Tiempo de la consulta: 17.20 ms Después de la última consulta: 0.70 ms Consulta a la memoria: 1.487 MB memoria antes de la consulta: 4.314 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 13:20:45')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 13:20:45')
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(62,78,85,150,155,163,174,214,279,285,303,349,357,450,495,530,531,572,666,667,808,863,869,885,954,1101,1102,1182,1216,1278,1279,1289,1346,1538,1648,1751,1846,1867,1919,2188,2328,2392,2402,2463,2647,2954,3036,3055,3106,3107,3109,3174,3180,3280,3364,3369,3402,3409,3412,3451,3454,3461,3571,3577,3663,4004,4166,4319,4476,4503,4589,4699,4713,4767,4823,4863,5161,5247,5351,5396,5439,5461,5478,5536,5608,5613,5819,5857,5881,5913,6120,6178,6331,6415,6435,6463,6465,6472,6475,6476,6477,6548,6597,6639,6643,6684,6806,6876,6888,6889,6939,7013,7014,7122,7246,7272,7439,7478,7720,7736,7818,7841,7897,7923,7924,7981,7994,8046,8061,8090,8116,8118,8158,8220,8460,8565,8655,8704,8796,8864,8945,9029,9087,9153,9364,9401,9434,9438,9529,9554,9688,9773,9836,9924,10073,10232,10307,10322,10475,10478,10497,10630,10694,10783,10801,10958,11059,11258,11267,11348,11402,11446,11472,11490,11563,11788,11865,11929,11964,12218,12331,12401,12410,12463,12474,12560,12620,12622,12625,12637,12686,12708,12810,12853,12875,12901,13017,13294,13298,13497,13528,13646,13671,13676,13687,13697,13707,13723,13742,13804,13842,13963,13975,13990,14074,14082,14092,14105,14117,14142,14167,14244,14262,14267,14271,14273,14440,14450,14456,14507,14513,14646,14657,14678,14683,14684,14794,14893,14923,14964,14983,14987,15004,15030,15032,15037,15048,15094,15104,15108,15111,15129,15139,15167,15206,15213,15243,15245,15247,15266,15301,15370,15382,15403,15411,15424,15439,15471,15492,15542,15548,15562,15574,15575,15699,15712,15717,15725,15728,15757,15782,15848,15866,15935,15955,16000,16092,16093,16110,16140,16153,16161,16206,16257,16326,16374,16382,16458,16497,16507,16543,16545,16573,16587,16619,16625,16648,16652,16657,16664,16810,16832,16838,16858,16889,16929,16936,16981,17000,17037,17125,17128,17215,17244,17257,17273,17307,17323,17337,17347,17358,17381,17382,17401,17432,17435,17465,17472,17541,17596,17626,17634,17659,17702,17733,17757,17766,17818,17831,17840,17854,17895,17961,17980,18031,18034,18140,18198,18309,18316,18326,18369,18384,18419,18442,18498,18543,18555,18561,18577,18612,18649,18659,18682,18689,18697,18739,18769,18805,18847,18848,18869,18901,18910,18920,18927,18930,18942,18977,18982,18991,18995,19000,19022,19083,19086,19091,19105,19108,19110,19132,19136,19139,19149,19171,19185,19207,19219,19237,19240,19247,19270,19274,19294,19304,19366,19386,19396,19442,19453,19497,19524,19535,19541,19567,19595,19604,19608,19650,19661,19681,19684,19699,19700,19718,19739,19815,19839,19867,19894,19915,19930,19932,19941,19983,19991,20007,20034,20036,20069,20097,20099,20103,20145,20162,20183,20199,20216,20295,20303,20344,20354,20363,20374,20403,20440,20446,20464,20536,20578,20579,20621,20636,20638,20649,20659,20768,20786,20826,20848,20856,20950,21000,21118,21161,21178,21213,21228,21242,21252,21268,21305,21323,21365,21388,21430,21431,21433,21452,21458,21464,21472,21516,21522,21536,21539,21546,21586,21676,21709,21711,21714,21737,21748,21751,21819,21871,21906,21912,21922,21952,21988,22045,22059,22100,22244,22245,22246,22258,22385,22419,22422,22435,22455,22483,22492,22500,22502,22527,22550,22552,22563,22572,22612,22668,22673,22708,22715,22738,22742,22744,22803,22805,22829,22868,22874,22895,22913,22924,22963,23000,23022,23034,23081,23097,23122,23124,23148,23219,23247,23256,23286,23300,23344,23375,23408,23451,23467,23546,23559,23564,23565,23664,23668,23677,23691,23703,23759,23763,23765,23772,23814,23839,23845,23857,23874,23889,23900,23922,23930,23941,23955,23959,23962,23967,23984,24010,24014,24024,24072,24075,24076,24111,24117,24141,24174,24178,24230,24260,24264,24282,24311,24346,24472,24513,24523,24555,24607,24616,24618,24624,24673,24686,24722,24745,24765,24788,24823,24857,24888,24907,24924,24943,24960,24968,24979,24989,25003,25048,25067,25070,25071,25100,25108,25115,25126,25245,25273,25349,25360,25373,25374,25421,25543,25624,25673,25678,25764,25798,25818,25823,25917,25925,25955,25987,26105,26107,26122,26135,26162,26176,26306,26454,26522,26540,26564,26665,26772,26779,26808,26816,26898,26910,26926,26939,26982,26996,27024,27026,27121,27131,27151,27186,27221,27251,27356,27452,27482,27490,27491,27506,27520,27545,27558,27572,27593,27738,27777,28005,28397,28424,28452,28605,28720,28763,28780,28824,28845,28944,29021,29089,29124,29143,29244,29256,29358,29369,29557,29617,29810,29890,29919,29930,31227,31499,31516,33254,33815,34729,34951,35040,35144,36157,36822,36893,36916,36918,37315,37380,37874,37996,38056,38066,38361,38455,38734,38775,38812,38960,39269,39307,39358,39452,39504,39516,39966,40009,40169,40213,40312,40313,40314,40360,40491,40542,40796,40801,40838,41036,41063,41402,41423,41811,41885,42460,42489,43680,43705,43706,43707,43914,43915,43917,44031,44041,44497,44681,45115,45160,45206,45252)
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 | 811 | 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.43 ms |
checking permissions | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.05 ms |
init | 0.20 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 1.46 ms |
preparing | 0.90 ms |
Sorting result | 0.04 ms |
executing | 0.01 ms |
Sending data | 13.34 ms |
end | 0.01 ms |
query end | 0.05 ms |
closing tables | 0.05 ms |
freeing items | 0.06 ms |
cleaning up | 0.10 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 |