Tiempo de la consulta: 3.54 ms Después de la última consulta: 0.62 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.307 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-05 02:22:51')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 02:22:51')
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,470,487,911,1287,1354,1361,1488,1525,1706,1756,1879,1898,2104,2170,2261,2376,2481,2482,2579,2594,2607,2650,2763,2776,2801,2895,2896,2975,2998,3020,3023,3112,3163,3198,3223,3297,3328,3341,3342,3384,3448,3471,3503,3522,3529,3543,3567,3577,3582,3672,3673,3706,3713,3781,3784,3912,3995,3996,3997,4001,4013,4030,4076,4078,4090,4114,4120,4154,4168,4203,4236,4239,4257,4315,4325,4346,4347,4369,4406,4417,4494,4499,4547,4643,4760,4778,4780,4789,4859,4893,4894,4915,4940,4991,5095,5115,5140,5146,5152,5175,5178,5187,5210,5211,5229,5261,5262,5274,5288,5304,5327,5343,5346,5350,5383,5386,5407,5433,5438,5442,5456,5536,5652,5655,5766,5816,5842,5851,5854,5909,5920,5979,6004,6030,6062,6164,6173,6247,6274,6337,6361,6419,6425,6486,6513,6559,6567,6619,6647,6714,6715,6776,6896,7031,7064,7092,7120,7142,7143,7145,7148,7165,7166,7180,7187,7217,7218,7311,7318,7320,7341,7354,7359,7364,7391,7451,7454,7509,7539,7561,7603,7608,7622,7736,7737,7765,7769,7770,7787,7799,7814,7818,7825,7827,7848,7908,7973,8010,8036,8041,8043,8065,8090,8123,8138,8142,8163,8171,8177,8202,8207,8219,8229,8235,8246,8259,8263,8264,8272,8282,8284,8311,8318,8332,8379,8388,8396,8400,8422,8455,8469,8509,8511,8519,8520,8523,8531,8563,8576,8598,8609,8623,8625,8630,8640,8691,8698,8699,8722,8727,8736,8756,8785,8789,8790,8840,8845,8857,8862,8867,8919,8934,8949,8952,8971,8976,8980,8986,8995,9005,9020,9050,9080,9103,9128,9138,9151,9159,9165,9180,9212,9214,9249,9310,9311,9342,9347,9365,9384,9435,9440,9445,9448,9457,9467,9480,9503,9505,9549,9555,9568,9585,9594,9616,9636,9655,9676,9690,9702,9773,9774,9815,9827,9829,9846,9884,9892,9893,9907,9913,9947,9959,10021,10022,10038,10047,10060,10108,10116,10117,10149,10154,10170,10187,10196,10208,10224,10229,10253,10268,10269,10275,10277,10278,10294,10334,10335,10342,10376,10401,10435,10498,10512,10522,10564,10567,10573,10643,10695,10754,10846,10903,10983,11065,11073,11091,11104,11120,11148,11149,11154,11167,11180,11304,11335,11344,11503,11607,11608,11632,11641,11749,11750,11757,11806,11875,11886,11974,11978,11983,12100,12105,12174,12181,12193,12197,12215,12216,12285,12355,12393,12487,12527,12602,12631,12651,12690,12693,12695,12705,12708,12743,12812,12823,12844,12856,12884,12997,13066,13089,13090,13187,13207,13276,13284,13349,13376,13504,13506,13740,13759,13808,13832,13844,13879,13886,13909,13910,13948,13949,14012,14026,14123,14128,14260,14297,14299,14330,14346,14372,14484,14516,14517,14533,14598,14607,14644,14740,14779,14819,14824,14828,14857,14947,14962,15007,15056,15103,15193,15216,15240,15252,15260,15296,15306,15318,15430,15432,15447,15501,15560,15628,15699,15721,15723,15738,15768,15771,15775,15776,15783,15793,15799,15801,15855,15872,15879,15889,15912,15932,15938,15958,16038,16061,16071,16078,16084,16100,16119,16130,16138,16139,16172,16193,16217,16310,16314,16315,16354,16368,16371,16378,16407,16427,16501,16509,16523,16610,16651,16705,16729,16746,16771,16776,16790,16834,16872,16875,16954,16960,16988,16993,17022,17024,17025,17067,17109,17112,17120,17148,17152,17200,17260,17275,17297,17298,17331,17343,17362,17391,17394,17418,17475,17545,17548,17550,17583,17601,17609,17627,17640,17668,17693,17729,17755,18061,18079,18190,18269,18271,18330,18386,18510,18526,18529,18609,18694,18698,18715,18789,18876,18923,18942,18972,19017,19082,19115,19143,19315,19373,19479,19521,19597,19719,19733,19784,19787,19839,19959,20065,20097,20173,20301,20461,20504,20676,20805,20960,21063,21178,21209,21421,21443,21475,21514,21522,21537,21543,21624,21627,21681,21858,21859,21901,22054,22127,22152,22642,22694,22695,22715,23287,23308,23359,23452,23727,23800,24068,24127,24559,25294,25352,25428,25548,25729,25869,26338,26604,26958,26960,27025,27056,27059,27521,27672,28360,28593,28747,29426,29575,33417,35576,36965,37748,38278,38391,38402,38453,39266,39579,41151,41157,42123,42270,42795,42843,43364,43808,43837,43960,43964,44509,44825)
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 | 694 | 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.36 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.15 ms |
preparing | 0.55 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.41 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.06 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 |