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

DB 82% · Py 16% · Render 1%

8 queries · avg 5.3ms · max 26.0ms

Render Breakdown

DB Logic (Pre-Render) 0.0421s

Python Logic (Pre-Render) 0.0084s

Full Page Render 0.0007s

QUERY TABLES ▾

⚠ ground_review 4× 0.033s

ground 1× 0.003s

event_review 1× 0.002s

site_configuration 1× 0.003s

admin_menu_item 1× 0.001s

⚠ = queried 3+ times (cache candidate)

SQL QUERIES (8) — click to expand

#1 [21:51:02.809] 3.0ms

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 [21:51:02.814] 3.8ms

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 [21:51:02.816] 1.3ms

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 [21:51:02.842] 26.0ms

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 [21:51:02.845] 1.6ms

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 [21:51:02.848] 2.3ms

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 [21:51:02.852] 2.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 [21:51:02.854] 1.3ms

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

Grimsthorpe Estate S.G

Analyzing Data...

Refresh Complete

Already Up to Date?

Analyzing Data...

Refresh Complete

Already Up to Date?