Tiempo de la consulta: 3.28 ms Después de la última consulta: 0.62 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.163 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 18:12:44')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 18:12:44')
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(60,263,274,341,482,869,998,1066,1101,1225,1304,1359,1411,1503,1620,1701,1735,1765,1775,1839,1848,1984,2006,2008,2027,2054,2142,2313,2632,2710,2971,3009,3122,3132,3161,3188,3202,3210,3264,3281,3292,3326,3329,3358,3376,3442,3464,3511,3515,3519,3595,3735,3795,3833,3851,3985,4108,4148,4227,4312,4323,4334,4354,4430,4507,4520,4550,4554,4621,4672,4673,4821,4832,4833,4848,4930,5000,5049,5056,5094,5144,5266,5399,5525,5578,5625,5646,5700,5758,5809,5874,5897,5908,5924,5947,5950,5972,5986,5989,5990,5991,6012,6020,6022,6073,6079,6083,6108,6110,6112,6130,6132,6138,6141,6222,6241,6319,6432,6442,6464,6504,6606,6610,6611,6612,6623,6633,6637,6638,6653,6659,6706,6729,6845,6886,6887,6905,6945,7022,7146,7200,7296,7324,7388,7395,7432,7440,7522,7527,7550,7621,7792,7810,7852,7866,8050,8083,8088,8089,8150,8261,8263,8273,8294,8367,8386,8393,8441,8498,8555,8583,8613,8647,8679,8696,8707,8723,8756,8841,8879,8940,8962,9023,9040,9057,9061,9126,9190,9199,9387,9515,9553,9665,9738,9833,9992,10101,10113,10228,10407,10482,10562,10572,10779,10952,11006,11137,11244,11320,11443,11469,11549,11700,11781,11868,11925,12077,12265,12324,12675,12817,12922,12939,12973,13015,13018,13129,13145,13186,13219,13231,13248,13251,13469,13475,13617,13624,13642,13694,13699,13701,13787,13851,13855,13861,13925,14132,14140,14146,14189,14194,14265,14331,14344,14364,14398,14411,14428,14432,14478,14531,14565,14582,14617,14655,14710,14713,14737,14808,14865,14972,14975,14988,15002,15046,15087,15125,15144,15171,15203,15259,15262,15271,15287,15298,15314,15322,15324,15398,15407,15423,15461,15564,15606,15619,15642,15646,15653,15710,15749,15759,15796,15850,15876,15899,15908,16054,16102,16171,16245,16464,16527,16547,16548,16564,16568,16569,16571,16587,16630,16633,16634,16636,16643,16648,16649,16668,16674,16684,16689,16694,16698,16709,16719,16720,16721,16742,16743,16754,16775,16795,16800,16855,16860,16880,16906,16924,16986,16995,16997,17062,17156,17167,17170,17270,17293,17335,17346,17412,17420,17427,17490,17524,17576,17606,17618,17620,17630,17635,17698,17721,17842,17893,17942,18010,18035,18038,18054,18080,18096,18102,18151,18184,18234,18265,18306,18347,18473,18494,18517,18609,18630,18678,18755,18778,18779,18802,18826,18836,18851,18863,18876,18891,18892,18905,18906,18907,18917,18929,18931,18934,18938,18940,18945,18956,18969,18977,18978,19012,19039,19046,19163,19189,19197,19422,19424,19490,19548,19551,19553,19558,19589,19681,19693,19808,19809,19845,19854,19857,19865,19879,19977,20081,20139,20188,20215,20353,20436,20448,20510,20535,20565,20571,20596,20607,20615,20621,20710,20858,20871,20997,21024,21025,21031,21034,21185,21203,21241,21439,21534,21542,21560,21652,21671,21720,21746,21787,21833,21884,22196,22209,22215,22249,22311,22312,22362,22365,22591,22603,22651,22850,22870,22926,22966,22998,23112,23116,23139,23402,23428,23452,23494,23511,23551,23584,23589,23595,23611,23648,23676,23701,23709,23732,23892,23912,23945,24014,24151,24190,24270,24280,24298,24317,24339,24382,24387,24396,24415,24424,24431,24451,24486,24553,24554,24627,24650,24774,24777,24783,24831,24856,25017,25049,25128,25281,25526,25592,25752,25909,26000,26082,26190,26362,26530,26531,26558,26875,26949,26997,27096,27208,27217,27223,27249,27354,27421,27422,27460,27491,27499,27502,27635,27860,27875,27894,27898,27968,27990,28022,28030,28218,28272,28416,28423,28440,28442,28458,28470,28524,28547,28582,28587,28596,28635,28636,28858,28884,29221,29222,29231,29232,31060,32920,33303,33476,33897,34319,35036,35103,35219,35574,35637,35676,35724,35746,36027,36252,37497,38855,38988,39253,39301,39683,39714,39971,40034,40328,40358,40453,40481,40784,40863,41117,42411,42763,42876,43461,44318,44427)
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 | 639 | 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.36 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.14 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 1.00 ms |
preparing | 0.48 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.33 ms |
end | 0.01 ms |
query end | 0.03 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.02 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 |