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-02-09 08:30:51' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-02-09 08:30:51' ) 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,257,280,301,311,345,346,350,363,370,372,407,413,423,425,427,448,453,460,478,481,489,493,494,496,516,520,528,530,548,572,574,590,592,598,604,624,627,638,643,655,669,673,677,683,695,699,702,703,719,721,736,741,745,757,760,838,847,857,867,869,877,883,884,886,1161,1285,1294,1322,1349,1368,1556,1622,1638,1644,1674,1685,1697,1698,1714,1717,1758,1784,1836,1855,1869,1883,1891,1894,1902,1905,1908,1936,1942,1958,1967,1996,2009,2023,2031,2064,2067,2075,2117,2129,2141,2159,2162,2165,2413,2451,2466,2484,2541,2549,2623,2675,2721,2754,2873,2898,2924,2933,2945,2970,2992,3001,3005,3019,3031,3036,3050,3064,3083,3111,3121,3137,3148,3161,3176,3213,3227,3247,3248,3261,3263,3275,3281,3296,3305,3311,3331,3340,3342,3354,3367,3375,3446,3464,3478,3490,3503,3513,3539,3545,3558,3567,3580,3597,3619,3884,3919,3928,3952,3954,4153,4261,4283,4293,4316,4324,4338,4354,4385,4395,4409,4437,4469,4477,4502,4538,4553,4562,4611,4629,4641,4650,4664,4695,4724,4733,4745,4781,4816,4828,4853,4856,4873,4898,5190,5288,5290,5292,5295,5309,5313,5316,5329,5335,5348,5373,5379,5398,5492,5620,5636,5651,5658,5671,5685,5694,5719,5738,5746,5750,5759,5780,5791,5834,5841,5847,5865,5874,5907,5960,5972,6127,6158,6192,6215,6216,6247,6252,6262,6263,6272,6294,6307,6346,6351,6366,6371,6374,6387,6417,6427,6436,6448,6473,6489,6493,6498,6524,6525,6546,6583,6594,6595,6596,6622,6630,6644,6657,6665,6668,6678,6690,6709,6718,6727,6737,6753,6786,6795,6802,6806,6827,6918,6949,6950,6997,7012,7032,7041,7062,7111,7113,7149,7151,7173,7180,7186,7217,7219,7220,7224,7234,7246,7250,7252,7272,7274,7279,7284,7296,7297,260,285,288,332,352,371,377,434,438,454,501,510,513,521,525,535,545,562,563,581,587,605,607,616,621,641,648,652,656,660,661,663,670,681,687,701,704,711,720,723,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,1676,1695,1696,1716,1723,1732,1755,1771,1777,1838,1839,1850,1874,1892,1900,1907,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,2495,2527,2529,2555,2588,2591,2681,2701,2724,2738,2752,2777,2809,2844,2906,2934,2951,2978,2994,3017,3028,3040,3056,3067,3080,3127,3155,3164,3179,3218,3229,3251,3265,3282,3283,3299,3313,3320,3327,3357,3365,3393,3401,3404,3468,3479,3515,3756,3804,3830,3858,4144,4151,4203,4210,4236,4299,4308,4329,4341,4358,4373,4386,4426,4441,4462,4480,4535,4542,4554,4627,4640,4683,4693,4706,4723,4734,4736,4804,4813,4827,4830,4836,4839,4840,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,5799,5802,5803,5824,5989,6015,6060,6078,6105,6254,6264,6297,6309,6342,6348,6355,6363,6377,6385,6400,6441,6452,6470,6481,6484,6513,6526,6539,6540,6545,6565,6571,6584,6588,6599,6620,6669,6804,6813,6816,6845,6919,6938,6998,6999,7033,7106,7112,7124,7140,7147,7159,7199,7216,7223,7237,7255,7264,7269,7280,7285)
ORDER BY i.created DESC LIMIT 0, 3