Total Queries: 18
Total Time: 0.065729141235352
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1776061763.4088
[end] => 1776061763.4091
[time] => 0.00030303001403809
)
[1] => Array
(
[query] => select * from matches where date >= '1776031200' AND date <= '1776117540' 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,30
[start] => 1776061763.4111
[end] => 1776061763.4139
[time] => 0.0028071403503418
)
[2] => Array
(
[query] => select * from match_time where match_id in (4301,4296,4027) order by id ASC
[start] => 1776061763.414
[end] => 1776061763.4166
[time] => 0.0026631355285645
)
[3] => Array
(
[query] => SELECT * FROM match_data where match_id IN (4301,4296,4027)
[start] => 1776061763.4168
[end] => 1776061763.429
[time] => 0.012244939804077
)
[4] => Array
(
[query] => select * from matches where date <= '1776031200' 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 date in('', '0') then 9999999999999999999999 else date end DESC,
round_id+0
DESC LIMIT 0,16
[start] => 1776061763.4299
[end] => 1776061763.4387
[time] => 0.0088338851928711
)
[5] => Array
(
[query] => select * from match_time where match_id in (4541,4623,4283,4376,4608,4607,3959,4225,4281,4198,4022,4529,4564,4539,4521,4556) order by id ASC
[start] => 1776061763.4389
[end] => 1776061763.4417
[time] => 0.0028579235076904
)
[6] => Array
(
[query] => SELECT * FROM match_data where match_id IN (4541,4623,4283,4376,4608,4607,3959,4225,4281,4198,4022,4529,4564,4539,4521,4556)
[start] => 1776061763.4688
[end] => 1776061763.4812
[time] => 0.012341022491455
)
[7] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1776061763.4849
[end] => 1776061763.4854
[time] => 0.00046896934509277
)
[8] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1776061763.4858
[end] => 1776061763.4861
[time] => 0.00024008750915527
)
[9] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1776061763.4872
[end] => 1776061763.4876
[time] => 0.00037598609924316
)
[10] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1776061763.4879
[end] => 1776061763.4882
[time] => 0.00024199485778809
)
[11] => Array
(
[query] => select * from matches where date >= '1776031200' AND date <= '1777327200' AND (match_id NOT IN (select match_id from match_time group by match_id) OR match_id IN (select match_id from match_time where closed = '0' group by match_id)) 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
[start] => 1776061763.4916
[end] => 1776061763.4971
[time] => 0.0055480003356934
)
[12] => Array
(
[query] => select * from match_time where match_id in (4301,4296,4027,4298,4212,4387,4213,3967,4299,4208,4553,4522,4570,4537,4039,4206,4235,3968,3973,3975,4391,4302,4023,3964,4220,4390,4311,4393,4214,3963,4304,4621,4300,4398,3977,4397,4395,4216,4307,4219,4215,4399,4218) order by id ASC
[start] => 1776061763.4974
[end] => 1776061763.5001
[time] => 0.0026731491088867
)
[13] => Array
(
[query] => SELECT * FROM match_data where match_id IN (4301,4296,4027,4298,4212,4387,4213,3967,4299,4208,4553,4522,4570,4537,4039,4206,4235,3968,3973,3975,4391,4302,4023,3964,4220,4390,4311,4393,4214,3963,4304,4621,4300,4398,3977,4397,4395,4216,4307,4219,4215,4399,4218)
[start] => 1776061763.5002
[end] => 1776061763.5129
[time] => 0.012736082077026
)
[14] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1776061763.5264
[end] => 1776061763.5269
[time] => 0.00053000450134277
)
[15] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1776061763.5272
[end] => 1776061763.5275
[time] => 0.00025391578674316
)
[16] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1776061763.53
[end] => 1776061763.5304
[time] => 0.00038003921508789
)
[17] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1776061763.5312
[end] => 1776061763.5314
[time] => 0.00022983551025391
)
)