Χρόνος επερώτησης:7.72 ms Μετά την τελευταία επερώτηση:0.81 ms Μνήμη με επερώτηση: 0.085 MB Μνήμη πριν την επερώτηση: 3.744 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-05 06:03:43' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-05-05 06:03:43' )
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 (35,71,609,906,917,1187,1518,1528,1654,2441,2490,2681,3235,3413,3486,3492,3556,3574,3567,3607,3585,3627,3693,3735,3754,3832,3845,3868,3883,3908,3970,3981,3994,4013,4036,4052,4092,4096,4121,4133,4177,4190,4213,4251,4263,4280,4295,4309,4323,4352,4435,4445,4487,4490,4520,4536,4561,4707,4815,1809,4962,5471,5614,5687,5708,5774,6146,6293,6299,6324,6331,6647,6803,6812,6979,7315,7386,7400,7582,7667,7733,7735,7783,7845,7846,7864,7869,7885,7893,7903,7917,7938,7948,7967,8088,8197,8224,8238,8240,8263,8303,8400,8410,8446,8447,8466,8477,8516,8570,8586,8606,8640,8704,8707,8708,8771,8816,8836,8918,8941,8966,8984,9012,9029,9065,9074,9152,9284,9434,9446,9501,9530,9620,9669,9699,9718,9748,9764,9840,9841,9923,9933,9962,9967,10025,10096,10098,10110,10114,10191,10256,10339,14562,59,69,389,448,460,463,495,576,598,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,3545,3531,3307,2455,3217,3600,3601,3605,3608,3609,3587,3616,3575,3705,3707,3718,3721,3723,3739,3741,3746,3761,3768,3769,3772,3813,3815,3823,3831,3844,3848,3850,3851,3860,3866,3873,3887,3893,3901,3909,3912,3927,3938,3939,3946,3951,3976,3566,3980,3983,3984,3995,3997,4002,4006,4010,4012,4018,4020,4026,4028,4029,4034,4035,4043,4047,4055,4063,4070,4071,4073,4098,4111,4119,4127,4129,4138,649,4145,4146,4157,4195,4208,4214,4218,4223,4228,4229,4236,4244,4253,4264,4271,4284,4288,4293,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,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,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,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,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,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,8817,8845,8852,8874,8878,8884,8887,8892,8893,8906,8940,8949,8954,8965,8970,8981,8983,8985,8993,9006,9010,9023,9039,9055,9057,9075,9078,9086,9087,9092,9113,9118,9121,9125,9126,9140,9146,9148,9165,9177,9228,9236,9243,9253,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,9858,9862,9874,9884,9900,9914,9931,9935,9952,9954,9956,9971,9994,10013,10020,10022,10030,10035,10056,10104,10115,10122,10137,10159,10176,10178,10179,10189,10208,10221,10242,10248,10291,10294,10299,10875,4594,5870,10046)
ORDER BY i.created DESC
LIMIT 0, 6
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | i | index | PRIMARY,item,catid | created | 5 | NULL | 123 | Using where |
| 1 | SIMPLE | c | eq_ref | PRIMARY,category,published,access,trash | PRIMARY | 4 | ifitness_ifitnew.i.catid | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.96 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.02 ms |
| init | 0.58 ms |
| Optimizing | 0.27 ms |
| Statistics | 0.81 ms |
| Preparing | 0.82 ms |
| Sorting result | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 3.95 ms |
| End of update loop | 0.01 ms |
| Query end | 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.05 ms |
| Updating status | 0.01 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 |