Tiempo de la consulta: 5.02 ms Después de la última consulta: 1.20 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.363 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-08 14:56:55')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-08 14:56:55')
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(11,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,67,68,74,75,76,77,78,81,87,88,89,110,111,117,125,136,140,142,143,144,145,146,178,179,188,189,190,200,205,207,208,234,246,248,249,263,271,272,278,281,287,325,331,344,350,353,362,380,385,412,415,416,417,420,421,422,423,424,426,427,429,431,484,489,496,501,503,531,574,575,586,593,686,697,717,723,744,785,831,844,853,857,862,868,942,964,976,978,986,1024,1044,1047,1080,1130,1143,1158,1168,1175,1187,1207,1208,1215,1223,1232,1252,1253,1256,1287,1302,1305,1319,1339,1353,1357,1434,1459,1506,1664,1698,1709,1718,1851,1878,2005,2108,2112,2208,2272,2394,2713,2825,2962,2997,3020,3051,3126,3212,3223,3301,3325,3340,3442,3650,3669,3682,3687,3696,3814,3870,3982,4310,4378,4563,4587,4674,4765,4863,4902,4905,5060,5189,5324,5392,5476,5538,5647,5659,5685,5730,5798,5814,5895,6039,6298,6311,6315,6381,6392,6470,6482,6484,6538,6570,6573,6616,6666,6671,6748,6776,6836,6868,6965,6966,6968,6989,7016,7017,7043,7050,7056,7075,7109,7124,7125,7138,7161,7189,7210,7282,7287,7291,7296,7311,7361,7380,7387,7401,7402,7403,7414,7427,7432,7450,7486,7508,7546,7692,7716,7730,7782,7801,7811,7831,7836,7838,7839,7860,7861,7867,7914,7931,7933,7946,7957,7965,7970,7981,7983,7985,7989,7993,8027,8108,8134,8215,8356,8444,8531,8551,8555,8565,8589,8602,8610,8638,8835,8856,8887,8950,9091,9203,9206,9239,9262,9282,9411,9428,9429,9472,9527,9532,9556,9650,9677,9678,9791,9895,9916,9924,9944,9945,10028,10035,10092,10100,10120,10193,10243,10260,10274,10280,10369,10383,10415,10453,10561,10682,10688,10777,10803,10834,10835,10916,11037,11091,11129,11192,11249,11260,11299,11310,11345,11377,11430,11482,11565,11688,11711,11808,11816,11822,11863,12020,12042,12070,12112,12133,12147,12150,12174,12204,12238,12324,12337,12401,12424,12427,12460,12492,12579,12609,12610,12611,12620,12625,12650,12668,12670,12681,12685,12686,12708,12709,12780,12806,12846,12913,12944,12973,12990,12996,13004,13014,13016,13036,13124,13152,13153,13216,13294,13348,13445,13461,13474,13475,13476,13492,13500,13628,13657,13666,13696,13748,13750,13771,13783,13790,13816,13837,13880,13900,13922,13924,13934,13971,13973,14103,14116,14153,14229,14257,14258,14277,14285,14289,14293,14362,14370,14424,14426,14481,14534,14536,14554,14570,14596,14625,14676,14697,14700,14749,14771,14792,14860,14895,14939,14958,14986,14988,15007,15035,15038,15043,15065,15086,15114,15145,15173,15183,15205,15244,15245,15261,15286,15293,15332,15359,15368,15382,15408,15414,15419,15475,15476,15486,15493,15520,15522,15533,15569,15574,15577,15600,15632,15645,15669,15672,15714,15732,15742,15744,15753,15778,15785,15796,15812,15819,15843,15861,15876,15880,15898,15945,15957,15972,15975,16030,16055,16062,16071,16083,16115,16127,16133,16161,16176,16180,16200,16201,16249,16254,16278,16282,16297,16322,16334,16362,16381,16417,16430,16446,16464,16497,16516,16520,16523,16526,16542,16543,16556,16566,16611,16622,16629,16657,16665,16675,16684,16687,16698,16751,16791,16830,16833,16839,16861,16865,16908,16950,16976,17084,17096,17114,17142,17153,17163,17210,17253,17270,17274,17278,17288,17289,17300,17309,17331,17333,17334,17335,17336,17362,17410,17414,17419,17422,17443,17449,17471,17496,17521,17528,17540,17559,17598,17599,17607,17629,17630,17632,17655,17664,17688,17702,17712,17713,17721,17734,17761,17783,17784,17814,17851,17857,17933,17941,17950,17994,17995,18006,18071,18073,18074,18121,18162,18220,18229,18260,18285,18291,18300,18301,18309,18311,18318,18320,18351,18360,18364,18391,18463,18467,18520,18524,18549,18552,18558,18567,18577,18578,18651,18658,18664,18668,18671,18693,18720,18724,18750,18757,18762,18773,18810,18811,18819,18828,18830,18846,18849,18873,18894,18951,18959,18984,18989,19002,19003,19047,19060,19067,19105,19129,19134,19138,19145,19148,19170,19180,19185,19230,19253,19276,19282,19296,19311,19327,19344,19352,19376,19381,19424,19457,19501,19521,19532,19536,19551,19562,19572,19577,19619,19620,19622,19633,19648,19650,19661,19668,19687,19695,19732,19733,19772,19811,19825,19848,19869,19870,19881,19886,19908,19909,19915,19923,19931,19937,19958,19960,19980,19982,19984,19993,19998,20005,20010,20028,20032,20042,20056,20060,20086,20091,20095,20104,20141,20148,20156,20163,20168,20170,20187,20189,20192,20193,20200,20213,20234,20253,20256,20263,20271,20276,20286,20289,20308,20335,20345,20353,20382,20405,20439,20449,20450,20459,20474,20515,20516,20535,20540,20555,20564,20567,20595,20616,20630,20638,20648,20659,20666,20699,20700,20708,20714,20727,20729,20752,20778,20847,20866,20869,20913,20940,20960,20969,20981,20982,21011,21016,21038,21050,21058,21075,21159,21173,21189,21198,21225,21247,21256,21279,21283,21285,21288,21300,21305,21314,21321,21338,21350,21368,21392,21398,21422,21432,21449,21464,21482,21485,21486,21513,21521,21524,21526,21529,21545,21577,21611,21618,21620,21623,21636,21640,21650,21661,21664,21678,21690,21694,21695,21704,21719,21727,21730,21738,21764,21768,21775,21800,21824,21843,21850,21854,21863,21895,21910,21924,21928,21950,21954,21955,21961,21980,22000,22015,22018,22039,22062,22077,22079,22093,22100,22107,22117,22137,22139,22140,22146,22149,22163,22164,22180,22195,22207,22229,22241,22297,22302,22324,22326,22337,22349,22361,22363,22382,22395,22406,22421,22436,22446,22453,22488,22497,22512,22559,22580,22603,22620,22622,22626,22647,22655,22658,22659,22673,22693,22698,22709,22710,22712,22727,22754,22765,22774,22780,22787,22804,22820,22829,22833,22840,22865,22897,22903,22908,22923,22947,22972,22980,22988,22989,23007,23024,23043,23053,23062,23077,23082,23087,23089,23124,23144,23179,23186,23214,23233,23242,23275,23279,23281,23289,23295,23367,23368,23374,23397,23402,23444,23480,23495,23498,23507,23527,23528,23535,23555,23585,23599,23610,23636,23665,23682,23691,23693,23709,23716,23732,23763,23764,23787,23836,23840,23845,23858,23869,23912,23920,23927,23937,23955,23965,23969,24003,24016,24028,24033,24059,24066,24090,24115,24164,24165,24170,24176,24194,24226,24249,24270,24284,24342,24393,24408,24417,24441,24451,24461,24475,24481,24489,24520,24522,24540,24582,24586,24617,24639,24649,24653,24707,24720,24730,24754,24755,24775,24791,24795,24803,24804,24816,24850,24865,24884,24897,24937,24956,24993,25002,25003,25026,25030,25035,25045,25062,25069,25090,25109,25131,25138,25164,25171,25184,25192,25264,25289,25315,25318,25351,25352,25387,25406,25408,25436,25448,25477,25484,25517,25519,25535,25542,25544,25584,25601,25638,25640,25646,25660,25664,25672,25701,25702,25740,25775,25872,25904,25906,26000,26005,26033,26043,26147,26151,26221,26315,26317,26343,26360,26415,26421,26424,26454,26474,26521,26561,26596,26640,26651,26677,26708,26713,26742,26801,26807,26820,26845,26854,26881,26905,26907,26930,26944,26973,27000,27038,27039,27086,27141,27143,27151,27158,27233,27263,27271,27346,27358,27366,27384,27388,27435,27500,27506,27530,27560,27603,27634,27688,27722,27729,27846,27949,27968,27989,27990,28001,28029,28068,28072,28080,28101,28292,28295,28310,28336,28339,28372,28440,28442,28454,28478,28495,28511,28606,28614,28615,28616,28712,28728,28845,28882,28933,28944,28949,29054,29214,29219,29269,29412,29453,29454,29460,29484,29622,29635,29802,29911,29923,30740,31129,31286,31571,31604,32054,32331,32565,32905,33417,35105,35119,35330,35603,35713,35744,35955,36875,37977,37985,38003,38017,38229,38239,38264,38759,38884,38898,39398,39530,39594,39868,40036,40175,40351,40369,40492,40605,40636,40759,40931,41138,42649,43658,44805,45008)
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 | 1302 | 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.03 ms |
init | 0.24 ms |
System lock | 0.02 ms |
optimizing | 0.09 ms |
statistics | 1.95 ms |
preparing | 0.99 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.38 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.09 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 |