Symfony Profiler

SELECT
  SUM(t0_.amount) AS sclr_0,
  a1_.id AS id_1,
  a1_.name AS name_2,
  a1_.created AS created_3,
  a1_.status AS status_4,
  a1_.time_zone AS time_zone_5,
  a1_.fdow AS fdow_6,
  a1_.billing_method AS billing_method_7,
  a1_.billing_details AS billing_details_8,
  a1_.price AS price_9,
  a1_.external_sub_id_url AS external_sub_id_url_10,
  a1_.meta AS meta_11,
  a1_.verified AS verified_12,
  a1_.badge_info AS badge_info_13,
  a2_.created AS created_14,
  a2_.runout AS runout_15,
  a1_.id AS id_16,
  a2_.id AS id_17
FROM
  accounts a1_
  LEFT JOIN transactions t0_ ON a1_.id = t0_.account_id
  AND (t0_.status = ?)
  LEFT JOIN accounts_runout a2_ ON a1_.id = a2_.id
WHERE
  a1_.id = ?
GROUP BY
  a1_.id,
  a1_.name,
  a1_.created,
  a1_.status,
  a1_.time_zone,
  a1_.fdow,
  a1_.billing_method,
  a1_.billing_details,
  a1_.price,
  a1_.external_sub_id_url,
  a1_.meta,
  a1_.verified,
  a1_.badge_info,
  a1_.id,
  a2_.created,
  a2_.runout,
  a2_.id

SELECT SUM(t0_.amount) AS sclr_0, a1_.id AS id_1, a1_.name AS name_2, a1_.created AS created_3, a1_.status AS status_4, a1_.time_zone AS time_zone_5, a1_.fdow AS fdow_6, a1_.billing_method AS billing_method_7, a1_.billing_details AS billing_details_8, a1_.price AS price_9, a1_.external_sub_id_url AS external_sub_id_url_10, a1_.meta AS meta_11, a1_.verified AS verified_12, a1_.badge_info AS badge_info_13, a2_.created AS created_14, a2_.runout AS runout_15, a1_.id AS id_16, a2_.id AS id_17 FROM accounts a1_ LEFT JOIN transactions t0_ ON a1_.id = t0_.account_id AND (t0_.status = 'completed') LEFT JOIN accounts_runout a2_ ON a1_.id = a2_.id WHERE a1_.id = 5 GROUP BY a1_.id, a1_.name, a1_.created, a1_.status, a1_.time_zone, a1_.fdow, a1_.billing_method, a1_.billing_details, a1_.price, a1_.external_sub_id_url, a1_.meta, a1_.verified, a1_.badge_info, a1_.id, a2_.created, a2_.runout, a2_.id;

SELECT
  t0.id AS id_3,
  t0.created AS created_4,
  t0.status AS status_5,
  t0.sentry_logging AS sentry_logging_6,
  t0.type,
  t1.description AS description_7,
  t1.`key` AS key_8,
  t1.key_type AS key_type_9,
  t2.email AS email_10,
  t2.password AS password_11,
  t2.first_name AS first_name_12,
  t2.last_name AS last_name_13,
  t2.phone_number AS phone_number_14,
  t2.country AS country_15,
  t2.session_token AS session_token_16,
  t2.meta AS meta_17
FROM
  users t0
  LEFT JOIN users_api t1 ON t0.id = t1.id
  LEFT JOIN users_interactive t2 ON t0.id = t2.id
  INNER JOIN roles ON t0.id = roles.user_id
WHERE
  roles.account_id = ?

SELECT t0.id AS id_3, t0.created AS created_4, t0.status AS status_5, t0.sentry_logging AS sentry_logging_6, t0.type, t1.description AS description_7, t1.`key` AS key_8, t1.key_type AS key_type_9, t2.email AS email_10, t2.password AS password_11, t2.first_name AS first_name_12, t2.last_name AS last_name_13, t2.phone_number AS phone_number_14, t2.country AS country_15, t2.session_token AS session_token_16, t2.meta AS meta_17 FROM users t0 LEFT JOIN users_api t1 ON t0.id = t1.id LEFT JOIN users_interactive t2 ON t0.id = t2.id INNER JOIN roles ON t0.id = roles.user_id WHERE roles.account_id = 5;

SELECT
  u0_.id AS id_0
FROM
  users u0_
  LEFT JOIN users_api u1_ ON u0_.id = u1_.id
  LEFT JOIN users_interactive u2_ ON u0_.id = u2_.id
  INNER JOIN roles r3_ ON u0_.id = r3_.user_id
WHERE
  r3_.status = ?
  AND r3_.account_id = ?
  AND r3_.type = ?
LIMIT
  1

SELECT u0_.id AS id_0 FROM users u0_ LEFT JOIN users_api u1_ ON u0_.id = u1_.id LEFT JOIN users_interactive u2_ ON u0_.id = u2_.id INNER JOIN roles r3_ ON u0_.id = r3_.user_id WHERE r3_.status = 'active' AND r3_.account_id = 5 AND r3_.type = 'owner' LIMIT 1;