Χρόνος επερώτησης:34.96 ms Μετά την τελευταία επερώτηση:1.33 ms Μνήμη με επερώτηση: 0.073 MB Μνήμη πριν την επερώτηση: 3.808 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-04 02:53:41' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-04-04 02:53:41' )
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,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,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,466,494,498,503,673,678,693,697,701,720,814,843,895,896,942,974,1328,1398,1480,1525,1540,1566,1735,1797,1807,1824,1867,1869,2055,2120,2163,2600,2498,2799,3080,209,422,3158,3199,3219,3227,3385,3419,3420,3421,3432,3431,3453,3485,3492,3501,3518,3544,3556,3570,3573,2339,3618,3645,3679,3650,3732,3749,3770,3773,3817,3818,3850,3882,3905,3914,3926,3925,3962,3965,3982,3984,3996,4018,4096,4112,4119,4122,4184,4190,4213,4218,4223,4315,4317,4325,4331,4428,4467,4475,4505,4508,4605,4626,4664,4674,4676,4680,4733,4746,4670,4820,4837,5038,5103,5199,5246,5257,5401,5449,5468,5506,5525,5589,5618,5639,5644,5774,5837,6019,6031,6064,6169,6206,6217,6225,6267,6426,6578,6672,6681,6759,6771,6773,6812,6839,7118,7237,7275,7338,7347,7352,7424,7445,7451,7493,7496,7518,7579,7584,7591,7655,7690,7760,7761,7773,7820,7854,7893,7897,7917,7995,8021,8050,8064,8097,8110,8131,8150,8204,8248,8266,8289,8312,8325,8332,8334,8368,8384,8411,8419,8430,8477,8480,8488,8527,8549,8553,8557,8578,8616,8617,8690,8695,8697,8700,8730,8746,8749,8771,8778,8803,8830,8864,8924,8979,8999,9022,9035,9037,9069,9086,9153,9161,9182,9205,9214,9229,9287,9487,9499,9593,9680,9756,9789,9805,9846,9916,9963,10070,10093,10098,10112,10189,10287,362,366,408,621,736,935,1027,1028,1195,1409,1469,1576,1854,1990,2080,2195,2569,2832,2854,3040,3340,3532,3638,3642,3646,3660,3675,3208,4104,4105,4106,4107,4108,1783,2979,4389,4449,4457,4554,4566,4636,4650,4658,4673,4687,4693,4700,4794,4806,4841,4882,4911,4992,5047,5057,5067,5066,5157,5209,5243,5284,5327,5333,5421,5467,5502,5538,5586,5600,5608,5651,5667,5697,5724,5738,5765,5783,5785,5808,5852,5916,5969,5979,6057,6128,6137,6143,6173,6209,6586,6647,6671,6674,6772,6821,6822,6838,6860,6861,6977,7015,7212,7217,7225,7250,7325,7412,7414,7456,7515,7513,7558,7580,7605,7636,7662,7837,7857,8042,8155,8179,8208,8252,8265,8298,8423,8694,8728,8750,8758,8766,8956,9133,9235,9277,9317,9345,9354,9363,9394,9428,9479,9482,9508,9560,9572,9595,9600,9606,9673,9686,9721,9741,9776,9781,9787,9794,9807,9824,9887,9952,9954,10026,10039,10113,10125,10139,10185,10399,10427,10709,10783,1041,1132,1266,1293,1435,1515,1597,1767,2145,2310,2342,2487,2488,2714,2751,2963,2683,3467,3483,3486,3526,2762,3687,3861,5663,5670,5758,6313,8067,8154,8625,8674,8860,8869,8919,8966,9002,9065,9078,9092,9105,9144,9176,9276,9292,9422,9711,9778,9825,9839,9943,9958,9976,9985,10012,10059,10157,10219,10230,10281,10323,10347,10905,14555)
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 | 1455 | 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 | 1455 | |
| 3 | DERIVED | NULL | NULL | NULL | ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ | NULL | NULL | NULL | No tables used |
| Status | Duration |
|---|
| Starting | 0.85 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.56 ms |
| Optimizing | 0.51 ms |
| Statistics | 0.17 ms |
| Preparing | 0.07 ms |
| Creating tmp table | 0.10 ms |
| Sorting result | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.32 ms |
| Removing tmp table | 0.01 ms |
| Sending data | 27.84 ms |
| Creating sort index | 3.79 ms |
| Removing tmp table | 0.37 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.01 ms |
| Freeing items | 0.05 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 |