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-06-04 19:41:00' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-06-04 19:41:00' ) 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 (269,264,259,277,322,332,336,344,356,371,375,434,439,444,456,462,503,512,521,526,549,594,616,619,634,636,640,679,701,705,720,724,736,742,755,780,811,817,821,898,902,921,922,923,924,925,926,927,928,929,930,940,942,958,1313,1321,1363,1490,1560,1571,1572,1589,1607,1614,1622,1639,1645,1649,1659,1672,1687,1690,1706,1739,1759,1777,1792,1837,1861,1883,1897,1910,1921,1929,1949,1954,1961,1981,1994,2012,2065,2078,2116,2130,2141,2160,2676,2711,2756,2758,2841,2910,2921,2933,2937,2950,2956,2971,2996,3012,3022,3027,3038,3053,3063,3067,3126,3143,3157,3182,3213,3230,3245,3267,3268,3302,3307,3325,3341,3357,3376,3407,3416,3447,3464,3479,3491,3503,3515,3528,3543,3548,3561,3568,3579,3596,3681,3743,3799,4030,4039,4097,4098,4131,4204,4213,4229,4250,4265,4280,4290,4307,4340,4371,4379,4390,4403,4404,4412,4426,4437,4450,4475,4504,4510,4515,4531,4559,4568,4572,4613,4624,4630,4644,4654,4683,4695,4710,4732,4746,4747,4753,4761,4767,4782,4796,4814,4825,4837,4920,5030,5178,5356,5419,5457,5464,5506,5531,5585,5621,5637,5651,5675,5683,5699,5707,5712,5734,5781,5839,5845,5854,5865,5874,5881,5886,5890,5891,5892,5896,5897,5904,5960,5994,5997,6004,6036,6174,6235,6240,6253,6265,6283,6305,6346,6351,6354,6362,6379,6398,6425,6450,6467,6475,6513,6527,6537,6549,6580,6592,6600,6615,6624,6646,6658,6672,6675,6681,6709,6717,6718,6727,6737,6753,6762,6770,6778,6789,6791,6796,6808,6815,6833,6967,7008,7067,7080,7143,7152,7192,7227,7251,7262,7297,7308,7322,7330,7336,7356,7363,7372,7386,7392,257,278,279,282,323,327,342,347,349,380,381,437,452,478,484,501,527,564,583,646,647,654,658,669,672,681,687,707,713,722,740,746,804,808,819,824,880,887,892,908,911,917,935,938,947,949,973,980,983,992,1001,1002,1014,1017,1047,1093,1286,1336,1369,1444,1558,1565,1606,1611,1620,1638,1647,1664,1686,1700,1724,1767,1772,1838,1839,1847,1860,1882,1891,1913,1923,1950,1960,1966,1969,1970,2014,2022,2037,2040,2063,2083,2135,2144,2153,2155,2171,2196,2210,2224,2235,2246,2256,2260,2273,2299,2304,2317,2332,2414,2423,2463,2488,2498,2670,2707,2770,2791,2922,2938,2946,2970,2993,3015,3026,3055,3068,3123,3144,3164,3180,3194,3208,3219,3231,3248,3264,3278,3297,3312,3314,3338,3349,3360,3380,3381,3386,3435,3437,3442,3443,3456,3457,3476,3477,3489,3500,3526,3537,3538,3544,3553,3566,3572,3583,3593,3758,3771,3895,3941,4067,4282,4289,4294,4313,4325,4341,4354,4378,4392,4407,4421,4423,4434,4440,4465,4479,4506,4536,4546,4618,4629,4634,4653,4665,4669,4678,4693,4699,4712,4731,4744,4759,4815,4828,4855,4874,4903,4949,5141,5169,5214,5237,5308,5314,5315,5330,5334,5341,5352,5359,5363,5365,5372,5389,5451,5526,5620,5660,5687,5697,5706,5711,5718,5763,5820,5825,5835,5920,5948,5982,6014,6258,6263,6278,6290,6314,6317,6336,6348,6376,6383,6424,6451,6473,6490,6500,6510,6512,6520,6539,6576,6590,6633,6655,6668,6678,6690,6780,6807,7082,7086,7126,7150,7171,7180,7200,7212,7216,7225,7230,7239,7258,7271,7273,7281,7347)
ORDER BY i.created DESC LIMIT 0, 3