EXPLAIN not possible on query: SELECT i.*, c.alias as categoryalias FROM u2tdi_k2_items as i
LEFT JOIN u2tdi_k2_categories c ON c.id = i.catid
WHERE i.published = 1
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2019-12-06 07:57:49' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-12-06 07:57:49' ) AND i.access IN(1,1) AND i.language IN('en-GB', '*') AND i.trash = 0
AND c.published = 1 AND c.access IN(1,1) AND c.language IN('en-GB', '*') AND c.trash = 0
AND (i.id) IN (255,243,244,263,242,272,275,278,279,280,282,285,286,287,288,292,297,309,321,340,347,349,363,403,415,424,434,440,450,482,483,492,498,501,508,514,515,527,533,540,541,546,547,559,562,563,573,583,584,594,597,613,617,621,637,646,654,658,664,667,679,687,695,698,706,713,717,724,731,739,747,754,759,788,792,801,806,823,844,861,874,883,898,900,917,919,940,974,980,983,1209,1254,1261,1285,1286,1334,1387,1402,1410,1472,1477,1515,1516,1543,1544,1552,1558,1563,1565,1587,1601,1605,1606,1611,1632,1646,1672,1686,1700,1706,1716,1732,1760,1772,1802,1828,1835,1842,1848,1864,1875,1880,1889,1890,1898,1913,1919,1926,1949,1955,1961,1966,1975,1981,1982,2012,2037,2049,2053,2058,2062,2068,2078,2089,2095,2121,2130,2146,2158,2170,2200,2207,2208,2220,2238,2245,2251,2260,2273,2286,2288,2289,2332,2343,2375,2398,2415,2423,2443,2458,2473,2488,2499,2502,2516,2531,2564,2627,2628,2630,2634,2659,2674,2682,2684,2695,2702,2707,2777,2788,2791,2802,2808,2831,2848,2895,2896,2907,2909,2915,2916,2922,2934,2935,2940,2947,2951,2952,2962,2969,2974,2990,2993,2996,3005,3010,3013,3027,3029,3040,3041,3042,3053,3056,3063,3067,3068,3069,3109,3111,3122,3123,3137,3141,3157,3165,3175,3178,3179,3180,3196,3201,3210,3212,3214,3215,3219,3229,3231,3246,3250,3254,3264,3266,3268,3280,3282,3283,3285,3298,3299,3300,3302,3309,3314,3325,3328,3332,3338,3339,3348,3358,3373,3377,3378,3380,3381,3386,3393,3401,3437,3456,3468,3476,3477,3488,3491,3496,3505,3518,3526,3536,3537,3541,3543,3544,3554,3561,3566,3572,3583,3594,3597,3600,3605,3611,3616,3618,3622,3629,3637,3642,3648,3652,3666,3667,3674,3675,3680,3684,3688,3692,3703,3705,3724,3727,3745,3747,3750,3758,3766,3769,3784,3799,3824,3841,3850,3871,3891,3895,4039,4044,4067,4092,4102,4128,4138,4149,4160,4166,4204,4209,4213,4236,4256,4260,4263,4272,4274,4277,4278,4279,4280,4282,4283,4284,4291,4292,4295,4296,4297,4308,4316,4329,4347,4362,4366,4386,4390,4398,4407,4412,4423,4430,4434,4436,4442,4450,4455,4465,4480,4492,4503,4508,954,968,1113,1594,1607,1620,1652,1673,1688,1714,1733,1754,1770,1839,1861,1882,1907,1933,1943,1967,1979,1995,2015,2113,2134,2145,2148,2152,2161,2171,2176,2177,2234,2250,2259,2272,2283,2291,2296,2311,2323,2325,2360,2380,2382,2431,2490,2507,2648,2765,2941,2978,3014,3026,3037,3050,3070,3115,3138,3160,3217,3235,3251,3267,3297,3323,3340,3362,3364,3374,3435,3442,3443,3460,3504,3539,3545,3558,3567,3580,3641,3650,3656,3660,3664,3669,3676,3677,3683,3719,3759,3787,3894,3908,3941,3942,3959,3978,4251,4276,4312,4325,4345,4350,4352,4356,4367,4389,4395,4419,4424,4431,4443,4451,4459,4460,4481)
ORDER BY i.created DESC LIMIT 0, 3