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.054s ● FAST

DB 61% · Py 33% · Render 6%

8 queries · avg 4.1ms · max 10.5ms

Render Breakdown

DB Logic (Pre-Render) 0.0328s

Python Logic (Pre-Render) 0.0179s

Full Page Render 0.0032s

QUERY TABLES ▾

⚠ shoot_event 5× 0.027s

site_configuration 2× 0.004s

shoot_score 1× 0.002s

⚠ = queried 3+ times (cache candidate)

SQL QUERIES (8) — click to expand

#1 [14:11:21.236] 3.9ms

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 [14:11:21.241] 3.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 [14:11:21.244] 1.8ms

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 [14:11:21.260] 10.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 [14:11:21.267] 4.6ms

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 [14:11:21.273] 4.6ms

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 [14:11:21.276] 1.4ms

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 [14:11:21.280] 2.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)

Events Activity

Events

Analyzing Data...

Refresh Complete

Already Up to Date?

Analyzing Data...

Refresh Complete

Already Up to Date?