GET https://2025-mu.release.sb.paritet.sprintf.ru/directory/cities

Query Metrics

25 Database Queries
4 Different statements
11.10 ms Query time
0 Invalid entities
48 Managed entities

Grouped Statements

Show all queries

Time Count Info
4.71 ms
(42.48%)
22
SELECT t0.code AS code_1, t0.name AS name_2, t0.name_full AS name_full_3, t0.name_eng AS name_eng_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.deleted_at AS deleted_at_7, t0.state_id AS state_id_8 FROM regions t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "b4489800-5660-4610-8e1b-3f0556a1849a"
]
4.50 ms
(40.53%)
1
SELECT DISTINCT id_5, MIN(sclr_7) AS dctrn_minrownum FROM (SELECT c0_.name AS name_0, c0_.okato AS okato_1, c0_.name_full AS name_full_2, c0_.name_eng AS name_eng_3, c0_.updated_at AS updated_at_4, c0_.id AS id_5, c0_.deleted_at AS deleted_at_6, ROW_NUMBER() OVER(ORDER BY c0_.name ASC) AS sclr_7 FROM cities c0_ WHERE (c0_.deleted_at IS NULL)) dctrn_result GROUP BY id_5 ORDER BY dctrn_minrownum ASC LIMIT 25
Parameters:
[]
1.23 ms
(11.12%)
1
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_5 FROM (SELECT c0_.name AS name_0, c0_.okato AS okato_1, c0_.name_full AS name_full_2, c0_.name_eng AS name_eng_3, c0_.updated_at AS updated_at_4, c0_.id AS id_5, c0_.deleted_at AS deleted_at_6 FROM cities c0_ WHERE (c0_.deleted_at IS NULL) ORDER BY c0_.name ASC) dctrn_result) dctrn_table
Parameters:
[]
0.65 ms
(5.87%)
1
SELECT c0_.name AS name_0, c0_.okato AS okato_1, c0_.name_full AS name_full_2, c0_.name_eng AS name_eng_3, c0_.updated_at AS updated_at_4, c0_.id AS id_5, c0_.deleted_at AS deleted_at_6, c0_.region_id AS region_id_7 FROM cities c0_ WHERE (c0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (c0_.deleted_at IS NULL) ORDER BY c0_.name ASC
Parameters:
[
  "20d1c5bd-e166-47f0-b05a-25fecf7b44e0"
  "0cf981fb-bed1-4cfe-8248-a8ebe635aa85"
  "c93ed54b-3878-4039-a32f-d6d5e4514a97"
  "9e8280a5-70bc-43d4-bce8-acfd3c65a872"
  "207da504-c9ff-46a6-a8ab-917930cdbcfb"
  "10455498-c311-49f8-bfcf-409ea3e0eff5"
  "b20dff67-e35e-4776-bd61-88098c973e6e"
  "5c54de66-58c2-4c35-b605-56037a90b532"
  "c57bbeae-ec67-4328-a229-b5f38b074f7b"
  "b9936242-d9f4-4a17-959d-6155f5688fd4"
  "34585d5d-3555-4109-a062-a262aebd9d4a"
  "331fe89f-50f4-4b15-95ac-f4bf9de7c835"
  "d2f0081b-170a-473c-b2cb-9b6b8d8aab28"
  "ff705bfc-9dbb-4aba-a1b5-64820e9d1dfd"
  "56d74828-62c1-46f8-b086-4035b6da8dd6"
  "701a466b-9596-47f6-ab52-37b2aa855096"
  "7460ed1e-6a47-4768-bbd4-e5465b035474"
  "ed3de610-3dd5-4c93-b209-01fb375f99e5"
  "e769c1eb-2b9b-431a-abbd-d6eaca09f7c6"
  "b47e2c96-2b6f-47fb-bbc7-0d4049681a21"
  "9fe08753-46d4-42c8-9a17-46489a697c33"
  "dcf7adcf-6905-47dc-aad3-1e7f30bfd671"
  "2212efe7-73d8-4d97-80b4-8be028f1c34f"
  "a15f230b-4ce9-4b32-97b0-77358fb24dbc"
  "6395a2b7-9bf2-4656-ad36-9575bc451394"
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Geo\Entity\City 25
App\Geo\Entity\Region 22
App\Geo\Entity\State 1

Entities Mapping

Class Mapping errors
App\Geo\Entity\City No errors.
App\Geo\Entity\Region No errors.
App\Geo\Entity\State No errors.