Tiempo de la consulta: 10.52 ms Después de la última consulta: 1.07 ms Consulta a la memoria: 1.276 MB memoria antes de la consulta: 4.214 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-07 06:52:52')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 06:52:52')
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(64,157,181,193,198,215,216,218,221,224,225,254,257,262,275,280,311,325,394,401,466,471,474,482,499,543,560,596,610,635,641,642,643,650,661,680,681,685,686,692,700,703,709,713,736,761,772,783,786,814,854,859,868,875,960,968,976,984,998,1024,1032,1034,1042,1048,1066,1071,1079,1098,1106,1127,1138,1142,1150,1151,1172,1192,1194,1226,1255,1266,1267,1269,1271,1279,1280,1295,1305,1322,1339,1349,1359,1375,1420,1421,1433,1435,1441,1444,1445,1447,1454,1455,1460,1466,1467,1476,1481,1484,1534,1553,1574,1586,1595,1624,1637,1659,1664,1686,1709,1721,1778,1805,1811,1812,1841,1852,1855,1870,1896,1903,1906,1932,1984,2001,2077,2148,2177,2193,2199,2221,2301,2359,2408,2428,2432,2455,2469,2480,2629,2631,2691,2773,2855,2869,2897,2989,3056,3119,3202,3278,3355,3364,3398,3513,3590,3594,3595,3630,3663,3801,3836,3868,3870,3872,3992,4075,4132,4168,4176,4197,4252,4271,4338,4477,4523,4547,4558,4578,4580,4585,4586,4587,4605,4799,4855,4874,4892,4911,4935,4965,5014,5053,5062,5079,5098,5147,5151,5166,5184,5195,5226,5263,5273,5374,5406,5496,5507,5508,5519,5534,5585,5756,5782,5835,5852,5876,5906,5927,5990,6014,6032,6068,6069,6133,6222,6226,6276,6308,6323,6325,6373,6461,6510,6533,6542,6543,6596,6641,6663,6666,6667,6677,6707,6716,6779,6842,6924,6939,7004,7048,7182,7200,7222,7237,7277,7421,7423,7435,7446,7534,7556,7560,7626,7688,7709,7748,7802,7812,7830,7839,7843,7860,7868,7870,7904,7926,7946,7951,7968,8060,8069,8091,8108,8178,8206,8294,8296,8299,8300,8306,8357,8400,8418,8518,8572,8678,8710,8711,8810,8835,8907,8923,8938,8940,8944,8948,8995,9005,9046,9048,9096,9108,9110,9140,9180,9186,9190,9199,9252,9362,9366,9381,9396,9462,9541,9576,9641,9685,9731,9873,9879,9915,10014,10044,10046,10113,10135,10147,10316,10342,10373,10407,10501,10725,10736,10774,10775,10834,10851,10923,11195,11223,11314,11436,11465,11549,11590,11705,11706,11750,11772,11774,11791,11859,11979,12089,12170,12238,12324,12334,12413,12440,12550,12795,12816,12946,12994,12998,13060,13065,13069,13070,13078,13094,13121,13160,13209,13258,13263,13272,13297,13316,13319,13344,13437,13438,13467,13480,13481,13482,13503,13525,13660,13728,13797,13803,13824,13894,13968,13978,14048,14146,14153,14177,14205,14244,14294,14309,14352,14432,14493,14494,14506,14546,14577,14624,14641,14710,14741,14752,14857,14874,14889,14958,14969,15063,15077,15090,15133,15138,15147,15184,15186,15216,15229,15279,15307,15359,15370,15420,15464,15507,15543,15551,15567,15577,15598,15627,15628,15632,15716,15722,15751,15753,15895,15902,15960,15982,15998,15999,16010,16040,16052,16055,16078,16136,16216,16219,16258,16284,16386,16395,16401,16466,16569,16570,16588,16607,16629,16634,16774,16780,16791,16913,17014,17126,17131,17224,17555,17580,17629,17643,17654,17658,17660,17730,17780,17799,17836,17892,17915,17921,17959,18013,18014,18037,18039,18055,18068,18160,18174,18181,18202,18276,18284,18306,18382,18411,18423,18466,18491,18516,18550,18567,18582,18599,18660,18744,18813,18900,18901,18916,19019,19043,19112,19286,19316,19335,19343,19359,19374,19407,19432,19505,19533,19596,19607,19612,19704,19742,19758,19773,19783,19797,19853,19885,20004,20043,20051,20142,20150,20202,20242,20265,20404,20568,20569,20602,20637,20704,20713,20739,20773,20776,20832,20871,20933,21013,21090,21174,21189,21205,21284,21340,21435,21438,21601,21620,21660,21691,21821,22173,22337,22352,22362,22400,22415,22416,22551,22573,22615,22653,22676,22737,22756,22767,22797,22848,22855,22864,22872,22941,22963,23031,23039,23101,23114,23115,23221,23296,23313,23344,23394,23406,23482,23547,23592,23593,23638,23691,23715,23722,23747,23769,23788,23860,23879,23943,23954,24017,24052,24107,24164,24170,24172,24198,24248,24434,24455,24458,24475,24524,24583,24599,24601,24766,24819,24838,24880,24894,24896,24927,24967,24993,25001,25010,25013,25039,25040,25091,25094,25114,25141,25167,25172,25197,25278,25284,25292,25296,25317,25321,25326,25367,25371,25372,25390,25391,25393,25414,25431,25433,25438,25446,25451,25457,25459,25464,25465,25467,25468,25472,25476,25482,25485,25486,25489,25491,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,25621,25674,25693,25705,25717,25881,25937,25941,25943,25953,25964,26044,26047,26109,26154,26167,26348,26353,26362,26468,26506,26530,26554,26572,26577,26578,26653,26683,26694,26722,26753,26785,26787,26796,26797,26807,26852,26909,26944,26945,26962,27035,27046,27067,27095,27123,27237,27280,27311,27342,27383,27491,27573,27610,27742,27779,27842,27859,27974,28189,28233,28306,28440,28534,28598,28628,28635,28741,28746,28751,28870,28930,29174,29222,29373,29548,29864,30562,31384,31463,31533,31725,32530,32919,33345,33605,34030,34071,34159,34174,34243,34262,34270,34375,34611,34676,34956,35226,35266,35299,35337,35360,35379,35434,35596,35643,35780,35822,35881,36007,36085,36143,36251,36297,36339,36382,36617,36620,36751,36817,36838,36961,37002,37034,37056,37107,37116,37170,37397,37403,37411,37422,37439,37454,37524,37532,37688,37758,37796,38006,38071,38103,38114,38122,38128,38199,38315,38343,38363,38398,38440,38446,38452,38530,38549,38585,38664,38665,38674,38719,38762,38933,39027,39052,39150,39163,39193,39227,39231,39245,39276,39315,39319,39347,39375,39389,39397,39475,39492,39609,39687,39706,39722,39747,39768,39769,39802,39826,39896,39897,39958,39964,39977,40018,40025,40082,40089,40183,40231,40276,40292,40398,40436,40438,40460,40465,40530,40535,40554,40555,40562,40614,40650,40667,40688,40703,40774,40811,40817,40959,41040,41068,41070,41095,41134,41150,41188,41204,41220,41246,41322,41418,41436,41464,41499,41503,41570,41576,41601,41649,41677,41681,41724,41778,41797,41800,41839,41861,41865,41871,41879,41896,41927,41956,41957,42040,42054,42057,42065,42091,42107,42134,42154,42163,42174,42185,42188,42205,42212,42304,42387,42396,42405,42448,42490,42538,42572,42590,42639,42703,42708,42716,42729,42765,42800,42806,42836,42863,42890,42900,42952,42991,42993,42998,43009,43050,43051,43078,43114,43115,43120,43136,43143,43191,43222,43234,43244,43247,43248,43274,43291,43294,43300,43301,43335,43345,43360,43365,43386,43398,43412,43424,43459,43508,43509,43528,43539,43546,43550,43565,43596,43599,43601,43605,43615,43651,43682,43688,43700,43716,43725,43846,43885,43979,44013,44026,44046,44051,44060,44079,44094,44120,44128,44159,44165,44175,44177,44184,44200,44208,44229,44263,44282,44312,44327,44351,44382,44387,44400,44406,44422,44431,44447,44453,44458,44479,44487,44491,44500,44517,44544,44562,44588,44609,44611,44613,44662,44682,44701,44761,44762,44786,44797,44894,44908,44941,44950,45008,45024,45050,45051,45086,45106,45131,45136,45152,45157,45183,45196,45208,45209,45257,45275,45302,45303,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 | 1171 | 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.55 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.22 ms |
System lock | 0.02 ms |
optimizing | 0.08 ms |
statistics | 1.80 ms |
preparing | 0.92 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 6.07 ms |
end | 0.02 ms |
query end | 0.03 ms |
closing tables | 0.02 ms |
freeing items | 0.07 ms |
cleaning up | 0.03 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 |