Tiempo de la consulta: 6.78 ms Después de la última consulta: 1.35 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.381 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 11:05:28')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 11:05:28')
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(1,11,43,49,58,83,137,154,178,179,183,184,233,281,294,316,329,332,362,368,398,446,458,465,478,510,521,522,555,558,593,618,621,671,695,723,728,729,752,757,784,806,816,825,845,868,877,879,911,915,931,955,963,980,986,1010,1027,1033,1057,1094,1158,1186,1207,1210,1214,1226,1234,1240,1318,1322,1335,1339,1344,1364,1371,1428,1440,1461,1541,1550,1556,1575,1601,1649,1673,1690,1708,1767,1782,1823,1827,1948,2000,2015,2094,2110,2115,2125,2145,2207,2332,2357,2381,2482,2540,2654,2658,2720,2728,2729,2735,2740,2765,2768,2787,2838,2870,2896,2922,2939,2957,2960,2964,2970,2972,2990,3022,3033,3040,3116,3117,3177,3199,3247,3257,3292,3295,3332,3353,3397,3478,3488,3514,3536,3546,3567,3574,3636,3696,3704,3706,3759,3838,3854,3864,3881,3920,3934,3939,3979,3991,3997,4015,4019,4093,4096,4123,4163,4217,4276,4281,4371,4650,4657,4690,4693,4716,4733,4745,4765,4790,4856,4857,4896,4900,5001,5030,5052,5053,5061,5085,5109,5155,5233,5257,5258,5285,5300,5306,5529,5530,5631,5633,5648,5657,5659,5665,5684,5690,5710,5729,5774,5800,5827,5840,5855,5894,5918,5933,5972,5998,6047,6048,6051,6094,6095,6176,6185,6203,6211,6228,6267,6283,6284,6383,6400,6418,6422,6438,6445,6448,6453,6454,6496,6501,6520,6550,6567,6619,6646,6695,6703,6713,6775,6802,6825,6832,6866,6902,6994,7002,7076,7115,7174,7175,7219,7224,7225,7266,7277,7285,7327,7338,7346,7354,7433,7449,7513,7551,7577,7583,7584,7610,7650,7657,7666,7670,7678,7687,7730,7733,7739,7757,7764,7766,7823,7829,7840,7849,7871,7875,7876,7901,7927,7951,7970,8027,8043,8068,8137,8138,8141,8167,8169,8177,8183,8189,8202,8204,8205,8210,8212,8223,8236,8245,8246,8247,8248,8258,8315,8320,8351,8355,8359,8362,8380,8391,8401,8426,8453,8471,8510,8521,8537,8543,8565,8569,8571,8575,8602,8626,8630,8665,8670,8742,8757,8790,8794,8806,8816,8838,8839,8845,8877,8885,8888,8912,8921,8952,8965,8971,8973,8983,8986,9058,9103,9131,9136,9158,9164,9187,9211,9254,9385,9401,9403,9442,9472,9487,9495,9564,9683,9712,9734,9752,9777,9780,9799,9818,9832,9842,9886,9891,9943,9952,9956,9972,9988,9994,9995,10016,10017,10021,10072,10074,10084,10144,10146,10149,10172,10173,10187,10199,10207,10221,10271,10315,10317,10340,10375,10376,10392,10394,10395,10401,10411,10420,10456,10464,10491,10499,10537,10547,10561,10596,10620,10673,10745,10755,10833,10841,10860,10896,10906,10932,10938,10939,10948,10953,10970,10975,10983,10986,10991,11009,11027,11037,11043,11060,11074,11075,11093,11117,11120,11150,11165,11168,11186,11238,11243,11252,11253,11255,11263,11284,11285,11287,11292,11343,11351,11361,11371,11377,11473,11491,11503,11538,11610,11611,11626,11629,11648,11661,11663,11666,11680,11698,11713,11716,11729,11737,11738,11739,11775,11789,11790,11800,11870,11879,11889,11926,11938,11967,11970,11998,12002,12003,12011,12036,12042,12069,12081,12082,12085,12094,12118,12131,12136,12152,12155,12206,12219,12221,12248,12283,12314,12317,12319,12326,12329,12339,12356,12362,12364,12370,12384,12434,12441,12448,12486,12511,12513,12514,12526,12538,12588,12604,12614,12636,12670,12676,12738,12749,12752,12758,12811,12813,12824,12845,12849,12895,12902,12910,12922,12960,13002,13056,13107,13110,13125,13132,13141,13150,13152,13153,13207,13217,13222,13250,13315,13345,13353,13359,13377,13379,13396,13412,13440,13446,13476,13481,13485,13549,13554,13585,13594,13613,13664,13685,13697,13705,13706,13708,13753,13892,13900,14002,14038,14040,14078,14092,14122,14133,14175,14198,14199,14232,14234,14268,14287,14305,14326,14355,14378,14382,14386,14417,14421,14436,14451,14457,14468,14480,14493,14502,14505,14531,14540,14607,14610,14612,14637,14642,14643,14649,14654,14691,14692,14699,14714,14791,14798,14847,14873,14881,14915,14922,14953,14955,14960,14982,15002,15003,15060,15092,15105,15107,15115,15117,15119,15123,15148,15177,15180,15206,15217,15226,15257,15284,15299,15314,15325,15344,15358,15371,15400,15403,15410,15417,15443,15483,15492,15500,15501,15577,15580,15596,15608,15609,15632,15637,15639,15642,15656,15701,15733,15742,15745,15755,15756,15762,15778,15788,15791,15811,15831,15832,15835,15840,15878,15879,15888,15954,15994,16024,16052,16066,16156,16167,16183,16217,16261,16279,16295,16321,16324,16328,16335,16336,16353,16359,16365,16368,16377,16389,16404,16421,16423,16436,16439,16446,16447,16450,16458,16505,16517,16518,16613,16622,16627,16628,16644,16659,16662,16682,16775,16777,16778,16792,16806,16814,16815,16818,16820,16831,16844,16866,16893,16898,16909,16919,16926,16935,16985,17006,17011,17047,17055,17070,17072,17074,17090,17108,17143,17149,17158,17185,17190,17194,17212,17214,17247,17269,17291,17292,17346,17376,17390,17410,17417,17424,17441,17452,17456,17460,17485,17487,17498,17512,17514,17518,17536,17547,17561,17568,17574,17588,17596,17620,17630,17633,17650,17661,17687,17701,17705,17725,17733,17734,17751,17753,17759,17761,17772,17774,17783,17816,17824,17838,17844,17845,17885,17887,17896,17909,17918,17921,17948,17951,17973,17989,17990,18055,18088,18102,18136,18139,18160,18179,18186,18192,18220,18221,18226,18231,18238,18277,18300,18315,18345,18351,18352,18353,18366,18396,18401,18434,18435,18447,18467,18483,18509,18520,18522,18530,18531,18537,18578,18579,18643,18664,18671,18708,18716,18731,18732,18744,18750,18770,18775,18792,18795,18799,18821,18831,18846,18881,18882,18909,18920,18936,18957,18960,18972,18973,18989,18993,19006,19017,19027,19031,19063,19096,19106,19114,19128,19131,19136,19145,19151,19172,19179,19191,19205,19221,19224,19247,19285,19309,19311,19313,19330,19339,19352,19367,19405,19413,19422,19437,19457,19492,19520,19562,19604,19619,19626,19641,19644,19666,19697,19748,19752,19778,19790,19806,19874,19881,19883,19925,19944,19957,20008,20028,20035,20041,20056,20067,20074,20095,20098,20111,20117,20141,20156,20158,20166,20170,20184,20204,20205,20233,20239,20240,20272,20282,20290,20299,20305,20328,20332,20333,20344,20345,20352,20359,20362,20399,20419,20420,20428,20450,20457,20483,20487,20489,20537,20554,20608,20631,20644,20654,20712,20734,20780,20782,20801,20841,20854,20877,20886,20888,20890,20912,20956,20974,21013,21017,21028,21055,21067,21085,21086,21108,21112,21115,21121,21128,21129,21131,21133,21149,21163,21176,21181,21191,21218,21231,21255,21258,21307,21324,21376,21387,21396,21449,21456,21459,21482,21542,21547,21566,21628,21665,21683,21689,21707,21713,21716,21720,21742,21750,21787,21859,21878,21910,21956,21964,21967,21969,21987,21994,22031,22053,22071,22075,22088,22100,22122,22132,22137,22138,22184,22219,22261,22266,22292,22316,22344,22380,22445,22485,22493,22498,22525,22546,22553,22619,22623,22654,22668,22669,22671,22681,22689,22691,22744,22779,22786,22822,22834,22857,22873,22885,22898,22917,22918,22930,22986,22998,23013,23026,23047,23057,23092,23127,23181,23202,23224,23260,23278,23288,23310,23319,23332,23338,23377,23400,23414,23431,23468,23516,23543,23584,23624,23627,23657,23666,23667,23686,23705,23726,23728,23731,23741,23756,23780,23801,23855,23873,23876,23882,23884,23911,23973,23989,24002,24082,24097,24100,24114,24118,24143,24182,24184,24185,24190,24201,24210,24241,24340,24432,24485,24489,24556,24567,24595,24597,24619,24620,24630,24657,24671,24672,24673,24681,24734,24790,24807,24836,24845,24887,24912,24922,24945,24947,24967,24998,25016,25036,25038,25041,25103,25137,25146,25156,25163,25200,25218,25258,25315,25353,25373,25380,25441,25461,25469,25474,25483,25513,25540,25554,25583,25600,25663,25746,25753,25790,25813,25822,25835,25871,25891,25911,25952,25995,26012,26038,26040,26048,26053,26073,26078,26116,26145,26148,26157,26174,26191,26207,26209,26225,26236,26247,26271,26298,26308,26309,26322,26339,26344,26355,26387,26392,26394,26420,26427,26432,26434,26452,26461,26476,26481,26485,26520,26522,26539,26554,26560,26561,26562,26567,26578,26594,26595,26598,26627,26642,26643,26647,26659,26699,26701,26769,26771,26780,26791,26828,26847,26893,26897,26906,26915,26924,26934,26936,26938,26963,26990,26991,27024,27028,27040,27075,27085,27096,27113,27121,27127,27134,27141,27162,27174,27175,27184,27233,27250,27279,27342,27352,27354,27355,27368,27381,27390,27403,27412,27420,27442,27455,27463,27563,27608,27626,27635,27650,27724,27739,27864,27880,27884,27887,27893,27898,27900,27972,28088,28090,28116,28118,28135,28185,28242,28252,28259,28263,28294,28335,28422,28487,28539,28554,28560,28579,28609,28617,28637,28651,28712,28714,28715,28849,28854,28882,28902,28941,29010,29028,29034,29073,29077,29089,29104,29126,29141,29172,29265,29348,29381,29413,29419,29437,29445,29467,29499,29550,29551,29622,29650,29658,29683,29783,29788,29801,29837,29839,29872,29896,29897,29915,29918,29933,30381,30414,30475,30499,30547,30941,31090,31173,31510,31733,31742,31762,31837,33385,33645,34066,34150,34841,35135,35366,35588,35675,35751,35798,35834,35843,35857,35886,35891,35922,35941,35972,36046,36141,36287,36364,36707,37158,37218,37576,37851,38657,38772,38855,38887,39112,39254,39342,39527,39773,39846,39877,39956,40064,40153,40483,40521,40672,40789,40835,40861,40909,41025,41104,42284,42494,42833,43360,43543,44494,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 | 1554 | 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.78 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.30 ms |
System lock | 0.02 ms |
optimizing | 0.14 ms |
statistics | 2.65 ms |
preparing | 1.20 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.44 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.07 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 |