Symfony Profiler

SELECT
  t.id,
  t.trip_index,
  t.trip_date,
  r.route_name,
  r.id AS route_id,
  t.fare,
  t.vehicle,
  ANY_VALUE(s_from.departure_time) as departure_time,
  ANY_VALUE(s_to.eta) as eta,
  s.station_name as station_from,
  ss.station_name as station_to,
  (
    select
      JSON_ARRAYAGG(seat_number)
    from
      bus_seat
    where
      trip_id = t.id
  ) as booked_seat_numbers
FROM
  bus_trip t
  JOIN bus_route r ON r.id = t.route_id
  JOIN bus_stop s_from ON s_from.route_id = r.id
  AND s_from.station_id =
  JOIN bus_stop s_to ON s_to.route_id = r.id
  AND s_to.station_id = MAIN
  JOIN station s ON s.id = s_from.station_id
  JOIN station ss ON ss.id = s_to.station_id
WHERE
  t.trip_date = '2026-02-07'
GROUP BY
  t.id

SELECT 
                    t.id,
                    t.trip_index,
                    t.trip_date,
                    r.route_name,
                    r.id AS route_id,
                    t.fare,
                    t.vehicle,
                    ANY_VALUE(s_from.departure_time) as departure_time,
                    ANY_VALUE(s_to.eta) as eta,
                    s.station_name as station_from,
                    ss.station_name as station_to,
                    (select JSON_ARRAYAGG(seat_number) from bus_seat where trip_id = t.id ) as booked_seat_numbers
                FROM bus_trip t
                JOIN bus_route r ON r.id = t.route_id
                JOIN bus_stop s_from ON s_from.route_id = r.id AND s_from.station_id = 
                JOIN bus_stop s_to ON s_to.route_id = r.id AND s_to.station_id = MAIN
                JOIN station s ON s.id =s_from.station_id
                JOIN station ss ON ss.id = s_to.station_id
                WHERE t.trip_date = '2026-02-07'  GROUP BY t.id;