Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

1.39 ms Query time

2 Invalid entities

8 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.41 ms

SELECT t0.id_user AS id_user_1, t0.login_user AS login_user_2, t0.password_user AS password_user_3, t0.email_user AS email_user_4, t0.firstname_user AS firstname_user_5, t0.lastname_user AS lastname_user_6, t0.color_user AS color_user_7, t0.active AS active_8, t0.reset_token AS reset_token_9, t0.reset_token_expires_at AS reset_token_expires_at_10, t0.id_usergroup AS id_usergroup_11 FROM user t0 WHERE t0.id_user = ?

Parameters:

[
  109
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id_user AS id_user_1,
  t0.login_user AS login_user_2,
  t0.password_user AS password_user_3,
  t0.email_user AS email_user_4,
  t0.firstname_user AS firstname_user_5,
  t0.lastname_user AS lastname_user_6,
  t0.color_user AS color_user_7,
  t0.active AS active_8,
  t0.reset_token AS reset_token_9,
  t0.reset_token_expires_at AS reset_token_expires_at_10,
  t0.id_usergroup AS id_usergroup_11
FROM
  user t0
WHERE
  t0.id_user = ?

SELECT t0.id_user AS id_user_1, t0.login_user AS login_user_2, t0.password_user AS password_user_3, t0.email_user AS email_user_4, t0.firstname_user AS firstname_user_5, t0.lastname_user AS lastname_user_6, t0.color_user AS color_user_7, t0.active AS active_8, t0.reset_token AS reset_token_9, t0.reset_token_expires_at AS reset_token_expires_at_10, t0.id_usergroup AS id_usergroup_11 FROM user t0 WHERE t0.id_user = 109;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 366)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 92)
7	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 129)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 74)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->Symfony\Bundle\SecurityBundle\Security\{closure} (line 34)
12	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 42)
13	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 41)
14	Symfony\Component\Security\Core\Authorization\AuthorizationChecker->isGranted (line 64)
15	Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener->onKernelControllerArguments (line 115)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 178)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.26 ms

SELECT t0.id_usergroup AS id_usergroup_1, t0.name_usergroup AS name_usergroup_2, t0.code_usergroup AS code_usergroup_3 FROM usergroup t0 WHERE t0.id_usergroup = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id_usergroup AS id_usergroup_1,
  t0.name_usergroup AS name_usergroup_2,
  t0.code_usergroup AS code_usergroup_3
FROM
  usergroup t0
WHERE
  t0.id_usergroup = ?

SELECT t0.id_usergroup AS id_usergroup_1, t0.name_usergroup AS name_usergroup_2, t0.code_usergroup AS code_usergroup_3 FROM usergroup t0 WHERE t0.id_usergroup = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 289)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 367)
5	Proxies\__CG__\App\Entity\UserGroup::Doctrine\ORM\Proxy\{closure} (line 60)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 153)
7	Proxies\__CG__\App\Entity\UserGroup->__get (line 51)
8	App\Entity\UserGroup->getCode (line 417)
9	App\Entity\User->getRoles (line 318)
10	Symfony\Component\Security\Http\Firewall\ContextListener::hasUserChanged (line 217)
11	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 129)
12	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
13	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 74)
14	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->Symfony\Bundle\SecurityBundle\Security\{closure} (line 34)
15	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 42)
16	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 41)
17	Symfony\Component\Security\Core\Authorization\AuthorizationChecker->isGranted (line 64)
18	Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener->onKernelControllerArguments (line 115)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 178)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.35 ms

SELECT t0.id_tache AS id_tache_1, t0.name_tache AS name_tache_2, t0.description_tache AS description_tache_3, t0.duration_tache AS duration_tache_4, t0.duration_estimated_tache AS duration_estimated_tache_5, t0.priority_tache AS priority_tache_6, t0.status_tache AS status_tache_7, t0.order_tache AS order_tache_8, t0.active AS active_9, t0.archived AS archived_10, t0.archived_at AS archived_at_11, t0.date_insert AS date_insert_12, t0.due_date AS due_date_13, t0.reminder_datetime AS reminder_datetime_14, t0.id_lot AS id_lot_15, t0.id_tache_type AS id_tache_type_16, t0.id_tache_statut AS id_tache_statut_17, t0.id_tache_priorite AS id_tache_priorite_18, t0.created_by AS created_by_19 FROM tache t0 WHERE t0.id_tache = ?

Parameters:

[
  383
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id_tache AS id_tache_1,
  t0.name_tache AS name_tache_2,
  t0.description_tache AS description_tache_3,
  t0.duration_tache AS duration_tache_4,
  t0.duration_estimated_tache AS duration_estimated_tache_5,
  t0.priority_tache AS priority_tache_6,
  t0.status_tache AS status_tache_7,
  t0.order_tache AS order_tache_8,
  t0.active AS active_9,
  t0.archived AS archived_10,
  t0.archived_at AS archived_at_11,
  t0.date_insert AS date_insert_12,
  t0.due_date AS due_date_13,
  t0.reminder_datetime AS reminder_datetime_14,
  t0.id_lot AS id_lot_15,
  t0.id_tache_type AS id_tache_type_16,
  t0.id_tache_statut AS id_tache_statut_17,
  t0.id_tache_priorite AS id_tache_priorite_18,
  t0.created_by AS created_by_19
FROM
  tache t0
WHERE
  t0.id_tache = ?

SELECT t0.id_tache AS id_tache_1, t0.name_tache AS name_tache_2, t0.description_tache AS description_tache_3, t0.duration_tache AS duration_tache_4, t0.duration_estimated_tache AS duration_estimated_tache_5, t0.priority_tache AS priority_tache_6, t0.status_tache AS status_tache_7, t0.order_tache AS order_tache_8, t0.active AS active_9, t0.archived AS archived_10, t0.archived_at AS archived_at_11, t0.date_insert AS date_insert_12, t0.due_date AS due_date_13, t0.reminder_datetime AS reminder_datetime_14, t0.id_lot AS id_lot_15, t0.id_tache_type AS id_tache_type_16, t0.id_tache_statut AS id_tache_statut_17, t0.id_tache_priorite AS id_tache_priorite_18, t0.created_by AS created_by_19 FROM tache t0 WHERE t0.id_tache = 383;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 366)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 1895)
7	App\Controller\Api\TacheApiController->getTimeEntries (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.37 ms

SELECT t0.id_entry AS id_entry_1, t0.id_mtask AS id_mtask_2, t0.id_lot AS id_lot_3, t0.id_client_phone AS id_client_phone_4, t0.date_entry AS date_entry_5, t0.duration_entry AS duration_entry_6, t0.comment_entry AS comment_entry_7, t0.date_insert AS date_insert_8, t0.id_taskuser AS id_taskuser_9, t0.id_ticket AS id_ticket_10, t0.is_meeting AS is_meeting_11, t0.id_user AS id_user_12, t0.id_tache AS id_tache_13 FROM entry t0 WHERE t0.id_tache = ? ORDER BY t0.date_entry DESC

Parameters:

[
  383
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id_entry AS id_entry_1,
  t0.id_mtask AS id_mtask_2,
  t0.id_lot AS id_lot_3,
  t0.id_client_phone AS id_client_phone_4,
  t0.date_entry AS date_entry_5,
  t0.duration_entry AS duration_entry_6,
  t0.comment_entry AS comment_entry_7,
  t0.date_insert AS date_insert_8,
  t0.id_taskuser AS id_taskuser_9,
  t0.id_ticket AS id_ticket_10,
  t0.is_meeting AS is_meeting_11,
  t0.id_user AS id_user_12,
  t0.id_tache AS id_tache_13
FROM
  entry t0
WHERE
  t0.id_tache = ?
ORDER BY
  t0.date_entry DESC

SELECT t0.id_entry AS id_entry_1, t0.id_mtask AS id_mtask_2, t0.id_lot AS id_lot_3, t0.id_client_phone AS id_client_phone_4, t0.date_entry AS date_entry_5, t0.duration_entry AS duration_entry_6, t0.comment_entry AS comment_entry_7, t0.date_insert AS date_insert_8, t0.id_taskuser AS id_taskuser_9, t0.id_ticket AS id_ticket_10, t0.is_meeting AS is_meeting_11, t0.id_user AS id_user_12, t0.id_tache AS id_tache_13 FROM entry t0 WHERE t0.id_tache = 383 ORDER BY t0.date_entry DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 948)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 1901)
5	App\Controller\Api\TacheApiController->getTimeEntries (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	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\User	2
App\Entity\UserGroup	1
App\Entity\Tache	1
App\Entity\Lot	1
App\Entity\TacheStatut	1
App\Entity\TachePriorite	1
App\Entity\Entry	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\UserGroup	No errors.
App\Entity\Entry	No errors.
App\Entity\TaskUser	No errors.
App\Entity\ProjectUser	No errors.
App\Entity\LotUser	No errors.
App\Entity\TacheUser	No errors.
App\Entity\MaintenanceTaskUser	No errors.
App\Entity\Tache	The mappings App\Entity\Tache#tacheType and App\Entity\TacheType#taches are inconsistent with each other.
App\Entity\Lot	No errors.
App\Entity\TacheType	The association App\Entity\TacheType#taches refers to the owning side field App\Entity\Tache#taskType which does not exist.
App\Entity\TacheStatut	No errors.
App\Entity\TachePriorite	No errors.
App\Entity\TacheCommentaire	No errors.

Symfony Profiler

GET https://pistache.definima.io/api/taches/383/time-entries

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping