Symfony Profiler

Query Metrics

16 Database Queries

8 Different statements

15.63 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.86 ms
(18.30%)

SELECT DISTINCT s0_.id AS id_0 FROM student s0_ WHERE (LOWER(s0_.first_name || '') LIKE ? OR LOWER(s0_.last_name || '') LIKE ? OR LOWER(s0_.email || '') LIKE ? OR LOWER(s0_.surname || '') LIKE ?) AND (LOWER(s0_.first_name || '') LIKE ? OR LOWER(s0_.last_name || '') LIKE ? OR LOWER(s0_.email || '') LIKE ? OR LOWER(s0_.surname || '') LIKE ?) LIMIT 20

Parameters:

[
  "%աննա%"
  "%աննա%"
  "%աննա%"
  "%աննա%"
  "%նիկ%"
  "%նիկ%"
  "%նիկ%"
  "%նիկ%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT s0_.id AS id_0
FROM
  student s0_
WHERE
  (
    LOWER(s0_.first_name || '') LIKE ?
    OR LOWER(s0_.last_name || '') LIKE ?
    OR LOWER(s0_.email || '') LIKE ?
    OR LOWER(s0_.surname || '') LIKE ?
  )
  AND (
    LOWER(s0_.first_name || '') LIKE ?
    OR LOWER(s0_.last_name || '') LIKE ?
    OR LOWER(s0_.email || '') LIKE ?
    OR LOWER(s0_.surname || '') LIKE ?
  )
LIMIT
  20

SELECT DISTINCT s0_.id AS id_0 FROM student s0_ WHERE (LOWER(s0_.first_name || '') LIKE '%աննա%' OR LOWER(s0_.last_name || '') LIKE '%աննա%' OR LOWER(s0_.email || '') LIKE '%աննա%' OR LOWER(s0_.surname || '') LIKE '%աննա%') AND (LOWER(s0_.first_name || '') LIKE '%նիկ%' OR LOWER(s0_.last_name || '') LIKE '%նիկ%' OR LOWER(s0_.email || '') LIKE '%նիկ%' OR LOWER(s0_.surname || '') LIKE '%նիկ%') LIMIT 20;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 127)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 70)
8	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 26)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 132)
10	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

2.77 ms
(17.69%)

SELECT count(s0_.id) AS sclr_0 FROM student s0_ WHERE (LOWER(s0_.first_name || '') LIKE ? OR LOWER(s0_.last_name || '') LIKE ? OR LOWER(s0_.email || '') LIKE ? OR LOWER(s0_.surname || '') LIKE ?) AND (LOWER(s0_.first_name || '') LIKE ? OR LOWER(s0_.last_name || '') LIKE ? OR LOWER(s0_.email || '') LIKE ? OR LOWER(s0_.surname || '') LIKE ?)

Parameters:

[
  "%աննա%"
  "%աննա%"
  "%աննա%"
  "%աննա%"
  "%նիկ%"
  "%նիկ%"
  "%նիկ%"
  "%նիկ%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(s0_.id) AS sclr_0
FROM
  student s0_
WHERE
  (
    LOWER(s0_.first_name || '') LIKE ?
    OR LOWER(s0_.last_name || '') LIKE ?
    OR LOWER(s0_.email || '') LIKE ?
    OR LOWER(s0_.surname || '') LIKE ?
  )
  AND (
    LOWER(s0_.first_name || '') LIKE ?
    OR LOWER(s0_.last_name || '') LIKE ?
    OR LOWER(s0_.email || '') LIKE ?
    OR LOWER(s0_.surname || '') LIKE ?
  )

SELECT count(s0_.id) AS sclr_0 FROM student s0_ WHERE (LOWER(s0_.first_name || '') LIKE '%աննա%' OR LOWER(s0_.last_name || '') LIKE '%աննա%' OR LOWER(s0_.email || '') LIKE '%աննա%' OR LOWER(s0_.surname || '') LIKE '%աննա%') AND (LOWER(s0_.first_name || '') LIKE '%նիկ%' OR LOWER(s0_.last_name || '') LIKE '%նիկ%' OR LOWER(s0_.email || '') LIKE '%նիկ%' OR LOWER(s0_.surname || '') LIKE '%նիկ%');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 71)
8	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 26)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 132)
10	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

2.21 ms
(14.14%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.verification_token AS verification_token_6, t0.reset_token AS reset_token_7, t0.reset_token_expires_at AS reset_token_expires_at_8, t0.first_name AS first_name_9, t0.last_name AS last_name_10, t0.verify_code AS verify_code_11, t0.verify_code_created_at AS verify_code_created_at_12, t0.jwt_token AS jwt_token_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t16.id AS id_17, t16.first_name AS first_name_18, t16.last_name AS last_name_19, t16.email AS email_20, t16.surname AS surname_21, t16.created_at AS created_at_22, t16.updated_at AS updated_at_23, t16.timesheet_number AS timesheet_number_24, t16.m_id AS m_id_25, t16.user_id AS user_id_26, t27.id AS id_28, t27.direction_sub_group_id AS direction_sub_group_id_29, t27.lessons_time_map AS lessons_time_map_30, t27.lessons_type_map AS lessons_type_map_31, t27.matrix AS matrix_32, t27.removed_lessons AS removed_lessons_33, t27.first_name AS first_name_34, t27.last_name AS last_name_35, t27.age AS age_36, t27.email AS email_37, t27.surname AS surname_38, t27.created_at AS created_at_39, t27.updated_at AS updated_at_40, t27.group_id AS group_id_41, t27.user_id AS user_id_42 FROM "user" t0 LEFT JOIN teacher t16 ON t16.user_id = t0.id LEFT JOIN student t27 ON t27.user_id = t0.id WHERE t0.id = ?

Parameters:

[
  27
]

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.is_verified AS is_verified_5,
  t0.verification_token AS verification_token_6,
  t0.reset_token AS reset_token_7,
  t0.reset_token_expires_at AS reset_token_expires_at_8,
  t0.first_name AS first_name_9,
  t0.last_name AS last_name_10,
  t0.verify_code AS verify_code_11,
  t0.verify_code_created_at AS verify_code_created_at_12,
  t0.jwt_token AS jwt_token_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t16.id AS id_17,
  t16.first_name AS first_name_18,
  t16.last_name AS last_name_19,
  t16.email AS email_20,
  t16.surname AS surname_21,
  t16.created_at AS created_at_22,
  t16.updated_at AS updated_at_23,
  t16.timesheet_number AS timesheet_number_24,
  t16.m_id AS m_id_25,
  t16.user_id AS user_id_26,
  t27.id AS id_28,
  t27.direction_sub_group_id AS direction_sub_group_id_29,
  t27.lessons_time_map AS lessons_time_map_30,
  t27.lessons_type_map AS lessons_type_map_31,
  t27.matrix AS matrix_32,
  t27.removed_lessons AS removed_lessons_33,
  t27.first_name AS first_name_34,
  t27.last_name AS last_name_35,
  t27.age AS age_36,
  t27.email AS email_37,
  t27.surname AS surname_38,
  t27.created_at AS created_at_39,
  t27.updated_at AS updated_at_40,
  t27.group_id AS group_id_41,
  t27.user_id AS user_id_42
FROM
  "user" t0
  LEFT JOIN teacher t16 ON t16.user_id = t0.id
  LEFT JOIN student t27 ON t27.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.is_verified AS is_verified_5, t0.verification_token AS verification_token_6, t0.reset_token AS reset_token_7, t0.reset_token_expires_at AS reset_token_expires_at_8, t0.first_name AS first_name_9, t0.last_name AS last_name_10, t0.verify_code AS verify_code_11, t0.verify_code_created_at AS verify_code_created_at_12, t0.jwt_token AS jwt_token_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t16.id AS id_17, t16.first_name AS first_name_18, t16.last_name AS last_name_19, t16.email AS email_20, t16.surname AS surname_21, t16.created_at AS created_at_22, t16.updated_at AS updated_at_23, t16.timesheet_number AS timesheet_number_24, t16.m_id AS m_id_25, t16.user_id AS user_id_26, t27.id AS id_28, t27.direction_sub_group_id AS direction_sub_group_id_29, t27.lessons_time_map AS lessons_time_map_30, t27.lessons_type_map AS lessons_type_map_31, t27.matrix AS matrix_32, t27.removed_lessons AS removed_lessons_33, t27.first_name AS first_name_34, t27.last_name AS last_name_35, t27.age AS age_36, t27.email AS email_37, t27.surname AS surname_38, t27.created_at AS created_at_39, t27.updated_at AS updated_at_40, t27.group_id AS group_id_41, t27.user_id AS user_id_42 FROM "user" t0 LEFT JOIN teacher t16 ON t16.user_id = t0.id LEFT JOIN student t27 ON t27.user_id = t0.id WHERE t0.id = 27;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 357)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 92)
7	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 207)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 60)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 77)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

2.06 ms
(13.16%)

SELECT t0.id AS id_1, t0.duration_in_minutes AS duration_in_minutes_2, t0.length AS length_3, t0.tmp_count AS tmp_count_4, t0.start_time AS start_time_5, t0.end_time AS end_time_6, t0.group_ids AS group_ids_7, t0.sub_group_ids AS sub_group_ids_8, t0.phase_group_ids AS phase_group_ids_9, t0.ref_id AS ref_id_10, t0.phase_part AS phase_part_11, t0.group_id AS group_id_12, t0.sub_group_id AS sub_group_id_13, t0.lesson_id AS lesson_id_14, t0.department_id AS department_id_15, t0.teacher_id AS teacher_id_16, t0.phase_group_id AS phase_group_id_17, t0.room_id AS room_id_18, t0.selecting_class_time_id AS selecting_class_time_id_19, t0.type_class_id AS type_class_id_20 FROM class_time t0 INNER JOIN student_class_time ON t0.id = student_class_time.class_time_id WHERE student_class_time.student_id = ?

Parameters:

[
  327
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.duration_in_minutes AS duration_in_minutes_2,
  t0.length AS length_3,
  t0.tmp_count AS tmp_count_4,
  t0.start_time AS start_time_5,
  t0.end_time AS end_time_6,
  t0.group_ids AS group_ids_7,
  t0.sub_group_ids AS sub_group_ids_8,
  t0.phase_group_ids AS phase_group_ids_9,
  t0.ref_id AS ref_id_10,
  t0.phase_part AS phase_part_11,
  t0.group_id AS group_id_12,
  t0.sub_group_id AS sub_group_id_13,
  t0.lesson_id AS lesson_id_14,
  t0.department_id AS department_id_15,
  t0.teacher_id AS teacher_id_16,
  t0.phase_group_id AS phase_group_id_17,
  t0.room_id AS room_id_18,
  t0.selecting_class_time_id AS selecting_class_time_id_19,
  t0.type_class_id AS type_class_id_20
FROM
  class_time t0
  INNER JOIN student_class_time ON t0.id = student_class_time.class_time_id
WHERE
  student_class_time.student_id = ?

SELECT t0.id AS id_1, t0.duration_in_minutes AS duration_in_minutes_2, t0.length AS length_3, t0.tmp_count AS tmp_count_4, t0.start_time AS start_time_5, t0.end_time AS end_time_6, t0.group_ids AS group_ids_7, t0.sub_group_ids AS sub_group_ids_8, t0.phase_group_ids AS phase_group_ids_9, t0.ref_id AS ref_id_10, t0.phase_part AS phase_part_11, t0.group_id AS group_id_12, t0.sub_group_id AS sub_group_id_13, t0.lesson_id AS lesson_id_14, t0.department_id AS department_id_15, t0.teacher_id AS teacher_id_16, t0.phase_group_id AS phase_group_id_17, t0.room_id AS room_id_18, t0.selecting_class_time_id AS selecting_class_time_id_19, t0.type_class_id AS type_class_id_20 FROM class_time t0 INNER JOIN student_class_time ON t0.id = student_class_time.class_time_id WHERE student_class_time.student_id = 327;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1076)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1005)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2709)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 276)
9	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->countNumElements (line 226)
10	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->configureToManyAssociation (line 142)
11	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->configure (line 102)
12	EasyCorp\Bundle\EasyAdminBundle\Factory\FieldFactory->processFields (line 43)
13	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->processFields (line 49)
14	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->processFieldsForAll (line 143)
15	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

1.93 ms
(12.37%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.number AS number_3, t0.matrix AS matrix_4, t0.m_id AS m_id_5, t0.group_id AS group_id_6, t0.lesson_id AS lesson_id_7, t0.type_class_id AS type_class_id_8, t0.group_direction_id AS group_direction_id_9 FROM sub_group t0 INNER JOIN student_sub_group ON t0.id = student_sub_group.sub_group_id WHERE student_sub_group.student_id = ?

Parameters:

[
  327
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.number AS number_3,
  t0.matrix AS matrix_4,
  t0.m_id AS m_id_5,
  t0.group_id AS group_id_6,
  t0.lesson_id AS lesson_id_7,
  t0.type_class_id AS type_class_id_8,
  t0.group_direction_id AS group_direction_id_9
FROM
  sub_group t0
  INNER JOIN student_sub_group ON t0.id = student_sub_group.sub_group_id
WHERE
  student_sub_group.student_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.number AS number_3, t0.matrix AS matrix_4, t0.m_id AS m_id_5, t0.group_id AS group_id_6, t0.lesson_id AS lesson_id_7, t0.type_class_id AS type_class_id_8, t0.group_direction_id AS group_direction_id_9 FROM sub_group t0 INNER JOIN student_sub_group ON t0.id = student_sub_group.sub_group_id WHERE student_sub_group.student_id = 327;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1076)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1005)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2709)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 276)
9	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->countNumElements (line 226)
10	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->configureToManyAssociation (line 142)
11	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->configure (line 102)
12	EasyCorp\Bundle\EasyAdminBundle\Factory\FieldFactory->processFields (line 43)
13	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->processFields (line 49)
14	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->processFieldsForAll (line 143)
15	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

1.74 ms
(11.15%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.number AS number_3, t0.phase_index_title AS phase_index_title_4, t0.group_id AS group_id_5, t0.sub_group_id AS sub_group_id_6, t0.lesson_id AS lesson_id_7, t0.type_class_id AS type_class_id_8, t0.phase_item_id AS phase_item_id_9 FROM phase_group t0 INNER JOIN student_phase_group ON t0.id = student_phase_group.phase_group_id WHERE student_phase_group.student_id = ?

Parameters:

[
  327
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.number AS number_3,
  t0.phase_index_title AS phase_index_title_4,
  t0.group_id AS group_id_5,
  t0.sub_group_id AS sub_group_id_6,
  t0.lesson_id AS lesson_id_7,
  t0.type_class_id AS type_class_id_8,
  t0.phase_item_id AS phase_item_id_9
FROM
  phase_group t0
  INNER JOIN student_phase_group ON t0.id = student_phase_group.phase_group_id
WHERE
  student_phase_group.student_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.number AS number_3, t0.phase_index_title AS phase_index_title_4, t0.group_id AS group_id_5, t0.sub_group_id AS sub_group_id_6, t0.lesson_id AS lesson_id_7, t0.type_class_id AS type_class_id_8, t0.phase_item_id AS phase_item_id_9 FROM phase_group t0 INNER JOIN student_phase_group ON t0.id = student_phase_group.phase_group_id WHERE student_phase_group.student_id = 327;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1076)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1005)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2709)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 276)
9	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->countNumElements (line 226)
10	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->configureToManyAssociation (line 142)
11	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->configure (line 102)
12	EasyCorp\Bundle\EasyAdminBundle\Factory\FieldFactory->processFields (line 43)
13	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->processFields (line 49)
14	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->processFieldsForAll (line 143)
15	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

1.39 ms
(8.89%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.number AS number_3, t0.m_id AS m_id_4, t0.level_class_id AS level_class_id_5 FROM "group" t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.number AS number_3,
  t0.m_id AS m_id_4,
  t0.level_class_id AS level_class_id_5
FROM
  "group" t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.number AS number_3, t0.m_id AS m_id_4, t0.level_class_id AS level_class_id_5 FROM "group" t0 WHERE t0.id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Group::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 88)
7	Proxies\__CG__\App\Entity\Group->initializeLazyObject (line 20)
8	Proxies\__CG__\App\Entity\Group->__load (line 116)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->doCreate (line 75)
10	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->createForEntityInstance (line 200)
11	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->configureToOneAssociation (line 138)
12	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->configure (line 102)
13	EasyCorp\Bundle\EasyAdminBundle\Factory\FieldFactory->processFields (line 43)
14	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->processFields (line 49)
15	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->processFieldsForAll (line 143)
16	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.67 ms
(4.30%)

SELECT s0_.id AS id_0, s0_.direction_sub_group_id AS direction_sub_group_id_1, s0_.lessons_time_map AS lessons_time_map_2, s0_.lessons_type_map AS lessons_type_map_3, s0_.matrix AS matrix_4, s0_.removed_lessons AS removed_lessons_5, s0_.first_name AS first_name_6, s0_.last_name AS last_name_7, s0_.age AS age_8, s0_.email AS email_9, s0_.surname AS surname_10, s0_.created_at AS created_at_11, s0_.updated_at AS updated_at_12, s0_.group_id AS group_id_13, s0_.user_id AS user_id_14 FROM student s0_ WHERE (LOWER(s0_.first_name || '') LIKE ? OR LOWER(s0_.last_name || '') LIKE ? OR LOWER(s0_.email || '') LIKE ? OR LOWER(s0_.surname || '') LIKE ?) AND (LOWER(s0_.first_name || '') LIKE ? OR LOWER(s0_.last_name || '') LIKE ? OR LOWER(s0_.email || '') LIKE ? OR LOWER(s0_.surname || '') LIKE ?) AND s0_.id IN (?, ?, ?)

Parameters:

[
  "%աննա%"
  "%աննա%"
  "%աննա%"
  "%աննա%"
  "%նիկ%"
  "%նիկ%"
  "%նիկ%"
  "%նիկ%"
  327
  880
  1018
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.direction_sub_group_id AS direction_sub_group_id_1,
  s0_.lessons_time_map AS lessons_time_map_2,
  s0_.lessons_type_map AS lessons_type_map_3,
  s0_.matrix AS matrix_4,
  s0_.removed_lessons AS removed_lessons_5,
  s0_.first_name AS first_name_6,
  s0_.last_name AS last_name_7,
  s0_.age AS age_8,
  s0_.email AS email_9,
  s0_.surname AS surname_10,
  s0_.created_at AS created_at_11,
  s0_.updated_at AS updated_at_12,
  s0_.group_id AS group_id_13,
  s0_.user_id AS user_id_14
FROM
  student s0_
WHERE
  (
    LOWER(s0_.first_name || '') LIKE ?
    OR LOWER(s0_.last_name || '') LIKE ?
    OR LOWER(s0_.email || '') LIKE ?
    OR LOWER(s0_.surname || '') LIKE ?
  )
  AND (
    LOWER(s0_.first_name || '') LIKE ?
    OR LOWER(s0_.last_name || '') LIKE ?
    OR LOWER(s0_.email || '') LIKE ?
    OR LOWER(s0_.surname || '') LIKE ?
  )
  AND s0_.id IN (?, ?, ?)

SELECT s0_.id AS id_0, s0_.direction_sub_group_id AS direction_sub_group_id_1, s0_.lessons_time_map AS lessons_time_map_2, s0_.lessons_type_map AS lessons_type_map_3, s0_.matrix AS matrix_4, s0_.removed_lessons AS removed_lessons_5, s0_.first_name AS first_name_6, s0_.last_name AS last_name_7, s0_.age AS age_8, s0_.email AS email_9, s0_.surname AS surname_10, s0_.created_at AS created_at_11, s0_.updated_at AS updated_at_12, s0_.group_id AS group_id_13, s0_.user_id AS user_id_14 FROM student s0_ WHERE (LOWER(s0_.first_name || '') LIKE '%աննա%' OR LOWER(s0_.last_name || '') LIKE '%աննա%' OR LOWER(s0_.email || '') LIKE '%աննա%' OR LOWER(s0_.surname || '') LIKE '%աննա%') AND (LOWER(s0_.first_name || '') LIKE '%նիկ%' OR LOWER(s0_.last_name || '') LIKE '%նիկ%' OR LOWER(s0_.email || '') LIKE '%նիկ%' OR LOWER(s0_.surname || '') LIKE '%նիկ%') AND s0_.id IN (327, 880, 1018);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 145)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 70)
8	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 26)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 132)
10	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	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\Teacher	No errors.
App\Entity\Student	No errors.
App\Entity\Group	No errors.
App\Entity\ChoosedLesson	The association App\Entity\ChoosedLesson#typeClass refers to the inverse side field App\Entity\TypeClass#choosedLessons which does not exist.
App\Entity\SubGroup	No errors.
App\Entity\PhaseGroup	No errors.
App\Entity\ClassTime	No errors.
App\Entity\LevelClass	No errors.
App\Entity\GroupDirection	No errors.
App\Entity\Phase	No errors.
App\Entity\Lesson	No errors.
App\Entity\TypeClass	The mappings App\Entity\TypeClass#choosedLesson and App\Entity\ChoosedLesson#typeClass are inconsistent with each other.
App\Entity\SelectingClassTime	No errors.
App\Entity\SelectingClassTimeGroup	No errors.
App\Entity\PhaseItem	No errors.
App\Entity\Department	No errors.
App\Entity\Room	No errors.

Symfony Profiler

GET https://edelar.tech/admin?crudAction=index&crudControllerFqcn=App%5CController%5CAdmin%5CStudentCrudController&page=1&query=%D4%B1%D5%B6%D5%B6%D5%A1%20%D5%86%D5…

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping