Tiempo de la consulta: 5.20 ms Después de la última consulta: 1.20 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 4.219 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 14:07:27')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 14:07:27')
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(4,21,43,83,137,185,197,259,260,263,281,287,316,362,368,374,394,398,416,522,563,621,697,728,752,770,784,825,931,963,980,1223,1230,1286,1296,1318,1344,1348,1364,1371,1428,1440,1461,1462,1496,1503,1538,1540,1541,1549,1556,1601,1649,1660,1673,1690,1714,1718,1782,1804,1823,1827,1870,2000,2110,2115,2207,2258,2305,2332,2357,2540,2631,2632,2641,2643,2657,2688,2720,2728,2729,2735,2765,2870,2896,2902,2922,2939,2957,3025,3033,3040,3067,3087,3117,3176,3177,3257,3294,3319,3332,3375,3397,3427,3478,3567,3574,3575,3725,3759,3838,3847,3881,3899,3925,3934,4015,4019,4025,4090,4095,4100,4131,4194,4227,4337,4339,4371,4386,4392,4468,4473,4493,4601,4612,4613,4614,4615,4617,4674,4677,4690,4693,4745,4816,4825,4856,4876,4896,4930,4959,4982,5052,5053,5138,5199,5233,5285,5299,5398,5431,5461,5515,5530,5633,5639,5659,5694,5710,5713,5719,5729,5800,5814,5819,5827,5840,5850,5855,5857,5933,5934,5973,5996,6043,6047,6050,6051,6055,6066,6071,6081,6094,6097,6127,6159,6164,6176,6178,6203,6211,6264,6267,6270,6272,6283,6284,6298,6329,6330,6332,6340,6347,6350,6372,6376,6388,6422,6427,6438,6442,6445,6453,6455,6456,6460,6462,6465,6468,6470,6471,6473,6492,6494,6497,6499,6500,6501,6502,6515,6517,6520,6534,6545,6546,6567,6568,6582,6601,6603,6608,6616,6619,6645,6654,6656,6658,6659,6690,6711,6718,6739,6744,6749,6762,6776,6779,6788,6802,6805,6806,6809,6825,6827,6832,6847,6868,6869,6872,6879,6882,6889,6910,6914,6915,6916,6942,6945,6976,6990,6995,7002,7043,7045,7102,7122,7125,7134,7135,7138,7150,7154,7155,7156,7160,7161,7170,7171,7173,7175,7176,7178,7179,7201,7212,7213,7215,7218,7219,7225,7231,7232,7234,7241,7243,7246,7249,7267,7268,7270,7277,7279,7282,7283,7285,7289,7319,7327,7328,7330,7333,7334,7344,7346,7364,7367,7368,7370,7371,7372,7374,7376,7377,7378,7379,7380,7389,7396,7406,7407,7408,7410,7411,7413,7414,7415,7416,7417,7418,7422,7427,7428,7430,7431,7435,7436,7447,7450,7455,7456,7457,7458,7459,7461,7462,7463,7464,7465,7469,7486,7488,7489,7494,7495,7513,7514,7523,7540,7545,7546,7552,7553,7555,7565,7567,7570,7577,7578,7583,7584,7615,7625,7647,7659,7670,7674,7677,7681,7682,7683,7686,7689,7690,7691,7708,7713,7715,7720,7722,7726,7735,7743,7744,7746,7749,7757,7758,7766,7768,7780,7799,7804,7806,7808,7810,7823,7830,7831,7833,7834,7835,7836,7841,7849,7851,7855,7862,7863,7864,7866,7871,7891,7894,7895,7900,7901,7918,7919,7920,7923,7928,7930,7940,7951,7955,7957,7960,7961,7962,7963,7966,7970,7979,7982,7987,7991,7993,7994,7998,8017,8020,8021,8022,8023,8024,8026,8028,8037,8048,8049,8056,8064,8067,8070,8071,8072,8073,8082,8090,8103,8109,8111,8129,8134,8139,8140,8141,8169,8183,8189,8204,8205,8223,8236,8245,8246,8247,8269,8289,8311,8315,8320,8330,8353,8355,8380,8401,8426,8471,8521,8537,8565,8569,8571,8602,8626,8630,8667,8669,8698,8757,8808,8816,8834,8838,8839,8845,8877,8888,8912,8921,8952,8968,8983,8986,9056,9058,9059,9131,9136,9158,9164,9218,9253,9263,9303,9308,9344,9351,9401,9442,9478,9487,9564,9568,9576,9590,9658,9672,9731,9741,9752,9759,9818,9826,9842,9881,9907,9996,10004,10017,10144,10186,10187,10197,10199,10205,10243,10265,10268,10315,10317,10340,10349,10375,10376,10379,10387,10392,10399,10400,10491,10522,10534,10553,10560,10561,10596,10600,10612,10673,10796,10803,10811,10835,10860,10896,10938,10939,10948,10953,10970,10975,10991,11037,11060,11071,11074,11075,11093,11099,11120,11126,11165,11176,11186,11192,11226,11229,11231,11252,11255,11285,11292,11343,11361,11371,11404,11458,11491,11548,11581,11592,11611,11626,11629,11648,11661,11729,11737,11738,11739,11789,11792,11800,11849,11864,11938,11967,12002,12013,12024,12081,12082,12094,12118,12171,12184,12219,12226,12283,12302,12326,12332,12339,12340,12356,12358,12364,12377,12384,12435,12441,12474,12488,12499,12500,12511,12513,12520,12526,12527,12609,12617,12649,12708,12752,12811,12880,12897,12925,12944,12978,12992,13002,13056,13110,13125,13150,13152,13153,13154,13207,13217,13298,13319,13325,13327,13375,13377,13476,13554,13585,13586,13613,13656,13667,13685,13731,13734,13775,13900,13908,14002,14038,14052,14084,14110,14212,14250,14287,14349,14357,14366,14382,14386,14402,14421,14431,14453,14457,14468,14505,14540,14596,14610,14612,14642,14643,14653,14680,14682,14685,14713,14749,14770,14791,14818,14847,14849,14865,14873,14892,14915,14946,14947,14960,14973,14974,15003,15015,15039,15046,15065,15117,15119,15177,15227,15244,15253,15293,15298,15318,15400,15464,15501,15505,15533,15594,15596,15608,15673,15682,15689,15742,15755,15778,15791,15797,15808,15835,15874,15888,15902,15916,15925,15954,16031,16055,16066,16101,16103,16156,16172,16240,16257,16365,16410,16423,16439,16440,16446,16447,16450,16520,16584,16622,16644,16667,16674,16806,16814,16815,16818,16823,16826,16831,16844,16854,16866,16898,16907,16935,16964,16985,16994,17011,17047,17055,17080,17090,17108,17143,17158,17190,17194,17247,17291,17292,17335,17344,17376,17410,17417,17452,17456,17476,17487,17514,17518,17536,17588,17590,17607,17630,17725,17734,17763,17824,17838,17845,17857,17883,17887,17896,17941,17989,17990,17991,17999,18066,18088,18136,18139,18150,18186,18203,18220,18227,18235,18311,18317,18351,18353,18401,18409,18442,18447,18469,18482,18490,18505,18512,18558,18576,18663,18695,18701,18708,18712,18716,18730,18735,18744,18770,18881,18882,18905,18909,18957,18989,19017,19031,19048,19049,19101,19114,19130,19131,19145,19170,19183,19192,19213,19221,19222,19243,19260,19311,19327,19330,19339,19367,19413,19426,19472,19484,19520,19533,19542,19586,19644,19651,19772,19851,19858,19881,19883,19933,19947,19967,20041,20056,20066,20067,20095,20111,20156,20158,20170,20188,20191,20239,20283,20289,20345,20362,20385,20420,20450,20457,20483,20486,20557,20592,20632,20644,20654,20670,20683,20708,20792,20854,20885,20888,21112,21115,21132,21154,21218,21229,21255,21259,21273,21294,21295,21300,21307,21327,21366,21375,21376,21413,21449,21453,21500,21566,21588,21602,21614,21624,21628,21689,21696,21707,21716,21720,21843,21884,21913,21924,21952,21956,21964,21990,22009,22033,22038,22071,22075,22100,22116,22132,22137,22138,22230,22262,22289,22290,22316,22344,22362,22444,22445,22525,22550,22584,22602,22614,22619,22623,22654,22669,22689,22693,22853,22886,22914,22917,22930,22936,22959,22989,23023,23057,23099,23107,23121,23123,23176,23214,23229,23308,23332,23364,23371,23377,23414,23431,23437,23542,23627,23631,23657,23725,23726,23728,23729,23741,23801,23849,23882,23884,23885,23949,23973,24015,24051,24062,24100,24140,24143,24162,24175,24182,24184,24185,24211,24223,24237,24279,24329,24362,24409,24439,24489,24526,24538,24556,24595,24619,24620,24650,24736,24738,24764,24774,24785,24834,24846,24862,24912,24915,24956,24983,24998,25076,25137,25178,25225,25255,25294,25328,25335,25369,25372,25441,25510,25512,25538,25555,25648,25873,25941,25995,26000,26024,26038,26048,26074,26203,26298,26359,26386,26409,26579,26595,26609,26646,26659,26771,26820,26831,26845,26915,26963,26968,27126,27134,27175,27184,27344,27347,27353,27354,27412,27445,27455,27480,27490,27492,27512,27563,27604,27605,27630,27749,27783,27789,27806,27808,27809,27898,28115,28336,28441,28468,28483,28545,28562,28577,28673,28777,28829,28846,28902,28979,28982,28999,29077,29091,29127,29142,29214,29223,29293,29359,29382,29405,29444,29655,29759,30194,30269,30325,30988,31798,31853,33416,33417,34944,35135,35366,35574,35588,35639,35640,35643,35653,35684,35710,35741,35744,35752,35834,35857,35886,35891,35922,35926,35972,36075,36208,36267,36364,36427,36581,36584,36707,36901,37576,37759,37851,37925,38362,38651,38689,38855,38912,39112,39224,39240,39600,39773,40483,40789,40822,40835,41025,41148,41171,42036,42284,42494,42833,43360,43412,43543,44509,45071,45072,45141,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 | 1364 | 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.03 ms |
init | 0.26 ms |
System lock | 0.02 ms |
optimizing | 0.09 ms |
statistics | 2.11 ms |
preparing | 1.05 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.32 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.06 ms |
cleaning up | 0.02 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 |