#1 [19:45:06.451]
2.9ms
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 [19:45:06.454]
2.2ms
shoot_event
SELECT shoot_event.ground AS shoot_event_ground, avg(event_review.rating) AS avg_rating, count(event_review.id) AS rating_count
FROM shoot_event JOIN event_review ON event_review.event_id = shoot_event.id
WHERE shoot_event.admin_hidden != true GROUP BY shoot_event.ground
#3 [19:45:06.457]
1.3ms
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_…
#4 [19:45:06.459]
0.9ms
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…
#5 [19:45:06.522]
62.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…
#6 [19:45:06.524]
1.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 IN (%(key_1_1)s, %(key_1_2)s, %(key_1_3)s, %(key_1_4)s)
#7 [19:45:06.526]
1.1ms
admin_menu_item
SELECT DISTINCT admin_menu_item.active_tab AS admin_menu_item_active_tab
FROM admin_menu_item