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
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
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. |