Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

4.11 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.67 ms
(64.87%)

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 316)
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.44 ms
(35.13%)

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:

[
  "2"
]

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 = '2';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 308)
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)

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.

Symfony Profiler

GET http://mail2.meteo.kg:8080/ru/productiveReservesOfSoilMoisture?type=2

Configuration Settings

Theme