Tiempo de la consulta: 4.22 ms Después de la última consulta: 0.81 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.327 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-09 03:00:38')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 03:00:38')
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,21,132,197,260,263,287,307,394,563,770,1284,1296,1337,1348,1503,1538,1714,1718,1804,2103,2122,2258,2261,2305,2325,2426,2482,2563,2625,2776,2827,2857,2898,2916,2924,3038,3150,3198,3223,3248,3276,3285,3319,3341,3384,3462,3503,3522,3543,3575,3577,3646,3667,3672,3706,3912,3997,4030,4078,4090,4100,4114,4120,4131,4168,4209,4222,4236,4239,4257,4297,4315,4325,4339,4346,4347,4417,4468,4473,4493,4499,4573,4612,4613,4614,4615,4617,4643,4760,4778,4780,4789,4894,4915,4940,4982,5034,5115,5152,5187,5199,5210,5211,5229,5274,5286,5304,5350,5386,5407,5433,5442,5461,5530,5536,5652,5814,5816,5842,5851,5854,5855,5857,5973,5977,5979,5996,6032,6056,6062,6159,6164,6247,6274,6277,6337,6340,6361,6372,6419,6427,6465,6468,6470,6486,6492,6567,6589,6616,6619,6629,6647,6711,6715,6736,6744,6776,6849,6906,6969,7031,7045,7142,7143,7165,7166,7187,7215,7217,7231,7232,7234,7243,7246,7249,7282,7285,7289,7311,7319,7328,7330,7333,7334,7344,7346,7359,7364,7367,7368,7370,7371,7374,7377,7379,7380,7391,7396,7406,7407,7408,7410,7413,7414,7415,7416,7417,7422,7430,7431,7435,7436,7447,7450,7451,7455,7456,7457,7458,7463,7464,7465,7486,7489,7490,7509,7539,7545,7546,7552,7553,7555,7561,7565,7570,7574,7577,7583,7603,7604,7615,7625,7659,7678,7682,7683,7691,7698,7715,7720,7735,7736,7737,7744,7746,7749,7757,7765,7768,7787,7799,7818,7825,7827,7830,7833,7834,7835,7848,7851,7852,7863,7871,7877,7891,7894,7895,7900,7901,7919,7955,7957,7961,7962,7973,7979,7982,8010,8014,8020,8022,8023,8024,8036,8041,8049,8065,8067,8072,8096,8123,8126,8153,8163,8171,8177,8207,8219,8259,8263,8264,8273,8281,8311,8318,8379,8400,8407,8422,8455,8469,8509,8519,8520,8523,8563,8576,8623,8625,8698,8727,8730,8736,8756,8785,8789,8857,8862,8867,8919,8934,8949,8971,8980,9005,9020,9050,9059,9080,9128,9138,9159,9165,9212,9214,9218,9249,9253,9303,9310,9311,9344,9347,9365,9384,9435,9445,9448,9457,9467,9503,9538,9549,9555,9568,9585,9594,9609,9615,9616,9624,9635,9658,9676,9690,9702,9774,9827,9829,9854,9892,9893,9907,9959,9988,9996,10060,10108,10116,10117,10149,10154,10170,10186,10187,10196,10197,10199,10205,10208,10243,10268,10277,10278,10286,10294,10304,10342,10349,10363,10373,10387,10400,10401,10411,10435,10498,10512,10522,10532,10554,10567,10661,10676,10713,10754,10846,10903,10920,10983,11065,11071,11073,11091,11121,11148,11149,11167,11262,11289,11335,11344,11399,11404,11458,11503,11607,11684,11749,11757,11821,11864,11872,11875,11886,11887,11903,11974,11978,11983,12019,12035,12174,12193,12226,12285,12290,12310,12355,12435,12488,12527,12609,12617,12631,12649,12651,12695,12743,12812,12823,12844,12856,12884,12944,12978,12997,13089,13090,13154,13207,13262,13284,13325,13327,13375,13376,13384,13504,13506,13659,13667,13685,13728,13733,13740,13808,13844,13879,13886,13909,13910,13926,13948,13949,14052,14123,14128,14250,14260,14270,14297,14316,14330,14346,14366,14381,14383,14421,14431,14505,14525,14596,14598,14613,14663,14680,14713,14732,14740,14770,14782,14810,14824,14828,14849,14865,14946,14947,14958,14962,14973,14974,15015,15039,15046,15103,15149,15193,15240,15260,15281,15289,15293,15318,15330,15432,15433,15447,15501,15533,15534,15560,15565,15594,15628,15635,15673,15689,15699,15721,15723,15738,15748,15765,15768,15775,15776,15793,15797,15799,15808,15835,15836,15851,15855,15872,15874,15879,15889,15902,15912,15916,15932,15958,15997,16011,16038,16055,16071,16084,16100,16103,16119,16128,16172,16176,16193,16195,16217,16240,16251,16258,16310,16314,16315,16368,16378,16410,16427,16440,16466,16509,16520,16575,16584,16608,16615,16651,16705,16729,16746,16771,16827,16855,16872,16875,16881,16888,16907,16949,16954,16960,16985,16988,16993,17014,17024,17025,17080,17109,17112,17120,17121,17148,17152,17184,17200,17222,17260,17291,17297,17298,17318,17335,17344,17418,17475,17476,17491,17545,17548,17550,17583,17590,17601,17605,17607,17625,17627,17668,17693,17704,17751,17755,17824,17837,17883,17941,17999,18024,18061,18150,18157,18190,18220,18271,18330,18353,18442,18482,18510,18529,18531,18538,18558,18576,18609,18646,18694,18712,18715,18718,18730,18735,18768,18905,18923,18929,19020,19064,19101,19139,19143,19243,19306,19426,19472,19484,19542,19642,19651,19719,19733,19772,19784,19787,19839,19860,19918,19930,19934,19955,19967,20000,20066,20166,20191,20289,20301,20385,20504,20556,20592,20676,20717,20753,20805,20885,20960,21063,21166,21209,21259,21294,21297,21300,21420,21475,21522,21602,21624,21627,21739,21831,21843,21858,21878,21952,22116,22129,22238,22262,22289,22290,22347,22348,22424,22505,22563,22571,22602,22642,22659,22689,22693,22711,22715,22770,22775,22883,22886,22894,22914,22959,23094,23107,23123,23188,23214,23229,23308,23362,23364,23418,23456,23612,23678,23725,23729,23742,23783,23819,23849,23856,23860,23885,23949,24062,24068,24127,24211,24223,24407,24425,24526,24595,24684,24723,24736,24738,24760,24785,24834,24860,24863,24915,25125,25174,25178,25294,25327,25352,25538,25555,25567,25580,25586,25592,25648,25696,25799,25916,25938,25941,25947,26000,26173,26359,26376,26386,26409,26490,26579,26604,26606,26609,26631,26646,26658,26682,26703,26765,26812,26818,26820,26832,26845,26952,26955,26958,26960,26968,27025,27033,27056,27126,27169,27181,27187,27190,27195,27218,27239,27298,27311,27347,27376,27445,27478,27492,27504,27507,27512,27604,27605,27651,27660,27749,27789,28103,28183,28184,28297,28360,28441,28468,28747,28781,28846,28954,29213,29655,29697,30194,30988,31798,31853,32171,33416,33644,33930,34200,34239,34249,35639,35640,35643,35744,35752,36075,36208,36581,36584,37759,38362,38912,39224,39240,39600,40736,41148,41171)
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 | 984 | 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.52 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.07 ms |
statistics | 1.50 ms |
preparing | 0.73 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.36 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 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 |