Query Time: 4.47 ms After last query: 0.98 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-25 06:35:40')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-11-25 06:35:40')
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,1469,2684,2707,2901,2933,3445,5514,5524,5685,5726,5738,5753,5908,6174,6175,6261,6296,6297,6337,6339,6351,6352,6445,6619,6916,6955,7002,7274,8262,8480,8507,8508,9245,9246,9263,9265,10147,10221,10233,10234,10313,10384,10414,10565,10573,10590,10606,10611,10612,10688,10718,10798,10816,10823,10824,10849,10976,10978,11044,11116,11329,11339,11342,11346,11349,11367,11410,11412,11416,11428,11429,11436,11445,11516,11519,11524,11525,11526,11527,11533,11552,11553,11557,11566,11582,11617,11626,11650,11681,11713,11747,11809,11828,11930,11936,11972,12066,12110,12223,12276,12366,12403,12416,12427,12437,12467,12546,12582,12586,12603,12612,12626,12627,12648,12650,12664,12679,12680,12693,12703,12704,12705,12713,12714,12725,12726,12741,12742,12748,12749,12759,12760,12761,12763,12765,12768,12770,12781,12782,12796,12834,12850,12873,12895,12904,12905,12917,12928,12938,12956,12959,12989,12992,12994,13017,13030,13043,13044,13046,13088,13100,13150,13189,13261,13268,13276,13277,13279,13281,13449,13484,13489,13492,13499,13579,13603,13611,13647,13651,13673,13682,13729,13741,13758,13767,13782,13786,13787,13790,13795,13874,13876,13888,14009,14061,14074,14113,14132,14133,14389,14402,14410,14417,14419,14422,14436,14437,14441,14497,14521,14522,14524,14553,14570,14593,14811,14832,14932,14937,15116,15128,15147,15211,15305,15335,15440,15456,15525,15603,15644,15710,15723,15734,15840,15841,15874,16013,16047,16149,16185,16227,16238,16329,16335,16415,16503,16599,16832,16845,16847,16850,17051,17055,17065,17114,17151,17189,17426,17485,17729,17749,17766,17826,17851,17855,17974,18025,18043,18056,18161,18180,18193,18204,18209,18216,18240,18261,18289,18331,18357,18359,18409,18431,18472,18486,18515,18518,18532,18533,18558,18559,18561,18563,18567,18578,18627,18635,18638,18648,18651,18652,18655,18682,18687,18690,18691,18697,18705,18723,18727,18732,18737,18746,18753,18768,18778,18781,18785,18806,18853,18854,18859,18879,18892,18900,18906,18907,18953,18969,18970,18979,18987,18992,18994,19002,19017,19024,19029,19038,19057,19061,19077,19087,19092,19097,19115,19122,19125,19144,19151,19153,19165,19174,19181,19188,19203,19214,19237,19251,19272,19278,19281,19298,19299,19307,19318,19331,19341,19371,19375,19413,19427,19431,19434,19436,19437,19445,19456,19460,19464,19473,19547,19571,19573,19577,19582,19590,19593,19597,19605,19607,19609,19620,19624,19632,19645,19654,19656,19659,19660,19664,19674,19681,19693,19700,19718,19731,19732,19733,19736,19737,19738,19745,19753,19754,19755,19758,19760,19761,19762,19778,19786,19790,19796,19798,19801,19815,19832,19834,19839,19850,19855,19867,19874,19877,19911,19919,19920,19921,19930,19949,19965,19969,19970,19971,19973,19974,19983,19986,19991,20003,20011,20012,20016,20019,20028,20031,20049,20062,20065,20073,20074,20078,20084,20085,20090,20093,20102,20107,20111,20122,20133,20153,20164,20185,20190,20192,20198,20199,20206,20210,20211,20213,20222,20229,20234,20240,20241,20243,20245,20252,20258,20262,20264,20265,20268,20269,20270,20280,20282,20286,20287,20292,20293,20295,20296,20297,20300,20304,20308,20312,20313,20314,20320,20321,20338,20339,20340,20373,20374,20380,20388,20391,20393,20401,20404,20405,20406,20407,20415,20421,20422,20427,20428,20433,20439,20443,20451,20453,20458,20459,20461,20464,20470,20473,20486,20491,20498,20501,20507,20509,20517,20518,20520,20522,20523,20526,20527,20531,20534,20536,20537,20546,20548,20551,20573,20576,20583,20591,20601,20602,20614,20621,20624,20626,20627,20638,20653,20656,20657,20662,20663,20664,20669,20675,20676,20696,20698,20704,20706,20712,20715,20728,20730,20731,20743,20759,20766,20773,20774,20794,20823,20840,20946,20962,20973,20998,21022,21035,21048,21058,21061,21066,21088,21093,21107,21120,21136,21137,21143,21164,21192,21207,21224,21225,21232,21238,21244,21245,21253,21255,21257,21262,21267,21270,21273,21274,21275,21276,21280,21283,21301,21317,21320,21336,21337,21340,21355,21368,21369,21374,21379,21380,21392,21411,21462,21466,21483,21485,21488,21491,21494,21499,21500,21509,21512,21515,21518,21520,21521,21528,21533,21536,21540,21549,21550,21551,21552,21553,21555,21557,21558,21559,21561,21562,21564,21568,21569,21572,21573,21581,21586,21587,21590,21595,21596,21601,21608,21616,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,21753,21756,21763,21764,21774,21775,21783,21787,21793,21798,21801,21809,21812,21815,21817,21819,21823,21827,21831,21838,21865,21866,21870,21884,21885,21910,21924,21927,21930,21932,21944,21946,21952,21953,21957,21958,21961,21969,21971,21982,21986,21987,21988,21989,22003,22005,22007,22008,22009,22010,22011,22012,22015,22019,22023,22024,22026,22033,22035,22038,22039,22047,22048,22049,22051,22054,22055,22072,22081,22092,22100,22109,22110,22112,22114,22117,22122,22123,22125,22127,22135,22137,22138,22140,22142,22151,22152,22153,22156,22159,22165,22168,22171,22172,22174,22176,22178,22183,22184,22185,22186,22187,22191,22194,22195,22202,22203,22205,22206,22207,22212,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,22278,22279,22286,22290,22302,22303,22304,22305,22306,22307,22308,22314,22316,22318,22319,22321,22322,22324,22325,22326,22327,22328,22330,22332,22334,22336,22337,22340,22342,22343,22344,22349,22354,22357,22358,22360,22364,22371,22374,22375,22376,22381,22382,22386,22387,22390,22391,22393,22395,22397,22404,22406,22407,22409,22410,22412,22414,22419,22426,22432,22435,22436,22441,22445,22448,22459,22464,22465,22466,22471,22472,22475,22486,22489,22491,22496,22498,22499,22500,22501,22502,22504,22505,22506,22509,22511,22514,22516,22517,22518,22521,22523,22524,22525,22527,22528,22529,22530,22531,22534,22536,22537,22538,22539,22540,22549,22552,22554,22555,22557,22560,22563,22564,22565,22568,22569,22571,22574,22576,22581,22582,22586,22588,22589,22591,22596,22602,22604,22605,22607,22608,22611,22612,22613,22616,22620,22621,22624,22625,22630,22631,22632,22634,22636,22637,22638,22639,22640,22641,22642,22644,22645,22648,22649,22650,22652,22653,22654,22655,22656,22657,22658,22659,22668,22670,22671,22674,22675,22676,22677,22678,22679,22682,22683,22685,22687,22690,22691,22692,22693,22700,22702,22703,22704,22705,22706,22707,22709,22710,22714,22716,22717,22718,22721,22722,22723,22724,22727,22729,22731,22734,22735,22736,22737,22738,22739,22741,22743,22744,22745,22746,22747,22749,22751,22753,22755,22761,22762,22763,22764,22765,22766,22767,22769,22772,22774,22776,22780,22783,22785,22787,22789,22790,22791,22792,22793,22795,22796,22798,22799,22803,22804,22807,22809,22811,22812,22818,22819,22820,22821,22822,22829,22830,22844,22845,22846,22847,22851,22854,22858,22864,22865,22866,22869,22875,22876,22881,22882,22885,22886,22887,22890,22891,22892,22894,22896,22898,22905,22910,22911,22912,22913,22918,22921,22922,22923,22924,22925,22927,22935,22936,22940,22941,22943,22944,22950,22951,22952,22955,22962,22964,22965,22967,22972,22976,22977,22988,22989,23002,23004,23006,23007,23008,23009,23012,23013,23014,23019,23020,23024,23025,23028,23032,23037,23040,23054,23055,23059,23062,23066,23073,23074,23075,23081,23082,23092,23095,23097,23102,23103,23112,23121,23122,23124,23125,23140,23141,23157,23172,23188,23231,23269,23310,23319,23346,23362,23373,23374,23399,23405,23409,23429,23472,23479,23525,23534,23585,23683,23684,23685,23686,23692,23694,23709,23719,23733,23759,23798,23799,23800,23805,23859,23912,23931,23944,23945,23946,23964,23999,24001,24015,24065,24066,24073,24114,24120,24137,24166,24167,24170,24184,24185,24235,24236,24241,24242,24245,24247,24316,24354,24397,24405,24624,24625,24626,24627,24628,24631,24687,24702,24766,24812,24831,24859,24860,24899,24909,24926,24943,24979,24981,24997,25022,25023,25024,25028,25032,25057,25095,25117,25253,25299,25356,25449,25450,25496,25510,25530,25533,25556,25598,25606,25612,25614,25621,25730,25776,25793,25798,25837,25907,25949,25965,25991,25992,25993,26051,26052,26283,26328,26331,26476,26542,26560,26573,26651,26665,26747,26774,26790,26829,26834,26869,26895,26910,26914,26926,27042,27049,27053,27210,27236,27291,27311,27356,27363,27395,27406,27445,27446,27449,27457,27481,27505,27507,27514,27562,27597,27598,27619,27656,27661,27665,27719,27724,27767,27783,27789,27818,27819,27902,27964,27996,28036,28047,28053,28075,28084,28095,28145,28161,28165,28166,28168,28172,28183,28195,28259,28289,28293,28297,28312,28321,28326,28332,28358,28376,28393,28403,28441,28443,28468,28474,28516,28531,28624,28629,28632,28642,28689,28690,28714,28715,28733,28785,28809,28810,28813,28849,28850,28864,28866,28887,28934,28935,28969,28973,28974,29004,29005,29006,29081,29085,29113,29114,29195,29197,29246,29259,29316,29350,29352,29361,29395,29418,29427,29441,29450,29469,29491,29527,29542,29559,29582,29599,29723,29728,29838,29859,29881,29884,29900,29934,30087,30111,30259,30278,30302,30347,30349,30353,30463,30508,30586,30616,30618,30648,30651,30773,30831,30836,30900,30910,31124,31184,31210,31251,31371,31375,31379,31435,31581,31605,31607,31696,31758,31797,31963,31964,31968,31982,31986,32022,32088,32102,32104,32115,32124,32154,32182,32250,32255,32290,32531,32598,32821,33022,33400,33410,33411,33421,33433,33434,33503,33635,33636,33682,33695,33836,33888,33890,33896,33905,33915,33930,33933,33935,33936,33941,33951,33957,33971,33972,34003,34004,34005,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,34437,34438,34445,34453,34468,34478,34508,34520,34537,34538,34549,34598,34604,34617,34635,34640,34651,34666,34667,34684,34704,34825,34859,35014,35026,35028,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 | 1652 | 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 |