Symfony Profiler

Query Metrics

2 Database Queries

1 Different statements

52.78 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

29.06 ms

SELECT t0.id AS id_1, t0.title AS title_2, t0.status_id AS status_id_3 FROM app_categories t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.status_id AS status_id_3
FROM
  app_categories t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.status_id AS status_id_3 FROM app_categories t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 942)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 60)
5	App\Service\Categories->shortlist (line 90)
6	App\Service\Categories->getCategoryBySlug (line 42)
7	App\Controller\IndexController->videoCategory (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

23.72 ms

SELECT t0.id AS id_1, t0.title AS title_2, t0.status_id AS status_id_3 FROM app_categories t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.status_id AS status_id_3
FROM
  app_categories t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.status_id AS status_id_3 FROM app_categories t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 942)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 60)
5	App\Service\Categories->shortlist (line 1635)
6	twig_get_attribute (line 77)
7	__TwigTemplate_048d553e435bd167c76efc0a7a858068->doDisplay (line 394)
8	Twig\Template->displayWithErrorHandling (line 367)
9	Twig\Template->display (line 216)
10	__TwigTemplate_4148b89fd3e0e310eb120de23cdf685a->block_menu (line 171)
11	Twig\Template->displayBlock (line 153)
12	__TwigTemplate_4148b89fd3e0e310eb120de23cdf685a->block_header (line 171)
13	Twig\Template->displayBlock (line 290)
14	__TwigTemplate_bd9a903b6df92c8401f417e14aef96ca->block_body (line 171)
15	Twig\Template->displayBlock (line 83)
16	__TwigTemplate_bd9a903b6df92c8401f417e14aef96ca->doDisplay (line 394)
17	Twig\Template->displayWithErrorHandling (line 367)
18	Twig\Template->display (line 63)
19	__TwigTemplate_2401902b3e4e2033f4cad4ce183913ad->doDisplay (line 394)
20	Twig\Template->displayWithErrorHandling (line 367)
21	Twig\Template->display (line 67)
22	__TwigTemplate_4148b89fd3e0e310eb120de23cdf685a->doDisplay (line 394)
23	Twig\Template->displayWithErrorHandling (line 367)
24	Twig\Template->display (line 50)
25	__TwigTemplate_3c62d18c89a9904b6b5ea9405a344d6c->doDisplay (line 394)
26	Twig\Template->displayWithErrorHandling (line 367)
27	Twig\Template->display (line 379)
28	Twig\Template->render (line 38)
29	Twig\TemplateWrapper->render (line 280)
30	Twig\Environment->render (line 62)
31	Symfony\Bridge\Twig\EventListener\TemplateAttributeListener->onKernelView (line 116)
32	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
33	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
34	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
35	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 186)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
38	Symfony\Component\HttpKernel\Kernel->handle (line 35)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
40	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.

Entities Mapping

Class	Mapping errors
App\Entity\Category	No errors.
App\Entity\Status	No errors.
App\Entity\Video	No errors.
TVI\Core\Entity\User	No errors.

Symfony Profiler

GET http://tobias.codelikebob.com/video/category/data-security

Configuration Settings

Theme