#1 [18:31:59.792]
3.2ms
ground
SELECT ground.id AS ground_id, ground.name AS ground_name, avg(ground_review.rating) AS avg_rating, count(ground_review.id) AS rating_count
FROM ground JOIN ground_review ON ground_review.ground_id = ground.id GROUP BY ground.id, ground.name ORDER BY avg(ground_review.rating) DESC, count(ground_rev…
#2 [18:31:59.795]
1.4ms
shoot_event
SELECT shoot_event.id AS shoot_event_id, shoot_event.name AS shoot_event_name, shoot_event.date AS shoot_event_date, shoot_event.ground AS shoot_event_ground, shoot_event.discipline AS shoot_event_discipline, avg(event_review.rating) AS avg_rating, count(event_review.id) AS rating_count
FROM shoot_…
#3 [18:31:59.797]
1.0ms
ground
SELECT count(*) AS count_1
FROM (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_even…
#4 [18:31:59.801]
3.1ms
shoot_event
SELECT count(*) AS count_1
FROM (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_groun…
#5 [18:31:59.802]
1.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)
#6 [18:31:59.804]
0.9ms
admin_menu_item
SELECT DISTINCT admin_menu_item.active_tab AS admin_menu_item_active_tab
FROM admin_menu_item