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.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 = 4016;

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.bordereau_complement_parent_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.bordereau_complement_parent_id = 5817;

SELECT
  b0_.id AS id_0,
  b0_.date_livraison AS date_livraison_1,
  b0_.heure_livraison AS heure_livraison_2,
  b0_.nombre_plis AS nombre_plis_3,
  b0_.poids AS poids_4,
  b0_.date_retour_boredereau AS date_retour_boredereau_5,
  b0_.nom_receptionnaire_accueil AS nom_receptionnaire_accueil_6,
  b0_.type_operation AS type_operation_7,
  b0_.instruction_particuliere AS instruction_particuliere_8,
  b0_.destinataire AS destinataire_9,
  b0_.adresse_livraison AS adresse_livraison_10,
  b0_.intruction_particuliere_livraison AS intruction_particuliere_livraison_11,
  b0_.statut_livraison AS statut_livraison_12,
  b0_.price AS price_13,
  b0_.number_bordereau AS number_bordereau_14,
  b0_.nom_client_retour_bordereau AS nom_client_retour_bordereau_15,
  b0_.date AS date_16,
  b0_.receptionnaire_colis AS receptionnaire_colis_17,
  b0_.non_transmis_commentaire AS non_transmis_commentaire_18,
  b0_.appel AS appel_19,
  b0_.frais_appel AS frais_appel_20,
  b0_.plis AS plis_21,
  b0_.nom_categorie_client AS nom_categorie_client_22,
  b0_.nombre_colis AS nombre_colis_23,
  b0_.nombre_avis_passage AS nombre_avis_passage_24,
  b0_.nombre_feuillet AS nombre_feuillet_25,
  b0_.reference AS reference_26,
  b0_.observation AS observation_27,
  b0_.numero_facture AS numero_facture_28,
  b0_.code_produit AS code_produit_29,
  b0_.nombre_corporate AS nombre_corporate_30,
  b0_.date_enlevement AS date_enlevement_31,
  b0_.heure_enlevement AS heure_enlevement_32,
  b0_.nombre_ticket AS nombre_ticket_33,
  b0_.reference_bordereau AS reference_bordereau_34,
  b0_.nombre_plis_courant AS nombre_plis_courant_35,
  b0_.price_complement AS price_complement_36,
  b0_.comment_retour_int AS comment_retour_int_37,
  b0_.comment_abandon_int AS comment_abandon_int_38,
  b0_.comment_destruction_int AS comment_destruction_int_39,
  b0_.comment_refus_reception_int AS comment_refus_reception_int_40,
  b0_.statut_representant AS statut_representant_41,
  b0_.created_at AS created_at_42,
  b0_.updated_at AS updated_at_43,
  b0_.deleted_at AS deleted_at_44,
  b0_.created_by AS created_by_45,
  b0_.updated_by AS updated_by_46,
  b0_.client_id AS client_id_47,
  b0_.coursier_id AS coursier_id_48,
  b0_.produit_id AS produit_id_49,
  b0_.operation_type_id AS operation_type_id_50,
  b0_.ville_id AS ville_id_51,
  b0_.bordereau_parent_id AS bordereau_parent_id_52,
  b0_.bordereau_complement_parent_id AS bordereau_complement_parent_id_53,
  b0_.ville_complement_id AS ville_complement_id_54,
  b0_.motif_id AS motif_id_55,
  b0_.representant_id AS representant_id_56
FROM
  bordereau b0_
WHERE
  (
    b0_.date BETWEEN ?
    AND ?
  )
  AND b0_.type_operation = ?
ORDER BY
  b0_.id DESC

SELECT b0_.id AS id_0, b0_.date_livraison AS date_livraison_1, b0_.heure_livraison AS heure_livraison_2, b0_.nombre_plis AS nombre_plis_3, b0_.poids AS poids_4, b0_.date_retour_boredereau AS date_retour_boredereau_5, b0_.nom_receptionnaire_accueil AS nom_receptionnaire_accueil_6, b0_.type_operation AS type_operation_7, b0_.instruction_particuliere AS instruction_particuliere_8, b0_.destinataire AS destinataire_9, b0_.adresse_livraison AS adresse_livraison_10, b0_.intruction_particuliere_livraison AS intruction_particuliere_livraison_11, b0_.statut_livraison AS statut_livraison_12, b0_.price AS price_13, b0_.number_bordereau AS number_bordereau_14, b0_.nom_client_retour_bordereau AS nom_client_retour_bordereau_15, b0_.date AS date_16, b0_.receptionnaire_colis AS receptionnaire_colis_17, b0_.non_transmis_commentaire AS non_transmis_commentaire_18, b0_.appel AS appel_19, b0_.frais_appel AS frais_appel_20, b0_.plis AS plis_21, b0_.nom_categorie_client AS nom_categorie_client_22, b0_.nombre_colis AS nombre_colis_23, b0_.nombre_avis_passage AS nombre_avis_passage_24, b0_.nombre_feuillet AS nombre_feuillet_25, b0_.reference AS reference_26, b0_.observation AS observation_27, b0_.numero_facture AS numero_facture_28, b0_.code_produit AS code_produit_29, b0_.nombre_corporate AS nombre_corporate_30, b0_.date_enlevement AS date_enlevement_31, b0_.heure_enlevement AS heure_enlevement_32, b0_.nombre_ticket AS nombre_ticket_33, b0_.reference_bordereau AS reference_bordereau_34, b0_.nombre_plis_courant AS nombre_plis_courant_35, b0_.price_complement AS price_complement_36, b0_.comment_retour_int AS comment_retour_int_37, b0_.comment_abandon_int AS comment_abandon_int_38, b0_.comment_destruction_int AS comment_destruction_int_39, b0_.comment_refus_reception_int AS comment_refus_reception_int_40, b0_.statut_representant AS statut_representant_41, b0_.created_at AS created_at_42, b0_.updated_at AS updated_at_43, b0_.deleted_at AS deleted_at_44, b0_.created_by AS created_by_45, b0_.updated_by AS updated_by_46, b0_.client_id AS client_id_47, b0_.coursier_id AS coursier_id_48, b0_.produit_id AS produit_id_49, b0_.operation_type_id AS operation_type_id_50, b0_.ville_id AS ville_id_51, b0_.bordereau_parent_id AS bordereau_parent_id_52, b0_.bordereau_complement_parent_id AS bordereau_complement_parent_id_53, b0_.ville_complement_id AS ville_complement_id_54, b0_.motif_id AS motif_id_55, b0_.representant_id AS representant_id_56 FROM bordereau b0_ WHERE (b0_.date BETWEEN '2026-03-26 00:00:00' AND '2026-04-02 23:59:59') AND b0_.type_operation = 'NATIONAL' ORDER BY b0_.id DESC;

SELECT
  SUM(O.nombre_plis) price,
  O.created_by
FROM
  bordereau O
WHERE
  O.date BETWEEN :debut
  AND :fin
  AND O.statut_livraison != :statutLivraison
  AND O.statut_livraison != :statutLivraison2
GROUP BY
  O.created_by

SELECT SUM(O.nombre_plis) price, O.created_by
                FROM bordereau O
                WHERE O.date BETWEEN '2026-03-26' AND '2026-04-02'
                AND O.statut_livraison != 'non_livrer'
                AND O.statut_livraison != 'livrer'
                
                GROUP BY O.created_by;

SELECT
  SUM(O.nombre_plis) price,
  O.created_by
FROM
  bordereau O
WHERE
  O.date BETWEEN :debut
  AND :fin
  AND O.statut_livraison = :statutLivraison
GROUP BY
  O.created_by

SELECT SUM(O.nombre_plis) price, O.created_by
                FROM bordereau O
                WHERE O.date BETWEEN '2026-03-26' AND '2026-04-02'
                AND O.statut_livraison = 'non_livrer'
                
                GROUP BY O.created_by;

SELECT
  SUM(O.nombre_plis) price,
  O.created_by
FROM
  bordereau O
WHERE
  O.date BETWEEN :debut
  AND :fin
GROUP BY
  O.created_by

SELECT SUM(O.nombre_plis) price, O.created_by
                FROM bordereau O
                WHERE O.date BETWEEN '2026-03-26' AND '2026-04-02'
                
                GROUP BY O.created_by;

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.operation_id AS operation_id_3,
  t0.client_id AS client_id_4,
  t0.client_name AS client_name_5,
  t0.client_firstname AS client_firstname_6,
  t0.amount AS amount_7,
  t0.poid AS poid_8,
  t0.user_id AS user_id_9,
  t0.destination_id AS destination_id_10,
  t0.date AS date_11,
  t0.raison_sociale AS raison_sociale_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.deleted_at AS deleted_at_15,
  t0.created_by AS created_by_16,
  t0.updated_by AS updated_by_17
FROM
  notification t0
WHERE
  t0.user_id = ?
  AND t0.status = ?
  AND t0.date = ?

SELECT t0.id AS id_1, t0.status AS status_2, t0.operation_id AS operation_id_3, t0.client_id AS client_id_4, t0.client_name AS client_name_5, t0.client_firstname AS client_firstname_6, t0.amount AS amount_7, t0.poid AS poid_8, t0.user_id AS user_id_9, t0.destination_id AS destination_id_10, t0.date AS date_11, t0.raison_sociale AS raison_sociale_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.deleted_at AS deleted_at_15, t0.created_by AS created_by_16, t0.updated_by AS updated_by_17 FROM notification t0 WHERE t0.user_id = 25 AND t0.status = 1 AND t0.date = '2026-04-02';

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.email = ?
LIMIT
  1

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.email = 'wilfried.houedanou@topchrono.com' LIMIT 1;

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.first_name AS first_name_4,
  u0_.last_name AS last_name_5,
  u0_.corpate AS corpate_6,
  u0_.active AS active_7,
  u0_.date_embauche AS date_embauche_8,
  u0_.date_depart AS date_depart_9,
  u0_.interphone AS interphone_10,
  u0_.date_naissance AS date_naissance_11,
  u0_.code_employer AS code_employer_12,
  u0_.code_pays AS code_pays_13,
  u0_.mobile AS mobile_14,
  u0_.fax AS fax_15,
  u0_.telephone_employer AS telephone_employer_16,
  u0_.email_employer AS email_employer_17,
  u0_.created_at AS created_at_18,
  u0_.updated_at AS updated_at_19,
  u0_.deleted_at AS deleted_at_20,
  u0_.created_by AS created_by_21,
  u0_.updated_by AS updated_by_22,
  u0_.affiliate_id AS affiliate_id_23,
  u0_.service_id AS service_id_24
FROM
  `user` u0_
WHERE
  u0_.roles LIKE '%\"LIVREUR\"%'

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.first_name AS first_name_4, u0_.last_name AS last_name_5, u0_.corpate AS corpate_6, u0_.active AS active_7, u0_.date_embauche AS date_embauche_8, u0_.date_depart AS date_depart_9, u0_.interphone AS interphone_10, u0_.date_naissance AS date_naissance_11, u0_.code_employer AS code_employer_12, u0_.code_pays AS code_pays_13, u0_.mobile AS mobile_14, u0_.fax AS fax_15, u0_.telephone_employer AS telephone_employer_16, u0_.email_employer AS email_employer_17, u0_.created_at AS created_at_18, u0_.updated_at AS updated_at_19, u0_.deleted_at AS deleted_at_20, u0_.created_by AS created_by_21, u0_.updated_by AS updated_by_22, u0_.affiliate_id AS affiliate_id_23, u0_.service_id AS service_id_24 FROM `user` u0_ WHERE u0_.roles LIKE '%\"LIVREUR\"%';

SELECT
  v0_.id AS id_0,
  v0_.nom_ville AS nom_ville_1,
  v0_.code_ville AS code_ville_2,
  v0_.tarif_puclic_courrier AS tarif_puclic_courrier_3,
  v0_.tarif_perso_courrier AS tarif_perso_courrier_4,
  v0_.delai AS delai_5,
  v0_.observation AS observation_6,
  v0_.nombre_ticket AS nombre_ticket_7,
  v0_.created_at AS created_at_8,
  v0_.updated_at AS updated_at_9,
  v0_.deleted_at AS deleted_at_10,
  v0_.created_by AS created_by_11,
  v0_.updated_by AS updated_by_12,
  v0_.pays_id AS pays_id_13
FROM
  ville v0_

SELECT v0_.id AS id_0, v0_.nom_ville AS nom_ville_1, v0_.code_ville AS code_ville_2, v0_.tarif_puclic_courrier AS tarif_puclic_courrier_3, v0_.tarif_perso_courrier AS tarif_perso_courrier_4, v0_.delai AS delai_5, v0_.observation AS observation_6, v0_.nombre_ticket AS nombre_ticket_7, v0_.created_at AS created_at_8, v0_.updated_at AS updated_at_9, v0_.deleted_at AS deleted_at_10, v0_.created_by AS created_by_11, v0_.updated_by AS updated_by_12, v0_.pays_id AS pays_id_13 FROM ville v0_;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3
FROM
  role t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM role t0 WHERE t0.name = 'ROLE_GESTIONNAIRE' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.label AS label_2
FROM
  pays t0

SELECT t0.id AS id_1, t0.label AS label_2 FROM pays t0;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.libelle AS libelle_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.created_by AS created_by_7,
  t0.updated_by AS updated_by_8
FROM
  operation_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8 FROM operation_type t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.category_id AS category_id_3
FROM
  motif t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.category_id AS category_id_3 FROM motif t0 WHERE t0.id = 2;