DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
Total Queries: 11
Total Time: 0.034136056900024
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1781159469.9912
[end] => 1781159469.9914
[time] => 0.00026392936706543
)
[1] => Array
(
[query] => select * from referee where referee_id = '45'
[start] => 1781159469.9932
[end] => 1781159469.9934
[time] => 0.00024199485778809
)
[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] => 1781159469.9938
[end] => 1781159470.0026
[time] => 0.0087380409240723
)
[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] => 1781159470.003
[end] => 1781159470.0065
[time] => 0.0035040378570557
)
[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] => 1781159470.0071
[end] => 1781159470.0101
[time] => 0.0030710697174072
)
[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] => 1781159470.0103
[end] => 1781159470.0136
[time] => 0.0033559799194336
)
[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] => 1781159470.0494
[end] => 1781159470.0628
[time] => 0.01339316368103
)
[7] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1781159470.0673
[end] => 1781159470.0679
[time] => 0.00058889389038086
)
[8] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1781159470.0683
[end] => 1781159470.0686
[time] => 0.00027704238891602
)
[9] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1781159470.0745
[end] => 1781159470.075
[time] => 0.00045990943908691
)
[10] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1781159470.0758
[end] => 1781159470.0761
[time] => 0.00024199485778809
)
)