Symfony Profiler

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.country AS country_2,
  t0.country_code AS country_code_3,
  t0.country_nav_code AS country_nav_code_4,
  t0.allowed AS allowed_5,
  t0.is_eu AS is_eu_6,
  t0.is_klarna_valid AS is_klarna_valid_7,
  t0.shipping_region_id AS shipping_region_id_8
FROM
  country t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.country AS country_2, t0.country_code AS country_code_3, t0.country_nav_code AS country_nav_code_4, t0.allowed AS allowed_5, t0.is_eu AS is_eu_6, t0.is_klarna_valid AS is_klarna_valid_7, t0.shipping_region_id AS shipping_region_id_8 FROM country t0 WHERE t0.id = 114;

SELECT
  t0.id AS id_1,
  t0.region_name AS region_name_2,
  t0.region_code AS region_code_3,
  t0.ordine AS ordine_4,
  t0.lang_id AS lang_id_5,
  t0.currency_id AS currency_id_6,
  t0.listino_id AS listino_id_7
FROM
  shipping_regions t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.region_name AS region_name_2, t0.region_code AS region_code_3, t0.ordine AS ordine_4, t0.lang_id AS lang_id_5, t0.currency_id AS currency_id_6, t0.listino_id AS listino_id_7 FROM shipping_regions t0 WHERE t0.id = 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 = 'it' LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.type AS type_1,
  s0_.text AS text_2,
  s0_.exa_color AS exa_color_3,
  s0_.font_color AS font_color_4,
  s0_.valid_from AS valid_from_5,
  s0_.valid_to AS valid_to_6
FROM
  static_texts s0_
  INNER JOIN static_text_langs s1_ ON (s0_.id = s1_.static_text_id)
WHERE
  s0_.type = ?
  AND s1_.lang_id = ?
  AND (
    s0_.valid_from IS NULL
    OR s0_.valid_from <= ?
  )
  AND (
    s0_.valid_to IS NULL
    OR s0_.valid_to >= ?
  )
ORDER BY
  s0_.id DESC
LIMIT
  1

SELECT s0_.id AS id_0, s0_.type AS type_1, s0_.text AS text_2, s0_.exa_color AS exa_color_3, s0_.font_color AS font_color_4, s0_.valid_from AS valid_from_5, s0_.valid_to AS valid_to_6 FROM static_texts s0_ INNER JOIN static_text_langs s1_ ON (s0_.id = s1_.static_text_id) WHERE s0_.type = 'basket' AND s1_.lang_id = 1 AND (s0_.valid_from IS NULL OR s0_.valid_from <= '2025-10-27 17:04:13') AND (s0_.valid_to IS NULL OR s0_.valid_to >= '2025-10-27 17:04:13') ORDER BY s0_.id DESC 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 = 'it' LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.type AS type_1,
  s0_.text AS text_2,
  s0_.exa_color AS exa_color_3,
  s0_.font_color AS font_color_4,
  s0_.valid_from AS valid_from_5,
  s0_.valid_to AS valid_to_6
FROM
  static_texts s0_
  INNER JOIN static_text_langs s1_ ON (s0_.id = s1_.static_text_id)
WHERE
  s0_.type = ?
  AND s1_.lang_id = ?
  AND (
    s0_.valid_from IS NULL
    OR s0_.valid_from <= ?
  )
  AND (
    s0_.valid_to IS NULL
    OR s0_.valid_to >= ?
  )
ORDER BY
  s0_.id DESC
LIMIT
  1

SELECT s0_.id AS id_0, s0_.type AS type_1, s0_.text AS text_2, s0_.exa_color AS exa_color_3, s0_.font_color AS font_color_4, s0_.valid_from AS valid_from_5, s0_.valid_to AS valid_to_6 FROM static_texts s0_ INNER JOIN static_text_langs s1_ ON (s0_.id = s1_.static_text_id) WHERE s0_.type = 'header' AND s1_.lang_id = 1 AND (s0_.valid_from IS NULL OR s0_.valid_from <= '2025-10-27 17:04:13') AND (s0_.valid_to IS NULL OR s0_.valid_to >= '2025-10-27 17:04:13') ORDER BY s0_.id DESC 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 = 'it' LIMIT 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 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 = 1 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 = ?
  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 = 84 AND c1_.lang_id = 1 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 = ?
  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 = 85 AND c1_.lang_id = 1 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 = ?
  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 = 91 AND c1_.lang_id = 1 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 = ?
  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 = 92 AND c1_.lang_id = 1 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 = ?
  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 = 88 AND c1_.lang_id = 1 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 = ?
  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 = 106 AND c1_.lang_id = 1 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 = ?
  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 = 107 AND c1_.lang_id = 1 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 = ?
  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 = 108 AND c1_.lang_id = 1 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 = ?
  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 = 89 AND c1_.lang_id = 1 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 = ?
  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 = 109 AND c1_.lang_id = 1 ORDER BY c0_.ordine ASC;