Query Metrics
4
Database Queries
4
Different statements
5.34 ms
Query time
6
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 3.01 ms |
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.is_remise_auto AS is_remise_auto_36, t0.sexe AS sexe_37, t0.code_parrainage_other AS code_parrainage_other_38, t0.code_parrainage_mine AS code_parrainage_mine_39, t0.prefix_number AS prefix_number_40, t0.is_disponible AS is_disponible_41, t0.deleted_at AS deleted_at_42, t0.speciality_id AS speciality_id_43, t0.ville_id AS ville_id_44, t0.quartier_id AS quartier_id_45, t0.grossiste_id AS grossiste_id_46, t0.payslocalisation_id AS payslocalisation_id_47, t0.ictus_pharmacie_id AS ictus_pharmacie_id_48, t0.societe_livraison_id AS societe_livraison_id_49, t0.last_type_livraison_id AS last_type_livraison_id_50, t0.last_type_paiement_id AS last_type_paiement_id_51 FROM user t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL OR t0.deleted_at >= CURRENT_TIMESTAMP))
Parameters:
[
"2266"
]
|
| 2 | 0.40 ms |
"START TRANSACTION"
Parameters:
[] |
| 3 | 0.68 ms |
UPDATE user SET latitude = ?, logitude = ? WHERE id = ?
Parameters:
[ -18.9011144 47.5068913 2266 ] |
| 4 | 1.25 ms |
"COMMIT"
Parameters:
[] |
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 |
|
| App\Entity\Speciality | No errors. |
| App\Entity\Ville | No errors. |
| App\Entity\Quartier | No errors. |
| App\Entity\Pays | No errors. |
| App\Entity\IctusPharmacie |
|
| App\Entity\SocieteLivraison |
|
| 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 |
|
| App\Entity\IctoRemboursement |
|
| 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 |
|
| App\Entity\RemiseUserPharmacie | No errors. |
| App\Entity\Parrainage | No errors. |
| App\Entity\Favorite | No errors. |
| App\Entity\Carte | No errors. |
| App\Entity\CertCertificat | No errors. |