Tiempo de la consulta: 14.68 ms Después de la última consulta: 1.07 ms Consulta a la memoria: 1.487 MB memoria antes de la consulta: 4.357 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 16:12:39')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 16:12:39')
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,62,78,83,150,161,162,163,164,174,204,255,310,325,345,346,349,350,352,353,357,458,485,512,529,530,531,537,542,547,560,566,567,570,607,660,686,708,709,710,711,712,713,756,760,783,806,830,850,881,886,911,933,977,986,999,1104,1182,1207,1226,1249,1265,1277,1289,1294,1346,1347,1376,1538,1555,1600,1664,1698,1751,1768,1919,2188,2392,2465,2733,2757,2795,3038,3055,3059,3081,3086,3109,3180,3207,3280,3364,3379,3409,3451,3464,3520,3571,3632,3794,3884,3898,3940,3993,4004,4007,4063,4116,4144,4153,4166,4263,4309,4319,4370,4409,4410,4436,4445,4453,4471,4476,4503,4692,4699,4713,4767,5001,5085,5161,5218,5229,5247,5369,5439,5515,5608,5647,5819,5854,5865,5881,5894,5931,6081,6119,6173,6448,6472,6527,6598,6681,6684,6752,6775,6806,6809,6827,6828,6912,6916,6939,6941,6994,7010,7013,7014,7064,7105,7122,7173,7212,7243,7246,7272,7276,7407,7415,7418,7439,7462,7516,7601,7730,7822,7840,7923,7965,8001,8027,8053,8061,8106,8116,8158,8220,8250,8351,8445,8610,8659,8663,8704,8778,8796,8808,8809,8864,8970,9050,9066,9204,9253,9310,9311,9350,9367,9434,9473,9529,9531,9532,9554,9580,9688,9743,9772,9773,9785,9827,9828,9893,9924,10004,10024,10043,10050,10073,10077,10079,10197,10198,10241,10260,10266,10286,10290,10291,10303,10307,10322,10329,10350,10486,10499,10518,10557,10563,10577,10582,10630,10690,10694,10731,10783,10806,10831,10874,10958,11010,11059,11087,11119,11126,11182,11203,11209,11258,11267,11273,11402,11446,11447,11494,11542,11563,11594,11636,11692,11728,11761,11840,11865,11880,11891,11898,11906,12097,12216,12218,12331,12338,12363,12366,12401,12463,12471,12474,12490,12508,12578,12600,12622,12625,12644,12685,12686,12745,12748,12757,12759,12779,12810,12840,12853,12875,12920,12965,12977,12983,13138,13235,13287,13441,13457,13497,13512,13562,13605,13651,13676,13697,13723,13742,13760,13827,13963,13985,13990,14011,14069,14074,14077,14082,14109,14117,14139,14142,14167,14205,14208,14227,14232,14244,14252,14262,14267,14273,14316,14440,14456,14488,14507,14513,14528,14557,14591,14596,14610,14655,14657,14683,14701,14774,14778,14794,14895,14923,14926,14964,14979,14983,15000,15032,15048,15055,15062,15065,15094,15104,15108,15111,15114,15129,15139,15144,15161,15167,15194,15204,15206,15213,15256,15297,15301,15304,15330,15370,15391,15411,15441,15445,15455,15471,15548,15575,15576,15606,15640,15691,15712,15725,15728,15757,15760,15766,15782,15858,15866,15877,15892,15905,15933,15935,16000,16014,16053,16054,16092,16093,16125,16153,16187,16208,16277,16326,16359,16374,16410,16458,16462,16467,16470,16513,16534,16554,16558,16607,16620,16625,16635,16642,16664,16691,16698,16815,16824,16831,16832,16843,16889,16964,16981,17001,17043,17059,17125,17128,17130,17149,17189,17192,17215,17257,17273,17280,17282,17323,17341,17354,17364,17381,17382,17401,17403,17417,17432,17435,17463,17472,17500,17541,17596,17597,17600,17617,17630,17634,17650,17689,17729,17733,17753,17757,17772,17784,17818,17835,17840,17854,17875,17880,17895,17907,17954,17980,17990,18001,18031,18034,18108,18158,18176,18217,18263,18337,18352,18361,18369,18427,18432,18455,18485,18520,18527,18547,18561,18565,18576,18577,18581,18583,18586,18591,18612,18648,18670,18682,18689,18716,18808,18809,18817,18869,18870,18898,18910,18920,18942,18957,18977,18982,18986,18991,18995,18997,19000,19022,19037,19056,19060,19063,19071,19075,19083,19091,19105,19108,19110,19120,19132,19134,19136,19139,19149,19189,19217,19240,19247,19251,19270,19294,19303,19313,19331,19356,19377,19383,19413,19419,19433,19437,19440,19453,19484,19494,19504,19522,19524,19535,19538,19539,19552,19556,19566,19593,19595,19604,19608,19625,19626,19650,19651,19661,19681,19684,19718,19720,19730,19739,19763,19766,19779,19792,19815,19864,19894,19930,19932,19941,19955,19959,19983,19987,19991,19999,20007,20034,20042,20069,20076,20083,20097,20127,20145,20146,20167,20183,20199,20229,20236,20279,20303,20332,20344,20352,20354,20362,20363,20374,20403,20422,20427,20440,20446,20479,20536,20543,20574,20578,20605,20636,20638,20659,20678,20686,20691,20724,20753,20765,20769,20774,20776,20795,20799,20817,20826,20831,20835,20840,20842,20848,20856,20915,20950,20956,21000,21017,21105,21118,21152,21161,21165,21178,21184,21228,21242,21252,21293,21305,21315,21323,21366,21415,21431,21432,21433,21452,21458,21464,21465,21518,21522,21546,21557,21575,21579,21586,21590,21606,21662,21667,21676,21709,21711,21714,21737,21751,21766,21775,21819,21849,21855,21858,21880,21901,21926,21952,21988,22059,22089,22100,22126,22167,22171,22196,22215,22218,22225,22248,22258,22268,22350,22363,22366,22378,22382,22385,22392,22395,22397,22419,22431,22435,22455,22483,22492,22500,22502,22523,22527,22530,22533,22539,22552,22559,22562,22563,22572,22582,22607,22612,22666,22673,22703,22708,22715,22740,22742,22750,22753,22766,22788,22793,22803,22874,22875,22902,22906,22921,22933,22934,22935,22976,23000,23002,23006,23017,23022,23033,23034,23050,23080,23103,23122,23126,23148,23149,23151,23219,23247,23271,23286,23310,23343,23344,23354,23375,23380,23396,23417,23445,23466,23467,23477,23495,23512,23546,23559,23564,23597,23651,23659,23665,23666,23677,23691,23693,23703,23705,23719,23740,23757,23761,23768,23772,23782,23792,23806,23814,23816,23827,23845,23857,23869,23880,23889,23914,23941,23959,23962,23965,23967,23984,23998,24001,24010,24014,24024,24059,24072,24075,24076,24103,24111,24117,24122,24171,24212,24230,24260,24261,24268,24299,24306,24311,24346,24373,24375,24470,24472,24487,24513,24523,24543,24607,24608,24616,24649,24659,24672,24673,24676,24686,24689,24713,24718,24745,24754,24759,24780,24788,24790,24823,24832,24851,24857,24905,24907,24924,24927,24935,24937,24942,24960,24995,25003,25067,25070,25071,25090,25104,25105,25115,25119,25126,25141,25143,25199,25207,25252,25260,25267,25273,25345,25349,25353,25360,25366,25373,25374,25382,25421,25435,25486,25502,25585,25595,25615,25616,25650,25653,25678,25764,25778,25798,25886,25917,25925,25987,26103,26105,26107,26122,26135,26162,26176,26229,26237,26238,26259,26293,26306,26324,26338,26389,26426,26431,26437,26479,26513,26522,26524,26540,26564,26589,26605,26654,26665,26712,26776,26792,26816,26818,26857,26926,26939,26982,27008,27015,27020,27024,27026,27038,27055,27076,27093,27149,27151,27153,27221,27248,27251,27356,27420,27438,27452,27453,27477,27506,27545,27558,27566,27572,27593,27720,27776,27777,27822,27991,28005,28316,28319,28397,28424,28605,28720,28780,28824,28910,28922,29021,29023,29087,29089,29123,29124,29142,29143,29144,29249,29256,29358,29369,29466,29499,29584,29617,29810,29834,29890,29909,29919,29928,29930,30111,31227,31499,31516,32136,33815,33932,35730,35741,35803,35885,35921,35989,36017,36041,36104,36235,36306,36406,36418,36633,36822,36893,36916,36918,36958,37315,37380,37874,37996,38056,38066,38361,38455,38506,38734,38775,38800,38812,38852,38916,38960,38985,39178,39307,39318,39358,39369,39452,39504,39516,39653,39858,39941,39966,39998,40050,40064,40167,40169,40214,40312,40313,40314,40360,40369,40471,40542,40706,40798,40801,40838,41036,41063,41257,41337,41402,41423,41811,41885,42460,42489,43680,43705,43706,43707,43914,43915,43917,44031,44041,44497,44681,45115,45160,45206,45252)
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 | 1223 | 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.23 ms |
System lock | 0.02 ms |
optimizing | 0.09 ms |
statistics | 1.84 ms |
preparing | 1.00 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 10.27 ms |
end | 0.01 ms |
query end | 0.03 ms |
closing tables | 0.02 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 |