GET https://raberu2.itservice18.ru/api/v1/user/context

Query Metrics

7 Database Queries
7 Different statements
14.41 ms Query time
0 Invalid entities
4 Managed entities

Queries

Group similar statements

# Time Info
1 5.31 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:
[
  "1efe2f24-5814-60b4-ae53-d3290c4a327c"
]
2 1.65 ms
SELECT t0.role AS role_1, t0.position AS position_2, t0.comment AS comment_3, t0.phone AS phone_4, t0.limit_basic AS limit_basic_5, t0.limit_optimum AS limit_optimum_6, t0.user_id AS user_id_7, t0.company_id AS company_id_8 FROM company_employer t0 WHERE t0.user_id = ?
Parameters:
[
  "1efe2f24-5814-60b4-ae53-d3290c4a327c"
]
3 1.06 ms
SELECT t0.applicant_status AS applicant_status_1, t0.user_id AS user_id_2 FROM applicant t0 WHERE t0.user_id = ? LIMIT 1
Parameters:
[
  "1efe2f24-5814-60b4-ae53-d3290c4a327c"
]
4 0.33 ms
SELECT t0.role AS role_1, t0.position AS position_2, t0.comment AS comment_3, t0.phone AS phone_4, t0.limit_basic AS limit_basic_5, t0.limit_optimum AS limit_optimum_6, t0.user_id AS user_id_7, t0.company_id AS company_id_8 FROM company_employer t0 WHERE t0.user_id = ? LIMIT 1
Parameters:
[
  "1efe2f24-5814-60b4-ae53-d3290c4a327c"
]
5 1.98 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:
[
  "1ef3ab2d-2b26-6b22-a5fa-8f4f45f98ab7"
]
6 3.10 ms
SELECT n0_.title AS title_0, n0_.body AS body_1, n0_.type AS type_2, n0_.read_at AS read_at_3, n0_.created_at AS created_at_4, n0_.updated_at AS updated_at_5, n0_.id AS id_6, n0_.user_id AS user_id_7 FROM notification n0_ WHERE n0_.user_id = ? ORDER BY n0_.created_at DESC LIMIT 6
Parameters:
[
  Symfony\Component\Uid\UuidV6 {#2153
    __toString(): "1efe2f24-5814-60b4-ae53-d3290c4a327c"
  }
]
7 0.99 ms
SELECT COUNT(n0_.id) AS sclr_0 FROM notification n0_ WHERE n0_.user_id = ? AND n0_.read_at IS NULL
Parameters:
[
  Symfony\Component\Uid\UuidV6 {#2153
    __toString(): "1efe2f24-5814-60b4-ae53-d3290c4a327c"
  }
]

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\Domain\User\User 1
App\Domain\City\City 1
App\Domain\Applicant\Applicant 1
App\Domain\City\Region 1

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\VacancyImportHistory No errors.
App\Domain\VacancyImport\VacancyImport No errors.
App\Domain\Blog\BlogAnchor No errors.
App\Domain\Blog\BlogAuthorLog No errors.
App\Domain\Blog\BlogAuthor No errors.
App\Domain\Blog\BlogTag No errors.
App\Domain\Blog\BlogTagLog No errors.
App\Domain\Blog\Blog No errors.
App\Domain\Blog\BlogLog 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\ConfirmRequest No errors.
App\Domain\User\ResetPasswordRequest 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\ResumeSchedule No errors.
App\Domain\Resume\PreviousJob No errors.
App\Domain\Resume\Comment No errors.
App\Domain\Resume\ResumeView No errors.
App\Domain\Resume\LanguageKnowledge No errors.
App\Domain\Resume\ResumeEmployment No errors.
App\Domain\Resume\Course No errors.
App\Domain\Resume\Education No errors.
App\Domain\Act\Act No errors.
App\Domain\Bill\Bill No errors.
App\Domain\Cart\CartBuyOrder No errors.
App\Domain\Cart\Cart 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\Settings No errors.
App\Domain\Notification\Site\Notification No errors.
App\Domain\AuthProviders\UserAuthProviders No errors.
App\Domain\Contract\Contract No errors.
App\Domain\Vacancy\Event\History No errors.
App\Domain\Vacancy\Event\Publication No errors.
App\Domain\Vacancy\Event\View No errors.
App\Domain\Vacancy\Event\Favorite No errors.
App\Domain\Vacancy\Event\ViewPhone No errors.