Symfony Profiler

SELECT
  d0_.id AS id_0,
  d0_.vendeur AS vendeur_1,
  d0_.adresse AS adresse_2,
  d0_.telphvendeur1 AS telphvendeur1_3,
  d0_.telphvendeur2 AS telphvendeur2_4,
  d0_.rc AS rc_5,
  d0_.mf AS mf_6,
  d0_.nomclient AS nomclient_7,
  d0_.adresseclient AS adresseclient_8,
  d0_.telphclient AS telphclient_9,
  d0_.faxclient AS faxclient_10,
  d0_.mfclient AS mfclient_11,
  d0_.num AS num_12,
  d0_.date AS date_13,
  d0_.reference AS reference_14,
  d0_.code AS code_15,
  d0_.base AS base_16,
  d0_.taux AS taux_17,
  d0_.montant AS montant_18,
  d0_.total AS total_19,
  d0_.totalht AS totalht_20,
  d0_.qttotal AS qttotal_21,
  d0_.totalttc AS totalttc_22,
  d0_.montant_net AS montant_net_23,
  d0_.statut AS statut_24,
  d0_.timbre AS timbre_25,
  d0_.idfacture AS idfacture_26,
  d0_.oldtype AS oldtype_27,
  d0_.retour AS retour_28,
  d0_.frtour AS frtour_29,
  d0_.fav AS fav_30,
  d0_.lu AS lu_31,
  d0_.datecreation AS datecreation_32,
  d0_.demandedevisold AS demandedevisold_33,
  d0_.iddevisold AS iddevisold_34,
  d0_.iduerold AS iduerold_35,
  d0_.idintervold AS idintervold_36,
  d0_.username AS username_37,
  d0_.adressp AS adressp_38,
  d0_.telpp AS telpp_39,
  d0_.idsfacts AS idsfacts_40,
  c1_.id AS id_41,
  c1_.email AS email_42,
  c1_.nom AS nom_43,
  c1_.prenom AS prenom_44,
  c1_.raisonsocial AS raisonsocial_45,
  c1_.adresse AS adresse_46,
  c1_.tel AS tel_47,
  c1_.photo AS photo_48,
  c1_.faxclient AS faxclient_49,
  c1_.mfclient AS mfclient_50,
  c1_.exoneres AS exoneres_51,
  p2_.id AS id_52,
  p2_.montant AS montant_53,
  p2_.acompte AS acompte_54,
  p2_.reste AS reste_55,
  p2_.description AS description_56,
  p2_.piecejointe AS piecejointe_57,
  p2_.date AS date_58,
  p2_.modedepaiement AS modedepaiement_59,
  p2_.num AS num_60,
  p2_.remise AS remise_61,
  d0_.vendeurs_id AS vendeurs_id_62,
  d0_.client_id AS client_id_63,
  d0_.user_id AS user_id_64,
  d0_.fournisseur_id AS fournisseur_id_65,
  c1_.region_id AS region_id_66,
  p2_.devis_id AS devis_id_67
FROM
  devis d0_
  LEFT JOIN client c1_ ON d0_.client_id = c1_.id
  LEFT JOIN paymentdevi p2_ ON d0_.id = p2_.devis_id
WHERE
  d0_.statut IN (?, ?, ?)
ORDER BY
  d0_.date DESC,
  d0_.datecreation DESC,
  d0_.id DESC

SELECT d0_.id AS id_0, d0_.vendeur AS vendeur_1, d0_.adresse AS adresse_2, d0_.telphvendeur1 AS telphvendeur1_3, d0_.telphvendeur2 AS telphvendeur2_4, d0_.rc AS rc_5, d0_.mf AS mf_6, d0_.nomclient AS nomclient_7, d0_.adresseclient AS adresseclient_8, d0_.telphclient AS telphclient_9, d0_.faxclient AS faxclient_10, d0_.mfclient AS mfclient_11, d0_.num AS num_12, d0_.date AS date_13, d0_.reference AS reference_14, d0_.code AS code_15, d0_.base AS base_16, d0_.taux AS taux_17, d0_.montant AS montant_18, d0_.total AS total_19, d0_.totalht AS totalht_20, d0_.qttotal AS qttotal_21, d0_.totalttc AS totalttc_22, d0_.montant_net AS montant_net_23, d0_.statut AS statut_24, d0_.timbre AS timbre_25, d0_.idfacture AS idfacture_26, d0_.oldtype AS oldtype_27, d0_.retour AS retour_28, d0_.frtour AS frtour_29, d0_.fav AS fav_30, d0_.lu AS lu_31, d0_.datecreation AS datecreation_32, d0_.demandedevisold AS demandedevisold_33, d0_.iddevisold AS iddevisold_34, d0_.iduerold AS iduerold_35, d0_.idintervold AS idintervold_36, d0_.username AS username_37, d0_.adressp AS adressp_38, d0_.telpp AS telpp_39, d0_.idsfacts AS idsfacts_40, c1_.id AS id_41, c1_.email AS email_42, c1_.nom AS nom_43, c1_.prenom AS prenom_44, c1_.raisonsocial AS raisonsocial_45, c1_.adresse AS adresse_46, c1_.tel AS tel_47, c1_.photo AS photo_48, c1_.faxclient AS faxclient_49, c1_.mfclient AS mfclient_50, c1_.exoneres AS exoneres_51, p2_.id AS id_52, p2_.montant AS montant_53, p2_.acompte AS acompte_54, p2_.reste AS reste_55, p2_.description AS description_56, p2_.piecejointe AS piecejointe_57, p2_.date AS date_58, p2_.modedepaiement AS modedepaiement_59, p2_.num AS num_60, p2_.remise AS remise_61, d0_.vendeurs_id AS vendeurs_id_62, d0_.client_id AS client_id_63, d0_.user_id AS user_id_64, d0_.fournisseur_id AS fournisseur_id_65, c1_.region_id AS region_id_66, p2_.devis_id AS devis_id_67 FROM devis d0_ LEFT JOIN client c1_ ON d0_.client_id = c1_.id LEFT JOIN paymentdevi p2_ ON d0_.id = p2_.devis_id WHERE d0_.statut IN ('Facture', 'BL', 'BLP') ORDER BY d0_.date DESC, d0_.datecreation DESC, d0_.id DESC;

SELECT
  b0_.id AS id_0,
  b0_.nomprenom AS nomprenom_1,
  b0_.adresse AS adresse_2,
  b0_.telephone AS telephone_3,
  b0_.datecreation AS datecreation_4,
  b0_.numbs AS numbs_5,
  b0_.date AS date_6,
  b0_.totaleqte AS totaleqte_7,
  b0_.totaleht AS totaleht_8,
  b0_.totaltva AS totaltva_9,
  b0_.totalttc AS totalttc_10,
  c1_.id AS id_11,
  c1_.email AS email_12,
  c1_.nom AS nom_13,
  c1_.prenom AS prenom_14,
  c1_.raisonsocial AS raisonsocial_15,
  c1_.adresse AS adresse_16,
  c1_.tel AS tel_17,
  c1_.photo AS photo_18,
  c1_.faxclient AS faxclient_19,
  c1_.mfclient AS mfclient_20,
  c1_.exoneres AS exoneres_21,
  b0_.vendeur_id AS vendeur_id_22,
  b0_.client_id AS client_id_23,
  c1_.region_id AS region_id_24
FROM
  bondesortie b0_
  LEFT JOIN client c1_ ON b0_.client_id = c1_.id
ORDER BY
  b0_.date DESC,
  b0_.datecreation DESC,
  b0_.id DESC

SELECT b0_.id AS id_0, b0_.nomprenom AS nomprenom_1, b0_.adresse AS adresse_2, b0_.telephone AS telephone_3, b0_.datecreation AS datecreation_4, b0_.numbs AS numbs_5, b0_.date AS date_6, b0_.totaleqte AS totaleqte_7, b0_.totaleht AS totaleht_8, b0_.totaltva AS totaltva_9, b0_.totalttc AS totalttc_10, c1_.id AS id_11, c1_.email AS email_12, c1_.nom AS nom_13, c1_.prenom AS prenom_14, c1_.raisonsocial AS raisonsocial_15, c1_.adresse AS adresse_16, c1_.tel AS tel_17, c1_.photo AS photo_18, c1_.faxclient AS faxclient_19, c1_.mfclient AS mfclient_20, c1_.exoneres AS exoneres_21, b0_.vendeur_id AS vendeur_id_22, b0_.client_id AS client_id_23, c1_.region_id AS region_id_24 FROM bondesortie b0_ LEFT JOIN client c1_ ON b0_.client_id = c1_.id ORDER BY b0_.date DESC, b0_.datecreation DESC, b0_.id DESC;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.nom AS nom_3,
  t0.prenom AS prenom_4,
  t0.raisonsocial AS raisonsocial_5,
  t0.adresse AS adresse_6,
  t0.tel AS tel_7,
  t0.photo AS photo_8,
  t0.faxclient AS faxclient_9,
  t0.mfclient AS mfclient_10,
  t0.exoneres AS exoneres_11,
  t0.region_id AS region_id_12
FROM
  client t0
ORDER BY
  t0.raisonsocial ASC,
  t0.nom ASC,
  t0.prenom ASC

SELECT t0.id AS id_1, t0.email AS email_2, t0.nom AS nom_3, t0.prenom AS prenom_4, t0.raisonsocial AS raisonsocial_5, t0.adresse AS adresse_6, t0.tel AS tel_7, t0.photo AS photo_8, t0.faxclient AS faxclient_9, t0.mfclient AS mfclient_10, t0.exoneres AS exoneres_11, t0.region_id AS region_id_12 FROM client t0 ORDER BY t0.raisonsocial ASC, t0.nom ASC, t0.prenom ASC;