Tiempo de la consulta: 17.29 ms Después de la última consulta: 2.49 ms Consulta a la memoria: 0.846 MB memoria antes de la consulta: 4.469 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 01:20:07')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 01:20:07')
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(11,46,49,57,58,87,90,92,99,149,154,170,181,186,189,198,215,216,221,224,225,232,243,244,245,246,249,254,262,276,280,309,325,328,330,332,337,394,412,417,418,427,433,446,452,458,468,474,478,488,510,521,524,528,548,553,555,558,593,595,596,597,603,618,628,641,642,646,647,650,662,671,681,686,695,706,711,723,729,730,757,781,800,816,818,823,845,854,868,875,879,911,915,955,976,986,994,1001,1010,1023,1027,1033,1057,1066,1071,1072,1094,1114,1145,1158,1186,1207,1210,1214,1226,1234,1240,1264,1266,1267,1268,1272,1274,1275,1276,1277,1278,1314,1325,1335,1339,1359,1389,1390,1412,1462,1467,1504,1534,1574,1637,1659,1686,1709,1721,1778,1800,1805,1828,1896,1932,1960,1961,2012,2073,2085,2094,2185,2191,2221,2355,2428,2455,2638,2661,2689,2710,2811,2852,2855,2869,2964,3017,3022,3051,3067,3181,3188,3269,3295,3353,3398,3512,3546,3557,3595,3630,3696,3706,3727,3801,3864,3868,3870,3991,4096,4163,4276,4281,4334,4338,4360,4424,4457,4498,4547,4578,4765,4790,4799,4855,4911,4935,4965,5001,5053,5062,5085,5098,5147,5151,5166,5184,5195,5263,5273,5300,5306,5357,5374,5392,5406,5417,5462,5495,5519,5544,5582,5585,5603,5637,5646,5648,5659,5678,5702,5732,5756,5759,5768,5777,5779,5780,5782,5793,5794,5795,5804,5831,5835,5852,5889,5894,5899,5906,5910,5918,5919,5923,5927,5942,5999,6000,6002,6014,6016,6022,6032,6045,6060,6069,6160,6194,6220,6222,6226,6258,6261,6276,6312,6373,6377,6391,6401,6420,6448,6449,6476,6477,6510,6520,6542,6543,6545,6564,6587,6623,6641,6666,6677,6703,6716,6733,6766,6774,6779,6924,6939,6994,7004,7048,7195,7222,7258,7277,7285,7327,7338,7346,7391,7423,7446,7449,7473,7513,7527,7534,7551,7556,7560,7576,7577,7583,7595,7606,7666,7687,7697,7730,7738,7757,7760,7764,7788,7812,7829,7840,7853,7871,7875,7901,7904,7926,7968,8009,8027,8060,8064,8074,8078,8081,8088,8138,8164,8177,8178,8192,8215,8218,8258,8273,8294,8296,8299,8306,8351,8356,8357,8374,8418,8435,8461,8465,8487,8495,8572,8589,8637,8650,8651,8672,8678,8710,8810,8815,8835,8861,8895,8923,8940,8948,8969,8973,8995,9046,9067,9096,9110,9121,9140,9174,9175,9180,9182,9186,9190,9199,9237,9252,9254,9277,9362,9380,9381,9394,9424,9472,9541,9572,9576,9641,9663,9685,9697,9701,9702,9711,9731,9734,9781,9832,9873,9886,9891,9915,9932,9934,9956,10014,10044,10046,10113,10147,10149,10199,10207,10258,10342,10401,10407,10464,10499,10537,10572,10708,10774,10833,10932,10986,11009,11027,11043,11086,11131,11150,11238,11263,11377,11436,11465,11473,11538,11549,11590,11666,11680,11706,11713,11716,11750,11772,11775,11791,11870,11879,11917,11926,11979,12011,12036,12042,12069,12085,12130,12131,12136,12152,12226,12317,12319,12324,12334,12362,12370,12383,12440,12448,12514,12550,12576,12588,12604,12623,12636,12670,12676,12684,12738,12745,12746,12758,12788,12795,12806,12846,12849,12910,12928,12943,12960,12974,12998,13013,13037,13062,13065,13069,13070,13094,13107,13121,13130,13132,13169,13186,13188,13209,13222,13250,13263,13285,13345,13359,13379,13396,13435,13440,13446,13459,13481,13529,13556,13594,13664,13697,13708,13728,13753,13803,13892,13894,13987,14015,14040,14048,14078,14092,14133,14146,14175,14177,14193,14198,14199,14218,14232,14234,14268,14305,14341,14352,14355,14378,14421,14451,14480,14493,14494,14502,14505,14531,14577,14637,14651,14654,14691,14699,14703,14741,14752,14782,14798,14807,14810,14831,14857,14889,14914,14951,14955,14957,14969,14978,14982,14988,15002,15014,15060,15077,15090,15092,15105,15107,15115,15123,15133,15148,15171,15180,15184,15186,15206,15217,15226,15235,15257,15279,15284,15299,15322,15325,15344,15358,15371,15381,15403,15410,15417,15443,15483,15490,15492,15500,15577,15580,15598,15603,15609,15627,15632,15637,15639,15642,15644,15656,15667,15733,15734,15745,15751,15753,15762,15788,15802,15811,15832,15835,15840,15844,15878,15879,15885,15895,15902,15913,15931,15954,15960,15973,15998,16000,16010,16024,16040,16046,16052,16055,16078,16115,16122,16155,16156,16167,16217,16219,16228,16261,16277,16279,16284,16295,16328,16336,16353,16359,16368,16389,16401,16404,16412,16422,16436,16447,16458,16479,16509,16516,16518,16547,16568,16570,16588,16613,16627,16648,16659,16662,16682,16737,16778,16792,16810,16820,16846,16866,16893,16908,16909,16913,16917,16918,16995,17014,17063,17066,17072,17101,17114,17136,17149,17158,17166,17170,17172,17185,17214,17247,17269,17333,17346,17359,17380,17390,17400,17424,17441,17452,17460,17474,17485,17498,17512,17534,17536,17574,17580,17596,17620,17629,17633,17643,17644,17645,17650,17680,17699,17701,17705,17715,17733,17753,17759,17761,17772,17774,17783,17785,17798,17803,17816,17821,17824,17844,17862,17885,17886,17918,17946,17951,17959,17965,17973,17976,17977,18006,18014,18021,18035,18036,18046,18047,18055,18068,18082,18102,18151,18160,18168,18171,18179,18182,18191,18220,18221,18231,18238,18241,18253,18259,18276,18277,18284,18300,18306,18308,18315,18345,18347,18352,18353,18354,18366,18377,18382,18401,18413,18421,18423,18426,18434,18435,18473,18478,18491,18497,18500,18506,18516,18520,18524,18527,18537,18540,18545,18575,18582,18599,18603,18624,18635,18638,18643,18719,18732,18744,18746,18750,18751,18775,18779,18790,18792,18795,18802,18821,18828,18842,18846,18852,18868,18874,18909,18917,18918,18920,18936,18960,18972,18973,18993,19005,19019,19027,19038,19063,19079,19082,19106,19112,19136,19151,19172,19179,19191,19205,19224,19247,19267,19284,19285,19286,19288,19295,19299,19301,19307,19309,19310,19313,19316,19318,19320,19321,19352,19359,19390,19405,19414,19422,19432,19437,19457,19473,19484,19492,19495,19531,19533,19561,19562,19568,19587,19594,19604,19607,19619,19625,19626,19666,19684,19696,19697,19710,19723,19742,19748,19751,19752,19758,19778,19783,19790,19806,19819,19824,19832,19874,19876,19925,19939,19944,19957,19982,19988,19989,20008,20017,20035,20098,20117,20141,20150,20158,20166,20176,20187,20188,20193,20204,20205,20211,20212,20213,20233,20264,20277,20282,20298,20299,20305,20307,20308,20310,20324,20328,20332,20333,20340,20343,20344,20352,20359,20370,20391,20399,20401,20410,20419,20420,20421,20442,20448,20457,20481,20484,20487,20489,20537,20543,20550,20554,20567,20572,20601,20608,20610,20630,20637,20663,20704,20705,20709,20712,20713,20714,20727,20728,20752,20758,20776,20780,20782,20808,20813,20830,20832,20841,20853,20865,20871,20877,20881,20886,20907,20910,20912,20920,20925,20954,20956,20973,20974,20990,21002,21012,21013,21017,21021,21027,21033,21035,21042,21047,21050,21055,21058,21059,21067,21069,21071,21080,21085,21086,21090,21099,21107,21108,21121,21128,21132,21133,21134,21138,21149,21158,21159,21163,21167,21169,21174,21181,21195,21204,21231,21233,21237,21241,21258,21262,21273,21288,21324,21340,21343,21387,21394,21396,21397,21410,21435,21445,21466,21474,21482,21485,21486,21491,21504,21542,21543,21547,21560,21563,21566,21574,21581,21617,21618,21628,21634,21640,21641,21646,21650,21660,21665,21669,21670,21683,21688,21689,21690,21699,21713,21716,21733,21738,21742,21748,21750,21756,21757,21760,21764,21800,21810,21820,21837,21850,21853,21859,21878,21902,21907,21915,21926,21942,21960,21967,21976,21977,21986,21988,21994,21995,21996,22002,22015,22017,22031,22034,22041,22050,22053,22056,22073,22081,22085,22088,22103,22112,22122,22137,22162,22164,22204,22219,22242,22266,22278,22281,22283,22292,22305,22316,22318,22321,22337,22352,22353,22362,22380,22394,22400,22405,22485,22493,22498,22502,22514,22522,22544,22545,22546,22551,22553,22564,22573,22588,22590,22595,22606,22615,22646,22658,22661,22668,22671,22676,22681,22691,22707,22716,22737,22744,22745,22746,22757,22759,22767,22779,22786,22797,22799,22816,22822,22834,22838,22855,22857,22858,22873,22887,22894,22898,22918,22936,22941,22955,22963,22968,22970,22971,22989,22991,22997,22998,23003,23013,23017,23026,23035,23047,23051,23063,23069,23070,23085,23086,23095,23097,23115,23117,23118,23132,23135,23136,23181,23201,23202,23216,23217,23224,23239,23240,23257,23260,23278,23280,23282,23288,23295,23297,23302,23310,23313,23317,23319,23320,23321,23331,23334,23338,23345,23348,23349,23351,23352,23382,23383,23396,23400,23420,23445,23468,23482,23486,23511,23512,23516,23528,23532,23533,23535,23543,23556,23560,23571,23582,23584,23599,23605,23609,23624,23631,23649,23662,23666,23667,23680,23681,23685,23686,23705,23712,23726,23731,23743,23756,23772,23780,23788,23800,23806,23811,23813,23814,23826,23836,23847,23851,23854,23855,23873,23876,23879,23901,23911,23943,23945,23951,23953,23961,23963,23975,23989,23999,24002,24045,24055,24082,24107,24112,24114,24120,24127,24139,24156,24164,24165,24169,24172,24177,24180,24189,24190,24201,24203,24204,24206,24210,24213,24223,24226,24227,24244,24245,24246,24248,24251,24305,24307,24323,24333,24340,24362,24385,24401,24410,24414,24425,24426,24432,24434,24458,24464,24475,24483,24485,24502,24513,24522,24532,24549,24560,24563,24567,24583,24605,24626,24628,24630,24632,24644,24651,24657,24671,24672,24673,24681,24682,24694,24697,24709,24730,24734,24750,24766,24790,24796,24797,24800,24807,24816,24824,24836,24845,24848,24861,24865,24877,24878,24880,24887,24894,24896,24922,24925,24927,24941,24945,24956,24959,24966,24969,24973,24977,24993,25001,25013,25021,25025,25030,25031,25038,25040,25041,25053,25057,25061,25073,25089,25091,25094,25103,25114,25118,25127,25129,25137,25146,25147,25151,25163,25167,25171,25200,25210,25218,25243,25258,25287,25296,25315,25321,25351,25353,25367,25369,25371,25372,25373,25378,25380,25390,25391,25393,25396,25399,25407,25414,25423,25424,25431,25433,25436,25440,25446,25451,25453,25457,25458,25459,25460,25461,25464,25465,25467,25468,25469,25472,25474,25476,25482,25483,25485,25486,25489,25492,25493,25494,25495,25499,25504,25506,25508,25509,25510,25513,25517,25520,25523,25524,25525,25526,25528,25536,25537,25538,25540,25541,25545,25546,25551,25552,25554,25559,25566,25568,25569,25572,25576,25578,25582,25583,25587,25588,25591,25596,25600,25649,25663,25674,25702,25746,25753,25775,25779,25781,25790,25813,25822,25844,25874,25911,25937,25941,25952,25953,25962,25983,26033,26044,26047,26073,26082,26116,26147,26157,26164,26172,26174,26191,26201,26207,26209,26225,26234,26236,26241,26247,26271,26283,26296,26318,26320,26322,26344,26351,26354,26355,26362,26366,26387,26391,26392,26405,26420,26432,26434,26452,26473,26481,26506,26522,26554,26560,26562,26572,26577,26578,26588,26594,26598,26613,26653,26683,26694,26701,26734,26780,26785,26787,26796,26814,26875,26897,26920,26924,26934,26936,26954,26962,26999,27024,27028,27040,27048,27067,27075,27085,27095,27096,27119,27123,27124,27127,27135,27139,27156,27231,27242,27252,27279,27302,27320,27330,27342,27345,27355,27368,27390,27403,27409,27420,27425,27432,27442,27461,27483,27551,27563,27622,27724,27739,27803,27805,27806,27818,27860,27875,27893,27898,27904,27958,28022,28030,28116,28117,28135,28185,28226,28242,28248,28251,28272,28281,28294,28328,28410,28416,28429,28440,28458,28504,28527,28528,28534,28539,28555,28609,28617,28635,28651,28683,28691,28703,28712,28714,28715,28728,28741,28751,28867,28868,28870,28930,28951,29034,29089,29108,29159,29189,29219,29222,29251,29298,29320,29328,29348,29354,29381,29413,29445,29447,29467,29499,29550,29551,29558,29619,29658,29683,29788,29801,29837,29839,29872,29896,29897,29915,29918,30404,30414,30696,30941,31090,31463,31510,31533,31623,31624,31725,31837,32339,32679,33385,33605,33998,34030,34071,34150,34159,34177,34205,34243,34262,34270,34375,34417,34489,34611,34639,34690,34888,34956,35266,35300,35368,35504,35643,35657,35822,35881,35936,35959,36007,36141,36143,36251,36298,36339,36382,36499,36617,36620,36813,36838,36990,37002,37056,37411,37422,37524,37532,37688,37758,37796,38071,38199,38363,38452,38489,38585,38619,38664,38665,38719,38762,38887,38933,38961,39227,39231,39251,39342,39397,39687,39769,39826,39846,39877,39896,39897,39917,39958,39964,39977,40025,40064,40072,40082,40183,40199,40292,40370,40521,40530,40650,40672,40703,40861,40909,41070,41089,41095,41104,41134,41185,41188,41204,41464,41494,41503,41601,41677,41681,41778,41861,41868,42107,42185,42205,42387,42396,42590,42639,42708,42716,42836,42890,42899,42900,42908,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,43581,43599,43651,43688,43700,43716,43725,43885,43906,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,44830,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 | 2161 | 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.79 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
Opening tables | 0.06 ms |
init | 0.54 ms |
System lock | 0.03 ms |
optimizing | 0.21 ms |
statistics | 5.83 ms |
preparing | 2.90 ms |
Sorting result | 0.03 ms |
executing | 0.01 ms |
Sending data | 5.02 ms |
end | 0.03 ms |
query end | 0.15 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 |