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 <= '2023-09-29 03:51:38' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-09-29 03:51:38' ) 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,3788,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,4513,4523,4530,4534,4547,4571,4593,4602,4613,4624,4626,4630,4636,4641,4647,4650,4659,4670,4681,4701,4719,4724,4725,4726,4734,4736,4746,4747,4753,4760,4775,4782,4783,4803,4804,4826,4827,4839,4851,4858,4874,4881,4896,4899,4901,4906,4914,5029,5064,5071,5099,5108,5112,5169,5178,5191,5231,5234,5261,5304,5306,5313,5314,5317,5318,5329,5337,5348,5363,5366,5367,5376,5380,5423,264,256,304,305,324,325,332,336,371,375,384,437,457,474,479,493,494,496,518,521,524,550,553,561,568,589,598,604,611,616,623,634,681,685,719,734,757,803,819,837,856,990,1084,1198,1218,1345,1371,1608,1637,1680,1703,1704,1723,1726,1730,1766,1788,1809,1825,1843,1855,1870,1896,1905,1912,1921,1950,1971,1986,1992,1993,2003,2015,2064,2077,2111,2119,2133,2145,2148,2182,2198,2210,2235,2246,2466,2612,2616,2618,2632,2673,2699,2715,2936,2957,2964,2967,2988,2997,3017,3043,3055,3065,3071,3120,3121,3153,3192,3199,3228,3249,3367,3372,3384,3390,3409,3447,3463,3478,3513,3528,3806,3844,4191,4235,4312,4320,4336,4338,4346,4353,4371,4402,4417,4425,4438,4453,4456,4466,4506,4512,4524,4537,4554,4562,4642,4655,4666,4668,4676,4692,4713,4744,4773,4780,4814,4824,4850,5195,5245,5392,5393,5517,5529,5619,5636,5648,5661,5667,5669,5678,5684,5717,5742,5755,5777,5796,5822,5826,5831,5909,5959,5961,6017,6230,6252,6261,6282,6296,6314,6344,6355,6362,6375,6381,6429,6438,6447,6479,6504,6509,6520,6545,6592,6628,6638,6659,6713,6723,6747,6756,6838,6917,6984,7091,7094,7101,7122,7135,7143,7150,7181,7186,7191,7193,7198,7201,7204,7235,7251,7260,7278,7284,7287,7293,7300,7301,7482,7493,7495,7520,7530,7548,7631)
ORDER BY i.created DESC LIMIT 0, 3