Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

2.18 ms Query time

5 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	2.18 ms	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.is_ready_pov AS is_ready_pov_3, t0.is_livrer AS is_livrer_4, t0.date_ready_pov AS date_ready_pov_5, t0.date_livraison AS date_livraison_6, t0.reference AS reference_7, t0.stripe_session_id AS stripe_session_id_8, t0.token AS token_9, t0.token_strippe AS token_strippe_10, t0.is_livraison_valide AS is_livraison_valide_11, t0.is_valide AS is_valide_12, t0.code AS code_13, t0.code_secret AS code_secret_14, t0.raison_annulation AS raison_annulation_15, t0.reference_client_tp AS reference_client_tp_16, t0.societename AS societename_17, t0.is_recuperer AS is_recuperer_18, t0.is_changed AS is_changed_19, t0.commentaire AS commentaire_20, t0.is_annule AS is_annule_21, t0.remise AS remise_22, t0.etatpaiement_id AS etatpaiement_id_23, t0.type_livraison_id AS type_livraison_id_24, t0.pharmacie_id AS pharmacie_id_25, t0.type_paiement_id AS type_paiement_id_26, t0.user_id AS user_id_27, t0.tierpayant_id AS tierpayant_id_28, t0.adresse_patient_id AS adresse_patient_id_29, t0.parrainage_id AS parrainage_id_30, t0.prisencharge_id AS prisencharge_id_31, t32.id AS id_33, t32.tarif AS tarif_34, t32.etat AS etat_35, t32.ictus_commande_id AS ictus_commande_id_36, t32.livraison_id AS livraison_id_37, t32.adresse_id AS adresse_id_38 FROM ictus_commande t0 LEFT JOIN parcours t32 ON t32.ictus_commande_id = t0.id WHERE t0.id = ? Parameters: [`"1104"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.is_ready_pov AS is_ready_pov_3, t0.is_livrer AS is_livrer_4, t0.date_ready_pov AS date_ready_pov_5, t0.date_livraison AS date_livraison_6, t0.reference AS reference_7, t0.stripe_session_id AS stripe_session_id_8, t0.token AS token_9, t0.token_strippe AS token_strippe_10, t0.is_livraison_valide AS is_livraison_valide_11, t0.is_valide AS is_valide_12, t0.code AS code_13, t0.code_secret AS code_secret_14, t0.raison_annulation AS raison_annulation_15, t0.reference_client_tp AS reference_client_tp_16, t0.societename AS societename_17, t0.is_recuperer AS is_recuperer_18, t0.is_changed AS is_changed_19, t0.commentaire AS commentaire_20, t0.is_annule AS is_annule_21, t0.remise AS remise_22, t0.etatpaiement_id AS etatpaiement_id_23, t0.type_livraison_id AS type_livraison_id_24, t0.pharmacie_id AS pharmacie_id_25, t0.type_paiement_id AS type_paiement_id_26, t0.user_id AS user_id_27, t0.tierpayant_id AS tierpayant_id_28, t0.adresse_patient_id AS adresse_patient_id_29, t0.parrainage_id AS parrainage_id_30, t0.prisencharge_id AS prisencharge_id_31, t32.id AS id_33, t32.tarif AS tarif_34, t32.etat AS etat_35, t32.ictus_commande_id AS ictus_commande_id_36, t32.livraison_id AS livraison_id_37, t32.adresse_id AS adresse_id_38 FROM ictus_commande t0 LEFT JOIN parcours t32 ON t32.ictus_commande_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.is_ready_pov AS is_ready_pov_3, t0.is_livrer AS is_livrer_4, t0.date_ready_pov AS date_ready_pov_5, t0.date_livraison AS date_livraison_6, t0.reference AS reference_7, t0.stripe_session_id AS stripe_session_id_8, t0.token AS token_9, t0.token_strippe AS token_strippe_10, t0.is_livraison_valide AS is_livraison_valide_11, t0.is_valide AS is_valide_12, t0.code AS code_13, t0.code_secret AS code_secret_14, t0.raison_annulation AS raison_annulation_15, t0.reference_client_tp AS reference_client_tp_16, t0.societename AS societename_17, t0.is_recuperer AS is_recuperer_18, t0.is_changed AS is_changed_19, t0.commentaire AS commentaire_20, t0.is_annule AS is_annule_21, t0.remise AS remise_22, t0.etatpaiement_id AS etatpaiement_id_23, t0.type_livraison_id AS type_livraison_id_24, t0.pharmacie_id AS pharmacie_id_25, t0.type_paiement_id AS type_paiement_id_26, t0.user_id AS user_id_27, t0.tierpayant_id AS tierpayant_id_28, t0.adresse_patient_id AS adresse_patient_id_29, t0.parrainage_id AS parrainage_id_30, t0.prisencharge_id AS prisencharge_id_31, t32.id AS id_33, t32.tarif AS tarif_34, t32.etat AS etat_35, t32.ictus_commande_id AS ictus_commande_id_36, t32.livraison_id AS livraison_id_37, t32.adresse_id AS adresse_id_38 FROM ictus_commande t0 LEFT JOIN parcours t32 ON t32.ictus_commande_id = t0.id WHERE t0.id = '1104';

#▲

Time

Info

2.18 ms

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.is_ready_pov AS is_ready_pov_3, t0.is_livrer AS is_livrer_4, t0.date_ready_pov AS date_ready_pov_5, t0.date_livraison AS date_livraison_6, t0.reference AS reference_7, t0.stripe_session_id AS stripe_session_id_8, t0.token AS token_9, t0.token_strippe AS token_strippe_10, t0.is_livraison_valide AS is_livraison_valide_11, t0.is_valide AS is_valide_12, t0.code AS code_13, t0.code_secret AS code_secret_14, t0.raison_annulation AS raison_annulation_15, t0.reference_client_tp AS reference_client_tp_16, t0.societename AS societename_17, t0.is_recuperer AS is_recuperer_18, t0.is_changed AS is_changed_19, t0.commentaire AS commentaire_20, t0.is_annule AS is_annule_21, t0.remise AS remise_22, t0.etatpaiement_id AS etatpaiement_id_23, t0.type_livraison_id AS type_livraison_id_24, t0.pharmacie_id AS pharmacie_id_25, t0.type_paiement_id AS type_paiement_id_26, t0.user_id AS user_id_27, t0.tierpayant_id AS tierpayant_id_28, t0.adresse_patient_id AS adresse_patient_id_29, t0.parrainage_id AS parrainage_id_30, t0.prisencharge_id AS prisencharge_id_31, t32.id AS id_33, t32.tarif AS tarif_34, t32.etat AS etat_35, t32.ictus_commande_id AS ictus_commande_id_36, t32.livraison_id AS livraison_id_37, t32.adresse_id AS adresse_id_38 FROM ictus_commande t0 LEFT JOIN parcours t32 ON t32.ictus_commande_id = t0.id WHERE t0.id = ?

Parameters:

[
  "1104"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.is_ready_pov AS is_ready_pov_3,
  t0.is_livrer AS is_livrer_4,
  t0.date_ready_pov AS date_ready_pov_5,
  t0.date_livraison AS date_livraison_6,
  t0.reference AS reference_7,
  t0.stripe_session_id AS stripe_session_id_8,
  t0.token AS token_9,
  t0.token_strippe AS token_strippe_10,
  t0.is_livraison_valide AS is_livraison_valide_11,
  t0.is_valide AS is_valide_12,
  t0.code AS code_13,
  t0.code_secret AS code_secret_14,
  t0.raison_annulation AS raison_annulation_15,
  t0.reference_client_tp AS reference_client_tp_16,
  t0.societename AS societename_17,
  t0.is_recuperer AS is_recuperer_18,
  t0.is_changed AS is_changed_19,
  t0.commentaire AS commentaire_20,
  t0.is_annule AS is_annule_21,
  t0.remise AS remise_22,
  t0.etatpaiement_id AS etatpaiement_id_23,
  t0.type_livraison_id AS type_livraison_id_24,
  t0.pharmacie_id AS pharmacie_id_25,
  t0.type_paiement_id AS type_paiement_id_26,
  t0.user_id AS user_id_27,
  t0.tierpayant_id AS tierpayant_id_28,
  t0.adresse_patient_id AS adresse_patient_id_29,
  t0.parrainage_id AS parrainage_id_30,
  t0.prisencharge_id AS prisencharge_id_31,
  t32.id AS id_33,
  t32.tarif AS tarif_34,
  t32.etat AS etat_35,
  t32.ictus_commande_id AS ictus_commande_id_36,
  t32.livraison_id AS livraison_id_37,
  t32.adresse_id AS adresse_id_38
FROM
  ictus_commande t0
  LEFT JOIN parcours t32 ON t32.ictus_commande_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.is_ready_pov AS is_ready_pov_3, t0.is_livrer AS is_livrer_4, t0.date_ready_pov AS date_ready_pov_5, t0.date_livraison AS date_livraison_6, t0.reference AS reference_7, t0.stripe_session_id AS stripe_session_id_8, t0.token AS token_9, t0.token_strippe AS token_strippe_10, t0.is_livraison_valide AS is_livraison_valide_11, t0.is_valide AS is_valide_12, t0.code AS code_13, t0.code_secret AS code_secret_14, t0.raison_annulation AS raison_annulation_15, t0.reference_client_tp AS reference_client_tp_16, t0.societename AS societename_17, t0.is_recuperer AS is_recuperer_18, t0.is_changed AS is_changed_19, t0.commentaire AS commentaire_20, t0.is_annule AS is_annule_21, t0.remise AS remise_22, t0.etatpaiement_id AS etatpaiement_id_23, t0.type_livraison_id AS type_livraison_id_24, t0.pharmacie_id AS pharmacie_id_25, t0.type_paiement_id AS type_paiement_id_26, t0.user_id AS user_id_27, t0.tierpayant_id AS tierpayant_id_28, t0.adresse_patient_id AS adresse_patient_id_29, t0.parrainage_id AS parrainage_id_30, t0.prisencharge_id AS prisencharge_id_31, t32.id AS id_33, t32.tarif AS tarif_34, t32.etat AS etat_35, t32.ictus_commande_id AS ictus_commande_id_36, t32.livraison_id AS livraison_id_37, t32.adresse_id AS adresse_id_38 FROM ictus_commande t0 LEFT JOIN parcours t32 ON t32.ictus_commande_id = t0.id WHERE t0.id = '1104';

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\IctusCommande	The field App\Entity\IctusCommande#parcours is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Parcours#ictusCommande does not contain the required 'inversedBy="parcours"' attribute.
App\Entity\IctusEtatPaiement	No errors.
App\Entity\IctusTypeLivraison	No errors.
App\Entity\IctusPharmacie	The association App\Entity\IctusPharmacie#parcours refers to the owning side field App\Entity\Parcours#pharmacie which does not exist.
App\Entity\IctusTypePaiement	No errors.
App\Entity\User	The association App\Entity\User#parcours refers to the owning side field App\Entity\Parcours#patient which does not exist. The field App\Entity\User#rates is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Rate#user does not contain the required 'inversedBy="rates"' attribute.
App\Entity\Tierpayant	No errors.
App\Entity\Adresse	No errors.
App\Entity\Parrainage	No errors.
App\Entity\PrisEnCharge	The field App\Entity\PrisEnCharge#ictusCommande is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\IctusCommande#prisencharge does not contain the required 'inversedBy="ictusCommande"' attribute.
App\Entity\Parcours	No errors.
App\Entity\Livraison	The association App\Entity\Livraison#livreur refers to the inverse side field App\Entity\User#livraisons which does not exist.
App\Entity\IctusCommandeLine	No errors.
App\Entity\IctusHistoriquePaiement	No errors.
App\Entity\Ordonnance	No errors.
App\Entity\IctusReclamation	No errors.
App\Entity\FacturePatient	No errors.

Symfony Profiler

https://www.pharmadexi.com/ictus/commande/patient/detail/1104

Configuration Settings

Theme