Symfony Profiler

SELECT
  t0.user AS user_1,
  t0.roles AS roles_2,
  t0.email AS email_3,
  t0.password AS password_4,
  t0.profile_picture AS profile_picture_5
FROM
  users t0
WHERE
  t0.user = ?

SELECT t0.user AS user_1, t0.roles AS roles_2, t0.email AS email_3, t0.password AS password_4, t0.profile_picture AS profile_picture_5 FROM users t0 WHERE t0.user = 'admin';

SELECT
  COUNT(u0_.user) AS sclr_0
FROM
  users u0_

SELECT COUNT(u0_.user) AS sclr_0 FROM users u0_;

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  person p0_

SELECT COUNT(p0_.id) AS sclr_0 FROM person p0_;

SELECT
  COUNT(p0_.code) AS sclr_0
FROM
  places p0_

SELECT COUNT(p0_.code) AS sclr_0 FROM places p0_;

SELECT
  COUNT(s0_.code) AS sclr_0
FROM
  settings s0_

SELECT COUNT(s0_.code) AS sclr_0 FROM settings s0_;

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  coffee c0_

SELECT COUNT(c0_.id) AS sclr_0 FROM coffee c0_;

SELECT
  COUNT(m0_.id) AS sclr_0
FROM
  money m0_

SELECT COUNT(m0_.id) AS sclr_0 FROM money m0_;

SELECT
  COUNT(l0_.id) AS sclr_0
FROM
  lunch_orders l0_

SELECT COUNT(l0_.id) AS sclr_0 FROM lunch_orders l0_;

SELECT
  COUNT(l0_.id) AS sclr_0
FROM
  lunch l0_

SELECT COUNT(l0_.id) AS sclr_0 FROM lunch l0_;

SELECT
  p0_.id AS id_0,
  p0_.employee AS employee_1,
  p0_.name AS name_2,
  p0_.shortcut AS shortcut_3,
  p0_.bank_account AS bank_account_4,
  p0_.bank_account_prefix AS bank_account_prefix_5,
  p0_.bank_account_code AS bank_account_code_6,
  p0_.show_in_printout AS show_in_printout_7,
  p0_.can_create_orders AS can_create_orders_8,
  p0_.active AS active_9,
  COALESCE(
    SUM(c1_.amount),
    0
  ) AS sclr_10,
  p0_.user AS user_11
FROM
  person p0_
  LEFT JOIN coffee c1_ ON (c1_.person = p0_.id)
GROUP BY
  p0_.id
HAVING
  COALESCE(
    SUM(c1_.amount),
    0
  ) < 0
ORDER BY
  sclr_10 ASC,
  p0_.name ASC,
  p0_.id ASC

SELECT p0_.id AS id_0, p0_.employee AS employee_1, p0_.name AS name_2, p0_.shortcut AS shortcut_3, p0_.bank_account AS bank_account_4, p0_.bank_account_prefix AS bank_account_prefix_5, p0_.bank_account_code AS bank_account_code_6, p0_.show_in_printout AS show_in_printout_7, p0_.can_create_orders AS can_create_orders_8, p0_.active AS active_9, COALESCE(SUM(c1_.amount), 0) AS sclr_10, p0_.user AS user_11 FROM person p0_ LEFT JOIN coffee c1_ ON (c1_.person = p0_.id) GROUP BY p0_.id HAVING COALESCE(SUM(c1_.amount), 0) < 0 ORDER BY sclr_10 ASC, p0_.name ASC, p0_.id ASC;

SELECT
  c0_.id AS id_0,
  c0_.date AS date_1,
  c0_.amount AS amount_2,
  c0_.note AS note_3,
  c0_.confirmed AS confirmed_4,
  p1_.id AS id_5,
  p1_.employee AS employee_6,
  p1_.name AS name_7,
  p1_.shortcut AS shortcut_8,
  p1_.bank_account AS bank_account_9,
  p1_.bank_account_prefix AS bank_account_prefix_10,
  p1_.bank_account_code AS bank_account_code_11,
  p1_.show_in_printout AS show_in_printout_12,
  p1_.can_create_orders AS can_create_orders_13,
  p1_.active AS active_14,
  p2_.id AS id_15,
  p2_.employee AS employee_16,
  p2_.name AS name_17,
  p2_.shortcut AS shortcut_18,
  p2_.bank_account AS bank_account_19,
  p2_.bank_account_prefix AS bank_account_prefix_20,
  p2_.bank_account_code AS bank_account_code_21,
  p2_.show_in_printout AS show_in_printout_22,
  p2_.can_create_orders AS can_create_orders_23,
  p2_.active AS active_24,
  c0_.person AS person_25,
  c0_.confirmed_by AS confirmed_by_26,
  p1_.user AS user_27,
  p2_.user AS user_28
FROM
  coffee c0_
  LEFT JOIN person p1_ ON c0_.person = p1_.id
  LEFT JOIN person p2_ ON c0_.confirmed_by = p2_.id
WHERE
  c0_.confirmed = ?
ORDER BY
  c0_.date DESC,
  c0_.id DESC
LIMIT
  15

SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.amount AS amount_2, c0_.note AS note_3, c0_.confirmed AS confirmed_4, p1_.id AS id_5, p1_.employee AS employee_6, p1_.name AS name_7, p1_.shortcut AS shortcut_8, p1_.bank_account AS bank_account_9, p1_.bank_account_prefix AS bank_account_prefix_10, p1_.bank_account_code AS bank_account_code_11, p1_.show_in_printout AS show_in_printout_12, p1_.can_create_orders AS can_create_orders_13, p1_.active AS active_14, p2_.id AS id_15, p2_.employee AS employee_16, p2_.name AS name_17, p2_.shortcut AS shortcut_18, p2_.bank_account AS bank_account_19, p2_.bank_account_prefix AS bank_account_prefix_20, p2_.bank_account_code AS bank_account_code_21, p2_.show_in_printout AS show_in_printout_22, p2_.can_create_orders AS can_create_orders_23, p2_.active AS active_24, c0_.person AS person_25, c0_.confirmed_by AS confirmed_by_26, p1_.user AS user_27, p2_.user AS user_28 FROM coffee c0_ LEFT JOIN person p1_ ON c0_.person = p1_.id LEFT JOIN person p2_ ON c0_.confirmed_by = p2_.id WHERE c0_.confirmed = 0 ORDER BY c0_.date DESC, c0_.id DESC LIMIT 15;

SELECT
  COALESCE(
    SUM(m0_.amount),
    0
  ) AS sclr_0
FROM
  money m0_

SELECT COALESCE(SUM(m0_.amount), 0) AS sclr_0 FROM money m0_;

SELECT
  m0_.id AS id_0,
  m0_.amount AS amount_1,
  m0_.note AS note_2,
  m0_.date AS date_3,
  m0_.inserted_on AS inserted_on_4,
  p1_.id AS id_5,
  p1_.employee AS employee_6,
  p1_.name AS name_7,
  p1_.shortcut AS shortcut_8,
  p1_.bank_account AS bank_account_9,
  p1_.bank_account_prefix AS bank_account_prefix_10,
  p1_.bank_account_code AS bank_account_code_11,
  p1_.show_in_printout AS show_in_printout_12,
  p1_.can_create_orders AS can_create_orders_13,
  p1_.active AS active_14,
  c2_.id AS id_15,
  c2_.date AS date_16,
  c2_.amount AS amount_17,
  c2_.note AS note_18,
  c2_.confirmed AS confirmed_19,
  m0_.inserted_by AS inserted_by_20,
  m0_.coffee_id AS coffee_id_21,
  p1_.user AS user_22,
  c2_.person AS person_23,
  c2_.confirmed_by AS confirmed_by_24
FROM
  money m0_
  LEFT JOIN person p1_ ON m0_.inserted_by = p1_.id
  LEFT JOIN coffee c2_ ON m0_.coffee_id = c2_.id
ORDER BY
  m0_.date DESC,
  m0_.id DESC
LIMIT
  5

SELECT m0_.id AS id_0, m0_.amount AS amount_1, m0_.note AS note_2, m0_.date AS date_3, m0_.inserted_on AS inserted_on_4, p1_.id AS id_5, p1_.employee AS employee_6, p1_.name AS name_7, p1_.shortcut AS shortcut_8, p1_.bank_account AS bank_account_9, p1_.bank_account_prefix AS bank_account_prefix_10, p1_.bank_account_code AS bank_account_code_11, p1_.show_in_printout AS show_in_printout_12, p1_.can_create_orders AS can_create_orders_13, p1_.active AS active_14, c2_.id AS id_15, c2_.date AS date_16, c2_.amount AS amount_17, c2_.note AS note_18, c2_.confirmed AS confirmed_19, m0_.inserted_by AS inserted_by_20, m0_.coffee_id AS coffee_id_21, p1_.user AS user_22, c2_.person AS person_23, c2_.confirmed_by AS confirmed_by_24 FROM money m0_ LEFT JOIN person p1_ ON m0_.inserted_by = p1_.id LEFT JOIN coffee c2_ ON m0_.coffee_id = c2_.id ORDER BY m0_.date DESC, m0_.id DESC LIMIT 5;