Tiempo de la consulta: 3.95 ms Después de la última consulta: 0.66 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.311 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-06 09:30:18')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 09:30:18')
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(174,263,303,331,718,1059,1337,1439,1455,1460,1503,1714,1781,1810,1961,2091,2261,2372,2395,2481,2537,2591,2594,2675,2678,2953,2975,3221,3234,3252,3328,3342,3443,3471,3524,3526,3553,3566,3567,3602,3620,3630,3633,3698,3769,3781,3850,3910,3926,3928,3971,3974,3995,4007,4013,4029,4038,4056,4057,4084,4085,4141,4152,4171,4177,4231,4240,4241,4242,4270,4274,4278,4317,4321,4331,4346,4349,4368,4374,4377,4397,4400,4418,4427,4438,4440,4455,4458,4469,4473,4482,4486,4494,4499,4501,4513,4527,4531,4533,4537,4538,4547,4559,4566,4571,4595,4631,4632,4635,4650,4651,4655,4661,4662,4755,4762,4763,4802,4803,4811,4814,4823,4859,4861,4893,4895,4915,4918,4938,4944,4946,4964,4984,5003,5027,5032,5033,5054,5059,5073,5074,5093,5129,5175,5178,5187,5202,5251,5256,5277,5282,5288,5294,5313,5314,5337,5339,5361,5377,5380,5383,5385,5386,5396,5422,5423,5431,5438,5441,5460,5461,5598,5670,5673,5708,5712,5751,5763,5774,5789,5790,5797,5813,5822,5843,5851,5902,5909,5920,5953,5964,5965,5979,5995,6027,6030,6031,6064,6106,6162,6167,6177,6192,6203,6204,6208,6268,6283,6313,6328,6359,6372,6399,6412,6436,6454,6456,6514,6559,6562,6565,6621,6626,6714,6722,6744,6775,6813,6833,6896,6900,6950,6953,6975,6978,6982,7009,7030,7061,7063,7077,7120,7142,7144,7145,7149,7185,7217,7228,7263,7320,7341,7390,7394,7451,7455,7478,7534,7540,7605,7607,7608,7695,7697,7700,7765,7769,7770,7790,7793,7814,7818,7905,7947,8003,8014,8042,8043,8159,8181,8195,8202,8204,8209,8210,8214,8235,8241,8246,8257,8264,8268,8269,8270,8277,8279,8280,8282,8284,8312,8324,8332,8333,8334,8336,8345,8357,8366,8375,8377,8381,8382,8383,8387,8388,8394,8396,8397,8422,8424,8427,8453,8457,8479,8513,8522,8523,8527,8531,8547,8576,8592,8627,8649,8660,8664,8667,8676,8678,8687,8689,8691,8700,8722,8724,8759,8763,8769,8802,8806,8825,8828,8840,8851,8856,8862,8863,8864,8874,8883,8911,8912,8935,8937,8952,8955,8957,8958,8966,8976,8977,8980,8985,8986,8987,8995,9001,9006,9034,9059,9064,9123,9124,9135,9151,9157,9176,9180,9184,9228,9265,9269,9313,9342,9393,9397,9439,9441,9452,9458,9463,9467,9480,9484,9486,9504,9505,9506,9544,9548,9558,9589,9593,9633,9636,9640,9672,9694,9713,9733,9743,9773,9785,9790,9792,9815,9816,9891,9905,9913,9916,9949,9976,9989,10021,10038,10052,10061,10123,10132,10164,10168,10177,10187,10224,10236,10245,10253,10269,10281,10324,10335,10377,10398,10415,10427,10441,10498,10564,10573,10575,10588,10614,10675,10677,10678,10695,10729,10813,10846,10882,10905,10921,10983,10999,11095,11149,11154,11162,11164,11182,11213,11240,11323,11360,11402,11414,11420,11428,11431,11562,11571,11608,11610,11624,11632,11636,11641,11658,11750,11776,11783,11796,11832,11893,11905,11920,11976,11985,12066,12100,12130,12159,12181,12197,12215,12220,12231,12278,12412,12460,12487,12495,12501,12540,12602,12604,12634,12651,12690,12754,12759,12831,12865,12932,12978,12997,13058,13059,13066,13083,13110,13113,13148,13171,13267,13268,13412,13633,13639,13832,13883,14012,14158,14299,14303,14312,14327,14331,14342,14359,14381,14438,14439,14484,14492,14517,14533,14580,14595,14598,14607,14645,14673,14701,14779,14784,14785,14806,14823,14857,14868,14878,14889,14953,15015,15019,15022,15056,15084,15192,15216,15252,15281,15290,15326,15393,15412,15430,15449,15453,15537,15693,15722,15729,15771,15783,15801,15911,16053,16071,16078,16079,16097,16110,16130,16138,16139,16173,16207,16253,16257,16280,16311,16371,16392,16396,16484,16501,16523,16552,16562,16597,16621,16625,16723,16767,16771,16785,16805,16854,16886,16901,16914,16930,17007,17022,17024,17079,17145,17275,17350,17362,17435,17475,17491,17517,17546,17549,17641,17672,17675,17729,18269,18367,18386,18404,18558,18604,18732,18742,18749,18786,18788,18805,18876,18923,18925,18938,18942,18972,19017,19142,19171,19521,19597,19907,20048,20114,20352,20460,20518,20545,20646,20681,20790,20833,20846,20905,20906,21010,21017,21183,21222,21443,21591,21666,21678,21783,21859,22015,22017,22127,22152,22160,22216,22258,22296,22389,22459,22518,22590,22675,22694,22695,22895,23312,23314,23359,23778,23785,23843,23913,23949,24108,24150,24188,24602,24779,24820,24885,24888,25131,25341,25374,25428,25673,26173,26208,26420,26743,26920,26939,27155,27521,27672,27687,27704,27721,27937,28300,28322,28651,28993,29426,29575,29608,29799,34273,36913,40162,40367,41114,43674,43796,44812,45216)
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 | 777 | 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.42 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.16 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 1.27 ms |
preparing | 0.63 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.34 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.05 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 |