Symfony Profiler

Query Metrics

4 Database Queries

3 Different statements

0.71 ms Query time

0 Invalid entities

8 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.37 ms
(52.88%)

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.intro_text AS intro_text_1, b0_.title AS title_2, b0_.full_text AS full_text_3, b0_.alias AS alias_4, b0_.created AS created_5, b0_.ordering AS ordering_6, b0_.views AS views_7, b0_.metakey AS metakey_8, b0_.metadesc AS metadesc_9, b0_.image AS image_10, b0_.image_title AS image_title_11, b0_.image_alt AS image_alt_12, b0_.metatitle AS metatitle_13, b0_.search_text AS search_text_14 FROM blog b0_) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 3

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          b0_.id AS id_0,
          b0_.intro_text AS intro_text_1,
          b0_.title AS title_2,
          b0_.full_text AS full_text_3,
          b0_.alias AS alias_4,
          b0_.created AS created_5,
          b0_.ordering AS ordering_6,
          b0_.views AS views_7,
          b0_.metakey AS metakey_8,
          b0_.metadesc AS metadesc_9,
          b0_.image AS image_10,
          b0_.image_title AS image_title_11,
          b0_.image_alt AS image_alt_12,
          b0_.metatitle AS metatitle_13,
          b0_.search_text AS search_text_14
        FROM
          blog b0_
      ) dctrn_result_inner
    ORDER BY
      id_0 DESC
  ) dctrn_result
LIMIT
  3

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.intro_text AS intro_text_1, b0_.title AS title_2, b0_.full_text AS full_text_3, b0_.alias AS alias_4, b0_.created AS created_5, b0_.ordering AS ordering_6, b0_.views AS views_7, b0_.metakey AS metakey_8, b0_.metadesc AS metadesc_9, b0_.image AS image_10, b0_.image_title AS image_title_11, b0_.image_alt AS image_alt_12, b0_.metatitle AS metatitle_13, b0_.search_text AS search_text_14 FROM blog b0_) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 3;

#	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->getScalarResult (line 725)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	__TwigTemplate_3c9a1c49d8abcbb412cbc69c0e19215a->block_carousel_block (line 79)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_3c9a1c49d8abcbb412cbc69c0e19215a->doDisplay (line 49)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_d67ea3cd5a9d07d916fbf79a819b9dc9___1009586956->doDisplay (line 5669)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_d67ea3cd5a9d07d916fbf79a819b9dc9->block_mainPageSlider (line 1487)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_d67ea3cd5a9d07d916fbf79a819b9dc9->block_body (line 1194)
16	Twig\Template->yieldBlock (line 446)
17	__TwigTemplate_d67ea3cd5a9d07d916fbf79a819b9dc9->doDisplay (line 182)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_34f63e6358e96a8a6d91d6a89edd8177->doDisplay (line 52)
20	Twig\Template->yield (line 402)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 373)
23	Twig\TemplateWrapper->render (line 51)
24	Twig\Environment->render (line 333)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
28	App\Controller\MainController->index (line 63)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 182)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 29)
34	require_once (line 5)

0.24 ms
(34.10%)

SELECT b0_.id AS id_0, b0_.intro_text AS intro_text_1, b0_.title AS title_2, b0_.full_text AS full_text_3, b0_.alias AS alias_4, b0_.created AS created_5, b0_.ordering AS ordering_6, b0_.views AS views_7, b0_.metakey AS metakey_8, b0_.metadesc AS metadesc_9, b0_.image AS image_10, b0_.image_title AS image_title_11, b0_.image_alt AS image_alt_12, b0_.metatitle AS metatitle_13, b0_.search_text AS search_text_14, b0_.category_id AS category_id_15, b0_.sub_category_id AS sub_category_id_16 FROM blog b0_ WHERE b0_.id IN (?, ?, ?) ORDER BY b0_.id DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.intro_text AS intro_text_1,
  b0_.title AS title_2,
  b0_.full_text AS full_text_3,
  b0_.alias AS alias_4,
  b0_.created AS created_5,
  b0_.ordering AS ordering_6,
  b0_.views AS views_7,
  b0_.metakey AS metakey_8,
  b0_.metadesc AS metadesc_9,
  b0_.image AS image_10,
  b0_.image_title AS image_title_11,
  b0_.image_alt AS image_alt_12,
  b0_.metatitle AS metatitle_13,
  b0_.search_text AS search_text_14,
  b0_.category_id AS category_id_15,
  b0_.sub_category_id AS sub_category_id_16
FROM
  blog b0_
WHERE
  b0_.id IN (?, ?, ?)
ORDER BY
  b0_.id DESC

SELECT b0_.id AS id_0, b0_.intro_text AS intro_text_1, b0_.title AS title_2, b0_.full_text AS full_text_3, b0_.alias AS alias_4, b0_.created AS created_5, b0_.ordering AS ordering_6, b0_.views AS views_7, b0_.metakey AS metakey_8, b0_.metadesc AS metadesc_9, b0_.image AS image_10, b0_.image_title AS image_title_11, b0_.image_alt AS image_alt_12, b0_.metatitle AS metatitle_13, b0_.search_text AS search_text_14, b0_.category_id AS category_id_15, b0_.sub_category_id AS sub_category_id_16 FROM blog b0_ WHERE b0_.id IN (313, 312, 311) ORDER BY b0_.id DESC;

#	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	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
7	__TwigTemplate_3c9a1c49d8abcbb412cbc69c0e19215a->block_carousel_block (line 79)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_3c9a1c49d8abcbb412cbc69c0e19215a->doDisplay (line 49)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_d67ea3cd5a9d07d916fbf79a819b9dc9___1009586956->doDisplay (line 5669)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_d67ea3cd5a9d07d916fbf79a819b9dc9->block_mainPageSlider (line 1487)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_d67ea3cd5a9d07d916fbf79a819b9dc9->block_body (line 1194)
16	Twig\Template->yieldBlock (line 446)
17	__TwigTemplate_d67ea3cd5a9d07d916fbf79a819b9dc9->doDisplay (line 182)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_34f63e6358e96a8a6d91d6a89edd8177->doDisplay (line 52)
20	Twig\Template->yield (line 402)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 373)
23	Twig\TemplateWrapper->render (line 51)
24	Twig\Environment->render (line 333)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
28	App\Controller\MainController->index (line 63)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 182)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 29)
34	require_once (line 5)

0.09 ms
(13.02%)

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.intro_text AS intro_text_1, b0_.title AS title_2, b0_.full_text AS full_text_3, b0_.alias AS alias_4, b0_.created AS created_5, b0_.ordering AS ordering_6, b0_.views AS views_7, b0_.metakey AS metakey_8, b0_.metadesc AS metadesc_9, b0_.image AS image_10, b0_.image_title AS image_title_11, b0_.image_alt AS image_alt_12, b0_.metatitle AS metatitle_13, b0_.search_text AS search_text_14 FROM blog b0_) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 3 OFFSET 3

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          b0_.id AS id_0,
          b0_.intro_text AS intro_text_1,
          b0_.title AS title_2,
          b0_.full_text AS full_text_3,
          b0_.alias AS alias_4,
          b0_.created AS created_5,
          b0_.ordering AS ordering_6,
          b0_.views AS views_7,
          b0_.metakey AS metakey_8,
          b0_.metadesc AS metadesc_9,
          b0_.image AS image_10,
          b0_.image_title AS image_title_11,
          b0_.image_alt AS image_alt_12,
          b0_.metatitle AS metatitle_13,
          b0_.search_text AS search_text_14
        FROM
          blog b0_
      ) dctrn_result_inner
    ORDER BY
      id_0 DESC
  ) dctrn_result
LIMIT
  3
OFFSET
  3

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.intro_text AS intro_text_1, b0_.title AS title_2, b0_.full_text AS full_text_3, b0_.alias AS alias_4, b0_.created AS created_5, b0_.ordering AS ordering_6, b0_.views AS views_7, b0_.metakey AS metakey_8, b0_.metadesc AS metadesc_9, b0_.image AS image_10, b0_.image_title AS image_title_11, b0_.image_alt AS image_alt_12, b0_.metatitle AS metatitle_13, b0_.search_text AS search_text_14 FROM blog b0_) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 3 OFFSET 3;

#	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->getScalarResult (line 725)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	__TwigTemplate_3c9a1c49d8abcbb412cbc69c0e19215a->block_carousel_block (line 119)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_3c9a1c49d8abcbb412cbc69c0e19215a->doDisplay (line 49)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_d67ea3cd5a9d07d916fbf79a819b9dc9___1009586956->doDisplay (line 5669)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_d67ea3cd5a9d07d916fbf79a819b9dc9->block_mainPageSlider (line 1487)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_d67ea3cd5a9d07d916fbf79a819b9dc9->block_body (line 1194)
16	Twig\Template->yieldBlock (line 446)
17	__TwigTemplate_d67ea3cd5a9d07d916fbf79a819b9dc9->doDisplay (line 182)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_34f63e6358e96a8a6d91d6a89edd8177->doDisplay (line 52)
20	Twig\Template->yield (line 402)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 373)
23	Twig\TemplateWrapper->render (line 51)
24	Twig\Environment->render (line 333)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
28	App\Controller\MainController->index (line 63)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 182)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 29)
34	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\Blog	6
App\Entity\BlogCategory	1
App\Entity\BlogSubCategory	1

Entities Mapping

Class	Mapping errors
App\Entity\Blog	No errors.
App\Entity\BlogCategory	No errors.
App\Entity\BlogSubCategory	No errors.

Symfony Profiler

GET http://www.tp.aac-testpsycho.fr/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping