Tiempo de la consulta: 6.25 ms Después de la última consulta: 1.54 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.387 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-07 22:47:45')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 22:47:45')
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(4,11,21,49,58,98,154,176,178,179,197,247,260,263,282,287,321,323,324,331,332,333,334,394,430,432,446,458,465,478,495,510,521,523,558,563,593,618,669,671,695,701,723,729,757,770,805,808,816,845,868,879,892,897,911,915,955,986,1010,1027,1033,1057,1094,1123,1130,1158,1169,1175,1186,1207,1210,1214,1226,1234,1236,1240,1277,1296,1326,1330,1331,1335,1339,1348,1350,1486,1503,1538,1555,1589,1714,1718,1785,1804,1894,1910,1928,1948,2062,2090,2092,2094,2258,2265,2294,2305,2306,2394,2482,2592,2601,2610,2740,2859,2964,3005,3022,3070,3071,3085,3099,3295,3319,3346,3353,3425,3531,3546,3575,3663,3696,3706,3831,3864,3870,3939,3969,4093,4096,4100,4117,4131,4163,4202,4276,4281,4327,4339,4346,4378,4388,4473,4493,4511,4516,4541,4572,4583,4612,4613,4614,4615,4617,4641,4658,4668,4710,4765,4790,4982,4987,5001,5085,5109,5194,5199,5236,5279,5288,5300,5306,5362,5366,5457,5461,5504,5530,5559,5647,5648,5659,5792,5796,5810,5814,5820,5825,5855,5857,5894,5918,5973,5976,5996,6012,6039,6112,6150,6159,6199,6292,6307,6372,6406,6427,6429,6448,6465,6468,6470,6475,6492,6520,6538,6546,6558,6585,6616,6626,6646,6669,6695,6700,6703,6744,6776,6799,6817,6831,6902,6913,6994,7014,7032,7063,7105,7131,7215,7218,7227,7231,7232,7234,7243,7246,7249,7277,7285,7289,7292,7319,7325,7327,7328,7330,7333,7334,7338,7343,7344,7346,7361,7364,7367,7368,7370,7371,7374,7377,7379,7380,7381,7387,7396,7401,7404,7406,7407,7408,7410,7413,7414,7415,7416,7417,7422,7430,7431,7433,7435,7436,7447,7449,7450,7451,7453,7455,7456,7457,7458,7461,7463,7464,7465,7477,7486,7488,7489,7513,7538,7545,7546,7551,7552,7553,7555,7558,7565,7567,7570,7577,7583,7615,7625,7642,7659,7666,7678,7682,7683,7691,7715,7720,7724,7730,7732,7733,7735,7744,7746,7749,7757,7764,7768,7782,7799,7813,7829,7830,7833,7834,7835,7840,7847,7851,7863,7871,7874,7891,7894,7895,7900,7901,7919,7936,7955,7957,7961,7962,7965,7979,7981,7982,8020,8022,8023,8024,8027,8034,8049,8067,8072,8092,8137,8138,8146,8167,8177,8254,8258,8287,8309,8317,8351,8362,8366,8391,8395,8474,8509,8575,8585,8663,8681,8689,8692,8698,8705,8742,8772,8794,8806,8822,8855,8881,8899,8965,8967,8973,8975,9027,9046,9051,9055,9059,9085,9107,9130,9211,9218,9224,9233,9253,9254,9270,9303,9344,9385,9472,9500,9518,9524,9568,9595,9611,9658,9664,9668,9670,9732,9734,9775,9777,9801,9832,9851,9858,9886,9891,9892,9896,9907,9909,9952,9956,9965,9996,10025,10146,10149,10168,10186,10197,10199,10205,10207,10221,10243,10269,10271,10305,10349,10354,10387,10400,10401,10418,10420,10462,10464,10499,10522,10537,10585,10609,10620,10629,10663,10715,10745,10755,10786,10833,10847,10878,10906,10928,10932,10946,10986,11009,11027,11043,11062,11071,11114,11150,11168,11182,11238,11263,11351,11374,11377,11404,11417,11458,11473,11477,11486,11538,11597,11599,11612,11661,11666,11680,11713,11716,11720,11775,11864,11870,11879,11926,11928,11989,12003,12010,12011,12024,12036,12042,12053,12054,12069,12085,12131,12136,12152,12156,12162,12226,12297,12317,12318,12319,12362,12370,12415,12435,12443,12448,12477,12482,12488,12514,12519,12527,12532,12588,12592,12604,12609,12614,12617,12636,12649,12670,12676,12714,12738,12758,12764,12783,12786,12849,12851,12895,12902,12910,12939,12942,12944,12956,12960,12963,12978,12997,13000,13039,13107,13132,13135,13141,13152,13154,13222,13250,13269,13273,13279,13290,13309,13325,13327,13345,13359,13373,13375,13379,13396,13402,13420,13423,13440,13446,13481,13553,13580,13594,13664,13667,13672,13685,13697,13708,13753,13768,13770,13819,13834,13891,13892,13902,13929,13933,13935,14030,14040,14052,14061,14078,14084,14092,14103,14105,14133,14172,14175,14186,14197,14198,14199,14232,14234,14250,14268,14305,14334,14336,14354,14355,14363,14366,14378,14417,14421,14426,14431,14435,14437,14451,14478,14480,14493,14502,14505,14516,14531,14581,14586,14596,14598,14637,14654,14680,14691,14692,14694,14699,14713,14742,14743,14749,14758,14770,14788,14798,14846,14849,14865,14929,14946,14953,14955,14973,14974,14982,14990,15001,15002,15005,15015,15038,15039,15046,15060,15065,15092,15105,15107,15114,15115,15123,15148,15180,15206,15213,15215,15217,15226,15227,15245,15257,15284,15293,15299,15311,15318,15325,15329,15340,15344,15358,15371,15392,15403,15410,15417,15443,15452,15483,15489,15492,15500,15533,15561,15577,15580,15594,15605,15609,15615,15632,15637,15639,15642,15656,15673,15689,15705,15728,15733,15741,15745,15762,15781,15788,15797,15808,15811,15832,15835,15840,15870,15874,15878,15879,15884,15899,15902,15910,15916,15954,15965,15985,16014,16024,16052,16055,16087,16089,16103,16106,16112,16142,16156,16167,16172,16192,16208,16217,16237,16240,16246,16248,16261,16279,16291,16295,16306,16321,16328,16335,16336,16353,16359,16368,16376,16377,16389,16404,16410,16436,16440,16444,16447,16458,16474,16483,16518,16520,16526,16579,16584,16613,16627,16635,16642,16645,16656,16659,16662,16667,16682,16715,16717,16726,16739,16748,16751,16777,16778,16792,16794,16820,16861,16866,16893,16907,16909,16919,16921,16926,16928,16944,16950,16964,16976,17043,17050,17059,17065,17071,17072,17080,17127,17149,17156,17158,17185,17205,17212,17214,17247,17263,17269,17272,17291,17299,17300,17335,17343,17344,17346,17375,17390,17419,17423,17424,17441,17442,17452,17455,17460,17463,17476,17485,17498,17512,17536,17541,17561,17566,17574,17590,17596,17598,17607,17620,17633,17650,17654,17661,17668,17670,17698,17701,17705,17719,17733,17748,17753,17759,17761,17772,17774,17783,17786,17808,17810,17812,17816,17844,17866,17879,17883,17885,17900,17918,17926,17941,17948,17951,17954,17973,17999,18003,18055,18072,18074,18098,18100,18102,18135,18150,18157,18160,18172,18179,18220,18221,18226,18227,18231,18238,18271,18276,18277,18292,18300,18304,18311,18315,18326,18333,18345,18352,18353,18366,18401,18410,18419,18434,18435,18442,18455,18467,18482,18498,18509,18520,18522,18530,18537,18553,18558,18576,18578,18579,18603,18619,18622,18624,18643,18653,18668,18670,18712,18719,18720,18730,18731,18732,18734,18735,18744,18749,18750,18778,18792,18795,18797,18821,18846,18876,18877,18900,18905,18909,18920,18936,18951,18960,18972,18973,18974,18975,18993,18997,19027,19029,19037,19044,19048,19049,19063,19076,19077,19101,19106,19118,19128,19136,19151,19172,19179,19180,19191,19205,19220,19224,19242,19243,19247,19276,19285,19288,19303,19309,19313,19352,19364,19405,19422,19426,19428,19430,19437,19457,19472,19484,19492,19512,19518,19542,19556,19562,19575,19604,19608,19619,19626,19645,19646,19651,19655,19666,19697,19702,19715,19720,19733,19743,19748,19752,19772,19777,19778,19790,19794,19806,19811,19872,19874,19920,19925,19944,19957,19967,19983,20008,20014,20035,20048,20066,20074,20076,20090,20098,20104,20117,20158,20166,20191,20204,20205,20218,20233,20282,20289,20291,20295,20299,20305,20315,20325,20328,20329,20332,20333,20344,20352,20359,20385,20399,20416,20419,20420,20450,20457,20465,20468,20476,20487,20489,20519,20537,20554,20559,20592,20598,20608,20612,20630,20641,20656,20660,20712,20715,20734,20761,20780,20782,20783,20807,20820,20834,20841,20849,20877,20885,20886,20887,20890,20897,20912,20956,20974,21013,21017,21028,21055,21065,21066,21067,21085,21086,21089,21108,21121,21128,21129,21131,21133,21136,21149,21163,21173,21181,21191,21231,21258,21259,21271,21289,21300,21310,21324,21356,21359,21385,21387,21396,21398,21421,21429,21456,21482,21502,21530,21542,21547,21560,21566,21569,21602,21608,21624,21628,21657,21665,21683,21689,21698,21702,21711,21713,21716,21742,21750,21759,21783,21792,21818,21842,21843,21859,21863,21878,21952,21967,21994,22023,22031,22037,22053,22088,22116,22122,22133,22135,22137,22156,22179,22191,22219,22262,22266,22287,22289,22290,22292,22316,22342,22374,22380,22381,22485,22490,22493,22498,22502,22546,22553,22602,22606,22609,22634,22668,22671,22681,22691,22693,22735,22741,22744,22746,22779,22786,22804,22822,22834,22857,22873,22886,22898,22914,22918,22934,22936,22959,22985,22998,23013,23015,23026,23047,23092,23100,23107,23123,23181,23202,23214,23224,23229,23251,23257,23260,23277,23278,23279,23288,23295,23310,23319,23338,23364,23400,23404,23423,23468,23505,23516,23543,23557,23576,23578,23584,23624,23666,23667,23686,23695,23705,23714,23725,23726,23729,23731,23756,23780,23786,23815,23849,23855,23866,23869,23873,23876,23885,23906,23911,23949,23989,23995,24002,24028,24062,24068,24082,24114,24189,24190,24201,24210,24211,24223,24279,24315,24340,24350,24365,24432,24438,24443,24474,24485,24511,24526,24567,24586,24592,24595,24617,24619,24630,24657,24671,24672,24673,24675,24681,24700,24704,24721,24734,24736,24738,24752,24780,24784,24785,24790,24806,24807,24834,24836,24845,24887,24915,24922,24945,24947,24967,24998,25016,25038,25041,25064,25087,25103,25117,25134,25137,25146,25155,25163,25178,25200,25218,25258,25260,25294,25314,25315,25316,25353,25373,25380,25461,25469,25471,25474,25483,25513,25538,25540,25554,25555,25583,25595,25600,25611,25648,25663,25734,25746,25753,25790,25813,25822,25871,25888,25911,25929,25941,25952,25964,25979,25989,26000,26001,26002,26038,26040,26073,26093,26101,26116,26128,26157,26165,26174,26191,26207,26209,26225,26236,26246,26247,26271,26322,26344,26355,26359,26386,26387,26392,26393,26409,26412,26420,26432,26434,26448,26452,26481,26482,26522,26530,26541,26560,26562,26579,26586,26594,26598,26609,26646,26672,26701,26780,26820,26841,26845,26897,26924,26934,26936,26968,26990,27024,27028,27040,27075,27083,27085,27096,27126,27127,27279,27347,27355,27368,27390,27399,27403,27420,27442,27447,27492,27512,27532,27563,27604,27605,27646,27724,27737,27739,27749,27757,27789,27893,27898,27944,27971,28116,28135,28139,28185,28242,28294,28441,28468,28539,28609,28617,28651,28712,28714,28715,28846,29034,29089,29348,29381,29413,29419,29445,29467,29499,29550,29551,29584,29658,29683,29788,29801,29837,29839,29872,29896,29897,29915,29918,30194,30222,30414,30941,30988,31090,31510,31798,31837,31853,31975,33385,33416,34150,35638,35639,35640,35643,35744,35752,35812,35831,36075,36141,36147,36208,36223,36310,36581,36584,37497,37759,38362,38593,38887,38912,38932,39224,39240,39254,39342,39527,39570,39588,39600,39642,39713,39846,39877,39956,39970,40048,40064,40343,40356,40367,40521,40672,40861,40877,40909,40935,41104,41148,41163,41171)
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 | 1765 | 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.83 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.31 ms |
System lock | 0.02 ms |
optimizing | 0.11 ms |
statistics | 2.55 ms |
preparing | 1.30 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.33 ms |
end | 0.01 ms |
query end | 0.03 ms |
closing tables | 0.02 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 |