Време на заявката: 2.51 ms След последната заявка: 0.39 ms Памет за заявки: 0.056 MB Памет преди заявката: 3.426 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-28 09:57:37')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-05-28 09:57:37')
AND i.access IN(1,1)
AND c.access IN(1,1)
AND c.published = 1
AND c.trash = 0
AND i.id IN(89,191,242,273,285,288,352,361,370,488,495,501,518,567,568,569,570,582,672,708,748,759,770,784,785,805,817,840,855,867,924,989,1050,1057,1066,1067,1109,1123,1139,1166,1194,1198,1300,1308,1384,1409,1421,1426,1431,1434,1447,1451,1458,1461,1470,1505,1533,1537,1555,1570,1613,1628,1639,1642,1649,1650,1793,1816,1849,1874,1877,1913,1914,1928,1931,1937,1983,1987,1988,1995,2014,2035,2036,2046,2177,2184,2204,2290,2405,2454,2457,2629,2640,2677,2841,2868,2886,2889,2914,2931,2956,2957,2976,2979,2997,3000,3003,3038,3071,3121,3205,3211,3256,3289,3370,3404,3422,3425,3444,3445,3593,3602,3636,3689,3719,3942,5238,6755,6759,6784,6790,6804,6823,6865,6871,6896,6948,6966,7136,7235,7253,7266,7339,7344,7385,7407,7412,7414,7445,7446,7464,7470,7488,7505,7527,7552,7558,7566,7567,7583,7603,7620,7651,7701,7705,7714,7759,7780,7791,7876,7929,7940,7948,7958,7984,8021,8087,8117,8172,8182,8187,8192,8204,8208,8210,8211,8214,8222,8247,8257,8261,8278,8283,8287,8301,8322,8323,8414,8421,8441,8468,8503,8551,8567,8579,8615,8702,8757,8956,8962,9002,9060,9070,9076,9092,9129,9178,9181,9191,9218,9282,9297,9302,9368,9377,9386,9395,9400,9403,9424,9477,9483,9488,9523,9570,9577,9585,9594,9617,9649,9681,9701,9731,9817,9818,9874,9876,9879,9889,9895,9901,9914,9921,9937,9939,9967,9990,10019,10024,10026,10039,10052,10073,10101,10107,10164,10192,10216,10218,10237,10337,10342,10361,10364,10366,10398,10436,10439,10471,10472,10474,10510,10514,10522,10540,10577,10591,10625,10628,10861,10878,10925,10940,11008,11010,11033,11092,11101,11110,11116,11131,11144,11161,11209,11245,11251,11263,11273,11293,11310,11523,11541,11553,11558,11559,11562,11572,11609,11614,11827,11937,11942,12062,12079,12118,12119,12121,12288,12381,12404,12422,12524,12561,12611,12632,12692,12712,12743,12744,12856,12872,12883,12925,12968,13017,13019,13031,13056,13057,13058,13083,13084,13100,13107,13114,13121,13123,13152,13169,13200,13234,13237,13241,13499,13508,13550,13563,13639,13677,13703,13848,13964,14079,14105,14136,14160,14164,14227,14317,14324,14378,14392,14394,14406,14455,14479,14484,14485,14491,14501,14512,14519,14578,14589,14617,14689,14694,14702,14829,14834,14835,14840,14846,14872,14954,14958,15065,15101,15179,15180,15189,15225,15366,15404,15411,15498,15527,15594,15676,15703,15805,16035,16056,16109,16164,16214,16429,16467,16485,16493,16531,16537,16539,16541,16546,16547,16549,16551,16560,16561,16566,16579,16581,16584,16585,16587,16589,16599,16603,16619,16628,16631,16637,16641,16644,16659,16690,16696,16697,16704,16710,16738,16745,16784,16871,16876,17062,17098,17101,17102,17114,17192,17456,17466,17482,17492,17561,17576,17577,17602,17622,17656,17662,17681,17706,17715,17765,17894,17895,17915,17997,18022,18023,18026,18072,18129,18130,18150,18237,18278,18353,18354,18401,18578,18585,18632,18651,18718,18731,18834,18847,18853,18905,18909,18971,18981,18986,19107,19181,19215,19231,19232,19281,19301,19319,19355,19361,19367,19389,19391,19406,19413,19483,19492,19506,19552,19568,19597,19627,19660,19723,19830,19843,19892,19936,19982,20006,20015,20032,20059,20076,20083,20108,20132,20135,20141,20149,20167,20210,20330,20339,20343,20359,20362,20420,20426,20448,20482,20489,20499,20559,20578,20596,20616,20623,20625,20630,20712,20774,20808,20813,20834,20889,20905,20924,21066,21086,21091,21111,21119,21121,21123,21141,21157,21158,21189,21194,21234,21280,21298,21299,21309,21316,21319,21356,21362,21366,21373,21375,21376,21400,21418,21422,21428)
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 | 614 | 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.26 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.08 ms |
Statistics | 0.69 ms |
Preparing | 0.88 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.24 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.02 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 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 |