Query Metrics
3
Database Queries
2
Different statements
16009.99 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 4258.49 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:
[
"fb6454d0f844f2b7039c0fe513086385"
]
|
2 | 967.09 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:
[ "fb6454d0f844f2b7039c0fe513086385" "98ead943a80a017f32b882dc540ebe69" ] |
3 | 10784.41 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:
[
"fb6454d0f844f2b7039c0fe513086385"
]
|
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. |