Tiempo de la consulta: 4.16 ms Después de la última consulta: 0.92 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 4.326 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-03 19:08:28')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-03 19:08:28')
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,70,72,75,113,126,127,128,168,174,204,252,261,263,277,458,473,479,577,608,622,828,868,903,945,946,988,1078,1080,1201,1205,1207,1220,1277,1329,1340,1348,1665,1697,1749,1941,1976,2018,2029,2163,2214,2227,2371,2569,2705,2750,2827,2857,2872,2875,3080,3125,3135,3255,3268,3302,3329,3425,3442,3456,3595,3716,3732,3782,3788,3825,3869,3880,3931,3980,3986,4036,4118,4217,4268,4358,4417,4707,4722,4765,4868,4872,4948,4966,5085,5105,5182,5207,5208,5257,5300,5302,5364,5472,5529,5560,5647,5658,5698,5718,5731,5823,5827,5833,5849,5877,5962,6005,6038,6141,6163,6210,6221,6238,6278,6279,6319,6335,6439,6487,6515,6517,6545,6575,6594,6611,6616,6628,6632,6658,6719,6739,6791,6810,6833,6889,6935,6969,6970,6978,7045,7077,7105,7136,7150,7156,7191,7270,7325,7329,7360,7409,7429,7447,7463,7502,7550,7554,7564,7675,7743,7755,7759,7777,7811,7835,7858,7895,7919,7954,7978,7982,8001,8015,8052,8083,8171,8231,8247,8268,8294,8406,8417,8534,8587,8662,8666,8749,8758,8759,8771,8819,8851,8858,8863,8901,8909,9015,9016,9030,9039,9077,9083,9086,9123,9149,9199,9207,9233,9320,9351,9489,9604,9619,9626,9653,9654,9689,9754,9755,9770,9853,9901,9990,10035,10068,10070,10075,10138,10139,10192,10211,10222,10271,10291,10347,10439,10452,10485,10519,10532,10650,10696,10699,10706,10758,10765,10810,10827,10854,10924,10926,10965,10971,10982,10987,11038,11045,11101,11138,11171,11179,11189,11239,11247,11261,11268,11289,11293,11312,11328,11399,11440,11443,11519,11625,11675,11700,11717,11764,11857,11912,11945,11951,11990,11992,12004,12092,12149,12176,12321,12340,12375,12379,12476,12516,12554,12599,12657,12665,12672,12773,12794,12804,12818,12839,12892,12902,12912,12918,12926,12964,13043,13055,13082,13118,13162,13218,13242,13243,13247,13306,13329,13371,13410,13454,13460,13495,13529,13603,13605,13617,13646,13654,13663,13698,13709,13733,13758,13772,13826,13838,13911,13925,13926,13970,14055,14076,14096,14100,14115,14147,14148,14200,14202,14270,14284,14291,14305,14350,14385,14392,14419,14470,14489,14521,14523,14540,14555,14556,14609,14639,14694,14839,14841,14851,14859,14959,14992,15009,15051,15115,15122,15154,15196,15204,15228,15269,15287,15301,15326,15354,15373,15374,15378,15411,15418,15450,15462,15465,15479,15498,15499,15524,15632,15643,15787,15842,15857,15864,15893,15900,15907,15913,15926,15969,15971,15979,16060,16112,16118,16128,16145,16168,16199,16208,16224,16235,16283,16295,16327,16341,16356,16359,16366,16371,16373,16405,16460,16468,16533,16535,16565,16659,16686,16714,16749,16803,16805,16887,16922,16925,16965,16979,16996,17004,17042,17115,17125,17137,17183,17229,17234,17271,17276,17311,17318,17411,17429,17434,17448,17457,17459,17481,17494,17517,17519,17541,17554,17568,17594,17596,17607,17614,17666,17688,17707,17745,17776,17815,17832,17894,17897,17908,17935,17943,17953,17956,17972,17993,18028,18048,18056,18069,18073,18104,18118,18153,18155,18221,18230,18237,18244,18281,18296,18352,18395,18408,18449,18492,18499,18518,18527,18539,18546,18547,18563,18592,18594,18627,18640,18648,18662,18674,18680,18683,18690,18691,18722,18737,18739,18746,18764,18765,18767,18773,18777,18790,18812,18823,18825,18889,18896,18900,18915,18921,18938,18956,18960,18962,18969,18998,19029,19065,19078,19092,19109,19139,19153,19193,19195,19202,19256,19266,19291,19292,19303,19304,19336,19346,19370,19401,19469,19488,19490,19510,19520,19537,19542,19544,19545,19553,19590,19594,19605,19610,19621,19623,19637,19662,19682,19683,19685,19686,19693,19717,19764,19765,19770,19789,19790,19798,19804,19806,19809,19810,19825,19843,19853,19883,19930,19951,19968,19971,19995,20009,20072,20075,20077,20102,20120,20131,20164,20172,20195,20209,20241,20250,20255,20280,20313,20347,20365,20378,20398,20407,20416,20426,20429,20446,20458,20462,20496,20512,20662,20685,20701,20795,20816,20840,20870,20891,20914,20939,20958,21003,21019,21054,21101,21106,21120,21141,21164,21179,21219,21238,21257,21260,21274,21277,21348,21373,21387,21407,21434,21446,21481,21511,21528,21552,21562,21563,21568,21571,21583,21592,21612,21632,21638,21651,21652,21675,21697,21737,21741,21754,21784,21798,21817,21820,21822,21830,21847,21868,21886,21890,21915,21923,21931,21948,21981,21989,21993,22025,22055,22065,22073,22094,22100,22128,22147,22168,22177,22211,22220,22260,22286,22294,22307,22319,22325,22338,22352,22360,22379,22387,22487,22504,22515,22524,22558,22594,22596,22638,22664,22675,22687,22688,22700,22728,22749,22755,22770,22778,22787,22822,22849,22858,22861,22880,22905,22956,23028,23030,23044,23045,23050,23067,23079,23090,23128,23143,23152,23163,23165,23244,23255,23284,23303,23323,23330,23341,23366,23375,23386,23403,23418,23443,23487,23524,23534,23545,23552,23576,23635,23660,23695,23819,23822,23856,23913,23950,23992,23994,24006,24013,24035,24059,24081,24084,24142,24266,24276,24293,24313,24321,24323,24325,24347,24353,24452,24475,24488,24495,24541,24638,24698,24717,24767,24769,24770,24771,24812,24828,24858,24877,24889,24902,24947,24987,24999,25011,25012,25041,25047,25056,25162,25208,25248,25263,25280,25301,25313,25442,25605,25696,25717,25719,25725,25732,25763,25799,25810,25882,25909,25932,26078,26395,26408,26423,26629,26725,26741,26748,26753,26765,26775,26793,26798,26813,26823,26844,26849,26858,26861,26912,26922,26926,26928,27014,27146,27152,27177,27264,27283,27319,27350,27362,27394,27418,27427,27466,27468,27514,27517,27749,27759,27946,27954,28020,28104,28161,28327,28420,28607,28640,28677,28692,28765,29022,29258,29289,29387,29454,29475,29505,29647,30703,31566,33975,34946,35059,35617,35726,35758,36001,36219,36280,36497,36549,36834,38250,38856,38866,38903,38911,38953,38992,38999,39033,39035,39046,39048,39111,39195,39230,39302,39410,39413,39459,39480,39544,39572,39614,39645,39650,39666,39753,39788,39891,39907,40026,40049,40097,40134,40297,40304,40492,40558,40607,41270,41304,41644,41855,42073,43506,44226,45026,45036)
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 | 1011 | 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.21 ms |
System lock | 0.02 ms |
optimizing | 0.08 ms |
statistics | 1.54 ms |
preparing | 0.78 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.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 |