Време на заявката: 2.79 ms След последната заявка: 0.43 ms Памет за заявки: 0.094 MB Памет преди заявката: 3.410 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 02:34:27')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-06-08 02:34: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(43,64,72,76,77,78,82,83,84,85,86,88,89,90,92,94,95,96,101,102,103,104,105,115,132,137,139,140,141,142,143,145,146,147,149,151,155,156,157,159,160,163,164,166,168,172,174,176,177,178,179,181,184,188,190,191,193,196,197,199,201,203,204,206,209,212,214,216,218,219,221,223,224,225,226,228,230,233,234,237,270,271,272,273,274,275,276,277,278,279,280,282,283,284,285,286,288,289,290,291,292,293,294,295,296,362,405,410,415,416,418,419,422,426,427,428,429,430,437,438,439,447,448,450,453,456,457,460,461,463,472,473,474,475,476,477,478,479,480,481,482,483,484,485,487,488,489,490,492,493,494,495,497,498,499,500,501,502,503,504,505,506,508,510,560,563,564,566,567,568,569,570,571,572,574,575,577,579,580,581,583,584,587,588,589,590,607,610,615,616,617,618,619,620,621,622,623,624,625,626,627,628,630,632,636,637,640,649,650,651,652,653,654,655,656,657,658,659,660,661,662,663,664,665,667,669,671,691,692,697,698,699,700,701,702,703,704,717,720,722,723,725,731,732,736,737,740,742,744,750,754,755,756,757,758,759,760,761,763,765,766,767,769,770,771,772,862,866,867,868,869,870,871,873,874,876,879,886,888,890,894,895,896,897,898,899,900,901,902,903,904,905,906,907,921,922,926,929,930,931,935,938,943,946,947,948,949,950,951,952,953,955,956,959,960,963,964,965,967,969,970,971,972,973,976,977,979,981,986,987,989,990,991,992,1008,1009,1010,1011,1013,1014,1016,1018,1019,1021,1024,1026,1027,1028,1031,1032,1033,1034,1035,1036,1037,1038,1039,1040,1041,1043,1051,1052,1053,1054,1055,1056,1057,1058,1059,1060,1061,1063,1071,1072,1073,1074,1075,1076,1077,1078,1079,1080,1081,1082,1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,1094,1095,1096,1097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1157,1158,1160,1161,1162,1165,1168,1170,1171,1172,1173,1176,1192,1196,1197,1198,1199,1200,1201,1202,1203,1204,1205,1206,1208,1209,1210,1212,1228,1229,1230,1231,1233,1234,1235,1236,1237,1238,1239,1290,1292,1294,1296,1300,1302,1304,1305,1309,1310,1311,1314,1315,1316,1317,1326,1331,1332,1333,1334,1335,1337,1338,1339,1340,1366,1368,1369,1370,1371,1373,1374,1375,1376,1377,1378,1379,1380,1381,1382,1383,1384,1385,1386,1387,1388,1389,1390,1391,1392,1393,1394,1395,1397,1399,1402,1403,1404,1405,1406,1407,1408,1409,1410,1411,1412,1413,1416,1417,1602,1698,1701,1703,1704,1705,1706,1707,1708,1709,1710,1711,1719,1720,1721,1722,1723,1724,1725,1726,1737,1738,1739,1740,1741,1742,1743,1744,1756,1759,1762,1765,1766,1767,1768,1769,1772,1773,1774,1786,1787,1788,1789,1790,1791,1792,1793,1794,1795,1825,1826,1827,1828,1829,1830,1831,1833,1834,1835,1837,1838,1841,1848,1849,1850,1851,1855,1856,1858,1860,1864,1873,1874,1877,1882,1885,1889,1953,1961,1971,1977,1978,1984,2105,2106,2107,2108,2109,2207,2219,2293,2307,2308,2322,10350,13005)
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 | 616 | 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.12 ms |
Optimizing | 0.08 ms |
Statistics | 0.71 ms |
Preparing | 0.88 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.46 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.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.02 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 |