DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
Total Queries: 11
Total Time: 0.034448385238647
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1786252861.3555
[end] => 1786252861.3558
[time] => 0.00030207633972168
)
[1] => Array
(
[query] => select * from referee where referee_id = '4'
[start] => 1786252861.3576
[end] => 1786252861.3579
[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] => 1786252861.3583
[end] => 1786252861.3675
[time] => 0.0092251300811768
)
[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] => 1786252861.3684
[end] => 1786252861.3725
[time] => 0.0041561126708984
)
[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] => 1786252861.3735
[end] => 1786252861.3763
[time] => 0.002871036529541
)
[5] => Array
(
[query] => select * from match_time where match_id in (4604,4595,4012,3958,4163,4166,3962) order by id ASC
[start] => 1786252861.3764
[end] => 1786252861.3795
[time] => 0.0030710697174072
)
[6] => Array
(
[query] => SELECT * FROM match_data where match_id IN (4604,4595,4012,3958,4163,4166,3962)
[start] => 1786252861.3934
[end] => 1786252861.4064
[time] => 0.013033866882324
)
[7] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1786252861.4084
[end] => 1786252861.4089
[time] => 0.00047612190246582
)
[8] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1786252861.4093
[end] => 1786252861.4096
[time] => 0.00029110908508301
)
[9] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1786252861.4132
[end] => 1786252861.4136
[time] => 0.00043797492980957
)
[10] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1786252861.4145
[end] => 1786252861.4148
[time] => 0.00032997131347656
)
)