Query Time: 4.72 ms After last query: 1.07 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 23:22:11')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-11-24 23:22:11')
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,478,512,583,615,1398,5354,5955,5985,6016,6619,6633,7103,7430,8096,8549,8550,8743,8861,8862,8870,8871,8961,9063,9064,9169,9170,9172,9341,9342,9343,9415,9416,9624,9648,9649,9717,9860,9862,10010,10065,10066,10076,10111,10332,10373,10510,10558,10559,10636,10637,10642,10660,10666,10673,10688,10701,10737,10743,10744,10769,10853,10863,10867,10874,11065,11259,11262,11265,11272,11292,11299,11317,11319,11437,11467,11619,11716,11804,11869,11911,11924,12032,13381,15841,16329,17279,17307,17329,17424,17457,17458,17555,17606,17643,17709,17710,17711,17728,17729,17735,17739,17761,17762,17766,17768,17774,17851,17893,18043,18180,18330,18336,18357,18359,18403,18409,18414,18418,18430,18431,18472,18509,18512,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,18855,18859,18879,18892,18900,18906,18907,18953,18969,18970,18979,18987,18992,18994,19002,19017,19024,19038,19054,19057,19061,19063,19068,19087,19092,19112,19115,19122,19125,19165,19167,19181,19187,19188,19203,19223,19237,19251,19265,19272,19278,19281,19283,19298,19299,19307,19318,19341,19371,19384,19395,19413,19427,19431,19436,19437,19456,19460,19464,19473,19547,19588,19590,19593,19597,19605,19607,19609,19620,19624,19628,19632,19645,19646,19654,19656,19674,19681,19700,19715,19718,19731,19733,19737,19754,19755,19760,19762,19786,19790,19796,19801,19815,19832,19834,19839,19841,19850,19855,19874,19877,19919,19920,19921,19930,19949,19961,19963,19965,19969,19970,19971,19973,19983,19986,19991,20003,20004,20011,20012,20016,20019,20028,20031,20049,20060,20062,20065,20073,20074,20084,20085,20090,20093,20102,20107,20111,20127,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,20287,20292,20293,20295,20296,20300,20301,20304,20308,20312,20313,20314,20320,20321,20338,20339,20340,20373,20374,20380,20382,20388,20391,20393,20401,20404,20405,20406,20407,20427,20428,20433,20439,20443,20447,20451,20453,20459,20464,20473,20486,20491,20497,20498,20503,20509,20517,20518,20519,20520,20522,20523,20527,20531,20534,20537,20538,20551,20573,20576,20583,20601,20613,20614,20621,20624,20627,20631,20638,20648,20653,20656,20657,20662,20663,20664,20669,20675,20679,20698,20704,20706,20712,20715,20728,20730,20731,20743,20766,20771,20773,20774,20962,20973,20998,20999,21002,21022,21035,21048,21066,21088,21093,21099,21107,21120,21136,21137,21143,21164,21165,21192,21199,21207,21222,21224,21225,21232,21238,21244,21245,21253,21255,21257,21267,21270,21273,21274,21275,21276,21279,21283,21289,21301,21315,21317,21320,21336,21337,21340,21355,21368,21369,21374,21379,21380,21389,21392,21451,21462,21466,21485,21488,21492,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,21651,21652,21654,21661,21668,21669,21679,21682,21692,21693,21694,21695,21700,21703,21708,21713,21719,21720,21721,21722,21723,21724,21725,21726,21727,21729,21730,21733,21735,21736,21738,21749,21750,21751,21752,21756,21763,21764,21774,21775,21783,21787,21793,21798,21803,21809,21812,21815,21817,21818,21819,21823,21827,21831,21838,21852,21865,21870,21884,21885,21910,21924,21927,21930,21940,21941,21944,21946,21952,21953,21957,21958,21961,21969,21971,21982,21986,21987,21988,21989,22003,22005,22007,22008,22009,22010,22011,22012,22015,22016,22019,22026,22033,22035,22038,22039,22047,22048,22049,22051,22053,22055,22072,22081,22090,22092,22109,22110,22112,22114,22117,22122,22123,22125,22127,22131,22135,22137,22138,22142,22151,22152,22153,22156,22159,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,22334,22337,22340,22343,22344,22347,22349,22354,22357,22358,22360,22361,22364,22370,22371,22374,22375,22376,22381,22386,22387,22390,22391,22393,22395,22397,22404,22406,22407,22409,22410,22412,22414,22419,22426,22429,22432,22433,22435,22436,22448,22453,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,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,22672,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,22754,22755,22765,22766,22767,22769,22770,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,22950,22951,22955,22959,22964,22965,22967,22972,22976,22977,22988,22989,23002,23004,23006,23007,23008,23009,23014,23019,23020,23024,23025,23028,23032,23033,23037,23040,23054,23055,23059,23061,23062,23066,23069,23070,23071,23076,23081,23082,23088,23092,23095,23097,23101,23112,23118,23121,23133,23143,23155,23174,23176,23204,23205,23221,23225,23229,23239,23269,23278,23285,23289,23314,23328,23329,23335,23350,23357,23358,23415,23424,23426,23452,23505,23521,23531,23547,23550,23551,23559,23570,23585,23655,23709,23712,23737,23751,23756,23757,23775,23801,23807,23808,23840,23850,23851,23877,23898,23907,23921,23927,23936,23938,23948,23971,23972,23995,24013,24015,24034,24065,24078,24103,24116,24121,24145,24165,24235,24236,24238,24258,24267,24289,24294,24315,24339,24348,24354,24365,24389,24440,24443,24528,24596,24597,24598,24624,24625,24626,24627,24670,24792,24809,24831,24888,24926,24995,24997,25039,25058,25093,25120,25127,25142,25204,25279,25280,25294,25329,25336,25354,25367,25376,25414,25419,25495,25496,25510,25592,25598,25651,25762,25793,25798,25837,25875,25876,25894,25906,25949,25958,25978,25990,25992,25993,26035,26042,26052,26120,26136,26153,26193,26277,26292,26294,26304,26319,26331,26591,26665,26688,26747,26774,26829,26834,26869,26895,26910,26914,27003,27042,27049,27094,27125,27136,27138,27139,27154,27196,27210,27227,27236,27241,27268,27272,27291,27296,27309,27311,27318,27338,27351,27356,27363,27395,27405,27406,27422,27445,27457,27466,27503,27514,27549,27614,27619,27641,27656,27659,27661,27664,27665,27670,27678,27689,27719,27724,27767,27783,27789,27803,27818,27819,27895,27902,27928,27993,27996,27998,28003,28004,28036,28037,28047,28053,28075,28084,28095,28128,28139,28145,28161,28165,28166,28168,28183,28195,28259,28262,28274,28289,28293,28297,28312,28321,28326,28332,28358,28372,28376,28384,28393,28394,28403,28440,28441,28443,28451,28467,28468,28472,28474,28499,28510,28516,28517,28531,28546,28624,28626,28629,28642,28665,28667,28689,28690,28707,28713,28714,28715,28729,28731,28732,28733,28735,28748,28773,28809,28810,28813,28824,28825,28849,28850,28864,28865,28866,28887,28904,28914,28934,28935,28939,28953,28954,28969,28974,28982,28997,29004,29005,29006,29054,29060,29081,29085,29090,29096,29105,29113,29114,29118,29195,29197,29200,29234,29246,29259,29260,29286,29315,29316,29333,29350,29352,29361,29369,29371,29389,29390,29395,29418,29427,29441,29450,29469,29478,29481,29491,29493,29510,29518,29542,29559,29582,29599,29611,29643,29647,29648,29655,29656,29699,29700,29717,29723,29728,29794,29795,29815,29838,29859,29881,29884,29899,29900,29934,29962,29970,29972,29973,29984,30044,30066,30079,30113,30147,30187,30311,30346,30347,30349,30353,30420,30430,30468,30501,30527,30577,30578,30584,30586,30616,30617,30618,30634,30692,30719,30720,30744,30773,30780,30792,30900,30940,31035,31082,31147,31159,31160,31175,31238,31243,31251,31285,31371,31375,31379,31431,31435,31446,31534,31556,31565,31567,31605,31607,31673,31694,31696,31758,31773,31786,31791,31812,31820,31840,31871,31904,31964,31968,31982,31986,31997,32022,32041,32081,32083,32093,32102,32115,32124,32135,32154,32254,32290,32428,32455,32494,32512,32530,32531,32563,32598,32626,32638,32650,32682,32819,32821,32835,32862,32945,32946,32970,32975,32983,33005,33035,33037,33052,33058,33076,33088,33098,33108,33110,33127,33151,33176,33202,33208,33214,33220,33231,33258,33269,33288,33305,33307,33310,33320,33326,33354,33363,33400,33404,33410,33411,33421,33433,33434,33503,33558,33635,33636,33660,33695,33698,33836,33888,33890,33896,33905,33915,33930,33933,33936,33941,33951,33957,33971,33972,34003,34004,34007,34020,34021,34028,34041,34089,34100,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,34324,34325,34327,34330,34331,34333,34334,34347,34400,34416,34417,34427,34437,34438,34445,34453,34468,34478,34508,34520,34537,34538,34549,34557,34598,34604,34617,34635,34640,34651,34666,34667,34684,34704,34825,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 | 1612 | 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 |