http://afimes-crm.wdib.fr/admin?crudAction=index&crudControllerFqcn=App%5CController%5CAdmin%5CProviderCrudController

Query Metrics

23 Database Queries
4 Different statements
45.80 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
43.48 ms
(94.93%)
20
SELECT t0.name AS name_1, t0.options AS options_2, t0.description AS description_3, t0.required AS required_4, t0.reference_afimes AS reference_afimes_5, t0.provider_selling_price AS provider_selling_price_6, t0.provider_discount AS provider_discount_7, t0.recommended_margin_rate AS recommended_margin_rate_8, t0.comment AS comment_9, t0.unit AS unit_10, t0.additional_options AS additional_options_11, t0.pricing_last_update AS pricing_last_update_12, t0.document_id AS document_id_13, t0.id AS id_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.category_id AS category_id_17, t0.range_id AS range_id_18, t0.serie_id AS serie_id_19, t0.provider_id AS provider_id_20 FROM product t0 WHERE t0.provider_id = ?
Parameters:
[
  b"\x1EßK<JèbàŸL{ÌþÝÆ©"
]
0.93 ms
(2.02%)
1
SELECT count(p0_.id) AS sclr_0 FROM provider p0_
Parameters:
[]
0.71 ms
(1.54%)
1
SELECT p0_.name AS name_0, p0_.id AS id_1 FROM provider p0_ WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  b"\x1EßK<JèbàŸL{ÌþÝÆ©"
  b"\x1EßK<Zÿlæ„‚{ÌþÝÆ©"
  b"\x1EßK<[Àkb¨Ë{ÌþÝÆ©"
  b"\x1E▀K<`=nÆüÍ{╠■¦ã®"
  b"\x1EßK<¥Õn\x14¦({ÌþÝÆ©"
  b"\x1EßK<­°b~˜\t{ÌþÝÆ©"
  b"\x1E▀KJ\x19╣ffØ¡{╠■¦ã®"
  b"\x1EßKJ#‘az–¿{ÌþÝÆ©"
  b"\x1EßKJ5ëk"©Ÿ{ÌþÝÆ©"
  b"\x1EßKJ¹@oê³w{ÌþÝÆ©"
  b"\x1EßKK³×`v¹ {ÌþÝÆ©"
  b"\x1EßKKÐLn|ˆÀ{ÌþÝÆ©"
  b"\x1EßKLŠêcL²\x14{ÌþÝÆ©"
  b"\x1EßKN'\x07e:´h{ÌþÝÆ©"
  b"\x1E▀KN1paÌ╣ü{╠■¦ã®"
  b"\x1EßKN=ól\x08§V{ÌþÝÆ©"
  b"\x1EßKU\x7F\x19c˜™°{ÌþÝÆ©"
  b"\x1EßKWÈ{dÆœö{ÌþÝÆ©"
  b"\x1EßKayÞj象{ÌþÝÆ©"
  b"\x1EßKeRîd¢Œ±{ÌþÝÆ©"
]
0.69 ms
(1.50%)
1
SELECT DISTINCT p0_.id AS id_0 FROM provider p0_ LIMIT 20
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Provider No errors.
App\Entity\Family No errors.
App\Entity\Product No errors.
App\Entity\Category No errors.
App\Entity\Range No errors.
App\Entity\Serie No errors.
App\Entity\ProductOption No errors.