Tiempo de la consulta: 43.62 ms Después de la última consulta: 1.54 ms Consulta a la memoria: 2.971 MB memoria antes de la consulta: 4.385 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-04 23:58:33')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 23:58: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(31,62,78,85,155,163,174,206,214,279,285,303,349,357,450,484,495,531,572,666,667,808,863,869,885,954,1059,1101,1102,1182,1216,1238,1249,1278,1279,1289,1294,1316,1346,1538,1648,1846,1867,1919,2013,2071,2188,2328,2392,2395,2402,2647,2954,3054,3055,3106,3107,3109,3174,3180,3364,3369,3402,3409,3412,3451,3454,3571,3577,3663,4166,4215,4226,4381,4409,4494,4503,4589,4699,4713,4767,4823,4863,5161,5210,5247,5396,5461,5478,5536,5618,5686,5857,5881,5886,5913,6056,6088,6120,6178,6465,6472,6503,6545,6604,6639,6876,6953,6988,7013,7014,7122,7215,7246,7272,7276,7336,7437,7439,7460,7478,7720,7736,7818,7841,7897,7923,7924,8046,8061,8090,8116,8118,8266,8385,8457,8568,8760,8864,9029,9087,9204,9364,9429,9434,9554,9745,9773,9836,9924,10209,10245,10307,10475,10478,10553,10567,10630,10694,10783,10801,10958,11059,11104,11258,11402,11446,11472,11899,11929,12218,12331,12401,12410,12463,12474,12617,12620,12622,12625,12637,12686,12692,12708,12810,12853,12875,12901,12944,13017,13246,13294,13298,13671,13687,13697,13707,13742,13804,13842,13963,13975,13990,14074,14082,14092,14105,14117,14142,14206,14244,14262,14271,14273,14367,14440,14456,14507,14646,14683,14698,14759,14794,14964,14983,14987,14992,15004,15030,15032,15037,15048,15094,15108,15111,15129,15139,15213,15247,15370,15382,15403,15424,15439,15471,15492,15542,15548,15562,15575,15717,15725,15728,15757,15763,15782,15829,15935,15954,16000,16092,16093,16140,16153,16161,16206,16257,16302,16326,16327,16373,16374,16458,16459,16497,16534,16543,16605,16652,16657,16832,16889,16929,16936,16981,17000,17128,17215,17257,17273,17347,17358,17381,17382,17432,17484,17541,17558,17596,17634,17659,17702,17733,17757,17766,17818,17831,17840,17864,17895,17961,17980,18031,18059,18267,18281,18309,18316,18326,18367,18369,18384,18408,18419,18442,18498,18518,18543,18555,18561,18566,18577,18612,18682,18689,18739,18782,18847,18848,18869,18901,18904,18910,18920,18942,18977,18982,18991,18995,19000,19022,19083,19086,19091,19105,19110,19112,19132,19136,19149,19171,19185,19207,19247,19270,19274,19294,19304,19313,19350,19366,19386,19396,19442,19446,19453,19524,19567,19581,19595,19604,19608,19650,19655,19661,19684,19700,19718,19815,19841,19867,19894,19930,19932,19941,19983,19991,20030,20034,20036,20069,20099,20103,20145,20162,20183,20197,20199,20216,20344,20354,20358,20363,20374,20403,20440,20446,20464,20578,20579,20636,20638,20649,20659,20755,20768,20797,20826,20841,20856,20906,20950,21000,21118,21161,21178,21242,21252,21305,21323,21388,21433,21452,21458,21464,21516,21522,21536,21546,21586,21593,21709,21714,21737,21906,21912,21948,21952,21988,22059,22100,22244,22245,22246,22290,22347,22419,22435,22455,22492,22500,22502,22517,22527,22668,22673,22708,22715,22742,22744,22803,22805,22827,22829,22874,22895,22910,22924,22963,23000,23022,23034,23060,23081,23122,23124,23148,23196,23200,23219,23234,23247,23250,23256,23286,23300,23344,23375,23408,23467,23516,23519,23546,23559,23564,23565,23668,23691,23703,23710,23759,23763,23767,23772,23839,23857,23874,23900,23922,23930,23955,23959,23962,23967,23968,23984,24010,24024,24072,24075,24076,24111,24141,24174,24230,24264,24282,24346,24392,24472,24501,24523,24536,24607,24616,24618,24624,24673,24727,24788,24823,24835,24844,24857,24888,24924,24943,24968,24979,24989,25003,25048,25100,25126,25245,25273,25333,25349,25360,25373,25374,25421,25432,25443,25534,25624,25639,25673,25707,25764,25798,25818,25842,25847,25851,25860,25884,25927,25935,25954,25955,25985,25987,25989,26018,26021,26031,26038,26041,26065,26097,26107,26131,26136,26161,26176,26193,26208,26210,26219,26222,26259,26358,26360,26361,26377,26389,26403,26426,26454,26494,26513,26522,26564,26569,26583,26630,26665,26733,26737,26767,26772,26779,26800,26808,26816,26834,26892,26898,26910,26914,26926,26939,26941,26968,26982,26989,26996,27024,27026,27069,27116,27120,27121,27131,27151,27155,27170,27186,27218,27221,27232,27248,27273,27277,27332,27343,27346,27355,27356,27363,27366,27372,27431,27438,27452,27481,27490,27506,27520,27529,27545,27558,27572,27645,27646,27669,27683,27738,27816,27869,27891,27917,27919,27977,27986,27991,27996,28005,28006,28011,28055,28296,28319,28378,28380,28381,28387,28395,28397,28400,28421,28424,28426,28433,28434,28446,28452,28460,28474,28482,28494,28497,28500,28506,28508,28512,28516,28530,28605,28606,28646,28720,28729,28732,28780,28824,28845,28976,28995,29021,29043,29069,29076,29089,29122,29124,29129,29139,29156,29160,29171,29182,29249,29256,29271,29310,29315,29333,29358,29436,29457,29497,29525,29579,29617,29632,29633,29636,29657,29693,29748,29766,29782,29784,29810,29828,29835,29851,29854,29877,29919,29927,29930,29975,30094,30115,30144,30146,30226,30241,30245,30282,30330,30347,30348,30351,30390,30397,30413,30474,30476,30482,30483,30497,30498,30502,30519,30585,30826,30861,30863,30887,30889,30964,31041,31062,31090,31189,31206,31227,31230,31236,31237,31267,31305,31306,31425,31469,31474,31494,31499,31500,31516,31539,31580,31791,31830,31849,31865,31930,31954,31995,32012,32223,32250,32278,32279,32302,32381,32433,32507,32528,32590,32646,32786,32797,32800,32815,32830,32843,32896,32914,32934,32943,33040,33102,33117,33129,33199,33267,33402,33461,33478,33522,33649,33760,33815,34078,34090,34091,34099,34109,34125,34126,34127,34179,34184,34189,34197,34207,34227,34229,34241,34252,34258,34260,34267,34269,34290,34291,34292,34300,34301,34316,34318,34326,34342,34343,34357,34384,34385,34405,34452,34485,34609,34655,34664,34669,34689,34691,34702,34710,34738,34774,34822,34823,34832,34844,34860,34929,34950,34951,35010,35011,35012,35026,35033,35068,35094,35122,35130,35132,35133,35144,35158,35161,35183,35184,35223,35224,35246,35251,35272,35274,35275,35279,35280,35281,35285,35293,35299,35314,35315,35327,35328,35334,35338,35341,35354,35356,35386,35392,35422,35432,35451,35499,35516,35524,35525,35536,35537,35538,35557,35573,35606,35610,35688,35701,35711,35714,35785,35807,35817,35835,35847,35876,35902,35962,35970,35973,35982,35990,35994,36031,36033,36037,36055,36074,36076,36088,36092,36104,36105,36110,36132,36136,36141,36144,36167,36206,36233,36239,36242,36247,36311,36370,36384,36391,36393,36433,36437,36467,36468,36469,36488,36513,36520,36524,36527,36530,36535,36558,36574,36595,36614,36651,36653,36662,36669,36670,36673,36688,36696,36697,36704,36723,36747,36759,36766,36774,36788,36790,36791,36792,36793,36811,36820,36822,36826,36852,36883,36886,36888,36889,36890,36893,36916,36918,36922,36929,36963,36997,37003,37015,37024,37038,37043,37052,37072,37096,37105,37166,37174,37196,37208,37234,37254,37257,37270,37315,37344,37355,37377,37380,37425,37443,37460,37474,37491,37521,37530,37543,37544,37554,37555,37631,37633,37662,37675,37710,37739,37740,37767,37783,37786,37794,37803,37826,37859,37872,37874,37910,37911,37914,37918,37922,37996,37999,38033,38047,38056,38060,38066,38083,38085,38101,38117,38143,38158,38165,38178,38203,38204,38206,38218,38242,38243,38246,38248,38265,38266,38278,38302,38317,38345,38361,38370,38391,38421,38429,38430,38453,38455,38465,38506,38510,38512,38516,38526,38543,38580,38588,38590,38611,38623,38671,38676,38688,38704,38710,38713,38716,38720,38734,38752,38753,38764,38765,38775,38781,38789,38797,38799,38812,38821,38823,38826,38829,38837,38838,38851,38888,38955,38956,38963,38981,38993,39019,39023,39024,39054,39070,39079,39103,39104,39117,39139,39140,39149,39151,39154,39155,39160,39168,39177,39183,39184,39189,39205,39228,39229,39244,39256,39257,39269,39307,39309,39310,39325,39329,39337,39346,39357,39358,39364,39377,39449,39452,39471,39486,39503,39504,39516,39521,39534,39540,39545,39546,39547,39548,39573,39582,39591,39595,39621,39625,39633,39662,39676,39678,39692,39710,39754,39757,39767,39792,39793,39810,39828,39836,39838,39840,39853,39864,39882,39898,39908,39912,39915,39920,39921,39934,39947,39966,39974,39976,40003,40042,40055,40081,40088,40091,40103,40105,40169,40194,40213,40288,40289,40302,40306,40312,40313,40314,40320,40350,40360,40378,40379,40467,40508,40539,40541,40542,40568,40574,40589,40590,40621,40627,40644,40676,40686,40709,40713,40743,40744,40750,40763,40767,40776,40791,40801,40819,40822,40850,40853,40866,40879,40882,40897,40900,40904,40915,40916,40927,40953,40965,40971,40986,40990,40992,40996,41012,41036,41045,41051,41062,41063,41137,41142,41144,41178,41179,41190,41194,41216,41218,41233,41249,41275,41276,41284,41291,41294,41303,41352,41358,41367,41369,41371,41382,41402,41403,41407,41420,41423,41424,41446,41451,41453,41458,41479,41512,41530,41535,41544,41562,41563,41569,41571,41572,41626,41663,41738,41752,41755,41756,41789,41794,41811,41835,41838,41851,41870,41885,41890,41892,41897,41922,41928,41939,41954,41973,41980,41982,42006,42008,42047,42056,42058,42086,42090,42113,42121,42129,42141,42172,42191,42216,42220,42232,42233,42234,42250,42267,42278,42285,42303,42312,42316,42317,42327,42329,42352,42355,42363,42413,42427,42436,42460,42466,42470,42489,42492,42497,42501,42505,42516,42528,42544,42554,42560,42609,42610,42611,42625,42660,42682,42687,42731,42736,42746,42754,42788,42793,42796,42798,42800,42821,42823,42862,42866,42867,42874,42882,42884,42911,42912,42979,43015,43021,43036,43058,43065,43075,43083,43086,43091,43116,43121,43135,43142,43146,43147,43154,43165,43181,43190,43257,43286,43287,43295,43312,43331,43337,43339,43340,43343,43344,43361,43381,43416,43434,43439,43442,43443,43455,43482,43484,43485,43493,43494,43502,43512,43535,43540,43551,43554,43558,43559,43567,43572,43573,43577,43591,43611,43613,43617,43626,43638,43643,43648,43661,43679,43680,43684,43694,43695,43696,43697,43699,43703,43705,43706,43707,43713,43721,43729,43730,43742,43758,43762,43768,43776,43782,43790,43800,43824,43825,43827,43832,43836,43838,43844,43845,43847,43858,43865,43876,43877,43883,43904,43906,43914,43915,43917,43919,43925,43930,43934,43938,43982,43998,44003,44005,44012,44016,44031,44035,44041,44080,44098,44117,44118,44133,44158,44164,44168,44170,44192,44259,44261,44276,44293,44295,44300,44320,44340,44341,44358,44394,44413,44414,44423,44497,44555,44559,44576,44581,44592,44598,44603,44604,44620,44623,44626,44630,44658,44675,44681,44699,44700,44727,44728,44731,44732,44733,44738,44748,44765,44810,44854,44859,44882,44891,44897,44898,44904,44917,44934,44952,44953,45003,45010,45012,45027,45034,45055,45078,45115,45155,45160,45162,45169,45171,45177,45190,45193,45206,45233,45252,45301,45310)
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 | 1735 | 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.29 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.45 ms |
System lock | 0.02 ms |
optimizing | 0.14 ms |
statistics | 4.07 ms |
preparing | 2.01 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 34.46 ms |
end | 0.30 ms |
query end | 0.05 ms |
closing tables | 0.10 ms |
freeing items | 0.16 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 |