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 04:05:14' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-09-29 04:05:14' ) 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,4679,4681,4701,4719,4724,4725,4726,4734,4736,4746,4747,4753,4760,4775,4782,4783,4803,4804,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,258,264,304,305,306,317,336,348,371,374,407,426,429,432,455,502,512,521,522,539,543,545,564,578,585,588,593,599,616,619,633,647,653,669,672,681,686,701,708,720,723,736,740,753,769,775,826,828,840,845,901,920,933,943,956,961,973,992,994,1001,1002,1014,1017,1034,1048,1053,1063,1066,1076,1079,1088,1089,1091,1095,1096,1102,1115,1118,1121,1123,1130,1133,1134,1138,1139,1149,1179,1293,1329,1347,1434,1465,1501,1517,1521,1522,1525,1528,1539,1542,1560,1573,1596,1602,1610,1618,1626,1637,1653,1658,1661,1662,1678,1680,1687,1710,1713,1718,1719,1737,1743,1761,1765,1770,1781,1786,1798,1836,1849,1872,1884,1896,1905,1937,1960,1968,1983,1997,2011,2057,2075,2111,2132,2143,2154,2182,2197,2199,2219,2296,2311,2325,2347,2360,2371,2390,2391,2402,2403,2405,2410,2411,2422,2426,2428,2435,2438,2441,2449,2454,2455,2459,2464,2466,2602,2625,2639,2662,2679,2699,2706,2715,2725,2734,2779,2806,2809,2841,2872,2886,2888,2892,2945,2977,3014,3019,3043,3057,3066,3127,3143,3154,3216,3227,3233,3241,3242,3243,3262,3322,3335,3350,3365,3376,3396,3436,3459,3474,3501,3519,3538,3553,3557,3590,3593,3598,3641,3650,3656,3660,3664,3676,3677,3683,3693,3694,3704,3706,3707,3714,3723,3734,3735,3740,3765,3768,3782,3803,3854,3857,3882,3948,4048,4068,4074,4080,4177,4202,4223,4226,4250,4285,4306,4310,4315,4327,4334,4344,4357,4374,4382,4406,4431,4441,4453,4469,4470,4494,4515,4540,4556,4563,4580,4582,4599,4610,4625,4642,4653,4671,4706,4722,4732,4763,4808,4838,4850,5025,5035,5239,5302,5305,5316,5335,5370,5374,5395,5446,5494,5499,5532,5535,5543,5549,5550,5555,5556,5571,5576,5598,5623,5650,5655,5688,5690,5705,5719,5723,5754,5781,5793,5804,5819,5821,5823,5829,5830,5884,5908,5946,5956,5976,6093,6129,6166,6241,6256,6268,6276,6290,6308,6356,6363,6393,6398,6413,6426,6435,6436,6443,6445,6447,6480,6486,6502,6512,6530,6550,6570,6588,6600,6601,6604,6614,6627,6636,6644,6652,6659,6661,6673,6676,6686,6695,6702,6703,6705,6713,6723,6746,6747,6750,6764,6771,6773,6776,6781,6797,6803,6819,6824,6835,6849,6856,6874,6889,6928,6997,7029,7032,7038,7097,7102,7111,7114,7117,7126,7135,7142,7149,7156,7179,7202,7207,7208,7211,7221,7223,7227,7230,7260,7265,7283,7287,7288,7292,7301,7307,7314,7411,7440,7464,7485,7490,7507,260,290,301,310,323,330,332,341,376,442,490,503,513,560,581,586,707,712,716,725,730,743,887,892,903,904,907,908,911,935,938,947,949,1065,1232,1284,1624,1627,1639,1647,1669,1699,1702,1721,1733,1740,1758,1791,1843,1873,1897,1922,1945,1959,1964,1979,1996,2061,2077,2113,2133,2152,2153,2173,2181,2212,2445,2526,2744,2745,2843,2906,2921,2932,2946,2973,2992,3011,3037,3065,3125,3136,3155,3169,3182,3226,3263,3295,3323,3368,3460,3473,3489,3525,3571,3612,3624,3626,3644,3645,3653,3655,3748,3845,3896,3990,4313,4353,4373,4375,4380,4385,4403,4432,4461,4514,4524,4525,4536,4560,4627,4654,4682,4691,4708,4730,4743,4759,4789,4810,4837,4900,5039,5222,5242,5298,5320,5331,5347,5351,5369,5378,5384,5402,5479,5496,5534,5542,5563,5615,5639,5649,5660,5671,5683,5695,5738,5747,5840,5844,5852,5861,5868,5873,5876,5960,5972,6026,6053,6127,6142,6216,6261,6273,6288,6316,6361,6365,6374,6385,6404,6424,6446,6457,6478,6479,6487,6507,6519,6523,6556,6564,6574,6589,6596,6616,6620,6633,6643,6664,6677,6687,6696,6788,6793,6836,6951,7019,7052,7127,7146,7155,7159,7177,7192,7200,7204,7215,7217,7228,7233,7249,7261,7269,7270,7277,7310)
ORDER BY i.created DESC LIMIT 0, 3