DEBUG - DEBUG - DEBUG

DEBUG - DEBUG - DEBUG

DEBUG - DEBUG - DEBUG

Referto Partita: Delirium Consulum vs Iron Lion Tyson

Referto Partita: Delirium Consulum vs Iron Lion Tyson

Delirium Consulum

Iron Lion Tyson

RISULTATO FINALE

65

86

1° Tempo

21

22

2° Tempo

24

24

3° Tempo

20

40

INVASIONI A MURO

2

0

Data e Luogo

Campionato Campionato Eccellenza 2023/2024 B1
Giornata: 14

Data e Luogo 05-03-2024 20:45 - Cavour

Arbitri

Primo Arbitro Bracesco Martina

Secondo Arbitro Bracesco Martina

Refertista ASD Polaris

Sorteggio

Sorteggio Vinto Da Iron Lion Tyson

Scelta Sorteggio Palla

Annotazioni

Refertista: Gaspare Guarrato

Progresso

Punteggi Individuali

Delirium Consulum

Paolo Lamberti

Tot.
26

4
x2

6
x3

0
x AUTOHIT
Renato Dalle Mura

Tot.
17

7
x2

1
x3

0
x AUTOHIT
Andrea Matys

Tot.
0

0
x2

0
x3

0
x AUTOHIT
Dino Pagano

Tot.
7

2
x2

1
x3

0
x AUTOHIT
Biagio Bodanza

Tot.
0

0
x2

0
x3

0
x AUTOHIT
Bogdan Andrei Stancu

Tot.
15

3
x2

3
x3

0
x AUTOHIT
Pietro Chevallard

Tot.
0

0
x2

0
x3

0
x AUTOHIT
Gianluca Minuto

Tot.
0

0
x2

0
x3

0
x AUTOHIT

Iron Lion Tyson

Marco Barrasso

10
x2

3
x3

0
x AUTOHIT

Tot.
29
Mario Franchi

2
x2

0
x3

0
x AUTOHIT

Tot.
4
Paul Mihei

9
x2

1
x3

0
x AUTOHIT

Tot.
21
Francesco Rigoni

1
x2

1
x3

0
x AUTOHIT

Tot.
5
SIlvia Petiti

0
x2

0
x3

0
x AUTOHIT

Tot.
0
Emiliano Travaglini

8
x2

3
x3

0
x AUTOHIT

Tot.
25
Simone Garino

1
x2

0
x3

0
x AUTOHIT

Tot.
2

                Total Queries: 55
        Total Time: 1.8145592212677
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1786249770.058
            [end] => 1786249770.0584
            [time] => 0.00038909912109375
        )

    [1] => Array
        (
            [query] => select * from matches where match_id = '3217'
            [start] => 1786249770.0629
            [end] => 1786249770.0635
            [time] => 0.00065088272094727
        )

    [2] => Array
        (
            [query] => select time,closed from match_time where match_id = '3217'
            [start] => 1786249770.0635
            [end] => 1786249770.0717
            [time] => 0.0081958770751953
        )

    [3] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3217'
            [start] => 1786249770.0719
            [end] => 1786249770.1094
            [time] => 0.037560939788818
        )

    [4] => Array
        (
            [query] => select time,closed from match_time where match_id = '3217'
            [start] => 1786249770.1098
            [end] => 1786249770.1207
            [time] => 0.010928153991699
        )

    [5] => Array
        (
            [query] => select * from matches where match_id = '3217'
            [start] => 1786249770.1208
            [end] => 1786249770.1229
            [time] => 0.0020580291748047
        )

    [6] => Array
        (
            [query] => select time,closed from match_time where match_id = '3217'
            [start] => 1786249770.1229
            [end] => 1786249770.1273
            [time] => 0.0044128894805908
        )

    [7] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3217'
            [start] => 1786249770.1274
            [end] => 1786249770.178
            [time] => 0.050552129745483
        )

    [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 (49,25) ORDER BY lastname,firstname ASC
            [start] => 1786249770.1784
            [end] => 1786249770.1799
            [time] => 0.0014979839324951
        )

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

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

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

    [12] => Array
        (
            [query] => select * from matches where match_id = '3217'
            [start] => 1786249770.19
            [end] => 1786249770.1903
            [time] => 0.00023412704467773
        )

    [13] => Array
        (
            [query] => select time,closed from match_time where match_id = '3217'
            [start] => 1786249770.1903
            [end] => 1786249770.2001
            [time] => 0.0098068714141846
        )

    [14] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3217'
            [start] => 1786249770.2002
            [end] => 1786249770.2379
            [time] => 0.037783145904541
        )

    [15] => Array
        (
            [query] => select * from match_roster where match_id = '3217'
            [start] => 1786249770.2382
            [end] => 1786249770.2738
            [time] => 0.035554885864258
        )

    [16] => Array
        (
            [query] => select * from matches where match_id = '3217'
            [start] => 1786249770.2739
            [end] => 1786249770.2789
            [time] => 0.0049939155578613
        )

    [17] => Array
        (
            [query] => select time,closed from match_time where match_id = '3217'
            [start] => 1786249770.2789
            [end] => 1786249770.2873
            [time] => 0.0083987712860107
        )

    [18] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3217'
            [start] => 1786249770.2874
            [end] => 1786249770.3395
            [time] => 0.052139043807983
        )

    [19] => Array
        (
            [query] => select point.*, penalty.cumulative from point 
                inner join penalty on (point.penalty_id = penalty.penalty_id)
                where point.match_id = '3217' and (point.point = 'P' or point.point = 'E')
            [start] => 1786249770.344
            [end] => 1786249770.7806
            [time] => 0.436527967453
        )

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

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

    [22] => Array
        (
            [query] => select * from matches where match_id = '3217'
            [start] => 1786249770.7868
            [end] => 1786249770.7929
            [time] => 0.0060751438140869
        )

    [23] => Array
        (
            [query] => select time,closed from match_time where match_id = '3217'
            [start] => 1786249770.7929
            [end] => 1786249770.7993
            [time] => 0.0064239501953125
        )

    [24] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3217'
            [start] => 1786249770.7994
            [end] => 1786249770.8678
            [time] => 0.068379163742065
        )

    [25] => Array
        (
            [query] => select * from match_roster where match_id = '3217'
            [start] => 1786249770.868
            [end] => 1786249770.9078
            [time] => 0.039785146713257
        )

    [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 = '3217' group by player_id
        
            [start] => 1786249770.9079
            [end] => 1786249771.1532
            [time] => 0.24529790878296
        )

    [27] => Array
        (
            [query] => select * from penalty_to_team where match_id = '3217'
            [start] => 1786249771.1533
            [end] => 1786249771.156
            [time] => 0.0026810169219971
        )

    [28] => Array
        (
            [query] => select * from matches where match_id = '3217'
            [start] => 1786249771.1561
            [end] => 1786249771.1563
            [time] => 0.00021791458129883
        )

    [29] => Array
        (
            [query] => select time,closed from match_time where match_id = '3217'
            [start] => 1786249771.1563
            [end] => 1786249771.1731
            [time] => 0.016758918762207
        )

    [30] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3217'
            [start] => 1786249771.1731
            [end] => 1786249771.2331
            [time] => 0.059947967529297
        )

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

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

    [33] => Array
        (
            [query] => select * from matches where match_id = '3217'
            [start] => 1786249771.2385
            [end] => 1786249771.2388
            [time] => 0.00028610229492188
        )

    [34] => Array
        (
            [query] => select time,closed from match_time where match_id = '3217'
            [start] => 1786249771.2388
            [end] => 1786249771.2532
            [time] => 0.014395952224731
        )

    [35] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3217'
            [start] => 1786249771.2533
            [end] => 1786249771.3145
            [time] => 0.061223030090332
        )

    [36] => Array
        (
            [query] => select * from match_staff_roster where match_id = '3217'
            [start] => 1786249771.3148
            [end] => 1786249771.3227
            [time] => 0.0079398155212402
        )

    [37] => Array
        (
            [query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
            [start] => 1786249771.3229
            [end] => 1786249771.3254
            [time] => 0.0025010108947754
        )

    [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 = '3217' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
            [start] => 1786249771.3254
            [end] => 1786249771.3258
            [time] => 0.00032711029052734
        )

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

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

    [41] => Array
        (
            [query] => select * from matches where match_id = '3217'
            [start] => 1786249771.3265
            [end] => 1786249771.3268
            [time] => 0.00025486946105957
        )

    [42] => Array
        (
            [query] => select time,closed from match_time where match_id = '3217'
            [start] => 1786249771.3268
            [end] => 1786249771.3371
            [time] => 0.010327100753784
        )

    [43] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3217'
            [start] => 1786249771.3372
            [end] => 1786249771.3993
            [time] => 0.062090158462524
        )

    [44] => Array
        (
            [query] => select * from matches where match_id = '3217'
            [start] => 1786249771.3996
            [end] => 1786249771.404
            [time] => 0.0043489933013916
        )

    [45] => Array
        (
            [query] => select time,closed from match_time where match_id = '3217'
            [start] => 1786249771.404
            [end] => 1786249771.4178
            [time] => 0.013788938522339
        )

    [46] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3217'
            [start] => 1786249771.4179
            [end] => 1786249771.4799
            [time] => 0.061990976333618
        )

    [47] => Array
        (
            [query] => select * from match_roster where match_id = '3217'
            [start] => 1786249771.4802
            [end] => 1786249771.5189
            [time] => 0.038721084594727
        )

    [48] => Array
        (
            [query] => select * from point where match_id = '3217' order by point_id ASC
            [start] => 1786249771.5189
            [end] => 1786249771.8325
            [time] => 0.31359815597534
        )

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

    [50] => Array
        (
            [query] => select * from matches where match_id = '3217'
            [start] => 1786249771.838
            [end] => 1786249771.8399
            [time] => 0.0018291473388672
        )

    [51] => Array
        (
            [query] => select time,closed from match_time where match_id = '3217'
            [start] => 1786249771.8399
            [end] => 1786249771.8483
            [time] => 0.0084540843963623
        )

    [52] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3217'
            [start] => 1786249771.8484
            [end] => 1786249771.8848
            [time] => 0.036420822143555
        )

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

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

)