Tiempo de la consulta: 7.86 ms Después de la última consulta: 1.51 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.391 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-08 08:30:36')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-08 08:30:36')
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(9,11,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,78,81,87,88,89,91,95,100,103,110,111,112,125,167,188,189,190,200,204,205,234,246,248,249,263,271,325,353,354,356,357,358,359,360,361,362,363,364,365,382,390,412,415,416,420,421,422,423,424,426,427,429,431,435,443,460,477,484,496,500,501,503,506,523,531,547,574,575,593,605,607,655,686,693,719,723,725,756,757,760,777,785,853,862,868,965,986,1002,1020,1045,1067,1075,1080,1090,1120,1143,1147,1168,1198,1207,1214,1223,1308,1313,1324,1336,1353,1357,1367,1386,1434,1463,1567,1718,1745,1878,1898,1990,2105,2108,2144,2150,2182,2204,2208,2209,2219,2235,2241,2242,2261,2272,2278,2319,2322,2353,2396,2590,2627,2630,2631,2632,2641,2666,2688,2729,2770,2825,2858,2902,2939,2964,2967,2983,3020,3025,3039,3051,3065,3067,3087,3166,3169,3176,3212,3294,3320,3325,3347,3414,3442,3463,3650,3673,3682,3725,3761,3901,3925,3984,4090,4095,4100,4131,4227,4310,4337,4378,4392,4422,4476,4631,4674,4765,4874,4902,4905,4930,5060,5136,5182,5189,5275,5302,5324,5373,5392,5451,5471,5476,5538,5579,5597,5615,5639,5647,5649,5659,5685,5694,5713,5719,5729,5731,5798,5800,5819,5894,5895,5934,5998,6020,6043,6050,6055,6066,6081,6097,6101,6127,6147,6178,6264,6270,6272,6298,6311,6318,6329,6330,6332,6340,6347,6350,6376,6388,6392,6420,6427,6442,6455,6456,6460,6462,6465,6468,6471,6473,6482,6492,6494,6497,6499,6500,6502,6515,6516,6517,6520,6534,6541,6545,6546,6565,6568,6572,6573,6601,6603,6608,6616,6645,6654,6656,6658,6659,6665,6666,6670,6671,6690,6694,6711,6718,6727,6749,6762,6776,6779,6788,6805,6806,6809,6827,6836,6847,6854,6868,6869,6872,6879,6882,6889,6910,6914,6915,6916,6939,6942,6945,6975,6989,6990,6995,7017,7026,7043,7045,7050,7056,7102,7109,7122,7124,7125,7134,7135,7139,7150,7154,7155,7156,7158,7160,7161,7170,7171,7173,7176,7178,7179,7181,7191,7201,7205,7210,7212,7213,7241,7243,7246,7247,7249,7265,7267,7268,7269,7270,7275,7277,7279,7282,7283,7284,7285,7286,7287,7288,7289,7293,7294,7298,7300,7304,7305,7308,7313,7327,7328,7330,7332,7333,7334,7335,7344,7346,7347,7365,7367,7368,7370,7371,7372,7374,7376,7377,7378,7379,7380,7387,7389,7401,7402,7406,7407,7408,7410,7411,7413,7414,7415,7417,7418,7419,7427,7428,7430,7431,7435,7436,7447,7450,7453,7457,7458,7459,7461,7462,7464,7465,7469,7488,7489,7494,7495,7513,7514,7523,7545,7546,7552,7553,7555,7567,7570,7577,7578,7583,7587,7615,7627,7629,7674,7677,7678,7681,7682,7683,7686,7689,7690,7691,7692,7708,7713,7715,7716,7718,7720,7722,7730,7741,7743,7744,7746,7749,7753,7757,7758,7768,7780,7782,7804,7806,7808,7810,7811,7831,7833,7834,7835,7836,7841,7855,7862,7863,7864,7866,7871,7891,7894,7895,7900,7901,7918,7919,7920,7923,7928,7930,7933,7935,7940,7950,7955,7957,7960,7961,7962,7963,7965,7970,7979,7982,7986,7987,7993,7994,8017,8020,8021,8022,8026,8027,8028,8048,8049,8056,8061,8064,8067,8070,8071,8072,8073,8082,8090,8093,8103,8109,8111,8134,8139,8140,8215,8289,8311,8330,8338,8345,8391,8399,8444,8533,8565,8589,8602,8610,8638,8666,8808,8823,8828,8835,8856,8887,8974,9029,9206,9262,9282,9308,9318,9411,9428,9472,9478,9616,9650,9677,9678,9759,9826,9834,9886,9924,10004,10023,10035,10078,10197,10199,10226,10239,10255,10263,10265,10274,10314,10345,10349,10379,10380,10399,10415,10416,10502,10503,10534,10553,10560,10572,10600,10601,10665,10686,10738,10768,10811,10835,10964,10980,10989,11001,11029,11031,11099,11126,11152,11191,11192,11204,11219,11226,11229,11231,11265,11320,11345,11446,11523,11542,11548,11581,11592,11678,11754,11806,11835,11849,11948,11954,12013,12020,12024,12031,12078,12116,12125,12166,12171,12184,12224,12259,12309,12324,12340,12358,12367,12385,12423,12460,12474,12499,12520,12546,12563,12571,12605,12609,12620,12625,12650,12670,12685,12686,12708,12737,12791,12856,12872,12902,12913,12973,12996,13014,13016,13067,13140,13152,13294,13344,13348,13350,13444,13474,13475,13488,13516,13542,13566,13571,13602,13615,13618,13645,13653,13656,13685,13759,13806,13861,13866,13874,13900,13902,13916,13917,13971,13973,13990,14000,14005,14052,14074,14084,14110,14152,14195,14205,14219,14227,14229,14243,14249,14269,14280,14292,14293,14349,14357,14362,14371,14386,14391,14401,14445,14447,14481,14483,14487,14508,14529,14534,14536,14537,14538,14550,14554,14591,14638,14653,14665,14682,14683,14685,14693,14707,14749,14754,14818,14830,14837,14844,14846,14849,14860,14935,14947,15038,15039,15043,15065,15079,15174,15224,15244,15245,15253,15261,15268,15278,15293,15298,15353,15372,15382,15414,15475,15476,15490,15494,15520,15533,15574,15579,15599,15606,15717,15739,15796,15835,15861,15885,15896,15899,15925,15939,15945,15953,15954,15972,16022,16031,16040,16048,16055,16062,16071,16091,16101,16115,16156,16161,16163,16176,16230,16257,16286,16337,16339,16386,16414,16472,16497,16523,16526,16541,16543,16566,16621,16646,16723,16751,16790,16808,16809,16816,16818,16823,16826,16833,16854,16908,16943,16950,16964,16976,16998,17069,17090,17092,17114,17132,17138,17158,17187,17224,17230,17234,17290,17307,17309,17321,17334,17335,17343,17361,17391,17419,17426,17442,17496,17500,17501,17528,17542,17562,17571,17607,17611,17615,17629,17630,17649,17679,17688,17702,17707,17708,17721,17729,17735,17738,17763,17777,17783,17817,17839,17857,17869,17882,17947,17948,17966,17991,18009,18071,18073,18079,18122,18142,18161,18176,18216,18220,18226,18227,18253,18260,18264,18279,18295,18297,18300,18308,18309,18317,18332,18360,18369,18380,18388,18401,18406,18409,18424,18494,18512,18520,18522,18554,18558,18578,18598,18653,18663,18687,18694,18695,18700,18701,18718,18744,18757,18775,18819,18822,18837,18861,18864,18904,18908,18912,18969,18982,18995,18997,19010,19018,19022,19048,19049,19086,19110,19170,19174,19181,19183,19213,19222,19282,19304,19367,19381,19383,19388,19404,19419,19426,19449,19460,19462,19496,19507,19551,19581,19624,19634,19650,19652,19657,19661,19668,19677,19695,19702,19715,19733,19772,19774,19825,19826,19851,19856,19858,19886,19913,19921,19923,19931,19937,19947,19971,19973,19980,20001,20024,20026,20036,20060,20065,20079,20095,20114,20180,20184,20192,20193,20194,20213,20217,20232,20277,20287,20304,20308,20354,20370,20439,20440,20459,20467,20486,20488,20500,20525,20529,20546,20564,20567,20579,20595,20609,20616,20626,20632,20647,20648,20670,20699,20700,20716,20727,20736,20749,20786,20792,20803,20814,20847,20865,20919,20944,20955,20986,20988,21004,21011,21016,21038,21049,21106,21116,21123,21151,21158,21159,21167,21183,21252,21256,21259,21263,21272,21273,21279,21283,21285,21288,21294,21300,21301,21327,21338,21366,21368,21376,21394,21413,21416,21419,21427,21436,21464,21472,21485,21486,21493,21510,21524,21526,21529,21534,21556,21566,21575,21588,21589,21614,21618,21623,21633,21648,21650,21659,21661,21664,21690,21695,21696,21704,21719,21721,21727,21732,21735,21753,21800,21824,21843,21850,21884,21888,21910,21913,21924,21954,21955,21990,21999,22009,22015,22018,22038,22049,22062,22071,22077,22100,22117,22137,22163,22164,22174,22178,22195,22206,22208,22230,22234,22241,22251,22262,22263,22266,22267,22283,22298,22302,22324,22343,22362,22406,22412,22414,22419,22421,22423,22446,22453,22476,22496,22512,22518,22528,22550,22555,22580,22603,22614,22620,22622,22626,22655,22658,22669,22682,22696,22710,22713,22726,22727,22735,22743,22747,22765,22780,22787,22804,22820,22829,22833,22834,22835,22883,22897,22900,22923,22947,22959,22972,22974,22979,22989,23007,23023,23024,23043,23062,23063,23072,23073,23082,23089,23118,23121,23124,23179,23214,23240,23249,23300,23308,23335,23355,23371,23378,23428,23430,23437,23446,23476,23480,23528,23542,23546,23586,23616,23631,23648,23665,23676,23693,23716,23719,23806,23825,23863,23882,23898,23927,23951,23970,23996,24015,24016,24021,24033,24099,24135,24140,24162,24211,24226,24237,24249,24275,24279,24329,24362,24393,24408,24409,24475,24484,24505,24522,24538,24563,24582,24603,24617,24650,24706,24709,24721,24742,24754,24756,24764,24774,24790,24803,24832,24842,24846,24862,24874,24879,24883,24937,24953,24956,24983,24993,24996,25030,25035,25048,25062,25076,25081,25087,25093,25105,25106,25120,25131,25137,25138,25142,25171,25175,25188,25221,25225,25255,25276,25288,25318,25322,25330,25335,25351,25369,25372,25383,25406,25436,25448,25471,25486,25487,25497,25510,25512,25514,25539,25542,25584,25636,25646,25648,25660,25672,25675,25764,25790,25809,25813,25821,25859,25864,25904,25949,25955,26000,26030,26033,26043,26074,26117,26134,26139,26147,26203,26204,26221,26240,26288,26317,26343,26360,26366,26415,26424,26431,26454,26456,26469,26474,26480,26541,26603,26634,26639,26651,26677,26709,26713,26742,26769,26801,26820,26845,26881,26905,26907,26923,26924,26944,26973,27000,27018,27038,27057,27143,27170,27262,27366,27372,27406,27530,27563,27571,27644,27677,27688,27722,27738,27846,27985,28072,28080,28115,28120,28163,28256,28339,28367,28440,28442,28465,28614,28615,28616,28627,28662,28673,28680,28681,28682,28683,28702,28710,28712,28728,28781,28844,28845,28847,28944,29054,29064,29133,29142,29359,29379,29382,29405,29406,29417,29444,29460,29569,29571,29578,29635,29646,29655,29727,29759,29853,30050,30318,30325,30790,32502,33349,33417,35330,35369,35548,35562,35653,35713,35741,35744,35878,35950,35955,36060,36153,36241,36323,36383,36396,36534,36639,36937,37005,37455,37981,38426,38730,38836,38890,39088,39398,39406,39530,39936,39938,39995,40036,40079,40116,40492,40583,40605,40867,40983,41515,42009,42036,42456,42971,43898,43907,43980,44509,45008,45018,45038,45039,45040,45041,45042,45043,45100)
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 | 1679 | 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 | 1.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.06 ms |
init | 0.35 ms |
System lock | 0.02 ms |
optimizing | 0.15 ms |
statistics | 3.45 ms |
preparing | 1.71 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.52 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.06 ms |
freeing items | 0.08 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 |