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:25:14' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-09-29 04:25: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 (258,264,286,304,305,306,317,336,340,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,713,720,723,736,740,753,769,775,826,828,840,845,898,901,920,933,940,943,956,961,973,980,983,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,1261,1293,1329,1347,1410,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,1700,1710,1713,1718,1719,1732,1737,1743,1760,1761,1765,1770,1781,1786,1798,1828,1836,1849,1864,1872,1884,1889,1896,1905,1919,1937,1949,1960,1968,1983,1997,2011,2057,2062,2075,2111,2132,2143,2154,2182,2197,2199,2207,2208,2219,2238,2251,2296,2311,2325,2343,2347,2360,2371,2375,2390,2391,2398,2402,2403,2405,2410,2411,2415,2422,2426,2428,2435,2438,2441,2443,2449,2454,2455,2458,2459,2464,2466,2602,2625,2627,2639,2662,2679,2699,2706,2715,2725,2734,2779,2806,2809,2841,2848,2872,2886,2888,2892,2909,2922,2935,2945,2977,2990,3014,3019,3029,3043,3057,3066,3127,3143,3154,3175,3180,3216,3227,3233,3241,3242,3243,3262,3285,3322,3332,3335,3350,3365,3376,3396,3436,3456,3459,3474,3488,3501,3519,3526,3537,3538,3553,3557,3572,3583,3590,3593,3598,3611,3637,3641,3642,3650,3652,3656,3660,3664,3666,3667,3676,3677,3683,3684,3692,3693,3694,3703,3704,3705,3706,3707,3714,3723,3724,3734,3735,3740,3745,3747,3750,3765,3766,3768,3769,3782,3784,3803,3824,3854,3857,3882,3948,4044,4048,4068,4074,4080,4177,4202,4223,4226,4250,4260,4277,4285,4306,4310,4315,4327,4334,4344,4357,4374,4382,4406,4407,4423,4431,4441,4453,4469,4470,4494,4515,4523,4530,4540,4556,4563,4571,4580,4582,4599,4610,4625,4642,4653,4659,4671,4681,4706,4722,4724,4732,4763,4808,4826,4838,4850,4906,5025,5035,5071,5108,5112,5231,5239,5302,5305,5313,5316,5329,5335,5348,5366,5370,5374,5376,5395,5423,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,7287,7288,7292,7301,7307,7314,7411,7440,7464,7485,7490,7507,260,280,290,301,310,323,330,332,341,376,434,442,490,503,513,527,540,546,560,581,586,621,679,707,712,716,725,730,743,754,844,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,1880,1897,1913,1922,1945,1959,1964,1979,1996,2061,2077,2113,2133,2146,2152,2153,2173,2181,2212,2220,2445,2526,2564,2744,2745,2802,2843,2906,2921,2932,2946,2973,2992,3011,3037,3065,3125,3136,3155,3169,3182,3226,3231,3246,3263,3280,3295,3323,3358,3368,3378,3460,3473,3489,3525,3536,3541,3554,3571,3594,3600,3612,3616,3622,3624,3626,3644,3645,3653,3655,3674,3675,3748,3845,3896,3990,4297,4313,4353,4373,4375,4380,4385,4403,4432,4442,4461,4492,4508,4514,4524,4525,4536,4547,4560,4627,4641,4654,4682,4691,4708,4730,4743,4759,4789,4810,4837,4851,4900,5039,5191,5222,5242,5261,5298,5318,5320,5331,5347,5351,5367,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