https://teste-symfony5.intranet-mariestopesbf.org/gestionDemandeAchat

Method
GET
HTTP Status
200
IP
197.239.115.31
Profiled on
Token
cd60eb

Query Metrics

49 Database Queries
20 Different statements
65.53 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.98 ms 
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 = ?
Parameters: 
[
  9
]
View formatted query    View runnable query    Explain query
2 4.61 ms 
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
Parameters: 
[
  0
  0
  0
  "CSO"
  0
  "CSO"
  0
  "CSO"
  0
  "roger.coul@yahoo.fr"
  "CSO"
]
View formatted query    View runnable query    Explain query
3 3.13 ms 
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_.montant > 2499999 GROUP BY d0_.numDemandeAchat ORDER BY d0_.numDemandeAchat DESC
Parameters: 
[]
View formatted query    View runnable query    Explain query
4 0.77 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.user_id AS user_id_3, t0.centrecout_id AS centrecout_id_4, t0.userreg_id AS userreg_id_5, t0.uselead_id AS uselead_id_6 FROM UserCentre t0 WHERE t0.user_id = ?
Parameters: 
[
  9
]
View formatted query    View runnable query    Explain query
5 0.60 ms 
SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.bailleur_id AS bailleur_id_3 FROM UseBailleur t0 WHERE t0.user_id = ?
Parameters: 
[
  9
]
View formatted query    View runnable query    Explain query
6 0.62 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.user_id AS user_id_3, t0.centrecout_id AS centrecout_id_4, t0.userreg_id AS userreg_id_5, t0.uselead_id AS uselead_id_6 FROM UserCentre t0 WHERE t0.uselead_id = ?
Parameters: 
[
  9
]
View formatted query    View runnable query    Explain query
7 3.52 ms 
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
Parameters: 
[
  0
]
View formatted query    View runnable query    Explain query
8 3.65 ms 
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 > ? AND d0_.drapoRR = 1) OR (d0_.id > ? AND d0_.drapoDSCSC = 1 AND d0_.montant > 2499999 AND d0_.montant < 5000000) OR (d0_.id > ? AND d0_.drapoDSCSC = 1 AND d0_.montant < 2500000) GROUP BY d0_.numDemandeAchat ORDER BY d0_.numDemandeAchat DESC
Parameters: 
[
  0
  0
  0
]
View formatted query    View runnable query    Explain query
9 3.89 ms 
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 > ? AND ((d0_.drapoLeadrefu = 1) OR (d0_.drapoDSCSCrefu = 1) OR (d0_.drapoDPrefu = 1) OR (d0_.drapoRRrefu = 1) OR (d0_.drapoChefprefu1 = 1) OR (d0_.drapoChefprefu2 = 1) OR (d0_.drapoChefprefu3 = 1) OR (d0_.drapoChefprefu4 = 1) OR (d0_.drapoChefprefu5 = 1) OR (d0_.drapoChefprefu6 = 1) OR (d0_.drapoChefprefu7 = 1) OR (d0_.drapoRespRegrefu = 1) OR (d0_.drapoSuprefu = 1) OR (d0_.drapoRespAcharefu = 1) OR (d0_.drapoDPrefu1 = 1) OR (d0_.drapoDPrefu2 = 1) OR (d0_.drapoDPrefu3 = 1) OR (d0_.drapoDPrefu4 = 1) OR (d0_.drapoDPrefu5 = 1) OR (d0_.drapoDPrefu6 = 1) OR (d0_.drapoDPrefu7 = 1) OR (d0_.drapoDPrefu8 = 1) OR (d0_.drapoDRMEDICALrefu = 1)) GROUP BY d0_.numDemandeAchat ORDER BY d0_.numDemandeAchat DESC
Parameters: 
[
  0
]
View formatted query    View runnable query    Explain query
10 5.61 ms 
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 > ? AND ((d0_.signeLead_id = ? AND d0_.drapoLead = 1) OR (d0_.signeDF_id = ? AND d0_.drapoDSCSC = 1) OR (d0_.signeDP_id = ? AND d0_.drapoDP = 1) OR (d0_.signeRR_id = ? AND d0_.drapoRR = 1) OR (d0_.signeChefp1_id = ? AND d0_.drapoChefp1 = 1) OR (d0_.signeChefp2_id = ? AND d0_.drapoChefp2 = 1) OR (d0_.signeChefp3_id = ? AND d0_.drapoChefp3 = 1) OR (d0_.signeChefp4_id = ? AND d0_.drapoChefp4 = 1) OR (d0_.signeChefp5_id = ? AND d0_.drapoChefp5 = 1) OR (d0_.signeChefp6_id = ? AND d0_.drapoChefp6 = 1) OR (d0_.signeChefp7_id = ? AND d0_.drapoChefp7 = 1) OR (d0_.signeRespReg_id = ? AND d0_.drapoRespReg = 1) OR (d0_.signeSUP_id = ? AND d0_.drapoSup = 1) OR (d0_.signeRespAcha_id = ? AND d0_.drapoRespAcha = 1) OR (d0_.signeInfo_id = ? AND d0_.drapoInfo = 1) OR (d0_.signeGarage_id = ? AND d0_.drapoGarage = 1) OR (d0_.signeLead1_id = ? AND d0_.drapoLead1 = 1) OR (d0_.signeLead2_id = ? AND d0_.drapoLead2 = 1) OR (d0_.signeLead3_id = ? AND d0_.drapoLead3 = 1) OR (d0_.signeDP1_id = ? AND d0_.drapoDP1 = 1) OR (d0_.signeDP2_id = ? AND d0_.drapoDP2 = 1) OR (d0_.signeDP3_id = ? AND d0_.drapoDP3 = 1) OR (d0_.signeDP4_id = ? AND d0_.drapoDP4 = 1) OR (d0_.signeDP5_id = ? AND d0_.drapoDP5 = 1) OR (d0_.signeDP6_id = ? AND d0_.drapoDP6 = 1) OR (d0_.signeDP7_id = ? AND d0_.drapoDP7 = 1) OR (d0_.signeDP8_id = ? AND d0_.drapoDP8 = 1) OR (d0_.signe_drmedical_id = ? AND d0_.drapoDRMEDICAL = 1)) GROUP BY d0_.numDemandeAchat ORDER BY d0_.numDemandeAchat DESC
Parameters: 
[
  0
  9
  9
  9
  9
  9
  9
  9
  9
  9
  9
  9
  9
  9
  9
  9
  9
  9
  9
  9
  9
  9
  9
  9
  9
  9
  9
  9
  9
]
View formatted query    View runnable query    Explain query
11 4.53 ms 
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 > ? AND ((d0_.signeLead_id = ? AND d0_.drapoLeadrefu = 1) OR (d0_.signeDF_id = ? AND d0_.drapoDSCSCrefu = 1) OR (d0_.signeDP_id = ? AND d0_.drapoDPrefu = 1) OR (d0_.signeRR_id = ? AND d0_.drapoRRrefu = 1) OR (d0_.signeChefp1_id = ? AND d0_.drapoChefprefu1 = 1) OR (d0_.signeChefp2_id = ? AND d0_.drapoChefprefu2 = 1) OR (d0_.signeChefp3_id = ? AND d0_.drapoChefprefu3 = 1) OR (d0_.signeChefp4_id = ? AND d0_.drapoChefprefu4 = 1) OR (d0_.signeChefp5_id = ? AND d0_.drapoChefprefu5 = 1) OR (d0_.signeChefp6_id = ? AND d0_.drapoChefprefu6 = 1) OR (d0_.signeChefp7_id = ? AND d0_.drapoChefprefu7 = 1) OR (d0_.signeRespReg_id = ? AND d0_.drapoRespRegrefu = 1) OR (d0_.signeSUP_id = ? AND d0_.drapoSuprefu = 1) OR (d0_.signeRespAcha_id = ? AND d0_.drapoRespAcharefu = 1) OR (d0_.signeDP1_id = ? AND d0_.drapoDPrefu1 = 1) OR (d0_.signeDP2_id = ? AND d0_.drapoDPrefu2 = 1) OR (d0_.signeDP3_id = ? AND d0_.drapoDPrefu3 = 1) OR (d0_.signeDP4_id = ? AND d0_.drapoDPrefu4 = 1) OR (d0_.signeDP5_id = ? AND d0_.drapoDPrefu5 = 1) OR (d0_.signeDP6_id = ? AND d0_.drapoDPrefu6 = 1) OR (d0_.signeDP7_id = ? AND d0_.drapoDPrefu7 = 1) OR (d0_.signeDP8_id = ? AND d0_.drapoDPrefu8 = 1) OR (d0_.signe_drmedical_id = ? AND d0_.drapoDRMEDICALrefu = 1)) GROUP BY d0_.numDemandeAchat ORDER BY d0_.numDemandeAchat DESC
Parameters: 
[
  0
  9
  9
  9
  9
  9
  9
  9
  9
  9
  9
  9
  9
  9
  9
  9
  9
  9
  9
  9
  9
  9
  9
  9
]
View formatted query    View runnable query    Explain query
12 3.81 ms 
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 > ? AND ((d0_.drapoPriCharge = 0 AND d0_.drapoTraite = 0 AND d0_.drapoDSCSC = 1 AND d0_.montant < 5000000) OR (d0_.drapoPriCharge = 0 AND d0_.drapoTraite = 0 AND d0_.drapoRR = 1) OR (d0_.costcenter_id IS NULL AND d0_.drapoChefp6 = 1)) GROUP BY d0_.numDemandeAchat ORDER BY d0_.numDemandeAchat DESC
Parameters: 
[
  0
]
View formatted query    View runnable query    Explain query
13 3.24 ms 
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 > ? AND d0_.drapoTraite = 1) OR d0_.drapoPriCharge = 1 GROUP BY d0_.numDemandeAchat ORDER BY d0_.numDemandeAchat DESC
Parameters: 
[
  0
]
View formatted query    View runnable query    Explain query
14 4.30 ms 
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 > ? AND d0_.user_id = ? GROUP BY d0_.numDemandeAchat ORDER BY d0_.numDemandeAchat DESC
Parameters: 
[
  0
  9
]
View formatted query    View runnable query    Explain query
15 2.07 ms 
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 ORDER BY t0.nom ASC, t0.prenom ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
16 0.71 ms 
SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.bailleur_id AS bailleur_id_3 FROM UseBailleur t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
17 0.53 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.drapoCloture AS drapoCloture_3 FROM Bailleur t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
18 0.55 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.drapoCloture AS drapoCloture_3 FROM Bailleur t0 WHERE t0.id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
19 0.53 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.drapoCloture AS drapoCloture_3 FROM Bailleur t0 WHERE t0.id = ?
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query
20 0.51 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.drapoCloture AS drapoCloture_3 FROM Bailleur t0 WHERE t0.id = ?
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query
21 0.58 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.drapoCloture AS drapoCloture_3 FROM Bailleur t0 WHERE t0.id = ?
Parameters: 
[
  5
]
View formatted query    View runnable query    Explain query
22 0.57 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.drapoCloture AS drapoCloture_3 FROM Bailleur t0 WHERE t0.id = ?
Parameters: 
[
  6
]
View formatted query    View runnable query    Explain query
23 0.47 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.drapoCloture AS drapoCloture_3 FROM Bailleur t0 WHERE t0.id = ?
Parameters: 
[
  7
]
View formatted query    View runnable query    Explain query
24 0.49 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.drapoCloture AS drapoCloture_3 FROM Bailleur t0 WHERE t0.id = ?
Parameters: 
[
  8
]
View formatted query    View runnable query    Explain query
25 0.41 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.drapoCloture AS drapoCloture_3 FROM Bailleur t0 WHERE t0.id = ?
Parameters: 
[
  9
]
View formatted query    View runnable query    Explain query
26 0.51 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.drapoCloture AS drapoCloture_3 FROM Bailleur t0 WHERE t0.id = ?
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query
27 0.51 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.drapoCloture AS drapoCloture_3 FROM Bailleur t0 WHERE t0.id = ?
Parameters: 
[
  11
]
View formatted query    View runnable query    Explain query
28 0.62 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.drapoCloture AS drapoCloture_3 FROM Bailleur t0 WHERE t0.id = ?
Parameters: 
[
  12
]
View formatted query    View runnable query    Explain query
29 0.48 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.drapoCloture AS drapoCloture_3 FROM Bailleur t0 WHERE t0.id = ?
Parameters: 
[
  13
]
View formatted query    View runnable query    Explain query
30 0.49 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.drapoCloture AS drapoCloture_3 FROM Bailleur t0 WHERE t0.id = ?
Parameters: 
[
  14
]
View formatted query    View runnable query    Explain query
31 0.45 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.drapoCloture AS drapoCloture_3 FROM Bailleur t0 WHERE t0.id = ?
Parameters: 
[
  16
]
View formatted query    View runnable query    Explain query
32 0.46 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.drapoCloture AS drapoCloture_3 FROM Bailleur t0 WHERE t0.id = ?
Parameters: 
[
  17
]
View formatted query    View runnable query    Explain query
33 0.51 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.drapoCloture AS drapoCloture_3 FROM Bailleur t0 WHERE t0.id = ?
Parameters: 
[
  18
]
View formatted query    View runnable query    Explain query
34 0.48 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.drapoCloture AS drapoCloture_3 FROM Bailleur t0 WHERE t0.id = ?
Parameters: 
[
  19
]
View formatted query    View runnable query    Explain query
35 0.54 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.drapoCloture AS drapoCloture_3 FROM Bailleur t0 WHERE t0.id = ?
Parameters: 
[
  21
]
View formatted query    View runnable query    Explain query
36 0.45 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.drapoCloture AS drapoCloture_3 FROM Bailleur t0 WHERE t0.id = ?
Parameters: 
[
  22
]
View formatted query    View runnable query    Explain query
37 0.44 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.drapoCloture AS drapoCloture_3 FROM Bailleur t0 WHERE t0.id = ?
Parameters: 
[
  23
]
View formatted query    View runnable query    Explain query
38 0.59 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.drapoCloture AS drapoCloture_3 FROM Bailleur t0 WHERE t0.id = ?
Parameters: 
[
  24
]
View formatted query    View runnable query    Explain query
39 0.58 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.drapoCloture AS drapoCloture_3 FROM Bailleur t0 WHERE t0.id = ?
Parameters: 
[
  25
]
View formatted query    View runnable query    Explain query
40 0.49 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.drapoCloture AS drapoCloture_3 FROM Bailleur t0 WHERE t0.id = ?
Parameters: 
[
  26
]
View formatted query    View runnable query    Explain query
41 0.57 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.drapoCloture AS drapoCloture_3 FROM Bailleur t0 WHERE t0.id = ?
Parameters: 
[
  27
]
View formatted query    View runnable query    Explain query
42 0.48 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.drapoCloture AS drapoCloture_3 FROM Bailleur t0 WHERE t0.id = ?
Parameters: 
[
  28
]
View formatted query    View runnable query    Explain query
43 0.62 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.drapoCloture AS drapoCloture_3 FROM Bailleur t0 WHERE t0.id = ?
Parameters: 
[
  29
]
View formatted query    View runnable query    Explain query
44 0.56 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.drapoCloture AS drapoCloture_3 FROM Bailleur t0 WHERE t0.id = ?
Parameters: 
[
  30
]
View formatted query    View runnable query    Explain query
45 0.57 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.drapoCloture AS drapoCloture_3 FROM Bailleur t0 WHERE t0.id = ?
Parameters: 
[
  31
]
View formatted query    View runnable query    Explain query
46 0.47 ms 
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.drapoCloture AS drapoCloture_3 FROM Bailleur t0 WHERE t0.id = ?
Parameters: 
[
  32
]
View formatted query    View runnable query    Explain query
47 2.23 ms 
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 = ?
Parameters: 
[
  8745
]
View formatted query    View runnable query    Explain query
48 0.60 ms 
SELECT b0_.id AS id_0, b0_.libele AS libele_1, b0_.drapoCloture AS drapoCloture_2 FROM Bailleur b0_
Parameters: 
[]
View formatted query    View runnable query    Explain query
49 1.15 ms 
SELECT c0_.id AS id_0, c0_.libele AS libele_1, c0_.code AS code_2 FROM CentreCout c0_
Parameters: 
[]
View formatted query    View runnable query    Explain query

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\SupH No errors.
App\Entity\ImageS No errors.
App\Entity\ReviewTec No errors.
App\Entity\Approb No errors.
App\Entity\demAchat No errors.
App\Entity\CentreCout No errors.
App\Entity\ContratCadre No errors.
App\Entity\CommandeAchat No errors.
App\Entity\demPaiement No errors.
App\Entity\Catalogue No errors.
App\Entity\Bailleur No errors.
App\Entity\Image No errors.
App\Entity\UserCentre No errors.
App\Entity\UseBailleur No errors.