#1 [19:53:49.506]
6.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…
#2 [19:53:49.516]
9.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…
#3 [19:53:49.521]
3.9ms
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 [19:53:49.523]
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".…
#5 [19:53:49.525]
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…
#6 [19:53:49.542]
16.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…
#7 [19:53:49.544]
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".…
#8 [19:53:49.559]
14.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…
#9 [19:53:49.565]
4.9ms
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 [19:53:49.567]
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".…
#11 [19:53:49.569]
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…
#12 [19:53:49.656]
86.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…
#13 [19:53:49.659]
2.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 [19:53:49.661]
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".…
#15 [19:53:49.746]
84.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…
#16 [19:53:49.751]
3.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…
#17 [19:53:49.753]
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".…
#18 [19:53:49.765]
11.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 [19:53:49.842]
76.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…
#20 [19:53:49.845]
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".…
#21 [19:53:49.859]
13.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…
#22 [19:53:49.864]
4.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…
#23 [19:53:49.865]
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".…
#24 [19:53:49.868]
2.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…
#25 [19:53:49.871]
2.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".…
#26 [19:53:49.952]
79.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…
#27 [19:53:50.242]
289.2ms
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 [19:53:50.345]
101.1ms
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 [19:53:50.351]
4.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 [19:53:50.550]
197.7ms
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 [19:53:50.764]
212.6ms
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 [19:53:50.766]
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 [19:53:50.769]
1.8ms
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 [19:53:50.776]
6.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 [19:53:50.778]
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".…
#36 [19:53:50.783]
4.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".…
#37 [19:53:50.788]
4.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…
#38 [19:53:50.790]
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".…
#39 [19:53:50.792]
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 [19:53:50.797]
4.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".…
#41 [19:53:50.799]
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".…
#42 [19:53:50.801]
1.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…
#43 [19:53:50.803]
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".…
#44 [19:53:50.806]
2.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…
#45 [19:53:50.807]
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".…
#46 [19:53:50.809]
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 [19:53:50.842]
32.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".…
#48 [19:53:50.844]
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".…
#49 [19:53:50.846]
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".…
#50 [19:53:50.847]
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…
#51 [19:53:50.849]
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".…
#52 [19:53:50.851]
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 [19:53:50.852]
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 [19:53:50.855]
1.9ms
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 [19:53:50.857]
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".…
#56 [19:53:50.861]
3.3ms
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 [19:53:50.863]
1.3ms
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 [19:53:50.864]
1.2ms
admin_menu_item
SELECT DISTINCT admin_menu_item.active_tab AS admin_menu_item_active_tab
FROM admin_menu_item