Tiempo de la consulta: 4.86 ms Después de la última consulta: 1.15 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.367 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 08:14:47')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 08:14:47')
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(43,49,83,136,137,140,142,143,144,145,146,178,179,185,214,259,271,281,316,362,367,368,374,398,416,450,489,522,556,608,621,686,697,710,723,728,752,754,784,825,843,854,931,963,964,977,980,986,1006,1044,1047,1080,1130,1143,1158,1207,1223,1230,1252,1253,1256,1280,1286,1302,1318,1339,1344,1351,1364,1371,1428,1440,1461,1468,1496,1503,1540,1541,1556,1565,1601,1649,1660,1664,1673,1690,1776,1782,1823,1827,1870,1916,2000,2013,2089,2109,2110,2115,2207,2233,2332,2354,2357,2384,2396,2540,2628,2643,2720,2728,2729,2735,2765,2870,2896,2898,2922,2939,2957,3033,3040,3074,3117,3126,3177,3223,3257,3283,3301,3332,3346,3375,3377,3397,3427,3478,3512,3564,3567,3574,3590,3641,3669,3687,3759,3838,3847,3881,3899,3934,3962,4015,4019,4025,4172,4192,4194,4214,4257,4341,4371,4378,4386,4468,4496,4622,4674,4677,4690,4693,4704,4718,4741,4745,4751,4765,4816,4825,4834,4856,4876,4896,4959,5052,5053,5072,5138,5149,5233,5247,5285,5298,5299,5389,5398,5454,5484,5495,5515,5530,5578,5587,5633,5644,5647,5659,5669,5710,5729,5814,5827,5837,5840,5850,5880,5888,5933,5940,5951,5972,6047,6051,6067,6071,6094,6164,6176,6203,6211,6267,6283,6284,6359,6381,6422,6438,6445,6453,6470,6501,6538,6567,6573,6582,6619,6690,6706,6729,6802,6816,6825,6832,6847,6916,6918,6950,6965,6966,6968,6976,6989,7002,7016,7022,7043,7048,7075,7104,7105,7156,7161,7168,7175,7219,7225,7291,7380,7387,7401,7403,7414,7427,7428,7461,7500,7508,7531,7546,7555,7584,7592,7594,7619,7630,7647,7670,7678,7726,7730,7742,7766,7823,7831,7849,7856,7860,7866,7867,7871,7920,7935,7936,7951,7957,7966,7970,7983,7989,7991,7993,7995,7998,8037,8108,8129,8141,8169,8183,8185,8189,8204,8205,8223,8236,8245,8246,8247,8269,8295,8315,8320,8355,8356,8380,8391,8401,8426,8452,8471,8521,8537,8551,8565,8569,8571,8602,8613,8626,8630,8667,8757,8773,8776,8813,8816,8834,8838,8839,8845,8877,8888,8912,8921,8950,8952,8983,8986,9010,9029,9056,9058,9091,9109,9114,9115,9131,9136,9149,9158,9164,9199,9200,9201,9203,9223,9239,9263,9351,9401,9425,9429,9442,9487,9564,9590,9619,9653,9728,9731,9752,9757,9767,9791,9818,9842,9878,9880,9881,10017,10028,10120,10144,10156,10187,10268,10275,10298,10299,10315,10317,10340,10375,10376,10392,10415,10468,10491,10561,10562,10596,10612,10673,10689,10764,10777,10796,10803,10835,10860,10896,10916,10938,10939,10948,10953,10970,10975,10991,11001,11016,11037,11060,11074,11075,11091,11093,11120,11165,11186,11192,11249,11252,11255,11260,11285,11292,11310,11320,11343,11361,11371,11377,11430,11491,11611,11626,11629,11648,11661,11694,11729,11737,11738,11739,11789,11800,11808,11814,11816,11863,11909,11938,11967,12002,12042,12081,12082,12094,12112,12118,12147,12174,12204,12218,12219,12283,12302,12326,12332,12334,12339,12356,12364,12377,12384,12401,12406,12410,12427,12441,12492,12500,12511,12513,12526,12538,12567,12579,12609,12621,12622,12625,12681,12709,12752,12806,12811,12839,12878,12880,12888,12897,12990,12992,13002,13004,13011,13036,13056,13110,13125,13129,13150,13152,13153,13207,13216,13217,13319,13377,13387,13436,13445,13461,13475,13492,13500,13501,13554,13585,13586,13608,13613,13629,13666,13685,13696,13707,13730,13731,13734,13748,13750,13775,13811,13837,13851,13858,13859,13880,13900,13922,14002,14038,14047,14052,14099,14116,14126,14212,14257,14258,14287,14289,14328,14382,14386,14398,14402,14426,14432,14457,14468,14540,14600,14610,14612,14642,14643,14676,14758,14782,14791,14847,14873,14879,14915,14939,14960,14980,14986,14988,15003,15063,15086,15117,15119,15135,15144,15162,15173,15177,15198,15205,15208,15227,15286,15306,15325,15332,15339,15400,15408,15464,15488,15501,15508,15569,15594,15596,15608,15672,15682,15732,15742,15744,15755,15778,15791,15843,15888,15898,15903,15917,16030,16066,16088,16096,16133,16180,16278,16340,16362,16365,16381,16417,16423,16439,16446,16447,16450,16466,16503,16507,16523,16542,16571,16622,16644,16646,16647,16657,16667,16675,16698,16806,16814,16815,16818,16831,16840,16844,16865,16866,16887,16898,16905,16935,16985,16994,17011,17047,17055,17090,17096,17108,17142,17143,17190,17194,17233,17247,17291,17292,17336,17376,17410,17417,17440,17446,17449,17452,17456,17458,17487,17514,17518,17536,17559,17588,17599,17630,17632,17635,17643,17662,17688,17712,17725,17734,17737,17767,17784,17814,17823,17838,17839,17845,17863,17881,17887,17896,17933,17941,17947,17989,17990,18006,18066,18074,18088,18096,18126,18136,18139,18142,18186,18203,18257,18301,18311,18320,18351,18447,18463,18466,18469,18473,18490,18524,18548,18552,18587,18658,18661,18668,18693,18708,18716,18739,18750,18770,18807,18810,18811,18816,18830,18846,18849,18873,18881,18882,18892,18894,18909,18957,18959,18970,18984,18989,19003,19017,19031,19040,19096,19114,19120,19129,19130,19131,19134,19145,19192,19221,19230,19260,19296,19306,19311,19327,19330,19339,19344,19367,19381,19390,19400,19413,19424,19460,19463,19520,19521,19529,19536,19572,19586,19587,19622,19644,19647,19733,19848,19853,19881,19883,19915,19982,19984,19993,20041,20042,20056,20057,20067,20095,20104,20111,20134,20135,20148,20152,20156,20158,20163,20170,20177,20188,20189,20239,20276,20286,20345,20362,20382,20420,20424,20450,20457,20474,20483,20515,20624,20644,20654,20683,20708,20752,20778,20854,20869,20886,20888,20913,20940,20960,20981,21062,21075,21112,21115,21132,21154,21218,21229,21247,21255,21268,21295,21307,21321,21350,21376,21392,21398,21402,21416,21449,21453,21459,21474,21487,21489,21500,21521,21577,21610,21611,21614,21628,21689,21707,21716,21720,21775,21791,21803,21863,21895,21909,21928,21956,21961,21962,21964,22033,22039,22045,22071,22075,22079,22100,22132,22138,22176,22196,22207,22251,22316,22326,22344,22349,22363,22382,22395,22436,22444,22445,22488,22525,22584,22619,22623,22633,22654,22659,22669,22689,22693,22698,22709,22749,22754,22804,22840,22851,22868,22917,22930,22936,22989,23057,23072,23077,23087,23099,23116,23127,23176,23196,23250,23279,23289,23332,23367,23368,23377,23397,23401,23414,23431,23444,23457,23471,23527,23535,23555,23627,23657,23665,23686,23693,23709,23716,23726,23728,23741,23787,23801,23869,23882,23884,23888,23920,23937,23965,23969,23973,24003,24033,24051,24066,24090,24100,24115,24143,24164,24170,24175,24182,24184,24185,24270,24284,24379,24439,24441,24461,24481,24489,24520,24556,24591,24594,24619,24620,24720,24754,24755,24775,24795,24801,24816,24865,24912,24998,25002,25026,25090,25109,25164,25192,25304,25408,25441,25473,25477,25484,25517,25519,25535,25601,25638,25664,25672,25730,25740,25769,25790,25835,25995,26038,26048,26125,26298,26374,26421,26516,26521,26561,26579,26595,26596,26601,26629,26638,26659,26760,26771,26772,26915,26935,26936,26963,27009,27039,27100,27101,27134,27175,27184,27233,27259,27326,27344,27346,27353,27354,27381,27384,27412,27445,27455,27479,27480,27490,27491,27524,27526,27559,27571,27630,27634,27673,27688,27783,27806,27808,27809,27898,28068,28129,28280,28295,28336,28372,28478,28483,28545,28562,28577,28671,28777,28829,28979,28982,28999,29077,29091,29127,29214,29219,29223,29269,29293,29484,30269,32331,32565,34944,35135,35366,35574,35588,35684,35710,35834,35857,35886,35891,35922,35926,35972,36267,36315,36364,36427,36707,36901,37576,37851,37925,38651,38689,38855,38884,38898,38962,39112,39321,39773,40034,40096,40369,40483,40636,40789,40822,40835,41025,42284,42494,42833,43360,43412,43543,44914,44915,45071,45072,45141,45240,45252)
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 | 1283 | 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.59 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.25 ms |
System lock | 0.02 ms |
optimizing | 0.11 ms |
statistics | 1.98 ms |
preparing | 0.96 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.35 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 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 |