DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
Total Queries: 11
Total Time: 0.032186508178711
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1770965498.8587
[end] => 1770965498.859
[time] => 0.00031185150146484
)
[1] => Array
(
[query] => select * from referee where referee_id = '23'
[start] => 1770965498.8606
[end] => 1770965498.8609
[time] => 0.00024700164794922
)
[2] => Array
(
[query] => select * from matches where (first_referee_id = '23' OR second_referee_id = '23' OR third_referee_id = '23') 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] => 1770965498.8612
[end] => 1770965498.8696
[time] => 0.0084099769592285
)
[3] => Array
(
[query] => select * from match_time where match_id in (2912,2891,2894,2895,2913,3920,2896,3947,2956,2953,2954,2957,3952,3953,3932,2910,2915,2900,2901,3925,2906,2905,3350,3351,3930,3937,2961,3360,2919,3060,2971,3326,3421,3425,3424,4136,2872,2976,2977,3068,3157,3698,3429,3895,3430,3961,4524,4521,3160,3161,3073,3072,3071,3331,3434,3433,3253,3165,2989,3437,3898,3970,3974,4531,4529,2938,2994,3082,3442,3531,3707,3532,3901,4157,4336,2466,3262,3263,3261,3448,3446,3450,3874,3902,3982,4253,4540,4539,4345,3987,4347,3005,3547,3783,3459,3719,3907,3010,3014,3193,3272,3462,3465,4552,4356,3468,3470,3911,3910,4362,3022,3023,3473,3474,4005,4009,4366,2495,2496,3284,3285,3287,3119,3478,3480,4562,4564,2502,2668,3290,4565,4017,2597,2596,2671,2672,2503,2504,2673,3125,3487,3486,4572,2602,2510,3132,3493,3492,3491,3584,2604,2354,2607,2515,2514,2517,3045,3135,3137,3138,3498,3823,2357,2360,2610,2612,2358,2522,3050,3501,3237,3239,3057,3507,3510) order by id ASC
[start] => 1770965498.8707
[end] => 1770965498.8745
[time] => 0.003748893737793
)
[4] => Array
(
[query] => select * from matches where (first_referee_id = '23' OR second_referee_id = '23' OR third_referee_id = '23') AND date <= '1770937200' ORDER BY
case when date in('', '0') then 9999999999999999999999 else date end DESC,
round_id+0
DESC LIMIT 0,15
[start] => 1770965498.8755
[end] => 1770965498.8783
[time] => 0.002875804901123
)
[5] => Array
(
[query] => select * from match_time where match_id in (4265,4285,4529,4564,4539,4521,4524,4366,4017,4362,4572,4531,4540,4562,4009) order by id ASC
[start] => 1770965498.8785
[end] => 1770965498.8811
[time] => 0.002687931060791
)
[6] => Array
(
[query] => SELECT * FROM match_data where match_id IN (4265,4285,4529,4564,4539,4521,4524,4366,4017,4362,4572,4531,4540,4562,4009)
[start] => 1770965498.9032
[end] => 1770965498.9155
[time] => 0.012295961380005
)
[7] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1770965498.9191
[end] => 1770965498.9197
[time] => 0.0005180835723877
)
[8] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1770965498.9201
[end] => 1770965498.9204
[time] => 0.00027990341186523
)
[9] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1770965498.9244
[end] => 1770965498.9249
[time] => 0.00046610832214355
)
[10] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1770965498.9256
[end] => 1770965498.926
[time] => 0.00034499168395996
)
)
