Symfony Profiler

Query Metrics

6 Database Queries

4 Different statements

4.34 ms Query time

2 Invalid entities

3 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.41 ms
(55.59%)

SELECT t0.id AS id_1, t0.business_name AS business_name_2, t0.address AS address_3, t0.address2 AS address2_4, t0.city AS city_5, t0.state AS state_6, t0.zip_code AS zip_code_7, t0.contact_name AS contact_name_8, t0.contact_phone AS contact_phone_9, t0.contact_email AS contact_email_10, t0.status AS status_11, t0.password AS password_12, t0.uuid AS uuid_13, t0.time_zone AS time_zone_14, t0.logo AS logo_15, t0.logo_meta_data AS logo_meta_data_16, t0.acknowledge_correct_information_paragraph AS acknowledge_correct_information_paragraph_17, t0.refusal_of_treatment_paragraph AS refusal_of_treatment_paragraph_18, t0.acknowledge_witness_paragraph AS acknowledge_witness_paragraph_19 FROM business t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.business_name AS business_name_2,
  t0.address AS address_3,
  t0.address2 AS address2_4,
  t0.city AS city_5,
  t0.state AS state_6,
  t0.zip_code AS zip_code_7,
  t0.contact_name AS contact_name_8,
  t0.contact_phone AS contact_phone_9,
  t0.contact_email AS contact_email_10,
  t0.status AS status_11,
  t0.password AS password_12,
  t0.uuid AS uuid_13,
  t0.time_zone AS time_zone_14,
  t0.logo AS logo_15,
  t0.logo_meta_data AS logo_meta_data_16,
  t0.acknowledge_correct_information_paragraph AS acknowledge_correct_information_paragraph_17,
  t0.refusal_of_treatment_paragraph AS refusal_of_treatment_paragraph_18,
  t0.acknowledge_witness_paragraph AS acknowledge_witness_paragraph_19
FROM
  business t0
LIMIT
  1

SELECT t0.id AS id_1, t0.business_name AS business_name_2, t0.address AS address_3, t0.address2 AS address2_4, t0.city AS city_5, t0.state AS state_6, t0.zip_code AS zip_code_7, t0.contact_name AS contact_name_8, t0.contact_phone AS contact_phone_9, t0.contact_email AS contact_email_10, t0.status AS status_11, t0.password AS password_12, t0.uuid AS uuid_13, t0.time_zone AS time_zone_14, t0.logo AS logo_15, t0.logo_meta_data AS logo_meta_data_16, t0.acknowledge_correct_information_paragraph AS acknowledge_correct_information_paragraph_17, t0.refusal_of_treatment_paragraph AS refusal_of_treatment_paragraph_18, t0.acknowledge_witness_paragraph AS acknowledge_witness_paragraph_19 FROM business t0 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Service\RegistrationManager->checkRegistration (line 18)
5	App\Service\RegistrationManager->__construct (line 13)
6	Container4CQfmBM\getRegistrationManagerService->do (line 23)
7	Container4CQfmBM\App_KernelDevDebugContainer::load (line 602)
8	Container4CQfmBM\getSecurityControllerService->do (line 25)
9	Container4CQfmBM\App_KernelDevDebugContainer::load (line 602)
10	Symfony\Component\DependencyInjection\Container->make (line 229)
11	Symfony\Component\DependencyInjection\Container::get (line 211)
12	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 40)
13	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 26)
14	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 128)
15	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 96)
16	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 36)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 164)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 208)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

0.90 ms
(20.77%)

SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.email AS email_3, c0_.mobile AS mobile_4, c0_.status AS status_5, c0_.license AS license_6, c0_.license_expire_date AS license_expire_date_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.chart_id AS chart_id_10, c0_.created_by_id AS created_by_id_11, c0_.updated_by_id AS updated_by_id_12, c0_.staff_id AS staff_id_13 FROM chart_staff c0_ INNER JOIN chart c1_ ON (c0_.chart_id = c1_.id) WHERE c0_.staff_id = ? AND c1_.status = ? ORDER BY c0_.chart_id ASC

Parameters:

[
  null
  "Active"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.first_name AS first_name_1,
  c0_.last_name AS last_name_2,
  c0_.email AS email_3,
  c0_.mobile AS mobile_4,
  c0_.status AS status_5,
  c0_.license AS license_6,
  c0_.license_expire_date AS license_expire_date_7,
  c0_.created_at AS created_at_8,
  c0_.updated_at AS updated_at_9,
  c0_.chart_id AS chart_id_10,
  c0_.created_by_id AS created_by_id_11,
  c0_.updated_by_id AS updated_by_id_12,
  c0_.staff_id AS staff_id_13
FROM
  chart_staff c0_
  INNER JOIN chart c1_ ON (c0_.chart_id = c1_.id)
WHERE
  c0_.staff_id = ?
  AND c1_.status = ?
ORDER BY
  c0_.chart_id ASC

SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.email AS email_3, c0_.mobile AS mobile_4, c0_.status AS status_5, c0_.license AS license_6, c0_.license_expire_date AS license_expire_date_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.chart_id AS chart_id_10, c0_.created_by_id AS created_by_id_11, c0_.updated_by_id AS updated_by_id_12, c0_.staff_id AS staff_id_13 FROM chart_staff c0_ INNER JOIN chart c1_ ON (c0_.chart_id = c1_.id) WHERE c0_.staff_id = NULL AND c1_.status = 'Active' ORDER BY c0_.chart_id ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\ChartStaffRepository->findOpenChartsByOwner (line 224)
7	App\Controller\BaseController->__construct (line 77)
8	Container4CQfmBM\getSecurityControllerService->do (line 25)
9	Container4CQfmBM\App_KernelDevDebugContainer::load (line 602)
10	Symfony\Component\DependencyInjection\Container->make (line 229)
11	Symfony\Component\DependencyInjection\Container::get (line 211)
12	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 40)
13	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 26)
14	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 128)
15	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 96)
16	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 36)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 164)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 208)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

0.60 ms
(13.93%)

SELECT t0.id AS id_1, t0.business_name AS business_name_2, t0.address AS address_3, t0.address2 AS address2_4, t0.city AS city_5, t0.state AS state_6, t0.zip_code AS zip_code_7, t0.contact_name AS contact_name_8, t0.contact_phone AS contact_phone_9, t0.contact_email AS contact_email_10, t0.status AS status_11, t0.password AS password_12, t0.uuid AS uuid_13, t0.time_zone AS time_zone_14, t0.logo AS logo_15, t0.logo_meta_data AS logo_meta_data_16, t0.acknowledge_correct_information_paragraph AS acknowledge_correct_information_paragraph_17, t0.refusal_of_treatment_paragraph AS refusal_of_treatment_paragraph_18, t0.acknowledge_witness_paragraph AS acknowledge_witness_paragraph_19 FROM business t0 WHERE t0.status = ? LIMIT 1

Parameters:

[
  "Active"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.business_name AS business_name_2,
  t0.address AS address_3,
  t0.address2 AS address2_4,
  t0.city AS city_5,
  t0.state AS state_6,
  t0.zip_code AS zip_code_7,
  t0.contact_name AS contact_name_8,
  t0.contact_phone AS contact_phone_9,
  t0.contact_email AS contact_email_10,
  t0.status AS status_11,
  t0.password AS password_12,
  t0.uuid AS uuid_13,
  t0.time_zone AS time_zone_14,
  t0.logo AS logo_15,
  t0.logo_meta_data AS logo_meta_data_16,
  t0.acknowledge_correct_information_paragraph AS acknowledge_correct_information_paragraph_17,
  t0.refusal_of_treatment_paragraph AS refusal_of_treatment_paragraph_18,
  t0.acknowledge_witness_paragraph AS acknowledge_witness_paragraph_19
FROM
  business t0
WHERE
  t0.status = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.business_name AS business_name_2, t0.address AS address_3, t0.address2 AS address2_4, t0.city AS city_5, t0.state AS state_6, t0.zip_code AS zip_code_7, t0.contact_name AS contact_name_8, t0.contact_phone AS contact_phone_9, t0.contact_email AS contact_email_10, t0.status AS status_11, t0.password AS password_12, t0.uuid AS uuid_13, t0.time_zone AS time_zone_14, t0.logo AS logo_15, t0.logo_meta_data AS logo_meta_data_16, t0.acknowledge_correct_information_paragraph AS acknowledge_correct_information_paragraph_17, t0.refusal_of_treatment_paragraph AS refusal_of_treatment_paragraph_18, t0.acknowledge_witness_paragraph AS acknowledge_witness_paragraph_19 FROM business t0 WHERE t0.status = 'Active' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\ORM\EntityRepository->resolveMagicCall (line 235)
4	Doctrine\ORM\EntityRepository->__call (line 158)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->__call (line 95)
6	App\Service\BusinessManager->__construct (line 32)
7	Container4CQfmBM\getBusinessManagerService->do (line 23)
8	Container4CQfmBM\App_KernelDevDebugContainer::load (line 602)
9	Container4CQfmBM\getSecurityControllerService->do (line 25)
10	Container4CQfmBM\App_KernelDevDebugContainer::load (line 602)
11	Symfony\Component\DependencyInjection\Container->make (line 229)
12	Symfony\Component\DependencyInjection\Container::get (line 211)
13	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 40)
14	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 26)
15	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 128)
16	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 96)
17	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 36)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 164)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 208)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 29)
23	require_once (line 5)

0.42 ms
(9.71%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.is_verified AS is_verified_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.status AS status_9, t0.license_active_date AS license_active_date_10, t0.license_renewal_date AS license_renewal_date_11, t0.photo_url AS photo_url_12, t0.business_id AS business_id_13, t0.license_id AS license_id_14 FROM staff t0 WHERE t0.status = ? LIMIT 1

Parameters:

[
  "Active"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.email AS email_5,
  t0.is_verified AS is_verified_6,
  t0.first_name AS first_name_7,
  t0.last_name AS last_name_8,
  t0.status AS status_9,
  t0.license_active_date AS license_active_date_10,
  t0.license_renewal_date AS license_renewal_date_11,
  t0.photo_url AS photo_url_12,
  t0.business_id AS business_id_13,
  t0.license_id AS license_id_14
FROM
  staff t0
WHERE
  t0.status = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.is_verified AS is_verified_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.status AS status_9, t0.license_active_date AS license_active_date_10, t0.license_renewal_date AS license_renewal_date_11, t0.photo_url AS photo_url_12, t0.business_id AS business_id_13, t0.license_id AS license_id_14 FROM staff t0 WHERE t0.status = 'Active' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\ORM\EntityRepository->resolveMagicCall (line 235)
4	Doctrine\ORM\EntityRepository->__call (line 158)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->__call (line 95)
6	App\Service\BusinessManager->checkUser (line 45)
7	App\Service\BusinessManager->__construct (line 37)
8	Container4CQfmBM\getBusinessManagerService->do (line 23)
9	Container4CQfmBM\App_KernelDevDebugContainer::load (line 602)
10	Container4CQfmBM\getSecurityControllerService->do (line 25)
11	Container4CQfmBM\App_KernelDevDebugContainer::load (line 602)
12	Symfony\Component\DependencyInjection\Container->make (line 229)
13	Symfony\Component\DependencyInjection\Container::get (line 211)
14	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 40)
15	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 26)
16	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 128)
17	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 96)
18	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 36)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 164)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 208)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	require_once (line 5)

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\Entity\Business	1
App\Entity\Staff	1
App\Entity\License	1

Entities Mapping

Class	Mapping errors
App\Entity\Business	No errors.
App\Entity\Location	No errors.
App\Entity\Staff	No errors.
App\Entity\License	No errors.
App\Entity\Team	The field App\Entity\Team#teamEventRoleRequirements is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\TeamEventRoleRequirement#team does not contain the required 'inversedBy: "teamEventRoleRequirements"' attribute.
App\Entity\ChartStaff	No errors.
App\Entity\LoginHistory	No errors.
App\Entity\ChartApprovalHistory	No errors.
App\Entity\Chart	The mappings App\Entity\Chart#chartPatient and App\Entity\ChartPatient#chart are inconsistent with each other.

Symfony Profiler

GET https://gerald.eventemscharts.com/login

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping