Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

8.24 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

4.39 ms

SELECT t0_.id AS id_0, t0_.idnum AS idnum_1, t0_.enabled AS enabled_2, t0_.title AS title_3, t0_.slug AS slug_4, t0_.file_name AS file_name_5, t0_.file_url AS file_url_6, t1_.id AS id_7, t1_.name AS name_8, t1_.slug AS slug_9, t2_.id AS id_10, t2_.name AS name_11, t2_.slug AS slug_12 FROM training t0_ LEFT JOIN training_category t1_ ON t0_.category_id = t1_.id LEFT JOIN training_level t2_ ON t0_.level_id = t2_.id WHERE t0_.enabled = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.idnum AS idnum_1,
  t0_.enabled AS enabled_2,
  t0_.title AS title_3,
  t0_.slug AS slug_4,
  t0_.file_name AS file_name_5,
  t0_.file_url AS file_url_6,
  t1_.id AS id_7,
  t1_.name AS name_8,
  t1_.slug AS slug_9,
  t2_.id AS id_10,
  t2_.name AS name_11,
  t2_.slug AS slug_12
FROM
  training t0_
  LEFT JOIN training_category t1_ ON t0_.category_id = t1_.id
  LEFT JOIN training_level t2_ ON t0_.level_id = t2_.id
WHERE
  t0_.enabled = ?

SELECT t0_.id AS id_0, t0_.idnum AS idnum_1, t0_.enabled AS enabled_2, t0_.title AS title_3, t0_.slug AS slug_4, t0_.file_name AS file_name_5, t0_.file_url AS file_url_6, t1_.id AS id_7, t1_.name AS name_8, t1_.slug AS slug_9, t2_.id AS id_10, t2_.name AS name_11, t2_.slug AS slug_12 FROM training t0_ LEFT JOIN training_category t1_ ON t0_.category_id = t1_.id LEFT JOIN training_level t2_ ON t0_.level_id = t2_.id WHERE t0_.enabled = 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->getArrayResult (line 700)
6	App\Repository\Training\TrainingRepository->findLatestOptimized (line 49)
7	App\Components\Training\Training\TrainingLatest->getTrainings (line 17)
8	Twig\Extension\CoreExtension->getAttribute (line 1911)
9	__TwigTemplate_e5b71e5738e65d982609b92b1a802752::doDisplay (line 64)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
14	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
15	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
16	__TwigTemplate_6563916ef10ccd61efc5f96b8d595bac->block_content (line 97)
17	Twig\Template->yieldBlock (line 446)
18	__TwigTemplate_f16b8672e65512743c9449fa73d7c6f2->doDisplay (line 112)
19	Twig\Template->yield (line 402)
20	__TwigTemplate_6563916ef10ccd61efc5f96b8d595bac->doDisplay (line 53)
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 467)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
29	App\Controller\Frontend\Main\HomeController->index (line 12)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	Symfony\Component\HttpKernel\Kernel->handle (line 193)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
34	require_once (line 32)
35	require_once (line 5)

3.85 ms

SELECT p0_.id AS id_0, p0_.idnum AS idnum_1, p0_.enabled AS enabled_2, p0_.title AS title_3, p0_.slug AS slug_4, p0_.file_name AS file_name_5, p0_.file_url AS file_url_6, p0_.status AS status_7, p0_.published AS published_8, p0_.content AS content_9, p1_.id AS id_10, p1_.name AS name_11, p1_.slug AS slug_12, p2_.id AS id_13, p2_.fullname AS fullname_14, p2_.slug AS slug_15 FROM post p0_ LEFT JOIN post_category p1_ ON p0_.category_id = p1_.id LEFT JOIN post_author p2_ ON p0_.author_id = p2_.id WHERE p0_.enabled = ? AND p0_.status = ? GROUP BY p0_.id, p1_.id, p2_.id ORDER BY p0_.published DESC LIMIT 6

Parameters:

[
  1
  "PUBLISHED"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.idnum AS idnum_1,
  p0_.enabled AS enabled_2,
  p0_.title AS title_3,
  p0_.slug AS slug_4,
  p0_.file_name AS file_name_5,
  p0_.file_url AS file_url_6,
  p0_.status AS status_7,
  p0_.published AS published_8,
  p0_.content AS content_9,
  p1_.id AS id_10,
  p1_.name AS name_11,
  p1_.slug AS slug_12,
  p2_.id AS id_13,
  p2_.fullname AS fullname_14,
  p2_.slug AS slug_15
FROM
  post p0_
  LEFT JOIN post_category p1_ ON p0_.category_id = p1_.id
  LEFT JOIN post_author p2_ ON p0_.author_id = p2_.id
WHERE
  p0_.enabled = ?
  AND p0_.status = ?
GROUP BY
  p0_.id,
  p1_.id,
  p2_.id
ORDER BY
  p0_.published DESC
LIMIT
  6

SELECT p0_.id AS id_0, p0_.idnum AS idnum_1, p0_.enabled AS enabled_2, p0_.title AS title_3, p0_.slug AS slug_4, p0_.file_name AS file_name_5, p0_.file_url AS file_url_6, p0_.status AS status_7, p0_.published AS published_8, p0_.content AS content_9, p1_.id AS id_10, p1_.name AS name_11, p1_.slug AS slug_12, p2_.id AS id_13, p2_.fullname AS fullname_14, p2_.slug AS slug_15 FROM post p0_ LEFT JOIN post_category p1_ ON p0_.category_id = p1_.id LEFT JOIN post_author p2_ ON p0_.author_id = p2_.id WHERE p0_.enabled = 1 AND p0_.status = 'PUBLISHED' GROUP BY p0_.id, p1_.id, p2_.id ORDER BY p0_.published DESC LIMIT 6;

#	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->getArrayResult (line 700)
6	App\Repository\Blog\PostRepository->findLatestOptimized (line 61)
7	App\Components\Blog\Post\PostLatest->getPosts (line 17)
8	Twig\Extension\CoreExtension->getAttribute (line 1911)
9	__TwigTemplate_a98987442bef1fe13a9b27203a7ffce0::doDisplay (line 62)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
14	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
15	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
16	__TwigTemplate_6563916ef10ccd61efc5f96b8d595bac->block_content (line 127)
17	Twig\Template->yieldBlock (line 446)
18	__TwigTemplate_f16b8672e65512743c9449fa73d7c6f2->doDisplay (line 112)
19	Twig\Template->yield (line 402)
20	__TwigTemplate_6563916ef10ccd61efc5f96b8d595bac->doDisplay (line 53)
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 467)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
29	App\Controller\Frontend\Main\HomeController->index (line 12)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	Symfony\Component\HttpKernel\Kernel->handle (line 193)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
34	require_once (line 32)
35	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

Entities Mapping

Class	Mapping errors
App\Entity\Training\Training	No errors.
App\Entity\Training\TrainingCategory	No errors.
App\Entity\Training\TrainingLevel	No errors.
App\Entity\Blog\Post	No errors.
App\Entity\Blog\PostCategory	No errors.
App\Entity\Blog\PostAuthor	No errors.

Symfony Profiler

GET https://test.icesacademy.org/

Configuration Settings

Theme

Page Width