Tiempo de la consulta: 4.59 ms Después de la última consulta: 0.82 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.180 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 01:58:21')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 01:58:21')
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(9,45,46,54,62,65,71,205,415,643,659,764,1295,1335,1563,1571,1716,1773,1810,2051,2084,2344,2444,2493,2909,3138,3163,3164,3196,3255,3266,3317,3361,3388,3393,3486,3497,3529,3581,3685,3712,3713,3760,3767,3776,3821,3830,3833,3902,3913,3960,4034,4054,4084,4101,4110,4114,4129,4146,4148,4150,4173,4202,4204,4284,4285,4323,4327,4369,4375,4423,4436,4456,4475,4511,4512,4518,4548,4555,4570,4575,4595,4731,4733,4734,4771,4798,4842,4859,4914,4938,4940,5085,5095,5176,5259,5276,5284,5292,5295,5304,5310,5313,5329,5382,5387,5396,5422,5456,5489,5708,5761,5909,5916,5920,6030,6031,6047,6063,6075,6100,6103,6115,6116,6128,6242,6348,6360,6362,6417,6440,6649,6720,6815,6865,6881,6900,6981,7033,7077,7111,7148,7185,7216,7250,7251,7255,7258,7261,7318,7331,7352,7364,7444,7510,7537,7586,7605,7614,7618,7651,7724,7752,7771,7784,7787,7874,7877,7883,7884,7903,7906,7912,7925,7935,7940,7942,7975,8004,8055,8152,8160,8179,8196,8227,8229,8234,8244,8265,8266,8305,8342,8365,8370,8378,8385,8412,8421,8430,8452,8453,8476,8507,8550,8570,8598,8611,8644,8650,8660,8677,8686,8697,8700,8718,8730,8737,8742,8750,8799,8813,8824,8826,8842,8850,8864,8867,8876,8893,8925,8934,8954,9007,9019,9047,9063,9068,9103,9120,9127,9187,9217,9232,9244,9267,9296,9304,9309,9311,9317,9327,9328,9350,9354,9383,9390,9420,9466,9471,9477,9501,9534,9543,9547,9569,9570,9573,9578,9584,9593,9599,9600,9609,9610,9617,9634,9657,9675,9684,9696,9715,9725,9738,9758,9760,9776,9783,9794,9829,9838,9878,9893,9896,9904,9908,9911,9922,9946,9956,9971,9977,10004,10043,10052,10084,10085,10122,10163,10167,10177,10190,10210,10212,10265,10269,10270,10313,10331,10392,10414,10448,10450,10461,10488,10498,10499,10513,10542,10569,10605,10617,10642,10700,10744,10754,10756,10774,10791,10812,10846,10933,10953,10976,10993,11023,11031,11041,11073,11120,11121,11152,11240,11250,11286,11338,11373,11387,11409,11412,11422,11435,11483,11488,11545,11558,11607,11636,11650,11678,11687,11690,11750,11796,11797,11806,11829,11855,11886,11906,11907,11921,11937,12063,12082,12249,12274,12384,12444,12452,12467,12496,12513,12553,12565,12632,12638,12661,12662,12689,12690,12743,12824,12831,12844,12936,12953,13005,13083,13110,13146,13166,13175,13185,13209,13270,13295,13305,13313,13376,13385,13441,13497,13523,13563,13633,13639,13702,13731,13738,13760,13764,13789,13946,13961,13978,13996,14009,14130,14141,14148,14226,14260,14297,14351,14395,14396,14414,14460,14512,14513,14515,14532,14566,14601,14613,14616,14656,14662,14695,14730,14739,14755,14784,14804,14819,14820,14824,14825,14875,14877,14884,14911,14939,14952,14991,14999,15006,15041,15044,15069,15081,15105,15148,15160,15178,15189,15193,15207,15268,15326,15347,15388,15423,15432,15443,15457,15465,15482,15487,15527,15551,15570,15611,15617,15636,15637,15640,15693,15698,15701,15738,15767,15783,15798,15857,15866,15894,15912,15913,15921,15938,15976,16025,16036,16039,16042,16059,16082,16084,16097,16127,16129,16156,16181,16248,16256,16292,16298,16311,16314,16315,16396,16403,16493,16495,16552,16577,16593,16681,16705,16750,16759,16828,16874,16883,16889,16890,16937,16991,17033,17053,17067,17074,17102,17107,17115,17145,17160,17216,17233,17266,17299,17303,17399,17468,17499,17553,17614,17633,17650,17720,17792,17844,17853,17855,17859,17893,17911,17913,17926,17931,17955,17966,18054,18062,18093,18122,18157,18180,18233,18255,18268,18271,18274,18292,18314,18316,18344,18359,18362,18399,18450,18460,18539,18544,18564,18608,18614,18709,18725,18727,18740,18794,18800,18820,18846,18862,18878,18916,18922,18931,18954,18975,18980,19028,19034,19037,19042,19068,19105,19124,19128,19135,19143,19155,19218,19240,19247,19313,19366,19530,19550,19561,19600,19604,19637,19652,19691,19713,19732,19787,19817,19852,19872,19945,19949,20009,20018,20030,20080,20127,20250,20260,20264,20327,20348,20349,20360,20376,20393,20429,20444,20461,20489,20507,20602,20649,20678,20737,20741,20779,20786,20797,20813,20828,20845,20850,20906,20915,20959,21000,21030,21057,21062,21092,21099,21107,21108,21117,21143,21161,21190,21193,21208,21249,21325,21369,21381,21397,21434,21435,21457,21458,21464,21489,21544,21552,21554,21578,21588,21590,21641,21710,21740,21744,21764,21776,21777,21855,21858,21883,21894,21944,21976,21982,22010,22040,22042,22053,22063,22111,22160,22176,22214,22237,22298,22313,22318,22348,22407,22457,22459,22461,22559,22617,22647,22731,22733,22739,22763,22819,22837,22889,22890,22904,22957,22983,23065,23067,23116,23131,23160,23185,23195,23201,23237,23241,23260,23280,23313,23320,23325,23326,23328,23335,23339,23442,23473,23582,23664,23678,23679,23772,23781,23858,23859,23890,23985,24075,24102,24104,24152,24188,24191,24273,24274,24327,24366,24371,24392,24503,24576,24592,24596,24644,24727,24733,24778,24816,24837,24844,24899,24964,25070,25071,25072,25085,25098,25107,25125,25133,25225,25253,25303,25377,25380,25644,25645,25680,25681,25714,25730,25785,25850,25851,25902,25993,26115,26178,26183,26256,26273,26322,26390,26438,26493,26501,26504,26521,26563,26589,26648,26674,26689,26706,26860,26901,26926,26972,26973,27002,27011,27061,27150,27170,27185,27246,27273,27297,27321,27356,27418,27420,27431,27496,27521,27545,27574,27593,27644,27686,27704,27721,27801,27802,27842,27917,27931,27936,28005,28033,28045,28082,28225,28312,28320,28411,28621,28639,28653,28658,28839,28952,28983,28989,29008,29009,29152,29153,29174,29197,29319,29356,29357,29417,29443,29444,29476,29781,29846,29905,29922,29923,29935,32768,32842,32911,33644,34273,35617,35689,35883,35885,36151,36178,38807,38831,38832,38854,38866,38974,39481,39603,39681,39857,40025,40038,40083,40097,40170,40200,40282,40357,40684,40708,40759,40785,40809,40907,40937,40984,41059,41255,41301,41325,41375)
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 | 986 | 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.54 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.19 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.51 ms |
preparing | 0.75 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.50 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.07 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 |