DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
Total Queries: 11
Total Time: 0.030855894088745
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1770978209.4551
[end] => 1770978209.4554
[time] => 0.00030183792114258
)
[1] => Array
(
[query] => select * from referee where referee_id = '47'
[start] => 1770978209.457
[end] => 1770978209.4573
[time] => 0.000244140625
)
[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] => 1770978209.4576
[end] => 1770978209.4654
[time] => 0.0077979564666748
)
[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] => 1770978209.4659
[end] => 1770978209.4688
[time] => 0.0029900074005127
)
[4] => Array
(
[query] => select * from matches where (first_referee_id = '47' OR second_referee_id = '47' OR third_referee_id = '47') 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.4692
[end] => 1770978209.4722
[time] => 0.0029430389404297
)
[5] => Array
(
[query] => select * from match_time where match_id in (4243,4354,4344,4324,4269,3978,4241,4264,4263,4320,4137,4266,4239,4337,4237) order by id ASC
[start] => 1770978209.4723
[end] => 1770978209.4751
[time] => 0.0027530193328857
)
[6] => Array
(
[query] => SELECT * FROM match_data where match_id IN (4243,4354,4344,4324,4269,3978,4241,4264,4263,4320,4137,4266,4239,4337,4237)
[start] => 1770978209.5006
[end] => 1770978209.5129
[time] => 0.012376070022583
)
[7] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1770978209.5166
[end] => 1770978209.5171
[time] => 0.00049591064453125
)
[8] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1770978209.5175
[end] => 1770978209.5178
[time] => 0.00028705596923828
)
[9] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1770978209.5217
[end] => 1770978209.5221
[time] => 0.00045084953308105
)
[10] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1770978209.5229
[end] => 1770978209.5231
[time] => 0.00021600723266602
)
)
