Tiempo de la consulta: 9.51 ms Después de la última consulta: 2.59 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.629 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-04 17:13:47')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 17:13:47')
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(21,53,72,138,141,206,252,332,373,425,472,510,522,583,594,611,723,757,826,828,837,841,922,986,996,1010,1053,1066,1133,1136,1207,1213,1235,1299,1301,1323,1370,1396,1457,1491,1518,1569,1587,1602,1767,1924,1965,2093,2107,2272,2324,2388,2435,2552,2559,2610,2817,2925,3011,3245,3352,3353,3354,3468,3476,3567,3708,3937,3948,4096,4210,4215,4218,4226,4227,4261,4293,4328,4381,4494,4680,4698,4723,4859,4884,5049,5135,5160,5189,5192,5313,5397,5429,5454,5460,5537,5591,5666,5719,5730,5846,5894,5896,6072,6173,6217,6227,6389,6462,6470,6498,6517,6531,6539,6575,6608,6688,6730,6799,6802,6942,6947,6965,7014,7052,7069,7123,7124,7135,7156,7167,7200,7244,7266,7336,7339,7340,7411,7420,7421,7449,7450,7460,7547,7556,7588,7621,7624,7659,7719,7725,7751,7776,7799,7831,7837,7850,7866,7889,7990,8051,8089,8258,8259,8267,8354,8377,8386,8417,8518,8566,8572,8580,8584,8617,8759,8762,8818,8860,8897,8909,8927,9008,9081,9231,9236,9417,9552,9750,9776,9801,9924,9956,9999,10030,10042,10114,10162,10274,10316,10433,10458,10709,10868,11030,11057,11078,11155,11194,11250,11253,11265,11299,11360,11408,11440,11441,11714,11808,11809,11810,11857,11907,12011,12074,12135,12140,12237,12248,12318,12440,12620,12624,12628,12670,12685,12686,12708,12746,12811,12972,12973,12995,13060,13122,13165,13224,13231,13239,13246,13275,13348,13349,13374,13445,13452,13533,13547,13647,13664,13692,13806,13851,13900,14062,14095,14153,14192,14206,14224,14263,14267,14281,14293,14346,14350,14385,14432,14516,14591,14601,14654,14655,14708,14754,14764,14795,14844,14894,14977,14983,14992,15055,15064,15080,15108,15147,15174,15217,15219,15343,15347,15356,15373,15378,15390,15420,15434,15440,15448,15486,15493,15494,15632,15638,15639,15656,15676,15712,15714,15890,15899,15904,15952,15953,15954,15973,16038,16089,16094,16156,16200,16216,16267,16297,16303,16313,16390,16430,16497,16609,16622,16714,16755,16780,16813,16825,16847,16848,16863,16866,16913,16928,16986,17026,17038,17039,17097,17116,17126,17142,17148,17155,17209,17234,17237,17275,17282,17301,17344,17363,17373,17381,17405,17422,17496,17573,17627,17653,17661,17682,17699,17710,17734,17755,17784,17812,17819,17875,17889,17948,18060,18085,18096,18181,18187,18229,18249,18260,18269,18316,18318,18344,18362,18419,18421,18429,18441,18446,18452,18494,18498,18509,18552,18556,18588,18600,18605,18647,18652,18675,18684,18700,18750,18760,18801,18807,18816,18826,18845,18856,18859,18864,18898,18904,18945,18953,18988,18989,18993,19007,19014,19024,19027,19040,19056,19059,19063,19110,19135,19145,19158,19189,19217,19226,19260,19261,19282,19292,19296,19303,19364,19370,19427,19437,19505,19527,19563,19572,19632,19655,19659,19857,19873,19883,19910,19922,19940,19950,19956,19972,19976,19980,19986,20006,20010,20020,20024,20033,20039,20043,20056,20105,20115,20234,20237,20254,20305,20347,20356,20378,20394,20402,20423,20426,20428,20435,20463,20482,20539,20557,20559,20669,20677,20681,20712,20731,20756,20823,20837,20841,20866,20891,20946,20947,20978,21007,21016,21032,21049,21069,21087,21094,21095,21118,21135,21189,21194,21294,21368,21380,21384,21390,21422,21481,21491,21520,21583,21664,21692,21701,21711,21727,21732,21836,21907,21998,22015,22020,22030,22035,22043,22062,22081,22117,22130,22140,22149,22164,22169,22174,22177,22181,22204,22222,22225,22228,22324,22351,22359,22382,22404,22415,22416,22456,22485,22502,22529,22543,22608,22625,22649,22651,22663,22698,22804,22841,22861,22878,22898,22919,22985,22986,23014,23028,23052,23053,23072,23089,23181,23207,23294,23299,23304,23324,23328,23369,23395,23401,23463,23605,23615,23633,23668,23732,23794,23831,23965,24005,24010,24025,24060,24091,24127,24155,24164,24183,24248,24266,24269,24320,24356,24357,24364,24374,24398,24404,24407,24436,24501,24523,24567,24573,24580,24615,24640,24710,24714,24717,24720,24733,24785,24950,25007,25026,25062,25079,25098,25099,25100,25117,25162,25165,25170,25183,25184,25208,25241,25278,25315,25365,25411,25419,25420,25428,25432,25435,25443,25463,25498,25549,25584,25601,25624,25640,25642,25661,25673,25694,25698,25707,25709,25727,25731,25761,25804,25812,25842,25851,25860,25861,25880,25898,25907,25915,25922,25927,25935,25942,25955,25970,25975,25976,25982,25985,25989,26008,26010,26018,26021,26023,26031,26038,26040,26041,26046,26065,26097,26107,26122,26131,26136,26143,26148,26149,26150,26158,26159,26161,26182,26184,26192,26195,26210,26219,26221,26222,26228,26239,26259,26276,26286,26319,26358,26360,26370,26377,26389,26403,26422,26426,26431,26437,26443,26454,26461,26472,26483,26494,26508,26511,26513,26529,26533,26535,26543,26569,26583,26594,26626,26630,26651,26663,26665,26686,26708,26733,26737,26762,26793,26834,26837,26892,26895,26914,26932,26941,26947,26968,26983,26987,27026,27030,27032,27035,27069,27116,27117,27120,27121,27131,27133,27155,27157,27170,27181,27189,27213,27218,27220,27221,27224,27232,27248,27273,27277,27303,27326,27328,27331,27332,27343,27346,27355,27356,27363,27364,27366,27367,27372,27385,27401,27408,27419,27426,27431,27452,27454,27458,27481,27494,27518,27520,27529,27533,27536,27541,27573,27584,27586,27597,27623,27624,27628,27633,27645,27646,27657,27669,27680,27683,27730,27738,27743,27771,27776,27804,27816,27825,27826,27842,27846,27869,27893,27917,27919,27967,27977,27984,27986,27991,27995,27996,28006,28011,28035,28046,28052,28054,28055,28057,28148,28173,28174,28202,28225,28240,28269,28282,28285,28296,28298,28319,28328,28356,28359,28378,28380,28381,28387,28395,28400,28421,28426,28433,28434,28446,28460,28473,28474,28482,28494,28497,28500,28506,28508,28512,28514,28516,28525,28530,28536,28549,28550,28592,28605,28606,28616,28622,28631,28638,28646,28682,28714,28720,28729,28732,28735,28740,28814,28879,28903,28914,28929,28933,28937,28944,28967,28976,28995,29015,29022,29035,29036,29043,29047,29057,29069,29075,29076,29122,29129,29156,29160,29173,29177,29182,29193,29249,29258,29271,29310,29315,29333,29386,29389,29392,29436,29441,29449,29457,29481,29487,29489,29497,29525,29530,29540,29559,29576,29577,29579,29590,29591,29592,29605,29632,29633,29634,29636,29653,29657,29661,29693,29718,29731,29738,29746,29748,29750,29766,29770,29782,29784,29828,29834,29841,29851,29854,29875,29877,29883,29927,29975,30025,30089,30094,30113,30115,30144,30146,30218,30221,30225,30226,30241,30245,30251,30278,30282,30283,30329,30330,30347,30348,30351,30357,30358,30360,30390,30392,30397,30413,30470,30474,30476,30482,30483,30497,30498,30502,30512,30519,30531,30550,30570,30585,30625,30627,30656,30675,30697,30826,30839,30840,30850,30853,30861,30863,30887,30888,30889,30895,30947,30948,30964,31041,31062,31064,31090,31189,31206,31230,31236,31237,31267,31287,31305,31306,31312,31423,31425,31434,31469,31474,31493,31494,31500,31539,31552,31563,31580,31623,31624,31650,31654,31687,31699,31791,31830,31842,31849,31865,31870,31930,31954,31995,32010,32012,32158,32167,32176,32223,32278,32279,32294,32433,32436,32528,32646,32764,32786,32797,32800,32810,32815,32816,32830,32913,32914,32934,32944,32995,33035,33102,33117,33148,33154,33167,33169,33226,33267,33298,33328,33342,33343,33345,33402,33412,33435,33461,33463,33472,33478,33519,33521,33522,33523,33526,33529,33541,33566,33568,33597,33606,33612,33613,33615,33616,33617,33621,33623,33626,33627,33637,33641,33653,33654,33659,33667,33669,33670,33671,33672,33676,33677,33678,33681,33684,33685,33687,33688,33693,33697,33698,33699,33705,33710,33712,33714,33715,33717,33721,33725,33738,33760,33761,33766,33767,33770,33771,33786,33825,33826,33835,33836,33847,33848,33850,33852,33858,33862,33863,33866,33869,33884,33885,33886,33894,33897,33901,33917,33944,33945,33946,33949,33956,33961,33963,33964,33965,33968,33970,33975,33981,33987,33989,33992,33996,34000,34001,34004,34009,34011,34013,34026,34028,34033,34035,34036,34037,34043,34052,34054,34056,34057,34067,34072,34073,34078,34083,34084,34087,34090,34091,34098,34102,34125,34126,34127,34135,34154,34163,34176,34183,34189,34192,34193,34194,34197,34201,34205,34207,34226,34227,34233,34234,34252,34253,34254,34263,34267,34268,34271,34277,34284,34290,34291,34300,34301,34305,34316,34318,34320,34327,34333,34342,34350,34351,34363,34370,34371,34384,34385,34392,34393,34394,34396,34399,34403,34405,34412,34429,34446,34450,34452,34462,34463,34464,34466,34472,34476,34477,34478,34485,34497,34499,34502,34504,34514,34515,34517,34528,34529,34532,34536,34545,34556,34570,34572,34573,34579,34600,34606,34608,34609,34612,34621,34633,34635,34655,34659,34664,34669,34689,34691,34702,34710,34712,34716,34721,34738,34742,34774,34780,34787,34822,34823,34832,34844,34860,34877,34884,34885,34893,34901,34906,34908,34915,34929,34934,34947,34948,34950,34951,34959,34978,34983,34999,35010,35011,35012,35015,35016,35019,35025,35026,35033,35048,35056,35068,35076,35094,35096,35099,35101,35107,35122,35130,35132,35133,35139,35144,35147,35149,35151,35154,35157,35158,35161,35168,35179,35180,35182,35183,35184,35202,35208,35223,35224,35225,35235,35246,35249,35251,35253,35257,35259,35272,35274,35275,35276,35279,35280,35281,35285,35293,35296,35299,35314,35315,35316,35327,35328,35329,35334,35338,35341,35352,35354,35356,35386,35388,35392,35404,35405,35422,35424,35432,35439,35444,35445,35450,35451,35456,35461,35463,35466,35468,35473,35475,35478,35480,35481,35499,35510,35516,35524,35525,35536,35537,35538,35551,35556,35557,35573,35578,35579,35580,35584,35600,35606,35608,35610,35618,35646,35688,35696,35701,35711,35714,35733,35785,35793,35802,35807,35809,35817,35823,35824,35828,35829,35831,35835,35847,35876,35881,35902,35927,35929,35943,35944,35962,35970,35973,35976,35982,35986,35990,35994,35997,36009,36031,36033,36037,36043,36053,36054,36055,36063,36074,36076,36077,36088,36092,36093,36104,36105,36110,36129,36132,36136,36141,36144,36167,36187,36206,36224,36233,36239,36242,36247,36256,36311,36315,36328,36370,36384,36387,36391,36393,36394,36401,36426,36429,36431,36433,36437,36457,36467,36468,36469,36488,36497,36509,36513,36519,36520,36522,36524,36527,36529,36530,36535,36537,36538,36546,36552,36553,36558,36574,36575,36588,36595,36601,36612,36614,36640,36646,36650,36651,36653,36655,36657,36661,36662,36665,36668,36669,36670,36673,36688,36696,36697,36704,36715,36723,36731,36739,36747,36757,36759,36766,36770,36771,36774,36784,36787,36788,36790,36791,36792,36793,36794,36796,36799,36811,36820,36822,36826,36842,36852,36856,36876,36883,36886,36888,36889,36890,36893,36898,36909,36916,36918,36922,36929,36946,36963,36994,36997,37000,37001,37003,37009,37015,37024,37025,37038,37043,37045,37052,37068,37072,37096,37105,37128,37145,37166,37174,37185,37189,37195,37196,37208,37234,37254,37255,37257,37270,37279,37296,37312,37318,37334,37336,37344,37355,37377,37421,37425,37438,37443,37460,37471,37474,37491,37521,37530,37543,37544,37554,37555,37595,37601,37604,37607,37608,37631,37633,37640,37662,37665,37675,37710,37739,37740,37767,37783,37786,37794,37800,37803,37826,37854,37859,37861,37863,37872,37874,37892,37910,37911,37914,37918,37922,37957,37994,37996,37999,38033,38047,38060,38061,38065,38066,38075,38083,38084,38085,38087,38094,38101,38102,38117,38122,38143,38158,38165,38178,38191,38203,38204,38206,38218,38242,38243,38246,38248,38265,38266,38278,38279,38285,38302,38317,38319,38341,38345,38361,38370,38377,38381,38391,38421,38429,38430,38453,38465,38481,38482,38483,38484,38506,38510,38512,38513,38516,38521,38526,38543,38556,38570,38580,38588,38590,38611,38623,38627,38655,38670,38671,38676,38688,38698,38704,38705,38707,38710,38713,38716,38720,38725,38734,38743,38752,38753,38760,38764,38765,38775,38781,38789,38797,38799,38812,38819,38821,38823,38826,38829,38837,38838,38851,38888,38911,38955,38956,38963,38969,38981,38993,39019,39023,39024,39038,39048,39050,39054,39070,39079,39103,39104,39108,39117,39139,39140,39149,39151,39154,39155,39160,39168,39177,39183,39184,39189,39190,39202,39205,39213,39228,39229,39230,39234,39244,39256,39257,39307,39309,39310,39324,39325,39329,39337,39346,39357,39358,39364,39377,39395,39398,39405,39412,39449,39459,39471,39484,39486,39503,39504,39521,39526,39534,39540,39545,39546,39547,39548,39563,39573,39582,39591,39595,39621,39625,39633,39658,39662,39676,39678,39692,39710,39734,39754,39757,39767,39792,39793,39805,39810,39817,39828,39836,39838,39840,39853,39863,39864,39882,39898,39900,39908,39912,39915,39920,39921,39934,39947,39950,39974,39976,40003,40026,40042,40045,40055,40061,40076,40081,40088,40091,40103,40105,40139,40156,40194,40241,40246,40247,40288,40289,40292,40298,40302,40306,40310,40312,40313,40314,40319,40320,40350,40360,40378,40379,40382,40404,40463,40467,40489,40508,40532,40539,40541,40542,40549,40568,40574,40577,40589,40590,40600,40614,40621,40627,40635,40644,40676,40686,40709,40713,40741,40743,40744,40750,40763,40767,40770,40771,40776,40791,40801,40819,40821,40830,40851,40853,40866,40874,40879,40882,40897,40900,40904,40915,40916,40927,40953,40960,40965,40971,40986,40992,40996,41012,41045,41051,41052,41056,41062,41063,41067,41133,41137,41142,41144,41167,41178,41179,41190,41194,41216,41218,41233,41246,41249,41275,41276,41284,41291,41294,41303,41307,41352,41358,41363,41367,41369,41370,41371,41378,41382,41402,41403,41407,41420,41422,41423,41424,41441,41446,41451,41453,41458,41478,41479,41499,41509,41512,41530,41535,41544,41562,41563,41569,41571,41572,41573,41579,41621,41626,41663,41679,41682,41738,41752,41755,41756,41789,41794,41796,41799,41811,41818,41820,41824,41835,41838,41851,41870,41872,41885,41890,41892,41897,41922,41928,41937,41939,41940,41954,41962,41973,41974,41975,41980,41982,41986,41987,41997,42006,42008,42047,42056,42058,42060,42086,42090,42113,42121,42124,42129,42141,42161,42166,42171,42172,42175,42191,42192,42208,42211,42216,42220,42232,42233,42234,42250,42267,42278,42285,42303,42312,42316,42317,42327,42329,42352,42355,42363,42384,42400,42413,42417,42418,42419,42427,42432,42433,42436,42449,42459,42466,42470,42475,42489,42491,42492,42497,42501,42505,42516,42528,42534,42544,42546,42554,42560,42582,42584,42600,42609,42610,42611,42621,42625,42626,42627,42631,42634,42636,42637,42660,42661,42671,42682,42684,42687,42700,42720,42731,42736,42746,42754,42761,42782,42788,42793,42796,42798,42800,42821,42823,42828,42841,42842,42855,42862,42866,42867,42874,42882,42884,42911,42912,42934,42979,42994,43015,43021,43036,43058,43065,43075,43076,43077,43079,43080,43083,43086,43091,43096,43097,43116,43121,43125,43135,43137,43139,43142,43146,43147,43154,43156,43165,43180,43181,43190,43201,43224,43232,43233,43257,43262,43286,43287,43295,43312,43331,43337,43339,43340,43343,43344,43352,43361,43381,43416,43434,43439,43442,43443,43455,43456,43482,43484,43485,43493,43494,43498,43502,43512,43535,43540,43551,43554,43558,43559,43567,43572,43573,43577,43591,43594,43611,43613,43617,43625,43626,43635,43638,43643,43648,43660,43661,43679,43680,43684,43694,43695,43696,43697,43699,43703,43705,43706,43707,43713,43721,43729,43730,43742,43758,43762,43768,43769,43776,43782,43790,43800,43801,43824,43825,43827,43832,43834,43836,43838,43844,43845,43847,43858,43865,43876,43877,43878,43881,43883,43904,43906,43907,43910,43914,43915,43917,43919,43925,43930,43934,43938,43982,43998,44003,44004,44005,44012,44016,44031,44035,44041,44063,44080,44098,44117,44118,44131,44133,44134,44158,44164,44168,44170,44192,44196,44197,44259,44261,44276,44293,44295,44300,44310,44320,44340,44341,44358,44394,44403,44413,44414,44423,44446,44497,44550,44555,44559,44576,44581,44592,44598,44603,44604,44620,44623,44626,44630,44658,44675,44681,44699,44700,44705,44727,44728,44731,44732,44733,44738,44748,44765,44775,44796,44810,44817,44834,44835,44854,44859,44877,44882,44891,44897,44898,44904,44917,44934,44952,44953,44967,44984,44992,45003,45010,45012,45016,45027,45028,45033,45034,45036,45055,45078,45081,45115,45134,45136,45155,45158,45160,45162,45169,45171,45173,45177,45190,45193,45198,45206,45224,45233,45290,45293,45297,45298,45301,45310)
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 | 2646 | 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.19 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.49 ms |
System lock | 0.02 ms |
optimizing | 0.16 ms |
statistics | 4.03 ms |
preparing | 2.04 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.36 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.08 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 |