http://test.dombusin.com/uk/api/checkout/citydetect

Query Metrics

29 Database Queries
8 Different statements
40.92 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
15.55 ms
(37.99%)
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_69e3c8056e87a"
]
14.24 ms
(34.80%)
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:
[
  1566
]
8.61 ms
(21.03%)
22
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.75 ms
(1.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 region_translation t0 WHERE t0.object_id = ?
Parameters:
[
  21
]
0.66 ms
(1.62%)
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.name = ? LIMIT 1
Parameters:
[
  ""
]
0.47 ms
(1.16%)
1
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.43 ms
(1.04%)
1
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.22 ms
(0.53%)
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.id = ?
Parameters:
[
  21
]

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.