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.email_canonical AS email_canonical_28,
  t0.username_canonical AS username_canonical_29,
  t0.oblige_id AS oblige_id_30
FROM
  ObligeUser t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.enabled AS enabled_3, t0.salt AS salt_4, t0.password AS password_5, t0.last_login AS last_login_6, t0.confirmation_token AS confirmation_token_7, t0.password_requested_at AS password_requested_at_8, t0.roles AS roles_9, t0.username AS username_10, t0.nom AS nom_11, t0.prenom AS prenom_12, t0.fonction AS fonction_13, t0.tel AS tel_14, t0.mobile AS mobile_15, t0.activation AS activation_16, t0.createdAt AS createdAt_17, t0.updatedAt AS updatedAt_18, t0.optin AS optin_19, t0.dateActivation AS dateActivation_20, t0.emailValidatedDateTime AS emailValidatedDateTime_21, t0.emailCreatedDateTime AS emailCreatedDateTime_22, t0.mobileCreatedDatetime AS mobileCreatedDatetime_23, t0.sendEmail AS sendEmail_24, t0.scope AS scope_25, t0.isArchived AS isArchived_26, t0.import AS import_27, t0.email_canonical AS email_canonical_28, t0.username_canonical AS username_canonical_29, t0.oblige_id AS oblige_id_30 FROM ObligeUser t0 WHERE t0.id = 2;

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 = 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_.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_.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_.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_.oblige_id = 2 AND c0_.disabled = 0 AND (c0_.current >= c0_.threshold OR DATE('2026-06-17 17:41:32') > 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_.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_
  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_.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_ INNER JOIN CappingRuleHistory c1_ ON c0_.id = c1_.cappingRule_id WHERE c0_.oblige_id = 2 AND c1_.type = 'alert_dismissed';

SELECT
  t0.id AS id_1,
  t0.raison AS raison_2,
  t0.siret AS siret_3,
  t0.adresse AS adresse_4,
  t0.adresse_complement AS adresse_complement_5,
  t0.codepostal AS codepostal_6,
  t0.ville AS ville_7,
  t0.website AS website_8,
  t0.effectif AS effectif_9,
  t0.status AS status_10,
  t0.created_datetime AS created_datetime_11,
  t0.updated_datetime AS updated_datetime_12,
  t0.signature AS signature_13,
  t0.logo AS logo_14,
  t0.formation_installateur_doc AS formation_installateur_doc_15,
  t0.pres_marketing_installateur AS pres_marketing_installateur_16,
  t0.guide_utilisation_commerciaux AS guide_utilisation_commerciaux_17,
  t0.guidePerformanceEnergetiqueB2b AS guidePerformanceEnergetiqueB2b_18,
  t0.guidePerformanceEnergetiqueB2c AS guidePerformanceEnergetiqueB2c_19,
  t0.cgu AS cgu_20,
  t0.partenariatContract AS partenariatContract_21,
  t0.tel_beneficiaire_B2C AS tel_beneficiaire_B2C_22,
  t0.tel_beneficiaire_B2B AS tel_beneficiaire_B2B_23,
  t0.tel_installateur AS tel_installateur_24,
  t0.tel_support_intern AS tel_support_intern_25,
  t0.fax_beneficiaire AS fax_beneficiaire_26,
  t0.fax_installateur AS fax_installateur_27,
  t0.email_beneficiaire AS email_beneficiaire_28,
  t0.email_installateur AS email_installateur_29,
  t0.is_consoneo AS is_consoneo_30,
  t0.slug AS slug_31,
  t0.conventionElectronique AS conventionElectronique_32,
  t0.aftElectronique AS aftElectronique_33,
  t0.contratInstallateur AS contratInstallateur_34,
  t0.modeProBeneficiaireInscription AS modeProBeneficiaireInscription_35,
  t0.modeByPassSuperviseur AS modeByPassSuperviseur_36,
  t0.`lead` AS lead_37,
  t0.`leadUrl` AS leadUrl_38,
  t0.`leadLogin` AS leadLogin_39,
  t0.`leadPassword` AS leadPassword_40,
  t0.relanceConventionClientUn AS relanceConventionClientUn_41,
  t0.relanceConventionClientDeux AS relanceConventionClientDeux_42,
  t0.alertConventionClient AS alertConventionClient_43,
  t0.relanceConventionInstallateurUn AS relanceConventionInstallateurUn_44,
  t0.relanceConventionInstallateurDeux AS relanceConventionInstallateurDeux_45,
  t0.alertConventionInstallateur AS alertConventionInstallateur_46,
  t0.conventionFin AS conventionFin_47,
  t0.questionnaireAftRelanceUn AS questionnaireAftRelanceUn_48,
  t0.questionnaireAftRelanceDeux AS questionnaireAftRelanceDeux_49,
  t0.alertQuestionnaireAFT AS alertQuestionnaireAFT_50,
  t0.questionnaireAftFin AS questionnaireAftFin_51,
  t0.relanceAftFacture AS relanceAftFacture_52,
  t0.alertAftFacture AS alertAftFacture_53,
  t0.aftFactureFin AS aftFactureFin_54,
  t0.mentionCnil AS mentionCnil_55,
  t0.serviceType AS serviceType_56,
  t0.precariteMode AS precariteMode_57,
  t0.precariteModeProgram AS precariteModeProgram_58,
  t0.blocked AS blocked_59,
  t0.blockedSimulation AS blockedSimulation_60,
  t0.resiliation AS resiliation_61,
  t0.archivageAuto AS archivageAuto_62,
  t0.travauxPostDevis AS travauxPostDevis_63,
  t0.emailFacturationPro AS emailFacturationPro_64,
  t0.mandatoryInstallateurGenericContract AS mandatoryInstallateurGenericContract_65,
  t0.hiddenEmail AS hiddenEmail_66,
  t0.certificallCompanyId AS certificallCompanyId_67,
  t0.visibilityCommercials AS visibilityCommercials_68,
  t0.mandat AS mandat_69,
  t0.pricingMandatClassique AS pricingMandatClassique_70,
  t0.pricingMandatPreca AS pricingMandatPreca_71,
  t0.pricingPrimeMaximumMandatClassique AS pricingPrimeMaximumMandatClassique_72,
  t0.pricingPrimeMaximumMandatPreca AS pricingPrimeMaximumMandatPreca_73,
  t0.originauxAdresse AS originauxAdresse_74,
  t0.originauxAdresseComplement AS originauxAdresseComplement_75,
  t0.originauxCodepostal AS originauxCodepostal_76,
  t0.originauxVille AS originauxVille_77,
  t0.eligible AS eligible_78,
  t0.satisfactionSurvey AS satisfactionSurvey_79,
  t0.surveyConfiguration AS surveyConfiguration_80,
  t0.autoPayment AS autoPayment_81,
  t0.isAnnexeDechetQuestion AS isAnnexeDechetQuestion_82,
  t0.aiEnabled AS aiEnabled_83,
  t0.isSignatureAutoAhEnabled AS isSignatureAutoAhEnabled_84,
  t0.isSignatureAutoOtherDocumentsEnabled AS isSignatureAutoOtherDocumentsEnabled_85,
  t0.emailVersion AS emailVersion_86,
  t0.validateBackwards AS validateBackwards_87,
  t0.displayTelConsoneo AS displayTelConsoneo_88,
  t0.allowedUniverSign AS allowedUniverSign_89,
  t0.allowedApplicationFees AS allowedApplicationFees_90,
  t0.displayApplicationFees AS displayApplicationFees_91,
  t0.programAutoAllowed AS programAutoAllowed_92,
  t0.mpr AS mpr_93,
  t0.isRibActivated AS isRibActivated_94,
  t0.canonicalTeteReseau_id AS canonicalTeteReseau_id_95,
  t0.oblige_id AS oblige_id_96,
  t97.id AS id_98,
  t97.raison AS raison_99,
  t97.email AS email_100,
  t97.tel AS tel_101,
  t97.site_web AS site_web_102,
  t97.adresse AS adresse_103,
  t97.cp AS cp_104,
  t97.ville AS ville_105,
  t97.oblige_id AS oblige_id_106,
  t107.id AS id_108,
  t107.gender AS gender_109,
  t107.firstName AS firstName_110,
  t107.name AS name_111,
  t107.raison AS raison_112,
  t107.email AS email_113,
  t107.tel AS tel_114,
  t107.address AS address_115,
  t107.cp AS cp_116,
  t107.city AS city_117,
  t107.adminMandate AS adminMandate_118,
  t107.financialMandate AS financialMandate_119,
  t107.mixteMandate AS mixteMandate_120,
  t107.signature AS signature_121,
  t107.tutorial_admin AS tutorial_admin_122,
  t107.tutorial_mixte AS tutorial_mixte_123,
  t107.tutorial_financial AS tutorial_financial_124,
  t107.oblige_id AS oblige_id_125,
  t126.id AS id_127,
  t126.raison AS raison_128,
  t126.siret AS siret_129,
  t126.oblige_id AS oblige_id_130
FROM
  Oblige t0
  LEFT JOIN Mediateur t97 ON t97.oblige_id = t0.id
  LEFT JOIN MprConfig t107 ON t107.oblige_id = t0.id
  LEFT JOIN Mandataire t126 ON t126.oblige_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.raison AS raison_2, t0.siret AS siret_3, t0.adresse AS adresse_4, t0.adresse_complement AS adresse_complement_5, t0.codepostal AS codepostal_6, t0.ville AS ville_7, t0.website AS website_8, t0.effectif AS effectif_9, t0.status AS status_10, t0.created_datetime AS created_datetime_11, t0.updated_datetime AS updated_datetime_12, t0.signature AS signature_13, t0.logo AS logo_14, t0.formation_installateur_doc AS formation_installateur_doc_15, t0.pres_marketing_installateur AS pres_marketing_installateur_16, t0.guide_utilisation_commerciaux AS guide_utilisation_commerciaux_17, t0.guidePerformanceEnergetiqueB2b AS guidePerformanceEnergetiqueB2b_18, t0.guidePerformanceEnergetiqueB2c AS guidePerformanceEnergetiqueB2c_19, t0.cgu AS cgu_20, t0.partenariatContract AS partenariatContract_21, t0.tel_beneficiaire_B2C AS tel_beneficiaire_B2C_22, t0.tel_beneficiaire_B2B AS tel_beneficiaire_B2B_23, t0.tel_installateur AS tel_installateur_24, t0.tel_support_intern AS tel_support_intern_25, t0.fax_beneficiaire AS fax_beneficiaire_26, t0.fax_installateur AS fax_installateur_27, t0.email_beneficiaire AS email_beneficiaire_28, t0.email_installateur AS email_installateur_29, t0.is_consoneo AS is_consoneo_30, t0.slug AS slug_31, t0.conventionElectronique AS conventionElectronique_32, t0.aftElectronique AS aftElectronique_33, t0.contratInstallateur AS contratInstallateur_34, t0.modeProBeneficiaireInscription AS modeProBeneficiaireInscription_35, t0.modeByPassSuperviseur AS modeByPassSuperviseur_36, t0.`lead` AS lead_37, t0.`leadUrl` AS leadUrl_38, t0.`leadLogin` AS leadLogin_39, t0.`leadPassword` AS leadPassword_40, t0.relanceConventionClientUn AS relanceConventionClientUn_41, t0.relanceConventionClientDeux AS relanceConventionClientDeux_42, t0.alertConventionClient AS alertConventionClient_43, t0.relanceConventionInstallateurUn AS relanceConventionInstallateurUn_44, t0.relanceConventionInstallateurDeux AS relanceConventionInstallateurDeux_45, t0.alertConventionInstallateur AS alertConventionInstallateur_46, t0.conventionFin AS conventionFin_47, t0.questionnaireAftRelanceUn AS questionnaireAftRelanceUn_48, t0.questionnaireAftRelanceDeux AS questionnaireAftRelanceDeux_49, t0.alertQuestionnaireAFT AS alertQuestionnaireAFT_50, t0.questionnaireAftFin AS questionnaireAftFin_51, t0.relanceAftFacture AS relanceAftFacture_52, t0.alertAftFacture AS alertAftFacture_53, t0.aftFactureFin AS aftFactureFin_54, t0.mentionCnil AS mentionCnil_55, t0.serviceType AS serviceType_56, t0.precariteMode AS precariteMode_57, t0.precariteModeProgram AS precariteModeProgram_58, t0.blocked AS blocked_59, t0.blockedSimulation AS blockedSimulation_60, t0.resiliation AS resiliation_61, t0.archivageAuto AS archivageAuto_62, t0.travauxPostDevis AS travauxPostDevis_63, t0.emailFacturationPro AS emailFacturationPro_64, t0.mandatoryInstallateurGenericContract AS mandatoryInstallateurGenericContract_65, t0.hiddenEmail AS hiddenEmail_66, t0.certificallCompanyId AS certificallCompanyId_67, t0.visibilityCommercials AS visibilityCommercials_68, t0.mandat AS mandat_69, t0.pricingMandatClassique AS pricingMandatClassique_70, t0.pricingMandatPreca AS pricingMandatPreca_71, t0.pricingPrimeMaximumMandatClassique AS pricingPrimeMaximumMandatClassique_72, t0.pricingPrimeMaximumMandatPreca AS pricingPrimeMaximumMandatPreca_73, t0.originauxAdresse AS originauxAdresse_74, t0.originauxAdresseComplement AS originauxAdresseComplement_75, t0.originauxCodepostal AS originauxCodepostal_76, t0.originauxVille AS originauxVille_77, t0.eligible AS eligible_78, t0.satisfactionSurvey AS satisfactionSurvey_79, t0.surveyConfiguration AS surveyConfiguration_80, t0.autoPayment AS autoPayment_81, t0.isAnnexeDechetQuestion AS isAnnexeDechetQuestion_82, t0.aiEnabled AS aiEnabled_83, t0.isSignatureAutoAhEnabled AS isSignatureAutoAhEnabled_84, t0.isSignatureAutoOtherDocumentsEnabled AS isSignatureAutoOtherDocumentsEnabled_85, t0.emailVersion AS emailVersion_86, t0.validateBackwards AS validateBackwards_87, t0.displayTelConsoneo AS displayTelConsoneo_88, t0.allowedUniverSign AS allowedUniverSign_89, t0.allowedApplicationFees AS allowedApplicationFees_90, t0.displayApplicationFees AS displayApplicationFees_91, t0.programAutoAllowed AS programAutoAllowed_92, t0.mpr AS mpr_93, t0.isRibActivated AS isRibActivated_94, t0.canonicalTeteReseau_id AS canonicalTeteReseau_id_95, t0.oblige_id AS oblige_id_96, t97.id AS id_98, t97.raison AS raison_99, t97.email AS email_100, t97.tel AS tel_101, t97.site_web AS site_web_102, t97.adresse AS adresse_103, t97.cp AS cp_104, t97.ville AS ville_105, t97.oblige_id AS oblige_id_106, t107.id AS id_108, t107.gender AS gender_109, t107.firstName AS firstName_110, t107.name AS name_111, t107.raison AS raison_112, t107.email AS email_113, t107.tel AS tel_114, t107.address AS address_115, t107.cp AS cp_116, t107.city AS city_117, t107.adminMandate AS adminMandate_118, t107.financialMandate AS financialMandate_119, t107.mixteMandate AS mixteMandate_120, t107.signature AS signature_121, t107.tutorial_admin AS tutorial_admin_122, t107.tutorial_mixte AS tutorial_mixte_123, t107.tutorial_financial AS tutorial_financial_124, t107.oblige_id AS oblige_id_125, t126.id AS id_127, t126.raison AS raison_128, t126.siret AS siret_129, t126.oblige_id AS oblige_id_130 FROM Oblige t0 LEFT JOIN Mediateur t97 ON t97.oblige_id = t0.id LEFT JOIN MprConfig t107 ON t107.oblige_id = t0.id LEFT JOIN Mandataire t126 ON t126.oblige_id = t0.id WHERE t0.id = 2;

SELECT
  p0_.id AS id_0,
  p0_.mprUuid AS mprUuid_1,
  p0_.mprReference AS mprReference_2,
  p0_.paymentDate AS paymentDate_3,
  p0_.invoiceReference AS invoiceReference_4,
  p0_.invoiceDate AS invoiceDate_5,
  p0_.amount AS amount_6,
  p0_.archive AS archive_7,
  p0_.step AS step_8,
  p0_.offreProjet_id AS offreProjet_id_9,
  p0_.batchBankTransfer_id AS batchBankTransfer_id_10,
  p0_.installateur_id AS installateur_id_11,
  p0_.particulierUser_id AS particulierUser_id_12
FROM
  PaymentMpr p0_
  INNER JOIN Installateur i1_ ON p0_.installateur_id = i1_.id
  INNER JOIN PaymentMethod p2_ ON i1_.id = p2_.installateur_id
  INNER JOIN PaymentMethodOblige p3_ ON p2_.id = p3_.paymentMethod_id
WHERE
  p3_.oblige_id = ?
  AND p3_.valid IS NULL
  AND p0_.step = ?

SELECT p0_.id AS id_0, p0_.mprUuid AS mprUuid_1, p0_.mprReference AS mprReference_2, p0_.paymentDate AS paymentDate_3, p0_.invoiceReference AS invoiceReference_4, p0_.invoiceDate AS invoiceDate_5, p0_.amount AS amount_6, p0_.archive AS archive_7, p0_.step AS step_8, p0_.offreProjet_id AS offreProjet_id_9, p0_.batchBankTransfer_id AS batchBankTransfer_id_10, p0_.installateur_id AS installateur_id_11, p0_.particulierUser_id AS particulierUser_id_12 FROM PaymentMpr p0_ INNER JOIN Installateur i1_ ON p0_.installateur_id = i1_.id INNER JOIN PaymentMethod p2_ ON i1_.id = p2_.installateur_id INNER JOIN PaymentMethodOblige p3_ ON p2_.id = p3_.paymentMethod_id WHERE p3_.oblige_id = 2 AND p3_.valid IS NULL AND p0_.step = 'ready_to_pay';

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 = ?

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

SELECT
  COUNT(DISTINCT p0_.id) AS sclr_0
FROM
  PaymentMethodOblige p0_
  LEFT JOIN PaymentMethod p1_ ON p0_.paymentMethod_id = p1_.id
  LEFT JOIN Installateur i2_ ON p1_.installateur_id = i2_.id
  LEFT JOIN EntrepriseUser e3_ ON p1_.entrepriseUser_id = e3_.id
  LEFT JOIN ParticulierUser p4_ ON p1_.particulierUser_id = p4_.id
  LEFT JOIN InstallateurUser i5_ ON i2_.user_id = i5_.id
  LEFT JOIN IntegrationModule i6_ ON i5_.integrationModule_id = i6_.id
  LEFT JOIN IntegrationModule i7_ ON e3_.integrationModule_id = i7_.id
  LEFT JOIN IntegrationModule i8_ ON p4_.integrationModule_id = i8_.id
  LEFT JOIN TeteReseau t9_ ON i6_.teteReseau_id = t9_.id
  LEFT JOIN TeteReseau t10_ ON i7_.teteReseau_id = t10_.id
  LEFT JOIN TeteReseau t11_ ON i8_.teteReseau_id = t11_.id
  LEFT JOIN Oblige o12_ ON t9_.oblige_id = o12_.id
  LEFT JOIN Oblige o13_ ON t10_.oblige_id = o13_.id
  LEFT JOIN Oblige o14_ ON t11_.oblige_id = o14_.id
WHERE
  p0_.oblige_id = ?
  AND (
    o12_.mandat <> ?
    OR o12_.mandat IS NULL
    OR o13_.mandat <> ?
    OR o13_.mandat IS NULL
    OR o14_.mandat <> ?
    OR o14_.mandat IS NULL
  )
  AND p0_.valid IS NULL
  AND p0_.decisionDate IS NULL
ORDER BY
  i2_.raison ASC

SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM PaymentMethodOblige p0_ LEFT JOIN PaymentMethod p1_ ON p0_.paymentMethod_id = p1_.id LEFT JOIN Installateur i2_ ON p1_.installateur_id = i2_.id LEFT JOIN EntrepriseUser e3_ ON p1_.entrepriseUser_id = e3_.id LEFT JOIN ParticulierUser p4_ ON p1_.particulierUser_id = p4_.id LEFT JOIN InstallateurUser i5_ ON i2_.user_id = i5_.id LEFT JOIN IntegrationModule i6_ ON i5_.integrationModule_id = i6_.id LEFT JOIN IntegrationModule i7_ ON e3_.integrationModule_id = i7_.id LEFT JOIN IntegrationModule i8_ ON p4_.integrationModule_id = i8_.id LEFT JOIN TeteReseau t9_ ON i6_.teteReseau_id = t9_.id LEFT JOIN TeteReseau t10_ ON i7_.teteReseau_id = t10_.id LEFT JOIN TeteReseau t11_ ON i8_.teteReseau_id = t11_.id LEFT JOIN Oblige o12_ ON t9_.oblige_id = o12_.id LEFT JOIN Oblige o13_ ON t10_.oblige_id = o13_.id LEFT JOIN Oblige o14_ ON t11_.oblige_id = o14_.id WHERE p0_.oblige_id = 2 AND (o12_.mandat <> 'officiel' OR o12_.mandat IS NULL OR o13_.mandat <> 'officiel' OR o13_.mandat IS NULL OR o14_.mandat <> 'officiel' OR o14_.mandat IS NULL) AND p0_.valid IS NULL AND p0_.decisionDate IS NULL ORDER BY i2_.raison ASC;

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_COMPTABLE', 'ROLE_SUPERVISEUR_GENERAL',
    'ROLE_ADMIN'
  )
  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_COMPTABLE', 'ROLE_SUPERVISEUR_GENERAL', 'ROLE_ADMIN') AND e0_.activation = 'pending' AND t3_.oblige_id = 2 AND DATE_SUB('2026-06-17 17:41:32', 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_COMPTABLE', 'ROLE_SUPERVISEUR_GENERAL',
    'ROLE_ADMIN'
  )
  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_COMPTABLE', 'ROLE_SUPERVISEUR_GENERAL', 'ROLE_ADMIN') AND p0_.activation = 'pending' AND t2_.oblige_id = 2 AND DATE_SUB('2026-06-17 17:41:32', 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 = 2;

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 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 = 2 AND p7_.activation = 'fully' AND t9_.nom IN ('Consoneo') AND o10_.is_consoneo = 1;