Време на заявката: 2.65 ms След последната заявка: 0.41 ms Памет за заявки: 0.040 MB Памет преди заявката: 3.424 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-06-08 14:48:35')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-06-08 14:48:35')
AND i.access IN(1,1)
AND c.access IN(1,1)
AND c.published = 1
AND c.trash = 0
AND i.id IN(76,172,1330,1466,1654,1909,2015,2383,2406,6561,6776,6838,6884,6902,6922,6935,7059,7156,7185,7207,7214,7228,8429,8432,8435,8454,8456,8457,8460,8562,8621,8935,8986,9182,9261,9350,9401,9497,9506,9613,9614,9616,9617,9620,9621,9623,9626,9627,9629,9631,9632,9633,9635,9636,9637,9641,9644,9648,9660,9664,9665,9667,9668,9673,9684,9686,9691,9699,9705,9707,9709,9714,9716,9717,9719,9720,9721,9722,9737,9738,9740,9741,9762,9766,9771,9774,9806,9812,9813,9816,9821,9841,9844,9860,9862,9865,9885,9905,9907,9912,9916,9934,9956,9965,9995,9997,10005,10016,10017,10018,10031,10034,10038,10047,10056,10096,10135,10156,10168,10170,10238,10290,10356,10367,10458,10461,10482,10628,10729,10740,10802,10803,10826,10829,10858,10866,10896,10920,10921,10944,11074,11135,11148,11268,11321,11336,11432,11506,11513,11525,11526,11535,11540,11548,11560,11596,11627,11661,11673,11681,11738,11814,12223,12244,12350,12361,12379,12595,12660,12795,12811,12853,12985,12999,13010,13071,13446,13504,13559,13640,13667,13688,13773,13791,13850,13861,13975,13991,14035,14040,14055,14060,14134,14154,14187,14263,14271,14369,14435,14691,14699,14704,14815,14961,14997,15056,15144,15268,15307,15316,15436,15444,15978,16011,16074,16093,16180,16182,16188,16240,16247,16283,16296,16358,16464,16784,16829,16929,16957,17245,17267,17269,17307,17359,17536,17547,17578,17724,17756,18125,18279,18301,18317,18319,18365,18377,18397,18448,18465,18532,18555,18577,18579,18689,18695,18721,18807,18977,19046,19054,19075,19110,19113,19115,19116,19125,19127,19131,19138,19139,19144,19150,19153,19156,19157,19158,19165,19168,19173,19174,19177,19183,19184,19190,19196,19197,19205,19207,19210,19213,19222,19224,19226,19229,19231,19233,19235,19238,19248,19261,19264,19274,19279,19304,19310,19312,19313,19314,19316,19323,19333,19334,19336,19338,19346,19347,19349,19350,19351,19354,19367,19370,19374,19376,19380,19396,19398,19400,19408,19413,19418,19420,19434,19442,19456,19457,19459,19472,19477,19480,19481,19482,19489,19498,19505,19510,19519,19543,19553,19558,19566,19574,19579,19581,19584,19585,19596,19598,19600,19603,19619,19620,19623,19624,19627,19628,19630,19631,19635,19637,19638,19646,19651,19652,19654,19659,19668,19675,19679,19694,19697,19709,19712,19720,19721,19723,19725,19734,19736,19738,19740,19743,19744,19746,19748,19757,19758,19760,19763,19774,19777,19784,19787,19788,19792,19800,19805,19812,19822,19838,19842,19844,19849,19851,19858,19865,19869,19871,19873,19874,19885,19897,19898,19910,19920,19937,19941,19946,19952,19956,19958,19960,19966,19977,19983,19986,19987,19992,20002,20005,20006,20016,20023,20030,20036,20047,20050,20051,20057,20062,20064,20065,20071,20073,20075,20076,20086,20093,20094,20109,20114,20116,20117,20126,20148,20155,20184,20187,20189,20200,20212,20228,20233,20234,20235,20236,20237,20238,20241,20242,20244,20246,20249,20253,20266,20269,20271,20272,20274,20277,20279,20282,20284,20288,20291,20292,20299,20300,20301,20302,20313,20325,20333,20338,20368,20383,20389,20403,20415,20423,20427,20428,20432,20433,20435,20441,20444,20457,20459,20466,20477,20496,20501,20503,20507,20523,20547,20548,20550,20553,20561,20583,20584,20587,20591,20593,20594,20598,20614,20622,20692,20716,20728,20730,20732,20797,20839,20857,20863,20883,20886,20897,20909,20911,20925,20934,20941,20960,20963,20977,20981,20998,21005,21032,21040,21071,21093,21113,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 | 577 | 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.24 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.81 ms |
Preparing | 0.85 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.26 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.03 ms |
Updating status | 0.03 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 |