Tiempo de la consulta: 7.06 ms Después de la última consulta: 1.74 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 4.389 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 02:28:40')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 02:28:40')
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(181,198,215,216,221,224,225,254,262,280,325,394,474,596,641,642,650,681,686,854,875,976,1035,1066,1071,1266,1267,1339,1359,1467,1505,1534,1574,1637,1659,1686,1709,1721,1778,1805,1896,1932,2123,2221,2428,2455,2805,2855,2869,3398,3595,3630,3725,3801,3868,3870,4131,4338,4442,4547,4578,4799,4855,4911,4935,4965,5053,5062,5098,5147,5150,5151,5166,5184,5195,5223,5237,5263,5273,5374,5406,5519,5585,5756,5782,5835,5852,5906,5927,6014,6032,6069,6222,6226,6276,6373,6510,6542,6543,6641,6666,6677,6716,6779,6924,6939,7004,7048,7117,7222,7423,7446,7534,7556,7560,7810,7812,7904,7913,7926,7968,8060,8178,8294,8296,8299,8306,8357,8418,8572,8678,8710,8810,8835,8923,8940,8948,8995,9046,9096,9110,9140,9146,9180,9186,9190,9197,9199,9252,9300,9362,9381,9541,9576,9641,9660,9685,9731,9873,9915,10014,10044,10046,10113,10147,10342,10407,10774,11436,11465,11549,11590,11706,11750,11772,11791,11979,12324,12334,12440,12550,12795,12908,12998,13065,13069,13070,13094,13121,13209,13263,13727,13728,13803,13894,14048,14122,14146,14352,14494,14577,14679,14741,14752,14857,14889,14969,15015,15020,15077,15090,15133,15184,15186,15279,15292,15598,15627,15644,15751,15753,15808,15895,15902,15960,15998,16010,16040,16055,16078,16219,16284,16401,16570,16588,16737,16913,17014,17133,17167,17168,17353,17412,17580,17629,17631,17643,17700,17959,18014,18068,18234,18276,18284,18306,18382,18423,18491,18516,18582,18599,18744,19019,19112,19286,19316,19359,19432,19472,19487,19533,19607,19695,19742,19758,19783,19943,19988,20150,20384,20539,20637,20704,20713,20750,20751,20776,20828,20832,21013,21090,21174,21198,21340,21435,21660,21811,22337,22352,22362,22400,22424,22550,22551,22573,22615,22676,22737,22767,22797,22855,22941,22963,23115,23313,23482,23666,23788,23879,23943,24107,24125,24164,24172,24248,24281,24434,24458,24475,24596,24766,24880,24894,24896,24927,24967,24977,24981,24993,25001,25013,25040,25091,25094,25114,25167,25296,25321,25367,25371,25372,25390,25391,25393,25414,25431,25433,25446,25451,25457,25459,25464,25465,25467,25468,25472,25476,25482,25485,25486,25489,25492,25493,25494,25495,25499,25504,25506,25508,25509,25510,25517,25536,25537,25538,25540,25545,25546,25548,25552,25559,25569,25572,25576,25578,25582,25587,25588,25592,25596,25613,25674,25844,25937,25941,25953,26033,26044,26047,26362,26372,26405,26506,26554,26572,26577,26578,26609,26653,26683,26694,26785,26787,26796,26835,26873,26962,27067,27095,27123,27139,27298,27342,27582,27641,27799,28329,28440,28441,28445,28446,28534,28635,28741,28751,28870,28930,28992,29222,29639,30111,30452,31463,31533,31614,31725,33078,33249,33250,33251,33252,33261,33265,33273,33281,33289,33292,33315,33317,33318,33325,33348,33349,33350,33359,33374,33375,33377,33378,33380,33381,33382,33396,33399,33410,33414,33415,33419,33421,33423,33424,33425,33426,33427,33428,33429,33430,33431,33432,33436,33438,33439,33440,33441,33446,33449,33450,33451,33452,33454,33464,33471,33473,33475,33483,33484,33498,33502,33504,33517,33520,33528,33549,33556,33559,33567,33570,33577,33579,33586,33587,33604,33605,33611,33615,33618,33619,33620,33628,33707,33788,33796,33797,33798,33799,33821,33822,33833,34030,34071,34159,34214,34239,34243,34249,34262,34270,34273,34375,34611,34655,34851,34956,35049,35250,35266,35444,35485,35487,35643,35822,35881,35948,36007,36015,36025,36112,36143,36220,36251,36339,36373,36380,36382,36385,36386,36400,36403,36425,36433,36464,36541,36555,36574,36617,36620,36635,36659,36662,36666,36669,36670,36704,36713,36759,36790,36791,36792,36793,36797,36820,36826,36838,36852,36889,36905,36929,36930,36931,36933,36936,36960,36971,36973,36984,36989,36991,36998,37002,37011,37015,37018,37033,37038,37056,37072,37095,37104,37105,37136,37149,37166,37196,37212,37242,37245,37257,37261,37273,37283,37288,37298,37315,37328,37332,37358,37392,37410,37411,37422,37429,37435,37458,37460,37473,37474,37524,37532,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,37688,37710,37740,37747,37757,37758,37759,37767,37786,37787,37796,37801,37806,37834,37845,37853,37864,37866,37867,37872,37873,37875,37902,37911,37914,37918,37940,37997,38032,38044,38046,38047,38058,38070,38071,38086,38101,38104,38117,38124,38126,38133,38165,38175,38178,38188,38195,38199,38203,38238,38240,38242,38244,38246,38267,38276,38278,38289,38302,38324,38326,38327,38329,38330,38338,38343,38346,38362,38363,38368,38370,38390,38391,38406,38409,38418,38419,38422,38423,38441,38452,38453,38465,38468,38470,38489,38490,38491,38506,38512,38526,38527,38532,38543,38567,38580,38585,38590,38611,38617,38618,38641,38647,38664,38665,38672,38676,38681,38687,38688,38690,38693,38711,38716,38719,38720,38723,38728,38734,38737,38749,38753,38758,38762,38764,38765,38767,38775,38781,38782,38783,38787,38789,38792,38794,38797,38821,38823,38824,38826,38829,38838,38851,38877,38888,38889,38891,38902,38904,38907,38912,38916,38922,38933,38949,38955,38957,38958,38965,38966,38975,38981,38983,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,39227,39228,39231,39240,39241,39244,39247,39251,39256,39260,39263,39271,39272,39285,39290,39293,39296,39297,39320,39325,39326,39337,39345,39346,39357,39366,39376,39381,39397,39398,39400,39425,39430,39442,39448,39451,39454,39460,39470,39476,39485,39491,39508,39513,39517,39519,39532,39534,39541,39545,39546,39547,39548,39575,39578,39582,39591,39604,39610,39625,39630,39633,39634,39637,39663,39676,39678,39686,39687,39701,39702,39717,39718,39724,39736,39739,39754,39766,39767,39769,39770,39792,39811,39815,39822,39824,39826,39828,39836,39847,39850,39856,39873,39883,39887,39896,39897,39919,39920,39932,39933,39934,39948,39951,39958,39964,39974,39977,39987,39992,39993,40003,40008,40015,40025,40040,40053,40055,40056,40059,40067,40073,40080,40082,40088,40103,40105,40111,40118,40143,40164,40173,40183,40184,40263,40267,40275,40285,40291,40292,40302,40316,40319,40325,40334,40335,40337,40341,40345,40367,40379,40390,40405,40412,40426,40453,40526,40530,40544,40561,40601,40624,40638,40645,40650,40673,40675,40692,40703,40704,40714,40721,40722,40723,40738,40760,40772,40806,40815,40824,40853,40855,40859,40872,40878,40879,40885,40888,40896,40897,40927,40940,40953,40965,40968,40975,40976,40987,40996,40997,41004,41009,41033,41042,41070,41073,41079,41084,41095,41096,41105,41109,41110,41123,41134,41137,41142,41148,41151,41155,41157,41171,41172,41175,41176,41178,41181,41186,41187,41188,41189,41192,41194,41197,41198,41201,41204,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,41361,41370,41374,41379,41383,41384,41391,41406,41415,41427,41434,41440,41446,41451,41453,41459,41464,41477,41483,41485,41487,41488,41492,41503,41504,41505,41506,41510,41516,41517,41531,41532,41535,41537,41541,41544,41546,41550,41551,41554,41557,41561,41564,41571,41577,41588,41597,41601,41602,41604,41605,41610,41612,41618,41626,41632,41647,41651,41660,41663,41677,41681,41683,41705,41712,41720,41726,41732,41735,41738,41739,41752,41759,41766,41773,41778,41781,41783,41785,41811,41821,41822,41828,41841,41848,41851,41861,41863,41870,41875,41915,41917,41919,41925,41928,41933,41939,41946,41948,41959,41964,41969,41973,41981,41999,42012,42024,42037,42042,42043,42059,42071,42076,42086,42087,42098,42102,42107,42113,42124,42130,42131,42138,42146,42148,42152,42160,42173,42182,42184,42185,42186,42191,42193,42205,42209,42220,42232,42233,42234,42246,42247,42251,42261,42275,42279,42280,42282,42285,42289,42295,42296,42302,42312,42320,42329,42330,42337,42349,42354,42358,42363,42376,42377,42380,42387,42393,42396,42413,42425,42427,42430,42433,42435,42437,42442,42444,42446,42457,42467,42473,42478,42482,42489,42492,42504,42505,42513,42516,42523,42527,42530,42541,42548,42551,42552,42555,42557,42567,42574,42590,42611,42614,42617,42625,42637,42639,42642,42650,42654,42655,42664,42677,42708,42716,42718,42748,42749,42754,42768,42774,42776,42780,42789,42795,42802,42809,42811,42821,42824,42826,42831,42834,42836,42839,42843,42845,42853,42857,42858,42866,42890,42893,42900,42902,42903,42906,42908,42911,42912,42939,42941,42952,42974,42982,42984,42991,42992,42993,42998,43003,43004,43012,43016,43027,43035,43043,43050,43051,43053,43058,43075,43078,43081,43083,43084,43090,43094,43095,43103,43106,43109,43114,43120,43129,43134,43137,43141,43150,43159,43164,43165,43169,43181,43191,43206,43221,43235,43237,43240,43241,43247,43248,43253,43263,43265,43268,43271,43274,43286,43287,43291,43295,43298,43300,43301,43303,43310,43312,43316,43317,43320,43324,43325,43326,43331,43335,43337,43339,43340,43342,43344,43347,43348,43360,43365,43369,43372,43375,43386,43396,43397,43398,43405,43408,43412,43416,43419,43420,43421,43424,43434,43443,43446,43454,43461,43468,43470,43471,43472,43475,43477,43483,43490,43491,43492,43502,43504,43507,43511,43512,43516,43517,43518,43524,43525,43526,43527,43528,43532,43544,43546,43552,43573,43580,43581,43583,43584,43599,43604,43606,43607,43609,43612,43613,43617,43621,43622,43626,43638,43647,43648,43649,43651,43654,43659,43665,43668,43669,43670,43674,43679,43683,43684,43688,43690,43698,43699,43700,43703,43704,43712,43714,43716,43717,43721,43725,43729,43730,43731,43732,43737,43738,43740,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,43885,43888,43904,43919,43927,43932,43937,43942,43948,43964,43966,43969,43974,43998,44003,44006,44013,44019,44029,44030,44032,44038,44039,44046,44049,44050,44051,44056,44057,44060,44062,44070,44073,44079,44084,44087,44088,44089,44092,44094,44105,44106,44109,44118,44120,44122,44128,44137,44141,44148,44159,44161,44162,44165,44168,44173,44175,44180,44186,44187,44189,44194,44200,44208,44217,44218,44219,44220,44221,44222,44227,44228,44229,44236,44239,44251,44259,44260,44263,44282,44293,44294,44299,44312,44313,44327,44328,44336,44338,44350,44352,44354,44356,44358,44359,44361,44364,44366,44368,44372,44378,44379,44382,44383,44384,44385,44387,44389,44390,44391,44392,44394,44404,44406,44411,44415,44418,44421,44422,44425,44427,44437,44444,44447,44453,44454,44455,44457,44458,44461,44463,44467,44472,44473,44474,44480,44481,44485,44487,44495,44500,44501,44502,44504,44506,44507,44508,44512,44513,44514,44516,44517,44518,44519,44520,44521,44522,44523,44524,44525,44526,44527,44528,44529,44530,44532,44533,44535,44536,44537,44538,44539,44540,44541,44542,44543,44545,44546,44551,44553,44555,44558,44560,44562,44564,44568,44569,44571,44572,44573,44580,44589,44590,44591,44593,44598,44601,44602,44605,44609,44612,44617,44620,44623,44627,44628,44632,44634,44640,44642,44646,44647,44648,44654,44656,44658,44659,44662,44666,44674,44675,44676,44679,44682,44683,44688,44699,44700,44718,44730,44735,44738,44743,44748,44749,44759,44761,44762,44782,44786,44788,44797,44798,44807,44811,44812,44815,44821,44828,44829,44846,44847,44850,44852,44855,44859,44870,44871,44873,44879,44881,44897,44898,44899,44907,44910,44912,44925,44935,44936,44943,44950,44953,44957,44959,44977,44988,45000,45008,45022,45024,45046,45050,45057,45058,45059,45066,45068,45071,45072,45076,45084,45086,45100,45101,45106,45115,45128,45129,45131,45132,45137,45138,45143,45144,45145,45147,45152,45154,45155,45159,45168,45172,45174,45175,45177,45183,45185,45193,45196,45201,45208,45209,45213,45219,45223,45228,45233,45235,45238,45245,45246,45249,45250,45253,45254,45257,45258,45263,45264,45267,45274,45275,45288,45289,45291,45294,45295,45296,45300,45301,45304,45305,45307,45309,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 | 1983 | 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 | 0.92 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.37 ms |
System lock | 0.02 ms |
optimizing | 0.12 ms |
statistics | 3.03 ms |
preparing | 1.56 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.36 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.07 ms |
cleaning up | 0.03 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 |