Tiempo de la consulta: 13.33 ms Después de la última consulta: 2.42 ms Consulta a la memoria: 0.846 MB memoria antes de la consulta: 4.488 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-08 01:34:48')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-08 01:34:48')
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,49,52,58,59,89,117,131,134,136,137,140,142,143,144,145,146,154,170,172,178,179,181,190,198,202,215,216,221,224,225,244,254,262,271,280,287,290,291,293,325,332,344,350,353,374,376,377,378,379,380,394,434,437,444,445,446,456,458,473,474,478,481,489,510,511,521,558,593,596,603,607,608,609,611,615,618,625,641,642,647,648,650,651,652,654,671,681,686,687,689,693,695,723,729,757,797,814,816,824,831,843,845,854,868,875,879,891,911,915,936,941,950,952,955,964,976,986,997,1010,1027,1033,1043,1044,1047,1057,1066,1071,1080,1094,1130,1143,1158,1185,1186,1207,1210,1214,1215,1226,1227,1232,1234,1240,1247,1252,1253,1256,1266,1267,1268,1287,1302,1317,1329,1335,1359,1467,1486,1534,1574,1601,1637,1659,1664,1686,1698,1709,1721,1778,1805,1863,1896,1931,1932,1996,2094,2221,2428,2455,2485,2656,2697,2714,2738,2742,2757,2855,2869,2911,2964,2997,3020,3022,3028,3045,3091,3124,3126,3209,3212,3215,3223,3291,3295,3301,3329,3340,3353,3398,3546,3595,3630,3668,3669,3671,3687,3696,3706,3738,3783,3801,3816,3842,3864,3868,3870,3895,3957,4087,4096,4120,4128,4163,4199,4206,4276,4281,4319,4338,4378,4399,4547,4578,4638,4765,4790,4799,4815,4855,4911,4935,4965,5001,5053,5062,5075,5085,5098,5147,5151,5166,5184,5195,5215,5263,5273,5300,5306,5374,5406,5471,5519,5559,5585,5647,5648,5659,5730,5756,5782,5785,5814,5835,5846,5852,5870,5894,5906,5918,5927,6014,6032,6039,6069,6084,6113,6131,6222,6226,6234,6276,6292,6333,6373,6384,6448,6464,6470,6484,6510,6520,6538,6542,6543,6573,6616,6631,6641,6666,6677,6687,6688,6703,6716,6719,6779,6908,6924,6939,6940,6942,6957,6961,6965,6966,6968,6989,6994,6998,7004,7016,7043,7048,7075,7100,7154,7161,7222,7245,7269,7277,7278,7279,7285,7291,7303,7327,7338,7346,7361,7365,7380,7387,7401,7403,7414,7423,7427,7434,7446,7449,7450,7454,7483,7486,7507,7508,7513,7522,7534,7546,7551,7556,7560,7577,7583,7638,7666,7677,7702,7713,7719,7730,7757,7764,7774,7812,7821,7829,7831,7840,7847,7862,7867,7871,7894,7901,7904,7916,7923,7926,7957,7965,7967,7968,7978,7983,7985,7989,8024,8027,8054,8060,8108,8138,8177,8178,8258,8294,8296,8299,8306,8307,8313,8351,8356,8357,8418,8477,8551,8572,8610,8678,8685,8694,8710,8715,8810,8835,8891,8909,8923,8940,8948,8950,8973,8995,9046,9057,9091,9096,9110,9137,9140,9180,9186,9190,9199,9203,9238,9239,9249,9252,9254,9296,9318,9362,9381,9429,9472,9541,9576,9641,9685,9716,9723,9725,9731,9734,9779,9784,9791,9832,9861,9873,9886,9891,9915,9956,9958,9966,9985,10011,10014,10028,10044,10046,10092,10100,10113,10120,10147,10149,10199,10207,10224,10227,10259,10265,10296,10313,10342,10357,10382,10401,10407,10415,10464,10499,10534,10537,10611,10623,10721,10774,10777,10782,10803,10820,10821,10833,10835,10916,10927,10932,10957,10971,10986,11005,11009,11027,11043,11091,11150,11192,11206,11224,11238,11249,11260,11263,11310,11333,11362,11365,11377,11419,11430,11436,11441,11462,11465,11468,11473,11475,11538,11539,11549,11590,11663,11666,11680,11706,11713,11716,11750,11772,11775,11791,11799,11808,11816,11863,11870,11879,11893,11926,11950,11976,11979,12009,12011,12025,12036,12042,12069,12085,12112,12131,12136,12147,12152,12174,12178,12179,12204,12270,12315,12317,12319,12324,12334,12362,12370,12388,12401,12413,12420,12427,12440,12446,12448,12475,12492,12514,12550,12579,12581,12582,12588,12604,12609,12625,12636,12670,12676,12681,12685,12709,12738,12758,12795,12806,12838,12839,12849,12851,12898,12910,12943,12960,12978,12985,12990,12998,13004,13036,13065,13069,13070,13079,13094,13107,13121,13132,13197,13202,13209,13216,13222,13229,13250,13263,13285,13307,13315,13332,13334,13335,13345,13358,13359,13379,13387,13396,13420,13440,13445,13446,13461,13476,13481,13492,13500,13515,13594,13647,13664,13666,13696,13697,13708,13722,13728,13753,13803,13837,13880,13892,13894,13901,13922,13972,14040,14048,14078,14083,14092,14098,14116,14133,14146,14152,14175,14198,14199,14205,14232,14234,14248,14250,14257,14258,14268,14289,14305,14336,14352,14354,14355,14372,14378,14396,14421,14424,14426,14439,14451,14453,14480,14493,14494,14502,14505,14531,14577,14583,14596,14625,14629,14630,14637,14654,14676,14684,14691,14695,14699,14722,14741,14752,14754,14779,14789,14798,14809,14840,14843,14845,14852,14856,14857,14889,14939,14954,14955,14969,14982,14983,14984,14986,14988,15002,15007,15018,15060,15077,15086,15090,15092,15105,15107,15109,15115,15123,15129,15133,15148,15156,15173,15180,15184,15186,15205,15206,15214,15217,15226,15257,15279,15284,15286,15291,15299,15304,15315,15316,15325,15332,15335,15344,15351,15358,15371,15376,15392,15403,15406,15408,15410,15417,15424,15433,15443,15444,15475,15483,15492,15500,15520,15522,15569,15577,15580,15581,15598,15600,15608,15609,15616,15627,15632,15637,15639,15642,15644,15656,15672,15683,15689,15700,15714,15723,15732,15733,15742,15745,15751,15753,15755,15762,15778,15785,15788,15790,15805,15811,15812,15832,15835,15840,15878,15879,15880,15895,15897,15898,15902,15954,15960,15966,15998,15999,16010,16024,16030,16040,16052,16053,16055,16078,16088,16095,16127,16133,16148,16156,16167,16180,16217,16219,16249,16261,16278,16279,16284,16295,16328,16336,16353,16357,16359,16362,16368,16381,16384,16389,16401,16404,16417,16427,16436,16447,16458,16474,16518,16521,16523,16542,16551,16570,16588,16609,16613,16622,16627,16657,16659,16662,16670,16675,16682,16698,16778,16781,16783,16792,16816,16820,16841,16865,16866,16872,16893,16903,16909,16913,16982,17014,17049,17072,17096,17116,17142,17149,17153,17158,17163,17185,17186,17188,17214,17240,17246,17247,17256,17269,17288,17331,17336,17346,17365,17387,17390,17410,17422,17424,17437,17441,17444,17449,17452,17460,17485,17497,17498,17512,17536,17542,17559,17561,17566,17573,17574,17580,17596,17599,17620,17625,17629,17630,17632,17633,17643,17650,17660,17681,17688,17701,17703,17705,17711,17712,17717,17733,17734,17736,17753,17759,17761,17772,17774,17779,17783,17784,17814,17816,17820,17824,17834,17844,17851,17862,17885,17914,17918,17919,17930,17933,17934,17936,17941,17950,17951,17959,17967,17973,17983,18006,18014,18044,18055,18061,18068,18074,18102,18118,18160,18179,18220,18221,18222,18231,18238,18257,18260,18262,18276,18277,18284,18295,18300,18301,18306,18311,18315,18320,18345,18352,18353,18366,18382,18401,18423,18429,18434,18435,18448,18454,18463,18491,18503,18516,18520,18524,18537,18549,18552,18582,18599,18605,18642,18643,18658,18664,18668,18693,18702,18705,18728,18732,18744,18750,18771,18792,18810,18811,18821,18830,18839,18846,18847,18849,18850,18853,18871,18873,18877,18888,18894,18905,18909,18920,18936,18937,18959,18960,18972,18973,18984,18993,19001,19003,19015,19019,19027,19055,19063,19105,19106,19112,19124,19128,19129,19134,19136,19140,19145,19151,19172,19173,19179,19184,19191,19205,19222,19224,19230,19247,19254,19259,19277,19285,19286,19287,19296,19309,19311,19313,19315,19316,19325,19344,19352,19359,19381,19405,19422,19424,19432,19437,19455,19457,19460,19486,19492,19521,19533,19536,19556,19562,19565,19570,19572,19574,19604,19607,19619,19622,19626,19639,19666,19670,19679,19684,19697,19698,19710,19720,19725,19733,19742,19748,19752,19756,19758,19773,19778,19783,19790,19794,19806,19807,19830,19848,19855,19871,19874,19877,19881,19901,19915,19923,19925,19944,19957,19965,19972,19982,19984,19993,19996,20008,20025,20035,20042,20076,20091,20098,20104,20117,20119,20148,20150,20158,20163,20166,20175,20189,20204,20205,20233,20276,20282,20286,20288,20299,20300,20305,20328,20332,20333,20344,20345,20352,20357,20359,20382,20390,20399,20405,20419,20420,20425,20433,20437,20445,20447,20457,20474,20487,20488,20489,20515,20537,20542,20545,20554,20588,20608,20637,20638,20659,20698,20704,20708,20712,20713,20718,20752,20772,20776,20777,20778,20780,20781,20782,20794,20806,20814,20829,20832,20841,20869,20877,20886,20890,20912,20913,20933,20940,20956,20959,20960,20974,20979,20981,20989,21013,21017,21019,21055,21067,21075,21085,21086,21090,21108,21110,21116,21117,21118,21121,21122,21128,21133,21143,21149,21163,21170,21174,21181,21198,21229,21231,21247,21258,21298,21308,21321,21324,21325,21340,21344,21350,21353,21361,21367,21370,21378,21380,21387,21392,21396,21398,21411,21421,21435,21448,21449,21457,21470,21482,21494,21496,21520,21521,21522,21540,21542,21547,21551,21566,21577,21591,21607,21609,21611,21628,21640,21656,21659,21660,21663,21665,21680,21683,21684,21689,21702,21713,21714,21716,21741,21742,21749,21750,21764,21775,21776,21777,21778,21818,21859,21863,21864,21867,21878,21883,21895,21906,21917,21928,21934,21961,21967,21968,21990,21994,21997,22018,22031,22038,22039,22044,22045,22053,22067,22079,22088,22096,22106,22119,22122,22132,22137,22170,22178,22180,22207,22215,22219,22255,22266,22276,22278,22292,22298,22316,22320,22326,22337,22344,22345,22349,22352,22362,22363,22380,22382,22395,22400,22436,22450,22460,22465,22476,22484,22485,22488,22493,22498,22501,22546,22551,22553,22555,22570,22573,22579,22588,22615,22659,22668,22671,22676,22681,22691,22693,22698,22709,22715,22737,22744,22751,22754,22759,22767,22779,22781,22786,22797,22804,22820,22822,22834,22840,22845,22850,22855,22857,22866,22873,22898,22903,22915,22918,22920,22930,22936,22941,22944,22960,22963,22978,22989,22998,23009,23013,23026,23029,23034,23047,23072,23077,23087,23093,23103,23112,23115,23137,23156,23181,23202,23213,23224,23232,23242,23252,23260,23270,23278,23279,23288,23289,23308,23310,23313,23317,23319,23338,23353,23367,23368,23373,23397,23400,23401,23405,23430,23438,23444,23457,23468,23482,23484,23489,23516,23520,23527,23535,23543,23544,23553,23555,23569,23577,23584,23621,23623,23624,23642,23646,23665,23666,23667,23682,23686,23691,23693,23695,23705,23709,23716,23719,23726,23731,23732,23756,23768,23780,23787,23788,23846,23849,23855,23859,23869,23872,23873,23876,23879,23902,23911,23920,23937,23943,23944,23949,23955,23965,23968,23969,23989,24002,24003,24009,24015,24024,24033,24060,24066,24076,24082,24090,24107,24110,24114,24115,24124,24159,24164,24170,24172,24190,24196,24201,24207,24210,24237,24239,24248,24258,24270,24284,24296,24306,24335,24340,24362,24422,24430,24432,24434,24437,24439,24441,24453,24458,24461,24475,24481,24485,24499,24506,24520,24530,24556,24565,24567,24575,24584,24617,24630,24635,24656,24657,24671,24672,24673,24677,24681,24690,24707,24720,24724,24726,24734,24754,24755,24766,24775,24779,24790,24794,24795,24805,24807,24816,24836,24841,24845,24865,24880,24887,24894,24896,24922,24927,24931,24945,24946,24963,24967,24993,25001,25002,25013,25026,25036,25037,25038,25040,25041,25043,25073,25081,25090,25091,25094,25103,25109,25114,25117,25136,25137,25146,25163,25164,25167,25170,25192,25193,25200,25218,25258,25281,25282,25287,25291,25296,25297,25315,25321,25327,25329,25332,25353,25356,25367,25371,25372,25373,25380,25384,25386,25390,25391,25393,25408,25414,25416,25431,25433,25440,25446,25451,25452,25457,25459,25461,25464,25465,25467,25468,25469,25470,25472,25474,25476,25477,25482,25483,25484,25485,25486,25489,25490,25492,25493,25494,25495,25499,25504,25506,25508,25509,25510,25512,25513,25515,25517,25519,25523,25526,25535,25536,25537,25538,25540,25545,25546,25548,25552,25554,25555,25559,25560,25569,25572,25576,25578,25582,25583,25587,25588,25596,25600,25601,25631,25638,25640,25663,25664,25672,25674,25676,25687,25692,25693,25697,25740,25746,25753,25765,25790,25806,25807,25813,25822,25854,25887,25889,25911,25919,25937,25941,25952,25953,25959,25963,25971,25974,26023,26044,26047,26055,26073,26116,26157,26174,26191,26207,26209,26218,26225,26229,26236,26247,26257,26261,26271,26274,26322,26340,26344,26355,26362,26375,26387,26390,26392,26412,26413,26420,26421,26432,26434,26452,26481,26506,26521,26522,26554,26560,26561,26562,26572,26577,26578,26594,26595,26596,26598,26627,26653,26683,26694,26701,26744,26780,26785,26787,26796,26835,26842,26843,26853,26854,26864,26873,26887,26897,26924,26933,26934,26936,26959,26962,27001,27024,27028,27039,27040,27059,27061,27062,27067,27075,27085,27095,27096,27123,27127,27158,27197,27233,27279,27290,27300,27305,27342,27346,27355,27368,27374,27379,27384,27390,27403,27420,27442,27552,27563,27578,27584,27634,27646,27707,27724,27739,27745,27795,27832,27851,27893,27898,27911,27921,27923,27924,27926,27950,28066,28068,28094,28116,28135,28185,28213,28242,28264,28283,28294,28295,28372,28423,28440,28442,28478,28511,28534,28537,28539,28609,28617,28623,28635,28651,28712,28714,28715,28741,28749,28751,28817,28826,28852,28870,28930,29034,29061,29073,29089,29214,29219,29222,29223,29235,29242,29269,29314,29325,29348,29380,29381,29413,29445,29467,29484,29499,29539,29550,29551,29611,29658,29683,29719,29777,29788,29801,29814,29837,29839,29864,29872,29896,29897,29915,29918,29931,29962,30274,30280,30414,30941,31090,31463,31510,31533,31640,31670,31684,31725,31821,31837,31852,31899,31908,32331,32472,32565,32679,32820,32840,32912,33385,33477,33575,33605,34030,34071,34087,34150,34159,34195,34243,34262,34270,34375,34381,34611,34956,35000,35266,35485,35574,35628,35632,35643,35667,35674,35711,35713,35740,35744,35759,35760,35774,35784,35822,35858,35881,36007,36141,36143,36214,36216,36251,36283,36339,36382,36431,36474,36492,36511,36617,36620,36838,36949,37002,37056,37397,37411,37422,37524,37532,37688,37758,37796,38071,38199,38363,38452,38585,38664,38665,38719,38762,38884,38887,38898,38933,38958,38960,38975,39020,39064,39121,39159,39227,39231,39335,39342,39397,39480,39572,39600,39617,39687,39769,39826,39839,39846,39877,39896,39897,39958,39964,39977,39981,39998,40025,40052,40064,40082,40168,40183,40184,40292,40332,40344,40369,40414,40521,40530,40611,40636,40650,40672,40684,40703,40760,40861,40909,41070,41095,41104,41134,41188,41204,41325,41464,41503,41601,41677,41681,41706,41778,41861,41994,42107,42185,42205,42357,42387,42396,42408,42590,42639,42708,42716,42836,42890,42900,42922,42952,42991,42993,42998,43050,43051,43078,43114,43120,43191,43193,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,44883,44884,44885,44886,44887,44888,44889,44890,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 | 2465 | 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.16 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.46 ms |
System lock | 0.02 ms |
optimizing | 0.15 ms |
statistics | 3.87 ms |
preparing | 1.98 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 4.56 ms |
end | 0.03 ms |
query end | 0.11 ms |
closing tables | 0.03 ms |
freeing items | 0.21 ms |
cleaning up | 0.05 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 |