Symfony Profiler

SELECT
  h0_.id AS id_0,
  h0_.description AS description_1,
  h0_.public AS public_2,
  h0_.world AS world_3,
  h0_.title AS title_4,
  h0_.start_latitude AS start_latitude_5,
  h0_.start_longitude AS start_longitude_6,
  h0_.start_city AS start_city_7,
  h0_.created_at AS created_at_8,
  h0_.updated_at AS updated_at_9,
  p1_.id AS id_10,
  p1_.cost AS cost_11,
  p1_.participants_limit AS participants_limit_12,
  h0_.organizer_id AS organizer_id_13,
  p1_.hunt_id AS hunt_id_14
FROM
  hunt h0_
  LEFT JOIN participation_condition p1_ ON h0_.id = p1_.hunt_id
  LEFT JOIN participant_hunt p3_ ON h0_.id = p3_.hunt_id
  LEFT JOIN participant p2_ ON p2_.id = p3_.participant_id
  LEFT JOIN user u4_ ON p2_.id = u4_.id
WHERE
  h0_.public = 1
ORDER BY
  h0_.created_at DESC

SELECT h0_.id AS id_0, h0_.description AS description_1, h0_.public AS public_2, h0_.world AS world_3, h0_.title AS title_4, h0_.start_latitude AS start_latitude_5, h0_.start_longitude AS start_longitude_6, h0_.start_city AS start_city_7, h0_.created_at AS created_at_8, h0_.updated_at AS updated_at_9, p1_.id AS id_10, p1_.cost AS cost_11, p1_.participants_limit AS participants_limit_12, h0_.organizer_id AS organizer_id_13, p1_.hunt_id AS hunt_id_14 FROM hunt h0_ LEFT JOIN participation_condition p1_ ON h0_.id = p1_.hunt_id LEFT JOIN participant_hunt p3_ ON h0_.id = p3_.hunt_id LEFT JOIN participant p2_ ON p2_.id = p3_.participant_id LEFT JOIN user u4_ ON p2_.id = u4_.id WHERE h0_.public = 1 ORDER BY h0_.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.latitude AS latitude_2,
  t0.longitude AS longitude_3,
  t0.radius AS radius_4,
  t0.hunt_id AS hunt_id_5
FROM
  landmark t0
WHERE
  t0.hunt_id = ?

SELECT t0.id AS id_1, t0.latitude AS latitude_2, t0.longitude AS longitude_3, t0.radius AS radius_4, t0.hunt_id AS hunt_id_5 FROM landmark t0 WHERE t0.hunt_id = 11;

SELECT
  t0.id AS id_1,
  t0.latitude AS latitude_2,
  t0.longitude AS longitude_3,
  t0.radius AS radius_4,
  t0.hunt_id AS hunt_id_5
FROM
  landmark t0
WHERE
  t0.hunt_id = ?

SELECT t0.id AS id_1, t0.latitude AS latitude_2, t0.longitude AS longitude_3, t0.radius AS radius_4, t0.hunt_id AS hunt_id_5 FROM landmark t0 WHERE t0.hunt_id = 10;

SELECT
  t0.id AS id_1,
  t0.latitude AS latitude_2,
  t0.longitude AS longitude_3,
  t0.radius AS radius_4,
  t0.hunt_id AS hunt_id_5
FROM
  landmark t0
WHERE
  t0.hunt_id = ?

SELECT t0.id AS id_1, t0.latitude AS latitude_2, t0.longitude AS longitude_3, t0.radius AS radius_4, t0.hunt_id AS hunt_id_5 FROM landmark t0 WHERE t0.hunt_id = 2;

SELECT
  t0.id AS id_1,
  t0.latitude AS latitude_2,
  t0.longitude AS longitude_3,
  t0.radius AS radius_4,
  t0.hunt_id AS hunt_id_5
FROM
  landmark t0
WHERE
  t0.hunt_id = ?

SELECT t0.id AS id_1, t0.latitude AS latitude_2, t0.longitude AS longitude_3, t0.radius AS radius_4, t0.hunt_id AS hunt_id_5 FROM landmark t0 WHERE t0.hunt_id = 3;

SELECT
  t0.id AS id_1,
  t0.latitude AS latitude_2,
  t0.longitude AS longitude_3,
  t0.radius AS radius_4,
  t0.hunt_id AS hunt_id_5
FROM
  landmark t0
WHERE
  t0.hunt_id = ?

SELECT t0.id AS id_1, t0.latitude AS latitude_2, t0.longitude AS longitude_3, t0.radius AS radius_4, t0.hunt_id AS hunt_id_5 FROM landmark t0 WHERE t0.hunt_id = 9;

SELECT
  t0.id AS id_1,
  t0.latitude AS latitude_2,
  t0.longitude AS longitude_3,
  t0.radius AS radius_4,
  t0.hunt_id AS hunt_id_5
FROM
  landmark t0
WHERE
  t0.hunt_id = ?

SELECT t0.id AS id_1, t0.latitude AS latitude_2, t0.longitude AS longitude_3, t0.radius AS radius_4, t0.hunt_id AS hunt_id_5 FROM landmark t0 WHERE t0.hunt_id = 6;

SELECT
  t0.id AS id_1,
  t0.latitude AS latitude_2,
  t0.longitude AS longitude_3,
  t0.radius AS radius_4,
  t0.hunt_id AS hunt_id_5
FROM
  landmark t0
WHERE
  t0.hunt_id = ?

SELECT t0.id AS id_1, t0.latitude AS latitude_2, t0.longitude AS longitude_3, t0.radius AS radius_4, t0.hunt_id AS hunt_id_5 FROM landmark t0 WHERE t0.hunt_id = 7;

SELECT
  t0.id AS id_1,
  t0.latitude AS latitude_2,
  t0.longitude AS longitude_3,
  t0.radius AS radius_4,
  t0.hunt_id AS hunt_id_5
FROM
  landmark t0
WHERE
  t0.hunt_id = ?

SELECT t0.id AS id_1, t0.latitude AS latitude_2, t0.longitude AS longitude_3, t0.radius AS radius_4, t0.hunt_id AS hunt_id_5 FROM landmark t0 WHERE t0.hunt_id = 5;

SELECT
  t0.id AS id_1,
  t0.latitude AS latitude_2,
  t0.longitude AS longitude_3,
  t0.radius AS radius_4,
  t0.hunt_id AS hunt_id_5
FROM
  landmark t0
WHERE
  t0.hunt_id = ?

SELECT t0.id AS id_1, t0.latitude AS latitude_2, t0.longitude AS longitude_3, t0.radius AS radius_4, t0.hunt_id AS hunt_id_5 FROM landmark t0 WHERE t0.hunt_id = 12;

SELECT
  t1.id AS id_2,
  t1.username AS username_3,
  t1.firstname AS firstname_4,
  t1.lastname AS lastname_5,
  t1.mail_address AS mail_address_6,
  t1.password AS password_7,
  t1.created AS created_8,
  t1.updated AS updated_9,
  t0.crowns AS crowns_10,
  t0.completed_hunts_count AS completed_hunts_count_11,
  t0.avatar_path AS avatar_path_12,
  t1.discriminator
FROM
  participant t0
  INNER JOIN user t1 ON t0.id = t1.id
  INNER JOIN participant_hunt ON t0.id = participant_hunt.participant_id
WHERE
  participant_hunt.hunt_id = ?

SELECT t1.id AS id_2, t1.username AS username_3, t1.firstname AS firstname_4, t1.lastname AS lastname_5, t1.mail_address AS mail_address_6, t1.password AS password_7, t1.created AS created_8, t1.updated AS updated_9, t0.crowns AS crowns_10, t0.completed_hunts_count AS completed_hunts_count_11, t0.avatar_path AS avatar_path_12, t1.discriminator FROM participant t0 INNER JOIN user t1 ON t0.id = t1.id INNER JOIN participant_hunt ON t0.id = participant_hunt.participant_id WHERE participant_hunt.hunt_id = 11;

SELECT
  t1.id AS id_2,
  t1.username AS username_3,
  t1.firstname AS firstname_4,
  t1.lastname AS lastname_5,
  t1.mail_address AS mail_address_6,
  t1.password AS password_7,
  t1.created AS created_8,
  t1.updated AS updated_9,
  t1.discriminator
FROM
  organizer t0
  INNER JOIN user t1 ON t0.id = t1.id
WHERE
  t1.id = ?

SELECT t1.id AS id_2, t1.username AS username_3, t1.firstname AS firstname_4, t1.lastname AS lastname_5, t1.mail_address AS mail_address_6, t1.password AS password_7, t1.created AS created_8, t1.updated AS updated_9, t1.discriminator FROM organizer t0 INNER JOIN user t1 ON t0.id = t1.id WHERE t1.id = 247;

SELECT
  t0.id AS id_1,
  t0.crown_amount AS crown_amount_2,
  t0.hunt_id AS hunt_id_3
FROM
  reward t0
WHERE
  t0.hunt_id = ?

SELECT t0.id AS id_1, t0.crown_amount AS crown_amount_2, t0.hunt_id AS hunt_id_3 FROM reward t0 WHERE t0.hunt_id = 11;

SELECT
  t1.id AS id_2,
  t1.username AS username_3,
  t1.firstname AS firstname_4,
  t1.lastname AS lastname_5,
  t1.mail_address AS mail_address_6,
  t1.password AS password_7,
  t1.created AS created_8,
  t1.updated AS updated_9,
  t0.crowns AS crowns_10,
  t0.completed_hunts_count AS completed_hunts_count_11,
  t0.avatar_path AS avatar_path_12,
  t1.discriminator
FROM
  participant t0
  INNER JOIN user t1 ON t0.id = t1.id
  INNER JOIN participant_hunt ON t0.id = participant_hunt.participant_id
WHERE
  participant_hunt.hunt_id = ?

SELECT t1.id AS id_2, t1.username AS username_3, t1.firstname AS firstname_4, t1.lastname AS lastname_5, t1.mail_address AS mail_address_6, t1.password AS password_7, t1.created AS created_8, t1.updated AS updated_9, t0.crowns AS crowns_10, t0.completed_hunts_count AS completed_hunts_count_11, t0.avatar_path AS avatar_path_12, t1.discriminator FROM participant t0 INNER JOIN user t1 ON t0.id = t1.id INNER JOIN participant_hunt ON t0.id = participant_hunt.participant_id WHERE participant_hunt.hunt_id = 10;

SELECT
  t1.id AS id_2,
  t1.username AS username_3,
  t1.firstname AS firstname_4,
  t1.lastname AS lastname_5,
  t1.mail_address AS mail_address_6,
  t1.password AS password_7,
  t1.created AS created_8,
  t1.updated AS updated_9,
  t1.discriminator
FROM
  organizer t0
  INNER JOIN user t1 ON t0.id = t1.id
WHERE
  t1.id = ?

SELECT t1.id AS id_2, t1.username AS username_3, t1.firstname AS firstname_4, t1.lastname AS lastname_5, t1.mail_address AS mail_address_6, t1.password AS password_7, t1.created AS created_8, t1.updated AS updated_9, t1.discriminator FROM organizer t0 INNER JOIN user t1 ON t0.id = t1.id WHERE t1.id = 246;

SELECT
  t0.id AS id_1,
  t0.crown_amount AS crown_amount_2,
  t0.hunt_id AS hunt_id_3
FROM
  reward t0
WHERE
  t0.hunt_id = ?

SELECT t0.id AS id_1, t0.crown_amount AS crown_amount_2, t0.hunt_id AS hunt_id_3 FROM reward t0 WHERE t0.hunt_id = 10;

SELECT
  t1.id AS id_2,
  t1.username AS username_3,
  t1.firstname AS firstname_4,
  t1.lastname AS lastname_5,
  t1.mail_address AS mail_address_6,
  t1.password AS password_7,
  t1.created AS created_8,
  t1.updated AS updated_9,
  t0.crowns AS crowns_10,
  t0.completed_hunts_count AS completed_hunts_count_11,
  t0.avatar_path AS avatar_path_12,
  t1.discriminator
FROM
  participant t0
  INNER JOIN user t1 ON t0.id = t1.id
  INNER JOIN participant_hunt ON t0.id = participant_hunt.participant_id
WHERE
  participant_hunt.hunt_id = ?

SELECT t1.id AS id_2, t1.username AS username_3, t1.firstname AS firstname_4, t1.lastname AS lastname_5, t1.mail_address AS mail_address_6, t1.password AS password_7, t1.created AS created_8, t1.updated AS updated_9, t0.crowns AS crowns_10, t0.completed_hunts_count AS completed_hunts_count_11, t0.avatar_path AS avatar_path_12, t1.discriminator FROM participant t0 INNER JOIN user t1 ON t0.id = t1.id INNER JOIN participant_hunt ON t0.id = participant_hunt.participant_id WHERE participant_hunt.hunt_id = 2;

SELECT
  t0.id AS id_1,
  t0.crown_amount AS crown_amount_2,
  t0.hunt_id AS hunt_id_3
FROM
  reward t0
WHERE
  t0.hunt_id = ?

SELECT t0.id AS id_1, t0.crown_amount AS crown_amount_2, t0.hunt_id AS hunt_id_3 FROM reward t0 WHERE t0.hunt_id = 2;

SELECT
  t1.id AS id_2,
  t1.username AS username_3,
  t1.firstname AS firstname_4,
  t1.lastname AS lastname_5,
  t1.mail_address AS mail_address_6,
  t1.password AS password_7,
  t1.created AS created_8,
  t1.updated AS updated_9,
  t0.crowns AS crowns_10,
  t0.completed_hunts_count AS completed_hunts_count_11,
  t0.avatar_path AS avatar_path_12,
  t1.discriminator
FROM
  participant t0
  INNER JOIN user t1 ON t0.id = t1.id
  INNER JOIN participant_hunt ON t0.id = participant_hunt.participant_id
WHERE
  participant_hunt.hunt_id = ?

SELECT t1.id AS id_2, t1.username AS username_3, t1.firstname AS firstname_4, t1.lastname AS lastname_5, t1.mail_address AS mail_address_6, t1.password AS password_7, t1.created AS created_8, t1.updated AS updated_9, t0.crowns AS crowns_10, t0.completed_hunts_count AS completed_hunts_count_11, t0.avatar_path AS avatar_path_12, t1.discriminator FROM participant t0 INNER JOIN user t1 ON t0.id = t1.id INNER JOIN participant_hunt ON t0.id = participant_hunt.participant_id WHERE participant_hunt.hunt_id = 3;

SELECT
  t1.id AS id_2,
  t1.username AS username_3,
  t1.firstname AS firstname_4,
  t1.lastname AS lastname_5,
  t1.mail_address AS mail_address_6,
  t1.password AS password_7,
  t1.created AS created_8,
  t1.updated AS updated_9,
  t1.discriminator
FROM
  organizer t0
  INNER JOIN user t1 ON t0.id = t1.id
WHERE
  t1.id = ?

SELECT t1.id AS id_2, t1.username AS username_3, t1.firstname AS firstname_4, t1.lastname AS lastname_5, t1.mail_address AS mail_address_6, t1.password AS password_7, t1.created AS created_8, t1.updated AS updated_9, t1.discriminator FROM organizer t0 INNER JOIN user t1 ON t0.id = t1.id WHERE t1.id = 248;

SELECT
  t0.id AS id_1,
  t0.crown_amount AS crown_amount_2,
  t0.hunt_id AS hunt_id_3
FROM
  reward t0
WHERE
  t0.hunt_id = ?

SELECT t0.id AS id_1, t0.crown_amount AS crown_amount_2, t0.hunt_id AS hunt_id_3 FROM reward t0 WHERE t0.hunt_id = 3;

SELECT
  t1.id AS id_2,
  t1.username AS username_3,
  t1.firstname AS firstname_4,
  t1.lastname AS lastname_5,
  t1.mail_address AS mail_address_6,
  t1.password AS password_7,
  t1.created AS created_8,
  t1.updated AS updated_9,
  t0.crowns AS crowns_10,
  t0.completed_hunts_count AS completed_hunts_count_11,
  t0.avatar_path AS avatar_path_12,
  t1.discriminator
FROM
  participant t0
  INNER JOIN user t1 ON t0.id = t1.id
  INNER JOIN participant_hunt ON t0.id = participant_hunt.participant_id
WHERE
  participant_hunt.hunt_id = ?

SELECT t1.id AS id_2, t1.username AS username_3, t1.firstname AS firstname_4, t1.lastname AS lastname_5, t1.mail_address AS mail_address_6, t1.password AS password_7, t1.created AS created_8, t1.updated AS updated_9, t0.crowns AS crowns_10, t0.completed_hunts_count AS completed_hunts_count_11, t0.avatar_path AS avatar_path_12, t1.discriminator FROM participant t0 INNER JOIN user t1 ON t0.id = t1.id INNER JOIN participant_hunt ON t0.id = participant_hunt.participant_id WHERE participant_hunt.hunt_id = 9;