Tiempo de la consulta: 14.65 ms Después de la última consulta: 2.28 ms Consulta a la memoria: 1.072 MB memoria antes de la consulta: 4.637 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-08 21:25:11')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-08 21:25:11')
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(4,8,13,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,54,55,75,82,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,183,184,194,195,197,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,260,263,269,270,287,318,328,350,361,367,385,391,393,394,407,412,414,415,416,419,420,421,422,423,424,425,426,427,428,429,430,431,432,470,473,475,479,482,489,529,563,581,594,639,644,645,653,662,666,672,675,692,693,754,770,794,802,826,847,848,861,868,874,880,893,896,902,907,924,935,967,1004,1005,1021,1085,1092,1112,1182,1200,1205,1231,1247,1255,1256,1280,1284,1285,1296,1326,1331,1335,1348,1354,1358,1382,1391,1408,1426,1437,1455,1467,1476,1477,1503,1509,1513,1535,1538,1603,1605,1634,1641,1646,1693,1713,1714,1718,1776,1800,1802,1804,1822,1837,1885,1900,1913,1915,2015,2018,2065,2122,2156,2217,2258,2305,2337,2367,2378,2424,2467,2469,2534,2569,2582,2598,2600,2601,2613,2618,2632,2636,2657,2668,2689,2779,2805,2807,2850,2885,2963,3067,3087,3095,3193,3212,3216,3251,3265,3268,3319,3337,3373,3379,3408,3452,3537,3575,3616,3688,3718,3719,3725,3825,3832,3869,3871,3951,3952,3953,3958,3976,4020,4033,4100,4118,4131,4138,4173,4277,4320,4339,4381,4435,4442,4473,4493,4586,4612,4613,4614,4615,4617,4624,4637,4648,4649,4675,4678,4698,4770,4785,4788,4790,4832,4844,4910,4932,4947,4957,4982,4990,4992,5023,5040,5079,5086,5104,5139,5150,5170,5173,5199,5207,5237,5259,5268,5279,5332,5333,5334,5360,5363,5394,5461,5530,5559,5560,5622,5658,5686,5692,5698,5798,5799,5807,5814,5827,5832,5833,5834,5848,5853,5855,5857,5862,5901,5914,5927,5949,5962,5970,5973,5985,5996,6009,6038,6039,6046,6063,6067,6072,6097,6134,6159,6168,6173,6218,6226,6241,6247,6264,6268,6270,6286,6305,6308,6319,6334,6335,6366,6372,6398,6427,6446,6452,6465,6468,6470,6475,6492,6500,6504,6506,6529,6532,6540,6545,6551,6571,6574,6575,6583,6599,6610,6611,6616,6661,6664,6669,6692,6695,6699,6710,6718,6744,6758,6765,6767,6768,6774,6776,6777,6798,6810,6824,6830,6839,6847,6848,6853,6867,6873,6884,6885,6889,6905,6910,6915,6917,6937,6941,6942,6944,6945,6955,6970,6985,6997,6998,7002,7037,7043,7046,7057,7081,7082,7083,7108,7117,7134,7136,7139,7140,7156,7172,7190,7191,7193,7194,7202,7205,7215,7218,7231,7232,7233,7234,7243,7245,7246,7249,7252,7258,7278,7285,7289,7294,7319,7323,7326,7328,7330,7333,7334,7340,7344,7346,7358,7364,7367,7368,7370,7371,7374,7377,7379,7380,7396,7406,7407,7408,7410,7413,7414,7415,7417,7419,7422,7430,7431,7435,7436,7445,7447,7450,7455,7456,7457,7458,7463,7464,7465,7482,7486,7489,7525,7526,7538,7543,7545,7546,7552,7553,7555,7560,7565,7567,7570,7577,7580,7582,7583,7596,7615,7618,7621,7624,7625,7633,7659,7663,7676,7678,7682,7683,7686,7687,7691,7715,7717,7718,7720,7721,7735,7744,7745,7746,7749,7757,7759,7761,7762,7764,7768,7775,7779,7794,7799,7800,7803,7811,7813,7815,7820,7828,7830,7833,7834,7835,7837,7851,7862,7863,7866,7867,7869,7871,7873,7883,7891,7894,7895,7900,7901,7919,7921,7932,7936,7938,7955,7957,7958,7961,7962,7979,7982,7995,7999,8020,8022,8023,8024,8026,8029,8032,8034,8036,8039,8049,8056,8057,8067,8072,8077,8083,8088,8089,8114,8155,8171,8186,8187,8221,8234,8268,8278,8286,8294,8297,8316,8330,8340,8347,8353,8354,8355,8359,8375,8387,8416,8417,8438,8462,8504,8534,8540,8582,8610,8612,8646,8662,8666,8670,8698,8712,8728,8758,8772,8779,8814,8818,8819,8822,8827,8836,8848,8858,8890,8892,8917,8925,8964,8972,8997,9012,9018,9023,9059,9067,9071,9083,9084,9086,9096,9097,9098,9100,9110,9114,9149,9155,9172,9188,9196,9197,9199,9206,9218,9222,9228,9233,9236,9238,9253,9264,9270,9300,9303,9320,9330,9344,9370,9404,9433,9481,9501,9528,9529,9568,9626,9640,9641,9653,9654,9656,9658,9699,9715,9716,9750,9752,9754,9755,9756,9767,9788,9808,9853,9865,9869,9889,9907,9909,9931,9970,9996,10035,10067,10068,10100,10112,10115,10129,10156,10179,10186,10197,10199,10205,10220,10243,10298,10301,10349,10352,10356,10364,10387,10400,10413,10474,10481,10522,10542,10603,10604,10625,10627,10677,10691,10706,10746,10759,10764,10765,10779,10811,10814,10854,10884,10886,10909,10932,10956,10970,10995,10996,11044,11071,11098,11106,11107,11112,11121,11138,11163,11179,11212,11220,11238,11244,11305,11332,11356,11397,11404,11408,11411,11413,11437,11440,11443,11444,11458,11465,11476,11527,11542,11565,11592,11627,11696,11700,11704,11722,11814,11820,11827,11857,11859,11864,11947,11994,12025,12083,12095,12104,12113,12144,12189,12198,12199,12216,12223,12226,12254,12288,12304,12324,12334,12344,12368,12375,12388,12435,12436,12437,12482,12488,12507,12524,12527,12541,12567,12592,12599,12609,12617,12649,12663,12669,12672,12683,12684,12701,12705,12708,12771,12807,12839,12854,12867,12889,12892,12896,12898,12902,12926,12944,12973,12978,13010,13023,13045,13067,13068,13074,13076,13126,13128,13145,13152,13154,13155,13190,13202,13209,13231,13232,13247,13248,13256,13266,13268,13269,13276,13277,13297,13321,13323,13325,13327,13328,13341,13348,13352,13358,13375,13413,13436,13452,13477,13485,13501,13509,13535,13543,13575,13576,13606,13608,13617,13628,13645,13646,13667,13681,13685,13693,13698,13727,13729,13731,13748,13750,13778,13782,13783,13798,13811,13846,13850,13851,13861,13868,13880,13924,13926,13938,13941,13950,13962,13970,13972,13973,13976,14037,14052,14064,14091,14100,14122,14125,14154,14156,14159,14179,14187,14203,14222,14246,14250,14293,14327,14338,14353,14356,14366,14400,14402,14411,14419,14421,14427,14428,14430,14431,14498,14505,14519,14524,14563,14577,14596,14604,14648,14663,14669,14677,14679,14680,14682,14688,14700,14713,14718,14733,14769,14770,14771,14774,14790,14796,14797,14807,14811,14832,14838,14846,14849,14860,14862,14865,14875,14905,14906,14907,14934,14942,14946,14948,14949,14969,14970,14973,14974,14982,14987,15001,15002,15007,15015,15020,15021,15038,15039,15045,15046,15047,15079,15110,15148,15157,15166,15179,15184,15185,15201,15208,15209,15223,15224,15228,15234,15257,15262,15272,15287,15293,15298,15304,15310,15315,15316,15318,15364,15365,15386,15411,15421,15450,15455,15460,15462,15465,15473,15476,15479,15482,15508,15515,15517,15524,15528,15533,15540,15550,15553,15555,15566,15583,15594,15625,15632,15640,15643,15650,15654,15665,15673,15685,15689,15706,15732,15751,15753,15759,15784,15797,15808,15824,15835,15841,15851,15856,15870,15874,15902,15913,15916,15917,15937,15940,15941,15947,15954,15967,15969,15980,15988,15999,16041,16051,16052,16055,16057,16066,16069,16071,16103,16120,16122,16125,16137,16172,16176,16184,16190,16202,16212,16214,16224,16240,16313,16323,16348,16365,16370,16383,16385,16387,16391,16410,16422,16428,16440,16455,16465,16469,16507,16519,16520,16523,16526,16543,16547,16550,16584,16585,16596,16637,16641,16642,16654,16675,16677,16680,16689,16720,16728,16737,16787,16802,16803,16812,16831,16857,16862,16880,16887,16894,16897,16907,16910,16917,16978,16979,17022,17026,17057,17080,17087,17093,17100,17131,17133,17136,17137,17139,17142,17148,17151,17169,17199,17209,17232,17233,17241,17248,17253,17269,17291,17295,17311,17317,17328,17334,17335,17336,17341,17344,17352,17356,17369,17388,17393,17404,17409,17412,17424,17448,17450,17454,17457,17476,17479,17481,17507,17520,17552,17557,17584,17587,17590,17594,17597,17603,17607,17609,17630,17635,17641,17642,17661,17667,17685,17698,17700,17721,17722,17728,17737,17740,17742,17776,17785,17788,17808,17809,17820,17822,17824,17826,17843,17856,17857,17862,17863,17883,17894,17902,17907,17908,17910,17927,17928,17934,17941,17949,17956,17958,17960,17965,17976,17977,17999,18002,18006,18021,18028,18029,18035,18040,18042,18067,18073,18078,18083,18105,18150,18165,18170,18181,18213,18220,18223,18227,18234,18235,18237,18245,18258,18292,18304,18306,18312,18353,18354,18362,18383,18389,18440,18442,18457,18473,18482,18508,18525,18527,18538,18558,18563,18576,18580,18595,18648,18675,18677,18707,18712,18719,18726,18730,18735,18736,18738,18745,18747,18753,18767,18771,18773,18774,18777,18779,18799,18801,18802,18817,18823,18824,18825,18834,18843,18845,18850,18851,18855,18879,18880,18885,18900,18905,18906,18907,18917,18919,18926,18935,18944,18954,18958,18964,18968,18969,18974,18979,18980,18996,18998,19012,19019,19024,19035,19039,19040,19041,19053,19073,19081,19085,19089,19094,19099,19101,19123,19127,19132,19150,19153,19154,19157,19159,19186,19188,19189,19197,19203,19204,19211,19216,19232,19235,19243,19245,19252,19256,19257,19265,19282,19294,19299,19303,19353,19358,19364,19376,19380,19390,19423,19424,19425,19426,19432,19452,19454,19472,19483,19484,19487,19489,19492,19508,19514,19520,19526,19527,19528,19532,19536,19542,19544,19553,19559,19584,19585,19589,19603,19605,19618,19619,19630,19649,19651,19655,19664,19675,19676,19685,19706,19723,19724,19745,19750,19764,19767,19772,19789,19791,19793,19796,19801,19805,19831,19843,19853,19858,19862,19876,19938,19950,19963,19967,19968,19988,20002,20003,20030,20037,20039,20046,20066,20068,20072,20082,20088,20092,20102,20115,20116,20122,20159,20183,20190,20191,20201,20202,20208,20209,20223,20226,20236,20262,20265,20266,20275,20289,20298,20309,20323,20338,20341,20362,20372,20384,20385,20386,20396,20417,20428,20431,20434,20437,20438,20456,20469,20473,20477,20496,20501,20519,20521,20526,20528,20533,20548,20565,20566,20574,20577,20584,20590,20592,20608,20618,20642,20643,20648,20670,20674,20682,20685,20688,20717,20720,20732,20738,20750,20751,20754,20759,20766,20792,20797,20804,20808,20828,20832,20838,20852,20861,20864,20873,20876,20877,20879,20884,20885,20890,20891,20894,20908,20911,20918,20934,20935,20938,20939,20944,20953,20962,20964,20969,20976,20984,20985,20990,21003,21008,21044,21053,21059,21087,21095,21146,21147,21162,21176,21179,21182,21186,21188,21196,21198,21214,21221,21239,21240,21243,21259,21274,21275,21277,21280,21293,21299,21300,21308,21311,21326,21327,21329,21332,21333,21341,21354,21358,21364,21379,21387,21393,21404,21405,21412,21428,21429,21434,21446,21451,21454,21465,21469,21478,21487,21505,21515,21528,21538,21547,21559,21562,21573,21582,21598,21602,21609,21614,21624,21629,21638,21652,21653,21654,21680,21688,21691,21722,21726,21741,21744,21746,21747,21761,21767,21769,21773,21784,21798,21811,21817,21818,21824,21830,21835,21843,21845,21848,21868,21891,21911,21932,21942,21943,21946,21952,21958,21971,21981,21989,22014,22019,22036,22064,22094,22104,22109,22116,22120,22129,22134,22136,22137,22156,22158,22162,22164,22172,22180,22186,22201,22211,22213,22222,22226,22253,22259,22262,22267,22289,22290,22291,22299,22309,22314,22315,22325,22330,22335,22338,22409,22410,22414,22428,22435,22442,22448,22453,22466,22475,22481,22482,22484,22494,22499,22512,22524,22525,22541,22546,22561,22581,22591,22602,22613,22624,22630,22634,22638,22649,22655,22662,22678,22679,22687,22693,22726,22728,22733,22739,22749,22753,22755,22773,22781,22790,22797,22816,22844,22851,22860,22865,22869,22871,22874,22876,22882,22885,22886,22903,22914,22921,22925,22945,22959,22964,23036,23037,23083,23099,23102,23104,23107,23119,23123,23124,23143,23145,23161,23163,23184,23186,23213,23214,23217,23218,23229,23254,23257,23268,23287,23301,23309,23320,23328,23337,23362,23364,23381,23398,23444,23463,23491,23504,23513,23531,23541,23554,23604,23628,23632,23645,23652,23704,23705,23713,23714,23725,23729,23738,23751,23760,23805,23813,23833,23849,23868,23885,23886,23887,23888,23890,23891,23893,23897,23899,23901,23904,23905,23907,23921,23927,23948,23949,23964,23981,23983,23985,23986,24000,24022,24029,24039,24040,24055,24056,24059,24062,24067,24077,24123,24160,24163,24164,24179,24191,24197,24207,24211,24217,24222,24223,24281,24294,24309,24316,24317,24337,24338,24380,24429,24441,24485,24496,24500,24503,24526,24572,24587,24589,24591,24595,24617,24634,24678,24679,24683,24700,24722,24731,24736,24738,24781,24782,24785,24808,24834,24871,24915,24954,24983,25032,25038,25054,25068,25110,25154,25178,25201,25233,25294,25317,25377,25450,25456,25504,25505,25511,25538,25548,25555,25585,25593,25598,25607,25612,25621,25622,25630,25648,25656,25673,25717,25719,25723,25742,25750,25757,25818,25833,25855,25860,25863,25909,25927,25928,25941,25986,26000,26002,26028,26051,26066,26078,26113,26153,26214,26296,26335,26338,26359,26372,26376,26386,26388,26394,26396,26398,26406,26408,26409,26410,26476,26548,26565,26576,26579,26609,26620,26630,26639,26646,26661,26691,26699,26753,26775,26784,26820,26838,26845,26849,26858,26874,26879,26891,26905,26916,26922,26935,26944,26947,26956,26968,27065,27126,27164,27166,27179,27206,27212,27216,27249,27268,27269,27270,27323,27326,27347,27362,27367,27399,27408,27420,27422,27423,27437,27439,27482,27488,27492,27512,27541,27547,27568,27570,27583,27592,27595,27601,27604,27605,27671,27717,27726,27749,27758,27786,27789,27805,27851,27878,27997,28031,28059,28066,28075,28094,28097,28114,28120,28129,28162,28168,28192,28230,28241,28243,28249,28277,28329,28423,28435,28441,28468,28671,28673,28712,28743,28745,28846,28864,28886,28890,28959,29000,29001,29011,29045,29130,29167,29266,29387,29454,29511,29562,29639,29653,29769,29866,29870,30194,30506,30703,30932,30988,31113,31608,31798,31853,32084,32769,33416,33925,33946,33957,34025,34275,34331,34356,34616,34646,34693,34811,34815,35220,35227,35238,35239,35289,35376,35397,35426,35444,35490,35554,35556,35621,35639,35640,35643,35688,35692,35695,35725,35736,35744,35752,35758,35805,35806,35808,35882,35892,35945,35948,36000,36015,36065,36075,36208,36217,36220,36237,36368,36369,36373,36385,36420,36441,36515,36581,36584,36652,36917,36930,36989,36998,37010,37136,37147,37283,37307,37308,37378,37534,37626,37644,37759,38005,38058,38126,38133,38330,38362,38433,38489,38546,38773,38800,38807,38824,38850,38877,38904,38912,38922,38949,39004,39033,39036,39065,39111,39113,39132,39142,39145,39170,39173,39205,39208,39224,39237,39240,39286,39290,39296,39302,39319,39335,39355,39412,39413,39476,39497,39528,39539,39572,39587,39600,39610,39616,39645,39669,39717,39740,39751,39774,39775,39820,39878,39968,40036,40037,40039,40049,40097,40186,40201,40214,40225,40256,40257,40319,40328,40331,40392,40492,40509,40558,40560,40604,40647,40648,40661,40662,40681,40707,40737,40751,40752,40836,40887,40888,40920,40922,40993,41006,41062,41081,41083,41102,41147,41148,41163,41171,41195,41270,41332,41345,41516,41781,41969,42637,42987,43016,43109,43165,43237,43271,43405,43446,43461,43483,43712,44062,44366,44573,44682,44718,44788,44807,44808,44829,44873,44912,44935,44936,44988,45101,45138,45235,45263,45264,45316)
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 | 2554 | 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.12 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.06 ms |
init | 0.46 ms |
System lock | 0.02 ms |
optimizing | 0.16 ms |
statistics | 3.83 ms |
preparing | 1.88 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 5.95 ms |
end | 0.02 ms |
query end | 0.05 ms |
closing tables | 0.14 ms |
freeing items | 0.21 ms |
cleaning up | 0.06 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 |