Tiempo de la consulta: 14.20 ms Después de la última consulta: 1.54 ms Consulta a la memoria: 1.072 MB memoria antes de la consulta: 4.411 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 09:10:42')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 09:10:42')
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,21,30,49,51,60,61,62,63,64,65,67,68,82,117,136,161,162,163,164,183,184,197,202,271,272,278,280,281,328,331,335,337,338,340,342,343,344,345,346,347,348,349,352,353,374,376,377,378,379,380,385,393,394,407,417,456,466,471,476,482,485,570,586,594,608,609,611,613,686,693,697,708,709,710,711,712,713,717,782,783,823,831,844,852,857,868,881,891,896,902,905,911,935,941,964,976,978,988,999,1012,1022,1024,1033,1043,1157,1168,1187,1207,1208,1215,1280,1287,1305,1319,1329,1339,1354,1367,1404,1411,1455,1506,1535,1548,1555,1601,1603,1616,1634,1646,1687,1698,1709,1800,1802,1812,1822,1851,1900,1913,2005,2067,2112,2118,2217,2305,2337,2347,2378,2392,2394,2419,2424,2476,2545,2598,2600,2601,2632,2636,2656,2668,2671,2689,2714,2742,2858,2880,2962,2983,3020,3067,3082,3087,3091,3191,3212,3215,3240,3254,3266,3298,3329,3337,3340,3373,3408,3436,3440,3464,3581,3623,3630,3696,3715,3718,3719,3725,3783,3794,3816,3866,3870,3871,3895,3922,3957,3982,3985,4087,4097,4206,4214,4245,4261,4289,4319,4320,4355,4378,4473,4485,4495,4548,4563,4587,4638,4710,4720,4832,4894,4910,4947,4957,4990,5104,5142,5150,5170,5173,5198,5395,5472,5559,5686,5730,5814,5965,5972,5995,6003,6039,6045,6067,6113,6132,6264,6270,6278,6279,6292,6317,6333,6347,6374,6381,6384,6442,6464,6470,6534,6546,6549,6570,6571,6597,6599,6609,6610,6612,6631,6653,6659,6680,6687,6689,6698,6706,6722,6729,6748,6763,6768,6789,6830,6866,6873,6881,6894,6908,6910,6912,6917,6940,6942,6957,6958,6961,6977,6985,6987,6989,7004,7014,7023,7030,7042,7046,7053,7054,7100,7102,7112,7125,7154,7195,7212,7223,7242,7265,7266,7272,7296,7303,7323,7324,7330,7375,7382,7383,7407,7415,7416,7432,7434,7435,7450,7454,7466,7500,7514,7515,7522,7526,7527,7556,7569,7571,7586,7613,7617,7618,7624,7637,7638,7659,7711,7713,7721,7745,7774,7778,7801,7819,7829,7830,7838,7839,7860,7862,7916,7920,7923,7929,7931,7946,7953,7965,7967,7969,7976,7981,7985,8026,8035,8039,8040,8045,8046,8057,8073,8074,8084,8104,8108,8164,8185,8187,8192,8217,8225,8227,8240,8242,8250,8273,8291,8295,8314,8330,8354,8416,8462,8463,8531,8546,8555,8592,8694,8716,8746,8750,8844,8861,8967,9012,9018,9057,9083,9196,9197,9249,9261,9272,9300,9318,9370,9401,9429,9532,9556,9606,9723,9725,9762,9861,9865,9869,9895,9944,9945,9966,9985,9988,10011,10146,10168,10186,10190,10225,10227,10241,10243,10259,10260,10265,10266,10280,10291,10313,10330,10352,10357,10383,10389,10400,10423,10442,10504,10531,10534,10561,10562,10563,10603,10604,10611,10764,10777,10811,10820,10821,10834,10874,10906,10971,11005,11046,11098,11107,11111,11121,11126,11129,11203,11299,11305,11333,11338,11356,11362,11365,11377,11390,11482,11539,11565,11608,11663,11683,11688,11711,11745,11761,11771,11788,11799,11816,11820,11822,11859,11864,11893,11910,11950,11976,11994,12009,12042,12097,12113,12132,12144,12150,12160,12178,12179,12216,12238,12254,12300,12337,12388,12424,12446,12471,12481,12541,12609,12644,12668,12669,12670,12685,12758,12779,12780,12838,12898,12944,12984,12985,13004,13034,13036,13079,13113,13117,13138,13152,13153,13167,13229,13268,13285,13315,13321,13334,13352,13404,13441,13486,13512,13523,13535,13575,13576,13605,13639,13647,13657,13671,13692,13693,13727,13748,13750,13773,13783,13816,13827,13840,13846,13901,13919,13924,13934,13941,13965,14048,14052,14059,14075,14077,14098,14103,14122,14127,14144,14152,14153,14201,14205,14208,14245,14248,14250,14251,14327,14329,14336,14349,14352,14354,14356,14379,14396,14398,14409,14424,14426,14430,14483,14503,14524,14527,14570,14596,14601,14615,14625,14629,14648,14658,14663,14670,14676,14679,14689,14695,14733,14737,14750,14754,14768,14769,14789,14807,14808,14824,14825,14831,14843,14856,14860,14861,14886,14895,14905,14958,14973,14984,14985,14992,15002,15018,15020,15038,15045,15046,15114,15145,15150,15166,15178,15179,15183,15194,15195,15204,15208,15209,15234,15240,15244,15267,15270,15273,15286,15290,15298,15304,15305,15315,15316,15359,15364,15368,15393,15397,15427,15444,15448,15450,15491,15493,15516,15517,15520,15522,15528,15541,15577,15594,15608,15616,15617,15632,15639,15645,15669,15671,15714,15722,15723,15740,15755,15761,15778,15785,15786,15805,15838,15843,15851,15858,15870,15897,15905,15930,15933,15937,15940,15947,15949,15957,15975,15981,16053,16057,16063,16083,16088,16201,16227,16275,16322,16334,16350,16362,16381,16417,16422,16437,16440,16446,16455,16461,16464,16465,16474,16483,16510,16520,16523,16542,16556,16561,16625,16629,16654,16657,16661,16670,16675,16684,16690,16737,16754,16777,16783,16791,16802,16819,16824,16830,16848,16861,16880,16894,16926,16956,16982,16984,17056,17110,17124,17163,17168,17199,17210,17253,17256,17273,17314,17334,17335,17344,17362,17365,17369,17405,17409,17412,17422,17443,17466,17471,17489,17521,17542,17555,17566,17573,17584,17587,17590,17603,17609,17610,17625,17630,17655,17660,17665,17688,17700,17712,17713,17716,17717,17761,17805,17820,17826,17856,17857,17914,17927,17930,17933,17956,17967,17974,17975,17994,17999,18008,18028,18029,18030,18045,18067,18081,18101,18118,18119,18162,18163,18165,18170,18184,18229,18234,18242,18258,18260,18285,18293,18300,18311,18348,18357,18362,18364,18365,18429,18432,18443,18448,18451,18467,18473,18496,18501,18519,18520,18528,18567,18585,18595,18604,18605,18615,18641,18671,18707,18720,18723,18739,18751,18762,18796,18807,18811,18814,18817,18825,18828,18830,18849,18866,18870,18871,18875,18883,18906,18907,18926,18947,18958,18981,19001,19002,19004,19024,19040,19045,19047,19055,19060,19067,19075,19107,19123,19127,19145,19148,19149,19153,19170,19180,19185,19189,19204,19211,19229,19232,19245,19253,19254,19259,19276,19277,19287,19299,19314,19325,19327,19352,19353,19356,19376,19378,19390,19402,19406,19418,19423,19432,19447,19457,19460,19484,19485,19494,19511,19532,19574,19577,19620,19625,19633,19634,19668,19679,19687,19707,19731,19732,19750,19773,19792,19795,19811,19812,19830,19832,19855,19858,19870,19871,19876,19877,19881,19901,19908,19909,19912,19954,19965,19967,19972,19984,19988,19996,19998,20010,20028,20032,20040,20056,20062,20086,20104,20129,20140,20141,20142,20156,20170,20187,20196,20234,20245,20256,20261,20263,20271,20283,20289,20309,20316,20318,20348,20353,20357,20379,20390,20405,20429,20433,20437,20447,20449,20450,20461,20469,20488,20516,20535,20541,20545,20564,20565,20574,20588,20592,20618,20630,20634,20642,20648,20653,20698,20708,20714,20718,20729,20731,20750,20758,20772,20776,20781,20792,20794,20806,20814,20819,20866,20899,20917,20932,20940,20950,20960,20979,20982,20983,21050,21053,21084,21122,21125,21137,21170,21173,21189,21198,21225,21239,21242,21247,21259,21269,21299,21314,21323,21325,21329,21343,21350,21370,21380,21384,21398,21405,21422,21432,21447,21448,21449,21452,21457,21474,21492,21513,21519,21545,21547,21551,21564,21591,21598,21602,21605,21607,21611,21614,21620,21636,21640,21678,21680,21694,21722,21726,21738,21747,21764,21768,21769,21773,21811,21824,21854,21855,21867,21880,21891,21895,21932,21945,21950,21980,21990,22016,22039,22044,22067,22091,22096,22100,22123,22129,22132,22134,22137,22146,22170,22176,22196,22210,22215,22218,22229,22255,22256,22262,22267,22268,22276,22297,22306,22320,22333,22337,22349,22361,22363,22382,22436,22453,22465,22466,22480,22481,22484,22492,22494,22501,22519,22529,22559,22562,22579,22581,22588,22605,22647,22673,22693,22709,22712,22734,22739,22751,22774,22781,22785,22820,22839,22866,22869,22872,22886,22903,22908,22911,22915,22930,22950,22964,22980,22988,23009,23014,23029,23033,23036,23037,23055,23072,23087,23099,23103,23104,23112,23119,23123,23137,23147,23156,23184,23186,23212,23229,23232,23239,23252,23270,23275,23276,23279,23281,23287,23295,23308,23326,23328,23347,23364,23367,23368,23374,23381,23401,23402,23444,23484,23495,23519,23536,23555,23568,23577,23585,23597,23610,23611,23621,23623,23626,23636,23638,23642,23662,23665,23682,23691,23693,23709,23716,23719,23732,23764,23768,23795,23840,23845,23846,23849,23858,23874,23877,23878,23885,23887,23888,23891,23897,23902,23905,23920,23921,23925,23944,23949,23964,23970,23971,24001,24009,24015,24024,24028,24059,24060,24077,24110,24115,24132,24159,24163,24164,24187,24194,24195,24196,24225,24239,24270,24296,24306,24316,24329,24335,24337,24342,24362,24373,24418,24422,24428,24430,24451,24453,24471,24487,24489,24506,24512,24521,24540,24556,24568,24575,24581,24586,24617,24634,24635,24639,24645,24653,24656,24677,24691,24707,24718,24724,24726,24737,24781,24785,24791,24793,24794,24804,24813,24816,24825,24871,24884,24897,24899,24931,24983,25032,25036,25043,25045,25065,25068,25105,25136,25178,25184,25200,25201,25212,25225,25246,25254,25264,25282,25287,25291,25315,25327,25332,25341,25359,25367,25377,25384,25386,25408,25416,25440,25450,25484,25515,25526,25548,25555,25560,25585,25590,25621,25622,25640,25681,25687,25692,25697,25702,25723,25726,25757,25765,25775,25806,25818,25836,25843,25850,25854,25869,25872,25887,25889,25906,25927,25928,25959,26000,26023,26055,26066,26112,26113,26129,26175,26177,26274,26296,26315,26340,26372,26386,26390,26413,26435,26565,26576,26595,26620,26639,26640,26646,26684,26691,26708,26807,26820,26845,26853,26935,27001,27060,27065,27086,27108,27141,27143,27212,27216,27282,27323,27347,27359,27367,27374,27379,27404,27408,27423,27541,27560,27583,27584,27592,27595,27601,27656,27671,27703,27717,27758,27795,28000,28031,28059,28066,28075,28094,28097,28114,28120,28129,28162,28168,28192,28230,28243,28336,28435,28454,28495,28511,28537,28623,28673,28852,28882,28979,29011,29045,29266,29325,29412,29454,29613,29639,29698,29769,29802,29866,29962,30274,30740,31129,31604,31608,31939,32084,32820,32905,33749,33925,33931,33946,33957,34025,34275,34331,34616,34646,34693,34811,34815,35000,35220,35227,35238,35239,35289,35333,35351,35376,35397,35426,35444,35490,35554,35556,35603,35621,35688,35711,35740,35774,35805,35858,35882,35948,36000,36015,36216,36220,36237,36368,36369,36373,36385,36418,36420,36441,36492,36584,36930,36989,36998,37010,37136,37147,37283,37307,37308,37378,37534,37567,37626,37644,38058,38126,38133,38330,38433,38489,38546,38824,38877,38904,38922,38949,38958,38975,39020,39064,39159,39205,39290,39296,39476,39497,39587,39610,39717,40184,40319,40509,40560,40647,41062,41325,41332,41345,41516,41781,41969,42054,42637,42987,43016,43109,43165,43237,43271,43405,43446,43461,43483,43712,44062,44366,44573,44718,44788,44807,44829,44873,44912,44935,44936,44988,45101,45138,45235,45263,45264,45316)
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 | 1806 | 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.79 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.32 ms |
System lock | 0.02 ms |
optimizing | 0.17 ms |
statistics | 3.27 ms |
preparing | 1.36 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 7.33 ms |
end | 0.03 ms |
query end | 0.04 ms |
closing tables | 0.10 ms |
freeing items | 0.27 ms |
cleaning up | 0.06 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 |