Symfony Profiler

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

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.obligeRole_id AS obligeRole_id_3,
  t4.id AS id_5,
  t4.role AS role_6,
  t4.title AS title_7,
  t4.scope AS scope_8,
  t4.position AS position_9,
  t4.definition AS definition_10,
  t4.cycle AS cycle_11,
  t4.only_consoneo_update AS only_consoneo_update_12,
  t0.teteReseau_id AS teteReseau_id_13
FROM
  RegleRole t0
  LEFT JOIN ObligeRole t4 ON t0.obligeRole_id = t4.id
  INNER JOIN RegleRole_ObligeUser ON t0.id = RegleRole_ObligeUser.regleRoleId
WHERE
  RegleRole_ObligeUser.userId = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.obligeRole_id AS obligeRole_id_3, t4.id AS id_5, t4.role AS role_6, t4.title AS title_7, t4.scope AS scope_8, t4.position AS position_9, t4.definition AS definition_10, t4.cycle AS cycle_11, t4.only_consoneo_update AS only_consoneo_update_12, t0.teteReseau_id AS teteReseau_id_13 FROM RegleRole t0 LEFT JOIN ObligeRole t4 ON t0.obligeRole_id = t4.id INNER JOIN RegleRole_ObligeUser ON t0.id = RegleRole_ObligeUser.regleRoleId WHERE RegleRole_ObligeUser.userId = 1845;

SELECT
  t0.id AS id_1,
  t0.raison AS raison_2,
  t0.siret AS siret_3,
  t0.adresse AS adresse_4,
  t0.adresse_complement AS adresse_complement_5,
  t0.codepostal AS codepostal_6,
  t0.ville AS ville_7,
  t0.website AS website_8,
  t0.effectif AS effectif_9,
  t0.status AS status_10,
  t0.created_datetime AS created_datetime_11,
  t0.updated_datetime AS updated_datetime_12,
  t0.signature AS signature_13,
  t0.logo AS logo_14,
  t0.formation_installateur_doc AS formation_installateur_doc_15,
  t0.pres_marketing_installateur AS pres_marketing_installateur_16,
  t0.guide_utilisation_commerciaux AS guide_utilisation_commerciaux_17,
  t0.guidePerformanceEnergetiqueB2b AS guidePerformanceEnergetiqueB2b_18,
  t0.guidePerformanceEnergetiqueB2c AS guidePerformanceEnergetiqueB2c_19,
  t0.cgu AS cgu_20,
  t0.partenariatContract AS partenariatContract_21,
  t0.tel_beneficiaire_B2C AS tel_beneficiaire_B2C_22,
  t0.tel_beneficiaire_B2B AS tel_beneficiaire_B2B_23,
  t0.tel_installateur AS tel_installateur_24,
  t0.tel_support_intern AS tel_support_intern_25,
  t0.fax_beneficiaire AS fax_beneficiaire_26,
  t0.fax_installateur AS fax_installateur_27,
  t0.email_beneficiaire AS email_beneficiaire_28,
  t0.email_installateur AS email_installateur_29,
  t0.is_consoneo AS is_consoneo_30,
  t0.slug AS slug_31,
  t0.alias AS alias_32,
  t0.conventionElectronique AS conventionElectronique_33,
  t0.aftElectronique AS aftElectronique_34,
  t0.contratInstallateur AS contratInstallateur_35,
  t0.modeProBeneficiaireInscription AS modeProBeneficiaireInscription_36,
  t0.modeByPassSuperviseur AS modeByPassSuperviseur_37,
  t0.`lead` AS lead_38,
  t0.`leadUrl` AS leadUrl_39,
  t0.`leadLogin` AS leadLogin_40,
  t0.`leadPassword` AS leadPassword_41,
  t0.relanceConventionClientUn AS relanceConventionClientUn_42,
  t0.relanceConventionClientDeux AS relanceConventionClientDeux_43,
  t0.alertConventionClient AS alertConventionClient_44,
  t0.relanceConventionInstallateurUn AS relanceConventionInstallateurUn_45,
  t0.relanceConventionInstallateurDeux AS relanceConventionInstallateurDeux_46,
  t0.alertConventionInstallateur AS alertConventionInstallateur_47,
  t0.conventionFin AS conventionFin_48,
  t0.questionnaireAftRelanceUn AS questionnaireAftRelanceUn_49,
  t0.questionnaireAftRelanceDeux AS questionnaireAftRelanceDeux_50,
  t0.alertQuestionnaireAFT AS alertQuestionnaireAFT_51,
  t0.questionnaireAftFin AS questionnaireAftFin_52,
  t0.relanceAftFacture AS relanceAftFacture_53,
  t0.alertAftFacture AS alertAftFacture_54,
  t0.aftFactureFin AS aftFactureFin_55,
  t0.mentionCnil AS mentionCnil_56,
  t0.serviceType AS serviceType_57,
  t0.precariteMode AS precariteMode_58,
  t0.precariteModeProgram AS precariteModeProgram_59,
  t0.blocked AS blocked_60,
  t0.blockedSimulation AS blockedSimulation_61,
  t0.resiliation AS resiliation_62,
  t0.archivageAuto AS archivageAuto_63,
  t0.travauxPostDevis AS travauxPostDevis_64,
  t0.emailFacturationPro AS emailFacturationPro_65,
  t0.mandatoryInstallateurGenericContract AS mandatoryInstallateurGenericContract_66,
  t0.hiddenEmail AS hiddenEmail_67,
  t0.certificallCompanyId AS certificallCompanyId_68,
  t0.visibilityCommercials AS visibilityCommercials_69,
  t0.mandat AS mandat_70,
  t0.pricingMandatClassique AS pricingMandatClassique_71,
  t0.pricingMandatPreca AS pricingMandatPreca_72,
  t0.pricingPrimeMaximumMandatClassique AS pricingPrimeMaximumMandatClassique_73,
  t0.pricingPrimeMaximumMandatPreca AS pricingPrimeMaximumMandatPreca_74,
  t0.originauxAdresse AS originauxAdresse_75,
  t0.originauxAdresseComplement AS originauxAdresseComplement_76,
  t0.originauxCodepostal AS originauxCodepostal_77,
  t0.originauxVille AS originauxVille_78,
  t0.eligible AS eligible_79,
  t0.satisfactionSurvey AS satisfactionSurvey_80,
  t0.surveyConfiguration AS surveyConfiguration_81,
  t0.autoPayment AS autoPayment_82,
  t0.isAnnexeDechetQuestion AS isAnnexeDechetQuestion_83,
  t0.aiEnabled AS aiEnabled_84,
  t0.isSignatureAutoAhEnabled AS isSignatureAutoAhEnabled_85,
  t0.isSignatureAutoOtherDocumentsEnabled AS isSignatureAutoOtherDocumentsEnabled_86,
  t0.emailVersion AS emailVersion_87,
  t0.validateBackwards AS validateBackwards_88,
  t0.displayTelConsoneo AS displayTelConsoneo_89,
  t0.allowedUniverSign AS allowedUniverSign_90,
  t0.allowedApplicationFees AS allowedApplicationFees_91,
  t0.displayApplicationFees AS displayApplicationFees_92,
  t0.programAutoAllowed AS programAutoAllowed_93,
  t0.mpr AS mpr_94,
  t0.isRibActivated AS isRibActivated_95,
  t0.canonicalTeteReseau_id AS canonicalTeteReseau_id_96,
  t0.oblige_id AS oblige_id_97,
  t98.id AS id_99,
  t98.raison AS raison_100,
  t98.email AS email_101,
  t98.tel AS tel_102,
  t98.site_web AS site_web_103,
  t98.adresse AS adresse_104,
  t98.cp AS cp_105,
  t98.ville AS ville_106,
  t98.oblige_id AS oblige_id_107,
  t108.id AS id_109,
  t108.gender AS gender_110,
  t108.firstName AS firstName_111,
  t108.name AS name_112,
  t108.raison AS raison_113,
  t108.email AS email_114,
  t108.tel AS tel_115,
  t108.address AS address_116,
  t108.cp AS cp_117,
  t108.city AS city_118,
  t108.adminMandate AS adminMandate_119,
  t108.financialMandate AS financialMandate_120,
  t108.mixteMandate AS mixteMandate_121,
  t108.signature AS signature_122,
  t108.tutorial_admin AS tutorial_admin_123,
  t108.tutorial_mixte AS tutorial_mixte_124,
  t108.tutorial_financial AS tutorial_financial_125,
  t108.oblige_id AS oblige_id_126,
  t127.id AS id_128,
  t127.raison AS raison_129,
  t127.siret AS siret_130,
  t127.oblige_id AS oblige_id_131
FROM
  Oblige t0
  LEFT JOIN Mediateur t98 ON t98.oblige_id = t0.id
  LEFT JOIN MprConfig t108 ON t108.oblige_id = t0.id
  LEFT JOIN Mandataire t127 ON t127.oblige_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.raison AS raison_2, t0.siret AS siret_3, t0.adresse AS adresse_4, t0.adresse_complement AS adresse_complement_5, t0.codepostal AS codepostal_6, t0.ville AS ville_7, t0.website AS website_8, t0.effectif AS effectif_9, t0.status AS status_10, t0.created_datetime AS created_datetime_11, t0.updated_datetime AS updated_datetime_12, t0.signature AS signature_13, t0.logo AS logo_14, t0.formation_installateur_doc AS formation_installateur_doc_15, t0.pres_marketing_installateur AS pres_marketing_installateur_16, t0.guide_utilisation_commerciaux AS guide_utilisation_commerciaux_17, t0.guidePerformanceEnergetiqueB2b AS guidePerformanceEnergetiqueB2b_18, t0.guidePerformanceEnergetiqueB2c AS guidePerformanceEnergetiqueB2c_19, t0.cgu AS cgu_20, t0.partenariatContract AS partenariatContract_21, t0.tel_beneficiaire_B2C AS tel_beneficiaire_B2C_22, t0.tel_beneficiaire_B2B AS tel_beneficiaire_B2B_23, t0.tel_installateur AS tel_installateur_24, t0.tel_support_intern AS tel_support_intern_25, t0.fax_beneficiaire AS fax_beneficiaire_26, t0.fax_installateur AS fax_installateur_27, t0.email_beneficiaire AS email_beneficiaire_28, t0.email_installateur AS email_installateur_29, t0.is_consoneo AS is_consoneo_30, t0.slug AS slug_31, t0.alias AS alias_32, t0.conventionElectronique AS conventionElectronique_33, t0.aftElectronique AS aftElectronique_34, t0.contratInstallateur AS contratInstallateur_35, t0.modeProBeneficiaireInscription AS modeProBeneficiaireInscription_36, t0.modeByPassSuperviseur AS modeByPassSuperviseur_37, t0.`lead` AS lead_38, t0.`leadUrl` AS leadUrl_39, t0.`leadLogin` AS leadLogin_40, t0.`leadPassword` AS leadPassword_41, t0.relanceConventionClientUn AS relanceConventionClientUn_42, t0.relanceConventionClientDeux AS relanceConventionClientDeux_43, t0.alertConventionClient AS alertConventionClient_44, t0.relanceConventionInstallateurUn AS relanceConventionInstallateurUn_45, t0.relanceConventionInstallateurDeux AS relanceConventionInstallateurDeux_46, t0.alertConventionInstallateur AS alertConventionInstallateur_47, t0.conventionFin AS conventionFin_48, t0.questionnaireAftRelanceUn AS questionnaireAftRelanceUn_49, t0.questionnaireAftRelanceDeux AS questionnaireAftRelanceDeux_50, t0.alertQuestionnaireAFT AS alertQuestionnaireAFT_51, t0.questionnaireAftFin AS questionnaireAftFin_52, t0.relanceAftFacture AS relanceAftFacture_53, t0.alertAftFacture AS alertAftFacture_54, t0.aftFactureFin AS aftFactureFin_55, t0.mentionCnil AS mentionCnil_56, t0.serviceType AS serviceType_57, t0.precariteMode AS precariteMode_58, t0.precariteModeProgram AS precariteModeProgram_59, t0.blocked AS blocked_60, t0.blockedSimulation AS blockedSimulation_61, t0.resiliation AS resiliation_62, t0.archivageAuto AS archivageAuto_63, t0.travauxPostDevis AS travauxPostDevis_64, t0.emailFacturationPro AS emailFacturationPro_65, t0.mandatoryInstallateurGenericContract AS mandatoryInstallateurGenericContract_66, t0.hiddenEmail AS hiddenEmail_67, t0.certificallCompanyId AS certificallCompanyId_68, t0.visibilityCommercials AS visibilityCommercials_69, t0.mandat AS mandat_70, t0.pricingMandatClassique AS pricingMandatClassique_71, t0.pricingMandatPreca AS pricingMandatPreca_72, t0.pricingPrimeMaximumMandatClassique AS pricingPrimeMaximumMandatClassique_73, t0.pricingPrimeMaximumMandatPreca AS pricingPrimeMaximumMandatPreca_74, t0.originauxAdresse AS originauxAdresse_75, t0.originauxAdresseComplement AS originauxAdresseComplement_76, t0.originauxCodepostal AS originauxCodepostal_77, t0.originauxVille AS originauxVille_78, t0.eligible AS eligible_79, t0.satisfactionSurvey AS satisfactionSurvey_80, t0.surveyConfiguration AS surveyConfiguration_81, t0.autoPayment AS autoPayment_82, t0.isAnnexeDechetQuestion AS isAnnexeDechetQuestion_83, t0.aiEnabled AS aiEnabled_84, t0.isSignatureAutoAhEnabled AS isSignatureAutoAhEnabled_85, t0.isSignatureAutoOtherDocumentsEnabled AS isSignatureAutoOtherDocumentsEnabled_86, t0.emailVersion AS emailVersion_87, t0.validateBackwards AS validateBackwards_88, t0.displayTelConsoneo AS displayTelConsoneo_89, t0.allowedUniverSign AS allowedUniverSign_90, t0.allowedApplicationFees AS allowedApplicationFees_91, t0.displayApplicationFees AS displayApplicationFees_92, t0.programAutoAllowed AS programAutoAllowed_93, t0.mpr AS mpr_94, t0.isRibActivated AS isRibActivated_95, t0.canonicalTeteReseau_id AS canonicalTeteReseau_id_96, t0.oblige_id AS oblige_id_97, t98.id AS id_99, t98.raison AS raison_100, t98.email AS email_101, t98.tel AS tel_102, t98.site_web AS site_web_103, t98.adresse AS adresse_104, t98.cp AS cp_105, t98.ville AS ville_106, t98.oblige_id AS oblige_id_107, t108.id AS id_109, t108.gender AS gender_110, t108.firstName AS firstName_111, t108.name AS name_112, t108.raison AS raison_113, t108.email AS email_114, t108.tel AS tel_115, t108.address AS address_116, t108.cp AS cp_117, t108.city AS city_118, t108.adminMandate AS adminMandate_119, t108.financialMandate AS financialMandate_120, t108.mixteMandate AS mixteMandate_121, t108.signature AS signature_122, t108.tutorial_admin AS tutorial_admin_123, t108.tutorial_mixte AS tutorial_mixte_124, t108.tutorial_financial AS tutorial_financial_125, t108.oblige_id AS oblige_id_126, t127.id AS id_128, t127.raison AS raison_129, t127.siret AS siret_130, t127.oblige_id AS oblige_id_131 FROM Oblige t0 LEFT JOIN Mediateur t98 ON t98.oblige_id = t0.id LEFT JOIN MprConfig t108 ON t108.oblige_id = t0.id LEFT JOIN Mandataire t127 ON t127.oblige_id = t0.id WHERE t0.id = 2;

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_.mprFeesFixed AS mprFeesFixed_10,
  c0_.mprFeesPercent AS mprFeesPercent_11,
  c0_.type AS type_12,
  c0_.oblige_id AS oblige_id_13,
  c0_.teteReseau_id AS teteReseau_id_14,
  c0_.mandataire_id AS mandataire_id_15,
  c0_.installateur_id AS installateur_id_16
FROM
  CappingRule c0_
WHERE
  c0_.oblige_id = ?
  AND c0_.disabled = ?
  AND (
    c0_.current >= c0_.threshold
    OR DATE(?) > DATE(c0_.expirationDate)
  )

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_.mprFeesFixed AS mprFeesFixed_10, c0_.mprFeesPercent AS mprFeesPercent_11, c0_.type AS type_12, c0_.oblige_id AS oblige_id_13, c0_.teteReseau_id AS teteReseau_id_14, c0_.mandataire_id AS mandataire_id_15, c0_.installateur_id AS installateur_id_16 FROM CappingRule c0_ WHERE c0_.oblige_id = 2 AND c0_.disabled = 0 AND (c0_.current >= c0_.threshold OR DATE('2026-10-09 17:28:51') > DATE(c0_.expirationDate));

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_.mprFeesFixed AS mprFeesFixed_10,
  c0_.mprFeesPercent AS mprFeesPercent_11,
  c0_.type AS type_12,
  c0_.oblige_id AS oblige_id_13,
  c0_.teteReseau_id AS teteReseau_id_14,
  c0_.mandataire_id AS mandataire_id_15,
  c0_.installateur_id AS installateur_id_16
FROM
  CappingRule c0_
  INNER JOIN CappingRuleHistory c1_ ON c0_.id = c1_.cappingRule_id
WHERE
  c0_.oblige_id = ?
  AND c1_.type = ?

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_.mprFeesFixed AS mprFeesFixed_10, c0_.mprFeesPercent AS mprFeesPercent_11, c0_.type AS type_12, c0_.oblige_id AS oblige_id_13, c0_.teteReseau_id AS teteReseau_id_14, c0_.mandataire_id AS mandataire_id_15, c0_.installateur_id AS installateur_id_16 FROM CappingRule c0_ INNER JOIN CappingRuleHistory c1_ ON c0_.id = c1_.cappingRule_id WHERE c0_.oblige_id = 2 AND c1_.type = 'alert_dismissed';

SELECT
  r0_.id AS id_0,
  r0_.link AS link_1,
  r0_.creation_date AS creation_date_2,
  r0_.content AS content_3
FROM
  Reminder r0_
WHERE
  r0_.obligeUser_id = ?
ORDER BY
  r0_.creation_date DESC

SELECT r0_.id AS id_0, r0_.link AS link_1, r0_.creation_date AS creation_date_2, r0_.content AS content_3 FROM Reminder r0_ WHERE r0_.obligeUser_id = 1845 ORDER BY r0_.creation_date DESC;

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` = 'enable_project_bundle' AND t0.object_id = 2 AND t0.object_class = 'Consoneo\\Bundle\\UserBundle\\Entity\\Oblige' LIMIT 1;

SELECT
  COUNT(DISTINCT e0_.id) AS sclr_0
FROM
  EntrepriseUser e0_
  INNER JOIN Entreprise e1_ ON e0_.company_id = e1_.id
  INNER JOIN IntegrationModule i2_ ON e0_.integrationModule_id = i2_.id
  INNER JOIN TeteReseau t3_ ON i2_.teteReseau_id = t3_.id
  INNER JOIN Oblige o4_ ON t3_.oblige_id = o4_.id
  INNER JOIN AffectationUser a5_ ON e0_.id = a5_.entrepriseUser_id
  INNER JOIN ObligeRole o6_ ON a5_.obligeRole_id = o6_.id
  INNER JOIN ObligeUser o7_ ON a5_.obligeUser_id = o7_.id
  INNER JOIN Workflow w8_ ON e0_.workflow_id = w8_.mode
WHERE
  o6_.role IN (
    'ROLE_USER', 'ROLE_SUPERVISEUR_GENERAL'
  )
  AND e0_.activation = ?
  AND t3_.oblige_id = ?
  AND DATE_SUB(?, INTERVAL 5 MINUTE) >= e0_.createdAt
ORDER BY
  e0_.id DESC

SELECT COUNT(DISTINCT e0_.id) AS sclr_0 FROM EntrepriseUser e0_ INNER JOIN Entreprise e1_ ON e0_.company_id = e1_.id INNER JOIN IntegrationModule i2_ ON e0_.integrationModule_id = i2_.id INNER JOIN TeteReseau t3_ ON i2_.teteReseau_id = t3_.id INNER JOIN Oblige o4_ ON t3_.oblige_id = o4_.id INNER JOIN AffectationUser a5_ ON e0_.id = a5_.entrepriseUser_id INNER JOIN ObligeRole o6_ ON a5_.obligeRole_id = o6_.id INNER JOIN ObligeUser o7_ ON a5_.obligeUser_id = o7_.id INNER JOIN Workflow w8_ ON e0_.workflow_id = w8_.mode WHERE o6_.role IN ('ROLE_USER', 'ROLE_SUPERVISEUR_GENERAL') AND e0_.activation = 'pending' AND t3_.oblige_id = 2 AND DATE_SUB('2026-10-09 17:28:51', INTERVAL 5 MINUTE) >= e0_.createdAt ORDER BY e0_.id DESC;

SELECT
  COUNT(DISTINCT p0_.id) AS sclr_0
FROM
  ParticulierUser p0_
  INNER JOIN IntegrationModule i1_ ON p0_.integrationModule_id = i1_.id
  INNER JOIN TeteReseau t2_ ON i1_.teteReseau_id = t2_.id
  INNER JOIN Oblige o3_ ON t2_.oblige_id = o3_.id
  INNER JOIN AffectationUser a4_ ON p0_.id = a4_.particulierUser_id
  INNER JOIN ObligeRole o5_ ON a4_.obligeRole_id = o5_.id
  INNER JOIN ObligeUser o6_ ON a4_.obligeUser_id = o6_.id
  INNER JOIN Workflow w7_ ON p0_.workflow_id = w7_.mode
WHERE
  o5_.role IN (
    'ROLE_USER', 'ROLE_SUPERVISEUR_GENERAL'
  )
  AND p0_.activation = ?
  AND t2_.oblige_id = ?
  AND DATE_SUB(?, INTERVAL 5 MINUTE) >= p0_.createdAt
  AND (
    p0_.optin = ?
    OR p0_.emailRequested = ?
  )
ORDER BY
  p0_.id DESC

SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM ParticulierUser p0_ INNER JOIN IntegrationModule i1_ ON p0_.integrationModule_id = i1_.id INNER JOIN TeteReseau t2_ ON i1_.teteReseau_id = t2_.id INNER JOIN Oblige o3_ ON t2_.oblige_id = o3_.id INNER JOIN AffectationUser a4_ ON p0_.id = a4_.particulierUser_id INNER JOIN ObligeRole o5_ ON a4_.obligeRole_id = o5_.id INNER JOIN ObligeUser o6_ ON a4_.obligeUser_id = o6_.id INNER JOIN Workflow w7_ ON p0_.workflow_id = w7_.mode WHERE o5_.role IN ('ROLE_USER', 'ROLE_SUPERVISEUR_GENERAL') AND p0_.activation = 'pending' AND t2_.oblige_id = 2 AND DATE_SUB('2026-10-09 17:28:51', INTERVAL 5 MINUTE) >= p0_.createdAt AND (p0_.optin = 1 OR p0_.emailRequested = 0) ORDER BY p0_.id DESC;

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
  INNER JOIN obligeuser_tetereseau ON t0.id = obligeuser_tetereseau.tetereseauId
WHERE
  obligeuser_tetereseau.obligeuserId = ?

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 INNER JOIN obligeuser_tetereseau ON t0.id = obligeuser_tetereseau.tetereseauId WHERE obligeuser_tetereseau.obligeuserId = 1845;

SELECT
  COUNT(DISTINCT o0_.id) AS sclr_0
FROM
  OffreProjet o0_
  INNER JOIN Oblige o1_ ON o0_.oblige_id = o1_.id
  INNER JOIN AffectationOffre a2_ ON o0_.id = a2_.offreProjet_id
  INNER JOIN OffreProjetDocumentObligatoire o3_ ON o0_.id = o3_.offreProjet_id
  INNER JOIN Projet p4_ ON o0_.projet_id = p4_.id
  INNER JOIN ObligeRole o5_ ON a2_.obligeRole_id = o5_.id
  INNER JOIN ObligeUser o6_ ON a2_.obligeUser_id = o6_.id
  INNER JOIN ProjectOwner p7_ ON o0_.projectOwner_id = p7_.id
  INNER JOIN IntegrationModule i8_ ON p7_.integrationModule_id = i8_.id
  INNER JOIN TeteReseau t9_ ON i8_.teteReseau_id = t9_.id
  INNER JOIN Oblige o10_ ON t9_.oblige_id = o10_.id
WHERE
  o0_.etat = ?
  AND o0_.pricingType = ?
  AND a2_.obligeUser_id = ?
  AND o0_.project_bundle_id IS NULL
  AND p7_.activation = ?
  AND t9_.nom IN ('Consoneo')
  AND o10_.is_consoneo = ?

SELECT COUNT(DISTINCT o0_.id) AS sclr_0 FROM OffreProjet o0_ INNER JOIN Oblige o1_ ON o0_.oblige_id = o1_.id INNER JOIN AffectationOffre a2_ ON o0_.id = a2_.offreProjet_id INNER JOIN OffreProjetDocumentObligatoire o3_ ON o0_.id = o3_.offreProjet_id INNER JOIN Projet p4_ ON o0_.projet_id = p4_.id INNER JOIN ObligeRole o5_ ON a2_.obligeRole_id = o5_.id INNER JOIN ObligeUser o6_ ON a2_.obligeUser_id = o6_.id INNER JOIN ProjectOwner p7_ ON o0_.projectOwner_id = p7_.id INNER JOIN IntegrationModule i8_ ON p7_.integrationModule_id = i8_.id INNER JOIN TeteReseau t9_ ON i8_.teteReseau_id = t9_.id INNER JOIN Oblige o10_ ON t9_.oblige_id = o10_.id WHERE o0_.etat = 'demande_convention' AND o0_.pricingType = 'osm' AND a2_.obligeUser_id = 1845 AND o0_.project_bundle_id IS NULL AND p7_.activation = 'fully' AND t9_.nom IN ('Consoneo') AND o10_.is_consoneo = 1;

SELECT
  COUNT(DISTINCT o0_.project_bundle_id) AS sclr_0
FROM
  OffreProjet o0_
  INNER JOIN Oblige o1_ ON o0_.oblige_id = o1_.id
  INNER JOIN AffectationOffre a2_ ON o0_.id = a2_.offreProjet_id
  INNER JOIN OffreProjetDocumentObligatoire o3_ ON o0_.id = o3_.offreProjet_id
  INNER JOIN Projet p4_ ON o0_.projet_id = p4_.id
  INNER JOIN ObligeRole o5_ ON a2_.obligeRole_id = o5_.id
  INNER JOIN ObligeUser o6_ ON a2_.obligeUser_id = o6_.id
  INNER JOIN ProjectOwner p7_ ON o0_.projectOwner_id = p7_.id
  INNER JOIN IntegrationModule i8_ ON p7_.integrationModule_id = i8_.id
  INNER JOIN TeteReseau t9_ ON i8_.teteReseau_id = t9_.id
  INNER JOIN Oblige o10_ ON t9_.oblige_id = o10_.id
WHERE
  o0_.etat = ?
  AND o0_.pricingType = ?
  AND a2_.obligeUser_id = ?
  AND p7_.activation = ?
  AND t9_.nom IN ('Consoneo')
  AND o10_.is_consoneo = ?
  AND o0_.project_bundle_id IS NOT NULL

SELECT COUNT(DISTINCT o0_.project_bundle_id) AS sclr_0 FROM OffreProjet o0_ INNER JOIN Oblige o1_ ON o0_.oblige_id = o1_.id INNER JOIN AffectationOffre a2_ ON o0_.id = a2_.offreProjet_id INNER JOIN OffreProjetDocumentObligatoire o3_ ON o0_.id = o3_.offreProjet_id INNER JOIN Projet p4_ ON o0_.projet_id = p4_.id INNER JOIN ObligeRole o5_ ON a2_.obligeRole_id = o5_.id INNER JOIN ObligeUser o6_ ON a2_.obligeUser_id = o6_.id INNER JOIN ProjectOwner p7_ ON o0_.projectOwner_id = p7_.id INNER JOIN IntegrationModule i8_ ON p7_.integrationModule_id = i8_.id INNER JOIN TeteReseau t9_ ON i8_.teteReseau_id = t9_.id INNER JOIN Oblige o10_ ON t9_.oblige_id = o10_.id WHERE o0_.etat = 'demande_convention' AND o0_.pricingType = 'osm' AND a2_.obligeUser_id = 1845 AND p7_.activation = 'fully' AND t9_.nom IN ('Consoneo') AND o10_.is_consoneo = 1 AND o0_.project_bundle_id IS NOT NULL;