Tiempo de la consulta: 14.97 ms Después de la última consulta: 1.94 ms Consulta a la memoria: 1.276 MB memoria antes de la consulta: 4.463 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-04 01:12:56')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 01:12:56')
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(2,5,9,21,185,255,271,272,274,311,594,1066,1081,1248,1252,1253,1255,1328,1476,1785,2033,2101,2125,2176,2324,2394,2397,2432,2469,2477,2494,2601,2605,2654,2671,2688,2742,2747,2964,3001,3110,3123,3193,3202,3468,3563,3704,3750,3797,3854,3872,3894,3920,3983,4101,4144,4227,4246,4247,4339,4342,4467,4492,4581,4809,4845,4882,4989,5008,5049,5496,5512,5609,5628,5697,5796,6065,6162,6209,6257,6316,6354,6358,6369,6407,6452,6464,6589,6608,6678,6709,6726,6762,6789,6807,6808,6835,6840,6863,7380,7387,7390,7403,7404,7405,7439,7449,7463,7488,7562,7625,7659,7953,8007,8056,8153,8179,8184,8193,8267,8449,8566,8623,8721,8750,8794,8854,8900,9055,9057,9236,9255,9288,9382,9390,9495,9664,9721,9765,9776,9815,9932,9999,10060,10111,10175,10195,10282,10477,10529,10839,10926,10928,10933,11134,11187,11195,11612,11761,11792,11989,12137,12156,12248,12473,12508,12519,12528,12602,12746,12809,12842,12976,12978,13006,13029,13117,13123,13231,13309,13310,13544,13546,13557,13573,13580,13669,13703,13712,13818,13819,13839,13861,13902,13935,14011,14103,14114,14188,14217,14279,14283,14311,14420,14467,14490,14545,14683,14711,14731,14765,14856,15058,15092,15109,15297,15329,15357,15456,15479,15586,15899,15909,15932,15936,15959,15973,15981,15988,16112,16266,16289,16360,16374,16420,16423,16449,16452,16478,16489,16638,16681,16734,16748,16836,16859,16867,16913,17050,17057,17059,17267,17285,17359,17423,17559,17579,17604,17742,17910,17952,17960,18201,18295,18333,18354,18409,18431,18446,18455,18520,18521,18550,18660,18679,18707,18714,18749,18772,18898,18920,18993,19004,19044,19099,19115,19155,19157,19158,19159,19207,19217,19227,19238,19502,19624,19768,19815,19855,19867,19930,19961,20217,20218,20400,20480,20579,20730,20757,20771,20796,20812,20820,20849,20875,20885,20948,21051,21069,21085,21309,21397,21530,21611,21644,21743,21926,21940,22019,22052,22092,22097,22107,22113,22130,22155,22192,22229,22261,22343,22477,22489,22624,22625,23016,23360,23647,23654,23737,23860,24270,24284,24288,24312,24388,24392,24407,24450,24479,24531,24565,24910,25043,25133,25222,25229,25242,25256,25278,25282,25340,25413,25417,25430,25454,25575,25577,25580,25595,25609,25631,25638,25720,25728,25734,25736,25747,25771,25787,25796,25816,25832,25835,25845,25852,25878,25888,25893,25896,25936,25943,25952,25963,25964,25968,25969,25976,25979,25980,25997,25999,26001,26004,26005,26006,26059,26061,26070,26083,26096,26109,26128,26151,26154,26167,26171,26181,26195,26197,26200,26202,26243,26256,26261,26267,26326,26328,26329,26330,26348,26353,26378,26384,26410,26429,26433,26438,26439,26450,26468,26471,26478,26481,26488,26492,26529,26570,26598,26645,26660,26670,26679,26681,26712,26722,26724,26733,26763,26766,26770,26774,26781,26783,26795,26799,26807,26808,26851,26855,26856,26862,26866,26873,26894,26905,26908,26910,26925,26950,26951,26970,26980,26984,26991,26992,27018,27036,27054,27071,27077,27098,27099,27105,27111,27118,27120,27133,27138,27140,27159,27163,27168,27182,27185,27193,27205,27208,27219,27226,27227,27235,27238,27241,27253,27254,27255,27257,27266,27278,27280,27285,27287,27292,27299,27309,27311,27314,27316,27322,27329,27334,27336,27358,27359,27370,27375,27383,27388,27406,27413,27415,27416,27428,27429,27447,27450,27456,27462,27465,27467,27469,27475,27484,27488,27500,27503,27508,27511,27519,27535,27537,27550,27553,27569,27576,27580,27598,27603,27610,27631,27652,27674,27682,27713,27715,27727,27729,27731,27751,27756,27760,27767,27772,27779,27784,27787,27792,27815,27831,27833,27837,27840,27844,27859,27865,27888,27896,27906,27941,27944,27947,27960,27974,27980,27989,28001,28012,28015,28025,28028,28029,28034,28039,28062,28074,28077,28081,28086,28093,28096,28099,28100,28101,28121,28123,28125,28126,28134,28138,28150,28151,28156,28169,28170,28180,28181,28182,28189,28210,28216,28228,28231,28233,28245,28253,28268,28278,28292,28306,28310,28313,28317,28318,28320,28352,28364,28381,28401,28418,28439,28451,28469,28471,28486,28492,28509,28523,28528,28564,28572,28580,28588,28602,28603,28613,28630,28644,28645,28648,28650,28659,28667,28705,28708,28716,28719,28737,28742,28743,28752,28760,28762,28770,28775,28779,28782,28783,28798,28802,28813,28816,28831,28832,28838,28861,28864,28875,28885,28891,28927,28934,28956,28957,28963,28965,28977,28981,28990,28991,28996,29007,29016,29030,29042,29045,29051,29062,29070,29072,29081,29085,29092,29096,29100,29103,29110,29114,29116,29125,29128,29138,29146,29148,29150,29162,29167,29168,29170,29174,29179,29181,29187,29190,29191,29198,29200,29203,29206,29207,29217,29220,29225,29228,29230,29236,29239,29240,29245,29246,29254,29255,29259,29267,29268,29270,29273,29276,29278,29282,29287,29292,29296,29304,29306,29313,29314,29316,29330,29334,29336,29338,29339,29340,29344,29353,29356,29364,29390,29393,29395,29401,29409,29424,29442,29453,29458,29479,29496,29501,29521,29522,29548,29554,29564,29565,29583,29603,29605,29614,29628,29638,29651,29652,29664,29667,29673,29675,29684,29685,29687,29700,29710,29713,29735,29737,29754,29755,29784,29793,29808,29818,29820,29838,29843,29845,29850,29860,29864,29867,29871,29876,29878,29879,29882,29891,29900,29902,29913,29916,29921,29922,29929,29932,29947,29949,29952,29954,29958,29959,29964,29970,29981,29989,30003,30004,30011,30012,30014,30019,30020,30030,30041,30048,30053,30057,30059,30066,30067,30096,30105,30122,30124,30134,30145,30156,30165,30167,30174,30178,30198,30200,30227,30246,30257,30264,30270,30277,30300,30321,30326,30328,30341,30343,30362,30370,30383,30396,30399,30411,30426,30435,30459,30460,30462,30505,30513,30518,30556,30557,30565,30566,30577,30579,30593,30594,30609,30618,30629,30630,30635,30639,30648,30649,30652,30653,30661,30669,30683,30689,30694,30695,30704,30705,30722,30747,30749,30753,30755,30762,30771,30773,30777,30785,30794,30804,30814,30820,30821,30827,30832,30851,30854,30861,30867,30880,30903,30904,30908,30910,30911,30912,30919,30920,30931,30934,30942,30946,30952,30960,30975,30976,30992,31003,31004,31005,31013,31027,31033,31040,31063,31074,31112,31134,31162,31170,31190,31191,31194,31195,31196,31203,31221,31269,31277,31292,31309,31339,31393,31424,31427,31429,31438,31439,31471,31476,31489,31501,31538,31546,31547,31548,31549,31559,31562,31571,31585,31588,31645,31656,31660,31672,31673,31677,31678,31680,31686,31689,31694,31774,31786,31790,31800,31810,31816,31817,31822,31823,31826,31839,31841,31851,31874,31879,31881,31894,31936,31944,31947,31965,31966,31997,32003,32032,32054,32063,32077,32117,32124,32180,32196,32210,32213,32218,32227,32238,32246,32253,32261,32262,32263,32303,32305,32323,32376,32413,32432,32433,32435,32457,32511,32512,32518,32524,32525,32530,32533,32549,32550,32569,32570,32589,32653,32677,32700,32702,32746,32778,32783,32800,32803,32810,32814,32823,32855,32859,32868,32892,32919,32923,32946,32947,32948,32949,32950,32951,32952,32953,32954,32955,32981,33008,33034,33042,33048,33088,33123,33132,33135,33136,33144,33177,33226,33236,33283,33379,33411,33431,33439,33459,33460,33491,33510,33511,33530,33552,33568,33588,33604,33621,33709,33757,33805,33806,33807,33809,33834,33866,33929,33950,34005,34026,34042,34103,34116,34162,34211,34217,34237,34241,34264,34271,34282,34289,34297,34322,34350,34378,34402,34410,34414,34433,34440,34454,34456,34461,34462,34486,34491,34509,34515,34524,34576,34584,34606,34613,34617,34627,34642,34650,34654,34673,34676,34678,34682,34686,34707,34725,34753,34758,34778,34788,34801,34819,34834,34837,34856,34886,34896,34909,34910,34917,34927,34928,34930,34932,34933,34936,34938,34941,34952,34954,34958,34961,34963,34972,34973,34974,34979,34986,34994,34996,35005,35020,35022,35026,35030,35033,35042,35043,35049,35050,35052,35054,35056,35061,35065,35081,35082,35083,35085,35093,35105,35109,35119,35121,35124,35125,35126,35128,35129,35146,35151,35152,35154,35166,35170,35172,35194,35204,35212,35213,35215,35226,35230,35243,35248,35258,35259,35276,35299,35305,35320,35337,35379,35381,35398,35430,35442,35498,35502,35505,35512,35515,35518,35547,35563,35567,35583,35596,35599,35601,35625,35636,35650,35659,35677,35678,35686,35717,35718,35742,35766,35773,35775,35780,35788,35794,35796,35803,35806,35812,35815,35816,35825,35830,35853,35855,35865,35888,35890,35893,35904,35905,35907,35911,35914,35920,35930,35940,35977,35998,35999,36011,36022,36025,36031,36038,36040,36069,36085,36096,36097,36098,36120,36131,36147,36153,36158,36186,36197,36200,36207,36208,36211,36215,36221,36223,36237,36241,36244,36249,36253,36255,36257,36271,36272,36273,36281,36287,36292,36297,36307,36312,36318,36327,36331,36342,36351,36352,36358,36362,36433,36434,36435,36440,36441,36443,36444,36451,36460,36468,36485,36487,36490,36504,36509,36510,36517,36518,36545,36551,36563,36568,36597,36621,36641,36671,36675,36712,36718,36745,36751,36770,36779,36782,36786,36809,36814,36817,36841,36882,36895,36898,36908,36927,36934,36937,36939,36961,36976,37005,37006,37017,37025,37040,37042,37048,37049,37050,37051,37062,37063,37070,37076,37077,37087,37091,37110,37112,37114,37116,37148,37150,37153,37167,37170,37204,37230,37309,37327,37374,37403,37405,37407,37430,37439,37454,37459,37496,37511,37519,37540,37564,37588,37596,37618,37620,37663,37703,37706,37761,37773,37776,37789,37792,37793,37802,37807,37841,37852,37866,37867,37873,37893,37895,37896,37897,37898,37900,37915,37919,37937,37938,37944,37945,37973,37977,37985,37997,38002,38003,38005,38006,38024,38025,38026,38027,38076,38081,38084,38088,38092,38093,38103,38110,38111,38114,38119,38122,38124,38128,38140,38166,38173,38175,38179,38187,38189,38190,38191,38198,38205,38207,38208,38209,38214,38217,38219,38221,38229,38239,38248,38252,38253,38254,38255,38259,38260,38264,38284,38285,38292,38294,38295,38296,38297,38298,38299,38305,38310,38313,38315,38319,38340,38342,38368,38369,38398,38440,38446,38447,38450,38476,38500,38502,38530,38548,38559,38576,38584,38591,38600,38633,38654,38662,38667,38672,38674,38684,38686,38690,38694,38711,38724,38729,38759,38776,38784,38813,38835,38839,38863,38879,38905,38917,38947,38950,38982,38983,38994,39027,39059,39150,39167,39173,39176,39182,39245,39261,39276,39279,39288,39289,39294,39296,39311,39327,39347,39367,39375,39389,39391,39407,39422,39444,39455,39477,39487,39492,39510,39589,39594,39607,39609,39622,39659,39708,39722,39747,39749,39768,39777,39797,39802,39823,39824,39852,39864,39868,39924,39946,39948,39983,40018,40043,40057,40058,40068,40070,40091,40108,40140,40151,40174,40175,40177,40231,40252,40262,40276,40309,40321,40336,40340,40383,40398,40421,40423,40433,40436,40438,40460,40469,40473,40485,40497,40520,40535,40553,40556,40586,40614,40631,40662,40667,40669,40688,40689,40692,40748,40805,40840,40854,40881,40884,40892,40894,40925,40931,40954,40957,40958,40959,40981,40988,41040,41054,41068,41077,41107,41138,41141,41220,41228,41232,41247,41266,41286,41288,41321,41359,41405,41418,41430,41436,41484,41527,41533,41555,41570,41573,41576,41592,41594,41595,41599,41624,41635,41649,41650,41660,41712,41724,41728,41764,41782,41800,41806,41807,41829,41834,41839,41865,41871,41879,41888,41927,41950,41956,41957,41992,42002,42004,42011,42032,42040,42057,42065,42076,42082,42117,42144,42150,42153,42154,42163,42174,42188,42212,42218,42262,42292,42314,42328,42366,42405,42431,42439,42448,42472,42490,42496,42509,42511,42529,42542,42545,42586,42587,42608,42649,42652,42685,42689,42691,42729,42733,42741,42787,42804,42806,42863,42904,42934,42937,42945,42960,42975,42997,43007,43009,43042,43066,43073,43089,43122,43143,43145,43148,43149,43151,43166,43173,43198,43202,43203,43222,43229,43234,43244,43251,43259,43261,43290,43294,43314,43327,43334,43345,43362,43367,43387,43389,43402,43403,43407,43433,43444,43458,43459,43487,43508,43509,43530,43534,43538,43539,43550,43556,43580,43582,43601,43610,43615,43622,43658,43663,43682,43686,43687,43715,43727,43789,43794,43807,43838,43844,43846,43852,43868,43869,43901,43920,43965,44026,44055,44074,44124,44125,44126,44154,44155,44238,44255,44256,44262,44299,44301,44315,44340,44346,44351,44357,44365,44376,44398,44400,44407,44431,44484,44491,44498,44501,44531,44561,44565,44578,44588,44606,44607,44608,44611,44613,44637,44643,44655,44665,44670,44698,44701,44710,44741,44742,44771,44779,44791,44803,44805,44806,44812,44818,44836,44864,44869,44872,44892,44894,44939,44946,44955,44978,44979,44990,45007,45048,45051,45062,45077,45098,45102,45116,45118,45122,45133,45142,45146,45147,45157,45166,45176,45191,45194,45197,45201,45221,45230,45234,45240,45241,45262,45277,45278,45287,45302,45303)
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 | 2075 | 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.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.36 ms |
System lock | 0.02 ms |
optimizing | 0.13 ms |
statistics | 3.34 ms |
preparing | 1.60 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 7.73 ms |
end | 0.04 ms |
query end | 0.06 ms |
closing tables | 0.03 ms |
freeing items | 0.19 ms |
cleaning up | 0.09 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 |