Tiempo de la consulta: 6.24 ms Después de la última consulta: 0.90 ms Consulta a la memoria: 0.408 MB memoria antes de la consulta: 4.211 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 12:39:22')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 12:39:22')
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,197,328,385,407,495,595,734,770,935,971,981,1198,1280,1352,1354,1357,1358,1455,1535,1603,1634,1646,1713,1781,1785,1800,1802,1804,1822,1846,1900,1913,2071,2123,2203,2210,2228,2260,2305,2337,2378,2424,2468,2509,2598,2601,2613,2632,2668,2688,2689,2805,2825,2828,2952,2967,3059,3067,3076,3087,3111,3202,3211,3212,3216,3258,3312,3319,3337,3373,3408,3410,3475,3517,3594,3606,3663,3718,3719,3725,3821,3849,3871,4033,4131,4157,4166,4215,4227,4315,4320,4383,4384,4493,4531,4612,4613,4614,4615,4617,4643,4770,4774,4791,4832,4836,4852,4910,4917,4920,4931,4947,4957,4990,5086,5092,5104,5150,5170,5173,5211,5218,5224,5237,5268,5295,5298,5315,5356,5456,5559,5767,5792,5798,5814,5854,5862,5911,5912,5917,5932,5943,5944,5953,5961,5973,6039,6050,6055,6062,6080,6082,6116,6131,6135,6167,6186,6192,6264,6268,6270,6282,6306,6324,6340,6412,6479,6571,6586,6588,6609,6645,6665,6698,6711,6718,6788,6809,6830,6897,6910,6917,6919,6927,6928,6933,6945,6977,6985,7001,7031,7081,7148,7205,7271,7321,7330,7358,7396,7416,7482,7526,7561,7565,7585,7604,7624,7659,7669,7690,7696,7735,7737,7745,7799,7810,7813,7825,7837,7866,7913,7933,7963,8000,8026,8085,8125,8222,8250,8259,8281,8298,8323,8354,8407,8416,8436,8437,8438,8462,8532,8603,8621,8655,8660,8687,8706,8711,8764,8964,8972,9012,9018,9031,9051,9091,9142,9157,9196,9197,9239,9308,9330,9365,9370,9529,9552,9646,9673,9757,9823,9863,9865,9869,9920,9948,10039,10100,10126,10184,10260,10297,10301,10352,10400,10422,10458,10510,10598,10603,10604,10634,10764,10811,11098,11106,11107,11305,11323,11335,11356,11425,11464,11476,11627,11703,11721,11722,11803,11859,11919,11960,12035,12113,12216,12224,12254,12437,12488,12525,12541,12592,12609,12627,12650,12669,12686,12708,12857,13154,13175,13188,13268,13276,13328,13349,13352,13474,13501,13535,13575,13576,13671,13685,13693,13727,13748,13750,13782,13783,13846,13858,13924,13941,13947,14008,14050,14079,14122,14169,14263,14327,14353,14356,14357,14430,14524,14648,14661,14663,14669,14679,14688,14703,14709,14713,14726,14733,14744,14749,14754,14762,14785,14790,14832,14846,14849,14860,14862,14905,14906,14911,14949,14970,14973,14992,14996,15020,15045,15046,15058,15077,15114,15128,15161,15179,15208,15209,15217,15234,15262,15293,15298,15304,15310,15365,15366,15517,15539,15540,15594,15689,15751,15753,15785,15791,15796,15851,15862,15870,15893,15917,15937,15945,15969,15988,16057,16120,16122,16156,16157,16346,16354,16422,16439,16440,16455,16465,16526,16562,16578,16587,16611,16646,16654,16678,16728,16787,16802,16809,16862,16877,16894,16993,17014,17034,17121,17133,17136,17166,17167,17199,17296,17304,17334,17335,17344,17353,17369,17385,17409,17412,17433,17530,17531,17584,17597,17609,17630,17635,17700,17826,17857,17862,17902,17910,17927,17956,17976,17977,18022,18028,18029,18067,18165,18170,18227,18262,18334,18362,18473,18590,18658,18671,18705,18707,18739,18782,18825,18866,18906,18907,18911,18912,18926,18927,18929,18930,18953,18974,19024,19123,19127,19153,19155,19204,19211,19235,19236,19245,19268,19299,19353,19426,19432,19472,19484,19487,19507,19706,19723,19750,19796,19845,19875,19876,19904,19916,19967,19988,20041,20066,20068,20100,20156,20157,20166,20180,20309,20338,20376,20396,20398,20434,20437,20469,20488,20521,20565,20574,20592,20642,20648,20656,20688,20690,20750,20751,20792,20953,20986,20990,21087,21198,21259,21329,21332,21401,21405,21413,21453,21487,21520,21523,21524,21547,21566,21598,21602,21612,21614,21718,21719,21722,21726,21769,21773,21787,21811,21824,21891,21932,21956,22031,22033,22067,22129,22137,22253,22262,22267,22419,22453,22481,22494,22581,22620,22659,22739,22761,22781,22790,22850,22851,22869,22871,22886,22914,22925,22959,22964,23036,23037,23072,23083,23099,23104,23119,23123,23184,23201,23213,23229,23273,23287,23309,23328,23365,23398,23471,23479,23489,23493,23523,23704,23720,23885,23891,23897,23905,23907,23964,24027,24029,24043,24062,24067,24077,24145,24153,24185,24199,24208,24247,24281,24286,24316,24334,24399,24406,24463,24485,24497,24539,24617,24766,24781,24785,24834,24906,24951,24952,25032,25038,25062,25068,25201,25329,25377,25450,25505,25518,25548,25554,25589,25621,25622,25639,25646,25648,25671,25673,25717,25723,25727,25734,25747,25757,25758,25771,25800,25817,25830,25836,25916,25924,25927,25941,25942,25949,25961,25990,25992,25994,25995,26000,26010,26013,26025,26033,26035,26060,26082,26087,26113,26120,26136,26146,26147,26153,26161,26185,26187,26191,26194,26215,26221,26227,26234,26259,26296,26335,26337,26359,26386,26388,26565,26572,26576,26620,26630,26639,26646,26652,26691,26699,26780,26784,26820,26845,26873,26879,26916,26927,26933,26935,26944,26964,26966,26968,27065,27067,27103,27108,27109,27119,27137,27192,27196,27209,27211,27212,27216,27240,27242,27252,27268,27269,27270,27298,27307,27323,27327,27367,27405,27408,27423,27487,27492,27526,27541,27568,27570,27578,27583,27595,27688,27707,27717,27786,27922,27923,27924,28019,28031,28059,28066,28075,28094,28097,28114,28120,28129,28162,28237,28243,28264,28329,28435,28846,28931,28943,28995,29045,29067,29152,29166,29226,29229,29272,29611,29616,29716,29724,30111,31735,31820,31837,31853,32720,32767,32768,33874,33908,34616,34646,34811,35100,35191,35232,35238,35239,35250,35289,35295,35345,35365,35376,35397,35540,35554,35621,35641,35728,35744,35806,35808,35814,35835,35846,35882,35948,36015,36141,36220,36368,36369,36373,36380,36385,36386,36441,36458,36790,36791,36792,36793,36849,36941,36984,37015,37104,37245,37370,37473,37508,37544,37643,37644,37677,37757,37834,37902,38058,38092,38133,38330,38418,38617,38681,38723,38734,38799,38821,38824,38829,38877,38912,38949,38965,38990,39039,39110,39133,39155,39205,39244,39290,39293,39297,39366,39442,39460,39470,39519,39559,39587,39686,39718,39724,39837,39856,40059,40275,40319,40509,40560,40576,40624,40855,40896,40969,41004,41009,41033,41123,41152,41171,41172,41176,41189,41201,41212,41225,41272,41289,41328,41338,41339,41343,41348,41415,41434,41479,41504,41550,41571,41591,41637,41737,41757,41783,41830,41857,41862,41948,41964,41980,41990,42017,42104,42329,42482,42682,42736,42811,42941,43003,43043,43093,43104,43117,43167,43221,43240,43241,43326,43375,43446,43461,43475,43477,43483,43517,43518,43792,44062,44122,44186,44187,44378,44581,44632,44640,44656,44718,44735,44788,44807,44829,44873,44881,44912,44935,44936,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 | 1094 | 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.62 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.21 ms |
System lock | 0.02 ms |
optimizing | 0.08 ms |
statistics | 1.66 ms |
preparing | 0.91 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 1.74 ms |
end | 0.02 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 |