Tiempo de la consulta: 8.16 ms Después de la última consulta: 1.62 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.392 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 13:55:33')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 13:55: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(9,49,58,74,75,76,77,78,111,113,114,117,131,133,136,139,140,142,143,144,145,146,151,155,170,172,178,179,202,204,207,208,234,271,280,287,290,291,293,344,349,350,353,374,376,377,378,379,380,420,437,447,456,489,495,605,607,608,611,639,644,645,653,663,686,693,701,719,721,723,744,757,777,797,831,836,843,862,868,891,912,929,941,942,944,964,976,986,997,1033,1043,1044,1047,1080,1130,1143,1158,1169,1173,1196,1204,1207,1215,1232,1236,1247,1252,1253,1256,1273,1287,1302,1329,1339,1459,1463,1486,1601,1643,1664,1698,1709,1713,1725,1893,1898,1931,2144,2150,2163,2164,2169,2178,2192,2194,2195,2199,2201,2202,2204,2210,2213,2217,2222,2227,2232,2234,2237,2242,2245,2246,2249,2256,2273,2285,2286,2299,2319,2346,2348,2386,2398,2409,2656,2713,2714,2742,2757,2859,2901,2991,2997,3020,3028,3045,3049,3091,3113,3117,3124,3126,3209,3212,3215,3223,3279,3286,3301,3329,3340,3442,3668,3669,3671,3687,3738,3783,3814,3816,3825,3842,3852,3870,3886,3895,3931,3932,3957,4061,4087,4117,4120,4128,4188,4204,4206,4229,4254,4319,4327,4346,4378,4399,4638,4765,4910,4987,5085,5194,5366,5457,5471,5504,5559,5647,5659,5730,5814,5870,6039,6131,6234,6292,6298,6333,6384,6406,6464,6470,6484,6538,6573,6577,6585,6616,6631,6687,6688,6817,6831,6908,6940,6942,6948,6957,6961,6965,6966,6968,6989,6998,7016,7032,7043,7075,7131,7154,7161,7189,7275,7280,7282,7288,7291,7303,7311,7312,7326,7335,7361,7380,7381,7387,7401,7402,7403,7410,7414,7422,7427,7434,7450,7454,7483,7486,7508,7522,7538,7546,7556,7558,7572,7614,7626,7638,7642,7677,7713,7724,7730,7732,7733,7774,7813,7829,7831,7836,7847,7861,7862,7867,7874,7890,7894,7914,7916,7923,7957,7965,7967,7983,7985,7989,8027,8092,8107,8108,8134,8177,8192,8254,8287,8309,8317,8356,8395,8474,8551,8585,8694,8705,8713,8772,8855,8881,8950,8967,8975,9027,9057,9091,9130,9203,9239,9249,9318,9414,9428,9429,9432,9438,9451,9611,9668,9723,9725,9732,9791,9801,9861,9916,9966,9983,9985,10011,10028,10092,10100,10110,10120,10149,10168,10181,10193,10227,10259,10265,10269,10313,10318,10357,10366,10369,10370,10382,10399,10415,10444,10453,10484,10534,10585,10609,10611,10623,10682,10721,10777,10782,10786,10798,10803,10820,10821,10835,10912,10916,10955,10957,10970,10971,11005,11037,11091,11188,11192,11235,11242,11249,11260,11310,11316,11333,11345,11362,11365,11377,11430,11441,11539,11599,11640,11661,11663,11726,11779,11799,11808,11816,11863,11893,11922,11950,11976,12009,12042,12070,12081,12112,12133,12147,12174,12178,12179,12204,12243,12270,12388,12401,12427,12446,12465,12492,12520,12579,12581,12582,12609,12610,12625,12670,12677,12681,12685,12709,12758,12764,12769,12803,12806,12808,12838,12846,12851,12873,12898,12907,12956,12978,12985,12990,13000,13004,13006,13035,13036,13041,13079,13124,13135,13137,13216,13229,13285,13307,13332,13334,13390,13420,13445,13461,13466,13476,13492,13497,13500,13515,13587,13647,13666,13696,13771,13790,13805,13817,13835,13837,13880,13901,13906,13922,13953,13972,14024,14098,14113,14116,14143,14152,14186,14205,14223,14248,14250,14257,14258,14283,14285,14289,14307,14336,14352,14354,14370,14372,14391,14396,14424,14426,14447,14450,14453,14481,14507,14517,14530,14558,14560,14570,14571,14573,14591,14596,14625,14629,14630,14676,14695,14697,14700,14742,14743,14749,14754,14771,14775,14788,14789,14840,14843,14845,14852,14856,14929,14939,14983,14984,14986,14988,15007,15010,15018,15035,15076,15086,15129,15156,15158,15173,15205,15214,15231,15245,15286,15304,15311,15315,15316,15332,15335,15340,15351,15376,15392,15406,15408,15424,15444,15452,15475,15486,15520,15522,15552,15569,15581,15600,15608,15616,15655,15672,15689,15700,15704,15714,15723,15730,15732,15742,15755,15778,15785,15790,15805,15812,15832,15874,15876,15880,15894,15897,15898,15910,15965,16030,16053,16058,16088,16095,16127,16133,16180,16248,16249,16250,16254,16278,16282,16291,16306,16316,16324,16357,16362,16364,16366,16375,16381,16384,16417,16427,16430,16474,16476,16483,16486,16490,16501,16516,16521,16523,16528,16542,16543,16551,16584,16622,16656,16657,16670,16675,16687,16695,16698,16724,16726,16728,16781,16783,16814,16816,16839,16841,16861,16865,16942,16982,17047,17049,17084,17096,17116,17142,17153,17163,17188,17201,17222,17240,17246,17256,17272,17274,17278,17288,17289,17300,17331,17333,17336,17365,17386,17387,17410,17414,17422,17444,17449,17497,17540,17542,17553,17559,17561,17566,17573,17575,17598,17599,17613,17615,17625,17630,17632,17660,17664,17668,17670,17688,17711,17712,17717,17734,17736,17753,17779,17783,17784,17808,17814,17820,17824,17834,17850,17851,17862,17887,17914,17919,17922,17924,17930,17933,17936,17941,17943,17950,17955,17967,17983,17995,17996,18006,18044,18060,18061,18074,18118,18121,18220,18222,18260,18276,18278,18291,18295,18300,18301,18311,18320,18351,18380,18382,18386,18391,18397,18428,18429,18463,18479,18486,18499,18524,18541,18549,18552,18571,18577,18603,18605,18626,18651,18658,18664,18668,18693,18702,18705,18706,18708,18711,18724,18728,18734,18750,18764,18810,18811,18830,18839,18843,18846,18847,18849,18853,18854,18871,18873,18877,18880,18888,18894,18900,18905,18959,18975,18984,18997,19001,19003,19015,19037,19055,19105,19124,19128,19129,19134,19138,19140,19145,19173,19178,19220,19222,19230,19254,19259,19277,19284,19287,19290,19296,19311,19315,19325,19344,19375,19379,19381,19414,19416,19419,19424,19435,19437,19439,19455,19460,19486,19492,19501,19512,19517,19521,19531,19536,19572,19574,19607,19622,19634,19639,19644,19659,19679,19684,19710,19725,19733,19754,19773,19794,19807,19819,19830,19848,19855,19869,19871,19877,19881,19901,19915,19923,19929,19958,19960,19965,19972,19982,19984,19993,19996,20042,20045,20083,20091,20097,20103,20104,20116,20119,20148,20154,20163,20168,20175,20186,20189,20200,20276,20286,20297,20333,20345,20352,20366,20382,20390,20405,20411,20433,20437,20445,20447,20458,20474,20488,20515,20519,20540,20542,20545,20555,20559,20563,20577,20588,20632,20638,20659,20666,20698,20708,20710,20718,20752,20772,20777,20778,20781,20794,20805,20811,20814,20834,20869,20885,20913,20940,20947,20959,20960,20979,20981,21009,21055,21058,21060,21075,21104,21106,21107,21116,21117,21118,21122,21128,21143,21170,21171,21198,21218,21228,21247,21305,21316,21321,21325,21344,21350,21367,21370,21378,21380,21390,21392,21398,21418,21421,21448,21449,21457,21463,21470,21495,21520,21521,21522,21540,21551,21569,21577,21591,21607,21609,21611,21640,21657,21663,21680,21682,21684,21702,21714,21741,21749,21764,21775,21776,21777,21778,21783,21792,21853,21863,21864,21867,21878,21883,21895,21904,21906,21917,21924,21928,21947,21961,21968,21977,21990,21997,22000,22003,22030,22038,22039,22044,22067,22072,22079,22093,22096,22106,22119,22126,22132,22139,22154,22170,22178,22180,22207,22215,22255,22276,22278,22298,22320,22326,22332,22336,22349,22359,22363,22382,22395,22414,22417,22419,22436,22450,22460,22465,22476,22488,22495,22497,22501,22555,22570,22579,22588,22595,22596,22616,22622,22653,22659,22661,22693,22698,22709,22715,22718,22735,22746,22751,22752,22754,22759,22781,22799,22804,22820,22840,22866,22879,22913,22915,22920,22930,22935,22944,22951,22960,22989,23009,23029,23034,23055,23071,23072,23077,23078,23087,23093,23103,23112,23137,23140,23144,23156,23208,23232,23236,23242,23252,23270,23273,23289,23302,23308,23339,23367,23368,23397,23401,23405,23430,23438,23444,23449,23484,23498,23527,23535,23550,23553,23555,23569,23577,23599,23621,23623,23634,23642,23646,23665,23682,23691,23693,23695,23698,23709,23714,23716,23719,23727,23743,23768,23774,23784,23787,23816,23836,23846,23849,23869,23902,23912,23920,23937,23944,23949,23955,23965,23968,23969,23991,24003,24009,24015,24024,24033,24060,24065,24066,24076,24090,24100,24102,24110,24115,24159,24164,24170,24178,24196,24217,24233,24237,24239,24258,24270,24272,24275,24283,24284,24291,24296,24302,24306,24335,24362,24368,24372,24402,24417,24422,24428,24430,24437,24441,24453,24457,24461,24473,24475,24481,24506,24520,24530,24556,24565,24573,24575,24577,24584,24590,24617,24635,24649,24656,24672,24677,24690,24700,24707,24720,24724,24726,24730,24751,24754,24755,24775,24779,24780,24794,24795,24800,24805,24809,24816,24841,24850,24859,24865,24930,24931,24946,24963,25002,25003,25026,25036,25037,25043,25063,25069,25077,25081,25090,25096,25102,25109,25112,25116,25117,25121,25136,25155,25164,25165,25180,25187,25192,25200,25281,25282,25287,25291,25297,25300,25310,25327,25329,25332,25343,25352,25356,25358,25367,25384,25386,25387,25389,25402,25408,25416,25418,25420,25429,25434,25440,25452,25462,25477,25484,25501,25515,25517,25519,25523,25526,25535,25548,25555,25560,25564,25573,25589,25601,25614,25636,25638,25640,25657,25664,25672,25676,25687,25688,25692,25697,25701,25711,25718,25740,25765,25806,25807,25820,25854,25884,25887,25889,25908,25919,25926,25948,25959,25971,26023,26030,26043,26055,26063,26133,26193,26229,26239,26250,26258,26261,26274,26275,26292,26340,26375,26390,26413,26421,26431,26451,26456,26521,26540,26541,26559,26561,26571,26595,26596,26618,26697,26709,26711,26723,26741,26742,26807,26809,26835,26842,26843,26853,26854,26859,26864,26873,26930,26959,26960,26969,27001,27024,27025,27028,27039,27044,27056,27058,27061,27062,27070,27079,27094,27158,27186,27197,27221,27233,27263,27271,27290,27315,27327,27346,27374,27379,27384,27417,27435,27506,27532,27544,27552,27578,27584,27633,27634,27646,27707,27738,27745,27763,27795,27832,27851,27871,27918,27921,27923,27924,27926,27949,27950,27968,27975,27990,27998,28036,28066,28068,28094,28213,28264,28283,28295,28309,28342,28372,28457,28461,28464,28472,28478,28484,28496,28499,28511,28537,28606,28611,28620,28623,28690,28747,28749,28755,28774,28787,28826,28852,28887,28892,28907,28908,28933,28939,28949,28951,28972,28973,29049,29061,29073,29140,29171,29194,29208,29214,29219,29223,29241,29269,29325,29349,29484,29534,29535,29539,29576,29588,29591,29611,29622,29642,29673,29719,29722,29911,29912,29923,29930,29939,29962,30274,30449,30939,31286,31430,31586,31908,32331,32392,32565,32820,32840,35000,35566,35711,35740,35774,35858,35942,36216,36492,36866,36875,37587,38380,38495,38597,38612,38712,38736,38793,38846,38847,38857,38867,38868,38878,38884,38898,38900,38932,38958,38975,38986,39020,39025,39049,39064,39131,39144,39159,39172,39385,39387,39642,39657,39713,39902,39931,39966,39970,39981,39998,40014,40036,40168,40184,40223,40351,40369,40611,40636,40681,40759,40797,40935,40993,41002,41005,41026,41034,41047,41163,41211,41257,41325,41399,41507,42210,42434,42455,42458,42532,42562,42948,43466,43842,43912,43981,43996,44289,44303,45004,45005,45009,45023,45180)
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 | 1817 | 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 | 1.07 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.42 ms |
System lock | 0.02 ms |
optimizing | 0.14 ms |
statistics | 3.62 ms |
preparing | 1.86 ms |
Sorting result | 0.02 ms |
executing | 0.03 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.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 |