Query Time: 10.00 ms After last query: 1.42 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 04:49:27')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-11-25 04:49:27')
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(273,274,275,277,278,284,286,288,295,299,305,308,309,310,321,323,324,325,329,331,345,350,358,363,366,380,382,392,393,404,405,409,416,422,423,425,426,428,429,430,431,433,445,468,486,488,489,493,501,510,521,522,523,534,537,538,558,560,562,563,585,592,593,867,1469,1659,1676,2406,2680,2684,2707,2811,2831,2901,2933,3445,5248,5513,5514,5516,5518,5520,5521,5524,5525,5547,5548,5549,5553,5559,5560,5570,5571,5577,5578,5582,5584,5588,5594,5595,5596,5597,5632,5635,5639,5644,5645,5647,5648,5649,5657,5658,5659,5664,5665,5666,5669,5673,5677,5678,5682,5683,5684,5685,5690,5695,5697,5700,5702,5705,5706,5715,5718,5721,5725,5726,5730,5732,5736,5738,5742,5743,5752,5753,5755,5762,5763,5764,5769,5771,5781,5782,5790,5791,5793,5795,5796,5797,5803,5804,5806,5807,5811,5812,5814,5815,5820,5821,5825,5827,5834,5840,5841,5845,5851,5856,5857,5863,5864,5865,5866,5874,5877,5878,5882,5883,5884,5885,5887,5892,5894,5900,5901,5902,5905,5907,5908,5917,5918,5919,5920,5922,5926,5927,5929,5930,5951,6174,6175,6261,6296,6297,6337,6339,6351,6352,6386,6423,6445,6567,6675,6832,6837,6842,6846,6847,6851,6853,6874,6875,6877,6878,6886,6887,6895,6897,6898,6902,6903,6910,6916,6920,6921,6922,6926,6927,6928,6935,6936,6939,6943,6945,6946,6947,6948,6950,6951,6952,6953,6954,6955,6958,6959,6960,6962,6964,6965,6966,6970,6975,6976,6977,6980,6981,6982,6983,6984,6989,6990,6991,6994,6996,6997,7002,7003,7004,7005,7116,7153,7274,7726,7929,8131,8262,8480,8507,8508,8594,8595,8596,8597,8598,8599,8600,8601,8602,8603,8604,8605,8801,8802,8805,8806,8838,8839,8861,8862,8874,8875,8876,8877,8879,8881,8882,8883,8884,8885,8886,8887,8888,8889,8890,8891,8892,8893,8894,8895,8912,8913,8995,8996,9001,9002,9003,9004,9005,9073,9074,9114,9115,9158,9159,9160,9161,9245,9246,9257,9258,9261,9262,9263,9264,9265,9268,9269,9292,9293,9294,9295,9296,9297,9312,9313,9333,9334,9353,9354,9428,9429,9430,9431,9440,9441,9520,9521,9588,9589,9614,9656,9691,9702,9721,9725,9752,9753,9779,9782,9810,9811,9823,9832,9852,9854,9873,9881,9899,9936,9957,9958,9959,9978,9979,9989,9990,9994,9998,10008,10020,10036,10043,10068,10071,10072,10084,10116,10123,10124,10147,10173,10174,10187,10204,10205,10214,10219,10221,10233,10234,10248,10280,10293,10298,10306,10309,10311,10313,10328,10341,10349,10350,10372,10376,10380,10381,10383,10384,10414,10415,10416,10437,10438,10439,10442,10459,10472,10489,10490,10519,10522,10523,10531,10558,10559,10563,10565,10567,10573,10580,10581,10584,10585,10590,10595,10603,10605,10606,10611,10612,10613,10614,10619,10621,10623,10644,10662,10663,10667,10674,10685,10693,10695,10714,10718,10720,10721,10726,10730,10731,10732,10738,10740,10741,10742,10746,10747,10750,10751,10755,10770,10773,10774,10781,10782,10783,10784,10790,10791,10792,10793,10794,10795,10798,10806,10812,10813,10816,10822,10823,10824,10829,10831,10835,10837,10841,10842,10849,10850,10851,10852,10857,10858,10859,10869,10870,10871,10872,10877,10878,10879,10880,10883,10884,10885,10889,10890,10891,10893,10896,10902,10906,10907,10908,10924,10928,10946,10949,10953,10955,10961,10963,10967,10970,10972,10975,10976,10978,10980,10983,10986,10992,11024,11040,11041,11044,11050,11051,11052,11057,11059,11061,11062,11063,11064,11066,11067,11068,11070,11071,11077,11079,11081,11082,11093,11104,11106,11116,11145,11148,11153,11154,11161,11162,11172,11183,11195,11205,11206,11213,11223,11226,11230,11233,11237,11238,11243,11247,11266,11280,11287,11288,11309,11310,11321,11326,11327,11328,11329,11332,11334,11335,11339,11340,11341,11342,11346,11349,11367,11375,11378,11383,11384,11404,11405,11410,11412,11416,11428,11429,11435,11436,11442,11445,11452,11453,11475,11477,11478,11479,11507,11512,11516,11519,11520,11521,11524,11525,11526,11527,11533,11552,11553,11557,11562,11566,11582,11617,11626,11650,11681,11704,11713,11719,11747,11806,11808,11809,11828,11835,11836,11844,11860,11876,11912,11929,11930,11933,11936,11972,12066,12110,12144,12145,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,14423,14436,14437,14441,14497,14521,14522,14524,14553,14570,14593,14753,14811,14832,14932,14937,15116,15128,15147,15211,15305,15335,15440,15456,15525,15603,15644,15710,15723,15734,15802,15803,15807,15840,15868,15874,15910,16013,16014,16047,16149,16185,16224,16227,16238,16247,16335,16338,16415,16503,16568,16599,16832,16845,16847,16850,16860,17051,17055,17065,17114,17151,17189,17356,17426,17485,17572,17604,17749,17779,17780,17826,17855,17875,17877,17974,18025,18056,18058,18125,18161,18193,18204,18209,18216,18223,18240,18261,18289,18331,18398,18473,18486,18489,18515,18524,18525,18565,18578,18608,18635,18653,18654,18693,18700,18713,18721,18723,18732,18742,18748,18749,18753,18754,18781,18806,18821,18830,18835,18836,18853,18854,18865,18883,18896,18901,18902,18903,18904,18924,18952,18974,18997,18998,19020,19050,19062,19077,19085,19089,19091,19097,19106,19107,19119,19127,19133,19144,19150,19153,19162,19174,19182,19185,19194,19201,19206,19212,19214,19222,19225,19227,19230,19231,19241,19273,19274,19286,19309,19325,19327,19331,19375,19376,19384,19390,19394,19398,19400,19415,19418,19433,19434,19445,19446,19464,19469,19472,19571,19573,19574,19577,19582,19596,19600,19619,19630,19634,19657,19660,19664,19679,19680,19687,19690,19693,19695,19703,19705,19707,19713,19717,19719,19734,19740,19744,19748,19768,19769,19770,19775,19789,19792,19793,19799,19806,19823,19833,19842,19843,19849,19881,19895,19913,19923,19924,19936,19940,19956,19964,19974,19977,19995,20005,20018,20022,20023,20027,20042,20047,20063,20067,20075,20077,20078,20088,20100,20101,20122,20126,20133,20149,20151,20168,20180,20184,20212,20248,20254,20286,20288,20289,20297,20299,20306,20307,20310,20314,20326,20327,20341,20342,20343,20348,20370,20385,20409,20411,20415,20418,20432,20442,20445,20458,20461,20465,20472,20478,20492,20497,20501,20507,20510,20513,20515,20521,20526,20546,20548,20557,20560,20575,20587,20596,20599,20602,20620,20635,20652,20659,20665,20666,20674,20685,20700,20739,20759,20761,20765,20789,20794,20823,20839,20840,20854,20855,20870,20890,20894,20899,20906,20910,20914,20918,20919,20936,20946,20955,20983,21013,21020,21044,21058,21077,21119,21126,21129,21134,21168,21169,21178,21182,21200,21202,21215,21216,21217,21234,21250,21251,21262,21266,21268,21284,21285,21298,21299,21302,21311,21335,21341,21350,21365,21383,21385,21387,21396,21398,21405,21409,21411,21453,21469,21470,21478,21479,21481,21483,21484,21491,21499,21506,21514,21524,21535,21541,21542,21543,21546,21565,21569,21577,21580,21597,21598,21613,21624,21625,21633,21639,21640,21653,21683,21693,21728,21744,21745,21746,21747,21753,21755,21765,21767,21770,21772,21801,21827,21828,21832,21835,21836,21857,21866,21868,21871,21880,21901,21902,21914,21923,21925,21926,21932,21937,21951,21972,21993,21998,22000,22002,22006,22020,22023,22024,22034,22054,22061,22087,22100,22103,22105,22106,22121,22126,22133,22136,22140,22148,22149,22159,22168,22179,22181,22182,22199,22200,22212,22235,22247,22252,22278,22279,22286,22292,22293,22307,22308,22323,22330,22331,22336,22342,22347,22348,22355,22356,22382,22383,22389,22398,22399,22411,22441,22464,22472,22500,22505,22514,22524,22534,22538,22539,22541,22542,22543,22562,22567,22572,22574,22581,22590,22592,22595,22596,22598,22599,22600,22605,22606,22608,22622,22624,22627,22636,22637,22645,22647,22653,22663,22673,22687,22689,22697,22698,22699,22701,22705,22708,22715,22729,22734,22735,22736,22737,22738,22739,22756,22757,22761,22762,22763,22764,22773,22774,22775,22780,22787,22795,22803,22804,22812,22813,22823,22824,22834,22848,22849,22850,22851,22854,22861,22862,22866,22867,22877,22879,22880,22883,22884,22901,22905,22908,22921,22923,22924,22928,22931,22934,22937,22939,22941,22953,22958,22962,22968,22970,22971,22975,22981,22983,22996,23001,23012,23013,23018,23021,23023,23029,23036,23039,23042,23043,23064,23065,23068,23073,23074,23075,23082,23093,23095,23096,23097,23102,23103,23104,23109,23111,23112,23120,23122,23124,23125,23136,23137,23139,23140,23145,23147,23153,23157,23159,23166,23172,23177,23186,23188,23195,23196,23203,23218,23220,23223,23230,23231,23232,23233,23250,23252,23253,23254,23260,23262,23267,23274,23277,23280,23282,23283,23294,23297,23303,23310,23319,23330,23336,23342,23344,23346,23356,23362,23373,23374,23376,23380,23397,23399,23405,23407,23409,23417,23418,23429,23433,23440,23441,23442,23454,23457,23472,23479,23487,23490,23494,23501,23509,23510,23523,23525,23534,23541,23543,23548,23552,23555,23594,23597,23605,23607,23613,23618,23623,23624,23626,23633,23637,23662,23666,23678,23683,23684,23685,23686,23687,23691,23692,23694,23701,23705,23707,23708,23719,23733,23739,23740,23754,23755,23759,23764,23768,23770,23774,23778,23779,23784,23785,23786,23787,23794,23798,23799,23800,23802,23804,23805,23809,23810,23811,23815,23822,23841,23859,23864,23872,23889,23890,23894,23895,23902,23908,23911,23912,23914,23919,23923,23925,23931,23944,23945,23946,23964,23992,23999,24037,24061,24066,24067,24073,24114,24120,24127,24137,24161,24166,24167,24170,24183,24184,24185,24195,24208,24213,24215,24226,24241,24245,24247,24255,24295,24316,24376,24397,24549,24628,24631,24687,24702,24710,24766,24812,24860,24870,24890,24899,24908,24909,24913,24947,24979,24981,25019,25022,25023,25024,25028,25032,25046,25057,25095,25115,25124,25161,25173,25189,25253,25299,25308,25323,25343,25356,25449,25450,25530,25533,25556,25583,25612,25614,25621,25776,25834,25836,25861,25907,25965,25991,26051,26154,26266,26283,26328,26476,26542,26560,26573,26579,26651,26687,26790,26846,26926,27053,27081,27106,27304,27315,27355,27446,27449,27481,27485,27505,27507,27562,27597,27598,27648,27669,27704,27722,27801,27964,28115,28134,28162,28172,28243,28388,28491,28553,28564,28608,28625,28632,28723,28737,28742,28744,28785,29180,29192,29237,29238,29240,29253,29312,29313,29337,29370,29375,29379,29426,29527,29541,29563,29738,29748,29749,29761,29762,29869,30087,30111,30123,30259,30278,30302,30314,30404,30405,30463,30508,30543,30648,30650,30651,30772,30814,30831,30836,30895,30910,31000,31015,31083,31097,31124,31130,31184,31210,31280,31404,31457,31458,31459,31495,31513,31551,31566,31581,31684,31797,31957,31963,32088,32099,32104,32111,32172,32182,32199,32243,32250,32255,32325,32732,32813,32814,32870,32900,32903,32994,32996,32999,33000,33022,33052,33066,33079,33095,33136,33142,33197,33309,33362,33410,33432,33433,33505,33545,33570,33583,33639,33674,33681,33682,33720,33762,33820,33828,33873,33884,33934,33935,33938,33941,33952,33979,33980,33981,33992,34005,34014,34016,34031,34032,34040,34047,34048,34051,34053,34054,34078,34079,34080,34081,34099,34109,34125,34159,34160,34163,34186,34191,34192,34193,34199,34223,34233,34238,34245,34248,34259,34265,34266,34267,34276,34286,34297,34326,34340,34341,34342,34343,34349,34350,34351,34354,34372,34379,34380,34387,34388,34398,34400,34401,34402,34421,34424,34425,34435,34441,34442,34443,34446,34454,34465,34469,34472,34489,34503,34504,34506,34528,34544,34571,34584,34591,34610,34611,34612,34624,34634,34663,34695,34745,34806,34859,34906,35030,35081,35144,35228,35495,35545,36007,36088)
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 | 1996 | 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 |