Tiempo de la consulta: 17.00 ms Después de la última consulta: 0.77 ms Consulta a la memoria: 0.846 MB memoria antes de la consulta: 4.329 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-04 07:25:09')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 07:25:09')
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(177,181,196,198,215,216,218,221,224,225,237,254,262,280,325,394,474,596,641,642,647,650,681,686,746,845,854,875,976,982,1066,1071,1252,1253,1266,1267,1339,1359,1467,1534,1574,1637,1659,1686,1709,1721,1778,1805,1896,1932,2032,2167,2221,2428,2455,2855,2869,3156,3398,3595,3630,3801,3868,3870,4338,4456,4467,4547,4578,4799,4855,4911,4935,4965,5053,5062,5098,5147,5151,5166,5184,5195,5263,5273,5374,5406,5519,5585,5756,5782,5835,5852,5906,5927,6014,6032,6069,6110,6222,6226,6276,6373,6510,6542,6543,6641,6666,6677,6716,6779,6924,6939,7004,7048,7222,7423,7446,7534,7556,7560,7673,7699,7710,7778,7812,7904,7926,7968,8060,8178,8294,8296,8299,8306,8357,8418,8572,8678,8710,8810,8835,8923,8940,8948,8995,9004,9046,9096,9110,9140,9180,9186,9190,9199,9252,9362,9369,9381,9541,9576,9641,9663,9666,9685,9731,9873,9915,9999,10014,10044,10046,10113,10147,10342,10407,10774,11436,11465,11549,11590,11706,11750,11772,11791,11979,12000,12324,12334,12440,12550,12795,12998,13065,13069,13070,13094,13121,13209,13263,13264,13612,13728,13803,13894,14048,14146,14352,14494,14577,14741,14752,14857,14889,14969,15077,15087,15090,15133,15184,15186,15279,15598,15615,15627,15644,15685,15751,15753,15895,15902,15960,15998,16010,16040,16055,16077,16078,16127,16165,16219,16284,16344,16377,16401,16475,16520,16570,16588,16846,16913,16936,17014,17134,17217,17580,17584,17629,17643,17644,17645,17649,17699,17785,17905,17946,17957,17959,17991,18006,18014,18068,18151,18171,18184,18191,18241,18253,18259,18276,18284,18306,18354,18382,18418,18423,18426,18460,18489,18491,18516,18524,18540,18582,18599,18744,18746,18751,18790,18828,18868,18874,18911,18918,18934,18977,19005,19019,19076,19082,19112,19155,19160,19267,19286,19316,19359,19400,19432,19495,19533,19607,19647,19742,19758,19783,19824,20017,20145,20150,20177,20340,20401,20405,20442,20550,20601,20617,20624,20637,20704,20705,20713,20714,20776,20832,20843,20871,20877,20910,20920,21012,21013,21027,21033,21047,21050,21059,21084,21090,21159,21174,21221,21230,21250,21262,21340,21397,21435,21547,21660,21688,21703,22037,22285,22300,22323,22337,22352,22362,22400,22551,22573,22590,22615,22676,22737,22797,22855,22941,22963,22991,22997,23063,23115,23192,23280,23285,23302,23313,23349,23351,23482,23483,23712,23788,23805,23879,23943,24107,24127,24164,24172,24209,24248,24434,24458,24475,24580,24709,24766,24787,24805,24861,24875,24880,24894,24896,24927,24967,24993,25001,25013,25040,25091,25094,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,25517,25520,25536,25537,25538,25540,25545,25546,25552,25559,25566,25569,25572,25576,25578,25582,25587,25588,25596,25674,25690,25873,25890,25937,25941,25953,25960,25974,26044,26047,26334,26347,26362,26506,26554,26572,26577,26578,26653,26683,26694,26728,26785,26787,26796,26962,27067,27095,27123,27187,27242,27342,27744,27860,28030,28248,28281,28328,28402,28416,28423,28440,28511,28534,28535,28547,28555,28575,28635,28683,28691,28712,28741,28751,28840,28870,28882,28930,29003,29108,29201,29221,29222,29298,29320,29450,29516,30284,30414,30605,30606,31055,31463,31533,31663,31725,31758,32115,32642,32643,33416,33605,33874,34030,34071,34159,34195,34243,34262,34270,34335,34375,34611,34881,34956,35266,35643,35822,35837,35881,36007,36117,36143,36251,36254,36270,36339,36382,36459,36548,36617,36620,36837,36838,36863,36948,37002,37056,37143,37311,37329,37363,37364,37411,37422,37440,37512,37524,37532,37561,37639,37688,37695,37696,37702,37709,37758,37796,38034,38071,38199,38223,38224,38225,38328,38363,38452,38579,38585,38664,38665,38719,38750,38762,38933,39227,39231,39361,39383,39397,39652,39687,39769,39826,39870,39896,39897,39933,39958,39964,39977,40025,40034,40082,40146,40147,40183,40207,40260,40292,40339,40370,40390,40530,40560,40578,40584,40650,40703,40824,40995,41025,41070,41094,41095,41118,41119,41134,41185,41188,41197,41204,41327,41393,41409,41411,41447,41463,41464,41474,41503,41536,41601,41672,41677,41681,41703,41778,41841,41860,41861,41898,41917,41942,41943,41944,41991,42003,42017,42045,42055,42071,42092,42096,42098,42107,42126,42152,42185,42205,42270,42318,42376,42387,42396,42585,42590,42639,42674,42690,42702,42708,42716,42742,42801,42826,42836,42890,42899,42900,42908,42920,42952,42991,42993,42998,43003,43013,43050,43051,43053,43078,43114,43120,43191,43204,43247,43248,43250,43274,43291,43300,43301,43335,43360,43363,43365,43386,43398,43412,43424,43528,43545,43546,43581,43599,43607,43651,43668,43688,43693,43700,43716,43725,43754,43828,43830,43831,43885,43887,44013,44038,44046,44051,44060,44079,44082,44094,44095,44112,44113,44116,44120,44128,44159,44162,44165,44175,44200,44208,44217,44220,44229,44263,44282,44312,44314,44327,44382,44384,44387,44406,44422,44426,44447,44453,44458,44479,44487,44500,44506,44509,44517,44527,44545,44562,44569,44572,44609,44662,44682,44761,44762,44786,44797,44928,44938,44950,45008,45024,45050,45066,45086,45089,45090,45091,45092,45093,45094,45095,45106,45131,45152,45183,45196,45203,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 | 883 | 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.74 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.23 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.41 ms |
preparing | 0.68 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 7.63 ms |
end | 0.03 ms |
query end | 0.03 ms |
closing tables | 0.07 ms |
freeing items | 0.14 ms |
cleaning up | 0.08 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 |