Χρόνος επερώτησης:58.01 ms Μετά την τελευταία επερώτηση:0.64 ms Μνήμη με επερώτηση: 0.105 MB Μνήμη πριν την επερώτηση: 3.818 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-11-02 15:55:05' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-11-02 15:55:05' )
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,8514,8528,8548,8552,8563,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,60,67,68,72,211,265,305,336,350,355,382,446,451,461,471,482,488,490,496,580,583,582,601,612,617,623,630,632,636,641,643,656,658,671,706,709,716,712,717,718,723,726,729,734,738,753,761,762,769,776,785,788,789,799,837,838,840,845,847,855,858,885,899,900,901,902,930,941,969,973,975,976,977,978,979,980,982,983,991,998,966,1022,1075,1085,1089,1118,1131,704,1153,1169,1172,1179,1199,1202,1206,1216,1219,1226,1228,1232,1248,1258,1260,1265,1277,1283,1324,1336,1337,1348,1350,1351,1373,1381,1383,1401,1445,1471,1494,1507,1508,1509,1551,1583,1601,1603,1657,1659,1660,1683,1690,1727,1731,1750,1755,1756,1764,1766,1769,1819,1821,1825,1838,1856,1862,1865,1866,1907,1912,1901,1917,1971,1975,1984,1993,2014,2018,2029,2045,2074,2087,2131,2147,2157,2198,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,2647,2662,2684,2694,2699,2698,2433,1347,766,690,2749,2805,2812,1592,581,2907,2914,2934,2935,2949,2960,2981,2985,3013,3058,345,597,585,579,3123,3148,3156,3190,3191,1268,747,2681,3256,3331,3332,3336,3383,3397,3454,3455,3489,3108,3519,3523,3525,3524,3538,3555,3581,3582,3584,3603,3587,3588,3382,3622,3628,3636,3639,3641,3662,3670,3672,3676,3680,3684,3651,3689,1322,3706,3710,3711,3722,3725,3727,3731,3733,3738,3748,3751,3754,3757,3761,3446,3424,3306,3766,3769,3776,3787,3790,3794,3797,3809,3812,3825,3828,913,3833,3837,3838,3843,3846,3849,3852,3854,3856,3859,3865,3868,3870,3875,3881,3885,3886,3889,3891,3897,3900,3902,3907,3909,3912,3913,3512,3918,3923,3929,3940,3941,3953,3950,3958,3961,3967,3975,3979,3981,3991,3992,3998,3999,3691,4007,4010,4011,4014,4016,4030,4036,4039,4044,4048,4049,4051,4057,4061,4067,4069,4075,4084,4080,4088,4091,4094,4099,4102,4110,4113,4120,4126,4133,4128,4140,4145,4147,4155,4170,4171,4176,4187,4189,4192,4193,4195,4200,4211,4216,4217,4224,4230,4231,4237,4240,4241,4245,4251,4256,4265,4267,4270,4279,4285,4287,4290,4291,4292,4294,4304,4313,4318,4321,4322,4327,4329,421,4335,4343,4350,4354,4355,4359,4367,4368,4374,4376,4381,2987,4394,4401,4404,3752,4410,4425,4445,4454,4455,4460,4463,4464,4469,4474,4477,4482,4483,4491,4494,4501,4517,4519,4526,4531,4534,4540,4558,4565,4572,4616,4623,4643,4653,4716,4630,4904,4927,4928,4901,4949,4968,648,4995,5014,5072,5120,5132,5195,5197,5323,5344,5347,5357,5396,5419,5429,5473,5528,5547,5550,5568,5577,5582,5592,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,6714,6716,6722,6731,6737,6740,6752,6789,6814,6817,6863,7032,3378,5398,7172,7199,7207,7263,7252,7290,7297,7316,7344,7349,7354,7361,7378,7382,7391,7406,7409,7422,7423,7428,7434,7439,7481,7511,7564,7592,7596,7603,7628,7668,7671,7673,7677,7692,7693,7696,7699,7700,7717,7721,7730,7735,7736,7745,7746,7763,7768,7778,7786,7879,7889,7902,7919,7943,7944,7987,7989,7998,8001,8004,8025,8045,8069,8079,8082,8083,8086,8098,8102,8103,8112,8115,8117,8120,8139,8146,8152,8176,8177,8182,8185,8194,8207,8209,8210,8212,8233,8236,8258,8262,8268,8274,8296,8330,8342,8349,8358,8362,8367,8376,8379,8409,8453,8454,8495,8536,8537,8542,8562,8567,8576,8599,8606,8608,8615,8628,8641,8648,8651,8655,8668,8669,8670,8673,8685,8689,8699,8702,8711,8721,8736,8768,8773,8808,8815,8820,8829,8831,8836,8838,8850,8857,8868,8875,8877,8900,8908,8909,8922,8929,8941,8963,8984,8989,8997,9028,9041,9052,9056,9060,9063,9082,9085,9095,9104,9115,9142,9156,9164,9212,9265,9336,9358,9371,9390,9395,9413,9439,9457,9464,9505,9530,9576,9618,9628,9631,9709,9740,9745,9761,9783,9806,9815,9816,9837,9844,9863,9884,9888,9901,9904,9906,9908,9925,9949,9959,9972,9988,9989,10009,10010,10015,10037,10042,10058,10064,10090,10104,10105,10121,10138,10161,10166,10226,10244,10255,10314,10379,10414,10420,10423,14549,14552,346,927,1286,1462,2327,2956,3443,3557,4122,4486,4549,4664,5293,5338,5724,6087,6618,7832,7962,8441,8469,8539,8739,8956,9112,9362,9702,9778,10109,10141,391,1596,1696,1980,2140,2143,3354,3202,3822,3962,3986,4097,4399,4398,4412,4515,5558,5655,5681,6029,6267,6327,6595,6623,6802,7182,7340,7364,7497,7570,7588,7590,7754,7805,7861,7887,7951,8222,8361,8461,8464,8472,8559,8594,8616,8623,8656,8717,8729,8800,8955,8995,9004,9314,9436,9438,9535,9658,10358,3972,4678,5789,6782,7210,8267,8277,8393,8725,10201)
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 | 1604 | 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 | 1604 | |
| 3 | DERIVED | NULL | NULL | NULL | ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ | NULL | NULL | NULL | No tables used |
| Status | Duration |
|---|
| Starting | 0.81 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.65 ms |
| Optimizing | 0.40 ms |
| Statistics | 0.17 ms |
| Preparing | 0.08 ms |
| Creating tmp table | 0.06 ms |
| Sorting result | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.35 ms |
| Removing tmp table | 0.02 ms |
| Sending data | 32.95 ms |
| Creating sort index | 5.11 ms |
| Removing tmp table | 0.56 ms |
| Creating sort index | 0.02 ms |
| End of update loop | 0.02 ms |
| Removing tmp table | 0.02 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.01 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.07 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 |
