Symfony Profiler

Query Metrics

6 Database Queries

4 Different statements

7.35 ms Query time

0 Invalid entities

13 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.42 ms
(46.56%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.photo AS photo_7, t0.tel_mobile AS tel_mobile_8, t0.last_login AS last_login_9, t0.last_login_ip AS last_login_ip_10, t0.is_actif AS is_actif_11, t0.uuid AS uuid_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.site_id AS site_id_15, t0.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17 FROM user t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.nom AS nom_5,
  t0.prenom AS prenom_6,
  t0.photo AS photo_7,
  t0.tel_mobile AS tel_mobile_8,
  t0.last_login AS last_login_9,
  t0.last_login_ip AS last_login_ip_10,
  t0.is_actif AS is_actif_11,
  t0.uuid AS uuid_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.site_id AS site_id_15,
  t0.created_by_id AS created_by_id_16,
  t0.updated_by_id AS updated_by_id_17
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.photo AS photo_7, t0.tel_mobile AS tel_mobile_8, t0.last_login AS last_login_9, t0.last_login_ip AS last_login_ip_10, t0.is_actif AS is_actif_11, t0.uuid AS uuid_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.site_id AS site_id_15, t0.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17 FROM user t0 WHERE t0.id = 2;

#	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\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 214)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 131)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 60)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 80)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 208)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

1.51 ms
(20.53%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.detail AS detail_4, t0.echeance AS echeance_5, t0.priorite AS priorite_6, t0.statut AS statut_7, t0.is_done AS is_done_8, t0.done_at AS done_at_9, t0.uuid AS uuid_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.site_id AS site_id_13, t0.emetteur_id AS emetteur_id_14, t0.pilote_id AS pilote_id_15, t0.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17 FROM tache t0 WHERE t0.site_id = ? AND t0.is_done = ? ORDER BY t0.echeance ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.nom AS nom_3,
  t0.detail AS detail_4,
  t0.echeance AS echeance_5,
  t0.priorite AS priorite_6,
  t0.statut AS statut_7,
  t0.is_done AS is_done_8,
  t0.done_at AS done_at_9,
  t0.uuid AS uuid_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.site_id AS site_id_13,
  t0.emetteur_id AS emetteur_id_14,
  t0.pilote_id AS pilote_id_15,
  t0.created_by_id AS created_by_id_16,
  t0.updated_by_id AS updated_by_id_17
FROM
  tache t0
WHERE
  t0.site_id = ?
  AND t0.is_done = ?
ORDER BY
  t0.echeance ASC

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.detail AS detail_4, t0.echeance AS echeance_5, t0.priorite AS priorite_6, t0.statut AS statut_7, t0.is_done AS is_done_8, t0.done_at AS done_at_9, t0.uuid AS uuid_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.site_id AS site_id_13, t0.emetteur_id AS emetteur_id_14, t0.pilote_id AS pilote_id_15, t0.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17 FROM tache t0 WHERE t0.site_id = 1 AND t0.is_done = 0 ORDER BY t0.echeance ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\TacheController->index (line 58)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 208)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

1.35 ms
(18.33%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.detail AS detail_3, t0.is_done AS is_done_4, t0.done_at AS done_at_5, t0.src_entity AS src_entity_6, t0.src_title AS src_title_7, t0.src_uuid AS src_uuid_8, t0.uuid AS uuid_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.src_type AS src_type_12, t0.site_id AS site_id_13, t0.user_id AS user_id_14, t0.created_by_id AS created_by_id_15, t0.updated_by_id AS updated_by_id_16 FROM notification t0 WHERE t0.user_id = ? AND t0.is_done = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.detail AS detail_3,
  t0.is_done AS is_done_4,
  t0.done_at AS done_at_5,
  t0.src_entity AS src_entity_6,
  t0.src_title AS src_title_7,
  t0.src_uuid AS src_uuid_8,
  t0.uuid AS uuid_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.src_type AS src_type_12,
  t0.site_id AS site_id_13,
  t0.user_id AS user_id_14,
  t0.created_by_id AS created_by_id_15,
  t0.updated_by_id AS updated_by_id_16
FROM
  notification t0
WHERE
  t0.user_id = ?
  AND t0.is_done = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.detail AS detail_3, t0.is_done AS is_done_4, t0.done_at AS done_at_5, t0.src_entity AS src_entity_6, t0.src_title AS src_title_7, t0.src_uuid AS src_uuid_8, t0.uuid AS uuid_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.src_type AS src_type_12, t0.site_id AS site_id_13, t0.user_id AS user_id_14, t0.created_by_id AS created_by_id_15, t0.updated_by_id AS updated_by_id_16 FROM notification t0 WHERE t0.user_id = 2 AND t0.is_done = 0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Service\NotificationHelper->setNotificationsSession (line 23)
5	App\EventListener\LastRouteListener->onKernelRequest (line 78)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 208)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

1.07 ms
(14.58%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.adresse1 AS adresse1_4, t0.adresse2 AS adresse2_5, t0.cp AS cp_6, t0.ville AS ville_7, t0.pays AS pays_8, t0.siteweb AS siteweb_9, t0.email AS email_10, t0.tel AS tel_11, t0.effectif AS effectif_12, t0.siret AS siret_13, t0.numero_tva AS numero_tva_14, t0.pdf_footer AS pdf_footer_15, t0.wiki AS wiki_16, t0.dossier AS dossier_17, t0.logo AS logo_18, t0.devis_conditions AS devis_conditions_19, t0.devis_acompte_pourcent AS devis_acompte_pourcent_20, t0.devis_validation_montant_ttc AS devis_validation_montant_ttc_21, t0.devis_validators AS devis_validators_22, t0.devis_prefix AS devis_prefix_23, t0.devis_index_start AS devis_index_start_24, t0.options AS options_25, t0.is_restricted AS is_restricted_26, t0.restricted_at AS restricted_at_27, t0.is_actif AS is_actif_28, t0.infos AS infos_29, t0.uuid AS uuid_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.code_portefeuille AS code_portefeuille_33, t0.sign_infos AS sign_infos_34, t0.created_by_id AS created_by_id_35, t0.updated_by_id AS updated_by_id_36 FROM site t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.nom AS nom_3,
  t0.adresse1 AS adresse1_4,
  t0.adresse2 AS adresse2_5,
  t0.cp AS cp_6,
  t0.ville AS ville_7,
  t0.pays AS pays_8,
  t0.siteweb AS siteweb_9,
  t0.email AS email_10,
  t0.tel AS tel_11,
  t0.effectif AS effectif_12,
  t0.siret AS siret_13,
  t0.numero_tva AS numero_tva_14,
  t0.pdf_footer AS pdf_footer_15,
  t0.wiki AS wiki_16,
  t0.dossier AS dossier_17,
  t0.logo AS logo_18,
  t0.devis_conditions AS devis_conditions_19,
  t0.devis_acompte_pourcent AS devis_acompte_pourcent_20,
  t0.devis_validation_montant_ttc AS devis_validation_montant_ttc_21,
  t0.devis_validators AS devis_validators_22,
  t0.devis_prefix AS devis_prefix_23,
  t0.devis_index_start AS devis_index_start_24,
  t0.options AS options_25,
  t0.is_restricted AS is_restricted_26,
  t0.restricted_at AS restricted_at_27,
  t0.is_actif AS is_actif_28,
  t0.infos AS infos_29,
  t0.uuid AS uuid_30,
  t0.created_at AS created_at_31,
  t0.updated_at AS updated_at_32,
  t0.code_portefeuille AS code_portefeuille_33,
  t0.sign_infos AS sign_infos_34,
  t0.created_by_id AS created_by_id_35,
  t0.updated_by_id AS updated_by_id_36
FROM
  site t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.adresse1 AS adresse1_4, t0.adresse2 AS adresse2_5, t0.cp AS cp_6, t0.ville AS ville_7, t0.pays AS pays_8, t0.siteweb AS siteweb_9, t0.email AS email_10, t0.tel AS tel_11, t0.effectif AS effectif_12, t0.siret AS siret_13, t0.numero_tva AS numero_tva_14, t0.pdf_footer AS pdf_footer_15, t0.wiki AS wiki_16, t0.dossier AS dossier_17, t0.logo AS logo_18, t0.devis_conditions AS devis_conditions_19, t0.devis_acompte_pourcent AS devis_acompte_pourcent_20, t0.devis_validation_montant_ttc AS devis_validation_montant_ttc_21, t0.devis_validators AS devis_validators_22, t0.devis_prefix AS devis_prefix_23, t0.devis_index_start AS devis_index_start_24, t0.options AS options_25, t0.is_restricted AS is_restricted_26, t0.restricted_at AS restricted_at_27, t0.is_actif AS is_actif_28, t0.infos AS infos_29, t0.uuid AS uuid_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.code_portefeuille AS code_portefeuille_33, t0.sign_infos AS sign_infos_34, t0.created_by_id AS created_by_id_35, t0.updated_by_id AS updated_by_id_36 FROM site 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->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\Base\Site::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\App\Entity\Base\Site->__get (line 184)
7	App\Entity\Base\Site->getUuid (line 636)
8	Twig\Extension\CoreExtension->getAttribute (line 1909)
9	__TwigTemplate_15bbc3f1685f1aa652e6d84f40cef055::doDisplay (line 90)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_09efa7a70150bdc70444279b63811576->doDisplay (line 102)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_a0e64bc2f6ba2e80f56c08191c6b0ec0->doDisplay (line 58)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_73c03dc0c8b78bd1742d3880ea50530b->doDisplay (line 63)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
24	App\Controller\TacheController->index (line 61)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 208)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	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\Notification	7
App\Entity\Base\User	4
App\Entity\Base\Site	1
App\Entity\Tache	1

Entities Mapping

Class	Mapping errors
App\Entity\Base\User	No errors.
App\Entity\Base\Site	No errors.
App\Entity\Base\Ticket	No errors.
App\Entity\Devis	No errors.
App\Entity\Email	No errors.
App\Entity\Contrat	No errors.
App\Entity\Compte	No errors.
App\Entity\Notification	No errors.
App\Entity\Base\UserSession	No errors.
App\Entity\Tache	No errors.
App\Entity\Cheval	No errors.
App\Entity\Produit	No errors.
App\Entity\EmailDoc	No errors.
App\Entity\EmailAttachment	No errors.
App\Entity\DevisDeny	No errors.
App\Entity\ContratLigne	No errors.
App\Entity\Facture	No errors.
App\Entity\FactureLigne	No errors.
App\Entity\Liste	No errors.
App\Entity\Sinistre	No errors.
App\Entity\EmailContent	No errors.
App\Entity\Echange	No errors.
App\Entity\IndAcc\ProduitIndAcc	No errors.

Symfony Profiler

GET https://dev.chevaux-assurances.fr/private/taches/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping