Query Metrics
32
Database Queries
19
Different statements
24.49 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.19 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.lft AS lft_4, t0.lvl AS lvl_5, t0.rgt AS rgt_6, t0.og_title AS og_title_7, t0.og_description AS og_description_8, t0.active AS active_9, t0.deleted AS deleted_10, t0.tree_root AS tree_root_11, t0.parent_id AS parent_id_12 FROM category t0 WHERE t0.id = ?
Parameters:
[
"62"
]
|
| 2 | 0.97 ms |
SELECT c0_.id AS id_0 FROM category c0_ WHERE c0_.lft >= ? AND c0_.rgt <= ?
Parameters:
[ 50 51 ] |
| 3 | 2.55 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.title AS title_1, c0_.perex AS perex_2, c0_.description AS description_3, c0_.website AS website_4, c0_.og_title AS og_title_5, c0_.og_description AS og_description_6, c0_.active AS active_7, c0_.deleted AS deleted_8 FROM catalogue_producer c0_ INNER JOIN catalogue_product c1_ ON c0_.id = c1_.producer_id AND c1_.type IN ('SIMPLE', 'VARIANT') INNER JOIN category_product c2_ ON c1_.id = c2_.product_id INNER JOIN category c3_ ON c2_.category_id = c3_.id WHERE c3_.id IN (?) ORDER BY c0_.title ASC
Parameters:
[
62
]
|
| 4 | 1.21 ms |
SELECT FLOOR(MIN(c0_.price)) AS sclr_0, CEIL(MAX(c0_.price)) AS sclr_1 FROM category c1_ INNER JOIN category_product c2_ ON c1_.id = c2_.category_id INNER JOIN catalogue_product c0_ ON c2_.product_id = c0_.id AND c0_.type IN ('SIMPLE', 'VARIANT') WHERE c1_.lft >= ? AND c1_.rgt <= ?
Parameters:
[ 50 51 ] |
| 5 | 0.69 ms |
SELECT c0_.id AS id_0 FROM category c0_ WHERE c0_.lft >= ? AND c0_.rgt <= ?
Parameters:
[ 50 51 ] |
| 6 | 1.18 ms |
SELECT count(DISTINCT c0_.id) AS sclr_0 FROM catalogue_product c0_ INNER JOIN category_product c1_ ON c0_.id = c1_.product_id INNER JOIN category c2_ ON c1_.category_id = c2_.id WHERE (c2_.id IN (?)) AND c0_.type IN ('SIMPLE', 'VARIANT')
Parameters:
[
62
]
|
| 7 | 0.70 ms |
SELECT DISTINCT c0_.id AS id_0 FROM catalogue_product c0_ INNER JOIN category_product c1_ ON c0_.id = c1_.product_id INNER JOIN category c2_ ON c1_.category_id = c2_.id WHERE (c2_.id IN (?)) AND c0_.type IN ('SIMPLE', 'VARIANT') LIMIT 12
Parameters:
[
62
]
|
| 8 | 1.00 ms |
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.perex AS perex_2, c0_.description AS description_3, c0_.price AS price_4, c0_.promotional_price AS promotional_price_5, c0_.og_title AS og_title_6, c0_.og_description AS og_description_7, c0_.active AS active_8, c0_.deleted AS deleted_9, c0_.type AS type_10, c0_.producer_id AS producer_id_11, c0_.availability_id AS availability_id_12, c0_.unit_id AS unit_id_13, c0_.vat_id AS vat_id_14, c0_.product_type_id AS product_type_id_15 FROM catalogue_product c0_ INNER JOIN category_product c1_ ON c0_.id = c1_.product_id INNER JOIN category c2_ ON c1_.category_id = c2_.id WHERE (c2_.id IN (?) AND c0_.id IN (?, ?, ?, ?, ?, ?)) AND c0_.type IN ('SIMPLE', 'VARIANT')
Parameters:
[ 62 434 435 436 440 442 443 ] |
| 9 | 0.41 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.rate AS rate_4, t0.active AS active_5, t0.main AS main_6, t0.deleted AS deleted_7 FROM setup_vat t0 WHERE t0.id IN (?)
Parameters:
[
1
]
|
| 10 | 0.48 ms |
SELECT t0.id AS id_1, t0.featured AS featured_2, t0.sort AS sort_3, t0.category_id AS category_id_4, t5.id AS id_6, t5.title AS title_7, t5.description AS description_8, t5.lft AS lft_9, t5.lvl AS lvl_10, t5.rgt AS rgt_11, t5.og_title AS og_title_12, t5.og_description AS og_description_13, t5.active AS active_14, t5.deleted AS deleted_15, t5.tree_root AS tree_root_16, t5.parent_id AS parent_id_17, t0.product_id AS product_id_18 FROM category_product t0 INNER JOIN category t5 ON t0.category_id = t5.id WHERE t0.product_id IN (?, ?, ?, ?, ?, ?)
Parameters:
[ 434 435 436 440 442 443 ] |
| 11 | 0.28 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.active AS active_3, t0.deleted AS deleted_4 FROM catalogue_product_type t0 WHERE t0.id IN (?)
Parameters:
[
1
]
|
| 12 | 0.44 ms |
SELECT t0.id AS id_1, t0.active AS active_2, t0.deleted AS deleted_3, t0.product_type_id AS product_type_id_4, t0.parameter_id AS parameter_id_5, t6.id AS id_7, t6.title AS title_8, t6.type AS type_9, t6.active AS active_10, t6.deleted AS deleted_11, t6.unit_id AS unit_id_12 FROM catalogue_product_type_parameter t0 INNER JOIN catalogue_parameter t6 ON t0.parameter_id = t6.id WHERE t0.product_type_id IN (?)
Parameters:
[
1
]
|
| 13 | 0.57 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.active AS active_3, t0.deleted AS deleted_4, t0.parameter_id AS parameter_id_5 FROM catalogue_parameter_value t0 WHERE t0.parameter_id IN (?)
Parameters:
[
1
]
|
| 14 | 1.79 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.title AS title_1, c0_.perex AS perex_2, c0_.description AS description_3, c0_.website AS website_4, c0_.og_title AS og_title_5, c0_.og_description AS og_description_6, c0_.active AS active_7, c0_.deleted AS deleted_8 FROM catalogue_producer c0_ INNER JOIN catalogue_product c1_ ON c0_.id = c1_.producer_id AND c1_.type IN ('SIMPLE', 'VARIANT') INNER JOIN category_product c2_ ON c1_.id = c2_.product_id INNER JOIN category c3_ ON c2_.category_id = c3_.id WHERE c3_.id IN (?) ORDER BY c0_.title ASC
Parameters:
[
62
]
|
| 15 | 0.52 ms |
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.description AS description_2, c0_.lft AS lft_3, c0_.lvl AS lvl_4, c0_.rgt AS rgt_5, c0_.og_title AS og_title_6, c0_.og_description AS og_description_7, c0_.active AS active_8, c0_.deleted AS deleted_9, c0_.tree_root AS tree_root_10, c0_.parent_id AS parent_id_11 FROM category c0_ WHERE c0_.lft <= 50 AND c0_.rgt >= 51 AND c0_.tree_root = ? ORDER BY c0_.lft ASC
Parameters:
[
2
]
|
| 16 | 0.59 ms |
SELECT COUNT(n0_.id) AS sclr_0 FROM navigation n0_ WHERE n0_.position = ?
Parameters:
[
"HEADER"
]
|
| 17 | 0.52 ms |
SELECT COUNT(n0_.id) AS sclr_0 FROM navigation n0_ WHERE n0_.position = ?
Parameters:
[
"TOP"
]
|
| 18 | 0.49 ms |
SELECT n0_.id AS id_0, n0_.position AS position_1, n0_.title AS title_2, n0_.active AS active_3, n0_.deleted AS deleted_4 FROM navigation n0_ WHERE n0_.position = ?
Parameters:
[
"TOP"
]
|
| 19 | 0.78 ms |
SELECT t0.id AS id_1, t0.sort AS sort_2, t0.deleted AS deleted_3, t0.navigation_id AS navigation_id_4, t5.id AS id_6, t5.position AS position_7, t5.title AS title_8, t5.active AS active_9, t5.deleted AS deleted_10, t0.category_id AS category_id_11, t12.id AS id_13, t12.title AS title_14, t12.description AS description_15, t12.lft AS lft_16, t12.lvl AS lvl_17, t12.rgt AS rgt_18, t12.og_title AS og_title_19, t12.og_description AS og_description_20, t12.active AS active_21, t12.deleted AS deleted_22, t12.tree_root AS tree_root_23, t12.parent_id AS parent_id_24 FROM navigation_category t0 INNER JOIN navigation t5 ON t0.navigation_id = t5.id INNER JOIN category t12 ON t0.category_id = t12.id WHERE t0.navigation_id IN (?)
Parameters:
[
1
]
|
| 20 | 0.67 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.lft AS lft_4, t0.lvl AS lvl_5, t0.rgt AS rgt_6, t0.og_title AS og_title_7, t0.og_description AS og_description_8, t0.active AS active_9, t0.deleted AS deleted_10, t0.tree_root AS tree_root_11, t0.parent_id AS parent_id_12 FROM category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
1
]
|
| 21 | 0.69 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.lft AS lft_4, t0.lvl AS lvl_5, t0.rgt AS rgt_6, t0.og_title AS og_title_7, t0.og_description AS og_description_8, t0.active AS active_9, t0.deleted AS deleted_10, t0.tree_root AS tree_root_11, t0.parent_id AS parent_id_12 FROM category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
2
]
|
| 22 | 0.77 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.lft AS lft_4, t0.lvl AS lvl_5, t0.rgt AS rgt_6, t0.og_title AS og_title_7, t0.og_description AS og_description_8, t0.active AS active_9, t0.deleted AS deleted_10, t0.tree_root AS tree_root_11, t0.parent_id AS parent_id_12 FROM category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
3
]
|
| 23 | 0.70 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.lft AS lft_4, t0.lvl AS lvl_5, t0.rgt AS rgt_6, t0.og_title AS og_title_7, t0.og_description AS og_description_8, t0.active AS active_9, t0.deleted AS deleted_10, t0.tree_root AS tree_root_11, t0.parent_id AS parent_id_12 FROM category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
4
]
|
| 24 | 0.71 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.lft AS lft_4, t0.lvl AS lvl_5, t0.rgt AS rgt_6, t0.og_title AS og_title_7, t0.og_description AS og_description_8, t0.active AS active_9, t0.deleted AS deleted_10, t0.tree_root AS tree_root_11, t0.parent_id AS parent_id_12 FROM category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
5
]
|
| 25 | 0.61 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.lft AS lft_4, t0.lvl AS lvl_5, t0.rgt AS rgt_6, t0.og_title AS og_title_7, t0.og_description AS og_description_8, t0.active AS active_9, t0.deleted AS deleted_10, t0.tree_root AS tree_root_11, t0.parent_id AS parent_id_12 FROM category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
62
]
|
| 26 | 0.99 ms |
SELECT t0.id AS id_1, t0.featured AS featured_2, t0.sort AS sort_3, t0.category_id AS category_id_4, t5.id AS id_6, t5.title AS title_7, t5.description AS description_8, t5.lft AS lft_9, t5.lvl AS lvl_10, t5.rgt AS rgt_11, t5.og_title AS og_title_12, t5.og_description AS og_description_13, t5.active AS active_14, t5.deleted AS deleted_15, t5.tree_root AS tree_root_16, t5.parent_id AS parent_id_17, t0.product_id AS product_id_18 FROM category_product t0 INNER JOIN category t5 ON t0.category_id = t5.id WHERE t0.category_id = ? ORDER BY t0.featured DESC, t0.sort ASC
Parameters:
[
62
]
|
| 27 | 0.80 ms |
SELECT t0.id AS id_1, t0.filepath AS filepath_2, t0.filename AS filename_3, t0.type AS type_4, t0.thumbnail_type AS thumbnail_type_5, t0.size AS size_6, t0.thumbnail AS thumbnail_7, t0.sort AS sort_8, t0.active AS active_9, t0.main AS main_10, t0.product_id AS product_id_11, t0.product_variant_id AS product_variant_id_12, t0.producer_id AS producer_id_13 FROM image t0 WHERE t0.product_id = ?
Parameters:
[
434
]
|
| 28 | 0.57 ms |
SELECT t0.id AS id_1, t0.filepath AS filepath_2, t0.filename AS filename_3, t0.type AS type_4, t0.thumbnail_type AS thumbnail_type_5, t0.size AS size_6, t0.thumbnail AS thumbnail_7, t0.sort AS sort_8, t0.active AS active_9, t0.main AS main_10, t0.product_id AS product_id_11, t0.product_variant_id AS product_variant_id_12, t0.producer_id AS producer_id_13 FROM image t0 WHERE t0.product_id = ?
Parameters:
[
435
]
|
| 29 | 0.40 ms |
SELECT t0.id AS id_1, t0.filepath AS filepath_2, t0.filename AS filename_3, t0.type AS type_4, t0.thumbnail_type AS thumbnail_type_5, t0.size AS size_6, t0.thumbnail AS thumbnail_7, t0.sort AS sort_8, t0.active AS active_9, t0.main AS main_10, t0.product_id AS product_id_11, t0.product_variant_id AS product_variant_id_12, t0.producer_id AS producer_id_13 FROM image t0 WHERE t0.product_id = ?
Parameters:
[
436
]
|
| 30 | 0.39 ms |
SELECT t0.id AS id_1, t0.filepath AS filepath_2, t0.filename AS filename_3, t0.type AS type_4, t0.thumbnail_type AS thumbnail_type_5, t0.size AS size_6, t0.thumbnail AS thumbnail_7, t0.sort AS sort_8, t0.active AS active_9, t0.main AS main_10, t0.product_id AS product_id_11, t0.product_variant_id AS product_variant_id_12, t0.producer_id AS producer_id_13 FROM image t0 WHERE t0.product_id = ?
Parameters:
[
440
]
|
| 31 | 0.39 ms |
SELECT t0.id AS id_1, t0.filepath AS filepath_2, t0.filename AS filename_3, t0.type AS type_4, t0.thumbnail_type AS thumbnail_type_5, t0.size AS size_6, t0.thumbnail AS thumbnail_7, t0.sort AS sort_8, t0.active AS active_9, t0.main AS main_10, t0.product_id AS product_id_11, t0.product_variant_id AS product_variant_id_12, t0.producer_id AS producer_id_13 FROM image t0 WHERE t0.product_id = ?
Parameters:
[
442
]
|
| 32 | 0.44 ms |
SELECT t0.id AS id_1, t0.filepath AS filepath_2, t0.filename AS filename_3, t0.type AS type_4, t0.thumbnail_type AS thumbnail_type_5, t0.size AS size_6, t0.thumbnail AS thumbnail_7, t0.sort AS sort_8, t0.active AS active_9, t0.main AS main_10, t0.product_id AS product_id_11, t0.product_variant_id AS product_variant_id_12, t0.producer_id AS producer_id_13 FROM image t0 WHERE t0.product_id = ?
Parameters:
[
443
]
|
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.