Tiempo de la consulta: 9.11 ms Después de la última consulta: 1.56 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.638 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-05 09:22:46')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 09:22:46')
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,2,3,4,5,6,7,8,9,11,16,17,25,28,29,49,56,60,71,72,75,83,86,119,164,165,185,203,204,256,263,271,272,275,276,283,295,296,301,302,307,323,325,344,353,371,373,389,400,403,429,458,463,472,485,495,512,529,531,537,542,547,549,560,566,567,581,583,607,611,613,657,686,689,722,723,756,757,758,760,806,808,816,832,850,863,868,873,883,886,895,900,903,906,916,917,933,937,940,958,963,970,974,977,983,984,986,1015,1031,1046,1053,1056,1080,1101,1102,1121,1140,1175,1207,1216,1226,1233,1235,1238,1250,1264,1265,1271,1277,1304,1308,1335,1337,1347,1436,1458,1459,1469,1486,1504,1533,1562,1600,1636,1648,1658,1664,1684,1698,1718,1735,1745,1768,1843,1849,1887,1917,1946,1975,2013,2016,2069,2101,2107,2254,2266,2290,2293,2305,2322,2342,2365,2489,2517,2548,2566,2596,2605,2639,2674,2693,2713,2732,2733,2780,2796,2804,2827,2857,2863,2967,3001,3008,3055,3065,3069,3095,3103,3106,3107,3147,3154,3183,3208,3303,3312,3329,3343,3346,3353,3364,3409,3447,3463,3493,3512,3520,3531,3552,3562,3569,3597,3603,3604,3634,3732,3750,3754,3786,3884,3898,3940,3976,3980,3983,3986,3993,4063,4116,4153,4247,4309,4409,4410,4436,4445,4453,4471,4492,4515,4549,4563,4580,4692,4848,4878,4902,4973,5001,5018,5079,5084,5085,5093,5095,5123,5150,5247,5279,5350,5365,5386,5451,5491,5512,5513,5515,5559,5647,5675,5730,5798,5827,5894,5896,6062,6102,6127,6141,6173,6301,6311,6313,6315,6330,6354,6363,6369,6372,6393,6400,6405,6448,6470,6473,6475,6520,6542,6543,6573,6593,6598,6616,6630,6656,6681,6688,6723,6724,6742,6744,6751,6752,6762,6775,6804,6806,6807,6808,6809,6828,6835,6840,6860,6889,6895,6906,6916,6936,6941,6945,6964,6985,6994,6997,7015,7018,7026,7093,7096,7105,7173,7193,7201,7212,7232,7243,7248,7249,7276,7343,7379,7405,7407,7418,7458,7462,7483,7488,7516,7545,7569,7583,7584,7586,7588,7616,7625,7630,7691,7718,7730,7749,7758,7806,7829,7832,7840,7891,7917,7934,7950,7959,7960,7965,7997,7998,8015,8019,8027,8053,8088,8106,8109,8114,8115,8143,8206,8351,8422,8445,8499,8508,8610,8663,8740,8759,8802,8864,8907,8909,8937,9010,9048,9056,9057,9082,9152,9200,9253,9314,9351,9398,9473,9527,9531,9532,9574,9580,9658,9721,9745,9764,9772,9825,9860,9864,10024,10050,10059,10077,10079,10110,10120,10176,10188,10195,10197,10198,10203,10239,10247,10250,10266,10273,10289,10290,10298,10303,10304,10306,10311,10350,10351,10369,10379,10462,10479,10486,10499,10518,10557,10686,10690,10697,10713,10731,10757,10759,10769,10806,10831,10872,10886,10912,10925,10951,10954,10971,10973,10974,11008,11015,11022,11035,11063,11076,11083,11087,11146,11150,11173,11182,11195,11226,11230,11269,11273,11318,11366,11391,11394,11410,11424,11438,11447,11479,11494,11534,11542,11611,11692,11712,11719,11730,11766,11826,11836,11840,11854,11880,11883,11987,12029,12076,12193,12212,12216,12218,12306,12338,12363,12366,12388,12393,12445,12449,12490,12519,12545,12548,12567,12576,12624,12625,12670,12684,12685,12697,12745,12750,12757,12758,12761,12789,12810,12852,12871,12894,12902,12920,12940,12945,12959,12965,12977,12978,12983,13029,13036,13038,13115,13129,13166,13188,13218,13225,13235,13241,13287,13421,13433,13463,13508,13511,13524,13530,13548,13550,13573,13611,13613,13641,13651,13671,13712,13731,13734,13763,13770,13792,13808,13821,13851,13855,13869,13926,13950,13968,13972,13985,13994,13998,14005,14011,14048,14053,14054,14069,14070,14081,14097,14101,14109,14114,14139,14148,14159,14183,14188,14197,14204,14205,14227,14229,14232,14236,14249,14252,14270,14305,14331,14336,14341,14354,14361,14382,14428,14482,14495,14507,14522,14557,14591,14596,14610,14665,14675,14684,14701,14711,14746,14769,14774,14778,14807,14811,14820,14841,14846,14850,14856,14895,14911,14926,14931,14945,14949,14979,14981,14990,14993,15003,15018,15038,15049,15065,15069,15100,15114,15144,15212,15213,15217,15248,15249,15256,15293,15297,15304,15310,15441,15445,15455,15475,15496,15499,15518,15522,15543,15551,15561,15606,15640,15667,15689,15719,15728,15757,15760,15766,15866,15877,15880,15892,15893,15897,15903,15913,15926,15953,16014,16023,16053,16054,16086,16087,16091,16125,16163,16164,16178,16187,16194,16209,16218,16258,16264,16277,16321,16325,16334,16358,16359,16366,16410,16415,16431,16432,16450,16451,16470,16521,16538,16554,16558,16560,16603,16604,16607,16623,16635,16642,16645,16664,16685,16691,16698,16713,16733,16734,16748,16775,16808,16815,16831,16843,16844,16964,16996,17001,17004,17043,17050,17059,17060,17069,17086,17090,17100,17115,17132,17134,17138,17146,17149,17157,17189,17197,17227,17228,17242,17280,17285,17309,17339,17341,17354,17364,17381,17403,17407,17417,17456,17459,17463,17470,17500,17510,17518,17537,17551,17559,17596,17597,17601,17617,17630,17633,17634,17650,17689,17715,17723,17729,17753,17763,17766,17772,17775,17776,17783,17784,17810,17826,17835,17839,17846,17852,17870,17880,17883,17907,17925,17931,17938,17950,17954,17988,17990,18000,18001,18032,18043,18046,18047,18112,18113,18121,18129,18142,18158,18176,18217,18263,18276,18294,18295,18304,18311,18326,18337,18352,18358,18361,18364,18375,18389,18390,18395,18409,18427,18431,18434,18455,18485,18494,18505,18520,18521,18524,18527,18547,18565,18576,18581,18583,18586,18591,18612,18617,18629,18648,18668,18670,18682,18697,18698,18716,18717,18730,18733,18751,18763,18772,18793,18808,18809,18826,18846,18867,18874,18882,18886,18898,18901,18916,18948,18952,18957,18986,18997,19006,19011,19026,19043,19051,19060,19063,19064,19086,19119,19120,19126,19133,19134,19147,19175,19201,19207,19217,19223,19247,19251,19260,19270,19272,19288,19291,19303,19306,19313,19322,19331,19349,19377,19383,19413,19419,19420,19433,19437,19440,19444,19453,19484,19494,19504,19516,19522,19552,19556,19566,19593,19604,19625,19645,19646,19651,19652,19653,19693,19700,19720,19727,19730,19733,19758,19763,19764,19766,19775,19779,19828,19855,19864,19871,19873,19875,19880,19913,19955,19962,19976,19987,19999,20007,20016,20023,20033,20042,20070,20076,20083,20089,20099,20127,20146,20149,20161,20163,20167,20174,20198,20199,20220,20223,20229,20236,20247,20256,20279,20303,20317,20327,20332,20352,20355,20362,20397,20398,20402,20418,20422,20427,20437,20471,20472,20479,20549,20551,20564,20574,20579,20586,20587,20605,20614,20654,20665,20668,20686,20691,20698,20705,20714,20724,20739,20747,20753,20757,20765,20769,20774,20776,20783,20785,20795,20797,20799,20807,20817,20820,20826,20835,20840,20878,20888,20897,20915,20941,20950,20967,20973,20993,21017,21046,21105,21113,21152,21165,21179,21184,21216,21226,21240,21242,21255,21286,21293,21307,21346,21347,21366,21369,21397,21401,21405,21415,21420,21433,21452,21465,21491,21498,21499,21517,21518,21548,21579,21606,21612,21635,21662,21667,21732,21740,21746,21750,21751,21766,21774,21775,21798,21846,21849,21851,21852,21866,21870,21886,21926,21950,22001,22012,22026,22038,22040,22043,22089,22097,22098,22099,22100,22103,22113,22124,22126,22128,22150,22171,22180,22194,22198,22212,22225,22229,22234,22248,22268,22270,22276,22290,22296,22298,22315,22319,22323,22325,22350,22366,22378,22382,22385,22389,22395,22414,22419,22431,22452,22489,22500,22509,22530,22533,22549,22554,22559,22572,22596,22607,22611,22648,22666,22672,22686,22692,22706,22720,22729,22732,22740,22741,22750,22753,22766,22784,22793,22848,22853,22854,22856,22875,22890,22901,22906,22917,22921,22933,22934,22935,22960,22976,22996,22999,23000,23002,23006,23016,23017,23019,23022,23040,23041,23046,23050,23070,23078,23080,23100,23103,23126,23130,23147,23148,23151,23156,23198,23201,23220,23245,23247,23253,23259,23267,23271,23305,23325,23343,23354,23363,23380,23383,23388,23396,23399,23415,23417,23423,23424,23436,23445,23466,23477,23485,23488,23492,23495,23501,23512,23555,23566,23615,23618,23647,23649,23651,23654,23659,23665,23666,23673,23677,23693,23706,23719,23730,23737,23740,23757,23761,23764,23767,23768,23782,23790,23792,23806,23816,23822,23827,23838,23869,23874,23914,23917,23921,23926,23960,23964,23965,23978,23990,23998,24001,24012,24024,24025,24059,24063,24077,24118,24119,24142,24147,24152,24168,24171,24184,24192,24193,24200,24212,24219,24242,24260,24277,24279,24284,24288,24299,24305,24312,24322,24337,24340,24342,24346,24373,24383,24388,24398,24403,24411,24419,24433,24440,24450,24451,24456,24470,24479,24498,24499,24505,24543,24550,24557,24576,24597,24601,24605,24608,24616,24643,24646,24659,24667,24672,24682,24695,24701,24702,24705,24718,24732,24733,24737,24747,24748,24754,24756,24767,24780,24790,24826,24830,24841,24851,24857,24863,24889,24891,24905,24909,24927,24941,24942,24960,24995,25004,25041,25043,25048,25056,25080,25090,25091,25104,25119,25123,25125,25133,25135,25141,25143,25147,25178,25199,25207,25212,25222,25230,25242,25250,25252,25260,25273,25279,25287,25293,25333,25345,25353,25366,25386,25397,25413,25415,25435,25452,25460,25486,25500,25502,25524,25535,25560,25561,25591,25595,25615,25616,25631,25650,25657,25709,25711,25778,25787,25816,25886,25888,25923,25934,25940,25968,25990,26017,26034,26043,26053,26061,26102,26103,26161,26188,26202,26238,26261,26288,26293,26324,26338,26378,26389,26410,26431,26439,26471,26479,26483,26488,26513,26519,26525,26570,26589,26595,26605,26620,26630,26640,26654,26679,26760,26763,26766,26770,26776,26792,26818,26857,26866,26901,26938,26939,26992,27008,27015,27020,27024,27041,27055,27056,27071,27074,27076,27093,27138,27149,27161,27178,27208,27248,27317,27321,27322,27356,27362,27365,27397,27407,27420,27438,27453,27471,27475,27477,27513,27518,27566,27572,27575,27592,27720,27790,27822,27949,27968,27974,27991,28005,28049,28313,28316,28548,28552,28557,28561,28563,28575,28581,28630,28646,28779,28799,28910,28922,28927,28928,28961,29023,29032,29066,29107,29123,29143,29180,29187,29200,29319,29329,29382,29443,29466,29473,29499,29500,29584,29694,29695,29711,29743,29834,29909,30000,30111,30284,30326,30481,30609,30854,31010,31773,31853,32136,32241,33621,33932,33950,34524,34584,34758,34927,34998,35259,35305,35505,35571,35718,35730,35741,35803,35884,35921,35989,36017,36041,36197,36235,36423,36602,36633,36671,36958,37025,37915,38662,38784,38800,38818,38852,38865,38905,38916,38961,38962,38985,39063,39078,39128,39178,39226,39296,39318,39323,39369,39558,39629,39653,39673,39808,39823,39858,39941,39998,40050,40064,40147,40214,40347,40545,40706,40812,40813,40922,40954,41035,41082,41184,41254,41305,41337,41594,42074,42262,43499,43538,45116,45133,45191,45262,45277,45278)
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 | 1795 | 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 | 1.04 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.47 ms |
System lock | 0.03 ms |
optimizing | 0.21 ms |
statistics | 4.02 ms |
preparing | 1.84 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.45 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.14 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 |