Query Time: 3.55 ms After last query: 0.76 ms
SELECT i.*, c.alias AS categoryalias
FROM dtsdb_k2_items AS i
LEFT JOIN dtsdb_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 <= '2024-11-24 21:05:03')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-11-24 21:05:03')
AND i.access IN(1,1,5)
AND c.access IN(1,1,5)
AND c.published = 1
AND c.trash = 0
AND i.id IN(188,237,240,269,5331,5431,6404,6619,6651,6683,7359,7430,7626,7890,7891,8026,8027,8048,8114,8204,8245,8496,8497,8499,8553,8555,8664,8665,8700,8701,8798,8799,8843,8987,8988,8989,8990,9685,9686,9687,9695,9917,10053,10054,10208,10642,10666,10684,10688,10904,10997,11114,11126,11140,11151,11180,11199,11258,11275,11333,11364,11398,11399,11599,11652,11745,11759,11760,11783,11795,11801,11802,11850,11851,11901,11977,12049,12069,12070,12095,12101,12106,12121,12124,12133,12138,12152,12156,12159,12166,12167,12168,12172,12183,12190,12202,12205,12212,12225,12226,12234,12239,12241,12261,12288,12293,12309,12321,12381,12399,12463,12474,12475,12496,12508,12534,12544,12629,12750,12752,12755,12774,12810,12870,12890,12914,12947,13057,13113,13326,13365,13370,13386,13408,13429,13455,13471,13474,13491,13505,13596,13601,13685,13791,13807,13809,13830,13835,13870,13885,14001,14134,14650,14699,14766,14767,15058,15448,15530,15553,15754,15782,15841,16010,16105,16113,16131,16135,16171,16182,16304,16305,16329,16561,16617,16646,16696,16710,16787,16947,16988,16998,17009,17126,17254,17265,17564,17617,17729,17766,17849,17851,18043,18180,18201,18295,18357,18359,18409,18431,18445,18472,18512,18518,18532,18533,18558,18559,18561,18563,18567,18627,18638,18648,18651,18652,18655,18667,18682,18687,18690,18691,18699,18705,18727,18737,18746,18768,18778,18785,18859,18879,18892,18900,18906,18907,18953,18969,18970,18979,18987,18992,18994,19002,19017,19024,19038,19046,19047,19057,19061,19087,19092,19115,19122,19125,19165,19181,19188,19203,19230,19237,19251,19272,19278,19281,19298,19299,19307,19318,19341,19343,19371,19412,19413,19427,19431,19436,19437,19441,19456,19460,19464,19473,19529,19538,19547,19590,19593,19597,19605,19607,19609,19620,19624,19632,19645,19654,19656,19674,19681,19700,19718,19731,19733,19737,19754,19755,19760,19762,19786,19790,19796,19801,19815,19832,19834,19839,19850,19855,19867,19874,19877,19919,19920,19921,19930,19949,19965,19969,19970,19971,19973,19983,19986,19991,20003,20011,20012,20016,20019,20028,20031,20049,20062,20065,20073,20074,20084,20085,20090,20093,20102,20107,20111,20153,20164,20185,20190,20192,20198,20199,20206,20210,20211,20213,20222,20229,20234,20240,20241,20243,20245,20252,20258,20262,20263,20264,20265,20268,20269,20270,20280,20282,20287,20292,20293,20295,20296,20300,20304,20308,20312,20313,20314,20320,20321,20338,20339,20340,20360,20365,20373,20374,20380,20384,20388,20391,20393,20401,20404,20406,20407,20427,20428,20433,20439,20443,20451,20453,20459,20464,20473,20486,20491,20497,20498,20509,20517,20518,20520,20522,20523,20527,20531,20534,20537,20551,20573,20576,20583,20601,20614,20621,20624,20627,20638,20653,20656,20657,20662,20663,20664,20669,20675,20695,20698,20704,20706,20712,20715,20728,20730,20731,20743,20764,20766,20773,20774,20831,20962,20973,20998,21005,21022,21035,21048,21066,21088,21093,21107,21120,21136,21137,21143,21164,21191,21192,21195,21207,21223,21224,21225,21232,21238,21244,21245,21253,21255,21257,21267,21270,21273,21274,21275,21276,21280,21283,21301,21317,21320,21336,21337,21340,21355,21368,21369,21374,21379,21380,21386,21392,21393,21462,21466,21485,21488,21494,21500,21509,21512,21515,21518,21520,21521,21528,21533,21536,21540,21549,21550,21551,21552,21553,21555,21557,21558,21559,21561,21562,21564,21568,21572,21573,21581,21586,21587,21590,21595,21596,21601,21608,21624,21630,21634,21635,21641,21646,21652,21654,21668,21669,21679,21692,21693,21694,21695,21703,21708,21713,21719,21720,21721,21722,21723,21724,21725,21726,21729,21730,21733,21735,21736,21738,21749,21750,21751,21752,21756,21763,21764,21774,21775,21783,21787,21793,21798,21809,21812,21815,21817,21819,21823,21827,21831,21838,21865,21866,21870,21884,21885,21910,21924,21927,21930,21944,21946,21952,21953,21957,21958,21961,21969,21971,21982,21986,21987,21988,21989,22003,22005,22007,22008,22009,22010,22011,22012,22015,22019,22026,22033,22035,22038,22039,22047,22048,22049,22051,22055,22072,22081,22092,22109,22110,22112,22114,22117,22122,22123,22125,22127,22135,22137,22138,22142,22151,22152,22153,22156,22165,22171,22172,22174,22176,22178,22183,22184,22185,22186,22187,22191,22194,22195,22202,22203,22205,22206,22207,22213,22215,22217,22220,22222,22226,22228,22229,22230,22232,22233,22235,22238,22239,22242,22243,22244,22245,22246,22248,22254,22261,22262,22263,22265,22268,22269,22272,22273,22274,22275,22276,22277,22290,22302,22303,22304,22305,22306,22314,22316,22318,22319,22321,22322,22324,22325,22326,22327,22328,22332,22333,22334,22337,22340,22343,22344,22349,22354,22357,22358,22360,22364,22371,22374,22375,22376,22381,22386,22387,22390,22391,22393,22395,22397,22404,22406,22407,22409,22410,22412,22414,22419,22426,22432,22435,22436,22448,22453,22459,22465,22466,22468,22471,22475,22486,22489,22491,22496,22498,22499,22501,22502,22504,22506,22509,22511,22516,22517,22518,22521,22523,22525,22527,22528,22529,22530,22531,22536,22537,22540,22549,22552,22554,22555,22557,22560,22563,22564,22565,22568,22569,22571,22576,22581,22582,22586,22588,22589,22591,22602,22604,22607,22608,22611,22612,22613,22616,22620,22621,22625,22630,22631,22632,22634,22638,22639,22640,22641,22642,22644,22648,22649,22650,22652,22654,22655,22656,22657,22658,22659,22668,22670,22671,22674,22675,22676,22677,22678,22679,22682,22683,22685,22690,22691,22692,22693,22700,22702,22703,22704,22706,22707,22709,22710,22714,22716,22717,22718,22721,22722,22723,22724,22727,22729,22731,22741,22743,22744,22745,22746,22747,22749,22751,22753,22755,22765,22766,22767,22769,22772,22776,22783,22785,22789,22790,22791,22792,22793,22796,22798,22799,22807,22809,22811,22818,22819,22820,22821,22822,22829,22830,22844,22845,22846,22847,22858,22864,22865,22869,22875,22876,22881,22882,22885,22886,22887,22890,22891,22892,22894,22896,22898,22910,22911,22912,22913,22918,22922,22925,22927,22935,22936,22940,22941,22943,22944,22949,22950,22951,22955,22964,22965,22967,22972,22976,22977,22988,22989,23002,23004,23006,23007,23008,23009,23014,23019,23020,23024,23025,23028,23032,23037,23040,23054,23055,23059,23062,23066,23081,23082,23092,23095,23112,23121,23143,23175,23269,23314,23350,23357,23547,23585,23670,23709,23839,23995,24015,24056,24065,24074,24087,24133,24235,24236,24354,24456,24624,24625,24626,24627,24632,24831,24865,24926,24997,25496,25510,25598,25793,25798,25837,25949,25992,25993,26042,26052,26101,26304,26331,26497,26565,26665,26747,26760,26774,26822,26823,26829,26834,26869,26895,26910,26914,27008,27037,27042,27049,27210,27236,27239,27291,27311,27356,27363,27395,27406,27415,27445,27457,27514,27596,27619,27656,27661,27665,27719,27724,27767,27783,27789,27818,27819,27902,27996,28036,28047,28053,28075,28084,28094,28095,28132,28139,28145,28161,28165,28166,28168,28183,28195,28259,28289,28293,28297,28312,28321,28326,28332,28343,28358,28376,28393,28403,28441,28443,28468,28474,28516,28531,28624,28629,28642,28689,28690,28714,28715,28733,28740,28783,28809,28810,28813,28849,28850,28864,28866,28887,28934,28935,28952,28969,28974,28978,28998,29004,29005,29006,29035,29081,29085,29113,29114,29168,29195,29197,29236,29246,29259,29316,29350,29352,29361,29395,29418,29427,29432,29441,29450,29469,29491,29542,29559,29562,29582,29599,29723,29728,29808,29838,29859,29881,29884,29900,29934,29939,30003,30153,30190,30263,30347,30349,30353,30586,30616,30618,30681,30773,30823,30900,31059,31076,31123,31251,31371,31375,31379,31435,31453,31605,31607,31696,31758,31812,31964,31968,31982,31986,32022,32023,32102,32113,32115,32124,32125,32154,32181,32290,32310,32437,32466,32514,32531,32563,32598,32821,33269,33400,33410,33411,33421,33433,33434,33503,33635,33636,33695,33836,33888,33890,33896,33905,33915,33930,33933,33936,33941,33951,33957,33971,33972,34003,34004,34007,34020,34021,34028,34041,34089,34105,34108,34134,34135,34136,34145,34151,34162,34170,34209,34220,34222,34224,34225,34246,34247,34250,34251,34252,34275,34278,34290,34291,34292,34293,34294,34304,34314,34325,34327,34330,34331,34333,34334,34347,34400,34416,34417,34427,34435,34437,34438,34443,34445,34453,34468,34478,34508,34520,34537,34538,34549,34598,34604,34617,34635,34640,34651,34666,34667,34684,34704,34750,34825,35014,35026,35028,35540,36042,36086,36288,36432,36497,37612,37676)
ORDER BY i.id DESC
LIMIT 5
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | i | range | PRIMARY,item,catid | PRIMARY | 4 | NULL | 1362 | Using where |
1 | SIMPLE | c | eq_ref | PRIMARY,category,published,access,trash | PRIMARY | 4 | dtkbanten.i.catid | 1 | Using index condition; Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
14 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/itemlist.php:654 |
12 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:292 |
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 |