Tiempo de la consulta: 3.79 ms Después de la última consulta: 0.85 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.319 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 07:19:49')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 07:19:49')
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(44,51,220,263,331,341,482,593,682,732,822,869,1066,1071,1101,1225,1272,1359,1404,1410,1411,1444,1485,1503,1509,1519,1549,1574,1576,1620,1735,1741,1752,1765,1771,1775,1839,1848,1994,2001,2006,2008,2015,2016,2019,2054,2055,2106,2123,2125,2126,2137,2142,2161,2189,2220,2225,2226,2230,2288,2290,2323,2344,2360,2432,2436,2443,2444,2470,2507,2533,2551,2586,2597,2605,2632,2638,2670,2675,2682,2699,2710,2760,2762,2788,2811,2860,2865,2911,2969,3008,3009,3036,3122,3188,3196,3206,3217,3224,3239,3240,3250,3281,3292,3305,3326,3329,3345,3372,3373,3376,3387,3426,3442,3446,3462,3515,3563,3575,3593,3595,3630,3648,3661,3696,3703,3720,3722,3726,3735,3901,3919,3957,4047,4053,4106,4148,4155,4207,4227,4262,4263,4265,4312,4323,4334,4354,4385,4411,4430,4461,4467,4468,4469,4472,4490,4492,4506,4507,4520,4529,4550,4554,4558,4569,4580,4621,4637,4666,4672,4673,4753,4821,4832,4833,4848,4876,4932,4955,4988,5049,5056,5092,5094,5096,5104,5134,5144,5150,5173,5214,5244,5246,5266,5298,5306,5343,5345,5356,5399,5415,5469,5478,5487,5496,5512,5534,5578,5589,5635,5646,5650,5653,5664,5701,5707,5732,5755,5781,5803,5874,5895,5897,5914,5950,5959,6032,6034,6056,6070,6100,6130,6141,6173,6198,6285,6300,6372,6394,6415,6424,6442,6465,6471,6476,6477,6589,6593,6597,6606,6612,6613,6622,6623,6637,6638,6680,6727,6729,6818,6845,6864,6894,6958,7022,7023,7025,7046,7183,7227,7278,7324,7375,7388,7395,7522,7527,7533,7601,7631,7664,7739,7780,7852,7942,7945,7953,8041,8045,8046,8051,8161,8185,8217,8273,8291,8294,8314,8343,8367,8373,8386,8388,8393,8424,8439,8454,8460,8463,8481,8498,8529,8611,8634,8671,8679,8707,8793,8878,8913,8940,8988,8993,9014,9015,9057,9061,9062,9074,9086,9087,9089,9122,9152,9169,9190,9199,9220,9241,9250,9307,9359,9360,9384,9401,9470,9494,9512,9519,9553,9653,9658,9709,9776,9819,9851,9854,9904,9929,9931,9992,9998,10005,10011,10101,10113,10156,10407,10562,10572,10799,10892,11207,11244,11320,11327,11408,11443,11463,11469,11549,11562,11625,11694,11700,11723,11741,11751,11786,11788,11814,11850,11935,12242,12291,12324,12502,12591,12650,12817,12878,12973,13038,13167,13186,13205,13219,13231,13287,13348,13416,13475,13530,13592,13619,13830,13851,13925,14132,14146,14171,14189,14194,14209,14228,14310,14331,14333,14364,14428,14432,14565,14618,14710,14713,14733,14737,14862,14865,14884,14972,14975,14988,14996,15017,15074,15087,15129,15138,15144,15171,15203,15322,15398,15414,15530,15531,15710,15719,15765,15796,15850,15855,15868,15871,15967,15969,16031,16102,16177,16245,16368,16416,16510,16547,16548,16569,16571,16634,16636,16649,16698,16742,16743,16745,16793,16880,16997,17028,17045,17055,17062,17080,17133,17136,17137,17167,17170,17237,17315,17335,17354,17412,17427,17500,17524,17606,17635,17649,17679,17721,17783,17942,18035,18080,18092,18096,18151,18265,18304,18306,18446,18473,18491,18547,18609,18630,18779,18802,18836,18969,18977,18978,19012,19039,19112,19394,19424,19541,19547,19551,19554,19681,19724,19860,19996,20188,20306,20337,20342,20367,20396,20418,20448,20484,20565,20617,20621,20640,20662,20663,20675,20704,20723,20743,20839,20871,20922,20966,20997,21006,21025,21027,21034,21036,21095,21185,21203,21241,21251,21279,21439,21488,21534,21560,21652,21717,21720,21741,21746,21787,21835,21940,22041,22249,22311,22312,22450,22586,22603,22870,22966,23161,23428,23452,23511,23648,23676,23701,23945,23983,24151,24184,24188,24416,24609,24627,24956,25128,25457,25578,25600,25682,25766,25837,26000,26043,26082,26083,26128,26148,26361,26362,26376,26476,26487,26578,26800,26843,26874,26875,26917,26949,26950,26997,27129,27280,27291,27354,27421,27422,27427,27437,27460,27502,27635,27750,27805,27860,27875,27894,27898,27968,27990,28022,28030,28218,28272,28281,28327,28392,28416,28423,28436,28437,28440,28442,28458,28470,28524,28526,28540,28547,28553,28555,28582,28587,28635,28636,28666,28668,28736,28828,28838,28858,28878,28884,29006,29013,29221,29222,29374,29440,30199,30273,31868,32755,32912,33897,33993,34319,34356,34368,34862,34982,35036,35103,35219,35269,35298,35657,35676,35685,35724,35746,35967,36049,36050,36252,36442,36489,37497,37647,38048,38437,38438,38599,38645,38663,38855,38988,39081,39149,39171,39253,39301,39310,39636,39683,39695,39696,39714,39765,39782,39896,39897,39971,40034,40136,40290,40344,40358,40453,40481,40482,40700,40734,40757,40784,40863,40925,40962,41117,41392,41585,41668,41797,41880,41955,42034,42051,42104,42106,42260,42309,42411,42522,42537,42603,42763,42859,42871,42876,43099,43163,43256,43259,43351,43461,43520,43545,43603,43697,44067,44197,44354,44650,44752,44769,44833,44846,44855,44873,44893,44943,45139,45217,45236,45295)
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 | 819 | 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.45 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.21 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.34 ms |
preparing | 0.68 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.39 ms |
end | 0.03 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 |