DEBUG - DEBUG - DEBUG

DEBUG - DEBUG - DEBUG

DEBUG - DEBUG - DEBUG

Referto Partita: Hocheti Pokety vs Black Knights

Referto Partita: Hocheti Pokety vs Black Knights

Hocheti Pokety

Black Knights

RISULTATO FINALE

72

99

1° Tempo

24

26

2° Tempo

23

32

3° Tempo

25

41

INVASIONI A MURO

0

0

Data e Luogo

Campionato Campionato Eccellenza 2025/2026 A2
Giornata: 4

Data e Luogo 27-01-2026 21:50 - Cavour

Arbitri

Primo Arbitro Aquila Giovanni

Secondo Arbitro Valetti Mattia

Refertista ASD Polaris

Sorteggio

Sorteggio Vinto Da Hocheti Pokety

Scelta Sorteggio Palla

Progresso

Punteggi Individuali

Hocheti Pokety

Samuel Maselli

Tot.
4

2
x2

0
x3

1
x AUTOHIT
Alberto Racco

Tot.
21

6
x2

3
x3

1
x AUTOHIT
Simone De Meo

Tot.
14

4
x2

2
x3

0
x AUTOHIT
Luigi Ghirardi

Tot.
20

7
x2

2
x3

0
x AUTOHIT
Ramon Rutigliano

Tot.
12

3
x2

2
x3

0
x AUTOHIT

Black Knights

Alessandro Varetto

4
x2

5
x3

0
x AUTOHIT

Tot.
23
Fabio Bragagnolo

2
x2

3
x3

0
x AUTOHIT

Tot.
13
Gianluca Varetto

0
x2

3
x3

0
x AUTOHIT

Tot.
9
Lorenzo De Nicola Civitarese

6
x2

3
x3

0
x AUTOHIT

Tot.
21
Marco Antinoro

4
x2

2
x3

1
x AUTOHIT

Tot.
14
Matteo Vanni

4
x2

3
x3

0
x AUTOHIT

Tot.
17

                Total Queries: 55
        Total Time: 2.2107496261597
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1776066839.2416
            [end] => 1776066839.245
            [time] => 0.0034089088439941
        )

    [1] => Array
        (
            [query] => select * from matches where match_id = '4151'
            [start] => 1776066839.2796
            [end] => 1776066839.288
            [time] => 0.0083549022674561
        )

    [2] => Array
        (
            [query] => select time,closed from match_time where match_id = '4151'
            [start] => 1776066839.288
            [end] => 1776066839.3198
            [time] => 0.031761884689331
        )

    [3] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '4151'
            [start] => 1776066839.3199
            [end] => 1776066839.4486
            [time] => 0.1286940574646
        )

    [4] => Array
        (
            [query] => select time,closed from match_time where match_id = '4151'
            [start] => 1776066839.449
            [end] => 1776066839.4708
            [time] => 0.021763801574707
        )

    [5] => Array
        (
            [query] => select * from matches where match_id = '4151'
            [start] => 1776066839.4709
            [end] => 1776066839.4768
            [time] => 0.0058829784393311
        )

    [6] => Array
        (
            [query] => select time,closed from match_time where match_id = '4151'
            [start] => 1776066839.4768
            [end] => 1776066839.5148
            [time] => 0.037966966629028
        )

    [7] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '4151'
            [start] => 1776066839.5149
            [end] => 1776066839.6898
            [time] => 0.17494010925293
        )

    [8] => Array
        (
            [query] => select player.*,player_to_team.team_id,player_to_team.number,player_to_team.start,player_to_team.end from player
        left join player_to_team on (player.player_id = player_to_team.player_id) where deleted = '0' AND team_id in (6,23) ORDER BY lastname,firstname ASC
            [start] => 1776066839.6904
            [end] => 1776066839.7028
            [time] => 0.012392997741699
        )

    [9] => Array
        (
            [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
            [start] => 1776066839.7077
            [end] => 1776066839.7112
            [time] => 0.0035049915313721
        )

    [10] => Array
        (
            [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
            [start] => 1776066839.7116
            [end] => 1776066839.7119
            [time] => 0.00033307075500488
        )

    [11] => Array
        (
            [query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC
            [start] => 1776066839.712
            [end] => 1776066839.7211
            [time] => 0.0090479850769043
        )

    [12] => Array
        (
            [query] => select * from matches where match_id = '4151'
            [start] => 1776066839.7215
            [end] => 1776066839.7248
            [time] => 0.0032498836517334
        )

    [13] => Array
        (
            [query] => select time,closed from match_time where match_id = '4151'
            [start] => 1776066839.7248
            [end] => 1776066839.7418
            [time] => 0.016944885253906
        )

    [14] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '4151'
            [start] => 1776066839.7418
            [end] => 1776066839.8772
            [time] => 0.13538599014282
        )

    [15] => Array
        (
            [query] => select * from match_roster where match_id = '4151'
            [start] => 1776066839.8775
            [end] => 1776066839.9518
            [time] => 0.074276208877563
        )

    [16] => Array
        (
            [query] => select * from matches where match_id = '4151'
            [start] => 1776066839.952
            [end] => 1776066839.9639
            [time] => 0.011941909790039
        )

    [17] => Array
        (
            [query] => select time,closed from match_time where match_id = '4151'
            [start] => 1776066839.964
            [end] => 1776066839.9678
            [time] => 0.0037779808044434
        )

    [18] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '4151'
            [start] => 1776066839.9679
            [end] => 1776066840.1345
            [time] => 0.16658401489258
        )

    [19] => Array
        (
            [query] => select point.*, penalty.cumulative from point 
                inner join penalty on (point.penalty_id = penalty.penalty_id)
                where point.match_id = '4151' and (point.point = 'P' or point.point = 'E')
            [start] => 1776066840.1387
            [end] => 1776066840.5199
            [time] => 0.38124918937683
        )

    [20] => Array
        (
            [query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC
            [start] => 1776066840.52
            [end] => 1776066840.5249
            [time] => 0.0049219131469727
        )

    [21] => Array
        (
            [query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC
            [start] => 1776066840.525
            [end] => 1776066840.5287
            [time] => 0.0036690235137939
        )

    [22] => Array
        (
            [query] => select * from matches where match_id = '4151'
            [start] => 1776066840.5289
            [end] => 1776066840.5292
            [time] => 0.00024080276489258
        )

    [23] => Array
        (
            [query] => select time,closed from match_time where match_id = '4151'
            [start] => 1776066840.5292
            [end] => 1776066840.5374
            [time] => 0.0081620216369629
        )

    [24] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '4151'
            [start] => 1776066840.5374
            [end] => 1776066840.5961
            [time] => 0.058634996414185
        )

    [25] => Array
        (
            [query] => select * from match_roster where match_id = '4151'
            [start] => 1776066840.5964
            [end] => 1776066840.6361
            [time] => 0.039746999740601
        )

    [26] => Array
        (
            [query] => 
        SELECT 
        player_id,
        COALESCE(
            SUM(
            CASE 
            WHEN point = '2' THEN point 
            END )
        ,0) 
        as attack,
        
        COALESCE(
            SUM(
            CASE 
            WHEN point = '3' THEN point
            END )
        ,0)
        as defense,
        
        
        COALESCE(
            SUM(
            CASE 
            WHEN point = '2' THEN point 
            WHEN point = '3' THEN point
            END ) 
        ,0)
        as total,
        
        COALESCE(
            SUM(
            CASE 
            WHEN point = '2' THEN 1 
            END )
        ,0) 
        as hit_attack,
        
        COALESCE(
            SUM(
            CASE 
            WHEN point = '3' THEN 1
            END )
        ,0)
        as hit_defense,
        
        
        COALESCE(
            SUM(
            CASE 
            WHEN point = '2' THEN 1 
            WHEN point = '3' THEN 1
            END ) 
        ,0)
        as hit_total,
        
        COALESCE(
            SUM(
            CASE 
            WHEN point = 'A' THEN 1
            END ) 
        ,0)
        as autohit      
        
        FROM point where match_id = '4151' group by player_id
        
            [start] => 1776066840.6362
            [end] => 1776066840.8691
            [time] => 0.23299098014832
        )

    [27] => Array
        (
            [query] => select * from penalty_to_team where match_id = '4151'
            [start] => 1776066840.8693
            [end] => 1776066840.8709
            [time] => 0.0015909671783447
        )

    [28] => Array
        (
            [query] => select * from matches where match_id = '4151'
            [start] => 1776066840.871
            [end] => 1776066840.8749
            [time] => 0.0039210319519043
        )

    [29] => Array
        (
            [query] => select time,closed from match_time where match_id = '4151'
            [start] => 1776066840.8749
            [end] => 1776066840.8832
            [time] => 0.0082781314849854
        )

    [30] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '4151'
            [start] => 1776066840.8833
            [end] => 1776066840.9448
            [time] => 0.061499118804932
        )

    [31] => Array
        (
            [query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC
            [start] => 1776066840.9451
            [end] => 1776066840.948
            [time] => 0.0028948783874512
        )

    [32] => Array
        (
            [query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC
            [start] => 1776066840.9481
            [end] => 1776066840.9553
            [time] => 0.0072090625762939
        )

    [33] => Array
        (
            [query] => select * from matches where match_id = '4151'
            [start] => 1776066840.9555
            [end] => 1776066840.9558
            [time] => 0.00026106834411621
        )

    [34] => Array
        (
            [query] => select time,closed from match_time where match_id = '4151'
            [start] => 1776066840.9558
            [end] => 1776066840.966
            [time] => 0.010138034820557
        )

    [35] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '4151'
            [start] => 1776066840.966
            [end] => 1776066841.0272
            [time] => 0.061166048049927
        )

    [36] => Array
        (
            [query] => select * from match_staff_roster where match_id = '4151'
            [start] => 1776066841.0275
            [end] => 1776066841.0284
            [time] => 0.00088405609130859
        )

    [37] => Array
        (
            [query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
            [start] => 1776066841.0285
            [end] => 1776066841.031
            [time] => 0.0024809837341309
        )

    [38] => Array
        (
            [query] => select penalty_to_staff.*, staff_penalty.cumulative from penalty_to_staff 
                inner join staff_penalty on (penalty_to_staff.staff_penalty_id = staff_penalty.staff_penalty_id)
                where penalty_to_staff.match_id = '4151' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
            [start] => 1776066841.031
            [end] => 1776066841.0312
            [time] => 0.00023698806762695
        )

    [39] => Array
        (
            [query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC
            [start] => 1776066841.0313
            [end] => 1776066841.0379
            [time] => 0.006601095199585
        )

    [40] => Array
        (
            [query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC
            [start] => 1776066841.038
            [end] => 1776066841.0382
            [time] => 0.00019502639770508
        )

    [41] => Array
        (
            [query] => select * from matches where match_id = '4151'
            [start] => 1776066841.0384
            [end] => 1776066841.0386
            [time] => 0.00022482872009277
        )

    [42] => Array
        (
            [query] => select time,closed from match_time where match_id = '4151'
            [start] => 1776066841.0386
            [end] => 1776066841.0488
            [time] => 0.010200023651123
        )

    [43] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '4151'
            [start] => 1776066841.0489
            [end] => 1776066841.1046
            [time] => 0.055624008178711
        )

    [44] => Array
        (
            [query] => select * from matches where match_id = '4151'
            [start] => 1776066841.105
            [end] => 1776066841.1063
            [time] => 0.0013668537139893
        )

    [45] => Array
        (
            [query] => select time,closed from match_time where match_id = '4151'
            [start] => 1776066841.1063
            [end] => 1776066841.1157
            [time] => 0.0094010829925537
        )

    [46] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '4151'
            [start] => 1776066841.1158
            [end] => 1776066841.1797
            [time] => 0.063925981521606
        )

    [47] => Array
        (
            [query] => select * from match_roster where match_id = '4151'
            [start] => 1776066841.1801
            [end] => 1776066841.2081
            [time] => 0.028002023696899
        )

    [48] => Array
        (
            [query] => select * from point where match_id = '4151' order by point_id ASC
            [start] => 1776066841.2081
            [end] => 1776066841.4457
            [time] => 0.23762702941895
        )

    [49] => Array
        (
            [query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC
            [start] => 1776066841.4463
            [end] => 1776066841.4469
            [time] => 0.00054693222045898
        )

    [50] => Array
        (
            [query] => select * from matches where match_id = '4151'
            [start] => 1776066841.4469
            [end] => 1776066841.4479
            [time] => 0.0010058879852295
        )

    [51] => Array
        (
            [query] => select time,closed from match_time where match_id = '4151'
            [start] => 1776066841.448
            [end] => 1776066841.4543
            [time] => 0.006356954574585
        )

    [52] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '4151'
            [start] => 1776066841.4545
            [end] => 1776066841.4925
            [time] => 0.037994146347046
        )

    [53] => Array
        (
            [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
            [start] => 1776066841.4979
            [end] => 1776066841.5068
            [time] => 0.0089399814605713
        )

    [54] => Array
        (
            [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
            [start] => 1776066841.5076
            [end] => 1776066841.5099
            [time] => 0.0023479461669922
        )

)