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

DB 65% · Py 32% · Render 3%

8 queries · avg 2.1ms · max 6.8ms

Render Breakdown

DB Logic (Pre-Render) 0.0168s

Python Logic (Pre-Render) 0.0084s

Full Page Render 0.0008s

QUERY TABLES ▾

⚠ event_review 4× 0.011s

site_configuration 2× 0.002s

shoot_event 1× 0.002s

admin_menu_item 1× 0.001s

⚠ = queried 3+ times (cache candidate)

SQL QUERIES (8) — click to expand

#1 [00:15:16.752] 2.4ms

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 [00:15:16.754] 2.1ms

event_review

SELECT avg(event_review.rating) AS avg_1, count(event_review.id) AS count_1 
FROM event_review 
WHERE event_review.event_id = %(event_id_1)s

#3 [00:15:16.756] 1.1ms

event_review

SELECT count(*) AS count_1 
FROM (SELECT event_review.id AS event_review_id, event_review.event_id AS event_review_event_id, event_review.rating AS event_review_rating, event_review.review_text AS event_review_review_text, event_review.reviewer_name AS event_review_reviewer_name, event_review.review…

#4 [00:15:16.764] 6.8ms

event_review

SELECT event_review.id AS event_review_id, event_review.event_id AS event_review_event_id, event_review.rating AS event_review_rating, event_review.review_text AS event_review_review_text, event_review.reviewer_name AS event_review_reviewer_name, event_review.reviewer_hash AS event_review_reviewer_h…

#5 [00:15:16.766] 1.2ms

event_review

SELECT event_review.id AS event_review_id, event_review.event_id AS event_review_event_id, event_review.rating AS event_review_rating, event_review.review_text AS event_review_review_text, event_review.reviewer_name AS event_review_reviewer_name, event_review.reviewer_hash AS event_review_reviewer_h…

#6 [00:15:16.768] 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

#7 [00:15:16.770] 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 IN (%(key_1_1)s, %(key_1_2)s, %(key_1_3)s, %(key_1_4)s)

#8 [00:15:16.772] 1.0ms

admin_menu_item

SELECT DISTINCT admin_menu_item.active_tab AS admin_menu_item_active_tab 
FROM admin_menu_item

LIVE REQUESTS (0) — click to expand

English Sporting at Hornet Shooting Ground (CF)

Analyzing Data...

Refresh Complete

Already Up to Date?

Analyzing Data...

Refresh Complete

Already Up to Date?