6.90 ms (30.70%)
5
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 ;
Copy
4.96 ms (22.05%)
5
SELECT t0 . id AS id_1 , t0 . cost AS cost_2 , t0 . participants_limit AS participants_limit_3 , t0 . hunt_id AS hunt_id_4 FROM participation_condition t0 WHERE t0 . hunt_id = ?
SELECT t0 . id AS id_1 , t0 . cost AS cost_2 , t0 . participants_limit AS participants_limit_3 , t0 . hunt_id AS hunt_id_4 FROM participation_condition t0 WHERE t0 . hunt_id = 11 ;
Copy
4.87 ms (21.67%)
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 = 11 ;
Copy
3.78 ms (16.80%)
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 = 247 ;
Copy
1.98 ms (8.79%)
1
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 , h0_ . organizer_id AS organizer_id_10 FROM hunt h0_ WHERE h0_ . public = 1 ORDER BY h0_ . created_at DESC LIMIT 5
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 , h0_ . organizer_id AS organizer_id_10 FROM hunt h0_ WHERE h0_ . public = 1 ORDER BY h0_ . created_at DESC LIMIT 5 ;
Copy