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

Method
GET
HTTP Status
200
IP
216.73.216.50
Profiled on
Token
3477ad

Query Metrics

25 Database Queries
5 Different statements
47.48 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.76 ms 
SELECT DISTINCT r0_.id AS id_0 FROM `range` r0_ LIMIT 20
Parameters: 
[]
View formatted query    View runnable query    Explain query
2 0.72 ms 
SELECT r0_.name AS name_0, r0_.id AS id_1, r0_.family_id AS family_id_2 FROM `range` r0_ WHERE r0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"\x1EßK<JÒdÖ´h{ÌþÝÆ©"
  b"\x1E▀K<N;odÅ╦{╠■¦ã®"
  b"\x1EßK<WOm\x1C±,{ÌþÝÆ©"
  b"\x1EßK<ZÒ`H³¨{ÌþÝÆ©"
  b"\x1E▀K<[ÉcTür{╠■¦ã®"
  b"\x1EßK<`\x08g\x06…\x08{ÌþÝÆ©"
  b"\x1EßK<»\x13e¦¼Ê{ÌþÝÆ©"
  b"\x1EßK<Å\x00e¾’¬{ÌþÝÆ©"
  b"\x1EßK<̃oÊ©&{ÌþÝÆ©"
  b"\x1EßK<Ýal\f¢­{ÌþÝÆ©"
  b"\x1EßK<ÞŸa\x1Ešð{ÌþÝÆ©"
  b"\x1EßK=§Âh\x16–Ë{ÌþÝÆ©"
  b"\x1EßKC{|o&©ž{ÌþÝÆ©"
  b"\x1EßKJ¶º`d‹${ÌþÝÆ©"
  b"\x1EßKK±@nÞƒx{ÌþÝÆ©"
  b"\x1EßKLˆ5c6ˆÞ{ÌþÝÆ©"
  b"\x1EßKvPze\¯j{ÌþÝÆ©"
  b"\x1Eâ5ßsofدOO5\x07ƒ/Ã"
  b"\x1E▀KeNÅ`\x1Eàc{╠■¦ã®"
  b"\x1EßKkü|dZª‹{ÌþÝÆ©"
]
View formatted query    View runnable query    Explain query
3 0.52 ms 
SELECT count(r0_.id) AS sclr_0 FROM `range` r0_
Parameters: 
[]
View formatted query    View runnable query    Explain query
4 0.54 ms 
SELECT t0.name AS name_1, t0.id AS id_2 FROM family t0 WHERE t0.id = ?
Parameters: 
[
  b"\x1EßK<JÇc⎸{ÌþÝÆ©"
]
View formatted query    View runnable query    Explain query
5 0.77 ms 
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.range_id = ?
Parameters: 
[
  b"\x1EßK<JÒdÖ´h{ÌþÝÆ©"
]
View formatted query    View runnable query    Explain query
6 6.82 ms 
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.range_id = ?
Parameters: 
[
  b"\x1E▀K<N;odÅ╦{╠■¦ã®"
]
View formatted query    View runnable query    Explain query
7 2.43 ms 
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.range_id = ?
Parameters: 
[
  b"\x1EßK<WOm\x1C±,{ÌþÝÆ©"
]
View formatted query    View runnable query    Explain query
8 1.85 ms 
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.range_id = ?
Parameters: 
[
  b"\x1EßK<ZÒ`H³¨{ÌþÝÆ©"
]
View formatted query    View runnable query    Explain query
9 5.48 ms 
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.range_id = ?
Parameters: 
[
  b"\x1E▀K<[ÉcTür{╠■¦ã®"
]
View formatted query    View runnable query    Explain query
10 0.70 ms 
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.range_id = ?
Parameters: 
[
  b"\x1EßK<`\x08g\x06…\x08{ÌþÝÆ©"
]
View formatted query    View runnable query    Explain query
11 2.40 ms 
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.range_id = ?
Parameters: 
[
  b"\x1EßK<»\x13e¦¼Ê{ÌþÝÆ©"
]
View formatted query    View runnable query    Explain query
12 3.64 ms 
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.range_id = ?
Parameters: 
[
  b"\x1EßK<Å\x00e¾’¬{ÌþÝÆ©"
]
View formatted query    View runnable query    Explain query
13 1.23 ms 
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.range_id = ?
Parameters: 
[
  b"\x1EßK<̃oÊ©&{ÌþÝÆ©"
]
View formatted query    View runnable query    Explain query
14 2.82 ms 
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.range_id = ?
Parameters: 
[
  b"\x1EßK<Ýal\f¢­{ÌþÝÆ©"
]
View formatted query    View runnable query    Explain query
15 3.08 ms 
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.range_id = ?
Parameters: 
[
  b"\x1EßK<ÞŸa\x1Ešð{ÌþÝÆ©"
]
View formatted query    View runnable query    Explain query
16 1.33 ms 
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.range_id = ?
Parameters: 
[
  b"\x1EßK=§Âh\x16–Ë{ÌþÝÆ©"
]
View formatted query    View runnable query    Explain query
17 0.64 ms 
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.range_id = ?
Parameters: 
[
  b"\x1EßKC{|o&©ž{ÌþÝÆ©"
]
View formatted query    View runnable query    Explain query
18 0.69 ms 
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.range_id = ?
Parameters: 
[
  b"\x1EßKJ¶º`d‹${ÌþÝÆ©"
]
View formatted query    View runnable query    Explain query
19 0.64 ms 
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.range_id = ?
Parameters: 
[
  b"\x1EßKK±@nÞƒx{ÌþÝÆ©"
]
View formatted query    View runnable query    Explain query
20 3.25 ms 
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.range_id = ?
Parameters: 
[
  b"\x1EßKLˆ5c6ˆÞ{ÌþÝÆ©"
]
View formatted query    View runnable query    Explain query
21 0.55 ms 
SELECT t0.name AS name_1, t0.id AS id_2 FROM family t0 WHERE t0.id = ?
Parameters: 
[
  b"\x1EßKeLrb\x0E©Ê{ÌþÝÆ©"
]
View formatted query    View runnable query    Explain query
22 3.11 ms 
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.range_id = ?
Parameters: 
[
  b"\x1E▀KeNÅ`\x1Eàc{╠■¦ã®"
]
View formatted query    View runnable query    Explain query
23 1.53 ms 
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.range_id = ?
Parameters: 
[
  b"\x1EßKkü|dZª‹{ÌþÝÆ©"
]
View formatted query    View runnable query    Explain query
24 1.36 ms 
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.range_id = ?
Parameters: 
[
  b"\x1EßKvPze\¯j{ÌþÝÆ©"
]
View formatted query    View runnable query    Explain query
25 0.60 ms 
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.range_id = ?
Parameters: 
[
  b"\x1Eâ5ßsofدOO5\x07ƒ/Ã"
]
View formatted query    View runnable query    Explain query

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\Range No errors.
App\Entity\Family No errors.
App\Entity\Product No errors.
App\Entity\Serie No errors.
App\Entity\Provider No errors.
App\Entity\Category No errors.
App\Entity\ProductOption No errors.