Symfony Profiler

SELECT
  bs.id,
  a.seat_number,
  bs.passenger,
  bs.phone,
  p.first_name,
  st.station_name as origin,
  mp.transaction_id,
  std.station_name as destination,
  bs.amount,
  a.status,
  b.status as booking_status,
  b.created_at as booking_created_at
FROM
  bus_seat a
  LEFT JOIN bus_booking_seat bs on a.id = bs.seat_id
  AND NOT EXISTS (
    SELECT
      1
    FROM
      bus_booking bfail
    WHERE
      bfail.id = bs.booking_id
      AND bfail.status = 'failed'
  )
  LEFT JOIN bus_booking b ON b.id = bs.booking_id
  LEFT JOIN bus_stop s on s.id = bs.origin
  LEFT JOIN station st ON st.id = s.station_id
  LEFT JOIN bus_stop sd ON sd.id = bs.destination
  LEFT JOIN station std ON std.id = sd.station_id
  LEFT JOIN user u on bs.created_by = u.id
  LEFT JOIN person p on u.person_id = p.id
  LEFT JOIN bus_booking_mpesa bs_mpesa ON bs_mpesa.booking_id = bs.id
  LEFT JOIN mpesa mp ON mp.id = bs_mpesa.mpesa_id
WHERE
  a.trip_id = 38451
order by
  a.seat_number

SELECT bs.id,a.seat_number, bs.passenger, bs.phone,p.first_name,st.station_name as origin,mp.transaction_id, std.station_name as destination, bs.amount,a.status,
                    b.status as booking_status, b.created_at as booking_created_at
                FROM bus_seat a
                    LEFT JOIN bus_booking_seat bs on a.id = bs.seat_id
                        AND NOT EXISTS (SELECT 1 FROM bus_booking bfail WHERE bfail.id = bs.booking_id AND bfail.status = 'failed')
                    LEFT JOIN bus_booking b ON b.id = bs.booking_id
                    LEFT JOIN bus_stop s on s.id = bs.origin
                    LEFT JOIN station st ON st.id = s.station_id
                    LEFT JOIN bus_stop sd ON sd.id = bs.destination
                    LEFT JOIN station std ON std.id = sd.station_id
                    LEFT JOIN user u on bs.created_by = u.id
                    LEFT JOIN person p on u.person_id = p.id
                    LEFT JOIN bus_booking_mpesa bs_mpesa ON bs_mpesa.booking_id = bs.id
                    LEFT JOIN mpesa mp ON mp.id = bs_mpesa.mpesa_id
                 WHERE a.trip_id = 38451  order by a.seat_number;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.trip_date AS trip_date_3,
  t0.departure_time AS departure_time_4,
  t0.eta AS eta_5,
  t0.fare AS fare_6,
  t0.trip_index AS trip_index_7,
  t0.vehicle_is_approved AS vehicle_is_approved_8,
  t0.route_id AS route_id_9,
  t0.origin AS origin_10,
  t0.destination AS destination_11,
  t0.created_by AS created_by_12,
  t0.vehicle AS vehicle_13
FROM
  bus_trip t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.trip_date AS trip_date_3, t0.departure_time AS departure_time_4, t0.eta AS eta_5, t0.fare AS fare_6, t0.trip_index AS trip_index_7, t0.vehicle_is_approved AS vehicle_is_approved_8, t0.route_id AS route_id_9, t0.origin AS origin_10, t0.destination AS destination_11, t0.created_by AS created_by_12, t0.vehicle AS vehicle_13 FROM bus_trip t0 WHERE t0.id = '38451';

SELECT
  t0.id AS id_1,
  t0.short_id AS short_id_2,
  t0.date AS date_3,
  t0.total_price AS total_price_4,
  t0.status AS status_5,
  t0.device_id AS device_id_6,
  t0.phone AS phone_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.trip_id AS trip_id_10,
  t0.origin_stop_id AS origin_stop_id_11,
  t0.destination_stop_id AS destination_stop_id_12
FROM
  bus_booking t0
WHERE
  t0.trip_id = ?
  AND t0.status = ?

SELECT t0.id AS id_1, t0.short_id AS short_id_2, t0.date AS date_3, t0.total_price AS total_price_4, t0.status AS status_5, t0.device_id AS device_id_6, t0.phone AS phone_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.trip_id AS trip_id_10, t0.origin_stop_id AS origin_stop_id_11, t0.destination_stop_id AS destination_stop_id_12 FROM bus_booking t0 WHERE t0.trip_id = 38451 AND t0.status = 'pending';

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.password AS password_3,
  t0.created_at AS created_at_4,
  t0.roles AS roles_5,
  t0.email AS email_6,
  t0.is_active AS is_active_7,
  t0.person_id AS person_id_8
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.created_at AS created_at_4, t0.roles AS roles_5, t0.email AS email_6, t0.is_active AS is_active_7, t0.person_id AS person_id_8 FROM user t0 WHERE t0.id = 2;