Query Metrics
11
Database Queries
9
Different statements
10.60 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2.13 ms |
SELECT t0.id AS id_1, t0.name_ru AS name_ru_2, t0.name_kg AS name_kg_3, t0.name_en AS name_en_4, t0.description_ru AS description_ru_5, t0.description_kg AS description_kg_6, t0.description_en AS description_en_7, t0.center_lat AS center_lat_8, t0.center_long AS center_long_9, t0.height AS height_10, t0.geo_json_file AS geo_json_file_11, t0.options AS options_12, t0.type AS type_13, t0.exclude_from_forecast AS exclude_from_forecast_14, t0.sort_index AS sort_index_15, t0.slug AS slug_16, t0.parent_id AS parent_id_17 FROM place t0 WHERE t0.type = ? ORDER BY t0.sort_index ASC
Parameters:
[
2
]
|
||||||||||||||||||||||||||||
2 | 0.51 ms |
SELECT t0.id AS id_1, t0.name_ru AS name_ru_2, t0.name_kg AS name_kg_3, t0.name_en AS name_en_4, t0.description_ru AS description_ru_5, t0.description_kg AS description_kg_6, t0.description_en AS description_en_7, t0.center_lat AS center_lat_8, t0.center_long AS center_long_9, t0.height AS height_10, t0.geo_json_file AS geo_json_file_11, t0.options AS options_12, t0.type AS type_13, t0.exclude_from_forecast AS exclude_from_forecast_14, t0.sort_index AS sort_index_15, t0.slug AS slug_16, t0.parent_id AS parent_id_17 FROM place t0 WHERE t0.parent_id = ? AND t0.type = ?
Parameters:
[ 21 7 ]
|
||||||||||||||||||||||||||||
3 | 1.42 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.short_forecast_ru AS short_forecast_ru_3, t0.short_forecast_kg AS short_forecast_kg_4, t0.short_forecast_en AS short_forecast_en_5, t0.created_at AS created_at_6, t0.date_key AS date_key_7, t0.place_id AS place_id_8 FROM daily_weather_forecast t0 WHERE t0.place_id = ? AND t0.date_key = ? LIMIT 1
Parameters:
[ 21 "2025-07-08" ]
|
||||||||||||||||||||||||||||
4 | 0.40 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.short_forecast_ru AS short_forecast_ru_3, t0.short_forecast_kg AS short_forecast_kg_4, t0.short_forecast_en AS short_forecast_en_5, t0.created_at AS created_at_6, t0.date_key AS date_key_7, t0.place_id AS place_id_8 FROM daily_weather_forecast t0 WHERE t0.place_id = ? AND t0.date_key = ? LIMIT 1
Parameters:
[ 21 "2025-07-09" ]
|
||||||||||||||||||||||||||||
5 | 0.37 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.short_forecast_ru AS short_forecast_ru_3, t0.short_forecast_kg AS short_forecast_kg_4, t0.short_forecast_en AS short_forecast_en_5, t0.created_at AS created_at_6, t0.date_key AS date_key_7, t0.place_id AS place_id_8 FROM daily_weather_forecast t0 WHERE t0.place_id = ? AND t0.date_key = ? LIMIT 1
Parameters:
[ 21 "2025-07-10" ]
|
||||||||||||||||||||||||||||
6 | 1.00 ms |
SELECT t0.id AS id_1, t0.message_ru AS message_ru_2, t0.message_kg AS message_kg_3, t0.message_en AS message_en_4, t0.level AS level_5, t0.area_level AS area_level_6, t0.start_date AS start_date_7, t0.end_date AS end_date_8, t0.type AS type_9, t0.hazard_type_id AS hazard_type_id_10, t0.place_id AS place_id_11 FROM meteo_alarm t0 WHERE t0.type IN (?, ?, ?, ?)
Parameters:
[ "main_page" "main_page_alarm" "main_page_avalanche" "main_page_hydro" ]
|
||||||||||||||||||||||||||||
7 | 0.48 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.icon_night AS icon_night_3, t0.code AS code_4, t0.name_ru AS name_ru_5, t0.name_kg AS name_kg_6, t0.name_en AS name_en_7 FROM weather_type t0
Parameters:
[]
|
||||||||||||||||||||||||||||
8 | 0.42 ms |
SELECT t0.id AS id_1, t0.setting_name AS setting_name_2, t0.setting_value AS setting_value_3 FROM system_settings t0 WHERE t0.setting_name = ? LIMIT 1
Parameters:
[
"forecast_days_count"
]
|
||||||||||||||||||||||||||||
9 | 1.50 ms |
SELECT c0_.id AS id_0, c0_.csdn_index AS csdn_index_1, c0_.name AS name_2, c0_.code AS code_3, c0_.alt AS alt_4, c0_.time_shift AS time_shift_5, c0_.mzone AS mzone_6, c0_.first_point AS first_point_7, c0_.points_count AS points_count_8, c0_.phones AS phones_9, c0_.active AS active_10, c0_.center_lat AS center_lat_11, c0_.center_long AS center_long_12, c0_.id AS id_13, c0_.name AS name_14, p1_.name_kg AS name_kg_15 FROM csdn_station c0_ LEFT JOIN place p1_ ON c0_.place_id = p1_.id WHERE p1_.type = ?
Parameters:
[
2
]
|
||||||||||||||||||||||||||||
10 | 0.51 ms |
SELECT t0.id AS id_1, t0.name_ru AS name_ru_2, t0.name_kg AS name_kg_3, t0.name_en AS name_en_4, t0.description_ru AS description_ru_5, t0.description_kg AS description_kg_6, t0.description_en AS description_en_7, t0.file AS file_8 FROM map t0
Parameters:
[]
|
||||||||||||||||||||||||||||
11 | 1.85 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"
]
|
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\Place | No errors. |
App\Entity\DailyWeatherForecast | No errors. |
App\Entity\Alarm | No errors. |
App\Entity\HazardType | No errors. |
App\Entity\WeatherType | No errors. |
App\Entity\SystemSettings | No errors. |
App\Entity\CSDN\Station | No errors. |
App\Entity\Agro\Map | No errors. |
App\Entity\Content\Menu | No errors. |
App\Entity\Content\MenuGroup | No errors. |