DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
Total Queries: 11
Total Time: 0.031149625778198
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1776061762.4067
[end] => 1776061762.407
[time] => 0.0003049373626709
)
[1] => Array
(
[query] => select * from referee where referee_id = '47'
[start] => 1776061762.4088
[end] => 1776061762.409
[time] => 0.00026988983154297
)
[2] => Array
(
[query] => select * from matches where (first_referee_id = '47' OR second_referee_id = '47' OR third_referee_id = '47') 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] => 1776061762.4094
[end] => 1776061762.4173
[time] => 0.0078909397125244
)
[3] => Array
(
[query] => select * from match_time where match_id in (3915,3920,3946,3931,3939,3940,3934,3957,4229,4137,4233,4234,4320,4324,3435,3880,3897,4329,4237,4239,3870,3899,4241,4243,3443,3873,4337,3978,4344,3722,3785,4263,4264,4354,4178,4266,4269,3727,3558,3732,3481,3485,3574,3745,3490,3580,3592,3509,3598) order by id ASC
[start] => 1776061762.4176
[end] => 1776061762.4207
[time] => 0.003087043762207
)
[4] => Array
(
[query] => select * from matches where (first_referee_id = '47' OR second_referee_id = '47' OR third_referee_id = '47') AND date <= '1776031200' ORDER BY
case when date in('', '0') then 9999999999999999999999 else date end DESC,
round_id+0
DESC LIMIT 0,15
[start] => 1776061762.4211
[end] => 1776061762.424
[time] => 0.0028750896453857
)
[5] => Array
(
[query] => select * from match_time where match_id in (4018,4020,4349,4290,4243,4354,4344,4324,4269,3978,4241,4264,4263,4320,4137) order by id ASC
[start] => 1776061762.4241
[end] => 1776061762.4268
[time] => 0.0027229785919189
)
[6] => Array
(
[query] => SELECT * FROM match_data where match_id IN (4018,4020,4349,4290,4243,4354,4344,4324,4269,3978,4241,4264,4263,4320,4137)
[start] => 1776061762.446
[end] => 1776061762.4585
[time] => 0.012485027313232
)
[7] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1776061762.4622
[end] => 1776061762.4627
[time] => 0.0005037784576416
)
[8] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1776061762.4631
[end] => 1776061762.4633
[time] => 0.0002589225769043
)
[9] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1776061762.4689
[end] => 1776061762.4694
[time] => 0.00048589706420898
)
[10] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1776061762.4702
[end] => 1776061762.4704
[time] => 0.00026512145996094
)
)