Tiempo de la consulta: 10.87 ms Después de la última consulta: 1.03 ms Consulta a la memoria: 1.072 MB memoria antes de la consulta: 4.503 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 01:39:18')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 01:39:18')
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(13,21,30,51,82,93,167,183,184,197,230,328,337,350,351,393,407,487,693,840,902,935,1097,1280,1352,1354,1357,1397,1433,1455,1464,1535,1603,1634,1646,1734,1781,1785,1800,1802,1803,1822,1900,1913,2014,2048,2150,2209,2210,2217,2235,2258,2305,2337,2349,2378,2396,2424,2427,2547,2598,2600,2601,2632,2636,2668,2689,2719,2735,2825,3067,3087,3166,3212,3337,3373,3408,3594,3606,3718,3719,3725,3871,4131,4166,4215,4227,4320,4473,4493,4612,4613,4614,4615,4617,4631,4832,4905,4910,4947,4957,4990,5012,5092,5104,5150,5170,5173,5268,5544,5559,5569,5686,5769,5934,5943,5944,6039,6101,6136,6166,6192,6264,6268,6270,6324,6347,6466,6571,6586,6665,6699,6787,6788,6830,6910,6917,6975,6977,6985,7081,7201,7263,7290,7330,7337,7416,7458,7462,7482,7513,7526,7565,7624,7659,7690,7716,7719,7735,7745,7758,7799,7866,8026,8039,8057,8059,8135,8201,8255,8330,8353,8354,8372,8416,8436,8437,8444,8462,8556,8681,8706,9012,9018,9051,9091,9142,9196,9197,9300,9308,9370,9481,9629,9757,9865,9869,9875,9920,9947,10038,10039,10186,10260,10352,10400,10422,10434,10436,10440,10458,10483,10504,10510,10603,10604,10634,10764,10811,10832,11098,11107,11121,11161,11305,11323,11356,11365,11457,11476,11525,11553,11702,11703,11721,11722,11765,11803,11820,11859,11864,11946,11994,12113,12130,12144,12172,12175,12216,12236,12254,12256,12364,12488,12489,12510,12520,12541,12592,12609,12650,12664,12669,12686,12715,12718,12753,12790,12806,12933,13154,13187,13188,13268,13276,13321,13325,13349,13352,13474,13535,13575,13576,13644,13693,13727,13782,13783,13846,13873,13886,13924,13941,13947,13975,14008,14052,14060,14079,14094,14122,14169,14263,14293,14327,14352,14356,14357,14373,14375,14384,14430,14482,14524,14648,14653,14663,14669,14679,14713,14725,14733,14749,14754,14832,14860,14869,14905,14906,14911,14943,14973,14993,14996,15020,15040,15046,15113,15128,15166,15179,15180,15204,15208,15209,15217,15234,15298,15304,15324,15335,15360,15366,15418,15473,15517,15522,15528,15539,15540,15550,15594,15689,15714,15751,15753,15759,15762,15785,15796,15813,15820,15844,15851,15862,15870,15917,15937,15945,15947,16057,16120,16151,16155,16186,16200,16206,16213,16342,16346,16354,16411,16422,16434,16440,16455,16465,16537,16562,16566,16578,16612,16654,16661,16678,16737,16771,16802,16820,16876,16894,16908,17014,17034,17052,17080,17091,17109,17121,17160,17166,17167,17168,17178,17198,17199,17221,17236,17269,17299,17304,17317,17334,17335,17344,17351,17353,17357,17369,17385,17409,17412,17422,17439,17531,17566,17574,17590,17603,17609,17630,17635,17652,17700,17826,17857,17902,17906,17927,17949,17956,18012,18028,18029,18030,18045,18067,18106,18124,18165,18170,18179,18217,18318,18334,18362,18458,18473,18496,18519,18537,18590,18595,18605,18658,18707,18739,18782,18825,18906,18907,18926,18949,18952,18958,18989,19013,19024,19123,19127,19148,19153,19160,19190,19204,19211,19232,19234,19235,19245,19259,19263,19299,19353,19358,19423,19432,19472,19484,19516,19593,19627,19706,19747,19750,19858,19875,19876,19877,19888,19891,19904,19916,19957,19962,19967,19980,19988,19989,20008,20068,20097,20120,20130,20147,20169,20180,20191,20220,20309,20343,20376,20398,20437,20469,20565,20567,20574,20592,20618,20642,20648,20658,20690,20748,20750,20792,20894,21053,21080,21103,21106,21122,21134,21147,21198,21259,21329,21405,21413,21425,21487,21520,21523,21524,21547,21566,21598,21602,21612,21614,21665,21670,21683,21718,21719,21722,21726,21747,21769,21773,21787,21811,21824,21891,21932,21966,21967,22061,22067,22082,22129,22134,22149,22167,22191,22208,22218,22221,22232,22253,22262,22267,22287,22290,22346,22394,22423,22424,22445,22453,22466,22481,22484,22494,22514,22581,22620,22654,22659,22689,22690,22739,22761,22768,22781,22795,22814,22869,22886,22889,22909,22919,22958,22964,22980,23001,23035,23036,23037,23053,23072,23099,23104,23119,23123,23184,23201,23213,23229,23230,23261,23271,23273,23281,23287,23309,23328,23359,23364,23365,23381,23479,23486,23523,23532,23542,23555,23600,23625,23627,23659,23688,23720,23790,23819,23877,23885,23888,23891,23897,23905,23921,23964,23971,24018,24027,24077,24145,24163,24281,24316,24337,24390,24481,24617,24679,24766,24781,24785,24847,24871,24896,24911,24983,25032,25062,25068,25176,25184,25201,25267,25377,25450,25505,25518,25539,25548,25554,25589,25600,25621,25622,25639,25646,25648,25671,25723,25727,25747,25757,25758,25771,25781,25817,25818,25830,25836,25916,25924,25927,25928,25941,25942,25949,25950,25956,25961,25990,25992,25994,25995,26000,26010,26013,26025,26033,26035,26060,26066,26073,26074,26082,26087,26113,26120,26136,26146,26147,26153,26161,26185,26187,26191,26194,26215,26221,26227,26234,26245,26259,26260,26295,26296,26337,26359,26372,26386,26391,26395,26432,26455,26525,26565,26576,26586,26620,26639,26646,26691,26710,26780,26820,26845,26873,26927,26933,26963,26968,26990,27005,27041,27042,27065,27109,27115,27187,27211,27212,27216,27240,27270,27273,27323,27327,27343,27347,27367,27405,27408,27423,27487,27496,27526,27541,27551,27578,27583,27592,27595,27601,27622,27655,27656,27671,27688,27695,27707,27717,27758,27786,27799,27922,27924,27956,27992,28019,28031,28059,28066,28075,28091,28094,28097,28114,28120,28129,28153,28162,28163,28168,28192,28193,28230,28237,28240,28241,28243,28264,28290,28294,28295,28354,28355,28435,28623,28673,28778,28846,28931,28943,28956,29011,29045,29063,29266,29426,29537,29572,29611,29616,29639,29714,29720,29724,29746,29757,29758,29769,29805,29857,29866,29920,29928,30111,30560,30654,30803,31608,31735,31820,31837,31853,32084,32187,32642,32643,32720,32767,32768,33874,33908,33925,33946,33957,34025,34275,34331,34612,34616,34646,34693,34811,34815,34888,35145,35220,35227,35230,35238,35239,35289,35376,35397,35426,35444,35490,35554,35556,35621,35688,35728,35805,35814,35835,35846,35882,35948,36000,36015,36141,36220,36237,36300,36368,36369,36373,36385,36420,36441,36492,36584,36930,36931,36989,36998,37010,37136,37147,37283,37288,37294,37298,37307,37308,37378,37534,37544,37626,37644,37677,37902,38058,38092,38126,38133,38330,38362,38433,38489,38546,38617,38723,38799,38810,38821,38824,38829,38877,38904,38912,38922,38949,38965,38990,39155,39205,39290,39293,39296,39366,39442,39476,39497,39508,39517,39559,39587,39610,39686,39717,39724,40102,40319,40509,40560,40624,40647,41062,41171,41289,41315,41332,41345,41516,41781,41969,42035,42637,42641,42803,42987,43003,43016,43109,43119,43155,43165,43237,43271,43276,43405,43446,43461,43472,43483,43712,43719,44062,44366,44369,44370,44509,44573,44656,44718,44788,44807,44829,44873,44912,44935,44936,44988,45101,45138,45235,45263,45264,45316)
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 | 1120 | 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.65 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.29 ms |
System lock | 0.04 ms |
optimizing | 0.09 ms |
statistics | 2.03 ms |
preparing | 0.87 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 6.00 ms |
end | 0.02 ms |
query end | 0.05 ms |
closing tables | 0.02 ms |
freeing items | 0.07 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 |