GET http://mail2.meteo.kg:8080/ru/average10DayTemperatureSoilDepth

Query Metrics

3 Database Queries
3 Different statements
5.94 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.24 ms
(37.72%)
1
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"
]
2.23 ms
(37.44%)
1
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:
[
  2025
  1
  7
]
1.48 ms
(24.84%)
1
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:
[]

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