Χρόνος επερώτησης:31.97 ms Μετά την τελευταία επερώτηση:0.48 ms Μνήμη με επερώτηση: 0.073 MB Μνήμη πριν την επερώτηση: 3.803 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 08:47:19' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-05-04 08:47:19' )
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,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,8427,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,257,351,378,381,389,438,449,458,460,461,472,473,490,495,496,619,625,632,635,663,691,703,723,751,762,783,784,838,839,843,902,933,958,959,963,964,982,1018,1020,1034,1055,1068,1104,1168,1185,1187,1176,1175,1266,1267,1331,1334,1398,1396,1402,1406,1435,1471,1507,1508,1509,1515,1537,1544,1558,1630,1635,1770,1846,1888,1893,2064,1019,468,2105,2165,2287,2418,2484,2488,2586,2709,2492,2747,2802,2851,2917,2962,3038,1170,3054,615,475,1268,3266,3351,1005,827,394,2961,2052,1786,1803,1785,1080,2323,898,509,399,2678,4089,4603,1809,4893,5332,5512,249,5943,6047,6081,6196,6445,6598,6612,6679,6682,6715,6739,7159,7270,7293,7347,7399,7494,7531,7561,7643,7670,7745,7865,8000,8005,8039,8050,8062,8063,8067,8069,8082,8085,8092,8100,8139,8168,8323,8372,8682,8683,8686,8830,8837,9358,9471,9898,10013,10212,307,384,705,1007,1054,1195,1222,1261,1400,1440,1516,1607,1643,1661,1703,1845,1849,1859,1993,2010,1663,2255,2265,2400,2401,2447,2496,2500,2499,2236,2697,2720,2211,999,2806,2807,2836,2850,2875,2935,2982,2995,3049,1642,993,3094,3112,3116,3147,3327,3385,3381,3412,3413,3435,3432,3477,3504,815,1001,3382,3616,3799,3885,3886,3903,3965,3974,4003,4087,4101,4253,4368,4443,4450,4468,4486,4492,4562,4588,4632,4677,4689,4690,4714,4749,4670,4805,4877,4950,4999,5018,5042,5082,5092,5135,5152,5158,5181,5199,5210,5213,5272,5276,5309,5373,5408,5418,5440,5480,5515,5567,5591,5610,5611,5678,5712,5816,5826,5827,5843,5894,5936,6019,6040,6097,6124,6176,6184,6207,6280,6277,6281,6310,6324,6330,6357,6581,6592,6638,6654,6653,6658,6663,6668,6697,6699,6711,6714,6743,6821,6852,7032,7287,7302,7392,7430,7452,7517,7557,7563,7674,7678,7744,7789,7790,7804,7808,7822,7870,7873,7879,7937,7977,7995,8023,8027,8028,8040,8044,8078,8080,8087,8178,8199,8223,8224,8319,8327,8332,8384,8414,8450,8481,8515,8547,8573,8597,8625,8634,8640,8641,8658,8725,8753,8754,8764,8796,8852,8911,8914,8934,9022,9089,9090,9106,9127,9163,9268,9370,9444,9496,9581,9618,9642,9655,9661,9691,9758,9761,9765,9773,9804,9820,9870,9906,9948,9986,9995,10046,10067,10110,10142,10191,10197,10202,10227,10296,10300,407,417,423,722,835,917,1076,1079,1143,1148,1333,1361,1410,1426,1427,1486,1552,1906,1991,1899,2109,2154,2135,1608,2930,3008,3088,376,3109,3210,1562,3251,3303,3322,3357,3411,3418,3438,3433,3431,3481,3574,3568,3567,3608,3609,3587,3627,3679,3724,3737,3750,3758,3767,3770,3777,3789,3819,3831,3850,3851,3860,3939,3951,3954,3959,3966,3980,3982,3983,3995,3996,4018,4023,4026,4028,4052,4054,4066,4071,4090,4098,4111,4116,4119,4121,4129,4139,4143,4156,4162,4167,4190,4213,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,4473,4476,4487,4490,4505,4520,4536,4545,4548,4561,4576,4627,4660,4698,4709,4711,4707,4634,4754,4771,4818,4836,4837,4873,4943,5040,5084,5093,5193,5228,5252,5353,5365,5506,5542,5653,5897,5902,5912,5917,5961,3185,6094,6112,6307,6331,6573,6769,6805,6809,6839,6866,7062,7116,7163,7218,7259,7359,7469,7472,7589,7749,7830,7868,7869,7872,7967,8101,8136,8169,8180,8231,8240,8263,8398,8419,8456,8566,8587,8687,8812,8814,8817,8892,9055,9144,9250,9446,9501,9545,9675,9685,9707,9762,10179,10256,949,1053,1408,1704,1808,2031,2065,2332,2563,2580,2713,1686,401,2049,1166,934,3592,2066,3715,4493,4514,4556,4619,4934,5294,5951,7269,7393,7656,7825,7945,7992,8132,8839,8873,9445,9640,9858,9876,9914)
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 | 1316 | 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 | 1316 | |
| 3 | DERIVED | NULL | NULL | NULL | ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ | NULL | NULL | NULL | No tables used |
| Status | Duration |
|---|
| Starting | 0.45 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.29 ms |
| Optimizing | 0.22 ms |
| Statistics | 0.12 ms |
| Preparing | 0.05 ms |
| Creating tmp table | 0.03 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.20 ms |
| Removing tmp table | 0.01 ms |
| Sending data | 26.60 ms |
| Creating sort index | 3.46 ms |
| Removing tmp table | 0.28 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 |