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

Venaria

Partite Da Giocare

Partite Giocate

                Total Queries: 29
        Total Time: 0.46637463569641
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1770959598.8034
            [end] => 1770959598.8037
            [time] => 0.0003201961517334
        )

    [1] => Array
        (
            [query] => select * from location where location_id = '10'
            [start] => 1770959598.8054
            [end] => 1770959598.8057
            [time] => 0.00033903121948242
        )

    [2] => Array
        (
            [query] => select * from matches where date >= '1770937200' AND location_id = '10' ORDER BY
            case when date in('', '0') then 9999999999999999999999 else date end ASC, 
            round_id+0, 
            case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end 
            ASC LIMIT 0,5
            [start] => 1770959598.806
            [end] => 1770959598.8088
            [time] => 0.0028071403503418
        )

    [3] => Array
        (
            [query] => select * from match_time where match_id in (4193,4284,4289,4297,4220) order by id ASC
            [start] => 1770959598.8088
            [end] => 1770959598.8115
            [time] => 0.0026659965515137
        )

    [4] => Array
        (
            [query] => SELECT * FROM match_data where match_id IN (4193,4284,4289,4297,4220)
            [start] => 1770959598.8116
            [end] => 1770959598.8236
            [time] => 0.012028932571411
        )

    [5] => Array
        (
            [query] => select * from matches where date <= '1770937200' AND match_id IN (select match_id from match_time where closed != '0' group by match_id) AND match_id NOT IN (select match_id from match_time where closed = '0' group by match_id) AND location_id = '10' ORDER BY 
            case when date in('', '0') then 9999999999999999999999 else date end DESC,  
            round_id+0 
            DESC LIMIT 0,5
            [start] => 1770959598.8249
            [end] => 1770959598.8325
            [time] => 0.0076160430908203
        )

    [6] => Array
        (
            [query] => select * from match_time where match_id in (4278,4272,4181,4171,4167) order by id ASC
            [start] => 1770959598.8325
            [end] => 1770959598.8352
            [time] => 0.0026390552520752
        )

    [7] => Array
        (
            [query] => select time from match_time where match_id = '4278'
            [start] => 1770959598.836
            [end] => 1770959598.8379
            [time] => 0.0018877983093262
        )

    [8] => Array
        (
            [query] => SELECT 
        COALESCE(
            SUM(
            CASE 
            WHEN team_id = '47' THEN point 
            WHEN (team_id = '12' AND point = 'A') THEN 1 
            END) 
        ,0) as home_team_score,
        
        COALESCE(
            SUM(
            CASE 
            WHEN team_id = '12' THEN point 
            WHEN (team_id = '47' AND point = 'A') THEN 1 
            END )
        ,0) as visitor_team_score,
        time
        FROM point where match_id = '4278' group by time
            [start] => 1770959598.8379
            [end] => 1770959598.8838
            [time] => 0.045876026153564
        )

    [9] => Array
        (
            [query] => SELECT 
        COALESCE(
            SUM(
            CASE 
            WHEN (team_id = '47' AND point = 'I') THEN 1 
            END) 
        ,0) as home_team_invasions,
        
        COALESCE(
            SUM(
            CASE 
            WHEN (team_id = '12' AND point = 'I') THEN 1 
            END )
        ,0) as visitor_team_invasions
        FROM point where match_id = '4278'
            [start] => 1770959598.8839
            [end] => 1770959598.9209
            [time] => 0.037023782730103
        )

    [10] => Array
        (
            [query] => select time from match_time where match_id = '4272'
            [start] => 1770959598.9229
            [end] => 1770959598.9248
            [time] => 0.0019221305847168
        )

    [11] => Array
        (
            [query] => SELECT 
        COALESCE(
            SUM(
            CASE 
            WHEN team_id = '47' THEN point 
            WHEN (team_id = '56' AND point = 'A') THEN 1 
            END) 
        ,0) as home_team_score,
        
        COALESCE(
            SUM(
            CASE 
            WHEN team_id = '56' THEN point 
            WHEN (team_id = '47' AND point = 'A') THEN 1 
            END )
        ,0) as visitor_team_score,
        time
        FROM point where match_id = '4272' group by time
            [start] => 1770959598.9248
            [end] => 1770959598.971
            [time] => 0.046140909194946
        )

    [12] => Array
        (
            [query] => SELECT 
        COALESCE(
            SUM(
            CASE 
            WHEN (team_id = '47' AND point = 'I') THEN 1 
            END) 
        ,0) as home_team_invasions,
        
        COALESCE(
            SUM(
            CASE 
            WHEN (team_id = '56' AND point = 'I') THEN 1 
            END )
        ,0) as visitor_team_invasions
        FROM point where match_id = '4272'
            [start] => 1770959598.971
            [end] => 1770959599.0079
            [time] => 0.03688907623291
        )

    [13] => Array
        (
            [query] => select time from match_time where match_id = '4181'
            [start] => 1770959599.0096
            [end] => 1770959599.0116
            [time] => 0.0019848346710205
        )

    [14] => Array
        (
            [query] => SELECT 
        COALESCE(
            SUM(
            CASE 
            WHEN team_id = '14' THEN point 
            WHEN (team_id = '37' AND point = 'A') THEN 1 
            END) 
        ,0) as home_team_score,
        
        COALESCE(
            SUM(
            CASE 
            WHEN team_id = '37' THEN point 
            WHEN (team_id = '14' AND point = 'A') THEN 1 
            END )
        ,0) as visitor_team_score,
        time
        FROM point where match_id = '4181' group by time
            [start] => 1770959599.0116
            [end] => 1770959599.0573
            [time] => 0.045680999755859
        )

    [15] => Array
        (
            [query] => SELECT 
        COALESCE(
            SUM(
            CASE 
            WHEN (team_id = '14' AND point = 'I') THEN 1 
            END) 
        ,0) as home_team_invasions,
        
        COALESCE(
            SUM(
            CASE 
            WHEN (team_id = '37' AND point = 'I') THEN 1 
            END )
        ,0) as visitor_team_invasions
        FROM point where match_id = '4181'
            [start] => 1770959599.0573
            [end] => 1770959599.0943
            [time] => 0.036938905715942
        )

    [16] => Array
        (
            [query] => select time from match_time where match_id = '4171'
            [start] => 1770959599.096
            [end] => 1770959599.098
            [time] => 0.0019230842590332
        )

    [17] => Array
        (
            [query] => SELECT 
        COALESCE(
            SUM(
            CASE 
            WHEN team_id = '14' THEN point 
            WHEN (team_id = '39' AND point = 'A') THEN 1 
            END) 
        ,0) as home_team_score,
        
        COALESCE(
            SUM(
            CASE 
            WHEN team_id = '39' THEN point 
            WHEN (team_id = '14' AND point = 'A') THEN 1 
            END )
        ,0) as visitor_team_score,
        time
        FROM point where match_id = '4171' group by time
            [start] => 1770959599.098
            [end] => 1770959599.144
            [time] => 0.04601001739502
        )

    [18] => Array
        (
            [query] => SELECT 
        COALESCE(
            SUM(
            CASE 
            WHEN (team_id = '14' AND point = 'I') THEN 1 
            END) 
        ,0) as home_team_invasions,
        
        COALESCE(
            SUM(
            CASE 
            WHEN (team_id = '39' AND point = 'I') THEN 1 
            END )
        ,0) as visitor_team_invasions
        FROM point where match_id = '4171'
            [start] => 1770959599.144
            [end] => 1770959599.1811
            [time] => 0.037010192871094
        )

    [19] => Array
        (
            [query] => select time from match_time where match_id = '4167'
            [start] => 1770959599.1829
            [end] => 1770959599.1848
            [time] => 0.00193190574646
        )

    [20] => Array
        (
            [query] => SELECT 
        COALESCE(
            SUM(
            CASE 
            WHEN team_id = '14' THEN point 
            WHEN (team_id = '6' AND point = 'A') THEN 1 
            END) 
        ,0) as home_team_score,
        
        COALESCE(
            SUM(
            CASE 
            WHEN team_id = '6' THEN point 
            WHEN (team_id = '14' AND point = 'A') THEN 1 
            END )
        ,0) as visitor_team_score,
        time
        FROM point where match_id = '4167' group by time
            [start] => 1770959599.1848
            [end] => 1770959599.2306
            [time] => 0.045821905136108
        )

    [21] => Array
        (
            [query] => SELECT 
        COALESCE(
            SUM(
            CASE 
            WHEN (team_id = '14' AND point = 'I') THEN 1 
            END) 
        ,0) as home_team_invasions,
        
        COALESCE(
            SUM(
            CASE 
            WHEN (team_id = '6' AND point = 'I') THEN 1 
            END )
        ,0) as visitor_team_invasions
        FROM point where match_id = '4167'
            [start] => 1770959599.2307
            [end] => 1770959599.2676
            [time] => 0.036931991577148
        )

    [22] => Array
        (
            [query] => SELECT * FROM match_data where match_id IN (4278,4272,4181,4171,4167)
            [start] => 1770959599.2686
            [end] => 1770959599.2807
            [time] => 0.012102842330933
        )

    [23] => Array
        (
            [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
            [start] => 1770959599.2822
            [end] => 1770959599.2826
            [time] => 0.00042104721069336
        )

    [24] => Array
        (
            [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
            [start] => 1770959599.283
            [end] => 1770959599.2833
            [time] => 0.00022196769714355
        )

    [25] => Array
        (
            [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
            [start] => 1770959599.2843
            [end] => 1770959599.2847
            [time] => 0.00040602684020996
        )

    [26] => Array
        (
            [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
            [start] => 1770959599.2851
            [end] => 1770959599.2853
            [time] => 0.00026679039001465
        )

    [27] => Array
        (
            [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
            [start] => 1770959599.2878
            [end] => 1770959599.2882
            [time] => 0.00037002563476562
        )

    [28] => Array
        (
            [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
            [start] => 1770959599.2889
            [end] => 1770959599.2891
            [time] => 0.00019598007202148
        )

)