Tiempo de la consulta: 8.73 ms Después de la última consulta: 0.76 ms Consulta a la memoria: 0.846 MB memoria antes de la consulta: 4.185 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 23:59:07')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 23:59: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(25,75,181,198,203,215,216,218,221,224,225,254,255,256,262,272,280,325,371,394,474,594,596,597,641,642,650,681,686,854,875,976,1066,1071,1080,1207,1266,1267,1339,1357,1359,1397,1467,1534,1574,1637,1659,1668,1686,1709,1721,1778,1805,1839,1896,1932,1952,1963,2221,2300,2322,2428,2455,2713,2855,2869,3106,3107,3188,3265,3281,3326,3329,3398,3442,3463,3565,3593,3595,3619,3626,3630,3786,3801,3868,3870,4024,4119,4338,4547,4578,4621,4799,4848,4855,4911,4935,4965,5053,5062,5098,5147,5151,5166,5184,5195,5263,5273,5374,5406,5451,5519,5585,5756,5782,5835,5852,5894,5906,5927,6014,6032,6059,6062,6069,6222,6226,6276,6373,6393,6510,6542,6543,6641,6666,6677,6716,6779,6827,6924,6939,7004,7048,7105,7222,7290,7423,7446,7533,7534,7556,7560,7588,7631,7812,7904,7926,7950,7968,7998,8027,8060,8115,8178,8294,8296,8299,8303,8306,8357,8418,8572,8648,8678,8696,8710,8810,8835,8923,8940,8948,8995,9046,9096,9110,9119,9140,9150,9180,9186,9190,9199,9200,9252,9275,9351,9362,9381,9541,9574,9576,9641,9685,9731,9860,9873,9915,10014,10044,10046,10113,10120,10122,10147,10188,10342,10369,10407,10497,10549,10720,10757,10774,10925,10964,11008,11035,11102,11150,11155,11254,11269,11299,11366,11391,11436,11462,11465,11469,11549,11590,11706,11750,11772,11791,11860,11930,11940,11941,11979,12057,12324,12334,12388,12440,12445,12501,12519,12550,12565,12567,12670,12795,12867,12902,12940,12978,12998,13036,13038,13065,13069,13070,13078,13094,13121,13157,13209,13263,13281,13390,13728,13792,13803,13894,13959,14048,14122,14146,14229,14249,14276,14352,14364,14494,14577,14713,14741,14752,14807,14850,14857,14889,14911,14969,15003,15014,15077,15090,15133,15184,15186,15279,15407,15414,15475,15598,15627,15643,15644,15751,15753,15850,15895,15902,15960,15969,15998,16010,16040,16055,16078,16141,16219,16241,16284,16401,16414,16450,16568,16570,16588,16913,16918,16974,17014,17060,17132,17141,17339,17456,17470,17580,17581,17629,17643,17673,17721,17753,17789,17790,17806,17807,17810,17826,17836,17870,17931,17959,17988,18014,18032,18068,18276,18284,18306,18382,18423,18491,18494,18516,18574,18582,18599,18612,18629,18663,18744,18751,18752,18798,18901,18916,19019,19103,19112,19134,19213,19260,19286,19316,19359,19412,19420,19432,19533,19607,19645,19646,19652,19733,19742,19758,19783,19875,20023,20150,20161,20303,20472,20637,20704,20713,20776,20832,20922,20973,21013,21027,21040,21090,21174,21255,21273,21340,21433,21435,21491,21498,21624,21660,21679,21740,21746,21751,21870,21890,21913,22038,22099,22113,22194,22315,22331,22337,22352,22362,22369,22400,22551,22554,22572,22573,22596,22602,22615,22676,22716,22737,22767,22770,22797,22831,22852,22855,22941,22963,22999,23022,23078,23115,23121,23146,23254,23261,23313,23321,23340,23349,23366,23371,23410,23418,23424,23482,23555,23585,23618,23774,23788,23796,23879,23921,23943,24012,24101,24107,24142,24162,24164,24168,24172,24203,24211,24248,24276,24305,24311,24335,24362,24406,24409,24434,24458,24469,24475,24499,24508,24517,24549,24598,24605,24613,24730,24766,24802,24841,24880,24894,24896,24909,24927,24941,24962,24967,24993,25001,25013,25040,25048,25094,25114,25147,25167,25225,25230,25251,25293,25296,25303,25321,25333,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,25500,25504,25506,25508,25509,25510,25517,25522,25536,25537,25538,25540,25545,25546,25552,25559,25560,25569,25572,25576,25578,25582,25587,25588,25596,25637,25674,25711,25712,25756,25937,25941,25953,26044,26047,26053,26164,26172,26188,26201,26337,26362,26506,26554,26572,26577,26578,26587,26621,26653,26683,26694,26785,26787,26796,26962,27067,27095,27119,27123,27161,27178,27291,27317,27321,27342,27433,27531,27600,27949,27968,27990,28440,28534,28548,28552,28635,28679,28741,28751,28754,28870,28930,29143,29222,29505,29743,29747,29804,30000,30703,31463,31533,31725,31976,32472,33605,34030,34071,34159,34243,34262,34270,34375,34611,34956,35266,35643,35746,35822,35881,36007,36143,36251,36339,36382,36617,36620,36838,36844,37002,37056,37411,37422,37524,37532,37688,37758,37796,38071,38199,38363,38452,38585,38664,38665,38719,38762,38933,39227,39231,39397,39629,39687,39769,39826,39896,39897,39958,39964,39977,40025,40082,40183,40292,40530,40583,40650,40703,41070,41095,41134,41148,41188,41204,41464,41503,41601,41677,41681,41778,41861,42107,42185,42205,42387,42396,42590,42639,42708,42716,42836,42890,42897,42900,42952,42991,42993,42998,43050,43051,43078,43114,43120,43191,43247,43248,43274,43291,43300,43301,43335,43360,43365,43386,43398,43412,43424,43528,43546,43599,43651,43688,43700,43716,43725,43885,44013,44046,44051,44060,44079,44094,44120,44128,44159,44165,44175,44200,44208,44229,44263,44282,44312,44327,44382,44387,44406,44422,44447,44453,44458,44479,44487,44500,44517,44562,44609,44662,44682,44761,44762,44786,44797,44950,45008,45024,45050,45086,45106,45131,45152,45183,45196,45208,45209,45257,45275,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 | 859 | 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.19 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.35 ms |
preparing | 0.65 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 4.73 ms |
end | 0.02 ms |
query end | 0.03 ms |
closing tables | 0.03 ms |
freeing items | 0.07 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 |