Tiempo de la consulta: 15.63 ms Después de la última consulta: 2.51 ms Consulta a la memoria: 1.276 MB memoria antes de la consulta: 4.602 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 15:25:30')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-08 15:25:30')
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(13,21,29,30,51,58,64,80,82,113,152,153,157,174,183,184,193,197,206,218,226,257,267,275,280,291,311,318,328,350,371,385,393,401,407,440,466,468,471,482,499,535,543,560,610,615,619,635,643,661,667,680,685,692,693,700,703,709,713,733,736,740,761,772,783,786,790,802,832,859,868,902,918,935,940,941,960,968,974,977,984,988,991,998,1001,1022,1024,1032,1034,1042,1048,1073,1079,1085,1098,1104,1106,1127,1138,1142,1150,1151,1158,1167,1172,1192,1194,1205,1220,1226,1231,1255,1257,1269,1271,1279,1280,1295,1305,1308,1322,1349,1352,1354,1357,1375,1391,1409,1420,1421,1433,1435,1440,1441,1444,1445,1447,1454,1455,1460,1466,1476,1481,1484,1498,1513,1533,1535,1553,1563,1573,1586,1595,1603,1624,1634,1643,1646,1664,1693,1713,1743,1753,1760,1781,1785,1800,1802,1805,1809,1811,1812,1822,1828,1841,1852,1855,1870,1900,1903,1906,1913,1915,1932,1959,1984,2001,2020,2077,2121,2122,2148,2156,2177,2193,2199,2210,2217,2223,2282,2301,2305,2310,2337,2346,2359,2367,2378,2389,2408,2424,2428,2432,2451,2465,2469,2479,2480,2491,2525,2598,2600,2601,2613,2629,2631,2632,2636,2668,2685,2689,2691,2773,2792,2794,2805,2815,2825,2843,2893,2927,2954,2957,2963,2980,2988,2989,3005,3056,3067,3085,3087,3106,3107,3119,3143,3152,3161,3202,3212,3216,3234,3265,3278,3337,3355,3364,3373,3385,3393,3396,3408,3439,3454,3513,3579,3590,3594,3632,3663,3716,3718,3719,3725,3733,3780,3836,3855,3871,3872,3883,3947,3960,3969,3992,4028,4033,4051,4061,4063,4075,4093,4122,4131,4132,4165,4166,4168,4173,4176,4182,4197,4200,4215,4227,4252,4255,4260,4268,4271,4302,4320,4392,4405,4433,4434,4473,4477,4493,4523,4558,4580,4582,4585,4586,4587,4605,4612,4613,4614,4615,4617,4644,4734,4770,4775,4799,4832,4855,4866,4874,4910,4911,4933,4947,4957,4990,5014,5040,5065,5071,5079,5086,5092,5104,5139,5150,5170,5173,5182,5207,5222,5224,5226,5237,5268,5302,5351,5363,5367,5439,5475,5479,5484,5496,5507,5508,5530,5534,5537,5543,5549,5559,5576,5593,5616,5622,5658,5679,5686,5698,5755,5797,5798,5799,5814,5872,5876,5879,5889,5924,5934,5943,5967,5990,5993,6039,6068,6081,6084,6097,6133,6172,6173,6192,6264,6268,6270,6277,6308,6323,6324,6335,6427,6446,6451,6461,6529,6533,6571,6586,6596,6658,6663,6667,6684,6695,6707,6736,6775,6780,6788,6830,6839,6842,6847,6873,6889,6910,6915,6917,6937,6977,6985,6986,7010,7071,7081,7082,7083,7095,7117,7134,7169,7181,7182,7200,7205,7237,7260,7277,7290,7294,7325,7329,7330,7343,7358,7365,7389,7396,7416,7421,7423,7424,7435,7436,7443,7459,7468,7482,7489,7520,7526,7536,7554,7556,7565,7566,7624,7626,7627,7633,7659,7663,7679,7686,7688,7690,7709,7717,7735,7743,7745,7746,7748,7751,7771,7797,7799,7802,7813,7820,7825,7830,7839,7860,7866,7868,7870,7934,7946,7951,7958,7961,7964,8001,8015,8026,8036,8039,8042,8045,8056,8057,8069,8083,8091,8101,8108,8198,8206,8224,8239,8261,8289,8306,8311,8313,8330,8347,8348,8354,8400,8406,8416,8436,8437,8438,8441,8462,8504,8507,8518,8569,8588,8612,8655,8657,8660,8661,8680,8688,8706,8765,8779,8808,8907,8938,8944,8963,8972,8999,9012,9018,9030,9038,9051,9052,9059,9091,9108,9111,9114,9139,9142,9196,9197,9199,9211,9238,9262,9263,9264,9296,9300,9303,9308,9330,9346,9359,9370,9398,9426,9443,9444,9454,9462,9480,9481,9529,9539,9658,9689,9691,9715,9741,9746,9754,9755,9757,9825,9854,9861,9865,9869,9879,9905,9928,9981,9990,10033,10039,10043,10068,10104,10112,10123,10134,10138,10186,10213,10217,10258,10260,10316,10352,10373,10400,10402,10419,10422,10458,10479,10481,10501,10510,10603,10604,10634,10646,10691,10696,10725,10736,10751,10758,10764,10775,10783,10811,10827,10834,10842,10851,10863,10886,10956,10981,11032,11038,11041,11098,11106,11107,11113,11121,11140,11142,11159,11163,11179,11185,11195,11223,11279,11304,11305,11314,11323,11356,11398,11421,11429,11476,11542,11594,11612,11617,11627,11701,11702,11703,11705,11715,11717,11721,11722,11723,11794,11803,11820,11838,11864,11944,11952,11990,11994,12019,12034,12083,12089,12095,12113,12115,12144,12158,12170,12206,12216,12223,12238,12254,12357,12393,12440,12454,12488,12541,12567,12592,12609,12640,12650,12669,12686,12692,12708,12746,12747,12771,12791,12807,12816,12830,12834,12843,12852,12889,12902,12946,12978,12994,13019,13045,13074,13078,13138,13154,13160,13188,13218,13258,13265,13268,13272,13276,13297,13316,13321,13325,13328,13334,13344,13349,13352,13358,13437,13438,13454,13467,13474,13480,13481,13482,13501,13503,13509,13525,13535,13575,13576,13604,13660,13667,13670,13677,13681,13685,13693,13698,13710,13727,13748,13750,13765,13782,13783,13797,13818,13819,13824,13846,13868,13907,13924,13925,13926,13938,13941,13947,13968,13970,13971,14008,14020,14027,14037,14052,14056,14079,14083,14115,14118,14122,14151,14153,14154,14159,14169,14177,14180,14190,14203,14246,14255,14263,14278,14291,14309,14327,14356,14357,14385,14430,14432,14484,14493,14506,14524,14527,14546,14609,14641,14648,14660,14663,14669,14679,14710,14713,14723,14733,14747,14749,14751,14754,14760,14766,14769,14811,14814,14832,14838,14846,14849,14860,14862,14869,14874,14878,14898,14905,14906,14911,14930,14948,14958,14973,14987,14995,14996,15001,15002,15015,15020,15021,15038,15045,15046,15047,15051,15054,15063,15074,15091,15110,15115,15122,15126,15138,15147,15166,15179,15190,15201,15207,15208,15209,15216,15217,15218,15222,15229,15234,15257,15262,15272,15286,15292,15293,15298,15304,15310,15313,15351,15359,15366,15386,15409,15415,15420,15421,15464,15473,15475,15482,15488,15499,15517,15528,15539,15540,15543,15550,15551,15577,15594,15632,15633,15643,15644,15650,15680,15689,15706,15722,15726,15732,15750,15751,15753,15784,15796,15851,15862,15864,15870,15917,15927,15937,15947,15973,15980,15982,16027,16034,16052,16057,16081,16120,16122,16142,16150,16214,16216,16236,16258,16270,16311,16313,16346,16354,16356,16359,16365,16386,16394,16401,16412,16422,16436,16440,16455,16465,16466,16502,16519,16526,16535,16545,16562,16569,16578,16607,16629,16634,16654,16671,16675,16678,16686,16689,16712,16720,16728,16737,16742,16774,16780,16784,16791,16802,16812,16826,16828,16876,16879,16887,16894,16899,16910,16913,16916,16917,16955,16966,16996,17014,17015,17034,17035,17052,17062,17080,17085,17121,17126,17131,17133,17136,17141,17161,17167,17184,17197,17199,17205,17224,17250,17304,17317,17327,17334,17335,17344,17353,17359,17369,17374,17385,17409,17412,17423,17425,17427,17434,17438,17439,17479,17520,17535,17552,17555,17584,17590,17597,17603,17605,17609,17630,17635,17658,17660,17667,17692,17700,17730,17750,17780,17781,17799,17820,17826,17831,17846,17857,17862,17871,17873,17892,17901,17902,17910,17921,17927,17935,17937,17949,17953,17956,17965,17976,17977,18013,18022,18028,18029,18031,18037,18039,18040,18055,18061,18067,18071,18073,18083,18145,18153,18160,18165,18170,18174,18181,18183,18197,18202,18213,18227,18248,18284,18306,18334,18357,18362,18382,18395,18420,18447,18466,18473,18527,18538,18550,18564,18570,18576,18578,18579,18581,18590,18591,18594,18595,18607,18617,18627,18641,18658,18670,18674,18675,18686,18697,18707,18726,18734,18739,18747,18753,18765,18771,18782,18812,18813,18823,18825,18829,18845,18853,18871,18889,18900,18901,18906,18907,18915,18916,18921,18926,18929,18952,18955,18958,18960,18971,18974,18981,19011,19024,19026,19039,19040,19043,19050,19053,19057,19089,19123,19127,19150,19153,19182,19202,19204,19211,19216,19232,19235,19252,19256,19266,19299,19335,19343,19353,19358,19368,19374,19401,19407,19411,19415,19423,19426,19429,19432,19454,19469,19476,19483,19484,19487,19505,19507,19523,19527,19551,19562,19571,19591,19596,19610,19612,19648,19676,19681,19690,19704,19706,19713,19750,19761,19762,19767,19770,19773,19788,19791,19796,19797,19807,19829,19853,19858,19875,19876,19886,19890,19897,19900,19904,19916,19917,19918,19927,19934,19944,19949,19951,19967,19988,20003,20004,20009,20030,20039,20043,20051,20066,20068,20080,20092,20122,20142,20164,20179,20180,20183,20202,20230,20239,20242,20262,20265,20288,20307,20309,20316,20338,20341,20376,20384,20386,20396,20398,20404,20409,20431,20434,20437,20455,20469,20510,20521,20526,20528,20543,20545,20565,20566,20568,20569,20574,20589,20592,20599,20602,20608,20618,20642,20648,20670,20672,20688,20690,20702,20711,20718,20720,20739,20740,20750,20751,20773,20792,20804,20818,20869,20871,20894,20919,20933,20935,20944,20951,20953,20958,20962,20964,20979,20984,20990,21019,21031,21040,21042,21053,21054,21067,21072,21073,21087,21119,21145,21146,21163,21171,21179,21182,21189,21196,21198,21205,21212,21216,21222,21231,21238,21239,21243,21259,21260,21268,21274,21284,21300,21308,21311,21327,21329,21332,21379,21391,21404,21405,21411,21413,21433,21438,21450,21454,21455,21467,21487,21490,21512,21520,21523,21524,21529,21537,21547,21558,21562,21566,21583,21592,21598,21601,21602,21612,21614,21620,21631,21637,21643,21675,21691,21693,21696,21713,21719,21722,21726,21729,21733,21740,21747,21761,21767,21769,21773,21775,21787,21789,21798,21811,21821,21824,21885,21886,21891,21932,21938,21958,21964,21975,21979,21981,22001,22007,22027,22029,22046,22055,22067,22115,22120,22129,22134,22137,22156,22162,22172,22173,22181,22201,22211,22213,22222,22253,22254,22262,22267,22272,22286,22294,22329,22332,22336,22338,22387,22389,22409,22415,22416,22453,22466,22476,22481,22484,22494,22499,22539,22551,22566,22578,22581,22594,22605,22612,22620,22632,22635,22638,22653,22659,22664,22674,22687,22688,22689,22726,22733,22739,22753,22756,22781,22783,22797,22846,22848,22851,22863,22864,22865,22869,22871,22872,22886,22914,22916,22925,22959,22964,22966,23031,23036,23037,23039,23042,23066,23067,23075,23083,23099,23101,23104,23109,23114,23119,23123,23128,23163,23164,23184,23200,23201,23206,23213,23218,23221,23229,23254,23257,23261,23267,23268,23273,23278,23287,23296,23304,23309,23326,23328,23340,23344,23362,23364,23365,23380,23381,23394,23398,23406,23447,23491,23504,23523,23547,23552,23554,23585,23592,23593,23604,23625,23628,23632,23638,23659,23689,23691,23696,23704,23708,23715,23720,23722,23747,23751,23769,23805,23813,23842,23860,23871,23885,23886,23887,23888,23890,23891,23893,23897,23899,23901,23904,23905,23907,23911,23921,23927,23954,23964,23981,23983,23986,23987,24000,24010,24017,24029,24039,24040,24052,24059,24067,24077,24114,24134,24145,24160,24163,24170,24172,24197,24198,24200,24208,24235,24269,24281,24286,24294,24311,24316,24337,24357,24390,24414,24422,24429,24452,24455,24485,24487,24496,24503,24510,24522,24524,24587,24589,24599,24617,24623,24674,24678,24679,24699,24766,24781,24782,24785,24802,24819,24834,24838,24854,24871,24958,24983,24999,25010,25024,25032,25038,25039,25046,25062,25068,25141,25172,25179,25197,25200,25201,25233,25267,25273,25275,25278,25284,25292,25317,25326,25347,25370,25377,25443,25450,25482,25505,25518,25548,25554,25589,25621,25622,25628,25639,25646,25648,25671,25673,25693,25705,25717,25723,25724,25727,25747,25754,25757,25758,25771,25784,25790,25810,25817,25818,25830,25831,25836,25849,25863,25881,25889,25896,25909,25916,25924,25927,25928,25932,25941,25942,25943,25949,25961,25964,25990,25992,25994,25995,26000,26010,26013,26025,26027,26031,26033,26035,26060,26066,26082,26087,26109,26113,26120,26136,26146,26147,26153,26154,26161,26167,26185,26187,26191,26194,26215,26221,26227,26234,26259,26287,26296,26319,26335,26337,26348,26353,26359,26372,26386,26388,26467,26468,26471,26486,26507,26508,26525,26530,26535,26548,26565,26576,26582,26620,26630,26639,26646,26689,26691,26699,26722,26744,26753,26755,26757,26759,26780,26784,26793,26797,26807,26820,26840,26845,26852,26873,26879,26890,26909,26927,26929,26933,26935,26944,26945,26949,26968,27035,27046,27049,27065,27148,27211,27212,27216,27236,27237,27240,27260,27270,27279,27280,27311,27323,27327,27347,27367,27383,27405,27408,27423,27487,27491,27492,27526,27541,27568,27570,27578,27583,27589,27592,27593,27595,27601,27610,27613,27614,27671,27688,27707,27717,27742,27758,27761,27766,27779,27786,27828,27859,27922,27924,27927,27930,27954,27983,28006,28018,28019,28031,28042,28059,28066,28075,28079,28094,28097,28114,28120,28129,28162,28168,28189,28192,28230,28233,28243,28264,28306,28329,28354,28380,28435,28441,28598,28608,28628,28673,28746,28846,28857,28880,28922,28931,28943,28956,28999,29011,29045,29129,29266,29345,29373,29387,29486,29495,29548,29560,29603,29611,29616,29639,29719,29724,29769,29801,29818,29832,29864,29866,29914,29919,29976,30111,30385,30562,30643,31002,31207,31384,31608,31620,31735,31820,31837,31853,31975,32084,32091,32530,32720,32767,32768,32919,33025,33290,33345,33874,33908,33925,33946,33957,34025,34047,34089,34126,34163,34174,34200,34257,34275,34321,34331,34421,34500,34559,34616,34646,34653,34676,34693,34750,34781,34782,34793,34804,34811,34815,34816,34838,34895,35055,35069,35103,35176,35184,35220,35226,35227,35238,35239,35289,35299,35337,35359,35360,35376,35379,35397,35403,35426,35434,35435,35444,35452,35484,35490,35492,35523,35545,35554,35556,35596,35621,35623,35688,35711,35728,35780,35805,35806,35808,35814,35835,35841,35846,35869,35872,35882,35948,35950,35967,35973,35980,36000,36015,36085,36141,36151,36153,36220,36232,36234,36237,36281,36297,36368,36369,36373,36385,36420,36441,36461,36476,36583,36584,36589,36592,36615,36670,36680,36704,36751,36752,36775,36776,36803,36815,36817,36851,36888,36890,36896,36897,36917,36930,36932,36945,36961,36973,36989,36998,37010,37011,37029,37034,37107,37116,37136,37147,37170,37245,37283,37284,37307,37308,37310,37332,37353,37371,37378,37397,37401,37403,37426,37439,37454,37534,37544,37602,37618,37626,37642,37644,37677,37717,37773,37880,37885,37902,37906,37907,37940,38006,38058,38079,38092,38103,38114,38122,38126,38128,38131,38133,38315,38330,38343,38364,38393,38397,38398,38433,38440,38446,38451,38452,38489,38530,38546,38549,38574,38602,38617,38666,38674,38676,38713,38716,38721,38723,38738,38763,38774,38799,38811,38821,38824,38829,38866,38873,38877,38903,38904,38912,38922,38934,38939,38949,38965,38975,38990,38999,39024,39027,39035,39048,39052,39054,39088,39090,39102,39111,39135,39150,39155,39163,39183,39193,39195,39205,39245,39260,39276,39286,39290,39293,39296,39315,39319,39335,39346,39347,39366,39370,39375,39389,39411,39442,39475,39476,39480,39485,39492,39497,39507,39520,39559,39572,39580,39587,39598,39609,39610,39624,39634,39645,39666,39677,39686,39706,39717,39722,39724,39747,39768,39802,39816,39891,39907,39993,40018,40080,40089,40099,40112,40135,40231,40276,40288,40289,40311,40319,40326,40345,40365,40381,40398,40436,40438,40441,40460,40465,40502,40509,40535,40554,40555,40558,40560,40562,40585,40594,40614,40624,40640,40647,40649,40660,40667,40688,40720,40727,40761,40772,40774,40775,40785,40787,40803,40811,40817,40853,40860,40887,40896,40912,40927,40937,40941,40959,40965,40973,41007,41040,41041,41048,41062,41068,41092,41140,41144,41150,41153,41158,41163,41171,41172,41191,41200,41219,41220,41246,41289,41290,41299,41322,41332,41345,41369,41418,41421,41436,41453,41499,41516,41522,41543,41566,41570,41576,41619,41622,41649,41687,41695,41696,41724,41746,41747,41779,41781,41797,41800,41816,41839,41840,41853,41865,41871,41876,41879,41896,41911,41927,41956,41957,41969,41993,42021,42040,42054,42057,42065,42069,42080,42091,42125,42134,42154,42163,42174,42187,42188,42212,42259,42264,42274,42304,42367,42368,42405,42412,42415,42448,42490,42531,42538,42541,42572,42629,42637,42651,42665,42673,42676,42703,42729,42730,42758,42765,42768,42789,42797,42800,42806,42808,42863,42870,42891,42911,42912,42941,42987,43003,43004,43009,43016,43068,43109,43115,43136,43143,43159,43165,43222,43234,43237,43244,43271,43294,43339,43340,43345,43347,43348,43405,43446,43459,43461,43483,43488,43507,43508,43509,43539,43550,43554,43565,43596,43601,43605,43613,43615,43653,43678,43682,43712,43732,43795,43814,43835,43846,43979,43988,44026,44062,44088,44089,44142,44168,44177,44184,44351,44352,44366,44368,44400,44431,44491,44544,44573,44588,44611,44613,44683,44701,44712,44718,44722,44788,44807,44829,44873,44894,44908,44912,44935,44936,44941,44982,44988,45051,45101,45136,45138,45157,45235,45263,45264,45302,45303,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 | 2753 | 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.31 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.51 ms |
System lock | 0.02 ms |
optimizing | 0.17 ms |
statistics | 4.24 ms |
preparing | 2.07 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 6.00 ms |
end | 0.02 ms |
query end | 0.05 ms |
closing tables | 0.02 ms |
freeing items | 0.26 ms |
cleaning up | 0.09 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 |