Symfony Profiler

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
  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 = 488 AND c1_.lang_id = 2 ORDER BY c0_.ordine 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
  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 = 488;

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.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
  COUNT(l0_.id) AS sclr_0
FROM
  listini l0_

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

SELECT
  c0_.id AS id_0,
  c0_.custom_category AS custom_category_1,
  c0_.ordine AS ordine_2,
  c0_.is_online AS is_online_3,
  c0_.show_in_menu AS show_in_menu_4,
  c0_.parent_id AS parent_id_5
FROM
  custom_categories c0_
  INNER JOIN custom_categories_lang c1_ ON (c1_.custom_category_id = c0_.id)
WHERE
  c0_.is_online = 1
  AND c0_.show_in_menu = 1
  AND c0_.parent_id IS NULL
  AND c1_.lang_id = ?
ORDER BY
  c0_.ordine ASC

SELECT c0_.id AS id_0, c0_.custom_category AS custom_category_1, c0_.ordine AS ordine_2, c0_.is_online AS is_online_3, c0_.show_in_menu AS show_in_menu_4, c0_.parent_id AS parent_id_5 FROM custom_categories c0_ INNER JOIN custom_categories_lang c1_ ON (c1_.custom_category_id = c0_.id) WHERE c0_.is_online = 1 AND c0_.show_in_menu = 1 AND c0_.parent_id IS NULL AND c1_.lang_id = 2 ORDER BY c0_.ordine ASC;

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

SELECT s0_.id AS id_0, s0_.text AS text_1, s0_.meta_title AS meta_title_2, s0_.meta_description AS meta_description_3, s1_.exa_color AS exa_color_4, s1_.font_color AS font_color_5, s0_.static_text_id AS static_text_id_6, s0_.lang_id AS lang_id_7 FROM static_texts s1_ INNER JOIN static_text_langs s0_ ON (s1_.id = s0_.static_text_id) WHERE s1_.type = 'header' AND s0_.lang_id = 2 AND (s1_.valid_from IS NULL OR s1_.valid_from <= '2026-09-04 20:50:21') AND (s1_.valid_to IS NULL OR s1_.valid_to >= '2026-09-04 20:50:21') ORDER BY s1_.id DESC 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.lang AS lang_2,
  t0.label AS label_3
FROM
  langs t0

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

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

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