DEBUG - DEBUG - DEBUG

DEBUG - DEBUG - DEBUG

DEBUG - DEBUG - DEBUG

Referto Partita: Together Hit vs Monstars - Villains

Referto Partita: Together Hit vs Monstars - Villains

Together Hit

Monstars - Villains

RISULTATO FINALE

68

71

1° Tempo

21

30

2° Tempo

20

13

3° Tempo

27

25

OVERTIME

0

3

INVASIONI A MURO

0

0

Data e Luogo

Campionato Campionato Eccellenza 2024/2025 B2
Giornata: 13

Data e Luogo 04-02-2025 21:50 - Cavour

Arbitri

Primo Arbitro Pajno Riccardo

Secondo Arbitro Pajno Riccardo

Refertista ASD Polaris

Sorteggio

Sorteggio Vinto Da Monstars - Villains

Scelta Sorteggio Palla

Annotazioni

Refertista di società: Rovetto thomas

Progresso

Punteggi Individuali

Together Hit

Stefano Mazzilli

Tot.
10

5
x2

0
x3

0
x AUTOHIT
Gabriele Argirò

Tot.
9

3
x2

1
x3

1
x AUTOHIT
Andrea Crovagna

Tot.
32

10
x2

4
x3

0
x AUTOHIT
Mauro Maria Pittavino

Tot.
0

0
x2

0
x3

0
x AUTOHIT
Rebecca Aurigemma

Tot.
0

0
x2

0
x3

0
x AUTOHIT
Gianluca Sabatino

Tot.
15

6
x2

1
x3

0
x AUTOHIT

Monstars - Villains

Lorenzo Lombardo

5
x2

0
x3

1
x AUTOHIT

Tot.
10
Andrea Brocchetta

3
x2

0
x3

1
x AUTOHIT

Tot.
6
Alessandro Castello

2
x2

0
x3

0
x AUTOHIT

Tot.
4
Daniele Cecconata

0
x2

1
x3

0
x AUTOHIT

Tot.
3
Daniele Cena

6
x2

1
x3

0
x AUTOHIT

Tot.
15
Chiara Gilardi

0
x2

0
x3

0
x AUTOHIT

Tot.
0
Mara Ferraris

1
x2

1
x3

0
x AUTOHIT

Tot.
5
Mattia Borca

12
x2

1
x3

0
x AUTOHIT

Tot.
27

                Total Queries: 55
        Total Time: 2.1396658420563
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1786252998.3105
            [end] => 1786252998.3129
            [time] => 0.0023751258850098
        )

    [1] => Array
        (
            [query] => select * from matches where match_id = '3740'
            [start] => 1786252998.3152
            [end] => 1786252998.3154
            [time] => 0.00024580955505371
        )

    [2] => Array
        (
            [query] => select time,closed from match_time where match_id = '3740'
            [start] => 1786252998.3155
            [end] => 1786252998.3239
            [time] => 0.0084249973297119
        )

    [3] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3740'
            [start] => 1786252998.324
            [end] => 1786252998.3828
            [time] => 0.058767795562744
        )

    [4] => Array
        (
            [query] => select time,closed from match_time where match_id = '3740'
            [start] => 1786252998.3831
            [end] => 1786252998.4142
            [time] => 0.031105995178223
        )

    [5] => Array
        (
            [query] => select * from matches where match_id = '3740'
            [start] => 1786252998.4144
            [end] => 1786252998.4146
            [time] => 0.00025320053100586
        )

    [6] => Array
        (
            [query] => select time,closed from match_time where match_id = '3740'
            [start] => 1786252998.4146
            [end] => 1786252998.4251
            [time] => 0.010447978973389
        )

    [7] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3740'
            [start] => 1786252998.4251
            [end] => 1786252998.4995
            [time] => 0.074340105056763
        )

    [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 (29,9) ORDER BY lastname,firstname ASC
            [start] => 1786252998.4999
            [end] => 1786252998.5107
            [time] => 0.010720014572144
        )

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

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

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

    [12] => Array
        (
            [query] => select * from matches where match_id = '3740'
            [start] => 1786252998.5233
            [end] => 1786252998.5235
            [time] => 0.00024795532226562
        )

    [13] => Array
        (
            [query] => select time,closed from match_time where match_id = '3740'
            [start] => 1786252998.5236
            [end] => 1786252998.536
            [time] => 0.01242208480835
        )

    [14] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3740'
            [start] => 1786252998.5361
            [end] => 1786252998.6165
            [time] => 0.080413103103638
        )

    [15] => Array
        (
            [query] => select * from match_roster where match_id = '3740'
            [start] => 1786252998.6168
            [end] => 1786252998.6678
            [time] => 0.051043033599854
        )

    [16] => Array
        (
            [query] => select * from matches where match_id = '3740'
            [start] => 1786252998.6679
            [end] => 1786252998.6682
            [time] => 0.00023102760314941
        )

    [17] => Array
        (
            [query] => select time,closed from match_time where match_id = '3740'
            [start] => 1786252998.6682
            [end] => 1786252998.6806
            [time] => 0.012446880340576
        )

    [18] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3740'
            [start] => 1786252998.6807
            [end] => 1786252998.7523
            [time] => 0.071578025817871
        )

    [19] => Array
        (
            [query] => select point.*, penalty.cumulative from point 
                inner join penalty on (point.penalty_id = penalty.penalty_id)
                where point.match_id = '3740' and (point.point = 'P' or point.point = 'E')
            [start] => 1786252998.7555
            [end] => 1786252999.2197
            [time] => 0.4642219543457
        )

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

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

    [22] => Array
        (
            [query] => select * from matches where match_id = '3740'
            [start] => 1786252999.2205
            [end] => 1786252999.2207
            [time] => 0.00024104118347168
        )

    [23] => Array
        (
            [query] => select time,closed from match_time where match_id = '3740'
            [start] => 1786252999.2207
            [end] => 1786252999.2332
            [time] => 0.012437105178833
        )

    [24] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3740'
            [start] => 1786252999.2332
            [end] => 1786252999.3072
            [time] => 0.07394003868103
        )

    [25] => Array
        (
            [query] => select * from match_roster where match_id = '3740'
            [start] => 1786252999.3075
            [end] => 1786252999.3644
            [time] => 0.056926965713501
        )

    [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 = '3740' group by player_id
        
            [start] => 1786252999.3644
            [end] => 1786252999.6563
            [time] => 0.29186201095581
        )

    [27] => Array
        (
            [query] => select * from penalty_to_team where match_id = '3740'
            [start] => 1786252999.6565
            [end] => 1786252999.6577
            [time] => 0.0012660026550293
        )

    [28] => Array
        (
            [query] => select * from matches where match_id = '3740'
            [start] => 1786252999.6578
            [end] => 1786252999.658
            [time] => 0.00022220611572266
        )

    [29] => Array
        (
            [query] => select time,closed from match_time where match_id = '3740'
            [start] => 1786252999.658
            [end] => 1786252999.674
            [time] => 0.015935182571411
        )

    [30] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3740'
            [start] => 1786252999.674
            [end] => 1786252999.7478
            [time] => 0.073809862136841
        )

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

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

    [33] => Array
        (
            [query] => select * from matches where match_id = '3740'
            [start] => 1786252999.7505
            [end] => 1786252999.7507
            [time] => 0.00023889541625977
        )

    [34] => Array
        (
            [query] => select time,closed from match_time where match_id = '3740'
            [start] => 1786252999.7507
            [end] => 1786252999.7672
            [time] => 0.016420841217041
        )

    [35] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3740'
            [start] => 1786252999.7673
            [end] => 1786252999.8368
            [time] => 0.069489002227783
        )

    [36] => Array
        (
            [query] => select * from match_staff_roster where match_id = '3740'
            [start] => 1786252999.837
            [end] => 1786252999.8457
            [time] => 0.0086679458618164
        )

    [37] => Array
        (
            [query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
            [start] => 1786252999.8458
            [end] => 1786252999.846
            [time] => 0.00020003318786621
        )

    [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 = '3740' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
            [start] => 1786252999.846
            [end] => 1786252999.8463
            [time] => 0.00023722648620605
        )

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

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

    [41] => Array
        (
            [query] => select * from matches where match_id = '3740'
            [start] => 1786252999.8493
            [end] => 1786252999.8549
            [time] => 0.0056090354919434
        )

    [42] => Array
        (
            [query] => select time,closed from match_time where match_id = '3740'
            [start] => 1786252999.855
            [end] => 1786252999.8625
            [time] => 0.0075509548187256
        )

    [43] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3740'
            [start] => 1786252999.8626
            [end] => 1786252999.9274
            [time] => 0.064883232116699
        )

    [44] => Array
        (
            [query] => select * from matches where match_id = '3740'
            [start] => 1786252999.9278
            [end] => 1786252999.9359
            [time] => 0.008091926574707
        )

    [45] => Array
        (
            [query] => select time,closed from match_time where match_id = '3740'
            [start] => 1786252999.9359
            [end] => 1786252999.9477
            [time] => 0.011827945709229
        )

    [46] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3740'
            [start] => 1786252999.9478
            [end] => 1786253000.0175
            [time] => 0.069668054580688
        )

    [47] => Array
        (
            [query] => select * from match_roster where match_id = '3740'
            [start] => 1786253000.0178
            [end] => 1786253000.0628
            [time] => 0.044984817504883
        )

    [48] => Array
        (
            [query] => select * from point where match_id = '3740' order by point_id ASC
            [start] => 1786253000.0628
            [end] => 1786253000.3864
            [time] => 0.32355308532715
        )

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

    [50] => Array
        (
            [query] => select * from matches where match_id = '3740'
            [start] => 1786253000.391
            [end] => 1786253000.3912
            [time] => 0.00021696090698242
        )

    [51] => Array
        (
            [query] => select time,closed from match_time where match_id = '3740'
            [start] => 1786253000.3912
            [end] => 1786253000.3996
            [time] => 0.0083930492401123
        )

    [52] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3740'
            [start] => 1786253000.3997
            [end] => 1786253000.4556
            [time] => 0.055867910385132
        )

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

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

)