Tiempo de la consulta: 3.33 ms Después de la última consulta: 0.67 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 4.376 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-07 06:18:38')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 06:18:38')
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(338,340,345,346,350,352,359,418,460,466,471,482,609,625,782,823,843,905,1022,1051,1066,1327,1359,1391,1432,1620,1686,1724,1754,1828,1839,2313,2369,2476,2574,2780,2808,2825,2884,3026,3037,3132,3165,3188,3193,3210,3264,3269,3281,3292,3329,3346,3358,3375,3436,3440,3464,3511,3519,3593,3715,3721,3722,3752,3851,3866,3922,3985,4026,4049,4108,4245,4289,4355,4415,4451,4457,4461,4485,4486,4495,4507,4510,4520,4583,4584,4620,4640,4672,4745,4787,4832,5092,5094,5160,5170,5183,5244,5282,5301,5415,5469,5495,5505,5525,5581,5589,5677,5683,5688,5703,5793,5802,5831,5848,5972,5979,6093,6113,6130,6142,6166,6176,6241,6256,6317,6335,6345,6374,6442,6538,6546,6549,6597,6606,6609,6610,6612,6633,6653,6680,6689,6698,6706,6722,6729,6763,6783,6866,6873,6894,6905,6912,6944,6958,6998,7023,7024,7046,7053,7054,7105,7139,7183,7195,7223,7242,7296,7323,7324,7375,7382,7383,7415,7432,7435,7440,7466,7513,7527,7533,7615,7618,7708,7710,7711,7778,7838,7860,7869,7918,7953,7969,7976,8002,8009,8040,8045,8046,8050,8073,8074,8104,8185,8192,8217,8225,8240,8273,8291,8294,8314,8393,8441,8532,8555,8568,8583,8613,8674,8707,8722,8940,9061,9147,9190,9369,9380,9401,9559,9641,9873,9932,10258,10371,10389,10407,10482,10501,10562,10572,10779,10952,11207,11241,11244,11408,11549,11555,11689,11693,11788,11814,12550,12727,12870,13018,13034,13067,13219,13251,13353,13469,13624,13642,13694,13699,13750,13779,13787,14022,14127,14129,14140,14144,14185,14194,14265,14344,14411,14432,14565,14582,14617,14710,14737,14752,14865,14873,14944,14974,15125,15133,15140,15144,15171,15203,15259,15271,15407,15423,15461,15485,15541,15564,15613,15619,15646,15653,15690,15710,15759,15785,15786,15850,15868,15871,15878,15908,15930,15969,16046,16081,16102,16103,16120,16171,16176,16227,16245,16300,16527,16547,16548,16564,16568,16569,16571,16587,16630,16633,16634,16636,16643,16649,16668,16674,16684,16689,16694,16709,16719,16720,16721,16742,16743,16754,16775,16793,16800,16855,16860,16880,16905,16906,16984,16986,16997,17136,17140,17242,17314,17315,17395,17405,17449,17458,17483,17490,17576,17592,17608,17683,17756,17886,17893,17986,18010,18054,18075,18077,18088,18191,18241,18307,18308,18327,18383,18448,18497,18500,18652,18657,18665,18695,18779,18783,18832,18863,19019,19062,19137,19228,19283,19289,19299,19397,19490,19647,19706,19710,19721,19744,19800,19854,19860,19874,19908,19977,19996,20040,20191,20196,20318,20357,20448,20510,20571,20596,20599,20607,20615,20710,20858,20873,20883,20921,20966,20967,20997,21024,21031,21036,21137,21203,21272,21279,21282,21473,21560,21720,21835,21884,21940,22038,22105,22123,22196,22249,22256,22306,22372,22480,22529,22726,22734,22758,22779,22870,22886,22955,23065,23116,23276,23397,23400,23482,23511,23551,23595,23788,23925,23932,24180,24195,24634,24690,24920,24933,25000,25017,25030,25112,25689,25843,25850,25869,25966,26000,26014,26037,26043,26044,26082,26100,26148,26215,26241,26405,26435,26447,26504,26652,26683,26707,26762,26797,26803,26825,26841,26875,26897,26948,26949,26954,26982,26991,27023,27340,27344,27354,27404,27511,27522,27676,27702,27843,27875,28000,28152,28193,28218,28334,28340,28548,28615,28616,28629,28656,28665,28671,28706,28707,28725,28727,28728,28745,28763,28776,28795,28799,28800,28803,28807,28833,28834,28844,28847,28866,28872,28925,28931,29127,29201,29329,29374,29389,29418,29459,29468,29613,29894,30138,30262,30572,30573,31401,32286,32306,32340,32342,32590,32591,32613,32640,32647,32965,33107,33327,33503,33649,34265,34595,34785,34902,34942,34969,35051,35071,35072,35073,35088,35097,35156,35165,35167,35206,35294,35308,35326,35427,35430,35564,35588,35657,35674,35694,35724,35792,35931,36012,36165,36191,36285,36346,36355,36463,36575,36750,36795,36798,36806,37129,37251,37528,37529,37532,37972,38212,38365,38392,38417,38503,38598,38825,38964,39056,39061,39170,39299,39301,39529,39703,39882,39971,40052,40107,40110,40119,40358,40481,40625,40655,40784,41063,41094,41117,41348,41353,41380,41381,41520,41723,41744,41866,41874,42035,42376,42394,42404,42416,42822,43090,43107,43162,43353,43645,43944,44078,44100,44101,44817,45134,45293)
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 | 714 | 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.45 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.17 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 1.15 ms |
preparing | 0.55 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.33 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.03 ms |
freeing items | 0.07 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 |