Tiempo de la consulta: 3.66 ms Después de la última consulta: 0.64 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.470 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-03 18:39:39')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-03 18:39:39')
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(71,119,185,220,255,271,272,283,323,331,400,403,429,495,537,569,657,689,722,808,832,863,868,937,940,1071,1101,1102,1216,1233,1250,1410,1444,1458,1459,1469,1485,1509,1576,1684,1701,1735,1745,1771,1887,1935,1975,1994,2001,2015,2016,2019,2051,2055,2061,2069,2101,2106,2123,2125,2137,2161,2180,2189,2220,2225,2226,2230,2254,2288,2290,2323,2343,2344,2360,2432,2436,2442,2443,2444,2470,2501,2507,2517,2520,2533,2551,2586,2587,2588,2597,2605,2638,2670,2674,2675,2682,2699,2760,2762,2776,2788,2802,2804,2811,2816,2860,2865,2911,2967,2968,2969,3001,3008,3036,3065,3075,3150,3154,3183,3196,3206,3208,3217,3224,3239,3240,3250,3303,3305,3312,3330,3343,3345,3346,3387,3426,3446,3462,3493,3515,3563,3569,3575,3597,3623,3637,3648,3661,3703,3720,3726,3750,3754,3919,3957,3983,4033,4034,4053,4106,4155,4205,4207,4262,4263,4312,4334,4385,4468,4492,4506,4507,4520,4529,4558,4569,4580,4876,4899,4932,4955,4958,4988,5079,5093,5095,5096,5104,5123,5134,5150,5173,5214,5246,5306,5343,5356,5415,5469,5478,5487,5496,5512,5513,5534,5536,5589,5635,5650,5653,5664,5701,5755,5781,5803,5914,5950,5959,6018,6034,6056,6070,6102,6130,6173,6198,6285,6300,6301,6315,6354,6363,6372,6394,6400,6415,6424,6465,6471,6516,6542,6543,6593,6597,6612,6613,6623,6680,6727,6750,6807,6808,6840,6872,6884,6886,6887,6894,6958,6964,6997,7018,7023,7025,7026,7046,7183,7227,7248,7278,7324,7369,7375,7483,7569,7571,7583,7601,7630,7664,7680,7739,7749,7780,7917,7945,7953,7987,8041,8045,8046,8051,8088,8161,8185,8206,8217,8291,8314,8343,8373,8388,8424,8439,8460,8481,8498,8634,8671,8740,8793,8907,8913,8927,8930,8937,8988,8993,8998,9014,9015,9048,9056,9057,9062,9070,9082,9086,9087,9152,9169,9200,9220,9241,9250,9307,9314,9359,9360,9401,9512,9519,9653,9658,9709,9764,9776,9825,9851,9854,9929,9931,9998,10005,10011,10059,10156,10195,10273,10421,10462,10973,11022,11124,11195,11207,11244,11318,11410,11562,11694,11788,11850,11854,12242,12268,12502,12591,12610,12650,12718,12846,12878,13029,13038,13129,13166,13220,13287,13524,13530,13548,13550,13573,13592,13641,13699,13712,13763,13821,13855,13896,13950,14081,14148,14159,14171,14188,14197,14333,14364,14428,14455,14675,14697,14710,14711,14713,14719,14722,14733,14769,14856,14862,15018,15049,15074,15158,15248,15406,15496,15530,15606,15740,15897,15964,15991,16178,16218,16270,16321,16325,16423,16432,16521,16603,16634,16649,16713,16733,16734,16745,16747,16808,16848,16967,17062,17086,17100,17133,17134,17137,17138,17157,17180,17197,17242,17309,17354,17388,17444,17453,17775,17777,17783,17835,17864,17883,17902,17938,18043,18112,18113,18129,18142,18281,18294,18295,18326,18338,18358,18409,18431,18491,18521,18717,18730,18763,18772,18779,18794,18826,18839,18867,19012,19086,19112,19126,19133,19217,19223,19541,19547,19653,19656,19679,19693,19754,19828,19855,19871,19873,19959,20163,20198,20396,20471,20564,20579,20614,20632,20680,20698,20704,20757,20840,20843,20993,21027,21165,21203,21217,21229,21313,21347,21369,21397,21405,21451,21488,21517,21554,21606,21610,21635,21732,21750,21846,21888,21926,21940,21952,22026,22040,22097,22180,22229,22234,22270,22276,22296,22311,22385,22414,22489,22527,22529,22533,22611,22622,22692,22699,22720,22749,22750,22784,22848,22960,23016,23040,23147,23156,23190,23198,23224,23245,23247,23325,23352,23361,23388,23399,23464,23485,23492,23511,23525,23566,23647,23654,23925,23983,24118,24119,24126,24152,24185,24192,24242,24277,24288,24312,24342,24370,24383,24398,24407,24416,24424,24440,24450,24451,24479,24498,24534,24601,24609,24643,24705,24747,24771,24826,24874,24891,24956,24980,25133,25222,25387,25413,25457,25631,25682,25787,25816,25940,25968,26017,26034,26061,26128,26202,26224,26261,26320,26325,26361,26376,26378,26410,26439,26471,26476,26487,26514,26570,26630,26640,26679,26706,26763,26766,26770,26800,26814,26866,26875,26887,26913,26917,26950,26992,27071,27138,27322,27421,27427,27475,27513,27805,27950,27974,28392,28526,28779,29107,29187,29200,29939,30273,30609,30854,31773,32241,32912,33621,33950,33993,34356,34368,34524,34584,34758,34927,35259,35305,35306,35676,35718,35967,36049,36050,36197,36423,37025,38383,38662,38784,38818,38865,38905,38962,39078,39171,39226,39296,39673,39808,39823,40734,40812,40864,40954,41254,41594,42074,42262,44362,45191)
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 | 760 | 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.58 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.33 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 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 |