Symfony Profiler

Query Metrics

16 Database Queries

12 Different statements

24.98 ms Query time

4 Invalid entities

25 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

6.75 ms
(27.03%)

SELECT t0.name AS name_1, t0.tax_code AS tax_code_2, t0.fiscal_code AS fiscal_code_3, t0.pec_address AS pec_address_4, t0.email_address AS email_address_5, t0.telephone AS telephone_6, t0.telephone_mobile AS telephone_mobile_7, t0.operating AS operating_8, t0.status AS status_9, t0.id AS id_10, t0.active AS active_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted_at AS deleted_at_14, t0.legal_form_id AS legal_form_id_15, t0.institution_size_id AS institution_size_id_16, t0.ateco_code_version_id AS ateco_code_version_id_17, t0.legal_owner_id AS legal_owner_id_18 FROM institutions t0 WHERE t0.legal_owner_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.tax_code AS tax_code_2,
  t0.fiscal_code AS fiscal_code_3,
  t0.pec_address AS pec_address_4,
  t0.email_address AS email_address_5,
  t0.telephone AS telephone_6,
  t0.telephone_mobile AS telephone_mobile_7,
  t0.operating AS operating_8,
  t0.status AS status_9,
  t0.id AS id_10,
  t0.active AS active_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.deleted_at AS deleted_at_14,
  t0.legal_form_id AS legal_form_id_15,
  t0.institution_size_id AS institution_size_id_16,
  t0.ateco_code_version_id AS ateco_code_version_id_17,
  t0.legal_owner_id AS legal_owner_id_18
FROM
  institutions t0
WHERE
  t0.legal_owner_id = ?

SELECT t0.name AS name_1, t0.tax_code AS tax_code_2, t0.fiscal_code AS fiscal_code_3, t0.pec_address AS pec_address_4, t0.email_address AS email_address_5, t0.telephone AS telephone_6, t0.telephone_mobile AS telephone_mobile_7, t0.operating AS operating_8, t0.status AS status_9, t0.id AS id_10, t0.active AS active_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted_at AS deleted_at_14, t0.legal_form_id AS legal_form_id_15, t0.institution_size_id AS institution_size_id_16, t0.ateco_code_version_id AS ateco_code_version_id_17, t0.legal_owner_id AS legal_owner_id_18 FROM institutions t0 WHERE t0.legal_owner_id = 1;

#	File/Call
1	Doctrine\DBAL\Logging\Statement->execute (line 98)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
5	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
6	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
7	Doctrine\ORM\PersistentCollection->initialize (line 186)
8	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
9	App\EventListener\InstitutionBlockedListener->getOperatingInstitution (line 237)
10	App\EventListener\InstitutionBlockedListener->__invoke (line 116)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 182)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 29)
20	require_once (line 5)

2.10 ms
(8.42%)

SELECT count(DISTINCT v0_.id) AS sclr_0 FROM variation_request v0_ INNER JOIN institutions i1_ ON v0_.institution_id = i1_.id WHERE i1_.legal_owner_id = ? AND i1_.operating = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT v0_.id) AS sclr_0
FROM
  variation_request v0_
  INNER JOIN institutions i1_ ON v0_.institution_id = i1_.id
WHERE
  i1_.legal_owner_id = ?
  AND i1_.operating = ?

SELECT count(DISTINCT v0_.id) AS sclr_0 FROM variation_request v0_ INNER JOIN institutions i1_ ON v0_.institution_id = i1_.id WHERE i1_.legal_owner_id = 1 AND i1_.operating = 1;

#	File/Call
1	Doctrine\DBAL\Logging\Statement->execute (line 98)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
4	Doctrine\ORM\Query->_doExecute (line 296)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
6	Doctrine\ORM\AbstractQuery->execute (line 886)
7	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
8	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
9	count (line 43)
10	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 43)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
15	Knp\Component\Pager\Paginator->paginate (line 97)
16	ContainerXWEx2uj\PaginatorProxyBa079e5->paginate (line 25)
17	App\Controller\VariationController->list (line 176)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 182)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 29)
23	require_once (line 5)

2.01 ms
(8.03%)

SELECT COUNT(m0_.id) AS sclr_0 FROM maintenance_request m0_ WHERE m0_.institution_id = ? AND m0_.status NOT IN (?, ?, ?)

Parameters:

[
  2
  "DETERMINA_COMPLETATA"
  "DEFINITIVELY_REJECTED"
  "DEFINITIVELY_APPROVED"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(m0_.id) AS sclr_0
FROM
  maintenance_request m0_
WHERE
  m0_.institution_id = ?
  AND m0_.status NOT IN (?, ?, ?)

SELECT COUNT(m0_.id) AS sclr_0 FROM maintenance_request m0_ WHERE m0_.institution_id = 2 AND m0_.status NOT IN ('DETERMINA_COMPLETATA', 'DEFINITIVELY_REJECTED', 'DEFINITIVELY_APPROVED');

#	File/Call
1	Doctrine\DBAL\Logging\Statement->execute (line 98)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
4	Doctrine\ORM\Query->_doExecute (line 296)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
6	Doctrine\ORM\AbstractQuery->execute (line 886)
7	Doctrine\ORM\AbstractQuery->getSingleResult (line 772)
8	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
9	App\Repository\MaintenanceRequestRepository->hasOpenMaintenanceRequestsByInstitution (line 557)
10	App\Controller\VariationController->list (line 166)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 182)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

1.84 ms
(7.38%)

SELECT t0.identifier AS identifier_1, t0.provider AS provider_2, t0.username AS username_3, t0.email AS email_4, t0.pec AS pec_5, t0.cellular AS cellular_6, t0.fiscal_code AS fiscal_code_7, t0.password AS password_8, t0.last_access AS last_access_9, t0.is_user_suspended AS is_user_suspended_10, t0.id AS id_11, t0.active AS active_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.deleted_at AS deleted_at_15, t0.person_id AS person_id_16, t0.last_operating_institution_id AS last_operating_institution_id_17 FROM user t0 WHERE t0.id = ?

Parameters:

[
  15
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.identifier AS identifier_1,
  t0.provider AS provider_2,
  t0.username AS username_3,
  t0.email AS email_4,
  t0.pec AS pec_5,
  t0.cellular AS cellular_6,
  t0.fiscal_code AS fiscal_code_7,
  t0.password AS password_8,
  t0.last_access AS last_access_9,
  t0.is_user_suspended AS is_user_suspended_10,
  t0.id AS id_11,
  t0.active AS active_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.deleted_at AS deleted_at_15,
  t0.person_id AS person_id_16,
  t0.last_operating_institution_id AS last_operating_institution_id_17
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.identifier AS identifier_1, t0.provider AS provider_2, t0.username AS username_3, t0.email AS email_4, t0.pec AS pec_5, t0.cellular AS cellular_6, t0.fiscal_code AS fiscal_code_7, t0.password AS password_8, t0.last_access AS last_access_9, t0.is_user_suspended AS is_user_suspended_10, t0.id AS id_11, t0.active AS active_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.deleted_at AS deleted_at_15, t0.person_id AS person_id_16, t0.last_operating_institution_id AS last_operating_institution_id_17 FROM user t0 WHERE t0.id = 15;

#	File/Call
1	Doctrine\DBAL\Logging\Statement->execute (line 98)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
5	Doctrine\ORM\EntityManager->find (line 366)
6	Doctrine\ORM\EntityRepository->find (line 86)
7	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
8	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 92)
9	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
10	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
11	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
12	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->Symfony\Bundle\SecurityBundle\Security\{closure} (line 74)
13	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 34)
14	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 42)
15	Symfony\Bundle\SecurityBundle\Security->getToken (line 68)
16	Symfony\Bundle\SecurityBundle\Security->getUser (line 50)
17	App\EventListener\RoleBaseRedirectListener->onKernelRequest (line 30)
18	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
19	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
20	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
21	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 182)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	require_once (line 5)

1.69 ms
(6.76%)

SELECT t0.status AS status_1, t0.request_type AS request_type_2, t0.code AS code_3, t0.accreditation_type AS accreditation_type_4, t0.score AS score_5, t0.send_at AS send_at_6, t0.determina_completed_at AS determina_completed_at_7, t0.accreditation_end_date AS accreditation_end_date_8, t0.renewal_notification_level AS renewal_notification_level_9, t0.viewed_by_instructor_l1 AS viewed_by_instructor_l1_10, t0.viewed_by_instructor_l2 AS viewed_by_instructor_l2_11, t0.viewed_by_instructor_l3 AS viewed_by_instructor_l3_12, t0.assignment_notification2_days_sent AS assignment_notification2_days_sent_13, t0.assignment_notification25_days_sent AS assignment_notification25_days_sent_14, t0.id AS id_15, t0.active AS active_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t20.id AS id_21, t20.active AS active_22, t20.created_at AS created_at_23, t20.updated_at AS updated_at_24, t20.deleted_at AS deleted_at_25, t20.accreditation_application_id AS accreditation_application_id_26, t20.tipology_id AS tipology_id_27, t0.institution_id AS institution_id_28, t0.legal_owner_id AS legal_owner_id_29, t0.institution_typology_id AS institution_typology_id_30, t0.parent_application_id AS parent_application_id_31 FROM accreditation_application t0 LEFT JOIN institutions_accreditation_tipologies t20 ON t20.accreditation_application_id = t0.id WHERE t0.institution_id IN (?)

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.status AS status_1,
  t0.request_type AS request_type_2,
  t0.code AS code_3,
  t0.accreditation_type AS accreditation_type_4,
  t0.score AS score_5,
  t0.send_at AS send_at_6,
  t0.determina_completed_at AS determina_completed_at_7,
  t0.accreditation_end_date AS accreditation_end_date_8,
  t0.renewal_notification_level AS renewal_notification_level_9,
  t0.viewed_by_instructor_l1 AS viewed_by_instructor_l1_10,
  t0.viewed_by_instructor_l2 AS viewed_by_instructor_l2_11,
  t0.viewed_by_instructor_l3 AS viewed_by_instructor_l3_12,
  t0.assignment_notification2_days_sent AS assignment_notification2_days_sent_13,
  t0.assignment_notification25_days_sent AS assignment_notification25_days_sent_14,
  t0.id AS id_15,
  t0.active AS active_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.deleted_at AS deleted_at_19,
  t20.id AS id_21,
  t20.active AS active_22,
  t20.created_at AS created_at_23,
  t20.updated_at AS updated_at_24,
  t20.deleted_at AS deleted_at_25,
  t20.accreditation_application_id AS accreditation_application_id_26,
  t20.tipology_id AS tipology_id_27,
  t0.institution_id AS institution_id_28,
  t0.legal_owner_id AS legal_owner_id_29,
  t0.institution_typology_id AS institution_typology_id_30,
  t0.parent_application_id AS parent_application_id_31
FROM
  accreditation_application t0
  LEFT JOIN institutions_accreditation_tipologies t20 ON t20.accreditation_application_id = t0.id
WHERE
  t0.institution_id IN (?)

SELECT t0.status AS status_1, t0.request_type AS request_type_2, t0.code AS code_3, t0.accreditation_type AS accreditation_type_4, t0.score AS score_5, t0.send_at AS send_at_6, t0.determina_completed_at AS determina_completed_at_7, t0.accreditation_end_date AS accreditation_end_date_8, t0.renewal_notification_level AS renewal_notification_level_9, t0.viewed_by_instructor_l1 AS viewed_by_instructor_l1_10, t0.viewed_by_instructor_l2 AS viewed_by_instructor_l2_11, t0.viewed_by_instructor_l3 AS viewed_by_instructor_l3_12, t0.assignment_notification2_days_sent AS assignment_notification2_days_sent_13, t0.assignment_notification25_days_sent AS assignment_notification25_days_sent_14, t0.id AS id_15, t0.active AS active_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t20.id AS id_21, t20.active AS active_22, t20.created_at AS created_at_23, t20.updated_at AS updated_at_24, t20.deleted_at AS deleted_at_25, t20.accreditation_application_id AS accreditation_application_id_26, t20.tipology_id AS tipology_id_27, t0.institution_id AS institution_id_28, t0.legal_owner_id AS legal_owner_id_29, t0.institution_typology_id AS institution_typology_id_30, t0.parent_application_id AS parent_application_id_31 FROM accreditation_application t0 LEFT JOIN institutions_accreditation_tipologies t20 ON t20.accreditation_application_id = t0.id WHERE t0.institution_id IN (2);

#	File/Call
1	Doctrine\DBAL\Logging\Statement->execute (line 98)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
4	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2677)
5	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 2653)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 124)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 177)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadCollectionFromStatement (line 1026)
9	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1819)
10	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
11	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
12	Doctrine\ORM\PersistentCollection->initialize (line 186)
13	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
14	App\EventListener\InstitutionBlockedListener->getOperatingInstitution (line 237)
15	App\EventListener\InstitutionBlockedListener->__invoke (line 116)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 182)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 5)

1.68 ms
(6.73%)

SELECT t0.context AS context_1, t0.id AS id_2, t0.active AS active_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.institution_type_id AS institution_type_id_7, t0.institution_id AS institution_id_8, t9.status AS status_10, t9.request_type AS request_type_11, t9.code AS code_12, t9.accreditation_type AS accreditation_type_13, t9.score AS score_14, t9.send_at AS send_at_15, t9.determina_completed_at AS determina_completed_at_16, t9.accreditation_end_date AS accreditation_end_date_17, t9.renewal_notification_level AS renewal_notification_level_18, t9.viewed_by_instructor_l1 AS viewed_by_instructor_l1_19, t9.viewed_by_instructor_l2 AS viewed_by_instructor_l2_20, t9.viewed_by_instructor_l3 AS viewed_by_instructor_l3_21, t9.assignment_notification2_days_sent AS assignment_notification2_days_sent_22, t9.assignment_notification25_days_sent AS assignment_notification25_days_sent_23, t9.id AS id_24, t9.active AS active_25, t9.created_at AS created_at_26, t9.updated_at AS updated_at_27, t9.deleted_at AS deleted_at_28, t9.institution_id AS institution_id_29, t9.legal_owner_id AS legal_owner_id_30, t9.institution_typology_id AS institution_typology_id_31, t9.parent_application_id AS parent_application_id_32 FROM institutions_accreditation_type t0 LEFT JOIN accreditation_application t9 ON t9.institution_typology_id = t0.id WHERE t0.institution_id IN (?)

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.context AS context_1,
  t0.id AS id_2,
  t0.active AS active_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.institution_type_id AS institution_type_id_7,
  t0.institution_id AS institution_id_8,
  t9.status AS status_10,
  t9.request_type AS request_type_11,
  t9.code AS code_12,
  t9.accreditation_type AS accreditation_type_13,
  t9.score AS score_14,
  t9.send_at AS send_at_15,
  t9.determina_completed_at AS determina_completed_at_16,
  t9.accreditation_end_date AS accreditation_end_date_17,
  t9.renewal_notification_level AS renewal_notification_level_18,
  t9.viewed_by_instructor_l1 AS viewed_by_instructor_l1_19,
  t9.viewed_by_instructor_l2 AS viewed_by_instructor_l2_20,
  t9.viewed_by_instructor_l3 AS viewed_by_instructor_l3_21,
  t9.assignment_notification2_days_sent AS assignment_notification2_days_sent_22,
  t9.assignment_notification25_days_sent AS assignment_notification25_days_sent_23,
  t9.id AS id_24,
  t9.active AS active_25,
  t9.created_at AS created_at_26,
  t9.updated_at AS updated_at_27,
  t9.deleted_at AS deleted_at_28,
  t9.institution_id AS institution_id_29,
  t9.legal_owner_id AS legal_owner_id_30,
  t9.institution_typology_id AS institution_typology_id_31,
  t9.parent_application_id AS parent_application_id_32
FROM
  institutions_accreditation_type t0
  LEFT JOIN accreditation_application t9 ON t9.institution_typology_id = t0.id
WHERE
  t0.institution_id IN (?)

SELECT t0.context AS context_1, t0.id AS id_2, t0.active AS active_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.institution_type_id AS institution_type_id_7, t0.institution_id AS institution_id_8, t9.status AS status_10, t9.request_type AS request_type_11, t9.code AS code_12, t9.accreditation_type AS accreditation_type_13, t9.score AS score_14, t9.send_at AS send_at_15, t9.determina_completed_at AS determina_completed_at_16, t9.accreditation_end_date AS accreditation_end_date_17, t9.renewal_notification_level AS renewal_notification_level_18, t9.viewed_by_instructor_l1 AS viewed_by_instructor_l1_19, t9.viewed_by_instructor_l2 AS viewed_by_instructor_l2_20, t9.viewed_by_instructor_l3 AS viewed_by_instructor_l3_21, t9.assignment_notification2_days_sent AS assignment_notification2_days_sent_22, t9.assignment_notification25_days_sent AS assignment_notification25_days_sent_23, t9.id AS id_24, t9.active AS active_25, t9.created_at AS created_at_26, t9.updated_at AS updated_at_27, t9.deleted_at AS deleted_at_28, t9.institution_id AS institution_id_29, t9.legal_owner_id AS legal_owner_id_30, t9.institution_typology_id AS institution_typology_id_31, t9.parent_application_id AS parent_application_id_32 FROM institutions_accreditation_type t0 LEFT JOIN accreditation_application t9 ON t9.institution_typology_id = t0.id WHERE t0.institution_id IN (2);

#	File/Call
1	Doctrine\DBAL\Logging\Statement->execute (line 98)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
4	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2677)
5	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 2653)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 124)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 177)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadCollectionFromStatement (line 1026)
9	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1819)
10	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
11	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
12	Doctrine\ORM\PersistentCollection->initialize (line 186)
13	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
14	App\EventListener\InstitutionBlockedListener->getOperatingInstitution (line 237)
15	App\EventListener\InstitutionBlockedListener->__invoke (line 116)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 182)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 5)

1.66 ms
(6.64%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.fiscal_code AS fiscal_code_4, t0.birth_date AS birth_date_5, t0.gender AS gender_6, t0.residence_address AS residence_address_7, t0.residence_address_number AS residence_address_number_8, t0.residence_address_zip AS residence_address_zip_9, t0.foreign_city AS foreign_city_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t14.identifier AS identifier_15, t14.provider AS provider_16, t14.username AS username_17, t14.email AS email_18, t14.pec AS pec_19, t14.cellular AS cellular_20, t14.fiscal_code AS fiscal_code_21, t14.password AS password_22, t14.last_access AS last_access_23, t14.is_user_suspended AS is_user_suspended_24, t14.id AS id_25, t14.active AS active_26, t14.created_at AS created_at_27, t14.updated_at AS updated_at_28, t14.deleted_at AS deleted_at_29, t14.person_id AS person_id_30, t14.last_operating_institution_id AS last_operating_institution_id_31, t0.birth_nation_id AS birth_nation_id_32, t0.birth_city_id AS birth_city_id_33, t0.residence_city_id AS residence_city_id_34, t0.residence_province_id AS residence_province_id_35, t0.residence_nation_id AS residence_nation_id_36, t37.signature_certificate_expires_on AS signature_certificate_expires_on_38, t37.signature_kit_notification_level AS signature_kit_notification_level_39, t37.id AS id_40, t37.active AS active_41, t37.created_at AS created_at_42, t37.updated_at AS updated_at_43, t37.deleted_at AS deleted_at_44, t37.person_id AS person_id_45, t37.signature_certifier_id AS signature_certifier_id_46 FROM persons t0 LEFT JOIN user t14 ON t14.person_id = t0.id LEFT JOIN legal_owner t37 ON t37.person_id = t0.id WHERE t0.id = ?

Parameters:

[
  15
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.surname AS surname_3,
  t0.fiscal_code AS fiscal_code_4,
  t0.birth_date AS birth_date_5,
  t0.gender AS gender_6,
  t0.residence_address AS residence_address_7,
  t0.residence_address_number AS residence_address_number_8,
  t0.residence_address_zip AS residence_address_zip_9,
  t0.foreign_city AS foreign_city_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.deleted_at AS deleted_at_13,
  t14.identifier AS identifier_15,
  t14.provider AS provider_16,
  t14.username AS username_17,
  t14.email AS email_18,
  t14.pec AS pec_19,
  t14.cellular AS cellular_20,
  t14.fiscal_code AS fiscal_code_21,
  t14.password AS password_22,
  t14.last_access AS last_access_23,
  t14.is_user_suspended AS is_user_suspended_24,
  t14.id AS id_25,
  t14.active AS active_26,
  t14.created_at AS created_at_27,
  t14.updated_at AS updated_at_28,
  t14.deleted_at AS deleted_at_29,
  t14.person_id AS person_id_30,
  t14.last_operating_institution_id AS last_operating_institution_id_31,
  t0.birth_nation_id AS birth_nation_id_32,
  t0.birth_city_id AS birth_city_id_33,
  t0.residence_city_id AS residence_city_id_34,
  t0.residence_province_id AS residence_province_id_35,
  t0.residence_nation_id AS residence_nation_id_36,
  t37.signature_certificate_expires_on AS signature_certificate_expires_on_38,
  t37.signature_kit_notification_level AS signature_kit_notification_level_39,
  t37.id AS id_40,
  t37.active AS active_41,
  t37.created_at AS created_at_42,
  t37.updated_at AS updated_at_43,
  t37.deleted_at AS deleted_at_44,
  t37.person_id AS person_id_45,
  t37.signature_certifier_id AS signature_certifier_id_46
FROM
  persons t0
  LEFT JOIN user t14 ON t14.person_id = t0.id
  LEFT JOIN legal_owner t37 ON t37.person_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.fiscal_code AS fiscal_code_4, t0.birth_date AS birth_date_5, t0.gender AS gender_6, t0.residence_address AS residence_address_7, t0.residence_address_number AS residence_address_number_8, t0.residence_address_zip AS residence_address_zip_9, t0.foreign_city AS foreign_city_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t14.identifier AS identifier_15, t14.provider AS provider_16, t14.username AS username_17, t14.email AS email_18, t14.pec AS pec_19, t14.cellular AS cellular_20, t14.fiscal_code AS fiscal_code_21, t14.password AS password_22, t14.last_access AS last_access_23, t14.is_user_suspended AS is_user_suspended_24, t14.id AS id_25, t14.active AS active_26, t14.created_at AS created_at_27, t14.updated_at AS updated_at_28, t14.deleted_at AS deleted_at_29, t14.person_id AS person_id_30, t14.last_operating_institution_id AS last_operating_institution_id_31, t0.birth_nation_id AS birth_nation_id_32, t0.birth_city_id AS birth_city_id_33, t0.residence_city_id AS residence_city_id_34, t0.residence_province_id AS residence_province_id_35, t0.residence_nation_id AS residence_nation_id_36, t37.signature_certificate_expires_on AS signature_certificate_expires_on_38, t37.signature_kit_notification_level AS signature_kit_notification_level_39, t37.id AS id_40, t37.active AS active_41, t37.created_at AS created_at_42, t37.updated_at AS updated_at_43, t37.deleted_at AS deleted_at_44, t37.person_id AS person_id_45, t37.signature_certifier_id AS signature_certifier_id_46 FROM persons t0 LEFT JOIN user t14 ON t14.person_id = t0.id LEFT JOIN legal_owner t37 ON t37.person_id = t0.id WHERE t0.id = 15;

#	File/Call
1	Doctrine\DBAL\Logging\Statement->execute (line 98)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
5	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
6	Proxies\__CG__\App\Entity\Person::Doctrine\ORM\Proxy\{closure} (line 373)
7	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 59)
8	Proxies\__CG__\App\Entity\Person->__get (line 146)
9	App\Entity\Person->getLegalOwner (line 234)
10	App\EventListener\InstitutionBlockedListener->getOperatingInstitution (line 231)
11	App\EventListener\InstitutionBlockedListener->__invoke (line 116)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 182)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

1.65 ms
(6.61%)

SELECT t0.status AS status_1, t0.request_type AS request_type_2, t0.code AS code_3, t0.accreditation_type AS accreditation_type_4, t0.score AS score_5, t0.send_at AS send_at_6, t0.determina_completed_at AS determina_completed_at_7, t0.accreditation_end_date AS accreditation_end_date_8, t0.renewal_notification_level AS renewal_notification_level_9, t0.viewed_by_instructor_l1 AS viewed_by_instructor_l1_10, t0.viewed_by_instructor_l2 AS viewed_by_instructor_l2_11, t0.viewed_by_instructor_l3 AS viewed_by_instructor_l3_12, t0.assignment_notification2_days_sent AS assignment_notification2_days_sent_13, t0.assignment_notification25_days_sent AS assignment_notification25_days_sent_14, t0.id AS id_15, t0.active AS active_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t20.id AS id_21, t20.active AS active_22, t20.created_at AS created_at_23, t20.updated_at AS updated_at_24, t20.deleted_at AS deleted_at_25, t20.accreditation_application_id AS accreditation_application_id_26, t20.tipology_id AS tipology_id_27, t0.institution_id AS institution_id_28, t0.legal_owner_id AS legal_owner_id_29, t0.institution_typology_id AS institution_typology_id_30, t0.parent_application_id AS parent_application_id_31 FROM accreditation_application t0 LEFT JOIN institutions_accreditation_tipologies t20 ON t20.accreditation_application_id = t0.id WHERE t0.institution_id = ? AND t0.accreditation_type = ? AND t0.status = ?

Parameters:

[
  2
  "Formazione"
  "DETERMINA_COMPLETATA"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.status AS status_1,
  t0.request_type AS request_type_2,
  t0.code AS code_3,
  t0.accreditation_type AS accreditation_type_4,
  t0.score AS score_5,
  t0.send_at AS send_at_6,
  t0.determina_completed_at AS determina_completed_at_7,
  t0.accreditation_end_date AS accreditation_end_date_8,
  t0.renewal_notification_level AS renewal_notification_level_9,
  t0.viewed_by_instructor_l1 AS viewed_by_instructor_l1_10,
  t0.viewed_by_instructor_l2 AS viewed_by_instructor_l2_11,
  t0.viewed_by_instructor_l3 AS viewed_by_instructor_l3_12,
  t0.assignment_notification2_days_sent AS assignment_notification2_days_sent_13,
  t0.assignment_notification25_days_sent AS assignment_notification25_days_sent_14,
  t0.id AS id_15,
  t0.active AS active_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.deleted_at AS deleted_at_19,
  t20.id AS id_21,
  t20.active AS active_22,
  t20.created_at AS created_at_23,
  t20.updated_at AS updated_at_24,
  t20.deleted_at AS deleted_at_25,
  t20.accreditation_application_id AS accreditation_application_id_26,
  t20.tipology_id AS tipology_id_27,
  t0.institution_id AS institution_id_28,
  t0.legal_owner_id AS legal_owner_id_29,
  t0.institution_typology_id AS institution_typology_id_30,
  t0.parent_application_id AS parent_application_id_31
FROM
  accreditation_application t0
  LEFT JOIN institutions_accreditation_tipologies t20 ON t20.accreditation_application_id = t0.id
WHERE
  t0.institution_id = ?
  AND t0.accreditation_type = ?
  AND t0.status = ?

SELECT t0.status AS status_1, t0.request_type AS request_type_2, t0.code AS code_3, t0.accreditation_type AS accreditation_type_4, t0.score AS score_5, t0.send_at AS send_at_6, t0.determina_completed_at AS determina_completed_at_7, t0.accreditation_end_date AS accreditation_end_date_8, t0.renewal_notification_level AS renewal_notification_level_9, t0.viewed_by_instructor_l1 AS viewed_by_instructor_l1_10, t0.viewed_by_instructor_l2 AS viewed_by_instructor_l2_11, t0.viewed_by_instructor_l3 AS viewed_by_instructor_l3_12, t0.assignment_notification2_days_sent AS assignment_notification2_days_sent_13, t0.assignment_notification25_days_sent AS assignment_notification25_days_sent_14, t0.id AS id_15, t0.active AS active_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t20.id AS id_21, t20.active AS active_22, t20.created_at AS created_at_23, t20.updated_at AS updated_at_24, t20.deleted_at AS deleted_at_25, t20.accreditation_application_id AS accreditation_application_id_26, t20.tipology_id AS tipology_id_27, t0.institution_id AS institution_id_28, t0.legal_owner_id AS legal_owner_id_29, t0.institution_typology_id AS institution_typology_id_30, t0.parent_application_id AS parent_application_id_31 FROM accreditation_application t0 LEFT JOIN institutions_accreditation_tipologies t20 ON t20.accreditation_application_id = t0.id WHERE t0.institution_id = 2 AND t0.accreditation_type = 'Formazione' AND t0.status = 'DETERMINA_COMPLETATA';

#	File/Call
1	Doctrine\DBAL\Logging\Statement->execute (line 98)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
4	Doctrine\ORM\EntityRepository->findBy (line 110)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
6	App\Service\Balance\BalanceReclassificationService->getReferenceApplication (line 567)
7	App\Service\Balance\BalanceReclassificationService->getDeterminaYear (line 159)
8	App\Service\Balance\BalanceReclassificationService->getAnnoDisponibilita (line 145)
9	App\Service\Balance\BalanceReclassificationService->isFunzionalitaDisponibile (line 173)
10	App\Twig\Extension\IsInstitutionAccreditatedExtension->isBalanceReclassificationAvailable (line 52)
11	App\Twig\Extension\IsInstitutionAccreditatedExtension->getGlobals (line 35)
12	Twig\ExtensionSet->getGlobals (line 361)
13	Twig\Environment->getGlobals (line 908)
14	Twig\Template->yield (line 398)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
22	App\Controller\VariationController->list (line 188)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

1.53 ms
(6.13%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.label AS label_4 FROM role t0 INNER JOIN user_role ON t0.id = user_role.role_id WHERE user_role.user_id = ?

Parameters:

[
  15
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.label AS label_4
FROM
  role t0
  INNER JOIN user_role ON t0.id = user_role.role_id
WHERE
  user_role.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.label AS label_4 FROM role t0 INNER JOIN user_role ON t0.id = user_role.role_id WHERE user_role.user_id = 15;

#	File/Call
1	Doctrine\DBAL\Logging\Statement->execute (line 98)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
5	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
6	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
7	Doctrine\ORM\PersistentCollection->initialize (line 186)
8	Doctrine\Common\Collections\AbstractLazyCollection->map (line 257)
9	App\Entity\User->getRoles (line 183)
10	Symfony\Component\Security\Http\Firewall\ContextListener->hasUserChanged (line 308)
11	Symfony\Component\Security\Http\Firewall\ContextListener::refreshUser (line 217)
12	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
13	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
14	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->Symfony\Bundle\SecurityBundle\Security\{closure} (line 74)
15	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 34)
16	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 42)
17	Symfony\Bundle\SecurityBundle\Security->getToken (line 68)
18	Symfony\Bundle\SecurityBundle\Security->getUser (line 50)
19	App\EventListener\RoleBaseRedirectListener->onKernelRequest (line 30)
20	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
21	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
22	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
23	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 182)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

1.45 ms
(5.79%)

SELECT t0.name AS name_1, t0.tax_code AS tax_code_2, t0.fiscal_code AS fiscal_code_3, t0.pec_address AS pec_address_4, t0.email_address AS email_address_5, t0.telephone AS telephone_6, t0.telephone_mobile AS telephone_mobile_7, t0.operating AS operating_8, t0.status AS status_9, t0.id AS id_10, t0.active AS active_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted_at AS deleted_at_14, t0.legal_form_id AS legal_form_id_15, t0.institution_size_id AS institution_size_id_16, t0.ateco_code_version_id AS ateco_code_version_id_17, t0.legal_owner_id AS legal_owner_id_18 FROM institutions t0 WHERE t0.operating = ? AND t0.legal_owner_id = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.tax_code AS tax_code_2,
  t0.fiscal_code AS fiscal_code_3,
  t0.pec_address AS pec_address_4,
  t0.email_address AS email_address_5,
  t0.telephone AS telephone_6,
  t0.telephone_mobile AS telephone_mobile_7,
  t0.operating AS operating_8,
  t0.status AS status_9,
  t0.id AS id_10,
  t0.active AS active_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.deleted_at AS deleted_at_14,
  t0.legal_form_id AS legal_form_id_15,
  t0.institution_size_id AS institution_size_id_16,
  t0.ateco_code_version_id AS ateco_code_version_id_17,
  t0.legal_owner_id AS legal_owner_id_18
FROM
  institutions t0
WHERE
  t0.operating = ?
  AND t0.legal_owner_id = ?
LIMIT
  1

SELECT t0.name AS name_1, t0.tax_code AS tax_code_2, t0.fiscal_code AS fiscal_code_3, t0.pec_address AS pec_address_4, t0.email_address AS email_address_5, t0.telephone AS telephone_6, t0.telephone_mobile AS telephone_mobile_7, t0.operating AS operating_8, t0.status AS status_9, t0.id AS id_10, t0.active AS active_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted_at AS deleted_at_14, t0.legal_form_id AS legal_form_id_15, t0.institution_size_id AS institution_size_id_16, t0.ateco_code_version_id AS ateco_code_version_id_17, t0.legal_owner_id AS legal_owner_id_18 FROM institutions t0 WHERE t0.operating = 1 AND t0.legal_owner_id = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Logging\Statement->execute (line 98)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
4	Doctrine\ORM\EntityRepository->findOneBy (line 125)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
6	App\Twig\Extension\EnteOperatingExtension->getEnteOperating (line 75)
7	App\Twig\Extension\EnteOperatingExtension->getGlobals (line 39)
8	Twig\ExtensionSet->getGlobals (line 361)
9	Twig\Environment->getGlobals (line 908)
10	Twig\Template->yield (line 398)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
18	App\Controller\VariationController->list (line 188)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 182)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	require_once (line 5)

1.42 ms
(5.67%)

SELECT DISTINCT v0_.id AS id_0, v0_.created_at AS created_at_1 FROM variation_request v0_ INNER JOIN institutions i1_ ON v0_.institution_id = i1_.id WHERE i1_.legal_owner_id = ? AND i1_.operating = ? ORDER BY v0_.created_at DESC LIMIT 10

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT v0_.id AS id_0,
  v0_.created_at AS created_at_1
FROM
  variation_request v0_
  INNER JOIN institutions i1_ ON v0_.institution_id = i1_.id
WHERE
  i1_.legal_owner_id = ?
  AND i1_.operating = ?
ORDER BY
  v0_.created_at DESC
LIMIT
  10

SELECT DISTINCT v0_.id AS id_0, v0_.created_at AS created_at_1 FROM variation_request v0_ INNER JOIN institutions i1_ ON v0_.institution_id = i1_.id WHERE i1_.legal_owner_id = 1 AND i1_.operating = 1 ORDER BY v0_.created_at DESC LIMIT 10;

#	File/Call
1	Doctrine\DBAL\Logging\Statement->execute (line 98)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
4	Doctrine\ORM\Query->_doExecute (line 296)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
6	Doctrine\ORM\AbstractQuery->execute (line 886)
7	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
8	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
9	iterator_to_array (line 45)
10	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 45)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
15	Knp\Component\Pager\Paginator->paginate (line 97)
16	ContainerXWEx2uj\PaginatorProxyBa079e5->paginate (line 25)
17	App\Controller\VariationController->list (line 176)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 182)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 29)
23	require_once (line 5)

1.20 ms
(4.82%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.label AS label_4 FROM role t0 WHERE t0.name = ? LIMIT 1

Parameters:

[
  "ROLE_LEGALE_RAPPRESENTANTE"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.label AS label_4
FROM
  role t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.label AS label_4 FROM role t0 WHERE t0.name = 'ROLE_LEGALE_RAPPRESENTANTE' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Logging\Statement->execute (line 98)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
4	Doctrine\ORM\EntityRepository->findOneBy (line 125)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
6	App\Service\RoleManager->getRoleEntityByName (line 43)
7	App\Twig\Extension\RoleExtension->getRoleLabel (line 27)
8	__TwigTemplate_099fa7a54caee493e9767a7908b20511->doDisplay (line 89)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_ef2cb7e231c49e8daf5501931fbdca9c->doDisplay (line 87)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_aeedebceb43d07b571c7a71920c87d72->doDisplay (line 56)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
21	App\Controller\VariationController->list (line 188)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 182)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\AccreditationApplication	3
App\Entity\InstitutionAccreditationType	3
App\Entity\InstitutionAccreditationTipology	3
App\Entity\InstitutionType	3
App\Entity\City	2
App\Entity\User	1
App\Entity\Person	1
App\Entity\Institution	1
App\Entity\Role	1
App\Entity\Nation	1
App\Entity\LegalOwner	1
App\Entity\SignatureCertifier	1
App\Entity\LegalForms	1
App\Entity\InstitutionSize	1
App\Entity\AtecoCodeVersion	1
App\Entity\AccreditationTipologies	1

Entities Mapping

Class	Mapping errors
App\Entity\User	The field App\Entity\User#notificheRicevute is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Notification#utente does not contain the required 'inversedBy: "notificheRicevute"' attribute. The field App\Entity\User#notificheCreate is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Notification#creatore does not contain the required 'inversedBy: "notificheCreate"' attribute.
App\Entity\Person	The mappings App\Entity\Person#personDocuments and App\Entity\PersonDocument#person are inconsistent with each other.
App\Entity\Institution	The field App\Entity\Institution#accreditationApplications is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\AccreditationApplication#institution does not contain the required 'inversedBy: "accreditationApplications"' attribute. The field App\Entity\Institution#institutionAccreditationTypes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\InstitutionAccreditationType#institution does not contain the required 'inversedBy: "institutionAccreditationTypes"' attribute.
App\Entity\Role	No errors.
App\Entity\Notification	No errors.
App\Entity\SuspensionRevocation	No errors.
App\Entity\TemporaryOfficeValidityHistory	No errors.
App\Entity\Nation	No errors.
App\Entity\City	No errors.
App\Entity\LegalOwner	No errors.
App\Entity\SignatureCertifier	No errors.
App\Entity\IdentityDocument	No errors.
App\Entity\PersonDocument	No errors.
App\Entity\AccreditationApplication	The field App\Entity\AccreditationApplication#institutionAccreditationTipology is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\InstitutionAccreditationTipology#accreditationApplication does not contain the required 'inversedBy: "institutionAccreditationTipology"' attribute. The mappings App\Entity\AccreditationApplication#jobServicesSpecialists and App\Entity\JobServiceSpecialist#accreditationApplication are inconsistent with each other.
App\Entity\LegalForms	No errors.
App\Entity\InstitutionSize	No errors.
App\Entity\AtecoCodeVersion	No errors.
App\Entity\InstitutionAccreditationType	No errors.
App\Entity\VariationRequest	No errors.
App\Entity\InstitutionOffice	No errors.
App\Entity\InstitutionAccreditationTipology	No errors.
App\Entity\AccreditationTipologies	No errors.
App\Entity\InstitutionAccreditationMacrotype	No errors.
App\Entity\InstitutionSep	No errors.
App\Entity\InstitutionAccreditationTabs	No errors.
App\Entity\Document	No errors.
App\Entity\AccreditationInvestigationL1	No errors.
App\Entity\AccreditationInvestigationL2	No errors.
App\Entity\AccreditationInvestigationL3	No errors.
App\Entity\InstitutionSpecialUser	No errors.
App\Entity\JobService	No errors.
App\Entity\JobServiceSpecialist	No errors.
App\Entity\SignedApplicationDocument	No errors.
App\Entity\AccreditationOffice	No errors.
App\Entity\InstitutionType	No errors.
App\Entity\MaintenanceRequest	No errors.

Symfony Profiler

GET https://sac-dev.schema31.it/variation/list

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping