Tiempo de la consulta: 24.45 ms Después de la última consulta: 1.96 ms Consulta a la memoria: 3.221 MB memoria antes de la consulta: 4.512 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 14:47:05')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 14:47:05')
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,64,65,66,71,73,78,81,86,87,94,117,120,126,138,149,157,164,167,174,177,180,193,196,201,216,218,220,221,226,240,244,257,259,262,265,267,275,291,299,304,305,306,311,316,317,331,340,341,349,354,366,368,377,385,390,391,401,406,428,429,452,463,466,471,472,477,481,482,489,493,494,495,497,499,501,510,515,519,525,530,531,543,546,549,560,563,584,592,593,610,614,619,621,635,643,659,661,662,663,667,674,680,681,685,692,697,699,700,703,705,709,713,728,731,733,736,737,740,741,742,746,761,769,771,772,783,786,791,800,802,805,808,823,825,832,835,841,855,859,864,868,869,872,873,889,891,894,908,909,910,923,928,931,939,940,943,954,955,960,968,969,974,977,982,983,984,998,999,1004,1005,1007,1011,1020,1021,1024,1029,1032,1034,1042,1048,1052,1055,1062,1079,1091,1095,1098,1103,1106,1114,1119,1127,1132,1138,1142,1150,1151,1158,1168,1172,1174,1182,1187,1188,1190,1192,1194,1205,1210,1226,1229,1231,1247,1252,1253,1255,1257,1265,1268,1269,1271,1276,1279,1280,1287,1289,1295,1296,1297,1298,1302,1305,1308,1309,1313,1319,1322,1336,1338,1344,1347,1349,1354,1355,1363,1367,1375,1380,1392,1402,1406,1409,1410,1413,1420,1421,1428,1430,1432,1433,1435,1441,1443,1444,1445,1447,1454,1455,1460,1465,1466,1470,1476,1478,1481,1484,1485,1506,1507,1509,1524,1531,1532,1537,1553,1557,1558,1568,1572,1586,1595,1598,1606,1619,1624,1629,1648,1664,1670,1675,1681,1693,1694,1695,1712,1719,1724,1765,1771,1794,1795,1796,1808,1810,1811,1812,1823,1841,1843,1852,1854,1855,1862,1870,1899,1903,1905,1906,1907,1918,1920,1930,1932,1945,1960,1961,1971,1973,1975,1984,1994,1995,2001,2007,2008,2013,2015,2028,2034,2035,2075,2077,2088,2096,2124,2133,2137,2144,2145,2148,2155,2157,2161,2177,2178,2180,2193,2194,2199,2207,2209,2229,2236,2245,2293,2301,2314,2315,2316,2331,2332,2333,2342,2359,2373,2376,2385,2408,2410,2432,2453,2455,2459,2469,2476,2480,2481,2503,2511,2516,2524,2527,2532,2548,2551,2564,2579,2586,2587,2594,2597,2617,2629,2631,2638,2643,2644,2646,2691,2695,2706,2720,2728,2764,2765,2773,2777,2790,2796,2814,2817,2824,2830,2851,2860,2883,2888,2926,2942,2960,2989,3027,3055,3056,3060,3063,3073,3075,3082,3100,3107,3112,3117,3119,3126,3129,3137,3143,3147,3157,3163,3169,3187,3202,3207,3222,3224,3235,3240,3244,3278,3293,3317,3327,3330,3355,3364,3368,3369,3377,3382,3387,3388,3409,3412,3424,3436,3444,3457,3473,3486,3512,3513,3520,3523,3546,3548,3552,3554,3556,3564,3573,3574,3579,3582,3587,3590,3594,3602,3613,3621,3648,3657,3663,3675,3683,3689,3709,3748,3792,3796,3827,3832,3836,3840,3853,3858,3864,3872,3905,3913,3919,3922,3943,3962,3979,3991,3992,4008,4015,4029,4033,4034,4035,4050,4068,4074,4075,4084,4110,4129,4132,4153,4168,4176,4197,4224,4234,4235,4252,4271,4273,4309,4313,4327,4331,4332,4335,4343,4361,4362,4364,4388,4391,4444,4468,4477,4488,4523,4525,4529,4532,4558,4560,4580,4585,4586,4587,4605,4616,4620,4622,4626,4631,4632,4643,4654,4666,4684,4688,4689,4691,4718,4732,4741,4751,4752,4767,4778,4784,4789,4808,4813,4815,4822,4831,4835,4841,4844,4846,4847,4865,4871,4874,4880,4902,4933,4949,4971,4973,4988,4999,5000,5014,5016,5020,5037,5051,5055,5074,5079,5099,5101,5134,5150,5153,5160,5180,5195,5220,5226,5263,5269,5323,5370,5378,5390,5415,5420,5423,5431,5469,5470,5496,5507,5508,5534,5559,5566,5569,5572,5579,5588,5594,5597,5632,5645,5648,5650,5659,5662,5664,5722,5726,5727,5729,5747,5755,5780,5795,5803,5822,5834,5859,5870,5876,5894,5971,5990,5999,6006,6009,6010,6068,6133,6148,6160,6197,6198,6217,6233,6272,6292,6308,6323,6331,6348,6349,6354,6359,6363,6391,6392,6420,6429,6435,6442,6445,6461,6476,6477,6533,6548,6554,6568,6596,6663,6667,6675,6677,6678,6707,6725,6726,6752,6758,6842,6845,6848,6855,6941,6944,6958,6975,7022,7030,7037,7048,7056,7082,7086,7096,7099,7110,7137,7181,7182,7195,7200,7212,7237,7242,7258,7275,7277,7278,7297,7299,7309,7324,7334,7418,7421,7426,7435,7466,7473,7491,7495,7535,7555,7556,7580,7581,7589,7592,7595,7626,7637,7648,7680,7688,7709,7719,7748,7751,7802,7819,7826,7830,7837,7839,7844,7860,7868,7870,7932,7946,7951,7970,7998,8037,8061,8069,8070,8071,8077,8086,8091,8105,8108,8192,8199,8206,8275,8276,8291,8295,8296,8303,8304,8314,8339,8400,8417,8443,8451,8493,8498,8512,8518,8522,8538,8540,8569,8592,8593,8602,8634,8704,8707,8773,8776,8779,8781,8801,8824,8853,8895,8898,8907,8938,8944,8975,8977,8983,8998,9004,9011,9029,9097,9108,9148,9184,9191,9201,9223,9237,9266,9277,9279,9322,9369,9401,9462,9475,9488,9516,9572,9650,9808,9818,9839,9879,9899,9930,9942,9970,10009,10078,10079,10140,10183,10261,10308,10316,10340,10345,10348,10373,10467,10501,10572,10595,10665,10673,10676,10677,10708,10725,10736,10775,10834,10840,10851,10906,11001,11030,11040,11137,11183,11184,11195,11223,11240,11241,11314,11439,11441,11552,11555,11603,11626,11669,11681,11692,11705,11850,11853,11859,11880,11967,12060,12089,12116,12128,12170,12181,12219,12223,12225,12238,12242,12385,12398,12408,12439,12440,12458,12550,12595,12620,12622,12623,12625,12630,12639,12667,12668,12705,12717,12718,12752,12760,12775,12777,12816,12894,12925,12945,12946,12949,12957,12974,12994,13002,13010,13034,13078,13083,13126,13160,13220,13246,13248,13258,13272,13297,13316,13344,13358,13436,13437,13438,13467,13473,13480,13481,13482,13503,13525,13579,13660,13759,13797,13812,13822,13824,13851,13875,13896,13959,13968,14005,14046,14047,14048,14134,14153,14159,14177,14181,14204,14229,14293,14309,14337,14350,14359,14432,14457,14468,14493,14506,14516,14542,14546,14570,14592,14641,14666,14700,14703,14710,14714,14718,14742,14752,14852,14865,14874,14927,14928,14941,14958,14969,14976,14987,14997,15038,15063,15087,15091,15138,15147,15203,15216,15229,15235,15261,15321,15359,15372,15408,15420,15460,15464,15495,15530,15533,15537,15543,15544,15551,15577,15604,15632,15644,15651,15722,15762,15781,15804,15807,15839,15850,15859,15875,15913,15915,15927,15973,15982,16052,16122,16142,16162,16201,16205,16214,16216,16224,16249,16258,16260,16318,16347,16370,16386,16421,16423,16454,16466,16537,16569,16580,16587,16588,16607,16612,16629,16634,16641,16737,16763,16774,16780,16791,16830,16913,16916,16924,16928,16940,16944,16947,16968,16969,16995,17002,17054,17055,17062,17126,17131,17133,17137,17140,17148,17166,17170,17185,17203,17206,17224,17242,17268,17291,17333,17371,17372,17379,17388,17416,17421,17442,17446,17458,17501,17529,17535,17555,17592,17640,17644,17646,17658,17660,17683,17699,17737,17750,17780,17791,17798,17806,17807,17851,17869,17892,17921,17936,17942,17947,17960,18013,18036,18037,18039,18040,18055,18076,18110,18122,18126,18127,18158,18160,18168,18174,18181,18191,18202,18212,18235,18277,18284,18286,18301,18309,18312,18321,18357,18380,18382,18383,18422,18433,18444,18466,18480,18490,18500,18516,18534,18535,18542,18549,18550,18571,18580,18599,18630,18657,18667,18689,18690,18695,18733,18742,18747,18754,18770,18779,18780,18802,18803,18813,18832,18835,18851,18901,18916,18923,18931,18934,18950,18954,18973,18980,18994,18999,19015,19028,19038,19043,19052,19113,19114,19124,19130,19131,19156,19168,19172,19178,19183,19184,19187,19196,19197,19219,19228,19258,19269,19280,19282,19283,19289,19299,19302,19307,19325,19335,19339,19343,19365,19370,19389,19400,19402,19407,19421,19423,19427,19445,19454,19458,19470,19481,19492,19493,19501,19503,19505,19532,19533,19555,19573,19574,19596,19612,19617,19618,19641,19678,19704,19721,19731,19742,19745,19773,19778,19797,19800,19830,19835,19853,19874,19898,19900,19924,19937,19950,19972,20003,20004,20028,20029,20033,20041,20043,20044,20051,20056,20057,20059,20062,20067,20080,20086,20111,20120,20129,20142,20152,20153,20158,20177,20187,20188,20195,20202,20215,20235,20236,20242,20248,20250,20252,20256,20265,20267,20271,20278,20279,20293,20306,20338,20376,20387,20391,20404,20443,20500,20508,20530,20568,20569,20570,20575,20590,20600,20601,20602,20609,20629,20650,20662,20667,20681,20689,20713,20733,20739,20740,20743,20764,20773,20800,20804,20808,20813,20843,20851,20853,20858,20860,20871,20879,20883,20888,20920,20921,20933,20944,20945,20949,20954,20957,20999,21059,21070,21114,21115,21127,21163,21168,21169,21172,21181,21189,21204,21205,21217,21229,21236,21261,21266,21268,21282,21284,21291,21311,21313,21321,21340,21342,21361,21383,21393,21402,21438,21445,21459,21467,21483,21490,21508,21559,21569,21593,21601,21620,21647,21652,21691,21703,21721,21735,21760,21774,21787,21810,21820,21821,21844,21848,21853,21870,21929,21950,21961,21969,21985,21986,22005,22049,22082,22105,22131,22132,22158,22161,22173,22175,22257,22385,22396,22408,22415,22416,22525,22567,22591,22603,22647,22653,22709,22720,22736,22743,22756,22758,22816,22847,22848,22854,22860,22864,22872,22898,22979,23031,23039,23041,23051,23084,23085,23101,23114,23132,23138,23164,23168,23170,23193,23202,23217,23221,23224,23246,23275,23280,23296,23332,23344,23379,23394,23406,23434,23459,23460,23526,23536,23547,23561,23569,23592,23593,23598,23599,23615,23617,23638,23645,23675,23682,23691,23715,23722,23747,23769,23803,23817,23860,23875,23894,23907,23922,23926,23932,23940,23954,23979,24011,24017,24052,24067,24087,24151,24153,24155,24170,24175,24189,24193,24198,24208,24219,24234,24361,24387,24413,24415,24455,24478,24484,24502,24524,24526,24549,24575,24585,24597,24598,24599,24609,24614,24644,24682,24697,24703,24719,24797,24799,24819,24838,24853,24973,24989,25010,25039,25061,25141,25172,25197,25278,25284,25292,25317,25323,25326,25331,25336,25456,25458,25475,25491,25534,25557,25569,25598,25610,25621,25626,25632,25670,25685,25687,25690,25693,25694,25695,25705,25717,25721,25845,25865,25881,25891,25901,25906,25943,25964,25981,25983,26014,26019,26056,26062,26080,26109,26154,26167,26204,26215,26226,26245,26334,26348,26353,26361,26369,26379,26386,26468,26473,26489,26509,26520,26530,26554,26630,26659,26680,26722,26731,26734,26753,26797,26802,26807,26829,26852,26909,26913,26920,26944,26945,26954,27035,27046,27103,27133,27135,27157,27183,27184,27199,27206,27237,27280,27311,27312,27313,27354,27362,27383,27412,27490,27491,27497,27610,27616,27694,27742,27779,27805,27806,27808,27823,27859,27863,27904,27997,28188,28189,28218,28233,28248,28306,28366,28402,28416,28453,28598,28601,28628,28636,28733,28746,28886,28898,28910,28918,28960,29002,29033,29111,29136,29164,29242,29281,29373,29548,29589,29864,30307,30486,30562,31114,31356,31384,31640,31671,32097,32530,32841,32919,33259,33345,33430,33593,33651,33784,33993,34008,34174,34176,34220,34300,34490,34573,34676,34699,34783,35095,35127,35153,35226,35299,35337,35360,35379,35428,35434,35568,35585,35596,35750,35754,35755,35776,35778,35780,35862,35865,36004,36051,36085,36109,36130,36159,36196,36197,36219,36267,36292,36297,36299,36341,36591,36594,36598,36604,36751,36769,36817,36961,37034,37083,37107,37116,37170,37397,37403,37408,37439,37454,38006,38103,38114,38122,38128,38315,38343,38379,38398,38440,38446,38452,38530,38549,38610,38613,38652,38674,38763,38777,38946,38971,39027,39041,39052,39150,39163,39171,39193,39225,39245,39276,39315,39319,39347,39375,39389,39475,39483,39492,39571,39590,39609,39682,39706,39722,39726,39747,39768,39790,39802,39821,39984,39997,40018,40089,40231,40276,40385,40386,40387,40398,40436,40438,40456,40460,40465,40533,40535,40554,40555,40562,40614,40667,40688,40742,40774,40811,40817,40939,40959,40983,41040,41068,41150,41220,41246,41256,41298,41311,41322,41418,41430,41436,41442,41499,41570,41576,41649,41724,41797,41800,41839,41865,41871,41879,41896,41927,41956,41957,42040,42054,42057,42065,42091,42134,42154,42163,42174,42188,42212,42304,42310,42405,42448,42490,42530,42538,42572,42602,42703,42729,42752,42765,42799,42800,42806,42863,43009,43018,43115,43136,43143,43222,43234,43244,43294,43345,43425,43426,43459,43508,43509,43539,43550,43565,43596,43601,43605,43615,43682,43846,43979,44026,44177,44184,44351,44396,44400,44402,44431,44491,44544,44588,44602,44611,44613,44701,44743,44894,44906,44908,44941,45051,45076,45136,45157,45227,45302,45303)
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 | 2140 | 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.93 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.39 ms |
System lock | 0.02 ms |
optimizing | 0.14 ms |
statistics | 3.24 ms |
preparing | 1.66 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 15.39 ms |
end | 0.03 ms |
query end | 0.04 ms |
closing tables | 0.02 ms |
freeing items | 0.12 ms |
cleaning up | 0.05 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 |