Tiempo de la consulta: 9.95 ms Después de la última consulta: 1.14 ms Consulta a la memoria: 0.846 MB memoria antes de la consulta: 4.510 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 17:57:08')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 17:57:08')
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(72,138,141,177,181,196,198,215,216,218,221,224,225,237,254,262,280,325,330,332,373,394,474,522,527,528,583,596,641,642,647,650,681,686,723,746,757,826,828,841,845,854,875,976,986,996,1066,1071,1133,1207,1252,1253,1266,1267,1323,1326,1339,1359,1384,1467,1504,1534,1574,1587,1637,1659,1686,1709,1721,1778,1805,1896,1932,2032,2107,2167,2221,2272,2428,2455,2610,2687,2825,2855,2869,2925,3045,3077,3353,3354,3398,3425,3435,3443,3462,3476,3595,3630,3721,3801,3868,3870,4049,4106,4338,4456,4547,4578,4620,4680,4698,4767,4799,4855,4911,4935,4965,5053,5062,5098,5147,5151,5160,5166,5183,5184,5192,5195,5263,5273,5291,5313,5374,5390,5406,5519,5585,5646,5666,5730,5756,5782,5835,5846,5852,5894,5896,5906,5927,6014,6032,6069,6110,6142,6222,6226,6276,6373,6389,6458,6470,6498,6510,6531,6539,6542,6543,6549,6575,6641,6666,6677,6688,6716,6730,6779,6782,6799,6802,6836,6924,6939,6942,6965,7004,7014,7048,7052,7069,7124,7137,7156,7200,7222,7244,7302,7336,7339,7340,7411,7420,7421,7423,7446,7450,7513,7534,7556,7560,7588,7592,7621,7624,7673,7699,7710,7719,7725,7751,7776,7778,7799,7812,7831,7837,7850,7866,7889,7904,7926,7968,7975,8060,8089,8178,8258,8259,8273,8294,8296,8299,8306,8338,8354,8357,8377,8386,8417,8418,8509,8566,8572,8580,8617,8678,8710,8759,8810,8835,8860,8909,8923,8926,8940,8948,8995,9004,9046,9096,9110,9140,9180,9186,9190,9198,9199,9252,9362,9369,9381,9525,9541,9552,9576,9641,9663,9666,9685,9731,9733,9750,9773,9801,9873,9880,9915,9924,9956,9999,10014,10030,10044,10046,10101,10113,10114,10125,10147,10162,10274,10316,10342,10407,10774,10868,10981,11030,11057,11117,11194,11250,11253,11299,11408,11436,11440,11441,11465,11488,11549,11590,11693,11706,11714,11750,11772,11791,11857,11979,12000,12011,12318,12324,12334,12440,12550,12611,12620,12624,12628,12670,12685,12686,12708,12795,12811,12901,12973,12974,12998,13065,13069,13070,13094,13121,13126,13209,13224,13239,13246,13263,13264,13321,13332,13349,13452,13612,13728,13803,13851,13894,13900,13930,14048,14146,14153,14182,14192,14224,14263,14267,14352,14385,14428,14494,14516,14577,14591,14601,14631,14708,14741,14752,14754,14795,14857,14889,14953,14969,14992,15055,15077,15080,15090,15108,15118,15133,15147,15184,15186,15217,15279,15306,15347,15378,15382,15411,15421,15422,15440,15486,15493,15516,15598,15611,15613,15615,15627,15632,15639,15644,15685,15712,15714,15751,15753,15895,15899,15902,15904,15952,15953,15960,15998,16010,16038,16040,16055,16078,16089,16127,16156,16200,16214,16216,16219,16267,16284,16297,16303,16313,16390,16401,16430,16497,16570,16581,16588,16609,16641,16714,16719,16780,16812,16813,16863,16866,16913,16928,16936,16998,17014,17038,17039,17083,17116,17126,17134,17142,17148,17209,17217,17234,17275,17282,17344,17363,17381,17405,17408,17422,17458,17496,17573,17580,17595,17627,17629,17643,17644,17645,17661,17699,17710,17721,17734,17812,17889,17959,17968,17991,18014,18068,18075,18088,18151,18181,18184,18187,18191,18229,18241,18249,18260,18276,18284,18306,18316,18318,18348,18362,18382,18396,18419,18421,18423,18429,18452,18460,18489,18491,18494,18498,18509,18516,18552,18556,18582,18588,18599,18605,18609,18652,18656,18664,18675,18744,18750,18775,18801,18807,18816,18826,18845,18856,18864,18904,18908,18911,18933,18934,18945,18949,18953,18988,18989,18992,18994,19007,19019,19024,19027,19040,19050,19056,19059,19096,19104,19112,19125,19135,19145,19155,19189,19217,19226,19260,19261,19282,19286,19292,19303,19316,19346,19359,19364,19370,19400,19427,19432,19437,19492,19527,19533,19607,19655,19659,19742,19758,19783,19816,19835,19857,19873,19883,19922,19940,19950,19972,19980,20006,20010,20020,20024,20033,20039,20043,20052,20056,20115,20150,20177,20234,20237,20254,20356,20394,20402,20426,20448,20539,20550,20559,20601,20619,20624,20637,20638,20659,20677,20681,20704,20713,20776,20777,20823,20832,20837,20860,20866,20869,20946,20947,20967,21007,21013,21027,21033,21049,21087,21090,21094,21095,21103,21117,21118,21132,21135,21143,21174,21194,21207,21221,21235,21250,21294,21302,21340,21342,21361,21368,21380,21384,21390,21422,21435,21439,21491,21508,21520,21538,21553,21559,21583,21591,21617,21618,21648,21660,21664,21688,21692,21700,21701,21711,21727,21732,21761,21767,21808,21836,21907,21971,21982,21998,22015,22020,22030,22035,22037,22062,22081,22117,22131,22140,22149,22162,22164,22177,22222,22225,22228,22249,22285,22300,22323,22324,22337,22351,22352,22359,22362,22382,22400,22404,22415,22416,22502,22543,22551,22568,22573,22590,22615,22651,22676,22698,22737,22767,22797,22804,22841,22855,22898,22919,22941,22963,22985,22991,23014,23017,23028,23053,23065,23072,23089,23115,23181,23190,23192,23194,23264,23265,23285,23294,23299,23302,23304,23313,23328,23351,23369,23401,23452,23455,23476,23482,23483,23517,23615,23633,23668,23732,23788,23796,23805,23806,23879,23943,23965,24025,24060,24107,24127,24148,24155,24164,24172,24209,24356,24434,24458,24475,24523,24573,24580,24615,24710,24766,24785,24787,24805,24861,24875,24880,24894,24896,24927,24967,24975,24993,25001,25007,25013,25019,25040,25053,25062,25079,25089,25091,25094,25099,25100,25114,25122,25167,25170,25184,25276,25278,25296,25315,25321,25355,25367,25371,25372,25390,25391,25393,25411,25414,25420,25428,25431,25433,25439,25446,25451,25457,25459,25463,25464,25465,25467,25468,25472,25476,25482,25485,25486,25489,25492,25493,25494,25495,25498,25499,25504,25506,25508,25509,25510,25517,25522,25535,25536,25537,25538,25540,25545,25546,25552,25559,25569,25572,25576,25578,25582,25584,25587,25588,25596,25640,25649,25674,25694,25890,25891,25937,25941,25953,25954,26017,26044,26047,26082,26239,26334,26360,26362,26431,26504,26506,26554,26572,26577,26578,26587,26651,26652,26653,26683,26690,26694,26785,26787,26796,26806,26814,26871,26947,26962,27067,27095,27123,27189,27315,27342,27364,27397,27454,27518,27532,27541,27592,27624,27628,27635,27743,27744,27846,27873,27907,27955,27985,28046,28081,28240,28328,28361,28440,28534,28616,28627,28635,28728,28741,28751,28870,28882,28930,28944,28963,29222,29289,29389,29418,29590,29886,30482,30605,30606,30656,31055,31463,31533,31623,31624,31725,32115,32718,33331,33416,33605,34030,34071,34159,34195,34243,34262,34270,34375,34611,34881,34956,35266,35643,35674,35822,35881,36007,36117,36143,36251,36254,36339,36382,36617,36620,36838,36948,37002,37056,37411,37422,37524,37532,37688,37758,37796,38071,38199,38363,38452,38585,38664,38665,38710,38719,38762,38933,39227,39231,39397,39603,39625,39687,39769,39826,39896,39897,39958,39964,39977,40025,40081,40082,40183,40292,40404,40518,40530,40650,40703,40828,41025,41070,41095,41106,41134,41188,41204,41363,41464,41503,41601,41677,41681,41778,41861,42107,42157,42185,42205,42332,42387,42396,42590,42639,42652,42675,42702,42708,42716,42836,42890,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,43750,43885,44013,44046,44051,44060,44079,44094,44120,44128,44159,44165,44175,44200,44208,44229,44263,44282,44312,44327,44382,44384,44387,44406,44422,44447,44453,44458,44479,44487,44500,44509,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 | 1256 | 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.62 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.26 ms |
System lock | 0.02 ms |
optimizing | 0.10 ms |
statistics | 1.87 ms |
preparing | 0.96 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 4.95 ms |
end | 0.02 ms |
query end | 0.04 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 |