Tiempo de la consulta: 5.29 ms Después de la última consulta: 1.24 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.368 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 21:20:48')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 21:20: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(92,98,122,176,178,179,226,432,660,792,1085,1331,1386,1391,1458,1513,1555,1634,1644,1654,1693,1785,1900,1910,1915,1928,2090,2092,2122,2156,2367,2424,2454,2592,2598,2600,2610,2740,2963,3002,3085,3346,3870,3969,4163,4378,4388,4511,4572,4658,4668,4957,4990,5040,5079,5086,5104,5139,5150,5170,5173,5288,5301,5622,5784,5799,5810,5814,5820,5976,6012,6097,6112,6173,6199,6264,6270,6288,6307,6429,6446,6626,6695,6826,6830,6839,6847,6873,6915,6937,7082,7083,7117,7133,7134,7227,7294,7314,7416,7433,7449,7477,7523,7526,7548,7618,7659,7663,7711,7717,7745,7746,7750,7782,7797,7808,7813,7829,7866,7936,7958,8016,8034,8036,8056,8070,8113,8146,8167,8330,8347,8362,8416,8462,8669,8681,8689,8742,8899,9018,9046,9051,9085,9107,9197,9211,9224,9270,9500,9518,9524,9584,9595,9650,9658,9730,9734,9775,9851,9858,9892,9896,9965,10112,10122,10199,10332,10398,10400,10420,10604,10656,10691,10715,10745,10764,10811,10878,10956,11163,11164,11182,11305,11374,11379,11474,11476,11648,11859,11864,11911,11994,12051,12053,12054,12083,12095,12223,12318,12482,12565,12714,12771,12807,12889,12895,12997,13039,13045,13074,13268,13290,13328,13402,13509,13535,13575,13576,13644,13681,13748,13782,13783,13846,13868,13924,13938,13941,13998,14094,14199,14203,14242,14263,14327,14348,14356,14366,14373,14378,14430,14435,14469,14480,14482,14502,14508,14581,14586,14598,14608,14637,14648,14654,14663,14669,14679,14699,14733,14747,14814,14896,14897,14948,14953,14964,14973,14987,15001,15021,15107,15110,15154,15174,15179,15181,15201,15217,15262,15283,15293,15298,15304,15311,15325,15358,15375,15386,15410,15417,15421,15473,15482,15495,15517,15550,15561,15580,15615,15650,15705,15741,15751,15753,15762,15781,15784,15794,15840,15870,15901,15947,15954,15955,15965,15977,15985,16040,16056,16106,16122,16126,16142,16214,16237,16246,16279,16337,16370,16440,16455,16518,16519,16526,16556,16611,16627,16654,16660,16667,16689,16720,16802,16812,16822,16846,16894,16908,16917,16927,16944,16950,17036,17063,17065,17127,17133,17136,17162,17269,17317,17334,17335,17346,17400,17408,17409,17412,17419,17433,17437,17442,17463,17479,17511,17520,17584,17603,17610,17629,17643,17644,17645,17654,17680,17698,17699,17700,17719,17785,17798,17824,17826,17831,17862,17886,17900,17918,17946,17948,17949,17965,17976,17977,18006,18021,18028,18031,18035,18036,18057,18135,18151,18168,18170,18171,18191,18213,18215,18241,18248,18253,18259,18262,18263,18271,18277,18292,18308,18315,18347,18354,18362,18376,18406,18410,18413,18426,18435,18473,18491,18497,18500,18509,18519,18538,18540,18575,18624,18635,18638,18670,18675,18695,18707,18719,18726,18732,18746,18751,18753,18778,18790,18795,18804,18821,18828,18845,18852,18868,18917,18918,18933,18948,18952,18966,18974,19005,19029,19039,19040,19053,19061,19062,19076,19079,19082,19104,19106,19121,19127,19150,19153,19204,19235,19242,19252,19254,19267,19288,19301,19310,19320,19350,19358,19390,19405,19426,19430,19432,19434,19440,19454,19462,19483,19484,19487,19495,19508,19509,19523,19527,19531,19561,19581,19592,19594,19654,19658,19668,19676,19684,19696,19710,19715,19723,19750,19751,19761,19762,19767,19774,19777,19791,19824,19832,19856,19876,19885,19920,19939,19957,19982,19988,19989,20003,20017,20030,20035,20039,20064,20066,20068,20092,20117,20122,20150,20176,20183,20187,20188,20193,20211,20213,20214,20262,20263,20264,20277,20295,20298,20307,20310,20325,20340,20343,20384,20386,20391,20401,20410,20421,20437,20442,20459,20469,20481,20484,20526,20528,20543,20550,20565,20566,20567,20572,20592,20598,20601,20630,20641,20642,20648,20670,20688,20691,20705,20709,20713,20714,20715,20716,20726,20727,20750,20752,20782,20792,20804,20807,20808,20810,20813,20830,20837,20841,20862,20865,20871,20876,20877,20881,20887,20894,20897,20907,20910,20920,20925,20944,20954,20956,20964,20973,20984,20986,20990,21002,21010,21012,21021,21033,21042,21047,21050,21059,21066,21069,21080,21090,21107,21132,21134,21135,21142,21159,21167,21169,21172,21173,21182,21191,21196,21198,21204,21222,21243,21262,21269,21273,21288,21310,21312,21324,21327,21329,21332,21346,21356,21366,21380,21397,21404,21405,21410,21436,21454,21466,21474,21485,21486,21487,21491,21501,21502,21504,21516,21530,21543,21547,21560,21563,21574,21581,21585,21588,21596,21618,21640,21641,21647,21650,21660,21664,21670,21683,21688,21690,21699,21722,21726,21727,21738,21756,21759,21761,21764,21767,21769,21800,21810,21811,21818,21824,21837,21842,21853,21860,21891,21902,21926,21932,21958,21960,21969,21976,21977,22002,22013,22015,22017,22034,22037,22050,22073,22081,22085,22087,22112,22115,22129,22153,22156,22162,22164,22170,22172,22204,22210,22239,22242,22253,22262,22267,22278,22281,22292,22305,22321,22353,22394,22405,22409,22411,22466,22481,22499,22502,22511,22514,22522,22523,22534,22539,22544,22545,22590,22606,22609,22634,22646,22658,22666,22671,22680,22707,22716,22726,22737,22741,22743,22745,22746,22753,22757,22759,22779,22797,22816,22838,22865,22872,22894,22914,22923,22949,22968,22970,22971,22973,22991,22997,23003,23013,23017,23035,23036,23037,23051,23063,23064,23070,23085,23093,23095,23097,23099,23104,23117,23119,23123,23132,23135,23136,23157,23184,23201,23202,23203,23213,23216,23217,23218,23235,23239,23254,23264,23268,23277,23280,23295,23302,23305,23309,23315,23317,23320,23345,23348,23349,23351,23352,23358,23383,23396,23404,23420,23440,23465,23480,23491,23504,23512,23524,23528,23544,23554,23556,23560,23571,23576,23582,23602,23604,23605,23609,23628,23631,23632,23649,23662,23680,23681,23685,23695,23704,23712,23731,23743,23751,23772,23800,23805,23806,23811,23813,23814,23826,23847,23851,23854,23866,23876,23886,23887,23888,23890,23891,23893,23897,23899,23901,23902,23904,23905,23906,23907,23921,23927,23945,23951,23953,23961,23963,23964,23975,23981,23983,23986,23999,24000,24016,24029,24039,24040,24045,24055,24088,24110,24112,24120,24127,24139,24160,24165,24169,24189,24197,24203,24204,24206,24210,24213,24223,24244,24245,24246,24270,24294,24307,24333,24337,24369,24385,24394,24395,24401,24410,24412,24414,24422,24425,24426,24429,24456,24474,24483,24486,24496,24502,24503,24513,24549,24560,24563,24583,24587,24589,24592,24598,24618,24628,24644,24651,24663,24678,24679,24681,24694,24721,24730,24738,24750,24764,24773,24782,24784,24796,24800,24824,24848,24852,24861,24865,24877,24878,24888,24896,24925,24941,24947,24966,24967,24969,24973,24977,24984,25021,25025,25031,25046,25053,25057,25061,25089,25118,25127,25129,25142,25157,25171,25205,25210,25233,25243,25260,25287,25296,25320,25351,25369,25372,25376,25378,25396,25399,25405,25407,25416,25418,25424,25436,25440,25458,25460,25505,25517,25520,25523,25524,25525,25528,25536,25541,25548,25551,25552,25568,25582,25591,25596,25611,25639,25649,25702,25775,25779,25781,25785,25844,25863,25874,25904,25909,25918,25929,25941,25962,25964,25979,25983,26001,26033,26035,26044,26082,26093,26120,26128,26131,26136,26146,26147,26161,26164,26168,26172,26184,26201,26241,26271,26283,26296,26318,26320,26335,26344,26351,26354,26362,26366,26393,26415,26434,26448,26452,26453,26492,26530,26588,26613,26651,26671,26673,26677,26694,26706,26710,26734,26784,26796,26810,26811,26814,26827,26841,26861,26898,26900,26924,26925,26940,26971,26990,26999,27048,27057,27065,27085,27119,27124,27128,27139,27156,27171,27232,27242,27247,27252,27302,27330,27363,27393,27395,27399,27425,27485,27505,27551,27622,27739,27743,27757,27761,27777,27803,27806,27818,27821,27860,27875,27922,27944,27958,27971,28030,28117,28139,28163,28281,28322,28328,28351,28425,28429,28441,28458,28465,28504,28555,28609,28683,28691,28703,28739,28786,28789,29004,29005,29017,29037,29053,29065,29105,29108,29142,29155,29159,29208,29298,29320,29460,29484,29502,29550,29563,29619,29635,29682,29742,29760,29801,29803,29895,29897,30222,31623,31624,31975,32679,33043,34177,34205,34239,34417,34489,34639,34690,34888,35300,35657,35831,35936,35959,36298,36499,36813,36917,36990,38961,39570,40072,40343,40356,40367,40370,40772,41089,41185,41868,42899,42900,42908,43581,43906,44682,44830)
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 | 1347 | 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.84 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.27 ms |
System lock | 0.02 ms |
optimizing | 0.10 ms |
statistics | 2.12 ms |
preparing | 1.05 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.38 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.06 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 |