Query Metrics
84
Database Queries
13
Different statements
44.69 ms
Query time
0
Invalid entities
117
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
18.15 ms (40.61%) |
56 |
SELECT t0.id AS id_1, t0.category_name AS category_name_2, t0.category_url AS category_url_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.frontend_description AS frontend_description_6, t0.meta_h1 AS meta_h1_7, t0.meta_h2 AS meta_h2_8, t0.custom_category_id AS custom_category_id_9, t0.lang_id AS lang_id_10 FROM custom_categories_lang t0 WHERE t0.custom_category_id = ?
Parameters:
[
84
]
|
||||||||||||||||||||||||||||||
|
10.45 ms (23.38%) |
2 |
SELECT DISTINCT p.*, pt.name AS translated_product_name, pt.description AS translated_product_description, ( SELECT c.color FROM colors AS c INNER JOIN products_skews AS ps ON ps.color_id = c.id AND ps.qty > 0 INNER JOIN skews_photos AS sp ON sp.product_id = ps.product_id AND sp.color_id = c.id WHERE ps.product_id = p.id AND ps.is_online = 1 LIMIT 1 ) AS color, ( SELECT GROUP_CONCAT(DISTINCT CONCAT(c.color, '|', cd.color_start, '|', IFNULL(cd.color_end, ''))) FROM colors AS c INNER JOIN products_skews AS ps ON ps.color_id = c.id AND ps.qty > 0 INNER JOIN colors_description AS cd ON cd.color = c.color INNER JOIN skews_photos AS sp ON sp.product_id = ps.product_id AND sp.color_id = c.id WHERE ps.product_id = p.id AND ps.is_online = 1 ) AS available_colors, ( SELECT COUNT(br.id) FROM custom_categories_products_br AS br WHERE br.product_id = p.id ) AS nr_associations, ( SELECT MAX(price) FROM prices AS pr WHERE pr.shipping_region_id = 1 AND pr.skew_id IN( SELECT ps.id FROM products_skews AS ps WHERE ps.product_id = p.id AND ps.qty > 0 AND ps.is_online = 1 ) ) AS max_price, ( SELECT MIN(price) FROM prices AS pr WHERE pr.shipping_region_id = 1 AND pr.skew_id IN( SELECT ps.id FROM products_skews AS ps WHERE ps.product_id = p.id AND ps.qty > 0 AND ps.is_online = 1 ) ) AS min_price, ( SELECT MAX(discounted_price) FROM prices AS pr WHERE pr.shipping_region_id = 1 AND (pr.discounted_price_from IS NULL OR pr.discounted_price_from <= '2025-10-27 17:01:35') AND (pr.discounted_price_to IS NULL OR pr.discounted_price_to >= '2025-10-27 17:01:35') AND pr.skew_id IN( SELECT ps.id FROM products_skews AS ps WHERE ps.product_id = p.id AND ps.qty > 0 AND ps.is_online = 1 ) ) AS max_discounted_price, ( SELECT MIN(discounted_price) FROM prices AS pr WHERE pr.shipping_region_id = 1 AND (pr.discounted_price_from IS NULL OR pr.discounted_price_from <= '2025-10-27 17:01:35') AND (pr.discounted_price_to IS NULL OR pr.discounted_price_to >= '2025-10-27 17:01:35') AND pr.skew_id IN( SELECT ps.id FROM products_skews AS ps WHERE ps.product_id = p.id AND ps.qty > 0 AND ps.is_online = 1 ) ) AS min_discounted_price, ( SELECT GREATEST(MAX(price), COALESCE(MAX(discounted_price),0)) FROM prices AS pr WHERE pr.skew_id IN( SELECT ps.id FROM products_skews AS ps WHERE ps.product_id = p.id AND ps.qty > 0 AND ps.is_online = 1 ) AND pr.shipping_region_id = 1 ) AS absolute_max_price, ( SELECT IF( pr.discounted_price_from IS NULL OR pr.discounted_price_from <= '2025-10-27 17:01:35' AND pr.discounted_price_to IS NULL OR pr.discounted_price_to >= '2025-10-27 17:01:35', LEAST(MIN(pr.price), COALESCE(MIN(pr.discounted_price),999999)), MIN(pr.price) ) FROM prices AS pr WHERE pr.skew_id IN( SELECT ps.id FROM products_skews AS ps WHERE ps.product_id = p.id AND ps.qty > 0 AND ps.is_online = 1 ) AND pr.shipping_region_id = 1 ) AS absolute_min_price, ( SELECT REPLACE(pdi.img_path, '400x570', '400x400_TE') FROM products_default_image AS pdi WHERE pdi.product_id = p.id ) AS default_path, ( SELECT sp.photo_path_reduced FROM skews_photos sp INNER JOIN products_skews AS ps on ps.product_id = sp.product_id AND ps.color_id = sp.color_id WHERE sp.product_id = p.id AND ps.is_online = 1 LIMIT 1 ) as path, ( SELECT SUM(qty) FROM products_skews AS ps WHERE ps.product_id = p.id ) AS sum_global_qty, ( SELECT SUM(qty) FROM products_skews AS ps WHERE ps.product_id = p.id AND ps.is_online = 1 ) AS sum_online_qty, ( SELECT l.label FROM labels_products_br AS lpb INNER JOIN labels AS l ON l.id = lpb.label_id WHERE lpb.product_id = p.id AND l.image IS NULL AND (l.valid_from IS NULL OR l.valid_from <= '2025-10-27 17:01:35') AND (l.valid_to IS NULL OR l.valid_to >= '2025-10-27 17:01:35') ORDER BY lpb.id DESC LIMIT 0,1 ) AS product_label, ( SELECT GROUP_CONCAT(l.image) FROM labels_products_br AS lpb INNER JOIN labels AS l ON l.id = lpb.label_id WHERE lpb.product_id = p.id AND (l.valid_from IS NULL OR l.valid_from <= '2025-10-27 17:01:35') AND (l.valid_to IS NULL OR l.valid_to >= '2025-10-27 17:01:35') ORDER BY lpb.id DESC ) AS product_icon_labels, ( SELECT GROUP_CONCAT(l.label) FROM labels_products_br AS lpb INNER JOIN labels AS l ON l.id = lpb.label_id WHERE lpb.product_id = p.id AND (l.valid_from IS NULL OR l.valid_from <= '2025-10-27 17:01:35') AND (l.valid_to IS NULL OR l.valid_to >= '2025-10-27 17:01:35') AND l.image is NOT NULL ORDER BY lpb.id DESC ) AS product_icon_labels_captions, ( SELECT l.exa_color FROM labels_products_br AS lpb INNER JOIN labels AS l ON l.id = lpb.label_id WHERE lpb.product_id = p.id AND l.image IS NULL AND (l.valid_from IS NULL OR l.valid_from <= '2025-10-27 17:01:35') AND (l.valid_to IS NULL OR l.valid_to >= '2025-10-27 17:01:35') ORDER BY lpb.id DESC LIMIT 0,1 ) AS product_label_color, ( SELECT l.font_color FROM labels_products_br AS lpb INNER JOIN labels AS l ON l.id = lpb.label_id WHERE lpb.product_id = p.id AND l.image IS NULL AND (l.valid_from IS NULL OR l.valid_from <= '2025-10-27 17:01:35') AND (l.valid_to IS NULL OR l.valid_to >= '2025-10-27 17:01:35') ORDER BY lpb.id DESC LIMIT 0,1 ) AS product_label_font_color, ( SELECT GROUP_CONCAT(pe.color_id) FROM products_exploded AS pe LEFT JOIN product_colors_order AS pco ON pco.product_id = pe.product_id AND pco.color_id = pe.color_id WHERE pe.product_id = p.id AND pe.custom_category_id = 109 ORDER BY pco.sequence ASC, pe.ordine ASC ) AS exploded_colors , cco.ordine FROM products AS p LEFT JOIN products_texts AS pt ON pt.product_id = p.id AND lang_id = 1 LEFT JOIN products_custom_category_order AS cco ON cco.product_id = p.id AND cco.custom_category_id IN (0, 109) WHERE p.is_online = 1 AND p.id IN ( SELECT product_id FROM custom_categories_products_br WHERE custom_category_id IN (0, 109,130,131,132,133,134,135) ) HAVING min_price > 0 AND color IS NOT NULL AND nr_associations > 0 AND sum_online_qty > 0 AND path != '' ORDER BY ordine ASC, absolute_min_price ASC LIMIT 0, 24
Parameters:
[] |
||||||||||||||||||||||||||||||
|
6.27 ms (14.03%) |
14 |
SELECT c0_.id AS id_0, c0_.custom_category AS custom_category_1, c0_.ordine AS ordine_2, c0_.is_online AS is_online_3, c0_.show_in_menu AS show_in_menu_4, c0_.parent_id AS parent_id_5 FROM custom_categories c0_ INNER JOIN custom_categories_lang c1_ ON (c1_.custom_category_id = c0_.id) WHERE c0_.is_online = 1 AND c0_.show_in_menu = 1 AND c0_.parent_id = ? AND c1_.lang_id = ? ORDER BY c0_.ordine ASC
Parameters:
[ 109 1 ]
|
||||||||||||||||||||||||||||||
|
3.77 ms (8.44%) |
1 |
SELECT DISTINCT p.*, pt.name AS translated_product_name, pt.description AS translated_product_description, ( SELECT c.color FROM colors AS c INNER JOIN products_skews AS ps ON ps.color_id = c.id AND ps.qty > 0 INNER JOIN skews_photos AS sp ON sp.product_id = ps.product_id AND sp.color_id = c.id WHERE ps.product_id = p.id AND ps.is_online = 1 LIMIT 1 ) AS color, ( SELECT GROUP_CONCAT(DISTINCT CONCAT(c.color, '|', cd.color_start, '|', IFNULL(cd.color_end, ''))) FROM colors AS c INNER JOIN products_skews AS ps ON ps.color_id = c.id AND ps.qty > 0 INNER JOIN colors_description AS cd ON cd.color = c.color INNER JOIN skews_photos AS sp ON sp.product_id = ps.product_id AND sp.color_id = c.id WHERE ps.product_id = p.id AND ps.is_online = 1 ) AS available_colors, ( SELECT COUNT(br.id) FROM custom_categories_products_br AS br WHERE br.product_id = p.id ) AS nr_associations, ( SELECT MAX(price) FROM prices AS pr WHERE pr.shipping_region_id = 1 AND pr.skew_id IN( SELECT ps.id FROM products_skews AS ps WHERE ps.product_id = p.id AND ps.qty > 0 AND ps.is_online = 1 ) ) AS max_price, ( SELECT MIN(price) FROM prices AS pr WHERE pr.shipping_region_id = 1 AND pr.skew_id IN( SELECT ps.id FROM products_skews AS ps WHERE ps.product_id = p.id AND ps.qty > 0 AND ps.is_online = 1 ) ) AS min_price, ( SELECT MAX(discounted_price) FROM prices AS pr WHERE pr.shipping_region_id = 1 AND (pr.discounted_price_from IS NULL OR pr.discounted_price_from <= '2025-10-27 17:01:35') AND (pr.discounted_price_to IS NULL OR pr.discounted_price_to >= '2025-10-27 17:01:35') AND pr.skew_id IN( SELECT ps.id FROM products_skews AS ps WHERE ps.product_id = p.id AND ps.qty > 0 AND ps.is_online = 1 ) ) AS max_discounted_price, ( SELECT MIN(discounted_price) FROM prices AS pr WHERE pr.shipping_region_id = 1 AND (pr.discounted_price_from IS NULL OR pr.discounted_price_from <= '2025-10-27 17:01:35') AND (pr.discounted_price_to IS NULL OR pr.discounted_price_to >= '2025-10-27 17:01:35') AND pr.skew_id IN( SELECT ps.id FROM products_skews AS ps WHERE ps.product_id = p.id AND ps.qty > 0 AND ps.is_online = 1 ) ) AS min_discounted_price, ( SELECT GREATEST(MAX(price), COALESCE(MAX(discounted_price),0)) FROM prices AS pr WHERE pr.skew_id IN( SELECT ps.id FROM products_skews AS ps WHERE ps.product_id = p.id AND ps.qty > 0 AND ps.is_online = 1 ) AND pr.shipping_region_id = 1 ) AS absolute_max_price, ( SELECT IF( pr.discounted_price_from IS NULL OR pr.discounted_price_from <= '2025-10-27 17:01:35' AND pr.discounted_price_to IS NULL OR pr.discounted_price_to >= '2025-10-27 17:01:35', LEAST(MIN(pr.price), COALESCE(MIN(pr.discounted_price),999999)), MIN(pr.price) ) FROM prices AS pr WHERE pr.skew_id IN( SELECT ps.id FROM products_skews AS ps WHERE ps.product_id = p.id AND ps.qty > 0 AND ps.is_online = 1 ) AND pr.shipping_region_id = 1 ) AS absolute_min_price, ( SELECT REPLACE(pdi.img_path, '400x570', '400x400_TE') FROM products_default_image AS pdi WHERE pdi.product_id = p.id ) AS default_path, ( SELECT sp.photo_path_reduced FROM skews_photos sp INNER JOIN products_skews AS ps on ps.product_id = sp.product_id AND ps.color_id = sp.color_id WHERE sp.product_id = p.id AND ps.is_online = 1 LIMIT 1 ) as path, ( SELECT SUM(qty) FROM products_skews AS ps WHERE ps.product_id = p.id ) AS sum_global_qty, ( SELECT SUM(qty) FROM products_skews AS ps WHERE ps.product_id = p.id AND ps.is_online = 1 ) AS sum_online_qty, ( SELECT l.label FROM labels_products_br AS lpb INNER JOIN labels AS l ON l.id = lpb.label_id WHERE lpb.product_id = p.id AND l.image IS NULL AND (l.valid_from IS NULL OR l.valid_from <= '2025-10-27 17:01:35') AND (l.valid_to IS NULL OR l.valid_to >= '2025-10-27 17:01:35') ORDER BY lpb.id DESC LIMIT 0,1 ) AS product_label, ( SELECT GROUP_CONCAT(l.image) FROM labels_products_br AS lpb INNER JOIN labels AS l ON l.id = lpb.label_id WHERE lpb.product_id = p.id AND (l.valid_from IS NULL OR l.valid_from <= '2025-10-27 17:01:35') AND (l.valid_to IS NULL OR l.valid_to >= '2025-10-27 17:01:35') ORDER BY lpb.id DESC ) AS product_icon_labels, ( SELECT GROUP_CONCAT(l.label) FROM labels_products_br AS lpb INNER JOIN labels AS l ON l.id = lpb.label_id WHERE lpb.product_id = p.id AND (l.valid_from IS NULL OR l.valid_from <= '2025-10-27 17:01:35') AND (l.valid_to IS NULL OR l.valid_to >= '2025-10-27 17:01:35') AND l.image is NOT NULL ORDER BY lpb.id DESC ) AS product_icon_labels_captions, ( SELECT l.exa_color FROM labels_products_br AS lpb INNER JOIN labels AS l ON l.id = lpb.label_id WHERE lpb.product_id = p.id AND l.image IS NULL AND (l.valid_from IS NULL OR l.valid_from <= '2025-10-27 17:01:35') AND (l.valid_to IS NULL OR l.valid_to >= '2025-10-27 17:01:35') ORDER BY lpb.id DESC LIMIT 0,1 ) AS product_label_color, ( SELECT l.font_color FROM labels_products_br AS lpb INNER JOIN labels AS l ON l.id = lpb.label_id WHERE lpb.product_id = p.id AND l.image IS NULL AND (l.valid_from IS NULL OR l.valid_from <= '2025-10-27 17:01:35') AND (l.valid_to IS NULL OR l.valid_to >= '2025-10-27 17:01:35') ORDER BY lpb.id DESC LIMIT 0,1 ) AS product_label_font_color, ( SELECT GROUP_CONCAT(pe.color_id) FROM products_exploded AS pe LEFT JOIN product_colors_order AS pco ON pco.product_id = pe.product_id AND pco.color_id = pe.color_id WHERE pe.product_id = p.id AND pe.custom_category_id = 109 ORDER BY pco.sequence ASC, pe.ordine ASC ) AS exploded_colors , cco.ordine FROM products AS p LEFT JOIN products_texts AS pt ON pt.product_id = p.id AND lang_id = 1 LEFT JOIN products_custom_category_order AS cco ON cco.product_id = p.id AND cco.custom_category_id IN (0, 109) WHERE p.is_online = 1 AND p.id IN ( SELECT product_id FROM custom_categories_products_br WHERE custom_category_id IN (0, 109,130,131,132,133,134,135) ) HAVING min_price > 0 AND color IS NOT NULL AND nr_associations > 0 AND sum_online_qty > 0 AND path != '' ORDER BY ordine ASC, absolute_min_price ASC
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.33 ms (2.98%) |
3 |
SELECT t0.id AS id_1, t0.lang AS lang_2, t0.label AS label_3 FROM langs t0 WHERE t0.lang = ? LIMIT 1
Parameters:
[
"it"
]
|
||||||||||||||||||||||||||||||
|
0.77 ms (1.71%) |
1 |
SELECT c0_.id AS id_0, c0_.custom_category AS custom_category_1, c0_.ordine AS ordine_2, c0_.is_online AS is_online_3, c0_.show_in_menu AS show_in_menu_4, c1_.category_name AS category_name_5, c1_.category_url AS category_url_6, c1_.meta_title AS meta_title_7, c1_.meta_description AS meta_description_8, c1_.frontend_description AS frontend_description_9, c1_.meta_h1 AS meta_h1_10, c1_.meta_h2 AS meta_h2_11, c0_.parent_id AS parent_id_12 FROM custom_categories c0_ INNER JOIN custom_categories_lang c1_ ON (c1_.custom_category_id = c0_.id) WHERE c1_.category_url = ? AND c1_.lang_id = ? AND c0_.parent_id IS NULL
Parameters:
[ "bambino" 1 ]
|
||||||||||||||||||||||||||||||
|
0.76 ms (1.71%) |
1 |
SELECT c0_.id AS id_0, c0_.custom_category AS custom_category_1, c0_.ordine AS ordine_2, c0_.is_online AS is_online_3, c0_.show_in_menu AS show_in_menu_4, c1_.category_name AS category_name_5, c1_.category_url AS category_url_6, c1_.meta_title AS meta_title_7, c1_.meta_description AS meta_description_8, c1_.frontend_description AS frontend_description_9, c1_.meta_h1 AS meta_h1_10, c1_.meta_h2 AS meta_h2_11, c0_.parent_id AS parent_id_12 FROM custom_categories c0_ INNER JOIN custom_categories_lang c1_ ON (c1_.custom_category_id = c0_.id) WHERE c1_.category_url = ? AND c1_.lang_id = ? AND c0_.parent_id = ?
Parameters:
[ "footwear" 1 89 ]
|
||||||||||||||||||||||||||||||
|
0.64 ms (1.44%) |
1 |
SELECT COUNT(l0_.id) AS sclr_0 FROM listini l0_
Parameters:
[] |
||||||||||||||||||||||||||||||
|
0.63 ms (1.42%) |
1 |
SELECT s0_.id AS id_0, s0_.type AS type_1, s0_.text AS text_2, s0_.exa_color AS exa_color_3, s0_.font_color AS font_color_4, s0_.valid_from AS valid_from_5, s0_.valid_to AS valid_to_6 FROM static_texts s0_ INNER JOIN static_text_langs s1_ ON (s0_.id = s1_.static_text_id) WHERE s0_.type = ? AND s1_.lang_id = ? AND (s0_.valid_from IS NULL OR s0_.valid_from <= ?) AND (s0_.valid_to IS NULL OR s0_.valid_to >= ?) ORDER BY s0_.id DESC LIMIT 1
Parameters:
[ "header" 1 "2025-10-27 17:01:35" "2025-10-27 17:01:35" ] |
||||||||||||||||||||||||||||||
|
0.55 ms (1.23%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.symbol AS symbol_3, t0.label AS label_4 FROM currencies t0 WHERE t0.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||
|
0.53 ms (1.19%) |
1 |
SELECT t0.id AS id_1, t0.region_name AS region_name_2, t0.region_code AS region_code_3, t0.ordine AS ordine_4, t0.lang_id AS lang_id_5, t0.currency_id AS currency_id_6, t0.listino_id AS listino_id_7 FROM shipping_regions t0 WHERE t0.region_code = ? LIMIT 1
Parameters:
[
"it"
]
|
||||||||||||||||||||||||||||||
|
0.43 ms (0.95%) |
1 |
SELECT c0_.id AS id_0, c0_.custom_category AS custom_category_1, c0_.ordine AS ordine_2, c0_.is_online AS is_online_3, c0_.show_in_menu AS show_in_menu_4, c0_.parent_id AS parent_id_5 FROM custom_categories c0_ INNER JOIN custom_categories_lang c1_ ON (c1_.custom_category_id = c0_.id) WHERE c0_.is_online = 1 AND c0_.show_in_menu = 1 AND c0_.parent_id IS NULL AND c1_.lang_id = ? ORDER BY c0_.ordine ASC
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||
|
0.41 ms (0.92%) |
1 |
SELECT t0.id AS id_1, t0.listino AS listino_2, t0.currency_id AS currency_id_3 FROM listini t0 WHERE t0.listino = ? LIMIT 1
Parameters:
[
"it"
]
|
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\CustomCategory | 56 |
| App\Entity\CustomCategoriesLang | 56 |
| App\Entity\Language | 1 |
| App\Entity\Listini | 1 |
| App\Entity\Currencies | 1 |
| App\Entity\ShippingRegion | 1 |
| App\Entity\StaticTexts | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Listini | No errors. |
| App\Entity\Language | No errors. |
| App\Entity\Currencies | No errors. |
| App\Entity\ShippingRegion | No errors. |
| App\Entity\CustomCategory | No errors. |
| App\Entity\CustomCategoriesLang | No errors. |
| App\Entity\CustomCategoriesProductsBridge | No errors. |
| App\Entity\StaticTexts | No errors. |
| App\Entity\StaticTextLangs | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\ProductsFeatures | No errors. |
| App\Entity\ProductsSkew | No errors. |
| App\Entity\Linea | No errors. |
| App\Entity\ProductDefaultImage | No errors. |
| App\Entity\ProductsExploded | No errors. |
| App\Entity\SkewPhotos | No errors. |
| App\Entity\ProductsRelated | No errors. |