Query Metrics
184
Database Queries
4
Different statements
3467.28 ms
Query time
5
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
3454.50 ms (99.63%) |
180 |
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[ 2137 "2025-01-01 00:00:00" "2025-01-01 23:59:59" ] |
10.07 ms (0.29%) |
2 |
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:
[
2137
]
|
2.20 ms (0.06%) |
1 |
SELECT MIN(c0_.id) AS sclr_0 FROM cookie c0_
Parameters:
[] |
0.50 ms (0.01%) |
1 |
SELECT c0_.id AS id_0, c0_.titre AS titre_1, c0_.contenue AS contenue_2 FROM cookie c0_ ORDER BY c0_.id ASC LIMIT 1
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 | No errors. |
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\Cookie | No errors. |