Symfony Profiler

Query Metrics

6 Database Queries

4 Different statements

10.81 ms Query time

0 Invalid entities

51 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

5.40 ms
(49.91%)

SELECT f0_.id AS id_0, f0_.question AS question_1, f0_.answer AS answer_2, f0_.published AS published_3, f0_.position AS position_4, f1_.id AS id_5, f1_.name AS name_6, f1_.slug AS slug_7, f1_.position AS position_8, f0_.category_id AS category_id_9 FROM faq f0_ LEFT JOIN faq_category f1_ ON f0_.category_id = f1_.id WHERE f0_.published = 1 ORDER BY f0_.position ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.question AS question_1,
  f0_.answer AS answer_2,
  f0_.published AS published_3,
  f0_.position AS position_4,
  f1_.id AS id_5,
  f1_.name AS name_6,
  f1_.slug AS slug_7,
  f1_.position AS position_8,
  f0_.category_id AS category_id_9
FROM
  faq f0_
  LEFT JOIN faq_category f1_ ON f0_.category_id = f1_.id
WHERE
  f0_.published = 1
ORDER BY
  f0_.position ASC

SELECT f0_.id AS id_0, f0_.question AS question_1, f0_.answer AS answer_2, f0_.published AS published_3, f0_.position AS position_4, f1_.id AS id_5, f1_.name AS name_6, f1_.slug AS slug_7, f1_.position AS position_8, f0_.category_id AS category_id_9 FROM faq f0_ LEFT JOIN faq_category f1_ ON f0_.category_id = f1_.id WHERE f0_.published = 1 ORDER BY f0_.position ASC;

#	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\FaqRepository->findVisibleOrdered (line 46)
7	App\Service\TaxonomyProvider->faqs (line 164)
8	App\Controller\PageController->faq (line 38)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
11	Symfony\Component\HttpKernel\Kernel->handle (line 143)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
13	require_once (line 32)
14	require_once (line 5)

2.91 ms
(26.95%)

SELECT n0_.id AS id_0, n0_.location AS location_1, n0_.label AS label_2, n0_.url AS url_3, n0_.published AS published_4, n0_.position AS position_5, p1_.id AS id_6, p1_.label AS label_7, p1_.file_name AS file_name_8, p1_.file_path AS file_path_9, p1_.published AS published_10, p1_.position AS position_11, n0_.pdf_document_id AS pdf_document_id_12 FROM navigation_item n0_ LEFT JOIN pdf_document p1_ ON n0_.pdf_document_id = p1_.id WHERE n0_.location = ? AND n0_.published = 1 ORDER BY n0_.position ASC

Parameters:

[
  "navbar_docs"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.id AS id_0,
  n0_.location AS location_1,
  n0_.label AS label_2,
  n0_.url AS url_3,
  n0_.published AS published_4,
  n0_.position AS position_5,
  p1_.id AS id_6,
  p1_.label AS label_7,
  p1_.file_name AS file_name_8,
  p1_.file_path AS file_path_9,
  p1_.published AS published_10,
  p1_.position AS position_11,
  n0_.pdf_document_id AS pdf_document_id_12
FROM
  navigation_item n0_
  LEFT JOIN pdf_document p1_ ON n0_.pdf_document_id = p1_.id
WHERE
  n0_.location = ?
  AND n0_.published = 1
ORDER BY
  n0_.position ASC

SELECT n0_.id AS id_0, n0_.location AS location_1, n0_.label AS label_2, n0_.url AS url_3, n0_.published AS published_4, n0_.position AS position_5, p1_.id AS id_6, p1_.label AS label_7, p1_.file_name AS file_name_8, p1_.file_path AS file_path_9, p1_.published AS published_10, p1_.position AS position_11, n0_.pdf_document_id AS pdf_document_id_12 FROM navigation_item n0_ LEFT JOIN pdf_document p1_ ON n0_.pdf_document_id = p1_.id WHERE n0_.location = 'navbar_docs' AND n0_.published = 1 ORDER BY n0_.position ASC;

#	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\NavigationItemRepository->findPublishedByLocation (line 33)
7	App\Service\ContentProvider->navbarDocs (line 94)
8	Twig\Extension\CoreExtension->getAttribute (line 1918)
9	__TwigTemplate_c25b52bef769c0ffc755642a1718018b::doDisplay (line 66)
10	Twig\Template->yield (line 411)
11	Twig\Template->display (line 366)
12	Twig\Template->render (line 381)
13	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
14	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
15	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 53)
16	__TwigTemplate_a077acae774e57057c129511cb520250->doDisplay (line 92)
17	Twig\Template->yield (line 411)
18	__TwigTemplate_8a88a3013538963fa87f289f5524d6e1->doDisplay (line 57)
19	Twig\Template->yield (line 411)
20	Twig\Template->display (line 366)
21	Twig\Template->render (line 381)
22	Twig\TemplateWrapper->render (line 51)
23	Twig\Environment->render (line 333)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 472)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 477)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 281)
27	App\Controller\PageController->faq (line 36)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
30	Symfony\Component\HttpKernel\Kernel->handle (line 143)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
32	require_once (line 32)
33	require_once (line 5)

1.34 ms
(12.41%)

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.slug AS slug_2, f0_.position AS position_3 FROM faq_category f0_ ORDER BY f0_.position ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.name AS name_1,
  f0_.slug AS slug_2,
  f0_.position AS position_3
FROM
  faq_category f0_
ORDER BY
  f0_.position ASC

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.slug AS slug_2, f0_.position AS position_3 FROM faq_category f0_ ORDER BY f0_.position ASC;

#	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\FaqCategoryRepository->findOrdered (line 27)
7	App\Service\TaxonomyProvider->faqCategories (line 153)
8	App\Controller\PageController->faq (line 37)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
11	Symfony\Component\HttpKernel\Kernel->handle (line 143)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
13	require_once (line 32)
14	require_once (line 5)

1.16 ms
(10.73%)

SELECT t0.id AS id_1, t0.content_key AS content_key_2, t0.locale AS locale_3, t0.value AS value_4 FROM content_block t0 WHERE t0.locale = ?

Parameters:

[
  "en"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.content_key AS content_key_2,
  t0.locale AS locale_3,
  t0.value AS value_4
FROM
  content_block t0
WHERE
  t0.locale = ?

SELECT t0.id AS id_1, t0.content_key AS content_key_2, t0.locale AS locale_3, t0.value AS value_4 FROM content_block t0 WHERE t0.locale = 'en';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	App\Repository\ContentBlockRepository->getMap (line 29)
5	App\Service\ContentProvider->texts (line 54)
6	App\Service\ContentProvider->text (line 44)
7	Twig\Extension\CoreExtension->getAttribute (line 1918)
8	__TwigTemplate_8a88a3013538963fa87f289f5524d6e1::block_body (line 115)
9	Twig\Template->yieldBlock (line 456)
10	__TwigTemplate_a077acae774e57057c129511cb520250->doDisplay (line 98)
11	Twig\Template->yield (line 411)
12	__TwigTemplate_8a88a3013538963fa87f289f5524d6e1->doDisplay (line 57)
13	Twig\Template->yield (line 411)
14	Twig\Template->display (line 366)
15	Twig\Template->render (line 381)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 472)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 477)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 281)
21	App\Controller\PageController->faq (line 36)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
24	Symfony\Component\HttpKernel\Kernel->handle (line 143)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
26	require_once (line 32)
27	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\ContentBlock	27
App\Entity\NavigationItem	11
App\Entity\Faq	8
App\Entity\FaqCategory	5

Entities Mapping

Class	Mapping errors
App\Entity\FaqCategory	No errors.
App\Entity\Faq	No errors.
App\Entity\NavigationItem	No errors.
App\Entity\PdfDocument	No errors.
App\Entity\ContentBlock	No errors.

GET https://ambire.iridian.co/faq

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping