Query Time: 3.64 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-24 23:41:56')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-11-24 23:41:56')
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(201,202,204,205,215,225,232,241,243,264,281,289,290,297,298,300,301,302,303,306,307,311,312,314,322,326,330,332,336,349,355,361,364,373,374,376,377,378,381,383,384,386,388,391,396,398,399,402,403,407,414,417,418,437,439,448,455,459,463,465,466,467,469,470,479,480,481,482,483,484,487,492,494,495,504,508,511,514,515,516,526,527,528,533,540,541,542,546,548,551,555,559,564,565,570,571,573,582,586,594,704,934,5523,5653,6444,6608,6864,6882,6883,6901,6906,6925,6957,6963,6972,7280,7676,8021,8931,8932,9041,9042,9043,9786,9836,9928,10199,10246,10800,10918,10922,11039,11403,11493,11818,11819,15813,15845,15962,15963,16141,16356,16366,16367,16514,16654,16655,16656,16920,17272,17273,17398,17401,17558,17591,17625,17713,17767,17862,17904,17916,17933,17939,17947,17961,18156,18183,18228,18262,18304,18390,18417,18522,18526,18534,18537,18544,18615,18620,18633,18665,18676,18681,18688,18689,18709,18712,18747,18748,18757,18799,18805,18818,18819,18845,18858,18888,18915,18918,18920,18934,18935,18937,18947,18956,18959,18985,18988,18997,19008,19014,19015,19019,19032,19033,19052,19103,19104,19105,19111,19135,19163,19166,19197,19199,19200,19209,19217,19220,19226,19229,19235,19243,19244,19245,19246,19253,19264,19267,19280,19284,19311,19342,19366,19382,19392,19402,19405,19419,19442,19444,19459,19475,19579,19581,19589,19595,19610,19614,19629,19653,19678,19686,19714,19721,19729,19745,19752,19753,19761,19794,19795,19809,19813,19817,19822,19824,19825,19845,19846,19847,19853,19856,19868,19873,19879,19884,19886,19888,19900,19901,19928,19931,19941,19943,19944,19960,19980,19981,19987,20007,20008,20009,20015,20020,20025,20027,20032,20037,20038,20045,20053,20054,20055,20056,20066,20071,20079,20081,20086,20097,20098,20103,20104,20106,20109,20110,20125,20128,20129,20136,20137,20148,20154,20156,20161,20167,20169,20172,20177,20179,20193,20194,20202,20221,20225,20235,20237,20238,20255,20272,20278,20279,20284,20291,20294,20298,20302,20316,20317,20319,20324,20325,20337,20345,20347,20362,20375,20383,20386,20396,20429,20434,20435,20463,20465,20467,20468,20471,20476,20481,20488,20489,20495,20511,20515,20528,20532,20552,20554,20555,20562,20564,20565,20581,20582,20590,20629,20632,20633,20641,20646,20651,20655,20676,20677,20699,20703,20717,20720,20721,20722,20735,20738,20741,20747,20748,20756,20769,20776,20785,20786,20788,20791,20810,20852,20905,20907,20915,20917,20927,20949,20975,20981,20989,21006,21008,21009,21031,21034,21043,21045,21051,21057,21073,21089,21101,21108,21111,21123,21125,21140,21141,21145,21160,21162,21163,21172,21178,21179,21183,21184,21186,21187,21201,21211,21246,21247,21259,21260,21281,21288,21305,21306,21307,21310,21327,21357,21361,21364,21371,21373,21390,21406,21428,21429,21432,21440,21442,21443,21446,21447,21449,21450,21458,21461,21463,21471,21474,21481,21489,21495,21496,21501,21503,21504,21507,21511,21517,21531,21532,21534,21544,21545,21563,21565,21570,21579,21585,21593,21599,21600,21603,21609,21611,21626,21628,21629,21636,21649,21658,21671,21673,21676,21678,21680,21686,21687,21699,21704,21705,21706,21710,21714,21732,21734,21737,21742,21766,21771,21773,21782,21786,21790,21791,21800,21804,21816,21825,21826,21839,21841,21847,21848,21849,21854,21855,21860,21869,21875,21876,21879,21887,21888,21893,21894,21896,21897,21898,21899,21905,21906,21907,21908,21916,21918,21921,21922,21928,21931,21936,21942,21943,21945,21949,21954,21955,21956,21960,21963,21964,21966,21968,21970,21985,21994,21999,22004,22014,22018,22021,22022,22028,22029,22036,22040,22045,22046,22056,22057,22058,22062,22066,22107,22108,22116,22118,22119,22120,22132,22143,22145,22146,22150,22157,22158,22162,22166,22167,22170,22173,22177,22196,22197,22198,22210,22219,22223,22225,22234,22236,22251,22255,22256,22258,22259,22260,22287,22295,22296,22297,22301,22312,22313,22345,22359,22367,22368,22377,22378,22388,22401,22402,22408,22415,22416,22417,22423,22425,22445,22446,22454,22455,22477,22479,22480,22483,22488,22493,22495,22497,22508,22512,22513,22532,22535,22544,22545,22551,22573,22575,22577,22578,22583,22584,22587,22594,22601,22609,22610,22614,22617,22619,22626,22628,22629,22660,22661,22662,22665,22666,22667,22681,22684,22712,22713,22720,22725,22726,22748,22750,22752,22758,22759,22760,22768,22782,22797,22810,22828,22832,22837,22843,22857,22859,22860,22868,22878,22897,22899,22900,22909,22926,22932,22933,22938,22946,22947,22956,22957,22961,22963,22966,22969,22978,22979,22980,22992,22993,23017,23022,23027,23041,23044,23049,23050,23051,23052,23063,23067,23077,23079,23098,23116,23131,23146,23154,23162,23184,23185,23190,23192,23197,23198,23216,23217,23230,23234,23236,23237,23249,23261,23264,23275,23295,23296,23308,23309,23311,23321,23327,23331,23332,23343,23345,23370,23377,23378,23379,23386,23387,23393,23401,23408,23410,23411,23413,23414,23422,23430,23431,23435,23438,23439,23443,23444,23445,23446,23448,23451,23453,23455,23456,23458,23459,23460,23461,23462,23463,23464,23467,23468,23469,23474,23475,23476,23478,23483,23484,23485,23486,23488,23489,23496,23497,23500,23507,23511,23514,23515,23516,23518,23520,23529,23532,23535,23537,23538,23540,23542,23544,23546,23553,23554,23562,23564,23567,23574,23575,23576,23586,23587,23588,23591,23593,23603,23609,23611,23612,23622,23636,23650,23660,23661,23677,23688,23695,23697,23698,23713,23714,23722,23725,23728,23730,23741,23747,23752,23766,23767,23785,23793,23819,23820,23821,23827,23829,23832,23855,23873,23874,23875,23876,23880,23881,23887,23893,23899,23900,23901,23905,23910,23915,23918,23920,23924,23934,23939,23941,23953,23958,23974,23978,23980,23991,23992,24003,24014,24018,24026,24032,24042,24058,24060,24077,24085,24086,24096,24097,24098,24102,24126,24140,24142,24158,24174,24175,24179,24190,24197,24200,24201,24202,24209,24220,24223,24224,24227,24232,24242,24246,24254,24256,24270,24272,24277,24287,24290,24293,24296,24312,24321,24326,24327,24330,24344,24355,24368,24371,24393,24396,24408,24425,24436,24441,24455,24459,24461,24497,24513,24546,24552,24584,24590,24595,24600,24601,24602,24616,24617,24639,24653,24655,24656,24660,24700,24703,24708,24731,24761,24767,24777,24779,24780,24796,24798,24825,24835,24841,24853,24855,24857,24859,24924,24943,24955,24957,24971,24983,24990,25014,25015,25018,25061,25089,25137,25144,25238,25239,25243,25248,25251,25298,25302,25319,25320,25321,25333,25334,25337,25338,25349,25358,25368,25369,25388,25393,25406,25408,25415,25422,25423,25437,25460,25483,25508,25509,25514,25540,25542,25545,25548,25552,25553,25560,25565,25582,25595,25603,25607,25610,25615,25625,25629,25631,25635,25638,25657,25658,25662,25675,25676,25678,25680,25693,25694,25720,25721,25728,25730,25738,25745,25749,25767,25768,25769,25779,25780,25795,25805,25807,25810,25815,25817,25825,25832,25833,25841,25846,25847,25861,25871,25884,25908,25910,25913,25924,25936,25939,25952,25953,25956,25957,25960,25961,25962,25963,26007,26008,26015,26025,26032,26057,26058,26069,26110,26117,26138,26139,26140,26144,26163,26180,26196,26241,26247,26270,26284,26285,26290,26292,26297,26298,26301,26313,26334,26335,26336,26346,26348,26352,26361,26362,26365,26381,26406,26407,26409,26411,26415,26420,26421,26430,26436,26447,26454,26461,26475,26477,26481,26483,26490,26559,26571,26578,26579,26606,26607,26609,26621,26624,26632,26633,26640,26645,26652,26671,26673,26674,26675,26683,26696,26777,26799,26809,26811,26841,26861,26872,26888,26925,26936,26951,26952,26954,26964,26987,26990,26995,27005,27020,27039,27054,27063,27065,27075,27078,27079,27083,27098,27099,27100,27108,27112,27122,27128,27129,27133,27134,27142,27143,27150,27155,27167,27238,27281,27283,27284,27298,27323,27331,27347,27348,27349,27397,27463,27464,27476,27478,27484,27530,27547,27552,27563,27574,27630,27715,27785,27822,27892,27893,27896,27899,27903,27912,27983,27997,28000,28018,28069,28111,28163,28208,28228,28290,28317,28330,28331,28333,28336,28356,28362,28373,28486,28487,28524,28552,28555,28634,28647,28670,28709,28724,28725,28726,28728,28734,28778,28799,28867,28868,28932,28936,28966,29042,29047,29050,29157,29162,29262,29338,29407,29416,29523,29619,29653,29663,29770,29789,29817,29818,29875,29877,29889,29902,29930,29946,29968,29969,29991,30015,30368,30400,30403,30517,30904,30956,31037,31078,31391,31424,31468,31482,31504,31701,31725,31753,31756,31782,31793,31808,31811,31822,31844,31869,31886,31895,31896,31910,31911,31927,31950,31970,31990,32014,32117,32162,32168,32192,32209,32225,32228,32234,32247,32271,32297,32309,32322,32337,32356,32387,32416,32430,32454,32538,32640,32658,32700,32832,32874,32890,32908,32923,32929,32950,32972,32984,33084,33262,33264,33292,33383,33452,33613,33632,33633,33679,33717,33823,33852,33865,33867,33868,33887,33993,34024,34030,34067,34073,34088,34097,34112,34130,34133,34147,34148,34166,34169,34176,34213,34261,34269,34287,34289,34296,34310,34346,34348,34363,34367,34368,34370,34371,34386,34389,34390,34395,34396,34399,34407,34419,34420,34421,34428,34440,34449,34471,34473,34474,34475,34476,34490,34492,34493,34496,34503,34509,34517,34518,34527,34535,34545,34547,34550,34552,34564,34566,34582,34586,34594,34597,34600,34603,34644,34648,34655,34664,34669,34686,34707,34714,34749,34754,34764,34775,34821,34834,34849,34853,34857,34978,34980,34981,35035,35102,35135,35136,35144,35145,35148,35188,35200,35215,35217,35226,35248,35284,35287,35300,35337,35390,35467,35726,35799,35977,35980,36016,36081,36082,36120,36121,36123,36128,36287,36296,36433,36434,37550,37551,37560,37699)
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 | 1591 | 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 |