Χρόνος επερώτησης:28.84 ms Μετά την τελευταία επερώτηση:0.42 ms Μνήμη με επερώτηση: 0.089 MB Μνήμη πριν την επερώτηση: 3.849 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-01 17:46:09' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-04-01 17:46:09' )
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,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,10137,10159,10176,10178,10179,10189,10208,10221,10242,10248,10291,10294,10299,10875,74,1435,1997,2569,2625,2694,3911,3913,3954,3968,4134,4199,4201,4278,4337,2675,4444,4446,4458,4537,4544,6039,6222,6262,6451,6609,7564,7585,7596,7608,7628,7641,7669,7671,7905,8404,8527,8558,8563,8590,8594,8595,8599,8609,8611,8625,8632,8645,8652,8655,8656,8670,8679,8692,8705,8729,8769,8824,9920,9926,9940,9967,9993,10012,10046,10047,10070,10111,10121,10129,10150,10154,10160,10184,10188,10205,10225,10235,10237,10239,10245,10267,10270,10279,10289,10301,10302,858,1184,1638,1854,1906,1993,2193,2393,2395,2471,2759,2832,2996,3029,2057,3054,376,3177,3252,3256,3348,3433,3432,3490,3492,3511,3518,3525,3560,3663,3680,3683,3714,3722,3724,3748,2463,3773,3576,3836,3846,3864,3878,3877,3905,3964,3993,4038,4077,4194,4255,4294,4352,3150,4353,4388,4475,4513,4522,4547,4552,4575,4611,4615,4620,4638,4661,4685,4688,4675,4701,4634,4932,5020,5112,5145,5307,5348,5414,5562,5662,5826,5866,5999,6681,6709,6751,6790,7200,7212,7219,7228,7231,7250,7254,7349,7356,7370,7403,7409,7457,7472,7487,7498,7515,7516,7513,7556,7560,7561,7602,7609,7618,7619,7664,7672,7680,7697,7704,7722,7749,7750,7751,7752,7756,7766,7779,7787,7810,7843,7847,7848,7854,7890,7908,7938,7942,7946,7955,7962,7974,8011,8015,8056,8114,8123,8138,8172,8180,8184,8187,8190,8207,8221,8231,8245,8251,8256,8257,8259,8262,8286,8319,8338,8365,8375,8381,8393,8405,8419,8427,8441,8445,8447,8448,8488,8495,8516,8549,8565,8586,8608,8610,8634,8640,8646,8659,8665,8691,8695,8745,8753,8756,8767,8771,8776,8783,8795,8796,8813,8814,8873,8894,8910,8928,8948,9008,9009,9012,9035,9059,9098,9184,9213,9241,9242,9251,9301,9323,9324,9327,9433,9511,9580,9583,9628,9666,9682,9688,9701,9706,9712,9745,9759,9763,9773,9774,9785,9805,9844,9846,9870,9871,9873,9885,9890,9902,9903,9904,9910,9917,9941,9945,9948,9949,9953,9964,9975,9985,9986,9987,9989,10055,10085,10087,10101,10107,10119,10120,10161,10162,10214,1410,2401,2550,2581,2588,2624,4346,4347,4395,4397,4468,6221,6521,7266,7400,7565,7623,8400,8553,8573,8657,8696,8700,10063,10096,10219,10347,1897,2399)
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 | 1095 | 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 | 1095 | |
| 3 | DERIVED | NULL | NULL | NULL | ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ | NULL | NULL | NULL | No tables used |
| Status | Duration |
|---|
| Starting | 0.42 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.28 ms |
| Optimizing | 0.24 ms |
| Statistics | 0.12 ms |
| Preparing | 0.05 ms |
| Creating tmp table | 0.05 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.18 ms |
| Removing tmp table | 0.01 ms |
| Sending data | 22.91 ms |
| Creating sort index | 3.88 ms |
| Removing tmp table | 0.43 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.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.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 |