Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.passwordChangedAt AS passwordChangedAt_2,
  t0.username AS username_3,
  t0.username_canonical AS username_canonical_4,
  t0.email AS email_5,
  t0.email_canonical AS email_canonical_6,
  t0.enabled AS enabled_7,
  t0.salt AS salt_8,
  t0.password AS password_9,
  t0.last_login AS last_login_10,
  t0.confirmation_token AS confirmation_token_11,
  t0.password_requested_at AS password_requested_at_12,
  t0.locked AS locked_13,
  t0.expired AS expired_14,
  t0.expires_at AS expires_at_15,
  t0.roles AS roles_16,
  t0.credentials_expired AS credentials_expired_17,
  t0.credentials_expire_at AS credentials_expire_at_18,
  t0.nom AS nom_19,
  t0.idsup AS idsup_20,
  t0.equipe AS equipe_21,
  t0.prenom AS prenom_22,
  t0.poste AS poste_23,
  t0.service AS service_24,
  t0.tel AS tel_25,
  t0.zone AS zone_26,
  t0.locale AS locale_27,
  t0.supH_id AS supH_id_28,
  t0.images_id AS images_id_29,
  t0.reviewtec_id AS reviewtec_id_30,
  t0.approb_id AS approb_id_31
FROM
  mstopeuser t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.passwordChangedAt AS passwordChangedAt_2, t0.username AS username_3, t0.username_canonical AS username_canonical_4, t0.email AS email_5, t0.email_canonical AS email_canonical_6, t0.enabled AS enabled_7, t0.salt AS salt_8, t0.password AS password_9, t0.last_login AS last_login_10, t0.confirmation_token AS confirmation_token_11, t0.password_requested_at AS password_requested_at_12, t0.locked AS locked_13, t0.expired AS expired_14, t0.expires_at AS expires_at_15, t0.roles AS roles_16, t0.credentials_expired AS credentials_expired_17, t0.credentials_expire_at AS credentials_expire_at_18, t0.nom AS nom_19, t0.idsup AS idsup_20, t0.equipe AS equipe_21, t0.prenom AS prenom_22, t0.poste AS poste_23, t0.service AS service_24, t0.tel AS tel_25, t0.zone AS zone_26, t0.locale AS locale_27, t0.supH_id AS supH_id_28, t0.images_id AS images_id_29, t0.reviewtec_id AS reviewtec_id_30, t0.approb_id AS approb_id_31 FROM mstopeuser t0 WHERE t0.id = 9;

SELECT
  t0.id AS id_1,
  t0.rue AS rue_2,
  t0.bp AS bp_3,
  t0.cms AS cms_4,
  t0.telsiege AS telsiege_5,
  t0.telclinique AS telclinique_6
FROM
  Parametre t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.rue AS rue_2, t0.bp AS bp_3, t0.cms AS cms_4, t0.telsiege AS telsiege_5, t0.telclinique AS telclinique_6 FROM Parametre t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.piece_jointe AS piece_jointe_2,
  t0.drapoDRMEDICAL AS drapoDRMEDICAL_3,
  t0.drapoDRMEDICALrefu AS drapoDRMEDICALrefu_4,
  t0.dateDRMEDICAL AS dateDRMEDICAL_5,
  t0.objet AS objet_6,
  t0.delaisPrevu AS delaisPrevu_7,
  t0.dateSoumis AS dateSoumis_8,
  t0.nomProjet AS nomProjet_9,
  t0.raisonRefu AS raisonRefu_10,
  t0.numDemandeAchat AS numDemandeAchat_11,
  t0.numOrdre AS numOrdre_12,
  t0.centreCout AS centreCout_13,
  t0.bailleur AS bailleur_14,
  t0.projet AS projet_15,
  t0.ligneBudget AS ligneBudget_16,
  t0.designation AS designation_17,
  t0.description AS description_18,
  t0.observation AS observation_19,
  t0.prixU AS prixU_20,
  t0.montant AS montant_21,
  t0.quantDemande AS quantDemande_22,
  t0.quantiteValidee AS quantiteValidee_23,
  t0.quantAccorde AS quantAccorde_24,
  t0.numBC AS numBC_25,
  t0.tva AS tva_26,
  t0.drapoValide AS drapoValide_27,
  t0.drapoTraite AS drapoTraite_28,
  t0.drapoStatut AS drapoStatut_29,
  t0.drapoImp AS drapoImp_30,
  t0.drapoSup AS drapoSup_31,
  t0.drapoSuprefu AS drapoSuprefu_32,
  t0.drapoRR AS drapoRR_33,
  t0.drapoRRrefu AS drapoRRrefu_34,
  t0.drapoDP AS drapoDP_35,
  t0.drapoDPrefu AS drapoDPrefu_36,
  t0.drapoDSCSC AS drapoDSCSC_37,
  t0.drapoDSCSCrefu AS drapoDSCSCrefu_38,
  t0.etat AS etat_39,
  t0.drapoRespAcha AS drapoRespAcha_40,
  t0.drapoRespAcharefu AS drapoRespAcharefu_41,
  t0.drapoRespReg AS drapoRespReg_42,
  t0.drapoRespRegrefu AS drapoRespRegrefu_43,
  t0.drapoLead AS drapoLead_44,
  t0.drapoLeadrefu AS drapoLeadrefu_45,
  t0.drapoChefp AS drapoChefp_46,
  t0.drapoChefprefu AS drapoChefprefu_47,
  t0.drapoChefp1 AS drapoChefp1_48,
  t0.drapoChefprefu1 AS drapoChefprefu1_49,
  t0.drapoChefp2 AS drapoChefp2_50,
  t0.drapoChefprefu2 AS drapoChefprefu2_51,
  t0.drapoChefp3 AS drapoChefp3_52,
  t0.drapoChefprefu3 AS drapoChefprefu3_53,
  t0.drapoChefp4 AS drapoChefp4_54,
  t0.drapoChefprefu4 AS drapoChefprefu4_55,
  t0.drapoChefp5 AS drapoChefp5_56,
  t0.drapoChefprefu5 AS drapoChefprefu5_57,
  t0.drapoChefp6 AS drapoChefp6_58,
  t0.drapoChefprefu6 AS drapoChefprefu6_59,
  t0.drapoChefp7 AS drapoChefp7_60,
  t0.drapoChefprefu7 AS drapoChefprefu7_61,
  t0.drapoRejetchef AS drapoRejetchef_62,
  t0.drapoInfo AS drapoInfo_63,
  t0.drapoInforefu AS drapoInforefu_64,
  t0.drapoGarage AS drapoGarage_65,
  t0.drapoGaragerefu AS drapoGaragerefu_66,
  t0.drapoLead1 AS drapoLead1_67,
  t0.drapoLead2 AS drapoLead2_68,
  t0.drapoLead3 AS drapoLead3_69,
  t0.drapoLead4 AS drapoLead4_70,
  t0.drapoLead5 AS drapoLead5_71,
  t0.drapoLeadrefu1 AS drapoLeadrefu1_72,
  t0.drapoLeadrefu2 AS drapoLeadrefu2_73,
  t0.drapoLeadrefu3 AS drapoLeadrefu3_74,
  t0.drapoLeadrefu4 AS drapoLeadrefu4_75,
  t0.drapoLeadrefu5 AS drapoLeadrefu5_76,
  t0.drapoRejetLead AS drapoRejetLead_77,
  t0.drapoPriCharge AS drapoPriCharge_78,
  t0.drapoDP1 AS drapoDP1_79,
  t0.drapoDP2 AS drapoDP2_80,
  t0.drapoDP3 AS drapoDP3_81,
  t0.drapoDP4 AS drapoDP4_82,
  t0.drapoDP5 AS drapoDP5_83,
  t0.drapoDP6 AS drapoDP6_84,
  t0.drapoDP7 AS drapoDP7_85,
  t0.drapoDP8 AS drapoDP8_86,
  t0.drapoDPrefu1 AS drapoDPrefu1_87,
  t0.drapoDPrefu2 AS drapoDPrefu2_88,
  t0.drapoDPrefu3 AS drapoDPrefu3_89,
  t0.drapoDPrefu4 AS drapoDPrefu4_90,
  t0.drapoDPrefu5 AS drapoDPrefu5_91,
  t0.drapoDPrefu6 AS drapoDPrefu6_92,
  t0.drapoDPrefu7 AS drapoDPrefu7_93,
  t0.drapoDPrefu8 AS drapoDPrefu8_94,
  t0.dateDP1 AS dateDP1_95,
  t0.dateDP2 AS dateDP2_96,
  t0.dateDP3 AS dateDP3_97,
  t0.dateDP4 AS dateDP4_98,
  t0.dateDP5 AS dateDP5_99,
  t0.dateDP6 AS dateDP6_100,
  t0.dateDP7 AS dateDP7_101,
  t0.dateDP8 AS dateDP8_102,
  t0.dateLead1 AS dateLead1_103,
  t0.dateLead2 AS dateLead2_104,
  t0.dateLead3 AS dateLead3_105,
  t0.dateLead4 AS dateLead4_106,
  t0.dateLead5 AS dateLead5_107,
  t0.dateInfo AS dateInfo_108,
  t0.dateGarage AS dateGarage_109,
  t0.dateDSCSC AS dateDSCSC_110,
  t0.dateRespAcha AS dateRespAcha_111,
  t0.dateRespReg AS dateRespReg_112,
  t0.dateSuph AS dateSuph_113,
  t0.dateDP AS dateDP_114,
  t0.dateRR AS dateRR_115,
  t0.dateLead AS dateLead_116,
  t0.dateChefp AS dateChefp_117,
  t0.dateChefp1 AS dateChefp1_118,
  t0.dateChefp2 AS dateChefp2_119,
  t0.dateChefp3 AS dateChefp3_120,
  t0.dateChefp4 AS dateChefp4_121,
  t0.dateChefp5 AS dateChefp5_122,
  t0.dateChefp6 AS dateChefp6_123,
  t0.dateChefp7 AS dateChefp7_124,
  t0.delais AS delais_125,
  t0.region AS region_126,
  t0.quantDemand AS quantDemand_127,
  t0.quantAccord AS quantAccord_128,
  t0.contratCadrePropose AS contratCadrePropose_129,
  t0.contratCadreValide AS contratCadreValide_130,
  t0.motifRefusContrat AS motifRefusContrat_131,
  t0.reserve_contrat_cadre AS reserve_contrat_cadre_132,
  t0.statut_contrat_cadre AS statut_contrat_cadre_133,
  t0.drapo_cc AS drapo_cc_134,
  t0.drapo_sans_cc AS drapo_sans_cc_135,
  t0.drapo_cloture AS drapo_cloture_136,
  t0.reste_acommander AS reste_acommander_137,
  t0.signe_drmedical_id AS signe_drmedical_id_138,
  t0.contrat_cadre_id AS contrat_cadre_id_139,
  t0.commandeAchat_id AS commandeAchat_id_140,
  t0.demPaiement_id AS demPaiement_id_141,
  t0.user_id AS user_id_142,
  t0.signeChef_id AS signeChef_id_143,
  t0.catalogue_id AS catalogue_id_144,
  t0.costcenter_id AS costcenter_id_145,
  t0.nombaille_id AS nombaille_id_146,
  t0.image_id AS image_id_147,
  t0.signeInfo_id AS signeInfo_id_148,
  t0.signeGarage_id AS signeGarage_id_149,
  t0.signeLead1_id AS signeLead1_id_150,
  t0.signeLead2_id AS signeLead2_id_151,
  t0.signeLead3_id AS signeLead3_id_152,
  t0.signeLead4_id AS signeLead4_id_153,
  t0.signeLead5_id AS signeLead5_id_154,
  t0.signeDP1_id AS signeDP1_id_155,
  t0.signeDP2_id AS signeDP2_id_156,
  t0.signeDP3_id AS signeDP3_id_157,
  t0.signeDP4_id AS signeDP4_id_158,
  t0.signeDP5_id AS signeDP5_id_159,
  t0.signeDP6_id AS signeDP6_id_160,
  t0.signeDP7_id AS signeDP7_id_161,
  t0.signeDP8_id AS signeDP8_id_162,
  t0.signeDF_id AS signeDF_id_163,
  t0.signeDP_id AS signeDP_id_164,
  t0.signeRR_id AS signeRR_id_165,
  t0.signeSUP_id AS signeSUP_id_166,
  t0.signeLead_id AS signeLead_id_167,
  t0.signeRespAcha_id AS signeRespAcha_id_168,
  t0.signeRespReg_id AS signeRespReg_id_169,
  t0.signeChefp_id AS signeChefp_id_170,
  t0.signeChefp1_id AS signeChefp1_id_171,
  t0.signeChefp2_id AS signeChefp2_id_172,
  t0.signeChefp3_id AS signeChefp3_id_173,
  t0.signeChefp4_id AS signeChefp4_id_174,
  t0.signeChefp5_id AS signeChefp5_id_175,
  t0.signeChefp6_id AS signeChefp6_id_176,
  t0.signeChefp7_id AS signeChefp7_id_177
FROM
  demAchat t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.piece_jointe AS piece_jointe_2, t0.drapoDRMEDICAL AS drapoDRMEDICAL_3, t0.drapoDRMEDICALrefu AS drapoDRMEDICALrefu_4, t0.dateDRMEDICAL AS dateDRMEDICAL_5, t0.objet AS objet_6, t0.delaisPrevu AS delaisPrevu_7, t0.dateSoumis AS dateSoumis_8, t0.nomProjet AS nomProjet_9, t0.raisonRefu AS raisonRefu_10, t0.numDemandeAchat AS numDemandeAchat_11, t0.numOrdre AS numOrdre_12, t0.centreCout AS centreCout_13, t0.bailleur AS bailleur_14, t0.projet AS projet_15, t0.ligneBudget AS ligneBudget_16, t0.designation AS designation_17, t0.description AS description_18, t0.observation AS observation_19, t0.prixU AS prixU_20, t0.montant AS montant_21, t0.quantDemande AS quantDemande_22, t0.quantiteValidee AS quantiteValidee_23, t0.quantAccorde AS quantAccorde_24, t0.numBC AS numBC_25, t0.tva AS tva_26, t0.drapoValide AS drapoValide_27, t0.drapoTraite AS drapoTraite_28, t0.drapoStatut AS drapoStatut_29, t0.drapoImp AS drapoImp_30, t0.drapoSup AS drapoSup_31, t0.drapoSuprefu AS drapoSuprefu_32, t0.drapoRR AS drapoRR_33, t0.drapoRRrefu AS drapoRRrefu_34, t0.drapoDP AS drapoDP_35, t0.drapoDPrefu AS drapoDPrefu_36, t0.drapoDSCSC AS drapoDSCSC_37, t0.drapoDSCSCrefu AS drapoDSCSCrefu_38, t0.etat AS etat_39, t0.drapoRespAcha AS drapoRespAcha_40, t0.drapoRespAcharefu AS drapoRespAcharefu_41, t0.drapoRespReg AS drapoRespReg_42, t0.drapoRespRegrefu AS drapoRespRegrefu_43, t0.drapoLead AS drapoLead_44, t0.drapoLeadrefu AS drapoLeadrefu_45, t0.drapoChefp AS drapoChefp_46, t0.drapoChefprefu AS drapoChefprefu_47, t0.drapoChefp1 AS drapoChefp1_48, t0.drapoChefprefu1 AS drapoChefprefu1_49, t0.drapoChefp2 AS drapoChefp2_50, t0.drapoChefprefu2 AS drapoChefprefu2_51, t0.drapoChefp3 AS drapoChefp3_52, t0.drapoChefprefu3 AS drapoChefprefu3_53, t0.drapoChefp4 AS drapoChefp4_54, t0.drapoChefprefu4 AS drapoChefprefu4_55, t0.drapoChefp5 AS drapoChefp5_56, t0.drapoChefprefu5 AS drapoChefprefu5_57, t0.drapoChefp6 AS drapoChefp6_58, t0.drapoChefprefu6 AS drapoChefprefu6_59, t0.drapoChefp7 AS drapoChefp7_60, t0.drapoChefprefu7 AS drapoChefprefu7_61, t0.drapoRejetchef AS drapoRejetchef_62, t0.drapoInfo AS drapoInfo_63, t0.drapoInforefu AS drapoInforefu_64, t0.drapoGarage AS drapoGarage_65, t0.drapoGaragerefu AS drapoGaragerefu_66, t0.drapoLead1 AS drapoLead1_67, t0.drapoLead2 AS drapoLead2_68, t0.drapoLead3 AS drapoLead3_69, t0.drapoLead4 AS drapoLead4_70, t0.drapoLead5 AS drapoLead5_71, t0.drapoLeadrefu1 AS drapoLeadrefu1_72, t0.drapoLeadrefu2 AS drapoLeadrefu2_73, t0.drapoLeadrefu3 AS drapoLeadrefu3_74, t0.drapoLeadrefu4 AS drapoLeadrefu4_75, t0.drapoLeadrefu5 AS drapoLeadrefu5_76, t0.drapoRejetLead AS drapoRejetLead_77, t0.drapoPriCharge AS drapoPriCharge_78, t0.drapoDP1 AS drapoDP1_79, t0.drapoDP2 AS drapoDP2_80, t0.drapoDP3 AS drapoDP3_81, t0.drapoDP4 AS drapoDP4_82, t0.drapoDP5 AS drapoDP5_83, t0.drapoDP6 AS drapoDP6_84, t0.drapoDP7 AS drapoDP7_85, t0.drapoDP8 AS drapoDP8_86, t0.drapoDPrefu1 AS drapoDPrefu1_87, t0.drapoDPrefu2 AS drapoDPrefu2_88, t0.drapoDPrefu3 AS drapoDPrefu3_89, t0.drapoDPrefu4 AS drapoDPrefu4_90, t0.drapoDPrefu5 AS drapoDPrefu5_91, t0.drapoDPrefu6 AS drapoDPrefu6_92, t0.drapoDPrefu7 AS drapoDPrefu7_93, t0.drapoDPrefu8 AS drapoDPrefu8_94, t0.dateDP1 AS dateDP1_95, t0.dateDP2 AS dateDP2_96, t0.dateDP3 AS dateDP3_97, t0.dateDP4 AS dateDP4_98, t0.dateDP5 AS dateDP5_99, t0.dateDP6 AS dateDP6_100, t0.dateDP7 AS dateDP7_101, t0.dateDP8 AS dateDP8_102, t0.dateLead1 AS dateLead1_103, t0.dateLead2 AS dateLead2_104, t0.dateLead3 AS dateLead3_105, t0.dateLead4 AS dateLead4_106, t0.dateLead5 AS dateLead5_107, t0.dateInfo AS dateInfo_108, t0.dateGarage AS dateGarage_109, t0.dateDSCSC AS dateDSCSC_110, t0.dateRespAcha AS dateRespAcha_111, t0.dateRespReg AS dateRespReg_112, t0.dateSuph AS dateSuph_113, t0.dateDP AS dateDP_114, t0.dateRR AS dateRR_115, t0.dateLead AS dateLead_116, t0.dateChefp AS dateChefp_117, t0.dateChefp1 AS dateChefp1_118, t0.dateChefp2 AS dateChefp2_119, t0.dateChefp3 AS dateChefp3_120, t0.dateChefp4 AS dateChefp4_121, t0.dateChefp5 AS dateChefp5_122, t0.dateChefp6 AS dateChefp6_123, t0.dateChefp7 AS dateChefp7_124, t0.delais AS delais_125, t0.region AS region_126, t0.quantDemand AS quantDemand_127, t0.quantAccord AS quantAccord_128, t0.contratCadrePropose AS contratCadrePropose_129, t0.contratCadreValide AS contratCadreValide_130, t0.motifRefusContrat AS motifRefusContrat_131, t0.reserve_contrat_cadre AS reserve_contrat_cadre_132, t0.statut_contrat_cadre AS statut_contrat_cadre_133, t0.drapo_cc AS drapo_cc_134, t0.drapo_sans_cc AS drapo_sans_cc_135, t0.drapo_cloture AS drapo_cloture_136, t0.reste_acommander AS reste_acommander_137, t0.signe_drmedical_id AS signe_drmedical_id_138, t0.contrat_cadre_id AS contrat_cadre_id_139, t0.commandeAchat_id AS commandeAchat_id_140, t0.demPaiement_id AS demPaiement_id_141, t0.user_id AS user_id_142, t0.signeChef_id AS signeChef_id_143, t0.catalogue_id AS catalogue_id_144, t0.costcenter_id AS costcenter_id_145, t0.nombaille_id AS nombaille_id_146, t0.image_id AS image_id_147, t0.signeInfo_id AS signeInfo_id_148, t0.signeGarage_id AS signeGarage_id_149, t0.signeLead1_id AS signeLead1_id_150, t0.signeLead2_id AS signeLead2_id_151, t0.signeLead3_id AS signeLead3_id_152, t0.signeLead4_id AS signeLead4_id_153, t0.signeLead5_id AS signeLead5_id_154, t0.signeDP1_id AS signeDP1_id_155, t0.signeDP2_id AS signeDP2_id_156, t0.signeDP3_id AS signeDP3_id_157, t0.signeDP4_id AS signeDP4_id_158, t0.signeDP5_id AS signeDP5_id_159, t0.signeDP6_id AS signeDP6_id_160, t0.signeDP7_id AS signeDP7_id_161, t0.signeDP8_id AS signeDP8_id_162, t0.signeDF_id AS signeDF_id_163, t0.signeDP_id AS signeDP_id_164, t0.signeRR_id AS signeRR_id_165, t0.signeSUP_id AS signeSUP_id_166, t0.signeLead_id AS signeLead_id_167, t0.signeRespAcha_id AS signeRespAcha_id_168, t0.signeRespReg_id AS signeRespReg_id_169, t0.signeChefp_id AS signeChefp_id_170, t0.signeChefp1_id AS signeChefp1_id_171, t0.signeChefp2_id AS signeChefp2_id_172, t0.signeChefp3_id AS signeChefp3_id_173, t0.signeChefp4_id AS signeChefp4_id_174, t0.signeChefp5_id AS signeChefp5_id_175, t0.signeChefp6_id AS signeChefp6_id_176, t0.signeChefp7_id AS signeChefp7_id_177 FROM demAchat t0 WHERE t0.id = 241;

SELECT
  t0.id AS id_1,
  t0.piece_jointe AS piece_jointe_2,
  t0.drapoDRMEDICAL AS drapoDRMEDICAL_3,
  t0.drapoDRMEDICALrefu AS drapoDRMEDICALrefu_4,
  t0.dateDRMEDICAL AS dateDRMEDICAL_5,
  t0.objet AS objet_6,
  t0.delaisPrevu AS delaisPrevu_7,
  t0.dateSoumis AS dateSoumis_8,
  t0.nomProjet AS nomProjet_9,
  t0.raisonRefu AS raisonRefu_10,
  t0.numDemandeAchat AS numDemandeAchat_11,
  t0.numOrdre AS numOrdre_12,
  t0.centreCout AS centreCout_13,
  t0.bailleur AS bailleur_14,
  t0.projet AS projet_15,
  t0.ligneBudget AS ligneBudget_16,
  t0.designation AS designation_17,
  t0.description AS description_18,
  t0.observation AS observation_19,
  t0.prixU AS prixU_20,
  t0.montant AS montant_21,
  t0.quantDemande AS quantDemande_22,
  t0.quantiteValidee AS quantiteValidee_23,
  t0.quantAccorde AS quantAccorde_24,
  t0.numBC AS numBC_25,
  t0.tva AS tva_26,
  t0.drapoValide AS drapoValide_27,
  t0.drapoTraite AS drapoTraite_28,
  t0.drapoStatut AS drapoStatut_29,
  t0.drapoImp AS drapoImp_30,
  t0.drapoSup AS drapoSup_31,
  t0.drapoSuprefu AS drapoSuprefu_32,
  t0.drapoRR AS drapoRR_33,
  t0.drapoRRrefu AS drapoRRrefu_34,
  t0.drapoDP AS drapoDP_35,
  t0.drapoDPrefu AS drapoDPrefu_36,
  t0.drapoDSCSC AS drapoDSCSC_37,
  t0.drapoDSCSCrefu AS drapoDSCSCrefu_38,
  t0.etat AS etat_39,
  t0.drapoRespAcha AS drapoRespAcha_40,
  t0.drapoRespAcharefu AS drapoRespAcharefu_41,
  t0.drapoRespReg AS drapoRespReg_42,
  t0.drapoRespRegrefu AS drapoRespRegrefu_43,
  t0.drapoLead AS drapoLead_44,
  t0.drapoLeadrefu AS drapoLeadrefu_45,
  t0.drapoChefp AS drapoChefp_46,
  t0.drapoChefprefu AS drapoChefprefu_47,
  t0.drapoChefp1 AS drapoChefp1_48,
  t0.drapoChefprefu1 AS drapoChefprefu1_49,
  t0.drapoChefp2 AS drapoChefp2_50,
  t0.drapoChefprefu2 AS drapoChefprefu2_51,
  t0.drapoChefp3 AS drapoChefp3_52,
  t0.drapoChefprefu3 AS drapoChefprefu3_53,
  t0.drapoChefp4 AS drapoChefp4_54,
  t0.drapoChefprefu4 AS drapoChefprefu4_55,
  t0.drapoChefp5 AS drapoChefp5_56,
  t0.drapoChefprefu5 AS drapoChefprefu5_57,
  t0.drapoChefp6 AS drapoChefp6_58,
  t0.drapoChefprefu6 AS drapoChefprefu6_59,
  t0.drapoChefp7 AS drapoChefp7_60,
  t0.drapoChefprefu7 AS drapoChefprefu7_61,
  t0.drapoRejetchef AS drapoRejetchef_62,
  t0.drapoInfo AS drapoInfo_63,
  t0.drapoInforefu AS drapoInforefu_64,
  t0.drapoGarage AS drapoGarage_65,
  t0.drapoGaragerefu AS drapoGaragerefu_66,
  t0.drapoLead1 AS drapoLead1_67,
  t0.drapoLead2 AS drapoLead2_68,
  t0.drapoLead3 AS drapoLead3_69,
  t0.drapoLead4 AS drapoLead4_70,
  t0.drapoLead5 AS drapoLead5_71,
  t0.drapoLeadrefu1 AS drapoLeadrefu1_72,
  t0.drapoLeadrefu2 AS drapoLeadrefu2_73,
  t0.drapoLeadrefu3 AS drapoLeadrefu3_74,
  t0.drapoLeadrefu4 AS drapoLeadrefu4_75,
  t0.drapoLeadrefu5 AS drapoLeadrefu5_76,
  t0.drapoRejetLead AS drapoRejetLead_77,
  t0.drapoPriCharge AS drapoPriCharge_78,
  t0.drapoDP1 AS drapoDP1_79,
  t0.drapoDP2 AS drapoDP2_80,
  t0.drapoDP3 AS drapoDP3_81,
  t0.drapoDP4 AS drapoDP4_82,
  t0.drapoDP5 AS drapoDP5_83,
  t0.drapoDP6 AS drapoDP6_84,
  t0.drapoDP7 AS drapoDP7_85,
  t0.drapoDP8 AS drapoDP8_86,
  t0.drapoDPrefu1 AS drapoDPrefu1_87,
  t0.drapoDPrefu2 AS drapoDPrefu2_88,
  t0.drapoDPrefu3 AS drapoDPrefu3_89,
  t0.drapoDPrefu4 AS drapoDPrefu4_90,
  t0.drapoDPrefu5 AS drapoDPrefu5_91,
  t0.drapoDPrefu6 AS drapoDPrefu6_92,
  t0.drapoDPrefu7 AS drapoDPrefu7_93,
  t0.drapoDPrefu8 AS drapoDPrefu8_94,
  t0.dateDP1 AS dateDP1_95,
  t0.dateDP2 AS dateDP2_96,
  t0.dateDP3 AS dateDP3_97,
  t0.dateDP4 AS dateDP4_98,
  t0.dateDP5 AS dateDP5_99,
  t0.dateDP6 AS dateDP6_100,
  t0.dateDP7 AS dateDP7_101,
  t0.dateDP8 AS dateDP8_102,
  t0.dateLead1 AS dateLead1_103,
  t0.dateLead2 AS dateLead2_104,
  t0.dateLead3 AS dateLead3_105,
  t0.dateLead4 AS dateLead4_106,
  t0.dateLead5 AS dateLead5_107,
  t0.dateInfo AS dateInfo_108,
  t0.dateGarage AS dateGarage_109,
  t0.dateDSCSC AS dateDSCSC_110,
  t0.dateRespAcha AS dateRespAcha_111,
  t0.dateRespReg AS dateRespReg_112,
  t0.dateSuph AS dateSuph_113,
  t0.dateDP AS dateDP_114,
  t0.dateRR AS dateRR_115,
  t0.dateLead AS dateLead_116,
  t0.dateChefp AS dateChefp_117,
  t0.dateChefp1 AS dateChefp1_118,
  t0.dateChefp2 AS dateChefp2_119,
  t0.dateChefp3 AS dateChefp3_120,
  t0.dateChefp4 AS dateChefp4_121,
  t0.dateChefp5 AS dateChefp5_122,
  t0.dateChefp6 AS dateChefp6_123,
  t0.dateChefp7 AS dateChefp7_124,
  t0.delais AS delais_125,
  t0.region AS region_126,
  t0.quantDemand AS quantDemand_127,
  t0.quantAccord AS quantAccord_128,
  t0.contratCadrePropose AS contratCadrePropose_129,
  t0.contratCadreValide AS contratCadreValide_130,
  t0.motifRefusContrat AS motifRefusContrat_131,
  t0.reserve_contrat_cadre AS reserve_contrat_cadre_132,
  t0.statut_contrat_cadre AS statut_contrat_cadre_133,
  t0.drapo_cc AS drapo_cc_134,
  t0.drapo_sans_cc AS drapo_sans_cc_135,
  t0.drapo_cloture AS drapo_cloture_136,
  t0.reste_acommander AS reste_acommander_137,
  t0.signe_drmedical_id AS signe_drmedical_id_138,
  t0.contrat_cadre_id AS contrat_cadre_id_139,
  t0.commandeAchat_id AS commandeAchat_id_140,
  t0.demPaiement_id AS demPaiement_id_141,
  t0.user_id AS user_id_142,
  t0.signeChef_id AS signeChef_id_143,
  t0.catalogue_id AS catalogue_id_144,
  t0.costcenter_id AS costcenter_id_145,
  t0.nombaille_id AS nombaille_id_146,
  t0.image_id AS image_id_147,
  t0.signeInfo_id AS signeInfo_id_148,
  t0.signeGarage_id AS signeGarage_id_149,
  t0.signeLead1_id AS signeLead1_id_150,
  t0.signeLead2_id AS signeLead2_id_151,
  t0.signeLead3_id AS signeLead3_id_152,
  t0.signeLead4_id AS signeLead4_id_153,
  t0.signeLead5_id AS signeLead5_id_154,
  t0.signeDP1_id AS signeDP1_id_155,
  t0.signeDP2_id AS signeDP2_id_156,
  t0.signeDP3_id AS signeDP3_id_157,
  t0.signeDP4_id AS signeDP4_id_158,
  t0.signeDP5_id AS signeDP5_id_159,
  t0.signeDP6_id AS signeDP6_id_160,
  t0.signeDP7_id AS signeDP7_id_161,
  t0.signeDP8_id AS signeDP8_id_162,
  t0.signeDF_id AS signeDF_id_163,
  t0.signeDP_id AS signeDP_id_164,
  t0.signeRR_id AS signeRR_id_165,
  t0.signeSUP_id AS signeSUP_id_166,
  t0.signeLead_id AS signeLead_id_167,
  t0.signeRespAcha_id AS signeRespAcha_id_168,
  t0.signeRespReg_id AS signeRespReg_id_169,
  t0.signeChefp_id AS signeChefp_id_170,
  t0.signeChefp1_id AS signeChefp1_id_171,
  t0.signeChefp2_id AS signeChefp2_id_172,
  t0.signeChefp3_id AS signeChefp3_id_173,
  t0.signeChefp4_id AS signeChefp4_id_174,
  t0.signeChefp5_id AS signeChefp5_id_175,
  t0.signeChefp6_id AS signeChefp6_id_176,
  t0.signeChefp7_id AS signeChefp7_id_177
FROM
  demAchat t0
WHERE
  t0.numDemandeAchat = ?
  AND t0.drapoRejetchef = ?

SELECT t0.id AS id_1, t0.piece_jointe AS piece_jointe_2, t0.drapoDRMEDICAL AS drapoDRMEDICAL_3, t0.drapoDRMEDICALrefu AS drapoDRMEDICALrefu_4, t0.dateDRMEDICAL AS dateDRMEDICAL_5, t0.objet AS objet_6, t0.delaisPrevu AS delaisPrevu_7, t0.dateSoumis AS dateSoumis_8, t0.nomProjet AS nomProjet_9, t0.raisonRefu AS raisonRefu_10, t0.numDemandeAchat AS numDemandeAchat_11, t0.numOrdre AS numOrdre_12, t0.centreCout AS centreCout_13, t0.bailleur AS bailleur_14, t0.projet AS projet_15, t0.ligneBudget AS ligneBudget_16, t0.designation AS designation_17, t0.description AS description_18, t0.observation AS observation_19, t0.prixU AS prixU_20, t0.montant AS montant_21, t0.quantDemande AS quantDemande_22, t0.quantiteValidee AS quantiteValidee_23, t0.quantAccorde AS quantAccorde_24, t0.numBC AS numBC_25, t0.tva AS tva_26, t0.drapoValide AS drapoValide_27, t0.drapoTraite AS drapoTraite_28, t0.drapoStatut AS drapoStatut_29, t0.drapoImp AS drapoImp_30, t0.drapoSup AS drapoSup_31, t0.drapoSuprefu AS drapoSuprefu_32, t0.drapoRR AS drapoRR_33, t0.drapoRRrefu AS drapoRRrefu_34, t0.drapoDP AS drapoDP_35, t0.drapoDPrefu AS drapoDPrefu_36, t0.drapoDSCSC AS drapoDSCSC_37, t0.drapoDSCSCrefu AS drapoDSCSCrefu_38, t0.etat AS etat_39, t0.drapoRespAcha AS drapoRespAcha_40, t0.drapoRespAcharefu AS drapoRespAcharefu_41, t0.drapoRespReg AS drapoRespReg_42, t0.drapoRespRegrefu AS drapoRespRegrefu_43, t0.drapoLead AS drapoLead_44, t0.drapoLeadrefu AS drapoLeadrefu_45, t0.drapoChefp AS drapoChefp_46, t0.drapoChefprefu AS drapoChefprefu_47, t0.drapoChefp1 AS drapoChefp1_48, t0.drapoChefprefu1 AS drapoChefprefu1_49, t0.drapoChefp2 AS drapoChefp2_50, t0.drapoChefprefu2 AS drapoChefprefu2_51, t0.drapoChefp3 AS drapoChefp3_52, t0.drapoChefprefu3 AS drapoChefprefu3_53, t0.drapoChefp4 AS drapoChefp4_54, t0.drapoChefprefu4 AS drapoChefprefu4_55, t0.drapoChefp5 AS drapoChefp5_56, t0.drapoChefprefu5 AS drapoChefprefu5_57, t0.drapoChefp6 AS drapoChefp6_58, t0.drapoChefprefu6 AS drapoChefprefu6_59, t0.drapoChefp7 AS drapoChefp7_60, t0.drapoChefprefu7 AS drapoChefprefu7_61, t0.drapoRejetchef AS drapoRejetchef_62, t0.drapoInfo AS drapoInfo_63, t0.drapoInforefu AS drapoInforefu_64, t0.drapoGarage AS drapoGarage_65, t0.drapoGaragerefu AS drapoGaragerefu_66, t0.drapoLead1 AS drapoLead1_67, t0.drapoLead2 AS drapoLead2_68, t0.drapoLead3 AS drapoLead3_69, t0.drapoLead4 AS drapoLead4_70, t0.drapoLead5 AS drapoLead5_71, t0.drapoLeadrefu1 AS drapoLeadrefu1_72, t0.drapoLeadrefu2 AS drapoLeadrefu2_73, t0.drapoLeadrefu3 AS drapoLeadrefu3_74, t0.drapoLeadrefu4 AS drapoLeadrefu4_75, t0.drapoLeadrefu5 AS drapoLeadrefu5_76, t0.drapoRejetLead AS drapoRejetLead_77, t0.drapoPriCharge AS drapoPriCharge_78, t0.drapoDP1 AS drapoDP1_79, t0.drapoDP2 AS drapoDP2_80, t0.drapoDP3 AS drapoDP3_81, t0.drapoDP4 AS drapoDP4_82, t0.drapoDP5 AS drapoDP5_83, t0.drapoDP6 AS drapoDP6_84, t0.drapoDP7 AS drapoDP7_85, t0.drapoDP8 AS drapoDP8_86, t0.drapoDPrefu1 AS drapoDPrefu1_87, t0.drapoDPrefu2 AS drapoDPrefu2_88, t0.drapoDPrefu3 AS drapoDPrefu3_89, t0.drapoDPrefu4 AS drapoDPrefu4_90, t0.drapoDPrefu5 AS drapoDPrefu5_91, t0.drapoDPrefu6 AS drapoDPrefu6_92, t0.drapoDPrefu7 AS drapoDPrefu7_93, t0.drapoDPrefu8 AS drapoDPrefu8_94, t0.dateDP1 AS dateDP1_95, t0.dateDP2 AS dateDP2_96, t0.dateDP3 AS dateDP3_97, t0.dateDP4 AS dateDP4_98, t0.dateDP5 AS dateDP5_99, t0.dateDP6 AS dateDP6_100, t0.dateDP7 AS dateDP7_101, t0.dateDP8 AS dateDP8_102, t0.dateLead1 AS dateLead1_103, t0.dateLead2 AS dateLead2_104, t0.dateLead3 AS dateLead3_105, t0.dateLead4 AS dateLead4_106, t0.dateLead5 AS dateLead5_107, t0.dateInfo AS dateInfo_108, t0.dateGarage AS dateGarage_109, t0.dateDSCSC AS dateDSCSC_110, t0.dateRespAcha AS dateRespAcha_111, t0.dateRespReg AS dateRespReg_112, t0.dateSuph AS dateSuph_113, t0.dateDP AS dateDP_114, t0.dateRR AS dateRR_115, t0.dateLead AS dateLead_116, t0.dateChefp AS dateChefp_117, t0.dateChefp1 AS dateChefp1_118, t0.dateChefp2 AS dateChefp2_119, t0.dateChefp3 AS dateChefp3_120, t0.dateChefp4 AS dateChefp4_121, t0.dateChefp5 AS dateChefp5_122, t0.dateChefp6 AS dateChefp6_123, t0.dateChefp7 AS dateChefp7_124, t0.delais AS delais_125, t0.region AS region_126, t0.quantDemand AS quantDemand_127, t0.quantAccord AS quantAccord_128, t0.contratCadrePropose AS contratCadrePropose_129, t0.contratCadreValide AS contratCadreValide_130, t0.motifRefusContrat AS motifRefusContrat_131, t0.reserve_contrat_cadre AS reserve_contrat_cadre_132, t0.statut_contrat_cadre AS statut_contrat_cadre_133, t0.drapo_cc AS drapo_cc_134, t0.drapo_sans_cc AS drapo_sans_cc_135, t0.drapo_cloture AS drapo_cloture_136, t0.reste_acommander AS reste_acommander_137, t0.signe_drmedical_id AS signe_drmedical_id_138, t0.contrat_cadre_id AS contrat_cadre_id_139, t0.commandeAchat_id AS commandeAchat_id_140, t0.demPaiement_id AS demPaiement_id_141, t0.user_id AS user_id_142, t0.signeChef_id AS signeChef_id_143, t0.catalogue_id AS catalogue_id_144, t0.costcenter_id AS costcenter_id_145, t0.nombaille_id AS nombaille_id_146, t0.image_id AS image_id_147, t0.signeInfo_id AS signeInfo_id_148, t0.signeGarage_id AS signeGarage_id_149, t0.signeLead1_id AS signeLead1_id_150, t0.signeLead2_id AS signeLead2_id_151, t0.signeLead3_id AS signeLead3_id_152, t0.signeLead4_id AS signeLead4_id_153, t0.signeLead5_id AS signeLead5_id_154, t0.signeDP1_id AS signeDP1_id_155, t0.signeDP2_id AS signeDP2_id_156, t0.signeDP3_id AS signeDP3_id_157, t0.signeDP4_id AS signeDP4_id_158, t0.signeDP5_id AS signeDP5_id_159, t0.signeDP6_id AS signeDP6_id_160, t0.signeDP7_id AS signeDP7_id_161, t0.signeDP8_id AS signeDP8_id_162, t0.signeDF_id AS signeDF_id_163, t0.signeDP_id AS signeDP_id_164, t0.signeRR_id AS signeRR_id_165, t0.signeSUP_id AS signeSUP_id_166, t0.signeLead_id AS signeLead_id_167, t0.signeRespAcha_id AS signeRespAcha_id_168, t0.signeRespReg_id AS signeRespReg_id_169, t0.signeChefp_id AS signeChefp_id_170, t0.signeChefp1_id AS signeChefp1_id_171, t0.signeChefp2_id AS signeChefp2_id_172, t0.signeChefp3_id AS signeChefp3_id_173, t0.signeChefp4_id AS signeChefp4_id_174, t0.signeChefp5_id AS signeChefp5_id_175, t0.signeChefp6_id AS signeChefp6_id_176, t0.signeChefp7_id AS signeChefp7_id_177 FROM demAchat t0 WHERE t0.numDemandeAchat = 1 AND t0.drapoRejetchef = 0;