Tiempo de la consulta: 3.68 ms Después de la última consulta: 0.74 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 4.370 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 07:59:10')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 07:59:10')
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(5,7,9,14,29,39,56,60,62,63,65,71,73,86,87,149,164,174,177,196,221,226,240,259,262,291,299,331,349,355,366,391,428,429,472,477,481,495,501,510,525,530,531,534,561,563,569,619,659,662,663,667,674,697,705,746,769,800,802,805,806,808,823,832,835,869,873,910,923,939,940,954,959,969,974,977,982,983,999,1004,1005,1011,1021,1055,1091,1095,1114,1119,1123,1158,1182,1205,1231,1247,1252,1253,1255,1268,1271,1276,1289,1308,1309,1319,1347,1363,1409,1410,1428,1432,1441,1444,1485,1509,1557,1606,1619,1629,1648,1675,1693,1694,1724,1771,1794,1795,1796,1808,1810,1843,1854,1855,1862,1899,1918,1920,1930,1960,1961,1975,1984,1994,1995,2001,2008,2013,2015,2035,2075,2088,2131,2137,2155,2157,2161,2223,2242,2293,2455,2456,2527,2532,2551,2586,2597,2638,2643,2647,2814,2824,2834,2835,2843,2851,2856,2883,2888,2960,3027,3055,3100,3107,3147,3152,3169,3207,3291,3364,3368,3369,3387,3409,3412,3417,3473,3498,3520,3548,3552,3554,3590,3648,3683,3689,3700,3748,3853,3858,3872,3913,3919,3922,3962,3980,3991,4034,4038,4050,4068,4110,4129,4327,4333,4468,4529,4531,4532,4558,4616,4620,4622,4626,4666,4751,4752,4767,4813,4815,4822,4831,4844,4846,4865,4894,4933,4973,4984,5055,5134,5153,5160,5187,5211,5220,5370,5415,5469,5559,5702,5780,5795,5977,5999,6089,6148,6198,6338,6351,6391,6420,6435,6442,6476,6477,6548,6588,6845,6855,6933,6944,6958,7022,7030,7048,7137,7195,7242,7258,7324,7343,7418,7436,7491,7510,7516,7535,7592,7595,7648,7676,7751,7805,7819,7954,7960,8070,8086,8159,8169,8192,8291,8295,8314,8538,8592,8602,8634,8707,8779,8801,8895,8970,9237,9253,9277,9279,9291,9369,9401,9440,9488,9572,9854,9861,9930,10024,10453,10572,10668,10840,11001,11035,11142,11184,11417,11555,12049,12242,12398,12408,12639,12667,12692,12974,13034,13126,13246,13404,13896,13921,14077,14105,14180,14266,14454,14624,14632,14666,14701,14703,14714,14752,14865,14969,14976,15038,15063,15087,15111,15203,15214,15235,15273,15334,15351,15425,15426,15460,15533,15544,15574,15582,15604,15725,15726,15750,15781,15804,15807,15875,15900,15913,15915,15949,15969,15973,16038,16122,16224,16270,16301,16305,16324,16454,16498,16587,16588,16612,16648,16737,16791,16830,16841,16913,16963,16964,16995,17054,17055,17062,17130,17138,17140,17166,17218,17222,17277,17333,17341,17354,17372,17388,17425,17442,17486,17592,17625,17644,17646,17683,17699,17706,17715,17732,17737,17791,17798,17799,17806,17807,17813,17846,17907,17936,18008,18036,18109,18128,18183,18247,18274,18357,18383,18444,18480,18495,18542,18554,18625,18657,18692,18695,18699,18733,18754,18779,18802,18832,18961,18986,19000,19001,19015,19038,19077,19183,19187,19194,19228,19258,19269,19280,19282,19283,19289,19299,19302,19307,19323,19339,19351,19355,19368,19389,19400,19402,19421,19423,19427,19458,19470,19486,19503,19532,19533,19573,19578,19721,19800,19807,19818,19830,19918,19937,19946,19949,19956,20000,20007,20029,20044,20056,20057,20062,20153,20174,20177,20188,20215,20236,20278,20293,20304,20306,20327,20391,20498,20508,20524,20530,20600,20635,20662,20713,20718,20733,20743,20764,20774,20777,20784,20804,20813,20843,20851,20853,20858,20860,20870,20871,20879,20883,20920,20921,20944,20949,20954,20999,21074,21160,21168,21170,21217,21236,21253,21282,21313,21402,21468,21483,21505,21536,21569,21672,21733,21760,21787,21820,21878,21906,21969,22105,22127,22141,22145,22216,22273,22277,22283,22320,22328,22468,22508,22562,22563,22567,22603,22688,22706,22743,22847,22854,22877,23012,23130,23138,23170,23189,23202,23209,23224,23246,23256,23259,23304,23307,23393,23526,23536,23568,23569,23575,23599,23611,23617,23682,23698,23745,23768,23778,23786,23837,23875,23883,23895,23994,24064,24067,24072,24086,24116,24153,24189,24208,24219,24274,24282,24328,24415,24484,24526,24574,24585,24598,24609,24614,24641,24667,24682,24797,24853,24958,24973,25069,25274,25285,25323,25443,25456,25512,25534,25569,25598,25610,25632,25671,25721,25724,25847,25901,26014,26064,26177,26208,26215,26245,26386,26507,26554,26578,26582,26829,26860,26920,26937,26954,27076,27103,27133,27135,27156,27157,27490,27512,27805,27863,27904,27997,28248,28319,28402,28416,28702,28910,28918,28960,29033,29136,29214,29281,29345,30307,31114,31356,31671,32097,32374,32841,33259,33430,33593,33651,33784,33993,34008,34176,34300,34490,34573,34781,34782,34783,34793,35568,35755,35917,35962,36033,36135,36219,36398,36461,37408,37907,38448,38451,38549,38574,38602,38666,39135,39511,39598,39816,40050,40251,40279,40326,40603,40778,40803,40808,40829,40941,41256,41299,41311,41430,41522,41566,41622,41747,41816,41840,42021,42159,42259,42331,42500,42530,42701,42752,42799,42852,43488,43592,43609,43653,43815,43816,44185,44224,44270,44396,44402,44602,44743,44809,44868,45076,45276)
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 | 841 | 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.44 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.20 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 1.25 ms |
preparing | 0.62 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.29 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.05 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 |