Symfony Profiler

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 = 'MSSS' 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 = 739174;

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-15 23:36:06'
      )
      AND (
        pr.discounted_price_to IS NULL
        OR pr.discounted_price_to >= '2025-06-15 23:36:06'
      )
      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-15 23:36:06'
      )
      AND (
        pr.discounted_price_to IS NULL
        OR pr.discounted_price_to >= '2025-06-15 23:36:06'
      )
      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-15 23:36:06'
        AND pr.discounted_price_to IS NULL
        OR pr.discounted_price_to >= '2025-06-15 23:36:06',
        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-15 23:36:06'
      )
      AND (
        l.valid_to IS NULL
        OR l.valid_to >= '2025-06-15 23:36:06'
      )
    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-15 23:36:06'
      )
      AND (
        l.valid_to IS NULL
        OR l.valid_to >= '2025-06-15 23:36:06'
      )
    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-15 23:36:06'
      )
      AND (
        l.valid_to IS NULL
        OR l.valid_to >= '2025-06-15 23:36:06'
      )
      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-15 23:36:06'
      )
      AND (
        l.valid_to IS NULL
        OR l.valid_to >= '2025-06-15 23:36:06'
      )
    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-15 23:36:06'
      )
      AND (
        l.valid_to IS NULL
        OR l.valid_to >= '2025-06-15 23:36:06'
      )
    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
    ORDER BY
      pco.sequence ASC,
      pe.ordine ASC
  ) AS exploded_colors
FROM
  products AS p
  LEFT JOIN products_texts AS pt ON pt.product_id = p.id
  AND lang_id = 1
WHERE
  p.is_online = 1
  AND p.in_home = 1
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, 12

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-15 23:36:06')
                  AND (pr.discounted_price_to IS NULL OR pr.discounted_price_to >= '2025-06-15 23:36:06')
                  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-15 23:36:06')
                  AND (pr.discounted_price_to IS NULL OR pr.discounted_price_to >= '2025-06-15 23:36:06')
                  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-15 23:36:06'
                        AND
                        pr.discounted_price_to IS NULL OR pr.discounted_price_to >= '2025-06-15 23:36:06',

                        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-15 23:36:06')
                    AND (l.valid_to IS NULL OR l.valid_to >= '2025-06-15 23:36:06')
                    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-15 23:36:06')
                    AND (l.valid_to IS NULL OR l.valid_to >= '2025-06-15 23:36:06')
                    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-15 23:36:06')
                    AND (l.valid_to IS NULL OR l.valid_to >= '2025-06-15 23:36:06')
                    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-15 23:36:06')
                    AND (l.valid_to IS NULL OR l.valid_to >= '2025-06-15 23:36:06')
                    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-15 23:36:06')
                    AND (l.valid_to IS NULL OR l.valid_to >= '2025-06-15 23:36:06')
                    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  ORDER BY pco.sequence ASC, pe.ordine ASC
                ) AS exploded_colors FROM products AS p
                  LEFT JOIN products_texts AS pt ON pt.product_id = p.id AND lang_id = 1 WHERE p.is_online = 1 AND p.in_home = 1 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, 12;

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;

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 = 15
  /* 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 = 22729
  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 = 15 /* 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 = 22729
                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 = 15
  /* 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 = 22727
  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 = 15 /* 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 = 22727
                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 = 22730
  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 = 22730
                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 = 22728
  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 = 22728
                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*/
                ;