Symfony Profiler

Query Metrics

20 Database Queries

17 Different statements

91.89 ms Query time

0 Invalid entities

161 Managed entities

0 Cache hits

0 Cache misses

0 Cache puts

Queries

Group similar statements

default connection


SELECT t0.id AS id_1, t0.email AS email_2, t0.enabled AS enabled_3, t0.salt AS salt_4, t0.password AS password_5, t0.last_login AS last_login_6, t0.confirmation_token AS confirmation_token_7, t0.password_requested_at AS password_requested_at_8, t0.roles AS roles_9, t0.username AS username_10, t0.nom AS nom_11, t0.prenom AS prenom_12, t0.fonction AS fonction_13, t0.tel AS tel_14, t0.mobile AS mobile_15, t0.activation AS activation_16, t0.createdAt AS createdAt_17, t0.updatedAt AS updatedAt_18, t0.optin AS optin_19, t0.dateActivation AS dateActivation_20, t0.emailValidatedDateTime AS emailValidatedDateTime_21, t0.emailCreatedDateTime AS emailCreatedDateTime_22, t0.mobileCreatedDatetime AS mobileCreatedDatetime_23, t0.sendEmail AS sendEmail_24, t0.scope AS scope_25, t0.isArchived AS isArchived_26, t0.import AS import_27, t0.neoSpaceEnabled AS neoSpaceEnabled_28, t0.email_canonical AS email_canonical_29, t0.username_canonical AS username_canonical_30, t0.oblige_id AS oblige_id_31 FROM ObligeUser t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.type AS type_2, t0.pricingType AS pricingType_3, t0.finalisationRequested AS finalisationRequested_4, t0.finalisationRequestDate AS finalisationRequestDate_5, t0.cofracSatisfyDate AS cofracSatisfyDate_6, t0.reference AS reference_7, t0.data AS data_8, t0.cofracData AS cofracData_9, t0.cofracEngineDocumentId AS cofracEngineDocumentId_10, t0.ip AS ip_11, t0.offre_auto_date AS offre_auto_date_12, t0.created_datetime AS created_datetime_13, t0.updated_datetime AS updated_datetime_14, t0.tel AS tel_15, t0.codepostal AS codepostal_16, t0.adresse AS adresse_17, t0.adresse_complement AS adresse_complement_18, t0.ville AS ville_19, t0.delai_souhaite AS delai_souhaite_20, t0.accept_recevoir_offre AS accept_recevoir_offre_21, t0.accept_recommandation AS accept_recommandation_22, t0.acceptLeadPromo AS acceptLeadPromo_23, t0.offre_cumac AS offre_cumac_24, t0.offre_cumac_client AS offre_cumac_client_25, t0.offre_cumac_precarite AS offre_cumac_precarite_26, t0.offre_cumac_client_precarite AS offre_cumac_client_precarite_27, t0.cumac AS cumac_28, t0.cumac_AFT AS cumac_AFT_29, t0.total_prime AS total_prime_30, t0.total_prime_AFT AS total_prime_AFT_31, t0.prime_pro AS prime_pro_32, t0.prime_pro_aft AS prime_pro_aft_33, t0.prime_client AS prime_client_34, t0.prime_client_aft AS prime_client_aft_35, t0.cumac_moyenne AS cumac_moyenne_36, t0.taux_actualise AS taux_actualise_37, t0.taux_accumule AS taux_accumule_38, t0.date_debut_chantier AS date_debut_chantier_39, t0.date_demande_offre AS date_demande_offre_40, t0.date_fin_chantier AS date_fin_chantier_41, t0.etat AS etat_42, t0.status AS status_43, t0.date_offre AS date_offre_44, t0.notification_date_chantier AS notification_date_chantier_45, t0.date_retour_conv AS date_retour_conv_46, t0.date_validation_conv AS date_validation_conv_47, t0.date_chantier_renseigne AS date_chantier_renseigne_48, t0.date_paiement AS date_paiement_49, t0.date_all_doc_valid AS date_all_doc_valid_50, t0.date_fin_chantier_repousse AS date_fin_chantier_repousse_51, t0.date_envoi_questionnaire AS date_envoi_questionnaire_52, t0.date_edition_questionnaire AS date_edition_questionnaire_53, t0.date_validation_final AS date_validation_final_54, t0.date_annulation AS date_annulation_55, t0.no_click_email_date_chantier AS no_click_email_date_chantier_56, t0.token AS token_57, t0.auto_installation AS auto_installation_58, t0.siret AS siret_59, t0.cancelReason AS cancelReason_60, t0.dateCommande AS dateCommande_61, t0.siteTravaux AS siteTravaux_62, t0.incitation AS incitation_63, t0.qualificationRecordDate AS qualificationRecordDate_64, t0.serviceType AS serviceType_65, t0.debutChantier AS debutChantier_66, t0.finChantier AS finChantier_67, t0.initiateCDP AS initiateCDP_68, t0.cdp AS cdp_69, t0.date_last_envoi_convention AS date_last_envoi_convention_70, t0.programStep AS programStep_71, t0.devisRestAPayer AS devisRestAPayer_72, t0.pricingMandatClassique AS pricingMandatClassique_73, t0.pricingMandatPreca AS pricingMandatPreca_74, t0.isCOFRAC AS isCOFRAC_75, t0.applicationFeesPrice AS applicationFeesPrice_76, t0.attributes AS attributes_77, t0.exclusive AS exclusive_78, t0.engineDocumentId AS engineDocumentId_79, t0.adresseTravaux AS adresseTravaux_80, t0.adresseTravauxCommentaire AS adresseTravauxCommentaire_81, t0.batchOffreProjet_id AS batchOffreProjet_id_82, t0.entrepriseUser_id AS entrepriseUser_id_83, t0.installateurUser_id AS installateurUser_id_84, t0.beUser_id AS beUser_id_85, t0.entrepriseUserContact_id AS entrepriseUserContact_id_86, t0.particulierUserContact_id AS particulierUserContact_id_87, t0.signataireEntreprise_id AS signataireEntreprise_id_88, t0.signataireInstallateur_id AS signataireInstallateur_id_89, t0.installateurUserContact_id AS installateurUserContact_id_90, t0.projet_id AS projet_id_91, t0.precariteCas2_id AS precariteCas2_id_92, t0.creditNoteContract_id AS creditNoteContract_id_93, t0.precarite_id AS precarite_id_94, t0.state_id AS state_id_95, t96.id AS id_97, t96.created_datetime AS created_datetime_98, t96.convention AS convention_99, t96.aft AS aft_100, t96.facture AS facture_101, t96.beneficiaire AS beneficiaire_102, t96.installateur AS installateur_103, t96.doc_obligatoire AS doc_obligatoire_104, t96.coherence_dossier AS coherence_dossier_105, t96.offre_id AS offre_id_106, t0.oblige_id AS oblige_id_107, t0.secteurActivite_id AS secteurActivite_id_108, t0.factureDetail_id AS factureDetail_id_109, t110.id AS id_111, t110.reference AS reference_112, t110.type AS type_113, t110.result AS result_114, t110.errors AS errors_115, t110.message AS message_116, t110.created_datetime AS created_datetime_117, t110.integrationModule_id AS integrationModule_id_118, t110.offre_id AS offre_id_119, t0.offreStatus_id AS offreStatus_id_120, t0.identiteBeneficiaire_id AS identiteBeneficiaire_id_121, t0.identiteInstallateur_id AS identiteInstallateur_id_122, t0.operation_id AS operation_id_123, t0.particulierUser_id AS particulierUser_id_124, t0.qualificationRecord_id AS qualificationRecord_id_125, t0.sousTraitant_id AS sousTraitant_id_126, t0.program_id AS program_id_127, t0.programCommercial_id AS programCommercial_id_128, t0.programManager_id AS programManager_id_129, t0.signatureAuto_id AS signatureAuto_id_130, t0.wasteCenter_id AS wasteCenter_id_131, t0.waste_id AS waste_id_132, t0.programAuto_id AS programAuto_id_133, t0.justificatif_id AS justificatif_id_134, t0.cappingRule_id AS cappingRule_id_135, t136.id AS id_137, t136.mprUuid AS mprUuid_138, t136.mprReference AS mprReference_139, t136.paymentDate AS paymentDate_140, t136.invoiceReference AS invoiceReference_141, t136.invoiceDate AS invoiceDate_142, t136.amount AS amount_143, t136.archive AS archive_144, t136.step AS step_145, t136.offreProjet_id AS offreProjet_id_146, t136.batchBankTransfer_id AS batchBankTransfer_id_147, t136.installateur_id AS installateur_id_148, t136.particulierUser_id AS particulierUser_id_149, t150.id AS id_151, t150.numero AS numero_152, t150.dateRealisation AS dateRealisation_153, t150.dateFinValidite AS dateFinValidite_154, t150.etiquetteBilan AS etiquetteBilan_155, t150.createdAt AS createdAt_156, t150.updatedAt AS updatedAt_157, t150.typeJustificatif AS typeJustificatif_158, t150.projet_id AS projet_id_159, t150.offreProjet_id AS offreProjet_id_160, t0.projectOwner_id AS projectOwner_id_161, t0.project_bundle_id AS project_bundle_id_162, t0.estate_id AS estate_id_163, t164.id AS id_165, t164.`value` AS value_166, t164.offreProjet_id AS offreProjet_id_167, t164.operation_id AS operation_id_168, t164.oblige_id AS oblige_id_169 FROM OffreProjet t0 LEFT JOIN OffreProjetValidation t96 ON t96.offre_id = t0.id LEFT JOIN `Lead` t110 ON t110.offre_id = t0.id LEFT JOIN PaymentMpr t136 ON t136.offreProjet_id = t0.id LEFT JOIN JustificatifPerformanceEnergetique t150 ON t150.offreProjet_id = t0.id LEFT JOIN Recensement t164 ON t164.offreProjet_id = t0.id WHERE t0.token = ? LIMIT 1
SELECT t0.id AS id_1, t0.dataSimulation AS dataSimulation_2, t0.dataAH AS dataAH_3, t0.cumac AS cumac_4, t0.tauxActualise AS tauxActualise_5, t0.tauxAccumule AS tauxAccumule_6, t0.cumacMoyenne AS cumacMoyenne_7, t0.initiateCDP AS initiateCDP_8, t0.cofracData AS cofracData_9, t0.operation_id AS operation_id_10, t0.projet_id AS projet_id_11, t0.program_id AS program_id_12, t0.offreProjet_id AS offreProjet_id_13 FROM OperationRecord t0 WHERE t0.offreProjet_id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.version AS version_3, t0.code AS code_4, t0.duree AS duree_5, t0.auto_installation AS auto_installation_6, t0.conditions AS conditions_7, t0.conditionsRaw AS conditionsRaw_8, t0.conditionsFormater AS conditionsFormater_9, t0.documents_requis AS documents_requis_10, t0.nombre_documents AS nombre_documents_11, t0.nombre_conditions AS nombre_conditions_12, t0.question_details_type AS question_details_type_13, t0.question_details_value AS question_details_value_14, t0.periode AS periode_15, t0.informationTechnique AS informationTechnique_16, t0.informationTechniqueRaw AS informationTechniqueRaw_17, t0.informationTechniqueFormater AS informationTechniqueFormater_18, t0.informationDocSupplementaire AS informationDocSupplementaire_19, t0.informationDocSupplementaireRaw AS informationDocSupplementaireRaw_20, t0.informationDocSupplementaireFormater AS informationDocSupplementaireFormater_21, t0.informationfacture AS informationfacture_22, t0.informationfactureRaw AS informationfactureRaw_23, t0.informationfactureFormater AS informationfactureFormater_24, t0.informationfacture2 AS informationfacture2_25, t0.informationfacture2Raw AS informationfacture2Raw_26, t0.informationfacture2Formater AS informationfacture2Formater_27, t0.nbMateriau AS nbMateriau_28, t0.materiauSubtitle AS materiauSubtitle_29, t0.materiauTitle AS materiauTitle_30, t0.textForm AS textForm_31, t0.private AS private_32, t0.campagne AS campagne_33, t0.special AS special_34, t0.abrogation_datetime AS abrogation_datetime_35, t0.date_limite_depot_referencement AS date_limite_depot_referencement_36, t0.end_zni_date AS end_zni_date_37, t0.globalConfigurationHash AS globalConfigurationHash_38, t0.zni AS zni_39, t0.cdp_eligible AS cdp_eligible_40, t0.simulateur_id AS simulateur_id_41, t0.arrete_id AS arrete_id_42, t0.certification_id AS certification_id_43, t0.qualification_id AS qualification_id_44, t0.formConfigEngine_id AS formConfigEngine_id_45 FROM Operation t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.nom AS nom_3, t0.nom_cd AS nom_cd_4, t0.cdiscount AS cdiscount_5, t0.pretty_name AS pretty_name_6, t0.status AS status_7, t0.slug AS slug_8, t0.form_lead_id AS form_lead_id_9, t0.active_operation_id AS active_operation_id_10, t11.id AS id_12, t11.nom AS nom_13, t11.version AS version_14, t11.code AS code_15, t11.duree AS duree_16, t11.auto_installation AS auto_installation_17, t11.conditions AS conditions_18, t11.conditionsRaw AS conditionsRaw_19, t11.conditionsFormater AS conditionsFormater_20, t11.documents_requis AS documents_requis_21, t11.nombre_documents AS nombre_documents_22, t11.nombre_conditions AS nombre_conditions_23, t11.question_details_type AS question_details_type_24, t11.question_details_value AS question_details_value_25, t11.periode AS periode_26, t11.informationTechnique AS informationTechnique_27, t11.informationTechniqueRaw AS informationTechniqueRaw_28, t11.informationTechniqueFormater AS informationTechniqueFormater_29, t11.informationDocSupplementaire AS informationDocSupplementaire_30, t11.informationDocSupplementaireRaw AS informationDocSupplementaireRaw_31, t11.informationDocSupplementaireFormater AS informationDocSupplementaireFormater_32, t11.informationfacture AS informationfacture_33, t11.informationfactureRaw AS informationfactureRaw_34, t11.informationfactureFormater AS informationfactureFormater_35, t11.informationfacture2 AS informationfacture2_36, t11.informationfacture2Raw AS informationfacture2Raw_37, t11.informationfacture2Formater AS informationfacture2Formater_38, t11.nbMateriau AS nbMateriau_39, t11.materiauSubtitle AS materiauSubtitle_40, t11.materiauTitle AS materiauTitle_41, t11.textForm AS textForm_42, t11.private AS private_43, t11.campagne AS campagne_44, t11.special AS special_45, t11.abrogation_datetime AS abrogation_datetime_46, t11.date_limite_depot_referencement AS date_limite_depot_referencement_47, t11.end_zni_date AS end_zni_date_48, t11.globalConfigurationHash AS globalConfigurationHash_49, t11.zni AS zni_50, t11.cdp_eligible AS cdp_eligible_51, t11.simulateur_id AS simulateur_id_52, t11.arrete_id AS arrete_id_53, t11.certification_id AS certification_id_54, t11.qualification_id AS qualification_id_55, t11.formConfigEngine_id AS formConfigEngine_id_56, t0.secteur_id AS secteur_id_57, t0.categorie_id AS categorie_id_58, t0.categorieCd_id AS categorieCd_id_59, t0.type_operation_id AS type_operation_id_60, t0.operation_specifique_id AS operation_specifique_id_61, t62.id AS id_63, t62.mode AS mode_64, t62.targetType AS targetType_65, t62.classic AS classic_66, t62.preca AS preca_67, t62.enable AS enable_68, t62.raiType AS raiType_69, t62.contractSignedElectronically AS contractSignedElectronically_70, t62.pro_signature_mandatory_outlay AS pro_signature_mandatory_outlay_71, t62.obligeTarget_id AS obligeTarget_id_72, t62.teteReseau_id AS teteReseau_id_73, t62.simulateur_id AS simulateur_id_74, t62.installateurTarget_id AS installateurTarget_id_75, t62.beTarget_id AS beTarget_id_76 FROM Simulateur t0 LEFT JOIN Operation t11 ON t0.active_operation_id = t11.id LEFT JOIN AffectationConsoneoRule t62 ON t62.simulateur_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.status AS status_4 FROM Secteur t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.status AS status_4 FROM TypeOperation t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.description AS description_4, t0.status AS status_5, t0.slug AS slug_6, t0.human_title AS human_title_7, t0.position AS position_8 FROM SecteurActivite t0 WHERE t0.id = ?
SELECT a0_.id AS id_0, a0_.created_datetime AS created_datetime_1, a0_.reason AS reason_2, a0_.type AS type_3, a0_.burn AS burn_4, a0_.burn_datetime AS burn_datetime_5, a0_.target_state_choice AS target_state_choice_6, a0_.batch_choice AS batch_choice_7, a0_.answer AS answer_8, a0_.offreProjet_id AS offreProjet_id_9, a0_.asker_id AS asker_id_10, a0_.target_state AS target_state_11 FROM AskUpdateStateOffreProjet a0_ WHERE a0_.offreProjet_id = ? ORDER BY a0_.created_datetime DESC LIMIT 1
SELECT t0.state AS state_1, t0.prettyName AS prettyName_2, t0.prettyNameIsolvendeur AS prettyNameIsolvendeur_3, t0.prettyNameFront AS prettyNameFront_4, t0.nextStepBe AS nextStepBe_5, t0.nextStepBeneficiaire AS nextStepBeneficiaire_6, t0.ahPrettyName AS ahPrettyName_7, t0.preActif AS preActif_8, t0.actif AS actif_9, t0.validationFinal AS validationFinal_10, t0.postEditionAh AS postEditionAh_11, t0.postValidationFinal AS postValidationFinal_12, t0.preAh AS preAh_13, t0.preValidationFinal AS preValidationFinal_14, t0.inactif AS inactif_15, t0.uploadAvailable AS uploadAvailable_16, t0.uploadPostConvention AS uploadPostConvention_17, t0.noLinearState AS noLinearState_18, t0.EndState AS EndState_19 FROM OffreProjetState t0
SELECT t0.id AS id_1, t0.raison AS raison_2, t0.siret AS siret_3, t0.adresse AS adresse_4, t0.adresse_complement AS adresse_complement_5, t0.codepostal AS codepostal_6, t0.ville AS ville_7, t0.website AS website_8, t0.effectif AS effectif_9, t0.status AS status_10, t0.created_datetime AS created_datetime_11, t0.updated_datetime AS updated_datetime_12, t0.signature AS signature_13, t0.logo AS logo_14, t0.formation_installateur_doc AS formation_installateur_doc_15, t0.pres_marketing_installateur AS pres_marketing_installateur_16, t0.guide_utilisation_commerciaux AS guide_utilisation_commerciaux_17, t0.guidePerformanceEnergetiqueB2b AS guidePerformanceEnergetiqueB2b_18, t0.guidePerformanceEnergetiqueB2c AS guidePerformanceEnergetiqueB2c_19, t0.cgu AS cgu_20, t0.partenariatContract AS partenariatContract_21, t0.tel_beneficiaire_B2C AS tel_beneficiaire_B2C_22, t0.tel_beneficiaire_B2B AS tel_beneficiaire_B2B_23, t0.tel_installateur AS tel_installateur_24, t0.tel_support_intern AS tel_support_intern_25, t0.fax_beneficiaire AS fax_beneficiaire_26, t0.fax_installateur AS fax_installateur_27, t0.email_beneficiaire AS email_beneficiaire_28, t0.email_installateur AS email_installateur_29, t0.is_consoneo AS is_consoneo_30, t0.slug AS slug_31, t0.alias AS alias_32, t0.conventionElectronique AS conventionElectronique_33, t0.aftElectronique AS aftElectronique_34, t0.contratInstallateur AS contratInstallateur_35, t0.modeProBeneficiaireInscription AS modeProBeneficiaireInscription_36, t0.modeByPassSuperviseur AS modeByPassSuperviseur_37, t0.`lead` AS lead_38, t0.`leadUrl` AS leadUrl_39, t0.`leadLogin` AS leadLogin_40, t0.`leadPassword` AS leadPassword_41, t0.relanceConventionClientUn AS relanceConventionClientUn_42, t0.relanceConventionClientDeux AS relanceConventionClientDeux_43, t0.alertConventionClient AS alertConventionClient_44, t0.relanceConventionInstallateurUn AS relanceConventionInstallateurUn_45, t0.relanceConventionInstallateurDeux AS relanceConventionInstallateurDeux_46, t0.alertConventionInstallateur AS alertConventionInstallateur_47, t0.conventionFin AS conventionFin_48, t0.questionnaireAftRelanceUn AS questionnaireAftRelanceUn_49, t0.questionnaireAftRelanceDeux AS questionnaireAftRelanceDeux_50, t0.alertQuestionnaireAFT AS alertQuestionnaireAFT_51, t0.questionnaireAftFin AS questionnaireAftFin_52, t0.relanceAftFacture AS relanceAftFacture_53, t0.alertAftFacture AS alertAftFacture_54, t0.aftFactureFin AS aftFactureFin_55, t0.mentionCnil AS mentionCnil_56, t0.serviceType AS serviceType_57, t0.precariteMode AS precariteMode_58, t0.precariteModeProgram AS precariteModeProgram_59, t0.blocked AS blocked_60, t0.blockedSimulation AS blockedSimulation_61, t0.resiliation AS resiliation_62, t0.archivageAuto AS archivageAuto_63, t0.travauxPostDevis AS travauxPostDevis_64, t0.emailFacturationPro AS emailFacturationPro_65, t0.mandatoryInstallateurGenericContract AS mandatoryInstallateurGenericContract_66, t0.hiddenEmail AS hiddenEmail_67, t0.certificallCompanyId AS certificallCompanyId_68, t0.visibilityCommercials AS visibilityCommercials_69, t0.mandat AS mandat_70, t0.pricingMandatClassique AS pricingMandatClassique_71, t0.pricingMandatPreca AS pricingMandatPreca_72, t0.pricingPrimeMaximumMandatClassique AS pricingPrimeMaximumMandatClassique_73, t0.pricingPrimeMaximumMandatPreca AS pricingPrimeMaximumMandatPreca_74, t0.originauxAdresse AS originauxAdresse_75, t0.originauxAdresseComplement AS originauxAdresseComplement_76, t0.originauxCodepostal AS originauxCodepostal_77, t0.originauxVille AS originauxVille_78, t0.eligible AS eligible_79, t0.satisfactionSurvey AS satisfactionSurvey_80, t0.surveyConfiguration AS surveyConfiguration_81, t0.autoPayment AS autoPayment_82, t0.isAnnexeDechetQuestion AS isAnnexeDechetQuestion_83, t0.aiEnabled AS aiEnabled_84, t0.isSignatureAutoAhEnabled AS isSignatureAutoAhEnabled_85, t0.isSignatureAutoOtherDocumentsEnabled AS isSignatureAutoOtherDocumentsEnabled_86, t0.emailVersion AS emailVersion_87, t0.validateBackwards AS validateBackwards_88, t0.displayTelConsoneo AS displayTelConsoneo_89, t0.allowedUniverSign AS allowedUniverSign_90, t0.allowedApplicationFees AS allowedApplicationFees_91, t0.displayApplicationFees AS displayApplicationFees_92, t0.programAutoAllowed AS programAutoAllowed_93, t0.mpr AS mpr_94, t0.isRibActivated AS isRibActivated_95, t0.canonicalTeteReseau_id AS canonicalTeteReseau_id_96, t0.oblige_id AS oblige_id_97, t98.id AS id_99, t98.raison AS raison_100, t98.email AS email_101, t98.tel AS tel_102, t98.site_web AS site_web_103, t98.adresse AS adresse_104, t98.cp AS cp_105, t98.ville AS ville_106, t98.oblige_id AS oblige_id_107, t108.id AS id_109, t108.gender AS gender_110, t108.firstName AS firstName_111, t108.name AS name_112, t108.raison AS raison_113, t108.email AS email_114, t108.tel AS tel_115, t108.address AS address_116, t108.cp AS cp_117, t108.city AS city_118, t108.adminMandate AS adminMandate_119, t108.financialMandate AS financialMandate_120, t108.mixteMandate AS mixteMandate_121, t108.signature AS signature_122, t108.tutorial_admin AS tutorial_admin_123, t108.tutorial_mixte AS tutorial_mixte_124, t108.tutorial_financial AS tutorial_financial_125, t108.oblige_id AS oblige_id_126, t127.id AS id_128, t127.raison AS raison_129, t127.siret AS siret_130, t127.oblige_id AS oblige_id_131 FROM Oblige t0 LEFT JOIN Mediateur t98 ON t98.oblige_id = t0.id LEFT JOIN MprConfig t108 ON t108.oblige_id = t0.id LEFT JOIN Mandataire t127 ON t127.oblige_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.enabled AS enabled_3, t0.salt AS salt_4, t0.password AS password_5, t0.last_login AS last_login_6, t0.confirmation_token AS confirmation_token_7, t0.password_requested_at AS password_requested_at_8, t0.roles AS roles_9, t0.username AS username_10, t0.nom AS nom_11, t0.prenom AS prenom_12, t0.fonction AS fonction_13, t0.tel AS tel_14, t0.mobile AS mobile_15, t0.activation AS activation_16, t0.createdAt AS createdAt_17, t0.updatedAt AS updatedAt_18, t0.optin AS optin_19, t0.dateActivation AS dateActivation_20, t0.emailValidatedDateTime AS emailValidatedDateTime_21, t0.emailCreatedDateTime AS emailCreatedDateTime_22, t0.mobileCreatedDatetime AS mobileCreatedDatetime_23, t0.sendEmail AS sendEmail_24, t0.scope AS scope_25, t0.isArchived AS isArchived_26, t0.import AS import_27, t0.neoSpaceEnabled AS neoSpaceEnabled_28, t0.email_canonical AS email_canonical_29, t0.username_canonical AS username_canonical_30, t0.oblige_id AS oblige_id_31 FROM ObligeUser t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.obligeRole_id AS obligeRole_id_3, t4.id AS id_5, t4.role AS role_6, t4.title AS title_7, t4.scope AS scope_8, t4.position AS position_9, t4.definition AS definition_10, t4.cycle AS cycle_11, t4.only_consoneo_update AS only_consoneo_update_12, t0.teteReseau_id AS teteReseau_id_13 FROM RegleRole t0 LEFT JOIN ObligeRole t4 ON t0.obligeRole_id = t4.id INNER JOIN RegleRole_ObligeUser ON t0.id = RegleRole_ObligeUser.regleRoleId WHERE RegleRole_ObligeUser.userId = ?
SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3, t0.`description` AS description_4, t0.object_id AS object_id_5, t0.object_class AS object_class_6, t0.is_default AS is_default_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM Configuration t0 WHERE t0.`key` = ? AND t0.object_id = ? AND t0.object_class = ? LIMIT 1
SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3, t0.`description` AS description_4, t0.object_id AS object_id_5, t0.object_class AS object_class_6, t0.is_default AS is_default_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM Configuration t0 WHERE t0.`key` = ? AND t0.object_id = ? AND t0.object_class = ? LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.obligeRole_id AS obligeRole_id_3, t4.id AS id_5, t4.role AS role_6, t4.title AS title_7, t4.scope AS scope_8, t4.position AS position_9, t4.definition AS definition_10, t4.cycle AS cycle_11, t4.only_consoneo_update AS only_consoneo_update_12, t0.teteReseau_id AS teteReseau_id_13 FROM RegleRole t0 LEFT JOIN ObligeRole t4 ON t0.obligeRole_id = t4.id WHERE t0.nom = ? LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.obligeRole_id AS obligeRole_id_3, t4.id AS id_5, t4.role AS role_6, t4.title AS title_7, t4.scope AS scope_8, t4.position AS position_9, t4.definition AS definition_10, t4.cycle AS cycle_11, t4.only_consoneo_update AS only_consoneo_update_12, t0.teteReseau_id AS teteReseau_id_13 FROM RegleRole t0 LEFT JOIN ObligeRole t4 ON t0.obligeRole_id = t4.id INNER JOIN RegleRole_ObligeUser ON t0.id = RegleRole_ObligeUser.regleRoleId WHERE RegleRole_ObligeUser.userId = ?
SELECT t0.id AS id_1, t0.username_canonical AS username_canonical_2, t0.email_canonical AS email_canonical_3, t0.enabled AS enabled_4, t0.salt AS salt_5, t0.password AS password_6, t0.last_login AS last_login_7, t0.confirmation_token AS confirmation_token_8, t0.password_requested_at AS password_requested_at_9, t0.roles AS roles_10, t0.nom AS nom_11, t0.prenom AS prenom_12, t0.fonction AS fonction_13, t0.tel AS tel_14, t0.mobile AS mobile_15, t0.activation AS activation_16, t0.createdAt AS createdAt_17, t0.updatedAt AS updatedAt_18, t0.optin AS optin_19, t0.dateActivation AS dateActivation_20, t0.emailValidatedDateTime AS emailValidatedDateTime_21, t0.emailCreatedDateTime AS emailCreatedDateTime_22, t0.mobileCreatedDatetime AS mobileCreatedDatetime_23, t0.sendEmail AS sendEmail_24, t0.dateEnvoiGuide AS dateEnvoiGuide_25, t0.token AS token_26, t0.emailJustificatifPreca AS emailJustificatifPreca_27, t0.adresse AS adresse_28, t0.adresse_complement AS adresse_complement_29, t0.codepostal AS codepostal_30, t0.ville AS ville_31, t0.formPrecaResponse AS formPrecaResponse_32, t0.gender AS gender_33, t0.stampFilename AS stampFilename_34, t0.email AS email_35, t0.username AS username_36, t0.cas1_id AS cas1_id_37, t38.id AS id_39, t38.type AS type_40, t38.detail AS detail_41, t38.token AS token_42, t38.installateur_id AS installateur_id_43, t38.particulierUser_id AS particulierUser_id_44, t38.entrepriseUser_id AS entrepriseUser_id_45, t38.particulierUserContact_id AS particulierUserContact_id_46, t38.entrepriseUserContact_id AS entrepriseUserContact_id_47, t0.identite_id AS identite_id_48, t0.integrationModule_id AS integrationModule_id_49 FROM ParticulierUserContact t0 LEFT JOIN PaymentMethod t38 ON t38.particulierUserContact_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.raison AS raison_2, t0.siret AS siret_3, t0.adresse AS adresse_4, t0.adresse_complement AS adresse_complement_5, t0.codepostal AS codepostal_6, t0.ville AS ville_7, t0.website AS website_8, t0.effectif AS effectif_9, t0.status AS status_10, t0.created_datetime AS created_datetime_11, t0.updated_datetime AS updated_datetime_12, t0.signature AS signature_13, t0.logo AS logo_14, t0.formation_installateur_doc AS formation_installateur_doc_15, t0.pres_marketing_installateur AS pres_marketing_installateur_16, t0.guide_utilisation_commerciaux AS guide_utilisation_commerciaux_17, t0.guidePerformanceEnergetiqueB2b AS guidePerformanceEnergetiqueB2b_18, t0.guidePerformanceEnergetiqueB2c AS guidePerformanceEnergetiqueB2c_19, t0.cgu AS cgu_20, t0.partenariatContract AS partenariatContract_21, t0.tel_beneficiaire_B2C AS tel_beneficiaire_B2C_22, t0.tel_beneficiaire_B2B AS tel_beneficiaire_B2B_23, t0.tel_installateur AS tel_installateur_24, t0.tel_support_intern AS tel_support_intern_25, t0.fax_beneficiaire AS fax_beneficiaire_26, t0.fax_installateur AS fax_installateur_27, t0.email_beneficiaire AS email_beneficiaire_28, t0.email_installateur AS email_installateur_29, t0.is_consoneo AS is_consoneo_30, t0.slug AS slug_31, t0.alias AS alias_32, t0.conventionElectronique AS conventionElectronique_33, t0.aftElectronique AS aftElectronique_34, t0.contratInstallateur AS contratInstallateur_35, t0.modeProBeneficiaireInscription AS modeProBeneficiaireInscription_36, t0.modeByPassSuperviseur AS modeByPassSuperviseur_37, t0.`lead` AS lead_38, t0.`leadUrl` AS leadUrl_39, t0.`leadLogin` AS leadLogin_40, t0.`leadPassword` AS leadPassword_41, t0.relanceConventionClientUn AS relanceConventionClientUn_42, t0.relanceConventionClientDeux AS relanceConventionClientDeux_43, t0.alertConventionClient AS alertConventionClient_44, t0.relanceConventionInstallateurUn AS relanceConventionInstallateurUn_45, t0.relanceConventionInstallateurDeux AS relanceConventionInstallateurDeux_46, t0.alertConventionInstallateur AS alertConventionInstallateur_47, t0.conventionFin AS conventionFin_48, t0.questionnaireAftRelanceUn AS questionnaireAftRelanceUn_49, t0.questionnaireAftRelanceDeux AS questionnaireAftRelanceDeux_50, t0.alertQuestionnaireAFT AS alertQuestionnaireAFT_51, t0.questionnaireAftFin AS questionnaireAftFin_52, t0.relanceAftFacture AS relanceAftFacture_53, t0.alertAftFacture AS alertAftFacture_54, t0.aftFactureFin AS aftFactureFin_55, t0.mentionCnil AS mentionCnil_56, t0.serviceType AS serviceType_57, t0.precariteMode AS precariteMode_58, t0.precariteModeProgram AS precariteModeProgram_59, t0.blocked AS blocked_60, t0.blockedSimulation AS blockedSimulation_61, t0.resiliation AS resiliation_62, t0.archivageAuto AS archivageAuto_63, t0.travauxPostDevis AS travauxPostDevis_64, t0.emailFacturationPro AS emailFacturationPro_65, t0.mandatoryInstallateurGenericContract AS mandatoryInstallateurGenericContract_66, t0.hiddenEmail AS hiddenEmail_67, t0.certificallCompanyId AS certificallCompanyId_68, t0.visibilityCommercials AS visibilityCommercials_69, t0.mandat AS mandat_70, t0.pricingMandatClassique AS pricingMandatClassique_71, t0.pricingMandatPreca AS pricingMandatPreca_72, t0.pricingPrimeMaximumMandatClassique AS pricingPrimeMaximumMandatClassique_73, t0.pricingPrimeMaximumMandatPreca AS pricingPrimeMaximumMandatPreca_74, t0.originauxAdresse AS originauxAdresse_75, t0.originauxAdresseComplement AS originauxAdresseComplement_76, t0.originauxCodepostal AS originauxCodepostal_77, t0.originauxVille AS originauxVille_78, t0.eligible AS eligible_79, t0.satisfactionSurvey AS satisfactionSurvey_80, t0.surveyConfiguration AS surveyConfiguration_81, t0.autoPayment AS autoPayment_82, t0.isAnnexeDechetQuestion AS isAnnexeDechetQuestion_83, t0.aiEnabled AS aiEnabled_84, t0.isSignatureAutoAhEnabled AS isSignatureAutoAhEnabled_85, t0.isSignatureAutoOtherDocumentsEnabled AS isSignatureAutoOtherDocumentsEnabled_86, t0.emailVersion AS emailVersion_87, t0.validateBackwards AS validateBackwards_88, t0.displayTelConsoneo AS displayTelConsoneo_89, t0.allowedUniverSign AS allowedUniverSign_90, t0.allowedApplicationFees AS allowedApplicationFees_91, t0.displayApplicationFees AS displayApplicationFees_92, t0.programAutoAllowed AS programAutoAllowed_93, t0.mpr AS mpr_94, t0.isRibActivated AS isRibActivated_95, t0.canonicalTeteReseau_id AS canonicalTeteReseau_id_96, t0.oblige_id AS oblige_id_97, t98.id AS id_99, t98.raison AS raison_100, t98.email AS email_101, t98.tel AS tel_102, t98.site_web AS site_web_103, t98.adresse AS adresse_104, t98.cp AS cp_105, t98.ville AS ville_106, t98.oblige_id AS oblige_id_107, t108.id AS id_109, t108.gender AS gender_110, t108.firstName AS firstName_111, t108.name AS name_112, t108.raison AS raison_113, t108.email AS email_114, t108.tel AS tel_115, t108.address AS address_116, t108.cp AS cp_117, t108.city AS city_118, t108.adminMandate AS adminMandate_119, t108.financialMandate AS financialMandate_120, t108.mixteMandate AS mixteMandate_121, t108.signature AS signature_122, t108.tutorial_admin AS tutorial_admin_123, t108.tutorial_mixte AS tutorial_mixte_124, t108.tutorial_financial AS tutorial_financial_125, t108.oblige_id AS oblige_id_126, t127.id AS id_128, t127.raison AS raison_129, t127.siret AS siret_130, t127.oblige_id AS oblige_id_131 FROM Oblige t0 LEFT JOIN Mediateur t98 ON t98.oblige_id = t0.id LEFT JOIN MprConfig t108 ON t108.oblige_id = t0.id LEFT JOIN Mandataire t127 ON t127.oblige_id = t0.id WHERE t0.oblige_id = ?
SELECT o0_.id AS id_0, o0_.type AS type_1, o0_.pricingType AS pricingType_2, o0_.finalisationRequested AS finalisationRequested_3, o0_.finalisationRequestDate AS finalisationRequestDate_4, o0_.cofracSatisfyDate AS cofracSatisfyDate_5, o0_.reference AS reference_6, o0_.data AS data_7, o0_.cofracData AS cofracData_8, o0_.cofracEngineDocumentId AS cofracEngineDocumentId_9, o0_.ip AS ip_10, o0_.offre_auto_date AS offre_auto_date_11, o0_.created_datetime AS created_datetime_12, o0_.updated_datetime AS updated_datetime_13, o0_.tel AS tel_14, o0_.codepostal AS codepostal_15, o0_.adresse AS adresse_16, o0_.adresse_complement AS adresse_complement_17, o0_.ville AS ville_18, o0_.delai_souhaite AS delai_souhaite_19, o0_.accept_recevoir_offre AS accept_recevoir_offre_20, o0_.accept_recommandation AS accept_recommandation_21, o0_.acceptLeadPromo AS acceptLeadPromo_22, o0_.offre_cumac AS offre_cumac_23, o0_.offre_cumac_client AS offre_cumac_client_24, o0_.offre_cumac_precarite AS offre_cumac_precarite_25, o0_.offre_cumac_client_precarite AS offre_cumac_client_precarite_26, o0_.cumac AS cumac_27, o0_.cumac_AFT AS cumac_AFT_28, o0_.total_prime AS total_prime_29, o0_.total_prime_AFT AS total_prime_AFT_30, o0_.prime_pro AS prime_pro_31, o0_.prime_pro_aft AS prime_pro_aft_32, o0_.prime_client AS prime_client_33, o0_.prime_client_aft AS prime_client_aft_34, o0_.cumac_moyenne AS cumac_moyenne_35, o0_.taux_actualise AS taux_actualise_36, o0_.taux_accumule AS taux_accumule_37, o0_.date_debut_chantier AS date_debut_chantier_38, o0_.date_demande_offre AS date_demande_offre_39, o0_.date_fin_chantier AS date_fin_chantier_40, o0_.etat AS etat_41, o0_.status AS status_42, o0_.date_offre AS date_offre_43, o0_.notification_date_chantier AS notification_date_chantier_44, o0_.date_retour_conv AS date_retour_conv_45, o0_.date_validation_conv AS date_validation_conv_46, o0_.date_chantier_renseigne AS date_chantier_renseigne_47, o0_.date_paiement AS date_paiement_48, o0_.date_all_doc_valid AS date_all_doc_valid_49, o0_.date_fin_chantier_repousse AS date_fin_chantier_repousse_50, o0_.date_envoi_questionnaire AS date_envoi_questionnaire_51, o0_.date_edition_questionnaire AS date_edition_questionnaire_52, o0_.date_validation_final AS date_validation_final_53, o0_.date_annulation AS date_annulation_54, o0_.no_click_email_date_chantier AS no_click_email_date_chantier_55, o0_.token AS token_56, o0_.auto_installation AS auto_installation_57, o0_.siret AS siret_58, o0_.cancelReason AS cancelReason_59, o0_.dateCommande AS dateCommande_60, o0_.siteTravaux AS siteTravaux_61, o0_.incitation AS incitation_62, o0_.qualificationRecordDate AS qualificationRecordDate_63, o0_.serviceType AS serviceType_64, o0_.debutChantier AS debutChantier_65, o0_.finChantier AS finChantier_66, o0_.initiateCDP AS initiateCDP_67, o0_.cdp AS cdp_68, o0_.date_last_envoi_convention AS date_last_envoi_convention_69, o0_.programStep AS programStep_70, o0_.devisRestAPayer AS devisRestAPayer_71, o0_.pricingMandatClassique AS pricingMandatClassique_72, o0_.pricingMandatPreca AS pricingMandatPreca_73, o0_.isCOFRAC AS isCOFRAC_74, o0_.applicationFeesPrice AS applicationFeesPrice_75, o0_.attributes AS attributes_76, o0_.exclusive AS exclusive_77, o0_.engineDocumentId AS engineDocumentId_78, o0_.adresseTravaux AS adresseTravaux_79, o0_.adresseTravauxCommentaire AS adresseTravauxCommentaire_80, o0_.batchOffreProjet_id AS batchOffreProjet_id_81, o0_.entrepriseUser_id AS entrepriseUser_id_82, o0_.installateurUser_id AS installateurUser_id_83, o0_.beUser_id AS beUser_id_84, o0_.entrepriseUserContact_id AS entrepriseUserContact_id_85, o0_.particulierUserContact_id AS particulierUserContact_id_86, o0_.signataireEntreprise_id AS signataireEntreprise_id_87, o0_.signataireInstallateur_id AS signataireInstallateur_id_88, o0_.installateurUserContact_id AS installateurUserContact_id_89, o0_.projet_id AS projet_id_90, o0_.precariteCas2_id AS precariteCas2_id_91, o0_.creditNoteContract_id AS creditNoteContract_id_92, o0_.precarite_id AS precarite_id_93, o0_.state_id AS state_id_94, o0_.oblige_id AS oblige_id_95, o0_.secteurActivite_id AS secteurActivite_id_96, o0_.factureDetail_id AS factureDetail_id_97, o0_.offreStatus_id AS offreStatus_id_98, o0_.identiteBeneficiaire_id AS identiteBeneficiaire_id_99, o0_.identiteInstallateur_id AS identiteInstallateur_id_100, o0_.operation_id AS operation_id_101, o0_.particulierUser_id AS particulierUser_id_102, o0_.qualificationRecord_id AS qualificationRecord_id_103, o0_.sousTraitant_id AS sousTraitant_id_104, o0_.program_id AS program_id_105, o0_.programCommercial_id AS programCommercial_id_106, o0_.programManager_id AS programManager_id_107, o0_.signatureAuto_id AS signatureAuto_id_108, o0_.wasteCenter_id AS wasteCenter_id_109, o0_.waste_id AS waste_id_110, o0_.programAuto_id AS programAuto_id_111, o0_.justificatif_id AS justificatif_id_112, o0_.cappingRule_id AS cappingRule_id_113, o0_.projectOwner_id AS projectOwner_id_114, o0_.project_bundle_id AS project_bundle_id_115, o0_.estate_id AS estate_id_116 FROM OffreProjet o0_ LEFT JOIN EntrepriseUserContact e1_ ON o0_.entrepriseUserContact_id = e1_.id LEFT JOIN ParticulierUserContact p2_ ON o0_.particulierUserContact_id = p2_.id LEFT JOIN EntrepriseUser e3_ ON o0_.entrepriseUser_id = e3_.id LEFT JOIN ParticulierUser p4_ ON o0_.particulierUser_id = p4_.id LEFT JOIN OperationRecord o5_ ON o0_.id = o5_.offreProjet_id LEFT JOIN Operation o6_ ON o5_.operation_id = o6_.id LEFT JOIN Operation o7_ ON o0_.operation_id = o7_.id WHERE o0_.oblige_id IN (?, ?, ?) AND o0_.id <> ? AND (e1_.username = ? OR p2_.username = ? OR e3_.username = ? OR p4_.username = ?) AND (o7_.nom LIKE ? OR o6_.nom LIKE ?) AND o0_.etat NOT IN (?, ?, ?, ?, ?, ?)

#▲	Time	Info
1	1.53 ms	SELECT t0.id AS id_1, t0.email AS email_2, t0.enabled AS enabled_3, t0.salt AS salt_4, t0.password AS password_5, t0.last_login AS last_login_6, t0.confirmation_token AS confirmation_token_7, t0.password_requested_at AS password_requested_at_8, t0.roles AS roles_9, t0.username AS username_10, t0.nom AS nom_11, t0.prenom AS prenom_12, t0.fonction AS fonction_13, t0.tel AS tel_14, t0.mobile AS mobile_15, t0.activation AS activation_16, t0.createdAt AS createdAt_17, t0.updatedAt AS updatedAt_18, t0.optin AS optin_19, t0.dateActivation AS dateActivation_20, t0.emailValidatedDateTime AS emailValidatedDateTime_21, t0.emailCreatedDateTime AS emailCreatedDateTime_22, t0.mobileCreatedDatetime AS mobileCreatedDatetime_23, t0.sendEmail AS sendEmail_24, t0.scope AS scope_25, t0.isArchived AS isArchived_26, t0.import AS import_27, t0.neoSpaceEnabled AS neoSpaceEnabled_28, t0.email_canonical AS email_canonical_29, t0.username_canonical AS username_canonical_30, t0.oblige_id AS oblige_id_31 FROM ObligeUser t0 WHERE t0.id = ? Parameters: [`44`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.email AS email_2, t0.enabled AS enabled_3, t0.salt AS salt_4, t0.password AS password_5, t0.last_login AS last_login_6, t0.confirmation_token AS confirmation_token_7, t0.password_requested_at AS password_requested_at_8, t0.roles AS roles_9, t0.username AS username_10, t0.nom AS nom_11, t0.prenom AS prenom_12, t0.fonction AS fonction_13, t0.tel AS tel_14, t0.mobile AS mobile_15, t0.activation AS activation_16, t0.createdAt AS createdAt_17, t0.updatedAt AS updatedAt_18, t0.optin AS optin_19, t0.dateActivation AS dateActivation_20, t0.emailValidatedDateTime AS emailValidatedDateTime_21, t0.emailCreatedDateTime AS emailCreatedDateTime_22, t0.mobileCreatedDatetime AS mobileCreatedDatetime_23, t0.sendEmail AS sendEmail_24, t0.scope AS scope_25, t0.isArchived AS isArchived_26, t0.import AS import_27, t0.neoSpaceEnabled AS neoSpaceEnabled_28, t0.email_canonical AS email_canonical_29, t0.username_canonical AS username_canonical_30, t0.oblige_id AS oblige_id_31 FROM ObligeUser t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.email AS email_2, t0.enabled AS enabled_3, t0.salt AS salt_4, t0.password AS password_5, t0.last_login AS last_login_6, t0.confirmation_token AS confirmation_token_7, t0.password_requested_at AS password_requested_at_8, t0.roles AS roles_9, t0.username AS username_10, t0.nom AS nom_11, t0.prenom AS prenom_12, t0.fonction AS fonction_13, t0.tel AS tel_14, t0.mobile AS mobile_15, t0.activation AS activation_16, t0.createdAt AS createdAt_17, t0.updatedAt AS updatedAt_18, t0.optin AS optin_19, t0.dateActivation AS dateActivation_20, t0.emailValidatedDateTime AS emailValidatedDateTime_21, t0.emailCreatedDateTime AS emailCreatedDateTime_22, t0.mobileCreatedDatetime AS mobileCreatedDatetime_23, t0.sendEmail AS sendEmail_24, t0.scope AS scope_25, t0.isArchived AS isArchived_26, t0.import AS import_27, t0.neoSpaceEnabled AS neoSpaceEnabled_28, t0.email_canonical AS email_canonical_29, t0.username_canonical AS username_canonical_30, t0.oblige_id AS oblige_id_31 FROM ObligeUser t0 WHERE t0.id = 44;
2	4.61 ms	SELECT t0.id AS id_1, t0.type AS type_2, t0.pricingType AS pricingType_3, t0.finalisationRequested AS finalisationRequested_4, t0.finalisationRequestDate AS finalisationRequestDate_5, t0.cofracSatisfyDate AS cofracSatisfyDate_6, t0.reference AS reference_7, t0.data AS data_8, t0.cofracData AS cofracData_9, t0.cofracEngineDocumentId AS cofracEngineDocumentId_10, t0.ip AS ip_11, t0.offre_auto_date AS offre_auto_date_12, t0.created_datetime AS created_datetime_13, t0.updated_datetime AS updated_datetime_14, t0.tel AS tel_15, t0.codepostal AS codepostal_16, t0.adresse AS adresse_17, t0.adresse_complement AS adresse_complement_18, t0.ville AS ville_19, t0.delai_souhaite AS delai_souhaite_20, t0.accept_recevoir_offre AS accept_recevoir_offre_21, t0.accept_recommandation AS accept_recommandation_22, t0.acceptLeadPromo AS acceptLeadPromo_23, t0.offre_cumac AS offre_cumac_24, t0.offre_cumac_client AS offre_cumac_client_25, t0.offre_cumac_precarite AS offre_cumac_precarite_26, t0.offre_cumac_client_precarite AS offre_cumac_client_precarite_27, t0.cumac AS cumac_28, t0.cumac_AFT AS cumac_AFT_29, t0.total_prime AS total_prime_30, t0.total_prime_AFT AS total_prime_AFT_31, t0.prime_pro AS prime_pro_32, t0.prime_pro_aft AS prime_pro_aft_33, t0.prime_client AS prime_client_34, t0.prime_client_aft AS prime_client_aft_35, t0.cumac_moyenne AS cumac_moyenne_36, t0.taux_actualise AS taux_actualise_37, t0.taux_accumule AS taux_accumule_38, t0.date_debut_chantier AS date_debut_chantier_39, t0.date_demande_offre AS date_demande_offre_40, t0.date_fin_chantier AS date_fin_chantier_41, t0.etat AS etat_42, t0.status AS status_43, t0.date_offre AS date_offre_44, t0.notification_date_chantier AS notification_date_chantier_45, t0.date_retour_conv AS date_retour_conv_46, t0.date_validation_conv AS date_validation_conv_47, t0.date_chantier_renseigne AS date_chantier_renseigne_48, t0.date_paiement AS date_paiement_49, t0.date_all_doc_valid AS date_all_doc_valid_50, t0.date_fin_chantier_repousse AS date_fin_chantier_repousse_51, t0.date_envoi_questionnaire AS date_envoi_questionnaire_52, t0.date_edition_questionnaire AS date_edition_questionnaire_53, t0.date_validation_final AS date_validation_final_54, t0.date_annulation AS date_annulation_55, t0.no_click_email_date_chantier AS no_click_email_date_chantier_56, t0.token AS token_57, t0.auto_installation AS auto_installation_58, t0.siret AS siret_59, t0.cancelReason AS cancelReason_60, t0.dateCommande AS dateCommande_61, t0.siteTravaux AS siteTravaux_62, t0.incitation AS incitation_63, t0.qualificationRecordDate AS qualificationRecordDate_64, t0.serviceType AS serviceType_65, t0.debutChantier AS debutChantier_66, t0.finChantier AS finChantier_67, t0.initiateCDP AS initiateCDP_68, t0.cdp AS cdp_69, t0.date_last_envoi_convention AS date_last_envoi_convention_70, t0.programStep AS programStep_71, t0.devisRestAPayer AS devisRestAPayer_72, t0.pricingMandatClassique AS pricingMandatClassique_73, t0.pricingMandatPreca AS pricingMandatPreca_74, t0.isCOFRAC AS isCOFRAC_75, t0.applicationFeesPrice AS applicationFeesPrice_76, t0.attributes AS attributes_77, t0.exclusive AS exclusive_78, t0.engineDocumentId AS engineDocumentId_79, t0.adresseTravaux AS adresseTravaux_80, t0.adresseTravauxCommentaire AS adresseTravauxCommentaire_81, t0.batchOffreProjet_id AS batchOffreProjet_id_82, t0.entrepriseUser_id AS entrepriseUser_id_83, t0.installateurUser_id AS installateurUser_id_84, t0.beUser_id AS beUser_id_85, t0.entrepriseUserContact_id AS entrepriseUserContact_id_86, t0.particulierUserContact_id AS particulierUserContact_id_87, t0.signataireEntreprise_id AS signataireEntreprise_id_88, t0.signataireInstallateur_id AS signataireInstallateur_id_89, t0.installateurUserContact_id AS installateurUserContact_id_90, t0.projet_id AS projet_id_91, t0.precariteCas2_id AS precariteCas2_id_92, t0.creditNoteContract_id AS creditNoteContract_id_93, t0.precarite_id AS precarite_id_94, t0.state_id AS state_id_95, t96.id AS id_97, t96.created_datetime AS created_datetime_98, t96.convention AS convention_99, t96.aft AS aft_100, t96.facture AS facture_101, t96.beneficiaire AS beneficiaire_102, t96.installateur AS installateur_103, t96.doc_obligatoire AS doc_obligatoire_104, t96.coherence_dossier AS coherence_dossier_105, t96.offre_id AS offre_id_106, t0.oblige_id AS oblige_id_107, t0.secteurActivite_id AS secteurActivite_id_108, t0.factureDetail_id AS factureDetail_id_109, t110.id AS id_111, t110.reference AS reference_112, t110.type AS type_113, t110.result AS result_114, t110.errors AS errors_115, t110.message AS message_116, t110.created_datetime AS created_datetime_117, t110.integrationModule_id AS integrationModule_id_118, t110.offre_id AS offre_id_119, t0.offreStatus_id AS offreStatus_id_120, t0.identiteBeneficiaire_id AS identiteBeneficiaire_id_121, t0.identiteInstallateur_id AS identiteInstallateur_id_122, t0.operation_id AS operation_id_123, t0.particulierUser_id AS particulierUser_id_124, t0.qualificationRecord_id AS qualificationRecord_id_125, t0.sousTraitant_id AS sousTraitant_id_126, t0.program_id AS program_id_127, t0.programCommercial_id AS programCommercial_id_128, t0.programManager_id AS programManager_id_129, t0.signatureAuto_id AS signatureAuto_id_130, t0.wasteCenter_id AS wasteCenter_id_131, t0.waste_id AS waste_id_132, t0.programAuto_id AS programAuto_id_133, t0.justificatif_id AS justificatif_id_134, t0.cappingRule_id AS cappingRule_id_135, t136.id AS id_137, t136.mprUuid AS mprUuid_138, t136.mprReference AS mprReference_139, t136.paymentDate AS paymentDate_140, t136.invoiceReference AS invoiceReference_141, t136.invoiceDate AS invoiceDate_142, t136.amount AS amount_143, t136.archive AS archive_144, t136.step AS step_145, t136.offreProjet_id AS offreProjet_id_146, t136.batchBankTransfer_id AS batchBankTransfer_id_147, t136.installateur_id AS installateur_id_148, t136.particulierUser_id AS particulierUser_id_149, t150.id AS id_151, t150.numero AS numero_152, t150.dateRealisation AS dateRealisation_153, t150.dateFinValidite AS dateFinValidite_154, t150.etiquetteBilan AS etiquetteBilan_155, t150.createdAt AS createdAt_156, t150.updatedAt AS updatedAt_157, t150.typeJustificatif AS typeJustificatif_158, t150.projet_id AS projet_id_159, t150.offreProjet_id AS offreProjet_id_160, t0.projectOwner_id AS projectOwner_id_161, t0.project_bundle_id AS project_bundle_id_162, t0.estate_id AS estate_id_163, t164.id AS id_165, t164.`value` AS value_166, t164.offreProjet_id AS offreProjet_id_167, t164.operation_id AS operation_id_168, t164.oblige_id AS oblige_id_169 FROM OffreProjet t0 LEFT JOIN OffreProjetValidation t96 ON t96.offre_id = t0.id LEFT JOIN `Lead` t110 ON t110.offre_id = t0.id LEFT JOIN PaymentMpr t136 ON t136.offreProjet_id = t0.id LEFT JOIN JustificatifPerformanceEnergetique t150 ON t150.offreProjet_id = t0.id LEFT JOIN Recensement t164 ON t164.offreProjet_id = t0.id WHERE t0.token = ? LIMIT 1 Parameters: [`"EfPdapGhtYgzhTWpsAnumX4v3diCIUTI69RPFekXvlM"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.type AS type_2, t0.pricingType AS pricingType_3, t0.finalisationRequested AS finalisationRequested_4, t0.finalisationRequestDate AS finalisationRequestDate_5, t0.cofracSatisfyDate AS cofracSatisfyDate_6, t0.reference AS reference_7, t0.data AS data_8, t0.cofracData AS cofracData_9, t0.cofracEngineDocumentId AS cofracEngineDocumentId_10, t0.ip AS ip_11, t0.offre_auto_date AS offre_auto_date_12, t0.created_datetime AS created_datetime_13, t0.updated_datetime AS updated_datetime_14, t0.tel AS tel_15, t0.codepostal AS codepostal_16, t0.adresse AS adresse_17, t0.adresse_complement AS adresse_complement_18, t0.ville AS ville_19, t0.delai_souhaite AS delai_souhaite_20, t0.accept_recevoir_offre AS accept_recevoir_offre_21, t0.accept_recommandation AS accept_recommandation_22, t0.acceptLeadPromo AS acceptLeadPromo_23, t0.offre_cumac AS offre_cumac_24, t0.offre_cumac_client AS offre_cumac_client_25, t0.offre_cumac_precarite AS offre_cumac_precarite_26, t0.offre_cumac_client_precarite AS offre_cumac_client_precarite_27, t0.cumac AS cumac_28, t0.cumac_AFT AS cumac_AFT_29, t0.total_prime AS total_prime_30, t0.total_prime_AFT AS total_prime_AFT_31, t0.prime_pro AS prime_pro_32, t0.prime_pro_aft AS prime_pro_aft_33, t0.prime_client AS prime_client_34, t0.prime_client_aft AS prime_client_aft_35, t0.cumac_moyenne AS cumac_moyenne_36, t0.taux_actualise AS taux_actualise_37, t0.taux_accumule AS taux_accumule_38, t0.date_debut_chantier AS date_debut_chantier_39, t0.date_demande_offre AS date_demande_offre_40, t0.date_fin_chantier AS date_fin_chantier_41, t0.etat AS etat_42, t0.status AS status_43, t0.date_offre AS date_offre_44, t0.notification_date_chantier AS notification_date_chantier_45, t0.date_retour_conv AS date_retour_conv_46, t0.date_validation_conv AS date_validation_conv_47, t0.date_chantier_renseigne AS date_chantier_renseigne_48, t0.date_paiement AS date_paiement_49, t0.date_all_doc_valid AS date_all_doc_valid_50, t0.date_fin_chantier_repousse AS date_fin_chantier_repousse_51, t0.date_envoi_questionnaire AS date_envoi_questionnaire_52, t0.date_edition_questionnaire AS date_edition_questionnaire_53, t0.date_validation_final AS date_validation_final_54, t0.date_annulation AS date_annulation_55, t0.no_click_email_date_chantier AS no_click_email_date_chantier_56, t0.token AS token_57, t0.auto_installation AS auto_installation_58, t0.siret AS siret_59, t0.cancelReason AS cancelReason_60, t0.dateCommande AS dateCommande_61, t0.siteTravaux AS siteTravaux_62, t0.incitation AS incitation_63, t0.qualificationRecordDate AS qualificationRecordDate_64, t0.serviceType AS serviceType_65, t0.debutChantier AS debutChantier_66, t0.finChantier AS finChantier_67, t0.initiateCDP AS initiateCDP_68, t0.cdp AS cdp_69, t0.date_last_envoi_convention AS date_last_envoi_convention_70, t0.programStep AS programStep_71, t0.devisRestAPayer AS devisRestAPayer_72, t0.pricingMandatClassique AS pricingMandatClassique_73, t0.pricingMandatPreca AS pricingMandatPreca_74, t0.isCOFRAC AS isCOFRAC_75, t0.applicationFeesPrice AS applicationFeesPrice_76, t0.attributes AS attributes_77, t0.exclusive AS exclusive_78, t0.engineDocumentId AS engineDocumentId_79, t0.adresseTravaux AS adresseTravaux_80, t0.adresseTravauxCommentaire AS adresseTravauxCommentaire_81, t0.batchOffreProjet_id AS batchOffreProjet_id_82, t0.entrepriseUser_id AS entrepriseUser_id_83, t0.installateurUser_id AS installateurUser_id_84, t0.beUser_id AS beUser_id_85, t0.entrepriseUserContact_id AS entrepriseUserContact_id_86, t0.particulierUserContact_id AS particulierUserContact_id_87, t0.signataireEntreprise_id AS signataireEntreprise_id_88, t0.signataireInstallateur_id AS signataireInstallateur_id_89, t0.installateurUserContact_id AS installateurUserContact_id_90, t0.projet_id AS projet_id_91, t0.precariteCas2_id AS precariteCas2_id_92, t0.creditNoteContract_id AS creditNoteContract_id_93, t0.precarite_id AS precarite_id_94, t0.state_id AS state_id_95, t96.id AS id_97, t96.created_datetime AS created_datetime_98, t96.convention AS convention_99, t96.aft AS aft_100, t96.facture AS facture_101, t96.beneficiaire AS beneficiaire_102, t96.installateur AS installateur_103, t96.doc_obligatoire AS doc_obligatoire_104, t96.coherence_dossier AS coherence_dossier_105, t96.offre_id AS offre_id_106, t0.oblige_id AS oblige_id_107, t0.secteurActivite_id AS secteurActivite_id_108, t0.factureDetail_id AS factureDetail_id_109, t110.id AS id_111, t110.reference AS reference_112, t110.type AS type_113, t110.result AS result_114, t110.errors AS errors_115, t110.message AS message_116, t110.created_datetime AS created_datetime_117, t110.integrationModule_id AS integrationModule_id_118, t110.offre_id AS offre_id_119, t0.offreStatus_id AS offreStatus_id_120, t0.identiteBeneficiaire_id AS identiteBeneficiaire_id_121, t0.identiteInstallateur_id AS identiteInstallateur_id_122, t0.operation_id AS operation_id_123, t0.particulierUser_id AS particulierUser_id_124, t0.qualificationRecord_id AS qualificationRecord_id_125, t0.sousTraitant_id AS sousTraitant_id_126, t0.program_id AS program_id_127, t0.programCommercial_id AS programCommercial_id_128, t0.programManager_id AS programManager_id_129, t0.signatureAuto_id AS signatureAuto_id_130, t0.wasteCenter_id AS wasteCenter_id_131, t0.waste_id AS waste_id_132, t0.programAuto_id AS programAuto_id_133, t0.justificatif_id AS justificatif_id_134, t0.cappingRule_id AS cappingRule_id_135, t136.id AS id_137, t136.mprUuid AS mprUuid_138, t136.mprReference AS mprReference_139, t136.paymentDate AS paymentDate_140, t136.invoiceReference AS invoiceReference_141, t136.invoiceDate AS invoiceDate_142, t136.amount AS amount_143, t136.archive AS archive_144, t136.step AS step_145, t136.offreProjet_id AS offreProjet_id_146, t136.batchBankTransfer_id AS batchBankTransfer_id_147, t136.installateur_id AS installateur_id_148, t136.particulierUser_id AS particulierUser_id_149, t150.id AS id_151, t150.numero AS numero_152, t150.dateRealisation AS dateRealisation_153, t150.dateFinValidite AS dateFinValidite_154, t150.etiquetteBilan AS etiquetteBilan_155, t150.createdAt AS createdAt_156, t150.updatedAt AS updatedAt_157, t150.typeJustificatif AS typeJustificatif_158, t150.projet_id AS projet_id_159, t150.offreProjet_id AS offreProjet_id_160, t0.projectOwner_id AS projectOwner_id_161, t0.project_bundle_id AS project_bundle_id_162, t0.estate_id AS estate_id_163, t164.id AS id_165, t164.`value` AS value_166, t164.offreProjet_id AS offreProjet_id_167, t164.operation_id AS operation_id_168, t164.oblige_id AS oblige_id_169 FROM OffreProjet t0 LEFT JOIN OffreProjetValidation t96 ON t96.offre_id = t0.id LEFT JOIN `Lead` t110 ON t110.offre_id = t0.id LEFT JOIN PaymentMpr t136 ON t136.offreProjet_id = t0.id LEFT JOIN JustificatifPerformanceEnergetique t150 ON t150.offreProjet_id = t0.id LEFT JOIN Recensement t164 ON t164.offreProjet_id = t0.id WHERE t0.token = ? LIMIT 1 SELECT t0.id AS id_1, t0.type AS type_2, t0.pricingType AS pricingType_3, t0.finalisationRequested AS finalisationRequested_4, t0.finalisationRequestDate AS finalisationRequestDate_5, t0.cofracSatisfyDate AS cofracSatisfyDate_6, t0.reference AS reference_7, t0.data AS data_8, t0.cofracData AS cofracData_9, t0.cofracEngineDocumentId AS cofracEngineDocumentId_10, t0.ip AS ip_11, t0.offre_auto_date AS offre_auto_date_12, t0.created_datetime AS created_datetime_13, t0.updated_datetime AS updated_datetime_14, t0.tel AS tel_15, t0.codepostal AS codepostal_16, t0.adresse AS adresse_17, t0.adresse_complement AS adresse_complement_18, t0.ville AS ville_19, t0.delai_souhaite AS delai_souhaite_20, t0.accept_recevoir_offre AS accept_recevoir_offre_21, t0.accept_recommandation AS accept_recommandation_22, t0.acceptLeadPromo AS acceptLeadPromo_23, t0.offre_cumac AS offre_cumac_24, t0.offre_cumac_client AS offre_cumac_client_25, t0.offre_cumac_precarite AS offre_cumac_precarite_26, t0.offre_cumac_client_precarite AS offre_cumac_client_precarite_27, t0.cumac AS cumac_28, t0.cumac_AFT AS cumac_AFT_29, t0.total_prime AS total_prime_30, t0.total_prime_AFT AS total_prime_AFT_31, t0.prime_pro AS prime_pro_32, t0.prime_pro_aft AS prime_pro_aft_33, t0.prime_client AS prime_client_34, t0.prime_client_aft AS prime_client_aft_35, t0.cumac_moyenne AS cumac_moyenne_36, t0.taux_actualise AS taux_actualise_37, t0.taux_accumule AS taux_accumule_38, t0.date_debut_chantier AS date_debut_chantier_39, t0.date_demande_offre AS date_demande_offre_40, t0.date_fin_chantier AS date_fin_chantier_41, t0.etat AS etat_42, t0.status AS status_43, t0.date_offre AS date_offre_44, t0.notification_date_chantier AS notification_date_chantier_45, t0.date_retour_conv AS date_retour_conv_46, t0.date_validation_conv AS date_validation_conv_47, t0.date_chantier_renseigne AS date_chantier_renseigne_48, t0.date_paiement AS date_paiement_49, t0.date_all_doc_valid AS date_all_doc_valid_50, t0.date_fin_chantier_repousse AS date_fin_chantier_repousse_51, t0.date_envoi_questionnaire AS date_envoi_questionnaire_52, t0.date_edition_questionnaire AS date_edition_questionnaire_53, t0.date_validation_final AS date_validation_final_54, t0.date_annulation AS date_annulation_55, t0.no_click_email_date_chantier AS no_click_email_date_chantier_56, t0.token AS token_57, t0.auto_installation AS auto_installation_58, t0.siret AS siret_59, t0.cancelReason AS cancelReason_60, t0.dateCommande AS dateCommande_61, t0.siteTravaux AS siteTravaux_62, t0.incitation AS incitation_63, t0.qualificationRecordDate AS qualificationRecordDate_64, t0.serviceType AS serviceType_65, t0.debutChantier AS debutChantier_66, t0.finChantier AS finChantier_67, t0.initiateCDP AS initiateCDP_68, t0.cdp AS cdp_69, t0.date_last_envoi_convention AS date_last_envoi_convention_70, t0.programStep AS programStep_71, t0.devisRestAPayer AS devisRestAPayer_72, t0.pricingMandatClassique AS pricingMandatClassique_73, t0.pricingMandatPreca AS pricingMandatPreca_74, t0.isCOFRAC AS isCOFRAC_75, t0.applicationFeesPrice AS applicationFeesPrice_76, t0.attributes AS attributes_77, t0.exclusive AS exclusive_78, t0.engineDocumentId AS engineDocumentId_79, t0.adresseTravaux AS adresseTravaux_80, t0.adresseTravauxCommentaire AS adresseTravauxCommentaire_81, t0.batchOffreProjet_id AS batchOffreProjet_id_82, t0.entrepriseUser_id AS entrepriseUser_id_83, t0.installateurUser_id AS installateurUser_id_84, t0.beUser_id AS beUser_id_85, t0.entrepriseUserContact_id AS entrepriseUserContact_id_86, t0.particulierUserContact_id AS particulierUserContact_id_87, t0.signataireEntreprise_id AS signataireEntreprise_id_88, t0.signataireInstallateur_id AS signataireInstallateur_id_89, t0.installateurUserContact_id AS installateurUserContact_id_90, t0.projet_id AS projet_id_91, t0.precariteCas2_id AS precariteCas2_id_92, t0.creditNoteContract_id AS creditNoteContract_id_93, t0.precarite_id AS precarite_id_94, t0.state_id AS state_id_95, t96.id AS id_97, t96.created_datetime AS created_datetime_98, t96.convention AS convention_99, t96.aft AS aft_100, t96.facture AS facture_101, t96.beneficiaire AS beneficiaire_102, t96.installateur AS installateur_103, t96.doc_obligatoire AS doc_obligatoire_104, t96.coherence_dossier AS coherence_dossier_105, t96.offre_id AS offre_id_106, t0.oblige_id AS oblige_id_107, t0.secteurActivite_id AS secteurActivite_id_108, t0.factureDetail_id AS factureDetail_id_109, t110.id AS id_111, t110.reference AS reference_112, t110.type AS type_113, t110.result AS result_114, t110.errors AS errors_115, t110.message AS message_116, t110.created_datetime AS created_datetime_117, t110.integrationModule_id AS integrationModule_id_118, t110.offre_id AS offre_id_119, t0.offreStatus_id AS offreStatus_id_120, t0.identiteBeneficiaire_id AS identiteBeneficiaire_id_121, t0.identiteInstallateur_id AS identiteInstallateur_id_122, t0.operation_id AS operation_id_123, t0.particulierUser_id AS particulierUser_id_124, t0.qualificationRecord_id AS qualificationRecord_id_125, t0.sousTraitant_id AS sousTraitant_id_126, t0.program_id AS program_id_127, t0.programCommercial_id AS programCommercial_id_128, t0.programManager_id AS programManager_id_129, t0.signatureAuto_id AS signatureAuto_id_130, t0.wasteCenter_id AS wasteCenter_id_131, t0.waste_id AS waste_id_132, t0.programAuto_id AS programAuto_id_133, t0.justificatif_id AS justificatif_id_134, t0.cappingRule_id AS cappingRule_id_135, t136.id AS id_137, t136.mprUuid AS mprUuid_138, t136.mprReference AS mprReference_139, t136.paymentDate AS paymentDate_140, t136.invoiceReference AS invoiceReference_141, t136.invoiceDate AS invoiceDate_142, t136.amount AS amount_143, t136.archive AS archive_144, t136.step AS step_145, t136.offreProjet_id AS offreProjet_id_146, t136.batchBankTransfer_id AS batchBankTransfer_id_147, t136.installateur_id AS installateur_id_148, t136.particulierUser_id AS particulierUser_id_149, t150.id AS id_151, t150.numero AS numero_152, t150.dateRealisation AS dateRealisation_153, t150.dateFinValidite AS dateFinValidite_154, t150.etiquetteBilan AS etiquetteBilan_155, t150.createdAt AS createdAt_156, t150.updatedAt AS updatedAt_157, t150.typeJustificatif AS typeJustificatif_158, t150.projet_id AS projet_id_159, t150.offreProjet_id AS offreProjet_id_160, t0.projectOwner_id AS projectOwner_id_161, t0.project_bundle_id AS project_bundle_id_162, t0.estate_id AS estate_id_163, t164.id AS id_165, t164.`value` AS value_166, t164.offreProjet_id AS offreProjet_id_167, t164.operation_id AS operation_id_168, t164.oblige_id AS oblige_id_169 FROM OffreProjet t0 LEFT JOIN OffreProjetValidation t96 ON t96.offre_id = t0.id LEFT JOIN `Lead` t110 ON t110.offre_id = t0.id LEFT JOIN PaymentMpr t136 ON t136.offreProjet_id = t0.id LEFT JOIN JustificatifPerformanceEnergetique t150 ON t150.offreProjet_id = t0.id LEFT JOIN Recensement t164 ON t164.offreProjet_id = t0.id WHERE t0.token = 'EfPdapGhtYgzhTWpsAnumX4v3diCIUTI69RPFekXvlM' LIMIT 1;
3	1.08 ms	SELECT t0.id AS id_1, t0.dataSimulation AS dataSimulation_2, t0.dataAH AS dataAH_3, t0.cumac AS cumac_4, t0.tauxActualise AS tauxActualise_5, t0.tauxAccumule AS tauxAccumule_6, t0.cumacMoyenne AS cumacMoyenne_7, t0.initiateCDP AS initiateCDP_8, t0.cofracData AS cofracData_9, t0.operation_id AS operation_id_10, t0.projet_id AS projet_id_11, t0.program_id AS program_id_12, t0.offreProjet_id AS offreProjet_id_13 FROM OperationRecord t0 WHERE t0.offreProjet_id = ? Parameters: [`1467`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.dataSimulation AS dataSimulation_2, t0.dataAH AS dataAH_3, t0.cumac AS cumac_4, t0.tauxActualise AS tauxActualise_5, t0.tauxAccumule AS tauxAccumule_6, t0.cumacMoyenne AS cumacMoyenne_7, t0.initiateCDP AS initiateCDP_8, t0.cofracData AS cofracData_9, t0.operation_id AS operation_id_10, t0.projet_id AS projet_id_11, t0.program_id AS program_id_12, t0.offreProjet_id AS offreProjet_id_13 FROM OperationRecord t0 WHERE t0.offreProjet_id = ? SELECT t0.id AS id_1, t0.dataSimulation AS dataSimulation_2, t0.dataAH AS dataAH_3, t0.cumac AS cumac_4, t0.tauxActualise AS tauxActualise_5, t0.tauxAccumule AS tauxAccumule_6, t0.cumacMoyenne AS cumacMoyenne_7, t0.initiateCDP AS initiateCDP_8, t0.cofracData AS cofracData_9, t0.operation_id AS operation_id_10, t0.projet_id AS projet_id_11, t0.program_id AS program_id_12, t0.offreProjet_id AS offreProjet_id_13 FROM OperationRecord t0 WHERE t0.offreProjet_id = 1467;
4	1.17 ms	SELECT t0.id AS id_1, t0.nom AS nom_2, t0.version AS version_3, t0.code AS code_4, t0.duree AS duree_5, t0.auto_installation AS auto_installation_6, t0.conditions AS conditions_7, t0.conditionsRaw AS conditionsRaw_8, t0.conditionsFormater AS conditionsFormater_9, t0.documents_requis AS documents_requis_10, t0.nombre_documents AS nombre_documents_11, t0.nombre_conditions AS nombre_conditions_12, t0.question_details_type AS question_details_type_13, t0.question_details_value AS question_details_value_14, t0.periode AS periode_15, t0.informationTechnique AS informationTechnique_16, t0.informationTechniqueRaw AS informationTechniqueRaw_17, t0.informationTechniqueFormater AS informationTechniqueFormater_18, t0.informationDocSupplementaire AS informationDocSupplementaire_19, t0.informationDocSupplementaireRaw AS informationDocSupplementaireRaw_20, t0.informationDocSupplementaireFormater AS informationDocSupplementaireFormater_21, t0.informationfacture AS informationfacture_22, t0.informationfactureRaw AS informationfactureRaw_23, t0.informationfactureFormater AS informationfactureFormater_24, t0.informationfacture2 AS informationfacture2_25, t0.informationfacture2Raw AS informationfacture2Raw_26, t0.informationfacture2Formater AS informationfacture2Formater_27, t0.nbMateriau AS nbMateriau_28, t0.materiauSubtitle AS materiauSubtitle_29, t0.materiauTitle AS materiauTitle_30, t0.textForm AS textForm_31, t0.private AS private_32, t0.campagne AS campagne_33, t0.special AS special_34, t0.abrogation_datetime AS abrogation_datetime_35, t0.date_limite_depot_referencement AS date_limite_depot_referencement_36, t0.end_zni_date AS end_zni_date_37, t0.globalConfigurationHash AS globalConfigurationHash_38, t0.zni AS zni_39, t0.cdp_eligible AS cdp_eligible_40, t0.simulateur_id AS simulateur_id_41, t0.arrete_id AS arrete_id_42, t0.certification_id AS certification_id_43, t0.qualification_id AS qualification_id_44, t0.formConfigEngine_id AS formConfigEngine_id_45 FROM Operation t0 WHERE t0.id = ? Parameters: [`1084`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nom AS nom_2, t0.version AS version_3, t0.code AS code_4, t0.duree AS duree_5, t0.auto_installation AS auto_installation_6, t0.conditions AS conditions_7, t0.conditionsRaw AS conditionsRaw_8, t0.conditionsFormater AS conditionsFormater_9, t0.documents_requis AS documents_requis_10, t0.nombre_documents AS nombre_documents_11, t0.nombre_conditions AS nombre_conditions_12, t0.question_details_type AS question_details_type_13, t0.question_details_value AS question_details_value_14, t0.periode AS periode_15, t0.informationTechnique AS informationTechnique_16, t0.informationTechniqueRaw AS informationTechniqueRaw_17, t0.informationTechniqueFormater AS informationTechniqueFormater_18, t0.informationDocSupplementaire AS informationDocSupplementaire_19, t0.informationDocSupplementaireRaw AS informationDocSupplementaireRaw_20, t0.informationDocSupplementaireFormater AS informationDocSupplementaireFormater_21, t0.informationfacture AS informationfacture_22, t0.informationfactureRaw AS informationfactureRaw_23, t0.informationfactureFormater AS informationfactureFormater_24, t0.informationfacture2 AS informationfacture2_25, t0.informationfacture2Raw AS informationfacture2Raw_26, t0.informationfacture2Formater AS informationfacture2Formater_27, t0.nbMateriau AS nbMateriau_28, t0.materiauSubtitle AS materiauSubtitle_29, t0.materiauTitle AS materiauTitle_30, t0.textForm AS textForm_31, t0.private AS private_32, t0.campagne AS campagne_33, t0.special AS special_34, t0.abrogation_datetime AS abrogation_datetime_35, t0.date_limite_depot_referencement AS date_limite_depot_referencement_36, t0.end_zni_date AS end_zni_date_37, t0.globalConfigurationHash AS globalConfigurationHash_38, t0.zni AS zni_39, t0.cdp_eligible AS cdp_eligible_40, t0.simulateur_id AS simulateur_id_41, t0.arrete_id AS arrete_id_42, t0.certification_id AS certification_id_43, t0.qualification_id AS qualification_id_44, t0.formConfigEngine_id AS formConfigEngine_id_45 FROM Operation t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.nom AS nom_2, t0.version AS version_3, t0.code AS code_4, t0.duree AS duree_5, t0.auto_installation AS auto_installation_6, t0.conditions AS conditions_7, t0.conditionsRaw AS conditionsRaw_8, t0.conditionsFormater AS conditionsFormater_9, t0.documents_requis AS documents_requis_10, t0.nombre_documents AS nombre_documents_11, t0.nombre_conditions AS nombre_conditions_12, t0.question_details_type AS question_details_type_13, t0.question_details_value AS question_details_value_14, t0.periode AS periode_15, t0.informationTechnique AS informationTechnique_16, t0.informationTechniqueRaw AS informationTechniqueRaw_17, t0.informationTechniqueFormater AS informationTechniqueFormater_18, t0.informationDocSupplementaire AS informationDocSupplementaire_19, t0.informationDocSupplementaireRaw AS informationDocSupplementaireRaw_20, t0.informationDocSupplementaireFormater AS informationDocSupplementaireFormater_21, t0.informationfacture AS informationfacture_22, t0.informationfactureRaw AS informationfactureRaw_23, t0.informationfactureFormater AS informationfactureFormater_24, t0.informationfacture2 AS informationfacture2_25, t0.informationfacture2Raw AS informationfacture2Raw_26, t0.informationfacture2Formater AS informationfacture2Formater_27, t0.nbMateriau AS nbMateriau_28, t0.materiauSubtitle AS materiauSubtitle_29, t0.materiauTitle AS materiauTitle_30, t0.textForm AS textForm_31, t0.private AS private_32, t0.campagne AS campagne_33, t0.special AS special_34, t0.abrogation_datetime AS abrogation_datetime_35, t0.date_limite_depot_referencement AS date_limite_depot_referencement_36, t0.end_zni_date AS end_zni_date_37, t0.globalConfigurationHash AS globalConfigurationHash_38, t0.zni AS zni_39, t0.cdp_eligible AS cdp_eligible_40, t0.simulateur_id AS simulateur_id_41, t0.arrete_id AS arrete_id_42, t0.certification_id AS certification_id_43, t0.qualification_id AS qualification_id_44, t0.formConfigEngine_id AS formConfigEngine_id_45 FROM Operation t0 WHERE t0.id = 1084;
5	1.59 ms	SELECT t0.id AS id_1, t0.reference AS reference_2, t0.nom AS nom_3, t0.nom_cd AS nom_cd_4, t0.cdiscount AS cdiscount_5, t0.pretty_name AS pretty_name_6, t0.status AS status_7, t0.slug AS slug_8, t0.form_lead_id AS form_lead_id_9, t0.active_operation_id AS active_operation_id_10, t11.id AS id_12, t11.nom AS nom_13, t11.version AS version_14, t11.code AS code_15, t11.duree AS duree_16, t11.auto_installation AS auto_installation_17, t11.conditions AS conditions_18, t11.conditionsRaw AS conditionsRaw_19, t11.conditionsFormater AS conditionsFormater_20, t11.documents_requis AS documents_requis_21, t11.nombre_documents AS nombre_documents_22, t11.nombre_conditions AS nombre_conditions_23, t11.question_details_type AS question_details_type_24, t11.question_details_value AS question_details_value_25, t11.periode AS periode_26, t11.informationTechnique AS informationTechnique_27, t11.informationTechniqueRaw AS informationTechniqueRaw_28, t11.informationTechniqueFormater AS informationTechniqueFormater_29, t11.informationDocSupplementaire AS informationDocSupplementaire_30, t11.informationDocSupplementaireRaw AS informationDocSupplementaireRaw_31, t11.informationDocSupplementaireFormater AS informationDocSupplementaireFormater_32, t11.informationfacture AS informationfacture_33, t11.informationfactureRaw AS informationfactureRaw_34, t11.informationfactureFormater AS informationfactureFormater_35, t11.informationfacture2 AS informationfacture2_36, t11.informationfacture2Raw AS informationfacture2Raw_37, t11.informationfacture2Formater AS informationfacture2Formater_38, t11.nbMateriau AS nbMateriau_39, t11.materiauSubtitle AS materiauSubtitle_40, t11.materiauTitle AS materiauTitle_41, t11.textForm AS textForm_42, t11.private AS private_43, t11.campagne AS campagne_44, t11.special AS special_45, t11.abrogation_datetime AS abrogation_datetime_46, t11.date_limite_depot_referencement AS date_limite_depot_referencement_47, t11.end_zni_date AS end_zni_date_48, t11.globalConfigurationHash AS globalConfigurationHash_49, t11.zni AS zni_50, t11.cdp_eligible AS cdp_eligible_51, t11.simulateur_id AS simulateur_id_52, t11.arrete_id AS arrete_id_53, t11.certification_id AS certification_id_54, t11.qualification_id AS qualification_id_55, t11.formConfigEngine_id AS formConfigEngine_id_56, t0.secteur_id AS secteur_id_57, t0.categorie_id AS categorie_id_58, t0.categorieCd_id AS categorieCd_id_59, t0.type_operation_id AS type_operation_id_60, t0.operation_specifique_id AS operation_specifique_id_61, t62.id AS id_63, t62.mode AS mode_64, t62.targetType AS targetType_65, t62.classic AS classic_66, t62.preca AS preca_67, t62.enable AS enable_68, t62.raiType AS raiType_69, t62.contractSignedElectronically AS contractSignedElectronically_70, t62.pro_signature_mandatory_outlay AS pro_signature_mandatory_outlay_71, t62.obligeTarget_id AS obligeTarget_id_72, t62.teteReseau_id AS teteReseau_id_73, t62.simulateur_id AS simulateur_id_74, t62.installateurTarget_id AS installateurTarget_id_75, t62.beTarget_id AS beTarget_id_76 FROM Simulateur t0 LEFT JOIN Operation t11 ON t0.active_operation_id = t11.id LEFT JOIN AffectationConsoneoRule t62 ON t62.simulateur_id = t0.id WHERE t0.id = ? Parameters: [`455`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.reference AS reference_2, t0.nom AS nom_3, t0.nom_cd AS nom_cd_4, t0.cdiscount AS cdiscount_5, t0.pretty_name AS pretty_name_6, t0.status AS status_7, t0.slug AS slug_8, t0.form_lead_id AS form_lead_id_9, t0.active_operation_id AS active_operation_id_10, t11.id AS id_12, t11.nom AS nom_13, t11.version AS version_14, t11.code AS code_15, t11.duree AS duree_16, t11.auto_installation AS auto_installation_17, t11.conditions AS conditions_18, t11.conditionsRaw AS conditionsRaw_19, t11.conditionsFormater AS conditionsFormater_20, t11.documents_requis AS documents_requis_21, t11.nombre_documents AS nombre_documents_22, t11.nombre_conditions AS nombre_conditions_23, t11.question_details_type AS question_details_type_24, t11.question_details_value AS question_details_value_25, t11.periode AS periode_26, t11.informationTechnique AS informationTechnique_27, t11.informationTechniqueRaw AS informationTechniqueRaw_28, t11.informationTechniqueFormater AS informationTechniqueFormater_29, t11.informationDocSupplementaire AS informationDocSupplementaire_30, t11.informationDocSupplementaireRaw AS informationDocSupplementaireRaw_31, t11.informationDocSupplementaireFormater AS informationDocSupplementaireFormater_32, t11.informationfacture AS informationfacture_33, t11.informationfactureRaw AS informationfactureRaw_34, t11.informationfactureFormater AS informationfactureFormater_35, t11.informationfacture2 AS informationfacture2_36, t11.informationfacture2Raw AS informationfacture2Raw_37, t11.informationfacture2Formater AS informationfacture2Formater_38, t11.nbMateriau AS nbMateriau_39, t11.materiauSubtitle AS materiauSubtitle_40, t11.materiauTitle AS materiauTitle_41, t11.textForm AS textForm_42, t11.private AS private_43, t11.campagne AS campagne_44, t11.special AS special_45, t11.abrogation_datetime AS abrogation_datetime_46, t11.date_limite_depot_referencement AS date_limite_depot_referencement_47, t11.end_zni_date AS end_zni_date_48, t11.globalConfigurationHash AS globalConfigurationHash_49, t11.zni AS zni_50, t11.cdp_eligible AS cdp_eligible_51, t11.simulateur_id AS simulateur_id_52, t11.arrete_id AS arrete_id_53, t11.certification_id AS certification_id_54, t11.qualification_id AS qualification_id_55, t11.formConfigEngine_id AS formConfigEngine_id_56, t0.secteur_id AS secteur_id_57, t0.categorie_id AS categorie_id_58, t0.categorieCd_id AS categorieCd_id_59, t0.type_operation_id AS type_operation_id_60, t0.operation_specifique_id AS operation_specifique_id_61, t62.id AS id_63, t62.mode AS mode_64, t62.targetType AS targetType_65, t62.classic AS classic_66, t62.preca AS preca_67, t62.enable AS enable_68, t62.raiType AS raiType_69, t62.contractSignedElectronically AS contractSignedElectronically_70, t62.pro_signature_mandatory_outlay AS pro_signature_mandatory_outlay_71, t62.obligeTarget_id AS obligeTarget_id_72, t62.teteReseau_id AS teteReseau_id_73, t62.simulateur_id AS simulateur_id_74, t62.installateurTarget_id AS installateurTarget_id_75, t62.beTarget_id AS beTarget_id_76 FROM Simulateur t0 LEFT JOIN Operation t11 ON t0.active_operation_id = t11.id LEFT JOIN AffectationConsoneoRule t62 ON t62.simulateur_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.reference AS reference_2, t0.nom AS nom_3, t0.nom_cd AS nom_cd_4, t0.cdiscount AS cdiscount_5, t0.pretty_name AS pretty_name_6, t0.status AS status_7, t0.slug AS slug_8, t0.form_lead_id AS form_lead_id_9, t0.active_operation_id AS active_operation_id_10, t11.id AS id_12, t11.nom AS nom_13, t11.version AS version_14, t11.code AS code_15, t11.duree AS duree_16, t11.auto_installation AS auto_installation_17, t11.conditions AS conditions_18, t11.conditionsRaw AS conditionsRaw_19, t11.conditionsFormater AS conditionsFormater_20, t11.documents_requis AS documents_requis_21, t11.nombre_documents AS nombre_documents_22, t11.nombre_conditions AS nombre_conditions_23, t11.question_details_type AS question_details_type_24, t11.question_details_value AS question_details_value_25, t11.periode AS periode_26, t11.informationTechnique AS informationTechnique_27, t11.informationTechniqueRaw AS informationTechniqueRaw_28, t11.informationTechniqueFormater AS informationTechniqueFormater_29, t11.informationDocSupplementaire AS informationDocSupplementaire_30, t11.informationDocSupplementaireRaw AS informationDocSupplementaireRaw_31, t11.informationDocSupplementaireFormater AS informationDocSupplementaireFormater_32, t11.informationfacture AS informationfacture_33, t11.informationfactureRaw AS informationfactureRaw_34, t11.informationfactureFormater AS informationfactureFormater_35, t11.informationfacture2 AS informationfacture2_36, t11.informationfacture2Raw AS informationfacture2Raw_37, t11.informationfacture2Formater AS informationfacture2Formater_38, t11.nbMateriau AS nbMateriau_39, t11.materiauSubtitle AS materiauSubtitle_40, t11.materiauTitle AS materiauTitle_41, t11.textForm AS textForm_42, t11.private AS private_43, t11.campagne AS campagne_44, t11.special AS special_45, t11.abrogation_datetime AS abrogation_datetime_46, t11.date_limite_depot_referencement AS date_limite_depot_referencement_47, t11.end_zni_date AS end_zni_date_48, t11.globalConfigurationHash AS globalConfigurationHash_49, t11.zni AS zni_50, t11.cdp_eligible AS cdp_eligible_51, t11.simulateur_id AS simulateur_id_52, t11.arrete_id AS arrete_id_53, t11.certification_id AS certification_id_54, t11.qualification_id AS qualification_id_55, t11.formConfigEngine_id AS formConfigEngine_id_56, t0.secteur_id AS secteur_id_57, t0.categorie_id AS categorie_id_58, t0.categorieCd_id AS categorieCd_id_59, t0.type_operation_id AS type_operation_id_60, t0.operation_specifique_id AS operation_specifique_id_61, t62.id AS id_63, t62.mode AS mode_64, t62.targetType AS targetType_65, t62.classic AS classic_66, t62.preca AS preca_67, t62.enable AS enable_68, t62.raiType AS raiType_69, t62.contractSignedElectronically AS contractSignedElectronically_70, t62.pro_signature_mandatory_outlay AS pro_signature_mandatory_outlay_71, t62.obligeTarget_id AS obligeTarget_id_72, t62.teteReseau_id AS teteReseau_id_73, t62.simulateur_id AS simulateur_id_74, t62.installateurTarget_id AS installateurTarget_id_75, t62.beTarget_id AS beTarget_id_76 FROM Simulateur t0 LEFT JOIN Operation t11 ON t0.active_operation_id = t11.id LEFT JOIN AffectationConsoneoRule t62 ON t62.simulateur_id = t0.id WHERE t0.id = 455;
6	0.88 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.status AS status_4 FROM Secteur t0 WHERE t0.id = ? Parameters: [`6`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.status AS status_4 FROM Secteur t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.status AS status_4 FROM Secteur t0 WHERE t0.id = 6;
7	0.85 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.status AS status_4 FROM TypeOperation t0 WHERE t0.id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.status AS status_4 FROM TypeOperation t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.status AS status_4 FROM TypeOperation t0 WHERE t0.id = 2;
8	0.91 ms	SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.description AS description_4, t0.status AS status_5, t0.slug AS slug_6, t0.human_title AS human_title_7, t0.position AS position_8 FROM SecteurActivite t0 WHERE t0.id = ? Parameters: [`5`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.description AS description_4, t0.status AS status_5, t0.slug AS slug_6, t0.human_title AS human_title_7, t0.position AS position_8 FROM SecteurActivite t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.description AS description_4, t0.status AS status_5, t0.slug AS slug_6, t0.human_title AS human_title_7, t0.position AS position_8 FROM SecteurActivite t0 WHERE t0.id = 5;
9	2.36 ms	SELECT a0_.id AS id_0, a0_.created_datetime AS created_datetime_1, a0_.reason AS reason_2, a0_.type AS type_3, a0_.burn AS burn_4, a0_.burn_datetime AS burn_datetime_5, a0_.target_state_choice AS target_state_choice_6, a0_.batch_choice AS batch_choice_7, a0_.answer AS answer_8, a0_.offreProjet_id AS offreProjet_id_9, a0_.asker_id AS asker_id_10, a0_.target_state AS target_state_11 FROM AskUpdateStateOffreProjet a0_ WHERE a0_.offreProjet_id = ? ORDER BY a0_.created_datetime DESC LIMIT 1 Parameters: [`1467`] View formatted query View runnable query Explain query SELECT a0_.id AS id_0, a0_.created_datetime AS created_datetime_1, a0_.reason AS reason_2, a0_.type AS type_3, a0_.burn AS burn_4, a0_.burn_datetime AS burn_datetime_5, a0_.target_state_choice AS target_state_choice_6, a0_.batch_choice AS batch_choice_7, a0_.answer AS answer_8, a0_.offreProjet_id AS offreProjet_id_9, a0_.asker_id AS asker_id_10, a0_.target_state AS target_state_11 FROM AskUpdateStateOffreProjet a0_ WHERE a0_.offreProjet_id = ? ORDER BY a0_.created_datetime DESC LIMIT 1 SELECT a0_.id AS id_0, a0_.created_datetime AS created_datetime_1, a0_.reason AS reason_2, a0_.type AS type_3, a0_.burn AS burn_4, a0_.burn_datetime AS burn_datetime_5, a0_.target_state_choice AS target_state_choice_6, a0_.batch_choice AS batch_choice_7, a0_.answer AS answer_8, a0_.offreProjet_id AS offreProjet_id_9, a0_.asker_id AS asker_id_10, a0_.target_state AS target_state_11 FROM AskUpdateStateOffreProjet a0_ WHERE a0_.offreProjet_id = 1467 ORDER BY a0_.created_datetime DESC LIMIT 1;
10	5.16 ms	SELECT t0.state AS state_1, t0.prettyName AS prettyName_2, t0.prettyNameIsolvendeur AS prettyNameIsolvendeur_3, t0.prettyNameFront AS prettyNameFront_4, t0.nextStepBe AS nextStepBe_5, t0.nextStepBeneficiaire AS nextStepBeneficiaire_6, t0.ahPrettyName AS ahPrettyName_7, t0.preActif AS preActif_8, t0.actif AS actif_9, t0.validationFinal AS validationFinal_10, t0.postEditionAh AS postEditionAh_11, t0.postValidationFinal AS postValidationFinal_12, t0.preAh AS preAh_13, t0.preValidationFinal AS preValidationFinal_14, t0.inactif AS inactif_15, t0.uploadAvailable AS uploadAvailable_16, t0.uploadPostConvention AS uploadPostConvention_17, t0.noLinearState AS noLinearState_18, t0.EndState AS EndState_19 FROM OffreProjetState t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.state AS state_1, t0.prettyName AS prettyName_2, t0.prettyNameIsolvendeur AS prettyNameIsolvendeur_3, t0.prettyNameFront AS prettyNameFront_4, t0.nextStepBe AS nextStepBe_5, t0.nextStepBeneficiaire AS nextStepBeneficiaire_6, t0.ahPrettyName AS ahPrettyName_7, t0.preActif AS preActif_8, t0.actif AS actif_9, t0.validationFinal AS validationFinal_10, t0.postEditionAh AS postEditionAh_11, t0.postValidationFinal AS postValidationFinal_12, t0.preAh AS preAh_13, t0.preValidationFinal AS preValidationFinal_14, t0.inactif AS inactif_15, t0.uploadAvailable AS uploadAvailable_16, t0.uploadPostConvention AS uploadPostConvention_17, t0.noLinearState AS noLinearState_18, t0.EndState AS EndState_19 FROM OffreProjetState t0 SELECT t0.state AS state_1, t0.prettyName AS prettyName_2, t0.prettyNameIsolvendeur AS prettyNameIsolvendeur_3, t0.prettyNameFront AS prettyNameFront_4, t0.nextStepBe AS nextStepBe_5, t0.nextStepBeneficiaire AS nextStepBeneficiaire_6, t0.ahPrettyName AS ahPrettyName_7, t0.preActif AS preActif_8, t0.actif AS actif_9, t0.validationFinal AS validationFinal_10, t0.postEditionAh AS postEditionAh_11, t0.postValidationFinal AS postValidationFinal_12, t0.preAh AS preAh_13, t0.preValidationFinal AS preValidationFinal_14, t0.inactif AS inactif_15, t0.uploadAvailable AS uploadAvailable_16, t0.uploadPostConvention AS uploadPostConvention_17, t0.noLinearState AS noLinearState_18, t0.EndState AS EndState_19 FROM OffreProjetState t0;
11	1.69 ms	SELECT t0.id AS id_1, t0.raison AS raison_2, t0.siret AS siret_3, t0.adresse AS adresse_4, t0.adresse_complement AS adresse_complement_5, t0.codepostal AS codepostal_6, t0.ville AS ville_7, t0.website AS website_8, t0.effectif AS effectif_9, t0.status AS status_10, t0.created_datetime AS created_datetime_11, t0.updated_datetime AS updated_datetime_12, t0.signature AS signature_13, t0.logo AS logo_14, t0.formation_installateur_doc AS formation_installateur_doc_15, t0.pres_marketing_installateur AS pres_marketing_installateur_16, t0.guide_utilisation_commerciaux AS guide_utilisation_commerciaux_17, t0.guidePerformanceEnergetiqueB2b AS guidePerformanceEnergetiqueB2b_18, t0.guidePerformanceEnergetiqueB2c AS guidePerformanceEnergetiqueB2c_19, t0.cgu AS cgu_20, t0.partenariatContract AS partenariatContract_21, t0.tel_beneficiaire_B2C AS tel_beneficiaire_B2C_22, t0.tel_beneficiaire_B2B AS tel_beneficiaire_B2B_23, t0.tel_installateur AS tel_installateur_24, t0.tel_support_intern AS tel_support_intern_25, t0.fax_beneficiaire AS fax_beneficiaire_26, t0.fax_installateur AS fax_installateur_27, t0.email_beneficiaire AS email_beneficiaire_28, t0.email_installateur AS email_installateur_29, t0.is_consoneo AS is_consoneo_30, t0.slug AS slug_31, t0.alias AS alias_32, t0.conventionElectronique AS conventionElectronique_33, t0.aftElectronique AS aftElectronique_34, t0.contratInstallateur AS contratInstallateur_35, t0.modeProBeneficiaireInscription AS modeProBeneficiaireInscription_36, t0.modeByPassSuperviseur AS modeByPassSuperviseur_37, t0.`lead` AS lead_38, t0.`leadUrl` AS leadUrl_39, t0.`leadLogin` AS leadLogin_40, t0.`leadPassword` AS leadPassword_41, t0.relanceConventionClientUn AS relanceConventionClientUn_42, t0.relanceConventionClientDeux AS relanceConventionClientDeux_43, t0.alertConventionClient AS alertConventionClient_44, t0.relanceConventionInstallateurUn AS relanceConventionInstallateurUn_45, t0.relanceConventionInstallateurDeux AS relanceConventionInstallateurDeux_46, t0.alertConventionInstallateur AS alertConventionInstallateur_47, t0.conventionFin AS conventionFin_48, t0.questionnaireAftRelanceUn AS questionnaireAftRelanceUn_49, t0.questionnaireAftRelanceDeux AS questionnaireAftRelanceDeux_50, t0.alertQuestionnaireAFT AS alertQuestionnaireAFT_51, t0.questionnaireAftFin AS questionnaireAftFin_52, t0.relanceAftFacture AS relanceAftFacture_53, t0.alertAftFacture AS alertAftFacture_54, t0.aftFactureFin AS aftFactureFin_55, t0.mentionCnil AS mentionCnil_56, t0.serviceType AS serviceType_57, t0.precariteMode AS precariteMode_58, t0.precariteModeProgram AS precariteModeProgram_59, t0.blocked AS blocked_60, t0.blockedSimulation AS blockedSimulation_61, t0.resiliation AS resiliation_62, t0.archivageAuto AS archivageAuto_63, t0.travauxPostDevis AS travauxPostDevis_64, t0.emailFacturationPro AS emailFacturationPro_65, t0.mandatoryInstallateurGenericContract AS mandatoryInstallateurGenericContract_66, t0.hiddenEmail AS hiddenEmail_67, t0.certificallCompanyId AS certificallCompanyId_68, t0.visibilityCommercials AS visibilityCommercials_69, t0.mandat AS mandat_70, t0.pricingMandatClassique AS pricingMandatClassique_71, t0.pricingMandatPreca AS pricingMandatPreca_72, t0.pricingPrimeMaximumMandatClassique AS pricingPrimeMaximumMandatClassique_73, t0.pricingPrimeMaximumMandatPreca AS pricingPrimeMaximumMandatPreca_74, t0.originauxAdresse AS originauxAdresse_75, t0.originauxAdresseComplement AS originauxAdresseComplement_76, t0.originauxCodepostal AS originauxCodepostal_77, t0.originauxVille AS originauxVille_78, t0.eligible AS eligible_79, t0.satisfactionSurvey AS satisfactionSurvey_80, t0.surveyConfiguration AS surveyConfiguration_81, t0.autoPayment AS autoPayment_82, t0.isAnnexeDechetQuestion AS isAnnexeDechetQuestion_83, t0.aiEnabled AS aiEnabled_84, t0.isSignatureAutoAhEnabled AS isSignatureAutoAhEnabled_85, t0.isSignatureAutoOtherDocumentsEnabled AS isSignatureAutoOtherDocumentsEnabled_86, t0.emailVersion AS emailVersion_87, t0.validateBackwards AS validateBackwards_88, t0.displayTelConsoneo AS displayTelConsoneo_89, t0.allowedUniverSign AS allowedUniverSign_90, t0.allowedApplicationFees AS allowedApplicationFees_91, t0.displayApplicationFees AS displayApplicationFees_92, t0.programAutoAllowed AS programAutoAllowed_93, t0.mpr AS mpr_94, t0.isRibActivated AS isRibActivated_95, t0.canonicalTeteReseau_id AS canonicalTeteReseau_id_96, t0.oblige_id AS oblige_id_97, t98.id AS id_99, t98.raison AS raison_100, t98.email AS email_101, t98.tel AS tel_102, t98.site_web AS site_web_103, t98.adresse AS adresse_104, t98.cp AS cp_105, t98.ville AS ville_106, t98.oblige_id AS oblige_id_107, t108.id AS id_109, t108.gender AS gender_110, t108.firstName AS firstName_111, t108.name AS name_112, t108.raison AS raison_113, t108.email AS email_114, t108.tel AS tel_115, t108.address AS address_116, t108.cp AS cp_117, t108.city AS city_118, t108.adminMandate AS adminMandate_119, t108.financialMandate AS financialMandate_120, t108.mixteMandate AS mixteMandate_121, t108.signature AS signature_122, t108.tutorial_admin AS tutorial_admin_123, t108.tutorial_mixte AS tutorial_mixte_124, t108.tutorial_financial AS tutorial_financial_125, t108.oblige_id AS oblige_id_126, t127.id AS id_128, t127.raison AS raison_129, t127.siret AS siret_130, t127.oblige_id AS oblige_id_131 FROM Oblige t0 LEFT JOIN Mediateur t98 ON t98.oblige_id = t0.id LEFT JOIN MprConfig t108 ON t108.oblige_id = t0.id LEFT JOIN Mandataire t127 ON t127.oblige_id = t0.id WHERE t0.id = ? Parameters: [`6`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.raison AS raison_2, t0.siret AS siret_3, t0.adresse AS adresse_4, t0.adresse_complement AS adresse_complement_5, t0.codepostal AS codepostal_6, t0.ville AS ville_7, t0.website AS website_8, t0.effectif AS effectif_9, t0.status AS status_10, t0.created_datetime AS created_datetime_11, t0.updated_datetime AS updated_datetime_12, t0.signature AS signature_13, t0.logo AS logo_14, t0.formation_installateur_doc AS formation_installateur_doc_15, t0.pres_marketing_installateur AS pres_marketing_installateur_16, t0.guide_utilisation_commerciaux AS guide_utilisation_commerciaux_17, t0.guidePerformanceEnergetiqueB2b AS guidePerformanceEnergetiqueB2b_18, t0.guidePerformanceEnergetiqueB2c AS guidePerformanceEnergetiqueB2c_19, t0.cgu AS cgu_20, t0.partenariatContract AS partenariatContract_21, t0.tel_beneficiaire_B2C AS tel_beneficiaire_B2C_22, t0.tel_beneficiaire_B2B AS tel_beneficiaire_B2B_23, t0.tel_installateur AS tel_installateur_24, t0.tel_support_intern AS tel_support_intern_25, t0.fax_beneficiaire AS fax_beneficiaire_26, t0.fax_installateur AS fax_installateur_27, t0.email_beneficiaire AS email_beneficiaire_28, t0.email_installateur AS email_installateur_29, t0.is_consoneo AS is_consoneo_30, t0.slug AS slug_31, t0.alias AS alias_32, t0.conventionElectronique AS conventionElectronique_33, t0.aftElectronique AS aftElectronique_34, t0.contratInstallateur AS contratInstallateur_35, t0.modeProBeneficiaireInscription AS modeProBeneficiaireInscription_36, t0.modeByPassSuperviseur AS modeByPassSuperviseur_37, t0.`lead` AS lead_38, t0.`leadUrl` AS leadUrl_39, t0.`leadLogin` AS leadLogin_40, t0.`leadPassword` AS leadPassword_41, t0.relanceConventionClientUn AS relanceConventionClientUn_42, t0.relanceConventionClientDeux AS relanceConventionClientDeux_43, t0.alertConventionClient AS alertConventionClient_44, t0.relanceConventionInstallateurUn AS relanceConventionInstallateurUn_45, t0.relanceConventionInstallateurDeux AS relanceConventionInstallateurDeux_46, t0.alertConventionInstallateur AS alertConventionInstallateur_47, t0.conventionFin AS conventionFin_48, t0.questionnaireAftRelanceUn AS questionnaireAftRelanceUn_49, t0.questionnaireAftRelanceDeux AS questionnaireAftRelanceDeux_50, t0.alertQuestionnaireAFT AS alertQuestionnaireAFT_51, t0.questionnaireAftFin AS questionnaireAftFin_52, t0.relanceAftFacture AS relanceAftFacture_53, t0.alertAftFacture AS alertAftFacture_54, t0.aftFactureFin AS aftFactureFin_55, t0.mentionCnil AS mentionCnil_56, t0.serviceType AS serviceType_57, t0.precariteMode AS precariteMode_58, t0.precariteModeProgram AS precariteModeProgram_59, t0.blocked AS blocked_60, t0.blockedSimulation AS blockedSimulation_61, t0.resiliation AS resiliation_62, t0.archivageAuto AS archivageAuto_63, t0.travauxPostDevis AS travauxPostDevis_64, t0.emailFacturationPro AS emailFacturationPro_65, t0.mandatoryInstallateurGenericContract AS mandatoryInstallateurGenericContract_66, t0.hiddenEmail AS hiddenEmail_67, t0.certificallCompanyId AS certificallCompanyId_68, t0.visibilityCommercials AS visibilityCommercials_69, t0.mandat AS mandat_70, t0.pricingMandatClassique AS pricingMandatClassique_71, t0.pricingMandatPreca AS pricingMandatPreca_72, t0.pricingPrimeMaximumMandatClassique AS pricingPrimeMaximumMandatClassique_73, t0.pricingPrimeMaximumMandatPreca AS pricingPrimeMaximumMandatPreca_74, t0.originauxAdresse AS originauxAdresse_75, t0.originauxAdresseComplement AS originauxAdresseComplement_76, t0.originauxCodepostal AS originauxCodepostal_77, t0.originauxVille AS originauxVille_78, t0.eligible AS eligible_79, t0.satisfactionSurvey AS satisfactionSurvey_80, t0.surveyConfiguration AS surveyConfiguration_81, t0.autoPayment AS autoPayment_82, t0.isAnnexeDechetQuestion AS isAnnexeDechetQuestion_83, t0.aiEnabled AS aiEnabled_84, t0.isSignatureAutoAhEnabled AS isSignatureAutoAhEnabled_85, t0.isSignatureAutoOtherDocumentsEnabled AS isSignatureAutoOtherDocumentsEnabled_86, t0.emailVersion AS emailVersion_87, t0.validateBackwards AS validateBackwards_88, t0.displayTelConsoneo AS displayTelConsoneo_89, t0.allowedUniverSign AS allowedUniverSign_90, t0.allowedApplicationFees AS allowedApplicationFees_91, t0.displayApplicationFees AS displayApplicationFees_92, t0.programAutoAllowed AS programAutoAllowed_93, t0.mpr AS mpr_94, t0.isRibActivated AS isRibActivated_95, t0.canonicalTeteReseau_id AS canonicalTeteReseau_id_96, t0.oblige_id AS oblige_id_97, t98.id AS id_99, t98.raison AS raison_100, t98.email AS email_101, t98.tel AS tel_102, t98.site_web AS site_web_103, t98.adresse AS adresse_104, t98.cp AS cp_105, t98.ville AS ville_106, t98.oblige_id AS oblige_id_107, t108.id AS id_109, t108.gender AS gender_110, t108.firstName AS firstName_111, t108.name AS name_112, t108.raison AS raison_113, t108.email AS email_114, t108.tel AS tel_115, t108.address AS address_116, t108.cp AS cp_117, t108.city AS city_118, t108.adminMandate AS adminMandate_119, t108.financialMandate AS financialMandate_120, t108.mixteMandate AS mixteMandate_121, t108.signature AS signature_122, t108.tutorial_admin AS tutorial_admin_123, t108.tutorial_mixte AS tutorial_mixte_124, t108.tutorial_financial AS tutorial_financial_125, t108.oblige_id AS oblige_id_126, t127.id AS id_128, t127.raison AS raison_129, t127.siret AS siret_130, t127.oblige_id AS oblige_id_131 FROM Oblige t0 LEFT JOIN Mediateur t98 ON t98.oblige_id = t0.id LEFT JOIN MprConfig t108 ON t108.oblige_id = t0.id LEFT JOIN Mandataire t127 ON t127.oblige_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.raison AS raison_2, t0.siret AS siret_3, t0.adresse AS adresse_4, t0.adresse_complement AS adresse_complement_5, t0.codepostal AS codepostal_6, t0.ville AS ville_7, t0.website AS website_8, t0.effectif AS effectif_9, t0.status AS status_10, t0.created_datetime AS created_datetime_11, t0.updated_datetime AS updated_datetime_12, t0.signature AS signature_13, t0.logo AS logo_14, t0.formation_installateur_doc AS formation_installateur_doc_15, t0.pres_marketing_installateur AS pres_marketing_installateur_16, t0.guide_utilisation_commerciaux AS guide_utilisation_commerciaux_17, t0.guidePerformanceEnergetiqueB2b AS guidePerformanceEnergetiqueB2b_18, t0.guidePerformanceEnergetiqueB2c AS guidePerformanceEnergetiqueB2c_19, t0.cgu AS cgu_20, t0.partenariatContract AS partenariatContract_21, t0.tel_beneficiaire_B2C AS tel_beneficiaire_B2C_22, t0.tel_beneficiaire_B2B AS tel_beneficiaire_B2B_23, t0.tel_installateur AS tel_installateur_24, t0.tel_support_intern AS tel_support_intern_25, t0.fax_beneficiaire AS fax_beneficiaire_26, t0.fax_installateur AS fax_installateur_27, t0.email_beneficiaire AS email_beneficiaire_28, t0.email_installateur AS email_installateur_29, t0.is_consoneo AS is_consoneo_30, t0.slug AS slug_31, t0.alias AS alias_32, t0.conventionElectronique AS conventionElectronique_33, t0.aftElectronique AS aftElectronique_34, t0.contratInstallateur AS contratInstallateur_35, t0.modeProBeneficiaireInscription AS modeProBeneficiaireInscription_36, t0.modeByPassSuperviseur AS modeByPassSuperviseur_37, t0.`lead` AS lead_38, t0.`leadUrl` AS leadUrl_39, t0.`leadLogin` AS leadLogin_40, t0.`leadPassword` AS leadPassword_41, t0.relanceConventionClientUn AS relanceConventionClientUn_42, t0.relanceConventionClientDeux AS relanceConventionClientDeux_43, t0.alertConventionClient AS alertConventionClient_44, t0.relanceConventionInstallateurUn AS relanceConventionInstallateurUn_45, t0.relanceConventionInstallateurDeux AS relanceConventionInstallateurDeux_46, t0.alertConventionInstallateur AS alertConventionInstallateur_47, t0.conventionFin AS conventionFin_48, t0.questionnaireAftRelanceUn AS questionnaireAftRelanceUn_49, t0.questionnaireAftRelanceDeux AS questionnaireAftRelanceDeux_50, t0.alertQuestionnaireAFT AS alertQuestionnaireAFT_51, t0.questionnaireAftFin AS questionnaireAftFin_52, t0.relanceAftFacture AS relanceAftFacture_53, t0.alertAftFacture AS alertAftFacture_54, t0.aftFactureFin AS aftFactureFin_55, t0.mentionCnil AS mentionCnil_56, t0.serviceType AS serviceType_57, t0.precariteMode AS precariteMode_58, t0.precariteModeProgram AS precariteModeProgram_59, t0.blocked AS blocked_60, t0.blockedSimulation AS blockedSimulation_61, t0.resiliation AS resiliation_62, t0.archivageAuto AS archivageAuto_63, t0.travauxPostDevis AS travauxPostDevis_64, t0.emailFacturationPro AS emailFacturationPro_65, t0.mandatoryInstallateurGenericContract AS mandatoryInstallateurGenericContract_66, t0.hiddenEmail AS hiddenEmail_67, t0.certificallCompanyId AS certificallCompanyId_68, t0.visibilityCommercials AS visibilityCommercials_69, t0.mandat AS mandat_70, t0.pricingMandatClassique AS pricingMandatClassique_71, t0.pricingMandatPreca AS pricingMandatPreca_72, t0.pricingPrimeMaximumMandatClassique AS pricingPrimeMaximumMandatClassique_73, t0.pricingPrimeMaximumMandatPreca AS pricingPrimeMaximumMandatPreca_74, t0.originauxAdresse AS originauxAdresse_75, t0.originauxAdresseComplement AS originauxAdresseComplement_76, t0.originauxCodepostal AS originauxCodepostal_77, t0.originauxVille AS originauxVille_78, t0.eligible AS eligible_79, t0.satisfactionSurvey AS satisfactionSurvey_80, t0.surveyConfiguration AS surveyConfiguration_81, t0.autoPayment AS autoPayment_82, t0.isAnnexeDechetQuestion AS isAnnexeDechetQuestion_83, t0.aiEnabled AS aiEnabled_84, t0.isSignatureAutoAhEnabled AS isSignatureAutoAhEnabled_85, t0.isSignatureAutoOtherDocumentsEnabled AS isSignatureAutoOtherDocumentsEnabled_86, t0.emailVersion AS emailVersion_87, t0.validateBackwards AS validateBackwards_88, t0.displayTelConsoneo AS displayTelConsoneo_89, t0.allowedUniverSign AS allowedUniverSign_90, t0.allowedApplicationFees AS allowedApplicationFees_91, t0.displayApplicationFees AS displayApplicationFees_92, t0.programAutoAllowed AS programAutoAllowed_93, t0.mpr AS mpr_94, t0.isRibActivated AS isRibActivated_95, t0.canonicalTeteReseau_id AS canonicalTeteReseau_id_96, t0.oblige_id AS oblige_id_97, t98.id AS id_99, t98.raison AS raison_100, t98.email AS email_101, t98.tel AS tel_102, t98.site_web AS site_web_103, t98.adresse AS adresse_104, t98.cp AS cp_105, t98.ville AS ville_106, t98.oblige_id AS oblige_id_107, t108.id AS id_109, t108.gender AS gender_110, t108.firstName AS firstName_111, t108.name AS name_112, t108.raison AS raison_113, t108.email AS email_114, t108.tel AS tel_115, t108.address AS address_116, t108.cp AS cp_117, t108.city AS city_118, t108.adminMandate AS adminMandate_119, t108.financialMandate AS financialMandate_120, t108.mixteMandate AS mixteMandate_121, t108.signature AS signature_122, t108.tutorial_admin AS tutorial_admin_123, t108.tutorial_mixte AS tutorial_mixte_124, t108.tutorial_financial AS tutorial_financial_125, t108.oblige_id AS oblige_id_126, t127.id AS id_128, t127.raison AS raison_129, t127.siret AS siret_130, t127.oblige_id AS oblige_id_131 FROM Oblige t0 LEFT JOIN Mediateur t98 ON t98.oblige_id = t0.id LEFT JOIN MprConfig t108 ON t108.oblige_id = t0.id LEFT JOIN Mandataire t127 ON t127.oblige_id = t0.id WHERE t0.id = 6;
12	0.98 ms	SELECT t0.id AS id_1, t0.email AS email_2, t0.enabled AS enabled_3, t0.salt AS salt_4, t0.password AS password_5, t0.last_login AS last_login_6, t0.confirmation_token AS confirmation_token_7, t0.password_requested_at AS password_requested_at_8, t0.roles AS roles_9, t0.username AS username_10, t0.nom AS nom_11, t0.prenom AS prenom_12, t0.fonction AS fonction_13, t0.tel AS tel_14, t0.mobile AS mobile_15, t0.activation AS activation_16, t0.createdAt AS createdAt_17, t0.updatedAt AS updatedAt_18, t0.optin AS optin_19, t0.dateActivation AS dateActivation_20, t0.emailValidatedDateTime AS emailValidatedDateTime_21, t0.emailCreatedDateTime AS emailCreatedDateTime_22, t0.mobileCreatedDatetime AS mobileCreatedDatetime_23, t0.sendEmail AS sendEmail_24, t0.scope AS scope_25, t0.isArchived AS isArchived_26, t0.import AS import_27, t0.neoSpaceEnabled AS neoSpaceEnabled_28, t0.email_canonical AS email_canonical_29, t0.username_canonical AS username_canonical_30, t0.oblige_id AS oblige_id_31 FROM ObligeUser t0 WHERE t0.id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.email AS email_2, t0.enabled AS enabled_3, t0.salt AS salt_4, t0.password AS password_5, t0.last_login AS last_login_6, t0.confirmation_token AS confirmation_token_7, t0.password_requested_at AS password_requested_at_8, t0.roles AS roles_9, t0.username AS username_10, t0.nom AS nom_11, t0.prenom AS prenom_12, t0.fonction AS fonction_13, t0.tel AS tel_14, t0.mobile AS mobile_15, t0.activation AS activation_16, t0.createdAt AS createdAt_17, t0.updatedAt AS updatedAt_18, t0.optin AS optin_19, t0.dateActivation AS dateActivation_20, t0.emailValidatedDateTime AS emailValidatedDateTime_21, t0.emailCreatedDateTime AS emailCreatedDateTime_22, t0.mobileCreatedDatetime AS mobileCreatedDatetime_23, t0.sendEmail AS sendEmail_24, t0.scope AS scope_25, t0.isArchived AS isArchived_26, t0.import AS import_27, t0.neoSpaceEnabled AS neoSpaceEnabled_28, t0.email_canonical AS email_canonical_29, t0.username_canonical AS username_canonical_30, t0.oblige_id AS oblige_id_31 FROM ObligeUser t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.email AS email_2, t0.enabled AS enabled_3, t0.salt AS salt_4, t0.password AS password_5, t0.last_login AS last_login_6, t0.confirmation_token AS confirmation_token_7, t0.password_requested_at AS password_requested_at_8, t0.roles AS roles_9, t0.username AS username_10, t0.nom AS nom_11, t0.prenom AS prenom_12, t0.fonction AS fonction_13, t0.tel AS tel_14, t0.mobile AS mobile_15, t0.activation AS activation_16, t0.createdAt AS createdAt_17, t0.updatedAt AS updatedAt_18, t0.optin AS optin_19, t0.dateActivation AS dateActivation_20, t0.emailValidatedDateTime AS emailValidatedDateTime_21, t0.emailCreatedDateTime AS emailCreatedDateTime_22, t0.mobileCreatedDatetime AS mobileCreatedDatetime_23, t0.sendEmail AS sendEmail_24, t0.scope AS scope_25, t0.isArchived AS isArchived_26, t0.import AS import_27, t0.neoSpaceEnabled AS neoSpaceEnabled_28, t0.email_canonical AS email_canonical_29, t0.username_canonical AS username_canonical_30, t0.oblige_id AS oblige_id_31 FROM ObligeUser t0 WHERE t0.id = 2;
13	1.77 ms	SELECT t0.id AS id_1, t0.nom AS nom_2, t0.obligeRole_id AS obligeRole_id_3, t4.id AS id_5, t4.role AS role_6, t4.title AS title_7, t4.scope AS scope_8, t4.position AS position_9, t4.definition AS definition_10, t4.cycle AS cycle_11, t4.only_consoneo_update AS only_consoneo_update_12, t0.teteReseau_id AS teteReseau_id_13 FROM RegleRole t0 LEFT JOIN ObligeRole t4 ON t0.obligeRole_id = t4.id INNER JOIN RegleRole_ObligeUser ON t0.id = RegleRole_ObligeUser.regleRoleId WHERE RegleRole_ObligeUser.userId = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nom AS nom_2, t0.obligeRole_id AS obligeRole_id_3, t4.id AS id_5, t4.role AS role_6, t4.title AS title_7, t4.scope AS scope_8, t4.position AS position_9, t4.definition AS definition_10, t4.cycle AS cycle_11, t4.only_consoneo_update AS only_consoneo_update_12, t0.teteReseau_id AS teteReseau_id_13 FROM RegleRole t0 LEFT JOIN ObligeRole t4 ON t0.obligeRole_id = t4.id INNER JOIN RegleRole_ObligeUser ON t0.id = RegleRole_ObligeUser.regleRoleId WHERE RegleRole_ObligeUser.userId = ? SELECT t0.id AS id_1, t0.nom AS nom_2, t0.obligeRole_id AS obligeRole_id_3, t4.id AS id_5, t4.role AS role_6, t4.title AS title_7, t4.scope AS scope_8, t4.position AS position_9, t4.definition AS definition_10, t4.cycle AS cycle_11, t4.only_consoneo_update AS only_consoneo_update_12, t0.teteReseau_id AS teteReseau_id_13 FROM RegleRole t0 LEFT JOIN ObligeRole t4 ON t0.obligeRole_id = t4.id INNER JOIN RegleRole_ObligeUser ON t0.id = RegleRole_ObligeUser.regleRoleId WHERE RegleRole_ObligeUser.userId = 2;
14	4.16 ms	SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3, t0.`description` AS description_4, t0.object_id AS object_id_5, t0.object_class AS object_class_6, t0.is_default AS is_default_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM Configuration t0 WHERE t0.`key` = ? AND t0.object_id = ? AND t0.object_class = ? LIMIT 1 Parameters: [`"validate_backwards" 6 "Consoneo\Bundle\UserBundle\Entity\Oblige"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3, t0.`description` AS description_4, t0.object_id AS object_id_5, t0.object_class AS object_class_6, t0.is_default AS is_default_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM Configuration t0 WHERE t0.`key` = ? AND t0.object_id = ? AND t0.object_class = ? LIMIT 1 SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3, t0.`description` AS description_4, t0.object_id AS object_id_5, t0.object_class AS object_class_6, t0.is_default AS is_default_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM Configuration t0 WHERE t0.`key` = 'validate_backwards' AND t0.object_id = 6 AND t0.object_class = 'Consoneo\\Bundle\\UserBundle\\Entity\\Oblige' LIMIT 1;
15	2.32 ms	SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3, t0.`description` AS description_4, t0.object_id AS object_id_5, t0.object_class AS object_class_6, t0.is_default AS is_default_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM Configuration t0 WHERE t0.`key` = ? AND t0.object_id = ? AND t0.object_class = ? LIMIT 1 Parameters: [`"allowed_all_operator_return" 6 "Consoneo\Bundle\UserBundle\Entity\Oblige"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3, t0.`description` AS description_4, t0.object_id AS object_id_5, t0.object_class AS object_class_6, t0.is_default AS is_default_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM Configuration t0 WHERE t0.`key` = ? AND t0.object_id = ? AND t0.object_class = ? LIMIT 1 SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3, t0.`description` AS description_4, t0.object_id AS object_id_5, t0.object_class AS object_class_6, t0.is_default AS is_default_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM Configuration t0 WHERE t0.`key` = 'allowed_all_operator_return' AND t0.object_id = 6 AND t0.object_class = 'Consoneo\\Bundle\\UserBundle\\Entity\\Oblige' LIMIT 1;
16	25.77 ms	SELECT t0.id AS id_1, t0.nom AS nom_2, t0.obligeRole_id AS obligeRole_id_3, t4.id AS id_5, t4.role AS role_6, t4.title AS title_7, t4.scope AS scope_8, t4.position AS position_9, t4.definition AS definition_10, t4.cycle AS cycle_11, t4.only_consoneo_update AS only_consoneo_update_12, t0.teteReseau_id AS teteReseau_id_13 FROM RegleRole t0 LEFT JOIN ObligeRole t4 ON t0.obligeRole_id = t4.id WHERE t0.nom = ? LIMIT 1 Parameters: [`"operator-offer-update"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nom AS nom_2, t0.obligeRole_id AS obligeRole_id_3, t4.id AS id_5, t4.role AS role_6, t4.title AS title_7, t4.scope AS scope_8, t4.position AS position_9, t4.definition AS definition_10, t4.cycle AS cycle_11, t4.only_consoneo_update AS only_consoneo_update_12, t0.teteReseau_id AS teteReseau_id_13 FROM RegleRole t0 LEFT JOIN ObligeRole t4 ON t0.obligeRole_id = t4.id WHERE t0.nom = ? LIMIT 1 SELECT t0.id AS id_1, t0.nom AS nom_2, t0.obligeRole_id AS obligeRole_id_3, t4.id AS id_5, t4.role AS role_6, t4.title AS title_7, t4.scope AS scope_8, t4.position AS position_9, t4.definition AS definition_10, t4.cycle AS cycle_11, t4.only_consoneo_update AS only_consoneo_update_12, t0.teteReseau_id AS teteReseau_id_13 FROM RegleRole t0 LEFT JOIN ObligeRole t4 ON t0.obligeRole_id = t4.id WHERE t0.nom = 'operator-offer-update' LIMIT 1;
17	1.19 ms	SELECT t0.id AS id_1, t0.nom AS nom_2, t0.obligeRole_id AS obligeRole_id_3, t4.id AS id_5, t4.role AS role_6, t4.title AS title_7, t4.scope AS scope_8, t4.position AS position_9, t4.definition AS definition_10, t4.cycle AS cycle_11, t4.only_consoneo_update AS only_consoneo_update_12, t0.teteReseau_id AS teteReseau_id_13 FROM RegleRole t0 LEFT JOIN ObligeRole t4 ON t0.obligeRole_id = t4.id INNER JOIN RegleRole_ObligeUser ON t0.id = RegleRole_ObligeUser.regleRoleId WHERE RegleRole_ObligeUser.userId = ? Parameters: [`44`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nom AS nom_2, t0.obligeRole_id AS obligeRole_id_3, t4.id AS id_5, t4.role AS role_6, t4.title AS title_7, t4.scope AS scope_8, t4.position AS position_9, t4.definition AS definition_10, t4.cycle AS cycle_11, t4.only_consoneo_update AS only_consoneo_update_12, t0.teteReseau_id AS teteReseau_id_13 FROM RegleRole t0 LEFT JOIN ObligeRole t4 ON t0.obligeRole_id = t4.id INNER JOIN RegleRole_ObligeUser ON t0.id = RegleRole_ObligeUser.regleRoleId WHERE RegleRole_ObligeUser.userId = ? SELECT t0.id AS id_1, t0.nom AS nom_2, t0.obligeRole_id AS obligeRole_id_3, t4.id AS id_5, t4.role AS role_6, t4.title AS title_7, t4.scope AS scope_8, t4.position AS position_9, t4.definition AS definition_10, t4.cycle AS cycle_11, t4.only_consoneo_update AS only_consoneo_update_12, t0.teteReseau_id AS teteReseau_id_13 FROM RegleRole t0 LEFT JOIN ObligeRole t4 ON t0.obligeRole_id = t4.id INNER JOIN RegleRole_ObligeUser ON t0.id = RegleRole_ObligeUser.regleRoleId WHERE RegleRole_ObligeUser.userId = 44;
18	4.42 ms	SELECT t0.id AS id_1, t0.username_canonical AS username_canonical_2, t0.email_canonical AS email_canonical_3, t0.enabled AS enabled_4, t0.salt AS salt_5, t0.password AS password_6, t0.last_login AS last_login_7, t0.confirmation_token AS confirmation_token_8, t0.password_requested_at AS password_requested_at_9, t0.roles AS roles_10, t0.nom AS nom_11, t0.prenom AS prenom_12, t0.fonction AS fonction_13, t0.tel AS tel_14, t0.mobile AS mobile_15, t0.activation AS activation_16, t0.createdAt AS createdAt_17, t0.updatedAt AS updatedAt_18, t0.optin AS optin_19, t0.dateActivation AS dateActivation_20, t0.emailValidatedDateTime AS emailValidatedDateTime_21, t0.emailCreatedDateTime AS emailCreatedDateTime_22, t0.mobileCreatedDatetime AS mobileCreatedDatetime_23, t0.sendEmail AS sendEmail_24, t0.dateEnvoiGuide AS dateEnvoiGuide_25, t0.token AS token_26, t0.emailJustificatifPreca AS emailJustificatifPreca_27, t0.adresse AS adresse_28, t0.adresse_complement AS adresse_complement_29, t0.codepostal AS codepostal_30, t0.ville AS ville_31, t0.formPrecaResponse AS formPrecaResponse_32, t0.gender AS gender_33, t0.stampFilename AS stampFilename_34, t0.email AS email_35, t0.username AS username_36, t0.cas1_id AS cas1_id_37, t38.id AS id_39, t38.type AS type_40, t38.detail AS detail_41, t38.token AS token_42, t38.installateur_id AS installateur_id_43, t38.particulierUser_id AS particulierUser_id_44, t38.entrepriseUser_id AS entrepriseUser_id_45, t38.particulierUserContact_id AS particulierUserContact_id_46, t38.entrepriseUserContact_id AS entrepriseUserContact_id_47, t0.identite_id AS identite_id_48, t0.integrationModule_id AS integrationModule_id_49 FROM ParticulierUserContact t0 LEFT JOIN PaymentMethod t38 ON t38.particulierUserContact_id = t0.id WHERE t0.id = ? Parameters: [`268`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.username_canonical AS username_canonical_2, t0.email_canonical AS email_canonical_3, t0.enabled AS enabled_4, t0.salt AS salt_5, t0.password AS password_6, t0.last_login AS last_login_7, t0.confirmation_token AS confirmation_token_8, t0.password_requested_at AS password_requested_at_9, t0.roles AS roles_10, t0.nom AS nom_11, t0.prenom AS prenom_12, t0.fonction AS fonction_13, t0.tel AS tel_14, t0.mobile AS mobile_15, t0.activation AS activation_16, t0.createdAt AS createdAt_17, t0.updatedAt AS updatedAt_18, t0.optin AS optin_19, t0.dateActivation AS dateActivation_20, t0.emailValidatedDateTime AS emailValidatedDateTime_21, t0.emailCreatedDateTime AS emailCreatedDateTime_22, t0.mobileCreatedDatetime AS mobileCreatedDatetime_23, t0.sendEmail AS sendEmail_24, t0.dateEnvoiGuide AS dateEnvoiGuide_25, t0.token AS token_26, t0.emailJustificatifPreca AS emailJustificatifPreca_27, t0.adresse AS adresse_28, t0.adresse_complement AS adresse_complement_29, t0.codepostal AS codepostal_30, t0.ville AS ville_31, t0.formPrecaResponse AS formPrecaResponse_32, t0.gender AS gender_33, t0.stampFilename AS stampFilename_34, t0.email AS email_35, t0.username AS username_36, t0.cas1_id AS cas1_id_37, t38.id AS id_39, t38.type AS type_40, t38.detail AS detail_41, t38.token AS token_42, t38.installateur_id AS installateur_id_43, t38.particulierUser_id AS particulierUser_id_44, t38.entrepriseUser_id AS entrepriseUser_id_45, t38.particulierUserContact_id AS particulierUserContact_id_46, t38.entrepriseUserContact_id AS entrepriseUserContact_id_47, t0.identite_id AS identite_id_48, t0.integrationModule_id AS integrationModule_id_49 FROM ParticulierUserContact t0 LEFT JOIN PaymentMethod t38 ON t38.particulierUserContact_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.username_canonical AS username_canonical_2, t0.email_canonical AS email_canonical_3, t0.enabled AS enabled_4, t0.salt AS salt_5, t0.password AS password_6, t0.last_login AS last_login_7, t0.confirmation_token AS confirmation_token_8, t0.password_requested_at AS password_requested_at_9, t0.roles AS roles_10, t0.nom AS nom_11, t0.prenom AS prenom_12, t0.fonction AS fonction_13, t0.tel AS tel_14, t0.mobile AS mobile_15, t0.activation AS activation_16, t0.createdAt AS createdAt_17, t0.updatedAt AS updatedAt_18, t0.optin AS optin_19, t0.dateActivation AS dateActivation_20, t0.emailValidatedDateTime AS emailValidatedDateTime_21, t0.emailCreatedDateTime AS emailCreatedDateTime_22, t0.mobileCreatedDatetime AS mobileCreatedDatetime_23, t0.sendEmail AS sendEmail_24, t0.dateEnvoiGuide AS dateEnvoiGuide_25, t0.token AS token_26, t0.emailJustificatifPreca AS emailJustificatifPreca_27, t0.adresse AS adresse_28, t0.adresse_complement AS adresse_complement_29, t0.codepostal AS codepostal_30, t0.ville AS ville_31, t0.formPrecaResponse AS formPrecaResponse_32, t0.gender AS gender_33, t0.stampFilename AS stampFilename_34, t0.email AS email_35, t0.username AS username_36, t0.cas1_id AS cas1_id_37, t38.id AS id_39, t38.type AS type_40, t38.detail AS detail_41, t38.token AS token_42, t38.installateur_id AS installateur_id_43, t38.particulierUser_id AS particulierUser_id_44, t38.entrepriseUser_id AS entrepriseUser_id_45, t38.particulierUserContact_id AS particulierUserContact_id_46, t38.entrepriseUserContact_id AS entrepriseUserContact_id_47, t0.identite_id AS identite_id_48, t0.integrationModule_id AS integrationModule_id_49 FROM ParticulierUserContact t0 LEFT JOIN PaymentMethod t38 ON t38.particulierUserContact_id = t0.id WHERE t0.id = 268;
19	1.78 ms	SELECT t0.id AS id_1, t0.raison AS raison_2, t0.siret AS siret_3, t0.adresse AS adresse_4, t0.adresse_complement AS adresse_complement_5, t0.codepostal AS codepostal_6, t0.ville AS ville_7, t0.website AS website_8, t0.effectif AS effectif_9, t0.status AS status_10, t0.created_datetime AS created_datetime_11, t0.updated_datetime AS updated_datetime_12, t0.signature AS signature_13, t0.logo AS logo_14, t0.formation_installateur_doc AS formation_installateur_doc_15, t0.pres_marketing_installateur AS pres_marketing_installateur_16, t0.guide_utilisation_commerciaux AS guide_utilisation_commerciaux_17, t0.guidePerformanceEnergetiqueB2b AS guidePerformanceEnergetiqueB2b_18, t0.guidePerformanceEnergetiqueB2c AS guidePerformanceEnergetiqueB2c_19, t0.cgu AS cgu_20, t0.partenariatContract AS partenariatContract_21, t0.tel_beneficiaire_B2C AS tel_beneficiaire_B2C_22, t0.tel_beneficiaire_B2B AS tel_beneficiaire_B2B_23, t0.tel_installateur AS tel_installateur_24, t0.tel_support_intern AS tel_support_intern_25, t0.fax_beneficiaire AS fax_beneficiaire_26, t0.fax_installateur AS fax_installateur_27, t0.email_beneficiaire AS email_beneficiaire_28, t0.email_installateur AS email_installateur_29, t0.is_consoneo AS is_consoneo_30, t0.slug AS slug_31, t0.alias AS alias_32, t0.conventionElectronique AS conventionElectronique_33, t0.aftElectronique AS aftElectronique_34, t0.contratInstallateur AS contratInstallateur_35, t0.modeProBeneficiaireInscription AS modeProBeneficiaireInscription_36, t0.modeByPassSuperviseur AS modeByPassSuperviseur_37, t0.`lead` AS lead_38, t0.`leadUrl` AS leadUrl_39, t0.`leadLogin` AS leadLogin_40, t0.`leadPassword` AS leadPassword_41, t0.relanceConventionClientUn AS relanceConventionClientUn_42, t0.relanceConventionClientDeux AS relanceConventionClientDeux_43, t0.alertConventionClient AS alertConventionClient_44, t0.relanceConventionInstallateurUn AS relanceConventionInstallateurUn_45, t0.relanceConventionInstallateurDeux AS relanceConventionInstallateurDeux_46, t0.alertConventionInstallateur AS alertConventionInstallateur_47, t0.conventionFin AS conventionFin_48, t0.questionnaireAftRelanceUn AS questionnaireAftRelanceUn_49, t0.questionnaireAftRelanceDeux AS questionnaireAftRelanceDeux_50, t0.alertQuestionnaireAFT AS alertQuestionnaireAFT_51, t0.questionnaireAftFin AS questionnaireAftFin_52, t0.relanceAftFacture AS relanceAftFacture_53, t0.alertAftFacture AS alertAftFacture_54, t0.aftFactureFin AS aftFactureFin_55, t0.mentionCnil AS mentionCnil_56, t0.serviceType AS serviceType_57, t0.precariteMode AS precariteMode_58, t0.precariteModeProgram AS precariteModeProgram_59, t0.blocked AS blocked_60, t0.blockedSimulation AS blockedSimulation_61, t0.resiliation AS resiliation_62, t0.archivageAuto AS archivageAuto_63, t0.travauxPostDevis AS travauxPostDevis_64, t0.emailFacturationPro AS emailFacturationPro_65, t0.mandatoryInstallateurGenericContract AS mandatoryInstallateurGenericContract_66, t0.hiddenEmail AS hiddenEmail_67, t0.certificallCompanyId AS certificallCompanyId_68, t0.visibilityCommercials AS visibilityCommercials_69, t0.mandat AS mandat_70, t0.pricingMandatClassique AS pricingMandatClassique_71, t0.pricingMandatPreca AS pricingMandatPreca_72, t0.pricingPrimeMaximumMandatClassique AS pricingPrimeMaximumMandatClassique_73, t0.pricingPrimeMaximumMandatPreca AS pricingPrimeMaximumMandatPreca_74, t0.originauxAdresse AS originauxAdresse_75, t0.originauxAdresseComplement AS originauxAdresseComplement_76, t0.originauxCodepostal AS originauxCodepostal_77, t0.originauxVille AS originauxVille_78, t0.eligible AS eligible_79, t0.satisfactionSurvey AS satisfactionSurvey_80, t0.surveyConfiguration AS surveyConfiguration_81, t0.autoPayment AS autoPayment_82, t0.isAnnexeDechetQuestion AS isAnnexeDechetQuestion_83, t0.aiEnabled AS aiEnabled_84, t0.isSignatureAutoAhEnabled AS isSignatureAutoAhEnabled_85, t0.isSignatureAutoOtherDocumentsEnabled AS isSignatureAutoOtherDocumentsEnabled_86, t0.emailVersion AS emailVersion_87, t0.validateBackwards AS validateBackwards_88, t0.displayTelConsoneo AS displayTelConsoneo_89, t0.allowedUniverSign AS allowedUniverSign_90, t0.allowedApplicationFees AS allowedApplicationFees_91, t0.displayApplicationFees AS displayApplicationFees_92, t0.programAutoAllowed AS programAutoAllowed_93, t0.mpr AS mpr_94, t0.isRibActivated AS isRibActivated_95, t0.canonicalTeteReseau_id AS canonicalTeteReseau_id_96, t0.oblige_id AS oblige_id_97, t98.id AS id_99, t98.raison AS raison_100, t98.email AS email_101, t98.tel AS tel_102, t98.site_web AS site_web_103, t98.adresse AS adresse_104, t98.cp AS cp_105, t98.ville AS ville_106, t98.oblige_id AS oblige_id_107, t108.id AS id_109, t108.gender AS gender_110, t108.firstName AS firstName_111, t108.name AS name_112, t108.raison AS raison_113, t108.email AS email_114, t108.tel AS tel_115, t108.address AS address_116, t108.cp AS cp_117, t108.city AS city_118, t108.adminMandate AS adminMandate_119, t108.financialMandate AS financialMandate_120, t108.mixteMandate AS mixteMandate_121, t108.signature AS signature_122, t108.tutorial_admin AS tutorial_admin_123, t108.tutorial_mixte AS tutorial_mixte_124, t108.tutorial_financial AS tutorial_financial_125, t108.oblige_id AS oblige_id_126, t127.id AS id_128, t127.raison AS raison_129, t127.siret AS siret_130, t127.oblige_id AS oblige_id_131 FROM Oblige t0 LEFT JOIN Mediateur t98 ON t98.oblige_id = t0.id LEFT JOIN MprConfig t108 ON t108.oblige_id = t0.id LEFT JOIN Mandataire t127 ON t127.oblige_id = t0.id WHERE t0.oblige_id = ? Parameters: [`6`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.raison AS raison_2, t0.siret AS siret_3, t0.adresse AS adresse_4, t0.adresse_complement AS adresse_complement_5, t0.codepostal AS codepostal_6, t0.ville AS ville_7, t0.website AS website_8, t0.effectif AS effectif_9, t0.status AS status_10, t0.created_datetime AS created_datetime_11, t0.updated_datetime AS updated_datetime_12, t0.signature AS signature_13, t0.logo AS logo_14, t0.formation_installateur_doc AS formation_installateur_doc_15, t0.pres_marketing_installateur AS pres_marketing_installateur_16, t0.guide_utilisation_commerciaux AS guide_utilisation_commerciaux_17, t0.guidePerformanceEnergetiqueB2b AS guidePerformanceEnergetiqueB2b_18, t0.guidePerformanceEnergetiqueB2c AS guidePerformanceEnergetiqueB2c_19, t0.cgu AS cgu_20, t0.partenariatContract AS partenariatContract_21, t0.tel_beneficiaire_B2C AS tel_beneficiaire_B2C_22, t0.tel_beneficiaire_B2B AS tel_beneficiaire_B2B_23, t0.tel_installateur AS tel_installateur_24, t0.tel_support_intern AS tel_support_intern_25, t0.fax_beneficiaire AS fax_beneficiaire_26, t0.fax_installateur AS fax_installateur_27, t0.email_beneficiaire AS email_beneficiaire_28, t0.email_installateur AS email_installateur_29, t0.is_consoneo AS is_consoneo_30, t0.slug AS slug_31, t0.alias AS alias_32, t0.conventionElectronique AS conventionElectronique_33, t0.aftElectronique AS aftElectronique_34, t0.contratInstallateur AS contratInstallateur_35, t0.modeProBeneficiaireInscription AS modeProBeneficiaireInscription_36, t0.modeByPassSuperviseur AS modeByPassSuperviseur_37, t0.`lead` AS lead_38, t0.`leadUrl` AS leadUrl_39, t0.`leadLogin` AS leadLogin_40, t0.`leadPassword` AS leadPassword_41, t0.relanceConventionClientUn AS relanceConventionClientUn_42, t0.relanceConventionClientDeux AS relanceConventionClientDeux_43, t0.alertConventionClient AS alertConventionClient_44, t0.relanceConventionInstallateurUn AS relanceConventionInstallateurUn_45, t0.relanceConventionInstallateurDeux AS relanceConventionInstallateurDeux_46, t0.alertConventionInstallateur AS alertConventionInstallateur_47, t0.conventionFin AS conventionFin_48, t0.questionnaireAftRelanceUn AS questionnaireAftRelanceUn_49, t0.questionnaireAftRelanceDeux AS questionnaireAftRelanceDeux_50, t0.alertQuestionnaireAFT AS alertQuestionnaireAFT_51, t0.questionnaireAftFin AS questionnaireAftFin_52, t0.relanceAftFacture AS relanceAftFacture_53, t0.alertAftFacture AS alertAftFacture_54, t0.aftFactureFin AS aftFactureFin_55, t0.mentionCnil AS mentionCnil_56, t0.serviceType AS serviceType_57, t0.precariteMode AS precariteMode_58, t0.precariteModeProgram AS precariteModeProgram_59, t0.blocked AS blocked_60, t0.blockedSimulation AS blockedSimulation_61, t0.resiliation AS resiliation_62, t0.archivageAuto AS archivageAuto_63, t0.travauxPostDevis AS travauxPostDevis_64, t0.emailFacturationPro AS emailFacturationPro_65, t0.mandatoryInstallateurGenericContract AS mandatoryInstallateurGenericContract_66, t0.hiddenEmail AS hiddenEmail_67, t0.certificallCompanyId AS certificallCompanyId_68, t0.visibilityCommercials AS visibilityCommercials_69, t0.mandat AS mandat_70, t0.pricingMandatClassique AS pricingMandatClassique_71, t0.pricingMandatPreca AS pricingMandatPreca_72, t0.pricingPrimeMaximumMandatClassique AS pricingPrimeMaximumMandatClassique_73, t0.pricingPrimeMaximumMandatPreca AS pricingPrimeMaximumMandatPreca_74, t0.originauxAdresse AS originauxAdresse_75, t0.originauxAdresseComplement AS originauxAdresseComplement_76, t0.originauxCodepostal AS originauxCodepostal_77, t0.originauxVille AS originauxVille_78, t0.eligible AS eligible_79, t0.satisfactionSurvey AS satisfactionSurvey_80, t0.surveyConfiguration AS surveyConfiguration_81, t0.autoPayment AS autoPayment_82, t0.isAnnexeDechetQuestion AS isAnnexeDechetQuestion_83, t0.aiEnabled AS aiEnabled_84, t0.isSignatureAutoAhEnabled AS isSignatureAutoAhEnabled_85, t0.isSignatureAutoOtherDocumentsEnabled AS isSignatureAutoOtherDocumentsEnabled_86, t0.emailVersion AS emailVersion_87, t0.validateBackwards AS validateBackwards_88, t0.displayTelConsoneo AS displayTelConsoneo_89, t0.allowedUniverSign AS allowedUniverSign_90, t0.allowedApplicationFees AS allowedApplicationFees_91, t0.displayApplicationFees AS displayApplicationFees_92, t0.programAutoAllowed AS programAutoAllowed_93, t0.mpr AS mpr_94, t0.isRibActivated AS isRibActivated_95, t0.canonicalTeteReseau_id AS canonicalTeteReseau_id_96, t0.oblige_id AS oblige_id_97, t98.id AS id_99, t98.raison AS raison_100, t98.email AS email_101, t98.tel AS tel_102, t98.site_web AS site_web_103, t98.adresse AS adresse_104, t98.cp AS cp_105, t98.ville AS ville_106, t98.oblige_id AS oblige_id_107, t108.id AS id_109, t108.gender AS gender_110, t108.firstName AS firstName_111, t108.name AS name_112, t108.raison AS raison_113, t108.email AS email_114, t108.tel AS tel_115, t108.address AS address_116, t108.cp AS cp_117, t108.city AS city_118, t108.adminMandate AS adminMandate_119, t108.financialMandate AS financialMandate_120, t108.mixteMandate AS mixteMandate_121, t108.signature AS signature_122, t108.tutorial_admin AS tutorial_admin_123, t108.tutorial_mixte AS tutorial_mixte_124, t108.tutorial_financial AS tutorial_financial_125, t108.oblige_id AS oblige_id_126, t127.id AS id_128, t127.raison AS raison_129, t127.siret AS siret_130, t127.oblige_id AS oblige_id_131 FROM Oblige t0 LEFT JOIN Mediateur t98 ON t98.oblige_id = t0.id LEFT JOIN MprConfig t108 ON t108.oblige_id = t0.id LEFT JOIN Mandataire t127 ON t127.oblige_id = t0.id WHERE t0.oblige_id = ? SELECT t0.id AS id_1, t0.raison AS raison_2, t0.siret AS siret_3, t0.adresse AS adresse_4, t0.adresse_complement AS adresse_complement_5, t0.codepostal AS codepostal_6, t0.ville AS ville_7, t0.website AS website_8, t0.effectif AS effectif_9, t0.status AS status_10, t0.created_datetime AS created_datetime_11, t0.updated_datetime AS updated_datetime_12, t0.signature AS signature_13, t0.logo AS logo_14, t0.formation_installateur_doc AS formation_installateur_doc_15, t0.pres_marketing_installateur AS pres_marketing_installateur_16, t0.guide_utilisation_commerciaux AS guide_utilisation_commerciaux_17, t0.guidePerformanceEnergetiqueB2b AS guidePerformanceEnergetiqueB2b_18, t0.guidePerformanceEnergetiqueB2c AS guidePerformanceEnergetiqueB2c_19, t0.cgu AS cgu_20, t0.partenariatContract AS partenariatContract_21, t0.tel_beneficiaire_B2C AS tel_beneficiaire_B2C_22, t0.tel_beneficiaire_B2B AS tel_beneficiaire_B2B_23, t0.tel_installateur AS tel_installateur_24, t0.tel_support_intern AS tel_support_intern_25, t0.fax_beneficiaire AS fax_beneficiaire_26, t0.fax_installateur AS fax_installateur_27, t0.email_beneficiaire AS email_beneficiaire_28, t0.email_installateur AS email_installateur_29, t0.is_consoneo AS is_consoneo_30, t0.slug AS slug_31, t0.alias AS alias_32, t0.conventionElectronique AS conventionElectronique_33, t0.aftElectronique AS aftElectronique_34, t0.contratInstallateur AS contratInstallateur_35, t0.modeProBeneficiaireInscription AS modeProBeneficiaireInscription_36, t0.modeByPassSuperviseur AS modeByPassSuperviseur_37, t0.`lead` AS lead_38, t0.`leadUrl` AS leadUrl_39, t0.`leadLogin` AS leadLogin_40, t0.`leadPassword` AS leadPassword_41, t0.relanceConventionClientUn AS relanceConventionClientUn_42, t0.relanceConventionClientDeux AS relanceConventionClientDeux_43, t0.alertConventionClient AS alertConventionClient_44, t0.relanceConventionInstallateurUn AS relanceConventionInstallateurUn_45, t0.relanceConventionInstallateurDeux AS relanceConventionInstallateurDeux_46, t0.alertConventionInstallateur AS alertConventionInstallateur_47, t0.conventionFin AS conventionFin_48, t0.questionnaireAftRelanceUn AS questionnaireAftRelanceUn_49, t0.questionnaireAftRelanceDeux AS questionnaireAftRelanceDeux_50, t0.alertQuestionnaireAFT AS alertQuestionnaireAFT_51, t0.questionnaireAftFin AS questionnaireAftFin_52, t0.relanceAftFacture AS relanceAftFacture_53, t0.alertAftFacture AS alertAftFacture_54, t0.aftFactureFin AS aftFactureFin_55, t0.mentionCnil AS mentionCnil_56, t0.serviceType AS serviceType_57, t0.precariteMode AS precariteMode_58, t0.precariteModeProgram AS precariteModeProgram_59, t0.blocked AS blocked_60, t0.blockedSimulation AS blockedSimulation_61, t0.resiliation AS resiliation_62, t0.archivageAuto AS archivageAuto_63, t0.travauxPostDevis AS travauxPostDevis_64, t0.emailFacturationPro AS emailFacturationPro_65, t0.mandatoryInstallateurGenericContract AS mandatoryInstallateurGenericContract_66, t0.hiddenEmail AS hiddenEmail_67, t0.certificallCompanyId AS certificallCompanyId_68, t0.visibilityCommercials AS visibilityCommercials_69, t0.mandat AS mandat_70, t0.pricingMandatClassique AS pricingMandatClassique_71, t0.pricingMandatPreca AS pricingMandatPreca_72, t0.pricingPrimeMaximumMandatClassique AS pricingPrimeMaximumMandatClassique_73, t0.pricingPrimeMaximumMandatPreca AS pricingPrimeMaximumMandatPreca_74, t0.originauxAdresse AS originauxAdresse_75, t0.originauxAdresseComplement AS originauxAdresseComplement_76, t0.originauxCodepostal AS originauxCodepostal_77, t0.originauxVille AS originauxVille_78, t0.eligible AS eligible_79, t0.satisfactionSurvey AS satisfactionSurvey_80, t0.surveyConfiguration AS surveyConfiguration_81, t0.autoPayment AS autoPayment_82, t0.isAnnexeDechetQuestion AS isAnnexeDechetQuestion_83, t0.aiEnabled AS aiEnabled_84, t0.isSignatureAutoAhEnabled AS isSignatureAutoAhEnabled_85, t0.isSignatureAutoOtherDocumentsEnabled AS isSignatureAutoOtherDocumentsEnabled_86, t0.emailVersion AS emailVersion_87, t0.validateBackwards AS validateBackwards_88, t0.displayTelConsoneo AS displayTelConsoneo_89, t0.allowedUniverSign AS allowedUniverSign_90, t0.allowedApplicationFees AS allowedApplicationFees_91, t0.displayApplicationFees AS displayApplicationFees_92, t0.programAutoAllowed AS programAutoAllowed_93, t0.mpr AS mpr_94, t0.isRibActivated AS isRibActivated_95, t0.canonicalTeteReseau_id AS canonicalTeteReseau_id_96, t0.oblige_id AS oblige_id_97, t98.id AS id_99, t98.raison AS raison_100, t98.email AS email_101, t98.tel AS tel_102, t98.site_web AS site_web_103, t98.adresse AS adresse_104, t98.cp AS cp_105, t98.ville AS ville_106, t98.oblige_id AS oblige_id_107, t108.id AS id_109, t108.gender AS gender_110, t108.firstName AS firstName_111, t108.name AS name_112, t108.raison AS raison_113, t108.email AS email_114, t108.tel AS tel_115, t108.address AS address_116, t108.cp AS cp_117, t108.city AS city_118, t108.adminMandate AS adminMandate_119, t108.financialMandate AS financialMandate_120, t108.mixteMandate AS mixteMandate_121, t108.signature AS signature_122, t108.tutorial_admin AS tutorial_admin_123, t108.tutorial_mixte AS tutorial_mixte_124, t108.tutorial_financial AS tutorial_financial_125, t108.oblige_id AS oblige_id_126, t127.id AS id_128, t127.raison AS raison_129, t127.siret AS siret_130, t127.oblige_id AS oblige_id_131 FROM Oblige t0 LEFT JOIN Mediateur t98 ON t98.oblige_id = t0.id LEFT JOIN MprConfig t108 ON t108.oblige_id = t0.id LEFT JOIN Mandataire t127 ON t127.oblige_id = t0.id WHERE t0.oblige_id = 6;
20	27.70 ms	SELECT o0_.id AS id_0, o0_.type AS type_1, o0_.pricingType AS pricingType_2, o0_.finalisationRequested AS finalisationRequested_3, o0_.finalisationRequestDate AS finalisationRequestDate_4, o0_.cofracSatisfyDate AS cofracSatisfyDate_5, o0_.reference AS reference_6, o0_.data AS data_7, o0_.cofracData AS cofracData_8, o0_.cofracEngineDocumentId AS cofracEngineDocumentId_9, o0_.ip AS ip_10, o0_.offre_auto_date AS offre_auto_date_11, o0_.created_datetime AS created_datetime_12, o0_.updated_datetime AS updated_datetime_13, o0_.tel AS tel_14, o0_.codepostal AS codepostal_15, o0_.adresse AS adresse_16, o0_.adresse_complement AS adresse_complement_17, o0_.ville AS ville_18, o0_.delai_souhaite AS delai_souhaite_19, o0_.accept_recevoir_offre AS accept_recevoir_offre_20, o0_.accept_recommandation AS accept_recommandation_21, o0_.acceptLeadPromo AS acceptLeadPromo_22, o0_.offre_cumac AS offre_cumac_23, o0_.offre_cumac_client AS offre_cumac_client_24, o0_.offre_cumac_precarite AS offre_cumac_precarite_25, o0_.offre_cumac_client_precarite AS offre_cumac_client_precarite_26, o0_.cumac AS cumac_27, o0_.cumac_AFT AS cumac_AFT_28, o0_.total_prime AS total_prime_29, o0_.total_prime_AFT AS total_prime_AFT_30, o0_.prime_pro AS prime_pro_31, o0_.prime_pro_aft AS prime_pro_aft_32, o0_.prime_client AS prime_client_33, o0_.prime_client_aft AS prime_client_aft_34, o0_.cumac_moyenne AS cumac_moyenne_35, o0_.taux_actualise AS taux_actualise_36, o0_.taux_accumule AS taux_accumule_37, o0_.date_debut_chantier AS date_debut_chantier_38, o0_.date_demande_offre AS date_demande_offre_39, o0_.date_fin_chantier AS date_fin_chantier_40, o0_.etat AS etat_41, o0_.status AS status_42, o0_.date_offre AS date_offre_43, o0_.notification_date_chantier AS notification_date_chantier_44, o0_.date_retour_conv AS date_retour_conv_45, o0_.date_validation_conv AS date_validation_conv_46, o0_.date_chantier_renseigne AS date_chantier_renseigne_47, o0_.date_paiement AS date_paiement_48, o0_.date_all_doc_valid AS date_all_doc_valid_49, o0_.date_fin_chantier_repousse AS date_fin_chantier_repousse_50, o0_.date_envoi_questionnaire AS date_envoi_questionnaire_51, o0_.date_edition_questionnaire AS date_edition_questionnaire_52, o0_.date_validation_final AS date_validation_final_53, o0_.date_annulation AS date_annulation_54, o0_.no_click_email_date_chantier AS no_click_email_date_chantier_55, o0_.token AS token_56, o0_.auto_installation AS auto_installation_57, o0_.siret AS siret_58, o0_.cancelReason AS cancelReason_59, o0_.dateCommande AS dateCommande_60, o0_.siteTravaux AS siteTravaux_61, o0_.incitation AS incitation_62, o0_.qualificationRecordDate AS qualificationRecordDate_63, o0_.serviceType AS serviceType_64, o0_.debutChantier AS debutChantier_65, o0_.finChantier AS finChantier_66, o0_.initiateCDP AS initiateCDP_67, o0_.cdp AS cdp_68, o0_.date_last_envoi_convention AS date_last_envoi_convention_69, o0_.programStep AS programStep_70, o0_.devisRestAPayer AS devisRestAPayer_71, o0_.pricingMandatClassique AS pricingMandatClassique_72, o0_.pricingMandatPreca AS pricingMandatPreca_73, o0_.isCOFRAC AS isCOFRAC_74, o0_.applicationFeesPrice AS applicationFeesPrice_75, o0_.attributes AS attributes_76, o0_.exclusive AS exclusive_77, o0_.engineDocumentId AS engineDocumentId_78, o0_.adresseTravaux AS adresseTravaux_79, o0_.adresseTravauxCommentaire AS adresseTravauxCommentaire_80, o0_.batchOffreProjet_id AS batchOffreProjet_id_81, o0_.entrepriseUser_id AS entrepriseUser_id_82, o0_.installateurUser_id AS installateurUser_id_83, o0_.beUser_id AS beUser_id_84, o0_.entrepriseUserContact_id AS entrepriseUserContact_id_85, o0_.particulierUserContact_id AS particulierUserContact_id_86, o0_.signataireEntreprise_id AS signataireEntreprise_id_87, o0_.signataireInstallateur_id AS signataireInstallateur_id_88, o0_.installateurUserContact_id AS installateurUserContact_id_89, o0_.projet_id AS projet_id_90, o0_.precariteCas2_id AS precariteCas2_id_91, o0_.creditNoteContract_id AS creditNoteContract_id_92, o0_.precarite_id AS precarite_id_93, o0_.state_id AS state_id_94, o0_.oblige_id AS oblige_id_95, o0_.secteurActivite_id AS secteurActivite_id_96, o0_.factureDetail_id AS factureDetail_id_97, o0_.offreStatus_id AS offreStatus_id_98, o0_.identiteBeneficiaire_id AS identiteBeneficiaire_id_99, o0_.identiteInstallateur_id AS identiteInstallateur_id_100, o0_.operation_id AS operation_id_101, o0_.particulierUser_id AS particulierUser_id_102, o0_.qualificationRecord_id AS qualificationRecord_id_103, o0_.sousTraitant_id AS sousTraitant_id_104, o0_.program_id AS program_id_105, o0_.programCommercial_id AS programCommercial_id_106, o0_.programManager_id AS programManager_id_107, o0_.signatureAuto_id AS signatureAuto_id_108, o0_.wasteCenter_id AS wasteCenter_id_109, o0_.waste_id AS waste_id_110, o0_.programAuto_id AS programAuto_id_111, o0_.justificatif_id AS justificatif_id_112, o0_.cappingRule_id AS cappingRule_id_113, o0_.projectOwner_id AS projectOwner_id_114, o0_.project_bundle_id AS project_bundle_id_115, o0_.estate_id AS estate_id_116 FROM OffreProjet o0_ LEFT JOIN EntrepriseUserContact e1_ ON o0_.entrepriseUserContact_id = e1_.id LEFT JOIN ParticulierUserContact p2_ ON o0_.particulierUserContact_id = p2_.id LEFT JOIN EntrepriseUser e3_ ON o0_.entrepriseUser_id = e3_.id LEFT JOIN ParticulierUser p4_ ON o0_.particulierUser_id = p4_.id LEFT JOIN OperationRecord o5_ ON o0_.id = o5_.offreProjet_id LEFT JOIN Operation o6_ ON o5_.operation_id = o6_.id LEFT JOIN Operation o7_ ON o0_.operation_id = o7_.id WHERE o0_.oblige_id IN (?, ?, ?) AND o0_.id <> ? AND (e1_.username = ? OR p2_.username = ? OR e3_.username = ? OR p4_.username = ?) AND (o7_.nom LIKE ? OR o6_.nom LIKE ?) AND o0_.etat NOT IN (?, ?, ?, ?, ?, ?) Parameters: [`6 21 23 1467 "[email protected]" "[email protected]" "[email protected]" "[email protected]" "TRA-EQ-117%" "TRA-EQ-117%" "demande_refuser" "dossier_aft_ineligible" "dossier_supprime_auto" "dossier_supprime_manuel_back" "dossier_supprime_manuel_front" "dossier_invalide_auto"`] View formatted query View runnable query Explain query SELECT o0_.id AS id_0, o0_.type AS type_1, o0_.pricingType AS pricingType_2, o0_.finalisationRequested AS finalisationRequested_3, o0_.finalisationRequestDate AS finalisationRequestDate_4, o0_.cofracSatisfyDate AS cofracSatisfyDate_5, o0_.reference AS reference_6, o0_.data AS data_7, o0_.cofracData AS cofracData_8, o0_.cofracEngineDocumentId AS cofracEngineDocumentId_9, o0_.ip AS ip_10, o0_.offre_auto_date AS offre_auto_date_11, o0_.created_datetime AS created_datetime_12, o0_.updated_datetime AS updated_datetime_13, o0_.tel AS tel_14, o0_.codepostal AS codepostal_15, o0_.adresse AS adresse_16, o0_.adresse_complement AS adresse_complement_17, o0_.ville AS ville_18, o0_.delai_souhaite AS delai_souhaite_19, o0_.accept_recevoir_offre AS accept_recevoir_offre_20, o0_.accept_recommandation AS accept_recommandation_21, o0_.acceptLeadPromo AS acceptLeadPromo_22, o0_.offre_cumac AS offre_cumac_23, o0_.offre_cumac_client AS offre_cumac_client_24, o0_.offre_cumac_precarite AS offre_cumac_precarite_25, o0_.offre_cumac_client_precarite AS offre_cumac_client_precarite_26, o0_.cumac AS cumac_27, o0_.cumac_AFT AS cumac_AFT_28, o0_.total_prime AS total_prime_29, o0_.total_prime_AFT AS total_prime_AFT_30, o0_.prime_pro AS prime_pro_31, o0_.prime_pro_aft AS prime_pro_aft_32, o0_.prime_client AS prime_client_33, o0_.prime_client_aft AS prime_client_aft_34, o0_.cumac_moyenne AS cumac_moyenne_35, o0_.taux_actualise AS taux_actualise_36, o0_.taux_accumule AS taux_accumule_37, o0_.date_debut_chantier AS date_debut_chantier_38, o0_.date_demande_offre AS date_demande_offre_39, o0_.date_fin_chantier AS date_fin_chantier_40, o0_.etat AS etat_41, o0_.status AS status_42, o0_.date_offre AS date_offre_43, o0_.notification_date_chantier AS notification_date_chantier_44, o0_.date_retour_conv AS date_retour_conv_45, o0_.date_validation_conv AS date_validation_conv_46, o0_.date_chantier_renseigne AS date_chantier_renseigne_47, o0_.date_paiement AS date_paiement_48, o0_.date_all_doc_valid AS date_all_doc_valid_49, o0_.date_fin_chantier_repousse AS date_fin_chantier_repousse_50, o0_.date_envoi_questionnaire AS date_envoi_questionnaire_51, o0_.date_edition_questionnaire AS date_edition_questionnaire_52, o0_.date_validation_final AS date_validation_final_53, o0_.date_annulation AS date_annulation_54, o0_.no_click_email_date_chantier AS no_click_email_date_chantier_55, o0_.token AS token_56, o0_.auto_installation AS auto_installation_57, o0_.siret AS siret_58, o0_.cancelReason AS cancelReason_59, o0_.dateCommande AS dateCommande_60, o0_.siteTravaux AS siteTravaux_61, o0_.incitation AS incitation_62, o0_.qualificationRecordDate AS qualificationRecordDate_63, o0_.serviceType AS serviceType_64, o0_.debutChantier AS debutChantier_65, o0_.finChantier AS finChantier_66, o0_.initiateCDP AS initiateCDP_67, o0_.cdp AS cdp_68, o0_.date_last_envoi_convention AS date_last_envoi_convention_69, o0_.programStep AS programStep_70, o0_.devisRestAPayer AS devisRestAPayer_71, o0_.pricingMandatClassique AS pricingMandatClassique_72, o0_.pricingMandatPreca AS pricingMandatPreca_73, o0_.isCOFRAC AS isCOFRAC_74, o0_.applicationFeesPrice AS applicationFeesPrice_75, o0_.attributes AS attributes_76, o0_.exclusive AS exclusive_77, o0_.engineDocumentId AS engineDocumentId_78, o0_.adresseTravaux AS adresseTravaux_79, o0_.adresseTravauxCommentaire AS adresseTravauxCommentaire_80, o0_.batchOffreProjet_id AS batchOffreProjet_id_81, o0_.entrepriseUser_id AS entrepriseUser_id_82, o0_.installateurUser_id AS installateurUser_id_83, o0_.beUser_id AS beUser_id_84, o0_.entrepriseUserContact_id AS entrepriseUserContact_id_85, o0_.particulierUserContact_id AS particulierUserContact_id_86, o0_.signataireEntreprise_id AS signataireEntreprise_id_87, o0_.signataireInstallateur_id AS signataireInstallateur_id_88, o0_.installateurUserContact_id AS installateurUserContact_id_89, o0_.projet_id AS projet_id_90, o0_.precariteCas2_id AS precariteCas2_id_91, o0_.creditNoteContract_id AS creditNoteContract_id_92, o0_.precarite_id AS precarite_id_93, o0_.state_id AS state_id_94, o0_.oblige_id AS oblige_id_95, o0_.secteurActivite_id AS secteurActivite_id_96, o0_.factureDetail_id AS factureDetail_id_97, o0_.offreStatus_id AS offreStatus_id_98, o0_.identiteBeneficiaire_id AS identiteBeneficiaire_id_99, o0_.identiteInstallateur_id AS identiteInstallateur_id_100, o0_.operation_id AS operation_id_101, o0_.particulierUser_id AS particulierUser_id_102, o0_.qualificationRecord_id AS qualificationRecord_id_103, o0_.sousTraitant_id AS sousTraitant_id_104, o0_.program_id AS program_id_105, o0_.programCommercial_id AS programCommercial_id_106, o0_.programManager_id AS programManager_id_107, o0_.signatureAuto_id AS signatureAuto_id_108, o0_.wasteCenter_id AS wasteCenter_id_109, o0_.waste_id AS waste_id_110, o0_.programAuto_id AS programAuto_id_111, o0_.justificatif_id AS justificatif_id_112, o0_.cappingRule_id AS cappingRule_id_113, o0_.projectOwner_id AS projectOwner_id_114, o0_.project_bundle_id AS project_bundle_id_115, o0_.estate_id AS estate_id_116 FROM OffreProjet o0_ LEFT JOIN EntrepriseUserContact e1_ ON o0_.entrepriseUserContact_id = e1_.id LEFT JOIN ParticulierUserContact p2_ ON o0_.particulierUserContact_id = p2_.id LEFT JOIN EntrepriseUser e3_ ON o0_.entrepriseUser_id = e3_.id LEFT JOIN ParticulierUser p4_ ON o0_.particulierUser_id = p4_.id LEFT JOIN OperationRecord o5_ ON o0_.id = o5_.offreProjet_id LEFT JOIN Operation o6_ ON o5_.operation_id = o6_.id LEFT JOIN Operation o7_ ON o0_.operation_id = o7_.id WHERE o0_.oblige_id IN (?, ?, ?) AND o0_.id <> ? AND ( e1_.username = ? OR p2_.username = ? OR e3_.username = ? OR p4_.username = ? ) AND ( o7_.nom LIKE ? OR o6_.nom LIKE ? ) AND o0_.etat NOT IN (?, ?, ?, ?, ?, ?) SELECT o0_.id AS id_0, o0_.type AS type_1, o0_.pricingType AS pricingType_2, o0_.finalisationRequested AS finalisationRequested_3, o0_.finalisationRequestDate AS finalisationRequestDate_4, o0_.cofracSatisfyDate AS cofracSatisfyDate_5, o0_.reference AS reference_6, o0_.data AS data_7, o0_.cofracData AS cofracData_8, o0_.cofracEngineDocumentId AS cofracEngineDocumentId_9, o0_.ip AS ip_10, o0_.offre_auto_date AS offre_auto_date_11, o0_.created_datetime AS created_datetime_12, o0_.updated_datetime AS updated_datetime_13, o0_.tel AS tel_14, o0_.codepostal AS codepostal_15, o0_.adresse AS adresse_16, o0_.adresse_complement AS adresse_complement_17, o0_.ville AS ville_18, o0_.delai_souhaite AS delai_souhaite_19, o0_.accept_recevoir_offre AS accept_recevoir_offre_20, o0_.accept_recommandation AS accept_recommandation_21, o0_.acceptLeadPromo AS acceptLeadPromo_22, o0_.offre_cumac AS offre_cumac_23, o0_.offre_cumac_client AS offre_cumac_client_24, o0_.offre_cumac_precarite AS offre_cumac_precarite_25, o0_.offre_cumac_client_precarite AS offre_cumac_client_precarite_26, o0_.cumac AS cumac_27, o0_.cumac_AFT AS cumac_AFT_28, o0_.total_prime AS total_prime_29, o0_.total_prime_AFT AS total_prime_AFT_30, o0_.prime_pro AS prime_pro_31, o0_.prime_pro_aft AS prime_pro_aft_32, o0_.prime_client AS prime_client_33, o0_.prime_client_aft AS prime_client_aft_34, o0_.cumac_moyenne AS cumac_moyenne_35, o0_.taux_actualise AS taux_actualise_36, o0_.taux_accumule AS taux_accumule_37, o0_.date_debut_chantier AS date_debut_chantier_38, o0_.date_demande_offre AS date_demande_offre_39, o0_.date_fin_chantier AS date_fin_chantier_40, o0_.etat AS etat_41, o0_.status AS status_42, o0_.date_offre AS date_offre_43, o0_.notification_date_chantier AS notification_date_chantier_44, o0_.date_retour_conv AS date_retour_conv_45, o0_.date_validation_conv AS date_validation_conv_46, o0_.date_chantier_renseigne AS date_chantier_renseigne_47, o0_.date_paiement AS date_paiement_48, o0_.date_all_doc_valid AS date_all_doc_valid_49, o0_.date_fin_chantier_repousse AS date_fin_chantier_repousse_50, o0_.date_envoi_questionnaire AS date_envoi_questionnaire_51, o0_.date_edition_questionnaire AS date_edition_questionnaire_52, o0_.date_validation_final AS date_validation_final_53, o0_.date_annulation AS date_annulation_54, o0_.no_click_email_date_chantier AS no_click_email_date_chantier_55, o0_.token AS token_56, o0_.auto_installation AS auto_installation_57, o0_.siret AS siret_58, o0_.cancelReason AS cancelReason_59, o0_.dateCommande AS dateCommande_60, o0_.siteTravaux AS siteTravaux_61, o0_.incitation AS incitation_62, o0_.qualificationRecordDate AS qualificationRecordDate_63, o0_.serviceType AS serviceType_64, o0_.debutChantier AS debutChantier_65, o0_.finChantier AS finChantier_66, o0_.initiateCDP AS initiateCDP_67, o0_.cdp AS cdp_68, o0_.date_last_envoi_convention AS date_last_envoi_convention_69, o0_.programStep AS programStep_70, o0_.devisRestAPayer AS devisRestAPayer_71, o0_.pricingMandatClassique AS pricingMandatClassique_72, o0_.pricingMandatPreca AS pricingMandatPreca_73, o0_.isCOFRAC AS isCOFRAC_74, o0_.applicationFeesPrice AS applicationFeesPrice_75, o0_.attributes AS attributes_76, o0_.exclusive AS exclusive_77, o0_.engineDocumentId AS engineDocumentId_78, o0_.adresseTravaux AS adresseTravaux_79, o0_.adresseTravauxCommentaire AS adresseTravauxCommentaire_80, o0_.batchOffreProjet_id AS batchOffreProjet_id_81, o0_.entrepriseUser_id AS entrepriseUser_id_82, o0_.installateurUser_id AS installateurUser_id_83, o0_.beUser_id AS beUser_id_84, o0_.entrepriseUserContact_id AS entrepriseUserContact_id_85, o0_.particulierUserContact_id AS particulierUserContact_id_86, o0_.signataireEntreprise_id AS signataireEntreprise_id_87, o0_.signataireInstallateur_id AS signataireInstallateur_id_88, o0_.installateurUserContact_id AS installateurUserContact_id_89, o0_.projet_id AS projet_id_90, o0_.precariteCas2_id AS precariteCas2_id_91, o0_.creditNoteContract_id AS creditNoteContract_id_92, o0_.precarite_id AS precarite_id_93, o0_.state_id AS state_id_94, o0_.oblige_id AS oblige_id_95, o0_.secteurActivite_id AS secteurActivite_id_96, o0_.factureDetail_id AS factureDetail_id_97, o0_.offreStatus_id AS offreStatus_id_98, o0_.identiteBeneficiaire_id AS identiteBeneficiaire_id_99, o0_.identiteInstallateur_id AS identiteInstallateur_id_100, o0_.operation_id AS operation_id_101, o0_.particulierUser_id AS particulierUser_id_102, o0_.qualificationRecord_id AS qualificationRecord_id_103, o0_.sousTraitant_id AS sousTraitant_id_104, o0_.program_id AS program_id_105, o0_.programCommercial_id AS programCommercial_id_106, o0_.programManager_id AS programManager_id_107, o0_.signatureAuto_id AS signatureAuto_id_108, o0_.wasteCenter_id AS wasteCenter_id_109, o0_.waste_id AS waste_id_110, o0_.programAuto_id AS programAuto_id_111, o0_.justificatif_id AS justificatif_id_112, o0_.cappingRule_id AS cappingRule_id_113, o0_.projectOwner_id AS projectOwner_id_114, o0_.project_bundle_id AS project_bundle_id_115, o0_.estate_id AS estate_id_116 FROM OffreProjet o0_ LEFT JOIN EntrepriseUserContact e1_ ON o0_.entrepriseUserContact_id = e1_.id LEFT JOIN ParticulierUserContact p2_ ON o0_.particulierUserContact_id = p2_.id LEFT JOIN EntrepriseUser e3_ ON o0_.entrepriseUser_id = e3_.id LEFT JOIN ParticulierUser p4_ ON o0_.particulierUser_id = p4_.id LEFT JOIN OperationRecord o5_ ON o0_.id = o5_.offreProjet_id LEFT JOIN Operation o6_ ON o5_.operation_id = o6_.id LEFT JOIN Operation o7_ ON o0_.operation_id = o7_.id WHERE o0_.oblige_id IN (6, 21, 23) AND o0_.id <> 1467 AND (e1_.username = '[email protected]' OR p2_.username = '[email protected]' OR e3_.username = '[email protected]' OR p4_.username = '[email protected]') AND (o7_.nom LIKE 'TRA-EQ-117%' OR o6_.nom LIKE 'TRA-EQ-117%') AND o0_.etat NOT IN ('demande_refuser', 'dossier_aft_ineligible', 'dossier_supprime_auto', 'dossier_supprime_manuel_back', 'dossier_supprime_manuel_front', 'dossier_invalide_auto');

Database Connections

Name	Service
default	doctrine.dbal.default_connection
read	doctrine.dbal.read_connection
stats	doctrine.dbal.stats_connection
qrdecode	doctrine.dbal.qrdecode_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
read	doctrine.orm.read_entity_manager
stats	doctrine.orm.stats_entity_manager
qrdecode	doctrine.orm.qrdecode_entity_manager

Second Level Cache

0 Hits

0 Misses

0 Puts

Managed Entities

default entity manager

Class	Amount of managed objects
Consoneo\Bundle\UserBundle\Entity\RegleRole	39
Consoneo\Bundle\UserBundle\Entity\ObligeRole	19
Consoneo\Bundle\UserBundle\Entity\TeteReseau	6
Consoneo\Bundle\UserBundle\Entity\Oblige	4
Consoneo\Bundle\UserBundle\Entity\ObligeUser	2
Consoneo\Bundle\UserBundle\Entity\Identite	2
Consoneo\Bundle\ObligeBundle\Entity\Configuration	2
Consoneo\Bundle\ObligeBundle\Entity\OffreProjet	1
Consoneo\Bundle\UserBundle\Entity\InstallateurUser	1
Consoneo\Bundle\UserBundle\Entity\ParticulierUserContact	1
Consoneo\Bundle\ObligeBundle\Entity\Projet	1
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetState	1
Consoneo\Bundle\SimulateurBundle\Entity\SecteurActivite	1
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetStatus	1
Consoneo\Bundle\SimulateurBundle\Entity\Operation	1
Consoneo\Bundle\ObligeBundle\Entity\SignatureAuto	1
Consoneo\Bundle\UserBundle\Entity\ProjectOwner	1
Consoneo\Bundle\SimulateurBundle\Entity\Simulateur	1
Consoneo\Bundle\SimulateurBundle\Entity\Secteur	1
Consoneo\Bundle\SimulateurBundle\Entity\Categorie	1
Consoneo\Bundle\SimulateurBundle\Entity\TypeOperation	1
Consoneo\Bundle\ObligeBundle\Entity\IntegrationModule	1

read entity manager

Class	Amount of managed objects
Consoneo\Bundle\ObligeBundle\Entity\Arrete	45
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetState	27

stats entity manager

Class	Amount of managed objects

qrdecode entity manager

Class	Amount of managed objects

Entities Mapping

default entity manager

Class	Mapping errors
Consoneo\Bundle\UserBundle\Entity\ObligeUser	No errors.
Consoneo\Bundle\UserBundle\Entity\Oblige	No errors.
Consoneo\Bundle\ObligeBundle\Entity\Reminder	No errors.
Consoneo\Bundle\ObligeBundle\Entity\Comment	No errors.
Consoneo\Bundle\ObligeBundle\Entity\Document	No errors.
Consoneo\Bundle\UserBundle\Entity\TeteReseau	No errors.
Consoneo\Bundle\WorkflowBundle\Entity\AlertRecord	No errors.
Consoneo\Bundle\ObligeBundle\Entity\StatRecord	No errors.
Consoneo\Bundle\UserBundle\Entity\AffectationUser	No errors.
Consoneo\Bundle\UserBundle\Entity\AffectationOffre	No errors.
Consoneo\Bundle\UserBundle\Entity\RegleRole	No errors.
Consoneo\Bundle\ObligeBundle\Entity\Campagne	No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetMonitoring	No errors.
Consoneo\Bundle\ObligeBundle\Entity\PaymentMethodOblige	No errors.
Consoneo\Bundle\ObligeBundle\Entity\ControlStepHistory	No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetAdditionalInformation	No errors.
Consoneo\Bundle\ObligeBundle\Entity\Configuration	No errors.
Consoneo\Bundle\WorkflowBundle\Entity\EmailHistory	No errors.
Consoneo\Bundle\SimulateurBundle\Entity\Operation	No errors.
Consoneo\Bundle\ObligeBundle\Entity\MoteurInfoArrete	No errors.
Consoneo\Bundle\ObligeBundle\Entity\Arrete	No errors.
Consoneo\Bundle\ObligeBundle\Entity\Contract	No errors.
Consoneo\Bundle\ObligeBundle\Entity\DocumentStatic	No errors.
Consoneo\Bundle\ObligeBundle\Entity\DocumentType	No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetDocumentObligatoire	No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjet	No errors.
Consoneo\Bundle\ObligeBundle\Entity\SampleCofracOperation	No errors.
Consoneo\Bundle\ObligeBundle\Entity\Batch	No errors.
Consoneo\Bundle\WorkflowBundle\Entity\Email	No errors.
C2eCoreBundle\Entity\Certificall\Certilink	No errors.
Consoneo\Bundle\UserBundle\Entity\InstallateurCertificallConfig	No errors.
Consoneo\Bundle\UserBundle\Entity\EntrepriseUser	No errors.
Consoneo\Bundle\UserBundle\Entity\InstallateurUser	No errors.
Consoneo\Bundle\UserBundle\Entity\BeUser	No errors.
Consoneo\Bundle\UserBundle\Entity\EntrepriseUserContact	No errors.
Consoneo\Bundle\UserBundle\Entity\ParticulierUserContact	No errors.
Consoneo\Bundle\UserBundle\Entity\SignataireEntreprise	No errors.
Consoneo\Bundle\UserBundle\Entity\SignataireInstallateur	No errors.
Consoneo\Bundle\UserBundle\Entity\InstallateurUserContact	No errors.
Consoneo\Bundle\ObligeBundle\Entity\Projet	No errors.
Consoneo\Bundle\SimulateurBundle\Entity\PrecariteCas2	No errors.
Consoneo\Bundle\ObligeBundle\Entity\Precarite	No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetState	No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetValidation	No errors.
Consoneo\Bundle\SimulateurBundle\Entity\SecteurActivite	No errors.
Consoneo\Bundle\ObligeBundle\Entity\FactureDetail	No errors.
Consoneo\Bundle\ObligeBundle\Entity\Lead	No errors.
Consoneo\Bundle\ObligeBundle\Entity\IntegrationModule	No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetStatus	No errors.
Consoneo\Bundle\UserBundle\Entity\Identite	No errors.
Consoneo\Bundle\UserBundle\Entity\ParticulierUser	No errors.
Consoneo\Bundle\UserBundle\Entity\QualificationRecord	No errors.
Consoneo\Bundle\UserBundle\Entity\SousTraitantRGE	No errors.
Consoneo\Bundle\WorkflowBundle\Entity\Program	No errors.
Consoneo\Bundle\ObligeBundle\Entity\User\Program\Commercial	No errors.
Consoneo\Bundle\ObligeBundle\Entity\User\Program\Manager	No errors.
Consoneo\Bundle\ObligeBundle\Entity\SignatureAuto	No errors.
Consoneo\Bundle\ObligeBundle\Entity\WasteCenter	No errors.
Consoneo\Bundle\ObligeBundle\Entity\Waste	No errors.
Consoneo\Bundle\WorkflowBundle\Entity\ProgramAuto	No errors.
Consoneo\Bundle\UserBundle\Entity\Precarite\Justificatif	No errors.
Consoneo\Bundle\ObligeBundle\Entity\CappingRule	No errors.
Consoneo\Bundle\ObligeBundle\Entity\PaymentMpr	No errors.
Consoneo\Bundle\ObligeBundle\Entity\BatchBankTransfer	No errors.
Consoneo\Bundle\UserBundle\Entity\Installateur	No errors.
Consoneo\Bundle\ObligeBundle\Entity\JustificatifPerformanceEnergetique	No errors.
Consoneo\Bundle\UserBundle\Entity\ProjectOwner	No errors.
C2eCoreBundle\Entity\Internal\ProjectBundle	No errors.
C2eCoreBundle\Entity\Internal\Estate	No errors.
Consoneo\Bundle\ObligeBundle\Entity\Recensement	No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetTag	No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetProduit	No errors.
Consoneo\Bundle\ObligeBundle\Entity\AskUpdateStateOffreProjet	No errors.
Consoneo\Bundle\WorkflowBundle\Entity\Sms	No errors.
Consoneo\Bundle\WorkflowBundle\Entity\Horodatage	No errors.
Consoneo\Bundle\ObligeBundle\Entity\Message	No errors.
Consoneo\Bundle\ObligeBundle\Entity\Payment	No errors.
Consoneo\Bundle\ObligeBundle\Entity\OperationRecord	No errors.
Consoneo\Bundle\ObligeBundle\Entity\Program\StepHistory	No errors.
Consoneo\Bundle\ObligeBundle\Entity\Control	No errors.
Consoneo\Bundle\WorkflowBundle\Entity\OffreProjetProgramAutoData	No errors.
Consoneo\Bundle\ObligeBundle\Entity\CofracDocument	No errors.
Consoneo\Bundle\ObligeBundle\Entity\ControlMonitoringHistory	No errors.
Consoneo\Bundle\SimulateurBundle\Entity\Simulateur	No errors.
Consoneo\Bundle\ObligeBundle\Entity\Certification	No errors.
Consoneo\Bundle\UserBundle\Entity\Qualification	No errors.
Consoneo\Bundle\FormGeneratorBundle\Form\Domain\Model\FormConfig	No errors.
Consoneo\Bundle\SimulateurBundle\Entity\OperationQuestionItem	No errors.
Consoneo\Bundle\SimulateurBundle\Entity\DataQuestion	No errors.
Consoneo\Bundle\UserBundle\Entity\DomaineTravauxRGE	No errors.
Consoneo\Bundle\UserBundle\Entity\Be	No errors.
Consoneo\Bundle\ObligeBundle\Entity\ObligeOperation	No errors.
Consoneo\Bundle\ObligeBundle\Entity\Program\Isolant	No errors.
C2eCoreBundle\Entity\Internal\ProjectBundleOperation	No errors.
C2eCoreBundle\Entity\Engine\ConstraintRule	No errors.
C2eCoreBundle\Entity\Engine\MatrixDefinition	No errors.
C2eCoreBundle\Entity\Engine\Formula	No errors.
Consoneo\Bundle\ObligeBundle\Entity\OperationDocumentConfig	No errors.
Consoneo\Bundle\SimulateurBundle\Entity\Secteur	No errors.
Consoneo\Bundle\SimulateurBundle\Entity\Categorie	No errors.
Consoneo\Bundle\SimulateurBundle\Entity\TypeOperation	No errors.
Consoneo\Bundle\SimulateurBundle\Entity\OperationSpecifique	No errors.
Consoneo\Bundle\UserBundle\Entity\AffectationConsoneoRule	No errors.
Consoneo\Bundle\UserBundle\Entity\ApplicationFees	No errors.
Consoneo\Bundle\ObligeBundle\Entity\Mediateur	No errors.
Consoneo\Bundle\ObligeBundle\Entity\MprConfig	No errors.
Consoneo\Bundle\UserBundle\Entity\Mandataire	No errors.
Consoneo\Bundle\ObligeBundle\Entity\PricingGroup	No errors.
Consoneo\Bundle\ObligeBundle\Entity\ObligeBlockedTimetable	No errors.
Consoneo\Bundle\WorkflowBundle\Entity\CoupDePouce	No errors.
Consoneo\Bundle\ObligeBundle\Entity\EmailConfigurationRecord	No errors.
Consoneo\Bundle\ObligeBundle\Entity\ConfigurationPaymentRecord	No errors.
Consoneo\Bundle\UserBundle\Entity\ObligeDocumentTypeConfig	No errors.
Consoneo\Bundle\ObligeBundle\Entity\Product\Product	No errors.
Consoneo\Bundle\ObligeBundle\Entity\PrestataireEffacement	No errors.
Consoneo\Bundle\UserBundle\Entity\ObligeRole	No errors.
Consoneo\Bundle\ObligeBundle\Entity\Alert	No errors.
Consoneo\Bundle\UserBundle\Entity\Precarite\Cas1	No errors.
Consoneo\Bundle\ObligeBundle\Entity\PaymentMethod	No errors.

read entity manager

Class	Mapping errors
Consoneo\Bundle\SimulateurBundle\Entity\ZoneClimatique	No errors.
Consoneo\Bundle\ObligeBundle\Entity\Configuration	No errors.
Consoneo\Bundle\UserBundle\Entity\Oblige	No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjet	No errors.
Consoneo\Bundle\ObligeBundle\Entity\Arrete	No errors.
Consoneo\Bundle\ObligeBundle\Entity\MoteurInfoArrete	No errors.
Consoneo\Bundle\FormGeneratorBundle\Form\Domain\Model\FormConfig	No errors.
Consoneo\Bundle\SimulateurBundle\Entity\Operation	No errors.
Consoneo\Bundle\ObligeBundle\Entity\AskUpdateStateOffreProjet	No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetState	No errors.

stats entity manager

No loaded entities.

qrdecode entity manager

Class	Mapping errors
C2eCoreBundle\Entity\DocumentQrDecode	No errors.

Symfony Profiler

GET https://admin.preprod-orion.dossier-c2e.fr/_fragment?_path=_format%3Dhtml%26_locale%3Dfr%26_controller%3DConsoneo%255CBundle%255CObligeBundle%255CController%255…

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

read entity manager

stats entity manager

qrdecode entity manager

Entities Mapping

default entity manager

read entity manager

stats entity manager

qrdecode entity manager