DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
Total Queries: 12
Total Time: 0.027791261672974
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1770971399.6061
[end] => 1770971399.6064
[time] => 0.0002739429473877
)
[1] => Array
(
[query] => select * from location where location_id = '3'
[start] => 1770971399.6081
[end] => 1770971399.6083
[time] => 0.0001988410949707
)
[2] => Array
(
[query] => select * from matches where date >= '1770937200' AND location_id = '3' 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,5
[start] => 1770971399.6085
[end] => 1770971399.6112
[time] => 0.002720832824707
)
[3] => Array
(
[query] => select * from matches where date <= '1770937200' 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) AND location_id = '3' ORDER BY
case when date in('', '0') then 9999999999999999999999 else date end DESC,
round_id+0
DESC LIMIT 0,5
[start] => 1770971399.6114
[end] => 1770971399.619
[time] => 0.0076019763946533
)
[4] => Array
(
[query] => select * from match_time where match_id in (3279,3199,3018,3107,3148) order by id ASC
[start] => 1770971399.6191
[end] => 1770971399.6219
[time] => 0.0027990341186523
)
[5] => Array
(
[query] => SELECT * FROM match_data where match_id IN (3279,3199,3018,3107,3148)
[start] => 1770971399.6304
[end] => 1770971399.6426
[time] => 0.012235879898071
)
[6] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1770971399.6441
[end] => 1770971399.6445
[time] => 0.00047087669372559
)
[7] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1770971399.6449
[end] => 1770971399.6452
[time] => 0.00028800964355469
)
[8] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1770971399.6456
[end] => 1770971399.6459
[time] => 0.0003669261932373
)
[9] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1770971399.6463
[end] => 1770971399.6465
[time] => 0.00023794174194336
)
[10] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1770971399.6493
[end] => 1770971399.6497
[time] => 0.00040698051452637
)
[11] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1770971399.6505
[end] => 1770971399.6507
[time] => 0.00019001960754395
)
)