Query Time: 2.91 ms After last query: 0.74 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 20:10:37')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-11-24 20:10:37')
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(237,240,2316,3198,6514,6543,6619,6664,10688,11619,15841,16329,17185,17283,17729,17766,17851,18043,18180,18357,18359,18409,18431,18472,18518,18532,18533,18558,18559,18561,18563,18567,18627,18638,18648,18651,18652,18655,18682,18687,18690,18691,18705,18727,18737,18746,18768,18778,18785,18859,18879,18892,18900,18906,18907,18953,18963,18968,18969,18970,18979,18987,18992,18994,19002,19017,19024,19038,19057,19061,19087,19092,19115,19122,19125,19165,19181,19188,19203,19237,19251,19272,19278,19281,19298,19299,19307,19318,19340,19341,19371,19413,19427,19431,19436,19437,19456,19460,19464,19473,19547,19590,19593,19597,19605,19607,19609,19620,19624,19632,19645,19654,19656,19674,19681,19700,19718,19724,19731,19733,19737,19754,19755,19760,19762,19786,19790,19796,19801,19815,19826,19832,19834,19839,19850,19855,19874,19877,19907,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,20160,20164,20185,20190,20192,20198,20199,20206,20210,20211,20213,20222,20229,20234,20240,20241,20243,20245,20252,20258,20262,20264,20265,20267,20268,20269,20270,20280,20282,20287,20292,20293,20295,20296,20300,20304,20308,20312,20313,20314,20320,20321,20338,20339,20340,20367,20373,20374,20376,20380,20388,20391,20393,20401,20404,20405,20406,20407,20427,20428,20433,20439,20441,20443,20451,20453,20459,20464,20466,20473,20486,20491,20497,20498,20509,20517,20518,20520,20522,20523,20527,20531,20534,20537,20551,20573,20576,20583,20601,20614,20621,20623,20624,20627,20638,20653,20656,20657,20662,20663,20664,20669,20675,20698,20704,20706,20712,20715,20728,20730,20731,20743,20766,20773,20774,20939,20945,20962,20973,20998,21022,21035,21048,21066,21088,21093,21107,21120,21136,21137,21143,21164,21175,21192,21207,21224,21225,21232,21238,21244,21245,21253,21255,21257,21267,21270,21273,21274,21275,21276,21280,21283,21297,21301,21317,21320,21336,21337,21340,21355,21368,21369,21374,21379,21380,21392,21462,21466,21473,21480,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,21609,21611,21624,21630,21634,21635,21641,21646,21650,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,21781,21782,21783,21787,21793,21798,21809,21812,21815,21817,21819,21823,21827,21831,21838,21840,21865,21870,21884,21885,21910,21924,21927,21930,21944,21946,21952,21953,21957,21958,21961,21969,21971,21982,21984,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,22141,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,22216,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,22288,22290,22302,22303,22304,22305,22306,22314,22316,22318,22319,22321,22322,22324,22325,22326,22327,22328,22332,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,22459,22465,22466,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,22566,22568,22569,22571,22576,22581,22582,22586,22588,22589,22591,22596,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,22946,22950,22951,22955,22956,22964,22965,22967,22972,22976,22977,22988,22989,23002,23004,23006,23007,23008,23009,23014,23019,23020,23024,23025,23028,23032,23037,23040,23044,23054,23055,23059,23062,23066,23072,23081,23082,23092,23095,23107,23112,23121,23171,23185,23227,23269,23449,23459,23465,23485,23508,23528,23572,23585,23709,23723,23904,23908,23929,24015,24065,24235,24236,24264,24297,24354,24357,24390,24447,24528,24624,24625,24626,24627,24776,24831,24926,24997,25174,25266,25267,25297,25422,25474,25496,25510,25521,25529,25598,25793,25798,25837,25897,25949,25992,25993,26033,26052,26331,26342,26416,26485,26491,26555,26615,26665,26747,26774,26829,26834,26869,26895,26910,26914,26927,27042,27049,27072,27074,27144,27187,27210,27236,27243,27245,27251,27262,27279,27291,27311,27339,27356,27363,27390,27395,27402,27404,27406,27416,27457,27478,27514,27538,27619,27656,27661,27665,27719,27724,27767,27783,27789,27818,27819,27820,27902,27996,28036,28047,28053,28060,28062,28075,28084,28095,28145,28161,28165,28166,28168,28183,28195,28231,28259,28289,28293,28297,28312,28321,28326,28332,28358,28376,28390,28392,28393,28396,28400,28403,28413,28419,28441,28443,28468,28474,28493,28516,28531,28624,28629,28633,28642,28689,28690,28714,28715,28733,28771,28809,28810,28813,28840,28849,28850,28864,28866,28887,28934,28935,28969,28974,29004,29005,29006,29013,29081,29085,29099,29113,29114,29168,29195,29197,29246,29259,29316,29350,29352,29361,29395,29418,29427,29441,29450,29457,29469,29491,29542,29559,29582,29599,29662,29723,29728,29838,29859,29881,29884,29900,29934,29986,30260,30265,30325,30347,30349,30353,30416,30586,30616,30618,30677,30747,30749,30773,30900,31005,31052,31251,31371,31375,31379,31398,31399,31406,31435,31463,31563,31605,31607,31613,31616,31653,31674,31696,31758,31802,31964,31968,31982,31986,32022,32062,32094,32102,32115,32124,32154,32167,32259,32290,32321,32531,32574,32598,32679,32821,32833,32865,32955,33064,33325,33400,33410,33411,33421,33433,33434,33503,33504,33534,33556,33594,33601,33618,33635,33636,33695,33731,33836,33888,33890,33896,33905,33915,33930,33933,33936,33941,33951,33956,33957,33971,33972,34003,34004,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,34311,34314,34325,34327,34330,34331,34333,34334,34347,34400,34416,34417,34427,34437,34438,34445,34453,34466,34468,34478,34508,34520,34537,34538,34549,34562,34598,34604,34617,34635,34640,34651,34666,34667,34684,34704,34825,35014,35026,35028,35226,36086,36288,36432,36497,37612)
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 | 1234 | 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 |