Tiempo de la consulta: 8.69 ms Después de la última consulta: 1.90 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.267 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-10 00:08:46')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-10 00:08:46')
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(3,8,11,46,49,57,58,62,64,73,122,124,130,149,154,155,177,180,186,188,189,198,202,206,212,214,215,219,220,221,244,246,248,250,253,254,260,276,309,325,328,330,332,337,388,390,394,417,418,419,423,427,433,439,446,448,452,454,455,458,459,478,481,510,521,524,550,551,558,567,583,587,593,595,596,597,603,604,612,613,618,628,641,647,659,660,662,671,678,686,695,699,723,729,743,757,779,788,793,816,845,852,868,879,902,911,915,927,938,954,955,986,1010,1015,1027,1033,1057,1066,1094,1099,1100,1114,1119,1158,1186,1207,1210,1214,1218,1222,1226,1227,1234,1240,1268,1269,1271,1272,1273,1274,1325,1328,1335,1339,1352,1357,1386,1388,1389,1390,1394,1397,1398,1412,1432,1458,1464,1475,1512,1519,1543,1627,1644,1712,1740,1754,1797,1800,1803,1839,1853,1904,1952,1960,2012,2038,2048,2053,2085,2086,2088,2092,2094,2122,2137,2142,2155,2185,2189,2190,2241,2243,2288,2355,2389,2429,2431,2482,2520,2532,2551,2580,2581,2598,2609,2687,2689,2710,2719,2746,2811,2825,2852,2900,2906,2937,2964,3017,3022,3026,3027,3031,3067,3120,3130,3144,3156,3188,3193,3224,3240,3258,3269,3295,3318,3323,3337,3353,3415,3416,3417,3418,3473,3512,3517,3546,3554,3557,3674,3696,3706,3709,3721,3748,3776,3828,3836,3864,3991,4000,4068,4096,4109,4127,4163,4276,4281,4301,4409,4490,4538,4580,4611,4620,4640,4765,4767,4790,4815,4831,4844,4846,4905,4955,5001,5018,5043,5045,5055,5085,5096,5154,5164,5190,5220,5243,5263,5300,5301,5306,5357,5370,5417,5543,5544,5562,5581,5582,5583,5637,5638,5644,5646,5648,5659,5666,5678,5702,5732,5768,5777,5779,5794,5795,5804,5831,5894,5899,5910,5918,5919,5923,5997,6000,6007,6011,6016,6022,6087,6093,6097,6112,6183,6220,6237,6253,6258,6261,6264,6266,6288,6312,6355,6390,6405,6420,6424,6448,6476,6477,6520,6564,6596,6681,6703,6716,6733,6749,6766,6826,6848,6855,6939,6994,7032,7048,7067,7277,7285,7294,7314,7324,7325,7327,7338,7346,7449,7491,7513,7523,7527,7548,7549,7551,7576,7577,7583,7595,7618,7666,7711,7716,7730,7746,7757,7760,7764,7795,7797,7808,7811,7829,7840,7853,7871,7901,7902,7958,7969,8009,8016,8027,8042,8062,8064,8078,8080,8081,8084,8087,8095,8113,8138,8164,8177,8178,8201,8218,8240,8258,8291,8351,8356,8374,8420,8461,8512,8517,8546,8573,8637,8826,8861,8875,8973,9057,9087,9093,9139,9175,9182,9184,9186,9219,9237,9251,9254,9277,9282,9307,9336,9357,9360,9362,9367,9387,9394,9408,9430,9431,9460,9472,9509,9515,9521,9540,9572,9576,9584,9589,9629,9644,9660,9679,9697,9711,9729,9730,9734,9832,9850,9864,9886,9891,9899,9930,9932,9934,9956,9992,10018,10046,10113,10122,10149,10199,10207,10213,10332,10361,10398,10401,10464,10477,10483,10499,10537,10603,10656,10671,10681,10708,10710,10720,10764,10833,10932,10986,11009,11027,11043,11131,11150,11161,11164,11238,11263,11302,11354,11377,11379,11473,11474,11480,11538,11559,11633,11648,11666,11680,11706,11713,11716,11748,11763,11775,11846,11854,11870,11879,11911,11926,12011,12036,12042,12051,12069,12085,12131,12136,12152,12202,12217,12242,12250,12256,12271,12317,12319,12334,12362,12370,12380,12426,12427,12448,12470,12514,12520,12565,12568,12588,12590,12604,12636,12670,12676,12738,12746,12758,12788,12799,12806,12849,12877,12900,12905,12906,12907,12908,12909,12910,12911,12912,12913,12914,12915,12958,12960,13010,13013,13027,13037,13062,13107,13126,13132,13142,13169,13186,13215,13222,13238,13246,13249,13250,13263,13264,13325,13328,13345,13359,13365,13379,13383,13391,13396,13409,13415,13426,13432,13440,13446,13453,13459,13481,13558,13566,13590,13594,13625,13644,13664,13697,13702,13708,13748,13753,13833,13881,13892,13928,13986,13998,14040,14074,14078,14092,14114,14133,14175,14177,14193,14198,14199,14224,14232,14234,14242,14261,14268,14305,14348,14355,14373,14378,14388,14421,14451,14461,14469,14480,14482,14493,14502,14504,14505,14508,14527,14531,14538,14565,14571,14608,14637,14651,14654,14680,14691,14699,14703,14725,14747,14798,14805,14810,14814,14818,14838,14862,14885,14896,14897,14904,14914,14953,14955,14964,14976,14977,14978,14982,15002,15054,15060,15092,15096,15105,15107,15115,15123,15138,15148,15154,15174,15175,15180,15181,15206,15217,15226,15235,15244,15257,15283,15284,15292,15299,15324,15325,15340,15344,15358,15371,15375,15403,15410,15417,15443,15469,15470,15473,15483,15490,15492,15500,15533,15540,15542,15547,15550,15562,15577,15580,15602,15604,15609,15612,15623,15630,15632,15637,15639,15642,15656,15662,15666,15707,15709,15733,15745,15762,15781,15785,15788,15794,15806,15811,15825,15832,15835,15840,15868,15878,15879,15901,15902,15922,15925,15937,15940,15954,15955,15977,15985,16005,16013,16015,16017,16024,16040,16052,16056,16074,16102,16117,16126,16156,16167,16213,16217,16219,16228,16242,16245,16261,16262,16265,16295,16297,16316,16328,16336,16337,16346,16353,16359,16368,16370,16382,16386,16389,16402,16404,16412,16417,16422,16435,16436,16447,16458,16463,16475,16479,16518,16547,16556,16588,16611,16613,16619,16627,16643,16659,16660,16662,16682,16722,16747,16778,16790,16791,16792,16820,16822,16823,16830,16833,16834,16838,16866,16893,16909,16917,16922,16927,16947,17028,17036,17045,17072,17149,17158,17160,17162,17172,17185,17214,17247,17268,17269,17283,17293,17337,17346,17360,17371,17390,17408,17422,17424,17433,17437,17441,17442,17452,17458,17460,17465,17485,17498,17507,17511,17512,17536,17567,17574,17584,17596,17610,17620,17633,17650,17680,17701,17705,17721,17733,17753,17759,17761,17772,17774,17783,17806,17807,17816,17824,17826,17831,17844,17850,17856,17862,17863,17885,17905,17918,17951,17973,17976,17977,18005,18006,18022,18031,18036,18046,18047,18050,18055,18057,18068,18102,18106,18140,18147,18151,18160,18179,18194,18215,18220,18221,18225,18231,18238,18244,18248,18253,18262,18263,18277,18297,18300,18313,18315,18334,18345,18352,18353,18357,18366,18376,18378,18401,18406,18434,18435,18439,18444,18460,18473,18480,18496,18519,18520,18524,18537,18544,18547,18572,18588,18598,18603,18609,18629,18638,18642,18643,18649,18655,18659,18665,18681,18695,18706,18732,18744,18750,18754,18766,18769,18792,18804,18821,18846,18852,18853,18859,18861,18868,18874,18885,18894,18908,18909,18920,18929,18930,18933,18936,18948,18952,18953,18956,18960,18966,18972,18973,18977,18989,18993,19005,19027,19038,19042,19053,19061,19062,19063,19073,19082,19104,19106,19121,19130,19136,19151,19160,19164,19172,19179,19191,19205,19219,19224,19237,19247,19254,19267,19275,19282,19285,19293,19299,19309,19313,19320,19322,19346,19350,19352,19405,19422,19427,19432,19434,19437,19440,19452,19457,19462,19484,19492,19503,19508,19509,19523,19562,19592,19604,19619,19626,19647,19654,19658,19666,19668,19695,19697,19706,19728,19748,19752,19753,19761,19762,19766,19774,19778,19790,19796,19806,19837,19856,19874,19885,19904,19925,19927,19944,19957,19976,19989,20001,20008,20035,20038,20052,20062,20064,20094,20098,20117,20120,20147,20150,20152,20158,20166,20191,20204,20205,20212,20213,20214,20215,20233,20263,20282,20299,20305,20306,20328,20332,20333,20337,20343,20344,20352,20359,20391,20399,20419,20420,20457,20459,20487,20489,20502,20530,20537,20543,20554,20572,20601,20608,20616,20621,20661,20691,20697,20712,20713,20716,20726,20733,20750,20754,20780,20782,20792,20810,20821,20830,20837,20841,20843,20858,20862,20876,20877,20886,20910,20912,20917,20920,20932,20949,20956,20963,20966,20974,20986,20997,20999,21002,21006,21010,21013,21017,21027,21040,21041,21047,21049,21050,21055,21057,21067,21069,21085,21086,21102,21104,21108,21121,21128,21133,21135,21142,21149,21159,21163,21166,21167,21172,21181,21185,21195,21222,21231,21233,21241,21250,21258,21262,21269,21312,21313,21324,21346,21366,21368,21387,21396,21436,21445,21466,21472,21482,21501,21508,21516,21542,21543,21547,21566,21585,21588,21596,21618,21628,21632,21640,21647,21648,21664,21665,21683,21689,21695,21703,21705,21713,21716,21727,21741,21742,21750,21757,21778,21859,21860,21878,21907,21914,21967,21969,21994,21995,22002,22013,22031,22049,22053,22081,22087,22088,22103,22115,22122,22137,22153,22156,22162,22170,22210,22219,22235,22236,22239,22249,22266,22292,22316,22353,22362,22365,22380,22402,22411,22427,22484,22485,22493,22498,22511,22512,22514,22523,22530,22531,22534,22539,22540,22546,22550,22553,22564,22590,22595,22615,22651,22665,22666,22668,22671,22680,22681,22691,22709,22738,22743,22744,22758,22759,22765,22768,22772,22779,22786,22822,22834,22857,22872,22873,22889,22898,22909,22918,22923,22936,22941,22949,22989,22998,23013,23023,23026,23035,23036,23047,23064,23082,23093,23094,23117,23157,23170,23181,23194,23202,23203,23224,23236,23254,23256,23257,23258,23260,23264,23277,23278,23288,23302,23305,23310,23315,23319,23336,23338,23340,23354,23358,23359,23398,23400,23417,23418,23424,23429,23435,23439,23440,23449,23465,23468,23469,23476,23480,23516,23524,23532,23543,23544,23556,23571,23584,23602,23624,23625,23627,23666,23667,23686,23705,23708,23726,23731,23743,23756,23765,23780,23800,23804,23809,23819,23826,23855,23873,23876,23893,23898,23902,23911,23945,23951,23989,24002,24016,24027,24082,24088,24101,24109,24110,24114,24125,24153,24168,24177,24190,24197,24199,24201,24210,24213,24224,24270,24286,24303,24333,24340,24369,24386,24395,24406,24412,24414,24422,24425,24426,24432,24456,24485,24486,24496,24503,24540,24545,24563,24567,24572,24585,24598,24618,24630,24657,24662,24663,24671,24672,24673,24679,24681,24734,24764,24773,24783,24787,24790,24796,24802,24807,24836,24845,24852,24862,24887,24888,24922,24941,24945,24962,24967,24975,24981,24984,25004,25035,25038,25041,25042,25046,25083,25097,25103,25105,25118,25129,25137,25142,25146,25151,25157,25163,25180,25200,25205,25214,25218,25233,25257,25258,25287,25315,25320,25353,25355,25373,25376,25380,25401,25405,25416,25418,25456,25461,25465,25469,25474,25483,25513,25537,25540,25548,25554,25558,25572,25583,25600,25610,25628,25639,25663,25721,25746,25753,25785,25790,25809,25813,25819,25822,25904,25911,25952,26010,26014,26044,26049,26073,26116,26120,26131,26136,26146,26147,26157,26161,26164,26168,26172,26174,26191,26207,26209,26225,26227,26234,26236,26245,26247,26268,26271,26322,26344,26355,26367,26387,26392,26405,26415,26420,26432,26434,26452,26453,26466,26481,26522,26560,26562,26594,26597,26598,26651,26671,26673,26677,26701,26706,26710,26780,26810,26811,26827,26861,26897,26898,26900,26924,26925,26934,26936,26940,26971,26999,27024,27028,27040,27057,27075,27085,27096,27108,27109,27126,27127,27128,27137,27171,27192,27198,27209,27232,27247,27252,27279,27307,27355,27363,27368,27390,27393,27395,27403,27420,27442,27466,27470,27485,27505,27563,27724,27739,27743,27761,27777,27786,27821,27893,27898,27922,28116,28135,28163,28185,28242,28248,28294,28322,28325,28351,28402,28416,28425,28436,28441,28442,28458,28465,28534,28539,28547,28555,28575,28609,28617,28651,28683,28712,28714,28715,28739,28786,28789,28817,28867,28911,28918,29004,29005,29017,29033,29034,29037,29053,29065,29089,29105,29142,29155,29201,29208,29221,29312,29348,29381,29413,29440,29445,29460,29467,29484,29499,29502,29550,29551,29553,29563,29635,29658,29682,29683,29742,29760,29788,29801,29803,29824,29837,29839,29872,29895,29896,29897,29915,29918,30111,30414,30478,30596,30941,31090,31114,31510,31623,31624,31663,31763,31837,31885,31896,32719,33385,33416,33649,33997,33998,34150,34239,34258,35333,36079,36141,37056,37210,37695,37696,37702,38000,38261,38475,38691,38887,39180,39186,39258,39267,39342,39463,39469,39491,39495,39543,39750,39819,39846,39870,39877,39884,39933,40064,40072,40207,40208,40355,40402,40521,40572,40672,40772,40837,40852,40861,40909,41074,41104,41241,41444,41525,41526,41541,41606,41632,41823,41946,41960,42024,42025,42067,42132,42251,42408,42421,42425,42426,42444,42748,42824,42839,43002,43052,43060,43069,43084,43087,43388,43717,44161,44509,44749,44763)
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 | 2026 | 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.18 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
Opening tables | 0.07 ms |
init | 0.50 ms |
System lock | 0.02 ms |
optimizing | 0.18 ms |
statistics | 3.79 ms |
preparing | 1.85 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.42 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.08 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 |