Време на заявката: 2.23 ms След последната заявка: 0.38 ms Памет за заявки: 0.040 MB Памет преди заявката: 3.426 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-03-25 17:29:22')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-03-25 17:29:22')
AND i.access IN(1,1)
AND c.access IN(1,1)
AND c.published = 1
AND c.trash = 0
AND i.id IN(200,371,498,567,568,569,570,640,800,830,1018,1211,1565,1575,1613,1749,1803,2014,2585,2907,3172,3554,3558,3773,6847,6890,6903,6908,6912,6914,7031,7040,7073,7091,7096,7115,7123,7131,7133,7156,7165,7169,7221,7223,7225,7389,7399,7400,7455,7537,7759,7774,7779,7883,8036,8053,8067,8166,8229,8233,8237,8287,8335,8358,8387,8441,8457,8546,8547,8550,8559,8570,8648,8696,8705,8707,8760,8792,8810,8820,8848,8860,9029,9085,9105,9233,9268,9293,9296,9300,9307,9309,9311,9313,9316,9317,9319,9320,9321,9327,9334,9341,9353,9366,9394,9399,9442,9450,9462,9479,9507,9517,9519,9530,9568,9598,9628,9645,9648,9659,9664,9671,9684,9691,9698,9699,9700,9703,9704,9706,9709,9710,9712,9715,9719,9721,9738,9757,9758,9760,9764,9765,9778,9786,9804,9805,9816,9861,9914,9921,9931,9938,9943,9946,10122,10131,10134,10148,10160,10218,10372,10425,10539,10577,10588,10753,10885,10892,10972,10985,10988,10989,10993,11008,11010,11057,11103,11109,11251,11257,11258,11259,11262,11267,11270,11280,11303,11306,11324,11333,11345,11355,11380,11602,11603,11606,11612,11671,11673,11745,11780,11973,12067,12087,12157,12267,12289,12294,12351,12358,12471,12491,12548,12558,12566,12574,12593,12681,12689,12691,12695,12729,12734,12764,12795,12804,12809,12828,12838,12845,12849,12858,12880,12883,12903,12999,13015,13019,13024,13031,13049,13099,13100,13237,13247,13265,13361,13519,13553,13627,13769,13782,13803,13848,13860,13915,13916,13998,14009,14277,14316,14388,14471,14532,14541,14547,14584,14639,14644,14695,14761,14788,15002,15005,15024,15051,15062,15078,15110,15178,15183,15200,15210,15214,15217,15242,15248,15366,15378,15459,15465,15467,15474,15476,15528,15659,15694,15715,15752,15753,15758,15767,15781,15792,15798,15799,15805,15819,15822,15824,15879,15954,15960,15976,16011,16012,16022,16168,16169,16180,16279,16417,16458,16480,16534,16540,16621,16624,16628,16665,16745,16886,16906,16966,17014,17213,17242,17287,17314,17378,17456,17561,17602,17650,17841,17876,17882,17894,17901,17991,17994,18014,18017,18059,18120,18122,18124,18128,18130,18201,18331,18441,18451,18531,18545,18572,18789,18824,18836,18838,18928,18940,18942,18994,19014,19029,19096,19098,19100,19119,19123,19130,19132,19139,19148,19156,19163,19168,19169,19173,19189,19190,19195,19196,19197,19206,19207,19210,19213,19217,19222,19223,19225,19226,19233,19235,19238,19239,19242,19243,19244,19251,19253,19254,19255,19258,19261,19262,19264,19266,19268,19269,19271,19274,19279,19284,19298,19313,19314,19316,19318,19326,19334,19346,19348,19356,19363,19367,19370,19385,19408,19413,19418,19429,19432,19434,19438,19442,19444,19446,19451,19459,19460,19461,19465,19470,19472,19475,19477,19480,19487,19489,19497,19510,19528,19530,19543,19550,19554,19558,19563,19567,19579,19580,19581,19584,19598,19600,19603,19620,19633,19635,19658,19659,19669,19679,19684,19694,19734,19739,19764,19769,19783,19784,19787,19790,19793,19797,19809,19822,19833,19843,19846,19858,19894,19898,19908,19920,19925,19935,19957,19958,19977,19992,20010,20017,20044,20046,20050,20057,20062,20064,20066,20073,20075,20076,20082,20084,20086,20100,20109,20115,20148,20152,20163,20184,20199,20200,20203,20209,20215,20219,20220,20222,20223,20246,20253,20267,20296,20300,20317,20338,20353,20354,20380,20383,20386,20389,20393,20409,20410,20438,20463,20465,20487,20496,20501,20570,20578,20587,20595,20598,20601,20602,20605,20609,20611,20618,20660,20680,20684,20696,20704,20714,20783,20797,20800,20845,20861,20862,20866,20870,20877,20887,20994,21052,21059,21111,21150)
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 | 599 | 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.23 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.00 ms |
Init | 0.10 ms |
Optimizing | 0.07 ms |
Statistics | 0.66 ms |
Preparing | 0.85 ms |
Sorting result | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.14 ms |
End of update loop | 0.01 ms |
Query end | 0.00 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 |