Време на заявката: 3.12 ms След последната заявка: 0.91 ms Памет за заявки: 0.056 MB Памет преди заявката: 3.438 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-29 10:05:27')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-05-29 10:05:27')
AND i.access IN(1,1)
AND c.access IN(1,1)
AND c.published = 1
AND c.trash = 0
AND i.id IN(166,200,210,217,227,280,371,452,494,498,567,568,569,570,627,640,800,830,1211,1218,1365,1565,1575,2005,2327,2328,2397,2585,2850,2900,2971,3006,3151,3196,3299,3483,3554,3558,3614,3773,5257,6612,6725,6741,6764,6767,6792,6822,6847,6890,6903,6908,6912,6914,6959,6965,6979,6987,7002,7004,7006,7013,7019,7023,7031,7039,7040,7043,7091,7096,7100,7106,7110,7115,7131,7133,7156,7165,7169,7208,7221,7223,7225,7233,7259,7300,7389,7399,7400,7430,7455,7482,7483,7488,7537,7666,7732,7759,7774,7779,7883,7937,8036,8045,8067,8103,8142,8159,8166,8198,8229,8233,8237,8238,8274,8281,8287,8297,8329,8351,8355,8358,8384,8387,8457,8506,8518,8546,8547,8550,8559,8570,8589,8648,8696,8704,8705,8707,8760,8792,8810,8820,8848,8860,9019,9021,9233,9264,9268,9293,9296,9300,9307,9309,9311,9313,9316,9317,9319,9320,9321,9327,9334,9341,9353,9359,9366,9391,9394,9396,9399,9442,9450,9462,9479,9495,9498,9507,9511,9517,9519,9530,9598,9628,9648,9664,9684,9691,9698,9699,9700,9703,9704,9706,9709,9710,9712,9715,9719,9721,9738,9757,9758,9760,9764,9765,9778,9816,9857,9882,9938,9940,10067,10141,10174,10177,10180,10184,10206,10212,10372,10407,10413,10449,10475,10476,10588,10710,10747,10750,10757,10790,10797,10802,10804,10809,10816,10820,10836,10838,10839,10840,10848,10853,10857,10868,10893,10896,10900,10904,10907,10919,10974,10993,11030,11037,11039,11043,11044,11052,11054,11056,11057,11061,11062,11067,11076,11090,11095,11108,11109,11115,11135,11143,11212,11213,11244,11257,11258,11259,11262,11267,11270,11280,11303,11306,11324,11328,11333,11345,11355,11380,11399,11468,11483,11524,11549,11554,11580,11596,11602,11603,11606,11612,11613,11624,11631,11671,11673,11745,11780,11796,11832,11849,11920,11931,11960,12048,12054,12067,12100,12116,12169,12196,12200,12207,12213,12221,12227,12230,12255,12267,12283,12294,12309,12340,12351,12358,12373,12383,12399,12400,12448,12471,12482,12491,12495,12497,12499,12506,12512,12518,12548,12552,12556,12557,12558,12566,12574,12600,12610,12616,12626,12628,12634,12639,12645,12648,12654,12662,12709,12734,12774,12803,12809,12823,12828,12838,12849,12858,12868,12880,12903,12924,12999,13024,13088,13135,13170,13174,13206,13215,13228,13246,13265,13430,13519,13553,13679,13700,13782,13803,13854,13860,13894,13915,13929,14016,14128,14245,14262,14277,14297,14312,14316,14388,14415,14419,14541,14547,14548,14570,14584,14639,14664,14671,14695,14717,14731,14739,14741,14744,14745,14750,14754,14759,14768,14776,14781,14788,14814,14856,14857,14884,14899,14968,15002,15005,15024,15051,15062,15078,15087,15110,15130,15200,15210,15214,15217,15242,15378,15391,15476,15507,15659,15694,15715,15752,15753,15758,15767,15781,15792,15798,15819,15822,15824,15851,15879,15908,15954,15976,16011,16012,16168,16169,16180,16223,16256,16259,16279,16343,16417,16480,16534,16624,16665,17213,17242,17314,17425,17621,17650,17782,17876,17882,17894,17901,17948,17980,17994,18007,18014,18017,18063,18120,18122,18128,18174,18259,18288,18441,18451,18457,18476,18496,18505,18546,18572,18789,18824,18838,18898,18904,18942,18959,18994,19014,19029,19045,19096,19098,19100,19105,19112,19114,19116,19119,19120,19123,19126,19130,19132,19139,19148,19156,19163,19169,19173,19189,19190,19195,19196,19206,19207,19210,19213,19217,19220,19222,19225,19226,19233,19235,19238,19239,19242,19243,19244,19247,19251,19253,19254,19255,19258,19261,19262,19264,19266,19268,19269,19271,19274,19279,19298,19313,19314,19316,19318,19320,19322,19326,19334,19346,19348,19356,19363,19367,19370,19383,19385,19408,19413,19418,19427,19429,19432,19434,19437,19438,19442,19444,19446,19451,19459,19460,19461,19465,19470,19472,19475,19477,19480,19487,19489,19510,19528,19530,19543,19554,19558,19563,19567,19579,19580,19581,19584,19598,19600,19603,19615,19620,19633,19635,19658,19659,19679,19684,19694,19734,19739,19764,19769,19783,19784,19787,19790,19793,19797,19809,19818,19822,19833,19845,19846,19853,19858,19894,19898,19908,19920,19925,19935,19954,19957,19958,19977,19979,19992,20010,20044,20046,20050,20057,20062,20064,20066,20067,20073,20075,20076,20084,20086,20088,20090,20115,20148,20163,20184,20185,20188,20199,20200,20209,20215,20219,20220,20222,20223,20246,20253,20255,20267,20289,20296,20317,20338,20353,20354,20370,20380,20383,20386,20389,20391,20393,20409,20410,20463,20478,20479,20483,20487,20496,20501,20542,20552,20562,20565,20587,20592,20595,20598,20601,20602,20605,20609,20611,20660,20662,20667,20680,20684,20696,20698,20704,20709,20714,20745,20783,20795,20797,20800,20830,20839,20845,20851,20866,20877,20900,20936,20941,20944,20954,20995,20996,21006,21035,21037,21052,21057,21058,21080,21108)
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 | 794 | 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.34 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.14 ms |
Optimizing | 0.10 ms |
Statistics | 0.91 ms |
Preparing | 1.17 ms |
Sorting result | 0.02 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.02 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 |