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/technologies/hytech-seas' 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/technologies/hytech-seas' 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 IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

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 IN ('422781', '422782', '424712', '424749', '415595', '415596', '410051', '410009', '410010', '410011', '410012', '410049', '410050', '410081', '410083', '410126', '410127', '410128', '410170', '410791', '410333', '410334', '424505', '410338', '410339');

SELECT
  f.code AS feature_code,
  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
  ) AS feature_value
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 = :lang_id
WHERE
  pfv.product_id = :product_id
ORDER BY
  pfv.feature_id ASC,
  pfv.option_id ASC

SELECT
                    f.code AS feature_code,
                    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
                    ) AS feature_value
                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 = 25967
                ORDER BY pfv.feature_id ASC, pfv.option_id ASC
            ;

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

SELECT
  f.code AS feature_code,
  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
  ) AS feature_value
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 = :lang_id
WHERE
  pfv.product_id = :product_id
ORDER BY
  pfv.feature_id ASC,
  pfv.option_id ASC

SELECT
                    f.code AS feature_code,
                    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
                    ) AS feature_value
                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 = 25872
                ORDER BY pfv.feature_id ASC, pfv.option_id ASC
            ;

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

SELECT
  f.code AS feature_code,
  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
  ) AS feature_value
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 = :lang_id
WHERE
  pfv.product_id = :product_id
ORDER BY
  pfv.feature_id ASC,
  pfv.option_id ASC

SELECT
                    f.code AS feature_code,
                    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
                    ) AS feature_value
                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 = 25963
                ORDER BY pfv.feature_id ASC, pfv.option_id ASC
            ;

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

SELECT
  f.code AS feature_code,
  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
  ) AS feature_value
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 = :lang_id
WHERE
  pfv.product_id = :product_id
ORDER BY
  pfv.feature_id ASC,
  pfv.option_id ASC

SELECT
                    f.code AS feature_code,
                    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
                    ) AS feature_value
                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 = 25865
                ORDER BY pfv.feature_id ASC, pfv.option_id ASC
            ;

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

SELECT
  f.code AS feature_code,
  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
  ) AS feature_value
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 = :lang_id
WHERE
  pfv.product_id = :product_id
ORDER BY
  pfv.feature_id ASC,
  pfv.option_id ASC

SELECT
                    f.code AS feature_code,
                    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
                    ) AS feature_value
                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 = 25866
                ORDER BY pfv.feature_id ASC, pfv.option_id ASC
            ;

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

SELECT
  f.code AS feature_code,
  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
  ) AS feature_value
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 = :lang_id
WHERE
  pfv.product_id = :product_id
ORDER BY
  pfv.feature_id ASC,
  pfv.option_id ASC

SELECT
                    f.code AS feature_code,
                    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
                    ) AS feature_value
                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 = 25867
                ORDER BY pfv.feature_id ASC, pfv.option_id ASC
            ;

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

SELECT
  f.code AS feature_code,
  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
  ) AS feature_value
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 = :lang_id
WHERE
  pfv.product_id = :product_id
ORDER BY
  pfv.feature_id ASC,
  pfv.option_id ASC

SELECT
                    f.code AS feature_code,
                    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
                    ) AS feature_value
                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 = 25868
                ORDER BY pfv.feature_id ASC, pfv.option_id ASC
            ;

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

SELECT
  f.code AS feature_code,
  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
  ) AS feature_value
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 = :lang_id
WHERE
  pfv.product_id = :product_id
ORDER BY
  pfv.feature_id ASC,
  pfv.option_id ASC

SELECT
                    f.code AS feature_code,
                    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
                    ) AS feature_value
                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 = 25961
                ORDER BY pfv.feature_id ASC, pfv.option_id ASC
            ;

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

SELECT
  f.code AS feature_code,
  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
  ) AS feature_value
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 = :lang_id
WHERE
  pfv.product_id = :product_id
ORDER BY
  pfv.feature_id ASC,
  pfv.option_id ASC