Tiempo de la consulta: 3.55 ms Después de la última consulta: 0.56 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.154 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-04 08:49:10')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 08:49:10')
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(1572,2479,2799,3059,3111,3202,3234,3312,3471,3499,3517,3602,3739,3802,3806,3821,3849,3850,3861,3910,3928,3948,3956,3990,4007,4014,4029,4033,4038,4056,4057,4084,4085,4090,4141,4152,4157,4171,4180,4205,4237,4242,4270,4278,4280,4311,4315,4317,4321,4331,4334,4337,4341,4346,4349,4368,4374,4377,4384,4397,4400,4418,4419,4427,4438,4440,4455,4458,4469,4482,4486,4501,4513,4531,4533,4537,4538,4559,4566,4568,4571,4594,4595,4631,4632,4635,4643,4650,4655,4661,4662,4715,4755,4762,4763,4774,4791,4811,4814,4820,4823,4840,4852,4859,4861,4895,4915,4917,4918,4920,4931,4936,4940,4944,4946,4964,4976,4980,4984,4985,5003,5005,5027,5032,5033,5054,5059,5073,5074,5086,5093,5115,5129,5131,5187,5202,5210,5211,5218,5251,5256,5258,5274,5277,5282,5288,5294,5295,5314,5315,5329,5337,5339,5361,5377,5380,5385,5386,5396,5422,5423,5425,5431,5441,5455,5456,5460,5502,5504,5536,5598,5643,5670,5673,5704,5712,5763,5767,5774,5783,5789,5790,5792,5797,5813,5822,5825,5835,5843,5854,5855,5862,5902,5908,5911,5912,5913,5917,5932,5940,5941,5953,5959,5961,5965,5979,5995,6009,6020,6027,6031,6050,6051,6062,6064,6070,6077,6080,6082,6106,6116,6135,6162,6167,6177,6186,6192,6203,6229,6244,6274,6282,6283,6291,6294,6300,6306,6328,6340,6356,6359,6361,6412,6436,6454,6479,6562,6565,6588,6626,6684,6698,6813,6826,6833,6881,6897,6900,6927,6928,6933,6950,6975,6978,6980,6982,7031,7063,7085,7144,7148,7217,7228,7263,7321,7357,7384,7390,7394,7478,7504,7540,7561,7579,7604,7636,7669,7695,7696,7700,7737,7790,7793,7813,7818,7825,7854,7856,7905,7912,7915,7947,8042,8060,8092,8116,8125,8142,8151,8159,8170,8195,8204,8210,8235,8257,8259,8277,8281,8289,8298,8312,8323,8324,8331,8336,8341,8366,8375,8388,8394,8427,8457,8470,8479,8517,8531,8539,8572,8576,8595,8621,8649,8652,8655,8660,8676,8678,8680,8689,8711,8755,8759,8763,8765,8769,8802,8804,8825,8863,8864,8875,8912,8913,8922,8935,8937,8953,8955,8957,8958,8966,8980,8985,8986,8987,9006,9009,9024,9031,9034,9096,9123,9135,9137,9140,9157,9184,9228,9253,9269,9365,9393,9439,9481,9484,9486,9543,9544,9633,9640,9646,9651,9672,9673,9694,9734,9785,9790,9792,9834,9863,9877,9891,9916,9948,9989,10040,10123,10126,10133,10144,10164,10177,10184,10220,10281,10297,10324,10398,10415,10468,10588,10677,10678,10813,10999,11119,11182,11213,11240,11335,11387,11402,11420,11425,11610,11636,11707,11783,11832,11852,11893,11919,11960,11972,11976,11985,12066,12130,12159,12220,12231,12495,12501,12525,12540,12604,12627,12754,12831,12857,12884,12929,12932,13030,13083,13175,13193,13264,13347,13636,13639,14050,14123,14661,14662,14760,14784,14785,14823,14868,14878,15019,15022,15058,15122,15132,15161,15399,15545,15731,15736,15813,15893,15911,15933,15973,16110,16199,16235,16311,16396,16477,16484,16597,16605,16723,16771,16785,16819,16853,16854,16877,16901,16913,16914,16924,16993,17075,17079,17245,17350,17475,17546,17672,17972,18155,18302,18305,18474,18662,18732,18896,18901,18923,19090,19115,19158,19281,19332,19333,19388,19574,19872,19907,19926,19955,20048,20346,20353,20646,20736,20819,21069,21339,21373,21407,21754,21791,21814,22015,22023,22121,22133,22240,22296,22505,22625,23030,23090,23183,23332,23494,23610,23950,24108,24150,24349,24358,24452,24671,24742,24832,24873,25123,25131,25152,25445,25459,25586,25613,25985,26031,26097,26385,26420,26474,26513,26582,26743,26920,26991,28300,28322,28387,28395,28491,28651,28993,29067,33041,33500,34075,35570,35681,36889,37131,37360,37396,37402,37538,37597,38601,38755,39291,39308,39675,39727,39827,39981,40089,40332,40486,40759,41295,41455,42277,42313,42375,42469,42535,42694,42785,43046,43082,43809)
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 | 657 | 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.02 ms |
init | 0.14 ms |
System lock | 0.02 ms |
optimizing | 0.05 ms |
statistics | 1.11 ms |
preparing | 0.50 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.33 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.05 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 |