Tiempo de la consulta: 3.70 ms Después de la última consulta: 0.62 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.161 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:19:18')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 17:19:18')
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(3,8,57,97,99,112,124,155,180,198,210,215,219,221,224,232,238,243,244,245,249,255,276,289,307,309,325,328,330,337,357,389,394,395,414,417,418,423,424,426,427,433,451,452,459,468,481,521,524,525,527,528,532,548,553,555,565,567,587,595,596,597,603,604,607,620,628,632,641,646,647,659,662,686,730,746,781,788,792,800,805,818,833,840,842,852,901,902,903,925,962,970,1007,1008,1015,1058,1066,1072,1100,1114,1119,1145,1165,1207,1227,1264,1268,1272,1274,1276,1277,1278,1325,1328,1337,1388,1389,1390,1394,1412,1504,1712,1754,1797,1800,1803,1839,1853,1922,1960,2007,2012,2048,2053,2086,2185,2355,2429,2463,2483,2489,2520,2532,2572,2580,2583,2589,2687,2732,2811,2827,2852,2857,3017,3026,3156,3167,3181,3269,3318,3337,3364,3415,3416,3417,3424,3473,3512,3517,3520,3603,3636,3704,3709,3732,3771,3776,3836,3853,3863,3980,4000,4017,4091,4116,4276,4281,4298,4301,4343,4345,4369,4373,4385,4413,4424,4517,4538,4561,4580,4620,4797,4832,4848,4955,5043,5045,5096,5125,5220,5243,5294,5301,5346,5357,5379,5417,5491,5582,5583,5637,5644,5646,5678,5702,5732,5759,5777,5794,5795,5804,5827,5831,5896,5899,5910,5919,5923,5978,6011,6016,6022,6059,6087,6112,6141,6183,6220,6258,6266,6312,6343,6371,6390,6559,6751,6758,6762,6855,6885,7048,7193,7201,7379,7473,7545,7549,7635,7650,7656,7691,7716,7760,7771,7829,7958,7960,7965,7969,8009,8015,8050,8070,8078,8081,8084,8087,8192,8215,8218,8247,8374,8398,8427,8461,8464,8537,8663,8805,8876,8909,8931,8982,9139,9175,9186,9237,9251,9254,9277,9294,9362,9431,9448,9660,9850,9993,10046,10128,10213,10215,10247,10289,10351,10479,10603,10708,10720,10753,10893,10971,11131,11150,11230,11302,11343,11559,11611,11719,11822,11826,11830,11836,12076,12258,12426,12568,12590,12697,12750,12758,12806,12982,13013,13028,13062,13077,13186,13215,13218,13238,13263,13285,13325,13365,13383,13415,13421,13432,13459,13511,13556,13558,13566,13590,13613,13622,13625,13753,13808,13833,13881,13903,13926,13986,13987,14015,14029,14053,14054,14147,14177,14193,14218,14238,14249,14571,14631,14651,14680,14725,14791,14810,14817,14820,14841,14885,14904,14914,14940,14949,14957,14969,15006,15054,15096,15138,15175,15213,15235,15244,15249,15314,15332,15469,15475,15490,15499,15518,15540,15547,15550,15579,15602,15612,15623,15627,15630,15648,15666,15667,15707,15835,15893,15902,15913,15925,15926,15966,16005,16015,16021,16024,16086,16164,16194,16213,16219,16264,16283,16336,16382,16402,16417,16443,16479,16560,16637,16664,16833,16844,16947,17004,17045,17115,17160,17183,17281,17292,17371,17410,17459,17470,17514,17536,17574,17584,17596,17601,17633,17715,17721,17723,17725,17776,17826,17838,17846,17976,18006,18046,18047,18067,18136,18151,18297,18311,18313,18378,18395,18421,18434,18437,18617,18655,18697,18752,18766,18792,18804,18853,18868,18874,18882,18886,18956,19006,19011,19062,19082,19164,19201,19267,19275,19293,19306,19313,19426,19592,19645,19646,19775,19796,19876,19976,20070,20145,20184,20247,20310,20337,20398,20457,20666,20733,20747,20783,20795,20821,20888,20917,20932,20963,21047,21050,21069,21102,21159,21179,21230,21258,21286,21294,21307,21313,21499,21548,21612,21632,21635,21774,21886,21955,22001,22028,22043,22109,22128,22252,22319,22325,22498,22512,22530,22531,22533,22540,22551,22567,22590,22607,22615,22648,22686,22738,22853,22930,22996,23019,23082,23182,23220,23302,23398,23415,23436,23673,23706,23737,23764,23822,23873,23960,24063,24101,24142,24184,24199,24286,24386,24419,24545,24550,24646,24662,24682,24702,24733,24767,24863,24962,24992,25041,25056,25125,25214,25250,25279,25465,25522,25563,25923,26104,26145,26361,26484,26728,26817,26858,26938,27024,27056,27307,27362,27365,27575,28072,28416,28423,28547,28561,28619,28646,28911,28961,29032,29066,29180,29221,29312,29329,29443,29504,29557,29640,29696,30111,30326,30478,30481,31533,31853,31899,32411,32731,33243,33874,34998,35884,36564,36602,37289,37656,37865,37915,38000,38691,39998,40053,40147,40545,41035,41074,41082,41184,41305,41460,42444,43388,43436,44866)
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 | 721 | 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.37 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.17 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 1.21 ms |
preparing | 0.59 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.31 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.02 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 |