Tiempo de la consulta: 3.76 ms Después de la última consulta: 0.76 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 4.474 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 19:05:37')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 19:05:37')
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,55,58,71,72,75,119,131,133,139,146,155,164,165,181,203,255,256,272,275,283,339,343,344,349,371,416,432,437,475,498,549,577,581,607,609,657,669,679,700,757,782,797,816,851,900,916,929,986,1012,1015,1046,1053,1056,1080,1140,1169,1204,1207,1235,1238,1262,1277,1304,1306,1308,1318,1319,1416,1504,1903,1966,2129,2222,2322,2560,2566,2672,2681,2713,2968,3064,3102,3106,3107,3279,3329,3353,3422,3427,3434,3447,3463,3634,3752,3768,3786,3823,3970,3976,3986,3988,4028,4061,4104,4515,4521,4533,4598,4784,4840,4848,4854,4910,4973,5018,5020,5150,5181,5247,5300,5451,5483,5545,5559,5647,5699,5800,5801,5870,5894,6062,6262,6311,6330,6344,6393,6442,6540,6542,6543,6577,6616,6660,6742,6804,6945,7105,7249,7282,7311,7458,7526,7551,7569,7572,7584,7588,7617,7668,7718,7732,7745,7771,7789,7806,7929,7950,7995,7998,8027,8114,8115,8133,8295,8499,8530,8663,8741,8759,8832,9010,9091,9239,9351,9398,9571,9574,9578,9608,9745,9860,9864,9922,9926,9979,9983,10110,10120,10188,10194,10239,10240,10304,10349,10369,10389,10420,10423,10465,10686,10713,10757,10761,10769,10830,10852,10912,10925,10950,10955,10957,10958,10970,11002,11008,11035,11076,11146,11150,11269,11366,11391,11424,11438,11441,11470,11503,11730,11760,11769,11958,12064,12127,12212,12218,12286,12388,12393,12403,12445,12517,12519,12521,12548,12562,12567,12576,12670,12684,12685,12712,12725,12758,12761,12852,12864,12902,12940,12959,12978,13036,13038,13105,13115,13188,13199,13366,13433,13587,13595,13608,13614,13671,13692,13731,13734,13792,13854,13869,13994,14005,14070,14101,14186,14201,14204,14227,14229,14237,14249,14270,14305,14331,14341,14389,14410,14482,14495,14522,14591,14746,14807,14840,14846,14850,14883,14911,14931,14981,14993,15003,15069,15100,15111,15150,15242,15245,15286,15293,15305,15355,15438,15475,15518,15520,15522,15543,15689,15722,15728,15740,15894,15940,15995,16163,16209,16358,16366,16375,16427,16450,16451,16528,16604,16626,16645,16654,16675,16685,16777,16814,16819,16848,16984,16996,17042,17047,17050,17060,17090,17093,17124,17132,17146,17155,17211,17268,17273,17300,17313,17339,17367,17407,17456,17470,17481,17518,17537,17551,17555,17613,17654,17659,17665,17688,17716,17753,17759,17766,17810,17826,17839,17867,17870,17880,17924,17925,17931,17979,17988,17999,18000,18032,18081,18218,18242,18277,18293,18304,18311,18348,18364,18375,18390,18410,18443,18451,18494,18524,18583,18612,18625,18629,18693,18702,18705,18708,18751,18762,18764,18793,18814,18827,18839,18840,18843,18853,18854,18882,18883,18901,18916,18947,18952,19043,19107,19119,19133,19134,19147,19165,19178,19222,19229,19247,19255,19260,19284,19290,19314,19338,19375,19378,19395,19414,19416,19418,19420,19439,19447,19452,19455,19511,19615,19616,19634,19644,19645,19646,19652,19659,19700,19707,19731,19733,19758,19764,19812,19819,19822,19824,19832,19857,19875,19880,19908,19913,20016,20023,20040,20045,20091,20104,20140,20161,20223,20261,20276,20285,20303,20318,20348,20355,20357,20363,20379,20402,20443,20461,20472,20542,20553,20577,20586,20614,20665,20705,20714,20758,20775,20807,20820,20825,20878,20889,20917,20940,20941,20957,20967,20983,21009,21046,21052,21060,21075,21107,21119,21171,21206,21218,21226,21240,21255,21323,21350,21378,21384,21398,21433,21447,21491,21492,21498,21545,21546,21609,21714,21740,21746,21749,21751,21777,21864,21866,21870,21880,21945,22027,22038,22072,22099,22113,22187,22194,22198,22315,22332,22340,22349,22364,22395,22407,22432,22495,22500,22509,22519,22529,22554,22559,22561,22572,22584,22595,22596,22605,22613,22660,22715,22732,22741,22750,22804,22819,22856,22858,22879,22911,22920,22951,22999,23008,23022,23033,23052,23055,23069,23100,23130,23190,23239,23242,23259,23262,23273,23279,23295,23318,23326,23367,23424,23430,23438,23456,23463,23518,23555,23568,23569,23617,23618,23626,23646,23649,23650,23653,23662,23665,23693,23695,23709,23714,23716,23719,23767,23774,23840,23921,23925,23953,23964,24012,24026,24056,24064,24077,24100,24106,24145,24157,24168,24175,24200,24217,24233,24236,24258,24268,24272,24275,24278,24291,24322,24329,24337,24368,24386,24428,24437,24499,24565,24577,24581,24590,24594,24605,24634,24648,24668,24695,24737,24773,24780,24825,24841,24862,24891,24899,24909,24941,24978,25004,25048,25077,25091,25116,25123,25135,25147,25178,25187,25212,25225,25230,25281,25293,25300,25333,25338,25356,25386,25397,25412,25415,25460,25560,25664,25709,25711,25762,25807,25820,25965,25971,25984,26053,26175,26188,26223,26288,26332,26375,26398,26431,26444,26487,26551,26620,26633,26646,26760,26805,26818,26835,26842,26843,26864,27060,27076,27138,27145,27161,27178,27186,27197,27317,27321,27384,27387,27438,27525,27592,27633,27790,27832,27842,27918,27921,27923,27924,27926,27949,27957,27968,28005,28313,28372,28436,28548,28552,28557,28563,28575,28581,28630,28662,28666,29143,29223,29318,29319,29382,29611,29613,29694,29695,29711,29719,29743,29930,30000,31908,32562,33749,35221,35449,36161,36316,36389,36465,36496,37712,37845,38276,38560,38932,39558,39629,39966,40221,40505,40813,40922,41257,41732,42163,45051)
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 | 880 | 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.44 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.19 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.33 ms |
preparing | 0.69 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.31 ms |
end | 0.01 ms |
query end | 0.01 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 |