Symfony Profiler

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO carts (
  id, country, updated_at, created_at,
  customer_id, last_order_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO carts (id, country, updated_at, created_at, customer_id, last_order_id) VALUES ('019f9a3a-5780-7f33-a41a-78898bd9b089', 'DE', '2026-07-25 19:02:22', '2026-07-25 19:02:22', NULL, NULL);

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO wishlists (
  id, updated_at, created_at, customer_id
)
VALUES
  (?, ?, ?, ?)

INSERT INTO wishlists (id, updated_at, created_at, customer_id) VALUES ('019f9a3a-5788-7dd1-a263-56eaf092b379', '2026-07-25 19:02:22', '2026-07-25 19:02:22', NULL);

"COMMIT"

"COMMIT";

SELECT
  a.id as group_id,
  a.code,
  a.name_ru,
  a.name_de,
  a.sort,
  a.is_metric,
  a.is_deeplink,
  a.is_filterable,
  a.use_deeplink_code,
  a.group_sort,
  a.group_name_ru,
  a.group_name_de,
  av.uid as value_id,
  av.name_ru as value_ru,
  av.name_de as value_de
FROM
  attribute_value AS av
  JOIN attribute AS a on a.code = av.code
WHERE
  av.uid IN(
    'netto_gewicht_filter_3',
    'verpackung_3948',
    'family_62',
    'materialgruppierung_23844',
    'netto_gewicht_filter_5',
    'groesse_3393',
    'groesse_3394',
    'geschlecht_65',
    'farbgruppierung_579',
    'serie_53664',
    'feiertage_822',
    'coolbox_filter_0',
    'freezebox_filter_3',
    'feiertage_819',
    'feiertage_826',
    'family_693',
    'farbgruppierung_578',
    'geschlecht_66',
    'art_der_suessigkeiten_34384',
    'feiertage_960',
    'feiertage_823',
    'verpackung_4003',
    'family_61',
    'family_418',
    'feiertage_820',
    'hoehe_3085',
    'materialgruppierung_1535',
    'netto_gewicht_filter_4',
    'netto_gewicht_filter_6',
    'volumen_2164',
    'feiertage_1130',
    'feiertage_825',
    'fuellung_39832',
    'netto_fuellmenge_filter_5',
    'altergruppierung_6272',
    'farbgruppierung_576',
    'fuellung_36388',
    'geschlecht_69',
    'geschmack_23757',
    'verpackung_2954',
    'beschriftungssprache_25379',
    'geschmack_26932',
    'geschmack_29768',
    'vendor_1240',
    'art_2163',
    'geschlecht_68',
    'inschrift_22369',
    'inschrift_22370',
    'inschrift_22440',
    'inschrift_23488',
    'modelname_22823',
    'modelname_22824',
    'modelname_22825',
    'modelname_22826',
    'modelname_22827',
    'modelname_22828',
    'modelname_32417',
    'modelname_32418',
    'modelname_32419',
    'modelname_32420',
    'modelname_32421',
    'modelname_32423',
    'modelname_32424',
    'modelname_32425',
    'modelname_36717',
    'muster_473',
    'vendor_267',
    'verpackung_3121',
    'farbgruppierung_2835',
    'farbgruppierung_586',
    'fuellung_39590',
    'geschmack_29765',
    'inschrift_22405',
    'inschrift_32549',
    'inschrift_32557',
    'modelname_32422',
    'netto_gewicht_filter_1',
    'vendor_1508',
    'vendor_156',
    'vendor_196',
    'anzahl_der_artikel_2680',
    'family_27',
    'family_376',
    'farbgruppierung_587',
    'form_2154',
    'geschmack_23783',
    'grossen_54132',
    'handelsform_3535',
    'inschrift_26753',
    'inschrift_32534',
    'inschrift_32551',
    'inschrift_32558',
    'inschrift_32559',
    'materialgruppierung_1527',
    'muster_8100',
    'netto_gewicht_filter_2',
    'serie_55565',
    'sorte_15484',
    'sorte_3536',
    'verpackung_2870',
    'verpackung_35918',
    'volumen_der_tasse_40912',
    'anzahl_der_artikel_2683',
    'art_26280',
    'art_26281',
    'art_der_suessigkeiten_35208',
    'art_der_suessigkeiten_40018',
    'family_185',
    'family_335',
    'family_370',
    'family_789',
    'farbgruppierung_582',
    'farbgruppierung_590',
    'fuellung_52550',
    'fuellung_52816',
    'geschmack_23761',
    'geschmack_23781',
    'geschmack_26601',
    'geschmack_36384',
    'geschmack_54643',
    'grossen_32765',
    'grossen_35939',
    'grossen_47194',
    'hoehe_3066',
    'inschrift_22385',
    'materialgruppierung_1534',
    'materialgruppierung_2386',
    'materialgruppierung_3917',
    'materialgruppierung_3960',
    'modelname_22795',
    'modelname_24471',
    'modelname_24472',
    'modelname_24501',
    'modelname_24661',
    'modelname_25372',
    'modelname_25636',
    'modelname_25644',
    'modelname_25652',
    'modelname_25660',
    'modelname_26359',
    'modelname_27883',
    'modelname_27885',
    'modelname_30251',
    'modelname_30252',
    'modelname_30305',
    'modelname_30390',
    'modelname_32482',
    'modelname_32483',
    'modelname_32486',
    'modelname_32490',
    'modelname_32492',
    'modelname_32506',
    'modelname_32510',
    'modelname_32511',
    'modelname_32516',
    'modelname_32521',
    'modelname_32523',
    'modelname_32524',
    'modelname_32525',
    'modelname_32532',
    'modelname_32537',
    'modelname_32538',
    'modelname_32539',
    'modelname_32540',
    'modelname_32541',
    'modelname_32542',
    'modelname_32544',
    'modelname_32545',
    'modelname_32546',
    'modelname_32547',
    'modelname_32548',
    'modelname_32550',
    'modelname_32552',
    'modelname_32553',
    'modelname_32554',
    'modelname_32555',
    'modelname_32556',
    'modelname_32769',
    'modelname_38192',
    'modelname_41231',
    'modelname_41233',
    'modelname_50900',
    'modelname_52170',
    'modelname_53421',
    'modelname_53431',
    'modelname_53732',
    'modelname_53737',
    'modelname_53739',
    'modelname_53742',
    'modelname_54532',
    'modelname_54534',
    'modelname_54536',
    'modelname_54587',
    'modelname_54588',
    'modelname_54589',
    'modelname_54590',
    'modelname_54591',
    'modelname_55321',
    'modelname_55323',
    'modelname_55324',
    'modelname_55328',
    'modelname_55329',
    'modelname_55330',
    'modelname_55351',
    'modelname_55353',
    'modelname_55354',
    'modelname_55355',
    'modelname_55356',
    'modelname_55357',
    'modelname_55358',
    'modelname_55359',
    'modelname_55360',
    'modelname_55362',
    'modelname_55363',
    'modelname_55364',
    'modelname_55499',
    'modelname_55501',
    'modelname_55506',
    'modelname_55515',
    'modelname_55521',
    'modelname_55522',
    'modelname_55526',
    'modelname_55530',
    'modelname_55532',
    'modelname_55534',
    'modelname_55535',
    'modelname_55542',
    'modelname_55547',
    'modelname_55548',
    'modelname_55551',
    'modelname_55554',
    'modelname_55557',
    'modelname_55573',
    'modelname_55574',
    'modelname_55588',
    'modelname_55589',
    'modelname_55590',
    'modelname_55591',
    'modelname_55592',
    'muster_28340',
    'muster_4585',
    'muster_474',
    'sorte_51687',
    'stil_4873',
    'vendor_1409',
    'vendor_186',
    'vendor_216',
    'vendor_316',
    'vendor_695',
    'verpackung_3154',
    'verpackung_3653',
    'volumen_2411'
  )
  AND a.is_filterable = true

SELECT a.id as group_id, a.code, a.name_ru, a.name_de, a.sort, 
			a.is_metric, a.is_deeplink, a.is_filterable, a.use_deeplink_code, 
			a.group_sort, a.group_name_ru, a.group_name_de,
			av.uid as value_id,  av.name_ru as value_ru, av.name_de as value_de
FROM attribute_value AS av
JOIN attribute AS a on a.code = av.code
WHERE av.uid IN('netto_gewicht_filter_3','verpackung_3948','family_62','materialgruppierung_23844','netto_gewicht_filter_5','groesse_3393','groesse_3394','geschlecht_65','farbgruppierung_579','serie_53664','feiertage_822','coolbox_filter_0','freezebox_filter_3','feiertage_819','feiertage_826','family_693','farbgruppierung_578','geschlecht_66','art_der_suessigkeiten_34384','feiertage_960','feiertage_823','verpackung_4003','family_61','family_418','feiertage_820','hoehe_3085','materialgruppierung_1535','netto_gewicht_filter_4','netto_gewicht_filter_6','volumen_2164','feiertage_1130','feiertage_825','fuellung_39832','netto_fuellmenge_filter_5','altergruppierung_6272','farbgruppierung_576','fuellung_36388','geschlecht_69','geschmack_23757','verpackung_2954','beschriftungssprache_25379','geschmack_26932','geschmack_29768','vendor_1240','art_2163','geschlecht_68','inschrift_22369','inschrift_22370','inschrift_22440','inschrift_23488','modelname_22823','modelname_22824','modelname_22825','modelname_22826','modelname_22827','modelname_22828','modelname_32417','modelname_32418','modelname_32419','modelname_32420','modelname_32421','modelname_32423','modelname_32424','modelname_32425','modelname_36717','muster_473','vendor_267','verpackung_3121','farbgruppierung_2835','farbgruppierung_586','fuellung_39590','geschmack_29765','inschrift_22405','inschrift_32549','inschrift_32557','modelname_32422','netto_gewicht_filter_1','vendor_1508','vendor_156','vendor_196','anzahl_der_artikel_2680','family_27','family_376','farbgruppierung_587','form_2154','geschmack_23783','grossen_54132','handelsform_3535','inschrift_26753','inschrift_32534','inschrift_32551','inschrift_32558','inschrift_32559','materialgruppierung_1527','muster_8100','netto_gewicht_filter_2','serie_55565','sorte_15484','sorte_3536','verpackung_2870','verpackung_35918','volumen_der_tasse_40912','anzahl_der_artikel_2683','art_26280','art_26281','art_der_suessigkeiten_35208','art_der_suessigkeiten_40018','family_185','family_335','family_370','family_789','farbgruppierung_582','farbgruppierung_590','fuellung_52550','fuellung_52816','geschmack_23761','geschmack_23781','geschmack_26601','geschmack_36384','geschmack_54643','grossen_32765','grossen_35939','grossen_47194','hoehe_3066','inschrift_22385','materialgruppierung_1534','materialgruppierung_2386','materialgruppierung_3917','materialgruppierung_3960','modelname_22795','modelname_24471','modelname_24472','modelname_24501','modelname_24661','modelname_25372','modelname_25636','modelname_25644','modelname_25652','modelname_25660','modelname_26359','modelname_27883','modelname_27885','modelname_30251','modelname_30252','modelname_30305','modelname_30390','modelname_32482','modelname_32483','modelname_32486','modelname_32490','modelname_32492','modelname_32506','modelname_32510','modelname_32511','modelname_32516','modelname_32521','modelname_32523','modelname_32524','modelname_32525','modelname_32532','modelname_32537','modelname_32538','modelname_32539','modelname_32540','modelname_32541','modelname_32542','modelname_32544','modelname_32545','modelname_32546','modelname_32547','modelname_32548','modelname_32550','modelname_32552','modelname_32553','modelname_32554','modelname_32555','modelname_32556','modelname_32769','modelname_38192','modelname_41231','modelname_41233','modelname_50900','modelname_52170','modelname_53421','modelname_53431','modelname_53732','modelname_53737','modelname_53739','modelname_53742','modelname_54532','modelname_54534','modelname_54536','modelname_54587','modelname_54588','modelname_54589','modelname_54590','modelname_54591','modelname_55321','modelname_55323','modelname_55324','modelname_55328','modelname_55329','modelname_55330','modelname_55351','modelname_55353','modelname_55354','modelname_55355','modelname_55356','modelname_55357','modelname_55358','modelname_55359','modelname_55360','modelname_55362','modelname_55363','modelname_55364','modelname_55499','modelname_55501','modelname_55506','modelname_55515','modelname_55521','modelname_55522','modelname_55526','modelname_55530','modelname_55532','modelname_55534','modelname_55535','modelname_55542','modelname_55547','modelname_55548','modelname_55551','modelname_55554','modelname_55557','modelname_55573','modelname_55574','modelname_55588','modelname_55589','modelname_55590','modelname_55591','modelname_55592','muster_28340','muster_4585','muster_474','sorte_51687','stil_4873','vendor_1409','vendor_186','vendor_216','vendor_316','vendor_695','verpackung_3154','verpackung_3653','volumen_2411') AND  a.is_filterable = true;

SELECT
  l0_.id AS id_0,
  l0_.category_id AS category_id_1,
  l0_.slug AS slug_2,
  l0_.name AS name_3,
  l0_.status AS status_4,
  l0_.start_at AS start_at_5,
  l0_.end_at AS end_at_6,
  l0_.custom_css AS custom_css_7,
  l0_.preview_token AS preview_token_8,
  l0_.created_at AS created_at_9,
  l0_.updated_at AS updated_at_10
FROM
  landing_pages l0_
WHERE
  l0_.category_id = ?
  AND l0_.status = ?
  AND (
    l0_.start_at IS NULL
    OR l0_.start_at <= ?
  )
  AND (
    l0_.end_at IS NULL
    OR l0_.end_at > ?
  )
LIMIT
  1

SELECT l0_.id AS id_0, l0_.category_id AS category_id_1, l0_.slug AS slug_2, l0_.name AS name_3, l0_.status AS status_4, l0_.start_at AS start_at_5, l0_.end_at AS end_at_6, l0_.custom_css AS custom_css_7, l0_.preview_token AS preview_token_8, l0_.created_at AS created_at_9, l0_.updated_at AS updated_at_10 FROM landing_pages l0_ WHERE l0_.category_id = 1576 AND l0_.status = 'published' AND (l0_.start_at IS NULL OR l0_.start_at <= '2026-07-25 19:02:22') AND (l0_.end_at IS NULL OR l0_.end_at > '2026-07-25 19:02:22') LIMIT 1;

SELECT
  b0_.id AS id_0,
  b0_.tracking_code AS tracking_code_1,
  b0_.title AS title_2,
  b0_.banner_type AS banner_type_3,
  b0_.banner_order AS banner_order_4,
  b0_.image_path AS image_path_5,
  b0_.destination AS destination_6,
  b0_.category_include AS category_include_7,
  b0_.category_exclude AS category_exclude_8,
  b0_.date_start AS date_start_9,
  b0_.date_end AS date_end_10,
  b0_.options AS options_11
FROM
  banners b0_
WHERE
  b0_.banner_type = ?
  AND b0_.date_start < ?
  AND (
    b0_.date_end > ?
    OR b0_.date_end IS NULL
  )

SELECT b0_.id AS id_0, b0_.tracking_code AS tracking_code_1, b0_.title AS title_2, b0_.banner_type AS banner_type_3, b0_.banner_order AS banner_order_4, b0_.image_path AS image_path_5, b0_.destination AS destination_6, b0_.category_include AS category_include_7, b0_.category_exclude AS category_exclude_8, b0_.date_start AS date_start_9, b0_.date_end AS date_end_10, b0_.options AS options_11 FROM banners b0_ WHERE b0_.banner_type = 'top_full_width' AND b0_.date_start < '2026-07-25 19:02:22' AND (b0_.date_end > '2026-07-25 19:02:22' OR b0_.date_end IS NULL);

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.category_order AS category_order_3,
  t0.title_ru AS title_ru_4,
  t0.title_de AS title_de_5,
  t0.url_ru AS url_ru_6,
  t0.url_de AS url_de_7,
  t0.date_start AS date_start_8,
  t0.date_end AS date_end_9,
  t0.options AS options_10
FROM
  category_menu t0
WHERE
  t0.type IN (?, ?, ?, ?)

SELECT t0.id AS id_1, t0.type AS type_2, t0.category_order AS category_order_3, t0.title_ru AS title_ru_4, t0.title_de AS title_de_5, t0.url_ru AS url_ru_6, t0.url_de AS url_de_7, t0.date_start AS date_start_8, t0.date_end AS date_end_9, t0.options AS options_10 FROM category_menu t0 WHERE t0.type IN ('menu_main', 'top_amount', 'top_sold', 'sale');

SELECT
  b0_.id AS id_0,
  b0_.tracking_code AS tracking_code_1,
  b0_.title AS title_2,
  b0_.banner_type AS banner_type_3,
  b0_.banner_order AS banner_order_4,
  b0_.image_path AS image_path_5,
  b0_.destination AS destination_6,
  b0_.category_include AS category_include_7,
  b0_.category_exclude AS category_exclude_8,
  b0_.date_start AS date_start_9,
  b0_.date_end AS date_end_10,
  b0_.options AS options_11
FROM
  banners b0_
WHERE
  b0_.banner_type = ?
  AND b0_.date_start < ?
  AND (
    b0_.date_end > ?
    OR b0_.date_end IS NULL
  )

SELECT b0_.id AS id_0, b0_.tracking_code AS tracking_code_1, b0_.title AS title_2, b0_.banner_type AS banner_type_3, b0_.banner_order AS banner_order_4, b0_.image_path AS image_path_5, b0_.destination AS destination_6, b0_.category_include AS category_include_7, b0_.category_exclude AS category_exclude_8, b0_.date_start AS date_start_9, b0_.date_end AS date_end_10, b0_.options AS options_11 FROM banners b0_ WHERE b0_.banner_type = 'top_promo' AND b0_.date_start < '2026-07-25 19:02:22' AND (b0_.date_end > '2026-07-25 19:02:22' OR b0_.date_end IS NULL);

SELECT
  b0_.id AS id_0,
  b0_.tracking_code AS tracking_code_1,
  b0_.title AS title_2,
  b0_.banner_type AS banner_type_3,
  b0_.banner_order AS banner_order_4,
  b0_.image_path AS image_path_5,
  b0_.destination AS destination_6,
  b0_.category_include AS category_include_7,
  b0_.category_exclude AS category_exclude_8,
  b0_.date_start AS date_start_9,
  b0_.date_end AS date_end_10,
  b0_.options AS options_11
FROM
  banners b0_
WHERE
  b0_.banner_type = ?
  AND b0_.date_start < ?
  AND (
    b0_.date_end > ?
    OR b0_.date_end IS NULL
  )

SELECT b0_.id AS id_0, b0_.tracking_code AS tracking_code_1, b0_.title AS title_2, b0_.banner_type AS banner_type_3, b0_.banner_order AS banner_order_4, b0_.image_path AS image_path_5, b0_.destination AS destination_6, b0_.category_include AS category_include_7, b0_.category_exclude AS category_exclude_8, b0_.date_start AS date_start_9, b0_.date_end AS date_end_10, b0_.options AS options_11 FROM banners b0_ WHERE b0_.banner_type = 'category' AND b0_.date_start < '2026-07-25 19:02:22' AND (b0_.date_end > '2026-07-25 19:02:22' OR b0_.date_end IS NULL);

SELECT
  b0_.id AS id_0,
  b0_.tracking_code AS tracking_code_1,
  b0_.title AS title_2,
  b0_.banner_type AS banner_type_3,
  b0_.banner_order AS banner_order_4,
  b0_.image_path AS image_path_5,
  b0_.destination AS destination_6,
  b0_.category_include AS category_include_7,
  b0_.category_exclude AS category_exclude_8,
  b0_.date_start AS date_start_9,
  b0_.date_end AS date_end_10,
  b0_.options AS options_11
FROM
  banners b0_
WHERE
  b0_.banner_type = ?
  AND b0_.date_start < ?
  AND (
    b0_.date_end > ?
    OR b0_.date_end IS NULL
  )

SELECT b0_.id AS id_0, b0_.tracking_code AS tracking_code_1, b0_.title AS title_2, b0_.banner_type AS banner_type_3, b0_.banner_order AS banner_order_4, b0_.image_path AS image_path_5, b0_.destination AS destination_6, b0_.category_include AS category_include_7, b0_.category_exclude AS category_exclude_8, b0_.date_start AS date_start_9, b0_.date_end AS date_end_10, b0_.options AS options_11 FROM banners b0_ WHERE b0_.banner_type = 'menu' AND b0_.date_start < '2026-07-25 19:02:23' AND (b0_.date_end > '2026-07-25 19:02:23' OR b0_.date_end IS NULL);

SELECT
  b0_.id AS id_0,
  b0_.tracking_code AS tracking_code_1,
  b0_.title AS title_2,
  b0_.banner_type AS banner_type_3,
  b0_.banner_order AS banner_order_4,
  b0_.image_path AS image_path_5,
  b0_.destination AS destination_6,
  b0_.category_include AS category_include_7,
  b0_.category_exclude AS category_exclude_8,
  b0_.date_start AS date_start_9,
  b0_.date_end AS date_end_10,
  b0_.options AS options_11
FROM
  banners b0_
WHERE
  b0_.banner_type = ?
  AND b0_.date_start < ?
  AND (
    b0_.date_end > ?
    OR b0_.date_end IS NULL
  )

SELECT b0_.id AS id_0, b0_.tracking_code AS tracking_code_1, b0_.title AS title_2, b0_.banner_type AS banner_type_3, b0_.banner_order AS banner_order_4, b0_.image_path AS image_path_5, b0_.destination AS destination_6, b0_.category_include AS category_include_7, b0_.category_exclude AS category_exclude_8, b0_.date_start AS date_start_9, b0_.date_end AS date_end_10, b0_.options AS options_11 FROM banners b0_ WHERE b0_.banner_type = 'menu_top' AND b0_.date_start < '2026-07-25 19:02:23' AND (b0_.date_end > '2026-07-25 19:02:23' OR b0_.date_end IS NULL);

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.category_order AS category_order_3,
  t0.title_ru AS title_ru_4,
  t0.title_de AS title_de_5,
  t0.url_ru AS url_ru_6,
  t0.url_de AS url_de_7,
  t0.date_start AS date_start_8,
  t0.date_end AS date_end_9,
  t0.options AS options_10
FROM
  category_menu t0
WHERE
  t0.type = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.category_order AS category_order_3, t0.title_ru AS title_ru_4, t0.title_de AS title_de_5, t0.url_ru AS url_ru_6, t0.url_de AS url_de_7, t0.date_start AS date_start_8, t0.date_end AS date_end_9, t0.options AS options_10 FROM category_menu t0 WHERE t0.type = 'menu_mobile';