Tiempo de la consulta: 4.30 ms Después de la última consulta: 1.54 ms Consulta a la memoria: 0.072 MB memoria antes de la consulta: 4.513 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 23:24:14')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 23:24:14')
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(11,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,78,81,85,87,88,89,110,111,125,155,188,189,190,200,205,214,217,234,246,248,249,263,271,279,285,303,325,349,353,362,412,415,416,420,421,422,423,424,426,427,429,431,450,484,495,496,501,503,531,572,574,575,593,666,667,686,737,785,808,853,862,863,868,869,885,954,986,1101,1102,1200,1207,1210,1216,1223,1278,1279,1342,1343,1353,1357,1434,1538,1648,1691,1718,1846,1867,1878,2013,2108,2208,2272,2328,2402,2433,2595,2647,2667,2717,2825,2954,3020,3051,3054,3106,3107,3174,3212,3325,3369,3402,3409,3412,3454,3577,3650,3663,3682,4310,4409,4503,4589,4674,4816,4823,4863,4902,4905,5060,5189,5247,5291,5324,5371,5392,5396,5446,5449,5461,5476,5478,5511,5536,5538,5622,5631,5685,5686,5798,5799,5847,5857,5870,5881,5886,5895,5913,6056,6088,6120,6121,6178,6257,6311,6392,6420,6437,6465,6478,6482,6498,6545,6616,6639,6666,6671,6776,6802,6836,6856,6868,6876,6948,6988,7014,7017,7050,7056,7109,7122,7124,7138,7192,7210,7243,7246,7272,7275,7276,7287,7328,7336,7374,7437,7450,7478,7692,7716,7720,7730,7736,7782,7811,7818,7841,7897,7924,7933,7967,7970,7993,8027,8046,8090,8116,8118,8215,8360,8382,8442,8444,8457,8533,8565,8589,8602,8610,8638,8760,8835,8846,8856,8864,8887,9029,9087,9120,9191,9204,9206,9219,9262,9282,9298,9364,9411,9428,9429,9472,9650,9658,9677,9678,9682,9761,9806,9836,9924,10035,10274,10475,10478,10548,10553,10630,10694,10801,10964,11059,11258,11345,11472,11547,11632,11899,11929,12012,12020,12324,12401,12410,12428,12460,12617,12620,12622,12625,12633,12637,12650,12670,12685,12686,12708,12768,12810,12853,12875,12901,12913,12944,12973,12996,13012,13014,13016,13017,13032,13152,13216,13246,13276,13277,13298,13348,13474,13475,13671,13687,13697,13707,13735,13742,13804,13842,13900,13971,13973,13975,14005,14074,14092,14105,14117,14142,14203,14229,14243,14271,14273,14293,14362,14399,14404,14447,14456,14500,14534,14536,14554,14564,14592,14646,14698,14759,14860,14942,14987,14992,15004,15030,15032,15037,15038,15043,15094,15245,15247,15261,15293,15372,15382,15403,15414,15424,15439,15471,15475,15476,15492,15520,15533,15542,15562,15574,15575,15657,15711,15717,15728,15756,15757,15796,15829,15856,15861,15935,15945,15948,15972,16055,16062,16071,16115,16140,16153,16161,16176,16206,16257,16373,16425,16458,16459,16488,16497,16508,16526,16534,16543,16566,16652,16657,16751,16833,16872,16889,16891,16908,16929,16936,16950,16976,16981,17000,17091,17114,17215,17273,17309,17331,17334,17335,17347,17358,17381,17419,17432,17484,17496,17528,17596,17607,17629,17634,17659,17702,17721,17757,17766,17818,17831,17840,17857,17862,17864,17895,17961,18021,18060,18071,18073,18220,18260,18267,18300,18309,18316,18326,18360,18384,18419,18442,18465,18498,18511,18543,18555,18558,18561,18577,18578,18612,18682,18689,18739,18757,18784,18819,18843,18847,18848,18869,18901,18904,18910,18977,18991,18995,18999,19022,19039,19083,19086,19091,19105,19112,19132,19149,19171,19185,19207,19247,19274,19282,19294,19304,19313,19350,19366,19381,19386,19396,19442,19446,19453,19460,19524,19545,19551,19567,19581,19595,19604,19608,19650,19655,19661,19668,19684,19695,19700,19733,19772,19811,19825,19867,19886,19923,19931,19932,19937,19980,19983,19991,20026,20030,20034,20036,20053,20058,20060,20095,20099,20103,20145,20162,20183,20192,20193,20199,20213,20216,20287,20296,20308,20354,20358,20374,20403,20439,20440,20459,20464,20567,20578,20579,20595,20616,20638,20648,20649,20659,20699,20700,20727,20755,20768,20797,20826,20847,20856,20950,20969,20983,20987,21000,21016,21038,21118,21148,21159,21161,21178,21180,21202,21252,21256,21279,21283,21285,21288,21300,21305,21334,21338,21368,21388,21421,21433,21452,21458,21464,21485,21486,21516,21521,21522,21524,21526,21529,21536,21546,21593,21618,21623,21650,21661,21664,21690,21695,21704,21709,21711,21719,21727,21737,21782,21800,21824,21841,21843,21850,21906,21910,21912,21952,21954,21955,21956,21971,21988,22015,22018,22059,22062,22077,22117,22163,22164,22195,22241,22244,22245,22246,22302,22324,22406,22421,22435,22446,22453,22455,22500,22502,22512,22517,22527,22580,22603,22620,22622,22626,22655,22658,22668,22710,22715,22727,22742,22744,22765,22780,22787,22803,22804,22805,22829,22833,22841,22874,22895,22897,22923,22924,22947,22963,22972,23000,23007,23022,23024,23034,23043,23060,23062,23081,23082,23089,23124,23144,23179,23196,23200,23214,23234,23247,23250,23256,23300,23344,23408,23467,23480,23516,23528,23546,23559,23564,23565,23620,23665,23668,23691,23711,23716,23759,23763,23767,23833,23839,23857,23859,23900,23922,23927,23930,23955,23962,23967,23974,23982,24016,24051,24072,24075,24076,24111,24141,24174,24226,24230,24249,24264,24282,24392,24393,24408,24457,24472,24475,24522,24523,24582,24616,24617,24618,24624,24727,24788,24803,24823,24844,24888,24924,24937,24943,24956,24968,24979,24989,24993,25003,25030,25035,25048,25062,25100,25126,25131,25138,25171,25245,25318,25333,25351,25360,25406,25436,25448,25534,25542,25584,25624,25639,25646,25648,25660,25673,25764,25798,25818,25904,25955,26000,26033,26107,26122,26147,26219,26221,26317,26318,26343,26360,26361,26415,26424,26454,26474,26522,26630,26651,26665,26673,26677,26713,26742,26767,26772,26779,26800,26801,26808,26816,26820,26845,26881,26884,26898,26905,26907,26910,26939,26944,26973,26996,27000,27023,27024,27026,27038,27102,27131,27151,27186,27307,27356,27363,27366,27410,27438,27449,27450,27452,27490,27520,27530,27545,27688,27722,27738,27846,27891,28030,28072,28080,28339,28440,28442,28452,28614,28615,28616,28712,28728,28780,28823,28845,28944,29054,29074,29460,29495,29635,32250,32302,32381,32507,32590,32843,32896,32943,33040,33129,33199,33417,33649,34078,34099,34109,34179,34184,34229,34241,34258,34260,34269,34292,34326,34343,34357,34485,35144,35330,35713,35744,35955,36052,39169,39269,39398,39453,39530,40036,40213,40492,40605,40822,40850,40990,42788,45008)
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 | 1030 | 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.49 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.21 ms |
System lock | 0.02 ms |
optimizing | 0.08 ms |
statistics | 1.58 ms |
preparing | 0.79 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.40 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.06 ms |
cleaning up | 0.08 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 |