Tiempo de la consulta: 5.22 ms Después de la última consulta: 1.05 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.365 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-07 04:53:47')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 04:53:47')
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,11,14,29,39,56,60,62,63,65,71,73,86,87,149,164,174,177,196,221,226,240,259,262,263,291,299,303,308,331,349,353,354,356,357,358,359,360,361,363,364,366,391,428,429,460,472,481,495,500,501,510,525,530,531,546,563,619,655,659,662,663,667,674,686,697,705,723,746,756,757,769,800,802,805,808,823,832,835,869,873,910,923,939,940,954,965,969,974,977,982,983,999,1004,1005,1011,1020,1021,1045,1055,1067,1080,1090,1091,1095,1114,1119,1120,1143,1158,1182,1198,1205,1207,1214,1231,1247,1251,1252,1253,1255,1268,1271,1276,1289,1308,1309,1319,1324,1336,1347,1363,1386,1409,1410,1428,1432,1441,1444,1479,1480,1485,1509,1514,1557,1606,1619,1623,1628,1629,1641,1648,1675,1693,1694,1718,1724,1745,1771,1794,1795,1796,1806,1808,1810,1843,1854,1855,1862,1868,1899,1918,1920,1930,1960,1961,1975,1984,1988,1994,1995,2001,2008,2013,2015,2035,2075,2078,2088,2105,2137,2155,2157,2161,2293,2322,2452,2455,2527,2532,2551,2560,2586,2597,2630,2636,2638,2643,2716,2786,2812,2814,2824,2849,2851,2858,2883,2888,2929,2939,2960,2964,2983,3016,3027,3039,3055,3065,3100,3107,3147,3169,3207,3294,3364,3368,3369,3387,3409,3412,3442,3463,3473,3520,3548,3552,3554,3590,3648,3673,3683,3689,3748,3761,3824,3853,3858,3872,3913,3919,3922,3962,3984,3991,4034,4050,4056,4068,4110,4129,4240,4325,4327,4378,4422,4468,4529,4532,4558,4616,4620,4622,4626,4666,4751,4752,4767,4772,4813,4815,4822,4831,4844,4846,4865,4874,4933,4973,5055,5133,5134,5136,5153,5160,5182,5204,5220,5302,5370,5373,5381,5415,5437,5451,5469,5556,5559,5579,5597,5647,5659,5729,5731,5780,5795,5798,5884,5894,5895,5999,6148,6155,6169,6198,6227,6342,6350,6380,6391,6420,6435,6442,6476,6477,6515,6516,6517,6541,6548,6573,6601,6602,6645,6665,6690,6727,6845,6854,6855,6939,6944,6958,7022,7026,7030,7048,7135,7136,7137,7138,7139,7178,7191,7195,7242,7245,7258,7284,7324,7365,7380,7387,7401,7402,7414,7418,7419,7453,7485,7491,7504,7535,7592,7595,7627,7629,7648,7718,7730,7741,7751,7753,7819,7872,7950,7965,7985,7986,8027,8030,8067,8070,8086,8090,8093,8109,8192,8291,8295,8314,8338,8538,8567,8592,8602,8625,8634,8638,8666,8707,8762,8777,8779,8801,8895,8897,8974,8978,8983,9029,9237,9277,9279,9286,9318,9340,9355,9369,9401,9423,9461,9488,9489,9572,9616,9769,9817,9818,9886,9924,9930,10023,10078,10132,10226,10239,10263,10314,10345,10380,10416,10430,10503,10572,10601,10665,10686,10738,10765,10768,10840,10964,10980,10989,11001,11029,11152,11184,11191,11204,11219,11265,11320,11418,11446,11523,11542,11555,11678,11754,11806,11835,11948,11954,11955,12031,12078,12116,12125,12171,12224,12242,12259,12309,12367,12398,12408,12546,12563,12566,12571,12605,12625,12639,12667,12670,12737,12791,12856,12872,12902,12974,13002,13034,13097,13126,13140,13246,13344,13350,13356,13444,13488,13516,13542,13571,13602,13615,13618,13645,13653,13806,13861,13874,13896,13916,13990,14000,14062,14063,14074,14137,14152,14205,14219,14227,14243,14249,14269,14280,14292,14362,14371,14389,14401,14508,14554,14591,14638,14665,14666,14693,14703,14714,14752,14753,14754,14830,14837,14846,14849,14865,14896,14897,14949,14969,14976,15038,15063,15079,15087,15174,15203,15221,15235,15268,15278,15353,15372,15460,15494,15520,15533,15544,15579,15604,15606,15717,15739,15781,15804,15807,15818,15835,15861,15875,15885,15896,15899,15913,15915,15939,15944,15953,15973,16022,16062,16091,16119,16122,16156,16224,16286,16337,16386,16414,16454,16472,16541,16582,16587,16588,16612,16621,16646,16698,16723,16737,16788,16790,16791,16808,16809,16816,16818,16830,16848,16913,16943,16957,16995,16998,17054,17055,17069,17090,17092,17132,17138,17140,17155,17166,17224,17230,17280,17290,17307,17309,17321,17333,17361,17372,17388,17391,17426,17442,17500,17571,17592,17611,17630,17644,17646,17679,17683,17699,17708,17727,17735,17737,17777,17783,17791,17798,17799,17806,17807,17817,17839,17869,17875,17882,17936,17947,18009,18036,18060,18079,18122,18129,18142,18176,18216,18220,18226,18253,18260,18264,18279,18295,18308,18332,18357,18360,18383,18388,18406,18424,18444,18480,18494,18520,18522,18542,18554,18566,18598,18653,18657,18695,18700,18718,18733,18754,18775,18779,18802,18822,18832,18859,18861,18908,18912,18937,18982,18995,19010,19015,19018,19022,19038,19086,19110,19137,19181,19183,19187,19228,19258,19269,19280,19282,19283,19289,19299,19302,19304,19307,19339,19367,19388,19389,19400,19402,19404,19421,19423,19427,19449,19458,19462,19464,19470,19496,19503,19507,19532,19533,19573,19581,19624,19652,19657,19677,19721,19774,19800,19826,19830,19856,19913,19921,19937,19973,20001,20029,20044,20056,20057,20058,20062,20153,20177,20180,20184,20188,20194,20215,20217,20232,20236,20277,20278,20293,20304,20306,20347,20354,20370,20378,20391,20440,20467,20488,20508,20525,20529,20530,20546,20564,20579,20600,20603,20626,20647,20662,20712,20713,20733,20736,20743,20749,20764,20802,20803,20804,20813,20843,20851,20853,20858,20860,20865,20871,20879,20883,20919,20920,20921,20944,20949,20954,20986,20988,20999,21004,21011,21116,21123,21151,21158,21167,21168,21183,21217,21224,21229,21236,21252,21257,21263,21272,21282,21301,21313,21376,21394,21402,21416,21419,21427,21483,21493,21510,21518,21534,21556,21569,21575,21589,21633,21659,21721,21735,21760,21765,21786,21787,21820,21888,21969,21999,22043,22071,22100,22105,22174,22178,22206,22251,22252,22263,22283,22298,22343,22412,22464,22476,22496,22528,22529,22555,22567,22603,22648,22649,22669,22682,22692,22696,22713,22726,22743,22747,22785,22820,22835,22847,22849,22854,22883,22900,22974,22979,23043,23052,23092,23118,23138,23170,23202,23224,23240,23246,23249,23307,23318,23328,23355,23378,23428,23430,23446,23457,23461,23476,23526,23536,23546,23569,23586,23599,23616,23617,23648,23665,23676,23682,23693,23719,23806,23825,23863,23875,23898,23951,23996,24021,24030,24033,24067,24099,24135,24153,24189,24192,24208,24219,24293,24361,24366,24392,24399,24415,24484,24497,24505,24526,24563,24585,24598,24609,24614,24635,24682,24683,24706,24709,24714,24717,24721,24754,24756,24790,24797,24818,24832,24853,24883,24936,24953,24973,24996,25048,25069,25105,25120,25175,25188,25288,25322,25323,25330,25383,25411,25456,25471,25486,25497,25514,25534,25539,25569,25598,25610,25632,25648,25673,25709,25721,25764,25790,25813,25821,25823,25859,25864,25898,25901,25955,26014,26043,26117,26134,26204,26215,26221,26240,26245,26366,26386,26431,26469,26480,26541,26554,26603,26630,26634,26639,26655,26686,26709,26769,26829,26920,26923,26954,26983,26996,27057,27103,27133,27135,27143,27157,27170,27220,27262,27372,27406,27490,27571,27644,27677,27738,27805,27863,27904,27985,27997,28120,28163,28248,28256,28402,28416,28465,28627,28662,28680,28681,28682,28683,28702,28710,28781,28844,28847,28910,28918,28960,29033,29064,29133,29136,29281,29379,29417,29571,29646,29727,30050,30307,30318,30790,31114,31356,31671,32097,32841,33259,33430,33593,33651,33725,33784,33993,34008,34176,34300,34490,34573,34783,35568,35755,36219,36323,37408,38986,39035,39129,39192,39287,40116,40202,40319,40583,41115,41256,41311,41430,42009,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 | 1253 | 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.66 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.28 ms |
System lock | 0.02 ms |
optimizing | 0.13 ms |
statistics | 2.15 ms |
preparing | 0.96 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.33 ms |
end | 0.01 ms |
query end | 0.01 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 |