Tiempo de la consulta: 4.53 ms Después de la última consulta: 0.99 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.451 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-04 00:31:46')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 00:31:46')
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(2,5,7,9,14,29,39,46,56,57,58,60,62,63,65,71,73,83,86,87,90,92,99,149,164,174,177,185,189,196,215,221,224,226,232,240,243,244,245,246,249,259,262,276,291,299,309,328,330,331,337,338,340,345,346,349,350,352,366,391,412,417,418,427,428,429,433,466,468,471,472,477,481,482,501,510,521,525,528,530,531,546,548,553,555,563,595,596,597,603,605,607,609,619,641,646,647,659,662,663,667,670,674,697,705,706,711,721,730,746,769,781,782,800,802,805,808,818,823,832,835,869,873,905,910,923,939,940,954,969,974,977,982,983,994,999,1004,1005,1011,1021,1022,1023,1055,1066,1072,1091,1095,1114,1119,1145,1158,1182,1196,1205,1231,1236,1247,1252,1253,1255,1264,1268,1271,1272,1274,1275,1276,1277,1278,1289,1308,1309,1314,1319,1325,1347,1350,1363,1389,1390,1409,1410,1412,1428,1432,1441,1444,1462,1485,1504,1509,1557,1606,1619,1629,1643,1648,1675,1693,1694,1713,1724,1771,1794,1795,1796,1805,1808,1810,1826,1828,1843,1854,1855,1862,1899,1918,1920,1930,1960,1961,1975,1984,1994,1995,2001,2008,2012,2013,2015,2035,2075,2088,2137,2155,2157,2161,2185,2265,2293,2355,2386,2455,2476,2527,2532,2551,2586,2597,2601,2638,2643,2811,2814,2824,2851,2852,2859,2883,2888,2960,3017,3027,3055,3100,3107,3147,3169,3181,3207,3269,3318,3364,3368,3369,3387,3409,3412,3436,3440,3464,3473,3512,3520,3548,3552,3554,3557,3590,3648,3683,3689,3715,3727,3748,3750,3825,3853,3858,3866,3868,3872,3913,3919,3922,3962,3985,3991,4021,4034,4050,4068,4110,4129,4214,4245,4289,4327,4334,4355,4360,4413,4457,4468,4485,4495,4517,4529,4532,4558,4561,4616,4620,4622,4626,4666,4673,4751,4752,4767,4813,4815,4822,4831,4844,4846,4865,4933,4973,5055,5134,5153,5160,5220,5357,5370,5392,5415,5417,5437,5469,5484,5495,5533,5559,5560,5582,5583,5637,5646,5678,5702,5732,5759,5768,5777,5779,5780,5793,5794,5795,5804,5831,5889,5899,5910,5919,5923,5942,5972,5999,6000,6002,6016,6022,6060,6113,6127,6148,6160,6183,6194,6198,6220,6258,6261,6294,6312,6315,6317,6374,6377,6391,6401,6405,6420,6435,6442,6449,6476,6477,6546,6548,6549,6564,6587,6597,6609,6610,6612,6623,6630,6653,6677,6680,6684,6689,6698,6706,6722,6729,6763,6774,6845,6855,6860,6866,6873,6889,6894,6912,6934,6944,6958,7022,7023,7025,7030,7046,7048,7053,7054,7137,7195,7223,7242,7258,7323,7324,7329,7375,7382,7383,7391,7415,7418,7435,7466,7473,7491,7527,7535,7576,7592,7595,7606,7618,7648,7687,7697,7711,7722,7738,7751,7759,7760,7778,7788,7806,7811,7819,7838,7853,7860,7875,7953,7969,7976,7991,7997,7998,8009,8040,8045,8046,8064,8070,8073,8074,8078,8081,8086,8104,8178,8185,8215,8217,8218,8225,8240,8250,8273,8291,8295,8314,8374,8441,8461,8465,8487,8495,8499,8538,8589,8592,8602,8613,8634,8637,8650,8672,8707,8779,8801,8815,8861,8895,8945,8969,9065,9071,9121,9174,9175,9182,9186,9237,9254,9264,9277,9279,9299,9362,9369,9380,9394,9401,9424,9438,9451,9488,9540,9572,9663,9697,9701,9709,9711,9781,9784,9930,10258,10389,10562,10572,10840,11001,11131,11184,11302,11555,11788,12130,12228,12242,12374,12383,12398,12408,12426,12639,12658,12667,12761,12788,12803,12974,12982,13013,13028,13034,13037,13062,13126,13130,13215,13246,13285,13365,13459,13556,13590,13738,13804,13833,13896,13903,13986,14015,14127,14132,14139,14144,14177,14183,14267,14341,14432,14630,14651,14666,14680,14703,14714,14752,14808,14845,14865,14914,14951,14957,14969,14976,14978,15038,15054,15063,15079,15087,15096,15203,15235,15279,15460,15469,15490,15533,15540,15541,15544,15547,15581,15604,15619,15623,15627,15630,15666,15667,15781,15785,15786,15804,15807,15866,15875,15891,15913,15915,15930,15973,16005,16021,16023,16046,16113,16122,16224,16227,16336,16344,16454,16547,16587,16588,16612,16648,16675,16737,16791,16830,16880,16913,16947,16984,16995,17054,17055,17140,17166,17170,17172,17314,17333,17359,17372,17380,17388,17405,17442,17592,17598,17629,17644,17646,17680,17683,17699,17737,17791,17798,17799,17806,17807,17826,17936,17976,17977,18035,18036,18253,18308,18357,18383,18413,18437,18444,18448,18480,18491,18497,18499,18500,18524,18542,18545,18575,18603,18635,18657,18695,18733,18751,18752,18754,18779,18792,18802,18828,18832,18862,18868,18874,18880,18905,18918,19005,19015,19038,19164,19183,19187,19228,19258,19267,19269,19280,19282,19283,19289,19293,19299,19302,19307,19310,19339,19389,19400,19402,19421,19423,19427,19458,19470,19503,19532,19533,19568,19573,19587,19592,19625,19635,19697,19721,19800,19824,19830,19908,19937,19939,19944,20017,20029,20040,20044,20056,20057,20062,20150,20153,20176,20177,20188,20196,20211,20212,20213,20215,20236,20264,20277,20278,20293,20306,20307,20318,20357,20391,20410,20458,20508,20530,20559,20600,20662,20709,20710,20713,20733,20743,20764,20804,20811,20813,20821,20843,20851,20853,20858,20860,20871,20879,20883,20917,20920,20921,20932,20944,20949,20954,20999,21009,21069,21102,21128,21137,21168,21217,21236,21237,21258,21273,21282,21294,21313,21402,21466,21483,21569,21632,21693,21733,21760,21787,21798,21820,21904,21955,21969,22088,22105,22123,22256,22306,22336,22480,22498,22512,22529,22530,22531,22540,22551,22564,22567,22590,22596,22603,22616,22734,22743,22752,22847,22854,22935,22955,22974,23017,23085,23138,23170,23182,23202,23208,23224,23246,23276,23279,23511,23526,23533,23536,23544,23569,23599,23617,23682,23809,23847,23875,23901,23925,23945,24067,24101,24127,24153,24156,24189,24195,24208,24219,24245,24286,24410,24415,24419,24484,24502,24526,24563,24573,24585,24598,24609,24614,24634,24682,24697,24797,24853,24865,24868,24878,24907,24962,24964,24967,24973,24992,25030,25147,25323,25429,25453,25456,25534,25569,25598,25610,25632,25711,25721,25739,25741,25843,25850,25869,25901,25948,26014,26128,26215,26245,26292,26361,26386,26435,26473,26484,26554,26571,26588,26664,26678,26829,26858,26875,26920,26954,26999,27103,27133,27135,27157,27307,27315,27345,27404,27409,27432,27461,27483,27490,27763,27805,27863,27904,27997,28000,28248,28402,28416,28910,28911,28918,28960,29033,29136,29213,29281,29312,29328,29354,29613,29640,29696,30111,30307,30696,31114,31356,31586,31671,31866,32097,32339,32411,32731,32841,33243,33259,33430,33593,33651,33784,33993,34008,34176,34300,34490,34573,34783,35368,35568,35755,35841,36219,36893,37408,38489,39917,40199,40972,41256,41311,41430,41494,42530,42752,42799,44396,44402,44602,44743,45076)
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 | 1147 | 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.54 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.24 ms |
System lock | 0.02 ms |
optimizing | 0.08 ms |
statistics | 1.72 ms |
preparing | 0.91 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.32 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 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 |