Tiempo de la consulta: 4.66 ms Después de la última consulta: 1.05 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.242 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 18:00:40')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 18:00:40')
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,93,407,495,595,625,843,971,981,1051,1066,1198,1327,1352,1357,1359,1432,1549,1620,1686,1701,1713,1724,1741,1754,1775,1781,1785,1800,1804,1839,1913,2123,2210,2228,2260,2337,2369,2378,2424,2468,2509,2574,2688,2689,2710,2780,2808,2825,2828,2884,2952,2967,3009,3026,3037,3067,3076,3165,3188,3193,3211,3212,3258,3281,3292,3319,3329,3346,3372,3373,3375,3376,3408,3410,3475,3593,3594,3663,3721,3722,3752,3871,4026,4049,4131,4166,4215,4227,4383,4411,4451,4461,4469,4486,4493,4507,4510,4520,4583,4584,4612,4613,4614,4615,4617,4620,4640,4672,4787,4832,4836,4908,4910,5094,5096,5170,5183,5224,5244,5268,5282,5298,5301,5469,5505,5677,5683,5688,5703,5798,5802,5831,5848,5895,5943,5944,5973,6039,6055,6093,6131,6142,6166,6176,6192,6256,6268,6324,6335,6345,6476,6477,6538,6571,6586,6606,6609,6612,6645,6665,6711,6783,6788,6809,6919,6944,6945,6977,6998,7001,7024,7081,7099,7105,7139,7271,7330,7482,7513,7533,7565,7585,7615,7624,7690,7735,7745,7799,7810,7837,7866,7869,7913,7918,7933,8000,8002,8085,8222,8250,8294,8354,8386,8393,8416,8436,8437,8454,8529,8532,8568,8603,8706,8707,8764,8940,8964,9012,9018,9051,9057,9061,9091,9142,9147,9190,9239,9308,9401,9470,9481,9552,9559,9641,9757,9823,9873,9920,9932,10039,10100,10260,10301,10371,10400,10407,10422,10458,10501,10510,10562,10572,10598,10604,10634,10764,10811,11098,11207,11241,11320,11323,11327,11408,11476,11549,11693,11703,11721,11722,11803,11814,11859,12035,12113,12216,12224,12324,12437,12488,12541,12592,12650,12669,12686,12708,12870,13067,13154,13188,13231,13276,13293,13348,13349,13352,13353,13474,13475,13575,13671,13685,13693,13727,13748,13782,13783,13851,13858,13924,13941,13947,14008,14022,14079,14129,14169,14228,14263,14357,14432,14648,14663,14669,14679,14688,14703,14709,14713,14726,14744,14749,14754,14762,14782,14790,14808,14832,14849,14865,14873,14905,14906,14911,14944,14949,14970,14974,14988,14992,14996,15017,15020,15045,15046,15133,15140,15144,15171,15217,15234,15262,15293,15304,15365,15366,15414,15539,15594,15613,15619,15646,15689,15690,15710,15751,15753,15785,15796,15851,15862,15868,15871,15878,15917,15967,15969,16057,16081,16102,16103,16120,16122,16157,16176,16245,16346,16354,16422,16455,16547,16562,16569,16578,16678,16742,16743,16787,16862,16880,16894,16905,17014,17028,17034,17055,17121,17136,17166,17167,17296,17304,17315,17335,17353,17385,17395,17449,17458,17483,17500,17530,17531,17608,17630,17635,17756,17857,17862,17985,17986,18022,18075,18077,18088,18092,18227,18241,18304,18306,18307,18327,18334,18590,18652,18658,18739,18779,18782,18906,18907,18912,18926,18927,18929,19019,19137,19153,19204,19211,19235,19236,19245,19268,19472,19507,19647,19706,19710,19723,19860,19874,19875,19904,19916,19967,19988,19996,20066,20180,20191,20376,20396,20398,20418,20448,20488,20599,20642,20656,20662,20663,20690,20839,20921,20966,20967,20997,21036,21095,21198,21203,21279,21329,21413,21473,21487,21520,21523,21524,21560,21566,21598,21612,21718,21719,21720,21726,21741,21787,21835,21891,21932,22038,22067,22129,22249,22253,22419,22450,22453,22494,22620,22659,22726,22739,22761,22779,22781,22850,22851,22870,22886,22964,23065,23104,23123,23161,23184,23201,23213,23273,23287,23328,23365,23397,23400,23479,23482,23493,23523,23720,23788,23932,24027,24043,24062,24145,24153,24185,24199,24208,24247,24281,24286,24316,24334,24399,24406,24463,24485,24497,24539,24690,24766,24906,24920,24933,24951,24952,25030,25032,25062,25112,25505,25518,25554,25589,25639,25646,25648,25671,25673,25689,25723,25727,25734,25747,25757,25758,25771,25800,25817,25830,25836,25916,25924,25927,25941,25942,25949,25961,25966,25990,25992,25994,25995,26000,26010,26013,26025,26033,26035,26037,26043,26044,26060,26082,26083,26087,26100,26113,26120,26136,26146,26147,26148,26153,26161,26185,26187,26191,26194,26215,26221,26227,26234,26241,26259,26296,26337,26359,26386,26388,26405,26447,26504,26578,26630,26652,26707,26762,26780,26820,26825,26843,26873,26874,26897,26916,26927,26933,26944,26949,26964,26968,26982,26991,27023,27103,27108,27109,27137,27192,27196,27209,27211,27212,27216,27240,27242,27252,27268,27269,27270,27291,27298,27307,27323,27327,27340,27344,27354,27367,27405,27487,27502,27511,27522,27526,27578,27583,27595,27688,27702,27707,27717,27786,27843,27875,27922,27923,27924,28019,28031,28059,28066,28075,28094,28097,28114,28120,28129,28152,28193,28218,28237,28243,28264,28281,28327,28334,28340,28435,28436,28437,28540,28548,28553,28555,28615,28616,28629,28656,28665,28666,28668,28671,28706,28707,28725,28727,28728,28745,28763,28776,28795,28799,28800,28803,28807,28828,28833,28834,28844,28846,28847,28866,28872,28878,28925,28931,28943,28995,29006,29013,29045,29127,29152,29166,29201,29226,29229,29272,29329,29374,29389,29418,29459,29468,29611,29616,29716,29724,29894,30111,30138,30199,30262,30572,30573,31401,31735,31820,31837,31853,32286,32720,32755,32767,32768,32965,33107,33327,33503,33874,33908,34265,34595,34646,34785,34811,34862,34902,34942,34969,34982,35051,35071,35072,35073,35088,35097,35100,35156,35165,35167,35191,35206,35232,35238,35239,35250,35269,35289,35294,35295,35298,35308,35326,35345,35365,35376,35397,35427,35430,35538,35540,35554,35564,35588,35621,35641,35657,35674,35685,35694,35724,35728,35744,35808,35814,35835,35846,35931,35948,36012,36015,36141,36165,36191,36213,36220,36285,36303,36346,36355,36368,36373,36380,36385,36386,36412,36441,36442,36463,36489,36575,36750,36790,36791,36792,36793,36795,36798,36806,36849,36941,36984,37015,37104,37129,37245,37251,37370,37473,37508,37528,37529,37532,37544,37643,37644,37647,37677,37704,37757,37834,37902,37972,38058,38092,38212,38330,38365,38392,38417,38418,38437,38438,38449,38503,38505,38598,38599,38606,38617,38663,38681,38723,38734,38799,38821,38824,38825,38829,38877,38912,38964,38965,38988,38990,39039,39056,39061,39110,39133,39149,39155,39170,39205,39244,39290,39293,39297,39299,39301,39310,39366,39442,39460,39470,39519,39529,39559,39636,39686,39695,39696,39703,39718,39724,39765,39782,39837,39856,39882,39896,39897,39971,40017,40052,40059,40107,40110,40119,40136,40275,40290,40319,40344,40358,40481,40482,40560,40576,40624,40625,40655,40700,40757,40784,40855,40896,40925,41004,41009,41033,41063,41117,41123,41152,41171,41172,41176,41189,41201,41212,41225,41272,41289,41328,41339,41343,41348,41353,41380,41381,41415,41434,41479,41504,41520,41550,41571,41585,41591,41637,41668,41723,41737,41744,41757,41783,41862,41866,41874,41880,41948,41955,41964,41980,42034,42051,42104,42106,42309,42329,42394,42404,42482,42537,42603,42682,42736,42811,42822,42859,42941,43003,43043,43090,43093,43099,43104,43107,43117,43162,43163,43167,43221,43240,43241,43256,43259,43326,43351,43353,43375,43446,43461,43475,43477,43483,43517,43518,43520,43545,43603,43645,43697,43792,43944,44067,44078,44100,44101,44107,44122,44186,44187,44197,44378,44581,44632,44640,44650,44656,44718,44735,44752,44788,44807,44817,44829,44833,44873,44881,44893,44912,44935,44936,45134,45139,45174,45175,45217,45223,45236,45249,45274,45293,45295,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 | 1196 | 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.54 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.22 ms |
System lock | 0.02 ms |
optimizing | 0.10 ms |
statistics | 1.86 ms |
preparing | 0.99 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.30 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.06 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 |