Tiempo de la consulta: 14.36 ms Después de la última consulta: 1.48 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.373 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 05:04:31')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 05:04:31')
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,76,138,141,165,192,323,332,373,505,507,522,579,583,599,723,729,757,795,805,808,826,828,841,914,942,971,981,986,996,1051,1101,1125,1133,1207,1216,1280,1285,1323,1342,1343,1352,1401,1408,1459,1473,1492,1521,1587,1771,1944,2046,2089,2098,2107,2272,2284,2285,2427,2569,2610,2623,2665,2695,2925,2941,2958,2961,2967,3025,3114,3227,3249,3321,3353,3354,3373,3410,3426,3444,3454,3475,3476,3487,3510,3521,3604,3651,3663,3749,3831,3832,3898,3910,3984,4066,4381,4680,4698,4699,4726,4750,4810,5076,5160,5192,5221,5313,5348,5391,5393,5480,5560,5666,5730,5846,5894,5896,6038,6049,6309,6345,6353,6356,6370,6389,6469,6470,6492,6498,6531,6557,6575,6614,6664,6670,6671,6688,6730,6799,6802,6942,6965,7014,7052,7062,7069,7124,7156,7167,7200,7244,7287,7336,7338,7339,7340,7399,7411,7420,7421,7450,7556,7588,7596,7621,7624,7719,7725,7751,7776,7799,7831,7837,7850,7866,7889,7913,7914,8076,8080,8089,8149,8258,8259,8290,8319,8354,8373,8377,8386,8404,8417,8444,8458,8483,8551,8566,8577,8580,8617,8659,8759,8784,8808,8859,8860,8907,8909,8939,9028,9313,9364,9544,9552,9605,9629,9750,9756,9801,9849,9857,9924,9956,10030,10039,10090,10091,10114,10162,10274,10316,10576,10658,10689,10868,10890,10947,11030,11057,11138,11194,11195,11250,11253,11299,11408,11440,11441,11531,11532,11534,11618,11621,11632,11677,11693,11714,11727,11834,11857,11930,12011,12138,12141,12152,12205,12270,12318,12333,12479,12494,12499,12531,12534,12535,12620,12624,12628,12670,12685,12686,12708,12790,12811,12954,12973,13025,13064,13220,13224,13239,13246,13349,13363,13452,13477,13535,13567,13576,13744,13851,13898,13900,13974,13980,14016,14153,14192,14224,14263,14267,14338,14360,14374,14385,14496,14516,14534,14591,14601,14604,14705,14708,14754,14789,14795,14876,14992,15055,15080,15108,15128,15147,15217,15220,15300,15323,15347,15378,15440,15486,15493,15531,15533,15568,15589,15625,15632,15639,15712,15714,15751,15896,15899,15904,15943,15945,15952,15953,15992,16038,16051,16089,16156,16200,16216,16246,16267,16297,16303,16313,16361,16390,16398,16430,16497,16529,16538,16609,16652,16661,16714,16780,16813,16829,16851,16863,16866,16908,16928,16977,17038,17039,17043,17116,17126,17142,17148,17177,17209,17224,17234,17275,17282,17344,17349,17363,17381,17405,17422,17493,17496,17545,17573,17627,17661,17695,17699,17710,17734,17753,17812,17842,17883,17889,18071,18181,18187,18229,18249,18260,18309,18316,18318,18362,18363,18419,18421,18429,18452,18456,18494,18498,18509,18552,18556,18588,18605,18652,18675,18703,18750,18789,18801,18807,18816,18826,18833,18835,18845,18856,18864,18893,18904,18945,18953,18988,18989,19007,19024,19027,19040,19046,19056,19059,19135,19145,19189,19217,19226,19241,19260,19261,19282,19292,19303,19364,19370,19427,19437,19527,19655,19659,19695,19857,19870,19873,19883,19935,19940,19950,19972,19980,20006,20010,20020,20024,20033,20039,20043,20056,20115,20157,20230,20234,20237,20254,20356,20394,20402,20426,20452,20453,20503,20539,20559,20576,20643,20677,20681,20698,20823,20825,20833,20837,20866,20883,20905,20946,20947,21007,21049,21087,21094,21095,21118,21135,21194,21284,21285,21294,21328,21333,21368,21380,21384,21390,21422,21441,21491,21520,21583,21619,21664,21692,21699,21701,21711,21727,21732,21794,21796,21803,21809,21822,21825,21834,21836,21900,21907,21962,21998,22015,22020,22030,22035,22062,22081,22117,22140,22149,22164,22177,22202,22222,22225,22228,22324,22351,22359,22382,22384,22404,22415,22416,22421,22494,22502,22543,22565,22651,22698,22774,22804,22818,22829,22841,22898,22919,22926,22938,22985,23014,23028,23040,23053,23072,23089,23181,23294,23299,23304,23328,23369,23401,23453,23454,23530,23570,23574,23615,23633,23648,23668,23732,23807,23965,24025,24060,24127,24155,24164,24216,24228,24248,24356,24462,24477,24510,24523,24529,24535,24573,24580,24615,24685,24710,24763,24785,24919,25007,25062,25079,25099,25100,25110,25131,25170,25184,25278,25315,25334,25351,25398,25411,25420,25428,25463,25498,25506,25518,25584,25612,25640,25658,25694,25717,25736,25801,25842,25860,25874,25954,25995,26010,26123,26155,26195,26239,26360,26373,26403,26431,26534,26651,26753,26758,26947,26956,27039,27052,27137,27189,27337,27360,27364,27408,27454,27509,27518,27541,27548,27549,27624,27628,27743,27800,27846,28046,28240,28328,28616,28944,29366,29389,29464,29590,29630,30242,30482,30656,31623,31624,32056,32642,32643,32644,33065,33750,33954,33955,34016,34047,34180,34189,34251,34377,34391,34483,34502,34701,34733,34832,34935,34959,35010,35094,35175,35185,35192,35205,35310,35314,35321,35392,35557,35581,35658,35773,35790,35836,35847,35859,35876,35902,35930,35958,35982,36014,36031,36066,36227,36437,36531,36688,36714,36828,36888,36957,37024,37137,37344,37357,37365,37521,37543,37544,37579,37581,37642,37669,37693,37710,37731,37740,37767,37787,37802,37844,37852,37876,37932,37953,37999,38060,38185,38329,38346,38361,38370,38409,38430,38506,38512,38520,38567,38588,38623,38658,38659,38660,38734,38764,38779,38781,38788,38809,38815,38837,38842,38851,38861,38888,38956,39019,39023,39070,39114,39160,39185,39212,39346,39415,39416,39439,39491,39582,39625,39649,39670,39736,39757,39767,39820,39838,39849,39932,39934,39993,40003,40072,40073,40094,40111,40195,40302,40306,40345,40379,40404,40431,40494,40505,40508,40521,40638,40665,40699,40714,40831,40886,40897,40904,40970,40996,41023,41046,41051,41075,41078,41096,41142,41146,41159,41181,41190,41227,41245,41248,41251,41259,41273,41284,41297,41303,41313,41363,41370,41373,41391,41440,41508,41517,41660,41722,41726,41738,41739,41768,41811,41822,41851,41875,41959,41963,41972,41973,41981,41983,41997,42002,42010,42029,42113,42124,42136,42199,42232,42251,42275,42282,42303,42353,42380,42427,42430,42446,42462,42478,42484,42574,42604,42625,42768,42788,42880,43058,43083,43116,43143,43181,43182,43199,43216,43217,43236,43268,43312,43342,43347,43348,43434,43443,43455,43468,43471,43501,43507,43512,43527,43612,43617,43628,43629,43647,43684,43703,43704,43730,43742,43758,43800,43836,43875,43876,43877,43883,43927,44003,44045,44049,44050,44070,44073,44098,44239,44259,44338,44353,44356,44379,44389,44392,44437,44455,44521,44558,44570,44586,44603,44625,44658,44683,44691,44708,44748,44842,44853,44874,44907,44964,44989,45008,45055,45060,45147,45195,45251,45289,45301,45311)
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 | 1072 | 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.51 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.20 ms |
System lock | 0.02 ms |
optimizing | 0.08 ms |
statistics | 1.70 ms |
preparing | 0.85 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.32 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 |