Tiempo de la consulta: 9.23 ms Después de la última consulta: 2.56 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 4.518 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 21:51:33')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 21:51:33')
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(1,11,17,49,58,75,83,154,204,255,274,325,332,353,405,441,446,458,478,485,497,510,512,521,529,531,537,542,547,558,559,560,566,567,593,607,618,671,686,695,723,729,752,756,757,760,806,816,845,850,868,879,886,911,915,933,955,970,977,986,992,1010,1027,1033,1057,1066,1080,1094,1154,1158,1186,1207,1210,1214,1226,1234,1240,1265,1277,1306,1318,1335,1339,1347,1600,1664,1698,1734,1768,1892,2043,2094,2123,2733,2805,2964,3022,3202,3295,3322,3353,3409,3520,3546,3584,3696,3706,3725,3841,3864,3884,3898,3940,3993,4063,4096,4116,4131,4153,4163,4210,4276,4281,4309,4389,4409,4410,4436,4442,4445,4453,4471,4597,4692,4765,4790,5001,5020,5085,5150,5223,5237,5300,5306,5433,5515,5647,5648,5659,5817,5894,5896,5918,6186,6289,6290,6448,6520,6592,6598,6681,6684,6703,6752,6775,6806,6809,6828,6916,6941,6994,7105,7117,7173,7212,7243,7276,7277,7285,7321,7327,7338,7346,7407,7418,7449,7462,7513,7516,7551,7577,7583,7624,7625,7666,7679,7730,7757,7764,7810,7829,7840,7851,7871,7901,7913,7965,8027,8053,8106,8138,8177,8258,8351,8416,8445,8610,8663,8864,8973,9118,9146,9197,9253,9254,9300,9472,9473,9531,9532,9580,9667,9702,9734,9772,9832,9851,9886,9891,9956,10024,10050,10077,10079,10149,10197,10198,10199,10207,10266,10284,10289,10290,10303,10317,10349,10350,10387,10401,10445,10464,10486,10499,10516,10518,10537,10557,10592,10690,10731,10778,10806,10831,10833,10932,10986,11009,11027,11043,11087,11124,11144,11150,11182,11238,11263,11273,11377,11392,11447,11473,11494,11538,11542,11666,11679,11680,11692,11713,11716,11775,11783,11840,11870,11879,11880,11926,12011,12036,12042,12069,12085,12131,12136,12152,12216,12308,12317,12319,12338,12339,12362,12363,12366,12370,12448,12490,12514,12588,12604,12621,12636,12670,12676,12685,12738,12745,12757,12758,12783,12810,12849,12908,12910,12920,12960,12965,12977,12983,13052,13071,13107,13132,13203,13222,13235,13250,13287,13345,13359,13379,13396,13440,13446,13481,13490,13594,13651,13664,13697,13708,13721,13727,13728,13753,13892,13985,13987,14011,14040,14068,14069,14078,14087,14092,14109,14133,14139,14163,14175,14198,14199,14205,14227,14232,14234,14252,14255,14268,14305,14355,14378,14393,14421,14451,14480,14493,14502,14505,14523,14531,14557,14591,14596,14610,14637,14654,14679,14691,14699,14701,14774,14778,14798,14888,14895,14926,14955,14979,14982,15002,15015,15020,15060,15065,15092,15105,15107,15114,15115,15123,15144,15148,15180,15206,15217,15226,15256,15257,15284,15292,15297,15299,15304,15325,15336,15344,15358,15371,15403,15410,15417,15438,15441,15443,15445,15455,15483,15492,15500,15551,15570,15577,15580,15609,15632,15637,15639,15640,15642,15656,15709,15733,15745,15760,15762,15766,15788,15811,15832,15835,15840,15877,15878,15879,15892,15954,16005,16014,16024,16052,16053,16054,16125,16126,16156,16164,16167,16187,16217,16261,16277,16279,16295,16328,16336,16342,16353,16359,16368,16389,16404,16408,16410,16424,16436,16447,16458,16470,16518,16554,16558,16607,16613,16627,16635,16642,16659,16662,16682,16691,16698,16737,16778,16792,16794,16815,16820,16831,16843,16844,16866,16876,16893,16909,16964,17001,17043,17059,17072,17098,17107,17133,17136,17149,17158,17167,17168,17185,17189,17214,17247,17269,17279,17280,17341,17346,17353,17354,17364,17381,17390,17403,17412,17417,17424,17435,17441,17452,17460,17463,17485,17498,17500,17512,17536,17543,17574,17585,17596,17597,17617,17620,17630,17631,17633,17650,17689,17700,17701,17704,17705,17729,17732,17733,17753,17758,17759,17761,17772,17774,17783,17784,17816,17824,17844,17877,17885,17907,17918,17935,17951,17954,17973,17989,17990,18001,18055,18102,18117,18158,18160,18176,18179,18217,18220,18221,18231,18234,18238,18263,18277,18300,18315,18337,18345,18352,18353,18361,18364,18366,18401,18427,18434,18435,18455,18485,18520,18527,18537,18547,18565,18576,18581,18586,18591,18643,18648,18716,18723,18732,18744,18750,18792,18808,18809,18817,18821,18846,18862,18898,18909,18920,18925,18936,18938,18957,18960,18972,18973,18986,18993,18997,19027,19060,19063,19106,19108,19120,19134,19136,19151,19172,19179,19191,19205,19217,19224,19247,19251,19270,19274,19285,19303,19309,19313,19331,19352,19360,19368,19377,19383,19405,19413,19419,19422,19433,19437,19440,19445,19453,19457,19472,19484,19487,19492,19494,19504,19522,19552,19556,19560,19562,19566,19593,19604,19619,19625,19626,19630,19651,19666,19680,19695,19697,19720,19730,19747,19748,19752,19763,19766,19778,19779,19790,19806,19864,19865,19874,19925,19943,19944,19955,19957,19987,19988,19999,20007,20008,20035,20042,20076,20083,20098,20117,20146,20158,20166,20167,20199,20204,20205,20229,20233,20236,20242,20279,20282,20299,20305,20328,20332,20333,20344,20352,20359,20362,20384,20399,20404,20419,20420,20422,20427,20437,20457,20479,20487,20489,20537,20539,20554,20574,20605,20608,20691,20712,20724,20750,20751,20753,20765,20769,20774,20776,20780,20782,20785,20787,20795,20799,20817,20826,20835,20841,20877,20886,20912,20915,20924,20947,20950,20956,20974,21010,21013,21017,21055,21067,21085,21086,21105,21108,21121,21128,21130,21133,21139,21149,21152,21163,21181,21184,21198,21231,21242,21258,21293,21311,21324,21366,21387,21396,21415,21423,21452,21465,21482,21518,21542,21547,21548,21566,21606,21628,21662,21665,21683,21689,21713,21716,21742,21750,21766,21775,21794,21811,21849,21859,21878,21967,21994,22031,22053,22088,22089,22122,22126,22137,22204,22214,22219,22225,22247,22248,22266,22268,22292,22316,22348,22350,22366,22378,22380,22382,22395,22419,22424,22431,22485,22493,22498,22530,22546,22553,22559,22607,22642,22645,22666,22668,22670,22671,22681,22691,22720,22740,22744,22753,22766,22779,22786,22793,22822,22834,22857,22873,22875,22898,22906,22918,22921,22933,22934,22935,22936,22942,22976,22998,23002,23006,23013,23017,23026,23039,23047,23050,23080,23103,23126,23151,23181,23202,23224,23254,23260,23271,23278,23288,23310,23319,23338,23343,23354,23380,23396,23400,23417,23445,23466,23468,23477,23495,23512,23516,23543,23575,23584,23589,23621,23624,23651,23659,23665,23667,23677,23686,23693,23705,23719,23726,23731,23740,23756,23761,23768,23780,23782,23785,23792,23806,23816,23827,23855,23869,23873,23874,23876,23911,23914,23935,23965,23978,23989,23998,24001,24002,24014,24059,24082,24114,24126,24171,24176,24190,24201,24202,24210,24212,24260,24281,24299,24340,24373,24432,24470,24485,24543,24567,24596,24608,24630,24637,24657,24659,24671,24672,24673,24681,24718,24734,24754,24780,24783,24790,24807,24836,24841,24845,24851,24857,24887,24905,24922,24927,24942,24945,24960,24967,24981,24995,25038,25041,25049,25090,25103,25104,25119,25137,25141,25143,25146,25154,25163,25199,25200,25207,25218,25252,25258,25260,25280,25290,25315,25345,25353,25366,25373,25380,25435,25461,25469,25474,25478,25483,25486,25502,25513,25540,25554,25556,25583,25595,25600,25615,25616,25650,25663,25746,25753,25778,25790,25813,25822,25844,25846,25886,25911,25952,26024,26073,26103,26116,26157,26174,26191,26207,26209,26225,26236,26238,26247,26271,26293,26322,26324,26338,26344,26355,26370,26372,26387,26389,26392,26405,26420,26431,26432,26434,26452,26479,26481,26513,26522,26560,26562,26589,26594,26598,26605,26609,26635,26654,26701,26776,26780,26792,26835,26857,26873,26897,26924,26934,26936,26939,26965,27003,27008,27015,27020,27024,27028,27040,27055,27075,27076,27085,27093,27096,27127,27139,27149,27234,27248,27249,27279,27298,27355,27356,27368,27390,27403,27420,27438,27442,27453,27477,27563,27566,27572,27576,27582,27641,27720,27724,27739,27799,27822,27893,27898,27991,28007,28116,28135,28177,28185,28242,28294,28316,28329,28441,28445,28446,28539,28609,28617,28651,28712,28714,28715,28910,28922,28992,29023,29034,29057,29089,29123,29343,29348,29381,29413,29445,29466,29467,29499,29550,29551,29584,29607,29639,29658,29683,29757,29788,29801,29834,29837,29839,29872,29896,29897,29909,29915,29918,30111,30414,30941,31090,31510,31614,31837,32136,33385,33707,33932,34039,34150,34214,34239,34249,34273,34655,34851,35049,35250,35444,35730,35741,35803,35921,35926,35948,35989,36015,36017,36025,36041,36112,36141,36220,36235,36338,36373,36380,36385,36386,36400,36433,36464,36541,36555,36574,36633,36635,36659,36662,36666,36669,36670,36704,36713,36759,36790,36791,36792,36793,36797,36820,36826,36852,36889,36905,36929,36930,36931,36933,36936,36958,36960,36971,36973,36984,36989,36991,36998,37011,37015,37018,37038,37072,37095,37104,37105,37136,37149,37166,37196,37212,37242,37245,37257,37261,37273,37283,37298,37315,37328,37332,37358,37392,37410,37429,37435,37458,37460,37473,37474,37534,37543,37544,37547,37548,37554,37568,37626,37627,37631,37642,37643,37644,37656,37668,37669,37670,37671,37672,37675,37676,37677,37685,37686,37687,37710,37740,37747,37757,37759,37767,37786,37787,37801,37834,37845,37853,37864,37866,37867,37872,37873,37875,37902,37911,37914,37915,37918,37940,37997,38032,38044,38046,38047,38058,38070,38086,38101,38104,38117,38124,38126,38133,38165,38175,38178,38188,38195,38203,38238,38240,38242,38244,38246,38267,38276,38278,38289,38302,38329,38330,38338,38343,38346,38362,38368,38370,38390,38391,38406,38409,38418,38419,38422,38423,38441,38453,38465,38468,38470,38489,38490,38491,38506,38512,38526,38527,38532,38543,38567,38580,38590,38611,38617,38618,38641,38647,38672,38676,38681,38687,38688,38690,38693,38711,38716,38720,38723,38728,38734,38737,38749,38753,38758,38764,38765,38767,38775,38781,38782,38783,38787,38789,38792,38794,38797,38800,38821,38823,38824,38826,38829,38838,38851,38852,38877,38887,38888,38889,38891,38902,38904,38907,38912,38916,38922,38949,38955,38957,38958,38965,38966,38975,38981,38983,38985,38989,38990,39019,39020,39023,39024,39038,39039,39054,39055,39059,39080,39090,39094,39103,39110,39114,39117,39118,39133,39134,39135,39137,39139,39140,39148,39152,39155,39160,39175,39178,39184,39199,39205,39212,39224,39228,39240,39241,39244,39247,39256,39260,39263,39271,39272,39285,39290,39293,39296,39297,39318,39320,39325,39326,39337,39342,39345,39346,39357,39366,39369,39376,39381,39398,39400,39425,39430,39442,39448,39451,39454,39460,39470,39476,39485,39508,39513,39517,39519,39532,39534,39541,39545,39546,39547,39548,39575,39578,39582,39591,39604,39610,39625,39630,39633,39634,39637,39653,39663,39676,39678,39686,39701,39702,39717,39718,39724,39736,39739,39754,39766,39767,39770,39792,39811,39815,39822,39824,39828,39836,39846,39847,39850,39856,39858,39873,39877,39883,39887,39919,39920,39932,39934,39941,39948,39951,39974,39987,39992,39993,39998,40003,40008,40015,40040,40050,40055,40056,40059,40064,40067,40073,40080,40088,40103,40105,40111,40118,40143,40164,40173,40184,40214,40263,40267,40275,40285,40291,40302,40316,40319,40325,40334,40335,40337,40341,40345,40367,40379,40405,40412,40426,40453,40521,40526,40544,40561,40601,40624,40638,40645,40672,40673,40675,40692,40704,40706,40714,40721,40722,40723,40738,40772,40806,40815,40824,40853,40855,40859,40861,40872,40878,40879,40885,40888,40896,40897,40909,40927,40940,40953,40965,40968,40975,40976,40987,40996,40997,41004,41009,41033,41042,41073,41079,41084,41096,41104,41105,41109,41110,41123,41137,41142,41151,41155,41157,41171,41172,41175,41176,41178,41181,41186,41187,41189,41192,41194,41197,41198,41201,41213,41216,41225,41227,41229,41231,41245,41262,41272,41281,41282,41289,41297,41300,41303,41308,41314,41315,41329,41331,41332,41337,41343,41345,41352,41358,41370,41374,41379,41383,41384,41391,41415,41427,41434,41440,41446,41451,41453,41459,41477,41483,41485,41487,41488,41492,41504,41505,41506,41510,41516,41517,41531,41532,41535,41537,41541,41544,41550,41551,41554,41564,41571,41577,41588,41597,41602,41604,41605,41610,41612,41618,41626,41632,41647,41651,41660,41663,41683,41705,41712,41720,41726,41732,41735,41738,41739,41752,41759,41773,41781,41783,41785,41811,41821,41822,41828,41841,41848,41851,41863,41870,41875,41925,41928,41933,41939,41948,41959,41964,41969,41973,41981,41999,42012,42024,42037,42042,42043,42059,42076,42086,42102,42113,42124,42130,42131,42138,42146,42148,42160,42173,42182,42184,42191,42193,42209,42220,42232,42233,42234,42246,42247,42251,42261,42275,42279,42280,42282,42285,42289,42295,42302,42312,42329,42337,42349,42358,42363,42377,42380,42393,42413,42425,42427,42430,42433,42435,42437,42446,42467,42473,42478,42482,42489,42492,42504,42505,42516,42523,42527,42530,42541,42548,42551,42552,42555,42557,42574,42611,42614,42617,42625,42637,42642,42650,42654,42655,42664,42677,42718,42748,42749,42754,42768,42774,42776,42780,42789,42795,42802,42809,42811,42821,42824,42826,42831,42834,42839,42843,42845,42857,42858,42866,42893,42902,42903,42911,42912,42939,42941,42974,42982,42984,42991,42992,43003,43004,43012,43016,43027,43035,43043,43058,43075,43081,43083,43090,43094,43095,43103,43106,43109,43129,43134,43137,43141,43150,43159,43164,43165,43169,43181,43206,43221,43235,43237,43240,43241,43247,43263,43265,43268,43271,43286,43287,43295,43298,43303,43310,43312,43316,43317,43320,43324,43325,43326,43331,43337,43339,43340,43342,43344,43347,43348,43365,43369,43372,43375,43386,43396,43397,43405,43408,43416,43419,43420,43421,43434,43443,43446,43454,43461,43470,43471,43472,43475,43477,43483,43490,43491,43492,43502,43504,43507,43511,43512,43516,43517,43518,43524,43525,43526,43527,43544,43546,43552,43573,43580,43583,43584,43599,43606,43607,43609,43612,43613,43617,43622,43626,43638,43647,43648,43649,43654,43659,43665,43670,43674,43679,43683,43684,43688,43690,43698,43699,43703,43704,43712,43714,43717,43721,43729,43730,43731,43732,43737,43738,43742,43749,43758,43765,43768,43775,43779,43781,43787,43790,43792,43795,43796,43800,43808,43814,43821,43830,43831,43835,43836,43837,43841,43849,43851,43853,43854,43862,43867,43870,43871,43874,43883,43884,43888,43904,43919,43927,43937,43948,43964,43966,43969,43974,43998,44003,44006,44013,44019,44030,44032,44038,44039,44049,44050,44051,44056,44057,44062,44070,44073,44084,44087,44088,44089,44106,44109,44118,44122,44137,44148,44161,44162,44168,44173,44180,44186,44187,44217,44218,44219,44221,44236,44259,44293,44299,44313,44336,44350,44352,44356,44358,44366,44368,44372,44378,44379,44383,44384,44389,44390,44394,44415,44421,44425,44437,44444,44455,44463,44474,44479,44487,44502,44504,44507,44512,44516,44517,44518,44519,44520,44521,44522,44523,44524,44525,44526,44527,44528,44530,44532,44533,44535,44536,44538,44540,44541,44542,44543,44546,44551,44553,44555,44558,44560,44564,44568,44569,44571,44573,44580,44589,44590,44598,44601,44602,44620,44623,44628,44632,44640,44648,44654,44656,44658,44659,44666,44674,44675,44679,44683,44688,44699,44700,44718,44730,44735,44738,44748,44782,44788,44798,44807,44811,44812,44821,44828,44829,44852,44859,44870,44871,44879,44881,44897,44898,44907,44910,44912,44925,44935,44936,44953,44988,45046,45057,45068,45100,45101,45115,45129,45132,45138,45145,45147,45154,45155,45159,45168,45172,45174,45175,45177,45193,45201,45213,45223,45228,45233,45235,45246,45249,45250,45258,45263,45264,45274,45288,45289,45291,45294,45295,45296,45300,45301,45304,45305,45307,45310,45312,45313,45316,45317)
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 | 2516 | 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.19 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.47 ms |
System lock | 0.02 ms |
optimizing | 0.15 ms |
statistics | 3.79 ms |
preparing | 1.92 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.38 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.07 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 |