Tiempo de la consulta: 3.59 ms Después de la última consulta: 1.01 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.159 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 15:41:15')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 15:41: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(2,3,4,5,6,7,8,16,25,29,49,58,72,165,255,260,263,275,344,495,549,581,607,675,757,816,844,900,916,1015,1029,1039,1046,1053,1056,1080,1089,1095,1140,1158,1195,1207,1235,1238,1239,1249,1304,1308,1319,1337,1372,1384,1497,1504,1557,1755,1803,1935,2064,2103,2325,2379,2404,2426,2442,2563,2566,2625,2647,2827,2842,2857,2888,2916,2924,3038,3111,3207,3208,3248,3276,3285,3353,3447,3452,3462,3604,3634,3700,3732,3812,3976,3986,4114,4169,4188,4209,4315,4446,4515,4573,4677,4920,4973,4980,5018,5034,5138,5150,5189,5247,5435,5450,5451,5458,5461,5559,5825,5854,5894,5977,6062,6277,6311,6330,6340,6407,6492,6493,6534,6542,6543,6561,6616,6629,6678,6685,6716,6736,6742,6791,6804,6833,6906,6945,6969,6995,7045,7128,7156,7218,7249,7282,7396,7412,7425,7447,7455,7458,7490,7565,7572,7584,7690,7718,7725,7735,7741,7752,7806,7950,8064,8114,8125,8223,8229,8281,8285,8383,8499,8549,8555,8589,8660,8689,8713,8759,8851,8856,9010,9036,9181,9233,9398,9399,9415,9432,9438,9439,9704,9745,9805,9828,9834,9836,9854,9864,10054,10110,10120,10154,10180,10286,10295,10369,10532,10554,10564,10611,10661,10686,10713,10769,10912,11026,11076,11146,11150,11170,11262,11277,11328,11345,11386,11399,11424,11438,11592,11642,11730,11821,11872,11891,11903,12019,12139,12212,12218,12248,12393,12548,12576,12684,12736,12758,12761,12852,12902,12935,12959,13115,13188,13262,13348,13384,13433,13434,13499,13659,13670,13671,13731,13733,13734,13869,13926,13994,14005,14070,14101,14141,14204,14227,14229,14249,14270,14276,14305,14331,14341,14420,14482,14495,14522,14525,14613,14692,14696,14746,14807,14846,14931,14981,14993,15069,15076,15100,15111,15149,15270,15293,15330,15346,15497,15518,15522,15543,15565,15635,15668,15689,15728,15748,15766,15894,16060,16062,16128,16163,16168,16209,16343,16358,16366,16418,16451,16490,16522,16523,16571,16604,16645,16671,16675,16685,16739,16791,16827,16904,16949,16985,17042,17053,17090,17132,17138,17146,17184,17222,17288,17318,17389,17394,17407,17425,17491,17518,17537,17551,17704,17753,17766,17839,17859,17880,17889,17925,18000,18032,18216,18304,18311,18364,18375,18390,18524,18583,18646,18718,18748,18768,18793,18882,18922,18952,18997,19020,19043,19064,19119,19133,19139,19147,19193,19233,19247,19437,19475,19604,19700,19758,19764,19880,19913,19918,19920,19930,20016,20127,20189,20223,20355,20361,20402,20556,20586,20614,20655,20660,20665,20671,20705,20807,20809,20820,20878,20941,20947,20967,21046,21049,21079,21166,21226,21240,21255,21294,21297,21305,21350,21420,21451,21510,21536,21554,21640,21739,21831,21866,21878,22082,22197,22198,22238,22317,22347,22348,22359,22364,22367,22395,22454,22500,22509,22553,22563,22571,22649,22711,22732,22741,22750,22751,22770,22775,22856,22877,22883,22986,23076,23078,23100,23130,23148,23188,23214,23231,23259,23286,23340,23367,23418,23438,23444,23527,23553,23575,23612,23649,23665,23680,23693,23716,23767,23783,23819,23849,23856,23869,23896,23955,23964,24077,24100,24200,24219,24282,24322,24337,24375,24397,24475,24559,24576,24668,24684,24689,24695,24716,24723,24737,24750,24760,24767,24780,24853,24860,24863,24872,24970,25004,25048,25123,25125,25135,25174,25178,25212,25310,25343,25374,25394,25397,25415,25460,25560,25567,25621,25664,25696,25699,25703,25709,25717,25799,25807,25938,25947,26030,26041,26173,26230,26250,26288,26582,26620,26760,26765,26818,27138,27245,27248,27283,27318,27438,27478,27557,27592,27790,27949,27968,28005,28184,28303,28313,28548,28557,28563,28575,28581,28630,29319,29355,29382,29438,29443,29536,29694,29695,29697,29711,29936,31684,35632,35741,35760,35846,35899,35975,36154,36367,36402,36447,36490,36583,36897,37345,37577,38226,38237,38352,38850,38899,38991,39214,39286,39558,39580,39642,39677,39737,39761,39801,39892,40120,40220,40271,40272,40375,40528,40594,40739,40773,40813,40887,40922,40973,41122,41217,41475,41636,41761,41826,42486,42563,42591,42680,42766,42944,43330,43569,43570,43571,43755,43856,43972,43973,44143,44160,44469,44843,44933,44998)
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 | 693 | 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.41 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.17 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 1.09 ms |
preparing | 0.54 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.31 ms |
end | 0.06 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.04 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 |