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.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 = 120;

SELECT
  b.id,
  c.account_date,
  a.expenses,
  a.created_at,
  d.station_name,
  b.sender_name,
  b.sender_phone_number,
  b.receiver_name,
  b.receiver_phone_number,
  a.amount,
  a.is_cancelled,
  f.transaction_id,
  a.payment_method
FROM
  transaction a
  JOIN way_bill b on a.way_bill_id = b.id
  JOIN daily_account c ON c.id = a.daily_account_id
  JOIN station d ON d.id = b.to_station_id
  LEFT JOIN mpesa_transaction e ON a.id = e.transaction_id
  LEFT JOIN mpesa f ON f.id = e.mpesa_id
WHERE
  b.from_station_id = 2
  AND b.receiver_name like '% caroline nj%'
ORDER BY
  b.id DESC
LIMIT
  0, 20

SELECT b.id,c.account_date,a.expenses,a.created_at,d.station_name,b.sender_name,b.sender_phone_number,b.receiver_name,b.receiver_phone_number,a.amount, a.is_cancelled,f.transaction_id,a.payment_method FROM transaction a 
                            JOIN way_bill b on a.way_bill_id = b.id
                            JOIN daily_account c ON c.id = a.daily_account_id
                            JOIN station d ON d.id = b.to_station_id
                            LEFT JOIN mpesa_transaction e ON a.id = e.transaction_id   
                            LEFT JOIN mpesa f ON f.id = e.mpesa_id                                                                                                                                           
                  WHERE  b.from_station_id = 2   AND  b.receiver_name like'% caroline nj%' ORDER BY b.id DESC LIMIT  0,20;

EXPLAIN
SELECT
  count(a.id) as total
FROM
  transaction a
  JOIN way_bill b on a.way_bill_id = b.id
  JOIN daily_account c ON c.id = a.daily_account_id
  JOIN station d ON d.id = b.to_station_id
  LEFT JOIN mpesa_transaction e ON a.id = e.transaction_id
  LEFT JOIN mpesa f ON f.id = e.mpesa_id
WHERE
  b.from_station_id = 2
  AND b.receiver_name like '% caroline nj%'

EXPLAIN SELECT count(a.id) as total  FROM transaction a 
                            JOIN way_bill b on a.way_bill_id = b.id
                            JOIN daily_account c ON c.id = a.daily_account_id
                            JOIN station d ON d.id = b.to_station_id
                            LEFT JOIN mpesa_transaction e ON a.id = e.transaction_id   
                            LEFT JOIN mpesa f ON f.id = e.mpesa_id                                                                                                                                           
                  WHERE  b.from_station_id = 2  AND  b.receiver_name like'% caroline nj%';

SELECT
  SUM(b.percel_count) as parcel_count,
  SUM(a.station_expenses) as station_expenses,
  SUM(a.tax_amount) as tax_amount,
  SUM(a.amount) as amount,
  SUM(a.expenses) as expenses,
  SUM(a.balance) as balance
FROM
  transaction a
  JOIN way_bill b on a.way_bill_id = b.id
  JOIN daily_account c ON c.id = a.daily_account_id
  JOIN station d ON d.id = b.to_station_id
WHERE
  b.from_station_id = 2
  AND a.created_by = 120
  AND b.receiver_name like '% caroline nj%'

SELECT SUM(b.percel_count) as parcel_count, SUM(a.station_expenses) as station_expenses,SUM(a.tax_amount) as tax_amount, SUM(a.amount) as amount, SUM(a.expenses) as expenses, SUM(a.balance) as balance  FROM transaction a 
                            JOIN way_bill b on a.way_bill_id = b.id
                            JOIN daily_account c ON c.id = a.daily_account_id
                            JOIN station d ON d.id = b.to_station_id
                  WHERE  b.from_station_id = 2 AND a.created_by = 120  AND  b.receiver_name like'% caroline nj%' ;