Tiempo de la consulta: 4.30 ms Después de la última consulta: 1.03 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 4.505 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-06 03:26:02')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 03:26:02')
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,14,29,39,56,57,60,62,63,65,71,73,86,87,97,99,112,120,121,122,123,124,149,155,164,174,175,177,180,196,198,210,215,218,219,221,224,226,232,237,238,240,243,244,245,249,254,259,262,276,282,284,289,291,299,309,325,328,330,331,337,349,357,366,391,394,395,414,417,418,423,424,426,427,428,429,433,437,446,451,452,459,468,472,477,481,501,510,521,524,525,527,528,530,531,532,546,548,553,555,563,565,567,587,595,596,597,603,604,619,620,628,632,641,642,646,647,659,662,663,667,669,670,671,674,686,697,705,728,730,742,769,781,788,792,799,800,802,805,808,818,823,832,833,835,840,842,845,852,869,873,901,902,910,923,925,939,940,954,962,969,974,977,982,983,986,987,999,1004,1005,1007,1008,1011,1015,1021,1055,1058,1066,1071,1072,1091,1095,1100,1114,1119,1123,1145,1158,1165,1182,1205,1227,1231,1247,1252,1253,1255,1264,1268,1271,1272,1274,1276,1278,1289,1304,1308,1309,1319,1325,1328,1347,1350,1363,1388,1389,1390,1394,1409,1410,1412,1428,1432,1441,1444,1485,1504,1509,1557,1606,1619,1629,1648,1675,1693,1694,1712,1724,1754,1771,1794,1795,1796,1797,1800,1803,1808,1810,1839,1843,1853,1854,1855,1862,1899,1918,1920,1930,1960,1961,1975,1984,1994,1995,2001,2007,2008,2012,2013,2015,2032,2035,2048,2053,2075,2086,2088,2137,2155,2157,2161,2167,2179,2185,2293,2355,2429,2455,2463,2520,2527,2532,2551,2580,2586,2589,2597,2638,2643,2687,2713,2811,2814,2824,2851,2852,2853,2883,2888,2960,3017,3026,3027,3055,3100,3107,3147,3156,3167,3169,3181,3207,3219,3229,3269,3318,3337,3364,3368,3369,3387,3398,3409,3412,3415,3416,3417,3424,3449,3473,3512,3517,3520,3548,3552,3554,3590,3648,3683,3689,3704,3709,3748,3776,3784,3836,3853,3858,3872,3913,3919,3922,3962,3991,4000,4034,4050,4068,4110,4129,4301,4327,4456,4468,4529,4532,4538,4558,4561,4580,4616,4620,4622,4626,4666,4674,4676,4751,4752,4767,4813,4815,4822,4831,4832,4844,4846,4848,4865,4933,4955,4973,5043,5045,5055,5096,5134,5153,5160,5220,5243,5300,5301,5357,5370,5415,5417,5469,5559,5582,5583,5637,5644,5646,5678,5702,5725,5732,5759,5777,5780,5794,5795,5804,5831,5899,5910,5919,5923,5978,5999,6011,6022,6087,6110,6112,6148,6198,6220,6258,6266,6312,6343,6390,6391,6420,6435,6442,6476,6477,6548,6748,6758,6841,6845,6855,6885,6895,6944,6958,7022,7030,7048,7137,7195,7242,7258,7324,7418,7473,7491,7535,7547,7549,7551,7581,7592,7595,7648,7673,7682,7699,7710,7716,7751,7771,7778,7779,7819,7829,7847,7958,7969,7984,8009,8050,8070,8081,8084,8086,8087,8192,8218,8291,8295,8314,8374,8398,8538,8592,8602,8634,8707,8779,8801,8895,9004,9139,9175,9186,9237,9251,9277,9279,9362,9369,9401,9431,9488,9572,9660,9663,9666,9850,9930,9999,10046,10213,10331,10572,10603,10611,10708,10720,10753,10771,10840,10893,11001,11095,11131,11184,11302,11427,11555,11559,11706,11822,12000,12096,12121,12156,12242,12299,12334,12398,12408,12426,12568,12590,12639,12667,12806,12974,12982,12998,13013,13034,13126,13186,13215,13238,13246,13263,13264,13285,13325,13365,13383,13415,13432,13459,13556,13558,13566,13590,13612,13625,13728,13753,13833,13881,13896,13903,13986,13987,14015,14029,14163,14177,14193,14218,14238,14571,14631,14651,14666,14680,14703,14714,14725,14726,14752,14810,14865,14885,14904,14914,14940,14957,14969,14976,15006,15038,15054,15063,15087,15096,15138,15175,15203,15235,15244,15314,15460,15469,15490,15518,15533,15540,15544,15547,15550,15579,15602,15604,15612,15615,15623,15627,15630,15666,15667,15685,15707,15781,15804,15807,15835,15875,15902,15913,15915,15925,15973,16005,16015,16021,16023,16024,16122,16127,16213,16219,16224,16336,16382,16402,16417,16443,16454,16479,16587,16588,16612,16715,16737,16791,16830,16833,16913,16936,16947,16995,17045,17054,17055,17134,17140,17160,17166,17193,17217,17333,17371,17372,17388,17442,17486,17500,17584,17592,17643,17644,17645,17646,17683,17699,17721,17737,17753,17791,17798,17799,17806,17807,17936,17976,17991,18001,18006,18036,18067,18143,18151,18184,18191,18222,18274,18297,18311,18313,18357,18378,18383,18421,18437,18444,18460,18480,18489,18542,18655,18657,18695,18733,18752,18754,18762,18766,18779,18792,18802,18804,18832,18853,18868,18874,18911,18934,18956,18961,19015,19018,19038,19062,19082,19152,19155,19164,19183,19187,19228,19258,19260,19267,19269,19275,19280,19282,19283,19289,19293,19299,19302,19307,19339,19389,19400,19402,19416,19421,19423,19426,19427,19437,19453,19458,19470,19503,19532,19533,19573,19592,19601,19721,19733,19796,19800,19827,19830,19857,19876,19937,19976,20029,20044,20053,20056,20057,20062,20127,20145,20153,20177,20184,20188,20215,20236,20243,20278,20293,20306,20310,20337,20391,20489,20508,20530,20550,20600,20601,20624,20630,20662,20713,20733,20743,20764,20804,20813,20821,20826,20843,20851,20853,20858,20860,20871,20879,20883,20920,20921,20944,20949,20954,20963,20982,20999,21005,21033,21047,21050,21159,21168,21217,21221,21230,21236,21250,21282,21313,21402,21483,21545,21569,21660,21688,21760,21787,21820,21851,21955,21969,22037,22098,22105,22222,22285,22300,22323,22432,22540,22567,22590,22603,22615,22647,22738,22743,22767,22804,22847,22854,22985,22991,23082,23127,23138,23170,23192,23202,23224,23246,23251,23285,23302,23318,23398,23463,23483,23526,23527,23536,23569,23574,23599,23617,23682,23730,23746,23805,23875,24067,24082,24101,24127,24144,24153,24189,24199,24208,24209,24219,24248,24386,24390,24415,24484,24526,24545,24577,24580,24585,24598,24609,24614,24662,24668,24682,24787,24797,24805,24853,24861,24875,24888,24962,24973,25214,25323,25326,25456,25465,25534,25569,25598,25610,25632,25691,25721,25890,25901,26014,26042,26066,26215,26245,26379,26386,26554,26687,26728,26829,26920,26954,27103,27133,27135,27153,27157,27213,27307,27316,27438,27490,27744,27805,27863,27904,27997,28072,28248,28336,28402,28416,28423,28547,28882,28910,28918,28960,29033,29136,29221,29281,29640,29696,30111,30307,30478,30605,30606,30723,31055,31114,31356,31533,31671,31850,31899,32097,32115,32841,33259,33416,33430,33593,33651,33784,33874,33993,34008,34176,34195,34300,34490,34573,34783,34881,35495,35568,35755,36117,36219,36254,36564,36948,37289,37408,37656,37865,38000,38691,40053,41025,41074,41256,41311,41430,41460,42444,42530,42702,42752,42799,43388,43436,43564,44384,44396,44402,44509,44602,44743,44866,45076)
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 | 1141 | 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.52 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.21 ms |
System lock | 0.02 ms |
optimizing | 0.08 ms |
statistics | 1.67 ms |
preparing | 0.86 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.30 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.06 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 |