Symfony Profiler

Query Metrics

201 Database Queries

38 Different statements

129.97 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

39.38 ms
(30.30%)

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-06-16 00:10:21')
                  AND (pr.discounted_price_to IS NULL OR pr.discounted_price_to >= '2025-06-16 00:10:21')
                  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-06-16 00:10:21')
                  AND (pr.discounted_price_to IS NULL OR pr.discounted_price_to >= '2025-06-16 00:10:21')
                  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-06-16 00:10:21'
                        AND
                        pr.discounted_price_to IS NULL OR pr.discounted_price_to >= '2025-06-16 00:10:21',

                        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') 
                    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-06-16 00:10:21')
                    AND (l.valid_to IS NULL OR l.valid_to >= '2025-06-16 00:10:21')
                    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-06-16 00:10:21')
                    AND (l.valid_to IS NULL OR l.valid_to >= '2025-06-16 00:10:21')
                    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-06-16 00:10:21')
                    AND (l.valid_to IS NULL OR l.valid_to >= '2025-06-16 00:10:21')
                    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-06-16 00:10:21')
                    AND (l.valid_to IS NULL OR l.valid_to >= '2025-06-16 00:10:21')
                    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-06-16 00:10:21')
                    AND (l.valid_to IS NULL OR l.valid_to >= '2025-06-16 00:10:21')
                    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 = 45 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, 45) WHERE p.is_online = 1 AND p.id NOT IN (21428) AND p.id IN (
                        SELECT product_id
                        FROM custom_categories_products_br
                        WHERE custom_category_id IN (0, 45)
                    ) HAVING min_price > 0
                  AND color IS NOT NULL
                  AND nr_associations > 0
                  AND sum_online_qty > 0
                  AND path != ''  ORDER BY RAND() LIMIT 0, 6

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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-06-16 00:10:21'
      )
      AND (
        pr.discounted_price_to IS NULL
        OR pr.discounted_price_to >= '2025-06-16 00:10:21'
      )
      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-06-16 00:10:21'
      )
      AND (
        pr.discounted_price_to IS NULL
        OR pr.discounted_price_to >= '2025-06-16 00:10:21'
      )
      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-06-16 00:10:21'
        AND pr.discounted_price_to IS NULL
        OR pr.discounted_price_to >= '2025-06-16 00:10:21',
        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'
      )
    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-06-16 00:10:21'
      )
      AND (
        l.valid_to IS NULL
        OR l.valid_to >= '2025-06-16 00:10:21'
      )
    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-06-16 00:10:21'
      )
      AND (
        l.valid_to IS NULL
        OR l.valid_to >= '2025-06-16 00:10:21'
      )
    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-06-16 00:10:21'
      )
      AND (
        l.valid_to IS NULL
        OR l.valid_to >= '2025-06-16 00:10:21'
      )
      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-06-16 00:10:21'
      )
      AND (
        l.valid_to IS NULL
        OR l.valid_to >= '2025-06-16 00:10:21'
      )
    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-06-16 00:10:21'
      )
      AND (
        l.valid_to IS NULL
        OR l.valid_to >= '2025-06-16 00:10:21'
      )
    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 = 45
    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, 45)
WHERE
  p.is_online = 1
  AND p.id NOT IN (21428)
  AND p.id IN (
    SELECT
      product_id
    FROM
      custom_categories_products_br
    WHERE
      custom_category_id IN (0, 45)
  )
HAVING
  min_price > 0
  AND color IS NOT NULL
  AND nr_associations > 0
  AND sum_online_qty > 0
  AND path != ''
ORDER BY
  RAND()
LIMIT
  0, 6

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-06-16 00:10:21')
                  AND (pr.discounted_price_to IS NULL OR pr.discounted_price_to >= '2025-06-16 00:10:21')
                  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-06-16 00:10:21')
                  AND (pr.discounted_price_to IS NULL OR pr.discounted_price_to >= '2025-06-16 00:10:21')
                  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-06-16 00:10:21'
                        AND
                        pr.discounted_price_to IS NULL OR pr.discounted_price_to >= '2025-06-16 00:10:21',

                        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') 
                    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-06-16 00:10:21')
                    AND (l.valid_to IS NULL OR l.valid_to >= '2025-06-16 00:10:21')
                    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-06-16 00:10:21')
                    AND (l.valid_to IS NULL OR l.valid_to >= '2025-06-16 00:10:21')
                    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-06-16 00:10:21')
                    AND (l.valid_to IS NULL OR l.valid_to >= '2025-06-16 00:10:21')
                    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-06-16 00:10:21')
                    AND (l.valid_to IS NULL OR l.valid_to >= '2025-06-16 00:10:21')
                    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-06-16 00:10:21')
                    AND (l.valid_to IS NULL OR l.valid_to >= '2025-06-16 00:10:21')
                    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 = 45 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, 45) WHERE p.is_online = 1 AND p.id NOT IN (21428) AND p.id IN (
                        SELECT product_id
                        FROM custom_categories_products_br
                        WHERE custom_category_id IN (0, 45)
                    ) HAVING min_price > 0
                  AND color IS NOT NULL
                  AND nr_associations > 0
                  AND sum_online_qty > 0
                  AND path != ''  ORDER BY RAND() LIMIT 0, 6;

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 458)
3	App\Services\SearchProductsService->listProducts (line 673)
4	App\Services\ProductService->getRelatedProducts (line 381)
5	App\Services\ProductService->getAllFrontendInfo (line 653)
6	App\Controller\PagesController->product (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

24.59 ms
(18.92%)

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:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

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 = ?

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 = 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1803)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1748)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2705)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 157)
7	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 175)
8	App\Entity\CustomCategory->getCurrentLocaleCustomCategoryLang (line 1754)
9	Twig\Extension\CoreExtension::getAttribute (line 185)
10	__TwigTemplate_f54d49b0f5f14893e62cb73547f3dc21->doDisplay (line 393)
11	Twig\Template->yield (line 349)
12	Twig\Template->display (line 364)
13	Twig\Template->render (line 35)
14	Twig\TemplateWrapper->render (line 306)
15	Twig\Environment->render (line 431)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 78)
19	App\Controller\IncludeController->header (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
22	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
23	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
24	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
25	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
26	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 907)
27	__TwigTemplate_70565a578a9e94380b0e00d32e9c24b8->block_header (line 437)
28	Twig\Template->yieldBlock (line 224)
29	__TwigTemplate_70565a578a9e94380b0e00d32e9c24b8->doDisplay (line 393)
30	Twig\Template->yield (line 57)
31	__TwigTemplate_a688e28fd3df0def56a2ca482eb5b098->doDisplay (line 393)
32	Twig\Template->yield (line 349)
33	Twig\Template->display (line 364)
34	Twig\Template->render (line 35)
35	Twig\TemplateWrapper->render (line 306)
36	Twig\Environment->render (line 431)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 700)
40	App\Controller\PagesController->product (line 183)
41	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
42	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
43	Symfony\Component\HttpKernel\Kernel->handle (line 35)
44	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
45	require_once (line 5)

15.61 ms
(12.01%)

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, pr.shipping_region_id,
                (
                    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 = 14 /* 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 AND pr.shipping_region_id = 1

                WHERE ps.product_id = 21428
                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

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,
  pr.shipping_region_id,
  (
    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 = 14
  /* 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
  AND pr.shipping_region_id = 1
WHERE
  ps.product_id = 21428
  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*/

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, pr.shipping_region_id,
                (
                    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 = 14 /* 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 AND pr.shipping_region_id = 1

                WHERE ps.product_id = 21428
                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*/
                ;

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 138)
3	App\Services\ProductService->sellableSkus (line 198)
4	App\Services\ProductService->parsedSellableSkus (line 605)
5	App\Controller\PagesController->product (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

9.17 ms
(7.06%)

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:

View formatted query View runnable query Explain query View query backtrace

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

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 = 4 AND c1_.lang_id = 1 ORDER BY c0_.ordine ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 94)
6	App\Repository\CustomCategoryRepository->findOffspringCategories (line 123)
7	App\Repository\CustomCategoryRepository->CategoryTree (line 30)
8	App\Services\HeaderService->menuItems (line 68)
9	App\Controller\IncludeController->header (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
12	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
13	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
14	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
15	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
16	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 907)
17	__TwigTemplate_70565a578a9e94380b0e00d32e9c24b8->block_header (line 437)
18	Twig\Template->yieldBlock (line 224)
19	__TwigTemplate_70565a578a9e94380b0e00d32e9c24b8->doDisplay (line 393)
20	Twig\Template->yield (line 57)
21	__TwigTemplate_a688e28fd3df0def56a2ca482eb5b098->doDisplay (line 393)
22	Twig\Template->yield (line 349)
23	Twig\Template->display (line 364)
24	Twig\Template->render (line 35)
25	Twig\TemplateWrapper->render (line 306)
26	Twig\Environment->render (line 431)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 700)
30	App\Controller\PagesController->product (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 5)

5.96 ms
(4.59%)

SELECT t0.id AS id_1, t0.color AS color_2, t0.description AS description_3, t0.color_start AS color_start_4, t0.color_end AS color_end_5 FROM colors_description t0 WHERE t0.color = ? LIMIT 1

Parameters:

[
  "OATM"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.color AS color_2,
  t0.description AS description_3,
  t0.color_start AS color_start_4,
  t0.color_end AS color_end_5
FROM
  colors_description t0
WHERE
  t0.color = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.color AS color_2, t0.description AS description_3, t0.color_start AS color_start_4, t0.color_end AS color_end_5 FROM colors_description t0 WHERE t0.color = 'OATM' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 559)
5	App\Services\ProductService->ColorConversion (line 224)
6	App\Services\ProductService->parsedSellableSkus (line 605)
7	App\Controller\PagesController->product (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

4.67 ms
(3.60%)

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:

[
  705509
]

View formatted query View runnable query Explain query View query backtrace

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 = ?

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 = 705509;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 357)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 222)
7	App\Services\ProductService->parsedSellableSkus (line 605)
8	App\Controller\PagesController->product (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

3.13 ms
(2.41%)

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 = ? AND p0_.shipping_region_id = ? LIMIT 1

Parameters:

[
  19111
  "FDBRK"
  1
]

View formatted query View runnable query Explain query View query backtrace

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 = ?
  AND p0_.shipping_region_id = ?
LIMIT
  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 = 19111 AND c2_.color = 'FDBRK' AND p0_.shipping_region_id = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 80)
7	App\Repository\PricesRepository->findProductColorPrice (line 708)
8	App\Services\SearchProductsService->getPriceProductColor (line 678)
9	App\Services\ProductService->getRelatedProducts (line 381)
10	App\Services\ProductService->getAllFrontendInfo (line 653)
11	App\Controller\PagesController->product (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

2.62 ms
(2.02%)

SELECT t0.id AS id_1, t0.type AS type_2, t0.old_url AS old_url_3, t0.new_url AS new_url_4 FROM redirects t0 WHERE t0.old_url = ? LIMIT 1

Parameters:

[
  "/it/shoponline/cotopaxi-llama-t-shirt.CX.F24474W1304?color=OATM"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.old_url AS old_url_3,
  t0.new_url AS new_url_4
FROM
  redirects t0
WHERE
  t0.old_url = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.type AS type_2, t0.old_url AS old_url_3, t0.new_url AS new_url_4 FROM redirects t0 WHERE t0.old_url = '/it/shoponline/cotopaxi-llama-t-shirt.CX.F24474W1304?color=OATM' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 33)
5	App\EventListener\OldUrlRedirects->onKernelRequest (line 115)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

2.27 ms
(1.75%)

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:

[
  19111
]

View formatted query View runnable query Explain query View query backtrace

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 = ?

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 = 19111;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 357)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 739)
7	App\Services\SearchProductsService->isProductColorSellable (line 818)
8	App\Services\SearchProductsService->FixListOutput (line 461)
9	App\Services\SearchProductsService->listProducts (line 673)
10	App\Services\ProductService->getRelatedProducts (line 381)
11	App\Services\ProductService->getAllFrontendInfo (line 653)
12	App\Controller\PagesController->product (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

2.04 ms
(1.57%)

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 = ? AND t0.phototype_id = ? ORDER BY t0.season_id DESC LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

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 = ?
  AND t0.phototype_id = ?
ORDER BY
  t0.season_id DESC
LIMIT
  1

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 = 22723 AND t0.color_id = 10936 AND t0.phototype_id = 1 ORDER BY t0.season_id DESC LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 850)
5	App\Services\SearchProductsService->getNewPreviewPhoto (line 826)
6	App\Services\SearchProductsService->FixListOutput (line 461)
7	App\Services\SearchProductsService->listProducts (line 673)
8	App\Services\ProductService->getRelatedProducts (line 381)
9	App\Services\ProductService->getAllFrontendInfo (line 653)
10	App\Controller\PagesController->product (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

1.83 ms
(1.41%)

SELECT t0.id AS id_1, t0.color AS color_2 FROM colors t0 WHERE t0.color = ? LIMIT 1

Parameters:

[
  "TEMPT"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.color AS color_2
FROM
  colors t0
WHERE
  t0.color = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.color AS color_2 FROM colors t0 WHERE t0.color = 'TEMPT' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 741)
4	App\Services\SearchProductsService->isProductColorSellable (line 818)
5	App\Services\SearchProductsService->FixListOutput (line 461)
6	App\Services\SearchProductsService->listProducts (line 673)
7	App\Services\ProductService->getRelatedProducts (line 381)
8	App\Services\ProductService->getAllFrontendInfo (line 653)
9	App\Controller\PagesController->product (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

1.55 ms
(1.19%)

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

SELECT
  t0.id AS id_1,
  t0.lang AS lang_2,
  t0.label AS label_3
FROM
  langs t0
WHERE
  t0.lang = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.lang AS lang_2, t0.label AS label_3 FROM langs t0 WHERE t0.lang = 'it' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 649)
5	App\Controller\PagesController->product (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

1.26 ms
(0.97%)

SELECT t0.id AS id_1, t0.color AS color_2 FROM colors t0 WHERE t0.id = ?

Parameters:

[
  9453
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.color AS color_2
FROM
  colors t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.color AS color_2 FROM colors t0 WHERE t0.id = 9453;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Color::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
7	Proxies\__CG__\App\Entity\Color->__get (line 39)
8	App\Entity\Color->getColor (line 555)
9	App\Services\ProductService->ColorConversion (line 224)
10	App\Services\ProductService->parsedSellableSkus (line 605)
11	App\Controller\PagesController->product (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

1.21 ms
(0.93%)

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:

View formatted query View runnable query Explain query View query backtrace

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 = ?

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 = 19111 AND t0.color_id = 9493;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 794)
5	App\Services\SearchProductsService->productColorHasPhoto (line 763)
6	App\Services\SearchProductsService->isProductColorSellable (line 818)
7	App\Services\SearchProductsService->FixListOutput (line 461)
8	App\Services\SearchProductsService->listProducts (line 673)
9	App\Services\ProductService->getRelatedProducts (line 381)
10	App\Services\ProductService->getAllFrontendInfo (line 653)
11	App\Controller\PagesController->product (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

1.15 ms
(0.88%)

SELECT COUNT(l0_.id) AS sclr_0 FROM listini l0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(l0_.id) AS sclr_0
FROM
  listini l0_

SELECT COUNT(l0_.id) AS sclr_0 FROM listini l0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 23)
8	App\Repository\ListiniRepository->findNrListini (line 44)
9	App\EventListener\RequestListener->__construct (line 1237)
10	ContainerUICYONZ\App_KernelDevDebugContainer::getRequestListenerService (line 949)
11	ContainerUICYONZ\App_KernelDevDebugContainer::ContainerUICYONZ\{closure} (line 221)
12	Symfony\Component\EventDispatcher\EventDispatcher->sortListeners (line 70)
13	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 252)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 116)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

1.06 ms
(0.81%)

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 = ? AND p0_.shipping_region_id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

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 = ?
  AND p0_.shipping_region_id = ?

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 = 19111 AND p1_.color_id = 9493 AND p0_.shipping_region_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 63)
8	App\Repository\PricesRepository->findProductColorHasPrice (line 805)
9	App\Services\SearchProductsService->productColorHasSkuWithPrice (line 768)
10	App\Services\SearchProductsService->isProductColorSellable (line 818)
11	App\Services\SearchProductsService->FixListOutput (line 461)
12	App\Services\SearchProductsService->listProducts (line 673)
13	App\Services\ProductService->getRelatedProducts (line 381)
14	App\Services\ProductService->getAllFrontendInfo (line 653)
15	App\Controller\PagesController->product (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

1.04 ms
(0.80%)

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"
]

View formatted query View runnable query Explain query View query backtrace

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

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 = 'it' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 397)
5	App\Services\UtilityService->getCurrencyFromListino (line 195)
6	App\Services\ProductService->parsedSellableSkus (line 605)
7	App\Controller\PagesController->product (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.89 ms
(0.68%)

SELECT COUNT(p0_.id) AS sclr_0 FROM products_skews p0_ WHERE p0_.product_id = ? AND p0_.color_id = ? AND p0_.qty > 0

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  products_skews p0_
WHERE
  p0_.product_id = ?
  AND p0_.color_id = ?
  AND p0_.qty > 0

SELECT COUNT(p0_.id) AS sclr_0 FROM products_skews p0_ WHERE p0_.product_id = 19111 AND p0_.color_id = 9493 AND p0_.qty > 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 168)
8	App\Repository\ProductsSkewRepository->findProductColorHasQuantity (line 778)
9	App\Services\SearchProductsService->productColorHasQuantity (line 753)
10	App\Services\SearchProductsService->isProductColorSellable (line 818)
11	App\Services\SearchProductsService->FixListOutput (line 461)
12	App\Services\SearchProductsService->listProducts (line 673)
13	App\Services\ProductService->getRelatedProducts (line 381)
14	App\Services\ProductService->getAllFrontendInfo (line 653)
15	App\Controller\PagesController->product (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

0.85 ms
(0.65%)

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:

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  products_skews p0_
WHERE
  p0_.product_id = ?
  AND p0_.color_id = ?
  AND p0_.is_online = 1

SELECT COUNT(p0_.id) AS sclr_0 FROM products_skews p0_ WHERE p0_.product_id = 19111 AND p0_.color_id = 9493 AND p0_.is_online = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 181)
8	App\Repository\ProductsSkewRepository->findProductColorHasSkuOnline (line 786)
9	App\Services\SearchProductsService->productColorHasSkuOnline (line 758)
10	App\Services\SearchProductsService->isProductColorSellable (line 818)
11	App\Services\SearchProductsService->FixListOutput (line 461)
12	App\Services\SearchProductsService->listProducts (line 673)
13	App\Services\ProductService->getRelatedProducts (line 381)
14	App\Services\ProductService->getAllFrontendInfo (line 653)
15	App\Controller\PagesController->product (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

0.75 ms
(0.58%)

SELECT s0_.id AS id_0, s0_.text AS text_1, s0_.meta_title AS meta_title_2, s0_.meta_description AS meta_description_3, s1_.exa_color AS exa_color_4, s1_.font_color AS font_color_5, s0_.static_text_id AS static_text_id_6, s0_.lang_id AS lang_id_7 FROM static_texts s1_ INNER JOIN static_text_langs s0_ ON (s1_.id = s0_.static_text_id) WHERE s1_.type = ? AND s0_.lang_id = ? AND (s1_.valid_from IS NULL OR s1_.valid_from <= ?) AND (s1_.valid_to IS NULL OR s1_.valid_to >= ?) ORDER BY s1_.id DESC LIMIT 1

Parameters:

[
  "header"
  1
  "2025-06-16 00:10:21"
  "2025-06-16 00:10:21"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.text AS text_1,
  s0_.meta_title AS meta_title_2,
  s0_.meta_description AS meta_description_3,
  s1_.exa_color AS exa_color_4,
  s1_.font_color AS font_color_5,
  s0_.static_text_id AS static_text_id_6,
  s0_.lang_id AS lang_id_7
FROM
  static_texts s1_
  INNER JOIN static_text_langs s0_ ON (s1_.id = s0_.static_text_id)
WHERE
  s1_.type = ?
  AND s0_.lang_id = ?
  AND (
    s1_.valid_from IS NULL
    OR s1_.valid_from <= ?
  )
  AND (
    s1_.valid_to IS NULL
    OR s1_.valid_to >= ?
  )
ORDER BY
  s1_.id DESC
LIMIT
  1

SELECT s0_.id AS id_0, s0_.text AS text_1, s0_.meta_title AS meta_title_2, s0_.meta_description AS meta_description_3, s1_.exa_color AS exa_color_4, s1_.font_color AS font_color_5, s0_.static_text_id AS static_text_id_6, s0_.lang_id AS lang_id_7 FROM static_texts s1_ INNER JOIN static_text_langs s0_ ON (s1_.id = s0_.static_text_id) WHERE s1_.type = 'header' AND s0_.lang_id = 1 AND (s1_.valid_from IS NULL OR s1_.valid_from <= '2025-06-16 00:10:21') AND (s1_.valid_to IS NULL OR s1_.valid_to >= '2025-06-16 00:10:21') ORDER BY s1_.id DESC LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 38)
7	App\Repository\StaticTextsRepository->findActiveTextGivenType (line 66)
8	App\Controller\IncludeController->header (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
11	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
12	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
13	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
14	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
15	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 907)
16	__TwigTemplate_70565a578a9e94380b0e00d32e9c24b8->block_header (line 437)
17	Twig\Template->yieldBlock (line 224)
18	__TwigTemplate_70565a578a9e94380b0e00d32e9c24b8->doDisplay (line 393)
19	Twig\Template->yield (line 57)
20	__TwigTemplate_a688e28fd3df0def56a2ca482eb5b098->doDisplay (line 393)
21	Twig\Template->yield (line 349)
22	Twig\Template->display (line 364)
23	Twig\Template->render (line 35)
24	Twig\TemplateWrapper->render (line 306)
25	Twig\Environment->render (line 431)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 700)
29	App\Controller\PagesController->product (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 5)

0.68 ms
(0.53%)

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.lang_id = ? AND t0.custom_category_id = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

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.lang_id = ?
  AND t0.custom_category_id = ?
LIMIT
  1

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.lang_id = 1 AND t0.custom_category_id = 45 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 460)
5	App\Services\ProductService->getBreadcrumbProducts (line 384)
6	App\Services\ProductService->getAllFrontendInfo (line 653)
7	App\Controller\PagesController->product (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.68 ms
(0.52%)

SELECT l0_.id AS id_0, l1_.id AS id_1, l1_.label AS label_2, l1_.valid_from AS valid_from_3, l1_.valid_to AS valid_to_4, l1_.image AS image_5, l1_.exa_color AS exa_color_6, l1_.font_color AS font_color_7, l1_.position AS position_8, l1_.old_id AS old_id_9, l0_.label_id AS label_id_10, l0_.product_id AS product_id_11 FROM labels_products_br l0_ INNER JOIN labels l1_ ON l0_.label_id = l1_.id WHERE l0_.product_id = 21428 AND (l1_.valid_from IS NULL OR l1_.valid_from <= '2025-06-16 00:10:21') AND (l1_.valid_to IS NULL OR l1_.valid_to >= '2025-06-16 00:10:21') AND l1_.image IS NULL ORDER BY l1_.id DESC LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l1_.id AS id_1,
  l1_.label AS label_2,
  l1_.valid_from AS valid_from_3,
  l1_.valid_to AS valid_to_4,
  l1_.image AS image_5,
  l1_.exa_color AS exa_color_6,
  l1_.font_color AS font_color_7,
  l1_.position AS position_8,
  l1_.old_id AS old_id_9,
  l0_.label_id AS label_id_10,
  l0_.product_id AS product_id_11
FROM
  labels_products_br l0_
  INNER JOIN labels l1_ ON l0_.label_id = l1_.id
WHERE
  l0_.product_id = 21428
  AND (
    l1_.valid_from IS NULL
    OR l1_.valid_from <= '2025-06-16 00:10:21'
  )
  AND (
    l1_.valid_to IS NULL
    OR l1_.valid_to >= '2025-06-16 00:10:21'
  )
  AND l1_.image IS NULL
ORDER BY
  l1_.id DESC
LIMIT
  1

SELECT l0_.id AS id_0, l1_.id AS id_1, l1_.label AS label_2, l1_.valid_from AS valid_from_3, l1_.valid_to AS valid_to_4, l1_.image AS image_5, l1_.exa_color AS exa_color_6, l1_.font_color AS font_color_7, l1_.position AS position_8, l1_.old_id AS old_id_9, l0_.label_id AS label_id_10, l0_.product_id AS product_id_11 FROM labels_products_br l0_ INNER JOIN labels l1_ ON l0_.label_id = l1_.id WHERE l0_.product_id = 21428 AND (l1_.valid_from IS NULL OR l1_.valid_from <= '2025-06-16 00:10:21') AND (l1_.valid_to IS NULL OR l1_.valid_to >= '2025-06-16 00:10:21') AND l1_.image IS NULL ORDER BY l1_.id DESC LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 49)
6	App\Repository\LabelsProductBridgeRepository->findProductLabel (line 54)
7	App\Repository\LabelsProductBridgeRepository->findTextProductLabels (line 409)
8	App\Services\ProductService->getAllFrontendInfo (line 653)
9	App\Controller\PagesController->product (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.63 ms
(0.48%)

SELECT t0.id AS id_1, t0.custom_category AS custom_category_2, t0.ordine AS ordine_3, t0.is_online AS is_online_4, t0.show_in_menu AS show_in_menu_5, t0.parent_id AS parent_id_6 FROM custom_categories t0 WHERE t0.id = ?

Parameters:

[
  45
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.custom_category AS custom_category_2,
  t0.ordine AS ordine_3,
  t0.is_online AS is_online_4,
  t0.show_in_menu AS show_in_menu_5,
  t0.parent_id AS parent_id_6
FROM
  custom_categories t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.custom_category AS custom_category_2, t0.ordine AS ordine_3, t0.is_online AS is_online_4, t0.show_in_menu AS show_in_menu_5, t0.parent_id AS parent_id_6 FROM custom_categories t0 WHERE t0.id = 45;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\CustomCategory::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
7	Proxies\__CG__\App\Entity\CustomCategory->__get (line 103)
8	App\Entity\CustomCategory->getParent (line 465)
9	App\Services\ProductService->getBreadcrumbProducts (line 384)
10	App\Services\ProductService->getAllFrontendInfo (line 653)
11	App\Controller\PagesController->product (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.62 ms
(0.48%)

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.product = ? LIMIT 1

Parameters:

[
  "CX.F24474W1304"
]

View formatted query View runnable query Explain query View query backtrace

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.product = ?
LIMIT
  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.product = 'CX.F24474W1304' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 576)
5	App\Controller\PagesController->product (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.58 ms
(0.44%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.video AS video_4, t0.product_id AS product_id_5, t0.lang_id AS lang_id_6 FROM products_texts t0 WHERE t0.product_id = ? AND t0.lang_id = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.video AS video_4,
  t0.product_id AS product_id_5,
  t0.lang_id AS lang_id_6
FROM
  products_texts t0
WHERE
  t0.product_id = ?
  AND t0.lang_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.video AS video_4, t0.product_id AS product_id_5, t0.lang_id AS lang_id_6 FROM products_texts t0 WHERE t0.product_id = 21428 AND t0.lang_id = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 376)
5	App\Services\ProductService->getAllFrontendInfo (line 653)
6	App\Controller\PagesController->product (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.57 ms
(0.44%)

SELECT t0.id AS id_1, t0.custom_category_id AS custom_category_id_2, t0.product_id AS product_id_3 FROM custom_categories_products_br t0 WHERE t0.product_id = ? LIMIT 1

Parameters:

[
  21428
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.custom_category_id AS custom_category_id_2,
  t0.product_id AS product_id_3
FROM
  custom_categories_products_br t0
WHERE
  t0.product_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.custom_category_id AS custom_category_id_2, t0.product_id AS product_id_3 FROM custom_categories_products_br t0 WHERE t0.product_id = 21428 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 612)
5	App\Services\ProductService->getRelatedProducts (line 381)
6	App\Services\ProductService->getAllFrontendInfo (line 653)
7	App\Controller\PagesController->product (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.57 ms
(0.44%)

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
]

View formatted query View runnable query Explain query View query backtrace

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

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 = 1 ORDER BY c0_.ordine ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 78)
6	App\Repository\CustomCategoryRepository->ParentCategories (line 120)
7	App\Repository\CustomCategoryRepository->CategoryTree (line 30)
8	App\Services\HeaderService->menuItems (line 68)
9	App\Controller\IncludeController->header (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
12	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
13	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
14	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
15	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
16	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 907)
17	__TwigTemplate_70565a578a9e94380b0e00d32e9c24b8->block_header (line 437)
18	Twig\Template->yieldBlock (line 224)
19	__TwigTemplate_70565a578a9e94380b0e00d32e9c24b8->doDisplay (line 393)
20	Twig\Template->yield (line 57)
21	__TwigTemplate_a688e28fd3df0def56a2ca482eb5b098->doDisplay (line 393)
22	Twig\Template->yield (line 349)
23	Twig\Template->display (line 364)
24	Twig\Template->render (line 35)
25	Twig\TemplateWrapper->render (line 306)
26	Twig\Environment->render (line 431)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 700)
30	App\Controller\PagesController->product (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 5)

0.53 ms
(0.41%)

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

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 = ?

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 = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Currencies::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
7	Proxies\__CG__\App\Entity\Currencies->__get (line 57)
8	App\Entity\Currencies->getLabel (line 1754)
9	Twig\Extension\CoreExtension::getAttribute (line 1433)
10	__TwigTemplate_04c03bf3632f7b46280ae7ddd942a28a->doDisplay (line 393)
11	Twig\Template->yield (line 155)
12	__TwigTemplate_a688e28fd3df0def56a2ca482eb5b098->block_DataLayer (line 437)
13	Twig\Template->yieldBlock (line 229)
14	__TwigTemplate_70565a578a9e94380b0e00d32e9c24b8->doDisplay (line 393)
15	Twig\Template->yield (line 57)
16	__TwigTemplate_a688e28fd3df0def56a2ca482eb5b098->doDisplay (line 393)
17	Twig\Template->yield (line 349)
18	Twig\Template->display (line 364)
19	Twig\Template->render (line 35)
20	Twig\TemplateWrapper->render (line 306)
21	Twig\Environment->render (line 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 700)
25	App\Controller\PagesController->product (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

0.51 ms
(0.39%)

SELECT t0.id AS id_1, t0.label_value AS label_value_2, t0.label_id AS label_id_3, t0.lang_id AS lang_id_4 FROM labels_lang t0 WHERE t0.label_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.label_value AS label_value_2,
  t0.label_id AS label_id_3,
  t0.lang_id AS lang_id_4
FROM
  labels_lang t0
WHERE
  t0.label_id = ?

SELECT t0.id AS id_1, t0.label_value AS label_value_2, t0.label_id AS label_id_3, t0.lang_id AS lang_id_4 FROM labels_lang t0 WHERE t0.label_id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1803)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1748)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2705)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 108)
7	Doctrine\Common\Collections\AbstractLazyCollection->containsKey (line 350)
8	Doctrine\ORM\PersistentCollection->containsKey (line 420)
9	Doctrine\ORM\PersistentCollection->offsetExists (line 1595)
10	Twig\Extension\CoreExtension::getAttribute (line 502)
11	__TwigTemplate_a688e28fd3df0def56a2ca482eb5b098->block_body (line 437)
12	Twig\Template->yieldBlock (line 231)
13	__TwigTemplate_70565a578a9e94380b0e00d32e9c24b8->doDisplay (line 393)
14	Twig\Template->yield (line 57)
15	__TwigTemplate_a688e28fd3df0def56a2ca482eb5b098->doDisplay (line 393)
16	Twig\Template->yield (line 349)
17	Twig\Template->display (line 364)
18	Twig\Template->render (line 35)
19	Twig\TemplateWrapper->render (line 306)
20	Twig\Environment->render (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 700)
24	App\Controller\PagesController->product (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.48 ms
(0.37%)

SELECT t0.id AS id_1, t0.linea AS linea_2 FROM linee t0 WHERE t0.id = ?

Parameters:

[
  14
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.linea AS linea_2
FROM
  linee t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.linea AS linea_2 FROM linee t0 WHERE t0.id = 14;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Linea::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
7	Proxies\__CG__\App\Entity\Linea->__get (line 39)
8	App\Entity\Linea->getLinea (line 1754)
9	Twig\Extension\CoreExtension::getAttribute (line 747)
10	__TwigTemplate_a688e28fd3df0def56a2ca482eb5b098->block_body (line 437)
11	Twig\Template->yieldBlock (line 231)
12	__TwigTemplate_70565a578a9e94380b0e00d32e9c24b8->doDisplay (line 393)
13	Twig\Template->yield (line 57)
14	__TwigTemplate_a688e28fd3df0def56a2ca482eb5b098->doDisplay (line 393)
15	Twig\Template->yield (line 349)
16	Twig\Template->display (line 364)
17	Twig\Template->render (line 35)
18	Twig\TemplateWrapper->render (line 306)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 700)
23	App\Controller\PagesController->product (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.47 ms
(0.36%)

SELECT t0.id AS id_1, t0.lang AS lang_2, t0.label AS label_3 FROM langs t0 WHERE t0.id = ?

Parameters:

[
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.lang AS lang_2,
  t0.label AS label_3
FROM
  langs t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.lang AS lang_2, t0.label AS label_3 FROM langs t0 WHERE t0.id = '1';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 357)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 36)
7	App\Controller\PagesController->__construct (line 24)
8	ContainerUICYONZ\getPagesControllerService::do (line 533)
9	ContainerUICYONZ\App_KernelDevDebugContainer->load (line 220)
10	Symfony\Component\DependencyInjection\Container::make (line 202)
11	Symfony\Component\DependencyInjection\Container->get (line 38)
12	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 25)
13	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 127)
14	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 95)
15	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 33)
16	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 166)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.45 ms
(0.35%)

SELECT t0.id AS id_1, t0.listino AS listino_2, t0.currency_id AS currency_id_3 FROM listini t0 WHERE t0.id = ?

Parameters:

[
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.listino AS listino_2,
  t0.currency_id AS currency_id_3
FROM
  listini t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.listino AS listino_2, t0.currency_id AS currency_id_3 FROM listini t0 WHERE t0.id = '1';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 357)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 38)
7	App\Controller\PagesController->__construct (line 24)
8	ContainerUICYONZ\getPagesControllerService::do (line 533)
9	ContainerUICYONZ\App_KernelDevDebugContainer->load (line 220)
10	Symfony\Component\DependencyInjection\Container::make (line 202)
11	Symfony\Component\DependencyInjection\Container->get (line 38)
12	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 25)
13	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 127)
14	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 95)
15	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 33)
16	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 166)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.45 ms
(0.35%)

SELECT l0_.id AS id_0, l1_.id AS id_1, l1_.label AS label_2, l1_.valid_from AS valid_from_3, l1_.valid_to AS valid_to_4, l1_.image AS image_5, l1_.exa_color AS exa_color_6, l1_.font_color AS font_color_7, l1_.position AS position_8, l1_.old_id AS old_id_9, l0_.label_id AS label_id_10, l0_.product_id AS product_id_11 FROM labels_products_br l0_ INNER JOIN labels l1_ ON l0_.label_id = l1_.id WHERE l0_.product_id = 21428 AND (l1_.valid_from IS NULL OR l1_.valid_from <= '2025-06-16 00:10:21') AND (l1_.valid_to IS NULL OR l1_.valid_to >= '2025-06-16 00:10:21') AND l1_.image IS NOT NULL ORDER BY l1_.id DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l1_.id AS id_1,
  l1_.label AS label_2,
  l1_.valid_from AS valid_from_3,
  l1_.valid_to AS valid_to_4,
  l1_.image AS image_5,
  l1_.exa_color AS exa_color_6,
  l1_.font_color AS font_color_7,
  l1_.position AS position_8,
  l1_.old_id AS old_id_9,
  l0_.label_id AS label_id_10,
  l0_.product_id AS product_id_11
FROM
  labels_products_br l0_
  INNER JOIN labels l1_ ON l0_.label_id = l1_.id
WHERE
  l0_.product_id = 21428
  AND (
    l1_.valid_from IS NULL
    OR l1_.valid_from <= '2025-06-16 00:10:21'
  )
  AND (
    l1_.valid_to IS NULL
    OR l1_.valid_to >= '2025-06-16 00:10:21'
  )
  AND l1_.image IS NOT NULL
ORDER BY
  l1_.id DESC

SELECT l0_.id AS id_0, l1_.id AS id_1, l1_.label AS label_2, l1_.valid_from AS valid_from_3, l1_.valid_to AS valid_to_4, l1_.image AS image_5, l1_.exa_color AS exa_color_6, l1_.font_color AS font_color_7, l1_.position AS position_8, l1_.old_id AS old_id_9, l0_.label_id AS label_id_10, l0_.product_id AS product_id_11 FROM labels_products_br l0_ INNER JOIN labels l1_ ON l0_.label_id = l1_.id WHERE l0_.product_id = 21428 AND (l1_.valid_from IS NULL OR l1_.valid_from <= '2025-06-16 00:10:21') AND (l1_.valid_to IS NULL OR l1_.valid_to >= '2025-06-16 00:10:21') AND l1_.image IS NOT NULL ORDER BY l1_.id DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 49)
6	App\Repository\LabelsProductBridgeRepository->findProductLabel (line 58)
7	App\Repository\LabelsProductBridgeRepository->findIconProductLabels (line 412)
8	App\Services\ProductService->getAllFrontendInfo (line 653)
9	App\Controller\PagesController->product (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.44 ms
(0.34%)

SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.related_id AS related_id_3 FROM products_related t0 WHERE t0.product_id = ?

Parameters:

[
  21428
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.product_id AS product_id_2,
  t0.related_id AS related_id_3
FROM
  products_related t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.related_id AS related_id_3 FROM products_related t0 WHERE t0.product_id = 21428;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 623)
5	App\Services\ProductService->getRelatedProducts (line 381)
6	App\Services\ProductService->getAllFrontendInfo (line 653)
7	App\Controller\PagesController->product (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.38 ms
(0.29%)

SELECT t0.id AS id_1, t0.listino AS listino_2, t0.currency_id AS currency_id_3 FROM listini t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.listino AS listino_2,
  t0.currency_id AS currency_id_3
FROM
  listini t0

SELECT t0.id AS id_1, t0.listino AS listino_2, t0.currency_id AS currency_id_3 FROM listini t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 74)
6	App\Controller\IncludeController->header (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
9	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
10	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
11	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
12	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
13	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 907)
14	__TwigTemplate_70565a578a9e94380b0e00d32e9c24b8->block_header (line 437)
15	Twig\Template->yieldBlock (line 224)
16	__TwigTemplate_70565a578a9e94380b0e00d32e9c24b8->doDisplay (line 393)
17	Twig\Template->yield (line 57)
18	__TwigTemplate_a688e28fd3df0def56a2ca482eb5b098->doDisplay (line 393)
19	Twig\Template->yield (line 349)
20	Twig\Template->display (line 364)
21	Twig\Template->render (line 35)
22	Twig\TemplateWrapper->render (line 306)
23	Twig\Environment->render (line 431)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 700)
27	App\Controller\PagesController->product (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

0.33 ms
(0.26%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.html_it AS html_it_3, t0.html_en AS html_en_4 FROM size_tables t0 WHERE t0.name = ? LIMIT 1

Parameters:

[
  "default_donna"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.html_it AS html_it_3,
  t0.html_en AS html_en_4
FROM
  size_tables t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.html_it AS html_it_3, t0.html_en AS html_en_4 FROM size_tables t0 WHERE t0.name = 'default_donna' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 397)
5	App\Services\ProductService->getAllFrontendInfo (line 653)
6	App\Controller\PagesController->product (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.30 ms
(0.23%)

SELECT t0.id AS id_1, t0.type AS type_2, t0.text AS text_3, t0.exa_color AS exa_color_4, t0.font_color AS font_color_5, t0.valid_from AS valid_from_6, t0.valid_to AS valid_to_7 FROM static_texts t0 WHERE t0.id = ?

Parameters:

[
  26
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.text AS text_3,
  t0.exa_color AS exa_color_4,
  t0.font_color AS font_color_5,
  t0.valid_from AS valid_from_6,
  t0.valid_to AS valid_to_7
FROM
  static_texts t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.text AS text_3, t0.exa_color AS exa_color_4, t0.font_color AS font_color_5, t0.valid_from AS valid_from_6, t0.valid_to AS valid_to_7 FROM static_texts t0 WHERE t0.id = 26;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\StaticTexts::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
7	Proxies\__CG__\App\Entity\StaticTexts->__get (line 80)
8	App\Entity\StaticTexts->getExaColor (line 1754)
9	Twig\Extension\CoreExtension::getAttribute (line 91)
10	__TwigTemplate_f54d49b0f5f14893e62cb73547f3dc21->doDisplay (line 393)
11	Twig\Template->yield (line 349)
12	Twig\Template->display (line 364)
13	Twig\Template->render (line 35)
14	Twig\TemplateWrapper->render (line 306)
15	Twig\Environment->render (line 431)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 78)
19	App\Controller\IncludeController->header (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
22	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
23	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
24	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
25	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
26	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 907)
27	__TwigTemplate_70565a578a9e94380b0e00d32e9c24b8->block_header (line 437)
28	Twig\Template->yieldBlock (line 224)
29	__TwigTemplate_70565a578a9e94380b0e00d32e9c24b8->doDisplay (line 393)
30	Twig\Template->yield (line 57)
31	__TwigTemplate_a688e28fd3df0def56a2ca482eb5b098->doDisplay (line 393)
32	Twig\Template->yield (line 349)
33	Twig\Template->display (line 364)
34	Twig\Template->render (line 35)
35	Twig\TemplateWrapper->render (line 306)
36	Twig\Environment->render (line 431)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 700)
40	App\Controller\PagesController->product (line 183)
41	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
42	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
43	Symfony\Component\HttpKernel\Kernel->handle (line 35)
44	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
45	require_once (line 5)

0.27 ms
(0.21%)

SELECT t0.id AS id_1, t0.lang AS lang_2, t0.label AS label_3 FROM langs t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.lang AS lang_2,
  t0.label AS label_3
FROM
  langs t0

SELECT t0.id AS id_1, t0.lang AS lang_2, t0.label AS label_3 FROM langs t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 71)
6	App\Controller\IncludeController->header (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
9	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
10	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
11	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
12	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
13	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 907)
14	__TwigTemplate_70565a578a9e94380b0e00d32e9c24b8->block_header (line 437)
15	Twig\Template->yieldBlock (line 224)
16	__TwigTemplate_70565a578a9e94380b0e00d32e9c24b8->doDisplay (line 393)
17	Twig\Template->yield (line 57)
18	__TwigTemplate_a688e28fd3df0def56a2ca482eb5b098->doDisplay (line 393)
19	Twig\Template->yield (line 349)
20	Twig\Template->display (line 364)
21	Twig\Template->render (line 35)
22	Twig\TemplateWrapper->render (line 306)
23	Twig\Environment->render (line 431)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 700)
27	App\Controller\PagesController->product (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\Listini	No errors.
App\Entity\Redirects	No errors.
App\Entity\Language	No errors.
App\Entity\Currencies	No errors.
App\Entity\ShippingRegion	No errors.
App\Entity\Product	The field App\Entity\Product#relatedProducts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ProductsRelated#product does not contain the required 'inversedBy="relatedProducts"' attribute.
App\Entity\Linea	No errors.
App\Entity\CustomCategoriesProductsBridge	No errors.
App\Entity\ProductsFeatures	No errors.
App\Entity\ProductsSkew	No errors.
App\Entity\ProductDefaultImage	No errors.
App\Entity\ProductsExploded	No errors.
App\Entity\ProductsRelated	No errors.
App\Entity\Color	No errors.
App\Entity\Size	No errors.
App\Entity\ColorsGroupsBr	No errors.
App\Entity\ColorsDescription	No errors.
App\Entity\ProductTexts	No errors.
App\Entity\CustomCategory	No errors.
App\Entity\SkewPhotos	No errors.
App\Entity\PhotoType	No errors.
App\Entity\Season	No errors.
App\Entity\Prices	No errors.
App\Entity\CustomCategoriesLang	No errors.
App\Entity\SizeTables	No errors.
App\Entity\LabelsProductsBridge	No errors.
App\Entity\Labels	No errors.
App\Entity\LabelsLang	No errors.
App\Entity\StaticTexts	No errors.
App\Entity\StaticTextLangs	No errors.
App\Entity\Features	No errors.
App\Entity\ColorsGroups	No errors.
App\Entity\ColorsGroupsLang	No errors.

Symfony Profiler

GET http://cotopaxi-interno.inol3.com/it/shoponline/cotopaxi-llama-t-shirt.CX.F24474W1304?color=OATM

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping