Tiempo de la consulta: 5.36 ms Después de la última consulta: 0.64 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.459 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 00:45:07')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 00:45:07')
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(49,51,131,133,136,138,139,140,142,143,144,145,146,155,178,179,204,271,374,460,489,495,529,583,686,723,892,907,929,964,986,1036,1044,1047,1080,1112,1130,1133,1143,1158,1169,1204,1207,1252,1253,1256,1302,1339,1587,1664,1808,2157,2219,2222,2485,2552,3126,3223,3279,3301,3379,3669,3687,3825,3932,3951,3984,4046,4061,4263,4378,4515,4765,4910,4992,5647,5659,5757,5814,5870,6221,6448,6470,6538,6573,6577,6616,6686,6691,6942,6965,6966,6968,6989,7016,7043,7075,7121,7130,7161,7282,7291,7311,7326,7380,7387,7401,7403,7414,7427,7508,7546,7572,7594,7652,7730,7804,7831,7867,7957,7967,7983,7989,8027,8108,8258,8356,8551,8728,8950,9091,9109,9203,9218,9239,9429,9791,9983,10028,10120,10348,10415,10777,10803,10835,10869,10916,10955,10970,11091,11192,11249,11260,11310,11377,11430,11441,11560,11662,11753,11808,11816,11863,11965,12042,12112,12113,12147,12174,12204,12213,12281,12401,12427,12430,12475,12492,12579,12609,12625,12681,12685,12709,12806,12935,12990,12999,13004,13036,13044,13216,13445,13461,13476,13492,13500,13587,13666,13696,13710,13729,13837,13880,13922,14116,14186,14257,14258,14264,14289,14426,14560,14591,14676,14840,14939,14986,14988,15027,15086,15104,15173,15205,15245,15286,15332,15408,15520,15569,15672,15706,15732,15782,15894,15898,15991,16014,16030,16133,16157,16180,16187,16278,16362,16375,16381,16417,16427,16523,16528,16542,16622,16657,16675,16698,16814,16865,16894,17047,17096,17117,17142,17248,17300,17328,17336,17410,17449,17559,17592,17599,17613,17632,17688,17712,17734,17753,17784,17814,17924,17933,17941,17954,18006,18027,18042,18072,18074,18078,18212,18290,18301,18320,18384,18419,18430,18463,18485,18524,18552,18658,18668,18693,18702,18705,18708,18750,18761,18764,18810,18811,18830,18839,18843,18846,18849,18853,18854,18873,18894,18959,18984,19003,19129,19134,19145,19178,19222,19230,19249,19284,19290,19296,19311,19344,19375,19381,19414,19424,19439,19455,19460,19521,19536,19565,19572,19622,19634,19644,19659,19664,19705,19720,19733,19759,19779,19819,19820,19848,19915,19942,19973,19982,19984,19993,20002,20042,20045,20076,20091,20104,20116,20148,20163,20189,20226,20276,20286,20315,20345,20382,20474,20515,20577,20677,20708,20752,20767,20778,20869,20885,20913,20940,20960,20969,20981,20992,21009,21060,21075,21093,21107,21171,21188,21218,21247,21251,21264,21321,21326,21350,21378,21392,21398,21502,21521,21577,21609,21611,21644,21714,21728,21749,21775,21777,21830,21863,21864,21895,21928,21961,22038,22039,22048,22072,22079,22166,22207,22299,22326,22332,22349,22363,22382,22385,22395,22436,22488,22495,22507,22556,22595,22659,22693,22698,22704,22709,22715,22736,22754,22804,22840,22879,22893,22920,22934,22951,22989,23055,23077,23078,23087,23116,23119,23134,23145,23178,23213,23273,23279,23287,23289,23364,23365,23367,23368,23397,23409,23426,23444,23527,23535,23555,23569,23646,23665,23668,23677,23693,23695,23709,23711,23716,23719,23774,23776,23787,23869,23872,23914,23920,23937,23965,23969,23991,24003,24033,24060,24066,24090,24100,24108,24115,24137,24164,24170,24195,24217,24233,24258,24270,24272,24275,24284,24291,24368,24380,24391,24428,24437,24441,24442,24461,24481,24518,24520,24527,24565,24590,24720,24754,24755,24775,24780,24795,24816,24865,24942,24974,25002,25026,25077,25090,25109,25116,25164,25170,25187,25192,25195,25281,25300,25356,25386,25408,25477,25484,25517,25519,25535,25601,25638,25657,25664,25672,25740,25745,25807,25944,26132,26193,26375,26412,26421,26431,26521,26561,26591,26596,26599,26672,26835,26842,26843,26864,26933,27039,27059,27186,27197,27233,27346,27384,27457,27633,27634,27832,27855,27918,27921,27923,27924,27926,27999,28068,28208,28295,28333,28346,28349,28352,28353,28354,28357,28359,28360,28361,28362,28363,28364,28367,28368,28369,28371,28373,28376,28378,28381,28389,28393,28406,28419,28478,28569,29214,29219,29223,29269,29380,29484,29611,29641,29930,30621,30932,31908,32304,32331,32565,32796,34795,34876,34923,35195,35309,35783,35850,36174,36222,36439,36480,36652,36728,36735,36805,37055,37306,38227,38563,38604,38859,38884,38885,38898,38932,38952,39062,39242,39886,39966,40218,40269,40369,40636,40656,40764,40786,41257,41363,42181)
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 | 710 | 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.43 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.06 ms |
init | 0.35 ms |
System lock | 0.02 ms |
optimizing | 0.13 ms |
statistics | 1.54 ms |
preparing | 0.99 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.84 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.05 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 |