#1 [19:50:53.643]
192.0ms
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…
#2 [19:50:53.943]
297.4ms
shoot_event
SELECT shoot_event.ground AS shoot_event_ground, shoot_event.discipline AS shoot_event_discipline, count(distinct(shoot_event.id)) AS count_1
FROM shoot_event
WHERE shoot_event.ground IN (%(ground_1_1)s, %(ground_1_2)s, %(ground_1_3)s, %(ground_1_4)s, %(ground_1_5)s, %(ground_1_6)s, %(ground_1_7)s…
#3 [19:50:57.944]
3997.9ms
shoot_event
SELECT shoot_event.ground AS shoot_event_ground, shoot_event.discipline AS shoot_event_discipline, count(shoot_score.id) AS count_1, avg(shoot_score.percentage) AS avg_1, count(distinct(shoot_event.id)) AS count_2
FROM shoot_event JOIN shoot_score ON shoot_score.event_id = shoot_event.id
WHERE sho…
#4 [19:50:58.144]
196.9ms
ground_vote
SELECT ground_vote.ground_id AS ground_vote_ground_id, count(ground_vote.id) AS count_1
FROM ground_vote GROUP BY ground_vote.ground_id
#5 [19:50:58.147]
2.3ms
ground_review
SELECT ground_review.ground_id AS ground_review_ground_id, avg(ground_review.rating) AS avg_1, count(ground_review.id) AS count_1
FROM ground_review GROUP BY ground_review.ground_id
#6 [19:50:58.154]
5.1ms
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
#7 [19:50:58.164]
7.0ms
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)
#8 [19:50:58.166]
2.0ms
admin_menu_item
SELECT DISTINCT admin_menu_item.active_tab AS admin_menu_item_active_tab
FROM admin_menu_item