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

Marco Virgilio

Marco Virgilio

Sunknights
Marco Virgilio

Statistiche Globali


485

Punti Totali

8.98

Media Punti/Partita

187

Hit x2

37

Hit x3

17%

% Hit x3

1

Autohit

54

Presenze

2

Ammonizioni

0

Espulsioni

Dati Storici


Squadre in cui ha militato

                Total Queries: 20
        Total Time: 0.49148106575012
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1770971455.3315
            [end] => 1770971455.3319
            [time] => 0.0003669261932373
        )

    [1] => 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 player.player_id = '140' ORDER BY lastname,firstname ASC
            [start] => 1770971455.3339
            [end] => 1770971455.3346
            [time] => 0.00069689750671387
        )

    [2] => Array
        (
            [query] => select team.*,team_to_club.club_id,team_to_club.start,team_to_club.end from team
        left join team_to_club on (team.team_id = team_to_club.team_id) where deleted = '0' AND (start = 0 OR start <= 1770971455 OR start >= 1770971455) AND (end >= 1770971455 OR end = 0) AND (start < 1770971455) ORDER BY name ASC
            [start] => 1770971455.335
            [end] => 1770971455.3359
            [time] => 0.00089192390441895
        )

    [3] => Array
        (
            [query] => select * from player_to_team WHERE player_id = '140'
            [start] => 1770971455.3361
            [end] => 1770971455.3366
            [time] => 0.00051403045654297
        )

    [4] => Array
        (
            [query] => select * from matches where (home_team_id = '21' OR visitor_team_id = '21') AND date <= '1697128989' ORDER BY 
        case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end, 
        round_id+0,
        date+0,
        match_id 
        ASC LIMIT 0,1
            [start] => 1770971455.3369
            [end] => 1770971455.3397
            [time] => 0.0027680397033691
        )

    [5] => Array
        (
            [query] => select * from match_time where match_id in (2239) order by id ASC
            [start] => 1770971455.3397
            [end] => 1770971455.3424
            [time] => 0.002669095993042
        )

    [6] => Array
        (
            [query] => SELECT * FROM match_data where match_id IN (2239)
            [start] => 1770971455.3425
            [end] => 1770971455.3567
            [time] => 0.014163017272949
        )

    [7] => Array
        (
            [query] => select * from matches where (home_team_id = '22' OR visitor_team_id = '22') AND date >= '1697129975' AND date <= '1727096827' ORDER BY 
        case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end, 
        round_id+0,
        date+0,
        match_id 
        ASC LIMIT 0,1
            [start] => 1770971455.3571
            [end] => 1770971455.3624
            [time] => 0.0052320957183838
        )

    [8] => Array
        (
            [query] => select * from match_time where match_id in (3332) order by id ASC
            [start] => 1770971455.3624
            [end] => 1770971455.3697
            [time] => 0.0073080062866211
        )

    [9] => Array
        (
            [query] => SELECT * FROM match_data where match_id IN (3332)
            [start] => 1770971455.3698
            [end] => 1770971455.3884
            [time] => 0.018588066101074
        )

    [10] => Array
        (
            [query] => select team.*,team_to_club.club_id,team_to_club.start,team_to_club.end from team
        left join team_to_club on (team.team_id = team_to_club.team_id) where team.team_id = '22' AND deleted = '0' AND (start = 0 OR start <= 1770971455 OR start >= 1770971455) AND (end >= 1770971455 OR end = 0) AND (start < 1770971455) ORDER BY name ASC
            [start] => 1770971455.3888
            [end] => 1770971455.3892
            [time] => 0.00041794776916504
        )

    [11] => 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 team_id = '22' AND end = '0' AND deleted = '0' ORDER BY number+0 ASC
            [start] => 1770971455.3894
            [end] => 1770971455.3901
            [time] => 0.00072193145751953
        )

    [12] => Array
        (
            [query] => SELECT player_id, COUNT(player_id) as attendance FROM match_roster LEFT JOIN matches ON (match_roster.match_id = matches.match_id)  where player_id = '140' AND match_roster.match_id NOT IN (select match_id from matches where championship_id IN (select championship_id from championship where show_player_ranking = '0')) GROUP BY player_id
            [start] => 1770971455.3905
            [end] => 1770971455.4057
            [time] => 0.015264987945557
        )

    [13] => Array
        (
            [query] => SELECT player_id,  
        SUM(
            CASE 
              WHEN point != 'A' THEN point  
            END 
        ) as total,
        
        SUM(
            CASE 
              WHEN point = 'A' THEN 1 
              WHEN point != 'A' THEN 0 
            END 
        ) as autohit,
    
        SUM(
            CASE 
              WHEN point = '3' THEN 1
              WHEN point != '3' THEN 0  
            END 
        ) as defense,
    
        SUM(
            CASE 
              WHEN point = '2' THEN 1 
              WHEN point != '2' THEN 0 
            END 
        ) as attack,
            
        SUM(
            CASE 
              WHEN point = 'P' THEN 1 
              WHEN point != 'P' THEN 0 
            END 
        ) as admonitions,
        
        SUM(
            CASE 
              WHEN point = 'E' THEN 1 
              WHEN point != 'E' THEN 0 
            END 
        ) as expulsions
                
        FROM point 
        LEFT JOIN matches ON (point.match_id = matches.match_id) where player_id = '140' AND point.match_id NOT IN (select match_id from matches where championship_id IN (select championship_id from championship where show_player_ranking = '0')) GROUP BY point.player_id 
            [start] => 1770971455.4058
            [end] => 1770971455.4943
            [time] => 0.088521003723145
        )

    [14] => Array
        (
            [query] => SELECT player_id, COUNT(player_id) as attendance, CASE 
              WHEN from_unixtime(matches.date, "%Y-%m-%d %H:%i") <= CONCAT(from_unixtime(matches.date, "%Y"), "-08-31" , '23:59:59') THEN CONCAT(from_unixtime(matches.date, "%Y")-1, '-', from_unixtime(matches.date, "%Y"))
              ELSE CONCAT(from_unixtime(matches.date, "%Y"), '-', from_unixtime(matches.date, "%Y")+1)
            END as period  FROM match_roster LEFT JOIN matches ON (match_roster.match_id = matches.match_id)  where player_id = '140' AND team_id = '21' AND match_roster.match_id NOT IN (select match_id from matches where championship_id IN (select championship_id from championship where show_player_ranking = '0')) GROUP BY player_id, period
            [start] => 1770971455.4945
            [end] => 1770971455.5157
            [time] => 0.021198987960815
        )

    [15] => Array
        (
            [query] => SELECT player_id, CASE 
              WHEN from_unixtime(matches.date, "%Y-%m-%d %H:%i") <= CONCAT(from_unixtime(matches.date, "%Y"), "-08-31" , '23:59:59') THEN CONCAT(from_unixtime(matches.date, "%Y")-1, '-', from_unixtime(matches.date, "%Y"))
              ELSE CONCAT(from_unixtime(matches.date, "%Y"), '-', from_unixtime(matches.date, "%Y")+1)
            END as period,  
        SUM(
            CASE 
              WHEN point != 'A' THEN point  
            END 
        ) as total,
        
        SUM(
            CASE 
              WHEN point = 'A' THEN 1 
              WHEN point != 'A' THEN 0 
            END 
        ) as autohit,
    
        SUM(
            CASE 
              WHEN point = '3' THEN 1
              WHEN point != '3' THEN 0  
            END 
        ) as defense,
    
        SUM(
            CASE 
              WHEN point = '2' THEN 1 
              WHEN point != '2' THEN 0 
            END 
        ) as attack,
            
        SUM(
            CASE 
              WHEN point = 'P' THEN 1 
              WHEN point != 'P' THEN 0 
            END 
        ) as admonitions,
        
        SUM(
            CASE 
              WHEN point = 'E' THEN 1 
              WHEN point != 'E' THEN 0 
            END 
        ) as expulsions
                
        FROM point 
        LEFT JOIN matches ON (point.match_id = matches.match_id) where player_id = '140' AND point.match_id NOT IN (select match_id from matches where championship_id IN (select championship_id from championship where show_player_ranking = '0')) AND team_id = '21' GROUP BY point.player_id, period  ORDER BY period ASC; 
            [start] => 1770971455.5157
            [end] => 1770971455.6783
            [time] => 0.16254496574402
        )

    [16] => Array
        (
            [query] => SELECT player_id, COUNT(player_id) as attendance, CASE 
              WHEN from_unixtime(matches.date, "%Y-%m-%d %H:%i") <= CONCAT(from_unixtime(matches.date, "%Y"), "-08-31" , '23:59:59') THEN CONCAT(from_unixtime(matches.date, "%Y")-1, '-', from_unixtime(matches.date, "%Y"))
              ELSE CONCAT(from_unixtime(matches.date, "%Y"), '-', from_unixtime(matches.date, "%Y")+1)
            END as period  FROM match_roster LEFT JOIN matches ON (match_roster.match_id = matches.match_id)  where player_id = '140' AND team_id = '22' AND match_roster.match_id NOT IN (select match_id from matches where championship_id IN (select championship_id from championship where show_player_ranking = '0')) GROUP BY player_id, period
            [start] => 1770971455.6784
            [end] => 1770971455.7064
            [time] => 0.027987957000732
        )

    [17] => Array
        (
            [query] => SELECT player_id, CASE 
              WHEN from_unixtime(matches.date, "%Y-%m-%d %H:%i") <= CONCAT(from_unixtime(matches.date, "%Y"), "-08-31" , '23:59:59') THEN CONCAT(from_unixtime(matches.date, "%Y")-1, '-', from_unixtime(matches.date, "%Y"))
              ELSE CONCAT(from_unixtime(matches.date, "%Y"), '-', from_unixtime(matches.date, "%Y")+1)
            END as period,  
        SUM(
            CASE 
              WHEN point != 'A' THEN point  
            END 
        ) as total,
        
        SUM(
            CASE 
              WHEN point = 'A' THEN 1 
              WHEN point != 'A' THEN 0 
            END 
        ) as autohit,
    
        SUM(
            CASE 
              WHEN point = '3' THEN 1
              WHEN point != '3' THEN 0  
            END 
        ) as defense,
    
        SUM(
            CASE 
              WHEN point = '2' THEN 1 
              WHEN point != '2' THEN 0 
            END 
        ) as attack,
            
        SUM(
            CASE 
              WHEN point = 'P' THEN 1 
              WHEN point != 'P' THEN 0 
            END 
        ) as admonitions,
        
        SUM(
            CASE 
              WHEN point = 'E' THEN 1 
              WHEN point != 'E' THEN 0 
            END 
        ) as expulsions
                
        FROM point 
        LEFT JOIN matches ON (point.match_id = matches.match_id) where player_id = '140' AND point.match_id NOT IN (select match_id from matches where championship_id IN (select championship_id from championship where show_player_ranking = '0')) AND team_id = '22' GROUP BY point.player_id, period  ORDER BY period ASC; 
            [start] => 1770971455.7065
            [end] => 1770971455.8244
            [time] => 0.11795020103455
        )

    [18] => Array
        (
            [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
            [start] => 1770971455.8265
            [end] => 1770971455.8298
            [time] => 0.0033419132232666
        )

    [19] => Array
        (
            [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
            [start] => 1770971455.8306
            [end] => 1770971455.831
            [time] => 0.00033307075500488
        )

)