Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.fname AS fname_1,
  c0_.lname AS lname_2,
  c0_.position AS position_3,
  c0_.division AS division_4,
  c0_.email AS email_5,
  c1_.name AS name_6,
  c2_.name AS name_7,
  c3_.name AS name_8
FROM
  contact c0_
  INNER JOIN csp c1_ ON c0_.csp_id = c1_.id
  LEFT JOIN csptype c3_ ON c0_.csptype_id = c3_.id
  LEFT JOIN country c2_ ON c0_.country_id = c2_.id
WHERE
  c0_.trash = 0
  AND c0_.fname LIKE ?
  AND c0_.lname LIKE ?
GROUP BY
  c0_.id
ORDER BY
  name_6 ASC
LIMIT
  25

SELECT c0_.id AS id_0, c0_.fname AS fname_1, c0_.lname AS lname_2, c0_.position AS position_3, c0_.division AS division_4, c0_.email AS email_5, c1_.name AS name_6, c2_.name AS name_7, c3_.name AS name_8 FROM contact c0_ INNER JOIN csp c1_ ON c0_.csp_id = c1_.id LEFT JOIN csptype c3_ ON c0_.csptype_id = c3_.id LEFT JOIN country c2_ ON c0_.country_id = c2_.id WHERE c0_.trash = 0 AND c0_.fname LIKE '%peter%' AND c0_.lname LIKE '%Awurum%' GROUP BY c0_.id ORDER BY name_6 ASC LIMIT 25;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.password AS password_3,
  t0.lastname AS lastname_4,
  t0.firstname AS firstname_5,
  t0.email AS email_6,
  t0.is_active AS is_active_7,
  t0.role_id AS role_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.lastname AS lastname_4, t0.firstname AS firstname_5, t0.email AS email_6, t0.is_active AS is_active_7, t0.role_id AS role_id_8 FROM user t0 WHERE t0.id = 415;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.role AS role_3
FROM
  role t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.role AS role_3 FROM role t0 WHERE t0.id = 10;