Symfony Profiler

select
  a.id,
  a.account_date,
  a.station_id,
  d.station_name,
  sum(c.amount) as amount,
  count(c.id) as transactions,
  (
    SELECT
      sum(inner_a.amount)
    FROM
      station_expense inner_a
      JOIN daily_account inner_b ON inner_b.id = inner_a.daily_account_id
      JOIN station_daily_account inner_c ON inner_c.id = inner_b.station_daily_account
    WHERE
      inner_c.id = a.id
      and is_cancelled = false
  ) as expenses
FROM
  station_daily_account a
  JOIN daily_account b ON b.station_daily_account = a.id
  JOIN transaction c ON c.daily_account_id = b.id
  JOIN station d ON a.station_id = d.id
WHERE
  a.id = :station_daily_account
  AND c.is_cancelled = false
  AND c.is_paid = true
  AND c.payment_method IS NOT NULL

select a.id,a.account_date, a.station_id, d.station_name, sum(c.amount) as amount, count(c.id) as transactions, 
                        (SELECT sum(inner_a.amount) FROM station_expense inner_a 
                                    JOIN daily_account inner_b ON inner_b.id = inner_a.daily_account_id 
                                    JOIN station_daily_account inner_c ON inner_c.id = inner_b.station_daily_account 
                              WHERE inner_c.id =a.id and is_cancelled = false  ) as expenses 
                             FROM station_daily_account a 
                                    JOIN daily_account b ON b.station_daily_account = a.id 
                                    JOIN transaction c ON c.daily_account_id = b.id 
                                    JOIN station d ON a.station_id = d.id 
                                WHERE a.id =18776 AND c.is_cancelled = false AND c.is_paid = true AND c.payment_method IS NOT NULL;

select
  b.id,
  a.account_date,
  a.station_id,
  d.station_name,
  sum(c.amount) as amount,
  count(c.id) as transactions,
  f.first_name,
  f.second_name,
  f.sir_name,
  (
    SELECT
      sum(amount)
    FROM
      transaction
    WHERE
      is_cancelled = true
      and daily_account_id = b.id
  ) as cancelled_amount,
  (
    SELECT
      count(id)
    FROM
      transaction
    WHERE
      is_cancelled = true
      and daily_account_id = b.id
  ) as cancelled,
  (
    SELECT
      sum(cash_amount)
    FROM
      transaction
    WHERE
      is_cancelled = false
      and daily_account_id = b.id
      AND payment_method is not null
  ) as cash_amount,
  (
    SELECT
      sum(mpesa_amount)
    FROM
      transaction
    WHERE
      is_cancelled = false
      and daily_account_id = b.id
      AND payment_method is not null
  ) as mpesa_amount,
  (
    SELECT
      sum(inner_a.amount)
    FROM
      station_expense inner_a
    WHERE
      inner_a.daily_account_id = b.id
      and inner_a.is_cancelled = false
  ) as expenses
FROM
  station_daily_account a
  JOIN daily_account b ON b.station_daily_account = a.id
  JOIN transaction c ON c.daily_account_id = b.id
  JOIN station d ON a.station_id = d.id
  JOIN user e ON e.id = b.user_id
  JOIN person f ON f.id = e.person_id
WHERE
  a.id = :station_daily_account
  AND c.is_paid = true
  AND c.is_cancelled = false
  AND c.payment_method IS NOT NULL
GROUP BY
  b.id

select b.id,a.account_date, a.station_id, d.station_name, sum(c.amount) as amount, count(c.id) as transactions, 
                        f.first_name, f.second_name, f.sir_name,
                        (SELECT sum(amount) FROM transaction WHERE is_cancelled = true and daily_account_id = b.id ) as cancelled_amount,                        
                        (SELECT count(id) FROM transaction WHERE is_cancelled = true and daily_account_id = b.id ) as cancelled,
       
                        (SELECT sum(cash_amount) FROM transaction WHERE is_cancelled = false and daily_account_id = b.id AND payment_method is not null) as cash_amount,
                        (SELECT sum(mpesa_amount) FROM transaction WHERE is_cancelled = false and daily_account_id = b.id  AND payment_method is not null ) as mpesa_amount,
       
                        (SELECT sum(inner_a.amount) FROM station_expense inner_a WHERE inner_a.daily_account_id = b.id and inner_a.is_cancelled = false ) as expenses 
                             FROM station_daily_account a 
                                    JOIN daily_account b ON b.station_daily_account = a.id 
                                    JOIN transaction c ON c.daily_account_id = b.id 
                                    JOIN station d ON a.station_id = d.id  
                                    JOIN user e ON e.id = b.user_id
                                    JOIN person f ON f.id = e.person_id
                            WHERE a.id =18776 AND c.is_paid = true AND c.is_cancelled = false AND  c.payment_method IS NOT NULL GROUP BY b.id;

SELECT
  t0.id AS id_1,
  t0.account_date AS account_date_2,
  t0.is_closed AS is_closed_3,
  t0.closing_date AS closing_date_4,
  t0.is_banked AS is_banked_5,
  t0.created_at AS created_at_6,
  t0.closed_by AS closed_by_7,
  t0.created_by AS created_by_8,
  t0.station_id AS station_id_9
FROM
  station_daily_account t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.account_date AS account_date_2, t0.is_closed AS is_closed_3, t0.closing_date AS closing_date_4, t0.is_banked AS is_banked_5, t0.created_at AS created_at_6, t0.closed_by AS closed_by_7, t0.created_by AS created_by_8, t0.station_id AS station_id_9 FROM station_daily_account t0 WHERE t0.id = '18776' LIMIT 1;

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.person_id AS person_id_7
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.person_id AS person_id_7 FROM user t0 WHERE t0.id = 86;