GET http://caterpillar-interno.inol3.com/it/caterpillar-shop/donna/scarpe

Response
200 OK
IP
192.168.0.116
Profiled on
Token
890631

Query Metrics

124 Database Queries
25 Different statements
62.87 ms Query time
0 Invalid entities
100 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
10.40 ms
(16.54%) 		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(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
                ) 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-12-06 02:51:44')
                  AND (pr.discounted_price_to IS NULL OR pr.discounted_price_to >= '2025-12-06 02:51:44')
                  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-12-06 02:51:44')
                  AND (pr.discounted_price_to IS NULL OR pr.discounted_price_to >= '2025-12-06 02:51:44')
                  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.currency_id = 1
                ) AS absolute_max_price,
                (
                    SELECT IF(
                        pr.discounted_price_from IS NULL OR pr.discounted_price_from <= '2025-12-06 02:51:44'
                        AND
                        pr.discounted_price_to IS NULL OR pr.discounted_price_to >= '2025-12-06 02:51:44',

                        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.currency_id = 1

                    /*SELECT LEAST(MIN(price), COALESCE(MIN(discounted_price),999999))
                    FROM prices 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.currency_id = 1*/
                ) AS absolute_min_price,
                (
                    SELECT REPLACE(pdi.img_path, '400x570', '400x400') 
                    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-12-06 02:51:44')
                    AND (l.valid_to IS NULL OR l.valid_to >= '2025-12-06 02:51:44')
                    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-12-06 02:51:44')
                    AND (l.valid_to IS NULL OR l.valid_to >= '2025-12-06 02:51:44')
                    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-12-06 02:51:44')
                    AND (l.valid_to IS NULL OR l.valid_to >= '2025-12-06 02:51:44')
                    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-12-06 02:51:44')
                    AND (l.valid_to IS NULL OR l.valid_to >= '2025-12-06 02:51:44')
                    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-12-06 02:51:44')
                    AND (l.valid_to IS NULL OR l.valid_to >= '2025-12-06 02:51:44')
                    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 = 7 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, 7) WHERE p.is_online = 1 AND p.id IN (
                        SELECT product_id
                        FROM custom_categories_products_br
                        WHERE custom_category_id IN (0, 7)
                    ) 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, 8
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
9.43 ms
(15.01%) 		40 
SELECT t0.id AS id_1, t0.color AS color_2, t0.description AS description_3 FROM colors_description t0 WHERE t0.color = ? LIMIT 1
Parameters: 
[
  "P110626"
]
View formatted query    View runnable query    Explain query    View query backtrace
9.38 ms
(14.92%) 		40 
SELECT t0.id AS id_1, t0.sku_code AS sku_code_2, t0.barcode AS barcode_3, t0.qty AS qty_4, t0.is_qty_blocked AS is_qty_blocked_5, t0.is_future AS is_future_6, t0.sent_to_splio AS sent_to_splio_7, t0.is_online AS is_online_8, t0.product_id AS product_id_9, t0.color_id AS color_id_10, t0.size_id AS size_id_11 FROM products_skews t0 WHERE t0.id = ?
Parameters: 
[
  716174
]
View formatted query    View runnable query    Explain query    View query backtrace
5.35 ms
(8.52%) 		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(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
                ) 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-12-06 02:51:45')
                  AND (pr.discounted_price_to IS NULL OR pr.discounted_price_to >= '2025-12-06 02:51:45')
                  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-12-06 02:51:45')
                  AND (pr.discounted_price_to IS NULL OR pr.discounted_price_to >= '2025-12-06 02:51:45')
                  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.currency_id = 1
                ) AS absolute_max_price,
                (
                    SELECT IF(
                        pr.discounted_price_from IS NULL OR pr.discounted_price_from <= '2025-12-06 02:51:45'
                        AND
                        pr.discounted_price_to IS NULL OR pr.discounted_price_to >= '2025-12-06 02:51:45',

                        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.currency_id = 1

                    /*SELECT LEAST(MIN(price), COALESCE(MIN(discounted_price),999999))
                    FROM prices 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.currency_id = 1*/
                ) AS absolute_min_price,
                (
                    SELECT REPLACE(pdi.img_path, '400x570', '400x400') 
                    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-12-06 02:51:45')
                    AND (l.valid_to IS NULL OR l.valid_to >= '2025-12-06 02:51:45')
                    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-12-06 02:51:45')
                    AND (l.valid_to IS NULL OR l.valid_to >= '2025-12-06 02:51:45')
                    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-12-06 02:51:45')
                    AND (l.valid_to IS NULL OR l.valid_to >= '2025-12-06 02:51:45')
                    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-12-06 02:51:45')
                    AND (l.valid_to IS NULL OR l.valid_to >= '2025-12-06 02:51:45')
                    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-12-06 02:51:45')
                    AND (l.valid_to IS NULL OR l.valid_to >= '2025-12-06 02:51:45')
                    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 = 7 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, 7) WHERE p.is_online = 1 AND p.id IN (
                        SELECT product_id
                        FROM custom_categories_products_br
                        WHERE custom_category_id IN (0, 7)
                    ) 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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
4.67 ms
(7.43%) 		1 
SELECT ps.*, c.color, s.size, sc.conversion, pr.price, pr.discounted_price, pr.lowest_price, pr.discount_percentage, pr.discounted_price_from, pr.discounted_price_to,
                (
                    SELECT
                       CONVERT(GROUP_CONCAT(
                           CONCAT_WS(
                                '|',
                                phototype_id, phototype_name, photo_path, photo_path_reduced
                            )
                       ) USING utf8mb4)
                    FROM skews_photos sp
                    WHERE sp.product_id = ps.product_id
                    AND sp.color_id = ps.color_id
                    AND season_id IN (
                        SELECT MAX(season_id)
                            FROM skews_photos
                            WHERE product_id = ps.product_id
                            AND color_id = ps.color_id
                    )
                    ORDER BY phototype_id ASC
                ) AS path
                FROM products_skews AS ps
                INNER JOIN colors AS c ON c.id = ps.color_id
                INNER JOIN sizes AS s ON s.id = ps.size_id
                LEFT JOIN size_conversion AS sc ON sc.size = s.size AND linea_id = 3 /* AND listino = 'it'*/
                LEFT JOIN product_colors_order AS pco ON pco.product_id = ps.product_id ANd pco.color_id = ps.color_id
                INNER JOIN prices AS pr ON pr.skew_id = ps.id

                WHERE ps.product_id = 22331
                AND ps.qty > 0
                AND ps.is_online = 1
                HAVING path != ''
                ORDER BY pco.sequence ASC, sc.sequence ASC

                /*ORDER BY ps.size_id ASC*/
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
4.53 ms
(7.21%) 		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(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
                ) 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-12-06 02:51:45')
                  AND (pr.discounted_price_to IS NULL OR pr.discounted_price_to >= '2025-12-06 02:51:45')
                  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-12-06 02:51:45')
                  AND (pr.discounted_price_to IS NULL OR pr.discounted_price_to >= '2025-12-06 02:51:45')
                  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.currency_id = 1
                ) AS absolute_max_price,
                (
                    SELECT IF(
                        pr.discounted_price_from IS NULL OR pr.discounted_price_from <= '2025-12-06 02:51:45'
                        AND
                        pr.discounted_price_to IS NULL OR pr.discounted_price_to >= '2025-12-06 02:51:45',

                        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.currency_id = 1

                    /*SELECT LEAST(MIN(price), COALESCE(MIN(discounted_price),999999))
                    FROM prices 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.currency_id = 1*/
                ) AS absolute_min_price,
                (
                    SELECT REPLACE(pdi.img_path, '400x570', '400x400') 
                    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-12-06 02:51:45')
                    AND (l.valid_to IS NULL OR l.valid_to >= '2025-12-06 02:51:45')
                    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-12-06 02:51:45')
                    AND (l.valid_to IS NULL OR l.valid_to >= '2025-12-06 02:51:45')
                    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-12-06 02:51:45')
                    AND (l.valid_to IS NULL OR l.valid_to >= '2025-12-06 02:51:45')
                    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-12-06 02:51:45')
                    AND (l.valid_to IS NULL OR l.valid_to >= '2025-12-06 02:51:45')
                    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-12-06 02:51:45')
                    AND (l.valid_to IS NULL OR l.valid_to >= '2025-12-06 02:51:45')
                    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 = 7 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, 7) WHERE p.is_online = 1 AND p.id IN (
                        SELECT product_id
                        FROM custom_categories_products_br
                        WHERE custom_category_id IN (0, 7)
                    ) 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, 8
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2.09 ms
(3.32%) 		8 
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: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
1.78 ms
(2.83%) 		3 
SELECT COUNT(p0_.id) AS sclr_0 FROM products_skews p0_ WHERE p0_.product_id = ? AND p0_.color_id = ? AND p0_.is_online = 1
Parameters: 
[
  22331
  11739
]
View formatted query    View runnable query    Explain query    View query backtrace
1.48 ms
(2.35%) 		3 
SELECT t0.id AS id_1, t0.photo_path AS photo_path_2, t0.photo_path_reduced AS photo_path_reduced_3, t0.brand_name AS brand_name_4, t0.color_name AS color_name_5, t0.season_label AS season_label_6, t0.insert_timestamp AS insert_timestamp_7, t0.product_id AS product_id_8, t0.color_id AS color_id_9, t0.phototype_id AS phototype_id_10, t0.season_id AS season_id_11 FROM skews_photos t0 WHERE t0.product_id = ? AND t0.color_id = ?
Parameters: 
[
  22331
  11739
]
View formatted query    View runnable query    Explain query    View query backtrace
1.43 ms
(2.27%) 		3 
SELECT COUNT(p0_.id) AS sclr_0 FROM products_skews p0_ WHERE p0_.product_id = ? AND p0_.color_id = ? AND p0_.qty > 0
Parameters: 
[
  22331
  11739
]
View formatted query    View runnable query    Explain query    View query backtrace
1.35 ms
(2.15%) 		1 
SELECT ps.size_id, s.size, sc.id AS size_conversion_id, sc.conversion
                FROM products_skews AS ps
                INNER JOIN products AS p on p.id = ps.product_id
                INNER JOIN sizes AS s ON s.id = ps.size_id
                LEFT JOIN size_conversion AS sc ON sc.size = s.size AND sc.linea_id = p.linea_id
                INNER JOIN skews_photos AS sp ON sp.product_id = ps.product_id AND phototype_id = 1 AND ps.color_id = sp.color_id
                WHERE p.id IN (22331)
                AND ps.qty > 0
                AND ps.is_online = 1
                GROUP BY sc.conversion
                ORDER BY sc.conversion ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.29 ms
(2.05%) 		3 
SELECT COUNT(p0_.id) AS sclr_0 FROM prices p0_ INNER JOIN products_skews p1_ ON (p1_.id = p0_.skew_id) WHERE p1_.product_id = ? AND p1_.color_id = ?
Parameters: 
[
  22331
  11739
]
View formatted query    View runnable query    Explain query    View query backtrace
1.27 ms
(2.02%) 		3 
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 FROM shipping_regions t0 WHERE t0.region_code = ? LIMIT 1
Parameters: 
[
  "it"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.18 ms
(1.87%) 		2 
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"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.12 ms
(1.79%) 		3 
SELECT t0.id AS id_1, t0.color AS color_2 FROM colors t0 WHERE t0.color = ? LIMIT 1
Parameters: 
[
  "P110626"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.94 ms
(1.49%) 		1 
SELECT ps.color_id, c.color, cd.id AS color_conversion_id, cd.description
                FROM products_skews AS ps
                INNER JOIN products AS p on p.id = ps.product_id
                INNER JOIN colors AS c ON c.id = ps.color_id
                LEFT JOIN colors_description AS cd ON cd.color = c.color
                INNER JOIN skews_photos AS sp ON sp.product_id = ps.product_id AND phototype_id = 1 AND ps.color_id = sp.color_id
                WHERE p.id IN (22331)
                AND ps.qty > 0
                AND ps.is_online = 1
                GROUP BY cd.description
                ORDER BY cd.description ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.86 ms
(1.37%) 		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 = ?
Parameters: 
[
  "donna"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.79 ms
(1.26%) 		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: 
[
  "scarpe"
  1
  2
]
View formatted query    View runnable query    Explain query    View query backtrace
0.70 ms
(1.11%) 		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
]
View formatted query    View runnable query    Explain query    View query backtrace
0.64 ms
(1.02%) 		1 
SELECT t0.id AS id_1, t0.product AS product_2, t0.ean13 AS ean13_3, t0.product_name AS product_name_4, t0.product_url AS product_url_5, t0.commodity_code AS commodity_code_6, t0.brand AS brand_7, t0.collection AS collection_8, t0.category AS category_9, t0.is_online AS is_online_10, t0.in_home AS in_home_11, t0.is_to_show AS is_to_show_12, t0.label AS label_13, t0.linea_id AS linea_id_14 FROM products t0 WHERE t0.id = ?
Parameters: 
[
  22331
]
View formatted query    View runnable query    Explain query    View query backtrace
0.59 ms
(0.94%) 		2 
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_ WHERE c0_.is_online = 1 AND c0_.show_in_menu = 1 AND c0_.parent_id = ? ORDER BY c0_.ordine ASC
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.57 ms
(0.91%) 		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-12-06 02:51:45"
  "2025-12-06 02:51:45"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.38 ms
(0.60%) 		1 
SELECT p0_.id AS id_0, p0_.price AS price_1, p0_.discount_percentage AS discount_percentage_2, p0_.discounted_price AS discounted_price_3, p0_.discounted_price_from AS discounted_price_from_4, p0_.discounted_price_to AS discounted_price_to_5, p0_.is_price_blocked AS is_price_blocked_6, p0_.lowest_price AS lowest_price_7, p0_.skew_id AS skew_id_8, p0_.currency_id AS currency_id_9, p0_.product_id AS product_id_10, p0_.shipping_region_id AS shipping_region_id_11 FROM prices p0_ INNER JOIN products_skews p1_ ON (p1_.id = p0_.skew_id) INNER JOIN colors c2_ ON (c2_.id = p1_.color_id) WHERE p0_.product_id = ? AND c2_.color = ? LIMIT 1
Parameters: 
[
  22331
  "P110626"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.37 ms
(0.59%) 		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_ WHERE c0_.is_online = 1 AND c0_.show_in_menu = 1 AND c0_.parent_id IS NULL ORDER BY c0_.ordine ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.27 ms
(0.43%) 		1 
SELECT t0.id AS id_1, t0.color AS color_2 FROM colors t0 WHERE t0.id = ?
Parameters: 
[
  11740
]
View formatted query    View runnable query    Explain query    View query backtrace

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\ProductsSkew 40
App\Entity\Size 20
App\Entity\CustomCategory 8
App\Entity\CustomCategoriesLang 8
App\Entity\SkewPhotos 6
App\Entity\PhotoType 6
App\Entity\Color 2
App\Entity\ColorsDescription 2
App\Entity\Language 1
App\Entity\ShippingRegion 1
App\Entity\Currencies 1
App\Entity\Product 1
App\Entity\Linea 1
App\Entity\Season 1
App\Entity\Prices 1
App\Entity\StaticTexts 1

Entities Mapping

Class Mapping errors
App\Entity\Language No errors.
App\Entity\CustomCategory No errors.
App\Entity\CustomCategoriesLang No errors.
App\Entity\CustomCategoriesProductsBridge No errors.
App\Entity\ShippingRegion No errors.
App\Entity\Currencies No errors.
App\Entity\Product No errors.
App\Entity\Linea No errors.
App\Entity\ProductsFeatures No errors.
App\Entity\ProductsSkew No errors.
App\Entity\ProductDefaultImage No errors.
App\Entity\ProductsExploded No errors.
App\Entity\RelatedProducts No errors.
App\Entity\Color No errors.
App\Entity\SkewPhotos No errors.
App\Entity\PhotoType No errors.
App\Entity\Season No errors.
App\Entity\Prices No errors.
App\Entity\Size No errors.
App\Entity\ColorsDescription No errors.
App\Entity\StaticTexts No errors.
App\Entity\StaticTextLangs No errors.
App\Entity\Features No errors.