Tiempo de la consulta: 6.12 ms Después de la última consulta: 1.52 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.506 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 16:14:02')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 16:14:02')
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(80,82,85,197,212,328,385,417,520,587,595,596,625,662,781,843,849,925,935,992,994,1009,1051,1066,1072,1252,1253,1280,1325,1327,1354,1357,1359,1432,1455,1519,1535,1570,1603,1614,1620,1634,1646,1656,1686,1701,1713,1716,1724,1735,1739,1741,1754,1775,1800,1802,1822,1839,1860,1899,1900,1913,1953,2044,2188,2305,2337,2345,2369,2378,2424,2464,2468,2574,2598,2601,2613,2632,2648,2668,2684,2689,2710,2780,2805,2808,2825,2884,2918,2948,3009,3026,3037,3067,3070,3087,3101,3102,3165,3178,3188,3193,3212,3216,3262,3281,3292,3305,3329,3337,3346,3372,3373,3375,3376,3439,3593,3594,3648,3649,3718,3719,3721,3722,3725,3752,3857,3871,3904,3946,3963,4026,4033,4049,4131,4155,4191,4223,4320,4323,4389,4391,4411,4451,4461,4469,4486,4493,4507,4510,4520,4583,4584,4620,4640,4672,4770,4787,4832,4947,4957,4990,5086,5092,5094,5096,5104,5150,5151,5168,5170,5173,5183,5237,5244,5268,5282,5298,5301,5357,5413,5417,5469,5505,5544,5559,5637,5677,5678,5683,5688,5702,5703,5729,5732,5759,5768,5777,5779,5780,5793,5794,5798,5802,5814,5831,5848,5852,5895,5923,5942,5973,6039,6060,6086,6087,6093,6142,6160,6166,6173,6176,6220,6256,6264,6268,6270,6317,6335,6345,6476,6477,6538,6587,6606,6612,6783,6830,6910,6917,6944,6985,6998,7022,7024,7025,7105,7139,7205,7330,7358,7396,7416,7449,7482,7513,7526,7533,7551,7606,7615,7624,7659,7679,7728,7745,7813,7866,7869,7918,8002,8020,8026,8033,8057,8170,8294,8351,8386,8393,8438,8454,8462,8525,8529,8532,8568,8707,8940,8972,8973,9012,9018,9057,9061,9082,9147,9190,9196,9197,9330,9370,9380,9401,9470,9481,9529,9559,9641,9726,9845,9865,9869,9873,9924,9932,10048,10063,10172,10276,10352,10371,10400,10407,10501,10531,10562,10572,10603,10604,10724,10764,10811,10893,10915,11098,11106,11107,11146,11207,11241,11305,11320,11327,11356,11408,11549,11627,11693,11722,11814,11859,12216,12254,12324,12379,12410,12505,12541,12567,12592,12609,12624,12669,12708,12746,12870,12913,12917,13062,13067,13147,13219,13231,13268,13328,13348,13352,13353,13387,13456,13475,13501,13535,13575,13576,13589,13613,13685,13707,13727,13730,13748,13750,13782,13783,13818,13846,13851,13865,13924,13925,13941,13972,14022,14056,14122,14129,14177,14228,14327,14356,14430,14432,14524,14600,14648,14663,14679,14713,14725,14726,14733,14786,14787,14808,14846,14860,14862,14865,14873,14905,14906,14944,14973,14974,14988,14992,15017,15020,15046,15054,15097,15133,15140,15144,15171,15179,15208,15209,15234,15262,15293,15298,15304,15310,15414,15517,15540,15555,15594,15613,15619,15646,15667,15690,15710,15751,15753,15774,15818,15851,15868,15870,15871,15878,15915,15937,15967,15969,16005,16024,16029,16081,16102,16103,16120,16122,16176,16228,16245,16346,16422,16440,16455,16465,16481,16526,16547,16560,16569,16654,16728,16742,16743,16802,16846,16880,16894,16905,16908,16917,17028,17055,17063,17105,17116,17133,17173,17199,17315,17334,17335,17344,17353,17369,17395,17400,17409,17412,17449,17458,17483,17500,17584,17597,17608,17609,17629,17635,17643,17644,17645,17663,17680,17688,17699,17700,17721,17756,17785,17798,17826,17857,17862,17886,17894,17902,17910,17927,17946,17956,17965,17976,17977,17986,18006,18021,18028,18029,18035,18036,18067,18071,18075,18077,18088,18092,18151,18165,18168,18170,18171,18191,18206,18214,18227,18233,18241,18253,18259,18304,18305,18306,18307,18308,18327,18347,18354,18362,18413,18426,18469,18473,18491,18497,18500,18540,18575,18635,18638,18652,18707,18746,18751,18779,18790,18795,18800,18825,18828,18868,18901,18906,18907,18917,18918,18926,18958,18974,19005,19006,19019,19024,19061,19079,19082,19123,19127,19137,19153,19161,19204,19235,19267,19288,19299,19300,19301,19310,19320,19353,19390,19426,19432,19435,19484,19487,19495,19503,19530,19531,19551,19561,19594,19647,19684,19696,19706,19710,19723,19750,19751,19796,19824,19832,19858,19860,19874,19875,19876,19939,19982,19988,19989,19996,20017,20056,20066,20068,20150,20176,20187,20188,20191,20193,20206,20211,20213,20264,20277,20298,20307,20309,20310,20338,20340,20343,20391,20393,20396,20401,20410,20418,20421,20434,20437,20442,20448,20469,20472,20481,20484,20521,20550,20565,20567,20572,20574,20591,20592,20599,20601,20630,20642,20648,20662,20663,20688,20705,20709,20713,20714,20727,20750,20751,20752,20758,20792,20804,20808,20813,20830,20839,20865,20871,20881,20907,20910,20920,20921,20925,20953,20954,20966,20967,20973,20990,20997,21002,21012,21021,21033,21036,21042,21047,21050,21059,21069,21080,21087,21090,21095,21107,21132,21134,21159,21169,21203,21204,21259,21262,21273,21279,21288,21311,21329,21332,21397,21405,21410,21466,21473,21474,21485,21486,21487,21491,21504,21543,21547,21560,21563,21574,21581,21598,21602,21614,21618,21640,21641,21650,21660,21670,21683,21688,21690,21699,21704,21719,21720,21722,21726,21738,21740,21741,21756,21764,21769,21773,21800,21810,21811,21824,21835,21837,21853,21891,21902,21926,21932,21960,21976,21977,22015,22017,22034,22038,22050,22057,22073,22081,22085,22103,22112,22137,22162,22164,22186,22204,22242,22249,22253,22262,22267,22278,22281,22292,22296,22305,22308,22321,22353,22394,22401,22405,22418,22450,22453,22481,22495,22502,22514,22522,22542,22544,22545,22581,22590,22606,22621,22646,22658,22690,22693,22707,22709,22716,22722,22726,22737,22739,22745,22757,22759,22779,22781,22816,22838,22851,22869,22870,22871,22886,22894,22914,22925,22942,22959,22964,22968,22970,22971,22991,22997,23003,23017,23035,23036,23037,23051,23063,23065,23070,23083,23085,23095,23097,23099,23104,23117,23119,23123,23132,23135,23136,23161,23166,23170,23184,23201,23213,23216,23217,23229,23239,23257,23280,23287,23295,23302,23309,23317,23320,23328,23345,23348,23349,23351,23352,23365,23383,23396,23397,23398,23400,23420,23437,23453,23482,23512,23528,23556,23560,23571,23582,23587,23605,23609,23631,23649,23662,23666,23680,23681,23685,23704,23712,23772,23788,23800,23806,23811,23813,23814,23826,23847,23851,23854,23885,23891,23897,23905,23907,23932,23945,23951,23953,23961,23963,23964,23975,23980,23999,24029,24045,24055,24062,24067,24077,24112,24120,24127,24139,24165,24169,24189,24203,24204,24206,24213,24221,24223,24244,24245,24246,24307,24314,24316,24333,24334,24385,24386,24401,24410,24414,24425,24426,24483,24485,24502,24513,24549,24560,24583,24617,24628,24644,24651,24679,24681,24690,24694,24730,24750,24781,24785,24796,24800,24824,24834,24848,24861,24865,24877,24878,24896,24920,24925,24933,24941,24966,24967,24969,24973,24977,25021,25025,25030,25031,25032,25038,25053,25057,25061,25068,25089,25112,25118,25127,25129,25171,25201,25210,25243,25287,25296,25351,25369,25372,25377,25378,25396,25399,25407,25424,25436,25440,25450,25458,25460,25517,25520,25523,25524,25525,25528,25536,25541,25548,25551,25552,25568,25581,25582,25591,25596,25621,25622,25649,25673,25689,25702,25717,25723,25775,25779,25781,25804,25844,25874,25927,25941,25962,25966,25974,25983,26000,26033,26037,26043,26044,26082,26083,26097,26100,26113,26124,26146,26147,26148,26153,26164,26172,26201,26215,26241,26264,26271,26283,26289,26296,26318,26320,26335,26351,26354,26362,26366,26388,26405,26447,26504,26507,26565,26576,26578,26588,26592,26613,26620,26630,26639,26646,26652,26664,26691,26694,26699,26707,26734,26743,26745,26762,26784,26796,26814,26820,26825,26843,26845,26867,26874,26879,26897,26918,26935,26945,26949,26982,26991,26999,27023,27048,27065,27076,27119,27124,27139,27156,27216,27242,27252,27269,27291,27302,27316,27323,27330,27340,27344,27354,27408,27423,27425,27444,27460,27492,27502,27511,27522,27541,27551,27552,27568,27570,27595,27622,27635,27702,27708,27757,27778,27786,27803,27806,27818,27843,27845,27860,27875,27894,27914,27958,28022,28030,28117,28152,28162,28193,28218,28243,28248,28255,28281,28302,28327,28328,28329,28334,28340,28429,28436,28437,28458,28504,28511,28521,28528,28540,28548,28553,28555,28561,28615,28616,28629,28656,28665,28666,28668,28671,28678,28681,28683,28691,28703,28706,28707,28725,28727,28728,28745,28763,28776,28795,28799,28800,28803,28807,28828,28833,28834,28844,28847,28866,28872,28877,28878,28925,28931,29006,29013,29108,29127,29159,29201,29237,29298,29320,29329,29374,29389,29418,29459,29468,29511,29619,29805,29894,30138,30199,30262,30404,30572,30573,30674,30696,31401,31623,31624,31855,32286,32679,32755,32965,33015,33107,33327,33503,33997,34177,34205,34265,34417,34489,34595,34639,34690,34785,34862,34888,34902,34942,34969,34982,35051,35071,35072,35073,35088,35097,35156,35165,35167,35206,35269,35294,35298,35300,35308,35326,35427,35430,35488,35564,35588,35657,35674,35685,35694,35724,35762,35806,35808,35856,35882,35931,35936,35937,35959,35988,36012,36064,36165,36191,36239,36285,36298,36346,36355,36368,36369,36442,36463,36464,36489,36499,36575,36606,36723,36750,36772,36795,36798,36806,36813,36990,37015,37129,37154,37236,37251,37335,37366,37528,37529,37532,37604,37616,37647,37668,37733,37817,37829,37902,37913,37972,38133,38158,38212,38328,38365,38392,38417,38437,38438,38493,38503,38598,38599,38621,38663,38737,38824,38825,38841,38877,38885,38949,38961,38964,38988,39056,39061,39081,39149,39170,39205,39269,39299,39301,39310,39410,39449,39529,39587,39615,39636,39681,39695,39696,39701,39703,39762,39765,39782,39882,39896,39897,39971,40052,40072,40107,40110,40119,40136,40290,40319,40334,40344,40358,40370,40405,40481,40482,40509,40625,40655,40700,40757,40771,40784,40925,41063,41089,41109,41117,41185,41205,41301,41348,41353,41380,41381,41520,41585,41668,41723,41744,41866,41868,41874,41880,41955,42034,42051,42104,42106,42309,42394,42404,42428,42537,42603,42822,42859,42899,42900,42908,43090,43099,43107,43162,43163,43256,43259,43351,43353,43520,43545,43581,43603,43645,43697,43906,43944,44062,44067,44078,44100,44101,44197,44650,44682,44752,44817,44830,44833,44893,45134,45139,45217,45236,45293,45295)
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 | 1656 | 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.80 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.48 ms |
preparing | 1.29 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.34 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 |