#1 [17:30:16.132]
6.0ms
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…
#2 [17:30:16.136]
2.6ms
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_…
#3 [17:30:16.140]
1.7ms
shoot_score
SELECT shoot_score.event_id AS shoot_score_event_id, count(shoot_score.id) AS count_1, avg(shoot_score.percentage) AS avg_1, max(shoot_score.percentage) AS max_1
FROM shoot_score
WHERE shoot_score.event_id IN (%(event_id_1_1)s, %(event_id_1_2)s, %(event_id_1_3)s, %(event_id_1_4)s, %(event_id_1_5)s…
#4 [17:30:16.143]
2.5ms
shoot_event
SELECT DISTINCT shoot_event.discipline AS shoot_event_discipline
FROM shoot_event
WHERE shoot_event.discipline IS NOT NULL ORDER BY shoot_event.discipline
#5 [17:30:16.148]
3.4ms
shoot_event
SELECT to_char(shoot_event.date, %(to_char_1)s) AS ym, count(shoot_event.id) AS cnt
FROM shoot_event
WHERE shoot_event.admin_hidden != true AND shoot_event.date >= %(date_1)s GROUP BY ym
#6 [17:30:16.178]
29.1ms
shoot_event
SELECT to_char(shoot_event.date, %(to_char_1)s) AS ym, shoot_event.discipline AS shoot_event_discipline, count(shoot_event.id) AS cnt
FROM shoot_event
WHERE shoot_event.admin_hidden != true AND shoot_event.date >= %(date_1)s AND shoot_event.discipline IS NOT NULL GROUP BY ym, shoot_event.disciplin…
#7 [17:30:16.182]
1.3ms
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
#8 [17:30:16.184]
1.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 IN (%(key_1_1)s, %(key_1_2)s, %(key_1_3)s, %(key_1_4)s)