Tiempo de la consulta: 5.35 ms Después de la última consulta: 1.33 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.400 MB Filas devueltas: 5
SELECT i.*, c.alias AS categoryalias
FROM av04h_k2_items AS i
LEFT JOIN av04h_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-05-04 23:34:03')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 23:34:03')
AND i.access IN(1,1,2,3,5)
AND c.access IN(1,1,2,3,5)
AND c.published = 1
AND c.trash = 0
AND i.id IN(35,71,76,119,132,133,165,185,192,247,255,271,272,282,283,321,324,334,354,390,400,403,412,429,495,505,507,538,565,657,668,669,679,689,690,701,722,769,780,795,805,808,832,844,863,868,870,883,885,897,914,937,940,942,1034,1036,1050,1061,1069,1101,1102,1125,1130,1169,1183,1193,1196,1207,1216,1233,1236,1250,1277,1285,1330,1414,1458,1459,1469,1492,1497,1503,1514,1521,1591,1645,1684,1713,1735,1745,1766,1771,1887,1944,1949,1955,1962,1975,1978,1982,2010,2016,2069,2089,2101,2109,2146,2200,2224,2254,2367,2372,2394,2415,2448,2451,2517,2569,2605,2663,2674,2705,2756,2797,2804,2859,2933,2946,2951,2958,2961,2967,2993,3000,3001,3065,3071,3099,3108,3114,3125,3154,3183,3195,3208,3227,3236,3249,3264,3288,3303,3312,3343,3346,3408,3409,3425,3444,3493,3511,3569,3597,3604,3651,3749,3750,3754,3825,3832,3871,3898,3910,3932,3975,3983,3984,4132,4133,4253,4301,4339,4353,4381,4383,4410,4492,4503,4516,4583,4622,4626,4667,4670,4710,4726,4732,4750,4790,4810,4817,4868,4872,4910,5076,5078,5079,5085,5093,5095,5123,5221,5348,5414,5424,5457,5464,5507,5508,5513,5570,5584,5615,5647,5680,5700,5798,6037,6038,6049,6058,6102,6139,6148,6150,6251,6256,6301,6309,6315,6331,6345,6353,6354,6363,6370,6372,6400,6448,6469,6470,6473,6475,6492,6516,6532,6539,6542,6543,6546,6557,6577,6593,6614,6616,6618,6664,6669,6670,6671,6699,6710,6799,6807,6808,6824,6840,6845,6913,6964,6997,7014,7018,7026,7062,7081,7105,7107,7156,7248,7283,7338,7343,7451,7461,7528,7551,7567,7569,7583,7596,7615,7630,7674,7722,7744,7749,7795,7848,7913,7914,7917,7965,7981,8022,8027,8076,8080,8088,8089,8177,8206,8222,8258,8290,8293,8297,8326,8327,8373,8404,8405,8416,8480,8530,8532,8551,8577,8603,8613,8654,8663,8674,8692,8706,8740,8784,8819,8859,8907,8908,8937,8943,9028,9048,9056,9057,9075,9082,9115,9152,9200,9284,9314,9339,9369,9544,9552,9626,9629,9658,9756,9764,9766,9825,9849,9857,9860,9894,10006,10008,10059,10090,10091,10195,10198,10273,10354,10355,10462,10484,10658,10668,10689,10840,10890,10947,10973,11022,11062,11064,11114,11138,11195,11207,11318,11330,11351,11369,11410,11417,11471,11494,11531,11532,11533,11534,11557,11618,11621,11625,11693,11697,11727,11834,11841,11854,11930,11937,11965,12017,12024,12138,12141,12152,12162,12189,12205,12207,12244,12270,12297,12333,12388,12430,12437,12443,12477,12479,12531,12535,12599,12628,12686,12704,12727,12786,12802,12816,12942,12954,12963,12974,13006,13018,13025,13029,13048,13061,13086,13112,13129,13152,13154,13166,13188,13190,13220,13269,13276,13279,13363,13420,13477,13488,13524,13530,13548,13550,13553,13567,13573,13589,13637,13641,13645,13646,13672,13678,13707,13712,13744,13763,13778,13782,13798,13821,13855,13926,13929,13950,13974,13980,14016,14057,14061,14081,14100,14105,14139,14148,14159,14186,14188,14197,14232,14290,14308,14323,14324,14338,14348,14374,14426,14428,14449,14477,14516,14601,14602,14636,14665,14668,14675,14684,14705,14711,14752,14761,14769,14789,14795,14856,14860,14876,14890,14905,15018,15038,15049,15059,15074,15079,15227,15245,15246,15248,15300,15323,15382,15392,15464,15489,15496,15530,15531,15546,15572,15589,15606,15615,15625,15632,15719,15760,15834,15884,15896,15897,15904,15943,15992,16014,16051,16108,16156,16178,16192,16206,16216,16218,16246,16269,16321,16325,16361,16387,16390,16398,16432,16444,16465,16468,16507,16521,16529,16538,16546,16571,16591,16596,16603,16604,16640,16642,16698,16700,16713,16717,16718,16733,16734,16739,16808,16829,16850,16880,16892,16928,16977,17043,17071,17086,17087,17100,17116,17134,17135,17138,17148,17157,17178,17189,17197,17202,17263,17299,17300,17303,17309,17338,17349,17493,17592,17598,17617,17645,17695,17737,17748,17753,17759,17775,17786,17811,17812,17824,17835,17842,17870,17883,17907,17908,17938,17954,18003,18043,18070,18072,18078,18091,18112,18113,18129,18130,18140,18142,18166,18249,18286,18290,18292,18295,18304,18311,18326,18358,18407,18409,18431,18452,18456,18457,18467,18485,18498,18521,18534,18535,18619,18622,18669,18703,18717,18738,18763,18772,18781,18799,18826,18833,18835,18867,18879,18880,18893,18912,18927,18934,18944,18996,18997,19003,19046,19048,19049,19086,19088,19126,19133,19180,19217,19223,19241,19258,19276,19291,19303,19308,19348,19364,19448,19482,19507,19514,19518,19532,19541,19554,19556,19572,19575,19649,19653,19655,19660,19693,19720,19729,19733,19776,19779,19790,19811,19823,19828,19855,19870,19871,19873,19921,19983,20002,20046,20048,20055,20073,20076,20082,20088,20159,20163,20198,20230,20258,20311,20315,20322,20323,20329,20394,20402,20408,20413,20422,20438,20452,20453,20456,20458,20468,20471,20503,20515,20533,20559,20564,20571,20579,20604,20630,20652,20677,20698,20757,20761,20774,20840,20860,20905,20911,20915,20976,20977,20981,20993,21044,21060,21089,21112,21129,21136,21145,21162,21165,21180,21227,21256,21266,21275,21284,21289,21304,21309,21333,21335,21341,21347,21353,21369,21392,21397,21405,21415,21421,21429,21440,21447,21480,21482,21517,21520,21523,21524,21567,21569,21571,21606,21619,21622,21681,21702,21704,21711,21732,21750,21794,21801,21803,21815,21822,21830,21834,21840,21846,21869,21900,21922,21926,21941,21962,21987,22026,22040,22057,22097,22118,22129,22154,22180,22191,22200,22202,22207,22224,22229,22234,22270,22276,22296,22342,22351,22367,22373,22385,22414,22422,22442,22489,22502,22517,22565,22596,22607,22611,22645,22692,22720,22754,22774,22784,22788,22802,22804,22818,22830,22848,22889,22926,22934,22960,22977,22992,23014,23015,23016,23019,23035,23040,23104,23123,23145,23147,23151,23156,23178,23198,23245,23247,23295,23318,23325,23332,23343,23365,23372,23388,23399,23453,23454,23474,23485,23492,23495,23505,23513,23566,23570,23574,23622,23647,23648,23654,23676,23695,23725,23739,23749,23807,23815,23828,23833,23869,23880,23935,23948,23949,23995,23998,24068,24115,24119,24152,24172,24189,24192,24202,24216,24224,24228,24242,24263,24271,24277,24288,24309,24312,24315,24342,24365,24383,24398,24427,24438,24440,24443,24450,24451,24460,24462,24465,24477,24479,24498,24510,24511,24529,24535,24555,24601,24617,24625,24630,24636,24643,24685,24705,24747,24763,24775,24780,24806,24826,24851,24891,24957,24995,24998,25018,25033,25064,25090,25099,25110,25133,25134,25222,25286,25314,25316,25334,25398,25400,25408,25413,25471,25511,25595,25631,25707,25736,25740,25746,25770,25787,25801,25816,25860,25881,25885,25940,25964,25968,26002,26017,26034,26053,26056,26061,26091,26092,26101,26104,26123,26130,26165,26195,26202,26211,26221,26246,26261,26262,26264,26319,26373,26374,26378,26395,26396,26403,26408,26409,26410,26412,26439,26458,26471,26516,26534,26536,26541,26550,26570,26575,26601,26627,26629,26630,26637,26640,26664,26672,26679,26684,26715,26716,26758,26760,26763,26766,26770,26792,26801,26831,26848,26866,26907,26941,26955,26992,27024,27039,27071,27083,27105,27106,27136,27138,27144,27161,27167,27178,27179,27189,27201,27203,27228,27265,27322,27337,27343,27360,27409,27466,27475,27491,27513,27548,27549,27646,27688,27737,27800,27974,28230,28779,29033,29107,29187,29200,29213,29366,29379,29436,29464,29511,29584,29626,30242,30279,30293,30331,30393,30394,30511,30609,30854,31773,32056,32241,33106,33621,33950,34052,34415,34449,34524,34525,34560,34584,34701,34733,34758,34927,34963,34978,35192,35259,35305,35321,35324,35436,35503,35530,35596,35609,35626,35638,35710,35718,35790,35812,35836,35859,35878,35953,35958,36011,36014,36104,36192,36197,36204,36238,36279,36310,36335,36423,36428,36515,36736,36850,36894,37025,37155,37497,37724,38157,38263,38382,38658,38659,38660,38662,38689,38779,38784,38786,38788,38815,38816,38817,38818,38865,38905,38932,38962,39078,39114,39196,39226,39296,39527,39588,39673,39699,39729,39808,39820,39823,39846,39855,40048,40111,40187,40212,40225,40239,40276,40392,40521,40665,40688,40812,40831,40877,40886,40954,40983,41059,41146,41254,41339,41594,41938,42074,42262,42540,42880,43358,43501,43905,44255,44317,44433,44853,45191,45231,45251)
ORDER BY i.id DESC
LIMIT 0, 5
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | i | NULL | range | PRIMARY,item,catid | PRIMARY | 4 | NULL | 1369 | 1.00 | Using where |
1 | SIMPLE | c | NULL | eq_ref | PRIMARY,category,published,access,trash | PRIMARY | 4 | cms_domad_francisca.i.catid | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.66 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.29 ms |
System lock | 0.02 ms |
optimizing | 0.09 ms |
statistics | 2.19 ms |
preparing | 1.10 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.33 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.06 ms |
cleaning up | 0.02 ms |
# | Comunicador | Archivo y número de línea |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/itemlist.php:668 |
13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:278 |
12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:78 |
8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |