Tiempo de la consulta: 4.17 ms Después de la última consulta: 0.94 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.316 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 23:00:38')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 23:00:38')
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(23,161,162,163,164,165,166,167,385,466,495,502,570,675,679,686,806,813,844,867,881,900,958,963,970,1017,1029,1039,1089,1095,1137,1143,1158,1195,1224,1226,1249,1298,1337,1344,1372,1446,1497,1503,1557,1720,1935,2064,2103,2109,2219,2325,2379,2404,2426,2439,2563,2625,2647,2767,2799,2827,2842,2857,2888,2916,2924,3037,3038,3207,3248,3276,3285,3462,3570,3617,3682,3715,3794,3812,3974,4105,4114,4204,4209,4285,4306,4310,4315,4446,4573,4944,5026,5034,5458,5484,5530,5537,5730,5849,5854,5874,5934,5977,6105,6277,6301,6340,6349,6442,6534,6561,6608,6629,6633,6644,6685,6736,6791,6804,6833,6878,6906,6925,6933,6969,6995,7026,7045,7124,7162,7163,7164,7218,7251,7264,7282,7296,7342,7343,7412,7436,7447,7490,7552,7679,7710,7752,7830,7838,7840,7854,8018,8045,8214,8281,8397,8430,8441,8555,8567,8903,9027,9036,9304,9326,9346,9415,9745,9834,9836,9854,10033,10043,10144,10160,10163,10169,10246,10272,10286,10304,10443,10453,10484,10512,10532,10554,10607,10661,10713,10769,10771,10800,10850,10952,11158,11170,11259,11262,11277,11320,11350,11399,11417,11427,11438,11452,11553,11716,11743,11821,11828,11872,11903,11914,11917,12019,12139,12410,12473,12567,12612,12675,12692,12713,12925,12933,12944,12952,12969,13019,13061,13188,13219,13251,13262,13312,13323,13334,13384,13442,13456,13510,13551,13604,13659,13694,13733,13911,13926,13966,14082,14141,14168,14178,14180,14205,14237,14246,14266,14270,14287,14369,14375,14382,14487,14491,14504,14525,14527,14529,14613,14624,14632,14655,14671,14692,14696,14701,14751,14760,14807,14812,14865,15005,15030,15048,15061,15094,15111,15125,15146,15149,15155,15202,15214,15259,15273,15281,15308,15330,15346,15351,15360,15375,15426,15474,15475,15487,15497,15542,15547,15565,15582,15635,15668,15677,15726,15748,15750,15836,15844,15850,15858,15881,15906,15930,15949,15953,16038,16042,16060,16062,16128,16168,16236,16303,16305,16322,16343,16344,16366,16430,16467,16486,16497,16522,16547,16561,16564,16571,16623,16671,16673,16683,16742,16754,16782,16827,16903,16949,16963,16985,17042,17066,17088,17123,17124,17138,17184,17220,17222,17266,17286,17318,17389,17402,17406,17411,17425,17431,17443,17491,17515,17704,17715,17759,17846,17858,17921,18008,18033,18109,18128,18159,18292,18302,18398,18409,18453,18506,18517,18625,18646,18648,18666,18668,18672,18698,18699,18718,18721,18768,18864,18939,18985,19000,19018,19020,19060,19064,19102,19111,19139,19191,19193,19200,19233,19264,19368,19406,19475,19504,19571,19580,19583,19626,19705,19746,19776,19807,19813,19818,19854,19903,19918,19919,19920,19930,19946,19948,19951,19956,19978,20018,20020,20089,20105,20126,20186,20221,20226,20289,20294,20312,20336,20359,20361,20363,20371,20388,20431,20498,20513,20523,20556,20558,20596,20608,20655,20671,20672,20721,20773,20777,20779,20784,20794,20809,20830,20870,20906,21074,21100,21110,21135,21160,21166,21223,21231,21244,21294,21297,21323,21339,21420,21505,21510,21512,21536,21546,21705,21733,21739,21752,21765,21816,21831,21878,21947,21972,21992,22027,22114,22122,22127,22144,22169,22185,22196,22205,22216,22238,22254,22270,22273,22277,22305,22312,22317,22333,22347,22348,22383,22386,22430,22468,22492,22508,22548,22553,22563,22571,22582,22592,22605,22645,22656,22706,22707,22711,22770,22775,22788,22804,22836,22877,22883,22949,22974,23031,23033,23076,23091,23112,23148,23188,23189,23204,23209,23263,23286,23296,23306,23307,23367,23393,23418,23444,23458,23459,23488,23612,23689,23698,23707,23709,23762,23770,23783,23786,23819,23843,23856,23883,23895,23917,23941,23957,23994,24018,24020,24023,24064,24083,24086,24114,24119,24219,24228,24282,24297,24366,24413,24423,24471,24536,24550,24559,24571,24574,24576,24621,24635,24641,24684,24723,24735,24747,24756,24760,24807,24812,24817,24822,24841,24855,24860,24863,24899,24964,24976,25022,25099,25111,25125,25134,25174,25176,25215,25273,25274,25297,25325,25332,25348,25361,25374,25382,25394,25452,25477,25512,25545,25560,25567,25580,25603,25621,25650,25657,25671,25672,25676,25680,25681,25696,25697,25699,25703,25711,25717,25724,25755,25799,25807,25820,25847,25884,25907,25908,25935,25938,25948,25958,25967,25971,25985,26030,26041,26064,26133,26173,26177,26193,26225,26230,26239,26250,26292,26409,26431,26456,26507,26508,26529,26541,26543,26559,26571,26582,26596,26605,26651,26664,26678,26685,26715,26723,26725,26740,26743,26749,26750,26756,26765,26767,26768,26801,26809,26818,26859,26860,26896,26937,26976,26991,27025,27028,27045,27056,27060,27082,27097,27143,27145,27155,27248,27261,27283,27318,27417,27478,27512,27544,27567,27589,27591,27634,27737,27738,27746,27763,27789,27811,27822,27930,27948,27957,27998,28006,28036,28135,28184,28309,28320,28342,28360,28361,28460,28472,28505,28620,28675,28690,28702,28755,28852,28916,29023,29123,29129,29241,29249,29250,29413,29438,29533,29536,29608,29618,29697,29799,29890,29904,32374,34432,34451,34653,34750,35196,35645,35871,35893,35899,35975,36154,36367,36402,36490,36583,36897,37345,37426,37503,38226,38237,38352,38666,38850,38899,38991,39214,39286,39558,39580,39677,39716,39737,39761,39801,39892,40120,40272,40375,40594,40661,40727,40739,40773,40860,40887,40973,41122,41158,41200,41217,41421,41475,41636,41761,41826,42486,42563,42591,42680,42758,42766,42944,43330,43569,43570,43571,43755,43856,43972,43973,44143,44160,44469,44843,44933,44998)
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 | 904 | 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.60 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.19 ms |
System lock | 0.02 ms |
optimizing | 0.09 ms |
statistics | 1.41 ms |
preparing | 0.73 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.30 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.05 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 |