Tiempo de la consulta: 13.00 ms Después de la última consulta: 1.23 ms Consulta a la memoria: 1.276 MB memoria antes de la consulta: 4.225 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 04:25:20')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 04:25:20')
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(84,98,107,119,122,176,178,179,193,218,257,266,275,311,432,466,471,610,660,921,991,1014,1104,1164,1180,1211,1279,1280,1295,1322,1331,1349,1357,1375,1386,1397,1420,1421,1425,1433,1435,1441,1444,1445,1447,1454,1458,1460,1476,1481,1484,1534,1553,1555,1586,1595,1624,1626,1644,1664,1666,1730,1731,1732,1785,1811,1812,1815,1841,1852,1855,1903,1906,1909,1910,1914,1917,1928,1984,2001,2090,2092,2148,2193,2199,2209,2301,2345,2351,2359,2424,2430,2432,2469,2480,2556,2592,2610,2629,2640,2662,2691,2694,2704,2724,2740,2773,2795,2804,2809,3056,3085,3090,3202,3205,3219,3278,3343,3346,3355,3513,3526,3570,3590,3594,3663,3819,3838,3870,3872,3910,3938,3960,3969,3992,4051,4075,4132,4163,4168,4197,4252,4337,4378,4388,4477,4511,4523,4524,4525,4539,4558,4572,4580,4585,4586,4592,4605,4658,4665,4668,4758,4761,4795,4810,4822,4874,4892,4919,4960,5005,5008,5014,5035,5076,5079,5143,5157,5166,5218,5226,5250,5288,5315,5435,5496,5534,5580,5627,5642,5659,5693,5694,5697,5700,5806,5810,5820,5876,5936,5976,5985,5990,6007,6012,6064,6068,6097,6112,6133,6199,6200,6202,6217,6288,6307,6308,6323,6328,6347,6396,6421,6429,6431,6461,6502,6511,6512,6520,6533,6553,6571,6596,6626,6648,6663,6667,6714,6778,6826,6842,6925,6932,6982,7165,7166,7181,7182,7200,7227,7237,7277,7314,7320,7349,7358,7421,7433,7435,7449,7477,7523,7548,7611,7618,7626,7650,7664,7688,7689,7709,7711,7713,7731,7746,7748,7765,7769,7782,7797,7802,7808,7822,7824,7829,7834,7839,7845,7868,7878,7931,7936,7946,8016,8034,8047,8069,8091,8099,8108,8113,8146,8167,8206,8230,8270,8272,8283,8341,8361,8362,8366,8388,8400,8466,8496,8517,8577,8599,8607,8627,8664,8681,8689,8695,8741,8742,8778,8802,8842,8899,8907,8929,8938,8967,9046,9051,9067,9069,9085,9107,9108,9122,9127,9132,9171,9177,9211,9224,9270,9295,9357,9363,9382,9424,9449,9462,9471,9500,9518,9524,9548,9562,9582,9584,9595,9621,9670,9675,9690,9710,9717,9730,9734,9775,9827,9851,9858,9879,9892,9896,9963,9965,9980,10122,10183,10199,10241,10332,10371,10398,10420,10451,10511,10525,10580,10616,10650,10656,10669,10688,10697,10715,10716,10725,10736,10745,10763,10775,10834,10838,10878,10923,10992,11104,11164,11182,11195,11208,11214,11275,11314,11318,11353,11374,11379,11390,11428,11442,11474,11530,11548,11648,11705,11795,11823,11842,11885,11911,11933,12032,12051,12053,12054,12170,12238,12318,12334,12418,12439,12440,12482,12552,12565,12708,12714,12785,12816,12822,12856,12859,12895,12946,12969,12973,12994,12997,13008,13039,13063,13078,13110,13148,13160,13199,13240,13258,13266,13272,13290,13297,13300,13316,13344,13402,13428,13436,13437,13438,13458,13467,13478,13479,13480,13481,13482,13502,13503,13525,13546,13557,13562,13589,13597,13644,13660,13698,13719,13761,13784,13794,13797,13898,13968,13998,14106,14140,14177,14199,14205,14242,14270,14309,14313,14332,14348,14366,14373,14376,14378,14429,14432,14435,14469,14476,14480,14482,14502,14508,14532,14546,14581,14586,14598,14608,14610,14637,14641,14646,14654,14686,14699,14710,14747,14748,14761,14772,14814,14815,14853,14864,14870,14874,14896,14897,14930,14932,14933,14953,14958,14964,15001,15028,15041,15063,15107,15124,15138,15147,15154,15160,15174,15181,15211,15216,15222,15224,15229,15230,15274,15283,15311,15318,15325,15358,15367,15369,15375,15410,15417,15420,15509,15543,15561,15580,15598,15615,15632,15645,15666,15672,15681,15705,15722,15738,15741,15743,15759,15762,15781,15794,15840,15870,15879,15882,15897,15901,15909,15935,15954,15955,15965,15977,15981,15982,15985,16002,16015,16040,16056,16084,16090,16099,16106,16126,16132,16142,16193,16215,16237,16246,16258,16279,16337,16338,16348,16370,16380,16386,16466,16518,16526,16529,16556,16569,16586,16607,16611,16618,16627,16629,16634,16658,16660,16667,16774,16780,16791,16795,16822,16927,16944,16950,16987,17010,17033,17036,17053,17065,17121,17126,17127,17131,17162,17177,17217,17224,17260,17269,17282,17334,17346,17355,17369,17383,17384,17394,17408,17419,17433,17437,17439,17442,17447,17451,17463,17478,17511,17517,17555,17570,17610,17645,17651,17654,17667,17698,17699,17719,17773,17778,17780,17809,17824,17831,17873,17892,17900,17918,17927,17939,17948,18006,18031,18037,18053,18057,18135,18160,18174,18183,18202,18215,18242,18248,18262,18263,18271,18277,18290,18292,18315,18328,18376,18382,18406,18410,18435,18466,18509,18519,18540,18589,18624,18670,18695,18703,18717,18719,18732,18739,18778,18804,18813,18821,18852,18884,18933,18940,18948,18952,18966,18974,19029,19043,19053,19061,19062,19076,19104,19106,19121,19135,19196,19217,19242,19250,19254,19267,19288,19298,19307,19335,19343,19350,19383,19405,19407,19412,19430,19434,19440,19448,19462,19502,19505,19508,19509,19523,19592,19640,19653,19654,19658,19668,19715,19761,19762,19773,19774,19777,19797,19816,19832,19853,19856,19865,19867,19885,19920,19933,19953,19957,19958,19979,20004,20035,20051,20053,20056,20064,20117,20144,20181,20202,20208,20213,20214,20242,20263,20265,20295,20325,20334,20343,20360,20404,20452,20459,20521,20525,20543,20553,20568,20569,20598,20641,20658,20691,20715,20716,20726,20738,20773,20782,20785,20803,20807,20810,20837,20841,20862,20875,20876,20877,20887,20897,20933,20956,20958,20986,21002,21010,21051,21052,21066,21114,21130,21131,21135,21142,21167,21172,21173,21186,21189,21191,21197,21205,21222,21254,21262,21269,21280,21284,21310,21312,21324,21346,21356,21366,21408,21411,21436,21437,21438,21466,21491,21501,21502,21516,21527,21530,21555,21559,21560,21585,21588,21596,21599,21601,21611,21620,21647,21664,21691,21719,21727,21759,21779,21818,21842,21860,21908,21957,21969,22002,22011,22013,22037,22052,22081,22087,22115,22153,22156,22162,22170,22210,22239,22378,22385,22400,22411,22415,22416,22464,22488,22511,22513,22523,22534,22539,22591,22600,22606,22609,22611,22634,22666,22671,22680,22710,22722,22741,22743,22746,22771,22779,22784,22864,22872,22923,22949,22987,23013,23031,23032,23036,23039,23040,23064,23093,23096,23101,23105,23114,23117,23157,23202,23203,23221,23257,23264,23284,23296,23305,23313,23315,23358,23394,23404,23406,23440,23453,23465,23480,23524,23544,23547,23576,23592,23593,23602,23634,23638,23684,23691,23695,23701,23715,23731,23743,23747,23817,23823,23866,23868,23876,23893,23902,23906,23954,24016,24017,24088,24110,24124,24197,24198,24210,24213,24270,24369,24390,24395,24412,24414,24422,24425,24441,24447,24455,24456,24474,24486,24496,24503,24563,24592,24598,24599,24618,24663,24679,24701,24721,24726,24738,24764,24769,24770,24773,24784,24819,24852,24875,24884,24888,24910,24947,24966,24977,24984,24992,25010,25039,25046,25092,25096,25141,25142,25157,25172,25197,25205,25233,25244,25260,25278,25283,25284,25292,25320,25357,25376,25405,25406,25416,25418,25537,25542,25548,25563,25609,25611,25621,25639,25655,25693,25748,25780,25785,25792,25881,25904,25929,25943,25961,25964,25979,26001,26093,26109,26120,26128,26131,26136,26146,26147,26154,26161,26164,26166,26167,26168,26171,26172,26260,26344,26348,26353,26393,26415,26434,26448,26452,26453,26468,26471,26530,26651,26671,26673,26677,26690,26706,26710,26722,26797,26807,26810,26811,26827,26841,26852,26861,26898,26900,26909,26924,26925,26940,26944,26945,26950,26951,26971,26990,27035,27046,27054,27057,27085,27128,27171,27232,27237,27247,27274,27280,27311,27314,27322,27363,27383,27393,27395,27399,27414,27415,27485,27491,27505,27610,27739,27743,27757,27761,27777,27821,27922,27944,27971,28139,28163,28322,28351,28425,28441,28465,28609,28628,28716,28739,28746,28786,28789,28977,28991,29004,29005,29017,29037,29053,29065,29105,29142,29153,29155,29208,29304,29373,29460,29484,29502,29550,29563,29635,29682,29710,29742,29760,29801,29803,29895,29897,30222,30280,31551,31975,32862,33251,33415,33716,34239,35102,35718,35831,36085,36200,36297,36751,37116,38398,39193,39276,39315,39347,39375,39570,39722,39747,39768,39802,40343,40356,40367,40465,40516,40535,40614,40772,40774,40783,41150,41220,41254,41436,41800,42057,42065,42154,42163,42174,42188,42304,42405,42448,42490,42729,42806,42863,43009,43115,43143,43222,43234,43244,43345,43550,43601,43605,43615,43682,43846,43979,44184,44351,44491,44588,44613,44701,44894,44908,45051,45302,45303)
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 | 1398 | 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.86 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.31 ms |
System lock | 0.03 ms |
optimizing | 0.18 ms |
statistics | 2.77 ms |
preparing | 1.32 ms |
Sorting result | 0.03 ms |
executing | 0.01 ms |
Sending data | 6.76 ms |
end | 0.02 ms |
query end | 0.04 ms |
closing tables | 0.02 ms |
freeing items | 0.12 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 |