Tiempo de la consulta: 3.96 ms Después de la última consulta: 0.68 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.175 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 05:03:45')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 05:03:45')
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(2,3,4,5,6,7,8,11,16,25,29,49,60,61,62,63,64,65,67,68,72,165,255,271,272,275,278,281,287,331,344,350,380,385,417,497,549,559,581,586,607,686,697,717,757,816,844,857,900,916,970,978,992,1015,1024,1046,1053,1056,1057,1080,1140,1154,1168,1187,1207,1208,1232,1235,1238,1304,1305,1306,1308,1318,1319,1504,1506,1664,1698,1851,1917,2005,2112,2394,2566,2713,2861,2962,2997,3201,3208,3340,3353,3447,3634,3696,3841,3942,3976,3982,3986,4210,4443,4515,4557,4563,4587,4597,4628,4863,4973,5018,5020,5150,5247,5559,5730,5814,5817,5894,5896,6062,6186,6289,6290,6311,6330,6381,6470,6484,6542,6543,6570,6616,6742,6748,6804,6945,7125,7238,7249,7296,7321,7361,7432,7458,7584,7625,7718,7801,7806,7838,7839,7851,7860,7931,7946,7950,7965,7981,7985,8114,8499,8531,8555,8574,8737,8759,9010,9018,9253,9398,9532,9556,9667,9745,9862,9864,9895,9944,9945,10100,10110,10120,10243,10260,10280,10284,10289,10304,10349,10383,10445,10449,10561,10592,10686,10688,10713,10747,10769,10805,10834,10912,10946,10961,11051,11076,11129,11146,11222,11299,11377,11392,11424,11438,11482,11495,11565,11679,11688,11711,11730,11822,12007,12042,12150,12212,12218,12238,12308,12337,12339,12393,12424,12548,12576,12611,12668,12684,12747,12758,12761,12780,12783,12852,12902,12944,12959,13004,13052,13071,13115,13152,13153,13188,13433,13657,13671,13731,13734,13748,13750,13783,13816,13869,13924,13934,13987,13994,14005,14068,14070,14101,14103,14153,14204,14227,14229,14249,14255,14270,14277,14305,14331,14341,14424,14481,14482,14495,14522,14570,14596,14746,14779,14792,14807,14846,14895,14931,14958,14981,14993,15007,15038,15053,15069,15100,15114,15145,15183,15244,15293,15336,15359,15368,15404,15438,15493,15518,15522,15543,15551,15577,15600,15605,15632,15645,15669,15689,15714,15728,15744,15753,15785,15812,15819,15843,15880,15957,15975,16005,16033,16083,16089,16127,16163,16164,16200,16201,16209,16249,16297,16308,16322,16334,16358,16370,16446,16451,16464,16520,16556,16575,16604,16611,16629,16645,16665,16668,16684,16685,16791,16794,16830,16844,16861,16881,17090,17098,17132,17145,17146,17156,17163,17210,17253,17270,17279,17319,17362,17407,17422,17443,17471,17518,17521,17537,17551,17559,17572,17630,17655,17690,17704,17713,17732,17753,17758,17761,17766,17839,17877,17880,17925,17933,17950,17989,17994,18000,18032,18117,18162,18229,18260,18285,18300,18304,18311,18318,18375,18390,18467,18520,18524,18567,18583,18664,18671,18720,18762,18793,18828,18876,18882,18905,18952,18989,19002,19043,19047,19060,19067,19105,19108,19119,19133,19145,19147,19148,19170,19180,19185,19247,19253,19276,19327,19352,19368,19376,19457,19460,19484,19532,19560,19577,19620,19633,19668,19687,19700,19732,19758,19764,19811,19865,19870,19880,19881,19908,19909,19913,19937,19998,20010,20016,20028,20032,20056,20086,20141,20156,20170,20187,20223,20234,20242,20256,20263,20271,20289,20353,20355,20402,20411,20449,20450,20516,20535,20564,20586,20614,20630,20638,20642,20659,20665,20705,20710,20714,20729,20807,20820,20866,20878,20924,20941,20967,20969,20982,21010,21046,21050,21173,21189,21198,21225,21226,21240,21255,21314,21422,21432,21449,21513,21545,21548,21611,21620,21636,21640,21678,21694,21713,21738,21764,21768,21854,21866,21950,21980,22082,22100,22137,22140,22146,22149,22198,22204,22229,22297,22304,22337,22361,22362,22500,22509,22559,22645,22647,22673,22712,22720,22732,22741,22750,22774,22852,22856,22865,22903,22908,22980,22988,23053,23078,23100,23130,23186,23233,23259,23275,23281,23295,23374,23402,23495,23555,23585,23610,23621,23636,23649,23666,23682,23732,23763,23764,23767,23840,23845,23858,23921,23955,23964,24028,24059,24077,24163,24165,24176,24194,24200,24208,24322,24337,24342,24415,24451,24489,24540,24586,24637,24639,24653,24695,24707,24737,24785,24791,24804,24834,24884,24897,24915,25004,25045,25048,25123,25135,25178,25184,25212,25264,25289,25290,25315,25397,25415,25460,25556,25640,25648,25702,25709,25775,25818,25872,25906,25927,25928,26000,26024,26245,26288,26315,26370,26620,26640,26708,26760,26807,26818,26854,27086,27138,27141,27143,27151,27158,27211,27216,27423,27511,27560,27576,27592,27671,27786,27790,27949,27968,28005,28059,28066,28075,28094,28097,28120,28129,28177,28192,28310,28313,28336,28354,28454,28495,28548,28557,28563,28575,28581,28630,28882,29057,29319,29382,29412,29454,29694,29695,29711,29802,30740,31129,31604,32905,33914,35603,35926,37915,39558,40813,40922,43032,43628,43629)
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 | 768 | 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.38 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
Opening tables | 0.02 ms |
init | 0.15 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.23 ms |
preparing | 0.61 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.33 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.05 ms |
cleaning up | 0.02 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 |