Tiempo de la consulta: 5.40 ms Después de la última consulta: 1.25 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.246 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-07 03:14:06')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 03:14:06')
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(23,72,101,112,122,138,141,332,373,391,466,493,501,516,521,522,523,583,660,723,757,826,828,841,953,959,977,986,996,1051,1075,1133,1207,1237,1291,1308,1323,1363,1386,1458,1556,1557,1587,1644,1720,2107,2108,2109,2119,2121,2156,2272,2282,2456,2571,2610,2721,2767,2799,2925,3059,3132,3145,3169,3209,3353,3354,3396,3476,3570,3617,3682,3715,3834,3974,3980,4114,4177,4200,4268,4285,4306,4310,4326,4370,4680,4698,4748,5026,5150,5160,5192,5313,5479,5484,5530,5537,5616,5666,5730,5846,5849,5874,5894,5896,5934,5977,6097,6257,6288,6351,6389,6470,6473,6478,6498,6514,6531,6539,6557,6574,6575,6608,6688,6730,6799,6802,6826,6833,6925,6933,6942,6965,7014,7052,7069,7124,7156,7162,7163,7164,7192,7200,7244,7251,7264,7314,7321,7336,7339,7340,7343,7389,7411,7420,7421,7436,7437,7447,7449,7450,7516,7523,7548,7556,7588,7601,7618,7621,7624,7679,7711,7719,7725,7746,7749,7751,7776,7797,7799,7808,7829,7831,7837,7840,7850,7852,7854,7866,7889,8016,8045,8089,8093,8111,8113,8190,8258,8259,8354,8377,8386,8397,8417,8430,8441,8525,8528,8555,8566,8567,8580,8617,8754,8759,8823,8860,8903,8909,9304,9326,9355,9552,9584,9730,9750,9801,9854,9924,9956,10030,10033,10100,10114,10122,10160,10162,10163,10169,10199,10272,10274,10316,10332,10398,10443,10453,10484,10512,10554,10572,10607,10656,10661,10771,10868,11030,11057,11164,11194,11207,11250,11253,11295,11299,11327,11379,11408,11417,11427,11440,11441,11474,11553,11594,11648,11714,11716,11828,11857,11911,12011,12019,12051,12318,12510,12565,12620,12624,12628,12670,12678,12685,12686,12692,12708,12811,12933,12973,12989,13010,13016,13017,13019,13067,13157,13224,13239,13246,13253,13312,13323,13334,13349,13408,13452,13487,13551,13604,13644,13851,13863,13900,13963,13998,14141,14151,14153,14180,14192,14199,14224,14240,14242,14246,14263,14266,14267,14293,14348,14373,14375,14378,14385,14414,14469,14480,14482,14491,14502,14508,14514,14516,14591,14596,14601,14608,14613,14624,14632,14637,14654,14701,14708,14747,14751,14754,14760,14795,14814,14896,14897,14935,14964,14992,15039,15048,15055,15068,15080,15094,15107,15108,15147,15154,15174,15181,15214,15217,15273,15281,15283,15302,15325,15347,15351,15358,15375,15378,15410,15417,15426,15440,15475,15486,15493,15580,15582,15632,15639,15677,15712,15714,15726,15750,15762,15794,15840,15899,15901,15904,15949,15952,15953,15954,15955,15977,16038,16040,16056,16089,16101,16126,16156,16200,16216,16236,16267,16279,16297,16301,16303,16305,16313,16322,16337,16366,16370,16390,16430,16486,16497,16518,16556,16564,16571,16585,16609,16611,16620,16623,16627,16653,16660,16671,16673,16714,16742,16780,16813,16822,16863,16866,16876,16903,16927,16928,16942,16963,16967,17000,17036,17038,17039,17066,17088,17116,17126,17142,17148,17162,17209,17218,17222,17234,17266,17269,17275,17277,17282,17343,17344,17363,17381,17405,17406,17408,17411,17422,17427,17431,17433,17437,17486,17496,17498,17511,17573,17610,17627,17661,17699,17710,17715,17732,17734,17812,17831,17846,17889,17918,18008,18031,18052,18057,18097,18108,18109,18111,18128,18181,18187,18215,18229,18248,18249,18260,18262,18263,18274,18315,18316,18318,18362,18376,18406,18419,18421,18429,18435,18452,18453,18494,18498,18509,18519,18552,18556,18588,18605,18625,18652,18666,18675,18695,18698,18699,18718,18732,18750,18801,18804,18807,18816,18821,18826,18845,18852,18856,18864,18904,18933,18945,18948,18952,18953,18961,18966,18985,18988,18989,19000,19007,19018,19024,19027,19040,19053,19056,19059,19061,19062,19104,19106,19121,19135,19145,19189,19191,19217,19226,19254,19260,19261,19267,19282,19292,19303,19350,19364,19368,19370,19405,19427,19434,19437,19440,19462,19467,19486,19504,19508,19509,19523,19527,19571,19580,19592,19626,19650,19654,19655,19658,19659,19668,19705,19761,19762,19774,19807,19818,19856,19857,19873,19874,19883,19885,19903,19918,19919,19929,19934,19940,19946,19948,19950,19951,19957,19972,19978,19980,20006,20010,20018,20020,20024,20033,20035,20039,20043,20056,20064,20089,20105,20115,20117,20186,20213,20214,20226,20234,20237,20254,20263,20294,20312,20327,20343,20356,20359,20371,20388,20394,20402,20426,20431,20459,20498,20513,20523,20539,20543,20559,20596,20608,20672,20677,20681,20691,20702,20711,20716,20721,20726,20777,20782,20784,20810,20823,20837,20841,20862,20866,20870,20876,20906,20944,20946,20947,20956,20957,20986,21002,21007,21010,21049,21074,21087,21094,21095,21109,21110,21118,21142,21160,21167,21172,21194,21202,21222,21231,21262,21269,21294,21312,21324,21339,21346,21366,21368,21380,21384,21390,21400,21422,21436,21466,21491,21501,21505,21510,21512,21516,21520,21529,21575,21583,21585,21588,21596,21614,21647,21664,21692,21701,21711,21727,21732,21733,21765,21816,21836,21860,21878,21907,21912,21947,21969,21998,22002,22013,22015,22020,22027,22030,22035,22062,22081,22087,22114,22115,22117,22122,22140,22144,22149,22153,22156,22162,22164,22170,22177,22183,22185,22205,22210,22216,22222,22225,22228,22239,22254,22273,22277,22305,22312,22324,22351,22359,22382,22383,22404,22411,22415,22416,22421,22430,22502,22511,22523,22527,22534,22539,22543,22563,22605,22651,22666,22671,22680,22698,22706,22743,22779,22804,22841,22872,22877,22898,22919,22923,22949,22985,23013,23014,23028,23036,23053,23064,23072,23076,23089,23093,23112,23117,23157,23181,23189,23202,23203,23209,23257,23263,23264,23277,23294,23299,23304,23305,23306,23307,23315,23328,23357,23358,23367,23369,23393,23401,23440,23444,23458,23465,23480,23524,23544,23555,23585,23602,23615,23633,23668,23689,23698,23709,23732,23743,23759,23770,23786,23876,23880,23882,23883,23893,23895,23902,23917,23941,23957,23965,23994,24016,24020,24025,24060,24064,24086,24088,24110,24112,24114,24127,24150,24155,24164,24186,24197,24210,24213,24248,24270,24274,24297,24356,24369,24395,24412,24414,24422,24423,24425,24456,24471,24480,24486,24496,24503,24523,24536,24559,24563,24571,24573,24574,24580,24598,24615,24618,24635,24641,24663,24667,24679,24684,24710,24756,24764,24773,24785,24807,24812,24822,24852,24888,24910,24984,25007,25022,25046,25062,25079,25099,25100,25111,25142,25157,25170,25176,25184,25205,25215,25233,25273,25274,25278,25285,25297,25315,25320,25332,25348,25361,25376,25394,25405,25411,25416,25418,25420,25428,25443,25452,25463,25477,25498,25548,25560,25580,25584,25603,25639,25640,25650,25657,25671,25672,25676,25680,25681,25694,25696,25697,25699,25711,25724,25755,25785,25799,25807,25820,25847,25884,25904,25907,25908,25935,25947,25948,25949,25954,25958,25967,25971,26026,26030,26064,26120,26131,26133,26136,26146,26147,26161,26164,26168,26172,26177,26193,26221,26225,26230,26239,26250,26254,26292,26344,26360,26409,26415,26431,26434,26452,26453,26456,26471,26507,26508,26529,26535,26541,26543,26559,26571,26582,26596,26605,26606,26651,26664,26671,26673,26677,26678,26685,26706,26710,26715,26723,26725,26740,26743,26749,26750,26756,26767,26768,26801,26809,26810,26811,26818,26827,26859,26860,26861,26896,26898,26900,26924,26925,26937,26940,26947,26971,26976,26991,27025,27028,27045,27056,27057,27060,27082,27085,27097,27128,27155,27156,27171,27189,27232,27247,27248,27261,27318,27363,27364,27393,27395,27417,27454,27478,27485,27505,27512,27518,27541,27544,27567,27589,27591,27624,27628,27634,27737,27738,27739,27743,27761,27763,27777,27789,27811,27821,27822,27846,27922,27930,27948,27957,27998,28006,28036,28046,28135,28163,28184,28240,28309,28320,28322,28328,28342,28351,28360,28361,28425,28441,28460,28465,28472,28575,28594,28609,28616,28620,28675,28690,28702,28739,28755,28786,28789,28852,28916,28944,29004,29005,29017,29023,29037,29053,29065,29105,29123,29129,29142,29155,29208,29241,29249,29250,29331,29372,29389,29413,29438,29460,29484,29502,29533,29550,29563,29590,29608,29618,29635,29682,29742,29760,29799,29801,29803,29890,29895,29897,29904,29937,30482,30656,31623,31624,32374,34239,34290,34316,34384,34385,34432,34451,34470,34531,34645,34653,34750,34804,34813,35196,35590,35645,35869,35871,36232,36234,36302,36476,36477,36543,37125,37426,37602,37735,37906,37907,38079,38131,38206,38574,38602,38666,38713,38910,39088,39158,39183,39204,39269,39286,39370,39411,39433,39507,39513,39598,39625,39634,39761,39926,40104,40238,40311,40326,40352,40401,40404,40540,40585,40661,40720,40727,40772,40803,40860,40865,40887,41013,41140,41158,41200,41217,41236,41253,41254,41298,41354,41363,41421,41456,41486,41543,41662,41695,41696,41747,41779,41853,41911,41993,42021,42044,42080,42094,42187,42274,42395,42412,42486,42531,42651,42676,42730,42745,42758,42789,42797,42932,42950,43068,43152,43153,43213,43214,43215,43488,43576,43595,43685,43765,43988,44114,44142,44916,45001,45069)
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 | 1455 | 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.69 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.28 ms |
System lock | 0.02 ms |
optimizing | 0.10 ms |
statistics | 2.13 ms |
preparing | 1.15 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.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 |