Query Time: 3.65 ms After last query: 0.86 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-30 10:36:47')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-11-30 10:36:47')
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,1417,1451,1453,3122,5928,5957,6271,6410,6413,6440,6441,6448,6467,6500,6507,6508,6545,6562,6569,6571,6592,6619,6740,6745,6900,6901,6916,7240,7446,7528,7529,7577,7719,7720,7797,7798,7814,7849,7919,8202,8271,8879,8881,8882,8883,8894,8895,8904,8905,8912,8913,8925,8926,8955,8956,8968,8969,9122,9123,9124,9125,9140,9141,9154,9155,9169,9170,9177,9329,9330,9432,9433,9925,10190,10288,10333,10334,10387,10436,10440,10441,10442,10444,10460,10461,10462,10465,10468,10470,10473,10480,10481,10494,10498,10535,10536,10548,10550,10552,10553,10571,10590,10606,10607,10615,10618,10631,10644,10645,10688,10709,10738,10743,10744,10757,10775,10776,10779,10780,10782,10785,10825,10832,10837,10847,10860,10863,10875,10876,10880,10887,10895,10900,10913,10962,10964,10987,11007,11044,11058,11061,11063,11065,11182,11302,11362,11522,11534,11562,11591,11595,11606,11633,14428,15841,16329,16604,16657,16672,16921,17193,17337,17395,17401,17403,17443,17445,17458,17525,17541,17545,17553,17554,17557,17570,17571,17588,17591,17592,17595,17596,17604,17606,17611,17621,17623,17625,17633,17634,17635,17636,17637,17641,17642,17644,17647,17648,17649,17651,17655,17657,17661,17666,17669,17670,17678,17680,17687,17691,17692,17693,17698,17709,17729,17734,17739,17740,17753,17766,17778,17788,17790,17796,17815,17851,17860,17861,17878,17938,17942,17947,17950,17955,17962,17964,17966,17968,17972,17986,17987,17988,17989,17990,17991,17994,17995,18039,18042,18043,18046,18118,18127,18154,18179,18180,18222,18243,18269,18271,18312,18345,18357,18359,18363,18387,18409,18417,18431,18446,18451,18472,18518,18522,18528,18532,18533,18541,18543,18555,18558,18559,18561,18563,18567,18568,18611,18615,18620,18627,18638,18648,18651,18652,18655,18662,18682,18683,18687,18689,18690,18691,18705,18720,18727,18729,18730,18737,18746,18757,18764,18768,18778,18780,18785,18817,18833,18845,18859,18879,18892,18898,18899,18900,18906,18907,18947,18953,18966,18969,18970,18979,18983,18987,18988,18992,18994,19002,19014,19015,19017,19024,19038,19042,19057,19061,19065,19076,19082,19086,19087,19092,19111,19112,19115,19120,19122,19125,19128,19131,19133,19146,19147,19161,19163,19165,19168,19177,19181,19185,19188,19195,19196,19197,19198,19199,19200,19201,19203,19208,19209,19212,19213,19217,19219,19220,19222,19237,19251,19267,19268,19272,19276,19278,19281,19282,19292,19298,19299,19307,19318,19341,19371,19413,19427,19431,19436,19437,19456,19458,19460,19464,19465,19473,19547,19590,19593,19597,19605,19607,19609,19620,19624,19632,19645,19654,19656,19674,19678,19681,19700,19718,19731,19733,19737,19754,19755,19760,19762,19786,19790,19796,19801,19815,19832,19834,19839,19850,19855,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,20227,20229,20234,20240,20241,20243,20245,20252,20258,20262,20264,20265,20268,20269,20270,20280,20282,20287,20292,20293,20295,20296,20300,20304,20308,20312,20313,20314,20320,20321,20338,20339,20340,20373,20374,20380,20388,20391,20393,20401,20404,20405,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,20698,20704,20706,20712,20715,20728,20730,20731,20743,20766,20773,20774,20962,20973,20998,21022,21035,21048,21066,21088,21093,21107,21120,21136,21137,21143,21164,21192,21207,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,21392,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,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,22311,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,22392,22393,22395,22397,22404,22406,22407,22409,22410,22412,22414,22419,22426,22432,22435,22436,22448,22459,22465,22466,22471,22475,22486,22487,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,22808,22809,22811,22818,22819,22820,22821,22822,22826,22829,22830,22839,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,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,23269,23585,23709,23901,23962,24015,24021,24065,24235,24236,24354,24624,24625,24626,24627,24663,24761,24831,24926,24938,24997,25010,25123,25496,25510,25589,25598,25793,25798,25837,25949,25992,25993,26026,26052,26331,26665,26747,26774,26804,26829,26834,26869,26895,26910,26914,27042,27049,27210,27236,27291,27311,27356,27363,27395,27406,27445,27457,27514,27619,27656,27661,27665,27719,27724,27767,27783,27789,27818,27819,27902,27996,28036,28047,28053,28075,28084,28095,28145,28161,28165,28166,28168,28183,28195,28259,28289,28293,28297,28312,28321,28326,28332,28358,28376,28393,28403,28441,28443,28468,28474,28516,28531,28624,28629,28642,28689,28690,28714,28715,28733,28809,28810,28813,28828,28849,28850,28864,28866,28887,28934,28935,28969,28974,29004,29005,29006,29081,29085,29113,29114,29195,29197,29246,29259,29316,29350,29352,29361,29395,29396,29397,29418,29427,29441,29450,29469,29491,29542,29556,29559,29582,29599,29723,29728,29838,29859,29881,29884,29900,29934,29979,29988,30017,30257,30347,30349,30353,30586,30616,30618,30773,30900,31251,31371,31375,31379,31435,31605,31607,31696,31758,31964,31968,31982,31986,32022,32102,32115,32124,32154,32290,32531,32598,32821,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,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,35014,35026,35028,36086,36288,36432,36497,36899,37612,37756,37801,37813,37818,37819,37823,37824,37825,37836,37837,37840,37841,37842,37844,37845,37847,37851,37852,37854,37859,37861)
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 | 1449 | 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 |