GET https://raberu.raduga.red/suggest/city/suggest?page=1&q=

Query Metrics

22 Database Queries
3 Different statements
32.86 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 5.11 ms
SELECT t0.public_id AS public_id_1, t0.email AS email_2, t0.email_confirmed AS email_confirmed_3, t0.password AS password_4, t0.enabled AS enabled_5, t0.has_notifications AS has_notifications_6, t0.phone AS phone_7, t0.phone_confirmed AS phone_confirmed_8, t0.photo_path AS photo_path_9, t0.first_name AS first_name_10, t0.middle_name AS middle_name_11, t0.last_name AS last_name_12, t0.birthday AS birthday_13, t0.gender AS gender_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.id AS id_17, t0.city_id AS city_id_18 FROM users t0 WHERE t0.id = ?
Parameters:
[
  "1effe4bd-d401-65b4-822f-21bc0b3a75f3"
]
2 21.29 ms
SELECT DISTINCT c0_.name AS name_0, c0_.name_prepositional AS name_prepositional_1, c0_.banner_path AS banner_path_2, c0_.slug AS slug_3, c0_.db_ip_light_city_id AS db_ip_light_city_id_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.id AS id_7, c0_.metadata_title AS metadata_title_8, c0_.metadata_description AS metadata_description_9, c0_.metadata_keywords AS metadata_keywords_10, c0_.region_id AS region_id_11 FROM city c0_ WHERE LOWER(c0_.name) LIKE ? ORDER BY c0_.name ASC LIMIT 31
Parameters:
[
  "%%"
]
3 1.31 ms
SELECT t0.name AS name_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM region t0 WHERE t0.id = ?
Parameters:
[
  "1ef50b44-fc20-658e-919b-35a649f9ced7"
]
4 0.32 ms
SELECT t0.name AS name_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM region t0 WHERE t0.id = ?
Parameters:
[
  "1ef50b43-bc98-6516-9255-c50586eab5d0"
]
5 0.28 ms
SELECT t0.name AS name_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM region t0 WHERE t0.id = ?
Parameters:
[
  "1ef50b4d-dd16-6a2c-b5a5-23ecfcf8ffd3"
]
6 0.24 ms
SELECT t0.name AS name_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM region t0 WHERE t0.id = ?
Parameters:
[
  "1ef50b4e-4b95-60d4-940d-3186491fa564"
]
7 0.25 ms
SELECT t0.name AS name_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM region t0 WHERE t0.id = ?
Parameters:
[
  "1ef50b49-8f43-65ba-9303-d5afb3dc7d7e"
]
8 0.27 ms
SELECT t0.name AS name_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM region t0 WHERE t0.id = ?
Parameters:
[
  "1ef50b20-940d-681c-a4be-41062261d81c"
]
9 0.30 ms
SELECT t0.name AS name_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM region t0 WHERE t0.id = ?
Parameters:
[
  "1ef50b44-b944-6d00-8022-2748bc57dc17"
]
10 0.21 ms
SELECT t0.name AS name_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM region t0 WHERE t0.id = ?
Parameters:
[
  "1ef50b38-1833-606c-8da8-0536d1ef8400"
]
11 0.27 ms
SELECT t0.name AS name_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM region t0 WHERE t0.id = ?
Parameters:
[
  "1ef50b18-9ad2-6254-9b7f-c3b6dda9436c"
]
12 0.23 ms
SELECT t0.name AS name_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM region t0 WHERE t0.id = ?
Parameters:
[
  "1ef50b3a-cad2-66f8-abb1-cffe2bddeb45"
]
13 0.23 ms
SELECT t0.name AS name_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM region t0 WHERE t0.id = ?
Parameters:
[
  "1ef50b58-af09-6db8-9582-f3564d90f4b0"
]
14 0.19 ms
SELECT t0.name AS name_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM region t0 WHERE t0.id = ?
Parameters:
[
  "1ef50b3f-4421-6b40-8e3f-1181f08d30da"
]
15 0.32 ms
SELECT t0.name AS name_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM region t0 WHERE t0.id = ?
Parameters:
[
  "1ef50b49-d147-666e-93d6-7ff4a8b3530c"
]
16 0.29 ms
SELECT t0.name AS name_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM region t0 WHERE t0.id = ?
Parameters:
[
  "1ef50b51-fa11-698e-a213-2f31ec0bd154"
]
17 0.28 ms
SELECT t0.name AS name_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM region t0 WHERE t0.id = ?
Parameters:
[
  "1ef50b2e-24b1-6a6e-bfa7-fd7d957ae4cc"
]
18 0.32 ms
SELECT t0.name AS name_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM region t0 WHERE t0.id = ?
Parameters:
[
  "1ef50b4f-c16b-6082-b3b3-71a9b61c1115"
]
19 0.28 ms
SELECT t0.name AS name_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM region t0 WHERE t0.id = ?
Parameters:
[
  "1ef50b3e-d627-67b6-af3a-a788dd2af8a4"
]
20 0.28 ms
SELECT t0.name AS name_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM region t0 WHERE t0.id = ?
Parameters:
[
  "1ef50b4e-1440-6070-a79a-45c0dff5b41e"
]
21 0.32 ms
SELECT t0.name AS name_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM region t0 WHERE t0.id = ?
Parameters:
[
  "1ef50b53-8c55-6358-8624-ad128c7edcd7"
]
22 0.28 ms
SELECT t0.name AS name_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM region t0 WHERE t0.id = ?
Parameters:
[
  "1ef50b4d-a528-68a4-aaf5-6d55f37691e6"
]

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

Class Mapping errors
App\Domain\Company\Company No errors.
App\Domain\Vacancy\Vacancy No errors.
App\Domain\Resume\Resume No errors.
App\Domain\Admin\Admin No errors.
App\Domain\User\User No errors.
App\Domain\Statistic\VacancySnapshot No errors.
App\Domain\VacancyResumeRequest\VacancyResumeRequest No errors.
App\Domain\AdminAccess\SectionAccess No errors.
App\Domain\Applicant\Applicant No errors.
App\Domain\Category\Category No errors.
App\Domain\City\Metadata No errors.
App\Domain\City\City No errors.
App\Domain\City\Region No errors.
App\Domain\Specialization\Specialization No errors.
App\Domain\Citizenship\Citizenship No errors.
App\Domain\EducationInstitution\EducationInstitution No errors.
App\Domain\Skill\Skill No errors.
App\Domain\User\ResetPasswordRequest No errors.
App\Domain\User\ConfirmRequest No errors.
App\Domain\Company\CompanyAcl No errors.
App\Domain\PersonalAccount\PersonalAccount\History No errors.
App\Domain\PersonalAccount\PersonalAccount No errors.
App\Domain\Employer\EmployerLimit No errors.
App\Domain\Employer\Employer No errors.
App\Domain\Vacancy\Event\View No errors.
App\Domain\Vacancy\Event\ViewPhone No errors.
App\Domain\Vacancy\Event\Publication No errors.
App\Domain\Vacancy\Event\History No errors.
App\Domain\VacancyQuota\VacancyQuota No errors.
App\Domain\VacancyResumeRequest\Event\VacancyResumeRequestEvent No errors.
App\Domain\VacancyResumeRequest\Event\VacancyResumeRequestEditEvent No errors.
App\Domain\VacancyResumeRequest\Event\VacancyResumeRequestCreateEvent No errors.
App\Domain\Language\Language No errors.
App\Domain\Resume\LanguageKnowledge No errors.
App\Domain\Resume\Education No errors.
App\Domain\Resume\PreviousJob No errors.
App\Domain\Resume\Comment No errors.
App\Domain\Act\Act No errors.
App\Domain\Bill\Bill No errors.
App\Domain\Cart\Cart No errors.
App\Domain\Cart\CartBuyOrder No errors.
App\Domain\Feedback\Feedback No errors.
App\Domain\News\News No errors.
App\Domain\PromoCode\PromoCode No errors.
App\Domain\PromoCode\PromoCodeUsageHistory No errors.
App\Domain\Moderation\Moderation No errors.
App\Domain\Moderation\ResumeModeration No errors.
App\Domain\Moderation\VacancyModeration No errors.
App\Domain\Moderation\FeedbackModeration No errors.
App\Domain\Notification\Site\Notification No errors.
App\Domain\Notification\Site\Settings No errors.
App\Domain\AuthProviders\UserAuthProviders No errors.
App\Domain\Contract\Contract No errors.