Χρόνος επερώτησης:4.91 ms Μετά την τελευταία επερώτηση:0.33 ms Μνήμη με επερώτηση: 0.105 MB Μνήμη πριν την επερώτηση: 3.758 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-08 12:07:01' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-05-08 12:07:01' )
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 (466,471,494,498,503,505,632,673,678,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,209,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,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,407,417,423,469,507,626,722,835,917,1076,1079,1143,1148,1333,1334,1361,1410,1426,1427,1486,1552,1906,1991,1899,2109,2154,2135,1608,2806,2831,2930,3008,3088,376,3109,3210,1562,3251,3266,3303,3322,3357,3411,3412,3418,3438,3433,3477,3481,3574,3568,3567,3608,3609,3587,3614,3627,3724,3737,3750,3758,3760,3767,3777,3789,3819,3831,3851,3860,3873,3939,3951,3954,3959,3966,3974,3980,3983,3995,4023,4026,4028,4052,4054,4066,4071,4090,4098,4111,4116,4121,4129,4139,4143,4156,4162,4167,4214,4225,4238,4244,4255,4263,4280,4284,4288,4295,4307,4320,4363,4380,2253,4382,4395,4408,4416,4417,4439,4440,4452,4462,4466,4468,4473,4476,4487,4490,4520,4536,4545,4548,4561,4576,4627,4660,4698,4709,4711,4707,4634,4754,4771,4818,4836,4873,4943,5040,5084,5093,5193,5228,5252,5353,5365,5542,5653,5897,5902,5912,5917,5961,3185,6094,6112,6307,6331,6573,6663,6769,6805,6809,6866,7062,7116,7163,7218,7259,7359,7469,7472,7589,7749,7830,7868,7869,7872,7967,8101,8136,8169,8180,8231,8240,8263,8398,8456,8566,8587,8687,8812,8814,8817,8892,9055,9144,9250,9446,9501,9545,9675,9685,9707,9758,9762,10179,10256,658,659,743,792,812,1016,1093,1156,1337,2110,2712,2696,2492,2249,1686,1472,713,2765,714,3096,3363,3379,3388,3405,3407,3426,3435,3429,3452,3460,3463,3468,3478,3486,3517,3525,3530,3533,3541,3516,3488,1732,1040,3542,3552,3589,3586,3585,3613,3615,3620,3621,3632,3643,3644,3648,3659,3666,3672,3673,3674,3687,3693,3714,3727,3730,3742,3745,3754,3778,3796,3813,3820,3834,3842,3847,3864,3878,3894,3911,3942,3968,3898,4013,4083,4135,4136,4158,4174,4191,4199,4221,4222,4262,4276,4298,491,1039,1066,2299,3462,3430,3150,3469,4365,4390,4415,4432,4442,4492,4530,4584,4642,4649,4785,4817,4871,4872,4891,4935,4939,4988,5029,5045,5061,5112,5189,5225,5153,5304,5457,5532,5563,5564,5582,5617,5647,5710,5805,5863,5477,5913,6024,6063,6607,6646,6757,6774,6788,6855,7010,7271,7296,7357,3534,7565,7701,7881,7990,8031,8095,8129,8140,8158,8216,8237,8318,8380,8390,8427,8448,8621,8741,8754,8841,8890,8913,8968,9330,9344,9467,9480,9663,9735,9880,9903,10000,10128,10143,10182,10200,10423,10566,978,1041,1132,1248,1266,1293,1435,1515,1597,1601,1767,2145,2298,2310,2342,2487,2488,2714,2749,2751,2960,2963,2683,3467,3483,3526,2762,3861,5663,5670,5758,6313,8067,8154,8625,8674,8860,8869,8919,8966,9002,9065,9078,9092,9105,9176,9276,9292,9422,9711,9778,9825,9839,9943,9958,9976,9985,10012,10059,10157,10219,10230,10281,10323,10347,10905,14555,1902,3503,6739,7646,9466,9618,9674,9737,10214)
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 | 129 | 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.56 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.39 ms |
| Optimizing | 0.19 ms |
| Statistics | 1.22 ms |
| Preparing | 1.24 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 1.13 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.02 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 |