Tiempo de la consulta: 4.11 ms Después de la última consulta: 0.90 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.193 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-08 04:13:05')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-08 04:13:05')
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(1,70,71,72,73,75,170,186,205,215,254,263,275,330,452,583,607,628,816,868,895,917,1001,1207,1519,1716,1800,1819,1823,2073,2085,2159,2191,2290,2293,2305,2661,2689,2710,2809,2886,2887,3051,3067,3163,3164,3188,3208,3255,3317,3388,3393,3452,3486,3497,3529,3581,3604,3700,3713,3880,3986,4054,4084,4114,4146,4202,4209,4369,4375,4436,4475,4511,4512,4518,4570,4595,4731,4733,4734,4739,4796,4798,4842,4879,4914,4938,5047,5095,5276,5284,5292,5295,5304,5310,5313,5329,5382,5451,5456,5462,5489,5544,5603,5894,5916,6030,6031,6045,6047,6075,6115,6141,6242,6270,6313,6348,6417,6476,6477,6542,6543,6545,6616,6733,6766,6815,6900,7033,7148,7261,7318,7352,7417,7489,7510,7527,7537,7595,7625,7718,7741,7780,7883,7884,7912,7934,7950,7965,8026,8027,8074,8088,8160,8164,8179,8196,8229,8244,8305,8352,8356,8365,8381,8412,8435,8452,8476,8570,8598,8677,8698,8718,8730,8742,8753,8842,8860,8867,8876,8934,9007,9019,9047,9068,9103,9127,9187,9232,9244,9309,9311,9354,9383,9398,9466,9471,9501,9534,9569,9573,9581,9584,9617,9675,9684,9704,9715,9725,9760,9783,9794,9853,9893,9896,9911,9932,9934,9971,9977,10052,10059,10084,10113,10120,10122,10163,10210,10212,10268,10270,10282,10314,10368,10384,10392,10412,10450,10462,10503,10511,10531,10542,10628,10696,10708,10738,10754,10761,10774,10812,10918,10933,10951,10953,10971,10982,11032,11108,11120,11150,11152,11169,11219,11224,11240,11328,11373,11383,11422,11508,11534,11558,11607,11636,11712,11754,11806,11829,11886,11906,11907,11917,11918,11944,12063,12082,12115,12226,12274,12307,12384,12452,12513,12554,12565,12576,12623,12661,12662,12684,12743,12745,12746,12795,12806,12824,12834,12841,12844,12846,12928,12943,12953,12974,13069,13070,13083,13108,13110,13172,13175,13185,13186,13188,13295,13313,13425,13497,13523,13563,13633,13639,13658,13675,13728,13741,13764,13827,13881,13972,14005,14081,14141,14148,14226,14281,14297,14376,14385,14485,14490,14512,14566,14572,14652,14703,14731,14740,14782,14784,14795,14807,14810,14815,14824,14848,14988,14991,15014,15069,15105,15171,15207,15216,15248,15254,15277,15297,15322,15329,15369,15381,15391,15411,15422,15443,15475,15524,15527,15603,15606,15641,15693,15701,15734,15750,15798,15802,15857,15882,15885,15894,15931,15938,15976,16000,16115,16155,16192,16228,16277,16311,16338,16356,16358,16373,16384,16396,16412,16422,16436,16472,16479,16493,16495,16513,16515,16516,16547,16568,16593,16681,16705,16750,16779,16822,16874,16883,16889,16918,16937,16996,17066,17071,17090,17101,17114,17115,17132,17166,17205,17234,17260,17285,17299,17333,17407,17474,17499,17534,17561,17614,17643,17651,17715,17720,17729,17753,17773,17778,17792,17813,17821,17822,17852,17853,17857,17862,17913,17925,17935,17955,17956,17970,17993,18018,18032,18046,18047,18082,18135,18144,18163,18200,18260,18271,18282,18295,18377,18399,18421,18431,18450,18478,18506,18527,18562,18593,18614,18624,18719,18724,18725,18733,18740,18752,18773,18775,18793,18949,19018,19026,19072,19073,19117,19122,19126,19134,19143,19207,19223,19273,19284,19295,19318,19321,19381,19414,19429,19484,19494,19508,19545,19576,19596,19604,19606,19607,19667,19691,19713,19744,19764,19768,19787,19819,19825,19853,19882,19949,19959,19988,20009,20029,20080,20118,20163,20188,20260,20291,20299,20308,20324,20334,20360,20370,20377,20398,20414,20448,20455,20478,20542,20543,20610,20651,20663,20707,20714,20728,20737,20757,20758,20764,20771,20796,20820,20845,20849,20925,20945,20974,20977,20993,21027,21035,21058,21071,21099,21101,21138,21145,21158,21165,21167,21193,21195,21208,21233,21241,21274,21292,21322,21343,21372,21394,21445,21450,21584,21586,21617,21634,21635,21646,21669,21739,21760,21850,21907,21915,21921,21942,21986,21988,21995,21996,22002,22010,22041,22042,22053,22056,22097,22103,22170,22283,22307,22455,22458,22477,22488,22489,22513,22514,22595,22661,22688,22731,22741,22746,22773,22774,22799,22803,22820,22831,22839,22852,22858,22887,22901,22935,22973,22983,22989,23038,23041,23069,23070,23096,23102,23118,23221,23227,23234,23240,23243,23247,23282,23297,23321,23331,23334,23348,23433,23445,23449,23473,23484,23485,23486,23492,23532,23535,23540,23617,23635,23642,23664,23680,23743,23847,23851,23858,23859,23926,23951,23953,23992,24055,24166,24169,24177,24186,24226,24227,24251,24283,24288,24305,24323,24362,24383,24385,24398,24410,24428,24433,24464,24475,24513,24522,24532,24596,24601,24605,24615,24626,24632,24682,24701,24778,24800,24816,24941,24956,24959,24967,24969,25002,25031,25048,25070,25071,25133,25135,25222,25243,25258,25277,25340,25413,25423,25436,25480,25526,25566,25631,25657,25680,25681,25702,25765,25787,25851,25902,25946,26061,26147,26201,26228,26256,26317,26362,26391,26405,26432,26438,26492,26577,26640,26706,26734,26860,26910,27040,27125,27219,27231,27235,27252,27266,27305,27320,27362,27375,27406,27427,27475,27535,27565,27576,27802,27806,27833,27947,28022,28272,28310,28318,28320,28327,28410,28418,28458,28527,28528,28630,28728,28741,28760,28779,28803,28839,28867,28868,28932,28951,28952,29022,29189,29219,29222,29239,29251,29340,29347,29357,29501,29535,29673,29871,29882,29922,30266,30285,30404,32400,33877,33998,34273,35504,35940,38619,38974,39251,39384,39542,39646,39666,39819,40282,41350)
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 | 894 | 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.56 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.29 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.45 ms |
preparing | 0.68 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.36 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.13 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 |