Време на заявката: 4.13 ms След последната заявка: 0.40 ms Памет за заявки: 0.055 MB Памет преди заявката: 3.403 MB Върнати редове: 3
SELECT i.*, c.alias AS categoryalias
FROM dui0l_k2_items AS i
LEFT JOIN dui0l_k2_categories AS c
ON c.id = i.catid
WHERE i.published = 1
AND i.trash = 0
AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2023-05-30 00:46:07')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-05-30 00:46:07')
AND i.access IN(1,1)
AND c.access IN(1,1)
AND c.published = 1
AND c.trash = 0
AND i.id IN(273,794,860,1493,1519,1592,1784,1795,1914,1937,1987,2177,2249,2725,2778,2819,3003,3246,3256,3400,3830,6746,6775,6783,6873,6993,6999,7054,7075,7093,7118,7214,7218,7225,7381,7543,7569,7578,7621,7650,7690,7718,7721,7741,7755,7772,7774,7880,7953,8169,8201,8239,8241,8294,8295,8356,8376,8466,8536,8574,8664,8701,8721,8788,8904,9024,9049,9230,9399,9436,9502,9505,9512,9574,9583,9602,9604,9721,9737,9853,9854,9873,10043,10045,10046,10055,10107,10121,10179,10232,10288,10295,10301,10338,10361,10369,10377,10384,10385,10390,10391,10392,10437,10453,10479,10530,10604,10882,10921,10968,10982,10984,10986,11013,11088,11164,11215,11277,11311,11316,11350,11413,11416,11417,11439,11507,11508,11517,11525,11528,11534,11582,11585,11598,11601,11629,11635,11645,11692,11741,11755,11783,11798,11831,11857,11893,11897,12074,12099,12160,12201,12224,12241,12248,12343,12357,12420,12498,12726,12786,12820,12844,12921,12940,12971,12982,13043,13098,13368,13436,13456,13462,13469,13476,13504,13510,13511,13513,13519,13524,13525,13533,13559,13565,13575,13601,13604,13624,13640,13649,13655,13658,13668,13679,13728,13773,13778,13791,13798,13809,13850,13903,13951,14038,14061,14062,14139,14149,14212,14228,14282,14295,14316,14384,14405,14424,14425,14428,14462,14477,14616,14699,14704,14876,14891,15031,15044,15068,15073,15084,15086,15096,15099,15106,15120,15130,15188,15200,15257,15268,15365,15367,15369,15370,15378,15431,15434,15439,15446,15450,15462,15487,15587,15715,15731,15746,15804,15928,15949,15953,15954,15976,15979,16012,16014,16033,16066,16095,16109,16112,16139,16168,16169,16178,16180,16224,16226,16231,16240,16264,16266,16376,16382,16401,16458,16516,16577,16664,16665,16674,16679,16682,16684,16685,16694,16707,16723,16767,16928,17089,17155,17245,17359,17393,17476,17536,17579,17694,17784,17964,17986,17994,18017,18097,18098,18114,18222,18224,18228,18241,18246,18250,18273,18282,18309,18334,18358,18386,18399,18451,18479,18530,18562,18607,18635,18659,18695,18745,18749,18779,18816,18838,18882,18908,18939,18963,18994,19014,19031,19052,19071,19077,19079,19081,19087,19088,19099,19100,19101,19108,19112,19114,19115,19116,19117,19122,19125,19126,19129,19137,19140,19145,19147,19148,19152,19160,19161,19169,19178,19204,19206,19209,19222,19227,19261,19271,19283,19297,19298,19310,19311,19312,19317,19324,19325,19331,19333,19334,19336,19347,19363,19364,19370,19385,19404,19410,19432,19438,19444,19460,19470,19475,19476,19487,19515,19530,19532,19534,19543,19554,19558,19562,19563,19565,19567,19584,19596,19598,19600,19603,19620,19623,19624,19627,19633,19635,19640,19644,19646,19654,19658,19659,19663,19675,19679,19684,19694,19711,19712,19717,19718,19723,19725,19734,19738,19739,19740,19743,19744,19757,19758,19760,19774,19777,19785,19792,19799,19805,19807,19822,19858,19865,19877,19878,19879,19897,19898,19900,19920,19928,19952,19955,19958,19960,19977,19987,19992,20010,20013,20023,20030,20046,20050,20051,20071,20128,20160,20163,20177,20197,20203,20207,20209,20215,20217,20224,20225,20226,20231,20247,20248,20249,20252,20259,20261,20277,20280,20287,20308,20309,20314,20315,20317,20350,20379,20380,20387,20409,20410,20412,20413,20414,20419,20430,20458,20477,20505,20510,20524,20551,20558,20571,20573,20593,20621,20680,20684,20696,20703,20705,20761,20783,20799,20804,20843,20853,20857,20866,20883,20909,21052,21163,21234,21298,21362,21366,21400,21422,21426,21429)
ORDER BY i.id DESC
LIMIT 0, 3
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | i | range | PRIMARY,item,catid | PRIMARY | 4 | NULL | 570 | Using where |
1 | SIMPLE | c | eq_ref | PRIMARY,category,published,access,trash | PRIMARY | 4 | big5_archdb.i.catid | 1 | Using where |
Status | Duration |
---|
Starting | 0.41 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Init | 0.18 ms |
Optimizing | 0.12 ms |
Statistics | 1.22 ms |
Preparing | 1.36 ms |
Sorting result | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.48 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.02 ms |
Closing tables | 0.02 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.03 ms |
Updating status | 0.02 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/itemlist.php:686 |
12 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:290 |
11 | K2ViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:19 |
9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:78 |
8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:64 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |