Tiempo de la consulta: 6.47 ms Después de la última consulta: 0.99 ms Consulta a la memoria: 0.408 MB memoria antes de la consulta: 4.372 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:39:41')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 13:39:41')
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(2,3,4,5,6,7,8,16,25,29,49,72,78,82,85,93,129,155,165,214,255,275,279,285,303,338,340,344,349,350,407,450,482,495,531,549,572,581,595,607,634,666,667,757,808,816,823,863,869,885,900,916,927,954,971,981,1015,1022,1046,1053,1056,1080,1101,1102,1140,1198,1207,1216,1235,1238,1278,1279,1304,1308,1363,1372,1504,1505,1519,1538,1648,1713,1800,1804,1812,1845,1846,1853,1854,1867,1944,2123,2210,2228,2260,2328,2337,2378,2392,2402,2468,2509,2566,2647,2688,2828,2884,2952,2954,2967,3067,3076,3106,3107,3174,3191,3208,3211,3258,3276,3291,3319,3353,3369,3373,3376,3402,3408,3409,3410,3412,3447,3454,3475,3577,3634,3663,3757,3871,3976,3985,3986,4131,4245,4383,4503,4515,4589,4651,4823,4832,4836,4910,4973,5018,5092,5136,5150,5224,5244,5247,5266,5298,5396,5461,5478,5536,5559,5798,5857,5894,5913,5943,5944,5973,6039,6055,6062,6120,6131,6178,6311,6330,6442,6542,6543,6571,6609,6616,6639,6645,6665,6711,6729,6742,6770,6775,6804,6809,6876,6881,6919,6945,6977,7001,7122,7235,7246,7249,7271,7330,7458,7466,7478,7482,7500,7584,7585,7624,7711,7718,7720,7736,7806,7810,7818,7819,7837,7841,7866,7897,7913,7924,7933,7950,7999,8000,8046,8085,8088,8090,8114,8116,8118,8187,8222,8227,8250,8354,8416,8499,8532,8603,8706,8759,8764,8861,8864,8964,9010,9012,9018,9029,9087,9237,9239,9308,9364,9398,9481,9552,9745,9823,9836,9864,9920,10100,10110,10120,10260,10301,10304,10475,10478,10598,10604,10630,10686,10713,10764,10769,10801,10912,11059,11076,11113,11138,11146,11424,11438,11472,11730,12035,12113,12212,12216,12218,12224,12393,12401,12410,12437,12481,12548,12576,12620,12625,12637,12669,12684,12708,12758,12761,12852,12875,12902,12959,13017,13115,13188,13294,13298,13433,13474,13685,13687,13693,13707,13727,13731,13734,13748,13750,13782,13842,13858,13869,13924,13941,13947,13975,13994,14005,14070,14092,14101,14105,14140,14142,14204,14227,14229,14249,14270,14271,14273,14305,14331,14341,14456,14482,14495,14522,14646,14648,14663,14669,14688,14703,14709,14726,14744,14746,14762,14790,14807,14846,14849,14865,14905,14911,14931,14949,14970,14981,14987,14992,14993,15004,15020,15030,15032,15037,15069,15100,15195,15247,15262,15293,15298,15304,15365,15366,15382,15403,15414,15424,15439,15450,15455,15456,15492,15518,15522,15542,15543,15562,15575,15594,15689,15717,15728,15751,15753,15785,15931,16115,16122,16140,16157,16161,16163,16206,16209,16257,16358,16422,16451,16497,16499,16534,16543,16604,16645,16652,16657,16685,16705,16787,16823,16862,16894,16929,16936,16984,17000,17090,17101,17105,17132,17146,17166,17215,17296,17314,17347,17353,17358,17405,17407,17432,17518,17530,17531,17537,17551,17596,17635,17659,17702,17753,17766,17818,17831,17839,17857,17862,17880,17883,17925,17961,18000,18022,18024,18032,18071,18227,18242,18304,18309,18311,18316,18326,18364,18375,18377,18384,18390,18419,18442,18498,18524,18543,18555,18577,18583,18595,18612,18682,18689,18739,18793,18847,18848,18882,18901,18910,18912,18927,18929,18952,18991,19022,19043,19083,19086,19105,19119,19133,19147,19171,19185,19207,19211,19235,19236,19245,19247,19268,19274,19294,19304,19366,19386,19396,19442,19453,19472,19507,19524,19567,19604,19650,19661,19700,19706,19723,19758,19764,19867,19880,19913,19932,19980,19988,19991,20016,20036,20066,20099,20103,20162,20183,20216,20223,20318,20354,20355,20374,20376,20396,20402,20429,20440,20464,20488,20578,20579,20586,20614,20649,20656,20659,20662,20665,20705,20764,20768,20807,20820,20838,20852,20878,20922,20941,20967,21046,21161,21178,21198,21226,21240,21252,21255,21388,21447,21452,21502,21516,21522,21536,21598,21605,21709,21718,21719,21850,21866,21906,21912,21932,21988,22059,22123,22129,22198,22207,22244,22245,22246,22256,22419,22494,22500,22502,22509,22527,22659,22732,22741,22742,22744,22745,22750,22761,22805,22829,22850,22851,22856,22874,22895,22924,22963,23034,23078,23081,23100,23124,23130,23173,23184,23213,23256,23259,23273,23287,23300,23313,23408,23479,23493,23565,23649,23720,23759,23763,23767,23831,23839,23857,23887,23900,23922,23930,23955,23962,23964,23967,24027,24043,24062,24072,24076,24077,24141,24153,24174,24185,24199,24200,24208,24247,24264,24281,24282,24286,24316,24322,24334,24337,24399,24406,24463,24472,24485,24497,24534,24539,24618,24624,24695,24737,24743,24788,24888,24899,24906,24924,24943,24951,24952,24956,24968,24979,24989,25004,25048,25100,25123,25126,25135,25152,25178,25212,25245,25318,25360,25397,25415,25460,25624,25648,25673,25709,25734,25747,25771,25800,25817,25818,25955,26113,26122,26153,26164,26187,26221,26288,26296,26386,26388,26454,26620,26630,26665,26760,26772,26779,26808,26815,26818,26820,26873,26898,26910,26916,26933,26935,26939,26944,26964,26996,27024,27026,27103,27108,27109,27131,27137,27138,27151,27186,27192,27196,27209,27212,27216,27242,27252,27268,27269,27270,27298,27307,27323,27356,27367,27487,27490,27520,27545,27592,27595,27717,27738,27786,27790,27923,27949,27968,28005,28031,28059,28066,28075,28094,28097,28120,28129,28237,28243,28313,28435,28452,28548,28553,28557,28563,28575,28581,28630,28845,28918,28995,29045,29152,29166,29226,29229,29272,29319,29382,29626,29694,29695,29711,29716,30525,31735,31820,32767,32768,34646,34811,35100,35144,35191,35232,35238,35239,35250,35289,35295,35345,35365,35376,35397,35540,35554,35621,35641,35744,35808,35948,36015,36220,36254,36368,36373,36380,36385,36386,36441,36469,36772,36790,36791,36792,36793,36849,36941,36960,36984,37015,37104,37155,37245,37307,37370,37473,37508,37643,37644,37757,37780,37834,37876,37902,37979,38058,38251,38330,38402,38418,38520,38617,38673,38681,38723,38734,38821,38829,38965,39039,39110,39133,39137,39153,39199,39244,39269,39290,39293,39297,39460,39470,39519,39558,39718,39837,39856,40059,40213,40275,40319,40560,40576,40813,40855,40896,40922,40951,41004,41009,41033,41123,41152,41172,41176,41189,41198,41201,41212,41225,41272,41289,41328,41339,41343,41415,41434,41479,41504,41519,41550,41571,41591,41623,41637,41737,41757,41783,41862,41881,41928,41948,41964,41965,41980,42246,42329,42482,42682,42736,42811,42941,43043,43093,43104,43117,43167,43221,43240,43241,43326,43375,43446,43461,43475,43477,43517,43518,43792,44122,44186,44187,44378,44581,44632,44640,44656,44718,44735,44788,44807,44829,44873,44881,44912,44935,44936,45174,45175,45223,45249,45274,45300,45313)
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 | 1089 | 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.60 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.21 ms |
System lock | 0.02 ms |
optimizing | 0.08 ms |
statistics | 1.60 ms |
preparing | 0.83 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 1.80 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 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 |