Tiempo de la consulta: 9.59 ms Después de la última consulta: 1.63 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.542 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-04 20:36:38')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 20:36:38')
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(4,9,11,25,28,49,56,58,75,86,147,148,149,150,151,152,153,154,155,165,170,186,198,203,215,219,221,254,255,256,263,271,272,275,276,309,325,328,330,371,385,389,394,417,418,437,452,458,463,472,583,607,611,613,628,686,723,758,799,813,844,868,883,895,900,917,956,958,963,970,986,1001,1018,1031,1053,1080,1091,1139,1185,1186,1207,1233,1271,1277,1298,1325,1328,1352,1388,1389,1390,1394,1412,1464,1475,1503,1712,1718,1754,1797,1800,1817,1835,1839,1952,2048,2053,2062,2073,2085,2086,2185,2191,2290,2293,2305,2322,2355,2365,2429,2520,2529,2532,2580,2639,2661,2687,2689,2710,2713,2719,2796,2825,2827,2857,2863,2900,2964,3017,3020,3026,3051,3067,3083,3106,3107,3144,3188,3209,3210,3269,3318,3322,3323,3329,3337,3463,3512,3517,3519,3604,3674,3692,3709,3776,3786,3986,3991,4000,4013,4076,4109,4127,4281,4301,4405,4538,4549,4580,4620,4670,4848,4878,4902,4955,5043,5045,5096,5154,5190,5220,5243,5263,5300,5301,5350,5357,5365,5417,5451,5462,5525,5544,5582,5583,5603,5637,5644,5646,5647,5666,5675,5678,5702,5730,5732,5768,5777,5779,5794,5795,5804,5831,5881,5894,5910,5919,5923,5997,6000,6007,6011,6016,6022,6045,6062,6087,6112,6127,6183,6220,6237,6258,6261,6266,6312,6355,6362,6389,6390,6393,6405,6420,6470,6473,6475,6476,6477,6484,6520,6542,6543,6545,6564,6573,6596,6630,6633,6654,6656,6688,6716,6723,6725,6726,6733,6742,6744,6749,6766,6785,6835,6848,6855,6860,6889,6895,6905,6906,6911,6936,6955,6971,6985,7015,7032,7048,7067,7101,7105,7232,7285,7296,7328,7343,7435,7456,7483,7527,7544,7545,7549,7576,7586,7588,7595,7688,7710,7716,7730,7760,7797,7806,7811,7832,7853,7858,7863,7902,7934,7950,7958,7959,7969,7997,7998,8009,8027,8062,8064,8078,8081,8084,8088,8095,8109,8115,8143,8164,8178,8218,8240,8250,8356,8374,8420,8435,8461,8508,8546,8573,8637,8663,8679,8826,8861,8875,9057,9093,9139,9175,9182,9184,9186,9237,9242,9251,9254,9277,9282,9305,9307,9351,9357,9362,9394,9408,9430,9431,9507,9509,9521,9540,9572,9574,9576,9589,9626,9629,9644,9660,9697,9711,9729,9850,9860,9864,9899,9932,9934,9992,10110,10113,10120,10176,10188,10203,10206,10213,10229,10239,10250,10264,10306,10311,10315,10361,10369,10425,10535,10603,10611,10644,10697,10708,10720,10741,10757,10779,10872,10907,10925,10951,10952,10954,10974,11008,11015,11035,11059,11063,11083,11091,11131,11150,11173,11207,11226,11269,11302,11366,11391,11394,11479,11534,11559,11706,11712,11766,11883,11896,11917,11924,11987,12165,12217,12226,12242,12250,12301,12306,12334,12388,12398,12426,12445,12449,12482,12519,12520,12545,12567,12568,12576,12590,12623,12624,12625,12670,12684,12745,12746,12758,12788,12789,12795,12799,12806,12846,12850,12894,12902,12928,12940,12943,12945,12974,12978,13010,13013,13036,13037,13038,13061,13062,13069,13070,13100,13126,13169,13186,13188,13215,13225,13238,13241,13249,13263,13325,13365,13383,13415,13426,13432,13453,13459,13481,13508,13519,13558,13566,13590,13611,13625,13635,13728,13792,13833,13851,13855,13881,13894,13968,13972,13986,13998,14048,14097,14107,14114,14140,14177,14183,14189,14193,14194,14205,14229,14236,14249,14261,14361,14388,14401,14457,14461,14507,14571,14591,14631,14651,14680,14684,14698,14703,14725,14782,14805,14807,14810,14811,14818,14829,14847,14850,14856,14865,14885,14904,14911,14914,14953,14978,14988,14999,15003,15014,15038,15054,15063,15094,15096,15138,15158,15171,15177,15187,15217,15233,15235,15244,15259,15270,15292,15304,15310,15322,15340,15346,15361,15381,15407,15418,15429,15469,15475,15487,15490,15516,15540,15547,15550,15551,15602,15603,15612,15623,15630,15662,15666,15707,15734,15757,15785,15802,15806,15835,15840,15850,15863,15866,15875,15885,15902,15903,15922,15925,15931,15937,15981,15987,16000,16005,16013,16015,16024,16043,16056,16074,16090,16102,16115,16117,16129,16155,16211,16213,16219,16228,16242,16262,16265,16277,16279,16281,16316,16323,16338,16346,16359,16366,16386,16402,16412,16415,16417,16422,16431,16432,16438,16450,16479,16497,16516,16524,16538,16547,16561,16564,16568,16571,16588,16626,16645,16668,16689,16717,16775,16816,16833,16834,16840,16846,16863,16908,16917,16918,16947,16951,16996,17002,17045,17060,17063,17066,17067,17086,17101,17114,17132,17136,17148,17160,17166,17172,17227,17228,17242,17253,17273,17282,17285,17287,17333,17339,17360,17371,17400,17407,17456,17470,17474,17490,17509,17510,17534,17539,17572,17618,17629,17634,17643,17644,17645,17659,17680,17699,17701,17715,17721,17727,17753,17759,17766,17782,17785,17798,17810,17818,17821,17826,17852,17853,17862,17870,17879,17886,17893,17920,17925,17931,17946,17950,17965,17976,17977,17988,18006,18021,18022,18032,18035,18036,18046,18047,18068,18074,18082,18083,18106,18121,18151,18168,18171,18173,18191,18219,18220,18241,18253,18259,18276,18294,18297,18308,18311,18347,18352,18354,18377,18378,18413,18421,18426,18444,18450,18471,18473,18478,18491,18494,18497,18500,18505,18506,18527,18540,18547,18572,18575,18612,18624,18629,18635,18638,18642,18648,18655,18668,18670,18682,18696,18698,18719,18730,18746,18751,18766,18775,18790,18792,18795,18828,18846,18853,18866,18868,18874,18880,18901,18911,18916,18917,18918,18948,18953,18956,18977,19004,19005,19014,19026,19038,19051,19060,19062,19063,19064,19079,19082,19130,19133,19134,19155,19160,19164,19175,19207,19217,19231,19260,19267,19275,19283,19284,19288,19295,19297,19301,19308,19310,19318,19320,19321,19322,19349,19390,19407,19414,19420,19432,19444,19457,19482,19484,19495,19516,19531,19561,19583,19591,19592,19594,19617,19645,19646,19648,19652,19684,19696,19706,19710,19718,19723,19727,19728,19733,19747,19751,19766,19796,19819,19824,19832,19854,19875,19876,19927,19939,19962,19976,19982,19988,19989,20015,20017,20023,20033,20038,20052,20062,20089,20099,20120,20127,20149,20150,20161,20174,20176,20179,20187,20188,20191,20193,20211,20212,20213,20220,20256,20264,20277,20289,20298,20303,20307,20308,20310,20317,20324,20333,20337,20340,20343,20370,20391,20397,20401,20410,20421,20437,20442,20448,20472,20481,20484,20502,20522,20543,20549,20550,20567,20572,20587,20601,20607,20610,20615,20616,20630,20654,20663,20664,20668,20686,20697,20705,20709,20710,20713,20714,20727,20728,20733,20737,20739,20750,20752,20754,20758,20785,20792,20797,20808,20813,20821,20830,20858,20865,20871,20881,20897,20907,20910,20917,20920,20925,20932,20947,20949,20954,20963,20966,20973,20990,20993,20997,20999,21002,21006,21012,21021,21027,21033,21035,21040,21041,21042,21047,21050,21058,21059,21069,21071,21079,21080,21090,21102,21104,21107,21113,21126,21128,21132,21134,21138,21158,21159,21167,21169,21172,21185,21187,21195,21204,21216,21223,21233,21241,21250,21255,21262,21270,21273,21288,21297,21313,21323,21343,21346,21368,21372,21394,21397,21410,21420,21433,21445,21466,21472,21474,21485,21486,21491,21496,21498,21504,21543,21547,21555,21560,21563,21574,21579,21581,21617,21618,21632,21634,21640,21641,21646,21648,21650,21660,21667,21669,21670,21683,21688,21690,21699,21703,21705,21738,21740,21746,21751,21756,21757,21760,21764,21798,21800,21810,21837,21846,21850,21852,21853,21870,21879,21902,21907,21915,21926,21942,21950,21954,21960,21976,21977,21986,21987,21988,21995,21996,22002,22011,22015,22017,22034,22038,22040,22041,22050,22056,22059,22073,22081,22085,22089,22098,22099,22103,22112,22113,22124,22150,22162,22164,22171,22194,22204,22212,22235,22236,22242,22249,22278,22281,22283,22290,22292,22305,22306,22315,22318,22321,22353,22359,22389,22394,22405,22411,22484,22498,22502,22512,22514,22522,22530,22531,22540,22544,22545,22550,22554,22564,22572,22590,22595,22596,22606,22615,22646,22658,22661,22665,22672,22706,22707,22716,22737,22738,22745,22746,22753,22757,22759,22765,22768,22772,22799,22816,22838,22854,22858,22887,22889,22894,22901,22909,22935,22968,22970,22971,22974,22976,22989,22991,22997,22999,23003,23011,23017,23022,23035,23041,23046,23051,23063,23069,23070,23078,23082,23085,23094,23095,23097,23117,23118,23132,23135,23136,23139,23148,23181,23194,23201,23216,23217,23221,23236,23239,23240,23242,23253,23256,23257,23258,23267,23280,23282,23295,23297,23302,23305,23317,23320,23321,23331,23334,23336,23345,23348,23349,23351,23352,23354,23358,23359,23363,23383,23396,23398,23418,23420,23423,23424,23429,23430,23435,23439,23440,23445,23449,23456,23465,23476,23486,23488,23501,23512,23516,23525,23528,23532,23535,23555,23556,23560,23562,23566,23571,23582,23585,23602,23605,23609,23615,23618,23627,23631,23649,23662,23680,23681,23685,23708,23712,23730,23743,23761,23765,23772,23790,23800,23806,23809,23811,23813,23814,23816,23826,23838,23847,23851,23853,23854,23910,23921,23926,23936,23945,23951,23953,23958,23961,23963,23975,23978,23990,23999,24012,24024,24025,24027,24034,24045,24055,24101,24112,24118,24120,24125,24127,24139,24147,24165,24168,24169,24177,24189,24193,24199,24203,24204,24206,24213,24219,24220,24223,24226,24227,24244,24245,24246,24251,24286,24303,24305,24307,24323,24326,24333,24362,24364,24385,24386,24401,24403,24406,24410,24411,24414,24425,24426,24429,24433,24440,24456,24464,24483,24499,24502,24513,24522,24526,24532,24540,24545,24549,24557,24560,24572,24577,24583,24597,24605,24616,24626,24628,24632,24644,24651,24662,24668,24681,24682,24694,24701,24730,24732,24748,24750,24783,24796,24800,24816,24824,24830,24841,24848,24849,24861,24865,24868,24877,24878,24896,24909,24925,24956,24959,24962,24966,24967,24969,24973,24975,24977,24981,24984,25021,25025,25031,25035,25042,25048,25053,25057,25061,25070,25071,25080,25081,25083,25089,25091,25097,25118,25127,25129,25142,25147,25151,25153,25157,25171,25180,25210,25214,25230,25243,25257,25280,25287,25293,25296,25310,25332,25333,25351,25352,25355,25369,25372,25378,25386,25396,25399,25407,25423,25424,25436,25440,25452,25456,25458,25460,25517,25520,25523,25524,25525,25526,25528,25535,25536,25537,25541,25548,25551,25552,25558,25560,25561,25566,25568,25582,25591,25596,25610,25628,25649,25653,25657,25676,25702,25711,25747,25775,25779,25781,25785,25809,25819,25844,25874,25888,25921,25934,25941,25962,25983,25990,26008,26010,26014,26033,26043,26044,26049,26050,26053,26082,26102,26147,26161,26164,26172,26188,26201,26234,26241,26271,26283,26296,26318,26320,26351,26354,26358,26362,26366,26367,26391,26405,26432,26444,26466,26483,26488,26515,26519,26525,26577,26583,26588,26597,26613,26694,26698,26734,26796,26814,26901,26999,27002,27009,27024,27040,27041,27048,27055,27074,27082,27101,27108,27109,27119,27124,27126,27137,27139,27156,27161,27178,27192,27209,27218,27231,27242,27252,27302,27307,27317,27320,27321,27330,27397,27407,27425,27466,27470,27471,27518,27551,27622,27786,27803,27806,27818,27860,27875,27949,27958,27968,28022,28030,28075,28117,28272,28281,28325,28328,28410,28429,28458,28504,28527,28528,28548,28552,28555,28683,28691,28703,28728,28741,28799,28867,28868,28911,28928,28951,29108,29143,29159,29189,29219,29222,29251,29298,29320,29372,29378,29473,29500,29617,29618,29619,29743,30000,30111,30284,30404,30478,31010,31115,31623,31624,32676,32679,33998,34177,34205,34258,34417,34489,34639,34690,34888,35300,35333,35504,35657,35744,35882,35936,35959,36079,36298,36499,36813,36990,38000,38619,38691,38961,39063,39251,39323,39629,39857,40072,40203,40347,40356,40370,40483,41074,41089,41185,41868,42899,42900,42908,43581,43906,44682,44830)
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 | 1923 | 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.47 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.42 ms |
System lock | 0.02 ms |
optimizing | 0.21 ms |
statistics | 4.09 ms |
preparing | 2.03 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.34 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.10 ms |
cleaning up | 0.09 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 |