Tiempo de la consulta: 14.08 ms Después de la última consulta: 1.14 ms Consulta a la memoria: 1.065 MB memoria antes de la consulta: 4.403 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-05 16:41:44')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 16:41:44')
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,12,55,57,60,66,78,81,94,110,115,117,119,120,126,131,151,167,180,200,201,204,216,240,252,263,265,266,303,304,305,306,316,317,340,354,368,377,384,390,431,435,443,463,493,495,506,515,519,547,549,579,584,592,593,599,621,635,663,673,693,719,728,731,737,740,741,742,757,760,764,767,777,791,821,825,836,841,855,891,908,931,947,954,955,1007,1020,1029,1052,1103,1140,1168,1178,1187,1188,1204,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,1461,1463,1470,1478,1495,1501,1506,1507,1524,1531,1532,1537,1558,1567,1568,1572,1598,1641,1681,1695,1706,1716,1719,1725,1730,1731,1732,1739,1769,1782,1823,1898,1901,1905,1932,1990,2006,2096,2144,2145,2150,2178,2182,2192,2194,2201,2202,2204,2207,2209,2219,2222,2229,2232,2235,2236,2241,2242,2243,2245,2246,2249,2261,2278,2285,2295,2299,2314,2315,2316,2319,2332,2333,2342,2353,2373,2376,2396,2409,2410,2453,2459,2463,2476,2481,2503,2511,2516,2524,2530,2550,2552,2564,2566,2579,2594,2627,2631,2636,2644,2658,2666,2682,2694,2695,2715,2717,2720,2728,2765,2770,2817,2830,2894,2926,2942,2967,3063,3065,3073,3112,3117,3126,3129,3135,3137,3143,3163,3166,3167,3187,3222,3232,3235,3293,3327,3347,3382,3388,3414,3436,3457,3486,3546,3556,3574,3579,3582,3587,3602,3657,3675,3709,3796,3797,3801,3827,3840,3864,3931,3932,3979,3986,4015,4066,4074,4153,4204,4229,4233,4254,4309,4335,4343,4354,4488,4525,4631,4632,4654,4684,4688,4689,4691,4718,4784,4808,4841,4847,4871,4902,4949,4971,4999,5016,5020,5051,5085,5099,5180,5275,5323,5371,5378,5394,5431,5446,5449,5470,5471,5511,5556,5566,5569,5572,5579,5588,5594,5597,5615,5631,5632,5645,5650,5659,5662,5722,5726,5727,5729,5731,5747,5822,5833,5870,5890,5998,6006,6010,6020,6101,6102,6154,6217,6257,6272,6292,6348,6349,6354,6359,6363,6384,6392,6403,6445,6501,6565,6568,6655,6670,6675,6677,6690,6694,6802,6836,6975,6989,7056,7070,7082,7086,7096,7099,7109,7110,7124,7132,7138,7168,7181,7205,7212,7216,7234,7243,7265,7266,7269,7275,7284,7288,7293,7299,7300,7309,7312,7326,7328,7330,7334,7335,7466,7495,7555,7629,7680,7689,7719,7774,7837,7839,7860,7868,7932,7935,7946,7970,7991,7993,7998,8037,8061,8071,8085,8199,8275,8276,8339,8345,8451,8498,8540,8569,8593,8594,8704,8713,8773,8776,8781,8828,8846,8853,8983,9029,9148,9151,9191,9201,9223,9239,9322,9428,9432,9472,9475,9511,9606,9650,9682,9746,9806,9818,9834,9839,9942,9953,10009,10078,10079,10130,10202,10229,10255,10261,10308,10340,10345,10348,10384,10502,10595,10665,10673,10708,10758,10775,10881,10912,11029,11030,11031,11035,11106,11142,11232,11241,11316,11345,11349,11389,11439,11441,11521,11547,11603,11626,11640,11692,11967,12012,12060,12116,12128,12166,12181,12210,12219,12223,12225,12283,12385,12428,12440,12499,12595,12620,12622,12623,12625,12630,12633,12654,12677,12705,12717,12718,12752,12760,12768,12769,12815,12835,12894,12925,12945,12957,12990,13002,13010,13040,13078,13248,13277,13345,13448,13473,13494,13611,13735,13759,13838,13893,13959,14005,14047,14048,14181,14204,14229,14279,14293,14307,14350,14356,14382,14391,14401,14404,14445,14447,14450,14457,14468,14481,14491,14507,14516,14517,14529,14534,14536,14538,14542,14550,14560,14564,14570,14573,14592,14660,14683,14707,14839,14852,14903,14942,14969,14987,15018,15019,15076,15158,15321,15372,15374,15378,15408,15495,15519,15530,15599,15651,15657,15756,15774,15839,15850,15948,16077,16119,16149,16214,16249,16347,16362,16364,16370,16416,16421,16423,16426,16476,16486,16490,16501,16523,16537,16543,16546,16551,16580,16763,16795,16891,16904,17002,17115,17117,17138,17148,17167,17185,17229,17291,17379,17458,17501,17529,17542,17562,17607,17615,17633,17640,17646,17649,17688,17707,17712,17729,17797,17799,17851,17869,17921,17941,17943,17947,17960,17996,18032,18060,18097,18102,18107,18110,18122,18127,18144,18156,18158,18212,18277,18284,18286,18301,18309,18321,18337,18360,18369,18379,18386,18388,18433,18442,18469,18479,18486,18490,18516,18549,18571,18580,18618,18630,18638,18687,18690,18694,18711,18770,18780,18837,18839,18843,18847,18969,18994,18997,18999,19028,19031,19052,19130,19134,19178,19184,19219,19260,19304,19325,19335,19357,19370,19383,19389,19416,19419,19435,19437,19445,19454,19492,19501,19555,19574,19617,19634,19659,19731,19811,19836,19898,19919,19966,19971,19972,19993,20003,20024,20034,20036,20058,20059,20065,20067,20083,20103,20111,20116,20120,20195,20248,20250,20252,20256,20271,20279,20281,20443,20500,20590,20609,20642,20648,20667,20681,20800,20814,20888,20945,20947,20955,21020,21106,21115,21129,21136,21163,21202,21229,21266,21305,21321,21340,21375,21393,21395,21398,21421,21459,21467,21490,21508,21521,21711,21721,21735,21738,21753,21774,21853,21870,21961,21969,22005,22071,22082,22101,22132,22175,22257,22262,22267,22286,22359,22382,22385,22395,22414,22417,22419,22423,22525,22546,22622,22647,22688,22736,22820,22834,22898,22913,22966,22979,23041,23073,23132,23168,23279,23332,23367,23376,23380,23444,23477,23592,23598,23620,23634,23665,23675,23684,23693,23716,23719,23722,23817,23833,23907,23922,23926,23932,23954,23970,23978,23991,24013,24016,24024,24060,24175,24178,24193,24236,24270,24272,24275,24302,24321,24361,24379,24413,24454,24478,24603,24620,24672,24692,24703,24771,24799,24989,25081,25093,25100,25102,25106,25121,25310,25331,25332,25336,25343,25352,25386,25402,25458,25475,25557,25560,25636,25657,25664,25672,25685,25687,25690,25694,25807,25818,25891,25981,26030,26062,26127,26159,26193,26204,26213,26226,26239,26288,26303,26306,26369,26386,26431,26451,26453,26456,26509,26520,26530,26573,26629,26630,26659,26673,26680,26697,26709,26723,26731,26741,26778,26802,26859,26892,26920,26924,26960,26969,27018,27023,27025,27028,27044,27058,27070,27079,27181,27183,27184,27199,27354,27431,27521,27597,27616,27738,27763,27806,27808,28218,28336,28349,28366,28367,28457,28461,28472,28496,28499,28601,28620,28636,28747,28755,28836,29002,29241,29534,29569,29588,29591,29810,30486,30939,31172,31430,31640,33081,34569,34699,35013,35095,35153,35207,35256,35369,35548,35562,35585,35595,35750,35778,35865,35878,35934,35950,36051,36060,36130,36153,36196,36241,36267,36292,36299,36317,36341,36383,36396,36534,36591,36594,36598,36604,36639,36700,36768,36769,36866,36937,36942,37005,37083,37110,37138,37190,37455,37587,37739,37908,37913,38082,38275,38312,38418,38426,38519,38610,38613,38652,38718,38760,38766,38777,38836,38867,38878,38890,38946,38971,39033,39041,39048,39122,39171,39225,39263,39336,39371,39387,39406,39453,39483,39529,39544,39571,39590,39595,39601,39656,39682,39790,39806,39821,39890,39902,39917,39928,39931,39936,39938,39978,39995,40002,40014,40036,40079,40091,40162,40223,40324,40385,40386,40387,40398,40456,40726,40742,40797,40867,40964,40983,41002,41026,41034,41047,41068,41298,41399,41442,41507,41515,41721,41808,41977,42184,42250,42310,42317,42434,42455,42456,42532,42602,42803,42971,43018,43119,43258,43276,43425,43426,43466,43472,43703,43842,43898,43907,43912,43978,43980,43981,43996,44080,44289,44493,44722,44903,44906,45004,45005,45009,45018,45023,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 | 1261 | 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.81 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.37 ms |
System lock | 0.02 ms |
optimizing | 0.16 ms |
statistics | 3.13 ms |
preparing | 1.37 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 7.48 ms |
end | 0.02 ms |
query end | 0.04 ms |
closing tables | 0.02 ms |
freeing items | 0.19 ms |
cleaning up | 0.09 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 |