Symfony Profiler

SELECT
  t0.signature AS signature_1,
  t0.logo AS logo_2,
  t0.formation_installateur_doc AS formation_installateur_doc_3,
  t0.pres_marketing_installateur AS pres_marketing_installateur_4,
  t0.guide_utilisation_commerciaux AS guide_utilisation_commerciaux_5,
  t0.guidePerformanceEnergetiqueB2b AS guidePerformanceEnergetiqueB2b_6,
  t0.guidePerformanceEnergetiqueB2c AS guidePerformanceEnergetiqueB2c_7,
  t0.cgu AS cgu_8,
  t0.partenariatContract AS partenariatContract_9,
  t0.tel_beneficiaire_B2C AS tel_beneficiaire_B2C_10,
  t0.tel_beneficiaire_B2B AS tel_beneficiaire_B2B_11,
  t0.tel_installateur AS tel_installateur_12,
  t0.tel_support_intern AS tel_support_intern_13,
  t0.fax_beneficiaire AS fax_beneficiaire_14,
  t0.fax_installateur AS fax_installateur_15,
  t0.adresse AS adresse_16,
  t0.adresse_complement AS adresse_complement_17,
  t0.codepostal AS codepostal_18,
  t0.ville AS ville_19,
  t0.email_beneficiaire AS email_beneficiaire_20,
  t0.email_installateur AS email_installateur_21,
  t0.is_consoneo AS is_consoneo_22,
  t0.slug AS slug_23,
  t0.conventionElectronique AS conventionElectronique_24,
  t0.aftElectronique AS aftElectronique_25,
  t0.contratInstallateur AS contratInstallateur_26,
  t0.modeProBeneficiaireInscription AS modeProBeneficiaireInscription_27,
  t0.modeByPassSuperviseur AS modeByPassSuperviseur_28,
  t0.`lead` AS lead_29,
  t0.`leadUrl` AS leadUrl_30,
  t0.`leadLogin` AS leadLogin_31,
  t0.`leadPassword` AS leadPassword_32,
  t0.relanceConventionClientUn AS relanceConventionClientUn_33,
  t0.relanceConventionClientDeux AS relanceConventionClientDeux_34,
  t0.alertConventionClient AS alertConventionClient_35,
  t0.relanceConventionInstallateurUn AS relanceConventionInstallateurUn_36,
  t0.relanceConventionInstallateurDeux AS relanceConventionInstallateurDeux_37,
  t0.alertConventionInstallateur AS alertConventionInstallateur_38,
  t0.conventionFin AS conventionFin_39,
  t0.questionnaireAftRelanceUn AS questionnaireAftRelanceUn_40,
  t0.questionnaireAftRelanceDeux AS questionnaireAftRelanceDeux_41,
  t0.alertQuestionnaireAFT AS alertQuestionnaireAFT_42,
  t0.questionnaireAftFin AS questionnaireAftFin_43,
  t0.relanceAftFacture AS relanceAftFacture_44,
  t0.alertAftFacture AS alertAftFacture_45,
  t0.aftFactureFin AS aftFactureFin_46,
  t0.mentionCnil AS mentionCnil_47,
  t0.serviceType AS serviceType_48,
  t0.precariteMode AS precariteMode_49,
  t0.precariteModeProgram AS precariteModeProgram_50,
  t0.blocked AS blocked_51,
  t0.blockedSimulation AS blockedSimulation_52,
  t0.resiliation AS resiliation_53,
  t0.archivageAuto AS archivageAuto_54,
  t0.travauxPostDevis AS travauxPostDevis_55,
  t0.emailFacturationPro AS emailFacturationPro_56,
  t0.mandatoryInstallateurGenericContract AS mandatoryInstallateurGenericContract_57,
  t0.hiddenEmail AS hiddenEmail_58,
  t0.visibilityCommercials AS visibilityCommercials_59,
  t0.mandat AS mandat_60,
  t0.pricingMandatClassique AS pricingMandatClassique_61,
  t0.pricingMandatPreca AS pricingMandatPreca_62,
  t0.pricingPrimeMaximumMandatClassique AS pricingPrimeMaximumMandatClassique_63,
  t0.pricingPrimeMaximumMandatPreca AS pricingPrimeMaximumMandatPreca_64,
  t0.originauxAdresse AS originauxAdresse_65,
  t0.originauxAdresseComplement AS originauxAdresseComplement_66,
  t0.originauxCodepostal AS originauxCodepostal_67,
  t0.originauxVille AS originauxVille_68,
  t0.eligible AS eligible_69,
  t0.satisfactionSurvey AS satisfactionSurvey_70,
  t0.surveyConfiguration AS surveyConfiguration_71,
  t0.autoPayment AS autoPayment_72,
  t0.isAnnexeDechetQuestion AS isAnnexeDechetQuestion_73,
  t0.aiEnabled AS aiEnabled_74,
  t0.isSignatureAutoAhEnabled AS isSignatureAutoAhEnabled_75,
  t0.isSignatureAutoOtherDocumentsEnabled AS isSignatureAutoOtherDocumentsEnabled_76,
  t0.emailVersion AS emailVersion_77,
  t0.validateBackwards AS validateBackwards_78,
  t0.displayTelConsoneo AS displayTelConsoneo_79,
  t0.allowedUniverSign AS allowedUniverSign_80,
  t0.allowedApplicationFees AS allowedApplicationFees_81,
  t0.displayApplicationFees AS displayApplicationFees_82,
  t0.programAutoAllowed AS programAutoAllowed_83,
  t0.mpr AS mpr_84,
  t0.isRibActivated AS isRibActivated_85,
  t0.id AS id_86,
  t0.raison AS raison_87,
  t0.siret AS siret_88,
  t0.website AS website_89,
  t0.effectif AS effectif_90,
  t0.status AS status_91,
  t0.created_datetime AS created_datetime_92,
  t0.updated_datetime AS updated_datetime_93,
  t0.canonicalTeteReseau_id AS canonicalTeteReseau_id_94,
  t0.oblige_id AS oblige_id_95,
  t96.id AS id_97,
  t96.raison AS raison_98,
  t96.email AS email_99,
  t96.tel AS tel_100,
  t96.site_web AS site_web_101,
  t96.adresse AS adresse_102,
  t96.cp AS cp_103,
  t96.ville AS ville_104,
  t96.oblige_id AS oblige_id_105,
  t106.id AS id_107,
  t106.gender AS gender_108,
  t106.firstName AS firstName_109,
  t106.name AS name_110,
  t106.raison AS raison_111,
  t106.email AS email_112,
  t106.tel AS tel_113,
  t106.address AS address_114,
  t106.cp AS cp_115,
  t106.city AS city_116,
  t106.adminMandate AS adminMandate_117,
  t106.financialMandate AS financialMandate_118,
  t106.mixteMandate AS mixteMandate_119,
  t106.signature AS signature_120,
  t106.tutorial_admin AS tutorial_admin_121,
  t106.tutorial_mixte AS tutorial_mixte_122,
  t106.tutorial_financial AS tutorial_financial_123,
  t106.oblige_id AS oblige_id_124,
  t125.id AS id_126,
  t125.raison AS raison_127,
  t125.siret AS siret_128,
  t125.oblige_id AS oblige_id_129
FROM
  Oblige t0
  LEFT JOIN Mediateur t96 ON t96.oblige_id = t0.id
  LEFT JOIN MprConfig t106 ON t106.oblige_id = t0.id
  LEFT JOIN Mandataire t125 ON t125.oblige_id = t0.id
WHERE
  t0.id = ?

SELECT t0.signature AS signature_1, t0.logo AS logo_2, t0.formation_installateur_doc AS formation_installateur_doc_3, t0.pres_marketing_installateur AS pres_marketing_installateur_4, t0.guide_utilisation_commerciaux AS guide_utilisation_commerciaux_5, t0.guidePerformanceEnergetiqueB2b AS guidePerformanceEnergetiqueB2b_6, t0.guidePerformanceEnergetiqueB2c AS guidePerformanceEnergetiqueB2c_7, t0.cgu AS cgu_8, t0.partenariatContract AS partenariatContract_9, t0.tel_beneficiaire_B2C AS tel_beneficiaire_B2C_10, t0.tel_beneficiaire_B2B AS tel_beneficiaire_B2B_11, t0.tel_installateur AS tel_installateur_12, t0.tel_support_intern AS tel_support_intern_13, t0.fax_beneficiaire AS fax_beneficiaire_14, t0.fax_installateur AS fax_installateur_15, t0.adresse AS adresse_16, t0.adresse_complement AS adresse_complement_17, t0.codepostal AS codepostal_18, t0.ville AS ville_19, t0.email_beneficiaire AS email_beneficiaire_20, t0.email_installateur AS email_installateur_21, t0.is_consoneo AS is_consoneo_22, t0.slug AS slug_23, t0.conventionElectronique AS conventionElectronique_24, t0.aftElectronique AS aftElectronique_25, t0.contratInstallateur AS contratInstallateur_26, t0.modeProBeneficiaireInscription AS modeProBeneficiaireInscription_27, t0.modeByPassSuperviseur AS modeByPassSuperviseur_28, t0.`lead` AS lead_29, t0.`leadUrl` AS leadUrl_30, t0.`leadLogin` AS leadLogin_31, t0.`leadPassword` AS leadPassword_32, t0.relanceConventionClientUn AS relanceConventionClientUn_33, t0.relanceConventionClientDeux AS relanceConventionClientDeux_34, t0.alertConventionClient AS alertConventionClient_35, t0.relanceConventionInstallateurUn AS relanceConventionInstallateurUn_36, t0.relanceConventionInstallateurDeux AS relanceConventionInstallateurDeux_37, t0.alertConventionInstallateur AS alertConventionInstallateur_38, t0.conventionFin AS conventionFin_39, t0.questionnaireAftRelanceUn AS questionnaireAftRelanceUn_40, t0.questionnaireAftRelanceDeux AS questionnaireAftRelanceDeux_41, t0.alertQuestionnaireAFT AS alertQuestionnaireAFT_42, t0.questionnaireAftFin AS questionnaireAftFin_43, t0.relanceAftFacture AS relanceAftFacture_44, t0.alertAftFacture AS alertAftFacture_45, t0.aftFactureFin AS aftFactureFin_46, t0.mentionCnil AS mentionCnil_47, t0.serviceType AS serviceType_48, t0.precariteMode AS precariteMode_49, t0.precariteModeProgram AS precariteModeProgram_50, t0.blocked AS blocked_51, t0.blockedSimulation AS blockedSimulation_52, t0.resiliation AS resiliation_53, t0.archivageAuto AS archivageAuto_54, t0.travauxPostDevis AS travauxPostDevis_55, t0.emailFacturationPro AS emailFacturationPro_56, t0.mandatoryInstallateurGenericContract AS mandatoryInstallateurGenericContract_57, t0.hiddenEmail AS hiddenEmail_58, t0.visibilityCommercials AS visibilityCommercials_59, t0.mandat AS mandat_60, t0.pricingMandatClassique AS pricingMandatClassique_61, t0.pricingMandatPreca AS pricingMandatPreca_62, t0.pricingPrimeMaximumMandatClassique AS pricingPrimeMaximumMandatClassique_63, t0.pricingPrimeMaximumMandatPreca AS pricingPrimeMaximumMandatPreca_64, t0.originauxAdresse AS originauxAdresse_65, t0.originauxAdresseComplement AS originauxAdresseComplement_66, t0.originauxCodepostal AS originauxCodepostal_67, t0.originauxVille AS originauxVille_68, t0.eligible AS eligible_69, t0.satisfactionSurvey AS satisfactionSurvey_70, t0.surveyConfiguration AS surveyConfiguration_71, t0.autoPayment AS autoPayment_72, t0.isAnnexeDechetQuestion AS isAnnexeDechetQuestion_73, t0.aiEnabled AS aiEnabled_74, t0.isSignatureAutoAhEnabled AS isSignatureAutoAhEnabled_75, t0.isSignatureAutoOtherDocumentsEnabled AS isSignatureAutoOtherDocumentsEnabled_76, t0.emailVersion AS emailVersion_77, t0.validateBackwards AS validateBackwards_78, t0.displayTelConsoneo AS displayTelConsoneo_79, t0.allowedUniverSign AS allowedUniverSign_80, t0.allowedApplicationFees AS allowedApplicationFees_81, t0.displayApplicationFees AS displayApplicationFees_82, t0.programAutoAllowed AS programAutoAllowed_83, t0.mpr AS mpr_84, t0.isRibActivated AS isRibActivated_85, t0.id AS id_86, t0.raison AS raison_87, t0.siret AS siret_88, t0.website AS website_89, t0.effectif AS effectif_90, t0.status AS status_91, t0.created_datetime AS created_datetime_92, t0.updated_datetime AS updated_datetime_93, t0.canonicalTeteReseau_id AS canonicalTeteReseau_id_94, t0.oblige_id AS oblige_id_95, t96.id AS id_97, t96.raison AS raison_98, t96.email AS email_99, t96.tel AS tel_100, t96.site_web AS site_web_101, t96.adresse AS adresse_102, t96.cp AS cp_103, t96.ville AS ville_104, t96.oblige_id AS oblige_id_105, t106.id AS id_107, t106.gender AS gender_108, t106.firstName AS firstName_109, t106.name AS name_110, t106.raison AS raison_111, t106.email AS email_112, t106.tel AS tel_113, t106.address AS address_114, t106.cp AS cp_115, t106.city AS city_116, t106.adminMandate AS adminMandate_117, t106.financialMandate AS financialMandate_118, t106.mixteMandate AS mixteMandate_119, t106.signature AS signature_120, t106.tutorial_admin AS tutorial_admin_121, t106.tutorial_mixte AS tutorial_mixte_122, t106.tutorial_financial AS tutorial_financial_123, t106.oblige_id AS oblige_id_124, t125.id AS id_126, t125.raison AS raison_127, t125.siret AS siret_128, t125.oblige_id AS oblige_id_129 FROM Oblige t0 LEFT JOIN Mediateur t96 ON t96.oblige_id = t0.id LEFT JOIN MprConfig t106 ON t106.oblige_id = t0.id LEFT JOIN Mandataire t125 ON t125.oblige_id = t0.id WHERE t0.id = 6;

SELECT
  s0_.id AS id_0,
  s0_.reference AS reference_1,
  s0_.nom AS nom_2,
  s0_.nom_cd AS nom_cd_3,
  s0_.cdiscount AS cdiscount_4,
  s0_.pretty_name AS pretty_name_5,
  s0_.status AS status_6,
  s0_.slug AS slug_7,
  s0_.form_lead_id AS form_lead_id_8,
  s0_.active_operation_id AS active_operation_id_9,
  s0_.secteur_id AS secteur_id_10,
  s0_.categorie_id AS categorie_id_11,
  s0_.categorieCd_id AS categorieCd_id_12,
  s0_.type_operation_id AS type_operation_id_13,
  s0_.operation_specifique_id AS operation_specifique_id_14
FROM
  Simulateur s0_
  INNER JOIN Operation o1_ ON s0_.active_operation_id = o1_.id
  INNER JOIN simulateur_secteuractivite s3_ ON s0_.id = s3_.simulateur_id
  INNER JOIN SecteurActivite s2_ ON s2_.id = s3_.secteuractivite_id
  INNER JOIN ObligeOperation o4_ ON o1_.id = o4_.operation_id
  INNER JOIN Oblige o5_ ON o4_.oblige_id = o5_.id
WHERE
  s2_.name IN ('Appartement individuel')
  AND s0_.status = ?
  AND o1_.campagne = ?
  AND s0_.categorie_id = ?
  AND o4_.active = ?
  AND o5_.id = ?
  AND (
    o1_.abrogation_datetime IS NULL
    OR o1_.abrogation_datetime > ?
  )

SELECT s0_.id AS id_0, s0_.reference AS reference_1, s0_.nom AS nom_2, s0_.nom_cd AS nom_cd_3, s0_.cdiscount AS cdiscount_4, s0_.pretty_name AS pretty_name_5, s0_.status AS status_6, s0_.slug AS slug_7, s0_.form_lead_id AS form_lead_id_8, s0_.active_operation_id AS active_operation_id_9, s0_.secteur_id AS secteur_id_10, s0_.categorie_id AS categorie_id_11, s0_.categorieCd_id AS categorieCd_id_12, s0_.type_operation_id AS type_operation_id_13, s0_.operation_specifique_id AS operation_specifique_id_14 FROM Simulateur s0_ INNER JOIN Operation o1_ ON s0_.active_operation_id = o1_.id INNER JOIN simulateur_secteuractivite s3_ ON s0_.id = s3_.simulateur_id INNER JOIN SecteurActivite s2_ ON s2_.id = s3_.secteuractivite_id INNER JOIN ObligeOperation o4_ ON o1_.id = o4_.operation_id INNER JOIN Oblige o5_ ON o4_.oblige_id = o5_.id WHERE s2_.name IN ('Appartement individuel') AND s0_.status = 'enable' AND o1_.campagne = 0 AND s0_.categorie_id = 86 AND o4_.active = 1 AND o5_.id = 6 AND (o1_.abrogation_datetime IS NULL OR o1_.abrogation_datetime > '2025-12-26 02:47:23');

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.pretty_name AS pretty_name_2,
  c0_.position_tertiaire AS position_tertiaire_3,
  c0_.position_industriel AS position_industriel_4,
  c0_.position_residentiel AS position_residentiel_5,
  c0_.position_agriculture AS position_agriculture_6,
  c0_.position_reseau AS position_reseau_7,
  c0_.status AS status_8,
  c0_.slug AS slug_9,
  c0_.historical_name AS historical_name_10,
  c0_.formLeadId AS formLeadId_11,
  c0_.cdiscount AS cdiscount_12,
  c0_.icon AS icon_13
FROM
  Categorie c0_
  INNER JOIN categorie_secteuractivite c2_ ON c0_.id = c2_.categorie_id
  INNER JOIN SecteurActivite s1_ ON s1_.id = c2_.secteuractivite_id
  INNER JOIN Simulateur s3_ ON c0_.id = s3_.categorie_id
  INNER JOIN Operation o4_ ON s3_.active_operation_id = o4_.id
WHERE
  o4_.private = ?
  AND s1_.code = ?
ORDER BY
  c0_.position_residentiel ASC

SELECT DISTINCT c0_.id AS id_0, c0_.name AS name_1, c0_.pretty_name AS pretty_name_2, c0_.position_tertiaire AS position_tertiaire_3, c0_.position_industriel AS position_industriel_4, c0_.position_residentiel AS position_residentiel_5, c0_.position_agriculture AS position_agriculture_6, c0_.position_reseau AS position_reseau_7, c0_.status AS status_8, c0_.slug AS slug_9, c0_.historical_name AS historical_name_10, c0_.formLeadId AS formLeadId_11, c0_.cdiscount AS cdiscount_12, c0_.icon AS icon_13 FROM Categorie c0_ INNER JOIN categorie_secteuractivite c2_ ON c0_.id = c2_.categorie_id INNER JOIN SecteurActivite s1_ ON s1_.id = c2_.secteuractivite_id INNER JOIN Simulateur s3_ ON c0_.id = s3_.categorie_id INNER JOIN Operation o4_ ON s3_.active_operation_id = o4_.id WHERE o4_.private = 0 AND s1_.code = 'APPARTEMENT' ORDER BY c0_.position_residentiel ASC;

SELECT
  t0.id AS id_1,
  t0.mode AS mode_2,
  t0.targetType AS targetType_3,
  t0.classic AS classic_4,
  t0.preca AS preca_5,
  t0.enable AS enable_6,
  t0.raiType AS raiType_7,
  t0.contractSignedElectronically AS contractSignedElectronically_8,
  t0.pro_signature_mandatory_outlay AS pro_signature_mandatory_outlay_9,
  t0.obligeTarget_id AS obligeTarget_id_10,
  t0.teteReseau_id AS teteReseau_id_11,
  t0.simulateur_id AS simulateur_id_12,
  t0.installateurTarget_id AS installateurTarget_id_13,
  t0.beTarget_id AS beTarget_id_14
FROM
  AffectationConsoneoRule t0
WHERE
  t0.simulateur_id = ?

SELECT t0.id AS id_1, t0.mode AS mode_2, t0.targetType AS targetType_3, t0.classic AS classic_4, t0.preca AS preca_5, t0.enable AS enable_6, t0.raiType AS raiType_7, t0.contractSignedElectronically AS contractSignedElectronically_8, t0.pro_signature_mandatory_outlay AS pro_signature_mandatory_outlay_9, t0.obligeTarget_id AS obligeTarget_id_10, t0.teteReseau_id AS teteReseau_id_11, t0.simulateur_id AS simulateur_id_12, t0.installateurTarget_id AS installateurTarget_id_13, t0.beTarget_id AS beTarget_id_14 FROM AffectationConsoneoRule t0 WHERE t0.simulateur_id = 253;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.version AS version_3,
  t0.code AS code_4,
  t0.duree AS duree_5,
  t0.auto_installation AS auto_installation_6,
  t0.conditions AS conditions_7,
  t0.conditionsRaw AS conditionsRaw_8,
  t0.conditionsFormater AS conditionsFormater_9,
  t0.documents_requis AS documents_requis_10,
  t0.nombre_documents AS nombre_documents_11,
  t0.nombre_conditions AS nombre_conditions_12,
  t0.question_details_type AS question_details_type_13,
  t0.question_details_value AS question_details_value_14,
  t0.periode AS periode_15,
  t0.informationTechnique AS informationTechnique_16,
  t0.informationTechniqueRaw AS informationTechniqueRaw_17,
  t0.informationTechniqueFormater AS informationTechniqueFormater_18,
  t0.informationDocSupplementaire AS informationDocSupplementaire_19,
  t0.informationDocSupplementaireRaw AS informationDocSupplementaireRaw_20,
  t0.informationDocSupplementaireFormater AS informationDocSupplementaireFormater_21,
  t0.informationfacture AS informationfacture_22,
  t0.informationfactureRaw AS informationfactureRaw_23,
  t0.informationfactureFormater AS informationfactureFormater_24,
  t0.informationfacture2 AS informationfacture2_25,
  t0.informationfacture2Raw AS informationfacture2Raw_26,
  t0.informationfacture2Formater AS informationfacture2Formater_27,
  t0.nbMateriau AS nbMateriau_28,
  t0.materiauSubtitle AS materiauSubtitle_29,
  t0.materiauTitle AS materiauTitle_30,
  t0.textForm AS textForm_31,
  t0.private AS private_32,
  t0.campagne AS campagne_33,
  t0.special AS special_34,
  t0.abrogation_datetime AS abrogation_datetime_35,
  t0.end_zni_date AS end_zni_date_36,
  t0.zni AS zni_37,
  t0.simulateur_id AS simulateur_id_38,
  t0.arrete_id AS arrete_id_39,
  t0.certification_id AS certification_id_40,
  t0.qualification_id AS qualification_id_41,
  t0.formConfigEngine_id AS formConfigEngine_id_42
FROM
  Operation t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.version AS version_3, t0.code AS code_4, t0.duree AS duree_5, t0.auto_installation AS auto_installation_6, t0.conditions AS conditions_7, t0.conditionsRaw AS conditionsRaw_8, t0.conditionsFormater AS conditionsFormater_9, t0.documents_requis AS documents_requis_10, t0.nombre_documents AS nombre_documents_11, t0.nombre_conditions AS nombre_conditions_12, t0.question_details_type AS question_details_type_13, t0.question_details_value AS question_details_value_14, t0.periode AS periode_15, t0.informationTechnique AS informationTechnique_16, t0.informationTechniqueRaw AS informationTechniqueRaw_17, t0.informationTechniqueFormater AS informationTechniqueFormater_18, t0.informationDocSupplementaire AS informationDocSupplementaire_19, t0.informationDocSupplementaireRaw AS informationDocSupplementaireRaw_20, t0.informationDocSupplementaireFormater AS informationDocSupplementaireFormater_21, t0.informationfacture AS informationfacture_22, t0.informationfactureRaw AS informationfactureRaw_23, t0.informationfactureFormater AS informationfactureFormater_24, t0.informationfacture2 AS informationfacture2_25, t0.informationfacture2Raw AS informationfacture2Raw_26, t0.informationfacture2Formater AS informationfacture2Formater_27, t0.nbMateriau AS nbMateriau_28, t0.materiauSubtitle AS materiauSubtitle_29, t0.materiauTitle AS materiauTitle_30, t0.textForm AS textForm_31, t0.private AS private_32, t0.campagne AS campagne_33, t0.special AS special_34, t0.abrogation_datetime AS abrogation_datetime_35, t0.end_zni_date AS end_zni_date_36, t0.zni AS zni_37, t0.simulateur_id AS simulateur_id_38, t0.arrete_id AS arrete_id_39, t0.certification_id AS certification_id_40, t0.qualification_id AS qualification_id_41, t0.formConfigEngine_id AS formConfigEngine_id_42 FROM Operation t0 WHERE t0.id IN (881);

SELECT
  t0.id AS id_1,
  t0.`key` AS key_2,
  t0.`value` AS value_3,
  t0.`description` AS description_4,
  t0.object_id AS object_id_5,
  t0.object_class AS object_class_6,
  t0.is_default AS is_default_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  Configuration t0
WHERE
  t0.`key` = ?
  AND t0.object_id = ?
  AND t0.object_class = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3, t0.`description` AS description_4, t0.object_id AS object_id_5, t0.object_class AS object_class_6, t0.is_default AS is_default_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM Configuration t0 WHERE t0.`key` = 'jpe_activated' AND t0.object_id = 6 AND t0.object_class = 'Consoneo\\Bundle\\UserBundle\\Entity\\Oblige' 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 = ?
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 = 'T28b' LIMIT 1;

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.id IS NULL
LIMIT
  1

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.id IS NULL LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.createdAt AS createdAt_3,
  t0.slug AS slug_4,
  t0.consoneoInstallateurPrixFixSimulation AS consoneoInstallateurPrixFixSimulation_5,
  t0.consoneoInstallateurPrixFixOffre AS consoneoInstallateurPrixFixOffre_6,
  t0.allow_curseur AS allow_curseur_7,
  t0.consoneoInstallateurVariableTranche1 AS consoneoInstallateurVariableTranche1_8,
  t0.consoneoInstallateurValeurTranche1 AS consoneoInstallateurValeurTranche1_9,
  t0.consoneoInstallateurVariableTranche2 AS consoneoInstallateurVariableTranche2_10,
  t0.consoneoInstallateurValeurTranche2 AS consoneoInstallateurValeurTranche2_11,
  t0.consoneoInstallateurVariableTranche3 AS consoneoInstallateurVariableTranche3_12,
  t0.consoneoInstallateurValeurTranche3 AS consoneoInstallateurValeurTranche3_13,
  t0.consoneoInstallateurVariableTranche4 AS consoneoInstallateurVariableTranche4_14,
  t0.consoneoInstallateurValeurTranche4 AS consoneoInstallateurValeurTranche4_15,
  t0.consoneoInstallateurValeurTrancheMax AS consoneoInstallateurValeurTrancheMax_16,
  t0.logo AS logo_17,
  t0.modePrime AS modePrime_18,
  t0.incitation AS incitation_19,
  t0.`lead` AS lead_20,
  t0.actif AS actif_21,
  t0.partenariatContract AS partenariatContract_22,
  t0.allowElectronicSign AS allowElectronicSign_23,
  t0.canonicalModuleInstallateur_id AS canonicalModuleInstallateur_id_24,
  t0.canonicalModuleEntreprise_id AS canonicalModuleEntreprise_id_25,
  t0.canonicalModuleParticulier_id AS canonicalModuleParticulier_id_26,
  t0.oblige_id AS oblige_id_27,
  t0.obligeTargetConsoneoPrixFix_id AS obligeTargetConsoneoPrixFix_id_28,
  t0.obligeTargetConsoneoPrixVariable_id AS obligeTargetConsoneoPrixVariable_id_29
FROM
  TeteReseau t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.createdAt AS createdAt_3, t0.slug AS slug_4, t0.consoneoInstallateurPrixFixSimulation AS consoneoInstallateurPrixFixSimulation_5, t0.consoneoInstallateurPrixFixOffre AS consoneoInstallateurPrixFixOffre_6, t0.allow_curseur AS allow_curseur_7, t0.consoneoInstallateurVariableTranche1 AS consoneoInstallateurVariableTranche1_8, t0.consoneoInstallateurValeurTranche1 AS consoneoInstallateurValeurTranche1_9, t0.consoneoInstallateurVariableTranche2 AS consoneoInstallateurVariableTranche2_10, t0.consoneoInstallateurValeurTranche2 AS consoneoInstallateurValeurTranche2_11, t0.consoneoInstallateurVariableTranche3 AS consoneoInstallateurVariableTranche3_12, t0.consoneoInstallateurValeurTranche3 AS consoneoInstallateurValeurTranche3_13, t0.consoneoInstallateurVariableTranche4 AS consoneoInstallateurVariableTranche4_14, t0.consoneoInstallateurValeurTranche4 AS consoneoInstallateurValeurTranche4_15, t0.consoneoInstallateurValeurTrancheMax AS consoneoInstallateurValeurTrancheMax_16, t0.logo AS logo_17, t0.modePrime AS modePrime_18, t0.incitation AS incitation_19, t0.`lead` AS lead_20, t0.actif AS actif_21, t0.partenariatContract AS partenariatContract_22, t0.allowElectronicSign AS allowElectronicSign_23, t0.canonicalModuleInstallateur_id AS canonicalModuleInstallateur_id_24, t0.canonicalModuleEntreprise_id AS canonicalModuleEntreprise_id_25, t0.canonicalModuleParticulier_id AS canonicalModuleParticulier_id_26, t0.oblige_id AS oblige_id_27, t0.obligeTargetConsoneoPrixFix_id AS obligeTargetConsoneoPrixFix_id_28, t0.obligeTargetConsoneoPrixVariable_id AS obligeTargetConsoneoPrixVariable_id_29 FROM TeteReseau t0 WHERE t0.id = 28;

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.slug = ?
LIMIT
  1

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.slug = 'appartement' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.disabled AS disabled_1,
  c0_.threshold AS threshold_2,
  c0_.current AS current_3,
  c0_.expirationDate AS expirationDate_4,
  c0_.beginningDate AS beginningDate_5,
  c0_.messageAdmin AS messageAdmin_6,
  c0_.messageInstallateur AS messageInstallateur_7,
  c0_.messageBeneficiaire AS messageBeneficiaire_8,
  c0_.unit AS unit_9,
  c0_.type AS type_10,
  c0_.oblige_id AS oblige_id_11,
  c0_.teteReseau_id AS teteReseau_id_12,
  c0_.mandataire_id AS mandataire_id_13,
  c0_.installateur_id AS installateur_id_14
FROM
  CappingRule c0_
WHERE
  c0_.disabled = ?
  AND c0_.teteReseau_id = ?
  AND DATE(?) > c0_.beginningDate

SELECT c0_.id AS id_0, c0_.disabled AS disabled_1, c0_.threshold AS threshold_2, c0_.current AS current_3, c0_.expirationDate AS expirationDate_4, c0_.beginningDate AS beginningDate_5, c0_.messageAdmin AS messageAdmin_6, c0_.messageInstallateur AS messageInstallateur_7, c0_.messageBeneficiaire AS messageBeneficiaire_8, c0_.unit AS unit_9, c0_.type AS type_10, c0_.oblige_id AS oblige_id_11, c0_.teteReseau_id AS teteReseau_id_12, c0_.mandataire_id AS mandataire_id_13, c0_.installateur_id AS installateur_id_14 FROM CappingRule c0_ WHERE c0_.disabled = 0 AND c0_.teteReseau_id = 28 AND DATE('2025-12-26 02:47:23') > c0_.beginningDate;

SELECT
  t0.branding AS branding_1,
  t0.title AS title_2
FROM
  Branding t0
WHERE
  t0.branding = ?
LIMIT
  1

SELECT t0.branding AS branding_1, t0.title AS title_2 FROM Branding t0 WHERE t0.branding = 'i' LIMIT 1;