Tiempo de la consulta: 8.32 ms Después de la última consulta: 1.62 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.249 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 10:15:14')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 10:15:14')
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,154,204,255,325,332,353,385,398,405,441,446,452,456,458,459,474,478,485,489,497,510,512,521,529,530,531,537,540,542,547,558,560,566,567,583,593,607,618,622,633,671,672,681,686,695,723,729,756,757,760,771,776,796,797,802,805,806,816,845,850,858,861,864,868,879,886,889,905,911,915,924,928,933,955,977,983,986,1010,1021,1027,1033,1040,1057,1062,1087,1094,1158,1185,1186,1202,1205,1207,1210,1214,1226,1234,1240,1248,1252,1253,1265,1277,1335,1339,1347,1402,1491,1563,1594,1600,1612,1664,1683,1698,1712,1717,1744,1768,1770,1784,1849,1866,1917,1949,1964,1999,2094,2102,2372,2433,2591,2633,2733,2739,2788,2875,2964,3022,3082,3085,3097,3251,3252,3259,3271,3295,3299,3353,3408,3409,3425,3520,3546,3633,3696,3698,3706,3832,3864,3869,3873,3884,3898,3932,3940,3963,3971,3974,3980,3988,3993,4063,4082,4096,4116,4117,4153,4163,4276,4281,4309,4327,4346,4355,4409,4410,4434,4436,4445,4453,4471,4502,4527,4560,4692,4765,4780,4790,4801,4854,4901,4987,5001,5063,5085,5136,5183,5190,5194,5227,5300,5306,5328,5363,5366,5457,5504,5515,5529,5575,5632,5646,5647,5648,5659,5694,5811,5894,5895,5904,5918,5994,6021,6068,6325,6399,6406,6448,6498,6501,6514,6520,6585,6598,6621,6681,6688,6703,6752,6775,6806,6809,6817,6828,6831,6834,6857,6884,6908,6916,6941,6960,6994,7009,7012,7032,7034,7053,7054,7105,7131,7149,7172,7173,7175,7212,7243,7273,7276,7277,7285,7327,7338,7346,7348,7374,7381,7407,7418,7422,7443,7449,7462,7513,7516,7534,7538,7551,7558,7567,7577,7583,7591,7595,7642,7644,7666,7700,7722,7724,7730,7732,7733,7751,7757,7764,7793,7797,7813,7829,7830,7838,7840,7871,7874,7901,7965,7980,7996,8027,8053,8092,8106,8138,8142,8148,8161,8177,8188,8209,8210,8254,8258,8264,8270,8280,8282,8287,8296,8309,8312,8317,8325,8351,8382,8387,8390,8395,8417,8445,8474,8492,8505,8506,8585,8610,8663,8700,8705,8716,8772,8851,8852,8855,8862,8864,8874,8881,8967,8973,8975,9001,9004,9011,9027,9124,9130,9155,9193,9252,9253,9254,9265,9291,9313,9337,9406,9441,9472,9473,9501,9525,9531,9532,9548,9573,9580,9589,9611,9648,9668,9708,9732,9734,9766,9772,9801,9831,9832,9840,9886,9889,9891,9905,9949,9956,10024,10050,10052,10061,10077,10079,10129,10149,10168,10197,10198,10199,10207,10266,10269,10278,10290,10298,10303,10326,10350,10364,10401,10449,10464,10486,10494,10498,10499,10518,10537,10557,10575,10585,10609,10675,10690,10731,10786,10806,10818,10831,10833,10900,10932,10942,10967,10986,11009,11027,11043,11087,11150,11164,11182,11198,11238,11263,11273,11360,11377,11431,11447,11473,11494,11538,11542,11599,11658,11661,11666,11672,11680,11685,11692,11709,11713,11716,11775,11776,11796,11840,11870,11879,11880,11905,11920,11926,12011,12036,12042,12069,12085,12131,12136,12152,12168,12216,12317,12319,12338,12362,12363,12366,12370,12387,12410,12412,12439,12448,12460,12482,12490,12509,12514,12567,12588,12604,12636,12651,12663,12670,12676,12685,12714,12738,12745,12754,12757,12758,12764,12795,12810,12849,12865,12892,12910,12913,12920,12926,12956,12960,12965,12977,12983,13000,13014,13079,13107,13110,13132,13135,13209,13222,13235,13250,13269,13287,13297,13317,13345,13359,13379,13396,13412,13436,13440,13446,13481,13553,13579,13594,13633,13651,13664,13697,13708,13722,13729,13753,13892,13959,13985,14011,14014,14040,14052,14069,14078,14092,14109,14133,14134,14139,14175,14197,14198,14199,14205,14227,14232,14234,14252,14268,14290,14302,14305,14355,14359,14368,14378,14417,14421,14451,14480,14493,14502,14505,14508,14531,14548,14557,14580,14591,14596,14610,14620,14637,14654,14673,14688,14691,14699,14701,14742,14743,14769,14774,14778,14788,14798,14884,14895,14926,14929,14930,14955,14979,14982,15002,15060,15065,15084,15092,15105,15107,15114,15115,15123,15144,15148,15180,15206,15217,15223,15226,15250,15256,15257,15261,15284,15297,15299,15304,15311,15325,15340,15344,15358,15371,15392,15403,15410,15412,15417,15430,15441,15443,15445,15450,15452,15455,15483,15484,15492,15500,15563,15566,15577,15580,15583,15601,15609,15632,15637,15639,15640,15642,15656,15670,15693,15706,15729,15733,15745,15760,15762,15766,15788,15811,15832,15835,15840,15874,15877,15878,15879,15892,15909,15910,15913,15916,15917,15954,15999,16014,16024,16052,16053,16054,16071,16079,16097,16125,16156,16167,16173,16187,16217,16248,16261,16277,16279,16291,16295,16306,16311,16313,16323,16328,16336,16353,16359,16368,16389,16404,16410,16436,16447,16458,16470,16483,16484,16518,16554,16555,16558,16584,16589,16607,16613,16620,16621,16627,16635,16642,16656,16659,16662,16682,16691,16698,16712,16726,16778,16792,16815,16820,16831,16843,16861,16863,16866,16891,16893,16909,16940,16964,16968,17001,17043,17059,17064,17072,17145,17149,17158,17169,17185,17189,17209,17214,17232,17247,17248,17269,17272,17280,17287,17341,17346,17354,17364,17381,17390,17403,17417,17424,17441,17450,17452,17460,17463,17485,17498,17500,17512,17513,17536,17574,17596,17597,17617,17620,17622,17630,17633,17650,17668,17670,17675,17689,17701,17705,17729,17733,17752,17753,17759,17761,17772,17774,17782,17783,17784,17788,17795,17808,17816,17824,17844,17885,17907,17918,17951,17954,17973,17978,17981,17990,18001,18004,18019,18027,18055,18068,18076,18102,18141,18158,18160,18176,18179,18203,18217,18220,18221,18231,18235,18238,18263,18276,18277,18300,18315,18337,18345,18352,18353,18361,18366,18401,18404,18415,18427,18434,18435,18447,18455,18485,18507,18520,18527,18534,18537,18542,18547,18564,18565,18576,18581,18586,18587,18591,18603,18643,18647,18648,18676,18716,18732,18734,18744,18750,18778,18786,18792,18800,18801,18808,18809,18821,18835,18846,18879,18898,18900,18909,18920,18931,18936,18946,18957,18960,18972,18973,18975,18980,18986,18993,18997,19027,19037,19060,19063,19093,19106,19120,19134,19136,19151,19172,19179,19184,19191,19196,19205,19215,19216,19217,19218,19224,19247,19251,19270,19285,19302,19303,19309,19313,19316,19331,19340,19352,19377,19383,19405,19413,19419,19422,19433,19437,19440,19453,19457,19473,19481,19484,19492,19494,19504,19508,19512,19514,19522,19545,19552,19556,19562,19565,19566,19580,19586,19587,19593,19604,19606,19619,19625,19626,19651,19665,19666,19697,19720,19730,19741,19748,19752,19755,19763,19766,19778,19779,19790,19805,19806,19826,19864,19874,19925,19942,19944,19955,19957,19973,19987,19999,20002,20007,20008,20035,20042,20050,20076,20083,20098,20104,20117,20146,20154,20155,20158,20166,20167,20199,20204,20205,20208,20209,20229,20233,20236,20278,20279,20282,20289,20299,20303,20305,20328,20332,20333,20344,20359,20362,20366,20384,20393,20399,20419,20420,20422,20427,20457,20479,20487,20489,20518,20519,20537,20545,20554,20570,20574,20585,20605,20608,20664,20681,20691,20712,20724,20753,20765,20769,20774,20776,20780,20782,20795,20799,20817,20826,20834,20835,20841,20876,20877,20886,20906,20912,20915,20935,20948,20950,20956,20974,20991,21010,21013,21017,21035,21042,21055,21067,21085,21086,21105,21108,21121,21128,21133,21149,21152,21163,21181,21184,21200,21222,21231,21242,21258,21291,21293,21302,21324,21335,21341,21361,21366,21387,21396,21398,21412,21415,21452,21465,21482,21518,21528,21542,21547,21566,21569,21583,21591,21603,21604,21606,21628,21632,21647,21652,21657,21662,21665,21683,21689,21713,21716,21729,21742,21750,21766,21770,21775,21783,21792,21849,21859,21878,21908,21930,21967,21986,21994,22017,22031,22036,22053,22055,22058,22074,22088,22089,22122,22126,22137,22177,22216,22219,22225,22248,22260,22266,22268,22292,22316,22321,22327,22350,22366,22378,22380,22382,22389,22395,22419,22428,22431,22485,22493,22498,22518,22520,22530,22546,22553,22559,22594,22607,22621,22623,22666,22668,22671,22674,22681,22691,22735,22740,22744,22753,22766,22779,22786,22793,22822,22834,22857,22873,22875,22898,22906,22918,22921,22922,22927,22932,22933,22934,22935,22936,22967,22976,22998,23002,23004,23006,23013,23017,23026,23027,23032,23047,23050,23080,23084,23090,23102,23103,23126,23136,23151,23166,23174,23181,23202,23215,23224,23260,23271,23278,23279,23288,23310,23319,23338,23343,23354,23380,23396,23400,23411,23412,23417,23445,23466,23468,23471,23477,23481,23495,23503,23512,23516,23531,23543,23548,23584,23624,23633,23634,23645,23651,23652,23659,23665,23666,23667,23677,23686,23693,23705,23714,23719,23726,23731,23740,23756,23761,23768,23780,23782,23785,23792,23806,23816,23827,23855,23866,23869,23873,23874,23876,23894,23911,23913,23914,23958,23965,23966,23989,23998,24001,24002,24059,24082,24114,24134,24137,24154,24171,24188,24190,24201,24210,24212,24232,24260,24299,24340,24373,24391,24432,24442,24470,24485,24543,24567,24608,24630,24657,24659,24671,24672,24673,24681,24700,24718,24719,24734,24754,24780,24790,24807,24836,24845,24851,24857,24882,24887,24888,24905,24922,24927,24942,24945,24960,24967,24986,24995,25033,25038,25041,25061,25090,25103,25104,25119,25137,25141,25143,25146,25155,25163,25199,25200,25207,25218,25252,25258,25260,25271,25315,25345,25353,25366,25373,25374,25379,25380,25435,25461,25469,25474,25483,25486,25502,25513,25540,25554,25583,25595,25600,25615,25616,25650,25663,25735,25742,25746,25749,25753,25768,25778,25782,25790,25813,25822,25886,25911,25952,26073,26103,26116,26140,26157,26174,26191,26197,26207,26209,26225,26236,26238,26247,26271,26293,26322,26323,26324,26338,26344,26355,26387,26389,26392,26398,26420,26431,26432,26434,26452,26479,26481,26513,26522,26548,26560,26562,26577,26589,26594,26598,26605,26612,26637,26654,26685,26701,26776,26780,26792,26857,26897,26909,26919,26924,26934,26936,26939,26941,26954,27008,27015,27020,27024,27028,27040,27055,27075,27076,27085,27087,27093,27096,27104,27127,27149,27155,27184,27248,27279,27355,27356,27368,27390,27403,27420,27438,27442,27453,27477,27488,27532,27563,27566,27572,27720,27724,27739,27822,27892,27893,27898,27937,27991,28116,28135,28157,28169,28185,28242,28294,28316,28539,28609,28617,28651,28657,28712,28714,28715,28910,28922,28925,29023,29034,29089,29123,29348,29381,29413,29445,29466,29467,29499,29550,29551,29584,29608,29658,29683,29788,29801,29834,29837,29839,29872,29890,29896,29897,29909,29915,29918,30111,30414,30941,31090,31510,31663,31837,32136,33385,33932,34150,34848,35730,35741,35803,35921,35989,36017,36041,36141,36178,36235,36633,36958,38800,38816,38817,38833,38845,38852,38887,38897,38916,38985,38987,39178,39318,39342,39369,39598,39614,39642,39645,39653,39713,39820,39846,39858,39877,39941,39970,39972,39998,40050,40064,40214,40521,40672,40706,40861,40909,40935,41104,41163,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 | 1796 | 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.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
init | 0.40 ms |
System lock | 0.02 ms |
optimizing | 0.12 ms |
statistics | 3.63 ms |
preparing | 1.83 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.54 ms |
end | 0.01 ms |
query end | 0.05 ms |
closing tables | 0.02 ms |
freeing items | 0.10 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 |