DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
Total Queries: 11
Total Time: 0.033995151519775
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1781159470.1155
[end] => 1781159470.1158
[time] => 0.00027108192443848
)
[1] => Array
(
[query] => select * from referee where referee_id = '4'
[start] => 1781159470.1175
[end] => 1781159470.1178
[time] => 0.00029897689819336
)
[2] => Array
(
[query] => select * from matches where (first_referee_id = '4' OR second_referee_id = '4' OR third_referee_id = '4') 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) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1781159470.1182
[end] => 1781159470.1272
[time] => 0.0090789794921875
)
[3] => Array
(
[query] => select * from match_time where match_id in (2268,3924,2265,2252,2253,2255,2256,3352,2262,2263,3943,1905,2618,2621,2438,3514,3748,3958,4595,2086,2060,2188,2202,2284,2285,2286,2283,2849,3962,1908,2182,2146,2145,2091,2044,2290,2541,2452,2983,2982,3896,1940,2070,2543,2294,3436,4604,1884,1932,2200,2203,2459,2297,2635,2636,2991,2990,3771,2127,2112,2638,2465,2640,2555,3447,4163,2310,2308,2642,2643,2471,3003,3000,3452,4166,2055,2084,2566,2648,2646,2647,2011,1992,2053,2040,1933,1942,2652,3275,2206,2117,2080,1950,2048,2325,2323,2324,2574,2483,2041,2059,1959,1903,2580,2659,2661,3283,3112,2665,2662,2497,2496,4012,2500,2666,2175,2184,2078,2344,2343,2595,2671,2672,2505,2109,1893,2517,2169,2142,2152,2365,2362,2614) order by id ASC
[start] => 1781159470.1282
[end] => 1781159470.1321
[time] => 0.0039608478546143
)
[4] => Array
(
[query] => select * from matches where (first_referee_id = '4' OR second_referee_id = '4' OR third_referee_id = '4') AND date >= '1756677600' AND date <= '1788213599' ORDER BY
case when date in('', '0') then 9999999999999999999999 else date end DESC,
round_id+0
DESC
[start] => 1781159470.1329
[end] => 1781159470.1358
[time] => 0.0028860569000244
)
[5] => Array
(
[query] => select * from match_time where match_id in (4604,4595,4012,3958,4163,4166,3962) order by id ASC
[start] => 1781159470.1359
[end] => 1781159470.139
[time] => 0.003101110458374
)
[6] => Array
(
[query] => SELECT * FROM match_data where match_id IN (4604,4595,4012,3958,4163,4166,3962)
[start] => 1781159470.153
[end] => 1781159470.166
[time] => 0.013002157211304
)
[7] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1781159470.1681
[end] => 1781159470.1685
[time] => 0.00046396255493164
)
[8] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1781159470.169
[end] => 1781159470.1692
[time] => 0.00026702880859375
)
[9] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1781159470.173
[end] => 1781159470.1734
[time] => 0.00042295455932617
)
[10] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1781159470.1742
[end] => 1781159470.1745
[time] => 0.00024199485778809
)
)
Smaronne
Sapore di Mara
Piccolo Club
Lab To Hit
Pellegrini Venaria
Sheet
Red Devils