Tiempo de la consulta: 6.72 ms Después de la última consulta: 1.68 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.415 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 08:38:33')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 08:38:33')
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(3,8,49,57,72,97,99,112,113,124,131,133,134,136,137,139,155,180,198,210,215,219,221,224,225,232,238,243,244,245,249,254,267,276,280,289,309,318,325,328,330,337,357,394,395,414,417,418,423,424,426,427,433,451,452,459,468,474,481,489,511,521,524,525,527,528,532,548,553,555,565,567,583,587,595,596,597,603,604,609,620,622,628,632,641,646,647,659,662,672,681,686,692,710,726,730,733,746,781,788,792,796,800,802,805,816,818,833,840,842,852,855,860,892,893,901,902,925,929,952,962,986,1007,1008,1015,1044,1047,1058,1066,1072,1100,1114,1119,1145,1165,1169,1185,1204,1207,1226,1227,1264,1268,1272,1273,1274,1276,1278,1317,1323,1325,1328,1339,1352,1388,1389,1390,1394,1395,1412,1464,1475,1504,1563,1573,1664,1712,1718,1743,1753,1754,1797,1800,1803,1839,1853,1873,1880,1883,1932,1952,1960,2007,2012,2020,2048,2053,2065,2085,2086,2185,2211,2222,2355,2388,2429,2433,2463,2485,2492,2520,2532,2580,2589,2687,2689,2719,2811,2825,2852,2900,2927,2997,3000,3005,3017,3026,3049,3067,3071,3085,3095,3126,3144,3156,3167,3179,3181,3188,3208,3214,3265,3269,3279,3318,3323,3337,3353,3393,3415,3416,3417,3424,3452,3473,3512,3517,3520,3662,3668,3674,3704,3709,3776,3800,3836,3853,3855,3898,3918,3953,3969,3988,3991,4000,4061,4109,4127,4165,4173,4182,4258,4301,4378,4381,4405,4433,4434,4435,4462,4538,4561,4580,4582,4620,4625,4644,4832,4848,4855,4910,4911,4932,4933,4955,4978,5043,5045,5065,5096,5101,5154,5190,5195,5220,5243,5263,5301,5336,5357,5363,5367,5417,5438,5439,5535,5544,5563,5575,5582,5583,5593,5637,5644,5646,5666,5678,5702,5732,5759,5768,5777,5779,5785,5794,5795,5804,5831,5870,5872,5898,5899,5910,5919,5923,5924,5978,5986,5997,6000,6007,6011,6014,6016,6022,6038,6087,6107,6112,6115,6183,6195,6220,6237,6258,6261,6266,6294,6312,6343,6355,6390,6420,6448,6451,6476,6477,6531,6548,6564,6577,6596,6616,6716,6733,6749,6758,6766,6780,6784,6848,6855,6885,6936,7032,7039,7048,7067,7095,7098,7172,7245,7260,7269,7282,7291,7311,7325,7337,7412,7423,7424,7457,7467,7473,7486,7520,7527,7546,7549,7556,7567,7572,7576,7595,7714,7716,7719,7751,7759,7760,7771,7797,7806,7811,7829,7847,7853,7902,7958,7967,7969,7996,8009,8027,8050,8054,8062,8064,8070,8078,8081,8084,8087,8095,8101,8114,8164,8178,8218,8224,8240,8261,8306,8356,8374,8398,8415,8420,8461,8514,8521,8546,8569,8573,8610,8615,8637,8661,8779,8780,8818,8826,8848,8861,8875,8909,8916,8917,8932,8963,8999,9030,9038,9057,9091,9093,9111,9131,9139,9160,9175,9182,9184,9186,9188,9199,9206,9237,9239,9251,9254,9262,9263,9277,9307,9345,9357,9362,9394,9398,9404,9408,9426,9430,9431,9443,9444,9509,9516,9521,9540,9572,9576,9589,9597,9629,9642,9644,9660,9680,9689,9697,9711,9715,9729,9755,9779,9798,9799,9850,9864,9899,9932,9934,9970,9983,9992,10046,10068,10092,10113,10213,10217,10254,10361,10402,10415,10481,10486,10603,10655,10659,10671,10678,10708,10720,10751,10753,10879,10886,10893,10894,10924,10927,10955,10970,11038,11041,11083,11091,11122,11127,11131,11138,11143,11157,11159,11179,11206,11238,11279,11302,11305,11309,11398,11407,11419,11441,11455,11468,11497,11541,11559,11585,11587,11614,11701,11706,11721,11727,11822,11839,11859,11915,11927,11987,11989,12018,12025,12037,12038,12040,12091,12098,12109,12123,12133,12146,12158,12168,12202,12204,12217,12242,12250,12263,12306,12334,12357,12372,12381,12426,12449,12475,12520,12568,12590,12625,12640,12655,12673,12685,12735,12746,12747,12788,12799,12806,12848,12893,12896,12901,12903,12916,12926,12976,12982,12991,12993,13000,13004,13010,13013,13023,13036,13037,13062,13073,13080,13126,13139,13141,13164,13169,13186,13198,13215,13230,13232,13238,13249,13263,13265,13285,13296,13297,13314,13325,13331,13336,13343,13346,13365,13383,13387,13411,13415,13418,13425,13426,13432,13453,13454,13459,13481,13556,13558,13566,13587,13590,13595,13611,13625,13627,13670,13677,13682,13697,13711,13753,13754,13833,13856,13875,13881,13903,13907,13926,13951,13970,13986,13987,14012,14015,14017,14029,14041,14073,14080,14083,14091,14097,14104,14114,14150,14159,14176,14177,14186,14190,14193,14196,14199,14205,14214,14218,14222,14227,14232,14236,14238,14242,14261,14267,14268,14278,14288,14304,14338,14388,14427,14448,14461,14469,14484,14549,14562,14563,14571,14574,14583,14591,14631,14632,14651,14656,14680,14684,14722,14723,14725,14747,14766,14770,14778,14799,14805,14810,14813,14818,14827,14840,14842,14885,14904,14914,14940,14953,14954,14957,14960,14970,14978,15006,15047,15054,15061,15066,15069,15091,15096,15109,15126,15138,15146,15172,15175,15185,15197,15206,15218,15235,15244,15245,15250,15286,15292,15303,15314,15315,15317,15332,15340,15469,15490,15518,15520,15532,15540,15547,15550,15565,15566,15579,15602,15612,15623,15627,15630,15631,15641,15662,15666,15667,15668,15707,15731,15732,15755,15785,15806,15835,15840,15894,15902,15922,15925,15927,15929,15937,15966,15980,16003,16005,16013,16015,16021,16023,16024,16053,16074,16088,16094,16102,16117,16123,16142,16148,16169,16202,16213,16219,16228,16242,16262,16265,16279,16311,16313,16316,16336,16346,16356,16365,16375,16377,16382,16386,16401,16402,16415,16417,16422,16427,16441,16442,16443,16448,16458,16479,16497,16502,16528,16535,16542,16545,16547,16585,16588,16589,16609,16624,16640,16645,16675,16676,16688,16712,16732,16758,16811,16813,16814,16817,16827,16828,16833,16834,16857,16864,16872,16879,16897,16910,16911,16916,16917,16947,17045,17047,17064,17085,17089,17130,17146,17150,17153,17160,17169,17172,17186,17209,17221,17227,17228,17263,17300,17363,17371,17378,17393,17417,17424,17436,17437,17450,17462,17488,17507,17513,17584,17591,17600,17613,17630,17667,17679,17680,17684,17688,17692,17697,17701,17703,17721,17724,17739,17750,17753,17766,17769,17781,17788,17808,17815,17820,17822,17826,17852,17862,17874,17884,17924,17938,17964,17966,17976,17977,17991,18006,18022,18036,18040,18067,18068,18073,18075,18106,18123,18138,18151,18156,18182,18185,18243,18245,18253,18259,18260,18261,18262,18297,18303,18306,18311,18313,18356,18357,18370,18378,18383,18396,18420,18421,18437,18444,18445,18453,18473,18503,18505,18524,18528,18547,18552,18564,18572,18578,18579,18580,18584,18591,18599,18638,18642,18655,18668,18678,18686,18693,18702,18705,18708,18734,18747,18752,18764,18766,18771,18777,18792,18793,18795,18804,18813,18817,18829,18835,18838,18839,18843,18847,18849,18850,18854,18868,18874,18917,18937,18956,18972,18973,18977,18985,18992,19019,19036,19038,19041,19062,19082,19117,19130,19145,19157,19159,19160,19164,19167,19175,19178,19184,19216,19217,19222,19223,19242,19267,19271,19275,19284,19286,19290,19293,19312,19316,19328,19371,19375,19398,19414,19417,19426,19432,19436,19439,19455,19466,19476,19484,19503,19525,19543,19556,19557,19558,19562,19565,19567,19571,19575,19579,19591,19592,19602,19604,19634,19643,19644,19659,19670,19671,19701,19706,19708,19720,19728,19740,19755,19764,19766,19769,19780,19796,19799,19819,19829,19842,19876,19882,19895,19900,19905,19924,19927,19952,19962,19963,19976,19989,20019,20025,20027,20038,20045,20052,20062,20076,20080,20091,20093,20104,20120,20123,20133,20145,20149,20150,20184,20191,20211,20212,20227,20230,20259,20276,20298,20307,20310,20323,20326,20337,20341,20367,20380,20395,20401,20409,20425,20442,20444,20475,20488,20502,20517,20544,20572,20577,20587,20601,20611,20616,20629,20697,20705,20713,20728,20733,20740,20750,20754,20791,20792,20797,20820,20821,20830,20858,20864,20875,20884,20890,20917,20923,20932,20933,20934,20940,20942,20946,20949,20960,20962,20963,20966,20993,20997,20999,21002,21006,21009,21012,21027,21031,21040,21041,21042,21047,21048,21050,21054,21060,21069,21075,21101,21102,21104,21107,21109,21110,21116,21142,21146,21159,21165,21171,21172,21176,21185,21186,21195,21218,21230,21233,21241,21245,21250,21260,21262,21308,21312,21313,21350,21359,21362,21368,21378,21398,21402,21414,21420,21445,21450,21458,21472,21477,21494,21498,21512,21519,21528,21535,21540,21541,21543,21544,21554,21609,21611,21616,21632,21637,21640,21643,21648,21653,21659,21703,21705,21714,21729,21749,21755,21758,21777,21797,21826,21830,21851,21864,21874,21882,21895,21897,21907,21921,21955,21964,21975,21978,21979,22023,22038,22046,22060,22064,22070,22072,22084,22092,22100,22103,22120,22165,22171,22188,22198,22201,22213,22235,22236,22237,22249,22252,22271,22275,22285,22290,22322,22332,22337,22341,22345,22349,22353,22395,22408,22411,22439,22448,22469,22478,22480,22484,22495,22497,22498,22500,22511,22512,22514,22530,22531,22540,22549,22550,22551,22557,22564,22578,22590,22595,22610,22614,22615,22635,22638,22665,22685,22693,22704,22709,22715,22716,22725,22738,22741,22759,22765,22768,22772,22782,22794,22803,22804,22823,22824,22832,22846,22850,22879,22885,22889,22903,22909,22916,22920,22927,22935,22945,22951,22978,22982,22988,22989,23035,23038,23046,23055,23061,23067,23078,23082,23094,23114,23135,23148,23164,23181,23188,23194,23213,23236,23253,23256,23258,23273,23279,23302,23305,23317,23336,23342,23353,23354,23358,23359,23367,23373,23397,23398,23418,23419,23424,23429,23435,23440,23442,23449,23457,23465,23472,23476,23508,23509,23516,23520,23521,23531,23532,23544,23551,23556,23569,23571,23590,23595,23615,23627,23631,23646,23665,23695,23697,23708,23709,23716,23719,23732,23765,23774,23777,23800,23809,23826,23842,23852,23859,23872,23885,23915,23945,23956,23961,23985,24022,24027,24100,24101,24125,24134,24168,24177,24199,24207,24217,24233,24244,24258,24272,24275,24286,24291,24295,24301,24303,24304,24333,24368,24386,24406,24426,24428,24433,24437,24439,24440,24456,24458,24510,24527,24532,24537,24540,24545,24565,24572,24574,24590,24616,24632,24660,24662,24664,24691,24699,24707,24748,24768,24780,24783,24789,24796,24830,24831,24907,24941,24962,24971,24975,24981,24984,24988,25035,25042,25077,25080,25083,25097,25116,25118,25123,25129,25142,25151,25153,25157,25170,25179,25180,25187,25191,25193,25198,25200,25206,25214,25241,25257,25277,25281,25287,25300,25344,25347,25355,25356,25374,25386,25433,25456,25465,25470,25482,25490,25491,25512,25537,25548,25558,25562,25593,25610,25628,25664,25693,25723,25755,25802,25807,25809,25819,25842,25871,25990,26010,26014,26044,26049,26079,26161,26218,26234,26256,26257,26274,26367,26375,26412,26431,26466,26548,26563,26597,26689,26728,26744,26835,26842,26843,26864,26901,26933,26986,26999,27010,27049,27059,27108,27109,27126,27137,27186,27192,27197,27209,27252,27261,27305,27307,27314,27384,27398,27466,27470,27472,27633,27761,27770,27786,27832,27911,27918,27921,27923,27924,27926,27967,28004,28072,28254,28325,28372,28416,28423,28479,28547,28807,28911,28925,28999,29221,29223,29235,29250,29281,29332,29355,29380,29476,29611,29640,29696,29763,29777,29814,29821,29864,29868,29930,30111,30234,30280,30478,30488,31533,31623,31624,31640,31899,31908,31975,32160,32195,33739,33874,33998,34114,34258,34987,34997,35333,35628,35632,35667,35713,35744,35759,35784,36079,36151,36308,36564,36949,37289,37656,37865,38000,38005,38691,38763,38884,38898,38932,38960,39067,39600,39642,39833,39966,40053,40072,40112,40116,40145,40244,40271,40332,40414,40502,40684,40810,40984,41074,41136,41257,41364,41460,42444,43388,43436,44206,44207,44866)
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 | 1935 | 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.91 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.33 ms |
System lock | 0.02 ms |
optimizing | 0.18 ms |
statistics | 2.89 ms |
preparing | 1.42 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.01 ms |
freeing items | 0.07 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 |