Symfony Profiler

Query Metrics

3 Database Queries

1 Different statements

1.74 ms Query time

0 Invalid entities

11 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.08 ms

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.title AS title_5, t0.subgroup AS subgroup_6, t0.url AS url_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.deleted_by_id AS deleted_by_id_10 FROM menu_item t0 WHERE t0.subgroup = ?

Parameters:

[
  "headerMenu"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.deleted_at AS deleted_at_4,
  t0.title AS title_5,
  t0.subgroup AS subgroup_6,
  t0.url AS url_7,
  t0.created_by_id AS created_by_id_8,
  t0.updated_by_id AS updated_by_id_9,
  t0.deleted_by_id AS deleted_by_id_10
FROM
  menu_item t0
WHERE
  t0.subgroup = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.title AS title_5, t0.subgroup AS subgroup_6, t0.url AS url_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.deleted_by_id AS deleted_by_id_10 FROM menu_item t0 WHERE t0.subgroup = 'headerMenu';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 25)
5	App\Service\MenuService->getMenuItems (line 1882)
6	Twig\Extension\CoreExtension::getAttribute (line 110)
7	__TwigTemplate_88b7bf1e41b5cc1e4eafd2a3f923401d->doDisplay (line 388)
8	Twig\Template->yield (line 344)
9	Twig\Template->display (line 359)
10	Twig\Template->render (line 51)
11	Twig\TemplateWrapper->render (line 1493)
12	Twig\Extension\CoreExtension::include (line 167)
13	__TwigTemplate_952e119b3791e7bae985c3211ebcde34->doDisplay (line 388)
14	Twig\Template->yield (line 55)
15	__TwigTemplate_5246e961e13ce6841ac889c5152cf366->doDisplay (line 388)
16	Twig\Template->yield (line 344)
17	Twig\Template->display (line 359)
18	Twig\Template->render (line 51)
19	Twig\TemplateWrapper->render (line 334)
20	Twig\Environment->render (line 448)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 147)
24	App\Controller\CrudAdvertismentController->new (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.33 ms

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.title AS title_5, t0.subgroup AS subgroup_6, t0.url AS url_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.deleted_by_id AS deleted_by_id_10 FROM menu_item t0 WHERE t0.subgroup = ?

Parameters:

[
  "footerMenu"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.deleted_at AS deleted_at_4,
  t0.title AS title_5,
  t0.subgroup AS subgroup_6,
  t0.url AS url_7,
  t0.created_by_id AS created_by_id_8,
  t0.updated_by_id AS updated_by_id_9,
  t0.deleted_by_id AS deleted_by_id_10
FROM
  menu_item t0
WHERE
  t0.subgroup = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.title AS title_5, t0.subgroup AS subgroup_6, t0.url AS url_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.deleted_by_id AS deleted_by_id_10 FROM menu_item t0 WHERE t0.subgroup = 'footerMenu';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 25)
5	App\Service\MenuService->getMenuItems (line 1882)
6	Twig\Extension\CoreExtension::getAttribute (line 65)
7	__TwigTemplate_84b808fd7e4cc0f3904df56bb140af53->doDisplay (line 388)
8	Twig\Template->yield (line 344)
9	Twig\Template->display (line 359)
10	Twig\Template->render (line 51)
11	Twig\TemplateWrapper->render (line 1493)
12	Twig\Extension\CoreExtension::include (line 174)
13	__TwigTemplate_952e119b3791e7bae985c3211ebcde34->doDisplay (line 388)
14	Twig\Template->yield (line 55)
15	__TwigTemplate_5246e961e13ce6841ac889c5152cf366->doDisplay (line 388)
16	Twig\Template->yield (line 344)
17	Twig\Template->display (line 359)
18	Twig\Template->render (line 51)
19	Twig\TemplateWrapper->render (line 334)
20	Twig\Environment->render (line 448)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 147)
24	App\Controller\CrudAdvertismentController->new (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.32 ms

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.title AS title_5, t0.subgroup AS subgroup_6, t0.url AS url_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.deleted_by_id AS deleted_by_id_10 FROM menu_item t0 WHERE t0.subgroup = ?

Parameters:

[
  "footerMenu1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.deleted_at AS deleted_at_4,
  t0.title AS title_5,
  t0.subgroup AS subgroup_6,
  t0.url AS url_7,
  t0.created_by_id AS created_by_id_8,
  t0.updated_by_id AS updated_by_id_9,
  t0.deleted_by_id AS deleted_by_id_10
FROM
  menu_item t0
WHERE
  t0.subgroup = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.title AS title_5, t0.subgroup AS subgroup_6, t0.url AS url_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.deleted_by_id AS deleted_by_id_10 FROM menu_item t0 WHERE t0.subgroup = 'footerMenu1';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 25)
5	App\Service\MenuService->getMenuItems (line 1882)
6	Twig\Extension\CoreExtension::getAttribute (line 101)
7	__TwigTemplate_84b808fd7e4cc0f3904df56bb140af53->doDisplay (line 388)
8	Twig\Template->yield (line 344)
9	Twig\Template->display (line 359)
10	Twig\Template->render (line 51)
11	Twig\TemplateWrapper->render (line 1493)
12	Twig\Extension\CoreExtension::include (line 174)
13	__TwigTemplate_952e119b3791e7bae985c3211ebcde34->doDisplay (line 388)
14	Twig\Template->yield (line 55)
15	__TwigTemplate_5246e961e13ce6841ac889c5152cf366->doDisplay (line 388)
16	Twig\Template->yield (line 344)
17	Twig\Template->display (line 359)
18	Twig\Template->render (line 51)
19	Twig\TemplateWrapper->render (line 334)
20	Twig\Environment->render (line 448)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 147)
24	App\Controller\CrudAdvertismentController->new (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	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\MenuItem	11

Entities Mapping

Class	Mapping errors
App\Entity\BaseEntity	No errors.
App\Entity\Advertisment	No errors.
App\Entity\User	No errors.
App\Entity\MenuItem	No errors.

Symfony Profiler

GET https://egazeta.ro/ad/new

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping