Tiempo de la consulta: 12.34 ms Después de la última consulta: 1.25 ms Consulta a la memoria: 0.830 MB memoria antes de la consulta: 4.414 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 14:04:04')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-08 14:04:04')
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(21,66,175,220,331,359,418,460,893,1071,1247,1391,1410,1444,1485,1509,1576,1701,1761,1771,1801,1828,1994,2001,2015,2016,2019,2055,2106,2123,2125,2137,2161,2189,2220,2225,2226,2230,2288,2290,2323,2344,2360,2432,2436,2443,2444,2470,2477,2499,2507,2533,2551,2586,2597,2601,2605,2638,2670,2671,2675,2682,2699,2742,2747,2760,2762,2788,2811,2860,2865,2911,2969,3008,3036,3123,3157,3196,3206,3217,3224,3239,3240,3250,3269,3305,3345,3387,3426,3446,3462,3537,3563,3575,3648,3661,3703,3720,3726,3919,3957,4029,4053,4058,4106,4155,4207,4234,4262,4263,4312,4334,4385,4415,4457,4468,4492,4506,4507,4520,4529,4558,4569,4580,4745,4771,4794,4876,4932,4955,4988,5096,5104,5134,5150,5160,5173,5214,5246,5306,5343,5356,5415,5469,5478,5487,5495,5496,5512,5534,5581,5589,5635,5650,5653,5664,5701,5708,5755,5781,5793,5796,5803,5914,5926,5950,5959,5979,6034,6056,6070,6130,6162,6173,6198,6285,6297,6300,6316,6372,6394,6396,6415,6424,6452,6465,6468,6471,6497,6593,6597,6612,6613,6623,6680,6727,6820,6837,6894,6939,6958,6960,7018,7023,7025,7046,7183,7227,7266,7278,7324,7375,7390,7405,7463,7488,7601,7664,7708,7710,7739,7780,7945,7953,8007,8009,8041,8045,8046,8051,8056,8161,8185,8187,8193,8217,8291,8314,8343,8373,8388,8424,8439,8460,8481,8498,8634,8671,8674,8722,8793,8854,8913,8988,8993,9014,9015,9055,9062,9086,9087,9152,9169,9220,9241,9250,9252,9288,9307,9359,9360,9369,9380,9401,9512,9519,9653,9658,9664,9709,9721,9765,9776,9851,9854,9929,9931,9998,10005,10011,10156,10258,10541,10709,10928,11007,11134,11147,11207,11244,11462,11562,11612,11689,11693,11694,11788,11815,11850,11854,11944,11989,12007,12135,12137,12156,12242,12473,12500,12502,12505,12519,12528,12550,12591,12650,12727,12752,12809,12839,12842,12878,12978,13038,13123,13202,13220,13264,13269,13287,13309,13310,13358,13530,13580,13592,13616,13750,13779,13818,13819,13839,13896,13902,14011,14103,14171,14185,14217,14320,14333,14364,14425,14545,14710,14713,14733,14752,14759,14808,14862,14873,14927,15058,15074,15092,15203,15282,15312,15329,15485,15530,15586,15647,15719,15793,15804,15806,15814,15816,15848,15899,15936,16046,16112,16220,16224,16300,16360,16420,16481,16545,16578,16630,16634,16636,16649,16674,16681,16693,16704,16742,16745,16748,16772,16800,16880,16904,16913,16969,17026,17055,17057,17062,17117,17133,17137,17140,17242,17301,17306,17353,17354,17372,17377,17423,17427,17527,17579,17592,17604,17683,17746,17767,17770,17783,17798,17942,18068,18074,18191,18265,18283,18326,18327,18333,18383,18384,18442,18455,18476,18491,18497,18500,18520,18547,18548,18638,18657,18665,18749,18779,18783,18832,18893,18920,18927,18934,19044,19099,19112,19157,19158,19159,19228,19238,19283,19289,19299,19397,19425,19541,19547,19549,19596,19624,19694,19721,19744,19800,19804,19918,20396,20624,20693,20694,20704,20820,20836,20861,20873,20875,20883,20885,20948,20997,21019,21027,21031,21033,21085,21154,21203,21206,21233,21236,21268,21282,21283,21309,21354,21356,21358,21362,21488,21530,21536,21592,21593,21644,21769,21787,21805,21828,21837,21875,22037,22105,22107,22131,22155,22192,22200,22244,22245,22246,22260,22311,22372,22377,22401,22426,22550,22585,22624,22677,22758,22854,22938,22939,22954,22955,22968,22991,23173,23334,23350,23511,23860,23906,23983,24043,24163,24180,24185,24406,24407,24408,24416,24502,24609,24623,24628,24956,25000,25030,25130,25222,25229,25430,25454,25457,25575,25577,25595,25622,25625,25638,25682,25720,25728,25734,25750,25772,25796,25818,25878,25888,25893,25912,25936,25952,25976,25980,25997,25999,26001,26003,26004,26005,26006,26014,26031,26059,26078,26083,26096,26108,26128,26136,26151,26181,26197,26198,26200,26215,26243,26267,26281,26288,26326,26329,26330,26361,26362,26376,26378,26384,26399,26403,26410,26447,26450,26454,26476,26478,26481,26487,26488,26598,26616,26626,26630,26645,26660,26683,26774,26781,26783,26785,26795,26797,26799,26800,26803,26804,26839,26841,26851,26855,26856,26862,26866,26875,26917,26925,26948,26950,26954,26955,26970,26984,26992,27055,27077,27098,27099,27105,27107,27109,27111,27118,27120,27124,27133,27140,27159,27161,27163,27168,27182,27193,27205,27208,27226,27227,27241,27253,27254,27255,27257,27275,27278,27285,27287,27299,27302,27309,27316,27322,27329,27334,27336,27358,27370,27388,27413,27421,27427,27428,27429,27445,27447,27450,27456,27457,27462,27465,27467,27469,27484,27488,27491,27500,27503,27508,27511,27519,27537,27548,27550,27553,27569,27598,27603,27631,27652,27674,27676,27682,27729,27751,27756,27760,27784,27787,27792,27805,27815,27831,27840,27844,27865,27888,27896,27906,27941,27960,27980,27989,28001,28015,28025,28028,28029,28077,28093,28096,28101,28121,28125,28134,28138,28150,28151,28156,28169,28182,28210,28216,28245,28253,28268,28278,28292,28317,28392,28523,28526,28564,28580,28602,28613,28648,28667,28693,28705,28742,28752,28762,28770,28775,28782,28783,28798,28813,28816,28832,28861,28864,28885,28891,28927,28957,28981,29007,29016,29030,29042,29051,29062,29072,29085,29092,29096,29103,29110,29114,29116,29128,29138,29146,29148,29162,29168,29181,29191,29198,29203,29206,29217,29220,29228,29230,29240,29255,29259,29270,29278,29282,29287,29296,29316,29339,29353,29390,29395,29401,29409,29453,29458,29496,29564,29565,29614,29628,29638,29664,29675,29684,29700,29713,29737,29793,29808,29850,29860,29867,29876,29891,29902,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,30273,30277,30300,30321,30326,30328,30341,30343,30362,30383,30399,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,30810,30814,30832,30851,30867,30880,30903,30904,30910,30911,30912,30919,30920,30931,30934,30942,30946,30960,30975,30976,30992,31003,31004,31013,31019,31027,31033,31040,31063,31074,31112,31134,31162,31190,31195,31196,31203,31221,31292,31339,31424,31476,31489,31559,31571,31585,31645,31673,31680,31686,31694,31774,31786,31800,31810,31822,31839,31881,31894,31936,31947,31965,31966,31997,32054,32077,32124,32196,32210,32227,32322,32413,32432,32457,32518,32549,32569,32589,32647,32653,32677,32700,32746,32778,32783,32814,32823,32859,32892,32912,32946,32947,32948,32949,32950,32951,32952,32953,32954,32955,33034,33123,33135,33236,33283,33411,33440,33491,33504,33505,33506,33507,33508,33509,33510,33511,33530,33649,33929,33993,34185,34186,34241,34356,34368,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,35676,35717,35775,35788,35792,35803,35812,35830,35853,35904,35905,35930,35967,36025,36031,36049,36050,36097,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,38947,39171,39173,39182,39288,39289,39311,39327,39422,39477,39487,39492,39589,39594,39607,39708,39768,39777,39797,39824,39852,39868,39946,39983,40057,40058,40070,40140,40151,40174,40175,40262,40321,40336,40383,40433,40469,40662,40669,40734,40840,40854,40864,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 | 1396 | 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 | 1.06 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.38 ms |
System lock | 0.07 ms |
optimizing | 0.14 ms |
statistics | 3.31 ms |
preparing | 1.66 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 4.62 ms |
end | 0.04 ms |
query end | 0.04 ms |
closing tables | 0.06 ms |
freeing items | 0.08 ms |
cleaning up | 0.05 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 |