Symfony Profiler

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 = ?
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 = 102 LIMIT 1;

SELECT
  a.id,
  (
    select
      count(*)
    from
      transaction
    where
      created_by = a.user_id
      and daily_account_id = a.id
  ) as transactions,
  (
    select
      sum(amount)
    from
      transaction
    where
      created_by = a.user_id
      and daily_account_id = a.id
      and is_cancelled = false
  ) as transactions_amount,
  (
    select
      count(*)
    from
      transaction
    where
      created_by = a.user_id
      and is_cancelled = true
      and daily_account_id = a.id
  ) as cancelled_transactions,
  (
    select
      sum(amount)
    from
      transaction
    where
      created_by = a.user_id
      and is_cancelled = true
      and daily_account_id = a.id
  ) as cancelled_amount,
  (
    select
      count(*)
    from
      transaction
    where
      created_by = a.user_id
      and is_cancelled = false
      and mpesa_amount > 0
      and daily_account_id = a.id
  ) as mpesa_transactions,
  (
    select
      sum(mpesa_amount)
    from
      transaction
    where
      created_by = a.user_id
      and is_cancelled = false
      and mpesa_amount > 0
      and daily_account_id = a.id
  ) as mpesa_amount,
  (
    select
      count(*)
    from
      transaction
    where
      created_by = a.user_id
      and is_cancelled = false
      and cash_amount > 0
      and daily_account_id = a.id
  ) as cash_transactions,
  (
    select
      sum(cash_amount)
    from
      transaction
    where
      created_by = a.user_id
      and is_cancelled = false
      and cash_amount > 0
      and daily_account_id = a.id
  ) as cash_amount,
  (
    SELECT
      sum(inner_a.amount)
    FROM
      station_expense inner_a
    WHERE
      inner_a.daily_account_id = a.id
      and inner_a.is_cancelled = false
  ) as expenses,
  (
    SELECT
      count(*)
    FROM
      station_expense inner_a
    WHERE
      inner_a.daily_account_id = a.id
      and inner_a.is_cancelled = false
  ) as expenses_count
FROM
  daily_account a
where
  a.user_id = 102
  and a.is_closed = 0
ORDER BY
  a.id desc
LIMIT
  1

SELECT a.id, 
                       (select count(*) from transaction where created_by = a.user_id and daily_account_id = a.id) as transactions,
                       (select sum(amount) from transaction where created_by = a.user_id and daily_account_id = a.id and is_cancelled = false) as transactions_amount,
                       
                       (select count(*) from transaction where created_by = a.user_id and is_cancelled = true and daily_account_id = a.id) as cancelled_transactions,
                       (select sum(amount) from transaction where created_by = a.user_id and is_cancelled = true and daily_account_id = a.id) as cancelled_amount,
                       
                       (select count(*) from transaction where created_by = a.user_id and is_cancelled = false and mpesa_amount > 0 and daily_account_id = a.id) as mpesa_transactions,
                       (select sum(mpesa_amount) from transaction where created_by = a.user_id and is_cancelled = false and mpesa_amount > 0 and daily_account_id = a.id) as mpesa_amount,
                       
                       (select count(*) from transaction where created_by = a.user_id and is_cancelled = false and cash_amount > 0 and daily_account_id = a.id) as cash_transactions,
                       (select sum(cash_amount) from transaction where created_by = a.user_id and is_cancelled = false and cash_amount > 0 and daily_account_id = a.id) as cash_amount,
                      (SELECT sum(inner_a.amount) FROM station_expense inner_a WHERE inner_a.daily_account_id = a.id and inner_a.is_cancelled = false  ) as expenses,
                      (SELECT count(*) FROM station_expense inner_a WHERE inner_a.daily_account_id = a.id and inner_a.is_cancelled = false  ) as expenses_count
                    FROM daily_account a  where a.user_id = 102 and a.is_closed = 0 ORDER BY a.id desc LIMIT 1

                ;

SELECT
  t0.id AS id_1,
  t0.drawer_cash AS drawer_cash_2,
  t0.account_date AS account_date_3,
  t0.is_closed AS is_closed_4,
  t0.created_at AS created_at_5,
  t0.user_id AS user_id_6,
  t0.station_daily_account AS station_daily_account_7,
  t0.closed_by AS closed_by_8
FROM
  daily_account t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.drawer_cash AS drawer_cash_2, t0.account_date AS account_date_3, t0.is_closed AS is_closed_4, t0.created_at AS created_at_5, t0.user_id AS user_id_6, t0.station_daily_account AS station_daily_account_7, t0.closed_by AS closed_by_8 FROM daily_account t0 WHERE t0.id = 36978 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  daily_account
SET
  drawer_cash = ?,
  is_closed = ?,
  closed_by = ?
WHERE
  id = ?

UPDATE daily_account SET drawer_cash = '600', is_closed = 1, closed_by = 102 WHERE id = 36978;

"COMMIT"

"COMMIT";