Tiempo de la consulta: 12.10 ms Después de la última consulta: 1.83 ms Consulta a la memoria: 0.846 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-05 06:20:50')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 06:20:50')
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(8,11,44,45,46,50,52,59,61,75,83,89,90,96,124,138,141,180,181,186,188,189,190,198,212,215,216,219,220,221,222,224,225,226,233,237,244,246,248,249,250,253,254,257,262,280,318,325,336,366,370,371,385,394,401,406,412,413,414,419,423,424,427,433,434,439,444,445,451,452,456,459,474,479,481,489,494,497,500,524,527,528,529,548,553,555,557,563,583,587,595,596,603,614,615,620,622,625,633,641,642,646,647,648,650,651,652,654,663,671,672,675,679,684,686,687,689,692,700,704,708,709,710,726,730,733,737,771,772,776,781,796,797,802,805,814,818,824,826,833,845,854,858,861,864,872,874,875,889,893,894,901,902,905,909,910,924,925,928,936,941,943,950,955,962,976,983,994,1005,1021,1033,1035,1040,1055,1062,1066,1071,1072,1087,1092,1105,1112,1114,1119,1132,1171,1172,1174,1182,1185,1190,1200,1205,1210,1213,1215,1227,1231,1235,1247,1248,1252,1253,1256,1264,1266,1267,1268,1269,1270,1272,1273,1274,1275,1276,1277,1278,1285,1297,1314,1317,1323,1339,1355,1359,1369,1388,1389,1390,1394,1395,1402,1465,1467,1491,1526,1534,1554,1563,1574,1593,1594,1612,1618,1637,1659,1683,1686,1709,1712,1717,1718,1721,1744,1750,1770,1776,1778,1784,1805,1849,1863,1873,1880,1896,1907,1917,1932,1949,1964,1971,1973,1979,1996,1999,2043,2065,2102,2124,2163,2211,2221,2237,2331,2374,2388,2401,2428,2433,2455,2469,2492,2553,2559,2580,2617,2633,2706,2739,2774,2788,2790,2850,2855,2869,2875,2964,2997,3000,3027,3049,3060,3071,3082,3085,3095,3155,3181,3193,3197,3214,3224,3240,3244,3251,3259,3271,3289,3291,3299,3317,3330,3386,3398,3417,3424,3425,3444,3473,3476,3506,3516,3544,3559,3573,3595,3630,3666,3707,3710,3720,3721,3757,3758,3785,3792,3796,3800,3801,3832,3868,3869,3870,3873,3886,3905,3918,3932,3943,3953,3963,3988,4008,4029,4035,4059,4082,4084,4199,4224,4234,4235,4255,4273,4300,4313,4331,4332,4338,4355,4361,4362,4364,4381,4391,4399,4434,4444,4491,4495,4502,4547,4560,4578,4589,4600,4675,4676,4732,4752,4775,4780,4799,4801,4835,4854,4855,4880,4901,4911,4932,4935,4965,4972,4978,5000,5037,5053,5062,5063,5074,5098,5101,5136,5147,5151,5166,5183,5184,5190,5195,5212,5227,5263,5269,5273,5285,5328,5336,5363,5374,5390,5406,5415,5417,5423,5519,5529,5541,5560,5563,5575,5585,5632,5646,5648,5679,5694,5702,5707,5732,5756,5757,5759,5782,5803,5811,5821,5834,5835,5852,5859,5895,5904,5906,5927,5994,6005,6009,6014,6021,6032,6038,6068,6069,6107,6115,6151,6160,6195,6199,6212,6221,6222,6226,6233,6276,6373,6402,6429,6498,6501,6510,6531,6542,6543,6548,6595,6615,6641,6666,6677,6688,6716,6740,6741,6757,6758,6760,6761,6769,6779,6784,6794,6802,6829,6834,6848,6853,6857,6862,6865,6884,6894,6908,6923,6924,6939,6941,6944,6960,7002,7004,7012,7037,7048,7053,7054,7084,7098,7172,7175,7222,7238,7242,7273,7278,7297,7348,7374,7394,7423,7443,7446,7507,7520,7534,7556,7560,7567,7580,7581,7591,7593,7595,7644,7714,7722,7751,7759,7762,7775,7797,7812,7904,7926,7967,7968,7980,7988,7996,8054,8060,8077,8089,8105,8114,8148,8161,8178,8188,8243,8249,8294,8296,8299,8303,8306,8325,8342,8357,8387,8390,8415,8417,8418,8443,8492,8505,8506,8512,8521,8572,8617,8678,8681,8710,8716,8784,8810,8835,8848,8852,8892,8923,8930,8940,8948,8995,9000,9004,9011,9046,9058,9096,9110,9111,9131,9140,9155,9180,9184,9186,9188,9190,9193,9199,9206,9252,9345,9362,9381,9391,9395,9404,9501,9516,9525,9541,9573,9576,9641,9642,9643,9648,9655,9685,9699,9708,9731,9752,9766,9799,9809,9814,9822,9831,9840,9873,9879,9889,9899,9915,9968,9970,10014,10044,10046,10113,10129,10140,10147,10179,10217,10254,10278,10298,10342,10364,10402,10405,10407,10449,10467,10481,10486,10494,10655,10677,10678,10774,10818,10879,10900,10942,10967,10970,11040,11137,11138,11159,11198,11238,11240,11305,11397,11407,11432,11436,11455,11461,11465,11529,11541,11542,11549,11552,11590,11616,11669,11672,11673,11681,11685,11706,11709,11750,11772,11791,11827,11853,11857,11880,11927,11979,11989,12037,12048,12050,12103,12123,12137,12141,12146,12168,12202,12217,12255,12263,12268,12324,12334,12372,12381,12387,12410,12413,12439,12440,12458,12482,12509,12523,12550,12567,12615,12655,12663,12668,12714,12786,12795,12818,12887,12892,12893,12896,12900,12903,12913,12926,12943,12949,12974,12976,12982,12993,12998,13014,13023,13065,13069,13070,13073,13079,13080,13083,13094,13121,13139,13152,13164,13209,13230,13232,13263,13269,13296,13297,13314,13317,13336,13343,13358,13390,13411,13436,13477,13508,13553,13579,13617,13626,13682,13711,13722,13728,13729,13754,13803,13822,13856,13875,13894,13959,13966,14012,14014,14017,14041,14048,14073,14091,14134,14136,14146,14152,14159,14176,14185,14197,14199,14214,14232,14238,14242,14268,14288,14290,14302,14304,14337,14338,14352,14368,14400,14417,14427,14455,14468,14469,14494,14508,14548,14549,14562,14563,14574,14577,14620,14633,14656,14660,14672,14688,14700,14704,14741,14747,14752,14766,14769,14778,14813,14857,14882,14884,14889,14927,14928,14930,14934,14941,14969,14970,14997,15047,15061,15066,15077,15090,15091,15133,15175,15184,15185,15186,15197,15218,15223,15250,15261,15279,15315,15332,15365,15392,15396,15397,15405,15430,15450,15460,15484,15532,15537,15563,15566,15583,15598,15601,15627,15644,15654,15670,15706,15731,15732,15749,15751,15753,15762,15788,15807,15859,15895,15898,15901,15902,15909,15913,15916,15917,15927,15929,15942,15960,15980,15998,15999,16010,16040,16053,16055,16078,16094,16123,16142,16150,16162,16202,16212,16219,16260,16284,16311,16313,16318,16323,16377,16401,16441,16448,16492,16497,16555,16570,16585,16588,16589,16590,16620,16624,16631,16641,16642,16647,16676,16698,16712,16732,16758,16811,16813,16857,16863,16891,16897,16905,16913,16916,16924,16940,16944,16947,16968,16969,16976,16996,17014,17035,17054,17064,17089,17137,17146,17150,17169,17174,17203,17206,17209,17232,17238,17248,17263,17268,17287,17363,17367,17371,17378,17393,17416,17417,17424,17436,17450,17462,17488,17507,17513,17535,17556,17580,17591,17595,17622,17629,17630,17643,17683,17684,17697,17722,17724,17739,17750,17752,17782,17784,17788,17799,17808,17815,17833,17863,17884,17907,17959,17961,17964,17978,17981,17997,18002,18004,18014,18019,18027,18028,18035,18040,18061,18068,18072,18076,18138,18141,18150,18168,18182,18188,18203,18211,18234,18235,18237,18243,18245,18276,18284,18306,18312,18382,18383,18415,18422,18423,18447,18491,18498,18507,18516,18534,18535,18542,18564,18582,18587,18599,18647,18676,18678,18686,18744,18747,18767,18771,18777,18778,18795,18800,18801,18803,18817,18829,18835,18838,18851,18853,18857,18879,18901,18917,18923,18931,18934,18946,18950,18954,18967,18972,18973,18980,18992,18996,19019,19036,19041,19053,19066,19093,19094,19098,19099,19112,19113,19154,19156,19157,19159,19164,19167,19172,19184,19186,19196,19197,19216,19218,19249,19257,19286,19302,19316,19328,19340,19359,19365,19383,19389,19398,19420,19432,19436,19466,19473,19481,19493,19500,19514,19525,19533,19545,19557,19558,19565,19573,19575,19579,19580,19586,19587,19606,19607,19618,19641,19643,19644,19665,19678,19701,19708,19725,19740,19741,19742,19745,19755,19758,19769,19778,19779,19783,19796,19805,19826,19829,19835,19842,19864,19893,19895,19900,19924,19942,19950,19952,19963,19973,20002,20027,20043,20062,20076,20080,20093,20129,20150,20154,20155,20204,20208,20209,20211,20227,20235,20239,20267,20278,20298,20303,20307,20323,20326,20352,20366,20384,20387,20393,20395,20401,20442,20475,20544,20570,20575,20584,20585,20601,20637,20650,20682,20689,20704,20713,20728,20733,20740,20750,20754,20776,20791,20808,20828,20832,20864,20876,20879,20884,20934,20935,20946,20948,20991,21013,21028,21035,21042,21048,21059,21070,21090,21095,21102,21109,21114,21174,21176,21186,21200,21204,21229,21261,21291,21302,21308,21311,21335,21340,21341,21342,21359,21361,21362,21383,21412,21414,21415,21435,21465,21482,21528,21535,21559,21582,21583,21603,21604,21616,21632,21647,21652,21653,21660,21677,21691,21703,21729,21758,21770,21772,21810,21815,21826,21830,21844,21848,21867,21869,21874,21897,21908,21929,21930,21954,21978,21983,21985,21986,22019,22036,22055,22058,22064,22070,22074,22084,22092,22131,22158,22161,22165,22177,22201,22213,22260,22271,22275,22290,22304,22321,22327,22337,22352,22362,22376,22379,22382,22400,22408,22428,22448,22482,22497,22511,22520,22541,22545,22549,22551,22573,22578,22591,22594,22610,22615,22621,22623,22638,22665,22676,22685,22704,22716,22737,22758,22767,22782,22797,22816,22823,22824,22832,22855,22860,22896,22922,22927,22932,22941,22945,22963,22967,22982,23004,23027,23032,23038,23051,23061,23084,23085,23089,23090,23102,23114,23115,23136,23164,23166,23174,23215,23217,23313,23379,23411,23412,23419,23434,23460,23472,23481,23482,23503,23508,23531,23548,23551,23561,23572,23590,23595,23633,23634,23645,23652,23654,23713,23777,23788,23803,23809,23842,23866,23879,23894,23943,23958,23979,23985,23999,24002,24011,24022,24032,24087,24107,24134,24137,24151,24154,24155,24164,24172,24179,24234,24244,24248,24289,24300,24309,24363,24387,24391,24418,24431,24434,24442,24458,24475,24500,24502,24527,24537,24549,24572,24575,24606,24644,24664,24688,24691,24719,24731,24766,24783,24831,24876,24880,24882,24894,24896,24927,24940,24967,24971,24986,24993,25001,25013,25033,25040,25051,25061,25073,25077,25091,25094,25101,25114,25153,25167,25191,25198,25256,25271,25296,25321,25367,25371,25372,25379,25390,25391,25393,25414,25431,25433,25446,25451,25457,25459,25464,25465,25467,25468,25472,25476,25482,25485,25486,25489,25492,25493,25494,25495,25499,25504,25506,25508,25509,25510,25517,25536,25537,25538,25540,25545,25546,25552,25559,25562,25569,25572,25576,25578,25582,25587,25588,25593,25596,25598,25626,25630,25670,25674,25695,25723,25735,25742,25749,25768,25782,25792,25802,25842,25845,25865,25871,25906,25937,25941,25953,25974,25983,26019,26040,26044,26047,26056,26079,26080,26139,26140,26197,26323,26324,26329,26333,26334,26345,26362,26379,26398,26450,26473,26485,26489,26506,26548,26554,26572,26577,26578,26612,26625,26628,26637,26653,26683,26694,26734,26757,26785,26787,26796,26838,26909,26919,26941,26949,26954,26962,27010,27056,27067,27087,27095,27100,27104,27123,27142,27144,27164,27179,27184,27206,27312,27313,27342,27362,27398,27488,27694,27761,27770,27892,28004,28157,28169,28290,28423,28440,28442,28453,28479,28531,28534,28635,28733,28741,28751,28817,28868,28870,28886,28898,28925,28930,28959,29001,29164,29218,29222,29242,29312,29589,30234,30253,30254,30472,30477,30503,30504,31463,31533,31663,31684,31725,31821,31852,31899,32472,32679,33605,34030,34071,34114,34159,34220,34243,34262,34270,34375,34611,34956,35127,35266,35325,35428,35485,35596,35643,35776,35822,35862,35881,36004,36007,36109,36127,36143,36178,36214,36251,36339,36382,36617,36620,36652,36838,37002,37056,37368,37411,37422,37524,37532,37688,37758,37796,38005,38071,38120,38199,38363,38452,38585,38664,38665,38719,38762,38763,38816,38817,38833,38844,38845,38897,38933,38987,39036,39067,39227,39231,39397,39614,39616,39645,39687,39726,39769,39789,39820,39826,39833,39896,39897,39958,39964,39972,39977,39984,39997,40025,40052,40082,40183,40292,40344,40530,40533,40650,40703,40760,40810,40873,40888,41070,41083,41095,41134,41136,41188,41204,41264,41268,41363,41464,41503,41601,41677,41681,41706,41778,41861,42107,42185,42205,42387,42396,42408,42451,42590,42639,42708,42716,42836,42890,42900,42952,42991,42993,42998,43050,43051,43078,43114,43120,43191,43247,43248,43274,43291,43300,43301,43335,43360,43365,43386,43398,43412,43424,43528,43546,43599,43651,43688,43700,43716,43725,43885,43942,44013,44046,44051,44060,44079,44094,44120,44128,44159,44165,44175,44200,44208,44229,44263,44282,44312,44327,44382,44387,44406,44422,44447,44453,44458,44479,44487,44500,44517,44562,44609,44662,44682,44761,44762,44786,44797,44950,45008,45024,45050,45086,45106,45131,45152,45183,45196,45208,45209,45257,45275,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 | 2077 | 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.98 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.37 ms |
System lock | 0.02 ms |
optimizing | 0.13 ms |
statistics | 3.31 ms |
preparing | 1.64 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 4.77 ms |
end | 0.02 ms |
query end | 0.06 ms |
closing tables | 0.06 ms |
freeing items | 0.22 ms |
cleaning up | 0.06 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 |