Symfony Profiler

Query Metrics

10 Database Queries

8 Different statements

15.15 ms Query time

0 Invalid entities

Queries


SELECT t0.public_id AS public_id_1, t0.email AS email_2, t0.password AS password_3, t0.role AS role_4, t0.enabled AS enabled_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8 FROM admin t0 WHERE t0.id = ?
"START TRANSACTION"
UPDATE admin SET public_id = ?, updated_at = ? WHERE id = ?
"COMMIT"
SELECT COUNT(v0_.id) AS sclr_0 FROM vacancy_imports v0_
SELECT v0_.uploaded_at AS uploaded_at_0, v0_.vacancies_count AS vacancies_count_1, v0_.imported_vacancies_count AS imported_vacancies_count_2, v0_.status AS status_3, v0_.id AS id_4, v0_.document_name AS document_name_5, v0_.file_path AS file_path_6, v0_.company_id AS company_id_7, v0_.uploaded_by_id AS uploaded_by_id_8 FROM vacancy_imports v0_ ORDER BY v0_.uploaded_at DESC LIMIT 10
SELECT t0.public_id AS public_id_1, t0.title AS title_2, t0.inn AS inn_3, t0.description AS description_4, t0.logo_path AS logo_path_5, t0.confirmed AS confirmed_6, t0.contract_path AS contract_path_7, t0.rating AS rating_8, t0.site AS site_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.id AS id_12, t0.city_id AS city_id_13, t0.category_id AS category_id_14 FROM companies t0 WHERE t0.id = ?
SELECT t0.balance AS balance_1, t0.company_id AS company_id_2 FROM company_personal_account t0 WHERE t0.company_id = ?
SELECT t0.public_id AS public_id_1, t0.title AS title_2, t0.inn AS inn_3, t0.description AS description_4, t0.logo_path AS logo_path_5, t0.confirmed AS confirmed_6, t0.contract_path AS contract_path_7, t0.rating AS rating_8, t0.site AS site_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.id AS id_12, t0.city_id AS city_id_13, t0.category_id AS category_id_14 FROM companies t0 WHERE t0.id = ?
SELECT t0.balance AS balance_1, t0.company_id AS company_id_2 FROM company_personal_account t0 WHERE t0.company_id = ?

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.

Symfony Profiler

GET https://raberu.raduga.red/admin/?dashboardControllerFqcn=App%5CController%5CAdmin%5CDashboardController&routeName=admin.vacancy.import.list

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping