Symfony Profiler

SELECT
  (c0_.id) AS sclr_0,
  (c0_.name) AS sclr_1,
  (c0_.parent_id) AS sclr_2,
  (c0_.products_number) AS sclr_3,
  (c0_.slug) AS sclr_4,
  (c0_.sort) AS sclr_5,
  (c0_.icon) AS sclr_6,
  (c0_.image) AS sclr_7
FROM
  category c0_
WHERE
  c0_.visible = 1
ORDER BY
  c0_.sort ASC

SELECT (c0_.id) AS sclr_0, (c0_.name) AS sclr_1, (c0_.parent_id) AS sclr_2, (c0_.products_number) AS sclr_3, (c0_.slug) AS sclr_4, (c0_.sort) AS sclr_5, (c0_.icon) AS sclr_6, (c0_.image) AS sclr_7 FROM category c0_ WHERE c0_.visible = 1 ORDER BY c0_.sort ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.postal_code AS postal_code_3,
  t0.kladr AS kladr_4,
  t0.fias AS fias_5,
  t0.oktmo AS oktmo_6,
  t0.time_zone AS time_zone_7,
  t0.latitude AS latitude_8,
  t0.longitude AS longitude_9,
  t0.population AS population_10,
  t0.full_address AS full_address_11,
  t0.okato AS okato_12,
  t0.country AS country_13,
  t0.region_id AS region_id_14,
  t0.delivery_zone_id AS delivery_zone_id_15
FROM
  city t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.postal_code AS postal_code_3, t0.kladr AS kladr_4, t0.fias AS fias_5, t0.oktmo AS oktmo_6, t0.time_zone AS time_zone_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.population AS population_10, t0.full_address AS full_address_11, t0.okato AS okato_12, t0.country AS country_13, t0.region_id AS region_id_14, t0.delivery_zone_id AS delivery_zone_id_15 FROM city t0 WHERE t0.id = 0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.postal_code AS postal_code_3,
  t0.kladr AS kladr_4,
  t0.fias AS fias_5,
  t0.oktmo AS oktmo_6,
  t0.time_zone AS time_zone_7,
  t0.latitude AS latitude_8,
  t0.longitude AS longitude_9,
  t0.population AS population_10,
  t0.full_address AS full_address_11,
  t0.okato AS okato_12,
  t0.country AS country_13,
  t0.region_id AS region_id_14,
  t0.delivery_zone_id AS delivery_zone_id_15
FROM
  city t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.postal_code AS postal_code_3, t0.kladr AS kladr_4, t0.fias AS fias_5, t0.oktmo AS oktmo_6, t0.time_zone AS time_zone_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.population AS population_10, t0.full_address AS full_address_11, t0.okato AS okato_12, t0.country AS country_13, t0.region_id AS region_id_14, t0.delivery_zone_id AS delivery_zone_id_15 FROM city t0 WHERE t0.id = 1;

SELECT
  p0_.id AS id_0,
  p0_.is_active AS is_active_1,
  p0_.date_from AS date_from_2,
  p0_.date_to AS date_to_3,
  p0_.name AS name_4,
  p0_.config AS config_5,
  p0_.type AS type_6,
  p0_.product_label_id AS product_label_id_7
FROM
  promotion p0_
WHERE
  (
    p0_.is_active = 1
    AND p0_.date_to >= ?
    AND p0_.date_from <= ?
  )
  AND p0_.type IN (
    'profit_set', 'registered_customer',
    'even_less_price', 'discount_on_products'
  )

SELECT p0_.id AS id_0, p0_.is_active AS is_active_1, p0_.date_from AS date_from_2, p0_.date_to AS date_to_3, p0_.name AS name_4, p0_.config AS config_5, p0_.type AS type_6, p0_.product_label_id AS product_label_id_7 FROM promotion p0_ WHERE (p0_.is_active = 1 AND p0_.date_to >= '2026-02-04 06:46:29' AND p0_.date_from <= '2026-02-04 06:46:29') AND p0_.type IN ('profit_set', 'registered_customer', 'even_less_price', 'discount_on_products');

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.visible AS visible_3,
  t0.slug AS slug_4,
  t0.sort AS sort_5,
  t0.products_number AS products_number_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.image AS image_9,
  t0.icon AS icon_10,
  t0.level AS level_11,
  t0.filter_properties AS filter_properties_12,
  t0.product_properties AS product_properties_13,
  t0.parent_id AS parent_id_14,
  t0.content_id AS content_id_15
FROM
  category t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.visible AS visible_3, t0.slug AS slug_4, t0.sort AS sort_5, t0.products_number AS products_number_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.image AS image_9, t0.icon AS icon_10, t0.level AS level_11, t0.filter_properties AS filter_properties_12, t0.product_properties AS product_properties_13, t0.parent_id AS parent_id_14, t0.content_id AS content_id_15 FROM category t0 WHERE t0.slug = 'odeyala-shelkovyye' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.meta_title AS meta_title_2,
  t0.meta_description AS meta_description_3,
  t0.h1 AS h1_4,
  t0.top_banner_img AS top_banner_img_5,
  t0.seo_text_top AS seo_text_top_6,
  t0.seo_text_bottom AS seo_text_bottom_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.top_banner_img_mobile AS top_banner_img_mobile_10,
  t0.top_banner_url AS top_banner_url_11
FROM
  products_list_content t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.h1 AS h1_4, t0.top_banner_img AS top_banner_img_5, t0.seo_text_top AS seo_text_top_6, t0.seo_text_bottom AS seo_text_bottom_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.top_banner_img_mobile AS top_banner_img_mobile_10, t0.top_banner_url AS top_banner_url_11 FROM products_list_content t0 WHERE t0.id = 73;

SELECT
  t0.id AS id_1,
  t0.object AS object_2,
  t0.title AS title_3,
  t0.description AS description_4,
  t0.h1 AS h1_5,
  t0.keywords AS keywords_6,
  t0.title_pagination AS title_pagination_7,
  t0.description_pagination AS description_pagination_8,
  t0.h1_pagination AS h1_pagination_9,
  t0.keywords_pagination AS keywords_pagination_10
FROM
  seo_template t0
WHERE
  t0.object = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.object AS object_2, t0.title AS title_3, t0.description AS description_4, t0.h1 AS h1_5, t0.keywords AS keywords_6, t0.title_pagination AS title_pagination_7, t0.description_pagination AS description_pagination_8, t0.h1_pagination AS h1_pagination_9, t0.keywords_pagination AS keywords_pagination_10 FROM seo_template t0 WHERE t0.object = 'category' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.visible AS visible_3,
  t0.slug AS slug_4,
  t0.sort AS sort_5,
  t0.products_number AS products_number_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.image AS image_9,
  t0.icon AS icon_10,
  t0.level AS level_11,
  t0.filter_properties AS filter_properties_12,
  t0.product_properties AS product_properties_13,
  t0.parent_id AS parent_id_14,
  t0.content_id AS content_id_15
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.visible AS visible_3, t0.slug AS slug_4, t0.sort AS sort_5, t0.products_number AS products_number_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.image AS image_9, t0.icon AS icon_10, t0.level AS level_11, t0.filter_properties AS filter_properties_12, t0.product_properties AS product_properties_13, t0.parent_id AS parent_id_14, t0.content_id AS content_id_15 FROM category t0 WHERE t0.id = 30;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.visible AS visible_3,
  t0.slug AS slug_4,
  t0.sort AS sort_5,
  t0.products_number AS products_number_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.image AS image_9,
  t0.icon AS icon_10,
  t0.level AS level_11,
  t0.filter_properties AS filter_properties_12,
  t0.product_properties AS product_properties_13,
  t0.parent_id AS parent_id_14,
  t0.content_id AS content_id_15
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.visible AS visible_3, t0.slug AS slug_4, t0.sort AS sort_5, t0.products_number AS products_number_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.image AS image_9, t0.icon AS icon_10, t0.level AS level_11, t0.filter_properties AS filter_properties_12, t0.product_properties AS product_properties_13, t0.parent_id AS parent_id_14, t0.content_id AS content_id_15 FROM category t0 WHERE t0.id = 1;

SELECT
  p0_.id AS id_0,
  p0_.alias AS alias_1,
  p0_.title AS title_2,
  p0_.values_sort AS values_sort_3
FROM
  property p0_
WHERE
  p0_.id IN (
    '9', '1', '26', '2', '7', '4', '20', '5',
    '10', '8', '12'
  )

SELECT p0_.id AS id_0, p0_.alias AS alias_1, p0_.title AS title_2, p0_.values_sort AS values_sort_3 FROM property p0_ WHERE p0_.id IN ('9', '1', '26', '2', '7', '4', '20', '5', '10', '8', '12');

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1
FROM
  property_value p0_
WHERE
  p0_.id IN (
    638, 27, 87, 56, 7, 3837922, 8, 32, 154,
    95, 73, 3155, 19, 644, 3839608, 3840162,
    471, 503, 163, 3840163, 1182, 3846941,
    13, 330, 3261, 61, 3839579, 3845978,
    3841856, 65, 1037876, 750, 696, 641,
    897, 3839638, 3846952, 3846989, 3846990,
    116, 15, 31, 40, 70, 209, 3840170, 1470838,
    2286, 537, 1424364, 3839558, 3846094,
    3846991, 3847035, 121, 2278, 2281,
    2911, 3840166, 3840168, 3840172, 3840575,
    3841859, 3845229, 4468, 46, 469, 904,
    383, 805, 997, 1153, 1593, 165, 175,
    185, 271, 33, 75, 1827, 3840165, 3840167,
    3840171, 3841857, 3841858, 462735,
    472, 547679, 682, 7742, 792, 3065, 1101,
    1259591, 1693760, 2048734, 2456834,
    24681, 3183038, 346155, 3842502, 3843875,
    3845223, 3847362, 3847715, 4373, 5545,
    6070, 4367, 59, 144, 14, 2285, 2378,
    30, 314, 3945, 547, 693, 4941, 3536,
    0
  )

SELECT p0_.id AS id_0, p0_.title AS title_1 FROM property_value p0_ WHERE p0_.id IN (638, 27, 87, 56, 7, 3837922, 8, 32, 154, 95, 73, 3155, 19, 644, 3839608, 3840162, 471, 503, 163, 3840163, 1182, 3846941, 13, 330, 3261, 61, 3839579, 3845978, 3841856, 65, 1037876, 750, 696, 641, 897, 3839638, 3846952, 3846989, 3846990, 116, 15, 31, 40, 70, 209, 3840170, 1470838, 2286, 537, 1424364, 3839558, 3846094, 3846991, 3847035, 121, 2278, 2281, 2911, 3840166, 3840168, 3840172, 3840575, 3841859, 3845229, 4468, 46, 469, 904, 383, 805, 997, 1153, 1593, 165, 175, 185, 271, 33, 75, 1827, 3840165, 3840167, 3840171, 3841857, 3841858, 462735, 472, 547679, 682, 7742, 792, 3065, 1101, 1259591, 1693760, 2048734, 2456834, 24681, 3183038, 346155, 3842502, 3843875, 3845223, 3847362, 3847715, 4373, 5545, 6070, 4367, 59, 144, 14, 2285, 2378, 30, 314, 3945, 547, 693, 4941, 3536, 0);

SELECT
  p0_.property_id AS sclr_0,
  p0_.value_id AS sclr_1,
  p0_.product_id AS sclr_2
FROM
  product_property p0_
WHERE
  p0_.product_id IN (
    '4883', '4884', '13552', '14135', '16811',
    '18439', '22540', '22542', '30813',
    '30814', '30815', '30816', '31870',
    '34298', '34299', '34300'
  )

SELECT p0_.property_id AS sclr_0, p0_.value_id AS sclr_1, p0_.product_id AS sclr_2 FROM product_property p0_ WHERE p0_.product_id IN ('4883', '4884', '13552', '14135', '16811', '18439', '22540', '22542', '30813', '30814', '30815', '30816', '31870', '34298', '34299', '34300');

SELECT
  p0_.id AS id_0,
  b1_.image AS image_1
FROM
  property_value p0_
  INNER JOIN brand b1_ ON (b1_.uid = p0_.uid)
WHERE
  p0_.id IN (
    3839608, 3840162, 3839579, 3839638,
    3839558
  )

SELECT p0_.id AS id_0, b1_.image AS image_1 FROM property_value p0_ INNER JOIN brand b1_ ON (b1_.uid = p0_.uid) WHERE p0_.id IN (3839608, 3840162, 3839579, 3839638, 3839558);

SELECT
  p0_.id AS id_0,
  p0_.text AS text_1,
  p0_.color AS color_2,
  p0_.visible AS visible_3,
  p0_.priority AS priority_4,
  p0_.type AS type_5
FROM
  product_label p0_
WHERE
  p0_.type <> ?
  AND p0_.visible = 1

SELECT p0_.id AS id_0, p0_.text AS text_1, p0_.color AS color_2, p0_.visible AS visible_3, p0_.priority AS priority_4, p0_.type AS type_5 FROM product_label p0_ WHERE p0_.type <> 'custom' AND p0_.visible = 1;

SELECT
  plp.product_id,
  pl.text,
  pl.color,
  pl.priority,
  pl.type
FROM
  product_label_product plp
  join product_label pl on pl.id = plp.product_label_id
WHERE
  plp.product_id IN (
    4884, 34299, 4883, 14135, 18439, 34298,
    34300
  )
  AND pl.visible = 1
ORDER BY
  plp.product_id,
  pl.priority DESC

SELECT plp.product_id,pl.text,pl.color,pl.priority,pl.type 
                    FROM product_label_product plp join product_label pl on pl.id = plp.product_label_id
                    WHERE plp.product_id IN (4884,34299,4883,14135,18439,34298,34300) AND pl.visible=1 ORDER BY plp.product_id,pl.priority DESC;

SELECT
  te.id AS id,
  te.name AS name,
  te.slug AS slug,
  te.created_at AS created_at,
  te.updated_at AS updated_at,
  te.conditions AS conditions,
  te.visible AS visible,
  te.short_name AS short_name,
  te.image AS image,
  te.filter_properties AS filter_properties,
  te.products_count AS products_count,
  te.content_id AS content_id
FROM
  virtual_category te
  JOIN virtual_category_category t ON t.virtual_category_id = te.id
WHERE
  t.category_id = ?
  AND te.visible = ?
  AND te.products_count > ?

SELECT te.id AS id, te.name AS name, te.slug AS slug, te.created_at AS created_at, te.updated_at AS updated_at, te.conditions AS conditions, te.visible AS visible, te.short_name AS short_name, te.image AS image, te.filter_properties AS filter_properties, te.products_count AS products_count, te.content_id AS content_id FROM virtual_category te JOIN virtual_category_category t ON t.virtual_category_id = te.id WHERE t.category_id = 46 AND te.visible = 1 AND te.products_count > 0;

SELECT
  te.id AS id,
  te.name AS name,
  te.visible AS visible,
  te.slug AS slug,
  te.sort AS sort,
  te.products_number AS products_number,
  te.created_at AS created_at,
  te.updated_at AS updated_at,
  te.image AS image,
  te.icon AS icon,
  te.level AS level,
  te.filter_properties AS filter_properties,
  te.product_properties AS product_properties,
  te.parent_id AS parent_id,
  te.content_id AS content_id
FROM
  category te
  JOIN category_category_to_tag t ON t.category_source = te.id
WHERE
  t.category_target = ?
  AND te.visible = ?
  AND te.products_number > ?

SELECT te.id AS id, te.name AS name, te.visible AS visible, te.slug AS slug, te.sort AS sort, te.products_number AS products_number, te.created_at AS created_at, te.updated_at AS updated_at, te.image AS image, te.icon AS icon, te.level AS level, te.filter_properties AS filter_properties, te.product_properties AS product_properties, te.parent_id AS parent_id, te.content_id AS content_id FROM category te JOIN category_category_to_tag t ON t.category_source = te.id WHERE t.category_target = 46 AND te.visible = 1 AND te.products_number > 0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.content AS content_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.content_head AS content_head_6
FROM
  ext_script t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.content_head AS content_head_6 FROM ext_script t0;