Tiempo de la consulta: 7.61 ms Después de la última consulta: 1.94 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.585 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 12:24:17')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 12:24:17')
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(9,11,51,75,76,133,135,138,142,143,165,188,192,204,233,263,323,341,353,354,356,357,358,359,360,361,363,364,390,460,461,477,500,505,507,529,579,583,599,618,633,655,672,684,686,690,697,723,729,756,757,787,795,805,808,826,841,892,907,908,914,922,923,931,942,965,969,971,981,1020,1036,1045,1051,1052,1067,1069,1080,1082,1090,1101,1112,1120,1125,1130,1133,1143,1162,1193,1198,1205,1207,1214,1216,1255,1264,1280,1285,1308,1324,1336,1342,1343,1352,1386,1401,1408,1414,1459,1464,1473,1492,1496,1518,1521,1534,1583,1587,1591,1645,1659,1676,1687,1694,1718,1745,1769,1771,1808,1813,1841,1944,1978,2046,2089,2098,2105,2113,2215,2250,2284,2285,2322,2427,2451,2485,2492,2543,2552,2569,2623,2630,2665,2688,2695,2774,2802,2858,2865,2902,2939,2941,2958,2961,2964,2967,2973,2981,2983,3025,3039,3077,3089,3099,3114,3126,3169,3227,3249,3279,3294,3321,3373,3379,3409,3410,3426,3442,3444,3454,3463,3475,3487,3510,3513,3516,3521,3604,3634,3651,3662,3663,3673,3749,3761,3825,3831,3832,3868,3898,3910,3926,3951,3986,4025,4046,4066,4213,4244,4263,4289,4300,4301,4353,4378,4381,4383,4410,4422,4452,4509,4515,4699,4726,4732,4750,4785,4810,4874,4931,4992,5076,5078,5136,5182,5221,5273,5302,5319,5332,5348,5353,5359,5373,5391,5393,5424,5451,5480,5560,5564,5579,5584,5597,5647,5659,5679,5680,5700,5729,5731,5757,5769,5798,5832,5846,5872,5894,6023,6038,6049,6058,6068,6139,6194,6215,6221,6236,6309,6331,6335,6345,6350,6353,6356,6370,6448,6469,6492,6516,6539,6541,6557,6566,6573,6577,6601,6614,6618,6635,6645,6664,6665,6670,6671,6686,6690,6691,6712,6727,6749,6760,6774,6854,6864,6869,6919,6939,6942,6965,7002,7026,7062,7121,7135,7136,7138,7139,7153,7167,7188,7191,7196,7237,7274,7284,7287,7291,7295,7325,7338,7365,7366,7372,7380,7387,7399,7401,7402,7419,7421,7453,7507,7519,7530,7550,7594,7596,7615,7620,7621,7627,7629,7652,7687,7699,7710,7718,7730,7741,7748,7753,7761,7786,7804,7913,7914,7950,7965,7967,7986,8027,8067,8076,8080,8089,8090,8093,8149,8258,8278,8290,8319,8326,8327,8338,8349,8373,8377,8390,8404,8444,8458,8483,8486,8530,8551,8577,8579,8638,8643,8659,8666,8728,8744,8784,8808,8819,8859,8907,8939,8943,8948,8950,8964,8974,9028,9029,9085,9109,9115,9218,9239,9283,9313,9318,9345,9364,9474,9477,9519,9544,9554,9557,9605,9616,9629,9685,9752,9756,9849,9857,9886,9924,10006,10023,10039,10078,10090,10091,10198,10226,10239,10263,10314,10345,10348,10355,10356,10380,10416,10463,10503,10565,10572,10576,10601,10618,10622,10658,10665,10686,10689,10738,10765,10768,10869,10890,10947,10955,10964,10980,10989,11001,11029,11064,11090,11138,11145,11152,11191,11195,11204,11206,11207,11219,11265,11320,11330,11358,11397,11408,11446,11467,11494,11523,11531,11532,11533,11534,11542,11549,11557,11560,11618,11621,11632,11656,11662,11677,11678,11693,11696,11699,11727,11753,11754,11773,11806,11834,11835,11841,11930,11937,11948,11954,11965,12031,12078,12079,12080,12113,12116,12125,12134,12138,12141,12152,12159,12169,12171,12189,12205,12207,12213,12224,12244,12259,12270,12281,12309,12325,12331,12333,12367,12417,12430,12439,12475,12477,12479,12494,12499,12502,12531,12534,12535,12543,12546,12563,12567,12571,12596,12599,12605,12625,12628,12663,12670,12704,12720,12721,12737,12790,12791,12802,12856,12872,12892,12902,12933,12935,12942,12954,12999,13025,13034,13044,13064,13086,13112,13126,13140,13184,13188,13220,13232,13239,13269,13344,13350,13363,13444,13477,13488,13516,13535,13542,13567,13571,13576,13602,13615,13618,13637,13645,13653,13672,13678,13707,13710,13721,13729,13744,13759,13781,13798,13806,13861,13874,13898,13916,13944,13962,13974,13980,13990,14000,14016,14074,14105,14135,14152,14192,14205,14219,14227,14243,14249,14264,14269,14280,14288,14291,14292,14323,14338,14348,14360,14371,14374,14401,14428,14436,14496,14508,14534,14591,14602,14604,14638,14665,14693,14702,14705,14733,14754,14789,14795,14804,14830,14837,14846,14849,14862,14876,14890,14954,14994,15015,15027,15074,15079,15128,15174,15220,15223,15268,15278,15291,15300,15321,15323,15353,15372,15494,15520,15531,15533,15546,15559,15568,15572,15579,15589,15606,15625,15650,15706,15717,15739,15751,15760,15782,15821,15822,15823,15824,15834,15835,15885,15896,15899,15904,15939,15943,15945,15946,15953,15991,15992,16014,16022,16045,16051,16062,16066,16070,16091,16108,16115,16156,16157,16175,16187,16209,16216,16246,16269,16286,16337,16361,16375,16386,16387,16390,16398,16414,16444,16453,16472,16529,16538,16541,16546,16596,16604,16613,16621,16642,16646,16647,16652,16693,16698,16700,16723,16738,16790,16808,16809,16816,16818,16829,16850,16851,16892,16894,16908,16943,16977,16998,17043,17069,17087,17090,17091,17092,17117,17132,17135,17137,17142,17148,17174,17177,17178,17189,17202,17224,17230,17248,17252,17290,17307,17321,17328,17336,17338,17349,17352,17361,17367,17370,17378,17391,17426,17442,17493,17500,17545,17571,17587,17592,17611,17617,17630,17679,17695,17708,17735,17753,17770,17777,17783,17784,17786,17811,17817,17839,17842,17869,17870,17882,17883,17924,17947,17954,18009,18027,18042,18071,18072,18078,18079,18107,18122,18140,18142,18150,18166,18176,18212,18216,18220,18226,18249,18253,18260,18264,18279,18290,18292,18295,18308,18309,18321,18332,18360,18363,18384,18388,18406,18407,18419,18422,18424,18430,18452,18456,18457,18471,18485,18494,18520,18522,18523,18534,18535,18554,18598,18620,18622,18652,18653,18669,18672,18688,18700,18703,18718,18761,18775,18781,18789,18822,18833,18835,18836,18838,18861,18879,18893,18908,18912,18945,18960,18979,18982,18995,18996,19010,19018,19022,19046,19086,19110,19145,19181,19235,19241,19249,19270,19304,19308,19316,19364,19367,19388,19404,19439,19449,19462,19482,19496,19507,19514,19518,19526,19540,19541,19554,19561,19565,19576,19581,19624,19649,19652,19657,19664,19665,19675,19677,19693,19695,19705,19712,19720,19729,19759,19774,19776,19779,19820,19823,19826,19835,19856,19862,19870,19892,19893,19913,19915,19921,19926,19935,19942,19973,20001,20002,20042,20045,20046,20055,20076,20082,20106,20130,20157,20159,20180,20184,20194,20217,20226,20230,20232,20275,20277,20304,20311,20315,20323,20329,20354,20370,20394,20402,20408,20422,20428,20438,20440,20452,20453,20456,20467,20473,20488,20500,20503,20525,20529,20531,20533,20546,20548,20564,20576,20577,20579,20626,20643,20647,20652,20677,20698,20736,20749,20767,20774,20786,20803,20825,20833,20837,20863,20865,20883,20885,20905,20911,20915,20919,20946,20969,20981,20986,20988,20992,21004,21011,21026,21042,21044,21060,21061,21093,21094,21116,21123,21151,21158,21162,21167,21183,21188,21217,21227,21251,21252,21263,21264,21272,21284,21285,21301,21304,21309,21326,21328,21333,21335,21337,21341,21376,21378,21394,21408,21415,21416,21419,21427,21441,21455,21458,21480,21482,21493,21502,21510,21534,21556,21567,21575,21589,21609,21619,21622,21633,21644,21659,21692,21699,21704,21714,21721,21728,21735,21782,21794,21796,21801,21803,21809,21815,21822,21825,21830,21834,21840,21844,21869,21888,21900,21922,21936,21938,21941,21962,21975,21999,22015,22019,22036,22048,22057,22071,22072,22100,22117,22154,22166,22174,22178,22200,22202,22206,22251,22263,22283,22298,22299,22323,22343,22351,22373,22384,22385,22412,22421,22422,22474,22476,22494,22496,22507,22528,22537,22555,22556,22565,22607,22660,22669,22682,22696,22704,22713,22726,22736,22747,22761,22774,22802,22818,22820,22827,22829,22835,22883,22889,22893,22896,22900,22926,22934,22938,22974,22979,22992,23006,23014,23019,23035,23040,23092,23104,23116,23118,23119,23134,23145,23151,23178,23213,23238,23240,23249,23273,23287,23290,23309,23322,23332,23343,23355,23364,23365,23378,23409,23426,23428,23430,23446,23453,23454,23474,23476,23481,23506,23513,23530,23546,23570,23574,23586,23607,23616,23648,23650,23665,23668,23676,23677,23693,23711,23719,23749,23776,23806,23807,23825,23828,23833,23863,23869,23872,23898,23914,23935,23948,23951,23996,23998,24021,24033,24094,24099,24108,24135,24172,24195,24216,24224,24225,24228,24233,24245,24271,24289,24309,24363,24368,24379,24380,24391,24427,24442,24443,24447,24462,24477,24484,24505,24510,24518,24527,24529,24535,24563,24608,24619,24625,24630,24636,24685,24706,24709,24721,24754,24756,24763,24790,24832,24851,24883,24915,24917,24919,24942,24953,24974,24995,24996,25018,25048,25090,25105,25110,25116,25120,25131,25153,25170,25175,25188,25195,25228,25286,25288,25315,25322,25330,25334,25351,25383,25398,25400,25444,25471,25486,25497,25504,25506,25511,25514,25518,25539,25594,25612,25648,25658,25661,25707,25717,25736,25740,25745,25749,25764,25790,25801,25813,25821,25842,25859,25860,25864,25874,25885,25892,25905,25944,25955,25995,26002,26010,26043,26091,26117,26123,26130,26132,26134,26155,26195,26204,26221,26240,26264,26332,26360,26366,26373,26377,26396,26403,26406,26412,26419,26431,26458,26469,26472,26480,26534,26541,26550,26591,26599,26603,26634,26637,26639,26661,26672,26702,26709,26753,26758,26769,26792,26835,26842,26843,26864,26879,26907,26917,26922,26923,26933,26947,26956,27039,27052,27057,27059,27105,27106,27137,27142,27143,27144,27164,27170,27178,27179,27189,27201,27203,27237,27262,27265,27337,27343,27360,27372,27406,27408,27409,27457,27548,27549,27571,27644,27677,27738,27800,27855,27911,27918,27921,27923,27924,27926,27985,27999,28120,28163,28208,28256,28283,28316,28349,28372,28419,28465,28627,28662,28680,28681,28682,28683,28702,28710,28781,28844,28847,29054,29064,29088,29133,29169,29223,29290,29366,29379,29380,29417,29464,29511,29571,29611,29626,29630,29641,29646,29727,29849,30050,30242,30318,30393,30394,30425,30511,30621,30676,30790,30932,32056,32304,32642,32643,32644,32769,32796,32831,32914,33065,33235,33749,33750,33863,33954,33955,34016,34047,34052,34146,34180,34189,34251,34377,34391,34415,34426,34427,34435,34449,34483,34502,34525,34560,34683,34701,34733,34795,34832,34876,34923,34935,34959,34978,35010,35094,35175,35185,35192,35195,35205,35310,35314,35321,35324,35392,35436,35503,35557,35581,35609,35626,35658,35698,35773,35783,35790,35836,35847,35850,35859,35876,35902,35930,35953,35958,35968,35982,36014,36031,36066,36174,36192,36204,36222,36227,36238,36323,36421,36437,36439,36478,36515,36531,36688,36714,36736,36828,36850,36868,36888,36957,37024,37137,37344,37357,37365,37479,37521,37543,37544,37553,37567,37579,37581,37642,37669,37693,37710,37731,37740,37756,37767,37787,37802,37844,37852,37876,37932,37953,37999,38060,38185,38263,38329,38346,38349,38361,38370,38409,38430,38506,38512,38520,38567,38588,38623,38658,38659,38660,38734,38764,38779,38781,38788,38800,38801,38809,38815,38837,38842,38851,38861,38885,38888,38898,38956,38979,38985,39004,39019,39023,39062,39070,39114,39160,39185,39212,39242,39324,39346,39415,39416,39439,39484,39491,39582,39602,39649,39670,39729,39736,39757,39767,39820,39838,39846,39849,39858,39886,39932,39934,39954,39984,39986,39993,40003,40015,40024,40066,40072,40073,40094,40100,40111,40116,40128,40186,40187,40195,40212,40218,40225,40239,40302,40306,40345,40357,40379,40392,40414,40431,40494,40505,40508,40521,40583,40638,40665,40699,40714,40786,40831,40886,40897,40904,40917,40970,40983,40996,41023,41046,41051,41059,41075,41078,41096,41142,41146,41159,41181,41190,41227,41245,41248,41251,41259,41273,41284,41297,41303,41313,41355,41363,41370,41373,41391,41440,41508,41517,41660,41722,41726,41738,41739,41768,41811,41822,41851,41875,41931,41959,41963,41972,41973,41981,41983,41997,42002,42009,42010,42029,42113,42124,42136,42181,42199,42232,42251,42275,42282,42303,42353,42380,42427,42430,42446,42462,42478,42484,42574,42604,42625,42768,42788,42880,43058,43083,43088,43116,43143,43181,43182,43199,43216,43217,43236,43268,43312,43342,43347,43348,43434,43443,43445,43455,43468,43471,43501,43507,43512,43527,43612,43617,43628,43629,43647,43684,43703,43704,43730,43742,43758,43800,43822,43836,43875,43876,43877,43883,43905,43927,44003,44045,44049,44050,44070,44073,44098,44239,44255,44259,44338,44353,44356,44379,44389,44392,44433,44437,44455,44521,44558,44570,44586,44603,44625,44658,44683,44691,44708,44748,44842,44853,44874,44907,44964,44989,45008,45055,45060,45147,45195,45251,45289,45301,45311)
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 | 2070 | 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.99 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.39 ms |
System lock | 0.02 ms |
optimizing | 0.13 ms |
statistics | 3.31 ms |
preparing | 1.62 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.38 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 |