Tiempo de la consulta: 9.86 ms Después de la última consulta: 1.23 ms Consulta a la memoria: 0.408 MB memoria antes de la consulta: 4.414 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-06 11:22:19')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 11:22:19')
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(21,49,51,82,93,131,133,138,139,155,204,407,460,495,529,583,595,634,892,907,929,935,971,981,986,1036,1112,1130,1133,1169,1198,1204,1207,1280,1352,1357,1587,1713,1781,1785,1800,1804,1808,1900,1902,1913,2046,2123,2210,2222,2228,2258,2260,2337,2378,2424,2468,2485,2509,2552,2598,2601,2632,2665,2688,2689,2825,2828,2952,2967,3067,3076,3114,3126,3211,3212,3258,3279,3319,3373,3379,3408,3410,3426,3475,3594,3663,3757,3825,3871,3951,3984,4046,4061,4131,4166,4215,4227,4263,4383,4493,4515,4612,4613,4614,4615,4617,4832,4836,4905,4910,4990,4992,5092,5150,5212,5224,5268,5298,5757,5798,5807,5870,5913,5943,5944,5973,6039,6055,6131,6192,6221,6268,6324,6347,6448,6571,6573,6577,6586,6609,6616,6645,6665,6686,6691,6699,6711,6770,6775,6788,6809,6830,6868,6919,6942,6945,6965,6977,7001,7081,7121,7201,7214,7271,7282,7291,7311,7330,7482,7526,7565,7572,7585,7594,7624,7652,7690,7735,7745,7758,7782,7799,7804,7810,7837,7866,7913,7933,7967,7997,7999,8000,8027,8085,8088,8222,8250,8258,8353,8354,8416,8436,8437,8532,8556,8603,8706,8728,8764,8787,8964,9012,9018,9051,9091,9109,9142,9218,9239,9308,9481,9552,9611,9649,9757,9823,9865,9920,9983,10039,10100,10260,10301,10348,10365,10400,10422,10458,10504,10510,10598,10604,10634,10764,10811,10840,10869,10955,10968,10970,11098,11323,11441,11476,11525,11560,11662,11703,11721,11722,11753,11803,11859,11965,12035,12113,12153,12213,12216,12224,12281,12430,12437,12475,12488,12541,12592,12650,12669,12685,12686,12708,12935,12999,13044,13154,13188,13227,13276,13325,13349,13352,13474,13575,13587,13671,13685,13693,13710,13727,13729,13748,13750,13782,13783,13858,13924,13941,13947,13973,14008,14052,14079,14139,14169,14186,14263,14264,14357,14426,14591,14601,14648,14663,14669,14679,14688,14703,14709,14713,14726,14744,14749,14754,14762,14790,14832,14840,14849,14880,14905,14906,14911,14949,14970,14992,14996,15014,15020,15027,15038,15045,15046,15059,15060,15217,15234,15245,15262,15286,15293,15298,15304,15365,15366,15382,15467,15520,15522,15533,15539,15594,15689,15706,15751,15753,15782,15785,15796,15851,15862,15894,15917,15931,15947,15991,16014,16057,16115,16120,16122,16157,16187,16208,16346,16354,16375,16422,16427,16455,16465,16528,16562,16566,16568,16578,16675,16678,16787,16814,16823,16862,16894,17014,17034,17035,17047,17101,17117,17121,17133,17142,17166,17167,17168,17198,17199,17221,17248,17296,17300,17304,17313,17328,17331,17335,17336,17353,17357,17385,17404,17412,17437,17449,17530,17531,17584,17592,17609,17613,17630,17635,17663,17688,17700,17753,17787,17792,17857,17862,17866,17924,17927,17928,17954,18012,18022,18027,18029,18042,18072,18078,18087,18212,18227,18290,18320,18334,18352,18377,18384,18419,18430,18473,18482,18483,18485,18524,18590,18595,18658,18693,18702,18705,18708,18739,18761,18764,18782,18839,18843,18853,18854,18906,18907,18912,18926,18927,18929,19042,19145,19153,19178,19204,19211,19222,19235,19236,19245,19249,19265,19268,19284,19290,19292,19375,19392,19414,19426,19439,19445,19455,19472,19487,19507,19520,19547,19565,19634,19637,19639,19644,19659,19664,19694,19695,19705,19706,19720,19723,19740,19758,19759,19765,19779,19789,19796,19798,19809,19819,19820,19841,19844,19853,19862,19875,19904,19916,19942,19967,19973,19988,20002,20042,20045,20060,20066,20068,20076,20091,20113,20145,20163,20180,20226,20246,20276,20288,20315,20376,20396,20398,20470,20488,20565,20577,20595,20618,20642,20656,20677,20690,20750,20764,20767,20805,20833,20837,20864,20883,20885,20934,20940,20953,20969,20992,21009,21027,21038,21060,21075,21093,21101,21107,21146,21147,21171,21188,21198,21218,21251,21259,21264,21275,21326,21329,21338,21350,21378,21398,21413,21441,21487,21502,21520,21523,21524,21566,21598,21609,21612,21623,21644,21659,21664,21695,21714,21718,21719,21726,21727,21728,21749,21777,21784,21787,21813,21817,21830,21850,21864,21875,21884,21891,21932,21980,22038,22048,22067,22072,22117,22129,22147,22166,22195,22253,22271,22290,22299,22302,22324,22329,22330,22332,22349,22357,22384,22385,22395,22406,22419,22426,22442,22450,22453,22482,22494,22495,22507,22535,22556,22580,22595,22620,22625,22626,22628,22655,22659,22704,22710,22715,22727,22736,22739,22753,22761,22780,22781,22804,22826,22829,22833,22850,22851,22879,22893,22897,22901,22920,22923,22934,22947,22951,22959,22964,23007,23024,23030,23055,23078,23083,23087,23089,23104,23116,23119,23123,23134,23145,23178,23179,23183,23184,23201,23213,23272,23279,23287,23294,23309,23328,23364,23365,23366,23367,23409,23413,23426,23479,23493,23509,23523,23544,23569,23646,23665,23668,23677,23695,23709,23711,23716,23719,23720,23774,23776,23831,23864,23869,23872,23887,23894,23914,24027,24043,24062,24100,24108,24145,24153,24156,24163,24185,24195,24199,24205,24208,24217,24225,24233,24240,24247,24258,24259,24265,24272,24275,24281,24286,24291,24316,24328,24334,24337,24338,24368,24380,24381,24391,24399,24406,24428,24437,24442,24463,24485,24492,24497,24518,24527,24539,24565,24590,24623,24700,24728,24743,24744,24761,24766,24780,24788,24854,24906,24942,24951,24952,24956,24974,24980,25032,25049,25062,25077,25092,25116,25170,25187,25195,25281,25300,25318,25356,25386,25505,25518,25548,25554,25589,25625,25639,25646,25648,25664,25665,25671,25673,25723,25727,25734,25745,25747,25757,25758,25771,25772,25774,25776,25800,25807,25817,25830,25836,25881,25916,25924,25927,25941,25942,25944,25949,25950,25961,25990,25992,25994,25995,26000,26010,26013,26025,26033,26035,26060,26082,26087,26108,26113,26120,26132,26136,26146,26147,26153,26161,26175,26183,26185,26187,26191,26194,26198,26215,26221,26227,26234,26245,26259,26263,26289,26296,26328,26337,26359,26361,26375,26378,26386,26388,26410,26412,26431,26471,26492,26591,26599,26608,26626,26630,26672,26679,26724,26744,26760,26780,26808,26815,26820,26835,26842,26843,26845,26864,26866,26873,26894,26905,26916,26927,26933,26935,26944,26964,26968,26992,27036,27041,27059,27065,27076,27100,27103,27108,27109,27115,27118,27120,27137,27138,27186,27192,27196,27197,27209,27211,27212,27216,27240,27242,27252,27268,27269,27270,27287,27291,27298,27307,27322,27323,27327,27367,27384,27405,27406,27457,27465,27487,27526,27550,27552,27578,27583,27595,27633,27688,27707,27717,27786,27832,27833,27855,27918,27921,27922,27923,27924,27926,27950,27999,28019,28031,28059,28066,28075,28094,28095,28097,28114,28120,28121,28129,28208,28228,28237,28243,28264,28279,28290,28349,28372,28419,28435,28668,28765,28838,28846,28858,28931,28943,28956,28995,29006,29045,29100,29152,29166,29223,29226,29229,29272,29380,29611,29616,29641,29712,29716,29724,29930,30111,30525,30540,30556,30560,30585,30621,30804,30932,31706,31735,31794,31820,31827,31837,31853,31908,32257,32304,32369,32468,32720,32761,32767,32768,32796,32843,32879,32977,32980,33026,33065,33157,33180,33289,33338,33522,33545,33874,33908,34646,34795,34811,34876,34888,34923,35100,35145,35171,35191,35195,35232,35238,35239,35250,35289,35295,35345,35365,35376,35397,35540,35554,35621,35641,35728,35744,35783,35808,35814,35835,35846,35850,35948,36015,36141,36174,36220,36222,36300,36368,36373,36380,36385,36386,36439,36441,36687,36790,36791,36792,36793,36849,36918,36931,36941,36984,37015,37104,37180,37183,37245,37370,37473,37508,37544,37643,37644,37677,37744,37757,37834,37894,37902,38001,38058,38092,38330,38356,38418,38617,38681,38723,38734,38799,38821,38824,38829,38877,38885,38898,38901,38912,38932,38965,38990,38993,39039,39062,39110,39133,39155,39205,39242,39244,39290,39293,39297,39366,39442,39460,39470,39491,39508,39517,39519,39559,39686,39718,39724,39730,39837,39856,39886,39966,40059,40218,40275,40319,40560,40576,40601,40624,40673,40786,40855,40885,40896,40922,41004,41009,41033,41123,41152,41171,41172,41176,41189,41201,41212,41225,41257,41272,41289,41328,41339,41343,41363,41415,41434,41479,41483,41504,41550,41571,41577,41591,41637,41737,41757,41783,41840,41862,41948,41964,41980,42010,42029,42181,42253,42258,42329,42415,42482,42513,42538,42682,42736,42811,42941,43003,43043,43093,43104,43117,43167,43221,43240,43241,43326,43375,43446,43461,43475,43477,43483,43517,43518,43551,43612,43645,43704,43792,44033,44053,44070,44098,44122,44186,44187,44378,44379,44421,44553,44581,44632,44640,44656,44718,44735,44788,44807,44829,44871,44873,44881,44912,44935,44936,45008,45174,45175,45223,45249,45274,45300,45313)
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 | 1407 | 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.01 ms |
Opening tables | 0.02 ms |
init | 0.37 ms |
System lock | 0.02 ms |
optimizing | 0.09 ms |
statistics | 3.21 ms |
preparing | 1.50 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 2.52 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.24 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 |