Symfony Profiler

Query Metrics

34 Database Queries

9 Different statements

12.09 ms Query time

0 Invalid entities

74 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

7.25 ms
(59.96%)

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.value AS value_3,
  t0.description AS description_4,
  t0.priority AS priority_5,
  t0.category_id AS category_id_6
FROM
  dm_permission t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	App\Entity\Permission::getSlug (line 50)
5	App\Entity\User->getPermissionType (line 65)
6	App\Security\PermissionVoter->voteOnAttribute (line 34)
7	Symfony\Component\Security\Core\Authorization\Voter\Voter->vote (line 56)
8	Symfony\Component\Security\Core\Authorization\Voter\TraceableVoter->vote (line 35)
9	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->collectResults (line 89)
10	Symfony\Component\Security\Core\Authorization\Strategy\AffirmativeStrategy->decide (line 36)
11	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->decide (line 73)
12	Symfony\Component\Security\Core\Authorization\TraceableAccessDecisionManager->decide (line 57)
13	Symfony\Component\Security\Core\Authorization\AuthorizationChecker->isGranted (line 54)
14	Symfony\Component\Security\Core\Authorization\ExpressionLanguageProvider->{closure:Symfony\Component\Security\Core\Authorization\ExpressionLanguageProvider::getFunctions():31} (line 31)
15	Symfony\Component\ExpressionLanguage\Node\FunctionNode::evaluate (line 50)
16	Symfony\Component\ExpressionLanguage\ExpressionLanguage->evaluate (line 59)
17	Symfony\Component\Security\Core\Authorization\Voter\ExpressionVoter->vote (line 65)
18	Symfony\Component\Security\Core\Authorization\Voter\TraceableVoter->vote (line 35)
19	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->collectResults (line 89)
20	Symfony\Component\Security\Core\Authorization\Strategy\AffirmativeStrategy->decide (line 36)
21	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->decide (line 73)
22	Symfony\Component\Security\Core\Authorization\TraceableAccessDecisionManager->decide (line 57)
23	Symfony\Component\Security\Core\Authorization\AuthorizationChecker->isGranted (line 54)
24	Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener->onKernelControllerArguments (line 74)
25	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
26	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
27	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
28	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 193)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
33	require_once (line 32)
34	require_once (line 5)

0.92 ms
(7.59%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.surname AS surname_4, t0.password AS password_5, t0.role AS role_6, t0.one_time_code AS one_time_code_7, t0.expiration_one_time_code AS expiration_one_time_code_8, t0.is_active AS is_active_9, t0.is_account_activation AS is_account_activation_10, t0.is_email_notification_active AS is_email_notification_active_11, t0.theme AS theme_12, t0.directory_path AS directory_path_13, t14.id AS id_15, t14.avatar AS avatar_16, t14.user_id AS user_id_17, t18.id AS id_19, t18.is_terms_accepted AS is_terms_accepted_20, t18.datetime_last_update AS datetime_last_update_21, t18.user_id AS user_id_22 FROM dm_user t0 LEFT JOIN dm_user_profile t14 ON t14.user_id = t0.id LEFT JOIN dm_user_privacy t18 ON t18.user_id = t0.id WHERE t0.id = ?

Parameters:

[
  "3"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.name AS name_3,
  t0.surname AS surname_4,
  t0.password AS password_5,
  t0.role AS role_6,
  t0.one_time_code AS one_time_code_7,
  t0.expiration_one_time_code AS expiration_one_time_code_8,
  t0.is_active AS is_active_9,
  t0.is_account_activation AS is_account_activation_10,
  t0.is_email_notification_active AS is_email_notification_active_11,
  t0.theme AS theme_12,
  t0.directory_path AS directory_path_13,
  t14.id AS id_15,
  t14.avatar AS avatar_16,
  t14.user_id AS user_id_17,
  t18.id AS id_19,
  t18.is_terms_accepted AS is_terms_accepted_20,
  t18.datetime_last_update AS datetime_last_update_21,
  t18.user_id AS user_id_22
FROM
  dm_user t0
  LEFT JOIN dm_user_profile t14 ON t14.user_id = t0.id
  LEFT JOIN dm_user_privacy t18 ON t18.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.surname AS surname_4, t0.password AS password_5, t0.role AS role_6, t0.one_time_code AS one_time_code_7, t0.expiration_one_time_code AS expiration_one_time_code_8, t0.is_active AS is_active_9, t0.is_account_activation AS is_account_activation_10, t0.is_email_notification_active AS is_email_notification_active_11, t0.theme AS theme_12, t0.directory_path AS directory_path_13, t14.id AS id_15, t14.avatar AS avatar_16, t14.user_id AS user_id_17, t18.id AS id_19, t18.is_terms_accepted AS is_terms_accepted_20, t18.datetime_last_update AS datetime_last_update_21, t18.user_id AS user_id_22 FROM dm_user t0 LEFT JOIN dm_user_profile t14 ON t14.user_id = t0.id LEFT JOIN dm_user_privacy t18 ON t18.user_id = t0.id WHERE t0.id = '3';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->find (line 66)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 227)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 132)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 193)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
21	require_once (line 32)
22	require_once (line 5)

0.82 ms
(6.82%)

SELECT t0.name AS name_1, t0.id AS id_2, t0.is_active AS is_active_3 FROM dm_item t0 INNER JOIN dm_to_do_list_item ON t0.id = dm_to_do_list_item.item_id WHERE dm_to_do_list_item.to_do_list_id = ? ORDER BY t0.name ASC

Parameters:

[
  "2"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.id AS id_2,
  t0.is_active AS is_active_3
FROM
  dm_item t0
  INNER JOIN dm_to_do_list_item ON t0.id = dm_to_do_list_item.item_id
WHERE
  dm_to_do_list_item.to_do_list_id = ?
ORDER BY
  t0.name ASC

SELECT t0.name AS name_1, t0.id AS id_2, t0.is_active AS is_active_3 FROM dm_item t0 INNER JOIN dm_to_do_list_item ON t0.id = dm_to_do_list_item.item_id WHERE dm_to_do_list_item.to_do_list_id = '2' ORDER BY t0.name ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2737)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1278)
9	__TwigTemplate_24771968ee5d6e46cd6f819f5b441c44::block_content (line 289)
10	Twig\Template->yieldBlock (line 456)
11	__TwigTemplate_f22f65c28a7dae52357281720ad05ba8->block_body (line 482)
12	Twig\Template->yieldBlock (line 456)
13	__TwigTemplate_f22f65c28a7dae52357281720ad05ba8->doDisplay (line 206)
14	Twig\Template->yield (line 411)
15	__TwigTemplate_3b724a3f79651e51a0691f1edeead77f->doDisplay (line 56)
16	Twig\Template->yield (line 411)
17	__TwigTemplate_24771968ee5d6e46cd6f819f5b441c44->doDisplay (line 57)
18	Twig\Template->yield (line 411)
19	Twig\Template->display (line 366)
20	Twig\Template->render (line 381)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
26	App\Controller\User\UserToDoListController->list (line 74)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 193)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
31	require_once (line 32)
32	require_once (line 5)

0.78 ms
(6.41%)

SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.to_do_list_id AS to_do_list_id_3 FROM dm_join_table_user_to_do_list t0 WHERE t0.to_do_list_id = ?

Parameters:

[
  "2"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.user_id AS user_id_2,
  t0.to_do_list_id AS to_do_list_id_3
FROM
  dm_join_table_user_to_do_list t0
WHERE
  t0.to_do_list_id = ?

SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.to_do_list_id AS to_do_list_id_3 FROM dm_join_table_user_to_do_list t0 WHERE t0.to_do_list_id = '2';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	__TwigTemplate_24771968ee5d6e46cd6f819f5b441c44->block_content (line 260)
8	Twig\Template->yieldBlock (line 456)
9	__TwigTemplate_f22f65c28a7dae52357281720ad05ba8->block_body (line 482)
10	Twig\Template->yieldBlock (line 456)
11	__TwigTemplate_f22f65c28a7dae52357281720ad05ba8->doDisplay (line 206)
12	Twig\Template->yield (line 411)
13	__TwigTemplate_3b724a3f79651e51a0691f1edeead77f->doDisplay (line 56)
14	Twig\Template->yield (line 411)
15	__TwigTemplate_24771968ee5d6e46cd6f819f5b441c44->doDisplay (line 57)
16	Twig\Template->yield (line 411)
17	Twig\Template->display (line 366)
18	Twig\Template->render (line 381)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
24	App\Controller\User\UserToDoListController->list (line 74)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 193)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
29	require_once (line 32)
30	require_once (line 5)

0.70 ms
(5.77%)

SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3, t0.permission_id AS permission_id_4 FROM dm_join_table_user_permission t0 WHERE t0.user_id = ?

Parameters:

[
  "3"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.user_id AS user_id_3,
  t0.permission_id AS permission_id_4
FROM
  dm_join_table_user_permission t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3, t0.permission_id AS permission_id_4 FROM dm_join_table_user_permission t0 WHERE t0.user_id = '3';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Entity\User->getPermissionType (line 64)
8	App\Security\PermissionVoter->voteOnAttribute (line 34)
9	Symfony\Component\Security\Core\Authorization\Voter\Voter->vote (line 56)
10	Symfony\Component\Security\Core\Authorization\Voter\TraceableVoter->vote (line 35)
11	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->collectResults (line 89)
12	Symfony\Component\Security\Core\Authorization\Strategy\AffirmativeStrategy->decide (line 36)
13	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->decide (line 73)
14	Symfony\Component\Security\Core\Authorization\TraceableAccessDecisionManager->decide (line 57)
15	Symfony\Component\Security\Core\Authorization\AuthorizationChecker->isGranted (line 54)
16	Symfony\Component\Security\Core\Authorization\ExpressionLanguageProvider->{closure:Symfony\Component\Security\Core\Authorization\ExpressionLanguageProvider::getFunctions():31} (line 31)
17	Symfony\Component\ExpressionLanguage\Node\FunctionNode::evaluate (line 50)
18	Symfony\Component\ExpressionLanguage\ExpressionLanguage->evaluate (line 59)
19	Symfony\Component\Security\Core\Authorization\Voter\ExpressionVoter->vote (line 65)
20	Symfony\Component\Security\Core\Authorization\Voter\TraceableVoter->vote (line 35)
21	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->collectResults (line 89)
22	Symfony\Component\Security\Core\Authorization\Strategy\AffirmativeStrategy->decide (line 36)
23	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->decide (line 73)
24	Symfony\Component\Security\Core\Authorization\TraceableAccessDecisionManager->decide (line 57)
25	Symfony\Component\Security\Core\Authorization\AuthorizationChecker->isGranted (line 54)
26	Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener->onKernelControllerArguments (line 74)
27	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
28	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
29	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
30	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
33	Symfony\Component\HttpKernel\Kernel->handle (line 193)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
35	require_once (line 32)
36	require_once (line 5)

0.52 ms
(4.28%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.surname AS surname_4, t0.password AS password_5, t0.role AS role_6, t0.one_time_code AS one_time_code_7, t0.expiration_one_time_code AS expiration_one_time_code_8, t0.is_active AS is_active_9, t0.is_account_activation AS is_account_activation_10, t0.is_email_notification_active AS is_email_notification_active_11, t0.theme AS theme_12, t0.directory_path AS directory_path_13, t14.id AS id_15, t14.avatar AS avatar_16, t14.user_id AS user_id_17, t18.id AS id_19, t18.is_terms_accepted AS is_terms_accepted_20, t18.datetime_last_update AS datetime_last_update_21, t18.user_id AS user_id_22 FROM dm_user t0 LEFT JOIN dm_user_profile t14 ON t14.user_id = t0.id LEFT JOIN dm_user_privacy t18 ON t18.user_id = t0.id WHERE t0.role = ? ORDER BY t0.surname ASC

Parameters:

[
  "ROLE_USER"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.name AS name_3,
  t0.surname AS surname_4,
  t0.password AS password_5,
  t0.role AS role_6,
  t0.one_time_code AS one_time_code_7,
  t0.expiration_one_time_code AS expiration_one_time_code_8,
  t0.is_active AS is_active_9,
  t0.is_account_activation AS is_account_activation_10,
  t0.is_email_notification_active AS is_email_notification_active_11,
  t0.theme AS theme_12,
  t0.directory_path AS directory_path_13,
  t14.id AS id_15,
  t14.avatar AS avatar_16,
  t14.user_id AS user_id_17,
  t18.id AS id_19,
  t18.is_terms_accepted AS is_terms_accepted_20,
  t18.datetime_last_update AS datetime_last_update_21,
  t18.user_id AS user_id_22
FROM
  dm_user t0
  LEFT JOIN dm_user_profile t14 ON t14.user_id = t0.id
  LEFT JOIN dm_user_privacy t18 ON t18.user_id = t0.id
WHERE
  t0.role = ?
ORDER BY
  t0.surname ASC

SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.surname AS surname_4, t0.password AS password_5, t0.role AS role_6, t0.one_time_code AS one_time_code_7, t0.expiration_one_time_code AS expiration_one_time_code_8, t0.is_active AS is_active_9, t0.is_account_activation AS is_account_activation_10, t0.is_email_notification_active AS is_email_notification_active_11, t0.theme AS theme_12, t0.directory_path AS directory_path_13, t14.id AS id_15, t14.avatar AS avatar_16, t14.user_id AS user_id_17, t18.id AS id_19, t18.is_terms_accepted AS is_terms_accepted_20, t18.datetime_last_update AS datetime_last_update_21, t18.user_id AS user_id_22 FROM dm_user t0 LEFT JOIN dm_user_profile t14 ON t14.user_id = t0.id LEFT JOIN dm_user_privacy t18 ON t18.user_id = t0.id WHERE t0.role = 'ROLE_USER' ORDER BY t0.surname ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	App\Controller\User\UserToDoListController->list (line 80)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
9	require_once (line 32)
10	require_once (line 5)

0.39 ms
(3.25%)

SELECT d0_.name AS name_0, d0_.cadence AS cadence_1, d0_.start_date AS start_date_2, d0_.end_date AS end_date_3, d0_.last_date_execution AS last_date_execution_4, d0_.id AS id_5, d0_.is_active AS is_active_6 FROM dm_to_do_list d0_ WHERE d0_.id IN (?, ?) ORDER BY d0_.name ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.name AS name_0,
  d0_.cadence AS cadence_1,
  d0_.start_date AS start_date_2,
  d0_.end_date AS end_date_3,
  d0_.last_date_execution AS last_date_execution_4,
  d0_.id AS id_5,
  d0_.is_active AS is_active_6
FROM
  dm_to_do_list d0_
WHERE
  d0_.id IN (?, ?)
ORDER BY
  d0_.name ASC

SELECT d0_.name AS name_0, d0_.cadence AS cadence_1, d0_.start_date AS start_date_2, d0_.end_date AS end_date_3, d0_.last_date_execution AS last_date_execution_4, d0_.id AS id_5, d0_.is_active AS is_active_6 FROM dm_to_do_list d0_ WHERE d0_.id IN (2, 1) ORDER BY d0_.name ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
7	iterator_to_array (line 45)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 45)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerSxTxSuh\PaginatorProxyBa079e5->paginate (line 20)
15	App\Controller\User\UserToDoListController->list (line 72)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 193)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
20	require_once (line 32)
21	require_once (line 5)

0.37 ms
(3.04%)

SELECT DISTINCT d0_.id AS id_0, d0_.name AS name_1 FROM dm_to_do_list d0_ ORDER BY d0_.name ASC LIMIT 25

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT d0_.id AS id_0,
  d0_.name AS name_1
FROM
  dm_to_do_list d0_
ORDER BY
  d0_.name ASC
LIMIT
  25

SELECT DISTINCT d0_.id AS id_0, d0_.name AS name_1 FROM dm_to_do_list d0_ ORDER BY d0_.name ASC LIMIT 25;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	iterator_to_array (line 45)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 45)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerSxTxSuh\PaginatorProxyBa079e5->paginate (line 20)
15	App\Controller\User\UserToDoListController->list (line 72)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 193)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
20	require_once (line 32)
21	require_once (line 5)

0.35 ms
(2.88%)

SELECT count(DISTINCT d0_.id) AS sclr_0 FROM dm_to_do_list d0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT d0_.id) AS sclr_0
FROM
  dm_to_do_list d0_

SELECT count(DISTINCT d0_.id) AS sclr_0 FROM dm_to_do_list d0_;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	count (line 43)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 43)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerSxTxSuh\PaginatorProxyBa079e5->paginate (line 20)
15	App\Controller\User\UserToDoListController->list (line 72)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 193)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
20	require_once (line 32)
21	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\JoinTableUserPermission	24
App\Entity\Permission	24
App\Entity\PermissionCategory	9
App\Entity\User	6
App\Entity\Item	4
App\Entity\JoinTableUserToDoList	3
App\Entity\UserProfile	2
App\Entity\ToDoList	2

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\UserProfile	No errors.
App\Entity\UserPrivacy	No errors.
App\Entity\JoinTableUserPermission	No errors.
App\Entity\Permission	No errors.
App\Entity\PermissionCategory	No errors.
App\Entity\ToDoList	No errors.
App\Entity\Item	No errors.
App\Entity\JoinTableUserToDoList	No errors.
App\Entity\ToDoListItemCheck	No errors.

Symfony Profiler

GET https://software.dualmoto.it/utente/mansionario/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping