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

Query Metrics

2 Database Queries
2 Different statements
5.35 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 4.53 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 FROM ictus_commande t0 WHERE t0.id = ?
Parameters:
[
  "907"
]
2 0.83 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 No errors.
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\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.