Symfony Profiler

Query Metrics

6 Database Queries

3 Different statements

7.65 ms Query time

0 Invalid entities

36 Managed entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

4.47 ms
(58.40%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.is_active AS is_active_4, t0.created_at AS created_at_5, t0.created_by AS created_by_6, t0.updated_at AS updated_at_7, t0.updated_by AS updated_by_8, t0.deleted_at AS deleted_at_9, t0.deleted_by AS deleted_by_10, t0.group_id AS group_id_11, t0.group_label AS group_label_12, t0.label AS label_13, t0.route AS route_14, t0.icon AS icon_15 FROM permission t0 WHERE t0.deleted_at IS NULL AND t0.group_label = ?

Parameters:

[
  "companies"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.is_active AS is_active_4,
  t0.created_at AS created_at_5,
  t0.created_by AS created_by_6,
  t0.updated_at AS updated_at_7,
  t0.updated_by AS updated_by_8,
  t0.deleted_at AS deleted_at_9,
  t0.deleted_by AS deleted_by_10,
  t0.group_id AS group_id_11,
  t0.group_label AS group_label_12,
  t0.label AS label_13,
  t0.route AS route_14,
  t0.icon AS icon_15
FROM
  permission t0
WHERE
  t0.deleted_at IS NULL
  AND t0.group_label = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.is_active AS is_active_4, t0.created_at AS created_at_5, t0.created_by AS created_by_6, t0.updated_at AS updated_at_7, t0.updated_by AS updated_by_8, t0.deleted_at AS deleted_at_9, t0.deleted_by AS deleted_by_10, t0.group_id AS group_id_11, t0.group_label AS group_label_12, t0.label AS label_13, t0.route AS route_14, t0.icon AS icon_15 FROM permission t0 WHERE t0.deleted_at IS NULL AND t0.group_label = 'companies';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 948)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 18)
5	App\Service\SidebarService->getSidebarData (line 21)
6	App\Twig\MenuExtension->getGlobals (line 359)
7	Twig\ExtensionSet->getGlobals (line 900)
8	Twig\Environment->getGlobals (line 398)
9	Twig\Template->yield (line 358)
10	Twig\Template->display (line 373)
11	Twig\Template->render (line 51)
12	Twig\TemplateWrapper->render (line 333)
13	Twig\Environment->render (line 431)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 123)
17	App\Controller\SecurityController->tenantLookup (line 51)
18	App\Controller\SecurityController->login (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

1.88 ms
(24.61%)

SELECT COUNT(*) FROM language t0 WHERE t0.deleted_at IS NULL AND t0.is_active = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  language t0
WHERE
  t0.deleted_at IS NULL
  AND t0.is_active = ?

SELECT COUNT(*) FROM language t0 WHERE t0.deleted_at IS NULL AND t0.is_active = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 875)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->count (line 140)
3	Doctrine\ORM\EntityRepository->count (line 87)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->count (line 29)
5	App\Twig\LanguageExtension->getGlobals (line 359)
6	Twig\ExtensionSet->getGlobals (line 900)
7	Twig\Environment->getGlobals (line 398)
8	Twig\Template->yield (line 358)
9	Twig\Template->display (line 373)
10	Twig\Template->render (line 51)
11	Twig\TemplateWrapper->render (line 333)
12	Twig\Environment->render (line 431)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 123)
16	App\Controller\SecurityController->tenantLookup (line 51)
17	App\Controller\SecurityController->login (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

1.30 ms
(16.99%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_active AS is_active_4, t0.created_at AS created_at_5, t0.created_by AS created_by_6, t0.updated_at AS updated_at_7, t0.updated_by AS updated_by_8, t0.deleted_at AS deleted_at_9, t0.deleted_by AS deleted_by_10, t0.label AS label_11 FROM language t0 WHERE t0.deleted_at IS NULL AND t0.is_active = ? ORDER BY t0.name ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.is_active AS is_active_4,
  t0.created_at AS created_at_5,
  t0.created_by AS created_by_6,
  t0.updated_at AS updated_at_7,
  t0.updated_by AS updated_by_8,
  t0.deleted_at AS deleted_at_9,
  t0.deleted_by AS deleted_by_10,
  t0.label AS label_11
FROM
  language t0
WHERE
  t0.deleted_at IS NULL
  AND t0.is_active = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_active AS is_active_4, t0.created_at AS created_at_5, t0.created_by AS created_by_6, t0.updated_at AS updated_at_7, t0.updated_by AS updated_by_8, t0.deleted_at AS deleted_at_9, t0.deleted_by AS deleted_by_10, t0.label AS label_11 FROM language t0 WHERE t0.deleted_at IS NULL AND t0.is_active = 1 ORDER BY t0.name ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 948)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 30)
5	App\Twig\LanguageExtension->getGlobals (line 359)
6	Twig\ExtensionSet->getGlobals (line 900)
7	Twig\Environment->getGlobals (line 398)
8	Twig\Template->yield (line 358)
9	Twig\Template->display (line 373)
10	Twig\Template->render (line 51)
11	Twig\TemplateWrapper->render (line 333)
12	Twig\Environment->render (line 431)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 123)
16	App\Controller\SecurityController->tenantLookup (line 51)
17	App\Controller\SecurityController->login (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
master	doctrine.dbal.master_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
master	doctrine.orm.master_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Permission	32
App\Entity\Language	4

master entity manager

Class	Amount of managed objects

Entities Mapping

default entity manager

Class	Mapping errors
App\Entity\Language	No errors.
App\Entity\User	No errors.
App\Entity\EmailTemplateTranslation	No errors.
App\Entity\ClientContact	No errors.
App\Entity\LanguageTranslations	No errors.
App\Entity\Permission	No errors.
App\Entity\RolePermission	No errors.
App\Entity\PermissionTranslations	No errors.

master entity manager

No loaded entities.

Symfony Profiler

GET https://staging.twensofund.nl/login

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

master entity manager

Entities Mapping

default entity manager

master entity manager