Tiempo de la consulta: 4.12 ms Después de la última consulta: 0.83 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 4.315 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-05 10:06:02')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 10:06:02')
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,58,72,75,113,128,168,204,263,277,458,473,479,577,608,622,828,868,903,988,1080,1201,1205,1207,1220,1277,1329,1340,1348,1547,1643,1665,1697,1730,1731,1749,1776,1829,1976,2018,2163,2214,2227,2346,2569,2750,2792,2827,2857,3080,3255,3268,3270,3282,3302,3329,3425,3442,3456,3716,3732,3782,3825,3869,3880,3903,3947,3980,3986,4118,4173,4386,4417,4605,4707,4765,4803,4872,4912,5071,5085,5182,5207,5208,5302,5472,5529,5560,5647,5658,5698,5731,5827,5833,5877,5962,5992,6005,6038,6141,6163,6179,6221,6278,6279,6319,6335,6515,6517,6545,6564,6568,6575,6594,6616,6628,6632,6658,6739,6779,6791,6810,6813,6823,6889,6935,6969,6970,7045,7077,7105,7136,7150,7156,7191,7216,7270,7316,7325,7329,7360,7409,7429,7447,7463,7489,7564,7675,7743,7755,7759,7777,7811,7835,7895,7954,7982,8001,8010,8015,8035,8052,8083,8094,8123,8171,8188,8231,8268,8294,8417,8534,8584,8587,8662,8666,8758,8759,8819,8858,8901,8909,9015,9016,9030,9039,9077,9083,9086,9149,9199,9233,9264,9351,9378,9386,9443,9619,9626,9653,9654,9689,9754,9755,9801,9825,9853,9990,9995,10017,10035,10068,10109,10138,10139,10142,10192,10222,10359,10391,10439,10452,10485,10519,10706,10765,10810,10827,10854,10866,10892,10914,10926,10933,10961,10971,10982,10987,11038,11045,11101,11138,11171,11179,11189,11247,11268,11293,11312,11328,11399,11440,11443,11675,11685,11700,11717,11764,11857,11859,11912,11945,11951,11992,11997,12092,12149,12176,12187,12321,12340,12375,12476,12516,12596,12652,12657,12665,12672,12742,12794,12804,12818,12839,12892,12902,12912,12918,12926,12996,13021,13043,13055,13082,13093,13162,13218,13242,13243,13247,13260,13290,13306,13329,13371,13410,13454,13460,13479,13495,13529,13603,13646,13654,13698,13709,13733,13758,13772,13826,13909,13910,13911,13925,13926,13970,14055,14076,14096,14100,14115,14147,14148,14200,14202,14270,14291,14305,14335,14385,14392,14419,14470,14489,14521,14523,14531,14555,14556,14622,14639,14694,14727,14777,14841,14851,14886,14929,14959,14992,15051,15122,15131,15154,15166,15196,15204,15228,15269,15277,15301,15326,15354,15373,15401,15418,15450,15462,15465,15479,15498,15524,15531,15610,15632,15636,15713,15772,15787,15842,15864,15893,15900,15913,15926,15959,15969,15971,15979,16060,16112,16118,16128,16136,16145,16168,16199,16208,16224,16235,16283,16314,16327,16341,16366,16373,16405,16460,16468,16565,16659,16675,16686,16749,16872,16887,16922,16965,16979,16996,17042,17115,17125,17137,17183,17229,17234,17245,17276,17311,17318,17340,17359,17411,17434,17448,17457,17481,17494,17517,17519,17541,17554,17568,17594,17596,17666,17688,17707,17776,17815,17843,17894,17935,17943,17953,17956,17972,17993,18028,18048,18056,18069,18073,18104,18153,18221,18237,18244,18281,18296,18330,18352,18395,18408,18449,18518,18527,18539,18546,18547,18556,18563,18592,18594,18616,18627,18633,18640,18648,18662,18674,18675,18680,18683,18691,18722,18737,18746,18764,18767,18773,18777,18787,18789,18790,18812,18823,18825,18889,18896,18900,18938,18956,18960,18962,18969,18998,19029,19065,19073,19092,19109,19139,19153,19193,19195,19256,19266,19292,19303,19304,19336,19346,19370,19429,19469,19490,19510,19520,19537,19542,19544,19545,19553,19590,19610,19621,19637,19662,19685,19686,19717,19764,19765,19789,19798,19804,19809,19810,19843,19853,19883,19930,19935,19951,19968,19971,19995,20009,20060,20072,20075,20077,20103,20120,20164,20172,20195,20209,20250,20255,20313,20347,20365,20378,20398,20407,20426,20462,20496,20512,20559,20662,20685,20701,20795,20840,20870,20914,20939,20958,21019,21054,21106,21120,21141,21164,21179,21219,21238,21260,21274,21277,21348,21373,21387,21393,21407,21434,21446,21528,21552,21562,21563,21568,21583,21612,21632,21638,21652,21675,21697,21737,21741,21754,21784,21798,21817,21822,21830,21847,21868,21886,21923,21931,21948,21981,21989,21993,22006,22025,22055,22073,22094,22128,22147,22211,22220,22260,22286,22288,22294,22307,22319,22325,22336,22338,22352,22360,22379,22413,22482,22487,22504,22524,22558,22594,22638,22675,22687,22700,22728,22749,22755,22770,22778,22849,22861,22905,22956,23030,23045,23067,23079,23090,23128,23143,23163,23165,23206,23244,23255,23284,23303,23323,23330,23341,23366,23375,23386,23418,23443,23487,23524,23534,23545,23552,23635,23660,23735,23774,23819,23856,23913,23950,23994,24006,24013,24084,24142,24276,24293,24323,24325,24343,24347,24353,24413,24452,24475,24488,24495,24541,24638,24648,24698,24717,24767,24769,24770,24799,24803,24812,24828,24858,24877,24902,24947,24987,25010,25011,25012,25047,25056,25162,25208,25248,25263,25275,25280,25301,25313,25442,25480,25532,25602,25605,25696,25717,25719,25763,25799,25810,25882,25894,25923,25932,25991,26147,26209,26232,26408,26423,26471,26526,26573,26687,26725,26741,26748,26753,26765,26775,26793,26798,26813,26823,26844,26849,26858,26861,26922,26926,26928,26991,27014,27146,27152,27177,27181,27190,27264,27283,27319,27332,27362,27394,27468,27514,27517,27759,27931,27946,27954,28020,28327,28349,28607,28640,28677,28692,28765,28836,29022,29038,29105,29387,29454,29505,29724,30703,33290,33975,34946,35069,35617,35726,35758,36001,36159,36219,36280,36589,36592,36834,36851,37310,38364,38397,38738,38811,38856,38866,38903,38934,38999,39033,39035,39046,39048,39102,39111,39302,39413,39480,39544,39572,39614,39645,39650,39666,39753,39788,39858,39891,39907,40049,40097,40134,40297,40492,40558,40607,40787,40802,41041,41270,41304,41369,41644,41746,41855,42069,42125,42264,42415,42808,42870,43506,44226,44712,44982,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 | 941 | 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.56 ms |
checking permissions | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.19 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.53 ms |
preparing | 0.80 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.34 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 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 |