Χρόνος επερώτησης:32.92 ms Μετά την τελευταία επερώτηση:1.14 ms Μνήμη με επερώτηση: 0.101 MB Μνήμη πριν την επερώτηση: 3.781 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-05-04 05:43:59' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-05-04 05:43:59' )
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 (59,69,389,448,460,463,495,576,598,609,611,614,619,625,626,627,639,642,650,657,693,700,703,711,685,721,731,737,751,758,770,773,774,780,784,789,790,816,848,862,894,943,945,946,955,1009,1050,1053,1057,1071,1087,864,1177,1193,1176,1241,1331,1338,1374,1394,1402,1414,1433,1445,1451,1458,1459,1504,1519,1561,1585,1606,1659,1661,1855,1891,1947,1983,2031,2040,2051,748,2123,2165,2167,2170,2182,2287,2298,2317,2332,2361,2402,2411,2434,2519,2526,2551,2554,2564,2563,2577,2580,2604,2709,2713,1902,1686,2765,2905,2913,2993,2997,2436,1170,934,3063,3074,27,289,615,603,590,599,608,504,3127,3153,3161,3187,3201,3211,395,1268,1636,1985,1536,2811,637,3275,3365,3392,3443,3457,3471,3520,3533,3544,3552,3563,3558,3557,3570,3581,3574,3545,3531,3307,2455,3217,3600,3601,3605,3607,3608,3609,3587,3616,3575,3705,3707,3718,3721,3723,3735,3739,3741,3746,3761,3768,3769,3772,3813,3815,3823,3831,3844,3845,3848,3850,3851,3860,3866,3873,3887,3893,3901,3908,3909,3912,3927,3938,3939,3946,3951,3976,3566,3980,3983,3984,3994,3995,3997,4002,4006,4010,4012,4013,4018,4020,4026,4028,4029,4034,4035,4043,4047,4052,4055,4063,4070,4071,4073,4092,4098,4111,4119,4121,4127,4129,4138,649,4145,4146,4157,4190,4195,4208,4213,4214,4218,4223,4228,4229,4236,4244,4253,4263,4264,4271,4280,4284,4288,4293,4295,4301,4316,4320,4325,4326,4334,4338,4349,4350,4351,4356,4358,4363,4369,4371,4372,4380,4382,4390,4407,4408,4416,4417,4423,4436,4438,4440,4452,2952,4461,4462,4476,4481,4490,4493,4505,4511,4529,4535,4545,4563,4569,4570,4576,4629,4640,4668,4682,4746,4750,4759,4769,4793,4833,4851,4919,4981,4996,5086,5107,5198,5293,5424,5432,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,6758,6760,6767,6775,6777,6781,6805,6809,6832,6830,6844,6847,6849,6866,7022,7037,7116,6783,7183,7223,7240,7249,7251,7267,7269,7271,7291,7321,7329,7347,7352,7393,7407,7413,7419,7424,7426,7448,7459,3534,7563,7586,7589,7593,7612,7615,7632,7656,7666,7690,7692,7700,7706,7729,7734,7738,7742,7745,7759,7761,7786,7800,7813,7816,7820,7825,7834,7858,7875,7882,7903,7918,7939,7944,7945,7949,7992,8002,8009,8010,8014,8017,8018,8032,8067,8074,8077,8080,8097,8100,8101,8105,8106,8107,8111,8113,8115,8116,8118,8127,8132,8135,8140,8143,8147,8148,8150,8156,8157,8170,8182,8186,8193,8194,8205,8213,8217,8219,8220,8241,8249,8253,8254,8258,8269,8270,8275,8278,8281,8295,8304,8307,8329,8335,8347,8354,8364,8377,8378,8379,8388,8392,8394,8401,8410,8416,8420,8425,8430,8440,8456,8482,8486,8497,8498,8509,8524,8528,8529,8532,8540,8544,8557,8560,8577,8578,8587,8592,8596,8604,8617,8618,8622,8639,8666,8687,8733,8734,8743,8750,8757,8758,8764,8766,8780,8782,8787,8797,8812,8816,8817,8845,8852,8874,8878,8884,8887,8892,8893,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,9118,9121,9125,9126,9140,9146,9148,9152,9165,9177,9228,9236,9243,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,9900,9914,9931,9935,9952,9954,9956,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,379,425,447,449,458,461,470,472,488,489,496,503,505,507,580,595,604,617,622,644,653,676,677,678,681,682,686,712,718,723,733,734,739,761,762,809,820,839,855,856,857,863,869,879,900,902,927,939,956,969,982,704,1297,1333,1339,1471,1508,1509,1499,1612,888,1668,1694,1787,1821,1858,1882,1924,2022,468,2147,2544,2729,2772,2873,2926,2939,2940,2943,2948,2973,2992,3004,304,266,613,597,606,579,3117,3168,3216,3509,3539,827,3578,3104,3091,3068,2780,2817,2103,2102,2230,1786,1785,3343,3152,2560,2504,2413,2419,1933,1932,1929,1900,1621,1003,898,707,754,509,342,437,399,277,624,3597,3884,3890,3913,591,4059,4125,4150,4170,4187,4186,4285,4292,4296,4299,4300,4305,4308,4319,4324,4332,4355,4465,4494,4559,4560,4638,4654,4661,4697,4699,4725,4734,4847,4857,4964,648,5020,5115,5025,5212,5137,5313,5335,5352,5409,5507,5511,5526,5596,5633,5688,5725,5860,5971,5962,5990,5991,6007,6017,6041,6070,6131,6167,6201,6203,6212,6260,6230,6355,6387,6501,6573,6602,6613,6615,6631,6635,6639,6644,6650,6662,6703,6704,6702,6738,6756,6784,6785,6792,6798,6799,6831,7063,7169,7236,7247,7258,7292,7270,7293,7303,7333,7355,7360,7372,7395,7397,7399,7417,7437,7478,7482,7494,7606,7630,7663,7719,7727,7739,7743,7791,7799,7838,7863,7877,7886,7899,7904,7912,7921,7935,7954,7960,7968,7978,7981,8063,8073,8076,8082,8085,8092,8098,8112,8137,8142,8165,8196,8200,8201,8211,8214,8232,8284,8294,8306,8308,8316,8320,8324,8328,8337,8372,8375,8381,8429,8452,8464,8468,8470,8474,8496,8508,8517,8538,8543,8545,8568,8630,8631,8635,8648,8653,8654,8655,8661,8671,8704,8722,8732,8737,8744,8807,8815,8826,8859,8861,8876,8899,8907,8973,9020,9036,9172,9195,9212,9252,9364,9365,9371,9392,9413,9446,9477,9480,9482,9591,9609,9611,9621,9625,9626,9646,9665,9710,9727,9728,9749,9799,9827,9829,9831,9857,9893,9992,10004,10021,10073,10076,10081,10085,10106,10135,10136,10167,10187,10304,10305,10312,10401,462,3056,3411,3568,3767,3922,3959,3996,4090,4238,4516,4875,5143,5751,5851,6747,7591,7831,8136,8962,10213)
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 | 1106 | 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 | 1106 | |
| 3 | DERIVED | NULL | NULL | NULL | ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ | NULL | NULL | NULL | No tables used |
| Status | Duration |
|---|
| Starting | 1.21 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| table lock | 0.02 ms |
| init | 0.77 ms |
| Optimizing | 0.55 ms |
| Statistics | 0.17 ms |
| Preparing | 0.07 ms |
| Creating tmp table | 0.05 ms |
| Sorting result | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.24 ms |
| Removing tmp table | 0.01 ms |
| Sending data | 25.39 ms |
| Creating sort index | 3.77 ms |
| Removing tmp table | 0.28 ms |
| Creating sort index | 0.01 ms |
| End of update loop | 0.01 ms |
| Removing tmp table | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.01 ms |
| closing tables | 0.00 ms |
| Removing tmp table | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.05 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 |