Tiempo de la consulta: 4.37 ms Después de la última consulta: 0.98 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 4.386 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 12:35:12')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 12:35:12')
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(44,45,46,52,59,89,181,198,215,216,221,224,225,244,254,262,280,325,394,434,439,444,445,474,481,596,603,615,625,641,642,647,648,650,651,652,654,681,686,687,689,697,805,814,824,843,845,854,875,936,941,950,976,1051,1066,1071,1215,1227,1266,1267,1268,1303,1327,1339,1359,1432,1467,1534,1574,1620,1637,1659,1686,1709,1721,1724,1754,1778,1805,1839,1853,1863,1896,1932,1996,2047,2221,2369,2428,2455,2574,2780,2808,2825,2855,2869,2884,3002,3026,3037,3165,3188,3193,3281,3291,3292,3326,3329,3346,3375,3398,3410,3593,3595,3630,3639,3721,3722,3752,3801,3868,3870,4026,4049,4199,4338,4451,4456,4461,4486,4507,4510,4520,4547,4578,4583,4584,4620,4640,4672,4673,4787,4799,4832,4833,4855,4911,4935,4965,5053,5062,5092,5094,5098,5142,5147,5151,5166,5170,5183,5184,5195,5244,5245,5263,5273,5282,5301,5374,5406,5469,5505,5519,5585,5677,5683,5688,5703,5756,5782,5802,5831,5835,5848,5852,5906,5927,6014,6032,6069,6093,6142,6166,6176,6222,6226,6256,6276,6335,6345,6373,6510,6538,6542,6543,6550,6606,6610,6612,6641,6666,6677,6716,6729,6779,6783,6924,6939,6944,6998,7004,7024,7048,7105,7139,7222,7411,7423,7446,7496,7507,7513,7533,7534,7556,7560,7595,7615,7812,7869,7904,7918,7926,7968,8002,8060,8178,8256,8294,8296,8299,8306,8357,8393,8418,8532,8568,8572,8678,8707,8710,8810,8835,8923,8940,8948,8995,9046,9061,9075,9096,9110,9112,9140,9147,9180,9186,9190,9199,9252,9362,9381,9401,9541,9559,9576,9641,9685,9731,9752,9873,9915,9932,10014,10044,10046,10113,10147,10342,10371,10407,10501,10572,10774,10993,11207,11241,11408,11436,11465,11549,11590,11693,11706,11750,11772,11791,11814,11979,12024,12324,12334,12413,12440,12550,12795,12801,12870,12943,12998,13065,13067,13069,13070,13094,13121,13149,13209,13263,13353,13387,13685,13728,13803,13894,14022,14048,14111,14129,14146,14233,14352,14494,14542,14577,14618,14620,14680,14741,14752,14808,14857,14873,14889,14944,14965,14969,14974,15077,15090,15140,15144,15184,15186,15279,15461,15488,15598,15613,15619,15627,15644,15646,15690,15710,15751,15753,15819,15868,15871,15878,15895,15902,15960,15969,15998,15999,16010,16040,16055,16078,16081,16102,16103,16120,16176,16219,16245,16284,16391,16401,16547,16569,16570,16588,16711,16742,16743,16905,16913,16918,17014,17028,17032,17136,17172,17217,17305,17315,17383,17395,17449,17458,17483,17580,17608,17629,17643,17699,17756,17959,17986,18014,18068,18075,18077,18088,18151,18241,18276,18284,18306,18307,18327,18382,18423,18446,18491,18516,18582,18599,18652,18744,18779,19019,19112,19135,19137,19257,19286,19316,19359,19432,19533,19551,19582,19607,19647,19706,19710,19742,19758,19783,19860,19874,19976,19996,20150,20188,20191,20235,20448,20565,20599,20637,20704,20713,20776,20832,20921,20966,20967,20997,21013,21036,21041,21090,21174,21195,21203,21233,21279,21340,21360,21435,21473,21560,21652,21660,21720,21835,22038,22249,22337,22352,22362,22400,22550,22551,22573,22615,22676,22726,22737,22767,22779,22797,22855,22870,22873,22886,22941,22963,23016,23065,23115,23200,23313,23349,23350,23397,23400,23482,23556,23788,23850,23876,23879,23932,23943,24096,24107,24164,24172,24248,24281,24434,24458,24475,24578,24681,24690,24766,24880,24894,24896,24920,24927,24933,24945,24967,24993,25001,25006,25013,25030,25040,25073,25091,25094,25112,25114,25167,25296,25321,25367,25371,25372,25390,25391,25393,25414,25431,25433,25446,25451,25457,25459,25464,25465,25467,25468,25472,25476,25482,25485,25486,25489,25492,25493,25494,25495,25499,25504,25506,25508,25509,25510,25513,25517,25536,25537,25538,25540,25545,25546,25552,25559,25569,25572,25576,25578,25582,25587,25588,25592,25596,25674,25689,25708,25753,25937,25941,25953,25966,25974,26000,26037,26043,26044,26047,26082,26100,26148,26215,26241,26362,26387,26405,26447,26452,26504,26506,26554,26572,26577,26578,26652,26653,26683,26694,26707,26762,26780,26785,26787,26796,26825,26897,26936,26949,26962,26982,26991,27023,27067,27075,27095,27123,27133,27211,27279,27340,27342,27344,27354,27496,27511,27522,27563,27582,27619,27702,27739,27843,27875,27981,28152,28193,28218,28334,28340,28423,28440,28442,28450,28466,28534,28548,28591,28615,28616,28629,28635,28656,28665,28671,28706,28707,28725,28727,28728,28741,28745,28751,28763,28776,28795,28799,28800,28803,28807,28817,28833,28834,28844,28847,28858,28866,28870,28872,28925,28930,28931,29127,29201,29209,29222,29242,29261,29329,29374,29389,29418,29459,29468,29837,29894,30138,30155,30262,30289,30572,30573,30941,30978,31090,31109,31401,31417,31463,31533,31560,31621,31684,31725,31821,31837,31843,31852,31899,31937,31962,32286,32472,32679,32965,33107,33233,33327,33475,33503,33605,33997,34030,34071,34159,34243,34262,34265,34270,34375,34539,34595,34611,34785,34902,34942,34956,34969,35051,35071,35072,35073,35088,35097,35156,35165,35167,35206,35266,35294,35308,35326,35427,35430,35485,35564,35588,35643,35657,35674,35694,35724,35822,35881,35931,36007,36012,36018,36143,36160,36165,36167,36191,36214,36247,36251,36256,36285,36339,36346,36349,36355,36365,36370,36382,36397,36433,36463,36474,36499,36575,36617,36620,36690,36750,36795,36798,36806,36838,36885,37002,37056,37129,37251,37411,37422,37524,37528,37529,37532,37569,37570,37571,37572,37688,37691,37758,37796,37972,38071,38199,38212,38363,38365,38392,38417,38427,38452,38503,38585,38598,38664,38665,38719,38762,38825,38933,38964,39056,39061,39170,39180,39227,39231,39258,39299,39301,39397,39494,39529,39687,39703,39769,39826,39882,39896,39897,39958,39964,39971,39977,40025,40033,40052,40082,40085,40107,40110,40119,40183,40229,40245,40292,40344,40358,40397,40481,40530,40572,40607,40625,40650,40655,40703,40760,40784,40874,40952,41063,41070,41095,41117,41134,41188,41204,41348,41353,41380,41381,41464,41503,41520,41525,41526,41531,41539,41546,41561,41580,41601,41677,41681,41692,41706,41723,41744,41778,41861,41866,41874,42107,42185,42205,42312,42387,42394,42396,42404,42408,42520,42567,42590,42639,42708,42716,42822,42836,42890,42900,42952,42963,42991,42993,42998,43050,43051,43052,43078,43090,43107,43114,43120,43162,43191,43247,43248,43274,43291,43300,43301,43335,43353,43360,43365,43386,43398,43412,43424,43528,43546,43599,43645,43651,43688,43700,43716,43717,43725,43828,43885,43942,43944,44013,44046,44051,44060,44078,44079,44094,44100,44101,44120,44128,44159,44165,44175,44200,44208,44229,44263,44282,44312,44327,44382,44387,44396,44406,44422,44447,44453,44458,44463,44479,44487,44500,44517,44562,44609,44627,44639,44662,44673,44682,44749,44761,44762,44786,44797,44817,44855,44950,45008,45024,45050,45086,45106,45131,45134,45152,45183,45196,45208,45209,45257,45275,45288,45293,45309)
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 | 1140 | 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.55 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.23 ms |
System lock | 0.02 ms |
optimizing | 0.11 ms |
statistics | 1.72 ms |
preparing | 0.85 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.30 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.06 ms |
cleaning up | 0.04 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 |