Tiempo de la consulta: 4.92 ms Después de la última consulta: 0.81 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.352 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-09 23:53:55')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 23:53:55')
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(8,161,162,163,164,165,166,167,190,197,198,215,221,253,254,269,275,311,345,346,349,350,352,363,371,385,452,485,502,544,570,608,686,697,701,708,709,710,711,712,713,715,764,783,806,813,844,854,867,881,911,923,958,963,970,977,999,1017,1137,1167,1224,1226,1277,1280,1298,1344,1358,1371,1405,1468,1476,1491,1502,1503,1555,1585,1916,1929,2089,2228,2233,2239,2313,2396,2476,2639,2697,3075,3079,3107,3113,3132,3161,3210,3216,3264,3335,3346,3358,3381,3464,3511,3513,3519,3563,3576,3666,3763,3794,3851,3868,3924,3926,3958,3985,4025,4061,4079,4105,4108,4195,4214,4229,4244,4341,4356,4386,4430,4493,4751,5149,5292,5298,5389,5454,5484,5525,5530,5578,5587,5669,5730,5756,5853,5880,5908,5940,5951,5954,5972,6038,6055,6067,6130,6202,6236,6241,6251,6301,6349,6362,6369,6442,6453,6531,6612,6633,6653,6681,6706,6729,6816,6878,6905,6912,6918,7022,7026,7048,7098,7105,7124,7156,7188,7212,7238,7271,7296,7342,7407,7415,7419,7429,7432,7440,7446,7461,7500,7530,7531,7552,7555,7569,7592,7619,7630,7710,7739,7747,7786,7811,7830,7838,7856,7860,7866,7871,7920,7935,7936,8018,8039,8050,8185,8250,8295,8296,8316,8333,8354,8441,8535,8550,8555,8583,8613,8635,8685,8714,8813,8964,9010,9029,9083,9084,9098,9114,9139,9149,9153,9197,9199,9200,9201,9223,9369,9383,9453,9557,9619,9653,9755,9757,9767,9768,9870,9878,9880,9958,10057,10144,10156,10186,10241,10246,10260,10266,10291,10298,10381,10468,10482,10522,10528,10562,10563,10689,10727,10764,10779,10800,10850,10874,10952,11001,11016,11126,11158,11203,11208,11244,11259,11320,11350,11358,11452,11520,11673,11709,11734,11742,11743,11753,11761,11814,11857,11909,11914,11917,12097,12218,12330,12334,12406,12410,12437,12471,12473,12522,12567,12575,12612,12621,12622,12644,12675,12713,12779,12839,12888,12925,12944,12952,12969,13018,13061,13129,13138,13208,13219,13251,13297,13323,13387,13441,13442,13469,13475,13476,13491,13501,13510,13512,13605,13610,13624,13642,13694,13699,13707,13730,13787,13827,13851,13966,14052,14082,14099,14126,14128,14140,14168,14178,14179,14194,14205,14208,14237,14262,14265,14287,14317,14328,14344,14369,14382,14389,14398,14411,14432,14487,14504,14527,14529,14548,14565,14582,14585,14600,14617,14655,14664,14671,14702,14710,14737,14756,14758,14769,14782,14808,14812,14838,14865,14980,15005,15015,15030,15061,15094,15125,15144,15162,15171,15194,15198,15202,15204,15259,15262,15271,15289,15308,15325,15339,15360,15375,15407,15423,15461,15487,15488,15508,15510,15532,15542,15547,15563,15564,15594,15619,15646,15650,15653,15681,15710,15726,15751,15759,15824,15833,15836,15844,15849,15850,15858,15881,15906,15908,15917,15930,15933,16011,16042,16171,16175,16242,16258,16287,16303,16344,16466,16467,16507,16522,16527,16530,16547,16548,16561,16564,16568,16569,16571,16587,16589,16630,16633,16634,16636,16643,16647,16649,16668,16674,16683,16684,16689,16694,16698,16709,16719,16720,16721,16742,16743,16754,16775,16782,16793,16798,16800,16824,16855,16860,16880,16887,16906,16986,16994,16997,17007,17022,17027,17123,17217,17220,17233,17286,17367,17402,17443,17467,17490,17515,17576,17635,17643,17645,17746,17759,17767,17784,17858,17863,17893,17921,17927,18010,18033,18054,18096,18126,18142,18159,18170,18216,18257,18292,18302,18398,18409,18432,18466,18473,18506,18517,18548,18587,18628,18648,18661,18668,18672,18677,18721,18739,18817,18824,18834,18863,18870,18892,18901,18916,18926,18939,18970,18976,18996,19018,19032,19040,19041,19060,19075,19102,19120,19189,19200,19235,19264,19306,19356,19390,19484,19490,19494,19583,19587,19625,19647,19681,19746,19776,19792,19813,19853,19854,19956,19977,20002,20026,20086,20126,20152,20221,20289,20303,20318,20336,20377,20429,20510,20558,20571,20584,20594,20596,20602,20604,20607,20615,20624,20638,20698,20710,20773,20776,20806,20830,20848,20858,20949,20950,21021,21024,21031,21062,21100,21223,21242,21268,21334,21342,21433,21452,21474,21487,21488,21489,21602,21614,21676,21705,21728,21740,21746,21752,21786,21791,21803,21855,21884,21933,21962,21972,21992,22045,22126,22127,22129,22134,22169,22176,22218,22249,22268,22270,22300,22304,22306,22315,22333,22386,22426,22468,22508,22548,22562,22572,22592,22633,22650,22660,22707,22734,22788,22804,22836,22851,22869,22890,22949,23031,23091,23116,23142,23145,23203,23204,23264,23296,23322,23332,23333,23451,23459,23521,23551,23595,23597,23694,23707,23718,23783,23829,23843,23857,23860,23874,23889,23976,24001,24015,24018,24023,24043,24062,24083,24119,24228,24230,24255,24335,24366,24373,24379,24413,24438,24558,24617,24621,24654,24718,24735,24747,24781,24793,24808,24817,24841,24854,24855,24894,24976,25017,25066,25099,25105,25146,25157,25186,25253,25293,25315,25325,25333,25335,25356,25382,25407,25510,25512,25545,25582,25585,25622,25757,25836,25916,25947,26124,26125,26153,26211,26262,26288,26362,26376,26377,26579,26587,26617,26658,26664,26684,26712,26743,26772,26915,27051,27053,27143,27145,27154,27184,27237,27326,27343,27479,27581,28280,28582,28671,31820,32445,35115,35684,35893,36315,36331,36418,36565,36656,36695,36851,38846,38939,38962,39142,39144,39286,39321,39392,39635,39644,39680,39716,39855,39891,40034,40096,40100,40646,40835,43054,43951,44914,44915,45247)
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 | 901 | 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.55 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.23 ms |
System lock | 0.06 ms |
optimizing | 0.07 ms |
statistics | 1.77 ms |
preparing | 0.90 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.49 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.06 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 |