Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

5.40 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

4.71 ms

SELECT t0.name AS name_1, t0.name_prepositional AS name_prepositional_2, t0.banner_path AS banner_path_3, t0.slug AS slug_4, t0.db_ip_light_city_id AS db_ip_light_city_id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.metadata_title AS metadata_title_9, t0.metadata_description AS metadata_description_10, t0.metadata_keywords AS metadata_keywords_11, t0.region_id AS region_id_12 FROM city t0 WHERE t0.db_ip_light_city_id = ? LIMIT 1

Parameters:

[
  "US;California;San Francisco"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.name_prepositional AS name_prepositional_2,
  t0.banner_path AS banner_path_3,
  t0.slug AS slug_4,
  t0.db_ip_light_city_id AS db_ip_light_city_id_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.id AS id_8,
  t0.metadata_title AS metadata_title_9,
  t0.metadata_description AS metadata_description_10,
  t0.metadata_keywords AS metadata_keywords_11,
  t0.region_id AS region_id_12
FROM
  city t0
WHERE
  t0.db_ip_light_city_id = ?
LIMIT
  1

SELECT t0.name AS name_1, t0.name_prepositional AS name_prepositional_2, t0.banner_path AS banner_path_3, t0.slug AS slug_4, t0.db_ip_light_city_id AS db_ip_light_city_id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.metadata_title AS metadata_title_9, t0.metadata_description AS metadata_description_10, t0.metadata_keywords AS metadata_keywords_11, t0.region_id AS region_id_12 FROM city t0 WHERE t0.db_ip_light_city_id = 'US;California;San Francisco' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 45)
4	App\Infrastructure\City\Repository\CityRepository->findByDbIpLightCityId (line 57)
5	App\Util\CityIpDetector\DbIpLiteCityIpDetector->find (line 158)
6	App\Infrastructure\City\Service\CitySelectorManager->getCityByIp (line 48)
7	App\Infrastructure\City\Service\CitySelectorManager->getCity (line 59)
8	App\EventSubscriber\CityRedirectListener->onKernelRequest (line 116)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

0.69 ms

SELECT t0.name AS name_1, t0.name_prepositional AS name_prepositional_2, t0.banner_path AS banner_path_3, t0.slug AS slug_4, t0.db_ip_light_city_id AS db_ip_light_city_id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.metadata_title AS metadata_title_9, t0.metadata_description AS metadata_description_10, t0.metadata_keywords AS metadata_keywords_11, t0.region_id AS region_id_12 FROM city t0 WHERE t0.id = ?

Parameters:

[
  "1efe92d4-23a2-686c-a633-85927c91bd49"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.name_prepositional AS name_prepositional_2,
  t0.banner_path AS banner_path_3,
  t0.slug AS slug_4,
  t0.db_ip_light_city_id AS db_ip_light_city_id_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.id AS id_8,
  t0.metadata_title AS metadata_title_9,
  t0.metadata_description AS metadata_description_10,
  t0.metadata_keywords AS metadata_keywords_11,
  t0.region_id AS region_id_12
FROM
  city t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.name_prepositional AS name_prepositional_2, t0.banner_path AS banner_path_3, t0.slug AS slug_4, t0.db_ip_light_city_id AS db_ip_light_city_id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.metadata_title AS metadata_title_9, t0.metadata_description AS metadata_description_10, t0.metadata_keywords AS metadata_keywords_11, t0.region_id AS region_id_12 FROM city t0 WHERE t0.id = '1efe92d4-23a2-686c-a633-85927c91bd49';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 83)
6	App\Infrastructure\City\Service\CitySelectorManager->getDefaultCity (line 50)
7	App\Infrastructure\City\Service\CitySelectorManager->getCity (line 59)
8	App\EventSubscriber\CityRedirectListener->onKernelRequest (line 116)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

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.

Symfony Profiler

GET https://raberu.raduga.red/vacancies?company=1f06d014-bdfc-6fc2-93c2-414e9b30c048&unset=city

Configuration Settings

Theme