Tiempo de la consulta: 3.68 ms Después de la última consulta: 0.67 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.317 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 23:56:42')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 23:56:42')
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(11,49,58,60,61,62,63,64,65,67,68,75,255,272,278,281,307,331,344,350,380,385,389,396,405,417,435,441,586,607,686,697,701,717,760,844,857,903,946,970,978,1024,1168,1187,1207,1208,1277,1303,1304,1305,1319,1337,1506,1698,1788,1827,1851,2005,2112,2394,2489,2550,2732,2827,2828,2857,2962,3248,3340,3347,3364,3592,3603,3672,3696,3714,3732,3980,3982,4563,4587,5300,5491,5647,5648,5674,5685,5730,5732,5814,5827,5833,5894,5896,6012,6141,6142,6381,6411,6470,6473,6570,6616,6748,6751,6762,7125,7193,7201,7296,7377,7379,7432,7545,7623,7625,7691,7780,7801,7829,7838,7839,7860,7864,7929,7931,7946,7960,7965,7981,7985,8015,8058,8154,8159,8531,8555,8562,8663,8909,9351,9374,9445,9532,9556,9610,9895,9944,9945,10019,10243,10247,10280,10289,10351,10382,10383,10479,10561,10600,10673,10719,10834,10971,11129,11150,11230,11299,11328,11369,11377,11433,11482,11565,11611,11626,11688,11711,11719,11815,11822,11826,11836,12042,12076,12150,12184,12203,12238,12337,12422,12424,12466,12480,12500,12529,12536,12643,12668,12697,12750,12752,12758,12780,12914,12944,13004,13102,13152,13153,13218,13421,13511,13613,13657,13748,13750,13783,13808,13816,13828,13924,13926,13934,13952,14053,14054,14103,14132,14153,14249,14421,14424,14504,14523,14570,14596,14820,14838,14841,14879,14895,14949,14958,14974,15038,15114,15145,15183,15213,15244,15249,15331,15359,15368,15475,15493,15499,15522,15577,15632,15645,15669,15720,15757,15843,15870,15893,15913,15915,15926,15957,15975,16002,16023,16062,16083,16086,16162,16164,16194,16201,16264,16276,16322,16334,16418,16446,16464,16468,16520,16556,16560,16629,16664,16684,16791,16830,16844,16861,16957,17004,17105,17115,17181,17210,17218,17250,17253,17274,17314,17362,17443,17444,17459,17461,17466,17470,17471,17521,17596,17601,17630,17633,17650,17655,17704,17713,17715,17723,17761,17776,17846,17854,17867,17877,17898,17914,17933,17935,17994,18046,18047,18162,18229,18260,18285,18300,18311,18313,18364,18395,18434,18467,18504,18520,18563,18567,18570,18606,18617,18628,18645,18650,18671,18674,18697,18720,18746,18762,18768,18790,18794,18828,18886,18971,18972,19002,19006,19011,19018,19047,19060,19067,19106,19125,19133,19145,19148,19170,19177,19180,19185,19201,19208,19215,19247,19253,19272,19276,19285,19294,19306,19313,19327,19352,19376,19457,19460,19532,19577,19583,19620,19633,19645,19646,19668,19687,19732,19775,19811,19824,19858,19870,19908,19909,19934,19936,19998,20010,20028,20032,20056,20070,20074,20086,20141,20156,20164,20170,20187,20189,20212,20234,20247,20256,20263,20271,20275,20289,20353,20398,20449,20450,20488,20496,20516,20535,20542,20549,20564,20630,20714,20729,20747,20763,20783,20794,20795,20802,20836,20866,20888,20891,20982,21037,21050,21054,21105,21109,21154,21173,21179,21189,21198,21225,21286,21303,21307,21314,21317,21422,21432,21468,21499,21513,21520,21545,21547,21548,21611,21612,21620,21635,21636,21640,21678,21694,21738,21750,21764,21768,21770,21774,21814,21854,21873,21886,21908,21950,21980,22000,22001,22043,22066,22089,22100,22111,22128,22137,22146,22185,22193,22197,22204,22214,22229,22243,22297,22312,22319,22325,22337,22348,22361,22366,22429,22467,22533,22559,22607,22647,22648,22673,22674,22686,22712,22774,22807,22837,22853,22903,22908,22946,22980,22988,22996,23019,23025,23049,23186,23220,23275,23281,23295,23311,23374,23402,23403,23415,23420,23436,23495,23555,23572,23575,23585,23601,23610,23629,23636,23673,23706,23732,23737,23781,23816,23822,23840,23845,23858,23960,24028,24059,24063,24069,24084,24142,24159,24184,24194,24211,24308,24342,24348,24419,24451,24475,24489,24504,24540,24550,24586,24639,24646,24653,24656,24682,24688,24702,24707,24733,24759,24767,24791,24798,24804,24863,24884,24897,25024,25041,25045,25056,25107,25118,25125,25166,25184,25250,25263,25264,25279,25280,25315,25386,25548,25619,25634,25640,25657,25702,25715,25741,25775,25872,25887,25906,25919,25923,25945,25957,26013,26031,26051,26102,26105,26315,26493,26542,26640,26708,26711,26807,26930,26938,27012,27024,27056,27061,27072,27086,27097,27141,27143,27246,27348,27362,27365,27375,27560,27575,27650,27769,27870,27975,28082,28336,28431,28454,28495,28537,28561,28607,28640,28646,28882,28961,28989,29032,29066,29180,29257,29329,29412,29443,29454,29659,29802,30326,30481,30740,30991,31129,31213,31604,31853,32629,32905,34998,35603,35882,35884,36602,37078,37080,37915,38485,38834,39479,39998,40147,40170,40348,40545,40568,40777,40938,41032,41035,41082,41184,41263,41305,43839,44383,45035)
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 | 767 | 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.38 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.16 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 1.18 ms |
preparing | 0.59 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.37 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.05 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 |