Tiempo de la consulta: 8.65 ms Después de la última consulta: 2.10 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.430 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-09 19:37:32')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 19:37:32')
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(5,7,9,14,29,39,56,60,62,63,65,71,73,86,87,99,114,149,164,174,177,196,221,226,240,259,262,291,299,331,349,366,391,412,427,428,429,472,477,481,501,510,525,530,531,546,563,595,596,604,619,659,662,663,667,674,697,705,746,769,800,802,805,808,823,832,835,842,869,873,901,910,923,939,940,954,969,974,977,982,983,999,1004,1005,1011,1021,1055,1058,1071,1091,1095,1114,1119,1158,1182,1205,1231,1247,1252,1253,1255,1268,1271,1276,1289,1308,1309,1319,1347,1363,1409,1410,1411,1412,1428,1432,1441,1444,1475,1485,1509,1557,1606,1619,1629,1648,1675,1693,1694,1724,1735,1771,1794,1795,1796,1808,1810,1843,1854,1855,1862,1899,1918,1920,1930,1960,1961,1975,1984,1994,1995,2001,2008,2013,2015,2035,2075,2088,2137,2155,2157,2161,2233,2293,2455,2527,2532,2551,2553,2586,2589,2597,2638,2643,2671,2739,2777,2789,2814,2824,2851,2881,2883,2888,2900,2960,3027,3055,3075,3091,3100,3107,3122,3127,3144,3147,3156,3169,3207,3364,3368,3369,3387,3409,3412,3473,3520,3548,3552,3554,3590,3605,3648,3674,3683,3689,3748,3853,3858,3872,3913,3919,3922,3962,3991,4034,4050,4068,4110,4129,4216,4323,4327,4355,4468,4490,4529,4532,4558,4616,4620,4622,4626,4666,4743,4751,4752,4767,4771,4794,4813,4815,4822,4831,4844,4846,4865,4905,4933,4973,5046,5047,5055,5088,5123,5134,5153,5160,5172,5190,5220,5370,5415,5469,5543,5559,5582,5708,5777,5780,5795,5999,6025,6109,6112,6148,6198,6208,6258,6355,6366,6391,6396,6420,6435,6442,6468,6476,6477,6497,6548,6549,6820,6837,6845,6855,6866,6939,6944,6958,6960,6997,7018,7022,7030,7032,7048,7137,7183,7195,7242,7258,7266,7324,7418,7491,7535,7592,7595,7648,7679,7751,7819,7856,8070,8084,8086,8100,8187,8192,8240,8291,8295,8314,8398,8419,8470,8538,8592,8602,8634,8707,8779,8801,8826,8875,8895,8954,9009,9020,9184,9237,9277,9279,9280,9282,9295,9369,9401,9488,9572,9619,9776,9850,9855,9930,9932,10011,10156,10509,10541,10572,10709,10840,11001,11147,11184,11207,11462,11555,11693,11694,11706,11788,11815,11854,12135,12242,12259,12334,12398,12408,12500,12505,12550,12590,12639,12667,12752,12839,12974,13034,13037,13126,13130,13202,13220,13246,13264,13269,13285,13358,13387,13426,13459,13556,13558,13616,13730,13896,13995,14177,14193,14218,14320,14364,14388,14425,14666,14703,14714,14733,14752,14759,14865,14873,14914,14927,14957,14969,14976,14978,15006,15038,15063,15074,15087,15203,15235,15244,15282,15312,15321,15460,15490,15518,15533,15544,15604,15667,15781,15804,15806,15807,15848,15875,15901,15913,15915,15973,16024,16122,16220,16224,16316,16344,16454,16481,16520,16545,16578,16587,16588,16612,16630,16636,16674,16693,16704,16734,16737,16742,16772,16791,16800,16830,16846,16861,16880,16904,16908,16913,16917,16969,16995,17026,17054,17055,17063,17117,17136,17137,17140,17166,17170,17172,17301,17333,17353,17372,17377,17380,17388,17400,17427,17442,17527,17584,17592,17629,17643,17644,17645,17646,17678,17680,17683,17699,17700,17737,17746,17767,17770,17785,17791,17799,17806,17807,17821,17862,17886,17936,17942,17946,17957,17965,17976,17977,18006,18021,18035,18036,18050,18068,18151,18168,18171,18191,18241,18253,18259,18265,18283,18308,18326,18327,18347,18354,18357,18374,18383,18384,18401,18413,18418,18426,18442,18444,18473,18476,18480,18491,18497,18500,18540,18542,18547,18548,18575,18635,18638,18657,18695,18714,18733,18746,18751,18754,18766,18779,18790,18795,18802,18828,18832,18868,18874,18893,18917,18918,18927,18934,19005,19015,19038,19079,19082,19158,19183,19187,19228,19258,19267,19269,19280,19282,19283,19288,19289,19293,19299,19301,19302,19307,19310,19320,19339,19389,19390,19400,19402,19421,19423,19427,19432,19458,19470,19473,19484,19495,19503,19531,19532,19533,19547,19549,19561,19569,19573,19594,19596,19684,19694,19696,19710,19721,19723,19751,19800,19804,19824,19830,19831,19832,19876,19918,19937,19939,19982,19988,19989,20017,20029,20044,20056,20057,20062,20150,20153,20176,20177,20187,20188,20193,20211,20213,20215,20232,20236,20264,20277,20278,20293,20298,20306,20307,20310,20340,20343,20391,20396,20401,20410,20421,20442,20481,20484,20508,20530,20550,20567,20572,20600,20601,20624,20630,20662,20693,20694,20705,20709,20713,20714,20727,20732,20733,20743,20752,20757,20764,20804,20808,20813,20830,20836,20843,20851,20853,20858,20860,20861,20865,20871,20877,20879,20881,20883,20907,20910,20920,20921,20925,20944,20949,20954,20973,20974,20990,20997,20999,21002,21012,21019,21021,21027,21031,21033,21040,21042,21047,21050,21059,21069,21070,21080,21084,21090,21107,21132,21134,21154,21159,21168,21169,21203,21204,21206,21217,21233,21236,21262,21268,21273,21282,21283,21288,21313,21354,21356,21358,21362,21397,21402,21410,21437,21466,21474,21483,21485,21486,21488,21491,21504,21536,21543,21547,21560,21563,21569,21574,21580,21581,21592,21593,21618,21640,21641,21650,21660,21670,21683,21688,21690,21699,21738,21756,21760,21764,21769,21787,21800,21805,21810,21820,21828,21837,21853,21864,21875,21902,21926,21940,21960,21969,21976,21977,22015,22017,22034,22037,22050,22073,22081,22085,22105,22112,22131,22136,22162,22164,22200,22204,22242,22244,22245,22246,22260,22278,22281,22292,22305,22321,22353,22377,22394,22401,22405,22426,22502,22514,22522,22544,22545,22550,22567,22585,22590,22603,22606,22646,22658,22677,22707,22716,22737,22743,22745,22757,22759,22816,22838,22847,22854,22894,22938,22939,22954,22955,22968,22970,22971,22991,22997,23003,23017,23035,23051,23063,23070,23085,23095,23097,23117,23132,23135,23136,23138,23170,23173,23181,23201,23202,23216,23217,23224,23239,23246,23257,23280,23285,23295,23302,23317,23320,23334,23336,23345,23348,23349,23350,23351,23352,23383,23396,23420,23437,23512,23526,23528,23536,23556,23560,23569,23571,23582,23585,23599,23605,23609,23617,23631,23649,23662,23673,23679,23680,23681,23682,23685,23712,23736,23772,23800,23803,23806,23811,23813,23814,23826,23847,23851,23854,23860,23875,23906,23945,23951,23953,23961,23963,23975,23999,24043,24045,24055,24067,24087,24112,24120,24127,24137,24139,24153,24163,24165,24169,24180,24181,24185,24189,24203,24204,24206,24208,24213,24219,24223,24244,24245,24246,24250,24265,24307,24325,24333,24334,24359,24385,24386,24401,24406,24407,24408,24410,24414,24415,24425,24426,24483,24484,24502,24513,24526,24549,24560,24580,24583,24585,24598,24609,24614,24623,24628,24644,24645,24651,24681,24682,24694,24709,24730,24750,24796,24797,24800,24803,24824,24826,24848,24853,24861,24865,24875,24877,24878,24895,24896,24925,24941,24966,24967,24969,24973,24977,25001,25021,25025,25030,25031,25053,25057,25061,25089,25101,25118,25127,25129,25130,25147,25155,25171,25209,25210,25243,25287,25296,25323,25351,25369,25372,25376,25378,25396,25399,25407,25424,25436,25440,25456,25458,25460,25499,25503,25517,25520,25523,25524,25525,25528,25534,25536,25541,25551,25552,25556,25559,25568,25569,25582,25591,25596,25598,25610,25622,25625,25632,25649,25686,25702,25721,25750,25772,25775,25779,25781,25818,25844,25874,25901,25912,25941,25962,25983,26003,26014,26031,26033,26044,26078,26082,26108,26125,26136,26147,26164,26172,26198,26201,26215,26241,26245,26271,26281,26283,26296,26318,26320,26351,26354,26362,26366,26378,26386,26399,26403,26405,26410,26447,26454,26548,26554,26588,26610,26613,26616,26626,26630,26694,26734,26785,26796,26803,26804,26814,26829,26839,26863,26866,26920,26948,26950,26954,26955,26999,27048,27055,27103,27104,27107,27108,27109,27118,27119,27120,27124,27133,27135,27139,27156,27157,27161,27242,27252,27275,27287,27302,27322,27330,27369,27425,27445,27450,27457,27465,27490,27491,27542,27548,27550,27551,27622,27625,27736,27801,27803,27805,27806,27818,27860,27863,27871,27875,27904,27958,27997,28030,28117,28248,28281,28328,28343,28402,28416,28429,28458,28463,28504,28555,28619,28683,28691,28703,28736,28809,28910,28918,28960,29003,29033,29108,29136,29159,29281,29298,29320,29444,29619,29824,30307,30696,30810,31019,31114,31116,31356,31519,31623,31624,31663,31671,32097,32182,32322,32679,32813,32841,33115,33178,33179,33181,33259,33274,33421,33430,33440,33504,33505,33506,33507,33508,33509,33510,33511,33559,33592,33593,33651,33784,33951,33993,33997,34008,34024,34066,34069,34079,34080,34086,34120,34131,34155,34176,34177,34185,34186,34205,34210,34222,34223,34230,34231,34240,34255,34261,34283,34296,34300,34304,34308,34315,34335,34346,34356,34417,34489,34490,34556,34573,34639,34690,34783,34888,35285,35300,35498,35506,35517,35568,35635,35657,35676,35752,35755,35768,35792,35851,35875,35895,35936,35959,36049,36050,36056,36100,36219,36298,36499,36505,36630,36738,36767,36813,36832,36843,36845,36951,36990,37408,37682,37753,37839,37843,37860,37862,38235,38701,38798,38801,38807,38833,38961,39003,39047,39113,39333,39594,39602,39615,39711,39751,39775,39906,39916,39922,40039,40072,40096,40370,40388,40516,40682,40734,40852,40963,40995,41089,41102,41147,41185,41222,41236,41253,41256,41270,41304,41311,41430,41655,41868,42296,42342,42360,42457,42530,42752,42767,42787,42799,42820,42899,42900,42908,43122,43144,43223,43293,43411,43451,43581,43621,43740,43763,43906,43913,43979,44043,44066,44396,44402,44602,44682,44743,44787,44830,44846,45000,45076,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 | 1568 | 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 | 1.13 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.30 ms |
System lock | 0.02 ms |
optimizing | 0.15 ms |
statistics | 4.22 ms |
preparing | 1.73 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.34 ms |
end | 0.01 ms |
query end | 0.03 ms |
closing tables | 0.02 ms |
freeing items | 0.09 ms |
cleaning up | 0.03 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 |