Tiempo de la consulta: 3.92 ms Después de la última consulta: 0.75 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.459 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-08 09:32:49')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-08 09:32:49')
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(4,9,11,25,28,56,72,86,101,112,138,141,165,255,263,271,275,276,332,373,391,463,472,493,501,516,522,523,583,607,611,613,686,723,757,758,826,828,841,868,883,895,900,917,953,958,963,986,996,1031,1075,1133,1207,1271,1291,1323,1587,1718,2107,2272,2290,2293,2305,2365,2610,2639,2796,2863,2925,3209,3353,3354,3476,3509,3512,3604,3986,4268,4549,4580,4680,4698,4878,4901,4902,5150,5160,5192,5313,5350,5365,5451,5647,5666,5675,5730,5846,5894,5896,6127,6257,6389,6405,6470,6473,6475,6478,6498,6520,6531,6539,6542,6543,6557,6573,6574,6575,6630,6656,6688,6723,6730,6742,6744,6799,6802,6835,6860,6889,6895,6906,6936,6942,6965,6985,7014,7015,7052,7069,7124,7156,7200,7232,7244,7336,7339,7340,7343,7344,7411,7420,7421,7450,7483,7545,7556,7586,7588,7621,7624,7719,7725,7730,7749,7751,7776,7799,7829,7831,7832,7837,7850,7866,7889,7934,7950,7959,7997,8027,8089,8093,8109,8143,8190,8258,8259,8354,8377,8386,8417,8508,8566,8580,8617,8754,8759,8860,8909,9355,9552,9750,9801,9924,9956,10030,10100,10110,10114,10162,10176,10203,10250,10274,10306,10311,10316,10572,10697,10868,10872,10951,10954,10974,11015,11030,11057,11063,11066,11083,11173,11194,11226,11250,11253,11299,11327,11394,11408,11440,11441,11479,11534,11712,11714,11766,11857,11883,11987,12011,12212,12306,12318,12449,12510,12545,12620,12624,12625,12628,12670,12685,12686,12708,12789,12811,12894,12945,12973,13010,13067,13157,13224,13225,13239,13241,13246,13253,13349,13408,13452,13487,13508,13611,13851,13855,13863,13900,13963,13968,13972,13998,14048,14097,14114,14153,14183,14192,14205,14224,14236,14240,14263,14267,14293,14361,14385,14507,14516,14591,14596,14601,14684,14708,14754,14795,14811,14856,14935,14992,15038,15039,15055,15080,15108,15147,15217,15304,15310,15347,15378,15440,15486,15493,15551,15632,15639,15712,15714,15757,15866,15899,15903,15904,15952,15953,16038,16089,16101,16156,16200,16216,16267,16297,16303,16313,16366,16390,16415,16430,16431,16432,16497,16538,16585,16609,16645,16714,16775,16780,16813,16863,16866,16928,16996,17038,17039,17116,17126,17142,17148,17209,17227,17228,17234,17242,17275,17282,17285,17343,17344,17363,17381,17405,17407,17422,17496,17510,17573,17627,17634,17661,17699,17710,17734,17766,17812,17852,17889,17925,17950,18052,18121,18181,18187,18229,18249,18260,18276,18294,18311,18316,18318,18362,18419,18421,18429,18452,18468,18494,18498,18505,18509,18552,18556,18588,18605,18652,18668,18670,18675,18682,18698,18730,18750,18801,18807,18816,18826,18845,18846,18856,18864,18874,18904,18945,18948,18953,18988,18989,19007,19018,19024,19026,19027,19040,19051,19056,19059,19064,19133,19135,19145,19175,19189,19207,19217,19226,19260,19261,19282,19288,19292,19303,19322,19349,19364,19370,19427,19437,19444,19467,19484,19516,19527,19650,19655,19659,19727,19857,19873,19883,19929,19940,19950,19962,19972,19976,19980,20006,20010,20020,20024,20033,20039,20043,20056,20089,20099,20115,20127,20149,20174,20220,20234,20237,20254,20256,20317,20356,20394,20397,20402,20426,20437,20539,20549,20559,20587,20654,20668,20677,20681,20686,20711,20714,20739,20785,20797,20823,20837,20866,20897,20944,20946,20947,20973,20993,21007,21049,21087,21094,21095,21113,21118,21135,21194,21216,21294,21346,21368,21380,21384,21390,21400,21420,21422,21491,21520,21579,21583,21614,21664,21667,21692,21701,21711,21727,21732,21798,21836,21846,21852,21907,21950,21998,22015,22020,22030,22035,22038,22062,22081,22098,22117,22124,22140,22149,22150,22164,22171,22177,22212,22222,22225,22228,22290,22324,22351,22359,22382,22389,22404,22415,22416,22502,22523,22527,22543,22651,22672,22698,22706,22753,22804,22841,22854,22898,22901,22919,22985,23014,23028,23041,23046,23053,23070,23072,23089,23148,23181,23253,23267,23294,23299,23304,23305,23328,23357,23363,23369,23383,23401,23423,23488,23501,23555,23566,23585,23615,23633,23668,23730,23732,23759,23790,23816,23838,23882,23926,23965,23978,23990,24024,24060,24112,24118,24127,24147,24155,24164,24186,24193,24219,24248,24356,24403,24411,24433,24440,24456,24480,24523,24557,24573,24580,24597,24615,24616,24701,24710,24732,24748,24785,24830,24841,24910,24941,25007,25048,25062,25079,25080,25099,25100,25170,25184,25278,25287,25315,25386,25411,25420,25428,25452,25463,25498,25535,25548,25560,25561,25584,25591,25640,25657,25694,25888,25934,25949,25954,25990,26043,26102,26161,26221,26239,26360,26431,26483,26488,26519,26525,26606,26651,26901,26947,27041,27074,27189,27364,27397,27407,27454,27471,27518,27541,27624,27628,27743,27846,28046,28240,28328,28616,28739,28799,28928,28944,29331,29389,29473,29500,29590,29937,30284,30482,30656,31010,31623,31624,38961,39063,39088,39158,39269,39323,39370,39411,39513,39625,40104,40347,40401,40404,41236,41253,41254,41363)
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 | 817 | 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.47 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.18 ms |
System lock | 0.02 ms |
optimizing | 0.08 ms |
statistics | 1.34 ms |
preparing | 0.61 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.41 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.04 ms |
freeing items | 0.06 ms |
cleaning up | 0.03 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 |