Symfony Profiler

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 = 5
  /* 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 = 9581
  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 = 5 /* 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 = 9581
                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
  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
      AND sp.phototype_id = 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
      AND sp.phototype_id = 1
  ) AS available_colors,
  (
    SELECT
      COUNT(br.id)
    FROM
      custom_categories_products_br AS br
    WHERE
      br.product_id = p.id
  ) AS nr_associations,
  (
    SELECT
      MAX(price)
    FROM
      prices AS pr
    WHERE
      pr.shipping_region_id = 1
      AND pr.skew_id IN(
        SELECT
          ps.id
        FROM
          products_skews AS ps
        WHERE
          ps.product_id = p.id
          AND ps.qty > 0
          AND ps.is_online = 1
      )
  ) AS max_price,
  (
    SELECT
      MIN(price)
    FROM
      prices AS pr
    WHERE
      pr.shipping_region_id = 1
      AND pr.skew_id IN(
        SELECT
          ps.id
        FROM
          products_skews AS ps
        WHERE
          ps.product_id = p.id
          AND ps.qty > 0
          AND ps.is_online = 1
      )
  ) AS min_price,
  (
    SELECT
      MAX(discounted_price)
    FROM
      prices AS pr
    WHERE
      pr.shipping_region_id = 1
      AND (
        pr.discounted_price_from IS NULL
        OR pr.discounted_price_from <= '2025-12-19 01:54:51'
      )
      AND (
        pr.discounted_price_to IS NULL
        OR pr.discounted_price_to >= '2025-12-19 01:54:51'
      )
      AND pr.skew_id IN(
        SELECT
          ps.id
        FROM
          products_skews AS ps
        WHERE
          ps.product_id = p.id
          AND ps.qty > 0
          AND ps.is_online = 1
      )
  ) AS max_discounted_price,
  (
    SELECT
      MIN(discounted_price)
    FROM
      prices AS pr
    WHERE
      pr.shipping_region_id = 1
      AND (
        pr.discounted_price_from IS NULL
        OR pr.discounted_price_from <= '2025-12-19 01:54:51'
      )
      AND (
        pr.discounted_price_to IS NULL
        OR pr.discounted_price_to >= '2025-12-19 01:54:51'
      )
      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-12-19 01:54:51'
        AND pr.discounted_price_to IS NULL
        OR pr.discounted_price_to >= '2025-12-19 01:54:51',
        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', '400x570_HC'
      )
    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
      ll.label_value
    FROM
      labels_products_br AS lpb
      INNER JOIN labels AS l ON l.id = lpb.label_id
      INNER JOIN labels_lang AS ll ON ll.label_id = l.id
      AND ll.lang_id = 1
    WHERE
      lpb.product_id = p.id
      AND l.image IS NULL
      AND (
        l.valid_from IS NULL
        OR l.valid_from <= '2025-12-19 01:54:51'
      )
      AND (
        l.valid_to IS NULL
        OR l.valid_to >= '2025-12-19 01:54:51'
      )
    ORDER BY
      lpb.id DESC
    LIMIT
      0, 1
  ) AS product_label,
  (
    SELECT
      GROUP_CONCAT(l.image)
    FROM
      labels_products_br AS lpb
      INNER JOIN labels AS l ON l.id = lpb.label_id
    WHERE
      lpb.product_id = p.id
      AND (
        l.valid_from IS NULL
        OR l.valid_from <= '2025-12-19 01:54:51'
      )
      AND (
        l.valid_to IS NULL
        OR l.valid_to >= '2025-12-19 01:54:51'
      )
    ORDER BY
      lpb.id DESC
  ) AS product_icon_labels,
  (
    SELECT
      GROUP_CONCAT(l.label)
    FROM
      labels_products_br AS lpb
      INNER JOIN labels AS l ON l.id = lpb.label_id
    WHERE
      lpb.product_id = p.id
      AND (
        l.valid_from IS NULL
        OR l.valid_from <= '2025-12-19 01:54:51'
      )
      AND (
        l.valid_to IS NULL
        OR l.valid_to >= '2025-12-19 01:54:51'
      )
      AND l.image is NOT NULL
    ORDER BY
      lpb.id DESC
  ) AS product_icon_labels_captions,
  (
    SELECT
      l.exa_color
    FROM
      labels_products_br AS lpb
      INNER JOIN labels AS l ON l.id = lpb.label_id
    WHERE
      lpb.product_id = p.id
      AND l.image IS NULL
      AND (
        l.valid_from IS NULL
        OR l.valid_from <= '2025-12-19 01:54:51'
      )
      AND (
        l.valid_to IS NULL
        OR l.valid_to >= '2025-12-19 01:54:51'
      )
    ORDER BY
      lpb.id DESC
    LIMIT
      0, 1
  ) AS product_label_color,
  (
    SELECT
      l.font_color
    FROM
      labels_products_br AS lpb
      INNER JOIN labels AS l ON l.id = lpb.label_id
    WHERE
      lpb.product_id = p.id
      AND l.image IS NULL
      AND (
        l.valid_from IS NULL
        OR l.valid_from <= '2025-12-19 01:54:51'
      )
      AND (
        l.valid_to IS NULL
        OR l.valid_to >= '2025-12-19 01:54:51'
      )
    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 = 122
    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, 122)
WHERE
  p.is_online = 1
  AND p.id NOT IN (9581)
  AND p.id IN (
    SELECT
      product_id
    FROM
      custom_categories_products_br
    WHERE
      custom_category_id IN (0, 122)
  )
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
                    AND sp.phototype_id = 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
                    AND sp.phototype_id = 1
                ) AS available_colors,
                (
                    SELECT COUNT(br.id)
                    FROM custom_categories_products_br AS br
                    WHERE br.product_id = p.id
                ) AS nr_associations,
                (
                    SELECT MAX(price)
                    FROM prices AS pr
                    WHERE pr.shipping_region_id = 1
                    AND pr.skew_id IN(
                        SELECT ps.id
                            FROM products_skews AS ps
                            WHERE ps.product_id = p.id
                            AND ps.qty > 0
                            AND ps.is_online = 1
                    )
                ) AS max_price,
                (
                  SELECT MIN(price)
                      FROM prices AS pr
                      WHERE pr.shipping_region_id = 1
                      AND pr.skew_id IN(
                        SELECT ps.id
                            FROM products_skews AS ps
                            WHERE ps.product_id = p.id
                            AND ps.qty > 0
                            AND ps.is_online = 1
                      )
                ) AS min_price,
                (
                  SELECT MAX(discounted_price)
                  FROM prices AS pr
                  WHERE pr.shipping_region_id = 1
                  AND (pr.discounted_price_from IS NULL OR pr.discounted_price_from <= '2025-12-19 01:54:51')
                  AND (pr.discounted_price_to IS NULL OR pr.discounted_price_to >= '2025-12-19 01:54:51')
                  AND pr.skew_id IN(
                    SELECT ps.id
                    FROM products_skews AS ps
                    WHERE ps.product_id = p.id
                    AND ps.qty > 0
                    AND ps.is_online = 1
                  )
                ) AS max_discounted_price,
                (
                  SELECT MIN(discounted_price)
                  FROM prices AS pr
                  WHERE pr.shipping_region_id = 1
                  AND (pr.discounted_price_from IS NULL OR pr.discounted_price_from <= '2025-12-19 01:54:51')
                  AND (pr.discounted_price_to IS NULL OR pr.discounted_price_to >= '2025-12-19 01:54:51')
                  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-12-19 01:54:51'
                        AND
                        pr.discounted_price_to IS NULL OR pr.discounted_price_to >= '2025-12-19 01:54:51',

                        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', '400x570_HC')
                    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 ll.label_value
                    FROM labels_products_br AS lpb
                    INNER JOIN labels AS l ON l.id = lpb.label_id
                    INNER JOIN labels_lang AS ll ON ll.label_id = l.id AND ll.lang_id = 1
                    WHERE lpb.product_id = p.id
                    AND l.image IS NULL
                    AND (l.valid_from IS NULL OR l.valid_from <= '2025-12-19 01:54:51')
                    AND (l.valid_to IS NULL OR l.valid_to >= '2025-12-19 01:54:51')
                    ORDER BY lpb.id DESC
                    LIMIT 0,1
                ) AS product_label,
                (
                    SELECT GROUP_CONCAT(l.image)
                    FROM labels_products_br AS lpb
                    INNER JOIN labels AS l ON l.id = lpb.label_id
                    WHERE lpb.product_id = p.id
                    AND (l.valid_from IS NULL OR l.valid_from <= '2025-12-19 01:54:51')
                    AND (l.valid_to IS NULL OR l.valid_to >= '2025-12-19 01:54:51')
                    ORDER BY lpb.id DESC
                ) AS product_icon_labels,
                (
                    SELECT GROUP_CONCAT(l.label)
                    FROM labels_products_br AS lpb
                    INNER JOIN labels AS l ON l.id = lpb.label_id
                    WHERE lpb.product_id = p.id
                    AND (l.valid_from IS NULL OR l.valid_from <= '2025-12-19 01:54:51')
                    AND (l.valid_to IS NULL OR l.valid_to >= '2025-12-19 01:54:51')
                    AND l.image is NOT NULL
                    ORDER BY lpb.id DESC
                ) AS product_icon_labels_captions,
                (
                    SELECT l.exa_color
                    FROM labels_products_br AS lpb
                    INNER JOIN labels AS l ON l.id = lpb.label_id
                    WHERE lpb.product_id = p.id
                    AND l.image IS NULL
                    AND (l.valid_from IS NULL OR l.valid_from <= '2025-12-19 01:54:51')
                    AND (l.valid_to IS NULL OR l.valid_to >= '2025-12-19 01:54:51')
                    ORDER BY lpb.id DESC
                    LIMIT 0,1
                ) AS product_label_color,
                (
                    SELECT l.font_color
                    FROM labels_products_br AS lpb
                    INNER JOIN labels AS l ON l.id = lpb.label_id
                    WHERE lpb.product_id = p.id
                    AND l.image IS NULL
                    AND (l.valid_from IS NULL OR l.valid_from <= '2025-12-19 01:54:51')
                    AND (l.valid_to IS NULL OR l.valid_to >= '2025-12-19 01:54:51')
                    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 = 122 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, 122) WHERE p.is_online = 1 AND p.id NOT IN (9581) AND p.id IN (
                        SELECT product_id
                        FROM custom_categories_products_br
                        WHERE custom_category_id IN (0, 122)
                    ) 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
  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 = 21268 AND c2_.color = 'QRTZ' AND p0_.shipping_region_id = 1 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.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 = 1;

SELECT
  c0_.id AS id_0,
  c0_.custom_category AS custom_category_1,
  c0_.ordine AS ordine_2,
  c0_.is_online AS is_online_3,
  c0_.show_in_menu AS show_in_menu_4,
  c0_.parent_id AS parent_id_5
FROM
  custom_categories c0_
  INNER JOIN custom_categories_lang c1_ ON (c1_.custom_category_id = c0_.id)
WHERE
  c0_.is_online = 1
  AND c0_.show_in_menu = 1
  AND c0_.parent_id = ?
  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 = 1 AND c1_.lang_id = 1 ORDER BY c0_.ordine ASC;

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

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

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-it/shoponline/ugg-boot-in-glitter-suede.HC.YK001GLI?color=BKBK' 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.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 = 21268;

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 = 24526 AND t0.color_id = 515;