Symfony Profiler

Query Metrics

4 Database Queries

2 Different statements

70.79 ms Query time

0 Invalid entities

688 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

60.75 ms
(85.81%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.ref AS ref_4, t0.old_id_web AS old_id_web_5, t0.is_etat_end AS is_etat_end_6, t0.is_etat_one AS is_etat_one_7, t0.is_accep AS is_accep_8, t0.quantite AS quantite_9, t0.num_commande AS num_commande_10, t0.num_facture AS num_facture_11, t0.date AS date_12, t0.is_en_livraison AS is_en_livraison_13, t0.date_delivery AS date_delivery_14 FROM mouvement_web t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.ean13 AS ean13_3,
  t0.ref AS ref_4,
  t0.old_id_web AS old_id_web_5,
  t0.is_etat_end AS is_etat_end_6,
  t0.is_etat_one AS is_etat_one_7,
  t0.is_accep AS is_accep_8,
  t0.quantite AS quantite_9,
  t0.num_commande AS num_commande_10,
  t0.num_facture AS num_facture_11,
  t0.date AS date_12,
  t0.is_en_livraison AS is_en_livraison_13,
  t0.date_delivery AS date_delivery_14
FROM
  mouvement_web t0

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.ref AS ref_4, t0.old_id_web AS old_id_web_5, t0.is_etat_end AS is_etat_end_6, t0.is_etat_one AS is_etat_one_7, t0.is_accep AS is_accep_8, t0.quantite AS quantite_9, t0.num_commande AS num_commande_10, t0.num_facture AS num_facture_11, t0.date AS date_12, t0.is_en_livraison AS is_en_livraison_13, t0.date_delivery AS date_delivery_14 FROM mouvement_web t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 23)
6	App\Twig\Components\BellNotif->getMouvements (line 1909)
7	Twig\Extension\CoreExtension::getAttribute (line 59)
8	__TwigTemplate_84f68b0e3be382a626e80fc525ea2017->doDisplay (line 402)
9	Twig\Template->yield (line 358)
10	Twig\Template->display (line 373)
11	Twig\Template->render (line 77)
12	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
13	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
14	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 236)
15	__TwigTemplate_67cb56fe31a7f1c33caf1e9c1ca3a9c3->doDisplay (line 402)
16	Twig\Template->yield (line 358)
17	Twig\Template->display (line 373)
18	Twig\Template->render (line 77)
19	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
20	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
21	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 247)
22	__TwigTemplate_65aad7421501b7d281d908ea5b868879->block_body (line 446)
23	Twig\Template->yieldBlock (line 109)
24	__TwigTemplate_65aad7421501b7d281d908ea5b868879->doDisplay (line 402)
25	Twig\Template->yield (line 54)
26	__TwigTemplate_9ab96b1f46943d6e1e71c8320b01b2fb->doDisplay (line 402)
27	Twig\Template->yield (line 358)
28	Twig\Template->display (line 373)
29	Twig\Template->render (line 51)
30	Twig\TemplateWrapper->render (line 333)
31	Twig\Environment->render (line 459)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 70)
35	App\Controller\ProduitController->show (line 183)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
38	Symfony\Component\HttpKernel\Kernel->handle (line 35)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
40	require_once (line 5)

10.04 ms
(14.19%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.old AS old_4, t0.bundle AS bundle_5, t0.is_active AS is_active_6, t0.reference AS reference_7, t0.qr_code_path AS qr_code_path_8, t0.is_surveillance AS is_surveillance_9, t0.is_france AS is_france_10, t0.is_active_produit AS is_active_produit_11, t0.is_coupure_produit AS is_coupure_produit_12, t0.is_in_active_produit AS is_in_active_produit_13, t0.date_debut AS date_debut_14, t0.date_fin AS date_fin_15 FROM produit t0 WHERE t0.id = ?

Parameters:

[
  "4"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.ean13 AS ean13_3,
  t0.old AS old_4,
  t0.bundle AS bundle_5,
  t0.is_active AS is_active_6,
  t0.reference AS reference_7,
  t0.qr_code_path AS qr_code_path_8,
  t0.is_surveillance AS is_surveillance_9,
  t0.is_france AS is_france_10,
  t0.is_active_produit AS is_active_produit_11,
  t0.is_coupure_produit AS is_coupure_produit_12,
  t0.is_in_active_produit AS is_in_active_produit_13,
  t0.date_debut AS date_debut_14,
  t0.date_fin AS date_fin_15
FROM
  produit t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.old AS old_4, t0.bundle AS bundle_5, t0.is_active AS is_active_6, t0.reference AS reference_7, t0.qr_code_path AS qr_code_path_8, t0.is_surveillance AS is_surveillance_9, t0.is_france AS is_france_10, t0.is_active_produit AS is_active_produit_11, t0.is_coupure_produit AS is_coupure_produit_12, t0.is_in_active_produit AS is_in_active_produit_13, t0.date_debut AS date_debut_14, t0.date_fin AS date_fin_15 FROM produit t0 WHERE t0.id = '4';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 129)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 69)
8	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
10	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	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\MouvementWeb	687
App\Entity\Produit	1

Entities Mapping

Class	Mapping errors
App\Entity\Produit	No errors.
App\Entity\Association	No errors.
App\Entity\MouvementWeb	No errors.
App\Entity\MouvementTransporteur	No errors.
App\Entity\MouvementWebAccessoires	No errors.

Symfony Profiler

GET https://app-prod.fr/produit/4

Configuration Settings

Theme

Page Width