Query Metrics
3
Database Queries
2
Different statements
20430.09 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 7641.03 ms |
SELECT t0.id AS id_1, t0.hash_basic AS hash_basic_2, t0.route_name AS route_name_3, t0.distance_km AS distance_km_4, t0.time_min AS time_min_5, t0.polyline AS polyline_6, t0.segments AS segments_7, t0.query_url AS query_url_8, t0.params AS params_9 FROM route_hash_table t0 WHERE t0.hash_basic = ? LIMIT 1
Parameters:
[
"8059d4c6707bbc7e285cd29e084544dc"
]
|
2 | 1250.31 ms |
SELECT t0.id AS id_1, t0.day_no AS day_no_2, t0.days_total AS days_total_3, t0.city_from AS city_from_4, t0.city_to AS city_to_5, t0.route_data AS route_data_6, t0.hash_basic AS hash_basic_7, t0.hash_full AS hash_full_8, t0.applied_params AS applied_params_9 FROM route_hash_block t0 WHERE t0.hash_basic = ? AND t0.hash_full = ? LIMIT 1
Parameters:
[ "8059d4c6707bbc7e285cd29e084544dc" "70b76bd7aaca76cc1cc00d9e98f0500b" ] |
3 | 11538.75 ms |
SELECT t0.id AS id_1, t0.hash_basic AS hash_basic_2, t0.route_name AS route_name_3, t0.distance_km AS distance_km_4, t0.time_min AS time_min_5, t0.polyline AS polyline_6, t0.segments AS segments_7, t0.query_url AS query_url_8, t0.params AS params_9 FROM route_hash_table t0 WHERE t0.hash_basic = ? LIMIT 1
Parameters:
[
"8059d4c6707bbc7e285cd29e084544dc"
]
|
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\RouteHashTable | No errors. |
App\Entity\RouteHashBlock | No errors. |