| 1 |
1.55 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = 2;
|
| 2 |
597.30 ms |
SELECT b0_.id AS id_0, b0_.date AS date_1, b0_.delivery AS delivery_2, b0_.name_of_ship_to_party AS name_of_ship_to_party_3, b0_.material AS material_4, b0_.purchasingdocument AS purchasingdocument_5, b0_.delivery_quantity AS delivery_quantity_6, b0_.city AS city_7, b0_.description AS description_8, b0_.valider AS valider_9, b0_.region AS region_10, b0_.observation AS observation_11, b0_.date_affectation AS date_affectation_12, b0_.valeur AS valeur_13, b0_.type_de_bl AS type_de_bl_14, b0_.livreur_id AS livreur_id_15, b0_.client_party_id AS client_party_id_16, b0_.demandeur_id AS demandeur_id_17 FROM bonlivraison b0_ LEFT JOIN livreur l1_ ON b0_.livreur_id = l1_.id LEFT JOIN suivi_expedition s2_ ON b0_.id = s2_.bonlivraison_id LEFT JOIN archivage a3_ ON b0_.id = a3_.bonlivraison_id WHERE b0_.delivery LIKE ? ORDER BY b0_.date DESC
Parameters: [
"%870122748%"
]
SELECT b0_.id AS id_0, b0_.date AS date_1, b0_.delivery AS delivery_2, b0_.name_of_ship_to_party AS name_of_ship_to_party_3, b0_.material AS material_4, b0_.purchasingdocument AS purchasingdocument_5, b0_.delivery_quantity AS delivery_quantity_6, b0_.city AS city_7, b0_.description AS description_8, b0_.valider AS valider_9, b0_.region AS region_10, b0_.observation AS observation_11, b0_.date_affectation AS date_affectation_12, b0_.valeur AS valeur_13, b0_.type_de_bl AS type_de_bl_14, b0_.livreur_id AS livreur_id_15, b0_.client_party_id AS client_party_id_16, b0_.demandeur_id AS demandeur_id_17 FROM bonlivraison b0_ LEFT JOIN livreur l1_ ON b0_.livreur_id = l1_.id LEFT JOIN suivi_expedition s2_ ON b0_.id = s2_.bonlivraison_id LEFT JOIN archivage a3_ ON b0_.id = a3_.bonlivraison_id WHERE b0_.delivery LIKE '%870122748%' ORDER BY b0_.date DESC;
|
| 3 |
0.54 ms |
SELECT t0.id AS id_1, t0.situation AS situation_2, t0.pod AS pod_3, t0.note AS note_4, t0.attachment_path AS attachment_path_5, t0.bonlivraison_id AS bonlivraison_id_6 FROM suivi_expedition t0 WHERE t0.bonlivraison_id = ?
SELECT t0.id AS id_1, t0.situation AS situation_2, t0.pod AS pod_3, t0.note AS note_4, t0.attachment_path AS attachment_path_5, t0.bonlivraison_id AS bonlivraison_id_6 FROM suivi_expedition t0 WHERE t0.bonlivraison_id = 147716;
|
| 4 |
0.70 ms |
SELECT t0.id AS id_1, t0.link_archivage AS link_archivage_2, t0.bonlivraison_id AS bonlivraison_id_3 FROM archivage t0 WHERE t0.bonlivraison_id = ?
SELECT t0.id AS id_1, t0.link_archivage AS link_archivage_2, t0.bonlivraison_id AS bonlivraison_id_3 FROM archivage t0 WHERE t0.bonlivraison_id = 147716;
|
| 5 |
0.37 ms |
SELECT t0.id AS id_1, t0.situation AS situation_2, t0.pod AS pod_3, t0.note AS note_4, t0.attachment_path AS attachment_path_5, t0.bonlivraison_id AS bonlivraison_id_6 FROM suivi_expedition t0 WHERE t0.bonlivraison_id = ?
SELECT t0.id AS id_1, t0.situation AS situation_2, t0.pod AS pod_3, t0.note AS note_4, t0.attachment_path AS attachment_path_5, t0.bonlivraison_id AS bonlivraison_id_6 FROM suivi_expedition t0 WHERE t0.bonlivraison_id = 147717;
|
| 6 |
0.34 ms |
SELECT t0.id AS id_1, t0.link_archivage AS link_archivage_2, t0.bonlivraison_id AS bonlivraison_id_3 FROM archivage t0 WHERE t0.bonlivraison_id = ?
SELECT t0.id AS id_1, t0.link_archivage AS link_archivage_2, t0.bonlivraison_id AS bonlivraison_id_3 FROM archivage t0 WHERE t0.bonlivraison_id = 147717;
|
| 7 |
0.36 ms |
SELECT t0.id AS id_1, t0.situation AS situation_2, t0.pod AS pod_3, t0.note AS note_4, t0.attachment_path AS attachment_path_5, t0.bonlivraison_id AS bonlivraison_id_6 FROM suivi_expedition t0 WHERE t0.bonlivraison_id = ?
SELECT t0.id AS id_1, t0.situation AS situation_2, t0.pod AS pod_3, t0.note AS note_4, t0.attachment_path AS attachment_path_5, t0.bonlivraison_id AS bonlivraison_id_6 FROM suivi_expedition t0 WHERE t0.bonlivraison_id = 147718;
|
| 8 |
0.45 ms |
SELECT t0.id AS id_1, t0.link_archivage AS link_archivage_2, t0.bonlivraison_id AS bonlivraison_id_3 FROM archivage t0 WHERE t0.bonlivraison_id = ?
SELECT t0.id AS id_1, t0.link_archivage AS link_archivage_2, t0.bonlivraison_id AS bonlivraison_id_3 FROM archivage t0 WHERE t0.bonlivraison_id = 147718;
|
| 9 |
0.30 ms |
SELECT t0.id AS id_1, t0.situation AS situation_2, t0.pod AS pod_3, t0.note AS note_4, t0.attachment_path AS attachment_path_5, t0.bonlivraison_id AS bonlivraison_id_6 FROM suivi_expedition t0 WHERE t0.bonlivraison_id = ?
SELECT t0.id AS id_1, t0.situation AS situation_2, t0.pod AS pod_3, t0.note AS note_4, t0.attachment_path AS attachment_path_5, t0.bonlivraison_id AS bonlivraison_id_6 FROM suivi_expedition t0 WHERE t0.bonlivraison_id = 147719;
|
| 10 |
0.31 ms |
SELECT t0.id AS id_1, t0.link_archivage AS link_archivage_2, t0.bonlivraison_id AS bonlivraison_id_3 FROM archivage t0 WHERE t0.bonlivraison_id = ?
SELECT t0.id AS id_1, t0.link_archivage AS link_archivage_2, t0.bonlivraison_id AS bonlivraison_id_3 FROM archivage t0 WHERE t0.bonlivraison_id = 147719;
|
| 11 |
0.32 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.phone_number AS phone_number_3, t0.matricule AS matricule_4, t0.active AS active_5, t0.type AS type_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.username AS username_9, t0.password AS password_10 FROM livreur t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.phone_number AS phone_number_3, t0.matricule AS matricule_4, t0.active AS active_5, t0.type AS type_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.username AS username_9, t0.password AS password_10 FROM livreur t0 WHERE t0.id = 65;
|