Tiempo de la consulta: 6.05 ms Después de la última consulta: 1.42 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 4.314 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 17:00:33')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-08 17:00:33')
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(14,19,20,21,22,23,24,25,26,27,28,29,30,31,32,49,57,71,72,90,92,96,97,98,99,102,104,107,117,127,136,198,199,202,204,209,210,217,226,228,232,234,238,240,242,243,253,263,265,271,272,276,280,344,350,353,374,376,377,378,379,380,419,428,456,466,484,487,505,507,523,550,551,583,605,607,608,611,637,667,686,705,709,771,801,816,831,868,871,878,882,891,895,904,917,928,941,948,961,964,966,968,976,1031,1033,1043,1059,1067,1124,1134,1198,1204,1207,1209,1215,1223,1226,1238,1287,1329,1339,1347,1381,1383,1478,1559,1579,1587,1594,1596,1601,1621,1690,1691,1698,1709,1738,1756,1760,1782,1787,1825,1845,1954,1957,2024,2082,2150,2156,2290,2293,2425,2433,2482,2530,2595,2656,2667,2714,2726,2729,2740,2742,2758,2797,2822,2870,2894,2922,2974,2975,3020,3024,3058,3091,3097,3129,3193,3215,3273,3290,3306,3329,3332,3340,3350,3353,3442,3495,3589,3626,3634,3696,3769,3783,3785,3816,3837,3870,3895,3930,3951,3957,4004,4008,4087,4092,4206,4305,4319,4357,4378,4410,4560,4580,4627,4631,4638,4640,4784,4792,4808,4853,4857,4896,4902,4929,4992,5051,5063,5125,5175,5186,5281,5285,5323,5365,5371,5451,5515,5561,5622,5634,5647,5649,5660,5685,5726,5727,5730,5798,5847,5969,6121,6176,6186,6211,6215,6216,6245,6264,6292,6333,6367,6384,6386,6403,6445,6459,6464,6482,6503,6518,6604,6605,6616,6631,6687,6708,6760,6764,6793,6802,6839,6847,6856,6881,6908,6915,6939,6940,6942,6957,6961,6984,6989,7017,7121,7154,7209,7245,7253,7303,7368,7374,7413,7434,7450,7454,7484,7492,7522,7556,7584,7618,7624,7638,7670,7711,7713,7720,7772,7774,7802,7829,7862,7916,7923,7928,7950,7958,7965,7967,7980,7985,7994,8027,8037,8056,8062,8070,8073,8108,8238,8249,8312,8320,8351,8354,8427,8487,8566,8568,8569,8587,8610,8694,8838,8844,8983,9003,9017,9057,9201,9203,9249,9256,9257,9318,9351,9429,9574,9650,9723,9724,9725,9734,9745,9749,9792,9818,9820,9861,9924,9942,9945,9966,9985,9993,10011,10031,10051,10099,10100,10141,10149,10165,10216,10227,10237,10248,10259,10260,10262,10265,10282,10313,10323,10357,10369,10385,10436,10471,10478,10483,10534,10554,10611,10666,10686,10777,10820,10821,10856,10857,10860,10888,10889,10912,10956,10970,10971,11005,11006,11091,11112,11123,11163,11241,11285,11290,11292,11320,11333,11362,11365,11388,11487,11539,11663,11762,11799,11816,11893,11900,11911,11925,11946,11950,11976,11996,12009,12032,12095,12126,12177,12178,12179,12186,12223,12237,12251,12369,12388,12412,12446,12463,12474,12493,12608,12630,12670,12679,12685,12758,12838,12887,12898,12913,12962,12973,12985,13002,13010,13020,13036,13062,13079,13143,13152,13176,13188,13190,13191,13229,13231,13246,13259,13276,13285,13309,13321,13334,13398,13405,13434,13456,13471,13473,13573,13609,13621,13631,13647,13662,13673,13674,13681,13702,13750,13800,13860,13867,13868,13900,13901,13969,13986,13994,14005,14029,14034,14062,14098,14152,14156,14184,14203,14205,14218,14224,14227,14248,14250,14263,14273,14293,14336,14339,14348,14352,14354,14356,14368,14386,14396,14408,14424,14426,14456,14537,14581,14596,14600,14624,14625,14629,14652,14676,14684,14692,14695,14754,14789,14794,14815,14843,14856,14941,14984,14987,15018,15021,15028,15039,15108,15110,15120,15147,15179,15188,15196,15198,15215,15243,15262,15263,15266,15286,15298,15304,15315,15316,15347,15356,15366,15370,15402,15418,15421,15439,15444,15464,15470,15473,15477,15482,15485,15495,15511,15517,15520,15521,15548,15550,15551,15562,15573,15604,15608,15616,15630,15664,15667,15703,15709,15714,15723,15725,15728,15755,15759,15763,15778,15784,15805,15835,15837,15841,15866,15873,15897,15955,16020,16037,16050,16053,16088,16093,16153,16165,16166,16213,16257,16263,16352,16362,16365,16369,16370,16381,16417,16451,16474,16488,16513,16523,16532,16539,16542,16605,16619,16644,16657,16670,16675,16720,16722,16783,16812,16825,16826,16845,16867,16894,16982,16983,17045,17059,17063,17115,17128,17132,17142,17154,17163,17169,17194,17234,17236,17244,17256,17257,17275,17291,17317,17334,17337,17365,17373,17407,17409,17420,17422,17432,17453,17465,17493,17506,17520,17521,17533,17542,17552,17566,17569,17573,17611,17619,17623,17625,17626,17660,17688,17710,17712,17717,17747,17766,17772,17775,17820,17852,17862,17875,17889,17895,17914,17930,17933,17949,17952,17965,17967,17980,17987,18031,18038,18052,18057,18072,18106,18116,18118,18124,18133,18140,18169,18181,18200,18213,18216,18260,18300,18311,18314,18316,18331,18336,18362,18402,18425,18426,18429,18431,18440,18447,18458,18465,18481,18490,18493,18509,18514,18524,18538,18543,18566,18588,18605,18626,18646,18649,18659,18668,18675,18679,18687,18707,18726,18738,18753,18780,18781,18793,18801,18811,18830,18837,18845,18846,18849,18852,18871,18891,18914,18930,18951,18956,18958,18978,18991,18999,19001,19013,19024,19031,19040,19053,19055,19057,19059,19078,19083,19098,19134,19145,19150,19168,19192,19219,19237,19245,19252,19254,19259,19260,19263,19271,19277,19293,19312,19318,19325,19353,19358,19369,19402,19411,19427,19429,19448,19454,19457,19483,19484,19505,19519,19526,19527,19535,19551,19553,19556,19574,19582,19595,19596,19612,19645,19646,19659,19676,19679,19699,19700,19720,19722,19741,19772,19773,19791,19816,19830,19834,19837,19841,19855,19871,19877,19881,19894,19901,19939,19943,19953,19963,19965,19972,19984,19996,20004,20012,20016,20039,20042,20045,20076,20092,20122,20133,20137,20153,20154,20181,20183,20216,20239,20269,20295,20296,20301,20343,20349,20386,20390,20403,20405,20408,20432,20433,20434,20437,20447,20488,20492,20497,20524,20526,20528,20539,20545,20570,20573,20588,20592,20617,20627,20649,20670,20681,20688,20698,20708,20714,20718,20721,20726,20738,20744,20772,20781,20792,20794,20804,20807,20814,20880,20881,20894,20896,20906,20907,20940,20944,20960,20964,20979,20980,20984,21002,21080,21115,21122,21170,21171,21182,21198,21213,21247,21251,21259,21300,21325,21331,21350,21370,21380,21390,21398,21404,21430,21448,21449,21454,21472,21481,21539,21551,21576,21586,21591,21607,21611,21631,21640,21653,21668,21679,21680,21709,21734,21748,21756,21767,21781,21867,21891,21895,21899,21916,21952,21958,21960,21990,22021,22032,22038,22039,22044,22045,22066,22067,22085,22087,22096,22132,22153,22156,22162,22170,22172,22189,22192,22215,22216,22238,22239,22253,22255,22267,22276,22289,22295,22320,22334,22339,22344,22349,22361,22363,22371,22382,22388,22402,22409,22436,22458,22465,22466,22476,22481,22499,22500,22501,22503,22509,22543,22544,22547,22564,22579,22587,22588,22602,22611,22623,22693,22694,22695,22708,22709,22726,22738,22751,22753,22781,22814,22820,22865,22866,22871,22876,22888,22891,22915,22924,22930,22931,22943,22958,22973,23003,23009,23010,23023,23028,23029,23036,23064,23072,23074,23087,23096,23099,23103,23104,23107,23112,23119,23122,23131,23137,23156,23176,23184,23203,23210,23218,23219,23228,23230,23232,23235,23236,23252,23254,23258,23264,23268,23270,23279,23292,23299,23304,23308,23312,23367,23368,23371,23381,23391,23401,23428,23444,23455,23460,23469,23475,23483,23484,23489,23523,23541,23554,23555,23567,23577,23585,23592,23604,23613,23619,23621,23623,23632,23642,23649,23657,23665,23682,23691,23693,23709,23716,23719,23722,23729,23768,23793,23805,23811,23813,23815,23846,23849,23854,23855,23861,23893,23897,23899,23901,23902,23905,23909,23920,23944,23947,23949,23964,23967,23973,23984,23986,24000,24007,24009,24015,24024,24032,24060,24088,24092,24095,24105,24110,24111,24115,24135,24158,24159,24160,24164,24166,24196,24197,24198,24209,24226,24229,24238,24239,24270,24282,24289,24294,24296,24303,24306,24335,24339,24352,24361,24362,24368,24375,24376,24422,24429,24430,24453,24496,24498,24503,24506,24526,24536,24556,24575,24585,24598,24607,24615,24617,24635,24656,24658,24663,24677,24678,24679,24707,24711,24713,24722,24724,24726,24741,24764,24765,24772,24782,24784,24794,24814,24816,24819,24823,24838,24853,24861,24881,24918,24924,24931,24934,24944,24958,24982,24984,24992,25005,25036,25043,25048,25062,25079,25089,25093,25109,25136,25151,25155,25183,25200,25205,25232,25244,25268,25282,25287,25291,25303,25312,25327,25332,25342,25349,25365,25367,25368,25375,25384,25386,25397,25401,25408,25416,25417,25421,25432,25440,25449,25474,25480,25484,25488,25507,25515,25526,25541,25548,25553,25555,25557,25560,25595,25613,25635,25637,25640,25649,25668,25687,25692,25697,25716,25765,25797,25806,25847,25854,25863,25870,25887,25889,25918,25949,25956,25958,25959,25969,26020,26023,26047,26048,26055,26118,26131,26159,26166,26179,26184,26221,26249,26274,26282,26283,26305,26340,26363,26369,26390,26413,26443,26508,26564,26570,26590,26595,26625,26636,26673,26699,26726,26732,26779,26853,26860,26884,26900,26925,26940,26971,26978,26990,27001,27084,27109,27118,27126,27131,27143,27171,27232,27363,27374,27379,27405,27430,27550,27574,27584,27795,28005,28030,28033,28107,28114,28121,28128,28303,28318,28511,28537,28545,28621,28623,28718,28764,28771,28825,28852,28872,28943,28950,29063,29155,29172,29210,29297,29325,29358,29438,29509,29510,29512,29625,29653,29846,29863,29926,29943,29962,30083,30273,30274,30433,30434,30483,30484,30808,31136,31447,31697,31890,32107,32820,35585,35660,35661,35711,35727,35740,35744,35774,35777,35814,35832,35846,35858,35891,36216,36492,36889,38958,38975,39020,39064,39159,39320,39333,39381,39465,39483,39698,39710,39866,39887,40086,40113,40184,40224,40259,40355,40451,40492,40578,40651,40875,41049,41213,41239,41325,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 | 1616 | 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.81 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.35 ms |
System lock | 0.02 ms |
optimizing | 0.11 ms |
statistics | 2.43 ms |
preparing | 1.28 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.39 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.07 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 |