Χρόνος επερώτησης:86.47 ms Μετά την τελευταία επερώτηση:0.71 ms Μνήμη με επερώτηση: 0.089 MB Μνήμη πριν την επερώτηση: 3.838 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 14:26:36' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-05-04 14:26:36' )
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 (38,59,84,418,463,466,470,469,464,478,488,503,507,576,598,609,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,2490,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,3607,3586,3612,3613,3614,3617,3618,3620,3621,3634,3643,3644,3645,3669,3671,3677,3684,3687,3686,3693,3695,3705,3707,3709,3714,3718,3721,3723,3727,3730,3732,3735,3741,3743,3754,3755,3760,3768,3769,3773,3772,3790,3796,3801,3808,3813,3814,3815,3817,3820,3823,3834,3836,3842,3844,3845,3848,3858,3864,3866,3873,3883,3887,3889,3897,3901,3909,3914,3919,3922,3926,3927,3937,3942,3946,3955,3970,3971,3566,3984,3987,3993,3994,3997,4002,4006,4012,4013,4020,4029,4031,4034,4035,4037,4047,4055,4058,4060,4070,4085,4086,4092,4096,4112,4122,4127,649,4146,4157,4169,4177,4183,4184,4191,4200,4221,4229,4222,4235,4236,4246,4264,4271,4276,4293,4298,4301,4302,4309,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,5774,5794,5818,5830,5856,6016,6069,6089,6106,6129,6142,6165,6178,6204,6279,6372,6676,6741,6758,6313,6812,6859,6879,7180,7227,7271,7279,7283,7313,7315,7320,7341,7345,7368,7370,7376,7413,7440,7445,7487,7495,7496,7498,7555,7560,7579,7584,7587,7641,7644,7646,7648,7652,7667,7669,7685,7692,7698,7706,7726,7766,7800,7802,7823,7826,7831,7843,7848,7864,7881,7888,7906,7907,7909,7916,7956,7963,7970,7974,8024,8032,8051,8058,8073,8077,8088,8095,8097,8116,8145,8170,8198,8204,8205,8209,8213,8225,8228,8238,8252,8257,8258,8260,8267,8286,8304,8334,8347,8357,8380,8390,8413,8466,8480,8492,8509,8524,8529,8577,8584,8639,8690,8693,8708,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,9065,9072,9073,9077,9084,9101,9118,9148,9152,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,2261,3925,4135,4136,181,272,491,1446,1631,1835,2299,3028,3528,4546,4615,4679,5003,5653,6148,6589,6791,6834,7015,7444,7665,8676,8803,9903,9963,10423,858,1184,1854,1906,1993,2193,2393,2395,2471,2759,2832,2996,3029,2057,3054,376,3177,3252,3256,3348,3433,3432,3490,3492,3518,3525,3560,3531,3663,3680,3683,3722,3724,3748,2463,3576,3846,3878,3877,3905,3964,4038,4077,4194,4255,4294,4352,3150,4353,4388,4475,4513,4522,4547,4552,4575,4620,4638,4661,4685,4688,4675,4701,4634,4932,5020,5145,5198,5307,5348,5414,5562,5662,5826,5866,5999,6451,6601,6681,6709,6751,6790,7200,7212,7219,7228,7231,7249,7250,7254,7321,7349,7352,7356,7393,7403,7409,7419,7457,7472,7515,7516,7513,7556,7561,7589,7602,7609,7618,7619,7664,7672,7680,7697,7704,7722,7729,7745,7749,7750,7751,7752,7756,7759,7779,7787,7810,7825,7847,7854,7882,7890,7908,7938,7942,7945,7946,7955,7962,8011,8014,8015,8056,8114,8118,8123,8138,8148,8172,8180,8184,8187,8190,8207,8221,8231,8245,8251,8254,8256,8259,8262,8275,8319,8338,8365,8375,8381,8392,8393,8401,8404,8405,8419,8420,8441,8445,8447,8448,8456,8486,8488,8495,8516,8540,8544,8549,8557,8565,8586,8595,8608,8610,8634,8640,8646,8659,8665,8691,8695,8733,8745,8753,8767,8771,8783,8795,8796,8813,8814,8873,8892,8910,8928,8940,8948,8949,8954,9009,9012,9035,9059,9075,9087,9098,9184,9213,9241,9242,9251,9301,9323,9324,9433,9511,9583,9628,9640,9666,9688,9701,9706,9709,9712,9745,9755,9759,9760,9763,9771,9773,9774,9785,9805,9817,9846,9870,9885,9890,9902,9904,9910,9920,9941,9945,9948,9949,9953,9964,9975,9985,9986,9987,9989,10055,10056,10085,10087,10101,10107,10111,10115,10119,10120,10122,10161,10162,10205,10214,10225,10235,658,659,743,792,812,1016,1093,1156,1337,2110,2712,2696,2492,2249,1686,2765,2799,714,3096,3363,3379,3388,3407,3426,3435,3438,3431,3429,3452,3460,3463,3468,3477,3478,3486,3517,3530,3533,3541,3516,3488,1732,1040,3542,3589,3585,3615,3627,3632,3648,3659,3666,3672,3673,3674,3679,3737,3742,3745,3749,3770,3778,3789,3847,3850,3894,3911,3954,3968,3974,3898,3982,3996,4028,4054,4066,4083,4158,4167,4174,4199,4213,4225,4238,4262,1039,1066,3462,3430,3469,4415,4432,4442,4492,4530,4584,4642,4649,4785,4817,4871,4872,4891,4935,4939,4988,5029,5045,5061,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,7296,7357,3534,7565,7591,7701,7990,8021,8031,8129,8140,8150,8158,8216,8237,8318,8527,8621,8741,8754,8841,8890,8913,8968,9344,9467,9480,9663,9735,9762,9880,10128,10143,10182,10200,10566)
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 | 1137 | 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 | 1137 | |
| 3 | DERIVED | NULL | NULL | NULL | ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ | NULL | NULL | NULL | No tables used |
| Status | Duration |
|---|
| Starting | 0.63 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.38 ms |
| Optimizing | 0.31 ms |
| Statistics | 0.13 ms |
| Preparing | 0.07 ms |
| Creating tmp table | 0.05 ms |
| Sorting result | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.25 ms |
| Removing tmp table | 0.01 ms |
| Sending data | 29.56 ms |
| Creating sort index | 3.48 ms |
| Removing tmp table | 0.39 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.06 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 |