DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
Total Queries: 11
Total Time: 0.033667325973511
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1770978208.9485
[end] => 1770978208.9488
[time] => 0.00033807754516602
)
[1] => Array
(
[query] => select * from referee where referee_id = '12'
[start] => 1770978208.9505
[end] => 1770978208.9507
[time] => 0.00027203559875488
)
[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] => 1770978208.9511
[end] => 1770978208.96
[time] => 0.0089030265808105
)
[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,2163,1896,2115,2339,2340,2669,2667,2499,3211,3032,3030,4198,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] => 1770978208.9616
[end] => 1770978208.966
[time] => 0.0044398307800293
)
[4] => Array
(
[query] => select * from matches where (first_referee_id = '12' OR second_referee_id = '12' OR third_referee_id = '12') AND date <= '1770937200' ORDER BY
case when date in('', '0') then 9999999999999999999999 else date end DESC,
round_id+0
DESC LIMIT 0,15
[start] => 1770978208.9674
[end] => 1770978208.9704
[time] => 0.0029668807983398
)
[5] => Array
(
[query] => select * from match_time where match_id in (4357,3986,4007,4283,4376,3959,4225,4198,4188,4276,4013,4360,4361,4364,4271) order by id ASC
[start] => 1770978208.9705
[end] => 1770978208.9732
[time] => 0.0027151107788086
)
[6] => Array
(
[query] => SELECT * FROM match_data where match_id IN (4357,3986,4007,4283,4376,3959,4225,4198,4188,4276,4013,4360,4361,4364,4271)
[start] => 1770978208.992
[end] => 1770978209.0045
[time] => 0.012538194656372
)
[7] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1770978209.0082
[end] => 1770978209.0087
[time] => 0.00052404403686523
)
[8] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1770978209.0091
[end] => 1770978209.0093
[time] => 0.00026106834411621
)
[9] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1770978209.0133
[end] => 1770978209.0137
[time] => 0.00045514106750488
)
[10] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1770978209.0145
[end] => 1770978209.0147
[time] => 0.00025391578674316
)
)
