Tiempo de la consulta: 3.87 ms Después de la última consulta: 0.90 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 4.176 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:25:37')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 05:25:37')
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,72,75,113,128,168,204,263,277,458,473,479,577,608,622,828,868,903,988,1080,1201,1205,1207,1220,1277,1286,1329,1340,1348,1665,1697,1749,1976,2018,2163,2214,2227,2353,2569,2687,2750,2827,2857,2976,3062,3080,3160,3255,3268,3302,3311,3329,3425,3442,3456,3516,3611,3685,3716,3732,3782,3825,3830,3869,3880,3961,3980,3986,4113,4118,4405,4417,4707,4765,4872,5085,5182,5207,5208,5250,5302,5458,5472,5529,5560,5647,5658,5698,5731,5827,5833,5877,5962,6005,6038,6141,6163,6172,6179,6221,6278,6279,6319,6335,6515,6517,6545,6556,6575,6594,6616,6628,6632,6658,6739,6791,6810,6889,6935,6969,6970,7045,7077,7082,7083,7105,7136,7150,7156,7191,7270,7325,7329,7360,7398,7409,7429,7447,7451,7463,7564,7607,7675,7694,7743,7755,7759,7777,7811,7820,7835,7895,7954,7982,8001,8015,8052,8083,8140,8171,8268,8294,8417,8516,8534,8587,8662,8666,8758,8759,8819,8858,8901,8909,9015,9016,9030,9039,9077,9083,9086,9130,9138,9149,9199,9207,9233,9267,9351,9444,9510,9599,9619,9626,9633,9653,9654,9689,9754,9755,9770,9812,9853,9990,10035,10068,10138,10139,10192,10222,10439,10452,10485,10706,10765,10787,10810,10827,10848,10854,10902,10926,10971,10982,10987,11038,11045,11101,11138,11171,11179,11189,11196,11247,11268,11293,11312,11328,11399,11435,11440,11443,11604,11675,11700,11707,11717,11753,11764,11857,11912,11945,11951,11992,12073,12092,12149,12176,12321,12340,12375,12476,12516,12657,12665,12672,12683,12794,12804,12818,12839,12892,12902,12912,12918,12926,13031,13043,13055,13082,13096,13162,13204,13218,13242,13243,13247,13306,13329,13371,13410,13454,13460,13495,13529,13603,13633,13646,13654,13698,13709,13733,13758,13772,13826,13911,13925,13926,13940,13970,14055,14076,14096,14100,14115,14147,14148,14200,14202,14270,14274,14291,14305,14369,14385,14392,14419,14470,14489,14521,14523,14555,14556,14639,14650,14694,14799,14841,14851,14877,14959,14979,14992,15051,15122,15154,15196,15204,15228,15256,15269,15301,15326,15354,15373,15418,15450,15453,15462,15465,15479,15498,15524,15538,15632,15641,15668,15765,15787,15842,15864,15876,15893,15900,15913,15926,15969,15971,15979,16060,16112,16118,16128,16145,16168,16199,16208,16224,16235,16283,16327,16341,16366,16373,16405,16460,16468,16535,16565,16659,16686,16749,16785,16856,16887,16922,16965,16979,16996,17016,17042,17115,17122,17125,17137,17183,17229,17234,17276,17311,17318,17337,17411,17434,17448,17457,17481,17494,17496,17517,17519,17541,17554,17568,17594,17596,17666,17688,17707,17776,17815,17843,17880,17894,17935,17943,17953,17956,17972,17993,18028,18048,18056,18069,18073,18104,18153,18221,18237,18244,18281,18296,18352,18395,18408,18432,18449,18492,18518,18527,18539,18546,18547,18563,18583,18592,18627,18640,18648,18662,18674,18680,18683,18691,18722,18737,18746,18764,18767,18773,18777,18790,18812,18823,18825,18889,18896,18900,18938,18952,18956,18960,18962,18969,18998,19029,19065,19092,19109,19139,19153,19193,19195,19202,19219,19254,19256,19266,19292,19303,19304,19334,19336,19346,19370,19415,19469,19476,19490,19510,19519,19520,19537,19542,19544,19545,19553,19572,19590,19610,19621,19637,19662,19683,19685,19686,19717,19764,19765,19789,19798,19804,19809,19810,19843,19844,19853,19883,19930,19951,19968,19971,19995,20009,20072,20075,20077,20120,20164,20172,20180,20195,20205,20209,20250,20255,20277,20291,20313,20347,20365,20378,20398,20407,20426,20462,20496,20512,20662,20685,20701,20727,20795,20840,20870,20914,20939,20958,21016,21019,21054,21106,21120,21141,21164,21179,21219,21226,21238,21260,21274,21277,21298,21348,21373,21387,21407,21434,21446,21450,21528,21552,21562,21563,21568,21583,21612,21632,21638,21652,21675,21697,21737,21741,21754,21784,21798,21817,21822,21830,21847,21856,21868,21886,21923,21931,21948,21981,21989,21993,22025,22055,22073,22094,22128,22147,22211,22220,22260,22286,22294,22307,22319,22325,22338,22352,22360,22379,22387,22487,22493,22504,22524,22558,22594,22638,22675,22687,22700,22728,22733,22755,22770,22778,22807,22818,22821,22849,22861,22862,22905,22956,23030,23045,23067,23079,23090,23111,23128,23143,23163,23165,23183,23244,23255,23284,23303,23323,23330,23341,23366,23375,23386,23390,23418,23443,23487,23524,23534,23545,23552,23635,23637,23660,23731,23735,23819,23856,23913,23950,23994,24006,24013,24084,24142,24276,24293,24323,24325,24347,24353,24452,24475,24488,24495,24509,24541,24674,24698,24717,24767,24769,24770,24812,24828,24858,24873,24877,24902,24932,24935,24947,24987,25011,25012,25021,25047,25056,25162,25171,25177,25208,25248,25263,25280,25301,25313,25442,25605,25653,25696,25717,25719,25763,25785,25799,25814,25882,25932,25988,26190,26408,26423,26725,26741,26748,26753,26765,26775,26793,26798,26813,26823,26844,26849,26858,26861,26922,26926,26928,26936,27014,27146,27152,27177,27232,27264,27283,27319,27362,27394,27468,27514,27517,27759,27795,27946,27954,28020,28080,28327,28432,28607,28640,28677,28692,28765,29022,29066,29387,29454,29505,30703,33975,34946,35604,35617,35726,35758,35947,36001,36219,36280,36834,38856,38866,38903,38999,39033,39035,39046,39048,39111,39302,39413,39480,39572,39614,39645,39650,39666,39753,39788,39891,39907,40049,40097,40134,40297,40492,40558,40607,41270,41304,41644,41855,42173,43010,43506,44226,45026)
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 | 898 | 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.49 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.43 ms |
preparing | 0.74 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.35 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.05 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 |