Tiempo de la consulta: 3.76 ms Después de la última consulta: 0.66 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.187 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-08 21:32:17')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-08 21:32:17')
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(185,263,267,341,368,482,625,843,869,877,1051,1066,1101,1225,1321,1327,1331,1359,1411,1431,1432,1503,1550,1620,1686,1701,1724,1735,1754,1765,1775,1785,1839,1848,1945,2006,2008,2054,2072,2142,2198,2314,2338,2369,2376,2473,2574,2632,2710,2780,2808,2825,2884,3009,3026,3037,3122,3165,3188,3193,3209,3281,3326,3329,3346,3375,3376,3442,3453,3515,3536,3593,3595,3721,3722,3735,3752,3961,4026,4049,4148,4227,4312,4323,4334,4354,4430,4451,4461,4486,4507,4510,4520,4550,4554,4583,4584,4620,4621,4640,4672,4673,4787,4821,4832,4833,4848,4900,5021,5049,5056,5092,5094,5144,5155,5170,5183,5244,5266,5282,5301,5399,5469,5488,5505,5565,5578,5622,5628,5638,5646,5648,5677,5683,5685,5688,5703,5802,5831,5848,5874,5897,6093,6141,6142,6166,6176,6209,6256,6260,6290,6307,6310,6335,6345,6400,6442,6538,6550,6606,6612,6614,6623,6637,6638,6729,6783,6845,6944,6998,7022,7024,7105,7139,7266,7287,7289,7324,7388,7395,7433,7471,7513,7522,7527,7533,7615,7647,7739,7852,7869,7918,7936,7938,8002,8047,8273,8294,8352,8359,8367,8386,8391,8393,8406,8449,8498,8532,8543,8568,8670,8679,8707,8940,8965,9051,9057,9061,9075,9107,9147,9155,9158,9190,9195,9197,9199,9286,9392,9401,9553,9559,9641,9800,9825,9873,9932,9965,9992,10011,10068,10101,10113,10134,10138,10167,10371,10407,10413,10501,10562,10572,10755,11207,11231,11241,11243,11253,11255,11287,11320,11371,11408,11443,11469,11549,11693,11697,11700,11814,12221,12248,12324,12329,12341,12440,12459,12614,12817,12835,12870,12895,12902,12973,13067,13145,13186,13219,13298,13353,13413,13475,13530,13534,13544,13546,13549,13557,13691,13846,13851,13853,13925,14022,14122,14129,14132,14135,14146,14189,14194,14206,14331,14364,14419,14428,14435,14464,14565,14581,14595,14706,14713,14737,14773,14808,14873,14925,14944,14972,14974,14975,14988,15087,15133,15140,15144,15171,15203,15322,15398,15613,15619,15646,15690,15701,15710,15796,15831,15850,15868,15871,15878,15969,15994,16029,16081,16102,16103,16120,16176,16183,16245,16416,16503,16517,16526,16547,16548,16569,16571,16628,16636,16698,16742,16743,16793,16836,16859,16905,16997,17006,17058,17062,17074,17136,17167,17170,17315,17335,17367,17376,17395,17412,17427,17449,17458,17483,17524,17606,17608,17635,17721,17756,17942,17948,17986,18035,18075,18077,18080,18088,18096,18151,18241,18265,18306,18307,18327,18371,18412,18473,18488,18602,18609,18630,18652,18779,18802,18836,18878,18969,18977,18978,19012,19019,19039,19137,19424,19551,19647,19681,19706,19710,19860,19874,19996,20188,20191,20240,20272,20290,20428,20448,20565,20599,20621,20801,20871,20921,20966,20967,20997,21025,21034,21036,21185,21203,21241,21279,21439,21460,21473,21534,21560,21652,21720,21746,21780,21787,21835,21846,22038,22184,22249,22312,22603,22632,22726,22779,22870,22885,22886,22936,22966,23065,23397,23400,23452,23482,23648,23676,23701,23788,23932,23945,24047,24151,24619,24627,24690,24793,24920,24933,24947,25016,25030,25112,25128,25689,25966,26000,26037,26040,26043,26044,26082,26093,26100,26148,26241,26362,26405,26410,26429,26447,26504,26652,26707,26762,26825,26897,26949,26982,26990,26991,26992,26997,27023,27293,27340,27344,27354,27421,27460,27502,27511,27522,27635,27702,27843,27860,27875,27880,27894,27898,27968,27990,28013,28022,28030,28152,28193,28218,28272,28334,28340,28416,28423,28440,28442,28458,28470,28524,28547,28548,28582,28587,28615,28616,28629,28635,28636,28656,28665,28671,28706,28707,28725,28727,28728,28745,28763,28776,28795,28799,28800,28803,28807,28833,28834,28844,28847,28858,28866,28872,28884,28925,28931,29127,29201,29221,29222,29329,29374,29389,29418,29446,29459,29468,29894,30138,30262,30572,30573,31401,31873,32286,32552,32965,33042,33044,33107,33327,33503,33884,33885,33886,33897,34111,34265,34284,34319,34595,34667,34668,34669,34785,34788,34892,34902,34942,34969,35036,35051,35071,35072,35073,35088,35097,35103,35126,35156,35165,35167,35195,35206,35219,35235,35294,35308,35326,35427,35430,35472,35564,35588,35650,35657,35674,35676,35694,35724,35746,35931,35943,36012,36042,36047,36095,36165,36191,36252,36285,36287,36346,36355,36463,36575,36750,36795,36798,36806,36880,37088,37129,37251,37497,37528,37529,37532,37972,38212,38293,38365,38392,38411,38417,38503,38598,38651,38772,38825,38855,38964,38988,39056,39061,39142,39170,39253,39254,39299,39301,39529,39683,39703,39714,39882,39971,40034,40052,40107,40110,40119,40358,40453,40481,40625,40655,40784,40863,41063,41117,41348,41353,41380,41381,41520,41723,41744,41866,41874,42394,42404,42411,42763,42822,42876,43090,43107,43162,43353,43461,43644,43645,43652,43944,44078,44100,44101,44817,44971,45134,45293)
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 | 795 | 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.40 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.21 ms |
preparing | 0.58 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.29 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.05 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 |