Tiempo de la consulta: 5.23 ms Después de la última consulta: 0.79 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.542 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-04 00:47:21')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 00:47:21')
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(2,3,4,5,6,7,8,9,11,16,25,28,29,49,56,72,86,165,201,255,263,271,275,276,344,463,472,495,549,581,583,607,611,613,675,686,723,757,758,816,831,844,868,883,895,916,917,958,963,1015,1029,1031,1039,1046,1053,1056,1080,1089,1095,1140,1158,1195,1207,1235,1238,1249,1271,1304,1308,1316,1337,1363,1372,1446,1497,1504,1557,1718,1866,1935,2026,2064,2078,2103,2219,2224,2248,2278,2290,2293,2305,2325,2365,2379,2404,2426,2439,2461,2563,2566,2625,2639,2647,2785,2796,2827,2842,2857,2863,2888,2916,2924,2934,2946,3018,3037,3038,3207,3248,3276,3285,3353,3411,3447,3462,3496,3512,3533,3591,3604,3620,3634,3812,3976,3986,4114,4204,4209,4255,4284,4287,4315,4446,4459,4515,4549,4573,4580,4735,4767,4813,4878,4902,4944,4973,5018,5150,5219,5247,5350,5365,5451,5458,5559,5647,5675,5726,5727,5730,5851,5854,5894,5912,5932,5934,5971,5977,6062,6105,6127,6151,6166,6311,6330,6340,6405,6424,6470,6473,6475,6520,6534,6542,6543,6561,6573,6605,6616,6629,6630,6644,6656,6685,6688,6723,6736,6742,6743,6744,6791,6801,6804,6833,6835,6842,6860,6889,6895,6897,6906,6936,6945,6953,6969,6985,6995,7015,7045,7232,7249,7271,7282,7343,7412,7439,7447,7458,7483,7490,7516,7545,7584,7586,7588,7718,7730,7752,7806,7832,7848,7934,7950,7959,7997,8027,8109,8113,8114,8143,8216,8264,8337,8431,8499,8508,8759,8820,8945,9010,9027,9036,9101,9346,9359,9398,9415,9744,9745,9834,9836,9854,9864,9905,10110,10120,10176,10203,10250,10286,10304,10306,10311,10428,10484,10532,10554,10661,10686,10697,10713,10760,10769,10872,10912,10951,10954,10974,11015,11063,11076,11083,11146,11170,11173,11226,11262,11277,11320,11394,11424,11438,11479,11480,11534,11712,11730,11766,11821,11872,11883,11987,12019,12114,12139,12212,12218,12306,12393,12410,12449,12545,12548,12567,12576,12618,12624,12625,12684,12758,12761,12789,12852,12894,12902,12945,12959,13115,13188,13190,13225,13241,13262,13276,13384,13433,13456,13508,13574,13611,13659,13671,13731,13733,13734,13851,13855,13869,13911,13926,13968,13972,13994,13998,14005,14048,14057,14070,14097,14098,14101,14114,14141,14183,14204,14205,14227,14229,14236,14249,14270,14305,14331,14341,14361,14482,14495,14507,14522,14525,14538,14571,14613,14616,14684,14692,14696,14701,14746,14807,14811,14846,14856,14931,14974,14981,14993,15038,15069,15100,15111,15149,15217,15293,15304,15310,15330,15346,15436,15474,15497,15518,15522,15543,15551,15565,15635,15668,15689,15728,15757,15866,15903,16060,16062,16128,16163,16168,16209,16280,16343,16358,16366,16415,16431,16432,16451,16522,16538,16571,16604,16645,16671,16685,16775,16827,16876,16996,17042,17090,17132,17138,17146,17184,17222,17227,17228,17242,17285,17354,17389,17407,17425,17480,17510,17518,17537,17551,17634,17704,17715,17753,17754,17766,17839,17852,17880,17901,17925,17950,18000,18032,18121,18276,18294,18304,18311,18364,18375,18390,18393,18505,18524,18583,18610,18628,18668,18670,18682,18698,18718,18730,18768,18793,18846,18874,18882,18948,18952,19020,19026,19043,19051,19064,19111,19119,19133,19147,19172,19175,19193,19207,19233,19247,19288,19322,19349,19444,19475,19484,19516,19700,19727,19758,19764,19880,19913,19918,19920,19930,19934,19962,19976,20016,20018,20033,20089,20099,20101,20120,20127,20149,20174,20220,20223,20256,20294,20317,20355,20361,20397,20402,20437,20441,20549,20556,20586,20587,20614,20654,20655,20665,20668,20671,20686,20705,20714,20739,20779,20784,20785,20794,20797,20807,20809,20820,20878,20897,20924,20941,20967,20973,20993,21046,21113,21216,21226,21240,21255,21294,21297,21346,21369,21420,21510,21536,21537,21579,21667,21739,21798,21831,21846,21851,21852,21865,21866,21950,22038,22051,22098,22124,22150,22167,22171,22185,22198,22212,22238,22250,22290,22317,22347,22348,22389,22500,22509,22553,22571,22582,22645,22656,22672,22706,22711,22732,22741,22750,22753,22770,22775,22854,22856,22883,22901,23041,23046,23070,23076,23078,23100,23130,23148,23156,23188,23253,23259,23267,23286,23305,23308,23363,23383,23423,23488,23501,23566,23612,23615,23649,23730,23767,23783,23790,23816,23838,23926,23957,23964,23978,23990,24024,24025,24077,24118,24147,24150,24193,24200,24219,24282,24288,24289,24322,24337,24362,24403,24411,24433,24440,24449,24456,24550,24557,24559,24576,24597,24614,24616,24687,24695,24701,24732,24737,24748,24760,24830,24841,24853,24860,24863,24899,24941,25004,25048,25060,25080,25111,25123,25125,25135,25174,25178,25212,25287,25374,25386,25397,25415,25452,25460,25535,25560,25561,25567,25591,25621,25657,25696,25703,25709,25717,25799,25888,25934,25938,25947,25990,26030,26031,26041,26043,26102,26146,26161,26173,26288,26483,26488,26519,26525,26582,26620,26760,26818,26901,27041,27074,27138,27248,27283,27318,27397,27407,27471,27478,27518,27592,27790,27949,27968,28005,28184,28313,28526,28548,28557,28563,28575,28581,28630,28799,28847,28928,29319,29382,29438,29443,29473,29500,29536,29694,29695,29711,30034,30284,31010,31986,35294,35871,35899,35975,36154,36367,36402,36490,36583,36897,37345,37582,37762,37822,38226,38237,38352,38850,38899,38961,38991,39063,39214,39286,39323,39558,39580,39592,39647,39677,39737,39761,39801,39892,40066,40120,40272,40347,40375,40594,40739,40773,40778,40813,40887,40922,40973,41122,41217,41475,41636,41761,41826,41965,42486,42563,42591,42680,42766,42944,43001,43330,43569,43570,43571,43755,43856,43972,43973,44143,44160,44469,44587,44843,44933,44998)
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 | 933 | 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.66 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
init | 0.21 ms |
System lock | 0.02 ms |
optimizing | 0.09 ms |
statistics | 1.78 ms |
preparing | 1.03 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.45 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.04 ms |
freeing items | 0.06 ms |
cleaning up | 0.06 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 |