Tiempo de la consulta: 34.27 ms Después de la última consulta: 2.40 ms Consulta a la memoria: 2.182 MB memoria antes de la consulta: 4.483 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 03:18:09')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-08 03:18:09')
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(2,5,9,21,185,274,311,318,554,594,937,1066,1081,1106,1248,1252,1253,1255,1328,1330,1368,1476,1753,1785,1841,1852,1903,2033,2101,2125,2324,2394,2397,2432,2451,2469,2494,2506,2605,2654,2671,2688,2779,2780,2871,2964,3001,3110,3193,3202,3456,3468,3563,3704,3721,3750,3797,3854,3869,3872,3894,3920,3983,4069,4071,4101,4144,4227,4246,4247,4252,4339,4342,4467,4492,4581,4595,4809,4845,4882,4989,4995,5008,5049,5496,5512,5609,5628,5697,6065,6066,6209,6257,6280,6309,6354,6358,6369,6407,6464,6589,6608,6678,6709,6726,6762,6789,6807,6808,6835,6840,6863,7369,7393,7421,7439,7449,7480,7586,7620,7625,7659,7683,7828,7953,8003,8034,8114,8153,8179,8184,8267,8310,8373,8411,8449,8566,8610,8623,8721,8750,8794,8900,8993,9051,9057,9199,9236,9255,9382,9390,9495,9631,9684,9776,9815,9932,9999,10033,10054,10060,10111,10154,10175,10195,10246,10436,10477,10529,10609,10716,10736,10839,10926,10933,11187,11195,11379,11386,11461,11534,11761,11792,11795,11828,11884,11913,11930,11947,12014,12106,12205,12248,12253,12508,12594,12602,12722,12746,12933,12976,13006,13029,13107,13117,13128,13140,13173,13203,13231,13343,13363,13402,13431,13437,13439,13484,13544,13546,13557,13567,13573,13669,13703,13712,13861,13980,13991,14114,14161,14188,14270,14279,14283,14311,14400,14420,14467,14490,14583,14637,14672,14683,14711,14731,14765,14822,14835,14856,14932,14937,14938,15047,15109,15177,15297,15300,15357,15438,15456,15479,15489,15591,15642,15760,15896,15909,15932,15959,15973,15981,15988,16051,16090,16159,16201,16266,16289,16374,16423,16449,16452,16469,16478,16489,16539,16632,16638,16716,16734,16829,16836,16849,16859,16882,16913,16968,16977,17023,17099,17127,17146,17203,17258,17267,17285,17393,17403,17443,17493,17604,17718,17742,17784,17842,17872,17883,17900,17910,17952,17994,18201,18246,18249,18295,18354,18409,18431,18446,18521,18550,18660,18679,18707,18714,18739,18772,18833,18898,18993,19004,19046,19088,19093,19102,19115,19155,19158,19162,19207,19217,19227,19241,19340,19502,19598,19768,19815,19855,19867,19961,20133,20159,20217,20230,20259,20400,20414,20480,20511,20579,20677,20730,20757,20771,20796,20812,20849,21051,21069,21227,21383,21397,21559,21611,21743,21926,22019,22052,22092,22097,22113,22130,22202,22229,22261,22343,22391,22477,22488,22489,22625,22682,22828,22937,22975,23016,23360,23406,23570,23574,23647,23654,23715,23730,23737,23860,23866,24023,24136,24216,24270,24288,24312,24387,24388,24392,24407,24450,24462,24477,24479,24531,24565,24910,25133,25207,25222,25256,25278,25282,25340,25398,25409,25413,25417,25455,25550,25570,25580,25581,25609,25612,25621,25623,25631,25647,25659,25670,25703,25704,25717,25727,25733,25735,25736,25737,25740,25747,25771,25787,25801,25805,25816,25832,25833,25835,25845,25852,25860,25862,25896,25897,25905,25906,25943,25963,25964,25968,25969,25979,26017,26019,26028,26061,26070,26089,26090,26109,26123,26126,26139,26154,26155,26167,26171,26183,26195,26202,26238,26256,26261,26264,26310,26328,26333,26348,26353,26373,26378,26403,26404,26408,26410,26411,26418,26429,26433,26438,26439,26464,26468,26471,26479,26492,26499,26517,26529,26531,26532,26534,26549,26555,26558,26570,26584,26625,26670,26678,26679,26681,26692,26712,26714,26722,26724,26731,26733,26738,26751,26753,26758,26759,26761,26763,26766,26770,26775,26807,26808,26838,26846,26866,26873,26877,26885,26887,26891,26894,26905,26908,26910,26911,26945,26947,26950,26951,26956,26974,26980,26991,26992,27017,27018,27036,27039,27046,27053,27054,27066,27071,27110,27118,27120,27133,27138,27143,27145,27171,27178,27185,27189,27191,27219,27228,27235,27238,27266,27280,27287,27288,27292,27310,27311,27314,27322,27337,27338,27359,27362,27364,27375,27378,27383,27386,27406,27415,27416,27422,27430,27450,27453,27459,27465,27475,27485,27493,27499,27509,27535,27548,27549,27550,27574,27576,27580,27606,27607,27610,27615,27632,27644,27684,27691,27700,27713,27715,27716,27722,27727,27731,27733,27734,27767,27772,27773,27779,27800,27833,27835,27837,27846,27859,27881,27916,27928,27944,27947,27963,27972,27974,27976,28012,28034,28037,28039,28044,28060,28061,28062,28074,28081,28086,28096,28099,28100,28123,28126,28170,28180,28181,28189,28191,28228,28231,28233,28288,28306,28310,28311,28313,28318,28320,28348,28350,28352,28364,28379,28381,28386,28401,28404,28418,28439,28451,28464,28469,28471,28486,28492,28503,28509,28515,28528,28558,28567,28572,28588,28603,28604,28630,28644,28645,28650,28659,28665,28672,28700,28701,28708,28716,28719,28737,28743,28760,28766,28768,28779,28802,28804,28805,28819,28831,28838,28875,28881,28883,28888,28890,28898,28905,28926,28934,28938,28940,28956,28963,28965,28974,28975,28977,28986,28987,28990,28991,28996,29020,29045,29054,29068,29070,29080,29081,29100,29109,29112,29115,29125,29131,29150,29167,29170,29174,29179,29187,29190,29200,29207,29225,29231,29232,29236,29239,29245,29246,29252,29254,29267,29268,29273,29276,29292,29296,29304,29306,29313,29314,29324,29330,29334,29336,29338,29340,29344,29356,29364,29366,29368,29370,29375,29380,29393,29402,29403,29410,29414,29424,29442,29446,29477,29479,29501,29506,29509,29521,29522,29542,29544,29548,29554,29555,29556,29580,29581,29583,29593,29595,29597,29600,29603,29605,29606,29649,29651,29652,29667,29670,29673,29676,29677,29685,29687,29689,29703,29704,29710,29729,29730,29732,29733,29735,29754,29755,29762,29784,29818,29819,29820,29838,29842,29843,29845,29859,29864,29871,29878,29879,29880,29882,29897,29900,29913,29916,29922,29949,29950,29952,29958,29980,30014,30019,30020,30021,30059,30085,30094,30096,30105,30122,30165,30178,30198,30243,30244,30246,30299,30331,30344,30368,30370,30384,30396,30411,30426,30460,30462,30505,30544,30556,30577,30579,30595,30609,30626,30669,30685,30689,30747,30753,30755,30773,30776,30778,30794,30798,30804,30820,30821,30827,30854,30861,30881,30902,30908,30952,30968,31005,31011,31016,31025,31072,31115,31121,31138,31170,31191,31194,31208,31209,31213,31214,31215,31269,31277,31308,31309,31348,31349,31376,31393,31423,31427,31429,31438,31439,31471,31501,31538,31546,31547,31548,31549,31562,31588,31625,31656,31660,31672,31677,31678,31681,31689,31691,31692,31709,31771,31790,31816,31817,31823,31826,31832,31841,31851,31874,31877,31879,31937,31941,31943,31944,31996,31997,31999,32003,32004,32012,32023,32032,32045,32063,32099,32108,32117,32139,32144,32180,32213,32218,32238,32246,32253,32261,32262,32263,32270,32295,32303,32305,32323,32325,32327,32329,32376,32402,32406,32412,32433,32435,32442,32511,32512,32520,32522,32524,32525,32529,32530,32533,32550,32570,32578,32624,32658,32671,32685,32702,32717,32729,32730,32793,32800,32803,32805,32806,32807,32810,32855,32868,32914,32919,32923,32974,32981,33004,33008,33010,33012,33013,33016,33017,33019,33020,33030,33042,33043,33045,33048,33063,33064,33067,33088,33102,33104,33122,33132,33133,33136,33142,33144,33147,33177,33226,33288,33333,33344,33376,33379,33431,33439,33458,33459,33460,33476,33510,33511,33516,33525,33527,33544,33552,33568,33572,33582,33583,33588,33604,33609,33621,33642,33694,33703,33709,33757,33768,33774,33777,33790,33805,33806,33807,33809,33810,33811,33812,33813,33814,33834,33866,33894,33916,33918,33950,33958,33959,34005,34023,34026,34042,34059,34065,34103,34116,34137,34160,34162,34165,34199,34211,34217,34225,34237,34238,34245,34246,34248,34264,34271,34282,34289,34297,34306,34309,34314,34322,34337,34350,34378,34402,34410,34413,34414,34427,34428,34431,34433,34435,34437,34440,34444,34454,34456,34461,34462,34469,34483,34486,34509,34512,34515,34521,34524,34535,34549,34558,34576,34578,34584,34597,34598,34599,34602,34606,34613,34614,34615,34617,34619,34625,34627,34642,34650,34654,34657,34665,34671,34673,34674,34676,34678,34682,34701,34707,34719,34723,34725,34733,34739,34740,34745,34747,34753,34756,34758,34759,34763,34770,34778,34788,34801,34818,34819,34834,34837,34839,34846,34856,34865,34868,34869,34870,34871,34875,34890,34903,34905,34920,34925,34926,34927,34931,34932,34934,34938,34956,34961,34963,34965,34966,34971,34980,34991,34994,34996,34998,35008,35014,35020,35026,35027,35041,35049,35052,35056,35063,35070,35081,35082,35083,35085,35086,35090,35109,35121,35124,35125,35126,35129,35146,35150,35151,35152,35154,35160,35166,35170,35172,35192,35194,35199,35203,35204,35212,35213,35214,35215,35226,35230,35243,35248,35255,35258,35259,35276,35299,35305,35306,35307,35319,35320,35326,35332,35337,35346,35347,35348,35379,35381,35394,35398,35408,35412,35415,35418,35430,35438,35442,35455,35459,35464,35470,35486,35495,35501,35502,35511,35512,35515,35518,35544,35547,35552,35560,35563,35567,35582,35583,35596,35599,35601,35625,35630,35641,35644,35650,35651,35652,35677,35678,35680,35686,35694,35695,35697,35706,35708,35718,35742,35756,35764,35766,35772,35773,35780,35790,35794,35796,35801,35806,35815,35816,35819,35825,35836,35839,35845,35855,35859,35865,35867,35888,35890,35893,35907,35908,35911,35912,35913,35914,35919,35920,35925,35939,35940,35951,35958,35974,35977,35981,35984,35996,35998,35999,36005,36011,36022,36030,36034,36038,36040,36044,36047,36062,36069,36080,36085,36096,36098,36099,36110,36120,36126,36130,36131,36142,36147,36153,36155,36158,36159,36170,36173,36184,36186,36194,36197,36200,36207,36209,36211,36215,36227,36237,36241,36244,36246,36248,36249,36257,36260,36271,36272,36273,36278,36281,36287,36288,36290,36292,36297,36305,36307,36309,36312,36318,36327,36330,36331,36337,36351,36352,36357,36358,36377,36381,36388,36395,36413,36414,36418,36430,36434,36438,36440,36441,36443,36444,36449,36451,36468,36473,36478,36483,36485,36487,36490,36504,36507,36508,36509,36510,36511,36514,36517,36518,36525,36530,36533,36539,36545,36551,36559,36563,36568,36588,36597,36599,36607,36614,36621,36641,36644,36653,36660,36671,36675,36693,36708,36712,36717,36718,36719,36743,36745,36746,36748,36749,36751,36770,36779,36780,36782,36783,36786,36808,36809,36810,36814,36817,36824,36830,36841,36848,36873,36895,36898,36904,36905,36911,36913,36914,36915,36923,36924,36927,36934,36936,36939,36961,36967,36975,36976,36995,37005,37007,37013,37014,37017,37025,37028,37034,37040,37042,37062,37063,37070,37076,37078,37080,37087,37091,37099,37112,37114,37116,37118,37119,37148,37150,37153,37167,37170,37172,37204,37230,37235,37255,37259,37260,37299,37303,37309,37316,37324,37376,37398,37400,37403,37406,37429,37439,37453,37454,37477,37479,37496,37514,37516,37517,37519,37540,37588,37589,37591,37596,37605,37618,37619,37624,37630,37636,37637,37663,37666,37667,37683,37685,37703,37706,37711,37713,37729,37731,37732,37742,37745,37752,37754,37761,37789,37792,37793,37794,37802,37807,37821,37827,37841,37852,37873,37884,37885,37893,37896,37897,37898,37900,37909,37919,37923,37936,37955,37958,37966,37973,37974,37975,37991,38002,38005,38006,38012,38013,38014,38024,38025,38026,38027,38043,38070,38088,38092,38093,38103,38108,38110,38111,38112,38114,38119,38122,38128,38134,38140,38141,38159,38161,38166,38173,38175,38179,38183,38189,38190,38191,38193,38194,38198,38202,38214,38216,38219,38221,38228,38235,38248,38252,38253,38254,38283,38284,38285,38292,38305,38310,38313,38314,38315,38319,38334,38339,38340,38349,38394,38396,38398,38419,38435,38440,38446,38447,38450,38471,38476,38500,38502,38530,38548,38576,38584,38591,38594,38600,38632,38654,38658,38659,38662,38674,38690,38711,38757,38779,38784,38788,38815,38830,38839,38879,38905,38917,38918,38950,38982,38983,38994,38998,39005,39013,39018,39020,39027,39046,39059,39087,39101,39131,39150,39167,39176,39245,39250,39252,39261,39276,39279,39281,39294,39296,39342,39347,39360,39365,39367,39374,39375,39389,39391,39407,39444,39455,39496,39498,39500,39510,39556,39557,39575,39599,39604,39609,39622,39623,39629,39650,39659,39661,39679,39712,39722,39747,39749,39768,39780,39781,39791,39802,39818,39823,39835,39864,39866,39883,39888,39909,39924,39948,39998,40001,40018,40024,40043,40068,40072,40090,40091,40108,40129,40150,40155,40177,40182,40192,40227,40231,40250,40252,40258,40274,40276,40309,40330,40340,40376,40398,40399,40416,40420,40421,40423,40430,40431,40432,40436,40437,40438,40442,40443,40447,40458,40460,40467,40470,40473,40485,40497,40501,40510,40514,40519,40520,40521,40522,40535,40537,40550,40553,40556,40564,40570,40586,40587,40588,40609,40610,40611,40614,40617,40631,40634,40654,40667,40668,40670,40688,40689,40692,40699,40705,40738,40748,40794,40805,40820,40823,40827,40831,40848,40881,40883,40884,40886,40892,40894,40903,40923,40925,40931,40936,40954,40957,40958,40959,40981,40988,41000,41010,41011,41014,41021,41028,41040,41054,41055,41066,41068,41087,41139,41141,41143,41204,41220,41228,41232,41242,41250,41251,41261,41266,41286,41287,41288,41298,41321,41341,41345,41359,41404,41405,41418,41427,41430,41435,41436,41448,41454,41461,41484,41496,41497,41498,41521,41529,41547,41555,41568,41570,41573,41576,41582,41583,41592,41594,41595,41599,41624,41635,41649,41650,41653,41660,41670,41683,41693,41694,41709,41717,41724,41728,41729,41730,41731,41751,41753,41764,41771,41777,41782,41800,41806,41807,41833,41834,41839,41852,41865,41871,41877,41879,41888,41906,41918,41927,41931,41950,41956,41957,41967,41978,41979,41984,41985,41992,42004,42012,42013,42014,42030,42040,42042,42048,42057,42061,42065,42084,42085,42093,42117,42144,42147,42149,42150,42154,42155,42163,42164,42174,42178,42188,42201,42204,42207,42212,42214,42215,42218,42256,42262,42265,42273,42281,42292,42300,42301,42314,42327,42328,42366,42405,42414,42431,42439,42440,42441,42447,42448,42451,42471,42474,42485,42488,42490,42496,42509,42511,42515,42517,42526,42529,42542,42543,42549,42573,42578,42579,42583,42589,42593,42601,42608,42617,42652,42659,42686,42689,42691,42704,42714,42729,42732,42741,42749,42753,42764,42787,42806,42810,42837,42856,42863,42875,42880,42888,42894,42913,42923,42934,42945,42947,42960,42975,42976,42997,43001,43009,43023,43024,43034,43040,43041,43042,43057,43059,43073,43081,43085,43088,43092,43108,43115,43143,43145,43148,43160,43168,43171,43172,43175,43187,43195,43196,43198,43202,43203,43205,43210,43211,43212,43220,43222,43229,43234,43244,43251,43252,43259,43267,43272,43273,43275,43282,43290,43292,43294,43296,43297,43323,43324,43325,43327,43341,43345,43366,43367,43368,43376,43377,43378,43387,43389,43407,43409,43417,43427,43428,43429,43433,43441,43449,43457,43458,43459,43460,43473,43474,43487,43499,43500,43501,43503,43508,43509,43530,43534,43539,43542,43550,43564,43574,43579,43590,43600,43601,43605,43606,43610,43615,43624,43646,43657,43663,43666,43673,43682,43686,43687,43715,43721,43727,43733,43734,43741,43744,43745,43746,43747,43757,43767,43777,43789,43791,43794,43806,43807,43813,43822,43829,43833,43838,43844,43846,43852,43859,43860,43861,43863,43866,43868,43872,43875,43889,43901,43918,43920,43935,43965,43970,43971,43975,43976,43979,43987,44000,44001,44008,44021,44022,44026,44039,44040,44044,44047,44048,44064,44093,44099,44124,44125,44132,44155,44156,44157,44164,44179,44225,44240,44243,44244,44257,44262,44299,44313,44323,44326,44333,44340,44346,44351,44365,44367,44371,44381,44390,44397,44400,44405,44409,44412,44417,44424,44431,44434,44438,44441,44442,44448,44450,44455,44465,44470,44477,44482,44484,44486,44490,44491,44492,44496,44498,44501,44502,44503,44505,44547,44548,44565,44570,44578,44579,44582,44586,44588,44597,44606,44607,44608,44611,44613,44616,44621,44623,44625,44637,44639,44643,44644,44651,44655,44669,44679,44691,44693,44695,44698,44701,44709,44723,44724,44729,44740,44741,44744,44750,44754,44756,44766,44770,44773,44779,44789,44790,44791,44795,44808,44810,44816,44818,44819,44828,44836,44853,44862,44864,44869,44875,44878,44894,44902,44909,44913,44920,44924,44925,44929,44937,44941,44942,44945,44955,44966,44970,44975,44980,44986,44991,44997,45002,45013,45019,45044,45051,45052,45053,45054,45070,45078,45085,45107,45110,45113,45118,45120,45122,45147,45153,45157,45161,45163,45166,45182,45187,45191,45200,45201,45212,45214,45229,45230,45234,45240,45241,45246,45251,45266,45283,45287,45302,45303,45306)
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 | 2649 | 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.99 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.06 ms |
init | 0.67 ms |
System lock | 0.04 ms |
optimizing | 0.33 ms |
statistics | 6.55 ms |
preparing | 3.13 ms |
Sorting result | 0.02 ms |
executing | 0.05 ms |
Sending data | 20.33 ms |
end | 0.03 ms |
query end | 0.05 ms |
closing tables | 0.06 ms |
freeing items | 0.15 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 |