Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

17.83 ms Query time

0 Invalid entities

4 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

14.00 ms
(78.53%)

SELECT c0_.id AS id_0, c0_.tag_1 AS tag_1_1, c0_.tag_2 AS tag_2_2, c0_.tag_3 AS tag_3_3, c0_.name_content AS name_content_4, c0_.description AS description_5, c0_.url_content AS url_content_6, c0_.tags_page AS tags_page_7, c0_.text_content AS text_content_8, c0_.date_update AS date_update_9 FROM content c0_ WHERE c0_.tag_1 = 'database' AND c0_.tag_2 = 'Postgresql' AND c0_.tag_3 = 'backup' AND c0_.url_content = 'rezervnaya_kopiya_postgresql'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.tag_1 AS tag_1_1,
  c0_.tag_2 AS tag_2_2,
  c0_.tag_3 AS tag_3_3,
  c0_.name_content AS name_content_4,
  c0_.description AS description_5,
  c0_.url_content AS url_content_6,
  c0_.tags_page AS tags_page_7,
  c0_.text_content AS text_content_8,
  c0_.date_update AS date_update_9
FROM
  content c0_
WHERE
  c0_.tag_1 = 'database'
  AND c0_.tag_2 = 'Postgresql'
  AND c0_.tag_3 = 'backup'
  AND c0_.url_content = 'rezervnaya_kopiya_postgresql'

SELECT c0_.id AS id_0, c0_.tag_1 AS tag_1_1, c0_.tag_2 AS tag_2_2, c0_.tag_3 AS tag_3_3, c0_.name_content AS name_content_4, c0_.description AS description_5, c0_.url_content AS url_content_6, c0_.tags_page AS tags_page_7, c0_.text_content AS text_content_8, c0_.date_update AS date_update_9 FROM content c0_ WHERE c0_.tag_1 = 'database' AND c0_.tag_2 = 'Postgresql' AND c0_.tag_3 = 'backup' AND c0_.url_content = 'rezervnaya_kopiya_postgresql';

#	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\ContentRepository->GetBlogContent (line 78)
7	App\Controller\BlogController->ShowBlogContent (line 114)
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)

3.83 ms
(21.47%)

SELECT t0.id AS id_1, t0.content AS content_2, t0.create_time AS create_time_3, t0.post_id AS post_id_4, t0.author_id AS author_id_5, t0.answer_id AS answer_id_6 FROM comment t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.create_time AS create_time_3,
  t0.post_id AS post_id_4,
  t0.author_id AS author_id_5,
  t0.answer_id AS answer_id_6
FROM
  comment t0

SELECT t0.id AS id_1, t0.content AS content_2, t0.create_time AS create_time_3, t0.post_id AS post_id_4, t0.author_id AS author_id_5, t0.answer_id AS answer_id_6 FROM comment 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\ShowComments->getComments (line 26)
6	Twig\Extension\CoreExtension->getAttribute (line 1913)
7	__TwigTemplate_35cd21724b100640bad6925ee4f511a1::doDisplay (line 54)
8	Twig\Template->yield (line 402)
9	Twig\Template->display (line 358)
10	Twig\Template->render (line 373)
11	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
12	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
13	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
14	__TwigTemplate_7b5f30c605976fbde855eaf493785667->block_page_contents (line 174)
15	Twig\Template->yieldBlock (line 446)
16	__TwigTemplate_7b5f30c605976fbde855eaf493785667->block_content (line 78)
17	Twig\Template->yieldBlock (line 446)
18	__TwigTemplate_9932c150224aee06b842d0c51bddfa9b->doDisplay (line 141)
19	Twig\Template->yield (line 402)
20	__TwigTemplate_7b5f30c605976fbde855eaf493785667->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 459)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
29	App\Controller\BlogController->ShowBlogContent (line 122)
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)

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\Comment	2
App\Entity\Content	1
App\Entity\User	1

Entities Mapping

Class	Mapping errors
App\Entity\Content	No errors.
App\Entity\Comment	No errors.
App\Entity\User	No errors.

Symfony Profiler

GET https://test.netbash.ru/blog/database/Postgresql/backup/rezervnaya_kopiya_postgresql

Configuration Settings

Theme

Page Width