Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

3.06 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.28 ms
(41.67%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_name AS last_name_5, t0.first_name AS first_name_6, t0.sur_name AS sur_name_7, t0.birth_date AS birth_date_8, t0.snils AS snils_9, t0.phone AS phone_10, t0.phone2 AS phone2_11, t0.created AS created_12, t0.updated AS updated_13, t0.old_id AS old_id_14, t0.year AS year_15, t0.moscow AS moscow_16, t0.status AS status_17, t0.status_date_start AS status_date_start_18, t0.status_date_end AS status_date_end_19, t0.status_comment AS status_comment_20, t0.old_last_name AS old_last_name_21, t0.status_log AS status_log_22, t0.token AS token_23, t0.message AS message_24, t0.enabled AS enabled_25, t26.id AS id_27, t26.series AS series_28, t26.number AS number_29, t26.address AS address_30, t26.date_issue AS date_issue_31, t26.code AS code_32, t26.place_issue AS place_issue_33, t26.zipcode AS zipcode_34, t26.user_id AS user_id_35, t0.type_id AS type_id_36, t0.representative_id AS representative_id_37, t0.selection_bias_id AS selection_bias_id_38, t0.selection_bias_ordinature_id AS selection_bias_ordinature_id_39, t0.organization_id AS organization_id_40, t0.changed_by_id AS changed_by_id_41 FROM user t0 LEFT JOIN user_passport t26 ON t26.user_id = t0.id WHERE t0.id = ?

Parameters:

[
  "12723"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.last_name AS last_name_5,
  t0.first_name AS first_name_6,
  t0.sur_name AS sur_name_7,
  t0.birth_date AS birth_date_8,
  t0.snils AS snils_9,
  t0.phone AS phone_10,
  t0.phone2 AS phone2_11,
  t0.created AS created_12,
  t0.updated AS updated_13,
  t0.old_id AS old_id_14,
  t0.year AS year_15,
  t0.moscow AS moscow_16,
  t0.status AS status_17,
  t0.status_date_start AS status_date_start_18,
  t0.status_date_end AS status_date_end_19,
  t0.status_comment AS status_comment_20,
  t0.old_last_name AS old_last_name_21,
  t0.status_log AS status_log_22,
  t0.token AS token_23,
  t0.message AS message_24,
  t0.enabled AS enabled_25,
  t26.id AS id_27,
  t26.series AS series_28,
  t26.number AS number_29,
  t26.address AS address_30,
  t26.date_issue AS date_issue_31,
  t26.code AS code_32,
  t26.place_issue AS place_issue_33,
  t26.zipcode AS zipcode_34,
  t26.user_id AS user_id_35,
  t0.type_id AS type_id_36,
  t0.representative_id AS representative_id_37,
  t0.selection_bias_id AS selection_bias_id_38,
  t0.selection_bias_ordinature_id AS selection_bias_ordinature_id_39,
  t0.organization_id AS organization_id_40,
  t0.changed_by_id AS changed_by_id_41
FROM
  user t0
  LEFT JOIN user_passport t26 ON t26.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_name AS last_name_5, t0.first_name AS first_name_6, t0.sur_name AS sur_name_7, t0.birth_date AS birth_date_8, t0.snils AS snils_9, t0.phone AS phone_10, t0.phone2 AS phone2_11, t0.created AS created_12, t0.updated AS updated_13, t0.old_id AS old_id_14, t0.year AS year_15, t0.moscow AS moscow_16, t0.status AS status_17, t0.status_date_start AS status_date_start_18, t0.status_date_end AS status_date_end_19, t0.status_comment AS status_comment_20, t0.old_last_name AS old_last_name_21, t0.status_log AS status_log_22, t0.token AS token_23, t0.message AS message_24, t0.enabled AS enabled_25, t26.id AS id_27, t26.series AS series_28, t26.number AS number_29, t26.address AS address_30, t26.date_issue AS date_issue_31, t26.code AS code_32, t26.place_issue AS place_issue_33, t26.zipcode AS zipcode_34, t26.user_id AS user_id_35, t0.type_id AS type_id_36, t0.representative_id AS representative_id_37, t0.selection_bias_id AS selection_bias_id_38, t0.selection_bias_ordinature_id AS selection_bias_ordinature_id_39, t0.organization_id AS organization_id_40, t0.changed_by_id AS changed_by_id_41 FROM user t0 LEFT JOIN user_passport t26 ON t26.user_id = t0.id WHERE t0.id = '12723';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 28)
6	App\Controller\Sonata\Api\UserPracticController->inArhive (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

1.03 ms
(33.67%)

SELECT t0.id AS id_1, t0.last_name AS last_name_2, t0.first_name AS first_name_3, t0.sur_name AS sur_name_4, t0.birth_date AS birth_date_5, t0.passport_id AS passport_id_6, t7.id AS id_8, t7.email AS email_9, t7.roles AS roles_10, t7.password AS password_11, t7.last_name AS last_name_12, t7.first_name AS first_name_13, t7.sur_name AS sur_name_14, t7.birth_date AS birth_date_15, t7.snils AS snils_16, t7.phone AS phone_17, t7.phone2 AS phone2_18, t7.created AS created_19, t7.updated AS updated_20, t7.old_id AS old_id_21, t7.year AS year_22, t7.moscow AS moscow_23, t7.status AS status_24, t7.status_date_start AS status_date_start_25, t7.status_date_end AS status_date_end_26, t7.status_comment AS status_comment_27, t7.old_last_name AS old_last_name_28, t7.status_log AS status_log_29, t7.token AS token_30, t7.message AS message_31, t7.enabled AS enabled_32, t7.type_id AS type_id_33, t7.representative_id AS representative_id_34, t7.selection_bias_id AS selection_bias_id_35, t7.selection_bias_ordinature_id AS selection_bias_ordinature_id_36, t7.organization_id AS organization_id_37, t7.changed_by_id AS changed_by_id_38 FROM user_representative t0 LEFT JOIN user t7 ON t7.representative_id = t0.id WHERE t0.passport_id = ?

Parameters:

[
  14431
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.last_name AS last_name_2,
  t0.first_name AS first_name_3,
  t0.sur_name AS sur_name_4,
  t0.birth_date AS birth_date_5,
  t0.passport_id AS passport_id_6,
  t7.id AS id_8,
  t7.email AS email_9,
  t7.roles AS roles_10,
  t7.password AS password_11,
  t7.last_name AS last_name_12,
  t7.first_name AS first_name_13,
  t7.sur_name AS sur_name_14,
  t7.birth_date AS birth_date_15,
  t7.snils AS snils_16,
  t7.phone AS phone_17,
  t7.phone2 AS phone2_18,
  t7.created AS created_19,
  t7.updated AS updated_20,
  t7.old_id AS old_id_21,
  t7.year AS year_22,
  t7.moscow AS moscow_23,
  t7.status AS status_24,
  t7.status_date_start AS status_date_start_25,
  t7.status_date_end AS status_date_end_26,
  t7.status_comment AS status_comment_27,
  t7.old_last_name AS old_last_name_28,
  t7.status_log AS status_log_29,
  t7.token AS token_30,
  t7.message AS message_31,
  t7.enabled AS enabled_32,
  t7.type_id AS type_id_33,
  t7.representative_id AS representative_id_34,
  t7.selection_bias_id AS selection_bias_id_35,
  t7.selection_bias_ordinature_id AS selection_bias_ordinature_id_36,
  t7.organization_id AS organization_id_37,
  t7.changed_by_id AS changed_by_id_38
FROM
  user_representative t0
  LEFT JOIN user t7 ON t7.representative_id = t0.id
WHERE
  t0.passport_id = ?

SELECT t0.id AS id_1, t0.last_name AS last_name_2, t0.first_name AS first_name_3, t0.sur_name AS sur_name_4, t0.birth_date AS birth_date_5, t0.passport_id AS passport_id_6, t7.id AS id_8, t7.email AS email_9, t7.roles AS roles_10, t7.password AS password_11, t7.last_name AS last_name_12, t7.first_name AS first_name_13, t7.sur_name AS sur_name_14, t7.birth_date AS birth_date_15, t7.snils AS snils_16, t7.phone AS phone_17, t7.phone2 AS phone2_18, t7.created AS created_19, t7.updated AS updated_20, t7.old_id AS old_id_21, t7.year AS year_22, t7.moscow AS moscow_23, t7.status AS status_24, t7.status_date_start AS status_date_start_25, t7.status_date_end AS status_date_end_26, t7.status_comment AS status_comment_27, t7.old_last_name AS old_last_name_28, t7.status_log AS status_log_29, t7.token AS token_30, t7.message AS message_31, t7.enabled AS enabled_32, t7.type_id AS type_id_33, t7.representative_id AS representative_id_34, t7.selection_bias_id AS selection_bias_id_35, t7.selection_bias_ordinature_id AS selection_bias_ordinature_id_36, t7.organization_id AS organization_id_37, t7.changed_by_id AS changed_by_id_38 FROM user_representative t0 LEFT JOIN user t7 ON t7.representative_id = t0.id WHERE t0.passport_id = 14431;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 843)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2966)
4	Doctrine\ORM\UnitOfWork->createEntity (line 272)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 445)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 270)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 779)
9	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
10	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
11	Doctrine\ORM\EntityManager->find (line 197)
12	Doctrine\ORM\EntityRepository->find (line 28)
13	App\Controller\Sonata\Api\UserPracticController->inArhive (line 181)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 5)

0.76 ms
(24.66%)

SELECT t0.id AS id_1, t0.created AS created_2, t0.is_was AS is_was_3, t0.date AS date_4, t0.comment AS comment_5, t0.user_id AS user_id_6, t0.parctic_id AS parctic_id_7 FROM practic_chedule t0 WHERE t0.user_id IN (?)

Parameters:

[
  12723
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.is_was AS is_was_3,
  t0.date AS date_4,
  t0.comment AS comment_5,
  t0.user_id AS user_id_6,
  t0.parctic_id AS parctic_id_7
FROM
  practic_chedule t0
WHERE
  t0.user_id IN (?)

SELECT t0.id AS id_1, t0.created AS created_2, t0.is_was AS is_was_3, t0.date AS date_4, t0.comment AS comment_5, t0.user_id AS user_id_6, t0.parctic_id AS parctic_id_7 FROM practic_chedule t0 WHERE t0.user_id IN (12723);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 779)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 843)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2966)
9	Doctrine\ORM\UnitOfWork->createEntity (line 272)
10	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 445)
11	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
12	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 270)
13	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 779)
14	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
15	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
16	Doctrine\ORM\EntityManager->find (line 197)
17	Doctrine\ORM\EntityRepository->find (line 28)
18	App\Controller\Sonata\Api\UserPracticController->inArhive (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	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\Entity\User	No errors.
App\Entity\UserPassport	No errors.
App\Entity\UserType	No errors.
App\Entity\UserRepresentative	No errors.
App\Entity\Criterion	No errors.
App\Entity\Organization	The association App\Entity\Organization#userPracticsByEducation refers to the owning side field App\Entity\UserPractic#educationOrganization which does not exist. The association App\Entity\Organization#practics refers to the owning side field App\Entity\Practic#educationOrganization which does not exist.
App\Entity\UserDocument	No errors.
App\Entity\UserEducation	No errors.
App\Entity\UserPractic	No errors.
App\Entity\PracticChedule	No errors.
App\Entity\LogUser	No errors.
App\Entity\EduPracticDocument	No errors.
App\Entity\MedPracticDocument	No errors.
App\Entity\Practic	No errors.
App\Entity\Specialty	No errors.
App\Entity\UserRequest	No errors.
App\Entity\Document	No errors.
App\Entity\Status	No errors.
App\Entity\OtherFile	No errors.
App\Entity\PracticStatus	No errors.
App\Entity\PracticDocument	No errors.
App\Entity\RequestStatus	No errors.
App\Entity\DocumentStatus	No errors.
App\Entity\Page	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET http://education.niioz.ru/user/setarhive/12723

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping