Tiempo de la consulta: 12.94 ms Después de la última consulta: 1.64 ms Consulta a la memoria: 1.276 MB memoria antes de la consulta: 4.650 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-09 21:14:46')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 21:14: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(7,60,64,66,78,81,94,117,120,126,157,167,180,181,190,193,198,201,215,216,218,221,224,225,254,257,262,265,275,280,304,305,306,311,316,317,325,340,353,354,368,377,390,394,401,463,466,471,473,474,482,493,495,499,515,519,543,549,560,584,592,593,596,610,621,635,641,642,643,650,661,680,681,685,686,692,700,703,709,713,728,731,736,740,741,742,761,772,783,786,791,825,841,854,855,859,868,875,891,908,931,954,955,960,968,976,984,998,1007,1020,1024,1029,1032,1034,1042,1048,1052,1066,1071,1079,1098,1103,1106,1127,1138,1142,1150,1151,1168,1172,1187,1188,1192,1194,1226,1229,1255,1257,1265,1266,1267,1269,1271,1279,1280,1287,1295,1296,1298,1302,1305,1313,1322,1336,1338,1339,1344,1349,1354,1359,1367,1375,1380,1392,1402,1406,1413,1420,1421,1430,1433,1435,1441,1443,1444,1445,1447,1454,1455,1460,1466,1467,1470,1476,1478,1481,1484,1506,1507,1524,1531,1532,1534,1537,1553,1558,1568,1572,1574,1586,1595,1598,1624,1637,1659,1664,1681,1686,1695,1709,1719,1721,1778,1805,1811,1812,1823,1841,1852,1855,1870,1896,1903,1905,1906,1932,1984,2001,2077,2096,2145,2148,2177,2178,2193,2194,2199,2207,2209,2221,2229,2236,2245,2301,2314,2315,2316,2332,2333,2342,2359,2373,2376,2408,2410,2428,2432,2453,2455,2459,2469,2476,2480,2481,2503,2511,2516,2524,2564,2579,2594,2629,2631,2644,2691,2695,2697,2720,2728,2738,2765,2773,2817,2830,2855,2869,2911,2926,2942,2989,3056,3063,3073,3112,3117,3119,3126,3129,3137,3143,3163,3187,3202,3222,3235,3278,3293,3327,3355,3364,3382,3388,3398,3436,3440,3457,3486,3513,3546,3556,3574,3579,3582,3587,3590,3594,3595,3602,3630,3657,3663,3675,3709,3796,3801,3827,3836,3840,3864,3868,3870,3872,3979,3992,3993,4015,4074,4075,4132,4153,4168,4176,4197,4252,4271,4309,4335,4338,4343,4477,4488,4523,4525,4547,4558,4578,4580,4585,4586,4587,4605,4631,4632,4654,4684,4688,4689,4691,4718,4784,4799,4808,4815,4841,4847,4855,4871,4874,4902,4911,4935,4949,4965,4971,4999,5014,5016,5020,5037,5051,5053,5062,5075,5079,5098,5099,5147,5148,5151,5166,5180,5184,5195,5215,5226,5241,5263,5273,5323,5374,5378,5406,5431,5470,5496,5507,5508,5519,5534,5566,5569,5572,5579,5585,5588,5594,5597,5632,5645,5650,5659,5662,5722,5726,5727,5729,5747,5756,5782,5822,5835,5846,5852,5870,5876,5906,5927,5990,6006,6010,6014,6032,6068,6069,6084,6124,6133,6217,6222,6226,6272,6276,6292,6308,6323,6348,6349,6354,6359,6363,6373,6392,6445,6461,6510,6533,6542,6543,6568,6596,6641,6663,6666,6667,6675,6677,6707,6716,6719,6779,6842,6924,6939,6975,7004,7048,7056,7082,7086,7096,7099,7100,7110,7145,7181,7182,7200,7212,7222,7237,7275,7277,7278,7299,7309,7334,7407,7421,7423,7435,7446,7466,7495,7534,7555,7556,7560,7608,7626,7680,7688,7702,7709,7719,7748,7802,7812,7821,7830,7837,7839,7860,7868,7870,7904,7926,7932,7946,7951,7968,7970,7978,7998,8024,8037,8060,8061,8069,8071,8091,8108,8178,8199,8206,8275,8276,8294,8296,8299,8306,8313,8314,8339,8355,8357,8400,8418,8451,8477,8498,8518,8540,8569,8572,8593,8678,8679,8685,8704,8710,8715,8773,8776,8781,8810,8835,8853,8891,8907,8923,8938,8940,8944,8948,8983,8995,9029,9046,9096,9108,9110,9137,9140,9148,9180,9186,9190,9191,9199,9201,9223,9238,9252,9296,9322,9362,9381,9462,9475,9541,9576,9641,9650,9685,9716,9731,9784,9801,9818,9839,9848,9873,9879,9915,9942,9958,9987,10009,10014,10044,10046,10068,10078,10079,10113,10147,10224,10261,10296,10308,10316,10340,10342,10345,10348,10373,10407,10501,10595,10665,10673,10708,10725,10736,10774,10775,10834,10851,11030,11153,11195,11223,11224,11241,11314,11436,11439,11441,11462,11465,11475,11492,11549,11590,11603,11626,11692,11705,11706,11750,11772,11791,11807,11859,11967,11979,11984,12060,12089,12116,12128,12170,12181,12219,12223,12225,12238,12266,12315,12324,12334,12385,12420,12440,12550,12595,12620,12622,12623,12625,12630,12675,12705,12717,12718,12752,12760,12795,12816,12839,12892,12894,12925,12945,12946,12957,12994,12998,13002,13010,13065,13069,13070,13078,13094,13121,13160,13197,13202,13209,13248,13258,13263,13272,13297,13315,13316,13335,13344,13358,13437,13438,13454,13467,13473,13480,13481,13482,13503,13525,13585,13660,13722,13728,13759,13797,13803,13824,13894,13925,13959,13968,14005,14047,14048,14146,14153,14177,14181,14204,14229,14293,14309,14350,14352,14432,14439,14457,14459,14468,14493,14494,14506,14516,14542,14546,14570,14577,14592,14641,14644,14710,14741,14752,14779,14809,14852,14857,14874,14886,14889,14958,14969,14987,15026,15063,15077,15090,15133,15138,15147,15184,15186,15216,15229,15279,15291,15321,15359,15372,15392,15408,15420,15433,15464,15493,15495,15530,15543,15551,15577,15598,15627,15632,15644,15651,15722,15751,15753,15839,15850,15895,15902,15960,15982,15998,16010,16040,16052,16055,16078,16214,16216,16219,16249,16258,16284,16347,16370,16386,16401,16421,16423,16466,16508,16537,16569,16570,16580,16588,16607,16629,16634,16763,16774,16780,16791,16903,16913,17002,17014,17126,17131,17148,17185,17224,17291,17379,17458,17501,17527,17529,17555,17580,17629,17640,17643,17646,17658,17660,17681,17780,17799,17851,17869,17892,17921,17934,17947,17959,17960,18013,18014,18037,18039,18055,18068,18110,18122,18127,18145,18148,18158,18160,18164,18174,18181,18202,18212,18257,18276,18277,18286,18301,18306,18309,18321,18380,18382,18423,18433,18448,18454,18466,18490,18491,18516,18549,18550,18571,18580,18582,18599,18630,18690,18744,18770,18771,18778,18780,18796,18813,18901,18916,18994,18999,19019,19028,19043,19047,19052,19112,19130,19178,19184,19219,19286,19316,19325,19335,19343,19359,19370,19389,19407,19432,19445,19454,19492,19501,19505,19514,19533,19555,19570,19574,19596,19607,19612,19617,19698,19704,19731,19742,19756,19758,19773,19783,19797,19853,19898,19972,20003,20004,20025,20043,20051,20059,20067,20111,20120,20142,20150,20195,20202,20242,20248,20250,20252,20256,20265,20271,20279,20288,20300,20404,20443,20500,20501,20568,20569,20590,20602,20609,20619,20637,20667,20681,20704,20713,20739,20773,20776,20800,20806,20832,20857,20871,20888,20933,20945,21013,21019,21090,21115,21163,21174,21189,21205,21229,21266,21284,21298,21308,21321,21340,21353,21361,21393,21411,21435,21438,21459,21467,21490,21508,21601,21620,21656,21660,21691,21721,21735,21774,21818,21821,21853,21870,21934,21961,22005,22016,22018,22045,22082,22132,22173,22175,22180,22257,22337,22352,22362,22385,22400,22415,22416,22525,22551,22573,22615,22647,22653,22676,22736,22737,22756,22767,22797,22845,22848,22855,22864,22872,22881,22941,22963,22979,23031,23039,23041,23101,23114,23115,23129,23132,23168,23221,23296,23313,23332,23344,23394,23406,23482,23547,23592,23593,23598,23638,23675,23691,23715,23722,23727,23747,23769,23788,23817,23860,23879,23907,23922,23926,23943,23954,24017,24052,24107,24164,24170,24172,24175,24193,24198,24248,24361,24413,24434,24455,24458,24475,24478,24499,24524,24597,24599,24703,24766,24799,24811,24819,24830,24838,24880,24894,24896,24927,24967,24989,24993,25001,25008,25010,25013,25039,25040,25091,25094,25114,25141,25167,25172,25197,25278,25284,25292,25296,25317,25321,25326,25331,25336,25367,25371,25372,25390,25391,25393,25414,25431,25433,25446,25451,25457,25458,25459,25464,25465,25467,25468,25472,25475,25476,25482,25485,25486,25489,25492,25493,25494,25495,25499,25504,25506,25508,25509,25510,25517,25536,25537,25538,25540,25545,25546,25552,25557,25559,25569,25572,25576,25578,25582,25587,25588,25596,25621,25631,25674,25685,25687,25690,25693,25694,25705,25717,25767,25881,25891,25937,25941,25943,25953,25963,25964,25981,26044,26047,26062,26109,26154,26167,26204,26226,26310,26348,26353,26362,26369,26386,26468,26506,26509,26520,26530,26554,26572,26577,26578,26627,26630,26653,26659,26680,26683,26694,26722,26731,26753,26785,26787,26796,26797,26802,26807,26852,26885,26887,26909,26944,26945,26962,27035,27046,27067,27095,27123,27183,27184,27199,27237,27280,27300,27311,27342,27354,27383,27491,27563,27607,27610,27616,27742,27779,27806,27808,27859,28189,28218,28233,28306,28366,28440,28534,28598,28601,28628,28635,28636,28741,28746,28751,28827,28870,28930,29002,29019,29222,29314,29373,29548,29864,29931,30486,30562,30957,31384,31463,31533,31640,31670,31725,31908,32530,32912,32919,33345,33477,33575,33605,34030,34071,34087,34159,34174,34195,34243,34262,34270,34375,34381,34611,34676,34699,34956,35095,35153,35226,35266,35299,35337,35360,35379,35434,35574,35585,35596,35643,35674,35750,35760,35778,35780,35822,35865,35881,36007,36051,36085,36130,36143,36196,36251,36267,36283,36292,36297,36299,36339,36341,36382,36431,36474,36511,36591,36594,36598,36604,36617,36620,36751,36769,36817,36838,36961,37002,37034,37056,37083,37107,37116,37170,37397,37403,37411,37422,37439,37454,37524,37532,37569,37570,37571,37572,37688,37758,37796,37925,38006,38071,38103,38114,38122,38128,38170,38199,38315,38343,38363,38398,38440,38446,38452,38530,38549,38585,38610,38613,38652,38664,38665,38674,38719,38762,38777,38933,38946,38971,39027,39041,39052,39121,39150,39163,39171,39193,39225,39227,39231,39245,39276,39315,39319,39335,39347,39375,39389,39397,39475,39480,39483,39492,39571,39572,39590,39609,39617,39682,39687,39706,39722,39747,39768,39769,39790,39802,39821,39826,39839,39896,39897,39953,39958,39964,39977,40018,40025,40082,40089,40183,40231,40276,40292,40385,40386,40387,40398,40436,40438,40456,40460,40465,40530,40535,40554,40555,40562,40614,40650,40667,40688,40703,40742,40774,40811,40817,40959,40983,41040,41068,41070,41095,41134,41150,41188,41204,41220,41246,41298,41322,41418,41436,41442,41464,41499,41503,41570,41576,41601,41649,41677,41681,41724,41778,41797,41800,41839,41861,41865,41871,41879,41896,41927,41956,41957,41994,42040,42054,42057,42065,42091,42107,42134,42154,42163,42174,42185,42188,42205,42212,42304,42310,42357,42387,42396,42405,42407,42448,42490,42538,42572,42590,42602,42639,42703,42708,42716,42729,42765,42800,42806,42836,42863,42890,42900,42922,42952,42991,42993,42998,43009,43018,43050,43051,43078,43114,43115,43120,43136,43143,43191,43193,43222,43234,43244,43247,43248,43274,43291,43294,43300,43301,43335,43345,43360,43365,43386,43398,43404,43412,43424,43425,43426,43459,43508,43509,43528,43539,43546,43550,43565,43596,43599,43601,43605,43615,43651,43682,43688,43700,43716,43725,43846,43885,43979,44013,44026,44046,44051,44060,44079,44094,44120,44128,44159,44165,44175,44177,44184,44200,44208,44229,44263,44282,44312,44327,44351,44382,44387,44400,44406,44422,44431,44447,44453,44458,44479,44487,44491,44500,44517,44544,44562,44588,44609,44611,44613,44662,44682,44701,44761,44762,44786,44797,44883,44884,44885,44886,44887,44888,44889,44890,44894,44906,44908,44941,44950,45008,45024,45050,45051,45086,45106,45123,45131,45136,45152,45157,45183,45196,45208,45209,45227,45257,45275,45302,45303,45309)
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 | 1878 | 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.80 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.05 ms |
init | 0.33 ms |
System lock | 0.02 ms |
optimizing | 0.12 ms |
statistics | 2.70 ms |
preparing | 1.39 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 6.81 ms |
end | 0.06 ms |
query end | 0.04 ms |
closing tables | 0.03 ms |
freeing items | 0.14 ms |
cleaning up | 0.04 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 |