Symfony Profiler

SELECT
  COUNT(DISTINCT c0_.id) AS sclr_0,
  COUNT(DISTINCT c1_.id) AS sclr_1,
  COUNT(DISTINCT c2_.id) AS sclr_2
FROM
  contact c3_
  INNER JOIN csp_country c2_ ON (
    c2_.csp_id = c3_.csp_id
    AND c2_.country_id = c3_.country_id
  )
  INNER JOIN csp c0_ ON c3_.csp_id = c0_.id
  LEFT JOIN country c1_ ON c3_.country_id = c1_.id
WHERE
  c3_.trash = 0
  AND c3_.fname LIKE ?
  AND c3_.lname LIKE ?

SELECT COUNT(DISTINCT c0_.id) AS sclr_0, COUNT(DISTINCT c1_.id) AS sclr_1, COUNT(DISTINCT c2_.id) AS sclr_2 FROM contact c3_ INNER JOIN csp_country c2_ ON (c2_.csp_id = c3_.csp_id AND c2_.country_id = c3_.country_id) INNER JOIN csp c0_ ON c3_.csp_id = c0_.id LEFT JOIN country c1_ ON c3_.country_id = c1_.id WHERE c3_.trash = 0 AND c3_.fname LIKE '%peter%' AND c3_.lname LIKE '%Nonye%';

SELECT
  COUNT(DISTINCT c0_.id) AS sclr_0
FROM
  contact c0_
WHERE
  c0_.trash = 0
  AND c0_.fname LIKE ?
  AND c0_.lname LIKE ?

SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM contact c0_ WHERE c0_.trash = 0 AND c0_.fname LIKE '%peter%' AND c0_.lname LIKE '%Nonye%';

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;