Tiempo de la consulta: 4.29 ms Después de la última consulta: 0.98 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.390 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 04:07:03')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 04:07: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(4,5,7,8,9,11,14,21,29,39,44,46,50,52,56,59,60,62,63,65,71,73,83,86,87,89,90,124,149,164,174,177,180,181,186,188,189,190,196,197,198,202,212,215,219,220,221,222,224,225,226,237,240,244,246,248,249,250,253,254,257,259,260,262,263,271,287,290,291,299,325,331,336,349,366,370,371,373,386,391,394,395,401,411,412,413,414,419,423,424,427,428,429,433,436,439,442,444,445,451,470,472,474,477,481,485,500,501,510,516,524,525,530,531,534,537,539,546,558,561,569,619,629,630,641,642,646,647,648,650,651,652,654,659,662,663,667,674,681,684,686,697,699,705,746,748,769,770,800,802,805,806,808,810,818,823,832,835,869,873,884,910,923,939,940,954,955,959,969,974,977,982,983,999,1004,1005,1011,1021,1037,1055,1066,1091,1095,1107,1108,1114,1119,1158,1181,1182,1205,1227,1231,1247,1252,1253,1255,1264,1266,1267,1268,1269,1270,1271,1272,1273,1274,1275,1276,1277,1278,1289,1296,1308,1309,1314,1319,1347,1348,1363,1388,1389,1390,1394,1402,1409,1410,1428,1432,1441,1444,1459,1485,1503,1509,1538,1557,1561,1606,1619,1629,1648,1675,1693,1694,1714,1718,1724,1771,1794,1795,1796,1804,1808,1810,1843,1854,1855,1862,1899,1918,1920,1930,1960,1961,1975,1979,1984,1994,1995,2001,2006,2008,2013,2015,2035,2036,2057,2075,2088,2137,2155,2157,2161,2215,2258,2290,2293,2305,2358,2455,2527,2532,2551,2586,2597,2638,2643,2759,2814,2824,2834,2835,2843,2851,2869,2883,2888,2960,3027,3055,3057,3100,3107,3147,3169,3181,3192,3207,3294,3319,3327,3364,3368,3369,3387,3409,3412,3417,3473,3507,3520,3544,3545,3548,3552,3554,3559,3575,3590,3648,3683,3689,3711,3748,3853,3858,3872,3886,3913,3919,3922,3962,3991,4034,4050,4068,4100,4110,4129,4131,4327,4339,4453,4468,4473,4493,4529,4532,4558,4612,4613,4614,4615,4616,4617,4620,4622,4626,4666,4751,4752,4767,4813,4815,4822,4831,4844,4846,4865,4876,4933,4973,4982,5055,5134,5153,5160,5199,5220,5262,5370,5415,5431,5461,5469,5530,5559,5633,5756,5780,5795,5814,5855,5857,5890,5973,5996,5999,6148,6159,6198,6372,6391,6420,6427,6435,6442,6465,6468,6470,6476,6477,6492,6548,6606,6616,6744,6770,6775,6776,6809,6845,6855,6944,6958,7022,7030,7048,7137,7195,7215,7218,7231,7232,7234,7242,7243,7246,7249,7258,7276,7285,7289,7319,7324,7328,7330,7333,7334,7336,7344,7346,7364,7367,7368,7370,7371,7374,7377,7379,7380,7396,7406,7407,7408,7410,7413,7414,7415,7416,7417,7418,7422,7430,7431,7435,7436,7447,7450,7455,7456,7457,7458,7463,7464,7465,7486,7489,7491,7535,7545,7546,7552,7553,7555,7565,7570,7577,7583,7592,7595,7615,7625,7648,7659,7678,7682,7683,7691,7715,7720,7735,7744,7746,7749,7751,7757,7768,7799,7819,7830,7833,7834,7835,7851,7863,7871,7890,7891,7894,7895,7900,7901,7919,7955,7957,7961,7962,7979,7982,8020,8022,8023,8024,8049,8053,8067,8070,8072,8086,8169,8192,8286,8291,8295,8314,8445,8538,8592,8602,8634,8677,8698,8707,8736,8779,8801,8895,9059,9173,9218,9237,9253,9277,9279,9291,9303,9344,9369,9401,9488,9568,9572,9658,9772,9907,9930,9996,10001,10024,10077,10079,10186,10189,10197,10198,10199,10205,10243,10331,10349,10387,10400,10522,10539,10572,10723,10840,11001,11071,11184,11404,11458,11494,11555,11630,11864,12049,12226,12242,12398,12408,12435,12444,12488,12527,12530,12609,12617,12639,12649,12667,12944,12974,12978,13034,13126,13154,13246,13325,13327,13375,13667,13685,13896,14052,14063,14250,14366,14421,14431,14505,14596,14666,14680,14703,14713,14714,14726,14752,14770,14849,14865,14946,14969,14973,14974,14976,15015,15038,15039,15046,15063,15087,15203,15235,15293,15318,15460,15533,15544,15594,15604,15673,15689,15781,15797,15804,15807,15808,15835,15874,15875,15902,15913,15915,15916,15973,16045,16055,16103,16122,16172,16224,16240,16277,16387,16410,16440,16454,16520,16540,16554,16584,16587,16588,16612,16698,16737,16789,16791,16830,16831,16892,16907,16913,16964,16995,17054,17055,17080,17102,17140,17149,17166,17189,17291,17333,17335,17341,17344,17354,17372,17388,17403,17442,17463,17476,17477,17590,17592,17607,17644,17646,17683,17699,17737,17791,17798,17799,17806,17807,17824,17883,17907,17936,17941,17999,18036,18046,18047,18150,18220,18353,18357,18371,18383,18407,18442,18444,18480,18482,18507,18542,18558,18576,18591,18657,18695,18712,18716,18730,18733,18735,18754,18779,18787,18802,18824,18832,18905,18986,19015,19021,19038,19101,19176,19182,19183,19187,19209,19228,19243,19258,19269,19280,19282,19283,19289,19299,19302,19307,19339,19389,19400,19402,19421,19423,19426,19427,19458,19467,19470,19472,19484,19489,19503,19504,19532,19533,19542,19552,19573,19651,19721,19772,19800,19830,19864,19937,19967,19969,20007,20029,20044,20056,20057,20062,20066,20153,20167,20177,20188,20191,20215,20236,20257,20278,20289,20293,20306,20385,20391,20508,20518,20530,20592,20600,20662,20713,20733,20743,20755,20764,20774,20804,20813,20843,20851,20853,20858,20860,20871,20879,20883,20885,20904,20920,20921,20944,20949,20954,20999,21168,21217,21236,21259,21282,21295,21300,21313,21402,21415,21483,21569,21582,21602,21624,21760,21787,21820,21843,21952,21969,22105,22116,22145,22226,22262,22289,22290,22421,22567,22602,22603,22693,22743,22847,22854,22886,22914,22959,23107,23123,23138,23170,23202,23214,23224,23229,23246,23256,23364,23376,23526,23536,23546,23548,23569,23599,23617,23682,23725,23729,23849,23875,23885,23949,24062,24067,24072,24098,24153,24189,24208,24211,24219,24223,24234,24384,24415,24435,24484,24526,24571,24585,24595,24598,24609,24614,24682,24694,24714,24736,24737,24738,24785,24790,24797,24834,24853,24915,24973,25178,25241,25294,25323,25456,25512,25534,25538,25555,25569,25598,25610,25632,25648,25721,25864,25901,25941,25978,26000,26014,26015,26061,26095,26208,26215,26245,26308,26338,26359,26386,26409,26554,26579,26609,26646,26820,26829,26845,26920,26954,26968,26979,27024,27076,27103,27126,27133,27135,27157,27161,27347,27490,27492,27512,27604,27605,27749,27789,27805,27863,27904,27997,28248,28319,28402,28416,28441,28468,28846,28910,28918,28960,29033,29136,29281,29990,29991,30194,30307,30988,31114,31356,31671,31798,31853,32097,32841,33259,33416,33430,33593,33651,33784,33993,34008,34176,34300,34490,34573,34783,35568,35639,35640,35643,35744,35752,35755,36075,36208,36219,36581,36584,37408,37759,38362,38912,39180,39224,39240,39600,39653,39655,40050,40876,41059,41148,41171,41256,41311,41430,42530,42752,42799,43717,44396,44402,44602,44743,45076)
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 | 1164 | 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.54 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.22 ms |
System lock | 0.02 ms |
optimizing | 0.08 ms |
statistics | 1.73 ms |
preparing | 0.86 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.33 ms |
end | 0.01 ms |
query end | 0.01 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 |