Χρόνος επερώτησης:9.67 ms Μετά την τελευταία επερώτηση:0.58 ms Μνήμη με επερώτηση: 0.105 MB Μνήμη πριν την επερώτηση: 3.788 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-01 07:13:22' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-11-01 07:13:22' )
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 (197,308,580,644,662,674,712,762,855,862,935,956,975,980,1250,1278,1295,1332,1778,1819,1867,2032,2033,2295,2317,2383,2805,2845,203,416,613,3264,3333,1005,3465,3678,3683,3725,3733,3751,3757,3766,3780,3794,3822,3891,3907,3923,3941,3991,3992,4001,4049,4075,4094,4109,4120,4164,4292,4296,4343,4367,4376,4389,4396,4412,4424,4473,4477,4515,4565,4894,4985,5306,5340,5414,5577,4865,5978,6623,6669,6698,6726,6738,6781,5919,6977,7055,6783,7195,7378,7398,7411,7420,7662,7692,7777,7919,7940,8045,8047,8069,8113,8153,8174,8209,8221,8233,8283,8296,8313,8328,8362,8536,8684,8688,8689,8768,8786,8831,8875,8882,8944,8977,9067,9212,9293,9296,9345,9413,9462,9490,9547,9579,9670,9783,9812,9819,9896,9949,10088,10094,10095,10153,10207,10285,10771,10808,379,425,447,448,449,458,460,461,470,472,488,489,495,496,503,505,507,576,595,598,604,609,611,614,617,622,625,626,627,650,653,657,676,677,678,681,682,686,693,703,685,718,723,731,733,734,737,739,751,761,770,773,784,809,816,820,839,856,857,863,869,879,900,902,927,939,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,597,606,590,599,608,579,504,3117,3168,3216,1268,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,3913,591,4059,4125,4138,649,4146,4150,4170,4187,4186,4195,4285,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,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,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,9252,9253,9364,9365,9371,9392,9446,9477,9480,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,362,366,408,621,671,706,736,847,942,973,1027,1028,1195,1398,1409,1469,1566,1576,1854,1990,2080,2152,2198,2195,2569,2699,2832,2854,3040,747,3340,3524,3532,3555,3603,3638,3642,3646,3660,3675,3689,3711,3731,3748,3761,3208,3776,3787,3797,3809,3812,3818,3825,3846,3868,3870,3875,3881,3882,3885,3886,3900,3902,3929,3940,3953,3956,3958,3961,3975,3979,3981,3998,4005,4014,4015,4016,4019,4036,4048,4051,4057,4061,4099,4104,4105,4106,4107,4108,4110,4113,4123,4133,4128,4176,4178,4210,4217,4224,4241,4249,4251,4270,4272,4279,4287,4297,4304,4318,4327,4329,1783,2979,4368,4374,4401,4410,4449,4457,4491,4508,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,5429,5449,5467,5502,5538,5586,5600,5608,5639,5651,5667,5680,5697,5724,5738,5765,5783,5785,5808,5852,5876,5886,5916,5969,5979,6057,6064,6128,6137,6143,6169,6173,6209,6315,6586,6647,6671,6674,6772,6773,6821,6822,6838,6860,6861,7015,7212,7217,7225,7250,7284,7325,7412,7414,7451,7456,7515,7513,7558,7580,7605,7636,7693,7699,7707,7801,7837,7857,7879,7883,7893,8042,8102,8117,8146,8155,8179,8185,8208,8252,8265,8274,8291,8298,8379,8423,8477,8599,8694,8699,8711,8728,8750,8758,8766,8792,8795,8908,8922,8941,8956,9028,9041,9052,9085,9133,9235,9277,9317,9354,9363,9394,9428,9479,9508,9560,9572,9595,9600,9606,9673,9686,9721,9738,9741,9756,9776,9781,9787,9794,9807,9816,9824,9887,9904,9944,9952,9954,9988,10015,10024,10026,10039,10064,10090,10113,10125,10134,10139,10185,10399,10427,10709,10783)
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 | 118 | 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.89 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.03 ms |
| table lock | 0.04 ms |
| init | 0.49 ms |
| Optimizing | 0.20 ms |
| Statistics | 1.46 ms |
| Preparing | 1.50 ms |
| Sorting result | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 4.62 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.06 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 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 |