Query Metrics
13
Database Queries
8
Different statements
528.71 ms
Query time
0
Invalid entities
24
Managed entities
0
Cache hits
0
Cache misses
0
Cache puts
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 5.61 ms |
SELECT t0.id AS id_1, t0.appKey AS appKey_2, t0.label AS label_3, t0.description AS description_4, t0.url AS url_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.report_auto_email AS report_auto_email_8, t0.logo AS logo_9, t0.smartName AS smartName_10, t0.prefixEmail AS prefixEmail_11, t0.`lead` AS lead_12, t0.`leadUrl` AS leadUrl_13, t0.`leadLogin` AS leadLogin_14, t0.`leadPassword` AS leadPassword_15, t0.recommanderProDefault AS recommanderProDefault_16, t0.actif AS actif_17, t0.allowMultiSubscription AS allowMultiSubscription_18, t0.teteReseau_id AS teteReseau_id_19, t0.branding AS branding_20 FROM IntegrationModule t0 WHERE t0.appKey = ? LIMIT 1
Parameters:
[
"Tjp3"
]
|
| 2 | 1.01 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.createdAt AS createdAt_3, t0.slug AS slug_4, t0.consoneoInstallateurPrixFixSimulation AS consoneoInstallateurPrixFixSimulation_5, t0.consoneoInstallateurPrixFixOffre AS consoneoInstallateurPrixFixOffre_6, t0.allow_curseur AS allow_curseur_7, t0.consoneoInstallateurVariableTranche1 AS consoneoInstallateurVariableTranche1_8, t0.consoneoInstallateurValeurTranche1 AS consoneoInstallateurValeurTranche1_9, t0.consoneoInstallateurVariableTranche2 AS consoneoInstallateurVariableTranche2_10, t0.consoneoInstallateurValeurTranche2 AS consoneoInstallateurValeurTranche2_11, t0.consoneoInstallateurVariableTranche3 AS consoneoInstallateurVariableTranche3_12, t0.consoneoInstallateurValeurTranche3 AS consoneoInstallateurValeurTranche3_13, t0.consoneoInstallateurVariableTranche4 AS consoneoInstallateurVariableTranche4_14, t0.consoneoInstallateurValeurTranche4 AS consoneoInstallateurValeurTranche4_15, t0.consoneoInstallateurValeurTrancheMax AS consoneoInstallateurValeurTrancheMax_16, t0.logo AS logo_17, t0.modePrime AS modePrime_18, t0.incitation AS incitation_19, t0.`lead` AS lead_20, t0.actif AS actif_21, t0.partenariatContract AS partenariatContract_22, t0.allowElectronicSign AS allowElectronicSign_23, t0.canonicalModuleInstallateur_id AS canonicalModuleInstallateur_id_24, t0.canonicalModuleEntreprise_id AS canonicalModuleEntreprise_id_25, t0.canonicalModuleParticulier_id AS canonicalModuleParticulier_id_26, t0.oblige_id AS oblige_id_27, t0.obligeTargetConsoneoPrixFix_id AS obligeTargetConsoneoPrixFix_id_28, t0.obligeTargetConsoneoPrixVariable_id AS obligeTargetConsoneoPrixVariable_id_29 FROM TeteReseau t0 WHERE t0.id = ?
Parameters:
[
1169
]
|
| 3 | 1.39 ms |
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
]
|
| 4 | 1.16 ms |
SELECT b0_.id AS id_0, b0_.username_canonical AS username_canonical_1, b0_.email AS email_2, b0_.email_canonical AS email_canonical_3, b0_.enabled AS enabled_4, b0_.salt AS salt_5, b0_.password AS password_6, b0_.last_login AS last_login_7, b0_.confirmation_token AS confirmation_token_8, b0_.password_requested_at AS password_requested_at_9, b0_.roles AS roles_10, b0_.username AS username_11, b0_.nom AS nom_12, b0_.prenom AS prenom_13, b0_.fonction AS fonction_14, b0_.tel AS tel_15, b0_.mobile AS mobile_16, b0_.activation AS activation_17, b0_.createdAt AS createdAt_18, b0_.updatedAt AS updatedAt_19, b0_.optin AS optin_20, b0_.dateActivation AS dateActivation_21, b0_.emailValidatedDateTime AS emailValidatedDateTime_22, b0_.emailCreatedDateTime AS emailCreatedDateTime_23, b0_.mobileCreatedDatetime AS mobileCreatedDatetime_24, b0_.sendEmail AS sendEmail_25, b0_.attributes AS attributes_26, b0_.emailRequested AS emailRequested_27, b0_.emailRequestedDate AS emailRequestedDate_28, b0_.lastOffreDate AS lastOffreDate_29, b0_.token AS token_30, b0_.inscriptionFromDemandeOffre AS inscriptionFromDemandeOffre_31, b0_.exclusiveEnabled AS exclusiveEnabled_32, b0_.relanceSmsRegistration AS relanceSmsRegistration_33, b0_.dateRelanceSmsRegistration AS dateRelanceSmsRegistration_34, b0_.company_id AS company_id_35, b0_.workflow_id AS workflow_id_36, b0_.contact_id AS contact_id_37, b0_.obligeTarget_id AS obligeTarget_id_38, b0_.integrationModule_id AS integrationModule_id_39, b0_.identite_id AS identite_id_40 FROM BeUser b0_ INNER JOIN IntegrationModule i1_ ON b0_.integrationModule_id = i1_.id INNER JOIN TeteReseau t2_ ON i1_.teteReseau_id = t2_.id WHERE t2_.oblige_id = ? AND b0_.activation <> ? AND b0_.enabled = ? AND b0_.username = ? LIMIT 1
Parameters:
[ 6 "pending" 1 "[email protected]" ] |
| 5 | 9.87 ms |
SELECT e0_.id AS id_0, e0_.username_canonical AS username_canonical_1, e0_.email AS email_2, e0_.email_canonical AS email_canonical_3, e0_.enabled AS enabled_4, e0_.salt AS salt_5, e0_.password AS password_6, e0_.last_login AS last_login_7, e0_.confirmation_token AS confirmation_token_8, e0_.password_requested_at AS password_requested_at_9, e0_.roles AS roles_10, e0_.username AS username_11, e0_.nom AS nom_12, e0_.prenom AS prenom_13, e0_.fonction AS fonction_14, e0_.tel AS tel_15, e0_.mobile AS mobile_16, e0_.activation AS activation_17, e0_.createdAt AS createdAt_18, e0_.updatedAt AS updatedAt_19, e0_.optin AS optin_20, e0_.dateActivation AS dateActivation_21, e0_.emailValidatedDateTime AS emailValidatedDateTime_22, e0_.emailCreatedDateTime AS emailCreatedDateTime_23, e0_.mobileCreatedDatetime AS mobileCreatedDatetime_24, e0_.sendEmail AS sendEmail_25, e0_.emailRequested AS emailRequested_26, e0_.emailRequestedDate AS emailRequestedDate_27, e0_.lastOffreDate AS lastOffreDate_28, e0_.token AS token_29, e0_.inscriptionFromDemandeOffre AS inscriptionFromDemandeOffre_30, e0_.exclusiveEnabled AS exclusiveEnabled_31, e0_.relanceSmsRegistration AS relanceSmsRegistration_32, e0_.dateRelanceSmsRegistration AS dateRelanceSmsRegistration_33, e0_.company_id AS company_id_34, e0_.workflow_id AS workflow_id_35, e0_.integrationModule_id AS integrationModule_id_36, e0_.identite_id AS identite_id_37 FROM EntrepriseUser e0_ INNER JOIN IntegrationModule i1_ ON e0_.integrationModule_id = i1_.id INNER JOIN TeteReseau t2_ ON i1_.teteReseau_id = t2_.id WHERE t2_.oblige_id = ? AND e0_.activation <> ? AND e0_.enabled = ? AND e0_.username = ? LIMIT 1
Parameters:
[ 6 "pending" 1 "[email protected]" ] |
| 6 | 245.73 ms |
SELECT p0_.id AS id_0, p0_.username_canonical AS username_canonical_1, p0_.email AS email_2, p0_.email_canonical AS email_canonical_3, p0_.enabled AS enabled_4, p0_.salt AS salt_5, p0_.password AS password_6, p0_.last_login AS last_login_7, p0_.confirmation_token AS confirmation_token_8, p0_.password_requested_at AS password_requested_at_9, p0_.roles AS roles_10, p0_.username AS username_11, p0_.nom AS nom_12, p0_.prenom AS prenom_13, p0_.fonction AS fonction_14, p0_.tel AS tel_15, p0_.mobile AS mobile_16, p0_.activation AS activation_17, p0_.createdAt AS createdAt_18, p0_.updatedAt AS updatedAt_19, p0_.optin AS optin_20, p0_.dateActivation AS dateActivation_21, p0_.emailValidatedDateTime AS emailValidatedDateTime_22, p0_.emailCreatedDateTime AS emailCreatedDateTime_23, p0_.mobileCreatedDatetime AS mobileCreatedDatetime_24, p0_.sendEmail AS sendEmail_25, p0_.adresse AS adresse_26, p0_.adresse_complement AS adresse_complement_27, p0_.codepostal AS codepostal_28, p0_.ville AS ville_29, p0_.token AS token_30, p0_.emailRequested AS emailRequested_31, p0_.emailRequestedDate AS emailRequestedDate_32, p0_.inscriptionFromDemandeOffre AS inscriptionFromDemandeOffre_33, p0_.lastOffreDate AS lastOffreDate_34, p0_.tag AS tag_35, p0_.cdiscountGuid AS cdiscountGuid_36, p0_.cdiscountCdav AS cdiscountCdav_37, p0_.gender AS gender_38, p0_.exclusiveEnabled AS exclusiveEnabled_39, p0_.relanceSmsRegistration AS relanceSmsRegistration_40, p0_.dateRelanceSmsRegistration AS dateRelanceSmsRegistration_41, p0_.workflow_id AS workflow_id_42, p0_.cas1_id AS cas1_id_43, p0_.identite_id AS identite_id_44, p0_.integrationModule_id AS integrationModule_id_45 FROM ParticulierUser p0_ INNER JOIN IntegrationModule i1_ ON p0_.integrationModule_id = i1_.id INNER JOIN TeteReseau t2_ ON i1_.teteReseau_id = t2_.id WHERE t2_.oblige_id = ? AND p0_.activation <> ? AND p0_.enabled = ? AND p0_.username = ? LIMIT 1
Parameters:
[ 6 "pending" 1 "[email protected]" ] |
| 7 | 1.29 ms |
SELECT i0_.id AS id_0, i0_.username_canonical AS username_canonical_1, i0_.email AS email_2, i0_.email_canonical AS email_canonical_3, i0_.enabled AS enabled_4, i0_.salt AS salt_5, i0_.password AS password_6, i0_.last_login AS last_login_7, i0_.confirmation_token AS confirmation_token_8, i0_.password_requested_at AS password_requested_at_9, i0_.roles AS roles_10, i0_.username AS username_11, i0_.nom AS nom_12, i0_.prenom AS prenom_13, i0_.fonction AS fonction_14, i0_.tel AS tel_15, i0_.mobile AS mobile_16, i0_.activation AS activation_17, i0_.createdAt AS createdAt_18, i0_.updatedAt AS updatedAt_19, i0_.optin AS optin_20, i0_.dateActivation AS dateActivation_21, i0_.emailValidatedDateTime AS emailValidatedDateTime_22, i0_.emailCreatedDateTime AS emailCreatedDateTime_23, i0_.mobileCreatedDatetime AS mobileCreatedDatetime_24, i0_.sendEmail AS sendEmail_25, i0_.reference AS reference_26, i0_.currentSubscriptionStep AS currentSubscriptionStep_27, i0_.dateRetourContratPartenariat AS dateRetourContratPartenariat_28, i0_.token AS token_29, i0_.dateActivationStep2 AS dateActivationStep2_30, i0_.dateActivationStep4 AS dateActivationStep4_31, i0_.dateActivationStep5 AS dateActivationStep5_32, i0_.dateRefused AS dateRefused_33, i0_.emailRequested AS emailRequested_34, i0_.emailRequestedDate AS emailRequestedDate_35, i0_.attributes AS attributes_36, i0_.lastOffreDate AS lastOffreDate_37, i0_.quicklyTraited AS quicklyTraited_38, i0_.proType AS proType_39, i0_.system_facturation AS system_facturation_40, i0_.signataireAh AS signataireAh_41, i0_.inscription_step AS inscription_step_42, i0_.import_status AS import_status_43, i0_.token_thermor AS token_thermor_44, i0_.exclusiveEnabled AS exclusiveEnabled_45, i0_.relanceSmsRegistration AS relanceSmsRegistration_46, i0_.dateRelanceSmsRegistration AS dateRelanceSmsRegistration_47, i0_.company_id AS company_id_48, i0_.workflow_id AS workflow_id_49, i0_.obligeTarget_id AS obligeTarget_id_50, i0_.identite_id AS identite_id_51, i0_.integrationModule_id AS integrationModule_id_52 FROM InstallateurUser i0_ INNER JOIN IntegrationModule i1_ ON i0_.integrationModule_id = i1_.id INNER JOIN TeteReseau t2_ ON i1_.teteReseau_id = t2_.id WHERE t2_.oblige_id = ? AND i0_.activation <> ? AND i0_.enabled = ? AND i0_.username = ? LIMIT 1
Parameters:
[ 6 "pending" 1 "[email protected]" ] |
| 8 | 0.86 ms |
SELECT t0.id AS id_1, t0.entrepriseUser_id AS entrepriseUser_id_2, t0.particulierUser_id AS particulierUser_id_3, t0.installateurUser_id AS installateurUser_id_4, t0.beUser_id AS beUser_id_5, t0.obligeUser_id AS obligeUser_id_6, t0.obligeRole_id AS obligeRole_id_7 FROM AffectationUser t0 WHERE t0.installateurUser_id IN (?)
Parameters:
[
10570
]
|
| 9 | 5.21 ms |
SELECT t0.id AS id_1, t0.appKey AS appKey_2, t0.label AS label_3, t0.description AS description_4, t0.url AS url_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.report_auto_email AS report_auto_email_8, t0.logo AS logo_9, t0.smartName AS smartName_10, t0.prefixEmail AS prefixEmail_11, t0.`lead` AS lead_12, t0.`leadUrl` AS leadUrl_13, t0.`leadLogin` AS leadLogin_14, t0.`leadPassword` AS leadPassword_15, t0.recommanderProDefault AS recommanderProDefault_16, t0.actif AS actif_17, t0.allowMultiSubscription AS allowMultiSubscription_18, t0.teteReseau_id AS teteReseau_id_19, t0.branding AS branding_20 FROM IntegrationModule t0 WHERE t0.appKey = ? LIMIT 1
Parameters:
[
"Tjp3"
]
|
| 10 | 1.10 ms |
SELECT b0_.id AS id_0, b0_.username_canonical AS username_canonical_1, b0_.email AS email_2, b0_.email_canonical AS email_canonical_3, b0_.enabled AS enabled_4, b0_.salt AS salt_5, b0_.password AS password_6, b0_.last_login AS last_login_7, b0_.confirmation_token AS confirmation_token_8, b0_.password_requested_at AS password_requested_at_9, b0_.roles AS roles_10, b0_.username AS username_11, b0_.nom AS nom_12, b0_.prenom AS prenom_13, b0_.fonction AS fonction_14, b0_.tel AS tel_15, b0_.mobile AS mobile_16, b0_.activation AS activation_17, b0_.createdAt AS createdAt_18, b0_.updatedAt AS updatedAt_19, b0_.optin AS optin_20, b0_.dateActivation AS dateActivation_21, b0_.emailValidatedDateTime AS emailValidatedDateTime_22, b0_.emailCreatedDateTime AS emailCreatedDateTime_23, b0_.mobileCreatedDatetime AS mobileCreatedDatetime_24, b0_.sendEmail AS sendEmail_25, b0_.attributes AS attributes_26, b0_.emailRequested AS emailRequested_27, b0_.emailRequestedDate AS emailRequestedDate_28, b0_.lastOffreDate AS lastOffreDate_29, b0_.token AS token_30, b0_.inscriptionFromDemandeOffre AS inscriptionFromDemandeOffre_31, b0_.exclusiveEnabled AS exclusiveEnabled_32, b0_.relanceSmsRegistration AS relanceSmsRegistration_33, b0_.dateRelanceSmsRegistration AS dateRelanceSmsRegistration_34, b0_.company_id AS company_id_35, b0_.workflow_id AS workflow_id_36, b0_.contact_id AS contact_id_37, b0_.obligeTarget_id AS obligeTarget_id_38, b0_.integrationModule_id AS integrationModule_id_39, b0_.identite_id AS identite_id_40 FROM BeUser b0_ INNER JOIN IntegrationModule i1_ ON b0_.integrationModule_id = i1_.id INNER JOIN TeteReseau t2_ ON i1_.teteReseau_id = t2_.id WHERE t2_.oblige_id = ? AND b0_.activation <> ? AND b0_.enabled = ? AND b0_.username = ? LIMIT 1
Parameters:
[ 6 "pending" 1 "[email protected]" ] |
| 11 | 10.04 ms |
SELECT e0_.id AS id_0, e0_.username_canonical AS username_canonical_1, e0_.email AS email_2, e0_.email_canonical AS email_canonical_3, e0_.enabled AS enabled_4, e0_.salt AS salt_5, e0_.password AS password_6, e0_.last_login AS last_login_7, e0_.confirmation_token AS confirmation_token_8, e0_.password_requested_at AS password_requested_at_9, e0_.roles AS roles_10, e0_.username AS username_11, e0_.nom AS nom_12, e0_.prenom AS prenom_13, e0_.fonction AS fonction_14, e0_.tel AS tel_15, e0_.mobile AS mobile_16, e0_.activation AS activation_17, e0_.createdAt AS createdAt_18, e0_.updatedAt AS updatedAt_19, e0_.optin AS optin_20, e0_.dateActivation AS dateActivation_21, e0_.emailValidatedDateTime AS emailValidatedDateTime_22, e0_.emailCreatedDateTime AS emailCreatedDateTime_23, e0_.mobileCreatedDatetime AS mobileCreatedDatetime_24, e0_.sendEmail AS sendEmail_25, e0_.emailRequested AS emailRequested_26, e0_.emailRequestedDate AS emailRequestedDate_27, e0_.lastOffreDate AS lastOffreDate_28, e0_.token AS token_29, e0_.inscriptionFromDemandeOffre AS inscriptionFromDemandeOffre_30, e0_.exclusiveEnabled AS exclusiveEnabled_31, e0_.relanceSmsRegistration AS relanceSmsRegistration_32, e0_.dateRelanceSmsRegistration AS dateRelanceSmsRegistration_33, e0_.company_id AS company_id_34, e0_.workflow_id AS workflow_id_35, e0_.integrationModule_id AS integrationModule_id_36, e0_.identite_id AS identite_id_37 FROM EntrepriseUser e0_ INNER JOIN IntegrationModule i1_ ON e0_.integrationModule_id = i1_.id INNER JOIN TeteReseau t2_ ON i1_.teteReseau_id = t2_.id WHERE t2_.oblige_id = ? AND e0_.activation <> ? AND e0_.enabled = ? AND e0_.username = ? LIMIT 1
Parameters:
[ 6 "pending" 1 "[email protected]" ] |
| 12 | 244.29 ms |
SELECT p0_.id AS id_0, p0_.username_canonical AS username_canonical_1, p0_.email AS email_2, p0_.email_canonical AS email_canonical_3, p0_.enabled AS enabled_4, p0_.salt AS salt_5, p0_.password AS password_6, p0_.last_login AS last_login_7, p0_.confirmation_token AS confirmation_token_8, p0_.password_requested_at AS password_requested_at_9, p0_.roles AS roles_10, p0_.username AS username_11, p0_.nom AS nom_12, p0_.prenom AS prenom_13, p0_.fonction AS fonction_14, p0_.tel AS tel_15, p0_.mobile AS mobile_16, p0_.activation AS activation_17, p0_.createdAt AS createdAt_18, p0_.updatedAt AS updatedAt_19, p0_.optin AS optin_20, p0_.dateActivation AS dateActivation_21, p0_.emailValidatedDateTime AS emailValidatedDateTime_22, p0_.emailCreatedDateTime AS emailCreatedDateTime_23, p0_.mobileCreatedDatetime AS mobileCreatedDatetime_24, p0_.sendEmail AS sendEmail_25, p0_.adresse AS adresse_26, p0_.adresse_complement AS adresse_complement_27, p0_.codepostal AS codepostal_28, p0_.ville AS ville_29, p0_.token AS token_30, p0_.emailRequested AS emailRequested_31, p0_.emailRequestedDate AS emailRequestedDate_32, p0_.inscriptionFromDemandeOffre AS inscriptionFromDemandeOffre_33, p0_.lastOffreDate AS lastOffreDate_34, p0_.tag AS tag_35, p0_.cdiscountGuid AS cdiscountGuid_36, p0_.cdiscountCdav AS cdiscountCdav_37, p0_.gender AS gender_38, p0_.exclusiveEnabled AS exclusiveEnabled_39, p0_.relanceSmsRegistration AS relanceSmsRegistration_40, p0_.dateRelanceSmsRegistration AS dateRelanceSmsRegistration_41, p0_.workflow_id AS workflow_id_42, p0_.cas1_id AS cas1_id_43, p0_.identite_id AS identite_id_44, p0_.integrationModule_id AS integrationModule_id_45 FROM ParticulierUser p0_ INNER JOIN IntegrationModule i1_ ON p0_.integrationModule_id = i1_.id INNER JOIN TeteReseau t2_ ON i1_.teteReseau_id = t2_.id WHERE t2_.oblige_id = ? AND p0_.activation <> ? AND p0_.enabled = ? AND p0_.username = ? LIMIT 1
Parameters:
[ 6 "pending" 1 "[email protected]" ] |
| 13 | 1.13 ms |
SELECT i0_.id AS id_0, i0_.username_canonical AS username_canonical_1, i0_.email AS email_2, i0_.email_canonical AS email_canonical_3, i0_.enabled AS enabled_4, i0_.salt AS salt_5, i0_.password AS password_6, i0_.last_login AS last_login_7, i0_.confirmation_token AS confirmation_token_8, i0_.password_requested_at AS password_requested_at_9, i0_.roles AS roles_10, i0_.username AS username_11, i0_.nom AS nom_12, i0_.prenom AS prenom_13, i0_.fonction AS fonction_14, i0_.tel AS tel_15, i0_.mobile AS mobile_16, i0_.activation AS activation_17, i0_.createdAt AS createdAt_18, i0_.updatedAt AS updatedAt_19, i0_.optin AS optin_20, i0_.dateActivation AS dateActivation_21, i0_.emailValidatedDateTime AS emailValidatedDateTime_22, i0_.emailCreatedDateTime AS emailCreatedDateTime_23, i0_.mobileCreatedDatetime AS mobileCreatedDatetime_24, i0_.sendEmail AS sendEmail_25, i0_.reference AS reference_26, i0_.currentSubscriptionStep AS currentSubscriptionStep_27, i0_.dateRetourContratPartenariat AS dateRetourContratPartenariat_28, i0_.token AS token_29, i0_.dateActivationStep2 AS dateActivationStep2_30, i0_.dateActivationStep4 AS dateActivationStep4_31, i0_.dateActivationStep5 AS dateActivationStep5_32, i0_.dateRefused AS dateRefused_33, i0_.emailRequested AS emailRequested_34, i0_.emailRequestedDate AS emailRequestedDate_35, i0_.attributes AS attributes_36, i0_.lastOffreDate AS lastOffreDate_37, i0_.quicklyTraited AS quicklyTraited_38, i0_.proType AS proType_39, i0_.system_facturation AS system_facturation_40, i0_.signataireAh AS signataireAh_41, i0_.inscription_step AS inscription_step_42, i0_.import_status AS import_status_43, i0_.token_thermor AS token_thermor_44, i0_.exclusiveEnabled AS exclusiveEnabled_45, i0_.relanceSmsRegistration AS relanceSmsRegistration_46, i0_.dateRelanceSmsRegistration AS dateRelanceSmsRegistration_47, i0_.company_id AS company_id_48, i0_.workflow_id AS workflow_id_49, i0_.obligeTarget_id AS obligeTarget_id_50, i0_.identite_id AS identite_id_51, i0_.integrationModule_id AS integrationModule_id_52 FROM InstallateurUser i0_ INNER JOIN IntegrationModule i1_ ON i0_.integrationModule_id = i1_.id INNER JOIN TeteReseau t2_ ON i1_.teteReseau_id = t2_.id WHERE t2_.oblige_id = ? AND i0_.activation <> ? AND i0_.enabled = ? AND i0_.username = ? LIMIT 1
Parameters:
[ 6 "pending" 1 "[email protected]" ] |
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\AffectationUser | 5 |
| Consoneo\Bundle\UserBundle\Entity\ObligeRole | 5 |
| Consoneo\Bundle\ObligeBundle\Entity\IntegrationModule | 3 |
| Consoneo\Bundle\UserBundle\Entity\TeteReseau | 2 |
| Consoneo\Bundle\UserBundle\Entity\ObligeUser | 2 |
| Consoneo\Bundle\WorkflowBundle\Entity\Branding | 1 |
| Consoneo\Bundle\UserBundle\Entity\Oblige | 1 |
| Consoneo\Bundle\ObligeBundle\Entity\MprConfig | 1 |
| Consoneo\Bundle\UserBundle\Entity\InstallateurUser | 1 |
| Consoneo\Bundle\UserBundle\Entity\Installateur | 1 |
| Consoneo\Bundle\WorkflowBundle\Entity\Workflow | 1 |
| Consoneo\Bundle\UserBundle\Entity\Identite | 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. |
stats entity manager
No loaded entities.
qrdecode entity manager
| Class | Mapping errors |
|---|---|
| C2eCoreBundle\Entity\DocumentQrDecode | No errors. |