GET https://test.uniqom.ru/catalog/brand/11/203

Query Metrics

22 Database Queries
6 Different statements
25.83 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.77 ms
"START TRANSACTION"
Parameters:
[]
2 2.24 ms
INSERT INTO sf_stat_catalog (type, ip, ref, date, fid, uid, found, time_local, time_cross, time_logic, microtime, brand_id, category_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "brand"
  "216.73.216.245"
  "/catalog/brand/11/203"
  "2025-07-07 06:42:29"
  8
  0
  45
  0.104
  0.0
  0
  0.23
  11
  203
]
3 0.88 ms
"COMMIT"
Parameters:
[]
4 1.11 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.description AS description_2, s0_.is_active AS is_active_3, s0_.start_date AS start_date_4, s0_.end_date AS end_date_5, s0_.color AS color_6, s0_.icon AS icon_7 FROM sale_types s0_ WHERE s0_.start_date <= ? AND s0_.end_date >= ? AND s0_.is_active = 1
Parameters:
[
  "2025-07-07 06:42:29"
  "2025-07-07 06:42:29"
]
5 1.53 ms
SELECT p0_.id AS id_0 FROM product_kit_items p0_ INNER JOIN product_kit p1_ ON (p0_.product_kit_id = p1_.id) INNER JOIN promo_kit p2_ ON (p2_.product_kit_id = p1_.id OR p2_.product_kit_id = p1_.parent_id) WHERE p0_.product_id = ? AND (p2_.date_finish IS NULL OR p2_.date_finish >= ?) AND p2_.public = 1
Parameters:
[
  1851160
  "2025-07-07 06:42:29"
]
6 1.30 ms
SELECT p0_.id AS id_0 FROM product_kit_items p0_ INNER JOIN product_kit p1_ ON (p0_.product_kit_id = p1_.id) INNER JOIN promo_kit p2_ ON (p2_.product_kit_id = p1_.id OR p2_.product_kit_id = p1_.parent_id) WHERE p0_.product_id = ? AND (p2_.date_finish IS NULL OR p2_.date_finish >= ?) AND p2_.public = 1
Parameters:
[
  1851161
  "2025-07-07 06:42:29"
]
7 1.20 ms
SELECT p0_.id AS id_0 FROM product_kit_items p0_ INNER JOIN product_kit p1_ ON (p0_.product_kit_id = p1_.id) INNER JOIN promo_kit p2_ ON (p2_.product_kit_id = p1_.id OR p2_.product_kit_id = p1_.parent_id) WHERE p0_.product_id = ? AND (p2_.date_finish IS NULL OR p2_.date_finish >= ?) AND p2_.public = 1
Parameters:
[
  1851162
  "2025-07-07 06:42:29"
]
8 1.11 ms
SELECT p0_.id AS id_0 FROM product_kit_items p0_ INNER JOIN product_kit p1_ ON (p0_.product_kit_id = p1_.id) INNER JOIN promo_kit p2_ ON (p2_.product_kit_id = p1_.id OR p2_.product_kit_id = p1_.parent_id) WHERE p0_.product_id = ? AND (p2_.date_finish IS NULL OR p2_.date_finish >= ?) AND p2_.public = 1
Parameters:
[
  1851163
  "2025-07-07 06:42:29"
]
9 1.15 ms
SELECT p0_.id AS id_0 FROM product_kit_items p0_ INNER JOIN product_kit p1_ ON (p0_.product_kit_id = p1_.id) INNER JOIN promo_kit p2_ ON (p2_.product_kit_id = p1_.id OR p2_.product_kit_id = p1_.parent_id) WHERE p0_.product_id = ? AND (p2_.date_finish IS NULL OR p2_.date_finish >= ?) AND p2_.public = 1
Parameters:
[
  1851164
  "2025-07-07 06:42:29"
]
10 1.06 ms
SELECT p0_.id AS id_0 FROM product_kit_items p0_ INNER JOIN product_kit p1_ ON (p0_.product_kit_id = p1_.id) INNER JOIN promo_kit p2_ ON (p2_.product_kit_id = p1_.id OR p2_.product_kit_id = p1_.parent_id) WHERE p0_.product_id = ? AND (p2_.date_finish IS NULL OR p2_.date_finish >= ?) AND p2_.public = 1
Parameters:
[
  1851165
  "2025-07-07 06:42:29"
]
11 1.27 ms
SELECT p0_.id AS id_0 FROM product_kit_items p0_ INNER JOIN product_kit p1_ ON (p0_.product_kit_id = p1_.id) INNER JOIN promo_kit p2_ ON (p2_.product_kit_id = p1_.id OR p2_.product_kit_id = p1_.parent_id) WHERE p0_.product_id = ? AND (p2_.date_finish IS NULL OR p2_.date_finish >= ?) AND p2_.public = 1
Parameters:
[
  1851166
  "2025-07-07 06:42:29"
]
12 1.19 ms
SELECT p0_.id AS id_0 FROM product_kit_items p0_ INNER JOIN product_kit p1_ ON (p0_.product_kit_id = p1_.id) INNER JOIN promo_kit p2_ ON (p2_.product_kit_id = p1_.id OR p2_.product_kit_id = p1_.parent_id) WHERE p0_.product_id = ? AND (p2_.date_finish IS NULL OR p2_.date_finish >= ?) AND p2_.public = 1
Parameters:
[
  1851167
  "2025-07-07 06:42:29"
]
13 1.08 ms
SELECT p0_.id AS id_0 FROM product_kit_items p0_ INNER JOIN product_kit p1_ ON (p0_.product_kit_id = p1_.id) INNER JOIN promo_kit p2_ ON (p2_.product_kit_id = p1_.id OR p2_.product_kit_id = p1_.parent_id) WHERE p0_.product_id = ? AND (p2_.date_finish IS NULL OR p2_.date_finish >= ?) AND p2_.public = 1
Parameters:
[
  1851168
  "2025-07-07 06:42:29"
]
14 1.32 ms
SELECT p0_.id AS id_0 FROM product_kit_items p0_ INNER JOIN product_kit p1_ ON (p0_.product_kit_id = p1_.id) INNER JOIN promo_kit p2_ ON (p2_.product_kit_id = p1_.id OR p2_.product_kit_id = p1_.parent_id) WHERE p0_.product_id = ? AND (p2_.date_finish IS NULL OR p2_.date_finish >= ?) AND p2_.public = 1
Parameters:
[
  1851169
  "2025-07-07 06:42:29"
]
15 1.09 ms
SELECT p0_.id AS id_0 FROM product_kit_items p0_ INNER JOIN product_kit p1_ ON (p0_.product_kit_id = p1_.id) INNER JOIN promo_kit p2_ ON (p2_.product_kit_id = p1_.id OR p2_.product_kit_id = p1_.parent_id) WHERE p0_.product_id = ? AND (p2_.date_finish IS NULL OR p2_.date_finish >= ?) AND p2_.public = 1
Parameters:
[
  1851170
  "2025-07-07 06:42:29"
]
16 1.15 ms
SELECT p0_.id AS id_0 FROM product_kit_items p0_ INNER JOIN product_kit p1_ ON (p0_.product_kit_id = p1_.id) INNER JOIN promo_kit p2_ ON (p2_.product_kit_id = p1_.id OR p2_.product_kit_id = p1_.parent_id) WHERE p0_.product_id = ? AND (p2_.date_finish IS NULL OR p2_.date_finish >= ?) AND p2_.public = 1
Parameters:
[
  1851171
  "2025-07-07 06:42:29"
]
17 1.32 ms
SELECT p0_.id AS id_0 FROM product_kit_items p0_ INNER JOIN product_kit p1_ ON (p0_.product_kit_id = p1_.id) INNER JOIN promo_kit p2_ ON (p2_.product_kit_id = p1_.id OR p2_.product_kit_id = p1_.parent_id) WHERE p0_.product_id = ? AND (p2_.date_finish IS NULL OR p2_.date_finish >= ?) AND p2_.public = 1
Parameters:
[
  1851172
  "2025-07-07 06:42:29"
]
18 1.09 ms
SELECT p0_.id AS id_0 FROM product_kit_items p0_ INNER JOIN product_kit p1_ ON (p0_.product_kit_id = p1_.id) INNER JOIN promo_kit p2_ ON (p2_.product_kit_id = p1_.id OR p2_.product_kit_id = p1_.parent_id) WHERE p0_.product_id = ? AND (p2_.date_finish IS NULL OR p2_.date_finish >= ?) AND p2_.public = 1
Parameters:
[
  1851173
  "2025-07-07 06:42:29"
]
19 1.14 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.enabled AS enabled_3, t0.type AS type_4, t0.sort AS sort_5 FROM selection_type t0 WHERE t0.enabled = ? ORDER BY t0.sort DESC
Parameters:
[
  1
]
20 0.99 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.description AS description_2, s0_.is_active AS is_active_3, s0_.start_date AS start_date_4, s0_.end_date AS end_date_5, s0_.color AS color_6, s0_.icon AS icon_7 FROM sale_types s0_ WHERE s0_.start_date <= ? AND s0_.end_date >= ? AND s0_.is_active = 1
Parameters:
[
  "2025-07-07 06:42:30"
  "2025-07-07 06:42:30"
]
21 1.16 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.enabled AS enabled_3, t0.type AS type_4, t0.sort AS sort_5 FROM selection_type t0 WHERE t0.enabled = ? ORDER BY t0.sort DESC
Parameters:
[
  1
]
22 0.67 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.description AS description_2, s0_.is_active AS is_active_3, s0_.start_date AS start_date_4, s0_.end_date AS end_date_5, s0_.color AS color_6, s0_.icon AS icon_7 FROM sale_types s0_ WHERE s0_.start_date <= ? AND s0_.end_date >= ? AND s0_.is_active = 1
Parameters:
[
  "2025-07-07 06:42:30"
  "2025-07-07 06:42:30"
]

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.