Време на заявката: 2.39 ms След последната заявка: 0.40 ms Памет за заявки: 0.079 MB Памет преди заявката: 3.425 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 03:06:17')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-06-08 03:06:17')
AND i.access IN(1,1)
AND c.access IN(1,1)
AND c.published = 1
AND c.trash = 0
AND i.id IN(1058,1643,2008,2975,3640,4766,5243,6754,6770,6828,6870,6951,6963,6981,7107,7239,7337,7338,7408,7473,7923,8056,8081,8149,8196,8217,8234,8271,8292,8431,8435,8444,8454,8455,8460,8463,8465,8467,8469,8475,8483,8484,8489,8490,8498,8499,8541,8543,8608,8615,8751,8859,8875,9107,9123,9208,9215,9223,9390,9449,9455,9468,9553,9562,9564,9569,9578,9580,9586,9591,9683,9746,9747,9770,9863,9875,9892,9901,9948,9961,9968,10020,10035,10076,10114,10133,10140,10141,10150,10182,10193,10297,10301,10334,10360,10369,10370,10376,10406,10413,10442,10480,10495,10504,10532,10535,10536,10571,10587,10595,10600,10603,10612,10614,10626,10645,10646,10648,10653,10663,10678,10682,10731,10755,10756,10764,10779,10793,10875,10903,10960,11022,11055,11079,11082,11084,11111,11114,11136,11180,11194,11229,11334,11353,11370,11431,11434,11507,11508,11573,11598,11637,11699,11711,11732,11749,11760,11764,11765,11806,11842,11845,11919,11923,11929,12082,12090,12287,12290,12342,12378,12420,12421,12506,12527,12615,12652,12675,12700,12706,12715,12750,12812,12821,12840,12862,12864,12948,12972,13011,13146,13151,13182,13227,13231,13243,13251,13336,13390,13440,13458,13470,13471,13473,13477,13490,13516,13540,13558,13579,13597,13662,13712,13833,13856,13899,13908,13920,13932,13935,13945,13953,14014,14018,14025,14027,14049,14053,14055,14065,14072,14081,14112,14129,14147,14201,14228,14236,14238,14261,14286,14293,14296,14302,14319,14331,14332,14336,14339,14345,14421,14441,14449,14480,14542,14555,14561,14636,14653,14669,14670,14673,14679,14697,14722,14742,14770,14836,15033,15103,15111,15126,15150,15159,15202,15232,15249,15256,15293,15316,15331,15473,15612,15640,15695,15717,15735,15739,15754,15760,15763,15769,15788,15789,15798,15803,15807,15810,15833,15847,15848,15855,15899,15934,15981,15993,15995,16008,16017,16038,16045,16048,16054,16099,16104,16112,16116,16120,16128,16139,16158,16172,16181,16185,16186,16227,16234,16241,16246,16253,16266,16272,16278,16287,16288,16321,16333,16337,16345,16358,16380,16385,16403,16421,16442,16459,16468,16469,16483,16484,16534,16536,16588,16590,16649,16697,16715,16733,16741,16772,16983,17048,17069,17088,17118,17134,17150,17176,17178,17199,17202,17222,17244,17310,17312,17316,17317,17327,17523,17546,17568,17605,17609,17619,17635,17639,17642,17680,17696,17708,17797,17798,17821,17866,17868,17922,17940,17987,18022,18034,18059,18069,18086,18087,18092,18116,18119,18136,18140,18198,18214,18233,18240,18245,18247,18254,18256,18258,18271,18272,18274,18303,18318,18327,18333,18335,18340,18352,18353,18361,18383,18390,18393,18411,18412,18413,18415,18417,18434,18441,18463,18502,18504,18516,18529,18537,18559,18607,18618,18621,18663,18669,18671,18677,18684,18698,18721,18734,18735,18738,18739,18740,18743,18748,18753,18755,18777,18792,18794,18825,18826,18844,18845,18851,18869,18876,18878,18890,18931,18938,18939,18940,18944,18956,18957,18976,18978,18989,18994,18995,19000,19009,19034,19055,19060,19069,19072,19073,19080,19084,19092,19158,19159,19170,19180,19186,19187,19216,19328,19340,19369,19403,19424,19529,19544,19577,19619,19645,19647,19716,19772,19801,19814,19815,19889,19904,19917,19928,19938,19944,19949,19950,19968,19970,20012,20020,20035,20085,20100,20110,20121,20204,20304,20313,20336,20349,20360,20384,20461,20497,20518,20520,20556,20560,20569,20580,20581,20604,20640,20645,20650,20670,20677,20723,20738,20758,20785,20816,20819,20859,20885,20908,20912,20951,20986,21000,21074,21081,21121,21376)
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 | 580 | 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.01 ms |
Table lock | 0.01 ms |
Init | 0.10 ms |
Optimizing | 0.07 ms |
Statistics | 0.64 ms |
Preparing | 0.83 ms |
Sorting result | 0.01 ms |
Executing | 0.01 ms |
Sending data | 0.27 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.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 |