DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
Total Queries: 12
Total Time: 0.031065940856934
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1786252860.083
[end] => 1786252860.0832
[time] => 0.0002739429473877
)
[1] => Array
(
[query] => select * from location where location_id = '3'
[start] => 1786252860.0851
[end] => 1786252860.0853
[time] => 0.00021505355834961
)
[2] => Array
(
[query] => select * from matches where date >= '1786226400' 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] => 1786252860.0856
[end] => 1786252860.0884
[time] => 0.0028870105743408
)
[3] => Array
(
[query] => select * from matches where date <= '1786226400' 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] => 1786252860.0886
[end] => 1786252860.0974
[time] => 0.0087409019470215
)
[4] => Array
(
[query] => select * from match_time where match_id in (3279,3199,3018,3107,3148) order by id ASC
[start] => 1786252860.0974
[end] => 1786252860.1006
[time] => 0.0031368732452393
)
[5] => Array
(
[query] => SELECT * FROM match_data where match_id IN (3279,3199,3018,3107,3148)
[start] => 1786252860.1106
[end] => 1786252860.1243
[time] => 0.013732194900513
)
[6] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1786252860.1259
[end] => 1786252860.1265
[time] => 0.00059294700622559
)
[7] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1786252860.1269
[end] => 1786252860.1272
[time] => 0.00026893615722656
)
[8] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1786252860.1275
[end] => 1786252860.1279
[time] => 0.00038409233093262
)
[9] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1786252860.1283
[end] => 1786252860.1285
[time] => 0.00023794174194336
)
[10] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1786252860.1317
[end] => 1786252860.1321
[time] => 0.00037312507629395
)
[11] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1786252860.1329
[end] => 1786252860.1331
[time] => 0.00022292137145996
)
)