Tiempo de la consulta: 6.38 ms Después de la última consulta: 1.00 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.384 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-07 17:41:33')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 17:41:33')
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,35,57,61,67,71,78,109,119,127,132,136,137,167,185,195,204,239,241,251,255,271,272,278,283,308,323,324,354,358,374,390,400,403,429,435,441,443,446,477,495,506,547,565,593,621,657,668,679,689,693,719,722,737,760,769,771,777,780,804,808,812,832,853,863,868,870,878,883,885,928,929,937,940,1018,1050,1061,1101,1102,1183,1188,1196,1200,1210,1216,1233,1250,1251,1264,1361,1383,1458,1459,1461,1463,1469,1478,1479,1480,1487,1503,1506,1514,1559,1567,1579,1596,1621,1623,1628,1641,1684,1690,1691,1713,1716,1735,1738,1739,1745,1756,1760,1782,1796,1806,1825,1860,1873,1887,1898,1944,1954,1975,1982,1990,2010,2016,2031,2069,2078,2082,2101,2109,2144,2146,2147,2150,2182,2188,2204,2209,2219,2224,2235,2241,2242,2243,2254,2261,2278,2319,2353,2361,2367,2372,2376,2396,2415,2425,2433,2452,2517,2530,2560,2566,2584,2595,2605,2627,2631,2636,2660,2666,2667,2674,2705,2716,2740,2756,2770,2786,2797,2804,2812,2822,2823,2849,2859,2870,2875,2894,2922,2929,2933,2967,2975,2993,3000,3001,3016,3022,3097,3108,3125,3154,3166,3183,3208,3236,3254,3264,3273,3288,3290,3303,3312,3332,3343,3346,3347,3350,3375,3390,3414,3493,3506,3511,3550,3569,3597,3750,3754,3824,3825,3832,3871,3951,3975,3983,4111,4132,4133,4240,4253,4325,4339,4357,4471,4492,4503,4631,4670,4710,4772,4784,4817,4868,4872,4896,4910,5079,5093,5095,5100,5123,5186,5275,5381,5437,5457,5471,5513,5515,5555,5561,5570,5573,5615,5798,5827,5895,5969,5998,6020,6037,6101,6102,6121,6155,6174,6176,6227,6256,6301,6315,6331,6342,6354,6363,6372,6400,6403,6445,6470,6473,6498,6515,6516,6517,6542,6543,6565,6568,6577,6593,6602,6670,6694,6742,6802,6807,6808,6840,6845,6856,6964,6975,6989,6997,7018,7026,7081,7121,7124,7130,7136,7138,7181,7205,7245,7248,7262,7265,7269,7273,7275,7283,7288,7291,7293,7300,7374,7414,7485,7528,7569,7583,7584,7594,7630,7670,7674,7743,7749,7841,7848,7872,7917,7935,7965,7985,8030,8061,8088,8109,8138,8206,8222,8297,8345,8416,8480,8494,8521,8532,8567,8603,8613,8625,8706,8740,8762,8777,8819,8828,8897,8907,8937,8978,8983,9017,9048,9056,9057,9082,9143,9152,9200,9284,9286,9314,9339,9340,9355,9423,9428,9461,9489,9552,9626,9629,9658,9764,9766,9769,9817,9818,9825,9834,9841,9894,10059,10132,10195,10255,10273,10315,10430,10462,10502,10645,10668,10765,10799,10860,10973,11022,11031,11112,11195,11237,11292,11318,11410,11418,11625,11854,11945,11948,11955,12166,12223,12388,12437,12566,12584,12599,12686,12703,12816,12846,12887,13002,13006,13018,13029,13061,13079,13097,13129,13154,13166,13190,13269,13276,13356,13488,13524,13530,13548,13550,13553,13573,13589,13641,13645,13646,13672,13712,13759,13763,13782,13821,13855,13926,13950,14005,14057,14062,14063,14081,14100,14137,14139,14148,14152,14159,14186,14188,14197,14324,14362,14389,14391,14428,14445,14447,14529,14534,14538,14550,14554,14601,14608,14636,14665,14675,14683,14684,14707,14711,14753,14754,14761,14769,14856,14864,14890,14896,14897,14905,14949,15018,15049,15059,15079,15200,15221,15245,15248,15464,15496,15530,15599,15606,15608,15719,15818,15861,15897,15944,16108,16158,16178,16197,16206,16218,16317,16321,16325,16370,16423,16432,16465,16521,16523,16571,16582,16591,16603,16698,16713,16733,16734,16788,16808,16816,16848,16865,16880,16957,17086,17100,17116,17134,17138,17155,17157,17194,17197,17234,17263,17280,17303,17309,17542,17562,17615,17649,17662,17688,17707,17727,17729,17775,17812,17835,17875,17883,17907,17908,17938,18043,18060,18084,18091,18112,18113,18129,18142,18264,18295,18321,18326,18358,18369,18380,18409,18431,18447,18490,18521,18566,18596,18626,18687,18694,18717,18739,18763,18772,18801,18826,18837,18859,18867,18880,18912,18927,18934,18937,18944,18969,18984,18997,19003,19086,19126,19133,19134,19217,19223,19291,19303,19348,19364,19383,19419,19448,19454,19464,19507,19541,19552,19572,19586,19634,19653,19659,19660,19693,19790,19828,19834,19855,19871,19873,19913,19921,19971,20003,20024,20036,20042,20058,20065,20073,20088,20163,20198,20258,20281,20329,20347,20378,20413,20458,20471,20500,20515,20564,20570,20571,20579,20603,20609,20612,20644,20698,20712,20757,20802,20814,20840,20955,20976,20977,20993,21106,21165,21180,21188,21224,21229,21257,21266,21275,21347,21353,21369,21392,21397,21405,21440,21447,21517,21518,21520,21524,21531,21571,21606,21653,21681,21732,21750,21765,21786,21846,21926,21987,22026,22040,22043,22061,22082,22097,22118,22129,22180,22207,22229,22234,22252,22262,22267,22270,22276,22296,22367,22385,22414,22419,22423,22442,22489,22529,22596,22611,22645,22648,22649,22692,22720,22754,22784,22785,22788,22830,22834,22848,22849,22960,22977,23016,23040,23043,23052,23073,23092,23104,23123,23147,23156,23198,23245,23247,23307,23318,23325,23328,23365,23388,23399,23431,23457,23461,23485,23492,23495,23566,23622,23647,23654,23688,23695,23725,23739,23880,23970,24030,24095,24115,24119,24152,24192,24202,24204,24242,24263,24275,24277,24288,24293,24312,24342,24361,24366,24383,24392,24398,24399,24440,24450,24451,24460,24465,24479,24497,24498,24555,24601,24603,24635,24643,24683,24705,24714,24717,24747,24775,24780,24826,24891,24936,24957,25069,25093,25099,25106,25133,25222,25411,25413,25631,25636,25648,25672,25673,25709,25740,25746,25770,25787,25816,25823,25898,25940,25959,25968,26017,26030,26034,26053,26056,26061,26092,26104,26202,26221,26261,26288,26340,26374,26378,26395,26408,26409,26410,26439,26471,26516,26570,26575,26577,26601,26629,26630,26640,26655,26664,26679,26684,26686,26715,26716,26760,26763,26766,26770,26801,26848,26866,26924,26955,26983,26992,26996,27018,27071,27105,27136,27138,27161,27167,27220,27322,27325,27466,27475,27513,27688,27974,28198,28367,28545,28779,29107,29187,29200,29213,29379,29436,29569,30609,30700,30854,31773,32241,32352,32995,33614,33621,33725,33950,34510,34524,34584,34667,34668,34669,34758,34927,34963,35259,35305,35369,35530,35548,35562,35710,35718,35823,35878,35950,36039,36060,36153,36197,36241,36279,36319,36340,36343,36383,36396,36423,36428,36534,36639,36937,37005,37025,37088,37155,37441,37455,37506,38235,38293,38382,38426,38436,38542,38563,38628,38662,38689,38772,38784,38786,38818,38836,38865,38890,38905,38962,38976,38986,38987,39035,39078,39129,39142,39192,39226,39287,39296,39406,39475,39645,39673,39808,39823,39878,39936,39938,39995,40079,40202,40221,40270,40317,40319,40548,40812,40867,40954,41115,41254,41339,41515,41594,41667,42074,42262,42456,42540,42718,42971,43155,43358,43627,43898,43907,43980,44317,44327,44369,44370,44433,44971,45018,45038,45039,45040,45041,45042,45043,45191,45231)
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 | 1151 | 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.85 ms |
checking permissions | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.26 ms |
System lock | 0.05 ms |
optimizing | 0.10 ms |
statistics | 2.39 ms |
preparing | 1.18 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.61 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.10 ms |
freeing items | 0.12 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 |