Tiempo de la consulta: 4.48 ms Después de la última consulta: 0.66 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.315 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 19:35:54')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 19:35:54')
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(11,49,58,60,65,66,147,148,149,150,151,152,153,154,155,282,293,385,389,437,458,495,669,675,686,799,813,844,857,868,900,956,970,986,1018,1029,1039,1053,1089,1091,1095,1139,1158,1185,1186,1195,1207,1233,1249,1277,1298,1337,1372,1497,1503,1537,1544,1551,1557,1817,1835,1935,2064,2103,2219,2325,2379,2404,2426,2439,2563,2625,2647,2713,2827,2842,2857,2888,2916,2924,2964,3020,3037,3038,3207,3209,3210,3242,3248,3254,3276,3285,3322,3462,3519,3692,3812,3986,4013,4076,4114,4204,4209,4281,4294,4315,4370,4405,4446,4573,4670,4870,4944,5034,5300,5458,5470,5473,5525,5730,5854,5894,5977,6105,6277,6340,6362,6484,6520,6534,6561,6583,6629,6630,6633,6644,6654,6685,6725,6726,6736,6744,6749,6785,6791,6804,6833,6905,6906,6911,6955,6969,6971,6995,7045,7101,7218,7272,7282,7285,7296,7311,7328,7412,7432,7435,7447,7456,7490,7544,7550,7551,7688,7710,7752,7797,7806,7831,7858,7863,8027,8177,8250,8281,8346,8663,8679,9027,9036,9242,9282,9305,9346,9415,9439,9507,9626,9673,9745,9834,9836,9854,9864,10206,10239,10264,10286,10304,10315,10418,10425,10434,10532,10535,10554,10611,10644,10661,10713,10741,10769,10779,10907,10952,11059,11091,11170,11207,11262,11277,11320,11372,11399,11438,11821,11868,11872,11896,11903,11924,12019,12139,12165,12301,12398,12410,12482,12551,12567,12625,12758,12850,13026,13061,13100,13164,13188,13262,13384,13456,13481,13519,13635,13659,13733,13894,13911,13926,14107,14140,14141,14189,14194,14195,14205,14270,14401,14457,14525,14591,14613,14631,14692,14696,14698,14725,14829,14842,14847,14848,14865,14911,14999,15038,15063,15076,15094,15111,15130,15149,15158,15171,15177,15187,15233,15244,15259,15270,15330,15346,15361,15368,15407,15418,15429,15469,15474,15487,15493,15497,15516,15565,15599,15635,15668,15748,15850,15863,15875,15937,15981,15987,16024,16043,16050,16056,16060,16062,16086,16090,16128,16129,16155,16168,16211,16281,16323,16338,16343,16359,16438,16446,16520,16522,16524,16547,16561,16564,16571,16626,16668,16671,16689,16717,16791,16795,16816,16827,16830,16840,16863,16949,16951,16976,16985,17002,17042,17067,17086,17138,17148,17184,17210,17222,17242,17253,17273,17282,17287,17318,17360,17389,17425,17490,17491,17500,17509,17539,17555,17572,17615,17618,17659,17701,17704,17713,17715,17727,17759,17778,17782,17818,17826,17853,17879,17893,17920,18022,18074,18079,18083,18173,18219,18220,18311,18352,18450,18562,18572,18646,18648,18671,18696,18718,18768,18866,18869,18880,18907,18911,18931,18945,18953,18968,18985,19000,19004,19014,19020,19060,19063,19064,19111,19139,19155,19163,19193,19217,19231,19233,19283,19297,19308,19407,19457,19475,19482,19558,19566,19583,19591,19617,19648,19718,19733,19747,19854,19918,19920,19930,20015,20018,20026,20098,20127,20134,20135,20179,20218,20289,20333,20361,20522,20556,20607,20615,20655,20664,20671,20681,20710,20729,20737,20779,20784,20794,20809,20889,20947,21002,21079,21126,21128,21166,21187,21223,21265,21270,21294,21323,21347,21372,21420,21475,21496,21510,21536,21555,21578,21661,21739,21757,21831,21874,21878,21879,21927,21950,21987,22011,22040,22089,22095,22146,22209,22238,22297,22306,22317,22347,22348,22359,22484,22553,22563,22571,22582,22619,22645,22656,22711,22753,22770,22775,22883,22909,22935,22948,22974,22976,23011,23076,23139,23148,23188,23207,23221,23242,23286,23398,23418,23430,23439,23456,23488,23525,23555,23562,23585,23602,23612,23761,23783,23819,23826,23840,23853,23856,23910,23936,23958,24034,24219,24220,24282,24326,24347,24364,24429,24451,24486,24526,24550,24558,24559,24576,24577,24668,24684,24723,24760,24849,24860,24863,24868,24872,24899,24941,24975,25070,25071,25081,25125,25134,25153,25174,25280,25294,25310,25332,25352,25374,25535,25567,25621,25653,25676,25696,25703,25717,25747,25785,25799,25921,25938,25947,26008,26030,26041,26043,26050,26173,26358,26367,26444,26522,26582,26583,26698,26765,26818,27002,27009,27024,27055,27079,27082,27101,27116,27218,27248,27283,27301,27318,27478,28075,28184,29014,29372,29378,29412,29438,29536,29617,29618,29697,31115,32676,35744,35871,35882,35899,35975,36154,36367,36402,36490,36583,36897,37345,38226,38237,38352,38850,38899,38991,39214,39286,39558,39580,39677,39737,39761,39801,39857,39892,40120,40203,40272,40351,40356,40375,40483,40594,40739,40773,40887,40973,41122,41217,41475,41636,41761,41826,42486,42563,42591,42680,42766,42944,43330,43569,43570,43571,43755,43856,43972,43973,44143,44160,44469,44843,44933,44998)
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 | 764 | 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.52 ms |
checking permissions | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.16 ms |
System lock | 0.03 ms |
optimizing | 0.06 ms |
statistics | 1.56 ms |
preparing | 0.96 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.34 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.05 ms |
freeing items | 0.09 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 |