Tiempo de la consulta: 4.24 ms Después de la última consulta: 0.68 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.309 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 16:48:36')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 16:48:36')
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,25,49,58,131,133,139,155,170,172,220,287,290,291,293,344,353,437,607,693,797,843,929,986,997,1169,1204,1207,1232,1247,1339,1486,1931,2222,2261,2482,2757,2776,2997,3020,3028,3045,3124,3198,3209,3212,3223,3279,3341,3384,3503,3522,3543,3577,3671,3672,3706,3738,3842,3912,3997,4030,4031,4061,4078,4090,4114,4120,4128,4168,4236,4239,4257,4315,4325,4346,4347,4399,4417,4499,4643,4760,4778,4780,4789,4894,4910,4915,4940,5115,5152,5187,5210,5211,5229,5274,5304,5350,5386,5407,5433,5442,5471,5536,5559,5647,5652,5816,5842,5851,5854,5870,5979,6039,6062,6131,6164,6234,6247,6274,6337,6361,6419,6484,6486,6567,6577,6616,6619,6647,6688,6715,6776,6998,7031,7142,7143,7146,7165,7166,7187,7217,7218,7282,7311,7359,7361,7364,7391,7451,7483,7509,7539,7561,7572,7603,7677,7736,7737,7787,7818,7825,7827,7847,7848,7894,7965,7973,8010,8014,8027,8036,8041,8065,8123,8130,8163,8171,8177,8207,8219,8259,8263,8264,8311,8318,8379,8400,8422,8455,8469,8509,8519,8520,8523,8563,8576,8623,8625,8698,8727,8736,8756,8785,8789,8857,8862,8867,8919,8934,8949,8971,8980,9005,9020,9050,9080,9091,9128,9138,9159,9165,9212,9214,9239,9249,9310,9311,9318,9347,9365,9384,9435,9445,9448,9457,9467,9503,9549,9555,9568,9585,9594,9616,9676,9690,9702,9774,9827,9829,9892,9893,9907,9945,9959,9983,10060,10100,10108,10116,10117,10149,10154,10170,10187,10196,10208,10268,10277,10278,10294,10342,10382,10401,10435,10498,10512,10522,10567,10623,10721,10754,10782,10846,10903,10955,10957,10970,10983,11065,11073,11091,11148,11149,11167,11335,11344,11441,11503,11607,11749,11757,11875,11886,11942,11974,11978,11983,12133,12174,12193,12270,12285,12355,12527,12581,12582,12631,12651,12685,12695,12743,12812,12823,12844,12851,12856,12884,12978,12997,13048,13089,13090,13207,13307,13332,13376,13420,13504,13506,13515,13587,13740,13751,13808,13844,13879,13886,13905,13909,13910,13948,13949,13972,14123,14128,14162,14186,14260,14297,14330,14346,14372,14453,14591,14598,14630,14740,14824,14828,14840,14845,14852,14856,14947,14962,14983,15007,15103,15129,15156,15193,15214,15240,15245,15260,15286,15318,15335,15351,15376,15406,15424,15432,15447,15475,15501,15520,15522,15560,15581,15600,15628,15689,15699,15700,15721,15723,15738,15742,15768,15775,15776,15785,15790,15793,15799,15812,15855,15872,15879,15880,15889,15894,15912,15932,15958,16038,16071,16084,16095,16100,16119,16127,16172,16193,16217,16249,16310,16314,16315,16357,16368,16375,16378,16384,16509,16521,16528,16551,16651,16675,16705,16729,16746,16771,16781,16814,16816,16841,16872,16875,16954,16960,16988,16993,17024,17025,17047,17049,17109,17112,17116,17120,17148,17152,17188,17200,17240,17246,17260,17288,17297,17298,17300,17331,17387,17418,17444,17475,17497,17545,17548,17550,17561,17573,17583,17601,17613,17627,17630,17668,17688,17693,17711,17736,17753,17755,17779,17834,17862,17919,17924,17930,17936,17950,17967,17983,18044,18061,18190,18222,18260,18271,18295,18330,18382,18510,18524,18529,18552,18609,18664,18693,18694,18702,18705,18708,18715,18728,18764,18830,18839,18843,18853,18854,18877,18888,18905,18923,19015,19105,19124,19128,19140,19143,19173,19178,19222,19284,19287,19290,19315,19375,19381,19414,19439,19455,19486,19607,19634,19639,19644,19659,19684,19710,19719,19725,19733,19784,19787,19794,19807,19819,19839,19923,20045,20091,20119,20175,20276,20301,20445,20504,20542,20577,20638,20659,20676,20772,20777,20805,20940,20959,20960,21009,21060,21063,21075,21107,21117,21118,21143,21171,21209,21218,21344,21350,21367,21378,21398,21421,21457,21470,21475,21520,21522,21609,21627,21663,21684,21702,21714,21741,21749,21764,21776,21777,21778,21858,21864,21883,21906,21917,21968,21997,22038,22067,22072,22106,22119,22178,22278,22298,22332,22349,22395,22450,22460,22476,22495,22555,22570,22595,22642,22715,22759,22804,22820,22840,22879,22920,22944,22951,22960,23034,23055,23078,23093,23242,23273,23279,23308,23367,23368,23405,23430,23438,23553,23555,23569,23646,23665,23695,23709,23716,23719,23774,23849,23955,23968,24068,24076,24100,24127,24164,24217,24233,24237,24258,24272,24275,24291,24368,24428,24437,24530,24565,24584,24590,24690,24779,24780,24805,24841,24946,24963,25037,25077,25081,25116,25117,25187,25281,25294,25297,25300,25329,25352,25356,25386,25452,25523,25664,25676,25807,25919,25971,26229,26261,26375,26431,26596,26604,26835,26842,26843,26854,26864,26873,26958,26959,26960,27001,27025,27056,27061,27062,27158,27186,27197,27290,27384,27552,27578,27633,27646,27707,27745,27832,27851,27918,27921,27923,27924,27926,27950,28066,28094,28213,28264,28283,28360,28372,28747,28749,28826,29061,29073,29223,29539,29611,29719,29930,31908,32840,38932,39966,39981,39998,40168,40611,41257,44563)
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 | 814 | 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.46 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.17 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 1.30 ms |
preparing | 0.84 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.37 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 |