Tiempo de la consulta: 4.76 ms Después de la última consulta: 1.01 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.350 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:14:11')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 14:14:11')
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(2,9,11,263,308,353,354,356,357,358,359,360,361,363,364,460,477,500,655,686,723,756,757,965,1020,1045,1067,1080,1090,1120,1143,1198,1207,1214,1308,1324,1336,1386,1410,1718,1745,1917,2105,2198,2261,2322,2482,2537,2591,2630,2725,2776,2858,2939,2953,2964,2983,3039,3090,3169,3198,3218,3223,3278,3294,3341,3384,3442,3463,3468,3503,3522,3526,3543,3570,3577,3637,3672,3673,3706,3761,3814,3838,3864,3910,3912,3984,3997,4002,4030,4078,4090,4114,4120,4168,4236,4239,4244,4257,4315,4325,4331,4337,4346,4347,4378,4417,4422,4499,4578,4643,4760,4778,4780,4789,4874,4894,4915,4940,4975,4987,5005,5115,5136,5152,5182,5187,5210,5211,5229,5252,5274,5302,5304,5315,5350,5373,5386,5407,5433,5442,5451,5536,5579,5597,5647,5652,5659,5729,5731,5798,5816,5842,5851,5854,5894,5962,5979,6062,6102,6164,6230,6247,6274,6337,6350,6361,6419,6486,6516,6541,6567,6573,6584,6601,6619,6645,6647,6665,6690,6714,6715,6721,6727,6776,6854,6925,6939,6948,7026,7031,7135,7138,7139,7142,7143,7165,7166,7187,7191,7217,7218,7284,7311,7320,7349,7359,7364,7365,7380,7387,7391,7401,7402,7419,7451,7453,7509,7539,7561,7603,7627,7629,7664,7718,7730,7736,7737,7741,7753,7769,7787,7818,7825,7827,7848,7880,7950,7964,7965,7973,7986,8010,8014,8019,8027,8036,8041,8065,8067,8090,8093,8123,8163,8171,8177,8207,8219,8259,8263,8264,8270,8311,8318,8338,8379,8388,8400,8422,8455,8466,8469,8492,8496,8509,8519,8520,8523,8563,8576,8599,8600,8607,8623,8625,8638,8664,8666,8698,8727,8736,8756,8767,8785,8789,8857,8862,8867,8896,8919,8934,8949,8967,8971,8974,8980,9005,9020,9029,9050,9070,9080,9082,9128,9137,9138,9145,9159,9165,9194,9212,9214,9249,9250,9295,9297,9310,9311,9318,9347,9357,9363,9365,9382,9384,9435,9445,9448,9457,9467,9471,9503,9504,9549,9555,9568,9585,9594,9606,9608,9610,9616,9670,9676,9690,9702,9710,9774,9827,9829,9886,9892,9893,9907,9924,9950,9959,9963,10023,10060,10078,10089,10108,10116,10117,10149,10154,10170,10183,10187,10196,10208,10226,10233,10236,10239,10263,10268,10277,10278,10294,10314,10321,10342,10343,10345,10380,10401,10416,10435,10454,10489,10498,10503,10512,10522,10525,10567,10572,10580,10601,10654,10665,10686,10738,10748,10754,10768,10846,10903,10961,10964,10980,10983,10989,11001,11029,11065,11073,11091,11119,11148,11149,11152,11167,11191,11204,11219,11265,11275,11307,11318,11320,11335,11344,11403,11422,11446,11491,11503,11523,11542,11607,11678,11749,11750,11754,11757,11806,11828,11835,11875,11886,11904,11948,11954,11974,11978,11983,12028,12031,12078,12116,12125,12171,12174,12193,12224,12226,12259,12278,12285,12309,12355,12367,12481,12508,12527,12546,12552,12563,12566,12571,12573,12593,12605,12625,12631,12632,12651,12662,12670,12695,12736,12737,12743,12791,12812,12823,12844,12872,12884,12902,12969,12997,13089,13090,13110,13140,13207,13300,13344,13350,13376,13444,13457,13488,13502,13504,13506,13516,13524,13534,13542,13571,13602,13615,13618,13645,13653,13740,13749,13761,13806,13808,13844,13861,13874,13879,13886,13909,13910,13916,13948,13949,13990,14000,14074,14108,14123,14128,14152,14161,14205,14219,14227,14243,14249,14260,14269,14280,14283,14292,14297,14330,14346,14371,14401,14490,14508,14532,14591,14598,14638,14665,14686,14688,14693,14740,14754,14785,14824,14828,14830,14837,14846,14849,14870,14930,14933,14947,14962,15041,15042,15079,15103,15109,15151,15174,15193,15211,15240,15260,15268,15274,15278,15313,15318,15353,15372,15432,15447,15494,15501,15520,15560,15579,15590,15606,15628,15699,15717,15721,15723,15738,15739,15768,15775,15776,15780,15784,15793,15799,15835,15855,15872,15879,15885,15889,15896,15899,15906,15912,15932,15939,15953,15958,16022,16038,16058,16062,16071,16084,16091,16099,16100,16119,16132,16156,16172,16193,16217,16254,16286,16310,16314,16315,16329,16337,16368,16378,16380,16386,16388,16414,16427,16462,16472,16509,16541,16621,16646,16651,16705,16723,16729,16734,16746,16771,16790,16808,16809,16816,16818,16872,16875,16879,16943,16954,16960,16988,16993,16998,17010,17024,17025,17033,17059,17069,17090,17092,17109,17112,17120,17132,17148,17152,17200,17217,17224,17230,17241,17260,17285,17290,17297,17298,17307,17321,17361,17391,17418,17426,17442,17475,17500,17545,17548,17550,17571,17583,17601,17611,17627,17630,17650,17664,17668,17679,17693,17708,17720,17735,17745,17755,17773,17777,17783,17817,17839,17869,17882,17947,18009,18061,18079,18122,18142,18176,18190,18216,18219,18220,18226,18253,18260,18264,18271,18279,18295,18308,18326,18330,18332,18360,18388,18406,18424,18494,18510,18520,18522,18523,18529,18554,18598,18609,18653,18694,18700,18715,18718,18735,18739,18775,18822,18861,18908,18912,18923,18942,18972,18982,18995,19010,19018,19022,19070,19086,19110,19132,19143,19181,19253,19304,19367,19388,19404,19449,19462,19496,19507,19516,19581,19624,19652,19657,19677,19719,19727,19733,19774,19784,19787,19826,19839,19856,19913,19921,19973,20001,20015,20172,20180,20184,20194,20217,20232,20275,20277,20301,20304,20354,20365,20370,20440,20467,20488,20504,20521,20525,20529,20546,20549,20564,20579,20626,20647,20676,20736,20749,20803,20805,20849,20865,20902,20919,20960,20986,20988,21004,21011,21063,21116,21123,21151,21158,21167,21183,21186,21209,21252,21263,21272,21301,21376,21394,21416,21419,21427,21475,21493,21510,21522,21534,21556,21575,21578,21589,21627,21633,21659,21687,21721,21735,21858,21888,21999,22052,22071,22100,22174,22178,22187,22206,22237,22251,22263,22264,22283,22298,22343,22412,22476,22496,22528,22555,22642,22669,22682,22696,22713,22715,22726,22747,22784,22820,22835,22883,22900,22974,22979,22987,23000,23025,23118,23240,23249,23267,23277,23308,23325,23355,23365,23378,23399,23428,23430,23446,23476,23546,23586,23616,23648,23665,23676,23693,23719,23806,23825,23863,23898,23951,23991,23996,24021,24033,24068,24099,24127,24135,24448,24484,24505,24563,24706,24709,24721,24754,24756,24769,24770,24790,24825,24832,24883,24953,24957,24996,25048,25105,25120,25156,25175,25188,25288,25294,25322,25330,25352,25357,25383,25418,25471,25486,25497,25514,25539,25648,25764,25790,25813,25814,25821,25859,25864,25955,25988,26031,26043,26117,26123,26134,26204,26221,26240,26287,26366,26431,26469,26480,26541,26572,26603,26604,26634,26639,26690,26709,26769,26823,26923,26958,26960,27008,27025,27032,27056,27057,27118,27143,27170,27262,27372,27406,27571,27644,27677,27703,27721,27738,27985,28120,28163,28256,28360,28465,28627,28662,28680,28681,28682,28683,28702,28710,28747,28781,28844,28847,29064,29133,29356,29379,29417,29437,29571,29646,29727,30050,30318,30790,35781,36182,36323,36466,36636,38818,40116,40516,40583,40783,42009)
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 | 1142 | 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.02 ms |
init | 0.24 ms |
System lock | 0.02 ms |
optimizing | 0.08 ms |
statistics | 1.78 ms |
preparing | 0.90 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.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 |