Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

2.23 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.67 ms
(29.97%)

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.id = ?

Parameters:

[
  "2403"
]

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.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.id = '2403';

#	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 1307)
6	App\Controller\DefaultController->printEtiquettesKitAction (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.60 ms
(26.73%)

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 177)
8	App\Entity\KitType->getCategory (line 1637)
9	twig_get_attribute (line 82)
10	__TwigTemplate_ff9c6b72b986a92352acae4e128c79df->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 379)
13	Twig\Template->render (line 40)
14	Twig\TemplateWrapper->render (line 280)
15	Twig\Environment->render (line 243)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 1310)
18	App\Controller\DefaultController->printEtiquettesKitAction (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.49 ms
(22.05%)

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

Parameters:

[
  20
]

View formatted query View runnable query Explain query View query backtrace

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

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM kit_category t0 WHERE t0.id = 20;

#	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\KitCategory->__get (line 36)
8	App\Entity\KitCategory->getLibelle (line 1637)
9	twig_get_attribute (line 82)
10	__TwigTemplate_ff9c6b72b986a92352acae4e128c79df->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 379)
13	Twig\Template->render (line 40)
14	Twig\TemplateWrapper->render (line 280)
15	Twig\Environment->render (line 243)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 1310)
18	App\Controller\DefaultController->printEtiquettesKitAction (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.47 ms
(21.25%)

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:

[
  4
]

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 = 4;

#	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)

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\Kit	No errors.
App\Entity\KitType	No errors.
App\Entity\KitStatut	No errors.
App\Entity\Commande	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.

Symfony Profiler

GET https://lims.kudzuscience.com/operateur/print/etiquettes/kit/2403

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping