Tiempo de la consulta: 3.64 ms Después de la última consulta: 0.65 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.312 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-07 08:12:29')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 08:12:29')
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(205,1716,1752,1783,1829,1925,2261,2482,2498,2733,2776,2985,3163,3164,3176,3198,3213,3223,3255,3317,3341,3384,3388,3393,3486,3497,3503,3522,3529,3543,3577,3581,3672,3690,3706,3713,3741,3912,3997,4030,4054,4078,4084,4090,4114,4120,4146,4168,4202,4236,4239,4257,4315,4325,4346,4347,4369,4375,4417,4436,4475,4499,4511,4512,4518,4570,4595,4638,4643,4731,4733,4734,4760,4778,4780,4789,4798,4842,4894,4914,4915,4916,4938,4940,5095,5115,5152,5187,5210,5211,5229,5274,5276,5284,5292,5295,5304,5310,5311,5313,5329,5350,5358,5382,5386,5407,5433,5442,5456,5475,5489,5536,5652,5816,5842,5851,5854,5862,5916,5941,5979,6030,6031,6041,6047,6062,6075,6115,6164,6202,6242,6247,6274,6337,6348,6349,6361,6417,6419,6486,6567,6619,6647,6715,6776,6815,6900,6927,7031,7033,7142,7143,7148,7165,7166,7187,7217,7218,7223,7261,7311,7318,7352,7359,7364,7382,7383,7391,7451,7472,7509,7510,7531,7537,7539,7561,7603,7660,7736,7737,7787,7814,7818,7819,7825,7827,7848,7854,7883,7884,7886,7910,7912,7973,8010,8014,8036,8041,8065,8094,8123,8160,8163,8171,8176,8177,8179,8196,8207,8219,8229,8244,8259,8263,8264,8305,8311,8318,8365,8379,8382,8400,8412,8422,8452,8455,8467,8469,8470,8476,8509,8519,8520,8523,8563,8570,8576,8598,8623,8625,8677,8698,8718,8727,8730,8736,8742,8753,8756,8769,8785,8789,8842,8857,8862,8867,8876,8919,8934,8948,8949,8956,8971,8975,8980,9005,9007,9019,9020,9047,9050,9068,9080,9103,9127,9128,9138,9159,9165,9183,9187,9212,9214,9232,9244,9249,9275,9309,9310,9311,9347,9354,9365,9383,9384,9389,9418,9420,9435,9445,9448,9457,9466,9467,9471,9501,9503,9534,9549,9555,9568,9569,9573,9584,9585,9594,9616,9617,9675,9676,9684,9690,9702,9715,9725,9760,9774,9783,9794,9802,9827,9829,9888,9892,9893,9896,9907,9911,9918,9959,9971,9977,9978,10052,10060,10084,10108,10116,10117,10122,10149,10154,10163,10170,10187,10196,10208,10210,10212,10218,10268,10270,10277,10278,10294,10342,10392,10401,10435,10450,10498,10512,10516,10522,10542,10567,10569,10674,10677,10754,10774,10812,10846,10903,10933,10953,10983,11065,11073,11077,11091,11106,11120,11148,11149,11152,11167,11183,11240,11335,11344,11373,11396,11422,11503,11556,11558,11607,11636,11668,11749,11753,11757,11806,11829,11875,11906,11907,11959,11974,11978,11983,12046,12063,12082,12174,12193,12274,12285,12355,12384,12452,12496,12513,12527,12565,12569,12601,12631,12651,12661,12662,12695,12741,12743,12744,12812,12823,12824,12844,12856,12884,12953,12962,12997,13083,13089,13090,13110,13113,13175,13185,13207,13295,13313,13376,13497,13504,13506,13523,13563,13633,13639,13740,13764,13808,13844,13879,13886,13909,13910,13948,13949,14117,14123,14128,14130,14148,14226,14260,14274,14297,14330,14346,14351,14358,14512,14566,14598,14740,14765,14784,14824,14828,14947,14962,14991,15103,15105,15191,15193,15207,15240,15260,15264,15318,15363,15432,15443,15447,15501,15527,15528,15560,15624,15628,15693,15699,15701,15721,15723,15738,15768,15775,15776,15789,15793,15798,15799,15854,15855,15857,15872,15879,15889,15894,15912,15932,15938,15958,15976,16038,16071,16084,16100,16119,16172,16193,16217,16225,16288,16310,16311,16314,16315,16342,16368,16378,16396,16427,16493,16495,16509,16531,16593,16613,16627,16651,16681,16683,16705,16729,16733,16746,16750,16770,16771,16799,16872,16874,16875,16883,16889,16937,16954,16960,16988,16993,17024,17025,17038,17109,17112,17120,17148,17152,17160,17200,17260,17297,17298,17299,17342,17346,17418,17475,17499,17502,17545,17548,17550,17583,17601,17609,17614,17627,17668,17671,17693,17718,17720,17755,17792,17853,17913,17931,17955,18061,18190,18271,18330,18399,18450,18510,18529,18609,18614,18694,18715,18725,18740,18803,18818,18923,19143,19496,19500,19564,19593,19691,19719,19733,19784,19787,19839,19852,19949,20002,20009,20054,20080,20301,20332,20360,20504,20509,20580,20676,20696,20737,20805,20810,20844,20845,20960,21063,21099,21193,21208,21209,21473,21475,21499,21522,21627,21693,21858,22042,22053,22318,22337,22642,22715,22731,22747,22983,23308,23473,23664,23858,23859,24068,24127,24350,24430,24596,24778,24890,25028,25070,25071,25152,25294,25352,25680,25681,25684,25758,25851,25902,26237,26438,26572,26604,26635,26706,26710,26860,26958,26960,27025,27056,27166,27217,27298,27600,27636,27651,27744,27802,27907,28081,28087,28320,28360,28747,28754,28839,28952,28983,29357,29396,29427,29681,34273,35776,36191,36625,37144,38109,38853,38974,39146,39893,40282,41117)
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 | 776 | 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.45 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.17 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 1.25 ms |
preparing | 0.62 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.42 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.06 ms |
cleaning up | 0.02 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 |