Tiempo de la consulta: 5.03 ms Después de la última consulta: 1.15 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.357 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-07 05:47:54')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 05:47:54')
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(11,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,71,75,81,83,87,88,89,110,111,125,137,174,185,188,189,190,200,205,234,246,248,249,263,271,281,294,316,325,353,362,368,398,412,415,416,420,421,422,423,424,426,427,429,431,481,484,496,501,503,520,522,531,574,575,593,611,621,626,686,697,698,728,752,784,785,801,816,820,825,853,862,868,931,963,973,980,986,1078,1183,1207,1223,1264,1318,1344,1353,1357,1364,1371,1428,1434,1440,1461,1507,1541,1556,1601,1638,1649,1673,1690,1697,1718,1724,1782,1823,1827,1878,1896,2000,2095,2108,2110,2115,2133,2150,2181,2195,2207,2208,2272,2290,2332,2357,2371,2540,2720,2728,2729,2735,2765,2797,2818,2825,2870,2896,2922,2939,2957,2972,3020,3033,3040,3051,3117,3177,3208,3212,3257,3325,3332,3397,3478,3491,3567,3574,3613,3650,3682,3759,3838,3881,3934,4015,4019,4310,4371,4674,4690,4693,4741,4745,4856,4896,4902,4905,5052,5053,5060,5072,5154,5189,5233,5285,5298,5324,5375,5392,5420,5451,5476,5520,5538,5633,5647,5684,5685,5710,5729,5798,5827,5840,5894,5895,5933,6047,6051,6094,6141,6176,6203,6211,6267,6278,6279,6283,6284,6311,6331,6339,6377,6392,6415,6422,6435,6438,6445,6453,6463,6475,6476,6477,6482,6501,6534,6548,6567,6597,6605,6616,6619,6643,6666,6671,6776,6802,6825,6832,6836,6868,6888,6889,7002,7017,7050,7056,7109,7124,7138,7175,7185,7210,7219,7225,7287,7450,7463,7492,7497,7584,7670,7678,7687,7692,7716,7718,7730,7741,7766,7782,7811,7823,7837,7849,7933,7950,7951,7955,7965,7970,7987,7993,7994,8027,8141,8169,8183,8189,8204,8205,8215,8223,8236,8245,8246,8247,8315,8320,8355,8380,8401,8426,8444,8460,8471,8521,8537,8569,8571,8589,8602,8610,8626,8630,8638,8674,8689,8757,8781,8801,8816,8835,8838,8839,8845,8856,8877,8887,8888,8912,8921,8945,8952,8983,8986,8997,9058,9073,9131,9136,9158,9164,9206,9262,9282,9351,9401,9411,9412,9425,9428,9442,9472,9487,9564,9650,9677,9678,9752,9818,9820,9842,9924,10017,10035,10120,10144,10180,10187,10274,10278,10315,10317,10340,10375,10376,10392,10414,10491,10561,10596,10673,10860,10896,10938,10939,10948,10953,10970,10971,10975,10991,11016,11037,11060,11074,11075,11080,11093,11120,11165,11186,11252,11255,11285,11292,11328,11343,11345,11361,11371,11438,11491,11611,11626,11629,11648,11661,11729,11737,11738,11739,11788,11789,11800,11848,11938,11967,12002,12020,12081,12082,12094,12108,12118,12162,12219,12248,12283,12324,12326,12339,12356,12364,12384,12415,12442,12460,12511,12513,12526,12557,12620,12630,12650,12670,12672,12685,12686,12708,12723,12752,12808,12811,12868,12873,12913,12955,12973,12996,13002,13014,13016,13056,13110,13125,13150,13152,13153,13207,13217,13294,13348,13377,13474,13475,13476,13530,13543,13554,13585,13600,13613,13646,13685,13695,13707,13713,13715,13838,13900,13920,13933,13971,13973,14002,14038,14047,14229,14282,14287,14293,14362,14382,14386,14457,14468,14471,14486,14534,14536,14540,14554,14610,14612,14642,14643,14657,14678,14684,14694,14791,14796,14847,14860,14873,14915,14960,14975,14980,15003,15038,15043,15117,15119,15177,15215,15243,15245,15261,15293,15382,15400,15411,15414,15475,15476,15497,15501,15520,15533,15574,15588,15596,15608,15633,15699,15742,15755,15778,15789,15791,15796,15848,15861,15888,15893,15945,15964,15969,15972,16055,16059,16062,16066,16071,16115,16161,16176,16320,16342,16365,16423,16439,16446,16447,16450,16451,16497,16507,16526,16534,16543,16545,16566,16573,16587,16622,16644,16648,16663,16751,16806,16814,16815,16818,16829,16831,16833,16844,16866,16898,16908,16935,16950,16976,16985,16996,17005,17011,17047,17048,17090,17108,17114,17115,17132,17143,17190,17194,17243,17247,17277,17291,17292,17309,17322,17334,17335,17376,17392,17410,17413,17417,17419,17421,17438,17452,17456,17464,17487,17496,17514,17517,17518,17528,17536,17557,17588,17607,17629,17630,17702,17710,17721,17725,17730,17734,17753,17781,17791,17838,17845,17857,17887,17890,17896,17908,17912,17989,17990,18007,18071,18073,18088,18100,18134,18136,18139,18186,18220,18239,18260,18300,18309,18311,18316,18351,18355,18360,18368,18436,18447,18492,18558,18562,18569,18578,18708,18716,18720,18757,18764,18765,18770,18819,18881,18882,18909,18951,18957,18989,19017,19031,19065,19073,19114,19131,19145,19208,19221,19282,19290,19292,19302,19304,19311,19329,19330,19339,19367,19381,19413,19415,19429,19460,19497,19520,19541,19551,19578,19596,19623,19644,19650,19661,19668,19682,19695,19700,19720,19733,19741,19772,19825,19839,19881,19883,19886,19923,19931,19937,19970,19980,20029,20033,20041,20056,20057,20060,20062,20067,20076,20095,20111,20128,20156,20158,20170,20188,20192,20193,20213,20239,20274,20308,20345,20362,20420,20439,20450,20457,20459,20483,20543,20554,20567,20595,20616,20621,20644,20648,20654,20684,20699,20700,20727,20748,20809,20847,20854,20888,21016,21038,21073,21115,21159,21171,21218,21248,21255,21256,21268,21279,21283,21285,21288,21300,21307,21310,21338,21368,21376,21388,21449,21464,21485,21486,21524,21526,21529,21552,21618,21623,21628,21645,21650,21661,21664,21669,21689,21690,21695,21704,21707,21716,21719,21720,21727,21763,21800,21824,21843,21850,21851,21871,21910,21922,21950,21954,21955,21956,21964,22015,22018,22029,22045,22062,22065,22071,22075,22077,22100,22110,22117,22132,22138,22163,22164,22177,22195,22223,22241,22302,22316,22324,22336,22344,22406,22421,22422,22435,22445,22446,22453,22512,22525,22550,22580,22603,22619,22620,22622,22623,22626,22654,22655,22658,22669,22689,22692,22702,22710,22723,22727,22741,22765,22780,22787,22804,22829,22833,22868,22897,22917,22923,22930,22936,22947,22972,23007,23024,23043,23057,23062,23063,23073,23077,23082,23089,23097,23124,23153,23179,23214,23332,23377,23382,23414,23424,23431,23441,23480,23518,23524,23528,23575,23627,23657,23663,23665,23672,23677,23708,23716,23726,23728,23741,23749,23768,23801,23808,23882,23884,23927,23973,23987,24016,24100,24143,24182,24184,24226,24249,24273,24289,24332,24393,24408,24475,24489,24522,24556,24582,24612,24617,24619,24620,24636,24642,24665,24697,24765,24803,24805,24912,24937,24956,24993,24998,25030,25035,25039,25048,25062,25108,25131,25138,25164,25171,25312,25318,25351,25394,25397,25406,25436,25441,25448,25528,25542,25548,25584,25646,25660,25725,25904,26000,26033,26038,26048,26147,26178,26221,26255,26298,26317,26343,26360,26415,26424,26454,26474,26574,26578,26595,26651,26659,26677,26713,26742,26771,26801,26820,26824,26845,26881,26905,26907,26915,26944,26963,26973,26997,27000,27038,27121,27130,27184,27362,27366,27412,27482,27491,27530,27688,27722,27803,27833,27846,27878,27898,27901,27904,27938,28005,28033,28072,28080,28318,28339,28436,28440,28442,28559,28614,28615,28616,28712,28728,28763,28777,28845,28944,28992,29012,29054,29214,29219,29244,29269,29354,29388,29460,29486,29635,29650,29832,33254,33270,33417,34729,35039,35040,35135,35330,35366,35588,35713,35744,35834,35857,35886,35891,35922,35955,35972,36157,36269,36364,36707,36798,36821,37576,37598,37736,37851,37871,38855,39112,39283,39398,39464,39530,39535,39773,40036,40110,40483,40490,40492,40515,40605,40789,40835,41025,41058,41069,41292,41318,41360,41722,41887,42284,42494,42769,42833,43360,43543,44149,44640,45008,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 | 1252 | 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.64 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.24 ms |
System lock | 0.02 ms |
optimizing | 0.09 ms |
statistics | 1.97 ms |
preparing | 0.98 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.37 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 |