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 (
    '9443', '9444', '9445', '9446', '9453',
    '9454', '21922', '25314', '25315',
    '25316', '25317', '25327', '25328',
    '25329', '25330', '34261', '34263',
    '34264', '34266', '35010', '35011',
    '38960', '38961'
  )

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 ('9443', '9444', '9445', '9446', '9453', '9454', '21922', '25314', '25315', '25316', '25317', '25327', '25328', '25329', '25330', '34261', '34263', '34264', '34266', '35010', '35011', '38960', '38961');

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1
FROM
  property_value p0_
WHERE
  p0_.id IN (
    638,
    19,
    7,
    644,
    649,
    8,
    13,
    27,
    805,
    3529014,
    658,
    3529015,
    3839642,
    1192,
    32,
    40,
    56,
    78,
    123,
    678,
    3839579,
    3839638,
    20,
    1037876,
    89,
    31,
    2378,
    1295522,
    185,
    33,
    176,
    3230,
    2,
    2418,
    255,
    641,
    3839568,
    3845841,
    3845979,
    3845981,
    3846047,
    3846048,
    3846052,
    3846053,
    3846104,
    3846105,
    3846107,
    107,
    108,
    165,
    175,
    70,
    1277418,
    740,
    1381,
    2283,
    3173954,
    3841829,
    449,
    479,
    651,
    86,
    26,
    3,
    60,
    5073,
    7606,
    3846008,
    3846027,
    3846791,
    1130,
    162,
    2493387,
    3828416,
    3828419,
    3828420,
    3837969,
    3838921,
    3840786,
    3841835,
    3844913,
    3960,
    547710,
    593,
    595,
    64,
    6471,
    6473,
    667,
    700,
    82,
    82883,
    899,
    1327,
    15,
    383,
    654,
    174,
    278,
    262,
    330,
    75,
    18,
    304890,
    3828405,
    3828412,
    3841824,
    3841832,
    3841834,
    3842082,
    3844911,
    3844912,
    3912,
    404077,
    642,
    7244,
    792,
    82878,
    1268489,
    3828417,
    3841784,
    6577,
    3840820,
    1080,
    1099888,
    1379,
    168,
    1726,
    2076,
    24885,
    2503,
    36,
    3619,
    4483,
    5142,
    5204,
    522048,
    6196,
    951,
    266,
    4,
    499,
    453,
    0
  )

SELECT p0_.id AS id_0, p0_.title AS title_1 FROM property_value p0_ WHERE p0_.id IN (638, 19, 7, 644, 649, 8, 13, 27, 805, 3529014, 658, 3529015, 3839642, 1192, 32, 40, 56, 78, 123, 678, 3839579, 3839638, 20, 1037876, 89, 31, 2378, 1295522, 185, 33, 176, 3230, 2, 2418, 255, 641, 3839568, 3845841, 3845979, 3845981, 3846047, 3846048, 3846052, 3846053, 3846104, 3846105, 3846107, 107, 108, 165, 175, 70, 1277418, 740, 1381, 2283, 3173954, 3841829, 449, 479, 651, 86, 26, 3, 60, 5073, 7606, 3846008, 3846027, 3846791, 1130, 162, 2493387, 3828416, 3828419, 3828420, 3837969, 3838921, 3840786, 3841835, 3844913, 3960, 547710, 593, 595, 64, 6471, 6473, 667, 700, 82, 82883, 899, 1327, 15, 383, 654, 174, 278, 262, 330, 75, 18, 304890, 3828405, 3828412, 3841824, 3841832, 3841834, 3842082, 3844911, 3844912, 3912, 404077, 642, 7244, 792, 82878, 1268489, 3828417, 3841784, 6577, 3840820, 1080, 1099888, 1379, 168, 1726, 2076, 24885, 2503, 36, 3619, 4483, 5142, 5204, 522048, 6196, 951, 266, 4, 499, 453, 0);

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
  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
  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
  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
  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:47:59' AND p0_.date_from <= '2026-02-04 06:47:59') AND p0_.type IN ('profit_set', 'registered_customer', 'even_less_price', 'discount_on_products');

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 (
    9443, 9445, 9446, 9454, 21922, 25314,
    25315, 25316, 25327, 25329, 34263,
    9444, 9453, 25317, 25330, 34264, 35010,
    35011
  )
  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 (9443,9445,9446,9454,21922,25314,25315,25316,25327,25329,34263,9444,9453,25317,25330,34264,35010,35011) 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 = 248 AND te.visible = 1 AND te.products_count > 0;

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 (
    3839642, 3839638, 3839579, 3839568
  )

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 (3839642, 3839638, 3839579, 3839568);

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 = 'podushki-len-khlopok-tensel' LIMIT 1;

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 = 248 AND te.visible = 1 AND te.products_number > 0;

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 = 83;

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.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.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 = 34;

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
  (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_.alias AS alias_1,
  p0_.title AS title_2,
  p0_.values_sort AS values_sort_3
FROM
  property p0_
WHERE
  p0_.id IN (
    '10', '5', '1', '21884', '21994', '20',
    '9', '7', '3', '8', '29', '2', '12',
    '4'
  )

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 ('10', '5', '1', '21884', '21994', '20', '9', '7', '3', '8', '29', '2', '12', '4');

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
  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.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;

SELECT
  *
FROM
  doctrine_migration_versions

SELECT * FROM doctrine_migration_versions;