Tiempo de la consulta: 6.85 ms Después de la última consulta: 1.56 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.390 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 16:53:33')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 16:53:33')
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(1,11,17,49,58,66,71,75,79,80,81,82,83,85,86,147,148,149,150,151,152,153,154,155,158,159,161,162,163,164,165,167,204,247,255,263,282,307,321,323,324,325,334,339,343,349,353,357,385,389,434,437,458,485,497,512,529,531,537,542,547,559,560,566,567,607,609,669,677,679,686,701,756,760,782,794,797,799,806,813,844,850,851,868,886,897,903,933,940,946,956,970,974,977,986,999,1012,1017,1018,1053,1083,1091,1130,1139,1169,1185,1186,1207,1226,1233,1236,1265,1277,1282,1298,1303,1304,1306,1318,1330,1337,1347,1502,1503,1600,1664,1698,1768,1817,1827,1835,2023,2064,2190,2313,2394,2476,2489,2611,2713,2732,2733,2762,2827,2857,2859,2964,2970,3020,3035,3040,3064,3069,3071,3099,3106,3107,3209,3210,3322,3329,3347,3364,3409,3415,3425,3427,3439,3448,3519,3520,3580,3603,3672,3692,3732,3794,3841,3884,3898,3940,3980,3986,3993,4009,4013,4063,4076,4105,4116,4153,4191,4257,4261,4281,4286,4309,4389,4405,4409,4410,4436,4445,4453,4471,4516,4533,4583,4597,4661,4670,4692,4710,5001,5085,5300,5491,5515,5525,5647,5662,5685,5730,5732,5827,5833,5894,5896,6012,6141,6142,6150,6186,6362,6411,6442,6448,6473,6475,6484,6546,6598,6616,6633,6654,6669,6681,6694,6725,6726,6744,6749,6751,6752,6762,6775,6785,6799,6806,6809,6828,6905,6908,6911,6913,6916,6941,6955,6971,6994,7014,7026,7101,7105,7173,7193,7201,7212,7243,7276,7285,7296,7328,7343,7377,7379,7407,7418,7435,7451,7456,7461,7462,7516,7544,7545,7551,7567,7568,7569,7615,7617,7625,7688,7691,7710,7730,7744,7797,7806,7829,7840,7851,7858,7863,7864,7892,7929,7930,7960,7965,7966,7981,8015,8018,8020,8022,8027,8053,8058,8106,8133,8154,8177,8250,8258,8295,8351,8445,8610,8679,8692,8864,8909,9242,9253,9282,9305,9351,9457,9473,9507,9531,9532,9580,9626,9772,9864,9984,10024,10050,10077,10079,10197,10198,10206,10239,10247,10264,10266,10289,10290,10294,10303,10309,10315,10331,10350,10351,10354,10389,10423,10425,10479,10486,10499,10518,10535,10557,10600,10611,10644,10690,10717,10719,10731,10741,10761,10779,10780,10806,10809,10831,10850,10907,10952,10957,10971,11002,11059,11062,11087,11091,11114,11150,11182,11186,11207,11230,11273,11328,11369,11417,11433,11447,11494,11503,11542,11611,11692,11719,11734,11823,11826,11836,11840,11880,11896,11924,12024,12033,12076,12162,12165,12216,12297,12301,12338,12363,12366,12398,12403,12443,12447,12477,12482,12490,12515,12517,12521,12536,12558,12562,12624,12625,12643,12670,12685,12697,12729,12745,12750,12757,12758,12786,12810,12837,12850,12909,12914,12920,12961,12963,12965,12977,12983,13061,13100,13105,13125,13152,13161,13213,13218,13235,13251,13257,13279,13287,13323,13420,13421,13443,13481,13511,13519,13548,13553,13569,13613,13624,13635,13651,13692,13757,13766,13792,13808,13890,13894,13926,13929,13985,14011,14013,14053,14054,14061,14069,14107,14109,14132,14139,14140,14168,14186,14189,14194,14197,14201,14205,14208,14227,14232,14237,14249,14252,14287,14334,14350,14382,14401,14426,14457,14487,14516,14523,14529,14557,14591,14596,14610,14612,14631,14655,14698,14701,14725,14760,14774,14778,14791,14820,14829,14833,14838,14841,14847,14865,14895,14911,14926,14949,14979,14999,15038,15049,15063,15065,15089,15094,15105,15109,15111,15114,15117,15144,15150,15158,15171,15177,15187,15213,15227,15233,15245,15249,15256,15259,15270,15297,15304,15305,15331,15336,15346,15355,15361,15407,15418,15429,15438,15441,15445,15455,15469,15472,15475,15487,15489,15499,15516,15520,15590,15615,15626,15631,15632,15640,15722,15740,15757,15760,15766,15850,15863,15875,15877,15884,15892,15893,15913,15926,15937,15940,15978,15981,15987,15995,16002,16014,16023,16024,16042,16043,16053,16054,16056,16086,16090,16125,16129,16155,16162,16164,16187,16192,16194,16211,16217,16264,16276,16277,16281,16301,16303,16323,16325,16338,16359,16366,16410,16418,16438,16468,16470,16524,16547,16554,16558,16560,16561,16564,16567,16571,16607,16626,16635,16642,16664,16668,16683,16689,16691,16698,16713,16717,16739,16777,16791,16815,16816,16819,16831,16840,16843,16844,16848,16850,16863,16898,16928,16948,16951,16964,16984,17001,17002,17004,17007,17043,17050,17059,17067,17071,17086,17105,17115,17124,17148,17149,17155,17189,17242,17253,17273,17280,17282,17287,17290,17299,17300,17314,17341,17354,17360,17364,17381,17403,17417,17455,17459,17461,17463,17467,17468,17470,17490,17500,17509,17523,17526,17539,17555,17572,17596,17597,17598,17601,17617,17618,17630,17633,17650,17659,17689,17701,17715,17716,17723,17727,17729,17748,17753,17759,17762,17772,17776,17782,17784,17786,17810,17818,17824,17826,17846,17853,17854,17877,17879,17893,17896,17907,17920,17935,17954,17989,17990,17992,17999,18001,18003,18022,18046,18047,18072,18074,18081,18083,18098,18158,18159,18173,18176,18217,18218,18219,18220,18236,18242,18246,18260,18263,18277,18292,18293,18304,18311,18333,18337,18348,18352,18358,18361,18395,18404,18409,18410,18427,18434,18443,18450,18451,18455,18467,18485,18498,18504,18520,18527,18547,18562,18563,18565,18568,18570,18572,18576,18581,18586,18591,18617,18619,18622,18625,18648,18665,18696,18697,18716,18744,18746,18757,18762,18789,18790,18794,18805,18808,18809,18814,18827,18866,18880,18881,18883,18886,18889,18898,18901,18911,18916,18947,18953,18957,18986,18997,19004,19006,19011,19014,19018,19048,19049,19060,19063,19107,19120,19134,19155,19165,19180,19183,19201,19217,19221,19229,19231,19251,19255,19260,19270,19276,19280,19283,19294,19297,19303,19306,19308,19313,19314,19331,19364,19377,19378,19381,19383,19392,19407,19413,19416,19418,19419,19433,19437,19440,19447,19452,19453,19457,19482,19484,19494,19504,19511,19518,19522,19552,19556,19566,19575,19583,19591,19593,19604,19617,19625,19634,19645,19646,19648,19651,19655,19659,19707,19718,19720,19730,19731,19733,19747,19763,19766,19775,19779,19811,19812,19813,19814,19824,19832,19854,19858,19864,19908,19925,19955,19983,19987,19999,20007,20015,20031,20040,20042,20048,20070,20076,20079,20083,20104,20127,20140,20146,20167,20179,20199,20219,20229,20236,20247,20261,20279,20289,20315,20318,20329,20332,20333,20336,20348,20352,20357,20362,20363,20379,20398,20422,20423,20427,20443,20461,20468,20472,20479,20488,20496,20522,20542,20553,20559,20574,20605,20607,20615,20630,20664,20680,20681,20691,20710,20724,20732,20737,20747,20753,20758,20761,20765,20769,20774,20775,20776,20783,20795,20799,20802,20812,20817,20826,20835,20868,20888,20891,20915,20917,20947,20950,20957,20975,20978,20983,21017,21079,21089,21105,21109,21119,21126,21128,21129,21136,21140,21152,21179,21184,21187,21223,21242,21270,21286,21289,21293,21297,21307,21317,21323,21349,21350,21366,21369,21371,21372,21384,21386,21415,21421,21429,21447,21452,21465,21490,21492,21496,21497,21499,21506,21518,21520,21545,21546,21548,21555,21570,21590,21606,21612,21620,21635,21662,21681,21702,21711,21740,21746,21751,21757,21766,21774,21775,21849,21855,21879,21880,21886,21894,21919,21945,21987,21992,22001,22011,22027,22038,22040,22043,22052,22061,22089,22122,22126,22128,22142,22178,22187,22191,22197,22204,22218,22225,22248,22268,22270,22294,22306,22319,22325,22328,22340,22342,22350,22359,22364,22366,22378,22382,22395,22407,22419,22431,22432,22484,22502,22519,22529,22530,22533,22555,22559,22561,22572,22592,22605,22607,22609,22642,22648,22666,22686,22707,22740,22751,22753,22766,22788,22793,22804,22807,22819,22836,22853,22858,22875,22899,22906,22909,22911,22921,22933,22934,22935,22974,22976,22983,22996,23002,23006,23011,23015,23017,23019,23022,23033,23050,23052,23055,23057,23069,23078,23080,23091,23103,23121,23126,23139,23151,23162,23190,23204,23220,23221,23222,23237,23239,23242,23262,23271,23295,23297,23300,23318,23326,23343,23348,23354,23380,23393,23396,23398,23415,23417,23420,23430,23436,23438,23439,23445,23456,23463,23466,23477,23495,23505,23512,23522,23525,23527,23555,23562,23568,23573,23575,23578,23585,23591,23596,23601,23602,23617,23626,23629,23651,23653,23659,23662,23665,23666,23673,23677,23680,23693,23706,23719,23728,23737,23740,23761,23764,23768,23781,23782,23792,23806,23814,23815,23816,23822,23826,23827,23829,23853,23869,23874,23910,23914,23925,23936,23953,23958,23960,23965,23995,23998,24001,24019,24034,24059,24060,24061,24063,24064,24068,24084,24106,24142,24145,24171,24184,24189,24211,24212,24215,24217,24220,24230,24236,24260,24268,24278,24299,24308,24315,24326,24329,24364,24365,24373,24386,24419,24429,24438,24470,24475,24504,24511,24526,24528,24543,24550,24577,24581,24608,24634,24642,24646,24659,24668,24672,24682,24688,24702,24718,24733,24754,24757,24759,24767,24773,24780,24790,24798,24804,24806,24807,24817,24825,24841,24849,24851,24857,24862,24863,24868,24872,24899,24900,24905,24906,24927,24941,24942,24960,24975,24995,24998,25024,25041,25056,25064,25070,25071,25081,25090,25104,25107,25119,25125,25134,25141,25143,25153,25199,25207,25225,25226,25250,25252,25260,25263,25279,25280,25293,25310,25314,25316,25332,25334,25345,25352,25353,25364,25366,25369,25382,25386,25411,25412,25435,25455,25471,25486,25500,25502,25535,25548,25595,25615,25616,25650,25653,25657,25662,25676,25697,25741,25747,25762,25778,25785,25820,25886,25921,25923,25942,25965,25971,26008,26043,26050,26101,26102,26103,26105,26115,26158,26165,26175,26238,26246,26293,26324,26338,26358,26367,26370,26389,26412,26431,26444,26479,26513,26541,26542,26559,26583,26589,26596,26604,26605,26654,26672,26698,26760,26776,26792,26814,26857,26898,26938,26939,26985,27002,27008,27009,27015,27020,27022,27024,27055,27056,27058,27060,27072,27076,27082,27083,27093,27101,27145,27149,27218,27248,27356,27362,27365,27375,27420,27438,27453,27477,27516,27525,27566,27572,27575,27646,27650,27720,27737,27822,27870,27957,27991,28075,28300,28316,28537,28561,28646,28664,28910,28922,28961,29014,29023,29032,29057,29066,29123,29180,29329,29340,29356,29365,29372,29374,29378,29391,29443,29466,29499,29584,29613,29617,29618,29659,29719,29834,29909,30111,30326,30481,30864,30991,31115,31213,31853,32136,32516,32676,33749,33932,34998,35638,35730,35741,35744,35803,35812,35882,35884,35921,35989,36017,36041,36042,36235,36310,36438,36602,36633,36958,37078,37080,37497,37915,38112,38800,38852,38916,38932,38985,39178,39318,39369,39527,39588,39653,39857,39858,39941,39998,40048,40050,40064,40147,40203,40214,40348,40356,40483,40545,40568,40706,40877,41035,41082,41184,41305,41337,44383,44770)
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 | 1763 | 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.82 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.37 ms |
System lock | 0.02 ms |
optimizing | 0.13 ms |
statistics | 2.70 ms |
preparing | 1.63 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.39 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.07 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 |