Symfony Profiler

Last 10 Latest Search

Method

Status

URL

Token

From

Until

Results

Profiler settings

Query Metrics

10 Database Queries

7 Different statements

18.11 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.56 ms
(25.16%)

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 28)
6	App\Controller\frontend\IndexController->index (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)

3.16 ms
(17.47%)

SELECT t0.id AS id_1, t0.content AS content_2, t0.answer AS answer_3, t0.category_id AS category_id_4, t0.language_id AS language_id_5 FROM question t0 WHERE t0.language_id = ? LIMIT 6

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.answer AS answer_3,
  t0.category_id AS category_id_4,
  t0.language_id AS language_id_5
FROM
  question t0
WHERE
  t0.language_id = ?
LIMIT
  6

SELECT t0.id AS id_1, t0.content AS content_2, t0.answer AS answer_3, t0.category_id AS category_id_4, t0.language_id AS language_id_5 FROM question t0 WHERE t0.language_id = 1 LIMIT 6;

#	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\QuestionService->getQuestion (line 93)
5	App\Controller\frontend\IndexController->questionwidget (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 78)
13	__TwigTemplate_061509e14d1edf7f5c4266f05046718f->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_061509e14d1edf7f5c4266f05046718f->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 29)
26	App\Controller\frontend\IndexController->index (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)

3.06 ms
(16.90%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.icon AS icon_3, t0.description AS description_4, t0.language_id AS language_id_5 FROM service 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.icon AS icon_3,
  t0.description AS description_4,
  t0.language_id AS language_id_5
FROM
  service t0
WHERE
  t0.language_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.icon AS icon_3, t0.description AS description_4, t0.language_id AS language_id_5 FROM service 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\ServiceService->getService (line 119)
5	App\Controller\frontend\IndexController->servicewidget (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 73)
13	__TwigTemplate_061509e14d1edf7f5c4266f05046718f->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_061509e14d1edf7f5c4266f05046718f->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 29)
26	App\Controller\frontend\IndexController->index (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)

2.51 ms
(13.85%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.position AS position_3, t0.description AS description_4, t0.image AS image_5 FROM testimony t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.position AS position_3,
  t0.description AS description_4,
  t0.image AS image_5
FROM
  testimony t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.position AS position_3, t0.description AS description_4, t0.image AS image_5 FROM testimony 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\TestimonyService->getTestimony (line 87)
5	App\Controller\frontend\IndexController->testimonywidget (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 82)
13	__TwigTemplate_061509e14d1edf7f5c4266f05046718f->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_061509e14d1edf7f5c4266f05046718f->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 29)
26	App\Controller\frontend\IndexController->index (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)

2.38 ms
(13.15%)

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_061509e14d1edf7f5c4266f05046718f->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 29)
26	App\Controller\frontend\IndexController->index (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.98 ms
(10.94%)

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 87)
13	__TwigTemplate_061509e14d1edf7f5c4266f05046718f->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_061509e14d1edf7f5c4266f05046718f->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 29)
26	App\Controller\frontend\IndexController->index (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.46 ms
(2.52%)

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_061509e14d1edf7f5c4266f05046718f->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 29)
24	App\Controller\frontend\IndexController->index (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.
App\Entity\Testimony	No errors.

Symfony Profiler

GET https://hejerbenjeddi-gastro.com/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255Cfrontend%255CIndexController%253A%253Ablog…

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping