Tiempo de la consulta: 3.81 ms Después de la última consulta: 0.53 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.165 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-03 21:38:37')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-03 21:38:37')
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(69,78,85,155,156,157,158,159,174,214,232,271,275,279,285,303,349,450,495,531,558,572,664,666,667,670,686,697,756,757,808,863,869,885,892,954,1101,1102,1216,1226,1278,1279,1538,1648,1846,1867,1941,2052,2328,2398,2402,2647,2688,2837,2954,3020,3049,3069,3106,3107,3158,3174,3329,3361,3369,3402,3409,3412,3454,3577,3663,3999,4145,4186,4195,4197,4220,4221,4229,4241,4242,4266,4313,4361,4387,4390,4503,4527,4589,4623,4710,4803,4823,5087,5182,5396,5461,5478,5498,5536,5730,5857,5913,6120,6178,6639,6669,6876,7122,7246,7361,7365,7478,7555,7667,7703,7720,7736,7818,7841,7886,7897,7924,7938,8046,8090,8116,8118,8203,8385,8463,8508,8523,8531,8680,8688,8716,8864,9029,9045,9087,9299,9318,9333,9359,9364,9442,9451,9457,9543,9547,9710,9774,9836,10096,10218,10238,10414,10475,10478,10610,10630,10686,10801,11059,11095,11230,11472,11494,11644,11691,11711,12076,12148,12401,12410,12486,12620,12625,12637,12693,12708,12875,12909,12992,13017,13021,13261,13294,13298,13481,13638,13671,13687,13707,13842,13975,14092,14105,14142,14150,14205,14271,14273,14397,14456,14485,14526,14646,14923,14987,15004,15030,15032,15037,15049,15061,15247,15312,15382,15403,15424,15439,15492,15542,15562,15575,15712,15717,15728,15881,15972,15977,15981,16025,16140,16161,16206,16232,16250,16257,16302,16327,16453,16497,16534,16543,16652,16657,16928,16929,16936,17000,17215,17265,17281,17347,17358,17432,17476,17505,17596,17615,17633,17659,17666,17702,17766,17772,17818,17831,17920,17961,18108,18164,18309,18311,18316,18326,18339,18384,18408,18414,18419,18442,18446,18498,18543,18547,18555,18577,18612,18636,18682,18689,18739,18805,18839,18847,18848,18901,18910,18955,18991,19021,19022,19055,19077,19083,19086,19105,19120,19171,19185,19207,19247,19261,19274,19280,19294,19303,19304,19346,19366,19386,19396,19443,19453,19493,19524,19567,19604,19650,19661,19700,19756,19811,19867,19896,19932,19991,20036,20099,20103,20162,20183,20216,20333,20344,20354,20374,20440,20464,20537,20542,20559,20578,20579,20587,20609,20620,20633,20649,20659,20729,20768,20915,21064,21161,21178,21252,21268,21287,21350,21388,21452,21516,21522,21536,21655,21709,21831,21894,21904,21906,21912,21988,22030,22053,22059,22060,22159,22244,22245,22246,22359,22389,22500,22502,22509,22527,22550,22711,22742,22744,22804,22805,22820,22827,22829,22874,22895,22924,22963,23022,23034,23081,23124,23150,23222,23256,23300,23408,23438,23458,23478,23495,23565,23596,23616,23716,23719,23721,23759,23760,23763,23839,23857,23900,23922,23930,23949,23955,23962,23967,23991,24072,24076,24141,24174,24264,24282,24373,24472,24573,24618,24624,24759,24804,24888,24924,24943,24968,24979,24989,25048,25100,25126,25245,25270,25360,25386,25420,25443,25624,25673,25699,25724,25789,25818,25884,25901,25955,26065,26122,26222,26247,26453,26454,26456,26665,26725,26772,26779,26808,26814,26898,26910,26939,26996,27008,27022,27024,27026,27058,27076,27085,27089,27131,27151,27186,27356,27490,27520,27545,27609,27670,27710,27738,27811,28300,28403,28452,28497,28845,29473,29835,32874,35144,36454,38646,38847,38850,38857,38865,38867,38884,38899,39049,39144,39269,39385,40213,40258,40797,41048,41164,41399,42877,42878,43855)
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 | 551 | 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.35 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.07 ms |
init | 0.27 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.22 ms |
preparing | 0.52 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.63 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.05 ms |
cleaning up | 0.04 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 |