Tiempo de la consulta: 10.48 ms Después de la última consulta: 1.46 ms Consulta a la memoria: 0.846 MB memoria antes de la consulta: 4.274 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 08:03:35')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 08:03:35')
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,11,21,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,81,87,88,89,110,111,125,181,188,189,190,197,198,200,205,215,216,221,224,225,234,244,246,248,249,254,260,262,263,271,280,287,325,353,362,394,412,415,416,420,421,422,423,424,426,427,429,431,434,444,445,474,481,484,496,501,503,531,563,574,575,593,596,603,615,625,641,642,647,648,650,651,652,654,681,686,687,689,770,785,814,824,845,853,854,862,868,875,936,941,950,976,986,1066,1071,1207,1215,1223,1227,1266,1267,1268,1295,1296,1339,1348,1353,1357,1359,1434,1467,1503,1534,1538,1574,1637,1659,1686,1709,1714,1718,1721,1778,1804,1805,1863,1878,1896,1932,1996,2108,2208,2221,2258,2272,2305,2428,2455,2631,2632,2641,2688,2825,2855,2869,2902,3020,3025,3051,3067,3087,3176,3212,3291,3319,3325,3398,3485,3575,3595,3630,3650,3682,3725,3801,3868,3870,3925,4090,4095,4100,4131,4199,4227,4265,4310,4337,4338,4339,4392,4473,4493,4547,4578,4612,4613,4614,4615,4617,4674,4799,4855,4902,4905,4911,4930,4935,4965,4982,5053,5060,5062,5098,5147,5151,5166,5184,5189,5195,5199,5259,5263,5273,5324,5374,5392,5406,5461,5476,5519,5530,5538,5585,5639,5685,5694,5713,5719,5756,5782,5798,5800,5814,5819,5835,5852,5855,5857,5895,5906,5927,5934,5973,5996,6014,6032,6043,6050,6055,6066,6069,6081,6097,6127,6159,6178,6222,6226,6264,6270,6272,6276,6298,6311,6329,6330,6332,6340,6347,6350,6372,6373,6376,6388,6392,6427,6442,6455,6456,6460,6462,6465,6468,6470,6471,6473,6482,6492,6494,6497,6499,6500,6502,6510,6515,6517,6520,6534,6542,6543,6545,6546,6568,6601,6603,6608,6616,6641,6645,6654,6656,6658,6659,6666,6671,6677,6711,6716,6718,6744,6749,6762,6776,6779,6788,6805,6806,6809,6827,6836,6847,6868,6869,6872,6879,6882,6889,6910,6914,6915,6916,6924,6939,6942,6945,6990,6995,7004,7017,7043,7045,7048,7050,7056,7102,7109,7122,7124,7125,7134,7135,7138,7150,7154,7155,7156,7160,7161,7170,7171,7173,7176,7178,7179,7201,7210,7212,7213,7215,7218,7222,7231,7232,7234,7241,7243,7246,7249,7267,7268,7270,7277,7279,7282,7283,7285,7287,7289,7319,7327,7328,7330,7333,7334,7344,7346,7364,7367,7368,7370,7371,7372,7374,7376,7377,7378,7379,7380,7389,7396,7406,7407,7408,7410,7411,7413,7414,7415,7416,7417,7418,7422,7423,7427,7428,7430,7431,7435,7436,7446,7447,7450,7455,7456,7457,7458,7459,7461,7462,7463,7464,7465,7469,7486,7488,7489,7494,7495,7507,7513,7514,7523,7534,7545,7546,7552,7553,7555,7556,7560,7565,7567,7570,7577,7578,7583,7615,7625,7659,7674,7677,7678,7681,7682,7683,7686,7689,7690,7691,7692,7708,7713,7715,7716,7720,7722,7730,7735,7743,7744,7746,7749,7757,7758,7768,7780,7782,7799,7804,7806,7808,7810,7811,7812,7830,7831,7833,7834,7835,7836,7841,7851,7855,7862,7863,7864,7866,7871,7891,7894,7895,7900,7901,7904,7918,7919,7920,7923,7926,7928,7930,7933,7940,7955,7957,7960,7961,7962,7963,7968,7970,7979,7982,7987,7993,7994,8017,8020,8021,8022,8023,8024,8026,8027,8028,8048,8049,8056,8060,8064,8067,8070,8071,8072,8073,8082,8090,8103,8109,8111,8134,8139,8140,8178,8215,8289,8294,8296,8299,8306,8311,8330,8357,8418,8444,8565,8572,8589,8602,8610,8638,8678,8698,8710,8808,8810,8835,8856,8887,8923,8940,8948,8995,9046,9059,9096,9110,9140,9180,9186,9190,9199,9206,9218,9252,9253,9262,9282,9303,9308,9344,9362,9381,9394,9411,9428,9472,9478,9541,9568,9576,9641,9650,9658,9660,9677,9678,9685,9731,9759,9826,9873,9907,9915,9924,9996,10004,10014,10035,10044,10046,10113,10147,10186,10190,10197,10199,10205,10243,10265,10274,10342,10349,10379,10387,10399,10400,10407,10522,10534,10553,10560,10600,10774,10811,10835,11019,11071,11099,11126,11192,11226,11229,11231,11345,11404,11436,11458,11465,11548,11549,11581,11590,11592,11706,11750,11772,11791,11849,11864,11979,12013,12020,12024,12171,12184,12226,12324,12334,12340,12358,12413,12435,12440,12460,12474,12488,12499,12520,12527,12550,12609,12617,12620,12649,12650,12670,12685,12686,12708,12795,12913,12943,12944,12973,12978,12996,12998,13014,13016,13065,13069,13070,13094,13121,13152,13154,13209,13263,13294,13325,13327,13348,13375,13474,13475,13656,13667,13685,13728,13803,13894,13900,13971,13973,14048,14052,14084,14110,14146,14189,14229,14250,14293,14349,14352,14357,14362,14366,14421,14431,14494,14505,14534,14536,14554,14577,14596,14653,14680,14682,14685,14713,14741,14749,14752,14770,14818,14832,14849,14857,14860,14865,14889,14946,14947,14969,14973,14974,15015,15038,15039,15043,15046,15065,15077,15090,15133,15184,15186,15244,15245,15253,15261,15279,15293,15298,15318,15382,15414,15475,15476,15520,15533,15574,15594,15598,15627,15644,15673,15689,15751,15753,15796,15797,15808,15835,15849,15861,15874,15895,15902,15916,15925,15945,15954,15960,15972,15998,15999,16010,16031,16040,16062,16071,16078,16101,16103,16115,16156,16161,16172,16176,16219,16240,16257,16284,16401,16410,16440,16487,16497,16520,16526,16543,16566,16570,16584,16588,16751,16823,16826,16833,16854,16907,16908,16913,16935,16950,16964,16976,17014,17080,17114,17158,17291,17309,17334,17335,17344,17419,17476,17496,17528,17537,17580,17590,17607,17629,17643,17702,17721,17763,17824,17857,17881,17883,17941,17959,17991,17999,18014,18068,18071,18073,18150,18220,18227,18260,18276,18284,18300,18306,18309,18317,18353,18360,18382,18401,18409,18423,18442,18482,18491,18512,18516,18558,18576,18578,18582,18599,18663,18695,18701,18712,18730,18735,18744,18757,18819,18905,19019,19048,19049,19101,19112,19170,19183,19213,19222,19243,19282,19286,19316,19359,19381,19426,19432,19460,19472,19484,19533,19542,19551,19607,19650,19651,19661,19668,19695,19733,19742,19758,19772,19783,19825,19851,19858,19886,19923,19931,19937,19947,19967,19980,20060,20066,20095,20150,20191,20192,20193,20213,20289,20308,20385,20439,20448,20459,20486,20567,20592,20595,20616,20632,20637,20648,20670,20699,20700,20704,20713,20727,20776,20792,20832,20847,20885,21013,21016,21038,21071,21090,21159,21174,21256,21259,21273,21279,21283,21285,21288,21294,21300,21327,21338,21340,21366,21368,21413,21435,21464,21485,21486,21524,21526,21529,21566,21587,21588,21602,21614,21618,21623,21624,21650,21660,21661,21664,21690,21695,21696,21704,21719,21727,21800,21824,21843,21850,21884,21910,21913,21924,21952,21954,21955,21990,22009,22015,22018,22038,22062,22077,22116,22117,22137,22163,22164,22195,22224,22230,22241,22262,22289,22290,22302,22324,22337,22352,22362,22400,22406,22421,22446,22453,22512,22550,22551,22573,22580,22602,22603,22614,22615,22620,22622,22626,22655,22658,22676,22693,22710,22727,22737,22765,22767,22780,22787,22797,22804,22829,22833,22843,22855,22886,22897,22914,22923,22941,22947,22959,22963,22972,22989,23007,23023,23024,23043,23062,23082,23089,23107,23115,23121,23123,23124,23179,23214,23229,23249,23308,23313,23364,23371,23437,23480,23482,23528,23542,23566,23631,23665,23716,23725,23729,23788,23849,23879,23885,23927,23943,23949,24015,24016,24062,24107,24125,24140,24162,24164,24172,24211,24223,24226,24237,24248,24249,24279,24329,24362,24393,24408,24409,24434,24458,24475,24522,24526,24538,24582,24595,24617,24650,24736,24738,24764,24766,24774,24785,24803,24834,24846,24862,24880,24894,24896,24915,24927,24937,24956,24967,24983,24993,25001,25013,25030,25035,25040,25062,25073,25076,25091,25094,25114,25131,25137,25138,25167,25171,25178,25225,25255,25276,25294,25296,25318,25321,25335,25351,25367,25369,25371,25372,25390,25391,25393,25406,25414,25431,25433,25436,25438,25446,25448,25451,25457,25459,25464,25465,25467,25468,25472,25476,25482,25485,25486,25489,25492,25493,25494,25495,25499,25504,25506,25508,25509,25510,25512,25517,25520,25536,25537,25538,25540,25542,25545,25546,25552,25555,25559,25569,25572,25576,25578,25582,25584,25587,25588,25596,25646,25648,25660,25674,25904,25937,25941,25953,25974,26000,26015,26033,26037,26044,26047,26074,26147,26203,26221,26317,26343,26359,26360,26362,26386,26409,26415,26424,26454,26474,26506,26554,26572,26577,26578,26579,26609,26612,26646,26651,26653,26677,26683,26694,26713,26742,26785,26787,26796,26801,26820,26845,26881,26905,26907,26944,26962,26968,26973,27000,27038,27067,27095,27123,27126,27342,27347,27366,27481,27492,27512,27530,27563,27592,27600,27604,27605,27688,27722,27749,27777,27789,27846,28072,28080,28115,28339,28423,28440,28441,28442,28468,28534,28614,28615,28616,28635,28673,28712,28728,28741,28751,28817,28845,28846,28870,28930,28944,29054,29067,29142,29222,29242,29359,29382,29405,29444,29460,29635,29655,29759,29870,29889,30194,30325,30988,31463,31533,31684,31725,31798,31821,31852,31853,31899,32472,32679,33416,33417,33605,34030,34071,34159,34243,34262,34270,34375,34611,34956,35266,35330,35485,35639,35640,35643,35653,35713,35741,35744,35752,35822,35881,35955,36007,36075,36143,36208,36214,36251,36339,36382,36581,36584,36617,36620,36838,37002,37056,37411,37422,37524,37532,37688,37758,37759,37796,38071,38199,38362,38363,38452,38585,38664,38665,38719,38762,38912,38933,39224,39227,39231,39240,39397,39398,39530,39600,39683,39687,39769,39826,39896,39897,39958,39964,39977,40025,40036,40052,40082,40096,40183,40292,40344,40492,40530,40605,40650,40703,40760,41070,41095,41134,41148,41171,41188,41204,41464,41503,41601,41677,41681,41706,41778,41861,42036,42107,42185,42205,42387,42396,42408,42590,42639,42708,42716,42836,42890,42900,42952,42991,42993,42998,43050,43051,43078,43114,43120,43191,43247,43248,43274,43291,43300,43301,43335,43360,43365,43386,43398,43412,43424,43528,43546,43599,43651,43688,43700,43716,43725,43885,43942,44013,44046,44051,44060,44079,44094,44120,44128,44159,44165,44175,44200,44208,44229,44263,44282,44312,44327,44382,44387,44406,44422,44447,44453,44458,44479,44487,44500,44509,44517,44562,44609,44662,44682,44761,44762,44786,44797,44950,45008,45024,45050,45086,45106,45131,45152,45183,45196,45208,45209,45257,45275,45309)
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 | 1722 | 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.77 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.30 ms |
System lock | 0.02 ms |
optimizing | 0.11 ms |
statistics | 2.56 ms |
preparing | 1.29 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 4.51 ms |
end | 0.02 ms |
query end | 0.11 ms |
closing tables | 0.03 ms |
freeing items | 0.13 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 |