Време на заявката: 2.51 ms След последната заявка: 0.44 ms Памет за заявки: 0.040 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-06-08 15:01:14')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-06-08 15:01:14')
AND i.access IN(1,1)
AND c.access IN(1,1)
AND c.published = 1
AND c.trash = 0
AND i.id IN(213,636,647,731,869,881,953,976,1187,1330,1410,1466,1558,1654,1815,1852,1909,1915,2015,2222,2383,2406,2634,2937,3020,6561,6776,6884,6902,6922,6935,7059,7156,7185,7207,7214,7228,7289,7441,7459,7771,7973,8244,8293,8429,8432,8454,8456,8457,8460,8562,8602,8621,8646,8986,9061,9182,9261,9305,9401,9412,9432,9497,9506,9613,9614,9616,9617,9620,9621,9623,9626,9627,9629,9631,9632,9633,9635,9636,9637,9641,9644,9648,9660,9664,9665,9667,9668,9673,9684,9686,9691,9699,9705,9707,9709,9714,9716,9717,9719,9720,9721,9722,9737,9738,9740,9741,9762,9766,9774,9782,9806,9812,9813,9816,9821,9841,9844,9860,9862,9865,9885,9905,9907,9912,9916,9934,9956,9965,9995,9997,10005,10016,10017,10031,10034,10047,10054,10056,10096,10121,10228,10238,10295,10356,10366,10367,10490,10829,10852,10921,11148,11287,11336,11410,11458,11560,11627,11661,11673,11681,11738,11778,11814,12223,12350,12361,12379,12428,12931,13013,13266,13457,13504,13559,13629,13640,13646,13651,13667,13688,13712,13773,13791,13818,13850,13853,13861,13975,14035,14040,14055,14060,14134,14154,14161,14187,14299,14369,14404,14435,14691,14699,14704,14815,15056,15090,15144,15268,15436,15444,15480,15511,15542,15976,15978,16011,16074,16180,16188,16227,16235,16270,16430,16649,16745,16775,16784,17031,17245,17359,17536,17647,17745,17756,17986,18150,18197,18212,18251,18279,18289,18301,18317,18319,18353,18365,18377,18397,18430,18448,18465,18500,18528,18532,18555,18577,18579,18689,18695,18711,18807,18977,19110,19111,19112,19113,19115,19116,19122,19123,19125,19127,19129,19131,19137,19138,19139,19144,19150,19153,19156,19157,19158,19165,19168,19173,19174,19177,19183,19184,19190,19196,19197,19205,19207,19210,19213,19222,19226,19229,19231,19233,19235,19238,19248,19264,19274,19279,19297,19304,19310,19312,19313,19314,19316,19323,19333,19334,19336,19338,19346,19347,19349,19350,19351,19354,19367,19370,19374,19376,19380,19396,19398,19400,19408,19413,19418,19420,19434,19442,19456,19457,19459,19472,19476,19477,19480,19481,19482,19489,19498,19505,19510,19519,19532,19543,19553,19558,19566,19574,19579,19581,19584,19585,19598,19600,19603,19619,19620,19623,19624,19627,19628,19630,19631,19632,19635,19637,19638,19646,19651,19652,19654,19659,19668,19675,19679,19689,19694,19697,19709,19712,19717,19720,19721,19723,19725,19732,19734,19738,19740,19743,19744,19748,19757,19758,19760,19763,19774,19777,19784,19787,19788,19792,19800,19805,19812,19816,19822,19842,19844,19849,19851,19858,19865,19871,19873,19874,19878,19885,19897,19898,19910,19920,19937,19941,19946,19956,19958,19960,19966,19977,19983,19986,19987,19992,20002,20005,20006,20013,20023,20030,20050,20051,20071,20076,20086,20093,20094,20109,20114,20116,20117,20126,20148,20155,20184,20187,20189,20200,20212,20224,20225,20228,20233,20234,20235,20236,20237,20238,20241,20242,20246,20248,20249,20252,20253,20255,20257,20259,20260,20266,20269,20271,20272,20274,20277,20279,20282,20284,20288,20291,20292,20299,20300,20301,20302,20313,20325,20333,20338,20368,20403,20412,20415,20419,20423,20427,20428,20432,20433,20435,20440,20441,20444,20457,20459,20466,20477,20482,20496,20501,20503,20523,20547,20548,20550,20553,20561,20583,20584,20587,20591,20593,20594,20598,20614,20622,20692,20696,20705,20716,20728,20730,20732,20797,20839,20857,20863,20883,20886,20897,20909,20911,20925,20934,20941,20960,20963,20977,20981,20998,21005,21032,21040,21071,21093,21113,21163,21234,21298,21362,21366,21400,21422,21426,21429)
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 | 588 | 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.67 ms |
Preparing | 0.85 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.27 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.03 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 |