Време на заявката: 3.36 ms След последната заявка: 0.54 ms Памет за заявки: 0.072 MB Памет преди заявката: 3.440 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-02-05 17:03:27')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-02-05 17:03:27')
AND i.access IN(1,1)
AND c.access IN(1,1)
AND c.published = 1
AND c.trash = 0
AND i.id IN(85,86,89,101,114,146,162,163,229,242,270,289,292,361,446,519,526,529,684,1037,1067,1145,1193,1270,1276,1471,1485,1518,1529,1541,1548,1570,1603,1642,1655,1742,1804,1875,1950,1996,2014,2032,2293,2358,2635,2839,2847,2957,2972,2979,3121,3160,3172,3358,3364,3365,3384,3389,3393,3408,3416,3425,3450,3833,3940,6332,6347,6535,6767,6844,6846,6850,6894,6966,6982,6986,7053,7074,7079,7121,7180,7181,7188,7229,7285,7379,7423,7427,7445,7475,7476,7481,7505,7530,7586,7594,7868,7889,7922,7952,8086,8137,8147,8197,8202,8220,8303,8309,8338,8343,8600,8609,8655,8750,8757,8959,8964,8966,8991,9016,9029,9033,9090,9170,9174,9188,9191,9200,9202,9303,9411,9419,9428,9438,9439,9441,9456,9461,9494,9542,9581,9588,9590,9597,9640,9647,9676,9693,9697,9719,9725,9745,9747,9755,9762,9795,9808,9827,9833,9844,9848,9851,9863,9868,9871,9890,9911,9917,9919,9921,9937,9943,9964,9971,9997,10000,10018,10030,10032,10035,10039,10040,10045,10057,10058,10063,10068,10073,10077,10084,10090,10100,10111,10127,10135,10155,10185,10191,10201,10215,10223,10252,10288,10289,10290,10329,10331,10349,10353,10374,10385,10391,10394,10395,10397,10398,10399,10406,10411,10413,10430,10481,10496,10499,10536,10538,10539,10556,10581,10585,10606,10614,10628,10638,10644,10645,10647,10648,10649,10651,10653,10654,10655,10660,10662,10667,10670,10673,10674,10676,10678,10680,10686,10690,10694,10701,10704,10706,10709,10715,10720,10748,10758,10762,10768,10781,10812,10829,10901,10965,10972,10985,10988,10994,11004,11031,11038,11040,11050,11059,11068,11084,11086,11099,11110,11119,11120,11138,11141,11228,11229,11230,11235,11246,11249,11250,11252,11253,11259,11262,11267,11270,11298,11330,11382,11408,11413,11512,11515,11517,11518,11521,11522,11528,11532,11536,11540,11544,11546,11561,11581,11592,11597,11598,11599,11601,11606,11639,11699,11706,11765,11827,11841,11984,12040,12042,12053,12056,12058,12067,12070,12085,12089,12091,12106,12113,12155,12160,12224,12228,12230,12237,12288,12316,12342,12343,12349,12351,12357,12358,12362,12418,12420,12431,12493,12495,12500,12517,12537,12541,12547,12561,12600,12602,12608,12615,12646,12647,12681,12689,12691,12695,12750,12755,12760,12783,12818,12827,12833,12844,12852,12864,12881,12891,12923,12924,12940,12955,12963,12984,12988,13010,13011,13028,13050,13057,13058,13069,13083,13084,13090,13150,13170,13196,13235,13444,13445,13526,13562,13650,13670,13712,13747,13848,13922,14039,14105,14144,14209,14304,14539,14640,14643,14644,14897,14909,14919,14933,14941,14942,14947,14952,15005,15116,15118,15159,15183,15207,15211,15297,15338,15354,15369,15370,15376,15395,15427,15479,15514,15528,15669,15683,15698,15778,15781,15791,15815,15921,15953,16047,16103,16106,16135,16145,16146,16171,16175,16182,16194,16201,16209,16217,16240,16275,16303,16335,16345,16362,16367,16369,16375,16425,16431,16455,16488,16493,16506,16527,16531,16540,16544,16584,16590,16651,16666,16696,16797,16982,17140,17176,17218,17297,17299,17301,17343,17350,17392,17396,17458,17461,17466,17478,17503,17561,17562,17576,17581,17594,17613,17621,17630,17668,17694,17767,17841,17842,17886,17894,17895,17903,17915,17950,17964,17969,18022,18025,18027,18049,18055,18056,18059,18072,18073,18095,18114,18115,18124,18146,18174,18180,18201,18206,18222,18230,18237,18241,18252,18271,18280,18327,18334,18346,18367,18418,18421,18422,18426,18436,18437,18450,18507,18511,18545,18552,18629,18644,18723,18753,18756,18777,18778,18779,18780,18785,18786,18796,18834,18839,18902,18928,19006,19030,19031,19041,19065,19079,19086,19089,19090,19123,19130,19193,19223,19257,19259,19280,19282,19283,19303,19313,19339,19345,19354,19375,19389,19396,19431,19436,19449,19456,19468,19474,19477,19492,19498,19499,19552,19573,19612,19616,19617,19637,19660,19708,19720,19730,19734,19736,19738,19748,19784,19795,19796,19819,19825,19834,19844,19850,19853,19894,19930,19934,19989,19997,19998,20006,20031,20063,20076,20082,20092,20093,20095,20100,20118,20121,20124,20125,20138,20142,20143,20144,20149,20189,20266,20268,20288,20299,20304,20311,20312,20313,20348,20364,20377,20395,20402,20437,20438,20441,20448,20456,20468,20470,20484,20485,20502,20506,20508,20530,20551,20553,20560,20570,20574,20578,20582,20586,20606,20608,20613,20618,20622,20625,20627,20634,20650,20658,20661,20665,20678,20681,20683,20692,20693,20694,20697,20700,20712,20715,20732,20733,20761,20769,20809,20829,20857,20858,20861,20862,20874,20876,20883,20887,20892,20904,20908,20916,20949,20965,20969,20971,20977,20981,20982,20983,20989,20991,20992,20997,20998,21008,21015,21016,21024,21032,21040,21046,21047,21048,21049,21056,21060,21061,21063,21064,21067,21068,21077,21104,21105,21115,21117,21118,21121,21145,21152,21423)
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 | 798 | 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.30 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.14 ms |
Optimizing | 0.09 ms |
Statistics | 1.00 ms |
Preparing | 1.19 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.39 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.03 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 |