Tiempo de la consulta: 6.17 ms Después de la última consulta: 1.54 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 4.413 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-06 07:50:41')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 07:50:41')
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(1,11,17,49,60,61,62,63,64,65,67,68,71,83,90,92,96,97,98,99,102,104,107,117,136,198,199,202,204,209,210,217,226,228,232,234,238,240,242,243,255,265,271,272,276,278,280,281,325,331,344,350,353,374,376,377,378,379,380,385,417,419,428,456,458,466,485,487,512,523,529,531,537,542,547,560,566,567,586,605,607,608,611,637,686,697,717,756,760,806,831,844,850,857,868,886,891,904,933,941,948,964,966,976,977,978,986,1024,1031,1033,1043,1067,1168,1187,1207,1208,1209,1215,1223,1226,1265,1277,1287,1305,1319,1329,1339,1347,1506,1600,1601,1664,1709,1768,1825,1829,1845,1851,1879,1957,2005,2019,2112,2145,2156,2320,2394,2656,2714,2729,2733,2742,2822,2962,3020,3058,3091,3215,3329,3340,3409,3520,3696,3783,3816,3870,3884,3895,3898,3940,3957,3982,3993,4063,4087,4116,4153,4206,4309,4319,4378,4409,4410,4436,4445,4453,4471,4563,4587,4638,4692,4784,4808,4902,5001,5085,5125,5269,5323,5371,5515,5622,5647,5649,5685,5726,5727,5730,5814,5847,5894,6264,6292,6333,6360,6381,6384,6386,6448,6464,6470,6518,6570,6598,6631,6681,6687,6748,6752,6760,6775,6806,6809,6828,6839,6847,6881,6908,6915,6916,6940,6941,6942,6957,6961,6984,6989,6994,7017,7105,7125,7154,7173,7212,7243,7276,7296,7303,7407,7418,7432,7434,7450,7454,7462,7516,7522,7556,7624,7638,7713,7730,7772,7774,7801,7829,7838,7839,7840,7860,7862,7916,7923,7928,7931,7946,7958,7965,7967,7981,7985,8027,8053,8056,8061,8062,8070,8106,8108,8320,8351,8354,8445,8531,8555,8610,8663,8694,8844,8864,9003,9057,9249,9253,9318,9429,9473,9531,9532,9556,9580,9650,9723,9724,9725,9772,9861,9895,9924,9944,9945,9966,9985,10011,10024,10031,10050,10063,10077,10079,10100,10197,10198,10227,10243,10259,10265,10266,10280,10290,10303,10313,10323,10350,10357,10383,10436,10486,10499,10518,10534,10557,10561,10611,10673,10690,10731,10777,10806,10820,10821,10831,10834,10889,10956,10971,11005,11087,11129,11163,11182,11273,11299,11333,11362,11365,11377,11447,11482,11494,11539,11542,11565,11663,11688,11692,11711,11799,11816,11822,11840,11880,11893,11911,11946,11950,11976,12009,12042,12095,12150,12177,12178,12179,12216,12238,12337,12338,12363,12366,12388,12412,12424,12446,12490,12668,12670,12679,12685,12745,12757,12758,12780,12810,12838,12887,12898,12913,12920,12944,12965,12973,12977,12983,12985,13004,13010,13036,13062,13079,13152,13153,13229,13231,13235,13276,13285,13287,13321,13334,13398,13405,13471,13473,13647,13651,13657,13681,13748,13750,13783,13800,13816,13868,13901,13924,13934,13969,13985,14011,14029,14034,14069,14098,14103,14109,14139,14152,14153,14156,14203,14205,14218,14224,14227,14232,14248,14250,14252,14263,14293,14336,14352,14354,14356,14396,14424,14426,14557,14570,14581,14591,14596,14610,14625,14629,14676,14695,14701,14754,14774,14778,14789,14843,14856,14895,14926,14958,14979,14984,14987,15018,15021,15038,15039,15065,15110,15114,15144,15145,15179,15183,15188,15198,15244,15256,15262,15286,15297,15298,15304,15315,15316,15347,15359,15366,15368,15418,15421,15441,15444,15445,15455,15470,15473,15482,15493,15495,15511,15517,15520,15522,15550,15573,15577,15608,15616,15630,15632,15640,15645,15667,15669,15714,15723,15755,15759,15760,15766,15778,15784,15805,15835,15843,15877,15892,15897,15957,15975,16014,16053,16054,16083,16088,16125,16165,16187,16201,16213,16263,16277,16322,16334,16352,16359,16362,16365,16381,16410,16417,16446,16464,16470,16474,16488,16520,16523,16532,16542,16554,16556,16558,16607,16629,16635,16642,16657,16670,16675,16684,16691,16698,16720,16783,16791,16812,16815,16826,16830,16831,16843,16861,16894,16964,16982,16983,17001,17043,17045,17059,17063,17142,17149,17154,17163,17189,17210,17236,17253,17256,17275,17280,17317,17334,17341,17354,17362,17364,17365,17381,17403,17409,17417,17422,17443,17453,17463,17471,17500,17506,17520,17521,17542,17566,17573,17596,17597,17611,17617,17619,17625,17630,17650,17655,17660,17688,17689,17710,17712,17713,17717,17729,17753,17761,17772,17784,17820,17862,17907,17914,17930,17933,17949,17954,17965,17967,17990,17994,18001,18052,18106,18118,18124,18133,18158,18162,18176,18181,18213,18217,18229,18260,18263,18285,18300,18311,18336,18337,18352,18361,18362,18364,18426,18427,18429,18455,18458,18465,18467,18485,18509,18520,18527,18538,18547,18565,18567,18576,18581,18586,18588,18591,18605,18648,18671,18675,18707,18716,18720,18726,18753,18762,18801,18808,18809,18811,18828,18830,18845,18846,18849,18852,18871,18898,18956,18957,18958,18986,18997,18999,19001,19002,19024,19040,19047,19055,19057,19060,19063,19067,19098,19120,19134,19145,19148,19150,19170,19180,19185,19217,19245,19251,19252,19253,19254,19259,19263,19270,19276,19277,19303,19312,19313,19325,19327,19331,19352,19353,19358,19369,19376,19377,19383,19402,19413,19419,19433,19437,19440,19453,19454,19457,19460,19483,19484,19494,19504,19522,19527,19532,19551,19552,19556,19566,19574,19577,19582,19593,19604,19620,19625,19633,19651,19668,19676,19679,19687,19720,19722,19730,19732,19763,19766,19772,19773,19779,19791,19811,19816,19830,19837,19855,19864,19870,19871,19877,19881,19901,19908,19909,19939,19943,19955,19963,19965,19972,19984,19987,19996,19998,19999,20004,20007,20010,20028,20032,20039,20042,20056,20076,20083,20086,20092,20122,20141,20146,20156,20167,20170,20183,20187,20199,20216,20229,20234,20236,20256,20263,20269,20271,20279,20289,20296,20301,20332,20343,20352,20353,20362,20386,20390,20405,20408,20422,20427,20433,20434,20437,20447,20449,20450,20479,20488,20492,20497,20516,20526,20528,20535,20539,20545,20564,20573,20574,20588,20592,20605,20617,20630,20670,20688,20691,20698,20708,20714,20718,20724,20729,20753,20765,20769,20772,20774,20776,20781,20792,20794,20795,20799,20804,20814,20817,20826,20835,20866,20881,20894,20907,20915,20940,20944,20950,20960,20964,20979,20982,20984,21002,21017,21050,21080,21105,21122,21152,21170,21173,21182,21184,21189,21198,21225,21242,21247,21259,21293,21300,21314,21325,21350,21366,21370,21380,21398,21404,21415,21422,21432,21448,21449,21452,21454,21465,21513,21518,21545,21551,21591,21606,21607,21611,21620,21631,21636,21640,21662,21678,21679,21680,21694,21738,21764,21766,21767,21768,21775,21849,21854,21867,21891,21895,21950,21958,21960,21980,21990,22032,22039,22044,22067,22085,22089,22096,22100,22126,22132,22137,22146,22156,22162,22170,22172,22189,22215,22225,22229,22239,22248,22253,22255,22267,22268,22276,22297,22320,22337,22339,22344,22349,22350,22361,22363,22366,22378,22382,22395,22409,22419,22431,22436,22465,22466,22481,22499,22501,22530,22544,22547,22559,22564,22579,22588,22607,22611,22647,22666,22673,22693,22694,22695,22709,22712,22726,22740,22751,22753,22766,22774,22781,22793,22814,22820,22865,22866,22871,22875,22903,22906,22908,22915,22921,22930,22933,22934,22935,22958,22973,22976,22980,22988,23002,23003,23006,23009,23010,23017,23029,23036,23050,23072,23074,23080,23087,23096,23099,23103,23104,23112,23119,23126,23137,23151,23156,23184,23186,23203,23218,23230,23232,23235,23252,23254,23264,23268,23270,23271,23275,23279,23281,23292,23295,23304,23308,23343,23354,23367,23368,23371,23374,23380,23381,23391,23396,23401,23402,23403,23417,23444,23445,23455,23460,23466,23475,23477,23483,23484,23495,23512,23523,23554,23555,23577,23585,23604,23610,23619,23621,23623,23632,23636,23642,23651,23659,23665,23666,23677,23682,23691,23693,23709,23716,23719,23732,23740,23761,23764,23768,23782,23792,23805,23806,23813,23816,23827,23840,23845,23846,23849,23854,23858,23869,23874,23893,23897,23901,23902,23905,23909,23914,23920,23944,23947,23949,23964,23965,23986,23998,24000,24001,24007,24009,24015,24024,24028,24059,24060,24092,24110,24115,24159,24160,24164,24171,24194,24196,24197,24209,24212,24226,24238,24239,24260,24270,24294,24296,24299,24303,24306,24335,24339,24342,24352,24361,24362,24373,24376,24422,24429,24430,24451,24453,24470,24489,24496,24503,24506,24526,24540,24543,24556,24575,24585,24586,24598,24608,24615,24617,24635,24639,24653,24656,24659,24663,24672,24677,24678,24679,24707,24711,24718,24724,24726,24741,24754,24764,24772,24780,24782,24790,24791,24794,24804,24816,24851,24857,24861,24884,24897,24905,24918,24927,24931,24934,24942,24960,24984,24992,24995,25005,25036,25043,25045,25062,25079,25089,25090,25104,25119,25136,25141,25143,25151,25184,25199,25200,25207,25232,25244,25252,25260,25264,25282,25287,25291,25303,25315,25327,25332,25345,25353,25366,25367,25368,25375,25384,25386,25401,25408,25416,25432,25435,25440,25480,25484,25486,25502,25507,25515,25526,25548,25555,25560,25595,25613,25615,25616,25637,25640,25649,25650,25687,25692,25697,25702,25716,25765,25775,25778,25806,25854,25863,25872,25886,25887,25889,25906,25918,25949,25956,25959,26023,26047,26055,26103,26118,26131,26184,26221,26238,26274,26283,26293,26315,26324,26338,26340,26389,26390,26413,26431,26443,26479,26513,26589,26595,26605,26625,26640,26654,26673,26699,26708,26732,26776,26792,26807,26853,26857,26884,26900,26925,26939,26940,26971,26978,26990,27001,27008,27015,27020,27024,27055,27076,27086,27093,27109,27118,27126,27141,27143,27149,27171,27232,27248,27356,27374,27379,27405,27420,27430,27438,27453,27477,27550,27560,27566,27572,27584,27720,27795,27822,27991,28030,28121,28316,28336,28454,28495,28511,28537,28623,28718,28825,28852,28882,28910,28922,29023,29063,29123,29155,29297,29325,29412,29454,29466,29499,29584,29802,29834,29909,29926,29943,29962,30083,30111,30273,30274,30483,30484,30740,30808,31129,31136,31447,31604,32107,32136,32820,32905,33932,35000,35585,35603,35711,35730,35740,35741,35744,35774,35803,35832,35846,35858,35921,35989,36017,36041,36216,36235,36492,36633,36958,38800,38852,38916,38958,38975,38985,39020,39064,39159,39178,39318,39320,39369,39381,39653,39858,39887,39941,39998,40050,40064,40086,40113,40184,40214,40451,40492,40578,40706,41049,41213,41325,41337,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 | 1676 | 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.78 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.30 ms |
System lock | 0.02 ms |
optimizing | 0.11 ms |
statistics | 2.49 ms |
preparing | 1.27 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.34 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 |