Tiempo de la consulta: 4.76 ms Después de la última consulta: 0.67 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.316 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-05 00:36:52')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 00:36:52')
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(72,128,220,331,606,832,1071,1205,1410,1444,1461,1468,1476,1485,1508,1509,1576,1683,1701,1771,1907,1927,1994,2001,2015,2016,2019,2055,2106,2123,2125,2137,2161,2189,2220,2225,2226,2230,2256,2288,2290,2323,2344,2360,2424,2432,2436,2443,2444,2470,2507,2533,2551,2586,2597,2605,2638,2665,2670,2671,2675,2682,2699,2760,2762,2788,2811,2860,2865,2911,2927,2969,3008,3036,3114,3196,3206,3217,3224,3239,3240,3250,3294,3305,3345,3387,3426,3446,3462,3563,3575,3648,3661,3703,3720,3726,3919,3957,4053,4106,4155,4207,4262,4263,4312,4334,4385,4415,4468,4492,4506,4507,4520,4529,4558,4569,4580,4585,4586,4605,4653,4771,4794,4876,4931,4932,4955,4988,5006,5096,5104,5134,5150,5173,5214,5246,5306,5343,5356,5406,5415,5439,5469,5478,5487,5496,5512,5525,5534,5589,5635,5650,5653,5664,5701,5708,5728,5755,5781,5803,5914,5950,5959,5968,6034,6056,6070,6083,6130,6138,6173,6198,6285,6300,6372,6394,6396,6415,6424,6465,6468,6471,6497,6593,6597,6612,6613,6623,6680,6727,6820,6837,6894,6939,6958,6960,7018,7023,7025,7046,7086,7183,7191,7227,7266,7278,7324,7375,7423,7601,7664,7739,7780,7903,7925,7945,7953,8041,8045,8046,8051,8161,8185,8187,8217,8291,8314,8343,8373,8388,8424,8439,8460,8481,8498,8634,8670,8671,8714,8793,8913,8988,8993,9014,9015,9038,9062,9086,9087,9152,9169,9180,9220,9241,9250,9307,9359,9360,9378,9401,9498,9512,9519,9523,9536,9653,9654,9658,9709,9752,9776,9849,9851,9854,9929,9931,9998,10005,10011,10013,10068,10086,10156,10541,10702,10709,10895,11140,11147,11207,11212,11244,11288,11410,11440,11462,11465,11542,11562,11570,11602,11693,11694,11701,11788,11811,11814,11815,11850,11853,11854,11881,12006,12007,12034,12117,12135,12211,12242,12373,12438,12500,12502,12505,12550,12591,12650,12752,12839,12878,12886,12945,12995,13038,13202,13220,13264,13269,13287,13358,13530,13537,13592,13616,13722,13855,13896,13983,14126,14155,14171,14320,14333,14364,14425,14710,14713,14733,14759,14773,14862,14873,14927,14995,15002,15074,15257,15282,15312,15382,15478,15488,15502,15530,15719,15804,15806,15848,15865,16078,16220,16224,16341,16481,16545,16565,16578,16630,16634,16636,16649,16674,16693,16704,16742,16745,16772,16800,16880,16904,16913,16969,17009,17026,17055,17061,17062,17092,17117,17133,17137,17241,17301,17311,17313,17353,17354,17372,17377,17404,17427,17469,17527,17635,17641,17666,17746,17767,17770,17783,17798,17872,17940,17942,18068,18153,18265,18283,18326,18327,18352,18379,18384,18442,18476,18483,18491,18547,18548,18638,18779,18893,18927,18934,19089,19092,19112,19158,19292,19336,19392,19445,19483,19520,19541,19549,19570,19596,19637,19683,19693,19694,19765,19783,19789,19798,19800,19804,19809,19844,19853,19918,20113,20115,20280,20288,20396,20470,20624,20693,20694,20704,20818,20836,20861,20864,20883,20934,20997,21019,21027,21031,21033,21062,21095,21101,21146,21154,21175,21179,21203,21204,21206,21229,21233,21236,21268,21283,21302,21345,21354,21356,21358,21362,21387,21443,21488,21489,21511,21528,21536,21552,21592,21593,21604,21649,21657,21747,21769,21779,21784,21787,21805,21817,21818,21828,21837,21875,21940,21981,22037,22131,22147,22200,22244,22245,22246,22260,22275,22301,22311,22377,22401,22426,22450,22482,22537,22550,22585,22594,22652,22677,22821,22854,22912,22938,22939,22954,22968,22991,23030,23037,23111,23173,23183,23213,23273,23309,23334,23350,23509,23511,23860,23864,23894,23906,23983,24043,24133,24163,24172,24185,24205,24225,24338,24406,24407,24408,24416,24502,24609,24623,24628,24700,24744,24956,25030,25130,25379,25457,25622,25625,25682,25750,25772,25776,25818,25881,25912,25929,26003,26014,26031,26078,26108,26128,26136,26198,26263,26281,26328,26361,26362,26376,26378,26399,26403,26410,26447,26454,26471,26476,26487,26492,26554,26616,26626,26630,26679,26724,26740,26785,26800,26803,26804,26808,26839,26866,26875,26890,26894,26917,26926,26948,26950,26955,26992,27047,27055,27107,27109,27118,27120,27124,27133,27138,27161,27275,27287,27302,27322,27406,27421,27427,27445,27450,27457,27465,27491,27548,27550,27805,27833,28228,28392,28526,28661,28838,29100,29840,30273,30540,30556,30804,30810,31019,31827,32322,32369,32912,33440,33504,33505,33506,33507,33508,33509,33510,33511,33993,34185,34186,34199,34356,34368,34591,35676,35967,36049,36050,36189,36225,36265,36374,36375,38801,39171,39237,39335,39477,39487,39491,39572,39614,39645,39666,39907,39967,40734,41844,41977,42539,43025,44574)
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 | 764 | 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.49 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.14 ms |
statistics | 1.69 ms |
preparing | 0.78 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.42 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 |