Partite Arbitrate
Total Queries: 11
Total Time: 0.035057306289673
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1770965499.0869
[end] => 1770965499.0872
[time] => 0.00031185150146484
)
[1] => Array
(
[query] => select * from referee where referee_id = '24'
[start] => 1770965499.0889
[end] => 1770965499.0891
[time] => 0.00023412704467773
)
[2] => Array
(
[query] => select * from matches where (first_referee_id = '24' OR second_referee_id = '24' OR third_referee_id = '24') 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] => 1770965499.0895
[end] => 1770965499.0993
[time] => 0.009774923324585
)
[3] => Array
(
[query] => select * from match_time where match_id in (3332,3915,3335,3916,3949,3367,3947,3953,3343,3912,3913,3914,3350,3351,3929,3936,3352,3358,3362,3944,3360,3375,3370,3371,2870,2846,2847,2919,3150,3154,3243,3241,3060,2972,3747,3750,3512,3511,3751,3423,3858,3876,4315,4135,4136,4138,4317,4137,3958,2873,2848,2920,3158,3247,3244,3159,2976,2977,3329,3328,3427,3428,3516,3844,3850,3838,3859,3862,3867,3878,3895,3755,4322,4321,3962,4140,4597,4521,2874,2850,2851,2935,3160,3249,3250,3162,3164,3073,3070,3331,3321,3758,3760,3521,3700,3524,3759,3757,3702,3845,3860,3863,3881,3869,3880,3897,4325,4328,4148,4146,2936,2852,3253,3166,3168,3254,2989,3252,3322,3528,3763,3762,3706,3440,3703,3852,3846,3870,3871,3898,3970,3974,4152,4334,4150,4244,4531,4602,4529,2878,2855,2854,3170,3172,2994,3080,3081,3768,3767,3534,3710,3709,3708,3531,3707,3532,3445,3873,4155,4335,4249,4339,4338,4156,4246,4336,4158,4607,2857,3262,3263,3176,2998,3085,3540,3536,3449,3712,3774,3848,3713,3874,3902,3903,4164,4162,4250,3983,3982,4340,4160,4253,4540,4539,3266,3180,3090,3093,3002,3715,3716,3777,3545,3541,3542,3453,3905,4346,4165,4166,4257,4345,3987,4169,4347,4348,3097,3006,3271,3457,3721,3546,3548,3549,3784,3720,3719,3786,3907,3906,4172,4352,4351,4173,4261,4174,4262,4350,3994,3100,3101,3013,3190,3274,3726,3723,3553,3551,3787,3464,3724,3725,3908,3909,4178,4177,4552,4266,4356,4355,4358,4179,3105,3109,3016,3198,3277,3467,3796,3729,3560,3730,3558,3911,3910,4180,4184,4271,4364,4361,4270,4360,4001,4362,4274,4182,3200,3110,3114,3111,3734,3733,3801,3565,3561,3797,3731,4558,4365,4189,4276,4185,4368,4188,4369,4187,4366,3025,3028,3117,3284,3285,3287,3736,3570,3476,3479,4562,4013,4564,3031,3210,3122,3120,3123,3289,3809,3741,3739,3571,3573,3482,3575,3037,3215,3129,3294,3295,3812,3746,3579,3488,3813,4572,3043,3221,3220,3130,3134,3817,3583,3581,3818,3494,3049,3225,3227,3136,3500,3825,3824,3823,4394,3233,3231,3230,3054,3140,3142,3827,3505,3591,3148,3055,3237,3239,3836,3599,3597,3506) order by id ASC
[start] => 1770965499.1018
[end] => 1770965499.1069
[time] => 0.0050778388977051
)
[4] => Array
(
[query] => select * from matches where (first_referee_id = '24' OR second_referee_id = '24' OR third_referee_id = '24') AND date <= '1770937200' ORDER BY
case when date in('', '0') then 9999999999999999999999 else date end DESC,
round_id+0
DESC LIMIT 0,15
[start] => 1770965499.1089
[end] => 1770965499.1121
[time] => 0.0031859874725342
)
[5] => Array
(
[query] => select * from match_time where match_id in (4563,4620,4554,4175,4618,4614,4547,4615,3979,4528,4238,4526,3966,4232,4519) order by id ASC
[start] => 1770965499.1122
[end] => 1770965499.1149
[time] => 0.0026869773864746
)
[6] => Array
(
[query] => SELECT * FROM match_data where match_id IN (4563,4620,4554,4175,4618,4614,4547,4615,3979,4528,4238,4526,3966,4232,4519)
[start] => 1770965499.1151
[end] => 1770965499.1275
[time] => 0.012415170669556
)
[7] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1770965499.1311
[end] => 1770965499.1316
[time] => 0.00045514106750488
)
[8] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1770965499.132
[end] => 1770965499.1323
[time] => 0.0002601146697998
)
[9] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1770965499.1362
[end] => 1770965499.1366
[time] => 0.00041007995605469
)
[10] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1770965499.1374
[end] => 1770965499.1376
[time] => 0.00024509429931641
)
)