Tiempo de la consulta: 4.88 ms Después de la última consulta: 1.23 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.225 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 06:34:47')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 06:34: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(4,9,11,25,28,49,56,58,74,75,76,77,78,86,113,114,117,136,165,170,172,207,208,255,263,271,275,276,287,290,291,293,344,349,353,377,437,463,472,489,559,583,607,611,613,633,686,693,723,744,758,797,831,843,846,868,883,895,900,917,942,958,963,976,986,997,999,1021,1031,1207,1215,1232,1247,1258,1271,1273,1287,1339,1459,1486,1664,1687,1709,1718,1931,2290,2293,2304,2305,2325,2365,2563,2639,2713,2757,2796,2863,2901,2921,2988,2991,2997,3020,3028,3034,3045,3117,3124,3145,3209,3212,3284,3442,3476,3512,3604,3617,3668,3671,3738,3814,3842,3869,3870,3985,3986,4120,4128,4378,4387,4399,4549,4580,4771,4857,4863,4878,4902,5350,5365,5451,5458,5471,5559,5647,5675,5730,5830,5894,5994,6021,6039,6127,6131,6234,6298,6311,6405,6470,6473,6475,6484,6520,6542,6543,6573,6616,6630,6637,6656,6688,6723,6742,6744,6765,6815,6835,6860,6889,6895,6906,6936,6960,6985,6989,6998,7015,7023,7189,7232,7280,7282,7311,7343,7359,7361,7387,7402,7403,7410,7483,7486,7545,7567,7568,7586,7588,7614,7626,7677,7730,7816,7832,7836,7847,7861,7890,7894,7914,7934,7950,7959,7965,7967,7997,8027,8107,8108,8109,8134,8143,8177,8203,8408,8417,8476,8508,8614,8646,8691,8956,8979,9091,9194,9317,9318,9433,9593,9657,9826,9916,10092,10100,10110,10120,10149,10176,10181,10193,10203,10250,10260,10306,10311,10318,10369,10370,10379,10382,10393,10399,10415,10444,10453,10623,10682,10688,10697,10721,10782,10798,10814,10854,10872,10909,10951,10954,10957,10974,11015,11037,11063,11083,11158,11167,11173,11188,11226,11235,11337,11394,11479,11534,11545,11604,11709,11712,11726,11766,11779,11883,11916,11922,11987,12070,12081,12133,12243,12270,12306,12312,12449,12465,12520,12545,12567,12581,12582,12610,12611,12624,12625,12789,12846,12851,12873,12894,12907,12945,12978,13006,13035,13036,13041,13124,13137,13225,13241,13307,13332,13351,13361,13388,13390,13420,13466,13497,13508,13515,13611,13633,13729,13771,13790,13805,13817,13835,13851,13855,13906,13953,13968,13972,13978,13998,14024,14048,14097,14109,14113,14114,14143,14156,14183,14205,14223,14236,14277,14283,14285,14361,14370,14372,14409,14419,14453,14481,14507,14530,14558,14571,14625,14630,14684,14693,14695,14697,14700,14749,14754,14771,14775,14792,14811,14819,14820,14845,14852,14856,14966,14983,14984,14999,15007,15010,15034,15035,15038,15088,15129,15156,15164,15214,15217,15231,15232,15276,15304,15310,15335,15347,15351,15376,15406,15424,15451,15475,15486,15520,15522,15532,15551,15552,15581,15600,15655,15689,15700,15704,15714,15730,15742,15744,15753,15757,15764,15778,15779,15785,15790,15812,15819,15866,15876,15880,15897,15903,15965,16058,16095,16111,16127,16170,16200,16249,16250,16254,16282,16297,16302,16316,16324,16357,16366,16384,16415,16417,16427,16430,16431,16432,16495,16516,16521,16538,16542,16551,16611,16645,16657,16665,16675,16687,16695,16705,16724,16775,16781,16783,16816,16827,16839,16841,16857,16942,16996,17049,17084,17112,17116,17153,17163,17165,17188,17201,17227,17228,17231,17240,17242,17246,17263,17270,17274,17278,17285,17287,17288,17289,17300,17331,17333,17365,17386,17387,17407,17414,17422,17444,17495,17497,17510,17540,17553,17561,17573,17575,17598,17630,17634,17664,17671,17688,17704,17711,17712,17733,17736,17753,17766,17779,17783,17784,17834,17850,17851,17852,17862,17887,17907,17917,17919,17922,17925,17930,17936,17955,17967,17968,17983,17995,17996,18044,18060,18061,18121,18150,18161,18203,18222,18260,18276,18278,18291,18294,18295,18311,18318,18351,18364,18382,18391,18397,18428,18505,18527,18541,18549,18552,18571,18576,18577,18626,18651,18655,18664,18667,18668,18670,18682,18689,18693,18698,18706,18718,18724,18728,18730,18811,18817,18830,18846,18849,18874,18877,18888,18905,18948,18989,19015,19026,19051,19064,19105,19124,19128,19133,19138,19140,19145,19173,19175,19207,19220,19248,19287,19288,19310,19315,19322,19349,19379,19381,19403,19444,19460,19484,19486,19501,19516,19517,19531,19607,19639,19652,19659,19684,19708,19710,19711,19712,19725,19727,19733,19754,19794,19807,19846,19847,19869,19881,19923,19929,19937,19958,19960,19962,19973,19976,19984,19996,20018,20033,20089,20091,20097,20099,20107,20119,20127,20149,20154,20168,20174,20175,20186,20200,20220,20227,20234,20256,20297,20317,20333,20336,20366,20397,20405,20411,20437,20444,20445,20506,20540,20542,20549,20555,20587,20632,20638,20654,20659,20666,20668,20685,20686,20687,20714,20739,20772,20777,20779,20785,20797,20805,20809,20885,20897,20940,20959,20960,20969,20973,20985,20993,21009,21055,21058,21104,21113,21116,21117,21118,21128,21143,21183,21216,21228,21244,21305,21316,21344,21346,21367,21379,21390,21398,21418,21420,21421,21422,21429,21449,21457,21463,21470,21495,21520,21522,21540,21579,21611,21632,21662,21663,21667,21682,21684,21702,21713,21741,21764,21776,21778,21798,21846,21849,21852,21853,21856,21883,21905,21906,21917,21924,21931,21947,21950,21968,21977,21997,22000,22003,22012,22038,22055,22058,22063,22067,22089,22093,22098,22106,22119,22124,22139,22140,22149,22150,22154,22171,22178,22180,22212,22259,22278,22290,22298,22306,22313,22317,22348,22349,22389,22395,22450,22460,22476,22479,22497,22532,22555,22570,22596,22616,22617,22640,22644,22653,22661,22672,22693,22706,22708,22709,22718,22724,22746,22753,22759,22799,22804,22820,22837,22840,22854,22865,22901,22904,22944,22960,22978,23034,23041,23045,23046,23053,23060,23068,23070,23071,23087,23093,23112,23140,23144,23148,23233,23236,23242,23252,23253,23267,23279,23302,23305,23339,23363,23367,23368,23383,23405,23423,23430,23436,23438,23449,23488,23498,23501,23503,23527,23550,23553,23555,23566,23577,23599,23615,23665,23677,23682,23691,23693,23698,23706,23716,23727,23730,23743,23763,23784,23787,23790,23795,23816,23836,23838,23849,23912,23926,23955,23968,23978,23990,24012,24024,24025,24065,24076,24102,24118,24138,24147,24159,24164,24165,24176,24193,24219,24237,24270,24273,24283,24295,24372,24402,24403,24411,24417,24433,24440,24442,24456,24457,24461,24473,24475,24530,24550,24557,24577,24584,24597,24616,24649,24656,24658,24689,24690,24701,24716,24730,24732,24748,24751,24756,24779,24800,24805,24809,24830,24841,24850,24859,24930,24941,24946,24963,25003,25037,25048,25063,25069,25078,25080,25081,25086,25096,25112,25117,25123,25155,25165,25166,25180,25192,25206,25261,25287,25289,25297,25308,25329,25352,25358,25386,25387,25416,25418,25452,25462,25477,25523,25535,25560,25561,25564,25589,25591,25645,25657,25676,25701,25713,25738,25778,25789,25793,25795,25807,25814,25887,25888,25902,25919,25926,25930,25934,25971,25990,26043,26063,26102,26161,26205,26229,26258,26261,26302,26414,26483,26488,26493,26519,26525,26540,26541,26596,26711,26807,26854,26873,26901,26930,26959,27001,27022,27039,27041,27061,27062,27074,27094,27147,27151,27158,27221,27260,27263,27271,27272,27290,27304,27327,27373,27397,27407,27435,27471,27506,27518,27552,27565,27575,27578,27646,27686,27707,27745,27748,27802,27851,27871,27945,27949,27950,27968,27975,27990,28047,28066,28094,28213,28250,28264,28283,28310,28312,28398,28431,28464,28511,28606,28748,28749,28785,28799,28826,28892,28907,28908,28920,28928,28933,28949,28951,28972,28973,29026,29049,29061,29073,29099,29139,29140,29157,29171,29194,29208,29224,29349,29473,29500,29535,29539,29576,29622,29642,29673,29719,29790,29791,29868,29911,29912,29923,29939,30284,30449,31010,31286,32840,33082,36875,38900,38961,38986,39063,39099,39131,39172,39269,39323,39893,39972,39981,39998,40134,40168,40238,40347,40351,40611,40759,40993,41211,41257)
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 | 1278 | 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.61 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.24 ms |
System lock | 0.02 ms |
optimizing | 0.09 ms |
statistics | 1.95 ms |
preparing | 0.95 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.34 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 |