Tiempo de la consulta: 3.36 ms Después de la última consulta: 0.60 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.306 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-09 14:43:04')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 14:43: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(60,274,998,1304,1984,2027,2261,2482,2776,2971,3036,3161,3198,3202,3223,3341,3384,3503,3522,3543,3577,3588,3672,3706,3795,3833,3912,3927,3945,3997,4030,4078,4090,4104,4114,4120,4168,4236,4239,4257,4315,4325,4346,4347,4417,4499,4521,4542,4643,4760,4778,4780,4789,4894,4915,4930,4940,5000,5115,5152,5187,5210,5211,5229,5274,5304,5350,5386,5407,5433,5442,5525,5536,5553,5586,5592,5625,5652,5700,5746,5758,5809,5816,5820,5842,5851,5854,5908,5924,5947,5950,5966,5968,5979,5986,5987,5989,5990,5991,5995,6012,6020,6022,6062,6073,6079,6083,6097,6108,6110,6112,6132,6138,6164,6222,6247,6274,6319,6337,6361,6419,6432,6439,6464,6486,6504,6567,6583,6610,6611,6619,6647,6659,6715,6776,6886,6887,6945,7031,7142,7143,7146,7165,7166,7187,7200,7217,7218,7311,7359,7364,7391,7451,7509,7529,7539,7550,7561,7603,7621,7736,7737,7787,7792,7810,7818,7825,7827,7848,7866,7930,7973,8010,8014,8036,8041,8065,8083,8088,8089,8123,8163,8171,8177,8207,8219,8259,8261,8264,8311,8318,8379,8400,8422,8455,8469,8509,8519,8520,8523,8563,8576,8612,8623,8625,8647,8696,8698,8723,8727,8736,8756,8785,8789,8841,8857,8862,8867,8879,8919,8934,8949,8955,8962,8971,8980,9005,9020,9023,9040,9050,9080,9126,9128,9138,9159,9165,9212,9214,9249,9310,9311,9347,9365,9384,9387,9435,9445,9448,9457,9467,9503,9515,9549,9555,9568,9585,9594,9616,9665,9676,9690,9702,9738,9774,9827,9829,9833,9892,9893,9907,9959,10060,10108,10116,10117,10149,10154,10170,10187,10196,10208,10228,10268,10277,10278,10294,10303,10342,10401,10435,10498,10512,10522,10556,10567,10754,10846,10903,10983,11006,11065,11073,11091,11137,11148,11149,11167,11335,11344,11503,11607,11749,11757,11781,11868,11875,11886,11925,11974,11978,11983,12077,12174,12193,12265,12285,12355,12527,12631,12651,12675,12695,12743,12812,12823,12844,12856,12884,12922,12939,12997,13015,13026,13029,13089,13090,13091,13129,13145,13207,13231,13248,13376,13504,13506,13617,13701,13740,13808,13844,13851,13855,13861,13879,13886,13909,13910,13948,13949,14123,14128,14260,14297,14330,14346,14398,14424,14478,14531,14598,14655,14740,14824,14828,14947,14962,15002,15046,15103,15193,15240,15260,15262,15287,15298,15314,15318,15324,15432,15447,15501,15560,15606,15620,15626,15628,15642,15699,15709,15721,15723,15738,15749,15768,15775,15776,15793,15799,15855,15872,15876,15879,15889,15899,15912,15932,15958,16038,16071,16084,16100,16119,16172,16193,16217,16310,16314,16315,16368,16378,16427,16464,16509,16648,16651,16705,16729,16746,16771,16793,16795,16872,16875,16924,16954,16960,16988,16993,16995,17024,17025,17109,17112,17120,17148,17152,17156,17200,17260,17270,17293,17297,17298,17346,17418,17420,17475,17545,17548,17550,17583,17601,17618,17620,17627,17630,17668,17693,17698,17755,17842,18038,18061,18102,18184,18190,18234,18271,18330,18347,18494,18510,18517,18529,18609,18678,18694,18715,18755,18778,18826,18851,18876,18891,18892,18905,18906,18907,18917,18923,18925,18929,18931,18934,18938,18940,18945,18956,19046,19143,19163,19197,19422,19548,19553,19558,19589,19693,19719,19733,19784,19787,19808,19809,19839,19845,19857,19865,19879,20081,20139,20215,20301,20353,20436,20504,20535,20676,20680,20732,20805,20960,21063,21209,21475,21522,21627,21671,21833,21858,22209,22215,22311,22362,22365,22591,22642,22651,22715,22850,22926,22998,23112,23139,23308,23402,23428,23494,23511,23584,23589,23611,23709,23732,23892,23912,24014,24068,24127,24190,24270,24280,24298,24317,24339,24347,24382,24387,24396,24415,24424,24431,24451,24486,24553,24554,24650,24771,24774,24777,24783,24831,24856,25049,25281,25294,25352,25526,25592,25752,25909,26190,26530,26531,26558,26604,26875,26958,26960,27025,27056,27096,27208,27217,27223,27249,27422,27499,27853,28360,28596,28747,29231,29232,31060,33303,33476,35574,35637,36027,36904,40328,44318,44427)
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 | 665 | 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.35 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.15 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 1.16 ms |
preparing | 0.54 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.38 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.07 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 |