Χρόνος επερώτησης:40.95 ms Μετά την τελευταία επερώτηση:1.15 ms Μνήμη με επερώτηση: 0.073 MB Μνήμη πριν την επερώτηση: 3.779 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 23:07:37' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-04-01 23:07:37' )
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 (38,73,74,76,79,470,474,489,493,494,502,505,492,444,586,588,589,605,607,618,619,620,621,628,631,634,642,647,659,661,664,665,674,680,681,682,683,689,691,692,698,701,702,710,724,735,743,746,749,750,757,767,768,771,778,782,795,797,796,810,811,813,818,821,822,823,825,832,846,849,850,851,852,859,860,861,868,883,886,887,892,893,905,914,938,960,963,965,971,981,989,996,997,1014,1015,1017,1018,1021,1032,1033,1034,1064,1065,1068,1072,1077,1084,1086,1088,1090,1093,1107,1119,1120,1121,1123,1125,1129,1132,1133,1135,1138,1139,1149,1159,1168,1173,1171,1203,1215,1218,1243,1247,1249,1267,1273,1274,1276,1294,1298,1346,1370,1399,1449,1491,1505,1635,1639,1647,1655,1661,1691,1730,1736,1739,1771,1780,1797,1818,1820,1837,1834,1864,1888,1832,1897,1923,2039,2055,2126,2148,2152,2153,2188,2193,2255,2341,2380,2389,2392,2391,2447,2448,2487,2501,2638,2682,2710,2713,508,2747,2748,2750,2752,2766,2801,2803,714,2904,2965,2976,2991,2996,3014,3045,37,78,606,499,3128,3159,3166,3177,3204,3215,3231,651,3242,3245,2067,3248,3252,3268,3301,3312,3328,3335,3352,3384,3390,3404,3434,3464,3482,3484,3491,3493,3500,3504,3507,3514,3527,1254,442,3559,3569,3571,3572,3579,3592,1095,3409,3053,2589,1197,1001,3601,3602,3619,3629,3630,3642,3655,3658,3575,3661,3667,3682,3685,3692,2525,3713,3664,3720,3726,3728,3739,3740,3747,3753,3759,3791,3792,3807,3625,3576,3814,3824,3835,3853,3855,3871,3876,3888,3892,3895,3896,3899,3904,3910,3916,3921,3930,3933,3935,3947,3956,3957,3963,3964,3969,3977,3993,4001,4005,4008,4015,4019,4038,4046,4055,4062,4072,4078,4081,4093,4103,4115,4123,4148,4169,4178,4179,4180,4182,4194,4203,4210,4215,4221,4222,4242,4243,4249,4250,4272,4277,4283,4297,4310,4328,4332,4333,4337,1013,1066,4361,4362,4366,4384,4387,4393,4397,4409,4411,4422,4426,4437,4449,4456,4496,4497,4498,4500,4506,4509,4521,4522,4543,4580,4588,4592,4606,4608,4610,4637,4677,4739,4756,4811,4840,4909,5022,5023,5028,5089,5101,5331,5372,5397,5395,5426,5431,5433,5455,5464,5469,5476,5479,5488,5572,5587,5606,5607,5616,5629,5644,5667,5712,5714,5722,5794,5839,5848,5861,5920,6000,6068,6088,6157,6164,6186,6204,6229,6261,6301,6377,6395,6447,6600,6619,6671,6677,6700,6727,6751,6762,6800,6810,6811,6860,6986,7029,7052,7246,7253,7272,7280,7284,7295,7299,7302,7307,7359,7362,7367,7368,7401,7457,7460,7461,7493,7515,7555,7562,7576,7577,7583,7600,7608,7651,7654,7664,7676,7679,7704,7707,7723,7724,7740,7750,7751,7757,7758,7767,7781,7782,7798,7801,7823,7828,7833,7840,7841,7848,7857,7862,7883,7907,7908,7915,7950,7971,7976,7986,8003,8008,8014,8026,8030,8041,8043,8057,8091,8104,8132,8133,8134,8145,8149,8160,8161,8171,8172,8184,8190,8199,8230,8251,8256,8257,8273,8291,8299,8321,8338,8355,8392,8402,8403,8422,8438,8442,8449,8451,8465,8471,8475,8487,8514,8528,8548,8552,8565,8572,8575,8579,8589,8600,8610,8619,8622,8639,8643,8692,8696,8706,8718,8719,8759,8774,8776,8777,8779,8780,8786,8789,8790,8792,8793,8795,8827,8834,8853,8863,8888,8890,8891,8893,8894,8898,8901,8906,8916,8927,8930,8935,8937,8945,8946,8947,8952,8974,8975,8976,8978,8987,8998,9003,9009,9020,9038,9043,9072,9073,9080,9093,9098,9109,9111,9149,9153,9193,9223,9254,9294,9341,9347,9361,9399,9405,9419,9452,9461,9472,9484,9527,9532,9540,9543,9560,9600,9614,9650,9655,9668,9684,9689,9690,9719,9720,9721,9730,9731,9733,9738,9739,9746,9760,9767,9794,9809,9832,9842,9859,9861,9864,9873,9881,9882,9885,9889,9909,9911,9919,9924,9930,9937,9938,9939,9944,9947,9950,9955,9965,9968,9973,9980,9983,10007,10018,10019,10024,10031,10034,10054,10089,10094,10099,10108,10115,10131,10134,10136,10153,10200,10243,10268,10299,10302,10316,10357,10360,10768,1435,1997,2551,2569,2625,2694,3911,3913,3954,3968,4134,4199,4201,4278,2675,4444,4446,4458,4537,4544,6039,6222,6262,6451,6609,7564,7585,7596,7628,7641,7669,7671,7905,8253,8254,8304,8404,8524,8527,8557,8558,8590,8594,8595,8599,8609,8611,8625,8632,8645,8652,8655,8656,8670,8679,8705,8729,8769,8824,9920,9926,9940,9967,9993,10012,10046,10047,10070,10111,10121,10122,10129,10137,10150,10154,10160,10184,10188,10205,10225,10235,10237,10239,10245,10267,10270,10279,10289,10294,10301,384,506,675,870,1038,1262,1404,1456,1485,1510,1921,2004,2177,2414,2523,2530,2712,2857,3032,3137,3138,3200,3324,3356,3416,3426,3445,3463,3468,3478,3488,3498,2892,4631,4646,4663,4672,4711,4729,4738,4796,4622,4804,4795,4872,4883,4926,4945,4956,4960,4987,4988,5002,5009,5018,5027,5041,5060,5075,5091,5104,5116,5127,5135,5160,5188,5201,5217,5221,5087,5241,5277,5303,5318,5330,5359,5394,5423,5466,5486,5489,5499,5502,5521,5541,5564,5570,5574,5592,5608,5621,5652,5680,5701,5723,5737,5759,5771,5789,5819,5842,5874,5477,5926,5957,5981,5989,5998,6072,6086,6127,6144,6173,6185,6224,6281,6298,6328,6368,6574,6581,6586,6627,6656,6674,6721,6750,6757,6774,6822,6835,6846,6851,6865,6899,5364,7198,7211,7238,7273,7325,7353,7361,7443,7454,7617,7659,7699,7710,7741,7748,7793,7817,7818,7856,7871,7969,7994,8034,8093,8138,8179,8195,8227,8247,8374,8406,8494,8591,8598,8620,8637,8646,8723,8724,8741,8763,8806,8809,8841,8855,8867,8900,8913,8950,8986,9026,9033,9047,9068,9083,9091,9154,9234,9241,9258,9271,9298,9299,9305,9328,9344,9360,9388,9420,9423,9435,9437,9444,9457,9488,9495,9533,9569,9604,9630,9632,9637,9641,9648,9663,9677,9687,9723,9776,9803,9814,9824,9835,9845,9871,9883,9905,9913,9942,9951,9974,10008,10016,10039,10066,10100,10113,10124,10139,10145,10168,10182,10185,10195,10209,10227,10255,10905,1417,1847,2022,2997,3396,3466,3505,3506,3558,3545,3605,3613,3677,3796,3878,3893,3908,3917,3942,3513,4035,4161,4368,4369,4432,4480,4501,4681,4800,4859,4919,4946,5161,5527,5584,5707,5764,5847,6116,6165,6183,7167,7263,7726,7888,7952,8023,8109,8213,8223,8377,8455,8560,8597,8669,8844,8878,8940,8953,9139,9522,9890,10152,10254,10287,10310)
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 | 1134 | 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 | 1134 | |
| 3 | DERIVED | NULL | NULL | NULL | ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ | NULL | NULL | NULL | No tables used |
| Status | Duration |
|---|
| Starting | 1.24 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.85 ms |
| Optimizing | 0.57 ms |
| Statistics | 0.31 ms |
| Preparing | 0.15 ms |
| Creating tmp table | 0.11 ms |
| Sorting result | 0.03 ms |
| Executing | 0.01 ms |
| Sending data | 0.49 ms |
| Removing tmp table | 0.02 ms |
| Sending data | 31.76 ms |
| Creating sort index | 4.41 ms |
| Removing tmp table | 0.52 ms |
| Creating sort index | 0.02 ms |
| End of update loop | 0.01 ms |
| Removing tmp table | 0.03 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Removing tmp table | 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.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 |
