Tiempo de la consulta: 9.93 ms Después de la última consulta: 1.12 ms Consulta a la memoria: 1.065 MB memoria antes de la consulta: 4.226 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-09 23:45:46')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 23:45:46')
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,14,57,60,66,67,78,81,94,109,117,120,126,127,136,137,167,180,195,200,201,204,216,226,239,241,265,278,303,304,305,306,316,317,340,354,358,368,374,377,390,446,463,493,495,515,519,549,579,584,592,593,599,621,635,673,728,731,737,740,741,742,771,791,804,812,821,825,841,853,855,871,878,891,908,928,931,947,954,955,1007,1018,1020,1029,1052,1085,1103,1140,1168,1187,1188,1200,1210,1229,1257,1264,1265,1287,1296,1298,1302,1313,1336,1338,1344,1354,1361,1367,1380,1381,1383,1391,1392,1402,1406,1413,1420,1421,1430,1433,1435,1441,1443,1461,1470,1478,1506,1507,1513,1524,1531,1532,1537,1558,1559,1568,1572,1579,1596,1598,1621,1634,1681,1682,1690,1691,1693,1695,1716,1719,1730,1731,1732,1738,1739,1756,1760,1782,1823,1873,1900,1901,1905,1915,1932,1954,2006,2082,2096,2122,2145,2147,2156,2178,2194,2207,2209,2229,2236,2245,2314,2315,2316,2332,2333,2342,2367,2373,2376,2410,2424,2425,2433,2453,2459,2463,2476,2481,2503,2511,2516,2524,2530,2564,2566,2579,2584,2594,2595,2598,2600,2628,2644,2660,2667,2695,2717,2720,2728,2740,2765,2817,2822,2823,2830,2870,2875,2894,2922,2926,2942,2963,2974,2975,3022,3024,3054,3063,3065,3073,3097,3112,3117,3126,3129,3137,3143,3163,3177,3187,3222,3235,3273,3290,3293,3327,3332,3350,3382,3388,3436,3457,3486,3506,3546,3550,3556,3574,3579,3582,3587,3589,3602,3634,3657,3675,3709,3780,3785,3796,3827,3840,3864,3930,3951,3979,3990,4008,4015,4066,4074,4111,4153,4305,4309,4335,4343,4357,4471,4488,4525,4560,4627,4631,4632,4654,4684,4688,4689,4691,4710,4718,4784,4792,4808,4841,4847,4853,4857,4871,4896,4902,4929,4949,4957,4971,4990,4992,4999,5016,5020,5040,5051,5063,5079,5086,5099,5104,5139,5150,5170,5173,5175,5180,5186,5281,5285,5323,5371,5378,5394,5431,5446,5449,5470,5511,5515,5555,5561,5566,5569,5572,5573,5579,5588,5594,5597,5622,5631,5632,5645,5650,5659,5662,5722,5726,5727,5729,5747,5799,5814,5822,5870,5969,6006,6010,6097,6121,6154,6173,6176,6178,6211,6215,6216,6217,6257,6264,6270,6272,6292,6348,6349,6354,6359,6363,6392,6403,6445,6446,6459,6482,6498,6568,6670,6675,6677,6695,6742,6802,6830,6836,6839,6847,6856,6873,6910,6915,6937,6975,7056,7082,7083,7086,7096,7099,7109,7110,7117,7121,7130,7132,7134,7168,7181,7209,7212,7213,7216,7243,7253,7273,7275,7284,7294,7299,7309,7328,7330,7334,7353,7374,7416,7466,7495,7526,7555,7584,7594,7659,7663,7670,7680,7717,7719,7745,7813,7834,7837,7839,7860,7866,7868,7932,7946,7958,7967,7970,7998,8036,8037,8056,8061,8071,8138,8199,8238,8249,8275,8276,8312,8330,8339,8347,8416,8427,8451,8462,8487,8494,8498,8521,8540,8569,8593,8594,8704,8773,8776,8781,8838,8846,8853,8983,9017,9018,9029,9148,9151,9191,9197,9201,9203,9223,9256,9322,9341,9475,9511,9560,9574,9650,9658,9682,9749,9806,9818,9839,9858,9942,9993,10009,10078,10079,10099,10112,10141,10149,10165,10229,10255,10261,10262,10308,10315,10340,10345,10348,10400,10471,10476,10483,10595,10604,10645,10665,10673,10691,10708,10764,10775,10811,10856,10860,10956,10970,11029,11030,11112,11163,11241,11285,11292,11305,11349,11439,11441,11476,11547,11603,11626,11692,11859,11864,11967,11994,11996,12012,12060,12083,12095,12116,12128,12181,12210,12219,12225,12310,12364,12385,12428,12499,12595,12619,12620,12622,12623,12625,12630,12633,12654,12677,12703,12705,12717,12718,12752,12760,12768,12771,12800,12807,12815,12887,12889,12894,12925,12945,12957,12962,13002,13010,13036,13045,13074,13078,13079,13152,13188,13248,13254,13268,13277,13328,13452,13468,13473,13509,13535,13575,13576,13681,13735,13748,13759,13782,13783,13846,13868,13900,13924,13938,13941,13959,14005,14047,14048,14181,14203,14204,14229,14293,14321,14327,14350,14356,14386,14404,14430,14447,14457,14468,14516,14537,14542,14564,14570,14592,14608,14648,14663,14669,14679,14733,14852,14942,14948,14973,14987,15019,15021,15110,15179,15200,15201,15262,15293,15298,15304,15321,15347,15372,15386,15408,15421,15473,15482,15495,15517,15519,15530,15550,15650,15651,15657,15662,15751,15753,15756,15784,15825,15839,15850,15947,15948,16119,16122,16197,16214,16249,16347,16370,16421,16423,16426,16440,16455,16519,16526,16537,16580,16654,16689,16720,16763,16802,16812,16816,16865,16891,16894,16904,16917,17002,17133,17148,17169,17185,17194,17198,17229,17234,17291,17317,17334,17335,17379,17409,17412,17458,17479,17501,17520,17529,17584,17603,17615,17619,17640,17646,17662,17700,17789,17790,17799,17826,17851,17862,17869,17921,17947,17949,17960,17965,17996,18028,18060,18084,18097,18106,18110,18122,18127,18129,18158,18170,18212,18213,18264,18277,18284,18286,18301,18309,18321,18362,18380,18433,18447,18490,18516,18538,18549,18571,18580,18596,18618,18626,18630,18675,18690,18707,18726,18739,18753,18770,18780,18801,18843,18845,18852,18974,18994,18999,19028,19031,19039,19040,19052,19098,19127,19130,19134,19150,19153,19178,19184,19192,19204,19219,19235,19252,19260,19325,19335,19358,19370,19389,19426,19429,19445,19454,19483,19487,19492,19501,19527,19555,19574,19586,19617,19659,19676,19731,19741,19750,19767,19772,19791,19811,19816,19834,19898,19966,19972,20003,20024,20030,20039,20042,20045,20059,20066,20067,20068,20092,20111,20120,20122,20183,20195,20239,20248,20250,20252,20256,20262,20271,20279,20384,20386,20437,20443,20469,20500,20526,20528,20565,20566,20570,20590,20592,20609,20627,20642,20648,20667,20670,20681,20688,20700,20750,20792,20800,20804,20888,20894,20944,20945,20964,20984,20990,21115,21136,21163,21182,21188,21196,21198,21202,21229,21243,21266,21279,21321,21327,21329,21332,21340,21366,21375,21390,21393,21404,21405,21421,21454,21459,21467,21487,21490,21508,21521,21653,21711,21721,21722,21726,21735,21756,21761,21767,21769,21774,21811,21824,21853,21870,21891,21899,21932,21958,21961,22005,22082,22129,22132,22156,22162,22172,22175,22253,22257,22262,22267,22385,22409,22466,22481,22499,22525,22623,22647,22726,22736,22753,22797,22865,22914,22924,22970,22979,23037,23041,23099,23104,23119,23123,23132,23168,23176,23184,23213,23218,23228,23254,23257,23268,23309,23332,23426,23491,23504,23554,23598,23604,23620,23628,23632,23675,23704,23722,23751,23805,23813,23815,23817,23886,23887,23888,23890,23891,23893,23897,23899,23901,23904,23905,23907,23921,23922,23926,23927,23964,23981,23983,23986,23991,24000,24029,24032,24039,24040,24095,24160,24175,24193,24197,24294,24337,24361,24368,24413,24429,24478,24496,24503,24587,24589,24678,24679,24703,24782,24799,24857,24911,24982,24989,25100,25104,25109,25233,25331,25336,25458,25475,25505,25557,25602,25685,25687,25690,25694,25758,25844,25863,25891,25909,25959,25981,26062,26127,26136,26204,26226,26306,26335,26340,26369,26386,26509,26520,26530,26630,26659,26673,26680,26731,26745,26784,26802,26866,26920,26990,26996,27023,27065,27183,27184,27199,27208,27340,27354,27449,27450,27551,27616,27806,27808,27903,28198,28218,28366,28545,28601,28636,28836,29002,30486,30700,31640,32352,33929,34699,35000,35095,35153,35585,35750,35778,35865,35891,36051,36130,36196,36267,36292,36299,36341,36591,36594,36598,36604,36697,36769,36917,37083,38542,38563,38610,38613,38628,38652,38777,38946,38971,39041,39171,39225,39483,39571,39590,39682,39790,39821,39883,40172,40270,40385,40386,40387,40456,40548,40742,40983,40987,41068,41298,41442,41625,41683,41703,41815,41998,42310,42602,43018,43425,43426,44798,44811,44870,44897,44898,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 | 1296 | 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.61 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.27 ms |
System lock | 0.02 ms |
optimizing | 0.09 ms |
statistics | 1.87 ms |
preparing | 1.00 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 5.05 ms |
end | 0.02 ms |
query end | 0.03 ms |
closing tables | 0.02 ms |
freeing items | 0.11 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 |