Symfony Profiler

Query Metrics

15 Database Queries

6 Different statements

5.19 ms Query time

0 Invalid entities

19 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.90 ms
(36.67%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.parent_id AS parent_id_6 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = ?

Parameters:

[
  617
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.image AS image_4,
  t0.created_at AS created_at_5,
  t0.parent_id AS parent_id_6
FROM
  category t0
  INNER JOIN article_category ON t0.id = article_category.category_id
WHERE
  article_category.article_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.parent_id AS parent_id_6 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = 617;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	Twig\Extension\CoreExtension->slice (line 761)
8	__TwigTemplate_830e907f9a0e365abd9a7c0d01c1a4be::block_body (line 143)
9	Twig\Template->yieldBlock (line 446)
10	__TwigTemplate_33ba668d4b77bfbf3a6515611af3e990->doDisplay (line 128)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_830e907f9a0e365abd9a7c0d01c1a4be->doDisplay (line 54)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
21	App\Controller\Front\FrontController->page (line 136)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 182)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	require_once (line 5)

1.41 ms
(27.13%)

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.description AS description_2, a0_.publish_date AS publish_date_3, a0_.created_at AS created_at_4, a0_.publish AS publish_5, a0_.image AS image_6, a0_.author_id AS author_id_7 FROM article a0_ INNER JOIN article_category a2_ ON a0_.id = a2_.article_id INNER JOIN category c1_ ON c1_.id = a2_.category_id WHERE c1_.id = ? ORDER BY a0_.id DESC LIMIT 9 OFFSET 126

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.description AS description_2,
  a0_.publish_date AS publish_date_3,
  a0_.created_at AS created_at_4,
  a0_.publish AS publish_5,
  a0_.image AS image_6,
  a0_.author_id AS author_id_7
FROM
  article a0_
  INNER JOIN article_category a2_ ON a0_.id = a2_.article_id
  INNER JOIN category c1_ ON c1_.id = a2_.category_id
WHERE
  c1_.id = ?
ORDER BY
  a0_.id DESC
LIMIT
  9
OFFSET
  126

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.description AS description_2, a0_.publish_date AS publish_date_3, a0_.created_at AS created_at_4, a0_.publish AS publish_5, a0_.image AS image_6, a0_.author_id AS author_id_7 FROM article a0_ INNER JOIN article_category a2_ ON a0_.id = a2_.article_id INNER JOIN category c1_ ON c1_.id = a2_.category_id WHERE c1_.id = 5 ORDER BY a0_.id DESC LIMIT 9 OFFSET 126;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\Article\ArticleRepository->getByCatPaginated (line 54)
7	App\Controller\Front\FrontController->page (line 130)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

1.16 ms
(22.29%)

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.description AS description_2, a0_.publish_date AS publish_date_3, a0_.created_at AS created_at_4, a0_.publish AS publish_5, a0_.image AS image_6 FROM article a0_ INNER JOIN article_category a2_ ON a0_.id = a2_.article_id INNER JOIN category c1_ ON c1_.id = a2_.category_id WHERE c1_.id = ? ORDER BY a0_.id DESC) dctrn_result) dctrn_table

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          a0_.id AS id_0,
          a0_.title AS title_1,
          a0_.description AS description_2,
          a0_.publish_date AS publish_date_3,
          a0_.created_at AS created_at_4,
          a0_.publish AS publish_5,
          a0_.image AS image_6
        FROM
          article a0_
          INNER JOIN article_category a2_ ON a0_.id = a2_.article_id
          INNER JOIN category c1_ ON c1_.id = a2_.category_id
        WHERE
          c1_.id = ?
        ORDER BY
          a0_.id DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.description AS description_2, a0_.publish_date AS publish_date_3, a0_.created_at AS created_at_4, a0_.publish AS publish_5, a0_.image AS image_6 FROM article a0_ INNER JOIN article_category a2_ ON a0_.id = a2_.article_id INNER JOIN category c1_ ON c1_.id = a2_.category_id WHERE c1_.id = 5 ORDER BY a0_.id DESC) dctrn_result) dctrn_table;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	App\Repository\Article\ArticleRepository->getByCatPaginated (line 57)
8	App\Controller\Front\FrontController->page (line 130)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

0.43 ms
(8.33%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.parent_id AS parent_id_6 FROM category t0 WHERE t0.id = ?

Parameters:

[
  "5"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.image AS image_4,
  t0.created_at AS created_at_5,
  t0.parent_id AS parent_id_6
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.parent_id AS parent_id_6 FROM category t0 WHERE t0.id = '5';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	App\Controller\Front\FrontController->page (line 125)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.15 ms
(2.81%)

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.description AS description_2, a0_.publish_date AS publish_date_3, a0_.created_at AS created_at_4, a0_.publish AS publish_5, a0_.image AS image_6, a0_.author_id AS author_id_7 FROM article a0_ ORDER BY a0_.id DESC LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.description AS description_2,
  a0_.publish_date AS publish_date_3,
  a0_.created_at AS created_at_4,
  a0_.publish AS publish_5,
  a0_.image AS image_6,
  a0_.author_id AS author_id_7
FROM
  article a0_
ORDER BY
  a0_.id DESC
LIMIT
  1

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.description AS description_2, a0_.publish_date AS publish_date_3, a0_.created_at AS created_at_4, a0_.publish AS publish_5, a0_.image AS image_6, a0_.author_id AS author_id_7 FROM article a0_ ORDER BY a0_.id DESC LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\Article\ArticleRepository->findLast (line 69)
7	App\Twig\Components\Sidebar->__construct (line 23)
8	ContainerDbnqG4x\getSidebarService->ContainerDbnqG4x\{closure} (line 25)
9	ContainerDbnqG4x\getSidebarService::do (line 28)
10	ContainerDbnqG4x\App_KernelDevDebugContainer::load (line 461)
11	Symfony\Component\DependencyInjection\Container->getService (line 405)
12	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 36)
13	Symfony\UX\TwigComponent\ComponentFactory->create (line 84)
14	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
15	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
16	__TwigTemplate_830e907f9a0e365abd9a7c0d01c1a4be->block_body (line 205)
17	Twig\Template->yieldBlock (line 446)
18	__TwigTemplate_33ba668d4b77bfbf3a6515611af3e990->doDisplay (line 128)
19	Twig\Template->yield (line 402)
20	__TwigTemplate_830e907f9a0e365abd9a7c0d01c1a4be->doDisplay (line 54)
21	Twig\Template->yield (line 402)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 373)
24	Twig\TemplateWrapper->render (line 51)
25	Twig\Environment->render (line 333)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
29	App\Controller\Front\FrontController->page (line 136)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	Symfony\Component\HttpKernel\Kernel->handle (line 182)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
34	require_once (line 29)
35	require_once (line 5)

0.14 ms
(2.77%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.parent_id AS parent_id_6 FROM category 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.description AS description_3,
  t0.image AS image_4,
  t0.created_at AS created_at_5,
  t0.parent_id AS parent_id_6
FROM
  category t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.parent_id AS parent_id_6 FROM category t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Twig\Components\Sidebar->__construct (line 22)
6	ContainerDbnqG4x\getSidebarService->ContainerDbnqG4x\{closure} (line 25)
7	ContainerDbnqG4x\getSidebarService::do (line 28)
8	ContainerDbnqG4x\App_KernelDevDebugContainer::load (line 461)
9	Symfony\Component\DependencyInjection\Container->getService (line 405)
10	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 36)
11	Symfony\UX\TwigComponent\ComponentFactory->create (line 84)
12	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
13	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
14	__TwigTemplate_830e907f9a0e365abd9a7c0d01c1a4be->block_body (line 205)
15	Twig\Template->yieldBlock (line 446)
16	__TwigTemplate_33ba668d4b77bfbf3a6515611af3e990->doDisplay (line 128)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_830e907f9a0e365abd9a7c0d01c1a4be->doDisplay (line 54)
19	Twig\Template->yield (line 402)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 373)
22	Twig\TemplateWrapper->render (line 51)
23	Twig\Environment->render (line 333)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
27	App\Controller\Front\FrontController->page (line 136)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 182)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 29)
33	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\Article\Article	10
App\Entity\Article\Category	8
App\Entity\Backend\User\User	1

Entities Mapping

Class	Mapping errors
App\Entity\Article\Category	No errors.
App\Entity\Article\Article	No errors.
App\Entity\Backend\User\User	No errors.
App\Entity\Article\Gallery	No errors.
App\Entity\Article\File	No errors.

Symfony Profiler

GET https://www.mcc.gov.mg/page/5?page=15

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping