Tiempo de la consulta: 4.62 ms Después de la última consulta: 0.82 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.186 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-03 21:06:01')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-03 21:06:01')
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(21,25,49,58,71,90,92,96,97,98,99,102,104,107,198,199,209,210,217,226,228,232,234,238,240,242,243,260,263,265,276,419,428,466,487,523,605,607,637,904,948,966,1031,1067,1209,1223,1352,1357,1698,1752,1781,1785,1825,1845,1913,1957,2156,2210,2424,2689,2718,2729,2822,2825,2826,3020,3058,3212,3452,3518,3594,3604,3700,3732,3953,4030,4035,4131,4166,4169,4188,4215,4227,4493,4612,4613,4614,4615,4617,4677,4784,4802,4808,4902,4920,4980,5092,5125,5138,5189,5268,5323,5371,5435,5461,5475,5622,5647,5649,5685,5726,5727,5825,5847,5943,6172,6192,6264,6268,6324,6386,6407,6450,6492,6493,6518,6571,6586,6616,6716,6760,6788,6839,6847,6881,6882,6915,6977,6984,7017,7081,7128,7321,7396,7425,7455,7482,7565,7572,7624,7662,7690,7725,7735,7741,7745,7772,7799,7913,7928,7958,7967,8056,8062,8064,8070,8103,8125,8193,8223,8229,8285,8320,8354,8381,8383,8436,8437,8549,8555,8589,8598,8660,8689,8706,8713,8844,8851,8856,8880,8970,9003,9051,9068,9091,9142,9181,9194,9233,9308,9399,9432,9438,9439,9445,9481,9494,9505,9650,9704,9710,9724,9757,9805,9828,9836,9924,10031,10039,10054,10095,10100,10110,10120,10154,10180,10260,10266,10295,10304,10323,10369,10377,10400,10422,10436,10458,10510,10564,10604,10611,10634,10727,10761,10811,10819,10889,10956,11026,11053,11098,11116,11149,11150,11157,11163,11236,11323,11328,11345,11373,11386,11414,11476,11592,11642,11703,11721,11722,11757,11803,11859,11911,11946,12095,12177,12248,12412,12488,12541,12592,12650,12679,12686,12736,12887,12913,12935,12973,13010,13058,13062,13154,13188,13231,13276,13321,13348,13349,13352,13376,13398,13405,13471,13473,13474,13575,13670,13681,13750,13782,13783,13800,13868,13947,13969,14008,14029,14034,14079,14097,14156,14169,14203,14218,14224,14263,14276,14293,14356,14357,14420,14581,14671,14679,14713,14749,14754,14832,14906,14911,14987,14996,15021,15039,15045,15046,15054,15076,15110,15179,15188,15198,15217,15234,15262,15298,15304,15309,15347,15366,15418,15421,15470,15473,15482,15495,15507,15511,15517,15539,15550,15573,15630,15667,15689,15729,15759,15766,15784,15796,15835,15851,15862,15894,15917,16049,16057,16120,16165,16185,16213,16263,16346,16352,16354,16365,16422,16455,16488,16490,16523,16532,16562,16566,16578,16660,16675,16678,16720,16739,16791,16812,16826,16894,16924,16983,17014,17034,17045,17053,17063,17121,17142,17154,17167,17236,17275,17288,17304,17317,17334,17335,17353,17385,17392,17394,17409,17453,17506,17520,17521,17611,17619,17623,17630,17710,17859,17862,17949,17965,18052,18106,18124,18133,18181,18213,18216,18328,18334,18336,18362,18426,18458,18465,18509,18538,18588,18590,18658,18675,18707,18726,18739,18748,18753,18782,18793,18801,18845,18846,18852,18906,18907,18922,18923,18926,18956,18958,18997,18999,19024,19040,19057,19098,19150,19153,19204,19231,19245,19252,19263,19312,19353,19358,19369,19402,19437,19454,19483,19484,19527,19551,19582,19604,19676,19722,19772,19791,19816,19837,19875,19904,19916,19939,19943,19963,19967,20004,20039,20092,20122,20124,20127,20180,20183,20189,20216,20269,20296,20301,20343,20376,20386,20398,20408,20434,20492,20497,20526,20528,20539,20573,20592,20617,20642,20660,20670,20688,20690,20792,20804,20881,20894,20907,20944,20947,20964,20984,21002,21049,21080,21088,21182,21198,21259,21300,21305,21329,21350,21391,21404,21413,21454,21477,21487,21520,21523,21524,21554,21566,21612,21631,21637,21639,21640,21679,21719,21726,21767,21787,21891,21932,21949,21958,21960,22032,22067,22085,22129,22156,22162,22172,22189,22205,22239,22253,22267,22339,22344,22359,22361,22363,22395,22409,22453,22454,22466,22481,22494,22499,22544,22547,22564,22577,22611,22612,22620,22649,22659,22694,22695,22703,22726,22739,22751,22753,22781,22814,22865,22871,22877,22958,22964,22973,22986,23003,23010,23036,23074,23096,23099,23104,23119,23123,23184,23201,23203,23214,23218,23230,23235,23254,23264,23268,23273,23292,23304,23328,23340,23365,23367,23371,23381,23391,23438,23444,23455,23460,23475,23483,23523,23527,23554,23555,23575,23585,23604,23619,23632,23665,23680,23693,23695,23716,23719,23720,23805,23813,23849,23854,23869,23893,23897,23901,23905,23909,23947,23955,23964,23986,24000,24007,24092,24100,24117,24145,24160,24197,24209,24226,24238,24268,24294,24303,24339,24352,24361,24366,24376,24397,24429,24475,24496,24503,24526,24528,24585,24598,24615,24639,24663,24668,24678,24679,24711,24716,24741,24761,24764,24766,24767,24772,24780,24782,24861,24872,24918,24934,24984,24992,25005,25032,25062,25079,25089,25151,25232,25244,25287,25303,25310,25343,25368,25375,25401,25432,25480,25505,25507,25518,25554,25560,25589,25613,25637,25639,25646,25648,25649,25664,25671,25716,25723,25727,25747,25757,25758,25771,25807,25817,25830,25836,25863,25916,25918,25924,25927,25941,25942,25949,25956,25961,25990,25992,25994,25995,26000,26010,26013,26025,26033,26035,26047,26060,26082,26087,26113,26118,26120,26131,26136,26146,26147,26153,26161,26184,26185,26187,26191,26194,26215,26221,26227,26230,26234,26250,26259,26283,26293,26296,26337,26359,26443,26625,26673,26684,26699,26732,26780,26873,26884,26900,26925,26927,26933,26940,26968,26971,26978,26990,27096,27109,27118,27126,27143,27157,27171,27211,27232,27240,27245,27270,27323,27327,27405,27430,27438,27487,27526,27550,27557,27578,27583,27688,27707,27717,27786,27922,27924,27950,28019,28030,28075,28097,28114,28121,28264,28709,28718,28825,28846,28931,28943,29063,29155,29297,29443,29611,29616,29724,29926,29936,29943,30083,30111,30273,30483,30484,30808,31136,31447,31684,31735,31820,31837,31853,32107,32720,32767,32768,33874,33908,35000,35539,35585,35614,35632,35659,35728,35741,35744,35760,35814,35832,35835,36093,36141,36793,36930,37544,37577,37677,37837,37856,37902,38092,38330,38498,38617,38723,38799,38821,38824,38829,38877,38912,38965,38990,39155,39205,39290,39293,39320,39366,39381,39442,39559,39642,39686,39724,39887,40086,40113,40145,40213,40451,40492,40578,40624,40730,41049,41171,41213,41289,41477,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 | 1018 | 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.48 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.20 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.64 ms |
preparing | 0.76 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.44 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 |