Tiempo de la consulta: 4.59 ms Después de la última consulta: 0.84 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.178 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 20:40:43')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-03 20:40:43')
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,70,72,75,126,127,128,167,263,277,458,466,693,747,868,903,945,946,988,998,1080,1201,1207,1277,1329,1340,1697,1720,1976,2109,2150,2204,2209,2235,2631,2666,2705,2750,2767,2799,2827,2857,2872,2944,3080,3125,3152,3255,3302,3329,3442,3570,3617,3682,3715,3732,3782,3880,3974,3980,3986,4105,4114,4217,4268,4285,4306,4310,4722,4765,4868,4872,5026,5085,5207,5208,5397,5472,5484,5530,5537,5586,5647,5658,5698,5718,5799,5827,5833,5849,5874,5877,5934,6141,6257,6278,6279,6319,6515,6517,6594,6608,6610,6611,6616,6628,6632,6658,6791,6833,6925,6933,6935,6969,7045,7077,7105,7136,7150,7162,7163,7164,7181,7243,7251,7264,7270,7275,7288,7335,7343,7429,7436,7447,7675,7679,7743,7777,7835,7840,7854,7858,7895,7919,7954,8015,8045,8052,8397,8406,8430,8441,8555,8567,8759,8903,8909,9207,9286,9304,9326,9351,9853,10033,10075,10160,10163,10169,10192,10202,10222,10272,10439,10443,10452,10453,10484,10485,10512,10519,10554,10607,10661,10758,10771,10810,10827,10924,10926,10971,10982,10987,11038,11045,11101,11171,11189,11261,11268,11293,11328,11399,11417,11427,11553,11675,11716,11764,11828,11912,11945,11951,11990,11992,12004,12019,12092,12176,12321,12340,12516,12554,12657,12665,12677,12692,12773,12794,12804,12912,12933,12964,13019,13043,13055,13067,13082,13128,13162,13218,13242,13243,13306,13312,13323,13329,13334,13371,13410,13460,13495,13529,13551,13603,13604,13611,13681,13709,13733,13758,13759,13772,13826,13838,13861,13911,13926,14005,14076,14096,14115,14141,14147,14148,14180,14200,14201,14202,14246,14266,14270,14279,14291,14375,14470,14489,14491,14521,14523,14534,14555,14556,14570,14613,14624,14632,14639,14701,14751,14760,14839,14851,14959,15048,15051,15094,15122,15154,15214,15269,15273,15281,15301,15326,15351,15354,15373,15378,15418,15426,15475,15498,15582,15632,15677,15680,15726,15750,15787,15842,15864,15893,15900,15913,15926,15949,15953,15979,16038,16060,16128,16145,16168,16199,16208,16235,16236,16283,16305,16322,16327,16341,16356,16366,16373,16405,16408,16418,16430,16460,16468,16486,16497,16533,16535,16564,16565,16571,16623,16659,16673,16686,16714,16742,16903,16922,16924,16925,16963,16965,16996,17042,17061,17066,17088,17115,17125,17183,17229,17266,17271,17276,17318,17406,17431,17434,17457,17459,17494,17519,17541,17554,17568,17596,17614,17651,17707,17715,17812,17815,17832,17846,17897,17935,17953,17972,17993,18008,18048,18056,18069,18109,18128,18221,18244,18281,18296,18352,18395,18408,18449,18453,18479,18492,18518,18539,18563,18592,18594,18621,18625,18627,18640,18648,18666,18674,18680,18690,18698,18699,18718,18722,18737,18746,18765,18790,18793,18812,18823,18825,18864,18889,18896,18921,18938,18960,18969,18985,18998,19000,19029,19109,19139,19191,19195,19202,19266,19292,19298,19346,19368,19370,19401,19469,19483,19490,19504,19510,19516,19537,19542,19571,19580,19590,19605,19621,19623,19626,19662,19682,19705,19770,19807,19810,19818,19883,19903,19919,19930,19946,19948,19951,19971,19978,19995,20018,20020,20058,20075,20089,20105,20116,20164,20172,20186,20195,20226,20280,20294,20312,20313,20347,20359,20365,20371,20378,20388,20398,20407,20431,20462,20496,20498,20512,20513,20523,20596,20608,20609,20662,20672,20685,20701,20721,20777,20784,20795,20816,20840,20870,20906,20914,20939,20958,21054,21074,21101,21106,21110,21120,21135,21141,21160,21164,21219,21231,21238,21274,21339,21348,21373,21407,21446,21469,21505,21510,21512,21552,21563,21568,21592,21612,21638,21651,21675,21697,21733,21737,21765,21816,21878,21886,21923,21931,21947,21948,22025,22027,22073,22114,22122,22128,22144,22147,22185,22205,22211,22216,22254,22273,22277,22286,22294,22305,22307,22311,22312,22319,22325,22338,22352,22360,22378,22383,22387,22430,22487,22504,22558,22594,22605,22664,22675,22700,22706,22770,22778,22849,22861,22877,22905,22956,23028,23030,23044,23045,23067,23076,23079,23090,23112,23128,23152,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,23592,23635,23660,23689,23698,23702,23709,23735,23770,23786,23819,23822,23856,23883,23895,23913,23917,23941,23950,23957,23994,24006,24020,24035,24041,24059,24064,24084,24086,24114,24142,24266,24276,24293,24297,24325,24347,24353,24423,24471,24475,24495,24536,24559,24571,24574,24635,24638,24641,24677,24684,24692,24698,24717,24753,24756,24767,24769,24770,24777,24783,24807,24812,24822,24828,24831,24858,24877,24902,24947,24987,24999,25011,25012,25022,25041,25056,25111,25162,25176,25208,25215,25248,25263,25273,25274,25280,25297,25301,25313,25332,25348,25361,25394,25442,25452,25477,25560,25580,25603,25650,25657,25671,25672,25676,25680,25681,25696,25697,25699,25711,25724,25725,25732,25755,25763,25799,25807,25820,25847,25882,25884,25907,25908,25932,25935,25947,25948,25958,25967,25971,26030,26064,26078,26133,26177,26193,26225,26230,26239,26250,26292,26409,26423,26431,26456,26507,26508,26529,26531,26541,26543,26559,26571,26582,26596,26605,26638,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,27008,27014,27025,27028,27045,27056,27060,27082,27097,27152,27155,27248,27261,27264,27283,27318,27319,27362,27394,27417,27478,27512,27517,27544,27567,27589,27591,27634,27737,27738,27763,27789,27811,27822,27930,27948,27954,27957,27998,28006,28020,28036,28104,28135,28184,28309,28320,28342,28360,28361,28460,28472,28607,28620,28640,28675,28677,28690,28692,28702,28755,28765,28852,28916,29023,29123,29129,29241,29249,29250,29289,29413,29438,29533,29608,29618,29647,29799,29890,29904,32374,34432,34451,34653,34750,35059,35196,35645,35646,35726,35871,36549,36834,37105,37107,37426,38666,38953,38992,39195,39286,39410,39650,39761,39913,40304,40661,40727,40860,40887,41158,41200,41217,41421,42073,42384,42486,42758,44197,44442)
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 | 1001 | 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.55 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.11 ms |
statistics | 1.62 ms |
preparing | 0.85 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.32 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.06 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 |