DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
Total Queries: 11
Total Time: 0.031882762908936
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1770978209.1692
[end] => 1770978209.1696
[time] => 0.00037384033203125
)
[1] => Array
(
[query] => select * from referee where referee_id = '16'
[start] => 1770978209.1713
[end] => 1770978209.1717
[time] => 0.00035715103149414
)
[2] => Array
(
[query] => select * from matches where (first_referee_id = '16' OR second_referee_id = '16' OR third_referee_id = '16') 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] => 1770978209.1721
[end] => 1770978209.1803
[time] => 0.0082359313964844
)
[3] => Array
(
[query] => select * from match_time where match_id in (3919,3364,3365,3946,3952,3953,2260,2261,3931,2264,3346,2251,3060,4138,4317,4137,2061,1948,3155,3329,4233,4597,2182,2146,2539,4236,4149,2292,2293,3439,4154,4334,2132,3535,3901,4248,4338,4250,3983,4251,3984,2156,2073,4346,4165,4257,4348,2196,1965,1899,3009,3007,3098,3992,4171,4261,3994,2180,2149,2197,1918,3995,4177,4266,1995,2082,1970,3017,3198,3277,4000,4274,4182,2140,1959,1903,3021,3022,3023,4278,1881,3029,3206,2668,3033,3034,3123,3811,4015,2175,1887,2079,1929,2596,3215,3294,3295,4024,2121,2195,2172,3130,3134,2141,2125,2087,3049,3226,1944,2058,2083,4037,2135,2194,3236,3833) order by id ASC
[start] => 1770978209.1811
[end] => 1770978209.1845
[time] => 0.0033948421478271
)
[4] => Array
(
[query] => select * from matches where (first_referee_id = '16' OR second_referee_id = '16' OR third_referee_id = '16') AND date <= '1770937200' ORDER BY
case when date in('', '0') then 9999999999999999999999 else date end DESC,
round_id+0
DESC LIMIT 0,15
[start] => 1770978209.1852
[end] => 1770978209.1881
[time] => 0.0028839111328125
)
[5] => Array
(
[query] => select * from match_time where match_id in (4015,4024,4278,3984,4182,4274,4149,4251,3994,4037,4597,4261,4348,4137,4266) order by id ASC
[start] => 1770978209.1882
[end] => 1770978209.1909
[time] => 0.0027320384979248
)
[6] => Array
(
[query] => SELECT * FROM match_data where match_id IN (4015,4024,4278,3984,4182,4274,4149,4251,3994,4037,4597,4261,4348,4137,4266)
[start] => 1770978209.2161
[end] => 1770978209.2285
[time] => 0.012337923049927
)
[7] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1770978209.2321
[end] => 1770978209.2326
[time] => 0.00050902366638184
)
[8] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1770978209.233
[end] => 1770978209.2333
[time] => 0.00028204917907715
)
[9] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1770978209.2372
[end] => 1770978209.2377
[time] => 0.0005180835723877
)
[10] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1770978209.2385
[end] => 1770978209.2387
[time] => 0.00025796890258789
)
)
