Tiempo de la consulta: 8.58 ms Después de la última consulta: 1.01 ms Consulta a la memoria: 1.065 MB memoria antes de la consulta: 4.179 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 16:57:14')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 16:57:14')
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(7,11,49,58,60,66,78,81,94,117,120,126,147,148,149,150,151,152,153,154,155,167,180,201,216,265,304,305,306,316,317,340,354,368,377,385,389,390,437,458,463,493,495,515,519,549,584,592,593,621,635,686,728,731,740,741,742,791,799,813,825,841,844,855,868,891,908,931,954,955,956,970,986,1007,1018,1020,1029,1052,1053,1091,1103,1139,1168,1185,1186,1187,1188,1207,1229,1233,1257,1265,1277,1287,1296,1298,1302,1313,1336,1338,1344,1354,1367,1380,1392,1402,1406,1413,1420,1421,1430,1433,1435,1441,1443,1470,1478,1503,1506,1507,1524,1531,1532,1537,1558,1568,1572,1598,1681,1695,1719,1817,1823,1835,1905,1932,2096,2145,2178,2194,2207,2209,2229,2236,2245,2314,2315,2316,2332,2333,2342,2348,2354,2373,2376,2410,2453,2459,2476,2481,2503,2511,2516,2521,2524,2564,2579,2594,2644,2695,2713,2720,2728,2765,2786,2817,2827,2830,2857,2926,2942,2964,3020,3063,3073,3112,3117,3126,3129,3137,3143,3163,3187,3209,3210,3222,3235,3293,3304,3322,3327,3382,3388,3394,3436,3457,3486,3519,3546,3556,3574,3579,3582,3587,3602,3641,3657,3675,3692,3709,3796,3827,3840,3864,3979,3986,4013,4015,4074,4076,4153,4260,4281,4309,4335,4343,4405,4488,4525,4631,4632,4654,4670,4684,4688,4689,4691,4718,4784,4808,4841,4847,4871,4902,4949,4971,4999,5016,5020,5051,5099,5180,5300,5323,5378,5431,5470,5525,5566,5569,5572,5579,5588,5594,5597,5632,5645,5650,5659,5662,5722,5726,5727,5729,5747,5822,5870,5894,6006,6010,6217,6272,6292,6320,6348,6349,6354,6359,6362,6363,6392,6445,6484,6568,6633,6654,6675,6677,6725,6726,6744,6749,6785,6905,6911,6955,6971,6975,7056,7082,7086,7096,7099,7101,7110,7181,7211,7212,7275,7285,7296,7299,7309,7328,7334,7435,7456,7466,7495,7544,7555,7680,7688,7710,7719,7797,7806,7837,7839,7858,7860,7863,7868,7932,7946,7970,7998,8027,8037,8061,8071,8199,8250,8275,8276,8339,8451,8498,8540,8569,8593,8663,8679,8704,8773,8776,8781,8853,8983,9029,9148,9191,9201,9223,9242,9282,9305,9322,9475,9507,9626,9650,9818,9839,9864,9881,9942,10009,10078,10079,10206,10239,10261,10264,10308,10315,10340,10345,10348,10425,10535,10595,10611,10644,10665,10673,10708,10741,10775,10779,10907,10930,10952,11030,11059,11091,11207,11241,11439,11441,11603,11626,11692,11896,11924,11967,12060,12116,12128,12165,12181,12219,12223,12225,12301,12385,12398,12482,12595,12620,12622,12623,12625,12630,12705,12717,12718,12752,12758,12760,12850,12894,12925,12945,12957,13002,13010,13061,13078,13100,13248,13473,13481,13519,13635,13759,13894,13959,14005,14047,14048,14107,14140,14181,14189,14194,14204,14205,14229,14293,14350,14401,14457,14468,14516,14542,14570,14591,14592,14631,14698,14725,14829,14847,14852,14865,14911,14987,14999,15038,15063,15094,15158,15171,15177,15187,15233,15259,15270,15321,15346,15361,15372,15407,15408,15418,15429,15469,15487,15495,15516,15530,15651,15758,15839,15850,15863,15875,15937,15981,15987,16024,16043,16056,16090,16129,16155,16211,16214,16249,16281,16323,16338,16341,16347,16359,16370,16421,16423,16438,16524,16537,16547,16561,16564,16571,16580,16626,16668,16689,16717,16763,16816,16840,16863,16951,17067,17086,17148,17185,17242,17253,17273,17282,17287,17291,17360,17379,17458,17490,17501,17509,17529,17539,17572,17618,17640,17646,17659,17664,17687,17701,17727,17759,17782,17799,17818,17826,17851,17853,17869,17879,17893,17920,17921,17947,17960,18022,18074,18083,18110,18122,18127,18158,18173,18212,18219,18220,18277,18284,18286,18301,18309,18311,18321,18352,18380,18425,18433,18450,18490,18516,18549,18571,18572,18580,18630,18648,18690,18696,18770,18780,18866,18880,18911,18953,18994,18999,19004,19014,19028,19052,19060,19063,19130,19155,19178,19184,19217,19219,19231,19283,19297,19308,19325,19335,19370,19389,19407,19445,19454,19457,19482,19492,19501,19555,19574,19583,19591,19617,19648,19718,19731,19733,19747,19854,19898,19972,20003,20015,20059,20067,20111,20120,20127,20179,20195,20248,20250,20252,20256,20271,20279,20289,20333,20443,20500,20522,20590,20607,20609,20615,20664,20667,20681,20710,20737,20800,20888,20945,20947,21079,21115,21126,21128,21163,21187,21223,21229,21266,21270,21297,21321,21323,21340,21372,21393,21459,21467,21490,21496,21508,21555,21721,21735,21757,21774,21853,21870,21879,21961,21987,22005,22011,22040,22082,22089,22132,22175,22257,22306,22359,22385,22484,22525,22647,22736,22753,22909,22935,22974,22976,22979,23011,23041,23132,23139,23168,23221,23242,23332,23353,23398,23430,23439,23456,23520,23525,23555,23562,23585,23598,23602,23675,23722,23761,23817,23826,23853,23907,23910,23922,23926,23936,23958,24034,24175,24193,24220,24326,24361,24364,24413,24429,24478,24526,24577,24668,24703,24799,24849,24868,24941,24975,24989,25070,25071,25081,25153,25280,25310,25331,25332,25336,25352,25458,25475,25535,25557,25653,25676,25685,25687,25690,25694,25747,25785,25816,25891,25921,25981,26008,26050,26062,26204,26226,26358,26367,26369,26386,26444,26509,26520,26530,26583,26630,26659,26680,26698,26731,26802,27002,27009,27024,27055,27082,27101,27183,27184,27199,27218,27354,27616,27783,27806,27808,28075,28218,28366,28601,28636,29002,29372,29378,29617,29618,30486,31115,31640,32676,34699,35095,35153,35585,35744,35750,35778,35865,35882,36051,36130,36196,36267,36292,36299,36341,36591,36594,36598,36604,36769,37083,38610,38613,38652,38777,38946,38971,39041,39171,39225,39483,39571,39590,39682,39790,39821,39857,40203,40356,40385,40386,40387,40456,40483,40742,40983,41068,41298,41442,42310,42602,43018,43425,43426,44906,45227)
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 | 967 | 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.03 ms |
init | 0.18 ms |
System lock | 0.02 ms |
optimizing | 0.09 ms |
statistics | 1.81 ms |
preparing | 0.83 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 4.28 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.08 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 |