1
1.29 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 . email = ? LIMIT 1
Parameters :
[
"dzebada@sifogroup.com "
]
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 . email = 'dzebada@sifogroup.com' LIMIT 1 ;
Copy
2
0.71 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 = 18 ;
Copy
3
0.60 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 = 3 ;
Copy
4
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 = 137 ;
Copy
5
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 = 44 ;
Copy
6
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 = 45 ;
Copy
7
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 = 48 ;
Copy
8
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 = 50 ;
Copy
9
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 = 75 ;
Copy
10
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 = 76 ;
Copy
11
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 = 78 ;
Copy
12
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
13
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 = 80 ;
Copy
14
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 = 81 ;
Copy
15
0.22 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
16
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 = 89 ;
Copy
17
0.22 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
18
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 = 92 ;
Copy
19
0.23 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
20
0.22 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
21
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 = 109 ;
Copy
22
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 = 111 ;
Copy
23
0.23 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
24
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
25
0.23 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
26
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 = 155 ;
Copy
27
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 = 61 ;
Copy
28
0.23 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
29
0.23 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 = 63 ;
Copy
30
0.22 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
31
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 = 65 ;
Copy
32
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 = 66 ;
Copy
33
0.23 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
34
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 = 68 ;
Copy
35
0.79 ms
SELECT b0_ . id AS id_0 , b0_ . super AS super_1 , b0_ . gasoil AS gasoil_2 , b0_ . fuel AS fuel_3 , b0_ . petrol AS petrol_4 , b0_ . date_de_chargement AS date_de_chargement_5 , b0_ . photo_bl AS photo_bl_6 , b0_ . numero AS numero_7 , b0_ . chauffeur AS chauffeur_8 , b0_ . isdepoted AS isdepoted_9 , b0_ . isdraft AS isdraft_10 , b0_ . date_edition AS date_edition_11 , b0_ . is_agent_traited AS is_agent_traited_12 , b0_ . is_validated AS is_validated_13 , b0_ . is_started AS is_started_14 , b0_ . date_arrivee_camion AS date_arrivee_camion_15 , b0_ . date_depart_camion AS date_depart_camion_16 , b0_ . date_debut_depotage AS date_debut_depotage_17 , b0_ . date_fin_depotage AS date_fin_depotage_18 , b0_ . temps_depotage AS temps_depotage_19 , b0_ . is_charged AS is_charged_20 , b0_ . granted AS granted_21 , b0_ . prix_super AS prix_super_22 , b0_ . prix_gasoil AS prix_gasoil_23 , b0_ . prix_fuel AS prix_fuel_24 , b0_ . prix_petrol AS prix_petrol_25 , b0_ . regime_douanier AS regime_douanier_26 , b0_ . differentiel_transport AS differentiel_transport_27 , b0_ . bc_client AS bc_client_28 , b0_ . created_at AS created_at_29 , b0_ . updated_at AS updated_at_30 , b0_ . station_service_id AS station_service_id_31 , b0_ . camion_id AS camion_id_32 , b0_ . lieux_empotage_id AS lieux_empotage_id_33 , b0_ . operation_user_id AS operation_user_id_34 , b0_ . agent_granted_id AS agent_granted_id_35 FROM bon_de_livraison b0_ WHERE b0_ . isdraft = 0 AND b0_ . isdepoted = 0 AND b0_ . is_started = 1 AND b0_ . granted = 1 ORDER BY b0_ . created_at DESC
SELECT b0_ . id AS id_0 , b0_ . super AS super_1 , b0_ . gasoil AS gasoil_2 , b0_ . fuel AS fuel_3 , b0_ . petrol AS petrol_4 , b0_ . date_de_chargement AS date_de_chargement_5 , b0_ . photo_bl AS photo_bl_6 , b0_ . numero AS numero_7 , b0_ . chauffeur AS chauffeur_8 , b0_ . isdepoted AS isdepoted_9 , b0_ . isdraft AS isdraft_10 , b0_ . date_edition AS date_edition_11 , b0_ . is_agent_traited AS is_agent_traited_12 , b0_ . is_validated AS is_validated_13 , b0_ . is_started AS is_started_14 , b0_ . date_arrivee_camion AS date_arrivee_camion_15 , b0_ . date_depart_camion AS date_depart_camion_16 , b0_ . date_debut_depotage AS date_debut_depotage_17 , b0_ . date_fin_depotage AS date_fin_depotage_18 , b0_ . temps_depotage AS temps_depotage_19 , b0_ . is_charged AS is_charged_20 , b0_ . granted AS granted_21 , b0_ . prix_super AS prix_super_22 , b0_ . prix_gasoil AS prix_gasoil_23 , b0_ . prix_fuel AS prix_fuel_24 , b0_ . prix_petrol AS prix_petrol_25 , b0_ . regime_douanier AS regime_douanier_26 , b0_ . differentiel_transport AS differentiel_transport_27 , b0_ . bc_client AS bc_client_28 , b0_ . created_at AS created_at_29 , b0_ . updated_at AS updated_at_30 , b0_ . station_service_id AS station_service_id_31 , b0_ . camion_id AS camion_id_32 , b0_ . lieux_empotage_id AS lieux_empotage_id_33 , b0_ . operation_user_id AS operation_user_id_34 , b0_ . agent_granted_id AS agent_granted_id_35 FROM bon_de_livraison b0_ WHERE b0_ . isdraft = 0 AND b0_ . isdepoted = 0 AND b0_ . is_started = 1 AND b0_ . granted = 1 ORDER BY b0_ . created_at DESC ;
Copy