Redirect 302 redirect from GET @dashboard (1f50cd)

GET https://admin.preprod-orion.dossier-c2e.fr/

Query Metrics

32 Database Queries
27 Different statements
214.39 ms Query time
0 Invalid entities
67 Managed entities
0 Cache hits
0 Cache misses
0 Cache puts

Grouped Statements

Show all queries

default connection

Time Count Info
38.69 ms
(18.04%)
1
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
Parameters:
[
  6
  "officiel"
  "officiel"
  "officiel"
]
33.47 ms
(15.61%)
1
SELECT COUNT(DISTINCT d0_.id) AS sclr_0 FROM Document d0_ LEFT JOIN OffreProjet o1_ ON d0_.offreProjet_id = o1_.id LEFT JOIN DocumentType d2_ ON d0_.type_id = d2_.id LEFT JOIN Operation o3_ ON o1_.operation_id = o3_.id LEFT JOIN Simulateur s4_ ON o3_.simulateur_id = s4_.id LEFT JOIN ParticulierUser p5_ ON o1_.particulierUser_id = p5_.id LEFT JOIN InstallateurUser i6_ ON o1_.installateurUser_id = i6_.id LEFT JOIN BeUser b7_ ON o1_.beUser_id = b7_.id LEFT JOIN EntrepriseUser e8_ ON o1_.entrepriseUser_id = e8_.id LEFT JOIN ParticulierUserContact p9_ ON o1_.particulierUserContact_id = p9_.id LEFT JOIN EntrepriseUserContact e10_ ON o1_.entrepriseUserContact_id = e10_.id LEFT JOIN InstallateurUserContact i11_ ON o1_.installateurUserContact_id = i11_.id LEFT JOIN Installateur i12_ ON i6_.company_id = i12_.id LEFT JOIN Entreprise e13_ ON e8_.company_id = e13_.id LEFT JOIN Be b14_ ON b7_.company_id = b14_.id LEFT JOIN EntrepriseContact e15_ ON e10_.id = e15_.user_id LEFT JOIN InstallateurContact i16_ ON i11_.company_id = i16_.id LEFT JOIN document_payment d18_ ON d0_.id = d18_.document_id LEFT JOIN Payment p17_ ON p17_.id = d18_.payment_id LEFT JOIN OffreProjet o19_ ON p17_.offreProjet_id = o19_.id LEFT JOIN ParticulierUser p20_ ON o19_.particulierUser_id = p20_.id LEFT JOIN InstallateurUser i21_ ON o19_.installateurUser_id = i21_.id LEFT JOIN BeUser b22_ ON o19_.beUser_id = b22_.id LEFT JOIN EntrepriseUser e23_ ON o19_.entrepriseUser_id = e23_.id LEFT JOIN ParticulierUserContact p24_ ON o19_.particulierUserContact_id = p24_.id LEFT JOIN EntrepriseUserContact e25_ ON o19_.entrepriseUserContact_id = e25_.id LEFT JOIN InstallateurUserContact i26_ ON o19_.installateurUserContact_id = i26_.id LEFT JOIN Installateur i27_ ON i21_.company_id = i27_.id LEFT JOIN Entreprise e28_ ON e23_.company_id = e28_.id LEFT JOIN Be b29_ ON b22_.company_id = b29_.id LEFT JOIN EntrepriseContact e30_ ON e25_.id = e30_.user_id LEFT JOIN InstallateurContact i31_ ON i26_.company_id = i31_.id LEFT JOIN Justificatif j32_ ON d0_.justificatif_id = j32_.id LEFT JOIN Declarant d33_ ON j32_.id = d33_.justificatif_id LEFT JOIN OffreProjet o34_ ON j32_.id = o34_.justificatif_id LEFT JOIN Cas1 c35_ ON j32_.cas1_id = c35_.id LEFT JOIN ParticulierUserContact p36_ ON c35_.id = p36_.cas1_id LEFT JOIN OffreProjet o37_ ON p36_.id = o37_.particulierUserContact_id LEFT JOIN ParticulierUser p38_ ON c35_.id = p38_.cas1_id LEFT JOIN OffreProjet o39_ ON p38_.id = o39_.particulierUser_id LEFT JOIN ProjectBundle p40_ ON o1_.project_bundle_id = p40_.id INNER JOIN ObligeUser o41_ ON d0_.obligeUser_id = o41_.id WHERE d0_.process = 0 AND d0_.secondJustificatif = 0 AND d0_.decoded = 1 AND d0_.disabled = 0 AND o41_.oblige_id IN (21, 23, 6)
Parameters:
[]
27.97 ms
(13.04%)
2
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 = ?
Parameters:
[
  6
]
23.80 ms
(11.10%)
1
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 WHERE o0_.etat = ? AND o0_.pricingType = ? AND o0_.oblige_id = ? AND p7_.activation = ?
Parameters:
[
  "demande_convention"
  "osm"
  6
  "fully"
]
8.14 ms
(3.80%)
1
SELECT COUNT(DISTINCT i0_.id) AS sclr_0 FROM InstallateurUser i0_ INNER JOIN Installateur i1_ ON i0_.company_id = i1_.id INNER JOIN IntegrationModule i2_ ON i0_.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 i0_.id = a5_.installateurUser_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 i0_.workflow_id = w8_.mode LEFT JOIN QualificationRecord q9_ ON i1_.id = q9_.installateur_id LEFT JOIN Qualification q10_ ON q9_.qualification_id = q10_.id WHERE w8_.mode IN ('exclusive', 'installateur', 'consoneo_installateur', 'consoneo_installateur_prix_fix', 'consoneo_installateur_prix_variable') AND i0_.activation IN ('pending', 'pending_step_1', 'pending_step_2', 'pending_step_3', 'pending_step_4', 'pending_step_5', 'pending_step_6') AND t3_.oblige_id IN (21, 23, 6) ORDER BY i0_.id DESC
Parameters:
[]
7.41 ms
(3.46%)
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 (5, 10, 13, 18, 19, 7, 8, 9, 11, 12, 14, 15, 16, 17, 26, 27) AND e0_.activation = ? AND t3_.oblige_id = ? AND DATE_SUB(?, INTERVAL 5 MINUTE) >= e0_.createdAt ORDER BY e0_.id DESC
Parameters:
[
  "pending"
  6
  "2026-06-17 17:41:56"
]
7.24 ms
(3.38%)
1
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 WHERE (o1_.oblige_id = ? OR o1_.id = ?) AND o0_.etat IN ('dossier_en_validation_operateur', 'dossier_en_validation_manager_tech', 'dossier_en_validation_manager_bu1', 'dossier_en_validation_manager_bu2')
Parameters:
[
  6
  6
]
6.77 ms
(3.16%)
1
SELECT COUNT(DISTINCT q0_.id) AS sclr_0 FROM QualificationRecord q0_ LEFT JOIN InstallateurContact i1_ ON q0_.installateurContact_id = i1_.id LEFT JOIN SousTraitantRGE s2_ ON q0_.sousTraitant_id = s2_.id LEFT JOIN InstallateurUserContact i3_ ON i1_.id = i3_.company_id LEFT JOIN OffreProjet o4_ ON i3_.id = o4_.installateurUserContact_id LEFT JOIN Oblige o5_ ON o4_.oblige_id = o5_.id LEFT JOIN OffreProjet o6_ ON s2_.id = o6_.sousTraitant_id LEFT JOIN OffreProjetDocumentObligatoire o7_ ON o4_.id = o7_.offreProjet_id LEFT JOIN OffreProjetDocumentObligatoire o8_ ON o6_.id = o8_.offreProjet_id LEFT JOIN OffreProjetDocumentObligatoire_DomaineTravaux o10_ ON o7_.id = o10_.offreProjetDocumentObligatoire_id LEFT JOIN DomaineTravauxRGE d9_ ON d9_.id = o10_.domaineTravaux_id LEFT JOIN OffreProjetDocumentObligatoire_DomaineTravaux o12_ ON o8_.id = o12_.offreProjetDocumentObligatoire_id LEFT JOIN DomaineTravauxRGE d11_ ON d11_.id = o12_.domaineTravaux_id LEFT JOIN Operation o13_ ON o4_.operation_id = o13_.id LEFT JOIN Operation o14_ ON o6_.operation_id = o14_.id LEFT JOIN AffectationOffre a15_ ON o4_.id = a15_.offreProjet_id LEFT JOIN AffectationOffre a16_ ON o6_.id = a16_.offreProjet_id WHERE (a15_.obligeUser_id = ? OR a16_.obligeUser_id = ?) AND (o4_.oblige_id = ? OR o5_.oblige_id = ?) AND q0_.dateFin IS NOT NULL AND q0_.dateEdit IS NOT NULL AND (o4_.status IN ('p', 'a') OR o6_.status IN ('p', 'a')) AND q0_.valid = ? AND (o7_.satisfied = ? OR o8_.satisfied = ?)
Parameters:
[
  44
  44
  6
  6
  0
  0
  0
]
6.74 ms
(3.14%)
1
SELECT COUNT(DISTINCT a0_.id) AS sclr_0 FROM AlertRecord a0_ INNER JOIN ObligeUser o1_ ON a0_.obligeUser_id = o1_.id LEFT JOIN BeUser b2_ ON a0_.beUser_id = b2_.id LEFT JOIN OffreProjet o3_ ON a0_.offreprojet_id = o3_.id LEFT JOIN ParticulierUser p4_ ON a0_.particulierUser_id = p4_.id LEFT JOIN EntrepriseUser e5_ ON a0_.entrepriseUser_id = e5_.id LEFT JOIN InstallateurUser i6_ ON a0_.installateurUser_id = i6_.id LEFT JOIN BeUser b7_ ON o3_.beUser_id = b7_.id LEFT JOIN EntrepriseUser e8_ ON o3_.entrepriseUser_id = e8_.id LEFT JOIN ParticulierUser p9_ ON o3_.particulierUser_id = p9_.id LEFT JOIN InstallateurUser i10_ ON o3_.installateurUser_id = i10_.id LEFT JOIN Message m11_ ON a0_.message_id = m11_.id WHERE a0_.status = ? AND a0_.message_id IS NULL AND o1_.oblige_id IN (21, 23, 6)
Parameters:
[
  "active"
]
6.40 ms
(2.98%)
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_.oblige_id = ? AND c0_.disabled = ? AND (c0_.current >= c0_.threshold OR DATE(?) > DATE(c0_.expirationDate))
Parameters:
[
  6
  0
  "2026-06-17 17:41:56"
]
5.94 ms
(2.77%)
1
SELECT COUNT(DISTINCT b0_.id) AS sclr_0 FROM BeUser b0_ INNER JOIN Be b1_ ON b0_.company_id = b1_.id INNER JOIN IntegrationModule i2_ ON b0_.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 b0_.id = a5_.beUser_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 b0_.workflow_id = w8_.mode WHERE b0_.activation IN ('pending', 'pending_step_2') AND t3_.oblige_id IN (21, 23, 6) ORDER BY b0_.id DESC
Parameters:
[]
3.76 ms
(1.75%)
3
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 WHERE (o1_.oblige_id = ? OR o1_.id = ?) AND o0_.etat = ? AND o5_.role = ? AND a2_.obligeUser_id = ?
Parameters:
[
  6
  6
  "dossier_en_validation_manager_bu2"
  "ROLE_MANAGER_BUSINESS_2"
  44
]
3.62 ms
(1.69%)
1
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.oblige_id = ?
Parameters:
[
  6
]
3.01 ms
(1.40%)
1
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 WHERE (o1_.oblige_id = ? OR o1_.id = ?) AND o0_.etat IN ('dossier_en_validation_operateur', 'dossier_en_validation_manager_tech')
Parameters:
[
  6
  6
]
2.92 ms
(1.36%)
1
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 WHERE (o1_.oblige_id = ? OR o1_.id = ?) AND o0_.etat IN ('dossier_en_validation_operateur', 'dossier_en_validation_manager_tech', 'dossier_en_validation_manager_bu1')
Parameters:
[
  6
  6
]
2.62 ms
(1.22%)
1
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 WHERE (o1_.oblige_id = ? OR o1_.id = ?) AND o0_.etat = ? AND o5_.role IN ('ROLE_OPERATEUR_PROJET_B2B', 'ROLE_OPERATEUR_PROJET_B2C') AND a2_.obligeUser_id = ?
Parameters:
[
  6
  6
  "dossier_en_validation_operateur"
  44
]
2.48 ms
(1.16%)
2
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 = ?
Parameters:
[
  44
]
2.29 ms
(1.07%)
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 = ?
Parameters:
[
  44
]
2.06 ms
(0.96%)
1
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 (5, 10, 13, 18, 19, 7, 8, 9, 11, 12, 14, 15, 16, 17, 26, 27) 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
Parameters:
[
  "pending"
  6
  "2026-06-17 17:41:56"
  1
  0
]
1.36 ms
(0.63%)
1
SELECT COUNT(DISTINCT q0_.id) AS sclr_0 FROM QualificationRecord q0_ INNER JOIN Installateur i1_ ON q0_.installateur_id = i1_.id INNER JOIN Qualification q2_ ON q0_.qualification_id = q2_.id INNER JOIN InstallateurUser i3_ ON i1_.user_id = i3_.id INNER JOIN AffectationUser a4_ ON i3_.id = a4_.installateurUser_id INNER JOIN IntegrationModule i5_ ON i3_.integrationModule_id = i5_.id INNER JOIN TeteReseau t6_ ON i5_.teteReseau_id = t6_.id WHERE q2_.slug = ? AND q0_.active = ? AND q0_.valid = ? AND i3_.activation = ? AND (a4_.obligeUser_id = ? OR t6_.oblige_id IN (21, 23, 6))
Parameters:
[
  "rge"
  0
  0
  "fully"
  44
]
1.24 ms
(0.58%)
1
SELECT COUNT(DISTINCT a0_.id) AS sclr_0 FROM AlertRecord a0_ INNER JOIN ObligeUser o1_ ON a0_.obligeUser_id = o1_.id LEFT JOIN BeUser b2_ ON a0_.beUser_id = b2_.id LEFT JOIN OffreProjet o3_ ON a0_.offreprojet_id = o3_.id LEFT JOIN ParticulierUser p4_ ON a0_.particulierUser_id = p4_.id LEFT JOIN EntrepriseUser e5_ ON a0_.entrepriseUser_id = e5_.id LEFT JOIN InstallateurUser i6_ ON a0_.installateurUser_id = i6_.id LEFT JOIN BeUser b7_ ON o3_.beUser_id = b7_.id LEFT JOIN EntrepriseUser e8_ ON o3_.entrepriseUser_id = e8_.id LEFT JOIN ParticulierUser p9_ ON o3_.particulierUser_id = p9_.id LEFT JOIN InstallateurUser i10_ ON o3_.installateurUser_id = i10_.id LEFT JOIN Message m11_ ON a0_.message_id = m11_.id WHERE a0_.status = ? AND a0_.message_id IS NOT NULL AND o1_.oblige_id IN (21, 23, 6)
Parameters:
[
  "active"
]
1.21 ms
(0.57%)
1
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 INNER JOIN obligeuser_obligeuser ON t0.id = obligeuser_obligeuser.obligeuser_target WHERE obligeuser_obligeuser.obligeuser_source = ?
Parameters:
[
  44
]
1.14 ms
(0.53%)
1
SELECT COUNT(DISTINCT a0_.id) AS sclr_0 FROM AlertRecord a0_ INNER JOIN ObligeUser o1_ ON a0_.obligeUser_id = o1_.id INNER JOIN Alert a2_ ON a0_.alert_id = a2_.id WHERE a0_.obligeUser_id = ? AND a0_.status = ? AND a0_.message_id IS NULL
Parameters:
[
  44
  "active"
]
1.08 ms
(0.51%)
1
SELECT COUNT(DISTINCT a0_.id) AS sclr_0 FROM AlertRecord a0_ INNER JOIN ObligeUser o1_ ON a0_.obligeUser_id = o1_.id INNER JOIN Alert a2_ ON a0_.alert_id = a2_.id WHERE a0_.obligeUser_id = ? AND a0_.status = ? AND a0_.message_id IS NOT NULL
Parameters:
[
  44
  "active"
]
1.02 ms
(0.48%)
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_ INNER JOIN CappingRuleHistory c1_ ON c0_.id = c1_.cappingRule_id WHERE c0_.oblige_id = ? AND c1_.type = ?
Parameters:
[
  6
  "alert_dismissed"
]
0.95 ms
(0.44%)
1
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 = ?
Parameters:
[
  2
]

read connection

Time Count Info
11.06 ms
(5.16%)
1
SELECT count(d.id) FROM Document d WHERE (d.process = 0) AND (d.secondJustificatif = 0) AND (d.decoded = 1) AND (d.disabled = 0) AND (d.obligeUser_id = ?)
Parameters:
[
  44
]

Database Connections

Name Service
default doctrine.dbal.default_connection
read doctrine.dbal.read_connection
stats doctrine.dbal.stats_connection
qrdecode doctrine.dbal.qrdecode_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
read doctrine.orm.read_entity_manager
stats doctrine.orm.stats_entity_manager
qrdecode doctrine.orm.qrdecode_entity_manager

Second Level Cache

0 Hits
0 Misses
0 Puts

Managed Entities

default entity manager

Class Amount of managed objects
Consoneo\Bundle\UserBundle\Entity\RegleRole 37
Consoneo\Bundle\UserBundle\Entity\ObligeRole 17
Consoneo\Bundle\UserBundle\Entity\TeteReseau 6
Consoneo\Bundle\UserBundle\Entity\Oblige 4
Consoneo\Bundle\UserBundle\Entity\ObligeUser 2
Consoneo\Bundle\ObligeBundle\Entity\MprConfig 1

read entity manager

Class Amount of managed objects

stats entity manager

Class Amount of managed objects

qrdecode entity manager

Class Amount of managed objects

Entities Mapping

default entity manager

Class Mapping errors
Consoneo\Bundle\UserBundle\Entity\ObligeUser No errors.
Consoneo\Bundle\UserBundle\Entity\Oblige No errors.
Consoneo\Bundle\ObligeBundle\Entity\Reminder No errors.
Consoneo\Bundle\ObligeBundle\Entity\Comment No errors.
Consoneo\Bundle\ObligeBundle\Entity\Document No errors.
Consoneo\Bundle\UserBundle\Entity\TeteReseau No errors.
Consoneo\Bundle\WorkflowBundle\Entity\AlertRecord No errors.
Consoneo\Bundle\ObligeBundle\Entity\StatRecord No errors.
Consoneo\Bundle\UserBundle\Entity\AffectationUser No errors.
Consoneo\Bundle\UserBundle\Entity\AffectationOffre No errors.
Consoneo\Bundle\UserBundle\Entity\RegleRole No errors.
Consoneo\Bundle\ObligeBundle\Entity\Campagne No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetMonitoring No errors.
Consoneo\Bundle\ObligeBundle\Entity\PaymentMethodOblige No errors.
Consoneo\Bundle\ObligeBundle\Entity\ControlStepHistory No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetAdditionalInformation No errors.
Consoneo\Bundle\ObligeBundle\Entity\Configuration No errors.
Consoneo\Bundle\WorkflowBundle\Entity\EmailHistory No errors.
Consoneo\Bundle\SimulateurBundle\Entity\Operation No errors.
Consoneo\Bundle\ObligeBundle\Entity\MoteurInfoArrete No errors.
Consoneo\Bundle\ObligeBundle\Entity\Arrete No errors.
Consoneo\Bundle\ObligeBundle\Entity\Contract No errors.
Consoneo\Bundle\ObligeBundle\Entity\DocumentStatic No errors.
Consoneo\Bundle\ObligeBundle\Entity\DocumentType No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjetDocumentObligatoire No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjet No errors.
Consoneo\Bundle\ObligeBundle\Entity\SampleCofracOperation No errors.
Consoneo\Bundle\ObligeBundle\Entity\Batch No errors.
Consoneo\Bundle\WorkflowBundle\Entity\Email No errors.
Consoneo\Bundle\UserBundle\Entity\InstallateurCertificallConfig No errors.
C2eCoreBundle\Entity\Certificall\Certilink No errors.
Consoneo\Bundle\UserBundle\Entity\ObligeRole No errors.
Consoneo\Bundle\ObligeBundle\Entity\Alert No errors.
Consoneo\Bundle\ObligeBundle\Entity\CappingRule No errors.
Consoneo\Bundle\ObligeBundle\Entity\Mediateur No errors.
Consoneo\Bundle\ObligeBundle\Entity\MprConfig No errors.
Consoneo\Bundle\UserBundle\Entity\Mandataire No errors.
Consoneo\Bundle\ObligeBundle\Entity\User\Program\Commercial No errors.
Consoneo\Bundle\ObligeBundle\Entity\User\Program\Manager No errors.
Consoneo\Bundle\ObligeBundle\Entity\PricingGroup No errors.
Consoneo\Bundle\ObligeBundle\Entity\ObligeOperation No errors.
Consoneo\Bundle\ObligeBundle\Entity\ObligeBlockedTimetable No errors.
Consoneo\Bundle\WorkflowBundle\Entity\CoupDePouce No errors.
Consoneo\Bundle\ObligeBundle\Entity\EmailConfigurationRecord No errors.
Consoneo\Bundle\ObligeBundle\Entity\ConfigurationPaymentRecord No errors.
Consoneo\Bundle\WorkflowBundle\Entity\ProgramAuto No errors.
Consoneo\Bundle\UserBundle\Entity\AffectationConsoneoRule No errors.
Consoneo\Bundle\UserBundle\Entity\ObligeDocumentTypeConfig No errors.
Consoneo\Bundle\ObligeBundle\Entity\Product\Product No errors.
Consoneo\Bundle\ObligeBundle\Entity\PrestataireEffacement No errors.

read entity manager

Class Mapping errors
Consoneo\Bundle\SimulateurBundle\Entity\ZoneClimatique No errors.
Consoneo\Bundle\ObligeBundle\Entity\Configuration No errors.
Consoneo\Bundle\UserBundle\Entity\Oblige No errors.
Consoneo\Bundle\ObligeBundle\Entity\OffreProjet No errors.
Consoneo\Bundle\WorkflowBundle\Entity\AlertRecord No errors.
Consoneo\Bundle\ObligeBundle\Entity\Reminder No errors.
Consoneo\Bundle\UserBundle\Entity\ObligeUser No errors.
Consoneo\Bundle\ObligeBundle\Entity\PaymentMethodOblige No errors.
Consoneo\Bundle\UserBundle\Entity\EntrepriseUser No errors.
Consoneo\Bundle\UserBundle\Entity\ParticulierUser No errors.
Consoneo\Bundle\UserBundle\Entity\InstallateurUser No errors.
Consoneo\Bundle\UserBundle\Entity\QualificationRecord No errors.
Consoneo\Bundle\UserBundle\Entity\BeUser No errors.
Consoneo\Bundle\ObligeBundle\Entity\Document No errors.

stats entity manager

No loaded entities.

qrdecode entity manager

Class Mapping errors
C2eCoreBundle\Entity\DocumentQrDecode No errors.