Tiempo de la consulta: 15.34 ms Después de la última consulta: 1.04 ms Consulta a la memoria: 1.487 MB memoria antes de la consulta: 4.347 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 22:11:23')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 22:11:23')
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(62,72,102,163,174,357,495,675,726,816,844,860,892,900,961,1029,1039,1089,1095,1158,1182,1195,1207,1226,1249,1289,1337,1346,1372,1497,1538,1557,1883,1919,1935,2064,2103,2188,2325,2372,2379,2392,2404,2426,2563,2591,2625,2647,2842,2857,2883,2888,2916,2924,3038,3055,3109,3180,3207,3208,3248,3252,3276,3285,3364,3451,3452,3462,3571,3633,3698,3812,3898,3918,3971,3974,4114,4166,4258,4315,4446,4527,4625,4661,4699,4713,4767,4932,5161,5247,5438,5458,5854,5881,5931,5977,5993,6081,6294,6399,6472,6514,6534,6561,6621,6629,6685,6736,6791,6804,6833,6906,6936,6969,6995,7009,7013,7014,7045,7149,7246,7272,7276,7282,7337,7412,7439,7447,7457,7490,7534,7700,7752,7793,7806,7829,7847,7923,8061,8116,8142,8209,8210,8264,8270,8280,8282,8312,8382,8387,8615,8700,8780,8796,8851,8862,8874,8916,8917,8932,9001,9036,9124,9265,9313,9415,9434,9441,9548,9554,9589,9745,9773,9834,9836,9854,9905,9924,9949,10052,10061,10304,10307,10387,10498,10532,10554,10575,10630,10659,10661,10675,10694,10713,10769,10783,10894,10924,10958,11059,11083,11091,11122,11127,11143,11157,11164,11170,11258,11262,11277,11309,11360,11402,11407,11431,11446,11497,11585,11587,11614,11658,11721,11727,11776,11796,11821,11839,11872,11905,11915,11920,11987,12018,12019,12038,12040,12091,12098,12109,12133,12139,12218,12306,12331,12401,12412,12449,12460,12463,12474,12622,12625,12651,12673,12686,12735,12754,12784,12794,12848,12865,12875,12903,12916,12991,13110,13141,13198,13262,13331,13346,13412,13418,13425,13595,13611,13627,13633,13659,13677,13697,13733,13742,13951,13963,13990,14073,14074,14080,14082,14097,14104,14114,14117,14141,14150,14196,14222,14227,14236,14244,14262,14267,14273,14278,14359,14440,14456,14469,14507,14525,14563,14574,14580,14613,14632,14673,14683,14692,14696,14701,14747,14770,14794,14799,14827,14842,14960,14964,14983,15006,15032,15048,15069,15084,15094,15108,15111,15129,15139,15146,15149,15175,15206,15213,15303,15330,15334,15346,15370,15412,15426,15497,15548,15565,15575,15631,15635,15641,15668,15693,15725,15729,15731,15757,15782,15935,16000,16053,16060,16062,16071,16079,16092,16093,16097,16128,16153,16168,16169,16173,16326,16343,16356,16374,16415,16442,16458,16484,16522,16534,16571,16621,16640,16645,16662,16671,16688,16827,16832,16864,16889,16981,17042,17128,17130,17138,17145,17184,17215,17221,17222,17227,17228,17257,17382,17389,17425,17432,17436,17488,17541,17596,17600,17634,17675,17679,17701,17704,17706,17724,17726,17733,17766,17818,17822,17840,17852,17874,17895,17938,17961,17966,17980,17991,18031,18123,18138,18156,18185,18259,18261,18303,18356,18369,18370,18396,18404,18445,18453,18505,18528,18561,18564,18577,18580,18584,18599,18612,18668,18682,18686,18689,18718,18768,18786,18793,18813,18829,18853,18874,18910,18920,18942,18973,18977,18982,18985,18991,18995,19000,19020,19022,19041,19064,19083,19091,19110,19117,19132,19136,19149,19175,19193,19217,19223,19233,19242,19247,19270,19294,19312,19350,19371,19417,19436,19453,19475,19503,19524,19567,19571,19595,19602,19604,19608,19643,19650,19661,19671,19684,19701,19718,19728,19764,19769,19780,19815,19829,19882,19894,19905,19918,19920,19930,19932,19941,19952,19962,19983,19991,20019,20034,20062,20069,20123,20133,20145,20149,20183,20199,20259,20298,20307,20323,20326,20344,20352,20354,20361,20363,20367,20374,20380,20403,20440,20442,20444,20488,20517,20518,20545,20556,20561,20578,20587,20611,20629,20636,20638,20655,20671,20681,20705,20797,20809,20820,20826,20856,20875,20884,20906,20921,20923,20942,20962,20993,21000,21010,21012,21014,21101,21118,21142,21161,21165,21178,21186,21222,21242,21245,21252,21294,21297,21305,21308,21312,21323,21402,21420,21433,21458,21464,21477,21498,21510,21512,21519,21522,21536,21541,21544,21546,21554,21586,21591,21611,21616,21637,21709,21714,21737,21739,21755,21758,21783,21851,21882,21897,21914,21921,21952,22017,22023,22059,22064,22084,22092,22100,22165,22171,22188,22198,22216,22237,22252,22271,22285,22290,22317,22322,22328,22337,22341,22347,22389,22408,22419,22435,22439,22455,22469,22478,22480,22492,22500,22502,22518,22527,22553,22557,22571,22610,22614,22673,22708,22711,22715,22725,22741,22742,22770,22794,22803,22874,22883,22885,22895,22935,23000,23022,23034,23038,23046,23061,23076,23122,23135,23148,23188,23219,23247,23253,23256,23286,23305,23342,23344,23375,23419,23442,23467,23521,23546,23551,23559,23564,23595,23612,23615,23631,23691,23697,23703,23772,23777,23785,23852,23857,23874,23889,23913,23915,23956,23959,23961,23962,23967,23984,23985,24010,24024,24072,24075,24076,24111,24188,24219,24230,24282,24295,24304,24346,24433,24440,24456,24458,24523,24532,24559,24574,24576,24607,24616,24632,24660,24664,24673,24691,24707,24748,24760,24768,24788,24789,24830,24857,24860,24863,24888,24907,24924,24988,25003,25065,25080,25123,25126,25168,25174,25206,25241,25273,25277,25291,25344,25349,25360,25373,25421,25491,25543,25567,25621,25654,25696,25703,25717,25755,25764,25798,25799,25947,25987,25990,26030,26041,26107,26122,26161,26176,26256,26274,26522,26563,26564,26582,26689,26816,26818,26898,26901,26926,26982,26986,27026,27128,27151,27155,27248,27261,27283,27314,27318,27356,27471,27472,27478,27506,27558,27572,27937,28005,28184,28254,28397,28424,28780,28807,28824,29021,29089,29124,29250,29256,29281,29332,29355,29358,29438,29476,29608,29617,29810,29868,29919,29930,31227,31499,31516,33815,35899,35975,36154,36367,36402,36490,36583,36893,36897,36916,36918,37315,37345,37380,37874,37996,38056,38066,38226,38237,38352,38361,38455,38734,38775,38812,38850,38899,38991,39214,39286,39307,39358,39452,39504,39516,39558,39580,39642,39677,39737,39761,39801,39892,39966,40116,40120,40145,40169,40271,40272,40312,40313,40314,40360,40375,40542,40594,40739,40773,40801,40887,40973,40984,41036,41063,41122,41217,41364,41402,41423,41475,41636,41761,41811,41826,41885,42460,42486,42489,42563,42591,42680,42766,42944,43330,43569,43570,43571,43680,43705,43706,43707,43755,43856,43914,43915,43917,43972,43973,44031,44041,44143,44160,44469,44497,44681,44843,44933,44998,45115,45160,45206,45252)
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 | 1026 | 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.52 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.20 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.56 ms |
preparing | 0.78 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 11.03 ms |
end | 0.02 ms |
query end | 0.04 ms |
closing tables | 0.02 ms |
freeing items | 0.08 ms |
cleaning up | 0.18 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 |