Query Time: 4.02 ms After last query: 1.09 ms Query memory: 0.056 MB Memory before query: 5.044 MB Rows returned: 5
SELECT i.*, c.alias AS categoryalias
FROM rdnmc_k2_items AS i
LEFT JOIN rdnmc_k2_categories AS c
ON c.id = i.catid
WHERE i.published = 1
AND i.trash = 0
AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-05-06 11:11:16')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-05-06 11:11:16')
AND i.access IN(1,1,5)
AND i.language IN('en-GB', '*')
AND c.access IN(1,1,5)
AND c.language IN('en-GB', '*')
AND c.published = 1
AND c.trash = 0
AND i.id IN(2201,2202,2203,2204,2205,2206,2207,2208,2209,2210,2211,2212,2213,2214,2215,2216,2220,2221,2222,2223,2226,2227,2228,2229,2230,2231,2232,2233,2235,2237,2238,2239,2240,2241,2242,2243,2247,2248,2249,2250,2251,2252,2254,2255,2256,2257,2258,2259,2260,2261,2262,2263,2264,2265,2266,2267,2269,2271,2273,2274,2275,2276,2277,2278,2279,2280,2281,2283,2286,2287,2291,2293,2294,2296,2297,2298,2299,2300,2301,2302,2303,2305,2306,2309,2310,2311,2312,2313,2314,2315,2316,2317,2318,2319,2320,2321,2322,2323,2324,2325,2326,2327,2328,2329,2330,2331,2332,2333,2334,2335,2336,2337,2338,2339,2343,2344,2345,2346,2347,2348,2349,2350,2351,2352,2353,2354,2355,2357,2358,2359,2363,2364,2369,2372,2373,2374,2375,2376,2377,2378,2379,2380,2381,2382,2384,2388,2389,2390,2391,2393,2394,2395,2396,2397,2400,2405,2406,2407,2425,2426,2443,2455,2463,2469,2477,2504,2505,2506,2507,2508,2509,2511,2513,2514,2515,2516,2518,2519,2521,2523,2525,2527,2529,2530,2531,2532,2533,2536,2537,2539,2540,2541,2543,2544,2545,2546,2547,2548,2549,2550,2551,2552,2553,2554,2555,2556,2557,2558,2559,2560,2561,2562,2563,2564,2565,2566,2567,2568,2569,2570,2571,2572,2573,2574,2575,2576,2577,2580,2581,2582,2583,2585,2586,2587,2588,2589,2590,2591,2592,2593,2594,2595,2596,2597,2598,2599,2600,2601,2602,2603,2604,2605,2606,2607,2608,2609,2611,2612,2613,2614,2615,2617,2618,2620,2621,2622,2623,2624,2625,2626,2628,2629,2630,2631,2632,2633,2634,2635,2636,2637,2638,2639,2640,2641,2642,2643,2644,2645,2646,2648,2650,2651,2652,2653,2654,2655,2656,2657,2659,2660,2661,2662,2663,2664,2665,2666,2667,2668,2670,2671,2672,2673,2674,2675,2676,2677,2678,2679,2680,2681,2682,2683,2684,2689,2690,2691,2692,2693,2694,2695,2696,2697,2698,2699,2700,2701,2702,2704,2705,2706,2707,2708,2709,2712,2714,2715,2716,2717,2718,2719,2720,2721,2722,2723,2724,2725,2727,2732,2736,2739,2740,2742,2743,2745,2746,2748,2749,2750,2752,2753,2754,2755,2756,2757,2758,2759,2761,2762,2763,2764,2765,2767,2768,2769,2770,2771,2772,2773,2774,2775,2777,2778,2779,2780,2781,2782,2783,2784,2785,2786,2787,2788,2789,2790,2791,2792,2798,2799,2800,2801,2811,2812,2813,2814,2815,2816,2818,2819,2820,2821,2822,2823,2824,2825,2826,2827,2828,2829,2831,2832,2833,2834,2835,2836,2837,2838,2839,2840,2841,2842,2843,2844,2845,2846,2847,2848,2849,2850,2851,2855,2856,2857,2858,2859,2860,2861,2862,2863,2864,2865,2866,2867,2868,2869,2870,2871,2872,2873,2874,2875,2877,2878,2879,2882,2883,2884,2885,2886,2887,2888,2889,2890,2891,2892,2893,2894,2895,2896,2897,2898,2899,2900,2903,2921,2922,2924,2926,2927,2928,2929,2937,2938,2939,2940,2941,2942,2943,2946,2948,2949,2956,2962,2963,2969,2970,2971,2972,2973,2974,2975,2981,2982,2983,2984,2985,2988,2989,2990,2991,2992,2993,2994,2995,2996,3000,3001,3002,3003,3004,3005,3006,3007,3008,3015,3016,3017,3018,3019,3020,3021,3026,3027,3030,3036,3037,3038,3039,3040,3041,3042,3043,3044,3045,3046,3047,3062,3063,3064,3069,3077,3078,3079,3080,3081,3082,3091,3097,3100,3101,3102,3104,3105,3109,3110,3111,3114,3116,3120,3121,3122,3123,3126,3128,3132,3136,3139,3140,3146,3148,3151,3152,3153,3154,3155,3156,3157,3158,3159,3160,3161,3162,3163,3164,3171,3172,3174,3175,3180,3187,3189,3191,3196,3200,3202,3203,3204,3205,3206,3207,3208,3210,3212,3213,3214,3215,3216,3217,3219,3220,3222,3223,3224,3225,3226,3244,3245,3246,3247,3248,3250,3251,3252,3253,3254,3255,3257,3258,3259,3264,3268,3272,3274,3279,3281,3283,3284,3287,3289,3290,3294,3295,3297,3305,3312,3317,3319,3321,3327,3329,3331,3333,3338,3372,3402,3403,3405,3406,3407,3409,3429,3432,3433,3434,3435,3438,3440,3441,3442,3443,3444,3445,3455,3456,3457,3458,3459,3464,3468,3478,3479,3481,3502,3522,3602,3615,3619,3626,3639,3640,3643,3644,3645,3655,3658,3661,3668,3673,3676,3678,3679,3699,3700,3717,3727,3738,3746,3759,3782,3783,3784,3791,3814,3840,3859,3873,3886,3912,3919,3952,3961,3965,4025,4032,4062,4096,4121,4222,4230,4284,4286,4287,4292,4293,4294,4317,4361,4362,4420,4510,4513,4515,4516,4517,4518,4600,4732,4733,4734,4735,4750,4754,4757,4759,4853,4896,4938,4939,4963,4990,5008,5225,5449,5484,5488,5508,5544,5595,5654,5669,5766,5779,5803,5820,5826,6086,6088,6089,6090,6091,6092,6093,6097,6098,6153,6160,6206,6226,6239,6283,6288,6305,6321,6340,6362,6402,6410,6420,6436,6450,6455,6459,6460,6461,6466,6467,6469,6470,6473,6476,6480,6481,6482,6483,6484,6488,6489,6490,6491,6492,6498,6499,6500,6501,6502,6503,6504,6515,6540,6565,6580,6631,6664,6676,6695)
ORDER BY i.id DESC
LIMIT 0, 5| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i | NULL | range | PRIMARY,item,catid,language | PRIMARY | 4 | NULL | 864 | 0.12 | Using where |
| 1 | SIMPLE | c | NULL | eq_ref | PRIMARY,category,published,access,trash,language | PRIMARY | 4 | schelcol.i.catid | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.40 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.17 ms |
| System lock | 0.01 ms |
| optimizing | 0.05 ms |
| statistics | 2.19 ms |
| preparing | 0.63 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.28 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.06 ms |
| cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/itemlist.php:654 |
| 12 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:292 |
| 11 | K2ViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:19 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:78 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:64 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |