GET https://stephen-nurse.com/houseguests/flight/price/scrape_one_destination/1821

Query Metrics

5 Database Queries
4 Different statements
24.85 ms Query time
0 Invalid entities
7 Managed entities

Queries

Group similar statements

# Time Info
1 0.70 ms
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"
]
2 2.73 ms
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"
]
3 16.52 ms
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 1.14 ms
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
]
5 3.77 ms
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:
[
  20
]

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.