DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
Total Queries: 11
Total Time: 0.034499406814575
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1781155182.7471
[end] => 1781155182.7474
[time] => 0.00030708312988281
)
[1] => Array
(
[query] => select * from referee where referee_id = '45'
[start] => 1781155182.7492
[end] => 1781155182.7494
[time] => 0.00023603439331055
)
[2] => Array
(
[query] => select * from matches where (first_referee_id = '45' OR second_referee_id = '45' OR third_referee_id = '45') 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] => 1781155182.7498
[end] => 1781155182.7585
[time] => 0.0086650848388672
)
[3] => Array
(
[query] => select * from match_time where match_id in (3949,3947,3929,3944,3423,4315,4135,4322,3521,3702,4328,4148,3763,3762,3706,3703,3445,4249,4156,4246,3711,3449,4340,3545,3541,3905,3457,3546,4172,3787,3467,3730,4002,3733,3801,3797,3731,4188,4006,3736,3567,3570,3476,3479,3807,3482,3575,3812,3494,4211,4391,3830,4038,3835,3836,4044,4400) order by id ASC
[start] => 1781155182.7589
[end] => 1781155182.7624
[time] => 0.0035409927368164
)
[4] => Array
(
[query] => select * from matches where (first_referee_id = '45' OR second_referee_id = '45' OR third_referee_id = '45') AND date >= '1756677600' AND date <= '1788213599' ORDER BY
case when date in('', '0') then 9999999999999999999999 else date end DESC,
round_id+0
DESC
[start] => 1781155182.763
[end] => 1781155182.7665
[time] => 0.0035419464111328
)
[5] => Array
(
[query] => select * from match_time where match_id in (4799,4400,4044,4391,4211,4002,4038,4006,4188,4246,4148,4340,4328,4156,4172,4249,4135,4315,4322) order by id ASC
[start] => 1781155182.7667
[end] => 1781155182.7701
[time] => 0.0034301280975342
)
[6] => Array
(
[query] => SELECT * FROM match_data where match_id IN (4799,4400,4044,4391,4211,4002,4038,4006,4188,4246,4148,4340,4328,4156,4172,4249,4135,4315,4322)
[start] => 1781155182.8062
[end] => 1781155182.8195
[time] => 0.013295888900757
)
[7] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1781155182.8242
[end] => 1781155182.8247
[time] => 0.00053501129150391
)
[8] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1781155182.8251
[end] => 1781155182.8254
[time] => 0.00027918815612793
)
[9] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1781155182.8315
[end] => 1781155182.8319
[time] => 0.0004279613494873
)
[10] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1781155182.8328
[end] => 1781155182.833
[time] => 0.00024008750915527
)
)