Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.corpate AS corpate_7,
  t0.active AS active_8,
  t0.date_embauche AS date_embauche_9,
  t0.date_depart AS date_depart_10,
  t0.interphone AS interphone_11,
  t0.date_naissance AS date_naissance_12,
  t0.code_employer AS code_employer_13,
  t0.code_pays AS code_pays_14,
  t0.mobile AS mobile_15,
  t0.fax AS fax_16,
  t0.telephone_employer AS telephone_employer_17,
  t0.email_employer AS email_employer_18,
  t0.created_at AS created_at_19,
  t0.updated_at AS updated_at_20,
  t0.deleted_at AS deleted_at_21,
  t0.created_by AS created_by_22,
  t0.updated_by AS updated_by_23,
  t0.affiliate_id AS affiliate_id_24,
  t0.service_id AS service_id_25
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, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.corpate AS corpate_7, t0.active AS active_8, t0.date_embauche AS date_embauche_9, t0.date_depart AS date_depart_10, t0.interphone AS interphone_11, t0.date_naissance AS date_naissance_12, t0.code_employer AS code_employer_13, t0.code_pays AS code_pays_14, t0.mobile AS mobile_15, t0.fax AS fax_16, t0.telephone_employer AS telephone_employer_17, t0.email_employer AS email_employer_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.deleted_at AS deleted_at_21, t0.created_by AS created_by_22, t0.updated_by AS updated_by_23, t0.affiliate_id AS affiliate_id_24, t0.service_id AS service_id_25 FROM `user` t0 WHERE t0.id = 25;

SELECT
  t0.id AS id_1,
  t0.date_livraison AS date_livraison_2,
  t0.heure_livraison AS heure_livraison_3,
  t0.nombre_plis AS nombre_plis_4,
  t0.poids AS poids_5,
  t0.date_retour_boredereau AS date_retour_boredereau_6,
  t0.nom_receptionnaire_accueil AS nom_receptionnaire_accueil_7,
  t0.type_operation AS type_operation_8,
  t0.instruction_particuliere AS instruction_particuliere_9,
  t0.destinataire AS destinataire_10,
  t0.adresse_livraison AS adresse_livraison_11,
  t0.intruction_particuliere_livraison AS intruction_particuliere_livraison_12,
  t0.statut_livraison AS statut_livraison_13,
  t0.price AS price_14,
  t0.number_bordereau AS number_bordereau_15,
  t0.nom_client_retour_bordereau AS nom_client_retour_bordereau_16,
  t0.date AS date_17,
  t0.receptionnaire_colis AS receptionnaire_colis_18,
  t0.non_transmis_commentaire AS non_transmis_commentaire_19,
  t0.appel AS appel_20,
  t0.frais_appel AS frais_appel_21,
  t0.plis AS plis_22,
  t0.nom_categorie_client AS nom_categorie_client_23,
  t0.nombre_colis AS nombre_colis_24,
  t0.nombre_avis_passage AS nombre_avis_passage_25,
  t0.nombre_feuillet AS nombre_feuillet_26,
  t0.reference AS reference_27,
  t0.observation AS observation_28,
  t0.numero_facture AS numero_facture_29,
  t0.code_produit AS code_produit_30,
  t0.nombre_corporate AS nombre_corporate_31,
  t0.date_enlevement AS date_enlevement_32,
  t0.heure_enlevement AS heure_enlevement_33,
  t0.nombre_ticket AS nombre_ticket_34,
  t0.reference_bordereau AS reference_bordereau_35,
  t0.nombre_plis_courant AS nombre_plis_courant_36,
  t0.price_complement AS price_complement_37,
  t0.comment_retour_int AS comment_retour_int_38,
  t0.comment_abandon_int AS comment_abandon_int_39,
  t0.comment_destruction_int AS comment_destruction_int_40,
  t0.comment_refus_reception_int AS comment_refus_reception_int_41,
  t0.statut_representant AS statut_representant_42,
  t0.created_at AS created_at_43,
  t0.updated_at AS updated_at_44,
  t0.deleted_at AS deleted_at_45,
  t0.created_by AS created_by_46,
  t0.updated_by AS updated_by_47,
  t0.client_id AS client_id_48,
  t0.coursier_id AS coursier_id_49,
  t0.produit_id AS produit_id_50,
  t0.operation_type_id AS operation_type_id_51,
  t0.ville_id AS ville_id_52,
  t0.bordereau_parent_id AS bordereau_parent_id_53,
  t0.bordereau_complement_parent_id AS bordereau_complement_parent_id_54,
  t0.ville_complement_id AS ville_complement_id_55,
  t0.motif_id AS motif_id_56,
  t0.representant_id AS representant_id_57
FROM
  bordereau t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.date_livraison AS date_livraison_2, t0.heure_livraison AS heure_livraison_3, t0.nombre_plis AS nombre_plis_4, t0.poids AS poids_5, t0.date_retour_boredereau AS date_retour_boredereau_6, t0.nom_receptionnaire_accueil AS nom_receptionnaire_accueil_7, t0.type_operation AS type_operation_8, t0.instruction_particuliere AS instruction_particuliere_9, t0.destinataire AS destinataire_10, t0.adresse_livraison AS adresse_livraison_11, t0.intruction_particuliere_livraison AS intruction_particuliere_livraison_12, t0.statut_livraison AS statut_livraison_13, t0.price AS price_14, t0.number_bordereau AS number_bordereau_15, t0.nom_client_retour_bordereau AS nom_client_retour_bordereau_16, t0.date AS date_17, t0.receptionnaire_colis AS receptionnaire_colis_18, t0.non_transmis_commentaire AS non_transmis_commentaire_19, t0.appel AS appel_20, t0.frais_appel AS frais_appel_21, t0.plis AS plis_22, t0.nom_categorie_client AS nom_categorie_client_23, t0.nombre_colis AS nombre_colis_24, t0.nombre_avis_passage AS nombre_avis_passage_25, t0.nombre_feuillet AS nombre_feuillet_26, t0.reference AS reference_27, t0.observation AS observation_28, t0.numero_facture AS numero_facture_29, t0.code_produit AS code_produit_30, t0.nombre_corporate AS nombre_corporate_31, t0.date_enlevement AS date_enlevement_32, t0.heure_enlevement AS heure_enlevement_33, t0.nombre_ticket AS nombre_ticket_34, t0.reference_bordereau AS reference_bordereau_35, t0.nombre_plis_courant AS nombre_plis_courant_36, t0.price_complement AS price_complement_37, t0.comment_retour_int AS comment_retour_int_38, t0.comment_abandon_int AS comment_abandon_int_39, t0.comment_destruction_int AS comment_destruction_int_40, t0.comment_refus_reception_int AS comment_refus_reception_int_41, t0.statut_representant AS statut_representant_42, t0.created_at AS created_at_43, t0.updated_at AS updated_at_44, t0.deleted_at AS deleted_at_45, t0.created_by AS created_by_46, t0.updated_by AS updated_by_47, t0.client_id AS client_id_48, t0.coursier_id AS coursier_id_49, t0.produit_id AS produit_id_50, t0.operation_type_id AS operation_type_id_51, t0.ville_id AS ville_id_52, t0.bordereau_parent_id AS bordereau_parent_id_53, t0.bordereau_complement_parent_id AS bordereau_complement_parent_id_54, t0.ville_complement_id AS ville_complement_id_55, t0.motif_id AS motif_id_56, t0.representant_id AS representant_id_57 FROM bordereau t0 WHERE t0.id = '5812';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.firstname AS firstname_3,
  t0.phone_number AS phone_number_4,
  t0.company_name AS company_name_5,
  t0.number_card AS number_card_6,
  t0.date_expiration AS date_expiration_7,
  t0.status_generate AS status_generate_8,
  t0.type AS type_9,
  t0.logo AS logo_10,
  t0.standard AS standard_11,
  t0.mobile AS mobile_12,
  t0.fax AS fax_13,
  t0.bp AS bp_14,
  t0.client_web AS client_web_15,
  t0.numero_carre AS numero_carre_16,
  t0.maison AS maison_17,
  t0.email AS email_18,
  t0.anniversaire AS anniversaire_19,
  t0.tva AS tva_20,
  t0.ifu AS ifu_21,
  t0.observation AS observation_22,
  t0.civilite AS civilite_23,
  t0.nom_dg AS nom_dg_24,
  t0.password AS password_25,
  t0.regime_fiscal AS regime_fiscal_26,
  t0.code_client AS code_client_27,
  t0.direct AS direct_28,
  t0.adresse_physique AS adresse_physique_29,
  t0.personne_contact AS personne_contact_30,
  t0.created_at AS created_at_31,
  t0.updated_at AS updated_at_32,
  t0.deleted_at AS deleted_at_33,
  t0.created_by AS created_by_34,
  t0.updated_by AS updated_by_35,
  t0.zone_id AS zone_id_36,
  t0.activite_id AS activite_id_37,
  t0.quartier_id AS quartier_id_38,
  t0.client_de_id AS client_de_id_39,
  t0.categorie_client_id AS categorie_client_id_40
FROM
  client t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.firstname AS firstname_3, t0.phone_number AS phone_number_4, t0.company_name AS company_name_5, t0.number_card AS number_card_6, t0.date_expiration AS date_expiration_7, t0.status_generate AS status_generate_8, t0.type AS type_9, t0.logo AS logo_10, t0.standard AS standard_11, t0.mobile AS mobile_12, t0.fax AS fax_13, t0.bp AS bp_14, t0.client_web AS client_web_15, t0.numero_carre AS numero_carre_16, t0.maison AS maison_17, t0.email AS email_18, t0.anniversaire AS anniversaire_19, t0.tva AS tva_20, t0.ifu AS ifu_21, t0.observation AS observation_22, t0.civilite AS civilite_23, t0.nom_dg AS nom_dg_24, t0.password AS password_25, t0.regime_fiscal AS regime_fiscal_26, t0.code_client AS code_client_27, t0.direct AS direct_28, t0.adresse_physique AS adresse_physique_29, t0.personne_contact AS personne_contact_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.deleted_at AS deleted_at_33, t0.created_by AS created_by_34, t0.updated_by AS updated_by_35, t0.zone_id AS zone_id_36, t0.activite_id AS activite_id_37, t0.quartier_id AS quartier_id_38, t0.client_de_id AS client_de_id_39, t0.categorie_client_id AS categorie_client_id_40 FROM client t0 WHERE t0.id = 1441;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.corpate AS corpate_7,
  t0.active AS active_8,
  t0.date_embauche AS date_embauche_9,
  t0.date_depart AS date_depart_10,
  t0.interphone AS interphone_11,
  t0.date_naissance AS date_naissance_12,
  t0.code_employer AS code_employer_13,
  t0.code_pays AS code_pays_14,
  t0.mobile AS mobile_15,
  t0.fax AS fax_16,
  t0.telephone_employer AS telephone_employer_17,
  t0.email_employer AS email_employer_18,
  t0.created_at AS created_at_19,
  t0.updated_at AS updated_at_20,
  t0.deleted_at AS deleted_at_21,
  t0.created_by AS created_by_22,
  t0.updated_by AS updated_by_23,
  t0.affiliate_id AS affiliate_id_24,
  t0.service_id AS service_id_25
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, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.corpate AS corpate_7, t0.active AS active_8, t0.date_embauche AS date_embauche_9, t0.date_depart AS date_depart_10, t0.interphone AS interphone_11, t0.date_naissance AS date_naissance_12, t0.code_employer AS code_employer_13, t0.code_pays AS code_pays_14, t0.mobile AS mobile_15, t0.fax AS fax_16, t0.telephone_employer AS telephone_employer_17, t0.email_employer AS email_employer_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.deleted_at AS deleted_at_21, t0.created_by AS created_by_22, t0.updated_by AS updated_by_23, t0.affiliate_id AS affiliate_id_24, t0.service_id AS service_id_25 FROM `user` t0 WHERE t0.id = 12;

SELECT
  MAX(e0_.version) AS sclr_0
FROM
  ext_log_entries e0_
WHERE
  e0_.object_id = ?
  AND e0_.object_class = ?

SELECT MAX(e0_.version) AS sclr_0 FROM ext_log_entries e0_ WHERE e0_.object_id = '5812' AND e0_.object_class = 'App\\Entity\\Bordereau';

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO ext_log_entries (
  action, logged_at, object_id, object_class,
  version, data, username
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO ext_log_entries (action, logged_at, object_id, object_class, version, data, username) VALUES ('update', '2026-04-02 18:02:05', '5812', 'App\\Entity\\Bordereau', 3, 'a:2:{s:15:\"statutLivraison\";s:19:\"en_attente_coursier\";s:8:\"coursier\";a:1:{s:2:\"id\";i:12;}}', 'wilfried.houedanou@topchrono.com');

UPDATE
  bordereau
SET
  statut_livraison = ?,
  coursier_id = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE bordereau SET statut_livraison = 'en_attente_coursier', coursier_id = 12, updated_at = '2026-04-02 18:02:05' WHERE id = 5812;

"COMMIT"

"COMMIT";