Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

5.99 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

1.57 ms

SELECT t0.id AS id_1, t0.year AS year_2, t0.type AS type_3, t0.current_year10 AS current_year10_4, t0.current_year20 AS current_year20_5, t0.current_year100 AS current_year100_6, t0.ttn_year10 AS ttn_year10_7, t0.ttn_year20 AS ttn_year20_8, t0.ttn_year100 AS ttn_year100_9, t0.prev_year10 AS prev_year10_10, t0.prev_year20 AS prev_year20_11, t0.prev_year100 AS prev_year100_12, t0.multi_year10 AS multi_year10_13, t0.multi_year20 AS multi_year20_14, t0.multi_year100 AS multi_year100_15, t0.station_id AS station_id_16 FROM productive_reserves_of_soil_moisture t0 WHERE t0.type = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.year AS year_2,
  t0.type AS type_3,
  t0.current_year10 AS current_year10_4,
  t0.current_year20 AS current_year20_5,
  t0.current_year100 AS current_year100_6,
  t0.ttn_year10 AS ttn_year10_7,
  t0.ttn_year20 AS ttn_year20_8,
  t0.ttn_year100 AS ttn_year100_9,
  t0.prev_year10 AS prev_year10_10,
  t0.prev_year20 AS prev_year20_11,
  t0.prev_year100 AS prev_year100_12,
  t0.multi_year10 AS multi_year10_13,
  t0.multi_year20 AS multi_year20_14,
  t0.multi_year100 AS multi_year100_15,
  t0.station_id AS station_id_16
FROM
  productive_reserves_of_soil_moisture t0
WHERE
  t0.type = ?

SELECT t0.id AS id_1, t0.year AS year_2, t0.type AS type_3, t0.current_year10 AS current_year10_4, t0.current_year20 AS current_year20_5, t0.current_year100 AS current_year100_6, t0.ttn_year10 AS ttn_year10_7, t0.ttn_year20 AS ttn_year20_8, t0.ttn_year100 AS ttn_year100_9, t0.prev_year10 AS prev_year10_10, t0.prev_year20 AS prev_year20_11, t0.prev_year100 AS prev_year100_12, t0.multi_year10 AS multi_year10_13, t0.multi_year20 AS multi_year20_14, t0.multi_year100 AS multi_year100_15, t0.station_id AS station_id_16 FROM productive_reserves_of_soil_moisture t0 WHERE t0.type = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 302)
4	App\Controller\PublicController->productiveReservesOfSoilMoisture (line 178)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

3.17 ms

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_14574c0c432ec0a25b2f96cf4bf5b3ec->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 310)
25	App\Controller\PublicController->productiveReservesOfSoilMoisture (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.25 ms

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:

[
  650
]

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 = 650;

#	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 153)
9	__TwigTemplate_14574c0c432ec0a25b2f96cf4bf5b3ec->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_14574c0c432ec0a25b2f96cf4bf5b3ec->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 310)
23	App\Controller\PublicController->productiveReservesOfSoilMoisture (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)

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\Agro\ProductiveReservesOfSoilMoisture	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/productiveReservesOfSoilMoisture

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping