Symfony Profiler

Query Metrics

20 Database Queries

16 Different statements

85.50 ms Query time

0 Invalid entities

888 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.email_canonical AS email_canonical_28, t0.username_canonical AS username_canonical_29, t0.oblige_id AS oblige_id_30 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.reference AS reference_6, t0.data AS data_7, t0.cofracData AS cofracData_8, t0.ip AS ip_9, t0.offre_auto_date AS offre_auto_date_10, t0.created_datetime AS created_datetime_11, t0.updated_datetime AS updated_datetime_12, t0.tel AS tel_13, t0.codepostal AS codepostal_14, t0.adresse AS adresse_15, t0.adresse_complement AS adresse_complement_16, t0.ville AS ville_17, t0.delai_souhaite AS delai_souhaite_18, t0.accept_recevoir_offre AS accept_recevoir_offre_19, t0.accept_recommandation AS accept_recommandation_20, t0.acceptLeadPromo AS acceptLeadPromo_21, t0.offre_cumac AS offre_cumac_22, t0.offre_cumac_client AS offre_cumac_client_23, t0.offre_cumac_precarite AS offre_cumac_precarite_24, t0.offre_cumac_client_precarite AS offre_cumac_client_precarite_25, t0.cumac AS cumac_26, t0.cumac_AFT AS cumac_AFT_27, t0.total_prime AS total_prime_28, t0.total_prime_AFT AS total_prime_AFT_29, t0.prime_pro AS prime_pro_30, t0.prime_pro_aft AS prime_pro_aft_31, t0.prime_client AS prime_client_32, t0.prime_client_aft AS prime_client_aft_33, t0.cumac_moyenne AS cumac_moyenne_34, t0.taux_actualise AS taux_actualise_35, t0.taux_accumule AS taux_accumule_36, t0.date_debut_chantier AS date_debut_chantier_37, t0.date_demande_offre AS date_demande_offre_38, t0.date_fin_chantier AS date_fin_chantier_39, t0.etat AS etat_40, t0.status AS status_41, t0.date_offre AS date_offre_42, t0.notification_date_chantier AS notification_date_chantier_43, t0.date_retour_conv AS date_retour_conv_44, t0.date_validation_conv AS date_validation_conv_45, t0.date_chantier_renseigne AS date_chantier_renseigne_46, t0.date_paiement AS date_paiement_47, t0.date_all_doc_valid AS date_all_doc_valid_48, t0.date_fin_chantier_repousse AS date_fin_chantier_repousse_49, t0.date_envoi_questionnaire AS date_envoi_questionnaire_50, t0.date_edition_questionnaire AS date_edition_questionnaire_51, t0.date_validation_final AS date_validation_final_52, t0.date_annulation AS date_annulation_53, t0.no_click_email_date_chantier AS no_click_email_date_chantier_54, t0.token AS token_55, t0.auto_installation AS auto_installation_56, t0.siret AS siret_57, t0.cancelReason AS cancelReason_58, t0.dateCommande AS dateCommande_59, t0.siteTravaux AS siteTravaux_60, t0.incitation AS incitation_61, t0.qualificationRecordDate AS qualificationRecordDate_62, t0.serviceType AS serviceType_63, t0.debutChantier AS debutChantier_64, t0.finChantier AS finChantier_65, t0.initiateCDP AS initiateCDP_66, t0.cdp AS cdp_67, t0.date_last_envoi_convention AS date_last_envoi_convention_68, t0.programStep AS programStep_69, t0.devisRestAPayer AS devisRestAPayer_70, t0.pricingMandatClassique AS pricingMandatClassique_71, t0.pricingMandatPreca AS pricingMandatPreca_72, t0.isCOFRAC AS isCOFRAC_73, t0.applicationFeesPrice AS applicationFeesPrice_74, t0.attributes AS attributes_75, t0.exclusive AS exclusive_76, t0.engineDocumentId AS engineDocumentId_77, t0.batchOffreProjet_id AS batchOffreProjet_id_78, t0.entrepriseUser_id AS entrepriseUser_id_79, t0.installateurUser_id AS installateurUser_id_80, t0.beUser_id AS beUser_id_81, t0.entrepriseUserContact_id AS entrepriseUserContact_id_82, t0.particulierUserContact_id AS particulierUserContact_id_83, t0.signataireEntreprise_id AS signataireEntreprise_id_84, t0.signataireInstallateur_id AS signataireInstallateur_id_85, t0.installateurUserContact_id AS installateurUserContact_id_86, t0.projet_id AS projet_id_87, t0.precariteCas2_id AS precariteCas2_id_88, t0.precarite_id AS precarite_id_89, t0.state_id AS state_id_90, t91.id AS id_92, t91.created_datetime AS created_datetime_93, t91.convention AS convention_94, t91.aft AS aft_95, t91.facture AS facture_96, t91.beneficiaire AS beneficiaire_97, t91.installateur AS installateur_98, t91.doc_obligatoire AS doc_obligatoire_99, t91.coherence_dossier AS coherence_dossier_100, t91.offre_id AS offre_id_101, t0.oblige_id AS oblige_id_102, t0.secteurActivite_id AS secteurActivite_id_103, t0.factureDetail_id AS factureDetail_id_104, t105.id AS id_106, t105.reference AS reference_107, t105.type AS type_108, t105.result AS result_109, t105.errors AS errors_110, t105.message AS message_111, t105.created_datetime AS created_datetime_112, t105.integrationModule_id AS integrationModule_id_113, t105.offre_id AS offre_id_114, t0.offreStatus_id AS offreStatus_id_115, t0.identiteBeneficiaire_id AS identiteBeneficiaire_id_116, t0.identiteInstallateur_id AS identiteInstallateur_id_117, t0.operation_id AS operation_id_118, t0.particulierUser_id AS particulierUser_id_119, t0.qualificationRecord_id AS qualificationRecord_id_120, t0.sousTraitant_id AS sousTraitant_id_121, t0.program_id AS program_id_122, t0.programCommercial_id AS programCommercial_id_123, t0.programManager_id AS programManager_id_124, t0.signatureAuto_id AS signatureAuto_id_125, t0.wasteCenter_id AS wasteCenter_id_126, t0.waste_id AS waste_id_127, t0.programAuto_id AS programAuto_id_128, t0.justificatif_id AS justificatif_id_129, t0.cappingRule_id AS cappingRule_id_130, t131.id AS id_132, t131.mprUuid AS mprUuid_133, t131.mprReference AS mprReference_134, t131.paymentDate AS paymentDate_135, t131.invoiceReference AS invoiceReference_136, t131.invoiceDate AS invoiceDate_137, t131.amount AS amount_138, t131.archive AS archive_139, t131.step AS step_140, t131.offreProjet_id AS offreProjet_id_141, t131.batchBankTransfer_id AS batchBankTransfer_id_142, t131.installateur_id AS installateur_id_143, t131.particulierUser_id AS particulierUser_id_144, t145.id AS id_146, t145.numero AS numero_147, t145.dateRealisation AS dateRealisation_148, t145.dateFinValidite AS dateFinValidite_149, t145.etiquetteBilan AS etiquetteBilan_150, t145.createdAt AS createdAt_151, t145.updatedAt AS updatedAt_152, t145.typeJustificatif AS typeJustificatif_153, t145.projet_id AS projet_id_154, t145.offreProjet_id AS offreProjet_id_155, t0.projectOwner_id AS projectOwner_id_156, t0.project_bundle_id AS project_bundle_id_157, t0.estate_id AS estate_id_158, t159.id AS id_160, t159.`value` AS value_161, t159.offreProjet_id AS offreProjet_id_162, t159.operation_id AS operation_id_163, t159.oblige_id AS oblige_id_164 FROM OffreProjet t0 LEFT JOIN OffreProjetValidation t91 ON t91.offre_id = t0.id LEFT JOIN `Lead` t105 ON t105.offre_id = t0.id LEFT JOIN PaymentMpr t131 ON t131.offreProjet_id = t0.id LEFT JOIN JustificatifPerformanceEnergetique t145 ON t145.offreProjet_id = t0.id LEFT JOIN Recensement t159 ON t159.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.end_zni_date AS end_zni_date_36, t0.globalConfigurationHash AS globalConfigurationHash_37, t0.zni AS zni_38, t0.cdp_eligible AS cdp_eligible_39, t0.simulateur_id AS simulateur_id_40, t0.arrete_id AS arrete_id_41, t0.certification_id AS certification_id_42, t0.qualification_id AS qualification_id_43, t0.formConfigEngine_id AS formConfigEngine_id_44 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.end_zni_date AS end_zni_date_47, t11.globalConfigurationHash AS globalConfigurationHash_48, t11.zni AS zni_49, t11.cdp_eligible AS cdp_eligible_50, t11.simulateur_id AS simulateur_id_51, t11.arrete_id AS arrete_id_52, t11.certification_id AS certification_id_53, t11.qualification_id AS qualification_id_54, t11.formConfigEngine_id AS formConfigEngine_id_55, t0.secteur_id AS secteur_id_56, t0.categorie_id AS categorie_id_57, t0.categorieCd_id AS categorieCd_id_58, t0.type_operation_id AS type_operation_id_59, t0.operation_specifique_id AS operation_specifique_id_60, t61.id AS id_62, t61.mode AS mode_63, t61.targetType AS targetType_64, t61.classic AS classic_65, t61.preca AS preca_66, t61.enable AS enable_67, t61.raiType AS raiType_68, t61.contractSignedElectronically AS contractSignedElectronically_69, t61.pro_signature_mandatory_outlay AS pro_signature_mandatory_outlay_70, t61.obligeTarget_id AS obligeTarget_id_71, t61.teteReseau_id AS teteReseau_id_72, t61.simulateur_id AS simulateur_id_73, t61.installateurTarget_id AS installateurTarget_id_74, t61.beTarget_id AS beTarget_id_75 FROM Simulateur t0 LEFT JOIN Operation t11 ON t0.active_operation_id = t11.id LEFT JOIN AffectationConsoneoRule t61 ON t61.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.conventionElectronique AS conventionElectronique_32, t0.aftElectronique AS aftElectronique_33, t0.contratInstallateur AS contratInstallateur_34, t0.modeProBeneficiaireInscription AS modeProBeneficiaireInscription_35, t0.modeByPassSuperviseur AS modeByPassSuperviseur_36, t0.`lead` AS lead_37, t0.`leadUrl` AS leadUrl_38, t0.`leadLogin` AS leadLogin_39, t0.`leadPassword` AS leadPassword_40, t0.relanceConventionClientUn AS relanceConventionClientUn_41, t0.relanceConventionClientDeux AS relanceConventionClientDeux_42, t0.alertConventionClient AS alertConventionClient_43, t0.relanceConventionInstallateurUn AS relanceConventionInstallateurUn_44, t0.relanceConventionInstallateurDeux AS relanceConventionInstallateurDeux_45, t0.alertConventionInstallateur AS alertConventionInstallateur_46, t0.conventionFin AS conventionFin_47, t0.questionnaireAftRelanceUn AS questionnaireAftRelanceUn_48, t0.questionnaireAftRelanceDeux AS questionnaireAftRelanceDeux_49, t0.alertQuestionnaireAFT AS alertQuestionnaireAFT_50, t0.questionnaireAftFin AS questionnaireAftFin_51, t0.relanceAftFacture AS relanceAftFacture_52, t0.alertAftFacture AS alertAftFacture_53, t0.aftFactureFin AS aftFactureFin_54, t0.mentionCnil AS mentionCnil_55, t0.serviceType AS serviceType_56, t0.precariteMode AS precariteMode_57, t0.precariteModeProgram AS precariteModeProgram_58, t0.blocked AS blocked_59, t0.blockedSimulation AS blockedSimulation_60, t0.resiliation AS resiliation_61, t0.archivageAuto AS archivageAuto_62, t0.travauxPostDevis AS travauxPostDevis_63, t0.emailFacturationPro AS emailFacturationPro_64, t0.mandatoryInstallateurGenericContract AS mandatoryInstallateurGenericContract_65, t0.hiddenEmail AS hiddenEmail_66, t0.certificallCompanyId AS certificallCompanyId_67, t0.visibilityCommercials AS visibilityCommercials_68, t0.mandat AS mandat_69, t0.pricingMandatClassique AS pricingMandatClassique_70, t0.pricingMandatPreca AS pricingMandatPreca_71, t0.pricingPrimeMaximumMandatClassique AS pricingPrimeMaximumMandatClassique_72, t0.pricingPrimeMaximumMandatPreca AS pricingPrimeMaximumMandatPreca_73, t0.originauxAdresse AS originauxAdresse_74, t0.originauxAdresseComplement AS originauxAdresseComplement_75, t0.originauxCodepostal AS originauxCodepostal_76, t0.originauxVille AS originauxVille_77, t0.eligible AS eligible_78, t0.satisfactionSurvey AS satisfactionSurvey_79, t0.surveyConfiguration AS surveyConfiguration_80, t0.autoPayment AS autoPayment_81, t0.isAnnexeDechetQuestion AS isAnnexeDechetQuestion_82, t0.aiEnabled AS aiEnabled_83, t0.isSignatureAutoAhEnabled AS isSignatureAutoAhEnabled_84, t0.isSignatureAutoOtherDocumentsEnabled AS isSignatureAutoOtherDocumentsEnabled_85, t0.emailVersion AS emailVersion_86, t0.validateBackwards AS validateBackwards_87, t0.displayTelConsoneo AS displayTelConsoneo_88, t0.allowedUniverSign AS allowedUniverSign_89, t0.allowedApplicationFees AS allowedApplicationFees_90, t0.displayApplicationFees AS displayApplicationFees_91, t0.programAutoAllowed AS programAutoAllowed_92, t0.mpr AS mpr_93, t0.isRibActivated AS isRibActivated_94, t0.canonicalTeteReseau_id AS canonicalTeteReseau_id_95, t0.oblige_id AS oblige_id_96, t97.id AS id_98, t97.raison AS raison_99, t97.email AS email_100, t97.tel AS tel_101, t97.site_web AS site_web_102, t97.adresse AS adresse_103, t97.cp AS cp_104, t97.ville AS ville_105, t97.oblige_id AS oblige_id_106, t107.id AS id_108, t107.gender AS gender_109, t107.firstName AS firstName_110, t107.name AS name_111, t107.raison AS raison_112, t107.email AS email_113, t107.tel AS tel_114, t107.address AS address_115, t107.cp AS cp_116, t107.city AS city_117, t107.adminMandate AS adminMandate_118, t107.financialMandate AS financialMandate_119, t107.mixteMandate AS mixteMandate_120, t107.signature AS signature_121, t107.tutorial_admin AS tutorial_admin_122, t107.tutorial_mixte AS tutorial_mixte_123, t107.tutorial_financial AS tutorial_financial_124, t107.oblige_id AS oblige_id_125, t126.id AS id_127, t126.raison AS raison_128, t126.siret AS siret_129, t126.oblige_id AS oblige_id_130 FROM Oblige t0 LEFT JOIN Mediateur t97 ON t97.oblige_id = t0.id LEFT JOIN MprConfig t107 ON t107.oblige_id = t0.id LEFT JOIN Mandataire t126 ON t126.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.email_canonical AS email_canonical_28, t0.username_canonical AS username_canonical_29, t0.oblige_id AS oblige_id_30 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.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.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.conventionElectronique AS conventionElectronique_32, t0.aftElectronique AS aftElectronique_33, t0.contratInstallateur AS contratInstallateur_34, t0.modeProBeneficiaireInscription AS modeProBeneficiaireInscription_35, t0.modeByPassSuperviseur AS modeByPassSuperviseur_36, t0.`lead` AS lead_37, t0.`leadUrl` AS leadUrl_38, t0.`leadLogin` AS leadLogin_39, t0.`leadPassword` AS leadPassword_40, t0.relanceConventionClientUn AS relanceConventionClientUn_41, t0.relanceConventionClientDeux AS relanceConventionClientDeux_42, t0.alertConventionClient AS alertConventionClient_43, t0.relanceConventionInstallateurUn AS relanceConventionInstallateurUn_44, t0.relanceConventionInstallateurDeux AS relanceConventionInstallateurDeux_45, t0.alertConventionInstallateur AS alertConventionInstallateur_46, t0.conventionFin AS conventionFin_47, t0.questionnaireAftRelanceUn AS questionnaireAftRelanceUn_48, t0.questionnaireAftRelanceDeux AS questionnaireAftRelanceDeux_49, t0.alertQuestionnaireAFT AS alertQuestionnaireAFT_50, t0.questionnaireAftFin AS questionnaireAftFin_51, t0.relanceAftFacture AS relanceAftFacture_52, t0.alertAftFacture AS alertAftFacture_53, t0.aftFactureFin AS aftFactureFin_54, t0.mentionCnil AS mentionCnil_55, t0.serviceType AS serviceType_56, t0.precariteMode AS precariteMode_57, t0.precariteModeProgram AS precariteModeProgram_58, t0.blocked AS blocked_59, t0.blockedSimulation AS blockedSimulation_60, t0.resiliation AS resiliation_61, t0.archivageAuto AS archivageAuto_62, t0.travauxPostDevis AS travauxPostDevis_63, t0.emailFacturationPro AS emailFacturationPro_64, t0.mandatoryInstallateurGenericContract AS mandatoryInstallateurGenericContract_65, t0.hiddenEmail AS hiddenEmail_66, t0.certificallCompanyId AS certificallCompanyId_67, t0.visibilityCommercials AS visibilityCommercials_68, t0.mandat AS mandat_69, t0.pricingMandatClassique AS pricingMandatClassique_70, t0.pricingMandatPreca AS pricingMandatPreca_71, t0.pricingPrimeMaximumMandatClassique AS pricingPrimeMaximumMandatClassique_72, t0.pricingPrimeMaximumMandatPreca AS pricingPrimeMaximumMandatPreca_73, t0.originauxAdresse AS originauxAdresse_74, t0.originauxAdresseComplement AS originauxAdresseComplement_75, t0.originauxCodepostal AS originauxCodepostal_76, t0.originauxVille AS originauxVille_77, t0.eligible AS eligible_78, t0.satisfactionSurvey AS satisfactionSurvey_79, t0.surveyConfiguration AS surveyConfiguration_80, t0.autoPayment AS autoPayment_81, t0.isAnnexeDechetQuestion AS isAnnexeDechetQuestion_82, t0.aiEnabled AS aiEnabled_83, t0.isSignatureAutoAhEnabled AS isSignatureAutoAhEnabled_84, t0.isSignatureAutoOtherDocumentsEnabled AS isSignatureAutoOtherDocumentsEnabled_85, t0.emailVersion AS emailVersion_86, t0.validateBackwards AS validateBackwards_87, t0.displayTelConsoneo AS displayTelConsoneo_88, t0.allowedUniverSign AS allowedUniverSign_89, t0.allowedApplicationFees AS allowedApplicationFees_90, t0.displayApplicationFees AS displayApplicationFees_91, t0.programAutoAllowed AS programAutoAllowed_92, t0.mpr AS mpr_93, t0.isRibActivated AS isRibActivated_94, t0.canonicalTeteReseau_id AS canonicalTeteReseau_id_95, t0.oblige_id AS oblige_id_96, t97.id AS id_98, t97.raison AS raison_99, t97.email AS email_100, t97.tel AS tel_101, t97.site_web AS site_web_102, t97.adresse AS adresse_103, t97.cp AS cp_104, t97.ville AS ville_105, t97.oblige_id AS oblige_id_106, t107.id AS id_108, t107.gender AS gender_109, t107.firstName AS firstName_110, t107.name AS name_111, t107.raison AS raison_112, t107.email AS email_113, t107.tel AS tel_114, t107.address AS address_115, t107.cp AS cp_116, t107.city AS city_117, t107.adminMandate AS adminMandate_118, t107.financialMandate AS financialMandate_119, t107.mixteMandate AS mixteMandate_120, t107.signature AS signature_121, t107.tutorial_admin AS tutorial_admin_122, t107.tutorial_mixte AS tutorial_mixte_123, t107.tutorial_financial AS tutorial_financial_124, t107.oblige_id AS oblige_id_125, t126.id AS id_127, t126.raison AS raison_128, t126.siret AS siret_129, t126.oblige_id AS oblige_id_130 FROM Oblige t0 LEFT JOIN Mediateur t97 ON t97.oblige_id = t0.id LEFT JOIN MprConfig t107 ON t107.oblige_id = t0.id LEFT JOIN Mandataire t126 ON t126.oblige_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 = ?
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.conventionElectronique AS conventionElectronique_32, t0.aftElectronique AS aftElectronique_33, t0.contratInstallateur AS contratInstallateur_34, t0.modeProBeneficiaireInscription AS modeProBeneficiaireInscription_35, t0.modeByPassSuperviseur AS modeByPassSuperviseur_36, t0.`lead` AS lead_37, t0.`leadUrl` AS leadUrl_38, t0.`leadLogin` AS leadLogin_39, t0.`leadPassword` AS leadPassword_40, t0.relanceConventionClientUn AS relanceConventionClientUn_41, t0.relanceConventionClientDeux AS relanceConventionClientDeux_42, t0.alertConventionClient AS alertConventionClient_43, t0.relanceConventionInstallateurUn AS relanceConventionInstallateurUn_44, t0.relanceConventionInstallateurDeux AS relanceConventionInstallateurDeux_45, t0.alertConventionInstallateur AS alertConventionInstallateur_46, t0.conventionFin AS conventionFin_47, t0.questionnaireAftRelanceUn AS questionnaireAftRelanceUn_48, t0.questionnaireAftRelanceDeux AS questionnaireAftRelanceDeux_49, t0.alertQuestionnaireAFT AS alertQuestionnaireAFT_50, t0.questionnaireAftFin AS questionnaireAftFin_51, t0.relanceAftFacture AS relanceAftFacture_52, t0.alertAftFacture AS alertAftFacture_53, t0.aftFactureFin AS aftFactureFin_54, t0.mentionCnil AS mentionCnil_55, t0.serviceType AS serviceType_56, t0.precariteMode AS precariteMode_57, t0.precariteModeProgram AS precariteModeProgram_58, t0.blocked AS blocked_59, t0.blockedSimulation AS blockedSimulation_60, t0.resiliation AS resiliation_61, t0.archivageAuto AS archivageAuto_62, t0.travauxPostDevis AS travauxPostDevis_63, t0.emailFacturationPro AS emailFacturationPro_64, t0.mandatoryInstallateurGenericContract AS mandatoryInstallateurGenericContract_65, t0.hiddenEmail AS hiddenEmail_66, t0.certificallCompanyId AS certificallCompanyId_67, t0.visibilityCommercials AS visibilityCommercials_68, t0.mandat AS mandat_69, t0.pricingMandatClassique AS pricingMandatClassique_70, t0.pricingMandatPreca AS pricingMandatPreca_71, t0.pricingPrimeMaximumMandatClassique AS pricingPrimeMaximumMandatClassique_72, t0.pricingPrimeMaximumMandatPreca AS pricingPrimeMaximumMandatPreca_73, t0.originauxAdresse AS originauxAdresse_74, t0.originauxAdresseComplement AS originauxAdresseComplement_75, t0.originauxCodepostal AS originauxCodepostal_76, t0.originauxVille AS originauxVille_77, t0.eligible AS eligible_78, t0.satisfactionSurvey AS satisfactionSurvey_79, t0.surveyConfiguration AS surveyConfiguration_80, t0.autoPayment AS autoPayment_81, t0.isAnnexeDechetQuestion AS isAnnexeDechetQuestion_82, t0.aiEnabled AS aiEnabled_83, t0.isSignatureAutoAhEnabled AS isSignatureAutoAhEnabled_84, t0.isSignatureAutoOtherDocumentsEnabled AS isSignatureAutoOtherDocumentsEnabled_85, t0.emailVersion AS emailVersion_86, t0.validateBackwards AS validateBackwards_87, t0.displayTelConsoneo AS displayTelConsoneo_88, t0.allowedUniverSign AS allowedUniverSign_89, t0.allowedApplicationFees AS allowedApplicationFees_90, t0.displayApplicationFees AS displayApplicationFees_91, t0.programAutoAllowed AS programAutoAllowed_92, t0.mpr AS mpr_93, t0.isRibActivated AS isRibActivated_94, t0.canonicalTeteReseau_id AS canonicalTeteReseau_id_95, t0.oblige_id AS oblige_id_96, t97.id AS id_98, t97.raison AS raison_99, t97.email AS email_100, t97.tel AS tel_101, t97.site_web AS site_web_102, t97.adresse AS adresse_103, t97.cp AS cp_104, t97.ville AS ville_105, t97.oblige_id AS oblige_id_106, t107.id AS id_108, t107.gender AS gender_109, t107.firstName AS firstName_110, t107.name AS name_111, t107.raison AS raison_112, t107.email AS email_113, t107.tel AS tel_114, t107.address AS address_115, t107.cp AS cp_116, t107.city AS city_117, t107.adminMandate AS adminMandate_118, t107.financialMandate AS financialMandate_119, t107.mixteMandate AS mixteMandate_120, t107.signature AS signature_121, t107.tutorial_admin AS tutorial_admin_122, t107.tutorial_mixte AS tutorial_mixte_123, t107.tutorial_financial AS tutorial_financial_124, t107.oblige_id AS oblige_id_125, t126.id AS id_127, t126.raison AS raison_128, t126.siret AS siret_129, t126.oblige_id AS oblige_id_130 FROM Oblige t0 LEFT JOIN Mediateur t97 ON t97.oblige_id = t0.id LEFT JOIN MprConfig t107 ON t107.oblige_id = t0.id LEFT JOIN Mandataire t126 ON t126.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_.reference AS reference_5, o0_.data AS data_6, o0_.cofracData AS cofracData_7, o0_.ip AS ip_8, o0_.offre_auto_date AS offre_auto_date_9, o0_.created_datetime AS created_datetime_10, o0_.updated_datetime AS updated_datetime_11, o0_.tel AS tel_12, o0_.codepostal AS codepostal_13, o0_.adresse AS adresse_14, o0_.adresse_complement AS adresse_complement_15, o0_.ville AS ville_16, o0_.delai_souhaite AS delai_souhaite_17, o0_.accept_recevoir_offre AS accept_recevoir_offre_18, o0_.accept_recommandation AS accept_recommandation_19, o0_.acceptLeadPromo AS acceptLeadPromo_20, o0_.offre_cumac AS offre_cumac_21, o0_.offre_cumac_client AS offre_cumac_client_22, o0_.offre_cumac_precarite AS offre_cumac_precarite_23, o0_.offre_cumac_client_precarite AS offre_cumac_client_precarite_24, o0_.cumac AS cumac_25, o0_.cumac_AFT AS cumac_AFT_26, o0_.total_prime AS total_prime_27, o0_.total_prime_AFT AS total_prime_AFT_28, o0_.prime_pro AS prime_pro_29, o0_.prime_pro_aft AS prime_pro_aft_30, o0_.prime_client AS prime_client_31, o0_.prime_client_aft AS prime_client_aft_32, o0_.cumac_moyenne AS cumac_moyenne_33, o0_.taux_actualise AS taux_actualise_34, o0_.taux_accumule AS taux_accumule_35, o0_.date_debut_chantier AS date_debut_chantier_36, o0_.date_demande_offre AS date_demande_offre_37, o0_.date_fin_chantier AS date_fin_chantier_38, o0_.etat AS etat_39, o0_.status AS status_40, o0_.date_offre AS date_offre_41, o0_.notification_date_chantier AS notification_date_chantier_42, o0_.date_retour_conv AS date_retour_conv_43, o0_.date_validation_conv AS date_validation_conv_44, o0_.date_chantier_renseigne AS date_chantier_renseigne_45, o0_.date_paiement AS date_paiement_46, o0_.date_all_doc_valid AS date_all_doc_valid_47, o0_.date_fin_chantier_repousse AS date_fin_chantier_repousse_48, o0_.date_envoi_questionnaire AS date_envoi_questionnaire_49, o0_.date_edition_questionnaire AS date_edition_questionnaire_50, o0_.date_validation_final AS date_validation_final_51, o0_.date_annulation AS date_annulation_52, o0_.no_click_email_date_chantier AS no_click_email_date_chantier_53, o0_.token AS token_54, o0_.auto_installation AS auto_installation_55, o0_.siret AS siret_56, o0_.cancelReason AS cancelReason_57, o0_.dateCommande AS dateCommande_58, o0_.siteTravaux AS siteTravaux_59, o0_.incitation AS incitation_60, o0_.qualificationRecordDate AS qualificationRecordDate_61, o0_.serviceType AS serviceType_62, o0_.debutChantier AS debutChantier_63, o0_.finChantier AS finChantier_64, o0_.initiateCDP AS initiateCDP_65, o0_.cdp AS cdp_66, o0_.date_last_envoi_convention AS date_last_envoi_convention_67, o0_.programStep AS programStep_68, o0_.devisRestAPayer AS devisRestAPayer_69, o0_.pricingMandatClassique AS pricingMandatClassique_70, o0_.pricingMandatPreca AS pricingMandatPreca_71, o0_.isCOFRAC AS isCOFRAC_72, o0_.applicationFeesPrice AS applicationFeesPrice_73, o0_.attributes AS attributes_74, o0_.exclusive AS exclusive_75, o0_.engineDocumentId AS engineDocumentId_76, o0_.batchOffreProjet_id AS batchOffreProjet_id_77, o0_.entrepriseUser_id AS entrepriseUser_id_78, o0_.installateurUser_id AS installateurUser_id_79, o0_.beUser_id AS beUser_id_80, o0_.entrepriseUserContact_id AS entrepriseUserContact_id_81, o0_.particulierUserContact_id AS particulierUserContact_id_82, o0_.signataireEntreprise_id AS signataireEntreprise_id_83, o0_.signataireInstallateur_id AS signataireInstallateur_id_84, o0_.installateurUserContact_id AS installateurUserContact_id_85, o0_.projet_id AS projet_id_86, o0_.precariteCas2_id AS precariteCas2_id_87, o0_.precarite_id AS precarite_id_88, o0_.state_id AS state_id_89, o0_.oblige_id AS oblige_id_90, o0_.secteurActivite_id AS secteurActivite_id_91, o0_.factureDetail_id AS factureDetail_id_92, o0_.offreStatus_id AS offreStatus_id_93, o0_.identiteBeneficiaire_id AS identiteBeneficiaire_id_94, o0_.identiteInstallateur_id AS identiteInstallateur_id_95, o0_.operation_id AS operation_id_96, o0_.particulierUser_id AS particulierUser_id_97, o0_.qualificationRecord_id AS qualificationRecord_id_98, o0_.sousTraitant_id AS sousTraitant_id_99, o0_.program_id AS program_id_100, o0_.programCommercial_id AS programCommercial_id_101, o0_.programManager_id AS programManager_id_102, o0_.signatureAuto_id AS signatureAuto_id_103, o0_.wasteCenter_id AS wasteCenter_id_104, o0_.waste_id AS waste_id_105, o0_.programAuto_id AS programAuto_id_106, o0_.justificatif_id AS justificatif_id_107, o0_.cappingRule_id AS cappingRule_id_108, o0_.projectOwner_id AS projectOwner_id_109, o0_.project_bundle_id AS project_bundle_id_110, o0_.estate_id AS estate_id_111 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	0.99 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.email_canonical AS email_canonical_28, t0.username_canonical AS username_canonical_29, t0.oblige_id AS oblige_id_30 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.email_canonical AS email_canonical_28, t0.username_canonical AS username_canonical_29, t0.oblige_id AS oblige_id_30 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.email_canonical AS email_canonical_28, t0.username_canonical AS username_canonical_29, t0.oblige_id AS oblige_id_30 FROM ObligeUser t0 WHERE t0.id = 44;
2	1.96 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.reference AS reference_6, t0.data AS data_7, t0.cofracData AS cofracData_8, t0.ip AS ip_9, t0.offre_auto_date AS offre_auto_date_10, t0.created_datetime AS created_datetime_11, t0.updated_datetime AS updated_datetime_12, t0.tel AS tel_13, t0.codepostal AS codepostal_14, t0.adresse AS adresse_15, t0.adresse_complement AS adresse_complement_16, t0.ville AS ville_17, t0.delai_souhaite AS delai_souhaite_18, t0.accept_recevoir_offre AS accept_recevoir_offre_19, t0.accept_recommandation AS accept_recommandation_20, t0.acceptLeadPromo AS acceptLeadPromo_21, t0.offre_cumac AS offre_cumac_22, t0.offre_cumac_client AS offre_cumac_client_23, t0.offre_cumac_precarite AS offre_cumac_precarite_24, t0.offre_cumac_client_precarite AS offre_cumac_client_precarite_25, t0.cumac AS cumac_26, t0.cumac_AFT AS cumac_AFT_27, t0.total_prime AS total_prime_28, t0.total_prime_AFT AS total_prime_AFT_29, t0.prime_pro AS prime_pro_30, t0.prime_pro_aft AS prime_pro_aft_31, t0.prime_client AS prime_client_32, t0.prime_client_aft AS prime_client_aft_33, t0.cumac_moyenne AS cumac_moyenne_34, t0.taux_actualise AS taux_actualise_35, t0.taux_accumule AS taux_accumule_36, t0.date_debut_chantier AS date_debut_chantier_37, t0.date_demande_offre AS date_demande_offre_38, t0.date_fin_chantier AS date_fin_chantier_39, t0.etat AS etat_40, t0.status AS status_41, t0.date_offre AS date_offre_42, t0.notification_date_chantier AS notification_date_chantier_43, t0.date_retour_conv AS date_retour_conv_44, t0.date_validation_conv AS date_validation_conv_45, t0.date_chantier_renseigne AS date_chantier_renseigne_46, t0.date_paiement AS date_paiement_47, t0.date_all_doc_valid AS date_all_doc_valid_48, t0.date_fin_chantier_repousse AS date_fin_chantier_repousse_49, t0.date_envoi_questionnaire AS date_envoi_questionnaire_50, t0.date_edition_questionnaire AS date_edition_questionnaire_51, t0.date_validation_final AS date_validation_final_52, t0.date_annulation AS date_annulation_53, t0.no_click_email_date_chantier AS no_click_email_date_chantier_54, t0.token AS token_55, t0.auto_installation AS auto_installation_56, t0.siret AS siret_57, t0.cancelReason AS cancelReason_58, t0.dateCommande AS dateCommande_59, t0.siteTravaux AS siteTravaux_60, t0.incitation AS incitation_61, t0.qualificationRecordDate AS qualificationRecordDate_62, t0.serviceType AS serviceType_63, t0.debutChantier AS debutChantier_64, t0.finChantier AS finChantier_65, t0.initiateCDP AS initiateCDP_66, t0.cdp AS cdp_67, t0.date_last_envoi_convention AS date_last_envoi_convention_68, t0.programStep AS programStep_69, t0.devisRestAPayer AS devisRestAPayer_70, t0.pricingMandatClassique AS pricingMandatClassique_71, t0.pricingMandatPreca AS pricingMandatPreca_72, t0.isCOFRAC AS isCOFRAC_73, t0.applicationFeesPrice AS applicationFeesPrice_74, t0.attributes AS attributes_75, t0.exclusive AS exclusive_76, t0.engineDocumentId AS engineDocumentId_77, t0.batchOffreProjet_id AS batchOffreProjet_id_78, t0.entrepriseUser_id AS entrepriseUser_id_79, t0.installateurUser_id AS installateurUser_id_80, t0.beUser_id AS beUser_id_81, t0.entrepriseUserContact_id AS entrepriseUserContact_id_82, t0.particulierUserContact_id AS particulierUserContact_id_83, t0.signataireEntreprise_id AS signataireEntreprise_id_84, t0.signataireInstallateur_id AS signataireInstallateur_id_85, t0.installateurUserContact_id AS installateurUserContact_id_86, t0.projet_id AS projet_id_87, t0.precariteCas2_id AS precariteCas2_id_88, t0.precarite_id AS precarite_id_89, t0.state_id AS state_id_90, t91.id AS id_92, t91.created_datetime AS created_datetime_93, t91.convention AS convention_94, t91.aft AS aft_95, t91.facture AS facture_96, t91.beneficiaire AS beneficiaire_97, t91.installateur AS installateur_98, t91.doc_obligatoire AS doc_obligatoire_99, t91.coherence_dossier AS coherence_dossier_100, t91.offre_id AS offre_id_101, t0.oblige_id AS oblige_id_102, t0.secteurActivite_id AS secteurActivite_id_103, t0.factureDetail_id AS factureDetail_id_104, t105.id AS id_106, t105.reference AS reference_107, t105.type AS type_108, t105.result AS result_109, t105.errors AS errors_110, t105.message AS message_111, t105.created_datetime AS created_datetime_112, t105.integrationModule_id AS integrationModule_id_113, t105.offre_id AS offre_id_114, t0.offreStatus_id AS offreStatus_id_115, t0.identiteBeneficiaire_id AS identiteBeneficiaire_id_116, t0.identiteInstallateur_id AS identiteInstallateur_id_117, t0.operation_id AS operation_id_118, t0.particulierUser_id AS particulierUser_id_119, t0.qualificationRecord_id AS qualificationRecord_id_120, t0.sousTraitant_id AS sousTraitant_id_121, t0.program_id AS program_id_122, t0.programCommercial_id AS programCommercial_id_123, t0.programManager_id AS programManager_id_124, t0.signatureAuto_id AS signatureAuto_id_125, t0.wasteCenter_id AS wasteCenter_id_126, t0.waste_id AS waste_id_127, t0.programAuto_id AS programAuto_id_128, t0.justificatif_id AS justificatif_id_129, t0.cappingRule_id AS cappingRule_id_130, t131.id AS id_132, t131.mprUuid AS mprUuid_133, t131.mprReference AS mprReference_134, t131.paymentDate AS paymentDate_135, t131.invoiceReference AS invoiceReference_136, t131.invoiceDate AS invoiceDate_137, t131.amount AS amount_138, t131.archive AS archive_139, t131.step AS step_140, t131.offreProjet_id AS offreProjet_id_141, t131.batchBankTransfer_id AS batchBankTransfer_id_142, t131.installateur_id AS installateur_id_143, t131.particulierUser_id AS particulierUser_id_144, t145.id AS id_146, t145.numero AS numero_147, t145.dateRealisation AS dateRealisation_148, t145.dateFinValidite AS dateFinValidite_149, t145.etiquetteBilan AS etiquetteBilan_150, t145.createdAt AS createdAt_151, t145.updatedAt AS updatedAt_152, t145.typeJustificatif AS typeJustificatif_153, t145.projet_id AS projet_id_154, t145.offreProjet_id AS offreProjet_id_155, t0.projectOwner_id AS projectOwner_id_156, t0.project_bundle_id AS project_bundle_id_157, t0.estate_id AS estate_id_158, t159.id AS id_160, t159.`value` AS value_161, t159.offreProjet_id AS offreProjet_id_162, t159.operation_id AS operation_id_163, t159.oblige_id AS oblige_id_164 FROM OffreProjet t0 LEFT JOIN OffreProjetValidation t91 ON t91.offre_id = t0.id LEFT JOIN `Lead` t105 ON t105.offre_id = t0.id LEFT JOIN PaymentMpr t131 ON t131.offreProjet_id = t0.id LEFT JOIN JustificatifPerformanceEnergetique t145 ON t145.offreProjet_id = t0.id LEFT JOIN Recensement t159 ON t159.offreProjet_id = t0.id WHERE t0.token = ? LIMIT 1 Parameters: [`"zWifXFC7jHG70HANXfmH6gUQUT78DZdqFsRLkQQKIB4"`] 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.reference AS reference_6, t0.data AS data_7, t0.cofracData AS cofracData_8, t0.ip AS ip_9, t0.offre_auto_date AS offre_auto_date_10, t0.created_datetime AS created_datetime_11, t0.updated_datetime AS updated_datetime_12, t0.tel AS tel_13, t0.codepostal AS codepostal_14, t0.adresse AS adresse_15, t0.adresse_complement AS adresse_complement_16, t0.ville AS ville_17, t0.delai_souhaite AS delai_souhaite_18, t0.accept_recevoir_offre AS accept_recevoir_offre_19, t0.accept_recommandation AS accept_recommandation_20, t0.acceptLeadPromo AS acceptLeadPromo_21, t0.offre_cumac AS offre_cumac_22, t0.offre_cumac_client AS offre_cumac_client_23, t0.offre_cumac_precarite AS offre_cumac_precarite_24, t0.offre_cumac_client_precarite AS offre_cumac_client_precarite_25, t0.cumac AS cumac_26, t0.cumac_AFT AS cumac_AFT_27, t0.total_prime AS total_prime_28, t0.total_prime_AFT AS total_prime_AFT_29, t0.prime_pro AS prime_pro_30, t0.prime_pro_aft AS prime_pro_aft_31, t0.prime_client AS prime_client_32, t0.prime_client_aft AS prime_client_aft_33, t0.cumac_moyenne AS cumac_moyenne_34, t0.taux_actualise AS taux_actualise_35, t0.taux_accumule AS taux_accumule_36, t0.date_debut_chantier AS date_debut_chantier_37, t0.date_demande_offre AS date_demande_offre_38, t0.date_fin_chantier AS date_fin_chantier_39, t0.etat AS etat_40, t0.status AS status_41, t0.date_offre AS date_offre_42, t0.notification_date_chantier AS notification_date_chantier_43, t0.date_retour_conv AS date_retour_conv_44, t0.date_validation_conv AS date_validation_conv_45, t0.date_chantier_renseigne AS date_chantier_renseigne_46, t0.date_paiement AS date_paiement_47, t0.date_all_doc_valid AS date_all_doc_valid_48, t0.date_fin_chantier_repousse AS date_fin_chantier_repousse_49, t0.date_envoi_questionnaire AS date_envoi_questionnaire_50, t0.date_edition_questionnaire AS date_edition_questionnaire_51, t0.date_validation_final AS date_validation_final_52, t0.date_annulation AS date_annulation_53, t0.no_click_email_date_chantier AS no_click_email_date_chantier_54, t0.token AS token_55, t0.auto_installation AS auto_installation_56, t0.siret AS siret_57, t0.cancelReason AS cancelReason_58, t0.dateCommande AS dateCommande_59, t0.siteTravaux AS siteTravaux_60, t0.incitation AS incitation_61, t0.qualificationRecordDate AS qualificationRecordDate_62, t0.serviceType AS serviceType_63, t0.debutChantier AS debutChantier_64, t0.finChantier AS finChantier_65, t0.initiateCDP AS initiateCDP_66, t0.cdp AS cdp_67, t0.date_last_envoi_convention AS date_last_envoi_convention_68, t0.programStep AS programStep_69, t0.devisRestAPayer AS devisRestAPayer_70, t0.pricingMandatClassique AS pricingMandatClassique_71, t0.pricingMandatPreca AS pricingMandatPreca_72, t0.isCOFRAC AS isCOFRAC_73, t0.applicationFeesPrice AS applicationFeesPrice_74, t0.attributes AS attributes_75, t0.exclusive AS exclusive_76, t0.engineDocumentId AS engineDocumentId_77, t0.batchOffreProjet_id AS batchOffreProjet_id_78, t0.entrepriseUser_id AS entrepriseUser_id_79, t0.installateurUser_id AS installateurUser_id_80, t0.beUser_id AS beUser_id_81, t0.entrepriseUserContact_id AS entrepriseUserContact_id_82, t0.particulierUserContact_id AS particulierUserContact_id_83, t0.signataireEntreprise_id AS signataireEntreprise_id_84, t0.signataireInstallateur_id AS signataireInstallateur_id_85, t0.installateurUserContact_id AS installateurUserContact_id_86, t0.projet_id AS projet_id_87, t0.precariteCas2_id AS precariteCas2_id_88, t0.precarite_id AS precarite_id_89, t0.state_id AS state_id_90, t91.id AS id_92, t91.created_datetime AS created_datetime_93, t91.convention AS convention_94, t91.aft AS aft_95, t91.facture AS facture_96, t91.beneficiaire AS beneficiaire_97, t91.installateur AS installateur_98, t91.doc_obligatoire AS doc_obligatoire_99, t91.coherence_dossier AS coherence_dossier_100, t91.offre_id AS offre_id_101, t0.oblige_id AS oblige_id_102, t0.secteurActivite_id AS secteurActivite_id_103, t0.factureDetail_id AS factureDetail_id_104, t105.id AS id_106, t105.reference AS reference_107, t105.type AS type_108, t105.result AS result_109, t105.errors AS errors_110, t105.message AS message_111, t105.created_datetime AS created_datetime_112, t105.integrationModule_id AS integrationModule_id_113, t105.offre_id AS offre_id_114, t0.offreStatus_id AS offreStatus_id_115, t0.identiteBeneficiaire_id AS identiteBeneficiaire_id_116, t0.identiteInstallateur_id AS identiteInstallateur_id_117, t0.operation_id AS operation_id_118, t0.particulierUser_id AS particulierUser_id_119, t0.qualificationRecord_id AS qualificationRecord_id_120, t0.sousTraitant_id AS sousTraitant_id_121, t0.program_id AS program_id_122, t0.programCommercial_id AS programCommercial_id_123, t0.programManager_id AS programManager_id_124, t0.signatureAuto_id AS signatureAuto_id_125, t0.wasteCenter_id AS wasteCenter_id_126, t0.waste_id AS waste_id_127, t0.programAuto_id AS programAuto_id_128, t0.justificatif_id AS justificatif_id_129, t0.cappingRule_id AS cappingRule_id_130, t131.id AS id_132, t131.mprUuid AS mprUuid_133, t131.mprReference AS mprReference_134, t131.paymentDate AS paymentDate_135, t131.invoiceReference AS invoiceReference_136, t131.invoiceDate AS invoiceDate_137, t131.amount AS amount_138, t131.archive AS archive_139, t131.step AS step_140, t131.offreProjet_id AS offreProjet_id_141, t131.batchBankTransfer_id AS batchBankTransfer_id_142, t131.installateur_id AS installateur_id_143, t131.particulierUser_id AS particulierUser_id_144, t145.id AS id_146, t145.numero AS numero_147, t145.dateRealisation AS dateRealisation_148, t145.dateFinValidite AS dateFinValidite_149, t145.etiquetteBilan AS etiquetteBilan_150, t145.createdAt AS createdAt_151, t145.updatedAt AS updatedAt_152, t145.typeJustificatif AS typeJustificatif_153, t145.projet_id AS projet_id_154, t145.offreProjet_id AS offreProjet_id_155, t0.projectOwner_id AS projectOwner_id_156, t0.project_bundle_id AS project_bundle_id_157, t0.estate_id AS estate_id_158, t159.id AS id_160, t159.`value` AS value_161, t159.offreProjet_id AS offreProjet_id_162, t159.operation_id AS operation_id_163, t159.oblige_id AS oblige_id_164 FROM OffreProjet t0 LEFT JOIN OffreProjetValidation t91 ON t91.offre_id = t0.id LEFT JOIN `Lead` t105 ON t105.offre_id = t0.id LEFT JOIN PaymentMpr t131 ON t131.offreProjet_id = t0.id LEFT JOIN JustificatifPerformanceEnergetique t145 ON t145.offreProjet_id = t0.id LEFT JOIN Recensement t159 ON t159.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.reference AS reference_6, t0.data AS data_7, t0.cofracData AS cofracData_8, t0.ip AS ip_9, t0.offre_auto_date AS offre_auto_date_10, t0.created_datetime AS created_datetime_11, t0.updated_datetime AS updated_datetime_12, t0.tel AS tel_13, t0.codepostal AS codepostal_14, t0.adresse AS adresse_15, t0.adresse_complement AS adresse_complement_16, t0.ville AS ville_17, t0.delai_souhaite AS delai_souhaite_18, t0.accept_recevoir_offre AS accept_recevoir_offre_19, t0.accept_recommandation AS accept_recommandation_20, t0.acceptLeadPromo AS acceptLeadPromo_21, t0.offre_cumac AS offre_cumac_22, t0.offre_cumac_client AS offre_cumac_client_23, t0.offre_cumac_precarite AS offre_cumac_precarite_24, t0.offre_cumac_client_precarite AS offre_cumac_client_precarite_25, t0.cumac AS cumac_26, t0.cumac_AFT AS cumac_AFT_27, t0.total_prime AS total_prime_28, t0.total_prime_AFT AS total_prime_AFT_29, t0.prime_pro AS prime_pro_30, t0.prime_pro_aft AS prime_pro_aft_31, t0.prime_client AS prime_client_32, t0.prime_client_aft AS prime_client_aft_33, t0.cumac_moyenne AS cumac_moyenne_34, t0.taux_actualise AS taux_actualise_35, t0.taux_accumule AS taux_accumule_36, t0.date_debut_chantier AS date_debut_chantier_37, t0.date_demande_offre AS date_demande_offre_38, t0.date_fin_chantier AS date_fin_chantier_39, t0.etat AS etat_40, t0.status AS status_41, t0.date_offre AS date_offre_42, t0.notification_date_chantier AS notification_date_chantier_43, t0.date_retour_conv AS date_retour_conv_44, t0.date_validation_conv AS date_validation_conv_45, t0.date_chantier_renseigne AS date_chantier_renseigne_46, t0.date_paiement AS date_paiement_47, t0.date_all_doc_valid AS date_all_doc_valid_48, t0.date_fin_chantier_repousse AS date_fin_chantier_repousse_49, t0.date_envoi_questionnaire AS date_envoi_questionnaire_50, t0.date_edition_questionnaire AS date_edition_questionnaire_51, t0.date_validation_final AS date_validation_final_52, t0.date_annulation AS date_annulation_53, t0.no_click_email_date_chantier AS no_click_email_date_chantier_54, t0.token AS token_55, t0.auto_installation AS auto_installation_56, t0.siret AS siret_57, t0.cancelReason AS cancelReason_58, t0.dateCommande AS dateCommande_59, t0.siteTravaux AS siteTravaux_60, t0.incitation AS incitation_61, t0.qualificationRecordDate AS qualificationRecordDate_62, t0.serviceType AS serviceType_63, t0.debutChantier AS debutChantier_64, t0.finChantier AS finChantier_65, t0.initiateCDP AS initiateCDP_66, t0.cdp AS cdp_67, t0.date_last_envoi_convention AS date_last_envoi_convention_68, t0.programStep AS programStep_69, t0.devisRestAPayer AS devisRestAPayer_70, t0.pricingMandatClassique AS pricingMandatClassique_71, t0.pricingMandatPreca AS pricingMandatPreca_72, t0.isCOFRAC AS isCOFRAC_73, t0.applicationFeesPrice AS applicationFeesPrice_74, t0.attributes AS attributes_75, t0.exclusive AS exclusive_76, t0.engineDocumentId AS engineDocumentId_77, t0.batchOffreProjet_id AS batchOffreProjet_id_78, t0.entrepriseUser_id AS entrepriseUser_id_79, t0.installateurUser_id AS installateurUser_id_80, t0.beUser_id AS beUser_id_81, t0.entrepriseUserContact_id AS entrepriseUserContact_id_82, t0.particulierUserContact_id AS particulierUserContact_id_83, t0.signataireEntreprise_id AS signataireEntreprise_id_84, t0.signataireInstallateur_id AS signataireInstallateur_id_85, t0.installateurUserContact_id AS installateurUserContact_id_86, t0.projet_id AS projet_id_87, t0.precariteCas2_id AS precariteCas2_id_88, t0.precarite_id AS precarite_id_89, t0.state_id AS state_id_90, t91.id AS id_92, t91.created_datetime AS created_datetime_93, t91.convention AS convention_94, t91.aft AS aft_95, t91.facture AS facture_96, t91.beneficiaire AS beneficiaire_97, t91.installateur AS installateur_98, t91.doc_obligatoire AS doc_obligatoire_99, t91.coherence_dossier AS coherence_dossier_100, t91.offre_id AS offre_id_101, t0.oblige_id AS oblige_id_102, t0.secteurActivite_id AS secteurActivite_id_103, t0.factureDetail_id AS factureDetail_id_104, t105.id AS id_106, t105.reference AS reference_107, t105.type AS type_108, t105.result AS result_109, t105.errors AS errors_110, t105.message AS message_111, t105.created_datetime AS created_datetime_112, t105.integrationModule_id AS integrationModule_id_113, t105.offre_id AS offre_id_114, t0.offreStatus_id AS offreStatus_id_115, t0.identiteBeneficiaire_id AS identiteBeneficiaire_id_116, t0.identiteInstallateur_id AS identiteInstallateur_id_117, t0.operation_id AS operation_id_118, t0.particulierUser_id AS particulierUser_id_119, t0.qualificationRecord_id AS qualificationRecord_id_120, t0.sousTraitant_id AS sousTraitant_id_121, t0.program_id AS program_id_122, t0.programCommercial_id AS programCommercial_id_123, t0.programManager_id AS programManager_id_124, t0.signatureAuto_id AS signatureAuto_id_125, t0.wasteCenter_id AS wasteCenter_id_126, t0.waste_id AS waste_id_127, t0.programAuto_id AS programAuto_id_128, t0.justificatif_id AS justificatif_id_129, t0.cappingRule_id AS cappingRule_id_130, t131.id AS id_132, t131.mprUuid AS mprUuid_133, t131.mprReference AS mprReference_134, t131.paymentDate AS paymentDate_135, t131.invoiceReference AS invoiceReference_136, t131.invoiceDate AS invoiceDate_137, t131.amount AS amount_138, t131.archive AS archive_139, t131.step AS step_140, t131.offreProjet_id AS offreProjet_id_141, t131.batchBankTransfer_id AS batchBankTransfer_id_142, t131.installateur_id AS installateur_id_143, t131.particulierUser_id AS particulierUser_id_144, t145.id AS id_146, t145.numero AS numero_147, t145.dateRealisation AS dateRealisation_148, t145.dateFinValidite AS dateFinValidite_149, t145.etiquetteBilan AS etiquetteBilan_150, t145.createdAt AS createdAt_151, t145.updatedAt AS updatedAt_152, t145.typeJustificatif AS typeJustificatif_153, t145.projet_id AS projet_id_154, t145.offreProjet_id AS offreProjet_id_155, t0.projectOwner_id AS projectOwner_id_156, t0.project_bundle_id AS project_bundle_id_157, t0.estate_id AS estate_id_158, t159.id AS id_160, t159.`value` AS value_161, t159.offreProjet_id AS offreProjet_id_162, t159.operation_id AS operation_id_163, t159.oblige_id AS oblige_id_164 FROM OffreProjet t0 LEFT JOIN OffreProjetValidation t91 ON t91.offre_id = t0.id LEFT JOIN `Lead` t105 ON t105.offre_id = t0.id LEFT JOIN PaymentMpr t131 ON t131.offreProjet_id = t0.id LEFT JOIN JustificatifPerformanceEnergetique t145 ON t145.offreProjet_id = t0.id LEFT JOIN Recensement t159 ON t159.offreProjet_id = t0.id WHERE t0.token = 'zWifXFC7jHG70HANXfmH6gUQUT78DZdqFsRLkQQKIB4' LIMIT 1;
3	0.98 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: [`453248`] 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 = 453248;
4	1.08 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.end_zni_date AS end_zni_date_36, t0.globalConfigurationHash AS globalConfigurationHash_37, t0.zni AS zni_38, t0.cdp_eligible AS cdp_eligible_39, t0.simulateur_id AS simulateur_id_40, t0.arrete_id AS arrete_id_41, t0.certification_id AS certification_id_42, t0.qualification_id AS qualification_id_43, t0.formConfigEngine_id AS formConfigEngine_id_44 FROM Operation t0 WHERE t0.id = ? Parameters: [`1054`] 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.end_zni_date AS end_zni_date_36, t0.globalConfigurationHash AS globalConfigurationHash_37, t0.zni AS zni_38, t0.cdp_eligible AS cdp_eligible_39, t0.simulateur_id AS simulateur_id_40, t0.arrete_id AS arrete_id_41, t0.certification_id AS certification_id_42, t0.qualification_id AS qualification_id_43, t0.formConfigEngine_id AS formConfigEngine_id_44 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.end_zni_date AS end_zni_date_36, t0.globalConfigurationHash AS globalConfigurationHash_37, t0.zni AS zni_38, t0.cdp_eligible AS cdp_eligible_39, t0.simulateur_id AS simulateur_id_40, t0.arrete_id AS arrete_id_41, t0.certification_id AS certification_id_42, t0.qualification_id AS qualification_id_43, t0.formConfigEngine_id AS formConfigEngine_id_44 FROM Operation t0 WHERE t0.id = 1054;
5	1.38 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.end_zni_date AS end_zni_date_47, t11.globalConfigurationHash AS globalConfigurationHash_48, t11.zni AS zni_49, t11.cdp_eligible AS cdp_eligible_50, t11.simulateur_id AS simulateur_id_51, t11.arrete_id AS arrete_id_52, t11.certification_id AS certification_id_53, t11.qualification_id AS qualification_id_54, t11.formConfigEngine_id AS formConfigEngine_id_55, t0.secteur_id AS secteur_id_56, t0.categorie_id AS categorie_id_57, t0.categorieCd_id AS categorieCd_id_58, t0.type_operation_id AS type_operation_id_59, t0.operation_specifique_id AS operation_specifique_id_60, t61.id AS id_62, t61.mode AS mode_63, t61.targetType AS targetType_64, t61.classic AS classic_65, t61.preca AS preca_66, t61.enable AS enable_67, t61.raiType AS raiType_68, t61.contractSignedElectronically AS contractSignedElectronically_69, t61.pro_signature_mandatory_outlay AS pro_signature_mandatory_outlay_70, t61.obligeTarget_id AS obligeTarget_id_71, t61.teteReseau_id AS teteReseau_id_72, t61.simulateur_id AS simulateur_id_73, t61.installateurTarget_id AS installateurTarget_id_74, t61.beTarget_id AS beTarget_id_75 FROM Simulateur t0 LEFT JOIN Operation t11 ON t0.active_operation_id = t11.id LEFT JOIN AffectationConsoneoRule t61 ON t61.simulateur_id = t0.id WHERE t0.id = ? Parameters: [`440`] 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.end_zni_date AS end_zni_date_47, t11.globalConfigurationHash AS globalConfigurationHash_48, t11.zni AS zni_49, t11.cdp_eligible AS cdp_eligible_50, t11.simulateur_id AS simulateur_id_51, t11.arrete_id AS arrete_id_52, t11.certification_id AS certification_id_53, t11.qualification_id AS qualification_id_54, t11.formConfigEngine_id AS formConfigEngine_id_55, t0.secteur_id AS secteur_id_56, t0.categorie_id AS categorie_id_57, t0.categorieCd_id AS categorieCd_id_58, t0.type_operation_id AS type_operation_id_59, t0.operation_specifique_id AS operation_specifique_id_60, t61.id AS id_62, t61.mode AS mode_63, t61.targetType AS targetType_64, t61.classic AS classic_65, t61.preca AS preca_66, t61.enable AS enable_67, t61.raiType AS raiType_68, t61.contractSignedElectronically AS contractSignedElectronically_69, t61.pro_signature_mandatory_outlay AS pro_signature_mandatory_outlay_70, t61.obligeTarget_id AS obligeTarget_id_71, t61.teteReseau_id AS teteReseau_id_72, t61.simulateur_id AS simulateur_id_73, t61.installateurTarget_id AS installateurTarget_id_74, t61.beTarget_id AS beTarget_id_75 FROM Simulateur t0 LEFT JOIN Operation t11 ON t0.active_operation_id = t11.id LEFT JOIN AffectationConsoneoRule t61 ON t61.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.end_zni_date AS end_zni_date_47, t11.globalConfigurationHash AS globalConfigurationHash_48, t11.zni AS zni_49, t11.cdp_eligible AS cdp_eligible_50, t11.simulateur_id AS simulateur_id_51, t11.arrete_id AS arrete_id_52, t11.certification_id AS certification_id_53, t11.qualification_id AS qualification_id_54, t11.formConfigEngine_id AS formConfigEngine_id_55, t0.secteur_id AS secteur_id_56, t0.categorie_id AS categorie_id_57, t0.categorieCd_id AS categorieCd_id_58, t0.type_operation_id AS type_operation_id_59, t0.operation_specifique_id AS operation_specifique_id_60, t61.id AS id_62, t61.mode AS mode_63, t61.targetType AS targetType_64, t61.classic AS classic_65, t61.preca AS preca_66, t61.enable AS enable_67, t61.raiType AS raiType_68, t61.contractSignedElectronically AS contractSignedElectronically_69, t61.pro_signature_mandatory_outlay AS pro_signature_mandatory_outlay_70, t61.obligeTarget_id AS obligeTarget_id_71, t61.teteReseau_id AS teteReseau_id_72, t61.simulateur_id AS simulateur_id_73, t61.installateurTarget_id AS installateurTarget_id_74, t61.beTarget_id AS beTarget_id_75 FROM Simulateur t0 LEFT JOIN Operation t11 ON t0.active_operation_id = t11.id LEFT JOIN AffectationConsoneoRule t61 ON t61.simulateur_id = t0.id WHERE t0.id = 440;
6	0.83 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: [`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 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 = 2;
7	0.68 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: [`1`] 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 = 1;
8	0.82 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: [`9`] 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 = 9;
9	1.05 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: [`453248`] 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 = 453248 ORDER BY a0_.created_datetime DESC LIMIT 1;
10	0.87 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.47 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.conventionElectronique AS conventionElectronique_32, t0.aftElectronique AS aftElectronique_33, t0.contratInstallateur AS contratInstallateur_34, t0.modeProBeneficiaireInscription AS modeProBeneficiaireInscription_35, t0.modeByPassSuperviseur AS modeByPassSuperviseur_36, t0.`lead` AS lead_37, t0.`leadUrl` AS leadUrl_38, t0.`leadLogin` AS leadLogin_39, t0.`leadPassword` AS leadPassword_40, t0.relanceConventionClientUn AS relanceConventionClientUn_41, t0.relanceConventionClientDeux AS relanceConventionClientDeux_42, t0.alertConventionClient AS alertConventionClient_43, t0.relanceConventionInstallateurUn AS relanceConventionInstallateurUn_44, t0.relanceConventionInstallateurDeux AS relanceConventionInstallateurDeux_45, t0.alertConventionInstallateur AS alertConventionInstallateur_46, t0.conventionFin AS conventionFin_47, t0.questionnaireAftRelanceUn AS questionnaireAftRelanceUn_48, t0.questionnaireAftRelanceDeux AS questionnaireAftRelanceDeux_49, t0.alertQuestionnaireAFT AS alertQuestionnaireAFT_50, t0.questionnaireAftFin AS questionnaireAftFin_51, t0.relanceAftFacture AS relanceAftFacture_52, t0.alertAftFacture AS alertAftFacture_53, t0.aftFactureFin AS aftFactureFin_54, t0.mentionCnil AS mentionCnil_55, t0.serviceType AS serviceType_56, t0.precariteMode AS precariteMode_57, t0.precariteModeProgram AS precariteModeProgram_58, t0.blocked AS blocked_59, t0.blockedSimulation AS blockedSimulation_60, t0.resiliation AS resiliation_61, t0.archivageAuto AS archivageAuto_62, t0.travauxPostDevis AS travauxPostDevis_63, t0.emailFacturationPro AS emailFacturationPro_64, t0.mandatoryInstallateurGenericContract AS mandatoryInstallateurGenericContract_65, t0.hiddenEmail AS hiddenEmail_66, t0.certificallCompanyId AS certificallCompanyId_67, t0.visibilityCommercials AS visibilityCommercials_68, t0.mandat AS mandat_69, t0.pricingMandatClassique AS pricingMandatClassique_70, t0.pricingMandatPreca AS pricingMandatPreca_71, t0.pricingPrimeMaximumMandatClassique AS pricingPrimeMaximumMandatClassique_72, t0.pricingPrimeMaximumMandatPreca AS pricingPrimeMaximumMandatPreca_73, t0.originauxAdresse AS originauxAdresse_74, t0.originauxAdresseComplement AS originauxAdresseComplement_75, t0.originauxCodepostal AS originauxCodepostal_76, t0.originauxVille AS originauxVille_77, t0.eligible AS eligible_78, t0.satisfactionSurvey AS satisfactionSurvey_79, t0.surveyConfiguration AS surveyConfiguration_80, t0.autoPayment AS autoPayment_81, t0.isAnnexeDechetQuestion AS isAnnexeDechetQuestion_82, t0.aiEnabled AS aiEnabled_83, t0.isSignatureAutoAhEnabled AS isSignatureAutoAhEnabled_84, t0.isSignatureAutoOtherDocumentsEnabled AS isSignatureAutoOtherDocumentsEnabled_85, t0.emailVersion AS emailVersion_86, t0.validateBackwards AS validateBackwards_87, t0.displayTelConsoneo AS displayTelConsoneo_88, t0.allowedUniverSign AS allowedUniverSign_89, t0.allowedApplicationFees AS allowedApplicationFees_90, t0.displayApplicationFees AS displayApplicationFees_91, t0.programAutoAllowed AS programAutoAllowed_92, t0.mpr AS mpr_93, t0.isRibActivated AS isRibActivated_94, t0.canonicalTeteReseau_id AS canonicalTeteReseau_id_95, t0.oblige_id AS oblige_id_96, t97.id AS id_98, t97.raison AS raison_99, t97.email AS email_100, t97.tel AS tel_101, t97.site_web AS site_web_102, t97.adresse AS adresse_103, t97.cp AS cp_104, t97.ville AS ville_105, t97.oblige_id AS oblige_id_106, t107.id AS id_108, t107.gender AS gender_109, t107.firstName AS firstName_110, t107.name AS name_111, t107.raison AS raison_112, t107.email AS email_113, t107.tel AS tel_114, t107.address AS address_115, t107.cp AS cp_116, t107.city AS city_117, t107.adminMandate AS adminMandate_118, t107.financialMandate AS financialMandate_119, t107.mixteMandate AS mixteMandate_120, t107.signature AS signature_121, t107.tutorial_admin AS tutorial_admin_122, t107.tutorial_mixte AS tutorial_mixte_123, t107.tutorial_financial AS tutorial_financial_124, t107.oblige_id AS oblige_id_125, t126.id AS id_127, t126.raison AS raison_128, t126.siret AS siret_129, t126.oblige_id AS oblige_id_130 FROM Oblige t0 LEFT JOIN Mediateur t97 ON t97.oblige_id = t0.id LEFT JOIN MprConfig t107 ON t107.oblige_id = t0.id LEFT JOIN Mandataire t126 ON t126.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.conventionElectronique AS conventionElectronique_32, t0.aftElectronique AS aftElectronique_33, t0.contratInstallateur AS contratInstallateur_34, t0.modeProBeneficiaireInscription AS modeProBeneficiaireInscription_35, t0.modeByPassSuperviseur AS modeByPassSuperviseur_36, t0.`lead` AS lead_37, t0.`leadUrl` AS leadUrl_38, t0.`leadLogin` AS leadLogin_39, t0.`leadPassword` AS leadPassword_40, t0.relanceConventionClientUn AS relanceConventionClientUn_41, t0.relanceConventionClientDeux AS relanceConventionClientDeux_42, t0.alertConventionClient AS alertConventionClient_43, t0.relanceConventionInstallateurUn AS relanceConventionInstallateurUn_44, t0.relanceConventionInstallateurDeux AS relanceConventionInstallateurDeux_45, t0.alertConventionInstallateur AS alertConventionInstallateur_46, t0.conventionFin AS conventionFin_47, t0.questionnaireAftRelanceUn AS questionnaireAftRelanceUn_48, t0.questionnaireAftRelanceDeux AS questionnaireAftRelanceDeux_49, t0.alertQuestionnaireAFT AS alertQuestionnaireAFT_50, t0.questionnaireAftFin AS questionnaireAftFin_51, t0.relanceAftFacture AS relanceAftFacture_52, t0.alertAftFacture AS alertAftFacture_53, t0.aftFactureFin AS aftFactureFin_54, t0.mentionCnil AS mentionCnil_55, t0.serviceType AS serviceType_56, t0.precariteMode AS precariteMode_57, t0.precariteModeProgram AS precariteModeProgram_58, t0.blocked AS blocked_59, t0.blockedSimulation AS blockedSimulation_60, t0.resiliation AS resiliation_61, t0.archivageAuto AS archivageAuto_62, t0.travauxPostDevis AS travauxPostDevis_63, t0.emailFacturationPro AS emailFacturationPro_64, t0.mandatoryInstallateurGenericContract AS mandatoryInstallateurGenericContract_65, t0.hiddenEmail AS hiddenEmail_66, t0.certificallCompanyId AS certificallCompanyId_67, t0.visibilityCommercials AS visibilityCommercials_68, t0.mandat AS mandat_69, t0.pricingMandatClassique AS pricingMandatClassique_70, t0.pricingMandatPreca AS pricingMandatPreca_71, t0.pricingPrimeMaximumMandatClassique AS pricingPrimeMaximumMandatClassique_72, t0.pricingPrimeMaximumMandatPreca AS pricingPrimeMaximumMandatPreca_73, t0.originauxAdresse AS originauxAdresse_74, t0.originauxAdresseComplement AS originauxAdresseComplement_75, t0.originauxCodepostal AS originauxCodepostal_76, t0.originauxVille AS originauxVille_77, t0.eligible AS eligible_78, t0.satisfactionSurvey AS satisfactionSurvey_79, t0.surveyConfiguration AS surveyConfiguration_80, t0.autoPayment AS autoPayment_81, t0.isAnnexeDechetQuestion AS isAnnexeDechetQuestion_82, t0.aiEnabled AS aiEnabled_83, t0.isSignatureAutoAhEnabled AS isSignatureAutoAhEnabled_84, t0.isSignatureAutoOtherDocumentsEnabled AS isSignatureAutoOtherDocumentsEnabled_85, t0.emailVersion AS emailVersion_86, t0.validateBackwards AS validateBackwards_87, t0.displayTelConsoneo AS displayTelConsoneo_88, t0.allowedUniverSign AS allowedUniverSign_89, t0.allowedApplicationFees AS allowedApplicationFees_90, t0.displayApplicationFees AS displayApplicationFees_91, t0.programAutoAllowed AS programAutoAllowed_92, t0.mpr AS mpr_93, t0.isRibActivated AS isRibActivated_94, t0.canonicalTeteReseau_id AS canonicalTeteReseau_id_95, t0.oblige_id AS oblige_id_96, t97.id AS id_98, t97.raison AS raison_99, t97.email AS email_100, t97.tel AS tel_101, t97.site_web AS site_web_102, t97.adresse AS adresse_103, t97.cp AS cp_104, t97.ville AS ville_105, t97.oblige_id AS oblige_id_106, t107.id AS id_108, t107.gender AS gender_109, t107.firstName AS firstName_110, t107.name AS name_111, t107.raison AS raison_112, t107.email AS email_113, t107.tel AS tel_114, t107.address AS address_115, t107.cp AS cp_116, t107.city AS city_117, t107.adminMandate AS adminMandate_118, t107.financialMandate AS financialMandate_119, t107.mixteMandate AS mixteMandate_120, t107.signature AS signature_121, t107.tutorial_admin AS tutorial_admin_122, t107.tutorial_mixte AS tutorial_mixte_123, t107.tutorial_financial AS tutorial_financial_124, t107.oblige_id AS oblige_id_125, t126.id AS id_127, t126.raison AS raison_128, t126.siret AS siret_129, t126.oblige_id AS oblige_id_130 FROM Oblige t0 LEFT JOIN Mediateur t97 ON t97.oblige_id = t0.id LEFT JOIN MprConfig t107 ON t107.oblige_id = t0.id LEFT JOIN Mandataire t126 ON t126.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.conventionElectronique AS conventionElectronique_32, t0.aftElectronique AS aftElectronique_33, t0.contratInstallateur AS contratInstallateur_34, t0.modeProBeneficiaireInscription AS modeProBeneficiaireInscription_35, t0.modeByPassSuperviseur AS modeByPassSuperviseur_36, t0.`lead` AS lead_37, t0.`leadUrl` AS leadUrl_38, t0.`leadLogin` AS leadLogin_39, t0.`leadPassword` AS leadPassword_40, t0.relanceConventionClientUn AS relanceConventionClientUn_41, t0.relanceConventionClientDeux AS relanceConventionClientDeux_42, t0.alertConventionClient AS alertConventionClient_43, t0.relanceConventionInstallateurUn AS relanceConventionInstallateurUn_44, t0.relanceConventionInstallateurDeux AS relanceConventionInstallateurDeux_45, t0.alertConventionInstallateur AS alertConventionInstallateur_46, t0.conventionFin AS conventionFin_47, t0.questionnaireAftRelanceUn AS questionnaireAftRelanceUn_48, t0.questionnaireAftRelanceDeux AS questionnaireAftRelanceDeux_49, t0.alertQuestionnaireAFT AS alertQuestionnaireAFT_50, t0.questionnaireAftFin AS questionnaireAftFin_51, t0.relanceAftFacture AS relanceAftFacture_52, t0.alertAftFacture AS alertAftFacture_53, t0.aftFactureFin AS aftFactureFin_54, t0.mentionCnil AS mentionCnil_55, t0.serviceType AS serviceType_56, t0.precariteMode AS precariteMode_57, t0.precariteModeProgram AS precariteModeProgram_58, t0.blocked AS blocked_59, t0.blockedSimulation AS blockedSimulation_60, t0.resiliation AS resiliation_61, t0.archivageAuto AS archivageAuto_62, t0.travauxPostDevis AS travauxPostDevis_63, t0.emailFacturationPro AS emailFacturationPro_64, t0.mandatoryInstallateurGenericContract AS mandatoryInstallateurGenericContract_65, t0.hiddenEmail AS hiddenEmail_66, t0.certificallCompanyId AS certificallCompanyId_67, t0.visibilityCommercials AS visibilityCommercials_68, t0.mandat AS mandat_69, t0.pricingMandatClassique AS pricingMandatClassique_70, t0.pricingMandatPreca AS pricingMandatPreca_71, t0.pricingPrimeMaximumMandatClassique AS pricingPrimeMaximumMandatClassique_72, t0.pricingPrimeMaximumMandatPreca AS pricingPrimeMaximumMandatPreca_73, t0.originauxAdresse AS originauxAdresse_74, t0.originauxAdresseComplement AS originauxAdresseComplement_75, t0.originauxCodepostal AS originauxCodepostal_76, t0.originauxVille AS originauxVille_77, t0.eligible AS eligible_78, t0.satisfactionSurvey AS satisfactionSurvey_79, t0.surveyConfiguration AS surveyConfiguration_80, t0.autoPayment AS autoPayment_81, t0.isAnnexeDechetQuestion AS isAnnexeDechetQuestion_82, t0.aiEnabled AS aiEnabled_83, t0.isSignatureAutoAhEnabled AS isSignatureAutoAhEnabled_84, t0.isSignatureAutoOtherDocumentsEnabled AS isSignatureAutoOtherDocumentsEnabled_85, t0.emailVersion AS emailVersion_86, t0.validateBackwards AS validateBackwards_87, t0.displayTelConsoneo AS displayTelConsoneo_88, t0.allowedUniverSign AS allowedUniverSign_89, t0.allowedApplicationFees AS allowedApplicationFees_90, t0.displayApplicationFees AS displayApplicationFees_91, t0.programAutoAllowed AS programAutoAllowed_92, t0.mpr AS mpr_93, t0.isRibActivated AS isRibActivated_94, t0.canonicalTeteReseau_id AS canonicalTeteReseau_id_95, t0.oblige_id AS oblige_id_96, t97.id AS id_98, t97.raison AS raison_99, t97.email AS email_100, t97.tel AS tel_101, t97.site_web AS site_web_102, t97.adresse AS adresse_103, t97.cp AS cp_104, t97.ville AS ville_105, t97.oblige_id AS oblige_id_106, t107.id AS id_108, t107.gender AS gender_109, t107.firstName AS firstName_110, t107.name AS name_111, t107.raison AS raison_112, t107.email AS email_113, t107.tel AS tel_114, t107.address AS address_115, t107.cp AS cp_116, t107.city AS city_117, t107.adminMandate AS adminMandate_118, t107.financialMandate AS financialMandate_119, t107.mixteMandate AS mixteMandate_120, t107.signature AS signature_121, t107.tutorial_admin AS tutorial_admin_122, t107.tutorial_mixte AS tutorial_mixte_123, t107.tutorial_financial AS tutorial_financial_124, t107.oblige_id AS oblige_id_125, t126.id AS id_127, t126.raison AS raison_128, t126.siret AS siret_129, t126.oblige_id AS oblige_id_130 FROM Oblige t0 LEFT JOIN Mediateur t97 ON t97.oblige_id = t0.id LEFT JOIN MprConfig t107 ON t107.oblige_id = t0.id LEFT JOIN Mandataire t126 ON t126.oblige_id = t0.id WHERE t0.id = 6;
12	1.06 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.email_canonical AS email_canonical_28, t0.username_canonical AS username_canonical_29, t0.oblige_id AS oblige_id_30 FROM ObligeUser t0 WHERE t0.id = ? Parameters: [`247`] 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.email_canonical AS email_canonical_28, t0.username_canonical AS username_canonical_29, t0.oblige_id AS oblige_id_30 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.email_canonical AS email_canonical_28, t0.username_canonical AS username_canonical_29, t0.oblige_id AS oblige_id_30 FROM ObligeUser t0 WHERE t0.id = 247;
13	1.08 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: [`247`] 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 = 247;
14	4.61 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;
15	1.87 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;
16	0.99 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;
17	1.42 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.conventionElectronique AS conventionElectronique_32, t0.aftElectronique AS aftElectronique_33, t0.contratInstallateur AS contratInstallateur_34, t0.modeProBeneficiaireInscription AS modeProBeneficiaireInscription_35, t0.modeByPassSuperviseur AS modeByPassSuperviseur_36, t0.`lead` AS lead_37, t0.`leadUrl` AS leadUrl_38, t0.`leadLogin` AS leadLogin_39, t0.`leadPassword` AS leadPassword_40, t0.relanceConventionClientUn AS relanceConventionClientUn_41, t0.relanceConventionClientDeux AS relanceConventionClientDeux_42, t0.alertConventionClient AS alertConventionClient_43, t0.relanceConventionInstallateurUn AS relanceConventionInstallateurUn_44, t0.relanceConventionInstallateurDeux AS relanceConventionInstallateurDeux_45, t0.alertConventionInstallateur AS alertConventionInstallateur_46, t0.conventionFin AS conventionFin_47, t0.questionnaireAftRelanceUn AS questionnaireAftRelanceUn_48, t0.questionnaireAftRelanceDeux AS questionnaireAftRelanceDeux_49, t0.alertQuestionnaireAFT AS alertQuestionnaireAFT_50, t0.questionnaireAftFin AS questionnaireAftFin_51, t0.relanceAftFacture AS relanceAftFacture_52, t0.alertAftFacture AS alertAftFacture_53, t0.aftFactureFin AS aftFactureFin_54, t0.mentionCnil AS mentionCnil_55, t0.serviceType AS serviceType_56, t0.precariteMode AS precariteMode_57, t0.precariteModeProgram AS precariteModeProgram_58, t0.blocked AS blocked_59, t0.blockedSimulation AS blockedSimulation_60, t0.resiliation AS resiliation_61, t0.archivageAuto AS archivageAuto_62, t0.travauxPostDevis AS travauxPostDevis_63, t0.emailFacturationPro AS emailFacturationPro_64, t0.mandatoryInstallateurGenericContract AS mandatoryInstallateurGenericContract_65, t0.hiddenEmail AS hiddenEmail_66, t0.certificallCompanyId AS certificallCompanyId_67, t0.visibilityCommercials AS visibilityCommercials_68, t0.mandat AS mandat_69, t0.pricingMandatClassique AS pricingMandatClassique_70, t0.pricingMandatPreca AS pricingMandatPreca_71, t0.pricingPrimeMaximumMandatClassique AS pricingPrimeMaximumMandatClassique_72, t0.pricingPrimeMaximumMandatPreca AS pricingPrimeMaximumMandatPreca_73, t0.originauxAdresse AS originauxAdresse_74, t0.originauxAdresseComplement AS originauxAdresseComplement_75, t0.originauxCodepostal AS originauxCodepostal_76, t0.originauxVille AS originauxVille_77, t0.eligible AS eligible_78, t0.satisfactionSurvey AS satisfactionSurvey_79, t0.surveyConfiguration AS surveyConfiguration_80, t0.autoPayment AS autoPayment_81, t0.isAnnexeDechetQuestion AS isAnnexeDechetQuestion_82, t0.aiEnabled AS aiEnabled_83, t0.isSignatureAutoAhEnabled AS isSignatureAutoAhEnabled_84, t0.isSignatureAutoOtherDocumentsEnabled AS isSignatureAutoOtherDocumentsEnabled_85, t0.emailVersion AS emailVersion_86, t0.validateBackwards AS validateBackwards_87, t0.displayTelConsoneo AS displayTelConsoneo_88, t0.allowedUniverSign AS allowedUniverSign_89, t0.allowedApplicationFees AS allowedApplicationFees_90, t0.displayApplicationFees AS displayApplicationFees_91, t0.programAutoAllowed AS programAutoAllowed_92, t0.mpr AS mpr_93, t0.isRibActivated AS isRibActivated_94, t0.canonicalTeteReseau_id AS canonicalTeteReseau_id_95, t0.oblige_id AS oblige_id_96, t97.id AS id_98, t97.raison AS raison_99, t97.email AS email_100, t97.tel AS tel_101, t97.site_web AS site_web_102, t97.adresse AS adresse_103, t97.cp AS cp_104, t97.ville AS ville_105, t97.oblige_id AS oblige_id_106, t107.id AS id_108, t107.gender AS gender_109, t107.firstName AS firstName_110, t107.name AS name_111, t107.raison AS raison_112, t107.email AS email_113, t107.tel AS tel_114, t107.address AS address_115, t107.cp AS cp_116, t107.city AS city_117, t107.adminMandate AS adminMandate_118, t107.financialMandate AS financialMandate_119, t107.mixteMandate AS mixteMandate_120, t107.signature AS signature_121, t107.tutorial_admin AS tutorial_admin_122, t107.tutorial_mixte AS tutorial_mixte_123, t107.tutorial_financial AS tutorial_financial_124, t107.oblige_id AS oblige_id_125, t126.id AS id_127, t126.raison AS raison_128, t126.siret AS siret_129, t126.oblige_id AS oblige_id_130 FROM Oblige t0 LEFT JOIN Mediateur t97 ON t97.oblige_id = t0.id LEFT JOIN MprConfig t107 ON t107.oblige_id = t0.id LEFT JOIN Mandataire t126 ON t126.oblige_id = t0.id WHERE t0.id = ? Parameters: [`2`] 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.conventionElectronique AS conventionElectronique_32, t0.aftElectronique AS aftElectronique_33, t0.contratInstallateur AS contratInstallateur_34, t0.modeProBeneficiaireInscription AS modeProBeneficiaireInscription_35, t0.modeByPassSuperviseur AS modeByPassSuperviseur_36, t0.`lead` AS lead_37, t0.`leadUrl` AS leadUrl_38, t0.`leadLogin` AS leadLogin_39, t0.`leadPassword` AS leadPassword_40, t0.relanceConventionClientUn AS relanceConventionClientUn_41, t0.relanceConventionClientDeux AS relanceConventionClientDeux_42, t0.alertConventionClient AS alertConventionClient_43, t0.relanceConventionInstallateurUn AS relanceConventionInstallateurUn_44, t0.relanceConventionInstallateurDeux AS relanceConventionInstallateurDeux_45, t0.alertConventionInstallateur AS alertConventionInstallateur_46, t0.conventionFin AS conventionFin_47, t0.questionnaireAftRelanceUn AS questionnaireAftRelanceUn_48, t0.questionnaireAftRelanceDeux AS questionnaireAftRelanceDeux_49, t0.alertQuestionnaireAFT AS alertQuestionnaireAFT_50, t0.questionnaireAftFin AS questionnaireAftFin_51, t0.relanceAftFacture AS relanceAftFacture_52, t0.alertAftFacture AS alertAftFacture_53, t0.aftFactureFin AS aftFactureFin_54, t0.mentionCnil AS mentionCnil_55, t0.serviceType AS serviceType_56, t0.precariteMode AS precariteMode_57, t0.precariteModeProgram AS precariteModeProgram_58, t0.blocked AS blocked_59, t0.blockedSimulation AS blockedSimulation_60, t0.resiliation AS resiliation_61, t0.archivageAuto AS archivageAuto_62, t0.travauxPostDevis AS travauxPostDevis_63, t0.emailFacturationPro AS emailFacturationPro_64, t0.mandatoryInstallateurGenericContract AS mandatoryInstallateurGenericContract_65, t0.hiddenEmail AS hiddenEmail_66, t0.certificallCompanyId AS certificallCompanyId_67, t0.visibilityCommercials AS visibilityCommercials_68, t0.mandat AS mandat_69, t0.pricingMandatClassique AS pricingMandatClassique_70, t0.pricingMandatPreca AS pricingMandatPreca_71, t0.pricingPrimeMaximumMandatClassique AS pricingPrimeMaximumMandatClassique_72, t0.pricingPrimeMaximumMandatPreca AS pricingPrimeMaximumMandatPreca_73, t0.originauxAdresse AS originauxAdresse_74, t0.originauxAdresseComplement AS originauxAdresseComplement_75, t0.originauxCodepostal AS originauxCodepostal_76, t0.originauxVille AS originauxVille_77, t0.eligible AS eligible_78, t0.satisfactionSurvey AS satisfactionSurvey_79, t0.surveyConfiguration AS surveyConfiguration_80, t0.autoPayment AS autoPayment_81, t0.isAnnexeDechetQuestion AS isAnnexeDechetQuestion_82, t0.aiEnabled AS aiEnabled_83, t0.isSignatureAutoAhEnabled AS isSignatureAutoAhEnabled_84, t0.isSignatureAutoOtherDocumentsEnabled AS isSignatureAutoOtherDocumentsEnabled_85, t0.emailVersion AS emailVersion_86, t0.validateBackwards AS validateBackwards_87, t0.displayTelConsoneo AS displayTelConsoneo_88, t0.allowedUniverSign AS allowedUniverSign_89, t0.allowedApplicationFees AS allowedApplicationFees_90, t0.displayApplicationFees AS displayApplicationFees_91, t0.programAutoAllowed AS programAutoAllowed_92, t0.mpr AS mpr_93, t0.isRibActivated AS isRibActivated_94, t0.canonicalTeteReseau_id AS canonicalTeteReseau_id_95, t0.oblige_id AS oblige_id_96, t97.id AS id_98, t97.raison AS raison_99, t97.email AS email_100, t97.tel AS tel_101, t97.site_web AS site_web_102, t97.adresse AS adresse_103, t97.cp AS cp_104, t97.ville AS ville_105, t97.oblige_id AS oblige_id_106, t107.id AS id_108, t107.gender AS gender_109, t107.firstName AS firstName_110, t107.name AS name_111, t107.raison AS raison_112, t107.email AS email_113, t107.tel AS tel_114, t107.address AS address_115, t107.cp AS cp_116, t107.city AS city_117, t107.adminMandate AS adminMandate_118, t107.financialMandate AS financialMandate_119, t107.mixteMandate AS mixteMandate_120, t107.signature AS signature_121, t107.tutorial_admin AS tutorial_admin_122, t107.tutorial_mixte AS tutorial_mixte_123, t107.tutorial_financial AS tutorial_financial_124, t107.oblige_id AS oblige_id_125, t126.id AS id_127, t126.raison AS raison_128, t126.siret AS siret_129, t126.oblige_id AS oblige_id_130 FROM Oblige t0 LEFT JOIN Mediateur t97 ON t97.oblige_id = t0.id LEFT JOIN MprConfig t107 ON t107.oblige_id = t0.id LEFT JOIN Mandataire t126 ON t126.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.conventionElectronique AS conventionElectronique_32, t0.aftElectronique AS aftElectronique_33, t0.contratInstallateur AS contratInstallateur_34, t0.modeProBeneficiaireInscription AS modeProBeneficiaireInscription_35, t0.modeByPassSuperviseur AS modeByPassSuperviseur_36, t0.`lead` AS lead_37, t0.`leadUrl` AS leadUrl_38, t0.`leadLogin` AS leadLogin_39, t0.`leadPassword` AS leadPassword_40, t0.relanceConventionClientUn AS relanceConventionClientUn_41, t0.relanceConventionClientDeux AS relanceConventionClientDeux_42, t0.alertConventionClient AS alertConventionClient_43, t0.relanceConventionInstallateurUn AS relanceConventionInstallateurUn_44, t0.relanceConventionInstallateurDeux AS relanceConventionInstallateurDeux_45, t0.alertConventionInstallateur AS alertConventionInstallateur_46, t0.conventionFin AS conventionFin_47, t0.questionnaireAftRelanceUn AS questionnaireAftRelanceUn_48, t0.questionnaireAftRelanceDeux AS questionnaireAftRelanceDeux_49, t0.alertQuestionnaireAFT AS alertQuestionnaireAFT_50, t0.questionnaireAftFin AS questionnaireAftFin_51, t0.relanceAftFacture AS relanceAftFacture_52, t0.alertAftFacture AS alertAftFacture_53, t0.aftFactureFin AS aftFactureFin_54, t0.mentionCnil AS mentionCnil_55, t0.serviceType AS serviceType_56, t0.precariteMode AS precariteMode_57, t0.precariteModeProgram AS precariteModeProgram_58, t0.blocked AS blocked_59, t0.blockedSimulation AS blockedSimulation_60, t0.resiliation AS resiliation_61, t0.archivageAuto AS archivageAuto_62, t0.travauxPostDevis AS travauxPostDevis_63, t0.emailFacturationPro AS emailFacturationPro_64, t0.mandatoryInstallateurGenericContract AS mandatoryInstallateurGenericContract_65, t0.hiddenEmail AS hiddenEmail_66, t0.certificallCompanyId AS certificallCompanyId_67, t0.visibilityCommercials AS visibilityCommercials_68, t0.mandat AS mandat_69, t0.pricingMandatClassique AS pricingMandatClassique_70, t0.pricingMandatPreca AS pricingMandatPreca_71, t0.pricingPrimeMaximumMandatClassique AS pricingPrimeMaximumMandatClassique_72, t0.pricingPrimeMaximumMandatPreca AS pricingPrimeMaximumMandatPreca_73, t0.originauxAdresse AS originauxAdresse_74, t0.originauxAdresseComplement AS originauxAdresseComplement_75, t0.originauxCodepostal AS originauxCodepostal_76, t0.originauxVille AS originauxVille_77, t0.eligible AS eligible_78, t0.satisfactionSurvey AS satisfactionSurvey_79, t0.surveyConfiguration AS surveyConfiguration_80, t0.autoPayment AS autoPayment_81, t0.isAnnexeDechetQuestion AS isAnnexeDechetQuestion_82, t0.aiEnabled AS aiEnabled_83, t0.isSignatureAutoAhEnabled AS isSignatureAutoAhEnabled_84, t0.isSignatureAutoOtherDocumentsEnabled AS isSignatureAutoOtherDocumentsEnabled_85, t0.emailVersion AS emailVersion_86, t0.validateBackwards AS validateBackwards_87, t0.displayTelConsoneo AS displayTelConsoneo_88, t0.allowedUniverSign AS allowedUniverSign_89, t0.allowedApplicationFees AS allowedApplicationFees_90, t0.displayApplicationFees AS displayApplicationFees_91, t0.programAutoAllowed AS programAutoAllowed_92, t0.mpr AS mpr_93, t0.isRibActivated AS isRibActivated_94, t0.canonicalTeteReseau_id AS canonicalTeteReseau_id_95, t0.oblige_id AS oblige_id_96, t97.id AS id_98, t97.raison AS raison_99, t97.email AS email_100, t97.tel AS tel_101, t97.site_web AS site_web_102, t97.adresse AS adresse_103, t97.cp AS cp_104, t97.ville AS ville_105, t97.oblige_id AS oblige_id_106, t107.id AS id_108, t107.gender AS gender_109, t107.firstName AS firstName_110, t107.name AS name_111, t107.raison AS raison_112, t107.email AS email_113, t107.tel AS tel_114, t107.address AS address_115, t107.cp AS cp_116, t107.city AS city_117, t107.adminMandate AS adminMandate_118, t107.financialMandate AS financialMandate_119, t107.mixteMandate AS mixteMandate_120, t107.signature AS signature_121, t107.tutorial_admin AS tutorial_admin_122, t107.tutorial_mixte AS tutorial_mixte_123, t107.tutorial_financial AS tutorial_financial_124, t107.oblige_id AS oblige_id_125, t126.id AS id_127, t126.raison AS raison_128, t126.siret AS siret_129, t126.oblige_id AS oblige_id_130 FROM Oblige t0 LEFT JOIN Mediateur t97 ON t97.oblige_id = t0.id LEFT JOIN MprConfig t107 ON t107.oblige_id = t0.id LEFT JOIN Mandataire t126 ON t126.oblige_id = t0.id WHERE t0.id = 2;
18	1.15 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: [`235477`] 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 = 235477;
19	1.44 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.conventionElectronique AS conventionElectronique_32, t0.aftElectronique AS aftElectronique_33, t0.contratInstallateur AS contratInstallateur_34, t0.modeProBeneficiaireInscription AS modeProBeneficiaireInscription_35, t0.modeByPassSuperviseur AS modeByPassSuperviseur_36, t0.`lead` AS lead_37, t0.`leadUrl` AS leadUrl_38, t0.`leadLogin` AS leadLogin_39, t0.`leadPassword` AS leadPassword_40, t0.relanceConventionClientUn AS relanceConventionClientUn_41, t0.relanceConventionClientDeux AS relanceConventionClientDeux_42, t0.alertConventionClient AS alertConventionClient_43, t0.relanceConventionInstallateurUn AS relanceConventionInstallateurUn_44, t0.relanceConventionInstallateurDeux AS relanceConventionInstallateurDeux_45, t0.alertConventionInstallateur AS alertConventionInstallateur_46, t0.conventionFin AS conventionFin_47, t0.questionnaireAftRelanceUn AS questionnaireAftRelanceUn_48, t0.questionnaireAftRelanceDeux AS questionnaireAftRelanceDeux_49, t0.alertQuestionnaireAFT AS alertQuestionnaireAFT_50, t0.questionnaireAftFin AS questionnaireAftFin_51, t0.relanceAftFacture AS relanceAftFacture_52, t0.alertAftFacture AS alertAftFacture_53, t0.aftFactureFin AS aftFactureFin_54, t0.mentionCnil AS mentionCnil_55, t0.serviceType AS serviceType_56, t0.precariteMode AS precariteMode_57, t0.precariteModeProgram AS precariteModeProgram_58, t0.blocked AS blocked_59, t0.blockedSimulation AS blockedSimulation_60, t0.resiliation AS resiliation_61, t0.archivageAuto AS archivageAuto_62, t0.travauxPostDevis AS travauxPostDevis_63, t0.emailFacturationPro AS emailFacturationPro_64, t0.mandatoryInstallateurGenericContract AS mandatoryInstallateurGenericContract_65, t0.hiddenEmail AS hiddenEmail_66, t0.certificallCompanyId AS certificallCompanyId_67, t0.visibilityCommercials AS visibilityCommercials_68, t0.mandat AS mandat_69, t0.pricingMandatClassique AS pricingMandatClassique_70, t0.pricingMandatPreca AS pricingMandatPreca_71, t0.pricingPrimeMaximumMandatClassique AS pricingPrimeMaximumMandatClassique_72, t0.pricingPrimeMaximumMandatPreca AS pricingPrimeMaximumMandatPreca_73, t0.originauxAdresse AS originauxAdresse_74, t0.originauxAdresseComplement AS originauxAdresseComplement_75, t0.originauxCodepostal AS originauxCodepostal_76, t0.originauxVille AS originauxVille_77, t0.eligible AS eligible_78, t0.satisfactionSurvey AS satisfactionSurvey_79, t0.surveyConfiguration AS surveyConfiguration_80, t0.autoPayment AS autoPayment_81, t0.isAnnexeDechetQuestion AS isAnnexeDechetQuestion_82, t0.aiEnabled AS aiEnabled_83, t0.isSignatureAutoAhEnabled AS isSignatureAutoAhEnabled_84, t0.isSignatureAutoOtherDocumentsEnabled AS isSignatureAutoOtherDocumentsEnabled_85, t0.emailVersion AS emailVersion_86, t0.validateBackwards AS validateBackwards_87, t0.displayTelConsoneo AS displayTelConsoneo_88, t0.allowedUniverSign AS allowedUniverSign_89, t0.allowedApplicationFees AS allowedApplicationFees_90, t0.displayApplicationFees AS displayApplicationFees_91, t0.programAutoAllowed AS programAutoAllowed_92, t0.mpr AS mpr_93, t0.isRibActivated AS isRibActivated_94, t0.canonicalTeteReseau_id AS canonicalTeteReseau_id_95, t0.oblige_id AS oblige_id_96, t97.id AS id_98, t97.raison AS raison_99, t97.email AS email_100, t97.tel AS tel_101, t97.site_web AS site_web_102, t97.adresse AS adresse_103, t97.cp AS cp_104, t97.ville AS ville_105, t97.oblige_id AS oblige_id_106, t107.id AS id_108, t107.gender AS gender_109, t107.firstName AS firstName_110, t107.name AS name_111, t107.raison AS raison_112, t107.email AS email_113, t107.tel AS tel_114, t107.address AS address_115, t107.cp AS cp_116, t107.city AS city_117, t107.adminMandate AS adminMandate_118, t107.financialMandate AS financialMandate_119, t107.mixteMandate AS mixteMandate_120, t107.signature AS signature_121, t107.tutorial_admin AS tutorial_admin_122, t107.tutorial_mixte AS tutorial_mixte_123, t107.tutorial_financial AS tutorial_financial_124, t107.oblige_id AS oblige_id_125, t126.id AS id_127, t126.raison AS raison_128, t126.siret AS siret_129, t126.oblige_id AS oblige_id_130 FROM Oblige t0 LEFT JOIN Mediateur t97 ON t97.oblige_id = t0.id LEFT JOIN MprConfig t107 ON t107.oblige_id = t0.id LEFT JOIN Mandataire t126 ON t126.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.conventionElectronique AS conventionElectronique_32, t0.aftElectronique AS aftElectronique_33, t0.contratInstallateur AS contratInstallateur_34, t0.modeProBeneficiaireInscription AS modeProBeneficiaireInscription_35, t0.modeByPassSuperviseur AS modeByPassSuperviseur_36, t0.`lead` AS lead_37, t0.`leadUrl` AS leadUrl_38, t0.`leadLogin` AS leadLogin_39, t0.`leadPassword` AS leadPassword_40, t0.relanceConventionClientUn AS relanceConventionClientUn_41, t0.relanceConventionClientDeux AS relanceConventionClientDeux_42, t0.alertConventionClient AS alertConventionClient_43, t0.relanceConventionInstallateurUn AS relanceConventionInstallateurUn_44, t0.relanceConventionInstallateurDeux AS relanceConventionInstallateurDeux_45, t0.alertConventionInstallateur AS alertConventionInstallateur_46, t0.conventionFin AS conventionFin_47, t0.questionnaireAftRelanceUn AS questionnaireAftRelanceUn_48, t0.questionnaireAftRelanceDeux AS questionnaireAftRelanceDeux_49, t0.alertQuestionnaireAFT AS alertQuestionnaireAFT_50, t0.questionnaireAftFin AS questionnaireAftFin_51, t0.relanceAftFacture AS relanceAftFacture_52, t0.alertAftFacture AS alertAftFacture_53, t0.aftFactureFin AS aftFactureFin_54, t0.mentionCnil AS mentionCnil_55, t0.serviceType AS serviceType_56, t0.precariteMode AS precariteMode_57, t0.precariteModeProgram AS precariteModeProgram_58, t0.blocked AS blocked_59, t0.blockedSimulation AS blockedSimulation_60, t0.resiliation AS resiliation_61, t0.archivageAuto AS archivageAuto_62, t0.travauxPostDevis AS travauxPostDevis_63, t0.emailFacturationPro AS emailFacturationPro_64, t0.mandatoryInstallateurGenericContract AS mandatoryInstallateurGenericContract_65, t0.hiddenEmail AS hiddenEmail_66, t0.certificallCompanyId AS certificallCompanyId_67, t0.visibilityCommercials AS visibilityCommercials_68, t0.mandat AS mandat_69, t0.pricingMandatClassique AS pricingMandatClassique_70, t0.pricingMandatPreca AS pricingMandatPreca_71, t0.pricingPrimeMaximumMandatClassique AS pricingPrimeMaximumMandatClassique_72, t0.pricingPrimeMaximumMandatPreca AS pricingPrimeMaximumMandatPreca_73, t0.originauxAdresse AS originauxAdresse_74, t0.originauxAdresseComplement AS originauxAdresseComplement_75, t0.originauxCodepostal AS originauxCodepostal_76, t0.originauxVille AS originauxVille_77, t0.eligible AS eligible_78, t0.satisfactionSurvey AS satisfactionSurvey_79, t0.surveyConfiguration AS surveyConfiguration_80, t0.autoPayment AS autoPayment_81, t0.isAnnexeDechetQuestion AS isAnnexeDechetQuestion_82, t0.aiEnabled AS aiEnabled_83, t0.isSignatureAutoAhEnabled AS isSignatureAutoAhEnabled_84, t0.isSignatureAutoOtherDocumentsEnabled AS isSignatureAutoOtherDocumentsEnabled_85, t0.emailVersion AS emailVersion_86, t0.validateBackwards AS validateBackwards_87, t0.displayTelConsoneo AS displayTelConsoneo_88, t0.allowedUniverSign AS allowedUniverSign_89, t0.allowedApplicationFees AS allowedApplicationFees_90, t0.displayApplicationFees AS displayApplicationFees_91, t0.programAutoAllowed AS programAutoAllowed_92, t0.mpr AS mpr_93, t0.isRibActivated AS isRibActivated_94, t0.canonicalTeteReseau_id AS canonicalTeteReseau_id_95, t0.oblige_id AS oblige_id_96, t97.id AS id_98, t97.raison AS raison_99, t97.email AS email_100, t97.tel AS tel_101, t97.site_web AS site_web_102, t97.adresse AS adresse_103, t97.cp AS cp_104, t97.ville AS ville_105, t97.oblige_id AS oblige_id_106, t107.id AS id_108, t107.gender AS gender_109, t107.firstName AS firstName_110, t107.name AS name_111, t107.raison AS raison_112, t107.email AS email_113, t107.tel AS tel_114, t107.address AS address_115, t107.cp AS cp_116, t107.city AS city_117, t107.adminMandate AS adminMandate_118, t107.financialMandate AS financialMandate_119, t107.mixteMandate AS mixteMandate_120, t107.signature AS signature_121, t107.tutorial_admin AS tutorial_admin_122, t107.tutorial_mixte AS tutorial_mixte_123, t107.tutorial_financial AS tutorial_financial_124, t107.oblige_id AS oblige_id_125, t126.id AS id_127, t126.raison AS raison_128, t126.siret AS siret_129, t126.oblige_id AS oblige_id_130 FROM Oblige t0 LEFT JOIN Mediateur t97 ON t97.oblige_id = t0.id LEFT JOIN MprConfig t107 ON t107.oblige_id = t0.id LEFT JOIN Mandataire t126 ON t126.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.conventionElectronique AS conventionElectronique_32, t0.aftElectronique AS aftElectronique_33, t0.contratInstallateur AS contratInstallateur_34, t0.modeProBeneficiaireInscription AS modeProBeneficiaireInscription_35, t0.modeByPassSuperviseur AS modeByPassSuperviseur_36, t0.`lead` AS lead_37, t0.`leadUrl` AS leadUrl_38, t0.`leadLogin` AS leadLogin_39, t0.`leadPassword` AS leadPassword_40, t0.relanceConventionClientUn AS relanceConventionClientUn_41, t0.relanceConventionClientDeux AS relanceConventionClientDeux_42, t0.alertConventionClient AS alertConventionClient_43, t0.relanceConventionInstallateurUn AS relanceConventionInstallateurUn_44, t0.relanceConventionInstallateurDeux AS relanceConventionInstallateurDeux_45, t0.alertConventionInstallateur AS alertConventionInstallateur_46, t0.conventionFin AS conventionFin_47, t0.questionnaireAftRelanceUn AS questionnaireAftRelanceUn_48, t0.questionnaireAftRelanceDeux AS questionnaireAftRelanceDeux_49, t0.alertQuestionnaireAFT AS alertQuestionnaireAFT_50, t0.questionnaireAftFin AS questionnaireAftFin_51, t0.relanceAftFacture AS relanceAftFacture_52, t0.alertAftFacture AS alertAftFacture_53, t0.aftFactureFin AS aftFactureFin_54, t0.mentionCnil AS mentionCnil_55, t0.serviceType AS serviceType_56, t0.precariteMode AS precariteMode_57, t0.precariteModeProgram AS precariteModeProgram_58, t0.blocked AS blocked_59, t0.blockedSimulation AS blockedSimulation_60, t0.resiliation AS resiliation_61, t0.archivageAuto AS archivageAuto_62, t0.travauxPostDevis AS travauxPostDevis_63, t0.emailFacturationPro AS emailFacturationPro_64, t0.mandatoryInstallateurGenericContract AS mandatoryInstallateurGenericContract_65, t0.hiddenEmail AS hiddenEmail_66, t0.certificallCompanyId AS certificallCompanyId_67, t0.visibilityCommercials AS visibilityCommercials_68, t0.mandat AS mandat_69, t0.pricingMandatClassique AS pricingMandatClassique_70, t0.pricingMandatPreca AS pricingMandatPreca_71, t0.pricingPrimeMaximumMandatClassique AS pricingPrimeMaximumMandatClassique_72, t0.pricingPrimeMaximumMandatPreca AS pricingPrimeMaximumMandatPreca_73, t0.originauxAdresse AS originauxAdresse_74, t0.originauxAdresseComplement AS originauxAdresseComplement_75, t0.originauxCodepostal AS originauxCodepostal_76, t0.originauxVille AS originauxVille_77, t0.eligible AS eligible_78, t0.satisfactionSurvey AS satisfactionSurvey_79, t0.surveyConfiguration AS surveyConfiguration_80, t0.autoPayment AS autoPayment_81, t0.isAnnexeDechetQuestion AS isAnnexeDechetQuestion_82, t0.aiEnabled AS aiEnabled_83, t0.isSignatureAutoAhEnabled AS isSignatureAutoAhEnabled_84, t0.isSignatureAutoOtherDocumentsEnabled AS isSignatureAutoOtherDocumentsEnabled_85, t0.emailVersion AS emailVersion_86, t0.validateBackwards AS validateBackwards_87, t0.displayTelConsoneo AS displayTelConsoneo_88, t0.allowedUniverSign AS allowedUniverSign_89, t0.allowedApplicationFees AS allowedApplicationFees_90, t0.displayApplicationFees AS displayApplicationFees_91, t0.programAutoAllowed AS programAutoAllowed_92, t0.mpr AS mpr_93, t0.isRibActivated AS isRibActivated_94, t0.canonicalTeteReseau_id AS canonicalTeteReseau_id_95, t0.oblige_id AS oblige_id_96, t97.id AS id_98, t97.raison AS raison_99, t97.email AS email_100, t97.tel AS tel_101, t97.site_web AS site_web_102, t97.adresse AS adresse_103, t97.cp AS cp_104, t97.ville AS ville_105, t97.oblige_id AS oblige_id_106, t107.id AS id_108, t107.gender AS gender_109, t107.firstName AS firstName_110, t107.name AS name_111, t107.raison AS raison_112, t107.email AS email_113, t107.tel AS tel_114, t107.address AS address_115, t107.cp AS cp_116, t107.city AS city_117, t107.adminMandate AS adminMandate_118, t107.financialMandate AS financialMandate_119, t107.mixteMandate AS mixteMandate_120, t107.signature AS signature_121, t107.tutorial_admin AS tutorial_admin_122, t107.tutorial_mixte AS tutorial_mixte_123, t107.tutorial_financial AS tutorial_financial_124, t107.oblige_id AS oblige_id_125, t126.id AS id_127, t126.raison AS raison_128, t126.siret AS siret_129, t126.oblige_id AS oblige_id_130 FROM Oblige t0 LEFT JOIN Mediateur t97 ON t97.oblige_id = t0.id LEFT JOIN MprConfig t107 ON t107.oblige_id = t0.id LEFT JOIN Mandataire t126 ON t126.oblige_id = t0.id WHERE t0.oblige_id = 6;
20	59.80 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_.reference AS reference_5, o0_.data AS data_6, o0_.cofracData AS cofracData_7, o0_.ip AS ip_8, o0_.offre_auto_date AS offre_auto_date_9, o0_.created_datetime AS created_datetime_10, o0_.updated_datetime AS updated_datetime_11, o0_.tel AS tel_12, o0_.codepostal AS codepostal_13, o0_.adresse AS adresse_14, o0_.adresse_complement AS adresse_complement_15, o0_.ville AS ville_16, o0_.delai_souhaite AS delai_souhaite_17, o0_.accept_recevoir_offre AS accept_recevoir_offre_18, o0_.accept_recommandation AS accept_recommandation_19, o0_.acceptLeadPromo AS acceptLeadPromo_20, o0_.offre_cumac AS offre_cumac_21, o0_.offre_cumac_client AS offre_cumac_client_22, o0_.offre_cumac_precarite AS offre_cumac_precarite_23, o0_.offre_cumac_client_precarite AS offre_cumac_client_precarite_24, o0_.cumac AS cumac_25, o0_.cumac_AFT AS cumac_AFT_26, o0_.total_prime AS total_prime_27, o0_.total_prime_AFT AS total_prime_AFT_28, o0_.prime_pro AS prime_pro_29, o0_.prime_pro_aft AS prime_pro_aft_30, o0_.prime_client AS prime_client_31, o0_.prime_client_aft AS prime_client_aft_32, o0_.cumac_moyenne AS cumac_moyenne_33, o0_.taux_actualise AS taux_actualise_34, o0_.taux_accumule AS taux_accumule_35, o0_.date_debut_chantier AS date_debut_chantier_36, o0_.date_demande_offre AS date_demande_offre_37, o0_.date_fin_chantier AS date_fin_chantier_38, o0_.etat AS etat_39, o0_.status AS status_40, o0_.date_offre AS date_offre_41, o0_.notification_date_chantier AS notification_date_chantier_42, o0_.date_retour_conv AS date_retour_conv_43, o0_.date_validation_conv AS date_validation_conv_44, o0_.date_chantier_renseigne AS date_chantier_renseigne_45, o0_.date_paiement AS date_paiement_46, o0_.date_all_doc_valid AS date_all_doc_valid_47, o0_.date_fin_chantier_repousse AS date_fin_chantier_repousse_48, o0_.date_envoi_questionnaire AS date_envoi_questionnaire_49, o0_.date_edition_questionnaire AS date_edition_questionnaire_50, o0_.date_validation_final AS date_validation_final_51, o0_.date_annulation AS date_annulation_52, o0_.no_click_email_date_chantier AS no_click_email_date_chantier_53, o0_.token AS token_54, o0_.auto_installation AS auto_installation_55, o0_.siret AS siret_56, o0_.cancelReason AS cancelReason_57, o0_.dateCommande AS dateCommande_58, o0_.siteTravaux AS siteTravaux_59, o0_.incitation AS incitation_60, o0_.qualificationRecordDate AS qualificationRecordDate_61, o0_.serviceType AS serviceType_62, o0_.debutChantier AS debutChantier_63, o0_.finChantier AS finChantier_64, o0_.initiateCDP AS initiateCDP_65, o0_.cdp AS cdp_66, o0_.date_last_envoi_convention AS date_last_envoi_convention_67, o0_.programStep AS programStep_68, o0_.devisRestAPayer AS devisRestAPayer_69, o0_.pricingMandatClassique AS pricingMandatClassique_70, o0_.pricingMandatPreca AS pricingMandatPreca_71, o0_.isCOFRAC AS isCOFRAC_72, o0_.applicationFeesPrice AS applicationFeesPrice_73, o0_.attributes AS attributes_74, o0_.exclusive AS exclusive_75, o0_.engineDocumentId AS engineDocumentId_76, o0_.batchOffreProjet_id AS batchOffreProjet_id_77, o0_.entrepriseUser_id AS entrepriseUser_id_78, o0_.installateurUser_id AS installateurUser_id_79, o0_.beUser_id AS beUser_id_80, o0_.entrepriseUserContact_id AS entrepriseUserContact_id_81, o0_.particulierUserContact_id AS particulierUserContact_id_82, o0_.signataireEntreprise_id AS signataireEntreprise_id_83, o0_.signataireInstallateur_id AS signataireInstallateur_id_84, o0_.installateurUserContact_id AS installateurUserContact_id_85, o0_.projet_id AS projet_id_86, o0_.precariteCas2_id AS precariteCas2_id_87, o0_.precarite_id AS precarite_id_88, o0_.state_id AS state_id_89, o0_.oblige_id AS oblige_id_90, o0_.secteurActivite_id AS secteurActivite_id_91, o0_.factureDetail_id AS factureDetail_id_92, o0_.offreStatus_id AS offreStatus_id_93, o0_.identiteBeneficiaire_id AS identiteBeneficiaire_id_94, o0_.identiteInstallateur_id AS identiteInstallateur_id_95, o0_.operation_id AS operation_id_96, o0_.particulierUser_id AS particulierUser_id_97, o0_.qualificationRecord_id AS qualificationRecord_id_98, o0_.sousTraitant_id AS sousTraitant_id_99, o0_.program_id AS program_id_100, o0_.programCommercial_id AS programCommercial_id_101, o0_.programManager_id AS programManager_id_102, o0_.signatureAuto_id AS signatureAuto_id_103, o0_.wasteCenter_id AS wasteCenter_id_104, o0_.waste_id AS waste_id_105, o0_.programAuto_id AS programAuto_id_106, o0_.justificatif_id AS justificatif_id_107, o0_.cappingRule_id AS cappingRule_id_108, o0_.projectOwner_id AS projectOwner_id_109, o0_.project_bundle_id AS project_bundle_id_110, o0_.estate_id AS estate_id_111 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 453248 "[email protected]" "[email protected]" "[email protected]" "[email protected]" "BAR-TH-171%" "BAR-TH-171%" "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_.reference AS reference_5, o0_.data AS data_6, o0_.cofracData AS cofracData_7, o0_.ip AS ip_8, o0_.offre_auto_date AS offre_auto_date_9, o0_.created_datetime AS created_datetime_10, o0_.updated_datetime AS updated_datetime_11, o0_.tel AS tel_12, o0_.codepostal AS codepostal_13, o0_.adresse AS adresse_14, o0_.adresse_complement AS adresse_complement_15, o0_.ville AS ville_16, o0_.delai_souhaite AS delai_souhaite_17, o0_.accept_recevoir_offre AS accept_recevoir_offre_18, o0_.accept_recommandation AS accept_recommandation_19, o0_.acceptLeadPromo AS acceptLeadPromo_20, o0_.offre_cumac AS offre_cumac_21, o0_.offre_cumac_client AS offre_cumac_client_22, o0_.offre_cumac_precarite AS offre_cumac_precarite_23, o0_.offre_cumac_client_precarite AS offre_cumac_client_precarite_24, o0_.cumac AS cumac_25, o0_.cumac_AFT AS cumac_AFT_26, o0_.total_prime AS total_prime_27, o0_.total_prime_AFT AS total_prime_AFT_28, o0_.prime_pro AS prime_pro_29, o0_.prime_pro_aft AS prime_pro_aft_30, o0_.prime_client AS prime_client_31, o0_.prime_client_aft AS prime_client_aft_32, o0_.cumac_moyenne AS cumac_moyenne_33, o0_.taux_actualise AS taux_actualise_34, o0_.taux_accumule AS taux_accumule_35, o0_.date_debut_chantier AS date_debut_chantier_36, o0_.date_demande_offre AS date_demande_offre_37, o0_.date_fin_chantier AS date_fin_chantier_38, o0_.etat AS etat_39, o0_.status AS status_40, o0_.date_offre AS date_offre_41, o0_.notification_date_chantier AS notification_date_chantier_42, o0_.date_retour_conv AS date_retour_conv_43, o0_.date_validation_conv AS date_validation_conv_44, o0_.date_chantier_renseigne AS date_chantier_renseigne_45, o0_.date_paiement AS date_paiement_46, o0_.date_all_doc_valid AS date_all_doc_valid_47, o0_.date_fin_chantier_repousse AS date_fin_chantier_repousse_48, o0_.date_envoi_questionnaire AS date_envoi_questionnaire_49, o0_.date_edition_questionnaire AS date_edition_questionnaire_50, o0_.date_validation_final AS date_validation_final_51, o0_.date_annulation AS date_annulation_52, o0_.no_click_email_date_chantier AS no_click_email_date_chantier_53, o0_.token AS token_54, o0_.auto_installation AS auto_installation_55, o0_.siret AS siret_56, o0_.cancelReason AS cancelReason_57, o0_.dateCommande AS dateCommande_58, o0_.siteTravaux AS siteTravaux_59, o0_.incitation AS incitation_60, o0_.qualificationRecordDate AS qualificationRecordDate_61, o0_.serviceType AS serviceType_62, o0_.debutChantier AS debutChantier_63, o0_.finChantier AS finChantier_64, o0_.initiateCDP AS initiateCDP_65, o0_.cdp AS cdp_66, o0_.date_last_envoi_convention AS date_last_envoi_convention_67, o0_.programStep AS programStep_68, o0_.devisRestAPayer AS devisRestAPayer_69, o0_.pricingMandatClassique AS pricingMandatClassique_70, o0_.pricingMandatPreca AS pricingMandatPreca_71, o0_.isCOFRAC AS isCOFRAC_72, o0_.applicationFeesPrice AS applicationFeesPrice_73, o0_.attributes AS attributes_74, o0_.exclusive AS exclusive_75, o0_.engineDocumentId AS engineDocumentId_76, o0_.batchOffreProjet_id AS batchOffreProjet_id_77, o0_.entrepriseUser_id AS entrepriseUser_id_78, o0_.installateurUser_id AS installateurUser_id_79, o0_.beUser_id AS beUser_id_80, o0_.entrepriseUserContact_id AS entrepriseUserContact_id_81, o0_.particulierUserContact_id AS particulierUserContact_id_82, o0_.signataireEntreprise_id AS signataireEntreprise_id_83, o0_.signataireInstallateur_id AS signataireInstallateur_id_84, o0_.installateurUserContact_id AS installateurUserContact_id_85, o0_.projet_id AS projet_id_86, o0_.precariteCas2_id AS precariteCas2_id_87, o0_.precarite_id AS precarite_id_88, o0_.state_id AS state_id_89, o0_.oblige_id AS oblige_id_90, o0_.secteurActivite_id AS secteurActivite_id_91, o0_.factureDetail_id AS factureDetail_id_92, o0_.offreStatus_id AS offreStatus_id_93, o0_.identiteBeneficiaire_id AS identiteBeneficiaire_id_94, o0_.identiteInstallateur_id AS identiteInstallateur_id_95, o0_.operation_id AS operation_id_96, o0_.particulierUser_id AS particulierUser_id_97, o0_.qualificationRecord_id AS qualificationRecord_id_98, o0_.sousTraitant_id AS sousTraitant_id_99, o0_.program_id AS program_id_100, o0_.programCommercial_id AS programCommercial_id_101, o0_.programManager_id AS programManager_id_102, o0_.signatureAuto_id AS signatureAuto_id_103, o0_.wasteCenter_id AS wasteCenter_id_104, o0_.waste_id AS waste_id_105, o0_.programAuto_id AS programAuto_id_106, o0_.justificatif_id AS justificatif_id_107, o0_.cappingRule_id AS cappingRule_id_108, o0_.projectOwner_id AS projectOwner_id_109, o0_.project_bundle_id AS project_bundle_id_110, o0_.estate_id AS estate_id_111 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_.reference AS reference_5, o0_.data AS data_6, o0_.cofracData AS cofracData_7, o0_.ip AS ip_8, o0_.offre_auto_date AS offre_auto_date_9, o0_.created_datetime AS created_datetime_10, o0_.updated_datetime AS updated_datetime_11, o0_.tel AS tel_12, o0_.codepostal AS codepostal_13, o0_.adresse AS adresse_14, o0_.adresse_complement AS adresse_complement_15, o0_.ville AS ville_16, o0_.delai_souhaite AS delai_souhaite_17, o0_.accept_recevoir_offre AS accept_recevoir_offre_18, o0_.accept_recommandation AS accept_recommandation_19, o0_.acceptLeadPromo AS acceptLeadPromo_20, o0_.offre_cumac AS offre_cumac_21, o0_.offre_cumac_client AS offre_cumac_client_22, o0_.offre_cumac_precarite AS offre_cumac_precarite_23, o0_.offre_cumac_client_precarite AS offre_cumac_client_precarite_24, o0_.cumac AS cumac_25, o0_.cumac_AFT AS cumac_AFT_26, o0_.total_prime AS total_prime_27, o0_.total_prime_AFT AS total_prime_AFT_28, o0_.prime_pro AS prime_pro_29, o0_.prime_pro_aft AS prime_pro_aft_30, o0_.prime_client AS prime_client_31, o0_.prime_client_aft AS prime_client_aft_32, o0_.cumac_moyenne AS cumac_moyenne_33, o0_.taux_actualise AS taux_actualise_34, o0_.taux_accumule AS taux_accumule_35, o0_.date_debut_chantier AS date_debut_chantier_36, o0_.date_demande_offre AS date_demande_offre_37, o0_.date_fin_chantier AS date_fin_chantier_38, o0_.etat AS etat_39, o0_.status AS status_40, o0_.date_offre AS date_offre_41, o0_.notification_date_chantier AS notification_date_chantier_42, o0_.date_retour_conv AS date_retour_conv_43, o0_.date_validation_conv AS date_validation_conv_44, o0_.date_chantier_renseigne AS date_chantier_renseigne_45, o0_.date_paiement AS date_paiement_46, o0_.date_all_doc_valid AS date_all_doc_valid_47, o0_.date_fin_chantier_repousse AS date_fin_chantier_repousse_48, o0_.date_envoi_questionnaire AS date_envoi_questionnaire_49, o0_.date_edition_questionnaire AS date_edition_questionnaire_50, o0_.date_validation_final AS date_validation_final_51, o0_.date_annulation AS date_annulation_52, o0_.no_click_email_date_chantier AS no_click_email_date_chantier_53, o0_.token AS token_54, o0_.auto_installation AS auto_installation_55, o0_.siret AS siret_56, o0_.cancelReason AS cancelReason_57, o0_.dateCommande AS dateCommande_58, o0_.siteTravaux AS siteTravaux_59, o0_.incitation AS incitation_60, o0_.qualificationRecordDate AS qualificationRecordDate_61, o0_.serviceType AS serviceType_62, o0_.debutChantier AS debutChantier_63, o0_.finChantier AS finChantier_64, o0_.initiateCDP AS initiateCDP_65, o0_.cdp AS cdp_66, o0_.date_last_envoi_convention AS date_last_envoi_convention_67, o0_.programStep AS programStep_68, o0_.devisRestAPayer AS devisRestAPayer_69, o0_.pricingMandatClassique AS pricingMandatClassique_70, o0_.pricingMandatPreca AS pricingMandatPreca_71, o0_.isCOFRAC AS isCOFRAC_72, o0_.applicationFeesPrice AS applicationFeesPrice_73, o0_.attributes AS attributes_74, o0_.exclusive AS exclusive_75, o0_.engineDocumentId AS engineDocumentId_76, o0_.batchOffreProjet_id AS batchOffreProjet_id_77, o0_.entrepriseUser_id AS entrepriseUser_id_78, o0_.installateurUser_id AS installateurUser_id_79, o0_.beUser_id AS beUser_id_80, o0_.entrepriseUserContact_id AS entrepriseUserContact_id_81, o0_.particulierUserContact_id AS particulierUserContact_id_82, o0_.signataireEntreprise_id AS signataireEntreprise_id_83, o0_.signataireInstallateur_id AS signataireInstallateur_id_84, o0_.installateurUserContact_id AS installateurUserContact_id_85, o0_.projet_id AS projet_id_86, o0_.precariteCas2_id AS precariteCas2_id_87, o0_.precarite_id AS precarite_id_88, o0_.state_id AS state_id_89, o0_.oblige_id AS oblige_id_90, o0_.secteurActivite_id AS secteurActivite_id_91, o0_.factureDetail_id AS factureDetail_id_92, o0_.offreStatus_id AS offreStatus_id_93, o0_.identiteBeneficiaire_id AS identiteBeneficiaire_id_94, o0_.identiteInstallateur_id AS identiteInstallateur_id_95, o0_.operation_id AS operation_id_96, o0_.particulierUser_id AS particulierUser_id_97, o0_.qualificationRecord_id AS qualificationRecord_id_98, o0_.sousTraitant_id AS sousTraitant_id_99, o0_.program_id AS program_id_100, o0_.programCommercial_id AS programCommercial_id_101, o0_.programManager_id AS programManager_id_102, o0_.signatureAuto_id AS signatureAuto_id_103, o0_.wasteCenter_id AS wasteCenter_id_104, o0_.waste_id AS waste_id_105, o0_.programAuto_id AS programAuto_id_106, o0_.justificatif_id AS justificatif_id_107, o0_.cappingRule_id AS cappingRule_id_108, o0_.projectOwner_id AS projectOwner_id_109, o0_.project_bundle_id AS project_bundle_id_110, o0_.estate_id AS estate_id_111 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 <> 453248 AND (e1_.username = '[email protected]' OR p2_.username = '[email protected]' OR e3_.username = '[email protected]' OR p4_.username = '[email protected]') AND (o7_.nom LIKE 'BAR-TH-171%' OR o6_.nom LIKE 'BAR-TH-171%') 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	690
Consoneo\Bundle\UserBundle\Entity\TeteReseau	80
Consoneo\Bundle\UserBundle\Entity\ObligeRole	18
Consoneo\Bundle\UserBundle\Entity\Oblige	4
Consoneo\Bundle\UserBundle\Entity\ObligeUser	2
Consoneo\Bundle\UserBundle\Entity\Identite	2
Consoneo\Bundle\ObligeBundle\Entity\MprConfig	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\FactureDetail	1
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetStatus	1
Consoneo\Bundle\SimulateurBundle\Entity\Operation	1
Consoneo\Bundle\UserBundle\Entity\QualificationRecord	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\UserBundle\Entity\Precarite\Cas1	1
Consoneo\Bundle\ObligeBundle\Entity\IntegrationModule	1

read entity manager

Class	Amount of managed objects
Consoneo\Bundle\ObligeBundle\Entity\Arrete	43
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-electra.dossier-c2e.fr/_fragment?_path=_format%3Dhtml%26_locale%3Dfr%26_controller%3DConsoneo%255CBundle%255CObligeBundle%255CController%2…

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