Tiempo de la consulta: 22.27 ms Después de la última consulta: 1.72 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 4.571 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 23:10:21')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 23:10:21')
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,13,25,30,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,81,82,87,88,89,110,111,117,125,136,165,175,180,183,184,188,189,190,197,200,202,205,206,222,225,234,246,247,248,249,250,263,269,271,272,275,280,308,311,323,324,325,327,328,329,332,333,334,344,350,353,362,370,374,376,377,378,379,380,385,387,388,390,392,393,395,397,398,400,402,403,404,405,407,408,410,411,412,415,416,420,421,422,423,424,426,427,429,430,431,433,435,436,437,438,442,443,445,448,451,454,455,456,484,496,501,503,531,538,574,575,589,593,608,611,686,693,701,715,760,764,785,817,831,844,853,856,862,868,891,902,935,941,964,976,986,1033,1034,1043,1167,1207,1215,1223,1280,1287,1290,1329,1339,1353,1354,1357,1358,1434,1455,1491,1497,1535,1601,1603,1634,1637,1646,1698,1709,1713,1718,1766,1788,1800,1802,1822,1878,1900,1913,1949,1962,1982,2108,2162,2200,2208,2217,2228,2239,2272,2305,2337,2353,2378,2424,2569,2598,2600,2601,2613,2632,2636,2637,2656,2663,2668,2689,2714,2732,2742,2805,2825,2946,2951,3000,3020,3051,3067,3075,3079,3087,3091,3212,3215,3216,3325,3329,3337,3340,3373,3381,3408,3425,3563,3592,3650,3682,3684,3718,3719,3725,3783,3816,3868,3870,3871,3895,3932,3957,4033,4061,4063,4087,4131,4206,4249,4310,4319,4320,4378,4383,4410,4473,4493,4638,4641,4667,4674,4688,4765,4770,4790,4808,4832,4902,4905,4910,4947,4957,4990,5060,5086,5104,5150,5170,5173,5189,5237,5268,5301,5324,5381,5392,5476,5538,5559,5685,5686,5730,5798,5814,5833,5895,6039,6139,6251,6264,6268,6270,6292,6311,6315,6333,6384,6392,6393,6464,6475,6482,6532,6571,6616,6618,6631,6666,6671,6687,6710,6776,6783,6824,6830,6836,6868,6889,6908,6910,6913,6917,6940,6942,6957,6961,6985,6989,7017,7050,7056,7107,7109,7124,7138,7154,7156,7194,7205,7210,7287,7303,7330,7358,7369,7396,7405,7416,7421,7434,7446,7450,7454,7482,7522,7526,7556,7569,7591,7596,7597,7624,7638,7659,7692,7696,7713,7716,7722,7730,7739,7745,7774,7782,7801,7811,7813,7829,7862,7866,7913,7916,7923,7933,7965,7966,7967,7970,7985,7993,7999,8022,8026,8027,8039,8057,8108,8215,8293,8326,8330,8333,8354,8405,8406,8416,8438,8444,8462,8509,8550,8551,8565,8589,8602,8610,8613,8638,8654,8685,8692,8694,8714,8760,8819,8835,8856,8864,8887,8908,8910,8972,9012,9018,9057,9093,9098,9196,9197,9199,9206,9249,9262,9282,9300,9318,9330,9332,9370,9411,9416,9428,9429,9472,9481,9529,9650,9677,9678,9723,9725,9757,9860,9861,9865,9869,9924,9934,9958,9966,9985,10008,10011,10035,10186,10227,10259,10265,10274,10313,10352,10357,10400,10484,10522,10534,10603,10604,10611,10727,10764,10777,10811,10820,10821,10971,11005,11062,11091,11098,11106,11107,11114,11121,11195,11208,11305,11333,11345,11356,11362,11365,11369,11471,11539,11597,11627,11651,11663,11697,11722,11742,11747,11799,11816,11820,11857,11859,11864,11893,11950,11976,11994,12009,12017,12020,12024,12113,12144,12178,12179,12216,12254,12324,12330,12388,12446,12460,12482,12541,12575,12592,12609,12620,12624,12625,12650,12669,12670,12685,12686,12708,12750,12758,12838,12898,12913,12973,12985,12996,13004,13014,13016,13036,13079,13152,13229,13268,13279,13285,13294,13321,13328,13334,13348,13352,13423,13474,13475,13501,13535,13560,13575,13576,13647,13678,13685,13693,13725,13727,13748,13750,13768,13778,13782,13783,13801,13846,13900,13901,13924,13941,13971,13973,14010,14052,14061,14093,14098,14105,14122,14128,14149,14152,14183,14205,14226,14229,14248,14250,14290,14293,14308,14323,14327,14336,14352,14354,14356,14362,14389,14396,14424,14426,14430,14431,14432,14449,14451,14477,14516,14524,14534,14536,14554,14596,14625,14629,14636,14648,14663,14676,14679,14687,14695,14713,14733,14739,14754,14758,14769,14789,14843,14846,14856,14860,14862,14892,14895,14905,14906,14973,14984,14996,15013,15018,15020,15038,15043,15045,15046,15059,15114,15166,15179,15208,15209,15234,15245,15246,15261,15262,15286,15289,15293,15298,15304,15310,15315,15316,15382,15392,15414,15444,15475,15476,15500,15517,15520,15528,15533,15540,15574,15594,15596,15608,15616,15650,15674,15681,15714,15723,15751,15753,15755,15778,15796,15805,15808,15832,15833,15849,15851,15861,15870,15897,15901,15937,15945,15947,15972,16011,16014,16053,16055,16057,16062,16071,16088,16104,16115,16122,16161,16176,16242,16362,16381,16417,16422,16440,16444,16455,16465,16468,16474,16497,16523,16526,16542,16543,16548,16550,16566,16640,16654,16657,16670,16675,16706,16718,16728,16737,16751,16760,16783,16802,16833,16876,16880,16894,16903,16908,16909,16936,16950,16976,16982,17014,17027,17072,17114,17131,17133,17136,17137,17142,17163,17199,17217,17251,17256,17303,17309,17334,17335,17344,17365,17369,17409,17412,17419,17422,17424,17427,17496,17500,17528,17532,17542,17543,17566,17573,17584,17590,17597,17603,17607,17608,17609,17625,17629,17635,17645,17660,17688,17690,17700,17702,17712,17717,17721,17746,17786,17820,17824,17826,17857,17862,17902,17910,17914,17918,17926,17927,17930,17933,17956,17967,17976,17977,18028,18029,18067,18071,18072,18073,18099,18118,18130,18150,18157,18160,18165,18170,18172,18220,18227,18260,18286,18300,18309,18360,18362,18429,18473,18548,18558,18578,18595,18605,18619,18628,18707,18720,18757,18799,18811,18819,18825,18830,18849,18871,18905,18906,18907,18926,18958,18974,19001,19024,19032,19048,19049,19055,19077,19118,19123,19127,19145,19153,19204,19211,19232,19235,19254,19259,19277,19282,19291,19299,19313,19325,19353,19381,19423,19426,19432,19460,19484,19487,19551,19562,19574,19592,19604,19608,19650,19655,19661,19668,19679,19695,19703,19706,19720,19723,19733,19750,19772,19773,19796,19806,19825,19830,19855,19858,19871,19872,19876,19877,19881,19886,19901,19923,19931,19937,19965,19967,19972,19980,19984,19988,19996,20014,20026,20060,20066,20068,20076,20086,20090,20094,20095,20117,20144,20192,20193,20213,20271,20308,20309,20312,20338,20390,20396,20405,20433,20434,20437,20439,20447,20450,20459,20468,20469,20488,20521,20545,20559,20565,20567,20574,20588,20592,20595,20604,20612,20616,20618,20638,20642,20648,20672,20688,20698,20699,20700,20708,20718,20727,20750,20751,20772,20781,20792,20794,20795,20806,20814,20833,20834,20847,20940,20953,20960,20979,20990,21016,21021,21038,21040,21053,21087,21122,21149,21156,21159,21170,21198,21247,21256,21259,21271,21274,21279,21283,21285,21288,21300,21325,21329,21332,21338,21350,21368,21370,21380,21385,21398,21405,21448,21449,21464,21485,21486,21487,21524,21526,21529,21547,21551,21565,21591,21598,21602,21607,21608,21614,21618,21623,21640,21650,21661,21664,21665,21670,21674,21680,21690,21695,21704,21719,21722,21726,21727,21747,21769,21773,21775,21800,21811,21812,21819,21824,21843,21850,21863,21867,21891,21895,21910,21932,21934,21954,21955,21957,21990,21995,22011,22015,22018,22039,22044,22062,22067,22077,22096,22117,22129,22132,22133,22134,22135,22137,22156,22163,22164,22170,22191,22195,22196,22215,22241,22253,22255,22262,22267,22276,22286,22287,22294,22302,22320,22324,22349,22363,22381,22382,22406,22411,22421,22436,22446,22453,22465,22466,22476,22481,22484,22490,22494,22501,22512,22517,22534,22579,22580,22581,22588,22603,22620,22622,22626,22655,22658,22659,22693,22709,22710,22727,22739,22751,22765,22780,22781,22787,22804,22820,22829,22833,22851,22854,22866,22869,22871,22886,22897,22899,22914,22915,22923,22925,22930,22947,22959,22964,22972,23007,23009,23019,23024,23029,23036,23037,23043,23062,23072,23082,23083,23087,23089,23099,23103,23104,23110,23112,23119,23123,23124,23137,23156,23179,23184,23213,23214,23229,23232,23252,23260,23269,23270,23279,23287,23308,23309,23319,23328,23332,23364,23365,23367,23368,23381,23398,23401,23430,23444,23480,23484,23505,23528,23555,23557,23577,23621,23623,23642,23665,23671,23682,23685,23691,23693,23704,23709,23716,23718,23719,23768,23786,23846,23849,23850,23860,23885,23888,23891,23897,23902,23905,23907,23920,23921,23927,23944,23949,23964,24009,24015,24016,24024,24028,24029,24060,24067,24077,24110,24115,24159,24163,24164,24172,24196,24225,24226,24239,24249,24270,24296,24306,24315,24316,24335,24337,24350,24362,24365,24393,24408,24422,24430,24438,24453,24475,24485,24506,24511,24522,24556,24575,24582,24635,24656,24677,24704,24707,24724,24726,24781,24785,24793,24794,24803,24816,24834,24854,24871,24922,24931,24937,24956,24983,24993,25030,25032,25033,25035,25036,25038,25043,25062,25068,25117,25131,25134,25136,25138,25171,25200,25201,25254,25282,25287,25291,25314,25316,25318,25327,25332,25351,25367,25377,25384,25386,25406,25408,25416,25436,25440,25448,25450,25484,25515,25526,25542,25548,25555,25560,25584,25621,25622,25640,25646,25648,25660,25673,25687,25692,25697,25717,25723,25757,25765,25806,25818,25836,25854,25855,25881,25887,25889,25904,25916,25927,25928,25930,25959,25989,26000,26001,26002,26023,26033,26043,26055,26066,26087,26113,26124,26147,26153,26154,26156,26165,26211,26215,26221,26262,26274,26288,26296,26317,26335,26340,26343,26360,26372,26376,26377,26386,26388,26390,26405,26408,26413,26415,26424,26454,26464,26474,26536,26565,26576,26587,26595,26620,26627,26630,26639,26646,26651,26658,26664,26677,26691,26699,26713,26742,26757,26784,26801,26820,26845,26853,26879,26881,26885,26897,26905,26907,26915,26935,26941,26944,26955,26973,27000,27001,27029,27030,27038,27065,27143,27204,27212,27216,27323,27327,27343,27347,27366,27367,27374,27379,27408,27423,27492,27518,27530,27541,27552,27568,27570,27581,27582,27583,27584,27591,27592,27595,27601,27671,27688,27717,27722,27724,27758,27786,27795,27846,27982,28031,28059,28066,28072,28075,28080,28094,28097,28114,28120,28129,28162,28168,28192,28230,28243,28329,28339,28435,28440,28442,28511,28537,28568,28569,28582,28614,28615,28616,28623,28673,28712,28714,28728,28845,28852,28889,28944,29011,29045,29054,29266,29325,29460,29635,29639,29769,29866,29962,30274,30293,31113,31560,31608,31937,32084,32820,33157,33405,33417,33584,33925,33946,33957,34025,34222,34239,34249,34258,34273,34275,34331,34428,34616,34646,34693,34731,34775,34811,34815,35000,35115,35220,35227,35238,35239,35289,35330,35333,35345,35376,35397,35426,35435,35444,35490,35554,35556,35596,35621,35684,35688,35711,35713,35740,35744,35774,35805,35806,35808,35858,35866,35882,35926,35948,35955,36000,36011,36015,36104,36160,36216,36220,36237,36262,36331,36333,36335,36368,36369,36373,36375,36385,36420,36441,36452,36492,36554,36584,36851,36909,36930,36933,36960,36989,36998,37010,37104,37136,37147,37192,37283,37307,37308,37378,37383,37534,37626,37635,37644,37669,37670,37671,37672,37675,37676,37687,37692,37724,37902,37942,38019,38058,38107,38126,38133,38330,38356,38403,38433,38443,38456,38489,38546,38824,38877,38887,38904,38922,38949,38958,38975,39020,39064,39155,39159,39170,39196,39205,39271,39286,39290,39295,39296,39334,39342,39392,39398,39442,39476,39497,39522,39527,39530,39550,39587,39610,39624,39635,39699,39717,39871,39891,40015,40036,40116,40184,40276,40319,40445,40446,40492,40509,40560,40588,40605,40647,40672,40859,41007,41062,41198,41305,41325,41332,41345,41349,41493,41516,41532,41612,41781,41794,41969,42312,42389,42536,42540,42637,42946,42987,43016,43109,43165,43207,43237,43271,43284,43405,43446,43450,43461,43465,43483,43572,43578,43633,43660,43667,43694,43695,43696,43712,43948,44062,44277,44366,44459,44475,44476,44573,44583,44718,44785,44788,44807,44829,44870,44873,44912,44935,44936,44988,45006,45008,45101,45138,45145,45235,45247,45263,45264,45265,45288,45289,45291,45294,45300,45301,45304,45305,45307,45312,45313,45316,45317)
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 | 1979 | 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 | 3.06 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.11 ms |
init | 0.65 ms |
System lock | 0.02 ms |
optimizing | 0.30 ms |
statistics | 11.65 ms |
preparing | 3.73 ms |
Sorting result | 0.03 ms |
executing | 0.01 ms |
Sending data | 1.89 ms |
end | 0.09 ms |
query end | 0.07 ms |
closing tables | 0.02 ms |
freeing items | 0.10 ms |
cleaning up | 0.04 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 |