No photo yet

Benjamin Husthwaite

CPSA WW3267

No bio yet — add one from Edit profile.

Coached shooters

Student activity

shoots logged · last 12 months

Grounds visited

Shooters coached

ClayInsights members tagged with Benjamin Husthwaite, average shown where linked

All Disciplines AR ALR ABT CSP DTL ESK ESP FSP STR SSP UTR

Shooter	ESP avg (12mo)	12mo change
Lewis •••••	69.6%	+10.8%
Oliver Roberts	68.3%	—
Tomas •••••	76.7%	+3.9%

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

Westfield Shooting Ground 8 shoots

Welsh Clay Target Shooting Association 7 shoots

Nottingham & District Gun Club 6 shoots

Barbury Shooting School 4 shoots

Stalisfield Shoot - JBD Sporting 4 shoots

⚙ Performance Stats DRAG TO MOVE

0.099s ● FAST

DB 80% · Py 18% · Render 1%

21 queries · avg 3.8ms · max 48.4ms

Render Breakdown

DB Logic (Pre-Render) 0.0797s

Python Logic (Pre-Render) 0.0182s

Full Page Render 0.0013s

QUERY TABLES ▾

⚠ shoot_score 7× 0.012s

⚠ shooter 4× 0.005s

⚠ shoot_event 4× 0.007s

site_configuration 2× 0.003s

coach 1× 0.003s

user 1× 0.001s

ground 1× 0.048s

admin_menu_item 1× 0.001s

⚠ = queried 3+ times (cache candidate)

SQL QUERIES (21) — click to expand

#1 [22:00:06.259] 2.7ms

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:00:06.261] 1.5ms

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".…

#3 [22:00:06.263] 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…

#4 [22:00:06.265] 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…

#5 [22:00:06.267] 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:00:06.269] 1.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…

#7 [22:00:06.271] 1.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…

#8 [22:00:06.274] 2.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 >= %(…

#9 [22:00:06.277] 1.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_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…

#10 [22:00:06.280] 1.9ms

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:00:06.282] 1.7ms

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…

#12 [22:00:06.285] 1.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_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…

#13 [22:00:06.287] 1.6ms

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:00:06.289] 1.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…

#15 [22:00:06.291] 1.6ms

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…

#16 [22:00:06.293] 1.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:00:06.295] 1.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…

#18 [22:00:06.345] 48.4ms

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…

#19 [22:00:06.347] 1.4ms

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

#20 [22:00:06.349] 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)

#21 [22:00:06.351] 1.2ms

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

Benjamin Husthwaite

Analyzing Data...

Refresh Complete

Already Up to Date?

Analyzing Data...

Refresh Complete

Already Up to Date?