Tiempo de la consulta: 3.68 ms Después de la última consulta: 0.58 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.304 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-06 03:52:15')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 03:52:15')
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(72,138,141,332,373,522,523,583,723,757,826,828,840,841,986,996,1121,1133,1207,1280,1323,1397,1464,1525,1587,1803,1827,2014,2048,2107,2272,2396,2610,2719,2836,2925,3353,3354,3476,3606,4637,4680,4698,5160,5192,5313,5649,5666,5730,5846,5894,5896,6136,6166,6389,6470,6498,6531,6539,6557,6575,6688,6730,6771,6799,6802,6942,6965,7014,7024,7052,7069,7124,7156,7200,7244,7336,7339,7340,7411,7420,7421,7450,7487,7556,7588,7621,7624,7719,7725,7751,7776,7799,7831,7837,7850,7866,7889,7933,8089,8168,8201,8258,8259,8353,8354,8372,8377,8386,8417,8444,8448,8533,8553,8566,8580,8617,8759,8860,8909,8912,9552,9629,9635,9713,9750,9801,9875,9924,9956,9996,10002,10030,10062,10114,10159,10162,10274,10316,10434,10440,10483,10493,10755,10764,10868,10938,11030,11057,11161,11194,11250,11253,11299,11365,11408,11440,11441,11714,11739,11750,11815,11857,12011,12183,12197,12256,12318,12500,12520,12620,12624,12628,12645,12650,12669,12670,12677,12685,12686,12708,12790,12811,12973,13067,13224,13239,13246,13325,13335,13349,13452,13644,13851,13900,13975,14094,14095,14103,14153,14192,14224,14263,14267,14293,14352,14385,14516,14591,14601,14642,14643,14708,14725,14754,14795,14935,14992,14993,15039,15045,15055,15080,15108,15147,15217,15227,15299,15347,15378,15400,15440,15471,15486,15493,15632,15639,15667,15675,15712,15714,15753,15759,15785,15796,15813,15820,15844,15855,15888,15899,15904,15952,15953,15994,16038,16089,16092,16155,16156,16186,16200,16213,16216,16230,16267,16297,16303,16313,16390,16430,16496,16497,16537,16540,16609,16628,16714,16780,16813,16863,16866,16876,16908,16928,17038,17039,17109,17116,17126,17142,17148,17166,17198,17209,17234,17275,17282,17317,17344,17363,17381,17405,17422,17496,17573,17627,17630,17652,17661,17699,17710,17734,17812,17881,17889,17909,17949,18096,18106,18125,18161,18181,18187,18209,18229,18249,18258,18260,18270,18288,18316,18318,18362,18419,18421,18429,18452,18458,18494,18498,18509,18537,18552,18556,18588,18605,18652,18675,18750,18801,18807,18816,18826,18845,18856,18864,18904,18945,18953,18988,18989,19007,19024,19027,19040,19056,19059,19130,19135,19145,19160,19189,19190,19217,19226,19234,19235,19259,19260,19261,19282,19292,19303,19364,19370,19427,19437,19527,19583,19627,19636,19655,19659,19857,19873,19877,19883,19888,19929,19940,19950,19962,19972,19980,20006,20010,20020,20024,20033,20039,20043,20056,20115,20120,20147,20169,20234,20237,20254,20343,20356,20394,20402,20426,20451,20539,20559,20677,20681,20823,20837,20866,20946,20947,20987,21007,21013,21049,21087,21094,21095,21118,21122,21134,21135,21194,21255,21294,21368,21380,21384,21390,21422,21425,21449,21491,21520,21583,21614,21664,21665,21670,21692,21701,21711,21727,21732,21836,21907,21950,21967,21998,22015,22020,22030,22035,22062,22081,22117,22140,22149,22164,22177,22191,22208,22218,22221,22222,22225,22228,22324,22351,22359,22382,22404,22415,22416,22445,22484,22502,22543,22651,22654,22698,22768,22795,22804,22841,22885,22889,22898,22909,22985,23001,23014,23028,23053,23072,23089,23181,23294,23299,23304,23328,23359,23369,23371,23401,23458,23486,23532,23600,23615,23627,23633,23668,23732,23757,23768,23882,23965,24025,24060,24112,24127,24155,24164,24184,24248,24356,24481,24514,24523,24573,24580,24615,24636,24710,24785,25007,25062,25079,25098,25099,25100,25170,25176,25184,25278,25315,25411,25420,25428,25463,25498,25520,25532,25538,25584,25640,25694,25781,25870,25954,26010,26221,26239,26260,26360,26391,26431,26651,26762,26791,26828,26947,26963,27109,27189,27223,27238,27364,27403,27434,27454,27473,27518,27541,27551,27622,27624,27628,27655,27743,27846,27992,28046,28087,28091,28193,28240,28241,28328,28616,28944,29010,29063,29389,29590,29714,29720,29746,29920,30482,30656,31623,31624,32642,32643,35941,36750,37851,38810,39370,39411,39625,39806,40401,40404,40415,40417,40482,40625,40655,40878,41363,42035,42288)
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 | 659 | 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.35 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.15 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 1.09 ms |
preparing | 0.53 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.46 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.03 ms |
freeing items | 0.03 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 |