Tiempo de la consulta: 5.70 ms Después de la última consulta: 0.73 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.313 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 00:31:36')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 00:31:36')
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(1,49,71,90,92,96,97,98,99,102,104,107,119,154,198,199,209,210,217,226,228,232,234,238,240,242,243,265,266,276,419,428,466,487,523,605,607,637,793,904,948,966,990,1031,1067,1180,1209,1223,1295,1447,1470,1698,1819,1825,1845,1852,1957,2156,2159,2301,2556,2640,2694,2729,2804,2809,2822,3020,3058,3139,3205,3343,3819,3960,4477,4665,4761,4765,4784,4796,4808,4810,4879,4902,5047,5125,5323,5371,5622,5642,5647,5649,5685,5693,5697,5726,5727,5806,5847,5976,5985,6264,6313,6386,6431,6511,6518,6760,6839,6847,6881,6915,6925,6982,6984,7017,7165,7166,7547,7624,7625,7650,7713,7731,7772,7780,7822,7928,7958,7967,8047,8056,8062,8070,8160,8206,8272,8320,8352,8354,8366,8423,8466,8517,8607,8741,8778,8802,8842,8844,8929,9003,9067,9069,9127,9132,9171,9177,9382,9424,9581,9582,9621,9650,9724,9827,9924,9980,10031,10059,10100,10183,10241,10282,10314,10323,10368,10412,10436,10450,10462,10503,10511,10531,10580,10650,10669,10688,10691,10697,10716,10738,10761,10763,10834,10838,10889,10918,10923,10951,10956,11104,11163,11169,11208,11214,11219,11231,11353,11390,11442,11508,11530,11548,11712,11754,11823,11911,11918,11933,11946,12032,12095,12177,12264,12412,12418,12679,12767,12785,12841,12887,12895,12913,12973,13008,13010,13062,13063,13108,13127,13148,13199,13231,13240,13276,13321,13398,13405,13471,13473,13480,13545,13546,13557,13562,13658,13681,13719,13750,13800,13827,13868,13898,13969,14029,14034,14081,14106,14156,14203,14218,14224,14263,14270,14293,14313,14332,14356,14376,14476,14485,14490,14581,14610,14652,14731,14740,14748,14753,14761,14772,14795,14815,14848,14853,14932,14958,14987,15021,15028,15039,15041,15063,15108,15110,15124,15160,15179,15188,15198,15201,15216,15220,15224,15248,15254,15262,15297,15298,15329,15347,15366,15367,15369,15391,15418,15421,15422,15470,15473,15482,15495,15509,15511,15517,15548,15550,15573,15606,15630,15632,15641,15667,15672,15738,15743,15759,15784,15835,15882,15897,15908,15909,15981,16002,16084,16090,16165,16192,16193,16213,16215,16263,16338,16352,16358,16365,16373,16380,16384,16436,16472,16488,16513,16532,16618,16720,16766,16779,16795,16812,16822,16826,16894,16946,16983,17045,17053,17063,17071,17142,17154,17236,17260,17275,17285,17317,17334,17394,17409,17451,17453,17506,17517,17520,17521,17538,17555,17561,17570,17611,17619,17651,17710,17729,17773,17778,17862,17873,17949,17965,17970,18052,18106,18124,18133,18135,18141,18163,18181,18183,18213,18242,18295,18328,18336,18362,18426,18431,18458,18465,18509,18538,18588,18589,18675,18703,18707,18717,18724,18726,18753,18801,18845,18846,18852,18884,18940,18956,18958,18999,19024,19040,19057,19072,19098,19122,19126,19150,19196,19207,19217,19223,19245,19252,19263,19273,19298,19312,19335,19353,19358,19369,19402,19448,19454,19483,19484,19494,19502,19527,19551,19582,19607,19653,19676,19722,19768,19772,19791,19816,19837,19865,19867,19885,19939,19943,19953,19958,19959,19963,20004,20039,20052,20092,20118,20122,20144,20163,20183,20216,20260,20269,20296,20299,20301,20334,20343,20377,20386,20408,20414,20434,20478,20492,20497,20525,20526,20528,20539,20553,20573,20592,20598,20617,20670,20688,20738,20757,20771,20785,20792,20796,20804,20849,20875,20881,20894,20907,20944,20958,20964,20974,20984,20993,21002,21051,21052,21080,21114,21130,21131,21145,21165,21182,21259,21300,21404,21454,21555,21559,21599,21631,21635,21679,21767,21891,21908,21958,21960,21988,22032,22085,22097,22156,22162,22170,22172,22189,22239,22253,22267,22318,22339,22344,22361,22363,22378,22385,22409,22458,22466,22477,22481,22488,22489,22499,22513,22544,22547,22564,22591,22611,22694,22695,22726,22753,22773,22774,22781,22784,22785,22814,22839,22865,22871,22958,22973,22987,23003,23010,23036,23038,23074,23092,23099,23102,23104,23105,23119,23184,23203,23208,23218,23221,23227,23230,23234,23235,23247,23254,23264,23268,23277,23292,23304,23363,23371,23381,23391,23455,23460,23475,23483,23485,23492,23523,23540,23554,23555,23585,23593,23604,23619,23632,23638,23642,23684,23719,23805,23813,23817,23823,23854,23893,23897,23901,23905,23909,23947,23964,23986,24000,24007,24053,24092,24160,24166,24186,24197,24209,24226,24238,24283,24288,24294,24303,24339,24352,24361,24376,24383,24393,24398,24428,24429,24496,24503,24526,24539,24585,24598,24601,24615,24663,24678,24679,24701,24711,24741,24764,24769,24770,24772,24782,24819,24861,24910,24918,24934,24984,24992,25002,25005,25062,25079,25089,25133,25145,25151,25172,25222,25232,25244,25258,25283,25287,25303,25318,25340,25368,25375,25401,25411,25413,25432,25480,25507,25613,25631,25637,25649,25716,25765,25787,25863,25918,25949,25956,26047,26061,26118,26131,26184,26221,26256,26283,26438,26443,26471,26492,26625,26640,26673,26699,26732,26884,26900,26910,26925,26940,26971,26978,26990,27078,27109,27118,27126,27143,27171,27219,27232,27235,27266,27273,27280,27305,27314,27322,27375,27405,27406,27430,27475,27535,27550,27565,27576,27833,27947,28030,28121,28310,28318,28320,28418,28718,28760,28779,28825,28932,28977,28991,29063,29153,29155,29239,29297,29304,29340,29347,29350,29501,29535,29673,29710,29871,29882,29922,29926,29943,30083,30266,30273,30280,30483,30484,30808,31136,31447,32107,32400,35000,35585,35718,35744,35832,35846,35940,37116,38070,39320,39381,39887,40086,40113,40451,40492,40578,40774,40790,41049,41213,41254,41442,41477,42658)
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 | 908 | 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.02 ms |
init | 0.28 ms |
System lock | 0.03 ms |
optimizing | 0.31 ms |
statistics | 1.86 ms |
preparing | 1.11 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.51 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.06 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 |