Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

3.27 ms Query time

0 Invalid entities

4 Managed entities

Queries

Group similar statements

#▲

Time

Info

3.27 ms

SELECT t0.id AS id_1, t0.date AS date_2, t0.status AS status_3, t0.nb_personnes AS nb_personnes_4, t0.montant_frais_dossier_eur AS montant_frais_dossier_eur_5, t0.montant_assurance_annulation_eur AS montant_assurance_annulation_eur_6, t0.montant_frais_dossier_chf AS montant_frais_dossier_chf_7, t0.montant_assurance_annulation_chf AS montant_assurance_annulation_chf_8, t0.sous_total_du_eur AS sous_total_du_eur_9, t0.sous_total_eur AS sous_total_eur_10, t0.sous_total_du_chf AS sous_total_du_chf_11, t0.sous_total_chf AS sous_total_chf_12, t0.assurance AS assurance_13, t0.taux_change_chf_to_eur AS taux_change_chf_to_eur_14, t0.remarque_client AS remarque_client_15, t0.ref_commande AS ref_commande_16, t0.delai_annulation AS delai_annulation_17, t0.litige AS litige_18, t0.motif_litige AS motif_litige_19, t0.commentaire_litige AS commentaire_litige_20, t0.frais_annulation_eur AS frais_annulation_eur_21, t0.frais_annulation_chf AS frais_annulation_chf_22, t0.last_action AS last_action_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.created_by AS created_by_26, t0.updated_by AS updated_by_27, t0.client_id AS client_id_28, t0.circuit_id AS circuit_id_29, t0.cancelled_command_id AS cancelled_command_id_30, t31.id AS id_32, t31.date AS date_33, t31.status AS status_34, t31.nb_personnes AS nb_personnes_35, t31.montant_frais_dossier_eur AS montant_frais_dossier_eur_36, t31.montant_assurance_annulation_eur AS montant_assurance_annulation_eur_37, t31.montant_frais_dossier_chf AS montant_frais_dossier_chf_38, t31.montant_assurance_annulation_chf AS montant_assurance_annulation_chf_39, t31.sous_total_du_eur AS sous_total_du_eur_40, t31.sous_total_eur AS sous_total_eur_41, t31.sous_total_du_chf AS sous_total_du_chf_42, t31.sous_total_chf AS sous_total_chf_43, t31.assurance AS assurance_44, t31.taux_change_chf_to_eur AS taux_change_chf_to_eur_45, t31.remarque_client AS remarque_client_46, t31.ref_commande AS ref_commande_47, t31.delai_annulation AS delai_annulation_48, t31.litige AS litige_49, t31.motif_litige AS motif_litige_50, t31.commentaire_litige AS commentaire_litige_51, t31.frais_annulation_eur AS frais_annulation_eur_52, t31.frais_annulation_chf AS frais_annulation_chf_53, t31.last_action AS last_action_54, t31.created_at AS created_at_55, t31.updated_at AS updated_at_56, t31.created_by AS created_by_57, t31.updated_by AS updated_by_58, t31.client_id AS client_id_59, t31.circuit_id AS circuit_id_60, t31.cancelled_command_id AS cancelled_command_id_61 FROM commande t0 LEFT JOIN commande t31 ON t31.cancelled_command_id = t0.id WHERE t0.id = ?

Parameters:

[
  "401771"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.status AS status_3,
  t0.nb_personnes AS nb_personnes_4,
  t0.montant_frais_dossier_eur AS montant_frais_dossier_eur_5,
  t0.montant_assurance_annulation_eur AS montant_assurance_annulation_eur_6,
  t0.montant_frais_dossier_chf AS montant_frais_dossier_chf_7,
  t0.montant_assurance_annulation_chf AS montant_assurance_annulation_chf_8,
  t0.sous_total_du_eur AS sous_total_du_eur_9,
  t0.sous_total_eur AS sous_total_eur_10,
  t0.sous_total_du_chf AS sous_total_du_chf_11,
  t0.sous_total_chf AS sous_total_chf_12,
  t0.assurance AS assurance_13,
  t0.taux_change_chf_to_eur AS taux_change_chf_to_eur_14,
  t0.remarque_client AS remarque_client_15,
  t0.ref_commande AS ref_commande_16,
  t0.delai_annulation AS delai_annulation_17,
  t0.litige AS litige_18,
  t0.motif_litige AS motif_litige_19,
  t0.commentaire_litige AS commentaire_litige_20,
  t0.frais_annulation_eur AS frais_annulation_eur_21,
  t0.frais_annulation_chf AS frais_annulation_chf_22,
  t0.last_action AS last_action_23,
  t0.created_at AS created_at_24,
  t0.updated_at AS updated_at_25,
  t0.created_by AS created_by_26,
  t0.updated_by AS updated_by_27,
  t0.client_id AS client_id_28,
  t0.circuit_id AS circuit_id_29,
  t0.cancelled_command_id AS cancelled_command_id_30,
  t31.id AS id_32,
  t31.date AS date_33,
  t31.status AS status_34,
  t31.nb_personnes AS nb_personnes_35,
  t31.montant_frais_dossier_eur AS montant_frais_dossier_eur_36,
  t31.montant_assurance_annulation_eur AS montant_assurance_annulation_eur_37,
  t31.montant_frais_dossier_chf AS montant_frais_dossier_chf_38,
  t31.montant_assurance_annulation_chf AS montant_assurance_annulation_chf_39,
  t31.sous_total_du_eur AS sous_total_du_eur_40,
  t31.sous_total_eur AS sous_total_eur_41,
  t31.sous_total_du_chf AS sous_total_du_chf_42,
  t31.sous_total_chf AS sous_total_chf_43,
  t31.assurance AS assurance_44,
  t31.taux_change_chf_to_eur AS taux_change_chf_to_eur_45,
  t31.remarque_client AS remarque_client_46,
  t31.ref_commande AS ref_commande_47,
  t31.delai_annulation AS delai_annulation_48,
  t31.litige AS litige_49,
  t31.motif_litige AS motif_litige_50,
  t31.commentaire_litige AS commentaire_litige_51,
  t31.frais_annulation_eur AS frais_annulation_eur_52,
  t31.frais_annulation_chf AS frais_annulation_chf_53,
  t31.last_action AS last_action_54,
  t31.created_at AS created_at_55,
  t31.updated_at AS updated_at_56,
  t31.created_by AS created_by_57,
  t31.updated_by AS updated_by_58,
  t31.client_id AS client_id_59,
  t31.circuit_id AS circuit_id_60,
  t31.cancelled_command_id AS cancelled_command_id_61
FROM
  commande t0
  LEFT JOIN commande t31 ON t31.cancelled_command_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.date AS date_2, t0.status AS status_3, t0.nb_personnes AS nb_personnes_4, t0.montant_frais_dossier_eur AS montant_frais_dossier_eur_5, t0.montant_assurance_annulation_eur AS montant_assurance_annulation_eur_6, t0.montant_frais_dossier_chf AS montant_frais_dossier_chf_7, t0.montant_assurance_annulation_chf AS montant_assurance_annulation_chf_8, t0.sous_total_du_eur AS sous_total_du_eur_9, t0.sous_total_eur AS sous_total_eur_10, t0.sous_total_du_chf AS sous_total_du_chf_11, t0.sous_total_chf AS sous_total_chf_12, t0.assurance AS assurance_13, t0.taux_change_chf_to_eur AS taux_change_chf_to_eur_14, t0.remarque_client AS remarque_client_15, t0.ref_commande AS ref_commande_16, t0.delai_annulation AS delai_annulation_17, t0.litige AS litige_18, t0.motif_litige AS motif_litige_19, t0.commentaire_litige AS commentaire_litige_20, t0.frais_annulation_eur AS frais_annulation_eur_21, t0.frais_annulation_chf AS frais_annulation_chf_22, t0.last_action AS last_action_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.created_by AS created_by_26, t0.updated_by AS updated_by_27, t0.client_id AS client_id_28, t0.circuit_id AS circuit_id_29, t0.cancelled_command_id AS cancelled_command_id_30, t31.id AS id_32, t31.date AS date_33, t31.status AS status_34, t31.nb_personnes AS nb_personnes_35, t31.montant_frais_dossier_eur AS montant_frais_dossier_eur_36, t31.montant_assurance_annulation_eur AS montant_assurance_annulation_eur_37, t31.montant_frais_dossier_chf AS montant_frais_dossier_chf_38, t31.montant_assurance_annulation_chf AS montant_assurance_annulation_chf_39, t31.sous_total_du_eur AS sous_total_du_eur_40, t31.sous_total_eur AS sous_total_eur_41, t31.sous_total_du_chf AS sous_total_du_chf_42, t31.sous_total_chf AS sous_total_chf_43, t31.assurance AS assurance_44, t31.taux_change_chf_to_eur AS taux_change_chf_to_eur_45, t31.remarque_client AS remarque_client_46, t31.ref_commande AS ref_commande_47, t31.delai_annulation AS delai_annulation_48, t31.litige AS litige_49, t31.motif_litige AS motif_litige_50, t31.commentaire_litige AS commentaire_litige_51, t31.frais_annulation_eur AS frais_annulation_eur_52, t31.frais_annulation_chf AS frais_annulation_chf_53, t31.last_action AS last_action_54, t31.created_at AS created_at_55, t31.updated_at AS updated_at_56, t31.created_by AS created_by_57, t31.updated_by AS updated_by_58, t31.client_id AS client_id_59, t31.circuit_id AS circuit_id_60, t31.cancelled_command_id AS cancelled_command_id_61 FROM commande t0 LEFT JOIN commande t31 ON t31.cancelled_command_id = t0.id WHERE t0.id = '401771';

#	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 129)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 69)
7	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
9	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
14	Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 476)
15	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 68)
16	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 453)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 351)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 220)
19	Symfony\Component\HttpKernel\Kernel->handle (line 179)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 32)
22	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\Commande	2
App\Entity\Client	1
App\Entity\Circuit	1

Entities Mapping

Class	Mapping errors
App\Entity\Commande	No errors.
App\Entity\Client	No errors.
App\Entity\Circuit	No errors.
App\Entity\Reservation	No errors.
App\Entity\Confort	No errors.
App\Entity\Voyageur	No errors.
App\Entity\Payment	No errors.
App\Entity\TransfertPaiement	No errors.

Symfony Profiler

GET https://tmb.2le-test.me/fr/mon-compte/commandes/401771

Configuration Settings

Theme

Page Width