Χρόνος επερώτησης:32.18 ms Μετά την τελευταία επερώτηση:1.04 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 10:01:03' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-05-04 10:01:03' )
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,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,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,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,79,299,976,978,1027,1064,1301,1690,1896,2145,3588,3680,3650,3651,3576,3871,3882,3944,3958,4016,4044,4102,4237,4256,4265,4270,4290,4294,4304,4315,4330,4361,4467,4501,4577,4605,4831,5047,5260,5863,6681,6788,7665,7974,9133,9161,9235,9294,9311,9670,9715,10062,10199,10311,362,366,408,621,671,706,736,847,942,935,973,1028,1195,1398,1409,1469,1566,1576,1854,1990,2080,2152,2198,2195,2569,2699,2832,2854,3040,747,3340,3524,3532,3555,3603,3638,3642,3646,3660,3675,3689,3711,3725,3731,3748,3208,3776,3787,3797,3809,3812,3818,3825,3846,3868,3870,3875,3881,3885,3886,3900,3902,3907,3929,3940,3953,3956,3961,3975,3979,3981,3998,4005,4014,4015,4019,4036,4048,4049,4051,4057,4061,4075,4099,4104,4105,4106,4107,4108,4110,4113,4123,4133,4128,4176,4178,4210,4217,4224,4241,4249,4251,4272,4279,4287,4297,4318,4327,4329,1783,2979,4368,4374,4376,4389,4401,4410,4449,4457,4491,4508,4554,4566,4636,4650,4658,4673,4687,4693,4700,4794,4806,4841,4882,4911,4992,5057,5067,5066,5157,5209,5243,5284,5327,5333,5421,5429,5449,5467,5502,5538,5586,5600,5608,5639,5667,5680,5697,5724,5738,5765,5783,5785,5808,5852,5876,5886,5916,5969,5979,6057,6064,6128,6137,6143,6169,6173,6209,6315,6586,6647,6671,6674,6772,6773,6821,6822,6838,6860,6861,6977,7015,7212,7217,7225,7250,7284,7325,7412,7414,7451,7456,7515,7513,7558,7580,7605,7636,7662,7693,7699,7707,7801,7837,7857,7879,7883,7893,8042,8102,8117,8146,8155,8179,8185,8208,8252,8265,8274,8291,8298,8423,8477,8599,8689,8694,8699,8711,8728,8792,8795,8908,8922,8941,8956,9028,9041,9052,9085,9277,9317,9345,9354,9363,9394,9428,9479,9482,9560,9572,9595,9600,9606,9673,9686,9721,9738,9741,9756,9776,9781,9787,9794,9807,9816,9824,9887,9904,9944,9988,10015,10024,10026,10039,10064,10090,10113,10125,10134,10139,10185,10399,10427,10709,10783,3538,4198)
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 | 1058 | 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 | 1058 | |
| 3 | DERIVED | NULL | NULL | NULL | ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ | NULL | NULL | NULL | No tables used |
| Status | Duration |
|---|
| Starting | 1.31 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.89 ms |
| Optimizing | 0.56 ms |
| Statistics | 0.28 ms |
| Preparing | 0.14 ms |
| Creating tmp table | 0.12 ms |
| Sorting result | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.63 ms |
| Removing tmp table | 0.01 ms |
| Sending data | 24.59 ms |
| Creating sort index | 3.04 ms |
| Removing tmp table | 0.26 ms |
| Creating sort index | 0.01 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.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.04 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 |