Tiempo de la consulta: 3.53 ms Después de la última consulta: 0.71 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 4.313 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-05 13:03:35')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 13:03:35')
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(2,49,58,72,111,138,141,204,234,293,332,373,420,437,447,495,522,583,605,607,639,644,645,653,701,719,721,723,757,777,826,828,836,841,862,912,944,986,996,1133,1173,1207,1236,1323,1463,1587,1643,1725,1893,2107,2144,2150,2163,2164,2169,2195,2199,2202,2204,2210,2213,2217,2227,2234,2237,2242,2245,2256,2272,2273,2286,2299,2346,2348,2386,2398,2610,2925,3049,3113,3158,3286,3353,3354,3476,3750,3852,3886,3999,4145,4186,4188,4195,4197,4220,4221,4229,4241,4242,4266,4313,4680,4698,4803,4973,5160,5192,5313,5437,5484,5533,5560,5666,5730,5846,5894,5896,6294,6389,6405,6470,6498,6531,6539,6575,6684,6688,6730,6799,6802,6934,6942,6948,6965,7014,7052,7069,7124,7156,7200,7244,7329,7336,7339,7340,7411,7420,7421,7450,7556,7588,7621,7624,7719,7722,7725,7751,7776,7799,7806,7831,7837,7850,7866,7889,7997,8089,8192,8250,8258,8259,8354,8377,8386,8417,8441,8499,8508,8566,8580,8617,8759,8860,8909,9045,9249,9264,9299,9318,9333,9414,9428,9438,9451,9543,9552,9750,9784,9801,9924,9956,10030,10114,10162,10238,10274,10316,10366,10484,10562,10868,11030,11057,11194,11242,11250,11253,11299,11408,11440,11441,11691,11711,11714,11857,12011,12228,12318,12374,12620,12624,12628,12670,12685,12686,12708,12761,12808,12811,12973,13224,13239,13246,13349,13452,13851,13900,14153,14192,14224,14263,14267,14385,14432,14516,14526,14591,14601,14708,14754,14795,14992,15030,15055,15061,15080,15108,15147,15217,15347,15378,15440,15486,15493,15619,15632,15639,15712,15714,15899,15904,15952,15953,16038,16089,16156,16200,16216,16232,16250,16267,16297,16303,16313,16366,16390,16430,16453,16476,16497,16547,16609,16675,16714,16728,16780,16813,16863,16866,16928,17038,17039,17116,17126,17142,17148,17209,17222,17234,17275,17282,17344,17363,17381,17405,17422,17496,17573,17596,17615,17616,17627,17633,17661,17666,17688,17699,17710,17712,17734,17812,17889,18181,18187,18229,18249,18260,18316,18318,18362,18419,18421,18429,18452,18494,18498,18509,18552,18556,18588,18605,18652,18675,18750,18801,18807,18816,18826,18845,18856,18862,18864,18904,18945,18953,18988,18989,18997,19007,19021,19024,19027,19040,19056,19059,19077,19135,19145,19189,19217,19226,19260,19261,19282,19292,19303,19364,19370,19419,19427,19437,19442,19443,19453,19527,19635,19655,19659,19733,19857,19873,19883,19940,19944,19950,19972,19980,20006,20010,20020,20024,20033,20039,20043,20056,20083,20115,20234,20237,20254,20333,20356,20394,20402,20426,20539,20542,20559,20563,20587,20609,20677,20681,20823,20837,20866,20946,20947,21007,21049,21087,21094,21095,21118,21128,21135,21194,21294,21350,21368,21380,21384,21390,21398,21422,21491,21520,21583,21655,21664,21692,21693,21701,21711,21727,21732,21798,21831,21836,21878,21904,21907,21998,22015,22020,22030,22035,22062,22081,22088,22117,22126,22140,22149,22159,22164,22177,22222,22225,22228,22324,22336,22351,22359,22382,22395,22396,22404,22415,22416,22502,22543,22622,22651,22698,22711,22752,22804,22820,22841,22898,22913,22919,22935,22974,22985,23014,23028,23053,23072,23089,23181,23242,23279,23294,23299,23304,23328,23367,23369,23401,23438,23458,23527,23615,23616,23633,23668,23709,23716,23719,23721,23732,23949,23965,24025,24060,24127,24155,24164,24178,24248,24356,24373,24523,24580,24615,24672,24710,24785,24868,24907,24964,25007,25062,25079,25099,25100,25170,25184,25278,25310,25315,25332,25343,25384,25386,25389,25411,25420,25428,25429,25434,25443,25452,25463,25477,25498,25501,25560,25573,25584,25614,25640,25664,25676,25688,25694,25697,25699,25711,25718,25724,25820,25884,25908,25948,25954,25971,26133,26216,26231,26239,26250,26275,26292,26360,26380,26431,26440,26451,26453,26456,26541,26559,26568,26571,26596,26618,26651,26678,26697,26725,26729,26730,26742,26747,26809,26859,26947,26960,27006,27008,27015,27024,27025,27056,27058,27085,27089,27189,27333,27364,27417,27454,27518,27541,27544,27624,27628,27670,27710,27741,27743,27763,27811,27839,27846,27905,27998,28036,28046,28102,28131,28215,28223,28232,28240,28309,28328,28333,28342,28346,28352,28353,28373,28457,28484,28485,28499,28611,28616,28690,28774,28787,28887,28896,28897,28939,28944,29213,29389,29590,29722,29844,29867,30031,30180,30382,30398,30403,30479,30482,30507,30574,30604,30656,31097,31430,31623,31624,31634,32392,32874,35566,35841,35942,38380,38495,38597,38612,38712,38736,38793,38846,38847,38850,38857,38865,38867,38868,38884,38899,39025,39049,39144,39385,39625,39657,40404,40681,40797,40972,41005,41048,41363,41399,41507,42210,42458,42532,42562,42948,43842,43855,44303,45180)
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 | 777 | 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.43 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.17 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 1.31 ms |
preparing | 0.61 ms |
Sorting result | 0.04 ms |
executing | 0.01 ms |
Sending data | 0.30 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.05 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 |