Tiempo de la consulta: 6.90 ms Después de la última consulta: 1.77 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.422 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-05 23:18:11')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 23:18:11')
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,4,8,9,11,25,28,46,49,56,57,71,86,87,90,92,96,97,98,99,102,104,107,112,124,149,155,165,180,186,189,198,199,209,210,212,215,217,219,220,221,222,224,226,228,232,234,238,240,242,243,244,245,246,248,249,250,253,254,255,257,259,260,262,263,265,271,275,289,296,297,300,301,303,304,305,307,309,325,328,330,337,357,370,372,373,394,395,412,414,417,418,419,423,424,426,427,428,429,433,445,451,452,459,463,466,468,472,481,487,521,523,524,525,527,528,532,548,549,553,555,565,567,583,587,592,595,596,597,603,604,605,607,611,613,620,628,632,637,641,646,647,659,662,686,706,711,723,730,746,758,781,788,792,794,800,805,818,823,833,840,842,847,848,852,868,878,883,895,900,901,902,904,917,925,948,958,962,963,966,994,1007,1008,1015,1023,1031,1058,1066,1067,1072,1080,1100,1114,1119,1145,1165,1209,1212,1223,1227,1264,1268,1271,1272,1274,1275,1276,1277,1278,1314,1325,1328,1352,1388,1389,1390,1394,1412,1462,1464,1475,1504,1698,1712,1718,1754,1797,1800,1803,1804,1825,1828,1839,1845,1853,1952,1957,1960,1961,2007,2012,2048,2053,2085,2086,2156,2185,2290,2293,2305,2322,2355,2365,2429,2463,2520,2532,2580,2589,2638,2639,2687,2689,2719,2729,2796,2811,2822,2825,2852,2863,2900,3017,3020,3026,3058,3067,3144,3156,3167,3181,3188,3269,3318,3323,3337,3415,3416,3417,3424,3473,3512,3517,3520,3557,3604,3674,3704,3709,3727,3776,3786,3836,3853,3868,3872,3986,3991,4000,4109,4127,4301,4334,4360,4378,4457,4538,4549,4561,4580,4620,4691,4784,4808,4832,4848,4878,4902,4907,4908,4955,5043,5045,5096,5125,5154,5190,5220,5243,5263,5301,5323,5350,5357,5365,5371,5392,5415,5417,5451,5495,5544,5567,5582,5583,5622,5637,5644,5646,5647,5649,5666,5675,5678,5685,5702,5726,5727,5730,5732,5756,5759,5768,5777,5779,5780,5793,5794,5795,5804,5831,5847,5889,5894,5899,5910,5919,5923,5942,5978,5997,5999,6000,6002,6007,6011,6016,6022,6060,6087,6112,6127,6147,6160,6183,6194,6220,6237,6258,6261,6264,6266,6312,6343,6355,6377,6386,6390,6391,6401,6405,6420,6449,6470,6473,6475,6476,6477,6499,6518,6520,6542,6543,6564,6573,6587,6596,6623,6630,6656,6662,6677,6688,6716,6723,6733,6742,6744,6749,6758,6760,6766,6774,6835,6839,6847,6848,6855,6860,6881,6885,6889,6895,6906,6915,6936,6984,6985,7015,7017,7032,7048,7067,7195,7232,7258,7343,7391,7473,7483,7527,7545,7549,7576,7586,7588,7595,7606,7616,7622,7624,7635,7687,7693,7697,7716,7730,7738,7756,7758,7760,7771,7772,7788,7811,7832,7853,7875,7902,7928,7934,7950,7958,7959,7967,7969,7997,8009,8021,8027,8050,8056,8062,8064,8070,8074,8078,8081,8084,8087,8095,8109,8143,8162,8164,8178,8192,8215,8218,8240,8273,8320,8354,8356,8374,8398,8420,8461,8465,8487,8495,8499,8508,8546,8573,8589,8637,8643,8650,8672,8815,8826,8844,8861,8875,8895,8932,8969,9003,9057,9093,9121,9139,9174,9175,9182,9184,9186,9237,9251,9254,9277,9307,9357,9362,9380,9394,9398,9408,9424,9430,9431,9509,9521,9540,9572,9576,9589,9629,9644,9650,9660,9663,9697,9701,9711,9724,9729,9781,9850,9864,9899,9924,9932,9934,9992,10031,10046,10079,10098,10100,10110,10113,10176,10203,10213,10250,10258,10298,10306,10311,10323,10361,10368,10436,10572,10603,10697,10708,10720,10753,10872,10889,10893,10951,10954,10956,10974,11015,11063,11083,11131,11156,11163,11173,11226,11292,11302,11394,11479,11534,11559,11561,11706,11712,11766,11822,11883,11894,11911,11946,11987,12095,12130,12145,12177,12217,12225,12242,12250,12306,12334,12383,12399,12412,12426,12449,12520,12545,12568,12590,12624,12625,12679,12746,12788,12789,12799,12806,12887,12894,12902,12913,12945,12966,12973,12974,12982,13010,13013,13037,13062,13126,13130,13155,13169,13186,13215,13225,13231,13238,13241,13249,13263,13276,13285,13321,13325,13365,13383,13398,13405,13415,13426,13432,13453,13459,13462,13471,13473,13481,13508,13518,13540,13556,13558,13566,13590,13611,13625,13665,13681,13750,13753,13800,13833,13851,13855,13868,13881,13903,13968,13969,13972,13986,13987,13998,14015,14029,14034,14048,14097,14114,14156,14177,14183,14193,14203,14204,14205,14218,14224,14229,14236,14238,14261,14263,14293,14341,14356,14361,14382,14388,14461,14507,14524,14571,14581,14631,14651,14665,14680,14684,14725,14776,14805,14810,14811,14818,14850,14856,14885,14904,14909,14911,14914,14940,14945,14951,14953,14957,14969,14978,14987,15006,15021,15029,15038,15039,15054,15096,15110,15126,15138,15175,15179,15188,15198,15217,15235,15244,15258,15262,15292,15298,15304,15310,15314,15328,15340,15347,15366,15418,15421,15442,15468,15469,15470,15473,15482,15490,15495,15511,15517,15518,15540,15547,15550,15551,15561,15573,15579,15602,15612,15623,15627,15630,15662,15666,15667,15707,15757,15759,15784,15785,15806,15808,15835,15840,15866,15902,15903,15913,15922,15925,15937,15973,16005,16013,16015,16021,16023,16024,16046,16074,16102,16117,16122,16154,16165,16213,16219,16228,16242,16258,16262,16263,16265,16279,16316,16336,16346,16352,16365,16366,16382,16386,16402,16415,16417,16422,16431,16432,16443,16479,16488,16517,16532,16538,16547,16588,16645,16648,16720,16737,16775,16812,16826,16833,16834,16894,16917,16947,16963,16983,16995,16996,17045,17063,17069,17132,17142,17154,17160,17170,17172,17177,17195,17227,17228,17236,17242,17275,17285,17307,17317,17334,17359,17371,17380,17407,17409,17431,17453,17470,17506,17510,17520,17521,17584,17602,17611,17619,17629,17634,17680,17710,17721,17764,17766,17826,17852,17862,17925,17949,17950,17965,17976,17977,17981,18006,18022,18035,18036,18050,18052,18067,18068,18106,18121,18124,18133,18151,18181,18207,18213,18253,18276,18294,18297,18308,18311,18313,18336,18362,18375,18378,18390,18413,18421,18426,18437,18444,18458,18465,18473,18491,18497,18500,18505,18509,18524,18538,18545,18547,18572,18575,18588,18603,18635,18638,18642,18655,18668,18670,18675,18682,18689,18698,18707,18718,18726,18730,18751,18752,18753,18766,18771,18779,18792,18801,18802,18804,18828,18845,18846,18852,18853,18868,18874,18918,18934,18948,18955,18956,18958,18977,18999,19005,19024,19026,19038,19040,19051,19057,19062,19064,19082,19098,19130,19133,19150,19160,19164,19175,19207,19227,19239,19245,19247,19252,19263,19267,19275,19288,19293,19299,19304,19307,19310,19312,19322,19349,19353,19358,19369,19402,19426,19432,19444,19454,19471,19483,19484,19516,19527,19551,19563,19568,19582,19587,19592,19625,19676,19697,19706,19722,19727,19728,19749,19766,19772,19791,19796,19816,19824,19837,19868,19876,19913,19927,19939,19943,19962,19963,19976,19989,19994,20004,20017,20025,20033,20038,20039,20052,20062,20089,20092,20099,20120,20122,20124,20127,20144,20145,20149,20150,20174,20176,20183,20184,20191,20211,20212,20213,20216,20220,20224,20256,20264,20269,20277,20296,20301,20307,20310,20317,20337,20343,20346,20366,20386,20397,20406,20408,20410,20434,20437,20492,20497,20502,20511,20526,20528,20539,20549,20572,20573,20587,20592,20601,20602,20616,20617,20654,20668,20670,20686,20688,20697,20704,20709,20713,20714,20733,20739,20750,20754,20785,20792,20797,20804,20821,20830,20845,20853,20858,20881,20894,20897,20907,20917,20932,20944,20949,20963,20964,20966,20973,20984,20993,20997,20999,21002,21006,21027,21040,21041,21047,21050,21069,21080,21102,21104,21113,21159,21172,21182,21185,21195,21215,21216,21230,21233,21237,21241,21250,21259,21262,21273,21300,21308,21313,21346,21368,21404,21420,21445,21454,21466,21472,21543,21579,21631,21632,21640,21648,21667,21679,21703,21705,21733,21765,21767,21798,21820,21846,21852,21891,21907,21950,21955,21958,21960,22032,22038,22056,22085,22098,22103,22124,22150,22156,22162,22171,22172,22189,22198,22212,22235,22236,22239,22249,22253,22267,22269,22290,22339,22344,22353,22361,22363,22389,22409,22411,22466,22481,22484,22486,22498,22499,22512,22514,22530,22531,22540,22544,22547,22550,22564,22590,22595,22611,22615,22665,22672,22694,22695,22706,22726,22737,22738,22753,22759,22765,22768,22772,22781,22808,22814,22854,22865,22871,22889,22901,22909,22925,22955,22958,22973,22974,22989,23003,23010,23017,23035,23036,23041,23046,23070,23074,23076,23082,23085,23094,23096,23099,23104,23113,23119,23143,23148,23181,23184,23194,23201,23203,23218,23230,23235,23236,23253,23254,23256,23258,23264,23267,23268,23286,23292,23300,23302,23304,23305,23336,23354,23358,23359,23363,23371,23381,23383,23391,23398,23399,23418,23423,23424,23429,23435,23440,23449,23455,23460,23465,23475,23476,23483,23488,23501,23508,23511,23516,23523,23532,23533,23554,23555,23556,23566,23571,23585,23604,23615,23619,23622,23627,23632,23708,23719,23730,23765,23790,23800,23805,23809,23813,23816,23826,23838,23847,23854,23893,23897,23901,23905,23909,23926,23945,23947,23964,23978,23986,23990,24000,24007,24024,24025,24027,24092,24101,24118,24122,24125,24127,24147,24156,24160,24168,24177,24181,24193,24197,24199,24209,24219,24226,24238,24245,24250,24286,24294,24303,24333,24339,24352,24361,24367,24376,24386,24403,24406,24410,24411,24420,24426,24429,24433,24440,24456,24496,24502,24503,24526,24540,24545,24557,24563,24572,24576,24585,24597,24598,24615,24616,24655,24662,24663,24678,24679,24697,24701,24711,24732,24741,24748,24764,24772,24782,24783,24796,24826,24830,24841,24844,24860,24861,24865,24878,24918,24934,24941,24962,24967,24973,24975,24981,24984,24992,25005,25030,25035,25042,25048,25062,25079,25080,25083,25088,25089,25097,25118,25129,25142,25147,25151,25157,25180,25214,25232,25244,25257,25287,25303,25346,25355,25368,25375,25386,25401,25432,25445,25452,25453,25456,25465,25479,25480,25507,25535,25537,25548,25558,25560,25561,25565,25591,25592,25610,25613,25628,25637,25649,25657,25679,25698,25716,25727,25795,25809,25819,25863,25864,25888,25911,25918,25934,25935,25949,25956,25990,26010,26014,26043,26044,26047,26049,26065,26102,26118,26131,26161,26184,26221,26234,26235,26283,26367,26443,26466,26469,26473,26483,26488,26519,26525,26588,26597,26625,26673,26699,26728,26732,26875,26884,26900,26901,26920,26925,26937,26940,26954,26971,26978,26990,26999,27041,27074,27108,27109,27118,27126,27135,27137,27143,27148,27171,27192,27209,27232,27250,27252,27307,27321,27345,27397,27405,27407,27409,27430,27432,27461,27466,27470,27471,27483,27518,27550,27552,27786,27805,27904,27909,27934,27949,27951,27952,28005,28030,28049,28072,28121,28248,28325,28344,28416,28423,28547,28695,28698,28718,28799,28825,28911,28920,28928,29028,29063,29155,29221,29297,29328,29354,29473,29500,29640,29696,29882,29926,29943,30083,30111,30273,30284,30478,30483,30484,30696,30808,31010,31136,31447,31533,31623,31624,31899,32107,32339,32472,33274,33358,33448,33493,33534,33559,33570,33574,33600,33624,33625,33649,33651,33728,33739,33740,33766,33778,33779,33780,33783,33874,33941,33951,33992,33998,34012,34044,34046,34062,34063,34064,34066,34067,34069,34086,34092,34117,34119,34120,34128,34131,34136,34138,34139,34142,34143,34148,34155,34164,34167,34169,34177,34178,34179,34184,34187,34190,34210,34216,34220,34222,34223,34224,34225,34228,34229,34230,34231,34232,34235,34240,34241,34244,34246,34255,34258,34260,34261,34266,34269,34270,34272,34276,34279,34283,34288,34292,34296,34300,34301,34303,34308,34324,34325,34326,34332,34336,34338,34341,34343,34345,34346,34348,34349,34352,34355,34357,34359,34372,34375,34404,35000,35333,35368,35585,35744,35746,35832,35846,36079,36191,36194,36564,37288,37289,37656,37865,38000,38071,38489,38691,38961,39063,39320,39323,39348,39381,39687,39887,39917,40011,40053,40072,40086,40113,40199,40347,40384,40451,40492,40578,40752,41049,41074,41213,41460,41477,41494,41557,42444,43388,43436,43716,44480,44481,44759,44846,44866,45000,45076,45219)
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 | 2011 | 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 | 0.89 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.36 ms |
System lock | 0.02 ms |
optimizing | 0.12 ms |
statistics | 3.04 ms |
preparing | 1.58 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.36 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 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 |