Tiempo de la consulta: 11.89 ms Después de la última consulta: 0.78 ms Consulta a la memoria: 1.455 MB memoria antes de la consulta: 4.200 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-07 17:47:50')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 17:47:50')
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(49,71,90,92,96,97,98,99,102,104,107,110,173,198,199,209,210,212,217,226,228,232,234,238,240,242,243,252,263,265,276,419,425,428,466,487,495,510,523,605,607,618,624,637,671,706,766,787,825,837,860,904,948,951,966,1010,1031,1053,1065,1067,1082,1099,1128,1136,1209,1213,1223,1235,1299,1340,1370,1422,1431,1480,1548,1550,1628,1638,1653,1678,1698,1706,1746,1762,1788,1790,1825,1831,1833,1835,1840,1845,1872,1939,1957,2036,2087,2093,2094,2156,2162,2166,2193,2204,2289,2303,2435,2452,2510,2550,2558,2559,2560,2652,2681,2683,2729,2732,2786,2812,2822,2904,3011,3020,3032,3058,3139,3167,3190,3228,3284,3329,3368,3373,3465,3638,3772,3818,3824,3949,4002,4189,4191,4240,4508,4513,4608,4609,4723,4767,4784,4808,4845,4902,4948,4983,4994,5011,5033,5086,5102,5125,5135,5323,5324,5371,5397,5477,5517,5528,5537,5579,5604,5622,5647,5649,5682,5685,5705,5713,5719,5726,5727,5829,5847,5934,5973,6044,6207,6264,6277,6293,6352,6368,6386,6460,6462,6518,6519,6628,6629,6636,6728,6760,6776,6805,6839,6847,6881,6908,6915,6935,6984,7017,7123,7135,7176,7439,7455,7553,7570,7624,7744,7772,7928,7958,7967,8056,8062,8070,8214,8232,8320,8339,8354,8507,8844,8858,9003,9008,9051,9081,9146,9191,9650,9724,9859,9924,10019,10031,10042,10093,10100,10323,10436,10517,10670,10870,10889,10956,10974,11054,11163,11676,11789,11808,11911,11946,11950,11970,12086,12095,12140,12177,12237,12259,12412,12617,12679,12761,12887,12913,12916,12973,13010,13057,13062,13170,13228,13231,13274,13275,13276,13321,13346,13398,13405,13471,13473,13501,13681,13750,13795,13800,13868,13969,14006,14029,14034,14064,14082,14152,14156,14181,14203,14218,14224,14237,14263,14268,14279,14293,14356,14389,14479,14493,14539,14581,14619,14683,14713,14728,14754,14927,14931,14977,14987,15021,15024,15039,15078,15107,15110,15111,15150,15179,15188,15198,15219,15220,15221,15262,15298,15347,15354,15366,15418,15421,15470,15473,15482,15495,15511,15517,15542,15548,15550,15573,15575,15630,15667,15745,15759,15784,15835,15934,15978,16165,16213,16263,16298,16303,16352,16364,16365,16422,16488,16532,16551,16623,16658,16670,16720,16803,16812,16826,16894,16983,17010,17045,17063,17091,17106,17138,17142,17154,17170,17236,17249,17275,17317,17334,17409,17439,17453,17506,17520,17521,17580,17611,17615,17619,17630,17635,17663,17710,17727,17736,17797,17840,17862,17885,17949,17965,17995,18052,18060,18096,18106,18113,18124,18133,18150,18162,18181,18213,18336,18362,18371,18402,18426,18458,18459,18465,18509,18516,18538,18566,18588,18675,18707,18712,18726,18728,18753,18801,18845,18846,18852,18859,18956,18958,18959,18982,18999,19024,19040,19057,19098,19150,19245,19252,19263,19312,19349,19353,19358,19369,19402,19454,19483,19484,19527,19551,19582,19632,19676,19722,19772,19791,19816,19837,19939,19943,19963,19986,20004,20039,20092,20122,20180,20183,20216,20269,20286,20296,20301,20343,20350,20386,20408,20423,20434,20435,20492,20497,20526,20528,20533,20534,20539,20557,20573,20592,20617,20629,20661,20670,20688,20756,20758,20792,20804,20810,20881,20894,20907,20908,20923,20944,20964,20978,20984,20993,21002,21080,21142,21182,21187,21189,21224,21252,21257,21259,21270,21300,21371,21404,21454,21472,21549,21631,21633,21679,21765,21767,21830,21891,21958,21960,22032,22043,22085,22091,22127,22142,22156,22162,22169,22172,22239,22253,22267,22339,22344,22361,22363,22409,22456,22464,22466,22481,22491,22499,22526,22529,22536,22544,22547,22564,22609,22611,22648,22649,22694,22695,22700,22706,22726,22753,22763,22781,22785,22789,22794,22814,22849,22865,22871,22920,22958,22973,22986,22996,23003,23010,23036,23043,23052,23054,23055,23074,23092,23096,23099,23104,23119,23147,23184,23203,23218,23230,23235,23237,23254,23264,23268,23292,23304,23307,23312,23314,23318,23328,23330,23346,23347,23365,23368,23371,23373,23381,23391,23448,23455,23460,23463,23475,23483,23495,23499,23518,23523,23546,23554,23555,23575,23577,23585,23604,23605,23619,23632,23719,23763,23805,23813,23823,23854,23893,23897,23900,23901,23905,23909,23918,23945,23947,23964,23986,24000,24007,24030,24092,24160,24165,24183,24191,24197,24209,24225,24226,24238,24266,24293,24294,24303,24339,24341,24352,24357,24361,24370,24376,24392,24394,24402,24429,24491,24496,24497,24503,24526,24585,24598,24615,24624,24635,24663,24678,24679,24711,24739,24741,24764,24772,24782,24792,24806,24814,24856,24861,24883,24918,24934,24943,24953,24984,24992,25005,25010,25026,25062,25079,25089,25151,25162,25232,25244,25287,25303,25304,25368,25375,25382,25401,25432,25480,25507,25613,25637,25640,25648,25649,25716,25839,25863,25898,25918,25949,25955,25956,26023,26047,26118,26131,26159,26184,26221,26283,26425,26428,26443,26483,26625,26655,26673,26699,26732,26884,26900,26925,26940,26971,26978,26983,26990,26992,27109,27117,27118,27126,27143,27171,27232,27242,27256,27326,27405,27420,27430,27536,27550,27621,27655,27688,27940,27946,28030,28106,28119,28121,28247,28260,28434,28682,28695,28718,28735,28822,28825,28866,28876,28889,28907,28908,28941,29047,29063,29135,29155,29297,29321,29322,29372,29529,29706,29926,29943,30083,30271,30273,30470,30483,30484,30808,31064,31136,31447,32107,32129,33795,33897,34214,35000,35077,35585,35646,35713,35733,35744,35832,35846,36053,36251,36333,36601,36655,36856,37242,37534,37594,37677,37892,38279,38341,38381,38580,38760,39224,39320,39381,39604,39887,40086,40113,40202,40246,40300,40319,40451,40492,40578,40635,41049,41213,41477,41712,41962,42588,42600,42605,42631,42637,42658,42671,42700,42735,42782,43096,43097,43098,43112,43125,43134,43156,43167,43169,43179,43192,43206,43208,43224,43235,43456,43498,43878,43910,44775,44814,45173)
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 | 971 | 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.45 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.20 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.52 ms |
preparing | 0.78 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 7.93 ms |
end | 0.03 ms |
query end | 0.06 ms |
closing tables | 0.04 ms |
freeing items | 0.14 ms |
cleaning up | 0.05 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 |