Tiempo de la consulta: 8.36 ms Después de la última consulta: 1.15 ms Consulta a la memoria: 0.846 MB memoria antes de la consulta: 4.577 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-05 12:51:26')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 12:51:26')
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(80,133,181,197,198,215,216,221,224,225,254,262,269,280,323,325,364,367,390,394,412,440,468,474,596,601,622,641,642,650,681,686,690,711,790,805,808,854,875,957,976,1034,1036,1041,1066,1069,1071,1101,1126,1167,1172,1193,1205,1216,1266,1267,1339,1359,1407,1414,1425,1459,1467,1468,1492,1534,1574,1591,1637,1645,1659,1683,1686,1709,1721,1749,1766,1778,1805,1822,1828,1896,1932,1959,1962,1978,2200,2221,2418,2428,2451,2455,2478,2507,2574,2663,2685,2781,2855,2869,2946,2958,2961,2967,3000,3099,3114,3216,3224,3267,3398,3409,3594,3595,3597,3630,3801,3832,3868,3870,3872,3981,3984,4244,4301,4323,4338,4353,4354,4383,4410,4490,4547,4578,4667,4732,4799,4855,4882,4911,4935,4965,5053,5062,5078,5098,5147,5151,5166,5184,5195,5222,5237,5263,5273,5374,5381,5406,5424,5519,5584,5585,5680,5687,5700,5728,5755,5756,5782,5803,5835,5852,5906,5927,6014,6032,6056,6058,6068,6069,6133,6141,6172,6199,6222,6226,6276,6331,6335,6373,6510,6529,6532,6542,6543,6577,6585,6641,6666,6677,6716,6776,6779,6824,6830,6924,6939,7004,7048,7149,7156,7222,7278,7394,7423,7446,7534,7556,7560,7582,7624,7633,7686,7798,7812,7820,7904,7926,7968,8001,8026,8060,8178,8221,8239,8294,8296,8299,8306,8313,8327,8357,8416,8418,8504,8530,8532,8572,8588,8670,8678,8692,8710,8714,8810,8819,8835,8923,8940,8943,8948,8995,9046,9096,9110,9115,9140,9180,9186,9190,9199,9211,9238,9252,9339,9346,9362,9381,9498,9536,9541,9552,9573,9576,9641,9685,9731,9754,9756,9873,9915,9990,10006,10014,10044,10046,10113,10147,10198,10342,10355,10407,10448,10484,10604,10646,10702,10709,10774,11064,11142,11195,11207,11330,11410,11436,11465,11494,11533,11549,11557,11590,11704,11706,11715,11750,11772,11791,11801,11814,11828,11841,11859,11864,11937,11965,11979,12007,12189,12207,12244,12324,12334,12430,12440,12454,12477,12535,12550,12567,12628,12704,12754,12795,12802,12818,12830,12942,12998,13065,13069,13070,13086,13094,13112,13121,13188,13202,13209,13263,13269,13366,13472,13535,13537,13575,13637,13672,13678,13707,13722,13728,13798,13803,13894,13970,13972,13983,14020,14027,14048,14105,14132,14146,14154,14179,14291,14348,14352,14374,14430,14432,14494,14577,14602,14675,14741,14752,14769,14814,14857,14889,14890,14905,14930,14934,14969,14973,14995,14996,15015,15074,15077,15090,15133,15184,15186,15246,15262,15279,15313,15392,15409,15415,15475,15478,15546,15572,15594,15598,15627,15644,15706,15751,15753,15760,15834,15895,15902,15904,15960,15998,16010,16014,16027,16034,16040,16055,16078,16081,16108,16150,16160,16219,16269,16284,16361,16387,16390,16401,16440,16444,16455,16546,16570,16588,16596,16604,16642,16671,16698,16700,16718,16802,16826,16850,16892,16894,16903,16913,16959,16966,17014,17027,17087,17135,17148,17178,17189,17197,17202,17313,17338,17367,17378,17479,17520,17580,17611,17617,17629,17635,17643,17645,17811,17863,17870,17872,17883,17900,17959,17984,18014,18061,18068,18078,18083,18130,18137,18140,18166,18170,18178,18240,18276,18284,18286,18292,18306,18373,18382,18407,18423,18447,18452,18457,18483,18485,18491,18516,18534,18535,18582,18599,18622,18669,18683,18703,18744,18766,18781,18818,18879,18926,18974,18996,19019,19053,19112,19158,19204,19232,19286,19308,19316,19359,19364,19415,19432,19482,19514,19518,19533,19541,19547,19554,19585,19607,19637,19649,19665,19690,19720,19729,19742,19758,19776,19779,19783,19798,19823,19844,19897,19919,19940,19948,19967,20002,20046,20055,20082,20144,20150,20159,20228,20239,20280,20288,20309,20311,20323,20338,20386,20394,20402,20408,20422,20438,20452,20456,20470,20503,20521,20533,20592,20599,20637,20642,20648,20652,20677,20704,20713,20774,20776,20832,20911,20915,20934,20935,20958,20981,21013,21044,21060,21073,21090,21095,21119,21146,21147,21162,21174,21198,21201,21204,21227,21229,21304,21309,21335,21340,21341,21360,21415,21435,21480,21482,21489,21502,21567,21598,21602,21619,21622,21631,21651,21660,21697,21703,21704,21741,21779,21784,21801,21815,21830,21834,21840,21890,21911,21922,21932,21941,21942,21946,21962,21979,22011,22047,22055,22057,22129,22146,22154,22200,22337,22352,22362,22373,22400,22422,22482,22517,22551,22573,22581,22607,22615,22676,22737,22739,22767,22797,22802,22855,22869,22889,22914,22941,22959,22963,22992,23006,23014,23019,23035,23037,23104,23115,23145,23151,23178,23229,23309,23313,23332,23343,23474,23482,23509,23513,23547,23552,23648,23674,23675,23676,23718,23749,23788,23828,23833,23860,23871,23879,23880,23885,23935,23943,23948,23998,24046,24078,24107,24133,24163,24164,24181,24224,24225,24228,24248,24271,24309,24338,24363,24427,24434,24443,24458,24475,24477,24535,24617,24625,24630,24636,24700,24731,24763,24766,24851,24854,24880,24894,24896,24927,24967,24993,24995,25001,25013,25018,25040,25090,25091,25094,25114,25148,25167,25286,25296,25321,25367,25371,25372,25379,25390,25391,25393,25400,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,25511,25517,25536,25537,25538,25540,25545,25546,25552,25559,25569,25572,25576,25578,25582,25587,25588,25596,25625,25674,25682,25707,25736,25740,25742,25757,25758,25772,25776,25784,25831,25849,25860,25881,25885,25916,25929,25937,25941,25953,26000,26002,26003,26027,26044,26047,26066,26091,26108,26130,26263,26264,26297,26319,26328,26335,26362,26373,26396,26398,26403,26447,26458,26482,26506,26536,26550,26554,26572,26577,26578,26637,26653,26683,26694,26757,26759,26785,26787,26792,26793,26796,26846,26885,26890,26907,26929,26949,26958,26962,26968,27067,27095,27105,27106,27123,27144,27178,27179,27201,27203,27229,27237,27265,27342,27343,27378,27409,27548,27993,28079,28175,28230,28349,28440,28473,28534,28635,28741,28751,28870,28930,29222,29389,29495,29511,29626,30393,30394,30511,30575,30576,31463,31533,31620,31664,31725,31823,31975,32009,33389,33442,33605,33919,34030,34052,34071,34159,34243,34262,34270,34319,34375,34415,34449,34525,34560,34591,34611,34956,34978,35104,35171,35266,35324,35403,35436,35503,35596,35609,35626,35643,35822,35881,35950,35953,35959,36007,36011,36104,36121,36143,36153,36189,36190,36192,36204,36225,36238,36251,36265,36329,36335,36339,36343,36354,36374,36375,36378,36382,36419,36452,36490,36515,36617,36620,36736,36838,36850,37002,37056,37210,37338,37360,37396,37411,37422,37475,37524,37532,37681,37688,37714,37758,37791,37796,37916,38071,38199,38263,38363,38452,38585,38645,38664,38665,38693,38719,38762,38856,38933,38939,39095,39114,39169,39181,39196,39217,39227,39231,39319,39345,39376,39397,39624,39644,39687,39699,39716,39729,39757,39769,39826,39846,39896,39897,39958,39964,39977,40025,40082,40111,40183,40187,40212,40219,40225,40239,40292,40361,40379,40381,40392,40530,40650,40660,40665,40703,40912,40983,41059,41070,41095,41134,41146,41188,41204,41290,41297,41464,41491,41503,41601,41677,41681,41778,41795,41861,41968,41972,42107,42185,42205,42251,42303,42357,42387,42389,42396,42484,42590,42639,42708,42716,42836,42871,42890,42900,42919,42952,42977,42991,42993,42998,43025,43050,43051,43074,43078,43114,43120,43141,43191,43247,43248,43271,43274,43291,43300,43301,43335,43360,43365,43386,43398,43412,43424,43528,43546,43599,43651,43688,43700,43716,43725,43750,43858,43885,43905,44013,44046,44051,44060,44070,44079,44092,44094,44120,44128,44159,44165,44175,44200,44208,44229,44255,44263,44282,44312,44327,44382,44387,44406,44422,44433,44447,44453,44457,44458,44479,44487,44500,44517,44562,44609,44662,44682,44761,44762,44786,44797,44820,44833,44950,45008,45024,45050,45083,45086,45106,45131,45152,45159,45179,45183,45196,45208,45209,45257,45272,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 | 1301 | 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.64 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.24 ms |
System lock | 0.02 ms |
optimizing | 0.09 ms |
statistics | 1.91 ms |
preparing | 1.02 ms |
Sorting result | 0.16 ms |
executing | 0.01 ms |
Sending data | 3.10 ms |
end | 0.02 ms |
query end | 0.06 ms |
closing tables | 0.03 ms |
freeing items | 0.08 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 |