Tiempo de la consulta: 25.39 ms Después de la última consulta: 0.71 ms Consulta a la memoria: 3.033 MB memoria antes de la consulta: 4.535 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-05 04:29:56')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 04:29:56')
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(80,82,197,226,317,328,333,440,468,513,790,935,1085,1167,1172,1205,1280,1391,1513,1533,1634,1693,1804,1822,1828,1860,1900,1915,1959,2027,2037,2122,2156,2367,2424,2451,2514,2598,2600,2601,2685,2689,2963,3067,3212,3216,3381,3439,3595,3872,4191,4392,4559,4957,4990,5040,5079,5086,5104,5139,5150,5168,5170,5173,5222,5237,5413,5622,5755,5799,5814,6097,6133,6172,6173,6175,6264,6270,6288,6335,6348,6446,6529,6695,6718,6830,6839,6847,6873,6915,6937,7041,7082,7083,7117,7125,7134,7294,7358,7389,7416,7514,7526,7624,7633,7659,7663,7686,7717,7745,7758,7813,7820,7866,7958,8001,8020,8021,8026,8036,8056,8239,8313,8330,8347,8416,8462,8504,8588,8988,9018,9197,9211,9238,9339,9346,9370,9437,9658,9754,9785,9990,10100,10112,10186,10400,10603,10604,10646,10691,10764,10802,10811,10840,10849,10956,11142,11163,11305,11461,11476,11715,11859,11864,11994,12013,12083,12095,12223,12250,12340,12454,12474,12510,12567,12746,12750,12753,12771,12807,12830,12889,12917,13045,13074,13268,13328,13509,13512,13535,13575,13576,13681,13748,13773,13782,13783,13816,13846,13868,13924,13938,13941,13968,14020,14027,14154,14203,14291,14327,14340,14356,14426,14430,14522,14648,14663,14669,14679,14733,14746,14753,14769,14814,14911,14930,14948,14973,14987,14995,15021,15110,15179,15201,15262,15293,15298,15304,15310,15313,15386,15409,15415,15421,15473,15482,15517,15528,15550,15650,15706,15751,15753,15784,15947,16027,16034,16081,16122,16150,16214,16440,16455,16465,16508,16519,16526,16654,16671,16689,16716,16720,16802,16812,16826,16858,16894,16917,16966,17133,17197,17317,17334,17335,17409,17412,17520,17584,17603,17700,17826,17862,17883,17906,17949,17956,17965,18028,18061,18083,18170,18213,18214,18263,18324,18362,18379,18447,18449,18538,18675,18707,18726,18753,18845,18926,18930,18949,18952,18974,19039,19040,19053,19118,19123,19127,19150,19153,19204,19235,19239,19252,19358,19415,19426,19454,19483,19487,19527,19676,19750,19767,19791,19897,19967,20003,20030,20039,20066,20068,20092,20122,20183,20239,20262,20288,20309,20384,20386,20437,20449,20469,20521,20526,20528,20565,20566,20592,20642,20648,20670,20688,20750,20792,20804,20894,20935,20944,20958,20964,20984,20990,21073,21119,21146,21182,21196,21198,21243,21327,21329,21332,21404,21405,21454,21480,21487,21602,21631,21722,21726,21761,21767,21769,21811,21821,21824,21891,21932,21941,21958,22055,22129,22156,22162,22172,22197,22253,22262,22267,22409,22466,22481,22499,22581,22726,22739,22753,22797,22865,22869,22914,22959,23037,23099,23104,23119,23123,23184,23213,23218,23254,23257,23268,23309,23491,23504,23547,23552,23554,23604,23628,23632,23704,23751,23805,23813,23834,23886,23887,23888,23890,23891,23893,23897,23899,23901,23904,23905,23907,23921,23927,23964,23981,23983,23986,24000,24029,24039,24040,24160,24172,24197,24294,24337,24429,24496,24497,24503,24587,24589,24678,24679,24782,24854,25201,25233,25505,25757,25758,25784,25831,25849,25863,25898,25909,25916,25927,26000,26027,26066,26335,26337,26505,26739,26757,26759,26784,26793,26890,26929,26949,27005,27045,27065,27116,27343,27408,27806,28079,29495,30115,30232,30643,31010,31620,31633,32752,33907,33914,33924,33925,33930,33932,33991,34020,34135,34420,34481,34714,34728,34798,34812,34879,34892,35197,35232,35233,35295,35339,35345,35353,35365,35376,35378,35386,35403,35432,35453,35476,35477,35490,35494,35555,35705,35833,35927,35947,35950,35956,35973,36000,36041,36062,36075,36144,36153,36245,36295,36380,36386,36486,36514,36555,36572,36774,36788,36811,36860,36862,36886,36917,36925,36932,36963,36971,37039,37052,37069,37072,37166,37198,37212,37227,37257,37271,37308,37508,37531,37566,37626,37671,37707,37875,37885,37959,37978,38033,38085,38109,38157,38178,38303,38385,38538,38545,38546,38583,38681,38690,38693,38742,38877,38916,38939,38965,39260,39285,39377,39573,39624,39633,39717,39744,39771,39799,39828,39919,39985,40023,40054,40149,40261,40267,40288,40289,40308,40322,40334,40356,40381,40406,40484,40645,40660,40704,40742,40790,40842,40853,40857,40869,40900,40912,40927,41010,41144,41191,41212,41216,41290,41315,41328,41329,41446,41453,41481,41505,41506,41512,41519,41535,41554,41569,41587,41607,41632,41651,41654,41690,41703,41725,41732,41735,41737,41745,41773,41821,41835,41933,41954,41991,42003,42059,42090,42121,42129,42145,42173,42186,42207,42234,42267,42278,42315,42337,42363,42364,42426,42460,42497,42501,42507,42541,42560,42588,42611,42650,42692,42727,42735,42748,42762,42798,42821,42824,42857,42924,42935,42974,42979,43021,43035,43081,43086,43176,43177,43192,43281,43295,43298,43339,43340,43442,43525,43526,43606,43611,43665,43669,43671,43699,43768,43775,43781,43782,43795,43835,43862,43867,43874,43930,43936,43966,43993,43998,44030,44084,44087,44173,44245,44246,44320,44328,44368,44404,44411,44426,44440,44516,44530,44532,44533,44538,44540,44551,44564,44598,44738,44785,44830,44904,44953,44993,45034,45100,45171,45186,45190,45199,45213,45228,45233,45263,45264,45307)
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 | 836 | 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.44 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.17 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 1.29 ms |
preparing | 0.67 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 22.09 ms |
end | 0.03 ms |
query end | 0.10 ms |
closing tables | 0.03 ms |
freeing items | 0.11 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 |