Symfony Profiler

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;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.`group` AS group_3,
  t0.history AS history_4,
  t0.last_import AS last_import_5,
  t0.trash AS trash_6
FROM
  csp t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.`group` AS group_3, t0.history AS history_4, t0.last_import AS last_import_5, t0.trash AS trash_6 FROM csp t0 WHERE t0.id = '5643';

SELECT
  c0_.id AS id_0,
  c0_.phone AS phone_1,
  c0_.email_format AS email_format_2,
  c0_.website AS website_3,
  c0_.wikipedia AS wikipedia_4,
  c0_.method_1 AS method_1_5,
  c0_.method_2 AS method_2_6,
  c0_.valid_switchboard AS valid_switchboard_7,
  c0_.domain AS domain_8,
  c1_.name AS name_9,
  DATE_FORMAT(
    c0_.updated_at, '%d/%m/%Y %H:%i'
  ) AS sclr_10,
  COUNT(c2_.id) AS sclr_11
FROM
  csp_country c0_
  INNER JOIN country c1_ ON c0_.country_id = c1_.id
  LEFT JOIN contact c2_ ON (
    c2_.csp_id = c0_.csp_id
    AND c2_.country_id = c0_.country_id
  )
WHERE
  c0_.csp_id = ?
GROUP BY
  c0_.id
ORDER BY
  c1_.name ASC

SELECT c0_.id AS id_0, c0_.phone AS phone_1, c0_.email_format AS email_format_2, c0_.website AS website_3, c0_.wikipedia AS wikipedia_4, c0_.method_1 AS method_1_5, c0_.method_2 AS method_2_6, c0_.valid_switchboard AS valid_switchboard_7, c0_.domain AS domain_8, c1_.name AS name_9, DATE_FORMAT(c0_.updated_at, '%d/%m/%Y %H:%i') AS sclr_10, COUNT(c2_.id) AS sclr_11 FROM csp_country c0_ INNER JOIN country c1_ ON c0_.country_id = c1_.id LEFT JOIN contact c2_ ON (c2_.csp_id = c0_.csp_id AND c2_.country_id = c0_.country_id) WHERE c0_.csp_id = 5643 GROUP BY c0_.id ORDER BY c1_.name ASC;