Време на заявката: 3.89 ms След последната заявка: 0.38 ms Памет за заявки: 0.079 MB Памет преди заявката: 3.416 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-30 01:18:21')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-05-30 01:18:21')
AND i.access IN(1,1)
AND c.access IN(1,1)
AND c.published = 1
AND c.trash = 0
AND i.id IN(41,291,365,747,822,842,1002,1049,1058,1124,1163,1498,1609,1643,1957,2008,2538,2975,3242,3640,4766,5243,6754,6770,6797,6804,6828,6870,6951,6963,6975,6981,7107,7239,7337,7338,7408,7473,7867,7898,7923,7973,8054,8056,8081,8149,8159,8196,8200,8234,8271,8292,8455,8465,8469,8498,8499,8541,8543,8608,8615,8724,8729,8751,8859,8875,8930,9107,9110,9123,9208,9215,9223,9253,9275,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,10041,10042,10047,10076,10077,10114,10133,10140,10141,10150,10182,10193,10216,10297,10334,10360,10369,10370,10376,10406,10413,10442,10480,10495,10504,10532,10535,10536,10571,10587,10595,10603,10612,10614,10626,10645,10646,10648,10653,10663,10678,10731,10755,10756,10764,10779,10793,10833,10875,10960,11022,11055,11065,11079,11082,11084,11111,11114,11136,11180,11194,11223,11229,11353,11431,11507,11508,11637,11699,11711,11725,11749,11759,11760,11764,11765,11806,11842,11845,11866,11885,11891,11919,11923,11929,12082,12090,12287,12290,12342,12378,12420,12421,12506,12527,12537,12615,12652,12675,12700,12706,12713,12715,12725,12738,12747,12750,12759,12812,12821,12840,12862,12864,12972,13011,13050,13146,13151,13182,13227,13231,13243,13251,13336,13390,13440,13458,13471,13473,13477,13490,13516,13540,13558,13579,13597,13690,13712,13826,13833,13856,13899,13908,13920,13932,13935,13953,14014,14018,14025,14027,14049,14053,14055,14065,14072,14081,14112,14129,14137,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,15111,15126,15159,15202,15232,15249,15256,15293,15316,15473,15612,15640,15695,15717,15735,15739,15754,15763,15769,15788,15789,15807,15810,15833,15847,15848,15899,15981,15993,15995,16008,16017,16030,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,16321,16333,16337,16345,16358,16380,16385,16403,16421,16459,16468,16469,16483,16484,16534,16536,16588,16590,16649,16697,16715,16729,16733,16741,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,17987,18022,18034,18059,18069,18092,18116,18119,18136,18140,18198,18214,18233,18240,18245,18247,18254,18256,18258,18272,18274,18303,18318,18335,18340,18352,18353,18383,18390,18393,18411,18412,18413,18415,18417,18434,18441,18463,18502,18504,18529,18559,18607,18621,18669,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,18944,18956,18957,18976,18978,18989,18994,18995,19000,19009,19034,19055,19060,19069,19072,19073,19080,19084,19092,19158,19170,19180,19186,19187,19216,19328,19340,19369,19403,19424,19544,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,20384,20447,20518,20520,20532,20533,20556,20560,20569,20580,20581,20604,20640,20645,20650,20677,20723,20736,20738,20758,20785,20819,20859,20885,20908,20912,20951,20986,21000,21013,21074,21081,21129,21395)
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.40 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.17 ms |
Optimizing | 0.12 ms |
Statistics | 1.09 ms |
Preparing | 1.39 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.41 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.03 ms |
Updating status | 0.02 ms |
Reset for next command | 0.02 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 |