Tiempo de la consulta: 5.34 ms Después de la última consulta: 0.70 ms Consulta a la memoria: 0.408 MB memoria antes de la consulta: 4.479 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 22:48:52')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 22:48:52')
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(82,93,226,407,495,595,634,935,971,981,1085,1198,1243,1280,1391,1513,1634,1693,1713,1781,1800,1804,1900,1902,1915,2122,2123,2156,2210,2228,2258,2260,2337,2367,2378,2424,2468,2509,2598,2600,2601,2688,2828,2952,2963,2967,3067,3076,3211,3258,3319,3373,3408,3410,3475,3663,3757,3871,4131,4383,4832,4836,4905,4910,4957,4990,5040,5047,5079,5086,5092,5104,5139,5150,5170,5173,5224,5298,5622,5798,5799,5814,5943,5944,5973,6039,6055,6097,6131,6173,6264,6270,6347,6446,6571,6609,6645,6665,6695,6699,6711,6770,6775,6809,6830,6839,6847,6873,6915,6919,6937,6945,6977,7001,7082,7083,7117,7134,7201,7271,7294,7330,7416,7482,7526,7585,7624,7659,7663,7717,7745,7810,7813,7837,7866,7913,7933,7944,7958,7999,8000,8036,8047,8056,8083,8085,8088,8089,8222,8250,8330,8347,8353,8354,8416,8462,8532,8556,8603,8706,8764,8964,9012,9018,9091,9197,9239,9308,9481,9552,9658,9823,9865,9920,10100,10112,10260,10301,10400,10598,10604,10691,10764,10811,10840,10956,11163,11305,11476,11859,11864,11994,12035,12083,12095,12113,12141,12153,12216,12223,12224,12437,12669,12708,12771,12807,12889,13045,13074,13188,13268,13328,13474,13509,13535,13575,13576,13671,13681,13685,13693,13727,13748,13750,13782,13783,13846,13858,13868,13924,13938,13941,13947,13954,14052,14203,14327,14356,14426,14430,14648,14663,14679,14688,14703,14709,14726,14733,14744,14762,14790,14849,14905,14911,14948,14949,14970,14973,14987,14992,15020,15021,15038,15045,15110,15179,15201,15262,15293,15298,15304,15365,15366,15386,15421,15473,15482,15517,15522,15550,15594,15650,15751,15753,15784,15785,15796,15931,15947,16115,16122,16157,16214,16422,16440,16455,16519,16526,16654,16678,16689,16720,16787,16802,16812,16862,16894,16917,17101,17133,17166,17221,17296,17317,17334,17335,17357,17409,17412,17479,17520,17530,17531,17584,17597,17603,17635,17663,17700,17724,17826,17857,17862,17949,17965,18012,18022,18028,18170,18213,18227,18362,18377,18538,18595,18675,18707,18726,18753,18845,18912,18927,18929,18974,19039,19040,19127,19150,19153,19204,19211,19235,19236,19245,19252,19268,19358,19426,19454,19472,19483,19487,19507,19527,19676,19706,19723,19750,19767,19791,19862,19981,19988,20003,20030,20039,20066,20068,20092,20122,20183,20262,20373,20376,20384,20386,20396,20437,20469,20488,20526,20528,20565,20566,20569,20592,20642,20648,20656,20670,20688,20750,20792,20804,20805,20894,20944,20964,20984,20990,21147,21182,21196,21198,21243,21327,21329,21332,21404,21405,21454,21487,21598,21718,21719,21722,21726,21761,21767,21769,21811,21824,21850,21891,21932,21958,22129,22156,22162,22172,22253,22262,22267,22290,22329,22409,22419,22466,22481,22494,22499,22674,22726,22753,22761,22797,22850,22851,22865,22914,23037,23099,23104,23119,23123,23184,23213,23218,23254,23257,23268,23273,23287,23309,23479,23491,23493,23504,23554,23604,23628,23632,23704,23720,23751,23805,23813,23831,23886,23887,23888,23890,23891,23893,23897,23899,23901,23904,23905,23907,23921,23927,23964,23981,23983,23986,24000,24027,24029,24039,24040,24043,24062,24153,24160,24185,24197,24199,24208,24247,24281,24286,24294,24316,24328,24334,24337,24399,24406,24429,24463,24485,24496,24497,24503,24539,24587,24589,24678,24679,24743,24761,24782,24788,24906,24951,24952,24956,25233,25318,25505,25648,25673,25734,25747,25771,25774,25800,25817,25863,25909,25950,26113,26153,26183,26187,26245,26296,26335,26386,26388,26630,26784,26815,26820,26916,26933,26935,26944,26964,27065,27103,27108,27109,27115,27137,27192,27196,27209,27212,27216,27242,27252,27268,27269,27270,27298,27307,27323,27367,27487,27549,27595,27699,27717,27786,27923,28031,28059,28066,28075,28094,28097,28120,28129,28237,28243,28435,28995,29045,29152,29166,29226,29229,29272,29716,30525,30560,31735,32767,32768,34646,34811,35100,35191,35232,35238,35239,35250,35289,35295,35345,35365,35376,35397,35540,35554,35621,35641,35744,35808,35948,36015,36220,36300,36368,36373,36380,36385,36386,36441,36790,36791,36792,36793,36849,36917,36941,36984,37015,37104,37245,37370,37473,37508,37624,37643,37644,37667,37757,37834,37902,38058,38330,38394,38418,38617,38681,38723,38734,38821,38829,38965,39039,39110,39133,39244,39290,39293,39297,39460,39470,39508,39519,39718,39837,39856,40059,40275,40319,40560,40576,40855,40896,41004,41009,41033,41123,41152,41172,41176,41189,41201,41212,41225,41272,41289,41328,41339,41343,41415,41434,41479,41504,41550,41571,41591,41637,41737,41757,41783,41862,41948,41964,41967,41980,42030,42329,42482,42682,42736,42764,42811,42837,42941,43043,43093,43104,43117,43167,43221,43240,43241,43326,43375,43446,43461,43475,43477,43517,43518,43792,44122,44186,44187,44378,44581,44632,44640,44656,44718,44735,44788,44807,44829,44873,44881,44912,44935,44936,45174,45175,45223,45249,45274,45300,45313)
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 | 807 | 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.47 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.25 ms |
preparing | 0.64 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 1.93 ms |
end | 0.02 ms |
query end | 0.03 ms |
closing tables | 0.02 ms |
freeing items | 0.09 ms |
cleaning up | 0.08 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 |