Tiempo de la consulta: 5.61 ms Después de la última consulta: 1.33 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 4.408 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-10 00:37:50')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-10 00:37:50')
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(11,23,29,39,49,58,111,154,204,234,293,332,355,420,437,446,447,458,466,478,495,510,521,546,558,593,605,607,618,639,644,645,653,671,695,701,719,721,723,729,757,777,816,836,845,862,868,879,911,912,915,944,955,959,977,986,1010,1011,1027,1033,1057,1094,1123,1158,1173,1186,1207,1210,1214,1226,1234,1236,1240,1308,1335,1339,1363,1463,1643,1720,1725,1893,2013,2094,2103,2109,2131,2144,2163,2164,2169,2195,2199,2202,2204,2210,2213,2217,2223,2227,2234,2237,2242,2245,2256,2273,2286,2299,2325,2346,2348,2386,2398,2413,2426,2456,2563,2625,2647,2767,2799,2827,2856,2857,2916,2924,2964,3022,3038,3049,3113,3152,3248,3276,3285,3286,3291,3295,3353,3462,3498,3546,3570,3617,3682,3696,3700,3706,3715,3852,3864,3886,3974,3980,4038,4096,4114,4163,4188,4209,4276,4281,4285,4306,4310,4315,4333,4531,4568,4573,4765,4790,4963,5001,5026,5034,5085,5187,5211,5300,5306,5484,5512,5530,5537,5648,5659,5849,5874,5894,5918,5934,5977,6056,6092,6103,6180,6277,6340,6351,6448,6520,6608,6629,6703,6736,6833,6884,6906,6925,6933,6948,6969,6994,7045,7162,7163,7164,7218,7251,7264,7277,7282,7285,7327,7338,7343,7346,7436,7447,7449,7490,7510,7513,7516,7551,7577,7583,7666,7676,7679,7730,7757,7762,7764,7805,7829,7840,7854,7871,7901,7954,7960,8027,8045,8092,8138,8159,8177,8242,8258,8281,8351,8397,8430,8439,8441,8555,8567,8661,8903,8973,9194,9240,9249,9254,9304,9318,9326,9400,9414,9428,9438,9451,9472,9734,9832,9854,9861,9886,9891,9956,10033,10149,10160,10163,10169,10199,10207,10272,10286,10304,10366,10401,10443,10453,10464,10484,10499,10512,10532,10537,10554,10607,10661,10668,10713,10771,10833,10932,10986,11009,11027,11035,11043,11142,11150,11238,11242,11262,11263,11377,11399,11417,11427,11473,11538,11553,11666,11680,11713,11716,11775,11821,11828,11870,11872,11879,11903,11926,12011,12019,12036,12042,12069,12085,12131,12136,12152,12317,12319,12362,12370,12448,12514,12588,12604,12636,12670,12676,12692,12738,12758,12808,12849,12910,12933,12960,13019,13107,13132,13220,13222,13250,13262,13312,13323,13334,13345,13359,13379,13384,13396,13404,13440,13446,13481,13551,13594,13604,13659,13664,13697,13708,13733,13753,13892,13921,13926,14040,14077,14078,14092,14105,14133,14141,14175,14180,14198,14199,14232,14234,14246,14266,14268,14270,14305,14355,14375,14378,14421,14451,14454,14480,14491,14493,14502,14505,14525,14531,14613,14624,14632,14637,14654,14691,14699,14701,14751,14760,14798,14955,14982,15002,15048,15060,15069,15092,15094,15105,15107,15111,15115,15123,15148,15149,15180,15206,15214,15217,15226,15257,15273,15281,15284,15299,15325,15330,15334,15344,15351,15358,15371,15403,15410,15417,15425,15426,15443,15475,15483,15492,15500,15565,15574,15577,15580,15582,15609,15632,15635,15637,15639,15642,15656,15677,15725,15726,15733,15745,15748,15750,15762,15788,15811,15832,15835,15840,15878,15879,15900,15949,15953,15954,16024,16038,16052,16128,16156,16167,16217,16236,16261,16270,16279,16295,16301,16305,16322,16324,16328,16336,16353,16359,16366,16368,16389,16404,16430,16436,16447,16458,16476,16486,16497,16498,16518,16564,16571,16613,16623,16627,16659,16662,16673,16675,16682,16728,16742,16772,16778,16792,16820,16827,16841,16866,16893,16903,16909,16949,16963,16985,17062,17066,17072,17088,17130,17138,17149,17158,17184,17185,17214,17218,17222,17247,17266,17269,17277,17318,17346,17390,17406,17411,17424,17425,17431,17441,17452,17460,17485,17486,17491,17498,17512,17536,17556,17574,17596,17620,17625,17633,17650,17688,17701,17704,17705,17706,17712,17715,17732,17733,17753,17759,17761,17772,17774,17778,17783,17813,17816,17824,17844,17846,17868,17880,17885,17918,17951,17973,18008,18055,18102,18109,18128,18160,18179,18183,18220,18221,18231,18238,18247,18274,18277,18300,18315,18326,18345,18352,18353,18366,18401,18434,18435,18453,18495,18520,18537,18554,18625,18643,18646,18666,18692,18698,18699,18718,18732,18744,18750,18768,18792,18821,18846,18864,18909,18920,18936,18960,18961,18972,18973,18985,18993,18997,19000,19001,19020,19027,19063,19064,19077,19106,19136,19139,19151,19172,19177,19179,19191,19194,19205,19224,19228,19247,19285,19309,19313,19323,19351,19352,19355,19368,19405,19407,19419,19422,19437,19457,19486,19492,19504,19562,19571,19578,19580,19604,19619,19626,19666,19697,19705,19733,19748,19752,19778,19790,19806,19807,19818,19874,19903,19918,19919,19925,19930,19944,19946,19948,19949,19951,19956,19957,19978,20000,20008,20018,20020,20035,20059,20083,20089,20098,20105,20117,20158,20166,20174,20186,20204,20205,20226,20233,20260,20282,20294,20299,20304,20305,20312,20327,20328,20332,20333,20344,20352,20359,20371,20388,20399,20419,20420,20431,20457,20487,20489,20495,20498,20513,20523,20524,20537,20542,20554,20556,20563,20596,20608,20635,20672,20712,20718,20721,20777,20780,20782,20784,20841,20870,20877,20886,20906,20912,20950,20956,20974,21013,21017,21055,21067,21074,21085,21086,21108,21110,21121,21127,21128,21133,21135,21149,21160,21163,21166,21170,21181,21231,21253,21258,21294,21297,21324,21339,21350,21387,21396,21398,21420,21468,21482,21505,21510,21512,21536,21542,21547,21566,21628,21665,21672,21683,21689,21713,21716,21733,21739,21742,21750,21765,21816,21831,21859,21904,21906,21947,21967,21994,22027,22030,22031,22053,22088,22114,22122,22126,22127,22137,22141,22144,22185,22205,22216,22219,22238,22254,22266,22273,22277,22283,22292,22305,22312,22316,22320,22328,22336,22347,22348,22380,22383,22395,22430,22468,22485,22493,22498,22508,22546,22553,22563,22571,22605,22622,22668,22671,22681,22688,22691,22706,22711,22715,22744,22752,22770,22775,22779,22786,22822,22834,22857,22873,22877,22883,22898,22913,22918,22935,22936,22998,23012,23013,23026,23047,23060,23076,23112,23130,23181,23188,23189,23202,23209,23224,23242,23260,23263,23278,23279,23280,23288,23306,23307,23310,23319,23338,23367,23393,23400,23418,23438,23444,23458,23468,23514,23516,23527,23543,23568,23575,23584,23596,23611,23612,23624,23666,23667,23686,23689,23698,23705,23709,23726,23731,23756,23770,23778,23780,23783,23786,23819,23837,23855,23856,23873,23876,23883,23895,23911,23917,23941,23957,23989,23994,24002,24020,24064,24082,24086,24114,24116,24178,24190,24201,24205,24210,24211,24274,24282,24297,24298,24328,24340,24423,24432,24471,24485,24523,24536,24559,24567,24571,24573,24574,24630,24635,24641,24657,24667,24671,24672,24673,24681,24684,24723,24734,24756,24760,24790,24807,24812,24822,24836,24845,24860,24863,24887,24922,24945,24958,24967,25022,25038,25041,25069,25103,25111,25125,25137,25146,25163,25174,25176,25200,25215,25218,25258,25273,25274,25285,25297,25310,25315,25332,25333,25343,25348,25353,25361,25373,25380,25384,25389,25394,25420,25429,25434,25443,25452,25461,25469,25474,25477,25483,25495,25501,25513,25534,25540,25554,25560,25567,25573,25580,25583,25600,25603,25614,25650,25657,25663,25664,25671,25672,25676,25680,25681,25688,25696,25697,25699,25711,25718,25724,25746,25753,25755,25790,25799,25807,25813,25818,25820,25822,25847,25884,25907,25908,25911,25935,25938,25947,25948,25952,25958,25967,25971,26030,26064,26073,26116,26133,26157,26173,26174,26177,26178,26191,26193,26205,26207,26209,26225,26230,26236,26239,26247,26250,26271,26275,26292,26322,26331,26344,26355,26378,26387,26392,26409,26420,26431,26432,26434,26452,26456,26481,26507,26508,26522,26529,26541,26543,26559,26560,26562,26571,26582,26594,26596,26598,26605,26618,26651,26664,26678,26685,26697,26701,26715,26723,26725,26740,26742,26743,26749,26750,26756,26765,26767,26768,26780,26801,26809,26818,26829,26859,26860,26896,26897,26924,26934,26936,26937,26960,26976,26991,27002,27024,27025,27028,27040,27045,27056,27058,27060,27075,27082,27085,27096,27097,27127,27155,27156,27177,27197,27248,27261,27277,27279,27318,27355,27368,27390,27403,27417,27418,27420,27442,27478,27482,27491,27512,27513,27544,27563,27567,27589,27591,27634,27724,27737,27738,27739,27763,27789,27811,27822,27893,27898,27930,27948,27957,27998,28006,28036,28071,28116,28135,28184,28185,28242,28294,28309,28320,28342,28360,28361,28460,28472,28484,28499,28539,28609,28611,28617,28620,28651,28675,28690,28702,28712,28714,28715,28755,28774,28787,28852,28887,28916,28939,29023,29034,29089,29123,29129,29241,29249,29250,29348,29381,29413,29438,29445,29467,29499,29533,29550,29551,29608,29618,29658,29683,29697,29722,29788,29799,29801,29837,29839,29872,29890,29896,29897,29904,29915,29918,30414,30941,31090,31510,31837,32374,32392,33385,34150,34432,34451,34653,34750,34793,35196,35566,35645,35871,35942,35962,36033,36135,36141,36398,36461,37426,37907,38380,38448,38451,38495,38549,38574,38597,38602,38612,38666,38712,38736,38793,38846,38847,38857,38868,38887,39025,39049,39135,39144,39286,39342,39385,39511,39598,39657,39761,39816,39846,39877,40064,40251,40279,40326,40521,40603,40661,40672,40681,40727,40778,40803,40808,40822,40829,40835,40850,40860,40861,40887,40909,40941,40990,41005,41104,41158,41200,41217,41299,41421,41522,41566,41622,41747,41816,41840,42021,42159,42210,42259,42331,42458,42486,42500,42532,42562,42701,42758,42852,42948,43488,43592,43609,43653,43815,43816,43842,44185,44224,44270,44303,44809,44868,45180,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.75 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.15 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.29 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 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 |