Tiempo de la consulta: 4.61 ms Después de la última consulta: 0.90 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.371 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 03:27:15')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 03:27:15')
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(51,72,133,141,204,318,332,373,385,406,452,460,461,489,494,497,522,529,583,597,614,681,723,733,737,757,771,802,826,828,841,864,872,889,892,894,907,909,910,928,943,986,996,1005,1036,1044,1062,1092,1112,1130,1132,1133,1174,1182,1190,1200,1207,1210,1256,1285,1297,1323,1355,1465,1526,1587,1594,1712,1776,1808,1907,1971,1973,2107,2124,2272,2274,2331,2485,2552,2559,2580,2610,2617,2706,2790,2925,3027,3060,3082,3126,3193,3224,3240,3244,3279,3317,3330,3353,3354,3379,3424,3440,3444,3456,3476,3573,3792,3825,3832,3905,3943,3951,3984,4008,4029,4035,4046,4084,4109,4120,4224,4234,4235,4263,4273,4289,4313,4331,4332,4361,4362,4364,4391,4444,4465,4491,4515,4560,4675,4680,4698,4732,4752,4835,4880,4992,5000,5037,5074,5101,5160,5176,5192,5195,5248,5263,5269,5285,5313,5318,5390,5423,5463,5583,5591,5648,5666,5707,5730,5757,5803,5834,5846,5859,5894,5896,6009,6111,6124,6160,6199,6221,6233,6357,6378,6389,6429,6430,6448,6470,6498,6531,6539,6575,6615,6625,6686,6688,6691,6730,6747,6750,6758,6799,6802,6848,6853,6941,6942,6965,7014,7037,7052,7069,7121,7124,7156,7200,7242,7244,7278,7291,7297,7336,7339,7340,7355,7411,7420,7421,7448,7450,7534,7556,7580,7581,7588,7594,7621,7624,7632,7652,7719,7725,7729,7751,7776,7799,7801,7804,7831,7837,7850,7866,7889,7967,8077,8089,8098,8105,8258,8259,8303,8354,8377,8386,8417,8443,8512,8566,8580,8617,8728,8759,8860,8909,8979,9004,9011,9109,9184,9218,9239,9272,9516,9552,9655,9750,9801,9814,9882,9899,9924,9925,9956,9970,10030,10114,10140,10162,10274,10316,10348,10405,10408,10467,10481,10635,10677,10819,10868,10869,10955,11030,11040,11057,11137,11194,11195,11240,11250,11253,11299,11408,11440,11441,11552,11560,11662,11669,11681,11714,11753,11853,11857,11880,11965,12011,12113,12137,12213,12217,12255,12281,12318,12430,12439,12458,12475,12620,12624,12628,12663,12668,12670,12685,12686,12708,12811,12890,12935,12949,12973,12974,12982,12999,13044,13083,13152,13224,13239,13246,13349,13358,13436,13452,13579,13617,13626,13710,13729,13822,13851,13875,13900,14134,14153,14159,14192,14224,14263,14264,14267,14337,14385,14516,14577,14591,14601,14688,14700,14708,14754,14795,14876,14927,14928,14941,14992,14997,15027,15055,15080,15091,15108,15147,15217,15223,15261,15347,15378,15405,15440,15486,15493,15537,15632,15639,15654,15706,15712,15714,15762,15782,15859,15899,15904,15927,15942,15952,15953,15991,16014,16038,16089,16142,16156,16157,16162,16187,16200,16216,16221,16260,16267,16297,16303,16313,16318,16375,16390,16430,16497,16609,16641,16714,16780,16813,16863,16866,16894,16905,16916,16924,16928,16940,16944,16947,16968,16969,16972,17001,17038,17039,17054,17116,17117,17126,17137,17142,17148,17203,17206,17209,17234,17238,17248,17268,17275,17282,17328,17336,17344,17363,17371,17381,17405,17416,17422,17496,17535,17573,17592,17593,17627,17661,17683,17699,17710,17734,17750,17799,17812,17863,17889,17924,17954,18027,18040,18042,18072,18076,18078,18168,18181,18187,18212,18229,18235,18249,18260,18290,18312,18316,18318,18362,18384,18419,18421,18422,18429,18430,18452,18485,18494,18498,18509,18534,18535,18542,18552,18556,18588,18599,18605,18652,18675,18747,18750,18761,18799,18801,18803,18807,18816,18826,18835,18845,18851,18856,18857,18864,18904,18923,18931,18934,18945,18950,18953,18954,18973,18980,18988,18989,18996,19007,19024,19027,19040,19053,19056,19059,19066,19113,19135,19145,19156,19172,19189,19197,19217,19226,19249,19260,19261,19282,19292,19303,19364,19365,19370,19427,19437,19439,19481,19493,19527,19565,19573,19618,19641,19655,19659,19664,19678,19705,19720,19742,19745,19759,19778,19779,19820,19835,19857,19873,19883,19900,19924,19940,19942,19950,19972,19973,19980,20002,20006,20010,20020,20024,20033,20039,20042,20043,20045,20046,20056,20076,20080,20115,20129,20226,20234,20235,20237,20254,20267,20315,20356,20387,20394,20402,20426,20539,20559,20570,20575,20577,20601,20650,20677,20681,20689,20733,20740,20767,20803,20808,20823,20828,20837,20866,20879,20885,20946,20947,20969,20992,21007,21049,21059,21070,21087,21093,21094,21095,21114,21118,21135,21188,21194,21204,21251,21261,21264,21288,21291,21294,21311,21326,21342,21361,21368,21378,21380,21383,21384,21390,21422,21491,21502,21520,21559,21583,21609,21644,21647,21664,21691,21692,21701,21703,21711,21714,21727,21728,21732,21810,21815,21830,21836,21844,21848,21907,21929,21985,21986,21998,22015,22020,22030,22035,22036,22048,22062,22072,22081,22117,22131,22140,22149,22158,22161,22164,22166,22177,22201,22222,22225,22228,22299,22324,22351,22359,22376,22382,22385,22404,22408,22415,22416,22502,22507,22541,22543,22556,22591,22651,22698,22704,22736,22758,22804,22816,22841,22860,22893,22898,22919,22934,22985,23014,23028,23051,23053,23072,23084,23085,23089,23116,23119,23134,23145,23164,23178,23181,23213,23217,23273,23287,23290,23294,23299,23304,23328,23364,23365,23369,23379,23401,23409,23426,23434,23460,23561,23615,23633,23645,23668,23677,23711,23713,23732,23758,23776,23803,23869,23872,23894,23914,23965,23979,24011,24025,24060,24087,24108,24127,24151,24155,24164,24191,24195,24233,24234,24248,24289,24300,24309,24356,24368,24380,24387,24391,24442,24500,24502,24518,24523,24527,24549,24573,24575,24580,24606,24615,24644,24710,24719,24731,24785,24832,24876,24942,24974,25007,25061,25062,25079,25099,25100,25116,25170,25184,25195,25256,25278,25315,25411,25420,25428,25463,25498,25584,25626,25640,25670,25694,25695,25745,25829,25845,25865,25906,25944,25954,25983,26019,26056,26080,26132,26239,26332,26334,26360,26379,26412,26431,26473,26489,26591,26599,26651,26672,26734,26754,26835,26838,26843,26864,26933,26947,27059,27090,27142,27144,27164,27179,27189,27206,27312,27313,27362,27364,27454,27457,27518,27541,27624,27628,27694,27743,27846,27855,27892,27918,27923,27999,28046,28208,28240,28328,28349,28372,28419,28453,28531,28616,28733,28886,28898,28944,29017,29164,29218,29223,29380,29389,29589,29590,29611,29641,30482,30621,30656,30932,31623,31624,32304,32796,34220,34795,34876,34923,35127,35195,35428,35776,35783,35850,35862,36004,36109,36174,36222,36439,37973,38763,38885,38898,39036,39062,39242,39616,39625,39726,39886,39984,39997,40218,40404,40533,40756,40786,41268,41363,42181)
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 | 1068 | 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.52 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.21 ms |
System lock | 0.22 ms |
optimizing | 0.09 ms |
statistics | 1.70 ms |
preparing | 0.79 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.36 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 |