Tiempo de la consulta: 9.06 ms Después de la última consulta: 1.36 ms Consulta a la memoria: 0.830 MB memoria antes de la consulta: 4.390 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 16:46:42')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 16:46:42')
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,21,49,58,154,332,446,458,478,510,521,558,593,618,671,680,695,723,729,757,816,845,868,879,911,915,955,986,1010,1027,1033,1057,1094,1115,1158,1175,1186,1207,1210,1214,1226,1234,1240,1335,1339,1543,1630,1655,1821,1942,2094,2477,2484,2601,2742,2747,2964,3022,3123,3259,3295,3353,3503,3525,3546,3566,3696,3706,3762,3864,4096,4141,4163,4198,4276,4281,4765,4790,5001,5085,5295,5300,5306,5648,5659,5796,5894,5918,6162,6316,6423,6448,6452,6520,6703,6902,6994,7277,7285,7327,7338,7346,7376,7390,7405,7431,7449,7453,7463,7488,7513,7551,7577,7583,7666,7669,7692,7707,7730,7757,7764,7829,7840,7871,7901,8007,8027,8056,8138,8177,8193,8258,8351,8727,8785,8854,8973,9055,9080,9215,9254,9288,9472,9527,9625,9664,9707,9721,9734,9765,9832,9886,9891,9956,10025,10034,10149,10199,10207,10256,10257,10300,10305,10401,10462,10464,10499,10537,10539,10565,10655,10663,10732,10767,10833,10910,10928,10932,10986,11009,11027,11043,11103,11134,11150,11228,11238,11263,11265,11367,11377,11473,11502,11538,11612,11666,11680,11713,11716,11767,11775,11870,11879,11926,11989,12011,12036,12042,12044,12069,12085,12129,12131,12136,12137,12152,12156,12317,12319,12345,12362,12370,12378,12448,12464,12473,12514,12519,12528,12588,12604,12629,12636,12658,12670,12676,12738,12758,12809,12842,12849,12851,12910,12944,12960,12978,13038,13107,13123,13132,13179,13222,13250,13309,13310,13345,13359,13379,13396,13440,13446,13481,13580,13594,13664,13697,13708,13753,13818,13819,13839,13892,13897,13902,14011,14013,14040,14078,14092,14103,14133,14175,14198,14199,14217,14232,14234,14268,14305,14355,14378,14421,14451,14480,14493,14502,14505,14523,14531,14545,14637,14654,14691,14699,14749,14798,14846,14887,14901,14955,14982,14990,15002,15005,15058,15060,15092,15105,15107,15115,15123,15148,15180,15206,15217,15226,15257,15284,15299,15325,15329,15344,15358,15371,15403,15410,15417,15443,15459,15483,15492,15500,15577,15580,15586,15609,15632,15637,15639,15642,15656,15733,15745,15762,15788,15811,15832,15835,15840,15878,15879,15899,15936,15954,16020,16024,16052,16089,16112,16156,16163,16167,16217,16261,16279,16295,16328,16336,16353,16359,16360,16368,16389,16404,16420,16436,16447,16458,16518,16613,16627,16645,16659,16662,16681,16682,16746,16748,16778,16792,16820,16866,16893,16909,17023,17057,17072,17099,17149,17158,17185,17214,17247,17269,17346,17390,17423,17424,17441,17452,17460,17485,17498,17512,17536,17574,17579,17596,17604,17620,17633,17650,17657,17701,17705,17716,17733,17753,17759,17761,17763,17772,17774,17783,17810,17816,17824,17831,17844,17885,17918,17951,17973,18055,18100,18102,18160,18179,18220,18221,18231,18238,18277,18300,18315,18333,18345,18352,18353,18366,18389,18401,18434,18435,18455,18514,18520,18537,18562,18643,18653,18654,18693,18732,18744,18749,18750,18773,18792,18811,18821,18830,18846,18877,18891,18905,18909,18920,18936,18951,18960,18972,18973,18988,18993,19027,19044,19063,19099,19106,19136,19151,19154,19157,19159,19172,19179,19191,19205,19224,19238,19247,19285,19305,19309,19313,19344,19352,19405,19422,19437,19457,19467,19492,19562,19604,19619,19624,19626,19666,19697,19702,19735,19743,19748,19752,19778,19790,19806,19874,19925,19929,19944,19957,20008,20035,20098,20117,20158,20166,20204,20205,20233,20282,20291,20299,20305,20328,20332,20333,20344,20352,20359,20399,20419,20420,20455,20457,20487,20489,20537,20554,20608,20656,20660,20712,20780,20782,20783,20805,20820,20841,20875,20877,20885,20886,20912,20948,20956,20974,21011,21013,21017,21055,21067,21085,21086,21108,21121,21128,21133,21149,21163,21181,21231,21258,21309,21324,21387,21396,21482,21530,21542,21547,21566,21628,21644,21665,21677,21683,21689,21713,21716,21742,21750,21855,21859,21878,21940,21967,21994,22031,22053,22088,22107,22122,22137,22155,22192,22219,22266,22292,22316,22380,22485,22493,22498,22546,22553,22624,22668,22671,22681,22691,22744,22779,22786,22822,22834,22857,22873,22898,22918,22936,22998,23013,23026,23047,23181,23202,23224,23260,23278,23288,23310,23319,23338,23400,23468,23515,23516,23543,23548,23584,23603,23624,23666,23667,23686,23705,23726,23731,23756,23773,23780,23855,23873,23876,23911,23989,24002,24082,24114,24190,24201,24210,24340,24432,24485,24567,24586,24630,24643,24657,24671,24672,24673,24681,24691,24715,24734,24752,24790,24807,24836,24845,24887,24922,24945,24967,25038,25041,25103,25137,25146,25163,25200,25218,25222,25229,25258,25315,25353,25373,25380,25430,25454,25461,25469,25474,25483,25513,25540,25544,25554,25575,25577,25583,25595,25600,25638,25663,25666,25720,25728,25734,25739,25743,25746,25753,25762,25768,25790,25796,25798,25813,25822,25878,25888,25893,25911,25936,25976,25980,25997,25999,26001,26004,26005,26006,26059,26068,26073,26083,26096,26116,26128,26151,26157,26174,26181,26191,26197,26200,26207,26209,26225,26236,26243,26247,26267,26271,26294,26322,26326,26329,26330,26344,26355,26384,26387,26392,26420,26432,26434,26450,26452,26478,26481,26488,26522,26560,26562,26594,26598,26645,26660,26701,26774,26780,26781,26783,26795,26799,26851,26855,26856,26862,26897,26924,26925,26934,26936,26970,26984,26992,27024,27028,27040,27075,27077,27085,27096,27098,27099,27105,27111,27127,27140,27159,27163,27168,27182,27193,27205,27208,27226,27227,27241,27253,27254,27255,27257,27278,27279,27285,27299,27309,27316,27329,27334,27336,27355,27358,27368,27370,27388,27390,27403,27413,27420,27428,27429,27441,27442,27447,27456,27462,27467,27469,27484,27488,27500,27503,27508,27511,27515,27519,27537,27553,27563,27569,27598,27603,27631,27652,27674,27682,27702,27720,27724,27729,27739,27751,27756,27760,27770,27784,27787,27792,27793,27815,27831,27840,27844,27865,27888,27893,27896,27898,27906,27941,27960,27980,27989,28001,28015,28025,28028,28029,28077,28093,28096,28101,28116,28121,28125,28134,28135,28138,28150,28151,28156,28169,28182,28185,28210,28216,28242,28245,28253,28268,28278,28292,28294,28317,28523,28539,28564,28580,28593,28602,28609,28613,28617,28648,28651,28667,28705,28712,28714,28715,28742,28752,28762,28770,28775,28782,28783,28798,28813,28816,28832,28861,28864,28885,28891,28927,28957,28981,29007,29016,29027,29030,29034,29042,29051,29062,29072,29085,29089,29092,29096,29103,29110,29114,29116,29128,29138,29146,29148,29162,29168,29181,29191,29198,29203,29206,29217,29220,29228,29230,29240,29243,29255,29259,29270,29278,29282,29287,29296,29316,29339,29346,29348,29353,29381,29390,29395,29401,29409,29413,29445,29453,29458,29467,29496,29499,29550,29551,29564,29565,29614,29628,29638,29658,29664,29675,29683,29684,29700,29713,29737,29788,29793,29801,29808,29837,29839,29850,29860,29867,29872,29876,29891,29896,29897,29902,29905,29915,29918,29921,29929,29932,29947,29954,29959,29964,29970,29981,29989,30003,30004,30011,30012,30030,30041,30048,30053,30057,30066,30067,30124,30134,30145,30156,30167,30174,30200,30227,30257,30264,30270,30277,30300,30321,30326,30328,30341,30343,30362,30383,30399,30414,30435,30459,30513,30518,30557,30565,30566,30593,30594,30618,30629,30630,30635,30639,30648,30649,30652,30653,30661,30683,30694,30695,30704,30705,30722,30749,30762,30771,30777,30785,30814,30832,30851,30867,30880,30903,30904,30910,30911,30912,30919,30920,30931,30934,30941,30942,30946,30960,30975,30976,30992,31003,31004,31013,31027,31033,31040,31063,31074,31090,31112,31134,31162,31190,31195,31196,31203,31221,31292,31339,31424,31476,31489,31510,31559,31571,31585,31645,31673,31680,31686,31694,31774,31786,31800,31810,31822,31837,31839,31881,31894,31936,31947,31965,31966,31997,32054,32077,32124,32196,32210,32227,32413,32432,32457,32518,32549,32569,32589,32653,32677,32687,32700,32746,32778,32783,32814,32823,32859,32892,32946,32947,32948,32949,32950,32951,32952,32953,32954,32955,33034,33123,33135,33236,33283,33385,33411,33491,33511,33530,33929,34150,34241,34491,34686,34886,34896,34909,34910,34917,34928,34930,34933,34936,34941,34952,34954,34958,34972,34973,34974,34979,34986,35005,35022,35030,35033,35042,35043,35050,35054,35061,35065,35093,35105,35119,35128,35498,35505,35636,35659,35717,35775,35788,35803,35812,35830,35831,35853,35904,35905,35926,35930,36025,36031,36097,36141,36147,36208,36221,36223,36253,36255,36342,36362,36433,36435,36460,36882,36908,36937,37006,37048,37049,37050,37051,37077,37110,37327,37374,37405,37407,37430,37459,37511,37564,37620,37773,37776,37866,37867,37895,37915,37937,37938,37944,37945,37977,37985,37997,38003,38076,38081,38084,38124,38187,38205,38207,38208,38209,38217,38229,38239,38255,38259,38260,38264,38294,38295,38296,38297,38298,38299,38342,38368,38369,38559,38633,38667,38672,38684,38686,38694,38724,38729,38759,38776,38813,38835,38863,38887,38947,39173,39182,39267,39288,39289,39311,39327,39342,39422,39477,39487,39492,39589,39594,39607,39708,39768,39777,39797,39809,39824,39846,39852,39868,39877,39946,39982,39983,40009,40057,40058,40064,40070,40140,40151,40174,40175,40262,40321,40336,40383,40433,40469,40521,40604,40605,40606,40662,40669,40672,40737,40751,40840,40854,40861,40909,41104,41107,41138,41247,41283,41527,41533,41712,41829,42002,42011,42032,42076,42082,42153,42472,42545,42586,42587,42649,42685,42733,42804,42904,42937,43007,43066,43089,43122,43149,43151,43166,43173,43261,43314,43334,43362,43402,43403,43444,43499,43538,43556,43580,43582,43622,43658,43869,44055,44074,44126,44154,44238,44255,44256,44301,44315,44357,44376,44398,44407,44531,44561,44665,44670,44710,44742,44771,44803,44805,44806,44812,44872,44892,44939,44946,44978,44979,44990,45007,45048,45062,45077,45098,45102,45116,45133,45142,45146,45176,45194,45197,45221,45262,45277,45278)
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 | 1598 | 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.72 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.28 ms |
System lock | 0.02 ms |
optimizing | 0.12 ms |
statistics | 2.44 ms |
preparing | 1.20 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 3.07 ms |
end | 0.02 ms |
query end | 0.03 ms |
closing tables | 0.03 ms |
freeing items | 0.09 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 |