Tiempo de la consulta: 4.90 ms Después de la última consulta: 1.04 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.364 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-08 21:52:07')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-08 21:52:07')
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(2,3,5,6,7,8,9,10,11,12,13,14,15,16,17,18,21,22,25,28,29,49,56,72,86,165,197,225,255,260,263,271,275,276,287,298,303,344,394,414,463,472,549,563,581,583,607,611,613,667,686,705,723,724,757,758,770,801,816,868,883,895,900,916,917,958,963,1015,1031,1046,1053,1056,1080,1124,1140,1207,1235,1238,1271,1296,1304,1308,1316,1348,1474,1477,1503,1504,1538,1696,1714,1718,1804,1823,2258,2272,2290,2293,2305,2365,2531,2566,2639,2796,2863,2866,3016,3038,3168,3208,3319,3353,3442,3447,3512,3522,3531,3575,3604,3634,3732,3812,3862,3976,3986,4100,4131,4231,4287,4310,4339,4473,4493,4515,4549,4580,4612,4613,4614,4615,4617,4767,4813,4878,4902,4920,4973,4982,5018,5019,5150,5199,5224,5247,5350,5365,5386,5451,5461,5530,5559,5647,5675,5686,5730,5814,5855,5857,5894,5973,5996,6062,6068,6119,6127,6141,6159,6311,6330,6372,6405,6427,6465,6468,6470,6471,6473,6475,6476,6477,6485,6492,6520,6542,6543,6573,6616,6630,6639,6656,6657,6688,6723,6742,6744,6776,6804,6835,6842,6860,6889,6895,6906,6918,6936,6945,6985,7015,7099,7155,7215,7218,7231,7232,7234,7243,7246,7249,7285,7289,7319,7328,7330,7333,7334,7343,7344,7346,7364,7367,7368,7370,7371,7374,7377,7379,7380,7389,7396,7406,7407,7408,7410,7413,7414,7415,7416,7417,7422,7430,7431,7435,7436,7447,7450,7455,7456,7457,7458,7463,7464,7465,7483,7484,7486,7489,7492,7516,7517,7545,7546,7552,7553,7555,7565,7570,7577,7583,7584,7586,7588,7615,7625,7659,7678,7682,7683,7691,7715,7718,7720,7730,7735,7744,7746,7749,7757,7768,7799,7806,7830,7832,7833,7834,7835,7851,7863,7871,7891,7894,7895,7900,7901,7919,7934,7950,7955,7957,7959,7961,7962,7964,7965,7979,7982,7994,7997,8020,8022,8023,8024,8027,8049,8067,8072,8109,8114,8143,8348,8460,8499,8508,8549,8652,8691,8698,8759,8860,9010,9059,9146,9218,9253,9303,9344,9351,9398,9441,9495,9568,9658,9745,9864,9907,9927,9996,10026,10110,10120,10176,10180,10186,10197,10199,10203,10205,10228,10243,10250,10295,10304,10306,10311,10328,10349,10364,10369,10387,10400,10435,10522,10553,10686,10697,10713,10769,10872,10912,10951,10954,10974,10978,11003,11015,11063,11071,11073,11076,11083,11146,11173,11206,11226,11235,11264,11394,11404,11424,11438,11458,11479,11534,11585,11702,11712,11730,11766,11864,11883,11968,11987,12071,12192,12193,12212,12218,12226,12248,12306,12393,12400,12435,12449,12488,12527,12545,12548,12576,12609,12617,12624,12625,12649,12684,12717,12758,12761,12789,12852,12894,12902,12944,12945,12959,12978,13020,13075,13115,13154,13188,13225,13241,13325,13327,13375,13433,13456,13508,13611,13646,13667,13671,13685,13731,13734,13742,13788,13851,13855,13869,13883,13945,13968,13972,13994,13998,14005,14048,14052,14057,14070,14080,14097,14101,14114,14183,14204,14205,14227,14229,14236,14249,14250,14270,14305,14314,14331,14341,14361,14366,14421,14431,14452,14482,14495,14505,14507,14522,14596,14616,14680,14684,14713,14746,14770,14807,14811,14846,14849,14855,14856,14865,14931,14946,14973,14974,14981,14993,15015,15038,15039,15046,15069,15100,15217,15251,15293,15304,15310,15318,15330,15343,15349,15356,15389,15412,15440,15470,15477,15513,15518,15522,15533,15543,15551,15565,15567,15576,15594,15663,15673,15689,15715,15728,15757,15797,15808,15835,15841,15866,15874,15902,15903,15916,15935,16020,16038,16055,16071,16103,16161,16163,16172,16209,16240,16280,16317,16358,16366,16410,16415,16431,16432,16440,16451,16520,16538,16562,16584,16604,16632,16645,16669,16685,16749,16775,16837,16907,16996,17019,17080,17090,17132,17138,17146,17227,17228,17242,17257,17280,17285,17291,17294,17307,17335,17344,17382,17407,17476,17487,17492,17510,17518,17537,17551,17565,17590,17603,17607,17634,17654,17725,17753,17757,17766,17824,17839,17852,17880,17883,17892,17925,17941,17950,17998,17999,18000,18032,18121,18150,18200,18216,18220,18228,18240,18248,18273,18276,18294,18303,18304,18311,18353,18360,18364,18375,18388,18390,18442,18482,18499,18505,18524,18558,18576,18583,18609,18667,18668,18670,18682,18698,18712,18730,18735,18793,18846,18874,18882,18895,18905,18948,18952,19026,19043,19051,19064,19092,19100,19101,19119,19133,19147,19175,19181,19207,19243,19247,19260,19288,19293,19322,19349,19366,19371,19381,19426,19444,19472,19484,19516,19541,19542,19612,19639,19651,19700,19727,19758,19764,19772,19880,19913,19962,19967,19975,19976,20016,20019,20029,20033,20044,20066,20089,20099,20127,20137,20149,20174,20191,20220,20223,20256,20289,20317,20355,20385,20397,20402,20437,20441,20476,20549,20586,20587,20592,20614,20621,20649,20654,20665,20668,20686,20705,20714,20739,20785,20790,20797,20807,20811,20820,20878,20885,20897,20941,20967,20973,20993,20996,21046,21113,21216,21226,21240,21255,21259,21290,21300,21346,21420,21516,21579,21602,21624,21667,21781,21798,21824,21843,21846,21851,21852,21861,21866,21903,21950,21952,22002,22008,22038,22086,22098,22116,22124,22125,22150,22171,22198,22212,22233,22250,22262,22289,22290,22312,22313,22315,22334,22367,22389,22404,22455,22457,22479,22500,22509,22602,22672,22693,22706,22711,22714,22732,22741,22745,22750,22753,22802,22803,22854,22856,22886,22901,22914,22959,23041,23046,23070,23078,23097,23100,23107,23123,23130,23148,23209,23214,23229,23253,23258,23259,23267,23305,23346,23363,23364,23383,23423,23458,23488,23501,23566,23615,23635,23649,23725,23729,23730,23767,23769,23790,23816,23838,23849,23885,23896,23926,23949,23959,23964,23978,23990,24024,24025,24062,24077,24118,24147,24193,24200,24211,24213,24219,24223,24288,24322,24337,24403,24411,24414,24433,24440,24456,24470,24513,24526,24557,24593,24595,24597,24616,24666,24695,24701,24732,24736,24737,24738,24748,24784,24785,24823,24830,24834,24841,24867,24915,24941,24964,25004,25048,25080,25111,25123,25135,25174,25178,25212,25274,25287,25294,25361,25365,25386,25397,25415,25443,25452,25460,25535,25538,25555,25560,25561,25591,25648,25657,25709,25888,25931,25934,25941,25990,26000,26030,26043,26048,26062,26102,26161,26166,26167,26186,26193,26288,26336,26359,26386,26409,26475,26483,26488,26499,26519,26525,26579,26609,26620,26646,26727,26728,26752,26760,26818,26820,26845,26901,26968,26989,27041,27074,27126,27138,27172,27315,27347,27391,27397,27407,27471,27474,27491,27492,27512,27518,27592,27604,27605,27749,27789,27790,27949,27968,28005,28311,28313,28320,28339,28425,28441,28468,28548,28557,28563,28575,28581,28630,28682,28780,28795,28799,28807,28808,28846,28850,28920,28928,29010,29319,29382,29473,29500,29626,29694,29695,29711,29924,29935,30099,30194,30284,30421,30988,31010,31199,31798,31853,32010,32051,33416,35639,35640,35643,35690,35744,35752,35762,36075,36208,36244,36321,36336,36378,36581,36584,36733,37759,38362,38912,38961,39063,39224,39240,39323,39467,39558,39600,40347,40813,40922,41038,41148,41171,41984,41985,42036,42314,42570)
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 | 1179 | 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.56 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.11 ms |
statistics | 1.77 ms |
preparing | 0.88 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.35 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 |