Tiempo de la consulta: 3.86 ms Después de la última consulta: 0.51 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.452 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:16:11')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 00:16:11')
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(158,216,220,269,694,863,976,994,1099,1170,1322,1333,1334,1408,1897,2007,2034,2125,2461,2467,2574,2671,2720,2764,2765,2865,2898,3129,3247,3258,3305,3345,3371,3374,3387,3446,3468,3473,3523,3589,3609,3613,3618,3657,3661,3703,3774,3922,3948,3952,4068,4069,4088,4354,4451,4467,4468,4489,4490,4577,4741,4745,4771,4794,4821,4865,4866,4988,5113,5162,5191,5214,5333,5416,5469,5481,5578,5581,5684,5690,5697,5708,5887,5888,5972,6176,6299,6381,6396,6468,6497,6554,6631,6709,6733,6766,6820,6837,6939,6960,7018,7266,7456,7491,7953,8040,8087,8090,8187,8353,8538,8626,8895,8940,9262,9369,9480,9497,9518,9656,9716,9754,9776,9853,9930,9999,10011,10068,10156,10168,10468,10489,10541,10709,11147,11207,11398,11462,11465,11542,11549,11559,11625,11693,11694,11699,11788,11805,11815,11822,11854,12135,12242,12257,12324,12341,12500,12505,12550,12684,12752,12839,13202,13220,13264,13269,13348,13358,13454,13475,13489,13520,13616,13685,13705,13706,13896,13962,13974,14126,14261,14310,14364,14398,14425,14461,14733,14759,14873,14927,14975,15074,15087,15219,15282,15312,15324,15368,15594,15613,15689,15744,15794,15804,15806,15848,15969,15973,16155,16220,16224,16262,16481,16545,16578,16594,16630,16636,16648,16650,16674,16693,16704,16742,16772,16800,16880,16904,16913,16969,17014,17026,17055,17117,17137,17140,17172,17176,17242,17301,17333,17353,17361,17368,17372,17377,17413,17421,17427,17437,17527,17539,17586,17630,17737,17746,17767,17770,17783,17798,17823,17863,17905,17942,18036,18068,18077,18080,18096,18125,18184,18192,18265,18283,18291,18326,18327,18376,18383,18384,18442,18446,18476,18483,18547,18548,18587,18601,18638,18739,18790,18893,18927,18934,19112,19158,19168,19301,19306,19327,19397,19465,19547,19549,19596,19694,19729,19800,19804,19815,19845,19918,20033,20086,20128,20151,20177,20190,20392,20396,20624,20662,20693,20694,20760,20778,20836,20851,20861,20873,20883,20973,20997,21019,21027,21029,21031,21033,21036,21086,21096,21154,21168,21203,21206,21233,21236,21268,21283,21354,21356,21358,21361,21362,21488,21536,21592,21593,21688,21756,21769,21787,21805,21828,21837,21875,21933,21940,22033,22037,22100,22131,22180,22200,22219,22244,22245,22246,22260,22377,22401,22426,22522,22550,22585,22677,22689,22813,22854,22881,22938,22939,22954,22968,22991,22997,23076,23155,23168,23173,23238,23282,23334,23350,23402,23567,23775,23797,23799,23860,23906,24043,24163,24185,24406,24407,24408,24502,24623,24628,24865,24952,25030,25130,25445,25535,25576,25622,25625,25627,25750,25772,25813,25818,25912,26000,26003,26014,26031,26078,26108,26136,26198,26281,26362,26378,26399,26403,26410,26447,26454,26473,26478,26616,26626,26630,26769,26785,26803,26804,26839,26866,26871,26948,26950,26955,26957,27055,27107,27109,27118,27120,27124,27133,27161,27162,27175,27180,27184,27188,27197,27200,27215,27240,27275,27287,27302,27322,27342,27351,27412,27445,27450,27455,27457,27463,27465,27479,27491,27529,27548,27550,27581,27619,27685,27765,27854,27886,27913,27929,27965,28002,28051,28053,28305,28383,28409,28591,28625,28680,28870,28919,29013,29134,29242,29470,30810,31019,32322,33440,33504,33505,33506,33507,33508,33509,33510,33511,34185,34186,34329,34692,34717,34828,35245,35578,35597,35598,35634,35676,35798,35810,35834,35843,35861,35886,35922,35941,36521,36600,36698,36707,36737,36750,36847,36948,37031,37158,37206,38212,39321,39392,39752,40453,40563,40584,40902,42344,42494,43921,44100,44101)
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 | 582 | 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.43 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.15 ms |
System lock | 0.05 ms |
optimizing | 0.10 ms |
statistics | 1.30 ms |
preparing | 0.58 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.55 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 |