Tiempo de la consulta: 13.31 ms Después de la última consulta: 2.34 ms Consulta a la memoria: 1.065 MB memoria antes de la consulta: 4.352 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 10:26:39')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 10:26: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(4,7,20,21,60,61,66,69,78,81,94,117,120,126,156,157,158,159,160,167,180,183,184,197,199,201,203,204,212,216,260,263,265,271,275,287,304,305,306,316,317,340,354,368,377,390,394,463,493,495,512,515,519,526,540,542,549,561,563,566,584,592,593,608,621,635,670,686,697,710,728,731,740,741,742,756,770,791,825,840,841,854,855,891,892,908,921,931,954,955,977,1007,1020,1022,1029,1052,1103,1104,1155,1164,1168,1187,1188,1226,1229,1257,1265,1280,1287,1296,1298,1302,1313,1336,1338,1344,1348,1354,1367,1371,1380,1392,1397,1398,1402,1406,1408,1413,1420,1421,1430,1433,1435,1441,1443,1468,1470,1478,1493,1498,1503,1506,1507,1524,1531,1532,1537,1538,1558,1568,1571,1572,1588,1598,1601,1616,1626,1630,1634,1645,1656,1681,1695,1714,1718,1719,1730,1731,1732,1739,1740,1774,1804,1823,1824,1905,1916,1932,1953,2014,2066,2089,2096,2145,2178,2183,2190,2194,2207,2209,2229,2233,2236,2245,2258,2305,2308,2314,2315,2316,2332,2333,2342,2353,2373,2376,2389,2396,2410,2427,2453,2459,2476,2481,2503,2511,2516,2524,2564,2579,2590,2594,2631,2632,2641,2644,2688,2695,2720,2728,2765,2817,2830,2902,2926,2942,3025,3063,3067,3069,3073,3078,3087,3112,3117,3126,3129,3131,3137,3143,3163,3176,3187,3222,3235,3293,3319,3327,3329,3346,3382,3388,3436,3457,3486,3546,3556,3574,3575,3579,3582,3587,3602,3612,3657,3675,3709,3725,3796,3827,3840,3864,3888,3898,3917,3925,3979,4015,4035,4038,4052,4074,4090,4095,4098,4100,4131,4140,4153,4214,4227,4292,4309,4332,4335,4337,4339,4341,4343,4362,4387,4392,4473,4488,4493,4525,4541,4565,4567,4612,4613,4614,4615,4617,4631,4632,4654,4684,4688,4689,4691,4710,4718,4751,4784,4808,4841,4847,4871,4902,4913,4930,4949,4971,4982,4999,5016,5020,5051,5099,5139,5149,5180,5182,5199,5241,5298,5323,5369,5378,5389,5431,5454,5461,5470,5484,5530,5543,5566,5569,5572,5578,5579,5580,5587,5588,5594,5597,5632,5639,5645,5650,5659,5662,5669,5694,5713,5719,5722,5726,5727,5729,5730,5747,5769,5792,5800,5814,5819,5822,5855,5857,5870,5880,5922,5934,5940,5951,5972,5973,5996,6006,6010,6043,6050,6055,6066,6067,6081,6097,6127,6159,6178,6217,6264,6270,6272,6291,6292,6298,6329,6330,6332,6340,6347,6348,6349,6350,6354,6359,6363,6372,6376,6381,6388,6392,6427,6442,6445,6455,6456,6460,6462,6465,6466,6468,6470,6471,6473,6492,6494,6497,6499,6500,6502,6515,6517,6520,6534,6537,6545,6546,6568,6601,6603,6608,6616,6621,6645,6654,6656,6658,6659,6669,6675,6677,6695,6706,6711,6718,6729,6744,6749,6762,6771,6776,6779,6788,6805,6806,6809,6816,6827,6847,6868,6869,6872,6879,6882,6889,6910,6914,6915,6916,6918,6942,6945,6975,6990,6995,7022,7043,7045,7048,7056,7074,7082,7083,7086,7096,7099,7102,7105,7110,7122,7125,7134,7135,7138,7150,7154,7155,7156,7160,7161,7170,7171,7173,7176,7178,7179,7181,7201,7212,7213,7215,7218,7231,7232,7234,7241,7243,7246,7249,7267,7268,7270,7275,7277,7279,7282,7283,7285,7289,7299,7309,7319,7327,7328,7330,7333,7334,7344,7346,7358,7361,7364,7365,7367,7368,7370,7371,7372,7374,7376,7377,7378,7379,7380,7389,7396,7403,7406,7407,7408,7410,7411,7413,7414,7415,7416,7417,7418,7422,7427,7428,7430,7431,7435,7436,7447,7449,7450,7455,7456,7457,7458,7459,7461,7462,7463,7464,7465,7466,7469,7486,7488,7489,7494,7495,7500,7513,7514,7523,7524,7531,7545,7546,7552,7553,7565,7567,7570,7577,7578,7583,7588,7589,7592,7615,7619,7624,7625,7630,7659,7674,7677,7678,7680,7681,7682,7683,7686,7688,7689,7690,7691,7708,7713,7715,7716,7717,7719,7720,7722,7735,7743,7744,7746,7749,7757,7758,7764,7768,7780,7799,7804,7806,7808,7809,7810,7830,7831,7833,7834,7835,7836,7837,7839,7841,7851,7855,7856,7860,7862,7863,7864,7866,7868,7871,7891,7894,7895,7900,7901,7918,7919,7920,7923,7928,7930,7932,7935,7936,7938,7940,7946,7955,7957,7960,7961,7962,7963,7970,7979,7982,7987,7994,7998,8017,8020,8021,8022,8023,8024,8026,8028,8037,8042,8048,8049,8056,8061,8064,8067,8070,8071,8072,8073,8082,8090,8103,8109,8111,8134,8139,8140,8185,8199,8203,8275,8276,8289,8295,8311,8328,8330,8338,8339,8451,8483,8498,8531,8540,8569,8577,8591,8593,8613,8681,8698,8704,8710,8773,8776,8781,8808,8813,8853,8865,8917,8934,8983,9010,9029,9046,9053,9059,9068,9077,9108,9114,9116,9148,9149,9191,9199,9200,9201,9202,9218,9223,9253,9303,9308,9322,9331,9341,9344,9475,9478,9568,9584,9613,9619,9650,9652,9653,9658,9672,9757,9759,9767,9818,9826,9839,9866,9877,9878,9880,9896,9907,9909,9939,9942,9964,9996,10004,10009,10010,10078,10079,10118,10134,10156,10165,10178,10186,10189,10197,10199,10205,10226,10243,10247,10261,10264,10265,10287,10298,10308,10340,10345,10348,10349,10379,10387,10399,10400,10438,10442,10451,10468,10477,10522,10534,10553,10560,10562,10595,10600,10665,10673,10686,10689,10708,10731,10764,10775,10811,10835,10967,10986,11001,11016,11030,11071,11099,11126,11163,11192,11226,11229,11231,11241,11320,11354,11404,11439,11441,11444,11446,11458,11494,11548,11581,11591,11592,11603,11626,11644,11692,11713,11814,11822,11840,11849,11864,11909,11943,11967,12013,12024,12060,12069,12095,12116,12128,12171,12181,12184,12218,12219,12223,12225,12226,12334,12340,12358,12385,12397,12406,12410,12435,12474,12487,12488,12499,12520,12527,12567,12592,12595,12609,12617,12620,12621,12622,12623,12625,12630,12649,12705,12708,12717,12718,12738,12745,12752,12760,12786,12839,12884,12888,12894,12909,12925,12944,12945,12951,12957,12978,13002,13010,13040,13078,13129,13154,13194,13248,13321,13325,13327,13328,13375,13387,13451,13460,13473,13475,13476,13479,13481,13501,13534,13535,13578,13656,13657,13667,13685,13707,13730,13759,13773,13851,13865,13886,13894,13895,13950,13959,13969,14000,14005,14047,14048,14049,14052,14074,14084,14099,14110,14126,14181,14204,14205,14218,14227,14229,14234,14250,14268,14282,14293,14328,14349,14350,14356,14357,14360,14366,14396,14398,14421,14431,14432,14448,14457,14462,14468,14505,14516,14521,14524,14542,14570,14574,14592,14596,14600,14651,14653,14680,14682,14685,14713,14726,14746,14749,14753,14758,14765,14770,14782,14818,14834,14837,14849,14852,14865,14881,14931,14946,14947,14973,14974,14980,14982,14987,14993,14997,15002,15015,15021,15024,15029,15039,15046,15049,15060,15065,15092,15110,15114,15123,15144,15162,15166,15198,15201,15222,15226,15230,15243,15244,15253,15293,15298,15307,15314,15317,15318,15319,15321,15324,15325,15339,15344,15358,15360,15371,15372,15377,15408,15421,15443,15482,15488,15495,15500,15508,15530,15533,15550,15562,15594,15642,15651,15660,15661,15666,15673,15689,15712,15714,15733,15744,15762,15784,15788,15797,15808,15816,15819,15835,15837,15839,15840,15843,15850,15862,15874,15897,15901,15902,15904,15916,15917,15925,15936,15945,15954,15977,15981,16000,16031,16055,16101,16103,16125,16156,16167,16172,16176,16190,16200,16214,16231,16240,16249,16257,16261,16282,16328,16347,16353,16370,16400,16410,16414,16415,16421,16422,16423,16437,16438,16440,16441,16463,16466,16467,16499,16507,16508,16514,16520,16537,16549,16560,16571,16580,16584,16613,16647,16661,16663,16682,16689,16704,16716,16717,16720,16722,16724,16763,16772,16778,16809,16812,16820,16823,16826,16854,16866,16884,16887,16894,16907,16964,16994,16998,17002,17018,17063,17066,17080,17114,17148,17150,17158,17160,17185,17205,17216,17233,17242,17244,17281,17283,17290,17291,17299,17334,17335,17337,17344,17348,17349,17355,17361,17369,17379,17393,17409,17424,17439,17445,17458,17476,17485,17496,17501,17511,17520,17529,17568,17571,17585,17590,17597,17603,17607,17626,17635,17640,17643,17646,17666,17705,17733,17763,17767,17772,17774,17782,17799,17816,17824,17831,17851,17857,17863,17869,17883,17885,17886,17918,17921,17939,17941,17947,17951,17952,17960,17965,17973,17991,17992,17999,18001,18053,18063,18079,18081,18082,18086,18096,18102,18110,18122,18126,18127,18133,18142,18143,18150,18158,18169,18174,18179,18212,18213,18220,18225,18227,18231,18239,18251,18257,18277,18284,18286,18301,18309,18311,18313,18317,18321,18343,18345,18353,18361,18362,18380,18401,18409,18426,18433,18435,18439,18441,18442,18466,18482,18490,18496,18501,18512,18516,18537,18538,18543,18548,18549,18558,18566,18569,18571,18573,18576,18580,18587,18598,18607,18617,18622,18630,18640,18641,18642,18649,18659,18661,18663,18671,18674,18675,18681,18690,18695,18701,18705,18712,18720,18730,18732,18735,18739,18744,18765,18769,18770,18775,18780,18792,18803,18805,18822,18845,18852,18861,18866,18870,18874,18881,18886,18892,18894,18898,18905,18911,18921,18936,18948,18953,18955,18970,18989,18993,18994,18999,19002,19010,19013,19024,19027,19028,19034,19040,19048,19049,19052,19074,19076,19101,19120,19130,19136,19150,19170,19178,19183,19184,19198,19213,19219,19222,19237,19243,19250,19254,19268,19276,19280,19281,19303,19305,19306,19321,19325,19326,19327,19328,19335,19358,19362,19370,19389,19390,19398,19426,19431,19438,19441,19442,19445,19454,19472,19484,19492,19495,19501,19503,19542,19553,19555,19566,19574,19582,19587,19591,19617,19620,19647,19651,19654,19662,19699,19708,19731,19748,19751,19756,19761,19762,19767,19772,19778,19781,19790,19811,19845,19851,19853,19858,19881,19898,19906,19927,19943,19947,19957,19962,19967,19972,19980,19994,20001,20003,20008,20027,20032,20035,20048,20059,20066,20067,20071,20081,20100,20111,20120,20139,20152,20153,20156,20166,20170,20187,20191,20195,20204,20212,20248,20250,20252,20254,20256,20271,20279,20287,20289,20295,20318,20343,20351,20360,20370,20379,20385,20386,20391,20399,20427,20443,20450,20486,20500,20518,20524,20526,20559,20567,20590,20592,20609,20617,20624,20632,20667,20670,20681,20683,20688,20700,20716,20721,20726,20727,20729,20752,20778,20780,20792,20799,20800,20804,20810,20830,20847,20883,20884,20885,20888,20894,20915,20945,20961,20986,20990,21002,21016,21062,21080,21103,21104,21105,21109,21115,21123,21126,21130,21151,21163,21182,21213,21229,21243,21254,21258,21259,21266,21268,21273,21282,21287,21294,21300,21301,21311,21313,21321,21327,21340,21341,21342,21365,21366,21368,21376,21377,21379,21393,21404,21412,21413,21416,21418,21419,21422,21430,21448,21454,21459,21467,21472,21474,21487,21489,21490,21508,21513,21526,21539,21547,21557,21563,21566,21574,21583,21588,21602,21604,21614,21623,21624,21633,21659,21664,21669,21695,21696,21721,21733,21734,21735,21738,21748,21757,21761,21767,21774,21791,21803,21843,21853,21870,21884,21885,21886,21894,21913,21914,21924,21950,21951,21952,21961,21962,21990,21998,22005,22009,22012,22031,22038,22045,22062,22071,22080,22081,22082,22085,22087,22106,22116,22132,22137,22140,22150,22156,22175,22176,22196,22206,22218,22221,22230,22232,22239,22241,22243,22257,22262,22267,22287,22289,22290,22292,22296,22339,22346,22354,22362,22365,22385,22409,22446,22481,22496,22498,22510,22514,22525,22528,22550,22564,22580,22593,22602,22614,22633,22647,22653,22655,22669,22693,22713,22736,22757,22771,22772,22793,22797,22804,22851,22861,22865,22871,22886,22908,22914,22924,22959,22972,22979,22989,23013,23023,23041,23072,23099,23107,23116,23121,23123,23132,23168,23191,23203,23214,23218,23222,23229,23240,23265,23268,23271,23275,23281,23302,23308,23310,23319,23332,23336,23345,23357,23364,23371,23382,23390,23396,23398,23400,23417,23437,23468,23469,23483,23495,23498,23542,23561,23596,23598,23618,23622,23628,23631,23632,23675,23685,23710,23722,23725,23729,23759,23791,23817,23849,23853,23854,23881,23885,23886,23887,23907,23913,23920,23922,23926,23942,23949,23964,23975,23989,23996,24008,24015,24062,24068,24085,24109,24124,24140,24146,24162,24171,24175,24185,24193,24209,24211,24223,24237,24249,24259,24279,24303,24307,24329,24331,24333,24343,24356,24361,24362,24379,24386,24393,24409,24413,24414,24437,24478,24485,24526,24538,24543,24569,24570,24579,24583,24587,24595,24650,24651,24703,24709,24736,24738,24764,24774,24785,24791,24799,24804,24816,24834,24846,24861,24862,24874,24915,24926,24930,24956,24983,24989,24990,24993,24997,25063,25072,25076,25095,25097,25137,25151,25171,25178,25180,25184,25225,25227,25255,25260,25270,25288,25294,25331,25335,25336,25351,25358,25369,25372,25418,25442,25453,25458,25475,25488,25490,25505,25506,25510,25512,25518,25538,25555,25557,25563,25589,25600,25608,25609,25642,25648,25685,25687,25690,25694,25716,25748,25766,25780,25791,25800,25809,25813,25821,25826,25864,25870,25874,25876,25890,25891,25922,25924,25941,25981,25991,25994,26000,26013,26017,26025,26056,26062,26073,26074,26099,26103,26118,26120,26125,26185,26203,26204,26226,26227,26244,26260,26283,26296,26321,26335,26336,26342,26343,26344,26346,26355,26359,26366,26367,26369,26386,26387,26392,26409,26420,26426,26434,26446,26452,26455,26486,26491,26496,26498,26505,26509,26520,26530,26544,26569,26579,26606,26609,26620,26623,26630,26634,26646,26656,26659,26674,26677,26680,26689,26691,26699,26702,26706,26727,26731,26739,26765,26772,26780,26784,26790,26802,26811,26814,26820,26845,26881,26898,26900,26918,26927,26928,26945,26946,26956,26968,26971,26973,26990,27021,27022,27045,27057,27075,27076,27126,27132,27183,27184,27187,27199,27208,27222,27236,27258,27279,27303,27320,27326,27345,27347,27354,27366,27372,27386,27396,27401,27403,27449,27454,27466,27473,27479,27492,27496,27510,27512,27518,27530,27541,27562,27563,27570,27582,27583,27592,27604,27605,27612,27616,27623,27627,27628,27636,27650,27654,27655,27671,27677,27686,27692,27739,27749,27761,27789,27806,27808,27828,27890,27910,27916,27919,27922,27937,27946,28021,28032,28067,28115,28127,28158,28187,28195,28214,28218,28280,28300,28329,28351,28366,28403,28441,28468,28531,28601,28636,28671,28673,28709,28718,28786,28846,28973,28984,28993,29002,29019,29020,29053,29061,29101,29121,29142,29155,29171,29218,29334,29349,29359,29365,29382,29394,29405,29406,29411,29444,29460,29503,29517,29563,29568,29642,29644,29655,29681,29720,29759,29791,29814,29835,29837,29839,29898,29915,29918,30194,30325,30486,30988,31551,31640,31798,31853,32182,32644,33416,33417,33749,34699,35095,35153,35214,35234,35384,35585,35639,35640,35643,35653,35741,35744,35750,35752,35778,35865,36051,36075,36130,36196,36208,36267,36292,36299,36315,36341,36581,36584,36591,36594,36598,36604,36769,37083,37759,38362,38610,38613,38652,38777,38912,38946,38962,38971,39041,39051,39171,39224,39225,39240,39321,39483,39571,39590,39600,39682,39697,39790,39821,39967,40034,40096,40258,40385,40386,40387,40456,40647,40742,40811,40835,40983,41068,41148,41171,41186,41292,41298,41376,41442,42036,42310,42602,43018,43425,43426,44509,44906,44914,44915,45227)
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 | 2506 | 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.11 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.44 ms |
System lock | 0.02 ms |
optimizing | 0.15 ms |
statistics | 3.92 ms |
preparing | 1.96 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 4.49 ms |
end | 0.03 ms |
query end | 0.04 ms |
closing tables | 0.02 ms |
freeing items | 0.14 ms |
cleaning up | 0.04 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 |