Symfony Profiler

Query Metrics

67 Database Queries

3 Different statements

32.31 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

27.37 ms
(84.70%)

SELECT t0.id AS id_1, t0.csdn_index AS csdn_index_2, t0.name AS name_3, t0.code AS code_4, t0.alt AS alt_5, t0.time_shift AS time_shift_6, t0.mzone AS mzone_7, t0.first_point AS first_point_8, t0.points_count AS points_count_9, t0.phones AS phones_10, t0.active AS active_11, t0.center_lat AS center_lat_12, t0.center_long AS center_long_13, t0.place_id AS place_id_14 FROM csdn_station t0 WHERE t0.id = ?

Parameters:

[
  658
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.csdn_index AS csdn_index_2,
  t0.name AS name_3,
  t0.code AS code_4,
  t0.alt AS alt_5,
  t0.time_shift AS time_shift_6,
  t0.mzone AS mzone_7,
  t0.first_point AS first_point_8,
  t0.points_count AS points_count_9,
  t0.phones AS phones_10,
  t0.active AS active_11,
  t0.center_lat AS center_lat_12,
  t0.center_long AS center_long_13,
  t0.place_id AS place_id_14
FROM
  csdn_station t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.csdn_index AS csdn_index_2, t0.name AS name_3, t0.code AS code_4, t0.alt AS alt_5, t0.time_shift AS time_shift_6, t0.mzone AS mzone_7, t0.first_point AS first_point_8, t0.points_count AS points_count_9, t0.phones AS phones_10, t0.active AS active_11, t0.center_lat AS center_lat_12, t0.center_long AS center_long_13, t0.place_id AS place_id_14 FROM csdn_station t0 WHERE t0.id = 658;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 221)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 61)
5	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 120)
6	Proxies\__CG__\App\Entity\CSDN\Station->__get (line 91)
7	App\Entity\CSDN\Station->getName (line 1635)
8	twig_get_attribute (line 131)
9	__TwigTemplate_67ff90bd886e7734d9c6b7ddaeb83208->block_body (line 171)
10	Twig\Template->displayBlock (line 238)
11	__TwigTemplate_ffea12241bf38eb2cb6abbf83282c1f4->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 51)
14	__TwigTemplate_67ff90bd886e7734d9c6b7ddaeb83208->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 379)
17	Twig\Template->render (line 38)
18	Twig\TemplateWrapper->render (line 280)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 246)
23	App\Controller\PublicController->sum5Temp (line 178)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

3.16 ms
(9.79%)

SELECT c0_.id AS id_0, c0_.url AS url_1, c0_.sort_index AS sort_index_2, c0_.title_ru AS title_ru_3, c0_.title_kg AS title_kg_4, c0_.title_en AS title_en_5, c0_.image AS image_6, c1_.id AS id_7 FROM content_menu c0_ LEFT JOIN content_menu c1_ ON c0_.parent_id = c1_.id LEFT JOIN content_menu_group c2_ ON c0_.group_id = c2_.id WHERE c2_.alias = ? AND c0_.published = TRUE ORDER BY c0_.sort_index ASC

Parameters:

[
  "main-menu"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.url AS url_1,
  c0_.sort_index AS sort_index_2,
  c0_.title_ru AS title_ru_3,
  c0_.title_kg AS title_kg_4,
  c0_.title_en AS title_en_5,
  c0_.image AS image_6,
  c1_.id AS id_7
FROM
  content_menu c0_
  LEFT JOIN content_menu c1_ ON c0_.parent_id = c1_.id
  LEFT JOIN content_menu_group c2_ ON c0_.group_id = c2_.id
WHERE
  c2_.alias = ?
  AND c0_.published = TRUE
ORDER BY
  c0_.sort_index ASC

SELECT c0_.id AS id_0, c0_.url AS url_1, c0_.sort_index AS sort_index_2, c0_.title_ru AS title_ru_3, c0_.title_kg AS title_kg_4, c0_.title_en AS title_en_5, c0_.image AS image_6, c1_.id AS id_7 FROM content_menu c0_ LEFT JOIN content_menu c1_ ON c0_.parent_id = c1_.id LEFT JOIN content_menu_group c2_ ON c0_.group_id = c2_.id WHERE c2_.alias = 'main-menu' AND c0_.published = TRUE ORDER BY c0_.sort_index ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 701)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 29)
7	App\Repository\Content\MenuRepository->findMenuItemsByGroupAlias (line 15)
8	App\Service\Menu\MenuBuilder->createMainMenu (line 36)
9	App\Twig\MenuExtension->getMenuMain (line 47)
10	__TwigTemplate_0a5f7cfe21eead9f1aecd01afbd23533->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 170)
13	__TwigTemplate_ffea12241bf38eb2cb6abbf83282c1f4->doDisplay (line 394)
14	Twig\Template->displayWithErrorHandling (line 367)
15	Twig\Template->display (line 51)
16	__TwigTemplate_67ff90bd886e7734d9c6b7ddaeb83208->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 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 246)
25	App\Controller\PublicController->sum5Temp (line 178)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

1.78 ms
(5.51%)

SELECT t0.id AS id_1, t0.year AS year_2, t0.active_temp5_sum AS active_temp5_sum_3, t0.active_temp10_sum AS active_temp10_sum_4, t0.active_temp5_days_count AS active_temp5_days_count_5, t0.active_temp10_days_count AS active_temp10_days_count_6, t0.vegetation_start_date AS vegetation_start_date_7, t0.vegetation10_start_date AS vegetation10_start_date_8, t0.vegetation_end_date AS vegetation_end_date_9, t0.station_id AS station_id_10 FROM csdn_agro_station_indicators_by_year t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.year AS year_2,
  t0.active_temp5_sum AS active_temp5_sum_3,
  t0.active_temp10_sum AS active_temp10_sum_4,
  t0.active_temp5_days_count AS active_temp5_days_count_5,
  t0.active_temp10_days_count AS active_temp10_days_count_6,
  t0.vegetation_start_date AS vegetation_start_date_7,
  t0.vegetation10_start_date AS vegetation10_start_date_8,
  t0.vegetation_end_date AS vegetation_end_date_9,
  t0.station_id AS station_id_10
FROM
  csdn_agro_station_indicators_by_year t0

SELECT t0.id AS id_1, t0.year AS year_2, t0.active_temp5_sum AS active_temp5_sum_3, t0.active_temp10_sum AS active_temp10_sum_4, t0.active_temp5_days_count AS active_temp5_days_count_5, t0.active_temp10_days_count AS active_temp10_days_count_6, t0.vegetation_start_date AS vegetation_start_date_7, t0.vegetation10_start_date AS vegetation10_start_date_8, t0.vegetation_end_date AS vegetation_end_date_9, t0.station_id AS station_id_10 FROM csdn_agro_station_indicators_by_year t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 236)
6	App\Controller\PublicController->sum5Temp (line 178)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	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\CSDN\AgroStationIndicatorsByYear	No errors.
App\Entity\CSDN\Station	No errors.
App\Entity\Content\Menu	No errors.
App\Entity\Content\MenuGroup	No errors.
App\Entity\Place	No errors.

Symfony Profiler

GET http://agro.meteo.kg/sum5Temp

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping