Tiempo de la consulta: 25.75 ms Después de la última consulta: 0.92 ms Consulta a la memoria: 3.221 MB memoria antes de la consulta: 4.493 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 03:43:15')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 03:43:15')
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(64,94,109,157,193,194,195,218,233,239,241,257,275,311,380,401,466,468,471,479,482,499,519,543,560,601,610,635,643,661,672,680,681,685,692,700,703,709,713,736,761,783,786,805,826,837,859,868,891,898,902,920,923,960,968,973,984,998,1013,1024,1032,1034,1042,1048,1054,1055,1067,1079,1092,1096,1098,1106,1127,1129,1138,1142,1150,1151,1172,1192,1194,1213,1226,1242,1254,1255,1257,1259,1269,1271,1279,1280,1284,1295,1305,1322,1335,1349,1375,1420,1421,1433,1435,1441,1444,1445,1447,1454,1455,1460,1466,1476,1481,1484,1553,1575,1586,1593,1595,1624,1664,1753,1811,1812,1828,1841,1852,1855,1870,1903,1906,1924,1929,1984,2001,2077,2148,2177,2193,2199,2301,2359,2374,2408,2432,2469,2480,2530,2569,2607,2616,2618,2629,2631,2658,2691,2773,2894,2989,3056,3095,3119,3202,3278,3355,3364,3476,3513,3590,3594,3611,3663,3758,3787,3796,3800,3836,3845,3868,3872,3992,4059,4075,4109,4132,4133,4168,4176,4197,4252,4271,4300,4303,4378,4381,4477,4523,4558,4580,4585,4586,4587,4589,4600,4605,4640,4775,4785,4874,4880,4892,4972,5014,5035,5079,5166,5226,5322,5496,5507,5508,5534,5642,5649,5707,5847,5876,5894,5936,5990,6005,6068,6133,6295,6308,6323,6386,6420,6421,6461,6484,6520,6533,6553,6596,6635,6661,6663,6667,6707,6788,6794,6842,6932,6985,7002,7107,7174,7182,7200,7202,7221,7237,7271,7275,7277,7287,7356,7374,7421,7435,7567,7626,7688,7709,7726,7748,7802,7817,7830,7839,7860,7868,7870,7946,7951,8007,8023,8069,8091,8108,8135,8191,8206,8243,8400,8415,8464,8518,8806,8848,8870,8907,8938,8944,9018,9029,9062,9108,9198,9247,9449,9462,9612,9643,9717,9767,9879,9893,9924,9964,10078,10100,10316,10323,10353,10371,10373,10501,10613,10725,10736,10765,10775,10834,10851,11195,11210,11223,11235,11314,11397,11408,11625,11705,11859,11969,12089,12141,12170,12238,12440,12816,12946,12994,13010,13040,13062,13068,13078,13126,13160,13185,13258,13272,13297,13316,13344,13413,13427,13437,13438,13467,13478,13479,13480,13481,13482,13503,13506,13508,13525,13660,13797,13824,13871,13968,13969,14009,14064,14136,14151,14153,14156,14177,14246,14293,14309,14427,14432,14493,14506,14546,14602,14603,14608,14633,14641,14651,14672,14710,14727,14766,14812,14866,14874,14882,14958,14970,14977,15063,15138,15147,15166,15181,15188,15198,15216,15223,15229,15304,15311,15312,15315,15321,15333,15359,15420,15464,15532,15543,15551,15577,15601,15632,15644,15667,15706,15722,15788,15856,15874,15901,15904,15982,16014,16052,16216,16258,16365,16386,16466,16488,16500,16569,16607,16629,16631,16634,16660,16676,16774,16780,16791,16813,16857,16927,16983,17035,17039,17091,17126,17131,17142,17151,17224,17240,17255,17344,17448,17513,17555,17658,17660,17710,17722,17780,17784,17799,17892,17921,17961,18002,18013,18037,18039,18055,18160,18174,18181,18202,18237,18284,18382,18465,18466,18509,18550,18767,18804,18813,18825,18856,18901,18916,18955,18992,18996,19007,19019,19043,19085,19154,19287,19335,19343,19390,19407,19420,19505,19536,19596,19603,19612,19658,19704,19765,19773,19797,19801,19803,19849,19853,19903,19932,20004,20043,20051,20071,20095,20106,20142,20202,20233,20242,20265,20308,20391,20400,20404,20408,20568,20569,20584,20602,20639,20688,20728,20739,20773,20832,20847,20871,20876,20933,20969,21189,21205,21229,21284,21359,21438,21601,21614,21620,21652,21691,21773,21782,21821,21868,21983,22013,22019,22173,22175,22254,22313,22344,22372,22379,22415,22416,22430,22482,22522,22653,22694,22695,22756,22828,22848,22864,22872,22904,22981,23031,23039,23077,23101,23114,23185,23221,23243,23296,23336,23344,23358,23371,23394,23406,23451,23547,23572,23592,23593,23638,23654,23669,23691,23703,23715,23721,23722,23747,23769,23834,23860,23921,23954,23962,24017,24052,24094,24170,24179,24198,24206,24264,24331,24343,24363,24391,24455,24524,24579,24599,24644,24652,24692,24819,24822,24838,24922,24923,24966,24977,24985,25010,25039,25081,25141,25156,25172,25182,25197,25278,25284,25292,25303,25317,25326,25348,25598,25621,25671,25693,25705,25717,25731,25881,25885,25898,25914,25922,25943,25964,25987,26018,26109,26152,26154,26167,26221,26284,26348,26353,26468,26505,26530,26565,26671,26702,26722,26753,26759,26771,26797,26807,26852,26881,26909,26944,26945,27035,27046,27188,27229,27237,27280,27311,27383,27401,27460,27491,27529,27610,27742,27775,27779,27859,27916,27956,27969,27992,28030,28080,28088,28189,28233,28290,28306,28598,28628,28659,28746,29121,29174,29373,29548,29864,29888,30252,30253,30254,30293,30455,30562,31026,31384,32484,32530,32919,33345,34174,34676,35226,35299,35325,35337,35360,35379,35434,35596,35780,36085,36297,36330,36403,36751,36817,36961,37034,37107,37116,37170,37397,37403,37439,37454,38006,38103,38114,38122,38128,38217,38239,38248,38315,38343,38398,38440,38446,38452,38530,38549,38674,38844,39027,39052,39150,39163,39193,39241,39245,39276,39285,39315,39319,39347,39375,39389,39475,39492,39609,39706,39722,39747,39767,39768,39802,39987,40018,40023,40089,40231,40276,40398,40436,40438,40460,40465,40535,40554,40555,40562,40614,40667,40688,40751,40774,40811,40817,40880,40959,41040,41068,41150,41220,41246,41322,41418,41436,41499,41570,41576,41602,41610,41630,41649,41720,41724,41797,41800,41839,41865,41871,41879,41896,41927,41956,41957,42040,42054,42057,42065,42091,42134,42154,42163,42174,42188,42212,42304,42405,42448,42451,42490,42538,42572,42703,42729,42765,42800,42806,42863,43009,43115,43136,43143,43222,43234,43244,43294,43345,43459,43508,43509,43539,43550,43565,43574,43596,43601,43605,43615,43682,43846,43979,44026,44177,44184,44351,44400,44431,44491,44544,44588,44611,44613,44701,44894,44908,44941,45049,45051,45136,45157,45302,45303)
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 | 980 | 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.53 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.22 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.64 ms |
preparing | 0.77 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 21.11 ms |
end | 0.11 ms |
query end | 0.12 ms |
closing tables | 0.03 ms |
freeing items | 0.47 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 |