Symfony Profiler

Query Metrics

2 Database Queries

1 Different statements

8.58 ms Query time

0 Invalid entities

9 Managed entities

Queries

Group similar statements

#▲

Time

Info

6.17 ms

SELECT c0_.id AS id_0, c0_.hash AS hash_1, c0_.created_date AS created_date_2, c0_.updated_date AS updated_date_3, c0_.deleted AS deleted_4, c0_.enabled AS enabled_5, c0_.name AS name_6, c0_.slug AS slug_7, c0_.description AS description_8, c0_.logo AS logo_9, c0_.background_colour AS background_colour_10, c0_.text_colour AS text_colour_11, c0_.highlight_colour AS highlight_colour_12, c0_.settings AS settings_13, c0_.client_id AS client_id_14 FROM clients c0_ WHERE c0_.deleted = 0 AND c0_.enabled = 1 ORDER BY c0_.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.hash AS hash_1,
  c0_.created_date AS created_date_2,
  c0_.updated_date AS updated_date_3,
  c0_.deleted AS deleted_4,
  c0_.enabled AS enabled_5,
  c0_.name AS name_6,
  c0_.slug AS slug_7,
  c0_.description AS description_8,
  c0_.logo AS logo_9,
  c0_.background_colour AS background_colour_10,
  c0_.text_colour AS text_colour_11,
  c0_.highlight_colour AS highlight_colour_12,
  c0_.settings AS settings_13,
  c0_.client_id AS client_id_14
FROM
  clients c0_
WHERE
  c0_.deleted = 0
  AND c0_.enabled = 1
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.hash AS hash_1, c0_.created_date AS created_date_2, c0_.updated_date AS updated_date_3, c0_.deleted AS deleted_4, c0_.enabled AS enabled_5, c0_.name AS name_6, c0_.slug AS slug_7, c0_.description AS description_8, c0_.logo AS logo_9, c0_.background_colour AS background_colour_10, c0_.text_colour AS text_colour_11, c0_.highlight_colour AS highlight_colour_12, c0_.settings AS settings_13, c0_.client_id AS client_id_14 FROM clients c0_ WHERE c0_.deleted = 0 AND c0_.enabled = 1 ORDER BY c0_.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 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Repository\ClientRepository->findAllActive (line 23)
7	App\Services\ClientService->getAllClients (line 66)
8	App\Twig\ClientExtension->getGlobals (line 31)
9	Twig\ExtensionSet->getGlobals (line 359)
10	Twig\Environment->getGlobals (line 900)
11	Twig\Template->yield (line 398)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 373)
14	Twig\TemplateWrapper->render (line 51)
15	Twig\Environment->render (line 333)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
19	App\Controller\HomePageController->index (line 14)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 182)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 5)

2.42 ms

SELECT c0_.id AS id_0, c0_.hash AS hash_1, c0_.created_date AS created_date_2, c0_.updated_date AS updated_date_3, c0_.deleted AS deleted_4, c0_.enabled AS enabled_5, c0_.name AS name_6, c0_.slug AS slug_7, c0_.description AS description_8, c0_.logo AS logo_9, c0_.background_colour AS background_colour_10, c0_.text_colour AS text_colour_11, c0_.highlight_colour AS highlight_colour_12, c0_.settings AS settings_13, c0_.client_id AS client_id_14 FROM clients c0_ WHERE c0_.deleted = 0 AND c0_.enabled = 1 ORDER BY c0_.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.hash AS hash_1,
  c0_.created_date AS created_date_2,
  c0_.updated_date AS updated_date_3,
  c0_.deleted AS deleted_4,
  c0_.enabled AS enabled_5,
  c0_.name AS name_6,
  c0_.slug AS slug_7,
  c0_.description AS description_8,
  c0_.logo AS logo_9,
  c0_.background_colour AS background_colour_10,
  c0_.text_colour AS text_colour_11,
  c0_.highlight_colour AS highlight_colour_12,
  c0_.settings AS settings_13,
  c0_.client_id AS client_id_14
FROM
  clients c0_
WHERE
  c0_.deleted = 0
  AND c0_.enabled = 1
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.hash AS hash_1, c0_.created_date AS created_date_2, c0_.updated_date AS updated_date_3, c0_.deleted AS deleted_4, c0_.enabled AS enabled_5, c0_.name AS name_6, c0_.slug AS slug_7, c0_.description AS description_8, c0_.logo AS logo_9, c0_.background_colour AS background_colour_10, c0_.text_colour AS text_colour_11, c0_.highlight_colour AS highlight_colour_12, c0_.settings AS settings_13, c0_.client_id AS client_id_14 FROM clients c0_ WHERE c0_.deleted = 0 AND c0_.enabled = 1 ORDER BY c0_.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 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Repository\ClientRepository->findAllActive (line 23)
7	App\Services\ClientService->getSelectedClient (line 48)
8	App\Twig\ClientExtension->getGlobals (line 32)
9	Twig\ExtensionSet->getGlobals (line 359)
10	Twig\Environment->getGlobals (line 900)
11	Twig\Template->yield (line 398)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 373)
14	Twig\TemplateWrapper->render (line 51)
15	Twig\Environment->render (line 333)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
19	App\Controller\HomePageController->index (line 14)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 182)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	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\Client	9

Entities Mapping

Class	Mapping errors
App\Entity\EntityBase	No errors.
App\Entity\Client	No errors.
App\Entity\Contact	No errors.

Symfony Profiler

GET https://dev.tisch.events/

Configuration Settings

Theme

Page Width