Tiempo de la consulta: 3.51 ms Después de la última consulta: 0.68 ms Consulta a la memoria: 0.072 MB memoria antes de la consulta: 4.463 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 15:39:25')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 15:39:25')
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(7,78,85,155,185,214,267,279,285,303,315,349,450,495,515,531,572,666,667,808,863,869,885,954,1065,1101,1102,1216,1278,1279,1321,1331,1431,1538,1648,1785,1846,1867,1945,2013,2072,2147,2198,2284,2285,2314,2328,2338,2376,2402,2473,2528,2647,2660,2695,2870,2894,2954,3054,3071,3106,3107,3174,3209,3236,3292,3329,3346,3369,3371,3402,3409,3412,3420,3442,3453,3454,3577,3663,3683,3961,4184,4231,4409,4503,4589,4823,4863,5021,5247,5396,5461,5478,5488,5536,5537,5565,5622,5628,5638,5648,5685,5686,5846,5857,5881,5886,5913,6056,6088,6120,6138,6178,6209,6260,6290,6307,6310,6465,6545,6550,6568,6577,6614,6639,6670,6876,6988,7012,7014,7122,7246,7266,7272,7275,7276,7287,7289,7336,7437,7471,7478,7554,7647,7678,7720,7736,7818,7841,7897,7924,7936,7938,7991,7998,8046,8047,8090,8116,8118,8352,8406,8449,8457,8543,8754,8760,8864,9029,9051,9075,9087,9107,9155,9195,9197,9204,9286,9364,9392,9404,9429,9800,9825,9836,9924,9965,10011,10068,10117,10134,10138,10167,10255,10402,10413,10475,10478,10486,10553,10630,10694,10801,11059,11231,11258,11371,11472,11697,11850,11899,11929,12221,12341,12401,12410,12440,12459,12617,12620,12625,12637,12708,12810,12835,12853,12875,12901,12902,12944,12945,13017,13145,13246,13294,13413,13530,13534,13544,13546,13557,13671,13687,13691,13697,13707,13742,13804,13842,13846,13853,13975,14074,14092,14105,14117,14122,14135,14142,14206,14271,14273,14329,14419,14435,14456,14464,14581,14595,14646,14698,14706,14759,14773,14925,14987,14992,15004,15030,15032,15037,15094,15247,15382,15403,15424,15439,15471,15492,15542,15562,15575,15717,15728,15757,15829,15935,16029,16140,16153,16161,16173,16206,16257,16373,16416,16458,16459,16497,16503,16526,16534,16543,16652,16657,16674,16836,16859,16889,16905,16929,16936,16981,17000,17058,17215,17273,17347,17358,17367,17376,17381,17432,17484,17596,17634,17659,17702,17757,17766,17818,17831,17840,17864,17895,17961,18267,18309,18316,18321,18326,18371,18384,18412,18419,18442,18488,18498,18543,18555,18561,18577,18602,18612,18639,18682,18689,18739,18847,18848,18869,18878,18901,18904,18910,18977,18991,18995,19022,19083,19086,19091,19105,19112,19132,19149,19171,19185,19207,19247,19274,19294,19304,19313,19350,19366,19386,19396,19442,19446,19453,19524,19567,19581,19595,19604,19608,19650,19655,19661,19684,19700,19867,19932,19983,19991,20030,20034,20036,20099,20103,20145,20162,20183,20199,20216,20354,20358,20374,20403,20440,20464,20578,20579,20638,20649,20659,20755,20768,20797,20826,20856,20950,21000,21118,21161,21178,21252,21305,21388,21433,21452,21458,21460,21464,21516,21522,21536,21546,21593,21709,21737,21780,21846,21906,21912,21952,21988,22059,22244,22245,22246,22435,22455,22500,22502,22517,22527,22632,22668,22715,22742,22744,22803,22805,22829,22874,22876,22895,22924,22963,23000,23022,23034,23060,23081,23124,23196,23200,23234,23247,23250,23256,23300,23408,23467,23516,23546,23559,23564,23565,23668,23691,23759,23763,23767,23839,23857,23900,23922,23930,23955,23962,23967,24047,24072,24075,24076,24111,24141,24174,24230,24264,24282,24392,24472,24523,24603,24616,24618,24624,24727,24788,24793,24823,24844,24888,24924,24943,24968,24979,24989,25003,25048,25100,25126,25245,25333,25360,25534,25624,25639,25673,25764,25798,25818,25955,26040,26093,26107,26122,26361,26410,26429,26454,26522,26665,26767,26772,26779,26800,26808,26816,26898,26910,26939,26992,26996,27024,27026,27131,27151,27186,27293,27326,27356,27363,27438,27452,27490,27520,27545,27738,27812,27891,28013,28452,28780,28845,29446,30594,31873,32250,32302,32381,32507,32552,32590,32843,32896,32943,33040,33042,33044,33129,33199,33649,33884,33885,33886,34078,34099,34109,34111,34179,34184,34229,34241,34258,34260,34269,34284,34292,34326,34343,34357,34667,34668,34669,34788,34892,34902,35126,35144,35195,35235,35472,35650,35663,35715,35943,36042,36043,36047,36095,36412,36721,36741,36880,37088,38097,38293,38411,38651,39142,39269,40213,40512,40575,40822,40850,40990,41742,43644,43652,44971)
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 | 686 | 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.39 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.14 ms |
preparing | 0.55 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.46 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.03 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 |