Време на заявката: 2.59 ms След последната заявка: 0.40 ms Памет за заявки: 0.040 MB Памет преди заявката: 3.447 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-01-28 19:40:31')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-01-28 19:40:31')
AND i.access IN(1,1)
AND c.access IN(1,1)
AND c.published = 1
AND c.trash = 0
AND i.id IN(73,74,76,84,95,96,124,127,130,131,148,150,152,153,154,162,175,318,319,336,524,528,575,775,904,1168,1621,1629,2124,2699,2902,3336,3428,6071,6685,6716,7205,7214,7223,7262,7435,7509,7526,7619,7790,7798,7801,7809,8119,8147,8161,8236,8298,8311,8314,8339,8350,8373,8444,8639,8803,9102,9171,9435,9438,9648,9810,10143,10849,11017,11118,11590,11870,12288,12665,12874,12888,12900,13002,13048,13149,13241,13512,13573,13795,13813,14310,14328,14604,14789,15151,15758,15929,16247,16368,16505,16518,16922,16938,16952,17000,17001,17012,17014,17016,17063,17077,17083,17085,17086,17131,17169,17171,17172,17176,17179,17185,17199,17204,17209,17210,17216,17232,17238,17250,17273,17279,17281,17282,17283,17285,17302,17314,17315,17318,17321,17322,17325,17328,17335,17337,17342,17348,17349,17350,17352,17369,17384,17386,17392,17393,17394,17402,17405,17406,17407,17408,17409,17412,17417,17425,17426,17433,17441,17459,17461,17467,17468,17469,17488,17489,17491,17503,17509,17524,17531,17537,17547,17549,17550,17551,17552,17555,17556,17561,17565,17572,17573,17574,17585,17586,17598,17599,17603,17607,17608,17610,17625,17643,17645,17646,17647,17652,17661,17665,17666,17668,17669,17670,17672,17673,17674,17675,17676,17685,17689,17690,17693,17698,17703,17713,17715,17717,17718,17719,17727,17736,17737,17738,17741,17747,17749,17758,17769,17770,17771,17775,17777,17779,17780,17786,17787,17788,17789,17790,17798,17800,17803,17804,17807,17808,17809,17811,17812,17814,17816,17819,17820,17821,17829,17833,17835,17839,17840,17843,17844,17846,17849,17851,17861,17865,17869,17874,17875,17897,17899,17904,17908,17912,17913,17916,17918,17919,17921,17927,17928,17931,17936,17945,17946,17955,17972,17976,17977,17979,17980,17981,17983,18003,18004,18009,18010,18025,18028,18032,18036,18037,18048,18050,18052,18065,18070,18072,18076,18077,18085,18088,18090,18110,18112,18115,18117,18121,18129,18131,18154,18159,18160,18172,18185,18188,18190,18191,18192,18193,18194,18213,18227,18237,18238,18248,18257,18261,18263,18277,18278,18290,18311,18325,18341,18344,18348,18371,18400,18404,18424,18429,18431,18447,18450,18469,18477,18485,18493,18497,18498,18518,18519,18523,18542,18545,18547,18548,18549,18550,18556,18573,18594,18595,18598,18599,18604,18611,18616,18620,18630,18638,18639,18641,18648,18670,18682,18685,18699,18701,18706,18708,18728,18729,18733,18743,18752,18757,18758,18763,18767,18770,18772,18776,18787,18789,18791,18796,18798,18807,18808,18809,18810,18821,18843,18848,18864,18877,18885,18891,18901,18903,18905,18906,18919,18921,18922,18924,18925,18935,18946,18965,18966,18978,18983,18991,18993,19002,19013,19017,19022,19027,19028,19037,19047,19061,19078,19083,19134,19136,19149,19155,19179,19181,19182,19211,19215,19228,19245,19256,19275,19284,19315,19319,19337,19357,19368,19387,19389,19406,19412,19422,19441,19445,19448,19450,19466,19471,19488,19491,19496,19508,19512,19514,19533,19557,19559,19583,19622,19634,19642,19649,19656,19672,19674,19692,19695,19710,19714,19741,19754,19759,19771,19775,19782,19786,19791,19808,19817,19823,19859,19875,19876,19896,19919,19922,19934,19940,19943,19957,19959,19995,20004,20025,20026,20048,20058,20070,20077,20097,20098,20104,20150,20165,20189,20194,20195,20216,20250,20278,20293,20303,20314,20322,20328,20334,20340,20355,20381,20408,20411,20441,20446,20457,20504,20505,20535,20536,20545,20555,20563,20588,20617,20623,20629,20652,20657,20666,20674,20679,20682,20695,20701,20706,20717,20719,20730,20731,20739,20745,20751,20779,20798,20824,20831,20838,20844,20850,20854,20860,20867,20874,20878,20893,20896,20904,20926,20946,20975,20997,21003,21007,21024,21026,21043,21050,21075,21082,21097,21100,21101,21105,21110,21112,21116)
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 | 620 | 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.25 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.11 ms |
Optimizing | 0.08 ms |
Statistics | 0.80 ms |
Preparing | 0.93 ms |
Sorting result | 0.01 ms |
Executing | 0.01 ms |
Sending data | 0.21 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 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 |