https://www.pharmadexi.com/api/ictus-shop/panier/somme-total/192

Method
GET
HTTP Status
404
IP
20.171.207.113
Profiled on
Token
011829

Query Metrics

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

Grouped Statements

Show all queries

Time▼ Count Info
4.67 ms
(57.94%) 		1 
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.designation AS designation_5, t0.phone AS phone_6, t0.phonetwo AS phonetwo_7, t0.phonethree AS phonethree_8, t0.ordre AS ordre_9, t0.is_active AS is_active_10, t0.firstname AS firstname_11, t0.lastname AS lastname_12, t0.is_acceptcgv AS is_acceptcgv_13, t0.address AS address_14, t0.pays AS pays_15, t0.urlexcelcmd AS urlexcelcmd_16, t0.is_paid AS is_paid_17, t0.image AS image_18, t0.updated_at AS updated_at_19, t0.verification_code AS verification_code_20, t0.verified AS verified_21, t0.latitude AS latitude_22, t0.logitude AS logitude_23, t0.cguaccepted AS cguaccepted_24, t0.is_admin AS is_admin_25, t0.cin AS cin_26, t0.reinitmdp AS reinitmdp_27, t0.validate_code AS validate_code_28, t0.expiredreinitmdp AS expiredreinitmdp_29, t0.reference_client_tp AS reference_client_tp_30, t0.societename AS societename_31, t0.datenaissance AS datenaissance_32, t0.fcm_token AS fcm_token_33, t0.rangphoto AS rangphoto_34, t0.service_sopharmad AS service_sopharmad_35, t0.deleted_at AS deleted_at_36, t0.speciality_id AS speciality_id_37, t0.ville_id AS ville_id_38, t0.quartier_id AS quartier_id_39, t0.grossiste_id AS grossiste_id_40, t0.payslocalisation_id AS payslocalisation_id_41, t0.ictus_pharmacie_id AS ictus_pharmacie_id_42, t0.societe_livraison_id AS societe_livraison_id_43, t0.last_type_livraison_id AS last_type_livraison_id_44, t0.last_type_paiement_id AS last_type_paiement_id_45 FROM user t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL OR t0.deleted_at >= CURRENT_TIMESTAMP))
Parameters: 
[
  "192"
]
View formatted query    View runnable query    Explain query
3.39 ms
(42.06%) 		1 
SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.created_at AS created_at_3, t0.total AS total_4, t0.prix_unitaire AS prix_unitaire_5, t0.produit_stock_pcie_id AS produit_stock_pcie_id_6, t0.user_id AS user_id_7, t0.ordonnance_id AS ordonnance_id_8 FROM ictus_panier_patient t0 WHERE t0.user_id = ?
Parameters: 
[
  192
]
View formatted query    View runnable query    Explain query

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\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\Speciality No errors.
App\Entity\Ville No errors.
App\Entity\Quartier No errors.
App\Entity\Pays 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\SocieteLivraison
  • The association App\Entity\SocieteLivraison#ictusCommandes refers to the owning side field App\Entity\IctusCommande#societeLivraison which does not exist.
App\Entity\IctusTypeLivraison No errors.
App\Entity\IctusTypePaiement No errors.
App\Entity\Proposition No errors.
App\Entity\Order No errors.
App\Entity\GroupSuggestion No errors.
App\Entity\Cart No errors.
App\Entity\Stockpharmacie No errors.
App\Entity\HistoriqueRefusProposition No errors.
App\Entity\Discution No errors.
App\Entity\Reclamation No errors.
App\Entity\Forecast No errors.
App\Entity\UserTypepaiement No errors.
App\Entity\HistoriquePaiement No errors.
App\Entity\IctusPanierPatient No errors.
App\Entity\IctusCommande No errors.
App\Entity\IctoRemboursement
  • The mappings App\Entity\IctoRemboursement#typePaiementObtenue and App\Entity\Typepaiement#ictoRemboursements are inconsistent with each other.
App\Entity\Ordonnance No errors.
App\Entity\Adresse No errors.
App\Entity\IctusPanierSpecial No errors.
App\Entity\CommandeSpecial No errors.
App\Entity\NonDisponibilite No errors.
App\Entity\FacturePatient No errors.
App\Entity\IctusReclamation No errors.
App\Entity\IctusMobileAppareil No errors.
App\Entity\Parcours No errors.
App\Entity\Photo No errors.
App\Entity\IctoMouvement No errors.
App\Entity\Doublon No errors.
App\Entity\Rate No errors.
App\Entity\SearchHistory
  • The association App\Entity\SearchHistory#appareil refers to the inverse side field App\Entity\IctusMobileAppareil#searchHistories which does not exist.