#1 [20:07:13.031]
75.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 [20:07:13.129]
95.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 [20:07:16.930]
3798.4ms
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 [20:07:16.935]
1.3ms
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 [20:07:16.936]
1.1ms
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 [20:07:17.021]
83.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
#7 [20:07:17.026]
1.7ms
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 [20:07:17.029]
1.1ms
admin_menu_item
SELECT DISTINCT admin_menu_item.active_tab AS admin_menu_item_active_tab
FROM admin_menu_item