https://mirbusin.ru/uk/api/checkout/citydetect

Query Metrics

35 Database Queries
11 Different statements
22.29 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
9.42 ms
(42.26%)
2
SELECT DATABASE()
Parameters:
[]
5.45 ms
(24.45%)
2
SELECT t0.id AS id_1, t0.oldurl AS oldurl_2, t0.newurl AS newurl_3 FROM redirect t0
Parameters:
[]
2.56 ms
(11.50%)
21
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM block_translation t0 WHERE t0.object_id = ?
Parameters:
[
  1
]
0.95 ms
(4.24%)
1
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "mirb_mir"
]
0.90 ms
(4.03%)
2
SELECT t0.id AS id_1, t0.user AS user_2, t0.prod AS prod_3, t0.var AS var_4, t0.num AS num_5, t0.tstamp AS tstamp_6 FROM wishlist t0 WHERE t0.user = ? ORDER BY t0.id DESC
Parameters:
[
  0
]
0.68 ms
(3.06%)
1
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM region_translation t0 WHERE t0.object_id = ?
Parameters:
[
  1
]
0.63 ms
(2.84%)
1
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM city_translation t0 WHERE t0.object_id = ?
Parameters:
[
  2
]
0.55 ms
(2.48%)
1
SELECT t0.id AS id_1, t0.fias_id AS fias_id_2, t0.name AS name_3, t0.prior AS prior_4, t0.visible AS visible_5 FROM region t0 WHERE t0.fias_id = ? LIMIT 1
Parameters:
[
  "0c5b2444-70a0-4932-980c-b4dc0d3f02b5"
]
0.49 ms
(2.18%)
2
SELECT t0.id AS id_1, t0.intname AS intname_2, t0.name AS name_3, t0.value AS value_4 FROM block t0
Parameters:
[]
0.35 ms
(1.56%)
1
SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.cart AS cart_3 FROM cart_unsaved t0 WHERE t0.user_id = ? LIMIT 1
Parameters:
[
  "guest_68ed64ea6f7bd"
]
0.31 ms
(1.39%)
1
SELECT t0.id AS id_1, t0.region AS region_2, t0.fias_id AS fias_id_3, t0.postal_code AS postal_code_4, t0.type AS type_5, t0.name AS name_6, t0.kw AS kw_7, t0.prior AS prior_8, t0.visible AS visible_9, t0.top AS top_10, t0.top2 AS top2_11 FROM city t0 WHERE t0.fias_id = ? LIMIT 1
Parameters:
[
  "0c5b2444-70a0-4932-980c-b4dc0d3f02b5"
]

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.