Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

2.71 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.20 ms

SELECT t0.icon AS icon_1, t0.title AS title_2, t0.slug AS slug_3, t0.json_content AS json_content_4, t0.html_content AS html_content_5, t0.excerpt AS excerpt_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM wiki_page t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "data:image/svg+xml,<svg xmlns="http:/www.w3.org/2000/svg" viewBox="0 0 128 128"><text y="1.2em" font-size="96">⚫️</text></data:image/svg+xml,<svg xmlns="http:/www.w3.org/2000/svg" viewBox="0 0 128 128"><text y="1.2em" font-size="96">⚫️</text></svg>"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.icon AS icon_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.json_content AS json_content_4,
  t0.html_content AS html_content_5,
  t0.excerpt AS excerpt_6,
  t0.id AS id_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.parent_id AS parent_id_10
FROM
  wiki_page t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.icon AS icon_1, t0.title AS title_2, t0.slug AS slug_3, t0.json_content AS json_content_4, t0.html_content AS html_content_5, t0.excerpt AS excerpt_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM wiki_page t0 WHERE t0.slug = 'data:image/svg+xml,<svg xmlns=\"http:/www.w3.org/2000/svg\" viewBox=\"0 0 128 128\"><text y=\"1.2em\" font-size=\"96\">⚫️</text></data:image/svg+xml,<svg xmlns=\"http:/www.w3.org/2000/svg\" viewBox=\"0 0 128 128\"><text y=\"1.2em\" font-size=\"96\">⚫️</text></svg>' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 119)
5	App\Controller\WikiPageController->catchAll (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

1.01 ms

SELECT t0.description AS description_1, t0.position AS position_2, t0.visible AS visible_3, t0.id AS id_4, t0.wiki_page_id AS wiki_page_id_5 FROM wiki_menu_item t0 WHERE t0.visible = ? ORDER BY t0.position ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.description AS description_1,
  t0.position AS position_2,
  t0.visible AS visible_3,
  t0.id AS id_4,
  t0.wiki_page_id AS wiki_page_id_5
FROM
  wiki_menu_item t0
WHERE
  t0.visible = ?
ORDER BY
  t0.position ASC

SELECT t0.description AS description_1, t0.position AS position_2, t0.visible AS visible_3, t0.id AS id_4, t0.wiki_page_id AS wiki_page_id_5 FROM wiki_menu_item t0 WHERE t0.visible = 1 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 20)
5	App\Repository\WikiMenuItemRepository->findActiveMenuItems (line 31)
6	App\Twig\AppExtension->getMenuItems (line 48)
7	__TwigTemplate_bb5a08dd599d59f6cfc1cea960524dac->doDisplay (line 402)
8	Twig\Template->yield (line 358)
9	Twig\Template->display (line 373)
10	Twig\Template->render (line 51)
11	Twig\TemplateWrapper->render (line 1520)
12	Twig\Extension\CoreExtension::include (line 201)
13	__TwigTemplate_a6a29c4ae14a1bc5a1b23e3aa09b1c87->block_header (line 446)
14	Twig\Template->yieldBlock (line 84)
15	__TwigTemplate_a6a29c4ae14a1bc5a1b23e3aa09b1c87->doDisplay (line 402)
16	Twig\Template->yield (line 53)
17	__TwigTemplate_804822c20951a0d880248f73a975098b->doDisplay (line 402)
18	Twig\Template->yield (line 358)
19	Twig\Template->display (line 373)
20	Twig\Template->render (line 51)
21	Twig\TemplateWrapper->render (line 333)
22	Twig\Environment->render (line 459)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 122)
26	App\Controller\WikiPageController->catchAll (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

0.50 ms

SELECT t0.icon AS icon_1, t0.title AS title_2, t0.slug AS slug_3, t0.json_content AS json_content_4, t0.html_content AS html_content_5, t0.excerpt AS excerpt_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM wiki_page t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "data:image/svg+xml,<svg xmlns="http:/www.w3.org/2000/svg" viewBox="0 0 128 128"><text y="1.2em" font-size="96">⚫️</text></data:image/svg+xml,<svg xmlns="http:/www.w3.org/2000/svg" viewBox="0 0 128 128"><text y="1.2em" font-size="96">⚫️</text></svg>"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.icon AS icon_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.json_content AS json_content_4,
  t0.html_content AS html_content_5,
  t0.excerpt AS excerpt_6,
  t0.id AS id_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.parent_id AS parent_id_10
FROM
  wiki_page t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.icon AS icon_1, t0.title AS title_2, t0.slug AS slug_3, t0.json_content AS json_content_4, t0.html_content AS html_content_5, t0.excerpt AS excerpt_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM wiki_page t0 WHERE t0.slug = 'data:image/svg+xml,<svg xmlns=\"http:/www.w3.org/2000/svg\" viewBox=\"0 0 128 128\"><text y=\"1.2em\" font-size=\"96\">⚫️</text></data:image/svg+xml,<svg xmlns=\"http:/www.w3.org/2000/svg\" viewBox=\"0 0 128 128\"><text y=\"1.2em\" font-size=\"96\">⚫️</text></svg>' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 39)
5	App\Twig\AppExtension->getBreadcrumbs (line 52)
6	__TwigTemplate_bb5a08dd599d59f6cfc1cea960524dac->doDisplay (line 402)
7	Twig\Template->yield (line 358)
8	Twig\Template->display (line 373)
9	Twig\Template->render (line 51)
10	Twig\TemplateWrapper->render (line 1520)
11	Twig\Extension\CoreExtension::include (line 201)
12	__TwigTemplate_a6a29c4ae14a1bc5a1b23e3aa09b1c87->block_header (line 446)
13	Twig\Template->yieldBlock (line 84)
14	__TwigTemplate_a6a29c4ae14a1bc5a1b23e3aa09b1c87->doDisplay (line 402)
15	Twig\Template->yield (line 53)
16	__TwigTemplate_804822c20951a0d880248f73a975098b->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 459)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 122)
25	App\Controller\WikiPageController->catchAll (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	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\Comments\CommentClosure	No errors.
App\Entity\Comments\Comment	No errors.
App\Entity\WikiPage	No errors.
App\Entity\Menu\WikiMenuItem	No errors.

Symfony Profiler

GET https://wiki.temper.digital/data%3Aimage/svg%2Bxml%2C%3Csvg%20xmlns%3D%22http%3A/www.w3.org/2000/svg%22%20viewBox%3D%220%200%20128%20128%22%3E%3Ctext%20y%3D%221…

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping