Tiempo de la consulta: 26.61 ms Después de la última consulta: 2.36 ms Consulta a la memoria: 1.487 MB memoria antes de la consulta: 4.546 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 06:10:55')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 06:10:55')
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(1,11,17,33,34,35,39,40,41,42,43,49,58,62,75,78,83,85,128,154,155,158,159,163,174,204,214,255,263,277,279,282,285,303,307,325,332,349,353,357,389,437,446,450,458,478,485,495,510,512,521,529,531,537,542,547,558,560,566,567,572,593,607,618,666,667,669,671,686,695,723,729,756,757,760,806,808,816,845,850,856,863,868,869,870,879,885,886,903,911,915,933,954,955,970,977,986,988,1010,1027,1033,1057,1080,1083,1094,1101,1102,1158,1182,1186,1201,1207,1210,1214,1216,1226,1234,1240,1265,1277,1278,1279,1289,1327,1329,1335,1337,1339,1340,1346,1347,1538,1600,1648,1664,1691,1697,1698,1768,1846,1867,1919,1976,2013,2023,2064,2094,2188,2190,2328,2392,2398,2402,2463,2489,2647,2732,2733,2750,2762,2827,2857,2859,2954,2964,3022,3035,3036,3049,3054,3055,3069,3080,3106,3107,3109,3158,3174,3180,3255,3295,3302,3329,3353,3364,3369,3402,3409,3412,3442,3451,3454,3461,3520,3546,3571,3577,3603,3663,3696,3706,3732,3782,3864,3880,3884,3898,3940,3980,3982,3986,3993,3999,4063,4096,4116,4145,4153,4163,4166,4186,4195,4197,4220,4221,4229,4241,4242,4266,4276,4281,4286,4309,4313,4409,4410,4436,4445,4453,4471,4503,4589,4661,4692,4699,4713,4765,4767,4790,4803,4823,4863,4872,5001,5085,5161,5207,5208,5247,5300,5306,5351,5396,5461,5472,5478,5491,5515,5536,5613,5647,5648,5658,5659,5686,5698,5730,5827,5833,5857,5877,5881,5886,5894,5896,5913,5918,6056,6088,6120,6141,6178,6278,6279,6319,6448,6465,6472,6515,6517,6520,6545,6594,6598,6616,6628,6632,6639,6658,6681,6694,6703,6751,6752,6762,6775,6791,6806,6809,6828,6876,6908,6916,6935,6941,6969,6988,6994,7013,7014,7045,7077,7105,7122,7136,7150,7173,7193,7201,7212,7243,7246,7270,7272,7276,7277,7285,7327,7336,7338,7346,7379,7407,7418,7429,7437,7439,7447,7449,7462,7478,7513,7516,7545,7551,7577,7583,7666,7675,7691,7720,7730,7736,7743,7744,7757,7764,7777,7818,7829,7835,7840,7841,7871,7895,7897,7901,7923,7924,7954,7960,7965,7981,8015,8027,8046,8052,8053,8061,8090,8106,8116,8118,8138,8177,8258,8351,8445,8457,8508,8555,8610,8663,8759,8760,8864,8909,8973,9029,9045,9087,9204,9253,9254,9299,9318,9333,9351,9364,9429,9434,9451,9472,9473,9531,9532,9543,9554,9580,9734,9772,9773,9832,9836,9853,9886,9891,9924,9956,9960,10024,10050,10077,10079,10149,10192,10197,10198,10199,10207,10222,10238,10247,10266,10289,10290,10294,10303,10307,10331,10350,10351,10401,10439,10452,10464,10475,10478,10479,10485,10486,10499,10518,10537,10553,10557,10630,10690,10694,10717,10731,10783,10801,10806,10810,10827,10831,10833,10926,10932,10958,10971,10986,10987,11009,11022,11027,11038,11043,11045,11059,11087,11101,11150,11171,11182,11189,11230,11238,11258,11263,11273,11293,11328,11348,11377,11399,11402,11446,11447,11472,11473,11494,11538,11542,11611,11666,11675,11680,11691,11692,11711,11713,11716,11719,11764,11775,11823,11826,11836,11840,11870,11879,11880,11899,11912,11926,11929,11945,11951,11992,12011,12036,12042,12069,12076,12085,12092,12131,12136,12152,12176,12190,12216,12218,12317,12319,12321,12331,12338,12340,12362,12363,12366,12370,12401,12410,12448,12463,12474,12490,12514,12516,12588,12604,12617,12620,12622,12625,12636,12637,12657,12665,12670,12676,12685,12686,12697,12708,12738,12745,12750,12757,12758,12794,12804,12810,12849,12853,12875,12901,12909,12910,12912,12920,12944,12960,12965,12977,12983,13017,13043,13055,13082,13107,13132,13162,13218,13222,13235,13242,13243,13246,13250,13257,13287,13294,13298,13306,13329,13345,13359,13371,13379,13396,13410,13421,13440,13443,13446,13460,13481,13495,13511,13528,13529,13594,13603,13613,13651,13664,13671,13687,13697,13707,13708,13709,13733,13742,13753,13758,13766,13772,13804,13808,13826,13842,13892,13911,13926,13963,13975,13985,13990,14011,14013,14040,14053,14054,14069,14074,14076,14078,14082,14092,14096,14105,14109,14115,14117,14133,14139,14142,14147,14148,14175,14198,14199,14200,14202,14205,14227,14232,14234,14244,14249,14252,14262,14268,14270,14271,14273,14291,14305,14355,14378,14421,14440,14450,14451,14453,14456,14470,14480,14489,14493,14502,14505,14507,14521,14523,14526,14531,14555,14556,14557,14591,14596,14610,14637,14639,14646,14654,14683,14691,14698,14699,14701,14759,14774,14778,14794,14798,14820,14841,14851,14891,14895,14926,14949,14955,14959,14964,14979,14982,14983,14987,14992,15002,15004,15030,15032,15037,15048,15049,15051,15060,15061,15065,15092,15094,15105,15107,15108,15109,15111,15114,15115,15122,15123,15129,15139,15144,15148,15154,15180,15206,15213,15217,15226,15247,15249,15256,15257,15266,15269,15284,15297,15299,15301,15304,15325,15326,15344,15354,15358,15370,15371,15373,15382,15403,15410,15417,15418,15424,15439,15441,15443,15445,15455,15471,15472,15475,15483,15492,15498,15499,15500,15542,15548,15562,15574,15575,15577,15580,15609,15631,15632,15637,15639,15640,15642,15656,15717,15725,15728,15733,15745,15752,15757,15760,15762,15766,15782,15787,15788,15811,15829,15832,15835,15840,15842,15864,15877,15878,15879,15892,15893,15900,15913,15926,15935,15937,15954,15979,16000,16014,16023,16024,16052,16053,16054,16060,16086,16092,16093,16125,16128,16140,16145,16153,16156,16161,16164,16167,16168,16187,16192,16194,16199,16206,16208,16217,16232,16235,16250,16257,16261,16264,16277,16279,16283,16295,16326,16327,16328,16336,16341,16353,16359,16366,16368,16373,16374,16389,16404,16405,16410,16436,16447,16453,16458,16459,16460,16468,16470,16497,16518,16534,16543,16554,16558,16560,16607,16613,16627,16635,16642,16652,16657,16659,16662,16664,16682,16686,16691,16695,16698,16778,16791,16792,16815,16820,16831,16832,16843,16844,16866,16889,16893,16909,16922,16929,16936,16948,16964,16965,16981,16996,17000,17001,17004,17042,17043,17059,17072,17088,17115,17125,17128,17149,17158,17183,17185,17189,17214,17215,17229,17247,17257,17269,17273,17276,17280,17290,17300,17307,17318,17327,17341,17346,17347,17354,17358,17364,17381,17382,17390,17403,17411,17417,17424,17432,17434,17441,17452,17457,17459,17460,17463,17470,17484,17485,17494,17498,17500,17512,17519,17536,17541,17554,17568,17574,17597,17601,17615,17617,17620,17630,17633,17634,17650,17659,17666,17689,17701,17702,17705,17707,17715,17723,17729,17733,17753,17757,17759,17761,17766,17772,17774,17776,17783,17784,17810,17815,17816,17818,17824,17831,17840,17844,17846,17864,17885,17895,17907,17918,17935,17951,17953,17954,17961,17972,17973,17980,17990,17993,18001,18031,18046,18047,18048,18055,18056,18069,18098,18102,18158,18160,18176,18179,18198,18217,18220,18221,18231,18238,18244,18263,18267,18277,18281,18296,18300,18309,18311,18315,18316,18326,18333,18337,18345,18352,18353,18361,18366,18369,18384,18395,18401,18408,18419,18427,18434,18435,18442,18449,18455,18464,18485,18498,18518,18520,18527,18537,18539,18543,18547,18555,18561,18562,18563,18565,18576,18577,18581,18586,18591,18592,18612,18617,18619,18627,18640,18643,18648,18674,18680,18682,18689,18697,18716,18722,18732,18739,18744,18746,18750,18762,18769,18790,18792,18805,18808,18809,18812,18821,18823,18825,18846,18847,18848,18869,18886,18889,18896,18898,18901,18904,18909,18910,18920,18927,18936,18938,18942,18957,18960,18972,18973,18977,18982,18986,18991,18993,18995,18997,19000,19006,19011,19021,19022,19025,19027,19029,19060,19063,19077,19083,19086,19091,19105,19106,19109,19110,19112,19120,19132,19134,19136,19139,19149,19151,19171,19172,19179,19183,19185,19191,19195,19201,19205,19207,19217,19224,19247,19251,19266,19270,19274,19275,19280,19285,19292,19294,19303,19304,19306,19309,19313,19331,19346,19350,19352,19366,19370,19377,19383,19386,19396,19405,19413,19416,19419,19422,19433,19437,19440,19442,19443,19446,19453,19457,19469,19484,19490,19492,19494,19504,19510,19522,19524,19537,19542,19552,19556,19562,19566,19567,19581,19590,19593,19595,19604,19608,19619,19621,19625,19626,19645,19646,19650,19651,19655,19659,19661,19662,19666,19684,19697,19700,19718,19720,19730,19748,19752,19763,19766,19775,19778,19779,19790,19806,19810,19815,19864,19867,19874,19883,19894,19925,19930,19932,19941,19944,19951,19955,19957,19971,19983,19987,19991,19995,19999,20007,20008,20015,20030,20034,20035,20036,20042,20069,20070,20075,20076,20083,20087,20098,20099,20103,20117,20145,20146,20158,20162,20164,20166,20167,20172,20183,20195,20199,20204,20205,20216,20219,20229,20233,20236,20247,20279,20282,20299,20305,20313,20328,20332,20333,20344,20347,20352,20354,20358,20359,20362,20363,20365,20374,20378,20398,20399,20403,20407,20419,20420,20422,20423,20427,20440,20457,20460,20462,20464,20479,20487,20489,20496,20512,20513,20537,20542,20554,20574,20578,20579,20587,20605,20608,20609,20630,20636,20638,20649,20659,20662,20664,20681,20685,20691,20701,20712,20724,20747,20753,20755,20765,20768,20769,20774,20776,20780,20782,20783,20786,20795,20797,20799,20817,20826,20835,20840,20841,20856,20868,20870,20877,20886,20888,20912,20914,20915,20939,20950,20956,20958,20974,20996,21000,21013,21017,21054,21055,21067,21085,21086,21105,21106,21108,21118,21120,21121,21128,21133,21141,21149,21152,21161,21163,21164,21178,21179,21181,21184,21194,21219,21231,21238,21242,21252,21258,21274,21286,21293,21305,21307,21323,21324,21348,21350,21366,21373,21387,21388,21396,21407,21415,21433,21446,21452,21458,21464,21465,21482,21499,21506,21516,21518,21522,21536,21542,21545,21546,21547,21548,21552,21563,21566,21568,21586,21593,21606,21612,21628,21635,21638,21655,21662,21665,21675,21683,21689,21709,21713,21714,21716,21737,21742,21750,21766,21774,21775,21831,21849,21859,21878,21886,21894,21904,21906,21912,21919,21923,21931,21948,21952,21967,21988,21994,22001,22025,22030,22031,22038,22043,22052,22053,22059,22073,22088,22089,22100,22122,22126,22128,22137,22159,22211,22219,22225,22244,22245,22246,22248,22266,22268,22286,22292,22294,22307,22311,22316,22319,22325,22338,22350,22352,22359,22360,22366,22378,22380,22382,22387,22393,22395,22419,22431,22435,22455,22485,22487,22492,22493,22498,22500,22502,22504,22517,22527,22530,22533,22546,22553,22558,22559,22594,22607,22648,22666,22668,22671,22673,22675,22681,22686,22691,22700,22708,22711,22715,22740,22742,22744,22752,22753,22766,22770,22778,22779,22786,22793,22803,22804,22805,22820,22822,22829,22834,22849,22853,22857,22861,22873,22874,22875,22895,22898,22899,22906,22918,22921,22924,22933,22934,22935,22936,22956,22963,22976,22996,22998,23000,23002,23006,23013,23015,23017,23019,23022,23026,23030,23034,23045,23047,23050,23060,23067,23079,23080,23081,23090,23103,23121,23122,23124,23126,23128,23148,23151,23163,23165,23181,23196,23200,23202,23219,23220,23222,23224,23234,23244,23247,23250,23255,23256,23260,23271,23278,23284,23286,23288,23295,23300,23303,23310,23318,23319,23323,23330,23338,23341,23343,23344,23354,23366,23375,23380,23386,23393,23396,23400,23408,23415,23417,23418,23436,23438,23443,23445,23451,23458,23466,23467,23468,23477,23487,23495,23512,23516,23527,23534,23543,23545,23546,23559,23564,23565,23578,23584,23596,23609,23616,23624,23635,23651,23659,23660,23664,23665,23666,23667,23668,23673,23677,23686,23691,23693,23703,23705,23706,23716,23719,23721,23726,23731,23735,23737,23740,23756,23759,23761,23763,23764,23767,23768,23772,23780,23782,23792,23806,23814,23816,23819,23822,23827,23839,23855,23856,23857,23869,23873,23874,23876,23889,23900,23911,23913,23914,23922,23929,23930,23949,23950,23955,23959,23960,23962,23965,23967,23984,23989,23994,23998,24001,24002,24006,24010,24024,24059,24063,24072,24075,24076,24082,24084,24111,24114,24141,24142,24171,24174,24184,24190,24201,24210,24212,24230,24260,24264,24276,24282,24293,24299,24325,24340,24346,24347,24364,24373,24392,24419,24432,24455,24470,24472,24475,24485,24495,24513,24523,24543,24550,24567,24573,24607,24608,24616,24618,24624,24630,24638,24642,24646,24657,24659,24668,24671,24672,24673,24681,24682,24698,24702,24717,24718,24727,24733,24734,24754,24767,24769,24770,24780,24788,24790,24804,24807,24812,24823,24828,24836,24844,24845,24851,24857,24858,24863,24872,24877,24887,24888,24900,24902,24905,24906,24922,24924,24927,24942,24943,24945,24947,24960,24967,24968,24979,24987,24989,24995,25003,25011,25012,25038,25041,25048,25056,25064,25090,25100,25103,25104,25119,25125,25126,25137,25141,25143,25146,25154,25162,25163,25199,25200,25207,25208,25218,25245,25248,25250,25252,25258,25260,25263,25273,25279,25280,25301,25313,25315,25333,25345,25349,25353,25360,25364,25366,25373,25374,25380,25386,25411,25420,25421,25435,25442,25443,25455,25461,25469,25474,25483,25486,25502,25513,25534,25540,25554,25583,25595,25600,25615,25616,25624,25639,25650,25663,25673,25696,25697,25699,25724,25746,25753,25763,25764,25778,25790,25798,25799,25813,25818,25822,25882,25884,25886,25911,25923,25932,25942,25952,25955,25971,25987,26043,26073,26103,26107,26116,26122,26157,26174,26176,26191,26207,26209,26225,26236,26238,26247,26271,26293,26322,26324,26338,26344,26355,26361,26387,26389,26392,26405,26420,26423,26431,26432,26434,26452,26453,26454,26456,26479,26481,26499,26513,26522,26559,26560,26562,26564,26589,26594,26598,26605,26654,26665,26698,26701,26725,26765,26767,26772,26776,26779,26780,26792,26800,26808,26814,26816,26857,26861,26897,26898,26910,26924,26926,26928,26934,26936,26938,26939,26982,26996,27008,27012,27014,27015,27020,27022,27024,27026,27028,27040,27055,27056,27058,27075,27076,27085,27089,27093,27096,27127,27131,27149,27151,27152,27186,27248,27279,27283,27319,27355,27356,27362,27363,27365,27368,27390,27394,27403,27420,27438,27442,27452,27453,27477,27490,27506,27517,27518,27520,27545,27558,27563,27566,27572,27575,27670,27710,27720,27724,27738,27739,27811,27822,27891,27893,27898,27991,28005,28020,28116,28135,28185,28242,28294,28300,28316,28397,28424,28452,28539,28561,28607,28609,28617,28640,28646,28651,28677,28692,28712,28714,28715,28765,28780,28824,28845,28910,28922,28944,28961,29014,29021,29023,29032,29034,29066,29089,29123,29124,29143,29180,29256,29329,29348,29358,29381,29413,29443,29445,29466,29467,29499,29550,29551,29557,29584,29617,29658,29683,29788,29801,29810,29834,29837,29839,29872,29896,29897,29908,29909,29915,29918,29919,29930,30111,30326,30414,30481,30941,31090,31227,31499,31510,31516,31837,31853,32136,32250,32302,32381,32507,32590,32843,32874,32896,32943,33040,33129,33199,33385,33649,33815,33932,34078,34099,34109,34150,34179,34184,34229,34241,34258,34260,34269,34292,34326,34343,34357,34951,34998,35144,35726,35730,35741,35803,35884,35921,35989,36017,36041,36042,36141,36235,36602,36633,36834,36893,36916,36918,36958,37315,37380,37874,37915,37996,38056,38066,38112,38361,38455,38734,38775,38800,38812,38847,38850,38852,38857,38865,38867,38884,38886,38887,38899,38916,38985,39049,39144,39178,39269,39307,39318,39342,39358,39369,39385,39452,39504,39516,39650,39653,39846,39858,39877,39941,39966,39998,40050,40064,40147,40169,40213,40214,40312,40313,40314,40360,40491,40521,40542,40545,40672,40706,40796,40797,40801,40822,40850,40861,40909,40990,41035,41036,41048,41063,41082,41104,41183,41184,41305,41337,41399,41402,41423,41811,41885,42460,42489,43680,43705,43706,43707,43855,43914,43915,43917,44031,44041,44497,44681,44770,45115,45160,45206,45252)
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 | 2559 | 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.23 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.49 ms |
System lock | 0.02 ms |
optimizing | 0.16 ms |
statistics | 6.01 ms |
preparing | 3.17 ms |
Sorting result | 0.06 ms |
executing | 0.01 ms |
Sending data | 14.02 ms |
end | 0.02 ms |
query end | 0.04 ms |
closing tables | 0.06 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 |