Tiempo de la consulta: 3.47 ms Después de la última consulta: 0.68 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 4.309 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-06 16:22:20')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 16:22:20')
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,49,131,133,139,155,246,337,340,342,343,347,348,350,352,476,500,609,782,844,929,953,986,1012,1022,1045,1157,1169,1204,1207,1367,1568,1708,1757,1819,1825,2129,2159,2222,2545,2590,2644,2729,2809,2880,3020,3082,3254,3279,3436,3440,3443,3464,3715,4039,4061,4476,4710,4720,4796,4840,4879,4894,4910,5047,5419,5472,5483,5545,5699,5801,5870,5938,6132,6145,6239,6262,6278,6279,6313,6442,6577,6616,6660,6912,6987,7223,7282,7311,7323,7415,7435,7466,7515,7526,7569,7572,7613,7617,7625,7651,7711,7732,7780,7789,7819,7882,7920,7929,7995,8027,8046,8073,8160,8187,8227,8242,8295,8352,8616,8832,8925,9091,9239,9571,9578,9581,9606,9838,9983,10059,10282,10314,10368,10412,10423,10442,10450,10462,10503,10511,10531,10562,10738,10761,10918,10951,10955,10970,11046,11111,11169,11195,11219,11390,11441,11508,11554,11712,11754,11918,12160,12300,12412,12582,12668,12685,12841,13108,13117,13404,13550,13587,13658,13692,13763,13827,13840,13919,13965,14077,14081,14108,14144,14186,14192,14197,14201,14208,14245,14349,14355,14376,14483,14485,14490,14503,14591,14615,14652,14658,14731,14740,14750,14768,14795,14815,14831,14840,14848,14985,15109,15150,15178,15195,15216,15245,15248,15254,15273,15286,15297,15305,15329,15369,15391,15422,15491,15520,15577,15606,15639,15641,15722,15740,15761,15838,15882,15894,15905,15940,15949,15981,16063,16192,16218,16227,16338,16358,16373,16375,16384,16427,16436,16461,16472,16513,16521,16528,16561,16576,16625,16675,16690,16777,16779,16814,16822,16926,17047,17071,17124,17260,17273,17285,17300,17314,17405,17466,17489,17555,17561,17610,17613,17651,17665,17688,17716,17729,17753,17773,17778,17924,17970,17974,17975,18008,18030,18045,18081,18101,18112,18135,18142,18163,18208,18216,18242,18293,18295,18297,18311,18348,18365,18431,18443,18451,18496,18516,18519,18524,18585,18624,18641,18693,18702,18705,18708,18723,18724,18764,18796,18814,18825,18839,18843,18853,18854,18875,18883,18947,18972,18981,18985,19004,19045,19072,19107,19122,19126,19174,19178,19189,19207,19222,19223,19229,19273,19284,19290,19314,19375,19378,19406,19414,19418,19439,19447,19455,19485,19494,19511,19607,19634,19644,19659,19687,19707,19731,19768,19792,19795,19812,19819,19832,19867,19870,19909,19954,19959,19995,20030,20045,20091,20104,20118,20129,20140,20163,20166,20196,20245,20260,20261,20274,20276,20299,20318,20334,20348,20357,20358,20377,20379,20400,20414,20429,20461,20478,20534,20564,20577,20579,20634,20653,20730,20731,20757,20771,20796,20812,20849,20899,20917,20932,20940,20974,20983,20993,21009,21060,21075,21086,21107,21145,21165,21171,21218,21239,21291,21323,21343,21350,21378,21384,21398,21492,21606,21609,21635,21714,21749,21777,21864,21880,21898,21945,21988,22026,22033,22038,22061,22072,22091,22097,22113,22123,22170,22231,22256,22270,22276,22318,22332,22349,22371,22395,22431,22458,22477,22487,22488,22489,22492,22495,22513,22524,22562,22579,22595,22611,22715,22734,22748,22773,22774,22783,22784,22804,22839,22859,22863,22879,22900,22920,22950,22951,22973,22996,23000,23014,23026,23033,23038,23055,23078,23096,23102,23147,23199,23221,23222,23227,23234,23239,23247,23266,23273,23279,23288,23347,23367,23388,23399,23485,23492,23519,23540,23568,23569,23611,23626,23638,23642,23646,23647,23662,23665,23695,23709,23716,23719,23774,23795,23878,23970,24100,24132,24166,24186,24217,24233,24242,24257,24258,24272,24275,24277,24283,24288,24291,24329,24368,24383,24392,24398,24411,24418,24437,24451,24471,24487,24565,24568,24581,24590,24601,24615,24666,24701,24705,24780,24813,24825,24835,24879,25002,25008,25065,25077,25116,25133,25187,25222,25225,25246,25258,25281,25300,25340,25341,25356,25359,25386,25413,25480,25483,25487,25590,25631,25664,25681,25726,25761,25765,25787,25807,25850,26061,26102,26112,26175,26177,26256,26375,26431,26435,26438,26492,26507,26640,26684,26835,26842,26843,26864,26910,26964,26985,27186,27197,27216,27219,27235,27252,27266,27305,27375,27384,27406,27475,27535,27565,27576,27633,27703,27717,27832,27833,27918,27921,27923,27924,27926,27931,27947,28310,28318,28320,28372,28418,28760,28779,28932,28979,29223,29239,29340,29347,29501,29535,29611,29613,29673,29871,29882,29918,29922,29930,30266,31908,31993,32400,33749,35613,35940,38932,39966,40286,41257,42054)
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.42 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.09 ms |
preparing | 0.54 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.34 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.04 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 |