Tiempo de la consulta: 13.66 ms Después de la última consulta: 1.59 ms Consulta a la memoria: 1.065 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 04:48:41')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 04:48:41')
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(7,49,60,66,74,75,76,77,81,85,94,110,113,114,117,120,126,136,150,155,167,174,180,201,204,207,208,214,216,252,265,279,285,303,304,305,306,316,317,340,349,353,354,368,377,389,390,435,443,450,463,493,495,506,515,519,530,531,547,549,572,584,592,593,621,635,666,667,693,719,728,731,740,741,742,744,760,777,791,808,825,831,841,855,863,869,885,891,908,914,931,942,954,955,976,986,1007,1020,1029,1052,1101,1102,1103,1168,1179,1187,1188,1207,1215,1216,1229,1257,1265,1273,1278,1279,1287,1296,1298,1302,1313,1336,1338,1344,1352,1354,1367,1380,1392,1402,1406,1413,1420,1421,1430,1433,1435,1441,1443,1459,1463,1470,1478,1506,1507,1524,1531,1532,1537,1538,1558,1567,1568,1572,1598,1648,1681,1695,1700,1709,1716,1719,1739,1751,1823,1846,1860,1867,1898,1905,1932,1990,2031,2096,2144,2145,2147,2150,2178,2182,2188,2194,2204,2207,2209,2219,2229,2235,2236,2241,2242,2243,2245,2261,2278,2284,2285,2314,2315,2316,2319,2328,2332,2333,2342,2353,2373,2376,2396,2402,2410,2453,2459,2476,2481,2503,2511,2516,2524,2528,2564,2579,2594,2627,2631,2644,2647,2658,2660,2666,2695,2713,2720,2728,2765,2770,2817,2830,2840,2870,2894,2901,2902,2926,2942,2954,2967,2979,2991,3013,3063,3065,3071,3073,3106,3107,3112,3117,3126,3129,3137,3143,3163,3166,3174,3187,3198,3222,3227,3235,3236,3249,3280,3293,3327,3347,3369,3382,3388,3390,3402,3409,3412,3414,3420,3436,3442,3454,3457,3486,3546,3556,3574,3577,3579,3582,3587,3602,3657,3663,3668,3675,3709,3796,3814,3827,3840,3864,3870,3979,4004,4015,4074,4153,4184,4231,4309,4319,4335,4343,4378,4476,4488,4503,4525,4589,4631,4632,4654,4684,4688,4689,4691,4718,4784,4808,4823,4841,4847,4871,4902,4949,4971,4999,5016,5020,5051,5099,5100,5180,5275,5323,5378,5396,5431,5439,5461,5470,5471,5478,5536,5566,5569,5572,5579,5588,5594,5597,5608,5615,5632,5645,5647,5650,5659,5662,5722,5726,5727,5729,5747,5822,5846,5857,5870,5913,5975,5998,6006,6010,6020,6039,6101,6120,6138,6174,6178,6217,6272,6292,6298,6348,6349,6354,6359,6363,6392,6445,6565,6568,6577,6616,6639,6665,6670,6675,6677,6684,6694,6821,6876,6975,6989,7001,7012,7056,7082,7083,7086,7096,7099,7110,7122,7124,7138,7181,7189,7205,7212,7246,7262,7265,7269,7275,7280,7282,7288,7291,7293,7299,7300,7309,7311,7330,7334,7387,7402,7403,7410,7439,7454,7466,7478,7486,7495,7546,7554,7555,7614,7626,7680,7719,7720,7736,7818,7836,7837,7839,7841,7860,7861,7868,7890,7897,7914,7924,7932,7935,7946,7965,7970,7991,7998,8027,8037,8046,8054,8061,8071,8090,8107,8108,8116,8118,8134,8158,8177,8199,8220,8275,8276,8339,8345,8451,8498,8540,8569,8593,8704,8754,8773,8776,8781,8796,8828,8853,8864,8983,9029,9087,9091,9148,9191,9201,9223,9239,9322,9364,9404,9428,9475,9650,9688,9818,9834,9836,9839,9841,9916,9942,10009,10073,10078,10079,10092,10110,10117,10120,10181,10193,10202,10217,10255,10261,10307,10308,10318,10322,10340,10345,10348,10369,10370,10399,10402,10415,10444,10453,10475,10478,10486,10502,10534,10595,10630,10665,10673,10682,10708,10775,10798,10799,10801,11030,11031,11035,11037,11059,11094,11142,11188,11235,11237,11241,11267,11439,11441,11472,11505,11563,11603,11626,11632,11692,11726,11779,11865,11922,11967,12060,12070,12081,12116,12128,12133,12166,12181,12219,12223,12225,12243,12385,12401,12410,12465,12520,12595,12610,12620,12622,12623,12625,12630,12637,12677,12705,12708,12717,12718,12752,12760,12846,12853,12873,12875,12894,12907,12925,12945,12957,13002,13006,13010,13017,13035,13036,13041,13078,13124,13137,13248,13259,13294,13298,13390,13466,13473,13497,13611,13671,13676,13687,13707,13723,13759,13771,13790,13805,13817,13835,13842,13906,13953,13959,13975,14005,14024,14047,14048,14092,14105,14113,14142,14143,14167,14181,14204,14205,14223,14229,14250,14267,14271,14273,14279,14283,14285,14293,14350,14370,14391,14426,14445,14447,14456,14457,14468,14481,14491,14513,14516,14529,14530,14534,14536,14538,14542,14550,14558,14570,14571,14592,14625,14646,14657,14683,14684,14695,14697,14700,14706,14707,14749,14754,14771,14775,14852,14923,14984,14987,15004,15010,15030,15032,15035,15037,15104,15167,15206,15231,15247,15301,15321,15372,15382,15403,15408,15411,15424,15439,15475,15486,15492,15495,15522,15530,15542,15552,15562,15575,15581,15599,15651,15655,15704,15712,15717,15728,15730,15742,15757,15778,15782,15839,15850,15866,15876,15897,15965,16013,16058,16140,16158,16161,16206,16214,16249,16250,16254,16257,16282,16305,16316,16317,16324,16347,16370,16417,16421,16423,16430,16458,16459,16497,16516,16523,16534,16537,16542,16543,16580,16625,16652,16657,16664,16675,16687,16695,16724,16763,16783,16839,16929,16936,16942,17000,17002,17084,17125,17138,17148,17153,17185,17201,17215,17240,17273,17274,17278,17288,17289,17291,17300,17323,17331,17333,17347,17358,17363,17365,17379,17386,17401,17414,17432,17435,17458,17472,17501,17529,17540,17542,17553,17562,17575,17596,17598,17615,17640,17646,17649,17659,17664,17688,17702,17707,17712,17729,17753,17757,17766,17783,17799,17818,17831,17850,17851,17854,17869,17887,17921,17922,17947,17950,17955,17960,17961,17995,17996,18034,18060,18110,18121,18122,18127,18158,18212,18277,18278,18284,18286,18291,18301,18309,18311,18316,18321,18326,18351,18369,18380,18384,18391,18397,18419,18428,18433,18442,18490,18498,18516,18541,18543,18549,18552,18555,18571,18577,18580,18596,18612,18626,18630,18639,18651,18673,18682,18687,18689,18690,18693,18694,18706,18724,18739,18770,18780,18811,18830,18837,18847,18848,18849,18869,18873,18901,18910,18920,18969,18984,18991,18994,18997,18999,19022,19028,19052,19083,19086,19105,19108,19111,19130,19138,19139,19145,19171,19178,19184,19185,19199,19207,19219,19220,19240,19247,19274,19294,19304,19325,19335,19366,19370,19379,19383,19386,19389,19396,19419,19442,19445,19453,19454,19460,19492,19501,19517,19524,19531,19535,19552,19555,19567,19574,19604,19617,19634,19650,19659,19661,19669,19681,19700,19708,19731,19733,19739,19754,19820,19867,19869,19898,19929,19932,19958,19960,19971,19972,19984,19991,19993,19996,20003,20007,20024,20036,20053,20058,20059,20065,20067,20091,20097,20099,20103,20111,20120,20154,20162,20168,20183,20186,20195,20199,20200,20216,20248,20250,20252,20256,20271,20279,20281,20297,20303,20329,20333,20354,20366,20374,20403,20405,20411,20440,20443,20446,20464,20500,20536,20540,20555,20578,20579,20590,20609,20632,20649,20659,20666,20667,20681,20768,20800,20805,20814,20817,20848,20885,20888,20945,20950,20955,20960,21009,21055,21058,21104,21106,21115,21116,21128,21161,21163,21178,21228,21229,21242,21252,21266,21305,21316,21321,21340,21388,21390,21393,21398,21418,21431,21433,21452,21458,21459,21463,21467,21490,21495,21505,21508,21516,21520,21522,21531,21536,21540,21611,21676,21682,21709,21711,21721,21733,21735,21751,21774,21819,21853,21870,21906,21912,21924,21947,21961,21977,21988,22000,22003,22005,22059,22061,22082,22093,22132,22139,22154,22175,22180,22244,22245,22246,22257,22258,22262,22267,22349,22385,22395,22414,22419,22423,22483,22497,22500,22502,22525,22527,22552,22563,22572,22596,22612,22616,22647,22653,22661,22693,22708,22709,22718,22736,22742,22744,22746,22799,22804,22805,22820,22829,22834,22874,22895,22924,22963,22979,23034,23041,23071,23073,23081,23087,23112,23124,23132,23140,23144,23168,23187,23236,23242,23252,23256,23279,23300,23302,23332,23339,23408,23449,23467,23498,23527,23529,23550,23555,23565,23577,23592,23598,23599,23665,23675,23682,23688,23691,23693,23698,23716,23722,23727,23743,23759,23763,23784,23787,23814,23816,23817,23836,23839,23845,23849,23857,23874,23889,23900,23907,23912,23922,23926,23930,23941,23955,23962,23967,23970,23977,24014,24065,24072,24076,24102,24117,24141,24159,24174,24175,24193,24204,24236,24260,24264,24270,24275,24282,24283,24311,24361,24372,24402,24413,24417,24454,24457,24461,24472,24473,24475,24478,24513,24577,24603,24618,24624,24649,24656,24686,24692,24703,24730,24738,24745,24751,24799,24800,24809,24823,24850,24859,24888,24907,24924,24930,24943,24960,24968,24979,24989,25003,25048,25063,25067,25069,25070,25071,25093,25096,25100,25106,25112,25115,25126,25155,25165,25180,25192,25245,25331,25336,25352,25358,25360,25387,25416,25418,25458,25462,25475,25477,25557,25564,25589,25624,25636,25672,25673,25678,25685,25687,25690,25694,25701,25818,25887,25891,25917,25925,25926,25955,25981,26030,26043,26062,26063,26105,26122,26135,26162,26204,26226,26258,26288,26306,26369,26386,26453,26454,26509,26520,26530,26540,26541,26630,26659,26665,26680,26711,26731,26772,26779,26802,26807,26808,26898,26910,26924,26930,26939,26996,27001,27018,27024,27026,27039,27094,27131,27151,27183,27184,27186,27199,27221,27251,27263,27271,27327,27354,27356,27435,27452,27490,27506,27520,27545,27593,27597,27609,27616,27738,27777,27806,27808,27871,27902,27949,27968,27975,27990,28005,28218,28366,28367,28452,28464,28497,28511,28601,28605,28606,28636,28720,28845,28892,28907,28908,28933,28949,28951,28972,28973,29002,29049,29140,29143,29171,29194,29208,29349,29369,29535,29569,29576,29622,29642,29673,29720,29890,29911,29912,29923,29939,30449,30486,31286,31640,33356,34699,35095,35144,35153,35369,35548,35562,35585,35663,35750,35778,35865,35878,35950,36051,36060,36130,36153,36196,36241,36267,36292,36299,36341,36383,36396,36534,36591,36594,36598,36604,36639,36769,36822,36836,36875,36893,36937,37005,37083,37455,38426,38610,38613,38652,38775,38777,38836,38890,38900,38946,38960,38966,38971,38986,39041,39131,39171,39172,39225,39269,39329,39406,39483,39571,39590,39682,39790,39814,39821,39858,39936,39938,39966,39995,40040,40079,40212,40213,40243,40317,40351,40385,40386,40387,40456,40622,40742,40759,40867,40983,40993,41068,41211,41298,41442,41515,42310,42456,42602,42971,43018,43155,43425,43426,43898,43907,43980,44291,44369,44370,44874,44906,45018,45038,45039,45040,45041,45042,45043,45227)
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 | 1706 | 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.89 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.38 ms |
System lock | 0.02 ms |
optimizing | 0.12 ms |
statistics | 2.66 ms |
preparing | 1.35 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 7.37 ms |
end | 0.03 ms |
query end | 0.06 ms |
closing tables | 0.03 ms |
freeing items | 0.18 ms |
cleaning up | 0.05 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 |