1
1.43 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 :
[
"gbetta@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 = 'gbetta@sifogroup.com' LIMIT 1 ;
Copy
2
1.04 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 = 15 ;
Copy
3
0.54 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 = 4 ;
Copy
4
0.43 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.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 = 44 ;
Copy
6
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 = 45 ;
Copy
7
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 = 46 ;
Copy
8
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 = 50 ;
Copy
9
0.20 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
10
0.21 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 = 52 ;
Copy
11
0.19 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 = 53 ;
Copy
12
0.19 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
13
1.25 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 , l1_ . id AS id_31 , l1_ . label AS label_32 , l1_ . latitude AS latitude_33 , l1_ . longitude AS longitude_34 , l1_ . created_at AS created_at_35 , l1_ . updated_at AS updated_at_36 , l1_ . slug AS slug_37 , b0_ . station_service_id AS station_service_id_38 , b0_ . camion_id AS camion_id_39 , b0_ . lieux_empotage_id AS lieux_empotage_id_40 , b0_ . operation_user_id AS operation_user_id_41 , b0_ . agent_granted_id AS agent_granted_id_42 FROM bon_de_livraison b0_ LEFT JOIN lieu_empotage l1_ ON b0_ . lieux_empotage_id = l1_ . id WHERE b0_ . isdraft = 0 AND b0_ . granted = 1 AND l1_ . id = ? AND b0_ . isdepoted = 1 AND b0_ . is_validated = 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 ,
l1_ . id AS id_31 ,
l1_ . label AS label_32 ,
l1_ . latitude AS latitude_33 ,
l1_ . longitude AS longitude_34 ,
l1_ . created_at AS created_at_35 ,
l1_ . updated_at AS updated_at_36 ,
l1_ . slug AS slug_37 ,
b0_ . station_service_id AS station_service_id_38 ,
b0_ . camion_id AS camion_id_39 ,
b0_ . lieux_empotage_id AS lieux_empotage_id_40 ,
b0_ . operation_user_id AS operation_user_id_41 ,
b0_ . agent_granted_id AS agent_granted_id_42
FROM
bon_de_livraison b0_
LEFT JOIN lieu_empotage l1_ ON b0_ . lieux_empotage_id = l1_ . id
WHERE
b0_ . isdraft = 0
AND b0_ . granted = 1
AND l1_ . id = ?
AND b0_ . isdepoted = 1
AND b0_ . is_validated = 1
ORDER BY
b0_ . created_at DESC
Copy
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 , l1_ . id AS id_31 , l1_ . label AS label_32 , l1_ . latitude AS latitude_33 , l1_ . longitude AS longitude_34 , l1_ . created_at AS created_at_35 , l1_ . updated_at AS updated_at_36 , l1_ . slug AS slug_37 , b0_ . station_service_id AS station_service_id_38 , b0_ . camion_id AS camion_id_39 , b0_ . lieux_empotage_id AS lieux_empotage_id_40 , b0_ . operation_user_id AS operation_user_id_41 , b0_ . agent_granted_id AS agent_granted_id_42 FROM bon_de_livraison b0_ LEFT JOIN lieu_empotage l1_ ON b0_ . lieux_empotage_id = l1_ . id WHERE b0_ . isdraft = 0 AND b0_ . granted = 1 AND l1_ . id = 2 AND b0_ . isdepoted = 1 AND b0_ . is_validated = 1 ORDER BY b0_ . created_at DESC ;
Copy
14
0.41 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 = 1 ;
Copy
15
0.48 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . differentiel_transport AS differentiel_transport_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 . slug AS slug_8 FROM localite t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . differentiel_transport AS differentiel_transport_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 . slug AS slug_8 FROM localite t0 WHERE t0 . id = 4 ;
Copy
16
0.47 ms
SELECT t0 . id AS id_1 , t0 . chauffeur AS chauffeur_2 , t0 . parking AS parking_3 , t0 . status AS status_4 , t0 . tractor_id AS tractor_id_5 , t0 . trailer_id AS trailer_id_6 FROM camion t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . chauffeur AS chauffeur_2 , t0 . parking AS parking_3 , t0 . status AS status_4 , t0 . tractor_id AS tractor_id_5 , t0 . trailer_id AS trailer_id_6 FROM camion t0 WHERE t0 . id = 33 ;
Copy
17
0.47 ms
SELECT t0 . id AS id_1 , t0 . immatriculation AS immatriculation_2 , t0 . capacity AS capacity_3 , t0 . nbrcompatiment AS nbrcompatiment_4 , t0 . typeatelage AS typeatelage_5 , t0 . company AS company_6 , t0 . slug AS slug_7 , t0 . marque AS marque_8 , t0 . created_at AS created_at_9 , t0 . updated_at AS updated_at_10 , t0 . tractor_id AS tractor_id_11 , t0 . carburant_id AS carburant_id_12 FROM trailer t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . immatriculation AS immatriculation_2 , t0 . capacity AS capacity_3 , t0 . nbrcompatiment AS nbrcompatiment_4 , t0 . typeatelage AS typeatelage_5 , t0 . company AS company_6 , t0 . slug AS slug_7 , t0 . marque AS marque_8 , t0 . created_at AS created_at_9 , t0 . updated_at AS updated_at_10 , t0 . tractor_id AS tractor_id_11 , t0 . carburant_id AS carburant_id_12 FROM trailer t0 WHERE t0 . id = 29 ;
Copy
18
0.53 ms
SELECT t0 . id AS id_1 , t0 . numero AS numero_2 , t0 . capacity AS capacity_3 , t0 . creux_certificat AS creux_certificat_4 , t0 . status AS status_5 , t0 . trailer_id AS trailer_id_6 FROM compartiment t0 WHERE t0 . trailer_id = ?
SELECT t0 . id AS id_1 , t0 . numero AS numero_2 , t0 . capacity AS capacity_3 , t0 . creux_certificat AS creux_certificat_4 , t0 . status AS status_5 , t0 . trailer_id AS trailer_id_6 FROM compartiment t0 WHERE t0 . trailer_id = 29 ;
Copy
19
0.57 ms
SELECT t0 . id AS id_1 , t0 . creux_gestoci AS creux_gestoci_2 , t0 . dif_creux_certifier_vs_creux_gestoci AS dif_creux_certifier_vs_creux_gestoci_3 , t0 . creux_station AS creux_station_4 , t0 . dif_creux_gestoci_vs_creux_station AS dif_creux_gestoci_vs_creux_station_5 , t0 . ecart AS ecart_6 , t0 . contre_plain AS contre_plain_7 , t0 . date_debut_depotage AS date_debut_depotage_8 , t0 . date_fin_depotage AS date_fin_depotage_9 , t0 . temps_depotage AS temps_depotage_10 , t0 . commentaire AS commentaire_11 , t0 . stock_avant_depotage AS stock_avant_depotage_12 , t0 . stock_apres_depotage AS stock_apres_depotage_13 , t0 . stock_theorique AS stock_theorique_14 , t0 . stock_reel AS stock_reel_15 , t0 . bon_de_livraison_id AS bon_de_livraison_id_16 , t0 . compartiment_id AS compartiment_id_17 , t0 . produit_id AS produit_id_18 , t0 . jaugeur_id AS jaugeur_id_19 , t0 . gerant_id AS gerant_id_20 FROM detail_bon_de_livraison t0 WHERE t0 . bon_de_livraison_id = ?
SELECT t0 . id AS id_1 , t0 . creux_gestoci AS creux_gestoci_2 , t0 . dif_creux_certifier_vs_creux_gestoci AS dif_creux_certifier_vs_creux_gestoci_3 , t0 . creux_station AS creux_station_4 , t0 . dif_creux_gestoci_vs_creux_station AS dif_creux_gestoci_vs_creux_station_5 , t0 . ecart AS ecart_6 , t0 . contre_plain AS contre_plain_7 , t0 . date_debut_depotage AS date_debut_depotage_8 , t0 . date_fin_depotage AS date_fin_depotage_9 , t0 . temps_depotage AS temps_depotage_10 , t0 . commentaire AS commentaire_11 , t0 . stock_avant_depotage AS stock_avant_depotage_12 , t0 . stock_apres_depotage AS stock_apres_depotage_13 , t0 . stock_theorique AS stock_theorique_14 , t0 . stock_reel AS stock_reel_15 , t0 . bon_de_livraison_id AS bon_de_livraison_id_16 , t0 . compartiment_id AS compartiment_id_17 , t0 . produit_id AS produit_id_18 , t0 . jaugeur_id AS jaugeur_id_19 , t0 . gerant_id AS gerant_id_20 FROM detail_bon_de_livraison t0 WHERE t0 . bon_de_livraison_id = 6 ;
Copy
20
0.28 ms
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . code AS code_3 FROM produit t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . code AS code_3 FROM produit t0 WHERE t0 . id = 2 ;
Copy
21
0.33 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 = 14 ;
Copy
22
0.28 ms
SELECT t0 . id AS id_1 , t0 . chauffeur AS chauffeur_2 , t0 . parking AS parking_3 , t0 . status AS status_4 , t0 . tractor_id AS tractor_id_5 , t0 . trailer_id AS trailer_id_6 FROM camion t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . chauffeur AS chauffeur_2 , t0 . parking AS parking_3 , t0 . status AS status_4 , t0 . tractor_id AS tractor_id_5 , t0 . trailer_id AS trailer_id_6 FROM camion t0 WHERE t0 . id = 29 ;
Copy
23
0.25 ms
SELECT t0 . id AS id_1 , t0 . immatriculation AS immatriculation_2 , t0 . capacity AS capacity_3 , t0 . nbrcompatiment AS nbrcompatiment_4 , t0 . typeatelage AS typeatelage_5 , t0 . company AS company_6 , t0 . slug AS slug_7 , t0 . marque AS marque_8 , t0 . created_at AS created_at_9 , t0 . updated_at AS updated_at_10 , t0 . tractor_id AS tractor_id_11 , t0 . carburant_id AS carburant_id_12 FROM trailer t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . immatriculation AS immatriculation_2 , t0 . capacity AS capacity_3 , t0 . nbrcompatiment AS nbrcompatiment_4 , t0 . typeatelage AS typeatelage_5 , t0 . company AS company_6 , t0 . slug AS slug_7 , t0 . marque AS marque_8 , t0 . created_at AS created_at_9 , t0 . updated_at AS updated_at_10 , t0 . tractor_id AS tractor_id_11 , t0 . carburant_id AS carburant_id_12 FROM trailer t0 WHERE t0 . id = 8 ;
Copy
24
0.27 ms
SELECT t0 . id AS id_1 , t0 . numero AS numero_2 , t0 . capacity AS capacity_3 , t0 . creux_certificat AS creux_certificat_4 , t0 . status AS status_5 , t0 . trailer_id AS trailer_id_6 FROM compartiment t0 WHERE t0 . trailer_id = ?
SELECT t0 . id AS id_1 , t0 . numero AS numero_2 , t0 . capacity AS capacity_3 , t0 . creux_certificat AS creux_certificat_4 , t0 . status AS status_5 , t0 . trailer_id AS trailer_id_6 FROM compartiment t0 WHERE t0 . trailer_id = 8 ;
Copy
25
0.50 ms
SELECT t0 . id AS id_1 , t0 . immatriculation AS immatriculation_2 , t0 . company AS company_3 , t0 . marque AS marque_4 , t0 . slug AS slug_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t8 . id AS id_9 , t8 . immatriculation AS immatriculation_10 , t8 . capacity AS capacity_11 , t8 . nbrcompatiment AS nbrcompatiment_12 , t8 . typeatelage AS typeatelage_13 , t8 . company AS company_14 , t8 . slug AS slug_15 , t8 . marque AS marque_16 , t8 . created_at AS created_at_17 , t8 . updated_at AS updated_at_18 , t8 . tractor_id AS tractor_id_19 , t8 . carburant_id AS carburant_id_20 , t0 . carburant_id AS carburant_id_21 FROM tractor t0 LEFT JOIN trailer t8 ON t8 . tractor_id = t0 . id WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . immatriculation AS immatriculation_2 , t0 . company AS company_3 , t0 . marque AS marque_4 , t0 . slug AS slug_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t8 . id AS id_9 , t8 . immatriculation AS immatriculation_10 , t8 . capacity AS capacity_11 , t8 . nbrcompatiment AS nbrcompatiment_12 , t8 . typeatelage AS typeatelage_13 , t8 . company AS company_14 , t8 . slug AS slug_15 , t8 . marque AS marque_16 , t8 . created_at AS created_at_17 , t8 . updated_at AS updated_at_18 , t8 . tractor_id AS tractor_id_19 , t8 . carburant_id AS carburant_id_20 , t0 . carburant_id AS carburant_id_21 FROM tractor t0 LEFT JOIN trailer t8 ON t8 . tractor_id = t0 . id WHERE t0 . id = 17 ;
Copy
26
0.39 ms
SELECT t0 . id AS id_1 , t0 . creux_gestoci AS creux_gestoci_2 , t0 . dif_creux_certifier_vs_creux_gestoci AS dif_creux_certifier_vs_creux_gestoci_3 , t0 . creux_station AS creux_station_4 , t0 . dif_creux_gestoci_vs_creux_station AS dif_creux_gestoci_vs_creux_station_5 , t0 . ecart AS ecart_6 , t0 . contre_plain AS contre_plain_7 , t0 . date_debut_depotage AS date_debut_depotage_8 , t0 . date_fin_depotage AS date_fin_depotage_9 , t0 . temps_depotage AS temps_depotage_10 , t0 . commentaire AS commentaire_11 , t0 . stock_avant_depotage AS stock_avant_depotage_12 , t0 . stock_apres_depotage AS stock_apres_depotage_13 , t0 . stock_theorique AS stock_theorique_14 , t0 . stock_reel AS stock_reel_15 , t0 . bon_de_livraison_id AS bon_de_livraison_id_16 , t0 . compartiment_id AS compartiment_id_17 , t0 . produit_id AS produit_id_18 , t0 . jaugeur_id AS jaugeur_id_19 , t0 . gerant_id AS gerant_id_20 FROM detail_bon_de_livraison t0 WHERE t0 . bon_de_livraison_id = ?
SELECT t0 . id AS id_1 , t0 . creux_gestoci AS creux_gestoci_2 , t0 . dif_creux_certifier_vs_creux_gestoci AS dif_creux_certifier_vs_creux_gestoci_3 , t0 . creux_station AS creux_station_4 , t0 . dif_creux_gestoci_vs_creux_station AS dif_creux_gestoci_vs_creux_station_5 , t0 . ecart AS ecart_6 , t0 . contre_plain AS contre_plain_7 , t0 . date_debut_depotage AS date_debut_depotage_8 , t0 . date_fin_depotage AS date_fin_depotage_9 , t0 . temps_depotage AS temps_depotage_10 , t0 . commentaire AS commentaire_11 , t0 . stock_avant_depotage AS stock_avant_depotage_12 , t0 . stock_apres_depotage AS stock_apres_depotage_13 , t0 . stock_theorique AS stock_theorique_14 , t0 . stock_reel AS stock_reel_15 , t0 . bon_de_livraison_id AS bon_de_livraison_id_16 , t0 . compartiment_id AS compartiment_id_17 , t0 . produit_id AS produit_id_18 , t0 . jaugeur_id AS jaugeur_id_19 , t0 . gerant_id AS gerant_id_20 FROM detail_bon_de_livraison t0 WHERE t0 . bon_de_livraison_id = 3 ;
Copy
27
0.22 ms
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . code AS code_3 FROM produit t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . code AS code_3 FROM produit t0 WHERE t0 . id = 1 ;
Copy
28
0.26 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 = 6 ;
Copy
29
0.25 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . differentiel_transport AS differentiel_transport_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 . slug AS slug_8 FROM localite t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . differentiel_transport AS differentiel_transport_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 . slug AS slug_8 FROM localite t0 WHERE t0 . id = 6 ;
Copy
30
0.23 ms
SELECT t0 . id AS id_1 , t0 . chauffeur AS chauffeur_2 , t0 . parking AS parking_3 , t0 . status AS status_4 , t0 . tractor_id AS tractor_id_5 , t0 . trailer_id AS trailer_id_6 FROM camion t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . chauffeur AS chauffeur_2 , t0 . parking AS parking_3 , t0 . status AS status_4 , t0 . tractor_id AS tractor_id_5 , t0 . trailer_id AS trailer_id_6 FROM camion t0 WHERE t0 . id = 32 ;
Copy
31
0.26 ms
SELECT t0 . id AS id_1 , t0 . immatriculation AS immatriculation_2 , t0 . capacity AS capacity_3 , t0 . nbrcompatiment AS nbrcompatiment_4 , t0 . typeatelage AS typeatelage_5 , t0 . company AS company_6 , t0 . slug AS slug_7 , t0 . marque AS marque_8 , t0 . created_at AS created_at_9 , t0 . updated_at AS updated_at_10 , t0 . tractor_id AS tractor_id_11 , t0 . carburant_id AS carburant_id_12 FROM trailer t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . immatriculation AS immatriculation_2 , t0 . capacity AS capacity_3 , t0 . nbrcompatiment AS nbrcompatiment_4 , t0 . typeatelage AS typeatelage_5 , t0 . company AS company_6 , t0 . slug AS slug_7 , t0 . marque AS marque_8 , t0 . created_at AS created_at_9 , t0 . updated_at AS updated_at_10 , t0 . tractor_id AS tractor_id_11 , t0 . carburant_id AS carburant_id_12 FROM trailer t0 WHERE t0 . id = 28 ;
Copy
32
0.28 ms
SELECT t0 . id AS id_1 , t0 . numero AS numero_2 , t0 . capacity AS capacity_3 , t0 . creux_certificat AS creux_certificat_4 , t0 . status AS status_5 , t0 . trailer_id AS trailer_id_6 FROM compartiment t0 WHERE t0 . trailer_id = ?
SELECT t0 . id AS id_1 , t0 . numero AS numero_2 , t0 . capacity AS capacity_3 , t0 . creux_certificat AS creux_certificat_4 , t0 . status AS status_5 , t0 . trailer_id AS trailer_id_6 FROM compartiment t0 WHERE t0 . trailer_id = 28 ;
Copy
33
0.38 ms
SELECT t0 . id AS id_1 , t0 . creux_gestoci AS creux_gestoci_2 , t0 . dif_creux_certifier_vs_creux_gestoci AS dif_creux_certifier_vs_creux_gestoci_3 , t0 . creux_station AS creux_station_4 , t0 . dif_creux_gestoci_vs_creux_station AS dif_creux_gestoci_vs_creux_station_5 , t0 . ecart AS ecart_6 , t0 . contre_plain AS contre_plain_7 , t0 . date_debut_depotage AS date_debut_depotage_8 , t0 . date_fin_depotage AS date_fin_depotage_9 , t0 . temps_depotage AS temps_depotage_10 , t0 . commentaire AS commentaire_11 , t0 . stock_avant_depotage AS stock_avant_depotage_12 , t0 . stock_apres_depotage AS stock_apres_depotage_13 , t0 . stock_theorique AS stock_theorique_14 , t0 . stock_reel AS stock_reel_15 , t0 . bon_de_livraison_id AS bon_de_livraison_id_16 , t0 . compartiment_id AS compartiment_id_17 , t0 . produit_id AS produit_id_18 , t0 . jaugeur_id AS jaugeur_id_19 , t0 . gerant_id AS gerant_id_20 FROM detail_bon_de_livraison t0 WHERE t0 . bon_de_livraison_id = ?
SELECT t0 . id AS id_1 , t0 . creux_gestoci AS creux_gestoci_2 , t0 . dif_creux_certifier_vs_creux_gestoci AS dif_creux_certifier_vs_creux_gestoci_3 , t0 . creux_station AS creux_station_4 , t0 . dif_creux_gestoci_vs_creux_station AS dif_creux_gestoci_vs_creux_station_5 , t0 . ecart AS ecart_6 , t0 . contre_plain AS contre_plain_7 , t0 . date_debut_depotage AS date_debut_depotage_8 , t0 . date_fin_depotage AS date_fin_depotage_9 , t0 . temps_depotage AS temps_depotage_10 , t0 . commentaire AS commentaire_11 , t0 . stock_avant_depotage AS stock_avant_depotage_12 , t0 . stock_apres_depotage AS stock_apres_depotage_13 , t0 . stock_theorique AS stock_theorique_14 , t0 . stock_reel AS stock_reel_15 , t0 . bon_de_livraison_id AS bon_de_livraison_id_16 , t0 . compartiment_id AS compartiment_id_17 , t0 . produit_id AS produit_id_18 , t0 . jaugeur_id AS jaugeur_id_19 , t0 . gerant_id AS gerant_id_20 FROM detail_bon_de_livraison t0 WHERE t0 . bon_de_livraison_id = 2 ;
Copy
34
0.30 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 = 16 ;
Copy
35
0.24 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
36
0.24 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . differentiel_transport AS differentiel_transport_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 . slug AS slug_8 FROM localite t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . differentiel_transport AS differentiel_transport_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 . slug AS slug_8 FROM localite t0 WHERE t0 . id = 7 ;
Copy
37
0.45 ms
SELECT t0 . id AS id_1 , t0 . creux_gestoci AS creux_gestoci_2 , t0 . dif_creux_certifier_vs_creux_gestoci AS dif_creux_certifier_vs_creux_gestoci_3 , t0 . creux_station AS creux_station_4 , t0 . dif_creux_gestoci_vs_creux_station AS dif_creux_gestoci_vs_creux_station_5 , t0 . ecart AS ecart_6 , t0 . contre_plain AS contre_plain_7 , t0 . date_debut_depotage AS date_debut_depotage_8 , t0 . date_fin_depotage AS date_fin_depotage_9 , t0 . temps_depotage AS temps_depotage_10 , t0 . commentaire AS commentaire_11 , t0 . stock_avant_depotage AS stock_avant_depotage_12 , t0 . stock_apres_depotage AS stock_apres_depotage_13 , t0 . stock_theorique AS stock_theorique_14 , t0 . stock_reel AS stock_reel_15 , t0 . bon_de_livraison_id AS bon_de_livraison_id_16 , t0 . compartiment_id AS compartiment_id_17 , t0 . produit_id AS produit_id_18 , t0 . jaugeur_id AS jaugeur_id_19 , t0 . gerant_id AS gerant_id_20 FROM detail_bon_de_livraison t0 WHERE t0 . bon_de_livraison_id = ?
SELECT t0 . id AS id_1 , t0 . creux_gestoci AS creux_gestoci_2 , t0 . dif_creux_certifier_vs_creux_gestoci AS dif_creux_certifier_vs_creux_gestoci_3 , t0 . creux_station AS creux_station_4 , t0 . dif_creux_gestoci_vs_creux_station AS dif_creux_gestoci_vs_creux_station_5 , t0 . ecart AS ecart_6 , t0 . contre_plain AS contre_plain_7 , t0 . date_debut_depotage AS date_debut_depotage_8 , t0 . date_fin_depotage AS date_fin_depotage_9 , t0 . temps_depotage AS temps_depotage_10 , t0 . commentaire AS commentaire_11 , t0 . stock_avant_depotage AS stock_avant_depotage_12 , t0 . stock_apres_depotage AS stock_apres_depotage_13 , t0 . stock_theorique AS stock_theorique_14 , t0 . stock_reel AS stock_reel_15 , t0 . bon_de_livraison_id AS bon_de_livraison_id_16 , t0 . compartiment_id AS compartiment_id_17 , t0 . produit_id AS produit_id_18 , t0 . jaugeur_id AS jaugeur_id_19 , t0 . gerant_id AS gerant_id_20 FROM detail_bon_de_livraison t0 WHERE t0 . bon_de_livraison_id = 1 ;
Copy
38
0.34 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 = 19 ;
Copy