Tiempo de la consulta: 4.81 ms Después de la última consulta: 1.02 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.351 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 18:29:46')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 18:29:46')
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(49,58,71,99,114,164,263,337,339,340,342,343,347,348,349,350,352,412,427,437,476,595,604,609,669,679,782,797,842,844,851,986,1012,1022,1058,1157,1207,1277,1367,1412,1475,1754,2035,2545,2589,2739,2880,2900,2933,3020,3064,3082,3144,3254,3427,3436,3440,3464,3605,3674,3715,4710,4720,4894,5190,5472,5570,5582,5647,5777,5848,6112,6132,6258,6278,6279,6355,6442,6549,6912,6987,7032,7223,7323,7415,7435,7466,7515,7551,7569,7613,7617,7711,7819,7920,7929,8027,8046,8073,8100,8133,8187,8227,8240,8242,8295,8398,8470,8663,8826,8875,8954,9009,9020,9184,9295,9606,9850,9855,10239,10389,10423,10442,10509,10562,10761,10957,11002,11046,11111,11390,11503,11706,12160,12300,12334,12383,12403,12517,12521,12562,12590,12668,13037,13105,13117,13130,13285,13404,13426,13556,13558,13559,13560,13692,13840,13919,13965,13987,14077,14144,14177,14189,14193,14201,14208,14218,14226,14245,14349,14367,14384,14388,14483,14491,14503,14615,14627,14658,14750,14768,14831,14914,14957,14969,14978,14985,15006,15111,15127,15150,15178,15195,15273,15305,15321,15355,15377,15438,15490,15491,15518,15520,15549,15577,15639,15652,15667,15705,15722,15740,15746,15761,15838,15905,15940,15949,15963,15981,15995,16024,16063,16227,16304,16316,16344,16366,16461,16471,16520,16561,16620,16625,16626,16690,16777,16792,16819,16846,16848,16861,16907,16908,16917,16926,16967,16984,17050,17063,17124,17136,17155,17170,17172,17182,17273,17314,17380,17400,17405,17445,17466,17489,17498,17555,17610,17629,17643,17644,17645,17659,17665,17680,17699,17716,17759,17785,17798,17862,17871,17886,17901,17946,17957,17965,17974,17975,17976,17977,17999,18006,18008,18021,18030,18035,18036,18045,18081,18101,18120,18151,18163,18168,18171,18191,18218,18241,18242,18253,18259,18277,18293,18308,18311,18347,18348,18354,18365,18410,18413,18418,18426,18443,18451,18473,18491,18496,18497,18500,18519,18540,18575,18585,18625,18635,18638,18641,18723,18744,18746,18751,18762,18766,18790,18795,18796,18814,18827,18828,18868,18874,18875,18883,18917,18918,18947,18981,19004,19005,19045,19079,19082,19107,19165,19189,19229,19255,19260,19267,19288,19301,19310,19314,19320,19378,19390,19406,19416,19418,19432,19447,19452,19473,19484,19485,19495,19509,19511,19531,19561,19594,19626,19634,19684,19687,19696,19707,19710,19723,19731,19751,19792,19795,19812,19824,19832,19870,19874,19876,19908,19936,19939,19954,19982,19988,19989,19993,20017,20040,20104,20129,20136,20140,20150,20176,20187,20188,20193,20196,20211,20213,20245,20261,20264,20277,20298,20307,20310,20318,20340,20343,20348,20357,20359,20363,20379,20391,20401,20410,20421,20429,20442,20443,20461,20481,20484,20542,20550,20553,20567,20572,20601,20630,20634,20653,20705,20709,20713,20714,20727,20731,20752,20758,20775,20808,20813,20830,20865,20871,20877,20881,20899,20907,20910,20917,20920,20925,20932,20954,20957,20973,20983,20990,20999,21002,21012,21021,21033,21040,21042,21047,21050,21059,21069,21070,21080,21084,21090,21107,21119,21132,21134,21159,21169,21204,21239,21262,21273,21288,21323,21343,21350,21384,21397,21410,21437,21447,21466,21474,21485,21486,21491,21492,21504,21543,21545,21546,21547,21560,21563,21574,21581,21618,21640,21641,21650,21660,21670,21683,21688,21690,21699,21738,21756,21764,21800,21810,21820,21837,21853,21864,21880,21902,21926,21945,21960,21976,21977,22015,22017,22027,22034,22050,22073,22081,22085,22091,22112,22116,22123,22136,22162,22164,22187,22204,22242,22256,22278,22281,22292,22305,22321,22340,22353,22364,22394,22405,22407,22432,22492,22502,22514,22519,22522,22529,22544,22545,22559,22561,22590,22605,22606,22646,22658,22681,22707,22716,22734,22737,22745,22757,22759,22816,22819,22838,22858,22894,22911,22950,22955,22968,22970,22971,22991,22997,23003,23014,23017,23033,23035,23051,23052,23055,23063,23069,23070,23078,23085,23095,23097,23117,23132,23135,23136,23147,23149,23190,23201,23216,23217,23239,23242,23257,23262,23280,23285,23295,23302,23317,23318,23320,23326,23345,23347,23348,23349,23351,23352,23383,23396,23420,23437,23438,23456,23463,23512,23519,23528,23556,23560,23568,23571,23582,23585,23605,23609,23611,23617,23626,23631,23638,23649,23653,23679,23680,23681,23685,23693,23696,23712,23736,23772,23795,23800,23803,23806,23811,23813,23814,23826,23847,23851,23854,23878,23925,23945,23951,23953,23961,23963,23970,23975,23999,24045,24055,24064,24087,24106,24112,24120,24127,24132,24139,24145,24165,24169,24180,24181,24189,24203,24204,24206,24213,24223,24236,24244,24245,24246,24250,24265,24268,24278,24307,24325,24329,24333,24359,24384,24385,24386,24401,24410,24414,24418,24425,24426,24428,24471,24483,24487,24502,24513,24549,24560,24568,24577,24580,24581,24583,24628,24634,24644,24645,24651,24668,24681,24694,24709,24730,24750,24773,24796,24799,24800,24803,24813,24824,24825,24848,24861,24862,24865,24875,24877,24878,24895,24896,24899,24925,24941,24966,24967,24969,24973,24977,25001,25021,25025,25030,25031,25053,25057,25061,25065,25089,25101,25118,25127,25129,25147,25155,25171,25209,25210,25225,25243,25246,25287,25296,25341,25351,25359,25369,25372,25376,25378,25386,25396,25399,25407,25412,25424,25436,25440,25458,25460,25494,25499,25503,25517,25520,25523,25524,25525,25528,25534,25536,25541,25551,25552,25554,25556,25559,25568,25569,25582,25583,25590,25591,25596,25649,25681,25686,25702,25726,25762,25775,25779,25781,25820,25844,25850,25874,25941,25962,25965,25971,25983,26033,26044,26082,26112,26147,26164,26172,26175,26177,26201,26241,26271,26283,26296,26318,26320,26351,26354,26362,26366,26435,26444,26548,26588,26613,26684,26694,26734,26760,26796,26814,26863,26999,27048,27060,27076,27104,27119,27124,27139,27156,27242,27252,27302,27304,27330,27369,27425,27438,27525,27542,27551,27567,27622,27625,27703,27736,27801,27803,27806,27818,27860,27871,27875,27957,27958,28021,28030,28117,28281,28328,28343,28409,28416,28429,28458,28463,28504,28555,28594,28619,28683,28691,28703,28736,28809,28979,29003,29108,29159,29298,29320,29444,29613,29619,29719,29824,30696,31116,31519,31623,31624,31663,32182,32679,32813,33115,33178,33179,33181,33274,33421,33559,33592,33749,33951,34024,34066,34069,34079,34080,34086,34120,34131,34155,34177,34205,34210,34222,34223,34230,34231,34240,34255,34261,34283,34296,34304,34308,34335,34346,34356,34417,34489,34573,34639,34690,34888,35285,35300,35498,35517,35657,35676,35752,35768,35792,35851,35862,35875,35895,35936,35959,36049,36050,36056,36100,36138,36298,36499,36630,36813,36832,36990,37843,38235,38701,38798,38807,38833,38961,39224,39333,39594,39602,39615,39711,39775,39916,39922,40072,40370,40388,40516,40608,40682,40734,40852,40995,41089,41102,41185,41236,41253,41270,41304,41868,42054,42296,42342,42360,42457,42767,42787,42820,42899,42900,42908,43122,43144,43223,43293,43451,43581,43621,43740,43906,43913,43979,44066,44396,44682,44787,44830,44846,45000,45128)
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 | 1145 | 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.21 ms |
System lock | 0.02 ms |
optimizing | 0.08 ms |
statistics | 1.93 ms |
preparing | 0.91 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.35 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.06 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 |