Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

1.56 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

1.56 ms

SELECT t0.id AS id_1, t0.date_emission AS date_emission_2, t0.motif_decaissement AS motif_decaissement_3, t0.service AS service_4, t0.montant_total AS montant_total_5, t0.motif_rejet AS motif_rejet_6, t0.statut AS statut_7, t0.is_priority AS is_priority_8, t0.objet AS objet_9, t0.montant_restitue AS montant_restitue_10, t0.date_restitution AS date_restitution_11, t0.statut_restitution AS statut_restitution_12, t0.is_facture_recue AS is_facture_recue_13, t0.chemin_facture AS chemin_facture_14, t0.nom_original_facture AS nom_original_facture_15, t0.date_reception_facture AS date_reception_facture_16, t0.montant_rejet AS montant_rejet_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.deleted_at AS deleted_at_20, t0.created_by AS created_by_21, t0.updated_by AS updated_by_22, t0.chef_service_id AS chef_service_id_23, t0.direction_generale_id AS direction_generale_id_24, t0.rejeter_par_id AS rejeter_par_id_25, t0.receptionnaire_sous_id AS receptionnaire_sous_id_26, t0.depensier_id AS depensier_id_27, t0.receptionnaire_facture_id AS receptionnaire_facture_id_28, t0.demande_id AS demande_id_29, t0.caissiere_id AS caissiere_id_30, t0.user_id AS user_id_31, t0.direction_financiere_id AS direction_financiere_id_32, t0.compte_syscohada_id AS compte_syscohada_id_33, t0.restituteur_id AS restituteur_id_34, t0.objet_bon_id AS objet_bon_id_35 FROM bon t0 WHERE t0.id = ?

Parameters:

[
  "01989998-9aeb-7de1-94fe-2b45013a1632"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date_emission AS date_emission_2,
  t0.motif_decaissement AS motif_decaissement_3,
  t0.service AS service_4,
  t0.montant_total AS montant_total_5,
  t0.motif_rejet AS motif_rejet_6,
  t0.statut AS statut_7,
  t0.is_priority AS is_priority_8,
  t0.objet AS objet_9,
  t0.montant_restitue AS montant_restitue_10,
  t0.date_restitution AS date_restitution_11,
  t0.statut_restitution AS statut_restitution_12,
  t0.is_facture_recue AS is_facture_recue_13,
  t0.chemin_facture AS chemin_facture_14,
  t0.nom_original_facture AS nom_original_facture_15,
  t0.date_reception_facture AS date_reception_facture_16,
  t0.montant_rejet AS montant_rejet_17,
  t0.created_at AS created_at_18,
  t0.updated_at AS updated_at_19,
  t0.deleted_at AS deleted_at_20,
  t0.created_by AS created_by_21,
  t0.updated_by AS updated_by_22,
  t0.chef_service_id AS chef_service_id_23,
  t0.direction_generale_id AS direction_generale_id_24,
  t0.rejeter_par_id AS rejeter_par_id_25,
  t0.receptionnaire_sous_id AS receptionnaire_sous_id_26,
  t0.depensier_id AS depensier_id_27,
  t0.receptionnaire_facture_id AS receptionnaire_facture_id_28,
  t0.demande_id AS demande_id_29,
  t0.caissiere_id AS caissiere_id_30,
  t0.user_id AS user_id_31,
  t0.direction_financiere_id AS direction_financiere_id_32,
  t0.compte_syscohada_id AS compte_syscohada_id_33,
  t0.restituteur_id AS restituteur_id_34,
  t0.objet_bon_id AS objet_bon_id_35
FROM
  bon t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.date_emission AS date_emission_2, t0.motif_decaissement AS motif_decaissement_3, t0.service AS service_4, t0.montant_total AS montant_total_5, t0.motif_rejet AS motif_rejet_6, t0.statut AS statut_7, t0.is_priority AS is_priority_8, t0.objet AS objet_9, t0.montant_restitue AS montant_restitue_10, t0.date_restitution AS date_restitution_11, t0.statut_restitution AS statut_restitution_12, t0.is_facture_recue AS is_facture_recue_13, t0.chemin_facture AS chemin_facture_14, t0.nom_original_facture AS nom_original_facture_15, t0.date_reception_facture AS date_reception_facture_16, t0.montant_rejet AS montant_rejet_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.deleted_at AS deleted_at_20, t0.created_by AS created_by_21, t0.updated_by AS updated_by_22, t0.chef_service_id AS chef_service_id_23, t0.direction_generale_id AS direction_generale_id_24, t0.rejeter_par_id AS rejeter_par_id_25, t0.receptionnaire_sous_id AS receptionnaire_sous_id_26, t0.depensier_id AS depensier_id_27, t0.receptionnaire_facture_id AS receptionnaire_facture_id_28, t0.demande_id AS demande_id_29, t0.caissiere_id AS caissiere_id_30, t0.user_id AS user_id_31, t0.direction_financiere_id AS direction_financiere_id_32, t0.compte_syscohada_id AS compte_syscohada_id_33, t0.restituteur_id AS restituteur_id_34, t0.objet_bon_id AS objet_bon_id_35 FROM bon t0 WHERE t0.id = '01989998-9aeb-7de1-94fe-2b45013a1632';

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

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\Bon	No errors.
App\Entity\User	No errors.
App\Entity\Demande	No errors.
App\Entity\CompteSyscohada	No errors.
App\Entity\ObjetBon	No errors.
App\Entity\OperationCaisse	No errors.
App\Entity\Assignation	No errors.
App\Entity\Operation	No errors.
App\Entity\Permission	No errors.
App\Entity\Reparation	No errors.
App\Entity\MoyensRoulant	No errors.
App\Entity\Evaluation	No errors.

Symfony Profiler

GET https://tc-logistic.topcrono.com/bon/01989998-9aeb-7de1-94fe-2b45013a1632?ajax=1

Configuration Settings

Theme