Tiempo de la consulta: 4.81 ms Después de la última consulta: 0.95 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.320 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 17:46:58')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 17:46:58')
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(71,78,85,119,155,174,185,214,227,255,271,272,279,283,285,303,307,323,349,400,403,428,429,450,495,531,572,588,651,657,666,667,686,689,722,784,808,832,868,869,885,937,940,954,1029,1101,1102,1165,1170,1195,1212,1216,1233,1250,1278,1279,1322,1439,1458,1459,1469,1538,1648,1684,1715,1735,1745,1775,1846,1867,1881,1887,1968,1975,2016,2033,2061,2069,2101,2125,2233,2239,2254,2287,2309,2328,2402,2403,2471,2472,2517,2587,2605,2643,2647,2674,2720,2722,2743,2764,2765,2804,2842,2843,2851,2898,2954,2956,2967,3001,3065,3066,3106,3107,3129,3146,3154,3174,3183,3208,3253,3258,3303,3305,3312,3343,3346,3369,3402,3409,3412,3446,3454,3468,3473,3493,3523,3569,3577,3597,3609,3613,3618,3657,3663,3682,3750,3754,3774,3948,3952,3983,4068,4069,4088,4301,4451,4468,4492,4503,4577,4589,4745,4823,4988,5079,5093,5095,5113,5123,5162,5191,5214,5396,5461,5469,5478,5513,5536,5578,5581,5691,5857,5913,5972,6007,6056,6102,6120,6123,6178,6301,6315,6354,6363,6372,6400,6542,6543,6554,6593,6620,6639,6689,6709,6733,6759,6763,6766,6807,6808,6840,6876,6964,6997,7018,7026,7122,7246,7248,7456,7478,7491,7569,7583,7630,7720,7736,7749,7818,7841,7897,7917,7924,7953,8040,8046,8087,8088,8090,8116,8118,8206,8367,8538,8626,8674,8740,8864,8895,8907,8937,9029,9048,9056,9057,9078,9082,9087,9152,9200,9262,9314,9364,9369,9403,9658,9764,9825,9836,10059,10168,10190,10195,10273,10301,10462,10468,10475,10478,10489,10630,10717,10801,10973,11022,11059,11147,11195,11318,11410,11472,11788,11805,11840,11854,11991,12257,12401,12410,12505,12620,12625,12637,12708,12820,12875,13017,13029,13129,13166,13252,13294,13298,13489,13501,13524,13530,13548,13550,13573,13641,13671,13685,13687,13705,13706,13707,13712,13763,13821,13842,13855,13950,13975,14081,14092,14105,14129,14142,14148,14159,14188,14197,14261,14271,14273,14310,14320,14428,14456,14617,14646,14675,14711,14769,14856,14987,15004,15018,15030,15032,15037,15049,15127,15247,15248,15258,15324,15368,15382,15403,15424,15439,15492,15496,15542,15562,15575,15606,15717,15719,15728,15744,15794,15800,15897,15973,16140,16155,16160,16161,16178,16206,16218,16257,16262,16321,16325,16432,16473,16497,16521,16534,16543,16594,16603,16652,16657,16713,16733,16734,16808,16929,16936,17000,17014,17055,17086,17100,17134,17138,17140,17157,17172,17176,17197,17215,17242,17309,17347,17358,17361,17368,17432,17437,17539,17586,17596,17630,17659,17702,17737,17766,17767,17775,17818,17823,17831,17835,17883,17905,17938,17961,18036,18043,18112,18113,18129,18142,18157,18184,18192,18217,18295,18309,18316,18326,18327,18358,18376,18383,18384,18409,18419,18431,18442,18446,18498,18521,18543,18555,18577,18601,18612,18630,18682,18689,18717,18739,18763,18772,18826,18847,18848,18867,18901,18910,18934,18991,19022,19080,19083,19086,19105,19126,19133,19168,19171,19185,19207,19217,19223,19247,19274,19294,19301,19304,19306,19327,19332,19333,19366,19386,19396,19397,19442,19453,19465,19524,19567,19571,19604,19650,19653,19661,19693,19700,19729,19771,19773,19815,19828,19845,19855,19867,19871,19873,19932,19991,19994,20032,20033,20036,20086,20099,20103,20128,20151,20162,20163,20177,20183,20190,20198,20216,20312,20354,20374,20392,20440,20464,20471,20564,20578,20579,20649,20659,20698,20699,20717,20757,20760,20768,20778,20840,20852,20993,21029,21086,21096,21161,21165,21168,21178,21252,21317,21347,21369,21388,21397,21401,21405,21452,21516,21517,21522,21536,21593,21596,21606,21688,21709,21732,21750,21756,21787,21837,21846,21906,21912,21926,21988,22026,22033,22037,22040,22059,22097,22100,22180,22219,22229,22234,22244,22245,22246,22270,22276,22296,22385,22414,22489,22500,22502,22522,22527,22611,22689,22692,22720,22742,22744,22784,22805,22813,22829,22848,22874,22881,22895,22924,22960,22963,22991,22997,23016,23034,23040,23076,23081,23124,23133,23147,23156,23168,23198,23238,23245,23247,23256,23282,23300,23325,23388,23399,23402,23408,23485,23492,23565,23566,23567,23647,23654,23759,23763,23797,23799,23839,23857,23900,23922,23930,23955,23962,23967,24072,24076,24119,24141,24152,24174,24192,24242,24264,24277,24282,24288,24312,24342,24383,24398,24440,24450,24451,24472,24479,24498,24597,24601,24618,24624,24643,24697,24705,24747,24826,24865,24888,24891,24924,24943,24968,24979,24989,25048,25100,25126,25133,25222,25245,25309,25360,25413,25445,25535,25624,25631,25673,25787,25813,25816,25818,25940,25955,25968,26017,26034,26061,26122,26202,26261,26378,26410,26439,26447,26454,26471,26478,26570,26630,26640,26665,26679,26763,26766,26769,26770,26772,26779,26808,26825,26866,26871,26898,26910,26939,26992,26996,27024,27026,27071,27131,27138,27151,27162,27175,27180,27184,27186,27188,27197,27200,27210,27215,27322,27342,27351,27356,27412,27445,27455,27463,27475,27479,27490,27513,27520,27529,27545,27581,27619,27685,27738,27765,27854,27886,27913,27929,27965,27974,28002,28049,28305,28383,28409,28452,28625,28779,28845,28919,29013,29107,29187,29200,29242,30609,30854,31773,32241,33382,33437,33621,33950,34524,34584,34717,34758,34927,35144,35259,35305,35676,35718,35734,35798,35834,35861,35886,35922,35941,36188,36197,36399,36423,36737,37025,37158,38010,38021,38662,38784,38818,38865,38905,38962,39078,39226,39269,39296,39321,39673,39752,39764,39808,39823,40213,40584,40812,40902,40954,41254,41594,42074,42262,42344,43921,45191)
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 | 919 | 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.82 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.05 ms |
init | 0.27 ms |
System lock | 0.02 ms |
optimizing | 0.10 ms |
statistics | 1.59 ms |
preparing | 0.69 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.52 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.06 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 |