#1 [20:54:06.812]
3.1ms
coach
SELECT coach.cpsa_number AS coach_cpsa_number, coach.id AS coach_id, coach.name AS coach_name, coach.active AS coach_active, coach.created_at AS coach_created_at, coach.photo_url AS coach_photo_url, coach.bio AS coach_bio, coach.specialties AS coach_specialties, coach.qualifications AS coach_qualifi…
#2 [20:54:06.827]
13.5ms
shooter
SELECT shooter.id AS shooter_id, shooter.cpsa_number AS shooter_cpsa_number, shooter.name AS shooter_name, shooter.category AS shooter_category, shooter.cpsa_url AS shooter_cpsa_url, shooter.cpsa_total_shoots AS shooter_cpsa_total_shoots, shooter.cpsa_total_shoots_checked_at AS shooter_cpsa_total_sh…
#3 [20:54:06.831]
2.5ms
shooter
SELECT shooter.id AS shooter_id, shooter.cpsa_number AS shooter_cpsa_number, shooter.name AS shooter_name, shooter.category AS shooter_category, shooter.cpsa_url AS shooter_cpsa_url, shooter.cpsa_total_shoots AS shooter_cpsa_total_shoots, shooter.cpsa_total_shoots_checked_at AS shooter_cpsa_total_sh…
#4 [20:54:06.833]
1.4ms
user
SELECT "user".id AS user_id, "user".username AS user_username, "user".email AS user_email, "user".password AS user_password, "user".verification_code AS user_verification_code, "user".verification_expiry AS user_verification_expiry, "user".verification_attempts AS user_verification_attempts, "user".…
#5 [20:54:06.836]
1.6ms
coach
SELECT coach.cpsa_number AS coach_cpsa_number, coach.id AS coach_id, coach.name AS coach_name, coach.active AS coach_active, coach.created_at AS coach_created_at, coach.photo_url AS coach_photo_url, coach.bio AS coach_bio, coach.specialties AS coach_specialties, coach.qualifications AS coach_qualifi…
#6 [20:54:06.839]
1.8ms
shooter
SELECT shooter.id AS shooter_id, shooter.cpsa_number AS shooter_cpsa_number, shooter.name AS shooter_name, shooter.category AS shooter_category, shooter.cpsa_url AS shooter_cpsa_url, shooter.cpsa_total_shoots AS shooter_cpsa_total_shoots, shooter.cpsa_total_shoots_checked_at AS shooter_cpsa_total_sh…
#7 [20:54:06.841]
1.3ms
user
SELECT "user".id AS user_id, "user".username AS user_username, "user".email AS user_email, "user".password AS user_password, "user".verification_code AS user_verification_code, "user".verification_expiry AS user_verification_expiry, "user".verification_attempts AS user_verification_attempts, "user".…
#8 [20:54:06.852]
11.0ms
shooter
SELECT shooter.id AS shooter_id, shooter.cpsa_number AS shooter_cpsa_number, shooter.name AS shooter_name, shooter.category AS shooter_category, shooter.cpsa_url AS shooter_cpsa_url, shooter.cpsa_total_shoots AS shooter_cpsa_total_shoots, shooter.cpsa_total_shoots_checked_at AS shooter_cpsa_total_sh…
#9 [20:54:06.854]
1.3ms
shooter
SELECT shooter.id AS shooter_id, shooter.cpsa_number AS shooter_cpsa_number, shooter.name AS shooter_name, shooter.category AS shooter_category, shooter.cpsa_url AS shooter_cpsa_url, shooter.cpsa_total_shoots AS shooter_cpsa_total_shoots, shooter.cpsa_total_shoots_checked_at AS shooter_cpsa_total_sh…
#10 [20:54:06.856]
1.5ms
user
SELECT "user".id AS user_id, "user".username AS user_username, "user".email AS user_email, "user".password AS user_password, "user".verification_code AS user_verification_code, "user".verification_expiry AS user_verification_expiry, "user".verification_attempts AS user_verification_attempts, "user".…
#11 [20:54:06.858]
1.3ms
coach
SELECT coach.cpsa_number AS coach_cpsa_number, coach.id AS coach_id, coach.name AS coach_name, coach.active AS coach_active, coach.created_at AS coach_created_at, coach.photo_url AS coach_photo_url, coach.bio AS coach_bio, coach.specialties AS coach_specialties, coach.qualifications AS coach_qualifi…
#12 [20:54:06.947]
88.3ms
shooter
SELECT shooter.id AS shooter_id, shooter.cpsa_number AS shooter_cpsa_number, shooter.name AS shooter_name, shooter.category AS shooter_category, shooter.cpsa_url AS shooter_cpsa_url, shooter.cpsa_total_shoots AS shooter_cpsa_total_shoots, shooter.cpsa_total_shoots_checked_at AS shooter_cpsa_total_sh…
#13 [20:54:06.949]
1.4ms
shooter
SELECT shooter.id AS shooter_id, shooter.cpsa_number AS shooter_cpsa_number, shooter.name AS shooter_name, shooter.category AS shooter_category, shooter.cpsa_url AS shooter_cpsa_url, shooter.cpsa_total_shoots AS shooter_cpsa_total_shoots, shooter.cpsa_total_shoots_checked_at AS shooter_cpsa_total_sh…
#14 [20:54:06.951]
1.5ms
user
SELECT "user".id AS user_id, "user".username AS user_username, "user".email AS user_email, "user".password AS user_password, "user".verification_code AS user_verification_code, "user".verification_expiry AS user_verification_expiry, "user".verification_attempts AS user_verification_attempts, "user".…
#15 [20:54:07.045]
92.6ms
shooter
SELECT shooter.id AS shooter_id, shooter.cpsa_number AS shooter_cpsa_number, shooter.name AS shooter_name, shooter.category AS shooter_category, shooter.cpsa_url AS shooter_cpsa_url, shooter.cpsa_total_shoots AS shooter_cpsa_total_shoots, shooter.cpsa_total_shoots_checked_at AS shooter_cpsa_total_sh…
#16 [20:54:07.048]
2.1ms
shooter
SELECT shooter.id AS shooter_id, shooter.cpsa_number AS shooter_cpsa_number, shooter.name AS shooter_name, shooter.category AS shooter_category, shooter.cpsa_url AS shooter_cpsa_url, shooter.cpsa_total_shoots AS shooter_cpsa_total_shoots, shooter.cpsa_total_shoots_checked_at AS shooter_cpsa_total_sh…
#17 [20:54:07.050]
1.7ms
user
SELECT "user".id AS user_id, "user".username AS user_username, "user".email AS user_email, "user".password AS user_password, "user".verification_code AS user_verification_code, "user".verification_expiry AS user_verification_expiry, "user".verification_attempts AS user_verification_attempts, "user".…
#18 [20:54:07.059]
8.5ms
shooter
SELECT shooter.id AS shooter_id, shooter.cpsa_number AS shooter_cpsa_number, shooter.name AS shooter_name, shooter.category AS shooter_category, shooter.cpsa_url AS shooter_cpsa_url, shooter.cpsa_total_shoots AS shooter_cpsa_total_shoots, shooter.cpsa_total_shoots_checked_at AS shooter_cpsa_total_sh…
#19 [20:54:07.144]
83.7ms
shooter
SELECT shooter.id AS shooter_id, shooter.cpsa_number AS shooter_cpsa_number, shooter.name AS shooter_name, shooter.category AS shooter_category, shooter.cpsa_url AS shooter_cpsa_url, shooter.cpsa_total_shoots AS shooter_cpsa_total_shoots, shooter.cpsa_total_shoots_checked_at AS shooter_cpsa_total_sh…
#20 [20:54:07.146]
1.3ms
user
SELECT "user".id AS user_id, "user".username AS user_username, "user".email AS user_email, "user".password AS user_password, "user".verification_code AS user_verification_code, "user".verification_expiry AS user_verification_expiry, "user".verification_attempts AS user_verification_attempts, "user".…
#21 [20:54:07.154]
7.8ms
shooter
SELECT shooter.id AS shooter_id, shooter.cpsa_number AS shooter_cpsa_number, shooter.name AS shooter_name, shooter.category AS shooter_category, shooter.cpsa_url AS shooter_cpsa_url, shooter.cpsa_total_shoots AS shooter_cpsa_total_shoots, shooter.cpsa_total_shoots_checked_at AS shooter_cpsa_total_sh…
#22 [20:54:07.156]
1.3ms
shooter
SELECT shooter.id AS shooter_id, shooter.cpsa_number AS shooter_cpsa_number, shooter.name AS shooter_name, shooter.category AS shooter_category, shooter.cpsa_url AS shooter_cpsa_url, shooter.cpsa_total_shoots AS shooter_cpsa_total_shoots, shooter.cpsa_total_shoots_checked_at AS shooter_cpsa_total_sh…
#23 [20:54:07.160]
3.2ms
user
SELECT "user".id AS user_id, "user".username AS user_username, "user".email AS user_email, "user".password AS user_password, "user".verification_code AS user_verification_code, "user".verification_expiry AS user_verification_expiry, "user".verification_attempts AS user_verification_attempts, "user".…
#24 [20:54:07.162]
1.4ms
shooter
SELECT shooter.id AS shooter_id, shooter.cpsa_number AS shooter_cpsa_number, shooter.name AS shooter_name, shooter.category AS shooter_category, shooter.cpsa_url AS shooter_cpsa_url, shooter.cpsa_total_shoots AS shooter_cpsa_total_shoots, shooter.cpsa_total_shoots_checked_at AS shooter_cpsa_total_sh…
#25 [20:54:07.167]
4.5ms
user
SELECT "user".id AS user_id, "user".username AS user_username, "user".email AS user_email, "user".password AS user_password, "user".verification_code AS user_verification_code, "user".verification_expiry AS user_verification_expiry, "user".verification_attempts AS user_verification_attempts, "user".…
#26 [20:54:07.249]
81.1ms
shooter
SELECT shooter.id AS shooter_id, shooter.cpsa_number AS shooter_cpsa_number, shooter.name AS shooter_name, shooter.category AS shooter_category, shooter.cpsa_url AS shooter_cpsa_url, shooter.cpsa_total_shoots AS shooter_cpsa_total_shoots, shooter.cpsa_total_shoots_checked_at AS shooter_cpsa_total_sh…
#27 [20:54:07.544]
293.3ms
user_coaches
SELECT user_coaches.coach_id AS user_coaches_coach_id, count(shoot_score.id) AS count_1
FROM user_coaches JOIN "user" ON "user".id = user_coaches.user_id JOIN shooter ON shooter.id = "user".shooter_id JOIN shoot_score ON shoot_score.shooter_id = shooter.id JOIN shoot_event ON shoot_event.id = shoot…
#28 [20:54:07.555]
9.3ms
shooter
SELECT shooter.cpsa_number AS shooter_cpsa_number, shoot_event.discipline AS shoot_event_discipline, avg(shoot_score.percentage) AS avg_1, count(shoot_score.id) AS count_1
FROM shooter JOIN shoot_score ON shoot_score.shooter_id = shooter.id JOIN shoot_event ON shoot_event.id = shoot_score.event_id …
#29 [20:54:07.558]
2.1ms
shooter
SELECT shooter.cpsa_number AS shooter_cpsa_number, shooter.id AS shooter_id
FROM shooter
WHERE shooter.cpsa_number IN (%(cpsa_number_1_1)s, %(cpsa_number_1_2)s, %(cpsa_number_1_3)s, %(cpsa_number_1_4)s, %(cpsa_number_1_5)s, %(cpsa_number_1_6)s, %(cpsa_number_1_7)s, %(cpsa_number_1_8)s, %(cpsa_numb…
#30 [20:54:07.749]
190.0ms
user_coaches
SELECT user_coaches.coach_id AS user_coaches_coach_id, "user".shooter_id AS user_shooter_id, avg(shoot_score.percentage) AS avg_1
FROM user_coaches JOIN "user" ON "user".id = user_coaches.user_id JOIN shoot_score ON shoot_score.shooter_id = "user".shooter_id JOIN shoot_event ON shoot_event.id = sho…
#31 [20:54:07.946]
194.9ms
user_coaches
SELECT user_coaches.coach_id AS user_coaches_coach_id, "user".shooter_id AS user_shooter_id, avg(shoot_score.percentage) AS avg_1
FROM user_coaches JOIN "user" ON "user".id = user_coaches.user_id JOIN shoot_score ON shoot_score.shooter_id = "user".shooter_id JOIN shoot_event ON shoot_event.id = sho…
#32 [20:54:07.948]
1.5ms
user
SELECT "user".id AS user_id, "user".username AS user_username, "user".email AS user_email, "user".password AS user_password, "user".verification_code AS user_verification_code, "user".verification_expiry AS user_verification_expiry, "user".verification_attempts AS user_verification_attempts, "user".…
#33 [20:54:07.951]
1.4ms
coach
SELECT coach.cpsa_number AS coach_cpsa_number, coach.id AS coach_id, coach.name AS coach_name, coach.active AS coach_active, coach.created_at AS coach_created_at, coach.photo_url AS coach_photo_url, coach.bio AS coach_bio, coach.specialties AS coach_specialties, coach.qualifications AS coach_qualifi…
#34 [20:54:07.953]
1.2ms
shooter
SELECT shooter.id AS shooter_id, shooter.cpsa_number AS shooter_cpsa_number, shooter.name AS shooter_name, shooter.category AS shooter_category, shooter.cpsa_url AS shooter_cpsa_url, shooter.cpsa_total_shoots AS shooter_cpsa_total_shoots, shooter.cpsa_total_shoots_checked_at AS shooter_cpsa_total_sh…
#35 [20:54:07.954]
1.3ms
user
SELECT "user".id AS user_id, "user".username AS user_username, "user".email AS user_email, "user".password AS user_password, "user".verification_code AS user_verification_code, "user".verification_expiry AS user_verification_expiry, "user".verification_attempts AS user_verification_attempts, "user".…
#36 [20:54:07.957]
1.8ms
user
SELECT "user".id AS user_id, "user".username AS user_username, "user".email AS user_email, "user".password AS user_password, "user".verification_code AS user_verification_code, "user".verification_expiry AS user_verification_expiry, "user".verification_attempts AS user_verification_attempts, "user".…
#37 [20:54:07.959]
1.3ms
coach
SELECT coach.cpsa_number AS coach_cpsa_number, coach.id AS coach_id, coach.name AS coach_name, coach.active AS coach_active, coach.created_at AS coach_created_at, coach.photo_url AS coach_photo_url, coach.bio AS coach_bio, coach.specialties AS coach_specialties, coach.qualifications AS coach_qualifi…
#38 [20:54:07.961]
1.2ms
user
SELECT "user".id AS user_id, "user".username AS user_username, "user".email AS user_email, "user".password AS user_password, "user".verification_code AS user_verification_code, "user".verification_expiry AS user_verification_expiry, "user".verification_attempts AS user_verification_attempts, "user".…
#39 [20:54:07.963]
1.2ms
user
SELECT "user".id AS user_id, "user".username AS user_username, "user".email AS user_email, "user".password AS user_password, "user".verification_code AS user_verification_code, "user".verification_expiry AS user_verification_expiry, "user".verification_attempts AS user_verification_attempts, "user".…
#40 [20:54:07.965]
1.2ms
user
SELECT "user".id AS user_id, "user".username AS user_username, "user".email AS user_email, "user".password AS user_password, "user".verification_code AS user_verification_code, "user".verification_expiry AS user_verification_expiry, "user".verification_attempts AS user_verification_attempts, "user".…
#41 [20:54:07.967]
1.7ms
user
SELECT "user".id AS user_id, "user".username AS user_username, "user".email AS user_email, "user".password AS user_password, "user".verification_code AS user_verification_code, "user".verification_expiry AS user_verification_expiry, "user".verification_attempts AS user_verification_attempts, "user".…
#42 [20:54:07.969]
1.2ms
shooter
SELECT shooter.id AS shooter_id, shooter.cpsa_number AS shooter_cpsa_number, shooter.name AS shooter_name, shooter.category AS shooter_category, shooter.cpsa_url AS shooter_cpsa_url, shooter.cpsa_total_shoots AS shooter_cpsa_total_shoots, shooter.cpsa_total_shoots_checked_at AS shooter_cpsa_total_sh…
#43 [20:54:07.971]
1.6ms
user
SELECT "user".id AS user_id, "user".username AS user_username, "user".email AS user_email, "user".password AS user_password, "user".verification_code AS user_verification_code, "user".verification_expiry AS user_verification_expiry, "user".verification_attempts AS user_verification_attempts, "user".…
#44 [20:54:07.973]
1.2ms
shooter
SELECT shooter.id AS shooter_id, shooter.cpsa_number AS shooter_cpsa_number, shooter.name AS shooter_name, shooter.category AS shooter_category, shooter.cpsa_url AS shooter_cpsa_url, shooter.cpsa_total_shoots AS shooter_cpsa_total_shoots, shooter.cpsa_total_shoots_checked_at AS shooter_cpsa_total_sh…
#45 [20:54:07.975]
1.2ms
user
SELECT "user".id AS user_id, "user".username AS user_username, "user".email AS user_email, "user".password AS user_password, "user".verification_code AS user_verification_code, "user".verification_expiry AS user_verification_expiry, "user".verification_attempts AS user_verification_attempts, "user".…
#46 [20:54:07.977]
1.2ms
shooter
SELECT shooter.id AS shooter_id, shooter.cpsa_number AS shooter_cpsa_number, shooter.name AS shooter_name, shooter.category AS shooter_category, shooter.cpsa_url AS shooter_cpsa_url, shooter.cpsa_total_shoots AS shooter_cpsa_total_shoots, shooter.cpsa_total_shoots_checked_at AS shooter_cpsa_total_sh…
#47 [20:54:07.978]
1.2ms
user
SELECT "user".id AS user_id, "user".username AS user_username, "user".email AS user_email, "user".password AS user_password, "user".verification_code AS user_verification_code, "user".verification_expiry AS user_verification_expiry, "user".verification_attempts AS user_verification_attempts, "user".…
#48 [20:54:07.980]
1.2ms
user
SELECT "user".id AS user_id, "user".username AS user_username, "user".email AS user_email, "user".password AS user_password, "user".verification_code AS user_verification_code, "user".verification_expiry AS user_verification_expiry, "user".verification_attempts AS user_verification_attempts, "user".…
#49 [20:54:07.983]
1.5ms
user
SELECT "user".id AS user_id, "user".username AS user_username, "user".email AS user_email, "user".password AS user_password, "user".verification_code AS user_verification_code, "user".verification_expiry AS user_verification_expiry, "user".verification_attempts AS user_verification_attempts, "user".…
#50 [20:54:07.985]
1.4ms
shooter
SELECT shooter.id AS shooter_id, shooter.cpsa_number AS shooter_cpsa_number, shooter.name AS shooter_name, shooter.category AS shooter_category, shooter.cpsa_url AS shooter_cpsa_url, shooter.cpsa_total_shoots AS shooter_cpsa_total_shoots, shooter.cpsa_total_shoots_checked_at AS shooter_cpsa_total_sh…
#51 [20:54:07.987]
1.5ms
user
SELECT "user".id AS user_id, "user".username AS user_username, "user".email AS user_email, "user".password AS user_password, "user".verification_code AS user_verification_code, "user".verification_expiry AS user_verification_expiry, "user".verification_attempts AS user_verification_attempts, "user".…
#52 [20:54:07.988]
1.2ms
shooter
SELECT shooter.id AS shooter_id, shooter.cpsa_number AS shooter_cpsa_number, shooter.name AS shooter_name, shooter.category AS shooter_category, shooter.cpsa_url AS shooter_cpsa_url, shooter.cpsa_total_shoots AS shooter_cpsa_total_shoots, shooter.cpsa_total_shoots_checked_at AS shooter_cpsa_total_sh…
#53 [20:54:07.990]
1.2ms
user
SELECT "user".id AS user_id, "user".username AS user_username, "user".email AS user_email, "user".password AS user_password, "user".verification_code AS user_verification_code, "user".verification_expiry AS user_verification_expiry, "user".verification_attempts AS user_verification_attempts, "user".…
#54 [20:54:07.992]
1.2ms
user
SELECT "user".id AS user_id, "user".username AS user_username, "user".email AS user_email, "user".password AS user_password, "user".verification_code AS user_verification_code, "user".verification_expiry AS user_verification_expiry, "user".verification_attempts AS user_verification_attempts, "user".…
#55 [20:54:07.995]
2.1ms
user
SELECT "user".id AS user_id, "user".username AS user_username, "user".email AS user_email, "user".password AS user_password, "user".verification_code AS user_verification_code, "user".verification_expiry AS user_verification_expiry, "user".verification_attempts AS user_verification_attempts, "user".…
#56 [20:54:07.997]
1.2ms
site_configuration
SELECT site_configuration.id AS site_configuration_id, site_configuration.key AS site_configuration_key, site_configuration.value AS site_configuration_value
FROM site_configuration
WHERE site_configuration.key LIKE %(key_1)s OR site_configuration.key LIKE %(key_2)s
#57 [20:54:08.001]
3.8ms
site_configuration
SELECT site_configuration.id AS site_configuration_id, site_configuration.key AS site_configuration_key, site_configuration.value AS site_configuration_value
FROM site_configuration
WHERE site_configuration.key IN (%(key_1_1)s, %(key_1_2)s, %(key_1_3)s, %(key_1_4)s)
#58 [20:54:08.043]
41.6ms
admin_menu_item
SELECT DISTINCT admin_menu_item.active_tab AS admin_menu_item_active_tab
FROM admin_menu_item