Tiempo de la consulta: 8.93 ms Después de la última consulta: 1.53 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.252 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 07:33:01')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 07:33:01')
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(3,5,7,8,9,11,14,29,39,46,56,57,60,62,63,64,65,71,73,86,87,124,130,149,155,164,174,177,180,186,188,189,196,198,202,212,214,215,220,221,226,240,244,246,248,250,253,259,260,262,291,299,330,331,337,349,366,391,394,403,417,418,419,423,427,428,429,433,439,452,459,461,472,477,481,501,510,521,524,525,530,531,546,550,551,552,563,567,583,587,595,596,597,603,604,612,613,619,625,628,641,647,659,662,663,667,674,678,686,697,699,705,746,769,779,788,800,802,805,808,823,832,835,843,845,852,869,873,902,910,923,927,938,939,940,954,969,974,975,977,982,983,999,1004,1005,1011,1015,1021,1051,1055,1066,1071,1091,1095,1099,1100,1106,1114,1119,1158,1182,1190,1205,1218,1222,1227,1231,1247,1252,1253,1255,1268,1269,1271,1272,1273,1274,1276,1289,1303,1308,1309,1319,1327,1347,1357,1359,1363,1391,1397,1402,1409,1410,1428,1441,1444,1485,1490,1508,1509,1512,1513,1519,1543,1557,1606,1619,1620,1627,1629,1648,1668,1675,1686,1693,1694,1724,1740,1754,1765,1771,1794,1795,1796,1800,1803,1808,1810,1832,1839,1843,1853,1854,1855,1862,1864,1898,1899,1904,1918,1920,1930,1950,1960,1961,1975,1984,1994,1995,2001,2008,2012,2013,2015,2035,2048,2053,2075,2088,2092,2122,2137,2142,2155,2157,2161,2189,2190,2241,2288,2293,2369,2389,2431,2455,2482,2527,2532,2551,2574,2581,2586,2597,2598,2609,2638,2643,2687,2710,2746,2780,2807,2808,2811,2814,2824,2825,2851,2852,2883,2884,2885,2888,2906,2937,2960,3009,3026,3027,3031,3037,3055,3077,3100,3107,3120,3122,3130,3147,3156,3165,3169,3188,3193,3207,3224,3240,3258,3281,3292,3326,3329,3346,3364,3368,3369,3372,3375,3376,3387,3409,3412,3415,3416,3417,3418,3473,3512,3520,3548,3552,3554,3557,3590,3593,3648,3683,3689,3721,3722,3748,3752,3836,3853,3858,3872,3913,3919,3922,3962,3991,4026,4034,4049,4050,4068,4110,4129,4148,4301,4323,4327,4411,4451,4461,4468,4486,4490,4507,4510,4520,4529,4532,4558,4580,4583,4584,4611,4616,4620,4622,4626,4640,4666,4672,4673,4751,4752,4767,4787,4813,4815,4822,4831,4832,4833,4844,4846,4865,4905,4933,4973,5008,5018,5045,5055,5079,5092,5094,5096,5126,5134,5153,5160,5164,5170,5183,5220,5244,5245,5282,5286,5301,5370,5415,5469,5505,5559,5562,5581,5677,5683,5688,5703,5780,5795,5802,5831,5848,5894,5895,5899,5999,6011,6070,6093,6097,6112,6142,6148,6166,6173,6176,6198,6253,6256,6264,6334,6335,6345,6391,6405,6420,6435,6442,6476,6477,6538,6548,6606,6610,6612,6681,6729,6783,6845,6855,6939,6944,6958,6998,7022,7024,7030,7048,7105,7137,7139,7195,7242,7258,7324,7400,7411,7418,7491,7513,7533,7535,7582,7592,7595,7615,7648,7751,7762,7795,7819,7869,7918,8002,8068,8070,8080,8084,8086,8087,8192,8291,8294,8295,8314,8393,8498,8512,8517,8532,8538,8568,8592,8602,8634,8707,8779,8801,8811,8895,8940,9061,9087,9147,9190,9219,9237,9277,9279,9282,9360,9369,9387,9401,9460,9488,9515,9559,9572,9641,9658,9679,9873,9930,9932,10046,10190,10260,10371,10407,10483,10501,10562,10572,10671,10708,10720,10764,10789,10840,11001,11124,11144,11184,11207,11241,11327,11408,11496,11549,11555,11693,11694,11748,11814,11846,11854,12024,12202,12242,12256,12271,12324,12380,12398,12408,12427,12433,12550,12621,12639,12667,12708,12801,12806,12807,12870,12879,12900,12905,12906,12907,12908,12909,12910,12911,12912,12913,12914,12915,12958,12973,12974,13014,13027,13034,13067,13126,13142,13186,13231,13246,13264,13266,13328,13348,13353,13391,13475,13644,13702,13748,13851,13896,14022,14074,14114,14129,14207,14224,14226,14228,14242,14504,14527,14565,14571,14618,14666,14703,14714,14752,14807,14808,14865,14873,14944,14969,14974,14976,14977,15017,15038,15050,15063,15087,15133,15140,15144,15154,15175,15200,15203,15235,15324,15380,15414,15460,15470,15473,15500,15522,15533,15539,15542,15544,15562,15580,15602,15604,15613,15619,15630,15646,15690,15707,15709,15710,15781,15804,15807,15819,15820,15832,15868,15871,15875,15878,15913,15915,15940,15955,15967,15969,15973,15985,16017,16056,16081,16102,16103,16120,16122,16176,16224,16245,16279,16297,16337,16382,16412,16417,16435,16451,16454,16475,16478,16479,16531,16547,16548,16556,16569,16587,16588,16612,16619,16643,16722,16737,16742,16743,16790,16791,16830,16838,16905,16907,16913,16922,16967,16995,17028,17054,17055,17136,17140,17166,17170,17173,17268,17283,17293,17305,17315,17333,17337,17360,17372,17388,17395,17419,17422,17442,17449,17458,17465,17483,17507,17508,17526,17567,17584,17587,17592,17608,17644,17645,17646,17683,17699,17737,17756,17770,17791,17798,17799,17806,17807,17844,17850,17856,17863,17878,17881,17905,17918,17936,17986,18005,18036,18046,18047,18050,18075,18077,18088,18092,18140,18147,18181,18194,18225,18241,18244,18249,18304,18306,18307,18313,18327,18334,18357,18383,18435,18439,18444,18460,18480,18496,18524,18537,18542,18544,18588,18598,18603,18609,18629,18649,18652,18657,18659,18665,18695,18706,18733,18754,18769,18779,18784,18802,18804,18832,18859,18861,18868,18885,18894,18897,18908,18929,18930,18933,18953,18989,19005,19015,19019,19038,19039,19042,19061,19073,19137,19183,19187,19219,19228,19237,19257,19258,19269,19280,19282,19283,19289,19293,19299,19302,19306,19307,19309,19320,19322,19339,19346,19389,19400,19402,19421,19423,19427,19452,19458,19466,19470,19503,19517,19532,19533,19573,19647,19695,19706,19710,19721,19796,19800,19825,19829,19830,19837,19860,19874,19904,19923,19937,19976,19996,20001,20029,20044,20056,20057,20062,20072,20077,20147,20152,20153,20177,20188,20191,20192,20215,20236,20278,20293,20306,20391,20439,20448,20508,20530,20565,20599,20600,20621,20637,20661,20662,20663,20693,20713,20733,20743,20764,20804,20813,20843,20851,20853,20858,20860,20868,20871,20879,20883,20910,20920,20921,20922,20944,20949,20954,20963,20966,20967,20997,20999,21027,21036,21047,21049,21095,21166,21168,21172,21203,21217,21236,21279,21282,21313,21402,21445,21472,21473,21483,21508,21524,21560,21569,21574,21630,21652,21695,21720,21741,21757,21760,21778,21787,21820,21835,21890,21969,22038,22049,22105,22116,22162,22171,22199,22306,22314,22362,22402,22411,22427,22476,22511,22530,22531,22550,22567,22603,22651,22663,22671,22709,22726,22743,22758,22779,22847,22854,22870,22873,22886,22941,22973,23013,23023,23065,23138,23142,23161,23170,23182,23200,23202,23224,23238,23246,23249,23254,23258,23294,23313,23334,23340,23350,23354,23397,23400,23429,23433,23455,23464,23469,23482,23516,23521,23526,23536,23556,23569,23599,23617,23625,23635,23650,23682,23701,23733,23751,23788,23804,23819,23850,23875,23876,23898,23929,23932,23951,24015,24029,24039,24067,24120,24121,24144,24153,24180,24181,24189,24203,24206,24208,24219,24231,24245,24255,24335,24415,24426,24429,24484,24496,24526,24540,24564,24578,24582,24585,24598,24609,24614,24670,24681,24682,24690,24797,24802,24808,24853,24862,24874,24920,24933,24945,24973,25004,25006,25030,25057,25062,25072,25105,25112,25146,25182,25209,25257,25323,25335,25357,25401,25407,25456,25465,25513,25534,25537,25569,25572,25582,25598,25610,25632,25689,25708,25721,25753,25818,25901,25966,26000,26014,26037,26043,26044,26082,26100,26148,26154,26172,26215,26241,26245,26268,26342,26349,26386,26387,26405,26447,26452,26504,26506,26554,26578,26652,26707,26762,26780,26796,26825,26829,26897,26919,26920,26936,26949,26954,26979,26982,26991,27023,27075,27103,27133,27135,27157,27198,27211,27216,27279,27291,27301,27307,27332,27340,27344,27354,27433,27490,27496,27511,27522,27531,27563,27564,27582,27678,27702,27739,27805,27843,27861,27863,27875,27898,27904,27912,27997,28152,28193,28194,28218,28248,28334,28340,28402,28416,28436,28442,28458,28466,28534,28540,28547,28548,28553,28555,28575,28615,28616,28629,28656,28665,28668,28671,28683,28698,28706,28707,28725,28726,28727,28728,28745,28754,28763,28776,28795,28799,28800,28803,28807,28817,28828,28833,28834,28844,28847,28849,28866,28867,28872,28878,28910,28912,28918,28925,28931,28960,29006,29013,29033,29127,29136,29201,29209,29221,29281,29312,29329,29374,29389,29418,29440,29459,29468,29553,29804,29824,29837,29894,30138,30262,30307,30572,30573,30596,30941,30978,31090,31109,31114,31356,31401,31417,31560,31621,31663,31671,31763,31837,31885,31896,31937,31962,32097,32286,32431,32841,32965,33107,33233,33259,33327,33416,33430,33503,33593,33649,33651,33784,33993,33997,34008,34168,34176,34265,34300,34307,34490,34573,34595,34783,34785,34902,34942,34969,35051,35071,35072,35073,35088,35097,35156,35165,35167,35206,35294,35308,35326,35427,35430,35564,35568,35588,35657,35674,35694,35724,35755,35931,36012,36018,36113,36160,36165,36167,36191,36219,36247,36256,36285,36346,36349,36355,36365,36370,36397,36433,36463,36575,36750,36795,36798,36806,36885,37056,37129,37210,37251,37408,37528,37529,37532,37695,37696,37702,37972,38212,38261,38365,38392,38417,38475,38503,38598,38790,38825,38964,39056,39061,39170,39180,39186,39258,39267,39299,39301,39463,39469,39491,39494,39495,39529,39543,39703,39746,39750,39819,39870,39882,39884,39933,39971,40052,40085,40107,40110,40119,40207,40208,40245,40355,40358,40397,40402,40415,40481,40572,40625,40655,40736,40784,40837,40852,40952,41063,41117,41241,41256,41311,41348,41353,41380,41381,41430,41444,41520,41525,41526,41531,41539,41541,41546,41561,41580,41606,41692,41723,41744,41823,41866,41874,41946,41960,42024,42025,42067,42132,42251,42312,42394,42404,42408,42421,42425,42426,42444,42520,42530,42567,42748,42752,42799,42822,42824,42839,42963,43002,43052,43060,43069,43084,43087,43090,43107,43162,43353,43388,43645,43717,43828,43944,44078,44100,44101,44161,44396,44402,44463,44509,44560,44602,44627,44743,44749,44763,44817,44855,45076,45134,45288,45293)
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 | 1681 | 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 | 1.11 ms |
checking permissions | 0.09 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.44 ms |
System lock | 0.03 ms |
optimizing | 0.12 ms |
statistics | 3.66 ms |
preparing | 1.86 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.85 ms |
end | 0.03 ms |
query end | 0.02 ms |
closing tables | 0.05 ms |
freeing items | 0.07 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 |