Χρόνος επερώτησης:7.52 ms Μετά την τελευταία επερώτηση:0.97 ms Μνήμη με επερώτηση: 0.136 MB Μνήμη πριν την επερώτηση: 3.759 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 12:59:00' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-05-05 12:59:00' )
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,7612,7667,7733,7735,7783,7845,7846,7864,7869,7885,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,84,918,955,970,982,991,1094,1097,1243,1414,1755,1890,1959,2004,2145,2593,2836,2894,55,3056,3096,3136,3178,3182,3191,3211,2104,2558,3346,3395,3422,3439,3470,3501,3731,3742,3761,3835,3893,3897,3899,3900,3916,3927,3937,3945,3984,3997,4010,4029,4111,4124,4130,4183,4184,4200,4262,4264,940,3469,4430,4447,4496,4576,4605,4663,4737,4748,4942,5097,5104,5144,5172,5187,5208,5153,5288,5393,5423,5482,5491,5512,5539,5576,5590,5718,5813,5868,5895,5906,5980,6075,6127,6203,6319,6661,6670,6675,6755,6771,6785,6846,7234,7240,7267,7281,7404,7407,7428,7440,7557,7562,7586,7603,7625,7635,7671,7732,7738,7813,7831,7854,7866,7874,7918,7947,7949,7987,7991,8017,8021,8043,8094,8098,8109,8112,8204,8205,8266,8287,8340,8349,8387,8394,8440,8449,8459,8485,8555,8572,8601,8627,8651,8741,8845,8867,8871,8874,8924,9003,9160,9268,9411,9461,9683,9799,9959,10104,10188,10208,466,471,494,498,503,505,632,673,678,693,697,701,720,729,814,843,895,896,942,974,975,998,966,1085,1232,1328,1398,1480,1525,1540,1566,1735,1797,1807,1824,1867,1869,1975,2029,2055,2120,2163,2600,2498,766,2799,581,3080,209,422,499,3158,3199,3219,3227,3385,3419,3420,3421,3432,3431,3453,3485,3518,3519,3524,3544,3555,3570,3573,2339,3588,3618,3645,3679,3650,3651,3722,3732,3749,3446,3770,3773,3790,3809,3817,3818,3825,3828,3837,3850,3859,3882,3885,3886,3905,3912,3913,3918,3914,3926,3925,3962,3965,3982,3996,4016,4018,4044,4051,4112,4113,4119,4122,4187,4192,4211,4218,4223,4231,4241,4256,4265,4267,4270,4294,4315,4317,4318,4325,4331,421,4335,4428,4454,4467,4475,4505,4508,4519,4531,4616,4626,4664,4674,4676,4680,4733,4746,4670,4820,4837,5038,5103,5132,5199,5246,5257,5401,5449,5468,5473,5506,5525,5589,5618,5639,5644,5837,6019,6031,6064,6169,6206,6217,6225,6227,6267,6426,6578,6672,6681,6759,6773,6839,7118,7237,7252,7275,7297,7338,7347,7352,7424,7445,7451,7493,7496,7518,7579,7584,7591,7655,7690,7693,7736,7760,7761,7773,7820,7897,7995,8025,8050,8064,8097,8110,8131,8150,8176,8248,8289,8312,8325,8332,8334,8368,8384,8411,8419,8430,8480,8488,8527,8549,8553,8557,8578,8615,8616,8617,8673,8690,8695,8697,8700,8730,8746,8749,8778,8803,8830,8864,8922,8979,8999,9022,9035,9037,9069,9085,9086,9153,9161,9182,9205,9214,9229,9287,9487,9499,9593,9680,9709,9756,9789,9805,9846,9916,9963,10070,10093,10112,10189,10287,362,366,408,621,671,706,736,847,935,973,1027,1028,1195,1409,1469,1576,1854,1990,2080,2152,2198,2195,2569,2699,2832,2854,3040,747,3340,3532,3603,3638,3642,3646,3660,3675,3689,3711,3725,3748,3208,3776,3787,3797,3812,3846,3870,3875,3881,3902,3907,3929,3940,3953,3956,3958,3961,3975,3979,3998,4005,4014,4015,4019,4048,4049,4057,4061,4075,4099,4104,4105,4106,4107,4108,4110,4123,4128,4176,4178,4210,4217,4224,4249,4272,4279,4287,4297,4304,4327,4329,1783,2979,4368,4374,4376,4389,4401,4410,4449,4457,4491,4554,4566,4636,4650,4658,4673,4687,4693,4700,4794,4806,4841,4882,4911,4992,5047,5057,5067,5066,5157,5209,5243,5284,5327,5333,5421,5429,5467,5502,5538,5586,5600,5608,5651,5667,5680,5697,5724,5738,5765,5783,5785,5808,5852,5876,5886,5916,5969,5979,6057,6128,6137,6143,6173,6209,6315,6586,6671,6674,6772,6821,6822,6838,6860,6861,6977,7015,7212,7217,7225,7250,7284,7325,7412,7414,7456,7515,7513,7558,7580,7605,7636,7662,7699,7707,7801,7837,7857,7879,7883,8042,8102,8117,8146,8155,8179,8185,8208,8252,8265,8274,8291,8298,8379,8423,8599,8689,8694,8699,8711,8728,8750,8758,8766,8792,8795,8908,8956,9028,9041,9052,9133,9235,9277,9317,9345,9354,9363,9394,9428,9479,9482,9508,9560,9572,9595,9600,9606,9673,9686,9721,9738,9741,9776,9781,9787,9794,9807,9816,9824,9887,9904,9944,9952,9954,9988,10015,10024,10026,10039,10064,10090,10113,10125,10134,10139,10185,10399,10427,10709,10783)
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 | 117 | 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.98 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.64 ms |
| Optimizing | 0.31 ms |
| Statistics | 1.84 ms |
| Preparing | 1.06 ms |
| Sorting result | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 2.20 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.10 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.04 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.04 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 |