Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.00 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.46 ms

SELECT c0_.id AS id_0, c0_.views AS views_1, c0_.main_image_id AS main_image_id_2, c0_.province_id AS province_id_3 FROM city c0_ ORDER BY c0_.views DESC LIMIT 6

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.views AS views_1,
  c0_.main_image_id AS main_image_id_2,
  c0_.province_id AS province_id_3
FROM
  city c0_
ORDER BY
  c0_.views DESC
LIMIT
  6

SELECT c0_.id AS id_0, c0_.views AS views_1, c0_.main_image_id AS main_image_id_2, c0_.province_id AS province_id_3 FROM city c0_ ORDER BY c0_.views DESC LIMIT 6;

#	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\CityRepository->findMostViewed (line 58)
7	App\Controller\HomeController->index (line 23)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
10	Symfony\Component\HttpKernel\Kernel->handle (line 143)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 5)

0.54 ms

SELECT t0.id AS id_1, t0.area AS area_2 FROM region t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.area AS area_2
FROM
  region t0

SELECT t0.id AS id_1, t0.area AS area_2 FROM region t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 111)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	Doctrine\ORM\EntityRepository->findAll (line 97)
5	App\Twig\AppExtension->getRegionsByArea (line 27)
6	__TwigTemplate_6e19900cb81c097c39204cf64944f2fa->doDisplay (line 137)
7	Twig\Template->yield (line 447)
8	__TwigTemplate_b3ed813ac288f230414d002ebedec6fb->doDisplay (line 56)
9	Twig\Template->yield (line 447)
10	Twig\Template->display (line 402)
11	Twig\Template->render (line 417)
12	Twig\TemplateWrapper->render (line 53)
13	Twig\Environment->render (line 333)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 472)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 477)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 281)
17	App\Controller\HomeController->index (line 22)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
20	Symfony\Component\HttpKernel\Kernel->handle (line 143)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
22	require_once (line 32)
23	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\City	No errors.
App\Entity\Image	No errors.
App\Entity\Province	No errors.
App\Entity\Region	No errors.

GET https://www.condescending-keller.89-46-65-47.plesk.page/en

Configuration Settings

Theme

Page Width