وقت الإستعلام: 5.23 ms قبل آخر إستعلام: 1.40 ms إستعلام الذاكرة: 0.010 MB الذاكرة بعد الإستعلام: 4.293 MB إرجاع الصفوف: 12
SELECT i.*, c.alias as categoryalias
FROM cafe_k2_items as i
LEFT JOIN cafe_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 <= '2018-04-22 04:43:45' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2018-04-22 04:43:45' )
AND i.access IN(1,1)
AND i.trash = 0
AND c.published = 1
AND c.access IN(1,1)
AND c.trash = 0
AND (i.id) IN (4232,4234,4238,4239,4243,1233,1236,1262,1258,1266,1269,1279,1283,1286,1289,1291,1295,1298,1300,1305,1312,1316,1318,1323,1635,1327,1332,1335,1337,1338,1342,1347,1348,1349,1354,1358,1366,1369,1372,1375,1377,1379,1382,1384,1388,1389,1390,1391,1394,1397,1398,1399,1402,1404,1405,1406,1408,1415,1416,1421,1425,1428,1430,1432,1438,1442,1448,1449,1458,1460,1461,1464,1467,1471,1473,1475,1476,1477,1479,1481,1482,1483,1486,1488,1490,1498,1500,1502,1503,1506,1511,1514,1517,1520,1521,1522,1525,1526,1530,1532,1533,1534,1538,1539,1541,1543,1545,1546,1548,1551,1552,1555,1559,1560,1561,1568,1569,1572,1573,1576,1581,1582,1586,1588,1590,1591,1596,1597,1599,1602,1607,1611,1613,1621,1622,1624,1625,1626,1627,1629,1630,1632,1637,1639,1642,1648,1653,1655,1656,1658,1659,1660,1661,1664,1666,1668,1671,1672,1674,1677,1678,1681,1686,1688,1689,1690,1692,1694,1695,1697,1698,1701,1703,1803,1705,1706,1708,1714,1716,1718,1719,1725,1727,1728,1729,1731,1735,1736,1740,1743,1745,1746,1749,1753,1754,1760,1762,1764,1769,1770,1772,1774,1779,1780,1781,1782,1785,1787,1788,1794,1795,1801,1804,1805,1808,1812,1814,1816,1820,1825,1826,1832,1834,1835,1839,1840,1841,1843,1844,1845,1846,1847,1851,1852,1855,1856,1858,1859,1864,1865,1866,1868,1869,1870,1871,1873,1874,1876,1882,1884,1887,1893,1895,1898,1903,1905,1908,1910,1911,1913,1914,1916,1917,1921,1922,1923,1924,1926,1928,1930,1932,1934,1935,1937,1939,1941,1942,1944,1945,1946,1947,1948,1949,1950,1952,1955,1957,1958,1959,1961,1964,1968,1969,1971,1972,1974,1975,1977,1981,1982,1984,1986,1987,1988,1989,1990,1993,1994,1996,1998,1999,2000,2003,2004,2008,2011,2012,2015,2016,2017,2019,2020,2021,2023,2025,2026,2027,2028,2029,2031,2033,2035,2038,2041,2042,2044,2046,2048,2049,2051,2052,2053,2055,2057,2058,2063,2064,2066,2070,2073,2076,2079,2082,2086,2088,2089,2091,2092,2094,2096,2098,2099,2100,2101,2103,2107,2109,2110,2113,2114,2115,2117,2119,2121,2124,2126,2127,2131,2132,2133,2136,2137,2138,2142,2144,2146,2147,2148,2149,2151,2152,2153,2155,2156,2158,2160,2163,2164,2166,2169,2171,2173,2174,2175,2177,2179,2181,2182,2184,2188,2190,2195,2196,2198,2200,2201,2203,2207,2208,2211,2212,2213,2215,2217,2219,2220,2224,2225,2226,2228,2230,2232,2233,2234,2236,2237,2239,2241,2242,2244,2247,2250,2254,2256,2262,2263,2264,2267,2274,2276,2278,2279,2282,2283,2284,2287,2289,2296,2297,2299,2300,2303,2304,2306,2308,2310,2312,2313,2323,2324,2333,2334,2335,2341,2344,2345,2347,2349,2351,2353,2355,2356,2359,2362,2368,2369,2371,2374,2377,2378,2379,2380,2384,2386,2388,2389,2391,2393,2395,2396,2401,2404,2406,2408,2410,2412,2413,2415,2416,2419,2421,2423,2426,2428,2430,2433,2434,2435,2438,2439,2440,2442,2444,2445,2447,2451,2452,2454,2458,2461,2462,2463,2465,2466,2468,2469,2473,2475,2476,2481,2483,2484,2485,2486,2489,2495,2496,2502,2503,2504,2506,2508,2509,2512,2513,2514,2515,2516,2517,2519,2520,2521,2522,2524,2525,2526,2527,2528,2530,2532,2533,2535,2536,2539,2540,2543,2546,2547,2548,2551,2553,2555,2556,2557,2559,2564,2566,2567,2570,2572,2573,2574,2576,2577,2578,2579,2582,2583,2584,2586,2588,2590,2591,2592,2594,2598,2600,2602,2603,2606,2607,2608,2610,2612,2613,2619,2621,2623,2625,2627,2629,2631,2633,2634,2635,2636,2638,2639,2640,2642,2643,2645,2647,2648,2652,2655,2657,2658,2660,2664,2665,2666,2668,2669,2671,2673,2675,2676,2677,2679,2680,2682,2684,2685,2687,2688,2693,2694,2696,2697,2701,2703,2705,2706,2708,2712,2714,2715,2716,2718,2719,2721,2722,2724,2726,2727,2729,2730,2732,2736,2737,2739,2745,2747,2751,2752,2754,2755,2759,2762,2764,2765,2768,4244,2772,2773,2775,2776,2777,2781,2782,2783,2784,2786,2787,2789,2790,2791,2792,2798,2803,2804,2805,2806,2808,2813,2814,2816,2818,2820,2821,2822,2825,2828,2831,2832,2834,2836,2840,2842,2843,2847,2848,2849,2855,2858,2861,2862,2863,2864,2866,2868,2870,2871,2873,2874,2882,2883,2884,2885,2886,2888,2891,2892,2893,2894,2897,2898,2899,2901,2902,2903,2906,2909,2910,2912,2915,2916,2917,2919,2921,2922,2928,2929,2930,2931,2933,2934,2936,2937,2940,2941,2942,2945,2946,2950,2952,2953,2956,2957,2959,2961,2963,2965,2967,2968,2970,2973,2977,2978,2980,2981,2983,2984,2987,2989,2992,2994,2995,2996,3001,3003,3004,3007,3010,3011,3014,3018,3022,3024,3025,3027,3028,3030,3032,3033,3034,3036,3038,3041,3042,3045,3048,3049,3051,3052,3055,3057,3060,3061,3063,3064,3066,3070,3071,3067,3073,3075,3077,3079,3080,3081,3082,3084,3086,3090,3096,3095,3099,3101,3104,3108,3111,3116,3117,3121,3126,3127,3133,3134,3135,3137,3139,3140,3141,3145,3148,3149,3151,3152,3154,3156,3158,3159,3160,3162,3167,3169,3170,3171,3172,3174,3176,3177,3179,3180,3181,3182,3183,3188,3189,3190,3191,3194,3196,3197,3198,3199,3200,3202,3204,3205,3206,3210,3214,3217,3218,3219,3220,3222,3226,3228,3229,3230,3232,3240,3241,3242,3244,3247,3252,3254,3256,3259,3260,3261,3262,3264,3265,3266,3269,3271,3273,4247,3278,3280,3281,3285,3286,3289,3291,3294,3295,3296,3298,3300,3302,3305,3310,3311,3314,3315,3316,3317,3318,3320,3321,3325,3327,3328,3329,3330,3332,3334,3335,3336,3341,3344,3345,3348,3349,3351,3354,3355,3358,3360,3362,3363,3366,3368,3369,3370,3372,3373,3374,3375,3377,3381,3386,3387,3389,4249,3392,3395,3396,3397,3402,3404,3405,3406,3408,3409,3410,3415,3416,3417,3418,3421,3426,3427,3428,3431,3432,3437,3440,3438,3444,3446,3449,3450,3451,3452,3453,3454,3458,3459,3460,3462,3464,3465,3466,3467,3472,3474,3479,3482,3483,3488,3491,3493,3494,3495,3496,3500,3501,3502,3504,3506,3509,3510,3516,3517,3519,4251,3521,3523,3526,3528,3532,3533,3534,3537,3538,3540,3542,3543,3545,3546,3548,3549,3550,3551,3552,3554,3558,3559,3562,3563,3564,4252,3570,3571,3573,3574,3576,3578,3581,3582,3583,3584,3585,3587,3588,3589,3590,3593,3594,3598,3600,3602,3604,3608,3611,3613,3617,3620,3621,3622,3624,3628,3630,3631,3632,3634,3638,3641,3643,3647,3652,3656,3659,3661,3662,3666,4257,3672,3673,3675,3677,3680,3681,3682,3684,3685,3687,3688,3691,3693,3694,3696,3697,3698,3699,3701,3702,3704,3706,3707,3709,3710,3711,3712,3714,3715,3717,3719,3721,3723,3727,3729,3730,3733,3734,3737,3738,3740,3742,3743,3746,3748,3749,3750,3751,3753,3754,3756,3757,3759,3762,3763,3764,3765,3771,3774,3776,3778,3781,3783,3785,3787,3788,3792,3796,3798,3800,3803,3809,3811,3814,3815,3817,3818,3819,3821,3824,3827,3829,3830,3832,3834,3837,3839,3841,3842,4258,3845,3849,3850,3852,3854,3857,3980,3978,3858,3859,3860,3862,3864,3865,3868,4261,3870,3873,3874,3876,3881,3884,3887,3888,3890,4264,3895,3896,3898,3899,3901,3902,3903,3905,3906,3908,3911,3913,3914,3916,3917,3923,3924,3926,3927,3929,3931,3932,3934,3937,3938,3939,3941,3942,3943,3944,3946,3949,3951,3954,3955,3956,3957,4266,3962,3963,3965,3968,3969,3970,3972,3973,3975,4268,3977,3981,3985,3987,3991,3992,3994,3995,4000,4003,4005,4008,4010,4011,4016,4017,4021,4022,4024,4027,4030,4031,4034,4038,4039,4040,4042,4043,4044,4047,4048,4050,4051,4054,4058,4060,4061,4067,4069,4072,4074,4076,4077,4078,4080,4081,4085,4086,4088,4089,4091,4092,4094,4096,4098,4099,4102,4103,4104,4105,4108,4110,4112,4113,4114,4115,4117,4119,4120,4124,4127,4129,4134,4135,4136,4137,4287,4139,4140,4269,4144,4145,4147,4149,4152,4153,4154,4160,4162,4163,4165,4168,4172,4173,4174,4177,4179,4180,4183,4184,4186,4188,4189,4190,4192,4193,4195,4197,4198,4200,4203,4205,4206,4207,4211,4213,4216,4217,4222,4223,4225,4227,4229,4231,4273,4274,4275,4277,4279,4281,4282,4283,4285,4290,4296,4299,4300,4302,4305,4307,4308,4310,4312,4313,4318,4319,4322,4324,4329,4330,4331,4332,4335,4336,4339,4340,4343,4345,4346,4348,4349,4352,4353,4355,4356,4357,4358,4361,4363,4366,4368,4371,4372,4376,4377,4380,4382,4384,4387,4388,4389,4391,4392,4393,4394,4395,4396,4398,4401,4404,4410,4411,4413,4415,4420,4423,4427,4429,4433,4437,4440,4442,4443,4444,4446,4447,4448,4450,4452,4454,4456,4457,4458,4461,4462,4464,4465,4472,4474,4477,4478,4480,4484,4486,4488,4495,4604,4505,4496,4497,4498,4503,4504,4509,4510,4513,4516,4517,4521,4522,4526,4527,4533,4534,4537,4543,4544,4546,4549,4552,4553,4556,4559,4561,4562,4564,4567,4569,4572,4577,4581,4582,4585,4587,4588,4590,4592,4594,4599,4606,4607,4612,4615,4619,4621,4622,4623,4624,4625,4627,4629,4630,4631,4632,4633,4634,4638,4639,4641,4644,4645,4648,4651,4652,4653,4655,4657,4659,4660,4662,4664,4666,4667,4668,4669,4672,4674,4675,4676,4678,4679,4682,4684,4685,4687,4688,4690,4691,4692,4693,4695,4696,4698,4699,4701,4702,4703,4704,4705,4708,4709,4710,4711,4712,4714,4717,4720,4721,4726,4727,4730,4731,4732,4734,4736,4738,4739,4740,4741,4742,4743,4744,4747,4753,4754,4757,4758,4760,4761,4762,4763,4768,4769,4770,4774,4776,4777,4778,4780,4781,4783,4785,4788,4789,4790,4792,4793,4795,4797,4798,4799,4801)
ORDER BY i.created DESC
LIMIT 0, 12
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | i | index | PRIMARY,item,catid | created | 8 | NULL | 12 | Using where |
1 | SIMPLE | c | eq_ref | PRIMARY,category,published,access,trash | PRIMARY | 4 | cafesport.i.catid | 1 | Using where |
Status | Duration |
---|
starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
checking query cache for query | 0.76 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
System lock | 0.01 ms |
Waiting for query cache lock | 0.12 ms |
init | 0.35 ms |
optimizing | 0.08 ms |
statistics | 2.49 ms |
preparing | 0.17 ms |
executing | 0.01 ms |
Sorting result | 0.01 ms |
Sending data | 0.18 ms |
Waiting for query cache lock | 0.01 ms |
Sending data | 0.18 ms |
Waiting for query cache lock | 0.01 ms |
Sending data | 0.19 ms |
Waiting for query cache lock | 0.01 ms |
Sending data | 0.15 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
Waiting for query cache lock | 0.01 ms |
freeing items | 0.04 ms |
Waiting for query cache lock | 0.01 ms |
freeing items | 0.00 ms |
storing result in query cache | 0.01 ms |
logging slow query | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/itemlist.php:975 |
12 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:306 |
11 | K2ViewItem->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:80 |
8 | K2ControllerItem->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:394 |
5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |