Tiempo de la consulta: 22.86 ms Después de la última consulta: 1.68 ms Consulta a la memoria: 3.221 MB memoria antes de la consulta: 4.389 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 06:32:29')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 06:32:29')
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(1,17,49,64,83,115,116,118,119,131,134,136,137,140,142,143,144,145,146,156,157,178,179,193,203,204,207,208,218,225,255,256,257,271,275,283,287,311,325,353,401,432,458,466,471,482,485,489,499,511,512,529,531,537,542,543,547,560,566,567,607,609,610,635,643,661,680,685,686,692,700,703,709,713,723,736,756,760,761,772,783,786,806,850,859,868,886,933,952,960,964,968,977,984,986,998,1024,1032,1034,1042,1044,1047,1048,1079,1080,1098,1106,1127,1130,1138,1142,1143,1150,1151,1158,1172,1185,1192,1194,1207,1226,1232,1252,1253,1255,1256,1265,1269,1271,1277,1279,1280,1287,1295,1302,1305,1317,1322,1339,1347,1349,1375,1420,1421,1425,1433,1435,1441,1444,1445,1447,1454,1455,1460,1466,1476,1481,1484,1534,1553,1586,1595,1600,1624,1666,1698,1768,1811,1812,1841,1852,1855,1870,1903,1906,1984,2001,2077,2148,2177,2193,2199,2203,2301,2359,2408,2432,2469,2480,2485,2629,2631,2691,2713,2724,2733,2773,2989,2997,3056,3119,3126,3202,3223,3278,3301,3353,3355,3364,3409,3500,3513,3520,3590,3594,3663,3668,3669,3687,3836,3872,3884,3898,3938,3940,3976,3992,3993,4063,4075,4116,4132,4153,4168,4176,4197,4252,4271,4309,4378,4409,4410,4436,4445,4453,4471,4477,4523,4524,4525,4539,4558,4580,4585,4586,4587,4605,4665,4692,4758,4765,4795,4822,4863,4874,4892,4919,4960,5001,5014,5035,5076,5079,5085,5143,5157,5166,5226,5250,5435,5496,5507,5508,5515,5534,5642,5647,5659,5700,5785,5814,5870,5876,5894,5936,5990,6007,6064,6068,6133,6200,6202,6217,6228,6308,6311,6323,6328,6396,6421,6448,6461,6470,6484,6512,6520,6533,6538,6553,6573,6596,6598,6648,6663,6667,6681,6707,6752,6775,6778,6806,6809,6828,6842,6874,6916,6932,6941,6965,6966,6968,6989,6994,7001,7016,7043,7075,7105,7161,7173,7176,7182,7200,7212,7237,7243,7245,7269,7276,7277,7291,7320,7358,7361,7378,7380,7387,7401,7403,7407,7414,7418,7421,7427,7435,7462,7486,7508,7516,7546,7611,7626,7688,7709,7719,7730,7748,7765,7769,7802,7824,7830,7831,7834,7839,7840,7845,7860,7867,7868,7870,7878,7931,7946,7951,7957,7965,7967,7983,7989,8027,8053,8054,8069,8091,8099,8106,8108,8206,8230,8283,8341,8351,8356,8361,8400,8445,8518,8551,8610,8627,8663,8695,8778,8864,8907,8909,8938,8944,8950,9052,9091,9108,9122,9132,9203,9239,9253,9429,9449,9462,9473,9531,9532,9548,9562,9580,9675,9690,9717,9772,9779,9791,9879,10024,10028,10050,10077,10079,10092,10100,10120,10197,10198,10260,10266,10290,10303,10316,10350,10371,10373,10415,10486,10499,10501,10518,10557,10616,10688,10690,10725,10731,10736,10775,10777,10803,10806,10831,10834,10835,10851,10916,10927,11087,11091,11182,11192,11195,11206,11223,11249,11260,11273,11310,11314,11377,11419,11428,11430,11441,11447,11468,11494,11542,11692,11705,11795,11808,11816,11840,11842,11859,11863,11867,11880,11885,11952,12025,12042,12089,12112,12147,12170,12174,12204,12216,12238,12334,12338,12363,12366,12401,12427,12439,12440,12475,12490,12492,12520,12579,12609,12611,12625,12681,12685,12709,12745,12757,12806,12810,12816,12822,12920,12946,12965,12977,12983,12990,12994,13004,13035,13036,13078,13160,13216,13235,13236,13258,13266,13272,13287,13297,13316,13344,13387,13428,13436,13437,13438,13445,13458,13461,13467,13476,13478,13479,13480,13481,13482,13492,13500,13502,13503,13525,13589,13597,13651,13660,13666,13696,13698,13784,13794,13797,13824,13837,13880,13922,13968,13985,14011,14069,14083,14109,14116,14139,14140,14153,14177,14205,14227,14232,14252,14257,14258,14277,14289,14309,14426,14429,14432,14481,14493,14506,14546,14557,14583,14591,14596,14610,14641,14646,14676,14684,14701,14710,14722,14774,14778,14792,14840,14864,14874,14895,14926,14939,14954,14958,14979,14986,14988,15007,15063,15065,15086,15109,15114,15138,15144,15147,15173,15205,15216,15229,15231,15256,15286,15297,15304,15332,15359,15408,15420,15441,15445,15455,15464,15543,15551,15558,15569,15577,15598,15600,15603,15632,15640,15644,15645,15672,15681,15714,15722,15732,15744,15753,15755,15759,15760,15766,15785,15812,15819,15877,15880,15884,15892,15898,15935,15966,15982,16014,16030,16052,16053,16054,16088,16125,16127,16133,16148,16180,16187,16200,16216,16249,16258,16277,16278,16297,16348,16359,16362,16381,16386,16410,16417,16466,16470,16523,16529,16542,16554,16558,16569,16586,16607,16609,16611,16622,16629,16634,16635,16642,16657,16658,16665,16675,16691,16698,16774,16780,16791,16815,16831,16843,16862,16865,16872,16964,16987,17001,17043,17059,17096,17121,17126,17131,17142,17149,17153,17163,17177,17186,17189,17224,17270,17280,17282,17331,17336,17341,17354,17355,17364,17381,17383,17384,17403,17410,17417,17422,17437,17449,17463,17478,17500,17555,17559,17596,17597,17598,17599,17617,17630,17632,17645,17650,17658,17660,17667,17688,17689,17699,17703,17712,17729,17734,17753,17772,17780,17784,17799,17814,17892,17907,17921,17927,17933,17941,17950,17954,17990,18001,18006,18013,18037,18039,18055,18074,18158,18160,18174,18176,18181,18202,18217,18260,18262,18263,18284,18290,18301,18311,18318,18320,18337,18352,18361,18364,18382,18427,18455,18463,18466,18485,18503,18520,18524,18527,18540,18547,18550,18552,18565,18576,18581,18586,18591,18642,18648,18658,18664,18668,18679,18693,18702,18705,18716,18739,18750,18808,18809,18810,18811,18813,18830,18839,18846,18847,18849,18850,18853,18873,18894,18898,18901,18916,18937,18957,18959,18984,18986,18989,18997,19003,19043,19060,19063,19105,19120,19129,19134,19135,19145,19184,19196,19217,19222,19230,19251,19270,19296,19303,19307,19311,19313,19331,19335,19343,19344,19377,19381,19383,19407,19412,19413,19419,19424,19433,19437,19440,19453,19455,19460,19484,19494,19504,19505,19521,19522,19536,19552,19556,19565,19566,19572,19593,19596,19604,19612,19622,19625,19640,19651,19670,19704,19720,19730,19733,19763,19766,19773,19779,19797,19816,19832,19848,19853,19864,19881,19915,19933,19937,19955,19979,19982,19984,19987,19993,19999,20004,20007,20042,20043,20051,20056,20076,20083,20091,20104,20142,20146,20148,20163,20167,20181,20189,20199,20202,20208,20229,20234,20236,20242,20265,20276,20279,20286,20332,20345,20352,20362,20382,20404,20422,20425,20427,20452,20474,20479,20515,20518,20568,20569,20574,20602,20605,20638,20659,20691,20708,20724,20739,20752,20753,20765,20769,20773,20774,20776,20778,20795,20799,20803,20805,20817,20826,20835,20869,20871,20890,20913,20915,20933,20940,20950,20960,20969,20981,21017,21075,21105,21110,21116,21152,21184,21189,21197,21205,21242,21247,21280,21284,21293,21321,21350,21366,21378,21392,21398,21408,21411,21415,21422,21437,21438,21449,21452,21465,21491,21494,21518,21521,21527,21540,21577,21601,21606,21609,21611,21620,21659,21662,21691,21714,21749,21766,21775,21777,21779,21821,21849,21863,21864,21895,21915,21928,21957,21961,22011,22039,22079,22089,22126,22140,22149,22173,22207,22225,22248,22268,22326,22345,22349,22350,22363,22366,22378,22382,22395,22400,22415,22416,22419,22431,22436,22464,22488,22530,22559,22600,22607,22653,22659,22666,22677,22693,22698,22709,22710,22715,22718,22722,22740,22753,22754,22756,22766,22793,22804,22840,22848,22850,22864,22865,22872,22875,22903,22906,22920,22921,22933,22934,22935,22976,22978,22989,23002,23006,23017,23031,23032,23039,23040,23050,23053,23077,23080,23087,23101,23103,23114,23126,23151,23213,23221,23233,23271,23277,23279,23284,23289,23296,23313,23317,23343,23344,23353,23354,23367,23368,23373,23380,23394,23396,23397,23406,23417,23444,23445,23453,23457,23466,23477,23495,23512,23520,23527,23535,23544,23547,23555,23569,23592,23593,23597,23633,23634,23638,23646,23651,23659,23665,23666,23677,23682,23691,23693,23695,23701,23709,23715,23716,23719,23722,23732,23740,23743,23747,23761,23763,23768,23769,23782,23787,23792,23806,23816,23827,23859,23860,23868,23869,23872,23874,23914,23920,23937,23954,23955,23965,23969,23998,24001,24003,24017,24033,24052,24059,24066,24090,24115,24164,24165,24170,24171,24176,24198,24207,24212,24258,24260,24270,24284,24299,24373,24437,24439,24441,24447,24455,24461,24470,24481,24520,24524,24543,24565,24599,24608,24659,24672,24718,24720,24726,24754,24755,24775,24780,24784,24790,24795,24816,24819,24838,24851,24857,24865,24875,24884,24905,24927,24942,24960,24966,24977,24995,25002,25010,25026,25039,25090,25096,25104,25109,25119,25141,25143,25164,25170,25172,25192,25193,25197,25199,25200,25207,25252,25260,25278,25281,25284,25289,25292,25317,25326,25345,25353,25356,25366,25406,25408,25435,25470,25477,25484,25486,25490,25502,25512,25517,25519,25535,25542,25595,25601,25609,25615,25616,25621,25638,25650,25655,25664,25672,25693,25705,25717,25740,25778,25792,25881,25886,25943,25964,26103,26109,26154,26166,26167,26171,26179,26218,26238,26257,26293,26324,26338,26348,26353,26375,26389,26412,26421,26431,26468,26479,26513,26521,26530,26561,26589,26596,26605,26654,26722,26744,26753,26776,26792,26797,26807,26835,26842,26843,26852,26854,26857,26864,26909,26933,26939,26944,26945,26950,26951,26959,27008,27015,27020,27024,27035,27039,27046,27054,27055,27059,27076,27093,27149,27151,27158,27197,27233,27237,27248,27274,27280,27298,27305,27311,27346,27356,27383,27384,27414,27415,27420,27438,27453,27477,27491,27566,27572,27610,27634,27720,27742,27779,27822,27832,27859,27911,27921,27923,27924,27926,27991,28068,28189,28233,28295,28306,28310,28316,28372,28476,28478,28598,28628,28716,28746,28910,28922,29023,29123,29214,29219,29223,29235,29269,29373,29380,29466,29484,29499,29548,29584,29611,29777,29814,29834,29864,29887,29909,30111,30280,30562,31384,31640,31908,32136,32331,32530,32565,32919,33345,33932,34174,34676,35102,35226,35299,35337,35360,35379,35434,35596,35628,35632,35667,35713,35730,35741,35744,35759,35780,35784,35803,35921,35989,36017,36041,36085,36200,36235,36297,36633,36751,36817,36949,36958,36961,37034,37107,37116,37170,37397,37403,37439,37454,38006,38103,38114,38122,38128,38315,38343,38398,38440,38446,38452,38530,38549,38674,38783,38800,38852,38884,38898,38916,38960,38985,39027,39052,39150,39163,39178,39193,39245,39276,39315,39318,39319,39347,39369,39375,39389,39475,39492,39600,39609,39653,39706,39722,39747,39768,39802,39858,39941,39998,40018,40050,40064,40089,40214,40231,40276,40332,40369,40398,40414,40436,40438,40460,40465,40535,40554,40555,40562,40614,40636,40667,40684,40688,40706,40772,40774,40811,40817,40959,41040,41068,41100,41150,41220,41246,41322,41337,41418,41436,41499,41570,41576,41649,41724,41797,41800,41839,41865,41871,41879,41896,41927,41956,41957,42040,42054,42057,42065,42091,42134,42154,42163,42174,42188,42212,42304,42405,42448,42490,42538,42572,42703,42729,42765,42800,42806,42863,43009,43115,43136,43143,43222,43234,43244,43294,43345,43459,43508,43509,43539,43550,43565,43596,43601,43605,43615,43682,43846,43979,44026,44177,44184,44237,44351,44400,44431,44491,44544,44588,44611,44613,44701,44894,44908,44941,45051,45136,45157,45302,45303)
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 | 1854 | 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.79 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.32 ms |
System lock | 0.02 ms |
optimizing | 0.12 ms |
statistics | 2.77 ms |
preparing | 1.38 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 16.33 ms |
end | 0.04 ms |
query end | 0.04 ms |
closing tables | 0.02 ms |
freeing items | 0.43 ms |
cleaning up | 0.04 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 |