Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.`group` AS group_2,
  GROUP_CONCAT(DISTINCT c1_.name SEPARATOR ', ') AS sclr_3,
  GROUP_CONCAT(DISTINCT c2_.name SEPARATOR ', ') AS sclr_4,
  GROUP_CONCAT(DISTINCT c3_.name SEPARATOR ', ') AS sclr_5,
  0 AS sclr_6
FROM
  csp c0_
  LEFT JOIN csp_country c4_ ON c0_.id = c4_.csp_id
  LEFT JOIN country c3_ ON c4_.country_id = c3_.id
  LEFT JOIN csp_csptype c5_ ON c0_.id = c5_.csp_id
  LEFT JOIN csptype c1_ ON c1_.id = c5_.csptype_id
  LEFT JOIN csp_company_type c6_ ON c0_.id = c6_.csp_id
  LEFT JOIN company_type c2_ ON c2_.id = c6_.company_type_id
WHERE
  c0_.trash = 0
  AND c0_.name LIKE ?
GROUP BY
  c0_.id
ORDER BY
  c0_.name ASC
LIMIT
  25

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.`group` AS group_2, GROUP_CONCAT(DISTINCT c1_.name SEPARATOR ', ') AS sclr_3, GROUP_CONCAT(DISTINCT c2_.name SEPARATOR ', ') AS sclr_4, GROUP_CONCAT(DISTINCT c3_.name SEPARATOR ', ') AS sclr_5, 0 AS sclr_6 FROM csp c0_ LEFT JOIN csp_country c4_ ON c0_.id = c4_.csp_id LEFT JOIN country c3_ ON c4_.country_id = c3_.id LEFT JOIN csp_csptype c5_ ON c0_.id = c5_.csp_id LEFT JOIN csptype c1_ ON c1_.id = c5_.csptype_id LEFT JOIN csp_company_type c6_ ON c0_.id = c6_.csp_id LEFT JOIN company_type c2_ ON c2_.id = c6_.company_type_id WHERE c0_.trash = 0 AND c0_.name LIKE '%Ciceker Consulting%' GROUP BY c0_.id ORDER BY c0_.name 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;

SELECT
  c0_.csp_id AS sclr_0,
  COUNT(c0_.id) AS sclr_1
FROM
  contact c0_
WHERE
  c0_.csp_id IN (?)
  AND c0_.trash = 0
GROUP BY
  c0_.csp_id

SELECT c0_.csp_id AS sclr_0, COUNT(c0_.id) AS sclr_1 FROM contact c0_ WHERE c0_.csp_id IN (6614) AND c0_.trash = 0 GROUP BY c0_.csp_id;