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-03-29 22:07:14' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-03-29 22:07: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 (264,260,285,288,301,311,332,345,346,352,371,377,434,438,454,501,510,513,521,525,535,545,562,563,581,587,598,605,607,616,621,641,648,652,656,660,661,663,670,681,687,701,704,711,720,723,736,742,756,758,782,787,795,799,826,829,840,845,853,887,891,900,908,913,919,935,937,947,950,959,964,969,972,973,974,985,986,987,995,998,1003,1005,1008,1015,1018,1048,1053,1059,1063,1066,1076,1079,1088,1091,1095,1096,1105,1115,1118,1121,1124,1130,1134,1138,1145,1149,1365,1445,1469,1479,1480,1523,1524,1532,1539,1543,1590,1597,1623,1628,1634,1652,1665,1674,1676,1695,1696,1716,1723,1732,1755,1771,1777,1838,1839,1850,1874,1892,1900,1907,1936,1945,1955,1971,1983,1985,1991,2004,2012,2013,2024,2026,2029,2050,2063,2076,2111,2119,2132,2146,2161,2166,2170,2196,2209,2215,2237,2252,2263,2277,2288,2315,2466,2495,2527,2529,2555,2588,2591,2681,2701,2724,2738,2752,2777,2809,2844,2906,2924,2934,2951,2978,2994,3017,3028,3040,3056,3067,3080,3127,3155,3164,3176,3179,3218,3229,3251,3265,3282,3283,3299,3313,3320,3327,3357,3365,3393,3401,3404,3446,3468,3479,3490,3515,3756,3804,3830,3858,4144,4151,4203,4210,4236,4299,4308,4329,4341,4358,4373,4386,4409,4426,4441,4462,4480,4535,4542,4554,4627,4640,4664,4683,4693,4706,4723,4734,4736,4804,4813,4827,4830,4836,4839,4840,4856,4870,4922,4993,5059,5130,5308,5317,5321,5332,5333,5339,5344,5353,5364,5368,5461,5474,5513,5540,5546,5577,5619,5649,5655,5666,5679,5700,5701,5715,5750,5799,5802,5803,5824,5989,6015,6060,6078,6105,6254,6264,6272,6297,6309,6342,6348,6355,6363,6377,6385,6400,6441,6452,6470,6481,6484,6498,6513,6526,6539,6540,6545,6565,6571,6584,6588,6599,6620,6669,6804,6813,6816,6845,6919,6938,6998,6999,7033,7106,7112,7124,7132,7140,7147,7159,7199,7216,7223,7237,7255,7264,7280,7285,280,290,310,323,330,336,341,376,442,455,490,503,527,540,546,560,586,647,653,679,707,712,716,725,730,743,754,828,844,892,903,904,907,911,938,949,1065,1232,1284,1610,1624,1627,1639,1647,1669,1699,1702,1721,1733,1740,1758,1791,1843,1864,1873,1880,1897,1913,1922,1959,1964,1979,1996,2061,2077,2113,2133,2152,2153,2173,2181,2197,2199,2212,2220,2238,2251,2445,2526,2564,2744,2745,2802,2843,2921,2932,2935,2946,2973,2992,3011,3037,3065,3125,3136,3169,3182,3216,3226,3231,3246,3263,3280,3295,3323,3358,3368,3378,3456,3460,3473,3489,3501,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,4375,4380,4385,4403,4432,4442,4461,4492,4508,4514,4524,4525,4536,4547,4560,4641,4654,4671,4682,4691,4708,4730,4743,4759,4789,4810,4826,4837,4851,4900,5039,5191,5222,5242,5261,5298,5318,5320,5331,5347,5351,5367,5369,5378,5384,5402,5423,5479,5496,5532,5534,5542,5563,5615,5623,5639,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,6393,6404,6424,6446,6457,6478,6479,6487,6507,6519,6523,6556,6564,6574,6589,6596,6616,6633,6643,6664,6677,6687,6696,6788,6793,6836,6951,7019,7052,7127,7146,7155,7177,7192,7200,7204,7215,7217,7228,7233,7249,7261,7270,7277,7283,7310)
ORDER BY i.created DESC LIMIT 0, 3
