Tiempo de la consulta: 6.05 ms Después de la última consulta: 1.42 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.423 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-06 23:04:57')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 23:04:57')
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,17,44,45,46,47,48,49,50,51,52,53,56,57,58,59,83,94,109,133,135,138,156,190,194,195,200,204,205,233,239,241,247,255,295,323,324,325,331,332,333,334,353,368,390,430,445,458,460,485,495,512,519,520,523,529,531,537,542,547,560,566,567,583,607,617,686,690,701,756,760,772,805,806,808,811,850,886,891,892,907,922,933,977,986,1013,1036,1054,1067,1069,1083,1101,1112,1129,1130,1133,1175,1193,1207,1216,1226,1242,1254,1257,1265,1277,1284,1285,1326,1329,1335,1347,1350,1353,1414,1434,1459,1486,1492,1587,1591,1600,1645,1664,1698,1768,1804,1808,1813,1924,1978,2215,2265,2294,2485,2530,2552,2569,2601,2607,2688,2733,2759,2894,2958,2961,2967,3005,3070,3089,3099,3114,3126,3209,3279,3379,3409,3425,3520,3531,3634,3787,3825,3831,3832,3884,3898,3940,3951,3963,3984,3993,4046,4063,4116,4133,4153,4263,4300,4301,4309,4353,4378,4383,4409,4410,4434,4436,4445,4452,4453,4471,4515,4587,4692,4732,4817,4876,4931,4992,5001,5078,5085,5176,5279,5322,5362,5424,5472,5515,5584,5647,5649,5680,5700,5757,5792,5796,5825,5847,5894,6058,6215,6221,6254,6292,6331,6386,6393,6448,6470,6473,6484,6558,6577,6598,6666,6681,6686,6691,6694,6752,6775,6788,6806,6809,6821,6828,6869,6883,6913,6916,6941,6942,6965,6990,6994,7056,7105,7107,7121,7153,7173,7212,7243,7271,7275,7276,7287,7291,7292,7325,7356,7374,7380,7387,7401,7404,7407,7418,7431,7432,7453,7455,7462,7488,7516,7565,7567,7591,7594,7621,7652,7726,7730,7761,7804,7840,7847,7848,7950,7965,7967,8027,8053,8106,8191,8258,8327,8351,8366,8445,8464,8509,8530,8610,8663,8728,8736,8760,8806,8807,8819,8864,8939,8943,8950,9029,9055,9059,9062,9109,9115,9198,9218,9233,9239,9253,9473,9531,9532,9580,9670,9756,9767,9772,9858,9909,9924,10006,10024,10050,10077,10078,10079,10100,10197,10198,10266,10290,10303,10305,10323,10348,10350,10355,10418,10486,10499,10518,10557,10613,10620,10629,10690,10731,10765,10806,10831,10869,10876,10946,10955,11062,11064,11087,11102,11114,11182,11207,11235,11273,11330,11374,11447,11456,11477,11486,11494,11533,11542,11557,11560,11597,11612,11625,11662,11692,11720,11753,11840,11841,11857,11880,11937,11965,11969,12010,12024,12079,12080,12113,12188,12189,12207,12213,12216,12244,12281,12338,12363,12366,12415,12430,12475,12477,12490,12535,12592,12628,12668,12685,12704,12745,12757,12783,12802,12810,12851,12887,12895,12913,12920,12935,12939,12942,12965,12977,12983,12999,13004,13010,13040,13044,13062,13086,13112,13188,13235,13269,13273,13277,13279,13287,13309,13373,13423,13427,13506,13637,13646,13651,13672,13678,13707,13710,13718,13725,13729,13768,13770,13775,13798,13819,13834,13871,13891,13902,13935,13945,13949,13969,13985,14009,14011,14061,14069,14084,14103,14105,14109,14139,14151,14156,14158,14172,14205,14227,14232,14236,14246,14252,14264,14293,14334,14336,14348,14354,14363,14437,14478,14512,14516,14557,14591,14596,14602,14603,14608,14610,14651,14665,14675,14701,14727,14758,14766,14774,14778,14846,14854,14873,14890,14895,14909,14911,14926,14954,14977,14979,14990,15027,15065,15074,15114,15144,15166,15181,15188,15198,15213,15245,15256,15258,15297,15304,15311,15312,15315,15333,15441,15445,15455,15546,15572,15605,15631,15640,15660,15667,15706,15712,15760,15766,15782,15834,15874,15877,15890,15892,15899,15904,15945,15970,15972,15991,16020,16029,16053,16054,16087,16089,16108,16125,16157,16183,16187,16202,16208,16269,16277,16359,16361,16365,16375,16387,16390,16410,16444,16470,16474,16481,16488,16495,16500,16540,16546,16554,16558,16579,16596,16604,16607,16635,16642,16660,16691,16698,16700,16715,16717,16751,16794,16808,16815,16831,16843,16850,16892,16894,16921,16927,16964,16976,16983,17001,17039,17043,17059,17087,17091,17104,17114,17117,17135,17139,17142,17148,17149,17151,17156,17177,17178,17181,17189,17202,17205,17248,17263,17280,17307,17328,17336,17338,17341,17344,17354,17364,17375,17381,17403,17417,17463,17477,17493,17500,17541,17592,17596,17597,17611,17617,17629,17630,17650,17689,17695,17710,17729,17753,17772,17784,17785,17786,17811,17824,17862,17870,17883,17907,17924,17926,17954,17961,17990,18001,18027,18042,18046,18047,18072,18074,18078,18107,18140,18157,18158,18166,18172,18176,18212,18217,18227,18263,18290,18292,18300,18322,18333,18337,18352,18361,18375,18384,18390,18407,18419,18427,18430,18452,18455,18457,18465,18485,18509,18520,18527,18534,18535,18547,18559,18565,18576,18581,18586,18591,18619,18622,18648,18653,18668,18669,18703,18716,18718,18720,18749,18761,18781,18791,18804,18808,18809,18825,18856,18876,18877,18879,18898,18905,18951,18957,18986,18996,18997,19007,19018,19027,19048,19049,19060,19063,19077,19118,19120,19134,19145,19154,19183,19210,19217,19220,19249,19251,19270,19287,19303,19308,19313,19323,19331,19364,19377,19383,19390,19413,19419,19428,19433,19437,19439,19440,19453,19482,19484,19494,19498,19504,19514,19518,19522,19541,19552,19554,19556,19565,19566,19593,19604,19608,19625,19645,19646,19649,19651,19655,19658,19664,19702,19705,19720,19729,19730,19759,19763,19766,19771,19776,19779,19820,19823,19849,19864,19872,19903,19932,19942,19955,19973,19987,19999,20000,20002,20007,20014,20042,20045,20046,20055,20071,20076,20082,20083,20090,20095,20106,20130,20146,20159,20162,20167,20199,20208,20218,20226,20229,20236,20266,20279,20291,20311,20315,20323,20332,20352,20362,20391,20394,20400,20402,20408,20422,20423,20427,20438,20450,20452,20456,20468,20479,20503,20533,20552,20559,20574,20577,20595,20605,20612,20639,20643,20652,20656,20677,20691,20724,20753,20755,20765,20767,20769,20774,20776,20795,20799,20817,20820,20826,20835,20847,20885,20911,20915,20950,20969,20981,20992,21017,21044,21060,21061,21065,21093,21105,21152,21162,21184,21188,21198,21199,21227,21242,21251,21264,21271,21280,21293,21304,21309,21326,21335,21341,21366,21378,21385,21415,21452,21455,21465,21480,21482,21502,21518,21528,21538,21567,21606,21608,21609,21614,21619,21622,21644,21662,21698,21704,21714,21728,21766,21773,21775,21782,21801,21815,21826,21830,21834,21840,21849,21863,21868,21919,21922,21941,21962,22013,22048,22056,22057,22072,22089,22103,22126,22133,22135,22154,22166,22175,22191,22200,22225,22248,22254,22268,22287,22299,22309,22344,22350,22366,22373,22374,22378,22381,22382,22385,22395,22419,22422,22430,22431,22452,22490,22507,22530,22537,22556,22559,22607,22666,22694,22695,22704,22722,22725,22736,22740,22753,22761,22766,22793,22802,22827,22875,22889,22893,22906,22921,22933,22934,22935,22976,22985,22992,23002,23006,23014,23017,23019,23035,23050,23077,23080,23082,23103,23104,23110,23116,23119,23126,23134,23145,23151,23178,23185,23213,23243,23271,23273,23287,23331,23332,23336,23343,23354,23358,23364,23365,23371,23376,23380,23396,23399,23409,23417,23423,23424,23426,23445,23451,23466,23474,23477,23495,23505,23512,23513,23548,23557,23607,23648,23651,23659,23665,23666,23668,23676,23677,23693,23703,23711,23719,23721,23740,23749,23761,23768,23776,23782,23786,23792,23806,23816,23827,23828,23833,23834,23865,23869,23872,23874,23878,23906,23914,23921,23935,23948,23949,23962,23965,23998,24001,24028,24059,24103,24108,24171,24172,24195,24212,24224,24228,24233,24260,24264,24271,24279,24299,24309,24315,24343,24350,24365,24368,24373,24380,24391,24427,24438,24442,24443,24470,24477,24511,24518,24527,24535,24543,24579,24586,24608,24617,24625,24630,24636,24659,24672,24692,24704,24718,24752,24754,24763,24780,24790,24822,24851,24857,24868,24905,24922,24927,24942,24954,24960,24974,24985,24995,25018,25081,25090,25104,25111,25116,25117,25119,25131,25134,25141,25143,25156,25170,25182,25195,25199,25201,25207,25252,25260,25274,25286,25303,25314,25316,25345,25348,25353,25366,25400,25435,25486,25502,25506,25511,25595,25615,25616,25650,25671,25707,25717,25731,25736,25740,25745,25778,25860,25885,25886,25888,25898,25922,25944,25987,25989,26001,26002,26028,26091,26103,26130,26132,26165,26221,26238,26264,26284,26293,26317,26324,26338,26360,26389,26396,26403,26412,26431,26458,26479,26505,26513,26550,26565,26589,26591,26599,26605,26637,26654,26671,26672,26742,26771,26776,26792,26835,26842,26843,26857,26864,26874,26905,26907,26916,26933,26939,26944,26947,26959,27000,27008,27015,27020,27024,27055,27059,27076,27091,27093,27105,27106,27144,27149,27178,27179,27188,27201,27203,27248,27265,27343,27356,27401,27409,27420,27438,27447,27453,27457,27460,27477,27526,27529,27535,27566,27572,27707,27717,27720,27726,27775,27786,27805,27809,27822,27846,27855,27878,27911,27916,27918,27921,27923,27924,27926,27949,27956,27969,27978,27991,27992,27999,28030,28078,28082,28208,28316,28349,28372,28419,28614,28615,28643,28845,28910,28922,29023,29054,29088,29121,29123,29174,29223,29290,29380,29459,29466,29499,29511,29540,29584,29611,29626,29641,29834,29849,29888,29909,30111,30293,30393,30394,30484,30511,30621,30676,30932,30940,31026,32136,32304,32484,32796,33932,34052,34082,34415,34449,34525,34560,34795,34876,34923,34978,35043,35195,35324,35436,35503,35609,35626,35730,35741,35783,35803,35850,35861,35905,35909,35921,35953,35989,36017,36041,36147,36174,36192,36204,36208,36222,36223,36235,36238,36330,36439,36479,36515,36633,36736,36850,36958,38263,38593,38631,38800,38852,38885,38898,38916,38985,39062,39114,39173,39178,39241,39242,39285,39318,39369,39527,39653,39729,39846,39858,39886,39941,39998,40023,40050,40064,40075,40111,40187,40212,40214,40218,40225,40239,40392,40414,40665,40706,40786,40983,41059,41146,41337,41363,42181,43905,44255,44433)
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 | 1612 | 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.81 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.28 ms |
System lock | 0.02 ms |
optimizing | 0.11 ms |
statistics | 2.44 ms |
preparing | 1.26 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.36 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 |