Symfony Profiler

Last 10 Latest Search

Method

Status

URL

Token

From

Until

Results

Profiler settings

Query Metrics

6 Database Queries

5 Different statements

17.60 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

5.47 ms
(31.08%)

SELECT t0.id AS id_1, t0.abbreviation AS abbreviation_2, t0.icon AS icon_3 FROM language t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.abbreviation AS abbreviation_2,
  t0.icon AS icon_3
FROM
  language t0

SELECT t0.id AS id_1, t0.abbreviation AS abbreviation_2, t0.icon AS icon_3 FROM language t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 48)
4	App\Service\LanguageService->getLanguage (line 50)
5	App\Service\CommonFunctionsService->getLanguage (line 66)
6	App\Controller\frontend\IndexController->detailsblog (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

5.31 ms
(30.16%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.detailed_description AS detailed_description_4, t0.image AS image_5, t0.images AS images_6, t0.active AS active_7, t0.created_at AS created_at_8, t0.alias AS alias_9, t0.language_id AS language_id_10 FROM blog t0 WHERE t0.alias = ? LIMIT 1

Parameters:

[
  "comment-preparer-coloscopie"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.detailed_description AS detailed_description_4,
  t0.image AS image_5,
  t0.images AS images_6,
  t0.active AS active_7,
  t0.created_at AS created_at_8,
  t0.alias AS alias_9,
  t0.language_id AS language_id_10
FROM
  blog t0
WHERE
  t0.alias = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.detailed_description AS detailed_description_4, t0.image AS image_5, t0.images AS images_6, t0.active AS active_7, t0.created_at AS created_at_8, t0.alias AS alias_9, t0.language_id AS language_id_10 FROM blog t0 WHERE t0.alias = 'comment-preparer-coloscopie' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 368)
4	Doctrine\ORM\EntityRepository->resolveMagicCall (line 276)
5	Doctrine\ORM\EntityRepository->__call (line 46)
6	App\Service\BlogService->getAlias (line 67)
7	App\Controller\frontend\IndexController->detailsblog (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

4.64 ms
(26.37%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.button AS button_5, t0.link AS link_6, t0.type AS type_7, t0.language_id AS language_id_8 FROM banner t0 WHERE t0.language_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.image AS image_4,
  t0.button AS button_5,
  t0.link AS link_6,
  t0.type AS type_7,
  t0.language_id AS language_id_8
FROM
  banner t0
WHERE
  t0.language_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.button AS button_5, t0.link AS link_6, t0.type AS type_7, t0.language_id AS language_id_8 FROM banner t0 WHERE t0.language_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 48)
4	App\Service\BannerService->getBanner (line 81)
5	App\Controller\frontend\IndexController->banner (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
8	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
9	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
10	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
11	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
12	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 640)
13	__TwigTemplate_2d8e353012f8052e4be879ac08973513->block_banner (line 171)
14	Twig\Template->displayBlock (line 357)
15	__TwigTemplate_2d8e353012f8052e4be879ac08973513->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 48)
18	__TwigTemplate_27b0c27d1b413b939abfd1d65119bddd->doDisplay (line 394)
19	Twig\Template->displayWithErrorHandling (line 367)
20	Twig\Template->display (line 379)
21	Twig\Template->render (line 38)
22	Twig\TemplateWrapper->render (line 280)
23	Twig\Environment->render (line 243)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 68)
26	App\Controller\frontend\IndexController->detailsblog (line 181)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

1.42 ms
(8.07%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.detailed_description AS detailed_description_4, t0.image AS image_5, t0.images AS images_6, t0.active AS active_7, t0.created_at AS created_at_8, t0.alias AS alias_9, t0.language_id AS language_id_10 FROM blog t0 WHERE t0.language_id = ? LIMIT 3

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.detailed_description AS detailed_description_4,
  t0.image AS image_5,
  t0.images AS images_6,
  t0.active AS active_7,
  t0.created_at AS created_at_8,
  t0.alias AS alias_9,
  t0.language_id AS language_id_10
FROM
  blog t0
WHERE
  t0.language_id = ?
LIMIT
  3

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.detailed_description AS detailed_description_4, t0.image AS image_5, t0.images AS images_6, t0.active AS active_7, t0.created_at AS created_at_8, t0.alias AS alias_9, t0.language_id AS language_id_10 FROM blog t0 WHERE t0.language_id = 1 LIMIT 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 58)
4	App\Service\BlogService->getBlog (line 99)
5	App\Controller\frontend\IndexController->blogwidget (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
8	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
9	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
10	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
11	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
12	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 116)
13	__TwigTemplate_27b0c27d1b413b939abfd1d65119bddd->block_body (line 171)
14	Twig\Template->displayBlock (line 362)
15	__TwigTemplate_2d8e353012f8052e4be879ac08973513->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 48)
18	__TwigTemplate_27b0c27d1b413b939abfd1d65119bddd->doDisplay (line 394)
19	Twig\Template->displayWithErrorHandling (line 367)
20	Twig\Template->display (line 379)
21	Twig\Template->render (line 38)
22	Twig\TemplateWrapper->render (line 280)
23	Twig\Environment->render (line 243)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 68)
26	App\Controller\frontend\IndexController->detailsblog (line 181)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

0.76 ms
(4.32%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.detailed_description AS detailed_description_4, t0.image AS image_5, t0.images AS images_6, t0.active AS active_7, t0.created_at AS created_at_8, t0.alias AS alias_9, t0.language_id AS language_id_10 FROM blog t0 WHERE t0.language_id = ? LIMIT 4

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.detailed_description AS detailed_description_4,
  t0.image AS image_5,
  t0.images AS images_6,
  t0.active AS active_7,
  t0.created_at AS created_at_8,
  t0.alias AS alias_9,
  t0.language_id AS language_id_10
FROM
  blog t0
WHERE
  t0.language_id = ?
LIMIT
  4

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.detailed_description AS detailed_description_4, t0.image AS image_5, t0.images AS images_6, t0.active AS active_7, t0.created_at AS created_at_8, t0.alias AS alias_9, t0.language_id AS language_id_10 FROM blog t0 WHERE t0.language_id = 1 LIMIT 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 58)
4	App\Service\BlogService->getBlog (line 106)
5	App\Controller\frontend\IndexController->blogfooter (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
8	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
9	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
10	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
11	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
12	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 413)
13	__TwigTemplate_2d8e353012f8052e4be879ac08973513->doDisplay (line 394)
14	Twig\Template->displayWithErrorHandling (line 367)
15	Twig\Template->display (line 48)
16	__TwigTemplate_27b0c27d1b413b939abfd1d65119bddd->doDisplay (line 394)
17	Twig\Template->displayWithErrorHandling (line 367)
18	Twig\Template->display (line 379)
19	Twig\Template->render (line 38)
20	Twig\TemplateWrapper->render (line 280)
21	Twig\Environment->render (line 243)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 68)
24	App\Controller\frontend\IndexController->detailsblog (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	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.

Entities Mapping

Class	Mapping errors
App\Entity\Language	No errors.
App\Entity\Banner	No errors.
App\Entity\Blog	No errors.
App\Entity\Service	No errors.
App\Entity\Question	No errors.
App\Entity\Category	No errors.

Symfony Profiler

GET http://hejerbenjeddi-gastro.com/detailsblog/comment-preparer-coloscopie

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping