Query Metrics
10
Database Queries
7
Different statements
17.56 ms
Query time
0
Invalid entities
10
Managed entities
0
Cache hits
0
Cache misses
0
Cache puts
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.29 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:
[
"1234"
]
|
| 2 | 2.94 ms |
SELECT t0.username AS username_1, t0.email AS email_2, t0.enabled AS enabled_3, t0.salt AS salt_4, t0.last_login AS last_login_5, t0.confirmation_token AS confirmation_token_6, t0.password_requested_at AS password_requested_at_7, t0.roles AS roles_8, t0.email_canonical AS email_canonical_9, t0.username_canonical AS username_canonical_10, t0.password AS password_11, t0.reference AS reference_12, t0.currentSubscriptionStep AS currentSubscriptionStep_13, t0.dateRetourContratPartenariat AS dateRetourContratPartenariat_14, t0.token AS token_15, t0.dateActivationStep2 AS dateActivationStep2_16, t0.dateActivationStep4 AS dateActivationStep4_17, t0.dateActivationStep5 AS dateActivationStep5_18, t0.dateRefused AS dateRefused_19, t0.emailRequested AS emailRequested_20, t0.emailRequestedDate AS emailRequestedDate_21, t0.attributes AS attributes_22, t0.lastOffreDate AS lastOffreDate_23, t0.quicklyTraited AS quicklyTraited_24, t0.proType AS proType_25, t0.system_facturation AS system_facturation_26, t0.signataireAh AS signataireAh_27, t0.inscription_step AS inscription_step_28, t0.import_status AS import_status_29, t0.token_thermor AS token_thermor_30, t0.relanceSmsRegistration AS relanceSmsRegistration_31, t0.dateRelanceSmsRegistration AS dateRelanceSmsRegistration_32, t0.id AS id_33, t0.nom AS nom_34, t0.prenom AS prenom_35, t0.fonction AS fonction_36, t0.tel AS tel_37, t0.mobile AS mobile_38, t0.activation AS activation_39, t0.createdAt AS createdAt_40, t0.updatedAt AS updatedAt_41, t0.optin AS optin_42, t0.dateActivation AS dateActivation_43, t0.emailValidatedDateTime AS emailValidatedDateTime_44, t0.emailCreatedDateTime AS emailCreatedDateTime_45, t0.mobileCreatedDatetime AS mobileCreatedDatetime_46, t0.sendEmail AS sendEmail_47, t0.company_id AS company_id_48, t0.workflow_id AS workflow_id_49, t0.obligeTarget_id AS obligeTarget_id_50, t0.identite_id AS identite_id_51, t0.integrationModule_id AS integrationModule_id_52 FROM InstallateurUser t0 WHERE t0.token IS NULL LIMIT 1
Parameters:
[] |
| 3 | 2.17 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:
[
2
]
|
| 4 | 1.44 ms |
SELECT t0.signature AS signature_1, t0.logo AS logo_2, t0.formation_installateur_doc AS formation_installateur_doc_3, t0.pres_marketing_installateur AS pres_marketing_installateur_4, t0.guide_utilisation_commerciaux AS guide_utilisation_commerciaux_5, t0.guidePerformanceEnergetiqueB2b AS guidePerformanceEnergetiqueB2b_6, t0.guidePerformanceEnergetiqueB2c AS guidePerformanceEnergetiqueB2c_7, t0.cgu AS cgu_8, t0.partenariatContract AS partenariatContract_9, t0.tel_beneficiaire_B2C AS tel_beneficiaire_B2C_10, t0.tel_beneficiaire_B2B AS tel_beneficiaire_B2B_11, t0.tel_installateur AS tel_installateur_12, t0.tel_support_intern AS tel_support_intern_13, t0.fax_beneficiaire AS fax_beneficiaire_14, t0.fax_installateur AS fax_installateur_15, t0.adresse AS adresse_16, t0.adresse_complement AS adresse_complement_17, t0.codepostal AS codepostal_18, t0.ville AS ville_19, t0.email_beneficiaire AS email_beneficiaire_20, t0.email_installateur AS email_installateur_21, t0.is_consoneo AS is_consoneo_22, t0.slug AS slug_23, t0.conventionElectronique AS conventionElectronique_24, t0.aftElectronique AS aftElectronique_25, t0.contratInstallateur AS contratInstallateur_26, t0.modeProBeneficiaireInscription AS modeProBeneficiaireInscription_27, t0.modeByPassSuperviseur AS modeByPassSuperviseur_28, t0.`lead` AS lead_29, t0.`leadUrl` AS leadUrl_30, t0.`leadLogin` AS leadLogin_31, t0.`leadPassword` AS leadPassword_32, t0.relanceConventionClientUn AS relanceConventionClientUn_33, t0.relanceConventionClientDeux AS relanceConventionClientDeux_34, t0.alertConventionClient AS alertConventionClient_35, t0.relanceConventionInstallateurUn AS relanceConventionInstallateurUn_36, t0.relanceConventionInstallateurDeux AS relanceConventionInstallateurDeux_37, t0.alertConventionInstallateur AS alertConventionInstallateur_38, t0.conventionFin AS conventionFin_39, t0.questionnaireAftRelanceUn AS questionnaireAftRelanceUn_40, t0.questionnaireAftRelanceDeux AS questionnaireAftRelanceDeux_41, t0.alertQuestionnaireAFT AS alertQuestionnaireAFT_42, t0.questionnaireAftFin AS questionnaireAftFin_43, t0.relanceAftFacture AS relanceAftFacture_44, t0.alertAftFacture AS alertAftFacture_45, t0.aftFactureFin AS aftFactureFin_46, t0.mentionCnil AS mentionCnil_47, t0.serviceType AS serviceType_48, t0.precariteMode AS precariteMode_49, t0.precariteModeProgram AS precariteModeProgram_50, t0.blocked AS blocked_51, t0.blockedSimulation AS blockedSimulation_52, t0.resiliation AS resiliation_53, t0.archivageAuto AS archivageAuto_54, t0.travauxPostDevis AS travauxPostDevis_55, t0.emailFacturationPro AS emailFacturationPro_56, t0.mandatoryInstallateurGenericContract AS mandatoryInstallateurGenericContract_57, t0.hiddenEmail AS hiddenEmail_58, t0.certificallCompanyId AS certificallCompanyId_59, t0.visibilityCommercials AS visibilityCommercials_60, t0.mandat AS mandat_61, t0.pricingMandatClassique AS pricingMandatClassique_62, t0.pricingMandatPreca AS pricingMandatPreca_63, t0.pricingPrimeMaximumMandatClassique AS pricingPrimeMaximumMandatClassique_64, t0.pricingPrimeMaximumMandatPreca AS pricingPrimeMaximumMandatPreca_65, t0.originauxAdresse AS originauxAdresse_66, t0.originauxAdresseComplement AS originauxAdresseComplement_67, t0.originauxCodepostal AS originauxCodepostal_68, t0.originauxVille AS originauxVille_69, t0.eligible AS eligible_70, t0.satisfactionSurvey AS satisfactionSurvey_71, t0.surveyConfiguration AS surveyConfiguration_72, t0.autoPayment AS autoPayment_73, t0.isAnnexeDechetQuestion AS isAnnexeDechetQuestion_74, t0.aiEnabled AS aiEnabled_75, t0.isSignatureAutoAhEnabled AS isSignatureAutoAhEnabled_76, t0.isSignatureAutoOtherDocumentsEnabled AS isSignatureAutoOtherDocumentsEnabled_77, t0.emailVersion AS emailVersion_78, t0.validateBackwards AS validateBackwards_79, t0.displayTelConsoneo AS displayTelConsoneo_80, t0.allowedUniverSign AS allowedUniverSign_81, t0.allowedApplicationFees AS allowedApplicationFees_82, t0.displayApplicationFees AS displayApplicationFees_83, t0.programAutoAllowed AS programAutoAllowed_84, t0.mpr AS mpr_85, t0.isRibActivated AS isRibActivated_86, t0.id AS id_87, t0.raison AS raison_88, t0.siret AS siret_89, t0.website AS website_90, t0.effectif AS effectif_91, t0.status AS status_92, t0.created_datetime AS created_datetime_93, t0.updated_datetime AS updated_datetime_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:
[
2
]
|
| 5 | 2.37 ms |
SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3, t0.`description` AS description_4, t0.object_id AS object_id_5, t0.object_class AS object_class_6, t0.is_default AS is_default_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM Configuration t0 WHERE t0.`key` = ? AND t0.object_id = ? AND t0.object_class = ? LIMIT 1
Parameters:
[ "allow_financial_mpr" 2 "Consoneo\Bundle\UserBundle\Entity\Oblige" ] |
| 6 | 1.56 ms |
SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3, t0.`description` AS description_4, t0.object_id AS object_id_5, t0.object_class AS object_class_6, t0.is_default AS is_default_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM Configuration t0 WHERE t0.`key` = ? AND t0.object_id = ? AND t0.object_class = ? LIMIT 1
Parameters:
[ "sirene_api_enabled" 2 "Consoneo\Bundle\UserBundle\Entity\Oblige" ] |
| 7 | 3.45 ms |
SELECT i0_.id AS id_0, i0_.appKey AS appKey_1, i0_.label AS label_2, i0_.description AS description_3, i0_.url AS url_4, i0_.status AS status_5, i0_.created_at AS created_at_6, i0_.report_auto_email AS report_auto_email_7, i0_.logo AS logo_8, i0_.smartName AS smartName_9, i0_.prefixEmail AS prefixEmail_10, i0_.`lead` AS lead_11, i0_.`leadUrl` AS leadUrl_12, i0_.`leadLogin` AS leadLogin_13, i0_.`leadPassword` AS leadPassword_14, i0_.recommanderProDefault AS recommanderProDefault_15, i0_.actif AS actif_16, i0_.allowMultiSubscription AS allowMultiSubscription_17, i0_.teteReseau_id AS teteReseau_id_18, i0_.branding AS branding_19 FROM IntegrationModule i0_ WHERE i0_.branding = ? AND i0_.teteReseau_id = ? AND i0_.actif = ? LIMIT 1
Parameters:
[ "i" 2 1 ] |
| 8 | 0.87 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:
[
"1234"
]
|
| 9 | 0.69 ms |
SELECT t0.branding AS branding_1, t0.title AS title_2 FROM Branding t0 WHERE t0.branding = ? LIMIT 1
Parameters:
[
"i"
]
|
| 10 | 0.78 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:
[
"1234"
]
|
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\ObligeBundle\Entity\IntegrationModule | 3 |
| Consoneo\Bundle\WorkflowBundle\Entity\Branding | 2 |
| Consoneo\Bundle\ObligeBundle\Entity\Configuration | 2 |
| Consoneo\Bundle\UserBundle\Entity\TeteReseau | 1 |
| Consoneo\Bundle\UserBundle\Entity\Oblige | 1 |
| 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\ObligeBundle\Entity\Configuration | No errors. |
| Consoneo\Bundle\UserBundle\Entity\Oblige | No errors. |
| Consoneo\Bundle\ObligeBundle\Entity\OffreProjet | No errors. |
| Consoneo\Bundle\SimulateurBundle\Entity\ZoneClimatique | No errors. |
stats entity manager
No loaded entities.
qrdecode entity manager
| Class | Mapping errors |
|---|---|
| C2eCoreBundle\Entity\DocumentQrDecode | No errors. |