DEBUG - DEBUG - DEBUG

DEBUG - DEBUG - DEBUG

DEBUG - DEBUG - DEBUG

Referto Partita: Hitbusters vs Hit Bulls

Referto Partita: Hitbusters vs Hit Bulls

Hitbusters

Hit Bulls

RISULTATO FINALE

84

142

1° Tempo

27

54

2° Tempo

27

54

3° Tempo

30

34

INVASIONI A MURO

0

0

Data e Luogo

Campionato Campionato Eccellenza 2022/2023 B1
Giornata: 18

Data e Luogo 14-04-2023 22:10 - Enaip

Arbitri

Primo Arbitro Spina Gabriele

Secondo Arbitro Da Re Francesca

Refertista Da Re Francesca

Sorteggio

Sorteggio Vinto Da Hit Bulls

Scelta Sorteggio Palla

Annotazioni

Addetto media per gli hitbusters: Ajassa Riccardo

Progresso

Punteggi Individuali

Hitbusters

Federica Nardacchione

Tot.
2

1
x2

0
x3

0
x AUTOHIT
Alessandro Caivano

Tot.
23

7
x2

3
x3

0
x AUTOHIT
Daniele Tessarin

Tot.
8

4
x2

0
x3

0
x AUTOHIT
Andrea Garzena

Tot.
19

5
x2

3
x3

0
x AUTOHIT
Luca Maria Mercurio

Tot.
32

10
x2

4
x3

0
x AUTOHIT
Noemi Castelluccio

Tot.
0

0
x2

0
x3

0
x AUTOHIT

Hit Bulls

Nicolò Bonincontro

6
x2

3
x3

0
x AUTOHIT

Tot.
21
Kevin Calvo

11
x2

3
x3

0
x AUTOHIT

Tot.
31
Emilio Bertello

13
x2

4
x3

0
x AUTOHIT

Tot.
38
Federico Tibaldi

13
x2

3
x3

0
x AUTOHIT

Tot.
35
Alberto Gabriolo

4
x2

3
x3

0
x AUTOHIT

Tot.
17

                Total Queries: 55
        Total Time: 1.9422650337219
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1770979961.9665
            [end] => 1770979961.9698
            [time] => 0.0033519268035889
        )

    [1] => Array
        (
            [query] => select * from matches where match_id = '2617'
            [start] => 1770979961.9741
            [end] => 1770979961.9744
            [time] => 0.00022697448730469
        )

    [2] => Array
        (
            [query] => select time,closed from match_time where match_id = '2617'
            [start] => 1770979961.9744
            [end] => 1770979961.9764
            [time] => 0.002018928527832
        )

    [3] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '2617'
            [start] => 1770979961.9765
            [end] => 1770979962.0155
            [time] => 0.039012908935547
        )

    [4] => Array
        (
            [query] => select time,closed from match_time where match_id = '2617'
            [start] => 1770979962.0158
            [end] => 1770979962.0278
            [time] => 0.0119788646698
        )

    [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] => 1770979962.028
            [end] => 1770979962.0467
            [time] => 0.018625974655151
        )

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

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

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

    [9] => Array
        (
            [query] => select * from matches where match_id = '2617'
            [start] => 1770979962.0829
            [end] => 1770979962.0831
            [time] => 0.00020480155944824
        )

    [10] => Array
        (
            [query] => select time,closed from match_time where match_id = '2617'
            [start] => 1770979962.0831
            [end] => 1770979962.0911
            [time] => 0.0080130100250244
        )

    [11] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '2617'
            [start] => 1770979962.0912
            [end] => 1770979962.1294
            [time] => 0.038257122039795
        )

    [12] => Array
        (
            [query] => select * from match_roster where match_id = '2617'
            [start] => 1770979962.1297
            [end] => 1770979962.1716
            [time] => 0.04187798500061
        )

    [13] => Array
        (
            [query] => select * from matches where match_id = '2617'
            [start] => 1770979962.1717
            [end] => 1770979962.1719
            [time] => 0.00021886825561523
        )

    [14] => Array
        (
            [query] => select time,closed from match_time where match_id = '2617'
            [start] => 1770979962.1719
            [end] => 1770979962.1812
            [time] => 0.0092730522155762
        )

    [15] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '2617'
            [start] => 1770979962.1813
            [end] => 1770979962.2278
            [time] => 0.046483993530273
        )

    [16] => Array
        (
            [query] => select point.*, penalty.cumulative from point 
                inner join penalty on (point.penalty_id = penalty.penalty_id)
                where point.match_id = '2617' and (point.point = 'P' or point.point = 'E')
            [start] => 1770979962.238
            [end] => 1770979962.5658
            [time] => 0.32776808738708
        )

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

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

    [19] => Array
        (
            [query] => select * from matches where match_id = '2617'
            [start] => 1770979962.5671
            [end] => 1770979962.5707
            [time] => 0.0036551952362061
        )

    [20] => Array
        (
            [query] => select time,closed from match_time where match_id = '2617'
            [start] => 1770979962.5708
            [end] => 1770979962.5861
            [time] => 0.01529598236084
        )

    [21] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '2617'
            [start] => 1770979962.5861
            [end] => 1770979962.6621
            [time] => 0.075934886932373
        )

    [22] => Array
        (
            [query] => select * from match_roster where match_id = '2617'
            [start] => 1770979962.6623
            [end] => 1770979962.7288
            [time] => 0.06646203994751
        )

    [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 = '2617' group by player_id
        
            [start] => 1770979962.7288
            [end] => 1770979963.0589
            [time] => 0.33009004592896
        )

    [24] => Array
        (
            [query] => select * from penalty_to_team where match_id = '2617'
            [start] => 1770979963.0591
            [end] => 1770979963.0594
            [time] => 0.00030899047851562
        )

    [25] => Array
        (
            [query] => select * from matches where match_id = '2617'
            [start] => 1770979963.0595
            [end] => 1770979963.0598
            [time] => 0.00029301643371582
        )

    [26] => Array
        (
            [query] => select time,closed from match_time where match_id = '2617'
            [start] => 1770979963.0598
            [end] => 1770979963.0694
            [time] => 0.0096349716186523
        )

    [27] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '2617'
            [start] => 1770979963.0695
            [end] => 1770979963.1997
            [time] => 0.13026714324951
        )

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

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

    [30] => Array
        (
            [query] => select * from matches where match_id = '2617'
            [start] => 1770979963.2105
            [end] => 1770979963.2148
            [time] => 0.0042688846588135
        )

    [31] => Array
        (
            [query] => select time,closed from match_time where match_id = '2617'
            [start] => 1770979963.2148
            [end] => 1770979963.2378
            [time] => 0.023038864135742
        )

    [32] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '2617'
            [start] => 1770979963.2379
            [end] => 1770979963.3118
            [time] => 0.07382607460022
        )

    [33] => Array
        (
            [query] => select * from match_staff_roster where match_id = '2617'
            [start] => 1770979963.312
            [end] => 1770979963.3197
            [time] => 0.0077300071716309
        )

    [34] => Array
        (
            [query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
            [start] => 1770979963.3198
            [end] => 1770979963.3227
            [time] => 0.0028908252716064
        )

    [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 = '2617' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
            [start] => 1770979963.3228
            [end] => 1770979963.323
            [time] => 0.00026488304138184
        )

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

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

    [38] => Array
        (
            [query] => select * from matches where match_id = '2617'
            [start] => 1770979963.3237
            [end] => 1770979963.3239
            [time] => 0.00018906593322754
        )

    [39] => Array
        (
            [query] => select time,closed from match_time where match_id = '2617'
            [start] => 1770979963.3239
            [end] => 1770979963.3298
            [time] => 0.0059139728546143
        )

    [40] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '2617'
            [start] => 1770979963.3299
            [end] => 1770979963.3859
            [time] => 0.055980920791626
        )

    [41] => Array
        (
            [query] => select * from matches where match_id = '2617'
            [start] => 1770979963.3862
            [end] => 1770979963.3888
            [time] => 0.0025968551635742
        )

    [42] => Array
        (
            [query] => select time,closed from match_time where match_id = '2617'
            [start] => 1770979963.3888
            [end] => 1770979963.3922
            [time] => 0.0034501552581787
        )

    [43] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '2617'
            [start] => 1770979963.3923
            [end] => 1770979963.4191
            [time] => 0.026830911636353
        )

    [44] => Array
        (
            [query] => select * from match_roster where match_id = '2617'
            [start] => 1770979963.4194
            [end] => 1770979963.4413
            [time] => 0.021867036819458
        )

    [45] => Array
        (
            [query] => select * from point where match_id = '2617' order by point_id ASC
            [start] => 1770979963.4413
            [end] => 1770979963.7548
            [time] => 0.31344890594482
        )

    [46] => Array
        (
            [query] => select * from matches where match_id = '2617'
            [start] => 1770979963.7554
            [end] => 1770979963.7617
            [time] => 0.006371021270752
        )

    [47] => Array
        (
            [query] => select time,closed from match_time where match_id = '2617'
            [start] => 1770979963.7618
            [end] => 1770979963.7789
            [time] => 0.017176866531372
        )

    [48] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '2617'
            [start] => 1770979963.779
            [end] => 1770979963.8649
            [time] => 0.085877895355225
        )

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

    [50] => Array
        (
            [query] => select * from matches where match_id = '2617'
            [start] => 1770979963.8658
            [end] => 1770979963.866
            [time] => 0.00024104118347168
        )

    [51] => Array
        (
            [query] => select time,closed from match_time where match_id = '2617'
            [start] => 1770979963.866
            [end] => 1770979963.8761
            [time] => 0.010080814361572
        )

    [52] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '2617'
            [start] => 1770979963.8762
            [end] => 1770979963.9461
            [time] => 0.069919109344482
        )

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

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

)