Tiempo de la consulta: 9.08 ms Después de la última consulta: 1.08 ms Consulta a la memoria: 1.065 MB memoria antes de la consulta: 4.347 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-07 23:56:06')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 23:56: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,49,60,66,71,78,81,90,92,94,96,97,98,99,102,104,107,117,120,126,167,180,198,199,201,209,210,216,217,226,228,232,234,238,240,242,243,259,265,276,281,304,305,306,316,317,329,340,354,368,377,390,419,428,463,466,487,493,495,515,519,522,523,549,584,592,593,605,607,621,635,637,728,731,740,741,742,791,825,841,855,891,904,908,931,948,954,955,966,1007,1020,1029,1031,1052,1067,1103,1168,1187,1188,1209,1223,1229,1257,1265,1287,1296,1298,1302,1313,1336,1338,1344,1354,1367,1380,1392,1402,1406,1413,1420,1421,1430,1433,1435,1441,1443,1470,1478,1506,1507,1524,1531,1532,1537,1558,1568,1572,1598,1681,1695,1698,1719,1814,1823,1825,1845,1905,1932,1943,1957,2054,2096,2145,2156,2178,2194,2207,2209,2229,2236,2245,2314,2315,2316,2332,2333,2342,2368,2373,2376,2410,2453,2459,2476,2481,2503,2511,2516,2524,2564,2579,2594,2611,2644,2695,2720,2728,2729,2765,2817,2822,2830,2926,2942,3020,3058,3063,3073,3112,3117,3126,3129,3137,3143,3163,3187,3222,3235,3293,3327,3332,3350,3382,3388,3436,3457,3486,3546,3556,3574,3579,3582,3587,3602,3657,3675,3709,3796,3827,3840,3864,3979,4015,4074,4153,4309,4335,4343,4488,4525,4631,4632,4654,4684,4688,4689,4691,4718,4784,4808,4841,4847,4871,4902,4949,4971,4999,5016,5020,5051,5099,5125,5180,5323,5371,5378,5431,5470,5566,5569,5572,5579,5588,5594,5597,5622,5632,5645,5647,5649,5650,5659,5662,5685,5722,5726,5727,5729,5747,5822,5847,5870,6006,6010,6163,6217,6264,6272,6292,6348,6349,6354,6359,6363,6385,6386,6392,6445,6518,6568,6675,6677,6760,6839,6847,6881,6915,6975,6984,7017,7056,7082,7086,7096,7099,7110,7181,7212,7275,7299,7309,7334,7466,7495,7555,7624,7680,7719,7772,7837,7839,7860,7868,7928,7932,7946,7958,7967,7970,7998,8037,8056,8061,8062,8070,8071,8199,8275,8276,8320,8339,8354,8451,8498,8540,8569,8593,8704,8773,8776,8781,8844,8853,8983,9003,9029,9148,9191,9201,9223,9322,9475,9579,9650,9683,9724,9818,9839,9924,9942,9989,10009,10031,10078,10079,10100,10261,10289,10308,10323,10340,10345,10348,10436,10581,10595,10665,10673,10708,10775,10889,10956,11030,11163,11241,11439,11441,11603,11626,11692,11911,11946,11967,12060,12095,12116,12128,12177,12181,12219,12223,12225,12385,12412,12595,12620,12622,12623,12625,12630,12679,12705,12717,12718,12752,12760,12887,12894,12913,12925,12945,12957,12973,13002,13010,13062,13078,13231,13248,13276,13321,13398,13405,13471,13473,13681,13750,13759,13800,13868,13959,13969,14005,14029,14034,14047,14048,14156,14181,14203,14204,14218,14224,14229,14263,14293,14350,14356,14457,14468,14516,14542,14570,14581,14592,14852,14987,15021,15039,15110,15170,15179,15188,15198,15262,15298,15321,15347,15366,15372,15408,15418,15421,15470,15473,15482,15495,15511,15517,15530,15550,15573,15630,15651,15667,15759,15784,15811,15835,15839,15850,16120,16165,16213,16214,16249,16263,16347,16352,16365,16370,16421,16423,16488,16532,16537,16580,16622,16720,16763,16812,16826,16894,16983,17002,17045,17063,17142,17148,17154,17185,17236,17275,17291,17317,17334,17379,17409,17453,17458,17501,17506,17519,17520,17521,17529,17611,17619,17624,17640,17646,17710,17799,17851,17858,17862,17869,17921,17947,17949,17960,17965,18052,18106,18110,18115,18122,18124,18127,18133,18158,18181,18212,18213,18277,18284,18286,18291,18301,18309,18321,18336,18351,18362,18380,18426,18433,18458,18465,18490,18509,18516,18538,18549,18571,18580,18588,18630,18674,18675,18690,18707,18726,18753,18770,18780,18801,18823,18845,18846,18852,18956,18958,18994,18999,19024,19028,19040,19052,19057,19098,19130,19150,19178,19184,19219,19245,19252,19259,19263,19312,19325,19335,19353,19358,19369,19370,19389,19402,19445,19454,19483,19484,19492,19501,19515,19527,19551,19555,19574,19582,19617,19676,19722,19731,19772,19791,19816,19837,19883,19898,19939,19943,19963,19972,20003,20004,20039,20059,20067,20092,20111,20120,20122,20183,20195,20216,20248,20250,20252,20256,20269,20271,20279,20290,20296,20301,20343,20386,20408,20420,20434,20443,20492,20497,20500,20526,20528,20539,20573,20590,20592,20609,20617,20667,20670,20681,20688,20792,20800,20804,20881,20888,20894,20907,20944,20945,20964,20982,20984,21002,21080,21115,21163,21182,21229,21259,21266,21300,21307,21319,21321,21340,21393,21404,21454,21459,21467,21490,21508,21631,21679,21721,21735,21767,21774,21853,21870,21891,21958,21960,21961,22005,22032,22082,22085,22132,22156,22162,22172,22175,22189,22239,22253,22257,22267,22339,22344,22361,22363,22385,22409,22466,22481,22499,22525,22544,22547,22558,22564,22611,22647,22654,22694,22695,22726,22736,22753,22781,22814,22865,22871,22958,22973,22979,23003,23010,23036,23041,23074,23096,23099,23104,23119,23132,23168,23184,23203,23218,23230,23235,23254,23264,23268,23292,23304,23332,23371,23381,23391,23415,23455,23460,23475,23483,23523,23554,23555,23585,23598,23604,23619,23632,23675,23719,23722,23805,23813,23817,23854,23893,23897,23901,23905,23907,23909,23922,23926,23947,23964,23986,24000,24007,24092,24160,24175,24193,24197,24209,24226,24238,24294,24303,24339,24352,24361,24376,24413,24429,24478,24496,24503,24526,24585,24598,24615,24663,24678,24679,24703,24711,24741,24764,24772,24782,24799,24861,24918,24934,24984,24989,24992,25005,25062,25079,25089,25151,25232,25244,25287,25303,25331,25336,25368,25375,25401,25432,25458,25475,25480,25507,25557,25613,25637,25649,25685,25687,25690,25694,25716,25730,25863,25891,25918,25949,25956,25981,26047,26062,26118,26131,26184,26204,26221,26226,26283,26369,26386,26443,26509,26520,26530,26625,26630,26659,26673,26680,26699,26731,26732,26802,26884,26900,26925,26940,26971,26978,26990,27109,27118,27126,27143,27171,27183,27184,27199,27232,27354,27405,27430,27550,27616,27806,27808,28030,28121,28218,28366,28601,28636,28718,28825,29002,29063,29155,29297,29926,29943,30083,30273,30483,30484,30486,30808,31136,31447,31640,32107,33612,33653,33689,33705,33749,33877,34453,34454,34455,34699,34846,34875,35000,35016,35095,35153,35584,35713,35744,35750,35778,35832,35846,35865,35892,35960,36051,36063,36130,36181,36196,36267,36292,36299,36315,36341,36387,36394,36538,36591,36594,36598,36604,36646,36657,36661,36665,36715,36739,36769,36770,36784,36794,36953,37000,37045,37083,37279,37336,37861,38075,38087,38094,38191,38256,38381,38610,38613,38652,38777,38946,38971,39041,39099,39108,39171,39225,39320,39381,39483,39571,39590,39682,39790,39821,39887,40045,40061,40076,40086,40113,40310,40382,40385,40386,40387,40451,40456,40463,40492,40532,40578,40707,40742,40770,40830,40983,41049,41067,41068,41133,41213,41298,41307,41441,41442,41477,41509,41579,41621,41679,41799,41872,41974,41975,42192,42310,42584,42602,42661,43018,43425,43426,44906,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 | 1163 | 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.55 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.21 ms |
System lock | 0.02 ms |
optimizing | 0.08 ms |
statistics | 1.78 ms |
preparing | 0.86 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 4.02 ms |
end | 0.02 ms |
query end | 0.03 ms |
closing tables | 0.02 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 |