Query Time: 4.50 ms After last query: 1.17 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-27 00:42:36')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-11-27 00:42:36')
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(5608,5668,5728,5729,5777,5808,5809,5832,5833,5848,5849,5872,5881,5890,5916,6408,7084,7452,7572,7613,7715,7877,7883,7884,7898,7985,8025,8036,8053,8054,8070,8072,8074,8082,8172,8189,8194,8199,8206,8207,8208,8209,8210,8220,8221,8222,8230,8231,8235,8236,8254,8260,8261,8262,8271,8272,8273,8274,8280,8281,8283,8284,8285,8286,8287,8288,8291,8292,8293,8296,8297,8298,8299,8300,8308,8309,8310,8317,8320,8323,8324,8325,8337,8338,8339,8340,8352,8355,8359,8360,8364,8365,8366,8367,8368,8375,8376,8385,8426,8427,8428,8429,8468,8477,8478,8479,8489,8491,8512,8513,8516,8517,8526,8527,8528,8529,8530,8531,8532,8533,8534,8535,8536,8537,8538,8620,8623,8624,8635,8636,8637,8638,8639,8640,8649,8650,8675,8676,8708,8709,8714,8715,8846,8847,8848,8849,8892,8893,8894,8895,8924,8925,8926,8927,8928,8943,8944,8949,8950,8951,8952,8953,8954,8955,8956,8957,8958,8968,8969,8970,8971,8979,8980,8997,8998,8999,9000,9016,9017,9020,9021,9024,9025,9035,9036,9055,9058,9063,9064,9065,9066,9077,9078,9084,9085,9086,9087,9088,9089,9118,9119,9142,9143,9146,9147,9154,9155,9166,9167,9168,9169,9170,9182,9183,9190,9191,9192,9193,9194,9195,9207,9208,9209,9210,9211,9214,9215,9216,9217,9236,9237,9238,9243,9244,9255,9256,9259,9260,9266,9267,9273,9274,9284,9285,9308,9309,9316,9317,9321,9322,9323,9324,9327,9328,9335,9336,9341,9344,9345,9361,9362,9363,9364,9367,9368,9377,9378,9379,9380,9381,9382,9385,9386,9387,9388,9399,9400,9403,9404,9405,9406,9407,9408,9409,9410,9411,9412,9413,9414,9415,9416,9427,9436,9450,9451,9452,9453,9454,9455,9456,9457,9473,9474,9475,9476,9492,9493,9502,9503,9506,9507,9508,9509,9514,9515,9525,9526,9529,9530,9557,9558,9559,9560,9561,9570,9571,9574,9575,9576,9577,9590,9591,9592,9593,9603,9604,9617,9618,9619,9620,9621,9628,9648,9649,9651,9652,9653,9658,9661,9664,9668,9672,9673,9679,9680,9684,9685,9686,9687,9693,9695,9698,9699,9700,9712,9717,9718,9719,9720,9728,9729,9730,9731,9732,9733,9736,9737,9740,9742,9745,9746,9748,9750,9751,9758,9759,9765,9766,9768,9770,9771,9772,9775,9777,9778,9783,9784,9785,9793,9794,9797,9798,9802,9806,9807,9808,9809,9812,9813,9814,9816,9818,9819,9826,9827,9828,9829,9833,9834,9839,9840,9841,9842,9843,9844,9845,9846,9847,9848,9851,9853,9857,9858,9865,9867,9869,9874,9875,9876,9877,9879,9880,9883,9884,9885,9888,9889,9890,9891,9892,9893,9894,9900,9902,9903,9904,9906,9910,9916,9917,9918,9919,9921,9924,9927,9929,9931,9934,9935,9937,9938,9940,9941,9943,9945,9950,9952,9953,9954,9960,9961,9962,9963,9966,9967,9969,9971,9972,9973,9975,9985,9986,9987,9988,9995,10000,10001,10002,10003,10004,10005,10009,10010,10023,10033,10034,10035,10038,10042,10044,10047,10048,10053,10054,10055,10065,10066,10073,10076,10078,10081,10090,10095,10098,10099,10100,10101,10102,10106,10107,10108,10109,10111,10112,10113,10114,10115,10118,10128,10129,10130,10131,10132,10133,10137,10138,10139,10140,10141,10144,10147,10148,10160,10161,10162,10163,10175,10176,10180,10185,10186,10188,10189,10194,10195,10202,10203,10211,10215,10217,10220,10223,10233,10234,10235,10236,10239,10240,10242,10243,10247,10250,10254,10255,10256,10257,10261,10262,10263,10264,10265,10266,10270,10274,10275,10281,10282,10283,10284,10285,10286,10287,10291,10292,10294,10296,10297,10300,10301,10302,10305,10307,10308,10310,10312,10320,10321,10322,10323,10324,10325,10326,10327,10329,10331,10332,10333,10334,10335,10336,10337,10338,10339,10340,10342,10343,10347,10348,10351,10357,10358,10361,10362,10363,10365,10368,10370,10371,10373,10374,10375,10377,10382,10388,10389,10390,10393,10394,10395,10399,10400,10402,10406,10409,10411,10414,10419,10423,10424,10425,10426,10427,10430,10436,10440,10443,10444,10448,10452,10460,10461,10463,10464,10465,10466,10467,10468,10469,10475,10476,10477,10484,10486,10488,10491,10492,10493,10506,10508,10509,10510,10526,10527,10528,10536,10538,10541,10544,10545,10546,10550,10562,10566,10574,10576,10577,10578,10586,10588,10589,10592,10593,10597,10598,10599,10602,10610,10616,10617,10620,10624,10628,10633,10635,10636,10637,10648,10654,10659,10661,10664,10665,10666,10672,10678,10692,10698,10699,10700,10701,10709,10710,10712,10713,10722,10729,10734,10735,10737,10767,10771,10772,10775,10776,10778,10787,10788,10789,10801,10802,10804,10809,10810,10811,10814,10815,10818,10827,10828,10830,10836,10838,10839,10840,10843,10853,10862,10863,10865,10867,10868,10873,10874,10881,10892,10894,10920,10937,10938,10939,10951,10952,10973,10974,11004,11036,11065,11069,11117,11128,11196,11197,11227,11231,11232,11235,11259,11264,11269,11272,11281,11290,11292,11293,11295,11299,11308,11317,11318,11319,11320,11336,11374,11375,11401,11406,11413,11434,11437,11440,11469,11470,11476,11483,11505,11508,11513,11518,11522,11528,11529,11530,11531,11542,11588,11590,11592,11593,11594,11598,11601,11611,11613,11614,11615,11616,11637,11640,11641,11652,11654,11662,11663,11697,11711,11716,11717,11718,11720,11722,11724,11729,11730,11734,11769,11770,11803,11804,11805,11806,11815,11831,11842,11843,11845,11861,11865,11866,11867,11868,11869,11877,11881,11882,11883,11891,11892,11893,11894,11895,11897,11906,11908,11909,11910,11911,11914,11915,11916,11917,11919,11920,11921,11922,11923,11924,11927,11928,11931,11932,11934,11935,11937,11938,11939,11947,11948,11949,11950,11951,11952,11953,11956,11957,11958,11961,11963,11964,11967,11968,11969,11970,11971,11973,11974,11980,11981,11986,11987,11993,11994,12004,12012,12013,12014,12015,12016,12017,12018,12020,12029,12033,12034,12052,12053,12054,12165,12166,12167,12168,12174,12175,12176,14718,14873,14961,15018,15074,16147,16387,16595,17285,17414,17575,17576,17618,17652,17658,17688,17701,17705,17727,17793,17850,17935,17951,17983,18029,18132,18393,18428,18433,18512,18557,18671,18725,18726,18782,18800,18802,18832,18963,18986,18991,19006,19009,19010,19023,19031,19228,19300,19323,19332,19395,19443,19612,19622,19628,19665,19669,19724,19730,19756,19784,19826,19844,19899,19907,19911,19922,19938,19951,19972,19975,20004,20145,20191,20224,20228,20239,20267,20281,20367,20376,20424,20425,20430,20441,20466,20538,20545,20563,20588,20612,20682,20688,20746,20760,20771,20968,20976,21098,21124,21153,21249,21258,21315,21325,21334,21389,21433,21441,21498,21681,21739,21741,21795,21797,21833,21858,21864,21992,22059,22064,22201,22288,22335,22339,22421,22429,22462,22694,23030,23047,23048,23056,23057,23058,23061,23069,23070,23071,23073,23074,23075,23076,23080,23088,23090,23097,23099,23100,23101,23105,23106,23107,23108,23117,23118,23119,23133,23134,23135,23142,23144,23148,23155,23156,23158,23160,23161,23164,23167,23169,23171,23173,23174,23175,23176,23178,23179,23180,23181,23182,23186,23193,23194,23199,23200,23202,23205,23206,23207,23210,23211,23212,23213,23214,23215,23219,23221,23222,23223,23225,23228,23229,23231,23243,23244,23245,23246,23258,23259,23265,23266,23268,23270,23273,23278,23279,23284,23285,23286,23289,23290,23291,23292,23293,23298,23300,23301,23302,23304,23305,23306,23307,23312,23313,23314,23317,23322,23323,23324,23328,23329,23333,23334,23335,23337,23338,23339,23349,23351,23352,23353,23354,23355,23357,23358,23359,23361,23362,23363,23365,23366,23367,23368,23371,23372,23381,23389,23390,23392,23398,23402,23415,23419,23420,23424,23426,23427,23428,23432,23491,23492,23505,23506,23508,23517,23519,23521,23526,23527,23528,23531,23533,23539,23545,23547,23549,23558,23559,23560,23561,23566,23570,23571,23572,23573,23580,23581,23583,23584,23589,23590,23596,23600,23606,23608,23610,23614,23615,23616,23617,23625,23631,23632,23634,23639,23640,23641,23643,23649,23654,23655,23656,23658,23663,23665,23671,23672,23682,23685,23694,23700,23706,23710,23711,23712,23718,23720,23723,23724,23727,23731,23734,23736,23737,23743,23746,23748,23751,23756,23757,23762,23763,23775,23777,23782,23783,23791,23792,23796,23797,23801,23808,23814,23825,23831,23833,23834,23839,23840,23850,23861,23865,23869,23871,23877,23878,23891,23892,23898,23906,23907,23908,23917,23921,23922,23926,23928,23929,23930,23932,23933,23935,23937,23947,23948,23949,23959,23966,23968,23971,23972,23977,23978,23980,23993,23995,23996,24000,24002,24016,24033,24034,24037,24040,24047,24050,24052,24054,24056,24057,24062,24067,24074,24075,24078,24083,24087,24088,24093,24103,24104,24106,24116,24117,24120,24122,24125,24133,24134,24135,24138,24143,24145,24146,24148,24153,24154,24159,24165,24168,24169,24170,24180,24181,24182,24193,24198,24199,24203,24206,24207,24212,24218,24219,24230,24235,24238,24258,24283,24289,24294,24306,24331,24332,24348,24354,24356,24357,24359,24379,24394,24398,24401,24420,24444,24451,24452,24463,24464,24465,24466,24467,24555,24596,24609,24622,24628,24648,24654,24657,24668,24670,24678,24694,24707,24736,24749,24756,24760,24778,24806,24809,24811,24903,24906,24907,24910,24941,24973,24996,25052,25065,25068,25094,25097,25102,25136,25194,25196,25235,25252,25267,25279,25285,25297,25313,25335,25354,25360,25376,25377,25378,25389,25409,25424,25469,25479,25495,25515,25521,25531,25547,25579,25628,25644,25754,25785,25791,25827,25894,25900,25951,25958,25964,26044,26119,26120,26153,26188,26246,26282,26308,26339,26350,26363,26364,26382,26384,26401,26416,26433,26442,26485,26486,26583,26585,26587,26608,26684,26685,26686,26730,26731,26732,26867,26918,26919,26963,26965,27012,27026,27067,27139,27153,27188,27216,27225,27242,27280,27318,27350,27408,27411,27425,27427,27575,27583,27589,27614,27615,27625,27683,27713,27730,27732,27733,27749,27786,27820,27821,27823,27826,27829,27836,27866,27867,27868,27870,27885,27888,27891,27895,27907,27908,27911,27915,27916,27917,27919,27920,27925,27927,27929,27930,27931,27937,27943,27948,27965,27979,27986,27987,27998,27999,28001,28003,28004,28007,28015,28016,28017,28021,28034,28039,28055,28057,28098,28099,28104,28117,28118,28132,28134,28136,28143,28182,28200,28205,28206,28213,28225,28226,28242,28261,28263,28265,28287,28292,28319,28339,28354,28367,28372,28401,28409,28414,28420,28422,28434,28435,28481,28482,28500,28502,28503,28506,28530,28532,28550,28568,28578,28597,28606,28616,28623,28637,28640,28641,28646,28688,28707,28711,28727,28745,28756,28758,28805,28807,28808,28856,28865,28872,28883,28903,28904,28905,28957,28979,28982,29018,29021,29053,29079,29088,29089,29090,29112,29114,29121,29122,29134,29146,29201,29225,29229,29286,29300,29311,29314,29315,29317,29336,29337,29371,29374,29390,29394,29421,29432,29433,29436,29470,29570,29583,29597,29623,29648,29657,29659,29667,29683,29693,29699,29766,29771,29777,29823,29932,30025,30313,30316,30317,30318,30401,30404,30772,31052,31129,31237,31278,31457,31529,31608,31699,31732,31752,31827,31831,31832,31841,31871,31900,31930,31932,31940,31967,31981,32002,32054,32116,32122,32287,32379,32399,32455,32479,32513,32561,32564,32581,32594,32650,32708,32770,32797,32881,32912,32918,32935,32946,32955,32969,33015,33016,33035,33069,33085,33107,33109,33131,33151,33176,33200,33213,33214,33219,33225,33232,33245,33260,33281,33307,33312,33401,33404,33422,33423,33424,33431,33432,33439,33445,33460,33470,33495,33533,33534,33550,33586,33594,33619,33628,33633,33655,33661,33675,33696,33697,33698,33699,33723,33761,33834,33837,33846,33859,33862,33869,33870,33884,33885,33886,33910,33948,33956,33963,33967,33969,33984,34037,34039,34075,34096,34100,34110,34113,34127,34129,34141,34142,34144,34150,34156,34165,34175,34190,34201,34228,34229,34256,34268,34311,34312,34328,34329,34339,34382,34384,34385,34409,34446,34456,34457,34516,34529,34536,34540,34548,34551,34557,34558,34565,34567,34568,34571,34572,34577,34609,34619,34665,34696,34757,34806,34836,34856,34859,34862,34896,34906,35004,35005,35006,35019,35020,35027,35030,35031,35049,35545,35722,36079,36117,36304,36430,37487)
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 | 1989 | 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 |