Tiempo de la consulta: 3.86 ms Después de la última consulta: 0.79 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.174 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 23:18:53')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 23:18:53')
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,33,34,35,39,40,41,42,43,75,128,263,277,458,466,868,903,959,977,988,1080,1201,1207,1277,1308,1329,1340,1697,1720,1976,2109,2121,2456,2750,2767,2799,2827,2857,3059,3080,3169,3255,3302,3329,3442,3570,3617,3682,3715,3732,3782,3880,3974,3980,3986,4114,4177,4285,4306,4310,4748,4765,4872,5026,5085,5207,5208,5472,5479,5484,5530,5537,5647,5658,5698,5827,5833,5849,5874,5877,5934,5977,6141,6278,6279,6319,6351,6515,6517,6594,6608,6616,6628,6632,6658,6791,6833,6925,6933,6935,6969,7045,7077,7105,7136,7150,7162,7163,7164,7251,7264,7270,7321,7343,7389,7429,7436,7447,7516,7601,7675,7679,7743,7777,7835,7840,7854,7895,7954,8045,8052,8111,8397,8430,8441,8555,8567,8759,8903,8909,9304,9326,9351,9853,10033,10160,10163,10169,10192,10222,10272,10439,10443,10452,10453,10484,10485,10512,10554,10607,10661,10771,10810,10827,10926,10971,10987,11038,11045,11101,11171,11189,11207,11293,11295,11328,11399,11417,11427,11553,11594,11675,11716,11764,11828,11912,11945,11951,11992,12019,12092,12176,12321,12340,12516,12657,12665,12692,12794,12804,12912,12933,13019,13043,13055,13082,13162,13218,13242,13243,13306,13312,13323,13329,13334,13371,13410,13460,13495,13529,13551,13603,13604,13709,13733,13758,13772,13826,13911,13926,14076,14096,14115,14141,14147,14148,14151,14180,14200,14202,14246,14266,14270,14291,14375,14414,14470,14489,14491,14514,14521,14523,14555,14556,14613,14624,14632,14639,14681,14701,14751,14760,14851,14959,15048,15051,15068,15094,15122,15154,15214,15269,15273,15281,15301,15302,15326,15351,15354,15373,15418,15426,15475,15498,15582,15632,15677,15726,15750,15787,15842,15864,15893,15900,15913,15926,15949,15953,15979,16038,16060,16128,16145,16168,16199,16208,16235,16236,16283,16301,16305,16322,16327,16341,16366,16373,16405,16430,16460,16468,16486,16497,16564,16571,16620,16623,16653,16659,16673,16686,16742,16876,16903,16922,16942,16963,16965,16967,16996,17000,17042,17066,17088,17115,17125,17183,17218,17229,17266,17276,17277,17318,17406,17411,17427,17431,17434,17457,17486,17494,17498,17519,17541,17554,17568,17596,17707,17715,17732,17815,17846,17935,17953,17972,17993,18008,18048,18056,18069,18109,18111,18128,18244,18274,18281,18296,18352,18395,18408,18449,18453,18518,18539,18563,18592,18625,18627,18640,18648,18666,18674,18680,18698,18699,18718,18722,18746,18790,18812,18823,18825,18864,18889,18896,18938,18960,18961,18985,19000,19029,19109,19139,19191,19195,19266,19346,19368,19370,19469,19486,19490,19504,19510,19537,19542,19571,19580,19590,19621,19626,19662,19705,19807,19810,19818,19874,19883,19903,19919,19930,19934,19946,19948,19951,19971,19978,19995,20018,20020,20075,20089,20105,20164,20172,20186,20195,20226,20294,20312,20313,20327,20347,20359,20365,20371,20378,20388,20398,20407,20431,20462,20496,20498,20512,20513,20523,20596,20608,20662,20672,20685,20701,20702,20721,20777,20784,20795,20840,20870,20906,20914,20939,20957,20958,21054,21074,21106,21109,21110,21120,21135,21141,21160,21164,21219,21231,21238,21274,21339,21348,21373,21407,21446,21505,21510,21512,21552,21563,21568,21612,21638,21675,21733,21737,21765,21816,21878,21886,21923,21931,21947,21948,22025,22027,22073,22114,22122,22128,22144,22183,22185,22205,22211,22216,22254,22273,22277,22286,22294,22305,22307,22312,22319,22325,22338,22352,22360,22383,22387,22430,22475,22487,22504,22558,22563,22594,22605,22675,22700,22706,22770,22778,22849,22861,22877,22956,23030,23045,23067,23076,23079,23090,23112,23128,23163,23165,23189,23209,23244,23255,23263,23284,23303,23306,23307,23323,23330,23341,23366,23367,23375,23386,23393,23418,23443,23444,23458,23487,23534,23545,23635,23660,23689,23698,23709,23735,23770,23786,23819,23856,23880,23883,23895,23913,23917,23941,23950,23957,23994,24006,24020,24064,24084,24086,24114,24142,24150,24274,24276,24293,24297,24325,24347,24423,24471,24475,24495,24536,24559,24571,24574,24635,24638,24641,24667,24684,24698,24717,24756,24767,24769,24770,24807,24822,24828,24858,24877,24885,24902,24947,24987,25011,25012,25022,25056,25111,25162,25176,25208,25215,25248,25263,25273,25274,25280,25285,25297,25301,25313,25332,25348,25361,25394,25442,25443,25452,25477,25560,25580,25603,25650,25657,25671,25672,25676,25680,25681,25696,25697,25699,25711,25724,25755,25763,25799,25807,25820,25847,25882,25884,25907,25908,25932,25935,25947,25948,25958,25967,25971,26026,26030,26064,26133,26177,26193,26225,26230,26239,26250,26254,26292,26409,26423,26431,26456,26471,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,26861,26896,26928,26937,26976,26991,27014,27025,27028,27045,27056,27060,27082,27097,27152,27155,27156,27248,27261,27283,27318,27319,27362,27394,27417,27478,27512,27517,27544,27567,27589,27591,27634,27737,27738,27763,27789,27811,27822,27930,27948,27957,27998,28006,28020,28036,28135,28184,28309,28320,28342,28360,28361,28460,28472,28575,28594,28607,28620,28640,28675,28677,28690,28692,28702,28755,28765,28852,28916,29023,29123,29129,29241,29249,29250,29372,29413,29438,29533,29608,29618,29799,29890,29904,32374,34432,34451,34653,34750,35196,35645,35726,35871,36834,37125,37426,37735,37906,37907,38574,38666,38910,39286,39598,39634,39650,39761,40326,40585,40661,40727,40803,40860,40887,41158,41200,41217,41421,41747,42021,42486,42758,42789,44114)
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 | 910 | 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.46 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.20 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.46 ms |
preparing | 0.73 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.31 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.06 ms |
cleaning up | 0.02 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 |