#1 [20:21:16.861]
1.9ms
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…
#2 [20:21:16.864]
1.3ms
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 [20:21:16.868]
2.4ms
shoot_event
SELECT shoot_event.discipline AS shoot_event_discipline, count(shoot_score.id) AS count_1, sum(shoot_score.hits) AS sum_1, sum(shoot_score.targets) AS sum_2, avg(shoot_score.percentage) AS avg_1
FROM shoot_event JOIN shoot_score ON shoot_score.event_id = shoot_event.id
WHERE shoot_event.ground = %…
#4 [20:21:16.872]
2.9ms
shoot_event
SELECT EXTRACT(year FROM shoot_event.date) AS yr, EXTRACT(month FROM shoot_event.date) AS mo, shoot_event.discipline AS shoot_event_discipline, avg(shoot_score.percentage) AS avg_1
FROM shoot_event JOIN shoot_score ON shoot_score.event_id = shoot_event.id
WHERE shoot_event.ground = %(ground_1)s AN…
#5 [20:21:16.875]
2.6ms
shoot_score
SELECT shoot_event.discipline AS shoot_event_discipline, trim(replace(shoot_score.shooter_class, %(replace_1)s, %(replace_2)s)) AS trim_1, count(shoot_score.id) AS count_1
FROM shoot_score JOIN shoot_event ON shoot_score.event_id = shoot_event.id
WHERE shoot_event.ground = %(ground_1)s AND shoot_e…
#6 [20:21:18.922]
2045.9ms
shoot_score
SELECT trim(replace(shoot_score.shooter_class, %(replace_1)s, %(replace_2)s)) AS trim_1, count(shoot_score.id) AS count_1
FROM shoot_score JOIN shoot_event ON shoot_score.event_id = shoot_event.id
WHERE shoot_event.date <= %(date_1)s AND shoot_event.admin_hidden != true AND shoot_score.shooter_cla…
#7 [20:21:18.925]
1.5ms
shoot_event
SELECT EXTRACT(year FROM shoot_event.date) AS yr, EXTRACT(month FROM shoot_event.date) AS mo, shoot_event.discipline AS shoot_event_discipline, count(shoot_event.id) AS count_1
FROM shoot_event
WHERE shoot_event.ground = %(ground_1)s AND shoot_event.date <= %(date_1)s AND shoot_event.admin_hidden …
#8 [20:21:18.927]
1.1ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#9 [20:21:18.929]
1.1ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#10 [20:21:18.931]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#11 [20:21:18.932]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#12 [20:21:18.934]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#13 [20:21:18.936]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#14 [20:21:18.937]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#15 [20:21:18.939]
1.1ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#16 [20:21:18.941]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#17 [20:21:18.942]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#18 [20:21:18.944]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#19 [20:21:18.946]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#20 [20:21:18.947]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#21 [20:21:18.948]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#22 [20:21:18.950]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#23 [20:21:18.951]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#24 [20:21:18.953]
1.1ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#25 [20:21:18.954]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#26 [20:21:18.956]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#27 [20:21:18.957]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#28 [20:21:18.958]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#29 [20:21:18.960]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#30 [20:21:18.961]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#31 [20:21:18.963]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#32 [20:21:19.021]
57.4ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#33 [20:21:19.023]
1.1ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#34 [20:21:19.025]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#35 [20:21:19.026]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#36 [20:21:19.028]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#37 [20:21:19.029]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#38 [20:21:19.041]
10.8ms
shoot_score
SELECT shoot_score.event_id AS shoot_score_event_id, shoot_score.percentage AS shoot_score_percentage, shooter.name AS shooter_name
FROM shoot_score JOIN shooter ON shoot_score.shooter_id = shooter.id JOIN (SELECT shoot_score.event_id AS event_id, max(shoot_score.percentage) AS max_pct
FROM shoot_…
#39 [20:21:19.044]
2.1ms
shoot_score
SELECT shoot_score.event_id AS shoot_score_event_id, avg(shoot_score.percentage) AS avg_1, count(shoot_score.id) AS count_1, min(shoot_score.percentage) AS min_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…
#40 [20:21:19.048]
2.9ms
shoot_score
SELECT shoot_score.event_id AS shoot_score_event_id, trim(replace(shoot_score.shooter_class, %(replace_1)s, %(replace_2)s)) AS cls, avg(shoot_score.percentage) AS avg_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_i…
#41 [20:21:19.050]
1.1ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#42 [20:21:19.052]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#43 [20:21:19.053]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#44 [20:21:19.055]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#45 [20:21:19.056]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#46 [20:21:19.057]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#47 [20:21:19.121]
63.4ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#48 [20:21:19.124]
1.1ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#49 [20:21:19.126]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#50 [20:21:19.127]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#51 [20:21:19.129]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#52 [20:21:19.131]
1.1ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#53 [20:21:19.132]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#54 [20:21:19.134]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#55 [20:21:19.136]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#56 [20:21:19.137]
1.1ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#57 [20:21:19.139]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#58 [20:21:19.141]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#59 [20:21:19.142]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#60 [20:21:19.144]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#61 [20:21:19.146]
1.1ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#62 [20:21:19.147]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#63 [20:21:19.149]
1.1ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#64 [20:21:19.150]
0.9ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#65 [20:21:19.152]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#66 [20:21:19.153]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#67 [20:21:19.155]
1.2ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#68 [20:21:19.156]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#69 [20:21:19.158]
1.1ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#70 [20:21:19.160]
1.0ms
shoot_score
SELECT count(*) AS count_1
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…
#71 [20:21:19.163]
2.4ms
shoot_score
SELECT count(distinct(shoot_score.shooter_id)) AS count_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.date <= %(date_1)s AND shoot_event.admin_hidden != true
#72 [20:21:19.222]
59.1ms
shoot_score
SELECT shoot_score.percentage AS shoot_score_percentage, shooter.name AS shooter_name, shoot_event.discipline AS shoot_event_discipline, shoot_event.date AS shoot_event_date
FROM shoot_score JOIN shooter ON shoot_score.shooter_id = shooter.id JOIN shoot_event ON shoot_score.event_id = shoot_event.i…
#73 [20:21:19.229]
5.0ms
shooter
SELECT shooter.name AS shooter_name, count(shoot_score.id) AS count_1, avg(shoot_score.percentage) AS avg_1, max(shoot_score.percentage) AS max_1
FROM shooter JOIN shoot_score ON shoot_score.shooter_id = shooter.id JOIN shoot_event ON shoot_score.event_id = shoot_event.id
WHERE shoot_event.ground …
#74 [20:21:19.235]
3.5ms
shoot_event
SELECT shoot_event.discipline AS shoot_event_discipline, shoot_score.percentage AS shoot_score_percentage, shooter.name AS shooter_name, shoot_event.date AS shoot_event_date
FROM shoot_event JOIN shoot_score ON shoot_score.event_id = shoot_event.id JOIN shooter ON shoot_score.shooter_id = shooter.i…
#75 [20:21:19.236]
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 LIKE %(key_1)s OR site_configuration.key LIKE %(key_2)s
#76 [20:21:19.321]
83.8ms
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 = %(key_1)s
LIMIT %(param_1)s
#77 [20:21:19.323]
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 = %(key_1)s
LIMIT %(param_1)s
#78 [20:21:19.325]
1.1ms
ground_review
SELECT avg(ground_review.rating) AS avg_1, count(ground_review.id) AS count_1
FROM ground_review
WHERE ground_review.ground_id = %(ground_id_1)s
#79 [20:21:19.327]
1.1ms
ground_review
SELECT count(*) AS count_1
FROM (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_…
#80 [20:21:19.328]
1.1ms
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…
#81 [20:21:19.330]
0.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…
#82 [20:21:19.331]
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)
#83 [20:21:19.332]
0.9ms
admin_menu_item
SELECT DISTINCT admin_menu_item.active_tab AS admin_menu_item_active_tab
FROM admin_menu_item