Tiempo de la consulta: 16.94 ms Después de la última consulta: 0.99 ms Consulta a la memoria: 1.487 MB memoria antes de la consulta: 4.376 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-05 00:51:04')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 00:51:04')
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,49,58,62,154,163,174,332,357,441,446,458,478,510,521,558,593,618,671,695,723,728,729,757,816,845,868,870,879,911,915,955,986,1010,1027,1033,1057,1094,1133,1158,1182,1186,1207,1210,1214,1226,1234,1240,1289,1292,1335,1339,1346,1538,1919,2094,2188,2392,2964,3022,3030,3036,3054,3055,3109,3180,3295,3353,3364,3451,3461,3474,3477,3546,3571,3696,3706,3864,3946,3994,4096,4163,4166,4276,4281,4409,4437,4699,4713,4765,4767,4790,4863,5001,5085,5161,5231,5247,5300,5306,5351,5456,5605,5648,5659,5686,5881,5886,5894,5918,6036,6304,6323,6448,6472,6520,6703,6806,6994,7013,7014,7246,7272,7277,7285,7327,7338,7346,7432,7439,7449,7513,7551,7577,7583,7666,7730,7757,7764,7829,7840,7860,7871,7901,7923,7981,8017,8027,8061,8116,8138,8177,8258,8351,8635,8973,9254,9429,9434,9472,9554,9734,9773,9832,9886,9891,9924,9956,10149,10199,10207,10307,10401,10464,10499,10537,10630,10694,10734,10783,10833,10917,10932,10958,10986,11009,11027,11043,11059,11150,11238,11258,11263,11377,11402,11414,11446,11452,11473,11538,11593,11666,11680,11713,11716,11775,11870,11879,11926,12011,12036,12042,12069,12085,12131,12136,12152,12218,12317,12319,12331,12362,12370,12401,12448,12463,12474,12514,12588,12604,12617,12622,12624,12625,12636,12655,12670,12676,12686,12738,12758,12849,12871,12875,12901,12910,12944,12960,13107,13120,13132,13222,13250,13345,13359,13379,13389,13396,13440,13446,13481,13594,13616,13664,13697,13708,13742,13753,13892,13963,13990,14018,14040,14074,14078,14082,14092,14117,14133,14175,14198,14199,14232,14234,14244,14262,14268,14271,14273,14305,14355,14378,14421,14440,14450,14451,14456,14480,14493,14502,14505,14507,14531,14564,14637,14654,14675,14683,14691,14699,14794,14798,14893,14955,14964,14982,14983,15002,15032,15048,15060,15092,15094,15105,15107,15108,15111,15115,15123,15129,15139,15148,15180,15206,15213,15217,15226,15257,15271,15284,15299,15302,15325,15344,15358,15370,15371,15403,15410,15417,15443,15471,15483,15492,15500,15542,15545,15548,15575,15577,15580,15609,15632,15637,15639,15642,15656,15725,15733,15745,15757,15759,15762,15782,15788,15811,15829,15832,15835,15840,15878,15879,15935,15952,15954,15957,16000,16024,16052,16092,16093,16153,16156,16167,16217,16261,16279,16295,16326,16328,16336,16353,16359,16368,16374,16389,16404,16432,16436,16447,16458,16518,16534,16613,16627,16659,16662,16682,16778,16779,16792,16820,16832,16858,16866,16889,16893,16909,16936,16981,17072,17128,17149,17158,17179,17185,17214,17215,17247,17257,17269,17289,17307,17346,17381,17382,17390,17424,17432,17441,17452,17460,17485,17498,17512,17536,17541,17574,17575,17596,17620,17633,17634,17650,17701,17705,17733,17753,17759,17761,17772,17774,17783,17816,17818,17824,17840,17844,17869,17885,17895,17918,17951,17973,17980,18031,18055,18102,18160,18179,18198,18220,18221,18231,18238,18267,18277,18300,18315,18316,18339,18345,18352,18353,18366,18369,18401,18434,18435,18442,18479,18520,18537,18561,18577,18612,18643,18682,18732,18744,18750,18792,18821,18846,18872,18909,18910,18920,18927,18936,18942,18960,18972,18973,18977,18982,18991,18993,18995,19000,19022,19027,19063,19083,19091,19106,19110,19132,19136,19149,19151,19172,19179,19191,19205,19224,19247,19270,19285,19294,19309,19313,19352,19405,19422,19437,19453,19457,19492,19524,19562,19581,19595,19604,19608,19619,19626,19650,19661,19666,19684,19697,19700,19718,19748,19752,19778,19790,19806,19815,19874,19894,19925,19930,19932,19941,19944,19957,19983,19991,20008,20034,20035,20069,20098,20117,20126,20145,20158,20166,20183,20199,20204,20205,20233,20282,20299,20305,20328,20332,20333,20344,20352,20354,20359,20363,20374,20399,20403,20419,20420,20440,20457,20487,20489,20537,20554,20578,20608,20631,20636,20638,20683,20712,20780,20782,20786,20796,20802,20826,20841,20856,20877,20886,20912,20956,20974,21000,21013,21017,21055,21067,21085,21086,21108,21110,21118,21121,21128,21133,21149,21161,21163,21178,21181,21229,21231,21242,21252,21258,21305,21323,21324,21328,21334,21387,21396,21433,21452,21458,21464,21482,21500,21516,21522,21542,21546,21547,21566,21586,21587,21628,21665,21672,21683,21689,21713,21714,21716,21737,21742,21749,21750,21859,21878,21906,21952,21967,21968,21994,22031,22053,22059,22088,22100,22122,22137,22139,22142,22219,22266,22292,22316,22380,22419,22421,22435,22455,22468,22485,22492,22493,22498,22500,22502,22509,22517,22527,22546,22553,22572,22668,22671,22673,22681,22691,22692,22708,22715,22742,22744,22779,22786,22803,22822,22834,22857,22873,22874,22898,22918,22936,22998,23000,23013,23022,23026,23034,23047,23122,23148,23181,23202,23219,23224,23247,23260,23278,23286,23288,23310,23319,23338,23344,23345,23375,23400,23451,23467,23468,23516,23543,23546,23559,23564,23584,23624,23664,23666,23667,23686,23691,23703,23705,23726,23731,23756,23772,23780,23848,23855,23857,23873,23874,23876,23911,23959,23962,23967,23984,23989,24002,24010,24024,24072,24075,24076,24082,24111,24114,24174,24190,24201,24210,24230,24288,24340,24346,24432,24455,24485,24523,24567,24607,24616,24630,24657,24671,24672,24681,24734,24788,24790,24807,24836,24845,24857,24887,24922,24924,24945,24967,25003,25038,25041,25103,25126,25137,25139,25146,25163,25200,25218,25226,25258,25273,25315,25349,25353,25360,25373,25374,25380,25421,25461,25469,25474,25483,25513,25540,25554,25583,25600,25637,25642,25663,25746,25753,25764,25775,25790,25798,25813,25822,25823,25911,25952,25987,26073,26107,26116,26122,26135,26157,26174,26176,26191,26207,26209,26219,26225,26236,26247,26271,26322,26344,26355,26370,26387,26392,26420,26432,26434,26452,26481,26521,26522,26560,26562,26564,26594,26598,26701,26752,26780,26800,26816,26897,26924,26926,26934,26936,26982,27024,27026,27028,27040,27075,27085,27096,27120,27127,27131,27151,27186,27267,27271,27279,27292,27355,27356,27368,27371,27390,27403,27420,27442,27452,27506,27558,27563,27572,27724,27739,27893,27898,27939,28005,28116,28135,28185,28242,28294,28321,28397,28424,28539,28609,28617,28651,28712,28714,28715,28780,28824,28933,28944,29021,29034,29089,29124,29256,29341,29348,29358,29381,29413,29445,29467,29499,29550,29551,29617,29658,29683,29788,29801,29810,29837,29839,29872,29896,29897,29915,29918,29919,29930,30414,30941,31090,31227,31499,31510,31516,31837,33385,33815,34150,34252,36141,36893,36916,36918,37315,37380,37382,37874,37996,38056,38066,38361,38455,38734,38775,38812,38887,39307,39342,39358,39452,39504,39516,39846,39877,39966,40064,40169,40312,40313,40314,40360,40521,40542,40672,40796,40801,40861,40909,41036,41063,41104,41199,41402,41423,41811,41885,42460,42489,43680,43705,43706,43707,43914,43915,43917,44031,44041,44497,44681,45115,45160,45206,45252)
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 | 1123 | 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.54 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.23 ms |
System lock | 0.02 ms |
optimizing | 0.08 ms |
statistics | 1.84 ms |
preparing | 0.95 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 12.62 ms |
end | 0.02 ms |
query end | 0.04 ms |
closing tables | 0.02 ms |
freeing items | 0.08 ms |
cleaning up | 0.04 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 |