Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.libele AS libele_2,
  t0.drapoCloture AS drapoCloture_3
FROM
  Bailleur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libele AS libele_2, t0.drapoCloture AS drapoCloture_3 FROM Bailleur t0 WHERE t0.id = 1;

SELECT
  d0_.id AS id_0,
  d0_.piece_jointe AS piece_jointe_1,
  d0_.drapoDRMEDICAL AS drapoDRMEDICAL_2,
  d0_.drapoDRMEDICALrefu AS drapoDRMEDICALrefu_3,
  d0_.dateDRMEDICAL AS dateDRMEDICAL_4,
  d0_.objet AS objet_5,
  d0_.delaisPrevu AS delaisPrevu_6,
  d0_.dateSoumis AS dateSoumis_7,
  d0_.nomProjet AS nomProjet_8,
  d0_.raisonRefu AS raisonRefu_9,
  d0_.numDemandeAchat AS numDemandeAchat_10,
  d0_.numOrdre AS numOrdre_11,
  d0_.centreCout AS centreCout_12,
  d0_.bailleur AS bailleur_13,
  d0_.projet AS projet_14,
  d0_.ligneBudget AS ligneBudget_15,
  d0_.designation AS designation_16,
  d0_.description AS description_17,
  d0_.observation AS observation_18,
  d0_.prixU AS prixU_19,
  d0_.montant AS montant_20,
  d0_.quantDemande AS quantDemande_21,
  d0_.quantiteValidee AS quantiteValidee_22,
  d0_.quantAccorde AS quantAccorde_23,
  d0_.numBC AS numBC_24,
  d0_.tva AS tva_25,
  d0_.drapoValide AS drapoValide_26,
  d0_.drapoTraite AS drapoTraite_27,
  d0_.drapoStatut AS drapoStatut_28,
  d0_.drapoImp AS drapoImp_29,
  d0_.drapoSup AS drapoSup_30,
  d0_.drapoSuprefu AS drapoSuprefu_31,
  d0_.drapoRR AS drapoRR_32,
  d0_.drapoRRrefu AS drapoRRrefu_33,
  d0_.drapoDP AS drapoDP_34,
  d0_.drapoDPrefu AS drapoDPrefu_35,
  d0_.drapoDSCSC AS drapoDSCSC_36,
  d0_.drapoDSCSCrefu AS drapoDSCSCrefu_37,
  d0_.etat AS etat_38,
  d0_.drapoRespAcha AS drapoRespAcha_39,
  d0_.drapoRespAcharefu AS drapoRespAcharefu_40,
  d0_.drapoRespReg AS drapoRespReg_41,
  d0_.drapoRespRegrefu AS drapoRespRegrefu_42,
  d0_.drapoLead AS drapoLead_43,
  d0_.drapoLeadrefu AS drapoLeadrefu_44,
  d0_.drapoChefp AS drapoChefp_45,
  d0_.drapoChefprefu AS drapoChefprefu_46,
  d0_.drapoChefp1 AS drapoChefp1_47,
  d0_.drapoChefprefu1 AS drapoChefprefu1_48,
  d0_.drapoChefp2 AS drapoChefp2_49,
  d0_.drapoChefprefu2 AS drapoChefprefu2_50,
  d0_.drapoChefp3 AS drapoChefp3_51,
  d0_.drapoChefprefu3 AS drapoChefprefu3_52,
  d0_.drapoChefp4 AS drapoChefp4_53,
  d0_.drapoChefprefu4 AS drapoChefprefu4_54,
  d0_.drapoChefp5 AS drapoChefp5_55,
  d0_.drapoChefprefu5 AS drapoChefprefu5_56,
  d0_.drapoChefp6 AS drapoChefp6_57,
  d0_.drapoChefprefu6 AS drapoChefprefu6_58,
  d0_.drapoChefp7 AS drapoChefp7_59,
  d0_.drapoChefprefu7 AS drapoChefprefu7_60,
  d0_.drapoRejetchef AS drapoRejetchef_61,
  d0_.drapoInfo AS drapoInfo_62,
  d0_.drapoInforefu AS drapoInforefu_63,
  d0_.drapoGarage AS drapoGarage_64,
  d0_.drapoGaragerefu AS drapoGaragerefu_65,
  d0_.drapoLead1 AS drapoLead1_66,
  d0_.drapoLead2 AS drapoLead2_67,
  d0_.drapoLead3 AS drapoLead3_68,
  d0_.drapoLead4 AS drapoLead4_69,
  d0_.drapoLead5 AS drapoLead5_70,
  d0_.drapoLeadrefu1 AS drapoLeadrefu1_71,
  d0_.drapoLeadrefu2 AS drapoLeadrefu2_72,
  d0_.drapoLeadrefu3 AS drapoLeadrefu3_73,
  d0_.drapoLeadrefu4 AS drapoLeadrefu4_74,
  d0_.drapoLeadrefu5 AS drapoLeadrefu5_75,
  d0_.drapoRejetLead AS drapoRejetLead_76,
  d0_.drapoPriCharge AS drapoPriCharge_77,
  d0_.drapoDP1 AS drapoDP1_78,
  d0_.drapoDP2 AS drapoDP2_79,
  d0_.drapoDP3 AS drapoDP3_80,
  d0_.drapoDP4 AS drapoDP4_81,
  d0_.drapoDP5 AS drapoDP5_82,
  d0_.drapoDP6 AS drapoDP6_83,
  d0_.drapoDP7 AS drapoDP7_84,
  d0_.drapoDP8 AS drapoDP8_85,
  d0_.drapoDPrefu1 AS drapoDPrefu1_86,
  d0_.drapoDPrefu2 AS drapoDPrefu2_87,
  d0_.drapoDPrefu3 AS drapoDPrefu3_88,
  d0_.drapoDPrefu4 AS drapoDPrefu4_89,
  d0_.drapoDPrefu5 AS drapoDPrefu5_90,
  d0_.drapoDPrefu6 AS drapoDPrefu6_91,
  d0_.drapoDPrefu7 AS drapoDPrefu7_92,
  d0_.drapoDPrefu8 AS drapoDPrefu8_93,
  d0_.dateDP1 AS dateDP1_94,
  d0_.dateDP2 AS dateDP2_95,
  d0_.dateDP3 AS dateDP3_96,
  d0_.dateDP4 AS dateDP4_97,
  d0_.dateDP5 AS dateDP5_98,
  d0_.dateDP6 AS dateDP6_99,
  d0_.dateDP7 AS dateDP7_100,
  d0_.dateDP8 AS dateDP8_101,
  d0_.dateLead1 AS dateLead1_102,
  d0_.dateLead2 AS dateLead2_103,
  d0_.dateLead3 AS dateLead3_104,
  d0_.dateLead4 AS dateLead4_105,
  d0_.dateLead5 AS dateLead5_106,
  d0_.dateInfo AS dateInfo_107,
  d0_.dateGarage AS dateGarage_108,
  d0_.dateDSCSC AS dateDSCSC_109,
  d0_.dateRespAcha AS dateRespAcha_110,
  d0_.dateRespReg AS dateRespReg_111,
  d0_.dateSuph AS dateSuph_112,
  d0_.dateDP AS dateDP_113,
  d0_.dateRR AS dateRR_114,
  d0_.dateLead AS dateLead_115,
  d0_.dateChefp AS dateChefp_116,
  d0_.dateChefp1 AS dateChefp1_117,
  d0_.dateChefp2 AS dateChefp2_118,
  d0_.dateChefp3 AS dateChefp3_119,
  d0_.dateChefp4 AS dateChefp4_120,
  d0_.dateChefp5 AS dateChefp5_121,
  d0_.dateChefp6 AS dateChefp6_122,
  d0_.dateChefp7 AS dateChefp7_123,
  d0_.delais AS delais_124,
  d0_.region AS region_125,
  d0_.quantDemand AS quantDemand_126,
  d0_.quantAccord AS quantAccord_127,
  d0_.contratCadrePropose AS contratCadrePropose_128,
  d0_.contratCadreValide AS contratCadreValide_129,
  d0_.motifRefusContrat AS motifRefusContrat_130,
  d0_.reserve_contrat_cadre AS reserve_contrat_cadre_131,
  d0_.statut_contrat_cadre AS statut_contrat_cadre_132,
  d0_.drapo_cc AS drapo_cc_133,
  d0_.drapo_sans_cc AS drapo_sans_cc_134,
  d0_.drapo_cloture AS drapo_cloture_135,
  d0_.reste_acommander AS reste_acommander_136,
  d0_.signe_drmedical_id AS signe_drmedical_id_137,
  d0_.contrat_cadre_id AS contrat_cadre_id_138,
  d0_.commandeAchat_id AS commandeAchat_id_139,
  d0_.demPaiement_id AS demPaiement_id_140,
  d0_.user_id AS user_id_141,
  d0_.signeChef_id AS signeChef_id_142,
  d0_.catalogue_id AS catalogue_id_143,
  d0_.costcenter_id AS costcenter_id_144,
  d0_.nombaille_id AS nombaille_id_145,
  d0_.image_id AS image_id_146,
  d0_.signeInfo_id AS signeInfo_id_147,
  d0_.signeGarage_id AS signeGarage_id_148,
  d0_.signeLead1_id AS signeLead1_id_149,
  d0_.signeLead2_id AS signeLead2_id_150,
  d0_.signeLead3_id AS signeLead3_id_151,
  d0_.signeLead4_id AS signeLead4_id_152,
  d0_.signeLead5_id AS signeLead5_id_153,
  d0_.signeDP1_id AS signeDP1_id_154,
  d0_.signeDP2_id AS signeDP2_id_155,
  d0_.signeDP3_id AS signeDP3_id_156,
  d0_.signeDP4_id AS signeDP4_id_157,
  d0_.signeDP5_id AS signeDP5_id_158,
  d0_.signeDP6_id AS signeDP6_id_159,
  d0_.signeDP7_id AS signeDP7_id_160,
  d0_.signeDP8_id AS signeDP8_id_161,
  d0_.signeDF_id AS signeDF_id_162,
  d0_.signeDP_id AS signeDP_id_163,
  d0_.signeRR_id AS signeRR_id_164,
  d0_.signeSUP_id AS signeSUP_id_165,
  d0_.signeLead_id AS signeLead_id_166,
  d0_.signeRespAcha_id AS signeRespAcha_id_167,
  d0_.signeRespReg_id AS signeRespReg_id_168,
  d0_.signeChefp_id AS signeChefp_id_169,
  d0_.signeChefp1_id AS signeChefp1_id_170,
  d0_.signeChefp2_id AS signeChefp2_id_171,
  d0_.signeChefp3_id AS signeChefp3_id_172,
  d0_.signeChefp4_id AS signeChefp4_id_173,
  d0_.signeChefp5_id AS signeChefp5_id_174,
  d0_.signeChefp6_id AS signeChefp6_id_175,
  d0_.signeChefp7_id AS signeChefp7_id_176
FROM
  demAchat d0_
  LEFT JOIN CentreCout c1_ ON d0_.costcenter_id = c1_.id
  LEFT JOIN mstopeuser m2_ ON d0_.user_id = m2_.id
  LEFT JOIN SupH s3_ ON m2_.supH_id = s3_.id
WHERE
  (
    d0_.id > ?
    AND d0_.drapoDSCSC = 0
    AND d0_.drapoDSCSCrefu = 0
    AND d0_.montant > 2499999
    AND d0_.etat = 1
    AND c1_.code = 13
    AND d0_.drapoDP = 1
  )
  OR (
    d0_.id > ?
    AND d0_.drapoDSCSC = 0
    AND d0_.drapoDSCSCrefu = 0
    AND d0_.montant > 2499999
    AND d0_.etat = 1
    AND c1_.code = 61
    AND d0_.drapoChefp = 1
  )
  OR (
    d0_.id > ?
    AND d0_.drapoDSCSC = 0
    AND d0_.drapoDSCSCrefu = 0
    AND d0_.montant > 2499999
    AND d0_.etat = 1
    AND c1_.code = 61
    AND d0_.drapoChefp = 1
    AND d0_.nomProjet <> ?
  )
  OR (
    d0_.id > ?
    AND d0_.drapoDSCSC = 0
    AND d0_.drapoDSCSCrefu = 0
    AND d0_.montant > 2499999
    AND d0_.etat = 1
    AND c1_.code = 61
    AND d0_.drapoDP = 1
    AND d0_.nomProjet = ?
  )
  OR (
    d0_.id > ?
    AND d0_.drapoDSCSC = 0
    AND d0_.drapoDSCSCrefu = 0
    AND d0_.montant > 2499999
    AND d0_.etat = 1
    AND c1_.code = 13
    AND d0_.drapoDP = 1
    AND d0_.nomProjet = ?
  )
  OR (
    d0_.id > ?
    AND s3_.email = ?
    AND d0_.nomProjet = ?
    AND d0_.drapoSup = 0
    AND d0_.drapoSuprefu = 0
    AND d0_.etat = 1
  )
GROUP BY
  d0_.numDemandeAchat
ORDER BY
  d0_.numDemandeAchat DESC

SELECT d0_.id AS id_0, d0_.piece_jointe AS piece_jointe_1, d0_.drapoDRMEDICAL AS drapoDRMEDICAL_2, d0_.drapoDRMEDICALrefu AS drapoDRMEDICALrefu_3, d0_.dateDRMEDICAL AS dateDRMEDICAL_4, d0_.objet AS objet_5, d0_.delaisPrevu AS delaisPrevu_6, d0_.dateSoumis AS dateSoumis_7, d0_.nomProjet AS nomProjet_8, d0_.raisonRefu AS raisonRefu_9, d0_.numDemandeAchat AS numDemandeAchat_10, d0_.numOrdre AS numOrdre_11, d0_.centreCout AS centreCout_12, d0_.bailleur AS bailleur_13, d0_.projet AS projet_14, d0_.ligneBudget AS ligneBudget_15, d0_.designation AS designation_16, d0_.description AS description_17, d0_.observation AS observation_18, d0_.prixU AS prixU_19, d0_.montant AS montant_20, d0_.quantDemande AS quantDemande_21, d0_.quantiteValidee AS quantiteValidee_22, d0_.quantAccorde AS quantAccorde_23, d0_.numBC AS numBC_24, d0_.tva AS tva_25, d0_.drapoValide AS drapoValide_26, d0_.drapoTraite AS drapoTraite_27, d0_.drapoStatut AS drapoStatut_28, d0_.drapoImp AS drapoImp_29, d0_.drapoSup AS drapoSup_30, d0_.drapoSuprefu AS drapoSuprefu_31, d0_.drapoRR AS drapoRR_32, d0_.drapoRRrefu AS drapoRRrefu_33, d0_.drapoDP AS drapoDP_34, d0_.drapoDPrefu AS drapoDPrefu_35, d0_.drapoDSCSC AS drapoDSCSC_36, d0_.drapoDSCSCrefu AS drapoDSCSCrefu_37, d0_.etat AS etat_38, d0_.drapoRespAcha AS drapoRespAcha_39, d0_.drapoRespAcharefu AS drapoRespAcharefu_40, d0_.drapoRespReg AS drapoRespReg_41, d0_.drapoRespRegrefu AS drapoRespRegrefu_42, d0_.drapoLead AS drapoLead_43, d0_.drapoLeadrefu AS drapoLeadrefu_44, d0_.drapoChefp AS drapoChefp_45, d0_.drapoChefprefu AS drapoChefprefu_46, d0_.drapoChefp1 AS drapoChefp1_47, d0_.drapoChefprefu1 AS drapoChefprefu1_48, d0_.drapoChefp2 AS drapoChefp2_49, d0_.drapoChefprefu2 AS drapoChefprefu2_50, d0_.drapoChefp3 AS drapoChefp3_51, d0_.drapoChefprefu3 AS drapoChefprefu3_52, d0_.drapoChefp4 AS drapoChefp4_53, d0_.drapoChefprefu4 AS drapoChefprefu4_54, d0_.drapoChefp5 AS drapoChefp5_55, d0_.drapoChefprefu5 AS drapoChefprefu5_56, d0_.drapoChefp6 AS drapoChefp6_57, d0_.drapoChefprefu6 AS drapoChefprefu6_58, d0_.drapoChefp7 AS drapoChefp7_59, d0_.drapoChefprefu7 AS drapoChefprefu7_60, d0_.drapoRejetchef AS drapoRejetchef_61, d0_.drapoInfo AS drapoInfo_62, d0_.drapoInforefu AS drapoInforefu_63, d0_.drapoGarage AS drapoGarage_64, d0_.drapoGaragerefu AS drapoGaragerefu_65, d0_.drapoLead1 AS drapoLead1_66, d0_.drapoLead2 AS drapoLead2_67, d0_.drapoLead3 AS drapoLead3_68, d0_.drapoLead4 AS drapoLead4_69, d0_.drapoLead5 AS drapoLead5_70, d0_.drapoLeadrefu1 AS drapoLeadrefu1_71, d0_.drapoLeadrefu2 AS drapoLeadrefu2_72, d0_.drapoLeadrefu3 AS drapoLeadrefu3_73, d0_.drapoLeadrefu4 AS drapoLeadrefu4_74, d0_.drapoLeadrefu5 AS drapoLeadrefu5_75, d0_.drapoRejetLead AS drapoRejetLead_76, d0_.drapoPriCharge AS drapoPriCharge_77, d0_.drapoDP1 AS drapoDP1_78, d0_.drapoDP2 AS drapoDP2_79, d0_.drapoDP3 AS drapoDP3_80, d0_.drapoDP4 AS drapoDP4_81, d0_.drapoDP5 AS drapoDP5_82, d0_.drapoDP6 AS drapoDP6_83, d0_.drapoDP7 AS drapoDP7_84, d0_.drapoDP8 AS drapoDP8_85, d0_.drapoDPrefu1 AS drapoDPrefu1_86, d0_.drapoDPrefu2 AS drapoDPrefu2_87, d0_.drapoDPrefu3 AS drapoDPrefu3_88, d0_.drapoDPrefu4 AS drapoDPrefu4_89, d0_.drapoDPrefu5 AS drapoDPrefu5_90, d0_.drapoDPrefu6 AS drapoDPrefu6_91, d0_.drapoDPrefu7 AS drapoDPrefu7_92, d0_.drapoDPrefu8 AS drapoDPrefu8_93, d0_.dateDP1 AS dateDP1_94, d0_.dateDP2 AS dateDP2_95, d0_.dateDP3 AS dateDP3_96, d0_.dateDP4 AS dateDP4_97, d0_.dateDP5 AS dateDP5_98, d0_.dateDP6 AS dateDP6_99, d0_.dateDP7 AS dateDP7_100, d0_.dateDP8 AS dateDP8_101, d0_.dateLead1 AS dateLead1_102, d0_.dateLead2 AS dateLead2_103, d0_.dateLead3 AS dateLead3_104, d0_.dateLead4 AS dateLead4_105, d0_.dateLead5 AS dateLead5_106, d0_.dateInfo AS dateInfo_107, d0_.dateGarage AS dateGarage_108, d0_.dateDSCSC AS dateDSCSC_109, d0_.dateRespAcha AS dateRespAcha_110, d0_.dateRespReg AS dateRespReg_111, d0_.dateSuph AS dateSuph_112, d0_.dateDP AS dateDP_113, d0_.dateRR AS dateRR_114, d0_.dateLead AS dateLead_115, d0_.dateChefp AS dateChefp_116, d0_.dateChefp1 AS dateChefp1_117, d0_.dateChefp2 AS dateChefp2_118, d0_.dateChefp3 AS dateChefp3_119, d0_.dateChefp4 AS dateChefp4_120, d0_.dateChefp5 AS dateChefp5_121, d0_.dateChefp6 AS dateChefp6_122, d0_.dateChefp7 AS dateChefp7_123, d0_.delais AS delais_124, d0_.region AS region_125, d0_.quantDemand AS quantDemand_126, d0_.quantAccord AS quantAccord_127, d0_.contratCadrePropose AS contratCadrePropose_128, d0_.contratCadreValide AS contratCadreValide_129, d0_.motifRefusContrat AS motifRefusContrat_130, d0_.reserve_contrat_cadre AS reserve_contrat_cadre_131, d0_.statut_contrat_cadre AS statut_contrat_cadre_132, d0_.drapo_cc AS drapo_cc_133, d0_.drapo_sans_cc AS drapo_sans_cc_134, d0_.drapo_cloture AS drapo_cloture_135, d0_.reste_acommander AS reste_acommander_136, d0_.signe_drmedical_id AS signe_drmedical_id_137, d0_.contrat_cadre_id AS contrat_cadre_id_138, d0_.commandeAchat_id AS commandeAchat_id_139, d0_.demPaiement_id AS demPaiement_id_140, d0_.user_id AS user_id_141, d0_.signeChef_id AS signeChef_id_142, d0_.catalogue_id AS catalogue_id_143, d0_.costcenter_id AS costcenter_id_144, d0_.nombaille_id AS nombaille_id_145, d0_.image_id AS image_id_146, d0_.signeInfo_id AS signeInfo_id_147, d0_.signeGarage_id AS signeGarage_id_148, d0_.signeLead1_id AS signeLead1_id_149, d0_.signeLead2_id AS signeLead2_id_150, d0_.signeLead3_id AS signeLead3_id_151, d0_.signeLead4_id AS signeLead4_id_152, d0_.signeLead5_id AS signeLead5_id_153, d0_.signeDP1_id AS signeDP1_id_154, d0_.signeDP2_id AS signeDP2_id_155, d0_.signeDP3_id AS signeDP3_id_156, d0_.signeDP4_id AS signeDP4_id_157, d0_.signeDP5_id AS signeDP5_id_158, d0_.signeDP6_id AS signeDP6_id_159, d0_.signeDP7_id AS signeDP7_id_160, d0_.signeDP8_id AS signeDP8_id_161, d0_.signeDF_id AS signeDF_id_162, d0_.signeDP_id AS signeDP_id_163, d0_.signeRR_id AS signeRR_id_164, d0_.signeSUP_id AS signeSUP_id_165, d0_.signeLead_id AS signeLead_id_166, d0_.signeRespAcha_id AS signeRespAcha_id_167, d0_.signeRespReg_id AS signeRespReg_id_168, d0_.signeChefp_id AS signeChefp_id_169, d0_.signeChefp1_id AS signeChefp1_id_170, d0_.signeChefp2_id AS signeChefp2_id_171, d0_.signeChefp3_id AS signeChefp3_id_172, d0_.signeChefp4_id AS signeChefp4_id_173, d0_.signeChefp5_id AS signeChefp5_id_174, d0_.signeChefp6_id AS signeChefp6_id_175, d0_.signeChefp7_id AS signeChefp7_id_176 FROM demAchat d0_ LEFT JOIN CentreCout c1_ ON d0_.costcenter_id = c1_.id LEFT JOIN mstopeuser m2_ ON d0_.user_id = m2_.id LEFT JOIN SupH s3_ ON m2_.supH_id = s3_.id WHERE (d0_.id > 0 AND d0_.drapoDSCSC = 0 AND d0_.drapoDSCSCrefu = 0 AND d0_.montant > 2499999 AND d0_.etat = 1 AND c1_.code = 13 AND d0_.drapoDP = 1) OR (d0_.id > 0 AND d0_.drapoDSCSC = 0 AND d0_.drapoDSCSCrefu = 0 AND d0_.montant > 2499999 AND d0_.etat = 1 AND c1_.code = 61 AND d0_.drapoChefp = 1) OR (d0_.id > 0 AND d0_.drapoDSCSC = 0 AND d0_.drapoDSCSCrefu = 0 AND d0_.montant > 2499999 AND d0_.etat = 1 AND c1_.code = 61 AND d0_.drapoChefp = 1 AND d0_.nomProjet <> 'CSO') OR (d0_.id > 0 AND d0_.drapoDSCSC = 0 AND d0_.drapoDSCSCrefu = 0 AND d0_.montant > 2499999 AND d0_.etat = 1 AND c1_.code = 61 AND d0_.drapoDP = 1 AND d0_.nomProjet = 'CSO') OR (d0_.id > 0 AND d0_.drapoDSCSC = 0 AND d0_.drapoDSCSCrefu = 0 AND d0_.montant > 2499999 AND d0_.etat = 1 AND c1_.code = 13 AND d0_.drapoDP = 1 AND d0_.nomProjet = 'CSO') OR (d0_.id > 0 AND s3_.email = 'roger.coul@yahoo.fr' AND d0_.nomProjet = 'CSO' AND d0_.drapoSup = 0 AND d0_.drapoSuprefu = 0 AND d0_.etat = 1) GROUP BY d0_.numDemandeAchat ORDER BY d0_.numDemandeAchat DESC;

SELECT
  d0_.id AS id_0,
  d0_.piece_jointe AS piece_jointe_1,
  d0_.drapoDRMEDICAL AS drapoDRMEDICAL_2,
  d0_.drapoDRMEDICALrefu AS drapoDRMEDICALrefu_3,
  d0_.dateDRMEDICAL AS dateDRMEDICAL_4,
  d0_.objet AS objet_5,
  d0_.delaisPrevu AS delaisPrevu_6,
  d0_.dateSoumis AS dateSoumis_7,
  d0_.nomProjet AS nomProjet_8,
  d0_.raisonRefu AS raisonRefu_9,
  d0_.numDemandeAchat AS numDemandeAchat_10,
  d0_.numOrdre AS numOrdre_11,
  d0_.centreCout AS centreCout_12,
  d0_.bailleur AS bailleur_13,
  d0_.projet AS projet_14,
  d0_.ligneBudget AS ligneBudget_15,
  d0_.designation AS designation_16,
  d0_.description AS description_17,
  d0_.observation AS observation_18,
  d0_.prixU AS prixU_19,
  d0_.montant AS montant_20,
  d0_.quantDemande AS quantDemande_21,
  d0_.quantiteValidee AS quantiteValidee_22,
  d0_.quantAccorde AS quantAccorde_23,
  d0_.numBC AS numBC_24,
  d0_.tva AS tva_25,
  d0_.drapoValide AS drapoValide_26,
  d0_.drapoTraite AS drapoTraite_27,
  d0_.drapoStatut AS drapoStatut_28,
  d0_.drapoImp AS drapoImp_29,
  d0_.drapoSup AS drapoSup_30,
  d0_.drapoSuprefu AS drapoSuprefu_31,
  d0_.drapoRR AS drapoRR_32,
  d0_.drapoRRrefu AS drapoRRrefu_33,
  d0_.drapoDP AS drapoDP_34,
  d0_.drapoDPrefu AS drapoDPrefu_35,
  d0_.drapoDSCSC AS drapoDSCSC_36,
  d0_.drapoDSCSCrefu AS drapoDSCSCrefu_37,
  d0_.etat AS etat_38,
  d0_.drapoRespAcha AS drapoRespAcha_39,
  d0_.drapoRespAcharefu AS drapoRespAcharefu_40,
  d0_.drapoRespReg AS drapoRespReg_41,
  d0_.drapoRespRegrefu AS drapoRespRegrefu_42,
  d0_.drapoLead AS drapoLead_43,
  d0_.drapoLeadrefu AS drapoLeadrefu_44,
  d0_.drapoChefp AS drapoChefp_45,
  d0_.drapoChefprefu AS drapoChefprefu_46,
  d0_.drapoChefp1 AS drapoChefp1_47,
  d0_.drapoChefprefu1 AS drapoChefprefu1_48,
  d0_.drapoChefp2 AS drapoChefp2_49,
  d0_.drapoChefprefu2 AS drapoChefprefu2_50,
  d0_.drapoChefp3 AS drapoChefp3_51,
  d0_.drapoChefprefu3 AS drapoChefprefu3_52,
  d0_.drapoChefp4 AS drapoChefp4_53,
  d0_.drapoChefprefu4 AS drapoChefprefu4_54,
  d0_.drapoChefp5 AS drapoChefp5_55,
  d0_.drapoChefprefu5 AS drapoChefprefu5_56,
  d0_.drapoChefp6 AS drapoChefp6_57,
  d0_.drapoChefprefu6 AS drapoChefprefu6_58,
  d0_.drapoChefp7 AS drapoChefp7_59,
  d0_.drapoChefprefu7 AS drapoChefprefu7_60,
  d0_.drapoRejetchef AS drapoRejetchef_61,
  d0_.drapoInfo AS drapoInfo_62,
  d0_.drapoInforefu AS drapoInforefu_63,
  d0_.drapoGarage AS drapoGarage_64,
  d0_.drapoGaragerefu AS drapoGaragerefu_65,
  d0_.drapoLead1 AS drapoLead1_66,
  d0_.drapoLead2 AS drapoLead2_67,
  d0_.drapoLead3 AS drapoLead3_68,
  d0_.drapoLead4 AS drapoLead4_69,
  d0_.drapoLead5 AS drapoLead5_70,
  d0_.drapoLeadrefu1 AS drapoLeadrefu1_71,
  d0_.drapoLeadrefu2 AS drapoLeadrefu2_72,
  d0_.drapoLeadrefu3 AS drapoLeadrefu3_73,
  d0_.drapoLeadrefu4 AS drapoLeadrefu4_74,
  d0_.drapoLeadrefu5 AS drapoLeadrefu5_75,
  d0_.drapoRejetLead AS drapoRejetLead_76,
  d0_.drapoPriCharge AS drapoPriCharge_77,
  d0_.drapoDP1 AS drapoDP1_78,
  d0_.drapoDP2 AS drapoDP2_79,
  d0_.drapoDP3 AS drapoDP3_80,
  d0_.drapoDP4 AS drapoDP4_81,
  d0_.drapoDP5 AS drapoDP5_82,
  d0_.drapoDP6 AS drapoDP6_83,
  d0_.drapoDP7 AS drapoDP7_84,
  d0_.drapoDP8 AS drapoDP8_85,
  d0_.drapoDPrefu1 AS drapoDPrefu1_86,
  d0_.drapoDPrefu2 AS drapoDPrefu2_87,
  d0_.drapoDPrefu3 AS drapoDPrefu3_88,
  d0_.drapoDPrefu4 AS drapoDPrefu4_89,
  d0_.drapoDPrefu5 AS drapoDPrefu5_90,
  d0_.drapoDPrefu6 AS drapoDPrefu6_91,
  d0_.drapoDPrefu7 AS drapoDPrefu7_92,
  d0_.drapoDPrefu8 AS drapoDPrefu8_93,
  d0_.dateDP1 AS dateDP1_94,
  d0_.dateDP2 AS dateDP2_95,
  d0_.dateDP3 AS dateDP3_96,
  d0_.dateDP4 AS dateDP4_97,
  d0_.dateDP5 AS dateDP5_98,
  d0_.dateDP6 AS dateDP6_99,
  d0_.dateDP7 AS dateDP7_100,
  d0_.dateDP8 AS dateDP8_101,
  d0_.dateLead1 AS dateLead1_102,
  d0_.dateLead2 AS dateLead2_103,
  d0_.dateLead3 AS dateLead3_104,
  d0_.dateLead4 AS dateLead4_105,
  d0_.dateLead5 AS dateLead5_106,
  d0_.dateInfo AS dateInfo_107,
  d0_.dateGarage AS dateGarage_108,
  d0_.dateDSCSC AS dateDSCSC_109,
  d0_.dateRespAcha AS dateRespAcha_110,
  d0_.dateRespReg AS dateRespReg_111,
  d0_.dateSuph AS dateSuph_112,
  d0_.dateDP AS dateDP_113,
  d0_.dateRR AS dateRR_114,
  d0_.dateLead AS dateLead_115,
  d0_.dateChefp AS dateChefp_116,
  d0_.dateChefp1 AS dateChefp1_117,
  d0_.dateChefp2 AS dateChefp2_118,
  d0_.dateChefp3 AS dateChefp3_119,
  d0_.dateChefp4 AS dateChefp4_120,
  d0_.dateChefp5 AS dateChefp5_121,
  d0_.dateChefp6 AS dateChefp6_122,
  d0_.dateChefp7 AS dateChefp7_123,
  d0_.delais AS delais_124,
  d0_.region AS region_125,
  d0_.quantDemand AS quantDemand_126,
  d0_.quantAccord AS quantAccord_127,
  d0_.contratCadrePropose AS contratCadrePropose_128,
  d0_.contratCadreValide AS contratCadreValide_129,
  d0_.motifRefusContrat AS motifRefusContrat_130,
  d0_.reserve_contrat_cadre AS reserve_contrat_cadre_131,
  d0_.statut_contrat_cadre AS statut_contrat_cadre_132,
  d0_.drapo_cc AS drapo_cc_133,
  d0_.drapo_sans_cc AS drapo_sans_cc_134,
  d0_.drapo_cloture AS drapo_cloture_135,
  d0_.reste_acommander AS reste_acommander_136,
  d0_.signe_drmedical_id AS signe_drmedical_id_137,
  d0_.contrat_cadre_id AS contrat_cadre_id_138,
  d0_.commandeAchat_id AS commandeAchat_id_139,
  d0_.demPaiement_id AS demPaiement_id_140,
  d0_.user_id AS user_id_141,
  d0_.signeChef_id AS signeChef_id_142,
  d0_.catalogue_id AS catalogue_id_143,
  d0_.costcenter_id AS costcenter_id_144,
  d0_.nombaille_id AS nombaille_id_145,
  d0_.image_id AS image_id_146,
  d0_.signeInfo_id AS signeInfo_id_147,
  d0_.signeGarage_id AS signeGarage_id_148,
  d0_.signeLead1_id AS signeLead1_id_149,
  d0_.signeLead2_id AS signeLead2_id_150,
  d0_.signeLead3_id AS signeLead3_id_151,
  d0_.signeLead4_id AS signeLead4_id_152,
  d0_.signeLead5_id AS signeLead5_id_153,
  d0_.signeDP1_id AS signeDP1_id_154,
  d0_.signeDP2_id AS signeDP2_id_155,
  d0_.signeDP3_id AS signeDP3_id_156,
  d0_.signeDP4_id AS signeDP4_id_157,
  d0_.signeDP5_id AS signeDP5_id_158,
  d0_.signeDP6_id AS signeDP6_id_159,
  d0_.signeDP7_id AS signeDP7_id_160,
  d0_.signeDP8_id AS signeDP8_id_161,
  d0_.signeDF_id AS signeDF_id_162,
  d0_.signeDP_id AS signeDP_id_163,
  d0_.signeRR_id AS signeRR_id_164,
  d0_.signeSUP_id AS signeSUP_id_165,
  d0_.signeLead_id AS signeLead_id_166,
  d0_.signeRespAcha_id AS signeRespAcha_id_167,
  d0_.signeRespReg_id AS signeRespReg_id_168,
  d0_.signeChefp_id AS signeChefp_id_169,
  d0_.signeChefp1_id AS signeChefp1_id_170,
  d0_.signeChefp2_id AS signeChefp2_id_171,
  d0_.signeChefp3_id AS signeChefp3_id_172,
  d0_.signeChefp4_id AS signeChefp4_id_173,
  d0_.signeChefp5_id AS signeChefp5_id_174,
  d0_.signeChefp6_id AS signeChefp6_id_175,
  d0_.signeChefp7_id AS signeChefp7_id_176
FROM
  demAchat d0_
WHERE
  d0_.id > ?
GROUP BY
  d0_.numDemandeAchat
ORDER BY
  d0_.numDemandeAchat DESC

SELECT d0_.id AS id_0, d0_.piece_jointe AS piece_jointe_1, d0_.drapoDRMEDICAL AS drapoDRMEDICAL_2, d0_.drapoDRMEDICALrefu AS drapoDRMEDICALrefu_3, d0_.dateDRMEDICAL AS dateDRMEDICAL_4, d0_.objet AS objet_5, d0_.delaisPrevu AS delaisPrevu_6, d0_.dateSoumis AS dateSoumis_7, d0_.nomProjet AS nomProjet_8, d0_.raisonRefu AS raisonRefu_9, d0_.numDemandeAchat AS numDemandeAchat_10, d0_.numOrdre AS numOrdre_11, d0_.centreCout AS centreCout_12, d0_.bailleur AS bailleur_13, d0_.projet AS projet_14, d0_.ligneBudget AS ligneBudget_15, d0_.designation AS designation_16, d0_.description AS description_17, d0_.observation AS observation_18, d0_.prixU AS prixU_19, d0_.montant AS montant_20, d0_.quantDemande AS quantDemande_21, d0_.quantiteValidee AS quantiteValidee_22, d0_.quantAccorde AS quantAccorde_23, d0_.numBC AS numBC_24, d0_.tva AS tva_25, d0_.drapoValide AS drapoValide_26, d0_.drapoTraite AS drapoTraite_27, d0_.drapoStatut AS drapoStatut_28, d0_.drapoImp AS drapoImp_29, d0_.drapoSup AS drapoSup_30, d0_.drapoSuprefu AS drapoSuprefu_31, d0_.drapoRR AS drapoRR_32, d0_.drapoRRrefu AS drapoRRrefu_33, d0_.drapoDP AS drapoDP_34, d0_.drapoDPrefu AS drapoDPrefu_35, d0_.drapoDSCSC AS drapoDSCSC_36, d0_.drapoDSCSCrefu AS drapoDSCSCrefu_37, d0_.etat AS etat_38, d0_.drapoRespAcha AS drapoRespAcha_39, d0_.drapoRespAcharefu AS drapoRespAcharefu_40, d0_.drapoRespReg AS drapoRespReg_41, d0_.drapoRespRegrefu AS drapoRespRegrefu_42, d0_.drapoLead AS drapoLead_43, d0_.drapoLeadrefu AS drapoLeadrefu_44, d0_.drapoChefp AS drapoChefp_45, d0_.drapoChefprefu AS drapoChefprefu_46, d0_.drapoChefp1 AS drapoChefp1_47, d0_.drapoChefprefu1 AS drapoChefprefu1_48, d0_.drapoChefp2 AS drapoChefp2_49, d0_.drapoChefprefu2 AS drapoChefprefu2_50, d0_.drapoChefp3 AS drapoChefp3_51, d0_.drapoChefprefu3 AS drapoChefprefu3_52, d0_.drapoChefp4 AS drapoChefp4_53, d0_.drapoChefprefu4 AS drapoChefprefu4_54, d0_.drapoChefp5 AS drapoChefp5_55, d0_.drapoChefprefu5 AS drapoChefprefu5_56, d0_.drapoChefp6 AS drapoChefp6_57, d0_.drapoChefprefu6 AS drapoChefprefu6_58, d0_.drapoChefp7 AS drapoChefp7_59, d0_.drapoChefprefu7 AS drapoChefprefu7_60, d0_.drapoRejetchef AS drapoRejetchef_61, d0_.drapoInfo AS drapoInfo_62, d0_.drapoInforefu AS drapoInforefu_63, d0_.drapoGarage AS drapoGarage_64, d0_.drapoGaragerefu AS drapoGaragerefu_65, d0_.drapoLead1 AS drapoLead1_66, d0_.drapoLead2 AS drapoLead2_67, d0_.drapoLead3 AS drapoLead3_68, d0_.drapoLead4 AS drapoLead4_69, d0_.drapoLead5 AS drapoLead5_70, d0_.drapoLeadrefu1 AS drapoLeadrefu1_71, d0_.drapoLeadrefu2 AS drapoLeadrefu2_72, d0_.drapoLeadrefu3 AS drapoLeadrefu3_73, d0_.drapoLeadrefu4 AS drapoLeadrefu4_74, d0_.drapoLeadrefu5 AS drapoLeadrefu5_75, d0_.drapoRejetLead AS drapoRejetLead_76, d0_.drapoPriCharge AS drapoPriCharge_77, d0_.drapoDP1 AS drapoDP1_78, d0_.drapoDP2 AS drapoDP2_79, d0_.drapoDP3 AS drapoDP3_80, d0_.drapoDP4 AS drapoDP4_81, d0_.drapoDP5 AS drapoDP5_82, d0_.drapoDP6 AS drapoDP6_83, d0_.drapoDP7 AS drapoDP7_84, d0_.drapoDP8 AS drapoDP8_85, d0_.drapoDPrefu1 AS drapoDPrefu1_86, d0_.drapoDPrefu2 AS drapoDPrefu2_87, d0_.drapoDPrefu3 AS drapoDPrefu3_88, d0_.drapoDPrefu4 AS drapoDPrefu4_89, d0_.drapoDPrefu5 AS drapoDPrefu5_90, d0_.drapoDPrefu6 AS drapoDPrefu6_91, d0_.drapoDPrefu7 AS drapoDPrefu7_92, d0_.drapoDPrefu8 AS drapoDPrefu8_93, d0_.dateDP1 AS dateDP1_94, d0_.dateDP2 AS dateDP2_95, d0_.dateDP3 AS dateDP3_96, d0_.dateDP4 AS dateDP4_97, d0_.dateDP5 AS dateDP5_98, d0_.dateDP6 AS dateDP6_99, d0_.dateDP7 AS dateDP7_100, d0_.dateDP8 AS dateDP8_101, d0_.dateLead1 AS dateLead1_102, d0_.dateLead2 AS dateLead2_103, d0_.dateLead3 AS dateLead3_104, d0_.dateLead4 AS dateLead4_105, d0_.dateLead5 AS dateLead5_106, d0_.dateInfo AS dateInfo_107, d0_.dateGarage AS dateGarage_108, d0_.dateDSCSC AS dateDSCSC_109, d0_.dateRespAcha AS dateRespAcha_110, d0_.dateRespReg AS dateRespReg_111, d0_.dateSuph AS dateSuph_112, d0_.dateDP AS dateDP_113, d0_.dateRR AS dateRR_114, d0_.dateLead AS dateLead_115, d0_.dateChefp AS dateChefp_116, d0_.dateChefp1 AS dateChefp1_117, d0_.dateChefp2 AS dateChefp2_118, d0_.dateChefp3 AS dateChefp3_119, d0_.dateChefp4 AS dateChefp4_120, d0_.dateChefp5 AS dateChefp5_121, d0_.dateChefp6 AS dateChefp6_122, d0_.dateChefp7 AS dateChefp7_123, d0_.delais AS delais_124, d0_.region AS region_125, d0_.quantDemand AS quantDemand_126, d0_.quantAccord AS quantAccord_127, d0_.contratCadrePropose AS contratCadrePropose_128, d0_.contratCadreValide AS contratCadreValide_129, d0_.motifRefusContrat AS motifRefusContrat_130, d0_.reserve_contrat_cadre AS reserve_contrat_cadre_131, d0_.statut_contrat_cadre AS statut_contrat_cadre_132, d0_.drapo_cc AS drapo_cc_133, d0_.drapo_sans_cc AS drapo_sans_cc_134, d0_.drapo_cloture AS drapo_cloture_135, d0_.reste_acommander AS reste_acommander_136, d0_.signe_drmedical_id AS signe_drmedical_id_137, d0_.contrat_cadre_id AS contrat_cadre_id_138, d0_.commandeAchat_id AS commandeAchat_id_139, d0_.demPaiement_id AS demPaiement_id_140, d0_.user_id AS user_id_141, d0_.signeChef_id AS signeChef_id_142, d0_.catalogue_id AS catalogue_id_143, d0_.costcenter_id AS costcenter_id_144, d0_.nombaille_id AS nombaille_id_145, d0_.image_id AS image_id_146, d0_.signeInfo_id AS signeInfo_id_147, d0_.signeGarage_id AS signeGarage_id_148, d0_.signeLead1_id AS signeLead1_id_149, d0_.signeLead2_id AS signeLead2_id_150, d0_.signeLead3_id AS signeLead3_id_151, d0_.signeLead4_id AS signeLead4_id_152, d0_.signeLead5_id AS signeLead5_id_153, d0_.signeDP1_id AS signeDP1_id_154, d0_.signeDP2_id AS signeDP2_id_155, d0_.signeDP3_id AS signeDP3_id_156, d0_.signeDP4_id AS signeDP4_id_157, d0_.signeDP5_id AS signeDP5_id_158, d0_.signeDP6_id AS signeDP6_id_159, d0_.signeDP7_id AS signeDP7_id_160, d0_.signeDP8_id AS signeDP8_id_161, d0_.signeDF_id AS signeDF_id_162, d0_.signeDP_id AS signeDP_id_163, d0_.signeRR_id AS signeRR_id_164, d0_.signeSUP_id AS signeSUP_id_165, d0_.signeLead_id AS signeLead_id_166, d0_.signeRespAcha_id AS signeRespAcha_id_167, d0_.signeRespReg_id AS signeRespReg_id_168, d0_.signeChefp_id AS signeChefp_id_169, d0_.signeChefp1_id AS signeChefp1_id_170, d0_.signeChefp2_id AS signeChefp2_id_171, d0_.signeChefp3_id AS signeChefp3_id_172, d0_.signeChefp4_id AS signeChefp4_id_173, d0_.signeChefp5_id AS signeChefp5_id_174, d0_.signeChefp6_id AS signeChefp6_id_175, d0_.signeChefp7_id AS signeChefp7_id_176 FROM demAchat d0_ WHERE d0_.id > 0 GROUP BY d0_.numDemandeAchat ORDER BY d0_.numDemandeAchat DESC;