West Midlands Shooting Ground

    ⚙ Performance Stats
    DRAG TO MOVE
  

        4.323s
        ● SLOW
      

        DB 98% ·
        Py 2% ·
        Render 0%
      

      
      
      43 queries · avg 98.2ms ·
      max 2367.0ms
    
Render Breakdown

        DB Logic (Pre-Render)
        4.2216s
      

        Python Logic (Pre-Render)
        0.0947s
      

        Full Page Render
        0.0072s
      
QUERY TABLES ▾

          ⚠ shoot_score
          27× 3.298s
        

          ⚠ shoot_event
          5× 0.215s
        

          ⚠ site_configuration
          4× 0.005s
        

          ⚠ ground_review
          4× 0.004s
        

          ground
          1× 0.003s
        

          shooter
          1× 0.696s
        

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

            #1 [20:24:08.233]
            3.2ms
          
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 [20:24:08.240]
            2.7ms
          
shoot_event
SELECT shoot_event.id AS shoot_event_id, shoot_event.cpsa_fixture_id AS shoot_event_cpsa_fixture_id, shoot_event.name AS shoot_event_name, shoot_event.date AS shoot_event_date, shoot_event.discipline AS shoot_event_discipline, shoot_event.ground AS shoot_event_ground, shoot_event.url AS shoot_event_…

            #3 [20:24:08.255]
            7.2ms
          
shoot_event
SELECT shoot_event.discipline AS shoot_event_discipline, count(shoot_score.id) AS count_1, sum(shoot_score.hits) AS sum_1, sum(shoot_score.targets) AS sum_2, avg(shoot_score.percentage) AS avg_1 
FROM shoot_event JOIN shoot_score ON shoot_score.event_id = shoot_event.id 
WHERE shoot_event.ground = %…

            #4 [20:24:08.270]
            9.1ms
          
shoot_event
SELECT EXTRACT(year FROM shoot_event.date) AS yr, EXTRACT(month FROM shoot_event.date) AS mo, shoot_event.discipline AS shoot_event_discipline, avg(shoot_score.percentage) AS avg_1 
FROM shoot_event JOIN shoot_score ON shoot_score.event_id = shoot_event.id 
WHERE shoot_event.ground = %(ground_1)s AN…

            #5 [20:24:08.325]
            53.5ms
          
shoot_score
SELECT shoot_event.discipline AS shoot_event_discipline, trim(replace(shoot_score.shooter_class, %(replace_1)s, %(replace_2)s)) AS trim_1, count(shoot_score.id) AS count_1 
FROM shoot_score JOIN shoot_event ON shoot_score.event_id = shoot_event.id 
WHERE shoot_event.ground = %(ground_1)s AND shoot_e…

            #6 [20:24:10.722]
            2367.0ms
          
shoot_score
SELECT trim(replace(shoot_score.shooter_class, %(replace_1)s, %(replace_2)s)) AS trim_1, count(shoot_score.id) AS count_1 
FROM shoot_score JOIN shoot_event ON shoot_score.event_id = shoot_event.id 
WHERE shoot_event.date <= %(date_1)s AND shoot_event.admin_hidden != true AND shoot_score.shooter_cla…

            #7 [20:24:10.822]
            98.0ms
          
shoot_event
SELECT EXTRACT(year FROM shoot_event.date) AS yr, EXTRACT(month FROM shoot_event.date) AS mo, shoot_event.discipline AS shoot_event_discipline, count(shoot_event.id) AS count_1 
FROM shoot_event 
WHERE shoot_event.ground = %(ground_1)s AND shoot_event.date <= %(date_1)s AND shoot_event.admin_hidden …

            #8 [20:24:10.824]
            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…

            #9 [20:24:10.826]
            1.1ms
          
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…

            #10 [20:24:10.828]
            1.1ms
          
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…

            #11 [20:24:10.921]
            92.5ms
          
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…

            #12 [20:24:10.924]
            1.1ms
          
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…

            #13 [20:24:10.925]
            1.1ms
          
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…

            #14 [20:24:10.927]
            1.1ms
          
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…

            #15 [20:24:10.929]
            1.2ms
          
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…

            #16 [20:24:10.931]
            1.1ms
          
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…

            #17 [20:24:10.932]
            1.0ms
          
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…

            #18 [20:24:11.122]
            189.1ms
          
shoot_score
SELECT shoot_score.event_id AS shoot_score_event_id, shoot_score.percentage AS shoot_score_percentage, shooter.name AS shooter_name 
FROM shoot_score JOIN shooter ON shoot_score.shooter_id = shooter.id JOIN (SELECT shoot_score.event_id AS event_id, max(shoot_score.percentage) AS max_pct 
FROM shoot_…

            #19 [20:24:11.222]
            97.5ms
          
shoot_score
SELECT shoot_score.event_id AS shoot_score_event_id, avg(shoot_score.percentage) AS avg_1, count(shoot_score.id) AS count_1, min(shoot_score.percentage) AS min_1 
FROM shoot_score 
WHERE shoot_score.event_id IN (%(event_id_1_1)s, %(event_id_1_2)s, %(event_id_1_3)s, %(event_id_1_4)s, %(event_id_1_5)s…

            #20 [20:24:11.323]
            98.5ms
          
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 cls, avg(shoot_score.percentage) AS avg_1 
FROM shoot_score 
WHERE shoot_score.event_id IN (%(event_id_1_1)s, %(event_id_1_2)s, %(event_id_1_3)s, %(event_id_1_4)s, %(event_i…

            #21 [20:24:11.325]
            1.1ms
          
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…

            #22 [20:24:11.327]
            1.0ms
          
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…

            #23 [20:24:11.329]
            1.1ms
          
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…

            #24 [20:24:11.331]
            1.1ms
          
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…

            #25 [20:24:11.332]
            1.0ms
          
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…

            #26 [20:24:11.334]
            1.0ms
          
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…

            #27 [20:24:11.336]
            1.0ms
          
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…

            #28 [20:24:11.338]
            1.1ms
          
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…

            #29 [20:24:11.340]
            1.1ms
          
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…

            #30 [20:24:11.421]
            80.5ms
          
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…

            #31 [20:24:11.521]
            97.9ms
          
shoot_score
SELECT count(distinct(shoot_score.shooter_id)) AS count_1 
FROM shoot_score JOIN shoot_event ON shoot_score.event_id = shoot_event.id 
WHERE shoot_event.ground = %(ground_1)s AND shoot_event.date <= %(date_1)s AND shoot_event.admin_hidden != true

            #32 [20:24:11.725]
            202.2ms
          
shoot_score
SELECT shoot_score.percentage AS shoot_score_percentage, shooter.name AS shooter_name, shoot_event.discipline AS shoot_event_discipline, shoot_event.date AS shoot_event_date 
FROM shoot_score JOIN shooter ON shoot_score.shooter_id = shooter.id JOIN shoot_event ON shoot_score.event_id = shoot_event.i…

            #33 [20:24:12.422]
            695.8ms
          
shooter
SELECT shooter.name AS shooter_name, count(shoot_score.id) AS count_1, avg(shoot_score.percentage) AS avg_1, max(shoot_score.percentage) AS max_1 
FROM shooter JOIN shoot_score ON shoot_score.shooter_id = shooter.id JOIN shoot_event ON shoot_score.event_id = shoot_event.id 
WHERE shoot_event.ground …

            #34 [20:24:12.522]
            97.7ms
          
shoot_event
SELECT shoot_event.discipline AS shoot_event_discipline, shoot_score.percentage AS shoot_score_percentage, shooter.name AS shooter_name, shoot_event.date AS shoot_event_date 
FROM shoot_event JOIN shoot_score ON shoot_score.event_id = shoot_event.id JOIN shooter ON shoot_score.shooter_id = shooter.i…

            #35 [20:24:12.524]
            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

            #36 [20:24:12.526]
            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 = %(key_1)s 
 LIMIT %(param_1)s

            #37 [20:24:12.528]
            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 = %(key_1)s 
 LIMIT %(param_1)s

            #38 [20:24:12.530]
            1.0ms
          
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

            #39 [20:24:12.532]
            1.1ms
          
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_…

            #40 [20:24:12.534]
            1.1ms
          
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…

            #41 [20:24:12.536]
            1.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…

            #42 [20:24:12.538]
            1.5ms
          
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)

            #43 [20:24:12.539]
            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
Open this panel before using the page to capture live request/debug data.

West Midlands Shooting Ground

Analyzing Data...

Refresh Complete

Already Up to Date?

Analyzing Data...

Refresh Complete

Already Up to Date?