DEBUG - DEBUG - DEBUG

DEBUG - DEBUG - DEBUG

DEBUG - DEBUG - DEBUG

Referto Partita: Skunk Milano vs Hocheti Pokety

Referto Partita: Skunk Milano vs Hocheti Pokety

Skunk Milano

Hocheti Pokety

RISULTATO FINALE

91

94

1° Tempo

28

42

2° Tempo

35

31

3° Tempo

28

21

INVASIONI A MURO

0

2

Data e Luogo

Campionato Campionato Eccellenza 2024/2025 B1
Giornata: 18

Data e Luogo 06-04-2025 14:30 - Milano

Arbitri

Primo Arbitro Zanetti Gianluca

Secondo Arbitro Zanetti Gianluca

Refertista ASD Almara

Sorteggio

Sorteggio Vinto Da Hocheti Pokety

Scelta Sorteggio Palla

Progresso

Punteggi Individuali

Skunk Milano

Stefano Braschi

Tot.
4

2
x2

0
x3

0
x AUTOHIT
Edoardo Gladiali

Tot.
18

6
x2

2
x3

0
x AUTOHIT
Francesco Colombo

Tot.
12

3
x2

2
x3

0
x AUTOHIT
Tommaso Tomasina

Tot.
19

2
x2

5
x3

0
x AUTOHIT
Alessandro Perrone

Tot.
15

6
x2

1
x3

0
x AUTOHIT
Lorenzo Natino

Tot.
23

4
x2

5
x3

0
x AUTOHIT

Comportamento scorretto o antisportivo (Minuto: 14 - 2T)

Hocheti Pokety

Samuel Maselli

3
x2

0
x3

0
x AUTOHIT

Tot.
6
Thomas Rovetto

3
x2

0
x3

0
x AUTOHIT

Tot.
6
Alberto Racco

9
x2

2
x3

0
x AUTOHIT

Tot.
24
Luigi Ghirardi

7
x2

4
x3

0
x AUTOHIT

Tot.
26
Ramon Rutigliano

7
x2

0
x3

0
x AUTOHIT

Tot.
14
Ivan Dastrù

6
x2

2
x3

0
x AUTOHIT

Tot.
18

Sanzioni Disciplinari

Skunk Milano

5. Lorenzo Natino

Comportamento scorretto o antisportivo (Minuto: 14 - 2T)

Hocheti Pokety

                Total Queries: 55
        Total Time: 1.9088878631592
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1770966484.3426
            [end] => 1770966484.3431
            [time] => 0.00053119659423828
        )

    [1] => Array
        (
            [query] => select * from matches where match_id = '3833'
            [start] => 1770966484.3466
            [end] => 1770966484.3499
            [time] => 0.0032939910888672
        )

    [2] => Array
        (
            [query] => select time,closed from match_time where match_id = '3833'
            [start] => 1770966484.3499
            [end] => 1770966484.356
            [time] => 0.0061218738555908
        )

    [3] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3833'
            [start] => 1770966484.3561
            [end] => 1770966484.4157
            [time] => 0.059521913528442
        )

    [4] => Array
        (
            [query] => select time,closed from match_time where match_id = '3833'
            [start] => 1770966484.4161
            [end] => 1770966484.4243
            [time] => 0.0082151889801025
        )

    [5] => 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' ORDER BY lastname,firstname ASC
            [start] => 1770966484.4245
            [end] => 1770966484.4495
            [time] => 0.025007963180542
        )

    [6] => Array
        (
            [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
            [start] => 1770966484.4543
            [end] => 1770966484.456
            [time] => 0.0017399787902832
        )

    [7] => Array
        (
            [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
            [start] => 1770966484.4564
            [end] => 1770966484.4566
            [time] => 0.00022602081298828
        )

    [8] => Array
        (
            [query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC
            [start] => 1770966484.4567
            [end] => 1770966484.4584
            [time] => 0.0016040802001953
        )

    [9] => Array
        (
            [query] => select * from matches where match_id = '3833'
            [start] => 1770966484.4588
            [end] => 1770966484.4607
            [time] => 0.0018990039825439
        )

    [10] => Array
        (
            [query] => select time,closed from match_time where match_id = '3833'
            [start] => 1770966484.4608
            [end] => 1770966484.4702
            [time] => 0.0094161033630371
        )

    [11] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3833'
            [start] => 1770966484.4702
            [end] => 1770966484.5258
            [time] => 0.055536985397339
        )

    [12] => Array
        (
            [query] => select * from match_roster where match_id = '3833'
            [start] => 1770966484.526
            [end] => 1770966484.5635
            [time] => 0.03745698928833
        )

    [13] => Array
        (
            [query] => select * from matches where match_id = '3833'
            [start] => 1770966484.5636
            [end] => 1770966484.5639
            [time] => 0.00025200843811035
        )

    [14] => Array
        (
            [query] => select time,closed from match_time where match_id = '3833'
            [start] => 1770966484.5639
            [end] => 1770966484.572
            [time] => 0.0080490112304688
        )

    [15] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3833'
            [start] => 1770966484.572
            [end] => 1770966484.6226
            [time] => 0.050609827041626
        )

    [16] => Array
        (
            [query] => select point.*, penalty.cumulative from point 
                inner join penalty on (point.penalty_id = penalty.penalty_id)
                where point.match_id = '3833' and (point.point = 'P' or point.point = 'E')
            [start] => 1770966484.6258
            [end] => 1770966484.9432
            [time] => 0.31743693351746
        )

    [17] => Array
        (
            [query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC
            [start] => 1770966484.9433
            [end] => 1770966484.9479
            [time] => 0.0045850276947021
        )

    [18] => Array
        (
            [query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC
            [start] => 1770966484.948
            [end] => 1770966484.9519
            [time] => 0.0038979053497314
        )

    [19] => Array
        (
            [query] => select * from matches where match_id = '3833'
            [start] => 1770966484.952
            [end] => 1770966484.9522
            [time] => 0.00019693374633789
        )

    [20] => Array
        (
            [query] => select time,closed from match_time where match_id = '3833'
            [start] => 1770966484.9522
            [end] => 1770966484.9653
            [time] => 0.013098001480103
        )

    [21] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3833'
            [start] => 1770966484.9654
            [end] => 1770966485.028
            [time] => 0.062644958496094
        )

    [22] => Array
        (
            [query] => select * from match_roster where match_id = '3833'
            [start] => 1770966485.0283
            [end] => 1770966485.0593
            [time] => 0.030937910079956
        )

    [23] => 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 = '3833' group by player_id
        
            [start] => 1770966485.0593
            [end] => 1770966485.2969
            [time] => 0.23764300346375
        )

    [24] => Array
        (
            [query] => select * from penalty_to_team where match_id = '3833'
            [start] => 1770966485.2971
            [end] => 1770966485.299
            [time] => 0.0018808841705322
        )

    [25] => Array
        (
            [query] => select * from matches where match_id = '3833'
            [start] => 1770966485.299
            [end] => 1770966485.3009
            [time] => 0.0018148422241211
        )

    [26] => Array
        (
            [query] => select time,closed from match_time where match_id = '3833'
            [start] => 1770966485.3009
            [end] => 1770966485.3128
            [time] => 0.011919975280762
        )

    [27] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3833'
            [start] => 1770966485.3129
            [end] => 1770966485.4208
            [time] => 0.10791611671448
        )

    [28] => Array
        (
            [query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC
            [start] => 1770966485.4211
            [end] => 1770966485.4259
            [time] => 0.004810094833374
        )

    [29] => Array
        (
            [query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC
            [start] => 1770966485.426
            [end] => 1770966485.4339
            [time] => 0.0078928470611572
        )

    [30] => Array
        (
            [query] => select * from matches where match_id = '3833'
            [start] => 1770966485.4341
            [end] => 1770966485.4388
            [time] => 0.0046250820159912
        )

    [31] => Array
        (
            [query] => select time,closed from match_time where match_id = '3833'
            [start] => 1770966485.4388
            [end] => 1770966485.4499
            [time] => 0.011162042617798
        )

    [32] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3833'
            [start] => 1770966485.45
            [end] => 1770966485.5319
            [time] => 0.08187198638916
        )

    [33] => Array
        (
            [query] => select * from match_staff_roster where match_id = '3833'
            [start] => 1770966485.5321
            [end] => 1770966485.5425
            [time] => 0.010389804840088
        )

    [34] => Array
        (
            [query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
            [start] => 1770966485.5427
            [end] => 1770966485.5449
            [time] => 0.0022251605987549
        )

    [35] => 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 = '3833' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
            [start] => 1770966485.5449
            [end] => 1770966485.5451
            [time] => 0.00021600723266602
        )

    [36] => Array
        (
            [query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC
            [start] => 1770966485.5452
            [end] => 1770966485.5479
            [time] => 0.0027058124542236
        )

    [37] => Array
        (
            [query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC
            [start] => 1770966485.548
            [end] => 1770966485.5482
            [time] => 0.00018906593322754
        )

    [38] => Array
        (
            [query] => select * from matches where match_id = '3833'
            [start] => 1770966485.5483
            [end] => 1770966485.5514
            [time] => 0.0030570030212402
        )

    [39] => Array
        (
            [query] => select time,closed from match_time where match_id = '3833'
            [start] => 1770966485.5514
            [end] => 1770966485.5747
            [time] => 0.023321866989136
        )

    [40] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3833'
            [start] => 1770966485.5748
            [end] => 1770966485.649
            [time] => 0.074215888977051
        )

    [41] => Array
        (
            [query] => select * from matches where match_id = '3833'
            [start] => 1770966485.6493
            [end] => 1770966485.6514
            [time] => 0.0020551681518555
        )

    [42] => Array
        (
            [query] => select time,closed from match_time where match_id = '3833'
            [start] => 1770966485.6514
            [end] => 1770966485.6577
            [time] => 0.006328821182251
        )

    [43] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3833'
            [start] => 1770966485.6578
            [end] => 1770966485.7508
            [time] => 0.092967987060547
        )

    [44] => Array
        (
            [query] => select * from match_roster where match_id = '3833'
            [start] => 1770966485.751
            [end] => 1770966485.7918
            [time] => 0.040711164474487
        )

    [45] => Array
        (
            [query] => select * from point where match_id = '3833' order by point_id ASC
            [start] => 1770966485.7918
            [end] => 1770966486.1449
            [time] => 0.35314393043518
        )

    [46] => Array
        (
            [query] => select * from matches where match_id = '3833'
            [start] => 1770966486.1455
            [end] => 1770966486.1477
            [time] => 0.002202033996582
        )

    [47] => Array
        (
            [query] => select time,closed from match_time where match_id = '3833'
            [start] => 1770966486.1478
            [end] => 1770966486.16
            [time] => 0.012230157852173
        )

    [48] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3833'
            [start] => 1770966486.16
            [end] => 1770966486.2047
            [time] => 0.044607162475586
        )

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

    [50] => Array
        (
            [query] => select * from matches where match_id = '3833'
            [start] => 1770966486.2054
            [end] => 1770966486.2057
            [time] => 0.00025606155395508
        )

    [51] => Array
        (
            [query] => select time,closed from match_time where match_id = '3833'
            [start] => 1770966486.2057
            [end] => 1770966486.2121
            [time] => 0.0063691139221191
        )

    [52] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3833'
            [start] => 1770966486.2122
            [end] => 1770966486.2622
            [time] => 0.050061941146851
        )

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

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

)