Tiempo de la consulta: 5.13 ms Después de la última consulta: 1.10 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.374 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 04:57:29')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 04:57:29')
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(3,8,11,46,57,62,64,73,99,114,124,130,149,155,177,180,186,188,189,198,202,212,214,215,220,221,244,246,248,250,253,260,330,337,394,412,417,418,419,423,427,433,439,452,459,481,521,524,544,550,551,567,583,587,595,596,597,603,604,612,613,628,641,647,659,662,678,686,699,779,788,842,845,852,902,927,938,954,1015,1058,1066,1099,1100,1114,1119,1218,1222,1227,1268,1269,1271,1272,1273,1274,1357,1397,1409,1410,1412,1428,1432,1475,1512,1519,1543,1606,1619,1627,1648,1694,1724,1740,1794,1795,1796,1800,1803,1808,1810,1843,1853,1904,1930,1960,1975,2012,2035,2048,2053,2061,2088,2092,2122,2137,2142,2155,2189,2190,2197,2241,2288,2342,2389,2431,2482,2532,2551,2581,2589,2598,2609,2613,2687,2710,2739,2746,2811,2838,2852,2900,2906,2937,2943,2962,3027,3031,3032,3120,3130,3144,3156,3193,3224,3240,3258,3296,3330,3415,3416,3417,3418,3473,3512,3515,3554,3557,3605,3637,3674,3721,3748,3815,3822,3823,3836,3848,3858,4017,4031,4034,4068,4077,4107,4175,4207,4298,4301,4414,4436,4437,4490,4550,4561,4569,4580,4611,4623,4640,4767,4815,4831,4844,4846,4877,4881,4905,5018,5024,5032,5045,5055,5096,5123,5137,5164,5190,5213,5249,5267,5270,5289,5306,5329,5338,5368,5370,5387,5419,5421,5454,5562,5581,5582,5704,5762,5777,5894,5899,5909,5912,5927,6011,6041,6093,6112,6194,6196,6253,6258,6264,6355,6405,6549,6564,6737,6759,6939,7032,7324,7385,7386,7393,7394,7412,7474,7491,7529,7669,7725,7732,7795,7817,7878,7885,7942,8008,8080,8084,8087,8100,8117,8163,8176,8240,8291,8330,8331,8358,8363,8364,8369,8387,8398,8409,8421,8424,8455,8470,8506,8512,8517,8599,8644,8667,8671,8703,8758,8803,8804,8826,8869,8873,8875,8930,8954,8977,8980,8998,9009,9019,9020,9087,9167,9184,9219,9234,9282,9295,9302,9325,9327,9354,9360,9387,9400,9420,9453,9460,9515,9640,9679,9697,9732,9793,9838,9850,9855,9886,9930,10042,10046,10082,10124,10148,10172,10393,10473,10483,10509,10513,10614,10671,10708,10720,10764,10998,11089,11184,11275,11436,11706,11728,11748,11772,11846,11854,12202,12214,12256,12268,12271,12288,12298,12334,12380,12427,12468,12590,12745,12806,12886,12900,12905,12906,12907,12908,12909,12910,12911,12912,12913,12914,12915,12958,13027,13037,13094,13113,13130,13135,13142,13186,13205,13246,13264,13285,13328,13353,13391,13426,13556,13558,13582,13702,13748,13794,14074,14097,14114,14177,14193,14211,14218,14224,14242,14260,14306,14355,14388,14458,14460,14494,14504,14527,14532,14565,14571,14607,14645,14693,14703,14824,14848,14866,14914,14944,14950,14957,14969,14976,14977,14978,15006,15098,15126,15137,15151,15154,15175,15235,15260,15270,15321,15324,15328,15364,15387,15406,15428,15458,15470,15473,15487,15490,15500,15513,15518,15533,15542,15562,15580,15602,15604,15618,15624,15630,15667,15707,15709,15743,15776,15781,15784,15800,15817,15822,15823,15832,15909,15940,15955,15964,15985,16002,16007,16017,16024,16027,16036,16039,16056,16074,16114,16137,16164,16192,16223,16245,16254,16275,16279,16297,16301,16316,16337,16344,16351,16358,16372,16373,16375,16382,16393,16396,16403,16405,16412,16414,16417,16435,16475,16479,16498,16520,16556,16563,16566,16619,16643,16656,16683,16722,16790,16791,16830,16838,16845,16861,16886,16917,16922,16924,16962,17008,17028,17056,17085,17152,17170,17172,17214,17268,17283,17293,17298,17337,17344,17360,17380,17422,17442,17458,17465,17499,17507,17549,17567,17584,17597,17628,17629,17699,17798,17806,17807,17850,17856,17863,17880,17905,17918,17923,17946,17957,17976,17977,17984,18005,18006,18021,18046,18047,18050,18063,18140,18147,18161,18168,18194,18225,18235,18244,18246,18254,18258,18259,18281,18313,18329,18334,18354,18357,18361,18413,18418,18435,18439,18460,18480,18491,18496,18524,18537,18540,18544,18575,18588,18598,18603,18609,18629,18632,18635,18646,18649,18655,18659,18665,18706,18727,18742,18746,18754,18757,18766,18769,18790,18804,18859,18861,18868,18874,18885,18894,18904,18908,18918,18930,18933,18953,18976,18989,19005,19042,19051,19061,19073,19082,19177,19180,19219,19237,19282,19293,19299,19301,19320,19322,19346,19427,19452,19473,19490,19495,19503,19569,19584,19594,19604,19641,19647,19674,19695,19709,19796,19832,19837,19867,19876,19904,20001,20072,20147,20150,20152,20215,20264,20286,20293,20306,20350,20391,20397,20400,20401,20410,20442,20445,20464,20473,20481,20484,20509,20529,20530,20534,20572,20579,20606,20621,20630,20661,20705,20707,20709,20714,20808,20813,20830,20843,20865,20877,20910,20920,20928,20954,20963,20973,20974,20990,20999,21000,21002,21008,21012,21021,21033,21040,21047,21049,21059,21070,21084,21090,21123,21138,21149,21166,21169,21172,21204,21225,21264,21270,21288,21313,21322,21429,21437,21466,21472,21474,21491,21508,21543,21547,21640,21641,21650,21683,21695,21732,21738,21741,21750,21757,21764,21778,21810,21820,21861,21864,21898,21960,21972,21973,21976,21999,22017,22026,22034,22049,22085,22112,22136,22162,22204,22209,22242,22321,22362,22402,22427,22455,22477,22511,22522,22530,22544,22590,22640,22651,22663,22684,22709,22737,22745,22758,22816,22838,22894,22941,22955,22991,22997,23017,23023,23049,23085,23095,23097,23136,23201,23217,23234,23254,23280,23285,23317,23320,23340,23352,23396,23399,23437,23469,23492,23559,23560,23571,23582,23585,23591,23596,23605,23625,23662,23679,23681,23685,23712,23736,23772,23803,23804,23811,23819,23847,23898,23945,23951,23961,23986,23999,24045,24055,24087,24101,24127,24139,24153,24180,24181,24189,24203,24205,24206,24250,24265,24307,24313,24325,24333,24359,24385,24386,24401,24426,24449,24513,24540,24549,24580,24585,24628,24642,24644,24645,24668,24681,24694,24709,24730,24745,24802,24803,24806,24848,24862,24865,24875,24877,24878,24895,24925,24973,25001,25004,25020,25021,25030,25053,25061,25101,25105,25127,25134,25147,25155,25178,25204,25209,25210,25253,25257,25293,25296,25376,25378,25399,25401,25407,25424,25440,25444,25465,25499,25503,25523,25534,25536,25556,25559,25561,25569,25572,25582,25649,25686,25721,25787,25941,26172,26245,26268,26284,26347,26349,26352,26356,26444,26548,26588,26808,26863,26999,27104,27198,27233,27302,27307,27369,27406,27410,27542,27625,27736,27737,27801,27871,28248,28281,28343,28402,28416,28436,28442,28458,28463,28504,28534,28547,28555,28575,28619,28683,28736,28809,28817,28867,28918,29003,29014,29033,29201,29221,29312,29437,29440,29444,29501,29535,29553,29586,29824,29906,29938,30284,30596,30696,31114,31116,31519,31663,31763,31885,31896,32182,32813,33115,33178,33179,33181,33274,33416,33421,33559,33592,33649,33951,34024,34066,34069,34079,34080,34086,34120,34131,34155,34205,34210,34222,34223,34230,34231,34240,34255,34261,34283,34296,34304,34308,34335,34346,34356,34573,35285,35437,35498,35517,35676,35752,35768,35792,35851,35875,35895,35959,36049,36050,36056,36100,36630,36832,37056,37210,37695,37696,37702,37843,38235,38261,38475,38701,38798,38807,38833,39180,39186,39258,39267,39333,39463,39469,39491,39495,39543,39594,39602,39615,39711,39750,39775,39819,39870,39884,39916,39922,39933,40207,40208,40355,40370,40388,40402,40516,40572,40682,40734,40837,40995,41016,41102,41185,41236,41241,41253,41270,41304,41444,41525,41526,41541,41606,41823,41946,41960,42024,42025,42067,42132,42251,42296,42342,42360,42408,42421,42425,42426,42444,42457,42748,42767,42787,42820,42824,42839,42899,43002,43052,43060,43069,43084,43087,43122,43144,43223,43293,43388,43451,43621,43717,43740,43906,43913,43979,44066,44161,44396,44509,44749,44763,44787,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 | 1286 | 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.63 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.27 ms |
System lock | 0.02 ms |
optimizing | 0.09 ms |
statistics | 1.98 ms |
preparing | 0.98 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.37 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.06 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 |