Tiempo de la consulta: 7.16 ms Después de la última consulta: 0.83 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.203 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 20:12:40')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 20:12:40')
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(137,185,214,259,330,367,374,416,417,450,556,583,697,754,825,843,1006,1223,1230,1286,1326,1351,1384,1412,1496,1504,1540,1556,1565,1660,1776,1870,2013,2109,2354,2384,2628,2643,2687,2825,2870,2884,2898,2939,3033,3074,3077,3283,3375,3377,3425,3427,3443,3462,3473,3478,3512,3564,3567,3590,3641,3721,3847,3899,3934,3962,4025,4049,4172,4192,4194,4257,4335,4386,4468,4620,4622,4673,4674,4677,4690,4693,4718,4741,4767,4816,4825,4834,4876,4959,5053,5072,5138,5183,5233,5247,5291,5299,5390,5398,5495,5515,5644,5646,5659,5827,5837,5840,5850,5888,6071,6142,6164,6258,6381,6458,6501,6549,6582,6677,6690,6782,6847,6872,6916,6950,6976,7104,7168,7428,7513,7594,7647,7678,7726,7966,7975,7991,7993,7995,7998,8037,8129,8269,8273,8338,8355,8391,8509,8569,8667,8773,8776,8834,8926,9056,9057,9058,9109,9115,9263,9351,9425,9525,9590,9728,9731,9733,9773,9881,10017,10101,10111,10268,10299,10340,10612,10673,10796,10803,10981,10991,11072,11488,11626,11661,11693,11694,11826,12302,12332,12377,12441,12500,12621,12681,12878,12880,12897,12901,12974,12992,13002,13126,13153,13319,13321,13436,13476,13585,13586,13608,13629,13731,13734,13750,13775,13811,13858,13859,13922,13930,14047,14212,14269,14402,14428,14631,14879,14944,14953,15063,15118,15208,15227,15306,15411,15421,15464,15516,15608,15611,15613,15682,15755,15903,16088,16214,16233,16340,16365,16439,16450,16503,16507,16547,16581,16646,16667,16672,16719,16831,16840,16846,16905,16908,16917,16960,16994,16998,17000,17055,17063,17090,17136,17400,17408,17421,17440,17446,17458,17487,17595,17629,17643,17644,17645,17662,17680,17699,17721,17737,17785,17798,17823,17839,17862,17881,17886,17946,17947,17965,17968,17976,17977,18003,18006,18021,18035,18036,18066,18088,18139,18151,18168,18171,18191,18203,18241,18253,18259,18308,18311,18347,18348,18354,18396,18413,18426,18469,18473,18490,18491,18497,18500,18540,18575,18609,18635,18638,18664,18746,18751,18770,18775,18790,18795,18807,18816,18828,18868,18908,18917,18918,18933,18949,18992,19005,19019,19031,19079,19082,19096,19104,19130,19134,19192,19260,19267,19288,19301,19310,19320,19327,19346,19367,19390,19400,19432,19463,19484,19495,19529,19531,19561,19586,19594,19659,19684,19696,19710,19723,19751,19786,19816,19824,19832,19835,19876,19922,19939,19982,19988,19989,20017,20052,20057,20095,20134,20135,20150,20176,20177,20187,20188,20193,20211,20213,20264,20277,20298,20307,20310,20340,20343,20391,20401,20410,20421,20424,20442,20448,20481,20483,20484,20520,20550,20567,20572,20601,20630,20683,20705,20708,20709,20713,20714,20727,20752,20808,20813,20830,20860,20865,20869,20871,20881,20886,20907,20910,20920,20925,20954,20967,20973,20990,21002,21012,21021,21033,21042,21047,21050,21059,21069,21080,21090,21103,21107,21112,21117,21134,21154,21159,21169,21204,21229,21247,21262,21273,21288,21295,21342,21397,21402,21410,21439,21453,21459,21466,21474,21485,21486,21491,21500,21504,21508,21543,21547,21559,21560,21563,21574,21581,21591,21610,21617,21618,21640,21641,21648,21650,21660,21670,21683,21688,21690,21699,21700,21738,21756,21761,21764,21767,21800,21808,21810,21837,21853,21902,21907,21909,21926,21960,21971,21976,21977,21982,22015,22017,22033,22034,22050,22073,22081,22085,22112,22132,22162,22164,22204,22242,22249,22278,22281,22285,22292,22305,22321,22353,22394,22405,22444,22502,22514,22522,22525,22544,22545,22552,22568,22584,22590,22606,22619,22646,22658,22707,22716,22737,22745,22749,22757,22759,22816,22838,22868,22894,22968,22970,22971,22991,22997,23003,23017,23035,23051,23063,23065,23070,23072,23085,23095,23097,23099,23117,23127,23132,23135,23136,23176,23190,23194,23196,23201,23216,23217,23239,23250,23257,23264,23265,23270,23280,23295,23302,23317,23320,23345,23348,23349,23351,23352,23383,23396,23397,23401,23420,23431,23452,23455,23457,23471,23476,23512,23517,23528,23556,23560,23571,23582,23605,23609,23631,23649,23662,23680,23681,23685,23686,23712,23741,23772,23787,23800,23806,23811,23813,23814,23826,23847,23851,23854,23888,23945,23951,23953,23961,23963,23973,23975,23999,24045,24051,24055,24100,24112,24120,24127,24139,24148,24164,24165,24169,24175,24185,24189,24203,24204,24206,24213,24223,24244,24245,24246,24248,24307,24333,24385,24401,24410,24414,24425,24426,24439,24483,24502,24513,24549,24556,24560,24583,24591,24594,24628,24644,24651,24681,24694,24720,24730,24750,24796,24800,24824,24848,24861,24865,24877,24878,24896,24912,24925,24941,24966,24967,24969,24973,24975,24977,24998,25021,25025,25031,25053,25057,25061,25089,25094,25118,25122,25127,25129,25171,25210,25243,25287,25296,25304,25351,25355,25369,25372,25378,25396,25399,25407,25424,25436,25439,25440,25458,25460,25473,25517,25520,25522,25523,25524,25525,25528,25535,25536,25541,25551,25552,25568,25582,25591,25596,25649,25690,25702,25730,25769,25775,25779,25781,25790,25835,25844,25874,25891,25941,25962,25983,25995,26033,26044,26082,26095,26147,26164,26172,26201,26241,26271,26283,26296,26318,26320,26334,26351,26354,26362,26366,26374,26504,26516,26587,26588,26601,26613,26629,26638,26652,26690,26694,26734,26760,26796,26806,26814,26935,26936,26999,27009,27048,27100,27101,27119,27124,27134,27139,27156,27162,27175,27242,27250,27252,27259,27302,27315,27330,27344,27353,27354,27384,27397,27425,27445,27455,27480,27490,27491,27524,27526,27532,27551,27559,27571,27592,27622,27630,27635,27643,27673,27683,27688,27783,27803,27806,27808,27809,27818,27860,27873,27875,27907,27958,27985,27992,28030,28081,28117,28129,28178,28281,28328,28336,28361,28429,28458,28483,28504,28545,28555,28562,28577,28582,28683,28691,28703,28728,28777,28829,28963,28979,28982,28999,29077,29091,29108,29127,29159,29214,29223,29289,29293,29298,29320,29418,29619,29886,30269,31623,31624,32679,34177,34195,34205,34417,34489,34639,34690,34888,34944,35221,35300,35452,35574,35657,35674,35684,35710,35857,35917,35926,35936,35959,36033,36135,36216,36267,36298,36398,36427,36499,36813,36901,36990,37925,38651,38689,38961,39603,40072,40370,40578,40822,41089,41185,41868,42899,42900,42908,43412,43581,43750,43906,44682,44830,45071,45072)
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 | 1024 | 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.75 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.44 ms |
System lock | 0.04 ms |
optimizing | 0.09 ms |
statistics | 2.72 ms |
preparing | 1.60 ms |
Sorting result | 0.04 ms |
executing | 0.01 ms |
Sending data | 0.35 ms |
end | 0.01 ms |
query end | 0.06 ms |
closing tables | 0.01 ms |
freeing items | 0.10 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 |