Symfony Profiler

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

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

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

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

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

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

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

SELECT t0.id AS id_1, t0.listino AS listino_2, t0.currency_id AS currency_id_3 FROM listini t0 WHERE t0.listino = 'it' 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 = ?
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 = '/en-it' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.symbol AS symbol_3,
  t0.label AS label_4
FROM
  currencies t0
WHERE
  t0.id = ?

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;

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 <= '2026-09-02 16:18:24'
      )
      AND (
        pr.discounted_price_to IS NULL
        OR pr.discounted_price_to >= '2026-09-02 16:18:24'
      )
      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 <= '2026-09-02 16:18:24'
      )
      AND (
        pr.discounted_price_to IS NULL
        OR pr.discounted_price_to >= '2026-09-02 16:18:24'
      )
      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 <= '2026-09-02 16:18:24'
        AND pr.discounted_price_to IS NULL
        OR pr.discounted_price_to >= '2026-09-02 16:18:24',
        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', 'grid')
    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 <= '2026-09-02 16:18:24'
      )
      AND (
        l.valid_to IS NULL
        OR l.valid_to >= '2026-09-02 16:18:24'
      )
    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 <= '2026-09-02 16:18:24'
      )
      AND (
        l.valid_to IS NULL
        OR l.valid_to >= '2026-09-02 16:18:24'
      )
    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 <= '2026-09-02 16:18:24'
      )
      AND (
        l.valid_to IS NULL
        OR l.valid_to >= '2026-09-02 16:18:24'
      )
      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 <= '2026-09-02 16:18:24'
      )
      AND (
        l.valid_to IS NULL
        OR l.valid_to >= '2026-09-02 16:18:24'
      )
    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 <= '2026-09-02 16:18:24'
      )
      AND (
        l.valid_to IS NULL
        OR l.valid_to >= '2026-09-02 16:18:24'
      )
    ORDER BY
      lpb.id DESC
    LIMIT
      0, 1
  ) AS product_label_font_color,
  (
    SELECT
      COALESCE(
        NULLIF(
          TRIM(pfv.value_text),
          ''
        ),
        NULLIF(
          TRIM(
            TRAILING '.'
            FROM
              TRIM(
                TRAILING '0'
                FROM
                  CAST(pfv.value_number AS CHAR)
              )
          ),
          ''
        ),
        CASE WHEN pfv.value_bool = 1 THEN
          'Yes'
        WHEN pfv.value_bool = 0 THEN
          'No'
        ELSE
          NULL
        END,
        fot.label
      )
    FROM
      product_feature_value AS pfv
      INNER JOIN feature AS f ON f.id = pfv.feature_id
      LEFT JOIN feature_option_translation AS fot ON fot.option_id = pfv.option_id
      AND fot.lang_id = 2
    WHERE
      pfv.product_id = p.id
      AND f.code = 'PLY'
    LIMIT
      1
  ) AS feature_ply,
  (
    SELECT
      COALESCE(
        NULLIF(
          TRIM(pfv.value_text),
          ''
        ),
        NULLIF(
          TRIM(
            TRAILING '.'
            FROM
              TRIM(
                TRAILING '0'
                FROM
                  CAST(pfv.value_number AS CHAR)
              )
          ),
          ''
        ),
        CASE WHEN pfv.value_bool = 1 THEN
          'Yes'
        WHEN pfv.value_bool = 0 THEN
          'No'
        ELSE
          NULL
        END,
        fot.label
      )
    FROM
      product_feature_value AS pfv
      INNER JOIN feature AS f ON f.id = pfv.feature_id
      LEFT JOIN feature_option_translation AS fot ON fot.option_id = pfv.option_id
      AND fot.lang_id = 2
    WHERE
      pfv.product_id = p.id
      AND f.code = 'SHEETS'
    LIMIT
      1
  ) AS feature_sheets_per_roll,
  (
    SELECT
      COALESCE(
        NULLIF(
          TRIM(pfv.value_text),
          ''
        ),
        NULLIF(
          TRIM(
            TRAILING '.'
            FROM
              TRIM(
                TRAILING '0'
                FROM
                  CAST(pfv.value_number AS CHAR)
              )
          ),
          ''
        ),
        CASE WHEN pfv.value_bool = 1 THEN
          'Yes'
        WHEN pfv.value_bool = 0 THEN
          'No'
        ELSE
          NULL
        END,
        fot.label
      )
    FROM
      product_feature_value AS pfv
      INNER JOIN feature AS f ON f.id = pfv.feature_id
      LEFT JOIN feature_option_translation AS fot ON fot.option_id = pfv.option_id
      AND fot.lang_id = 2
    WHERE
      pfv.product_id = p.id
      AND f.code = 'ROLL LENGTH'
    LIMIT
      1
  ) AS feature_roll_length,
  (
    SELECT
      COALESCE(
        NULLIF(
          TRIM(pfv.value_text),
          ''
        ),
        NULLIF(
          TRIM(
            TRAILING '.'
            FROM
              TRIM(
                TRAILING '0'
                FROM
                  CAST(pfv.value_number AS CHAR)
              )
          ),
          ''
        ),
        CASE WHEN pfv.value_bool = 1 THEN
          'Yes'
        WHEN pfv.value_bool = 0 THEN
          'No'
        ELSE
          NULL
        END,
        fot.label
      )
    FROM
      product_feature_value AS pfv
      INNER JOIN feature AS f ON f.id = pfv.feature_id
      LEFT JOIN feature_option_translation AS fot ON fot.option_id = pfv.option_id
      AND fot.lang_id = 2
    WHERE
      pfv.product_id = p.id
      AND (
        UPPER(f.code) = 'TECH LINE'
        OR UPPER(f.code) = 'TECHLINE'
        OR UPPER(f.code) = 'TECH_LINE'
        OR UPPER(f.code) = 'TECH-LINE'
      )
    LIMIT
      1
  ) AS feature_tech_line,
  (
    SELECT
      GROUP_CONCAT(
        CONCAT(
          TRIM(
            IFNULL(f.feature, '')
          ),
          ':::',
          TRIM(
            IFNULL(f.text, '')
          )
        ) SEPARATOR '|||'
      )
    FROM
      products_features AS pf
      INNER JOIN features AS f ON f.id = pf.feature_id
    WHERE
      pf.product_id = p.id
  ) AS features_raw,
  (
    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 = 2
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 <= '2026-09-02 16:18:24')
                  AND (pr.discounted_price_to IS NULL OR pr.discounted_price_to >= '2026-09-02 16:18:24')
                  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 <= '2026-09-02 16:18:24')
                  AND (pr.discounted_price_to IS NULL OR pr.discounted_price_to >= '2026-09-02 16:18:24')
                  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 <= '2026-09-02 16:18:24'
                        AND
                        pr.discounted_price_to IS NULL OR pr.discounted_price_to >= '2026-09-02 16:18:24',

                        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', 'grid')
                    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 <= '2026-09-02 16:18:24')
                    AND (l.valid_to IS NULL OR l.valid_to >= '2026-09-02 16:18:24')
                    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 <= '2026-09-02 16:18:24')
                    AND (l.valid_to IS NULL OR l.valid_to >= '2026-09-02 16:18:24')
                    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 <= '2026-09-02 16:18:24')
                    AND (l.valid_to IS NULL OR l.valid_to >= '2026-09-02 16:18:24')
                    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 <= '2026-09-02 16:18:24')
                    AND (l.valid_to IS NULL OR l.valid_to >= '2026-09-02 16:18:24')
                    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 <= '2026-09-02 16:18:24')
                    AND (l.valid_to IS NULL OR l.valid_to >= '2026-09-02 16:18:24')
                    ORDER BY lpb.id DESC
                    LIMIT 0,1
                ) AS product_label_font_color,
                (
                    SELECT COALESCE(
                        NULLIF(TRIM(pfv.value_text), ''),
                        NULLIF(TRIM(TRAILING '.' FROM TRIM(TRAILING '0' FROM CAST(pfv.value_number AS CHAR))), ''),
                        CASE
                            WHEN pfv.value_bool = 1 THEN 'Yes'
                            WHEN pfv.value_bool = 0 THEN 'No'
                            ELSE NULL
                        END,
                        fot.label
                    )
                    FROM product_feature_value AS pfv
                    INNER JOIN feature AS f ON f.id = pfv.feature_id
                    LEFT JOIN feature_option_translation AS fot ON fot.option_id = pfv.option_id AND fot.lang_id = 2
                    WHERE pfv.product_id = p.id
                    AND f.code = 'PLY'
                    LIMIT 1
                ) AS feature_ply,
                (
                    SELECT COALESCE(
                        NULLIF(TRIM(pfv.value_text), ''),
                        NULLIF(TRIM(TRAILING '.' FROM TRIM(TRAILING '0' FROM CAST(pfv.value_number AS CHAR))), ''),
                        CASE
                            WHEN pfv.value_bool = 1 THEN 'Yes'
                            WHEN pfv.value_bool = 0 THEN 'No'
                            ELSE NULL
                        END,
                        fot.label
                    )
                    FROM product_feature_value AS pfv
                    INNER JOIN feature AS f ON f.id = pfv.feature_id
                    LEFT JOIN feature_option_translation AS fot ON fot.option_id = pfv.option_id AND fot.lang_id = 2
                    WHERE pfv.product_id = p.id
                    AND f.code = 'SHEETS'
                    LIMIT 1
                ) AS feature_sheets_per_roll,
                (
                    SELECT COALESCE(
                        NULLIF(TRIM(pfv.value_text), ''),
                        NULLIF(TRIM(TRAILING '.' FROM TRIM(TRAILING '0' FROM CAST(pfv.value_number AS CHAR))), ''),
                        CASE
                            WHEN pfv.value_bool = 1 THEN 'Yes'
                            WHEN pfv.value_bool = 0 THEN 'No'
                            ELSE NULL
                        END,
                        fot.label
                    )
                    FROM product_feature_value AS pfv
                    INNER JOIN feature AS f ON f.id = pfv.feature_id
                    LEFT JOIN feature_option_translation AS fot ON fot.option_id = pfv.option_id AND fot.lang_id = 2
                    WHERE pfv.product_id = p.id
                    AND f.code = 'ROLL LENGTH'
                    LIMIT 1
                ) AS feature_roll_length,
                (
                    SELECT COALESCE(
                        NULLIF(TRIM(pfv.value_text), ''),
                        NULLIF(TRIM(TRAILING '.' FROM TRIM(TRAILING '0' FROM CAST(pfv.value_number AS CHAR))), ''),
                        CASE
                            WHEN pfv.value_bool = 1 THEN 'Yes'
                            WHEN pfv.value_bool = 0 THEN 'No'
                            ELSE NULL
                        END,
                        fot.label
                    )
                    FROM product_feature_value AS pfv
                    INNER JOIN feature AS f ON f.id = pfv.feature_id
                    LEFT JOIN feature_option_translation AS fot ON fot.option_id = pfv.option_id AND fot.lang_id = 2
                    WHERE pfv.product_id = p.id
                    AND (
                        UPPER(f.code) = 'TECH LINE'
                        OR UPPER(f.code) = 'TECHLINE'
                        OR UPPER(f.code) = 'TECH_LINE'
                        OR UPPER(f.code) = 'TECH-LINE'
                    )
                    LIMIT 1
                ) AS feature_tech_line,
                (
                    SELECT GROUP_CONCAT(
                        CONCAT(
                            TRIM(IFNULL(f.feature, '')),
                            ':::',
                            TRIM(IFNULL(f.text, ''))
                        ) SEPARATOR '|||'
                    )
                    FROM products_features AS pf
                    INNER JOIN features AS f ON f.id = pf.feature_id
                    WHERE pf.product_id = p.id
                ) AS features_raw,
                (
                    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 = 2 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
  b0_.id AS id_0,
  b0_.visible_from AS visible_from_1,
  b0_.visible_to AS visible_to_2,
  b0_.position AS position_3,
  b0_.deleted AS deleted_4,
  b0_.video_desktop AS video_desktop_5,
  b0_.video_mobile AS video_mobile_6
FROM
  banner_box b0_
WHERE
  b0_.position = ?

SELECT b0_.id AS id_0, b0_.visible_from AS visible_from_1, b0_.visible_to AS visible_to_2, b0_.position AS position_3, b0_.deleted AS deleted_4, b0_.video_desktop AS video_desktop_5, b0_.video_mobile AS video_mobile_6 FROM banner_box b0_ WHERE b0_.position = 1;

SELECT
  t0.id AS id_1,
  t0.slide_id AS slide_id_2,
  t0.ordine AS ordine_3,
  t0.mobile AS mobile_4,
  t0.link AS link_5,
  t0.link2 AS link2_6,
  t0.link_video AS link_video_7,
  t0.text AS text_8,
  t0.text_banner AS text_banner_9,
  t0.btn_text AS btn_text_10,
  t0.btn_text2 AS btn_text2_11,
  t0.image AS image_12,
  t0.deleted AS deleted_13,
  t0.created_at AS created_at_14,
  t0.banner_box_id AS banner_box_id_15,
  t0.lang_id AS lang_id_16
FROM
  banner_item t0
WHERE
  t0.banner_box_id = ?
  AND t0.lang_id = ?
ORDER BY
  t0.ordine ASC

SELECT t0.id AS id_1, t0.slide_id AS slide_id_2, t0.ordine AS ordine_3, t0.mobile AS mobile_4, t0.link AS link_5, t0.link2 AS link2_6, t0.link_video AS link_video_7, t0.text AS text_8, t0.text_banner AS text_banner_9, t0.btn_text AS btn_text_10, t0.btn_text2 AS btn_text2_11, t0.image AS image_12, t0.deleted AS deleted_13, t0.created_at AS created_at_14, t0.banner_box_id AS banner_box_id_15, t0.lang_id AS lang_id_16 FROM banner_item t0 WHERE t0.banner_box_id = 15 AND t0.lang_id = 2 ORDER BY t0.ordine ASC;

SELECT
  b0_.id AS id_0,
  b0_.visible_from AS visible_from_1,
  b0_.visible_to AS visible_to_2,
  b0_.position AS position_3,
  b0_.deleted AS deleted_4,
  b0_.video_desktop AS video_desktop_5,
  b0_.video_mobile AS video_mobile_6
FROM
  banner_box b0_
WHERE
  b0_.position = ?

SELECT b0_.id AS id_0, b0_.visible_from AS visible_from_1, b0_.visible_to AS visible_to_2, b0_.position AS position_3, b0_.deleted AS deleted_4, b0_.video_desktop AS video_desktop_5, b0_.video_mobile AS video_mobile_6 FROM banner_box b0_ WHERE b0_.position = 2;