Tiempo de la consulta: 3.85 ms Después de la última consulta: 0.79 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.338 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 09:51:47')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 09:51: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(8,75,233,380,468,471,474,479,485,489,544,559,583,597,601,622,633,672,681,692,697,701,709,710,769,772,783,796,797,817,826,837,846,874,893,902,903,905,923,999,1021,1044,1055,1092,1112,1149,1167,1184,1213,1235,1255,1258,1259,1269,1273,1317,1320,1323,1395,1398,1426,1476,1491,1575,1593,1683,1687,1718,1753,1828,1873,1880,1926,1929,2022,2065,2211,2227,2374,2388,2433,2474,2492,2569,2616,2618,2658,2697,2698,2779,2877,2988,2997,3000,3049,3071,3095,3113,3145,3214,3268,3284,3335,3440,3476,3513,3611,3758,3763,3796,3800,3845,3868,3869,3918,3926,3953,3958,3985,3988,4025,4046,4059,4079,4195,4229,4244,4300,4303,4356,4381,4386,4434,4589,4600,4640,4775,4785,4857,4880,4907,4932,4972,4978,5034,5165,5176,5195,5263,5292,5336,5563,5575,5581,5583,5629,5701,5707,5830,5853,5981,5994,6005,6021,6038,6041,6107,6115,6195,6228,6236,6295,6335,6393,6404,6420,6430,6453,6531,6548,6595,6635,6637,6661,6681,6747,6765,6784,6794,6960,6973,6985,7002,7023,7098,7172,7188,7193,7194,7202,7238,7271,7278,7303,7333,7360,7393,7394,7419,7520,7530,7567,7568,7714,7721,7723,7747,7759,7786,7801,7817,7837,7866,7941,7944,7956,7967,7996,8023,8054,8089,8114,8203,8243,8296,8316,8354,8415,8417,8475,8521,8646,8819,8845,8848,8964,8979,9083,9088,9131,9188,9206,9247,9288,9345,9375,9383,9395,9404,9433,9516,9557,9612,9642,9643,9799,9893,9970,10057,10126,10217,10254,10312,10353,10402,10449,10461,10486,10505,10528,10565,10655,10678,10814,10853,10854,10879,10909,11138,11159,11238,11305,11358,11397,11407,11408,11455,11541,11568,11673,11709,11753,11795,11842,11857,11927,11989,12037,12123,12141,12146,12202,12263,12372,12381,12421,12482,12523,12567,12655,12723,12757,12818,12893,12896,12903,12926,12976,12993,13023,13068,13073,13080,13126,13139,13164,13185,13202,13208,13209,13230,13232,13296,13297,13314,13336,13343,13357,13358,13411,13413,13491,13508,13606,13682,13711,13729,13754,13856,13875,14012,14017,14041,14064,14067,14073,14091,14098,14136,14156,14174,14176,14179,14199,14214,14242,14262,14268,14288,14290,14304,14338,14419,14427,14469,14549,14562,14563,14574,14582,14585,14633,14656,14664,14672,14702,14747,14756,14766,14774,14778,14812,14813,14838,14862,14866,14876,14882,14970,15015,15047,15061,15066,15175,15185,15197,15218,15223,15250,15315,15321,15327,15332,15347,15433,15445,15528,15529,15563,15566,15601,15619,15706,15731,15732,15788,15824,15856,15901,15917,15929,15980,16019,16053,16094,16123,16175,16202,16287,16348,16377,16441,16448,16488,16497,16530,16585,16589,16624,16631,16676,16698,16732,16758,16798,16811,16813,16857,16897,17022,17035,17055,17059,17064,17089,17142,17146,17150,17165,17169,17197,17209,17240,17255,17263,17352,17363,17367,17378,17393,17417,17424,17436,17448,17450,17457,17462,17488,17507,17513,17591,17630,17684,17697,17722,17724,17733,17739,17784,17788,17808,17815,17844,17884,17907,17932,17950,17964,17985,18002,18013,18021,18037,18061,18138,18150,18182,18203,18237,18243,18245,18383,18417,18502,18527,18564,18576,18599,18677,18678,18686,18710,18767,18771,18777,18778,18795,18817,18824,18829,18834,18835,18838,18853,18917,18955,18968,18972,18976,18992,18996,19019,19036,19041,19081,19084,19085,19157,19159,19164,19167,19186,19189,19216,19237,19286,19328,19398,19420,19436,19466,19525,19536,19557,19558,19575,19579,19586,19603,19643,19644,19701,19704,19708,19712,19740,19755,19765,19769,19796,19801,19803,19829,19842,19895,19918,19924,19952,19963,20027,20055,20062,20093,20107,20211,20227,20233,20298,20307,20308,20323,20326,20395,20401,20433,20442,20475,20544,20569,20584,20622,20623,20688,20698,20728,20750,20751,20754,20763,20781,20788,20791,20832,20864,20876,20884,20934,20943,20946,20969,21048,21109,21174,21176,21186,21216,21229,21308,21359,21362,21379,21401,21414,21528,21533,21535,21616,21632,21653,21728,21758,21826,21830,21849,21874,21897,21978,21983,22019,22055,22064,22070,22084,22092,22108,22126,22165,22196,22203,22260,22271,22275,22290,22304,22306,22313,22315,22379,22392,22448,22482,22497,22511,22522,22549,22551,22578,22610,22638,22660,22665,22685,22704,22716,22782,22823,22824,22828,22832,22896,22927,22940,22945,22981,22982,23038,23061,23068,23114,23116,23145,23290,23322,23333,23337,23409,23413,23419,23472,23508,23531,23551,23572,23590,23595,23654,23677,23777,23795,23809,23842,23867,23985,24022,24085,24094,24179,24244,24331,24363,24391,24427,24438,24442,24527,24537,24652,24664,24691,24729,24783,24831,24922,24923,24971,25077,25086,25128,25153,25186,25191,25198,25228,25271,25315,25433,25482,25562,25593,25598,25630,25713,25723,25770,25789,25802,25842,25848,25871,25902,25914,25930,25940,26018,26068,26079,26096,26152,26332,26397,26500,26625,26661,26702,26759,26797,26841,26881,26890,26919,26922,27010,27053,27113,27164,27184,27237,27260,27398,27464,27686,27742,27770,27878,27971,28004,28080,28179,28290,28479,28655,28659,28925,29791,30234,30252,30253,30254,30455,34114,35071,35072,35073,35087,35186,35222,35325,36147,36222,36401,36403,37134,38005,38036,38217,38239,38832,38844,38846,38954,39067,39099,39110,39142,39144,39269,39286,39348,39566,39644,39680,39767,39833,39925,39972,39982,40010,40077,40100,40134,40238,40591,40756,40810,40880,40887,41136,41602,41908,42451,42830,44081,44097,44931,45049)
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 | 905 | 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.46 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.18 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.33 ms |
preparing | 0.70 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.40 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 |