Време на заявката: 17.78 ms След последната заявка: 0.84 ms Памет за заявки: 0.056 MB Памет преди заявката: 3.462 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 16:51:22')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-03-25 16:51: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(1242,1717,1804,2214,6670,6736,6753,6758,6767,6795,6844,6846,6850,6892,6923,6967,6977,6981,6982,7025,7074,7079,7099,7108,7153,7275,7280,7297,7327,7421,7518,7553,7627,7728,7779,7783,7868,8031,8086,8133,8198,8202,8300,8325,8343,8350,8356,8369,8381,8497,8499,8567,8600,8615,8616,8685,8889,8902,8964,8991,9003,9033,9042,9090,9109,9138,9170,9174,9188,9202,9208,9209,9213,9266,9340,9347,9350,9411,9419,9428,9437,9438,9439,9441,9456,9461,9475,9479,9494,9508,9546,9562,9579,9581,9590,9597,9640,9647,9693,9697,9719,9725,9745,9747,9762,9765,9773,9795,9799,9802,9827,9833,9846,9851,9863,9868,9871,9917,9919,9943,9971,9997,10000,10018,10030,10035,10038,10040,10045,10057,10063,10068,10084,10090,10100,10111,10127,10135,10155,10156,10168,10170,10172,10215,10223,10252,10257,10275,10289,10304,10329,10349,10350,10353,10374,10399,10405,10406,10407,10410,10411,10413,10430,10473,10475,10499,10536,10539,10553,10581,10585,10606,10614,10628,10634,10638,10644,10645,10647,10648,10649,10651,10653,10654,10655,10660,10662,10667,10670,10673,10674,10676,10677,10678,10680,10686,10690,10694,10701,10704,10706,10709,10715,10720,10726,10741,10748,10749,10756,10757,10758,10760,10761,10762,10765,10768,10772,10781,10788,10794,10795,10812,10816,10819,10829,10873,10881,10901,10905,10917,10954,10974,10985,10988,10994,11038,11040,11050,11059,11068,11079,11084,11087,11120,11121,11123,11128,11129,11180,11211,11215,11217,11228,11229,11230,11246,11252,11259,11262,11267,11270,11298,11311,11316,11330,11350,11352,11380,11382,11413,11417,11507,11508,11515,11522,11525,11528,11532,11534,11540,11544,11546,11561,11581,11582,11585,11592,11596,11597,11598,11599,11601,11606,11629,11641,11645,11664,11682,11699,11706,11765,11798,11841,11846,11919,11923,11924,12040,12042,12053,12056,12058,12067,12070,12085,12089,12091,12106,12113,12155,12158,12160,12224,12230,12237,12262,12288,12290,12342,12343,12349,12351,12357,12358,12362,12378,12418,12420,12421,12431,12493,12537,12541,12547,12557,12559,12560,12561,12566,12593,12602,12608,12615,12647,12651,12652,12660,12675,12681,12689,12691,12693,12695,12700,12750,12760,12768,12774,12783,12811,12827,12833,12844,12864,12872,12881,12891,12892,12899,12921,12924,12940,12955,12963,12971,12984,13010,13011,13028,13050,13150,13170,13187,13193,13235,13297,13348,13456,13469,13478,13511,13516,13524,13525,13526,13546,13562,13649,13655,13658,13668,13670,13712,13747,13778,13809,13903,13922,13924,13943,13999,14010,14014,14017,14035,14129,14144,14168,14200,14209,14236,14293,14301,14332,14345,14352,14441,14462,14473,14477,14568,14636,14640,14653,14673,14732,14788,14823,14841,14891,14909,14923,14962,15000,15003,15005,15073,15078,15096,15099,15118,15126,15130,15188,15207,15257,15262,15297,15343,15365,15367,15369,15370,15376,15378,15395,15434,15439,15462,15493,15683,15698,15731,15781,15794,15921,15928,15929,15953,16005,16014,16033,16047,16076,16095,16106,16109,16112,16135,16139,16145,16166,16168,16169,16175,16182,16194,16201,16209,16217,16226,16231,16240,16264,16266,16303,16335,16345,16363,16367,16375,16382,16401,16488,16506,16527,16544,16590,16651,16664,16767,16799,16928,16948,16963,17010,17065,17092,17124,17155,17194,17239,17284,17296,17297,17299,17300,17301,17393,17396,17430,17476,17526,17538,17562,17579,17581,17594,17621,17630,17660,17694,17928,17950,17964,17966,17967,17986,18042,18049,18055,18056,18060,18095,18097,18098,18100,18124,18128,18138,18180,18201,18206,18222,18228,18230,18246,18250,18271,18273,18286,18309,18327,18334,18345,18358,18386,18399,18435,18436,18437,18444,18451,18456,18479,18507,18511,18552,18565,18629,18635,18637,18644,18659,18723,18742,18745,18749,18753,18755,18756,18777,18779,18785,18786,18816,18879,18882,18902,18908,18911,18932,18939,18990,19006,19031,19041,19086,19089,19090,19092,19123,19130,19193,19216,19259,19280,19283,19285,19311,19313,19336,19339,19375,19416,19428,19436,19449,19456,19468,19474,19477,19498,19552,19565,19573,19605,19637,19660,19670,19720,19807,19825,19826,19844,19854,19894,19930,19941,19942,19952,19970,19989,19990,19997,20006,20063,20075,20082,20092,20093,20095,20100,20102,20118,20124,20125,20142,20160,20189,20213,20215,20230,20265,20266,20293,20295,20302,20311,20348,20364,20383,20394,20409,20410,20421,20430,20438,20441,20454,20455,20476,20484,20506,20508,20510,20516,20524,20528,20551,20560,20566,20570,20571,20577,20582,20587,20602,20609,20621,20661,20665,20678,20693,20694,20804,20809,20853,20857,20861,20862,20863,20870,20887,20892,20895,20908,20949,20965,21016,21037,21042,21061,21081,21092,21104,21118,21145,21211,21355,21402)
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 | 771 | 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.45 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.20 ms |
Optimizing | 0.13 ms |
Statistics | 1.50 ms |
Preparing | 1.99 ms |
Sorting result | 0.03 ms |
Executing | 0.01 ms |
Sending data | 13.06 ms |
End of update loop | 0.02 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.04 ms |
Updating status | 0.28 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 |