Tiempo de la consulta: 6.94 ms Después de la última consulta: 1.49 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.250 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 02:14:53')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 02:14:53')
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,43,49,58,74,75,76,77,78,83,113,114,117,136,137,155,170,172,207,208,281,287,290,291,293,316,344,349,353,362,368,377,398,437,448,522,594,607,621,693,728,744,749,752,784,797,825,831,843,931,942,963,976,980,986,997,1026,1027,1066,1088,1134,1183,1193,1198,1207,1215,1232,1239,1247,1273,1287,1312,1318,1339,1344,1364,1371,1428,1440,1459,1461,1486,1492,1541,1556,1601,1649,1673,1690,1709,1782,1823,1827,1882,1931,1983,2000,2110,2115,2207,2332,2357,2372,2391,2477,2540,2555,2568,2631,2713,2720,2728,2729,2735,2757,2765,2859,2870,2896,2901,2922,2934,2939,2957,2984,2991,2997,3018,3020,3028,3033,3040,3045,3117,3124,3139,3141,3177,3209,3212,3257,3332,3361,3373,3397,3442,3478,3567,3574,3668,3671,3738,3759,3776,3814,3838,3842,3856,3870,3881,3913,3934,4006,4015,4019,4120,4128,4339,4358,4371,4378,4399,4690,4693,4745,4856,4896,5052,5053,5059,5233,5285,5471,5559,5633,5647,5662,5710,5729,5827,5840,5933,5940,6039,6047,6051,6094,6131,6176,6203,6211,6234,6267,6283,6284,6294,6298,6327,6422,6438,6445,6453,6459,6484,6501,6516,6567,6571,6589,6616,6619,6674,6688,6728,6780,6802,6825,6832,6925,6989,6998,7002,7094,7175,7189,7219,7225,7280,7282,7311,7342,7361,7371,7387,7402,7403,7410,7429,7483,7486,7537,7553,7584,7614,7626,7670,7677,7678,7744,7766,7823,7836,7847,7849,7861,7890,7894,7914,7951,7965,7970,7989,8027,8107,8108,8134,8141,8169,8177,8183,8189,8204,8205,8223,8236,8245,8246,8247,8315,8320,8355,8380,8401,8426,8471,8521,8537,8565,8569,8571,8602,8626,8630,8757,8816,8826,8838,8839,8845,8877,8888,8912,8921,8952,8983,8986,9053,9058,9091,9131,9136,9158,9164,9191,9318,9401,9411,9432,9442,9487,9561,9564,9616,9752,9818,9842,9916,9926,10017,10049,10092,10100,10110,10120,10144,10149,10181,10187,10193,10263,10315,10317,10318,10340,10369,10370,10375,10376,10381,10382,10392,10399,10415,10444,10453,10479,10491,10515,10552,10561,10596,10623,10673,10682,10721,10782,10798,10860,10896,10938,10939,10948,10953,10957,10970,10975,10991,11037,11060,11074,11075,11093,11120,11165,11186,11188,11235,11252,11255,11285,11288,11292,11308,11343,11361,11371,11491,11611,11626,11629,11637,11648,11661,11671,11715,11726,11729,11737,11738,11739,11779,11789,11800,11922,11938,11950,11967,12002,12070,12081,12082,12094,12118,12133,12219,12243,12270,12283,12326,12339,12356,12364,12384,12465,12491,12511,12513,12520,12524,12526,12580,12581,12582,12610,12752,12803,12811,12816,12842,12846,12851,12873,12907,12978,12980,13002,13006,13035,13036,13041,13056,13110,13118,13124,13125,13137,13150,13152,13153,13161,13207,13217,13219,13244,13307,13332,13349,13377,13390,13420,13466,13476,13497,13501,13515,13554,13585,13612,13613,13685,13689,13771,13786,13790,13805,13817,13835,13882,13890,13900,13906,13953,13972,14002,14024,14038,14112,14113,14142,14143,14205,14223,14283,14285,14287,14370,14372,14382,14383,14386,14453,14457,14468,14481,14487,14529,14530,14540,14558,14571,14599,14610,14612,14625,14630,14642,14643,14657,14695,14697,14700,14721,14749,14754,14771,14775,14791,14816,14837,14845,14847,14852,14856,14873,14915,14960,14981,14983,14984,15003,15007,15010,15015,15035,15092,15111,15112,15117,15119,15129,15156,15177,15214,15231,15306,15335,15351,15372,15376,15393,15400,15406,15424,15475,15486,15501,15520,15522,15552,15561,15568,15581,15596,15600,15608,15655,15669,15672,15675,15689,15700,15704,15730,15755,15760,15778,15785,15790,15791,15812,15876,15880,15885,15888,15897,15965,16013,16058,16066,16095,16127,16208,16249,16250,16254,16282,16316,16324,16357,16365,16384,16417,16423,16427,16430,16439,16446,16447,16450,16516,16521,16542,16551,16622,16627,16644,16657,16672,16675,16687,16695,16724,16781,16783,16806,16814,16815,16816,16818,16821,16831,16839,16841,16843,16844,16866,16898,16921,16935,16942,16960,16985,17011,17047,17049,17084,17090,17098,17108,17116,17143,17153,17188,17190,17194,17201,17240,17246,17247,17272,17274,17278,17288,17289,17291,17292,17300,17331,17333,17343,17365,17366,17376,17386,17387,17410,17414,17417,17444,17452,17456,17487,17497,17514,17517,17518,17536,17540,17553,17561,17573,17575,17588,17598,17603,17630,17632,17664,17688,17711,17712,17725,17734,17736,17753,17762,17779,17783,17834,17838,17845,17850,17851,17862,17877,17887,17896,17907,17919,17922,17930,17936,17950,17955,17967,17983,17989,17990,17995,17996,18007,18044,18060,18061,18085,18088,18121,18136,18139,18180,18186,18222,18260,18278,18291,18295,18302,18309,18311,18351,18355,18382,18391,18395,18397,18428,18447,18450,18454,18463,18499,18516,18541,18549,18552,18571,18577,18626,18651,18652,18664,18666,18693,18706,18708,18712,18716,18724,18726,18728,18758,18770,18811,18830,18849,18877,18881,18882,18888,18905,18909,18944,18957,18982,18989,19003,19010,19015,19017,19031,19078,19105,19110,19114,19124,19128,19131,19138,19140,19145,19173,19220,19221,19231,19264,19265,19287,19311,19315,19330,19331,19334,19339,19348,19367,19375,19379,19381,19413,19415,19445,19460,19486,19488,19501,19506,19507,19517,19520,19531,19607,19623,19639,19644,19659,19667,19684,19710,19712,19725,19731,19733,19754,19771,19786,19794,19806,19807,19869,19881,19883,19917,19923,19929,19958,19960,19984,19987,19994,19996,20041,20056,20065,20067,20073,20088,20091,20095,20097,20098,20111,20119,20131,20143,20154,20156,20158,20168,20170,20175,20186,20200,20239,20258,20297,20312,20313,20314,20333,20345,20362,20366,20405,20411,20420,20445,20450,20457,20483,20515,20540,20542,20555,20594,20632,20638,20644,20654,20659,20666,20673,20692,20772,20777,20805,20829,20834,20835,20854,20874,20885,20888,20897,20914,20940,20959,20960,20976,21008,21009,21015,21055,21058,21065,21073,21078,21092,21104,21115,21116,21117,21118,21128,21143,21218,21228,21255,21266,21305,21307,21316,21321,21344,21367,21376,21388,21390,21398,21418,21421,21440,21449,21457,21463,21469,21470,21471,21495,21501,21520,21522,21540,21611,21613,21628,21629,21633,21663,21682,21684,21689,21693,21702,21707,21716,21720,21741,21764,21776,21778,21853,21879,21883,21906,21917,21924,21947,21956,21964,21968,21977,21997,22000,22003,22038,22067,22071,22075,22093,22100,22106,22119,22132,22138,22139,22154,22159,22178,22180,22207,22223,22268,22278,22282,22293,22298,22316,22344,22349,22365,22366,22395,22431,22442,22445,22450,22460,22462,22476,22491,22497,22525,22532,22555,22570,22596,22616,22619,22623,22641,22645,22653,22654,22661,22669,22689,22693,22700,22706,22709,22718,22746,22747,22748,22754,22759,22788,22799,22804,22820,22840,22863,22879,22890,22917,22930,22936,22944,22960,22977,23029,23034,23057,23071,23082,23087,23093,23112,23140,23144,23210,23236,23242,23252,23279,23302,23318,23332,23339,23356,23367,23368,23377,23404,23405,23409,23414,23430,23431,23438,23449,23490,23495,23498,23527,23539,23550,23553,23555,23577,23599,23622,23627,23639,23657,23665,23682,23691,23692,23693,23695,23698,23704,23716,23726,23727,23728,23739,23741,23743,23757,23772,23784,23787,23801,23816,23832,23836,23849,23880,23882,23884,23912,23955,23968,23970,23973,24065,24076,24100,24102,24115,24143,24159,24164,24167,24180,24182,24184,24187,24202,24215,24236,24237,24241,24261,24270,24283,24290,24361,24372,24402,24417,24457,24461,24465,24473,24475,24489,24530,24556,24577,24584,24619,24620,24649,24656,24659,24674,24690,24730,24751,24779,24780,24800,24805,24809,24815,24829,24841,24843,24850,24859,24868,24889,24912,24930,24946,24963,24979,24998,25003,25022,25029,25037,25062,25063,25069,25081,25096,25112,25116,25117,25155,25165,25180,25181,25192,25199,25217,25230,25280,25297,25329,25352,25358,25387,25416,25418,25441,25452,25462,25477,25523,25529,25530,25564,25589,25604,25606,25676,25683,25700,25701,25718,25730,25732,25746,25755,25801,25807,25853,25887,25911,25919,25926,25933,25971,26038,26039,26043,26048,26050,26053,26054,26060,26063,26117,26229,26258,26261,26298,26395,26467,26540,26541,26595,26596,26601,26659,26711,26715,26771,26807,26830,26854,26873,26897,26915,26930,26935,26959,26963,26977,27001,27003,27009,27039,27061,27062,27074,27094,27129,27158,27184,27221,27230,27259,27263,27271,27272,27283,27290,27303,27315,27327,27350,27392,27412,27435,27506,27516,27541,27552,27558,27559,27571,27577,27578,27634,27638,27646,27647,27655,27671,27707,27745,27772,27851,27870,27871,27898,27932,27949,27950,27955,27968,27975,27990,28066,28073,28094,28127,28213,28264,28280,28283,28324,28407,28464,28511,28532,28542,28546,28551,28569,28571,28606,28618,28654,28749,28826,28882,28892,28907,28908,28933,28949,28951,28972,28973,29049,29061,29073,29130,29140,29154,29171,29172,29194,29208,29326,29349,29437,29535,29539,29576,29610,29622,29642,29673,29719,29787,29911,29912,29923,29939,30133,30356,30449,30529,31286,32061,32840,32964,33080,33854,34502,34511,34629,34647,35103,35135,35366,35588,35684,35732,35834,35857,35886,35891,35922,35941,35971,35972,36003,36060,36092,36333,36364,36416,36420,36424,36427,36428,36441,36452,36469,36490,36551,36565,36616,36625,36629,36638,36654,36656,36695,36707,36761,36772,36802,36853,36855,36859,36875,36891,36894,36900,36934,37005,37086,37155,37192,37232,37283,37286,37308,37331,37346,37347,37348,37349,37350,37351,37359,37361,37371,37383,37391,37397,37399,37443,37470,37495,37501,37505,37507,37520,37557,37558,37560,37573,37576,37578,37618,37635,37645,37652,37692,37755,37780,37799,37820,37831,37833,37851,37858,37890,37894,37916,37959,38007,38011,38015,38016,38023,38031,38058,38083,38107,38113,38157,38160,38177,38185,38192,38222,38226,38236,38274,38288,38311,38350,38356,38366,38382,38401,38403,38432,38443,38456,38568,38622,38634,38689,38718,38765,38786,38814,38843,38855,38900,38978,38986,38995,39112,39131,39155,39172,39191,39194,39214,39217,39264,39295,39296,39330,39332,39334,39338,39339,39379,39424,39429,39442,39474,39490,39522,39550,39569,39596,39624,39649,39725,39758,39761,39773,39803,39855,39871,39873,39892,39981,39998,40004,40054,40073,40095,40166,40168,40226,40271,40333,40351,40379,40445,40446,40461,40483,40495,40496,40515,40534,40554,40593,40611,40629,40656,40674,40742,40746,40759,40789,40835,40993,41007,41025,41211,41339,42284,42486,42494,42833,43360,43543,45141,45240,45252)
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 | 1719 | 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.85 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.43 ms |
System lock | 0.02 ms |
optimizing | 0.16 ms |
statistics | 2.93 ms |
preparing | 1.32 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 |