Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.appKey AS appKey_2,
  t0.label AS label_3,
  t0.description AS description_4,
  t0.url AS url_5,
  t0.status AS status_6,
  t0.created_at AS created_at_7,
  t0.report_auto_email AS report_auto_email_8,
  t0.logo AS logo_9,
  t0.smartName AS smartName_10,
  t0.prefixEmail AS prefixEmail_11,
  t0.`lead` AS lead_12,
  t0.`leadUrl` AS leadUrl_13,
  t0.`leadLogin` AS leadLogin_14,
  t0.`leadPassword` AS leadPassword_15,
  t0.recommanderProDefault AS recommanderProDefault_16,
  t0.actif AS actif_17,
  t0.allowMultiSubscription AS allowMultiSubscription_18,
  t0.teteReseau_id AS teteReseau_id_19,
  t0.branding AS branding_20
FROM
  IntegrationModule t0
WHERE
  t0.appKey = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.appKey AS appKey_2, t0.label AS label_3, t0.description AS description_4, t0.url AS url_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.report_auto_email AS report_auto_email_8, t0.logo AS logo_9, t0.smartName AS smartName_10, t0.prefixEmail AS prefixEmail_11, t0.`lead` AS lead_12, t0.`leadUrl` AS leadUrl_13, t0.`leadLogin` AS leadLogin_14, t0.`leadPassword` AS leadPassword_15, t0.recommanderProDefault AS recommanderProDefault_16, t0.actif AS actif_17, t0.allowMultiSubscription AS allowMultiSubscription_18, t0.teteReseau_id AS teteReseau_id_19, t0.branding AS branding_20 FROM IntegrationModule t0 WHERE t0.appKey = 'qGfP' LIMIT 1;

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.end_zni_date AS end_zni_date_88,
  t52.zni AS zni_89,
  t52.simulateur_id AS simulateur_id_90,
  t52.arrete_id AS arrete_id_91,
  t52.certification_id AS certification_id_92,
  t52.qualification_id AS qualification_id_93,
  t52.formConfigEngine_id AS formConfigEngine_id_94,
  t0.entrepriseUser_id AS entrepriseUser_id_95,
  t0.particulierUser_id AS particulierUser_id_96,
  t0.installateurUser_id AS installateurUser_id_97,
  t0.beUser_id AS beUser_id_98,
  t99.id AS id_100,
  t99.type AS type_101,
  t99.pricingType AS pricingType_102,
  t99.finalisationRequested AS finalisationRequested_103,
  t99.finalisationRequestDate AS finalisationRequestDate_104,
  t99.reference AS reference_105,
  t99.data AS data_106,
  t99.cofracData AS cofracData_107,
  t99.ip AS ip_108,
  t99.offre_auto_date AS offre_auto_date_109,
  t99.created_datetime AS created_datetime_110,
  t99.updated_datetime AS updated_datetime_111,
  t99.tel AS tel_112,
  t99.codepostal AS codepostal_113,
  t99.adresse AS adresse_114,
  t99.adresse_complement AS adresse_complement_115,
  t99.ville AS ville_116,
  t99.delai_souhaite AS delai_souhaite_117,
  t99.accept_recevoir_offre AS accept_recevoir_offre_118,
  t99.accept_recommandation AS accept_recommandation_119,
  t99.acceptLeadPromo AS acceptLeadPromo_120,
  t99.offre_cumac AS offre_cumac_121,
  t99.offre_cumac_client AS offre_cumac_client_122,
  t99.offre_cumac_precarite AS offre_cumac_precarite_123,
  t99.offre_cumac_client_precarite AS offre_cumac_client_precarite_124,
  t99.cumac AS cumac_125,
  t99.cumac_AFT AS cumac_AFT_126,
  t99.total_prime AS total_prime_127,
  t99.total_prime_AFT AS total_prime_AFT_128,
  t99.prime_pro AS prime_pro_129,
  t99.prime_pro_aft AS prime_pro_aft_130,
  t99.prime_client AS prime_client_131,
  t99.prime_client_aft AS prime_client_aft_132,
  t99.cumac_moyenne AS cumac_moyenne_133,
  t99.taux_actualise AS taux_actualise_134,
  t99.taux_accumule AS taux_accumule_135,
  t99.date_debut_chantier AS date_debut_chantier_136,
  t99.date_demande_offre AS date_demande_offre_137,
  t99.date_fin_chantier AS date_fin_chantier_138,
  t99.etat AS etat_139,
  t99.status AS status_140,
  t99.date_offre AS date_offre_141,
  t99.notification_date_chantier AS notification_date_chantier_142,
  t99.date_retour_conv AS date_retour_conv_143,
  t99.date_validation_conv AS date_validation_conv_144,
  t99.date_chantier_renseigne AS date_chantier_renseigne_145,
  t99.date_paiement AS date_paiement_146,
  t99.date_all_doc_valid AS date_all_doc_valid_147,
  t99.date_fin_chantier_repousse AS date_fin_chantier_repousse_148,
  t99.date_envoi_questionnaire AS date_envoi_questionnaire_149,
  t99.date_edition_questionnaire AS date_edition_questionnaire_150,
  t99.date_validation_final AS date_validation_final_151,
  t99.date_annulation AS date_annulation_152,
  t99.no_click_email_date_chantier AS no_click_email_date_chantier_153,
  t99.token AS token_154,
  t99.auto_installation AS auto_installation_155,
  t99.siret AS siret_156,
  t99.cancelReason AS cancelReason_157,
  t99.dateCommande AS dateCommande_158,
  t99.siteTravaux AS siteTravaux_159,
  t99.incitation AS incitation_160,
  t99.qualificationRecordDate AS qualificationRecordDate_161,
  t99.serviceType AS serviceType_162,
  t99.debutChantier AS debutChantier_163,
  t99.finChantier AS finChantier_164,
  t99.initiateCDP AS initiateCDP_165,
  t99.cdp AS cdp_166,
  t99.date_last_envoi_convention AS date_last_envoi_convention_167,
  t99.programStep AS programStep_168,
  t99.devisRestAPayer AS devisRestAPayer_169,
  t99.pricingMandatClassique AS pricingMandatClassique_170,
  t99.pricingMandatPreca AS pricingMandatPreca_171,
  t99.isCOFRAC AS isCOFRAC_172,
  t99.applicationFeesPrice AS applicationFeesPrice_173,
  t99.attributes AS attributes_174,
  t99.engineDocumentId AS engineDocumentId_175,
  t99.batchOffreProjet_id AS batchOffreProjet_id_176,
  t99.entrepriseUser_id AS entrepriseUser_id_177,
  t99.installateurUser_id AS installateurUser_id_178,
  t99.beUser_id AS beUser_id_179,
  t99.entrepriseUserContact_id AS entrepriseUserContact_id_180,
  t99.particulierUserContact_id AS particulierUserContact_id_181,
  t99.signataireEntreprise_id AS signataireEntreprise_id_182,
  t99.signataireInstallateur_id AS signataireInstallateur_id_183,
  t99.installateurUserContact_id AS installateurUserContact_id_184,
  t99.projet_id AS projet_id_185,
  t99.precariteCas2_id AS precariteCas2_id_186,
  t99.precarite_id AS precarite_id_187,
  t99.state_id AS state_id_188,
  t99.oblige_id AS oblige_id_189,
  t99.secteurActivite_id AS secteurActivite_id_190,
  t99.factureDetail_id AS factureDetail_id_191,
  t99.offreStatus_id AS offreStatus_id_192,
  t99.identiteBeneficiaire_id AS identiteBeneficiaire_id_193,
  t99.identiteInstallateur_id AS identiteInstallateur_id_194,
  t99.operation_id AS operation_id_195,
  t99.particulierUser_id AS particulierUser_id_196,
  t99.qualificationRecord_id AS qualificationRecord_id_197,
  t99.sousTraitant_id AS sousTraitant_id_198,
  t99.program_id AS program_id_199,
  t99.programCommercial_id AS programCommercial_id_200,
  t99.programManager_id AS programManager_id_201,
  t99.signatureAuto_id AS signatureAuto_id_202,
  t99.wasteCenter_id AS wasteCenter_id_203,
  t99.waste_id AS waste_id_204,
  t99.programAuto_id AS programAuto_id_205,
  t99.justificatif_id AS justificatif_id_206,
  t99.cappingRule_id AS cappingRule_id_207,
  t99.projectOwner_id AS projectOwner_id_208,
  t99.project_bundle_id AS project_bundle_id_209,
  t99.estate_id AS estate_id_210,
  t0.precarite_id AS precarite_id_211,
  t0.secteurActivite_id AS secteurActivite_id_212,
  t0.integrationModule_id AS integrationModule_id_213,
  t0.precariteCas2_id AS precariteCas2_id_214,
  t0.program_id AS program_id_215,
  t0.programCommercial_id AS programCommercial_id_216,
  t0.programManager_id AS programManager_id_217,
  t0.justificatif_id AS justificatif_id_218,
  t219.id AS id_220,
  t219.numero AS numero_221,
  t219.dateRealisation AS dateRealisation_222,
  t219.dateFinValidite AS dateFinValidite_223,
  t219.etiquetteBilan AS etiquetteBilan_224,
  t219.createdAt AS createdAt_225,
  t219.updatedAt AS updatedAt_226,
  t219.typeJustificatif AS typeJustificatif_227,
  t219.projet_id AS projet_id_228,
  t219.offreProjet_id AS offreProjet_id_229,
  t0.project_bundle_id AS project_bundle_id_230,
  t0.estate_id AS estate_id_231
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 t99 ON t99.projet_id = t0.id
  LEFT JOIN JustificatifPerformanceEnergetique t219 ON t219.projet_id = t0.id
WHERE
  t0.reference = ?
LIMIT
  1

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.end_zni_date AS end_zni_date_88, t52.zni AS zni_89, t52.simulateur_id AS simulateur_id_90, t52.arrete_id AS arrete_id_91, t52.certification_id AS certification_id_92, t52.qualification_id AS qualification_id_93, t52.formConfigEngine_id AS formConfigEngine_id_94, t0.entrepriseUser_id AS entrepriseUser_id_95, t0.particulierUser_id AS particulierUser_id_96, t0.installateurUser_id AS installateurUser_id_97, t0.beUser_id AS beUser_id_98, t99.id AS id_100, t99.type AS type_101, t99.pricingType AS pricingType_102, t99.finalisationRequested AS finalisationRequested_103, t99.finalisationRequestDate AS finalisationRequestDate_104, t99.reference AS reference_105, t99.data AS data_106, t99.cofracData AS cofracData_107, t99.ip AS ip_108, t99.offre_auto_date AS offre_auto_date_109, t99.created_datetime AS created_datetime_110, t99.updated_datetime AS updated_datetime_111, t99.tel AS tel_112, t99.codepostal AS codepostal_113, t99.adresse AS adresse_114, t99.adresse_complement AS adresse_complement_115, t99.ville AS ville_116, t99.delai_souhaite AS delai_souhaite_117, t99.accept_recevoir_offre AS accept_recevoir_offre_118, t99.accept_recommandation AS accept_recommandation_119, t99.acceptLeadPromo AS acceptLeadPromo_120, t99.offre_cumac AS offre_cumac_121, t99.offre_cumac_client AS offre_cumac_client_122, t99.offre_cumac_precarite AS offre_cumac_precarite_123, t99.offre_cumac_client_precarite AS offre_cumac_client_precarite_124, t99.cumac AS cumac_125, t99.cumac_AFT AS cumac_AFT_126, t99.total_prime AS total_prime_127, t99.total_prime_AFT AS total_prime_AFT_128, t99.prime_pro AS prime_pro_129, t99.prime_pro_aft AS prime_pro_aft_130, t99.prime_client AS prime_client_131, t99.prime_client_aft AS prime_client_aft_132, t99.cumac_moyenne AS cumac_moyenne_133, t99.taux_actualise AS taux_actualise_134, t99.taux_accumule AS taux_accumule_135, t99.date_debut_chantier AS date_debut_chantier_136, t99.date_demande_offre AS date_demande_offre_137, t99.date_fin_chantier AS date_fin_chantier_138, t99.etat AS etat_139, t99.status AS status_140, t99.date_offre AS date_offre_141, t99.notification_date_chantier AS notification_date_chantier_142, t99.date_retour_conv AS date_retour_conv_143, t99.date_validation_conv AS date_validation_conv_144, t99.date_chantier_renseigne AS date_chantier_renseigne_145, t99.date_paiement AS date_paiement_146, t99.date_all_doc_valid AS date_all_doc_valid_147, t99.date_fin_chantier_repousse AS date_fin_chantier_repousse_148, t99.date_envoi_questionnaire AS date_envoi_questionnaire_149, t99.date_edition_questionnaire AS date_edition_questionnaire_150, t99.date_validation_final AS date_validation_final_151, t99.date_annulation AS date_annulation_152, t99.no_click_email_date_chantier AS no_click_email_date_chantier_153, t99.token AS token_154, t99.auto_installation AS auto_installation_155, t99.siret AS siret_156, t99.cancelReason AS cancelReason_157, t99.dateCommande AS dateCommande_158, t99.siteTravaux AS siteTravaux_159, t99.incitation AS incitation_160, t99.qualificationRecordDate AS qualificationRecordDate_161, t99.serviceType AS serviceType_162, t99.debutChantier AS debutChantier_163, t99.finChantier AS finChantier_164, t99.initiateCDP AS initiateCDP_165, t99.cdp AS cdp_166, t99.date_last_envoi_convention AS date_last_envoi_convention_167, t99.programStep AS programStep_168, t99.devisRestAPayer AS devisRestAPayer_169, t99.pricingMandatClassique AS pricingMandatClassique_170, t99.pricingMandatPreca AS pricingMandatPreca_171, t99.isCOFRAC AS isCOFRAC_172, t99.applicationFeesPrice AS applicationFeesPrice_173, t99.attributes AS attributes_174, t99.engineDocumentId AS engineDocumentId_175, t99.batchOffreProjet_id AS batchOffreProjet_id_176, t99.entrepriseUser_id AS entrepriseUser_id_177, t99.installateurUser_id AS installateurUser_id_178, t99.beUser_id AS beUser_id_179, t99.entrepriseUserContact_id AS entrepriseUserContact_id_180, t99.particulierUserContact_id AS particulierUserContact_id_181, t99.signataireEntreprise_id AS signataireEntreprise_id_182, t99.signataireInstallateur_id AS signataireInstallateur_id_183, t99.installateurUserContact_id AS installateurUserContact_id_184, t99.projet_id AS projet_id_185, t99.precariteCas2_id AS precariteCas2_id_186, t99.precarite_id AS precarite_id_187, t99.state_id AS state_id_188, t99.oblige_id AS oblige_id_189, t99.secteurActivite_id AS secteurActivite_id_190, t99.factureDetail_id AS factureDetail_id_191, t99.offreStatus_id AS offreStatus_id_192, t99.identiteBeneficiaire_id AS identiteBeneficiaire_id_193, t99.identiteInstallateur_id AS identiteInstallateur_id_194, t99.operation_id AS operation_id_195, t99.particulierUser_id AS particulierUser_id_196, t99.qualificationRecord_id AS qualificationRecord_id_197, t99.sousTraitant_id AS sousTraitant_id_198, t99.program_id AS program_id_199, t99.programCommercial_id AS programCommercial_id_200, t99.programManager_id AS programManager_id_201, t99.signatureAuto_id AS signatureAuto_id_202, t99.wasteCenter_id AS wasteCenter_id_203, t99.waste_id AS waste_id_204, t99.programAuto_id AS programAuto_id_205, t99.justificatif_id AS justificatif_id_206, t99.cappingRule_id AS cappingRule_id_207, t99.projectOwner_id AS projectOwner_id_208, t99.project_bundle_id AS project_bundle_id_209, t99.estate_id AS estate_id_210, t0.precarite_id AS precarite_id_211, t0.secteurActivite_id AS secteurActivite_id_212, t0.integrationModule_id AS integrationModule_id_213, t0.precariteCas2_id AS precariteCas2_id_214, t0.program_id AS program_id_215, t0.programCommercial_id AS programCommercial_id_216, t0.programManager_id AS programManager_id_217, t0.justificatif_id AS justificatif_id_218, t219.id AS id_220, t219.numero AS numero_221, t219.dateRealisation AS dateRealisation_222, t219.dateFinValidite AS dateFinValidite_223, t219.etiquetteBilan AS etiquetteBilan_224, t219.createdAt AS createdAt_225, t219.updatedAt AS updatedAt_226, t219.typeJustificatif AS typeJustificatif_227, t219.projet_id AS projet_id_228, t219.offreProjet_id AS offreProjet_id_229, t0.project_bundle_id AS project_bundle_id_230, t0.estate_id AS estate_id_231 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 t99 ON t99.projet_id = t0.id LEFT JOIN JustificatifPerformanceEnergetique t219 ON t219.projet_id = t0.id WHERE t0.reference = '204452aacf4323009cdd9090485fc883' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.created_datetime AS created_datetime_2,
  t0.convention AS convention_3,
  t0.aft AS aft_4,
  t0.facture AS facture_5,
  t0.beneficiaire AS beneficiaire_6,
  t0.installateur AS installateur_7,
  t0.doc_obligatoire AS doc_obligatoire_8,
  t0.coherence_dossier AS coherence_dossier_9,
  t0.offre_id AS offre_id_10
FROM
  OffreProjetValidation t0
WHERE
  t0.offre_id = ?

SELECT t0.id AS id_1, t0.created_datetime AS created_datetime_2, t0.convention AS convention_3, t0.aft AS aft_4, t0.facture AS facture_5, t0.beneficiaire AS beneficiaire_6, t0.installateur AS installateur_7, t0.doc_obligatoire AS doc_obligatoire_8, t0.coherence_dossier AS coherence_dossier_9, t0.offre_id AS offre_id_10 FROM OffreProjetValidation t0 WHERE t0.offre_id = 229;

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.type AS type_3,
  t0.result AS result_4,
  t0.errors AS errors_5,
  t0.message AS message_6,
  t0.created_datetime AS created_datetime_7,
  t0.integrationModule_id AS integrationModule_id_8,
  t0.offre_id AS offre_id_9
FROM
  `Lead` t0
WHERE
  t0.offre_id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.type AS type_3, t0.result AS result_4, t0.errors AS errors_5, t0.message AS message_6, t0.created_datetime AS created_datetime_7, t0.integrationModule_id AS integrationModule_id_8, t0.offre_id AS offre_id_9 FROM `Lead` t0 WHERE t0.offre_id = 229;

SELECT
  t0.id AS id_1,
  t0.mprUuid AS mprUuid_2,
  t0.mprReference AS mprReference_3,
  t0.paymentDate AS paymentDate_4,
  t0.invoiceReference AS invoiceReference_5,
  t0.invoiceDate AS invoiceDate_6,
  t0.amount AS amount_7,
  t0.archive AS archive_8,
  t0.step AS step_9,
  t0.offreProjet_id AS offreProjet_id_10,
  t0.batchBankTransfer_id AS batchBankTransfer_id_11,
  t0.installateur_id AS installateur_id_12,
  t0.particulierUser_id AS particulierUser_id_13
FROM
  PaymentMpr t0
WHERE
  t0.offreProjet_id = ?

SELECT t0.id AS id_1, t0.mprUuid AS mprUuid_2, t0.mprReference AS mprReference_3, t0.paymentDate AS paymentDate_4, t0.invoiceReference AS invoiceReference_5, t0.invoiceDate AS invoiceDate_6, t0.amount AS amount_7, t0.archive AS archive_8, t0.step AS step_9, t0.offreProjet_id AS offreProjet_id_10, t0.batchBankTransfer_id AS batchBankTransfer_id_11, t0.installateur_id AS installateur_id_12, t0.particulierUser_id AS particulierUser_id_13 FROM PaymentMpr t0 WHERE t0.offreProjet_id = 229;

SELECT
  t0.id AS id_1,
  t0.numero AS numero_2,
  t0.dateRealisation AS dateRealisation_3,
  t0.dateFinValidite AS dateFinValidite_4,
  t0.etiquetteBilan AS etiquetteBilan_5,
  t0.createdAt AS createdAt_6,
  t0.updatedAt AS updatedAt_7,
  t0.typeJustificatif AS typeJustificatif_8,
  t0.projet_id AS projet_id_9,
  t0.offreProjet_id AS offreProjet_id_10
FROM
  JustificatifPerformanceEnergetique t0
WHERE
  t0.offreProjet_id = ?

SELECT t0.id AS id_1, t0.numero AS numero_2, t0.dateRealisation AS dateRealisation_3, t0.dateFinValidite AS dateFinValidite_4, t0.etiquetteBilan AS etiquetteBilan_5, t0.createdAt AS createdAt_6, t0.updatedAt AS updatedAt_7, t0.typeJustificatif AS typeJustificatif_8, t0.projet_id AS projet_id_9, t0.offreProjet_id AS offreProjet_id_10 FROM JustificatifPerformanceEnergetique t0 WHERE t0.offreProjet_id = 229;

SELECT
  t0.id AS id_1,
  t0.`value` AS value_2,
  t0.offreProjet_id AS offreProjet_id_3,
  t0.operation_id AS operation_id_4,
  t0.oblige_id AS oblige_id_5
FROM
  Recensement t0
WHERE
  t0.offreProjet_id = ?

SELECT t0.id AS id_1, t0.`value` AS value_2, t0.offreProjet_id AS offreProjet_id_3, t0.operation_id AS operation_id_4, t0.oblige_id AS oblige_id_5 FROM Recensement t0 WHERE t0.offreProjet_id = 229;

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 = 229;

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.nom AS nom_3,
  t0.nom_cd AS nom_cd_4,
  t0.cdiscount AS cdiscount_5,
  t0.pretty_name AS pretty_name_6,
  t0.status AS status_7,
  t0.slug AS slug_8,
  t0.form_lead_id AS form_lead_id_9,
  t0.active_operation_id AS active_operation_id_10,
  t11.id AS id_12,
  t11.nom AS nom_13,
  t11.version AS version_14,
  t11.code AS code_15,
  t11.duree AS duree_16,
  t11.auto_installation AS auto_installation_17,
  t11.conditions AS conditions_18,
  t11.conditionsRaw AS conditionsRaw_19,
  t11.conditionsFormater AS conditionsFormater_20,
  t11.documents_requis AS documents_requis_21,
  t11.nombre_documents AS nombre_documents_22,
  t11.nombre_conditions AS nombre_conditions_23,
  t11.question_details_type AS question_details_type_24,
  t11.question_details_value AS question_details_value_25,
  t11.periode AS periode_26,
  t11.informationTechnique AS informationTechnique_27,
  t11.informationTechniqueRaw AS informationTechniqueRaw_28,
  t11.informationTechniqueFormater AS informationTechniqueFormater_29,
  t11.informationDocSupplementaire AS informationDocSupplementaire_30,
  t11.informationDocSupplementaireRaw AS informationDocSupplementaireRaw_31,
  t11.informationDocSupplementaireFormater AS informationDocSupplementaireFormater_32,
  t11.informationfacture AS informationfacture_33,
  t11.informationfactureRaw AS informationfactureRaw_34,
  t11.informationfactureFormater AS informationfactureFormater_35,
  t11.informationfacture2 AS informationfacture2_36,
  t11.informationfacture2Raw AS informationfacture2Raw_37,
  t11.informationfacture2Formater AS informationfacture2Formater_38,
  t11.nbMateriau AS nbMateriau_39,
  t11.materiauSubtitle AS materiauSubtitle_40,
  t11.materiauTitle AS materiauTitle_41,
  t11.textForm AS textForm_42,
  t11.private AS private_43,
  t11.campagne AS campagne_44,
  t11.special AS special_45,
  t11.abrogation_datetime AS abrogation_datetime_46,
  t11.end_zni_date AS end_zni_date_47,
  t11.zni AS zni_48,
  t11.simulateur_id AS simulateur_id_49,
  t11.arrete_id AS arrete_id_50,
  t11.certification_id AS certification_id_51,
  t11.qualification_id AS qualification_id_52,
  t11.formConfigEngine_id AS formConfigEngine_id_53,
  t0.secteur_id AS secteur_id_54,
  t0.categorie_id AS categorie_id_55,
  t0.categorieCd_id AS categorieCd_id_56,
  t0.type_operation_id AS type_operation_id_57,
  t0.operation_specifique_id AS operation_specifique_id_58,
  t59.id AS id_60,
  t59.mode AS mode_61,
  t59.targetType AS targetType_62,
  t59.classic AS classic_63,
  t59.preca AS preca_64,
  t59.enable AS enable_65,
  t59.raiType AS raiType_66,
  t59.contractSignedElectronically AS contractSignedElectronically_67,
  t59.pro_signature_mandatory_outlay AS pro_signature_mandatory_outlay_68,
  t59.obligeTarget_id AS obligeTarget_id_69,
  t59.teteReseau_id AS teteReseau_id_70,
  t59.simulateur_id AS simulateur_id_71,
  t59.installateurTarget_id AS installateurTarget_id_72,
  t59.beTarget_id AS beTarget_id_73
FROM
  Simulateur t0
  LEFT JOIN Operation t11 ON t0.active_operation_id = t11.id
  LEFT JOIN AffectationConsoneoRule t59 ON t59.simulateur_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.nom AS nom_3, t0.nom_cd AS nom_cd_4, t0.cdiscount AS cdiscount_5, t0.pretty_name AS pretty_name_6, t0.status AS status_7, t0.slug AS slug_8, t0.form_lead_id AS form_lead_id_9, t0.active_operation_id AS active_operation_id_10, t11.id AS id_12, t11.nom AS nom_13, t11.version AS version_14, t11.code AS code_15, t11.duree AS duree_16, t11.auto_installation AS auto_installation_17, t11.conditions AS conditions_18, t11.conditionsRaw AS conditionsRaw_19, t11.conditionsFormater AS conditionsFormater_20, t11.documents_requis AS documents_requis_21, t11.nombre_documents AS nombre_documents_22, t11.nombre_conditions AS nombre_conditions_23, t11.question_details_type AS question_details_type_24, t11.question_details_value AS question_details_value_25, t11.periode AS periode_26, t11.informationTechnique AS informationTechnique_27, t11.informationTechniqueRaw AS informationTechniqueRaw_28, t11.informationTechniqueFormater AS informationTechniqueFormater_29, t11.informationDocSupplementaire AS informationDocSupplementaire_30, t11.informationDocSupplementaireRaw AS informationDocSupplementaireRaw_31, t11.informationDocSupplementaireFormater AS informationDocSupplementaireFormater_32, t11.informationfacture AS informationfacture_33, t11.informationfactureRaw AS informationfactureRaw_34, t11.informationfactureFormater AS informationfactureFormater_35, t11.informationfacture2 AS informationfacture2_36, t11.informationfacture2Raw AS informationfacture2Raw_37, t11.informationfacture2Formater AS informationfacture2Formater_38, t11.nbMateriau AS nbMateriau_39, t11.materiauSubtitle AS materiauSubtitle_40, t11.materiauTitle AS materiauTitle_41, t11.textForm AS textForm_42, t11.private AS private_43, t11.campagne AS campagne_44, t11.special AS special_45, t11.abrogation_datetime AS abrogation_datetime_46, t11.end_zni_date AS end_zni_date_47, t11.zni AS zni_48, t11.simulateur_id AS simulateur_id_49, t11.arrete_id AS arrete_id_50, t11.certification_id AS certification_id_51, t11.qualification_id AS qualification_id_52, t11.formConfigEngine_id AS formConfigEngine_id_53, t0.secteur_id AS secteur_id_54, t0.categorie_id AS categorie_id_55, t0.categorieCd_id AS categorieCd_id_56, t0.type_operation_id AS type_operation_id_57, t0.operation_specifique_id AS operation_specifique_id_58, t59.id AS id_60, t59.mode AS mode_61, t59.targetType AS targetType_62, t59.classic AS classic_63, t59.preca AS preca_64, t59.enable AS enable_65, t59.raiType AS raiType_66, t59.contractSignedElectronically AS contractSignedElectronically_67, t59.pro_signature_mandatory_outlay AS pro_signature_mandatory_outlay_68, t59.obligeTarget_id AS obligeTarget_id_69, t59.teteReseau_id AS teteReseau_id_70, t59.simulateur_id AS simulateur_id_71, t59.installateurTarget_id AS installateurTarget_id_72, t59.beTarget_id AS beTarget_id_73 FROM Simulateur t0 LEFT JOIN Operation t11 ON t0.active_operation_id = t11.id LEFT JOIN AffectationConsoneoRule t59 ON t59.simulateur_id = t0.id WHERE t0.id = 441;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.status AS status_4
FROM
  Secteur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.status AS status_4 FROM Secteur t0 WHERE t0.id = 2;