Symfony Profiler

SELECT
  COUNT(DISTINCT t0_.id) AS sclr_0
FROM
  transaction t0_
  INNER JOIN bank_account b1_ ON t0_.bank_account_id = b1_.id
  LEFT JOIN category c2_ ON t0_.category_id = c2_.id
  LEFT JOIN sub_category s3_ ON t0_.sub_category_id = s3_.id
WHERE
  (
    b1_.owner_id = ?
    OR b1_.partner_id = ?
  )
  AND b1_.id = ?

SELECT COUNT(DISTINCT t0_.id) AS sclr_0 FROM transaction t0_ INNER JOIN bank_account b1_ ON t0_.bank_account_id = b1_.id LEFT JOIN category c2_ ON t0_.category_id = c2_.id LEFT JOIN sub_category s3_ ON t0_.sub_category_id = s3_.id WHERE (b1_.owner_id = 1 OR b1_.partner_id = 1) AND b1_.id = 2;

SELECT
  t0_.id AS id_0,
  t0_.amount AS amount_1,
  t0_.type AS type_2,
  t0_.description AS description_3,
  t0_.date AS date_4,
  t0_.status AS status_5,
  t0_.label AS label_6,
  t0_.uuid AS uuid_7,
  t0_.created_at AS created_at_8,
  t0_.updated_at AS updated_at_9,
  b1_.id AS id_10,
  b1_.name AS name_11,
  b1_.bank_name AS bank_name_12,
  b1_.type AS type_13,
  b1_.status AS status_14,
  b1_.bank_balance AS bank_balance_15,
  b1_.app_balance AS app_balance_16,
  b1_.provisional_balance AS provisional_balance_17,
  b1_.invitation_token AS invitation_token_18,
  b1_.sort_order AS sort_order_19,
  b1_.uuid AS uuid_20,
  b1_.created_at AS created_at_21,
  b1_.updated_at AS updated_at_22,
  c2_.id AS id_23,
  c2_.name AS name_24,
  c2_.color AS color_25,
  c2_.uuid AS uuid_26,
  c2_.created_at AS created_at_27,
  c2_.updated_at AS updated_at_28,
  s3_.id AS id_29,
  s3_.name AS name_30,
  s3_.uuid AS uuid_31,
  s3_.created_at AS created_at_32,
  s3_.updated_at AS updated_at_33,
  t0_.bank_account_id AS bank_account_id_34,
  t0_.category_id AS category_id_35,
  t0_.sub_category_id AS sub_category_id_36,
  b1_.owner_id AS owner_id_37,
  b1_.partner_id AS partner_id_38,
  c2_.user_id AS user_id_39,
  s3_.category_id AS category_id_40
FROM
  transaction t0_
  INNER JOIN bank_account b1_ ON t0_.bank_account_id = b1_.id
  LEFT JOIN category c2_ ON t0_.category_id = c2_.id
  LEFT JOIN sub_category s3_ ON t0_.sub_category_id = s3_.id
WHERE
  (
    b1_.owner_id = ?
    OR b1_.partner_id = ?
  )
  AND b1_.id = ?
ORDER BY
  t0_.date DESC
LIMIT
  20

SELECT t0_.id AS id_0, t0_.amount AS amount_1, t0_.type AS type_2, t0_.description AS description_3, t0_.date AS date_4, t0_.status AS status_5, t0_.label AS label_6, t0_.uuid AS uuid_7, t0_.created_at AS created_at_8, t0_.updated_at AS updated_at_9, b1_.id AS id_10, b1_.name AS name_11, b1_.bank_name AS bank_name_12, b1_.type AS type_13, b1_.status AS status_14, b1_.bank_balance AS bank_balance_15, b1_.app_balance AS app_balance_16, b1_.provisional_balance AS provisional_balance_17, b1_.invitation_token AS invitation_token_18, b1_.sort_order AS sort_order_19, b1_.uuid AS uuid_20, b1_.created_at AS created_at_21, b1_.updated_at AS updated_at_22, c2_.id AS id_23, c2_.name AS name_24, c2_.color AS color_25, c2_.uuid AS uuid_26, c2_.created_at AS created_at_27, c2_.updated_at AS updated_at_28, s3_.id AS id_29, s3_.name AS name_30, s3_.uuid AS uuid_31, s3_.created_at AS created_at_32, s3_.updated_at AS updated_at_33, t0_.bank_account_id AS bank_account_id_34, t0_.category_id AS category_id_35, t0_.sub_category_id AS sub_category_id_36, b1_.owner_id AS owner_id_37, b1_.partner_id AS partner_id_38, c2_.user_id AS user_id_39, s3_.category_id AS category_id_40 FROM transaction t0_ INNER JOIN bank_account b1_ ON t0_.bank_account_id = b1_.id LEFT JOIN category c2_ ON t0_.category_id = c2_.id LEFT JOIN sub_category s3_ ON t0_.sub_category_id = s3_.id WHERE (b1_.owner_id = 1 OR b1_.partner_id = 1) AND b1_.id = 2 ORDER BY t0_.date DESC LIMIT 20;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.bank_name AS bank_name_3,
  t0.type AS type_4,
  t0.status AS status_5,
  t0.bank_balance AS bank_balance_6,
  t0.app_balance AS app_balance_7,
  t0.provisional_balance AS provisional_balance_8,
  t0.invitation_token AS invitation_token_9,
  t0.sort_order AS sort_order_10,
  t0.uuid AS uuid_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.owner_id AS owner_id_14,
  t0.partner_id AS partner_id_15
FROM
  bank_account t0
WHERE
  t0.uuid = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.bank_name AS bank_name_3, t0.type AS type_4, t0.status AS status_5, t0.bank_balance AS bank_balance_6, t0.app_balance AS app_balance_7, t0.provisional_balance AS provisional_balance_8, t0.invitation_token AS invitation_token_9, t0.sort_order AS sort_order_10, t0.uuid AS uuid_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.owner_id AS owner_id_14, t0.partner_id AS partner_id_15 FROM bank_account t0 WHERE t0.uuid = 0x72040C46187D432BBE978C4B9A4B3936 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.first_name AS first_name_3,
  t0.last_name AS last_name_4,
  t0.username AS username_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.uuid AS uuid_8,
  t0.roles AS roles_9,
  t0.password AS password_10,
  t0.profile_picture AS profile_picture_11
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.username AS username_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.uuid AS uuid_8, t0.roles AS roles_9, t0.password AS password_10, t0.profile_picture AS profile_picture_11 FROM `user` t0 WHERE t0.id = 1;