DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
Total Queries: 11
Total Time: 0.03386664390564
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1776061761.77
[end] => 1776061761.7704
[time] => 0.00030994415283203
)
[1] => Array
(
[query] => select * from referee where referee_id = '12'
[start] => 1776061761.7721
[end] => 1776061761.7723
[time] => 0.00023508071899414
)
[2] => Array
(
[query] => select * from matches where (first_referee_id = '12' OR second_referee_id = '12' OR third_referee_id = '12') 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] => 1776061761.7726
[end] => 1776061761.7816
[time] => 0.0089800357818604
)
[3] => Array
(
[query] => select * from match_time where match_id in (2239,3332,3335,3918,2952,3916,3921,2244,3949,2965,2967,2966,2268,2917,3342,2916,3923,2915,2252,2253,2900,2901,3347,2255,2256,3346,2254,2892,2893,3353,3929,2962,2529,2532,2280,2277,2278,2847,2930,2931,3150,2970,3061,3327,3513,3422,3892,4227,3958,4225,3959,2533,2535,2625,2623,2872,3246,2975,3069,3067,3065,3068,3318,3319,3427,3428,3695,3696,3519,4143,2627,2626,2448,2288,2449,2863,2850,2851,2922,2923,3161,2981,3073,3868,4326,3969,2454,2455,2545,2936,2853,3253,3077,3078,3530,3765,4244,2458,2461,2460,2551,2855,2854,3443,2556,2304,2305,2857,3177,2997,2999,3775,3539,3449,3980,4160,2126,2170,2468,3182,3184,3265,3267,3454,3780,3779,3543,3904,3985,2124,2176,2187,2473,3784,4174,2160,2128,2320,2571,2651,2481,3191,3012,3553,3908,3909,4176,2198,2179,2322,2655,2486,3196,3197,3017,3015,3278,3276,3108,3792,3727,4004,4271,4364,4361,4360,2578,3201,3280,3282,3024,3800,4276,4188,2165,1881,1882,2190,2046,2332,2335,2493,3208,3209,3476,3479,4013,4283,2163,1896,2115,2339,2340,2669,2667,2499,3211,3032,3030,4198,4376,2155,1886,1913,2107,2597,2594,3129,3490,3577,2599,2601,2347,2349,2510,3043,3131,2087,2090,1902,1922,2605,2356,2603,2606,2607,2515,3048,3228,3135,3499,2169,2142,2610,2612,3052,3050,3140,3142,3143,3593,3505,3591,1888,2098,1904,2173,2364,3055,3509,3598,3597,3506) order by id ASC
[start] => 1776061761.7833
[end] => 1776061761.7878
[time] => 0.004525899887085
)
[4] => Array
(
[query] => select * from matches where (first_referee_id = '12' OR second_referee_id = '12' OR third_referee_id = '12') AND date <= '1776031200' ORDER BY
case when date in('', '0') then 9999999999999999999999 else date end DESC,
round_id+0
DESC LIMIT 0,15
[start] => 1776061761.7893
[end] => 1776061761.7923
[time] => 0.0030319690704346
)
[5] => Array
(
[query] => select * from match_time where match_id in (4028,4375,3990,4363,4357,3986,4007,4283,4376,3959,4225,4198,4188,4276,4013) order by id ASC
[start] => 1776061761.7925
[end] => 1776061761.7952
[time] => 0.0027308464050293
)
[6] => Array
(
[query] => SELECT * FROM match_data where match_id IN (4028,4375,3990,4363,4357,3986,4007,4283,4376,3959,4225,4198,4188,4276,4013)
[start] => 1776061761.809
[end] => 1776061761.8216
[time] => 0.012602806091309
)
[7] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1776061761.8253
[end] => 1776061761.8258
[time] => 0.00050687789916992
)
[8] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1776061761.8262
[end] => 1776061761.8265
[time] => 0.00026416778564453
)
[9] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1776061761.8317
[end] => 1776061761.8322
[time] => 0.00044488906860352
)
[10] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1776061761.833
[end] => 1776061761.8332
[time] => 0.00023412704467773
)
)