Tiempo de la consulta: 3.56 ms Después de la última consulta: 0.66 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.162 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-07 08:22:19')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 08:22:19')
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(33,34,35,39,40,41,42,43,75,128,174,263,277,280,458,615,832,868,903,941,988,1073,1078,1080,1201,1207,1220,1257,1277,1329,1340,1697,1753,1805,1941,1976,2029,2371,2428,2750,2773,2794,2827,2857,2893,2980,3080,3234,3255,3302,3329,3442,3716,3732,3733,3782,3880,3883,3931,3980,3986,4028,4063,4093,4182,4260,4268,4302,4358,4405,4765,4872,5085,5182,5207,5208,5257,5302,5472,5576,5647,5658,5698,5827,5833,5877,5879,5889,5967,6084,6141,6278,6279,6319,6515,6517,6594,6616,6628,6632,6658,6719,6780,6791,6833,6935,6969,6978,7045,7077,7105,7136,7150,7270,7329,7365,7429,7447,7536,7554,7627,7675,7743,7777,7835,7895,7954,7978,8052,8083,8231,8306,8406,8759,8765,8851,8858,8909,9039,9111,9114,9351,9398,9444,9454,9480,9604,9741,9770,9853,9901,9928,9981,10068,10138,10192,10211,10217,10222,10347,10402,10439,10452,10479,10485,10519,10650,10696,10758,10810,10827,10842,10863,10926,10971,10987,11032,11038,11045,11101,11140,11171,11179,11189,11239,11289,11293,11328,11398,11399,11421,11542,11675,11717,11723,11764,11794,11838,11859,11912,11945,11951,11990,11992,12004,12034,12092,12176,12206,12321,12340,12516,12657,12665,12773,12794,12804,12852,12902,12912,13043,13055,13082,13162,13218,13242,13243,13306,13329,13371,13410,13460,13495,13529,13603,13663,13698,13709,13710,13733,13758,13765,13772,13826,13911,13925,13926,13970,14037,14076,14083,14096,14115,14147,14148,14154,14200,14202,14255,14270,14284,14291,14385,14470,14489,14521,14523,14555,14556,14609,14639,14766,14811,14851,14959,15002,15009,15051,15115,15122,15154,15257,15269,15272,15286,15301,15326,15354,15373,15378,15411,15418,15488,15498,15499,15632,15633,15643,15732,15787,15842,15857,15893,15900,15907,15913,15926,15979,15980,16060,16112,16128,16145,16168,16199,16208,16235,16283,16327,16341,16356,16359,16366,16373,16394,16405,16460,16468,16535,16659,16686,16784,16805,16887,16922,16955,16965,16996,17004,17042,17115,17125,17183,17229,17276,17318,17327,17359,17411,17423,17429,17434,17438,17457,17494,17519,17541,17554,17568,17596,17707,17730,17781,17815,17873,17935,17953,17972,17993,18048,18056,18069,18073,18145,18153,18155,18230,18244,18281,18296,18352,18395,18408,18449,18492,18518,18527,18539,18563,18570,18576,18581,18592,18594,18607,18617,18627,18640,18648,18674,18680,18697,18722,18737,18739,18746,18765,18773,18790,18812,18823,18825,18889,18896,18900,18915,18938,18952,18960,18998,19011,19026,19029,19050,19057,19089,19109,19139,19195,19202,19256,19266,19346,19370,19374,19401,19411,19469,19490,19510,19537,19542,19590,19594,19610,19621,19648,19662,19682,19683,19713,19770,19809,19810,19825,19883,19930,19944,19951,19971,19995,20009,20075,20102,20131,20164,20172,20179,20195,20241,20280,20313,20347,20365,20378,20398,20407,20416,20446,20462,20496,20510,20512,20589,20662,20685,20701,20795,20840,20870,20914,20919,20939,20951,20958,20962,21003,21019,21054,21067,21072,21106,21120,21141,21146,21163,21164,21171,21179,21219,21238,21239,21274,21311,21348,21373,21379,21407,21411,21446,21450,21455,21467,21490,21511,21552,21562,21563,21568,21583,21592,21612,21638,21675,21713,21737,21775,21789,21820,21886,21890,21923,21931,21948,21981,22001,22025,22029,22065,22073,22094,22128,22168,22177,22181,22211,22272,22286,22294,22307,22319,22325,22338,22352,22360,22379,22387,22487,22504,22515,22558,22594,22664,22675,22687,22688,22700,22733,22749,22770,22778,22783,22787,22849,22861,22863,22880,22956,23030,23042,23045,23066,23067,23075,23079,23090,23109,23128,23152,23163,23165,23244,23255,23278,23284,23303,23323,23330,23341,23362,23366,23375,23386,23403,23418,23443,23487,23534,23545,23576,23635,23660,23696,23735,23819,23856,23913,23950,23987,23992,23994,24006,24013,24035,24059,24084,24142,24235,24276,24293,24313,24325,24347,24353,24452,24475,24495,24638,24674,24698,24717,24767,24769,24770,24812,24828,24858,24877,24902,24947,24987,24999,25011,25012,25024,25056,25162,25208,25248,25263,25280,25301,25313,25347,25442,25696,25732,25763,25799,25810,25882,25932,26423,26741,26765,26861,26928,27014,27152,27236,27279,27283,27319,27362,27394,27418,27427,27517,27759,27954,28020,28161,28420,28607,28640,28677,28692,28765,28922,29387,29475,29486,29719,29832,35617,35726,36834,38866,38903,39033,39035,39048,39111,39195,39335,39413,39480,39544,39572,39645,39650,39666,39891,39907,40441,40558,41092,41219)
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 | 738 | 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.02 ms |
init | 0.15 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 1.20 ms |
preparing | 0.55 ms |
Sorting result | 0.01 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.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 |