Tiempo de la consulta: 11.08 ms Después de la última consulta: 0.69 ms Consulta a la memoria: 1.455 MB memoria antes de la consulta: 4.306 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-06 11:03:49')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 11:03: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(78,85,110,155,173,174,214,232,252,279,285,303,349,353,354,361,376,414,425,450,495,510,531,545,572,581,618,666,667,706,707,787,808,825,837,860,863,869,885,954,966,1010,1033,1053,1065,1080,1082,1101,1102,1128,1136,1148,1213,1216,1235,1278,1279,1298,1299,1340,1370,1422,1431,1480,1538,1550,1628,1648,1678,1706,1788,1833,1835,1846,1867,1872,1939,2036,2087,2093,2162,2166,2193,2204,2289,2303,2328,2402,2410,2435,2559,2560,2647,2652,2681,2688,2786,2812,2954,3011,3032,3106,3107,3167,3174,3190,3228,3329,3361,3368,3369,3373,3402,3409,3412,3454,3577,3663,3772,3818,4189,4191,4361,4390,4503,4508,4527,4589,4608,4609,4623,4767,4785,4823,4845,4948,4983,5011,5033,5087,5135,5324,5396,5397,5461,5477,5478,5517,5536,5604,5719,5829,5857,5913,6044,6120,6147,6178,6207,6277,6293,6352,6368,6460,6462,6628,6629,6636,6639,6728,6805,6876,6908,6935,7122,7123,7132,7135,7176,7246,7304,7439,7478,7553,7570,7667,7703,7720,7736,7744,7818,7841,7886,7897,7924,8046,8090,8116,8118,8203,8232,8502,8523,8688,8764,8858,8864,9008,9029,9081,9087,9191,9318,9359,9364,9452,9457,9710,9836,9859,10019,10042,10093,10096,10218,10364,10414,10475,10478,10610,10630,10801,11054,11059,11095,11178,11230,11404,11472,11789,11808,11950,11967,11970,12012,12076,12086,12140,12148,12224,12237,12259,12401,12410,12620,12625,12637,12688,12708,12760,12761,12875,12916,12925,13017,13057,13187,13189,13228,13261,13274,13275,13294,13298,13346,13501,13534,13649,13671,13687,13707,13842,13975,14092,14105,14142,14150,14152,14271,14273,14279,14389,14397,14456,14479,14485,14493,14539,14619,14646,14683,14728,14754,14927,14931,14977,14987,15004,15024,15030,15032,15037,15107,15111,15114,15150,15197,15219,15220,15247,15306,15312,15315,15354,15382,15403,15424,15439,15492,15495,15496,15542,15562,15575,15717,15728,15745,15934,15978,16025,16140,16161,16206,16257,16298,16364,16497,16534,16543,16551,16564,16623,16652,16657,16658,16670,16803,16907,16929,16936,17000,17010,17046,17090,17091,17106,17170,17215,17347,17358,17432,17476,17501,17542,17580,17596,17615,17659,17663,17702,17727,17736,17766,17818,17831,17885,17920,17961,17995,18060,18096,18108,18113,18162,18309,18316,18326,18384,18402,18419,18442,18446,18459,18498,18516,18543,18547,18555,18566,18577,18612,18682,18689,18712,18728,18739,18825,18847,18848,18850,18901,18910,18944,18955,18959,18982,18991,19005,19018,19022,19055,19083,19086,19105,19171,19185,19207,19247,19261,19274,19294,19304,19366,19386,19396,19442,19453,19493,19524,19567,19604,19624,19632,19650,19661,19700,19768,19867,19896,19898,19932,19938,19986,19991,20020,20036,20088,20099,20103,20162,20180,20183,20216,20264,20344,20350,20354,20374,20423,20440,20464,20557,20578,20579,20620,20633,20649,20659,20756,20768,20803,20919,20978,21064,21161,21178,21187,21189,21224,21252,21257,21270,21371,21388,21452,21516,21520,21522,21536,21556,21633,21655,21709,21765,21830,21906,21912,21988,22043,22053,22059,22060,22091,22127,22169,22189,22244,22245,22246,22389,22500,22502,22527,22550,22649,22700,22713,22742,22744,22763,22785,22789,22805,22829,22874,22895,22900,22920,22924,22963,22996,23034,23055,23081,23124,23150,23256,23300,23373,23408,23448,23478,23492,23518,23546,23565,23575,23605,23759,23763,23839,23857,23900,23921,23922,23930,23955,23962,23967,24030,24072,24076,24141,24174,24176,24191,24241,24264,24282,24293,24341,24394,24402,24472,24618,24624,24635,24806,24814,24832,24855,24856,24883,24888,24924,24950,24968,24979,24989,25010,25048,25100,25126,25162,25245,25360,25382,25624,25673,25789,25818,25839,25901,25955,26023,26065,26099,26122,26159,26222,26247,26425,26454,26456,26494,26655,26665,26772,26779,26808,26898,26910,26939,26983,26992,26996,27008,27024,27026,27117,27131,27151,27186,27220,27326,27356,27420,27490,27520,27545,27609,27655,27738,28120,28403,28452,28639,28682,28695,28735,28844,28845,28847,28866,28907,28908,29135,29372,29473,30470,31064,32058,33795,33897,35077,35144,35646,35713,35733,36053,36251,36454,36601,36655,36856,37594,37892,38279,38341,38381,38646,38760,39269,40213,40300,40319,40492,40635,41164,41962,42600,42631,42671,42700,42877,42878,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 | 722 | 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.37 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
init | 0.16 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 1.15 ms |
preparing | 0.56 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 8.14 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.07 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 |