Symfony Profiler

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  station_expense s0_
  INNER JOIN daily_account d1_ ON s0_.daily_account_id = d1_.id
  INNER JOIN expense_type e2_ ON s0_.expense_type_id = e2_.id
  INNER JOIN user u3_ ON s0_.created_by = u3_.id
  INNER JOIN station_daily_account s4_ ON d1_.station_daily_account = s4_.id
  INNER JOIN station s5_ ON s4_.station_id = s5_.id

SELECT COUNT(s0_.id) AS sclr_0 FROM station_expense s0_ INNER JOIN daily_account d1_ ON s0_.daily_account_id = d1_.id INNER JOIN expense_type e2_ ON s0_.expense_type_id = e2_.id INNER JOIN user u3_ ON s0_.created_by = u3_.id INNER JOIN station_daily_account s4_ ON d1_.station_daily_account = s4_.id INNER JOIN station s5_ ON s4_.station_id = s5_.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 = ?

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 = 157;

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.second_name AS second_name_3,
  t0.sir_name AS sir_name_4,
  t0.gender AS gender_5,
  t0.national_id AS national_id_6,
  t0.phone_number AS phone_number_7,
  t0.created_at AS created_at_8,
  t0.date_of_birth AS date_of_birth_9,
  t0.preferred_name AS preferred_name_10,
  t0.created_by AS created_by_11
FROM
  person t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.second_name AS second_name_3, t0.sir_name AS sir_name_4, t0.gender AS gender_5, t0.national_id AS national_id_6, t0.phone_number AS phone_number_7, t0.created_at AS created_at_8, t0.date_of_birth AS date_of_birth_9, t0.preferred_name AS preferred_name_10, t0.created_by AS created_by_11 FROM person t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.expense_accrued AS expense_accrued_3,
  t0.description AS description_4,
  t0.created_at AS created_at_5,
  t0.is_cancelled AS is_cancelled_6,
  t0.station_id AS station_id_7,
  t0.daily_account_id AS daily_account_id_8,
  t0.expense_type_id AS expense_type_id_9,
  t0.created_by AS created_by_10
FROM
  station_expense t0
WHERE
  t0.daily_account_id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.expense_accrued AS expense_accrued_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.is_cancelled AS is_cancelled_6, t0.station_id AS station_id_7, t0.daily_account_id AS daily_account_id_8, t0.expense_type_id AS expense_type_id_9, t0.created_by AS created_by_10 FROM station_expense t0 WHERE t0.daily_account_id = 48470;

SELECT
  t0.id AS id_1,
  t0.station_name AS station_name_2,
  t0.station_address AS station_address_3,
  t0.phone_numbers AS phone_numbers_4,
  t0.created_at AS created_at_5,
  t0.operating_hrs AS operating_hrs_6,
  t0.is_mobile AS is_mobile_7,
  t0.organization_id AS organization_id_8,
  t0.created_by AS created_by_9
FROM
  station t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.station_name AS station_name_2, t0.station_address AS station_address_3, t0.phone_numbers AS phone_numbers_4, t0.created_at AS created_at_5, t0.operating_hrs AS operating_hrs_6, t0.is_mobile AS is_mobile_7, t0.organization_id AS organization_id_8, t0.created_by AS created_by_9 FROM station t0 WHERE t0.id = 16;

SELECT
  t0.id AS id_1,
  t0.expense_name AS expense_name_2,
  t0.is_automatic AS is_automatic_3,
  t0.is_way_bill AS is_way_bill_4,
  t0.is_active AS is_active_5,
  t0.created_at AS created_at_6,
  t0.automatic_expense_id AS automatic_expense_id_7,
  t0.created_by AS created_by_8
FROM
  expense_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.expense_name AS expense_name_2, t0.is_automatic AS is_automatic_3, t0.is_way_bill AS is_way_bill_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.automatic_expense_id AS automatic_expense_id_7, t0.created_by AS created_by_8 FROM expense_type t0 WHERE t0.id = 12;

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 = ?

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 = 48470;

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 = ?

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 = 23956;

SELECT
  t0.id AS id_1,
  t0.organization_name AS organization_name_2,
  t0.code AS code_3,
  t0.county AS county_4,
  t0.town AS town_5,
  t0.address AS address_6,
  t0.person_id AS person_id_7,
  t0.created_by AS created_by_8
FROM
  organization t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.organization_name AS organization_name_2, t0.code AS code_3, t0.county AS county_4, t0.town AS town_5, t0.address AS address_6, t0.person_id AS person_id_7, t0.created_by AS created_by_8 FROM organization t0 WHERE t0.id = 1;

SELECT
  s0_.id AS id_0,
  s0_.amount AS amount_1,
  s0_.expense_accrued AS expense_accrued_2,
  s0_.description AS description_3,
  s0_.created_at AS created_at_4,
  s0_.is_cancelled AS is_cancelled_5,
  s0_.station_id AS station_id_6,
  s0_.daily_account_id AS daily_account_id_7,
  s0_.expense_type_id AS expense_type_id_8,
  s0_.created_by AS created_by_9
FROM
  station_expense s0_
  INNER JOIN daily_account d1_ ON s0_.daily_account_id = d1_.id
  INNER JOIN expense_type e2_ ON s0_.expense_type_id = e2_.id
  INNER JOIN user u3_ ON s0_.created_by = u3_.id
  INNER JOIN station_daily_account s4_ ON d1_.station_daily_account = s4_.id
  INNER JOIN station s5_ ON s4_.station_id = s5_.id
ORDER BY
  s0_.id DESC
LIMIT
  20

SELECT s0_.id AS id_0, s0_.amount AS amount_1, s0_.expense_accrued AS expense_accrued_2, s0_.description AS description_3, s0_.created_at AS created_at_4, s0_.is_cancelled AS is_cancelled_5, s0_.station_id AS station_id_6, s0_.daily_account_id AS daily_account_id_7, s0_.expense_type_id AS expense_type_id_8, s0_.created_by AS created_by_9 FROM station_expense s0_ INNER JOIN daily_account d1_ ON s0_.daily_account_id = d1_.id INNER JOIN expense_type e2_ ON s0_.expense_type_id = e2_.id INNER JOIN user u3_ ON s0_.created_by = u3_.id INNER JOIN station_daily_account s4_ ON d1_.station_daily_account = s4_.id INNER JOIN station s5_ ON s4_.station_id = s5_.id ORDER BY s0_.id DESC LIMIT 20;