#1 [00:23:23.046]
53.8ms
shoot_event
SELECT EXTRACT(year FROM shoot_event.last_updated) AS y, EXTRACT(month FROM shoot_event.last_updated) AS m, count(*) AS c
FROM shoot_event
WHERE shoot_event.admin_hidden IS false AND shoot_event.last_updated IS NOT NULL GROUP BY EXTRACT(year FROM shoot_event.last_updated), EXTRACT(month FROM shoot…
#2 [00:23:23.050]
3.4ms
ground
SELECT EXTRACT(year FROM ground.created_at) AS y, EXTRACT(month FROM ground.created_at) AS m, count(*) AS c
FROM ground
WHERE ground.created_at IS NOT NULL GROUP BY EXTRACT(year FROM ground.created_at), EXTRACT(month FROM ground.created_at)
#3 [00:23:23.052]
1.4ms
ground_review
SELECT EXTRACT(year FROM ground_review.created_at) AS y, EXTRACT(month FROM ground_review.created_at) AS m, count(*) AS c
FROM ground_review
WHERE ground_review.created_at IS NOT NULL GROUP BY EXTRACT(year FROM ground_review.created_at), EXTRACT(month FROM ground_review.created_at)
#4 [00:23:23.054]
1.2ms
event_review
SELECT EXTRACT(year FROM event_review.created_at) AS y, EXTRACT(month FROM event_review.created_at) AS m, count(*) AS c
FROM event_review
WHERE event_review.created_at IS NOT NULL GROUP BY EXTRACT(year FROM event_review.created_at), EXTRACT(month FROM event_review.created_at)
#5 [00:23:23.057]
1.4ms
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…
#6 [00:23:23.152]
94.1ms
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 [00:23:23.252]
77.0ms
event_score_stat
SELECT event_score_stat.event_id AS event_score_stat_event_id, event_score_stat.avg_percentage AS event_score_stat_avg_percentage, event_score_stat.score_count AS event_score_stat_score_count
FROM event_score_stat
WHERE event_score_stat.event_id IN (%(event_id_1_1)s, %(event_id_1_2)s, %(event_id_1…
#8 [00:23:24.851]
1586.7ms
shoot_event
SELECT shoot_event.id AS event_id, shoot_event.ground AS ground, shoot_event.discipline AS discipline, shoot_event.date AS event_date, event_score_stat.percentage_sum AS score_sum, event_score_stat.percentage_count AS score_count
FROM shoot_event JOIN event_score_stat ON event_score_stat.event_id =…
#9 [00:23:25.186]
49.9ms
analytics_page_view
SELECT analytics_page_view.path AS analytics_page_view_path, analytics_page_view.visitor_id AS analytics_page_view_visitor_id, analytics_page_view.started_at AS analytics_page_view_started_at
FROM analytics_page_view
WHERE analytics_page_view.started_at >= %(started_at_1)s AND analytics_page_view.…
#10 [00:23:25.223]
1.9ms
ground_review
SELECT ground_review.id AS ground_review_id, ground_review.ground_id AS ground_review_ground_id, ground_review.rating AS ground_review_rating, ground_review.review_text AS ground_review_review_text, ground_review.reviewer_name AS ground_review_reviewer_name, ground_review.reviewer_hash AS ground_rev…
#11 [00:23:25.243]
18.3ms
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…
#12 [00:23:25.247]
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 LIKE %(key_1)s OR site_configuration.key LIKE %(key_2)s
#13 [00:23:25.342]
91.5ms
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 [00:23:25.345]
1.6ms
admin_menu_item
SELECT DISTINCT admin_menu_item.active_tab AS admin_menu_item_active_tab
FROM admin_menu_item