Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

2.68 ms Query time

21 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.99 ms
(37.04%)

SELECT t0.id AS id_1, t0.denomination AS denomination_2, t0.sigle AS sigle_3, t0.statut AS statut_4, t0.nature AS nature_5, t0.raison_sociale AS raison_sociale_6, t0.regime_fiscal AS regime_fiscal_7, t0.siege AS siege_8, t0.annee_fermeture AS annee_fermeture_9, t0.nombre_surccursale AS nombre_surccursale_10, t0.code_unique AS code_unique_11, t0.rccm AS rccm_12, t0.id_nationnal AS id_nationnal_13, t0.num_ident_fiscal AS num_ident_fiscal_14, t0.num_import_export AS num_import_export_15, t0.num_affactation_inss AS num_affactation_inss_16, t0.num_affectation_inpp AS num_affectation_inpp_17, t0.num_compte_bancaire_interne AS num_compte_bancaire_interne_18, t0.num_compte_bancaire_etranger AS num_compte_bancaire_etranger_19, t0.capital_social AS capital_social_20, t0.num_tva AS num_tva_21, t0.num_dgda AS num_dgda_22, t0.num_dgi AS num_dgi_23, t0.num_dgrad AS num_dgrad_24, t0.num_occ AS num_occ_25, t0.boite_postal AS boite_postal_26, t0.fax AS fax_27, t0.telephone AS telephone_28, t0.site_web AS site_web_29, t0.email AS email_30, t0.fichier AS fichier_31, t0.nom_original AS nom_original_32, t0.description AS description_33, t0.anne_creation AS anne_creation_34, t0.code_operateur AS code_operateur_35, t0.code_indentification AS code_indentification_36, t0.date_creation AS date_creation_37, t0.service AS service_38, t0.part_etat AS part_etat_39, t0.devise AS devise_40, t0.logo AS logo_41, t0.token AS token_42, t0.domaine AS domaine_43, t0.id_dw AS id_dw_44, t0.created_at AS created_at_45, t0.updated_at AS updated_at_46, t0.deleted_at AS deleted_at_47, t0.categorie_id AS categorie_id_48, t0.forme_juridique_id AS forme_juridique_id_49, t0.ville_id AS ville_id_50, t0.sous_secteur_id AS sous_secteur_id_51, t0.province_id AS province_id_52, t0.user_id AS user_id_53 FROM operateur t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.denomination AS denomination_2,
  t0.sigle AS sigle_3,
  t0.statut AS statut_4,
  t0.nature AS nature_5,
  t0.raison_sociale AS raison_sociale_6,
  t0.regime_fiscal AS regime_fiscal_7,
  t0.siege AS siege_8,
  t0.annee_fermeture AS annee_fermeture_9,
  t0.nombre_surccursale AS nombre_surccursale_10,
  t0.code_unique AS code_unique_11,
  t0.rccm AS rccm_12,
  t0.id_nationnal AS id_nationnal_13,
  t0.num_ident_fiscal AS num_ident_fiscal_14,
  t0.num_import_export AS num_import_export_15,
  t0.num_affactation_inss AS num_affactation_inss_16,
  t0.num_affectation_inpp AS num_affectation_inpp_17,
  t0.num_compte_bancaire_interne AS num_compte_bancaire_interne_18,
  t0.num_compte_bancaire_etranger AS num_compte_bancaire_etranger_19,
  t0.capital_social AS capital_social_20,
  t0.num_tva AS num_tva_21,
  t0.num_dgda AS num_dgda_22,
  t0.num_dgi AS num_dgi_23,
  t0.num_dgrad AS num_dgrad_24,
  t0.num_occ AS num_occ_25,
  t0.boite_postal AS boite_postal_26,
  t0.fax AS fax_27,
  t0.telephone AS telephone_28,
  t0.site_web AS site_web_29,
  t0.email AS email_30,
  t0.fichier AS fichier_31,
  t0.nom_original AS nom_original_32,
  t0.description AS description_33,
  t0.anne_creation AS anne_creation_34,
  t0.code_operateur AS code_operateur_35,
  t0.code_indentification AS code_indentification_36,
  t0.date_creation AS date_creation_37,
  t0.service AS service_38,
  t0.part_etat AS part_etat_39,
  t0.devise AS devise_40,
  t0.logo AS logo_41,
  t0.token AS token_42,
  t0.domaine AS domaine_43,
  t0.id_dw AS id_dw_44,
  t0.created_at AS created_at_45,
  t0.updated_at AS updated_at_46,
  t0.deleted_at AS deleted_at_47,
  t0.categorie_id AS categorie_id_48,
  t0.forme_juridique_id AS forme_juridique_id_49,
  t0.ville_id AS ville_id_50,
  t0.sous_secteur_id AS sous_secteur_id_51,
  t0.province_id AS province_id_52,
  t0.user_id AS user_id_53
FROM
  operateur t0

SELECT t0.id AS id_1, t0.denomination AS denomination_2, t0.sigle AS sigle_3, t0.statut AS statut_4, t0.nature AS nature_5, t0.raison_sociale AS raison_sociale_6, t0.regime_fiscal AS regime_fiscal_7, t0.siege AS siege_8, t0.annee_fermeture AS annee_fermeture_9, t0.nombre_surccursale AS nombre_surccursale_10, t0.code_unique AS code_unique_11, t0.rccm AS rccm_12, t0.id_nationnal AS id_nationnal_13, t0.num_ident_fiscal AS num_ident_fiscal_14, t0.num_import_export AS num_import_export_15, t0.num_affactation_inss AS num_affactation_inss_16, t0.num_affectation_inpp AS num_affectation_inpp_17, t0.num_compte_bancaire_interne AS num_compte_bancaire_interne_18, t0.num_compte_bancaire_etranger AS num_compte_bancaire_etranger_19, t0.capital_social AS capital_social_20, t0.num_tva AS num_tva_21, t0.num_dgda AS num_dgda_22, t0.num_dgi AS num_dgi_23, t0.num_dgrad AS num_dgrad_24, t0.num_occ AS num_occ_25, t0.boite_postal AS boite_postal_26, t0.fax AS fax_27, t0.telephone AS telephone_28, t0.site_web AS site_web_29, t0.email AS email_30, t0.fichier AS fichier_31, t0.nom_original AS nom_original_32, t0.description AS description_33, t0.anne_creation AS anne_creation_34, t0.code_operateur AS code_operateur_35, t0.code_indentification AS code_indentification_36, t0.date_creation AS date_creation_37, t0.service AS service_38, t0.part_etat AS part_etat_39, t0.devise AS devise_40, t0.logo AS logo_41, t0.token AS token_42, t0.domaine AS domaine_43, t0.id_dw AS id_dw_44, t0.created_at AS created_at_45, t0.updated_at AS updated_at_46, t0.deleted_at AS deleted_at_47, t0.categorie_id AS categorie_id_48, t0.forme_juridique_id AS forme_juridique_id_49, t0.ville_id AS ville_id_50, t0.sous_secteur_id AS sous_secteur_id_51, t0.province_id AS province_id_52, t0.user_id AS user_id_53 FROM operateur t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 17)
5	App\Controller\QuiSommeNousController->index (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.47 ms
(17.67%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.id_dw AS id_dw_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.secteur_id AS secteur_id_8, t0.user_id AS user_id_9 FROM sous_secteur t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.code AS code_3,
  t0.id_dw AS id_dw_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.deleted_at AS deleted_at_7,
  t0.secteur_id AS secteur_id_8,
  t0.user_id AS user_id_9
FROM
  sous_secteur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.id_dw AS id_dw_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.secteur_id AS secteur_id_8, t0.user_id AS user_id_9 FROM sous_secteur 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 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Operateur\SousSecteur::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 176)
7	Proxies\__CG__\App\Entity\Operateur\SousSecteur->__get (line 61)
8	App\Entity\Operateur\SousSecteur->getSecteur (line 1635)
9	twig_get_attribute (line 142)
10	__TwigTemplate_ea5f91dcf2743342dbb61df44dfcb843->block_body (line 171)
11	Twig\Template->displayBlock (line 86)
12	__TwigTemplate_725b5741f0b67fc58b12bd5e2e9d30fe->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 50)
15	__TwigTemplate_f5d6cbd903fe872e7e4e3395be2eb55e->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 49)
18	__TwigTemplate_ea5f91dcf2743342dbb61df44dfcb843->doDisplay (line 394)
19	Twig\Template->displayWithErrorHandling (line 367)
20	Twig\Template->display (line 379)
21	Twig\Template->render (line 38)
22	Twig\TemplateWrapper->render (line 280)
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 17)
27	App\Controller\QuiSommeNousController->index (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)

0.40 ms
(14.72%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.color AS color_3, t0.unite AS unite_4, t0.symbole_chimique AS symbole_chimique_5, t0.max AS max_6, t0.maxim AS maxim_7, t0.amount AS amount_8, t0.min_annuel AS min_annuel_9, t0.max_annuel AS max_annuel_10, t0.amout_annuel AS amout_annuel_11, t0.max_semestre AS max_semestre_12, t0.amount_semestre AS amount_semestre_13, t0.min_trimestre AS min_trimestre_14, t0.max_trimestre AS max_trimestre_15, t0.amount_trimestre AS amount_trimestre_16, t0.min_semetre AS min_semetre_17, t0.id_dw AS id_dw_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.deleted_at AS deleted_at_21, t0.filiere_id AS filiere_id_22, t0.user_id AS user_id_23 FROM commodite t0 INNER JOIN operateur_commodite ON t0.id = operateur_commodite.commodite_id WHERE operateur_commodite.operateur_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.color AS color_3,
  t0.unite AS unite_4,
  t0.symbole_chimique AS symbole_chimique_5,
  t0.max AS max_6,
  t0.maxim AS maxim_7,
  t0.amount AS amount_8,
  t0.min_annuel AS min_annuel_9,
  t0.max_annuel AS max_annuel_10,
  t0.amout_annuel AS amout_annuel_11,
  t0.max_semestre AS max_semestre_12,
  t0.amount_semestre AS amount_semestre_13,
  t0.min_trimestre AS min_trimestre_14,
  t0.max_trimestre AS max_trimestre_15,
  t0.amount_trimestre AS amount_trimestre_16,
  t0.min_semetre AS min_semetre_17,
  t0.id_dw AS id_dw_18,
  t0.created_at AS created_at_19,
  t0.updated_at AS updated_at_20,
  t0.deleted_at AS deleted_at_21,
  t0.filiere_id AS filiere_id_22,
  t0.user_id AS user_id_23
FROM
  commodite t0
  INNER JOIN operateur_commodite ON t0.id = operateur_commodite.commodite_id
WHERE
  operateur_commodite.operateur_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.color AS color_3, t0.unite AS unite_4, t0.symbole_chimique AS symbole_chimique_5, t0.max AS max_6, t0.maxim AS maxim_7, t0.amount AS amount_8, t0.min_annuel AS min_annuel_9, t0.max_annuel AS max_annuel_10, t0.amout_annuel AS amout_annuel_11, t0.max_semestre AS max_semestre_12, t0.amount_semestre AS amount_semestre_13, t0.min_trimestre AS min_trimestre_14, t0.max_trimestre AS max_trimestre_15, t0.amount_trimestre AS amount_trimestre_16, t0.min_semetre AS min_semetre_17, t0.id_dw AS id_dw_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.deleted_at AS deleted_at_21, t0.filiere_id AS filiere_id_22, t0.user_id AS user_id_23 FROM commodite t0 INNER JOIN operateur_commodite ON t0.id = operateur_commodite.commodite_id WHERE operateur_commodite.operateur_id = 1;

#	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 3228)
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 1476)
10	twig_get_attribute (line 160)
11	__TwigTemplate_ea5f91dcf2743342dbb61df44dfcb843->block_body (line 171)
12	Twig\Template->displayBlock (line 86)
13	__TwigTemplate_725b5741f0b67fc58b12bd5e2e9d30fe->doDisplay (line 394)
14	Twig\Template->displayWithErrorHandling (line 367)
15	Twig\Template->display (line 50)
16	__TwigTemplate_f5d6cbd903fe872e7e4e3395be2eb55e->doDisplay (line 394)
17	Twig\Template->displayWithErrorHandling (line 367)
18	Twig\Template->display (line 49)
19	__TwigTemplate_ea5f91dcf2743342dbb61df44dfcb843->doDisplay (line 394)
20	Twig\Template->displayWithErrorHandling (line 367)
21	Twig\Template->display (line 379)
22	Twig\Template->render (line 38)
23	Twig\TemplateWrapper->render (line 280)
24	Twig\Environment->render (line 448)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 17)
28	App\Controller\QuiSommeNousController->index (line 181)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

0.28 ms
(10.32%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.unite AS unite_4, t0.id_dw AS id_dw_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.user_id AS user_id_9 FROM filiere 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.code AS code_3,
  t0.unite AS unite_4,
  t0.id_dw AS id_dw_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.deleted_at AS deleted_at_8,
  t0.user_id AS user_id_9
FROM
  filiere t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.unite AS unite_4, t0.id_dw AS id_dw_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.user_id AS user_id_9 FROM filiere 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 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Operateur\Filiere::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 176)
7	Proxies\__CG__\App\Entity\Operateur\Filiere->__get (line 50)
8	App\Entity\Operateur\Filiere->getNom (line 1635)
9	twig_get_attribute (line 163)
10	__TwigTemplate_ea5f91dcf2743342dbb61df44dfcb843->block_body (line 171)
11	Twig\Template->displayBlock (line 86)
12	__TwigTemplate_725b5741f0b67fc58b12bd5e2e9d30fe->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 50)
15	__TwigTemplate_f5d6cbd903fe872e7e4e3395be2eb55e->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 49)
18	__TwigTemplate_ea5f91dcf2743342dbb61df44dfcb843->doDisplay (line 394)
19	Twig\Template->displayWithErrorHandling (line 367)
20	Twig\Template->display (line 379)
21	Twig\Template->render (line 38)
22	Twig\TemplateWrapper->render (line 280)
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 17)
27	App\Controller\QuiSommeNousController->index (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)

0.27 ms
(10.21%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.id_dw AS id_dw_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.user_id AS user_id_8 FROM secteur t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.code AS code_3,
  t0.id_dw AS id_dw_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.deleted_at AS deleted_at_7,
  t0.user_id AS user_id_8
FROM
  secteur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.id_dw AS id_dw_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.user_id AS user_id_8 FROM secteur 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 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Operateur\Secteur::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 176)
7	Proxies\__CG__\App\Entity\Operateur\Secteur->__get (line 46)
8	App\Entity\Operateur\Secteur->getNom (line 1635)
9	twig_get_attribute (line 142)
10	__TwigTemplate_ea5f91dcf2743342dbb61df44dfcb843->block_body (line 171)
11	Twig\Template->displayBlock (line 86)
12	__TwigTemplate_725b5741f0b67fc58b12bd5e2e9d30fe->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 50)
15	__TwigTemplate_f5d6cbd903fe872e7e4e3395be2eb55e->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 49)
18	__TwigTemplate_ea5f91dcf2743342dbb61df44dfcb843->doDisplay (line 394)
19	Twig\Template->displayWithErrorHandling (line 367)
20	Twig\Template->display (line 379)
21	Twig\Template->render (line 38)
22	Twig\TemplateWrapper->render (line 280)
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 17)
27	App\Controller\QuiSommeNousController->index (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)

0.27 ms
(10.03%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.id_dw AS id_dw_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.user_id AS user_id_8 FROM categorie t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.code AS code_3,
  t0.id_dw AS id_dw_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.deleted_at AS deleted_at_7,
  t0.user_id AS user_id_8
FROM
  categorie t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.id_dw AS id_dw_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.user_id AS user_id_8 FROM categorie 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 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Operateur\Categorie::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 176)
7	Proxies\__CG__\App\Entity\Operateur\Categorie->__get (line 47)
8	App\Entity\Operateur\Categorie->getNom (line 1635)
9	twig_get_attribute (line 256)
10	__TwigTemplate_ea5f91dcf2743342dbb61df44dfcb843->block_body (line 171)
11	Twig\Template->displayBlock (line 86)
12	__TwigTemplate_725b5741f0b67fc58b12bd5e2e9d30fe->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 50)
15	__TwigTemplate_f5d6cbd903fe872e7e4e3395be2eb55e->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 49)
18	__TwigTemplate_ea5f91dcf2743342dbb61df44dfcb843->doDisplay (line 394)
19	Twig\Template->displayWithErrorHandling (line 367)
20	Twig\Template->display (line 379)
21	Twig\Template->render (line 38)
22	Twig\TemplateWrapper->render (line 280)
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 17)
27	App\Controller\QuiSommeNousController->index (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.

Entities Mapping

Class	Mapping errors
App\Entity\Operateur\Operateur	The association App\Entity\Operateur\Operateur#commodites refers to the inverse side field App\Entity\Transparence\Commodite#operateurs which does not exist. The association App\Entity\Operateur\Operateur#province refers to the inverse side field App\Entity\Transparence\Province#operateurs which does not exist. The field App\Entity\Operateur\Operateur#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Operateur\Operateur#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Operateur\Categorie	The field App\Entity\Operateur\Categorie#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Operateur\Categorie#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Operateur\FormeJuridique	The field App\Entity\Operateur\FormeJuridique#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Operateur\FormeJuridique#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Operateur\Ville	The association App\Entity\Operateur\Ville#province refers to the inverse side field App\Entity\Transparence\Province#villes which does not exist. The field App\Entity\Operateur\Ville#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Operateur\Ville#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Operateur\SousSecteur	The field App\Entity\Operateur\SousSecteur#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Operateur\SousSecteur#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Transparence\Province	The field App\Entity\Transparence\Province#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Transparence\Province#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\User	The field App\Entity\User#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\User#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Obligation\InformationFinanciere	The field App\Entity\Obligation\InformationFinanciere#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Obligation\InformationFinanciere#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Transparence\Commodite	The field App\Entity\Transparence\Commodite#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Transparence\Commodite#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Operateur\SiegeExploitation	The field App\Entity\Operateur\SiegeExploitation#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Operateur\SiegeExploitation#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Operateur\Secteur	The field App\Entity\Operateur\Secteur#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Operateur\Secteur#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Operateur\Filiere	The field App\Entity\Operateur\Filiere#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Operateur\Filiere#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Production\Production	The field App\Entity\Production\Production#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Production\Production#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Production\Exportation	The field 'App\Entity\Production\Exportation#quantite' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The association App\Entity\Production\Exportation#pays refers to the inverse side field App\Entity\Transparence\Pays#exportations which does not exist. The field App\Entity\Production\Exportation#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Production\Exportation#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Production\VenteLocal	The field 'App\Entity\Production\VenteLocal#quantite' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field App\Entity\Production\VenteLocal#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Production\VenteLocal#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Transparence\ContratPrincipal	The field App\Entity\Transparence\ContratPrincipal#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Transparence\ContratPrincipal#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Transparence\ContratRelatif	The field App\Entity\Transparence\ContratRelatif#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Transparence\ContratRelatif#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Activite\Ressource	The field App\Entity\Activite\Ressource#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Activite\Ressource#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Activite\Reserve	The field App\Entity\Activite\Reserve#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Activite\Reserve#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Autres\TeneurCommodite	The field App\Entity\Autres\TeneurCommodite#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Autres\TeneurCommodite#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Activite\Projet	The field App\Entity\Activite\Projet#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Activite\Projet#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.

Symfony Profiler

GET https://dot.cd/qui/somme/nous

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping