Tiempo de la consulta: 4.35 ms Después de la última consulta: 0.79 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.325 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-09 15:52:07')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 15:52:07')
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,21,25,58,197,260,263,287,331,394,495,523,563,707,770,805,808,1175,1296,1326,1348,1350,1352,1357,1486,1503,1538,1697,1714,1718,1744,1781,1785,1804,1823,1913,1917,2210,2258,2265,2294,2305,2424,2601,2689,2709,2825,3005,3070,3212,3319,3452,3483,3531,3575,3594,3604,3700,3732,3831,4018,4100,4131,4166,4169,4188,4215,4227,4339,4473,4493,4612,4613,4614,4615,4617,4677,4920,4980,4982,5092,5138,5189,5199,5268,5279,5362,5435,5436,5461,5530,5792,5796,5814,5825,5855,5857,5943,5973,5996,6159,6192,6205,6268,6292,6324,6372,6407,6427,6452,6465,6468,6470,6492,6493,6558,6571,6586,6616,6716,6744,6776,6788,6822,6977,7081,7085,7128,7215,7218,7231,7232,7234,7243,7246,7249,7285,7289,7292,7319,7325,7328,7330,7333,7334,7344,7346,7364,7367,7368,7370,7371,7374,7377,7379,7380,7387,7396,7401,7404,7406,7407,7408,7410,7413,7414,7415,7416,7417,7422,7425,7430,7431,7435,7436,7447,7450,7453,7455,7456,7457,7458,7463,7464,7465,7482,7486,7488,7489,7532,7545,7546,7552,7553,7555,7570,7572,7577,7583,7615,7624,7625,7659,7678,7682,7683,7690,7691,7715,7720,7725,7735,7741,7744,7745,7746,7749,7757,7768,7799,7830,7833,7834,7835,7847,7850,7851,7863,7867,7871,7887,7891,7894,7895,7900,7901,7919,7955,7957,7961,7962,7979,7982,8020,8022,8023,8024,8049,8064,8067,8072,8125,8223,8229,8285,8366,8383,8436,8437,8549,8555,8589,8599,8649,8660,8689,8698,8706,8713,8752,8851,8856,9041,9051,9055,9059,9091,9142,9181,9218,9233,9253,9303,9308,9344,9356,9399,9432,9438,9439,9471,9481,9568,9658,9670,9704,9757,9805,9828,9858,9907,9909,9996,10039,10054,10110,10120,10154,10180,10186,10197,10199,10205,10243,10260,10284,10295,10304,10305,10349,10369,10387,10400,10418,10422,10458,10510,10522,10564,10604,10611,10620,10629,10634,10811,10946,11026,11068,11071,11098,11150,11323,11328,11345,11386,11404,11458,11476,11477,11486,11592,11612,11642,11703,11720,11721,11722,11749,11803,11859,11864,12010,12226,12248,12415,12435,12488,12527,12541,12592,12609,12617,12649,12650,12686,12736,12783,12851,12895,12935,12939,12942,12944,12978,13154,13188,13269,13273,13276,13309,13325,13327,13348,13349,13352,13373,13375,13474,13539,13575,13667,13670,13672,13685,13770,13782,13783,13812,13819,13834,13891,13902,13935,13947,14008,14052,14079,14084,14103,14149,14169,14172,14250,14263,14276,14334,14336,14354,14357,14363,14366,14420,14421,14431,14437,14478,14505,14576,14596,14679,14680,14713,14749,14754,14770,14832,14846,14849,14865,14906,14911,14946,14973,14974,14990,14996,15015,15039,15045,15046,15065,15076,15213,15217,15234,15257,15293,15304,15318,15366,15427,15533,15539,15594,15605,15673,15689,15766,15796,15797,15808,15835,15851,15862,15874,15894,15899,15902,15916,15917,16009,16014,16055,16057,16087,16089,16103,16120,16172,16208,16240,16280,16346,16354,16410,16422,16440,16455,16474,16490,16520,16523,16562,16578,16579,16584,16675,16678,16715,16739,16751,16765,16791,16794,16907,16921,16964,16976,17014,17034,17043,17053,17059,17067,17080,17121,17156,17167,17205,17263,17288,17291,17304,17335,17344,17353,17375,17385,17394,17476,17541,17590,17607,17630,17824,17859,17883,17941,17999,18150,18216,18220,18223,18227,18333,18334,18351,18353,18442,18455,18482,18558,18576,18590,18619,18653,18658,18668,18712,18730,18735,18739,18748,18749,18782,18793,18876,18877,18905,18906,18907,18922,18926,18951,18997,19027,19101,19153,19204,19220,19243,19426,19428,19437,19472,19484,19542,19604,19645,19646,19651,19702,19772,19875,19904,19916,19967,20066,20127,20167,20180,20189,20191,20218,20289,20291,20376,20385,20398,20592,20642,20656,20660,20690,20788,20820,20885,20947,21049,21065,21239,21259,21263,21300,21305,21315,21329,21345,21350,21413,21487,21520,21523,21524,21554,21566,21574,21602,21612,21624,21640,21698,21719,21726,21787,21843,21891,21932,21952,22014,22067,22116,22129,22253,22262,22289,22290,22359,22374,22395,22453,22454,22494,22602,22620,22649,22659,22693,22739,22751,22781,22877,22886,22914,22959,22964,22985,22986,23104,23107,23123,23184,23201,23214,23229,23273,23328,23340,23364,23365,23367,23423,23438,23444,23523,23527,23575,23665,23680,23693,23716,23720,23725,23729,23849,23869,23885,23949,23955,24062,24100,24145,24211,24223,24279,24397,24443,24475,24526,24586,24595,24668,24716,24736,24738,24752,24766,24767,24780,24785,24834,24872,24915,25032,25062,25178,25294,25310,25343,25505,25518,25538,25554,25555,25560,25589,25639,25646,25648,25664,25671,25723,25727,25747,25751,25757,25758,25771,25807,25817,25830,25836,25888,25916,25920,25924,25927,25941,25942,25949,25961,25990,25992,25994,25995,26000,26010,26013,26025,26033,26035,26060,26082,26087,26113,26120,26136,26146,26147,26153,26161,26185,26187,26191,26194,26215,26221,26227,26230,26234,26250,26259,26296,26337,26359,26386,26409,26579,26609,26646,26780,26820,26845,26873,26927,26933,26968,27126,27211,27240,27245,27270,27323,27327,27347,27405,27438,27447,27487,27492,27512,27526,27557,27578,27583,27604,27605,27688,27707,27717,27749,27786,27789,27922,27924,28019,28075,28097,28114,28264,28399,28441,28468,28846,28931,28943,29443,29611,29616,29724,29907,29936,30111,30194,30988,31684,31735,31798,31820,31837,31853,32720,32767,32768,33416,33874,33908,35632,35639,35640,35643,35728,35741,35744,35752,35760,35814,35835,35846,36075,36141,36147,36208,36223,36581,36584,37544,37577,37677,37759,37902,38092,38330,38362,38593,38617,38723,38799,38821,38824,38829,38877,38912,38965,38990,39155,39205,39224,39240,39290,39293,39366,39442,39559,39600,39642,39686,39724,40624,41148,41171,41289,43003,43483)
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 | 954 | 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.51 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.07 ms |
statistics | 1.59 ms |
preparing | 0.75 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.01 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 |