Tiempo de la consulta: 21.25 ms Después de la última consulta: 2.19 ms Consulta a la memoria: 3.221 MB memoria antes de la consulta: 4.430 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 13:49:37')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 13:49:37')
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(35,64,132,155,157,193,218,257,275,311,323,354,401,448,466,471,482,495,499,543,560,565,610,635,643,661,668,679,680,685,692,700,703,709,713,736,749,761,769,772,780,783,786,808,831,859,868,870,883,885,960,968,984,998,1024,1026,1027,1032,1034,1042,1048,1050,1061,1066,1079,1088,1098,1106,1127,1134,1138,1142,1149,1150,1151,1172,1183,1192,1193,1194,1196,1198,1226,1239,1255,1269,1271,1279,1280,1295,1305,1312,1322,1349,1375,1420,1421,1425,1433,1435,1441,1444,1445,1447,1454,1455,1460,1466,1476,1481,1482,1484,1492,1503,1534,1553,1586,1595,1624,1664,1666,1713,1811,1812,1841,1852,1855,1870,1882,1903,1906,1944,1982,1984,1985,2001,2010,2077,2109,2146,2148,2177,2193,2199,2224,2301,2359,2367,2372,2391,2408,2415,2432,2469,2477,2480,2555,2568,2629,2631,2691,2705,2724,2756,2773,2797,2859,2933,2934,2967,2984,2989,2993,3000,3018,3056,3065,3108,3119,3125,3139,3141,3202,3236,3264,3278,3288,3355,3361,3364,3373,3511,3513,3590,3594,3663,3825,3832,3836,3856,3871,3872,3938,3975,3992,4006,4075,4132,4133,4168,4176,4197,4252,4253,4271,4339,4358,4477,4503,4523,4524,4525,4539,4558,4580,4585,4586,4587,4605,4665,4670,4758,4795,4817,4822,4868,4872,4874,4892,4910,4919,4960,5014,5035,5059,5076,5079,5143,5157,5166,5226,5250,5435,5457,5496,5507,5508,5534,5570,5615,5642,5659,5662,5700,5798,5876,5936,5940,5990,6007,6037,6064,6068,6122,6133,6200,6202,6217,6256,6294,6308,6323,6327,6328,6331,6396,6421,6461,6470,6473,6512,6516,6520,6523,6524,6533,6553,6571,6577,6596,6648,6663,6667,6707,6728,6778,6780,6842,6845,6925,6932,7081,7094,7182,7200,7237,7277,7283,7320,7342,7358,7371,7421,7429,7435,7528,7537,7553,7611,7626,7674,7688,7709,7744,7748,7765,7769,7802,7824,7830,7834,7839,7845,7848,7860,7868,7870,7878,7931,7946,7951,8069,8091,8099,8108,8206,8222,8230,8283,8297,8341,8361,8400,8416,8480,8518,8532,8603,8613,8627,8695,8706,8778,8819,8826,8907,8938,8944,9108,9122,9132,9191,9284,9339,9432,9449,9462,9548,9552,9562,9626,9629,9675,9690,9717,9766,9879,9894,9926,10049,10263,10316,10318,10371,10373,10381,10479,10501,10515,10616,10668,10725,10736,10775,10834,10851,11195,11223,11308,11314,11410,11428,11625,11705,11715,11795,11842,11859,11885,11950,12089,12170,12238,12334,12388,12437,12439,12440,12491,12524,12580,12599,12686,12803,12822,12842,12946,12980,12994,13006,13018,13061,13078,13118,13154,13160,13161,13190,13219,13258,13266,13269,13272,13276,13297,13316,13344,13349,13428,13436,13437,13438,13458,13467,13478,13479,13480,13481,13482,13488,13501,13502,13503,13525,13553,13589,13597,13612,13645,13646,13660,13672,13689,13698,13782,13784,13786,13794,13797,13824,13882,13890,13926,13968,14057,14100,14112,14139,14140,14142,14153,14177,14186,14205,14309,14324,14383,14429,14432,14487,14493,14506,14529,14546,14599,14601,14641,14646,14657,14665,14684,14710,14721,14761,14816,14837,14864,14874,14890,14905,14958,14981,14983,15015,15059,15063,15079,15092,15111,15112,15138,15147,15216,15229,15245,15359,15372,15420,15464,15530,15543,15551,15561,15568,15577,15598,15632,15644,15645,15669,15672,15681,15722,15742,15759,15760,15885,15935,15982,16052,16108,16206,16208,16216,16258,16282,16348,16386,16465,16466,16529,16569,16571,16586,16591,16607,16627,16629,16634,16658,16774,16780,16791,16821,16843,16880,16921,16942,16987,17098,17116,17121,17126,17131,17138,17177,17188,17224,17263,17272,17282,17288,17303,17343,17355,17366,17383,17384,17478,17517,17555,17632,17645,17658,17660,17667,17699,17762,17780,17799,17812,17877,17892,17907,17908,17921,17927,18006,18007,18013,18037,18039,18055,18085,18091,18160,18174,18180,18181,18202,18284,18290,18302,18309,18355,18382,18395,18450,18454,18463,18466,18499,18516,18540,18550,18652,18666,18712,18726,18739,18758,18770,18813,18880,18901,18912,18916,18927,18934,18944,18982,19003,19010,19043,19078,19110,19135,19196,19231,19264,19265,19291,19303,19307,19331,19334,19335,19343,19348,19364,19375,19383,19407,19412,19415,19445,19448,19488,19505,19506,19507,19541,19572,19596,19612,19623,19640,19660,19667,19704,19712,19771,19773,19786,19790,19797,19806,19816,19832,19853,19917,19921,19933,19979,19987,19994,20004,20043,20051,20056,20065,20073,20088,20098,20131,20142,20143,20181,20202,20208,20242,20258,20265,20312,20313,20314,20329,20404,20413,20452,20458,20515,20568,20569,20571,20594,20602,20673,20692,20739,20773,20803,20829,20834,20835,20871,20874,20914,20933,20976,20977,21008,21015,21065,21073,21078,21092,21180,21189,21197,21205,21266,21275,21280,21284,21321,21353,21388,21392,21408,21411,21437,21438,21440,21447,21469,21471,21491,21501,21520,21524,21527,21571,21601,21611,21613,21620,21629,21633,21681,21691,21693,21779,21821,21879,21957,21987,22011,22118,22129,22159,22173,22207,22223,22268,22282,22293,22365,22367,22400,22415,22416,22431,22442,22462,22464,22491,22532,22596,22600,22616,22645,22653,22700,22706,22710,22722,22747,22748,22754,22756,22788,22830,22848,22863,22864,22872,22879,22890,22977,23029,23031,23032,23039,23040,23082,23101,23104,23114,23123,23210,23221,23277,23284,23296,23313,23318,23344,23356,23365,23394,23404,23406,23409,23453,23490,23495,23539,23547,23592,23593,23622,23634,23638,23639,23691,23692,23695,23701,23704,23715,23722,23725,23739,23747,23757,23769,23772,23832,23860,23868,23880,23905,23954,23970,24017,24052,24115,24167,24170,24180,24187,24198,24202,24215,24236,24247,24263,24290,24361,24441,24447,24455,24460,24465,24524,24555,24599,24659,24674,24726,24775,24780,24784,24815,24819,24829,24838,24843,24868,24875,24884,24889,24957,24966,24977,24979,25010,25022,25029,25039,25062,25096,25099,25116,25141,25172,25181,25197,25199,25217,25230,25278,25280,25284,25292,25317,25326,25406,25529,25530,25542,25604,25606,25609,25621,25655,25683,25693,25700,25705,25717,25718,25732,25740,25746,25755,25770,25792,25801,25853,25881,25911,25933,25943,25964,26039,26050,26053,26054,26056,26060,26063,26092,26104,26109,26117,26154,26166,26167,26171,26221,26348,26353,26374,26395,26408,26409,26467,26468,26516,26530,26575,26601,26629,26664,26684,26715,26716,26722,26731,26753,26760,26797,26801,26807,26830,26848,26852,26897,26909,26935,26944,26945,26950,26951,26955,26977,27003,27009,27035,27046,27054,27074,27105,27129,27136,27161,27167,27230,27237,27259,27272,27274,27280,27283,27303,27311,27315,27350,27383,27392,27414,27415,27466,27491,27516,27541,27558,27559,27571,27577,27610,27634,27638,27647,27655,27671,27688,27742,27772,27779,27859,27870,27932,27955,28073,28127,28189,28233,28280,28306,28324,28407,28532,28542,28546,28551,28569,28571,28598,28618,28628,28654,28716,28746,29130,29154,29213,29326,29373,29379,29436,29548,29610,29787,29864,30133,30356,30529,30562,31384,32061,32530,32919,32964,33080,33345,33854,34174,34502,34511,34629,34647,34676,34963,35102,35103,35226,35299,35337,35360,35379,35434,35530,35596,35684,35710,35732,35780,35971,36003,36060,36085,36092,36200,36279,36297,36333,36416,36420,36424,36427,36428,36441,36452,36469,36490,36551,36565,36616,36625,36629,36638,36654,36656,36695,36751,36761,36772,36802,36817,36853,36855,36859,36891,36894,36900,36934,36961,37005,37034,37086,37107,37116,37155,37170,37192,37232,37283,37286,37308,37331,37346,37347,37348,37349,37350,37351,37359,37361,37371,37383,37391,37397,37399,37403,37439,37443,37454,37470,37495,37501,37505,37507,37520,37557,37558,37560,37573,37578,37618,37635,37645,37652,37692,37755,37780,37799,37820,37831,37833,37858,37890,37894,37916,37959,38006,38007,38011,38015,38016,38023,38031,38058,38083,38103,38107,38113,38114,38122,38128,38157,38160,38177,38185,38192,38222,38226,38236,38274,38288,38311,38315,38343,38350,38356,38366,38382,38398,38401,38403,38432,38440,38443,38446,38452,38456,38530,38549,38568,38622,38634,38674,38689,38718,38765,38786,38814,38843,38978,38995,39027,39052,39150,39155,39163,39191,39193,39194,39214,39217,39245,39264,39276,39295,39296,39315,39319,39330,39332,39334,39338,39339,39347,39375,39379,39389,39424,39429,39442,39474,39475,39490,39492,39522,39550,39569,39596,39609,39624,39649,39706,39722,39725,39747,39758,39761,39768,39802,39803,39855,39871,39873,39892,40004,40018,40054,40073,40089,40095,40166,40226,40231,40271,40276,40333,40379,40398,40436,40438,40445,40446,40460,40461,40465,40495,40496,40515,40534,40535,40554,40555,40562,40593,40614,40629,40656,40667,40674,40688,40742,40746,40774,40811,40817,40959,41007,41040,41068,41150,41220,41246,41322,41339,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,42486,42490,42538,42540,42572,42703,42729,42765,42800,42806,42863,43009,43115,43136,43143,43222,43234,43244,43294,43345,43358,43459,43508,43509,43539,43550,43565,43596,43601,43605,43615,43682,43846,43979,44026,44177,44184,44317,44351,44400,44431,44491,44544,44588,44611,44613,44701,44894,44908,44941,45051,45136,45157,45231,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 | 1532 | 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.75 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.29 ms |
System lock | 0.02 ms |
optimizing | 0.10 ms |
statistics | 2.25 ms |
preparing | 1.24 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 15.46 ms |
end | 0.03 ms |
query end | 0.10 ms |
closing tables | 0.03 ms |
freeing items | 0.19 ms |
cleaning up | 0.05 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 |