Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 27
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Migrations 2
• Messages
• Emails
• Serializer
• EasyAdmin
• Configuration

Query Metrics

SELECT t0.route_code AS route_code_1, t0.from_location AS from_location_2, t0.to_location AS to_location_3, t0.miles_economy AS miles_economy_4, t0.miles_premium_economy AS miles_premium_economy_5, t0.miles_business AS miles_business_6, t0.miles_first AS miles_first_7, t0.tax_economy AS tax_economy_8, t0.tax_premium_economy AS tax_premium_economy_9, t0.tax_business AS tax_business_10, t0.tax_first AS tax_first_11, t0.tax_currency AS tax_currency_12 FROM flight_route t0 WHERE t0.route_code = ?

[
  "FRASIN"
]

SELECT
  t0.route_code AS route_code_1,
  t0.from_location AS from_location_2,
  t0.to_location AS to_location_3,
  t0.miles_economy AS miles_economy_4,
  t0.miles_premium_economy AS miles_premium_economy_5,
  t0.miles_business AS miles_business_6,
  t0.miles_first AS miles_first_7,
  t0.tax_economy AS tax_economy_8,
  t0.tax_premium_economy AS tax_premium_economy_9,
  t0.tax_business AS tax_business_10,
  t0.tax_first AS tax_first_11,
  t0.tax_currency AS tax_currency_12
FROM
  flight_route t0
WHERE
  t0.route_code = ?

SELECT t0.route_code AS route_code_1, t0.from_location AS from_location_2, t0.to_location AS to_location_3, t0.miles_economy AS miles_economy_4, t0.miles_premium_economy AS miles_premium_economy_5, t0.miles_business AS miles_business_6, t0.miles_first AS miles_first_7, t0.tax_economy AS tax_economy_8, t0.tax_premium_economy AS tax_premium_economy_9, t0.tax_business AS tax_business_10, t0.tax_first AS tax_first_11, t0.tax_currency AS tax_currency_12 FROM flight_route t0 WHERE t0.route_code = 'FRASIN';

SELECT t0.id AS id_1, t0.code AS code_2, t0.icao AS icao_3, t0.name AS name_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.elevation AS elevation_7, t0.url AS url_8, t0.time_zone AS time_zone_9, t0.city_code AS city_code_10, t0.country AS country_11, t0.city AS city_12, t0.state AS state_13, t0.county AS county_14, t0.type AS type_15 FROM airport t0 WHERE t0.code = ? LIMIT 1

[
  "FRA"
]

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.icao AS icao_3,
  t0.name AS name_4,
  t0.latitude AS latitude_5,
  t0.longitude AS longitude_6,
  t0.elevation AS elevation_7,
  t0.url AS url_8,
  t0.time_zone AS time_zone_9,
  t0.city_code AS city_code_10,
  t0.country AS country_11,
  t0.city AS city_12,
  t0.state AS state_13,
  t0.county AS county_14,
  t0.type AS type_15
FROM
  airport t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.icao AS icao_3, t0.name AS name_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.elevation AS elevation_7, t0.url AS url_8, t0.time_zone AS time_zone_9, t0.city_code AS city_code_10, t0.country AS country_11, t0.city AS city_12, t0.state AS state_13, t0.county AS county_14, t0.type AS type_15 FROM airport t0 WHERE t0.code = 'FRA' LIMIT 1;

SELECT a.*, 
                   (6371 * ACOS(
                      COS(RADIANS(?)) * COS(RADIANS(a.latitude)) * COS(RADIANS(a.longitude) - RADIANS(?)) 
                      + SIN(RADIANS(?)) * SIN(RADIANS(a.latitude))
                   )) AS distance
            FROM airport a
            HAVING distance < ?
            ORDER BY distance ASC

[
  50.0229437
  8.5249381519162
  50.0229437
  250
]

SELECT
  a.*,
  (
    6371 * ACOS(
      COS(
        RADIANS(?)
      ) * COS(
        RADIANS(a.latitude)
      ) * COS(
        RADIANS(a.longitude) - RADIANS(?)
      ) + SIN(
        RADIANS(?)
      ) * SIN(
        RADIANS(a.latitude)
      )
    )
  ) AS distance
FROM
  airport a
HAVING
  distance < ?
ORDER BY
  distance ASC

SELECT a.*, 
                   (6371 * ACOS(
                      COS(RADIANS(50.0229437)) * COS(RADIANS(a.latitude)) * COS(RADIANS(a.longitude) - RADIANS(8.5249381519162)) 
                      + SIN(RADIANS(50.0229437)) * SIN(RADIANS(a.latitude))
                   )) AS distance
            FROM airport a
            HAVING distance < 250
            ORDER BY distance ASC
        ;

SELECT f0_.id AS id_0, f0_.origin_iata AS origin_iata_1, f0_.destination_iata AS destination_iata_2, f0_.departure_at AS departure_at_3, f0_.arrival_at AS arrival_at_4, f0_.airline AS airline_5, f0_.operating_airline AS operating_airline_6, f0_.flight_number AS flight_number_7, f0_.segments AS segments_8, f0_.layovers AS layovers_9, f0_.mixed_cabin AS mixed_cabin_10, f0_.program AS program_11, f0_.duration_minutes AS duration_minutes_12, f0_.booking_link AS booking_link_13, f0_.last_checked AS last_checked_14 FROM flight f0_ WHERE f0_.origin_iata = ? AND f0_.destination_iata = ? AND f0_.departure_at >= ? AND f0_.departure_at < ? ORDER BY f0_.departure_at ASC

[
  "FRA"
  "SIN"
  "2026-01-12 00:00:00"
  "2026-01-13 00:00:00"
]

SELECT
  f0_.id AS id_0,
  f0_.origin_iata AS origin_iata_1,
  f0_.destination_iata AS destination_iata_2,
  f0_.departure_at AS departure_at_3,
  f0_.arrival_at AS arrival_at_4,
  f0_.airline AS airline_5,
  f0_.operating_airline AS operating_airline_6,
  f0_.flight_number AS flight_number_7,
  f0_.segments AS segments_8,
  f0_.layovers AS layovers_9,
  f0_.mixed_cabin AS mixed_cabin_10,
  f0_.program AS program_11,
  f0_.duration_minutes AS duration_minutes_12,
  f0_.booking_link AS booking_link_13,
  f0_.last_checked AS last_checked_14
FROM
  flight f0_
WHERE
  f0_.origin_iata = ?
  AND f0_.destination_iata = ?
  AND f0_.departure_at >= ?
  AND f0_.departure_at < ?
ORDER BY
  f0_.departure_at ASC

SELECT f0_.id AS id_0, f0_.origin_iata AS origin_iata_1, f0_.destination_iata AS destination_iata_2, f0_.departure_at AS departure_at_3, f0_.arrival_at AS arrival_at_4, f0_.airline AS airline_5, f0_.operating_airline AS operating_airline_6, f0_.flight_number AS flight_number_7, f0_.segments AS segments_8, f0_.layovers AS layovers_9, f0_.mixed_cabin AS mixed_cabin_10, f0_.program AS program_11, f0_.duration_minutes AS duration_minutes_12, f0_.booking_link AS booking_link_13, f0_.last_checked AS last_checked_14 FROM flight f0_ WHERE f0_.origin_iata = 'FRA' AND f0_.destination_iata = 'SIN' AND f0_.departure_at >= '2026-01-12 00:00:00' AND f0_.departure_at < '2026-01-13 00:00:00' ORDER BY f0_.departure_at ASC;

SELECT t0.id AS id_1, t0.create_at AS create_at_2, t0.type AS type_3, t0.decryption_key AS decryption_key_4, t0.status AS status_5, t0.data AS data_6, t0.last_check_at AS last_check_at_7, t0.return_message AS return_message_8, t0.has_worked AS has_worked_9, t0.error_counter AS error_counter_10, t0.user_id AS user_id_11 FROM user_credential t0 WHERE t0.id = ?

[
  "75"
]

SELECT
  t0.id AS id_1,
  t0.create_at AS create_at_2,
  t0.type AS type_3,
  t0.decryption_key AS decryption_key_4,
  t0.status AS status_5,
  t0.data AS data_6,
  t0.last_check_at AS last_check_at_7,
  t0.return_message AS return_message_8,
  t0.has_worked AS has_worked_9,
  t0.error_counter AS error_counter_10,
  t0.user_id AS user_id_11
FROM
  user_credential t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.create_at AS create_at_2, t0.type AS type_3, t0.decryption_key AS decryption_key_4, t0.status AS status_5, t0.data AS data_6, t0.last_check_at AS last_check_at_7, t0.return_message AS return_message_8, t0.has_worked AS has_worked_9, t0.error_counter AS error_counter_10, t0.user_id AS user_id_11 FROM user_credential t0 WHERE t0.id = '75';