Tiempo de la consulta: 3.93 ms Después de la última consulta: 0.67 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.165 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 06:53:26')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 06:53:26')
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(11,60,61,62,63,64,65,67,68,72,138,141,272,278,281,331,332,344,350,373,380,385,417,522,583,586,686,697,717,723,757,826,828,841,844,857,978,986,996,1024,1133,1168,1187,1207,1208,1305,1319,1323,1506,1587,1698,1851,2005,2107,2112,2272,2394,2610,2925,2962,3256,3265,3340,3353,3354,3476,3483,3619,3626,3644,3678,3696,3731,3875,3890,3982,4119,4420,4563,4587,4680,4698,4945,5058,5160,5192,5313,5666,5730,5814,5846,5894,5896,6381,6389,6470,6498,6531,6539,6570,6575,6688,6730,6748,6799,6802,6942,6965,7014,7052,7069,7124,7125,7156,7200,7244,7257,7296,7336,7339,7340,7411,7420,7421,7432,7450,7556,7588,7621,7624,7719,7725,7751,7776,7799,7801,7831,7837,7838,7839,7850,7860,7866,7889,7931,7946,7965,7981,7985,8089,8230,8258,8259,8354,8377,8386,8417,8472,8531,8555,8566,8580,8617,8648,8696,8759,8860,8909,9150,9275,9532,9552,9556,9750,9801,9895,9924,9944,9945,9956,10030,10114,10122,10162,10243,10274,10280,10316,10383,10497,10549,10561,10751,10834,10868,11030,11057,11102,11129,11155,11194,11250,11253,11254,11377,11408,11440,11441,11469,11482,11565,11583,11688,11711,11714,11822,11831,11857,11860,11941,12011,12042,12150,12238,12318,12337,12424,12501,12565,12620,12624,12628,12668,12670,12685,12686,12708,12780,12811,12867,12944,12973,13004,13152,13153,13224,13239,13246,13349,13452,13657,13748,13750,13783,13816,13851,13900,13924,13934,14103,14153,14192,14224,14263,14267,14276,14385,14424,14516,14570,14591,14596,14601,14708,14754,14795,14895,14958,14992,15038,15055,15080,15108,15114,15145,15147,15183,15217,15244,15347,15359,15368,15378,15440,15486,15493,15522,15577,15632,15639,15645,15669,15712,15714,15843,15899,15904,15952,15953,15957,15975,16038,16083,16089,16156,16200,16201,16216,16241,16267,16297,16303,16313,16322,16334,16390,16430,16446,16464,16497,16520,16556,16609,16629,16684,16714,16780,16791,16813,16830,16861,16863,16866,16918,16928,16974,17038,17039,17116,17126,17142,17148,17209,17210,17234,17253,17275,17282,17344,17362,17363,17381,17405,17422,17443,17471,17496,17521,17573,17581,17627,17630,17655,17661,17699,17710,17713,17734,17761,17812,17836,17889,17933,17994,18162,18181,18187,18229,18249,18260,18285,18300,18311,18316,18318,18362,18364,18419,18421,18429,18452,18467,18494,18498,18509,18520,18552,18556,18567,18588,18605,18652,18671,18675,18720,18750,18762,18801,18807,18816,18826,18828,18845,18856,18864,18904,18945,18953,18988,18989,19002,19007,19024,19027,19040,19047,19056,19059,19060,19067,19135,19145,19148,19170,19180,19185,19189,19217,19226,19253,19260,19261,19276,19282,19292,19303,19327,19352,19364,19370,19376,19412,19427,19437,19457,19460,19527,19532,19577,19620,19633,19655,19659,19668,19687,19732,19811,19857,19870,19873,19883,19908,19909,19940,19950,19972,19980,19998,20006,20010,20020,20024,20028,20032,20033,20039,20043,20056,20086,20115,20141,20156,20170,20187,20234,20237,20254,20256,20263,20271,20289,20353,20356,20394,20402,20426,20449,20450,20516,20535,20539,20559,20564,20630,20677,20681,20714,20729,20823,20837,20866,20946,20947,20982,21007,21049,21050,21087,21094,21095,21118,21135,21173,21189,21194,21198,21225,21294,21314,21368,21380,21384,21390,21422,21432,21491,21513,21520,21545,21583,21611,21620,21636,21640,21664,21678,21692,21694,21701,21711,21727,21732,21738,21764,21768,21836,21854,21907,21950,21980,21998,22015,22020,22030,22035,22062,22081,22100,22117,22137,22140,22146,22149,22164,22177,22222,22225,22228,22229,22297,22324,22337,22351,22359,22361,22382,22404,22415,22416,22502,22543,22559,22647,22651,22673,22698,22712,22774,22804,22841,22898,22903,22908,22919,22980,22985,22988,23014,23028,23053,23072,23089,23181,23186,23275,23281,23294,23295,23299,23304,23328,23369,23374,23401,23402,23495,23555,23585,23610,23615,23633,23636,23668,23732,23764,23840,23845,23858,23965,24025,24028,24059,24060,24127,24155,24164,24194,24248,24305,24342,24356,24451,24489,24523,24540,24573,24580,24586,24613,24615,24639,24653,24707,24710,24785,24791,24804,24884,24897,25007,25045,25062,25079,25091,25099,25100,25170,25184,25264,25278,25315,25411,25420,25428,25463,25492,25498,25584,25640,25694,25702,25775,25872,25906,25954,26164,26172,26201,26239,26315,26360,26431,26621,26640,26651,26708,26807,26947,27086,27141,27143,27189,27364,27433,27454,27518,27541,27560,27600,27624,27628,27743,27846,28046,28240,28328,28336,28454,28495,28616,28679,28882,28944,29389,29412,29454,29590,29747,29802,29804,30482,30656,30740,31129,31604,31623,31624,32472,32905,35603,39625,40404,41148,41363)
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 | 774 | 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.38 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.16 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 1.16 ms |
preparing | 0.63 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.31 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.05 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 |