#1 [22:02:28.283]
3.9ms
shoot_event
SELECT shoot_event.id AS shoot_event_id, shoot_event.cpsa_fixture_id AS shoot_event_cpsa_fixture_id, shoot_event.name AS shoot_event_name, shoot_event.date AS shoot_event_date, shoot_event.discipline AS shoot_event_discipline, shoot_event.ground AS shoot_event_ground, shoot_event.url AS shoot_event_…
#2 [22:02:28.292]
2.4ms
shoot_score
SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.course_breakdown AS shoot_score_course_breakdown, shoot_score.shooter_id …
#3 [22:02:28.298]
4.3ms
shoot_score
SELECT avg(shoot_score.percentage) AS avg_1
FROM shoot_score JOIN shoot_event ON shoot_score.event_id = shoot_event.id
WHERE shoot_event.ground = %(ground_1)s AND shoot_event.discipline = %(discipline_1)s AND shoot_event.is_scraped = true AND shoot_event.admin_hidden != true AND shoot_event.id != …
#4 [22:02:28.303]
3.5ms
shooter
SELECT shooter.name AS shooter_name
FROM shooter JOIN "user" ON "user".shooter_id = shooter.id
WHERE "user".hide_surname IS false
#5 [22:02:28.306]
2.1ms
coach
SELECT coach.name AS coach_name
FROM coach JOIN "user" ON "user".coach_id = coach.id
WHERE "user".hide_surname IS false
#6 [22:02:28.311]
3.0ms
shoot_event
SELECT shoot_event.id AS shoot_event_id, shoot_event.cpsa_fixture_id AS shoot_event_cpsa_fixture_id, shoot_event.name AS shoot_event_name, shoot_event.date AS shoot_event_date, shoot_event.discipline AS shoot_event_discipline, shoot_event.ground AS shoot_event_ground, shoot_event.url AS shoot_event_…
#7 [22:02:28.315]
2.7ms
event_review
SELECT avg(event_review.rating) AS avg_1, count(event_review.id) AS count_1
FROM event_review
WHERE event_review.event_id = %(event_id_1)s
#8 [22:02:28.322]
5.5ms
event_review
SELECT count(*) AS count_1
FROM (SELECT event_review.id AS event_review_id, event_review.event_id AS event_review_event_id, event_review.rating AS event_review_rating, event_review.review_text AS event_review_review_text, event_review.reviewer_name AS event_review_reviewer_name, event_review.review…
#9 [22:02:28.325]
2.9ms
event_review
SELECT event_review.id AS event_review_id, event_review.event_id AS event_review_event_id, event_review.rating AS event_review_rating, event_review.review_text AS event_review_review_text, event_review.reviewer_name AS event_review_reviewer_name, event_review.reviewer_hash AS event_review_reviewer_h…
#10 [22:02:28.328]
2.4ms
event_review
SELECT event_review.id AS event_review_id, event_review.event_id AS event_review_event_id, event_review.rating AS event_review_rating, event_review.review_text AS event_review_review_text, event_review.reviewer_name AS event_review_reviewer_name, event_review.reviewer_hash AS event_review_reviewer_h…
#11 [22:02:28.334]
4.9ms
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…
#12 [22:02:28.337]
2.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 LIKE %(key_1)s OR site_configuration.key LIKE %(key_2)s
#13 [22:02:28.340]
1.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)
#14 [22:02:28.343]
3.1ms
admin_menu_item
SELECT DISTINCT admin_menu_item.active_tab AS admin_menu_item_active_tab
FROM admin_menu_item