وقت الإستعلام: 7.05 ms قبل آخر إستعلام: 1.61 ms إستعلام الذاكرة: 0.010 MB الذاكرة بعد الإستعلام: 4.317 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:55:10' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2018-04-22 04:55:10' )
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,4233,4235,4236,4237,4239,4240,4241,4242,1234,1226,1218,1246,1248,1249,1256,1259,1268,1274,1277,1280,1281,1283,1285,1291,1292,1297,1300,1303,1307,1314,1315,1321,1634,1331,1333,1335,1326,1341,1345,1348,1351,1353,1355,1357,1363,1365,1375,1377,1378,1381,1382,1385,1387,1388,1390,1392,1395,1396,1397,1398,1400,1401,1403,1406,1411,1414,1418,1420,1421,1422,1427,1433,1440,1441,1445,1453,1456,1462,1467,1468,1474,1475,1476,1477,1480,1482,1487,1489,1491,1493,1494,1496,1498,1500,1508,1509,1512,1517,1519,1524,1525,1528,1529,1530,1531,1533,1534,1535,1536,1537,1540,1544,1545,1547,1551,1554,1556,1562,1563,1565,1566,1567,1570,1571,1574,1575,1576,1580,1579,1582,1583,1586,1587,1589,1593,1594,1598,1599,1601,1607,1608,1610,1612,1616,1617,1619,1621,1623,1625,1626,1628,1629,1631,1632,1633,1636,1637,1638,1641,1642,1643,1645,1646,1647,1649,1650,1651,1652,1653,1654,1655,1656,1657,1660,1663,1665,1667,1669,1670,1672,1673,1675,1676,1677,1678,1681,1682,1683,1684,1685,1686,1687,1689,1691,1693,1694,1695,1698,1701,1702,1704,1706,1707,1708,1709,1710,1711,1713,1715,1716,1717,1718,1719,1721,1722,1724,1726,1729,1730,1731,1733,1735,1737,1739,1743,1744,1745,1747,1748,1750,1751,1752,1755,1756,1761,1762,1763,1765,1766,1767,1768,1769,1771,1772,1773,1775,1777,1778,1780,1783,1785,1786,1787,1789,1790,1791,1792,1793,1794,1796,1800,1802,1806,1807,1808,1809,1811,1813,1815,1817,1818,1819,1821,1824,1826,1827,1831,1833,1835,1836,1841,1842,1844,1847,1848,1853,1854,1857,1858,1860,1863,1865,1867,1868,1871,1873,1874,1875,1877,1878,1879,1881,1884,1886,1887,1889,1890,1892,1894,1896,1897,1899,1900,1901,1902,1905,1906,1907,1910,1912,1913,1915,1917,1918,1921,1922,1923,1925,1926,1927,1929,1931,1933,1935,1936,1937,1940,1944,1945,1946,1947,1949,1950,1951,1952,1953,1954,1956,1958,1959,1960,1961,1962,1965,1966,1967,1968,1969,1970,1972,1973,1975,1976,1978,1979,1981,1987,1988,1989,1990,1992,1996,1997,1999,2001,2002,2003,2005,2007,2009,2010,2011,2012,2013,2014,2016,2018,2020,2022,2024,2025,2026,2027,2028,2029,2030,2032,2033,2034,2037,2039,2040,2043,2044,2045,2048,2049,2052,2054,2056,2057,2059,2061,2062,2064,2066,2069,2070,2071,2074,2075,2076,2077,2081,2083,2084,2085,2088,2089,2090,2091,2093,2096,2097,2098,2099,2100,2101,2102,2104,2109,2111,2113,2114,2116,2117,2118,2120,2121,2122,2123,2131,2133,2134,2135,2136,2138,2139,2141,2143,2145,2146,2147,2148,2150,2151,2152,2153,2154,2157,2158,2159,2161,2163,2164,2165,2167,2169,2170,2172,2176,2177,2178,2180,2181,2183,2185,2187,2188,2189,2191,2192,2193,2195,2197,2199,2202,2203,2204,2205,2206,2207,2209,2210,2213,2214,2216,2218,2219,2222,2223,2225,2227,2229,2230,2231,2232,2234,2235,2237,2238,2240,2243,2244,2245,2249,2251,2252,2253,2255,2263,2265,2271,2272,2274,2275,2279,2280,2281,2283,2285,2286,2287,2288,2290,2292,2293,2295,2297,2298,2300,2302,2304,2305,2307,2309,2311,2312,2314,2315,2318,2322,2323,2325,2326,2328,2330,2332,2334,2336,2337,2340,2342,2343,2346,2348,2349,2350,2352,2354,2357,2358,2359,2362,2363,2365,2366,2370,2371,2372,2373,2375,2376,2378,2381,2382,2387,2390,2391,2392,2395,2400,2402,2403,2405,2407,2409,2411,2413,2414,2417,2418,2422,2423,2424,2427,2428,2429,2431,2432,2434,2436,2437,2439,2441,2443,2445,2446,2448,2450,2452,2453,2455,2459,2460,2462,2464,2465,2466,2467,2469,2472,2473,2474,2478,2479,2482,2484,2487,2489,2490,2494,2495,2499,2500,2501,2502,2503,2504,2505,2508,2511,2513,2518,2520,2523,2524,2525,2526,2528,2529,2531,2532,2533,2534,2538,2542,2544,2545,2547,2550,2552,2553,2554,2557,2558,2563,2564,2565,2567,2569,2571,2572,2574,2575,2577,2578,2580,2581,2583,2587,2589,2590,2592,2593,2594,2595,2596,2597,2599,2600,2601,2602,2605,2608,2611,2612,2613,2617,2621,2622,2623,2624,2625,2626,2627,2630,2636,2637,2639,2641,2644,2645,2646,2649,2651,2652,2656,2657,2659,2661,2662,2663,2664,2665,2667,2668,2669,2672,2673,2674,2675,2678,2679,2681,2682,2683,2685,2686,2687,2689,2691,2692,2695,2696,2698,2702,2704,2705,2707,2708,2712,2713,2714,2715,2716,2719,2720,2722,2726,2727,2728,2730,2731,2733,2735,2737,2738,2742,2743,2744,2746,2747,2748,2750,2752,2753,2755,2757,2761,2762,2763,2765,2767,2770,4244,2772,2776,2779,2781,2783,2784,2785,2788,2789,2792,2795,2796,2797,2799,2800,2801,2803,2804,2807,2809,2811,2812,2814,2815,2817,2819,2821,2822,2823,2824,2829,2830,2832,2833,2839,2841,2843,2845,2846,2847,2849,2850,2851,2854,2855,2856,2858,2859,2861,2862,2863,2866,2867,2869,2870,2871,2873,2875,2876,2879,2880,2881,2882,2884,2885,2888,2889,2894,2896,2898,2900,2901,2904,2907,2909,2910,2913,2914,2918,2919,2920,2924,2926,2927,2929,2932,2933,2938,2939,2941,2943,2944,2950,2954,4245,2958,2960,2966,2968,2969,2970,2972,2974,2979,2981,2982,2985,2986,2988,2991,2992,2993,2996,2997,2998,2999,3002,3003,3006,3009,3011,3016,3017,3021,3023,3024,3026,3028,3031,3032,3037,3039,3044,3048,3049,3050,3054,3056,3057,3058,3062,3063,3065,3066,3069,3071,3072,3074,3076,3078,3079,3081,3082,3087,3088,3091,3094,3097,3095,3098,3099,3100,3101,3105,3106,3107,3108,3110,3112,3115,3116,3117,3118,3123,3125,3127,3129,3132,3133,3134,3138,3139,3144,3145,3147,3149,3150,3151,3153,3154,3156,3157,3159,3160,3161,3162,3166,3169,3173,3174,3175,3177,3179,3180,3181,3183,4246,3187,3189,3190,3191,3193,3194,3195,3197,3198,3199,3201,3203,3205,3207,3209,3210,3213,3216,3219,3220,3221,3222,3227,3229,3230,3231,3232,3233,3234,3238,3239,3240,3241,3243,3245,3246,3248,3251,3254,3255,3258,3260,3261,3263,3264,3266,3267,3270,3271,3272,3273,3276,4247,3278,3279,4248,3283,3284,3285,3286,3287,3288,3290,3294,3295,3297,3299,3300,3301,3303,3304,3306,3307,3309,3311,3313,3315,3318,3319,3320,3322,3323,3324,3326,3327,3329,3331,3332,3333,3336,3337,3341,3342,3343,3345,3347,3350,3352,3354,3355,3359,3360,3361,3364,3365,3367,3371,3372,3373,3374,3377,3379,3382,3383,3386,3387,3388,3389,4251,4250,3392,3393,3394,3396,3397,3400,3401,3402,3407,3409,3411,3416,3422,3423,3426,3427,3429,3430,3432,3435,3438,3441,3442,3444,3447,3448,3450,3451,3457,3458,3459,3460,3463,3464,3465,3467,3474,3475,3479,3480,3484,3488,3492,3494,3495,3496,3497,3501,3502,3503,3504,3505,3507,3508,3509,3511,3512,3515,3518,3519,3522,3523,3525,3529,3531,3533,3538,3539,3541,3542,3543,3544,3547,3549,3550,3551,3552,3556,3557,3561,3564,3565,3568,4254,4253,3570,3573,3574,3575,3576,3577,3581,3582,3583,3584,3586,3588,3589,3590,3591,3592,3593,3594,3596,3597,3599,3600,3603,3605,3606,3610,3611,3612,3614,3616,3619,3620,3622,3623,3626,3627,3629,3630,3631,3632,3633,3636,3638,3640,3642,3643,3646,3648,3650,3651,3652,3653,3657,3658,3660,3661,3663,3665,4256,3670,3671,3673,3676,3678,3679,3680,3681,3683,3684,3685,3686,3687,3688,3689,3691,3692,3694,3695,3697,3698,3701,3702,3705,3708,3710,3711,3713,3714,3716,3717,3718,3720,3722,3724,3723,3725,3726,3728,3729,3732,3733,3735,3736,3738,3739,3742,3743,3744,3747,3748,3749,3750,3751,3752,3754,3755,3758,3760,3761,3763,3764,3766,3767,3769,3770,3772,3775,3776,3777,3780,3782,3783,3784,3786,3787,3789,3790,3793,3795,3797,3798,3799,3802,3803,3804,3805,3806,3810,3811,3812,3813,3815,3816,3818,3819,3820,3823,3824,3826,3827,3828,3830,3831,3833,3834,3835,3836,3838,3840,3841,3843,3848,3849,3850,3851,3853,3854,3856,3979,3858,3859,3861,3863,3864,3866,4263,4261,4259,3870,3871,3873,3875,3876,3877,3880,3882,3884,3886,3885,3887,3889,3890,3892,3893,4264,3895,3896,3897,3899,3900,3902,3904,3905,3906,3907,3909,3910,3912,3914,3915,3916,3920,3921,3923,3925,3927,3928,3930,3931,3932,3933,3934,3935,3936,3938,3939,3940,3942,3943,3945,3948,3950,3951,3953,3955,3956,3957,3958,3960,4267,4266,3962,3964,3965,3967,3969,3970,3971,3972,3973,3974,3977,3980,3982,3984,3986,3987,3988,3990,3992,3993,3996,3997,3998,4000,4002,4004,4005,4008,4009,4011,4012,4013,4018,4020,4022,4023,4028,4029,4031,4032,4035,4036,4041,4042,4046,4047,4048,4049,4051,4052,4053,4055,4058,4059,4061,4064,4065,4066,4070,4071,4072,4073,4075,4076,4077,4079,4080,4081,4083,4085,4088,4090,4091,4092,4094,4095,4097,4098,4099,4100,4101,4103,4105,4109,4110,4111,4113,4115,4116,4117,4118,4120,4122,4123,4124,4125,4126,4130,4132,4133,4136,4137,4138,4286,4139,4140,4143,4144,4145,4269,4147,4148,4151,4152,4154,4157,4161,4162,4164,4166,4168,4169,4171,4174,4176,4177,4178,4179,4183,4185,4186,4187,4189,4192,4193,4194,4196,4197,4199,4200,4204,4206,4210,4212,4213,4215,4217,4218,4219,4221,4222,4224,4225,4228,4231,4270,4272,4273,4276,4278,4279,4280,4281,4285,4289,4290,4291,4292,4293,4299,4300,4301,4304,4306,4307,4309,4310,4311,4313,4314,4316,4317,4319,4320,4323,4324,4325,4328,4330,4334,4335,4338,4339,4341,4342,4343,4344,4345,4349,4351,4353,4355,4357,4358,4360,4361,4364,4367,4368,4369,4370,4371,4374,4375,4376,4378,4379,4381,4383,4384,4385,4386,4387,4390,4391,4392,4394,4395,4397,4400,4401,4402,4403,4406,4407,4409,4410,4411,4412,4414,4416,4418,4420,4422,4424,4426,4428,4429,4432,4433,4436,4441,4443,4445,4449,4450,4451,4453,4455,4456,4457,4458,4459,4461,4463,4464,4466,4470,4471,4473,4474,4475,4476,4478,4482,4483,4484,4487,4489,4491,4492,4494,4495,4604,4496,4500,4501,4504,4506,4507,4508,4510,4512,4513,4514,4515,4520,4521,4523,4524,4525,4527,4528,4530,4532,4534,4535,4538,4541,4542,4543,4544,4545,4547,4551,4552,4553,4554,4557,4558,4559,4563,4565,4568,4569,4571,4573,4574,4575,4576,4578,4580,4581,4582,4584,4589,4590,4591,4593,4595,4598,4602,4603,4605,4606,4607,4608,4609,4610,4611,4615,4616,4617,4620,4622,4623,4626,4627,4628,4630,4631,4632,4635,4636,4637,4638,4639,4640,4642,4643,4647,4648,4649,4650,4651,4653,4654,4655,4657,4658,4659,4663,4664,4665,4666,4667,4669,4670,4671,4672,4673,4674,4675,4677,4680,4681,4682,4684,4686,4687,4689,4691,4692,4694,4695,4696,4697,4698,4699,4700,4702,4704,4705,4706,4707,4708,4709,4710,4713,4714,4716,4717,4719,4720,4722,4726,4727,4728,4729,4730,4731,4733,4734,4735,4737,4738,4740,4741,4742,4744,4745,4746,4747,4748,4749,4752,4753,4754,4755,4757,4758,4759,4760,4761,4762,4763,4764,4765,4767,4768,4770,4771,4772,4773,4775,4777,4778,4779,4780,4782,4783,4785,4786,4787,4789,4791,4793,4794,4796,4798,4800)
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.01 ms |
Waiting for query cache lock | 0.01 ms |
checking query cache for query | 0.73 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.15 ms |
init | 0.38 ms |
optimizing | 0.08 ms |
statistics | 2.29 ms |
preparing | 0.33 ms |
executing | 0.01 ms |
Sorting result | 0.01 ms |
Sending data | 0.26 ms |
Waiting for query cache lock | 0.01 ms |
Sending data | 0.10 ms |
Waiting for query cache lock | 0.01 ms |
Sending data | 1.82 ms |
Waiting for query cache lock | 0.01 ms |
Sending data | 0.11 ms |
Waiting for query cache lock | 0.01 ms |
Sending data | 0.09 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.01 ms |
Waiting for query cache lock | 0.00 ms |
freeing items | 0.00 ms |
storing result in query cache | 0.01 ms |
logging slow query | 0.00 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 |