Tiempo de la consulta: 5.51 ms Después de la última consulta: 1.27 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.236 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 19:35:02')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-08 19:35:02')
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,49,58,154,263,310,332,446,458,466,478,510,521,530,558,593,618,660,671,695,723,729,757,813,816,830,845,868,879,911,915,955,959,977,986,1010,1027,1033,1057,1094,1104,1158,1186,1207,1210,1214,1226,1234,1240,1249,1294,1308,1322,1335,1339,1376,1720,2014,2094,2109,2121,2456,2465,2757,2767,2795,2799,2933,2964,3022,3038,3059,3081,3086,3169,3207,3295,3353,3379,3546,3570,3571,3617,3632,3682,3696,3706,3715,3864,3974,3980,4007,4096,4114,4144,4163,4166,4177,4263,4276,4281,4285,4286,4306,4310,4370,4748,4765,4790,5001,5026,5085,5218,5229,5300,5306,5369,5479,5484,5525,5530,5537,5570,5648,5659,5849,5854,5865,5874,5894,5918,5931,5934,5977,6081,6119,6173,6351,6448,6520,6527,6608,6633,6703,6827,6833,6925,6933,6994,7010,7064,7162,7163,7164,7251,7264,7277,7285,7321,7327,7338,7343,7346,7389,7436,7447,7449,7456,7513,7516,7551,7577,7583,7601,7666,7679,7730,7757,7764,7822,7829,7840,7854,7871,7901,7951,8001,8027,8045,8111,8138,8177,8258,8351,8397,8430,8441,8555,8567,8659,8778,8808,8809,8903,8970,8973,9050,9066,9204,9254,9304,9310,9311,9326,9350,9367,9472,9554,9734,9743,9785,9827,9828,9832,9886,9891,9893,9956,10004,10033,10043,10149,10160,10163,10169,10199,10207,10272,10286,10322,10329,10401,10443,10453,10464,10484,10499,10512,10537,10554,10577,10582,10594,10607,10661,10771,10833,10932,10986,11009,11010,11027,11043,11119,11150,11207,11209,11238,11263,11295,11377,11417,11427,11473,11538,11553,11594,11636,11666,11680,11713,11716,11728,11775,11828,11870,11879,11891,11898,11906,11926,12011,12019,12036,12042,12069,12085,12131,12136,12152,12317,12319,12362,12370,12448,12508,12514,12578,12588,12600,12604,12636,12670,12676,12692,12738,12748,12758,12759,12840,12849,12910,12933,12960,13019,13107,13132,13222,13250,13312,13323,13334,13345,13359,13379,13396,13440,13446,13457,13481,13551,13559,13560,13562,13594,13604,13664,13697,13708,13753,13760,13892,14040,14077,14078,14092,14133,14141,14142,14151,14175,14180,14189,14198,14199,14226,14232,14234,14246,14266,14268,14305,14316,14355,14367,14375,14378,14384,14414,14421,14440,14451,14480,14488,14491,14493,14502,14505,14514,14528,14531,14613,14624,14627,14632,14637,14654,14655,14671,14691,14699,14701,14751,14760,14798,14955,14982,15000,15002,15048,15055,15060,15062,15068,15092,15094,15105,15107,15115,15123,15127,15148,15161,15180,15206,15214,15217,15226,15257,15259,15273,15281,15284,15299,15302,15325,15330,15344,15351,15358,15371,15377,15391,15403,15410,15417,15426,15443,15471,15475,15483,15492,15500,15549,15564,15576,15577,15580,15582,15606,15609,15632,15637,15639,15642,15652,15656,15677,15691,15705,15726,15733,15745,15746,15750,15762,15788,15811,15832,15835,15840,15878,15879,15905,15949,15953,15954,15963,16024,16038,16052,16156,16167,16208,16217,16236,16261,16279,16281,16295,16301,16304,16305,16322,16328,16336,16353,16359,16366,16368,16389,16404,16430,16436,16447,16458,16462,16467,16471,16486,16497,16503,16513,16518,16547,16564,16571,16613,16620,16623,16627,16636,16653,16659,16662,16665,16673,16682,16719,16742,16778,16792,16820,16866,16876,16893,16903,16906,16907,16909,16942,16963,16967,17000,17066,17072,17088,17130,17149,17158,17182,17185,17192,17214,17218,17247,17266,17269,17277,17282,17318,17346,17390,17406,17411,17424,17427,17431,17441,17445,17452,17460,17485,17486,17498,17512,17536,17574,17596,17600,17620,17633,17650,17701,17705,17715,17732,17733,17753,17757,17759,17761,17772,17774,17783,17816,17824,17835,17844,17846,17871,17875,17880,17885,17893,17901,17918,17951,17973,18008,18010,18054,18055,18102,18108,18109,18111,18120,18128,18160,18179,18220,18221,18231,18238,18274,18277,18289,18300,18315,18345,18352,18353,18366,18401,18434,18435,18453,18520,18537,18576,18583,18625,18643,18650,18666,18670,18698,18699,18718,18732,18744,18750,18792,18821,18846,18863,18864,18869,18909,18920,18936,18960,18961,18972,18973,18985,18993,19000,19027,19037,19052,19056,19063,19071,19106,19136,19151,19172,19179,19191,19205,19224,19247,19285,19309,19313,19352,19368,19405,19422,19437,19457,19486,19492,19504,19509,19538,19539,19562,19571,19580,19604,19619,19666,19697,19705,19748,19752,19778,19790,19806,19807,19818,19874,19903,19919,19925,19934,19936,19944,19946,19948,19951,19957,19959,19977,19978,20004,20007,20008,20018,20020,20035,20089,20098,20105,20117,20127,20136,20158,20166,20186,20204,20205,20226,20233,20282,20294,20299,20305,20312,20327,20328,20332,20333,20344,20352,20359,20363,20371,20388,20389,20399,20419,20420,20431,20457,20487,20489,20498,20513,20523,20537,20543,20554,20560,20596,20608,20672,20678,20686,20702,20710,20712,20721,20777,20780,20782,20784,20831,20840,20841,20842,20870,20877,20886,20906,20912,20956,20957,20974,21013,21017,21055,21067,21074,21085,21086,21108,21109,21110,21121,21128,21133,21135,21149,21160,21163,21165,21181,21231,21258,21315,21324,21339,21387,21396,21432,21449,21452,21482,21505,21510,21512,21542,21547,21557,21566,21575,21579,21590,21628,21665,21667,21683,21689,21713,21716,21733,21742,21750,21765,21816,21853,21858,21859,21878,21880,21901,21926,21947,21967,21979,21988,21994,22003,22027,22031,22053,22088,22114,22116,22118,22122,22137,22144,22152,22167,22171,22183,22185,22205,22215,22216,22219,22254,22266,22273,22277,22292,22305,22312,22316,22363,22380,22383,22392,22397,22430,22485,22493,22498,22523,22527,22533,22539,22546,22553,22563,22582,22605,22668,22671,22681,22691,22703,22706,22744,22750,22779,22786,22795,22822,22834,22835,22844,22857,22873,22877,22898,22902,22918,22936,22998,23013,23026,23033,23047,23050,23076,23112,23127,23149,23181,23189,23202,23209,23224,23260,23263,23278,23288,23306,23307,23310,23319,23338,23367,23374,23380,23393,23400,23444,23450,23458,23468,23516,23543,23551,23584,23595,23624,23659,23662,23666,23667,23685,23686,23689,23696,23698,23705,23709,23726,23731,23756,23757,23770,23780,23786,23814,23855,23873,23874,23876,23880,23883,23895,23911,23917,23941,23957,23989,23994,24002,24010,24020,24064,24082,24086,24103,24114,24117,24122,24150,24190,24201,24210,24261,24268,24274,24297,24306,24340,24346,24375,24384,24423,24432,24471,24485,24487,24536,24559,24567,24571,24574,24630,24635,24641,24649,24657,24667,24671,24672,24673,24676,24681,24684,24689,24713,24734,24756,24759,24790,24799,24807,24812,24822,24832,24836,24845,24887,24922,24935,24937,24945,24967,25022,25038,25041,25070,25071,25103,25111,25137,25146,25163,25176,25200,25215,25218,25258,25267,25273,25274,25285,25297,25315,25332,25348,25353,25361,25373,25380,25382,25394,25443,25452,25461,25469,25474,25477,25483,25513,25540,25554,25560,25580,25583,25600,25603,25650,25653,25657,25663,25671,25672,25676,25680,25681,25696,25697,25699,25711,25724,25746,25753,25755,25790,25799,25807,25813,25820,25822,25847,25884,25907,25908,25911,25925,25935,25947,25948,25952,25958,25967,25971,26026,26030,26064,26073,26105,26116,26133,26157,26162,26174,26177,26191,26193,26207,26209,26225,26229,26230,26236,26237,26239,26247,26250,26254,26259,26271,26292,26322,26344,26355,26387,26389,26392,26409,26420,26426,26431,26432,26434,26437,26452,26456,26471,26481,26507,26508,26522,26524,26529,26541,26543,26559,26560,26562,26571,26582,26594,26596,26598,26605,26651,26664,26665,26678,26685,26701,26712,26715,26723,26725,26740,26743,26749,26750,26756,26767,26768,26780,26801,26809,26818,26859,26860,26896,26897,26924,26926,26934,26936,26937,26976,26991,27024,27025,27028,27038,27040,27045,27056,27060,27075,27082,27085,27096,27097,27127,27153,27155,27156,27248,27261,27279,27304,27318,27355,27368,27390,27403,27417,27420,27442,27478,27512,27544,27545,27563,27567,27589,27591,27634,27724,27737,27738,27739,27763,27776,27789,27811,27822,27893,27898,27930,27948,27957,27998,28006,28021,28036,28116,28135,28184,28185,28242,28294,28309,28319,28320,28342,28360,28361,28460,28472,28539,28575,28594,28609,28617,28620,28651,28675,28690,28702,28712,28714,28715,28755,28808,28852,28916,29023,29034,29087,29089,29123,29129,29142,29144,29241,29249,29250,29348,29372,29381,29413,29438,29445,29467,29499,29533,29550,29551,29608,29618,29658,29683,29788,29799,29801,29837,29839,29872,29890,29896,29897,29904,29915,29918,29928,30414,30941,31090,31397,31510,31837,32374,33385,34150,34432,34451,34653,34750,35196,35645,35871,35885,36104,36141,36306,36406,37125,37426,37735,37906,37907,38506,38574,38666,38887,38910,39286,39342,39598,39634,39761,39846,39877,39966,40064,40167,40326,40369,40471,40521,40585,40661,40672,40727,40798,40803,40860,40861,40887,40909,41104,41158,41200,41217,41257,41421,41747,42021,42486,42758,42789,42799,44114)
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 | 1446 | 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.65 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.26 ms |
System lock | 0.02 ms |
optimizing | 0.10 ms |
statistics | 2.27 ms |
preparing | 1.13 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.40 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 |