Време на заявката: 2.49 ms След последната заявка: 0.42 ms Памет за заявки: 0.072 MB Памет преди заявката: 3.423 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 09:52:07')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-05-29 09:52:07')
AND i.access IN(1,1)
AND c.access IN(1,1)
AND c.published = 1
AND c.trash = 0
AND i.id IN(47,262,359,409,448,453,483,535,588,620,621,622,634,684,722,757,760,948,949,1043,1134,1193,1296,1428,1433,1472,1504,1535,1625,1701,1725,1791,1996,1999,2193,2203,2256,2293,2358,2379,2947,3194,3366,3398,3541,3715,3888,6720,6765,6805,6865,6878,6881,6904,6916,6974,7045,7084,7138,7189,7199,7200,7201,7206,7222,7226,7234,7246,7248,7250,7262,7264,7268,7272,7283,7284,7285,7320,7321,7322,7335,7340,7347,7349,7350,7354,7358,7378,7410,7413,7414,7418,7420,7425,7437,7444,7445,7447,7448,7450,7456,7460,7466,7469,7476,7479,7490,7491,7492,7493,7497,7507,7510,7512,7530,7534,7538,7550,7555,7557,7571,7587,7602,7607,7608,7611,7612,7617,7620,7622,7629,7644,7674,7682,7719,7724,7726,7729,7831,7849,7850,7860,7900,7952,7961,7970,7974,7979,7988,7993,7994,8003,8019,8020,8026,8059,8071,8072,8085,8100,8110,8111,8112,8155,8181,8206,8220,8254,8285,8307,8328,8411,8449,8481,8492,8493,8567,8579,8668,8679,8684,8693,8702,8709,8753,8769,8779,8837,8864,8959,9012,9055,9064,9143,9164,9189,9214,9228,9235,9242,9272,9294,9315,9338,9351,9392,9420,9444,9463,9472,9501,9550,9576,9687,9701,9732,9779,9823,9829,9830,9834,9839,9845,9851,9879,9881,9884,9886,9889,9897,9900,9923,9953,9963,9980,9990,10009,10025,10050,10062,10064,10073,10077,10092,10117,10129,10145,10149,10158,10173,10196,10210,10211,10239,10241,10244,10246,10247,10256,10264,10321,10342,10363,10395,10402,10487,10494,10513,10516,10544,10610,10632,10637,10650,10687,10688,10733,10734,10770,10787,10827,10845,10855,10878,10887,10931,10942,10983,10990,10991,11005,11006,11007,11011,11012,11013,11014,11016,11017,11035,11041,11042,11049,11075,11089,11099,11110,11134,11155,11167,11192,11196,11204,11207,11214,11227,11282,11340,11393,11494,11497,11594,11632,11685,11724,11759,11768,11794,11846,11922,11972,11992,12036,12041,12051,12073,12080,12115,12120,12122,12128,12129,12130,12190,12257,12269,12273,12293,12297,12304,12316,12407,12481,12579,12585,12591,12592,12614,12633,12659,12671,12680,12698,12699,12701,12711,12733,12744,12778,12794,12813,12848,12850,12893,12916,12922,12927,12969,12974,12989,12993,12997,13072,13124,13133,13305,13311,13341,13405,13480,13482,13486,13553,13630,13684,13699,13721,13736,13754,13784,13885,13914,13918,13933,13942,13961,13962,13969,13976,13986,14002,14010,14011,14012,14013,14015,14017,14019,14020,14022,14024,14025,14028,14033,14041,14052,14053,14054,14058,14082,14084,14087,14088,14150,14180,14190,14235,14269,14287,14335,14416,14554,14562,14595,14638,14706,14711,14719,14724,14780,14805,14842,14866,15059,15076,15101,15303,15313,15347,15356,15363,15373,15382,15405,15471,15499,15501,15505,15562,15564,15583,15614,15629,15680,15730,15756,15822,15823,15824,15862,15863,15942,15945,15957,15958,15959,15975,15987,16085,16164,16183,16190,16196,16217,16252,16254,16312,16319,16366,16372,16418,16541,16578,16604,16609,16617,16627,16634,16653,16735,16749,16787,16800,16832,16923,16955,16959,16977,16984,17013,17040,17050,17051,17054,17097,17108,17113,17129,17173,17182,17206,17240,17280,17309,17379,17474,17589,17624,17664,17737,17777,17835,17836,17842,17872,17890,17961,18178,18227,18253,18317,18322,18347,18385,18586,18626,18704,18770,18774,18814,18836,18853,18916,18945,18997,19136,19266,19357,19365,19397,19451,19608,19642,19714,19726,19786,19847,19969,19980,20210,20303,20345,20554,20616,20655,20673,20699,20715,20913,20979,21096,21148,21153,21207,21254,21270,21331,21421)
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 | 598 | 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.07 ms |
Statistics | 0.68 ms |
Preparing | 0.87 ms |
Sorting result | 0.01 ms |
Executing | 0.01 ms |
Sending data | 0.28 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 |