#1 [22:53:17.094]
3.7ms
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 [22:53:17.097]
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".…
#3 [22:53:17.099]
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…
#4 [22:53:17.143]
43.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…
#5 [22:53:17.146]
2.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…
#6 [22:53:17.148]
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…
#7 [22:53:17.151]
1.6ms
shoot_score
SELECT avg(shoot_score.percentage) AS avg_1, count(shoot_score.id) AS count_1
FROM shoot_score JOIN shoot_event ON shoot_event.id = shoot_score.event_id
WHERE shoot_event.discipline IN (%(discipline_1_1)s, %(discipline_1_2)s) AND shoot_event.date >= %(date_1)s AND shoot_event.date <= %(date_2)s AN…
#8 [22:53:17.154]
2.0ms
shoot_event
SELECT DISTINCT shoot_event.discipline AS shoot_event_discipline
FROM shoot_event JOIN shoot_score ON shoot_score.event_id = shoot_event.id
WHERE shoot_score.shooter_id IN (%(shooter_id_1_1)s, %(shooter_id_1_2)s, %(shooter_id_1_3)s) AND shoot_event.discipline IS NOT NULL AND shoot_event.date >= %(…
#9 [22:53:17.157]
2.1ms
shoot_score
SELECT avg(shoot_score.percentage) AS avg_1, count(shoot_score.id) AS count_1
FROM shoot_score JOIN shoot_event ON shoot_event.id = shoot_score.event_id
WHERE shoot_score.shooter_id = %(shooter_id_1)s AND shoot_event.date >= %(date_1)s AND shoot_event.date <= %(date_2)s AND shoot_event.admin_hidde…
#10 [22:53:17.160]
1.9ms
shoot_score
SELECT avg(shoot_score.percentage) AS avg_1, count(shoot_score.id) AS count_1
FROM shoot_score JOIN shoot_event ON shoot_event.id = shoot_score.event_id
WHERE shoot_score.shooter_id = %(shooter_id_1)s AND shoot_event.date >= %(date_1)s AND shoot_event.date <= %(date_2)s AND shoot_event.admin_hidde…
#11 [22:53:17.162]
1.8ms
shoot_event
SELECT shoot_event.ground AS shoot_event_ground, shoot_event.date AS shoot_event_date, count(shoot_score.id) AS count_1
FROM shoot_event JOIN shoot_score ON shoot_score.event_id = shoot_event.id
WHERE shoot_score.shooter_id = %(shooter_id_1)s AND shoot_event.ground IS NOT NULL AND shoot_event.admi…
#12 [22:53:17.165]
1.9ms
shoot_score
SELECT avg(shoot_score.percentage) AS avg_1, count(shoot_score.id) AS count_1
FROM shoot_score JOIN shoot_event ON shoot_event.id = shoot_score.event_id
WHERE shoot_score.shooter_id = %(shooter_id_1)s AND shoot_event.date >= %(date_1)s AND shoot_event.date <= %(date_2)s AND shoot_event.admin_hidde…
#13 [22:53:17.167]
1.8ms
shoot_score
SELECT avg(shoot_score.percentage) AS avg_1, count(shoot_score.id) AS count_1
FROM shoot_score JOIN shoot_event ON shoot_event.id = shoot_score.event_id
WHERE shoot_score.shooter_id = %(shooter_id_1)s AND shoot_event.date >= %(date_1)s AND shoot_event.date <= %(date_2)s AND shoot_event.admin_hidde…
#14 [22:53:17.170]
2.4ms
shoot_event
SELECT shoot_event.ground AS shoot_event_ground, shoot_event.date AS shoot_event_date, count(shoot_score.id) AS count_1
FROM shoot_event JOIN shoot_score ON shoot_score.event_id = shoot_event.id
WHERE shoot_score.shooter_id = %(shooter_id_1)s AND shoot_event.ground IS NOT NULL AND shoot_event.admi…
#15 [22:53:17.173]
2.1ms
shoot_score
SELECT avg(shoot_score.percentage) AS avg_1, count(shoot_score.id) AS count_1
FROM shoot_score JOIN shoot_event ON shoot_event.id = shoot_score.event_id
WHERE shoot_score.shooter_id = %(shooter_id_1)s AND shoot_event.date >= %(date_1)s AND shoot_event.date <= %(date_2)s AND shoot_event.admin_hidde…
#16 [22:53:17.176]
2.0ms
shoot_score
SELECT avg(shoot_score.percentage) AS avg_1, count(shoot_score.id) AS count_1
FROM shoot_score JOIN shoot_event ON shoot_event.id = shoot_score.event_id
WHERE shoot_score.shooter_id = %(shooter_id_1)s AND shoot_event.date >= %(date_1)s AND shoot_event.date <= %(date_2)s AND shoot_event.admin_hidde…
#17 [22:53:17.243]
66.1ms
shoot_event
SELECT shoot_event.ground AS shoot_event_ground, shoot_event.date AS shoot_event_date, count(shoot_score.id) AS count_1
FROM shoot_event JOIN shoot_score ON shoot_score.event_id = shoot_event.id
WHERE shoot_score.shooter_id = %(shooter_id_1)s AND shoot_event.ground IS NOT NULL AND shoot_event.admi…
#18 [22:53:17.246]
1.6ms
ground
SELECT ground.id AS ground_id, ground.name AS ground_name, ground.url AS ground_url, ground.postcode AS ground_postcode, ground.what3words AS ground_what3words, ground.email AS ground_email, ground.website AS ground_website, ground.num_events_cpsa AS ground_num_events_cpsa, ground.num_events_cpsa_la…
#19 [22:53:17.248]
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 LIKE %(key_1)s OR site_configuration.key LIKE %(key_2)s
#20 [22:53:17.250]
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 IN (%(key_1_1)s, %(key_1_2)s, %(key_1_3)s, %(key_1_4)s)
#21 [22:53:17.252]
1.7ms
admin_menu_item
SELECT DISTINCT admin_menu_item.active_tab AS admin_menu_item_active_tab
FROM admin_menu_item