Време на заявката: 2.88 ms След последната заявка: 0.53 ms Памет за заявки: 0.040 MB Памет преди заявката: 3.446 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:14:39')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-03-25 17:14:39')
AND i.access IN(1,1)
AND c.access IN(1,1)
AND c.published = 1
AND c.trash = 0
AND i.id IN(172,200,371,498,567,568,569,570,610,640,800,830,1091,1211,1236,1267,1340,1456,1565,1575,1807,2585,2734,2899,3019,3554,3558,3773,5257,6670,6736,6753,6755,6758,6783,6784,6791,6800,6835,6845,6846,6847,6855,6890,6892,6903,6904,6908,6912,6914,6923,6934,6954,6998,7025,7031,7033,7040,7079,7091,7092,7096,7108,7115,7131,7133,7145,7156,7165,7169,7221,7223,7225,7226,7238,7294,7331,7371,7389,7399,7400,7429,7455,7461,7469,7499,7514,7537,7539,7553,7631,7634,7648,7657,7669,7673,7722,7728,7759,7774,7779,7783,7784,7786,7807,7842,7843,7857,7866,7868,7881,7883,7897,7904,7956,7963,7969,7978,7992,8036,8043,8063,8064,8065,8067,8077,8103,8133,8142,8143,8144,8146,8159,8166,8198,8201,8229,8233,8234,8237,8241,8259,8281,8287,8297,8299,8300,8350,8351,8356,8358,8369,8370,8381,8382,8387,8389,8406,8420,8455,8457,8472,8475,8485,8490,8497,8524,8530,8531,8537,8546,8547,8550,8554,8559,8570,8616,8648,8696,8701,8705,8707,8708,8760,8792,8810,8814,8817,8820,8839,8848,8860,8891,8898,8902,8934,8935,8937,9233,9268,9293,9296,9300,9307,9309,9311,9313,9316,9317,9319,9320,9321,9327,9334,9341,9350,9353,9366,9384,9394,9399,9442,9450,9462,9479,9507,9517,9519,9530,9554,9575,9598,9628,9648,9664,9680,9684,9685,9691,9694,9698,9699,9700,9703,9704,9706,9709,9710,9712,9715,9719,9721,9738,9757,9758,9760,9764,9765,9771,9773,9775,9778,9816,9852,9853,9859,9890,9938,9957,9965,10038,10135,10141,10156,10168,10170,10178,10372,10413,10458,10461,10477,10482,10505,10546,10588,10635,10659,10729,10740,10794,10802,10803,10826,10842,10858,10864,10866,10873,10881,10890,10896,10904,10907,10911,10920,10928,10932,10935,10944,10952,10967,10990,10993,11037,11043,11044,11054,11057,11074,11086,11087,11095,11109,11121,11128,11129,11130,11135,11257,11258,11259,11262,11267,11268,11270,11280,11303,11306,11321,11324,11333,11345,11354,11355,11357,11380,11506,11513,11525,11526,11535,11548,11596,11602,11603,11606,11612,11640,11641,11643,11671,11673,11745,11763,11780,12067,12158,12244,12267,12294,12351,12358,12421,12471,12491,12548,12558,12566,12568,12574,12595,12660,12734,12795,12802,12809,12811,12828,12838,12849,12853,12858,12880,12903,12966,12985,12999,13010,13024,13063,13071,13081,13162,13265,13354,13358,13394,13396,13446,13519,13553,13782,13803,13860,13915,13924,13926,13943,13991,13993,14263,14271,14277,14316,14388,14541,14547,14584,14639,14695,14788,15002,15005,15024,15037,15051,15062,15110,15200,15210,15214,15217,15242,15307,15309,15316,15378,15476,15648,15659,15694,15715,15752,15753,15758,15767,15781,15792,15798,15819,15822,15824,15879,15954,15976,16011,16012,16076,16168,16169,16170,16180,16182,16240,16247,16279,16283,16296,16358,16413,16417,16464,16480,16534,16624,16665,16667,16829,16929,16943,16957,17065,17106,17183,17213,17242,17251,17253,17267,17269,17307,17314,17414,17422,17538,17578,17640,17650,17667,17724,17876,17882,17894,17901,17930,17994,18014,18017,18120,18122,18125,18128,18137,18427,18441,18451,18528,18572,18789,18824,18838,18901,18925,18942,18994,19014,19029,19046,19054,19075,19096,19098,19100,19109,19110,19119,19123,19127,19130,19132,19139,19148,19156,19163,19169,19173,19189,19190,19195,19196,19206,19207,19210,19213,19217,19222,19224,19225,19226,19233,19235,19238,19239,19242,19243,19244,19251,19253,19254,19255,19258,19261,19262,19264,19266,19268,19269,19271,19274,19279,19285,19298,19313,19314,19316,19318,19326,19334,19346,19348,19356,19363,19367,19370,19383,19385,19408,19413,19418,19429,19432,19434,19438,19439,19442,19444,19446,19451,19459,19460,19461,19465,19470,19472,19475,19477,19480,19487,19489,19510,19528,19530,19542,19543,19554,19558,19563,19567,19579,19580,19581,19584,19598,19600,19603,19619,19620,19633,19635,19658,19659,19679,19684,19694,19703,19734,19739,19764,19769,19783,19784,19787,19790,19793,19797,19809,19810,19822,19833,19838,19846,19853,19858,19869,19878,19894,19898,19901,19908,19913,19914,19920,19925,19935,19957,19958,19977,19992,20002,20010,20016,20036,20044,20046,20047,20050,20057,20062,20064,20065,20066,20073,20075,20076,20084,20086,20115,20140,20147,20148,20163,20184,20199,20200,20209,20215,20219,20220,20221,20222,20223,20244,20246,20253,20267,20295,20296,20317,20338,20353,20354,20380,20383,20386,20393,20409,20410,20463,20476,20487,20496,20498,20501,20507,20525,20557,20573,20584,20587,20595,20598,20601,20602,20605,20609,20611,20646,20660,20680,20684,20696,20704,20714,20783,20797,20800,20806,20830,20845,20847,20848,20855,20866,21031,21052,21059,21221,21420)
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 | 779 | 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.30 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.14 ms |
Optimizing | 0.10 ms |
Statistics | 0.86 ms |
Preparing | 1.12 ms |
Sorting result | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.20 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.00 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.01 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 |