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

DB 46% · Py 41% · Render 13%

8 queries · avg 1.5ms · max 2.2ms

Render Breakdown

DB Logic (Pre-Render) 0.0123s

Python Logic (Pre-Render) 0.0111s

Full Page Render 0.0036s

QUERY TABLES ▾

⚠ shoot_event 5× 0.009s

site_configuration 2× 0.002s

shoot_score 1× 0.001s

⚠ = queried 3+ times (cache candidate)

SQL QUERIES (8) — click to expand

#1 [16:44:36.285] 2.2ms

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 [16:44:36.288] 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_…

#3 [16:44:36.291] 1.3ms

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) GROUP BY shoot_score.event_id

#4 [16:44:36.293] 2.1ms

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 [16:44:36.296] 1.3ms

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 [16:44:36.298] 1.5ms

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 [16:44:36.300] 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 LIKE %(key_1)s OR site_configuration.key LIKE %(key_2)s

#8 [16:44:36.302] 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 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?