Tiempo de la consulta: 8.98 ms Después de la última consulta: 1.78 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 4.384 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 01:31:18')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-08 01:31:18')
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(1,11,17,49,58,61,83,131,134,136,137,154,204,225,247,255,282,321,323,324,325,332,334,353,385,446,452,456,458,459,474,478,485,489,497,510,511,512,521,529,531,537,542,547,558,560,566,567,583,593,607,609,618,622,633,669,671,672,681,686,695,701,708,723,729,733,756,757,760,771,776,796,797,802,805,806,816,845,850,858,861,864,868,879,886,889,897,905,911,915,924,928,933,952,955,977,983,986,1010,1021,1027,1033,1040,1044,1047,1057,1062,1087,1094,1105,1130,1158,1169,1185,1186,1205,1207,1210,1214,1226,1234,1236,1240,1248,1252,1253,1265,1277,1317,1330,1335,1339,1347,1402,1491,1554,1563,1594,1600,1612,1664,1683,1698,1712,1717,1744,1750,1768,1770,1784,1849,1917,1949,1964,1999,2043,2094,2102,2394,2433,2485,2633,2733,2739,2788,2859,2875,2964,3022,3071,3082,3085,3099,3126,3251,3259,3271,3295,3299,3353,3409,3425,3520,3546,3634,3668,3696,3706,3832,3864,3869,3873,3884,3898,3932,3940,3963,3988,3993,4029,4063,4082,4096,4116,4153,4163,4276,4281,4309,4355,4378,4409,4410,4434,4436,4445,4453,4471,4502,4516,4560,4583,4692,4710,4765,4780,4790,4801,4854,4880,4901,5001,5063,5085,5136,5183,5190,5195,5227,5263,5300,5306,5328,5363,5515,5529,5575,5632,5646,5647,5648,5659,5694,5785,5811,5870,5894,5895,5904,5918,5994,6021,6068,6150,6448,6475,6498,6501,6520,6546,6598,6616,6669,6681,6688,6703,6752,6775,6799,6806,6809,6828,6834,6857,6884,6908,6913,6916,6923,6941,6960,6994,7012,7014,7053,7054,7105,7172,7173,7175,7212,7243,7245,7269,7273,7276,7277,7285,7291,7327,7338,7343,7346,7348,7374,7407,7418,7443,7449,7451,7461,7462,7486,7513,7516,7546,7551,7567,7577,7583,7591,7595,7615,7644,7666,7719,7722,7730,7744,7751,7757,7764,7797,7829,7840,7871,7901,7965,7967,7980,7981,7996,8022,8027,8053,8054,8106,8138,8148,8161,8177,8188,8258,8296,8325,8351,8387,8390,8417,8445,8492,8505,8506,8610,8663,8692,8716,8852,8864,8909,8973,9004,9011,9155,9193,9252,9253,9254,9378,9472,9473,9501,9525,9531,9532,9573,9580,9648,9708,9734,9766,9772,9779,9831,9832,9840,9886,9889,9891,9956,10024,10050,10077,10079,10092,10129,10149,10197,10198,10199,10207,10266,10278,10290,10298,10303,10350,10354,10364,10401,10415,10449,10464,10486,10494,10499,10518,10537,10557,10690,10731,10806,10818,10831,10833,10900,10927,10932,10942,10967,10986,11009,11027,11043,11062,11087,11114,11150,11182,11198,11206,11238,11263,11273,11336,11377,11417,11419,11432,11441,11447,11468,11473,11494,11538,11542,11666,11672,11680,11685,11692,11709,11713,11716,11775,11840,11870,11879,11880,11926,12011,12024,12025,12036,12042,12069,12085,12131,12136,12152,12162,12168,12204,12216,12297,12317,12319,12338,12362,12363,12366,12370,12387,12410,12439,12443,12448,12475,12477,12482,12490,12509,12514,12567,12588,12604,12615,12625,12636,12663,12670,12676,12685,12714,12738,12745,12757,12758,12786,12810,12849,12892,12910,12913,12920,12926,12960,12963,12965,12977,12983,13004,13014,13036,13079,13107,13132,13152,13209,13222,13235,13250,13269,13279,13287,13297,13317,13345,13359,13379,13387,13396,13420,13436,13440,13446,13481,13553,13579,13594,13651,13664,13697,13708,13722,13729,13753,13892,13929,13959,13985,14011,14014,14040,14061,14069,14078,14083,14092,14109,14133,14134,14139,14175,14186,14197,14198,14199,14205,14227,14234,14252,14268,14290,14302,14305,14338,14355,14368,14378,14417,14421,14426,14451,14480,14493,14502,14505,14508,14516,14531,14548,14557,14583,14591,14596,14610,14620,14637,14654,14684,14688,14691,14699,14701,14722,14769,14774,14778,14798,14840,14884,14895,14926,14930,14954,14955,14979,14982,15002,15038,15060,15065,15092,15105,15107,15109,15114,15115,15123,15144,15148,15180,15206,15217,15223,15226,15227,15245,15250,15256,15257,15261,15284,15297,15299,15304,15325,15344,15358,15371,15392,15403,15410,15417,15430,15441,15443,15445,15450,15455,15483,15484,15489,15492,15500,15563,15566,15577,15580,15583,15601,15609,15615,15632,15637,15639,15640,15642,15656,15670,15706,15733,15745,15755,15760,15762,15766,15788,15811,15832,15835,15840,15877,15878,15879,15884,15892,15909,15913,15916,15917,15954,15966,15999,16014,16024,16052,16053,16054,16088,16125,16148,16156,16167,16187,16192,16217,16261,16277,16279,16295,16311,16313,16323,16328,16336,16353,16359,16368,16389,16404,16410,16417,16436,16447,16458,16470,16518,16542,16554,16555,16558,16589,16607,16609,16613,16620,16627,16635,16642,16659,16662,16682,16691,16698,16712,16717,16739,16778,16792,16815,16820,16831,16843,16863,16866,16872,16891,16893,16909,16928,16940,16964,16968,16996,17001,17043,17059,17064,17071,17072,17149,17153,17158,17169,17185,17186,17189,17209,17214,17232,17247,17248,17269,17280,17287,17299,17300,17341,17346,17354,17364,17381,17390,17403,17417,17424,17437,17441,17450,17452,17460,17463,17485,17498,17500,17512,17513,17536,17574,17596,17597,17598,17617,17620,17622,17630,17633,17650,17689,17701,17703,17705,17729,17733,17748,17752,17753,17759,17761,17772,17774,17782,17783,17784,17786,17788,17808,17816,17824,17844,17885,17907,17918,17951,17954,17973,17978,17981,17990,17997,18001,18003,18004,18019,18027,18055,18068,18072,18076,18102,18141,18158,18160,18176,18179,18203,18211,18217,18220,18221,18231,18235,18238,18260,18262,18263,18277,18300,18304,18311,18315,18337,18345,18352,18353,18361,18366,18401,18415,18427,18434,18435,18447,18455,18467,18485,18498,18503,18507,18520,18527,18534,18537,18542,18547,18552,18564,18565,18576,18581,18586,18587,18591,18619,18622,18642,18643,18647,18648,18676,18702,18705,18716,18732,18744,18750,18778,18792,18800,18801,18808,18809,18821,18835,18839,18846,18847,18850,18853,18879,18898,18909,18920,18931,18936,18937,18946,18957,18960,18972,18973,18980,18986,18993,18997,19027,19048,19049,19060,19063,19093,19106,19120,19134,19136,19145,19151,19172,19179,19180,19184,19191,19196,19205,19216,19217,19218,19222,19224,19247,19251,19270,19276,19285,19302,19303,19309,19313,19316,19331,19340,19352,19364,19377,19383,19405,19413,19419,19422,19433,19437,19440,19453,19455,19457,19473,19481,19484,19492,19494,19504,19514,19518,19522,19545,19552,19556,19562,19565,19566,19575,19580,19586,19587,19593,19604,19606,19619,19625,19626,19651,19655,19665,19666,19670,19697,19720,19730,19733,19741,19748,19752,19755,19763,19766,19778,19779,19790,19805,19806,19811,19826,19864,19874,19925,19942,19944,19955,19957,19973,19983,19987,19999,20002,20007,20008,20035,20042,20048,20076,20083,20091,20098,20104,20117,20146,20154,20155,20158,20166,20167,20199,20204,20205,20208,20209,20229,20233,20236,20278,20279,20282,20299,20303,20305,20315,20328,20329,20332,20333,20344,20352,20359,20362,20366,20384,20393,20399,20419,20420,20422,20425,20427,20457,20468,20479,20487,20489,20537,20554,20559,20570,20574,20585,20605,20608,20630,20691,20712,20724,20753,20761,20765,20769,20774,20776,20780,20782,20795,20799,20817,20826,20835,20841,20876,20877,20886,20890,20912,20915,20933,20935,20948,20950,20956,20960,20974,20991,21013,21017,21035,21042,21055,21067,21075,21085,21086,21089,21105,21108,21110,21116,21121,21128,21129,21133,21136,21149,21152,21163,21181,21184,21200,21231,21242,21258,21289,21291,21293,21302,21324,21335,21341,21361,21366,21378,21387,21396,21412,21415,21421,21429,21452,21465,21482,21494,21518,21528,21540,21542,21547,21566,21583,21603,21604,21606,21609,21628,21632,21647,21652,21659,21662,21665,21683,21689,21702,21711,21713,21714,21716,21729,21742,21749,21750,21766,21770,21775,21777,21844,21849,21859,21864,21878,21895,21908,21930,21967,21986,21994,22031,22036,22053,22055,22058,22074,22088,22089,22118,22122,22126,22137,22177,22191,22219,22225,22248,22260,22266,22268,22292,22316,22321,22327,22342,22345,22350,22366,22378,22380,22382,22395,22419,22428,22431,22485,22493,22498,22502,22520,22530,22546,22553,22559,22594,22607,22621,22623,22666,22668,22671,22681,22691,22693,22709,22715,22740,22744,22753,22766,22779,22786,22793,22804,22822,22834,22843,22850,22857,22873,22875,22898,22903,22906,22918,22920,22921,22922,22927,22932,22933,22934,22935,22936,22967,22976,22978,22998,23002,23004,23006,23013,23015,23017,23026,23027,23032,23047,23050,23080,23084,23090,23102,23103,23126,23136,23151,23166,23174,23181,23202,23213,23215,23224,23260,23271,23278,23288,23295,23310,23317,23319,23338,23343,23353,23354,23373,23380,23396,23397,23400,23411,23412,23417,23445,23457,23460,23466,23468,23477,23481,23495,23503,23505,23512,23516,23520,23531,23543,23544,23548,23569,23584,23624,23633,23634,23645,23646,23651,23652,23659,23665,23666,23667,23677,23686,23693,23695,23705,23719,23726,23731,23732,23740,23756,23761,23768,23780,23782,23792,23806,23815,23816,23827,23855,23859,23866,23869,23872,23873,23874,23876,23894,23911,23914,23958,23965,23989,23995,23998,24001,24002,24059,24068,24082,24114,24134,24137,24154,24171,24189,24190,24201,24207,24210,24212,24258,24260,24299,24315,24340,24365,24373,24391,24431,24432,24437,24438,24439,24442,24470,24485,24511,24543,24565,24567,24608,24630,24657,24659,24671,24672,24673,24681,24718,24719,24734,24754,24780,24790,24806,24807,24836,24845,24851,24857,24882,24887,24905,24922,24927,24942,24945,24960,24967,24986,24995,24998,25033,25038,25041,25061,25064,25090,25103,25104,25119,25134,25137,25141,25143,25146,25163,25170,25193,25199,25200,25207,25218,25252,25258,25260,25271,25281,25314,25315,25316,25345,25353,25356,25366,25373,25379,25380,25435,25461,25469,25470,25471,25474,25483,25486,25490,25502,25512,25513,25540,25554,25583,25595,25600,25615,25616,25626,25650,25663,25693,25735,25742,25746,25749,25753,25768,25778,25782,25790,25813,25822,25886,25911,25952,26073,26101,26103,26116,26140,26157,26165,26174,26191,26197,26207,26209,26218,26225,26236,26238,26246,26247,26257,26271,26293,26322,26323,26324,26338,26344,26355,26375,26387,26389,26392,26398,26412,26420,26431,26432,26434,26450,26452,26479,26481,26513,26522,26541,26548,26560,26562,26577,26589,26594,26598,26605,26612,26637,26654,26672,26701,26744,26776,26780,26792,26835,26842,26843,26857,26864,26897,26909,26919,26924,26933,26934,26936,26939,26941,26954,27008,27015,27020,27024,27028,27040,27055,27059,27075,27076,27083,27085,27087,27093,27096,27104,27127,27149,27184,27197,27244,27248,27279,27305,27355,27356,27368,27390,27403,27420,27438,27442,27453,27477,27488,27563,27566,27572,27646,27720,27724,27737,27739,27761,27822,27832,27892,27893,27898,27911,27921,27923,27924,27926,27991,28116,28135,28157,28169,28185,28242,28294,28316,28539,28609,28617,28651,28712,28714,28715,28910,28922,28925,29023,29034,29089,29123,29223,29235,29348,29380,29381,29413,29445,29466,29467,29499,29550,29551,29584,29611,29658,29683,29777,29788,29801,29814,29834,29837,29839,29864,29872,29896,29897,29909,29915,29918,30111,30280,30414,30941,31090,31510,31640,31663,31837,31908,32136,33385,33932,34150,35628,35632,35638,35667,35713,35730,35741,35744,35759,35784,35803,35812,35921,35989,36017,36041,36141,36178,36235,36310,36633,36949,36958,37497,38800,38816,38817,38833,38845,38852,38884,38887,38897,38898,38916,38932,38960,38985,38987,39178,39318,39342,39369,39527,39588,39600,39614,39645,39653,39820,39846,39858,39877,39941,39972,39998,40048,40050,40064,40214,40332,40414,40521,40672,40684,40706,40861,40877,40909,41104,41337,41363)
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 | 1912 | 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.10 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.44 ms |
System lock | 0.05 ms |
optimizing | 0.17 ms |
statistics | 3.80 ms |
preparing | 1.98 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.50 ms |
end | 0.01 ms |
query end | 0.18 ms |
closing tables | 0.02 ms |
freeing items | 0.12 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 |