DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
Total Queries: 11
Total Time: 0.03420090675354
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1781155182.8388
[end] => 1781155182.839
[time] => 0.00027608871459961
)
[1] => Array
(
[query] => select * from referee where referee_id = '4'
[start] => 1781155182.8409
[end] => 1781155182.8411
[time] => 0.00025391578674316
)
[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] => 1781155182.8415
[end] => 1781155182.8508
[time] => 0.009303092956543
)
[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] => 1781155182.8517
[end] => 1781155182.8558
[time] => 0.0040910243988037
)
[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] => 1781155182.8568
[end] => 1781155182.8597
[time] => 0.0028738975524902
)
[5] => Array
(
[query] => select * from match_time where match_id in (4604,4595,4012,3958,4163,4166,3962) order by id ASC
[start] => 1781155182.8598
[end] => 1781155182.8629
[time] => 0.0031108856201172
)
[6] => Array
(
[query] => SELECT * FROM match_data where match_id IN (4604,4595,4012,3958,4163,4166,3962)
[start] => 1781155182.877
[end] => 1781155182.8899
[time] => 0.01292610168457
)
[7] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1781155182.8919
[end] => 1781155182.8924
[time] => 0.00048398971557617
)
[8] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1781155182.8928
[end] => 1781155182.8931
[time] => 0.00026202201843262
)
[9] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1781155182.8967
[end] => 1781155182.8971
[time] => 0.00038290023803711
)
[10] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1781155182.8979
[end] => 1781155182.8982
[time] => 0.00023698806762695
)
)
Smaronne
Sapore di Mara
Piccolo Club
Lab To Hit
Pellegrini Venaria
Sheet
Red Devils