Tiempo de la consulta: 16.91 ms Después de la última consulta: 1.98 ms Consulta a la memoria: 1.072 MB memoria antes de la consulta: 4.397 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 05:36:01')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 05:36:01')
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,49,51,71,82,90,92,96,97,98,99,102,104,107,117,120,121,136,183,184,197,198,199,202,209,210,217,226,228,232,234,238,240,242,243,265,271,276,280,328,344,350,353,374,376,377,378,379,380,385,393,407,419,428,453,456,466,487,523,605,607,608,611,637,686,693,831,839,868,870,891,902,904,935,941,948,964,966,976,1031,1033,1043,1067,1123,1207,1209,1215,1223,1280,1287,1329,1339,1352,1354,1357,1455,1535,1601,1603,1634,1646,1698,1709,1713,1781,1785,1800,1802,1822,1825,1845,1900,1913,1957,2156,2210,2217,2305,2337,2378,2424,2598,2600,2601,2613,2632,2636,2643,2656,2668,2689,2714,2729,2742,2805,2822,2825,3020,3058,3067,3087,3091,3212,3215,3216,3217,3329,3337,3340,3373,3408,3412,3499,3522,3594,3718,3719,3725,3783,3816,3870,3871,3895,3899,3957,4033,4046,4087,4131,4166,4206,4215,4227,4319,4320,4378,4473,4493,4612,4613,4614,4615,4617,4638,4770,4784,4808,4832,4902,4910,4947,4957,4990,5086,5092,5104,5125,5150,5170,5173,5237,5268,5323,5345,5371,5559,5622,5647,5649,5685,5686,5726,5727,5730,5798,5814,5847,5943,6039,6192,6264,6268,6270,6292,6324,6333,6384,6386,6464,6518,6571,6586,6631,6687,6760,6788,6830,6839,6847,6881,6908,6910,6915,6917,6921,6940,6942,6957,6961,6977,6984,6985,6989,7017,7081,7154,7205,7303,7330,7358,7396,7416,7434,7450,7454,7482,7494,7522,7526,7556,7565,7624,7638,7659,7690,7713,7735,7745,7772,7774,7799,7813,7829,7847,7862,7866,7916,7923,7928,7958,7965,7967,7985,8026,8039,8056,8057,8062,8070,8108,8161,8267,8317,8320,8330,8354,8416,8436,8437,8438,8453,8462,8541,8694,8706,8844,8972,9003,9012,9018,9051,9057,9091,9142,9196,9197,9249,9300,9308,9318,9330,9370,9395,9429,9481,9529,9650,9723,9724,9725,9757,9861,9865,9869,9924,9966,9985,10011,10031,10039,10061,10075,10100,10186,10227,10259,10260,10265,10313,10323,10352,10357,10400,10422,10436,10458,10489,10510,10534,10536,10603,10604,10611,10634,10664,10764,10777,10811,10820,10821,10889,10895,10956,10971,11005,11069,11086,11098,11106,11107,11121,11163,11305,11321,11323,11333,11356,11362,11365,11476,11539,11627,11663,11703,11721,11722,11799,11803,11816,11820,11859,11864,11893,11911,11946,11950,11976,11994,12009,12095,12113,12144,12177,12178,12179,12216,12254,12327,12388,12412,12446,12488,12541,12592,12609,12650,12669,12670,12679,12685,12686,12708,12758,12838,12867,12887,12898,12913,12973,12985,13010,13036,13062,13079,13154,13188,13205,13229,13231,13268,13276,13285,13321,13328,13334,13349,13352,13398,13405,13471,13473,13474,13501,13535,13575,13576,13647,13681,13685,13693,13695,13727,13748,13750,13782,13783,13800,13846,13868,13901,13924,13941,13947,13969,14008,14029,14034,14052,14079,14098,14122,14152,14156,14169,14203,14205,14218,14224,14231,14248,14250,14263,14293,14327,14336,14352,14354,14356,14357,14396,14424,14426,14430,14524,14581,14596,14625,14629,14648,14663,14676,14679,14695,14713,14733,14749,14754,14789,14832,14843,14846,14856,14860,14862,14905,14906,14911,14973,14984,14987,14996,15018,15020,15021,15039,15044,15045,15046,15110,15151,15166,15179,15188,15198,15208,15209,15217,15234,15262,15286,15293,15298,15304,15310,15313,15315,15316,15347,15366,15418,15421,15444,15470,15473,15482,15495,15502,15511,15517,15520,15528,15539,15540,15550,15573,15594,15608,15616,15630,15667,15689,15705,15714,15723,15751,15753,15755,15759,15778,15784,15796,15805,15835,15851,15860,15862,15870,15897,15917,15937,15947,16049,16053,16057,16088,16120,16122,16132,16163,16165,16213,16263,16346,16352,16354,16362,16365,16381,16417,16422,16440,16455,16465,16474,16488,16523,16526,16532,16542,16562,16578,16623,16654,16657,16670,16675,16678,16720,16728,16737,16783,16802,16812,16826,16890,16894,16973,16982,16983,17014,17034,17045,17063,17110,17121,17133,17136,17142,17145,17154,17163,17167,17199,17223,17236,17256,17275,17304,17317,17334,17335,17344,17353,17365,17369,17385,17409,17412,17422,17453,17506,17520,17521,17542,17566,17573,17584,17590,17597,17603,17609,17611,17619,17625,17630,17631,17635,17660,17688,17700,17710,17712,17717,17820,17826,17844,17857,17862,17902,17910,17914,17927,17930,17933,17949,17956,17965,17967,17976,17977,18028,18029,18052,18067,18106,18118,18124,18133,18165,18170,18181,18213,18227,18274,18300,18334,18336,18362,18426,18429,18458,18465,18473,18509,18538,18559,18588,18590,18595,18597,18605,18658,18675,18707,18726,18739,18753,18782,18801,18811,18825,18830,18845,18846,18849,18852,18871,18906,18907,18926,18956,18958,18974,18999,19001,19024,19040,19055,19057,19098,19123,19127,19135,19145,19150,19153,19185,19204,19211,19232,19235,19245,19252,19254,19259,19263,19277,19299,19312,19325,19353,19358,19369,19402,19423,19426,19432,19454,19483,19484,19487,19527,19551,19574,19582,19648,19676,19679,19706,19722,19750,19772,19773,19791,19796,19816,19830,19837,19855,19858,19871,19875,19876,19877,19881,19901,19904,19916,19939,19943,19963,19965,19967,19972,19984,19988,19996,20004,20039,20066,20068,20092,20122,20180,20183,20216,20269,20296,20301,20309,20338,20343,20376,20386,20390,20396,20398,20405,20408,20433,20434,20437,20447,20469,20488,20492,20497,20521,20526,20528,20539,20545,20565,20573,20574,20588,20592,20617,20618,20642,20648,20670,20688,20690,20698,20708,20718,20750,20751,20772,20781,20792,20794,20804,20814,20881,20894,20907,20940,20944,20953,20960,20964,20979,20984,20990,21002,21053,21080,21087,21122,21170,21182,21198,21247,21259,21300,21325,21329,21332,21350,21370,21380,21398,21404,21405,21413,21448,21449,21454,21487,21520,21523,21524,21547,21551,21566,21591,21598,21602,21607,21612,21614,21631,21640,21679,21680,21719,21722,21726,21747,21767,21769,21773,21787,21811,21824,21867,21891,21895,21932,21958,21960,21990,22032,22039,22044,22067,22085,22096,22129,22132,22134,22137,22156,22162,22170,22172,22189,22215,22239,22253,22255,22262,22267,22276,22320,22339,22344,22349,22361,22363,22382,22409,22436,22453,22465,22466,22481,22484,22494,22499,22501,22544,22547,22564,22579,22581,22588,22611,22620,22659,22692,22693,22694,22695,22709,22726,22739,22751,22753,22814,22820,22851,22865,22866,22869,22871,22886,22914,22915,22925,22930,22958,22959,22964,22973,23003,23009,23010,23029,23036,23037,23072,23074,23083,23087,23096,23099,23103,23104,23112,23119,23123,23137,23146,23156,23184,23201,23203,23213,23218,23229,23230,23232,23235,23251,23252,23254,23264,23268,23270,23273,23279,23287,23292,23304,23308,23309,23328,23364,23365,23367,23368,23371,23381,23391,23398,23401,23444,23455,23460,23475,23483,23484,23523,23554,23555,23577,23585,23604,23619,23621,23623,23632,23642,23665,23682,23691,23693,23704,23709,23716,23719,23720,23768,23805,23813,23846,23849,23854,23885,23888,23891,23893,23897,23901,23902,23905,23907,23909,23920,23921,23944,23947,23949,23964,23986,24000,24007,24009,24015,24024,24029,24060,24067,24077,24092,24110,24115,24145,24159,24160,24163,24164,24196,24197,24209,24226,24238,24239,24270,24294,24296,24303,24306,24316,24335,24337,24339,24352,24361,24362,24376,24422,24429,24430,24453,24485,24496,24503,24506,24526,24556,24575,24585,24598,24615,24617,24635,24656,24663,24677,24678,24679,24707,24711,24724,24726,24741,24764,24766,24772,24781,24782,24785,24794,24816,24834,24861,24871,24918,24931,24934,24983,24984,24992,25005,25032,25036,25038,25043,25062,25068,25079,25089,25136,25151,25200,25201,25232,25244,25282,25287,25291,25303,25327,25332,25367,25368,25375,25377,25384,25386,25401,25408,25416,25432,25440,25450,25480,25484,25505,25507,25515,25518,25526,25548,25554,25555,25560,25589,25613,25621,25622,25637,25639,25640,25646,25648,25649,25671,25673,25687,25692,25697,25716,25717,25723,25727,25747,25757,25758,25765,25771,25806,25817,25818,25830,25836,25854,25863,25887,25889,25916,25918,25924,25927,25928,25941,25942,25949,25956,25959,25961,25990,25992,25994,25995,26000,26010,26013,26023,26025,26033,26035,26047,26055,26060,26066,26082,26087,26113,26118,26120,26131,26136,26146,26147,26153,26161,26184,26185,26187,26191,26194,26215,26221,26227,26234,26259,26263,26274,26283,26296,26335,26337,26340,26359,26372,26386,26388,26390,26413,26443,26565,26576,26595,26620,26625,26630,26639,26646,26673,26691,26699,26732,26780,26784,26820,26845,26853,26873,26879,26884,26900,26925,26927,26933,26935,26940,26968,26971,26978,26990,27001,27065,27109,27117,27118,27126,27143,27171,27211,27212,27216,27232,27240,27270,27323,27327,27347,27367,27374,27379,27405,27408,27423,27430,27487,27492,27526,27541,27550,27568,27570,27578,27583,27584,27592,27595,27601,27671,27688,27707,27717,27758,27786,27795,27922,27924,28019,28030,28031,28059,28066,28075,28094,28097,28114,28120,28121,28129,28162,28168,28192,28230,28243,28264,28329,28435,28511,28537,28623,28673,28718,28825,28846,28852,28931,28943,29011,29045,29063,29155,29266,29297,29325,29611,29616,29639,29724,29769,29866,29924,29926,29943,29962,30083,30111,30273,30274,30483,30484,30808,31136,31447,31608,31735,31798,31820,31837,31853,31890,32084,32107,32720,32767,32768,32820,32997,33874,33908,33925,33946,33957,34025,34275,34331,34616,34646,34693,34811,34815,35000,35220,35227,35238,35239,35289,35376,35397,35426,35444,35490,35554,35556,35585,35621,35688,35711,35728,35740,35744,35774,35805,35806,35808,35813,35814,35832,35835,35846,35858,35882,35921,35948,36000,36015,36141,36216,36220,36237,36368,36369,36373,36385,36420,36441,36492,36584,36857,36860,36930,36989,36998,37010,37136,37147,37283,37307,37308,37378,37431,37534,37544,37626,37644,37677,37902,38058,38092,38126,38133,38330,38433,38489,38546,38617,38723,38799,38821,38824,38829,38854,38877,38904,38912,38922,38949,38958,38965,38975,38990,39020,39064,39155,39159,39205,39290,39293,39296,39320,39366,39381,39442,39476,39497,39559,39587,39610,39686,39717,39724,39887,40086,40113,40184,40319,40334,40405,40451,40492,40509,40560,40578,40624,40647,41049,41062,41105,41171,41213,41289,41325,41332,41345,41415,41477,41504,41505,41506,41516,41781,41798,41969,42637,42987,43003,43012,43016,43109,43165,43237,43271,43405,43446,43461,43483,43712,44062,44366,44573,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 | 1720 | 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 | 1.13 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.36 ms |
System lock | 0.03 ms |
optimizing | 0.21 ms |
statistics | 4.62 ms |
preparing | 1.96 ms |
Sorting result | 0.06 ms |
executing | 0.02 ms |
Sending data | 7.43 ms |
end | 0.01 ms |
query end | 0.03 ms |
closing tables | 0.02 ms |
freeing items | 0.10 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 |