Symfony Profiler

Query Metrics

7 Database Queries

7 Different statements

72.60 ms Query time

0 Invalid entities

44 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

59.28 ms
(81.65%)

SELECT count(DISTINCT b0_.id) AS sclr_0 FROM bulletin b0_ WHERE b0_.published = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT b0_.id) AS sclr_0
FROM
  bulletin b0_
WHERE
  b0_.published = ?

SELECT count(DISTINCT b0_.id) AS sclr_0 FROM bulletin b0_ WHERE b0_.published = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 943)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 120)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 1)
8	count (line 43)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerDnUfJ1E\PaginatorProxy9cc2a8f->paginate (line 44)
16	App\Controller\BulletinController->list (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

6.68 ms
(9.20%)

SELECT DISTINCT b0_.id AS id_0, b0_.created_date AS created_date_1 FROM bulletin b0_ WHERE b0_.published = ? ORDER BY b0_.created_date DESC LIMIT 20 OFFSET 940

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT b0_.id AS id_0,
  b0_.created_date AS created_date_1
FROM
  bulletin b0_
WHERE
  b0_.published = ?
ORDER BY
  b0_.created_date DESC
LIMIT
  20
OFFSET
  940

SELECT DISTINCT b0_.id AS id_0, b0_.created_date AS created_date_1 FROM bulletin b0_ WHERE b0_.published = 1 ORDER BY b0_.created_date DESC LIMIT 20 OFFSET 940;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 943)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 153)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerDnUfJ1E\PaginatorProxy9cc2a8f->paginate (line 44)
16	App\Controller\BulletinController->list (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

1.70 ms
(2.34%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.show_title AS show_title_3, t0.background_color AS background_color_4, t0.column_number AS column_number_5, t0.type AS type_6, t0.with_carousel AS with_carousel_7, t0.orden AS orden_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.file_name AS file_name_11, t0.index_configuration_id AS index_configuration_id_12 FROM section t0 WHERE t0.index_configuration_id = ? ORDER BY t0.orden ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.show_title AS show_title_3,
  t0.background_color AS background_color_4,
  t0.column_number AS column_number_5,
  t0.type AS type_6,
  t0.with_carousel AS with_carousel_7,
  t0.orden AS orden_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.file_name AS file_name_11,
  t0.index_configuration_id AS index_configuration_id_12
FROM
  section t0
WHERE
  t0.index_configuration_id = ?
ORDER BY
  t0.orden ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.show_title AS show_title_3, t0.background_color AS background_color_4, t0.column_number AS column_number_5, t0.type AS type_6, t0.with_carousel AS with_carousel_7, t0.orden AS orden_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.file_name AS file_name_11, t0.index_configuration_id AS index_configuration_id_12 FROM section t0 WHERE t0.index_configuration_id = 1 ORDER BY t0.orden ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1929)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1870)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3309)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 456)
8	Doctrine\ORM\PersistentCollection->count (line 535)
9	Doctrine\ORM\PersistentCollection->isEmpty (line 85)
10	App\Entity\IndexConfiguration->getSectionFooter (line 1909)
11	Twig\Extension\CoreExtension::getAttribute (line 293)
12	__TwigTemplate_878e74922cb496c4c058cd67585da5d9->block_footer (line 446)
13	Twig\Template->yieldBlock (line 99)
14	__TwigTemplate_878e74922cb496c4c058cd67585da5d9->doDisplay (line 402)
15	Twig\Template->yield (line 55)
16	__TwigTemplate_be5befd21933ab98c224696917404e2f->doDisplay (line 402)
17	Twig\Template->yield (line 358)
18	Twig\Template->display (line 373)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 333)
21	Twig\Environment->render (line 448)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 55)
25	App\Controller\BulletinController->list (line 181)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

1.56 ms
(2.16%)

SELECT b0_.id AS id_0, b0_.published AS published_1, b0_.nro_bulletin AS nro_bulletin_2, b0_.created_date AS created_date_3, b0_.created_at AS created_at_4, b0_.updated_at AS updated_at_5, b0_.file_name AS file_name_6 FROM bulletin b0_ WHERE b0_.published = ? AND b0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY b0_.created_date DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.published AS published_1,
  b0_.nro_bulletin AS nro_bulletin_2,
  b0_.created_date AS created_date_3,
  b0_.created_at AS created_at_4,
  b0_.updated_at AS updated_at_5,
  b0_.file_name AS file_name_6
FROM
  bulletin b0_
WHERE
  b0_.published = ?
  AND b0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  b0_.created_date DESC

SELECT b0_.id AS id_0, b0_.published AS published_1, b0_.nro_bulletin AS nro_bulletin_2, b0_.created_date AS created_date_3, b0_.created_at AS created_at_4, b0_.updated_at AS updated_at_5, b0_.file_name AS file_name_6 FROM bulletin b0_ WHERE b0_.published = 1 AND b0_.id IN (865, 866, 867, 868, 869, 870, 871, 872, 873, 874, 876, 877, 878, 879, 880, 881, 882, 883, 884, 885) ORDER BY b0_.created_date DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 171)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerDnUfJ1E\PaginatorProxy9cc2a8f->paginate (line 44)
16	App\Controller\BulletinController->list (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

1.51 ms
(2.08%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.active AS active_3, t0.url AS url_4, t0.orden AS orden_5, t0.show_title AS show_title_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.file_name AS file_name_9, t0.section_id AS section_id_10 FROM widget t0 WHERE t0.section_id = ? ORDER BY t0.orden ASC

Parameters:

[
  10
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.active AS active_3,
  t0.url AS url_4,
  t0.orden AS orden_5,
  t0.show_title AS show_title_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.file_name AS file_name_9,
  t0.section_id AS section_id_10
FROM
  widget t0
WHERE
  t0.section_id = ?
ORDER BY
  t0.orden ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.active AS active_3, t0.url AS url_4, t0.orden AS orden_5, t0.show_title AS show_title_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.file_name AS file_name_9, t0.section_id AS section_id_10 FROM widget t0 WHERE t0.section_id = 10 ORDER BY t0.orden ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1929)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1870)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3309)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 237)
7	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 208)
8	App\Entity\Section->getWidgetsColumn (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 53)
10	__TwigTemplate_27f5d52f0752d03c43f6bbf525791e2e->doDisplay (line 402)
11	Twig\Template->yield (line 358)
12	Twig\Template->display (line 373)
13	Twig\Template->render (line 77)
14	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
15	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
16	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 145)
17	__TwigTemplate_cdb21db7ea412a32e1e5f50c0417054b->doDisplay (line 402)
18	Twig\Template->yield (line 358)
19	Twig\Template->display (line 373)
20	Twig\Template->render (line 77)
21	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
22	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
23	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 293)
24	__TwigTemplate_878e74922cb496c4c058cd67585da5d9->block_footer (line 446)
25	Twig\Template->yieldBlock (line 99)
26	__TwigTemplate_878e74922cb496c4c058cd67585da5d9->doDisplay (line 402)
27	Twig\Template->yield (line 55)
28	__TwigTemplate_be5befd21933ab98c224696917404e2f->doDisplay (line 402)
29	Twig\Template->yield (line 358)
30	Twig\Template->display (line 373)
31	Twig\Template->render (line 51)
32	Twig\TemplateWrapper->render (line 333)
33	Twig\Environment->render (line 448)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 55)
37	App\Controller\BulletinController->list (line 181)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
40	Symfony\Component\HttpKernel\Kernel->handle (line 35)
41	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
42	require_once (line 5)

0.98 ms
(1.35%)

SELECT f0_.id AS id_0, f0_.favicon AS favicon_1, f0_.favicon16 AS favicon16_2, f0_.favicon32 AS favicon32_3, f0_.favicon_apple AS favicon_apple_4, f0_.favicon_android192 AS favicon_android192_5, f0_.favicon_android512 AS favicon_android512_6, f0_.created_at AS created_at_7, f0_.updated_at AS updated_at_8 FROM favicon f0_ ORDER BY f0_.id ASC LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.favicon AS favicon_1,
  f0_.favicon16 AS favicon16_2,
  f0_.favicon32 AS favicon32_3,
  f0_.favicon_apple AS favicon_apple_4,
  f0_.favicon_android192 AS favicon_android192_5,
  f0_.favicon_android512 AS favicon_android512_6,
  f0_.created_at AS created_at_7,
  f0_.updated_at AS updated_at_8
FROM
  favicon f0_
ORDER BY
  f0_.id ASC
LIMIT
  1

SELECT f0_.id AS id_0, f0_.favicon AS favicon_1, f0_.favicon16 AS favicon16_2, f0_.favicon32 AS favicon32_3, f0_.favicon_apple AS favicon_apple_4, f0_.favicon_android192 AS favicon_android192_5, f0_.favicon_android512 AS favicon_android512_6, f0_.created_at AS created_at_7, f0_.updated_at AS updated_at_8 FROM favicon f0_ ORDER BY f0_.id ASC LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 959)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 31)
7	App\Repository\FaviconRepository->getFavicon (line 47)
8	App\Twig\Runtime\AppExtensionRuntime->getFavicon (line 48)
9	__TwigTemplate_b8ad022335a8292bba3477063788d51c->doDisplay (line 402)
10	Twig\Template->yield (line 358)
11	Twig\Template->display (line 373)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 1520)
14	Twig\Extension\CoreExtension::include (line 186)
15	__TwigTemplate_878e74922cb496c4c058cd67585da5d9->block_favicons (line 446)
16	Twig\Template->yieldBlock (line 77)
17	__TwigTemplate_878e74922cb496c4c058cd67585da5d9->doDisplay (line 402)
18	Twig\Template->yield (line 55)
19	__TwigTemplate_be5befd21933ab98c224696917404e2f->doDisplay (line 402)
20	Twig\Template->yield (line 358)
21	Twig\Template->display (line 373)
22	Twig\Template->render (line 51)
23	Twig\TemplateWrapper->render (line 333)
24	Twig\Environment->render (line 448)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 55)
28	App\Controller\BulletinController->list (line 181)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

0.89 ms
(1.22%)

SELECT i0_.id AS id_0, i0_.created_at AS created_at_1, i0_.updated_at AS updated_at_2, i0_.file_name AS file_name_3, i0_.second_file_name AS second_file_name_4 FROM index_configuration i0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  i0_.id AS id_0,
  i0_.created_at AS created_at_1,
  i0_.updated_at AS updated_at_2,
  i0_.file_name AS file_name_3,
  i0_.second_file_name AS second_file_name_4
FROM
  index_configuration i0_

SELECT i0_.id AS id_0, i0_.created_at AS created_at_1, i0_.updated_at AS updated_at_2, i0_.file_name AS file_name_3, i0_.second_file_name AS second_file_name_4 FROM index_configuration i0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 959)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 43)
7	App\Repository\IndexConfigurationRepository->findLast (line 16)
8	App\Service\GetIndexConfigurationService->execute (line 31)
9	App\Twig\Runtime\AppExtensionRuntime->getIndexConfiguration (line 88)
10	__TwigTemplate_878e74922cb496c4c058cd67585da5d9->doDisplay (line 402)
11	Twig\Template->yield (line 55)
12	__TwigTemplate_be5befd21933ab98c224696917404e2f->doDisplay (line 402)
13	Twig\Template->yield (line 358)
14	Twig\Template->display (line 373)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 333)
17	Twig\Environment->render (line 448)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 55)
21	App\Controller\BulletinController->list (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	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\Bulletin	20
App\Entity\Widget	12
App\Entity\Section	10
App\Entity\Favicon	1
App\Entity\IndexConfiguration	1

Entities Mapping

Class	Mapping errors
App\Entity\Bulletin	No errors.
App\Entity\Favicon	No errors.
App\Entity\IndexConfiguration	No errors.
App\Entity\Section	No errors.
App\Entity\Widget	No errors.

Symfony Profiler

GET http://boletin.ecomdev.ar/?page=48

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping