Tiempo de la consulta: 5.65 ms Después de la última consulta: 1.40 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 4.413 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 00:30:55')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-08 00:30:55')
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(4,11,25,29,35,39,71,78,119,132,167,185,204,255,271,272,283,308,323,354,355,390,400,403,429,435,443,477,495,506,546,547,565,657,668,675,679,689,693,719,722,760,769,777,780,808,825,832,844,863,868,870,883,885,900,935,937,940,959,977,1011,1029,1039,1050,1061,1089,1095,1101,1102,1123,1158,1183,1195,1196,1216,1233,1249,1250,1251,1308,1330,1337,1363,1372,1458,1459,1463,1469,1477,1479,1480,1497,1503,1514,1528,1548,1557,1567,1623,1628,1641,1684,1713,1735,1745,1796,1806,1887,1898,1935,1944,1975,1982,1990,2010,2016,2064,2069,2078,2101,2103,2109,2131,2144,2146,2150,2182,2204,2209,2219,2223,2224,2235,2241,2242,2254,2261,2272,2278,2319,2325,2353,2367,2372,2379,2396,2404,2415,2426,2452,2456,2517,2560,2563,2605,2625,2627,2631,2636,2647,2666,2668,2674,2705,2716,2756,2770,2786,2797,2804,2812,2842,2849,2856,2857,2859,2888,2916,2924,2929,2933,2967,2993,3000,3001,3016,3038,3065,3108,3125,3152,3154,3166,3183,3207,3208,3236,3248,3264,3276,3285,3288,3291,3303,3312,3343,3346,3347,3414,3462,3493,3498,3511,3522,3569,3597,3700,3718,3719,3750,3754,3812,3824,3825,3832,3871,3975,3980,3983,4002,4038,4114,4132,4133,4231,4240,4253,4315,4325,4333,4339,4446,4492,4503,4513,4531,4631,4670,4772,4817,4868,4872,4894,4910,4935,4984,5079,5086,5093,5095,5123,5187,5211,5275,5381,5386,5437,5451,5457,5458,5471,5513,5570,5615,5798,5854,5895,5973,5977,5998,6020,6037,6089,6101,6102,6155,6227,6256,6301,6315,6331,6338,6342,6351,6354,6363,6372,6394,6400,6470,6473,6475,6476,6477,6485,6515,6516,6517,6534,6542,6543,6561,6565,6577,6588,6593,6602,6629,6670,6685,6694,6736,6791,6804,6807,6808,6830,6833,6840,6845,6906,6933,6964,6969,6975,6989,6995,6997,7018,7026,7045,7070,7081,7124,7136,7138,7181,7205,7245,7248,7265,7269,7275,7282,7283,7288,7293,7300,7335,7343,7412,7414,7436,7447,7455,7485,7490,7510,7516,7528,7569,7583,7630,7674,7676,7689,7718,7749,7752,7805,7848,7872,7917,7935,7954,7960,7965,7985,7994,8030,8061,8088,8109,8159,8206,8222,8239,8297,8345,8416,8480,8532,8549,8567,8603,8613,8625,8691,8706,8740,8762,8777,8819,8828,8897,8907,8937,8970,8978,8983,9036,9048,9051,9056,9057,9082,9146,9152,9200,9239,9284,9286,9314,9339,9340,9355,9415,9423,9428,9440,9461,9489,9552,9626,9629,9658,9745,9764,9766,9769,9817,9818,9825,9834,9836,9854,9861,9894,10019,10059,10132,10195,10255,10273,10295,10304,10430,10453,10462,10502,10532,10554,10661,10668,10713,10765,10769,10973,11022,11031,11035,11142,11170,11195,11262,11277,11318,11410,11417,11418,11625,11821,11854,11872,11948,11955,12019,12139,12166,12388,12437,12566,12599,12617,12686,12692,12816,13002,13006,13018,13029,13061,13097,13129,13154,13166,13170,13190,13262,13269,13276,13356,13404,13456,13488,13524,13530,13548,13550,13553,13573,13589,13641,13645,13646,13659,13672,13712,13733,13759,13763,13782,13821,13855,13921,13926,13950,14005,14057,14062,14063,14077,14081,14100,14105,14137,14139,14141,14148,14152,14159,14180,14181,14186,14188,14197,14266,14268,14324,14356,14362,14366,14389,14391,14428,14445,14447,14454,14525,14529,14534,14538,14550,14554,14601,14613,14624,14632,14665,14675,14683,14684,14692,14696,14701,14707,14711,14713,14753,14754,14761,14769,14856,14890,14896,14897,14905,14949,15018,15049,15059,15069,15079,15111,15149,15214,15221,15245,15248,15273,15330,15334,15346,15351,15425,15426,15464,15496,15497,15530,15565,15574,15582,15599,15606,15635,15668,15719,15725,15726,15750,15809,15818,15861,15897,15900,15935,15944,15949,16038,16060,16062,16108,16128,16161,16168,16178,16206,16218,16270,16301,16305,16317,16321,16324,16325,16343,16408,16422,16432,16451,16465,16498,16521,16522,16523,16562,16571,16582,16591,16603,16632,16671,16698,16713,16733,16734,16788,16808,16827,16837,16841,16848,16880,16957,16963,17019,17042,17061,17062,17086,17100,17116,17117,17130,17134,17155,17157,17167,17184,17197,17218,17222,17263,17277,17280,17303,17307,17309,17389,17425,17486,17542,17562,17615,17625,17630,17649,17688,17704,17706,17707,17712,17715,17727,17729,17732,17775,17812,17813,17835,17846,17875,17883,17907,17908,17938,18008,18043,18060,18091,18109,18112,18113,18128,18129,18142,18150,18183,18247,18273,18274,18295,18326,18358,18360,18369,18380,18388,18409,18431,18495,18521,18554,18566,18625,18687,18692,18694,18699,18717,18718,18763,18768,18772,18793,18826,18837,18859,18867,18880,18912,18927,18934,18937,18944,18961,18969,18997,19000,19001,19003,19020,19064,19077,19086,19126,19133,19193,19194,19217,19223,19233,19291,19303,19323,19348,19351,19355,19364,19366,19368,19371,19383,19419,19448,19464,19475,19486,19507,19541,19572,19578,19634,19639,19653,19660,19693,19790,19807,19818,19828,19855,19871,19873,19913,19918,19919,19920,19921,19930,19946,19949,19956,19971,19975,20000,20024,20036,20058,20065,20073,20088,20163,20174,20198,20258,20304,20327,20329,20347,20361,20378,20413,20458,20471,20498,20500,20515,20524,20556,20564,20571,20579,20603,20609,20621,20635,20655,20665,20671,20698,20712,20718,20757,20758,20777,20784,20790,20802,20809,20814,20840,20870,20955,20976,20977,20993,20996,21074,21106,21160,21165,21170,21180,21224,21229,21253,21257,21266,21275,21294,21297,21347,21353,21369,21392,21397,21398,21405,21420,21440,21447,21468,21472,21505,21510,21517,21518,21520,21524,21536,21549,21571,21606,21672,21681,21732,21733,21739,21750,21765,21781,21786,21846,21878,21906,21926,21987,22008,22026,22040,22043,22097,22118,22127,22129,22141,22180,22189,22207,22216,22229,22234,22252,22262,22267,22270,22273,22276,22277,22283,22296,22312,22317,22320,22328,22334,22347,22367,22385,22414,22419,22423,22442,22468,22489,22491,22508,22529,22553,22562,22563,22571,22596,22609,22611,22645,22648,22649,22688,22692,22706,22711,22720,22726,22754,22770,22784,22785,22788,22802,22830,22834,22848,22849,22877,22883,22901,22960,22966,22977,23012,23016,23040,23041,23043,23052,23073,23076,23092,23097,23104,23123,23130,23147,23148,23156,23188,23189,23198,23209,23245,23247,23259,23286,23304,23307,23318,23325,23328,23365,23388,23393,23399,23457,23461,23485,23492,23495,23566,23568,23575,23611,23612,23622,23647,23654,23695,23698,23718,23725,23739,23778,23786,23837,23880,23883,23895,23945,23970,23994,24030,24064,24086,24115,24116,24119,24152,24165,24192,24202,24219,24225,24242,24263,24274,24275,24277,24282,24288,24293,24312,24328,24342,24361,24366,24383,24392,24398,24399,24440,24450,24451,24460,24465,24479,24497,24498,24513,24526,24555,24559,24574,24576,24601,24603,24624,24635,24641,24643,24667,24683,24705,24714,24717,24739,24747,24760,24775,24780,24826,24860,24863,24891,24936,24957,24958,24964,25069,25093,25099,25106,25133,25174,25222,25274,25285,25374,25411,25413,25441,25443,25567,25621,25631,25636,25648,25671,25672,25673,25696,25703,25709,25717,25724,25740,25746,25770,25787,25799,25816,25823,25847,25898,25940,25947,25968,26017,26030,26034,26041,26053,26056,26061,26064,26092,26104,26166,26167,26177,26202,26221,26261,26288,26374,26378,26395,26408,26409,26410,26428,26439,26471,26499,26507,26516,26570,26575,26582,26601,26629,26630,26640,26655,26664,26679,26684,26686,26715,26716,26760,26763,26766,26770,26801,26818,26829,26848,26860,26866,26924,26937,26955,26983,26989,26992,26996,27018,27071,27105,27136,27138,27156,27161,27167,27220,27242,27248,27256,27283,27318,27322,27466,27475,27478,27491,27512,27513,27621,27688,27940,27946,27974,28106,28119,28184,28247,28260,28339,28367,28434,28682,28702,28779,28822,28876,28889,28941,29107,29187,29200,29213,29321,29322,29345,29379,29436,29438,29529,29569,29626,29706,29924,30271,30609,30622,30854,31773,32129,32241,32374,33621,33725,33950,34214,34524,34584,34758,34781,34782,34793,34927,34963,35259,35305,35369,35530,35548,35562,35710,35718,35762,35878,35899,35917,35950,35962,35975,36033,36060,36135,36153,36154,36197,36241,36279,36321,36333,36336,36367,36378,36383,36396,36398,36402,36423,36428,36461,36490,36534,36583,36639,36897,36937,36942,37005,37025,37155,37242,37345,37455,37534,37677,37907,38226,38237,38352,38382,38426,38448,38451,38549,38574,38602,38662,38666,38689,38784,38786,38818,38836,38850,38865,38888,38890,38899,38905,38962,38986,38991,39035,39078,39129,39135,39192,39214,39224,39226,39286,39287,39296,39406,39467,39511,39558,39580,39598,39673,39677,39737,39761,39801,39808,39816,39823,39892,39936,39938,39995,40079,40120,40202,40251,40272,40279,40319,40326,40375,40594,40603,40739,40773,40778,40803,40808,40812,40829,40867,40887,40941,40954,40973,41115,41122,41217,41254,41299,41339,41475,41515,41522,41566,41594,41622,41636,41747,41761,41816,41826,41840,41984,41985,42021,42074,42159,42184,42259,42262,42314,42331,42456,42486,42500,42540,42563,42570,42591,42680,42701,42766,42803,42852,42944,42971,43119,43276,43330,43358,43472,43488,43569,43570,43571,43592,43609,43653,43755,43815,43816,43856,43880,43898,43907,43972,43973,43980,44143,44160,44185,44224,44270,44317,44469,44493,44809,44843,44868,44933,44998,45018,45038,45039,45040,45041,45042,45043,45191,45231,45276)
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 | 1550 | 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.69 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.28 ms |
System lock | 0.02 ms |
optimizing | 0.10 ms |
statistics | 2.27 ms |
preparing | 1.19 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.34 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 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 |