Tiempo de la consulta: 13.71 ms Después de la última consulta: 0.90 ms Consulta a la memoria: 1.487 MB memoria antes de la consulta: 4.359 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 16:46:51')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 16:46:51')
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(9,11,14,35,49,58,62,95,147,148,149,150,151,152,153,154,155,163,174,213,263,308,344,354,357,385,389,437,458,670,686,708,710,711,712,713,723,783,799,813,827,831,844,868,956,970,986,1018,1053,1065,1080,1091,1139,1182,1185,1186,1196,1207,1231,1233,1277,1289,1298,1324,1346,1361,1364,1422,1437,1456,1501,1503,1538,1555,1607,1623,1679,1756,1757,1796,1817,1825,1835,1919,1922,2013,2041,2042,2047,2188,2224,2285,2302,2353,2392,2415,2604,2608,2611,2695,2705,2713,2797,2827,2857,2893,2964,2967,2993,3018,3020,3055,3109,3123,3125,3180,3209,3210,3322,3364,3393,3451,3480,3519,3571,3664,3692,3737,3829,3871,3931,3932,3986,4013,4076,4166,4281,4339,4405,4488,4503,4670,4699,4713,4767,4910,4973,5161,5247,5300,5348,5439,5525,5570,5617,5749,5785,5798,5881,5894,5968,6062,6076,6150,6256,6275,6331,6362,6440,6454,6472,6473,6484,6548,6568,6600,6633,6654,6673,6684,6725,6726,6735,6744,6749,6785,6897,6905,6911,6955,6971,7013,7014,7081,7101,7139,7246,7272,7285,7296,7328,7357,7435,7439,7456,7528,7544,7545,7594,7633,7688,7704,7710,7722,7797,7806,7858,7860,7863,7923,7934,7992,7997,8015,8027,8061,8116,8147,8173,8190,8222,8250,8297,8416,8480,8532,8533,8587,8603,8613,8663,8679,8692,8706,8776,8894,8983,9079,9242,9282,9305,9320,9422,9434,9507,9554,9626,9677,9727,9766,9767,9773,9820,9864,9894,9924,9942,9963,10008,10019,10071,10078,10206,10239,10263,10264,10307,10315,10340,10416,10425,10471,10530,10535,10563,10611,10630,10644,10673,10694,10741,10779,10783,10907,10952,10958,10968,11059,11091,11207,11247,11258,11397,11402,11446,11626,11896,11924,12165,12218,12301,12331,12388,12398,12401,12463,12474,12482,12564,12599,12622,12625,12677,12686,12718,12752,12758,12850,12875,12945,13006,13061,13068,13100,13154,13190,13276,13481,13519,13553,13612,13635,13645,13697,13742,13759,13894,13926,13963,13990,14048,14074,14082,14101,14107,14117,14132,14139,14140,14189,14194,14205,14244,14262,14273,14324,14395,14401,14440,14456,14457,14487,14507,14591,14630,14631,14683,14698,14725,14794,14816,14829,14847,14865,14911,14964,14983,14999,15031,15032,15038,15048,15059,15063,15079,15094,15108,15111,15115,15129,15139,15158,15171,15177,15187,15213,15224,15233,15259,15270,15346,15361,15370,15407,15418,15429,15469,15487,15516,15523,15548,15575,15725,15747,15757,15763,15782,15850,15863,15875,15935,15937,15981,15987,16000,16005,16024,16043,16056,16090,16092,16093,16124,16129,16140,16153,16155,16206,16211,16281,16323,16326,16338,16359,16374,16438,16458,16465,16524,16534,16547,16561,16564,16571,16626,16668,16689,16717,16816,16832,16840,16843,16863,16877,16889,16951,16976,16981,17002,17067,17086,17115,17116,17128,17148,17169,17184,17188,17215,17242,17253,17257,17273,17282,17287,17288,17339,17343,17360,17374,17382,17432,17490,17509,17539,17541,17572,17596,17611,17618,17631,17634,17659,17701,17727,17733,17759,17782,17818,17826,17840,17853,17870,17879,17893,17895,17920,17980,18007,18022,18031,18059,18074,18083,18173,18219,18220,18311,18352,18369,18379,18403,18427,18447,18450,18463,18464,18499,18561,18563,18572,18577,18593,18594,18612,18648,18682,18691,18696,18866,18880,18910,18911,18912,18920,18942,18944,18953,18977,18982,18991,18995,19000,19004,19014,19022,19054,19060,19063,19078,19083,19091,19110,19132,19136,19149,19155,19188,19217,19231,19247,19260,19265,19270,19283,19294,19297,19308,19331,19407,19411,19447,19453,19457,19482,19507,19524,19545,19583,19591,19595,19608,19617,19648,19650,19652,19660,19661,19684,19720,19730,19733,19747,19790,19815,19854,19894,19921,19930,19931,19932,19941,19944,19983,19991,20015,20023,20034,20054,20069,20076,20100,20127,20143,20145,20179,20183,20199,20207,20215,20289,20333,20344,20354,20363,20374,20403,20426,20440,20458,20472,20510,20522,20559,20578,20607,20615,20636,20638,20664,20704,20710,20737,20824,20826,20856,20858,20947,21000,21008,21009,21015,21020,21078,21079,21101,21118,21126,21128,21161,21178,21181,21187,21210,21223,21227,21242,21252,21268,21270,21297,21305,21319,21323,21372,21392,21433,21440,21458,21464,21469,21496,21522,21546,21555,21586,21592,21714,21737,21757,21862,21879,21952,21987,22011,22040,22059,22089,22099,22100,22119,22159,22306,22315,22359,22393,22419,22431,22435,22455,22477,22484,22492,22500,22502,22527,22596,22607,22645,22673,22708,22715,22742,22753,22786,22803,22830,22874,22878,22909,22935,22974,22976,22977,23000,23011,23019,23022,23034,23042,23122,23139,23148,23219,23221,23242,23247,23286,23318,23344,23375,23398,23430,23439,23456,23467,23525,23546,23555,23559,23562,23564,23585,23594,23602,23622,23639,23691,23703,23732,23761,23772,23826,23828,23853,23857,23874,23910,23930,23936,23958,23959,23962,23967,23984,24004,24010,24024,24034,24072,24075,24076,24111,24176,24202,24220,24230,24236,24263,24326,24346,24364,24429,24497,24505,24523,24526,24577,24607,24616,24623,24668,24673,24788,24843,24849,24857,24862,24868,24885,24924,24941,24964,24975,25003,25008,25022,25048,25070,25071,25081,25082,25126,25153,25273,25280,25310,25332,25349,25352,25360,25373,25374,25415,25421,25535,25648,25653,25676,25747,25764,25785,25788,25798,25833,25921,25967,25987,26008,26050,26078,26107,26122,26176,26205,26221,26358,26367,26374,26444,26522,26530,26564,26583,26698,26715,26716,26816,26926,26982,27002,27009,27024,27026,27055,27082,27101,27150,27151,27161,27174,27213,27218,27230,27259,27272,27293,27294,27295,27315,27317,27356,27384,27497,27506,27524,27558,27572,27577,27860,28005,28075,28397,28424,28773,28780,28824,29021,29089,29124,29256,29358,29372,29378,29553,29617,29618,29672,29810,29919,29930,31115,31227,31499,31516,32078,32676,33815,35731,35744,35878,35882,36893,36916,36918,37315,37380,37573,37874,37996,38011,38015,38016,38018,38020,38023,38034,38049,38055,38056,38066,38361,38455,38734,38775,38812,39307,39358,39452,39474,39504,39505,39516,39857,39966,40169,40203,40312,40313,40314,40356,40360,40483,40542,40558,40801,41036,41063,41163,41402,41423,41811,41885,42460,42489,43680,43705,43706,43707,43914,43915,43917,44031,44041,44091,44136,44497,44681,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 | 1042 | 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.03 ms |
init | 0.20 ms |
System lock | 0.02 ms |
optimizing | 0.08 ms |
statistics | 1.64 ms |
preparing | 0.77 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 9.84 ms |
end | 0.03 ms |
query end | 0.07 ms |
closing tables | 0.03 ms |
freeing items | 0.11 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 |