Tiempo de la consulta: 16.20 ms Después de la última consulta: 1.35 ms Consulta a la memoria: 1.487 MB memoria antes de la consulta: 4.373 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 01:56:23')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 01:56:23')
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,9,11,57,62,97,99,112,124,155,158,159,163,174,180,198,210,212,215,219,221,224,232,238,243,244,245,249,263,276,282,289,309,325,328,330,337,353,354,356,358,359,360,361,363,364,394,395,414,417,418,423,424,426,427,433,437,451,452,459,460,468,477,481,500,521,524,525,527,528,532,548,553,555,565,567,587,595,596,597,603,604,607,620,628,632,641,646,647,655,659,662,669,686,723,730,746,756,757,781,788,792,800,805,818,833,840,842,852,901,902,925,931,962,965,1007,1008,1015,1020,1045,1058,1066,1067,1072,1080,1083,1085,1090,1100,1114,1119,1120,1143,1145,1165,1182,1198,1207,1214,1227,1264,1268,1272,1274,1276,1277,1278,1289,1308,1324,1325,1328,1336,1346,1386,1388,1389,1390,1394,1400,1412,1504,1538,1712,1718,1740,1745,1754,1759,1797,1800,1803,1839,1853,1919,1960,2007,2012,2048,2053,2064,2086,2105,2185,2188,2190,2322,2355,2392,2429,2463,2496,2520,2532,2580,2589,2630,2646,2687,2762,2811,2827,2852,2857,2858,2859,2864,2939,2964,2983,3017,3026,3035,3039,3055,3069,3109,3139,3156,3167,3169,3180,3181,3269,3294,3318,3329,3337,3364,3415,3416,3417,3424,3442,3451,3463,3473,3512,3517,3520,3571,3673,3704,3709,3761,3776,3836,3853,3888,3945,3984,4000,4038,4166,4286,4301,4378,4422,4538,4561,4580,4620,4661,4699,4713,4767,4775,4832,4848,4874,4955,5043,5045,5085,5096,5136,5161,5182,5220,5243,5247,5301,5302,5305,5357,5373,5417,5451,5543,5579,5582,5583,5597,5637,5644,5646,5647,5659,5678,5702,5729,5730,5731,5732,5759,5777,5794,5795,5798,5804,5831,5881,5894,5899,5910,5919,5923,5934,5944,5978,6011,6022,6043,6087,6112,6166,6220,6258,6264,6266,6291,6312,6343,6350,6390,6472,6494,6516,6541,6573,6601,6645,6665,6690,6694,6727,6758,6854,6855,6885,6908,6939,7013,7014,7026,7048,7105,7135,7138,7139,7191,7246,7272,7284,7365,7380,7387,7401,7402,7419,7439,7453,7473,7478,7549,7627,7629,7716,7718,7730,7741,7753,7771,7923,7950,7958,7965,7969,7986,8009,8027,8050,8061,8067,8070,8081,8084,8087,8090,8093,8116,8177,8218,8338,8372,8374,8398,8488,8541,8638,8663,8666,8974,9029,9137,9139,9175,9186,9237,9251,9277,9318,9362,9431,9434,9554,9616,9660,9773,9850,9886,9924,10023,10046,10078,10213,10226,10239,10263,10294,10307,10314,10331,10345,10380,10416,10503,10572,10601,10603,10630,10665,10686,10694,10708,10717,10720,10738,10753,10768,10783,10893,10958,10964,10980,10989,11001,11029,11059,11131,11152,11191,11204,11219,11258,11265,11302,11320,11402,11446,11523,11542,11559,11678,11754,11806,11822,11823,11835,11948,11954,11984,12031,12078,12116,12125,12171,12218,12224,12259,12309,12331,12367,12401,12426,12463,12474,12546,12563,12568,12571,12590,12605,12622,12625,12670,12685,12686,12737,12791,12806,12856,12872,12875,12902,12909,12982,13013,13140,13186,13215,13238,13257,13263,13285,13325,13344,13350,13365,13383,13415,13432,13443,13444,13459,13488,13516,13542,13556,13558,13566,13571,13590,13602,13615,13618,13625,13645,13653,13697,13742,13753,13766,13806,13833,13861,13874,13881,13903,13916,13963,13986,13987,13990,14000,14013,14015,14029,14074,14082,14117,14152,14177,14193,14205,14218,14219,14227,14238,14243,14244,14249,14262,14269,14273,14280,14292,14371,14401,14440,14456,14507,14508,14571,14591,14631,14638,14644,14651,14665,14680,14683,14693,14725,14754,14794,14810,14830,14837,14846,14849,14873,14885,14904,14914,14940,14957,14964,14983,15006,15032,15048,15049,15054,15079,15094,15096,15105,15108,15109,15111,15129,15138,15139,15174,15175,15213,15235,15244,15268,15278,15314,15353,15370,15372,15469,15472,15490,15494,15518,15520,15540,15547,15548,15550,15575,15579,15602,15606,15612,15623,15627,15630,15631,15666,15667,15707,15717,15725,15739,15757,15782,15786,15835,15851,15885,15896,15899,15902,15925,15935,15939,15953,16000,16005,16015,16021,16022,16023,16024,16062,16091,16092,16093,16153,16156,16192,16213,16219,16286,16326,16336,16337,16374,16382,16386,16402,16414,16417,16422,16443,16458,16472,16479,16534,16541,16621,16646,16723,16790,16791,16808,16809,16816,16818,16825,16832,16833,16889,16943,16947,16948,16981,16998,17045,17069,17090,17092,17128,17132,17160,17215,17224,17230,17257,17283,17290,17300,17307,17321,17361,17368,17371,17382,17391,17426,17432,17442,17500,17541,17571,17584,17596,17611,17630,17634,17640,17650,17679,17708,17721,17733,17735,17753,17777,17783,17810,17817,17818,17839,17840,17869,17882,17895,17902,17947,17976,17980,18006,18009,18031,18067,18079,18098,18122,18142,18151,18176,18216,18220,18226,18253,18260,18264,18279,18295,18297,18308,18313,18332,18333,18360,18369,18378,18388,18406,18421,18424,18437,18494,18520,18522,18554,18561,18562,18577,18598,18612,18619,18653,18655,18674,18682,18700,18718,18752,18762,18766,18775,18792,18804,18805,18822,18853,18861,18868,18874,18908,18910,18912,18920,18928,18942,18956,18977,18982,18991,18995,18997,19000,19010,19018,19022,19061,19062,19082,19083,19086,19091,19110,19132,19134,19136,19149,19164,19181,19183,19247,19267,19270,19275,19280,19293,19294,19303,19304,19367,19388,19404,19416,19426,19437,19449,19453,19462,19496,19507,19524,19581,19592,19595,19608,19624,19650,19652,19657,19659,19661,19677,19684,19718,19774,19796,19815,19826,19854,19856,19876,19894,19913,19921,19930,19932,19941,19973,19976,19983,19991,20001,20034,20069,20145,20180,20183,20184,20191,20194,20199,20216,20217,20219,20232,20277,20304,20310,20337,20344,20354,20363,20370,20374,20403,20423,20440,20467,20488,20525,20529,20546,20564,20578,20579,20626,20630,20636,20638,20647,20681,20736,20749,20803,20821,20826,20856,20865,20868,20915,20919,20963,20986,20988,20994,21000,21004,21010,21011,21047,21050,21088,21116,21118,21123,21151,21158,21159,21161,21167,21178,21183,21230,21242,21252,21263,21272,21301,21305,21313,21323,21376,21394,21416,21419,21427,21433,21458,21464,21493,21506,21510,21522,21534,21545,21546,21550,21556,21575,21586,21589,21633,21659,21714,21721,21735,21737,21888,21894,21919,21952,21955,21999,22038,22052,22059,22071,22100,22174,22178,22206,22251,22263,22283,22298,22343,22344,22359,22382,22395,22412,22419,22435,22455,22476,22492,22496,22500,22502,22527,22528,22540,22555,22593,22615,22669,22673,22682,22689,22696,22708,22713,22715,22726,22738,22742,22747,22803,22804,22813,22820,22835,22874,22883,22899,22900,22939,22974,22979,23000,23015,23022,23034,23082,23118,23121,23122,23148,23219,23222,23240,23247,23249,23286,23295,23302,23318,23344,23355,23375,23378,23393,23398,23428,23430,23438,23446,23467,23476,23527,23546,23559,23564,23578,23586,23596,23616,23648,23665,23676,23691,23693,23703,23719,23772,23806,23814,23825,23857,23863,23874,23898,23951,23959,23962,23967,23984,23996,24010,24021,24024,24033,24072,24075,24076,24099,24111,24135,24199,24230,24346,24364,24386,24484,24505,24523,24545,24563,24580,24607,24616,24642,24662,24672,24673,24706,24709,24721,24754,24756,24780,24788,24790,24804,24832,24857,24872,24883,24900,24906,24924,24953,24962,24996,25003,25048,25064,25105,25120,25126,25175,25188,25214,25273,25288,25322,25330,25349,25355,25360,25364,25373,25374,25383,25391,25411,25421,25455,25465,25471,25486,25497,25514,25539,25648,25673,25697,25764,25790,25798,25813,25821,25859,25864,25893,25942,25955,25971,25987,26043,26107,26117,26122,26134,26176,26204,26221,26240,26295,26366,26431,26446,26469,26480,26522,26541,26559,26564,26603,26634,26639,26709,26728,26769,26814,26816,26828,26898,26923,26926,26982,27022,27024,27026,27055,27057,27076,27115,27143,27151,27170,27262,27274,27307,27356,27372,27381,27406,27438,27506,27558,27571,27572,27644,27677,27738,27985,28005,28072,28091,28120,28163,28256,28300,28355,28397,28416,28423,28424,28465,28547,28627,28662,28680,28681,28682,28683,28702,28710,28780,28781,28824,28844,28847,29014,29021,29064,29089,29124,29133,29194,29221,29256,29358,29379,29417,29571,29617,29640,29646,29696,29727,29800,29809,29810,29919,29920,29930,30050,30111,30318,30478,30790,31227,31499,31516,31533,31899,33815,33874,36042,36323,36564,36650,36893,36916,36918,37289,37315,37380,37656,37865,37874,37996,38000,38056,38066,38112,38361,38455,38691,38714,38717,38734,38775,38812,39307,39358,39452,39504,39516,39966,40053,40116,40169,40312,40313,40314,40360,40542,40583,40603,40801,41036,41063,41074,41402,41423,41460,41811,41885,42009,42444,42460,42489,43388,43436,43680,43705,43706,43707,43914,43915,43917,44031,44041,44497,44681,44770,44866,45115,45160,45206,45252)
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 | 1452 | 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.65 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.26 ms |
System lock | 0.02 ms |
optimizing | 0.10 ms |
statistics | 2.17 ms |
preparing | 1.07 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 11.05 ms |
end | 0.02 ms |
query end | 0.03 ms |
closing tables | 0.02 ms |
freeing items | 0.10 ms |
cleaning up | 0.05 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 |