#1 [22:00:18.972]
2.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 [22:00:18.974]
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".…
#3 [22:00:18.976]
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:00:18.978]
1.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:00:18.982]
2.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_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…
#6 [22:00:18.984]
1.5ms
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) AND shoot_event.discipline IS NOT NULL AND shoot_event.date >= %(date_1)s AND shoot_event.date <= %(date_…
#7 [22:00:18.987]
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…
#8 [22:00:18.989]
1.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…
#9 [22:00:18.991]
1.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…
#10 [22:00:18.993]
1.3ms
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…
#11 [22:00:18.996]
1.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 LIKE %(key_1)s OR site_configuration.key LIKE %(key_2)s
#12 [22:00:19.042]
45.9ms
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)
#13 [22:00:19.044]
1.2ms
admin_menu_item
SELECT DISTINCT admin_menu_item.active_tab AS admin_menu_item_active_tab
FROM admin_menu_item