Tiempo de la consulta: 14.42 ms Después de la última consulta: 1.14 ms Consulta a la memoria: 1.487 MB memoria antes de la consulta: 4.362 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 00:59:20')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 00:59:20')
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,62,78,85,148,150,155,163,174,197,214,260,263,279,285,287,303,349,357,394,430,450,490,495,530,531,563,572,666,667,708,710,711,712,713,723,770,783,808,863,869,885,954,1018,1080,1101,1102,1182,1216,1233,1278,1279,1289,1296,1346,1348,1503,1533,1555,1648,1714,1718,1751,1804,1835,1846,1850,1867,1919,2188,2258,2305,2328,2392,2402,2647,2857,2954,3055,3106,3107,3109,3174,3180,3220,3280,3319,3364,3369,3371,3402,3409,3412,3451,3454,3480,3571,3575,3577,3663,3806,4004,4100,4131,4166,4225,4250,4315,4319,4339,4473,4476,4493,4503,4540,4589,4612,4613,4614,4615,4617,4699,4713,4767,4823,4973,4982,5161,5199,5247,5396,5439,5461,5478,5530,5536,5608,5785,5791,5814,5855,5857,5881,5913,5973,5996,6062,6120,6159,6178,6372,6427,6465,6468,6470,6472,6492,6600,6616,6639,6673,6684,6744,6776,6876,7013,7014,7101,7122,7215,7218,7231,7232,7234,7243,7246,7249,7264,7272,7285,7289,7319,7328,7330,7333,7334,7344,7346,7364,7367,7368,7370,7371,7374,7377,7379,7380,7396,7406,7407,7408,7410,7412,7413,7414,7415,7416,7417,7422,7430,7431,7435,7436,7439,7447,7450,7455,7456,7457,7458,7463,7464,7465,7478,7486,7489,7545,7546,7552,7553,7555,7565,7570,7577,7583,7615,7625,7659,7678,7682,7683,7691,7715,7720,7722,7735,7736,7744,7746,7749,7757,7768,7799,7818,7830,7833,7834,7835,7841,7851,7863,7871,7891,7894,7895,7897,7900,7901,7919,7923,7924,7955,7957,7960,7961,7962,7979,7982,8020,8022,8023,8024,8046,8049,8061,8067,8072,8090,8116,8118,8158,8220,8250,8385,8679,8692,8698,8704,8796,8864,9029,9036,9059,9087,9218,9253,9303,9344,9364,9418,9434,9554,9568,9658,9688,9773,9836,9847,9907,9924,9996,10008,10068,10073,10186,10197,10199,10205,10243,10307,10322,10349,10387,10400,10403,10475,10478,10522,10530,10563,10630,10694,10783,10801,10958,11059,11071,11258,11267,11402,11404,11446,11458,11472,11563,11864,11865,12022,12218,12226,12331,12401,12410,12435,12463,12474,12488,12527,12564,12609,12617,12620,12622,12625,12637,12649,12686,12708,12748,12853,12875,12944,12966,12978,13017,13154,13293,13294,13298,13325,13327,13375,13497,13635,13667,13671,13676,13685,13687,13697,13707,13723,13742,13842,13877,13963,13975,13990,14050,14052,14074,14082,14092,14105,14117,14142,14167,14244,14250,14262,14267,14271,14273,14362,14366,14421,14431,14440,14456,14474,14505,14507,14513,14514,14596,14646,14657,14680,14683,14713,14770,14794,14849,14865,14923,14946,14964,14973,14974,14983,14987,15004,15015,15030,15031,15032,15037,15039,15046,15048,15052,15094,15104,15108,15111,15129,15139,15167,15206,15213,15247,15293,15301,15318,15370,15382,15403,15411,15424,15439,15451,15492,15510,15523,15533,15542,15548,15562,15575,15594,15673,15689,15712,15717,15725,15728,15747,15757,15782,15797,15808,15835,15863,15866,15874,15902,15916,15935,16000,16005,16055,16092,16093,16103,16140,16153,16161,16172,16206,16240,16257,16326,16374,16410,16440,16458,16497,16520,16534,16543,16584,16625,16652,16657,16664,16832,16877,16889,16907,16929,16936,16981,17000,17033,17080,17125,17128,17184,17215,17257,17273,17291,17323,17335,17339,17344,17347,17358,17360,17382,17401,17432,17435,17472,17476,17541,17590,17596,17607,17631,17634,17659,17702,17733,17757,17766,17818,17824,17831,17840,17854,17870,17883,17895,17941,17961,17980,17999,18031,18034,18150,18220,18309,18316,18326,18353,18369,18384,18403,18419,18442,18464,18482,18498,18539,18543,18555,18558,18561,18576,18577,18612,18682,18689,18712,18730,18735,18739,18847,18848,18869,18880,18901,18905,18910,18920,18942,18977,18982,18991,18995,19000,19022,19054,19083,19086,19091,19101,19105,19108,19110,19132,19136,19139,19149,19170,19171,19185,19188,19207,19240,19243,19247,19270,19274,19294,19304,19366,19386,19396,19426,19442,19453,19472,19484,19524,19535,19542,19567,19595,19604,19608,19650,19651,19652,19661,19681,19684,19700,19718,19720,19730,19739,19772,19815,19867,19894,19930,19932,19941,19967,19983,19991,20007,20023,20034,20036,20054,20066,20069,20076,20097,20099,20100,20103,20145,20162,20173,20183,20191,20199,20216,20289,20303,20344,20354,20363,20374,20385,20403,20440,20446,20464,20472,20510,20536,20578,20579,20592,20636,20638,20649,20659,20710,20768,20824,20826,20848,20856,20858,20885,20950,21000,21118,21161,21178,21181,21227,21228,21242,21252,21259,21300,21305,21323,21388,21431,21433,21452,21458,21464,21516,21518,21522,21536,21546,21586,21602,21624,21676,21709,21711,21714,21737,21751,21819,21843,21906,21912,21952,21988,22059,22099,22100,22116,22244,22245,22246,22258,22262,22289,22290,22315,22385,22419,22435,22455,22477,22483,22492,22500,22502,22527,22552,22563,22572,22602,22607,22612,22673,22693,22708,22715,22742,22744,22786,22803,22805,22829,22874,22878,22886,22895,22914,22924,22959,22963,23000,23019,23022,23034,23042,23081,23107,23122,23123,23124,23148,23207,23214,23219,23229,23247,23256,23286,23300,23344,23364,23375,23408,23467,23546,23559,23564,23565,23594,23691,23703,23725,23729,23732,23759,23763,23772,23791,23814,23828,23839,23845,23848,23849,23857,23874,23885,23889,23900,23922,23930,23941,23949,23955,23959,23962,23967,23984,24010,24014,24024,24062,24072,24075,24076,24111,24117,24141,24174,24176,24202,24211,24223,24230,24260,24264,24282,24311,24346,24466,24472,24513,24523,24526,24595,24607,24616,24618,24624,24673,24680,24686,24736,24738,24745,24785,24788,24823,24834,24843,24857,24868,24888,24907,24915,24924,24943,24960,24964,24968,24979,24989,25003,25022,25048,25067,25070,25071,25082,25100,25115,25126,25178,25245,25273,25294,25340,25349,25360,25373,25374,25415,25421,25538,25555,25624,25648,25673,25678,25764,25798,25818,25833,25917,25925,25941,25955,25987,26000,26022,26105,26107,26122,26135,26162,26176,26205,26306,26359,26386,26390,26409,26454,26522,26540,26564,26579,26609,26646,26665,26772,26779,26808,26816,26820,26845,26898,26910,26926,26939,26968,26982,26996,27024,27026,27101,27126,27131,27151,27174,27186,27221,27251,27293,27294,27295,27347,27356,27452,27490,27492,27497,27506,27512,27520,27545,27558,27572,27593,27604,27605,27738,27749,27777,27789,28005,28397,28424,28441,28452,28468,28605,28720,28773,28780,28824,28825,28845,28846,29021,29089,29124,29143,29256,29358,29369,29372,29378,29617,29810,29890,29919,29930,30194,30988,31227,31499,31516,31798,31853,33416,33815,35144,35639,35640,35643,35744,35752,35882,36075,36208,36581,36584,36822,36893,36916,36918,37315,37380,37759,37874,37905,37996,38056,38066,38361,38362,38455,38734,38775,38812,38834,38912,38960,39224,39240,39269,39307,39358,39452,39504,39516,39600,39966,40169,40213,40312,40313,40314,40360,40542,40801,40938,41036,41063,41148,41171,41402,41423,41811,41885,42460,42489,42796,43118,43680,43705,43706,43707,43914,43915,43917,44031,44041,44497,44618,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 | 1159 | 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.22 ms |
System lock | 0.02 ms |
optimizing | 0.08 ms |
statistics | 1.69 ms |
preparing | 0.85 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 9.67 ms |
end | 0.03 ms |
query end | 0.17 ms |
closing tables | 0.03 ms |
freeing items | 0.26 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 |