Query Metrics
5
Database Queries
4
Different statements
24.85 ms
Query time
0
Invalid entities
7
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
16.52 ms (66.47%) |
1 |
SELECT t0.id AS id_1, t0.admin_only AS admin_only_2, t0.is_active AS is_active_3, t0.date_start AS date_start_4, t0.date_end AS date_end_5, t0.last_scraped AS last_scraped_6, t0.return_leg AS return_leg_7, t0.grouping_x AS grouping_x_8, t0.departure_city_id AS departure_city_id_9, t0.arrival_city_id AS arrival_city_id_10 FROM flight_destinations t0 WHERE t0.id = ?
Parameters:
[
"1821"
]
|
|
4.90 ms (19.73%) |
2 |
SELECT t0.id AS id_1, t0.city AS city_2, t0.airport_code AS airport_code_3, t0.include_in_flight_prices AS include_in_flight_prices_4, t0.country_id AS country_id_5 FROM airports t0 WHERE t0.id = ?
Parameters:
[
3
]
|
|
2.73 ms (10.98%) |
1 |
SELECT t0.id AS id_1, t0.flight_stats_days AS flight_stats_days_2, t0.flight_stats_start_date AS flight_stats_start_date_3, t0.investment_date AS investment_date_4, t0.flight_stats_return_leg_offset AS flight_stats_return_leg_offset_5, t0.last_outlook_download AS last_outlook_download_6, t0.uk_days_start_date AS uk_days_start_date_7 FROM settings t0 WHERE t0.id = ?
Parameters:
[
"1"
]
|
|
0.70 ms (2.82%) |
1 |
SELECT t0.id AS id_1, t0.language AS language_2, t0.abbreviation AS abbreviation_3, t0.icon AS icon_4, t0.is_active AS is_active_5, t0.linked_in_other AS linked_in_other_6, t0.ranking AS ranking_7 FROM languages t0 WHERE t0.abbreviation = ? LIMIT 1
Parameters:
[
"en"
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Airports | 2 |
| App\Entity\Country | 2 |
| App\Entity\Languages | 1 |
| App\Entity\Settings | 1 |
| App\Entity\FlightDestinations | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Languages | No errors. |
| App\Entity\Settings | No errors. |
| App\Entity\FlightDestinations | No errors. |
| App\Entity\Airports | No errors. |
| App\Entity\Country | No errors. |