Tiempo de la consulta: 6.60 ms Después de la última consulta: 1.26 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.394 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-04 06:24:28')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 06:24:28')
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(11,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,71,73,81,87,88,89,90,92,96,97,98,99,102,104,107,110,111,125,170,186,188,189,190,198,199,200,205,209,210,215,216,217,226,228,232,234,238,240,242,243,246,248,249,254,263,265,271,276,325,330,353,362,412,415,416,419,420,421,422,423,424,426,427,428,429,431,433,452,459,466,484,487,496,501,503,523,531,574,575,593,605,607,612,628,634,637,647,648,686,785,818,853,862,868,902,904,948,966,986,1001,1015,1031,1066,1067,1119,1167,1207,1209,1223,1225,1268,1270,1326,1353,1357,1434,1475,1698,1718,1800,1803,1825,1845,1878,1957,2073,2085,2108,2156,2191,2208,2272,2661,2689,2710,2729,2780,2808,2822,2825,3020,3051,3058,3067,3188,3212,3325,3444,3473,3650,3682,4310,4674,4784,4808,4832,4902,4905,5060,5125,5189,5266,5323,5324,5371,5392,5434,5462,5466,5476,5538,5544,5603,5622,5633,5647,5649,5685,5726,5727,5756,5798,5847,5895,6045,6264,6268,6311,6335,6374,6386,6392,6476,6477,6482,6518,6545,6611,6616,6666,6671,6733,6760,6766,6776,6836,6839,6847,6868,6881,6915,6984,7017,7050,7056,7105,7109,7124,7138,7210,7287,7450,7527,7595,7624,7692,7716,7730,7772,7782,7811,7918,7928,7933,7958,7967,7970,7993,8021,8027,8056,8062,8070,8088,8164,8215,8320,8354,8356,8435,8444,8565,8589,8602,8610,8638,8835,8844,8856,8887,9003,9206,9262,9282,9411,9428,9472,9650,9677,9678,9724,9924,9932,9934,10031,10035,10046,10100,10101,10113,10274,10301,10323,10436,10444,10708,10764,10889,10956,11163,11192,11260,11345,11408,11863,11911,11917,11946,12020,12095,12177,12226,12324,12334,12412,12460,12576,12609,12620,12623,12650,12667,12670,12679,12684,12685,12686,12708,12745,12746,12795,12806,12817,12846,12887,12897,12913,12928,12943,12973,12974,12996,13010,13011,13014,13016,13062,13069,13070,13149,13152,13186,13188,13231,13276,13294,13321,13348,13398,13405,13471,13473,13474,13475,13500,13681,13728,13750,13800,13868,13900,13969,13971,13973,14029,14034,14156,14203,14218,14224,14229,14263,14293,14356,14362,14400,14534,14536,14554,14581,14703,14782,14807,14810,14860,14987,14988,15014,15021,15038,15039,15043,15110,15171,15179,15188,15198,15235,15245,15261,15262,15293,15298,15314,15322,15347,15366,15381,15382,15414,15418,15421,15470,15473,15475,15476,15482,15495,15511,15517,15520,15533,15550,15573,15574,15603,15630,15667,15734,15759,15784,15796,15802,15835,15861,15885,15901,15925,15931,15945,15972,16000,16055,16062,16071,16115,16155,16161,16165,16176,16213,16228,16263,16277,16352,16365,16412,16417,16422,16479,16488,16497,16516,16526,16532,16543,16547,16566,16568,16719,16720,16751,16812,16826,16833,16894,16908,16918,16950,16976,16983,17045,17063,17066,17101,17114,17142,17154,17166,17236,17275,17309,17317,17333,17334,17335,17409,17419,17453,17474,17496,17506,17520,17521,17528,17534,17584,17607,17611,17619,17629,17643,17702,17710,17715,17721,17821,17857,17862,17949,17965,18046,18047,18052,18071,18073,18082,18106,18124,18133,18181,18213,18220,18260,18300,18309,18313,18336,18360,18362,18377,18421,18426,18458,18465,18478,18506,18509,18527,18538,18558,18576,18578,18588,18624,18675,18705,18707,18719,18726,18753,18757,18766,18775,18801,18819,18845,18846,18852,18921,18933,18956,18958,18999,19024,19039,19040,19057,19098,19150,19245,19252,19263,19282,19284,19295,19312,19318,19321,19353,19358,19369,19381,19402,19414,19454,19460,19483,19484,19499,19527,19551,19582,19650,19661,19668,19676,19695,19722,19733,19772,19791,19816,19819,19825,19837,19886,19923,19931,19937,19939,19943,19963,19980,19988,20004,20026,20039,20060,20092,20095,20122,20183,20188,20192,20193,20213,20216,20233,20269,20296,20301,20308,20324,20343,20370,20386,20408,20434,20439,20448,20459,20492,20497,20526,20528,20539,20543,20567,20573,20592,20595,20610,20616,20617,20648,20663,20670,20679,20688,20699,20700,20727,20728,20758,20792,20804,20830,20847,20881,20894,20907,20925,20944,20964,20984,21002,21016,21027,21035,21038,21041,21057,21058,21069,21071,21080,21138,21158,21159,21167,21182,21195,21221,21233,21241,21256,21259,21279,21283,21285,21288,21300,21338,21343,21368,21394,21404,21445,21454,21464,21485,21486,21524,21526,21529,21617,21618,21623,21631,21634,21646,21650,21661,21664,21669,21679,21690,21695,21704,21719,21727,21760,21761,21767,21800,21824,21843,21850,21889,21891,21907,21910,21913,21915,21942,21954,21955,21958,21960,21967,21986,21988,21995,21996,22002,22015,22018,22032,22041,22056,22062,22077,22085,22103,22117,22156,22162,22163,22164,22172,22189,22195,22239,22241,22253,22267,22283,22302,22318,22324,22339,22344,22354,22357,22361,22363,22406,22409,22411,22421,22446,22453,22466,22481,22498,22499,22512,22514,22544,22547,22550,22564,22580,22595,22603,22611,22620,22622,22626,22655,22657,22658,22661,22694,22695,22710,22726,22727,22746,22753,22765,22780,22781,22787,22799,22804,22814,22829,22833,22858,22865,22871,22887,22897,22923,22947,22958,22972,22973,22989,23003,23007,23010,23024,23036,23043,23062,23069,23074,23082,23089,23096,23099,23104,23118,23119,23124,23179,23184,23203,23214,23218,23230,23235,23240,23254,23264,23268,23282,23292,23297,23304,23321,23331,23334,23348,23371,23381,23391,23445,23455,23460,23475,23480,23483,23486,23523,23528,23532,23535,23554,23555,23585,23603,23604,23619,23632,23665,23680,23716,23719,23733,23743,23805,23813,23847,23851,23854,23893,23897,23901,23904,23905,23909,23927,23947,23951,23953,23964,23986,24000,24007,24016,24055,24067,24092,24160,24169,24177,24197,24209,24223,24227,24238,24249,24251,24294,24303,24305,24323,24339,24352,24361,24362,24376,24385,24393,24408,24410,24429,24464,24475,24496,24503,24522,24526,24532,24582,24585,24598,24605,24615,24617,24626,24632,24663,24678,24679,24682,24711,24741,24764,24766,24772,24782,24800,24803,24805,24816,24861,24918,24934,24937,24941,24956,24959,24967,24969,24984,24992,24993,25005,25030,25031,25035,25062,25079,25089,25131,25138,25151,25171,25232,25243,25244,25287,25303,25318,25351,25368,25372,25375,25401,25406,25410,25423,25432,25436,25448,25453,25480,25493,25498,25506,25507,25517,25518,25526,25542,25566,25582,25584,25613,25637,25646,25649,25660,25702,25712,25716,25774,25797,25863,25874,25890,25904,25918,25949,25956,26000,26033,26047,26087,26118,26131,26147,26168,26184,26201,26221,26283,26317,26334,26343,26351,26354,26360,26362,26367,26391,26401,26405,26415,26424,26428,26432,26443,26454,26474,26515,26577,26625,26651,26673,26674,26677,26699,26702,26713,26732,26734,26742,26790,26801,26810,26820,26845,26881,26884,26900,26905,26907,26925,26940,26944,26947,26956,26971,26973,26978,26990,27000,27038,27040,27052,27091,27109,27118,27126,27143,27171,27187,27231,27232,27252,27303,27320,27366,27405,27430,27530,27541,27550,27583,27621,27623,27627,27654,27688,27722,27806,27846,27937,28022,28030,28032,28072,28080,28121,28272,28339,28388,28402,28410,28416,28423,28440,28442,28455,28458,28459,28511,28527,28528,28578,28614,28615,28616,28625,28679,28712,28718,28728,28741,28744,28789,28825,28840,28845,28867,28868,28944,28951,29019,29054,29063,29155,29189,29201,29219,29221,29222,29251,29297,29460,29635,29751,29926,29943,30083,30273,30347,30348,30404,30483,30484,30616,30808,31136,31409,31447,31798,32107,32129,32182,32284,32472,32514,32623,32827,32880,33046,33417,33475,33907,33998,34197,34449,34525,34577,34583,34714,34978,34994,35000,35114,35324,35330,35379,35407,35464,35481,35503,35504,35521,35585,35621,35626,35653,35668,35713,35744,35800,35823,35832,35835,35840,35846,35873,35892,35905,35955,35992,36019,36036,36056,36079,36119,36127,36192,36204,36205,36304,36427,36462,36850,37002,37235,37532,38210,38218,38263,38357,38619,38651,38894,38957,39251,39320,39381,39397,39398,39495,39530,39846,39877,39887,40036,40066,40086,40099,40113,40186,40187,40214,40290,40344,40392,40451,40469,40492,40578,40605,40636,40719,40769,41024,41049,41146,41194,41213,41477,41672,41869,42152,42254,43253,43439,43753,43824,43905,43913,44062,44679,44830,44852,44870,45008,45032,45068)
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 | 1368 | 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.89 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.36 ms |
System lock | 0.02 ms |
optimizing | 0.09 ms |
statistics | 2.75 ms |
preparing | 1.47 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 |