Tiempo de la consulta: 4.96 ms Después de la última consulta: 1.03 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.366 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 18:19:11')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 18:19:11')
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,61,132,213,247,262,263,282,308,311,321,323,324,334,354,376,385,452,456,459,474,489,495,497,565,583,605,622,633,639,644,668,669,670,672,679,681,701,769,771,776,780,796,797,802,805,808,827,831,858,861,864,870,883,885,889,897,905,924,928,955,983,1021,1033,1040,1050,1061,1062,1065,1087,1130,1169,1183,1185,1196,1205,1207,1231,1236,1248,1252,1253,1277,1330,1402,1422,1491,1503,1563,1594,1612,1623,1679,1683,1685,1712,1713,1717,1744,1766,1770,1784,1796,1849,1917,1924,1944,1949,1964,1982,1999,2010,2013,2047,2102,2109,2146,2150,2208,2224,2284,2302,2367,2372,2394,2415,2433,2466,2633,2705,2739,2756,2788,2797,2859,2875,2933,2961,2964,2967,2993,3000,3065,3071,3082,3085,3099,3108,3125,3236,3251,3259,3264,3271,3288,3299,3420,3425,3480,3495,3511,3543,3641,3664,3743,3819,3825,3832,3869,3871,3873,3932,3963,3975,3988,4035,4082,4132,4133,4211,4253,4292,4339,4355,4434,4487,4502,4503,4516,4560,4583,4670,4710,4780,4801,4817,4854,4868,4872,4901,4910,5063,5085,5136,5183,5190,5206,5227,5300,5328,5363,5457,5529,5570,5575,5615,5632,5646,5647,5648,5680,5694,5784,5798,5811,5830,5895,5904,5929,5994,6021,6037,6038,6068,6150,6158,6201,6256,6275,6331,6339,6440,6448,6470,6473,6475,6498,6501,6516,6537,6546,6548,6577,6616,6669,6688,6735,6799,6834,6845,6857,6884,6891,6897,6908,6913,6960,6988,7012,7014,7053,7054,7081,7105,7172,7175,7196,7273,7283,7290,7295,7343,7348,7357,7366,7374,7430,7432,7441,7442,7443,7451,7461,7476,7492,7528,7551,7567,7580,7591,7595,7615,7633,7644,7674,7680,7704,7722,7744,7751,7797,7848,7965,7980,7981,7996,7997,8002,8022,8027,8148,8161,8177,8188,8222,8258,8296,8297,8304,8325,8328,8387,8390,8413,8416,8417,8437,8480,8492,8505,8506,8532,8603,8613,8663,8692,8706,8716,8819,8852,8911,8941,9004,9011,9063,9125,9155,9193,9199,9252,9284,9320,9323,9339,9370,9501,9525,9552,9573,9620,9626,9629,9648,9677,9708,9766,9767,9831,9840,9848,9889,9894,10129,10263,10278,10298,10354,10364,10449,10494,10668,10818,10900,10942,10967,10968,11062,11114,11147,11198,11397,11410,11417,11542,11581,11625,11672,11685,11704,11709,11921,12024,12084,12162,12168,12201,12274,12297,12387,12388,12410,12437,12439,12443,12477,12482,12509,12537,12567,12599,12663,12686,12714,12786,12803,12815,12816,12892,12902,12913,12926,12963,12986,13006,13014,13018,13061,13068,13079,13152,13154,13190,13209,13269,13276,13279,13297,13317,13420,13436,13479,13488,13579,13589,13612,13645,13646,13672,13722,13729,13782,13813,13926,13929,13950,13959,13997,14014,14057,14061,14098,14100,14132,14134,14139,14186,14197,14232,14278,14289,14290,14301,14302,14324,14368,14395,14417,14426,14433,14487,14508,14516,14548,14601,14620,14630,14665,14674,14684,14688,14690,14761,14769,14800,14809,14816,14884,14890,14905,14906,14927,14930,15038,15059,15079,15223,15224,15227,15245,15250,15261,15323,15392,15430,15445,15450,15456,15458,15464,15484,15489,15530,15563,15566,15583,15601,15615,15632,15670,15706,15763,15774,15884,15909,15913,15916,15917,15999,16108,16192,16206,16311,16313,16323,16328,16465,16505,16555,16571,16589,16591,16620,16642,16698,16712,16717,16739,16843,16863,16880,16891,16928,16940,16968,17008,17064,17071,17087,17089,17116,17132,17138,17169,17185,17188,17209,17232,17248,17263,17287,17288,17299,17300,17303,17343,17363,17450,17513,17580,17598,17611,17622,17644,17748,17751,17752,17753,17759,17782,17786,17788,17808,17812,17824,17876,17907,17908,17943,17954,17978,17981,18003,18004,18007,18019,18027,18068,18072,18076,18091,18141,18203,18231,18235,18304,18311,18359,18415,18447,18450,18463,18467,18498,18499,18507,18534,18542,18564,18587,18602,18611,18619,18622,18644,18647,18676,18778,18800,18801,18835,18879,18880,18912,18927,18931,18934,18944,18946,18980,18982,18997,19003,19048,19049,19050,19093,19096,19110,19125,19180,19184,19196,19216,19218,19265,19276,19291,19302,19303,19316,19331,19340,19348,19364,19383,19448,19473,19481,19507,19514,19518,19541,19545,19556,19565,19572,19575,19580,19586,19587,19606,19655,19660,19665,19712,19716,19718,19720,19733,19741,19755,19778,19779,19790,19805,19811,19826,19864,19921,19942,19952,19973,19983,20002,20048,20073,20076,20088,20113,20117,20154,20155,20182,20204,20208,20209,20215,20251,20258,20278,20303,20315,20329,20352,20366,20384,20393,20413,20458,20468,20510,20515,20559,20570,20571,20585,20619,20630,20761,20876,20935,20948,20976,20977,20991,20996,21008,21015,21035,21042,21064,21068,21078,21081,21089,21129,21136,21180,21200,21205,21210,21235,21266,21268,21275,21289,21291,21302,21335,21341,21353,21354,21361,21392,21408,21412,21415,21421,21429,21440,21447,21465,21469,21520,21524,21528,21571,21583,21589,21594,21603,21604,21632,21647,21652,21681,21702,21711,21729,21770,21781,21782,21790,21862,21908,21930,21986,21987,22015,22036,22055,22058,22074,22118,22129,22159,22177,22191,22207,22260,22321,22327,22342,22367,22393,22398,22428,22438,22442,22502,22520,22594,22596,22621,22623,22645,22752,22754,22788,22804,22830,22922,22927,22932,22934,22962,22967,22977,23004,23015,23027,23032,23084,23090,23102,23104,23123,23136,23166,23174,23196,23215,23295,23301,23318,23365,23411,23412,23481,23495,23503,23505,23531,23548,23590,23622,23633,23634,23645,23652,23695,23725,23739,23815,23866,23869,23880,23894,23944,23958,23995,24002,24004,24068,24115,24134,24137,24154,24189,24202,24263,24315,24330,24365,24391,24438,24442,24447,24460,24465,24505,24511,24518,24555,24623,24708,24719,24725,24775,24780,24793,24806,24843,24862,24882,24957,24986,24998,25033,25048,25061,25064,25099,25134,25271,25314,25316,25379,25409,25471,25595,25648,25706,25735,25740,25742,25746,25749,25768,25770,25782,25788,25936,25967,26017,26053,26056,26092,26101,26104,26140,26165,26197,26221,26246,26323,26324,26374,26395,26398,26408,26409,26412,26516,26541,26548,26575,26577,26601,26612,26629,26637,26664,26672,26684,26715,26716,26760,26801,26848,26909,26919,26941,26954,26955,27024,27083,27087,27104,27105,27136,27161,27167,27184,27213,27466,27488,27584,27611,27630,27646,27688,27737,27892,28157,28169,28275,28925,29213,29379,29436,29553,29584,31663,32078,32973,33547,34963,35530,35638,35710,35812,36178,36279,36310,36428,37155,37333,37497,37535,37536,37537,37549,37550,37551,38382,38436,38646,38689,38786,38816,38817,38833,38845,38897,38917,38932,38987,39067,39474,39527,39588,39614,39645,39820,39972,40048,40688,40877,41319,41339,41363,42030,42066,42237,42407,42540,43358,43637,44091,44317,45029,45231)
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 | 1123 | 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.56 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.21 ms |
System lock | 0.02 ms |
optimizing | 0.09 ms |
statistics | 2.03 ms |
preparing | 0.89 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.42 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.09 ms |
cleaning up | 0.10 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 |