Tiempo de la consulta: 4.42 ms Después de la última consulta: 0.67 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.168 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 06:31:38')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 06:31: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(49,136,140,142,143,144,145,146,178,179,271,489,686,723,964,986,1044,1047,1080,1103,1130,1143,1158,1207,1252,1253,1256,1302,1339,1664,2631,2632,2641,2688,2902,3025,3067,3087,3126,3176,3223,3301,3669,3687,3725,3925,4090,4095,4100,4131,4227,4337,4378,4392,4765,4930,5554,5639,5647,5659,5694,5713,5719,5800,5814,5819,5934,6043,6050,6055,6066,6081,6097,6127,6178,6264,6270,6272,6298,6329,6330,6332,6340,6347,6350,6376,6388,6427,6442,6455,6456,6460,6462,6465,6468,6470,6471,6473,6492,6494,6497,6499,6500,6502,6515,6517,6520,6534,6538,6545,6546,6568,6573,6601,6603,6608,6645,6654,6656,6658,6659,6711,6718,6749,6762,6776,6779,6788,6805,6806,6809,6827,6847,6868,6869,6872,6879,6882,6889,6910,6914,6915,6916,6942,6945,6965,6966,6968,6989,6990,6995,7016,7043,7045,7075,7102,7122,7125,7134,7135,7138,7150,7154,7155,7156,7160,7170,7171,7173,7176,7178,7179,7201,7212,7213,7241,7243,7246,7249,7267,7268,7270,7277,7279,7282,7283,7285,7289,7291,7327,7328,7330,7333,7334,7344,7346,7367,7368,7370,7371,7372,7374,7376,7377,7378,7379,7380,7387,7389,7401,7403,7406,7407,7408,7410,7411,7413,7414,7415,7417,7418,7427,7428,7430,7431,7435,7436,7447,7450,7457,7458,7459,7461,7462,7464,7465,7469,7488,7489,7494,7495,7508,7513,7514,7523,7545,7546,7552,7553,7555,7567,7570,7577,7578,7583,7615,7674,7677,7678,7681,7682,7683,7686,7689,7690,7691,7708,7713,7715,7720,7722,7730,7743,7744,7746,7749,7757,7758,7768,7780,7804,7806,7808,7810,7831,7833,7834,7835,7836,7841,7855,7862,7863,7864,7866,7867,7871,7891,7894,7895,7900,7901,7918,7919,7920,7923,7928,7930,7940,7955,7957,7960,7961,7962,7963,7979,7982,7983,7987,7989,7994,8017,8020,8021,8022,8026,8028,8048,8049,8056,8064,8067,8070,8071,8072,8073,8082,8090,8103,8108,8109,8111,8134,8139,8140,8289,8311,8330,8356,8551,8808,8950,9091,9203,9239,9308,9429,9478,9759,9791,9826,10004,10028,10120,10197,10199,10265,10349,10379,10399,10415,10534,10553,10560,10600,10777,10803,10811,10835,10916,11091,11099,11126,11192,11226,11229,11231,11249,11260,11310,11377,11430,11548,11581,11592,11808,11816,11849,11863,12013,12024,12042,12112,12147,12171,12174,12184,12204,12340,12358,12401,12427,12474,12492,12499,12520,12579,12609,12625,12681,12708,12709,12806,12990,13004,13036,13216,13445,13461,13476,13492,13500,13656,13666,13685,13696,13837,13880,13922,14052,14084,14110,14116,14257,14258,14289,14349,14357,14426,14653,14676,14682,14685,14749,14818,14939,14947,14986,14988,15065,15086,15173,15205,15244,15253,15286,15298,15332,15408,15569,15672,15732,15835,15898,15925,15954,16030,16031,16055,16101,16133,16156,16180,16257,16278,16362,16381,16417,16523,16542,16622,16657,16675,16698,16823,16826,16854,16865,16964,17096,17142,17158,17336,17410,17449,17559,17599,17632,17688,17712,17734,17763,17784,17814,17857,17933,17941,17991,18006,18074,18227,18301,18317,18320,18401,18409,18463,18512,18524,18552,18658,18663,18668,18693,18695,18701,18744,18750,18810,18811,18830,18846,18849,18873,18894,18959,18984,19003,19048,19049,19129,19134,19145,19170,19183,19213,19222,19230,19296,19311,19344,19381,19424,19426,19460,19521,19536,19572,19622,19733,19848,19851,19858,19915,19947,19982,19984,19993,20042,20104,20148,20163,20189,20276,20286,20345,20382,20474,20486,20515,20632,20670,20708,20752,20778,20792,20869,20913,20940,20960,20981,21075,21247,21259,21273,21294,21321,21327,21350,21366,21392,21398,21413,21521,21566,21577,21588,21611,21614,21696,21775,21863,21884,21895,21913,21924,21928,21961,21990,22009,22038,22039,22079,22137,22207,22230,22326,22349,22362,22363,22382,22395,22436,22488,22550,22614,22659,22693,22698,22709,22754,22804,22840,22959,22989,23023,23077,23087,23121,23279,23289,23308,23367,23368,23371,23397,23437,23444,23527,23535,23542,23555,23631,23665,23693,23709,23716,23787,23869,23920,23937,23965,23969,24003,24015,24033,24066,24090,24115,24140,24162,24164,24170,24211,24237,24270,24279,24284,24329,24362,24409,24441,24461,24481,24520,24538,24650,24720,24754,24755,24764,24774,24775,24795,24816,24846,24862,24865,24956,24983,25002,25026,25076,25090,25109,25137,25164,25192,25225,25255,25335,25369,25372,25408,25477,25484,25510,25512,25517,25519,25535,25601,25638,25664,25672,25740,26074,26203,26421,26521,26561,26596,27039,27233,27346,27384,27563,27634,28068,28115,28295,28372,28478,28673,29142,29214,29219,29269,29359,29382,29405,29444,29484,29655,29759,30325,32331,32565,33417,35653,35741,38884,38898,40369,40636,42036,44509)
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 | 787 | 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.02 ms |
init | 0.19 ms |
System lock | 0.02 ms |
optimizing | 0.09 ms |
statistics | 1.54 ms |
preparing | 0.71 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.36 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.12 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 |