Query Metrics
25
Database Queries
3
Different statements
370.77 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 41.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.placement AS placement_3, t0.title AS title_4, t0.description AS description_5, t0.tier1maturin_fees_pc AS tier1maturin_fees_pc_6, t0.tier2maturin_fees_pc AS tier2maturin_fees_pc_7, t0.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_8, t0.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_9, t0.packing_fees_amount AS packing_fees_amount_10, t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_11, t0.meta_description AS meta_description_12, t0.is_displayed_for_buyer AS is_displayed_for_buyer_13, t0.sub_category_id AS sub_category_id_14, t0.image_id AS image_id_15, t0.banner_id AS banner_id_16 FROM category t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"epicerie"
]
|
| 2 | 30.38 ms |
SELECT c0_.id AS id_0, c0_.placement AS placement_1, c0_.name AS name_2 FROM category c0_ WHERE c0_.sub_category_id = ? AND c0_.placement > 0 ORDER BY c0_.placement ASC
Parameters:
[
33
]
|
| 3 | 9.05 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.placement AS placement_3, t0.title AS title_4, t0.description AS description_5, t0.tier1maturin_fees_pc AS tier1maturin_fees_pc_6, t0.tier2maturin_fees_pc AS tier2maturin_fees_pc_7, t0.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_8, t0.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_9, t0.packing_fees_amount AS packing_fees_amount_10, t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_11, t0.meta_description AS meta_description_12, t0.is_displayed_for_buyer AS is_displayed_for_buyer_13, t0.sub_category_id AS sub_category_id_14, t0.image_id AS image_id_15, t0.banner_id AS banner_id_16 FROM category t0 WHERE t0.sub_category_id = ?
Parameters:
[
33
]
|
| 4 | 20.34 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.placement AS placement_3, t0.title AS title_4, t0.description AS description_5, t0.tier1maturin_fees_pc AS tier1maturin_fees_pc_6, t0.tier2maturin_fees_pc AS tier2maturin_fees_pc_7, t0.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_8, t0.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_9, t0.packing_fees_amount AS packing_fees_amount_10, t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_11, t0.meta_description AS meta_description_12, t0.is_displayed_for_buyer AS is_displayed_for_buyer_13, t0.sub_category_id AS sub_category_id_14, t0.image_id AS image_id_15, t0.banner_id AS banner_id_16 FROM category t0 WHERE t0.sub_category_id = ?
Parameters:
[
45
]
|
| 5 | 10.61 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.placement AS placement_3, t0.title AS title_4, t0.description AS description_5, t0.tier1maturin_fees_pc AS tier1maturin_fees_pc_6, t0.tier2maturin_fees_pc AS tier2maturin_fees_pc_7, t0.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_8, t0.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_9, t0.packing_fees_amount AS packing_fees_amount_10, t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_11, t0.meta_description AS meta_description_12, t0.is_displayed_for_buyer AS is_displayed_for_buyer_13, t0.sub_category_id AS sub_category_id_14, t0.image_id AS image_id_15, t0.banner_id AS banner_id_16 FROM category t0 WHERE t0.sub_category_id = ?
Parameters:
[
80
]
|
| 6 | 10.14 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.placement AS placement_3, t0.title AS title_4, t0.description AS description_5, t0.tier1maturin_fees_pc AS tier1maturin_fees_pc_6, t0.tier2maturin_fees_pc AS tier2maturin_fees_pc_7, t0.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_8, t0.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_9, t0.packing_fees_amount AS packing_fees_amount_10, t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_11, t0.meta_description AS meta_description_12, t0.is_displayed_for_buyer AS is_displayed_for_buyer_13, t0.sub_category_id AS sub_category_id_14, t0.image_id AS image_id_15, t0.banner_id AS banner_id_16 FROM category t0 WHERE t0.sub_category_id = ?
Parameters:
[
81
]
|
| 7 | 8.65 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.placement AS placement_3, t0.title AS title_4, t0.description AS description_5, t0.tier1maturin_fees_pc AS tier1maturin_fees_pc_6, t0.tier2maturin_fees_pc AS tier2maturin_fees_pc_7, t0.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_8, t0.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_9, t0.packing_fees_amount AS packing_fees_amount_10, t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_11, t0.meta_description AS meta_description_12, t0.is_displayed_for_buyer AS is_displayed_for_buyer_13, t0.sub_category_id AS sub_category_id_14, t0.image_id AS image_id_15, t0.banner_id AS banner_id_16 FROM category t0 WHERE t0.sub_category_id = ?
Parameters:
[
82
]
|
| 8 | 14.98 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.placement AS placement_3, t0.title AS title_4, t0.description AS description_5, t0.tier1maturin_fees_pc AS tier1maturin_fees_pc_6, t0.tier2maturin_fees_pc AS tier2maturin_fees_pc_7, t0.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_8, t0.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_9, t0.packing_fees_amount AS packing_fees_amount_10, t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_11, t0.meta_description AS meta_description_12, t0.is_displayed_for_buyer AS is_displayed_for_buyer_13, t0.sub_category_id AS sub_category_id_14, t0.image_id AS image_id_15, t0.banner_id AS banner_id_16 FROM category t0 WHERE t0.sub_category_id = ?
Parameters:
[
316
]
|
| 9 | 26.68 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.placement AS placement_3, t0.title AS title_4, t0.description AS description_5, t0.tier1maturin_fees_pc AS tier1maturin_fees_pc_6, t0.tier2maturin_fees_pc AS tier2maturin_fees_pc_7, t0.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_8, t0.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_9, t0.packing_fees_amount AS packing_fees_amount_10, t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_11, t0.meta_description AS meta_description_12, t0.is_displayed_for_buyer AS is_displayed_for_buyer_13, t0.sub_category_id AS sub_category_id_14, t0.image_id AS image_id_15, t0.banner_id AS banner_id_16 FROM category t0 WHERE t0.sub_category_id = ?
Parameters:
[
83
]
|
| 10 | 27.67 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.placement AS placement_3, t0.title AS title_4, t0.description AS description_5, t0.tier1maturin_fees_pc AS tier1maturin_fees_pc_6, t0.tier2maturin_fees_pc AS tier2maturin_fees_pc_7, t0.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_8, t0.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_9, t0.packing_fees_amount AS packing_fees_amount_10, t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_11, t0.meta_description AS meta_description_12, t0.is_displayed_for_buyer AS is_displayed_for_buyer_13, t0.sub_category_id AS sub_category_id_14, t0.image_id AS image_id_15, t0.banner_id AS banner_id_16 FROM category t0 WHERE t0.sub_category_id = ?
Parameters:
[
84
]
|
| 11 | 12.80 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.placement AS placement_3, t0.title AS title_4, t0.description AS description_5, t0.tier1maturin_fees_pc AS tier1maturin_fees_pc_6, t0.tier2maturin_fees_pc AS tier2maturin_fees_pc_7, t0.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_8, t0.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_9, t0.packing_fees_amount AS packing_fees_amount_10, t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_11, t0.meta_description AS meta_description_12, t0.is_displayed_for_buyer AS is_displayed_for_buyer_13, t0.sub_category_id AS sub_category_id_14, t0.image_id AS image_id_15, t0.banner_id AS banner_id_16 FROM category t0 WHERE t0.sub_category_id = ?
Parameters:
[
327
]
|
| 12 | 13.75 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.placement AS placement_3, t0.title AS title_4, t0.description AS description_5, t0.tier1maturin_fees_pc AS tier1maturin_fees_pc_6, t0.tier2maturin_fees_pc AS tier2maturin_fees_pc_7, t0.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_8, t0.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_9, t0.packing_fees_amount AS packing_fees_amount_10, t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_11, t0.meta_description AS meta_description_12, t0.is_displayed_for_buyer AS is_displayed_for_buyer_13, t0.sub_category_id AS sub_category_id_14, t0.image_id AS image_id_15, t0.banner_id AS banner_id_16 FROM category t0 WHERE t0.sub_category_id = ?
Parameters:
[
331
]
|
| 13 | 8.11 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.placement AS placement_3, t0.title AS title_4, t0.description AS description_5, t0.tier1maturin_fees_pc AS tier1maturin_fees_pc_6, t0.tier2maturin_fees_pc AS tier2maturin_fees_pc_7, t0.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_8, t0.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_9, t0.packing_fees_amount AS packing_fees_amount_10, t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_11, t0.meta_description AS meta_description_12, t0.is_displayed_for_buyer AS is_displayed_for_buyer_13, t0.sub_category_id AS sub_category_id_14, t0.image_id AS image_id_15, t0.banner_id AS banner_id_16 FROM category t0 WHERE t0.sub_category_id = ?
Parameters:
[
86
]
|
| 14 | 8.70 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.placement AS placement_3, t0.title AS title_4, t0.description AS description_5, t0.tier1maturin_fees_pc AS tier1maturin_fees_pc_6, t0.tier2maturin_fees_pc AS tier2maturin_fees_pc_7, t0.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_8, t0.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_9, t0.packing_fees_amount AS packing_fees_amount_10, t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_11, t0.meta_description AS meta_description_12, t0.is_displayed_for_buyer AS is_displayed_for_buyer_13, t0.sub_category_id AS sub_category_id_14, t0.image_id AS image_id_15, t0.banner_id AS banner_id_16 FROM category t0 WHERE t0.sub_category_id = ?
Parameters:
[
313
]
|
| 15 | 17.13 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.placement AS placement_3, t0.title AS title_4, t0.description AS description_5, t0.tier1maturin_fees_pc AS tier1maturin_fees_pc_6, t0.tier2maturin_fees_pc AS tier2maturin_fees_pc_7, t0.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_8, t0.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_9, t0.packing_fees_amount AS packing_fees_amount_10, t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_11, t0.meta_description AS meta_description_12, t0.is_displayed_for_buyer AS is_displayed_for_buyer_13, t0.sub_category_id AS sub_category_id_14, t0.image_id AS image_id_15, t0.banner_id AS banner_id_16 FROM category t0 WHERE t0.sub_category_id = ?
Parameters:
[
314
]
|
| 16 | 15.95 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.placement AS placement_3, t0.title AS title_4, t0.description AS description_5, t0.tier1maturin_fees_pc AS tier1maturin_fees_pc_6, t0.tier2maturin_fees_pc AS tier2maturin_fees_pc_7, t0.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_8, t0.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_9, t0.packing_fees_amount AS packing_fees_amount_10, t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_11, t0.meta_description AS meta_description_12, t0.is_displayed_for_buyer AS is_displayed_for_buyer_13, t0.sub_category_id AS sub_category_id_14, t0.image_id AS image_id_15, t0.banner_id AS banner_id_16 FROM category t0 WHERE t0.sub_category_id = ?
Parameters:
[
315
]
|
| 17 | 12.40 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.placement AS placement_3, t0.title AS title_4, t0.description AS description_5, t0.tier1maturin_fees_pc AS tier1maturin_fees_pc_6, t0.tier2maturin_fees_pc AS tier2maturin_fees_pc_7, t0.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_8, t0.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_9, t0.packing_fees_amount AS packing_fees_amount_10, t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_11, t0.meta_description AS meta_description_12, t0.is_displayed_for_buyer AS is_displayed_for_buyer_13, t0.sub_category_id AS sub_category_id_14, t0.image_id AS image_id_15, t0.banner_id AS banner_id_16 FROM category t0 WHERE t0.sub_category_id = ?
Parameters:
[
317
]
|
| 18 | 19.61 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.placement AS placement_3, t0.title AS title_4, t0.description AS description_5, t0.tier1maturin_fees_pc AS tier1maturin_fees_pc_6, t0.tier2maturin_fees_pc AS tier2maturin_fees_pc_7, t0.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_8, t0.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_9, t0.packing_fees_amount AS packing_fees_amount_10, t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_11, t0.meta_description AS meta_description_12, t0.is_displayed_for_buyer AS is_displayed_for_buyer_13, t0.sub_category_id AS sub_category_id_14, t0.image_id AS image_id_15, t0.banner_id AS banner_id_16 FROM category t0 WHERE t0.sub_category_id = ?
Parameters:
[
90
]
|
| 19 | 7.30 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.placement AS placement_3, t0.title AS title_4, t0.description AS description_5, t0.tier1maturin_fees_pc AS tier1maturin_fees_pc_6, t0.tier2maturin_fees_pc AS tier2maturin_fees_pc_7, t0.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_8, t0.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_9, t0.packing_fees_amount AS packing_fees_amount_10, t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_11, t0.meta_description AS meta_description_12, t0.is_displayed_for_buyer AS is_displayed_for_buyer_13, t0.sub_category_id AS sub_category_id_14, t0.image_id AS image_id_15, t0.banner_id AS banner_id_16 FROM category t0 WHERE t0.sub_category_id = ?
Parameters:
[
326
]
|
| 20 | 7.99 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.placement AS placement_3, t0.title AS title_4, t0.description AS description_5, t0.tier1maturin_fees_pc AS tier1maturin_fees_pc_6, t0.tier2maturin_fees_pc AS tier2maturin_fees_pc_7, t0.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_8, t0.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_9, t0.packing_fees_amount AS packing_fees_amount_10, t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_11, t0.meta_description AS meta_description_12, t0.is_displayed_for_buyer AS is_displayed_for_buyer_13, t0.sub_category_id AS sub_category_id_14, t0.image_id AS image_id_15, t0.banner_id AS banner_id_16 FROM category t0 WHERE t0.sub_category_id = ?
Parameters:
[
320
]
|
| 21 | 17.48 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.placement AS placement_3, t0.title AS title_4, t0.description AS description_5, t0.tier1maturin_fees_pc AS tier1maturin_fees_pc_6, t0.tier2maturin_fees_pc AS tier2maturin_fees_pc_7, t0.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_8, t0.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_9, t0.packing_fees_amount AS packing_fees_amount_10, t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_11, t0.meta_description AS meta_description_12, t0.is_displayed_for_buyer AS is_displayed_for_buyer_13, t0.sub_category_id AS sub_category_id_14, t0.image_id AS image_id_15, t0.banner_id AS banner_id_16 FROM category t0 WHERE t0.sub_category_id = ?
Parameters:
[
318
]
|
| 22 | 11.18 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.placement AS placement_3, t0.title AS title_4, t0.description AS description_5, t0.tier1maturin_fees_pc AS tier1maturin_fees_pc_6, t0.tier2maturin_fees_pc AS tier2maturin_fees_pc_7, t0.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_8, t0.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_9, t0.packing_fees_amount AS packing_fees_amount_10, t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_11, t0.meta_description AS meta_description_12, t0.is_displayed_for_buyer AS is_displayed_for_buyer_13, t0.sub_category_id AS sub_category_id_14, t0.image_id AS image_id_15, t0.banner_id AS banner_id_16 FROM category t0 WHERE t0.sub_category_id = ?
Parameters:
[
321
]
|
| 23 | 3.52 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.placement AS placement_3, t0.title AS title_4, t0.description AS description_5, t0.tier1maturin_fees_pc AS tier1maturin_fees_pc_6, t0.tier2maturin_fees_pc AS tier2maturin_fees_pc_7, t0.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_8, t0.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_9, t0.packing_fees_amount AS packing_fees_amount_10, t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_11, t0.meta_description AS meta_description_12, t0.is_displayed_for_buyer AS is_displayed_for_buyer_13, t0.sub_category_id AS sub_category_id_14, t0.image_id AS image_id_15, t0.banner_id AS banner_id_16 FROM category t0 WHERE t0.sub_category_id = ?
Parameters:
[
322
]
|
| 24 | 5.87 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.placement AS placement_3, t0.title AS title_4, t0.description AS description_5, t0.tier1maturin_fees_pc AS tier1maturin_fees_pc_6, t0.tier2maturin_fees_pc AS tier2maturin_fees_pc_7, t0.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_8, t0.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_9, t0.packing_fees_amount AS packing_fees_amount_10, t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_11, t0.meta_description AS meta_description_12, t0.is_displayed_for_buyer AS is_displayed_for_buyer_13, t0.sub_category_id AS sub_category_id_14, t0.image_id AS image_id_15, t0.banner_id AS banner_id_16 FROM category t0 WHERE t0.sub_category_id = ?
Parameters:
[
324
]
|
| 25 | 9.30 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.placement AS placement_3, t0.title AS title_4, t0.description AS description_5, t0.tier1maturin_fees_pc AS tier1maturin_fees_pc_6, t0.tier2maturin_fees_pc AS tier2maturin_fees_pc_7, t0.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_8, t0.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_9, t0.packing_fees_amount AS packing_fees_amount_10, t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_11, t0.meta_description AS meta_description_12, t0.is_displayed_for_buyer AS is_displayed_for_buyer_13, t0.sub_category_id AS sub_category_id_14, t0.image_id AS image_id_15, t0.banner_id AS banner_id_16 FROM category t0 WHERE t0.sub_category_id = ?
Parameters:
[
339
]
|
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\User | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\Image | No errors. |
| App\Entity\Notification | No errors. |
| App\Entity\Message | No errors. |
| App\Entity\Cart | No errors. |
| App\Entity\Category | No errors. |