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

Query Metrics

4 Database Queries
4 Different statements
7.17 ms Query time
0 Invalid entities
26 Managed entities

Queries

Group similar statements

# Time Info
1 4.33 ms
SELECT DISTINCT id_5, MIN(sclr_7) AS dctrn_minrownum FROM (SELECT r0_.code AS code_0, r0_.name AS name_1, r0_.name_full AS name_full_2, r0_.name_eng AS name_eng_3, r0_.updated_at AS updated_at_4, r0_.id AS id_5, r0_.deleted_at AS deleted_at_6, ROW_NUMBER() OVER(ORDER BY r0_.code ASC) AS sclr_7 FROM regions r0_ WHERE (r0_.deleted_at IS NULL)) dctrn_result GROUP BY id_5 ORDER BY dctrn_minrownum ASC LIMIT 25
Parameters:
[]
2 0.80 ms
SELECT r0_.code AS code_0, r0_.name AS name_1, r0_.name_full AS name_full_2, r0_.name_eng AS name_eng_3, r0_.updated_at AS updated_at_4, r0_.id AS id_5, r0_.deleted_at AS deleted_at_6, r0_.state_id AS state_id_7 FROM regions r0_ WHERE (r0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (r0_.deleted_at IS NULL) ORDER BY r0_.code ASC
Parameters:
[
  "21422329-0c20-4737-ac94-cb2d2e8e1d45"
  "da2fb174-9189-403e-973c-280bedc75747"
  "d4771a03-ea0d-4c95-8c1d-63bb44267475"
  "90b197f1-ba1d-41a3-ab84-0d8b154d99c0"
  "64d516db-7187-4609-8611-9398af593f98"
  "57ef51af-69a2-4f65-ada3-39509a11b5cd"
  "5258fc5d-0d5a-4718-b649-1a74d09d59a7"
  "c90f5884-27fd-4f3d-986e-070aa77bcb9e"
  "1b0e9977-c339-46bb-be19-9009c2ddb945"
  "368a344a-96e1-45bf-a40f-cc780a8c05a5"
  "d458b57c-c446-43a4-8d24-783016c709bb"
  "22e3ccd1-b149-4dde-9ceb-c57932dcbf94"
  "670c44e1-c172-4fb3-a2e9-b15e2995b1bd"
  "99873381-2dbc-4109-bf37-3fc80badce46"
  "ea8898a6-0ac0-49fe-b783-200104ef71ca"
  "6002e1a6-a786-4c19-b822-65d16edfa6c7"
  "08a272d6-39a7-4742-8d63-5eb659b2b005"
  "e819e6fc-3d0d-4b70-a804-fa55f92a8330"
  "b4489800-5660-4610-8e1b-3f0556a1849a"
  "e49b39d5-4c2d-4de3-9c15-2e2d865ff53e"
  "934fda57-9ae3-4d2a-b6a1-992dfea1694f"
  "fdd57c70-fbbf-4be1-8bdf-0bce43300310"
  "ee7455f8-75f4-4ae0-bd01-5cef3dbb0372"
  "569d6ccb-501e-45d2-8610-a0a7eef2bd69"
  "0a0a09cb-a3eb-4d4d-b0fe-8d7462928ee9"
]
3 1.28 ms
SELECT t0.alpha2 AS alpha2_1, t0.alpha3 AS alpha3_2, t0.name AS name_3, t0.name_full AS name_full_4, t0.name_eng AS name_eng_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.deleted_at AS deleted_at_8 FROM states t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "802da38d-f55a-4fca-978e-b694da10b29a"
]
4 0.76 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_5 FROM (SELECT r0_.code AS code_0, r0_.name AS name_1, r0_.name_full AS name_full_2, r0_.name_eng AS name_eng_3, r0_.updated_at AS updated_at_4, r0_.id AS id_5, r0_.deleted_at AS deleted_at_6 FROM regions r0_ WHERE (r0_.deleted_at IS NULL) ORDER BY r0_.code ASC) dctrn_result) dctrn_table
Parameters:
[]

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\Region 25
App\Geo\Entity\State 1

Entities Mapping

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