ClayInsights.co.uk

✨

What's New

v0.4

Shooter Profiles, Latest Grounds & Performance

✓Shooter profiles now show a Data Range stat, per-discipline Score Trend lines, and a Discipline × Ground Performance toggle with sortable columns.
✓Recent Results on mobile redesigned as clean cards including Class Average.
✓Latest page redesigned as a chronological timeline of recently added grounds, now accessible without logging in.
✓Grounds Directory and Shooter Directory load significantly faster — pagination, search and sort are now near-instant after first load.

Full Changelog →

⚙ Performance Stats DRAG TO MOVE

0.020s ● FAST

DB 56% · Py 33% · Render 12%

8 queries · avg 1.4ms · max 2.3ms

Render Breakdown

DB Logic (Pre-Render) 0.0112s

Python Logic (Pre-Render) 0.0066s

Full Page Render 0.0023s

QUERY TABLES ▾

⚠ shoot_event 5× 0.008s

site_configuration 2× 0.002s

shoot_score 1× 0.001s

⚠ = queried 3+ times (cache candidate)

SQL QUERIES (8) — click to expand

#1 [18:36:36.820] 2.3ms

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 [18:36:36.822] 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 [18:36:36.824] 1.2ms

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 [18:36:36.826] 1.8ms

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 [18:36:36.828] 1.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 AND shoot_event.discipline = %(discipline_1)s GROUP BY ym

#6 [18:36:36.830] 1.3ms

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 = %(discipline_1)s AND shoot_event.discipline …

#7 [18:36:36.832] 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

#8 [18:36:36.834] 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)

Events Activity

Events

Analyzing Data...

Refresh Complete

Already Up to Date?

Analyzing Data...

Refresh Complete

Already Up to Date?