Tiempo de la consulta: 4.16 ms Después de la última consulta: 0.85 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 4.399 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 16:33:45')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 16:33: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(72,113,155,168,190,204,280,473,479,577,608,615,622,635,828,832,941,1073,1205,1220,1257,1339,1348,1665,1715,1749,1753,1805,2018,2163,2214,2227,2428,2569,2671,2697,2738,2773,2794,2893,2911,2980,3234,3268,3425,3456,3716,3733,3825,3868,3869,3883,4028,4063,4093,4118,4182,4260,4268,4302,4405,4417,4707,4771,4794,4815,5075,5182,5207,5215,5302,5529,5560,5576,5658,5698,5708,5731,5833,5846,5879,5889,5962,5967,6005,6038,6084,6163,6221,6319,6335,6396,6468,6497,6545,6575,6654,6658,6719,6739,6780,6810,6820,6837,6889,6939,6960,6970,7018,7100,7156,7191,7266,7278,7325,7329,7360,7365,7374,7409,7415,7440,7463,7536,7554,7564,7627,7688,7702,7743,7755,7759,7811,7821,7978,7982,8001,8015,8024,8054,8083,8171,8187,8268,8294,8296,8306,8313,8406,8417,8477,8534,8587,8662,8666,8685,8715,8758,8765,8819,8858,8891,8901,9015,9016,9030,9039,9077,9083,9086,9111,9114,9137,9149,9199,9233,9238,9296,9398,9444,9454,9480,9619,9626,9653,9654,9689,9716,9741,9754,9755,9776,9784,9800,9853,9928,9958,9981,9990,10011,10035,10068,10138,10139,10156,10217,10224,10264,10296,10402,10479,10541,10696,10706,10709,10758,10765,10827,10842,10854,10863,10970,10982,11016,11032,11138,11140,11147,11179,11207,11224,11247,11268,11312,11398,11421,11440,11443,11462,11465,11475,11542,11693,11694,11700,11717,11723,11788,11794,11815,11838,11854,11857,11859,11990,12034,12135,12149,12206,12242,12315,12375,12420,12476,12500,12505,12550,12672,12752,12818,12839,12852,12892,12902,12918,12926,13197,13202,13218,13220,13247,13264,13269,13315,13335,13358,13454,13616,13646,13654,13698,13710,13722,13765,13894,13896,13925,13926,13970,14037,14055,14083,14100,14115,14126,14129,14154,14255,14305,14320,14364,14385,14392,14419,14425,14439,14609,14694,14733,14759,14766,14779,14809,14811,14839,14841,14873,14927,14959,14975,14992,15002,15038,15051,15074,15115,15122,15196,15204,15228,15257,15272,15282,15283,15286,15291,15312,15392,15433,15450,15462,15465,15479,15488,15499,15524,15633,15643,15659,15732,15804,15806,15848,15864,15969,15971,15980,16112,16118,16211,16220,16224,16284,16341,16356,16359,16394,16481,16535,16545,16565,16578,16630,16636,16674,16686,16693,16704,16742,16749,16772,16784,16800,16880,16887,16903,16904,16913,16955,16969,16979,17026,17055,17117,17137,17234,17242,17301,17311,17327,17353,17359,17372,17377,17423,17427,17434,17438,17448,17457,17481,17517,17527,17594,17666,17681,17688,17730,17746,17767,17770,17776,17781,17798,17832,17851,17873,17879,17894,17934,17942,17943,17953,17956,17972,18022,18028,18032,18048,18067,18068,18069,18073,18104,18145,18153,18221,18237,18257,18265,18283,18284,18326,18327,18352,18384,18395,18442,18448,18454,18476,18527,18546,18547,18548,18549,18570,18576,18581,18594,18607,18617,18627,18638,18662,18683,18691,18697,18737,18764,18765,18767,18771,18773,18777,18812,18889,18893,18900,18911,18915,18927,18934,18952,18953,18956,18960,18962,18969,18998,19011,19026,19050,19057,19065,19089,19092,19153,19158,19193,19202,19256,19266,19292,19303,19304,19336,19374,19401,19407,19411,19469,19520,19544,19545,19547,19549,19553,19560,19570,19591,19596,19610,19637,19648,19662,19685,19686,19694,19698,19713,19717,19756,19764,19765,19770,19789,19798,19800,19804,19809,19810,19843,19853,19883,19918,19944,19968,20009,20025,20072,20077,20120,20164,20179,20209,20250,20255,20288,20300,20396,20426,20510,20589,20624,20693,20694,20806,20818,20836,20861,20883,20919,20951,20962,20997,21020,21027,21031,21033,21054,21067,21072,21101,21126,21146,21154,21163,21164,21171,21179,21203,21206,21214,21229,21233,21236,21238,21239,21260,21268,21274,21277,21283,21298,21308,21311,21353,21354,21356,21358,21360,21361,21362,21379,21387,21411,21413,21434,21446,21450,21455,21467,21488,21490,21528,21536,21553,21562,21564,21583,21592,21593,21632,21647,21651,21652,21654,21656,21675,21697,21713,21741,21754,21769,21775,21784,21787,21789,21798,21805,21817,21818,21822,21828,21830,21832,21837,21847,21868,21875,21886,21934,21940,21942,21981,21989,21993,22001,22018,22025,22029,22037,22045,22055,22094,22128,22131,22147,22180,22181,22200,22211,22220,22244,22245,22246,22260,22272,22286,22294,22338,22377,22379,22387,22401,22426,22450,22524,22550,22585,22638,22664,22674,22677,22687,22728,22733,22755,22783,22806,22845,22854,22863,22905,22938,22939,22954,22968,22971,22991,23030,23042,23066,23067,23075,23109,23128,23143,23163,23173,23278,23334,23350,23362,23386,23524,23552,23696,23735,23853,23860,23906,23987,24013,24043,24059,24163,24185,24235,24323,24326,24353,24406,24407,24408,24452,24488,24499,24502,24541,24623,24628,24638,24674,24975,24999,25024,25030,25047,25070,25071,25130,25248,25347,25605,25622,25625,25631,25717,25719,25750,25772,25818,25912,25932,25963,26003,26014,26031,26078,26108,26136,26198,26281,26362,26378,26399,26403,26408,26410,26447,26454,26616,26626,26627,26630,26725,26741,26748,26753,26775,26785,26793,26798,26803,26804,26813,26823,26839,26844,26849,26858,26866,26887,26922,26926,26948,26950,26955,27055,27107,27109,27118,27120,27124,27133,27146,27161,27177,27236,27264,27275,27279,27287,27300,27302,27322,27394,27445,27450,27457,27465,27468,27491,27514,27548,27550,27759,27946,27954,28327,28922,29022,29314,29387,29454,29486,29505,29719,29832,29931,30703,30810,31019,31640,31670,31908,32322,32912,33440,33477,33504,33505,33506,33507,33508,33509,33510,33511,33575,33975,34087,34185,34186,34195,34381,34946,35574,35617,35674,35758,35760,36001,36189,36219,36280,36283,36431,36474,36511,36919,37397,37987,38036,38182,38184,38856,38866,38903,38927,38992,38999,39033,39035,39046,39048,39111,39121,39195,39302,39335,39413,39480,39505,39537,39572,39608,39614,39617,39645,39666,39753,39788,39839,39891,39907,40049,40097,40134,40297,40441,40492,40511,40558,40607,40942,41092,41219,41270,41304,41644,41855,41856,41994,42357,42922,43193,43506,44226,44883,44884,44885,44886,44887,44888,44889,44890,45026,45280)
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 | 1000 | 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.53 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.19 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.57 ms |
preparing | 0.75 ms |
Sorting result | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.37 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 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 |