Tiempo de la consulta: 3.66 ms Después de la última consulta: 0.68 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 4.185 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-09 01:09:10')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 01:09:10')
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(66,72,127,138,141,174,328,332,373,374,495,522,583,647,723,757,826,828,841,986,996,1078,1133,1207,1323,1363,1587,1693,1897,1919,1941,1994,2029,2042,2107,2272,2285,2337,2371,2533,2608,2610,2695,2894,2925,2967,3109,3174,3296,3353,3354,3379,3476,3629,3782,3796,3806,3812,3931,3986,4209,4358,4680,4698,4953,5160,5180,5192,5209,5257,5311,5313,5470,5536,5586,5666,5729,5730,5748,5782,5846,5865,5894,5896,5931,6141,6217,6319,6389,6396,6432,6470,6498,6531,6539,6575,6675,6688,6719,6730,6799,6802,6833,6863,6942,6965,6978,7014,7038,7052,7069,7086,7094,7124,7156,7200,7244,7299,7336,7339,7340,7374,7411,7420,7421,7450,7541,7554,7556,7576,7588,7621,7624,7719,7725,7751,7776,7799,7818,7831,7837,7850,7866,7889,7910,7932,7978,7981,8089,8095,8119,8231,8258,8259,8354,8377,8386,8417,8566,8580,8617,8625,8655,8759,8851,8858,8860,8909,8936,8973,8978,9039,9043,9050,9148,9446,9450,9476,9492,9512,9552,9604,9645,9722,9750,9770,9801,9804,9828,9901,9908,9924,9956,10030,10089,10114,10123,10146,10162,10211,10222,10274,10295,10307,10316,10347,10506,10519,10582,10650,10696,10721,10758,10827,10846,10868,10904,10958,11030,11057,11068,11194,11238,11239,11250,11253,11261,11268,11289,11299,11408,11425,11440,11441,11695,11714,11773,11857,11898,11919,11951,11957,11958,11981,12004,12011,12117,12318,12600,12620,12621,12624,12628,12670,12685,12686,12705,12708,12760,12773,12811,12973,13032,13095,13111,13224,13239,13246,13349,13452,13562,13663,13838,13851,13877,13900,13977,14048,14153,14181,14192,14200,14224,14253,14263,14267,14284,14385,14440,14488,14497,14516,14526,14591,14601,14609,14708,14754,14795,14839,14851,14898,14903,14946,14956,14992,15009,15055,15080,15108,15115,15122,15147,15217,15236,15260,15336,15347,15391,15411,15440,15451,15486,15493,15499,15512,15527,15613,15632,15639,15643,15712,15714,15772,15857,15864,15899,15904,15907,15952,15953,16038,16089,16092,16111,16112,16156,16200,16216,16233,16250,16267,16297,16303,16313,16320,16341,16343,16359,16390,16416,16425,16430,16494,16495,16497,16565,16609,16659,16686,16705,16714,16780,16795,16805,16813,16863,16866,16925,16928,17004,17038,17039,17115,17116,17126,17142,17148,17209,17234,17275,17282,17344,17363,17381,17405,17411,17422,17429,17434,17457,17459,17496,17573,17614,17618,17627,17661,17699,17710,17734,17812,17889,18032,18102,18135,18144,18155,18156,18181,18187,18229,18230,18249,18260,18261,18296,18316,18318,18352,18362,18379,18380,18419,18421,18429,18447,18452,18479,18492,18494,18498,18509,18552,18556,18588,18605,18652,18675,18737,18739,18750,18773,18801,18807,18816,18820,18826,18845,18848,18856,18864,18900,18904,18915,18945,18953,18988,18989,18997,18998,19007,19024,19027,19037,19040,19056,19059,19135,19145,19189,19217,19226,19260,19261,19282,19292,19303,19304,19364,19370,19401,19427,19437,19527,19535,19538,19539,19590,19594,19638,19655,19659,19682,19683,19809,19825,19857,19873,19883,19931,19940,19944,19950,19972,19980,20006,20010,20020,20024,20033,20039,20043,20056,20058,20059,20102,20103,20115,20131,20164,20234,20237,20241,20250,20254,20280,20356,20361,20394,20402,20416,20426,20446,20539,20559,20646,20677,20681,20701,20818,20823,20837,20850,20866,20914,20939,20946,20947,21003,21007,21020,21049,21087,21094,21095,21118,21135,21194,21202,21219,21229,21274,21294,21368,21373,21380,21384,21390,21422,21446,21491,21511,21520,21583,21664,21692,21701,21711,21727,21732,21740,21820,21836,21890,21907,21921,21960,21969,21998,22015,22020,22030,22035,22062,22065,22081,22094,22101,22117,22140,22149,22164,22168,22177,22211,22222,22225,22228,22294,22324,22351,22359,22379,22382,22404,22415,22416,22485,22499,22502,22515,22543,22546,22651,22686,22688,22690,22698,22749,22787,22804,22841,22880,22898,22919,22985,23014,23028,23053,23067,23072,23089,23090,23152,23163,23181,23225,23294,23299,23304,23328,23369,23375,23401,23403,23576,23612,23615,23633,23635,23668,23684,23722,23732,23735,23817,23954,23965,23978,23992,24013,24025,24035,24059,24060,24083,24127,24155,24164,24192,24248,24313,24353,24356,24452,24499,24523,24573,24580,24607,24615,24698,24710,24771,24785,24957,25007,25062,25079,25099,25100,25170,25184,25278,25301,25315,25411,25420,25428,25463,25498,25584,25640,25694,25732,25810,25862,25932,25954,26210,26239,26259,26360,26431,26573,26629,26638,26651,26741,26778,26947,27073,27152,27189,27319,27364,27418,27424,27427,27454,27518,27541,27624,27628,27743,27759,27846,27954,27997,28046,28161,28198,28240,28328,28420,28616,28636,28692,28917,28944,29358,29389,29475,29590,29811,30482,30656,31172,31623,31624,33081,35595,35602,35617,36021,36161,37083,37913,37992,38082,38138,38213,38595,38866,38903,39033,39413,39446,39544,39571,39625,39913,39917,40285,40388,40404,40721,40772,40773,41363,41808,42914,44722,44903,44906,45164)
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 | 817 | 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.41 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.23 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 1.34 ms |
preparing | 0.67 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.33 ms |
end | 0.01 ms |
query end | 0.01 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 |