Tiempo de la consulta: 10.03 ms Después de la última consulta: 1.66 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.414 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-04 19:03:19')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 19:03:19')
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(10,47,49,58,60,65,66,74,75,76,77,78,113,114,117,131,133,136,139,155,203,205,207,208,219,282,293,349,353,368,377,437,669,693,744,831,857,914,929,942,976,986,1089,1169,1179,1204,1207,1215,1273,1284,1287,1291,1324,1338,1345,1398,1413,1452,1455,1459,1486,1490,1504,1506,1551,1600,1601,1709,1815,1943,1956,2066,2222,2261,2304,2325,2482,2563,2713,2776,2840,2901,2921,2991,3034,3117,3198,3223,3227,3249,3254,3279,3312,3327,3341,3384,3385,3390,3442,3448,3490,3503,3522,3543,3572,3577,3617,3668,3672,3680,3706,3814,3870,3912,3916,3997,4015,4030,4039,4055,4060,4061,4063,4078,4087,4090,4092,4114,4120,4144,4153,4163,4165,4168,4177,4203,4236,4239,4257,4276,4294,4315,4325,4346,4347,4378,4387,4389,4395,4417,4457,4496,4499,4511,4549,4559,4602,4643,4660,4760,4773,4778,4780,4789,4894,4910,4912,4915,4940,4949,4983,5050,5100,5115,5152,5161,5187,5203,5210,5211,5218,5229,5240,5274,5300,5301,5304,5350,5386,5407,5428,5432,5433,5442,5458,5462,5470,5473,5536,5594,5633,5647,5652,5725,5730,5788,5816,5842,5851,5854,5870,5894,5931,5979,6039,6043,6062,6074,6081,6116,6164,6177,6192,6247,6274,6291,6298,6337,6350,6361,6374,6419,6428,6435,6456,6471,6473,6486,6494,6495,6497,6499,6515,6520,6521,6534,6567,6576,6577,6578,6583,6598,6601,6603,6616,6619,6630,6636,6647,6655,6656,6657,6659,6662,6695,6715,6724,6725,6734,6764,6776,6789,6790,6805,6815,6838,6843,6869,6871,6873,6875,6876,6879,6903,6904,6914,6925,6927,6928,6940,6956,6957,6968,6986,6989,6990,6992,6994,7009,7011,7016,7020,7031,7045,7059,7100,7102,7142,7143,7165,7166,7187,7189,7217,7218,7248,7272,7280,7282,7313,7314,7359,7364,7387,7389,7391,7397,7402,7403,7410,7432,7443,7449,7451,7453,7454,7478,7484,7486,7488,7494,7509,7516,7523,7539,7542,7546,7547,7548,7550,7551,7561,7571,7572,7578,7586,7603,7614,7616,7618,7623,7626,7675,7677,7683,7711,7722,7726,7728,7736,7737,7773,7774,7787,7794,7797,7808,7816,7818,7825,7827,7832,7836,7841,7848,7861,7877,7890,7914,7953,7965,7973,8010,8014,8026,8027,8036,8041,8046,8054,8062,8065,8071,8073,8074,8103,8106,8107,8108,8116,8123,8134,8135,8141,8157,8163,8171,8177,8185,8198,8199,8200,8207,8217,8219,8259,8263,8264,8272,8298,8311,8318,8323,8334,8345,8346,8379,8399,8400,8408,8422,8441,8452,8455,8469,8476,8489,8509,8510,8519,8520,8523,8559,8563,8576,8598,8608,8614,8619,8623,8625,8639,8641,8649,8655,8658,8665,8691,8698,8700,8702,8727,8736,8738,8755,8756,8761,8765,8770,8785,8789,8794,8823,8828,8829,8856,8857,8862,8867,8871,8919,8926,8934,8949,8953,8956,8971,8973,8980,8982,9005,9020,9041,9050,9058,9065,9068,9080,9091,9101,9127,9128,9138,9147,9159,9165,9192,9194,9212,9214,9239,9249,9260,9300,9310,9311,9317,9347,9355,9365,9384,9406,9435,9445,9448,9457,9467,9476,9489,9503,9514,9542,9549,9555,9556,9558,9561,9565,9568,9569,9585,9592,9593,9594,9602,9616,9657,9676,9690,9702,9714,9724,9730,9762,9774,9783,9794,9826,9827,9829,9843,9892,9893,9894,9896,9907,9910,9911,9916,9919,9941,9951,9959,9961,9983,10017,10060,10083,10092,10108,10110,10116,10117,10118,10120,10149,10154,10170,10181,10184,10187,10192,10193,10196,10208,10209,10217,10221,10264,10268,10277,10278,10291,10294,10297,10318,10322,10332,10342,10352,10369,10370,10379,10393,10395,10398,10399,10401,10415,10418,10435,10436,10444,10450,10453,10464,10473,10475,10480,10485,10498,10512,10522,10543,10567,10613,10629,10631,10645,10646,10650,10660,10663,10681,10682,10692,10710,10754,10798,10846,10903,10941,10955,10969,10970,10983,11037,11041,11065,11073,11091,11094,11098,11106,11148,11149,11151,11163,11167,11188,11209,11226,11229,11235,11258,11289,11295,11335,11337,11344,11416,11441,11503,11505,11545,11607,11726,11749,11757,11779,11867,11868,11875,11886,11904,11907,11916,11922,11934,11974,11978,11983,12002,12046,12070,12081,12133,12174,12193,12243,12285,12312,12355,12412,12465,12520,12527,12551,12610,12631,12651,12652,12685,12695,12743,12812,12823,12841,12844,12846,12856,12857,12873,12884,12907,12997,13006,13026,13035,13036,13041,13089,13090,13124,13137,13164,13187,13207,13290,13351,13361,13376,13388,13390,13430,13455,13466,13497,13504,13505,13506,13528,13552,13587,13588,13633,13740,13771,13777,13790,13805,13808,13817,13835,13844,13879,13884,13886,13906,13909,13910,13948,13949,13953,14024,14095,14108,14109,14110,14113,14118,14123,14128,14143,14146,14186,14189,14195,14196,14205,14223,14224,14234,14240,14244,14250,14260,14261,14276,14283,14285,14297,14318,14330,14346,14353,14367,14370,14383,14409,14426,14440,14445,14448,14481,14524,14528,14530,14533,14558,14571,14591,14598,14622,14625,14681,14684,14693,14695,14697,14700,14701,14726,14740,14745,14748,14749,14750,14754,14765,14771,14773,14775,14792,14819,14820,14824,14827,14828,14840,14842,14848,14870,14871,14899,14943,14947,14949,14962,14966,14984,14999,15010,15034,15035,15048,15049,15076,15088,15103,15116,15130,15164,15166,15178,15193,15231,15232,15240,15244,15245,15247,15251,15260,15276,15286,15302,15318,15319,15333,15335,15338,15368,15390,15432,15438,15447,15451,15453,15475,15482,15486,15493,15500,15501,15503,15520,15521,15522,15533,15542,15552,15560,15578,15581,15599,15628,15631,15647,15655,15678,15693,15699,15704,15705,15720,15721,15723,15730,15738,15742,15746,15761,15764,15768,15770,15775,15776,15777,15778,15779,15780,15782,15784,15793,15799,15808,15813,15840,15855,15872,15876,15878,15879,15889,15894,15896,15897,15912,15932,15938,15954,15958,15965,15993,16008,16028,16036,16038,16048,16058,16071,16084,16086,16100,16111,16119,16141,16170,16172,16181,16193,16217,16231,16233,16250,16254,16282,16288,16302,16305,16310,16314,16315,16316,16324,16354,16368,16372,16375,16378,16389,16417,16427,16430,16446,16459,16461,16471,16475,16495,16509,16515,16516,16520,16528,16542,16651,16653,16657,16666,16675,16687,16695,16705,16724,16729,16746,16768,16770,16771,16783,16791,16795,16814,16822,16827,16830,16839,16850,16872,16875,16886,16900,16928,16942,16954,16958,16960,16967,16988,16993,17024,17025,17047,17084,17096,17109,17112,17120,17148,17152,17153,17160,17190,17200,17201,17210,17214,17227,17228,17231,17240,17243,17260,17274,17275,17277,17278,17287,17288,17289,17297,17298,17299,17300,17331,17333,17344,17363,17365,17386,17396,17414,17418,17437,17475,17495,17500,17540,17545,17548,17550,17553,17555,17573,17575,17583,17598,17601,17602,17613,17615,17627,17634,17652,17664,17668,17671,17688,17693,17704,17707,17709,17712,17713,17716,17718,17738,17753,17755,17756,17778,17783,17809,17810,17817,17850,17851,17869,17887,17888,17917,17922,17923,17924,17950,17955,17968,17995,17996,18060,18061,18121,18150,18161,18190,18248,18271,18278,18291,18311,18330,18351,18356,18384,18391,18397,18404,18428,18451,18505,18510,18518,18524,18529,18530,18537,18541,18549,18550,18552,18562,18571,18577,18595,18596,18603,18609,18610,18619,18626,18651,18655,18667,18671,18673,18689,18693,18694,18702,18705,18706,18708,18715,18718,18724,18753,18764,18775,18786,18811,18830,18832,18839,18843,18849,18852,18853,18854,18861,18869,18872,18878,18888,18907,18923,18931,18940,18941,18945,18948,18966,18968,18972,18985,18987,19003,19007,19034,19051,19061,19076,19100,19111,19138,19143,19145,19163,19173,19178,19199,19220,19222,19248,19284,19290,19310,19318,19322,19353,19358,19375,19379,19382,19403,19414,19439,19455,19460,19479,19501,19503,19517,19519,19531,19558,19566,19575,19591,19634,19644,19645,19646,19652,19659,19674,19708,19711,19719,19733,19754,19784,19787,19792,19819,19820,19839,19846,19847,19869,19906,19929,19943,19958,19960,19973,19974,19984,19996,20000,20018,20020,20045,20091,20097,20098,20131,20134,20135,20154,20168,20186,20200,20218,20276,20279,20281,20297,20301,20329,20333,20336,20366,20399,20405,20408,20411,20441,20444,20472,20504,20506,20527,20540,20541,20555,20577,20632,20641,20648,20658,20666,20676,20681,20685,20687,20716,20729,20730,20731,20753,20776,20779,20787,20797,20805,20809,20866,20885,20889,20940,20960,20985,21002,21009,21012,21055,21058,21060,21063,21075,21104,21107,21116,21128,21171,21183,21209,21218,21228,21244,21262,21265,21296,21297,21305,21312,21316,21323,21343,21347,21350,21351,21378,21390,21398,21413,21418,21425,21429,21436,21448,21463,21475,21495,21505,21520,21522,21540,21566,21578,21585,21609,21610,21611,21627,21662,21682,21700,21703,21713,21714,21733,21734,21749,21777,21853,21856,21858,21864,21871,21886,21905,21924,21927,21931,21947,21950,21977,22000,22002,22003,22012,22038,22051,22058,22063,22072,22089,22093,22095,22123,22124,22139,22146,22154,22180,22209,22214,22243,22247,22259,22296,22297,22305,22313,22317,22326,22332,22339,22348,22349,22365,22395,22439,22460,22479,22495,22497,22509,22532,22558,22564,22595,22596,22608,22616,22617,22619,22640,22642,22644,22653,22661,22690,22693,22708,22709,22715,22718,22724,22725,22746,22799,22804,22820,22837,22854,22871,22879,22904,22920,22946,22948,22951,22978,22988,23033,23045,23055,23060,23071,23078,23079,23087,23112,23140,23144,23187,23203,23207,23209,23236,23242,23252,23265,23273,23279,23299,23302,23308,23339,23367,23396,23436,23449,23459,23467,23498,23503,23512,23527,23550,23555,23569,23577,23578,23599,23602,23606,23626,23646,23665,23670,23682,23685,23691,23693,23695,23698,23706,23709,23716,23719,23727,23743,23759,23774,23784,23787,23816,23836,23840,23849,23898,23912,23968,23977,23989,24008,24012,24020,24061,24065,24068,24100,24102,24124,24127,24138,24159,24196,24202,24217,24233,24238,24258,24270,24272,24273,24275,24283,24291,24295,24316,24347,24348,24352,24368,24372,24402,24417,24428,24429,24437,24451,24457,24461,24473,24475,24486,24525,24550,24558,24565,24566,24577,24590,24649,24656,24658,24679,24689,24716,24730,24751,24756,24775,24780,24782,24794,24800,24809,24850,24859,24867,24872,24924,24930,25003,25046,25063,25069,25077,25078,25096,25112,25116,25134,25139,25144,25155,25165,25166,25180,25187,25192,25194,25206,25224,25261,25263,25269,25281,25294,25300,25308,25352,25356,25358,25386,25387,25412,25416,25418,25451,25462,25477,25478,25516,25531,25538,25554,25556,25561,25563,25564,25589,25590,25645,25664,25701,25738,25778,25793,25795,25807,25814,25817,25887,25888,25926,26043,26063,26205,26234,26249,26258,26302,26344,26346,26366,26375,26414,26431,26493,26522,26540,26541,26604,26685,26711,26756,26807,26815,26827,26835,26842,26843,26861,26864,26901,26930,26958,26960,26964,26986,27001,27022,27025,27039,27056,27059,27079,27086,27094,27128,27139,27147,27171,27186,27197,27221,27263,27271,27272,27304,27327,27367,27373,27384,27404,27405,27423,27435,27506,27565,27567,27575,27601,27609,27633,27655,27656,27663,27683,27692,27695,27745,27748,27758,27802,27832,27871,27887,27903,27918,27921,27923,27924,27926,27945,27949,27968,27975,27990,27999,28047,28067,28250,28312,28360,28372,28398,28431,28464,28497,28511,28530,28606,28718,28747,28748,28785,28892,28907,28908,28920,28933,28949,28951,28972,28973,28984,28992,29004,29005,29014,29021,29026,29034,29037,29049,29099,29139,29140,29157,29171,29194,29208,29223,29224,29349,29412,29489,29535,29576,29611,29622,29642,29673,29694,29716,29720,29790,29810,29868,29873,29911,29912,29923,29930,29939,30449,31286,31510,31908,32182,33082,33099,34239,35722,35740,36875,38477,38496,38900,38932,38986,39131,39172,39451,39860,39893,39966,40198,40212,40243,40351,40461,40583,40622,40728,40746,40759,40993,41211,41257,41429,41452,43840,44291)
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 | 1953 | 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.63 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.44 ms |
System lock | 0.02 ms |
optimizing | 0.12 ms |
statistics | 4.26 ms |
preparing | 2.12 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.68 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.08 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 |