Tiempo de la consulta: 4.74 ms Después de la última consulta: 1.20 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.358 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 05:49:12')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-08 05:49:12')
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,9,11,25,28,44,45,46,47,48,49,50,51,52,53,56,57,58,59,81,91,95,100,103,112,163,165,190,200,205,234,263,276,279,296,297,300,301,303,304,305,307,325,353,354,356,357,358,359,360,361,363,364,368,372,373,445,460,477,500,520,523,549,592,605,607,655,666,686,723,725,756,757,794,847,848,868,878,965,1002,1020,1045,1067,1075,1080,1090,1102,1120,1143,1147,1168,1198,1207,1212,1214,1223,1285,1308,1313,1324,1329,1336,1353,1367,1386,1434,1477,1718,1745,1804,1846,2105,2272,2293,2322,2463,2569,2590,2630,2729,2858,2939,2964,2983,3016,3020,3036,3038,3039,3054,3109,3169,3294,3320,3412,3442,3461,3463,3474,3477,3522,3673,3761,3786,3812,3984,4231,4378,4409,4422,4476,4589,4691,4765,4863,4874,4907,4908,5136,5176,5182,5231,5302,5351,5373,5386,5451,5456,5472,5567,5579,5597,5605,5613,5647,5649,5659,5686,5729,5730,5731,5798,5881,5886,5894,6036,6147,6254,6304,6318,6350,6393,6420,6465,6470,6473,6475,6476,6477,6485,6516,6541,6542,6543,6572,6573,6601,6645,6662,6665,6666,6690,6727,6806,6854,6939,7026,7056,7135,7138,7139,7191,7284,7365,7380,7387,7401,7402,7419,7453,7587,7591,7616,7621,7622,7627,7629,7718,7730,7741,7753,7758,7950,7965,7981,7986,7994,8021,8027,8067,8090,8093,8139,8191,8338,8391,8499,8533,8549,8638,8666,8691,8823,8932,8939,8974,9029,9318,9398,9429,9616,9886,9924,10023,10078,10098,10100,10226,10239,10263,10295,10298,10314,10345,10368,10380,10416,10503,10572,10601,10665,10686,10738,10768,10801,10964,10980,10989,11001,11029,11152,11156,11191,11204,11219,11265,11292,11320,11348,11374,11446,11523,11542,11561,11678,11754,11806,11835,11857,11894,11948,11954,12031,12078,12116,12125,12145,12171,12224,12225,12259,12309,12367,12385,12399,12423,12474,12546,12563,12571,12605,12617,12625,12628,12668,12670,12737,12791,12810,12856,12872,12875,12887,12901,12902,12913,12944,12966,13004,13067,13140,13155,13277,13344,13350,13444,13456,13462,13488,13516,13518,13528,13542,13566,13571,13602,13615,13618,13645,13646,13653,13665,13687,13697,13718,13725,13775,13804,13806,13861,13866,13874,13902,13916,13917,13963,13990,14000,14074,14152,14204,14205,14219,14227,14229,14243,14249,14269,14271,14273,14280,14292,14293,14366,14371,14382,14386,14401,14450,14456,14507,14508,14524,14537,14552,14564,14591,14602,14638,14665,14675,14684,14693,14754,14776,14830,14837,14844,14846,14849,14850,14893,14909,14911,14935,14945,15029,15032,15039,15048,15069,15079,15094,15174,15224,15245,15258,15266,15268,15278,15304,15328,15353,15370,15372,15403,15424,15442,15468,15471,15490,15492,15494,15520,15542,15561,15574,15575,15579,15606,15717,15725,15728,15739,15829,15835,15885,15890,15896,15899,15935,15939,15945,15953,15972,16014,16022,16029,16040,16048,16062,16091,16093,16140,16153,16154,16156,16161,16163,16202,16230,16258,16286,16317,16326,16337,16339,16386,16414,16451,16472,16481,16497,16517,16534,16541,16562,16621,16632,16646,16723,16790,16808,16809,16816,16818,16837,16858,16943,16963,16981,16998,17019,17069,17090,17092,17104,17114,17128,17132,17138,17139,17177,17179,17195,17224,17230,17234,17257,17290,17321,17334,17343,17358,17361,17381,17382,17391,17426,17431,17442,17470,17500,17501,17571,17596,17602,17611,17629,17630,17679,17695,17702,17708,17735,17764,17766,17777,17783,17785,17817,17839,17840,17862,17869,17882,17895,17947,17948,17961,17966,17980,18009,18074,18079,18122,18142,18161,18176,18198,18216,18220,18226,18253,18260,18264,18267,18273,18279,18295,18297,18300,18308,18311,18322,18332,18339,18360,18369,18375,18384,18388,18390,18406,18419,18424,18442,18479,18494,18498,18520,18522,18554,18561,18598,18653,18682,18689,18700,18718,18769,18775,18791,18793,18822,18847,18861,18864,18904,18908,18912,18927,18934,18955,18982,18991,18995,19010,19018,19022,19086,19110,19132,19133,19174,19181,19185,19227,19247,19303,19304,19313,19366,19367,19371,19388,19404,19446,19449,19462,19471,19496,19507,19541,19551,19563,19581,19624,19639,19650,19652,19657,19677,19700,19702,19715,19720,19749,19774,19826,19856,19868,19894,19913,19921,19973,19975,19994,20001,20026,20069,20076,20124,20144,20180,20184,20194,20208,20217,20224,20232,20277,20287,20304,20344,20346,20354,20366,20370,20406,20440,20467,20488,20511,20525,20529,20546,20564,20579,20595,20602,20621,20626,20636,20643,20647,20665,20677,20716,20736,20749,20768,20786,20790,20796,20803,20845,20865,20919,20944,20986,20988,20996,21004,21011,21049,21061,21116,21123,21151,21158,21167,21183,21198,21215,21229,21242,21252,21263,21272,21280,21301,21305,21323,21328,21334,21376,21394,21416,21419,21427,21436,21452,21472,21493,21510,21516,21528,21534,21538,21556,21575,21589,21622,21633,21648,21659,21672,21721,21732,21735,21753,21765,21781,21826,21888,21999,22008,22049,22056,22059,22071,22100,22174,22178,22198,22206,22208,22234,22251,22263,22266,22269,22283,22298,22309,22312,22334,22343,22412,22421,22476,22486,22496,22509,22517,22528,22555,22572,22668,22669,22682,22692,22696,22713,22726,22735,22743,22747,22802,22808,22820,22827,22835,22883,22900,22901,22925,22974,22979,23041,23063,23072,23076,23082,23097,23113,23118,23122,23201,23219,23240,23249,23286,23300,23335,23345,23355,23364,23378,23399,23423,23428,23430,23446,23451,23476,23480,23546,23555,23586,23616,23622,23648,23664,23665,23668,23676,23693,23719,23806,23825,23848,23863,23882,23898,23900,23906,23951,23959,23996,24021,24033,24099,24111,24122,24135,24174,24282,24288,24367,24420,24484,24505,24513,24563,24576,24607,24616,24655,24673,24706,24709,24721,24742,24754,24756,24790,24826,24832,24842,24844,24857,24860,24874,24879,24883,24922,24953,24954,24996,25048,25087,25088,25105,25120,25131,25142,25175,25188,25245,25276,25288,25322,25330,25346,25383,25443,25445,25471,25486,25487,25497,25506,25514,25539,25548,25565,25648,25675,25679,25698,25707,25727,25746,25764,25790,25795,25809,25813,25821,25823,25859,25864,25935,25949,25955,25987,26028,26043,26065,26117,26134,26166,26167,26176,26204,26219,26221,26235,26240,26317,26360,26366,26431,26456,26469,26480,26499,26521,26541,26564,26603,26634,26639,26709,26742,26752,26769,26800,26874,26905,26916,26923,26937,26944,26947,26959,26989,27000,27057,27091,27120,27131,27143,27148,27170,27186,27250,27262,27321,27372,27406,27452,27491,27526,27571,27644,27677,27707,27717,27726,27738,27786,27805,27809,27846,27878,27909,27949,27966,27978,27985,28005,28049,28078,28120,28163,28256,28339,28344,28465,28614,28615,28627,28643,28662,28680,28681,28682,28683,28695,28698,28702,28710,28781,28844,28845,28847,28920,28944,29028,29054,29064,29133,29379,29406,29417,29459,29540,29557,29571,29626,29646,29727,29882,29924,30050,30318,30484,30790,30940,32502,33349,34252,34951,35744,35746,35762,35861,35909,36191,36321,36323,36336,36378,36453,36479,36506,37281,37382,38361,38631,39088,39452,39467,39504,39966,40116,40169,40278,40491,40583,40752,40796,41036,41811,41885,41984,41985,42009,42314,42570)
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 | 1183 | 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.56 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.23 ms |
System lock | 0.02 ms |
optimizing | 0.08 ms |
statistics | 1.83 ms |
preparing | 0.90 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.34 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 |