Symfony Profiler

Query Metrics

19 Database Queries

19 Different statements

71.69 ms Query time

1 Invalid entities

68 Managed entities

0 Cache hits

0 Cache misses

0 Cache puts

Queries

Group similar statements

default connection


SELECT t0.id AS id_1, t0.email AS email_2, t0.enabled AS enabled_3, t0.salt AS salt_4, t0.password AS password_5, t0.last_login AS last_login_6, t0.confirmation_token AS confirmation_token_7, t0.password_requested_at AS password_requested_at_8, t0.roles AS roles_9, t0.username AS username_10, t0.nom AS nom_11, t0.prenom AS prenom_12, t0.fonction AS fonction_13, t0.tel AS tel_14, t0.mobile AS mobile_15, t0.activation AS activation_16, t0.createdAt AS createdAt_17, t0.updatedAt AS updatedAt_18, t0.optin AS optin_19, t0.dateActivation AS dateActivation_20, t0.emailValidatedDateTime AS emailValidatedDateTime_21, t0.emailCreatedDateTime AS emailCreatedDateTime_22, t0.mobileCreatedDatetime AS mobileCreatedDatetime_23, t0.sendEmail AS sendEmail_24, t0.scope AS scope_25, t0.isArchived AS isArchived_26, t0.import AS import_27, t0.neoSpaceEnabled AS neoSpaceEnabled_28, t0.email_canonical AS email_canonical_29, t0.username_canonical AS username_canonical_30, t0.oblige_id AS oblige_id_31 FROM ObligeUser t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.type AS type_2, t0.pricingType AS pricingType_3, t0.finalisationRequested AS finalisationRequested_4, t0.finalisationRequestDate AS finalisationRequestDate_5, t0.cofracSatisfyDate AS cofracSatisfyDate_6, t0.reference AS reference_7, t0.data AS data_8, t0.cofracData AS cofracData_9, t0.cofracEngineDocumentId AS cofracEngineDocumentId_10, t0.ip AS ip_11, t0.offre_auto_date AS offre_auto_date_12, t0.created_datetime AS created_datetime_13, t0.updated_datetime AS updated_datetime_14, t0.tel AS tel_15, t0.codepostal AS codepostal_16, t0.adresse AS adresse_17, t0.adresse_complement AS adresse_complement_18, t0.ville AS ville_19, t0.delai_souhaite AS delai_souhaite_20, t0.accept_recevoir_offre AS accept_recevoir_offre_21, t0.accept_recommandation AS accept_recommandation_22, t0.acceptLeadPromo AS acceptLeadPromo_23, t0.offre_cumac AS offre_cumac_24, t0.offre_cumac_client AS offre_cumac_client_25, t0.offre_cumac_precarite AS offre_cumac_precarite_26, t0.offre_cumac_client_precarite AS offre_cumac_client_precarite_27, t0.cumac AS cumac_28, t0.cumac_AFT AS cumac_AFT_29, t0.total_prime AS total_prime_30, t0.total_prime_AFT AS total_prime_AFT_31, t0.prime_pro AS prime_pro_32, t0.prime_pro_aft AS prime_pro_aft_33, t0.prime_client AS prime_client_34, t0.prime_client_aft AS prime_client_aft_35, t0.cumac_moyenne AS cumac_moyenne_36, t0.taux_actualise AS taux_actualise_37, t0.taux_accumule AS taux_accumule_38, t0.date_debut_chantier AS date_debut_chantier_39, t0.date_demande_offre AS date_demande_offre_40, t0.date_fin_chantier AS date_fin_chantier_41, t0.etat AS etat_42, t0.status AS status_43, t0.date_offre AS date_offre_44, t0.notification_date_chantier AS notification_date_chantier_45, t0.date_retour_conv AS date_retour_conv_46, t0.date_validation_conv AS date_validation_conv_47, t0.date_chantier_renseigne AS date_chantier_renseigne_48, t0.date_paiement AS date_paiement_49, t0.date_all_doc_valid AS date_all_doc_valid_50, t0.date_fin_chantier_repousse AS date_fin_chantier_repousse_51, t0.date_envoi_questionnaire AS date_envoi_questionnaire_52, t0.date_edition_questionnaire AS date_edition_questionnaire_53, t0.date_validation_final AS date_validation_final_54, t0.date_annulation AS date_annulation_55, t0.no_click_email_date_chantier AS no_click_email_date_chantier_56, t0.token AS token_57, t0.auto_installation AS auto_installation_58, t0.siret AS siret_59, t0.cancelReason AS cancelReason_60, t0.dateCommande AS dateCommande_61, t0.siteTravaux AS siteTravaux_62, t0.incitation AS incitation_63, t0.qualificationRecordDate AS qualificationRecordDate_64, t0.serviceType AS serviceType_65, t0.debutChantier AS debutChantier_66, t0.finChantier AS finChantier_67, t0.initiateCDP AS initiateCDP_68, t0.cdp AS cdp_69, t0.date_last_envoi_convention AS date_last_envoi_convention_70, t0.programStep AS programStep_71, t0.devisRestAPayer AS devisRestAPayer_72, t0.pricingMandatClassique AS pricingMandatClassique_73, t0.pricingMandatPreca AS pricingMandatPreca_74, t0.isCOFRAC AS isCOFRAC_75, t0.applicationFeesPrice AS applicationFeesPrice_76, t0.attributes AS attributes_77, t0.exclusive AS exclusive_78, t0.engineDocumentId AS engineDocumentId_79, t0.adresseTravaux AS adresseTravaux_80, t0.adresseTravauxCommentaire AS adresseTravauxCommentaire_81, t0.batchOffreProjet_id AS batchOffreProjet_id_82, t0.entrepriseUser_id AS entrepriseUser_id_83, t0.installateurUser_id AS installateurUser_id_84, t0.beUser_id AS beUser_id_85, t0.entrepriseUserContact_id AS entrepriseUserContact_id_86, t0.particulierUserContact_id AS particulierUserContact_id_87, t0.signataireEntreprise_id AS signataireEntreprise_id_88, t0.signataireInstallateur_id AS signataireInstallateur_id_89, t0.installateurUserContact_id AS installateurUserContact_id_90, t0.projet_id AS projet_id_91, t0.precariteCas2_id AS precariteCas2_id_92, t0.creditNoteContract_id AS creditNoteContract_id_93, t0.precarite_id AS precarite_id_94, t0.state_id AS state_id_95, t96.id AS id_97, t96.created_datetime AS created_datetime_98, t96.convention AS convention_99, t96.aft AS aft_100, t96.facture AS facture_101, t96.beneficiaire AS beneficiaire_102, t96.installateur AS installateur_103, t96.doc_obligatoire AS doc_obligatoire_104, t96.coherence_dossier AS coherence_dossier_105, t96.offre_id AS offre_id_106, t0.oblige_id AS oblige_id_107, t0.secteurActivite_id AS secteurActivite_id_108, t0.factureDetail_id AS factureDetail_id_109, t110.id AS id_111, t110.reference AS reference_112, t110.type AS type_113, t110.result AS result_114, t110.errors AS errors_115, t110.message AS message_116, t110.created_datetime AS created_datetime_117, t110.integrationModule_id AS integrationModule_id_118, t110.offre_id AS offre_id_119, t0.offreStatus_id AS offreStatus_id_120, t0.identiteBeneficiaire_id AS identiteBeneficiaire_id_121, t0.identiteInstallateur_id AS identiteInstallateur_id_122, t0.operation_id AS operation_id_123, t0.particulierUser_id AS particulierUser_id_124, t0.qualificationRecord_id AS qualificationRecord_id_125, t0.sousTraitant_id AS sousTraitant_id_126, t0.program_id AS program_id_127, t0.programCommercial_id AS programCommercial_id_128, t0.programManager_id AS programManager_id_129, t0.signatureAuto_id AS signatureAuto_id_130, t0.wasteCenter_id AS wasteCenter_id_131, t0.waste_id AS waste_id_132, t0.programAuto_id AS programAuto_id_133, t0.justificatif_id AS justificatif_id_134, t0.cappingRule_id AS cappingRule_id_135, t136.id AS id_137, t136.mprUuid AS mprUuid_138, t136.mprReference AS mprReference_139, t136.paymentDate AS paymentDate_140, t136.invoiceReference AS invoiceReference_141, t136.invoiceDate AS invoiceDate_142, t136.amount AS amount_143, t136.archive AS archive_144, t136.step AS step_145, t136.offreProjet_id AS offreProjet_id_146, t136.batchBankTransfer_id AS batchBankTransfer_id_147, t136.installateur_id AS installateur_id_148, t136.particulierUser_id AS particulierUser_id_149, t150.id AS id_151, t150.numero AS numero_152, t150.dateRealisation AS dateRealisation_153, t150.dateFinValidite AS dateFinValidite_154, t150.etiquetteBilan AS etiquetteBilan_155, t150.createdAt AS createdAt_156, t150.updatedAt AS updatedAt_157, t150.typeJustificatif AS typeJustificatif_158, t150.projet_id AS projet_id_159, t150.offreProjet_id AS offreProjet_id_160, t0.projectOwner_id AS projectOwner_id_161, t0.project_bundle_id AS project_bundle_id_162, t0.estate_id AS estate_id_163, t164.id AS id_165, t164.`value` AS value_166, t164.offreProjet_id AS offreProjet_id_167, t164.operation_id AS operation_id_168, t164.oblige_id AS oblige_id_169 FROM OffreProjet t0 LEFT JOIN OffreProjetValidation t96 ON t96.offre_id = t0.id LEFT JOIN `Lead` t110 ON t110.offre_id = t0.id LEFT JOIN PaymentMpr t136 ON t136.offreProjet_id = t0.id LEFT JOIN JustificatifPerformanceEnergetique t150 ON t150.offreProjet_id = t0.id LEFT JOIN Recensement t164 ON t164.offreProjet_id = t0.id WHERE t0.reference = ? LIMIT 1
SELECT t0.id AS id_1, t0.dataSimulation AS dataSimulation_2, t0.dataAH AS dataAH_3, t0.cumac AS cumac_4, t0.tauxActualise AS tauxActualise_5, t0.tauxAccumule AS tauxAccumule_6, t0.cumacMoyenne AS cumacMoyenne_7, t0.initiateCDP AS initiateCDP_8, t0.cofracData AS cofracData_9, t0.operation_id AS operation_id_10, t0.projet_id AS projet_id_11, t0.program_id AS program_id_12, t0.offreProjet_id AS offreProjet_id_13 FROM OperationRecord t0 WHERE t0.offreProjet_id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.version AS version_3, t0.code AS code_4, t0.duree AS duree_5, t0.auto_installation AS auto_installation_6, t0.conditions AS conditions_7, t0.conditionsRaw AS conditionsRaw_8, t0.conditionsFormater AS conditionsFormater_9, t0.documents_requis AS documents_requis_10, t0.nombre_documents AS nombre_documents_11, t0.nombre_conditions AS nombre_conditions_12, t0.question_details_type AS question_details_type_13, t0.question_details_value AS question_details_value_14, t0.periode AS periode_15, t0.informationTechnique AS informationTechnique_16, t0.informationTechniqueRaw AS informationTechniqueRaw_17, t0.informationTechniqueFormater AS informationTechniqueFormater_18, t0.informationDocSupplementaire AS informationDocSupplementaire_19, t0.informationDocSupplementaireRaw AS informationDocSupplementaireRaw_20, t0.informationDocSupplementaireFormater AS informationDocSupplementaireFormater_21, t0.informationfacture AS informationfacture_22, t0.informationfactureRaw AS informationfactureRaw_23, t0.informationfactureFormater AS informationfactureFormater_24, t0.informationfacture2 AS informationfacture2_25, t0.informationfacture2Raw AS informationfacture2Raw_26, t0.informationfacture2Formater AS informationfacture2Formater_27, t0.nbMateriau AS nbMateriau_28, t0.materiauSubtitle AS materiauSubtitle_29, t0.materiauTitle AS materiauTitle_30, t0.textForm AS textForm_31, t0.private AS private_32, t0.campagne AS campagne_33, t0.special AS special_34, t0.abrogation_datetime AS abrogation_datetime_35, t0.date_limite_depot_referencement AS date_limite_depot_referencement_36, t0.end_zni_date AS end_zni_date_37, t0.globalConfigurationHash AS globalConfigurationHash_38, t0.zni AS zni_39, t0.cdp_eligible AS cdp_eligible_40, t0.simulateur_id AS simulateur_id_41, t0.arrete_id AS arrete_id_42, t0.certification_id AS certification_id_43, t0.qualification_id AS qualification_id_44, t0.formConfigEngine_id AS formConfigEngine_id_45 FROM Operation t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.nom AS nom_3, t0.nom_cd AS nom_cd_4, t0.cdiscount AS cdiscount_5, t0.pretty_name AS pretty_name_6, t0.status AS status_7, t0.slug AS slug_8, t0.form_lead_id AS form_lead_id_9, t0.active_operation_id AS active_operation_id_10, t11.id AS id_12, t11.nom AS nom_13, t11.version AS version_14, t11.code AS code_15, t11.duree AS duree_16, t11.auto_installation AS auto_installation_17, t11.conditions AS conditions_18, t11.conditionsRaw AS conditionsRaw_19, t11.conditionsFormater AS conditionsFormater_20, t11.documents_requis AS documents_requis_21, t11.nombre_documents AS nombre_documents_22, t11.nombre_conditions AS nombre_conditions_23, t11.question_details_type AS question_details_type_24, t11.question_details_value AS question_details_value_25, t11.periode AS periode_26, t11.informationTechnique AS informationTechnique_27, t11.informationTechniqueRaw AS informationTechniqueRaw_28, t11.informationTechniqueFormater AS informationTechniqueFormater_29, t11.informationDocSupplementaire AS informationDocSupplementaire_30, t11.informationDocSupplementaireRaw AS informationDocSupplementaireRaw_31, t11.informationDocSupplementaireFormater AS informationDocSupplementaireFormater_32, t11.informationfacture AS informationfacture_33, t11.informationfactureRaw AS informationfactureRaw_34, t11.informationfactureFormater AS informationfactureFormater_35, t11.informationfacture2 AS informationfacture2_36, t11.informationfacture2Raw AS informationfacture2Raw_37, t11.informationfacture2Formater AS informationfacture2Formater_38, t11.nbMateriau AS nbMateriau_39, t11.materiauSubtitle AS materiauSubtitle_40, t11.materiauTitle AS materiauTitle_41, t11.textForm AS textForm_42, t11.private AS private_43, t11.campagne AS campagne_44, t11.special AS special_45, t11.abrogation_datetime AS abrogation_datetime_46, t11.date_limite_depot_referencement AS date_limite_depot_referencement_47, t11.end_zni_date AS end_zni_date_48, t11.globalConfigurationHash AS globalConfigurationHash_49, t11.zni AS zni_50, t11.cdp_eligible AS cdp_eligible_51, t11.simulateur_id AS simulateur_id_52, t11.arrete_id AS arrete_id_53, t11.certification_id AS certification_id_54, t11.qualification_id AS qualification_id_55, t11.formConfigEngine_id AS formConfigEngine_id_56, t0.secteur_id AS secteur_id_57, t0.categorie_id AS categorie_id_58, t0.categorieCd_id AS categorieCd_id_59, t0.type_operation_id AS type_operation_id_60, t0.operation_specifique_id AS operation_specifique_id_61, t62.id AS id_63, t62.mode AS mode_64, t62.targetType AS targetType_65, t62.classic AS classic_66, t62.preca AS preca_67, t62.enable AS enable_68, t62.raiType AS raiType_69, t62.contractSignedElectronically AS contractSignedElectronically_70, t62.pro_signature_mandatory_outlay AS pro_signature_mandatory_outlay_71, t62.obligeTarget_id AS obligeTarget_id_72, t62.teteReseau_id AS teteReseau_id_73, t62.simulateur_id AS simulateur_id_74, t62.installateurTarget_id AS installateurTarget_id_75, t62.beTarget_id AS beTarget_id_76 FROM Simulateur t0 LEFT JOIN Operation t11 ON t0.active_operation_id = t11.id LEFT JOIN AffectationConsoneoRule t62 ON t62.simulateur_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.status AS status_4 FROM Secteur t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.status AS status_4 FROM TypeOperation t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.description AS description_4, t0.status AS status_5, t0.slug AS slug_6, t0.human_title AS human_title_7, t0.position AS position_8 FROM SecteurActivite t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.reference AS reference_3, t0.offre_cumac AS offre_cumac_4, t0.offre_cumac_precarite AS offre_cumac_precarite_5, t0.offre_cumac_client AS offre_cumac_client_6, t0.offre_cumac_client_precarite AS offre_cumac_client_precarite_7, t0.cumac AS cumac_8, t0.total_prime AS total_prime_9, t0.cumac_moyenne AS cumac_moyenne_10, t0.taux_actualise AS taux_actualise_11, t0.taux_accumule AS taux_accumule_12, t0.data AS data_13, t0.ip AS ip_14, t0.created_datetime AS created_datetime_15, t0.prime_pro AS prime_pro_16, t0.prime_client AS prime_client_17, t0.raison AS raison_18, t0.codepostal AS codepostal_19, t0.adresse AS adresse_20, t0.adresse_complement AS adresse_complement_21, t0.ville AS ville_22, t0.delai_souhaite AS delai_souhaite_23, t0.accept_recevoir_offre AS accept_recevoir_offre_24, t0.accept_recommandation AS accept_recommandation_25, t0.status AS status_26, t0.zone AS zone_27, t0.devisValue AS devisValue_28, t0.addressSituation AS addressSituation_29, t0.programStep AS programStep_30, t0.createdAt AS createdAt_31, t0.updatedAt AS updatedAt_32, t0.engineDocumentId AS engineDocumentId_33, t0.simulateur_id AS simulateur_id_34, t35.id AS id_36, t35.reference AS reference_37, t35.nom AS nom_38, t35.nom_cd AS nom_cd_39, t35.cdiscount AS cdiscount_40, t35.pretty_name AS pretty_name_41, t35.status AS status_42, t35.slug AS slug_43, t35.form_lead_id AS form_lead_id_44, t35.active_operation_id AS active_operation_id_45, t35.secteur_id AS secteur_id_46, t35.categorie_id AS categorie_id_47, t35.categorieCd_id AS categorieCd_id_48, t35.type_operation_id AS type_operation_id_49, t35.operation_specifique_id AS operation_specifique_id_50, t0.operation_id AS operation_id_51, t52.id AS id_53, t52.nom AS nom_54, t52.version AS version_55, t52.code AS code_56, t52.duree AS duree_57, t52.auto_installation AS auto_installation_58, t52.conditions AS conditions_59, t52.conditionsRaw AS conditionsRaw_60, t52.conditionsFormater AS conditionsFormater_61, t52.documents_requis AS documents_requis_62, t52.nombre_documents AS nombre_documents_63, t52.nombre_conditions AS nombre_conditions_64, t52.question_details_type AS question_details_type_65, t52.question_details_value AS question_details_value_66, t52.periode AS periode_67, t52.informationTechnique AS informationTechnique_68, t52.informationTechniqueRaw AS informationTechniqueRaw_69, t52.informationTechniqueFormater AS informationTechniqueFormater_70, t52.informationDocSupplementaire AS informationDocSupplementaire_71, t52.informationDocSupplementaireRaw AS informationDocSupplementaireRaw_72, t52.informationDocSupplementaireFormater AS informationDocSupplementaireFormater_73, t52.informationfacture AS informationfacture_74, t52.informationfactureRaw AS informationfactureRaw_75, t52.informationfactureFormater AS informationfactureFormater_76, t52.informationfacture2 AS informationfacture2_77, t52.informationfacture2Raw AS informationfacture2Raw_78, t52.informationfacture2Formater AS informationfacture2Formater_79, t52.nbMateriau AS nbMateriau_80, t52.materiauSubtitle AS materiauSubtitle_81, t52.materiauTitle AS materiauTitle_82, t52.textForm AS textForm_83, t52.private AS private_84, t52.campagne AS campagne_85, t52.special AS special_86, t52.abrogation_datetime AS abrogation_datetime_87, t52.date_limite_depot_referencement AS date_limite_depot_referencement_88, t52.end_zni_date AS end_zni_date_89, t52.globalConfigurationHash AS globalConfigurationHash_90, t52.zni AS zni_91, t52.cdp_eligible AS cdp_eligible_92, t52.simulateur_id AS simulateur_id_93, t52.arrete_id AS arrete_id_94, t52.certification_id AS certification_id_95, t52.qualification_id AS qualification_id_96, t52.formConfigEngine_id AS formConfigEngine_id_97, t0.entrepriseUser_id AS entrepriseUser_id_98, t0.particulierUser_id AS particulierUser_id_99, t0.installateurUser_id AS installateurUser_id_100, t0.beUser_id AS beUser_id_101, t102.id AS id_103, t102.type AS type_104, t102.pricingType AS pricingType_105, t102.finalisationRequested AS finalisationRequested_106, t102.finalisationRequestDate AS finalisationRequestDate_107, t102.cofracSatisfyDate AS cofracSatisfyDate_108, t102.reference AS reference_109, t102.data AS data_110, t102.cofracData AS cofracData_111, t102.cofracEngineDocumentId AS cofracEngineDocumentId_112, t102.ip AS ip_113, t102.offre_auto_date AS offre_auto_date_114, t102.created_datetime AS created_datetime_115, t102.updated_datetime AS updated_datetime_116, t102.tel AS tel_117, t102.codepostal AS codepostal_118, t102.adresse AS adresse_119, t102.adresse_complement AS adresse_complement_120, t102.ville AS ville_121, t102.delai_souhaite AS delai_souhaite_122, t102.accept_recevoir_offre AS accept_recevoir_offre_123, t102.accept_recommandation AS accept_recommandation_124, t102.acceptLeadPromo AS acceptLeadPromo_125, t102.offre_cumac AS offre_cumac_126, t102.offre_cumac_client AS offre_cumac_client_127, t102.offre_cumac_precarite AS offre_cumac_precarite_128, t102.offre_cumac_client_precarite AS offre_cumac_client_precarite_129, t102.cumac AS cumac_130, t102.cumac_AFT AS cumac_AFT_131, t102.total_prime AS total_prime_132, t102.total_prime_AFT AS total_prime_AFT_133, t102.prime_pro AS prime_pro_134, t102.prime_pro_aft AS prime_pro_aft_135, t102.prime_client AS prime_client_136, t102.prime_client_aft AS prime_client_aft_137, t102.cumac_moyenne AS cumac_moyenne_138, t102.taux_actualise AS taux_actualise_139, t102.taux_accumule AS taux_accumule_140, t102.date_debut_chantier AS date_debut_chantier_141, t102.date_demande_offre AS date_demande_offre_142, t102.date_fin_chantier AS date_fin_chantier_143, t102.etat AS etat_144, t102.status AS status_145, t102.date_offre AS date_offre_146, t102.notification_date_chantier AS notification_date_chantier_147, t102.date_retour_conv AS date_retour_conv_148, t102.date_validation_conv AS date_validation_conv_149, t102.date_chantier_renseigne AS date_chantier_renseigne_150, t102.date_paiement AS date_paiement_151, t102.date_all_doc_valid AS date_all_doc_valid_152, t102.date_fin_chantier_repousse AS date_fin_chantier_repousse_153, t102.date_envoi_questionnaire AS date_envoi_questionnaire_154, t102.date_edition_questionnaire AS date_edition_questionnaire_155, t102.date_validation_final AS date_validation_final_156, t102.date_annulation AS date_annulation_157, t102.no_click_email_date_chantier AS no_click_email_date_chantier_158, t102.token AS token_159, t102.auto_installation AS auto_installation_160, t102.siret AS siret_161, t102.cancelReason AS cancelReason_162, t102.dateCommande AS dateCommande_163, t102.siteTravaux AS siteTravaux_164, t102.incitation AS incitation_165, t102.qualificationRecordDate AS qualificationRecordDate_166, t102.serviceType AS serviceType_167, t102.debutChantier AS debutChantier_168, t102.finChantier AS finChantier_169, t102.initiateCDP AS initiateCDP_170, t102.cdp AS cdp_171, t102.date_last_envoi_convention AS date_last_envoi_convention_172, t102.programStep AS programStep_173, t102.devisRestAPayer AS devisRestAPayer_174, t102.pricingMandatClassique AS pricingMandatClassique_175, t102.pricingMandatPreca AS pricingMandatPreca_176, t102.isCOFRAC AS isCOFRAC_177, t102.applicationFeesPrice AS applicationFeesPrice_178, t102.attributes AS attributes_179, t102.exclusive AS exclusive_180, t102.engineDocumentId AS engineDocumentId_181, t102.adresseTravaux AS adresseTravaux_182, t102.adresseTravauxCommentaire AS adresseTravauxCommentaire_183, t102.batchOffreProjet_id AS batchOffreProjet_id_184, t102.entrepriseUser_id AS entrepriseUser_id_185, t102.installateurUser_id AS installateurUser_id_186, t102.beUser_id AS beUser_id_187, t102.entrepriseUserContact_id AS entrepriseUserContact_id_188, t102.particulierUserContact_id AS particulierUserContact_id_189, t102.signataireEntreprise_id AS signataireEntreprise_id_190, t102.signataireInstallateur_id AS signataireInstallateur_id_191, t102.installateurUserContact_id AS installateurUserContact_id_192, t102.projet_id AS projet_id_193, t102.precariteCas2_id AS precariteCas2_id_194, t102.creditNoteContract_id AS creditNoteContract_id_195, t102.precarite_id AS precarite_id_196, t102.state_id AS state_id_197, t102.oblige_id AS oblige_id_198, t102.secteurActivite_id AS secteurActivite_id_199, t102.factureDetail_id AS factureDetail_id_200, t102.offreStatus_id AS offreStatus_id_201, t102.identiteBeneficiaire_id AS identiteBeneficiaire_id_202, t102.identiteInstallateur_id AS identiteInstallateur_id_203, t102.operation_id AS operation_id_204, t102.particulierUser_id AS particulierUser_id_205, t102.qualificationRecord_id AS qualificationRecord_id_206, t102.sousTraitant_id AS sousTraitant_id_207, t102.program_id AS program_id_208, t102.programCommercial_id AS programCommercial_id_209, t102.programManager_id AS programManager_id_210, t102.signatureAuto_id AS signatureAuto_id_211, t102.wasteCenter_id AS wasteCenter_id_212, t102.waste_id AS waste_id_213, t102.programAuto_id AS programAuto_id_214, t102.justificatif_id AS justificatif_id_215, t102.cappingRule_id AS cappingRule_id_216, t102.projectOwner_id AS projectOwner_id_217, t102.project_bundle_id AS project_bundle_id_218, t102.estate_id AS estate_id_219, t0.precarite_id AS precarite_id_220, t0.secteurActivite_id AS secteurActivite_id_221, t0.integrationModule_id AS integrationModule_id_222, t0.precariteCas2_id AS precariteCas2_id_223, t0.program_id AS program_id_224, t0.programCommercial_id AS programCommercial_id_225, t0.programManager_id AS programManager_id_226, t0.justificatif_id AS justificatif_id_227, t228.id AS id_229, t228.numero AS numero_230, t228.dateRealisation AS dateRealisation_231, t228.dateFinValidite AS dateFinValidite_232, t228.etiquetteBilan AS etiquetteBilan_233, t228.createdAt AS createdAt_234, t228.updatedAt AS updatedAt_235, t228.typeJustificatif AS typeJustificatif_236, t228.projet_id AS projet_id_237, t228.offreProjet_id AS offreProjet_id_238, t0.project_bundle_id AS project_bundle_id_239, t0.estate_id AS estate_id_240 FROM Projet t0 LEFT JOIN Simulateur t35 ON t0.simulateur_id = t35.id LEFT JOIN Operation t52 ON t0.operation_id = t52.id LEFT JOIN OffreProjet t102 ON t102.projet_id = t0.id LEFT JOIN JustificatifPerformanceEnergetique t228 ON t228.projet_id = t0.id WHERE t0.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.projet_id = ?
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.suffix AS suffix_2, a0_.effectiveDate AS effectiveDate_3 FROM Arrete a0_ WHERE a0_.effectiveDate <= ? ORDER BY a0_.effectiveDate DESC LIMIT 1
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.suffix AS suffix_2, a0_.effectiveDate AS effectiveDate_3 FROM Arrete a0_ WHERE a0_.effectiveDate <= ? ORDER BY a0_.effectiveDate DESC
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.originalEmailName AS originalEmailName_4, t0.created_datetime AS created_datetime_5, t0.weight AS weight_6, t0.originalNeeded AS originalNeeded_7, t0.allowedUniverSign AS allowedUniverSign_8, t0.description AS description_9 FROM DocumentType t0 WHERE t0.slug = ? LIMIT 1
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 = ?
"START TRANSACTION"
INSERT INTO Cas1 (nbFoyerFiscal, codePostal, situation, createdAt, updatedAt) VALUES (?, ?, ?, ?, ?)
INSERT INTO Justificatif (token, type, source, choice, declared_year, declared_tax_income, nb_people_declared, tax_year, address, zip_code, city, country, nb_dependents, reference_tax_income, nb_tax_parts, address_supplement, doc_iua, createdAt, updatedAt, cas1_id, main_declarant_id, secondAvis_id, campagneUser_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO Document (dateSignatureConvention, dateSignatureAhClient, dateSignatureAhPro, dateSignatureFacture, datePrevisite, noQrDecode, originalName, optionalName, valid, process, decoded, disabled, path, validated_datetime, processed_datetime, created_datetime, updated_datetime, signe, lisible, electronic, thumbnail, reference, stockage, iua, safeId, serviceType, secondJustificatif, imported, dateEditionDevis, ahProElectronic, signataireName, signataireSurname, dateEmission, expirationDate, sienna_id, offre_projets_group, type_id, offreProjet_id, installateurUser_id, justificatif_id, jpe_id, obligeUser_id, obligeUserReal_id, factureDetail_id, contract_id, geolocalisation_id, sousTraitant_id, certilink_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
"COMMIT"

#▲	Time	Info
1	1.34 ms	SELECT t0.id AS id_1, t0.email AS email_2, t0.enabled AS enabled_3, t0.salt AS salt_4, t0.password AS password_5, t0.last_login AS last_login_6, t0.confirmation_token AS confirmation_token_7, t0.password_requested_at AS password_requested_at_8, t0.roles AS roles_9, t0.username AS username_10, t0.nom AS nom_11, t0.prenom AS prenom_12, t0.fonction AS fonction_13, t0.tel AS tel_14, t0.mobile AS mobile_15, t0.activation AS activation_16, t0.createdAt AS createdAt_17, t0.updatedAt AS updatedAt_18, t0.optin AS optin_19, t0.dateActivation AS dateActivation_20, t0.emailValidatedDateTime AS emailValidatedDateTime_21, t0.emailCreatedDateTime AS emailCreatedDateTime_22, t0.mobileCreatedDatetime AS mobileCreatedDatetime_23, t0.sendEmail AS sendEmail_24, t0.scope AS scope_25, t0.isArchived AS isArchived_26, t0.import AS import_27, t0.neoSpaceEnabled AS neoSpaceEnabled_28, t0.email_canonical AS email_canonical_29, t0.username_canonical AS username_canonical_30, t0.oblige_id AS oblige_id_31 FROM ObligeUser t0 WHERE t0.id = ? Parameters: [`44`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.email AS email_2, t0.enabled AS enabled_3, t0.salt AS salt_4, t0.password AS password_5, t0.last_login AS last_login_6, t0.confirmation_token AS confirmation_token_7, t0.password_requested_at AS password_requested_at_8, t0.roles AS roles_9, t0.username AS username_10, t0.nom AS nom_11, t0.prenom AS prenom_12, t0.fonction AS fonction_13, t0.tel AS tel_14, t0.mobile AS mobile_15, t0.activation AS activation_16, t0.createdAt AS createdAt_17, t0.updatedAt AS updatedAt_18, t0.optin AS optin_19, t0.dateActivation AS dateActivation_20, t0.emailValidatedDateTime AS emailValidatedDateTime_21, t0.emailCreatedDateTime AS emailCreatedDateTime_22, t0.mobileCreatedDatetime AS mobileCreatedDatetime_23, t0.sendEmail AS sendEmail_24, t0.scope AS scope_25, t0.isArchived AS isArchived_26, t0.import AS import_27, t0.neoSpaceEnabled AS neoSpaceEnabled_28, t0.email_canonical AS email_canonical_29, t0.username_canonical AS username_canonical_30, t0.oblige_id AS oblige_id_31 FROM ObligeUser t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.email AS email_2, t0.enabled AS enabled_3, t0.salt AS salt_4, t0.password AS password_5, t0.last_login AS last_login_6, t0.confirmation_token AS confirmation_token_7, t0.password_requested_at AS password_requested_at_8, t0.roles AS roles_9, t0.username AS username_10, t0.nom AS nom_11, t0.prenom AS prenom_12, t0.fonction AS fonction_13, t0.tel AS tel_14, t0.mobile AS mobile_15, t0.activation AS activation_16, t0.createdAt AS createdAt_17, t0.updatedAt AS updatedAt_18, t0.optin AS optin_19, t0.dateActivation AS dateActivation_20, t0.emailValidatedDateTime AS emailValidatedDateTime_21, t0.emailCreatedDateTime AS emailCreatedDateTime_22, t0.mobileCreatedDatetime AS mobileCreatedDatetime_23, t0.sendEmail AS sendEmail_24, t0.scope AS scope_25, t0.isArchived AS isArchived_26, t0.import AS import_27, t0.neoSpaceEnabled AS neoSpaceEnabled_28, t0.email_canonical AS email_canonical_29, t0.username_canonical AS username_canonical_30, t0.oblige_id AS oblige_id_31 FROM ObligeUser t0 WHERE t0.id = 44;
2	1.87 ms	SELECT t0.id AS id_1, t0.type AS type_2, t0.pricingType AS pricingType_3, t0.finalisationRequested AS finalisationRequested_4, t0.finalisationRequestDate AS finalisationRequestDate_5, t0.cofracSatisfyDate AS cofracSatisfyDate_6, t0.reference AS reference_7, t0.data AS data_8, t0.cofracData AS cofracData_9, t0.cofracEngineDocumentId AS cofracEngineDocumentId_10, t0.ip AS ip_11, t0.offre_auto_date AS offre_auto_date_12, t0.created_datetime AS created_datetime_13, t0.updated_datetime AS updated_datetime_14, t0.tel AS tel_15, t0.codepostal AS codepostal_16, t0.adresse AS adresse_17, t0.adresse_complement AS adresse_complement_18, t0.ville AS ville_19, t0.delai_souhaite AS delai_souhaite_20, t0.accept_recevoir_offre AS accept_recevoir_offre_21, t0.accept_recommandation AS accept_recommandation_22, t0.acceptLeadPromo AS acceptLeadPromo_23, t0.offre_cumac AS offre_cumac_24, t0.offre_cumac_client AS offre_cumac_client_25, t0.offre_cumac_precarite AS offre_cumac_precarite_26, t0.offre_cumac_client_precarite AS offre_cumac_client_precarite_27, t0.cumac AS cumac_28, t0.cumac_AFT AS cumac_AFT_29, t0.total_prime AS total_prime_30, t0.total_prime_AFT AS total_prime_AFT_31, t0.prime_pro AS prime_pro_32, t0.prime_pro_aft AS prime_pro_aft_33, t0.prime_client AS prime_client_34, t0.prime_client_aft AS prime_client_aft_35, t0.cumac_moyenne AS cumac_moyenne_36, t0.taux_actualise AS taux_actualise_37, t0.taux_accumule AS taux_accumule_38, t0.date_debut_chantier AS date_debut_chantier_39, t0.date_demande_offre AS date_demande_offre_40, t0.date_fin_chantier AS date_fin_chantier_41, t0.etat AS etat_42, t0.status AS status_43, t0.date_offre AS date_offre_44, t0.notification_date_chantier AS notification_date_chantier_45, t0.date_retour_conv AS date_retour_conv_46, t0.date_validation_conv AS date_validation_conv_47, t0.date_chantier_renseigne AS date_chantier_renseigne_48, t0.date_paiement AS date_paiement_49, t0.date_all_doc_valid AS date_all_doc_valid_50, t0.date_fin_chantier_repousse AS date_fin_chantier_repousse_51, t0.date_envoi_questionnaire AS date_envoi_questionnaire_52, t0.date_edition_questionnaire AS date_edition_questionnaire_53, t0.date_validation_final AS date_validation_final_54, t0.date_annulation AS date_annulation_55, t0.no_click_email_date_chantier AS no_click_email_date_chantier_56, t0.token AS token_57, t0.auto_installation AS auto_installation_58, t0.siret AS siret_59, t0.cancelReason AS cancelReason_60, t0.dateCommande AS dateCommande_61, t0.siteTravaux AS siteTravaux_62, t0.incitation AS incitation_63, t0.qualificationRecordDate AS qualificationRecordDate_64, t0.serviceType AS serviceType_65, t0.debutChantier AS debutChantier_66, t0.finChantier AS finChantier_67, t0.initiateCDP AS initiateCDP_68, t0.cdp AS cdp_69, t0.date_last_envoi_convention AS date_last_envoi_convention_70, t0.programStep AS programStep_71, t0.devisRestAPayer AS devisRestAPayer_72, t0.pricingMandatClassique AS pricingMandatClassique_73, t0.pricingMandatPreca AS pricingMandatPreca_74, t0.isCOFRAC AS isCOFRAC_75, t0.applicationFeesPrice AS applicationFeesPrice_76, t0.attributes AS attributes_77, t0.exclusive AS exclusive_78, t0.engineDocumentId AS engineDocumentId_79, t0.adresseTravaux AS adresseTravaux_80, t0.adresseTravauxCommentaire AS adresseTravauxCommentaire_81, t0.batchOffreProjet_id AS batchOffreProjet_id_82, t0.entrepriseUser_id AS entrepriseUser_id_83, t0.installateurUser_id AS installateurUser_id_84, t0.beUser_id AS beUser_id_85, t0.entrepriseUserContact_id AS entrepriseUserContact_id_86, t0.particulierUserContact_id AS particulierUserContact_id_87, t0.signataireEntreprise_id AS signataireEntreprise_id_88, t0.signataireInstallateur_id AS signataireInstallateur_id_89, t0.installateurUserContact_id AS installateurUserContact_id_90, t0.projet_id AS projet_id_91, t0.precariteCas2_id AS precariteCas2_id_92, t0.creditNoteContract_id AS creditNoteContract_id_93, t0.precarite_id AS precarite_id_94, t0.state_id AS state_id_95, t96.id AS id_97, t96.created_datetime AS created_datetime_98, t96.convention AS convention_99, t96.aft AS aft_100, t96.facture AS facture_101, t96.beneficiaire AS beneficiaire_102, t96.installateur AS installateur_103, t96.doc_obligatoire AS doc_obligatoire_104, t96.coherence_dossier AS coherence_dossier_105, t96.offre_id AS offre_id_106, t0.oblige_id AS oblige_id_107, t0.secteurActivite_id AS secteurActivite_id_108, t0.factureDetail_id AS factureDetail_id_109, t110.id AS id_111, t110.reference AS reference_112, t110.type AS type_113, t110.result AS result_114, t110.errors AS errors_115, t110.message AS message_116, t110.created_datetime AS created_datetime_117, t110.integrationModule_id AS integrationModule_id_118, t110.offre_id AS offre_id_119, t0.offreStatus_id AS offreStatus_id_120, t0.identiteBeneficiaire_id AS identiteBeneficiaire_id_121, t0.identiteInstallateur_id AS identiteInstallateur_id_122, t0.operation_id AS operation_id_123, t0.particulierUser_id AS particulierUser_id_124, t0.qualificationRecord_id AS qualificationRecord_id_125, t0.sousTraitant_id AS sousTraitant_id_126, t0.program_id AS program_id_127, t0.programCommercial_id AS programCommercial_id_128, t0.programManager_id AS programManager_id_129, t0.signatureAuto_id AS signatureAuto_id_130, t0.wasteCenter_id AS wasteCenter_id_131, t0.waste_id AS waste_id_132, t0.programAuto_id AS programAuto_id_133, t0.justificatif_id AS justificatif_id_134, t0.cappingRule_id AS cappingRule_id_135, t136.id AS id_137, t136.mprUuid AS mprUuid_138, t136.mprReference AS mprReference_139, t136.paymentDate AS paymentDate_140, t136.invoiceReference AS invoiceReference_141, t136.invoiceDate AS invoiceDate_142, t136.amount AS amount_143, t136.archive AS archive_144, t136.step AS step_145, t136.offreProjet_id AS offreProjet_id_146, t136.batchBankTransfer_id AS batchBankTransfer_id_147, t136.installateur_id AS installateur_id_148, t136.particulierUser_id AS particulierUser_id_149, t150.id AS id_151, t150.numero AS numero_152, t150.dateRealisation AS dateRealisation_153, t150.dateFinValidite AS dateFinValidite_154, t150.etiquetteBilan AS etiquetteBilan_155, t150.createdAt AS createdAt_156, t150.updatedAt AS updatedAt_157, t150.typeJustificatif AS typeJustificatif_158, t150.projet_id AS projet_id_159, t150.offreProjet_id AS offreProjet_id_160, t0.projectOwner_id AS projectOwner_id_161, t0.project_bundle_id AS project_bundle_id_162, t0.estate_id AS estate_id_163, t164.id AS id_165, t164.`value` AS value_166, t164.offreProjet_id AS offreProjet_id_167, t164.operation_id AS operation_id_168, t164.oblige_id AS oblige_id_169 FROM OffreProjet t0 LEFT JOIN OffreProjetValidation t96 ON t96.offre_id = t0.id LEFT JOIN `Lead` t110 ON t110.offre_id = t0.id LEFT JOIN PaymentMpr t136 ON t136.offreProjet_id = t0.id LEFT JOIN JustificatifPerformanceEnergetique t150 ON t150.offreProjet_id = t0.id LEFT JOIN Recensement t164 ON t164.offreProjet_id = t0.id WHERE t0.reference = ? LIMIT 1 Parameters: [`"VEOS1789475612"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.type AS type_2, t0.pricingType AS pricingType_3, t0.finalisationRequested AS finalisationRequested_4, t0.finalisationRequestDate AS finalisationRequestDate_5, t0.cofracSatisfyDate AS cofracSatisfyDate_6, t0.reference AS reference_7, t0.data AS data_8, t0.cofracData AS cofracData_9, t0.cofracEngineDocumentId AS cofracEngineDocumentId_10, t0.ip AS ip_11, t0.offre_auto_date AS offre_auto_date_12, t0.created_datetime AS created_datetime_13, t0.updated_datetime AS updated_datetime_14, t0.tel AS tel_15, t0.codepostal AS codepostal_16, t0.adresse AS adresse_17, t0.adresse_complement AS adresse_complement_18, t0.ville AS ville_19, t0.delai_souhaite AS delai_souhaite_20, t0.accept_recevoir_offre AS accept_recevoir_offre_21, t0.accept_recommandation AS accept_recommandation_22, t0.acceptLeadPromo AS acceptLeadPromo_23, t0.offre_cumac AS offre_cumac_24, t0.offre_cumac_client AS offre_cumac_client_25, t0.offre_cumac_precarite AS offre_cumac_precarite_26, t0.offre_cumac_client_precarite AS offre_cumac_client_precarite_27, t0.cumac AS cumac_28, t0.cumac_AFT AS cumac_AFT_29, t0.total_prime AS total_prime_30, t0.total_prime_AFT AS total_prime_AFT_31, t0.prime_pro AS prime_pro_32, t0.prime_pro_aft AS prime_pro_aft_33, t0.prime_client AS prime_client_34, t0.prime_client_aft AS prime_client_aft_35, t0.cumac_moyenne AS cumac_moyenne_36, t0.taux_actualise AS taux_actualise_37, t0.taux_accumule AS taux_accumule_38, t0.date_debut_chantier AS date_debut_chantier_39, t0.date_demande_offre AS date_demande_offre_40, t0.date_fin_chantier AS date_fin_chantier_41, t0.etat AS etat_42, t0.status AS status_43, t0.date_offre AS date_offre_44, t0.notification_date_chantier AS notification_date_chantier_45, t0.date_retour_conv AS date_retour_conv_46, t0.date_validation_conv AS date_validation_conv_47, t0.date_chantier_renseigne AS date_chantier_renseigne_48, t0.date_paiement AS date_paiement_49, t0.date_all_doc_valid AS date_all_doc_valid_50, t0.date_fin_chantier_repousse AS date_fin_chantier_repousse_51, t0.date_envoi_questionnaire AS date_envoi_questionnaire_52, t0.date_edition_questionnaire AS date_edition_questionnaire_53, t0.date_validation_final AS date_validation_final_54, t0.date_annulation AS date_annulation_55, t0.no_click_email_date_chantier AS no_click_email_date_chantier_56, t0.token AS token_57, t0.auto_installation AS auto_installation_58, t0.siret AS siret_59, t0.cancelReason AS cancelReason_60, t0.dateCommande AS dateCommande_61, t0.siteTravaux AS siteTravaux_62, t0.incitation AS incitation_63, t0.qualificationRecordDate AS qualificationRecordDate_64, t0.serviceType AS serviceType_65, t0.debutChantier AS debutChantier_66, t0.finChantier AS finChantier_67, t0.initiateCDP AS initiateCDP_68, t0.cdp AS cdp_69, t0.date_last_envoi_convention AS date_last_envoi_convention_70, t0.programStep AS programStep_71, t0.devisRestAPayer AS devisRestAPayer_72, t0.pricingMandatClassique AS pricingMandatClassique_73, t0.pricingMandatPreca AS pricingMandatPreca_74, t0.isCOFRAC AS isCOFRAC_75, t0.applicationFeesPrice AS applicationFeesPrice_76, t0.attributes AS attributes_77, t0.exclusive AS exclusive_78, t0.engineDocumentId AS engineDocumentId_79, t0.adresseTravaux AS adresseTravaux_80, t0.adresseTravauxCommentaire AS adresseTravauxCommentaire_81, t0.batchOffreProjet_id AS batchOffreProjet_id_82, t0.entrepriseUser_id AS entrepriseUser_id_83, t0.installateurUser_id AS installateurUser_id_84, t0.beUser_id AS beUser_id_85, t0.entrepriseUserContact_id AS entrepriseUserContact_id_86, t0.particulierUserContact_id AS particulierUserContact_id_87, t0.signataireEntreprise_id AS signataireEntreprise_id_88, t0.signataireInstallateur_id AS signataireInstallateur_id_89, t0.installateurUserContact_id AS installateurUserContact_id_90, t0.projet_id AS projet_id_91, t0.precariteCas2_id AS precariteCas2_id_92, t0.creditNoteContract_id AS creditNoteContract_id_93, t0.precarite_id AS precarite_id_94, t0.state_id AS state_id_95, t96.id AS id_97, t96.created_datetime AS created_datetime_98, t96.convention AS convention_99, t96.aft AS aft_100, t96.facture AS facture_101, t96.beneficiaire AS beneficiaire_102, t96.installateur AS installateur_103, t96.doc_obligatoire AS doc_obligatoire_104, t96.coherence_dossier AS coherence_dossier_105, t96.offre_id AS offre_id_106, t0.oblige_id AS oblige_id_107, t0.secteurActivite_id AS secteurActivite_id_108, t0.factureDetail_id AS factureDetail_id_109, t110.id AS id_111, t110.reference AS reference_112, t110.type AS type_113, t110.result AS result_114, t110.errors AS errors_115, t110.message AS message_116, t110.created_datetime AS created_datetime_117, t110.integrationModule_id AS integrationModule_id_118, t110.offre_id AS offre_id_119, t0.offreStatus_id AS offreStatus_id_120, t0.identiteBeneficiaire_id AS identiteBeneficiaire_id_121, t0.identiteInstallateur_id AS identiteInstallateur_id_122, t0.operation_id AS operation_id_123, t0.particulierUser_id AS particulierUser_id_124, t0.qualificationRecord_id AS qualificationRecord_id_125, t0.sousTraitant_id AS sousTraitant_id_126, t0.program_id AS program_id_127, t0.programCommercial_id AS programCommercial_id_128, t0.programManager_id AS programManager_id_129, t0.signatureAuto_id AS signatureAuto_id_130, t0.wasteCenter_id AS wasteCenter_id_131, t0.waste_id AS waste_id_132, t0.programAuto_id AS programAuto_id_133, t0.justificatif_id AS justificatif_id_134, t0.cappingRule_id AS cappingRule_id_135, t136.id AS id_137, t136.mprUuid AS mprUuid_138, t136.mprReference AS mprReference_139, t136.paymentDate AS paymentDate_140, t136.invoiceReference AS invoiceReference_141, t136.invoiceDate AS invoiceDate_142, t136.amount AS amount_143, t136.archive AS archive_144, t136.step AS step_145, t136.offreProjet_id AS offreProjet_id_146, t136.batchBankTransfer_id AS batchBankTransfer_id_147, t136.installateur_id AS installateur_id_148, t136.particulierUser_id AS particulierUser_id_149, t150.id AS id_151, t150.numero AS numero_152, t150.dateRealisation AS dateRealisation_153, t150.dateFinValidite AS dateFinValidite_154, t150.etiquetteBilan AS etiquetteBilan_155, t150.createdAt AS createdAt_156, t150.updatedAt AS updatedAt_157, t150.typeJustificatif AS typeJustificatif_158, t150.projet_id AS projet_id_159, t150.offreProjet_id AS offreProjet_id_160, t0.projectOwner_id AS projectOwner_id_161, t0.project_bundle_id AS project_bundle_id_162, t0.estate_id AS estate_id_163, t164.id AS id_165, t164.`value` AS value_166, t164.offreProjet_id AS offreProjet_id_167, t164.operation_id AS operation_id_168, t164.oblige_id AS oblige_id_169 FROM OffreProjet t0 LEFT JOIN OffreProjetValidation t96 ON t96.offre_id = t0.id LEFT JOIN `Lead` t110 ON t110.offre_id = t0.id LEFT JOIN PaymentMpr t136 ON t136.offreProjet_id = t0.id LEFT JOIN JustificatifPerformanceEnergetique t150 ON t150.offreProjet_id = t0.id LEFT JOIN Recensement t164 ON t164.offreProjet_id = t0.id WHERE t0.reference = ? LIMIT 1 SELECT t0.id AS id_1, t0.type AS type_2, t0.pricingType AS pricingType_3, t0.finalisationRequested AS finalisationRequested_4, t0.finalisationRequestDate AS finalisationRequestDate_5, t0.cofracSatisfyDate AS cofracSatisfyDate_6, t0.reference AS reference_7, t0.data AS data_8, t0.cofracData AS cofracData_9, t0.cofracEngineDocumentId AS cofracEngineDocumentId_10, t0.ip AS ip_11, t0.offre_auto_date AS offre_auto_date_12, t0.created_datetime AS created_datetime_13, t0.updated_datetime AS updated_datetime_14, t0.tel AS tel_15, t0.codepostal AS codepostal_16, t0.adresse AS adresse_17, t0.adresse_complement AS adresse_complement_18, t0.ville AS ville_19, t0.delai_souhaite AS delai_souhaite_20, t0.accept_recevoir_offre AS accept_recevoir_offre_21, t0.accept_recommandation AS accept_recommandation_22, t0.acceptLeadPromo AS acceptLeadPromo_23, t0.offre_cumac AS offre_cumac_24, t0.offre_cumac_client AS offre_cumac_client_25, t0.offre_cumac_precarite AS offre_cumac_precarite_26, t0.offre_cumac_client_precarite AS offre_cumac_client_precarite_27, t0.cumac AS cumac_28, t0.cumac_AFT AS cumac_AFT_29, t0.total_prime AS total_prime_30, t0.total_prime_AFT AS total_prime_AFT_31, t0.prime_pro AS prime_pro_32, t0.prime_pro_aft AS prime_pro_aft_33, t0.prime_client AS prime_client_34, t0.prime_client_aft AS prime_client_aft_35, t0.cumac_moyenne AS cumac_moyenne_36, t0.taux_actualise AS taux_actualise_37, t0.taux_accumule AS taux_accumule_38, t0.date_debut_chantier AS date_debut_chantier_39, t0.date_demande_offre AS date_demande_offre_40, t0.date_fin_chantier AS date_fin_chantier_41, t0.etat AS etat_42, t0.status AS status_43, t0.date_offre AS date_offre_44, t0.notification_date_chantier AS notification_date_chantier_45, t0.date_retour_conv AS date_retour_conv_46, t0.date_validation_conv AS date_validation_conv_47, t0.date_chantier_renseigne AS date_chantier_renseigne_48, t0.date_paiement AS date_paiement_49, t0.date_all_doc_valid AS date_all_doc_valid_50, t0.date_fin_chantier_repousse AS date_fin_chantier_repousse_51, t0.date_envoi_questionnaire AS date_envoi_questionnaire_52, t0.date_edition_questionnaire AS date_edition_questionnaire_53, t0.date_validation_final AS date_validation_final_54, t0.date_annulation AS date_annulation_55, t0.no_click_email_date_chantier AS no_click_email_date_chantier_56, t0.token AS token_57, t0.auto_installation AS auto_installation_58, t0.siret AS siret_59, t0.cancelReason AS cancelReason_60, t0.dateCommande AS dateCommande_61, t0.siteTravaux AS siteTravaux_62, t0.incitation AS incitation_63, t0.qualificationRecordDate AS qualificationRecordDate_64, t0.serviceType AS serviceType_65, t0.debutChantier AS debutChantier_66, t0.finChantier AS finChantier_67, t0.initiateCDP AS initiateCDP_68, t0.cdp AS cdp_69, t0.date_last_envoi_convention AS date_last_envoi_convention_70, t0.programStep AS programStep_71, t0.devisRestAPayer AS devisRestAPayer_72, t0.pricingMandatClassique AS pricingMandatClassique_73, t0.pricingMandatPreca AS pricingMandatPreca_74, t0.isCOFRAC AS isCOFRAC_75, t0.applicationFeesPrice AS applicationFeesPrice_76, t0.attributes AS attributes_77, t0.exclusive AS exclusive_78, t0.engineDocumentId AS engineDocumentId_79, t0.adresseTravaux AS adresseTravaux_80, t0.adresseTravauxCommentaire AS adresseTravauxCommentaire_81, t0.batchOffreProjet_id AS batchOffreProjet_id_82, t0.entrepriseUser_id AS entrepriseUser_id_83, t0.installateurUser_id AS installateurUser_id_84, t0.beUser_id AS beUser_id_85, t0.entrepriseUserContact_id AS entrepriseUserContact_id_86, t0.particulierUserContact_id AS particulierUserContact_id_87, t0.signataireEntreprise_id AS signataireEntreprise_id_88, t0.signataireInstallateur_id AS signataireInstallateur_id_89, t0.installateurUserContact_id AS installateurUserContact_id_90, t0.projet_id AS projet_id_91, t0.precariteCas2_id AS precariteCas2_id_92, t0.creditNoteContract_id AS creditNoteContract_id_93, t0.precarite_id AS precarite_id_94, t0.state_id AS state_id_95, t96.id AS id_97, t96.created_datetime AS created_datetime_98, t96.convention AS convention_99, t96.aft AS aft_100, t96.facture AS facture_101, t96.beneficiaire AS beneficiaire_102, t96.installateur AS installateur_103, t96.doc_obligatoire AS doc_obligatoire_104, t96.coherence_dossier AS coherence_dossier_105, t96.offre_id AS offre_id_106, t0.oblige_id AS oblige_id_107, t0.secteurActivite_id AS secteurActivite_id_108, t0.factureDetail_id AS factureDetail_id_109, t110.id AS id_111, t110.reference AS reference_112, t110.type AS type_113, t110.result AS result_114, t110.errors AS errors_115, t110.message AS message_116, t110.created_datetime AS created_datetime_117, t110.integrationModule_id AS integrationModule_id_118, t110.offre_id AS offre_id_119, t0.offreStatus_id AS offreStatus_id_120, t0.identiteBeneficiaire_id AS identiteBeneficiaire_id_121, t0.identiteInstallateur_id AS identiteInstallateur_id_122, t0.operation_id AS operation_id_123, t0.particulierUser_id AS particulierUser_id_124, t0.qualificationRecord_id AS qualificationRecord_id_125, t0.sousTraitant_id AS sousTraitant_id_126, t0.program_id AS program_id_127, t0.programCommercial_id AS programCommercial_id_128, t0.programManager_id AS programManager_id_129, t0.signatureAuto_id AS signatureAuto_id_130, t0.wasteCenter_id AS wasteCenter_id_131, t0.waste_id AS waste_id_132, t0.programAuto_id AS programAuto_id_133, t0.justificatif_id AS justificatif_id_134, t0.cappingRule_id AS cappingRule_id_135, t136.id AS id_137, t136.mprUuid AS mprUuid_138, t136.mprReference AS mprReference_139, t136.paymentDate AS paymentDate_140, t136.invoiceReference AS invoiceReference_141, t136.invoiceDate AS invoiceDate_142, t136.amount AS amount_143, t136.archive AS archive_144, t136.step AS step_145, t136.offreProjet_id AS offreProjet_id_146, t136.batchBankTransfer_id AS batchBankTransfer_id_147, t136.installateur_id AS installateur_id_148, t136.particulierUser_id AS particulierUser_id_149, t150.id AS id_151, t150.numero AS numero_152, t150.dateRealisation AS dateRealisation_153, t150.dateFinValidite AS dateFinValidite_154, t150.etiquetteBilan AS etiquetteBilan_155, t150.createdAt AS createdAt_156, t150.updatedAt AS updatedAt_157, t150.typeJustificatif AS typeJustificatif_158, t150.projet_id AS projet_id_159, t150.offreProjet_id AS offreProjet_id_160, t0.projectOwner_id AS projectOwner_id_161, t0.project_bundle_id AS project_bundle_id_162, t0.estate_id AS estate_id_163, t164.id AS id_165, t164.`value` AS value_166, t164.offreProjet_id AS offreProjet_id_167, t164.operation_id AS operation_id_168, t164.oblige_id AS oblige_id_169 FROM OffreProjet t0 LEFT JOIN OffreProjetValidation t96 ON t96.offre_id = t0.id LEFT JOIN `Lead` t110 ON t110.offre_id = t0.id LEFT JOIN PaymentMpr t136 ON t136.offreProjet_id = t0.id LEFT JOIN JustificatifPerformanceEnergetique t150 ON t150.offreProjet_id = t0.id LEFT JOIN Recensement t164 ON t164.offreProjet_id = t0.id WHERE t0.reference = 'VEOS1789475612' LIMIT 1;
3	0.94 ms	SELECT t0.id AS id_1, t0.dataSimulation AS dataSimulation_2, t0.dataAH AS dataAH_3, t0.cumac AS cumac_4, t0.tauxActualise AS tauxActualise_5, t0.tauxAccumule AS tauxAccumule_6, t0.cumacMoyenne AS cumacMoyenne_7, t0.initiateCDP AS initiateCDP_8, t0.cofracData AS cofracData_9, t0.operation_id AS operation_id_10, t0.projet_id AS projet_id_11, t0.program_id AS program_id_12, t0.offreProjet_id AS offreProjet_id_13 FROM OperationRecord t0 WHERE t0.offreProjet_id = ? Parameters: [`1467`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.dataSimulation AS dataSimulation_2, t0.dataAH AS dataAH_3, t0.cumac AS cumac_4, t0.tauxActualise AS tauxActualise_5, t0.tauxAccumule AS tauxAccumule_6, t0.cumacMoyenne AS cumacMoyenne_7, t0.initiateCDP AS initiateCDP_8, t0.cofracData AS cofracData_9, t0.operation_id AS operation_id_10, t0.projet_id AS projet_id_11, t0.program_id AS program_id_12, t0.offreProjet_id AS offreProjet_id_13 FROM OperationRecord t0 WHERE t0.offreProjet_id = ? SELECT t0.id AS id_1, t0.dataSimulation AS dataSimulation_2, t0.dataAH AS dataAH_3, t0.cumac AS cumac_4, t0.tauxActualise AS tauxActualise_5, t0.tauxAccumule AS tauxAccumule_6, t0.cumacMoyenne AS cumacMoyenne_7, t0.initiateCDP AS initiateCDP_8, t0.cofracData AS cofracData_9, t0.operation_id AS operation_id_10, t0.projet_id AS projet_id_11, t0.program_id AS program_id_12, t0.offreProjet_id AS offreProjet_id_13 FROM OperationRecord t0 WHERE t0.offreProjet_id = 1467;
4	1.00 ms	SELECT t0.id AS id_1, t0.nom AS nom_2, t0.version AS version_3, t0.code AS code_4, t0.duree AS duree_5, t0.auto_installation AS auto_installation_6, t0.conditions AS conditions_7, t0.conditionsRaw AS conditionsRaw_8, t0.conditionsFormater AS conditionsFormater_9, t0.documents_requis AS documents_requis_10, t0.nombre_documents AS nombre_documents_11, t0.nombre_conditions AS nombre_conditions_12, t0.question_details_type AS question_details_type_13, t0.question_details_value AS question_details_value_14, t0.periode AS periode_15, t0.informationTechnique AS informationTechnique_16, t0.informationTechniqueRaw AS informationTechniqueRaw_17, t0.informationTechniqueFormater AS informationTechniqueFormater_18, t0.informationDocSupplementaire AS informationDocSupplementaire_19, t0.informationDocSupplementaireRaw AS informationDocSupplementaireRaw_20, t0.informationDocSupplementaireFormater AS informationDocSupplementaireFormater_21, t0.informationfacture AS informationfacture_22, t0.informationfactureRaw AS informationfactureRaw_23, t0.informationfactureFormater AS informationfactureFormater_24, t0.informationfacture2 AS informationfacture2_25, t0.informationfacture2Raw AS informationfacture2Raw_26, t0.informationfacture2Formater AS informationfacture2Formater_27, t0.nbMateriau AS nbMateriau_28, t0.materiauSubtitle AS materiauSubtitle_29, t0.materiauTitle AS materiauTitle_30, t0.textForm AS textForm_31, t0.private AS private_32, t0.campagne AS campagne_33, t0.special AS special_34, t0.abrogation_datetime AS abrogation_datetime_35, t0.date_limite_depot_referencement AS date_limite_depot_referencement_36, t0.end_zni_date AS end_zni_date_37, t0.globalConfigurationHash AS globalConfigurationHash_38, t0.zni AS zni_39, t0.cdp_eligible AS cdp_eligible_40, t0.simulateur_id AS simulateur_id_41, t0.arrete_id AS arrete_id_42, t0.certification_id AS certification_id_43, t0.qualification_id AS qualification_id_44, t0.formConfigEngine_id AS formConfigEngine_id_45 FROM Operation t0 WHERE t0.id = ? Parameters: [`1084`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nom AS nom_2, t0.version AS version_3, t0.code AS code_4, t0.duree AS duree_5, t0.auto_installation AS auto_installation_6, t0.conditions AS conditions_7, t0.conditionsRaw AS conditionsRaw_8, t0.conditionsFormater AS conditionsFormater_9, t0.documents_requis AS documents_requis_10, t0.nombre_documents AS nombre_documents_11, t0.nombre_conditions AS nombre_conditions_12, t0.question_details_type AS question_details_type_13, t0.question_details_value AS question_details_value_14, t0.periode AS periode_15, t0.informationTechnique AS informationTechnique_16, t0.informationTechniqueRaw AS informationTechniqueRaw_17, t0.informationTechniqueFormater AS informationTechniqueFormater_18, t0.informationDocSupplementaire AS informationDocSupplementaire_19, t0.informationDocSupplementaireRaw AS informationDocSupplementaireRaw_20, t0.informationDocSupplementaireFormater AS informationDocSupplementaireFormater_21, t0.informationfacture AS informationfacture_22, t0.informationfactureRaw AS informationfactureRaw_23, t0.informationfactureFormater AS informationfactureFormater_24, t0.informationfacture2 AS informationfacture2_25, t0.informationfacture2Raw AS informationfacture2Raw_26, t0.informationfacture2Formater AS informationfacture2Formater_27, t0.nbMateriau AS nbMateriau_28, t0.materiauSubtitle AS materiauSubtitle_29, t0.materiauTitle AS materiauTitle_30, t0.textForm AS textForm_31, t0.private AS private_32, t0.campagne AS campagne_33, t0.special AS special_34, t0.abrogation_datetime AS abrogation_datetime_35, t0.date_limite_depot_referencement AS date_limite_depot_referencement_36, t0.end_zni_date AS end_zni_date_37, t0.globalConfigurationHash AS globalConfigurationHash_38, t0.zni AS zni_39, t0.cdp_eligible AS cdp_eligible_40, t0.simulateur_id AS simulateur_id_41, t0.arrete_id AS arrete_id_42, t0.certification_id AS certification_id_43, t0.qualification_id AS qualification_id_44, t0.formConfigEngine_id AS formConfigEngine_id_45 FROM Operation t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.nom AS nom_2, t0.version AS version_3, t0.code AS code_4, t0.duree AS duree_5, t0.auto_installation AS auto_installation_6, t0.conditions AS conditions_7, t0.conditionsRaw AS conditionsRaw_8, t0.conditionsFormater AS conditionsFormater_9, t0.documents_requis AS documents_requis_10, t0.nombre_documents AS nombre_documents_11, t0.nombre_conditions AS nombre_conditions_12, t0.question_details_type AS question_details_type_13, t0.question_details_value AS question_details_value_14, t0.periode AS periode_15, t0.informationTechnique AS informationTechnique_16, t0.informationTechniqueRaw AS informationTechniqueRaw_17, t0.informationTechniqueFormater AS informationTechniqueFormater_18, t0.informationDocSupplementaire AS informationDocSupplementaire_19, t0.informationDocSupplementaireRaw AS informationDocSupplementaireRaw_20, t0.informationDocSupplementaireFormater AS informationDocSupplementaireFormater_21, t0.informationfacture AS informationfacture_22, t0.informationfactureRaw AS informationfactureRaw_23, t0.informationfactureFormater AS informationfactureFormater_24, t0.informationfacture2 AS informationfacture2_25, t0.informationfacture2Raw AS informationfacture2Raw_26, t0.informationfacture2Formater AS informationfacture2Formater_27, t0.nbMateriau AS nbMateriau_28, t0.materiauSubtitle AS materiauSubtitle_29, t0.materiauTitle AS materiauTitle_30, t0.textForm AS textForm_31, t0.private AS private_32, t0.campagne AS campagne_33, t0.special AS special_34, t0.abrogation_datetime AS abrogation_datetime_35, t0.date_limite_depot_referencement AS date_limite_depot_referencement_36, t0.end_zni_date AS end_zni_date_37, t0.globalConfigurationHash AS globalConfigurationHash_38, t0.zni AS zni_39, t0.cdp_eligible AS cdp_eligible_40, t0.simulateur_id AS simulateur_id_41, t0.arrete_id AS arrete_id_42, t0.certification_id AS certification_id_43, t0.qualification_id AS qualification_id_44, t0.formConfigEngine_id AS formConfigEngine_id_45 FROM Operation t0 WHERE t0.id = 1084;
5	1.40 ms	SELECT t0.id AS id_1, t0.reference AS reference_2, t0.nom AS nom_3, t0.nom_cd AS nom_cd_4, t0.cdiscount AS cdiscount_5, t0.pretty_name AS pretty_name_6, t0.status AS status_7, t0.slug AS slug_8, t0.form_lead_id AS form_lead_id_9, t0.active_operation_id AS active_operation_id_10, t11.id AS id_12, t11.nom AS nom_13, t11.version AS version_14, t11.code AS code_15, t11.duree AS duree_16, t11.auto_installation AS auto_installation_17, t11.conditions AS conditions_18, t11.conditionsRaw AS conditionsRaw_19, t11.conditionsFormater AS conditionsFormater_20, t11.documents_requis AS documents_requis_21, t11.nombre_documents AS nombre_documents_22, t11.nombre_conditions AS nombre_conditions_23, t11.question_details_type AS question_details_type_24, t11.question_details_value AS question_details_value_25, t11.periode AS periode_26, t11.informationTechnique AS informationTechnique_27, t11.informationTechniqueRaw AS informationTechniqueRaw_28, t11.informationTechniqueFormater AS informationTechniqueFormater_29, t11.informationDocSupplementaire AS informationDocSupplementaire_30, t11.informationDocSupplementaireRaw AS informationDocSupplementaireRaw_31, t11.informationDocSupplementaireFormater AS informationDocSupplementaireFormater_32, t11.informationfacture AS informationfacture_33, t11.informationfactureRaw AS informationfactureRaw_34, t11.informationfactureFormater AS informationfactureFormater_35, t11.informationfacture2 AS informationfacture2_36, t11.informationfacture2Raw AS informationfacture2Raw_37, t11.informationfacture2Formater AS informationfacture2Formater_38, t11.nbMateriau AS nbMateriau_39, t11.materiauSubtitle AS materiauSubtitle_40, t11.materiauTitle AS materiauTitle_41, t11.textForm AS textForm_42, t11.private AS private_43, t11.campagne AS campagne_44, t11.special AS special_45, t11.abrogation_datetime AS abrogation_datetime_46, t11.date_limite_depot_referencement AS date_limite_depot_referencement_47, t11.end_zni_date AS end_zni_date_48, t11.globalConfigurationHash AS globalConfigurationHash_49, t11.zni AS zni_50, t11.cdp_eligible AS cdp_eligible_51, t11.simulateur_id AS simulateur_id_52, t11.arrete_id AS arrete_id_53, t11.certification_id AS certification_id_54, t11.qualification_id AS qualification_id_55, t11.formConfigEngine_id AS formConfigEngine_id_56, t0.secteur_id AS secteur_id_57, t0.categorie_id AS categorie_id_58, t0.categorieCd_id AS categorieCd_id_59, t0.type_operation_id AS type_operation_id_60, t0.operation_specifique_id AS operation_specifique_id_61, t62.id AS id_63, t62.mode AS mode_64, t62.targetType AS targetType_65, t62.classic AS classic_66, t62.preca AS preca_67, t62.enable AS enable_68, t62.raiType AS raiType_69, t62.contractSignedElectronically AS contractSignedElectronically_70, t62.pro_signature_mandatory_outlay AS pro_signature_mandatory_outlay_71, t62.obligeTarget_id AS obligeTarget_id_72, t62.teteReseau_id AS teteReseau_id_73, t62.simulateur_id AS simulateur_id_74, t62.installateurTarget_id AS installateurTarget_id_75, t62.beTarget_id AS beTarget_id_76 FROM Simulateur t0 LEFT JOIN Operation t11 ON t0.active_operation_id = t11.id LEFT JOIN AffectationConsoneoRule t62 ON t62.simulateur_id = t0.id WHERE t0.id = ? Parameters: [`455`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.reference AS reference_2, t0.nom AS nom_3, t0.nom_cd AS nom_cd_4, t0.cdiscount AS cdiscount_5, t0.pretty_name AS pretty_name_6, t0.status AS status_7, t0.slug AS slug_8, t0.form_lead_id AS form_lead_id_9, t0.active_operation_id AS active_operation_id_10, t11.id AS id_12, t11.nom AS nom_13, t11.version AS version_14, t11.code AS code_15, t11.duree AS duree_16, t11.auto_installation AS auto_installation_17, t11.conditions AS conditions_18, t11.conditionsRaw AS conditionsRaw_19, t11.conditionsFormater AS conditionsFormater_20, t11.documents_requis AS documents_requis_21, t11.nombre_documents AS nombre_documents_22, t11.nombre_conditions AS nombre_conditions_23, t11.question_details_type AS question_details_type_24, t11.question_details_value AS question_details_value_25, t11.periode AS periode_26, t11.informationTechnique AS informationTechnique_27, t11.informationTechniqueRaw AS informationTechniqueRaw_28, t11.informationTechniqueFormater AS informationTechniqueFormater_29, t11.informationDocSupplementaire AS informationDocSupplementaire_30, t11.informationDocSupplementaireRaw AS informationDocSupplementaireRaw_31, t11.informationDocSupplementaireFormater AS informationDocSupplementaireFormater_32, t11.informationfacture AS informationfacture_33, t11.informationfactureRaw AS informationfactureRaw_34, t11.informationfactureFormater AS informationfactureFormater_35, t11.informationfacture2 AS informationfacture2_36, t11.informationfacture2Raw AS informationfacture2Raw_37, t11.informationfacture2Formater AS informationfacture2Formater_38, t11.nbMateriau AS nbMateriau_39, t11.materiauSubtitle AS materiauSubtitle_40, t11.materiauTitle AS materiauTitle_41, t11.textForm AS textForm_42, t11.private AS private_43, t11.campagne AS campagne_44, t11.special AS special_45, t11.abrogation_datetime AS abrogation_datetime_46, t11.date_limite_depot_referencement AS date_limite_depot_referencement_47, t11.end_zni_date AS end_zni_date_48, t11.globalConfigurationHash AS globalConfigurationHash_49, t11.zni AS zni_50, t11.cdp_eligible AS cdp_eligible_51, t11.simulateur_id AS simulateur_id_52, t11.arrete_id AS arrete_id_53, t11.certification_id AS certification_id_54, t11.qualification_id AS qualification_id_55, t11.formConfigEngine_id AS formConfigEngine_id_56, t0.secteur_id AS secteur_id_57, t0.categorie_id AS categorie_id_58, t0.categorieCd_id AS categorieCd_id_59, t0.type_operation_id AS type_operation_id_60, t0.operation_specifique_id AS operation_specifique_id_61, t62.id AS id_63, t62.mode AS mode_64, t62.targetType AS targetType_65, t62.classic AS classic_66, t62.preca AS preca_67, t62.enable AS enable_68, t62.raiType AS raiType_69, t62.contractSignedElectronically AS contractSignedElectronically_70, t62.pro_signature_mandatory_outlay AS pro_signature_mandatory_outlay_71, t62.obligeTarget_id AS obligeTarget_id_72, t62.teteReseau_id AS teteReseau_id_73, t62.simulateur_id AS simulateur_id_74, t62.installateurTarget_id AS installateurTarget_id_75, t62.beTarget_id AS beTarget_id_76 FROM Simulateur t0 LEFT JOIN Operation t11 ON t0.active_operation_id = t11.id LEFT JOIN AffectationConsoneoRule t62 ON t62.simulateur_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.reference AS reference_2, t0.nom AS nom_3, t0.nom_cd AS nom_cd_4, t0.cdiscount AS cdiscount_5, t0.pretty_name AS pretty_name_6, t0.status AS status_7, t0.slug AS slug_8, t0.form_lead_id AS form_lead_id_9, t0.active_operation_id AS active_operation_id_10, t11.id AS id_12, t11.nom AS nom_13, t11.version AS version_14, t11.code AS code_15, t11.duree AS duree_16, t11.auto_installation AS auto_installation_17, t11.conditions AS conditions_18, t11.conditionsRaw AS conditionsRaw_19, t11.conditionsFormater AS conditionsFormater_20, t11.documents_requis AS documents_requis_21, t11.nombre_documents AS nombre_documents_22, t11.nombre_conditions AS nombre_conditions_23, t11.question_details_type AS question_details_type_24, t11.question_details_value AS question_details_value_25, t11.periode AS periode_26, t11.informationTechnique AS informationTechnique_27, t11.informationTechniqueRaw AS informationTechniqueRaw_28, t11.informationTechniqueFormater AS informationTechniqueFormater_29, t11.informationDocSupplementaire AS informationDocSupplementaire_30, t11.informationDocSupplementaireRaw AS informationDocSupplementaireRaw_31, t11.informationDocSupplementaireFormater AS informationDocSupplementaireFormater_32, t11.informationfacture AS informationfacture_33, t11.informationfactureRaw AS informationfactureRaw_34, t11.informationfactureFormater AS informationfactureFormater_35, t11.informationfacture2 AS informationfacture2_36, t11.informationfacture2Raw AS informationfacture2Raw_37, t11.informationfacture2Formater AS informationfacture2Formater_38, t11.nbMateriau AS nbMateriau_39, t11.materiauSubtitle AS materiauSubtitle_40, t11.materiauTitle AS materiauTitle_41, t11.textForm AS textForm_42, t11.private AS private_43, t11.campagne AS campagne_44, t11.special AS special_45, t11.abrogation_datetime AS abrogation_datetime_46, t11.date_limite_depot_referencement AS date_limite_depot_referencement_47, t11.end_zni_date AS end_zni_date_48, t11.globalConfigurationHash AS globalConfigurationHash_49, t11.zni AS zni_50, t11.cdp_eligible AS cdp_eligible_51, t11.simulateur_id AS simulateur_id_52, t11.arrete_id AS arrete_id_53, t11.certification_id AS certification_id_54, t11.qualification_id AS qualification_id_55, t11.formConfigEngine_id AS formConfigEngine_id_56, t0.secteur_id AS secteur_id_57, t0.categorie_id AS categorie_id_58, t0.categorieCd_id AS categorieCd_id_59, t0.type_operation_id AS type_operation_id_60, t0.operation_specifique_id AS operation_specifique_id_61, t62.id AS id_63, t62.mode AS mode_64, t62.targetType AS targetType_65, t62.classic AS classic_66, t62.preca AS preca_67, t62.enable AS enable_68, t62.raiType AS raiType_69, t62.contractSignedElectronically AS contractSignedElectronically_70, t62.pro_signature_mandatory_outlay AS pro_signature_mandatory_outlay_71, t62.obligeTarget_id AS obligeTarget_id_72, t62.teteReseau_id AS teteReseau_id_73, t62.simulateur_id AS simulateur_id_74, t62.installateurTarget_id AS installateurTarget_id_75, t62.beTarget_id AS beTarget_id_76 FROM Simulateur t0 LEFT JOIN Operation t11 ON t0.active_operation_id = t11.id LEFT JOIN AffectationConsoneoRule t62 ON t62.simulateur_id = t0.id WHERE t0.id = 455;
6	0.88 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.status AS status_4 FROM Secteur t0 WHERE t0.id = ? Parameters: [`6`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.status AS status_4 FROM Secteur t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.status AS status_4 FROM Secteur t0 WHERE t0.id = 6;
7	0.78 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.status AS status_4 FROM TypeOperation t0 WHERE t0.id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.status AS status_4 FROM TypeOperation t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.status AS status_4 FROM TypeOperation t0 WHERE t0.id = 2;
8	0.92 ms	SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.description AS description_4, t0.status AS status_5, t0.slug AS slug_6, t0.human_title AS human_title_7, t0.position AS position_8 FROM SecteurActivite t0 WHERE t0.id = ? Parameters: [`5`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.description AS description_4, t0.status AS status_5, t0.slug AS slug_6, t0.human_title AS human_title_7, t0.position AS position_8 FROM SecteurActivite t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.description AS description_4, t0.status AS status_5, t0.slug AS slug_6, t0.human_title AS human_title_7, t0.position AS position_8 FROM SecteurActivite t0 WHERE t0.id = 5;
9	2.18 ms	SELECT t0.id AS id_1, t0.titre AS titre_2, t0.reference AS reference_3, t0.offre_cumac AS offre_cumac_4, t0.offre_cumac_precarite AS offre_cumac_precarite_5, t0.offre_cumac_client AS offre_cumac_client_6, t0.offre_cumac_client_precarite AS offre_cumac_client_precarite_7, t0.cumac AS cumac_8, t0.total_prime AS total_prime_9, t0.cumac_moyenne AS cumac_moyenne_10, t0.taux_actualise AS taux_actualise_11, t0.taux_accumule AS taux_accumule_12, t0.data AS data_13, t0.ip AS ip_14, t0.created_datetime AS created_datetime_15, t0.prime_pro AS prime_pro_16, t0.prime_client AS prime_client_17, t0.raison AS raison_18, t0.codepostal AS codepostal_19, t0.adresse AS adresse_20, t0.adresse_complement AS adresse_complement_21, t0.ville AS ville_22, t0.delai_souhaite AS delai_souhaite_23, t0.accept_recevoir_offre AS accept_recevoir_offre_24, t0.accept_recommandation AS accept_recommandation_25, t0.status AS status_26, t0.zone AS zone_27, t0.devisValue AS devisValue_28, t0.addressSituation AS addressSituation_29, t0.programStep AS programStep_30, t0.createdAt AS createdAt_31, t0.updatedAt AS updatedAt_32, t0.engineDocumentId AS engineDocumentId_33, t0.simulateur_id AS simulateur_id_34, t35.id AS id_36, t35.reference AS reference_37, t35.nom AS nom_38, t35.nom_cd AS nom_cd_39, t35.cdiscount AS cdiscount_40, t35.pretty_name AS pretty_name_41, t35.status AS status_42, t35.slug AS slug_43, t35.form_lead_id AS form_lead_id_44, t35.active_operation_id AS active_operation_id_45, t35.secteur_id AS secteur_id_46, t35.categorie_id AS categorie_id_47, t35.categorieCd_id AS categorieCd_id_48, t35.type_operation_id AS type_operation_id_49, t35.operation_specifique_id AS operation_specifique_id_50, t0.operation_id AS operation_id_51, t52.id AS id_53, t52.nom AS nom_54, t52.version AS version_55, t52.code AS code_56, t52.duree AS duree_57, t52.auto_installation AS auto_installation_58, t52.conditions AS conditions_59, t52.conditionsRaw AS conditionsRaw_60, t52.conditionsFormater AS conditionsFormater_61, t52.documents_requis AS documents_requis_62, t52.nombre_documents AS nombre_documents_63, t52.nombre_conditions AS nombre_conditions_64, t52.question_details_type AS question_details_type_65, t52.question_details_value AS question_details_value_66, t52.periode AS periode_67, t52.informationTechnique AS informationTechnique_68, t52.informationTechniqueRaw AS informationTechniqueRaw_69, t52.informationTechniqueFormater AS informationTechniqueFormater_70, t52.informationDocSupplementaire AS informationDocSupplementaire_71, t52.informationDocSupplementaireRaw AS informationDocSupplementaireRaw_72, t52.informationDocSupplementaireFormater AS informationDocSupplementaireFormater_73, t52.informationfacture AS informationfacture_74, t52.informationfactureRaw AS informationfactureRaw_75, t52.informationfactureFormater AS informationfactureFormater_76, t52.informationfacture2 AS informationfacture2_77, t52.informationfacture2Raw AS informationfacture2Raw_78, t52.informationfacture2Formater AS informationfacture2Formater_79, t52.nbMateriau AS nbMateriau_80, t52.materiauSubtitle AS materiauSubtitle_81, t52.materiauTitle AS materiauTitle_82, t52.textForm AS textForm_83, t52.private AS private_84, t52.campagne AS campagne_85, t52.special AS special_86, t52.abrogation_datetime AS abrogation_datetime_87, t52.date_limite_depot_referencement AS date_limite_depot_referencement_88, t52.end_zni_date AS end_zni_date_89, t52.globalConfigurationHash AS globalConfigurationHash_90, t52.zni AS zni_91, t52.cdp_eligible AS cdp_eligible_92, t52.simulateur_id AS simulateur_id_93, t52.arrete_id AS arrete_id_94, t52.certification_id AS certification_id_95, t52.qualification_id AS qualification_id_96, t52.formConfigEngine_id AS formConfigEngine_id_97, t0.entrepriseUser_id AS entrepriseUser_id_98, t0.particulierUser_id AS particulierUser_id_99, t0.installateurUser_id AS installateurUser_id_100, t0.beUser_id AS beUser_id_101, t102.id AS id_103, t102.type AS type_104, t102.pricingType AS pricingType_105, t102.finalisationRequested AS finalisationRequested_106, t102.finalisationRequestDate AS finalisationRequestDate_107, t102.cofracSatisfyDate AS cofracSatisfyDate_108, t102.reference AS reference_109, t102.data AS data_110, t102.cofracData AS cofracData_111, t102.cofracEngineDocumentId AS cofracEngineDocumentId_112, t102.ip AS ip_113, t102.offre_auto_date AS offre_auto_date_114, t102.created_datetime AS created_datetime_115, t102.updated_datetime AS updated_datetime_116, t102.tel AS tel_117, t102.codepostal AS codepostal_118, t102.adresse AS adresse_119, t102.adresse_complement AS adresse_complement_120, t102.ville AS ville_121, t102.delai_souhaite AS delai_souhaite_122, t102.accept_recevoir_offre AS accept_recevoir_offre_123, t102.accept_recommandation AS accept_recommandation_124, t102.acceptLeadPromo AS acceptLeadPromo_125, t102.offre_cumac AS offre_cumac_126, t102.offre_cumac_client AS offre_cumac_client_127, t102.offre_cumac_precarite AS offre_cumac_precarite_128, t102.offre_cumac_client_precarite AS offre_cumac_client_precarite_129, t102.cumac AS cumac_130, t102.cumac_AFT AS cumac_AFT_131, t102.total_prime AS total_prime_132, t102.total_prime_AFT AS total_prime_AFT_133, t102.prime_pro AS prime_pro_134, t102.prime_pro_aft AS prime_pro_aft_135, t102.prime_client AS prime_client_136, t102.prime_client_aft AS prime_client_aft_137, t102.cumac_moyenne AS cumac_moyenne_138, t102.taux_actualise AS taux_actualise_139, t102.taux_accumule AS taux_accumule_140, t102.date_debut_chantier AS date_debut_chantier_141, t102.date_demande_offre AS date_demande_offre_142, t102.date_fin_chantier AS date_fin_chantier_143, t102.etat AS etat_144, t102.status AS status_145, t102.date_offre AS date_offre_146, t102.notification_date_chantier AS notification_date_chantier_147, t102.date_retour_conv AS date_retour_conv_148, t102.date_validation_conv AS date_validation_conv_149, t102.date_chantier_renseigne AS date_chantier_renseigne_150, t102.date_paiement AS date_paiement_151, t102.date_all_doc_valid AS date_all_doc_valid_152, t102.date_fin_chantier_repousse AS date_fin_chantier_repousse_153, t102.date_envoi_questionnaire AS date_envoi_questionnaire_154, t102.date_edition_questionnaire AS date_edition_questionnaire_155, t102.date_validation_final AS date_validation_final_156, t102.date_annulation AS date_annulation_157, t102.no_click_email_date_chantier AS no_click_email_date_chantier_158, t102.token AS token_159, t102.auto_installation AS auto_installation_160, t102.siret AS siret_161, t102.cancelReason AS cancelReason_162, t102.dateCommande AS dateCommande_163, t102.siteTravaux AS siteTravaux_164, t102.incitation AS incitation_165, t102.qualificationRecordDate AS qualificationRecordDate_166, t102.serviceType AS serviceType_167, t102.debutChantier AS debutChantier_168, t102.finChantier AS finChantier_169, t102.initiateCDP AS initiateCDP_170, t102.cdp AS cdp_171, t102.date_last_envoi_convention AS date_last_envoi_convention_172, t102.programStep AS programStep_173, t102.devisRestAPayer AS devisRestAPayer_174, t102.pricingMandatClassique AS pricingMandatClassique_175, t102.pricingMandatPreca AS pricingMandatPreca_176, t102.isCOFRAC AS isCOFRAC_177, t102.applicationFeesPrice AS applicationFeesPrice_178, t102.attributes AS attributes_179, t102.exclusive AS exclusive_180, t102.engineDocumentId AS engineDocumentId_181, t102.adresseTravaux AS adresseTravaux_182, t102.adresseTravauxCommentaire AS adresseTravauxCommentaire_183, t102.batchOffreProjet_id AS batchOffreProjet_id_184, t102.entrepriseUser_id AS entrepriseUser_id_185, t102.installateurUser_id AS installateurUser_id_186, t102.beUser_id AS beUser_id_187, t102.entrepriseUserContact_id AS entrepriseUserContact_id_188, t102.particulierUserContact_id AS particulierUserContact_id_189, t102.signataireEntreprise_id AS signataireEntreprise_id_190, t102.signataireInstallateur_id AS signataireInstallateur_id_191, t102.installateurUserContact_id AS installateurUserContact_id_192, t102.projet_id AS projet_id_193, t102.precariteCas2_id AS precariteCas2_id_194, t102.creditNoteContract_id AS creditNoteContract_id_195, t102.precarite_id AS precarite_id_196, t102.state_id AS state_id_197, t102.oblige_id AS oblige_id_198, t102.secteurActivite_id AS secteurActivite_id_199, t102.factureDetail_id AS factureDetail_id_200, t102.offreStatus_id AS offreStatus_id_201, t102.identiteBeneficiaire_id AS identiteBeneficiaire_id_202, t102.identiteInstallateur_id AS identiteInstallateur_id_203, t102.operation_id AS operation_id_204, t102.particulierUser_id AS particulierUser_id_205, t102.qualificationRecord_id AS qualificationRecord_id_206, t102.sousTraitant_id AS sousTraitant_id_207, t102.program_id AS program_id_208, t102.programCommercial_id AS programCommercial_id_209, t102.programManager_id AS programManager_id_210, t102.signatureAuto_id AS signatureAuto_id_211, t102.wasteCenter_id AS wasteCenter_id_212, t102.waste_id AS waste_id_213, t102.programAuto_id AS programAuto_id_214, t102.justificatif_id AS justificatif_id_215, t102.cappingRule_id AS cappingRule_id_216, t102.projectOwner_id AS projectOwner_id_217, t102.project_bundle_id AS project_bundle_id_218, t102.estate_id AS estate_id_219, t0.precarite_id AS precarite_id_220, t0.secteurActivite_id AS secteurActivite_id_221, t0.integrationModule_id AS integrationModule_id_222, t0.precariteCas2_id AS precariteCas2_id_223, t0.program_id AS program_id_224, t0.programCommercial_id AS programCommercial_id_225, t0.programManager_id AS programManager_id_226, t0.justificatif_id AS justificatif_id_227, t228.id AS id_229, t228.numero AS numero_230, t228.dateRealisation AS dateRealisation_231, t228.dateFinValidite AS dateFinValidite_232, t228.etiquetteBilan AS etiquetteBilan_233, t228.createdAt AS createdAt_234, t228.updatedAt AS updatedAt_235, t228.typeJustificatif AS typeJustificatif_236, t228.projet_id AS projet_id_237, t228.offreProjet_id AS offreProjet_id_238, t0.project_bundle_id AS project_bundle_id_239, t0.estate_id AS estate_id_240 FROM Projet t0 LEFT JOIN Simulateur t35 ON t0.simulateur_id = t35.id LEFT JOIN Operation t52 ON t0.operation_id = t52.id LEFT JOIN OffreProjet t102 ON t102.projet_id = t0.id LEFT JOIN JustificatifPerformanceEnergetique t228 ON t228.projet_id = t0.id WHERE t0.id = ? Parameters: [`3875`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.titre AS titre_2, t0.reference AS reference_3, t0.offre_cumac AS offre_cumac_4, t0.offre_cumac_precarite AS offre_cumac_precarite_5, t0.offre_cumac_client AS offre_cumac_client_6, t0.offre_cumac_client_precarite AS offre_cumac_client_precarite_7, t0.cumac AS cumac_8, t0.total_prime AS total_prime_9, t0.cumac_moyenne AS cumac_moyenne_10, t0.taux_actualise AS taux_actualise_11, t0.taux_accumule AS taux_accumule_12, t0.data AS data_13, t0.ip AS ip_14, t0.created_datetime AS created_datetime_15, t0.prime_pro AS prime_pro_16, t0.prime_client AS prime_client_17, t0.raison AS raison_18, t0.codepostal AS codepostal_19, t0.adresse AS adresse_20, t0.adresse_complement AS adresse_complement_21, t0.ville AS ville_22, t0.delai_souhaite AS delai_souhaite_23, t0.accept_recevoir_offre AS accept_recevoir_offre_24, t0.accept_recommandation AS accept_recommandation_25, t0.status AS status_26, t0.zone AS zone_27, t0.devisValue AS devisValue_28, t0.addressSituation AS addressSituation_29, t0.programStep AS programStep_30, t0.createdAt AS createdAt_31, t0.updatedAt AS updatedAt_32, t0.engineDocumentId AS engineDocumentId_33, t0.simulateur_id AS simulateur_id_34, t35.id AS id_36, t35.reference AS reference_37, t35.nom AS nom_38, t35.nom_cd AS nom_cd_39, t35.cdiscount AS cdiscount_40, t35.pretty_name AS pretty_name_41, t35.status AS status_42, t35.slug AS slug_43, t35.form_lead_id AS form_lead_id_44, t35.active_operation_id AS active_operation_id_45, t35.secteur_id AS secteur_id_46, t35.categorie_id AS categorie_id_47, t35.categorieCd_id AS categorieCd_id_48, t35.type_operation_id AS type_operation_id_49, t35.operation_specifique_id AS operation_specifique_id_50, t0.operation_id AS operation_id_51, t52.id AS id_53, t52.nom AS nom_54, t52.version AS version_55, t52.code AS code_56, t52.duree AS duree_57, t52.auto_installation AS auto_installation_58, t52.conditions AS conditions_59, t52.conditionsRaw AS conditionsRaw_60, t52.conditionsFormater AS conditionsFormater_61, t52.documents_requis AS documents_requis_62, t52.nombre_documents AS nombre_documents_63, t52.nombre_conditions AS nombre_conditions_64, t52.question_details_type AS question_details_type_65, t52.question_details_value AS question_details_value_66, t52.periode AS periode_67, t52.informationTechnique AS informationTechnique_68, t52.informationTechniqueRaw AS informationTechniqueRaw_69, t52.informationTechniqueFormater AS informationTechniqueFormater_70, t52.informationDocSupplementaire AS informationDocSupplementaire_71, t52.informationDocSupplementaireRaw AS informationDocSupplementaireRaw_72, t52.informationDocSupplementaireFormater AS informationDocSupplementaireFormater_73, t52.informationfacture AS informationfacture_74, t52.informationfactureRaw AS informationfactureRaw_75, t52.informationfactureFormater AS informationfactureFormater_76, t52.informationfacture2 AS informationfacture2_77, t52.informationfacture2Raw AS informationfacture2Raw_78, t52.informationfacture2Formater AS informationfacture2Formater_79, t52.nbMateriau AS nbMateriau_80, t52.materiauSubtitle AS materiauSubtitle_81, t52.materiauTitle AS materiauTitle_82, t52.textForm AS textForm_83, t52.private AS private_84, t52.campagne AS campagne_85, t52.special AS special_86, t52.abrogation_datetime AS abrogation_datetime_87, t52.date_limite_depot_referencement AS date_limite_depot_referencement_88, t52.end_zni_date AS end_zni_date_89, t52.globalConfigurationHash AS globalConfigurationHash_90, t52.zni AS zni_91, t52.cdp_eligible AS cdp_eligible_92, t52.simulateur_id AS simulateur_id_93, t52.arrete_id AS arrete_id_94, t52.certification_id AS certification_id_95, t52.qualification_id AS qualification_id_96, t52.formConfigEngine_id AS formConfigEngine_id_97, t0.entrepriseUser_id AS entrepriseUser_id_98, t0.particulierUser_id AS particulierUser_id_99, t0.installateurUser_id AS installateurUser_id_100, t0.beUser_id AS beUser_id_101, t102.id AS id_103, t102.type AS type_104, t102.pricingType AS pricingType_105, t102.finalisationRequested AS finalisationRequested_106, t102.finalisationRequestDate AS finalisationRequestDate_107, t102.cofracSatisfyDate AS cofracSatisfyDate_108, t102.reference AS reference_109, t102.data AS data_110, t102.cofracData AS cofracData_111, t102.cofracEngineDocumentId AS cofracEngineDocumentId_112, t102.ip AS ip_113, t102.offre_auto_date AS offre_auto_date_114, t102.created_datetime AS created_datetime_115, t102.updated_datetime AS updated_datetime_116, t102.tel AS tel_117, t102.codepostal AS codepostal_118, t102.adresse AS adresse_119, t102.adresse_complement AS adresse_complement_120, t102.ville AS ville_121, t102.delai_souhaite AS delai_souhaite_122, t102.accept_recevoir_offre AS accept_recevoir_offre_123, t102.accept_recommandation AS accept_recommandation_124, t102.acceptLeadPromo AS acceptLeadPromo_125, t102.offre_cumac AS offre_cumac_126, t102.offre_cumac_client AS offre_cumac_client_127, t102.offre_cumac_precarite AS offre_cumac_precarite_128, t102.offre_cumac_client_precarite AS offre_cumac_client_precarite_129, t102.cumac AS cumac_130, t102.cumac_AFT AS cumac_AFT_131, t102.total_prime AS total_prime_132, t102.total_prime_AFT AS total_prime_AFT_133, t102.prime_pro AS prime_pro_134, t102.prime_pro_aft AS prime_pro_aft_135, t102.prime_client AS prime_client_136, t102.prime_client_aft AS prime_client_aft_137, t102.cumac_moyenne AS cumac_moyenne_138, t102.taux_actualise AS taux_actualise_139, t102.taux_accumule AS taux_accumule_140, t102.date_debut_chantier AS date_debut_chantier_141, t102.date_demande_offre AS date_demande_offre_142, t102.date_fin_chantier AS date_fin_chantier_143, t102.etat AS etat_144, t102.status AS status_145, t102.date_offre AS date_offre_146, t102.notification_date_chantier AS notification_date_chantier_147, t102.date_retour_conv AS date_retour_conv_148, t102.date_validation_conv AS date_validation_conv_149, t102.date_chantier_renseigne AS date_chantier_renseigne_150, t102.date_paiement AS date_paiement_151, t102.date_all_doc_valid AS date_all_doc_valid_152, t102.date_fin_chantier_repousse AS date_fin_chantier_repousse_153, t102.date_envoi_questionnaire AS date_envoi_questionnaire_154, t102.date_edition_questionnaire AS date_edition_questionnaire_155, t102.date_validation_final AS date_validation_final_156, t102.date_annulation AS date_annulation_157, t102.no_click_email_date_chantier AS no_click_email_date_chantier_158, t102.token AS token_159, t102.auto_installation AS auto_installation_160, t102.siret AS siret_161, t102.cancelReason AS cancelReason_162, t102.dateCommande AS dateCommande_163, t102.siteTravaux AS siteTravaux_164, t102.incitation AS incitation_165, t102.qualificationRecordDate AS qualificationRecordDate_166, t102.serviceType AS serviceType_167, t102.debutChantier AS debutChantier_168, t102.finChantier AS finChantier_169, t102.initiateCDP AS initiateCDP_170, t102.cdp AS cdp_171, t102.date_last_envoi_convention AS date_last_envoi_convention_172, t102.programStep AS programStep_173, t102.devisRestAPayer AS devisRestAPayer_174, t102.pricingMandatClassique AS pricingMandatClassique_175, t102.pricingMandatPreca AS pricingMandatPreca_176, t102.isCOFRAC AS isCOFRAC_177, t102.applicationFeesPrice AS applicationFeesPrice_178, t102.attributes AS attributes_179, t102.exclusive AS exclusive_180, t102.engineDocumentId AS engineDocumentId_181, t102.adresseTravaux AS adresseTravaux_182, t102.adresseTravauxCommentaire AS adresseTravauxCommentaire_183, t102.batchOffreProjet_id AS batchOffreProjet_id_184, t102.entrepriseUser_id AS entrepriseUser_id_185, t102.installateurUser_id AS installateurUser_id_186, t102.beUser_id AS beUser_id_187, t102.entrepriseUserContact_id AS entrepriseUserContact_id_188, t102.particulierUserContact_id AS particulierUserContact_id_189, t102.signataireEntreprise_id AS signataireEntreprise_id_190, t102.signataireInstallateur_id AS signataireInstallateur_id_191, t102.installateurUserContact_id AS installateurUserContact_id_192, t102.projet_id AS projet_id_193, t102.precariteCas2_id AS precariteCas2_id_194, t102.creditNoteContract_id AS creditNoteContract_id_195, t102.precarite_id AS precarite_id_196, t102.state_id AS state_id_197, t102.oblige_id AS oblige_id_198, t102.secteurActivite_id AS secteurActivite_id_199, t102.factureDetail_id AS factureDetail_id_200, t102.offreStatus_id AS offreStatus_id_201, t102.identiteBeneficiaire_id AS identiteBeneficiaire_id_202, t102.identiteInstallateur_id AS identiteInstallateur_id_203, t102.operation_id AS operation_id_204, t102.particulierUser_id AS particulierUser_id_205, t102.qualificationRecord_id AS qualificationRecord_id_206, t102.sousTraitant_id AS sousTraitant_id_207, t102.program_id AS program_id_208, t102.programCommercial_id AS programCommercial_id_209, t102.programManager_id AS programManager_id_210, t102.signatureAuto_id AS signatureAuto_id_211, t102.wasteCenter_id AS wasteCenter_id_212, t102.waste_id AS waste_id_213, t102.programAuto_id AS programAuto_id_214, t102.justificatif_id AS justificatif_id_215, t102.cappingRule_id AS cappingRule_id_216, t102.projectOwner_id AS projectOwner_id_217, t102.project_bundle_id AS project_bundle_id_218, t102.estate_id AS estate_id_219, t0.precarite_id AS precarite_id_220, t0.secteurActivite_id AS secteurActivite_id_221, t0.integrationModule_id AS integrationModule_id_222, t0.precariteCas2_id AS precariteCas2_id_223, t0.program_id AS program_id_224, t0.programCommercial_id AS programCommercial_id_225, t0.programManager_id AS programManager_id_226, t0.justificatif_id AS justificatif_id_227, t228.id AS id_229, t228.numero AS numero_230, t228.dateRealisation AS dateRealisation_231, t228.dateFinValidite AS dateFinValidite_232, t228.etiquetteBilan AS etiquetteBilan_233, t228.createdAt AS createdAt_234, t228.updatedAt AS updatedAt_235, t228.typeJustificatif AS typeJustificatif_236, t228.projet_id AS projet_id_237, t228.offreProjet_id AS offreProjet_id_238, t0.project_bundle_id AS project_bundle_id_239, t0.estate_id AS estate_id_240 FROM Projet t0 LEFT JOIN Simulateur t35 ON t0.simulateur_id = t35.id LEFT JOIN Operation t52 ON t0.operation_id = t52.id LEFT JOIN OffreProjet t102 ON t102.projet_id = t0.id LEFT JOIN JustificatifPerformanceEnergetique t228 ON t228.projet_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.titre AS titre_2, t0.reference AS reference_3, t0.offre_cumac AS offre_cumac_4, t0.offre_cumac_precarite AS offre_cumac_precarite_5, t0.offre_cumac_client AS offre_cumac_client_6, t0.offre_cumac_client_precarite AS offre_cumac_client_precarite_7, t0.cumac AS cumac_8, t0.total_prime AS total_prime_9, t0.cumac_moyenne AS cumac_moyenne_10, t0.taux_actualise AS taux_actualise_11, t0.taux_accumule AS taux_accumule_12, t0.data AS data_13, t0.ip AS ip_14, t0.created_datetime AS created_datetime_15, t0.prime_pro AS prime_pro_16, t0.prime_client AS prime_client_17, t0.raison AS raison_18, t0.codepostal AS codepostal_19, t0.adresse AS adresse_20, t0.adresse_complement AS adresse_complement_21, t0.ville AS ville_22, t0.delai_souhaite AS delai_souhaite_23, t0.accept_recevoir_offre AS accept_recevoir_offre_24, t0.accept_recommandation AS accept_recommandation_25, t0.status AS status_26, t0.zone AS zone_27, t0.devisValue AS devisValue_28, t0.addressSituation AS addressSituation_29, t0.programStep AS programStep_30, t0.createdAt AS createdAt_31, t0.updatedAt AS updatedAt_32, t0.engineDocumentId AS engineDocumentId_33, t0.simulateur_id AS simulateur_id_34, t35.id AS id_36, t35.reference AS reference_37, t35.nom AS nom_38, t35.nom_cd AS nom_cd_39, t35.cdiscount AS cdiscount_40, t35.pretty_name AS pretty_name_41, t35.status AS status_42, t35.slug AS slug_43, t35.form_lead_id AS form_lead_id_44, t35.active_operation_id AS active_operation_id_45, t35.secteur_id AS secteur_id_46, t35.categorie_id AS categorie_id_47, t35.categorieCd_id AS categorieCd_id_48, t35.type_operation_id AS type_operation_id_49, t35.operation_specifique_id AS operation_specifique_id_50, t0.operation_id AS operation_id_51, t52.id AS id_53, t52.nom AS nom_54, t52.version AS version_55, t52.code AS code_56, t52.duree AS duree_57, t52.auto_installation AS auto_installation_58, t52.conditions AS conditions_59, t52.conditionsRaw AS conditionsRaw_60, t52.conditionsFormater AS conditionsFormater_61, t52.documents_requis AS documents_requis_62, t52.nombre_documents AS nombre_documents_63, t52.nombre_conditions AS nombre_conditions_64, t52.question_details_type AS question_details_type_65, t52.question_details_value AS question_details_value_66, t52.periode AS periode_67, t52.informationTechnique AS informationTechnique_68, t52.informationTechniqueRaw AS informationTechniqueRaw_69, t52.informationTechniqueFormater AS informationTechniqueFormater_70, t52.informationDocSupplementaire AS informationDocSupplementaire_71, t52.informationDocSupplementaireRaw AS informationDocSupplementaireRaw_72, t52.informationDocSupplementaireFormater AS informationDocSupplementaireFormater_73, t52.informationfacture AS informationfacture_74, t52.informationfactureRaw AS informationfactureRaw_75, t52.informationfactureFormater AS informationfactureFormater_76, t52.informationfacture2 AS informationfacture2_77, t52.informationfacture2Raw AS informationfacture2Raw_78, t52.informationfacture2Formater AS informationfacture2Formater_79, t52.nbMateriau AS nbMateriau_80, t52.materiauSubtitle AS materiauSubtitle_81, t52.materiauTitle AS materiauTitle_82, t52.textForm AS textForm_83, t52.private AS private_84, t52.campagne AS campagne_85, t52.special AS special_86, t52.abrogation_datetime AS abrogation_datetime_87, t52.date_limite_depot_referencement AS date_limite_depot_referencement_88, t52.end_zni_date AS end_zni_date_89, t52.globalConfigurationHash AS globalConfigurationHash_90, t52.zni AS zni_91, t52.cdp_eligible AS cdp_eligible_92, t52.simulateur_id AS simulateur_id_93, t52.arrete_id AS arrete_id_94, t52.certification_id AS certification_id_95, t52.qualification_id AS qualification_id_96, t52.formConfigEngine_id AS formConfigEngine_id_97, t0.entrepriseUser_id AS entrepriseUser_id_98, t0.particulierUser_id AS particulierUser_id_99, t0.installateurUser_id AS installateurUser_id_100, t0.beUser_id AS beUser_id_101, t102.id AS id_103, t102.type AS type_104, t102.pricingType AS pricingType_105, t102.finalisationRequested AS finalisationRequested_106, t102.finalisationRequestDate AS finalisationRequestDate_107, t102.cofracSatisfyDate AS cofracSatisfyDate_108, t102.reference AS reference_109, t102.data AS data_110, t102.cofracData AS cofracData_111, t102.cofracEngineDocumentId AS cofracEngineDocumentId_112, t102.ip AS ip_113, t102.offre_auto_date AS offre_auto_date_114, t102.created_datetime AS created_datetime_115, t102.updated_datetime AS updated_datetime_116, t102.tel AS tel_117, t102.codepostal AS codepostal_118, t102.adresse AS adresse_119, t102.adresse_complement AS adresse_complement_120, t102.ville AS ville_121, t102.delai_souhaite AS delai_souhaite_122, t102.accept_recevoir_offre AS accept_recevoir_offre_123, t102.accept_recommandation AS accept_recommandation_124, t102.acceptLeadPromo AS acceptLeadPromo_125, t102.offre_cumac AS offre_cumac_126, t102.offre_cumac_client AS offre_cumac_client_127, t102.offre_cumac_precarite AS offre_cumac_precarite_128, t102.offre_cumac_client_precarite AS offre_cumac_client_precarite_129, t102.cumac AS cumac_130, t102.cumac_AFT AS cumac_AFT_131, t102.total_prime AS total_prime_132, t102.total_prime_AFT AS total_prime_AFT_133, t102.prime_pro AS prime_pro_134, t102.prime_pro_aft AS prime_pro_aft_135, t102.prime_client AS prime_client_136, t102.prime_client_aft AS prime_client_aft_137, t102.cumac_moyenne AS cumac_moyenne_138, t102.taux_actualise AS taux_actualise_139, t102.taux_accumule AS taux_accumule_140, t102.date_debut_chantier AS date_debut_chantier_141, t102.date_demande_offre AS date_demande_offre_142, t102.date_fin_chantier AS date_fin_chantier_143, t102.etat AS etat_144, t102.status AS status_145, t102.date_offre AS date_offre_146, t102.notification_date_chantier AS notification_date_chantier_147, t102.date_retour_conv AS date_retour_conv_148, t102.date_validation_conv AS date_validation_conv_149, t102.date_chantier_renseigne AS date_chantier_renseigne_150, t102.date_paiement AS date_paiement_151, t102.date_all_doc_valid AS date_all_doc_valid_152, t102.date_fin_chantier_repousse AS date_fin_chantier_repousse_153, t102.date_envoi_questionnaire AS date_envoi_questionnaire_154, t102.date_edition_questionnaire AS date_edition_questionnaire_155, t102.date_validation_final AS date_validation_final_156, t102.date_annulation AS date_annulation_157, t102.no_click_email_date_chantier AS no_click_email_date_chantier_158, t102.token AS token_159, t102.auto_installation AS auto_installation_160, t102.siret AS siret_161, t102.cancelReason AS cancelReason_162, t102.dateCommande AS dateCommande_163, t102.siteTravaux AS siteTravaux_164, t102.incitation AS incitation_165, t102.qualificationRecordDate AS qualificationRecordDate_166, t102.serviceType AS serviceType_167, t102.debutChantier AS debutChantier_168, t102.finChantier AS finChantier_169, t102.initiateCDP AS initiateCDP_170, t102.cdp AS cdp_171, t102.date_last_envoi_convention AS date_last_envoi_convention_172, t102.programStep AS programStep_173, t102.devisRestAPayer AS devisRestAPayer_174, t102.pricingMandatClassique AS pricingMandatClassique_175, t102.pricingMandatPreca AS pricingMandatPreca_176, t102.isCOFRAC AS isCOFRAC_177, t102.applicationFeesPrice AS applicationFeesPrice_178, t102.attributes AS attributes_179, t102.exclusive AS exclusive_180, t102.engineDocumentId AS engineDocumentId_181, t102.adresseTravaux AS adresseTravaux_182, t102.adresseTravauxCommentaire AS adresseTravauxCommentaire_183, t102.batchOffreProjet_id AS batchOffreProjet_id_184, t102.entrepriseUser_id AS entrepriseUser_id_185, t102.installateurUser_id AS installateurUser_id_186, t102.beUser_id AS beUser_id_187, t102.entrepriseUserContact_id AS entrepriseUserContact_id_188, t102.particulierUserContact_id AS particulierUserContact_id_189, t102.signataireEntreprise_id AS signataireEntreprise_id_190, t102.signataireInstallateur_id AS signataireInstallateur_id_191, t102.installateurUserContact_id AS installateurUserContact_id_192, t102.projet_id AS projet_id_193, t102.precariteCas2_id AS precariteCas2_id_194, t102.creditNoteContract_id AS creditNoteContract_id_195, t102.precarite_id AS precarite_id_196, t102.state_id AS state_id_197, t102.oblige_id AS oblige_id_198, t102.secteurActivite_id AS secteurActivite_id_199, t102.factureDetail_id AS factureDetail_id_200, t102.offreStatus_id AS offreStatus_id_201, t102.identiteBeneficiaire_id AS identiteBeneficiaire_id_202, t102.identiteInstallateur_id AS identiteInstallateur_id_203, t102.operation_id AS operation_id_204, t102.particulierUser_id AS particulierUser_id_205, t102.qualificationRecord_id AS qualificationRecord_id_206, t102.sousTraitant_id AS sousTraitant_id_207, t102.program_id AS program_id_208, t102.programCommercial_id AS programCommercial_id_209, t102.programManager_id AS programManager_id_210, t102.signatureAuto_id AS signatureAuto_id_211, t102.wasteCenter_id AS wasteCenter_id_212, t102.waste_id AS waste_id_213, t102.programAuto_id AS programAuto_id_214, t102.justificatif_id AS justificatif_id_215, t102.cappingRule_id AS cappingRule_id_216, t102.projectOwner_id AS projectOwner_id_217, t102.project_bundle_id AS project_bundle_id_218, t102.estate_id AS estate_id_219, t0.precarite_id AS precarite_id_220, t0.secteurActivite_id AS secteurActivite_id_221, t0.integrationModule_id AS integrationModule_id_222, t0.precariteCas2_id AS precariteCas2_id_223, t0.program_id AS program_id_224, t0.programCommercial_id AS programCommercial_id_225, t0.programManager_id AS programManager_id_226, t0.justificatif_id AS justificatif_id_227, t228.id AS id_229, t228.numero AS numero_230, t228.dateRealisation AS dateRealisation_231, t228.dateFinValidite AS dateFinValidite_232, t228.etiquetteBilan AS etiquetteBilan_233, t228.createdAt AS createdAt_234, t228.updatedAt AS updatedAt_235, t228.typeJustificatif AS typeJustificatif_236, t228.projet_id AS projet_id_237, t228.offreProjet_id AS offreProjet_id_238, t0.project_bundle_id AS project_bundle_id_239, t0.estate_id AS estate_id_240 FROM Projet t0 LEFT JOIN Simulateur t35 ON t0.simulateur_id = t35.id LEFT JOIN Operation t52 ON t0.operation_id = t52.id LEFT JOIN OffreProjet t102 ON t102.projet_id = t0.id LEFT JOIN JustificatifPerformanceEnergetique t228 ON t228.projet_id = t0.id WHERE t0.id = 3875;
10	0.86 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.projet_id = ? Parameters: [`3875`] 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.projet_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.projet_id = 3875;
11	0.90 ms	SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.suffix AS suffix_2, a0_.effectiveDate AS effectiveDate_3 FROM Arrete a0_ WHERE a0_.effectiveDate <= ? ORDER BY a0_.effectiveDate DESC LIMIT 1 Parameters: [`"2026-09-16 17:17:36"`] View formatted query View runnable query Explain query SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.suffix AS suffix_2, a0_.effectiveDate AS effectiveDate_3 FROM Arrete a0_ WHERE a0_.effectiveDate <= ? ORDER BY a0_.effectiveDate DESC LIMIT 1 SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.suffix AS suffix_2, a0_.effectiveDate AS effectiveDate_3 FROM Arrete a0_ WHERE a0_.effectiveDate <= '2026-09-16 17:17:36' ORDER BY a0_.effectiveDate DESC LIMIT 1;
12	0.77 ms	SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.suffix AS suffix_2, a0_.effectiveDate AS effectiveDate_3 FROM Arrete a0_ WHERE a0_.effectiveDate <= ? ORDER BY a0_.effectiveDate DESC Parameters: [`"2026-09-16 17:17:36"`] View formatted query View runnable query Explain query SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.suffix AS suffix_2, a0_.effectiveDate AS effectiveDate_3 FROM Arrete a0_ WHERE a0_.effectiveDate <= ? ORDER BY a0_.effectiveDate DESC SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.suffix AS suffix_2, a0_.effectiveDate AS effectiveDate_3 FROM Arrete a0_ WHERE a0_.effectiveDate <= '2026-09-16 17:17:36' ORDER BY a0_.effectiveDate DESC;
13	1.45 ms	SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.originalEmailName AS originalEmailName_4, t0.created_datetime AS created_datetime_5, t0.weight AS weight_6, t0.originalNeeded AS originalNeeded_7, t0.allowedUniverSign AS allowedUniverSign_8, t0.description AS description_9 FROM DocumentType t0 WHERE t0.slug = ? LIMIT 1 Parameters: [`"avis_imposition"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.originalEmailName AS originalEmailName_4, t0.created_datetime AS created_datetime_5, t0.weight AS weight_6, t0.originalNeeded AS originalNeeded_7, t0.allowedUniverSign AS allowedUniverSign_8, t0.description AS description_9 FROM DocumentType t0 WHERE t0.slug = ? LIMIT 1 SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.originalEmailName AS originalEmailName_4, t0.created_datetime AS created_datetime_5, t0.weight AS weight_6, t0.originalNeeded AS originalNeeded_7, t0.allowedUniverSign AS allowedUniverSign_8, t0.description AS description_9 FROM DocumentType t0 WHERE t0.slug = 'avis_imposition' LIMIT 1;
14	1.31 ms	SELECT t0.id AS id_1, t0.username_canonical AS username_canonical_2, t0.email_canonical AS email_canonical_3, t0.enabled AS enabled_4, t0.salt AS salt_5, t0.password AS password_6, t0.last_login AS last_login_7, t0.confirmation_token AS confirmation_token_8, t0.password_requested_at AS password_requested_at_9, t0.roles AS roles_10, t0.nom AS nom_11, t0.prenom AS prenom_12, t0.fonction AS fonction_13, t0.tel AS tel_14, t0.mobile AS mobile_15, t0.activation AS activation_16, t0.createdAt AS createdAt_17, t0.updatedAt AS updatedAt_18, t0.optin AS optin_19, t0.dateActivation AS dateActivation_20, t0.emailValidatedDateTime AS emailValidatedDateTime_21, t0.emailCreatedDateTime AS emailCreatedDateTime_22, t0.mobileCreatedDatetime AS mobileCreatedDatetime_23, t0.sendEmail AS sendEmail_24, t0.dateEnvoiGuide AS dateEnvoiGuide_25, t0.token AS token_26, t0.emailJustificatifPreca AS emailJustificatifPreca_27, t0.adresse AS adresse_28, t0.adresse_complement AS adresse_complement_29, t0.codepostal AS codepostal_30, t0.ville AS ville_31, t0.formPrecaResponse AS formPrecaResponse_32, t0.gender AS gender_33, t0.stampFilename AS stampFilename_34, t0.email AS email_35, t0.username AS username_36, t0.cas1_id AS cas1_id_37, t38.id AS id_39, t38.type AS type_40, t38.detail AS detail_41, t38.token AS token_42, t38.installateur_id AS installateur_id_43, t38.particulierUser_id AS particulierUser_id_44, t38.entrepriseUser_id AS entrepriseUser_id_45, t38.particulierUserContact_id AS particulierUserContact_id_46, t38.entrepriseUserContact_id AS entrepriseUserContact_id_47, t0.identite_id AS identite_id_48, t0.integrationModule_id AS integrationModule_id_49 FROM ParticulierUserContact t0 LEFT JOIN PaymentMethod t38 ON t38.particulierUserContact_id = t0.id WHERE t0.id = ? Parameters: [`268`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.username_canonical AS username_canonical_2, t0.email_canonical AS email_canonical_3, t0.enabled AS enabled_4, t0.salt AS salt_5, t0.password AS password_6, t0.last_login AS last_login_7, t0.confirmation_token AS confirmation_token_8, t0.password_requested_at AS password_requested_at_9, t0.roles AS roles_10, t0.nom AS nom_11, t0.prenom AS prenom_12, t0.fonction AS fonction_13, t0.tel AS tel_14, t0.mobile AS mobile_15, t0.activation AS activation_16, t0.createdAt AS createdAt_17, t0.updatedAt AS updatedAt_18, t0.optin AS optin_19, t0.dateActivation AS dateActivation_20, t0.emailValidatedDateTime AS emailValidatedDateTime_21, t0.emailCreatedDateTime AS emailCreatedDateTime_22, t0.mobileCreatedDatetime AS mobileCreatedDatetime_23, t0.sendEmail AS sendEmail_24, t0.dateEnvoiGuide AS dateEnvoiGuide_25, t0.token AS token_26, t0.emailJustificatifPreca AS emailJustificatifPreca_27, t0.adresse AS adresse_28, t0.adresse_complement AS adresse_complement_29, t0.codepostal AS codepostal_30, t0.ville AS ville_31, t0.formPrecaResponse AS formPrecaResponse_32, t0.gender AS gender_33, t0.stampFilename AS stampFilename_34, t0.email AS email_35, t0.username AS username_36, t0.cas1_id AS cas1_id_37, t38.id AS id_39, t38.type AS type_40, t38.detail AS detail_41, t38.token AS token_42, t38.installateur_id AS installateur_id_43, t38.particulierUser_id AS particulierUser_id_44, t38.entrepriseUser_id AS entrepriseUser_id_45, t38.particulierUserContact_id AS particulierUserContact_id_46, t38.entrepriseUserContact_id AS entrepriseUserContact_id_47, t0.identite_id AS identite_id_48, t0.integrationModule_id AS integrationModule_id_49 FROM ParticulierUserContact t0 LEFT JOIN PaymentMethod t38 ON t38.particulierUserContact_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.username_canonical AS username_canonical_2, t0.email_canonical AS email_canonical_3, t0.enabled AS enabled_4, t0.salt AS salt_5, t0.password AS password_6, t0.last_login AS last_login_7, t0.confirmation_token AS confirmation_token_8, t0.password_requested_at AS password_requested_at_9, t0.roles AS roles_10, t0.nom AS nom_11, t0.prenom AS prenom_12, t0.fonction AS fonction_13, t0.tel AS tel_14, t0.mobile AS mobile_15, t0.activation AS activation_16, t0.createdAt AS createdAt_17, t0.updatedAt AS updatedAt_18, t0.optin AS optin_19, t0.dateActivation AS dateActivation_20, t0.emailValidatedDateTime AS emailValidatedDateTime_21, t0.emailCreatedDateTime AS emailCreatedDateTime_22, t0.mobileCreatedDatetime AS mobileCreatedDatetime_23, t0.sendEmail AS sendEmail_24, t0.dateEnvoiGuide AS dateEnvoiGuide_25, t0.token AS token_26, t0.emailJustificatifPreca AS emailJustificatifPreca_27, t0.adresse AS adresse_28, t0.adresse_complement AS adresse_complement_29, t0.codepostal AS codepostal_30, t0.ville AS ville_31, t0.formPrecaResponse AS formPrecaResponse_32, t0.gender AS gender_33, t0.stampFilename AS stampFilename_34, t0.email AS email_35, t0.username AS username_36, t0.cas1_id AS cas1_id_37, t38.id AS id_39, t38.type AS type_40, t38.detail AS detail_41, t38.token AS token_42, t38.installateur_id AS installateur_id_43, t38.particulierUser_id AS particulierUser_id_44, t38.entrepriseUser_id AS entrepriseUser_id_45, t38.particulierUserContact_id AS particulierUserContact_id_46, t38.entrepriseUserContact_id AS entrepriseUserContact_id_47, t0.identite_id AS identite_id_48, t0.integrationModule_id AS integrationModule_id_49 FROM ParticulierUserContact t0 LEFT JOIN PaymentMethod t38 ON t38.particulierUserContact_id = t0.id WHERE t0.id = 268;
15	0.69 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
16	2.22 ms	INSERT INTO Cas1 (nbFoyerFiscal, codePostal, situation, createdAt, updatedAt) VALUES (?, ?, ?, ?, ?) Parameters: [`1 "75001" 1 "2026-09-16 17:17:36" "2026-09-16 17:17:36"`] View formatted query View runnable query Explain query INSERT INTO Cas1 ( nbFoyerFiscal, codePostal, situation, createdAt, updatedAt ) VALUES (?, ?, ?, ?, ?) INSERT INTO Cas1 (nbFoyerFiscal, codePostal, situation, createdAt, updatedAt) VALUES (1, '75001', 1, '2026-09-16 17:17:36', '2026-09-16 17:17:36');
17	10.39 ms	INSERT INTO Justificatif (token, type, source, choice, declared_year, declared_tax_income, nb_people_declared, tax_year, address, zip_code, city, country, nb_dependents, reference_tax_income, nb_tax_parts, address_supplement, doc_iua, createdAt, updatedAt, cas1_id, main_declarant_id, secondAvis_id, campagneUser_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"f4zj0YFK79sJEXgtDBhmkSXTIY97aUbU11qNFlG0MFk" "avis_imposition" "beneficiaire" "beneficiaire" null null null null null null null "FRANCE" null null null null null "2026-09-16 17:17:36" "2026-09-16 17:17:36" 287 null null null`] View formatted query View runnable query Explain query INSERT INTO Justificatif ( token, type, source, choice, declared_year, declared_tax_income, nb_people_declared, tax_year, address, zip_code, city, country, nb_dependents, reference_tax_income, nb_tax_parts, address_supplement, doc_iua, createdAt, updatedAt, cas1_id, main_declarant_id, secondAvis_id, campagneUser_id ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) INSERT INTO Justificatif (token, type, source, choice, declared_year, declared_tax_income, nb_people_declared, tax_year, address, zip_code, city, country, nb_dependents, reference_tax_income, nb_tax_parts, address_supplement, doc_iua, createdAt, updatedAt, cas1_id, main_declarant_id, secondAvis_id, campagneUser_id) VALUES ('f4zj0YFK79sJEXgtDBhmkSXTIY97aUbU11qNFlG0MFk', 'avis_imposition', 'beneficiaire', 'beneficiaire', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FRANCE', NULL, NULL, NULL, NULL, NULL, '2026-09-16 17:17:36', '2026-09-16 17:17:36', 287, NULL, NULL, NULL);
18	29.62 ms	INSERT INTO Document (dateSignatureConvention, dateSignatureAhClient, dateSignatureAhPro, dateSignatureFacture, datePrevisite, noQrDecode, originalName, optionalName, valid, process, decoded, disabled, path, validated_datetime, processed_datetime, created_datetime, updated_datetime, signe, lisible, electronic, thumbnail, reference, stockage, iua, safeId, serviceType, secondJustificatif, imported, dateEditionDevis, ahProElectronic, signataireName, signataireSurname, dateEmission, expirationDate, sienna_id, offre_projets_group, type_id, offreProjet_id, installateurUser_id, justificatif_id, jpe_id, obligeUser_id, obligeUserReal_id, factureDetail_id, contract_id, geolocalisation_id, sousTraitant_id, certilink_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`null null null null null 0 "fiscal-6aaab310208961.13498130-AVIS D'IMPOSITION.pdf" null 0 0 1 0 "entity/Justificatif/fiscal-6aaab310208961.13498130-AVIS D'IMPOSITION.pdf" null null "2026-09-16 17:17:36" "2026-09-16 17:17:36" 0 0 0 null "bd399fb033bdb2b017b52e328a0f85b6" "S3" null null null 0 0 null 0 null null null null null null 390 null null 361 null null null null null null null null`] View formatted query View runnable query Explain query INSERT INTO Document ( dateSignatureConvention, dateSignatureAhClient, dateSignatureAhPro, dateSignatureFacture, datePrevisite, noQrDecode, originalName, optionalName, valid, process, decoded, disabled, path, validated_datetime, processed_datetime, created_datetime, updated_datetime, signe, lisible, electronic, thumbnail, reference, stockage, iua, safeId, serviceType, secondJustificatif, imported, dateEditionDevis, ahProElectronic, signataireName, signataireSurname, dateEmission, expirationDate, sienna_id, offre_projets_group, type_id, offreProjet_id, installateurUser_id, justificatif_id, jpe_id, obligeUser_id, obligeUserReal_id, factureDetail_id, contract_id, geolocalisation_id, sousTraitant_id, certilink_id ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) INSERT INTO Document (dateSignatureConvention, dateSignatureAhClient, dateSignatureAhPro, dateSignatureFacture, datePrevisite, noQrDecode, originalName, optionalName, valid, process, decoded, disabled, path, validated_datetime, processed_datetime, created_datetime, updated_datetime, signe, lisible, electronic, thumbnail, reference, stockage, iua, safeId, serviceType, secondJustificatif, imported, dateEditionDevis, ahProElectronic, signataireName, signataireSurname, dateEmission, expirationDate, sienna_id, offre_projets_group, type_id, offreProjet_id, installateurUser_id, justificatif_id, jpe_id, obligeUser_id, obligeUserReal_id, factureDetail_id, contract_id, geolocalisation_id, sousTraitant_id, certilink_id) VALUES (NULL, NULL, NULL, NULL, NULL, 0, 'fiscal-6aaab310208961.13498130-AVIS D\'IMPOSITION.pdf', NULL, 0, 0, 1, 0, 'entity/Justificatif/fiscal-6aaab310208961.13498130-AVIS D\'IMPOSITION.pdf', NULL, NULL, '2026-09-16 17:17:36', '2026-09-16 17:17:36', 0, 0, 0, NULL, 'bd399fb033bdb2b017b52e328a0f85b6', 'S3', NULL, NULL, NULL, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 390, NULL, NULL, 361, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
19	12.18 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";

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\Identite	2
Consoneo\Bundle\UserBundle\Entity\ObligeUser	1
Consoneo\Bundle\UserBundle\Entity\Oblige	1
Consoneo\Bundle\ObligeBundle\Entity\OffreProjet	1
Consoneo\Bundle\UserBundle\Entity\InstallateurUser	1
Consoneo\Bundle\UserBundle\Entity\ParticulierUserContact	1
Consoneo\Bundle\ObligeBundle\Entity\Projet	1
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetState	1
Consoneo\Bundle\SimulateurBundle\Entity\SecteurActivite	1
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetStatus	1
Consoneo\Bundle\SimulateurBundle\Entity\Operation	1
Consoneo\Bundle\ObligeBundle\Entity\SignatureAuto	1
Consoneo\Bundle\UserBundle\Entity\ProjectOwner	1
Consoneo\Bundle\SimulateurBundle\Entity\Simulateur	1
Consoneo\Bundle\SimulateurBundle\Entity\Secteur	1
Consoneo\Bundle\SimulateurBundle\Entity\Categorie	1
Consoneo\Bundle\SimulateurBundle\Entity\TypeOperation	1
Consoneo\Bundle\ObligeBundle\Entity\IntegrationModule	1
Consoneo\Bundle\ObligeBundle\Entity\DocumentType	1
Consoneo\Bundle\UserBundle\Entity\Precarite\Cas1	1
Consoneo\Bundle\UserBundle\Entity\Precarite\Justificatif	1
Consoneo\Bundle\ObligeBundle\Entity\Document	1

read entity manager

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

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\UserBundle\Entity\InstallateurDocumentReference	No errors.
Consoneo\Bundle\UserBundle\Entity\ObligeDocumentTypeConfig	No errors.
Consoneo\Bundle\UserBundle\Entity\Precarite\Cas1	No errors.
Consoneo\Bundle\ObligeBundle\Entity\PaymentMethod	No errors.
Consoneo\Bundle\UserBundle\Entity\Precarite\Declarant	No errors.
Consoneo\Bundle\WorkflowBundle\Entity\SignatureRequest	No errors.
Consoneo\Bundle\ObligeBundle\Entity\UploadedDocument	No errors.
Consoneo\Bundle\ObligeBundle\Entity\CampagneUser	No errors.
Consoneo\Bundle\ObligeBundle\Entity\Position\Geolocalisation	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\UserBundle\Entity\Precarite\Justificatif	No errors.

stats entity manager

No loaded entities.

qrdecode entity manager

Class	Mapping errors
C2eCoreBundle\Entity\DocumentQrDecode	No errors.
Consoneo\Bundle\UserBundle\Entity\Precarite\Justificatif	The target entity 'Consoneo\Bundle\ObligeBundle\Entity\Document' specified on Consoneo\Bundle\UserBundle\Entity\Precarite\Justificatif#documents is unknown or not an entity.

Symfony Profiler

POST https://admin.preprod-orion.dossier-c2e.fr/precarite/modal-update-minfi/VEOS1789475612/

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