Symfony Profiler

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.hcp_id AS sclr_1
FROM
  customer c0_
  LEFT JOIN hcp h1_ ON c0_.hcp_id = h1_.id
ORDER BY
  c0_.hcp_id DESC
LIMIT
  20

SELECT DISTINCT c0_.id AS id_0, c0_.hcp_id AS sclr_1 FROM customer c0_ LEFT JOIN hcp h1_ ON c0_.hcp_id = h1_.id ORDER BY c0_.hcp_id DESC LIMIT 20;

SELECT
  c0_.id AS id_0,
  c0_.customer_id AS customer_id_1,
  c0_.name AS name_2,
  c0_.email AS email_3,
  c0_.hcp_id AS hcp_id_4
FROM
  customer c0_
  LEFT JOIN hcp h1_ ON c0_.hcp_id = h1_.id
WHERE
  c0_.id IN (?)
ORDER BY
  c0_.hcp_id DESC

SELECT c0_.id AS id_0, c0_.customer_id AS customer_id_1, c0_.name AS name_2, c0_.email AS email_3, c0_.hcp_id AS hcp_id_4 FROM customer c0_ LEFT JOIN hcp h1_ ON c0_.hcp_id = h1_.id WHERE c0_.id IN (173, 172) ORDER BY c0_.hcp_id DESC;

SELECT
  count(DISTINCT c0_.id) AS sclr_0
FROM
  customer c0_
  LEFT JOIN hcp h1_ ON c0_.hcp_id = h1_.id

SELECT count(DISTINCT c0_.id) AS sclr_0 FROM customer c0_ LEFT JOIN hcp h1_ ON c0_.hcp_id = h1_.id;

SELECT
  t0.id AS id_1,
  t0.hcp_id AS hcp_id_2,
  t0.name AS name_3,
  t0.email AS email_4,
  t0.phone_number AS phone_number_5,
  t0.customer_number AS customer_number_6
FROM
  hcp t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.hcp_id AS hcp_id_2, t0.name AS name_3, t0.email AS email_4, t0.phone_number AS phone_number_5, t0.customer_number AS customer_number_6 FROM hcp t0 WHERE t0.id = 89;