Tiempo de la consulta: 6.54 ms Después de la última consulta: 0.64 ms Consulta a la memoria: 0.643 MB memoria antes de la consulta: 4.164 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 04:26:50')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 04:26:50')
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(2,5,71,107,119,185,255,266,271,272,283,323,400,403,429,495,657,667,689,722,808,832,863,868,913,937,940,983,1101,1102,1180,1216,1232,1233,1250,1295,1447,1458,1459,1469,1684,1735,1745,1852,1887,1975,2016,2069,2101,2254,2301,2494,2517,2556,2605,2640,2674,2694,2776,2792,2804,2809,2967,3001,3065,3154,3183,3205,3208,3303,3312,3343,3346,3480,3485,3493,3531,3569,3597,3750,3754,3819,3960,3983,4120,4364,4477,4492,4665,4761,4810,4888,5079,5093,5095,5123,5513,5642,5693,5697,5806,5976,5985,6102,6301,6315,6354,6363,6372,6400,6431,6511,6542,6543,6593,6807,6808,6840,6925,6964,6982,6997,7018,7026,7165,7166,7248,7569,7583,7630,7650,7713,7731,7749,7822,7848,7917,8047,8088,8206,8272,8366,8378,8466,8517,8523,8607,8740,8741,8778,8802,8842,8907,8929,8937,9048,9056,9057,9067,9069,9082,9127,9132,9152,9171,9177,9200,9290,9314,9382,9424,9582,9621,9658,9764,9825,9827,9977,9980,10051,10052,10059,10183,10195,10241,10273,10462,10511,10580,10650,10669,10688,10697,10716,10763,10834,10838,10923,10973,11022,11104,11195,11208,11214,11318,11353,11390,11410,11442,11530,11548,11823,11854,11933,12032,12418,12785,12973,13008,13029,13063,13129,13148,13166,13199,13240,13480,13524,13530,13546,13548,13550,13557,13562,13573,13641,13712,13719,13763,13821,13855,13898,13945,13950,14081,14106,14148,14159,14188,14197,14270,14313,14316,14332,14376,14428,14476,14610,14675,14711,14748,14750,14761,14769,14772,14815,14853,14856,14932,14958,15018,15028,15041,15049,15063,15124,15160,15224,15248,15367,15369,15402,15496,15509,15606,15632,15672,15719,15738,15743,15747,15882,15897,15909,15981,16002,16084,16090,16178,16193,16215,16218,16282,16321,16325,16338,16432,16521,16603,16618,16713,16733,16734,16795,16808,17053,17086,17098,17100,17134,17138,17157,17197,17260,17288,17309,17394,17451,17517,17555,17570,17651,17775,17778,17812,17835,17873,17883,17923,17938,18043,18112,18113,18129,18142,18180,18183,18242,18295,18326,18328,18358,18409,18431,18521,18589,18679,18703,18717,18763,18772,18826,18867,18884,18940,19027,19029,19086,19090,19126,19133,19150,19196,19217,19223,19298,19335,19448,19502,19506,19693,19806,19828,19854,19855,19865,19867,19871,19873,19885,19953,19958,20131,20144,20163,20198,20273,20334,20471,20525,20553,20564,20579,20596,20598,20698,20738,20745,20757,20785,20840,20875,20958,20993,21051,21052,21114,21130,21131,21165,21347,21369,21397,21405,21517,21555,21559,21599,21606,21678,21681,21732,21750,21808,21846,21908,21926,22026,22040,22097,22118,22180,22229,22234,22270,22273,22276,22296,22343,22378,22385,22414,22436,22488,22489,22513,22554,22591,22611,22692,22720,22754,22784,22834,22848,22960,22977,22983,22987,23016,23029,23040,23096,23105,23147,23156,23198,23210,23245,23247,23277,23325,23388,23399,23485,23492,23566,23593,23638,23647,23654,23684,23770,23817,23823,24020,24119,24152,24192,24242,24277,24288,24312,24342,24383,24398,24440,24450,24451,24479,24498,24601,24643,24659,24701,24705,24747,24769,24770,24819,24826,24891,24910,25133,25172,25222,25244,25283,25413,25631,25732,25760,25787,25816,25868,25933,25940,25968,26017,26034,26053,26061,26104,26189,26202,26254,26261,26327,26378,26395,26410,26413,26433,26439,26471,26519,26560,26570,26630,26635,26640,26679,26763,26766,26770,26788,26866,26992,27003,27027,27071,27074,27138,27230,27280,27314,27322,27350,27475,27513,27576,27642,27701,27772,27974,28779,28977,28991,29107,29153,29187,29200,29304,29710,30280,30540,30609,30854,31773,31841,32241,33621,33950,34524,34584,34758,34927,35259,35305,35718,35766,35998,36095,36120,36197,36423,36434,37025,37116,38179,38662,38784,38818,38865,38905,38962,39078,39226,39296,39371,39595,39647,39673,39808,39823,40004,40091,40697,40774,40812,40954,41160,41254,41365,41555,41594,42074,42262,42509,45191,45241,45287)
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 | 652 | 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.40 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.05 ms |
preparing | 0.52 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 2.90 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 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 |