Tiempo de la consulta: 3.94 ms Después de la última consulta: 0.74 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.181 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-07 15:10:41')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 15:10:41')
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,49,56,58,86,165,170,172,255,263,271,275,276,287,290,291,293,344,353,437,463,472,583,607,611,613,667,686,693,723,758,797,843,868,883,895,900,905,917,958,963,997,1031,1095,1207,1232,1247,1271,1339,1486,1613,1718,1931,1935,2051,2061,2180,2225,2242,2290,2293,2305,2308,2343,2344,2360,2365,2436,2442,2443,2444,2470,2501,2513,2520,2586,2587,2588,2639,2682,2685,2757,2760,2776,2788,2796,2802,2816,2860,2863,2953,2968,2997,3008,3020,3028,3036,3045,3075,3124,3125,3138,3150,3172,3209,3212,3250,3330,3488,3512,3515,3604,3623,3637,3671,3738,3776,3842,3894,3986,4033,4034,4053,4120,4128,4169,4205,4207,4262,4399,4549,4580,4878,4899,4902,4958,5350,5365,5451,5471,5536,5559,5647,5675,5730,5894,6018,6039,6070,6127,6131,6139,6234,6340,6405,6440,6470,6473,6475,6484,6486,6516,6520,6542,6543,6573,6616,6630,6656,6688,6693,6710,6723,6742,6744,6750,6827,6835,6860,6884,6886,6887,6889,6895,6906,6936,6985,6998,7015,7232,7251,7343,7361,7369,7447,7484,7496,7545,7571,7586,7588,7677,7680,7730,7785,7832,7847,7894,7934,7949,7950,7959,7965,7987,7997,8012,8027,8109,8128,8143,8279,8442,8508,8566,8671,8930,8998,9070,9207,9318,9744,9754,9863,9948,10085,10100,10110,10149,10156,10176,10203,10250,10306,10311,10382,10385,10421,10508,10623,10697,10721,10778,10782,10872,10951,10954,10957,10974,11015,11063,11083,11124,11173,11207,11226,11394,11479,11534,11712,11766,11883,11987,12268,12270,12306,12449,12545,12581,12582,12624,12625,12789,12851,12878,12894,12945,12978,13038,13130,13220,13225,13241,13307,13332,13420,13450,13508,13515,13611,13699,13778,13851,13855,13896,13940,13968,13972,13998,14048,14086,14097,14114,14183,14205,14236,14333,14361,14372,14453,14455,14507,14509,14613,14630,14684,14697,14719,14811,14845,14852,14856,14862,14983,15007,15038,15129,15130,15155,15156,15158,15214,15217,15304,15310,15335,15351,15376,15406,15424,15475,15520,15522,15551,15581,15600,15668,15689,15700,15719,15740,15742,15757,15785,15790,15812,15866,15880,15903,15964,15991,16042,16095,16127,16249,16323,16357,16366,16384,16415,16427,16431,16432,16521,16538,16551,16645,16675,16747,16775,16781,16816,16827,16841,16848,16967,16996,17049,17103,17116,17188,17227,17228,17240,17242,17246,17250,17285,17288,17331,17387,17388,17407,17444,17453,17497,17510,17561,17573,17630,17634,17711,17736,17766,17777,17779,17822,17834,17852,17862,17864,17919,17925,17930,17936,17950,17967,17983,18043,18044,18061,18121,18222,18240,18260,18276,18281,18294,18295,18311,18382,18505,18552,18664,18668,18670,18682,18693,18698,18728,18730,18794,18830,18839,18846,18874,18877,18888,18905,18948,19012,19015,19026,19051,19064,19105,19111,19124,19128,19133,19140,19173,19175,19207,19287,19288,19315,19322,19349,19381,19444,19448,19484,19486,19516,19607,19639,19656,19679,19684,19708,19710,19725,19727,19733,19754,19794,19807,19923,19959,19962,19976,20033,20089,20099,20119,20127,20149,20174,20175,20220,20256,20317,20397,20437,20445,20542,20549,20587,20614,20632,20638,20654,20659,20668,20680,20686,20714,20739,20772,20777,20785,20797,20843,20897,20940,20959,20973,20993,20996,21113,21117,21118,21141,21143,21157,21216,21217,21229,21313,21344,21346,21367,21398,21420,21421,21451,21457,21470,21520,21522,21554,21579,21610,21635,21663,21667,21684,21702,21741,21764,21776,21778,21795,21798,21846,21852,21883,21888,21906,21917,21950,21952,21968,21997,22021,22038,22067,22098,22106,22119,22124,22150,22171,22178,22212,22278,22290,22298,22316,22389,22450,22460,22476,22527,22529,22533,22555,22570,22672,22699,22706,22735,22745,22749,22750,22753,22759,22820,22840,22854,22901,22944,22960,23034,23041,23046,23070,23093,23148,23190,23224,23242,23245,23253,23267,23279,23305,23352,23361,23363,23367,23368,23383,23405,23423,23430,23438,23464,23488,23501,23503,23525,23553,23555,23566,23615,23730,23790,23816,23838,23849,23925,23926,23955,23968,23978,23983,23990,24024,24025,24076,24118,24126,24147,24164,24193,24219,24237,24370,24403,24407,24411,24424,24433,24440,24456,24530,24534,24557,24584,24597,24616,24690,24701,24732,24748,24771,24779,24805,24830,24841,24874,24941,24946,24963,24980,25037,25048,25080,25081,25117,25287,25297,25329,25386,25452,25523,25535,25560,25561,25591,25657,25676,25807,25888,25919,25934,25971,25990,26043,26048,26102,26161,26224,26229,26261,26320,26325,26483,26488,26514,26519,26525,26596,26675,26767,26814,26854,26873,26901,26913,26959,27001,27041,27061,27062,27074,27158,27290,27318,27397,27407,27471,27518,27552,27578,27646,27707,27745,27851,27950,28066,28094,28213,28264,28283,28749,28799,28826,28928,29061,29073,29473,29500,29539,29719,29787,30284,31010,32840,36165,36303,38383,38961,39063,39323,39841,39981,39998,40168,40347,40611,40864,43718,44362)
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 | 819 | 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.50 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.17 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.40 ms |
preparing | 0.73 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.47 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.08 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 |