Tiempo de la consulta: 16.28 ms Después de la última consulta: 2.62 ms Consulta a la memoria: 1.276 MB memoria antes de la consulta: 4.508 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-07 02:09:47')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 02:09:47')
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,9,10,11,25,28,47,49,56,58,60,65,66,86,154,157,165,193,203,205,207,208,218,219,255,257,263,271,275,276,282,293,311,321,332,368,437,446,458,463,466,471,472,478,510,521,558,560,583,593,607,610,611,613,618,643,669,671,680,686,695,701,709,713,723,729,757,758,761,772,783,786,816,845,857,868,879,883,892,895,898,900,911,915,917,920,955,958,963,968,973,986,1010,1027,1031,1032,1033,1042,1048,1057,1089,1094,1096,1098,1127,1142,1151,1158,1186,1207,1210,1214,1226,1234,1240,1271,1279,1280,1284,1291,1295,1322,1324,1335,1338,1339,1345,1349,1375,1398,1413,1420,1421,1425,1433,1435,1441,1444,1445,1447,1454,1455,1459,1460,1476,1481,1484,1486,1490,1504,1506,1534,1551,1553,1586,1595,1600,1601,1624,1664,1666,1718,1810,1811,1812,1815,1841,1852,1855,1903,1906,1943,1956,1984,2001,2066,2077,2094,2148,2193,2199,2290,2293,2301,2305,2359,2365,2432,2469,2480,2629,2631,2632,2639,2641,2688,2691,2724,2767,2773,2796,2834,2843,2863,2902,2964,2989,3022,3025,3056,3067,3087,3176,3202,3254,3278,3295,3312,3327,3353,3355,3385,3390,3417,3448,3451,3490,3512,3513,3546,3571,3572,3590,3594,3604,3663,3696,3706,3725,3864,3872,3916,3925,3938,3986,3992,4015,4039,4055,4060,4063,4075,4087,4090,4092,4095,4096,4098,4100,4131,4132,4144,4153,4163,4165,4168,4177,4197,4203,4227,4252,4271,4276,4281,4294,4337,4389,4392,4395,4457,4496,4511,4523,4524,4525,4539,4549,4558,4559,4580,4585,4586,4602,4605,4660,4665,4758,4760,4765,4773,4790,4795,4822,4874,4878,4892,4902,4912,4919,4930,4949,4960,4983,5001,5014,5035,5050,5076,5079,5085,5100,5143,5157,5161,5166,5199,5203,5218,5226,5240,5250,5300,5301,5306,5350,5365,5428,5432,5435,5451,5462,5470,5473,5496,5534,5633,5639,5642,5647,5648,5659,5675,5694,5700,5713,5719,5725,5730,5788,5800,5819,5876,5894,5918,5931,5934,5936,5979,5990,6007,6039,6043,6050,6055,6064,6066,6068,6074,6081,6097,6116,6127,6133,6177,6178,6192,6200,6202,6217,6264,6270,6272,6291,6298,6308,6323,6328,6329,6330,6332,6340,6347,6350,6374,6376,6388,6396,6405,6421,6427,6428,6435,6442,6448,6455,6456,6460,6461,6462,6465,6468,6470,6471,6473,6475,6492,6494,6495,6497,6499,6500,6502,6512,6515,6517,6521,6533,6534,6542,6543,6545,6546,6553,6568,6573,6576,6578,6583,6596,6598,6601,6603,6608,6630,6636,6645,6648,6654,6655,6656,6657,6658,6659,6662,6663,6667,6688,6695,6703,6707,6711,6718,6723,6724,6725,6734,6742,6744,6749,6762,6764,6776,6778,6779,6788,6789,6790,6805,6806,6809,6827,6835,6838,6842,6843,6847,6860,6868,6869,6871,6872,6873,6875,6876,6879,6882,6889,6895,6903,6904,6906,6910,6914,6915,6916,6925,6927,6928,6932,6936,6940,6942,6945,6956,6957,6968,6985,6986,6990,6992,6994,6995,7009,7011,7015,7016,7020,7043,7045,7059,7100,7102,7122,7125,7134,7135,7138,7150,7154,7155,7156,7160,7161,7170,7171,7173,7176,7178,7179,7182,7200,7201,7212,7213,7232,7237,7241,7243,7246,7248,7249,7267,7268,7270,7272,7277,7279,7282,7283,7285,7289,7311,7313,7314,7320,7327,7328,7330,7333,7334,7338,7343,7344,7346,7358,7361,7367,7368,7370,7371,7372,7374,7376,7377,7378,7379,7380,7389,7397,7406,7407,7408,7410,7411,7413,7414,7415,7417,7418,7421,7427,7428,7430,7431,7432,7435,7436,7443,7447,7449,7450,7453,7457,7458,7459,7461,7462,7464,7465,7469,7478,7483,7484,7488,7489,7494,7495,7513,7514,7516,7523,7542,7545,7546,7547,7548,7550,7551,7552,7553,7555,7567,7570,7571,7577,7578,7583,7586,7588,7611,7615,7616,7618,7623,7626,7666,7674,7675,7677,7678,7681,7682,7683,7686,7688,7689,7690,7691,7708,7709,7711,7713,7715,7720,7722,7726,7728,7730,7737,7743,7744,7746,7748,7749,7757,7758,7764,7765,7768,7769,7773,7774,7780,7787,7794,7797,7802,7804,7806,7808,7810,7817,7824,7829,7831,7832,7833,7834,7835,7836,7839,7840,7841,7845,7855,7862,7863,7864,7866,7868,7870,7871,7877,7878,7891,7894,7895,7900,7901,7918,7919,7920,7923,7928,7930,7931,7934,7940,7946,7950,7955,7957,7959,7960,7961,7962,7963,7979,7982,7987,7994,7997,8007,8017,8020,8021,8022,8026,8027,8028,8036,8048,8049,8056,8062,8064,8067,8069,8070,8071,8072,8073,8082,8083,8090,8091,8099,8103,8106,8108,8109,8111,8116,8134,8135,8138,8139,8140,8141,8143,8157,8177,8198,8199,8200,8206,8230,8258,8272,8283,8289,8298,8311,8323,8330,8334,8341,8345,8346,8351,8361,8399,8400,8452,8489,8508,8510,8559,8598,8608,8619,8627,8639,8641,8649,8655,8658,8665,8695,8700,8702,8738,8755,8761,8765,8770,8778,8794,8808,8823,8828,8829,8856,8870,8871,8907,8926,8938,8953,8973,8982,9020,9041,9058,9065,9068,9101,9108,9122,9127,9128,9132,9147,9192,9254,9260,9300,9308,9355,9406,9449,9462,9472,9476,9478,9489,9514,9542,9548,9556,9558,9561,9562,9565,9569,9592,9594,9602,9675,9690,9714,9717,9724,9730,9734,9759,9762,9783,9794,9826,9832,9841,9843,9879,9886,9891,9893,9896,9910,9911,9919,9941,9951,9956,9961,10004,10017,10083,10110,10118,10149,10176,10184,10192,10197,10199,10203,10207,10208,10209,10221,10250,10264,10265,10291,10297,10306,10311,10316,10322,10332,10349,10352,10371,10379,10395,10398,10399,10401,10418,10436,10450,10464,10473,10475,10480,10485,10499,10534,10537,10543,10553,10556,10560,10600,10613,10616,10629,10631,10645,10646,10650,10660,10663,10672,10681,10692,10697,10710,10725,10736,10754,10775,10811,10833,10834,10835,10872,10932,10941,10951,10954,10969,10974,10986,11009,11015,11027,11041,11043,11063,11065,11083,11098,11099,11106,11126,11150,11151,11163,11173,11192,11195,11209,11226,11229,11231,11235,11238,11258,11263,11289,11295,11314,11377,11394,11416,11428,11473,11479,11505,11534,11538,11548,11581,11592,11666,11680,11705,11712,11713,11716,11766,11775,11795,11842,11849,11867,11868,11870,11875,11879,11883,11885,11904,11907,11926,11934,11987,12002,12011,12013,12024,12036,12042,12046,12069,12085,12131,12136,12152,12170,12171,12184,12238,12306,12317,12319,12334,12340,12358,12362,12370,12412,12439,12440,12448,12449,12474,12499,12514,12520,12545,12551,12588,12604,12609,12624,12625,12636,12651,12652,12670,12676,12708,12738,12743,12758,12789,12816,12822,12841,12849,12857,12894,12910,12921,12945,12946,12953,12960,12994,13026,13078,13090,13107,13132,13152,13160,13164,13187,13222,13225,13241,13250,13258,13266,13272,13290,13297,13316,13344,13345,13359,13379,13396,13428,13430,13436,13437,13438,13440,13446,13455,13458,13467,13478,13479,13480,13481,13482,13502,13503,13505,13506,13508,13525,13528,13552,13588,13589,13594,13597,13611,13656,13660,13664,13685,13697,13698,13708,13753,13777,13784,13794,13797,13851,13855,13884,13892,13968,13972,13998,14040,14048,14052,14078,14084,14092,14095,14097,14108,14110,14114,14118,14133,14140,14146,14175,14177,14183,14189,14195,14196,14198,14199,14205,14224,14232,14234,14236,14240,14244,14261,14268,14276,14305,14309,14318,14349,14353,14355,14357,14361,14367,14378,14383,14421,14426,14429,14432,14440,14445,14448,14451,14480,14493,14502,14505,14507,14524,14528,14531,14533,14546,14622,14637,14641,14646,14653,14654,14681,14682,14684,14685,14691,14699,14701,14710,14726,14745,14748,14749,14750,14765,14773,14792,14798,14811,14818,14827,14842,14848,14856,14864,14870,14871,14874,14899,14943,14947,14949,14955,14958,14982,15002,15038,15048,15049,15060,15063,15065,15076,15092,15105,15107,15115,15116,15123,15130,15138,15147,15148,15166,15178,15180,15206,15216,15217,15226,15229,15244,15247,15251,15253,15257,15284,15298,15299,15302,15304,15310,15319,15325,15333,15335,15338,15344,15358,15368,15371,15375,15390,15403,15410,15417,15420,15432,15438,15443,15453,15482,15483,15489,15492,15493,15500,15503,15521,15533,15542,15543,15551,15560,15577,15578,15580,15598,15599,15609,15628,15631,15632,15637,15639,15642,15645,15647,15655,15656,15678,15681,15693,15705,15720,15722,15723,15728,15733,15745,15746,15757,15759,15761,15762,15770,15777,15780,15784,15788,15808,15811,15813,15832,15835,15840,15866,15878,15879,15896,15903,15912,15925,15935,15938,15954,15982,15993,16008,16024,16028,16031,16036,16048,16052,16055,16086,16101,16141,16156,16167,16181,16217,16231,16233,16257,16258,16261,16279,16288,16295,16328,16336,16348,16353,16354,16359,16366,16368,16372,16378,16386,16389,16404,16415,16431,16432,16436,16446,16447,16458,16461,16466,16471,16475,16515,16518,16520,16529,16538,16569,16586,16607,16613,16627,16629,16634,16645,16653,16658,16659,16662,16666,16682,16768,16770,16774,16775,16778,16780,16791,16792,16795,16820,16822,16823,16826,16830,16850,16854,16866,16886,16893,16900,16909,16958,16964,16967,16987,16996,17059,17072,17096,17121,17126,17131,17149,17158,17160,17177,17185,17190,17210,17214,17224,17227,17228,17242,17243,17247,17269,17275,17277,17282,17285,17299,17344,17346,17354,17355,17383,17384,17390,17396,17407,17424,17437,17441,17452,17460,17478,17485,17498,17500,17510,17512,17536,17555,17566,17573,17574,17583,17596,17602,17615,17620,17633,17634,17645,17650,17652,17667,17668,17699,17701,17702,17705,17707,17709,17713,17716,17718,17733,17738,17753,17756,17759,17761,17763,17766,17772,17774,17778,17780,17783,17809,17810,17816,17817,17824,17844,17852,17857,17869,17885,17888,17892,17918,17923,17925,17927,17950,17951,17973,17991,18006,18037,18055,18102,18121,18160,18174,18179,18202,18220,18221,18227,18231,18238,18248,18276,18277,18290,18294,18300,18311,18315,18317,18345,18352,18353,18356,18366,18382,18401,18404,18409,18419,18434,18435,18451,18466,18505,18512,18518,18520,18530,18537,18540,18541,18550,18562,18586,18595,18603,18610,18619,18643,18663,18668,18670,18671,18682,18694,18695,18698,18701,18730,18732,18739,18744,18750,18753,18775,18786,18792,18797,18813,18821,18832,18846,18852,18861,18869,18872,18874,18878,18907,18909,18920,18931,18936,18940,18941,18945,18948,18960,18966,18968,18972,18973,18985,18986,18987,18993,19003,19007,19026,19027,19034,19043,19048,19049,19051,19061,19063,19064,19076,19088,19100,19106,19133,19135,19136,19151,19163,19170,19172,19173,19175,19179,19183,19191,19196,19205,19207,19213,19222,19224,19247,19285,19288,19307,19309,19313,19318,19322,19335,19343,19349,19352,19353,19358,19382,19383,19405,19407,19412,19422,19426,19437,19444,19457,19479,19484,19492,19503,19505,19516,19519,19558,19562,19566,19575,19591,19604,19619,19626,19640,19645,19646,19651,19666,19674,19697,19727,19748,19752,19773,19778,19787,19790,19792,19797,19806,19816,19832,19851,19853,19858,19874,19906,19925,19933,19943,19944,19947,19957,19962,19974,19976,19979,19981,20000,20004,20008,20020,20033,20035,20051,20056,20089,20098,20099,20117,20127,20131,20134,20135,20149,20158,20166,20174,20181,20202,20204,20205,20208,20218,20220,20233,20242,20256,20265,20279,20281,20282,20299,20305,20317,20328,20332,20333,20344,20352,20359,20397,20399,20404,20408,20419,20420,20437,20441,20452,20457,20465,20472,20486,20487,20489,20504,20527,20537,20541,20549,20554,20568,20569,20587,20608,20632,20641,20648,20654,20658,20668,20670,20681,20686,20712,20714,20716,20729,20730,20731,20739,20753,20773,20776,20780,20782,20785,20787,20792,20797,20803,20841,20849,20866,20877,20886,20889,20897,20912,20933,20956,20973,20974,20993,21002,21012,21013,21017,21055,21063,21067,21085,21086,21108,21113,21121,21128,21133,21149,21163,21181,21189,21197,21205,21209,21216,21231,21258,21259,21262,21265,21273,21280,21284,21294,21296,21297,21312,21323,21324,21327,21343,21346,21347,21351,21366,21387,21396,21408,21411,21413,21420,21425,21429,21436,21437,21438,21475,21482,21491,21527,21542,21547,21566,21578,21579,21585,21588,21601,21610,21611,21614,21620,21627,21628,21665,21667,21683,21689,21691,21696,21700,21703,21713,21716,21734,21742,21750,21779,21798,21846,21852,21859,21871,21878,21884,21886,21913,21924,21927,21950,21957,21967,21990,21994,22002,22009,22011,22023,22031,22038,22051,22053,22088,22089,22095,22098,22122,22124,22137,22145,22146,22150,22171,22179,22209,22212,22214,22219,22230,22243,22247,22266,22290,22292,22296,22297,22305,22316,22326,22339,22362,22365,22378,22380,22389,22400,22415,22416,22439,22464,22485,22493,22498,22509,22546,22550,22553,22558,22564,22600,22608,22614,22619,22668,22671,22672,22681,22690,22691,22706,22710,22722,22725,22744,22753,22779,22786,22822,22834,22854,22857,22864,22871,22872,22873,22898,22901,22918,22936,22946,22948,22959,22988,22989,22998,23002,23013,23016,23023,23026,23031,23032,23033,23039,23040,23041,23046,23047,23070,23079,23100,23101,23114,23121,23148,23153,23181,23202,23203,23207,23209,23221,23224,23253,23260,23265,23267,23277,23278,23284,23288,23296,23299,23305,23308,23310,23313,23319,23338,23363,23371,23383,23394,23396,23400,23406,23423,23437,23453,23459,23468,23488,23501,23505,23512,23516,23542,23543,23547,23566,23578,23584,23592,23593,23602,23606,23615,23624,23626,23631,23634,23664,23666,23667,23670,23685,23686,23691,23695,23701,23705,23715,23726,23730,23731,23747,23756,23759,23780,23790,23816,23838,23840,23855,23868,23873,23876,23898,23911,23926,23954,23968,23978,23989,23990,24002,24008,24015,24017,24020,24024,24025,24061,24082,24114,24118,24124,24140,24147,24162,24190,24193,24196,24198,24201,24202,24206,24210,24211,24219,24237,24238,24279,24316,24329,24340,24347,24348,24352,24362,24403,24409,24411,24429,24432,24433,24440,24441,24447,24451,24455,24456,24485,24486,24525,24538,24557,24558,24566,24567,24597,24599,24616,24630,24644,24647,24650,24657,24671,24672,24673,24679,24681,24701,24726,24732,24734,24740,24748,24764,24774,24775,24782,24784,24790,24794,24807,24819,24830,24836,24841,24845,24846,24862,24867,24872,24875,24884,24887,24922,24924,24941,24945,24956,24966,24967,24977,24983,25010,25038,25039,25041,25046,25048,25076,25080,25096,25103,25134,25137,25139,25141,25144,25146,25163,25172,25194,25197,25200,25218,25224,25225,25255,25258,25263,25269,25278,25284,25287,25292,25294,25315,25335,25353,25369,25372,25373,25380,25386,25406,25412,25418,25451,25452,25461,25469,25474,25478,25483,25510,25512,25513,25516,25531,25535,25538,25540,25542,25554,25556,25560,25561,25563,25583,25590,25591,25600,25609,25621,25655,25657,25663,25693,25746,25753,25790,25792,25813,25817,25822,25881,25888,25911,25934,25943,25952,25964,25990,26038,26043,26073,26074,26102,26109,26116,26154,26157,26161,26166,26167,26171,26174,26191,26203,26207,26209,26225,26234,26236,26238,26247,26249,26271,26322,26344,26346,26348,26353,26355,26356,26366,26387,26392,26414,26420,26432,26434,26452,26468,26481,26483,26488,26519,26522,26525,26530,26560,26562,26586,26594,26598,26685,26701,26722,26756,26780,26797,26807,26815,26827,26852,26861,26897,26901,26909,26924,26934,26936,26944,26945,26950,26951,26964,26986,27024,27028,27035,27040,27041,27046,27054,27059,27074,27075,27079,27085,27086,27096,27127,27128,27139,27171,27237,27249,27274,27279,27280,27311,27355,27367,27368,27383,27390,27397,27403,27404,27405,27407,27414,27415,27420,27423,27442,27471,27491,27518,27563,27567,27601,27610,27655,27656,27663,27683,27692,27695,27724,27739,27758,27887,27893,27898,27903,27999,28067,28088,28115,28116,28135,28185,28242,28294,28530,28539,28609,28617,28628,28651,28673,28712,28714,28715,28716,28718,28746,28799,28825,28928,28973,28984,28992,29004,29005,29014,29021,29034,29037,29089,29142,29348,29359,29373,29381,29382,29405,29412,29413,29444,29445,29467,29473,29489,29499,29500,29550,29551,29655,29658,29683,29694,29716,29759,29788,29801,29810,29837,29839,29872,29873,29896,29897,29915,29918,30284,30325,30414,30941,31010,31090,31510,31837,32182,33099,33385,33417,34150,34239,35102,35653,35722,35740,35741,36085,36141,36200,36297,36751,37139,37141,38398,38887,38961,39063,39193,39276,39315,39323,39342,39347,39375,39451,39722,39747,39768,39802,39846,39877,40064,40198,40347,40351,40465,40521,40535,40583,40614,40672,40861,40909,41104,41150,41220,41436,41800,42036,42057,42065,42154,42163,42174,42188,42304,42405,42448,42490,42729,42806,42863,43009,43115,43143,43222,43234,43244,43345,43550,43601,43605,43615,43682,43846,43979,44184,44351,44491,44509,44588,44613,44701,44894,44908,45051,45302,45303)
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 | 2751 | 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.23 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.49 ms |
System lock | 0.02 ms |
optimizing | 0.16 ms |
statistics | 4.33 ms |
preparing | 2.32 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 6.41 ms |
end | 0.03 ms |
query end | 0.05 ms |
closing tables | 0.03 ms |
freeing items | 0.16 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 |