Tiempo de la consulta: 6.00 ms Después de la última consulta: 1.47 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.248 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 12:04:51')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 12:04:51')
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,23,47,203,205,207,208,219,368,466,1284,1291,1324,1338,1345,1384,1398,1413,1455,1459,1486,1490,1504,1506,1600,1601,1696,1720,1815,1890,1943,1956,2066,2109,2531,2767,2799,2853,3135,3312,3327,3385,3390,3448,3490,3570,3572,3617,3672,3682,3715,3916,3974,4015,4039,4055,4060,4063,4087,4092,4114,4144,4153,4163,4165,4177,4203,4276,4285,4306,4310,4389,4395,4457,4496,4511,4549,4559,4602,4660,4760,4773,4879,4912,4949,4983,5026,5050,5100,5161,5203,5218,5240,5301,5350,5351,5428,5432,5462,5484,5530,5537,5633,5725,5788,5849,5874,5931,5934,5979,6043,6074,6081,6116,6119,6177,6192,6291,6350,6374,6428,6435,6456,6471,6473,6494,6495,6497,6499,6515,6520,6521,6534,6576,6578,6598,6601,6603,6608,6636,6655,6656,6657,6659,6662,6695,6724,6725,6734,6744,6764,6789,6790,6805,6833,6838,6843,6869,6871,6873,6875,6876,6879,6903,6904,6914,6925,6927,6928,6933,6940,6956,6957,6968,6986,6990,6992,6994,7009,7011,7016,7020,7045,7059,7100,7102,7162,7163,7164,7248,7251,7264,7311,7313,7314,7343,7389,7397,7432,7436,7443,7447,7449,7453,7478,7484,7488,7494,7516,7523,7542,7547,7548,7571,7578,7586,7616,7618,7623,7626,7675,7677,7679,7683,7711,7722,7726,7728,7737,7773,7774,7787,7794,7797,7808,7832,7840,7841,7848,7854,7877,8026,8036,8045,8062,8071,8103,8106,8116,8135,8141,8157,8198,8199,8200,8272,8298,8323,8334,8345,8397,8399,8430,8441,8452,8489,8510,8555,8559,8567,8598,8608,8619,8639,8641,8649,8655,8658,8665,8700,8702,8738,8755,8761,8765,8770,8794,8823,8828,8829,8856,8871,8903,8926,8953,8973,8982,9020,9041,9058,9065,9068,9101,9127,9128,9147,9192,9260,9300,9304,9325,9326,9355,9406,9459,9476,9489,9514,9542,9556,9558,9561,9565,9569,9592,9594,9602,9714,9724,9730,9762,9783,9794,9843,9893,9896,9910,9911,9919,9941,9951,9961,10017,10033,10083,10118,10149,10160,10163,10169,10184,10192,10208,10209,10221,10264,10272,10291,10297,10322,10332,10352,10395,10398,10436,10443,10450,10453,10464,10473,10475,10480,10484,10485,10512,10543,10554,10607,10613,10629,10631,10645,10646,10650,10660,10661,10663,10681,10692,10710,10754,10771,10941,10969,11041,11065,11098,11106,11151,11163,11209,11226,11229,11235,11258,11289,11295,11416,11417,11427,11505,11553,11716,11828,11867,11875,11904,11907,11934,12002,12019,12046,12412,12651,12652,12664,12692,12743,12841,12857,12933,13019,13090,13187,13290,13312,13323,13334,13430,13455,13505,13506,13528,13551,13552,13588,13604,13777,13884,14032,14095,14108,14110,14118,14141,14146,14180,14189,14195,14196,14224,14234,14240,14244,14246,14261,14266,14276,14318,14353,14367,14375,14383,14440,14445,14448,14491,14524,14528,14533,14613,14622,14624,14632,14681,14701,14726,14745,14748,14750,14751,14760,14765,14773,14792,14827,14842,14870,14871,14899,14943,14949,15048,15049,15074,15094,15116,15166,15178,15214,15247,15251,15260,15273,15281,15302,15319,15333,15335,15338,15351,15390,15426,15432,15438,15453,15475,15482,15500,15503,15521,15533,15542,15560,15578,15582,15628,15631,15647,15655,15669,15677,15678,15693,15705,15720,15723,15726,15746,15750,15761,15770,15777,15780,15784,15808,15813,15840,15878,15896,15912,15938,15949,15953,15954,15993,16008,16028,16036,16038,16048,16141,16181,16231,16233,16236,16288,16305,16322,16354,16366,16372,16378,16389,16430,16461,16471,16475,16486,16497,16515,16564,16571,16623,16653,16666,16673,16742,16768,16770,16822,16846,16850,16886,16900,16903,16908,16917,16946,16958,16963,16967,17063,17066,17088,17096,17136,17160,17190,17214,17227,17228,17243,17266,17275,17277,17299,17344,17396,17400,17406,17411,17431,17437,17573,17583,17602,17613,17629,17634,17643,17644,17645,17652,17668,17680,17699,17707,17709,17715,17716,17718,17738,17756,17778,17785,17798,17809,17810,17817,17846,17862,17869,17886,17888,17923,17946,17965,17976,17977,18006,18008,18021,18035,18036,18109,18128,18151,18168,18171,18191,18241,18248,18253,18259,18308,18347,18354,18356,18404,18413,18426,18451,18453,18473,18491,18497,18500,18505,18518,18530,18537,18540,18541,18550,18575,18595,18603,18610,18619,18625,18635,18638,18666,18694,18698,18699,18718,18746,18751,18753,18775,18786,18790,18795,18828,18832,18852,18861,18862,18864,18868,18872,18878,18917,18918,18940,18941,18948,18966,18972,18985,18987,19000,19003,19005,19007,19034,19061,19076,19079,19082,19100,19173,19191,19267,19288,19301,19310,19318,19320,19322,19353,19358,19368,19382,19390,19432,19479,19484,19495,19503,19504,19519,19531,19561,19566,19571,19575,19580,19591,19594,19626,19645,19646,19674,19684,19696,19705,19710,19723,19751,19787,19792,19807,19818,19824,19832,19876,19903,19906,19919,19939,19943,19946,19948,19951,19974,19978,19982,19988,19989,20000,20017,20018,20020,20089,20105,20131,20150,20176,20186,20187,20188,20193,20211,20213,20226,20264,20277,20279,20281,20294,20298,20307,20310,20312,20340,20343,20359,20371,20388,20391,20399,20401,20408,20410,20421,20431,20441,20442,20472,20481,20484,20498,20504,20513,20523,20527,20541,20550,20567,20572,20596,20601,20608,20630,20641,20648,20658,20672,20705,20709,20713,20714,20716,20721,20727,20729,20730,20731,20752,20753,20776,20777,20784,20787,20797,20808,20813,20830,20865,20866,20870,20871,20881,20906,20907,20910,20920,20925,20954,20973,20990,21002,21012,21021,21033,21042,21047,21050,21059,21063,21069,21074,21080,21090,21107,21110,21132,21134,21135,21145,21159,21160,21169,21204,21209,21231,21245,21262,21273,21288,21296,21312,21323,21339,21343,21351,21397,21410,21413,21425,21429,21436,21466,21474,21485,21486,21491,21502,21504,21505,21510,21512,21543,21547,21560,21563,21566,21574,21578,21581,21585,21610,21618,21627,21640,21641,21650,21660,21670,21683,21688,21690,21699,21700,21703,21733,21734,21738,21756,21764,21765,21800,21810,21816,21837,21853,21871,21878,21886,21902,21926,21947,21960,21976,21977,22002,22015,22017,22027,22034,22050,22051,22073,22081,22085,22112,22114,22122,22124,22144,22162,22164,22185,22204,22205,22214,22216,22242,22243,22247,22254,22273,22277,22278,22281,22292,22296,22312,22321,22326,22339,22353,22365,22383,22394,22405,22430,22439,22502,22509,22514,22522,22544,22545,22558,22564,22577,22590,22605,22606,22608,22646,22658,22690,22706,22707,22716,22725,22737,22745,22757,22759,22816,22838,22854,22871,22877,22894,22946,22968,22970,22971,22988,22991,22997,23003,23017,23033,23035,23051,23063,23070,23076,23079,23085,23095,23097,23112,23117,23132,23135,23136,23189,23201,23203,23209,23216,23217,23239,23257,23263,23265,23280,23295,23299,23302,23306,23307,23317,23320,23345,23348,23349,23351,23352,23365,23367,23383,23393,23396,23420,23444,23458,23459,23512,23528,23556,23560,23571,23582,23602,23605,23606,23609,23626,23631,23649,23662,23670,23680,23681,23685,23689,23698,23709,23712,23759,23770,23772,23786,23800,23806,23811,23813,23814,23826,23847,23851,23854,23883,23895,23898,23917,23941,23945,23951,23953,23957,23961,23963,23968,23975,23989,23994,23999,24008,24020,24045,24054,24055,24061,24064,24086,24112,24114,24120,24124,24127,24139,24165,24169,24189,24196,24202,24203,24204,24206,24213,24223,24238,24244,24245,24246,24297,24307,24316,24333,24348,24352,24385,24401,24410,24414,24423,24425,24426,24429,24471,24483,24502,24513,24525,24536,24549,24559,24560,24566,24571,24574,24583,24628,24635,24641,24644,24651,24679,24681,24684,24694,24730,24750,24756,24775,24782,24794,24796,24800,24807,24812,24822,24824,24848,24861,24865,24867,24877,24878,24896,24924,24925,24941,24966,24967,24969,24973,24977,25021,25022,25025,25031,25046,25053,25057,25061,25089,25111,25118,25123,25127,25129,25139,25144,25171,25176,25194,25204,25210,25215,25224,25243,25263,25269,25273,25274,25287,25296,25297,25332,25348,25351,25361,25369,25372,25378,25394,25396,25399,25407,25412,25418,25424,25436,25440,25451,25452,25458,25460,25477,25478,25516,25517,25520,25523,25524,25525,25528,25531,25536,25538,25541,25551,25552,25554,25556,25560,25563,25568,25580,25582,25590,25591,25596,25603,25649,25650,25657,25671,25672,25676,25680,25681,25696,25697,25699,25702,25711,25724,25755,25775,25779,25781,25797,25799,25807,25817,25820,25844,25847,25874,25884,25888,25907,25908,25935,25941,25947,25948,25958,25962,25967,25971,25983,26030,26033,26044,26064,26082,26133,26147,26164,26172,26177,26193,26201,26225,26230,26234,26239,26241,26249,26250,26271,26283,26292,26296,26318,26320,26344,26346,26351,26354,26362,26366,26409,26414,26431,26456,26507,26508,26529,26541,26543,26559,26571,26582,26588,26596,26605,26613,26651,26664,26678,26685,26694,26715,26723,26725,26734,26740,26743,26749,26750,26756,26767,26768,26796,26801,26809,26814,26815,26818,26827,26859,26860,26861,26896,26937,26964,26976,26986,26991,26999,27025,27028,27045,27048,27056,27059,27060,27082,27086,27097,27119,27124,27128,27139,27155,27156,27171,27242,27248,27252,27261,27302,27318,27330,27367,27404,27405,27417,27423,27425,27478,27512,27544,27551,27567,27589,27591,27601,27622,27634,27655,27656,27663,27683,27692,27695,27737,27738,27758,27763,27789,27803,27806,27811,27818,27822,27860,27875,27887,27903,27930,27948,27957,27958,27998,27999,28006,28030,28036,28067,28117,28135,28184,28281,28309,28320,28328,28342,28360,28361,28429,28458,28460,28472,28504,28530,28555,28620,28675,28683,28690,28691,28702,28703,28718,28755,28852,28916,28973,28984,28992,29004,29005,29021,29023,29034,29037,29108,29123,29129,29159,29241,29249,29250,29298,29320,29413,29438,29489,29533,29608,29618,29619,29694,29716,29799,29810,29873,29890,29904,31510,31623,31624,32182,32374,32679,33099,34177,34205,34239,34417,34432,34451,34489,34639,34653,34690,34750,34888,35196,35300,35645,35657,35722,35740,35871,35936,35959,36298,36499,36596,36813,36990,37426,37503,38666,38961,39286,39451,39761,40072,40198,40370,40583,40661,40727,40860,40887,41089,41158,41185,41200,41217,41421,41868,42486,42758,42899,42900,42908,43581,43906,44682,44830)
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 | 1659 | 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.75 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.31 ms |
System lock | 0.02 ms |
optimizing | 0.11 ms |
statistics | 2.48 ms |
preparing | 1.28 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.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 |