1
1.36 ms
SELECT t0 . id AS id_1 , t0 . email AS email_2 , t0 . nom AS nom_3 , t0 . prenom AS prenom_4 , t0 . fonction AS fonction_5 , t0 . photo AS photo_6 , t0 . roles AS roles_7 , t0 . refresh_token AS refresh_token_8 , t0 . refresh_token_expires_at AS refresh_token_expires_at_9 , t0 . apps AS apps_10 , t0 . signature AS signature_11 , t0 . fleet_refresh_token AS fleet_refresh_token_12 , t0 . password AS password_13 , t0 . slug AS slug_14 , t0 . created_at AS created_at_15 , t0 . updated_at AS updated_at_16 , t0 . station_id AS station_id_17 , t0 . lieu_empotage_id AS lieu_empotage_id_18 FROM `user` t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . email AS email_2 , t0 . nom AS nom_3 , t0 . prenom AS prenom_4 , t0 . fonction AS fonction_5 , t0 . photo AS photo_6 , t0 . roles AS roles_7 , t0 . refresh_token AS refresh_token_8 , t0 . refresh_token_expires_at AS refresh_token_expires_at_9 , t0 . apps AS apps_10 , t0 . signature AS signature_11 , t0 . fleet_refresh_token AS fleet_refresh_token_12 , t0 . password AS password_13 , t0 . slug AS slug_14 , t0 . created_at AS created_at_15 , t0 . updated_at AS updated_at_16 , t0 . station_id AS station_id_17 , t0 . lieu_empotage_id AS lieu_empotage_id_18 FROM `user` t0 WHERE t0 . id = 21 ;
Copy
2
0.90 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . value AS value_3 FROM role t0 INNER JOIN role_user ON t0 . id = role_user . role_id WHERE role_user . user_id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . value AS value_3 FROM role t0 INNER JOIN role_user ON t0 . id = role_user . role_id WHERE role_user . user_id = 21 ;
Copy
3
0.85 ms
SELECT t0 . id AS id_1 , t0 . entity AS entity_2 , t0 . role_id AS role_id_3 , t0 . permission_id AS permission_id_4 FROM role_permission t0 WHERE t0 . role_id = ?
SELECT t0 . id AS id_1 , t0 . entity AS entity_2 , t0 . role_id AS role_id_3 , t0 . permission_id AS permission_id_4 FROM role_permission t0 WHERE t0 . role_id = 2 ;
Copy
4
0.53 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 138 ;
Copy
5
0.49 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 24 ;
Copy
6
0.44 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 25 ;
Copy
7
0.46 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 44 ;
Copy
8
0.52 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 45 ;
Copy
9
0.34 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 46 ;
Copy
10
0.48 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 47 ;
Copy
11
0.51 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 50 ;
Copy
12
0.39 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 51 ;
Copy
13
0.46 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 54 ;
Copy
14
0.47 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 75 ;
Copy
15
0.39 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 76 ;
Copy
16
0.31 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 78 ;
Copy
17
0.27 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 79 ;
Copy
18
0.31 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 80 ;
Copy
19
0.38 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 81 ;
Copy
20
0.32 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 82 ;
Copy
21
0.27 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 83 ;
Copy
22
0.31 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 89 ;
Copy
23
0.26 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 90 ;
Copy
24
0.34 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 92 ;
Copy
25
0.27 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 93 ;
Copy
26
0.33 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 108 ;
Copy
27
0.29 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 109 ;
Copy
28
0.26 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 111 ;
Copy
29
0.26 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 112 ;
Copy
30
0.26 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 153 ;
Copy
31
0.29 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 154 ;
Copy
32
0.28 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 155 ;
Copy
33
0.30 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 156 ;
Copy
34
0.27 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 61 ;
Copy
35
0.29 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 62 ;
Copy
36
0.30 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 64 ;
Copy
37
0.27 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 65 ;
Copy
38
0.27 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 66 ;
Copy
39
0.24 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 67 ;
Copy
40
0.28 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 68 ;
Copy
41
0.28 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 69 ;
Copy
42
0.30 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 88 ;
Copy
43
0.25 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 97 ;
Copy
44
0.24 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 73 ;
Copy
45
0.26 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 74 ;
Copy
46
0.26 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 99 ;
Copy
47
0.30 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 100 ;
Copy
48
0.26 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 102 ;
Copy
49
0.26 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 103 ;
Copy
50
0.26 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 19 ;
Copy
51
0.28 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 20 ;
Copy
52
0.27 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 129 ;
Copy
53
0.25 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 130 ;
Copy
54
0.29 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 132 ;
Copy
55
0.27 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 133 ;
Copy
56
0.28 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 122 ;
Copy
57
0.27 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 123 ;
Copy
58
0.27 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 125 ;
Copy
59
0.25 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 126 ;
Copy
60
0.28 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 34 ;
Copy
61
0.28 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . entity AS entity_3 , t0 . value AS value_4 FROM permission t0 WHERE t0 . id = 35 ;
Copy
62
1.77 ms
SELECT v0_ . id AS id_0 , v0_ . montant AS montant_1 , v0_ . date AS date_2 , v0_ . reference AS reference_3 , v0_ . justificatif AS justificatif_4 , v0_ . commentaire AS commentaire_5 , v0_ . statut AS statut_6 , v0_ . motif_rejet AS motif_rejet_7 , v0_ . type AS type_8 , v0_ . date_debut AS date_debut_9 , v0_ . date_fin AS date_fin_10 , v0_ . created_at AS created_at_11 , v0_ . updated_at AS updated_at_12 , v0_ . station_id AS station_id_13 , v0_ . banque_id AS banque_id_14 , v0_ . operation_user_id AS operation_user_id_15 FROM versement v0_ WHERE v0_ . date BETWEEN ? AND ? ORDER BY v0_ . date DESC
Parameters :
[
"2026-01-01 00:00:00 "
"2026-12-31 23:59:59 "
]
SELECT v0_ . id AS id_0 , v0_ . montant AS montant_1 , v0_ . date AS date_2 , v0_ . reference AS reference_3 , v0_ . justificatif AS justificatif_4 , v0_ . commentaire AS commentaire_5 , v0_ . statut AS statut_6 , v0_ . motif_rejet AS motif_rejet_7 , v0_ . type AS type_8 , v0_ . date_debut AS date_debut_9 , v0_ . date_fin AS date_fin_10 , v0_ . created_at AS created_at_11 , v0_ . updated_at AS updated_at_12 , v0_ . station_id AS station_id_13 , v0_ . banque_id AS banque_id_14 , v0_ . operation_user_id AS operation_user_id_15 FROM versement v0_ WHERE v0_ . date BETWEEN '2026-01-01 00:00:00' AND '2026-12-31 23:59:59' ORDER BY v0_ . date DESC ;
Copy
63
1.19 ms
SELECT c0_ . id AS id_0 , c0_ . ref AS ref_1 , c0_ . litrage AS litrage_2 , c0_ . montant_accorde AS montant_accorde_3 , c0_ . montant_restant AS montant_restant_4 , c0_ . date AS date_5 , c0_ . echeance AS echeance_6 , c0_ . motif AS motif_7 , c0_ . statut AS statut_8 , c0_ . validation_statut AS validation_statut_9 , c0_ . motif_rejet AS motif_rejet_10 , c0_ . nature AS nature_11 , c0_ . immatriculation AS immatriculation_12 , c0_ . with_echeance AS with_echeance_13 , c0_ . camion_id AS camion_id_14 , c0_ . vehicule_id AS vehicule_id_15 , c0_ . counter_year AS counter_year_16 , c0_ . slug AS slug_17 , c0_ . created_at AS created_at_18 , c0_ . updated_at AS updated_at_19 , c0_ . client_id AS client_id_20 , c0_ . station_id AS station_id_21 , c0_ . produit_id AS produit_id_22 , c0_ . operation_user_id AS operation_user_id_23 , c0_ . type_credit_id AS type_credit_id_24 , c0_ . pompiste_id AS pompiste_id_25 FROM credit c0_ WHERE c0_ . date BETWEEN ? AND ?
Parameters :
[
"2026-01-01 00:00:00 "
"2026-12-31 23:59:59 "
]
SELECT c0_ . id AS id_0 , c0_ . ref AS ref_1 , c0_ . litrage AS litrage_2 , c0_ . montant_accorde AS montant_accorde_3 , c0_ . montant_restant AS montant_restant_4 , c0_ . date AS date_5 , c0_ . echeance AS echeance_6 , c0_ . motif AS motif_7 , c0_ . statut AS statut_8 , c0_ . validation_statut AS validation_statut_9 , c0_ . motif_rejet AS motif_rejet_10 , c0_ . nature AS nature_11 , c0_ . immatriculation AS immatriculation_12 , c0_ . with_echeance AS with_echeance_13 , c0_ . camion_id AS camion_id_14 , c0_ . vehicule_id AS vehicule_id_15 , c0_ . counter_year AS counter_year_16 , c0_ . slug AS slug_17 , c0_ . created_at AS created_at_18 , c0_ . updated_at AS updated_at_19 , c0_ . client_id AS client_id_20 , c0_ . station_id AS station_id_21 , c0_ . produit_id AS produit_id_22 , c0_ . operation_user_id AS operation_user_id_23 , c0_ . type_credit_id AS type_credit_id_24 , c0_ . pompiste_id AS pompiste_id_25 FROM credit c0_ WHERE c0_ . date BETWEEN '2026-01-01 00:00:00' AND '2026-12-31 23:59:59' ;
Copy
64
4.71 ms
SELECT v0_ . id AS id_0 , v0_ . ref AS ref_1 , v0_ . date AS date_2 , v0_ . index_ouverture AS index_ouverture_3 , v0_ . index_cloture AS index_cloture_4 , v0_ . retour_en_cuve AS retour_en_cuve_5 , v0_ . vente AS vente_6 , v0_ . ca AS ca_7 , v0_ . jauge_ouverture AS jauge_ouverture_8 , v0_ . jauge_cloture AS jauge_cloture_9 , v0_ . stock_theorique AS stock_theorique_10 , v0_ . ecart AS ecart_11 , v0_ . stock_cuve_restant AS stock_cuve_restant_12 , v0_ . commentaire AS commentaire_13 , v0_ . statut AS statut_14 , v0_ . motif_rejet AS motif_rejet_15 , v0_ . counter_year AS counter_year_16 , v0_ . created_at AS created_at_17 , v0_ . updated_at AS updated_at_18 , d1_ . id AS id_19 , d1_ . index_ouverture AS index_ouverture_20 , d1_ . index_cloture AS index_cloture_21 , d1_ . retour_en_cuve AS retour_en_cuve_22 , d1_ . produit_vendu AS produit_vendu_23 , d1_ . ca AS ca_24 , d1_ . product_name AS product_name_25 , d1_ . jauge_ouverture AS jauge_ouverture_26 , d1_ . jauge_cloture AS jauge_cloture_27 , d1_ . stock_restant AS stock_restant_28 , d1_ . stock_vendu AS stock_vendu_29 , d1_ . type AS type_30 , d1_ . stock_reception AS stock_reception_31 , d1_ . stock_cuve_av_vente AS stock_cuve_av_vente_32 , d1_ . created_at AS created_at_33 , d1_ . updated_at AS updated_at_34 , v0_ . operation_user_id AS operation_user_id_35 , v0_ . station_id AS station_id_36 , d1_ . pompe_id AS pompe_id_37 , d1_ . vente_id AS vente_id_38 , d1_ . cuve_id AS cuve_id_39 FROM vente v0_ LEFT JOIN details_vente d1_ ON v0_ . id = d1_ . vente_id WHERE YEAR (v0_ . date ) = YEAR (CURRENT_DATE ) ORDER BY v0_ . date ASC
SELECT v0_ . id AS id_0 , v0_ . ref AS ref_1 , v0_ . date AS date_2 , v0_ . index_ouverture AS index_ouverture_3 , v0_ . index_cloture AS index_cloture_4 , v0_ . retour_en_cuve AS retour_en_cuve_5 , v0_ . vente AS vente_6 , v0_ . ca AS ca_7 , v0_ . jauge_ouverture AS jauge_ouverture_8 , v0_ . jauge_cloture AS jauge_cloture_9 , v0_ . stock_theorique AS stock_theorique_10 , v0_ . ecart AS ecart_11 , v0_ . stock_cuve_restant AS stock_cuve_restant_12 , v0_ . commentaire AS commentaire_13 , v0_ . statut AS statut_14 , v0_ . motif_rejet AS motif_rejet_15 , v0_ . counter_year AS counter_year_16 , v0_ . created_at AS created_at_17 , v0_ . updated_at AS updated_at_18 , d1_ . id AS id_19 , d1_ . index_ouverture AS index_ouverture_20 , d1_ . index_cloture AS index_cloture_21 , d1_ . retour_en_cuve AS retour_en_cuve_22 , d1_ . produit_vendu AS produit_vendu_23 , d1_ . ca AS ca_24 , d1_ . product_name AS product_name_25 , d1_ . jauge_ouverture AS jauge_ouverture_26 , d1_ . jauge_cloture AS jauge_cloture_27 , d1_ . stock_restant AS stock_restant_28 , d1_ . stock_vendu AS stock_vendu_29 , d1_ . type AS type_30 , d1_ . stock_reception AS stock_reception_31 , d1_ . stock_cuve_av_vente AS stock_cuve_av_vente_32 , d1_ . created_at AS created_at_33 , d1_ . updated_at AS updated_at_34 , v0_ . operation_user_id AS operation_user_id_35 , v0_ . station_id AS station_id_36 , d1_ . pompe_id AS pompe_id_37 , d1_ . vente_id AS vente_id_38 , d1_ . cuve_id AS cuve_id_39 FROM vente v0_ LEFT JOIN details_vente d1_ ON v0_ . id = d1_ . vente_id WHERE YEAR (v0_ . date ) = YEAR (CURRENT_DATE ) ORDER BY v0_ . date ASC ;
Copy
65
0.64 ms
SELECT COUNT (c0_ . id ) AS sclr_0 FROM credit c0_ WHERE c0_ . statut IN (? , ? ) AND c0_ . echeance < ?
Parameters :
[
"actif "
"en_retard "
"2026-09-24 14:55:19 "
]
SELECT COUNT (c0_ . id ) AS sclr_0 FROM credit c0_ WHERE c0_ . statut IN ('actif' , 'en_retard' ) AND c0_ . echeance < '2026-09-24 14:55:19' ;
Copy
66
0.52 ms
SELECT COUNT (c0_ . id ) AS sclr_0 FROM credit c0_ WHERE c0_ . statut = ? AND c0_ . echeance > = ? AND c0_ . echeance < = ?
Parameters :
[
"actif "
"2026-09-24 14:55:19 "
"2026-10-08 14:55:19 "
]
SELECT COUNT (c0_ . id ) AS sclr_0 FROM credit c0_ WHERE c0_ . statut = 'actif' AND c0_ . echeance > = '2026-09-24 14:55:19' AND c0_ . echeance < = '2026-10-08 14:55:19' ;
Copy
67
0.50 ms
SELECT COUNT (c0_ . id ) AS sclr_0 FROM credit c0_ WHERE c0_ . statut = ? AND c0_ . montant_restant > 0 AND c0_ . echeance < ?
Parameters :
[
"actif "
"2026-09-24 14:55:19 "
]
SELECT COUNT (c0_ . id ) AS sclr_0 FROM credit c0_ WHERE c0_ . statut = 'actif' AND c0_ . montant_restant > 0 AND c0_ . echeance < '2026-09-24 14:55:19' ;
Copy
68
0.42 ms
SELECT COUNT (c0_ . id ) AS sclr_0 FROM credit c0_ WHERE c0_ . statut = ?
SELECT COUNT (c0_ . id ) AS sclr_0 FROM credit c0_ WHERE c0_ . statut = 'solde' ;
Copy
69
0.49 ms
SELECT COALESCE (SUM (c0_ . montant_restant ), 0 ) AS sclr_0 FROM credit c0_ WHERE c0_ . statut = ?
SELECT COALESCE (SUM (c0_ . montant_restant ), 0 ) AS sclr_0 FROM credit c0_ WHERE c0_ . statut = 'actif' ;
Copy
70
0.65 ms
SELECT COUNT (DISTINCT c0_ . client_id ) AS sclr_0 FROM credit c0_ WHERE c0_ . statut = ?
SELECT COUNT (DISTINCT c0_ . client_id ) AS sclr_0 FROM credit c0_ WHERE c0_ . statut = 'actif' ;
Copy
71
0.49 ms
SELECT COALESCE (AVG (c0_ . montant_accorde ), 0 ) AS sclr_0 FROM credit c0_ WHERE c0_ . statut = ?
SELECT COALESCE (AVG (c0_ . montant_accorde ), 0 ) AS sclr_0 FROM credit c0_ WHERE c0_ . statut = 'actif' ;
Copy
72
0.94 ms
SELECT DATE_FORMAT (r0_ . date , '%Y-%m' ) AS sclr_0 , DATE_FORMAT (r0_ . date , '%b %y' ) AS sclr_1 , SUM (r0_ . montant ) AS sclr_2 FROM regelement_credit r0_ WHERE r0_ . date > = ? GROUP BY sclr_0 , sclr_1 ORDER BY sclr_0 ASC
Parameters :
[
"2026-03-24 14:55:19 "
]
SELECT DATE_FORMAT (r0_ . date , '%Y-%m' ) AS sclr_0 , DATE_FORMAT (r0_ . date , '%b %y' ) AS sclr_1 , SUM (r0_ . montant ) AS sclr_2 FROM regelement_credit r0_ WHERE r0_ . date > = '2026-03-24 14:55:19' GROUP BY sclr_0 , sclr_1 ORDER BY sclr_0 ASC ;
Copy
73
0.60 ms
SELECT DATE_FORMAT (r0_ . date , '%Y-%m' ) AS sclr_0 , SUM (c1_ . montant_accorde ) AS sclr_1 FROM regelement_credit r0_ INNER JOIN credit c1_ ON r0_ . credit_id = c1_ . id WHERE r0_ . date > = ? GROUP BY sclr_0
Parameters :
[
"2026-03-24 14:55:19 "
]
SELECT DATE_FORMAT (r0_ . date , '%Y-%m' ) AS sclr_0 , SUM (c1_ . montant_accorde ) AS sclr_1 FROM regelement_credit r0_ INNER JOIN credit c1_ ON r0_ . credit_id = c1_ . id WHERE r0_ . date > = '2026-03-24 14:55:19' GROUP BY sclr_0 ;
Copy
74
0.92 ms
SELECT c0_ . raison_sociale AS raison_sociale_0 , SUM (c1_ . montant_accorde ) AS sclr_1 , COALESCE (SUM (c1_ . montant_restant ), 0 ) AS sclr_2 FROM credit c1_ INNER JOIN client c0_ ON c1_ . client_id = c0_ . id WHERE c1_ . statut IN (? , ? ) GROUP BY c0_ . id , c0_ . raison_sociale ORDER BY sclr_1 DESC LIMIT 6
Parameters :
[
"actif "
"en_retard "
]
SELECT c0_ . raison_sociale AS raison_sociale_0 , SUM (c1_ . montant_accorde ) AS sclr_1 , COALESCE (SUM (c1_ . montant_restant ), 0 ) AS sclr_2 FROM credit c1_ INNER JOIN client c0_ ON c1_ . client_id = c0_ . id WHERE c1_ . statut IN ('actif' , 'en_retard' ) GROUP BY c0_ . id , c0_ . raison_sociale ORDER BY sclr_1 DESC LIMIT 6 ;
Copy
75
0.78 ms
SELECT c0_ . raison_sociale AS raison_sociale_0 , c0_ . cumule_credit AS cumule_credit_1 , c0_ . plafond_credit AS plafond_credit_2 FROM credit c1_ INNER JOIN client c0_ ON c1_ . client_id = c0_ . id WHERE c1_ . statut = ? AND c0_ . plafond_credit > 0 GROUP BY c0_ . id , c0_ . raison_sociale , c0_ . cumule_credit , c0_ . plafond_credit ORDER BY c0_ . cumule_credit DESC LIMIT 10
SELECT c0_ . raison_sociale AS raison_sociale_0 , c0_ . cumule_credit AS cumule_credit_1 , c0_ . plafond_credit AS plafond_credit_2 FROM credit c1_ INNER JOIN client c0_ ON c1_ . client_id = c0_ . id WHERE c1_ . statut = 'actif' AND c0_ . plafond_credit > 0 GROUP BY c0_ . id , c0_ . raison_sociale , c0_ . cumule_credit , c0_ . plafond_credit ORDER BY c0_ . cumule_credit DESC LIMIT 10 ;
Copy
76
1.43 ms
SELECT v0_ . id AS id_0 , v0_ . montant AS montant_1 , v0_ . date AS date_2 , v0_ . reference AS reference_3 , v0_ . justificatif AS justificatif_4 , v0_ . commentaire AS commentaire_5 , v0_ . statut AS statut_6 , v0_ . motif_rejet AS motif_rejet_7 , v0_ . type AS type_8 , v0_ . date_debut AS date_debut_9 , v0_ . date_fin AS date_fin_10 , v0_ . created_at AS created_at_11 , v0_ . updated_at AS updated_at_12 , s1_ . id AS id_13 , s1_ . libelle AS libelle_14 , s1_ . ref_client AS ref_client_15 , s1_ . latitude AS latitude_16 , s1_ . longitude AS longitude_17 , s1_ . created_at AS created_at_18 , s1_ . updated_at AS updated_at_19 , b2_ . id AS id_20 , b2_ . name AS name_21 , b2_ . code AS code_22 , b2_ . numero_compte AS numero_compte_23 , b2_ . statut AS statut_24 , b2_ . created_at AS created_at_25 , b2_ . updated_at AS updated_at_26 , v0_ . station_id AS station_id_27 , v0_ . banque_id AS banque_id_28 , v0_ . operation_user_id AS operation_user_id_29 , s1_ . localite_id AS localite_id_30 FROM versement v0_ LEFT JOIN station_service s1_ ON v0_ . station_id = s1_ . id LEFT JOIN banque b2_ ON v0_ . banque_id = b2_ . id ORDER BY v0_ . date DESC LIMIT 8
SELECT v0_ . id AS id_0 , v0_ . montant AS montant_1 , v0_ . date AS date_2 , v0_ . reference AS reference_3 , v0_ . justificatif AS justificatif_4 , v0_ . commentaire AS commentaire_5 , v0_ . statut AS statut_6 , v0_ . motif_rejet AS motif_rejet_7 , v0_ . type AS type_8 , v0_ . date_debut AS date_debut_9 , v0_ . date_fin AS date_fin_10 , v0_ . created_at AS created_at_11 , v0_ . updated_at AS updated_at_12 , s1_ . id AS id_13 , s1_ . libelle AS libelle_14 , s1_ . ref_client AS ref_client_15 , s1_ . latitude AS latitude_16 , s1_ . longitude AS longitude_17 , s1_ . created_at AS created_at_18 , s1_ . updated_at AS updated_at_19 , b2_ . id AS id_20 , b2_ . name AS name_21 , b2_ . code AS code_22 , b2_ . numero_compte AS numero_compte_23 , b2_ . statut AS statut_24 , b2_ . created_at AS created_at_25 , b2_ . updated_at AS updated_at_26 , v0_ . station_id AS station_id_27 , v0_ . banque_id AS banque_id_28 , v0_ . operation_user_id AS operation_user_id_29 , s1_ . localite_id AS localite_id_30 FROM versement v0_ LEFT JOIN station_service s1_ ON v0_ . station_id = s1_ . id LEFT JOIN banque b2_ ON v0_ . banque_id = b2_ . id ORDER BY v0_ . date DESC LIMIT 8 ;
Copy
77
0.88 ms
SELECT v0_ . id AS id_0 , v0_ . ref AS ref_1 , v0_ . date AS date_2 , v0_ . index_ouverture AS index_ouverture_3 , v0_ . index_cloture AS index_cloture_4 , v0_ . retour_en_cuve AS retour_en_cuve_5 , v0_ . vente AS vente_6 , v0_ . ca AS ca_7 , v0_ . jauge_ouverture AS jauge_ouverture_8 , v0_ . jauge_cloture AS jauge_cloture_9 , v0_ . stock_theorique AS stock_theorique_10 , v0_ . ecart AS ecart_11 , v0_ . stock_cuve_restant AS stock_cuve_restant_12 , v0_ . commentaire AS commentaire_13 , v0_ . statut AS statut_14 , v0_ . motif_rejet AS motif_rejet_15 , v0_ . counter_year AS counter_year_16 , v0_ . created_at AS created_at_17 , v0_ . updated_at AS updated_at_18 , s1_ . id AS id_19 , s1_ . libelle AS libelle_20 , s1_ . ref_client AS ref_client_21 , s1_ . latitude AS latitude_22 , s1_ . longitude AS longitude_23 , s1_ . created_at AS created_at_24 , s1_ . updated_at AS updated_at_25 , v0_ . operation_user_id AS operation_user_id_26 , v0_ . station_id AS station_id_27 , s1_ . localite_id AS localite_id_28 FROM vente v0_ LEFT JOIN station_service s1_ ON v0_ . station_id = s1_ . id ORDER BY v0_ . date DESC , v0_ . id DESC LIMIT 8
SELECT v0_ . id AS id_0 , v0_ . ref AS ref_1 , v0_ . date AS date_2 , v0_ . index_ouverture AS index_ouverture_3 , v0_ . index_cloture AS index_cloture_4 , v0_ . retour_en_cuve AS retour_en_cuve_5 , v0_ . vente AS vente_6 , v0_ . ca AS ca_7 , v0_ . jauge_ouverture AS jauge_ouverture_8 , v0_ . jauge_cloture AS jauge_cloture_9 , v0_ . stock_theorique AS stock_theorique_10 , v0_ . ecart AS ecart_11 , v0_ . stock_cuve_restant AS stock_cuve_restant_12 , v0_ . commentaire AS commentaire_13 , v0_ . statut AS statut_14 , v0_ . motif_rejet AS motif_rejet_15 , v0_ . counter_year AS counter_year_16 , v0_ . created_at AS created_at_17 , v0_ . updated_at AS updated_at_18 , s1_ . id AS id_19 , s1_ . libelle AS libelle_20 , s1_ . ref_client AS ref_client_21 , s1_ . latitude AS latitude_22 , s1_ . longitude AS longitude_23 , s1_ . created_at AS created_at_24 , s1_ . updated_at AS updated_at_25 , v0_ . operation_user_id AS operation_user_id_26 , v0_ . station_id AS station_id_27 , s1_ . localite_id AS localite_id_28 FROM vente v0_ LEFT JOIN station_service s1_ ON v0_ . station_id = s1_ . id ORDER BY v0_ . date DESC , v0_ . id DESC LIMIT 8 ;
Copy
78
0.46 ms
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . ref_client AS ref_client_3 , t0 . latitude AS latitude_4 , t0 . longitude AS longitude_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . localite_id AS localite_id_8 FROM station_service t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . ref_client AS ref_client_3 , t0 . latitude AS latitude_4 , t0 . longitude AS longitude_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . localite_id AS localite_id_8 FROM station_service t0 WHERE t0 . id = 5 ;
Copy
79
0.89 ms
SELECT b0_ . name AS name_0 , COALESCE (SUM (v1_ . montant ), 0 ) AS sclr_1 FROM versement v1_ INNER JOIN banque b0_ ON v1_ . banque_id = b0_ . id WHERE v1_ . statut = ? GROUP BY b0_ . id , b0_ . name ORDER BY sclr_1 DESC LIMIT 10
SELECT b0_ . name AS name_0 , COALESCE (SUM (v1_ . montant ), 0 ) AS sclr_1 FROM versement v1_ INNER JOIN banque b0_ ON v1_ . banque_id = b0_ . id WHERE v1_ . statut = 'valide' GROUP BY b0_ . id , b0_ . name ORDER BY sclr_1 DESC LIMIT 10 ;
Copy
80
0.79 ms
SELECT DATE_FORMAT (v0_ . date , '%Y-%m' ) AS sclr_0 , DATE_FORMAT (v0_ . date , '%b %Y' ) AS sclr_1 , COALESCE (SUM (v0_ . montant ), 0 ) AS sclr_2 FROM versement v0_ WHERE v0_ . statut = ? AND v0_ . date > = ? GROUP BY sclr_0 , sclr_1 ORDER BY sclr_0 ASC
Parameters :
[
"valide "
"2025-09-24 14:55:19 "
]
SELECT DATE_FORMAT (v0_ . date , '%Y-%m' ) AS sclr_0 , DATE_FORMAT (v0_ . date , '%b %Y' ) AS sclr_1 , COALESCE (SUM (v0_ . montant ), 0 ) AS sclr_2 FROM versement v0_ WHERE v0_ . statut = 'valide' AND v0_ . date > = '2025-09-24 14:55:19' GROUP BY sclr_0 , sclr_1 ORDER BY sclr_0 ASC ;
Copy
81
0.79 ms
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . need_camion AS need_camion_3 , t0 . need_vehicule AS need_vehicule_4 , t0 . need_litrage_field AS need_litrage_field_5 , t0 . need_pompiste AS need_pompiste_6 , t0 . need_motif AS need_motif_7 , t0 . need_immatriculation_field AS need_immatriculation_field_8 , t0 . need_nature_field AS need_nature_field_9 FROM type_credit t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . need_camion AS need_camion_3 , t0 . need_vehicule AS need_vehicule_4 , t0 . need_litrage_field AS need_litrage_field_5 , t0 . need_pompiste AS need_pompiste_6 , t0 . need_motif AS need_motif_7 , t0 . need_immatriculation_field AS need_immatriculation_field_8 , t0 . need_nature_field AS need_nature_field_9 FROM type_credit t0 WHERE t0 . id = 1 ;
Copy
82
0.78 ms
SELECT p0_ . libelle AS libelle_0 , p1_ . prix AS prix_1 FROM prix_produit p1_ LEFT JOIN produit p0_ ON (p0_ . id = p1_ . produit_id ) WHERE YEAR (p1_ . date ) = ? AND MONTH (p1_ . date ) = ?
SELECT p0_ . libelle AS libelle_0 , p1_ . prix AS prix_1 FROM prix_produit p1_ LEFT JOIN produit p0_ ON (p0_ . id = p1_ . produit_id ) WHERE YEAR (p1_ . date ) = 2026 AND MONTH (p1_ . date ) = 9 ;
Copy
83
0.46 ms
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . code AS code_3 FROM produit t0
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . code AS code_3 FROM produit t0 ;
Copy