Symfony Profiler

Last 10 Latest Search

Method

Status

URL

Token

From

Until

Results

Profiler settings

Query Metrics

4 Database Queries

3 Different statements

7.48 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

2.34 ms

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

1.79 ms

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 = ?

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 = ?

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;

#	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 59)
5	App\Controller\frontend\IndexController->blog (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.89 ms

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 118)
6	App\Controller\frontend\IndexController->servicewidget (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
9	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
10	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
11	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
12	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
13	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 181)
14	__TwigTemplate_0f20a38adfd54f79082f4ccdd6028b0d->block_body (line 171)
15	Twig\Template->displayBlock (line 362)
16	__TwigTemplate_2d8e353012f8052e4be879ac08973513->doDisplay (line 394)
17	Twig\Template->displayWithErrorHandling (line 367)
18	Twig\Template->display (line 49)
19	__TwigTemplate_0f20a38adfd54f79082f4ccdd6028b0d->doDisplay (line 394)
20	Twig\Template->displayWithErrorHandling (line 367)
21	Twig\Template->display (line 379)
22	Twig\Template->render (line 38)
23	Twig\TemplateWrapper->render (line 280)
24	Twig\Environment->render (line 243)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 60)
27	App\Controller\frontend\IndexController->blog (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

2.46 ms

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 181)
13	__TwigTemplate_0f20a38adfd54f79082f4ccdd6028b0d->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 49)
18	__TwigTemplate_0f20a38adfd54f79082f4ccdd6028b0d->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 60)
26	App\Controller\frontend\IndexController->blog (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)

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.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping