Χρόνος επερώτησης:6.26 ms Μετά την τελευταία επερώτηση:0.33 ms Μνήμη με επερώτηση: 0.105 MB Μνήμη πριν την επερώτηση: 3.754 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-07 00:52:23' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-05-07 00:52:23' )
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 (2312,209,590,3539,4405,9046,466,471,494,498,503,505,632,673,693,697,701,720,729,814,843,895,896,942,974,975,998,966,1085,1232,1328,1398,1480,1525,1540,1566,1735,1797,1807,1824,1867,1869,1975,2029,2055,2120,2163,2600,2498,766,2799,581,3080,422,499,3158,3199,3219,3227,3385,3419,3420,3421,3432,3431,3453,3485,3492,3501,3518,3519,3524,3544,3556,3555,3570,3573,2339,3588,3618,3645,3679,3650,3651,3722,3732,3749,3446,3770,3773,3790,3809,3817,3818,3825,3828,3837,3850,3859,3882,3885,3886,3900,3905,3912,3913,3918,3914,3926,3925,3962,3965,3981,3982,3984,3996,4016,4018,4044,4051,4096,4112,4113,4119,4122,4184,4187,4190,4192,4200,4211,4213,4218,4223,4231,4241,4251,4256,4265,4267,4270,4294,4315,4317,4318,4325,4331,421,4335,4428,4454,4467,4475,4505,4508,4519,4531,4605,4616,4626,4664,4674,4676,4680,4733,4746,4670,4820,4837,5038,5103,5132,5199,5246,5257,5401,5449,5468,5473,5506,5525,5589,5618,5639,5644,5774,5837,6019,6031,6064,6169,6206,6217,6225,6227,6267,6426,6578,6672,6681,6759,6771,6773,6812,6839,7118,7237,7252,7275,7297,7338,7347,7352,7424,7445,7451,7493,7496,7518,7579,7584,7591,7655,7690,7693,7736,7760,7761,7773,7820,7854,7893,7897,7917,7995,8021,8025,8050,8064,8097,8110,8131,8150,8176,8204,8248,8266,8289,8312,8325,8332,8334,8368,8384,8411,8419,8430,8477,8480,8488,8527,8549,8553,8557,8578,8615,8616,8617,8673,8690,8695,8697,8700,8730,8746,8749,8771,8778,8803,8830,8864,8922,8924,8979,8999,9022,9035,9037,9069,9085,9086,9153,9161,9182,9205,9214,9229,9287,9487,9499,9593,9680,9709,9756,9789,9805,9846,9916,9963,10070,10093,10098,10112,10189,10287,379,425,447,448,449,458,460,461,470,472,488,489,495,496,507,576,580,595,598,604,609,611,614,617,622,625,626,627,644,650,653,657,676,677,681,682,686,703,712,685,718,723,731,733,734,737,739,751,761,762,770,773,784,809,816,820,839,855,856,857,863,869,879,900,902,927,939,956,969,982,1071,1087,704,864,1176,1297,1331,1333,1338,1339,1394,1451,1458,1471,1504,1508,1509,1499,1612,888,1668,1694,1787,1821,1858,1882,1924,2022,748,468,2147,2544,2729,2772,2873,2926,2939,2940,2943,2948,2973,2992,3004,304,266,615,613,597,606,599,608,579,504,3117,3168,3216,1268,1985,1536,3509,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,4170,4186,4195,4285,4292,4296,4299,4300,4305,4308,4319,4324,4332,4355,4465,4494,4559,4560,4638,4654,4661,4697,4699,4725,4734,4847,4857,4964,648,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,8082,8085,8092,8098,8107,8112,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,8648,8653,8654,8655,8661,8671,8704,8722,8732,8737,8744,8807,8815,8826,8859,8861,8876,8899,8907,8973,9020,9023,9036,9172,9195,9212,9252,9253,9364,9365,9371,9392,9413,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,398,641,658,783,789,846,862,907,1010,1022,1234,1250,1264,1278,1332,1337,1340,1349,1569,1570,1630,1659,1819,1917,2033,2095,2180,2264,2343,2397,2546,2804,2941,3084,3145,3228,1725,3499,3678,3700,4024,4065,4076,4131,4147,4164,4396,4427,4686,4766,4822,5005,5264,5325,5410,6043,2197,5508,6625,6815,6816,7074,7221,7363,7439,7481,7645,7763,7807,7880,7895,8029,8069,8089,8096,8206,8215,8258,8272,8378,8425,8469,8489,8642,8752,9334,9440,9651,9760,10399)
ORDER BY i.created DESC
LIMIT 0, 6
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | i | index | PRIMARY,item,catid | created | 5 | NULL | 123 | Using where |
| 1 | SIMPLE | c | eq_ref | PRIMARY,category,published,access,trash | PRIMARY | 4 | ifitness_ifitnew.i.catid | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.91 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.57 ms |
| Optimizing | 0.30 ms |
| Statistics | 1.41 ms |
| Preparing | 1.09 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 1.74 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.04 ms |
| Updating status | 0.01 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 |