Tiempo de la consulta: 12.33 ms Después de la última consulta: 2.80 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.517 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-06 12:31:06')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 12:31:06')
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,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,214,215,224,226,227,228,229,230,231,232,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,252,253,261,267,269,270,287,316,361,367,368,391,412,414,415,416,419,420,421,422,423,424,425,426,427,428,429,430,431,432,452,472,473,475,479,482,510,529,581,594,611,639,644,645,653,662,672,754,802,826,837,847,848,874,893,896,907,922,924,931,967,971,979,981,1001,1004,1010,1021,1051,1053,1066,1092,1111,1136,1205,1213,1235,1255,1284,1299,1301,1326,1331,1335,1342,1343,1352,1358,1370,1382,1396,1408,1426,1437,1457,1467,1473,1477,1491,1509,1518,1551,1569,1602,1605,1649,1767,1806,1885,1907,1924,1944,2018,2054,2065,2093,2142,2155,2324,2331,2376,2424,2427,2435,2437,2543,2559,2569,2582,2618,2665,2695,2885,2963,3003,3011,3095,3114,3131,3224,3240,3245,3251,3265,3268,3352,3379,3426,3450,3452,3454,3468,3481,3537,3543,3567,3616,3660,3662,3664,3688,3708,3825,3926,3937,3948,3953,3958,3976,4020,4096,4118,4132,4138,4152,4173,4210,4218,4227,4261,4277,4283,4293,4295,4328,4435,4442,4586,4637,4648,4649,4678,4698,4699,4716,4785,4788,4790,4844,4859,4884,4932,5023,5049,5135,5189,5230,5259,5279,5332,5334,5336,5347,5360,5363,5394,5397,5410,5429,5454,5498,5560,5591,5658,5690,5692,5698,5714,5719,5807,5827,5832,5833,5834,5848,5853,5862,5872,5914,5927,5949,5962,5965,5985,5986,6009,6012,6014,6038,6045,6063,6067,6072,6134,6168,6173,6218,6226,6227,6241,6247,6286,6305,6308,6319,6334,6335,6346,6366,6398,6452,6462,6475,6496,6500,6504,6506,6517,6529,6532,6540,6545,6551,6574,6575,6583,6599,6608,6610,6611,6615,6661,6664,6669,6699,6710,6718,6758,6765,6767,6768,6774,6777,6778,6798,6810,6824,6848,6853,6863,6884,6885,6889,6905,6941,6942,6944,6945,6947,6955,6970,6997,6998,7002,7024,7037,7039,7043,7046,7057,7081,7108,7123,7135,7136,7139,7140,7156,7162,7163,7164,7169,7172,7190,7191,7192,7193,7194,7202,7230,7233,7245,7252,7258,7278,7287,7294,7323,7326,7344,7416,7419,7449,7465,7467,7525,7547,7560,7567,7580,7582,7596,7618,7621,7633,7647,7659,7673,7676,7686,7687,7716,7718,7721,7759,7761,7762,7764,7775,7779,7785,7794,7800,7803,7811,7813,7820,7822,7828,7837,7862,7867,7869,7873,7883,7921,7932,7936,7990,7995,7996,7999,8029,8032,8034,8051,8077,8083,8088,8089,8114,8149,8155,8171,8186,8187,8221,8257,8266,8267,8268,8278,8286,8294,8297,8316,8335,8340,8353,8355,8359,8387,8414,8416,8417,8421,8444,8483,8504,8518,8534,8540,8556,8572,8582,8584,8612,8646,8652,8659,8662,8666,8670,8712,8719,8728,8735,8758,8762,8772,8779,8814,8819,8822,8827,8836,8847,8848,8858,8868,8870,8890,8892,8897,8917,8925,8927,8964,8997,9008,9023,9051,9067,9071,9081,9083,9084,9086,9096,9097,9098,9100,9110,9114,9149,9155,9160,9172,9188,9195,9199,9206,9222,9228,9231,9233,9236,9238,9264,9270,9282,9320,9363,9404,9417,9433,9501,9528,9597,9598,9626,9640,9641,9653,9654,9656,9680,9699,9715,9716,9750,9754,9755,9756,9767,9776,9788,9798,9799,9806,9808,9814,9853,9855,9889,9909,9931,9968,9970,9978,9999,10035,10042,10067,10068,10100,10138,10139,10156,10179,10220,10296,10298,10301,10356,10364,10413,10433,10458,10474,10542,10544,10584,10620,10625,10627,10671,10677,10706,10709,10715,10746,10765,10779,10811,10814,10854,10884,10886,10909,10910,10932,10995,10996,11044,11112,11138,11155,11179,11209,11212,11220,11238,11244,11265,11319,11332,11374,11397,11408,11411,11413,11437,11440,11443,11444,11458,11465,11527,11542,11565,11592,11696,11700,11704,11808,11809,11810,11813,11814,11827,11857,11907,11947,12025,12074,12104,12140,12146,12168,12189,12198,12199,12217,12237,12248,12288,12304,12324,12334,12344,12368,12375,12388,12436,12437,12440,12482,12507,12524,12567,12599,12631,12669,12672,12683,12684,12701,12705,12714,12746,12839,12867,12892,12896,12898,12902,12903,12926,12972,12973,12993,12995,13010,13023,13060,13067,13068,13076,13122,13126,13128,13145,13155,13165,13202,13209,13231,13232,13247,13248,13256,13263,13266,13275,13276,13277,13297,13323,13341,13348,13374,13413,13436,13445,13452,13477,13485,13533,13535,13537,13543,13547,13576,13606,13608,13617,13628,13645,13646,13647,13664,13692,13698,13729,13731,13778,13798,13806,13811,13814,13850,13851,13853,13856,13861,13880,13898,13926,13943,13950,13962,13970,13972,13976,14037,14062,14064,14091,14095,14100,14125,14154,14156,14159,14179,14187,14222,14245,14246,14278,14281,14293,14338,14346,14350,14353,14360,14402,14411,14419,14427,14428,14432,14498,14519,14534,14562,14563,14574,14604,14654,14655,14677,14682,14700,14718,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,15079,15128,15142,15147,15148,15174,15184,15185,15218,15219,15223,15224,15228,15257,15272,15287,15293,15310,15315,15316,15343,15356,15365,15373,15390,15411,15420,15434,15448,15450,15455,15460,15462,15465,15476,15479,15494,15508,15515,15524,15533,15555,15566,15583,15625,15632,15638,15640,15643,15650,15654,15656,15665,15676,15685,15706,15732,15759,15824,15831,15841,15856,15890,15913,15917,15940,15941,15945,15947,15954,15967,15969,15973,15980,15988,15999,16003,16041,16051,16052,16066,16069,16071,16094,16120,16137,16176,16184,16190,16202,16212,16224,16268,16323,16340,16348,16365,16370,16383,16385,16387,16391,16428,16439,16469,16507,16517,16523,16543,16547,16550,16622,16641,16642,16652,16673,16675,16677,16680,16693,16755,16787,16803,16825,16826,16831,16847,16848,16857,16862,16880,16887,16897,16905,16910,16911,16913,16944,16978,16979,16986,17022,17026,17027,17057,17087,17093,17097,17099,17100,17131,17137,17139,17142,17148,17151,17155,17169,17232,17233,17237,17241,17248,17253,17255,17295,17301,17311,17328,17335,17336,17341,17367,17373,17388,17393,17404,17424,17448,17450,17454,17457,17481,17488,17496,17507,17513,17552,17557,17587,17594,17604,17635,17641,17642,17653,17661,17667,17669,17682,17684,17685,17698,17721,17722,17724,17728,17737,17740,17742,17755,17769,17776,17784,17785,17788,17808,17809,17819,17820,17822,17843,17856,17875,17894,17907,17908,17928,17934,17948,17956,17958,17960,18002,18006,18021,18035,18040,18042,18055,18060,18071,18073,18078,18083,18085,18096,18105,18114,18169,18175,18181,18220,18223,18234,18235,18237,18245,18258,18269,18271,18285,18292,18304,18306,18312,18344,18354,18440,18446,18457,18508,18525,18527,18563,18580,18600,18636,18647,18648,18677,18684,18700,18707,18719,18736,18738,18745,18747,18760,18767,18771,18773,18774,18777,18779,18799,18801,18802,18823,18824,18829,18834,18843,18850,18851,18853,18855,18859,18879,18880,18885,18898,18900,18917,18919,18935,18944,18954,18964,18968,18969,18974,18979,18980,18993,18996,18998,19012,19014,19019,19024,19035,19041,19053,19056,19063,19073,19081,19089,19094,19099,19110,19127,19132,19154,19157,19158,19159,19182,19186,19188,19189,19197,19203,19216,19245,19256,19257,19265,19282,19294,19296,19303,19316,19358,19364,19376,19380,19390,19424,19425,19452,19472,19489,19492,19505,19508,19514,19520,19525,19526,19528,19532,19536,19543,19544,19553,19557,19559,19563,19572,19584,19585,19589,19603,19605,19618,19619,19630,19632,19649,19655,19661,19664,19675,19685,19698,19723,19724,19727,19745,19764,19789,19793,19799,19801,19805,19831,19843,19853,19910,19922,19938,19950,19957,19963,19968,19976,19980,19986,20002,20025,20037,20046,20066,20072,20082,20088,20101,20102,20105,20115,20116,20157,20159,20190,20200,20201,20202,20208,20209,20223,20226,20236,20265,20266,20275,20298,20305,20323,20341,20347,20362,20372,20378,20395,20417,20423,20428,20431,20435,20438,20456,20463,20473,20477,20482,20496,20501,20519,20533,20548,20557,20567,20577,20584,20590,20598,20608,20643,20669,20674,20682,20685,20700,20712,20717,20720,20732,20738,20754,20756,20759,20766,20797,20808,20832,20833,20837,20838,20852,20861,20864,20865,20873,20876,20877,20884,20889,20890,20891,20908,20911,20934,20935,20938,20939,20962,20969,20976,20978,20985,21003,21008,21016,21028,21031,21032,21044,21053,21059,21069,21070,21094,21095,21176,21179,21186,21189,21198,21200,21203,21204,21205,21214,21221,21239,21240,21274,21275,21277,21280,21293,21299,21308,21311,21326,21333,21341,21354,21355,21358,21364,21368,21379,21387,21393,21411,21412,21428,21429,21434,21446,21451,21465,21469,21478,21481,21505,21509,21515,21528,21535,21538,21558,21559,21562,21573,21582,21609,21629,21638,21650,21652,21653,21654,21680,21688,21691,21720,21727,21741,21744,21746,21762,21784,21798,21817,21818,21824,21830,21835,21845,21848,21874,21875,21911,21942,21943,21946,21971,21981,21989,22019,22020,22037,22043,22062,22064,22094,22104,22109,22129,22130,22131,22136,22155,22158,22164,22169,22174,22180,22181,22186,22195,22201,22204,22211,22213,22222,22226,22241,22259,22267,22275,22291,22299,22309,22314,22315,22325,22330,22335,22338,22357,22399,22406,22410,22414,22420,22428,22435,22442,22446,22448,22456,22475,22482,22485,22506,22510,22512,22524,22525,22529,22546,22561,22578,22591,22608,22613,22624,22625,22626,22634,22638,22649,22655,22662,22663,22678,22679,22687,22728,22732,22733,22741,22749,22755,22773,22780,22782,22811,22816,22824,22829,22844,22860,22861,22874,22876,22878,22882,22885,22897,22903,22921,22938,22945,22986,23035,23038,23052,23061,23102,23117,23123,23124,23137,23143,23145,23161,23163,23179,23186,23207,23217,23254,23301,23304,23320,23324,23327,23337,23345,23362,23395,23444,23463,23508,23509,23513,23515,23531,23541,23590,23605,23645,23652,23705,23714,23738,23751,23754,23760,23794,23831,23833,23868,23948,23949,23985,24022,24055,24056,24059,24073,24087,24091,24134,24135,24164,24179,24182,24183,24191,24207,24217,24222,24266,24269,24309,24317,24320,24338,24357,24364,24374,24380,24393,24398,24404,24407,24436,24439,24441,24570,24582,24590,24626,24634,24640,24683,24700,24714,24717,24720,24722,24733,24777,24783,24803,24808,24824,24890,24895,24948,24950,24954,24982,25026,25035,25051,25054,25098,25110,25117,25154,25162,25165,25171,25183,25208,25214,25241,25317,25365,25407,25410,25411,25419,25433,25435,25436,25456,25482,25493,25504,25511,25518,25549,25585,25593,25598,25601,25612,25640,25642,25656,25659,25661,25665,25673,25698,25707,25709,25719,25721,25727,25731,25742,25750,25752,25761,25774,25802,25804,25812,25833,25860,25861,25871,25880,25897,25898,25907,25915,25922,25927,25942,25954,25955,25970,25975,25976,25982,25986,26002,26008,26010,26023,26028,26033,26040,26046,26078,26079,26080,26081,26143,26148,26149,26150,26158,26159,26182,26183,26184,26192,26195,26214,26221,26228,26276,26286,26318,26319,26338,26360,26370,26376,26394,26396,26398,26406,26408,26410,26422,26423,26424,26443,26454,26460,26461,26472,26474,26476,26483,26508,26511,26529,26533,26535,26543,26548,26594,26626,26661,26663,26678,26686,26708,26762,26775,26793,26837,26849,26858,26874,26891,26895,26905,26907,26916,26932,26944,26947,26956,26983,26987,27030,27032,27035,27052,27073,27091,27110,27117,27133,27157,27166,27176,27181,27206,27213,27220,27224,27249,27268,27269,27270,27326,27328,27331,27362,27367,27385,27399,27401,27408,27419,27420,27422,27426,27437,27439,27458,27482,27488,27533,27536,27547,27573,27584,27586,27597,27622,27623,27633,27657,27680,27717,27726,27730,27771,27776,27786,27804,27805,27825,27826,27842,27851,27878,27893,27928,27967,27984,27995,27997,28004,28011,28035,28052,28054,28057,28148,28173,28174,28202,28225,28269,28277,28282,28285,28298,28356,28359,28406,28423,28473,28514,28525,28536,28549,28550,28592,28622,28626,28631,28638,28671,28682,28712,28714,28735,28740,28744,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,29416,29441,29449,29454,29481,29487,29489,29511,29530,29540,29559,29562,29576,29577,29591,29592,29605,29634,29653,29661,29718,29731,29738,29746,29750,29763,29770,29821,29834,29841,29870,29875,29883,30025,30089,30113,30218,30221,30225,30226,30251,30278,30283,30329,30357,30358,30360,30392,30470,30488,30506,30512,30531,30550,30570,30625,30627,30675,30697,30703,30839,30840,30850,30853,30888,30895,30932,30947,30948,31064,31236,31287,31303,31312,31423,31434,31493,31552,31563,31650,31654,31664,31687,31699,31842,31870,32010,32151,32152,32158,32160,32167,32176,32195,32294,32436,32764,32769,32810,32816,32913,32944,32995,33035,33148,33154,33160,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,33739,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,34997,34999,35015,35016,35019,35025,35048,35056,35076,35096,35099,35101,35107,35139,35147,35149,35151,35154,35157,35168,35174,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,35894,35898,35927,35929,35943,35944,35945,35976,35986,35997,36009,36040,36043,36053,36054,36063,36065,36074,36077,36093,36129,36187,36217,36224,36256,36308,36315,36328,36387,36394,36401,36426,36429,36431,36457,36497,36509,36515,36519,36522,36529,36537,36538,36546,36552,36553,36557,36575,36587,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,36903,36909,36946,36994,37000,37001,37009,37025,37045,37065,37068,37128,37145,37159,37185,37189,37195,37208,37255,37279,37296,37311,37312,37318,37334,37336,37411,37421,37438,37471,37595,37601,37604,37607,37608,37640,37665,37800,37854,37861,37863,37892,37957,37994,38061,38065,38075,38084,38087,38094,38102,38104,38122,38191,38279,38285,38319,38340,38341,38377,38381,38428,38472,38481,38482,38483,38484,38513,38521,38548,38556,38570,38591,38627,38655,38670,38697,38698,38705,38707,38725,38743,38760,38762,38763,38773,38800,38807,38819,38850,38911,38969,39004,39021,39033,39036,39038,39048,39050,39065,39108,39111,39113,39123,39132,39142,39145,39170,39173,39190,39202,39208,39213,39230,39234,39237,39286,39299,39302,39319,39324,39335,39355,39395,39405,39409,39412,39413,39459,39484,39526,39528,39539,39563,39572,39616,39638,39645,39658,39669,39734,39740,39751,39774,39775,39805,39817,39820,39863,39878,39900,39950,39968,40016,40026,40036,40037,40039,40045,40049,40061,40076,40097,40139,40156,40186,40201,40219,40225,40241,40246,40247,40257,40292,40298,40310,40319,40328,40331,40382,40392,40463,40489,40492,40532,40549,40558,40577,40600,40604,40608,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,41142,41147,41163,41167,41195,41246,41270,41307,41422,41441,41478,41499,41509,41573,41579,41621,41679,41682,41753,41796,41799,41818,41820,41824,41872,41937,41940,41962,41974,41975,41986,41987,41997,42060,42100,42116,42124,42161,42166,42171,42175,42192,42208,42211,42384,42400,42403,42409,42417,42418,42419,42432,42433,42449,42459,42475,42491,42523,42534,42546,42548,42582,42584,42600,42621,42626,42627,42631,42634,42636,42637,42661,42671,42684,42698,42700,42720,42761,42782,42816,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,43532,43594,43625,43635,43660,43769,43801,43834,43841,43878,43881,43907,43910,44004,44063,44131,44134,44196,44197,44229,44310,44403,44446,44550,44679,44705,44775,44796,44817,44834,44835,44850,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 | 2943 | 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 | 2.22 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
Opening tables | 0.07 ms |
init | 0.72 ms |
System lock | 0.03 ms |
optimizing | 0.31 ms |
statistics | 5.37 ms |
preparing | 2.33 ms |
Sorting result | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.47 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.09 ms |
cleaning up | 0.04 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 |