DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG

Referto Partita: Spartak vs Kebbabheat

Referto Partita: Spartak vs Kebbabheat

Spartak

Spartak

Kebbabheat

Kebbabheat

RISULTATO FINALE

90

41

1° Tempo

28

14

2° Tempo

33

19

3° Tempo

29

8

INVASIONI A MURO

0

0

Data e Luogo


Campionato Torneo Open Finali B
Giornata: 2
Data e Luogo 16-02-2025 10:45 - Frassati

Arbitri


Primo Arbitro Torneo Open Arbitro
Refertista ASD Sinombre

Sorteggio


Sorteggio Vinto Da Spartak
Scelta Sorteggio Palla

Progresso

                Total Queries: 55
        Total Time: 1.4548029899597
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1776072938.0627
            [end] => 1776072938.0649
            [time] => 0.0022032260894775
        )

    [1] => Array
        (
            [query] => select * from matches where match_id = '3859'
            [start] => 1776072938.0671
            [end] => 1776072938.0674
            [time] => 0.00026416778564453
        )

    [2] => Array
        (
            [query] => select time,closed from match_time where match_id = '3859'
            [start] => 1776072938.0674
            [end] => 1776072938.0733
            [time] => 0.0058648586273193
        )

    [3] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3859'
            [start] => 1776072938.0734
            [end] => 1776072938.1272
            [time] => 0.053821802139282
        )

    [4] => Array
        (
            [query] => select time,closed from match_time where match_id = '3859'
            [start] => 1776072938.1276
            [end] => 1776072938.1368
            [time] => 0.0092458724975586
        )

    [5] => Array
        (
            [query] => select * from matches where match_id = '3859'
            [start] => 1776072938.137
            [end] => 1776072938.1409
            [time] => 0.00394606590271
        )

    [6] => Array
        (
            [query] => select time,closed from match_time where match_id = '3859'
            [start] => 1776072938.1409
            [end] => 1776072938.149
            [time] => 0.008126974105835
        )

    [7] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3859'
            [start] => 1776072938.1491
            [end] => 1776072938.2126
            [time] => 0.063486099243164
        )

    [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 (60,59) ORDER BY lastname,firstname ASC
            [start] => 1776072938.2131
            [end] => 1776072938.2173
            [time] => 0.0042030811309814
        )

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

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

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

    [12] => Array
        (
            [query] => select * from matches where match_id = '3859'
            [start] => 1776072938.2321
            [end] => 1776072938.2323
            [time] => 0.0002291202545166
        )

    [13] => Array
        (
            [query] => select time,closed from match_time where match_id = '3859'
            [start] => 1776072938.2323
            [end] => 1776072938.2445
            [time] => 0.012146949768066
        )

    [14] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3859'
            [start] => 1776072938.2445
            [end] => 1776072938.3317
            [time] => 0.08716893196106
        )

    [15] => Array
        (
            [query] => select * from match_roster where match_id = '3859'
            [start] => 1776072938.332
            [end] => 1776072938.379
            [time] => 0.046972036361694
        )

    [16] => Array
        (
            [query] => select * from matches where match_id = '3859'
            [start] => 1776072938.3791
            [end] => 1776072938.3793
            [time] => 0.00023794174194336
        )

    [17] => Array
        (
            [query] => select time,closed from match_time where match_id = '3859'
            [start] => 1776072938.3794
            [end] => 1776072938.3915
            [time] => 0.012156963348389
        )

    [18] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3859'
            [start] => 1776072938.3916
            [end] => 1776072938.4637
            [time] => 0.072095155715942
        )

    [19] => Array
        (
            [query] => select point.*, penalty.cumulative from point 
                inner join penalty on (point.penalty_id = penalty.penalty_id)
                where point.match_id = '3859' and (point.point = 'P' or point.point = 'E')
            [start] => 1776072938.4669
            [end] => 1776072938.7618
            [time] => 0.29487013816833
        )

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

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

    [22] => Array
        (
            [query] => select * from matches where match_id = '3859'
            [start] => 1776072938.7625
            [end] => 1776072938.7628
            [time] => 0.00022506713867188
        )

    [23] => Array
        (
            [query] => select time,closed from match_time where match_id = '3859'
            [start] => 1776072938.7628
            [end] => 1776072938.7738
            [time] => 0.011008977890015
        )

    [24] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3859'
            [start] => 1776072938.7739
            [end] => 1776072938.8326
            [time] => 0.058710813522339
        )

    [25] => Array
        (
            [query] => select * from match_roster where match_id = '3859'
            [start] => 1776072938.8329
            [end] => 1776072938.8661
            [time] => 0.033255100250244
        )

    [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 = '3859' group by player_id
        
            [start] => 1776072938.8662
            [end] => 1776072939.0925
            [time] => 0.22630906105042
        )

    [27] => Array
        (
            [query] => select * from penalty_to_team where match_id = '3859'
            [start] => 1776072939.0927
            [end] => 1776072939.095
            [time] => 0.0023150444030762
        )

    [28] => Array
        (
            [query] => select * from matches where match_id = '3859'
            [start] => 1776072939.0951
            [end] => 1776072939.0953
            [time] => 0.0002288818359375
        )

    [29] => Array
        (
            [query] => select time,closed from match_time where match_id = '3859'
            [start] => 1776072939.0953
            [end] => 1776072939.1058
            [time] => 0.010465145111084
        )

    [30] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3859'
            [start] => 1776072939.1059
            [end] => 1776072939.1466
            [time] => 0.040734052658081
        )

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

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

    [33] => Array
        (
            [query] => select * from matches where match_id = '3859'
            [start] => 1776072939.1505
            [end] => 1776072939.1547
            [time] => 0.0042312145233154
        )

    [34] => Array
        (
            [query] => select time,closed from match_time where match_id = '3859'
            [start] => 1776072939.1548
            [end] => 1776072939.1589
            [time] => 0.0041649341583252
        )

    [35] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3859'
            [start] => 1776072939.159
            [end] => 1776072939.1983
            [time] => 0.039315938949585
        )

    [36] => Array
        (
            [query] => select * from match_staff_roster where match_id = '3859'
            [start] => 1776072939.1986
            [end] => 1776072939.1994
            [time] => 0.00082206726074219
        )

    [37] => Array
        (
            [query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
            [start] => 1776072939.1995
            [end] => 1776072939.2019
            [time] => 0.0023181438446045
        )

    [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 = '3859' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
            [start] => 1776072939.2019
            [end] => 1776072939.2021
            [time] => 0.00023102760314941
        )

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

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

    [41] => Array
        (
            [query] => select * from matches where match_id = '3859'
            [start] => 1776072939.2054
            [end] => 1776072939.2056
            [time] => 0.00023198127746582
        )

    [42] => Array
        (
            [query] => select time,closed from match_time where match_id = '3859'
            [start] => 1776072939.2056
            [end] => 1776072939.2101
            [time] => 0.0044929981231689
        )

    [43] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3859'
            [start] => 1776072939.2102
            [end] => 1776072939.2478
            [time] => 0.037562131881714
        )

    [44] => Array
        (
            [query] => select * from matches where match_id = '3859'
            [start] => 1776072939.2481
            [end] => 1776072939.252
            [time] => 0.0039150714874268
        )

    [45] => Array
        (
            [query] => select time,closed from match_time where match_id = '3859'
            [start] => 1776072939.2521
            [end] => 1776072939.2573
            [time] => 0.0052258968353271
        )

    [46] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3859'
            [start] => 1776072939.2574
            [end] => 1776072939.2941
            [time] => 0.036686182022095
        )

    [47] => Array
        (
            [query] => select * from match_roster where match_id = '3859'
            [start] => 1776072939.2944
            [end] => 1776072939.311
            [time] => 0.016674995422363
        )

    [48] => Array
        (
            [query] => select * from point where match_id = '3859' order by point_id ASC
            [start] => 1776072939.3111
            [end] => 1776072939.4972
            [time] => 0.18615007400513
        )

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

    [50] => Array
        (
            [query] => select * from matches where match_id = '3859'
            [start] => 1776072939.5
            [end] => 1776072939.5002
            [time] => 0.00021004676818848
        )

    [51] => Array
        (
            [query] => select time,closed from match_time where match_id = '3859'
            [start] => 1776072939.5002
            [end] => 1776072939.5043
            [time] => 0.0041048526763916
        )

    [52] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3859'
            [start] => 1776072939.5044
            [end] => 1776072939.5304
            [time] => 0.026015043258667
        )

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

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

)