https://www.pharmadexi.com/api_ictus/commande/patient/validation/1127

Query Metrics

2 Database Queries
2 Different statements
5.04 ms Query time
5 Invalid entities

Queries

Group similar statements

# Time Info
1 3.67 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:
[
  "1127"
]
2 1.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.codepays AS codepays_3, t0.currency AS currency_4, t0.coursechange AS coursechange_5, t0.updated_at AS updated_at_6, t0.tva AS tva_7 FROM pays t0 WHERE t0.codepays = ? LIMIT 1
Parameters:
[
  "MG"
]

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.
App\Entity\Pays No errors.
App\Entity\Ville No errors.
App\Entity\Product No errors.
App\Entity\IctoParamgeneral No errors.