Tiempo de la consulta: 8.21 ms Después de la última consulta: 1.51 ms Consulta a la memoria: 0.408 MB memoria antes de la consulta: 4.405 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 03:18:39')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 03:18:39')
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(14,19,20,21,22,23,24,25,26,27,28,29,30,31,32,49,72,82,93,127,161,162,163,164,204,213,253,263,271,272,279,287,335,345,346,349,350,352,353,403,407,417,484,485,495,505,507,550,551,570,574,575,583,595,608,634,667,686,705,708,709,710,711,712,713,783,801,816,837,881,882,895,911,917,938,961,968,971,981,999,1059,1099,1124,1134,1198,1204,1207,1226,1232,1238,1347,1352,1357,1432,1555,1587,1594,1664,1696,1713,1734,1765,1781,1785,1787,1800,1804,1913,2024,2123,2150,2210,2228,2260,2290,2293,2337,2349,2365,2378,2424,2427,2468,2482,2509,2531,2688,2689,2713,2726,2758,2797,2798,2825,2828,2853,2935,2952,2967,2997,3067,3076,3193,3211,3212,3258,3306,3319,3353,3372,3373,3376,3408,3410,3442,3464,3475,3495,3594,3626,3663,3696,3757,3769,3794,3837,3871,4004,4072,4092,4131,4166,4215,4227,4383,4410,4493,4580,4587,4612,4613,4614,4615,4617,4631,4640,4832,4836,4863,4910,5051,5092,5224,5268,5298,5365,5451,5544,5596,5634,5635,5660,5726,5727,5730,5769,5778,5798,5934,5943,5944,5973,6039,6055,6131,6166,6186,6192,6245,6264,6268,6310,6311,6324,6367,6380,6466,6484,6503,6571,6586,6604,6605,6609,6616,6645,6665,6681,6708,6711,6764,6770,6775,6788,6793,6799,6809,6912,6919,6939,6945,6977,7001,7081,7212,7245,7271,7290,7330,7361,7368,7407,7413,7415,7458,7462,7482,7484,7492,7513,7565,7585,7618,7624,7690,7711,7716,7720,7735,7745,7758,7762,7799,7802,7810,7837,7847,7866,7913,7933,7950,7965,7980,7994,7999,8000,8027,8068,8073,8085,8088,8135,8222,8250,8255,8351,8354,8416,8436,8437,8532,8566,8568,8587,8603,8610,8681,8706,8764,8860,8964,9012,9018,9051,9091,9142,9165,9239,9257,9292,9308,9351,9481,9542,9552,9734,9745,9757,9792,9820,9823,9920,9945,9947,10038,10039,10051,10100,10216,10237,10241,10248,10266,10282,10291,10301,10369,10385,10400,10422,10436,10440,10458,10478,10510,10554,10563,10598,10604,10634,10666,10686,10688,10764,10811,10832,10857,10874,10888,10912,10971,11006,11091,11098,11123,11124,11126,11144,11203,11235,11290,11320,11323,11388,11457,11476,11487,11702,11703,11721,11722,11761,11762,11765,11803,11859,11900,11909,11925,11946,12032,12035,12097,12113,12126,12172,12175,12186,12216,12224,12236,12237,12251,12334,12364,12369,12393,12410,12437,12463,12471,12474,12488,12489,12493,12510,12541,12592,12608,12611,12644,12650,12669,12686,12708,12718,12753,12779,12806,12900,13020,13027,13138,13143,13154,13176,13187,13188,13190,13191,13246,13259,13276,13309,13349,13352,13395,13404,13434,13441,13456,13474,13512,13573,13575,13580,13604,13605,13609,13621,13631,13662,13671,13673,13674,13685,13693,13702,13727,13748,13750,13782,13783,13827,13858,13860,13867,13873,13886,13924,13941,13947,13986,13994,14005,14008,14060,14062,14079,14169,14184,14205,14208,14226,14227,14263,14273,14277,14339,14348,14357,14368,14375,14384,14408,14456,14481,14482,14504,14527,14561,14600,14624,14648,14652,14653,14663,14665,14669,14679,14684,14688,14692,14703,14709,14713,14726,14744,14749,14750,14754,14762,14790,14792,14794,14815,14832,14849,14869,14905,14906,14911,14941,14949,14970,14992,14996,15007,15020,15028,15040,15045,15046,15069,15108,15113,15120,15128,15147,15180,15194,15196,15204,15215,15217,15234,15243,15262,15263,15266,15293,15298,15304,15324,15335,15356,15360,15365,15366,15370,15393,15402,15439,15464,15473,15477,15485,15521,15539,15540,15548,15550,15551,15562,15594,15600,15604,15664,15689,15703,15709,15714,15725,15728,15744,15751,15753,15761,15763,15785,15796,15812,15819,15837,15841,15851,15858,15862,15866,15873,15880,15917,15931,15933,15945,15955,16020,16037,16050,16057,16093,16115,16120,16122,16127,16153,16157,16166,16200,16249,16257,16297,16346,16354,16369,16370,16411,16422,16429,16434,16445,16451,16455,16461,16478,16513,16539,16562,16566,16578,16605,16611,16612,16619,16644,16661,16665,16678,16722,16771,16787,16819,16820,16824,16825,16845,16848,16862,16867,16894,16967,17014,17034,17052,17059,17080,17101,17115,17121,17128,17132,17160,17163,17166,17167,17178,17194,17236,17244,17257,17270,17291,17296,17299,17304,17335,17337,17353,17369,17373,17385,17407,17420,17422,17431,17432,17439,17465,17493,17530,17531,17533,17552,17569,17608,17623,17626,17630,17635,17688,17731,17747,17766,17770,17772,17775,17844,17852,17857,17862,17875,17878,17889,17895,17902,17906,17950,17952,17980,17987,18022,18030,18031,18038,18045,18057,18072,18116,18124,18140,18169,18179,18200,18216,18217,18227,18260,18282,18293,18311,18314,18316,18318,18331,18334,18364,18377,18402,18425,18431,18432,18440,18481,18493,18496,18514,18519,18524,18543,18566,18590,18595,18609,18646,18649,18658,18659,18664,18668,18679,18687,18692,18738,18739,18781,18782,18793,18817,18837,18870,18891,18906,18907,18912,18914,18926,18927,18929,18930,18949,18951,18952,18978,18989,18991,19013,19053,19059,19075,19078,19083,19100,19105,19148,19153,19160,19168,19189,19204,19211,19219,19235,19236,19237,19245,19263,19268,19271,19293,19309,19318,19350,19356,19358,19406,19411,19427,19448,19457,19460,19472,19484,19494,19505,19507,19516,19519,19526,19535,19553,19556,19593,19595,19596,19612,19625,19645,19646,19699,19700,19706,19720,19723,19771,19792,19841,19875,19881,19894,19904,19916,19937,19953,19957,19967,19988,19989,20008,20012,20016,20066,20076,20133,20137,20153,20154,20180,20181,20191,20215,20220,20234,20295,20348,20349,20376,20396,20397,20398,20403,20429,20432,20488,20524,20567,20638,20642,20649,20656,20658,20659,20662,20690,20714,20721,20726,20738,20744,20748,20764,20775,20776,20807,20880,20894,20896,20906,20921,20922,20950,20969,20980,21049,21080,21103,21115,21147,21171,21198,21213,21242,21251,21329,21331,21413,21422,21430,21449,21452,21457,21472,21481,21487,21520,21523,21524,21539,21546,21566,21576,21586,21598,21611,21612,21639,21668,21683,21709,21718,21719,21726,21734,21748,21781,21787,21798,21850,21855,21891,21916,21932,21952,21966,22021,22027,22038,22045,22066,22067,22087,22116,22129,22140,22149,22153,22167,22192,22196,22216,22218,22232,22238,22253,22268,22287,22289,22290,22295,22334,22346,22371,22388,22394,22402,22419,22424,22434,22439,22453,22458,22476,22486,22492,22494,22500,22503,22509,22514,22519,22543,22562,22587,22602,22620,22659,22671,22689,22708,22738,22739,22761,22781,22814,22839,22850,22851,22854,22865,22876,22888,22891,22911,22924,22931,22943,22950,22958,22964,22980,23013,23014,23023,23028,23033,23035,23053,23064,23069,23072,23104,23107,23122,23123,23131,23180,23184,23201,23210,23213,23219,23230,23233,23236,23249,23258,23261,23273,23281,23287,23299,23312,23313,23328,23350,23364,23365,23381,23428,23464,23469,23479,23489,23493,23516,23523,23541,23542,23567,23592,23597,23613,23625,23626,23649,23650,23657,23659,23682,23720,23722,23729,23763,23771,23790,23793,23811,23819,23831,23855,23861,23874,23877,23887,23899,23929,23953,23955,23967,23971,23973,23984,24001,24027,24043,24062,24088,24105,24111,24135,24145,24153,24158,24165,24166,24176,24185,24198,24199,24208,24229,24247,24255,24281,24282,24286,24289,24316,24334,24337,24373,24375,24390,24399,24406,24463,24485,24497,24498,24536,24539,24607,24658,24679,24681,24713,24718,24722,24743,24765,24766,24784,24788,24814,24819,24823,24838,24853,24881,24896,24906,24911,24924,24944,24945,24951,24952,24956,24958,25032,25048,25057,25062,25093,25105,25155,25183,25184,25205,25267,25268,25289,25312,25318,25342,25349,25365,25397,25417,25421,25449,25474,25488,25505,25518,25539,25541,25553,25554,25557,25585,25589,25590,25595,25600,25635,25639,25646,25648,25668,25671,25673,25723,25727,25734,25747,25757,25758,25771,25781,25797,25800,25817,25830,25836,25847,25870,25916,25924,25927,25941,25942,25949,25950,25956,25958,25961,25969,25990,25992,25994,25995,26000,26010,26013,26020,26025,26033,26035,26048,26060,26073,26074,26082,26087,26113,26120,26136,26146,26147,26153,26154,26159,26160,26161,26166,26179,26185,26187,26191,26194,26215,26221,26227,26234,26249,26259,26282,26295,26296,26305,26337,26359,26363,26369,26386,26388,26395,26432,26455,26508,26525,26564,26570,26586,26590,26628,26630,26636,26710,26726,26779,26780,26815,26820,26854,26860,26873,26916,26927,26933,26935,26944,26964,26968,26990,27005,27042,27060,27084,27103,27108,27109,27115,27131,27137,27151,27158,27187,27192,27196,27209,27211,27212,27216,27240,27242,27252,27268,27269,27270,27273,27298,27307,27323,27327,27343,27363,27367,27405,27487,27496,27526,27574,27578,27583,27595,27656,27688,27695,27707,27717,27786,27799,27861,27898,27912,27922,27923,27924,27956,28005,28019,28031,28033,28059,28066,28075,28094,28097,28107,28114,28120,28128,28129,28153,28163,28237,28240,28243,28264,28294,28303,28310,28318,28435,28555,28621,28623,28764,28771,28778,28846,28872,28931,28943,28950,28995,29045,29152,29166,29172,29210,29226,29229,29272,29358,29438,29509,29510,29512,29537,29572,29611,29616,29625,29653,29716,29724,29757,29758,29805,29846,29857,29863,29928,30111,30433,30434,30525,31697,31735,31820,31837,31853,31890,32720,32767,32768,33874,33908,34168,34307,34646,34811,35000,35100,35191,35232,35238,35239,35250,35289,35295,35345,35365,35376,35397,35540,35554,35621,35641,35660,35661,35727,35728,35744,35777,35808,35814,35835,35846,35948,36015,36141,36220,36368,36373,36380,36385,36386,36418,36441,36790,36791,36792,36793,36849,36889,36941,36984,37015,37104,37245,37370,37473,37508,37544,37643,37644,37677,37757,37834,37902,38058,38092,38330,38362,38418,38617,38681,38723,38734,38790,38799,38821,38824,38829,38877,38912,38965,38990,39039,39110,39133,39155,39205,39244,39290,39293,39297,39333,39366,39442,39460,39463,39465,39469,39470,39483,39519,39559,39686,39698,39710,39718,39724,39746,39837,39856,39866,40059,40224,40259,40275,40319,40355,40560,40576,40624,40651,40855,40875,40896,41004,41009,41033,41123,41152,41171,41172,41176,41189,41201,41202,41212,41225,41239,41272,41289,41328,41339,41343,41415,41434,41479,41504,41550,41571,41591,41637,41737,41757,41783,41862,41948,41964,41980,42329,42482,42682,42736,42811,42941,43003,43043,43093,43104,43117,43167,43221,43240,43241,43326,43375,43446,43461,43475,43477,43483,43517,43518,43792,44122,44186,44187,44378,44509,44560,44581,44632,44640,44656,44718,44735,44788,44807,44829,44873,44881,44912,44935,44936,45174,45175,45223,45249,45274,45300,45313)
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 | 1739 | 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.84 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.32 ms |
System lock | 0.02 ms |
optimizing | 0.11 ms |
statistics | 2.53 ms |
preparing | 1.33 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 1.71 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.06 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 |