Symfony Profiler

Query Metrics

14 Database Queries

4 Different statements

7.02 ms Query time

0 Invalid entities

29 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.77 ms
(39.37%)

SELECT t0.connection_type AS connection_type_1, t0.from_email AS from_email_2, t0.from_name AS from_name_3, t0.smtp_host AS smtp_host_4, t0.smtp_port AS smtp_port_5, t0.smtp_username AS smtp_username_6, t0.smtp_password_encrypted AS smtp_password_encrypted_7, t0.smtp_encryption AS smtp_encryption_8, t0.oauth_access_token_encrypted AS oauth_access_token_encrypted_9, t0.oauth_refresh_token_encrypted AS oauth_refresh_token_encrypted_10, t0.oauth_token_expiry AS oauth_token_expiry_11, t0.oauth_microsoft_id AS oauth_microsoft_id_12, t0.status AS status_13, t0.last_tested AS last_tested_14, t0.last_test_error AS last_test_error_15, t0.id AS id_16, t0.uuid AS uuid_17, t0.created AS created_18, t0.modified AS modified_19, t0.user_id AS user_id_20 FROM mail_account t0 WHERE t0.user_id = ?

Parameters:

[
  17
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.connection_type AS connection_type_1,
  t0.from_email AS from_email_2,
  t0.from_name AS from_name_3,
  t0.smtp_host AS smtp_host_4,
  t0.smtp_port AS smtp_port_5,
  t0.smtp_username AS smtp_username_6,
  t0.smtp_password_encrypted AS smtp_password_encrypted_7,
  t0.smtp_encryption AS smtp_encryption_8,
  t0.oauth_access_token_encrypted AS oauth_access_token_encrypted_9,
  t0.oauth_refresh_token_encrypted AS oauth_refresh_token_encrypted_10,
  t0.oauth_token_expiry AS oauth_token_expiry_11,
  t0.oauth_microsoft_id AS oauth_microsoft_id_12,
  t0.status AS status_13,
  t0.last_tested AS last_tested_14,
  t0.last_test_error AS last_test_error_15,
  t0.id AS id_16,
  t0.uuid AS uuid_17,
  t0.created AS created_18,
  t0.modified AS modified_19,
  t0.user_id AS user_id_20
FROM
  mail_account t0
WHERE
  t0.user_id = ?

SELECT t0.connection_type AS connection_type_1, t0.from_email AS from_email_2, t0.from_name AS from_name_3, t0.smtp_host AS smtp_host_4, t0.smtp_port AS smtp_port_5, t0.smtp_username AS smtp_username_6, t0.smtp_password_encrypted AS smtp_password_encrypted_7, t0.smtp_encryption AS smtp_encryption_8, t0.oauth_access_token_encrypted AS oauth_access_token_encrypted_9, t0.oauth_refresh_token_encrypted AS oauth_refresh_token_encrypted_10, t0.oauth_token_expiry AS oauth_token_expiry_11, t0.oauth_microsoft_id AS oauth_microsoft_id_12, t0.status AS status_13, t0.last_tested AS last_tested_14, t0.last_test_error AS last_test_error_15, t0.id AS id_16, t0.uuid AS uuid_17, t0.created AS created_18, t0.modified AS modified_19, t0.user_id AS user_id_20 FROM mail_account t0 WHERE t0.user_id = 17;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 837)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2458)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 495)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
9	Doctrine\ORM\AbstractQuery->execute (line 886)
10	Doctrine\ORM\AbstractQuery->getResult (line 688)
11	WelshDev\Doctrix\BaseRepository->fetch (line 84)
12	App\Twig\AppExtension->getGlobals (line 20)
13	Twig\ExtensionSet->getGlobals (line 365)
14	Twig\Environment->getGlobals (line 908)
15	Twig\Template->yield (line 398)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
23	App\Controller\App\Auth\AuthController->login (line 50)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 193)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 11)

2.26 ms
(32.22%)

SELECT t0.oauth_access_token_encrypted AS oauth_access_token_encrypted_1, t0.oauth_refresh_token_encrypted AS oauth_refresh_token_encrypted_2, t0.oauth_token_expiry AS oauth_token_expiry_3, t0.calendly_user_uri AS calendly_user_uri_4, t0.calendly_organization_uri AS calendly_organization_uri_5, t0.account_email AS account_email_6, t0.account_name AS account_name_7, t0.status AS status_8, t0.last_synced AS last_synced_9, t0.last_error AS last_error_10, t0.id AS id_11, t0.uuid AS uuid_12, t0.created AS created_13, t0.modified AS modified_14, t0.user_id AS user_id_15 FROM calendar_calendly_integration t0 WHERE t0.user_id = ?

Parameters:

[
  17
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.oauth_access_token_encrypted AS oauth_access_token_encrypted_1,
  t0.oauth_refresh_token_encrypted AS oauth_refresh_token_encrypted_2,
  t0.oauth_token_expiry AS oauth_token_expiry_3,
  t0.calendly_user_uri AS calendly_user_uri_4,
  t0.calendly_organization_uri AS calendly_organization_uri_5,
  t0.account_email AS account_email_6,
  t0.account_name AS account_name_7,
  t0.status AS status_8,
  t0.last_synced AS last_synced_9,
  t0.last_error AS last_error_10,
  t0.id AS id_11,
  t0.uuid AS uuid_12,
  t0.created AS created_13,
  t0.modified AS modified_14,
  t0.user_id AS user_id_15
FROM
  calendar_calendly_integration t0
WHERE
  t0.user_id = ?

SELECT t0.oauth_access_token_encrypted AS oauth_access_token_encrypted_1, t0.oauth_refresh_token_encrypted AS oauth_refresh_token_encrypted_2, t0.oauth_token_expiry AS oauth_token_expiry_3, t0.calendly_user_uri AS calendly_user_uri_4, t0.calendly_organization_uri AS calendly_organization_uri_5, t0.account_email AS account_email_6, t0.account_name AS account_name_7, t0.status AS status_8, t0.last_synced AS last_synced_9, t0.last_error AS last_error_10, t0.id AS id_11, t0.uuid AS uuid_12, t0.created AS created_13, t0.modified AS modified_14, t0.user_id AS user_id_15 FROM calendar_calendly_integration t0 WHERE t0.user_id = 17;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 837)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2458)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 495)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
9	Doctrine\ORM\AbstractQuery->execute (line 886)
10	Doctrine\ORM\AbstractQuery->getResult (line 688)
11	WelshDev\Doctrix\BaseRepository->fetch (line 84)
12	App\Twig\AppExtension->getGlobals (line 20)
13	Twig\ExtensionSet->getGlobals (line 365)
14	Twig\Environment->getGlobals (line 908)
15	Twig\Template->yield (line 398)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
23	App\Controller\App\Auth\AuthController->login (line 50)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 193)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 11)

1.00 ms
(14.25%)

SELECT s0_.identifier AS identifier_0, s0_.value AS value_1, s0_.id AS id_2, s0_.uuid AS uuid_3, s0_.created AS created_4, s0_.modified AS modified_5 FROM system_config s0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.identifier AS identifier_0,
  s0_.value AS value_1,
  s0_.id AS id_2,
  s0_.uuid AS uuid_3,
  s0_.created AS created_4,
  s0_.modified AS modified_5
FROM
  system_config s0_

SELECT s0_.identifier AS identifier_0, s0_.value AS value_1, s0_.id AS id_2, s0_.uuid AS uuid_3, s0_.created AS created_4, s0_.modified AS modified_5 FROM system_config s0_;

#	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	WelshDev\Doctrix\BaseRepository->fetch (line 84)
7	App\Helper\ConfigHelper->__construct (line 23)
8	ContainerGsgStb6\getConfigHelperService->do (line 29)
9	ContainerGsgStb6\App_KernelDevDebugContainer::load (line 635)
10	ContainerGsgStb6\getTraditionalLoginAuthenticatorService->do (line 29)
11	ContainerGsgStb6\App_KernelDevDebugContainer::load (line 635)
12	ContainerGsgStb6\getSecurity_Firewall_Map_Context_AppService->do (line 36)
13	ContainerGsgStb6\App_KernelDevDebugContainer::load (line 635)
14	Symfony\Component\DependencyInjection\Container->getService (line 399)
15	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 36)
16	Symfony\Bundle\SecurityBundle\Security\FirewallMap->getFirewallContext (line 66)
17	Symfony\Bundle\SecurityBundle\Security\FirewallMap->getFirewallConfig (line 46)
18	Symfony\Bundle\SecurityBundle\EventListener\FirewallListener->configureLogoutUrlGenerator (line 42)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 11)

0.99 ms
(14.16%)

SELECT u0_.name AS name_0, u0_.email AS email_1, u0_.password AS password_2, u0_.last_active AS last_active_3, u0_.avatar AS avatar_4, u0_.archived AS archived_5, u0_.sidebar_collapsed AS sidebar_collapsed_6, u0_.microsoft_id AS microsoft_id_7, u0_.nickname AS nickname_8, u0_.email_notifications_enabled AS email_notifications_enabled_9, u0_.traditional_login_enabled AS traditional_login_enabled_10, u0_.id AS id_11, u0_.uuid AS uuid_12, u0_.created AS created_13, u0_.modified AS modified_14, u0_.role_id AS role_id_15, u0_.location_id AS location_id_16 FROM users_user u0_ LEFT JOIN users_role u1_ ON u0_.role_id = u1_.id WHERE u0_.archived IS NULL AND u0_.archived IS NULL ORDER BY u0_.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.name AS name_0,
  u0_.email AS email_1,
  u0_.password AS password_2,
  u0_.last_active AS last_active_3,
  u0_.avatar AS avatar_4,
  u0_.archived AS archived_5,
  u0_.sidebar_collapsed AS sidebar_collapsed_6,
  u0_.microsoft_id AS microsoft_id_7,
  u0_.nickname AS nickname_8,
  u0_.email_notifications_enabled AS email_notifications_enabled_9,
  u0_.traditional_login_enabled AS traditional_login_enabled_10,
  u0_.id AS id_11,
  u0_.uuid AS uuid_12,
  u0_.created AS created_13,
  u0_.modified AS modified_14,
  u0_.role_id AS role_id_15,
  u0_.location_id AS location_id_16
FROM
  users_user u0_
  LEFT JOIN users_role u1_ ON u0_.role_id = u1_.id
WHERE
  u0_.archived IS NULL
  AND u0_.archived IS NULL
ORDER BY
  u0_.name ASC

SELECT u0_.name AS name_0, u0_.email AS email_1, u0_.password AS password_2, u0_.last_active AS last_active_3, u0_.avatar AS avatar_4, u0_.archived AS archived_5, u0_.sidebar_collapsed AS sidebar_collapsed_6, u0_.microsoft_id AS microsoft_id_7, u0_.nickname AS nickname_8, u0_.email_notifications_enabled AS email_notifications_enabled_9, u0_.traditional_login_enabled AS traditional_login_enabled_10, u0_.id AS id_11, u0_.uuid AS uuid_12, u0_.created AS created_13, u0_.modified AS modified_14, u0_.role_id AS role_id_15, u0_.location_id AS location_id_16 FROM users_user u0_ LEFT JOIN users_role u1_ ON u0_.role_id = u1_.id WHERE u0_.archived IS NULL AND u0_.archived IS NULL ORDER BY u0_.name 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	WelshDev\Doctrix\BaseRepository->fetch (line 84)
7	App\Twig\AppExtension->getGlobals (line 20)
8	Twig\ExtensionSet->getGlobals (line 365)
9	Twig\Environment->getGlobals (line 908)
10	Twig\Template->yield (line 398)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
18	App\Controller\App\Auth\AuthController->login (line 50)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 193)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	require_once (line 11)

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\System\Config\Config	21
App\Entity\Users\User	6
App\Entity\Users\Role	1
App\Entity\Locations\Location	1

Entities Mapping

Class	Mapping errors
App\Entity\System\Config\Config	No errors.
App\Entity\Users\User	No errors.
App\Entity\Users\Role	No errors.
App\Entity\Locations\Location	No errors.
App\Entity\Notifications\Notification	No errors.
App\Entity\Cases\CaseSubscription	No errors.
App\Entity\Mail\MailAccount	No errors.
App\Entity\Calendar\CalendlyIntegration	No errors.

Symfony Profiler

GET https://hudsonrose.cwd-mm.com/app/login

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping