Tiempo de la consulta: 12.03 ms Después de la última consulta: 2.24 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 4.482 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 04:40:56')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 04:40: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,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,49,58,70,71,72,73,75,126,127,128,154,165,174,197,204,253,255,263,272,275,294,332,344,353,446,458,478,481,484,505,507,510,521,549,550,551,558,581,583,593,607,608,611,618,667,671,686,695,705,709,723,724,726,729,735,757,801,819,845,860,868,879,882,892,895,900,911,915,916,917,955,961,968,973,986,1010,1015,1027,1033,1046,1053,1056,1057,1059,1078,1080,1094,1124,1134,1140,1158,1183,1186,1198,1204,1207,1210,1214,1226,1234,1235,1238,1240,1304,1308,1335,1339,1347,1504,1519,1587,1594,1697,1787,1823,1883,2024,2094,2150,2181,2195,2290,2293,2305,2371,2482,2566,2726,2758,2797,2886,2887,2964,3022,3193,3208,3295,3306,3353,3393,3442,3447,3452,3491,3495,3546,3591,3604,3620,3626,3634,3696,3700,3706,3732,3769,3837,3862,3864,3880,3898,3918,3976,3986,4004,4092,4096,4114,4163,4209,4258,4276,4281,4410,4459,4515,4580,4625,4631,4640,4739,4765,4767,4790,4813,4920,4932,4973,5001,5018,5051,5085,5150,5154,5247,5300,5306,5365,5438,5451,5559,5634,5647,5648,5659,5660,5686,5726,5727,5730,5798,5894,5918,5924,6038,6062,6068,6137,6141,6186,6245,6278,6279,6294,6311,6330,6339,6367,6415,6426,6448,6463,6471,6475,6476,6477,6503,6520,6534,6542,6543,6545,6548,6583,6604,6605,6616,6639,6643,6703,6708,6742,6764,6793,6804,6842,6888,6889,6918,6936,6939,6945,6994,7005,7185,7245,7249,7277,7285,7327,7337,7338,7346,7368,7412,7413,7417,7449,7457,7458,7463,7484,7489,7492,7513,7516,7551,7577,7583,7584,7618,7666,7683,7711,7718,7720,7730,7741,7757,7764,7802,7806,7829,7837,7840,7847,7859,7871,7901,7934,7941,7950,7955,7962,7964,7965,7980,7987,7994,8024,8026,8027,8073,8074,8114,8138,8177,8223,8258,8351,8381,8460,8499,8565,8566,8568,8587,8610,8615,8689,8759,8780,8860,8916,8917,8932,8973,9010,9073,9181,9254,9257,9351,9398,9412,9472,9495,9631,9704,9734,9745,9792,9820,9832,9853,9864,9886,9891,9927,9945,9956,10026,10051,10110,10120,10149,10180,10195,10199,10207,10216,10228,10237,10248,10260,10268,10274,10278,10282,10304,10328,10364,10369,10384,10385,10401,10414,10435,10464,10478,10499,10537,10554,10628,10659,10666,10686,10696,10713,10769,10833,10857,10888,10894,10912,10924,10932,10971,10978,10982,10986,11003,11006,11009,11027,11032,11043,11065,11073,11076,11080,11083,11091,11108,11122,11123,11127,11143,11146,11150,11157,11224,11238,11263,11264,11290,11309,11320,11328,11370,11377,11383,11388,11407,11424,11438,11473,11487,11497,11534,11538,11585,11587,11614,11666,11680,11713,11716,11721,11727,11730,11762,11775,11839,11848,11870,11879,11900,11915,11925,11926,11944,11987,12011,12018,12032,12036,12038,12040,12042,12069,12085,12091,12098,12108,12109,12115,12126,12131,12133,12136,12152,12186,12212,12218,12237,12248,12251,12306,12307,12317,12319,12362,12369,12370,12393,12415,12448,12449,12463,12474,12493,12514,12548,12554,12557,12576,12588,12604,12608,12636,12670,12672,12673,12676,12684,12717,12723,12735,12738,12758,12761,12808,12834,12848,12849,12852,12868,12902,12903,12910,12916,12959,12960,12991,13020,13081,13107,13115,13132,13141,13143,13172,13176,13188,13190,13191,13198,13222,13231,13246,13250,13259,13309,13331,13345,13346,13359,13379,13396,13418,13425,13433,13434,13440,13446,13456,13481,13543,13573,13594,13595,13600,13609,13611,13621,13627,13631,13646,13662,13664,13671,13673,13674,13675,13677,13695,13697,13702,13703,13705,13706,13707,13708,13713,13715,13731,13734,13741,13742,13753,13788,13838,13860,13867,13869,13883,13892,13920,13933,13951,13972,13986,13994,14005,14040,14057,14062,14070,14073,14078,14080,14092,14097,14101,14104,14114,14133,14141,14150,14175,14184,14196,14198,14199,14204,14205,14222,14227,14229,14232,14234,14236,14249,14267,14268,14270,14273,14278,14281,14282,14305,14314,14331,14339,14341,14348,14355,14368,14378,14385,14408,14421,14451,14452,14456,14469,14471,14480,14482,14486,14493,14495,14502,14505,14522,14531,14563,14572,14574,14600,14616,14624,14632,14637,14652,14654,14657,14684,14691,14692,14694,14699,14732,14746,14747,14770,14794,14796,14798,14799,14807,14815,14827,14842,14846,14931,14941,14955,14960,14980,14981,14982,14993,15002,15006,15028,15060,15069,15092,15100,15105,15107,15108,15115,15120,15123,15146,15147,15148,15175,15180,15196,15206,15215,15217,15226,15243,15245,15257,15263,15266,15277,15284,15293,15299,15303,15304,15325,15330,15343,15344,15349,15356,15358,15370,15371,15389,15402,15403,15410,15411,15417,15439,15443,15464,15470,15475,15477,15483,15485,15492,15497,15500,15513,15518,15521,15522,15524,15543,15548,15551,15562,15565,15576,15577,15580,15588,15604,15609,15631,15632,15633,15637,15639,15641,15642,15656,15664,15668,15689,15703,15709,15725,15728,15731,15733,15745,15750,15762,15763,15788,15789,15811,15832,15835,15837,15840,15841,15866,15873,15878,15879,15893,15954,15955,15964,16020,16024,16037,16050,16052,16053,16059,16093,16153,16156,16163,16166,16167,16169,16209,16217,16257,16261,16279,16280,16295,16320,16328,16336,16342,16353,16356,16358,16359,16368,16369,16370,16389,16404,16415,16436,16442,16447,16451,16458,16507,16513,16515,16518,16539,16604,16605,16613,16619,16627,16640,16644,16645,16659,16662,16663,16682,16685,16688,16722,16749,16778,16792,16820,16825,16827,16829,16845,16864,16866,16867,16893,16909,16996,17005,17048,17059,17072,17090,17115,17128,17130,17132,17146,17149,17158,17185,17194,17205,17214,17221,17227,17228,17234,17243,17244,17247,17257,17269,17277,17280,17291,17294,17322,17337,17346,17373,17382,17390,17392,17407,17420,17424,17432,17436,17438,17441,17452,17460,17464,17465,17485,17487,17488,17493,17498,17512,17517,17518,17533,17536,17537,17551,17552,17557,17565,17569,17574,17596,17600,17620,17623,17626,17633,17650,17654,17679,17681,17688,17701,17705,17724,17730,17733,17747,17753,17759,17761,17766,17772,17774,17775,17781,17783,17813,17816,17822,17824,17839,17844,17852,17874,17875,17880,17885,17889,17890,17892,17895,17908,17912,17918,17923,17925,17935,17938,17951,17952,17956,17966,17973,17980,17987,17991,17993,17998,18000,18007,18018,18031,18032,18038,18055,18057,18072,18100,18102,18116,18123,18134,18138,18140,18156,18160,18169,18179,18185,18200,18216,18220,18221,18231,18238,18239,18240,18259,18260,18261,18277,18282,18300,18303,18304,18311,18314,18315,18316,18331,18345,18352,18353,18355,18356,18364,18366,18368,18370,18375,18390,18396,18401,18402,18425,18431,18434,18435,18436,18440,18445,18453,18481,18492,18493,18499,18505,18514,18520,18524,18528,18537,18543,18562,18564,18566,18569,18580,18583,18584,18593,18599,18643,18646,18649,18659,18667,18668,18679,18686,18687,18732,18733,18738,18744,18750,18764,18765,18773,18781,18792,18793,18813,18821,18829,18837,18846,18853,18874,18882,18891,18895,18909,18914,18920,18930,18936,18949,18951,18952,18960,18972,18973,18978,18985,18991,18993,19013,19018,19026,19027,19041,19043,19053,19059,19063,19065,19073,19078,19083,19092,19100,19106,19117,19119,19133,19134,19136,19147,19151,19168,19172,19175,19179,19191,19205,19208,19217,19219,19223,19224,19237,19242,19247,19260,19271,19285,19290,19292,19293,19304,19309,19312,19313,19318,19329,19352,19371,19381,19405,19408,19409,19411,19415,19417,19422,19427,19428,19429,19436,19437,19448,19457,19492,19497,19503,19505,19508,19519,19526,19535,19545,19553,19556,19562,19567,19571,19576,19578,19585,19589,19595,19596,19602,19604,19606,19612,19619,19623,19626,19643,19645,19646,19666,19667,19671,19682,19697,19699,19700,19701,19713,19720,19728,19741,19744,19748,19752,19758,19764,19769,19778,19780,19790,19806,19825,19829,19841,19853,19874,19880,19882,19894,19905,19913,19925,19944,19952,19953,19957,19962,19970,20008,20012,20016,20019,20029,20035,20062,20076,20098,20109,20117,20123,20133,20137,20149,20153,20154,20158,20166,20181,20204,20205,20223,20233,20259,20273,20282,20291,20295,20298,20299,20305,20307,20323,20326,20328,20332,20333,20344,20349,20352,20355,20359,20367,20380,20398,20399,20402,20403,20419,20420,20432,20442,20444,20455,20457,20476,20487,20488,20489,20517,20524,20537,20542,20543,20554,20586,20587,20608,20611,20614,20621,20629,20649,20651,20665,20684,20705,20707,20712,20714,20721,20726,20738,20744,20748,20764,20780,20782,20797,20807,20809,20811,20820,20841,20875,20877,20878,20880,20884,20886,20896,20906,20912,20923,20941,20942,20945,20956,20962,20967,20974,20977,20980,20993,21012,21013,21017,21046,21055,21067,21073,21085,21086,21101,21108,21115,21121,21128,21133,21142,21149,21163,21165,21171,21181,21186,21198,21213,21226,21231,21240,21245,21248,21251,21255,21258,21274,21292,21308,21310,21312,21322,21324,21331,21372,21387,21388,21396,21402,21420,21430,21450,21458,21472,21477,21481,21482,21498,21504,21512,21519,21539,21541,21542,21544,21547,21552,21554,21566,21576,21584,21586,21611,21616,21628,21637,21645,21665,21668,21669,21683,21689,21709,21713,21716,21734,21739,21742,21748,21750,21755,21758,21763,21781,21851,21859,21866,21871,21878,21882,21897,21903,21916,21921,21922,21952,21967,21994,22010,22021,22023,22029,22031,22038,22045,22053,22064,22065,22066,22084,22087,22088,22092,22100,22110,22122,22125,22137,22153,22165,22171,22177,22188,22192,22198,22216,22219,22223,22233,22237,22238,22250,22252,22266,22271,22285,22289,22290,22292,22295,22307,22316,22318,22322,22334,22336,22337,22341,22371,22380,22388,22402,22404,22408,22422,22439,22455,22458,22469,22476,22478,22479,22480,22485,22493,22498,22500,22503,22509,22543,22546,22553,22557,22587,22602,22610,22614,22668,22671,22681,22688,22691,22702,22708,22714,22723,22725,22732,22738,22741,22744,22745,22750,22779,22786,22794,22803,22820,22822,22831,22834,22852,22856,22857,22873,22876,22885,22888,22891,22898,22901,22918,22924,22931,22935,22936,22943,22998,23013,23023,23026,23028,23038,23041,23046,23047,23061,23063,23064,23070,23073,23077,23078,23100,23107,23122,23130,23131,23135,23148,23153,23181,23188,23202,23210,23219,23224,23236,23243,23253,23258,23259,23260,23278,23288,23299,23305,23310,23312,23319,23338,23342,23346,23382,23400,23419,23424,23428,23433,23441,23442,23449,23468,23469,23484,23485,23489,23516,23518,23521,23524,23541,23543,23551,23567,23575,23584,23592,23595,23613,23615,23617,23624,23631,23635,23649,23657,23666,23667,23672,23680,23686,23697,23705,23708,23722,23726,23729,23731,23749,23756,23767,23769,23777,23780,23793,23811,23852,23855,23861,23873,23876,23899,23911,23915,23926,23956,23959,23961,23964,23967,23973,23984,23985,23987,23989,23992,24002,24077,24082,24088,24105,24111,24114,24121,24135,24158,24166,24190,24198,24200,24201,24210,24213,24229,24273,24282,24288,24289,24295,24304,24322,24332,24337,24340,24375,24432,24433,24440,24456,24458,24475,24485,24498,24513,24532,24536,24567,24574,24593,24607,24612,24614,24616,24630,24632,24636,24642,24657,24658,24660,24664,24665,24671,24672,24673,24675,24681,24691,24695,24707,24713,24722,24734,24737,24748,24765,24768,24783,24784,24789,24790,24807,24814,24819,24823,24830,24831,24836,24838,24839,24845,24853,24881,24887,24907,24922,24924,24944,24945,24958,24967,24988,25004,25038,25039,25041,25048,25080,25093,25103,25123,25135,25137,25146,25155,25163,25174,25178,25183,25200,25205,25206,25212,25218,25241,25258,25268,25277,25312,25315,25342,25344,25349,25353,25361,25365,25373,25374,25380,25394,25397,25415,25417,25421,25449,25460,25461,25469,25474,25483,25488,25491,25513,25528,25540,25541,25548,25553,25554,25557,25583,25595,25600,25635,25657,25663,25668,25709,25725,25746,25753,25755,25790,25797,25813,25822,25847,25870,25911,25946,25952,25958,25969,25990,26020,26048,26062,26073,26116,26157,26159,26161,26166,26174,26178,26179,26186,26191,26207,26209,26225,26228,26236,26247,26249,26250,26255,26256,26271,26274,26282,26288,26295,26305,26317,26322,26344,26355,26363,26369,26387,26392,26420,26432,26434,26452,26481,26508,26522,26543,26560,26562,26563,26564,26570,26574,26590,26594,26598,26620,26636,26689,26701,26726,26760,26779,26780,26818,26824,26860,26897,26901,26924,26934,26936,26986,27024,27028,27040,27075,27084,27085,27096,27125,27127,27130,27131,27138,27261,27279,27314,27315,27355,27362,27363,27368,27390,27391,27403,27420,27427,27441,27442,27472,27482,27563,27574,27592,27724,27739,27790,27833,27893,27898,27938,27949,27968,28005,28033,28107,28114,28116,28128,28135,28185,28192,28242,28250,28254,28294,28303,28311,28313,28318,28320,28327,28425,28436,28539,28548,28557,28559,28563,28575,28581,28609,28617,28621,28630,28651,28712,28714,28715,28763,28764,28771,28780,28795,28803,28807,28837,28850,28872,28943,28950,28992,29012,29022,29034,29089,29172,29210,29244,29250,29281,29319,29332,29348,29355,29358,29381,29382,29413,29438,29445,29467,29476,29486,29499,29509,29510,29512,29550,29551,29625,29653,29658,29683,29694,29695,29711,29788,29801,29832,29837,29839,29846,29863,29868,29872,29896,29897,29915,29918,30285,30414,30433,30434,30941,31090,31510,31697,31837,31890,33270,33385,33877,34150,35000,35660,35661,35690,35727,35777,35814,36141,36244,36798,36821,36889,36975,38887,39283,39320,39333,39342,39384,39464,39465,39483,39542,39558,39642,39646,39666,39698,39710,39819,39846,39866,39877,40064,40110,40116,40145,40224,40259,40271,40355,40490,40515,40521,40651,40672,40813,40861,40875,40909,40922,40984,41038,41058,41069,41104,41239,41292,41350,41364)
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 | 2258 | 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.12 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.48 ms |
System lock | 0.02 ms |
optimizing | 0.14 ms |
statistics | 7.15 ms |
preparing | 1.94 ms |
Sorting result | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.52 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.11 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 |