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

Query Metrics

21 Database Queries
2 Different statements
17.27 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 11.03 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:
[
  "%%"
]
2 1.16 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"
]
3 0.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:
[
  "1ef50b43-bc98-6516-9255-c50586eab5d0"
]
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:
[
  "1ef50b4d-dd16-6a2c-b5a5-23ecfcf8ffd3"
]
5 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:
[
  "1ef50b4e-4b95-60d4-940d-3186491fa564"
]
6 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:
[
  "1ef50b49-8f43-65ba-9303-d5afb3dc7d7e"
]
7 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:
[
  "1ef50b20-940d-681c-a4be-41062261d81c"
]
8 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:
[
  "1ef50b44-b944-6d00-8022-2748bc57dc17"
]
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:
[
  "1ef50b38-1833-606c-8da8-0536d1ef8400"
]
10 0.26 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"
]
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:
[
  "1ef50b3a-cad2-66f8-abb1-cffe2bddeb45"
]
12 0.26 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"
]
13 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:
[
  "1ef50b3f-4421-6b40-8e3f-1181f08d30da"
]
14 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:
[
  "1ef50b49-d147-666e-93d6-7ff4a8b3530c"
]
15 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:
[
  "1ef50b51-fa11-698e-a213-2f31ec0bd154"
]
16 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:
[
  "1ef50b2e-24b1-6a6e-bfa7-fd7d957ae4cc"
]
17 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:
[
  "1ef50b4f-c16b-6082-b3b3-71a9b61c1115"
]
18 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:
[
  "1ef50b3e-d627-67b6-af3a-a788dd2af8a4"
]
19 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:
[
  "1ef50b4e-1440-6070-a79a-45c0dff5b41e"
]
20 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:
[
  "1ef50b53-8c55-6358-8624-ad128c7edcd7"
]
21 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:
[
  "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\Payer\Payer No errors.
App\Domain\Payer\JuridicalPayer No errors.
App\Domain\Order\Position No errors.
App\Domain\Order\VacancyQuotaPosition No errors.
App\Domain\Order\Order No errors.
App\Domain\VacancyImport\VacancyImport No errors.
App\Domain\VacancyImport\VacancyImportHistory 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\VacancyQuota\VacancyQuota No errors.
App\Domain\Language\Language No errors.
App\Domain\Resume\LanguageKnowledge No errors.
App\Domain\Resume\Course No errors.
App\Domain\Resume\ResumeEmployment No errors.
App\Domain\Resume\Education No errors.
App\Domain\Resume\PreviousJob No errors.
App\Domain\Resume\ResumeSchedule No errors.
App\Domain\Resume\Comment No errors.
App\Domain\Resume\ResumeView 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\VacancyResumeRequest\Event\VacancyResumeRequestEvent No errors.
App\Domain\VacancyResumeRequest\Event\VacancyResumeRequestEditEvent No errors.
App\Domain\VacancyResumeRequest\VacancyResumeRequest No errors.
App\Domain\VacancyResumeRequest\Event\VacancyResumeRequestCreateEvent No errors.
App\Domain\Feedback\Feedback No errors.
App\Domain\Statistic\VacancySnapshot No errors.
App\Domain\Statistic\VacancySnapshotArchive 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.
App\Domain\Vacancy\Event\Favorite 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.