#1 [22:53:18.976]
2.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…
#2 [22:53:19.046]
66.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…
#3 [22:53:19.069]
22.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".…
#4 [22:53:19.078]
5.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…
#5 [22:53:19.080]
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…
#6 [22:53:19.082]
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:19.086]
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…
#8 [22:53:19.092]
4.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_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…
#9 [22:53:19.104]
9.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 >= %(…
#10 [22:53:19.108]
2.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_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:19.119]
6.5ms
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…
#12 [22:53:19.143]
22.9ms
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…
#13 [22:53:19.147]
2.3ms
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:19.151]
2.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…
#15 [22:53:19.154]
1.9ms
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…
#16 [22:53:19.158]
3.2ms
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:19.162]
3.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…
#18 [22:53:19.168]
4.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…
#19 [22:53:19.171]
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…
#20 [22:53:19.174]
2.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
#21 [22:53:19.176]
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)
#22 [22:53:19.178]
1.2ms
admin_menu_item
SELECT DISTINCT admin_menu_item.active_tab AS admin_menu_item_active_tab
FROM admin_menu_item