Symfony Profiler

SELECT
  DISTINCT k.CONSTRAINT_NAME,
  k.COLUMN_NAME,
  k.REFERENCED_TABLE_NAME,
  k.REFERENCED_COLUMN_NAME,
  k.ORDINAL_POSITION
  /*!50116,
              c.UPDATE_RULE,
              c.DELETE_RULE */
FROM
  information_schema.key_column_usage k
  /*!50116
  INNER JOIN information_schema.referential_constraints c
  ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
  AND c.TABLE_NAME = k.TABLE_NAME
  AND c.CONSTRAINT_SCHEMA = k.TABLE_SCHEMA */
WHERE
  k.TABLE_SCHEMA = ?
  AND k.TABLE_NAME = ?
  AND k.REFERENCED_COLUMN_NAME IS NOT NULL
ORDER BY
  k.ORDINAL_POSITION

SELECT DISTINCT            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION /*!50116,
            c.UPDATE_RULE,
            c.DELETE_RULE */
FROM information_schema.key_column_usage k /*!50116
INNER JOIN information_schema.referential_constraints c
ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
AND c.TABLE_NAME = k.TABLE_NAME
AND c.CONSTRAINT_SCHEMA = k.TABLE_SCHEMA */ WHERE k.TABLE_SCHEMA = 'test' AND k.TABLE_NAME = 'doctrine_migration_versions' AND k.REFERENCED_COLUMN_NAME IS NOT NULL ORDER BY k.ORDINAL_POSITION;

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'test'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

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 (0, 29174, 29176, 29178, 29181)

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 (0, 29174, 29176, 29178, 29181);

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  t0.id AS id_1,
  t0.info_block AS info_block_2,
  t0.url AS url_3,
  t0.anchor AS anchor_4,
  t0.position AS position_5,
  t0.visible AS visible_6
FROM
  info_block_link t0
WHERE
  t0.info_block = ?
  AND t0.visible = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.info_block AS info_block_2, t0.url AS url_3, t0.anchor AS anchor_4, t0.position AS position_5, t0.visible AS visible_6 FROM info_block_link t0 WHERE t0.info_block = 'catalog' AND t0.visible = 1 ORDER BY t0.position ASC;

SELECT
  p0_.property_id AS sclr_0,
  p0_.value_id AS sclr_1,
  p1_.id AS id_2
FROM
  product p1_
  INNER JOIN product_property p0_ ON p1_.id = p0_.product_id
WHERE
  p1_.id IN (0, 29174, 29176, 29178, 29181)

SELECT p0_.property_id AS sclr_0, p0_.value_id AS sclr_1, p1_.id AS id_2 FROM product p1_ INNER JOIN product_property p0_ ON p1_.id = p0_.product_id WHERE p1_.id IN (0, 29174, 29176, 29178, 29181);

SELECT
  t.TABLE_NAME,
  t.ENGINE,
  t.AUTO_INCREMENT,
  t.TABLE_COMMENT,
  t.CREATE_OPTIONS,
  t.TABLE_COLLATION,
  ccsa.CHARACTER_SET_NAME
FROM
  information_schema.TABLES t
  INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION
WHERE
  t.TABLE_SCHEMA = ?
  AND t.TABLE_NAME = ?
  AND t.TABLE_TYPE = 'BASE TABLE'

SELECT t.TABLE_NAME,
           t.ENGINE,
           t.AUTO_INCREMENT,
           t.TABLE_COMMENT,
           t.CREATE_OPTIONS,
           t.TABLE_COLLATION,
           ccsa.CHARACTER_SET_NAME
      FROM information_schema.TABLES t
        INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
            ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = 'test' AND t.TABLE_NAME = 'doctrine_migration_versions' AND t.TABLE_TYPE = 'BASE TABLE';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.updated_at AS updated_at_4,
  t0.code AS code_5,
  t0.sort AS sort_6,
  t0.help_text AS help_text_7,
  t0.visible AS visible_8
FROM
  settings t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated_at AS updated_at_4, t0.code AS code_5, t0.sort AS sort_6, t0.help_text AS help_text_7, t0.visible AS visible_8 FROM settings t0 WHERE t0.code = 'registration_bonus' LIMIT 1;

SELECT
  COLUMN_NAME AS field,
  COLUMN_TYPE AS type,
  IS_NULLABLE AS `null`,
  COLUMN_KEY AS `key`,
  COLUMN_DEFAULT AS `default`,
  EXTRA,
  COLUMN_COMMENT AS comment,
  CHARACTER_SET_NAME AS characterset,
  COLLATION_NAME AS collation
FROM
  information_schema.COLUMNS
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_NAME = ?
ORDER BY
  ORDINAL_POSITION

SELECT       COLUMN_NAME        AS field,
       COLUMN_TYPE        AS type,
       IS_NULLABLE        AS `null`,
       COLUMN_KEY         AS `key`,
       COLUMN_DEFAULT     AS `default`,
       EXTRA,
       COLUMN_COMMENT     AS comment,
       CHARACTER_SET_NAME AS characterset,
       COLLATION_NAME     AS collation
FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'test' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image AS image_4,
  t0.uid AS uid_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.markers AS markers_8,
  t0.meta_title AS meta_title_9,
  t0.meta_description AS meta_description_10,
  t0.content AS content_11,
  t0.filter_properties AS filter_properties_12
FROM
  brand t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.uid AS uid_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.markers AS markers_8, t0.meta_title AS meta_title_9, t0.meta_description AS meta_description_10, t0.content AS content_11, t0.filter_properties AS filter_properties_12 FROM brand t0 WHERE t0.slug = 'lab-fragrans' LIMIT 1;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.visible AS visible_1,
          p0_.name AS name_2,
          p0_.sku AS sku_3,
          p0_.description AS description_4,
          p0_.main_image AS main_image_5,
          p0_.uid AS uid_6,
          p0_.characteristic AS characteristic_7,
          p0_.created_at AS created_at_8,
          p0_.updated_at AS updated_at_9,
          p0_.created_at_in1_c AS created_at_in1_c_10,
          p0_.price AS price_11,
          p0_.old_price AS old_price_12,
          p0_.bonus AS bonus_13,
          p0_.slug AS slug_14,
          p0_.images AS images_15,
          p0_.number_of_orders AS number_of_orders_16,
          p0_.is_new AS is_new_17,
          p0_.is_hit AS is_hit_18,
          p0_.is_gift AS is_gift_19,
          p0_.is_new_year AS is_new_year_20,
          p0_.full_title AS full_title_21,
          p0_.discount_percent AS discount_percent_22,
          p0_.balance_store AS balance_store_23,
          p0_.balance_warehouse AS balance_warehouse_24,
          p0_.old_slug AS old_slug_25,
          p0_.viewed AS viewed_26,
          p0_.code1c AS code1c_27,
          p0_.data AS data_28,
          p0_.on_demand AS on_demand_29,
          p0_.hash AS hash_30,
          p0_.reviews_number AS reviews_number_31,
          p0_.reviews_avg_score AS reviews_avg_score_32,
          p0_.group_uid AS group_uid_33,
          p0_.is_little_remains AS is_little_remains_34,
          p0_.common_group_name AS common_group_name_35
        FROM
          product p0_
        WHERE
          p0_.visible = 1
          AND p0_.id IN (29174, 29176, 29178, 29181)
        ORDER BY
          p0_.is_hit DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.visible AS visible_1, p0_.name AS name_2, p0_.sku AS sku_3, p0_.description AS description_4, p0_.main_image AS main_image_5, p0_.uid AS uid_6, p0_.characteristic AS characteristic_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p0_.created_at_in1_c AS created_at_in1_c_10, p0_.price AS price_11, p0_.old_price AS old_price_12, p0_.bonus AS bonus_13, p0_.slug AS slug_14, p0_.images AS images_15, p0_.number_of_orders AS number_of_orders_16, p0_.is_new AS is_new_17, p0_.is_hit AS is_hit_18, p0_.is_gift AS is_gift_19, p0_.is_new_year AS is_new_year_20, p0_.full_title AS full_title_21, p0_.discount_percent AS discount_percent_22, p0_.balance_store AS balance_store_23, p0_.balance_warehouse AS balance_warehouse_24, p0_.old_slug AS old_slug_25, p0_.viewed AS viewed_26, p0_.code1c AS code1c_27, p0_.data AS data_28, p0_.on_demand AS on_demand_29, p0_.hash AS hash_30, p0_.reviews_number AS reviews_number_31, p0_.reviews_avg_score AS reviews_avg_score_32, p0_.group_uid AS group_uid_33, p0_.is_little_remains AS is_little_remains_34, p0_.common_group_name AS common_group_name_35 FROM product p0_ WHERE p0_.visible = 1 AND p0_.id IN (29174, 29176, 29178, 29181) ORDER BY p0_.is_hit DESC) dctrn_result) dctrn_table;

SELECT
  p0_.id AS id_0
FROM
  product p0_
  LEFT JOIN brand b1_ ON p0_.brand_id = b1_.id
WHERE
  p0_.visible = 1
  AND b1_.id IN (364)

SELECT p0_.id AS id_0 FROM product p0_ LEFT JOIN brand b1_ ON p0_.brand_id = b1_.id WHERE p0_.visible = 1 AND b1_.id IN (364);

SELECT
  p0_.id AS id_0,
  p0_.visible AS visible_1,
  p0_.name AS name_2,
  p0_.sku AS sku_3,
  p0_.description AS description_4,
  p0_.main_image AS main_image_5,
  p0_.uid AS uid_6,
  p0_.characteristic AS characteristic_7,
  p0_.created_at AS created_at_8,
  p0_.updated_at AS updated_at_9,
  p0_.created_at_in1_c AS created_at_in1_c_10,
  p0_.price AS price_11,
  p0_.old_price AS old_price_12,
  p0_.bonus AS bonus_13,
  p0_.slug AS slug_14,
  p0_.images AS images_15,
  p0_.number_of_orders AS number_of_orders_16,
  p0_.is_new AS is_new_17,
  p0_.is_hit AS is_hit_18,
  p0_.is_gift AS is_gift_19,
  p0_.is_new_year AS is_new_year_20,
  p0_.full_title AS full_title_21,
  p0_.discount_percent AS discount_percent_22,
  p0_.balance_store AS balance_store_23,
  p0_.balance_warehouse AS balance_warehouse_24,
  p0_.old_slug AS old_slug_25,
  p0_.viewed AS viewed_26,
  p0_.code1c AS code1c_27,
  p0_.data AS data_28,
  p0_.on_demand AS on_demand_29,
  p0_.hash AS hash_30,
  p0_.reviews_number AS reviews_number_31,
  p0_.reviews_avg_score AS reviews_avg_score_32,
  p0_.group_uid AS group_uid_33,
  p0_.is_little_remains AS is_little_remains_34,
  p0_.common_group_name AS common_group_name_35,
  p0_.brand_id AS brand_id_36,
  p0_.size_id AS size_id_37,
  p0_.category1c_id AS category1c_id_38
FROM
  product p0_
WHERE
  p0_.visible = 1
  AND p0_.id IN (29174, 29176, 29178, 29181)
ORDER BY
  p0_.is_hit DESC
LIMIT
  64

SELECT p0_.id AS id_0, p0_.visible AS visible_1, p0_.name AS name_2, p0_.sku AS sku_3, p0_.description AS description_4, p0_.main_image AS main_image_5, p0_.uid AS uid_6, p0_.characteristic AS characteristic_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p0_.created_at_in1_c AS created_at_in1_c_10, p0_.price AS price_11, p0_.old_price AS old_price_12, p0_.bonus AS bonus_13, p0_.slug AS slug_14, p0_.images AS images_15, p0_.number_of_orders AS number_of_orders_16, p0_.is_new AS is_new_17, p0_.is_hit AS is_hit_18, p0_.is_gift AS is_gift_19, p0_.is_new_year AS is_new_year_20, p0_.full_title AS full_title_21, p0_.discount_percent AS discount_percent_22, p0_.balance_store AS balance_store_23, p0_.balance_warehouse AS balance_warehouse_24, p0_.old_slug AS old_slug_25, p0_.viewed AS viewed_26, p0_.code1c AS code1c_27, p0_.data AS data_28, p0_.on_demand AS on_demand_29, p0_.hash AS hash_30, p0_.reviews_number AS reviews_number_31, p0_.reviews_avg_score AS reviews_avg_score_32, p0_.group_uid AS group_uid_33, p0_.is_little_remains AS is_little_remains_34, p0_.common_group_name AS common_group_name_35, p0_.brand_id AS brand_id_36, p0_.size_id AS size_id_37, p0_.category1c_id AS category1c_id_38 FROM product p0_ WHERE p0_.visible = 1 AND p0_.id IN (29174, 29176, 29178, 29181) ORDER BY p0_.is_hit DESC LIMIT 64;

SELECT
  p0_.id AS id_0,
  c1_.id AS id_1
FROM
  product p0_
  INNER JOIN category_1c c2_ ON p0_.category1c_id = c2_.id
  INNER JOIN category_category1c c3_ ON c2_.id = c3_.category1c_id
  INNER JOIN category c1_ ON c1_.id = c3_.category_id
WHERE
  p0_.id IN (0, 29174, 29176, 29178, 29181)

SELECT p0_.id AS id_0, c1_.id AS id_1 FROM product p0_ INNER JOIN category_1c c2_ ON p0_.category1c_id = c2_.id INNER JOIN category_category1c c3_ ON c2_.id = c3_.category1c_id INNER JOIN category c1_ ON c1_.id = c3_.category_id WHERE p0_.id IN (0, 29174, 29176, 29178, 29181);

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1
FROM
  property_value p0_
WHERE
  p0_.id IN (
    2827, 8, 2828, 3839728, 3839495, 3839497,
    3839499, 3839502, 229, 246, 3838758,
    5335, 1137, 3839493, 19, 1017, 16, 3583343,
    3583349, 3583344, 0
  )

SELECT p0_.id AS id_0, p0_.title AS title_1 FROM property_value p0_ WHERE p0_.id IN (2827, 8, 2828, 3839728, 3839495, 3839497, 3839499, 3839502, 229, 246, 3838758, 5335, 1137, 3839493, 19, 1017, 16, 3583343, 3583349, 3583344, 0);

SELECT
  p0_.id AS id_0
FROM
  product p0_
WHERE
  p0_.visible = 1
  AND p0_.id IN (29174, 29176, 29178, 29181)
ORDER BY
  p0_.is_hit DESC

SELECT p0_.id AS id_0 FROM product p0_ WHERE p0_.visible = 1 AND p0_.id IN (29174, 29176, 29178, 29181) ORDER BY p0_.is_hit DESC;

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 (3839728)

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 (3839728);

SELECT
  MIN(p0_.price) AS sclr_0,
  MAX(p0_.price) AS sclr_1
FROM
  product p0_
WHERE
  p0_.visible = 1
  AND p0_.id IN (29174, 29176, 29178, 29181)
ORDER BY
  p0_.is_hit DESC

SELECT MIN(p0_.price) AS sclr_0, MAX(p0_.price) AS sclr_1 FROM product p0_ WHERE p0_.visible = 1 AND p0_.id IN (29174, 29176, 29178, 29181) ORDER BY p0_.is_hit DESC;

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
  NON_UNIQUE AS Non_Unique,
  INDEX_NAME AS Key_name,
  COLUMN_NAME AS Column_Name,
  SUB_PART AS Sub_Part,
  INDEX_TYPE AS Index_Type
FROM
  information_schema.STATISTICS
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_NAME = ?
ORDER BY
  SEQ_IN_INDEX

SELECT        NON_UNIQUE  AS Non_Unique,
        INDEX_NAME  AS Key_name,
        COLUMN_NAME AS Column_Name,
        SUB_PART    AS Sub_Part,
        INDEX_TYPE  AS Index_Type
FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = 'test' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY SEQ_IN_INDEX;

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;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.page_code AS page_code_4,
  t0.content AS content_5
FROM
  content t0
WHERE
  t0.page_code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.page_code AS page_code_4, t0.content AS content_5 FROM content t0 WHERE t0.page_code = 'topCatalog' LIMIT 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 08:26:08' AND p0_.date_from <= '2026-02-04 08:26:08') AND p0_.type IN ('profit_set', 'registered_customer', 'even_less_price', 'discount_on_products');

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
  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
  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 = 'brand' LIMIT 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_.in_filter = 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_.in_filter = 1;

SELECT
  *
FROM
  doctrine_migration_versions

SELECT * FROM doctrine_migration_versions;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.is_mobile AS is_mobile_3,
  t0.type,
  t0.object_id AS object_id_4,
  t0.object_id AS object_id_5
FROM
  catalog t0
WHERE
  t0.is_mobile = ?
  AND t0.type IN ('category', 'virtual_category')
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.is_mobile AS is_mobile_3, t0.type, t0.object_id AS object_id_4, t0.object_id AS object_id_5 FROM catalog t0 WHERE t0.is_mobile = 0 AND t0.type IN ('category', 'virtual_category') ORDER BY t0.position ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1
FROM
  city c0_
  INNER JOIN pickpoint p1_ ON c0_.id = p1_.city_id
WHERE
  c0_.name NOT IN (
    'Москва', 'Санкт-Петербург',
    'Екатеринбург'
  )
  AND c0_.id NOT IN (1)
GROUP BY
  c0_.id,
  c0_.name
ORDER BY
  c0_.population DESC
LIMIT
  25

SELECT c0_.id AS id_0, c0_.name AS name_1 FROM city c0_ INNER JOIN pickpoint p1_ ON c0_.id = p1_.city_id WHERE c0_.name NOT IN ('Москва', 'Санкт-Петербург', 'Екатеринбург') AND c0_.id NOT IN (1) GROUP BY c0_.id, c0_.name ORDER BY c0_.population DESC LIMIT 25;