2.58 ms (28.61%)
1
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 WHERE t0 . 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 WHERE t0 . id = 5 ;
Copy
2.39 ms (26.50%)
1
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 = 5 ;
Copy
1.86 ms (20.69%)
1
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 = 244 ;
Copy