Tiempo de la consulta: 9.41 ms Después de la última consulta: 2.59 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.496 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 22:41:39')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 22:41:39')
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,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,119,125,126,128,162,176,178,179,194,195,205,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,283,287,361,367,391,412,414,415,416,419,420,421,422,423,424,425,426,427,428,429,430,431,432,466,471,473,475,479,482,529,581,594,639,644,645,653,662,672,680,754,787,802,808,826,847,848,874,893,896,907,924,967,1004,1021,1092,1205,1255,1284,1326,1331,1335,1358,1382,1408,1426,1437,1467,1477,1503,1509,1555,1605,1687,1785,1885,1910,1928,1940,2013,2018,2065,2090,2092,2098,2109,2352,2353,2359,2466,2477,2569,2582,2592,2610,2618,2631,2740,2885,2965,2967,3085,3095,3140,3208,3251,3264,3265,3268,3329,3346,3379,3445,3452,3456,3511,3522,3537,3616,3664,3668,3688,3715,3757,3814,3825,3870,3882,3948,3953,3958,3969,3976,4020,4118,4138,4141,4163,4173,4270,4277,4339,4378,4388,4435,4442,4485,4494,4511,4572,4586,4637,4648,4649,4658,4668,4678,4698,4774,4785,4788,4790,4844,4932,5023,5077,5259,5279,5288,5332,5334,5360,5363,5394,5542,5560,5658,5689,5692,5698,5711,5730,5797,5807,5810,5820,5827,5832,5833,5834,5848,5849,5853,5862,5914,5927,5949,5962,5976,5985,6009,6012,6038,6063,6067,6072,6112,6130,6134,6168,6199,6218,6226,6241,6247,6251,6257,6286,6305,6307,6308,6319,6327,6331,6334,6335,6366,6398,6405,6429,6452,6475,6495,6500,6504,6506,6516,6529,6532,6540,6545,6551,6574,6575,6583,6599,6608,6610,6611,6612,6626,6653,6661,6664,6669,6699,6710,6718,6727,6735,6758,6765,6767,6768,6774,6775,6777,6798,6810,6824,6827,6833,6848,6853,6884,6885,6889,6905,6912,6941,6942,6944,6945,6955,6970,6997,6998,7002,7037,7043,7046,7057,7081,7108,7136,7139,7140,7156,7172,7190,7191,7193,7194,7196,7202,7227,7233,7245,7252,7258,7278,7323,7326,7329,7344,7416,7419,7433,7465,7477,7525,7560,7567,7580,7582,7596,7618,7621,7625,7633,7674,7676,7686,7687,7718,7721,7759,7761,7762,7764,7775,7779,7782,7794,7800,7803,7811,7813,7820,7828,7829,7837,7862,7867,7869,7873,7883,7892,7913,7921,7932,7936,7995,7999,8029,8032,8034,8077,8083,8088,8089,8114,8146,8155,8167,8171,8186,8187,8216,8221,8250,8260,8268,8278,8286,8294,8297,8316,8340,8353,8355,8359,8362,8387,8405,8416,8417,8484,8504,8534,8540,8552,8582,8583,8584,8612,8646,8662,8666,8670,8681,8689,8712,8728,8742,8758,8772,8779,8814,8818,8819,8820,8822,8827,8836,8848,8858,8890,8892,8899,8917,8925,8929,8964,8967,8997,9023,9046,9051,9067,9071,9083,9084,9085,9086,9096,9097,9098,9100,9107,9110,9114,9149,9155,9172,9188,9199,9206,9211,9222,9224,9228,9233,9236,9238,9264,9270,9313,9320,9404,9433,9500,9501,9518,9524,9528,9595,9626,9640,9641,9653,9654,9656,9699,9715,9716,9734,9750,9754,9755,9756,9767,9775,9788,9808,9851,9853,9858,9889,9892,9896,9909,9931,9965,9970,9999,10008,10035,10067,10068,10100,10156,10179,10180,10216,10220,10272,10298,10301,10356,10364,10412,10413,10420,10459,10474,10542,10559,10562,10625,10627,10677,10706,10715,10745,10746,10757,10765,10779,10804,10811,10814,10854,10878,10884,10886,10909,10925,10932,10990,10995,10996,11044,11112,11138,11179,11182,11212,11220,11238,11244,11332,11374,11397,11408,11411,11413,11437,11440,11443,11444,11458,11465,11527,11542,11554,11565,11592,11696,11700,11704,11730,11814,11827,11857,11947,12025,12053,12054,12104,12189,12198,12199,12224,12288,12304,12318,12324,12334,12344,12368,12375,12388,12436,12437,12482,12507,12524,12567,12599,12672,12683,12684,12701,12705,12714,12803,12839,12867,12892,12895,12896,12898,12902,12926,12973,12980,12997,13010,13018,13023,13039,13061,13067,13068,13076,13126,13128,13140,13145,13155,13159,13202,13209,13219,13221,13231,13232,13247,13248,13256,13260,13266,13276,13277,13290,13297,13323,13341,13348,13402,13413,13436,13452,13465,13477,13485,13543,13606,13608,13617,13628,13645,13646,13687,13698,13725,13729,13731,13778,13798,13811,13850,13851,13861,13880,13926,13950,13962,13970,13972,13976,14037,14064,14091,14100,14125,14154,14156,14159,14179,14187,14222,14246,14285,14293,14338,14353,14366,14402,14411,14419,14427,14428,14432,14435,14446,14498,14519,14548,14563,14581,14586,14598,14604,14677,14682,14684,14699,14700,14718,14761,14774,14790,14796,14797,14807,14811,14832,14838,14862,14875,14932,14942,14949,14953,14969,14970,14982,15001,15002,15007,15038,15047,15079,15148,15184,15185,15223,15224,15228,15246,15257,15272,15287,15293,15310,15311,15315,15316,15365,15411,15450,15455,15460,15462,15465,15476,15479,15508,15515,15524,15533,15555,15561,15566,15583,15595,15615,15625,15632,15640,15643,15650,15654,15665,15685,15705,15706,15732,15741,15759,15781,15824,15841,15856,15870,15913,15917,15940,15941,15947,15954,15965,15967,15969,15980,15985,15988,15999,16041,16051,16052,16066,16069,16071,16106,16120,16137,16142,16176,16184,16190,16191,16202,16212,16224,16237,16246,16323,16348,16365,16370,16383,16385,16387,16391,16428,16469,16507,16523,16526,16539,16543,16547,16550,16567,16573,16587,16641,16642,16667,16675,16677,16680,16749,16787,16803,16831,16857,16862,16880,16887,16897,16910,16944,16950,16978,16979,17022,17057,17065,17087,17093,17100,17127,17131,17137,17139,17142,17148,17151,17169,17193,17232,17233,17241,17248,17253,17295,17311,17328,17335,17336,17341,17346,17388,17393,17404,17419,17420,17424,17441,17442,17448,17450,17454,17457,17463,17481,17507,17522,17537,17552,17557,17587,17594,17631,17635,17641,17642,17654,17661,17667,17685,17698,17719,17721,17722,17728,17737,17740,17742,17776,17785,17788,17808,17809,17820,17822,17824,17843,17856,17894,17900,17907,17908,17928,17934,17948,17956,17958,17960,17987,18002,18006,18021,18035,18038,18040,18041,18042,18073,18078,18083,18105,18135,18181,18220,18223,18234,18235,18237,18245,18258,18271,18277,18292,18304,18306,18312,18354,18410,18440,18457,18508,18509,18525,18527,18563,18580,18624,18648,18670,18677,18707,18719,18736,18738,18745,18747,18767,18771,18773,18774,18777,18778,18779,18799,18801,18802,18823,18824,18834,18843,18850,18851,18855,18879,18880,18885,18900,18917,18919,18935,18944,18954,18964,18968,18969,18974,18979,18980,18996,18998,19012,19019,19024,19029,19035,19040,19041,19053,19073,19076,19081,19089,19094,19099,19127,19132,19154,19157,19159,19186,19188,19189,19197,19203,19216,19242,19245,19256,19257,19265,19282,19288,19294,19303,19358,19364,19376,19380,19390,19424,19425,19430,19452,19472,19489,19492,19508,19514,19520,19526,19528,19532,19536,19544,19553,19559,19584,19585,19589,19603,19605,19618,19619,19630,19649,19655,19664,19675,19685,19715,19723,19724,19745,19764,19777,19789,19793,19801,19802,19805,19831,19833,19843,19853,19920,19938,19950,19963,19968,20002,20037,20046,20066,20072,20082,20088,20102,20115,20116,20159,20190,20201,20202,20208,20209,20223,20226,20236,20265,20266,20272,20275,20295,20298,20323,20325,20341,20362,20372,20417,20428,20431,20438,20456,20473,20477,20496,20501,20519,20533,20548,20549,20571,20577,20584,20590,20596,20598,20608,20641,20643,20674,20682,20685,20692,20715,20717,20720,20732,20738,20754,20759,20766,20797,20801,20807,20808,20832,20838,20852,20861,20864,20873,20876,20877,20882,20884,20887,20890,20891,20897,20908,20911,20934,20935,20938,20939,20962,20969,20976,20985,21003,21008,21044,21053,21059,21066,21095,21173,21176,21179,21186,21191,21199,21214,21221,21239,21240,21274,21275,21277,21280,21293,21299,21308,21310,21311,21326,21333,21341,21354,21356,21358,21364,21379,21387,21393,21412,21428,21429,21434,21446,21451,21465,21469,21478,21502,21505,21515,21528,21530,21538,21559,21560,21562,21573,21582,21599,21609,21629,21638,21652,21653,21654,21680,21688,21691,21741,21744,21746,21759,21784,21791,21798,21817,21818,21824,21830,21835,21842,21845,21848,21908,21911,21942,21943,21946,21965,21971,21981,21989,22019,22037,22064,22094,22104,22109,22129,22130,22136,22156,22157,22158,22164,22180,22186,22201,22211,22213,22222,22226,22259,22267,22291,22299,22309,22314,22315,22325,22330,22335,22338,22410,22414,22428,22435,22442,22448,22475,22482,22512,22524,22525,22546,22561,22591,22606,22609,22613,22624,22638,22649,22655,22662,22678,22679,22687,22728,22733,22741,22746,22749,22755,22773,22816,22826,22827,22844,22860,22874,22876,22882,22885,22903,22921,22945,23074,23102,23116,23123,23124,23143,23145,23161,23163,23186,23217,23257,23277,23301,23320,23337,23362,23404,23444,23463,23508,23513,23531,23541,23576,23584,23645,23652,23695,23702,23705,23714,23731,23738,23760,23833,23866,23868,23906,23948,23949,23985,24022,24055,24056,24059,24164,24179,24191,24207,24217,24222,24253,24255,24309,24317,24338,24380,24424,24441,24474,24477,24564,24592,24634,24683,24700,24721,24722,24738,24784,24808,24899,24947,24954,24957,25054,25110,25154,25228,25260,25317,25408,25415,25420,25443,25445,25456,25501,25504,25511,25585,25593,25598,25603,25611,25612,25621,25630,25640,25643,25648,25656,25663,25664,25671,25673,25703,25717,25719,25742,25750,25753,25755,25770,25782,25833,25834,25841,25855,25860,25864,25868,25877,25882,25884,25900,25922,25929,25933,25935,25964,25967,25975,25979,25986,26001,26002,26020,26023,26026,26028,26030,26054,26056,26064,26078,26092,26093,26097,26128,26160,26166,26173,26179,26185,26186,26189,26191,26193,26207,26214,26221,26230,26231,26239,26240,26248,26262,26275,26287,26297,26319,26327,26338,26374,26376,26380,26393,26394,26396,26398,26406,26408,26410,26431,26435,26440,26448,26451,26456,26459,26467,26469,26476,26490,26516,26519,26530,26536,26541,26548,26559,26560,26562,26571,26574,26575,26579,26596,26601,26605,26629,26635,26650,26661,26664,26684,26685,26704,26709,26715,26716,26717,26723,26725,26732,26740,26741,26742,26745,26747,26748,26750,26752,26757,26760,26767,26768,26775,26777,26788,26789,26801,26818,26832,26841,26848,26849,26858,26859,26874,26891,26896,26897,26905,26912,26916,26936,26937,26944,26947,26955,26956,26959,26960,26969,26976,26977,26990,27001,27003,27005,27015,27018,27025,27028,27050,27055,27056,27058,27063,27064,27089,27100,27129,27136,27150,27156,27161,27166,27174,27204,27206,27230,27249,27268,27269,27270,27272,27275,27293,27294,27295,27298,27308,27315,27317,27326,27327,27330,27350,27362,27376,27384,27399,27420,27422,27427,27437,27438,27439,27466,27476,27478,27482,27488,27491,27516,27547,27570,27577,27589,27591,27602,27642,27644,27660,27673,27681,27701,27706,27709,27712,27714,27717,27718,27726,27732,27737,27738,27748,27752,27753,27754,27757,27772,27786,27805,27811,27827,27838,27839,27851,27878,27880,27905,27932,27944,27966,27971,27982,27997,28006,28036,28038,28048,28102,28127,28137,28139,28141,28154,28176,28211,28215,28223,28232,28235,28255,28274,28276,28277,28287,28293,28305,28308,28331,28345,28352,28356,28358,28361,28362,28363,28367,28368,28375,28376,28423,28430,28441,28460,28466,28467,28471,28474,28475,28479,28482,28484,28488,28489,28494,28496,28497,28506,28519,28525,28530,28568,28611,28650,28654,28671,28712,28730,28731,28745,28773,28863,28871,28887,28890,28894,28924,29000,29078,29130,29274,29284,29285,29307,29342,29378,29379,29387,29396,29399,29436,29454,29474,29511,29520,29532,29541,29545,29546,29555,29560,29562,29578,29579,29598,29602,29603,29612,29663,29672,29767,29779,29794,29818,29819,29870,29934,29940,29966,29977,30093,30163,30168,30202,30222,30333,30351,30373,30382,30395,30405,30406,30413,30447,30450,30465,30484,30504,30506,30515,30525,30569,30580,30608,30613,30638,30687,30689,30703,30721,30739,30741,30763,30932,30967,30994,31016,31167,31174,31188,31207,31218,31235,31311,31312,31314,31315,31317,31331,31337,31345,31355,31394,31399,31402,31422,31431,31471,31527,31530,31568,31577,31586,31613,31679,31685,31741,31760,31764,31820,31849,31863,31866,31931,31938,31939,31962,31975,31982,32062,32069,32125,32172,32185,32225,32229,32239,32271,32374,32380,32397,32440,32441,32445,32494,32523,32548,32689,32693,32699,32769,32776,32832,32855,32860,32870,32903,32915,32945,32973,32982,33092,33099,33106,33116,33143,33146,33150,33221,33254,33271,33299,33301,33329,33346,33351,33499,33508,33569,33573,33580,33584,33744,33861,33872,33951,33952,33953,33956,33957,33964,33966,33974,33993,33999,34010,34014,34081,34082,34093,34105,34118,34122,34130,34161,34166,34171,34175,34191,34197,34204,34213,34226,34254,34257,34277,34308,34356,34377,34380,34405,34420,34432,34439,34451,34452,34460,34467,34468,34470,34487,34488,34493,34500,34501,34518,34538,34543,34546,34555,34561,34578,34589,34605,34641,34665,34718,34731,34754,34759,34775,34776,34793,34802,34825,34830,34836,34857,34861,34961,34963,34968,34981,35021,35040,35055,35077,35084,35090,35100,35102,35104,35115,35116,35137,35138,35184,35196,35224,35294,35296,35311,35317,35345,35359,35369,35376,35378,35387,35395,35418,35419,35422,35435,35440,35448,35452,35453,35462,35465,35469,35484,35497,35507,35523,35526,35530,35546,35548,35550,35562,35565,35566,35575,35581,35614,35623,35633,35663,35692,35695,35710,35725,35729,35736,35758,35827,35831,35841,35866,35878,35892,35909,35915,35942,35945,35950,35956,35969,35971,35979,36035,36065,36066,36069,36070,36094,36154,36175,36176,36198,36212,36216,36217,36228,36249,36250,36258,36262,36279,36281,36335,36338,36452,36515,36585,36625,36803,36859,36910,36952,36985,37040,37062,37197,37558,37560,37635,37652,38113,38549,38666,38671,38773,38800,38806,38807,38814,38846,38847,38850,38857,38862,38865,38867,38868,38870,38872,38874,38875,38876,38877,38878,38879,38880,38881,38882,38883,38884,38885,38886,38887,38888,38889,38890,38891,38892,38893,38894,38895,38898,38899,38902,38904,38910,38912,38913,38915,38921,38923,38925,38930,38932,38938,38939,38942,38963,38964,38973,38974,38986,38988,39004,39033,39064,39065,39111,39113,39127,39132,39142,39145,39170,39173,39194,39208,39237,39286,39302,39319,39335,39355,39412,39413,39415,39528,39539,39570,39572,39616,39620,39645,39669,39740,39751,39774,39775,39820,39878,39892,39942,39943,39968,40036,40037,40039,40049,40097,40186,40201,40225,40257,40271,40328,40331,40343,40356,40367,40392,40453,40492,40515,40545,40554,40558,40595,40604,40629,40648,40661,40662,40664,40674,40681,40707,40720,40728,40737,40739,40746,40751,40752,40768,40773,40778,40780,40786,40836,40839,40860,40865,40880,40887,40920,40922,40967,40972,40993,41000,41006,41007,41039,41064,41076,41083,41102,41108,41147,41153,41158,41163,41174,41195,41200,41205,41217,41234,41270,41290,41295,41322,41334,41339,41410,41421,41431,41491,41500,41505,41506,41507,41516,41528,41543,41548,41578,41581,41588,41611,41612,41613,41623,41628,41645,41653,41654,41658,41659,41668,41669,41674,41685,41687,41690,41702,41733,41741,41769,41774,41786,41791,41792,41794,41815,41816,41821,41832,41840,41876,41911,41912,41965,41968,41995,42023,42031,42034,42037,42049,42054,42079,42111,42133,42176,42190,42206,42231,42282,42287,42290,42313,42325,42326,42350,42362,42367,42368,42389,42415,42424,42453,42458,42480,42493,42514,42515,42532,42536,42540,42565,42591,42623,42628,42650,42688,42693,42726,42758,42847,42860,42883,42888,42891,42933,42940,42946,42951,42965,42992,43028,43035,43054,43063,43070,43071,43091,43128,43130,43141,43146,43147,43154,43174,43207,43216,43217,43218,43270,43271,43292,43305,43358,43414,43432,43450,43465,43479,43487,43530,43537,43541,43554,43567,43572,43578,43584,43592,43598,43619,43620,43623,43633,43653,43655,43660,43667,43675,43678,43681,43694,43695,43696,43738,43770,43778,43810,43815,43816,43842,43847,43855,43856,43909,43911,43927,43931,43937,44002,44018,44037,44042,44103,44143,44177,44249,44250,44253,44254,44292,44297,44303,44317,44380,44399,44445,44451,44452,44459,44469,44475,44476,44483,44499,44565,44575,44577,44587,44633,44753,44754,44794,44799,44800,44814,44826,44839,44844,44916,44927,44932,44933,44936,44941,44954,44966,44976,44994,44998,45006,45060,45063,45064,45069,45115,45140,45141,45180,45181,45210,45213,45226,45231,45247,45265,45281,45282,45286,45308)
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 | 2739 | 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.22 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.48 ms |
System lock | 0.02 ms |
optimizing | 0.18 ms |
statistics | 4.09 ms |
preparing | 2.07 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.49 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.12 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 |