Tiempo de la consulta: 22.08 ms Después de la última consulta: 1.10 ms Consulta a la memoria: 2.322 MB memoria antes de la consulta: 4.357 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 18:58:48')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-03 18:58:48')
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(21,33,34,35,39,40,41,42,43,70,71,72,73,75,126,127,128,197,255,263,275,277,307,353,389,458,491,583,607,705,735,801,816,868,895,903,917,970,988,1064,1080,1201,1207,1277,1284,1329,1337,1340,1352,1357,1368,1384,1477,1519,1697,1773,1781,1785,1823,1897,1913,1976,2152,2210,2290,2293,2305,2365,2424,2489,2609,2689,2732,2750,2825,2827,2857,2886,2887,3080,3208,3212,3255,3302,3329,3364,3393,3442,3452,3591,3594,3603,3604,3620,3700,3732,3782,3880,3980,3986,4114,4131,4166,4209,4215,4227,4459,4493,4612,4613,4614,4615,4617,4739,4765,4767,4872,5085,5092,5207,5208,5268,5351,5451,5472,5491,5647,5658,5698,5827,5833,5877,5894,5896,5924,5943,6050,6141,6192,6268,6278,6279,6319,6324,6419,6515,6517,6542,6543,6545,6571,6583,6586,6594,6616,6628,6632,6658,6666,6751,6762,6788,6791,6935,6969,6977,7005,7045,7077,7081,7105,7136,7150,7193,7201,7270,7374,7379,7417,7429,7447,7482,7484,7489,7516,7545,7565,7624,7675,7690,7691,7718,7735,7741,7743,7745,7777,7799,7829,7835,7895,7934,7949,7950,7954,7960,7965,8015,8026,8027,8052,8074,8223,8381,8436,8437,8663,8689,8706,8759,8860,8909,9051,9077,9091,9142,9181,9308,9351,9398,9481,9704,9735,9757,9853,10039,10120,10180,10192,10195,10222,10247,10260,10268,10274,10289,10351,10369,10384,10400,10422,10439,10452,10458,10479,10485,10510,10604,10628,10634,10654,10696,10810,10811,10827,10926,10970,10971,10982,10987,11032,11038,11045,11065,11098,11101,11108,11150,11171,11189,11224,11230,11293,11323,11328,11370,11383,11399,11476,11534,11611,11675,11703,11719,11721,11722,11764,11803,11826,11836,11859,11912,11944,11945,11951,11960,11992,12076,12092,12101,12115,12176,12248,12307,12321,12340,12488,12516,12541,12554,12592,12650,12657,12665,12686,12697,12750,12758,12794,12804,12834,12912,13043,13055,13081,13082,13154,13162,13172,13188,13190,13218,13231,13242,13243,13276,13306,13329,13349,13352,13371,13410,13421,13425,13456,13460,13474,13495,13511,13529,13575,13603,13613,13675,13703,13705,13706,13709,13733,13741,13742,13758,13772,13782,13783,13808,13826,13883,13911,13926,13947,13972,14008,14053,14054,14057,14076,14079,14096,14115,14141,14147,14148,14169,14200,14202,14249,14263,14270,14281,14291,14357,14385,14470,14489,14521,14523,14555,14556,14572,14639,14679,14713,14732,14749,14754,14820,14832,14841,14851,14906,14911,14949,14959,14981,14996,15045,15046,15051,15069,15122,15154,15213,15217,15234,15249,15269,15277,15301,15304,15326,15349,15354,15356,15366,15373,15411,15418,15470,15475,15498,15499,15524,15539,15632,15643,15689,15750,15787,15796,15842,15851,15862,15864,15893,15900,15913,15917,15926,15979,16023,16057,16060,16086,16120,16128,16145,16164,16168,16194,16199,16208,16235,16264,16280,16283,16308,16327,16341,16346,16354,16356,16366,16373,16405,16422,16455,16460,16468,16515,16560,16562,16578,16659,16664,16678,16686,16844,16922,16965,16996,17004,17014,17034,17042,17090,17115,17121,17125,17132,17167,17183,17205,17229,17234,17276,17304,17318,17335,17353,17385,17407,17411,17434,17457,17459,17470,17494,17500,17512,17519,17541,17554,17568,17596,17601,17630,17633,17681,17707,17715,17723,17753,17776,17813,17815,17822,17846,17852,17923,17925,17935,17953,17956,17972,17993,17998,18018,18032,18046,18047,18048,18056,18069,18200,18244,18260,18281,18282,18296,18311,18334,18352,18395,18408,18434,18449,18518,18539,18562,18563,18590,18592,18593,18617,18627,18640,18648,18658,18674,18680,18697,18722,18733,18739,18746,18773,18782,18790,18793,18812,18823,18825,18886,18889,18896,18906,18907,18926,18938,18949,18960,19006,19011,19018,19026,19029,19073,19109,19117,19134,19139,19153,19195,19201,19204,19216,19266,19293,19306,19313,19346,19370,19381,19408,19409,19428,19429,19469,19490,19508,19510,19537,19542,19545,19576,19585,19589,19590,19596,19604,19606,19621,19645,19646,19662,19667,19713,19744,19764,19775,19809,19810,19825,19853,19875,19882,19883,19904,19916,19930,19951,19967,19971,19995,20029,20070,20075,20109,20164,20172,20180,20195,20247,20273,20291,20313,20347,20365,20376,20378,20407,20455,20462,20496,20512,20542,20642,20651,20662,20685,20690,20701,20707,20714,20747,20764,20783,20795,20820,20840,20870,20888,20914,20939,20945,20958,20977,21054,21063,21101,21106,21120,21141,21164,21179,21219,21238,21274,21286,21292,21307,21322,21329,21348,21372,21373,21407,21413,21446,21450,21487,21499,21504,21520,21523,21524,21548,21552,21554,21563,21566,21568,21584,21586,21612,21635,21638,21675,21719,21726,21737,21739,21774,21787,21851,21886,21890,21891,21921,21923,21931,21932,21948,22001,22010,22025,22043,22067,22073,22128,22129,22211,22250,22253,22286,22294,22306,22307,22318,22319,22325,22338,22352,22360,22379,22387,22453,22455,22487,22494,22504,22533,22558,22563,22594,22607,22620,22648,22659,22675,22686,22688,22700,22739,22741,22770,22778,22781,22803,22820,22831,22849,22852,22853,22861,22901,22935,22956,22964,22996,23019,23030,23041,23045,23067,23070,23079,23090,23097,23104,23123,23128,23163,23165,23184,23201,23220,23243,23244,23255,23273,23284,23303,23313,23323,23328,23330,23341,23365,23366,23375,23386,23415,23418,23433,23436,23443,23449,23484,23485,23487,23523,23534,23545,23617,23635,23660,23673,23680,23706,23720,23735,23737,23764,23819,23822,23856,23913,23926,23950,23960,23992,23994,24006,24063,24084,24121,24142,24145,24184,24276,24293,24325,24347,24419,24433,24475,24495,24513,24550,24614,24638,24646,24675,24682,24698,24702,24717,24733,24766,24767,24769,24770,24783,24812,24828,24831,24839,24858,24863,24877,24902,24947,24987,25011,25012,25032,25041,25048,25056,25062,25125,25135,25158,25162,25174,25208,25248,25250,25263,25277,25279,25280,25301,25313,25361,25442,25505,25518,25554,25589,25639,25646,25648,25657,25671,25696,25723,25727,25747,25757,25758,25763,25771,25799,25817,25830,25836,25882,25916,25923,25924,25927,25932,25941,25942,25946,25949,25961,25990,25992,25994,25995,26000,26010,26013,26025,26033,26035,26060,26082,26087,26113,26120,26136,26146,26147,26153,26161,26185,26187,26191,26194,26215,26221,26227,26228,26234,26250,26259,26295,26296,26317,26337,26359,26423,26543,26687,26765,26780,26806,26826,26861,26873,26899,26927,26928,26933,26934,26938,26968,27014,27024,27056,27125,27152,27211,27240,27270,27283,27319,27323,27327,27362,27365,27394,27405,27427,27441,27487,27517,27526,27575,27578,27583,27678,27688,27707,27717,27786,27809,27922,27924,28019,28020,28075,28097,28114,28192,28250,28264,28327,28534,28561,28607,28630,28640,28646,28677,28692,28765,28803,28837,28846,28870,28931,28943,28961,29022,29032,29066,29180,29329,29443,29537,29611,29616,29623,29724,30111,30285,30326,30481,31735,31820,31837,31853,32720,32767,32768,33874,33877,33908,34998,35017,35726,35728,35814,35835,35846,35884,36141,36540,36602,36834,37544,37677,37902,37915,38092,38330,38542,38617,38669,38723,38799,38821,38824,38829,38877,38896,38897,38912,38965,38990,39073,39155,39205,39290,39293,39366,39384,39442,39542,39559,39611,39646,39650,39666,39686,39724,39819,39998,40031,40147,40278,40455,40545,40624,41035,41082,41171,41184,41206,41289,41305,41350,41397,41634,41700,41716,43003,43483,43672,43924,44287,45225)
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 | 1208 | 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.57 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.22 ms |
System lock | 0.02 ms |
optimizing | 0.08 ms |
statistics | 1.80 ms |
preparing | 0.92 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 17.85 ms |
end | 0.02 ms |
query end | 0.06 ms |
closing tables | 0.02 ms |
freeing items | 0.09 ms |
cleaning up | 0.04 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 |