Tiempo de la consulta: 3.78 ms Después de la última consulta: 0.68 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.307 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-08 09:07:52')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-08 09:07:52')
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(4,21,197,260,263,287,394,465,563,739,770,1296,1348,1503,1538,1714,1718,1804,1900,1948,2258,2305,2424,2482,2807,2957,3319,3499,3575,3739,3802,3806,3939,4033,4093,4100,4131,4180,4205,4237,4243,4280,4311,4334,4337,4339,4341,4419,4473,4493,4533,4568,4594,4612,4613,4614,4615,4617,4650,4820,4836,4840,4936,4940,4980,4982,4990,5005,5086,5109,5115,5121,5131,5150,5173,5199,5210,5258,5274,5329,5337,5372,5455,5461,5502,5504,5530,5536,5598,5704,5783,5796,5814,5816,5825,5835,5857,5908,5913,5934,5940,5941,5959,5973,5979,5996,6009,6020,6051,6064,6070,6135,6159,6167,6274,6291,6294,6356,6361,6372,6427,6446,6465,6468,6470,6479,6492,6603,6616,6630,6646,6695,6744,6750,6776,6826,6881,6902,6927,6980,6985,7085,7148,7215,7218,7231,7232,7234,7243,7246,7249,7266,7285,7289,7319,7328,7330,7333,7334,7344,7346,7357,7364,7367,7368,7370,7371,7374,7377,7379,7380,7394,7396,7406,7407,7408,7410,7413,7414,7415,7416,7417,7422,7430,7431,7435,7436,7447,7450,7455,7456,7457,7458,7463,7464,7465,7486,7489,7545,7546,7552,7553,7555,7565,7570,7577,7583,7586,7615,7625,7659,7678,7682,7683,7691,7715,7720,7735,7744,7746,7749,7757,7768,7793,7799,7813,7830,7833,7834,7835,7851,7854,7863,7871,7891,7894,7895,7900,7901,7919,7955,7957,7961,7962,7979,7982,8020,8022,8023,8024,8049,8060,8067,8072,8092,8116,8137,8151,8167,8170,8280,8331,8341,8362,8388,8391,8470,8517,8539,8575,8595,8649,8652,8687,8698,8742,8755,8765,8794,8806,8875,8913,8922,8953,8965,9009,9024,9059,9070,9096,9140,9211,9218,9253,9303,9344,9365,9385,9568,9651,9658,9681,9734,9777,9877,9907,9952,9996,10040,10133,10146,10186,10197,10199,10205,10207,10209,10221,10243,10271,10349,10387,10400,10420,10522,10604,10745,10755,10840,10906,11071,11119,11168,11192,11351,11404,11458,11745,11864,11972,11987,12003,12112,12144,12216,12226,12435,12488,12527,12609,12614,12617,12638,12649,12753,12884,12902,12935,12944,12978,13141,13154,13325,13327,13375,13535,13667,13685,13930,13968,13972,14048,14052,14123,14183,14250,14267,14366,14401,14417,14421,14426,14431,14505,14596,14662,14680,14692,14713,14770,14849,14865,14946,14953,14973,14974,15015,15038,15039,15046,15132,15262,15293,15310,15318,15352,15533,15580,15594,15673,15689,15736,15797,15808,15812,15835,15845,15866,15874,15902,15916,15917,15933,15947,16050,16055,16092,16103,16172,16240,16321,16335,16377,16410,16415,16422,16440,16458,16465,16499,16520,16584,16777,16789,16907,16919,16926,17075,17080,17130,17135,17141,17186,17212,17245,17291,17335,17344,17476,17561,17584,17590,17607,17661,17672,17691,17700,17824,17883,17902,17941,17999,18150,18220,18226,18227,18353,18356,18360,18379,18386,18388,18442,18482,18509,18522,18530,18558,18576,18578,18579,18589,18705,18712,18730,18731,18735,18750,18795,18825,18846,18873,18905,19101,19115,19118,19128,19243,19426,19472,19484,19487,19542,19589,19643,19651,19728,19772,19848,19862,19967,20066,20074,20090,20191,20220,20244,20289,20385,20592,20599,20634,20734,20869,20885,20890,21028,21087,21131,21198,21259,21300,21389,21456,21579,21602,21624,21667,21712,21716,21843,21952,22098,22116,22210,22212,22262,22289,22290,22329,22514,22602,22659,22689,22693,22753,22886,22914,22918,22936,22959,22966,23072,23092,23107,23123,23212,23214,23229,23261,23305,23364,23571,23725,23729,23756,23790,23849,23871,23885,23909,23915,23921,23947,23949,23969,24062,24161,24187,24211,24223,24337,24361,24394,24526,24567,24595,24619,24678,24736,24738,24785,24801,24834,24915,25016,25046,25097,25178,25227,25258,25294,25538,25555,25648,25734,25747,25766,25818,25871,25934,25941,25990,26000,26013,26040,26161,26335,26359,26368,26386,26409,26579,26609,26646,26744,26820,26827,26845,26868,26873,26968,27065,27074,27126,27347,27404,27407,27492,27512,27604,27605,27749,27789,28153,28441,28468,28799,28800,28846,29028,29419,30194,30988,31798,31853,33416,35639,35640,35643,35743,35744,35752,36075,36128,36208,36298,36581,36584,37759,38362,38912,39224,39240,39254,39600,39956,39969,39987,41148,41171,44564,44785)
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 | 703 | 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.42 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.16 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.17 ms |
preparing | 0.55 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 |