GET https://test.uniqom.ru/catalog/chemistry/1325

Query Metrics

9 Database Queries
6 Different statements
14.41 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.58 ms
SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.display AS display_3, t0.search AS search_4, t0.basket AS basket_5, t0.button AS button_6 FROM extracharge t0 WHERE t0.user_id IS NULL LIMIT 1
Parameters:
[]
2 0.78 ms
"START TRANSACTION"
Parameters:
[]
3 1.44 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:
[
  "group"
  "216.73.216.245"
  "/catalog/chemistry/1325"
  "2025-07-07 00:42:57"
  8
  0
  0
  0.025
  0.0
  0
  0.026
  null
  null
]
4 0.93 ms
"COMMIT"
Parameters:
[]
5 1.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 00:42:57"
  "2025-07-07 00:42:57"
]
6 1.31 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
]
7 1.81 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 00:42:58"
  "2025-07-07 00:42:58"
]
8 2.55 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
]
9 1.02 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 00:42:58"
  "2025-07-07 00:42:58"
]

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