#1 [23:00:01.118]
2.2ms
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 [23:00:01.120]
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".…
#3 [23:00:01.122]
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…
#4 [23:00:01.124]
1.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…
#5 [23:00:01.125]
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…
#6 [23:00:01.142]
16.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…
#7 [23:00:01.146]
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_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 [23:00:01.150]
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 [23:00:01.153]
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…
#10 [23:00:01.156]
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…
#11 [23:00:01.158]
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 [23:00:01.161]
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 [23:00:01.164]
1.7ms
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 [23:00:01.166]
1.5ms
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 [23:00:01.168]
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…
#16 [23:00:01.171]
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_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 [23:00:01.173]
1.5ms
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 [23:00:01.175]
1.4ms
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 [23:00:01.177]
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
#20 [23:00:01.179]
1.4ms
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 [23:00:01.181]
1.2ms
admin_menu_item
SELECT DISTINCT admin_menu_item.active_tab AS admin_menu_item_active_tab
FROM admin_menu_item