Χρόνος επερώτησης:37.44 ms Μετά την τελευταία επερώτηση:0.51 ms Μνήμη με επερώτηση: 0.089 MB Μνήμη πριν την επερώτηση: 3.811 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 04:52:53' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-05-04 04:52:53' )
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 (60,67,68,72,211,265,305,336,350,355,382,446,451,461,470,471,474,482,488,489,490,496,505,492,580,583,582,601,605,612,617,620,623,628,630,631,632,636,641,643,656,658,665,671,682,689,692,698,706,709,710,716,712,717,718,723,726,729,734,735,738,746,753,761,762,757,767,768,769,776,778,782,785,788,789,797,799,811,818,822,823,837,838,840,845,847,849,855,858,861,885,887,892,899,900,901,902,930,938,941,963,965,969,971,973,975,976,977,978,979,980,982,983,991,996,998,966,1014,1015,1018,1022,1064,1068,1072,1075,1085,1088,1089,1093,1118,1119,1120,1121,1123,1125,1129,1131,1133,1135,1138,1139,704,1149,1153,1168,1169,1172,1173,1179,1199,1202,1206,1216,1219,1226,1228,1232,1247,1248,1258,1260,1265,1273,1277,1283,1298,1324,1336,1337,1348,1350,1351,1373,1381,1383,1401,1445,1449,1471,1494,1507,1508,1509,1551,1583,1601,1603,1639,1647,1657,1659,1660,1661,1683,1690,1727,1730,1731,1750,1755,1756,1764,1766,1769,1819,1820,1821,1825,1838,1856,1862,1865,1866,1907,1912,1901,1917,1923,1971,1975,1984,1993,2014,2018,2029,2045,2074,2087,2131,2147,2152,2153,2157,2198,2255,2260,2261,775,2270,2280,2289,2298,2304,2314,2324,2325,2364,2383,2394,2397,2398,2415,2424,2422,2425,2484,2510,2511,2513,2546,2550,2562,2579,2573,2584,2583,2574,2601,2602,2638,2647,2662,2682,2684,2694,2699,2698,2710,2433,1347,766,690,508,2749,2750,2766,2805,2812,1592,714,581,2907,2914,2934,2935,2949,2960,2965,2981,2985,3013,3058,345,597,585,579,499,3123,3148,3156,3190,3191,3204,1268,747,2681,3248,3256,3331,3332,3336,3383,3397,3454,3455,3482,3489,3108,3519,3523,3525,3524,3538,3555,3581,3582,3584,3603,3587,3588,3382,3622,3628,3636,3639,3641,3655,3575,3662,3670,3672,3676,3680,3684,3685,3651,3689,1322,3706,3710,3711,3720,3722,3725,3726,3727,3728,3731,3733,3738,3748,3751,3753,3754,3757,3761,3446,3424,3306,3766,3769,3776,3787,3790,3794,3797,3809,3576,3812,3825,3828,913,3833,3837,3838,3843,3846,3849,3852,3853,3854,3856,3859,3865,3868,3870,3875,3881,3885,3886,3888,3889,3891,3895,3897,3900,3902,3907,3909,3912,3913,3512,3918,3923,3929,3935,3940,3941,3953,3956,3950,3958,3961,3967,3975,3979,3981,3991,3992,3998,3999,3691,4005,4007,4010,4011,4014,4015,4016,4019,4030,4036,4039,4044,4046,4048,4049,4051,4057,4061,4067,4069,4072,4075,4084,4080,4088,4091,4094,4099,4102,4110,4113,4115,4120,4123,4126,4133,4128,4140,4145,4147,4155,4170,4171,4176,4178,4180,4182,4187,4189,4192,4193,4195,4200,4203,4210,4211,4216,4217,4224,4230,4231,4237,4240,4241,4245,4249,4251,4256,4265,4267,4270,4272,4277,4279,4283,4285,4287,4290,4291,4292,4294,4297,4304,4310,4313,4318,4321,4322,4327,4329,4333,421,4335,4343,4350,4354,4355,4359,4367,4368,4374,4376,4381,4384,4387,2987,4394,4401,4404,3752,4410,4425,4426,4437,4445,4454,4455,4456,4460,4463,4464,4469,4474,4477,4482,4483,4491,4494,4500,4501,4506,4517,4519,4521,4526,4531,4534,4540,4543,4558,4565,4572,4616,4623,4643,4653,4716,4630,4904,4927,4928,4901,4949,4968,648,4995,5014,5072,5101,5120,5132,5195,5197,5323,5344,5347,5357,5372,5396,5419,5429,5473,5528,5547,5550,5568,5577,5582,5592,5606,5632,5659,5661,5668,5680,5727,5775,5810,5816,5840,5841,5845,5859,5876,5886,5921,5925,5932,6058,6071,6153,6211,6227,6246,6274,6315,6318,6339,6341,6354,6213,6360,6365,5508,6630,6640,6641,6675,6677,6700,6714,6716,6722,6731,6737,6740,6751,6752,6789,6811,6814,6817,6863,7032,3378,5398,7172,7199,7207,7253,7263,7272,7252,7280,7284,7290,7297,7316,7344,7349,7354,7361,7367,7378,7382,7391,7401,7406,7409,7422,7423,7428,7434,7439,7481,7511,7564,7592,7596,7603,7628,7651,7668,7671,7673,7677,7692,7693,7696,7699,7700,7707,7717,7721,7730,7735,7736,7745,7746,7757,7763,7768,7778,7786,7801,7828,7833,7841,7879,7883,7889,7902,7915,7919,7943,7944,7950,7971,7987,7989,7998,8001,8004,8025,8030,8045,8069,8079,8082,8083,8086,8091,8098,8102,8103,8104,8112,8115,8117,8120,8134,8139,8146,8152,8171,8176,8177,8182,8185,8190,8194,8207,8209,8210,8212,8233,8236,8256,8258,8262,8268,8274,8291,8296,8330,8342,8349,8355,8358,8362,8367,8376,8379,8409,8422,8451,8453,8454,8487,8495,8536,8537,8542,8548,8562,8567,8572,8576,8579,8599,8606,8608,8615,8619,8628,8641,8651,8655,8668,8669,8670,8673,8685,8689,8699,8702,8706,8711,8721,8736,8768,8773,8792,8793,8795,8808,8815,8820,8829,8831,8836,8838,8850,8853,8857,8868,8875,8877,8898,8900,8908,8909,8922,8929,8937,8941,8963,8975,8976,8984,8987,8989,8997,9003,9009,9028,9041,9052,9056,9060,9063,9082,9085,9095,9104,9109,9115,9142,9149,9156,9164,9212,9254,9265,9294,9336,9341,9358,9361,9371,9390,9395,9413,9439,9457,9464,9505,9530,9576,9618,9628,9631,9689,9709,9738,9740,9745,9761,9783,9806,9815,9816,9837,9842,9844,9863,9882,9884,9888,9889,9901,9904,9906,9908,9924,9925,9937,9938,9944,9949,9959,9968,9972,9983,9988,9989,10007,10009,10010,10015,10019,10024,10031,10037,10042,10058,10064,10090,10094,10104,10105,10121,10134,10138,10161,10166,10226,10244,10255,10268,10314,10379,10414,10420,10423,14549,14552,159,3021,3126,3197,3354,4571,4579,4783,4930,5465,5698,5752,5880,7225,7449,7577,7780,10199,14537,379,425,447,448,449,458,460,472,495,503,507,576,595,598,604,609,611,614,622,625,626,627,644,650,653,657,676,677,678,681,686,693,703,685,731,733,737,739,751,770,773,784,809,816,820,839,856,857,863,869,879,927,939,956,1071,1087,864,1176,1297,1331,1333,1338,1339,1394,1451,1458,1504,1499,1612,888,1668,1694,1787,1858,1882,1924,2022,748,468,2544,2729,2772,2873,2926,2939,2940,2943,2948,2973,2992,3004,304,266,615,613,606,590,599,608,504,3117,3168,3216,1985,1536,3509,3539,827,3578,3104,3091,3068,2780,2817,2103,2102,2230,1786,1785,3343,3152,2560,2504,2413,2419,1933,1932,1929,1900,1621,1003,898,707,754,509,342,437,399,277,624,3597,3815,3866,3884,3890,591,4059,4125,4138,649,4146,4150,4186,4296,4299,4300,4305,4308,4319,4324,4332,4465,4559,4560,4638,4654,4661,4697,4699,4725,4734,4847,4857,4964,5020,5115,5025,5212,5137,5313,5335,5352,5409,5507,5511,5526,5596,5633,5634,5688,5725,5860,5971,5962,5990,5991,6007,6017,6041,6070,6131,6167,6201,6203,6212,6260,6230,6355,6387,6501,6573,6602,6613,6615,6631,6635,6639,6644,6650,6662,6673,6682,6703,6704,6702,6738,6756,6784,6785,6792,6798,6799,6831,7063,7169,7236,7247,7258,7292,7270,7293,7303,7333,7355,7360,7372,7395,7397,7399,7417,7437,7478,7482,7494,7606,7630,7663,7719,7727,7739,7743,7791,7799,7838,7858,7863,7877,7886,7899,7904,7912,7921,7935,7954,7960,7968,7978,7981,8063,8073,8076,8085,8092,8107,8137,8142,8143,8165,8196,8200,8201,8211,8214,8232,8249,8284,8294,8306,8308,8316,8320,8324,8328,8337,8372,8375,8381,8416,8429,8440,8452,8464,8468,8470,8474,8496,8508,8517,8538,8543,8545,8568,8630,8631,8635,8653,8654,8661,8671,8704,8722,8732,8737,8744,8807,8826,8859,8861,8876,8899,8907,8973,9020,9023,9036,9172,9195,9252,9253,9364,9365,9392,9446,9477,9480,9482,9591,9609,9611,9621,9625,9626,9633,9646,9665,9694,9710,9727,9728,9749,9799,9827,9829,9831,9857,9893,9992,10004,10021,10073,10076,10081,10085,10106,10135,10136,10159,10167,10178,10187,10304,10305,10312,10401,1167,1424,1824,2060,2196,2344,2320,931,2930,3019,2912,2311,2172,2683,2134,2436,2057,1841,1836,1490,1196,1166,1155,1154,1062,993,934,924,3079,3033,2978,2871,2843,2146,3082,3085,3102,3121,3224,3238,2405,3471,3533,3560,3376,3105,3693,3709,3758,3819,3832,3851,3864,3945,4018,4098,4307,4356,4357,4408,4441,4535,4548,4620,4651,4664,4750,4951,4954,4996,5010,5085,5117,5418,5687,5828,6605,6622,6633,6666,6717,6765,6922,7387,7390,7392,7419,7445,3239,3534,7513,7579,7609,7661,7708,7756,7770,7790,7809,7817,7847,7851,7867,7909,7920,7937,7995,8002,8166,8205,8270,8323,8353,8488,8497,8544,8600,8666,8691,8700,8990,9010,9035,9065,9116,9202,9257,9393,9422,9538,9784,9866,9876,9933,10070,10151,10183)
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 | 1529 | 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 | 1529 | |
| 3 | DERIVED | NULL | NULL | NULL | ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ | NULL | NULL | NULL | No tables used |
| Status | Duration |
|---|
| Starting | 0.54 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.35 ms |
| Optimizing | 0.25 ms |
| Statistics | 0.11 ms |
| Preparing | 0.05 ms |
| Creating tmp table | 0.05 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.21 ms |
| Removing tmp table | 0.01 ms |
| Sending data | 31.69 ms |
| Creating sort index | 3.64 ms |
| Removing tmp table | 0.26 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.01 ms |
| Query end | 0.01 ms |
| closing tables | 0.00 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.00 ms |
| Freeing items | 0.08 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 |