https://www.pharmadexi.com/

Query Metrics

184 Database Queries
4 Different statements
3467.28 ms Query time
5 Invalid entities

Queries

Group similar statements

# Time Info
1 8.43 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.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 1.64 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.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:
[
  2138
]
3 40.52 ms
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"
]
4 22.43 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-01-01 00:00:00"
  "2025-01-01 23:59:59"
]
5 24.70 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-01-02 00:00:00"
  "2025-01-02 23:59:59"
]
6 9.41 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-01-02 00:00:00"
  "2025-01-02 23:59:59"
]
7 40.72 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-01-03 00:00:00"
  "2025-01-03 23:59:59"
]
8 8.95 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-01-03 00:00:00"
  "2025-01-03 23:59:59"
]
9 18.55 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-01-04 00:00:00"
  "2025-01-04 23:59:59"
]
10 9.26 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-01-04 00:00:00"
  "2025-01-04 23:59:59"
]
11 20.69 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-01-05 00:00:00"
  "2025-01-05 23:59:59"
]
12 21.28 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-01-05 00:00:00"
  "2025-01-05 23:59:59"
]
13 30.37 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-01-06 00:00:00"
  "2025-01-06 23:59:59"
]
14 10.07 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-01-06 00:00:00"
  "2025-01-06 23:59:59"
]
15 21.12 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-01-07 00:00:00"
  "2025-01-07 23:59:59"
]
16 10.04 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-01-07 00:00:00"
  "2025-01-07 23:59:59"
]
17 25.52 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-01-08 00:00:00"
  "2025-01-08 23:59:59"
]
18 33.31 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-01-08 00:00:00"
  "2025-01-08 23:59:59"
]
19 31.86 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-01-09 00:00:00"
  "2025-01-09 23:59:59"
]
20 10.49 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-01-09 00:00:00"
  "2025-01-09 23:59:59"
]
21 22.26 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-01-10 00:00:00"
  "2025-01-10 23:59:59"
]
22 12.72 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-01-10 00:00:00"
  "2025-01-10 23:59:59"
]
23 19.58 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-01-11 00:00:00"
  "2025-01-11 23:59:59"
]
24 9.99 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-01-11 00:00:00"
  "2025-01-11 23:59:59"
]
25 20.15 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-01-12 00:00:00"
  "2025-01-12 23:59:59"
]
26 12.78 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-01-12 00:00:00"
  "2025-01-12 23:59:59"
]
27 20.21 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-01-13 00:00:00"
  "2025-01-13 23:59:59"
]
28 9.64 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-01-13 00:00:00"
  "2025-01-13 23:59:59"
]
29 19.53 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-01-14 00:00:00"
  "2025-01-14 23:59:59"
]
30 9.52 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-01-14 00:00:00"
  "2025-01-14 23:59:59"
]
31 22.12 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-01-15 00:00:00"
  "2025-01-15 23:59:59"
]
32 16.29 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-01-15 00:00:00"
  "2025-01-15 23:59:59"
]
33 33.40 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-01-16 00:00:00"
  "2025-01-16 23:59:59"
]
34 9.74 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-01-16 00:00:00"
  "2025-01-16 23:59:59"
]
35 19.01 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-01-17 00:00:00"
  "2025-01-17 23:59:59"
]
36 9.71 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-01-17 00:00:00"
  "2025-01-17 23:59:59"
]
37 28.33 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-01-18 00:00:00"
  "2025-01-18 23:59:59"
]
38 16.72 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-01-18 00:00:00"
  "2025-01-18 23:59:59"
]
39 26.89 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-01-19 00:00:00"
  "2025-01-19 23:59:59"
]
40 18.55 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-01-19 00:00:00"
  "2025-01-19 23:59:59"
]
41 32.34 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-01-20 00:00:00"
  "2025-01-20 23:59:59"
]
42 13.50 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-01-20 00:00:00"
  "2025-01-20 23:59:59"
]
43 28.30 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-01-21 00:00:00"
  "2025-01-21 23:59:59"
]
44 14.99 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-01-21 00:00:00"
  "2025-01-21 23:59:59"
]
45 30.65 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-01-22 00:00:00"
  "2025-01-22 23:59:59"
]
46 12.32 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-01-22 00:00:00"
  "2025-01-22 23:59:59"
]
47 24.89 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-01-23 00:00:00"
  "2025-01-23 23:59:59"
]
48 13.98 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-01-23 00:00:00"
  "2025-01-23 23:59:59"
]
49 23.41 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-01-24 00:00:00"
  "2025-01-24 23:59:59"
]
50 10.24 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-01-24 00:00:00"
  "2025-01-24 23:59:59"
]
51 24.09 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-01-25 00:00:00"
  "2025-01-25 23:59:59"
]
52 14.31 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-01-25 00:00:00"
  "2025-01-25 23:59:59"
]
53 28.92 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-01-26 00:00:00"
  "2025-01-26 23:59:59"
]
54 11.63 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-01-26 00:00:00"
  "2025-01-26 23:59:59"
]
55 25.42 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-01-27 00:00:00"
  "2025-01-27 23:59:59"
]
56 15.62 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-01-27 00:00:00"
  "2025-01-27 23:59:59"
]
57 30.06 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-01-28 00:00:00"
  "2025-01-28 23:59:59"
]
58 15.73 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-01-28 00:00:00"
  "2025-01-28 23:59:59"
]
59 25.53 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-01-29 00:00:00"
  "2025-01-29 23:59:59"
]
60 10.41 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-01-29 00:00:00"
  "2025-01-29 23:59:59"
]
61 23.79 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-01-30 00:00:00"
  "2025-01-30 23:59:59"
]
62 9.42 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-01-30 00:00:00"
  "2025-01-30 23:59:59"
]
63 20.41 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-01-31 00:00:00"
  "2025-01-31 23:59:59"
]
64 9.33 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-01-31 00:00:00"
  "2025-01-31 23:59:59"
]
65 18.88 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-02-01 00:00:00"
  "2025-02-01 23:59:59"
]
66 9.62 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-02-01 00:00:00"
  "2025-02-01 23:59:59"
]
67 18.83 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-02-02 00:00:00"
  "2025-02-02 23:59:59"
]
68 9.24 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-02-02 00:00:00"
  "2025-02-02 23:59:59"
]
69 27.23 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-02-03 00:00:00"
  "2025-02-03 23:59:59"
]
70 10.05 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-02-03 00:00:00"
  "2025-02-03 23:59:59"
]
71 22.28 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-02-04 00:00:00"
  "2025-02-04 23:59:59"
]
72 11.31 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-02-04 00:00:00"
  "2025-02-04 23:59:59"
]
73 25.39 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-02-05 00:00:00"
  "2025-02-05 23:59:59"
]
74 14.78 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-02-05 00:00:00"
  "2025-02-05 23:59:59"
]
75 31.37 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-02-06 00:00:00"
  "2025-02-06 23:59:59"
]
76 15.27 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-02-06 00:00:00"
  "2025-02-06 23:59:59"
]
77 33.97 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-02-07 00:00:00"
  "2025-02-07 23:59:59"
]
78 14.17 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-02-07 00:00:00"
  "2025-02-07 23:59:59"
]
79 25.31 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-02-08 00:00:00"
  "2025-02-08 23:59:59"
]
80 11.89 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-02-08 00:00:00"
  "2025-02-08 23:59:59"
]
81 28.84 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-02-09 00:00:00"
  "2025-02-09 23:59:59"
]
82 14.10 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-02-09 00:00:00"
  "2025-02-09 23:59:59"
]
83 33.49 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-02-10 00:00:00"
  "2025-02-10 23:59:59"
]
84 16.79 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-02-10 00:00:00"
  "2025-02-10 23:59:59"
]
85 37.34 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-02-11 00:00:00"
  "2025-02-11 23:59:59"
]
86 11.57 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-02-11 00:00:00"
  "2025-02-11 23:59:59"
]
87 25.35 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-02-12 00:00:00"
  "2025-02-12 23:59:59"
]
88 12.41 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-02-12 00:00:00"
  "2025-02-12 23:59:59"
]
89 23.13 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-02-13 00:00:00"
  "2025-02-13 23:59:59"
]
90 11.86 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-02-13 00:00:00"
  "2025-02-13 23:59:59"
]
91 22.21 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-02-14 00:00:00"
  "2025-02-14 23:59:59"
]
92 11.07 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-02-14 00:00:00"
  "2025-02-14 23:59:59"
]
93 26.33 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-02-15 00:00:00"
  "2025-02-15 23:59:59"
]
94 10.32 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-02-15 00:00:00"
  "2025-02-15 23:59:59"
]
95 19.03 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-02-16 00:00:00"
  "2025-02-16 23:59:59"
]
96 9.93 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-02-16 00:00:00"
  "2025-02-16 23:59:59"
]
97 23.87 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-02-17 00:00:00"
  "2025-02-17 23:59:59"
]
98 13.25 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-02-17 00:00:00"
  "2025-02-17 23:59:59"
]
99 22.83 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-02-18 00:00:00"
  "2025-02-18 23:59:59"
]
100 11.71 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-02-18 00:00:00"
  "2025-02-18 23:59:59"
]
101 22.69 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-02-19 00:00:00"
  "2025-02-19 23:59:59"
]
102 10.57 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-02-19 00:00:00"
  "2025-02-19 23:59:59"
]
103 21.46 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-02-20 00:00:00"
  "2025-02-20 23:59:59"
]
104 9.69 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-02-20 00:00:00"
  "2025-02-20 23:59:59"
]
105 20.65 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-02-21 00:00:00"
  "2025-02-21 23:59:59"
]
106 11.08 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-02-21 00:00:00"
  "2025-02-21 23:59:59"
]
107 22.80 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-02-22 00:00:00"
  "2025-02-22 23:59:59"
]
108 9.59 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-02-22 00:00:00"
  "2025-02-22 23:59:59"
]
109 18.60 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-02-23 00:00:00"
  "2025-02-23 23:59:59"
]
110 9.01 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-02-23 00:00:00"
  "2025-02-23 23:59:59"
]
111 18.61 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-02-24 00:00:00"
  "2025-02-24 23:59:59"
]
112 9.37 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-02-24 00:00:00"
  "2025-02-24 23:59:59"
]
113 20.48 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-02-25 00:00:00"
  "2025-02-25 23:59:59"
]
114 9.08 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-02-25 00:00:00"
  "2025-02-25 23:59:59"
]
115 21.56 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-02-26 00:00:00"
  "2025-02-26 23:59:59"
]
116 11.02 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-02-26 00:00:00"
  "2025-02-26 23:59:59"
]
117 19.81 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-02-27 00:00:00"
  "2025-02-27 23:59:59"
]
118 12.49 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-02-27 00:00:00"
  "2025-02-27 23:59:59"
]
119 25.49 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-02-28 00:00:00"
  "2025-02-28 23:59:59"
]
120 8.96 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-02-28 00:00:00"
  "2025-02-28 23:59:59"
]
121 17.90 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-03-01 00:00:00"
  "2025-03-01 23:59:59"
]
122 8.72 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-03-01 00:00:00"
  "2025-03-01 23:59:59"
]
123 18.54 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-03-02 00:00:00"
  "2025-03-02 23:59:59"
]
124 9.49 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-03-02 00:00:00"
  "2025-03-02 23:59:59"
]
125 34.39 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-03-03 00:00:00"
  "2025-03-03 23:59:59"
]
126 19.43 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-03-03 00:00:00"
  "2025-03-03 23:59:59"
]
127 22.62 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-03-04 00:00:00"
  "2025-03-04 23:59:59"
]
128 18.00 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-03-04 00:00:00"
  "2025-03-04 23:59:59"
]
129 48.41 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-03-05 00:00:00"
  "2025-03-05 23:59:59"
]
130 15.06 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-03-05 00:00:00"
  "2025-03-05 23:59:59"
]
131 25.13 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-03-06 00:00:00"
  "2025-03-06 23:59:59"
]
132 12.34 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-03-06 00:00:00"
  "2025-03-06 23:59:59"
]
133 49.90 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-03-07 00:00:00"
  "2025-03-07 23:59:59"
]
134 14.31 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-03-07 00:00:00"
  "2025-03-07 23:59:59"
]
135 30.15 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-03-08 00:00:00"
  "2025-03-08 23:59:59"
]
136 19.00 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-03-08 00:00:00"
  "2025-03-08 23:59:59"
]
137 35.59 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-03-09 00:00:00"
  "2025-03-09 23:59:59"
]
138 16.35 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-03-09 00:00:00"
  "2025-03-09 23:59:59"
]
139 30.72 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-03-10 00:00:00"
  "2025-03-10 23:59:59"
]
140 16.48 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-03-10 00:00:00"
  "2025-03-10 23:59:59"
]
141 29.28 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-03-11 00:00:00"
  "2025-03-11 23:59:59"
]
142 16.89 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-03-11 00:00:00"
  "2025-03-11 23:59:59"
]
143 25.23 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-03-12 00:00:00"
  "2025-03-12 23:59:59"
]
144 11.36 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-03-12 00:00:00"
  "2025-03-12 23:59:59"
]
145 35.33 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-03-13 00:00:00"
  "2025-03-13 23:59:59"
]
146 10.62 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-03-13 00:00:00"
  "2025-03-13 23:59:59"
]
147 20.82 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-03-14 00:00:00"
  "2025-03-14 23:59:59"
]
148 9.98 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-03-14 00:00:00"
  "2025-03-14 23:59:59"
]
149 20.83 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-03-15 00:00:00"
  "2025-03-15 23:59:59"
]
150 10.46 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-03-15 00:00:00"
  "2025-03-15 23:59:59"
]
151 22.46 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-03-16 00:00:00"
  "2025-03-16 23:59:59"
]
152 10.03 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-03-16 00:00:00"
  "2025-03-16 23:59:59"
]
153 21.02 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-03-17 00:00:00"
  "2025-03-17 23:59:59"
]
154 9.91 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-03-17 00:00:00"
  "2025-03-17 23:59:59"
]
155 18.61 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-03-18 00:00:00"
  "2025-03-18 23:59:59"
]
156 13.04 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-03-18 00:00:00"
  "2025-03-18 23:59:59"
]
157 25.44 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-03-19 00:00:00"
  "2025-03-19 23:59:59"
]
158 25.23 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-03-19 00:00:00"
  "2025-03-19 23:59:59"
]
159 22.88 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-03-20 00:00:00"
  "2025-03-20 23:59:59"
]
160 10.39 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-03-20 00:00:00"
  "2025-03-20 23:59:59"
]
161 24.76 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-03-21 00:00:00"
  "2025-03-21 23:59:59"
]
162 11.46 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-03-21 00:00:00"
  "2025-03-21 23:59:59"
]
163 20.51 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-03-22 00:00:00"
  "2025-03-22 23:59:59"
]
164 9.65 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-03-22 00:00:00"
  "2025-03-22 23:59:59"
]
165 20.73 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-03-23 00:00:00"
  "2025-03-23 23:59:59"
]
166 9.58 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-03-23 00:00:00"
  "2025-03-23 23:59:59"
]
167 19.72 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-03-24 00:00:00"
  "2025-03-24 23:59:59"
]
168 10.15 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-03-24 00:00:00"
  "2025-03-24 23:59:59"
]
169 24.85 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-03-25 00:00:00"
  "2025-03-25 23:59:59"
]
170 10.31 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-03-25 00:00:00"
  "2025-03-25 23:59:59"
]
171 25.88 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-03-26 00:00:00"
  "2025-03-26 23:59:59"
]
172 10.47 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-03-26 00:00:00"
  "2025-03-26 23:59:59"
]
173 37.22 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-03-27 00:00:00"
  "2025-03-27 23:59:59"
]
174 15.80 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-03-27 00:00:00"
  "2025-03-27 23:59:59"
]
175 31.18 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-03-28 00:00:00"
  "2025-03-28 23:59:59"
]
176 13.38 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-03-28 00:00:00"
  "2025-03-28 23:59:59"
]
177 19.40 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-03-29 00:00:00"
  "2025-03-29 23:59:59"
]
178 11.65 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-03-29 00:00:00"
  "2025-03-29 23:59:59"
]
179 19.44 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-03-30 00:00:00"
  "2025-03-30 23:59:59"
]
180 9.96 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-03-30 00:00:00"
  "2025-03-30 23:59:59"
]
181 28.97 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2137
  "2025-03-31 00:00:00"
  "2025-03-31 23:59:59"
]
182 23.31 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ WHERE p0_.creator_id = ? AND p0_.createdat BETWEEN ? AND ?
Parameters:
[
  2138
  "2025-03-31 00:00:00"
  "2025-03-31 23:59:59"
]
183 2.20 ms
SELECT MIN(c0_.id) AS sclr_0 FROM cookie c0_
Parameters:
[]
184 0.50 ms
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
  • 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.
App\Entity\Cookie No errors.