Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

5.85 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.20 ms
(37.55%)

SELECT c0_.id AS id_0, c0_.year AS year_1, c0_.month AS month_2, c0_.decade AS decade_3, c0_.avg_temp5cm AS avg_temp5cm_4, c0_.avg_temp10cm AS avg_temp10cm_5, c0_.avg_temp15cm AS avg_temp15cm_6, c0_.avg_temp20cm AS avg_temp20cm_7, c0_.id AS id_8, c0_.avg_temp5cm AS avg_temp5cm_9, c0_.avg_temp10cm AS avg_temp10cm_10, c0_.avg_temp15cm AS avg_temp15cm_11, c0_.avg_temp20cm AS avg_temp20cm_12, c1_.id AS id_13, c1_.center_lat AS center_lat_14, c1_.center_long AS center_long_15, c1_.name AS name_16 FROM csdn_agro_decade_journal c0_ LEFT JOIN csdn_station c1_ ON c0_.station_id = c1_.id WHERE c0_.year = ? AND c0_.decade = ? AND c0_.month = ? LIMIT 400

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.year AS year_1,
  c0_.month AS month_2,
  c0_.decade AS decade_3,
  c0_.avg_temp5cm AS avg_temp5cm_4,
  c0_.avg_temp10cm AS avg_temp10cm_5,
  c0_.avg_temp15cm AS avg_temp15cm_6,
  c0_.avg_temp20cm AS avg_temp20cm_7,
  c0_.id AS id_8,
  c0_.avg_temp5cm AS avg_temp5cm_9,
  c0_.avg_temp10cm AS avg_temp10cm_10,
  c0_.avg_temp15cm AS avg_temp15cm_11,
  c0_.avg_temp20cm AS avg_temp20cm_12,
  c1_.id AS id_13,
  c1_.center_lat AS center_lat_14,
  c1_.center_long AS center_long_15,
  c1_.name AS name_16
FROM
  csdn_agro_decade_journal c0_
  LEFT JOIN csdn_station c1_ ON c0_.station_id = c1_.id
WHERE
  c0_.year = ?
  AND c0_.decade = ?
  AND c0_.month = ?
LIMIT
  400

SELECT c0_.id AS id_0, c0_.year AS year_1, c0_.month AS month_2, c0_.decade AS decade_3, c0_.avg_temp5cm AS avg_temp5cm_4, c0_.avg_temp10cm AS avg_temp10cm_5, c0_.avg_temp15cm AS avg_temp15cm_6, c0_.avg_temp20cm AS avg_temp20cm_7, c0_.id AS id_8, c0_.avg_temp5cm AS avg_temp5cm_9, c0_.avg_temp10cm AS avg_temp10cm_10, c0_.avg_temp15cm AS avg_temp15cm_11, c0_.avg_temp20cm AS avg_temp20cm_12, c1_.id AS id_13, c1_.center_lat AS center_lat_14, c1_.center_long AS center_long_15, c1_.name AS name_16 FROM csdn_agro_decade_journal c0_ LEFT JOIN csdn_station c1_ ON c0_.station_id = c1_.id WHERE c0_.year = 2025 AND c0_.decade = 1 AND c0_.month = 7 LIMIT 400;

#	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 43)
7	App\Repository\CSDN\AgroDecadeJournalRepository->findDataForDecade (line 298)
8	App\Controller\PublicController->average10DayTemperatureSoilDepth (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

2.15 ms
(36.73%)

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_2309633348b2d024bb70bafbee27676c->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 300)
25	App\Controller\PublicController->average10DayTemperatureSoilDepth (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.51 ms
(25.73%)

SELECT t0.id AS id_1, t0.year AS year_2, t0.month AS month_3, t0.decade AS decade_4, t0.avg_temp5cm AS avg_temp5cm_5, t0.avg_temp10cm AS avg_temp10cm_6, t0.avg_temp15cm AS avg_temp15cm_7, t0.avg_temp20cm AS avg_temp20cm_8, t0.station_id AS station_id_9 FROM csdn_agro_decade_journal 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.month AS month_3,
  t0.decade AS decade_4,
  t0.avg_temp5cm AS avg_temp5cm_5,
  t0.avg_temp10cm AS avg_temp10cm_6,
  t0.avg_temp15cm AS avg_temp15cm_7,
  t0.avg_temp20cm AS avg_temp20cm_8,
  t0.station_id AS station_id_9
FROM
  csdn_agro_decade_journal t0

SELECT t0.id AS id_1, t0.year AS year_2, t0.month AS month_3, t0.decade AS decade_4, t0.avg_temp5cm AS avg_temp5cm_5, t0.avg_temp10cm AS avg_temp10cm_6, t0.avg_temp15cm AS avg_temp15cm_7, t0.avg_temp20cm AS avg_temp20cm_8, t0.station_id AS station_id_9 FROM csdn_agro_decade_journal 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 276)
6	App\Controller\PublicController->average10DayTemperatureSoilDepth (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\AgroDecadeJournal	No errors.
App\Entity\CSDN\Station	No errors.
App\Entity\Content\Menu	No errors.
App\Entity\Content\MenuGroup	No errors.

Symfony Profiler

GET http://212.112.125.69:8080/average10DayTemperatureSoilDepth

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping