Tiempo de la consulta: 10.36 ms Después de la última consulta: 2.58 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.647 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-07 16:51:50')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 16:51:50')
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(8,16,17,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,39,40,41,42,43,44,45,46,47,48,49,50,51,53,54,55,58,75,84,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,125,128,162,194,195,209,210,211,226,227,228,229,230,231,232,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,252,253,269,270,287,361,367,391,412,414,415,416,419,420,421,422,423,424,425,426,427,428,429,430,431,432,472,473,475,479,482,510,529,581,594,611,639,644,645,653,662,672,701,742,754,802,826,837,847,848,874,893,896,903,907,922,924,946,967,1004,1010,1021,1053,1066,1092,1136,1205,1207,1213,1233,1235,1255,1277,1282,1284,1299,1301,1303,1304,1326,1331,1335,1358,1370,1382,1396,1408,1426,1437,1447,1453,1457,1467,1477,1479,1491,1509,1514,1518,1569,1602,1605,1767,1827,1885,1924,2018,2065,2093,2193,2324,2417,2435,2559,2569,2582,2618,2719,2885,2909,3011,3050,3095,3228,3245,3251,3265,3268,3347,3352,3375,3379,3452,3468,3537,3567,3583,3616,3672,3688,3708,3825,3937,3948,3953,3958,3976,4020,4096,4118,4138,4173,4210,4218,4227,4261,4277,4293,4328,4435,4442,4586,4637,4648,4649,4678,4698,4785,4788,4790,4844,4859,4884,4932,5023,5049,5135,5189,5259,5279,5300,5332,5334,5347,5360,5363,5394,5397,5429,5454,5560,5591,5647,5658,5685,5692,5698,5719,5730,5732,5807,5827,5832,5833,5834,5848,5853,5862,5894,5896,5914,5927,5949,5962,5985,6009,6012,6038,6063,6067,6072,6134,6141,6142,6168,6173,6218,6226,6227,6241,6247,6286,6305,6308,6319,6334,6335,6366,6398,6411,6439,6443,6452,6462,6475,6500,6504,6506,6517,6529,6532,6540,6545,6551,6574,6575,6583,6599,6608,6610,6611,6616,6661,6664,6669,6699,6710,6718,6758,6765,6767,6768,6774,6777,6798,6810,6824,6839,6844,6848,6853,6884,6885,6889,6905,6941,6942,6944,6945,6947,6955,6970,6997,6998,7002,7037,7043,7046,7057,7081,7108,7123,7135,7136,7139,7140,7156,7172,7190,7191,7193,7194,7202,7233,7245,7252,7258,7278,7323,7326,7344,7377,7392,7413,7416,7419,7449,7465,7525,7547,7550,7560,7567,7580,7582,7596,7618,7621,7625,7633,7659,7675,7676,7686,7687,7718,7721,7759,7761,7762,7764,7775,7779,7794,7800,7803,7811,7813,7820,7828,7837,7862,7864,7867,7869,7873,7883,7921,7932,7936,7963,7990,7995,7999,8029,8032,8034,8051,8058,8077,8083,8088,8089,8114,8154,8155,8171,8186,8187,8221,8267,8268,8278,8286,8294,8297,8316,8340,8353,8355,8359,8383,8387,8416,8417,8504,8518,8534,8540,8572,8582,8584,8612,8646,8662,8663,8666,8670,8712,8728,8758,8762,8763,8770,8772,8779,8814,8818,8819,8822,8827,8836,8848,8858,8890,8892,8897,8917,8925,8927,8964,8997,9008,9023,9067,9071,9081,9083,9084,9086,9096,9097,9098,9100,9110,9114,9149,9155,9172,9188,9199,9206,9222,9228,9231,9233,9236,9238,9264,9270,9286,9320,9351,9404,9417,9433,9501,9528,9626,9640,9641,9653,9654,9656,9699,9703,9715,9716,9750,9754,9755,9756,9767,9776,9788,9808,9853,9889,9909,9931,9970,9999,10035,10042,10067,10068,10100,10156,10179,10220,10298,10301,10356,10364,10413,10433,10458,10474,10542,10577,10600,10625,10627,10677,10699,10706,10709,10719,10746,10761,10765,10779,10811,10814,10854,10884,10886,10894,10899,10909,10932,10963,10995,10996,11044,11112,11138,11155,11179,11212,11220,11238,11244,11265,11328,11332,11369,11397,11408,11411,11413,11433,11437,11440,11443,11444,11458,11465,11527,11542,11543,11565,11592,11610,11696,11700,11704,11749,11808,11809,11810,11814,11827,11857,11894,11907,11947,12025,12074,12104,12140,12189,12198,12199,12237,12248,12288,12304,12324,12334,12342,12344,12368,12375,12388,12436,12437,12440,12482,12507,12524,12536,12567,12599,12643,12672,12674,12683,12684,12701,12705,12746,12839,12867,12892,12896,12898,12902,12914,12926,12972,12973,12995,13001,13010,13023,13060,13067,13068,13076,13122,13126,13128,13145,13155,13165,13191,13202,13209,13231,13232,13247,13248,13256,13266,13275,13276,13277,13297,13323,13341,13348,13374,13413,13436,13445,13452,13477,13480,13481,13485,13533,13543,13547,13606,13608,13617,13628,13645,13646,13647,13664,13692,13698,13729,13731,13778,13798,13806,13807,13811,13850,13851,13861,13880,13926,13950,13962,13970,13972,13976,14037,14062,14064,14091,14095,14098,14100,14125,14132,14154,14156,14159,14179,14187,14222,14246,14281,14293,14338,14346,14350,14353,14402,14411,14417,14419,14427,14428,14432,14479,14498,14519,14523,14554,14563,14604,14654,14655,14677,14682,14700,14718,14728,14754,14764,14774,14790,14796,14797,14807,14811,14832,14838,14844,14862,14875,14894,14942,14949,14969,14970,14977,14982,14983,15002,15007,15038,15047,15064,15067,15079,15147,15148,15174,15176,15184,15185,15202,15219,15223,15224,15228,15241,15257,15272,15284,15287,15293,15310,15315,15316,15331,15343,15353,15354,15356,15360,15361,15365,15373,15390,15411,15420,15434,15448,15450,15455,15460,15462,15465,15476,15479,15494,15498,15508,15515,15524,15533,15555,15566,15583,15625,15632,15638,15640,15643,15650,15653,15654,15656,15665,15676,15685,15706,15732,15757,15759,15824,15841,15856,15890,15913,15917,15940,15941,15947,15954,15967,15969,15973,15980,15988,15999,16002,16041,16051,16052,16066,16069,16071,16086,16094,16120,16137,16145,16162,16176,16184,16190,16199,16202,16212,16224,16276,16295,16323,16348,16365,16367,16370,16383,16385,16387,16391,16418,16425,16428,16431,16445,16468,16469,16493,16507,16523,16543,16547,16550,16563,16591,16622,16641,16642,16675,16677,16680,16755,16777,16787,16788,16803,16825,16831,16847,16848,16857,16862,16880,16887,16897,16910,16913,16978,16979,16986,17022,17026,17049,17057,17087,17091,17093,17097,17100,17105,17131,17137,17139,17142,17148,17151,17155,17169,17232,17233,17237,17241,17248,17249,17253,17295,17301,17311,17314,17328,17335,17336,17341,17365,17373,17388,17393,17404,17424,17448,17450,17454,17457,17461,17481,17507,17552,17557,17587,17594,17633,17635,17638,17641,17642,17650,17653,17661,17667,17682,17685,17698,17711,17721,17722,17728,17730,17737,17740,17742,17755,17776,17777,17784,17785,17788,17808,17809,17819,17820,17822,17843,17854,17856,17868,17875,17877,17894,17907,17908,17928,17934,17935,17948,17956,17958,17960,17963,17995,18002,18006,18021,18035,18040,18042,18060,18073,18078,18083,18085,18096,18105,18162,18181,18220,18223,18234,18235,18237,18245,18258,18260,18269,18292,18304,18306,18311,18312,18344,18354,18402,18429,18440,18446,18457,18504,18508,18525,18527,18563,18570,18580,18600,18647,18648,18677,18680,18684,18700,18707,18719,18728,18736,18738,18745,18746,18747,18760,18767,18771,18773,18774,18777,18779,18790,18794,18799,18801,18802,18823,18824,18834,18843,18850,18851,18855,18859,18879,18880,18885,18898,18900,18917,18919,18935,18937,18944,18954,18964,18968,18969,18979,18980,18993,18996,18998,19006,19012,19014,19018,19019,19024,19035,19041,19053,19059,19063,19073,19081,19089,19094,19099,19110,19127,19132,19154,19157,19158,19159,19186,19188,19189,19197,19203,19216,19230,19245,19256,19257,19265,19282,19294,19296,19303,19358,19360,19364,19376,19380,19390,19424,19425,19452,19472,19489,19492,19505,19508,19514,19520,19526,19528,19532,19536,19544,19553,19559,19563,19572,19584,19585,19589,19603,19605,19608,19618,19619,19630,19632,19649,19655,19664,19675,19685,19693,19723,19724,19732,19745,19764,19789,19793,19801,19805,19824,19831,19843,19853,19858,19863,19882,19910,19922,19938,19950,19963,19968,19976,19986,20002,20013,20037,20046,20066,20072,20082,20088,20102,20105,20115,20116,20159,20185,20190,20201,20202,20208,20209,20223,20226,20236,20240,20265,20266,20275,20298,20305,20323,20341,20347,20362,20372,20378,20417,20423,20428,20431,20435,20438,20456,20462,20463,20473,20477,20479,20482,20488,20496,20501,20519,20522,20533,20542,20548,20557,20577,20584,20588,20590,20608,20643,20646,20669,20674,20682,20685,20712,20717,20720,20732,20738,20754,20756,20759,20766,20795,20797,20802,20808,20832,20838,20852,20861,20864,20873,20876,20877,20882,20884,20890,20908,20911,20934,20935,20938,20939,20941,20962,20969,20976,20978,20985,21003,21008,21032,21044,21053,21059,21069,21095,21109,21176,21179,21186,21189,21214,21221,21239,21240,21274,21275,21277,21280,21293,21299,21308,21311,21317,21326,21333,21341,21354,21358,21364,21371,21379,21387,21393,21412,21428,21429,21434,21446,21451,21465,21469,21478,21481,21505,21515,21520,21528,21538,21559,21562,21573,21582,21609,21612,21620,21629,21638,21652,21653,21654,21680,21688,21691,21741,21744,21746,21784,21798,21817,21818,21824,21830,21835,21845,21848,21911,21942,21943,21946,21971,21981,21989,22003,22019,22043,22064,22089,22091,22094,22104,22109,22130,22136,22139,22142,22158,22164,22169,22174,22180,22181,22186,22191,22197,22201,22204,22211,22213,22222,22226,22259,22267,22291,22299,22309,22314,22315,22319,22325,22330,22335,22338,22366,22410,22414,22428,22435,22442,22448,22456,22475,22478,22482,22485,22512,22524,22525,22529,22536,22546,22561,22575,22591,22608,22613,22624,22625,22634,22638,22649,22655,22662,22663,22678,22679,22687,22728,22733,22749,22755,22773,22789,22807,22816,22844,22860,22861,22874,22876,22878,22882,22885,22903,22921,22945,22986,23052,23102,23123,23124,23143,23145,23161,23163,23186,23207,23217,23301,23311,23320,23324,23337,23362,23395,23420,23436,23444,23463,23513,23531,23541,23575,23586,23601,23605,23629,23645,23652,23705,23714,23735,23738,23760,23764,23781,23794,23831,23833,23868,23946,23948,23949,23985,24022,24055,24056,24059,24084,24090,24091,24129,24147,24164,24179,24183,24191,24207,24211,24217,24222,24239,24266,24269,24308,24309,24317,24320,24324,24338,24341,24357,24364,24374,24380,24398,24404,24407,24435,24436,24441,24466,24468,24475,24504,24584,24634,24640,24683,24688,24700,24702,24707,24714,24717,24720,24722,24733,24759,24767,24771,24798,24806,24808,24924,24950,24953,24954,24987,25024,25026,25054,25098,25107,25110,25117,25154,25162,25165,25183,25193,25208,25241,25263,25280,25317,25365,25382,25386,25411,25419,25435,25456,25504,25511,25548,25549,25583,25585,25593,25598,25601,25612,25640,25642,25656,25657,25661,25673,25698,25707,25709,25719,25727,25731,25741,25742,25750,25761,25804,25812,25833,25860,25861,25880,25898,25907,25909,25915,25922,25927,25942,25954,25955,25970,25975,25976,25982,25986,26002,26008,26010,26023,26028,26036,26040,26046,26078,26102,26105,26143,26148,26149,26150,26158,26159,26182,26184,26192,26195,26214,26221,26228,26276,26286,26293,26319,26338,26370,26376,26394,26396,26398,26406,26408,26410,26422,26425,26443,26461,26472,26476,26483,26508,26511,26529,26533,26535,26542,26543,26548,26594,26626,26661,26663,26686,26708,26762,26775,26793,26837,26849,26858,26874,26891,26895,26905,26916,26932,26944,26947,26956,26983,26987,27030,27032,27035,27072,27117,27133,27157,27166,27181,27206,27213,27220,27224,27249,27263,27268,27269,27270,27326,27328,27331,27362,27367,27375,27385,27399,27401,27408,27419,27420,27422,27426,27437,27439,27458,27460,27482,27488,27533,27536,27547,27573,27584,27586,27597,27623,27633,27650,27657,27680,27717,27726,27730,27771,27776,27786,27804,27805,27825,27826,27842,27851,27870,27878,27893,27967,27984,27995,27997,28011,28035,28052,28054,28057,28148,28173,28174,28202,28225,28269,28277,28282,28285,28298,28356,28359,28423,28473,28514,28525,28536,28537,28549,28550,28592,28622,28631,28638,28671,28682,28712,28714,28735,28740,28745,28814,28879,28890,28903,28914,28929,28933,28937,28967,29000,29015,29022,29035,29036,29047,29057,29075,29130,29173,29177,29193,29258,29386,29387,29392,29441,29449,29454,29481,29487,29489,29511,29530,29540,29559,29562,29576,29577,29591,29592,29605,29634,29653,29659,29661,29718,29731,29738,29746,29750,29770,29834,29841,29870,29875,29883,30025,30089,30113,30218,30221,30225,30226,30251,30278,30283,30329,30357,30358,30360,30392,30470,30506,30512,30531,30550,30570,30625,30627,30675,30697,30703,30839,30840,30850,30853,30888,30895,30932,30947,30948,30991,31064,31213,31236,31287,31312,31423,31434,31493,31552,31563,31650,31654,31687,31699,31842,31870,32010,32158,32167,32176,32294,32436,32764,32769,32810,32816,32913,32944,32995,33035,33148,33154,33167,33169,33226,33298,33328,33342,33343,33345,33412,33435,33463,33472,33519,33521,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,33751,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,34098,34102,34135,34154,34163,34176,34183,34192,34193,34194,34201,34205,34226,34233,34234,34253,34254,34263,34268,34271,34277,34284,34305,34320,34327,34333,34350,34351,34356,34363,34370,34371,34392,34393,34394,34396,34399,34403,34412,34429,34446,34450,34462,34463,34464,34466,34472,34476,34477,34478,34497,34499,34502,34504,34514,34515,34517,34528,34529,34532,34536,34545,34556,34570,34572,34573,34579,34600,34606,34608,34612,34621,34633,34635,34659,34712,34716,34721,34742,34780,34787,34877,34884,34885,34893,34901,34906,34908,34915,34934,34947,34948,34959,34978,34983,34999,35015,35016,35019,35025,35048,35056,35076,35096,35099,35101,35107,35139,35147,35149,35151,35154,35157,35168,35179,35180,35182,35202,35208,35225,35235,35246,35249,35253,35257,35259,35276,35296,35316,35329,35352,35388,35404,35405,35424,35439,35444,35445,35450,35456,35461,35463,35466,35468,35473,35475,35478,35480,35481,35510,35516,35524,35551,35556,35578,35579,35580,35584,35600,35608,35618,35646,35692,35695,35696,35725,35733,35736,35758,35793,35802,35809,35823,35824,35828,35829,35831,35881,35892,35927,35929,35943,35944,35945,35976,35986,35997,36009,36043,36053,36054,36063,36065,36074,36077,36093,36129,36187,36217,36224,36256,36315,36328,36387,36394,36401,36426,36429,36431,36457,36497,36509,36515,36519,36522,36529,36537,36538,36546,36552,36553,36575,36588,36601,36612,36640,36646,36650,36655,36657,36661,36665,36668,36715,36731,36739,36757,36770,36771,36784,36787,36794,36796,36799,36842,36856,36876,36898,36909,36946,36994,37000,37001,37009,37025,37045,37068,37078,37080,37128,37145,37185,37189,37195,37255,37279,37296,37312,37318,37334,37336,37421,37438,37471,37595,37601,37604,37607,37608,37640,37665,37800,37854,37861,37863,37892,37957,37994,38061,38065,38075,38084,38087,38094,38102,38109,38122,38191,38279,38285,38319,38341,38377,38381,38481,38482,38483,38484,38513,38521,38556,38570,38627,38655,38670,38698,38705,38707,38725,38743,38754,38760,38773,38800,38807,38819,38850,38911,38969,39004,39033,39038,39048,39050,39065,39108,39111,39113,39132,39142,39145,39170,39173,39190,39202,39208,39213,39230,39234,39237,39286,39302,39319,39324,39335,39355,39395,39405,39412,39413,39459,39484,39526,39528,39539,39563,39572,39616,39645,39658,39669,39734,39740,39751,39774,39775,39805,39817,39820,39863,39878,39900,39950,39968,40026,40036,40037,40039,40045,40049,40061,40076,40097,40139,40156,40186,40201,40225,40241,40246,40247,40257,40292,40298,40310,40319,40328,40331,40348,40382,40392,40463,40489,40492,40532,40549,40558,40568,40577,40600,40604,40614,40635,40648,40661,40662,40681,40707,40737,40741,40751,40752,40770,40771,40821,40830,40836,40851,40874,40887,40920,40922,40960,40993,41006,41052,41056,41067,41083,41102,41133,41147,41163,41167,41195,41246,41270,41307,41422,41441,41478,41499,41509,41573,41579,41621,41679,41682,41796,41799,41818,41820,41824,41872,41937,41940,41962,41974,41975,41986,41987,41997,42060,42124,42161,42166,42171,42175,42192,42208,42211,42384,42400,42417,42418,42419,42432,42433,42449,42459,42475,42491,42534,42546,42582,42584,42600,42621,42626,42627,42631,42634,42636,42637,42661,42671,42684,42700,42720,42761,42782,42828,42841,42842,42855,42934,42994,43076,43077,43079,43080,43096,43097,43125,43137,43139,43156,43180,43201,43224,43232,43233,43262,43352,43456,43498,43594,43625,43635,43660,43769,43801,43834,43878,43881,43907,43910,44004,44063,44131,44134,44196,44197,44310,44383,44403,44446,44550,44705,44775,44796,44817,44834,44835,44877,44967,44984,44992,45016,45028,45033,45036,45081,45134,45136,45158,45173,45198,45224,45290,45293,45297,45298)
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 | 2809 | 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.42 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.53 ms |
System lock | 0.02 ms |
optimizing | 0.20 ms |
statistics | 4.50 ms |
preparing | 2.32 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.41 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.09 ms |
cleaning up | 0.24 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 |