http://afimes-crm.wdib.fr/admin?crudAction=index&crudControllerFqcn=App%5CController%5CAdmin%5CSerieCrudController&page=8&sort%5Bname%5D=ASC

Method
GET
HTTP Status
200
IP
74.7.242.61
Profiled on
Token
b16e77

Query Metrics

24 Database Queries
5 Different statements
17.50 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.97 ms 
SELECT DISTINCT s0_.id AS id_0, s0_.name AS name_1 FROM serie s0_ ORDER BY s0_.name ASC LIMIT 20 OFFSET 140
Parameters: 
[]
View formatted query    View runnable query    Explain query
2 0.54 ms 
SELECT s0_.name AS name_0, s0_.id AS id_1, s0_.family_id AS family_id_2 FROM serie s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.name ASC
Parameters: 
[
  b"\x1EßK<t¹k2žÓ{ÌþÝÆ©"
  b"\x1EßK<‰ji<¥\{ÌþÝÆ©"
  b"\x1EßK<£Eo–ª°{ÌþÝÆ©"
  b"\x1EßKQÉŸj.¯\x1F{ÌþÝÆ©"
  b"\x1EÕõÖJ▓b─æÐ)¨░Å■Ð"
  b"\x1EßK<`#f\x14¬¤{ÌþÝÆ©"
  b"\x1EßKE­Zo槒{ÌþÝÆ©"
  b"\x1EßK<[©c\x04›\r{ÌþÝÆ©"
  b"\x1EßKoˆ?hh®p{ÌþÝÆ©"
  b"\x1EßKur°g²¤É{ÌþÝÆ©"
  b"\x1EßKu\x7F`g(¥•{ÌþÝÆ©"
  b"\x1E▀KJ\x18Ça┤Ø´{╠■¦ã®"
  b"\x1EßKcZRfd¢\t{ÌþÝÆ©"
  b"\x1EßKE±Òc:€Ò{ÌþÝÆ©"
  b"\x1EßKc)üh\x02Œ {ÌþÝÆ©"
  b"\x1EßK<R°`@± {ÌþÝÆ©"
  b"\x1EßK<M>d\x04¥Í{ÌþÝÆ©"
  b"\x1EßK<U\fT£³{ÌþÝÆ©"
  b"\x1E▀K<M¼nÛÅÿ{╠■¦ã®"
  b"\x1EßKJ·þf–œ\x06{ÌþÝÆ©"
]
View formatted query    View runnable query    Explain query
3 0.63 ms 
SELECT count(s0_.id) AS sclr_0 FROM serie s0_
Parameters: 
[]
View formatted query    View runnable query    Explain query
4 0.55 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 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.serie_id = ?
Parameters: 
[
  b"\x1EßK<t¹k2žÓ{ÌþÝÆ©"
]
View formatted query    View runnable query    Explain query
6 1.09 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.serie_id = ?
Parameters: 
[
  b"\x1EßK<‰ji<¥\{ÌþÝÆ©"
]
View formatted query    View runnable query    Explain query
7 0.73 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.serie_id = ?
Parameters: 
[
  b"\x1EßK<£Eo–ª°{ÌþÝÆ©"
]
View formatted query    View runnable query    Explain query
8 0.89 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.serie_id = ?
Parameters: 
[
  b"\x1EßKQÉŸj.¯\x1F{ÌþÝÆ©"
]
View formatted query    View runnable query    Explain query
9 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.serie_id = ?
Parameters: 
[
  b"\x1EÕõÖJ▓b─æÐ)¨░Å■Ð"
]
View formatted query    View runnable query    Explain query
10 0.68 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.serie_id = ?
Parameters: 
[
  b"\x1EßK<`#f\x14¬¤{ÌþÝÆ©"
]
View formatted query    View runnable query    Explain query
11 0.56 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.serie_id = ?
Parameters: 
[
  b"\x1EßKE­Zo槒{ÌþÝÆ©"
]
View formatted query    View runnable query    Explain query
12 0.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.serie_id = ?
Parameters: 
[
  b"\x1EßK<[©c\x04›\r{ÌþÝÆ©"
]
View formatted query    View runnable query    Explain query
13 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.serie_id = ?
Parameters: 
[
  b"\x1EßKoˆ?hh®p{ÌþÝÆ©"
]
View formatted query    View runnable query    Explain query
14 0.57 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.serie_id = ?
Parameters: 
[
  b"\x1EßKur°g²¤É{ÌþÝÆ©"
]
View formatted query    View runnable query    Explain query
15 0.58 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.serie_id = ?
Parameters: 
[
  b"\x1EßKu\x7F`g(¥•{ÌþÝÆ©"
]
View formatted query    View runnable query    Explain query
16 0.58 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.serie_id = ?
Parameters: 
[
  b"\x1E▀KJ\x18Ça┤Ø´{╠■¦ã®"
]
View formatted query    View runnable query    Explain query
17 1.27 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.serie_id = ?
Parameters: 
[
  b"\x1EßKcZRfd¢\t{ÌþÝÆ©"
]
View formatted query    View runnable query    Explain query
18 0.66 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.serie_id = ?
Parameters: 
[
  b"\x1EßKE±Òc:€Ò{ÌþÝÆ©"
]
View formatted query    View runnable query    Explain query
19 0.65 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.serie_id = ?
Parameters: 
[
  b"\x1EßKc)üh\x02Œ {ÌþÝÆ©"
]
View formatted query    View runnable query    Explain query
20 0.56 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.serie_id = ?
Parameters: 
[
  b"\x1EßK<R°`@± {ÌþÝÆ©"
]
View formatted query    View runnable query    Explain query
21 0.65 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.serie_id = ?
Parameters: 
[
  b"\x1EßK<M>d\x04¥Í{ÌþÝÆ©"
]
View formatted query    View runnable query    Explain query
22 0.57 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.serie_id = ?
Parameters: 
[
  b"\x1EßK<U\fT£³{ÌþÝÆ©"
]
View formatted query    View runnable query    Explain query
23 0.65 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.serie_id = ?
Parameters: 
[
  b"\x1E▀K<M¼nÛÅÿ{╠■¦ã®"
]
View formatted query    View runnable query    Explain query
24 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.serie_id = ?
Parameters: 
[
  b"\x1EßKJ·þf–œ\x06{ÌþÝÆ©"
]
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\Serie No errors.
App\Entity\Family No errors.
App\Entity\Product No errors.
App\Entity\Range No errors.
App\Entity\Provider No errors.
App\Entity\Category No errors.
App\Entity\ProductOption No errors.