Tiempo de la consulta: 6.01 ms Después de la última consulta: 1.49 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.383 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-06 10:36:24')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 10:36:24')
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,25,49,58,61,117,136,154,202,271,272,280,332,344,350,353,354,361,374,376,377,378,379,380,385,414,446,452,456,458,459,474,478,489,497,510,521,545,558,581,583,593,608,611,618,622,633,671,672,681,686,695,707,723,729,757,771,776,796,797,802,805,816,831,845,858,861,864,868,879,889,891,905,911,915,924,928,941,955,964,976,983,986,1010,1021,1027,1040,1043,1057,1062,1080,1087,1094,1148,1158,1185,1186,1205,1207,1210,1214,1215,1226,1234,1240,1248,1252,1253,1287,1298,1329,1335,1339,1402,1491,1563,1594,1601,1612,1683,1698,1709,1712,1717,1744,1770,1784,1849,1917,1946,1949,1964,1999,2094,2102,2187,2410,2433,2633,2656,2714,2739,2742,2788,2875,2964,3022,3082,3085,3091,3215,3251,3259,3271,3295,3299,3329,3340,3353,3425,3546,3696,3706,3783,3816,3832,3864,3869,3870,3873,3895,3932,3957,3963,3988,4082,4087,4096,4163,4206,4276,4281,4319,4355,4378,4434,4502,4560,4638,4765,4780,4790,4801,4854,4901,5001,5063,5085,5136,5183,5190,5227,5300,5306,5328,5363,5529,5575,5632,5646,5648,5659,5694,5730,5811,5894,5895,5904,5918,5994,6021,6068,6147,6292,6333,6384,6448,6452,6464,6498,6501,6520,6631,6687,6688,6703,6824,6834,6857,6884,6908,6940,6942,6957,6960,6961,6989,6994,7012,7053,7054,7154,7172,7175,7273,7277,7285,7303,7304,7327,7338,7346,7348,7374,7434,7443,7449,7450,7454,7488,7513,7522,7551,7556,7567,7577,7583,7591,7595,7638,7644,7666,7713,7722,7730,7751,7757,7764,7774,7797,7829,7840,7862,7867,7871,7901,7916,7923,7965,7967,7980,7985,7996,8027,8108,8138,8148,8161,8177,8188,8258,8296,8325,8351,8387,8390,8417,8492,8502,8505,8506,8694,8716,8764,8852,8973,9004,9011,9057,9155,9193,9206,9249,9252,9254,9318,9429,9452,9472,9501,9525,9573,9648,9708,9723,9725,9734,9766,9831,9832,9840,9861,9886,9889,9891,9956,9966,9985,10011,10129,10149,10199,10207,10227,10259,10265,10278,10298,10313,10357,10364,10401,10449,10464,10494,10499,10534,10537,10611,10777,10818,10820,10821,10833,10900,10932,10942,10967,10971,10986,11005,11009,11027,11043,11150,11178,11198,11238,11263,11333,11362,11365,11377,11404,11473,11538,11539,11542,11663,11666,11672,11680,11685,11709,11713,11716,11775,11799,11816,11870,11879,11893,11926,11950,11976,12009,12011,12036,12042,12069,12085,12131,12136,12152,12168,12178,12179,12224,12317,12319,12362,12370,12387,12388,12410,12439,12446,12448,12482,12509,12514,12567,12588,12604,12636,12663,12670,12676,12685,12688,12714,12738,12758,12838,12849,12892,12898,12910,12913,12926,12960,12985,13014,13036,13079,13107,13132,13189,13209,13222,13229,13250,13269,13285,13297,13317,13334,13345,13359,13379,13396,13436,13440,13446,13481,13534,13553,13579,13594,13647,13649,13664,13697,13708,13722,13729,13753,13892,13901,13959,14014,14040,14078,14092,14098,14133,14134,14152,14175,14197,14198,14199,14205,14232,14234,14248,14250,14268,14290,14302,14305,14336,14352,14354,14355,14368,14378,14396,14417,14421,14424,14426,14451,14480,14493,14502,14505,14508,14531,14548,14596,14620,14625,14629,14637,14654,14676,14688,14691,14695,14699,14754,14769,14789,14798,14843,14846,14856,14884,14930,14955,14982,14984,15002,15018,15024,15060,15092,15105,15107,15114,15115,15123,15148,15180,15197,15206,15217,15223,15226,15250,15257,15261,15284,15286,15299,15304,15306,15315,15316,15325,15344,15358,15371,15392,15403,15410,15417,15430,15443,15444,15450,15483,15484,15492,15496,15500,15520,15563,15566,15577,15580,15583,15601,15608,15609,15616,15632,15637,15639,15642,15656,15670,15706,15714,15723,15733,15745,15755,15762,15778,15788,15805,15811,15832,15835,15840,15878,15879,15897,15909,15913,15916,15917,15954,15999,16024,16052,16053,16088,16156,16167,16217,16261,16279,16295,16311,16313,16323,16328,16334,16336,16353,16359,16362,16368,16381,16389,16404,16417,16436,16447,16458,16474,16518,16523,16542,16555,16589,16613,16620,16627,16642,16657,16659,16662,16670,16675,16682,16698,16712,16778,16783,16792,16820,16863,16866,16891,16893,16907,16909,16940,16968,16982,17046,17064,17072,17090,17149,17158,17163,17169,17185,17209,17214,17232,17247,17248,17256,17269,17287,17346,17365,17390,17422,17424,17441,17450,17452,17460,17485,17498,17512,17513,17536,17542,17566,17573,17574,17596,17620,17622,17625,17633,17650,17660,17688,17701,17705,17712,17717,17733,17752,17753,17759,17761,17772,17774,17782,17783,17788,17808,17816,17820,17824,17844,17885,17907,17914,17918,17930,17933,17951,17967,17973,17978,17981,18004,18019,18027,18055,18068,18076,18102,18118,18141,18160,18179,18203,18220,18221,18231,18235,18238,18277,18300,18315,18345,18352,18353,18366,18401,18415,18429,18434,18435,18447,18507,18520,18534,18537,18542,18564,18587,18605,18643,18647,18676,18732,18744,18750,18778,18792,18800,18801,18811,18821,18825,18830,18835,18846,18849,18850,18871,18879,18909,18920,18931,18936,18944,18946,18960,18972,18973,18980,18993,19001,19005,19018,19027,19055,19063,19093,19106,19136,19145,19151,19172,19179,19184,19191,19196,19205,19216,19218,19224,19247,19254,19259,19277,19285,19302,19309,19313,19316,19325,19340,19352,19383,19405,19422,19437,19457,19473,19481,19492,19514,19545,19562,19565,19574,19580,19586,19587,19604,19606,19619,19624,19626,19665,19666,19679,19697,19741,19748,19752,19755,19768,19773,19778,19779,19790,19805,19806,19826,19830,19855,19864,19871,19874,19877,19881,19901,19925,19938,19942,19944,19957,19965,19972,19973,19984,19996,20002,20008,20020,20035,20076,20088,20098,20117,20154,20155,20158,20166,20204,20205,20208,20209,20233,20264,20278,20282,20299,20303,20305,20328,20332,20333,20344,20350,20352,20359,20366,20384,20390,20393,20399,20405,20419,20420,20433,20437,20447,20457,20487,20488,20489,20537,20545,20554,20570,20585,20588,20608,20698,20708,20712,20718,20772,20780,20781,20782,20794,20803,20814,20841,20876,20877,20886,20912,20919,20935,20940,20948,20956,20960,20974,20979,20991,21013,21017,21035,21042,21055,21067,21085,21086,21108,21121,21122,21128,21133,21149,21163,21170,21181,21198,21200,21231,21247,21258,21291,21302,21324,21325,21335,21341,21350,21361,21370,21380,21387,21396,21398,21412,21415,21448,21449,21465,21482,21520,21528,21542,21547,21551,21556,21566,21583,21591,21603,21604,21607,21628,21632,21640,21647,21652,21665,21680,21683,21689,21713,21716,21729,21742,21750,21770,21859,21867,21878,21895,21908,21930,21967,21986,21990,21994,22031,22036,22039,22044,22053,22055,22058,22067,22074,22088,22096,22122,22132,22137,22170,22177,22215,22219,22255,22260,22266,22276,22292,22316,22320,22321,22327,22349,22363,22380,22382,22428,22436,22465,22485,22493,22498,22501,22520,22546,22553,22579,22588,22594,22621,22623,22668,22671,22681,22691,22693,22709,22713,22744,22751,22779,22781,22786,22820,22822,22834,22857,22866,22873,22898,22900,22915,22918,22922,22927,22930,22932,22936,22967,22998,23004,23009,23013,23026,23027,23029,23032,23047,23072,23084,23087,23090,23102,23103,23112,23136,23137,23156,23166,23174,23181,23202,23215,23224,23232,23252,23260,23270,23278,23279,23288,23308,23310,23319,23338,23367,23368,23400,23401,23411,23412,23444,23468,23481,23484,23492,23503,23516,23531,23543,23548,23555,23577,23584,23621,23623,23624,23633,23634,23642,23645,23652,23665,23666,23667,23682,23686,23691,23693,23705,23709,23716,23719,23726,23731,23756,23768,23780,23846,23849,23855,23866,23873,23876,23894,23902,23911,23920,23921,23944,23949,23958,23989,24002,24009,24015,24024,24060,24082,24110,24114,24115,24134,24137,24154,24159,24164,24176,24190,24196,24201,24210,24239,24241,24270,24296,24306,24335,24340,24362,24391,24422,24430,24432,24442,24453,24485,24506,24556,24567,24575,24617,24630,24635,24656,24657,24671,24672,24673,24677,24681,24707,24719,24724,24726,24734,24790,24794,24807,24816,24832,24836,24845,24855,24882,24887,24922,24931,24943,24945,24967,24986,25033,25036,25038,25041,25043,25061,25103,25136,25137,25146,25163,25200,25218,25258,25271,25282,25287,25291,25315,25327,25332,25353,25367,25373,25379,25380,25384,25386,25408,25416,25440,25461,25469,25474,25483,25484,25513,25515,25526,25540,25548,25554,25555,25560,25583,25600,25640,25663,25687,25692,25697,25735,25742,25746,25749,25753,25765,25768,25782,25790,25806,25813,25822,25854,25887,25889,25911,25952,25959,26023,26055,26073,26099,26116,26140,26157,26174,26191,26197,26207,26209,26225,26236,26247,26271,26274,26322,26323,26324,26340,26344,26355,26387,26390,26392,26398,26413,26420,26432,26434,26450,26452,26481,26494,26522,26548,26560,26562,26577,26594,26595,26598,26612,26637,26660,26701,26780,26781,26853,26897,26909,26919,26924,26934,26936,26941,26954,27001,27024,27028,27040,27075,27085,27087,27096,27104,27127,27184,27220,27279,27355,27368,27374,27379,27390,27403,27420,27442,27488,27563,27584,27724,27739,27795,27892,27893,27898,28116,28120,28135,28157,28169,28185,28242,28294,28511,28537,28539,28609,28617,28623,28639,28651,28712,28714,28715,28844,28847,28852,28925,29034,29089,29325,29348,29381,29413,29445,29467,29499,29550,29551,29658,29683,29788,29801,29837,29839,29872,29896,29897,29915,29918,29962,30274,30414,30941,31090,31510,31663,31837,32058,32820,33385,34150,35000,35711,35740,35774,35858,36141,36178,36216,36492,38816,38817,38833,38845,38887,38897,38947,38958,38975,38987,39020,39064,39159,39342,39614,39645,39820,39846,39877,39972,40064,40184,40521,40672,40861,40909,41104,41325,41363)
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 | 1587 | 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.71 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.29 ms |
System lock | 0.02 ms |
optimizing | 0.11 ms |
statistics | 2.43 ms |
preparing | 1.43 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.35 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 |