Symfony Profiler

Query Metrics

7 Database Queries

6 Different statements

3.75 ms Query time

2 Invalid entities

12 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.87 ms
(23.10%)

SELECT t0.id AS id_1, t0.type AS type_2, t0.code_parametre AS code_parametre_3, t0.lib_prog AS lib_prog_4, t0.libclient AS libclient_5 FROM parametres t0 WHERE t0.type = ?

Parameters:

[
  "suiviLogistique"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.code_parametre AS code_parametre_3,
  t0.lib_prog AS lib_prog_4,
  t0.libclient AS libclient_5
FROM
  parametres t0
WHERE
  t0.type = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.code_parametre AS code_parametre_3, t0.lib_prog AS lib_prog_4, t0.libclient AS libclient_5 FROM parametres t0 WHERE t0.type = 'suiviLogistique';

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\AbstractTracingStatement->traceFunction (line 43)
2	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV3->execute (line 1104)
3	Doctrine\DBAL\Connection->executeQuery (line 972)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
5	Doctrine\ORM\EntityRepository->findBy (line 92)
6	App\Controller\SuiviLogistiqueController->show (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.71 ms
(19.03%)

SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.firstname AS firstname_13, t0.name AS name_14, t0.code_client_bc AS code_client_bc_15, t0.type_profil AS type_profil_16, t0.code_operation AS code_operation_17, t0.date_creation AS date_creation_18, t0.id_user_create AS id_user_create_19, t0.date_update AS date_update_20, t0.id_user_update AS id_user_update_21, t0.code_partenaire AS code_partenaire_22, t0.nom_art_file AS nom_art_file_23, t0.nom_pack_file AS nom_pack_file_24, t0.nom_com_file AS nom_com_file_25, t0.nom_recep_file AS nom_recep_file_26, t0.columns_order AS columns_order_27, t0.sil_conso_shop_name AS sil_conso_shop_name_28, t0.dtype FROM `fos_user` t0 WHERE t0.id = ? LIMIT 1

Parameters:

[
  13
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.username AS username_1,
  t0.username_canonical AS username_canonical_2,
  t0.email AS email_3,
  t0.email_canonical AS email_canonical_4,
  t0.enabled AS enabled_5,
  t0.salt AS salt_6,
  t0.password AS password_7,
  t0.last_login AS last_login_8,
  t0.confirmation_token AS confirmation_token_9,
  t0.password_requested_at AS password_requested_at_10,
  t0.roles AS roles_11,
  t0.id AS id_12,
  t0.firstname AS firstname_13,
  t0.name AS name_14,
  t0.code_client_bc AS code_client_bc_15,
  t0.type_profil AS type_profil_16,
  t0.code_operation AS code_operation_17,
  t0.date_creation AS date_creation_18,
  t0.id_user_create AS id_user_create_19,
  t0.date_update AS date_update_20,
  t0.id_user_update AS id_user_update_21,
  t0.code_partenaire AS code_partenaire_22,
  t0.nom_art_file AS nom_art_file_23,
  t0.nom_pack_file AS nom_pack_file_24,
  t0.nom_com_file AS nom_com_file_25,
  t0.nom_recep_file AS nom_recep_file_26,
  t0.columns_order AS columns_order_27,
  t0.sil_conso_shop_name AS sil_conso_shop_name_28,
  t0.dtype
FROM
  `fos_user` t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.firstname AS firstname_13, t0.name AS name_14, t0.code_client_bc AS code_client_bc_15, t0.type_profil AS type_profil_16, t0.code_operation AS code_operation_17, t0.date_creation AS date_creation_18, t0.id_user_create AS id_user_create_19, t0.date_update AS date_update_20, t0.id_user_update AS id_user_update_21, t0.code_partenaire AS code_partenaire_22, t0.nom_art_file AS nom_art_file_23, t0.nom_pack_file AS nom_pack_file_24, t0.nom_com_file AS nom_com_file_25, t0.nom_recep_file AS nom_recep_file_26, t0.columns_order AS columns_order_27, t0.sil_conso_shop_name AS sil_conso_shop_name_28, t0.dtype FROM `fos_user` t0 WHERE t0.id = 13 LIMIT 1;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\AbstractTracingStatement->traceFunction (line 43)
2	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV3->execute (line 1104)
3	Doctrine\DBAL\Connection->executeQuery (line 779)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
5	Doctrine\ORM\EntityRepository->findOneBy (line 75)
6	FOS\UserBundle\Doctrine\UserManager->findUserBy (line 79)
7	FOS\UserBundle\Security\UserProvider->refreshUser (line 214)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 131)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
11	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 83)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.67 ms
(17.88%)

SELECT n.* FROM notification n 
            LEFT JOIN notification_user nu ON nu.notification_id = n.id 
            LEFT JOIN fos_user u ON u.id = nu.user_id
            WHERE n.is_active = 1 
            AND n.activation_date IS NOT NULL
            AND (DATE_ADD(n.activation_date, INTERVAL n.visibility_time DAY) >= NOW() 
            OR n.visibility_time IS NULL) AND u.id = ? ORDER BY n.activation_date DESC

Parameters:

[
  13
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n.*
FROM
  notification n
  LEFT JOIN notification_user nu ON nu.notification_id = n.id
  LEFT JOIN fos_user u ON u.id = nu.user_id
WHERE
  n.is_active = 1
  AND n.activation_date IS NOT NULL
  AND (
    DATE_ADD(
      n.activation_date, INTERVAL n.visibility_time DAY
    ) >= NOW()
    OR n.visibility_time IS NULL
  )
  AND u.id = ?
ORDER BY
  n.activation_date DESC

SELECT n.* FROM notification n 
            LEFT JOIN notification_user nu ON nu.notification_id = n.id 
            LEFT JOIN fos_user u ON u.id = nu.user_id
            WHERE n.is_active = 1 
            AND n.activation_date IS NOT NULL
            AND (DATE_ADD(n.activation_date, INTERVAL n.visibility_time DAY) >= NOW() 
            OR n.visibility_time IS NULL) AND u.id = 13 ORDER BY n.activation_date DESC;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\AbstractTracingStatement->traceFunction (line 43)
2	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV3->execute (line 1104)
3	Doctrine\DBAL\Connection->executeQuery (line 79)
4	Doctrine\ORM\NativeQuery->_doExecute (line 1218)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
6	Doctrine\ORM\AbstractQuery->execute (line 919)
7	Doctrine\ORM\AbstractQuery->getArrayResult (line 40)
8	App\Repository\NotificationRepository->getHeaderNotifications (line 32)
9	App\Twig\AppExtension->getHeaderNotifications (line 51)
10	__TwigTemplate_02b10241d5e2223b41335cacbfed74c1->doDisplay (line 388)
11	Twig\Template->yield (line 218)
12	__TwigTemplate_c4fc4089f29c1aef2ecf9db7270bf167->block_header (line 432)
13	Twig\Template->yieldBlock (line 83)
14	__TwigTemplate_c4fc4089f29c1aef2ecf9db7270bf167->doDisplay (line 388)
15	Twig\Template->yield (line 59)
16	__TwigTemplate_14b1363e70008af4dbcfed76e0dd489c->doDisplay (line 388)
17	Twig\Template->yield (line 344)
18	Twig\Template->display (line 359)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 334)
21	Twig\Environment->render (line 448)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 111)
25	App\Controller\SuiviLogistiqueController->show (line 181)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

0.66 ms
(17.67%)

SELECT t0.id AS id_1, t0.date_demande AS date_demande_2, t0.operation AS operation_3, t0.commande AS commande_4, t0.commande_n3 AS commande_n3_5, t0.objet AS objet_6, t0.etat AS etat_7, t0.demandeur AS demandeur_8, t0.date_resolution AS date_resolution_9, t0.dernier_type_utilisateur AS dernier_type_utilisateur_10, t0.dernier_utilisateur AS dernier_utilisateur_11, t0.is_seen AS is_seen_12 FROM suivi_logistique t0 WHERE t0.id = ?

Parameters:

[
  "000000051"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date_demande AS date_demande_2,
  t0.operation AS operation_3,
  t0.commande AS commande_4,
  t0.commande_n3 AS commande_n3_5,
  t0.objet AS objet_6,
  t0.etat AS etat_7,
  t0.demandeur AS demandeur_8,
  t0.date_resolution AS date_resolution_9,
  t0.dernier_type_utilisateur AS dernier_type_utilisateur_10,
  t0.dernier_utilisateur AS dernier_utilisateur_11,
  t0.is_seen AS is_seen_12
FROM
  suivi_logistique t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.date_demande AS date_demande_2, t0.operation AS operation_3, t0.commande AS commande_4, t0.commande_n3 AS commande_n3_5, t0.objet AS objet_6, t0.etat AS etat_7, t0.demandeur AS demandeur_8, t0.date_resolution AS date_resolution_9, t0.dernier_type_utilisateur AS dernier_type_utilisateur_10, t0.dernier_utilisateur AS dernier_utilisateur_11, t0.is_seen AS is_seen_12 FROM suivi_logistique t0 WHERE t0.id = '000000051';

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\AbstractTracingStatement->traceFunction (line 43)
2	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV3->execute (line 1104)
3	Doctrine\DBAL\Connection->executeQuery (line 779)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
5	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
6	Doctrine\ORM\EntityManager->find (line 196)
7	Doctrine\ORM\EntityRepository->find (line 90)
8	App\Controller\SuiviLogistiqueController->show (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.45 ms
(11.88%)

SELECT t0.id AS id_1, t0.utilisateur AS utilisateur_2, t0.type_utilisateur AS type_utilisateur_3, t0.commentaire AS commentaire_4, t0.suivi_id AS suivi_id_5 FROM detail_suivi_logistique t0 WHERE t0.suivi_id = ?

Parameters:

[
  "000000051"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.utilisateur AS utilisateur_2,
  t0.type_utilisateur AS type_utilisateur_3,
  t0.commentaire AS commentaire_4,
  t0.suivi_id AS suivi_id_5
FROM
  detail_suivi_logistique t0
WHERE
  t0.suivi_id = ?

SELECT t0.id AS id_1, t0.utilisateur AS utilisateur_2, t0.type_utilisateur AS type_utilisateur_3, t0.commentaire AS commentaire_4, t0.suivi_id AS suivi_id_5 FROM detail_suivi_logistique t0 WHERE t0.suivi_id = '000000051';

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\AbstractTracingStatement->traceFunction (line 43)
2	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV3->execute (line 1104)
3	Doctrine\DBAL\Connection->executeQuery (line 972)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
5	Doctrine\ORM\EntityRepository->findBy (line 107)
6	App\Controller\SuiviLogistiqueController->show (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.39 ms
(10.46%)

SELECT n.* FROM notification n 
            WHERE n.is_active = 1 
            AND (DATE_ADD(n.activation_date, INTERVAL n.visibility_time DAY) >= NOW() 
            OR n.visibility_time IS NULL) ORDER BY n.activation_date DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n.*
FROM
  notification n
WHERE
  n.is_active = 1
  AND (
    DATE_ADD(
      n.activation_date, INTERVAL n.visibility_time DAY
    ) >= NOW()
    OR n.visibility_time IS NULL
  )
ORDER BY
  n.activation_date DESC

SELECT n.* FROM notification n 
            WHERE n.is_active = 1 
            AND (DATE_ADD(n.activation_date, INTERVAL n.visibility_time DAY) >= NOW() 
            OR n.visibility_time IS NULL) ORDER BY n.activation_date DESC;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV2V3->Sentry\SentryBundle\Tracing\Doctrine\DBAL\{closure} (line 242)
2	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV2V3->traceFunction (line 113)
3	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV2V3->query (line 49)
4	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingServerInfoAwareDriverConnection->query (line 1106)
5	Doctrine\DBAL\Connection->executeQuery (line 79)
6	Doctrine\ORM\NativeQuery->_doExecute (line 1218)
7	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
8	Doctrine\ORM\AbstractQuery->execute (line 919)
9	Doctrine\ORM\AbstractQuery->getArrayResult (line 59)
10	App\Repository\NotificationRepository->getHeaderNotifications (line 32)
11	App\Twig\AppExtension->getHeaderNotifications (line 51)
12	__TwigTemplate_02b10241d5e2223b41335cacbfed74c1->doDisplay (line 388)
13	Twig\Template->yield (line 218)
14	__TwigTemplate_c4fc4089f29c1aef2ecf9db7270bf167->block_header (line 432)
15	Twig\Template->yieldBlock (line 83)
16	__TwigTemplate_c4fc4089f29c1aef2ecf9db7270bf167->doDisplay (line 388)
17	Twig\Template->yield (line 59)
18	__TwigTemplate_14b1363e70008af4dbcfed76e0dd489c->doDisplay (line 388)
19	Twig\Template->yield (line 344)
20	Twig\Template->display (line 359)
21	Twig\Template->render (line 51)
22	Twig\TemplateWrapper->render (line 334)
23	Twig\Environment->render (line 448)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 111)
27	App\Controller\SuiviLogistiqueController->show (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	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\DetailSuiviLogistique	7
App\Entity\Parametres	3
App\Entity\User	1
App\Entity\SuiviLogistique	1

Entities Mapping

Class	Mapping errors
FOS\UserBundle\Model\User	No errors.
App\Entity\User	No errors.
App\Entity\CommandeExportManuel	No errors.
App\Entity\Notification	No errors.
App\Entity\SuiviLogistique	The association App\Entity\SuiviLogistique#SuiviLogistiqueDetails refers to the owning side field App\Entity\DetailSuiviLogistique#id which is not defined as association, but as field. The association App\Entity\SuiviLogistique#SuiviLogistiqueDetails refers to the owning side field App\Entity\DetailSuiviLogistique#id which does not exist.
App\Entity\DetailSuiviLogistique	The association App\Entity\DetailSuiviLogistique#suiviLogistique refers to the inverse side field App\Entity\SuiviLogistique#suiviLogistiqueDetails which does not exist.
App\Entity\Parametres	No errors.

Symfony Profiler

GET https://pp.starting.web.oxv.fr/suivi-logistique/000000051

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping