DEBUG - DEBUG - DEBUG

DEBUG - DEBUG - DEBUG

DEBUG - DEBUG - DEBUG

Referto Partita: Levuoiqueikiwi vs Poska

Referto Partita: Levuoiqueikiwi vs Poska

Levuoiqueikiwi

Poska

RISULTATO FINALE

79

19

1° Tempo

28

6

2° Tempo

25

7

3° Tempo

26

6

INVASIONI A MURO

0

1

Data e Luogo

Campionato Torneo Femminile 2025
Giornata: 5

Data e Luogo 03-06-2025 20:45 - Cavour

Arbitri

Primo Arbitro Zanetti Gianluca

Secondo Arbitro Agnelli Filippo

Refertista ASD Polaris

Sorteggio

Sorteggio Vinto Da Levuoiqueikiwi

Scelta Sorteggio Palla

Annotazioni

Refertista: Capitolo Sabrina

Progresso

Punteggi Individuali

Levuoiqueikiwi

Francesca Da Re

Tot.
14

7
x2

0
x3

0
x AUTOHIT
Rebecca Aurigemma

Tot.
8

4
x2

0
x3

0
x AUTOHIT
Arianna Vismara

Tot.
22

8
x2

2
x3

0
x AUTOHIT
Sabrina Zanfretta

Tot.
10

5
x2

0
x3

0
x AUTOHIT
Martina Bracesco

Tot.
12

6
x2

0
x3

0
x AUTOHIT
Veronica Beria

Tot.
12

6
x2

0
x3

0
x AUTOHIT

Poska

Angelica Maria Bonomi

2
x2

0
x3

0
x AUTOHIT

Tot.
4
Ginevra Pala

2
x2

0
x3

0
x AUTOHIT

Tot.
4
Nina Quaranta

0
x2

1
x3

0
x AUTOHIT

Tot.
3
Emma Sandretto

0
x2

0
x3

0
x AUTOHIT

Tot.
0
Paola Verardi

3
x2

0
x3

1
x AUTOHIT

Tot.
6
Halima Alabdullah

1
x2

0
x3

0
x AUTOHIT

Tot.
2
Giulia D'alessandro

0
x2

0
x3

0
x AUTOHIT

Tot.
0

                Total Queries: 55
        Total Time: 1.9851648807526
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1776068010.8086
            [end] => 1776068010.8109
            [time] => 0.0022499561309814
        )

    [1] => Array
        (
            [query] => select * from matches where match_id = '3901'
            [start] => 1776068010.8163
            [end] => 1776068010.818
            [time] => 0.0016059875488281
        )

    [2] => Array
        (
            [query] => select time,closed from match_time where match_id = '3901'
            [start] => 1776068010.818
            [end] => 1776068010.8261
            [time] => 0.0081620216369629
        )

    [3] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3901'
            [start] => 1776068010.8263
            [end] => 1776068010.8828
            [time] => 0.056482076644897
        )

    [4] => Array
        (
            [query] => select time,closed from match_time where match_id = '3901'
            [start] => 1776068010.8831
            [end] => 1776068010.8912
            [time] => 0.0080881118774414
        )

    [5] => Array
        (
            [query] => select * from matches where match_id = '3901'
            [start] => 1776068010.8913
            [end] => 1776068010.8915
            [time] => 0.00022983551025391
        )

    [6] => Array
        (
            [query] => select time,closed from match_time where match_id = '3901'
            [start] => 1776068010.8916
            [end] => 1776068010.8967
            [time] => 0.0051620006561279
        )

    [7] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3901'
            [start] => 1776068010.8968
            [end] => 1776068010.9568
            [time] => 0.059962034225464
        )

    [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 (50,63) ORDER BY lastname,firstname ASC
            [start] => 1776068010.9572
            [end] => 1776068010.9582
            [time] => 0.00096392631530762
        )

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

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

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

    [12] => Array
        (
            [query] => select * from matches where match_id = '3901'
            [start] => 1776068010.9683
            [end] => 1776068010.9699
            [time] => 0.0016288757324219
        )

    [13] => Array
        (
            [query] => select time,closed from match_time where match_id = '3901'
            [start] => 1776068010.9699
            [end] => 1776068010.979
            [time] => 0.0090858936309814
        )

    [14] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3901'
            [start] => 1776068010.9791
            [end] => 1776068011.0405
            [time] => 0.061382055282593
        )

    [15] => Array
        (
            [query] => select * from match_roster where match_id = '3901'
            [start] => 1776068011.0408
            [end] => 1776068011.0701
            [time] => 0.029327154159546
        )

    [16] => Array
        (
            [query] => select * from matches where match_id = '3901'
            [start] => 1776068011.0702
            [end] => 1776068011.0785
            [time] => 0.0082569122314453
        )

    [17] => Array
        (
            [query] => select time,closed from match_time where match_id = '3901'
            [start] => 1776068011.0785
            [end] => 1776068011.0806
            [time] => 0.0021021366119385
        )

    [18] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3901'
            [start] => 1776068011.0807
            [end] => 1776068011.135
            [time] => 0.054277181625366
        )

    [19] => Array
        (
            [query] => select point.*, penalty.cumulative from point 
                inner join penalty on (point.penalty_id = penalty.penalty_id)
                where point.match_id = '3901' and (point.point = 'P' or point.point = 'E')
            [start] => 1776068011.1372
            [end] => 1776068011.5978
            [time] => 0.46059203147888
        )

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

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

    [22] => Array
        (
            [query] => select * from matches where match_id = '3901'
            [start] => 1776068011.6099
            [end] => 1776068011.612
            [time] => 0.002079963684082
        )

    [23] => Array
        (
            [query] => select time,closed from match_time where match_id = '3901'
            [start] => 1776068011.612
            [end] => 1776068011.6177
            [time] => 0.005763053894043
        )

    [24] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3901'
            [start] => 1776068011.6178
            [end] => 1776068011.7234
            [time] => 0.10553407669067
        )

    [25] => Array
        (
            [query] => select * from match_roster where match_id = '3901'
            [start] => 1776068011.7237
            [end] => 1776068011.8012
            [time] => 0.077487945556641
        )

    [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 = '3901' group by player_id
        
            [start] => 1776068011.8012
            [end] => 1776068012.0806
            [time] => 0.27936887741089
        )

    [27] => Array
        (
            [query] => select * from penalty_to_team where match_id = '3901'
            [start] => 1776068012.0808
            [end] => 1776068012.083
            [time] => 0.0022270679473877
        )

    [28] => Array
        (
            [query] => select * from matches where match_id = '3901'
            [start] => 1776068012.0831
            [end] => 1776068012.0835
            [time] => 0.00044894218444824
        )

    [29] => Array
        (
            [query] => select time,closed from match_time where match_id = '3901'
            [start] => 1776068012.0835
            [end] => 1776068012.0867
            [time] => 0.0032289028167725
        )

    [30] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3901'
            [start] => 1776068012.0868
            [end] => 1776068012.1601
            [time] => 0.073337078094482
        )

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

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

    [33] => Array
        (
            [query] => select * from matches where match_id = '3901'
            [start] => 1776068012.1664
            [end] => 1776068012.1679
            [time] => 0.0014898777008057
        )

    [34] => Array
        (
            [query] => select time,closed from match_time where match_id = '3901'
            [start] => 1776068012.168
            [end] => 1776068012.1839
            [time] => 0.015936851501465
        )

    [35] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3901'
            [start] => 1776068012.184
            [end] => 1776068012.2498
            [time] => 0.065790891647339
        )

    [36] => Array
        (
            [query] => select * from match_staff_roster where match_id = '3901'
            [start] => 1776068012.25
            [end] => 1776068012.2585
            [time] => 0.008479118347168
        )

    [37] => Array
        (
            [query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
            [start] => 1776068012.2587
            [end] => 1776068012.2627
            [time] => 0.0040619373321533
        )

    [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 = '3901' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
            [start] => 1776068012.2628
            [end] => 1776068012.2649
            [time] => 0.0021839141845703
        )

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

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

    [41] => Array
        (
            [query] => select * from matches where match_id = '3901'
            [start] => 1776068012.2673
            [end] => 1776068012.2675
            [time] => 0.00021982192993164
        )

    [42] => Array
        (
            [query] => select time,closed from match_time where match_id = '3901'
            [start] => 1776068012.2675
            [end] => 1776068012.2696
            [time] => 0.0020909309387207
        )

    [43] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3901'
            [start] => 1776068012.2697
            [end] => 1776068012.3411
            [time] => 0.071487903594971
        )

    [44] => Array
        (
            [query] => select * from matches where match_id = '3901'
            [start] => 1776068012.3414
            [end] => 1776068012.3449
            [time] => 0.0034661293029785
        )

    [45] => Array
        (
            [query] => select time,closed from match_time where match_id = '3901'
            [start] => 1776068012.3449
            [end] => 1776068012.3508
            [time] => 0.0058400630950928
        )

    [46] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3901'
            [start] => 1776068012.3508
            [end] => 1776068012.4275
            [time] => 0.076694965362549
        )

    [47] => Array
        (
            [query] => select * from match_roster where match_id = '3901'
            [start] => 1776068012.4278
            [end] => 1776068012.4868
            [time] => 0.058990955352783
        )

    [48] => Array
        (
            [query] => select * from point where match_id = '3901' order by point_id ASC
            [start] => 1776068012.4868
            [end] => 1776068012.7408
            [time] => 0.25398802757263
        )

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

    [50] => Array
        (
            [query] => select * from matches where match_id = '3901'
            [start] => 1776068012.7438
            [end] => 1776068012.7441
            [time] => 0.00025582313537598
        )

    [51] => Array
        (
            [query] => select time,closed from match_time where match_id = '3901'
            [start] => 1776068012.7441
            [end] => 1776068012.7552
            [time] => 0.01111102104187
        )

    [52] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3901'
            [start] => 1776068012.7552
            [end] => 1776068012.7976
            [time] => 0.04234504699707
        )

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

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

)