Tiempo de la consulta: 47.54 ms Después de la última consulta: 2.71 ms Consulta a la memoria: 7.401 MB memoria antes de la consulta: 4.448 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 04:21:31')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-08 04:21:31')
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(1,14,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,44,45,46,47,48,49,50,51,52,53,56,57,58,59,61,71,72,75,83,127,131,133,134,135,136,137,138,148,165,174,175,180,190,200,204,205,206,222,225,247,250,253,255,263,271,272,282,294,308,321,323,324,325,327,329,334,353,368,370,385,387,388,390,392,393,395,397,398,400,402,403,404,405,408,410,411,433,435,436,437,438,442,443,445,448,451,452,454,455,456,458,459,460,462,474,481,484,485,489,497,505,507,511,512,520,527,529,531,537,542,547,550,551,560,566,567,583,589,607,608,609,611,622,633,667,669,672,681,686,701,705,708,709,710,711,712,713,723,733,756,760,771,776,783,796,797,801,802,805,806,816,850,856,858,861,864,882,886,889,892,895,897,905,907,917,922,924,928,933,952,955,961,968,973,977,983,986,1018,1021,1031,1033,1036,1040,1044,1047,1059,1062,1078,1080,1087,1105,1112,1124,1130,1133,1134,1169,1183,1185,1198,1204,1205,1207,1226,1233,1236,1238,1248,1252,1253,1265,1277,1285,1290,1317,1329,1330,1339,1347,1353,1401,1402,1434,1476,1491,1538,1539,1554,1555,1563,1587,1594,1600,1612,1617,1664,1683,1697,1698,1712,1717,1744,1750,1768,1770,1784,1787,1788,1808,1813,1835,1849,1917,1949,1964,1999,2024,2043,2102,2150,2162,2181,2195,2250,2290,2293,2338,2353,2371,2394,2433,2482,2485,2552,2569,2570,2633,2637,2688,2726,2732,2733,2739,2755,2758,2759,2780,2788,2797,2859,2875,2964,3071,3082,3085,3089,3099,3126,3193,3208,3251,3259,3271,3279,3299,3306,3353,3379,3409,3425,3442,3491,3495,3520,3592,3607,3626,3634,3653,3668,3684,3696,3769,3825,3832,3837,3869,3873,3884,3898,3932,3940,3951,3963,3984,3988,3993,4004,4029,4046,4063,4082,4092,4116,4153,4249,4263,4309,4355,4378,4409,4410,4434,4436,4445,4452,4453,4471,4502,4515,4516,4560,4580,4583,4631,4640,4641,4688,4692,4710,4765,4780,4801,4808,4854,4880,4901,4931,4973,4992,5001,5051,5063,5084,5085,5136,5154,5176,5183,5190,5195,5227,5263,5292,5328,5333,5363,5365,5451,5472,5480,5515,5529,5564,5575,5576,5632,5634,5646,5647,5648,5660,5680,5694,5700,5726,5727,5730,5757,5785,5798,5811,5833,5870,5894,5895,5904,5994,6021,6062,6068,6141,6150,6186,6215,6221,6245,6254,6270,6278,6279,6315,6339,6367,6381,6393,6395,6415,6448,6463,6470,6473,6475,6476,6477,6498,6501,6503,6534,6546,6548,6577,6598,6600,6604,6605,6616,6643,6666,6669,6673,6681,6684,6686,6688,6691,6708,6744,6752,6764,6775,6783,6793,6799,6806,6809,6828,6834,6857,6884,6888,6889,6908,6913,6916,6923,6939,6941,6942,6960,6965,6994,7012,7014,7023,7053,7054,7056,7101,7105,7121,7153,7172,7173,7175,7185,7194,7212,7243,7245,7248,7269,7273,7276,7291,7343,7348,7368,7374,7405,7407,7413,7418,7421,7443,7451,7461,7462,7463,7484,7486,7492,7499,7516,7546,7551,7567,7589,7591,7594,7595,7596,7597,7615,7618,7621,7644,7652,7707,7711,7718,7719,7720,7722,7730,7741,7744,7751,7761,7797,7801,7802,7804,7837,7840,7950,7955,7965,7966,7967,7980,7981,7987,7994,7996,8022,8027,8053,8054,8073,8106,8148,8161,8177,8188,8250,8258,8296,8325,8328,8351,8387,8390,8404,8406,8417,8440,8442,8445,8447,8492,8505,8506,8551,8565,8566,8568,8587,8610,8613,8663,8679,8689,8692,8716,8728,8760,8852,8864,8909,8910,8939,8950,9004,9011,9073,9091,9109,9155,9193,9218,9239,9252,9253,9257,9351,9412,9416,9472,9473,9501,9525,9531,9532,9573,9580,9620,9648,9708,9734,9745,9747,9757,9766,9772,9779,9792,9820,9831,9840,9889,9924,9934,9945,10008,10024,10050,10051,10077,10079,10092,10120,10129,10180,10197,10198,10216,10237,10248,10260,10266,10278,10282,10290,10298,10303,10348,10350,10354,10364,10369,10385,10414,10415,10449,10478,10486,10494,10499,10518,10530,10554,10557,10563,10666,10686,10690,10731,10765,10806,10818,10831,10857,10869,10888,10900,10912,10927,10942,10955,10967,10971,11006,11062,11080,11087,11091,11114,11123,11182,11198,11206,11273,11290,11320,11328,11330,11374,11388,11417,11419,11432,11438,11441,11447,11468,11471,11487,11494,11542,11552,11560,11651,11662,11672,11685,11692,11709,11753,11762,11840,11848,11857,11880,11900,11925,11965,12024,12025,12032,12079,12080,12108,12113,12126,12162,12168,12186,12204,12213,12216,12237,12248,12251,12281,12297,12338,12362,12363,12366,12369,12387,12410,12415,12430,12439,12443,12463,12474,12475,12477,12482,12490,12493,12509,12557,12564,12567,12608,12615,12624,12625,12628,12663,12668,12672,12685,12714,12723,12745,12750,12757,12786,12808,12810,12868,12887,12892,12902,12913,12920,12926,12935,12963,12965,12973,12977,12983,12999,13004,13014,13020,13036,13044,13079,13143,13152,13176,13190,13191,13209,13235,13246,13259,13269,13277,13279,13287,13297,13309,13317,13318,13348,13364,13387,13420,13434,13436,13456,13543,13553,13560,13573,13579,13600,13609,13621,13631,13635,13646,13651,13662,13673,13674,13695,13702,13707,13710,13713,13715,13718,13722,13725,13729,13775,13838,13860,13867,13900,13920,13929,13933,13959,13985,13986,13994,14005,14011,14014,14052,14061,14062,14069,14083,14109,14134,14139,14149,14183,14184,14186,14197,14205,14226,14227,14232,14252,14264,14273,14282,14290,14302,14338,14339,14348,14368,14393,14408,14417,14426,14434,14451,14456,14471,14486,14508,14516,14548,14557,14583,14591,14596,14600,14602,14610,14620,14624,14625,14652,14657,14675,14684,14687,14688,14692,14694,14701,14722,14769,14774,14778,14794,14796,14800,14815,14840,14860,14862,14864,14884,14892,14895,14906,14926,14930,14941,14954,14979,14980,15027,15028,15031,15032,15038,15065,15108,15109,15114,15120,15144,15147,15196,15215,15223,15227,15243,15245,15250,15256,15261,15263,15266,15297,15304,15323,15356,15370,15392,15402,15411,15430,15439,15441,15445,15450,15455,15464,15475,15476,15477,15484,15485,15489,15497,15500,15521,15523,15548,15551,15562,15563,15566,15583,15588,15596,15601,15604,15615,15632,15633,15640,15664,15670,15674,15703,15706,15709,15725,15728,15747,15755,15760,15763,15766,15782,15789,15832,15837,15841,15863,15866,15873,15877,15884,15890,15892,15893,15901,15904,15909,15913,15916,15917,15945,15955,15964,15966,15972,15991,15999,16005,16014,16020,16029,16037,16050,16053,16054,16059,16088,16093,16125,16140,16148,16153,16157,16166,16176,16187,16192,16195,16202,16257,16277,16311,16313,16320,16323,16342,16349,16359,16369,16370,16375,16410,16417,16451,16470,16481,16488,16507,16508,16513,16539,16542,16550,16554,16555,16558,16589,16605,16607,16609,16619,16620,16635,16641,16642,16644,16663,16678,16691,16698,16706,16712,16717,16722,16739,16815,16817,16825,16829,16831,16843,16845,16863,16867,16872,16876,16877,16891,16894,16909,16928,16936,16940,16964,16968,16996,17001,17005,17014,17043,17048,17059,17064,17071,17104,17114,17115,17117,17128,17131,17132,17139,17142,17149,17153,17169,17177,17184,17186,17189,17194,17209,17232,17243,17244,17248,17251,17257,17277,17280,17287,17291,17299,17300,17307,17322,17328,17336,17337,17339,17341,17354,17360,17364,17373,17381,17392,17403,17407,17417,17420,17424,17427,17432,17437,17438,17450,17458,17463,17464,17465,17493,17500,17513,17517,17533,17543,17552,17557,17569,17592,17596,17597,17598,17608,17611,17617,17622,17623,17626,17629,17630,17631,17650,17688,17689,17690,17695,17703,17729,17730,17746,17747,17748,17751,17752,17753,17759,17766,17772,17775,17781,17782,17784,17785,17786,17788,17808,17824,17852,17862,17870,17875,17889,17890,17895,17907,17908,17912,17918,17924,17952,17954,17978,17980,17981,17987,17990,17997,18001,18003,18004,18007,18019,18027,18031,18038,18042,18057,18068,18072,18074,18076,18078,18100,18107,18116,18134,18140,18141,18158,18160,18169,18176,18193,18200,18202,18203,18211,18212,18216,18217,18235,18239,18260,18262,18263,18290,18300,18304,18311,18314,18316,18322,18331,18337,18352,18355,18361,18368,18382,18384,18402,18403,18415,18419,18422,18425,18427,18430,18431,18436,18440,18447,18455,18464,18467,18481,18482,18485,18492,18493,18498,18503,18507,18514,18520,18524,18527,18534,18542,18543,18547,18552,18562,18564,18565,18566,18569,18576,18581,18586,18587,18591,18602,18619,18620,18622,18642,18644,18646,18647,18648,18649,18659,18668,18676,18679,18687,18702,18705,18716,18738,18761,18764,18765,18778,18781,18791,18793,18800,18801,18808,18809,18835,18837,18839,18847,18850,18853,18879,18880,18891,18898,18914,18930,18931,18937,18946,18951,18957,18978,18980,18986,18991,18997,19013,19048,19049,19053,19054,19059,19060,19063,19065,19073,19078,19083,19093,19120,19134,19145,19168,19180,19184,19188,19196,19208,19216,19217,19218,19219,19222,19237,19249,19251,19270,19271,19276,19290,19292,19293,19302,19303,19304,19313,19316,19318,19329,19331,19340,19364,19377,19383,19411,19413,19415,19419,19427,19429,19433,19437,19439,19440,19448,19453,19455,19457,19473,19481,19484,19494,19497,19504,19505,19514,19518,19519,19522,19526,19535,19545,19552,19553,19554,19556,19562,19565,19566,19575,19578,19580,19586,19587,19593,19595,19596,19604,19606,19612,19623,19625,19645,19646,19651,19652,19655,19664,19665,19670,19682,19699,19700,19703,19705,19718,19720,19730,19733,19741,19755,19759,19763,19766,19778,19779,19801,19805,19806,19811,19820,19826,19841,19864,19894,19942,19953,19955,19970,19973,19983,19987,19999,20002,20007,20012,20016,20023,20027,20029,20042,20045,20048,20054,20083,20091,20094,20100,20104,20117,20130,20133,20137,20146,20153,20154,20155,20160,20167,20181,20182,20199,20204,20208,20209,20226,20229,20236,20254,20271,20276,20278,20279,20295,20303,20315,20329,20332,20349,20352,20362,20366,20384,20393,20403,20422,20425,20427,20432,20468,20472,20479,20510,20524,20543,20559,20570,20574,20577,20585,20595,20605,20621,20630,20643,20649,20677,20684,20691,20710,20714,20721,20724,20726,20738,20744,20748,20753,20761,20765,20767,20769,20774,20776,20795,20799,20800,20807,20809,20817,20824,20826,20835,20858,20876,20880,20885,20890,20896,20906,20915,20933,20935,20940,20948,20950,20960,20969,20980,20991,20992,20996,21017,21035,21040,21042,21061,21064,21068,21073,21075,21089,21093,21105,21110,21115,21116,21129,21133,21136,21149,21152,21156,21171,21181,21184,21188,21198,21200,21213,21227,21242,21248,21251,21264,21274,21280,21289,21291,21293,21302,21309,21310,21326,21331,21335,21341,21349,21357,21361,21366,21378,21388,21403,21412,21414,21415,21421,21429,21430,21452,21455,21459,21465,21472,21481,21494,21502,21518,21528,21538,21539,21540,21552,21565,21576,21583,21586,21603,21604,21606,21609,21611,21622,21632,21644,21645,21647,21652,21659,21662,21668,21669,21687,21702,21709,21711,21714,21728,21729,21734,21748,21749,21763,21766,21770,21775,21777,21781,21782,21801,21819,21826,21830,21844,21849,21851,21864,21871,21895,21908,21916,21922,21930,21952,21984,21986,21995,22021,22029,22036,22038,22045,22048,22055,22058,22065,22066,22072,22074,22087,22089,22099,22110,22126,22153,22166,22177,22191,22192,22216,22223,22225,22238,22244,22245,22246,22248,22260,22268,22286,22289,22294,22295,22299,22309,22315,22321,22327,22334,22336,22342,22345,22350,22356,22366,22371,22377,22378,22382,22385,22388,22395,22402,22411,22419,22422,22428,22431,22438,22458,22476,22477,22500,22502,22503,22507,22509,22520,22530,22534,22537,22543,22556,22559,22587,22589,22594,22602,22607,22621,22623,22666,22693,22702,22704,22708,22709,22715,22723,22736,22738,22740,22741,22753,22761,22766,22786,22792,22793,22804,22827,22843,22850,22854,22875,22876,22878,22888,22891,22893,22899,22903,22906,22920,22921,22922,22924,22927,22931,22932,22933,22934,22935,22943,22962,22967,22976,22978,22988,23002,23004,23006,23015,23017,23019,23023,23027,23028,23032,23042,23050,23063,23064,23073,23077,23080,23082,23084,23090,23102,23103,23106,23107,23110,23116,23119,23122,23126,23131,23134,23136,23145,23151,23153,23166,23174,23178,23196,23210,23213,23215,23219,23229,23236,23258,23260,23269,23271,23273,23287,23295,23299,23312,23317,23319,23332,23338,23343,23353,23354,23364,23365,23373,23380,23382,23396,23397,23409,23411,23412,23417,23424,23426,23428,23430,23434,23441,23445,23457,23460,23466,23469,23477,23481,23489,23495,23503,23505,23512,23518,23520,23524,23531,23541,23543,23544,23548,23567,23569,23575,23592,23594,23607,23613,23633,23634,23645,23646,23649,23651,23652,23657,23659,23665,23666,23668,23672,23677,23685,23693,23695,23708,23711,23719,23722,23729,23732,23740,23749,23761,23768,23776,23782,23792,23793,23806,23811,23815,23816,23827,23828,23850,23855,23859,23861,23866,23869,23872,23874,23894,23899,23906,23914,23952,23958,23965,23967,23973,23984,23987,23995,23998,24001,24002,24059,24068,24088,24105,24108,24111,24134,24135,24137,24154,24158,24166,24171,24176,24189,24195,24198,24202,24207,24212,24229,24233,24258,24260,24273,24282,24289,24299,24315,24332,24336,24365,24368,24373,24375,24380,24391,24431,24437,24438,24439,24442,24445,24447,24470,24475,24498,24511,24518,24527,24536,24543,24565,24607,24608,24612,24617,24625,24636,24642,24658,24659,24665,24672,24710,24713,24718,24719,24722,24725,24754,24765,24780,24784,24790,24806,24814,24819,24823,24838,24843,24851,24853,24857,24868,24881,24882,24905,24922,24924,24927,24942,24944,24954,24958,24960,24964,24974,24986,24995,24998,25014,25022,25033,25039,25048,25061,25064,25082,25090,25093,25104,25116,25119,25131,25134,25141,25143,25155,25170,25183,25193,25195,25199,25200,25205,25207,25252,25260,25268,25271,25281,25312,25314,25316,25342,25345,25349,25353,25356,25365,25366,25379,25394,25397,25415,25417,25421,25435,25449,25470,25471,25474,25486,25488,25490,25502,25506,25512,25528,25541,25548,25553,25557,25595,25599,25609,25615,25616,25621,25623,25626,25635,25648,25650,25668,25693,25703,25707,25717,25725,25735,25742,25745,25749,25768,25778,25782,25797,25833,25834,25847,25866,25870,25886,25944,25958,25969,26020,26028,26043,26048,26090,26101,26103,26132,26140,26154,26159,26165,26166,26178,26179,26197,26205,26215,26218,26238,26246,26249,26255,26257,26281,26282,26293,26305,26317,26323,26324,26328,26338,26360,26363,26369,26375,26389,26398,26405,26412,26431,26450,26464,26479,26508,26513,26541,26548,26564,26570,26574,26577,26589,26590,26591,26599,26605,26612,26636,26637,26646,26654,26672,26706,26726,26742,26744,26772,26776,26779,26792,26824,26835,26842,26843,26846,26857,26860,26864,26874,26885,26897,26905,26909,26916,26918,26919,26933,26939,26941,26944,26945,26947,26954,26959,26967,27000,27008,27015,27020,27024,27030,27055,27059,27076,27083,27084,27087,27091,27093,27101,27104,27130,27131,27142,27143,27149,27164,27174,27184,27197,27248,27293,27294,27295,27305,27356,27362,27363,27420,27438,27453,27457,27458,27477,27482,27488,27497,27518,27526,27552,27566,27572,27574,27582,27584,27632,27646,27707,27717,27720,27724,27726,27737,27761,27786,27805,27809,27820,27822,27832,27833,27846,27855,27878,27892,27911,27918,27921,27923,27924,27926,27934,27938,27949,27951,27952,27978,27991,27999,28005,28033,28078,28107,28114,28128,28157,28169,28208,28303,28316,28318,28349,28372,28419,28436,28559,28600,28614,28615,28621,28643,28714,28763,28764,28771,28773,28845,28872,28889,28910,28922,28925,28943,28950,28992,29012,29023,29054,29088,29123,29172,29210,29223,29235,29244,29286,29290,29358,29372,29378,29380,29438,29459,29464,29466,29469,29486,29499,29509,29510,29512,29540,29584,29611,29625,29641,29653,29777,29814,29832,29834,29846,29849,29863,29864,29909,30111,30280,30433,30434,30484,30621,30676,30805,30932,30940,31437,31560,31640,31663,31697,31890,31908,31937,32136,32304,32579,32592,32796,33270,33932,34160,34428,34565,34795,34850,34859,34876,34923,34949,35000,35195,35373,35474,35503,35521,35628,35632,35638,35660,35661,35667,35713,35719,35727,35730,35741,35744,35759,35777,35783,35784,35803,35805,35811,35812,35814,35850,35861,35877,35882,35909,35921,35926,35953,35989,36017,36041,36108,36158,36160,36174,36178,36222,36235,36310,36410,36411,36439,36450,36479,36633,36780,36798,36804,36821,36889,36893,36949,36958,37497,37649,37690,37901,37942,38029,38314,38357,38387,38631,38668,38748,38800,38816,38817,38833,38845,38852,38884,38885,38887,38897,38898,38916,38932,38960,38985,38987,39062,39107,39178,39242,39271,39283,39318,39333,39342,39369,39432,39464,39465,39483,39527,39588,39600,39612,39614,39645,39653,39698,39710,39820,39858,39866,39886,39941,39972,39998,40015,40048,40050,40064,40110,40116,40214,40218,40224,40237,40259,40332,40355,40414,40490,40515,40588,40651,40672,40684,40706,40786,40861,40875,40877,40905,41058,41069,41156,41239,41292,41296,41337,41363,41376,41532,41794,41909,42181,42202,42445,42502,42503,42844,43178,43305,43710,43711,44277,44288,45268,45269,45270)
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 | 2826 | 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.48 ms |
System lock | 0.02 ms |
optimizing | 0.18 ms |
statistics | 4.21 ms |
preparing | 2.20 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 37.95 ms |
end | 0.03 ms |
query end | 0.05 ms |
closing tables | 0.02 ms |
freeing items | 0.19 ms |
cleaning up | 0.05 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 |