Query Metrics
30
Database Queries
3
Different statements
123.17 ms
Query time
0
Invalid entities
179
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.29 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.position AS position_16, t0.active AS active_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.brand_id AS brand_id_21 FROM product t0 WHERE t0.id = ?
Parameters:
[
24996
]
|
||||||||||||||||||||||||||||
| 2 | 0.19 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.position AS position_16, t0.active AS active_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.brand_id AS brand_id_21 FROM product t0 WHERE t0.id = ?
Parameters:
[
16830
]
|
||||||||||||||||||||||||||||
| 3 | 0.17 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.position AS position_16, t0.active AS active_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.brand_id AS brand_id_21 FROM product t0 WHERE t0.id = ?
Parameters:
[
25251
]
|
||||||||||||||||||||||||||||
| 4 | 0.17 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.position AS position_16, t0.active AS active_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.brand_id AS brand_id_21 FROM product t0 WHERE t0.id = ?
Parameters:
[
9590
]
|
||||||||||||||||||||||||||||
| 5 | 0.14 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.position AS position_16, t0.active AS active_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.brand_id AS brand_id_21 FROM product t0 WHERE t0.id = ?
Parameters:
[
11870
]
|
||||||||||||||||||||||||||||
| 6 | 0.14 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.position AS position_16, t0.active AS active_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.brand_id AS brand_id_21 FROM product t0 WHERE t0.id = ?
Parameters:
[
8834
]
|
||||||||||||||||||||||||||||
| 7 | 0.16 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.position AS position_16, t0.active AS active_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.brand_id AS brand_id_21 FROM product t0 WHERE t0.id = ?
Parameters:
[
2614
]
|
||||||||||||||||||||||||||||
| 8 | 0.15 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.position AS position_16, t0.active AS active_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.brand_id AS brand_id_21 FROM product t0 WHERE t0.id = ?
Parameters:
[
22842
]
|
||||||||||||||||||||||||||||
| 9 | 0.13 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.position AS position_16, t0.active AS active_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.brand_id AS brand_id_21 FROM product t0 WHERE t0.id = ?
Parameters:
[
21331
]
|
||||||||||||||||||||||||||||
| 10 | 0.12 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.position AS position_16, t0.active AS active_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.brand_id AS brand_id_21 FROM product t0 WHERE t0.id = ?
Parameters:
[
12361
]
|
||||||||||||||||||||||||||||
| 11 | 0.12 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.position AS position_16, t0.active AS active_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.brand_id AS brand_id_21 FROM product t0 WHERE t0.id = ?
Parameters:
[
11171
]
|
||||||||||||||||||||||||||||
| 12 | 0.13 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.position AS position_16, t0.active AS active_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.brand_id AS brand_id_21 FROM product t0 WHERE t0.id = ?
Parameters:
[
11393
]
|
||||||||||||||||||||||||||||
| 13 | 0.12 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.position AS position_16, t0.active AS active_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.brand_id AS brand_id_21 FROM product t0 WHERE t0.id = ?
Parameters:
[
24863
]
|
||||||||||||||||||||||||||||
| 14 | 0.11 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.position AS position_16, t0.active AS active_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.brand_id AS brand_id_21 FROM product t0 WHERE t0.id = ?
Parameters:
[
16345
]
|
||||||||||||||||||||||||||||
| 15 | 0.12 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.position AS position_16, t0.active AS active_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.brand_id AS brand_id_21 FROM product t0 WHERE t0.id = ?
Parameters:
[
17737
]
|
||||||||||||||||||||||||||||
| 16 | 0.15 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.position AS position_16, t0.active AS active_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.brand_id AS brand_id_21 FROM product t0 WHERE t0.id = ?
Parameters:
[
21814
]
|
||||||||||||||||||||||||||||
| 17 | 0.12 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.position AS position_16, t0.active AS active_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.brand_id AS brand_id_21 FROM product t0 WHERE t0.id = ?
Parameters:
[
18670
]
|
||||||||||||||||||||||||||||
| 18 | 0.11 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.position AS position_16, t0.active AS active_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.brand_id AS brand_id_21 FROM product t0 WHERE t0.id = ?
Parameters:
[
16224
]
|
||||||||||||||||||||||||||||
| 19 | 0.11 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.position AS position_16, t0.active AS active_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.brand_id AS brand_id_21 FROM product t0 WHERE t0.id = ?
Parameters:
[
14222
]
|
||||||||||||||||||||||||||||
| 20 | 0.11 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.position AS position_16, t0.active AS active_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.brand_id AS brand_id_21 FROM product t0 WHERE t0.id = ?
Parameters:
[
17973
]
|
||||||||||||||||||||||||||||
| 21 | 0.12 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.position AS position_16, t0.active AS active_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.brand_id AS brand_id_21 FROM product t0 WHERE t0.id = ?
Parameters:
[
12712
]
|
||||||||||||||||||||||||||||
| 22 | 0.12 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.position AS position_16, t0.active AS active_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.brand_id AS brand_id_21 FROM product t0 WHERE t0.id = ?
Parameters:
[
12782
]
|
||||||||||||||||||||||||||||
| 23 | 0.13 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.position AS position_16, t0.active AS active_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.brand_id AS brand_id_21 FROM product t0 WHERE t0.id = ?
Parameters:
[
13379
]
|
||||||||||||||||||||||||||||
| 24 | 0.11 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.position AS position_16, t0.active AS active_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.brand_id AS brand_id_21 FROM product t0 WHERE t0.id = ?
Parameters:
[
16143
]
|
||||||||||||||||||||||||||||
| 25 | 0.11 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.position AS position_16, t0.active AS active_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.brand_id AS brand_id_21 FROM product t0 WHERE t0.id = ?
Parameters:
[
27548
]
|
||||||||||||||||||||||||||||
| 26 | 0.14 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.position AS position_16, t0.active AS active_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.brand_id AS brand_id_21 FROM product t0 WHERE t0.id = ?
Parameters:
[
5091
]
|
||||||||||||||||||||||||||||
| 27 | 43.21 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.image AS image_3, c0_.active AS active_4, c0_.position AS position_5, c0_.meta_title AS meta_title_6, c0_.meta_description AS meta_description_7, c0_.meta_keywords AS meta_keywords_8, COUNT(p1_.id) AS sclr_9, c0_.parent_id AS parent_id_10 FROM category c0_ LEFT JOIN product_category p2_ ON c0_.id = p2_.category_id LEFT JOIN product p1_ ON p1_.id = p2_.product_id WHERE c0_.active = ? AND c0_.parent_id IS NULL GROUP BY c0_.id ORDER BY c0_.position ASC, c0_.name ASC
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
| 28 | 35.26 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.image AS image_3, c0_.active AS active_4, c0_.position AS position_5, c0_.meta_title AS meta_title_6, c0_.meta_description AS meta_description_7, c0_.meta_keywords AS meta_keywords_8, COUNT(p1_.id) AS sclr_9, c0_.parent_id AS parent_id_10 FROM category c0_ LEFT JOIN product_category p2_ ON c0_.id = p2_.category_id LEFT JOIN product p1_ ON p1_.id = p2_.product_id WHERE c0_.active = ? AND c0_.parent_id IS NULL GROUP BY c0_.id ORDER BY c0_.position ASC, c0_.name ASC
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
| 29 | 0.78 ms |
SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.position AS position_16, t0.active AS active_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.brand_id AS brand_id_21 FROM product t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY t0.position ASC, t0.name ASC
Parameters:
[ 21186 23199 24359 23115 18569 20852 7389 1805 20646 8892 16162 11474 23155 3724 25524 28137 22241 20524 24607 12875 9275 16256 12062 15513 12650 7226 4679 28133 28138 21608 2494 8406 13153 21704 10600 3253 20770 16356 1218 20640 2982 1919 22083 19660 2326 1310 9979 22099 2324 23609 16669 25326 2312 13746 1856 13729 8659 12255 16995 15633 13748 21748 19658 3351 20571 2942 20581 7027 20512 23700 5453 3662 ] |
||||||||||||||||||||||||||||
| 30 | 40.33 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.image AS image_3, c0_.active AS active_4, c0_.position AS position_5, c0_.meta_title AS meta_title_6, c0_.meta_description AS meta_description_7, c0_.meta_keywords AS meta_keywords_8, COUNT(p1_.id) AS sclr_9, c0_.parent_id AS parent_id_10 FROM category c0_ LEFT JOIN product_category p2_ ON c0_.id = p2_.category_id LEFT JOIN product p1_ ON p1_.id = p2_.product_id WHERE c0_.active = ? AND c0_.parent_id IS NULL GROUP BY c0_.id ORDER BY c0_.position ASC, c0_.name ASC
Parameters:
[
1
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Product | 98 |
| App\Entity\Brand | 76 |
| App\Entity\Category | 5 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Product | No errors. |
| App\Entity\Brand | No errors. |
| App\Entity\Category | No errors. |