Χρόνος επερώτησης:39.66 ms Μετά την τελευταία επερώτηση:0.41 ms Μνήμη με επερώτηση: 0.081 MB Μνήμη πριν την επερώτηση: 3.825 MB Σειρές που επιστράφηκαν:6
SELECT i.*, c.alias as categoryalias
FROM plzh7_k2_items as i
LEFT JOIN plzh7_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 <= '2026-04-02 20:48:08' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-04-02 20:48:08' )
AND i.access IN(1,1,5)
AND i.trash = 0
AND c.published = 1
AND c.access IN(1,1,5)
AND c.trash = 0
AND (i.id) IN (38,59,84,418,463,466,470,469,464,478,488,503,507,576,598,609,610,611,612,614,617,622,626,627,638,639,646,650,657,675,677,688,693,700,711,685,718,721,737,742,752,758,757,770,772,773,774,780,781,790,800,809,816,840,842,856,870,916,918,921,930,952,961,970,979,990,1021,1056,1078,1097,1134,1135,864,1158,1177,1221,1242,1271,1276,1297,1324,1338,1391,1394,1414,1441,1461,1473,1576,1601,1638,1658,1664,1688,1769,1776,1796,1798,1802,1840,1878,1897,1911,1930,1947,1960,1983,2011,2024,1035,748,730,645,462,2121,2122,2149,2156,2157,2170,2182,2192,2280,2327,2340,2490,2507,2519,2535,2553,2554,2561,2565,2610,2611,2609,2604,2625,2672,2715,1902,1874,1472,713,2800,2805,2808,2831,2932,2950,2960,2980,2988,2989,3014,3030,2683,1490,3055,3071,3070,3084,340,291,426,600,500,606,603,590,599,584,608,504,3149,3167,3187,3193,3200,3211,1092,3240,637,1692,3365,3380,3387,3394,3395,3396,3405,3410,3415,3419,3420,3421,3436,3448,3455,3464,3467,3479,3483,3485,3493,3503,3511,3515,3520,3526,3552,3559,3558,3570,3580,3584,3599,3573,3545,2762,2613,2219,1095,3409,1197,3217,3605,3607,3586,3612,3613,3614,3617,3618,3620,3621,3634,3643,3644,3645,3669,3671,3677,3684,3687,3686,3693,3695,3705,3707,3709,3714,3718,3721,3723,3727,3730,3732,3735,3741,3743,3754,3755,3760,3768,3769,3773,3772,3790,3796,3801,3808,3813,3814,3815,3817,3820,3823,3834,3836,3842,3844,3845,3848,3858,3864,3866,3873,3883,3887,3889,3897,3901,3909,3914,3919,3922,3926,3927,3937,3942,3946,3955,3970,3971,3566,3984,3987,3993,3994,4002,4006,4012,4013,4020,4029,4031,4034,4035,4037,4047,4055,4058,4060,4070,4085,4086,4092,4096,4112,4122,4127,649,4146,4157,4169,4177,4183,4184,4191,4200,4221,4229,4222,4235,4236,4246,4264,4271,4276,4293,4298,4301,4302,4309,4316,4325,4326,4331,4334,4338,4346,4347,4349,4351,4356,4358,4362,4365,4369,4371,4372,4390,2612,4407,4458,4461,4471,4472,4481,4511,4518,4528,4529,4542,4563,4570,4580,4607,4611,4551,4617,4626,4640,4651,4671,4692,4702,4625,4716,4727,4745,4741,4764,4780,4784,4790,4816,4839,4906,4916,4928,4954,4973,4982,4986,5007,5019,5037,5049,5054,5062,5071,5089,5106,5112,5120,5144,5166,5222,5224,5190,5105,5246,5260,5323,5357,5388,5431,5432,5467,5529,5575,5576,5620,5625,5679,5693,5763,5774,5794,5818,5830,5856,6016,6069,6089,6106,6129,6142,6165,6178,6204,6279,6372,6676,6741,6758,6313,6812,6859,6879,7180,7227,7271,7279,7283,7313,7315,7320,7341,7345,7368,7370,7376,7413,7440,7445,7487,7495,7496,7498,7555,7560,7579,7584,7587,7641,7644,7646,7648,7652,7667,7669,7685,7692,7698,7706,7726,7766,7800,7802,7823,7826,7831,7843,7848,7864,7881,7888,7906,7907,7909,7916,7956,7963,7970,7974,8024,8032,8051,8058,8073,8077,8088,8095,8097,8116,8145,8170,8198,8204,8205,8209,8213,8225,8228,8238,8252,8257,8258,8260,8267,8286,8304,8334,8347,8357,8380,8390,8413,8427,8466,8480,8492,8509,8524,8529,8577,8584,8639,8690,8693,8708,8730,8743,8756,8757,8776,8786,8797,8827,8828,8860,8884,8889,8893,8894,8901,8903,8919,8933,8974,8979,8988,8992,8996,9008,9047,9065,9072,9073,9077,9084,9101,9118,9148,9152,9207,9221,9257,9274,9327,9330,9359,9411,9518,9571,9580,9594,9619,9623,9630,9665,9682,9844,9871,9873,9895,9900,9915,9916,9917,9956,10000,10012,10061,10103,10108,10165,10171,10213,10261,10324,10357,10379,69,389,448,460,495,619,625,642,703,731,751,784,789,848,862,894,943,945,946,955,1009,1050,1053,1057,1071,1087,1193,1176,1241,1331,1374,1402,1433,1445,1451,1458,1459,1504,1519,1561,1585,1606,1659,1661,1855,1891,2031,2040,2051,2123,2165,2167,2287,2298,2317,2332,2361,2402,2411,2434,2526,2551,2564,2563,2577,2580,2709,2713,1686,2765,2905,2913,2993,2997,2436,1170,934,3063,3074,27,289,615,3127,3153,3161,3201,395,1268,1636,1985,1536,2811,3275,3392,3443,3457,3471,3533,3544,3563,3557,3581,3574,3531,3307,2455,3600,3601,3608,3609,3587,3616,3575,3739,3746,3761,3831,3850,3851,3860,3893,3908,3912,3938,3939,3951,3976,3980,3983,3995,4010,4018,4026,4028,4043,4052,4063,4071,4073,4098,4111,4119,4121,4129,4138,4145,4190,4195,4208,4213,4214,4218,4223,4228,4244,4253,4263,4280,4284,4288,4295,4320,4350,4363,4380,4382,4408,4416,4417,4423,4436,4438,4440,4452,2952,4462,4476,4490,4493,4505,4535,4545,4569,4576,4629,4668,4682,4746,4750,4759,4769,4793,4833,4851,4919,4981,4996,5086,5107,5198,5293,5424,5458,5482,5543,5584,5580,5614,5624,5634,5645,5651,5656,5671,5676,5730,5733,5746,5749,5859,5970,5975,6046,6053,6058,6071,6111,6150,6154,6171,6269,6351,6361,6374,6507,6525,6577,6594,6597,6601,6616,6626,6633,6638,6666,6667,6673,6675,6682,6699,6717,6729,6736,6739,6755,6760,6767,6775,6777,6781,6805,6809,6832,6830,6844,6847,6849,6866,7022,7037,7116,6783,7183,7223,7240,7249,7251,7267,7269,7291,7321,7329,7347,7352,7393,7407,7419,7424,7426,7448,7459,3534,7563,7586,7589,7593,7612,7615,7632,7656,7666,7690,7700,7729,7734,7738,7742,7745,7759,7761,7786,7813,7816,7820,7825,7834,7858,7875,7882,7903,7918,7939,7944,7945,7949,7992,8002,8009,8010,8014,8017,8018,8067,8074,8080,8100,8101,8105,8106,8107,8111,8113,8115,8118,8127,8132,8135,8140,8143,8147,8148,8150,8156,8157,8182,8186,8193,8194,8217,8219,8220,8241,8249,8253,8254,8269,8270,8275,8278,8281,8295,8307,8329,8335,8354,8364,8377,8378,8379,8388,8392,8394,8401,8410,8416,8420,8425,8430,8440,8456,8482,8486,8497,8498,8528,8532,8540,8544,8557,8560,8578,8587,8592,8596,8604,8617,8618,8622,8666,8687,8733,8734,8750,8758,8764,8766,8780,8782,8787,8812,8816,8817,8845,8852,8874,8878,8887,8892,8906,8918,8940,8949,8954,8965,8970,8981,8983,8985,8993,9006,9010,9023,9029,9039,9055,9057,9074,9075,9078,9086,9087,9092,9113,9121,9125,9126,9140,9146,9165,9177,9228,9236,9243,9253,9284,9292,9297,9340,9348,9355,9372,9378,9380,9401,9407,9417,9449,9466,9468,9481,9494,9508,9534,9555,9578,9590,9602,9605,9612,9629,9633,9636,9640,9645,9651,9655,9662,9689,9691,9694,9696,9698,9709,9717,9737,9742,9755,9760,9771,9795,9811,9815,9817,9823,9841,9858,9862,9874,9884,9914,9931,9935,9952,9954,9971,9994,10013,10020,10022,10030,10035,10056,10104,10114,10115,10122,10137,10159,10176,10178,10179,10189,10208,10221,10242,10248,10291,10294,10299,10875,982,991,1094,1243,1755,1890,1959,2004,2145,2593,2836,2894,55,3056,3096,3136,3178,3182,3191,2104,2558,3346,3422,3439,3470,3501,3731,3742,3835,3899,3900,3916,3945,4124,4130,4133,4262,940,3469,4430,4447,4496,4605,4663,4737,4748,4942,5097,5104,5172,5187,5208,5153,5288,5393,5423,5491,5512,5539,5590,5718,5813,5868,5895,5906,5980,6075,6127,6203,6319,6661,6670,6771,6785,6846,7234,7281,7404,7428,7557,7562,7582,7603,7625,7635,7671,7732,7854,7866,7874,7885,7893,7947,7987,7991,8021,8043,8094,8098,8109,8112,8266,8287,8340,8349,8387,8449,8459,8485,8555,8572,8601,8627,8651,8741,8867,8871,8924,9003,9160,9268,9461,9683,9799,9959,10025,10188,10339,72,406,630,727,895,1409,1419,1457,1515,1768,1777,1833,1988,2273,3190,3223,3358,3454,3676,3839,3871,3882,3885,3886,3929,3953,3986,4007,4030,4039,4061,4067,4069,4084,4113,4171,4192,4193,4211,4231,4313,4317,4381,4428,2272,4507,4512,4514,4522,4526,4533,4539,4540,4558,4616,4998,5046,5117,5195,5283,5313,5417,5661,5690,5878,5996,6001,6084,6267,6603,6611,6714,5400,7181,7192,7231,7248,7406,7461,7614,7668,7682,7728,7778,7819,7851,7902,7946,7972,8001,8025,8064,8212,8229,8262,8332,8352,8369,8376,8541,8546,8554,8558,8628,8644,8650,8718,8769,8785,8798,8824,8872,8963,9037,9104,9108,9283,9299,9357,9464,9476,9532,9676,9735,9744,9781,9797,9836,9860,9894,9926,10055,10062,10107,10207,949,1408,1704,1808,2065,2697,401,2049,1166,3477,3592,815,2066,3715,3767,3903,4556,4619,4934,5294,5332,5951,7163,8839,8873,8934,9445,9675,9876,10227)
ORDER BY i.created DESC
LIMIT 0, 6
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | <subquery2> | ALL | distinct_key | ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ | NULL | NULL | 1489 | Using temporary; Χρήση ταξινόμησης αρχείου |
| 1 | PRIMARY | i | eq_ref | PRIMARY,item,catid | PRIMARY | 4 | tvc_0._col_1 | 1 | Using where |
| 1 | PRIMARY | c | eq_ref | PRIMARY,category,published,access,trash | PRIMARY | 4 | ifitness_ifitnew.i.catid | 1 | Using index condition; Using where |
| 2 | MATERIALIZED | <derived3> | ALL | NULL | ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ | NULL | NULL | 1489 | |
| 3 | DERIVED | NULL | NULL | NULL | ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ | NULL | NULL | NULL | No tables used |
| Status | Duration |
|---|
| Starting | 0.91 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.42 ms |
| Optimizing | 0.23 ms |
| Statistics | 0.11 ms |
| Preparing | 0.04 ms |
| Creating tmp table | 0.03 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.19 ms |
| Removing tmp table | 0.01 ms |
| Sending data | 31.93 ms |
| Creating sort index | 4.99 ms |
| Removing tmp table | 0.50 ms |
| Creating sort index | 0.02 ms |
| End of update loop | 0.02 ms |
| Removing tmp table | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| closing tables | 0.00 ms |
| Removing tmp table | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.06 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/itemlist.php:975 |
| 13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:306 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 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:59 |