Tiempo de la consulta: 4.58 ms Después de la última consulta: 0.80 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.311 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 23:37:53')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 23:37:53')
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(7,78,113,267,280,318,473,474,489,515,583,606,608,615,622,672,681,692,710,733,796,802,832,893,941,1034,1073,1220,1257,1273,1281,1317,1323,1395,1563,1567,1573,1718,1743,1753,1805,1873,1880,1932,2020,2065,2147,2211,2284,2285,2388,2428,2433,2492,2528,2660,2695,2773,2794,2870,2893,2894,2927,2980,2997,3000,3005,3049,3071,3085,3095,3214,3234,3236,3265,3393,3420,3716,3733,3800,3855,3870,3883,3918,3953,3969,3988,4028,4047,4063,4093,4113,4165,4173,4182,4184,4217,4231,4260,4268,4302,4381,4405,4433,4434,4582,4644,4855,4911,4932,4933,4978,5065,5182,5195,5207,5263,5302,5336,5363,5367,5439,5563,5575,5576,5593,5658,5674,5698,5731,5805,5846,5872,5878,5879,5889,5924,5967,6038,6084,6107,6115,6138,6195,6319,6451,6531,6548,6568,6577,6658,6670,6780,6784,7012,7095,7098,7172,7260,7275,7325,7329,7365,7423,7424,7489,7520,7536,7554,7556,7567,7627,7714,7743,7751,7759,7771,7777,7797,7967,7991,7996,7998,8054,8083,8101,8114,8224,8261,8306,8406,8415,8521,8569,8587,8661,8754,8765,8779,8848,8963,8999,9030,9038,9111,9114,9131,9188,9199,9206,9262,9263,9345,9398,9404,9426,9443,9444,9454,9480,9516,9642,9689,9715,9741,9755,9799,9853,9928,9970,9981,10068,10117,10138,10217,10254,10255,10479,10481,10486,10519,10570,10655,10678,10696,10751,10758,10793,10817,10827,10842,10863,10879,10886,10960,11032,11038,11041,11138,11140,11159,11179,11238,11279,11305,11398,11407,11421,11455,11541,11542,11684,11701,11717,11723,11751,11794,11838,11859,11873,11927,11989,11990,12034,12037,12094,12123,12146,12158,12202,12206,12263,12321,12357,12372,12381,12640,12655,12747,12839,12852,12893,12896,12902,12903,12926,12945,12976,12981,12993,13023,13073,13080,13139,13152,13164,13218,13230,13232,13260,13265,13296,13297,13298,13314,13336,13343,13411,13429,13454,13670,13682,13698,13710,13711,13754,13765,13856,13875,13907,13925,13926,13970,14012,14017,14037,14041,14073,14083,14091,14115,14154,14159,14176,14190,14199,14214,14242,14255,14268,14278,14288,14304,14338,14385,14427,14469,14484,14549,14562,14563,14569,14574,14609,14656,14706,14723,14747,14766,14778,14811,14813,14970,15002,15009,15047,15051,15061,15066,15090,15091,15115,15122,15126,15175,15185,15197,15218,15250,15257,15272,15286,15315,15332,15488,15499,15524,15532,15566,15613,15633,15643,15683,15731,15732,15864,15927,15929,15980,16053,16094,16123,16142,16202,16311,16313,16356,16359,16365,16377,16394,16401,16441,16448,16497,16502,16535,16545,16585,16589,16624,16676,16686,16712,16732,16758,16784,16811,16813,16828,16857,16879,16887,16897,16910,16916,16955,17064,17085,17089,17146,17150,17169,17209,17245,17263,17327,17359,17363,17378,17393,17417,17423,17424,17434,17436,17438,17450,17462,17488,17507,17513,17591,17630,17667,17684,17692,17697,17724,17730,17739,17750,17781,17788,17808,17815,17820,17873,17884,17953,17964,18040,18073,18138,18145,18153,18182,18243,18245,18306,18321,18357,18383,18384,18395,18420,18527,18564,18570,18576,18578,18579,18581,18591,18594,18599,18607,18617,18627,18639,18648,18678,18686,18697,18734,18747,18765,18771,18777,18795,18812,18817,18829,18835,18838,18853,18889,18900,18915,18917,18952,18960,18967,18972,18992,19011,19019,19026,19036,19050,19057,19089,19151,19157,19159,19164,19167,19202,19216,19256,19266,19286,19328,19374,19398,19401,19411,19436,19466,19469,19476,19525,19557,19558,19562,19575,19579,19591,19610,19643,19644,19648,19701,19708,19713,19740,19755,19769,19770,19796,19829,19842,19895,19900,19924,19944,19952,19963,20009,20027,20062,20080,20093,20164,20179,20211,20227,20230,20298,20307,20323,20326,20341,20395,20401,20409,20442,20475,20510,20544,20589,20728,20740,20750,20754,20791,20816,20864,20884,20919,20934,20946,20951,20962,21019,21031,21042,21048,21054,21067,21072,21109,21146,21163,21171,21176,21179,21186,21238,21239,21260,21274,21308,21311,21345,21359,21362,21379,21411,21414,21443,21450,21455,21467,21490,21528,21535,21552,21562,21583,21592,21616,21643,21653,21675,21680,21713,21729,21758,21775,21789,21826,21830,21874,21886,21897,21964,21975,21978,21979,21981,22001,22029,22046,22064,22070,22084,22092,22120,22165,22181,22201,22211,22213,22271,22272,22275,22286,22290,22294,22338,22448,22450,22497,22511,22549,22551,22578,22610,22635,22638,22664,22665,22685,22687,22704,22716,22733,22782,22783,22823,22824,22832,22846,22863,22916,22927,22945,22982,23038,23042,23061,23066,23067,23075,23109,23114,23128,23163,23164,23165,23215,23278,23362,23419,23472,23508,23531,23551,23590,23595,23696,23777,23809,23842,23885,23985,23987,24022,24059,24134,24179,24235,24244,24353,24452,24510,24527,24537,24603,24664,24674,24691,24699,24783,24831,24971,24999,25024,25077,25153,25179,25191,25198,25347,25433,25482,25562,25593,25723,25802,25842,25871,25932,26079,26548,26741,26803,26899,27010,27049,27087,27152,27236,27279,27319,27325,27398,27761,27770,27954,27973,28004,28160,28200,28479,28899,28922,28925,28999,29387,29486,29719,29832,29840,29848,29884,30234,31377,31975,34114,35663,36151,36294,37987,38005,38763,38866,38903,39026,39035,39048,39067,39111,39195,39335,39480,39572,39645,39666,39833,39891,39907,39918,40112,40441,40502,40558,40810,41092,41136,41219,41304,41856,43105,43218,44226)
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 | 887 | 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.56 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.18 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.89 ms |
preparing | 0.70 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.43 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.07 ms |
cleaning up | 0.08 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 |