Tiempo de la consulta: 3.76 ms Después de la última consulta: 0.83 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.302 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-07 00:00:14')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 00:00:14')
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(185,259,544,1286,1371,1409,1410,1428,1540,1606,1619,1648,1694,1724,1794,1795,1796,1808,1810,1843,1930,1975,2004,2061,2197,2261,2384,2467,2482,2613,2628,2776,2898,2939,3032,3198,3223,3283,3296,3330,3341,3377,3384,3478,3503,3512,3515,3522,3543,3564,3567,3577,3590,3637,3672,3706,3779,3815,3822,3823,3848,3858,3912,3934,3997,4030,4031,4034,4077,4078,4090,4107,4114,4120,4168,4172,4175,4192,4207,4236,4239,4257,4266,4315,4325,4346,4347,4414,4417,4436,4437,4451,4499,4529,4550,4561,4569,4596,4622,4623,4643,4760,4778,4780,4789,4876,4877,4881,4894,4915,4940,5024,5032,5072,5115,5123,5137,5152,5187,5210,5211,5213,5229,5247,5249,5267,5270,5274,5289,5303,5304,5306,5329,5338,5350,5368,5386,5387,5407,5419,5421,5433,5442,5454,5536,5644,5652,5684,5704,5762,5816,5827,5837,5842,5851,5854,5909,5912,5927,5979,6041,6062,6164,6176,6194,6247,6274,6336,6337,6361,6419,6486,6564,6567,6619,6647,6715,6737,6759,6776,7002,7031,7142,7143,7165,7166,7168,7187,7217,7218,7311,7359,7364,7385,7386,7391,7393,7394,7412,7451,7474,7509,7529,7539,7561,7594,7603,7669,7681,7688,7725,7732,7736,7737,7787,7817,7818,7825,7827,7848,7878,7885,7942,7973,8008,8010,8014,8027,8036,8041,8065,8117,8123,8163,8171,8176,8177,8207,8219,8259,8263,8264,8311,8318,8330,8331,8355,8358,8363,8364,8369,8379,8387,8400,8409,8421,8422,8424,8455,8469,8481,8506,8509,8519,8520,8523,8563,8576,8599,8623,8625,8644,8667,8671,8698,8703,8727,8736,8756,8758,8785,8789,8803,8804,8857,8862,8867,8869,8873,8919,8930,8934,8949,8971,8977,8980,8998,9005,9019,9020,9050,9080,9109,9115,9128,9138,9159,9165,9167,9212,9214,9234,9249,9302,9310,9311,9325,9327,9347,9354,9365,9384,9400,9420,9435,9442,9445,9448,9453,9457,9467,9503,9549,9555,9568,9585,9594,9616,9640,9676,9690,9697,9702,9728,9732,9774,9793,9827,9829,9838,9886,9892,9893,9907,9959,10001,10042,10060,10082,10108,10116,10117,10124,10148,10149,10154,10170,10172,10187,10196,10208,10268,10277,10278,10294,10308,10342,10393,10401,10435,10473,10498,10512,10513,10522,10567,10614,10673,10754,10846,10903,10932,10983,10998,11065,11073,11089,11091,11148,11149,11167,11184,11275,11335,11344,11436,11503,11607,11626,11694,11728,11749,11757,11772,11875,11886,11936,11974,11978,11983,12174,12193,12214,12268,12285,12288,12298,12355,12468,12527,12621,12631,12651,12695,12743,12812,12823,12844,12856,12878,12884,12886,12897,12997,13089,13090,13094,13113,13135,13153,13205,13207,13353,13376,13436,13504,13506,13582,13608,13740,13748,13750,13794,13808,13811,13844,13858,13879,13886,13909,13910,13948,13949,14047,14097,14123,14128,14211,14260,14297,14306,14330,14346,14355,14458,14460,14494,14532,14598,14607,14645,14693,14729,14740,14824,14828,14848,14866,14879,14944,14947,14950,14962,15098,15103,15126,15137,15151,15193,15238,15240,15260,15270,15318,15324,15328,15364,15387,15406,15428,15432,15447,15458,15487,15501,15513,15560,15618,15624,15628,15699,15721,15723,15738,15743,15755,15768,15775,15784,15793,15799,15800,15817,15822,15823,15855,15872,15879,15889,15909,15912,15932,15958,15964,16002,16007,16027,16036,16038,16039,16056,16071,16074,16084,16100,16114,16119,16137,16164,16172,16192,16193,16217,16223,16254,16275,16301,16310,16314,16315,16351,16358,16365,16368,16372,16373,16375,16378,16393,16396,16403,16405,16414,16426,16427,16498,16503,16509,16563,16566,16651,16656,16683,16705,16729,16746,16771,16845,16872,16875,16886,16905,16924,16954,16960,16962,16988,16993,17008,17024,17025,17056,17085,17090,17109,17112,17120,17148,17152,17200,17214,17260,17297,17298,17344,17418,17440,17458,17475,17499,17545,17548,17549,17550,17583,17597,17601,17627,17628,17668,17693,17755,17880,17923,17946,17984,18061,18063,18161,18190,18203,18219,18235,18246,18254,18258,18271,18281,18329,18330,18361,18460,18510,18529,18609,18632,18646,18655,18694,18715,18727,18742,18757,18894,18904,18923,18976,19051,19096,19143,19177,19389,19490,19569,19584,19604,19641,19674,19709,19719,19733,19784,19787,19839,19867,19931,20057,20072,20286,20293,20301,20350,20397,20400,20445,20464,20473,20504,20509,20529,20534,20579,20606,20676,20704,20707,20805,20928,20960,20974,21000,21008,21063,21138,21149,21209,21225,21264,21322,21429,21475,21522,21610,21627,21732,21738,21750,21858,21861,21898,21972,21973,21999,22026,22209,22455,22477,22530,22640,22642,22663,22684,22715,23049,23234,23308,23399,23492,23559,23591,23596,23986,24068,24101,24127,24205,24313,24449,24642,24668,24745,24806,24998,25020,25134,25178,25204,25253,25293,25294,25352,25444,25561,25787,26284,26347,26349,26352,26356,26444,26604,26630,26663,26808,26958,26960,27025,27056,27184,27406,27410,27463,27737,27805,27860,27898,28049,28360,28384,28587,28747,29014,29501,29535,29906,29938,30284,34335,37828,40852,41270)
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 | 831 | 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.43 ms |
checking permissions | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.16 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.40 ms |
preparing | 0.71 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.38 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.10 ms |
cleaning up | 0.07 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 |