ClayInsights.co.uk

✨

What's New

v0.7

🎉

Registrations are open! ClayInsights is now in Limited Beta — create a free account to unlock full stats.

Latest Browsing, CPSA Linking & Social Sharing

✓A better Latest feed — compact event cards, result counts, Popular markers, archive browsing and cleaner mobile layouts.
✓Choose the right CPSA profile — registration now shows matching profiles when a number is shared across prefixes.
✓More accurate CPSA matching — exact numeric suffix matching prevents unrelated shooters from appearing.
✓Facebook and Instagram publishing — ClayInsights social cards can now be previewed and shared across both channels.
✓Discipline ranking cards — shooter social cards now include the selected discipline's ClayInsights ranking.

Full Changelog →

⚙ Performance Stats DRAG TO MOVE

0.018s ● FAST

DB 50% · Py 46% · Render 4%

8 queries · avg 1.1ms · max 1.8ms

Render Breakdown

DB Logic (Pre-Render) 0.0088s

Python Logic (Pre-Render) 0.0080s

Full Page Render 0.0007s

QUERY TABLES ▾

⚠ ground_review 4× 0.004s

ground 1× 0.002s

event_review 1× 0.001s

site_configuration 1× 0.001s

admin_menu_item 1× 0.001s

⚠ = queried 3+ times (cache candidate)

SQL QUERIES (8) — click to expand

#1 [00:36:56.705] 1.8ms

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 [00:36:56.707] 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

#3 [00:36:56.709] 1.0ms

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_…

#4 [00:36:56.710] 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…

#5 [00:36:56.711] 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…

#6 [00:36:56.714] 1.5ms

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…

#7 [00:36:56.715] 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)

#8 [00:36:56.717] 0.9ms

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

Ayre Clay Target Club

Analyzing Data...

Refresh Complete

Already Up to Date?

Analyzing Data...

Refresh Complete

Already Up to Date?