Χρόνος επερώτησης:6.21 ms Μετά την τελευταία επερώτηση:0.28 ms Μνήμη με επερώτηση: 0.058 MB Μνήμη πριν την επερώτηση: 3.742 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-04 13:56:59' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-05-04 13:56:59' )
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 (35,71,609,906,917,1187,1518,1528,1654,2441,2490,2681,3235,3413,3486,3492,3556,3574,3567,3607,3585,3627,3693,3735,3754,3832,3845,3868,3883,3908,3970,3981,3994,4013,4036,4052,4092,4096,4121,4133,4177,4190,4213,4251,4263,4280,4295,4309,4323,4352,4435,4445,4487,4490,4520,4536,4561,4707,4815,1809,4962,5471,5614,5687,5708,5774,6146,6293,6299,6324,6331,6647,6803,6812,6979,7315,7386,7400,7582,7612,7667,7733,7735,7783,7845,7846,7869,7885,7893,7903,7917,7938,7948,7967,8088,8197,8224,8238,8240,8263,8303,8400,8410,8446,8447,8466,8477,8516,8570,8586,8606,8640,8704,8707,8708,8771,8816,8836,8918,8941,8966,8984,9012,9029,9065,9074,9152,9284,9434,9446,9501,9530,9620,9669,9699,9718,9748,9764,9840,9841,9923,9933,9962,9967,10025,10096,10098,10110,10114,10191,10256,10339,14562,38,59,84,418,463,466,470,469,464,478,488,503,507,576,598,610,611,612,614,617,622,626,627,638,639,646,650,657,675,677,688,693,700,711,685,718,721,737,742,752,758,757,770,772,773,774,780,781,790,800,809,816,840,842,856,870,916,918,921,930,952,961,970,979,990,1021,1056,1078,1097,1134,1135,864,1158,1177,1221,1242,1271,1276,1297,1324,1338,1391,1394,1414,1441,1461,1473,1576,1601,1638,1658,1664,1688,1769,1776,1796,1798,1802,1840,1878,1897,1911,1930,1947,1960,1983,2011,2024,1035,748,730,645,462,2121,2122,2149,2156,2157,2170,2182,2192,2280,2327,2340,2507,2519,2535,2553,2554,2561,2565,2610,2611,2609,2604,2625,2672,2715,1902,1874,1472,713,2800,2805,2808,2831,2932,2950,2960,2980,2988,2989,3014,3030,2683,1490,3055,3071,3070,3084,340,291,426,600,500,606,603,590,599,584,608,504,3149,3167,3187,3193,3200,3211,1092,3240,637,1692,3365,3380,3387,3394,3395,3396,3405,3410,3415,3419,3420,3421,3436,3448,3455,3464,3467,3479,3483,3485,3493,3503,3511,3515,3520,3526,3552,3559,3558,3570,3580,3584,3599,3573,3545,2762,2613,2219,1095,3409,1197,3217,3605,3586,3612,3613,3614,3617,3618,3620,3621,3634,3643,3644,3645,3669,3671,3677,3684,3687,3686,3695,3705,3707,3709,3714,3718,3721,3723,3727,3730,3732,3741,3743,3755,3760,3768,3769,3773,3772,3790,3796,3801,3808,3813,3814,3815,3817,3820,3823,3834,3836,3842,3844,3848,3858,3864,3866,3873,3887,3889,3897,3901,3909,3914,3919,3922,3926,3927,3937,3942,3946,3955,3971,3566,3984,3987,3993,3997,4002,4006,4012,4020,4029,4031,4034,4035,4037,4047,4055,4058,4060,4070,4085,4086,4112,4122,4127,649,4146,4157,4169,4183,4184,4191,4200,4221,4229,4222,4235,4236,4246,4264,4271,4276,4293,4298,4301,4302,4316,4325,4326,4331,4334,4338,4346,4347,4349,4351,4356,4358,4362,4365,4369,4371,4372,4390,2612,4407,4458,4461,4471,4472,4481,4511,4518,4528,4529,4542,4563,4570,4580,4607,4611,4551,4617,4626,4640,4651,4671,4692,4702,4625,4716,4727,4745,4741,4764,4780,4784,4790,4816,4839,4906,4916,4928,4954,4973,4982,4986,5007,5019,5037,5049,5054,5062,5071,5089,5106,5112,5120,5144,5166,5222,5224,5190,5105,5246,5260,5323,5357,5388,5431,5432,5467,5529,5575,5576,5620,5625,5679,5693,5763,5794,5818,5830,5856,6016,6069,6089,6106,6129,6142,6165,6178,6204,6279,6372,6676,6741,6758,6313,6859,6879,7180,7227,7271,7279,7283,7313,7320,7341,7345,7368,7370,7376,7413,7440,7445,7487,7495,7496,7498,7555,7560,7579,7584,7587,7641,7644,7646,7648,7652,7669,7685,7692,7698,7706,7726,7766,7800,7802,7823,7826,7831,7843,7848,7881,7888,7906,7907,7909,7916,7956,7963,7970,7974,8024,8032,8051,8058,8073,8077,8095,8097,8116,8145,8170,8198,8204,8205,8209,8213,8225,8228,8252,8257,8258,8260,8267,8286,8304,8334,8347,8357,8380,8390,8413,8427,8480,8492,8509,8524,8529,8577,8584,8639,8690,8693,8730,8743,8756,8757,8776,8786,8797,8827,8828,8860,8884,8889,8893,8894,8901,8903,8919,8933,8974,8979,8988,8992,8996,9008,9047,9072,9073,9077,9084,9101,9118,9148,9207,9221,9257,9274,9327,9330,9359,9411,9518,9571,9580,9594,9619,9623,9630,9665,9682,9844,9871,9873,9895,9900,9915,9916,9917,9956,10000,10012,10061,10103,10108,10165,10171,10213,10261,10324,10357,10379,68,474,671,785,818,837,849,1287,1551,1633,1731,1770,1901,1927,2304,2584,2583,2590,2492,2814,1562,3331,3379,3408,3453,3454,3461,3480,3776,3859,3861,3865,3918,3965,3986,4030,4044,4067,4128,4140,4193,4313,4451,4467,4512,4544,4605,4687,4713,4762,4807,4981,4994,5016,5200,5403,5506,5786,6037,6083,6228,6645,6729,6839,7012,7255,7314,7342,7391,7626,7659,7671,7734,7760,7785,7830,7897,7943,7946,7947,7966,7975,7989,7998,8011,8110,8154,8246,8277,8285,8295,8495,8541,8546,8548,8554,8558,8599,8617,8624,8628,8645,8651,8658,8668,8674,8681,8710,8725,8785,8838,8839,8864,8875,8877,8967,9037,9048,9056,9233,9343,9410,9499,9653,9670,9735,9740,9747,9781,9972,10150,10201,10566,2342,931,2146,1052,4733,5257,5837,6681,6759,6827,7338,7352,7419,7773,7820,8029,8131,8248,8266,8368,8578)
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 | 111 | 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.47 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.30 ms |
| Optimizing | 0.16 ms |
| Statistics | 1.05 ms |
| Preparing | 1.07 ms |
| Sorting result | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 2.95 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.04 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 |