Време на заявката: 2.93 ms След последната заявка: 0.51 ms Памет за заявки: 0.055 MB Памет преди заявката: 3.991 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 <= '2022-08-14 19:44:15')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2022-08-14 19:44:15')
AND i.access IN(1,1)
AND c.access IN(1,1)
AND c.published = 1
AND c.trash = 0
AND i.id IN(103,229,272,292,399,403,423,483,514,572,620,621,622,634,717,792,795,813,829,923,962,994,1018,1037,1075,1126,1134,1145,1147,1177,1215,1235,1296,1350,1428,1492,1535,1556,1603,1625,1660,1661,1672,1679,1682,1701,1725,1755,1763,1931,2011,2024,2206,2207,2253,2349,2355,2366,2375,2406,2540,2567,2617,2694,2747,2754,2781,2893,2947,2950,2964,2965,3093,3112,3194,3243,3301,3305,3318,3340,3386,3397,3420,3495,3496,3594,6719,6812,6820,6865,6904,6932,6936,6942,6955,6978,6995,7005,7029,7067,7076,7078,7109,7157,7223,7241,7250,7261,7320,7321,7358,7378,7414,7489,7490,7491,7492,7497,7507,7555,7566,7567,7587,7609,7611,7622,7629,7647,7751,7778,7781,7788,7819,7831,7834,7847,7851,7854,7862,7873,7947,7974,8040,8087,8130,8138,8180,8189,8197,8206,8218,8229,8411,8421,8449,8464,8468,8492,8506,8516,8521,8532,8567,8568,8571,8588,8619,8668,8700,8717,8795,8847,8904,8915,8982,8988,9214,9219,9272,9294,9304,9315,9334,9335,9338,9342,9345,9351,9370,9377,9403,9419,9420,9440,9441,9453,9460,9461,9475,9495,9504,9507,9537,9541,9545,9571,9581,9594,9649,9651,9657,9710,9712,9750,9830,9879,9900,9919,9943,9985,10001,10006,10008,10025,10035,10048,10062,10064,10092,10097,10105,10124,10149,10158,10173,10175,10186,10187,10196,10217,10237,10239,10244,10342,10363,10369,10373,10402,10414,10416,10455,10464,10473,10475,10476,10477,10483,10507,10509,10511,10513,10551,10566,10584,10593,10594,10605,10610,10629,10637,10669,10687,10688,10697,10703,10725,10737,10738,10745,10764,10795,10806,10817,10845,10855,10860,10867,10878,10921,10925,10930,10931,10940,10942,10965,10979,10983,10998,11006,11012,11031,11034,11041,11069,11075,11082,11120,11134,11153,11200,11214,11227,11253,11269,11282,11292,11312,11335,11393,11395,11409,11420,11437,11456,11494,11539,11558,11562,11609,11628,11636,11638,11687,11696,11703,11761,11797,11844,11846,11849,11859,11882,11898,11903,11914,11922,11933,11992,12051,12063,12066,12073,12080,12122,12128,12217,12229,12257,12265,12273,12293,12297,12300,12375,12435,12467,12579,12591,12623,12631,12650,12657,12680,12712,12719,12734,12745,12792,12794,12807,12848,12852,12856,12893,12904,12906,12914,12922,12927,12930,12934,12951,12956,12993,13000,13005,13006,13012,13051,13060,13072,13078,13124,13177,13179,13214,13230,13234,13255,13274,13341,13362,13388,13405,13418,13442,13453,13480,13482,13486,13509,13515,13536,13553,13560,13582,13590,13603,13621,13636,13669,13682,13688,13690,13699,13715,13717,13721,13733,13736,13738,13863,13877,13879,13884,13913,13929,13944,13960,13961,14022,14150,14158,14178,14181,14190,14193,14223,14269,14283,14284,14287,14299,14307,14309,14324,14377,14394,14406,14416,14439,14455,14484,14519,14651,14730,14775,14792,14926,14982,14996,15010,15022,15036,15115,15118,15127,15131,15141,15145,15147,15148,15151,15154,15157,15173,15206,15207,15221,15230,15272,15337,15373,15389,15411,15443,15460,15472,15488,15500,15501,15503,15552,15576,15656,15667,15669,15672,15677,15679,15685,15687,15689,15690,15693,15706,15710,15711,15718,15719,15723,15726,15727,15734,15738,15750,15756,15760,15768,15781,15786,15795,15806,15815,15839,15843,15850,15863,15866,15904,15945,15958,15964,15970,15987,16058,16106,16135,16136,16142,16143,16145,16152,16153,16160,16164,16175,16182,16183,16192,16217,16218,16228,16232,16252,16254,16266,16286,16311,16313,16314,16319,16320,16418,16424,16447,16500,16509,16520,16538,16541,16606,16669,16718,16776,16784,16810,16818,16933,17028,17062,17077,17092,17093,17124,17169,17173,17176,17182,17186,17187,17197,17255,17268,17292,17297,17320,17345,17356,17361,17375,17379,17411,17418,17452,17474,17493,17502,17512,17581,17589,17632,17641,17701,17719,17735,17743,17751,17756,17757,17765,17787,17788,17800,17803,17822,17838,17861,17869,17890,17891,17894,17950,17958,17960,17961,17968,18000,18036,18080,18095,18149,18152,18219,18281,18283,18286,18291,18292,18301,18302,18317,18319,18329,18340,18342,18365,18368,18377,18385,18397,18410,18427,18448,18465,18510,18532,18555,18577,18586,18686,18687,18689,18711,18712,18751,18823,18836,18853,18856,18875,18892,18924,18977,18984,19027,19035,19180,19183,19191,19193,19237,19241,19265,19292,19300,19307,19358,19365,19391,19419,19482,19576,19589,19748,19753,19776,19830,19837,19847,19867,19982,20034,20101,20183,20210,20211,20367,20377,20443,20447,20555,20627,20633,20641,20644,20653,20658,20665,20673,20686,20693,20694,20699,20737,20772,20811,20835,20918,20921,20953,20973,20987,21003,21012,21091,21207,21224,21430)
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 | 769 | 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.28 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.13 ms |
Optimizing | 0.09 ms |
Statistics | 0.85 ms |
Preparing | 1.11 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.25 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.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 |