Tiempo de la consulta: 3.54 ms Después de la última consulta: 0.54 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.149 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 22:40:20')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-08 22:40:20')
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(1279,1860,1961,2864,3059,3111,3202,3234,3312,3471,3499,3517,3524,3526,3566,3602,3739,3802,3806,3821,3849,3850,3910,3928,4007,4029,4033,4038,4056,4057,4084,4085,4113,4141,4152,4157,4171,4180,4205,4237,4242,4270,4274,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,4477,4482,4486,4501,4513,4531,4533,4537,4538,4559,4566,4568,4571,4588,4594,4595,4631,4632,4635,4643,4650,4651,4655,4661,4662,4665,4755,4762,4763,4774,4791,4811,4814,4820,4823,4840,4852,4859,4861,4895,4915,4917,4918,4920,4931,4936,4938,4940,4944,4946,4964,4980,4984,5003,5005,5027,5032,5033,5054,5059,5073,5074,5086,5093,5115,5129,5131,5187,5202,5210,5211,5218,5251,5256,5258,5264,5274,5277,5282,5288,5294,5295,5314,5315,5329,5337,5339,5361,5377,5380,5385,5386,5396,5422,5423,5431,5441,5455,5456,5460,5502,5504,5536,5598,5651,5670,5673,5704,5708,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,5964,5965,5979,5995,6009,6020,6027,6031,6050,6051,6062,6064,6070,6080,6082,6106,6116,6135,6162,6177,6186,6192,6203,6248,6249,6274,6282,6283,6291,6294,6306,6328,6340,6356,6359,6361,6412,6436,6454,6479,6562,6565,6588,6626,6698,6813,6826,6833,6881,6897,6900,6927,6928,6933,6950,6975,6978,6980,6982,7031,7063,7085,7142,7144,7148,7217,7228,7263,7321,7357,7390,7394,7478,7540,7561,7574,7604,7669,7695,7696,7697,7709,7737,7790,7793,7813,7818,7825,7854,7905,7947,8003,8042,8060,8092,8116,8125,8142,8151,8159,8170,8195,8204,8210,8235,8249,8257,8259,8268,8269,8277,8281,8298,8312,8323,8324,8331,8333,8336,8341,8357,8366,8375,8377,8388,8394,8424,8427,8457,8470,8479,8517,8525,8527,8531,8539,8576,8592,8595,8621,8649,8652,8655,8660,8667,8676,8678,8687,8689,8711,8755,8759,8763,8765,8769,8802,8806,8825,8828,8842,8856,8863,8864,8875,8911,8912,8913,8922,8935,8937,8953,8955,8957,8958,8966,8977,8980,8985,8986,8987,9006,9009,9024,9031,9034,9064,9096,9123,9135,9140,9157,9184,9228,9253,9269,9365,9393,9439,9481,9484,9486,9544,9558,9640,9646,9651,9672,9673,9694,9713,9734,9785,9790,9792,9863,9877,9891,9916,9941,9948,9989,10040,10058,10123,10126,10133,10164,10168,10177,10184,10277,10281,10297,10324,10398,10415,10441,10588,10677,10678,10813,10882,10905,10983,10999,11119,11153,11182,11213,11240,11283,11335,11359,11402,11420,11425,11520,11578,11610,11636,11783,11832,11893,11919,11960,11972,11976,11985,12066,12130,12159,12220,12231,12495,12501,12525,12540,12604,12627,12754,12831,12857,12884,12932,13083,13113,13148,13171,13175,13267,13639,13876,14050,14123,14153,14312,14438,14492,14645,14661,14662,14728,14784,14785,14823,14868,14878,14889,15019,15022,15058,15132,15161,15290,15483,15736,15786,15893,15911,15933,15979,16053,16079,16110,16253,16311,16396,16494,16552,16597,16723,16767,16771,16785,16854,16877,16901,16914,16993,17048,17075,17079,17186,17245,17315,17350,17475,17517,17546,17548,17672,17774,18183,18239,18402,18561,18732,18742,18749,18923,19115,19907,20048,20114,20222,20262,20646,20846,20905,20986,21092,21098,21487,21678,22015,22119,22160,22166,22296,22399,22553,23029,23120,23312,23314,23368,23571,23737,23843,23969,24108,24150,24215,24252,24708,24755,24820,25131,25916,26420,26515,26743,26852,26920,27395,28300,28322,28651,28973,28993,29067,29349,29405,39967,40454,44345)
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 | 623 | 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.41 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 | 0.96 ms |
preparing | 0.53 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.39 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.04 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 |