Query Metrics

39 Database Queries
18 Different statements
14.52 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.86 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.visible AS visible_3, t0.content AS content_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.views AS views_7, t0.image AS image_8, t0.slug AS slug_9, t0.meta_title AS meta_title_10, t0.meta_description AS meta_description_11 FROM article t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "kak-pravilno-vybrat-prostynyu-po-razmeru-matrasa"
]
2 0.12 ms
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 = ?
Parameters:
[
  0
]
3 0.08 ms
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 = ?
Parameters:
[
  1
]
4 0.09 ms
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')
Parameters:
[
  "2026-02-04 06:49:02"
  "2026-02-04 06:49:02"
]
5 0.09 ms
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
Parameters:
[
  App\Component\Seo\SeoObjectType {#2627
    __toString(): "article"
  }
]
6 0.13 ms
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
Parameters:
[]
7 0.10 ms
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
Parameters:
[]
8 0.14 ms
SELECT DATABASE()
Parameters:
[]
9 1.11 ms
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "test"
]
10 0.11 ms
SELECT DATABASE()
Parameters:
[]
11 0.79 ms
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "test"
]
12 0.11 ms
SELECT DATABASE()
Parameters:
[]
13 0.60 ms
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'
Parameters:
[
  "test"
  "doctrine_migration_versions"
]
14 0.09 ms
SELECT DATABASE()
Parameters:
[]
15 7.39 ms
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
Parameters:
[
  "test"
  "doctrine_migration_versions"
]
16 0.48 ms
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
Parameters:
[
  "test"
  "doctrine_migration_versions"
]
17 0.12 ms
SELECT DATABASE()
Parameters:
[]
18 0.20 ms
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
Parameters:
[
  "test"
  "doctrine_migration_versions"
]
19 0.09 ms
SELECT * FROM doctrine_migration_versions
Parameters:
[]
20 0.13 ms
SELECT DATABASE()
Parameters:
[]
21 0.09 ms
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
Parameters:
[
  "registration_bonus"
]
22 0.08 ms
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
Parameters:
[
  "logo"
]
23 0.12 ms
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
Parameters:
[]
24 0.10 ms
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
Parameters:
[
  "logo"
]
25 0.10 ms
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
Parameters:
[
  0
]
26 0.10 ms
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
Parameters:
[
  "topCatalog"
]
27 0.11 ms
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
Parameters:
[
  "registration_bonus"
]
28 0.10 ms
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
Parameters:
[
  "topLinksRow"
]
29 0.10 ms
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
Parameters:
[
  "catalog"
  1
]
30 0.09 ms
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
Parameters:
[
  "about_company"
  1
]
31 0.08 ms
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
Parameters:
[
  "help"
  1
]
32 0.08 ms
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
Parameters:
[
  "to_customers"
  1
]
33 0.08 ms
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
Parameters:
[
  "logo"
]
34 0.08 ms
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
Parameters:
[
  "to_customers"
  1
]
35 0.08 ms
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
Parameters:
[
  "about_company"
  1
]
36 0.08 ms
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
Parameters:
[
  "help"
  1
]
37 0.07 ms
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
Parameters:
[
  "to_customers"
  1
]
38 0.08 ms
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
Parameters:
[
  "logo"
]
39 0.09 ms
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
Parameters:
[
  "auth_type"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Article No errors.
App\Entity\ArticleType No errors.
App\Entity\ArticleCategory No errors.
App\Entity\Customer No errors.
App\Entity\City No errors.
App\Entity\Sms No errors.
App\Entity\Product No errors.
App\Entity\PromoCode No errors.
App\Entity\Settings No errors.
App\Entity\Region No errors.
App\Entity\DeliveryZone No errors.
App\Entity\TransporterCode No errors.
App\Entity\PickPoint No errors.
App\Entity\Transporter No errors.
App\Entity\Promotions\AbstractPromotion No errors.
App\Entity\Promotions\ProfitSetPromotion No errors.
App\Entity\Promotions\DiscountRegisteredCustomerPromotion No errors.
App\Entity\Promotions\EvenLessPricePromotion No errors.
App\Entity\Promotions\DiscountOnProductsPromotion No errors.
App\Entity\ProductLabel No errors.
App\Entity\SeoTemplate No errors.
App\Entity\Category No errors.
App\Entity\Content No errors.
App\Entity\InfoBlockLink No errors.
App\Entity\ExtScript No errors.
App\Entity\CustomerQuestion No errors.
App\Entity\ProductReview No errors.
App\Entity\Order No errors.
App\Entity\ProductQuestion No errors.
App\Entity\EmailLog No errors.
App\Entity\Store No errors.
App\Entity\CustomerLog No errors.
App\Entity\Brand No errors.
App\Entity\ProductSize No errors.
App\Entity\ProductIcon No errors.
App\Entity\ProductCertificate No errors.
App\Entity\ProductVideo No errors.
App\Entity\ProductProperty No errors.
App\Entity\Category1C No errors.
App\Entity\ProductsListContent No errors.
App\Entity\VirtualCategory No errors.
App\Entity\OrderItem No errors.
App\Entity\Address No errors.
App\Entity\OrderCalculation No errors.
App\Entity\GiftCardOrder No errors.
App\Entity\OrderTransaction No errors.
App\Entity\SiteLog No errors.
App\Entity\OrderPayment No errors.
App\Entity\GiftCard No errors.
App\Entity\GiftCardDebit No errors.
App\Entity\EmailLogEvent No errors.
App\Entity\Property No errors.
App\Entity\PropertyValue No errors.
App\Entity\Catalog\AbstractCatalogItem No errors.
App\Entity\Catalog\CategoryCatalogItem No errors.
App\Entity\Catalog\VirtualCategoryCatalogItem No errors.
App\Entity\AdminUser No errors.
App\Entity\MessageThrottle No errors.
App\Entity\NotifyTemplate No errors.