Partite Arbitrate
Total Queries: 11
Total Time: 0.030096054077148
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1770971399.8058
[end] => 1770971399.806
[time] => 0.00024199485778809
)
[1] => Array
(
[query] => select * from referee where referee_id = '50'
[start] => 1770971399.8076
[end] => 1770971399.8078
[time] => 0.00023508071899414
)
[2] => Array
(
[query] => select * from matches where (first_referee_id = '50' OR second_referee_id = '50' OR third_referee_id = '50') 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] => 1770971399.8082
[end] => 1770971399.816
[time] => 0.0078461170196533
)
[3] => Array
(
[query] => select * from match_time where match_id in (3849,3851,3853,3854) order by id ASC
[start] => 1770971399.8161
[end] => 1770971399.8188
[time] => 0.0026659965515137
)
[4] => Array
(
[query] => select * from matches where (first_referee_id = '50' OR second_referee_id = '50' OR third_referee_id = '50') AND date <= '1770937200' ORDER BY
case when date in('', '0') then 9999999999999999999999 else date end DESC,
round_id+0
DESC LIMIT 0,15
[start] => 1770971399.8189
[end] => 1770971399.8217
[time] => 0.0027859210968018
)
[5] => Array
(
[query] => select * from match_time where match_id in (3854,3853,3851,3849) order by id ASC
[start] => 1770971399.8218
[end] => 1770971399.8246
[time] => 0.0027580261230469
)
[6] => Array
(
[query] => SELECT * FROM match_data where match_id IN (3854,3853,3851,3849)
[start] => 1770971399.8315
[end] => 1770971399.8438
[time] => 0.012269973754883
)
[7] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1770971399.8451
[end] => 1770971399.8455
[time] => 0.0004580020904541
)
[8] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1770971399.8459
[end] => 1770971399.8462
[time] => 0.00024294853210449
)
[9] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1770971399.8487
[end] => 1770971399.849
[time] => 0.0003669261932373
)
[10] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1770971399.8498
[end] => 1770971399.85
[time] => 0.00022506713867188
)
)