Tiempo de la consulta: 10.00 ms Después de la última consulta: 1.20 ms Consulta a la memoria: 1.080 MB memoria antes de la consulta: 4.365 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 03:03:06')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 03:03:06')
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,11,43,49,57,58,60,66,78,81,83,94,117,120,121,126,137,147,148,149,150,151,152,153,154,155,167,180,201,216,265,281,297,304,305,306,316,317,340,354,362,368,377,385,389,390,398,437,458,463,492,493,495,515,519,522,549,584,592,593,621,635,686,728,731,740,741,742,752,784,791,799,803,813,825,841,844,855,868,891,908,931,954,955,956,963,970,980,986,1007,1018,1020,1029,1052,1053,1091,1103,1139,1168,1185,1186,1187,1188,1207,1229,1233,1257,1265,1277,1287,1296,1298,1302,1313,1318,1336,1338,1344,1354,1364,1367,1371,1380,1392,1402,1406,1413,1420,1421,1428,1430,1433,1435,1440,1441,1443,1461,1470,1478,1503,1506,1507,1524,1531,1532,1537,1541,1556,1558,1568,1572,1598,1601,1649,1673,1681,1690,1695,1719,1782,1817,1823,1827,1835,1905,1932,2000,2096,2110,2115,2145,2178,2194,2207,2209,2229,2236,2245,2314,2315,2316,2332,2333,2342,2357,2373,2376,2410,2453,2458,2459,2476,2481,2503,2511,2516,2524,2540,2564,2579,2584,2594,2644,2695,2713,2720,2728,2729,2735,2765,2817,2827,2830,2857,2870,2896,2922,2926,2939,2942,2957,2964,3020,3033,3040,3063,3073,3112,3117,3126,3129,3137,3143,3163,3177,3187,3209,3210,3222,3235,3257,3293,3322,3327,3332,3382,3388,3397,3436,3457,3478,3486,3519,3546,3556,3567,3574,3579,3582,3587,3602,3657,3675,3692,3709,3759,3796,3827,3838,3840,3864,3881,3934,3979,3986,4013,4015,4019,4074,4076,4153,4281,4309,4335,4343,4371,4405,4453,4488,4525,4631,4632,4654,4670,4684,4688,4689,4690,4691,4693,4715,4718,4745,4784,4808,4841,4847,4856,4857,4871,4896,4902,4949,4971,4999,5016,5020,5051,5052,5053,5099,5180,5233,5285,5300,5323,5378,5431,5470,5525,5566,5569,5572,5579,5588,5594,5597,5632,5633,5645,5650,5659,5662,5710,5722,5726,5727,5729,5747,5822,5827,5840,5870,5894,5933,6006,6010,6047,6051,6094,6176,6203,6211,6217,6231,6267,6272,6283,6284,6292,6348,6349,6354,6359,6362,6363,6392,6422,6438,6445,6453,6484,6501,6567,6568,6619,6633,6654,6675,6677,6725,6726,6744,6749,6785,6802,6825,6832,6905,6911,6955,6971,6975,7002,7056,7082,7086,7096,7099,7101,7110,7175,7181,7212,7216,7219,7225,7275,7285,7296,7299,7309,7328,7334,7435,7456,7466,7495,7544,7555,7584,7670,7678,7680,7688,7710,7719,7766,7797,7806,7823,7837,7839,7849,7858,7860,7863,7868,7932,7946,7951,7970,7998,8027,8037,8061,8071,8141,8169,8183,8189,8199,8200,8204,8205,8223,8236,8245,8246,8247,8250,8275,8276,8315,8320,8339,8355,8380,8401,8426,8451,8471,8498,8521,8537,8540,8547,8565,8569,8571,8593,8602,8626,8630,8663,8679,8704,8757,8773,8776,8781,8816,8838,8839,8845,8853,8877,8888,8912,8918,8921,8952,8983,8986,9029,9058,9131,9136,9148,9158,9164,9183,9191,9201,9223,9242,9282,9305,9322,9389,9401,9442,9475,9487,9507,9564,9626,9650,9752,9818,9839,9842,9864,9942,9962,10009,10017,10078,10079,10144,10187,10206,10239,10261,10264,10308,10315,10317,10340,10345,10348,10375,10376,10392,10425,10491,10535,10561,10595,10596,10611,10644,10665,10673,10708,10741,10775,10779,10860,10896,10905,10907,10938,10939,10948,10952,10953,10970,10975,10991,11030,11037,11059,11060,11074,11075,11091,11093,11120,11165,11186,11207,11241,11252,11255,11285,11292,11343,11361,11371,11419,11439,11441,11491,11603,11611,11626,11629,11648,11661,11692,11729,11737,11738,11739,11770,11789,11800,11896,11924,11938,11967,12002,12060,12081,12082,12094,12116,12118,12128,12165,12181,12219,12223,12225,12283,12301,12326,12339,12356,12364,12384,12385,12398,12482,12511,12513,12526,12595,12620,12622,12623,12625,12630,12705,12717,12718,12752,12758,12760,12811,12850,12894,12925,12945,12957,13002,13010,13056,13061,13078,13100,13110,13125,13150,13152,13153,13207,13217,13248,13377,13473,13476,13481,13519,13554,13585,13613,13635,13665,13685,13759,13894,13900,13959,14002,14005,14033,14038,14047,14048,14107,14140,14181,14189,14194,14204,14205,14229,14287,14293,14350,14382,14386,14401,14468,14516,14540,14542,14570,14591,14592,14610,14612,14631,14642,14643,14698,14725,14768,14791,14829,14847,14852,14865,14873,14911,14915,14960,14987,14999,15003,15038,15063,15094,15117,15119,15158,15171,15177,15187,15233,15259,15270,15321,15346,15361,15372,15400,15407,15408,15418,15429,15469,15487,15495,15501,15516,15530,15596,15608,15651,15742,15755,15778,15791,15833,15839,15850,15863,15875,15888,15937,15981,15987,16024,16043,16056,16066,16090,16129,16155,16211,16214,16249,16281,16323,16338,16347,16359,16365,16370,16421,16423,16438,16439,16446,16447,16450,16524,16537,16547,16561,16564,16571,16580,16593,16622,16626,16644,16668,16689,16708,16717,16763,16806,16814,16815,16816,16818,16831,16840,16844,16863,16866,16898,16935,16951,16985,17002,17011,17047,17067,17086,17090,17108,17143,17148,17185,17190,17194,17242,17247,17253,17273,17282,17287,17291,17292,17360,17376,17379,17410,17417,17452,17456,17458,17487,17490,17501,17509,17514,17518,17529,17536,17539,17572,17588,17618,17630,17640,17646,17659,17701,17725,17727,17734,17759,17782,17799,17818,17826,17838,17845,17851,17853,17869,17879,17887,17893,17896,17920,17921,17934,17947,17960,17989,17990,18022,18074,18083,18088,18110,18122,18127,18136,18139,18158,18173,18186,18212,18219,18220,18277,18284,18286,18301,18309,18311,18321,18351,18352,18380,18433,18447,18450,18490,18516,18549,18571,18572,18580,18630,18648,18690,18696,18708,18716,18770,18780,18866,18880,18881,18882,18909,18911,18953,18957,18989,18994,18999,19004,19014,19017,19028,19031,19052,19060,19063,19114,19130,19131,19145,19155,19178,19184,19217,19219,19221,19231,19283,19297,19308,19311,19325,19330,19335,19339,19367,19370,19389,19407,19413,19445,19454,19457,19482,19492,19501,19520,19555,19574,19583,19591,19617,19641,19644,19648,19672,19718,19731,19733,19747,19854,19881,19883,19898,19972,20003,20015,20041,20056,20059,20067,20095,20111,20120,20127,20156,20158,20170,20179,20195,20239,20248,20250,20252,20256,20271,20279,20289,20333,20345,20362,20420,20443,20450,20457,20483,20500,20522,20590,20607,20609,20615,20644,20654,20664,20667,20681,20710,20737,20800,20854,20888,20945,20947,21067,21079,21115,21126,21128,21163,21187,21218,21223,21229,21255,21266,21270,21297,21307,21321,21323,21340,21372,21376,21393,21449,21459,21467,21490,21496,21508,21555,21628,21689,21707,21716,21720,21721,21735,21757,21774,21853,21870,21879,21956,21961,21964,21987,22005,22011,22040,22071,22075,22082,22089,22100,22132,22138,22175,22257,22306,22316,22344,22359,22385,22445,22484,22525,22619,22623,22647,22654,22669,22689,22736,22753,22909,22917,22930,22935,22936,22974,22976,22979,23011,23041,23057,23132,23139,23168,23221,23242,23332,23377,23398,23414,23430,23431,23439,23456,23525,23555,23562,23585,23598,23602,23627,23657,23675,23722,23726,23728,23741,23761,23801,23817,23826,23853,23882,23884,23907,23910,23922,23926,23936,23958,23973,24034,24100,24143,24175,24182,24184,24193,24220,24326,24361,24364,24413,24429,24478,24489,24526,24556,24577,24619,24620,24668,24703,24799,24849,24868,24912,24941,24975,24989,24998,25070,25071,25081,25153,25280,25310,25331,25332,25336,25352,25441,25458,25475,25535,25557,25653,25676,25685,25687,25690,25694,25747,25785,25891,25921,25981,26008,26038,26048,26050,26062,26204,26226,26298,26358,26367,26369,26386,26444,26509,26520,26530,26583,26595,26630,26659,26680,26698,26731,26771,26802,26915,26963,26977,26978,27002,27009,27024,27055,27082,27101,27183,27184,27199,27218,27354,27412,27616,27806,27808,27898,28075,28218,28366,28601,28636,29002,29141,29372,29378,29617,29618,30486,31115,31640,32676,34699,35095,35135,35153,35366,35585,35588,35744,35750,35778,35834,35857,35865,35882,35886,35891,35922,35972,36051,36130,36196,36267,36292,36299,36341,36364,36591,36594,36598,36604,36707,36769,37083,37576,37851,38610,38613,38652,38777,38855,38946,38971,39041,39112,39171,39225,39483,39571,39590,39682,39773,39790,39821,39857,40203,40356,40385,40386,40387,40456,40483,40742,40789,40835,40983,41025,41068,41298,41442,42284,42310,42494,42602,42833,43018,43360,43425,43426,43543,44906,45141,45227,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 | 1400 | 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.72 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.27 ms |
System lock | 0.02 ms |
optimizing | 0.12 ms |
statistics | 2.09 ms |
preparing | 1.04 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 4.88 ms |
end | 0.02 ms |
query end | 0.04 ms |
closing tables | 0.03 ms |
freeing items | 0.12 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 |