No photo yet

Cheryl Hall

No bio yet — add one from Edit profile.

Coached shooters

116

Student activity

shoots logged · last 12 months

Grounds visited

Shooters coached

ClayInsights members tagged with Cheryl Hall, average shown where linked

All Disciplines DTL ESP STR SSP

Shooter	All disciplines avg (12mo)	12mo change
David •••••	63.2%	-3.5%
Martyn •••••	64.6%	+6.8%
Roy •••••	75.5%	+2.0%

Get in touch

No contact details added yet.

Qualifications

No qualifications listed yet.

Grounds shot at

Last 12 months All Time

Grounds most visited by coached shooters

Normanton Shooting Ground 23 shoots

Kibworth Gun Club 16 shoots

Ian Coley Shooting School 13 shoots

Barby Sporting Club Ltd 10 shoots

Garlands Shooting Ground 9 shoots

⚙ Performance Stats DRAG TO MOVE

0.212s ● FAST

DB 87% · Py 12% · Render 1%

22 queries · avg 8.4ms · max 67.5ms

Render Breakdown

DB Logic (Pre-Render) 0.1844s

Python Logic (Pre-Render) 0.0266s

Full Page Render 0.0015s

QUERY TABLES ▾

⚠ shoot_score 7× 0.140s

⚠ shooter 5× 0.017s

⚠ shoot_event 4× 0.012s

site_configuration 2× 0.008s

coach 1× 0.002s

user 1× 0.002s

ground 1× 0.002s

admin_menu_item 1× 0.001s

⚠ = queried 3+ times (cache candidate)

SQL QUERIES (22) — click to expand

#1 [22:01:26.362] 2.5ms

coach

SELECT coach.cpsa_number AS coach_cpsa_number, coach.id AS coach_id, coach.name AS coach_name, coach.active AS coach_active, coach.created_at AS coach_created_at, coach.photo_url AS coach_photo_url, coach.bio AS coach_bio, coach.specialties AS coach_specialties, coach.qualifications AS coach_qualifi…

#2 [22:01:26.373] 9.1ms

shooter

SELECT shooter.id AS shooter_id, shooter.cpsa_number AS shooter_cpsa_number, shooter.name AS shooter_name, shooter.category AS shooter_category, shooter.cpsa_url AS shooter_cpsa_url, shooter.cpsa_total_shoots AS shooter_cpsa_total_shoots, shooter.cpsa_total_shoots_checked_at AS shooter_cpsa_total_sh…

#3 [22:01:26.376] 2.2ms

user

SELECT "user".id AS user_id, "user".username AS user_username, "user".email AS user_email, "user".password AS user_password, "user".verification_code AS user_verification_code, "user".verification_expiry AS user_verification_expiry, "user".verification_attempts AS user_verification_attempts, "user".…

#4 [22:01:26.379] 3.1ms

shooter

SELECT shooter.id AS shooter_id, shooter.cpsa_number AS shooter_cpsa_number, shooter.name AS shooter_name, shooter.category AS shooter_category, shooter.cpsa_url AS shooter_cpsa_url, shooter.cpsa_total_shoots AS shooter_cpsa_total_shoots, shooter.cpsa_total_shoots_checked_at AS shooter_cpsa_total_sh…

#5 [22:01:26.381] 1.2ms

shooter

SELECT shooter.id AS shooter_id, shooter.cpsa_number AS shooter_cpsa_number, shooter.name AS shooter_name, shooter.category AS shooter_category, shooter.cpsa_url AS shooter_cpsa_url, shooter.cpsa_total_shoots AS shooter_cpsa_total_shoots, shooter.cpsa_total_shoots_checked_at AS shooter_cpsa_total_sh…

#6 [22:01:26.383] 1.2ms

shooter

SELECT shooter.id AS shooter_id, shooter.cpsa_number AS shooter_cpsa_number, shooter.name AS shooter_name, shooter.category AS shooter_category, shooter.cpsa_url AS shooter_cpsa_url, shooter.cpsa_total_shoots AS shooter_cpsa_total_shoots, shooter.cpsa_total_shoots_checked_at AS shooter_cpsa_total_sh…

#7 [22:01:26.386] 2.5ms

shooter

SELECT shooter.id AS shooter_id, shooter.cpsa_number AS shooter_cpsa_number, shooter.name AS shooter_name, shooter.category AS shooter_category, shooter.cpsa_url AS shooter_cpsa_url, shooter.cpsa_total_shoots AS shooter_cpsa_total_shoots, shooter.cpsa_total_shoots_checked_at AS shooter_cpsa_total_sh…

#8 [22:01:26.444] 56.7ms

shoot_score

SELECT avg(shoot_score.percentage) AS avg_1, count(shoot_score.id) AS count_1 
FROM shoot_score JOIN shoot_event ON shoot_event.id = shoot_score.event_id 
WHERE shoot_event.discipline IN (%(discipline_1_1)s, %(discipline_1_2)s) AND shoot_event.date >= %(date_1)s AND shoot_event.date <= %(date_2)s AN…

#9 [22:01:26.451] 5.1ms

shoot_event

SELECT DISTINCT shoot_event.discipline AS shoot_event_discipline 
FROM shoot_event JOIN shoot_score ON shoot_score.event_id = shoot_event.id 
WHERE shoot_score.shooter_id IN (%(shooter_id_1_1)s, %(shooter_id_1_2)s, %(shooter_id_1_3)s) AND shoot_event.discipline IS NOT NULL AND shoot_event.date >= %(…

#10 [22:01:26.454] 2.2ms

shoot_score

SELECT avg(shoot_score.percentage) AS avg_1, count(shoot_score.id) AS count_1 
FROM shoot_score JOIN shoot_event ON shoot_event.id = shoot_score.event_id 
WHERE shoot_score.shooter_id = %(shooter_id_1)s AND shoot_event.date >= %(date_1)s AND shoot_event.date <= %(date_2)s AND shoot_event.admin_hidde…

#11 [22:01:26.457] 2.3ms

shoot_score

SELECT avg(shoot_score.percentage) AS avg_1, count(shoot_score.id) AS count_1 
FROM shoot_score JOIN shoot_event ON shoot_event.id = shoot_score.event_id 
WHERE shoot_score.shooter_id = %(shooter_id_1)s AND shoot_event.date >= %(date_1)s AND shoot_event.date <= %(date_2)s AND shoot_event.admin_hidde…

#12 [22:01:26.460] 2.1ms

shoot_event

SELECT shoot_event.ground AS shoot_event_ground, shoot_event.date AS shoot_event_date, count(shoot_score.id) AS count_1 
FROM shoot_event JOIN shoot_score ON shoot_score.event_id = shoot_event.id 
WHERE shoot_score.shooter_id = %(shooter_id_1)s AND shoot_event.ground IS NOT NULL AND shoot_event.admi…

#13 [22:01:26.468] 7.1ms

shoot_score

SELECT avg(shoot_score.percentage) AS avg_1, count(shoot_score.id) AS count_1 
FROM shoot_score JOIN shoot_event ON shoot_event.id = shoot_score.event_id 
WHERE shoot_score.shooter_id = %(shooter_id_1)s AND shoot_event.date >= %(date_1)s AND shoot_event.date <= %(date_2)s AND shoot_event.admin_hidde…

#14 [22:01:26.472] 2.0ms

shoot_score

SELECT avg(shoot_score.percentage) AS avg_1, count(shoot_score.id) AS count_1 
FROM shoot_score JOIN shoot_event ON shoot_event.id = shoot_score.event_id 
WHERE shoot_score.shooter_id = %(shooter_id_1)s AND shoot_event.date >= %(date_1)s AND shoot_event.date <= %(date_2)s AND shoot_event.admin_hidde…

#15 [22:01:26.475] 2.0ms

shoot_event

SELECT shoot_event.ground AS shoot_event_ground, shoot_event.date AS shoot_event_date, count(shoot_score.id) AS count_1 
FROM shoot_event JOIN shoot_score ON shoot_score.event_id = shoot_event.id 
WHERE shoot_score.shooter_id = %(shooter_id_1)s AND shoot_event.ground IS NOT NULL AND shoot_event.admi…

#16 [22:01:26.543] 67.5ms

shoot_score

SELECT avg(shoot_score.percentage) AS avg_1, count(shoot_score.id) AS count_1 
FROM shoot_score JOIN shoot_event ON shoot_event.id = shoot_score.event_id 
WHERE shoot_score.shooter_id = %(shooter_id_1)s AND shoot_event.date >= %(date_1)s AND shoot_event.date <= %(date_2)s AND shoot_event.admin_hidde…

#17 [22:01:26.547] 2.5ms

shoot_score

SELECT avg(shoot_score.percentage) AS avg_1, count(shoot_score.id) AS count_1 
FROM shoot_score JOIN shoot_event ON shoot_event.id = shoot_score.event_id 
WHERE shoot_score.shooter_id = %(shooter_id_1)s AND shoot_event.date >= %(date_1)s AND shoot_event.date <= %(date_2)s AND shoot_event.admin_hidde…

#18 [22:01:26.551] 2.5ms

shoot_event

SELECT shoot_event.ground AS shoot_event_ground, shoot_event.date AS shoot_event_date, count(shoot_score.id) AS count_1 
FROM shoot_event JOIN shoot_score ON shoot_score.event_id = shoot_event.id 
WHERE shoot_score.shooter_id = %(shooter_id_1)s AND shoot_event.ground IS NOT NULL AND shoot_event.admi…

#19 [22:01:26.554] 1.7ms

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…

#20 [22:01:26.562] 6.3ms

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

#21 [22:01:26.564] 1.3ms

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)

#22 [22:01:26.566] 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

Cheryl Hall

Analyzing Data...

Refresh Complete

Already Up to Date?

Analyzing Data...

Refresh Complete

Already Up to Date?