Tiempo de la consulta: 3.23 ms Después de la última consulta: 0.53 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.163 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:40:10')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 17:40:10')
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(4,9,11,25,28,56,76,86,165,192,255,263,271,275,276,323,463,472,505,507,583,607,611,613,686,723,758,795,805,808,868,883,895,900,914,917,942,958,963,1031,1101,1125,1216,1262,1271,1285,1407,1459,1492,1521,1718,1771,1816,2089,2290,2293,2305,2365,2569,2639,2796,2863,2958,2961,3114,3227,3249,3444,3512,3604,3651,3749,3832,3898,3910,3984,3986,4379,4381,4549,4580,4726,4750,4810,4878,4902,5076,5221,5348,5350,5365,5451,5647,5675,5696,5730,5894,6038,6049,6127,6308,6309,6345,6353,6370,6405,6469,6470,6473,6475,6492,6520,6539,6542,6543,6557,6573,6614,6630,6656,6664,6670,6671,6688,6723,6742,6744,6835,6860,6889,6895,6906,6936,6985,7015,7062,7232,7338,7343,7483,7543,7545,7586,7588,7596,7730,7832,7913,7914,7934,7950,7959,7997,8027,8076,8080,8089,8109,8143,8290,8373,8404,8508,8551,8577,8582,8596,8784,8859,8907,9028,9399,9544,9849,9857,10090,10091,10110,10176,10203,10250,10306,10311,10329,10385,10448,10501,10658,10689,10697,10859,10872,10890,10947,10951,10954,10974,11015,11063,11083,11138,11173,11195,11226,11394,11479,11531,11532,11534,11618,11621,11693,11712,11727,11766,11834,11883,11930,11987,12138,12141,12152,12205,12270,12306,12333,12449,12479,12531,12545,12624,12625,12789,12894,12945,12954,13025,13220,13225,13241,13363,13475,13477,13508,13567,13611,13744,13851,13855,13968,13972,13974,13980,13998,14016,14048,14097,14114,14183,14205,14236,14338,14361,14374,14507,14684,14699,14705,14789,14795,14811,14856,14876,15023,15038,15217,15300,15304,15310,15323,15531,15551,15589,15625,15757,15866,15896,15903,15943,15992,16051,16112,16216,16246,16366,16398,16415,16431,16432,16529,16645,16775,16829,16977,16996,17043,17206,17227,17228,17238,17242,17285,17349,17407,17493,17510,17634,17695,17753,17766,17842,17852,17883,17925,17950,18121,18173,18249,18276,18294,18311,18456,18505,18668,18670,18682,18698,18730,18833,18835,18846,18874,18893,18948,19026,19046,19051,19064,19133,19175,19207,19241,19288,19322,19349,19444,19484,19516,19727,19801,19870,19962,19976,20017,20033,20089,20099,20127,20149,20174,20220,20230,20256,20317,20397,20437,20452,20453,20503,20549,20587,20654,20668,20677,20686,20698,20714,20739,20785,20797,20897,20905,20973,20993,21113,21207,21216,21279,21280,21284,21333,21346,21420,21579,21667,21794,21798,21803,21822,21846,21852,21900,21950,21962,22038,22098,22124,22150,22171,22202,22212,22290,22351,22389,22565,22672,22706,22753,22774,22818,22854,22901,22926,23040,23041,23046,23070,23148,23253,23267,23305,23363,23383,23423,23453,23454,23488,23501,23566,23570,23574,23615,23648,23695,23730,23790,23807,23816,23838,23926,23978,23990,24024,24025,24118,24147,24193,24216,24219,24228,24403,24411,24433,24440,24456,24462,24510,24529,24557,24597,24616,24685,24701,24732,24748,24763,24830,24841,24941,25048,25080,25110,25167,25287,25334,25386,25398,25452,25535,25560,25561,25591,25621,25657,25717,25801,25860,25888,25934,25990,26043,26102,26123,26161,26195,26295,26373,26483,26488,26519,26525,26534,26758,26901,27039,27041,27074,27189,27337,27397,27407,27471,27518,27548,27549,27800,28799,28928,29366,29464,29473,29500,30242,30243,30244,30284,31010,32056,34602,34701,34733,35164,35192,35233,35318,35321,35393,35533,35790,35836,35859,35958,35960,36014,36310,37514,37516,37517,38658,38659,38660,38779,38788,38815,38961,39063,39323,39576,39820,40347,40521,40633,40831,40886,41914,41934,42243,42378,42424,42775,42880,43501,43791,43971,43976,44853,45200,45251)
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 | 598 | 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.03 ms |
init | 0.16 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 1.06 ms |
preparing | 0.46 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.41 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.06 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 |