Tiempo de la consulta: 15.22 ms Después de la última consulta: 0.70 ms Consulta a la memoria: 1.455 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-05 02:31:13')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 02:31:13')
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,12,13,14,15,16,17,18,46,57,87,90,92,99,110,126,129,149,173,189,215,221,224,232,243,244,245,246,249,252,276,309,328,330,337,412,417,418,425,427,433,468,495,510,521,528,548,553,555,578,583,595,596,597,603,613,618,641,646,647,662,667,705,711,723,724,730,781,787,800,818,823,825,837,838,860,966,994,1010,1023,1053,1065,1066,1072,1082,1114,1128,1136,1145,1213,1235,1264,1268,1272,1274,1275,1276,1277,1278,1299,1314,1325,1340,1370,1389,1390,1412,1422,1431,1458,1462,1480,1504,1550,1628,1665,1678,1685,1706,1788,1828,1833,1835,1859,1872,1939,1960,1961,2012,2036,2056,2087,2093,2162,2166,2185,2193,2204,2289,2303,2355,2435,2541,2559,2560,2638,2652,2681,2724,2750,2786,2811,2812,2852,2946,3011,3017,3032,3167,3181,3190,3228,3269,3329,3346,3368,3373,3491,3512,3557,3727,3743,3772,3818,3868,3970,3991,4189,4191,4334,4360,4390,4457,4508,4608,4609,4640,4649,4680,4701,4724,4767,4793,4820,4845,4920,4948,4983,5007,5011,5033,5135,5324,5357,5392,5397,5417,5477,5495,5517,5582,5604,5637,5646,5678,5702,5719,5730,5732,5759,5768,5777,5779,5780,5793,5794,5795,5804,5829,5831,5839,5889,5899,5910,5919,5923,5942,5960,5999,6000,6002,6016,6022,6044,6060,6068,6160,6194,6207,6220,6258,6261,6277,6293,6312,6352,6368,6377,6391,6401,6420,6449,6460,6462,6476,6477,6495,6564,6587,6623,6628,6629,6636,6677,6728,6745,6774,6805,6846,6908,6935,6986,6995,7048,7057,7123,7135,7176,7195,7248,7258,7391,7439,7473,7492,7516,7553,7570,7576,7606,7687,7697,7738,7744,7760,7761,7788,7853,7872,7875,7936,7980,8009,8030,8064,8074,8078,8081,8178,8192,8215,8218,8232,8273,8316,8374,8436,8437,8461,8465,8487,8495,8566,8589,8637,8650,8672,8707,8815,8858,8861,8895,8909,8911,8969,9008,9081,9082,9121,9174,9175,9182,9186,9191,9237,9277,9362,9380,9394,9424,9572,9663,9697,9701,9711,9745,9781,9859,10019,10042,10093,10258,10385,10386,10572,11031,11054,11100,11131,11264,11271,11411,11645,11682,11697,11718,11789,11808,11842,11950,11953,11970,12055,12086,12130,12140,12206,12237,12259,12296,12369,12383,12439,12692,12761,12788,12833,12916,12931,12974,13013,13030,13037,13057,13062,13130,13228,13246,13274,13275,13285,13346,13351,13456,13459,13498,13501,13556,13601,13631,13702,13772,13842,13860,14015,14152,14177,14184,14279,14341,14376,14389,14428,14479,14493,14501,14539,14619,14651,14683,14728,14754,14914,14927,14931,14951,14957,14969,14977,14978,15024,15107,15111,15150,15219,15220,15263,15272,15354,15389,15464,15470,15490,15496,15576,15667,15745,15837,15913,15934,15973,15978,16046,16122,16298,16336,16364,16434,16551,16588,16623,16648,16658,16670,16737,16803,16995,17010,17058,17091,17106,17170,17172,17294,17359,17380,17389,17484,17562,17580,17615,17629,17663,17680,17727,17736,17885,17976,17977,17995,18035,18036,18060,18096,18113,18118,18162,18183,18240,18253,18273,18308,18311,18402,18413,18459,18491,18497,18500,18516,18524,18545,18566,18575,18603,18635,18673,18712,18728,18729,18751,18756,18779,18802,18828,18868,18874,18918,18959,18982,19005,19038,19267,19288,19299,19307,19310,19355,19475,19568,19587,19625,19632,19697,19824,19939,19986,20017,20073,20150,20176,20180,20211,20212,20213,20264,20277,20290,20307,20349,20410,20423,20557,20709,20725,20756,20790,20853,20978,21187,21189,21224,21237,21252,21257,21270,21273,21371,21436,21466,21517,21633,21733,21765,21820,21830,21903,22043,22091,22127,22169,22189,22349,22479,22564,22574,22649,22700,22705,22714,22763,22785,22789,22920,22955,22996,23017,23055,23085,23373,23448,23511,23518,23533,23546,23575,23605,23613,23770,23847,23901,23945,24030,24127,24156,24191,24245,24288,24293,24341,24394,24402,24410,24476,24502,24563,24635,24697,24806,24814,24856,24865,24878,24883,24886,24943,24967,24973,24994,25010,25030,25147,25162,25382,25453,25738,25839,25896,25955,26023,26062,26159,26166,26302,26425,26457,26471,26473,26588,26655,26875,26920,26954,26983,26992,26999,27117,27135,27326,27345,27409,27420,27432,27461,27483,27512,27556,27655,27776,27805,27904,28248,28416,28418,28536,28682,28695,28720,28735,28786,28866,28907,28908,28965,29004,29005,29020,29135,29153,29328,29354,29372,29871,29907,29935,30470,30696,31064,31389,32339,33795,33897,34007,35077,35368,35646,35713,35733,35769,36053,36242,36251,36319,36601,36655,36856,37594,37892,38279,38341,38381,38489,38760,39782,39917,40199,40300,40319,40492,40635,41494,41962,42600,42631,42671,42700,43456,43498,43878,43910,44814,45173)
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 | 792 | 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.44 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.16 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 1.21 ms |
preparing | 0.59 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 11.75 ms |
end | 0.03 ms |
query end | 0.04 ms |
closing tables | 0.03 ms |
freeing items | 0.08 ms |
cleaning up | 0.05 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 |