Symfony Profiler

SELECT
  count(DISTINCT u0_.id) AS sclr_0
FROM
  participant p1_
  INNER JOIN user u0_ ON p1_.id = u0_.id
  LEFT JOIN participant_hunt p3_ ON p1_.id = p3_.participant_id
  LEFT JOIN hunt h2_ ON h2_.id = p3_.hunt_id
  LEFT JOIN participant_badge p4_ ON p1_.id = p4_.participant_id
GROUP BY
  u0_.id

SELECT count(DISTINCT u0_.id) AS sclr_0 FROM participant p1_ INNER JOIN user u0_ ON p1_.id = u0_.id LEFT JOIN participant_hunt p3_ ON p1_.id = p3_.participant_id LEFT JOIN hunt h2_ ON h2_.id = p3_.hunt_id LEFT JOIN participant_badge p4_ ON p1_.id = p4_.participant_id GROUP BY u0_.id;

SELECT
  DISTINCT u0_.id AS id_0,
  p1_.completed_hunts_count AS completed_hunts_count_1,
  u0_.username AS username_2
FROM
  participant p1_
  INNER JOIN user u0_ ON p1_.id = u0_.id
  LEFT JOIN participant_hunt p3_ ON p1_.id = p3_.participant_id
  LEFT JOIN hunt h2_ ON h2_.id = p3_.hunt_id
  LEFT JOIN participant_badge p4_ ON p1_.id = p4_.participant_id
GROUP BY
  u0_.id
ORDER BY
  p1_.completed_hunts_count DESC,
  u0_.username ASC
LIMIT
  15
OFFSET
  15

SELECT DISTINCT u0_.id AS id_0, p1_.completed_hunts_count AS completed_hunts_count_1, u0_.username AS username_2 FROM participant p1_ INNER JOIN user u0_ ON p1_.id = u0_.id LEFT JOIN participant_hunt p3_ ON p1_.id = p3_.participant_id LEFT JOIN hunt h2_ ON h2_.id = p3_.hunt_id LEFT JOIN participant_badge p4_ ON p1_.id = p4_.participant_id GROUP BY u0_.id ORDER BY p1_.completed_hunts_count DESC, u0_.username ASC LIMIT 15 OFFSET 15;

SELECT
  u0_.id AS id_0,
  u0_.username AS username_1,
  u0_.firstname AS firstname_2,
  u0_.lastname AS lastname_3,
  u0_.mail_address AS mail_address_4,
  u0_.password AS password_5,
  u0_.created AS created_6,
  u0_.updated AS updated_7,
  p1_.crowns AS crowns_8,
  p1_.completed_hunts_count AS completed_hunts_count_9,
  p1_.avatar_path AS avatar_path_10,
  COUNT(DISTINCT h2_.id) AS sclr_11,
  COUNT(DISTINCT p3_.id) AS sclr_12,
  u0_.discriminator AS discriminator_13
FROM
  participant p1_
  INNER JOIN user u0_ ON p1_.id = u0_.id
  LEFT JOIN participant_hunt p4_ ON p1_.id = p4_.participant_id
  LEFT JOIN hunt h2_ ON h2_.id = p4_.hunt_id
  LEFT JOIN participant_badge p3_ ON p1_.id = p3_.participant_id
WHERE
  u0_.id IN (?, ?, ?, ?, ?)
GROUP BY
  u0_.id
ORDER BY
  p1_.completed_hunts_count DESC,
  u0_.username ASC

SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.firstname AS firstname_2, u0_.lastname AS lastname_3, u0_.mail_address AS mail_address_4, u0_.password AS password_5, u0_.created AS created_6, u0_.updated AS updated_7, p1_.crowns AS crowns_8, p1_.completed_hunts_count AS completed_hunts_count_9, p1_.avatar_path AS avatar_path_10, COUNT(DISTINCT h2_.id) AS sclr_11, COUNT(DISTINCT p3_.id) AS sclr_12, u0_.discriminator AS discriminator_13 FROM participant p1_ INNER JOIN user u0_ ON p1_.id = u0_.id LEFT JOIN participant_hunt p4_ ON p1_.id = p4_.participant_id LEFT JOIN hunt h2_ ON h2_.id = p4_.hunt_id LEFT JOIN participant_badge p3_ ON p1_.id = p3_.participant_id WHERE u0_.id IN (265, 259, 251, 249, 262) GROUP BY u0_.id ORDER BY p1_.completed_hunts_count DESC, u0_.username ASC;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.public AS public_3,
  t0.world AS world_4,
  t0.title AS title_5,
  t0.start_latitude AS start_latitude_6,
  t0.start_longitude AS start_longitude_7,
  t0.start_city AS start_city_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t11.id AS id_12,
  t11.cost AS cost_13,
  t11.participants_limit AS participants_limit_14,
  t11.hunt_id AS hunt_id_15,
  t0.organizer_id AS organizer_id_16,
  t17.id AS id_18,
  t17.latitude AS latitude_19,
  t17.longitude AS longitude_20,
  t17.radius AS radius_21,
  t17.hunt_id AS hunt_id_22
FROM
  hunt t0
  LEFT JOIN participation_condition t11 ON t11.hunt_id = t0.id
  LEFT JOIN landmark t17 ON t17.hunt_id = t0.id
  INNER JOIN participant_hunt ON t0.id = participant_hunt.hunt_id
WHERE
  participant_hunt.participant_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.public AS public_3, t0.world AS world_4, t0.title AS title_5, t0.start_latitude AS start_latitude_6, t0.start_longitude AS start_longitude_7, t0.start_city AS start_city_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t11.id AS id_12, t11.cost AS cost_13, t11.participants_limit AS participants_limit_14, t11.hunt_id AS hunt_id_15, t0.organizer_id AS organizer_id_16, t17.id AS id_18, t17.latitude AS latitude_19, t17.longitude AS longitude_20, t17.radius AS radius_21, t17.hunt_id AS hunt_id_22 FROM hunt t0 LEFT JOIN participation_condition t11 ON t11.hunt_id = t0.id LEFT JOIN landmark t17 ON t17.hunt_id = t0.id INNER JOIN participant_hunt ON t0.id = participant_hunt.hunt_id WHERE participant_hunt.participant_id = 265;

SELECT
  t0.id AS id_1,
  t0.obtained_at AS obtained_at_2,
  t0.participant_id AS participant_id_3,
  t0.badge_id AS badge_id_4
FROM
  participant_badge t0
WHERE
  t0.participant_id = ?

SELECT t0.id AS id_1, t0.obtained_at AS obtained_at_2, t0.participant_id AS participant_id_3, t0.badge_id AS badge_id_4 FROM participant_badge t0 WHERE t0.participant_id = 265;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.public AS public_3,
  t0.world AS world_4,
  t0.title AS title_5,
  t0.start_latitude AS start_latitude_6,
  t0.start_longitude AS start_longitude_7,
  t0.start_city AS start_city_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t11.id AS id_12,
  t11.cost AS cost_13,
  t11.participants_limit AS participants_limit_14,
  t11.hunt_id AS hunt_id_15,
  t0.organizer_id AS organizer_id_16,
  t17.id AS id_18,
  t17.latitude AS latitude_19,
  t17.longitude AS longitude_20,
  t17.radius AS radius_21,
  t17.hunt_id AS hunt_id_22
FROM
  hunt t0
  LEFT JOIN participation_condition t11 ON t11.hunt_id = t0.id
  LEFT JOIN landmark t17 ON t17.hunt_id = t0.id
  INNER JOIN participant_hunt ON t0.id = participant_hunt.hunt_id
WHERE
  participant_hunt.participant_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.public AS public_3, t0.world AS world_4, t0.title AS title_5, t0.start_latitude AS start_latitude_6, t0.start_longitude AS start_longitude_7, t0.start_city AS start_city_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t11.id AS id_12, t11.cost AS cost_13, t11.participants_limit AS participants_limit_14, t11.hunt_id AS hunt_id_15, t0.organizer_id AS organizer_id_16, t17.id AS id_18, t17.latitude AS latitude_19, t17.longitude AS longitude_20, t17.radius AS radius_21, t17.hunt_id AS hunt_id_22 FROM hunt t0 LEFT JOIN participation_condition t11 ON t11.hunt_id = t0.id LEFT JOIN landmark t17 ON t17.hunt_id = t0.id INNER JOIN participant_hunt ON t0.id = participant_hunt.hunt_id WHERE participant_hunt.participant_id = 259;

SELECT
  t0.id AS id_1,
  t0.obtained_at AS obtained_at_2,
  t0.participant_id AS participant_id_3,
  t0.badge_id AS badge_id_4
FROM
  participant_badge t0
WHERE
  t0.participant_id = ?

SELECT t0.id AS id_1, t0.obtained_at AS obtained_at_2, t0.participant_id AS participant_id_3, t0.badge_id AS badge_id_4 FROM participant_badge t0 WHERE t0.participant_id = 259;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.public AS public_3,
  t0.world AS world_4,
  t0.title AS title_5,
  t0.start_latitude AS start_latitude_6,
  t0.start_longitude AS start_longitude_7,
  t0.start_city AS start_city_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t11.id AS id_12,
  t11.cost AS cost_13,
  t11.participants_limit AS participants_limit_14,
  t11.hunt_id AS hunt_id_15,
  t0.organizer_id AS organizer_id_16,
  t17.id AS id_18,
  t17.latitude AS latitude_19,
  t17.longitude AS longitude_20,
  t17.radius AS radius_21,
  t17.hunt_id AS hunt_id_22
FROM
  hunt t0
  LEFT JOIN participation_condition t11 ON t11.hunt_id = t0.id
  LEFT JOIN landmark t17 ON t17.hunt_id = t0.id
  INNER JOIN participant_hunt ON t0.id = participant_hunt.hunt_id
WHERE
  participant_hunt.participant_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.public AS public_3, t0.world AS world_4, t0.title AS title_5, t0.start_latitude AS start_latitude_6, t0.start_longitude AS start_longitude_7, t0.start_city AS start_city_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t11.id AS id_12, t11.cost AS cost_13, t11.participants_limit AS participants_limit_14, t11.hunt_id AS hunt_id_15, t0.organizer_id AS organizer_id_16, t17.id AS id_18, t17.latitude AS latitude_19, t17.longitude AS longitude_20, t17.radius AS radius_21, t17.hunt_id AS hunt_id_22 FROM hunt t0 LEFT JOIN participation_condition t11 ON t11.hunt_id = t0.id LEFT JOIN landmark t17 ON t17.hunt_id = t0.id INNER JOIN participant_hunt ON t0.id = participant_hunt.hunt_id WHERE participant_hunt.participant_id = 251;

SELECT
  t0.id AS id_1,
  t0.obtained_at AS obtained_at_2,
  t0.participant_id AS participant_id_3,
  t0.badge_id AS badge_id_4
FROM
  participant_badge t0
WHERE
  t0.participant_id = ?

SELECT t0.id AS id_1, t0.obtained_at AS obtained_at_2, t0.participant_id AS participant_id_3, t0.badge_id AS badge_id_4 FROM participant_badge t0 WHERE t0.participant_id = 251;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.public AS public_3,
  t0.world AS world_4,
  t0.title AS title_5,
  t0.start_latitude AS start_latitude_6,
  t0.start_longitude AS start_longitude_7,
  t0.start_city AS start_city_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t11.id AS id_12,
  t11.cost AS cost_13,
  t11.participants_limit AS participants_limit_14,
  t11.hunt_id AS hunt_id_15,
  t0.organizer_id AS organizer_id_16,
  t17.id AS id_18,
  t17.latitude AS latitude_19,
  t17.longitude AS longitude_20,
  t17.radius AS radius_21,
  t17.hunt_id AS hunt_id_22
FROM
  hunt t0
  LEFT JOIN participation_condition t11 ON t11.hunt_id = t0.id
  LEFT JOIN landmark t17 ON t17.hunt_id = t0.id
  INNER JOIN participant_hunt ON t0.id = participant_hunt.hunt_id
WHERE
  participant_hunt.participant_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.public AS public_3, t0.world AS world_4, t0.title AS title_5, t0.start_latitude AS start_latitude_6, t0.start_longitude AS start_longitude_7, t0.start_city AS start_city_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t11.id AS id_12, t11.cost AS cost_13, t11.participants_limit AS participants_limit_14, t11.hunt_id AS hunt_id_15, t0.organizer_id AS organizer_id_16, t17.id AS id_18, t17.latitude AS latitude_19, t17.longitude AS longitude_20, t17.radius AS radius_21, t17.hunt_id AS hunt_id_22 FROM hunt t0 LEFT JOIN participation_condition t11 ON t11.hunt_id = t0.id LEFT JOIN landmark t17 ON t17.hunt_id = t0.id INNER JOIN participant_hunt ON t0.id = participant_hunt.hunt_id WHERE participant_hunt.participant_id = 249;

SELECT
  t0.id AS id_1,
  t0.obtained_at AS obtained_at_2,
  t0.participant_id AS participant_id_3,
  t0.badge_id AS badge_id_4
FROM
  participant_badge t0
WHERE
  t0.participant_id = ?

SELECT t0.id AS id_1, t0.obtained_at AS obtained_at_2, t0.participant_id AS participant_id_3, t0.badge_id AS badge_id_4 FROM participant_badge t0 WHERE t0.participant_id = 249;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.public AS public_3,
  t0.world AS world_4,
  t0.title AS title_5,
  t0.start_latitude AS start_latitude_6,
  t0.start_longitude AS start_longitude_7,
  t0.start_city AS start_city_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t11.id AS id_12,
  t11.cost AS cost_13,
  t11.participants_limit AS participants_limit_14,
  t11.hunt_id AS hunt_id_15,
  t0.organizer_id AS organizer_id_16,
  t17.id AS id_18,
  t17.latitude AS latitude_19,
  t17.longitude AS longitude_20,
  t17.radius AS radius_21,
  t17.hunt_id AS hunt_id_22
FROM
  hunt t0
  LEFT JOIN participation_condition t11 ON t11.hunt_id = t0.id
  LEFT JOIN landmark t17 ON t17.hunt_id = t0.id
  INNER JOIN participant_hunt ON t0.id = participant_hunt.hunt_id
WHERE
  participant_hunt.participant_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.public AS public_3, t0.world AS world_4, t0.title AS title_5, t0.start_latitude AS start_latitude_6, t0.start_longitude AS start_longitude_7, t0.start_city AS start_city_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t11.id AS id_12, t11.cost AS cost_13, t11.participants_limit AS participants_limit_14, t11.hunt_id AS hunt_id_15, t0.organizer_id AS organizer_id_16, t17.id AS id_18, t17.latitude AS latitude_19, t17.longitude AS longitude_20, t17.radius AS radius_21, t17.hunt_id AS hunt_id_22 FROM hunt t0 LEFT JOIN participation_condition t11 ON t11.hunt_id = t0.id LEFT JOIN landmark t17 ON t17.hunt_id = t0.id INNER JOIN participant_hunt ON t0.id = participant_hunt.hunt_id WHERE participant_hunt.participant_id = 262;

SELECT
  t0.id AS id_1,
  t0.obtained_at AS obtained_at_2,
  t0.participant_id AS participant_id_3,
  t0.badge_id AS badge_id_4
FROM
  participant_badge t0
WHERE
  t0.participant_id = ?

SELECT t0.id AS id_1, t0.obtained_at AS obtained_at_2, t0.participant_id AS participant_id_3, t0.badge_id AS badge_id_4 FROM participant_badge t0 WHERE t0.participant_id = 262;