Tiempo de la consulta: 5.77 ms Después de la última consulta: 1.37 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.548 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 16:08:46')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 16:08:46')
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,8,11,46,57,61,62,64,73,97,99,112,124,130,149,155,177,180,186,188,189,198,202,210,212,214,215,219,220,221,224,232,238,243,244,245,246,248,249,250,253,260,276,289,309,325,328,330,337,357,385,394,395,406,413,414,417,418,419,423,424,426,427,433,439,451,452,456,468,474,481,489,497,521,524,525,527,528,532,548,550,551,553,555,565,567,574,575,583,587,595,596,597,603,604,612,613,620,622,628,632,633,634,641,646,647,659,662,672,678,681,686,699,709,730,746,771,776,779,781,788,792,796,797,800,802,805,818,833,840,842,845,852,858,861,864,889,901,902,905,910,924,925,927,928,938,954,955,962,983,1007,1008,1015,1021,1033,1040,1058,1062,1066,1072,1087,1099,1100,1114,1119,1145,1165,1185,1205,1218,1222,1227,1248,1252,1253,1264,1266,1268,1269,1270,1271,1272,1273,1274,1276,1278,1325,1328,1357,1376,1388,1389,1390,1394,1397,1402,1412,1432,1491,1504,1512,1519,1543,1563,1594,1612,1627,1683,1712,1716,1717,1740,1744,1754,1770,1784,1797,1800,1803,1839,1849,1853,1904,1917,1949,1960,1964,1971,1973,1999,2007,2012,2048,2053,2071,2073,2086,2088,2092,2102,2122,2137,2142,2155,2170,2185,2189,2190,2241,2288,2355,2389,2429,2431,2433,2463,2482,2520,2532,2551,2580,2581,2589,2598,2609,2633,2661,2687,2710,2739,2746,2758,2788,2790,2811,2852,2875,2906,2937,2964,3017,3026,3027,3031,3051,3082,3085,3120,3130,3156,3167,3181,3193,3224,3240,3244,3251,3258,3259,3269,3271,3299,3318,3337,3415,3416,3417,3418,3424,3425,3473,3512,3517,3520,3554,3557,3704,3709,3721,3748,3776,3792,3832,3836,3853,3869,3873,3932,3963,3988,4000,4068,4082,4224,4301,4355,4434,4490,4502,4538,4560,4561,4580,4611,4620,4621,4640,4767,4780,4801,4815,4831,4832,4844,4846,4848,4854,4901,4905,4955,5018,5043,5045,5055,5063,5096,5136,5141,5164,5183,5190,5220,5227,5243,5301,5328,5357,5363,5370,5417,5452,5466,5529,5562,5575,5581,5582,5583,5625,5632,5637,5644,5646,5648,5678,5694,5702,5732,5756,5759,5777,5794,5795,5804,5811,5831,5894,5895,5899,5904,5910,5919,5923,5925,5946,5978,5994,6011,6021,6022,6068,6075,6087,6093,6112,6220,6235,6253,6258,6264,6266,6312,6343,6390,6405,6429,6498,6501,6688,6757,6758,6821,6834,6855,6857,6884,6885,6908,6939,6960,7012,7048,7053,7054,7172,7175,7237,7242,7273,7324,7348,7374,7443,7473,7491,7527,7549,7567,7591,7595,7644,7711,7716,7722,7751,7752,7771,7795,7797,7918,7958,7969,7980,7996,8009,8050,8070,8080,8081,8084,8087,8148,8161,8188,8218,8291,8296,8325,8374,8387,8390,8398,8417,8435,8443,8492,8501,8505,8506,8512,8517,8716,8852,9004,9011,9087,9139,9155,9175,9186,9193,9219,9237,9244,9251,9252,9277,9280,9282,9360,9362,9387,9431,9460,9501,9515,9525,9573,9618,9648,9660,9679,9708,9760,9766,9831,9840,9850,9889,9930,9970,10046,10095,10129,10213,10219,10278,10298,10364,10444,10449,10483,10494,10603,10624,10666,10671,10698,10708,10720,10753,10764,10818,10888,10893,10900,10942,10967,11131,11198,11302,11542,11559,11672,11685,11709,11748,11822,11833,11846,11854,11918,12168,12202,12246,12256,12271,12380,12387,12410,12426,12427,12439,12458,12482,12509,12567,12568,12574,12590,12656,12663,12714,12795,12806,12890,12892,12900,12905,12906,12907,12908,12909,12910,12911,12912,12913,12914,12915,12926,12928,12943,12958,12974,12982,13013,13014,13027,13079,13121,13142,13186,13209,13215,13238,13246,13263,13264,13269,13285,13297,13317,13325,13328,13365,13381,13383,13391,13406,13415,13432,13436,13449,13459,13553,13556,13558,13566,13579,13590,13625,13702,13722,13729,13748,13753,13803,13809,13833,13881,13903,13959,13986,13987,14014,14015,14029,14074,14114,14134,14171,14177,14185,14193,14197,14218,14224,14232,14238,14242,14290,14302,14368,14388,14417,14504,14508,14527,14548,14565,14571,14577,14620,14631,14651,14652,14656,14680,14688,14690,14703,14723,14725,14769,14810,14834,14884,14885,14904,14914,14928,14930,14940,14957,14976,14977,15006,15054,15096,15126,15138,15154,15175,15223,15235,15244,15250,15254,15261,15314,15324,15392,15430,15437,15450,15460,15469,15470,15473,15484,15490,15500,15518,15533,15540,15542,15547,15550,15562,15563,15566,15572,15579,15580,15583,15601,15602,15603,15604,15612,15623,15627,15630,15666,15667,15670,15706,15707,15709,15749,15781,15832,15835,15885,15901,15902,15909,15913,15916,15917,15925,15940,15955,15985,15999,16005,16015,16017,16021,16023,16024,16056,16068,16143,16213,16219,16245,16279,16297,16311,16313,16323,16336,16337,16381,16382,16401,16402,16412,16417,16435,16443,16475,16479,16516,16555,16556,16570,16589,16600,16619,16620,16642,16643,16698,16712,16722,16790,16791,16830,16833,16838,16846,16860,16863,16891,16918,16922,16924,16940,16947,16968,17008,17028,17045,17054,17064,17101,17114,17160,17169,17209,17232,17248,17268,17283,17287,17293,17326,17337,17360,17371,17388,17422,17428,17442,17446,17450,17458,17465,17507,17513,17524,17534,17567,17584,17622,17694,17721,17752,17780,17782,17788,17806,17807,17808,17850,17856,17857,17863,17905,17907,17918,17976,17978,17981,18004,18005,18006,18019,18027,18046,18047,18050,18067,18068,18076,18140,18141,18147,18151,18194,18203,18225,18235,18244,18251,18297,18313,18334,18357,18378,18383,18415,18420,18421,18435,18437,18439,18447,18460,18476,18480,18496,18504,18506,18507,18524,18532,18534,18537,18542,18544,18564,18576,18581,18587,18588,18598,18603,18609,18624,18629,18647,18649,18655,18659,18665,18676,18677,18705,18706,18719,18752,18754,18766,18769,18778,18792,18800,18801,18804,18835,18851,18853,18859,18861,18868,18874,18879,18885,18894,18897,18908,18930,18931,18933,18946,18953,18956,18966,18980,18989,19005,19023,19042,19061,19062,19073,19082,19093,19095,19163,19164,19184,19196,19216,19218,19219,19237,19267,19275,19282,19293,19295,19299,19302,19316,19320,19321,19322,19340,19346,19383,19414,19426,19427,19452,19473,19481,19503,19514,19545,19565,19580,19586,19587,19592,19606,19618,19647,19665,19695,19741,19755,19778,19779,19796,19805,19808,19826,19827,19837,19864,19876,19904,19942,19963,19973,19976,19988,20001,20002,20076,20108,20129,20145,20147,20152,20154,20155,20184,20204,20208,20209,20215,20223,20278,20303,20306,20310,20337,20352,20366,20384,20391,20393,20421,20530,20570,20585,20621,20628,20650,20661,20679,20693,20728,20821,20843,20876,20910,20920,20925,20935,20948,20963,20991,21031,21035,21042,21047,21049,21050,21057,21090,21158,21159,21166,21167,21172,21181,21200,21230,21291,21299,21302,21313,21335,21341,21349,21361,21399,21412,21415,21428,21465,21472,21483,21508,21528,21583,21599,21603,21604,21632,21634,21646,21647,21652,21660,21670,21688,21695,21729,21741,21757,21770,21778,21827,21829,21849,21908,21930,21955,21986,22036,22041,22049,22055,22056,22058,22074,22131,22136,22162,22177,22242,22260,22321,22327,22362,22402,22427,22428,22511,22520,22535,22540,22545,22594,22595,22604,22615,22621,22623,22629,22651,22657,22709,22738,22758,22799,22838,22860,22922,22927,22932,22941,22967,23004,23023,23027,23032,23082,23084,23090,23102,23136,23166,23174,23215,23254,23302,23331,23340,23379,23398,23411,23412,23469,23481,23503,23531,23548,23625,23630,23633,23634,23640,23645,23652,23758,23804,23819,23866,23894,23898,23951,23958,24002,24134,24137,24153,24154,24199,24226,24234,24285,24386,24391,24410,24426,24442,24517,24540,24545,24585,24662,24719,24744,24802,24862,24882,24962,24986,25004,25033,25061,25092,25105,25203,25214,25257,25271,25379,25401,25465,25572,25721,25735,25742,25749,25768,25782,25797,25845,25865,25963,26019,26080,26140,26172,26197,26201,26245,26268,26323,26324,26398,26449,26473,26489,26548,26577,26612,26637,26728,26909,26919,26941,26954,27087,27104,27184,27198,27307,27444,27488,27547,27892,28072,28157,28169,28248,28272,28402,28416,28423,28436,28442,28455,28458,28459,28511,28528,28534,28547,28555,28575,28683,28817,28840,28867,28918,28925,29033,29086,29189,29201,29221,29251,29312,29440,29553,29640,29696,29824,30111,30289,30478,30596,31114,31533,31663,31763,31809,31885,31896,31899,32472,33416,33649,33874,34295,34764,35928,36137,36178,36564,37056,37210,37289,37574,37656,37695,37696,37702,37865,38000,38139,38261,38475,38619,38691,38816,38817,38833,38845,38897,38987,39180,39186,39251,39258,39267,39427,39463,39469,39491,39495,39543,39614,39645,39750,39819,39820,39870,39884,39933,39972,40053,40112,40207,40208,40355,40402,40488,40533,40572,40837,40852,41074,41241,41363,41388,41444,41460,41525,41526,41541,41606,41672,41823,41946,41960,42024,42025,42067,42132,42251,42408,42421,42425,42426,42444,42520,42748,42824,42829,42839,43002,43052,43060,43069,43084,43087,43388,43436,43717,43753,43977,44161,44509,44749,44763,44866)
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 | 1507 | 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.70 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.27 ms |
System lock | 0.03 ms |
optimizing | 0.10 ms |
statistics | 2.40 ms |
preparing | 1.12 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.37 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.08 ms |
cleaning up | 0.04 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 |