Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

1.68 ms Query time

0 Invalid entities

5 Managed entities

Queries

Group similar statements

#▲	Time	Info
1	1.68 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.setting_group AS setting_group_4, t0.type AS type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM setting t0 WHERE t0.setting_group = ? Parameters: [`0`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.setting_group AS setting_group_4, t0.type AS type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM setting t0 WHERE t0.setting_group = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.setting_group AS setting_group_4, t0.type AS type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM setting t0 WHERE t0.setting_group = 0;

#▲

Time

Info

1.68 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.setting_group AS setting_group_4, t0.type AS type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM setting t0 WHERE t0.setting_group = ?

Parameters:

[
  0
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.setting_group AS setting_group_4,
  t0.type AS type_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7
FROM
  setting t0
WHERE
  t0.setting_group = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.setting_group AS setting_group_4, t0.type AS type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM setting t0 WHERE t0.setting_group = 0;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Bundles\SettingsBundle\Entity\Setting	5

Entities Mapping

Class	Mapping errors
App\Bundles\SettingsBundle\Entity\Setting	No errors.
App\Bundles\OTPBundle\Entity\OTPCode	No errors.
App\Bundles\LocationBundle\Entity\LocationImportFile	No errors.
App\Bundles\LocationBundle\Entity\LocationShape	No errors.
App\Bundles\LocationBundle\Entity\BaseLocation	No errors.
App\Bundles\LocationBundle\Entity\Location	No errors.
App\Bundles\LocationBundle\Entity\LocationStreet	No errors.
App\Bundles\LocationBundle\Entity\LocationCoordinate	No errors.
App\Bundles\LocationBundle\Entity\LocationStreetNumber	No errors.
App\Bundles\LocationBundle\Entity\LocationCenter	No errors.
App\Bundles\LocationBundle\Entity\LocationPoint	No errors.
App\Bundles\LocationBundle\Entity\LocationHistory	No errors.
App\Bundles\LocationBundle\Entity\ImportedLocation	No errors.
App\Bundles\UserBundle\Entity\User	No errors.
App\Bundles\UserBundle\Entity\UserFilters	No errors.
App\Bundles\UserBundle\Entity\PasswordHistoryRecord	No errors.
App\Bundles\UserBundle\Entity\UserTrial	No errors.
App\Bundles\UserBundle\Entity\Role	No errors.
App\Bundles\UserBundle\Entity\Permission	No errors.
App\Bundles\UserBundle\Entity\UserReport	No errors.
App\Bundles\UserBundle\Entity\LoginLink	No errors.
App\Bundles\AuditBundle\Entity\AuditLogEntry	No errors.
App\Bundles\AuditBundle\Entity\SessionAuditEntry	No errors.
App\Bundles\OrganizationBundle\Entity\Department	No errors.
App\Bundles\OrganizationBundle\Entity\UserOrganizationApiKey	No errors.
App\Bundles\OrganizationBundle\Entity\Organization	No errors.
App\Bundles\OrganizationBundle\Entity\OrganizationResponsibleLocation	No errors.
App\Bundles\OrganizationBundle\Entity\UserOrganization	No errors.
App\Bundles\CatalogBundle\Entity\Catalog	No errors.
App\Bundles\CatalogBundle\Entity\CatalogItem	No errors.
App\Bundles\DiagnosisBundle\Entity\DiagnosisCode	No errors.
App\Bundles\DiagnosisBundle\Entity\Diagnosis	No errors.
App\Bundles\DiagnosisBundle\Entity\Field	No errors.
App\Bundles\DiagnosisBundle\Entity\Section	No errors.
App\Bundles\OutbreakBundle\Entity\Outbreak	No errors.
App\Bundles\PatientBundle\Entity\PatientAddress	No errors.
App\Bundles\PatientBundle\Entity\Patient	No errors.
App\Bundles\DiseaseCaseBundle\Entity\BaseDiseaseCaseTest	No errors.
App\Bundles\DiseaseCaseBundle\Entity\TransferDiseaseCase	No errors.
App\Bundles\DiseaseCaseBundle\Entity\ExpiredDiseaseCaseNotification	No errors.
App\Bundles\DiseaseCaseBundle\Entity\ContactDiseaseCaseTest	No errors.
App\Bundles\DiseaseCaseBundle\Entity\DiseaseCase	No errors.
App\Bundles\DiseaseCaseBundle\Entity\DiseaseCaseContact	No errors.
App\Bundles\DiseaseCaseBundle\Entity\DiseaseCaseFieldValue	No errors.
App\Bundles\DiseaseCaseBundle\Entity\DiseaseCaseTest	No errors.
App\Bundles\DiseaseCaseBundle\Entity\ShareDiseaseCase	No errors.
App\Bundles\ReportBundle\Entity\ReportRow	No errors.
App\Bundles\ReportBundle\Entity\ReportSetting	No errors.
App\Bundles\ReportBundle\Entity\ReportTemplate	No errors.
App\Bundles\ReportBundle\Entity\Report	No errors.
App\Bundles\TemplateBundle\Entity\Template	No errors.
App\Bundles\ProfessionalCaseBundle\Entity\NACE	No errors.
App\Bundles\ProfessionalCaseBundle\Entity\Diagnosis	No errors.
App\Bundles\ProfessionalCaseBundle\Entity\ProfessionalCase	No errors.
App\Bundles\ProfessionalCaseBundle\Entity\Factor	No errors.
App\Bundles\ProfessionalCaseBundle\Entity\Subfactor	No errors.
App\Bundles\ProfessionalCaseBundle\Entity\ProfessionalCaseIllness	No errors.
App\Bundles\ProfessionalCaseBundle\Entity\ProfessionalCase\ProfessionalCaseDiagnosisFactorSubfactor	No errors.
App\Bundles\ProfessionalCaseBundle\Entity\ProfessionalCase\ProfessionalCaseDiagnosisFactor	No errors.
App\Bundles\ProfessionalCaseBundle\Entity\ProfessionalCase\ProfessionalCaseDiagnosis	No errors.
App\Bundles\PopulationBundle\Entity\HistoricalStatisticCatalog	No errors.
App\Bundles\PopulationBundle\Entity\PopulationListItem	No errors.
App\Bundles\PopulationBundle\Entity\HistoricalStatisticCatalogItem	No errors.
App\Bundles\PopulationBundle\Entity\PopulationList	No errors.
App\Bundles\PopulationBundle\Entity\PopulationItemValue	No errors.
App\Bundles\EpidemiologicalSurveillanceBundle\Entity\SurveillanceWeekValue	No errors.
App\Bundles\EpidemiologicalSurveillanceBundle\Entity\HospitalActivityScheduler	No errors.
App\Bundles\EpidemiologicalSurveillanceBundle\Entity\SurveillanceTemplateComponent	No errors.
App\Bundles\EpidemiologicalSurveillanceBundle\Entity\SurveillanceTemplate	No errors.
App\Bundles\EpidemiologicalSurveillanceBundle\Entity\SurveillanceCase	No errors.
App\Bundles\EpidemiologicalSurveillanceBundle\Entity\SurveillanceWeek	No errors.
App\Bundles\EpidemiologicalSurveillanceBundle\Entity\Hospital	No errors.
App\Bundles\EpidemiologicalSurveillanceBundle\Entity\SurveillanceVaccinationWeek	No errors.
App\Bundles\AnalyticBundle\Entity\ReindexRequest	No errors.
App\Bundles\AntibioticResistanceBundle\Entity\Pathogen	No errors.
App\Bundles\AntibioticResistanceBundle\Entity\Patient\AntibioticPatient	No errors.
App\Bundles\AntibioticResistanceBundle\Entity\InfectionControl\InfectionControl	No errors.
App\Bundles\AntibioticResistanceBundle\Entity\InfectionControl\InfectionControlTracheostomy	No errors.
App\Bundles\AntibioticResistanceBundle\Entity\InfectionControl\InfectionControlObservation	No errors.
App\Bundles\AntibioticResistanceBundle\Entity\InfectionControl\InfectionControlIohvTherapy	No errors.
App\Bundles\AntibioticResistanceBundle\Entity\InfectionControl\InfectionControlCase	No errors.
App\Bundles\AntibioticResistanceBundle\Entity\InfectionControl\InfectionControlExperiment	No errors.
App\Bundles\AntibioticResistanceBundle\Entity\InfectionControl\InfectionControlBlock	No errors.
App\Bundles\AntibioticResistanceBundle\Entity\InfectionControl\Block\InfectionControlAbstractBlock	No errors.
App\Bundles\AntibioticResistanceBundle\Entity\InfectionControl\Block\InfectionControlIohv	No errors.
App\Bundles\AntibioticResistanceBundle\Entity\InfectionControl\Block\InfectionControlKaisvsh	No errors.
App\Bundles\AntibioticResistanceBundle\Entity\InfectionControl\Block\InfectionControlVap	No errors.
App\Bundles\AntibioticResistanceBundle\Entity\InfectionControl\Block\InfectionControlKaik	No errors.
App\Bundles\AntibioticResistanceBundle\Entity\InfectionControl\Block\InfectionControlKaikc	No errors.
App\Bundles\AntibioticResistanceBundle\Entity\Diagnosis	No errors.
App\Bundles\AntibioticResistanceBundle\Entity\Antibiotic	No errors.
App\Bundles\AntibioticResistanceBundle\Entity\Bacteriological\BacteriologicalExperiment	No errors.
App\Bundles\AntibioticResistanceBundle\Entity\Bacteriological\BacteriologicalExperimentPathogen	No errors.
App\Bundles\AntibioticResistanceBundle\Entity\Bacteriological\BacteriologicalExperimentItem	No errors.
App\Bundles\SyndromicSurveillanceBundle\Entity\SyndromicSignal	No errors.
App\Bundles\SyndromicSurveillanceBundle\Entity\SyndromicDiagnosisGroup	No errors.
App\Bundles\SyndromicSurveillanceBundle\Entity\SyndromicEstablishment	No errors.
App\Bundles\SyndromicSurveillanceBundle\Entity\SyndromicCaseDiagnosisMatch	No errors.
App\Bundles\SyndromicSurveillanceBundle\Entity\SyndromicBasicLevel	No errors.
App\Bundles\SyndromicSurveillanceBundle\Entity\SyndromicDiagnosis	No errors.
App\Bundles\SyndromicSurveillanceBundle\Entity\SyndromicTemplateReport	No errors.
App\Bundles\SyndromicSurveillanceBundle\Entity\SyndromicTemplateComponent	No errors.
App\Bundles\SyndromicSurveillanceBundle\Entity\SyndromicCase	No errors.
App\Bundles\SyndromicSurveillanceBundle\Entity\SyndromicTemplate	No errors.
App\Bundles\SyndromicSurveillanceBundle\Entity\Syndromic	No errors.
App\Bundles\SyndromicSurveillanceBundle\Entity\SyndromicImport	No errors.
App\Bundles\SyndromicSurveillanceBundle\Entity\SyndromicNotification	No errors.
App\Bundles\CommandHistoryBundle\Entity\CommandHistory	No errors.
App\Bundles\LaboratoryBundle\Entity\LaboratoryRequest	No errors.
App\Bundles\MediaBundle\Entity\File	No errors.
App\Bundles\ExportBundle\Entity\ExportFile	No errors.

Symfony Profiler

GET https://cct.devprove.com/password/forgot

Configuration Settings

Theme

Page Width