Symfony Profiler

Query Metrics

10 Database Queries

9 Different statements

5.39 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.77 ms
(32.85%)

SELECT t0.id AS id_1, t0.date AS date_2, t0.numero AS numero_3, t0.code AS code_4, t0.ref_client AS ref_client_5, t0.numero_expedition AS numero_expedition_6, t0.a_facturer AS a_facturer_7, t0.facture_num AS facture_num_8, t0.devis_num AS devis_num_9, t0.paiement_en_attente AS paiement_en_attente_10, t0.facture_dans_colis AS facture_dans_colis_11, t0.commentaire AS commentaire_12, t0.create_by_id AS create_by_id_13, t0.client_id AS client_id_14, t0.adresse_id AS adresse_id_15, t0.transporteur_id AS transporteur_id_16, t0.statut_id AS statut_id_17 FROM commande t0 WHERE t0.id = ?

Parameters:

[
  "698"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.numero AS numero_3,
  t0.code AS code_4,
  t0.ref_client AS ref_client_5,
  t0.numero_expedition AS numero_expedition_6,
  t0.a_facturer AS a_facturer_7,
  t0.facture_num AS facture_num_8,
  t0.devis_num AS devis_num_9,
  t0.paiement_en_attente AS paiement_en_attente_10,
  t0.facture_dans_colis AS facture_dans_colis_11,
  t0.commentaire AS commentaire_12,
  t0.create_by_id AS create_by_id_13,
  t0.client_id AS client_id_14,
  t0.adresse_id AS adresse_id_15,
  t0.transporteur_id AS transporteur_id_16,
  t0.statut_id AS statut_id_17
FROM
  commande t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.date AS date_2, t0.numero AS numero_3, t0.code AS code_4, t0.ref_client AS ref_client_5, t0.numero_expedition AS numero_expedition_6, t0.a_facturer AS a_facturer_7, t0.facture_num AS facture_num_8, t0.devis_num AS devis_num_9, t0.paiement_en_attente AS paiement_en_attente_10, t0.facture_dans_colis AS facture_dans_colis_11, t0.commentaire AS commentaire_12, t0.create_by_id AS create_by_id_13, t0.client_id AS client_id_14, t0.adresse_id AS adresse_id_15, t0.transporteur_id AS transporteur_id_16, t0.statut_id AS statut_id_17 FROM commande t0 WHERE t0.id = '698';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 1071)
6	App\Controller\DefaultController->showCommandeDetailAction (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.74 ms
(13.78%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.position AS position_3 FROM kit_statut t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.position AS position_3
FROM
  kit_statut t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.position AS position_3 FROM kit_statut t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 248)
4	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 134)
5	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 97)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 176)
7	Proxies\__CG__\App\Entity\KitStatut->__get (line 41)
8	App\Entity\KitStatut->getPosition (line 1637)
9	twig_get_attribute (line 51)
10	__TwigTemplate_8361034a87f522aa4175d3ef75cf6d15->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 112)
13	__TwigTemplate_f523d2bcc0422846cef730e46d64e393->block_body (line 171)
14	Twig\Template->displayBlock (line 268)
15	__TwigTemplate_3cef8b7cc1016d2ae9c30bff53b6e7ed->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 51)
18	__TwigTemplate_f523d2bcc0422846cef730e46d64e393->doDisplay (line 394)
19	Twig\Template->displayWithErrorHandling (line 367)
20	Twig\Template->display (line 379)
21	Twig\Template->render (line 40)
22	Twig\TemplateWrapper->render (line 280)
23	Twig\Environment->render (line 243)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 1077)
26	App\Controller\DefaultController->showCommandeDetailAction (line 181)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

0.56 ms
(10.29%)

SELECT t0.id AS id_1, t0.blacklisted AS blacklisted_2, t0.blacklisted_commentaire AS blacklisted_commentaire_3, t0.codekit AS codekit_4, t0.numero_retour AS numero_retour_5, t0.delai AS delai_6, t0.cofrac AS cofrac_7, t0.commentaire AS commentaire_8, t0.prep_date AS prep_date_9, t0.prelev_start_date AS prelev_start_date_10, t0.prelev_end_date AS prelev_end_date_11, t0.recpt_date AS recpt_date_12, t0.rapport_deadline AS rapport_deadline_13, t0.recpt_commentaire AS recpt_commentaire_14, t0.ncr AS ncr_15, t0.ncr_ref AS ncr_ref_16, t0.rapport_signe AS rapport_signe_17, t0.format AS format_18, t0.prelev_piece_text AS prelev_piece_text_19, t0.prelev_temp AS prelev_temp_20, t0.prelev_filtration_mol AS prelev_filtration_mol_21, t0.prelev_nature AS prelev_nature_22, t0.prelev_traitement AS prelev_traitement_23, t0.prelev_quantite AS prelev_quantite_24, t0.prelev_long AS prelev_long_25, t0.prelev_couleur AS prelev_couleur_26, t0.prelev_prox_cultures AS prelev_prox_cultures_27, t0.prelev_expo_pro AS prelev_expo_pro_28, t0.prelev_pest_dom AS prelev_pest_dom_29, t0.facture_num AS facture_num_30, t0.rapport_email AS rapport_email_31, t0.kit_type_id AS kit_type_id_32, t0.statut_id AS statut_id_33, t0.prep_user_id AS prep_user_id_34, t0.recpt_user_id AS recpt_user_id_35, t0.commande_id AS commande_id_36, t0.prelev_piece_id AS prelev_piece_id_37 FROM kit t0 WHERE t0.commande_id = ?

Parameters:

[
  698
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.blacklisted AS blacklisted_2,
  t0.blacklisted_commentaire AS blacklisted_commentaire_3,
  t0.codekit AS codekit_4,
  t0.numero_retour AS numero_retour_5,
  t0.delai AS delai_6,
  t0.cofrac AS cofrac_7,
  t0.commentaire AS commentaire_8,
  t0.prep_date AS prep_date_9,
  t0.prelev_start_date AS prelev_start_date_10,
  t0.prelev_end_date AS prelev_end_date_11,
  t0.recpt_date AS recpt_date_12,
  t0.rapport_deadline AS rapport_deadline_13,
  t0.recpt_commentaire AS recpt_commentaire_14,
  t0.ncr AS ncr_15,
  t0.ncr_ref AS ncr_ref_16,
  t0.rapport_signe AS rapport_signe_17,
  t0.format AS format_18,
  t0.prelev_piece_text AS prelev_piece_text_19,
  t0.prelev_temp AS prelev_temp_20,
  t0.prelev_filtration_mol AS prelev_filtration_mol_21,
  t0.prelev_nature AS prelev_nature_22,
  t0.prelev_traitement AS prelev_traitement_23,
  t0.prelev_quantite AS prelev_quantite_24,
  t0.prelev_long AS prelev_long_25,
  t0.prelev_couleur AS prelev_couleur_26,
  t0.prelev_prox_cultures AS prelev_prox_cultures_27,
  t0.prelev_expo_pro AS prelev_expo_pro_28,
  t0.prelev_pest_dom AS prelev_pest_dom_29,
  t0.facture_num AS facture_num_30,
  t0.rapport_email AS rapport_email_31,
  t0.kit_type_id AS kit_type_id_32,
  t0.statut_id AS statut_id_33,
  t0.prep_user_id AS prep_user_id_34,
  t0.recpt_user_id AS recpt_user_id_35,
  t0.commande_id AS commande_id_36,
  t0.prelev_piece_id AS prelev_piece_id_37
FROM
  kit t0
WHERE
  t0.commande_id = ?

SELECT t0.id AS id_1, t0.blacklisted AS blacklisted_2, t0.blacklisted_commentaire AS blacklisted_commentaire_3, t0.codekit AS codekit_4, t0.numero_retour AS numero_retour_5, t0.delai AS delai_6, t0.cofrac AS cofrac_7, t0.commentaire AS commentaire_8, t0.prep_date AS prep_date_9, t0.prelev_start_date AS prelev_start_date_10, t0.prelev_end_date AS prelev_end_date_11, t0.recpt_date AS recpt_date_12, t0.rapport_deadline AS rapport_deadline_13, t0.recpt_commentaire AS recpt_commentaire_14, t0.ncr AS ncr_15, t0.ncr_ref AS ncr_ref_16, t0.rapport_signe AS rapport_signe_17, t0.format AS format_18, t0.prelev_piece_text AS prelev_piece_text_19, t0.prelev_temp AS prelev_temp_20, t0.prelev_filtration_mol AS prelev_filtration_mol_21, t0.prelev_nature AS prelev_nature_22, t0.prelev_traitement AS prelev_traitement_23, t0.prelev_quantite AS prelev_quantite_24, t0.prelev_long AS prelev_long_25, t0.prelev_couleur AS prelev_couleur_26, t0.prelev_prox_cultures AS prelev_prox_cultures_27, t0.prelev_expo_pro AS prelev_expo_pro_28, t0.prelev_pest_dom AS prelev_pest_dom_29, t0.facture_num AS facture_num_30, t0.rapport_email AS rapport_email_31, t0.kit_type_id AS kit_type_id_32, t0.statut_id AS statut_id_33, t0.prep_user_id AS prep_user_id_34, t0.recpt_user_id AS recpt_user_id_35, t0.commande_id AS commande_id_36, t0.prelev_piece_id AS prelev_piece_id_37 FROM kit t0 WHERE t0.commande_id = 698;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1886)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1827)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3166)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 458)
8	Doctrine\ORM\PersistentCollection->count (line 151)
9	__TwigTemplate_f523d2bcc0422846cef730e46d64e393->block_body (line 171)
10	Twig\Template->displayBlock (line 268)
11	__TwigTemplate_3cef8b7cc1016d2ae9c30bff53b6e7ed->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 51)
14	__TwigTemplate_f523d2bcc0422846cef730e46d64e393->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 379)
17	Twig\Template->render (line 40)
18	Twig\TemplateWrapper->render (line 280)
19	Twig\Environment->render (line 243)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 1077)
22	App\Controller\DefaultController->showCommandeDetailAction (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.52 ms
(9.61%)

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.status AS status_7, t0.is_verified AS is_verified_8 FROM `user` t0 WHERE t0.id = ?

Parameters:

[
  6
]

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.status AS status_7,
  t0.is_verified AS is_verified_8
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.status AS status_7, t0.is_verified AS is_verified_8 FROM `user` t0 WHERE t0.id = 6;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 92)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 207)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 60)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 80)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.48 ms
(8.96%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.numero_badge AS numero_badge_3 FROM support t0 INNER JOIN kit_type_support ON t0.id = kit_type_support.support_id WHERE kit_type_support.kit_type_id = ?

Parameters:

[
  25
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.numero_badge AS numero_badge_3
FROM
  support t0
  INNER JOIN kit_type_support ON t0.id = kit_type_support.support_id
WHERE
  kit_type_support.kit_type_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.numero_badge AS numero_badge_3 FROM support t0 INNER JOIN kit_type_support ON t0.id = kit_type_support.support_id WHERE kit_type_support.kit_type_id = 25;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1087)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1009)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3170)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 108)
7	Doctrine\Common\Collections\AbstractLazyCollection->containsKey (line 409)
8	Doctrine\ORM\PersistentCollection->containsKey (line 498)
9	Doctrine\ORM\PersistentCollection->offsetExists (line 1478)
10	twig_get_attribute (line 240)
11	__TwigTemplate_f523d2bcc0422846cef730e46d64e393->block_body (line 171)
12	Twig\Template->displayBlock (line 268)
13	__TwigTemplate_3cef8b7cc1016d2ae9c30bff53b6e7ed->doDisplay (line 394)
14	Twig\Template->displayWithErrorHandling (line 367)
15	Twig\Template->display (line 51)
16	__TwigTemplate_f523d2bcc0422846cef730e46d64e393->doDisplay (line 394)
17	Twig\Template->displayWithErrorHandling (line 367)
18	Twig\Template->display (line 379)
19	Twig\Template->render (line 40)
20	Twig\TemplateWrapper->render (line 280)
21	Twig\Environment->render (line 243)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 1077)
24	App\Controller\DefaultController->showCommandeDetailAction (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.39 ms
(7.31%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.rapport_type AS rapport_type_3, t0.delai AS delai_4, t0.code AS code_5, t0.code_old AS code_old_6, t0.ref_dolibarr AS ref_dolibarr_7, t0.delai_express AS delai_express_8, t0.active AS active_9, t0.prelev_end_date AS prelev_end_date_10, t0.prelev_lieu AS prelev_lieu_11, t0.prelev_temp AS prelev_temp_12, t0.prelev_pesticides AS prelev_pesticides_13, t0.category_id AS category_id_14 FROM kit_type t0 WHERE t0.id = ?

Parameters:

[
  25
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.rapport_type AS rapport_type_3,
  t0.delai AS delai_4,
  t0.code AS code_5,
  t0.code_old AS code_old_6,
  t0.ref_dolibarr AS ref_dolibarr_7,
  t0.delai_express AS delai_express_8,
  t0.active AS active_9,
  t0.prelev_end_date AS prelev_end_date_10,
  t0.prelev_lieu AS prelev_lieu_11,
  t0.prelev_temp AS prelev_temp_12,
  t0.prelev_pesticides AS prelev_pesticides_13,
  t0.category_id AS category_id_14
FROM
  kit_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.rapport_type AS rapport_type_3, t0.delai AS delai_4, t0.code AS code_5, t0.code_old AS code_old_6, t0.ref_dolibarr AS ref_dolibarr_7, t0.delai_express AS delai_express_8, t0.active AS active_9, t0.prelev_end_date AS prelev_end_date_10, t0.prelev_lieu AS prelev_lieu_11, t0.prelev_temp AS prelev_temp_12, t0.prelev_pesticides AS prelev_pesticides_13, t0.category_id AS category_id_14 FROM kit_type t0 WHERE t0.id = 25;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 248)
4	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 134)
5	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 97)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 176)
7	Proxies\__CG__\App\Entity\KitType->__get (line 81)
8	App\Entity\KitType->getLibelle (line 1637)
9	twig_get_attribute (line 178)
10	__TwigTemplate_f523d2bcc0422846cef730e46d64e393->block_body (line 171)
11	Twig\Template->displayBlock (line 268)
12	__TwigTemplate_3cef8b7cc1016d2ae9c30bff53b6e7ed->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 51)
15	__TwigTemplate_f523d2bcc0422846cef730e46d64e393->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 379)
18	Twig\Template->render (line 40)
19	Twig\TemplateWrapper->render (line 280)
20	Twig\Environment->render (line 243)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 1077)
23	App\Controller\DefaultController->showCommandeDetailAction (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.34 ms
(6.32%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.adresse AS adresse_4, t0.cp AS cp_5, t0.ville AS ville_6, t0.pays AS pays_7, t0.is_facturation AS is_facturation_8, t0.livraison_default AS livraison_default_9, t0.societe AS societe_10, t0.client_id AS client_id_11 FROM adresse t0 WHERE t0.id = ?

Parameters:

[
  429
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenom AS prenom_3,
  t0.adresse AS adresse_4,
  t0.cp AS cp_5,
  t0.ville AS ville_6,
  t0.pays AS pays_7,
  t0.is_facturation AS is_facturation_8,
  t0.livraison_default AS livraison_default_9,
  t0.societe AS societe_10,
  t0.client_id AS client_id_11
FROM
  adresse t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.adresse AS adresse_4, t0.cp AS cp_5, t0.ville AS ville_6, t0.pays AS pays_7, t0.is_facturation AS is_facturation_8, t0.livraison_default AS livraison_default_9, t0.societe AS societe_10, t0.client_id AS client_id_11 FROM adresse t0 WHERE t0.id = 429;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 248)
4	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 134)
5	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 97)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 176)
7	Proxies\__CG__\App\Entity\Adresse->__get (line 167)
8	App\Entity\Adresse->getSociete (line 1637)
9	twig_get_attribute (line 146)
10	__TwigTemplate_8361034a87f522aa4175d3ef75cf6d15->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 112)
13	__TwigTemplate_f523d2bcc0422846cef730e46d64e393->block_body (line 171)
14	Twig\Template->displayBlock (line 268)
15	__TwigTemplate_3cef8b7cc1016d2ae9c30bff53b6e7ed->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 51)
18	__TwigTemplate_f523d2bcc0422846cef730e46d64e393->doDisplay (line 394)
19	Twig\Template->displayWithErrorHandling (line 367)
20	Twig\Template->display (line 379)
21	Twig\Template->render (line 40)
22	Twig\TemplateWrapper->render (line 280)
23	Twig\Environment->render (line 243)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 1077)
26	App\Controller\DefaultController->showCommandeDetailAction (line 181)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

0.32 ms
(5.92%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.ref_client_dolibarr AS ref_client_dolibarr_3, t0.societe AS societe_4, t0.nom AS nom_5, t0.prenom AS prenom_6 FROM client t0 WHERE t0.id = ?

Parameters:

[
  392
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.ref_client_dolibarr AS ref_client_dolibarr_3,
  t0.societe AS societe_4,
  t0.nom AS nom_5,
  t0.prenom AS prenom_6
FROM
  client t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.ref_client_dolibarr AS ref_client_dolibarr_3, t0.societe AS societe_4, t0.nom AS nom_5, t0.prenom AS prenom_6 FROM client t0 WHERE t0.id = 392;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 248)
4	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 134)
5	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 97)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 176)
7	Proxies\__CG__\App\Entity\Client->__get (line 106)
8	App\Entity\Client->getSociete (line 1637)
9	twig_get_attribute (line 127)
10	__TwigTemplate_8361034a87f522aa4175d3ef75cf6d15->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 112)
13	__TwigTemplate_f523d2bcc0422846cef730e46d64e393->block_body (line 171)
14	Twig\Template->displayBlock (line 268)
15	__TwigTemplate_3cef8b7cc1016d2ae9c30bff53b6e7ed->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 51)
18	__TwigTemplate_f523d2bcc0422846cef730e46d64e393->doDisplay (line 394)
19	Twig\Template->displayWithErrorHandling (line 367)
20	Twig\Template->display (line 379)
21	Twig\Template->render (line 40)
22	Twig\TemplateWrapper->render (line 280)
23	Twig\Environment->render (line 243)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 1077)
26	App\Controller\DefaultController->showCommandeDetailAction (line 181)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

0.27 ms
(4.97%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM transporteur t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  transporteur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM transporteur t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 248)
4	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 134)
5	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 97)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 176)
7	Proxies\__CG__\App\Entity\Transporteur->__get (line 26)
8	App\Entity\Transporteur->getLibelle (line 1637)
9	twig_get_attribute (line 61)
10	__TwigTemplate_8361034a87f522aa4175d3ef75cf6d15->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 112)
13	__TwigTemplate_f523d2bcc0422846cef730e46d64e393->block_body (line 171)
14	Twig\Template->displayBlock (line 268)
15	__TwigTemplate_3cef8b7cc1016d2ae9c30bff53b6e7ed->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 51)
18	__TwigTemplate_f523d2bcc0422846cef730e46d64e393->doDisplay (line 394)
19	Twig\Template->displayWithErrorHandling (line 367)
20	Twig\Template->display (line 379)
21	Twig\Template->render (line 40)
22	Twig\TemplateWrapper->render (line 280)
23	Twig\Environment->render (line 243)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 1077)
26	App\Controller\DefaultController->showCommandeDetailAction (line 181)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	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.

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Commande	No errors.
App\Entity\Client	No errors.
App\Entity\Adresse	No errors.
App\Entity\Transporteur	No errors.
App\Entity\KitStatut	No errors.
App\Entity\Kit	No errors.
App\Entity\KitType	No errors.
App\Entity\PiecePrelevt	No errors.
App\Entity\Echantillon	No errors.
App\Entity\Rapport	No errors.
App\Entity\KitCategory	No errors.
App\Entity\Molecule	No errors.
App\Entity\Support	No errors.
App\Entity\MoleculeCategory	No errors.
App\Entity\Lot	No errors.

Symfony Profiler

GET https://lims.kudzuscience.com/operateur/show/commande/detail/698

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping