Tiempo de la consulta: 17.30 ms Después de la última consulta: 1.35 ms Consulta a la memoria: 1.487 MB memoria antes de la consulta: 4.399 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 21:18:55')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-03 21:18:55')
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(5,7,9,14,29,39,56,60,62,63,65,71,73,86,87,108,138,149,163,164,174,177,186,188,195,196,202,221,226,240,248,259,262,290,291,299,318,327,331,349,357,366,386,391,395,428,429,442,461,470,472,474,477,481,489,498,500,501,510,525,529,530,531,546,563,583,619,629,633,659,662,663,666,667,672,674,675,679,681,692,696,697,699,705,726,746,748,769,794,797,800,802,805,808,823,832,835,852,861,868,869,873,880,884,910,923,924,939,940,954,969,974,977,982,983,999,1004,1005,1011,1021,1055,1091,1092,1095,1107,1112,1114,1119,1158,1167,1172,1190,1200,1205,1231,1247,1252,1253,1255,1256,1268,1271,1275,1276,1285,1286,1289,1295,1308,1309,1319,1346,1347,1363,1402,1409,1410,1416,1428,1432,1441,1444,1459,1476,1485,1496,1509,1526,1538,1557,1594,1606,1619,1629,1641,1648,1675,1693,1694,1718,1720,1724,1734,1749,1759,1771,1776,1794,1795,1796,1808,1810,1828,1837,1843,1854,1855,1862,1899,1918,1919,1920,1930,1960,1961,1975,1984,1994,1995,2001,2006,2008,2013,2015,2035,2057,2060,2075,2088,2089,2136,2137,2155,2157,2161,2188,2290,2293,2392,2455,2467,2469,2527,2532,2534,2551,2559,2580,2586,2597,2638,2643,2657,2756,2774,2779,2807,2814,2824,2850,2851,2875,2883,2888,2960,3027,3055,3057,3100,3107,3109,3147,3169,3180,3192,3193,3196,3207,3224,3260,3267,3294,3330,3364,3368,3369,3387,3409,3412,3424,3451,3473,3507,3520,3545,3548,3552,3554,3563,3571,3590,3648,3683,3689,3721,3748,3785,3808,3832,3853,3858,3869,3872,3913,3919,3922,3951,3952,3962,3988,3991,4025,4034,4050,4068,4110,4129,4132,4166,4327,4355,4381,4468,4491,4495,4529,4532,4558,4616,4620,4622,4624,4626,4649,4666,4675,4699,4713,4751,4752,4767,4813,4815,4822,4831,4844,4845,4846,4865,4880,4933,4973,4992,5055,5134,5153,5160,5161,5163,5191,5207,5220,5247,5285,5333,5370,5415,5469,5486,5559,5629,5679,5757,5780,5795,5799,5867,5881,5890,5894,5901,5970,5999,6046,6130,6148,6198,6199,6331,6391,6420,6435,6442,6472,6476,6477,6548,6575,6595,6606,6615,6688,6692,6765,6802,6810,6845,6855,6867,6870,6872,6944,6958,7013,7014,7022,7030,7048,7137,7191,7195,7242,7246,7258,7272,7324,7336,7340,7360,7363,7409,7416,7418,7419,7439,7443,7491,7535,7538,7543,7567,7592,7595,7648,7668,7670,7751,7801,7815,7819,7923,7938,7980,8061,8070,8086,8089,8116,8192,8291,8295,8314,8342,8375,8404,8405,8417,8500,8538,8564,8582,8588,8592,8602,8610,8617,8634,8707,8779,8784,8801,8895,8979,9011,9237,9277,9279,9369,9401,9434,9488,9554,9572,9611,9655,9656,9752,9756,9773,9814,9822,9879,9924,9930,10100,10115,10129,10200,10301,10307,10364,10405,10481,10572,10630,10635,10677,10694,10759,10783,10840,10854,10958,10970,11001,11059,11184,11195,11258,11402,11446,11529,11555,11665,11742,11947,12137,12217,12218,12242,12255,12331,12398,12401,12408,12442,12463,12474,12567,12622,12625,12639,12663,12667,12686,12757,12839,12854,12875,12913,12958,12974,12982,13034,13126,13152,13190,13246,13269,13297,13358,13477,13617,13626,13641,13646,13697,13729,13742,13781,13861,13880,13896,13963,13973,13990,14063,14074,14082,14117,14135,14144,14244,14262,14273,14302,14356,14364,14400,14440,14455,14456,14507,14577,14660,14666,14683,14688,14703,14714,14752,14769,14771,14794,14797,14865,14907,14964,14969,14970,14976,14983,14999,15001,15018,15032,15038,15048,15063,15087,15094,15108,15111,15129,15138,15139,15157,15203,15213,15235,15293,15364,15370,15396,15405,15460,15533,15544,15548,15553,15575,15604,15654,15725,15747,15757,15781,15782,15804,15807,15875,15913,15915,15916,15935,15942,15973,16000,16051,16092,16093,16122,16125,16150,16153,16221,16224,16313,16326,16374,16390,16454,16458,16534,16549,16555,16585,16587,16588,16596,16612,16631,16637,16647,16737,16791,16830,16832,16857,16889,16905,16913,16972,16981,16995,17001,17026,17040,17054,17055,17059,17102,17128,17140,17142,17166,17174,17197,17209,17215,17232,17238,17239,17257,17268,17269,17295,17312,17333,17352,17356,17367,17371,17372,17378,17382,17388,17432,17442,17450,17541,17556,17592,17596,17630,17634,17644,17646,17683,17685,17689,17695,17699,17733,17737,17788,17791,17795,17798,17799,17806,17807,17811,17818,17840,17863,17895,17936,17980,18031,18036,18061,18076,18105,18150,18188,18199,18234,18357,18369,18383,18389,18444,18480,18542,18561,18577,18587,18611,18612,18657,18682,18683,18695,18733,18754,18777,18779,18802,18817,18832,18833,18857,18901,18910,18920,18933,18942,18967,18977,18982,18991,18995,18996,19000,19015,19022,19032,19038,19053,19066,19083,19085,19091,19110,19112,19132,19136,19149,19154,19183,19187,19228,19247,19249,19257,19258,19269,19270,19280,19282,19283,19289,19294,19299,19302,19307,19316,19339,19365,19389,19400,19402,19421,19423,19427,19453,19458,19470,19503,19524,19526,19532,19533,19573,19595,19608,19650,19661,19684,19718,19721,19745,19800,19815,19830,19862,19893,19894,19919,19920,19930,19932,19937,19941,19969,19983,19991,20011,20029,20034,20044,20056,20057,20062,20069,20082,20101,20145,20153,20177,20183,20188,20199,20215,20236,20239,20278,20293,20306,20344,20354,20363,20374,20391,20401,20403,20417,20440,20466,20503,20508,20530,20578,20600,20636,20638,20662,20682,20713,20733,20743,20762,20764,20804,20813,20826,20828,20843,20851,20853,20856,20858,20860,20871,20879,20883,20918,20920,20921,20944,20949,20954,20999,21000,21042,21118,21145,21146,21147,21161,21162,21168,21178,21188,21217,21236,21242,21252,21261,21282,21305,21313,21323,21402,21433,21458,21464,21482,21483,21515,21522,21546,21569,21582,21586,21622,21703,21704,21714,21737,21760,21772,21787,21815,21820,21835,21868,21869,21884,21943,21952,21962,21969,22014,22019,22036,22059,22100,22104,22105,22120,22201,22321,22376,22419,22435,22455,22492,22500,22502,22527,22541,22546,22567,22603,22623,22630,22673,22687,22708,22715,22742,22743,22790,22803,22847,22854,22874,22882,22896,22899,22934,23000,23022,23034,23083,23122,23138,23145,23148,23170,23202,23215,23219,23224,23246,23247,23286,23317,23344,23375,23466,23467,23507,23526,23530,23536,23546,23559,23564,23569,23599,23617,23650,23671,23682,23691,23692,23703,23713,23758,23772,23857,23874,23875,23877,23959,23962,23967,23984,24010,24024,24067,24072,24075,24076,24111,24123,24153,24155,24160,24189,24197,24208,24219,24230,24234,24281,24289,24300,24309,24330,24346,24384,24415,24421,24423,24484,24500,24503,24518,24523,24526,24572,24575,24585,24587,24591,24597,24598,24606,24607,24609,24614,24616,24663,24673,24682,24688,24711,24714,24731,24737,24785,24788,24797,24853,24857,24876,24924,24973,25003,25051,25110,25126,25241,25256,25273,25323,25349,25360,25373,25374,25421,25456,25489,25534,25569,25598,25607,25610,25621,25626,25630,25632,25703,25717,25721,25764,25798,25860,25901,25978,25987,26014,26015,26051,26095,26107,26122,26176,26215,26245,26308,26386,26522,26554,26564,26641,26646,26700,26753,26757,26793,26816,26823,26829,26838,26903,26920,26922,26926,26949,26954,26979,26982,26992,27026,27100,27103,27133,27135,27142,27144,27151,27157,27164,27179,27356,27389,27490,27506,27518,27558,27572,27805,27863,27892,27904,27997,28005,28241,28248,28249,28397,28402,28416,28424,28453,28718,28743,28780,28824,28864,28886,28910,28918,28925,28959,28960,29001,29021,29033,29089,29124,29136,29167,29256,29281,29312,29358,29617,29653,29810,29919,29930,29990,29991,30307,30838,31113,31114,31227,31356,31499,31516,31671,31892,32007,32097,32841,33259,33430,33593,33651,33784,33815,33993,34008,34176,34300,34490,34573,34783,35308,35568,35755,35924,36019,36219,36280,36353,36431,36652,36893,36916,36918,37094,37315,37380,37408,37874,37919,37996,38005,38056,38066,38360,38361,38419,38455,38734,38775,38812,38901,39036,39142,39180,39286,39307,39358,39374,39452,39480,39504,39516,39616,39644,39789,39966,40169,40214,40215,40256,40312,40313,40314,40360,40542,40563,40801,40873,40886,40888,41036,41063,41081,41256,41270,41311,41402,41423,41430,41478,41811,41885,42012,42460,42489,42530,42536,42727,42752,42767,42799,42914,42915,42972,42973,43093,43680,43705,43706,43707,43717,43741,43914,43915,43917,44031,44041,44396,44402,44497,44602,44681,44682,44743,45064,45076,45115,45160,45206,45252,45255)
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 | 1416 | 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.85 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.29 ms |
System lock | 0.02 ms |
optimizing | 0.10 ms |
statistics | 2.32 ms |
preparing | 1.27 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 11.57 ms |
end | 0.03 ms |
query end | 0.08 ms |
closing tables | 0.02 ms |
freeing items | 0.19 ms |
cleaning up | 0.07 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 |