Tiempo de la consulta: 4.16 ms Después de la última consulta: 0.84 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.321 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 16:28:47')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 16:28:47')
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(72,133,138,141,323,332,335,337,340,342,343,347,348,350,352,373,390,417,476,522,583,609,690,723,757,782,808,826,828,841,844,986,996,1012,1022,1036,1069,1101,1133,1157,1193,1207,1216,1323,1367,1414,1459,1492,1587,1591,1645,1978,2107,2272,2545,2610,2880,2925,2958,2961,2967,3020,3082,3099,3114,3254,3353,3354,3409,3436,3440,3464,3476,3715,3832,3984,4301,4353,4383,4410,4680,4698,4710,4720,4732,4894,5078,5160,5192,5313,5424,5472,5584,5666,5680,5700,5730,5846,5894,5896,6058,6132,6278,6279,6331,6389,6442,6470,6498,6531,6539,6575,6577,6688,6730,6799,6802,6912,6942,6965,6987,7014,7052,7069,7124,7156,7200,7223,7244,7323,7336,7339,7340,7411,7415,7420,7421,7435,7450,7466,7515,7556,7569,7588,7613,7617,7621,7624,7711,7719,7725,7751,7776,7799,7819,7831,7837,7850,7866,7889,7920,7929,8046,8073,8089,8187,8227,8242,8258,8259,8295,8327,8354,8377,8386,8417,8433,8530,8566,8580,8617,8719,8759,8819,8860,8909,8943,9115,9552,9606,9750,9756,9801,9924,9956,10006,10030,10114,10162,10198,10260,10274,10316,10355,10423,10442,10562,10868,11030,11046,11057,11064,11111,11194,11207,11250,11253,11299,11330,11390,11408,11440,11441,11494,11533,11557,11714,11841,11857,11937,11965,12011,12160,12189,12207,12244,12300,12318,12430,12477,12535,12620,12624,12628,12668,12670,12685,12686,12704,12708,12802,12811,12942,12973,13086,13112,13117,13188,13224,13239,13246,13269,13349,13404,13452,13637,13672,13678,13692,13707,13798,13840,13851,13900,13919,13965,14077,14105,14144,14153,14192,14201,14208,14224,14245,14263,14267,14348,14349,14385,14483,14503,14516,14591,14601,14602,14615,14658,14708,14750,14754,14768,14795,14831,14890,14985,14992,15055,15074,15080,15108,15147,15150,15178,15195,15217,15273,15305,15347,15378,15440,15486,15491,15493,15546,15572,15577,15632,15639,15712,15714,15722,15740,15760,15761,15834,15838,15899,15904,15905,15940,15949,15952,15953,15981,16014,16038,16063,16089,16108,16156,16200,16216,16227,16267,16269,16297,16303,16313,16361,16387,16390,16430,16444,16461,16497,16546,16561,16596,16604,16609,16625,16642,16690,16698,16700,16714,16777,16780,16813,16848,16850,16863,16866,16892,16926,16928,17038,17039,17087,17116,17124,17126,17135,17142,17148,17178,17189,17202,17209,17234,17273,17275,17282,17314,17338,17344,17363,17381,17405,17422,17466,17489,17496,17555,17573,17610,17617,17627,17661,17665,17699,17710,17716,17734,17811,17812,17870,17883,17889,17974,17975,18008,18030,18045,18078,18081,18101,18140,18163,18166,18181,18187,18229,18242,18249,18260,18292,18293,18311,18316,18318,18348,18362,18365,18407,18419,18421,18429,18443,18451,18452,18457,18485,18494,18496,18498,18509,18519,18534,18535,18552,18556,18585,18588,18605,18622,18641,18652,18669,18675,18703,18723,18750,18781,18796,18801,18807,18814,18816,18826,18845,18856,18864,18875,18879,18883,18904,18945,18947,18953,18981,18988,18989,18996,19004,19007,19024,19027,19040,19045,19056,19059,19107,19135,19145,19189,19217,19226,19229,19260,19261,19282,19292,19303,19308,19314,19364,19370,19378,19406,19418,19427,19437,19447,19482,19485,19511,19514,19518,19527,19541,19554,19634,19649,19655,19659,19687,19707,19720,19729,19731,19776,19779,19792,19795,19812,19823,19832,19857,19870,19873,19883,19940,19950,19954,19972,19980,20002,20006,20010,20020,20024,20033,20039,20043,20046,20055,20056,20082,20104,20115,20129,20140,20159,20196,20234,20237,20245,20254,20261,20311,20318,20323,20348,20356,20357,20379,20394,20402,20408,20422,20426,20429,20438,20452,20456,20461,20503,20533,20539,20559,20634,20652,20653,20677,20681,20731,20774,20823,20837,20866,20899,20911,20915,20917,20932,20946,20947,20981,20983,21007,21044,21049,21060,21087,21094,21095,21118,21135,21162,21194,21227,21239,21294,21304,21309,21323,21335,21341,21343,21368,21380,21384,21390,21415,21422,21457,21480,21482,21491,21492,21520,21567,21583,21619,21622,21664,21692,21701,21704,21711,21727,21732,21801,21815,21830,21834,21836,21840,21880,21907,21922,21941,21945,21962,21998,22015,22020,22030,22035,22057,22062,22081,22091,22117,22123,22140,22149,22154,22164,22177,22200,22222,22225,22228,22256,22324,22351,22359,22373,22382,22404,22415,22416,22422,22492,22502,22519,22543,22607,22651,22698,22734,22802,22804,22839,22841,22889,22898,22911,22919,22950,22985,22992,23019,23028,23033,23035,23053,23055,23072,23089,23104,23145,23147,23151,23178,23181,23239,23294,23299,23304,23328,23332,23343,23347,23369,23401,23474,23513,23519,23568,23611,23615,23626,23633,23638,23648,23662,23668,23676,23732,23749,23795,23828,23833,23878,23935,23948,23965,23970,23998,24025,24060,24127,24132,24155,24164,24172,24224,24228,24248,24271,24309,24329,24356,24418,24427,24428,24443,24471,24477,24487,24523,24535,24568,24573,24580,24581,24615,24625,24630,24636,24710,24763,24785,24813,24825,24851,24995,25007,25018,25062,25065,25079,25090,25099,25100,25170,25184,25225,25246,25278,25286,25315,25341,25359,25400,25411,25420,25428,25463,25498,25511,25584,25590,25640,25681,25694,25707,25726,25736,25740,25850,25860,25885,25954,26002,26091,26112,26130,26175,26177,26239,26264,26360,26396,26403,26431,26435,26458,26550,26637,26651,26684,26792,26907,26947,27105,27106,27144,27178,27179,27189,27201,27203,27265,27343,27364,27409,27454,27518,27541,27624,27628,27703,27743,27846,28046,28240,28328,28616,28944,28979,29389,29511,29590,29613,29626,30393,30394,30482,30511,30656,31623,31624,33749,34052,34415,34449,34525,34560,34978,35324,35436,35503,35609,35626,35953,36192,36204,36238,36515,36736,36850,38263,39114,39625,39729,39846,40111,40187,40212,40225,40239,40392,40404,40665,40983,41059,41146,41363,42054,43905,44255,44433)
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 | 957 | 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.44 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.18 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.40 ms |
preparing | 0.76 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.32 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.06 ms |
cleaning up | 0.02 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 |