Tiempo de la consulta: 4.98 ms Después de la última consulta: 1.16 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.501 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-03 18:40:16')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-03 18:40:16')
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,49,71,81,84,90,91,92,93,95,96,97,98,99,100,101,102,103,104,105,106,107,108,112,197,198,199,209,210,211,217,226,227,228,229,230,231,232,234,236,237,238,240,242,243,260,263,265,276,287,353,391,394,419,428,466,487,493,501,516,523,563,605,607,608,637,691,694,714,723,725,770,803,868,904,948,953,965,966,1002,1031,1045,1067,1075,1104,1110,1121,1147,1164,1168,1209,1217,1223,1291,1296,1313,1348,1367,1503,1538,1698,1714,1718,1804,1825,1830,1845,1862,1928,1957,2156,2252,2258,2305,2590,2729,2822,2964,3020,3058,3209,3319,3320,3442,3575,4100,4131,4268,4339,4473,4476,4493,4587,4612,4613,4614,4615,4617,4765,4784,4808,4902,4982,5060,5125,5150,5199,5323,5371,5461,5530,5567,5594,5622,5647,5649,5685,5726,5727,5814,5847,5855,5857,5894,5973,5996,6159,6257,6264,6318,6341,6363,6372,6386,6420,6427,6465,6468,6470,6473,6478,6492,6502,6518,6557,6572,6574,6616,6690,6744,6756,6760,6776,6839,6840,6847,6870,6881,6915,6984,7017,7110,7138,7215,7218,7231,7232,7234,7241,7243,7246,7249,7285,7289,7319,7325,7328,7330,7333,7334,7344,7346,7364,7367,7368,7370,7371,7374,7377,7379,7380,7396,7406,7407,7408,7410,7413,7414,7415,7416,7417,7422,7430,7431,7435,7436,7447,7450,7455,7456,7457,7458,7463,7464,7465,7486,7489,7545,7546,7552,7553,7555,7565,7570,7577,7583,7587,7591,7615,7624,7625,7654,7659,7678,7682,7683,7689,7691,7715,7720,7735,7744,7746,7749,7757,7768,7772,7776,7799,7829,7830,7833,7834,7835,7851,7863,7871,7891,7894,7895,7900,7901,7919,7928,7933,7955,7957,7958,7961,7962,7967,7979,7982,8020,8022,8023,8024,8049,8056,8062,8067,8070,8072,8093,8139,8190,8220,8320,8354,8391,8533,8698,8754,8823,8844,9003,9059,9102,9218,9253,9303,9344,9355,9568,9650,9658,9677,9678,9724,9907,9924,9996,10031,10100,10186,10196,10197,10199,10205,10243,10323,10349,10387,10400,10436,10440,10451,10522,10572,10722,10739,10889,10956,11071,11163,11327,11404,11458,11746,11758,11815,11864,11911,11946,12095,12177,12226,12385,12412,12423,12435,12488,12500,12510,12527,12609,12617,12645,12649,12677,12679,12708,12756,12841,12887,12913,12944,12973,12978,13010,13062,13067,13154,13157,13194,13224,13231,13253,13276,13321,13325,13327,13349,13365,13375,13398,13405,13408,13471,13473,13487,13530,13566,13667,13681,13685,13750,13800,13863,13866,13868,13902,13917,13963,13969,14029,14034,14047,14052,14095,14103,14156,14203,14213,14218,14224,14240,14250,14263,14293,14356,14366,14386,14421,14431,14505,14537,14581,14596,14680,14713,14770,14844,14849,14865,14935,14946,14973,14974,14987,15015,15021,15046,15079,15110,15179,15188,15198,15224,15230,15245,15262,15293,15298,15318,15347,15352,15366,15390,15418,15421,15470,15471,15473,15482,15490,15495,15496,15511,15517,15533,15550,15573,15594,15630,15667,15673,15689,15759,15784,15797,15808,15835,15874,15902,15916,15945,16016,16036,16040,16048,16055,16092,16101,16103,16141,16163,16165,16172,16213,16230,16240,16263,16339,16352,16365,16367,16410,16440,16488,16520,16532,16584,16585,16692,16720,16812,16826,16894,16907,16983,17036,17045,17063,17080,17142,17154,17234,17236,17275,17291,17307,17317,17334,17335,17343,17344,17409,17447,17453,17476,17501,17506,17511,17520,17521,17590,17607,17611,17619,17710,17771,17824,17862,17883,17939,17941,17948,17949,17965,17966,17999,18052,18053,18073,18106,18124,18133,18150,18161,18174,18181,18213,18220,18297,18336,18353,18362,18426,18442,18458,18465,18482,18509,18538,18556,18558,18576,18588,18675,18707,18712,18726,18730,18735,18753,18801,18845,18846,18852,18864,18904,18905,18956,18958,18999,19018,19024,19040,19056,19057,19062,19082,19098,19101,19130,19150,19160,19174,19190,19243,19245,19250,19252,19263,19312,19353,19358,19369,19402,19426,19438,19454,19467,19472,19483,19484,19527,19542,19551,19582,19583,19592,19636,19650,19651,19676,19702,19715,19722,19772,19791,19795,19804,19816,19835,19837,19929,19939,19943,19963,19967,20004,20026,20039,20053,20066,20092,20122,20169,20183,20191,20216,20269,20287,20289,20296,20301,20325,20343,20360,20385,20386,20408,20434,20451,20492,20497,20526,20528,20539,20568,20573,20592,20617,20633,20658,20670,20688,20711,20716,20730,20771,20792,20804,20881,20885,20894,20907,20944,20964,20984,21002,21049,21080,21118,21135,21172,21182,21254,21259,21300,21313,21400,21404,21436,21449,21454,21472,21543,21602,21614,21624,21631,21648,21679,21700,21732,21753,21767,21768,21843,21891,21944,21952,21958,21959,21960,21969,22032,22049,22085,22101,22116,22156,22162,22172,22189,22208,22234,22239,22253,22262,22266,22267,22288,22289,22290,22331,22332,22339,22344,22361,22363,22409,22445,22466,22481,22499,22523,22527,22531,22544,22547,22552,22564,22602,22611,22693,22694,22695,22726,22735,22743,22753,22764,22781,22784,22814,22845,22865,22871,22886,22914,22919,22958,22959,22973,22989,23003,23010,23034,23036,23062,23063,23072,23074,23096,23099,23104,23107,23119,23123,23150,23184,23203,23214,23218,23229,23230,23235,23254,23264,23268,23292,23300,23304,23335,23357,23358,23359,23364,23371,23381,23391,23401,23408,23455,23458,23460,23475,23480,23483,23517,23523,23554,23555,23585,23604,23619,23627,23632,23719,23725,23729,23759,23768,23805,23813,23849,23854,23868,23882,23885,23893,23897,23901,23905,23909,23942,23947,23949,23964,23986,24000,24007,24025,24062,24092,24112,24124,24146,24160,24186,24197,24209,24211,24223,24226,24238,24259,24294,24303,24339,24352,24357,24361,24376,24390,24429,24480,24496,24503,24505,24526,24548,24585,24595,24598,24615,24618,24663,24678,24679,24711,24736,24738,24741,24742,24764,24772,24782,24785,24834,24842,24861,24874,24879,24910,24915,24918,24926,24934,24963,24984,24986,24992,25005,25062,25079,25087,25089,25098,25115,25142,25151,25178,25232,25244,25255,25276,25287,25294,25303,25368,25375,25401,25405,25432,25447,25480,25487,25507,25520,25532,25537,25538,25548,25555,25558,25596,25613,25637,25648,25649,25675,25684,25716,25748,25780,25792,25809,25815,25863,25918,25941,25949,25956,25961,25994,26000,26047,26118,26131,26184,26221,26260,26283,26303,26321,26346,26359,26386,26409,26414,26443,26453,26456,26569,26579,26606,26609,26623,26625,26646,26658,26673,26699,26710,26732,26791,26811,26820,26845,26884,26900,26925,26940,26968,26971,26978,26990,27102,27109,27118,27126,27143,27151,27171,27232,27238,27258,27307,27347,27396,27405,27430,27466,27473,27492,27510,27512,27550,27573,27604,27605,27668,27749,27789,28030,28121,28280,28334,28339,28441,28447,28468,28529,28533,28718,28738,28739,28759,28825,28846,29063,29155,29297,29328,29331,29406,29710,29926,29937,29943,30083,30194,30273,30388,30483,30484,30808,30988,31136,31447,31532,31798,31853,32107,32502,33349,33416,35000,35585,35639,35640,35643,35691,35722,35744,35752,35832,35846,36052,36055,36075,36208,36581,36584,37759,38362,38902,38912,39088,39158,39224,39225,39240,39263,39269,39320,39370,39381,39411,39513,39600,39615,39806,39887,40086,40104,40113,40168,40401,40451,40492,40578,40878,41049,41148,41171,41213,41236,41253,41254,41477)
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 | 1207 | 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.64 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.25 ms |
System lock | 0.02 ms |
optimizing | 0.10 ms |
statistics | 2.01 ms |
preparing | 0.93 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.41 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 |