Tiempo de la consulta: 9.85 ms Después de la última consulta: 2.71 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.588 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 21:48:24')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 21:48:24')
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,7,8,9,11,14,19,20,21,22,23,24,25,26,27,28,29,30,31,32,35,49,56,71,72,75,76,77,78,86,114,127,129,130,131,132,134,136,137,150,165,174,204,205,207,208,214,225,253,255,263,271,272,275,276,294,323,325,353,354,385,463,466,471,472,481,484,495,505,507,511,550,551,565,583,607,608,609,611,613,667,668,679,686,705,709,723,758,769,780,801,808,816,831,868,870,882,883,885,895,900,914,917,952,958,961,963,968,973,1031,1044,1047,1050,1059,1061,1078,1124,1134,1179,1183,1185,1196,1198,1204,1207,1226,1236,1238,1271,1302,1304,1317,1322,1338,1339,1347,1459,1477,1503,1504,1587,1594,1659,1664,1678,1679,1687,1697,1713,1718,1787,1803,1940,1944,1982,2010,2024,2098,2109,2146,2150,2181,2195,2216,2224,2272,2290,2293,2305,2352,2353,2359,2365,2367,2371,2372,2408,2415,2466,2482,2485,2631,2639,2705,2726,2756,2758,2796,2797,2840,2859,2863,2894,2933,2965,2967,2993,3000,3016,3038,3065,3108,3125,3126,3141,3193,3198,3208,3227,3236,3249,3264,3288,3306,3353,3442,3456,3491,3495,3511,3512,3522,3604,3626,3664,3668,3696,3715,3757,3769,3812,3814,3825,3832,3837,3871,3948,3975,3986,4004,4065,4092,4132,4133,4231,4242,4253,4255,4339,4378,4410,4458,4461,4469,4478,4485,4489,4494,4503,4549,4580,4631,4640,4670,4758,4814,4817,4868,4872,4878,4902,4910,4973,5018,5051,5077,5136,5154,5247,5334,5350,5365,5386,5451,5457,5530,5559,5570,5594,5600,5615,5634,5647,5660,5675,5686,5726,5727,5730,5785,5797,5798,5849,5870,5891,5894,6037,6127,6130,6141,6186,6245,6251,6256,6276,6278,6279,6298,6327,6330,6331,6339,6367,6393,6405,6415,6435,6448,6463,6470,6473,6475,6476,6477,6485,6503,6516,6520,6534,6542,6543,6548,6573,6577,6597,6604,6605,6608,6612,6616,6630,6643,6653,6656,6678,6684,6688,6708,6716,6723,6735,6742,6744,6764,6775,6793,6827,6833,6834,6835,6845,6860,6888,6889,6895,6906,6912,6936,6939,6945,6985,6989,7015,7061,7081,7185,7196,7232,7245,7269,7283,7291,7311,7329,7343,7368,7413,7454,7463,7483,7484,7486,7492,7495,7522,7528,7545,7546,7586,7588,7618,7674,7711,7718,7719,7720,7730,7741,7802,7832,7837,7848,7913,7934,7950,7955,7959,7965,7967,7980,7987,7989,7994,7997,7998,8017,8027,8049,8054,8073,8109,8143,8216,8222,8250,8297,8311,8325,8351,8356,8405,8416,8460,8480,8484,8508,8532,8549,8552,8565,8566,8568,8583,8584,8587,8603,8610,8613,8680,8689,8691,8706,8769,8819,8820,8909,8945,9010,9023,9073,9257,9284,9313,9339,9351,9401,9412,9451,9524,9552,9624,9626,9629,9734,9745,9766,9779,9792,9820,9894,9945,9982,9999,10008,10026,10048,10051,10092,10110,10120,10176,10180,10203,10205,10216,10217,10237,10248,10250,10260,10272,10278,10282,10295,10306,10311,10369,10385,10414,10415,10443,10453,10478,10554,10562,10660,10666,10668,10686,10697,10724,10857,10872,10877,10888,10912,10927,10951,10954,10971,10974,10978,11006,11015,11063,11076,11080,11083,11091,11094,11123,11146,11173,11206,11226,11244,11290,11320,11328,11388,11394,11410,11419,11424,11427,11438,11441,11468,11479,11487,11505,11534,11625,11712,11762,11766,11775,11788,11848,11883,11900,11925,11987,12025,12032,12108,12126,12186,12204,12218,12224,12228,12237,12248,12251,12306,12369,12370,12388,12393,12410,12415,12437,12449,12463,12474,12475,12493,12524,12545,12557,12576,12599,12608,12624,12625,12650,12672,12684,12686,12723,12727,12761,12789,12800,12803,12808,12816,12868,12894,12902,12936,12945,12980,13004,13006,13018,13020,13036,13060,13061,13115,13143,13154,13176,13188,13190,13191,13219,13221,13225,13241,13246,13259,13260,13269,13276,13309,13387,13399,13434,13456,13488,13508,13532,13543,13553,13560,13573,13589,13600,13604,13609,13611,13621,13631,13645,13646,13662,13672,13673,13674,13687,13695,13702,13707,13713,13715,13725,13729,13731,13782,13838,13851,13855,13860,13867,13920,13926,13933,13968,13972,13986,13994,13998,14005,14048,14057,14062,14083,14097,14100,14101,14114,14139,14164,14183,14184,14186,14205,14227,14232,14236,14250,14273,14282,14324,14331,14339,14341,14348,14361,14366,14368,14408,14426,14432,14446,14450,14456,14471,14486,14507,14548,14583,14600,14601,14604,14624,14652,14657,14665,14678,14692,14694,14722,14761,14794,14796,14807,14811,14815,14840,14856,14890,14905,14931,14941,14954,14961,14980,14993,15028,15038,15059,15069,15079,15108,15109,15120,15139,15147,15196,15215,15217,15243,15245,15250,15263,15266,15273,15293,15304,15310,15356,15370,15402,15411,15439,15455,15464,15475,15477,15485,15497,15521,15530,15548,15551,15562,15588,15595,15604,15633,15664,15699,15703,15709,15725,15728,15755,15757,15763,15782,15789,15837,15841,15848,15866,15870,15873,15893,15903,15935,15955,15964,15966,15972,16020,16037,16050,16059,16088,16093,16108,16148,16153,16161,16166,16191,16198,16206,16243,16257,16305,16317,16320,16342,16366,16369,16370,16392,16415,16417,16430,16431,16432,16451,16459,16465,16476,16477,16480,16507,16513,16534,16538,16539,16542,16545,16562,16571,16573,16587,16591,16605,16609,16619,16632,16644,16645,16648,16663,16720,16722,16749,16775,16783,16792,16825,16829,16837,16845,16867,16872,16880,16996,17005,17019,17048,17059,17115,17116,17128,17132,17137,17138,17153,17180,17186,17194,17227,17228,17242,17243,17244,17257,17263,17277,17285,17291,17303,17307,17322,17337,17339,17363,17373,17392,17407,17420,17432,17437,17438,17464,17465,17493,17510,17517,17533,17552,17557,17569,17623,17626,17634,17688,17703,17730,17747,17753,17766,17772,17775,17781,17812,17846,17852,17875,17889,17890,17895,17907,17908,17912,17925,17950,17952,17980,17987,18001,18007,18018,18031,18038,18051,18057,18072,18091,18100,18109,18116,18121,18134,18140,18169,18183,18200,18216,18239,18247,18260,18262,18273,18276,18294,18311,18314,18316,18331,18355,18360,18368,18384,18388,18402,18425,18431,18436,18440,18453,18481,18492,18493,18497,18499,18503,18505,18514,18524,18529,18543,18552,18562,18566,18569,18573,18577,18596,18625,18642,18646,18649,18659,18668,18670,18673,18679,18682,18687,18698,18702,18705,18730,18738,18764,18765,18781,18793,18834,18837,18839,18846,18847,18850,18853,18874,18880,18891,18912,18914,18927,18930,18934,18937,18944,18948,18951,18978,18986,18991,19003,19010,19013,19026,19043,19051,19053,19059,19064,19065,19073,19078,19083,19111,19133,19145,19168,19175,19184,19199,19207,19208,19219,19222,19237,19271,19281,19288,19290,19291,19292,19293,19303,19304,19318,19322,19329,19335,19348,19349,19364,19366,19371,19411,19415,19427,19429,19444,19448,19455,19457,19484,19497,19505,19507,19516,19519,19526,19535,19541,19553,19556,19565,19572,19578,19590,19595,19596,19612,19623,19639,19645,19646,19660,19666,19670,19682,19699,19700,19708,19720,19727,19741,19790,19802,19807,19820,19839,19841,19894,19921,19934,19953,19962,19970,19975,19976,20012,20016,20020,20029,20033,20073,20076,20088,20089,20091,20099,20104,20127,20133,20137,20142,20149,20153,20154,20174,20181,20185,20186,20187,20193,20198,20208,20210,20220,20237,20256,20258,20295,20317,20329,20334,20349,20368,20371,20397,20403,20413,20425,20432,20437,20458,20515,20523,20524,20541,20543,20549,20571,20587,20596,20621,20649,20654,20665,20668,20678,20684,20686,20714,20721,20726,20738,20739,20744,20748,20785,20786,20790,20797,20807,20809,20811,20880,20882,20885,20887,20890,20896,20897,20906,20923,20933,20940,20960,20969,20973,20976,20977,20980,20993,20996,21017,21073,21075,21110,21113,21115,21116,21145,21160,21163,21171,21180,21198,21199,21210,21213,21216,21248,21251,21266,21268,21275,21310,21331,21344,21346,21353,21378,21388,21392,21420,21430,21440,21447,21472,21481,21494,21502,21505,21520,21524,21537,21539,21540,21552,21571,21576,21579,21586,21609,21611,21645,21659,21667,21668,21669,21681,21709,21714,21733,21734,21748,21749,21763,21777,21781,21791,21798,21846,21851,21852,21864,21871,21895,21916,21922,21947,21950,21952,21965,21987,22008,22021,22027,22029,22038,22045,22065,22066,22087,22098,22110,22118,22124,22128,22129,22130,22150,22153,22171,22177,22192,22207,22212,22216,22223,22229,22238,22273,22289,22290,22295,22312,22334,22336,22345,22367,22371,22388,22389,22402,22422,22435,22442,22458,22468,22476,22500,22503,22508,22509,22543,22550,22566,22587,22596,22602,22634,22645,22672,22693,22702,22706,22708,22709,22715,22723,22738,22741,22753,22754,22788,22802,22826,22827,22829,22830,22850,22854,22868,22876,22888,22891,22901,22903,22920,22924,22931,22943,22977,22978,23023,23028,23041,23046,23063,23064,23070,23073,23077,23097,23104,23107,23116,23122,23123,23131,23148,23153,23187,23210,23213,23219,23225,23236,23253,23258,23267,23299,23305,23312,23317,23318,23353,23363,23365,23373,23382,23383,23397,23423,23424,23428,23441,23457,23467,23469,23488,23489,23495,23501,23508,23518,23520,23524,23541,23544,23566,23567,23569,23575,23592,23613,23615,23622,23646,23649,23657,23672,23677,23682,23695,23708,23722,23725,23729,23730,23732,23739,23749,23750,23770,23790,23793,23811,23816,23832,23838,23855,23859,23861,23872,23880,23899,23926,23967,23973,23977,23978,23984,23987,23990,24005,24024,24025,24088,24105,24111,24115,24118,24135,24137,24147,24158,24166,24193,24198,24202,24207,24219,24222,24229,24253,24255,24258,24263,24273,24282,24283,24289,24332,24375,24403,24411,24433,24437,24439,24440,24456,24460,24465,24475,24477,24498,24513,24536,24555,24557,24565,24568,24577,24597,24607,24612,24616,24636,24642,24649,24658,24665,24701,24713,24722,24732,24748,24765,24775,24780,24784,24814,24819,24823,24830,24838,24841,24853,24881,24899,24924,24941,24944,24957,24958,25003,25011,25039,25048,25080,25093,25099,25108,25155,25170,25183,25193,25200,25205,25228,25268,25269,25281,25287,25290,25312,25342,25348,25349,25356,25365,25386,25387,25394,25397,25408,25409,25415,25417,25420,25421,25443,25445,25447,25449,25452,25470,25474,25488,25490,25501,25512,25525,25528,25535,25541,25548,25553,25557,25560,25561,25591,25595,25603,25621,25630,25635,25640,25643,25648,25657,25659,25663,25664,25668,25671,25673,25684,25693,25703,25717,25725,25740,25746,25753,25755,25770,25782,25797,25833,25834,25841,25847,25855,25864,25868,25870,25877,25882,25884,25888,25900,25922,25933,25934,25935,25958,25967,25969,25975,25990,26020,26023,26026,26030,26039,26043,26048,26053,26054,26056,26063,26064,26092,26097,26102,26104,26135,26159,26160,26161,26166,26167,26173,26178,26179,26185,26186,26189,26191,26193,26207,26218,26221,26230,26231,26239,26240,26248,26249,26254,26255,26257,26262,26275,26282,26287,26297,26305,26317,26319,26327,26363,26369,26374,26375,26380,26395,26408,26409,26412,26431,26435,26440,26451,26456,26459,26467,26469,26483,26488,26490,26491,26499,26508,26516,26519,26525,26536,26541,26559,26560,26562,26564,26570,26571,26574,26575,26579,26590,26596,26601,26605,26629,26635,26636,26650,26664,26684,26685,26704,26709,26715,26716,26717,26723,26725,26726,26732,26734,26740,26741,26742,26744,26745,26747,26748,26750,26752,26757,26760,26767,26768,26775,26777,26779,26788,26789,26801,26807,26818,26824,26832,26835,26842,26843,26848,26859,26860,26864,26896,26897,26901,26902,26912,26933,26936,26937,26955,26959,26960,26969,26976,26977,26989,27001,27003,27005,27015,27018,27025,27028,27041,27050,27055,27056,27058,27059,27063,27064,27074,27084,27089,27100,27105,27121,27129,27130,27131,27136,27150,27156,27160,27161,27167,27174,27197,27204,27230,27235,27250,27251,27271,27272,27293,27294,27295,27305,27308,27314,27315,27317,27327,27330,27350,27362,27363,27376,27384,27397,27407,27427,27438,27440,27445,27466,27471,27476,27478,27482,27491,27502,27506,27516,27518,27570,27574,27577,27589,27591,27602,27609,27611,27644,27660,27673,27681,27688,27701,27706,27709,27712,27714,27716,27718,27732,27737,27738,27748,27752,27753,27754,27772,27811,27827,27832,27833,27838,27839,27880,27905,27911,27920,27921,27923,27924,27926,27932,27938,27957,27966,27982,28005,28006,28019,28033,28036,28038,28048,28066,28102,28107,28114,28127,28128,28137,28141,28154,28176,28198,28211,28215,28223,28232,28235,28255,28274,28276,28287,28293,28303,28305,28308,28318,28323,28331,28339,28345,28352,28356,28358,28361,28362,28363,28367,28368,28375,28376,28430,28436,28460,28466,28467,28471,28474,28475,28479,28482,28484,28488,28489,28494,28496,28497,28506,28519,28525,28530,28557,28559,28563,28568,28575,28581,28611,28621,28650,28654,28665,28682,28730,28731,28763,28764,28771,28773,28799,28839,28863,28871,28872,28887,28894,28916,28924,28928,28933,28943,28950,28952,28972,28992,29012,29023,29057,29078,29172,29187,29210,29213,29223,29235,29244,29274,29284,29285,29307,29331,29341,29342,29358,29378,29379,29380,29396,29399,29413,29436,29438,29473,29474,29486,29500,29509,29510,29512,29520,29532,29541,29545,29546,29555,29560,29578,29579,29598,29602,29603,29608,29611,29612,29625,29626,29653,29663,29672,29720,29767,29777,29779,29794,29799,29812,29814,29818,29819,29832,29835,29846,29863,29864,29865,29896,29924,29934,29940,29966,29977,30093,30163,30168,30202,30251,30280,30284,30333,30351,30373,30382,30395,30405,30406,30413,30433,30434,30447,30450,30465,30484,30504,30515,30525,30569,30580,30608,30613,30638,30687,30689,30721,30739,30741,30763,30967,30994,31010,31016,31167,31174,31188,31207,31218,31235,31311,31312,31314,31315,31317,31331,31337,31345,31355,31394,31399,31402,31431,31471,31527,31530,31568,31577,31586,31613,31640,31679,31685,31697,31741,31760,31764,31820,31849,31863,31866,31890,31908,31931,31938,31939,31962,31982,32062,32069,32125,32172,32185,32225,32229,32239,32271,32374,32380,32397,32440,32441,32445,32494,32523,32548,32689,32693,32699,32776,32832,32855,32860,32870,32903,32915,32945,32973,32982,33092,33099,33106,33116,33143,33146,33150,33221,33254,33270,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,34163,34166,34171,34175,34191,34197,34204,34213,34226,34254,34257,34277,34308,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,34729,34731,34754,34759,34775,34776,34793,34802,34825,34830,34836,34857,34861,34961,34963,34981,35000,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,35468,35469,35484,35497,35507,35523,35526,35530,35546,35548,35550,35562,35565,35566,35575,35581,35614,35623,35628,35632,35633,35660,35661,35663,35667,35694,35710,35713,35727,35729,35744,35759,35762,35770,35777,35784,35814,35827,35841,35866,35878,35909,35915,35942,35950,35956,35969,35971,35975,35979,36035,36066,36069,36070,36094,36154,36157,36175,36176,36212,36216,36228,36249,36250,36258,36262,36279,36281,36321,36335,36336,36338,36347,36378,36428,36452,36625,36798,36803,36821,36859,36875,36889,36910,36949,37040,37062,37155,37197,37558,37560,37635,37652,38113,38382,38549,38666,38671,38689,38786,38806,38814,38846,38847,38850,38854,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,38960,38961,38963,38964,38973,38974,38986,38988,39063,39064,39127,39194,39283,39323,39333,39415,39443,39464,39465,39467,39483,39600,39666,39698,39710,39866,39889,39892,39942,39943,40110,40212,40224,40243,40259,40271,40332,40347,40355,40414,40453,40490,40515,40545,40554,40622,40629,40651,40664,40674,40684,40720,40728,40739,40746,40768,40773,40778,40780,40786,40809,40839,40860,40865,40875,40880,40887,40967,40972,40993,41000,41007,41039,41058,41064,41069,41076,41108,41153,41158,41163,41174,41200,41205,41217,41234,41239,41290,41292,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,41984,41985,41995,42023,42031,42034,42037,42049,42054,42079,42111,42133,42176,42190,42206,42231,42282,42287,42290,42313,42314,42325,42326,42350,42362,42367,42368,42389,42415,42453,42458,42480,42493,42514,42515,42532,42536,42540,42565,42570,42591,42623,42628,42650,42688,42693,42758,42847,42860,42883,42888,42891,42933,42940,42946,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,43537,43541,43554,43567,43572,43578,43584,43592,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,44291,44292,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,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 | 2931 | 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.26 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.51 ms |
System lock | 0.02 ms |
optimizing | 0.17 ms |
statistics | 4.33 ms |
preparing | 2.23 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.01 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 |