Tiempo de la consulta: 5.15 ms Después de la última consulta: 1.21 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.483 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-08 06:46:00')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-08 06:46:00')
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(14,126,127,128,129,138,190,195,269,318,385,406,452,470,473,489,494,497,596,597,614,626,633,666,667,672,675,681,692,701,709,733,737,771,794,802,835,861,864,868,872,880,889,894,903,909,910,924,928,943,980,994,1004,1005,1021,1044,1062,1066,1092,1112,1132,1174,1182,1190,1210,1231,1247,1256,1285,1286,1297,1339,1355,1358,1426,1465,1476,1496,1611,1641,1683,1705,1709,1712,1718,1776,1837,1883,1907,1971,1973,2015,2124,2136,2227,2331,2381,2467,2469,2534,2553,2617,2657,2671,2687,2697,2706,2738,2779,2790,2807,2850,2911,2946,2972,2997,3027,3060,3082,3193,3224,3240,3244,3267,3268,3317,3330,3384,3386,3424,3440,3444,3563,3573,3620,3792,3832,3868,3869,3905,3943,3952,4008,4025,4029,4035,4084,4224,4234,4235,4255,4273,4313,4331,4332,4361,4362,4364,4381,4391,4444,4560,4624,4675,4700,4732,4752,4771,4794,4801,4813,4815,4835,4844,4845,4880,4907,4992,5000,5037,5041,5074,5075,5101,5176,5182,5191,5195,5207,5215,5219,5248,5263,5269,5283,5318,5333,5390,5423,5463,5469,5583,5591,5592,5629,5639,5648,5708,5799,5803,5834,5846,5859,5867,5901,5970,5981,6009,6015,6046,6084,6124,6130,6160,6199,6233,6286,6319,6335,6357,6378,6393,6396,6404,6429,6430,6468,6497,6532,6548,6575,6625,6692,6719,6747,6758,6810,6820,6837,6848,6867,6939,6941,6960,6973,7018,7037,7100,7191,7193,7242,7266,7278,7297,7324,7329,7340,7360,7394,7395,7416,7492,7538,7543,7553,7567,7580,7581,7582,7702,7721,7723,7798,7815,7821,7869,7938,7965,7978,7996,8024,8077,8087,8105,8187,8216,8294,8296,8297,8303,8313,8328,8375,8417,8443,8475,8477,8512,8610,8638,8685,8715,8819,8822,8825,8891,9004,9011,9073,9088,9137,9184,9199,9238,9288,9296,9375,9516,9536,9573,9656,9716,9752,9754,9776,9784,9809,9899,9958,9970,10011,10100,10129,10140,10156,10202,10224,10285,10296,10301,10364,10449,10454,10467,10481,10494,10519,10541,10635,10677,10709,10759,10764,10779,10792,10793,11034,11040,11044,11089,11137,11147,11195,11206,11207,11212,11224,11235,11240,11250,11301,11317,11397,11398,11431,11443,11462,11465,11475,11541,11549,11551,11552,11568,11590,11609,11669,11681,11684,11685,11693,11694,11699,11701,11705,11750,11751,11788,11793,11794,11807,11815,11827,11842,11853,11854,11857,11859,11880,11989,12006,12020,12052,12135,12201,12215,12242,12266,12315,12324,12334,12368,12375,12420,12439,12458,12500,12505,12506,12523,12550,12567,12584,12648,12663,12668,12752,12818,12819,12830,12839,12854,12900,12949,12974,13083,13152,13168,13190,13197,13202,13209,13220,13232,13264,13269,13297,13313,13315,13335,13343,13357,13386,13429,13436,13454,13579,13581,13593,13616,13722,13729,13822,13831,13847,13850,13853,13861,13875,13880,13894,13896,13925,13941,13947,13970,13973,14125,14126,14129,14134,14146,14155,14159,14185,14211,14290,14320,14337,14356,14364,14400,14402,14403,14425,14427,14436,14439,14577,14658,14688,14700,14733,14759,14769,14771,14779,14797,14809,14873,14876,14927,14928,14941,14969,14975,14981,14997,15001,15013,15074,15087,15091,15223,15227,15250,15261,15272,15282,15291,15293,15312,15314,15330,15364,15392,15433,15460,15479,15532,15537,15553,15582,15583,15689,15762,15804,15806,15848,15859,15865,15868,15893,15927,15969,15971,16080,16121,16125,16142,16162,16220,16224,16260,16284,16313,16318,16348,16390,16394,16416,16423,16428,16481,16526,16545,16578,16585,16596,16607,16630,16636,16637,16641,16674,16693,16704,16742,16772,16800,16857,16860,16880,16903,16904,16913,16916,16924,16940,16944,16947,16959,16968,16969,16996,17020,17026,17054,17055,17059,17093,17115,17117,17137,17142,17203,17206,17209,17232,17268,17269,17295,17301,17352,17353,17356,17371,17372,17374,17377,17407,17416,17427,17527,17535,17593,17606,17630,17642,17681,17683,17746,17750,17767,17770,17784,17788,17798,17799,17843,17851,17863,17901,17934,17942,18037,18040,18068,18076,18105,18145,18165,18168,18235,18257,18260,18265,18283,18284,18312,18326,18327,18383,18384,18389,18417,18422,18442,18448,18454,18476,18492,18502,18531,18534,18535,18542,18547,18548,18549,18551,18599,18638,18710,18717,18747,18771,18777,18778,18803,18817,18835,18836,18851,18893,18923,18927,18931,18934,18950,18954,18968,18973,18980,18996,19041,19081,19085,19092,19113,19156,19158,19172,19186,19197,19281,19292,19365,19428,19481,19493,19508,19544,19547,19549,19553,19570,19573,19586,19591,19596,19618,19641,19673,19678,19689,19690,19694,19698,19742,19745,19756,19778,19789,19800,19802,19804,19835,19900,19918,19919,19924,19950,20025,20080,20082,20129,20141,20202,20235,20267,20274,20288,20297,20300,20321,20387,20396,20417,20534,20535,20567,20570,20575,20601,20624,20650,20682,20689,20693,20694,20698,20733,20740,20745,20806,20808,20818,20828,20836,20861,20879,20883,20918,20928,20997,21006,21019,21027,21031,21033,21051,21059,21070,21114,21147,21154,21162,21174,21203,21204,21206,21214,21229,21233,21236,21261,21268,21274,21283,21291,21298,21308,21311,21342,21353,21354,21356,21358,21361,21362,21375,21383,21408,21411,21488,21528,21533,21536,21552,21559,21564,21592,21593,21647,21649,21654,21656,21671,21677,21691,21703,21741,21769,21787,21790,21805,21810,21815,21817,21818,21826,21828,21837,21844,21848,21868,21875,21911,21929,21934,21939,21940,21959,21985,21986,22014,22018,22036,22037,22045,22104,22120,22131,22158,22161,22180,22200,22201,22209,22244,22245,22246,22260,22321,22377,22401,22408,22426,22453,22541,22546,22550,22560,22585,22591,22630,22677,22755,22758,22790,22816,22845,22854,22860,22938,22939,22953,22954,22968,22991,23028,23044,23051,23083,23084,23085,23145,23164,23173,23217,23290,23309,23334,23350,23379,23413,23434,23460,23498,23561,23645,23713,23803,23860,23894,23906,23979,24011,24043,24087,24123,24151,24155,24163,24176,24185,24191,24223,24225,24234,24281,24309,24330,24357,24363,24387,24406,24407,24408,24499,24500,24502,24549,24572,24575,24591,24623,24628,24644,24675,24687,24697,24708,24719,24725,24729,24731,24858,24882,25030,25061,25110,25130,25283,25567,25580,25598,25607,25608,25617,25622,25625,25626,25630,25631,25661,25670,25682,25695,25700,25725,25750,25770,25772,25792,25818,25829,25845,25848,25860,25865,25906,25912,25945,25963,25983,26003,26014,26019,26031,26044,26051,26056,26068,26078,26080,26108,26136,26182,26198,26281,26287,26332,26334,26353,26362,26377,26378,26379,26399,26403,26410,26447,26448,26454,26472,26473,26486,26489,26543,26554,26582,26616,26625,26626,26627,26630,26641,26661,26734,26753,26785,26803,26804,26838,26839,26866,26887,26922,26948,26950,26955,27055,27107,27109,27118,27120,27124,27133,27161,27164,27179,27206,27240,27275,27287,27300,27302,27312,27313,27322,27362,27376,27437,27445,27450,27457,27465,27491,27548,27550,27694,27788,27803,27892,27920,28192,28241,28249,28453,28608,28733,28743,28837,28864,28886,28898,28959,29001,29164,29167,29314,29461,29475,29508,29559,29589,29653,29837,29931,30806,30810,31019,31050,31533,31640,31670,31716,31908,32322,32912,33164,33440,33477,33504,33505,33506,33507,33508,33509,33510,33511,33575,34087,34185,34186,34195,34220,34381,34580,35047,35127,35178,35428,35574,35594,35597,35674,35760,35776,35862,36004,36109,36283,36403,36425,36431,36474,36511,36698,37397,37966,38005,38159,38175,38183,38193,38334,38763,38798,38833,38858,38901,38954,39036,39095,39121,39302,39335,39455,39480,39572,39616,39617,39726,39761,39839,39984,39997,40214,40256,40533,40558,40756,40829,40887,40888,40943,41081,41270,41385,41430,41769,41994,42357,42386,42915,42922,42978,43005,43031,43064,43193,43306,43328,43413,43438,43517,43518,43545,43585,43586,43631,43656,43660,43945,44487,44682,44726,44768,44883,44884,44885,44886,44887,44888,44889,44890)
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 | 1299 | 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.59 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.05 ms |
init | 0.25 ms |
System lock | 0.02 ms |
optimizing | 0.09 ms |
statistics | 1.98 ms |
preparing | 1.04 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.43 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.06 ms |
freeing items | 0.07 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 |