#1 [20:38:07.304]
1.8ms
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_…
#2 [20:38:07.307]
1.7ms
shoot_score
SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, shoot_score.event_id AS shoot_score_event_id, shoot_score.ground_id AS shoot_…
#3 [20:38:07.311]
1.5ms
shoot_score
SELECT avg(shoot_score.percentage) AS avg_1
FROM shoot_score JOIN shoot_event ON shoot_score.event_id = shoot_event.id
WHERE shoot_event.ground = %(ground_1)s AND shoot_event.discipline = %(discipline_1)s AND shoot_event.is_scraped = true AND shoot_event.admin_hidden != true AND shoot_event.id != …
#4 [20:38:07.313]
1.2ms
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_…
#5 [20:38:07.315]
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 LIKE %(key_1)s OR site_configuration.key LIKE %(key_2)s
#6 [20:38:07.316]
0.9ms
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)