Tiempo de la consulta: 10.32 ms Después de la última consulta: 1.67 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.268 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 18:55:45')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 18:55:45')
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(9,11,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,71,81,87,88,89,110,111,117,125,131,133,136,139,155,164,170,172,188,189,190,200,202,205,234,246,248,249,263,271,280,287,290,291,293,325,339,343,344,349,350,353,354,356,357,358,359,360,361,362,363,364,374,376,377,378,379,380,412,415,416,420,421,422,423,424,426,427,429,431,437,456,460,477,484,496,500,501,503,531,574,575,593,607,608,609,611,655,669,679,686,693,723,756,757,782,785,797,831,843,851,853,862,868,891,929,941,964,965,976,986,997,1012,1020,1033,1043,1045,1067,1080,1090,1120,1143,1169,1175,1198,1204,1207,1214,1215,1223,1232,1247,1277,1287,1308,1324,1329,1336,1339,1353,1357,1360,1386,1434,1486,1526,1597,1601,1605,1642,1650,1688,1692,1698,1709,1710,1718,1733,1745,1770,1821,1878,1931,2105,2108,2208,2222,2272,2322,2341,2575,2618,2630,2653,2656,2712,2714,2742,2747,2757,2825,2858,2939,2964,2983,2997,3020,3028,3039,3045,3051,3064,3091,3124,3169,3209,3212,3215,3279,3294,3325,3329,3340,3427,3442,3463,3644,3650,3671,3673,3682,3738,3761,3783,3816,3842,3870,3895,3903,3912,3957,3984,4061,4087,4120,4128,4206,4310,4319,4378,4399,4422,4638,4674,4874,4902,4905,4910,5060,5136,5182,5189,5302,5324,5373,5392,5451,5471,5476,5538,5559,5579,5597,5647,5659,5685,5729,5730,5731,5798,5870,5894,5895,6039,6131,6234,6292,6311,6315,6333,6350,6384,6392,6442,6464,6482,6484,6516,6541,6573,6577,6601,6616,6631,6645,6665,6666,6671,6687,6688,6690,6727,6776,6836,6854,6868,6908,6923,6939,6940,6942,6957,6961,6989,6998,7017,7026,7050,7056,7064,7098,7109,7119,7124,7135,7138,7139,7154,7191,7210,7282,7284,7287,7303,7311,7361,7365,7367,7380,7387,7401,7402,7419,7434,7450,7453,7454,7483,7522,7551,7556,7562,7569,7572,7617,7627,7629,7638,7677,7692,7713,7716,7718,7730,7741,7753,7774,7782,7811,7829,7847,7862,7894,7916,7923,7929,7933,7950,7965,7967,7970,7985,7986,7993,8027,8056,8067,8090,8093,8108,8133,8215,8295,8338,8422,8444,8565,8589,8602,8610,8638,8663,8666,8694,8835,8856,8887,8974,9029,9057,9091,9206,9239,9249,9262,9282,9316,9318,9411,9428,9429,9472,9527,9616,9650,9677,9678,9691,9723,9725,9861,9886,9924,9966,9983,9985,10011,10023,10035,10078,10100,10149,10226,10227,10239,10256,10259,10263,10265,10274,10305,10313,10314,10345,10357,10380,10382,10389,10416,10423,10503,10534,10572,10601,10611,10613,10623,10665,10686,10721,10738,10761,10768,10777,10782,10820,10821,10955,10957,10964,10970,10971,10980,10989,11001,11002,11005,11029,11152,11191,11197,11204,11219,11265,11291,11320,11333,11345,11362,11365,11441,11446,11460,11490,11503,11507,11523,11539,11542,11663,11678,11724,11754,11799,11806,11816,11817,11825,11835,11893,11948,11950,11954,11964,11976,11986,12009,12020,12031,12078,12116,12125,12171,12178,12179,12224,12259,12270,12276,12309,12324,12367,12378,12388,12403,12446,12457,12460,12503,12517,12521,12546,12560,12562,12563,12571,12581,12582,12605,12620,12625,12650,12670,12685,12686,12708,12737,12758,12765,12791,12838,12851,12856,12872,12898,12902,12913,12973,12978,12985,12996,13014,13016,13036,13079,13105,13140,13152,13229,13285,13294,13307,13332,13334,13344,13348,13350,13420,13444,13474,13475,13488,13515,13516,13542,13571,13587,13602,13615,13618,13645,13647,13653,13692,13806,13861,13874,13900,13901,13902,13916,13971,13972,13973,13990,14000,14074,14090,14098,14152,14186,14201,14205,14217,14219,14227,14229,14243,14248,14249,14250,14269,14277,14280,14292,14293,14336,14352,14354,14362,14371,14372,14396,14401,14424,14426,14453,14508,14534,14536,14554,14591,14596,14625,14629,14630,14638,14665,14676,14693,14695,14754,14789,14830,14837,14840,14843,14845,14846,14849,14852,14856,14860,14901,14983,14984,15007,15018,15038,15043,15079,15111,15129,15150,15156,15174,15197,15214,15245,15261,15268,15278,15286,15293,15304,15305,15315,15316,15335,15351,15353,15355,15372,15376,15382,15406,15414,15424,15438,15444,15475,15476,15494,15522,15533,15574,15579,15581,15600,15606,15608,15616,15620,15689,15700,15714,15717,15722,15723,15739,15740,15742,15755,15778,15785,15790,15796,15805,15812,15835,15861,15872,15880,15885,15894,15896,15897,15899,15939,15940,15945,15953,15972,15995,16022,16053,16055,16062,16071,16085,16088,16091,16095,16115,16127,16156,16161,16176,16212,16249,16286,16337,16357,16361,16362,16366,16375,16381,16384,16386,16414,16417,16427,16472,16474,16497,16518,16521,16523,16526,16528,16541,16542,16543,16551,16566,16621,16626,16646,16657,16670,16675,16717,16723,16751,16777,16781,16783,16790,16808,16809,16814,16816,16818,16819,16833,16841,16848,16908,16943,16950,16976,16982,16984,16998,17047,17049,17050,17069,17090,17092,17114,17116,17124,17132,17155,17163,17188,17224,17230,17240,17246,17256,17273,17288,17290,17300,17307,17309,17321,17331,17334,17335,17361,17365,17387,17391,17419,17422,17426,17442,17444,17496,17497,17500,17528,17542,17555,17561,17566,17571,17573,17607,17611,17613,17625,17629,17630,17659,17660,17679,17688,17702,17708,17711,17712,17716,17717,17721,17735,17736,17753,17759,17761,17777,17779,17783,17810,17817,17820,17834,17839,17857,17862,17869,17879,17882,17914,17919,17924,17930,17933,17936,17947,17950,17967,17983,17999,18009,18044,18061,18071,18073,18079,18081,18118,18122,18142,18176,18216,18218,18220,18222,18226,18242,18253,18260,18264,18277,18279,18293,18295,18300,18308,18309,18331,18332,18348,18360,18382,18388,18389,18390,18406,18410,18424,18429,18443,18451,18494,18520,18522,18524,18552,18554,18558,18578,18598,18605,18625,18653,18664,18668,18693,18700,18702,18705,18708,18718,18728,18757,18762,18764,18775,18811,18814,18819,18822,18827,18830,18839,18843,18849,18853,18854,18861,18871,18877,18883,18888,18905,18908,18912,18947,18982,18995,19001,19010,19015,19018,19022,19055,19086,19105,19107,19110,19124,19128,19140,19145,19165,19173,19178,19181,19222,19229,19238,19254,19255,19259,19260,19277,19282,19284,19287,19290,19304,19314,19315,19325,19367,19375,19378,19381,19388,19404,19414,19416,19418,19439,19447,19449,19452,19455,19460,19462,19467,19486,19496,19507,19511,19551,19574,19581,19607,19624,19634,19639,19644,19650,19652,19657,19659,19661,19668,19677,19679,19684,19695,19707,19710,19725,19731,19733,19772,19773,19774,19794,19807,19812,19819,19825,19826,19830,19832,19855,19856,19871,19877,19881,19886,19901,19908,19913,19921,19923,19931,19937,19965,19972,19973,19980,19984,19996,20001,20040,20045,20060,20091,20095,20104,20119,20140,20175,20180,20184,20192,20193,20194,20213,20217,20232,20261,20276,20277,20304,20308,20318,20348,20354,20357,20363,20370,20379,20390,20405,20433,20437,20439,20440,20443,20445,20447,20459,20461,20467,20488,20525,20529,20542,20545,20546,20553,20564,20567,20577,20579,20588,20595,20616,20626,20638,20647,20648,20656,20659,20660,20698,20699,20700,20708,20718,20727,20736,20749,20758,20772,20775,20777,20781,20794,20803,20814,20847,20865,20917,20919,20940,20957,20959,20960,20979,20983,20986,20988,21004,21009,21011,21016,21038,21060,21075,21107,21116,21117,21118,21119,21122,21123,21143,21151,21158,21159,21167,21170,21171,21183,21198,21218,21247,21252,21256,21263,21272,21279,21283,21285,21288,21300,21301,21323,21325,21338,21344,21350,21367,21368,21370,21376,21378,21380,21384,21394,21398,21416,21419,21421,21427,21447,21448,21449,21457,21464,21470,21485,21486,21492,21493,21510,21520,21522,21524,21526,21529,21534,21545,21546,21551,21556,21575,21589,21591,21607,21609,21618,21623,21633,21640,21650,21659,21661,21663,21664,21680,21684,21690,21695,21702,21704,21714,21719,21721,21727,21735,21741,21749,21764,21776,21777,21778,21800,21824,21843,21850,21864,21867,21880,21883,21888,21895,21906,21910,21917,21945,21954,21955,21968,21990,21997,21999,22015,22018,22027,22038,22039,22044,22062,22067,22071,22072,22077,22096,22100,22106,22117,22119,22132,22163,22164,22170,22174,22178,22187,22195,22206,22215,22241,22251,22255,22263,22276,22278,22283,22298,22302,22320,22324,22332,22340,22343,22349,22363,22364,22382,22395,22406,22407,22412,22421,22432,22436,22446,22450,22453,22460,22465,22476,22495,22496,22501,22512,22519,22528,22529,22555,22559,22561,22570,22579,22580,22588,22595,22603,22605,22620,22622,22626,22655,22658,22669,22682,22685,22693,22696,22709,22710,22713,22714,22715,22726,22727,22747,22751,22759,22765,22780,22781,22787,22804,22819,22820,22829,22833,22835,22840,22858,22866,22879,22883,22897,22900,22911,22915,22920,22923,22930,22944,22947,22951,22960,22972,22974,22979,23007,23009,23024,23029,23033,23034,23043,23052,23055,23062,23069,23072,23078,23082,23087,23089,23093,23103,23112,23118,23124,23137,23156,23179,23190,23214,23232,23239,23240,23242,23249,23252,23262,23270,23273,23279,23295,23308,23318,23326,23355,23367,23368,23378,23401,23405,23428,23430,23438,23444,23446,23456,23463,23476,23480,23484,23528,23546,23553,23555,23568,23569,23577,23586,23616,23617,23621,23623,23626,23642,23646,23648,23653,23662,23665,23676,23682,23691,23693,23695,23709,23716,23719,23768,23774,23777,23806,23825,23846,23849,23863,23898,23902,23920,23925,23927,23936,23944,23949,23951,23953,23955,23968,23996,24009,24015,24016,24021,24024,24033,24060,24064,24076,24099,24100,24106,24110,24115,24135,24145,24154,24159,24164,24196,24217,24226,24233,24236,24237,24239,24249,24258,24268,24270,24272,24275,24278,24291,24296,24306,24329,24335,24362,24368,24386,24393,24408,24422,24428,24430,24437,24453,24475,24484,24505,24506,24522,24530,24556,24563,24565,24575,24577,24581,24582,24584,24586,24590,24617,24634,24635,24656,24668,24677,24690,24706,24707,24709,24721,24724,24726,24752,24754,24756,24773,24779,24780,24790,24794,24803,24805,24816,24825,24832,24841,24862,24883,24899,24931,24937,24946,24953,24956,24963,24993,24996,25030,25035,25036,25037,25043,25048,25062,25077,25081,25105,25116,25117,25120,25131,25136,25138,25171,25175,25187,25188,25200,25225,25281,25282,25287,25288,25291,25297,25300,25318,25322,25327,25329,25330,25332,25351,25356,25367,25383,25384,25386,25406,25408,25412,25416,25436,25440,25448,25452,25471,25484,25486,25497,25514,25515,25523,25526,25539,25542,25548,25555,25560,25584,25640,25646,25648,25660,25664,25676,25687,25692,25697,25762,25764,25765,25790,25798,25806,25807,25813,25820,25821,25854,25859,25864,25887,25889,25904,25919,25955,25959,25965,25971,26000,26006,26023,26033,26043,26055,26117,26134,26147,26175,26204,26221,26229,26240,26261,26274,26317,26340,26343,26360,26366,26375,26390,26413,26415,26424,26431,26444,26454,26460,26469,26474,26480,26541,26595,26596,26603,26634,26639,26651,26677,26709,26713,26742,26760,26769,26801,26820,26835,26842,26843,26845,26853,26854,26864,26873,26881,26905,26907,26923,26944,26959,26973,27000,27001,27038,27057,27060,27061,27062,27076,27143,27158,27170,27186,27197,27262,27290,27366,27372,27374,27379,27384,27406,27438,27525,27530,27552,27571,27578,27584,27633,27644,27646,27677,27688,27707,27722,27738,27745,27770,27795,27832,27846,27851,27918,27921,27923,27924,27926,27950,27957,27985,28015,28066,28072,28077,28080,28094,28120,28138,28151,28163,28213,28256,28264,28283,28339,28372,28440,28442,28465,28511,28537,28614,28615,28616,28623,28627,28662,28680,28681,28682,28683,28702,28710,28712,28728,28749,28781,28826,28844,28845,28847,28852,28944,29054,29061,29064,29073,29133,29223,29325,29379,29417,29460,29539,29571,29611,29613,29635,29646,29719,29727,29930,29962,30050,30274,30318,30790,30919,30942,30960,31881,31908,32820,32840,33417,33749,35000,35330,35711,35713,35740,35744,35774,35858,35955,36097,36216,36323,36492,37077,38932,38958,38975,39020,39064,39159,39398,39530,39966,39981,39998,40036,40116,40168,40184,40492,40583,40605,40611,41257,41325,41362,42009,42032,45008)
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 | 1997 | 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 | 1.46 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.06 ms |
init | 0.53 ms |
System lock | 0.02 ms |
optimizing | 0.15 ms |
statistics | 4.39 ms |
preparing | 2.24 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.64 ms |
end | 0.01 ms |
query end | 0.03 ms |
closing tables | 0.02 ms |
freeing items | 0.11 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 |