Symfony Profiler

Query Metrics

18 Database Queries

12 Different statements

32.48 ms Query time

18 Invalid entities

32 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

18.09 ms
(55.70%)

SELECT t0.id AS id_1, t0.nom_devise AS nom_devise_2 FROM devise 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_devise AS nom_devise_2
FROM
  devise t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom_devise AS nom_devise_2 FROM devise t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 369)
4	Proxies\__CG__\App\Entity\Devise::Doctrine\ORM\Proxy\{closure} (line 479)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\App\Entity\Devise->__get (line 184)
7	App\Entity\Devise->getNomDevise (line 112)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_91ed4a6aa953d92b7919637b179e4d07::block_produits (line 451)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_970bfcf6ac0bbed7f56984515357a965->block_main (line 442)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_970bfcf6ac0bbed7f56984515357a965->block_body (line 196)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_970bfcf6ac0bbed7f56984515357a965->doDisplay (line 91)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_91ed4a6aa953d92b7919637b179e4d07->doDisplay (line 67)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
26	App\Controller\Logescom\Vente\FacturationController->show (line 1186)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 208)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	require_once (line 5)

7.86 ms
(24.19%)

SELECT t0.id AS id_1, t0.designation AS designation_2, t0.type AS type_3, t0.numero_compte AS numero_compte_4, t0.document AS document_5, t0.point_de_vente_id AS point_de_vente_id_6 FROM caisse t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.designation AS designation_2,
  t0.type AS type_3,
  t0.numero_compte AS numero_compte_4,
  t0.document AS document_5,
  t0.point_de_vente_id AS point_de_vente_id_6
FROM
  caisse t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.designation AS designation_2, t0.type AS type_3, t0.numero_compte AS numero_compte_4, t0.document AS document_5, t0.point_de_vente_id AS point_de_vente_id_6 FROM caisse t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 369)
4	Proxies\__CG__\App\Entity\Caisse::Doctrine\ORM\Proxy\{closure} (line 479)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\App\Entity\Caisse->__get (line 184)
7	App\Entity\Caisse->getDesignation (line 120)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_91ed4a6aa953d92b7919637b179e4d07::block_produits (line 434)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_970bfcf6ac0bbed7f56984515357a965->block_main (line 442)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_970bfcf6ac0bbed7f56984515357a965->block_body (line 196)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_970bfcf6ac0bbed7f56984515357a965->doDisplay (line 91)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_91ed4a6aa953d92b7919637b179e4d07->doDisplay (line 67)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
26	App\Controller\Logescom\Vente\FacturationController->show (line 1186)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 208)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	require_once (line 5)

2.36 ms
(7.28%)

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.designation AS designation_3, t0.prix_vente AS prix_vente_4, t0.code_barre AS code_barre_5, t0.nbre_piece AS nbre_piece_6, t0.nbre_paquet AS nbre_paquet_7, t0.type_produit AS type_produit_8, t0.nbre_vente AS nbre_vente_9, t0.statut AS statut_10, t0.statut_comptable AS statut_comptable_11, t0.tva AS tva_12, t0.categorie_id AS categorie_id_13, t0.epaisseur_id AS epaisseur_id_14, t0.dimension_id AS dimension_id_15, t0.origine_id AS origine_id_16, t0.type_id AS type_id_17 FROM products t0 WHERE t0.id = ?

Parameters:

[
  91
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.designation AS designation_3,
  t0.prix_vente AS prix_vente_4,
  t0.code_barre AS code_barre_5,
  t0.nbre_piece AS nbre_piece_6,
  t0.nbre_paquet AS nbre_paquet_7,
  t0.type_produit AS type_produit_8,
  t0.nbre_vente AS nbre_vente_9,
  t0.statut AS statut_10,
  t0.statut_comptable AS statut_comptable_11,
  t0.tva AS tva_12,
  t0.categorie_id AS categorie_id_13,
  t0.epaisseur_id AS epaisseur_id_14,
  t0.dimension_id AS dimension_id_15,
  t0.origine_id AS origine_id_16,
  t0.type_id AS type_id_17
FROM
  products t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.designation AS designation_3, t0.prix_vente AS prix_vente_4, t0.code_barre AS code_barre_5, t0.nbre_piece AS nbre_piece_6, t0.nbre_paquet AS nbre_paquet_7, t0.type_produit AS type_produit_8, t0.nbre_vente AS nbre_vente_9, t0.statut AS statut_10, t0.statut_comptable AS statut_comptable_11, t0.tva AS tva_12, t0.categorie_id AS categorie_id_13, t0.epaisseur_id AS epaisseur_id_14, t0.dimension_id AS dimension_id_15, t0.origine_id AS origine_id_16, t0.type_id AS type_id_17 FROM products t0 WHERE t0.id = 91;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 369)
4	Proxies\__CG__\App\Entity\Products::Doctrine\ORM\Proxy\{closure} (line 479)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\App\Entity\Products->__get (line 184)
7	App\Entity\Products->getDesignation (line 162)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_91ed4a6aa953d92b7919637b179e4d07::block_produits (line 535)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_970bfcf6ac0bbed7f56984515357a965->block_main (line 442)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_970bfcf6ac0bbed7f56984515357a965->block_body (line 196)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_970bfcf6ac0bbed7f56984515357a965->doDisplay (line 91)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_91ed4a6aa953d92b7919637b179e4d07->doDisplay (line 67)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
26	App\Controller\Logescom\Vente\FacturationController->show (line 1186)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 208)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	require_once (line 5)

1.77 ms
(5.46%)

SELECT t0.id AS id_1, t0.prix_vente AS prix_vente_2, t0.prix_revient AS prix_revient_3, t0.prix_achat AS prix_achat_4, t0.quantite AS quantite_5, t0.quantite_livre AS quantite_livre_6, t0.remise AS remise_7, t0.tva AS tva_8, t0.facturation_id AS facturation_id_9, t0.product_id AS product_id_10 FROM commande_product t0 WHERE t0.facturation_id = ? ORDER BY t0.product_id ASC

Parameters:

[
  619
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.prix_vente AS prix_vente_2,
  t0.prix_revient AS prix_revient_3,
  t0.prix_achat AS prix_achat_4,
  t0.quantite AS quantite_5,
  t0.quantite_livre AS quantite_livre_6,
  t0.remise AS remise_7,
  t0.tva AS tva_8,
  t0.facturation_id AS facturation_id_9,
  t0.product_id AS product_id_10
FROM
  commande_product t0
WHERE
  t0.facturation_id = ?
ORDER BY
  t0.product_id ASC

SELECT t0.id AS id_1, t0.prix_vente AS prix_vente_2, t0.prix_revient AS prix_revient_3, t0.prix_achat AS prix_achat_4, t0.quantite AS quantite_5, t0.quantite_livre AS quantite_livre_6, t0.remise AS remise_7, t0.tva AS tva_8, t0.facturation_id AS facturation_id_9, t0.product_id AS product_id_10 FROM commande_product t0 WHERE t0.facturation_id = 619 ORDER BY t0.product_id ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 995)
2	Doctrine\ORM\EntityRepository->findBy (line 224)
3	App\Controller\Logescom\Vente\FacturationController->show (line 1190)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 208)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 29)
9	require_once (line 5)

0.41 ms
(1.26%)

SELECT t0.id AS id_1, t0.type_mouvement AS type_mouvement_2, t0.montant AS montant_3, t0.date_operation AS date_operation_4, t0.date_saisie AS date_saisie_5, t0.numero_paie AS numero_paie_6, t0.banque_cheque AS banque_cheque_7, t0.taux AS taux_8, t0.etat_operation AS etat_operation_9, t0.date_sortie AS date_sortie_10, t0.type_sortie AS type_sortie_11, t0.detail_sortie AS detail_sortie_12, t0.lieu_vente_id AS lieu_vente_id_13, t0.caisse_id AS caisse_id_14, t0.categorie_operation_id AS categorie_operation_id_15, t0.compte_operation_id AS compte_operation_id_16, t0.devise_id AS devise_id_17, t0.decaissement_id AS decaissement_id_18, t0.avance_salaire_id AS avance_salaire_id_19, t0.paiement_salaire_id AS paiement_salaire_id_20, t0.depense_id AS depense_id_21, t0.versement_id AS versement_id_22, t0.transfert_fond_id AS transfert_fond_id_23, t0.cheque_espece_id AS cheque_espece_id_24, t0.recette_id AS recette_id_25, t0.facturation_id AS facturation_id_26, t0.mode_paie_id AS mode_paie_id_27, t0.retour_product_id AS retour_product_id_28, t0.echange_id AS echange_id_29, t0.saisie_par_id AS saisie_par_id_30, t0.cloture_id AS cloture_id_31, t0.sortie_stock_id AS sortie_stock_id_32 FROM mouvement_caisse t0 WHERE t0.facturation_id = ?

Parameters:

[
  619
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type_mouvement AS type_mouvement_2,
  t0.montant AS montant_3,
  t0.date_operation AS date_operation_4,
  t0.date_saisie AS date_saisie_5,
  t0.numero_paie AS numero_paie_6,
  t0.banque_cheque AS banque_cheque_7,
  t0.taux AS taux_8,
  t0.etat_operation AS etat_operation_9,
  t0.date_sortie AS date_sortie_10,
  t0.type_sortie AS type_sortie_11,
  t0.detail_sortie AS detail_sortie_12,
  t0.lieu_vente_id AS lieu_vente_id_13,
  t0.caisse_id AS caisse_id_14,
  t0.categorie_operation_id AS categorie_operation_id_15,
  t0.compte_operation_id AS compte_operation_id_16,
  t0.devise_id AS devise_id_17,
  t0.decaissement_id AS decaissement_id_18,
  t0.avance_salaire_id AS avance_salaire_id_19,
  t0.paiement_salaire_id AS paiement_salaire_id_20,
  t0.depense_id AS depense_id_21,
  t0.versement_id AS versement_id_22,
  t0.transfert_fond_id AS transfert_fond_id_23,
  t0.cheque_espece_id AS cheque_espece_id_24,
  t0.recette_id AS recette_id_25,
  t0.facturation_id AS facturation_id_26,
  t0.mode_paie_id AS mode_paie_id_27,
  t0.retour_product_id AS retour_product_id_28,
  t0.echange_id AS echange_id_29,
  t0.saisie_par_id AS saisie_par_id_30,
  t0.cloture_id AS cloture_id_31,
  t0.sortie_stock_id AS sortie_stock_id_32
FROM
  mouvement_caisse t0
WHERE
  t0.facturation_id = ?

SELECT t0.id AS id_1, t0.type_mouvement AS type_mouvement_2, t0.montant AS montant_3, t0.date_operation AS date_operation_4, t0.date_saisie AS date_saisie_5, t0.numero_paie AS numero_paie_6, t0.banque_cheque AS banque_cheque_7, t0.taux AS taux_8, t0.etat_operation AS etat_operation_9, t0.date_sortie AS date_sortie_10, t0.type_sortie AS type_sortie_11, t0.detail_sortie AS detail_sortie_12, t0.lieu_vente_id AS lieu_vente_id_13, t0.caisse_id AS caisse_id_14, t0.categorie_operation_id AS categorie_operation_id_15, t0.compte_operation_id AS compte_operation_id_16, t0.devise_id AS devise_id_17, t0.decaissement_id AS decaissement_id_18, t0.avance_salaire_id AS avance_salaire_id_19, t0.paiement_salaire_id AS paiement_salaire_id_20, t0.depense_id AS depense_id_21, t0.versement_id AS versement_id_22, t0.transfert_fond_id AS transfert_fond_id_23, t0.cheque_espece_id AS cheque_espece_id_24, t0.recette_id AS recette_id_25, t0.facturation_id AS facturation_id_26, t0.mode_paie_id AS mode_paie_id_27, t0.retour_product_id AS retour_product_id_28, t0.echange_id AS echange_id_29, t0.saisie_par_id AS saisie_par_id_30, t0.cloture_id AS cloture_id_31, t0.sortie_stock_id AS sortie_stock_id_32 FROM mouvement_caisse t0 WHERE t0.facturation_id = 619;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 995)
2	Doctrine\ORM\EntityRepository->findBy (line 224)
3	App\Controller\Logescom\Vente\FacturationController->show (line 1191)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 208)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 29)
9	require_once (line 5)

0.39 ms
(1.21%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.telephone AS telephone_7, t0.email AS email_8, t0.type_user AS type_user_9, t0.date_creation AS date_creation_10, t0.adresse AS adresse_11, t0.ville AS ville_12, t0.pays AS pays_13, t0.statut AS statut_14, t0.reference AS reference_15, t0.lieu_vente_id AS lieu_vente_id_16, t0.region_id AS region_id_17 FROM user t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.nom AS nom_5,
  t0.prenom AS prenom_6,
  t0.telephone AS telephone_7,
  t0.email AS email_8,
  t0.type_user AS type_user_9,
  t0.date_creation AS date_creation_10,
  t0.adresse AS adresse_11,
  t0.ville AS ville_12,
  t0.pays AS pays_13,
  t0.statut AS statut_14,
  t0.reference AS reference_15,
  t0.lieu_vente_id AS lieu_vente_id_16,
  t0.region_id AS region_id_17
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.telephone AS telephone_7, t0.email AS email_8, t0.type_user AS type_user_9, t0.date_creation AS date_creation_10, t0.adresse AS adresse_11, t0.ville AS ville_12, t0.pays AS pays_13, t0.statut AS statut_14, t0.reference AS reference_15, t0.lieu_vente_id AS lieu_vente_id_16, t0.region_id AS region_id_17 FROM user t0 WHERE t0.id = 1;

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

0.30 ms
(0.91%)

SELECT t0.id AS id_1, t0.numero_facture AS numero_facture_2, t0.total_facture AS total_facture_3, t0.montant_paye AS montant_paye_4, t0.montant_remise AS montant_remise_5, t0.etat AS etat_6, t0.etat_livraison AS etat_livraison_7, t0.date_facturation AS date_facturation_8, t0.date_saisie AS date_saisie_9, t0.date_alerte AS date_alerte_10, t0.commentaire AS commentaire_11, t0.nom_client_cash AS nom_client_cash_12, t0.frais_sup AS frais_sup_13, t0.taux AS taux_14, t0.client_id AS client_id_15, t0.caisse_id AS caisse_id_16, t0.lieu_vente_id AS lieu_vente_id_17, t0.saisie_par_id AS saisie_par_id_18, t0.mode_paie_id AS mode_paie_id_19, t0.proformat_id AS proformat_id_20, t0.devise_id AS devise_id_21 FROM facturation t0 WHERE t0.id = ?

Parameters:

[
  "619"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.numero_facture AS numero_facture_2,
  t0.total_facture AS total_facture_3,
  t0.montant_paye AS montant_paye_4,
  t0.montant_remise AS montant_remise_5,
  t0.etat AS etat_6,
  t0.etat_livraison AS etat_livraison_7,
  t0.date_facturation AS date_facturation_8,
  t0.date_saisie AS date_saisie_9,
  t0.date_alerte AS date_alerte_10,
  t0.commentaire AS commentaire_11,
  t0.nom_client_cash AS nom_client_cash_12,
  t0.frais_sup AS frais_sup_13,
  t0.taux AS taux_14,
  t0.client_id AS client_id_15,
  t0.caisse_id AS caisse_id_16,
  t0.lieu_vente_id AS lieu_vente_id_17,
  t0.saisie_par_id AS saisie_par_id_18,
  t0.mode_paie_id AS mode_paie_id_19,
  t0.proformat_id AS proformat_id_20,
  t0.devise_id AS devise_id_21
FROM
  facturation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.numero_facture AS numero_facture_2, t0.total_facture AS total_facture_3, t0.montant_paye AS montant_paye_4, t0.montant_remise AS montant_remise_5, t0.etat AS etat_6, t0.etat_livraison AS etat_livraison_7, t0.date_facturation AS date_facturation_8, t0.date_saisie AS date_saisie_9, t0.date_alerte AS date_alerte_10, t0.commentaire AS commentaire_11, t0.nom_client_cash AS nom_client_cash_12, t0.frais_sup AS frais_sup_13, t0.taux AS taux_14, t0.client_id AS client_id_15, t0.caisse_id AS caisse_id_16, t0.lieu_vente_id AS lieu_vente_id_17, t0.saisie_par_id AS saisie_par_id_18, t0.mode_paie_id AS mode_paie_id_19, t0.proformat_id AS proformat_id_20, t0.devise_id AS devise_id_21 FROM facturation t0 WHERE t0.id = '619';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\EntityManager->find (line 530)
4	Doctrine\ORM\EntityRepository->find (line 196)
5	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 119)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 63)
7	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 60)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
9	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 40)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 173)
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)

0.29 ms
(0.90%)

SELECT t0.id AS id_1, t0.nom_entreprise AS nom_entreprise_2, t0.identifiant AS identifiant_3, t0.numero_agrement AS numero_agrement_4, t0.adresse AS adresse_5, t0.telephone AS telephone_6, t0.logo AS logo_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9 FROM entreprise 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_entreprise AS nom_entreprise_2,
  t0.identifiant AS identifiant_3,
  t0.numero_agrement AS numero_agrement_4,
  t0.adresse AS adresse_5,
  t0.telephone AS telephone_6,
  t0.logo AS logo_7,
  t0.latitude AS latitude_8,
  t0.longitude AS longitude_9
FROM
  entreprise t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom_entreprise AS nom_entreprise_2, t0.identifiant AS identifiant_3, t0.numero_agrement AS numero_agrement_4, t0.adresse AS adresse_5, t0.telephone AS telephone_6, t0.logo AS logo_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9 FROM entreprise t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\EntityManager->find (line 530)
4	Doctrine\ORM\EntityRepository->find (line 196)
5	App\Controller\Logescom\Vente\FacturationController->show (line 1187)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 208)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

0.28 ms
(0.86%)

SELECT sum(m0_.montant) AS sclr_0, d1_.nom_devise AS nom_devise_1 FROM mouvement_collaborateur m0_ LEFT JOIN devise d1_ ON m0_.devise_id = d1_.id WHERE m0_.collaborateur_id = ? GROUP BY m0_.devise_id

Parameters:

[
  null
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  sum(m0_.montant) AS sclr_0,
  d1_.nom_devise AS nom_devise_1
FROM
  mouvement_collaborateur m0_
  LEFT JOIN devise d1_ ON m0_.devise_id = d1_.id
WHERE
  m0_.collaborateur_id = ?
GROUP BY
  m0_.devise_id

SELECT sum(m0_.montant) AS sclr_0, d1_.nom_devise AS nom_devise_1 FROM mouvement_collaborateur m0_ LEFT JOIN devise d1_ ON m0_.devise_id = d1_.id WHERE m0_.collaborateur_id = NULL GROUP BY m0_.devise_id;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getResult (line 906)
6	App\Repository\MouvementCollaborateurRepository->findSoldeCollaborateur (line 97)
7	App\Controller\Logescom\Vente\FacturationController->show (line 1185)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 208)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.26 ms
(0.79%)

SELECT t0.id AS id_1, t0.montant AS montant_2, t0.facturation_id AS facturation_id_3, t0.frais_sup_id AS frais_sup_id_4, t0.devise_id AS devise_id_5 FROM facture_frais_sup t0 WHERE t0.facturation_id = ?

Parameters:

[
  619
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.montant AS montant_2,
  t0.facturation_id AS facturation_id_3,
  t0.frais_sup_id AS frais_sup_id_4,
  t0.devise_id AS devise_id_5
FROM
  facture_frais_sup t0
WHERE
  t0.facturation_id = ?

SELECT t0.id AS id_1, t0.montant AS montant_2, t0.facturation_id AS facturation_id_3, t0.frais_sup_id AS frais_sup_id_4, t0.devise_id AS devise_id_5 FROM facture_frais_sup t0 WHERE t0.facturation_id = 619;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 995)
2	Doctrine\ORM\EntityRepository->findBy (line 224)
3	App\Controller\Logescom\Vente\FacturationController->show (line 1192)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 208)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 29)
9	require_once (line 5)

0.24 ms
(0.75%)

SELECT t0.id AS id_1, t0.designation AS designation_2 FROM mode_paiement t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.designation AS designation_2
FROM
  mode_paiement t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.designation AS designation_2 FROM mode_paiement t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 369)
4	Proxies\__CG__\App\Entity\ModePaiement::Doctrine\ORM\Proxy\{closure} (line 479)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\App\Entity\ModePaiement->__get (line 184)
7	App\Entity\ModePaiement->getDesignation (line 68)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_91ed4a6aa953d92b7919637b179e4d07::block_produits (line 451)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_970bfcf6ac0bbed7f56984515357a965->block_main (line 442)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_970bfcf6ac0bbed7f56984515357a965->block_body (line 196)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_970bfcf6ac0bbed7f56984515357a965->doDisplay (line 91)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_91ed4a6aa953d92b7919637b179e4d07->doDisplay (line 67)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
26	App\Controller\Logescom\Vente\FacturationController->show (line 1186)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 208)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	require_once (line 5)

0.23 ms
(0.70%)

SELECT t0.id AS id_1, t0.total_facture AS total_facture_2, t0.montant_paye AS montant_paye_3, t0.montant_remise AS montant_remise_4, t0.frais_sup AS frais_sup_5, t0.nom_client_cash AS nom_client_cash_6, t0.etat AS etat_7, t0.etat_livraison AS etat_livraison_8, t0.date_facturation AS date_facturation_9, t0.date_saisie AS date_saisie_10, t0.facture_id AS facture_id_11, t0.caisse_id AS caisse_id_12, t0.lieu_vente_id AS lieu_vente_id_13, t0.saisie_par_id AS saisie_par_id_14, t0.client_id AS client_id_15, t0.mode_paie_id AS mode_paie_id_16 FROM modification_facture t0 WHERE t0.facture_id = ?

Parameters:

[
  619
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.total_facture AS total_facture_2,
  t0.montant_paye AS montant_paye_3,
  t0.montant_remise AS montant_remise_4,
  t0.frais_sup AS frais_sup_5,
  t0.nom_client_cash AS nom_client_cash_6,
  t0.etat AS etat_7,
  t0.etat_livraison AS etat_livraison_8,
  t0.date_facturation AS date_facturation_9,
  t0.date_saisie AS date_saisie_10,
  t0.facture_id AS facture_id_11,
  t0.caisse_id AS caisse_id_12,
  t0.lieu_vente_id AS lieu_vente_id_13,
  t0.saisie_par_id AS saisie_par_id_14,
  t0.client_id AS client_id_15,
  t0.mode_paie_id AS mode_paie_id_16
FROM
  modification_facture t0
WHERE
  t0.facture_id = ?

SELECT t0.id AS id_1, t0.total_facture AS total_facture_2, t0.montant_paye AS montant_paye_3, t0.montant_remise AS montant_remise_4, t0.frais_sup AS frais_sup_5, t0.nom_client_cash AS nom_client_cash_6, t0.etat AS etat_7, t0.etat_livraison AS etat_livraison_8, t0.date_facturation AS date_facturation_9, t0.date_saisie AS date_saisie_10, t0.facture_id AS facture_id_11, t0.caisse_id AS caisse_id_12, t0.lieu_vente_id AS lieu_vente_id_13, t0.saisie_par_id AS saisie_par_id_14, t0.client_id AS client_id_15, t0.mode_paie_id AS mode_paie_id_16 FROM modification_facture t0 WHERE t0.facture_id = 619;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 995)
2	Doctrine\ORM\EntityRepository->findBy (line 224)
3	App\Controller\Logescom\Vente\FacturationController->show (line 1194)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 208)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 29)
9	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\CommandeProduct	7
App\Entity\Products	7
App\Entity\Categorie	6
App\Entity\User	1
App\Entity\LieuxVentes	1
App\Entity\Region	1
App\Entity\Facturation	1
App\Entity\Caisse	1
App\Entity\ModePaiement	1
App\Entity\Entreprise	1
App\Entity\MouvementCaisse	1
App\Entity\CategorieOperation	1
App\Entity\CompteOperation	1
App\Entity\Devise	1
App\Entity\PointDeVente	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\LieuxVentes	No errors.
App\Entity\Region	No errors.
App\Entity\ListeStock	No errors.
App\Entity\Personnel	No errors.
App\Entity\Client	No errors.
App\Entity\ListeInventaire	No errors.
App\Entity\Inventaire	No errors.
App\Entity\MouvementProduct	No errors.
App\Entity\AnomalieProduit	No errors.
App\Entity\ListeTransfertProduct	No errors.
App\Entity\TransfertProducts	The mappings App\Entity\TransfertProducts#traitePar and App\Entity\User#transfertProduct are inconsistent with each other.
App\Entity\AchatFournisseur	No errors.
App\Entity\ListeProductAchatFournisseur	No errors.
App\Entity\Decaissement	No errors.
App\Entity\MouvementCollaborateur	No errors.
App\Entity\BonCommandeFournisseur	No errors.
App\Entity\AbsencesPersonnels	No errors.
App\Entity\PrimesPersonnel	The mappings App\Entity\PrimesPersonnel#saisiePar and App\Entity\User#primesPersonnels are inconsistent with each other.
App\Entity\AvanceSalaire	The association App\Entity\AvanceSalaire#devise refers to the inverse side field App\Entity\Devise#avanceSalaires which does not exist.
App\Entity\PaiementSalairePersonnel	The mappings App\Entity\PaiementSalairePersonnel#saisiePar and App\Entity\User#paiementSalairePersonnels are inconsistent with each other. The association App\Entity\PaiementSalairePersonnel#compteRetrait refers to the inverse side field App\Entity\Caisse#paiementSalairePersonnels which does not exist. The association App\Entity\PaiementSalairePersonnel#typePaiement refers to the inverse side field App\Entity\ModePaiement#paiementSalairePersonnels which does not exist. The association App\Entity\PaiementSalairePersonnel#devise refers to the inverse side field App\Entity\Devise#paiementSalairePersonnels which does not exist.
App\Entity\ModifDecaissement	No errors.
App\Entity\Depenses	No errors.
App\Entity\Versement	No errors.
App\Entity\Modification	The mappings App\Entity\Modification#traitePar and App\Entity\User#modifications are inconsistent with each other.
App\Entity\TransfertFond	The mappings App\Entity\TransfertFond#caisseReception and App\Entity\Caisse#transfertFonds are inconsistent with each other. The mappings App\Entity\TransfertFond#envoyePar and App\Entity\User#transfertFonds are inconsistent with each other.
App\Entity\ChequeEspece	The mappings App\Entity\ChequeEspece#caisseRetrait and App\Entity\Caisse#chequeEspeces are inconsistent with each other. The mappings App\Entity\ChequeEspece#saisiePar and App\Entity\User#chequeEspeces are inconsistent with each other.
App\Entity\Recette	No errors.
App\Entity\AjustementSolde	No errors.
App\Entity\Livraison	No errors.
App\Entity\Facturation	The mappings App\Entity\Facturation#saisiePar and App\Entity\User#facturations are inconsistent with each other.
App\Entity\CommissionVente	No errors.
App\Entity\ModificationFacture	The mappings App\Entity\ModificationFacture#client and App\Entity\User#modificationFactures are inconsistent with each other.
App\Entity\Proformat	The mappings App\Entity\Proformat#saisiePar and App\Entity\User#proformats are inconsistent with each other.
App\Entity\SuppressionFacture	No errors.
App\Entity\RetourProduct	The association App\Entity\RetourProduct#lieuVente refers to the inverse side field App\Entity\LieuxVentes#retourProducts which does not exist.
App\Entity\EchangeDevise	The mappings App\Entity\EchangeDevise#caisseDestination and App\Entity\Caisse#echangeDevises are inconsistent with each other. The mappings App\Entity\EchangeDevise#deviseDestination and App\Entity\Devise#echangeDevises are inconsistent with each other.
App\Entity\MouvementCaisse	No errors.
App\Entity\GestionCheque	The mappings App\Entity\GestionCheque#caisseReception and App\Entity\Caisse#gestionCheques are inconsistent with each other. The mappings App\Entity\GestionCheque#lieuVenteReception and App\Entity\LieuxVentes#gestionCheques are inconsistent with each other. The mappings App\Entity\GestionCheque#envoyePar and App\Entity\User#gestionCheques are inconsistent with each other. The mappings App\Entity\GestionCheque#collaborateur and App\Entity\User#gestionCheques are inconsistent with each other.
App\Entity\ClotureCaisse	No errors.
App\Entity\RetourProductFournisseur	No errors.
App\Entity\FactureFrais	The mappings App\Entity\FactureFrais#personnel and App\Entity\User#factureFrais are inconsistent with each other.
App\Entity\ListeProductAchatFournisseurFrais	No errors.
App\Entity\ListeProductAchatFournisseurMultiple	No errors.
App\Entity\AchatFournisseurGeneral	The mappings App\Entity\AchatFournisseurGeneral#personnel and App\Entity\User#achatFournisseurGenerals are inconsistent with each other.
App\Entity\Promotion	The mappings App\Entity\Promotion#produitBonus and App\Entity\Products#promotions are inconsistent with each other. If association App\Entity\Promotion#produitBonus is many-to-one, then the inversed side App\Entity\Products#promotions has to be one-to-many.
App\Entity\SortieStock	No errors.
App\Entity\ClotureAnnuel	No errors.
App\Entity\HistoriqueChangement	No errors.
App\Entity\Caisse	No errors.
App\Entity\ModePaiement	No errors.
App\Entity\Devise	No errors.
App\Entity\FactureFraisSup	No errors.
App\Entity\CommandeProduct	No errors.
App\Entity\Entreprise	No errors.
App\Entity\Licence	No errors.
App\Entity\Products	The association App\Entity\Products#stocks refers to the owning side field App\Entity\Stock#products which does not exist.
App\Entity\CategorieOperation	No errors.
App\Entity\CompteOperation	No errors.
App\Entity\FraisSup	No errors.
App\Entity\PointDeVente	No errors.
App\Entity\TauxDevise	No errors.
App\Entity\ProformatFraisSup	No errors.
App\Entity\Categorie	No errors.
App\Entity\Epaisseurs	No errors.
App\Entity\Dimensions	No errors.
App\Entity\OrigineProduit	No errors.
App\Entity\TypeProduit	No errors.
App\Entity\Stock	The mappings App\Entity\Stock#product and App\Entity\Products#stocks are inconsistent with each other.
App\Entity\LiaisonProduit	No errors.
App\Entity\ListeProductBonFournisseur	No errors.
App\Entity\ProformatProduct	No errors.

Symfony Profiler

GET https://etselboubacarbalde.damkocompany.com/public/logescom/vente/facturation/show/619/1

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping