Tiempo de la consulta: 14.47 ms Después de la última consulta: 2.60 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.683 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-03 18:10:39')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-03 18:10: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(9,11,25,28,49,58,60,61,62,63,64,65,67,68,71,75,78,90,92,96,97,98,99,101,102,104,107,112,113,114,117,119,120,121,136,140,142,143,144,145,146,147,148,149,150,151,152,153,154,155,165,170,172,178,179,198,199,202,203,207,208,209,210,217,226,228,232,234,238,240,242,243,255,256,265,271,272,276,278,280,281,283,287,290,291,293,296,297,300,301,303,304,305,307,331,344,349,350,353,371,372,373,374,376,377,378,379,380,385,389,391,417,419,428,437,453,456,458,466,487,489,493,501,516,523,549,586,592,605,607,608,611,637,667,686,693,697,717,723,794,797,799,813,831,839,843,844,847,848,857,868,870,878,891,904,941,948,953,956,964,966,970,976,978,986,997,1018,1024,1031,1033,1043,1044,1047,1053,1067,1075,1080,1091,1123,1130,1139,1143,1158,1168,1169,1178,1185,1186,1187,1207,1208,1209,1212,1215,1223,1232,1233,1247,1252,1253,1256,1273,1277,1280,1287,1291,1298,1302,1305,1319,1329,1339,1372,1486,1503,1506,1601,1664,1698,1709,1718,1781,1800,1804,1817,1825,1835,1845,1851,1931,1957,2005,2112,2156,2258,2293,2322,2394,2601,2656,2713,2714,2729,2742,2757,2822,2827,2857,2901,2962,2964,2991,2997,3020,3028,3045,3058,3067,3091,3106,3107,3117,3124,3126,3209,3210,3212,3215,3223,3301,3322,3329,3340,3412,3463,3519,3668,3669,3671,3687,3692,3696,3738,3783,3786,3816,3842,3870,3895,3957,3982,3986,4013,4076,4087,4120,4128,4206,4268,4281,4319,4378,4399,4405,4563,4587,4638,4670,4691,4701,4765,4767,4784,4808,4832,4848,4902,4905,4907,4908,5125,5150,5300,5323,5371,5451,5471,5525,5559,5567,5622,5647,5649,5659,5685,5726,5727,5730,5814,5847,5894,5944,6015,6039,6062,6131,6147,6234,6257,6264,6270,6292,6298,6333,6347,6362,6381,6384,6386,6393,6464,6470,6473,6478,6484,6518,6538,6542,6543,6557,6570,6573,6574,6616,6631,6633,6654,6662,6687,6688,6699,6725,6726,6744,6748,6749,6760,6785,6830,6839,6847,6881,6905,6908,6911,6915,6940,6942,6955,6957,6961,6965,6966,6968,6971,6984,6986,6989,6998,7001,7016,7017,7043,7075,7101,7105,7125,7154,7161,7235,7280,7282,7285,7291,7296,7303,7311,7328,7361,7378,7380,7387,7401,7402,7403,7410,7414,7427,7432,7434,7435,7439,7450,7454,7456,7483,7488,7490,7494,7508,7522,7544,7546,7556,7578,7588,7614,7616,7622,7624,7626,7638,7677,7688,7710,7713,7730,7745,7749,7758,7772,7774,7797,7801,7806,7829,7831,7836,7838,7839,7847,7858,7860,7862,7863,7867,7890,7894,7916,7923,7928,7931,7946,7950,7957,7958,7965,7967,7981,7983,7985,7989,7998,8021,8027,8056,8062,8070,8093,8107,8108,8115,8177,8190,8250,8320,8353,8354,8356,8499,8531,8551,8555,8663,8679,8694,8754,8844,8886,8932,8950,9003,9057,9091,9203,9239,9242,9249,9282,9305,9318,9351,9355,9398,9405,9429,9507,9532,9556,9574,9626,9650,9723,9724,9725,9791,9860,9861,9864,9865,9895,9924,9944,9945,9966,9985,10011,10028,10031,10092,10098,10100,10106,10110,10120,10149,10181,10188,10206,10227,10239,10243,10259,10264,10265,10280,10298,10313,10315,10318,10323,10357,10368,10369,10370,10382,10383,10399,10415,10425,10436,10444,10504,10534,10535,10536,10561,10572,10611,10623,10644,10688,10721,10741,10757,10764,10777,10779,10782,10798,10803,10820,10821,10834,10835,10889,10907,10916,10925,10952,10956,10957,10971,11005,11008,11035,11059,11073,11082,11091,11094,11113,11129,11150,11156,11163,11188,11192,11207,11235,11249,11260,11269,11292,11299,11310,11327,11333,11362,11365,11366,11377,11391,11430,11476,11482,11525,11539,11561,11565,11663,11688,11711,11726,11779,11799,11808,11816,11822,11863,11893,11894,11896,11911,11922,11924,11946,11950,11976,12009,12019,12042,12081,12095,12112,12145,12147,12150,12153,12165,12167,12174,12177,12178,12179,12204,12225,12238,12243,12270,12301,12337,12364,12388,12398,12399,12401,12412,12424,12427,12445,12446,12465,12482,12492,12510,12519,12520,12567,12579,12581,12582,12609,12625,12668,12670,12679,12681,12685,12709,12715,12758,12780,12806,12838,12850,12851,12873,12887,12898,12902,12907,12913,12940,12944,12948,12966,12973,12978,12985,12990,13004,13006,13010,13035,13036,13038,13041,13061,13062,13067,13079,13100,13137,13152,13153,13155,13157,13211,13216,13227,13229,13231,13253,13276,13285,13307,13321,13325,13332,13334,13387,13390,13398,13405,13408,13420,13445,13461,13462,13466,13471,13473,13476,13481,13487,13492,13493,13497,13500,13515,13518,13519,13557,13635,13647,13657,13665,13666,13681,13695,13696,13748,13750,13783,13792,13800,13805,13816,13817,13835,13837,13863,13868,13880,13894,13901,13906,13922,13924,13934,13941,13953,13963,13969,13972,14021,14024,14029,14034,14098,14103,14107,14113,14116,14140,14143,14152,14153,14156,14189,14194,14203,14204,14205,14218,14223,14224,14229,14240,14248,14249,14250,14257,14258,14263,14283,14289,14293,14336,14352,14354,14356,14372,14382,14396,14401,14424,14426,14435,14453,14457,14524,14530,14558,14570,14571,14581,14591,14596,14625,14629,14630,14631,14663,14665,14676,14679,14682,14695,14698,14725,14754,14759,14775,14776,14789,14829,14843,14845,14847,14850,14852,14856,14865,14895,14909,14911,14935,14939,14945,14958,14983,14984,14986,14987,14988,14999,15003,15007,15010,15018,15021,15029,15038,15039,15045,15063,15086,15094,15110,15114,15129,15145,15151,15156,15158,15171,15173,15177,15179,15183,15187,15188,15198,15205,15214,15231,15233,15244,15258,15259,15262,15270,15286,15298,15304,15315,15316,15328,15332,15335,15346,15347,15351,15359,15361,15366,15368,15376,15406,15407,15408,15418,15421,15424,15429,15442,15444,15468,15469,15470,15473,15475,15482,15487,15493,15495,15511,15513,15516,15517,15520,15522,15550,15552,15561,15569,15573,15577,15581,15594,15600,15608,15616,15630,15632,15645,15655,15667,15669,15672,15689,15700,15704,15714,15723,15730,15732,15742,15753,15755,15759,15778,15782,15784,15785,15790,15805,15812,15835,15843,15850,15863,15875,15880,15897,15898,15937,15957,15965,15975,15981,15987,16024,16030,16043,16053,16056,16058,16083,16088,16090,16095,16101,16122,16127,16129,16133,16154,16155,16163,16165,16180,16201,16211,16213,16249,16250,16254,16258,16263,16278,16281,16316,16322,16323,16324,16334,16338,16352,16357,16359,16362,16365,16381,16384,16410,16417,16427,16438,16446,16450,16464,16474,16488,16517,16520,16521,16523,16524,16532,16542,16547,16551,16556,16561,16562,16564,16566,16571,16585,16622,16623,16626,16629,16657,16668,16670,16675,16678,16684,16689,16695,16698,16717,16720,16724,16737,16748,16781,16783,16791,16812,16816,16826,16830,16839,16840,16841,16861,16862,16863,16865,16894,16942,16951,16963,16982,16983,17002,17045,17049,17060,17063,17067,17069,17084,17086,17096,17116,17132,17142,17148,17154,17163,17166,17168,17177,17188,17195,17198,17199,17201,17210,17221,17236,17240,17242,17246,17253,17256,17273,17275,17282,17287,17288,17300,17307,17317,17331,17334,17335,17336,17339,17343,17344,17353,17360,17362,17365,17386,17387,17409,17410,17412,17422,17431,17433,17443,17444,17449,17453,17456,17470,17471,17490,17497,17506,17509,17520,17521,17539,17542,17553,17559,17561,17566,17572,17573,17575,17584,17590,17598,17599,17602,17609,17611,17618,17619,17625,17630,17632,17655,17659,17660,17663,17688,17691,17700,17701,17710,17711,17712,17713,17717,17727,17734,17736,17748,17749,17753,17759,17761,17764,17766,17779,17782,17783,17784,17802,17810,17814,17818,17820,17826,17834,17850,17853,17862,17870,17876,17879,17887,17893,17914,17919,17920,17922,17930,17931,17933,17936,17941,17949,17950,17955,17965,17967,17983,17988,17994,17996,18006,18012,18022,18029,18032,18034,18044,18052,18060,18061,18074,18083,18084,18106,18118,18121,18124,18133,18162,18170,18173,18181,18213,18219,18220,18222,18229,18240,18260,18274,18278,18285,18295,18300,18301,18311,18317,18320,18336,18352,18362,18364,18375,18382,18390,18391,18397,18426,18428,18429,18450,18458,18463,18465,18467,18473,18494,18509,18520,18524,18538,18541,18552,18567,18571,18572,18588,18596,18597,18605,18612,18626,18629,18648,18658,18664,18668,18671,18675,18689,18693,18696,18706,18707,18718,18720,18726,18728,18750,18751,18753,18762,18801,18810,18811,18828,18830,18845,18846,18849,18852,18866,18871,18873,18877,18880,18888,18892,18894,18901,18905,18911,18916,18929,18934,18953,18955,18956,18958,18959,18984,18999,19001,19002,19003,19004,19014,19015,19018,19024,19040,19047,19055,19057,19060,19063,19067,19098,19100,19105,19124,19128,19129,19133,19134,19140,19145,19148,19150,19155,19170,19173,19180,19185,19211,19217,19220,19227,19230,19231,19235,19236,19245,19247,19252,19253,19254,19259,19260,19263,19276,19277,19283,19287,19296,19297,19304,19308,19311,19312,19315,19325,19327,19344,19352,19353,19358,19369,19376,19379,19381,19387,19402,19407,19420,19424,19454,19457,19460,19467,19471,19475,19482,19483,19484,19486,19517,19521,19527,19531,19532,19536,19551,19563,19572,19574,19577,19582,19583,19591,19607,19617,19620,19622,19633,19639,19645,19646,19648,19650,19652,19659,19668,19676,19679,19684,19687,19710,19718,19722,19725,19732,19733,19747,19749,19754,19772,19773,19791,19794,19807,19811,19816,19830,19837,19848,19854,19855,19862,19868,19870,19871,19875,19877,19881,19891,19901,19908,19909,19913,19915,19923,19929,19939,19943,19963,19965,19972,19982,19984,19993,19994,19996,19998,20004,20010,20015,20023,20028,20032,20039,20042,20056,20086,20092,20097,20104,20119,20122,20124,20127,20141,20144,20148,20154,20156,20161,20163,20170,20175,20179,20183,20186,20187,20189,20216,20224,20234,20256,20263,20269,20271,20276,20286,20289,20296,20297,20301,20303,20309,20333,20338,20343,20345,20346,20353,20366,20376,20382,20383,20385,20386,20390,20405,20406,20408,20411,20433,20434,20437,20445,20447,20449,20450,20472,20474,20476,20488,20492,20497,20511,20515,20516,20521,20522,20526,20528,20535,20539,20542,20545,20564,20565,20573,20588,20592,20602,20607,20615,20617,20630,20632,20638,20656,20659,20664,20670,20688,20698,20708,20710,20711,20714,20718,20729,20735,20737,20750,20752,20772,20777,20778,20781,20792,20794,20804,20805,20814,20845,20866,20869,20881,20885,20894,20907,20913,20940,20944,20947,20959,20960,20964,20979,20981,20982,20984,20994,21002,21009,21050,21055,21075,21079,21080,21104,21116,21117,21118,21122,21126,21128,21135,21143,21147,21170,21173,21182,21187,21189,21198,21215,21223,21225,21228,21247,21255,21256,21259,21270,21297,21300,21305,21314,21316,21321,21323,21325,21344,21350,21367,21370,21372,21380,21390,21392,21398,21400,21404,21418,21421,21422,21432,21433,21448,21449,21454,21457,21463,21470,21487,21491,21495,21496,21498,21502,21513,21520,21521,21522,21523,21540,21545,21551,21555,21577,21591,21607,21611,21614,21620,21631,21636,21640,21663,21678,21679,21680,21682,21684,21694,21698,21702,21718,21719,21738,21740,21741,21746,21751,21756,21757,21764,21765,21767,21768,21775,21776,21778,21795,21853,21854,21863,21867,21870,21879,21883,21891,21895,21899,21906,21917,21924,21928,21932,21947,21950,21958,21960,21961,21968,21977,21980,21987,21990,21992,21997,22003,22011,22028,22032,22038,22039,22040,22044,22056,22067,22079,22085,22089,22096,22099,22100,22106,22113,22119,22132,22134,22137,22146,22154,22156,22162,22170,22172,22178,22189,22194,22198,22207,22215,22229,22239,22253,22255,22267,22269,22276,22278,22290,22297,22298,22306,22315,22320,22326,22337,22339,22341,22344,22349,22359,22361,22363,22382,22395,22409,22436,22450,22460,22465,22466,22476,22481,22484,22486,22488,22494,22499,22501,22523,22527,22544,22547,22554,22555,22559,22564,22570,22572,22579,22588,22596,22611,22616,22647,22653,22659,22661,22673,22693,22694,22695,22698,22709,22712,22718,22726,22746,22751,22753,22754,22759,22774,22781,22799,22804,22808,22814,22820,22840,22865,22866,22871,22903,22908,22909,22914,22915,22925,22930,22935,22944,22958,22959,22960,22964,22973,22974,22976,22980,22988,22989,22999,23003,23009,23010,23011,23022,23029,23034,23036,23071,23072,23074,23076,23077,23078,23083,23087,23093,23096,23099,23103,23104,23112,23113,23119,23137,23139,23140,23156,23184,23186,23201,23203,23208,23218,23221,23229,23230,23232,23235,23236,23242,23251,23252,23254,23264,23268,23270,23272,23275,23279,23281,23286,23287,23289,23292,23295,23300,23302,23304,23308,23339,23357,23364,23367,23368,23371,23374,23381,23391,23397,23398,23399,23401,23402,23405,23423,23424,23430,23438,23439,23444,23449,23455,23456,23460,23467,23475,23479,23483,23484,23486,23495,23523,23525,23527,23535,23550,23553,23554,23562,23577,23585,23602,23604,23610,23618,23619,23621,23622,23623,23632,23636,23642,23665,23682,23691,23693,23698,23709,23716,23719,23727,23732,23743,23759,23761,23764,23768,23784,23787,23805,23813,23816,23826,23840,23845,23846,23849,23853,23854,23858,23869,23882,23885,23893,23897,23901,23902,23905,23909,23910,23920,23921,23936,23937,23944,23947,23949,23955,23958,23964,23965,23968,23969,23986,24000,24003,24007,24009,24012,24015,24024,24025,24028,24033,24034,24059,24060,24065,24066,24076,24090,24092,24102,24110,24112,24115,24122,24159,24160,24164,24168,24170,24186,24194,24196,24197,24209,24220,24226,24237,24238,24239,24270,24283,24284,24294,24296,24303,24306,24326,24328,24335,24337,24339,24342,24352,24361,24362,24364,24367,24372,24376,24402,24420,24422,24429,24430,24441,24451,24453,24457,24460,24461,24473,24475,24480,24481,24489,24496,24499,24503,24506,24520,24526,24530,24539,24540,24556,24566,24575,24576,24577,24584,24585,24586,24598,24605,24615,24617,24635,24639,24650,24653,24655,24656,24663,24668,24677,24678,24679,24690,24707,24711,24720,24724,24726,24741,24751,24754,24755,24764,24772,24775,24779,24782,24791,24794,24795,24800,24804,24805,24809,24816,24826,24841,24844,24849,24859,24860,24861,24865,24868,24884,24897,24909,24910,24918,24930,24931,24934,24941,24946,24951,24963,24975,24984,24992,25002,25003,25005,25026,25032,25036,25037,25038,25043,25045,25048,25062,25063,25068,25070,25071,25079,25081,25088,25089,25090,25091,25096,25109,25112,25117,25136,25147,25151,25153,25155,25164,25165,25180,25184,25192,25200,25202,25230,25232,25244,25264,25280,25282,25287,25291,25293,25297,25303,25310,25315,25327,25329,25332,25333,25346,25352,25358,25367,25368,25375,25384,25386,25401,25408,25416,25418,25432,25440,25445,25450,25452,25462,25477,25480,25484,25507,25515,25517,25519,25523,25526,25535,25548,25555,25560,25564,25565,25589,25601,25613,25637,25638,25640,25649,25653,25664,25672,25676,25678,25679,25687,25692,25697,25698,25702,25711,25716,25727,25734,25740,25747,25765,25775,25785,25795,25806,25807,25854,25863,25864,25872,25887,25889,25906,25918,25919,25921,25925,25926,25935,25949,25950,25956,25959,25971,25995,26008,26023,26028,26043,26047,26050,26053,26055,26063,26065,26082,26118,26131,26135,26184,26187,26188,26221,26229,26235,26258,26261,26274,26283,26296,26315,26340,26358,26367,26372,26386,26390,26413,26421,26443,26444,26469,26521,26540,26541,26561,26583,26595,26596,26606,26625,26640,26673,26698,26699,26708,26711,26720,26732,26807,26835,26843,26853,26854,26864,26873,26884,26900,26902,26916,26925,26937,26940,26944,26959,26971,26978,26990,27001,27002,27009,27024,27039,27041,27055,27061,27062,27076,27082,27086,27094,27101,27109,27115,27118,27126,27141,27143,27148,27158,27161,27171,27178,27212,27218,27221,27232,27233,27250,27290,27317,27321,27327,27346,27374,27379,27384,27405,27430,27487,27499,27506,27550,27552,27560,27578,27584,27595,27634,27646,27707,27717,27745,27795,27851,27871,27909,27949,27950,27968,27975,28005,28030,28049,28059,28066,28068,28075,28094,28097,28114,28120,28121,28192,28213,28230,28237,28243,28264,28279,28283,28290,28295,28336,28344,28354,28355,28372,28454,28464,28478,28495,28511,28537,28548,28552,28623,28695,28698,28718,28739,28749,28825,28826,28852,28882,28892,28907,28908,28920,28951,28972,28973,29028,29049,29061,29063,29073,29140,29143,29155,29171,29194,29208,29214,29219,29269,29297,29325,29331,29349,29372,29378,29412,29454,29484,29495,29535,29539,29576,29611,29617,29618,29642,29653,29655,29673,29719,29743,29802,29882,29912,29924,29926,29937,29939,29943,29962,30000,30083,30111,30273,30274,30379,30449,30483,30484,30530,30654,30740,30803,30808,31115,31129,31136,31174,31447,31604,31651,31876,32107,32187,32331,32565,32676,32820,32840,32905,33871,34612,34784,34794,35000,35230,35339,35444,35490,35554,35556,35585,35603,35637,35711,35740,35744,35746,35774,35832,35846,35858,35882,35921,35956,36191,36208,36216,36441,36492,36584,36797,37288,37294,37298,37547,37627,37644,38086,38723,38884,38898,38900,38958,38975,38986,39020,39064,39088,39131,39158,39159,39172,39184,39269,39293,39320,39345,39370,39376,39381,39411,39448,39451,39513,39517,39629,39686,39857,39887,39981,39998,40086,40104,40113,40168,40184,40203,40334,40351,40356,40369,40401,40405,40451,40483,40492,40578,40611,40636,40736,40752,40885,40888,40993,41049,41105,41109,41121,41149,41172,41211,41213,41236,41253,41254,41325,41415,41477,41483,41504,41505,41506,41577,41612,42042,42423,42479,42809,43012,43276,43401,43654,44109,44122,44143,44421,44478,44735,44871,44912,45046,45057,45068,45201)
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 | 2879 | 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.96 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.06 ms |
init | 0.85 ms |
System lock | 0.02 ms |
optimizing | 0.21 ms |
statistics | 6.80 ms |
preparing | 3.18 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.47 ms |
end | 0.05 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.08 ms |
cleaning up | 0.06 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 |