Tiempo de la consulta: 9.15 ms Después de la última consulta: 0.95 ms Consulta a la memoria: 0.846 MB memoria antes de la consulta: 4.469 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 14:38:17')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 14:38: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(75,181,198,215,216,221,224,225,254,262,280,325,341,394,474,532,596,615,641,642,650,681,686,832,854,875,941,976,1066,1071,1073,1101,1216,1220,1257,1266,1267,1329,1339,1359,1425,1467,1534,1574,1633,1637,1659,1686,1709,1721,1753,1778,1805,1814,1896,1932,2221,2455,2554,2569,2773,2794,2855,2869,2893,2980,3204,3215,3234,3277,3283,3398,3486,3538,3594,3595,3624,3630,3702,3716,3733,3801,3863,3868,3870,3883,3906,3958,3979,3986,4028,4059,4063,4093,4136,4154,4172,4182,4194,4238,4260,4268,4302,4338,4405,4547,4564,4566,4578,4756,4799,4855,4911,4935,4950,4965,4968,5021,5053,5062,5098,5147,5151,5166,5182,5184,5195,5207,5215,5221,5232,5263,5273,5302,5374,5406,5519,5576,5585,5658,5687,5698,5731,5755,5756,5782,5835,5846,5852,5878,5879,5889,5906,5927,5967,6014,6032,6069,6084,6222,6226,6276,6373,6510,6542,6543,6553,6641,6658,6666,6677,6706,6716,6779,6780,6810,6924,6939,7004,7008,7048,7100,7102,7222,7329,7365,7382,7383,7397,7423,7446,7534,7536,7554,7556,7560,7564,7566,7627,7743,7812,7843,7846,7881,7904,7926,7938,7968,8060,8083,8099,8178,8186,8189,8223,8286,8294,8296,8299,8306,8307,8315,8357,8392,8397,8406,8418,8484,8536,8541,8571,8572,8678,8685,8710,8732,8747,8765,8810,8835,8907,8923,8939,8940,8948,8985,8995,9001,9046,9096,9110,9111,9114,9140,9151,9180,9186,9190,9199,9252,9362,9381,9398,9444,9454,9480,9541,9576,9607,9641,9685,9731,9741,9757,9873,9915,9928,9964,9971,9981,10014,10044,10046,10068,10113,10138,10147,10217,10342,10402,10407,10479,10566,10696,10758,10774,10790,10827,10842,10863,10922,11032,11140,11154,11179,11236,11288,11398,11421,11436,11465,11542,11549,11590,11641,11706,11717,11723,11750,11772,11791,11794,11798,11838,11859,11930,11969,11979,11990,11997,12034,12117,12206,12314,12324,12334,12440,12550,12614,12795,12852,12902,12998,13065,13069,13070,13094,13121,13201,13209,13218,13263,13268,13352,13454,13655,13698,13710,13728,13765,13803,13894,13925,13926,13955,13970,14037,14048,14083,14088,14115,14146,14154,14255,14314,14352,14385,14494,14524,14577,14609,14737,14741,14752,14766,14779,14811,14857,14889,14969,15002,15051,15077,15090,15115,15122,15133,15184,15186,15257,15272,15279,15286,15363,15488,15499,15568,15598,15627,15633,15643,15644,15715,15732,15751,15753,15864,15895,15902,15960,15980,15998,16010,16040,16055,16078,16135,16219,16284,16356,16359,16394,16401,16535,16570,16588,16594,16686,16784,16813,16857,16887,16905,16913,16955,17009,17014,17327,17359,17423,17434,17438,17547,17580,17629,17643,17730,17781,17837,17873,17953,17959,18014,18068,18073,18145,18153,18276,18284,18306,18382,18395,18423,18491,18511,18516,18527,18570,18576,18581,18582,18594,18599,18607,18617,18627,18697,18707,18744,18765,18812,18889,18900,18915,18952,18960,19011,19019,19025,19026,19050,19057,19089,19112,19158,19202,19256,19266,19286,19316,19359,19374,19401,19411,19432,19469,19533,19607,19610,19648,19713,19742,19758,19770,19783,19944,20009,20150,20164,20179,20356,20510,20589,20637,20704,20713,20776,20832,20919,20951,20962,21013,21019,21067,21072,21090,21146,21163,21171,21174,21179,21238,21239,21274,21311,21333,21340,21361,21379,21411,21435,21450,21455,21459,21467,21490,21562,21583,21592,21660,21675,21713,21775,21789,21886,21981,22001,22029,22181,22211,22272,22280,22286,22294,22337,22338,22352,22362,22400,22551,22573,22615,22664,22676,22687,22733,22737,22767,22783,22797,22855,22863,22912,22941,22963,23040,23042,23066,23067,23075,23109,23115,23128,23163,23278,23313,23362,23482,23541,23696,23788,23879,23943,23987,24059,24107,24164,24172,24235,24248,24434,24452,24458,24475,24674,24766,24880,24894,24896,24927,24967,24993,24999,25001,25013,25024,25040,25091,25094,25114,25167,25197,25296,25321,25347,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,25536,25537,25538,25540,25545,25546,25552,25559,25569,25572,25576,25578,25582,25587,25588,25596,25658,25674,25784,25932,25937,25941,25953,26044,26047,26114,26319,26362,26506,26554,26572,26577,26578,26653,26683,26694,26785,26787,26796,26962,27067,27095,27123,27183,27236,27279,27342,27954,28440,28534,28635,28741,28751,28870,28922,28930,29222,29387,29486,29719,29832,31463,31533,31725,33605,34030,34071,34159,34243,34262,34270,34375,34611,34956,35266,35643,35822,35881,36007,36143,36251,36339,36382,36617,36620,36838,37002,37056,37411,37422,37524,37532,37688,37758,37796,38071,38199,38363,38452,38585,38664,38665,38719,38762,38866,38903,38933,39035,39048,39111,39195,39227,39231,39335,39397,39480,39572,39645,39666,39687,39769,39826,39891,39896,39897,39907,39958,39964,39977,40025,40082,40183,40292,40441,40530,40558,40603,40650,40702,40703,41070,41092,41095,41114,41134,41188,41204,41219,41464,41503,41601,41677,41681,41694,41778,41861,42107,42185,42205,42387,42396,42590,42639,42708,42716,42836,42890,42900,42952,42991,42993,42998,43050,43051,43078,43114,43120,43133,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 | 942 | 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.57 ms |
preparing | 0.73 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 5.09 ms |
end | 0.03 ms |
query end | 0.11 ms |
closing tables | 0.04 ms |
freeing items | 0.16 ms |
cleaning up | 0.05 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 |