Tiempo de la consulta: 7.44 ms Después de la última consulta: 1.41 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.397 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 17:15:22')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 17:15:22')
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,3,4,5,6,7,8,11,14,16,19,20,21,22,23,24,25,26,27,28,29,30,31,32,49,58,70,71,72,73,75,126,127,128,165,167,197,204,253,255,260,263,272,275,344,353,484,505,507,549,550,551,581,583,607,608,667,686,693,705,709,726,735,757,801,816,825,860,868,882,892,895,900,916,917,935,961,968,1015,1046,1053,1056,1059,1080,1124,1134,1140,1198,1204,1207,1226,1235,1238,1304,1308,1330,1347,1477,1504,1519,1587,1594,1787,1823,1883,2024,2150,2204,2209,2235,2272,2290,2293,2305,2482,2566,2631,2666,2668,2726,2758,2797,2886,2887,3016,3038,3152,3193,3208,3306,3353,3393,3442,3447,3452,3495,3522,3591,3604,3620,3626,3634,3696,3700,3718,3719,3732,3769,3812,3837,3880,3898,3918,3975,3976,3986,4004,4092,4114,4169,4188,4209,4231,4258,4410,4459,4515,4580,4625,4631,4640,4677,4739,4767,4920,4932,4973,4980,5018,5051,5138,5150,5189,5247,5365,5386,5435,5438,5451,5461,5559,5634,5660,5726,5727,5730,5798,5825,5894,5924,6062,6141,6186,6245,6257,6294,6311,6330,6367,6394,6407,6475,6476,6477,6485,6492,6493,6503,6542,6543,6545,6583,6604,6605,6616,6708,6716,6742,6764,6793,6804,6830,6936,6939,6945,7005,7128,7142,7181,7243,7245,7249,7275,7288,7335,7337,7368,7396,7412,7413,7417,7425,7455,7457,7458,7484,7489,7492,7516,7565,7572,7584,7618,7711,7718,7720,7725,7735,7741,7802,7806,7829,7847,7934,7950,7965,7980,7994,8026,8027,8064,8073,8074,8114,8125,8223,8229,8285,8351,8381,8383,8499,8549,8555,8566,8568,8587,8589,8610,8615,8660,8689,8691,8713,8759,8780,8851,8856,8860,8916,8917,8932,9010,9181,9233,9257,9286,9351,9398,9399,9432,9435,9438,9439,9704,9734,9745,9792,9805,9820,9828,9853,9864,9945,10051,10054,10110,10120,10154,10180,10195,10202,10216,10237,10248,10260,10268,10274,10282,10295,10304,10369,10384,10385,10478,10554,10564,10611,10628,10659,10666,10686,10696,10713,10769,10857,10888,10894,10912,10924,10971,10982,11006,11026,11032,11065,11076,11083,11091,11108,11122,11123,11127,11143,11146,11150,11157,11196,11224,11290,11309,11320,11328,11345,11370,11383,11386,11388,11407,11424,11438,11487,11497,11534,11585,11587,11592,11614,11642,11707,11721,11727,11730,11762,11839,11900,11915,11925,11944,11987,12018,12032,12038,12040,12091,12098,12109,12115,12126,12133,12186,12212,12218,12237,12248,12251,12306,12307,12369,12393,12449,12463,12474,12493,12548,12554,12576,12608,12673,12677,12684,12735,12736,12758,12761,12834,12848,12852,12902,12903,12916,12935,12959,12991,13020,13081,13115,13141,13143,13172,13176,13188,13190,13191,13198,13231,13246,13259,13309,13331,13346,13348,13418,13425,13433,13434,13456,13573,13595,13609,13611,13621,13627,13631,13662,13670,13671,13673,13674,13675,13677,13697,13702,13703,13705,13706,13731,13734,13741,13742,13759,13860,13867,13869,13883,13951,13972,13986,13994,14005,14057,14062,14070,14073,14080,14097,14101,14104,14114,14141,14150,14184,14196,14201,14204,14205,14222,14227,14229,14236,14249,14267,14270,14273,14276,14278,14279,14281,14305,14331,14339,14341,14348,14366,14368,14385,14408,14420,14456,14469,14482,14495,14522,14534,14563,14570,14572,14574,14600,14624,14632,14652,14684,14692,14732,14746,14747,14769,14770,14794,14799,14807,14815,14827,14842,14846,14931,14941,14960,14981,14993,15006,15028,15069,15076,15100,15108,15120,15146,15147,15175,15196,15206,15215,15243,15263,15266,15277,15293,15303,15304,15349,15356,15370,15402,15411,15439,15464,15470,15475,15477,15485,15518,15521,15522,15524,15543,15548,15551,15562,15565,15604,15631,15641,15664,15668,15680,15689,15703,15709,15725,15728,15731,15750,15763,15766,15837,15841,15866,15873,15894,15935,15955,16020,16037,16050,16053,16093,16153,16161,16163,16166,16169,16209,16257,16280,16317,16356,16358,16369,16370,16408,16415,16442,16451,16458,16490,16513,16515,16523,16539,16562,16604,16605,16619,16632,16640,16644,16645,16675,16685,16688,16722,16739,16791,16825,16827,16837,16845,16864,16867,16996,17019,17053,17059,17061,17090,17115,17128,17130,17132,17138,17146,17194,17205,17221,17227,17228,17234,17244,17257,17288,17291,17307,17337,17373,17394,17407,17411,17420,17432,17436,17465,17488,17493,17518,17533,17537,17551,17552,17569,17600,17623,17626,17679,17681,17688,17701,17724,17747,17753,17766,17772,17775,17812,17813,17822,17839,17852,17859,17874,17875,17880,17889,17895,17923,17925,17935,17938,17952,17956,17966,17980,17987,17991,17993,17998,18000,18018,18031,18032,18038,18057,18072,18116,18123,18138,18140,18156,18164,18169,18185,18200,18216,18259,18260,18261,18273,18282,18303,18304,18311,18314,18316,18331,18356,18360,18364,18370,18375,18388,18390,18396,18402,18425,18431,18440,18445,18453,18479,18481,18493,18505,18514,18524,18528,18543,18554,18562,18564,18566,18580,18583,18584,18593,18599,18621,18646,18649,18659,18668,18679,18686,18687,18733,18738,18748,18773,18781,18813,18829,18837,18853,18874,18882,18891,18914,18922,18930,18949,18951,18952,18969,18973,18978,18985,18991,18997,19013,19018,19026,19041,19043,19053,19059,19073,19078,19083,19117,19119,19133,19134,19147,19168,19175,19217,19219,19223,19237,19242,19247,19271,19293,19312,19318,19366,19371,19381,19408,19409,19411,19417,19427,19428,19429,19436,19437,19448,19457,19503,19505,19508,19519,19526,19535,19541,19545,19553,19556,19567,19571,19576,19585,19589,19595,19596,19602,19604,19606,19612,19639,19643,19645,19646,19667,19671,19699,19700,19701,19713,19720,19728,19744,19758,19764,19769,19780,19825,19829,19841,19853,19880,19882,19894,19905,19913,19952,19953,19962,19975,20012,20016,20019,20029,20058,20062,20076,20109,20116,20123,20127,20133,20137,20149,20153,20154,20181,20189,20223,20259,20273,20288,20291,20295,20298,20307,20323,20326,20349,20355,20367,20380,20398,20402,20403,20432,20442,20444,20455,20488,20517,20524,20542,20586,20587,20609,20611,20614,20621,20629,20649,20651,20660,20665,20705,20707,20714,20721,20726,20738,20744,20764,20790,20797,20807,20820,20875,20878,20880,20884,20896,20906,20923,20941,20942,20945,20947,20962,20967,20977,20980,20993,20996,21012,21046,21049,21101,21115,21142,21165,21171,21186,21198,21213,21226,21238,21240,21245,21251,21253,21255,21274,21292,21305,21308,21312,21322,21331,21350,21372,21402,21420,21430,21450,21458,21469,21472,21477,21481,21498,21504,21512,21519,21539,21541,21544,21554,21576,21584,21586,21611,21616,21637,21640,21668,21709,21734,21739,21748,21755,21758,21781,21851,21866,21882,21897,21916,21921,21952,22008,22010,22021,22023,22038,22045,22064,22066,22084,22087,22092,22100,22153,22165,22171,22188,22192,22198,22216,22237,22238,22250,22252,22267,22271,22285,22289,22290,22295,22307,22312,22318,22322,22334,22337,22341,22359,22371,22388,22395,22402,22408,22439,22454,22455,22458,22469,22476,22478,22480,22500,22503,22509,22543,22557,22587,22602,22610,22614,22649,22688,22708,22725,22732,22738,22741,22750,22751,22794,22802,22803,22820,22831,22852,22856,22876,22877,22885,22888,22891,22901,22924,22931,22935,22943,22986,23023,23028,23038,23041,23046,23061,23064,23070,23078,23097,23100,23107,23122,23125,23130,23131,23135,23148,23188,23210,23214,23219,23236,23243,23253,23258,23259,23299,23305,23312,23340,23342,23367,23419,23428,23433,23438,23442,23444,23449,23469,23484,23485,23489,23521,23527,23541,23551,23567,23575,23592,23595,23613,23615,23617,23631,23635,23649,23657,23665,23680,23693,23697,23716,23722,23729,23767,23777,23793,23811,23849,23852,23855,23861,23869,23899,23915,23926,23955,23956,23961,23964,23967,23973,23984,23985,23992,24077,24088,24100,24105,24111,24121,24135,24158,24166,24198,24200,24229,24282,24289,24295,24304,24322,24337,24375,24397,24433,24440,24456,24458,24475,24498,24513,24532,24535,24536,24574,24607,24614,24616,24632,24658,24660,24664,24668,24675,24677,24691,24692,24695,24707,24713,24716,24722,24737,24748,24765,24767,24768,24780,24783,24784,24789,24814,24819,24823,24830,24831,24838,24839,24853,24872,24881,24907,24924,24944,24958,24988,25004,25048,25080,25093,25123,25135,25155,25174,25178,25183,25205,25206,25212,25241,25268,25277,25310,25312,25342,25343,25344,25349,25361,25365,25374,25397,25415,25417,25421,25441,25443,25449,25460,25474,25488,25491,25541,25553,25557,25560,25595,25635,25657,25664,25668,25709,25755,25797,25807,25847,25870,25946,25958,25969,25990,26020,26048,26159,26161,26166,26167,26179,26228,26230,26249,26250,26256,26274,26282,26288,26295,26305,26317,26363,26369,26499,26508,26543,26563,26564,26570,26590,26620,26636,26689,26726,26760,26779,26818,26860,26901,26986,26989,27008,27075,27084,27125,27131,27138,27245,27261,27314,27362,27363,27427,27438,27441,27472,27491,27557,27574,27592,27790,27949,27968,28005,28033,28107,28114,28128,28192,28250,28254,28303,28313,28318,28327,28339,28430,28548,28557,28563,28575,28581,28621,28630,28682,28764,28771,28803,28807,28837,28872,28943,28950,29022,29172,29210,29250,29281,29319,29332,29355,29358,29382,29438,29443,29476,29509,29510,29512,29625,29626,29653,29694,29695,29711,29846,29863,29868,29924,29926,29936,30285,30433,30434,30622,31684,31697,31890,33877,35000,35632,35646,35660,35661,35727,35741,35760,35762,35777,35814,35846,36321,36336,36378,36889,37577,39333,39384,39465,39467,39483,39542,39558,39642,39646,39666,39698,39710,39819,39866,40116,40145,40224,40259,40271,40355,40651,40813,40875,40922,40984,41239,41350,41364,41984,41985,42314,42384,42570,44197,44442)
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 | 1587 | 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.03 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.32 ms |
System lock | 0.02 ms |
optimizing | 0.36 ms |
statistics | 2.88 ms |
preparing | 1.63 ms |
Sorting result | 0.02 ms |
executing | 0.10 ms |
Sending data | 0.35 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 |