Tiempo de la consulta: 4.34 ms Después de la última consulta: 0.86 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.305 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-03 22:16:10')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-03 22:16:10')
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(11,23,49,58,147,148,149,150,151,152,153,154,155,385,389,437,458,466,686,799,806,813,844,868,956,970,986,1018,1053,1091,1139,1185,1186,1207,1233,1277,1298,1324,1503,1720,1817,1835,2109,2713,2767,2799,2827,2857,2964,3020,3209,3210,3322,3519,3570,3617,3682,3692,3715,3974,3986,4013,4076,4114,4281,4285,4306,4310,4405,4670,5026,5300,5484,5525,5530,5537,5849,5874,5894,5934,6165,6362,6484,6600,6608,6633,6654,6681,6684,6725,6726,6744,6749,6785,6833,6843,6905,6911,6925,6933,6955,6971,7101,7162,7163,7164,7251,7264,7285,7296,7328,7343,7435,7436,7447,7456,7544,7679,7688,7710,7797,7806,7840,7854,7858,7863,8027,8045,8250,8397,8430,8441,8555,8567,8610,8663,8679,8692,8903,9242,9282,9304,9305,9326,9507,9626,9864,10033,10160,10163,10169,10206,10239,10264,10272,10301,10315,10425,10443,10453,10473,10484,10512,10535,10541,10554,10607,10611,10644,10661,10741,10771,10779,10849,10907,10949,10952,11059,11091,11207,11417,11427,11553,11716,11828,11896,11924,12010,12013,12019,12165,12301,12398,12482,12625,12692,12758,12850,12933,13019,13061,13100,13312,13323,13334,13481,13519,13551,13604,13635,13876,13894,13958,14093,14107,14140,14141,14180,14189,14194,14205,14246,14266,14375,14401,14457,14491,14591,14613,14624,14631,14632,14698,14701,14725,14751,14760,14829,14847,14865,14911,14943,14999,15038,15048,15063,15094,15158,15171,15177,15187,15214,15233,15259,15270,15273,15281,15346,15351,15361,15407,15418,15426,15429,15469,15475,15480,15487,15516,15546,15582,15629,15677,15688,15726,15750,15850,15863,15875,15937,15949,15953,15981,15987,16024,16038,16043,16056,16090,16129,16155,16197,16211,16236,16281,16305,16322,16323,16338,16359,16366,16430,16438,16486,16497,16524,16547,16561,16564,16571,16623,16626,16668,16673,16689,16717,16718,16742,16755,16816,16840,16863,16903,16923,16951,16963,17002,17066,17067,17086,17088,17122,17148,17180,17203,17242,17253,17266,17273,17282,17287,17339,17360,17406,17411,17431,17490,17509,17539,17572,17618,17656,17659,17701,17715,17727,17759,17782,17818,17826,17846,17853,17870,17879,17893,17920,18008,18022,18074,18083,18109,18128,18173,18219,18220,18311,18352,18354,18450,18453,18464,18572,18625,18648,18666,18696,18698,18699,18718,18864,18866,18880,18911,18953,18985,19000,19004,19014,19060,19063,19121,19155,19167,19191,19217,19231,19248,19283,19297,19308,19328,19368,19407,19457,19482,19504,19571,19580,19583,19591,19613,19617,19626,19648,19705,19718,19733,19747,19807,19818,19854,19903,19919,19946,19948,19951,19978,19992,20015,20018,20020,20023,20088,20089,20105,20127,20171,20179,20186,20226,20289,20294,20312,20333,20359,20371,20388,20431,20437,20498,20513,20522,20523,20590,20596,20607,20608,20615,20664,20672,20710,20721,20737,20777,20784,20858,20862,20870,20906,20947,20985,21074,21079,21110,21126,21128,21135,21160,21187,21223,21231,21270,21297,21323,21339,21372,21417,21496,21505,21510,21512,21555,21733,21757,21765,21816,21878,21879,21947,21987,22011,22027,22040,22058,22089,22099,22114,22118,22122,22144,22185,22205,22216,22254,22273,22277,22305,22306,22312,22359,22375,22383,22430,22484,22513,22605,22706,22753,22786,22859,22877,22909,22935,22974,22976,23011,23019,23021,23076,23112,23139,23189,23209,23221,23242,23263,23306,23307,23367,23393,23398,23422,23430,23439,23444,23456,23458,23525,23555,23562,23585,23602,23689,23694,23698,23709,23761,23770,23786,23818,23826,23853,23883,23895,23910,23917,23936,23941,23957,23958,23994,24020,24034,24064,24086,24114,24202,24220,24297,24326,24364,24423,24429,24471,24525,24526,24536,24559,24571,24574,24577,24635,24641,24668,24684,24756,24807,24812,24822,24849,24868,24941,24975,25022,25070,25071,25081,25111,25153,25176,25215,25273,25274,25280,25297,25310,25332,25348,25352,25361,25394,25427,25452,25477,25535,25550,25560,25580,25603,25650,25653,25657,25671,25672,25676,25680,25681,25696,25697,25699,25711,25724,25747,25755,25785,25794,25799,25807,25820,25847,25884,25900,25907,25908,25921,25935,25947,25948,25958,25967,25971,26008,26030,26050,26064,26133,26145,26177,26193,26225,26230,26239,26250,26292,26358,26367,26409,26431,26444,26456,26507,26508,26516,26529,26541,26543,26559,26571,26582,26583,26596,26605,26651,26664,26678,26685,26698,26715,26723,26725,26740,26743,26749,26750,26756,26767,26768,26801,26809,26818,26859,26860,26896,26937,26976,26991,27002,27009,27024,27025,27028,27045,27055,27056,27060,27097,27101,27155,27218,27248,27261,27318,27417,27478,27512,27544,27567,27589,27591,27634,27673,27737,27738,27763,27789,27811,27822,27930,27948,27957,27998,28006,28035,28036,28075,28135,28184,28309,28320,28342,28360,28361,28460,28472,28620,28675,28690,28702,28755,28852,28916,29023,29123,29129,29241,29249,29250,29372,29378,29413,29438,29533,29608,29617,29618,29799,29809,29890,29895,29904,30486,31115,32374,32676,34432,34451,34653,34750,35196,35614,35645,35744,35871,35882,36020,36324,37426,38666,39286,39761,39857,40203,40356,40483,40661,40727,40860,40887,41158,41200,41217,41421,41500,42486,42758)
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 | 845 | 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.51 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.18 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.46 ms |
preparing | 0.88 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.44 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.12 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 |