Tiempo de la consulta: 5.60 ms Después de la última consulta: 1.32 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.388 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-08 20:13:32')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-08 20:13:32')
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,49,58,70,71,72,73,75,85,101,112,113,114,119,120,121,122,123,124,161,162,163,164,165,166,167,175,180,185,263,275,282,283,284,295,353,354,356,357,358,359,360,361,363,364,376,377,385,391,414,417,437,446,458,460,477,493,500,501,502,516,523,545,570,581,583,607,617,655,669,670,671,686,701,707,723,728,741,746,756,757,800,806,813,816,831,844,867,868,870,881,895,903,917,946,953,954,958,963,965,970,986,987,1017,1020,1033,1045,1067,1075,1080,1081,1090,1120,1123,1137,1143,1148,1169,1178,1198,1207,1214,1224,1226,1273,1277,1291,1298,1303,1304,1308,1324,1336,1344,1386,1503,1519,1718,1745,1804,1823,1827,2023,2105,2290,2293,2305,2322,2410,2477,2610,2630,2713,2853,2858,2886,2887,2939,2964,2983,3039,3169,3208,3209,3219,3229,3294,3347,3393,3442,3449,3452,3463,3604,3672,3673,3696,3700,3761,3784,3794,3825,3880,3911,3984,3986,4105,4114,4209,4268,4378,4422,4438,4674,4676,4710,4739,4874,5136,5150,5182,5300,5302,5373,5451,5579,5597,5647,5659,5685,5725,5729,5730,5731,5732,5798,5799,5833,5894,5896,6012,6039,6141,6142,6147,6257,6298,6301,6349,6350,6411,6442,6470,6473,6478,6516,6541,6542,6543,6545,6557,6573,6574,6601,6616,6633,6645,6665,6690,6727,6748,6841,6854,6878,6895,6939,6955,6990,6994,7001,7026,7124,7135,7138,7139,7191,7244,7269,7284,7296,7304,7342,7365,7377,7378,7380,7387,7401,7402,7417,7419,7430,7453,7459,7488,7489,7547,7551,7552,7581,7625,7627,7629,7682,7710,7718,7730,7741,7749,7753,7774,7779,7829,7830,7838,7847,7851,7860,7864,7934,7950,7965,7984,7986,8018,8026,8027,8058,8067,8074,8090,8093,8154,8190,8338,8354,8381,8502,8555,8638,8663,8666,8754,8764,8860,8886,8974,9024,9029,9059,9318,9351,9355,9398,9452,9491,9616,9704,9853,9886,9924,10023,10078,10092,10100,10120,10144,10181,10226,10239,10246,10263,10268,10314,10345,10364,10370,10380,10384,10412,10416,10503,10511,10540,10572,10600,10601,10611,10628,10665,10686,10696,10719,10738,10768,10771,10800,10850,10876,10952,10959,10964,10971,10980,10982,10989,11001,11029,11032,11060,11082,11094,11095,11108,11150,11152,11158,11178,11191,11204,11219,11224,11229,11259,11265,11320,11327,11328,11350,11369,11377,11383,11404,11427,11433,11446,11452,11477,11523,11534,11542,11598,11678,11743,11754,11806,11835,11851,11914,11917,11944,11948,11954,12019,12031,12078,12096,12115,12116,12121,12125,12153,12156,12171,12224,12259,12299,12307,12309,12367,12444,12473,12510,12536,12546,12554,12559,12563,12571,12605,12612,12625,12643,12670,12675,12688,12713,12715,12737,12791,12834,12856,12872,12902,12914,12925,12944,12948,12952,12969,13006,13010,13061,13067,13081,13140,13157,13172,13189,13211,13219,13251,13253,13323,13344,13350,13408,13425,13442,13444,13487,13488,13493,13510,13516,13532,13534,13542,13557,13571,13602,13615,13618,13645,13649,13653,13675,13694,13714,13741,13806,13861,13863,13874,13889,13901,13916,13945,13963,13966,13972,13990,14000,14024,14074,14082,14132,14141,14152,14158,14163,14168,14178,14205,14219,14227,14237,14240,14243,14249,14250,14269,14280,14281,14287,14292,14293,14369,14371,14382,14385,14396,14401,14426,14435,14487,14504,14508,14523,14527,14529,14572,14591,14596,14634,14638,14655,14665,14670,14671,14693,14726,14754,14759,14812,14817,14830,14837,14838,14846,14849,14865,14895,14909,14911,14935,14961,15005,15024,15030,15038,15039,15061,15069,15079,15094,15114,15125,15151,15174,15197,15202,15258,15259,15268,15277,15278,15306,15308,15315,15331,15353,15360,15372,15375,15411,15444,15475,15487,15494,15496,15520,15524,15542,15547,15579,15606,15695,15717,15726,15739,15750,15757,15782,15835,15836,15844,15850,15858,15881,15885,15896,15899,15906,15930,15939,15953,16001,16002,16014,16022,16042,16062,16086,16091,16101,16156,16162,16183,16264,16276,16286,16303,16337,16344,16356,16375,16386,16410,16414,16418,16467,16468,16472,16495,16515,16522,16541,16547,16561,16585,16621,16623,16640,16646,16683,16695,16715,16717,16723,16748,16754,16782,16790,16808,16809,16816,16818,16862,16907,16921,16943,16996,16998,17046,17069,17090,17092,17105,17115,17123,17132,17193,17205,17220,17224,17230,17234,17286,17290,17307,17314,17321,17343,17344,17361,17386,17391,17402,17407,17426,17442,17443,17461,17486,17500,17515,17538,17571,17575,17584,17585,17598,17611,17630,17633,17650,17663,17679,17691,17700,17708,17735,17748,17749,17753,17759,17761,17777,17783,17813,17817,17822,17838,17839,17852,17854,17858,17869,17876,17877,17882,17921,17925,17935,17947,17956,17993,18001,18009,18018,18032,18033,18034,18052,18079,18084,18122,18134,18142,18143,18159,18176,18200,18216,18220,18222,18226,18253,18260,18261,18264,18274,18279,18282,18292,18295,18302,18308,18311,18332,18333,18360,18375,18388,18390,18398,18406,18409,18424,18455,18459,18494,18504,18506,18517,18520,18522,18554,18559,18562,18563,18570,18593,18596,18598,18605,18619,18648,18651,18653,18668,18672,18700,18718,18721,18733,18746,18762,18773,18775,18790,18793,18794,18811,18822,18825,18849,18850,18861,18905,18908,18912,18939,18944,18949,18961,18982,18995,19005,19006,19010,19022,19026,19060,19073,19086,19102,19110,19117,19134,19152,19181,19200,19226,19260,19264,19294,19304,19367,19381,19388,19404,19416,19428,19429,19437,19449,19453,19462,19467,19496,19507,19508,19545,19576,19581,19583,19596,19601,19604,19606,19624,19627,19645,19646,19648,19650,19652,19657,19663,19667,19677,19713,19733,19744,19746,19764,19768,19771,19774,19776,19813,19824,19825,19826,19827,19830,19853,19854,19856,19857,19858,19862,19882,19913,19921,19929,19938,19956,19973,20001,20020,20029,20047,20053,20088,20097,20126,20127,20180,20184,20194,20217,20221,20232,20243,20256,20264,20266,20277,20289,20291,20304,20336,20350,20354,20370,20389,20398,20411,20440,20455,20467,20488,20489,20496,20525,20529,20542,20546,20558,20560,20564,20579,20626,20630,20647,20651,20656,20660,20672,20707,20710,20711,20714,20735,20736,20749,20764,20773,20795,20798,20802,20803,20805,20820,20826,20830,20865,20891,20919,20944,20945,20977,20982,20986,20988,21004,21005,21009,21011,21100,21101,21109,21111,21116,21123,21135,21151,21158,21167,21183,21222,21223,21246,21252,21263,21269,21272,21274,21292,21301,21305,21313,21317,21322,21372,21376,21394,21400,21416,21419,21427,21450,21493,21502,21510,21520,21534,21545,21556,21575,21584,21586,21589,21612,21614,21618,21620,21633,21659,21698,21705,21721,21735,21739,21752,21756,21851,21888,21899,21921,21947,21972,21992,21999,22010,22028,22043,22056,22071,22089,22098,22100,22103,22127,22169,22174,22178,22196,22197,22206,22215,22222,22228,22251,22263,22270,22283,22290,22298,22307,22318,22319,22325,22328,22333,22343,22366,22374,22386,22412,22432,22436,22446,22452,22455,22468,22476,22496,22508,22523,22527,22528,22539,22548,22555,22592,22647,22669,22682,22688,22696,22707,22713,22722,22726,22741,22747,22788,22803,22804,22807,22820,22831,22835,22836,22852,22883,22900,22901,22935,22949,22974,22976,22979,22985,23031,23041,23070,23091,23118,23127,23204,23208,23240,23243,23249,23251,23296,23318,23355,23357,23378,23399,23420,23428,23430,23433,23436,23446,23449,23459,23463,23467,23476,23484,23486,23492,23514,23527,23546,23555,23574,23575,23585,23586,23601,23616,23617,23629,23635,23648,23665,23676,23682,23693,23703,23707,23719,23727,23730,23746,23759,23764,23779,23781,23783,23806,23817,23825,23843,23863,23882,23898,23921,23926,23951,23988,23992,23996,24018,24021,24023,24025,24033,24082,24083,24084,24099,24101,24112,24119,24135,24144,24176,24186,24211,24228,24239,24241,24292,24308,24328,24366,24390,24413,24433,24475,24480,24481,24484,24504,24505,24513,24539,24563,24566,24577,24621,24668,24688,24706,24709,24721,24726,24735,24747,24754,24756,24759,24767,24790,24798,24809,24816,24817,24832,24841,24855,24859,24868,24883,24888,24910,24928,24943,24948,24953,24976,24996,25003,25024,25026,25035,25048,25099,25105,25107,25111,25120,25135,25155,25175,25188,25201,25263,25267,25274,25277,25280,25288,25322,25325,25326,25330,25337,25382,25383,25386,25416,25440,25471,25486,25497,25512,25514,25539,25545,25548,25648,25657,25678,25680,25691,25741,25764,25790,25813,25821,25859,25864,25889,25925,25946,25947,25949,25955,26042,26043,26066,26099,26102,26105,26117,26134,26135,26187,26204,26221,26228,26240,26317,26366,26379,26431,26444,26469,26480,26494,26541,26542,26603,26606,26622,26634,26639,26709,26743,26769,26778,26902,26923,27057,27072,27125,27143,27145,27153,27170,27213,27220,27221,27262,27282,27316,27362,27367,27372,27375,27406,27427,27438,27475,27535,27571,27644,27650,27677,27738,27827,27870,27929,27939,27985,28120,28163,28166,28169,28256,28327,28336,28465,28537,28627,28630,28639,28662,28680,28681,28682,28683,28702,28710,28739,28781,28803,28844,28847,29022,29064,29133,29331,29379,29417,29571,29624,29646,29659,29727,29931,29937,29939,30050,30285,30318,30723,30790,30991,31213,31651,31850,31876,31907,32058,33877,35495,35893,36323,37078,37080,39088,39158,39269,39370,39384,39411,39513,39542,39646,39666,39716,39819,40104,40116,40348,40401,40568,40583,41236,41253,41254,41350,41533,42009,43564,44143,44383,44478)
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 | 1551 | 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.69 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.28 ms |
System lock | 0.03 ms |
optimizing | 0.11 ms |
statistics | 2.27 ms |
preparing | 1.13 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.36 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.08 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 |