Χρόνος επερώτησης:37.79 ms Μετά την τελευταία επερώτηση:0.39 ms Μνήμη με επερώτηση: 0.073 MB Μνήμη πριν την επερώτηση: 3.841 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-03 23:17:06' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-04-03 23:17:06' )
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,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,8648,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,307,384,469,688,705,711,751,781,843,1007,1034,1054,1195,1222,1261,1400,1440,1515,1516,1607,1643,1703,1845,1849,1859,2010,1663,2156,2265,2400,2401,2447,2496,2500,2499,2236,2625,2697,2709,2720,2211,999,2806,2807,2836,2850,2875,2980,2982,2995,3049,1642,993,3094,3112,3116,3147,3327,3380,3385,3381,3405,3410,3412,3413,3419,3420,3421,3435,3432,3467,3477,3479,3485,3504,3511,3515,3526,815,1001,3614,3616,3617,3677,3687,3695,3705,3709,3714,3718,3721,3799,3801,3820,3887,3903,3914,3942,3946,3965,3971,3974,3566,4003,4060,4087,4101,4183,4246,4253,4338,4443,4450,4468,4486,4492,4528,4562,4588,4632,4651,4677,4689,4690,4714,4749,4670,4805,4877,4950,4999,5018,5042,5082,5092,5135,5152,5158,5181,5199,5210,5213,5272,5276,5309,5373,5408,5418,5440,5480,5515,5567,5591,5610,5611,5678,5712,5826,5827,5843,5894,5936,6019,6040,6097,6124,6176,6184,6207,6280,6277,6281,6310,6324,6330,6357,6581,6592,6638,6654,6653,6658,6663,6668,6679,6697,6699,6711,6715,6741,6743,6821,6852,7180,7283,7287,7302,7392,7430,7440,7452,7517,7557,7563,7674,7678,7744,7789,7790,7804,7808,7822,7870,7873,7937,7956,7977,7995,8023,8027,8028,8040,8044,8078,8080,8087,8088,8095,8178,8199,8223,8224,8267,8319,8327,8332,8384,8390,8414,8450,8481,8515,8547,8573,8597,8625,8634,8640,8658,8708,8725,8753,8754,8764,8796,8852,8893,8911,8914,8934,8974,9008,9022,9072,9089,9090,9106,9127,9163,9221,9268,9370,9444,9496,9581,9594,9642,9655,9661,9691,9758,9765,9773,9804,9820,9870,9948,9986,9995,10046,10067,10110,10142,10171,10191,10197,10202,10227,10296,10300,1709,1836,367,5369,1167,1424,1824,2060,2196,2344,2320,931,2930,3019,2912,2311,2172,2683,2134,2436,2057,1841,1490,1196,1166,1155,1154,1062,934,924,3079,3033,2978,2871,2843,2146,3082,615,3085,3102,3121,3224,3238,2405,3471,3533,3560,3376,3105,3693,3758,3819,3832,3851,3864,3945,4018,4098,4307,4356,4357,4408,4441,4535,4548,4620,4664,4750,4951,4954,4996,5010,5085,5117,5687,5828,6605,6622,6633,6666,6717,6765,6922,7387,7390,7419,7445,3239,3534,7513,7579,7609,7661,7708,7756,7770,7809,7817,7847,7851,7867,7909,7920,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,3120,4798,4813,4826,6613,6753,6850,7363,7791,7880,7896,7899,7904,7910,7921,7981,8159,8306,8523,8580,8585,8631,8715,8809,9208,9485,10005,10126,10327,10350,10480,10708)
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 | 1444 | 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 | 1444 | |
| 3 | DERIVED | NULL | NULL | NULL | ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ | NULL | NULL | NULL | No tables used |
| Status | Duration |
|---|
| Starting | 0.62 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.40 ms |
| Optimizing | 0.29 ms |
| Statistics | 0.14 ms |
| Preparing | 0.06 ms |
| Creating tmp table | 0.04 ms |
| Sorting result | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.26 ms |
| Removing tmp table | 0.01 ms |
| Sending data | 31.55 ms |
| Creating sort index | 3.75 ms |
| Removing tmp table | 0.38 ms |
| Creating sort index | 0.02 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.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 |