Mark Smith

CPSA: EE64377

Apr 2026 -

Data Range

1

Total Shoots

100

Targets Shot

1

Grounds Visited

Discipline Performance

ESP 64.0%

PB: 64.0% Targets: 100

Score Trend

Performance over time across all disciplines

Discipline Split

Proportion of shoots by discipline

Personal Bests

Best score achieved per discipline

ESP 1 shoot 64.0% avg 64.0%

Top Grounds

Most visited grounds and average score

Ground	Visits	Avg	Best
Chalk Farm Clay Ground	1	64.0%	64.0%

Discipline × Ground Performance

Average score and personal best by discipline and ground

Chalk Farm Clay Ground 1×

Discipline	Avg ↕	PB ↕
ESP	64.0%	64.0%

Recent Results

Last 1 competition results

04 Apr 2026 ESP C

100 ESP REG THE NORFOLK CPSA 100 BIRD SPORTING THE NORFOLK 100 BIRD CPSA SPORTING CUP SQUADDED

Chalk Farm Clay Ground

Score 64/100

% 64.0%

Class Avg 62.6%

Class Rank 17th= in C

Overall Rank 136th=

							Classification				Overall
Date	Event		Discipline	Ground	Score	%	Class	Class Avg	Δ vs Class	Class Rank	Field Avg	Overall Rank
04 Apr 2026	100 ESP REG THE NORFOLK CPSA 100 BIRD SPORTING THE NORFOLK 100 BIRD CPSA SPORTING CUP SQUADDED		ESP	Chalk Farm Clay Ground	64/100	64.0%	C	62.6%	+1.4%	17th=	74.6%	136th=

0%

Analyzing Data...

Connecting to CPSA...

Initial Scores

History Pages

Classifications

Fixture Details

VER: v0.4

BUILD:

DEPLOYED: 01 Jul 2026 16:45:53

    ⚙ Performance Stats
    DRAG TO MOVE
  

        0.075s
        ● FAST
        
      

        DB 78% ·
        Py 20% ·
        Render 2%
      

      
      
      11 queries · avg 5.3ms ·
      max 43.9ms
    
Render Breakdown

        DB Logic (Pre-Render)
        0.0583s
      

        Python Logic (Pre-Render)
        0.0151s
      

        Full Page Render
        0.0012s
      
QUERY TABLES ▾

          ⚠ shoot_score
          7× 0.053s
        

          site_configuration
          2× 0.002s
        

          shooter
          1× 0.002s
        

          admin_menu_item
          1× 0.001s
        
⚠ = queried 3+ times (cache candidate)
SQL QUERIES (11) — click to expand

            #1 [23:59:34.670]
            1.9ms
          
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…

            #2 [23:59:34.672]
            1.5ms
          
shoot_score
SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, shoot_score.event_id AS shoot_score…

            #3 [23:59:34.675]
            1.4ms
          
shoot_score
SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, shoot_score.event_id AS shoot_score…

            #4 [23:59:34.677]
            1.3ms
          
shoot_score
SELECT count(*) AS count_1 
FROM (SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, s…

            #5 [23:59:34.721]
            43.9ms
          
shoot_score
SELECT shoot_score.event_id AS shoot_score_event_id 
FROM shoot_score 
WHERE shoot_score.event_id IN (%(event_id_1_1)s) GROUP BY shoot_score.event_id 
HAVING count(shoot_score.id) > %(count_1)s

            #6 [23:59:34.724]
            1.3ms
          
shoot_score
SELECT shoot_score.event_id AS shoot_score_event_id, avg(shoot_score.percentage) AS avg_1 
FROM shoot_score 
WHERE shoot_score.event_id IN (%(event_id_1_1)s) AND shoot_score.percentage IS NOT NULL GROUP BY shoot_score.event_id

            #7 [23:59:34.727]
            1.4ms
          
shoot_score
SELECT shoot_score.event_id AS shoot_score_event_id, trim(replace(shoot_score.shooter_class, %(replace_1)s, %(replace_2)s)) AS trim_1, avg(shoot_score.percentage) AS avg_1 
FROM shoot_score 
WHERE shoot_score.event_id IN (%(event_id_1_1)s) AND shoot_score.shooter_class IS NOT NULL AND shoot_score.pe…

            #8 [23:59:34.730]
            2.6ms
          
shoot_score
SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, shoot_score.event_id AS shoot_score…

            #9 [23:59:34.736]
            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

            #10 [23:59:34.738]
            1.0ms
          
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)

            #11 [23:59:34.739]
            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
Open this panel before using the page to capture live request/debug data.