Tiempo de la consulta: 3.65 ms Después de la última consulta: 0.66 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.305 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-03 22:58:41')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-03 22:58:41')
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(11,15,16,17,33,48,60,61,62,63,64,65,67,68,79,80,81,82,83,85,86,131,165,271,272,278,281,294,325,331,335,344,350,368,380,385,417,434,436,458,488,569,572,586,619,686,697,717,724,735,744,755,756,760,766,844,857,870,872,894,899,940,952,972,974,978,987,1024,1039,1047,1056,1083,1090,1091,1137,1147,1154,1168,1187,1208,1287,1298,1302,1305,1306,1313,1319,1336,1338,1344,1365,1380,1392,1406,1430,1443,1470,1478,1506,1525,1531,1532,1572,1614,1695,1698,1788,1851,1878,1943,2005,2022,2112,2184,2311,2326,2350,2356,2394,2485,2489,2536,2550,2572,2580,2583,2607,2610,2611,2621,2627,2650,2726,2733,2740,2766,2787,2794,2798,2828,2836,2839,2848,2943,2962,2990,3024,3034,3078,3116,3118,3136,3162,3173,3175,3215,3229,3248,3340,3393,3439,3443,3549,3603,3696,3771,3773,3778,3885,3905,3928,3963,3980,3982,4001,4013,4019,4062,4089,4091,4115,4128,4130,4163,4164,4182,4203,4235,4276,4308,4368,4377,4563,4587,4697,4758,4818,4819,4950,5284,5309,5349,5476,5491,5662,5674,5730,5814,5896,5965,6094,6203,6381,6470,6473,6559,6570,6600,6654,6670,6748,6899,6955,6971,7035,7125,7191,7217,7296,7330,7333,7352,7432,7546,7554,7568,7574,7575,7584,7598,7656,7801,7838,7839,7860,7875,7931,7946,7965,7966,7981,7985,8020,8120,8122,8159,8209,8210,8228,8246,8247,8275,8282,8301,8394,8412,8426,8468,8473,8502,8531,8555,8560,8614,8620,8725,8809,8886,8952,9103,9342,9445,9480,9532,9556,9575,9610,9637,9686,9712,9895,9944,9945,9949,9953,9986,10048,10131,10243,10275,10299,10302,10308,10348,10383,10395,10429,10443,10560,10561,10834,10887,10915,10930,10953,11098,11129,11234,11237,11252,11278,11299,11367,11377,11415,11482,11555,11565,11574,11688,11711,11747,11822,11843,11844,11889,11974,12042,12133,12150,12179,12238,12293,12337,12379,12416,12424,12434,12472,12480,12556,12572,12668,12716,12780,12917,12944,12962,13004,13029,13084,13152,13153,13177,13178,13278,13388,13550,13596,13635,13657,13658,13748,13750,13763,13783,13816,13828,13836,13841,13924,13934,14103,14104,14108,14113,14153,14175,14293,14350,14424,14470,14477,14570,14596,14635,14647,14729,14730,14793,14811,14895,14956,14958,15038,15114,15145,15183,15236,15242,15244,15304,15305,15359,15368,15493,15512,15522,15577,15626,15632,15645,15669,15678,15741,15766,15843,15915,15957,15975,15978,16001,16062,16083,16085,16123,16190,16201,16217,16281,16301,16322,16325,16334,16356,16392,16436,16446,16464,16468,16494,16520,16556,16561,16564,16565,16580,16606,16629,16684,16713,16721,16754,16791,16830,16854,16861,16966,17004,17157,17207,17210,17218,17250,17253,17362,17430,17443,17471,17521,17552,17567,17630,17655,17657,17669,17704,17713,17715,17761,17933,17968,17994,18049,18060,18115,18159,18162,18214,18229,18260,18277,18285,18291,18300,18311,18351,18364,18433,18438,18467,18520,18567,18647,18648,18665,18671,18690,18695,18720,18762,18828,18899,18971,18972,19002,19047,19060,19067,19123,19145,19148,19170,19180,19185,19210,19253,19276,19294,19310,19327,19352,19370,19376,19457,19460,19495,19532,19577,19620,19633,19668,19687,19732,19751,19811,19870,19908,19909,19934,19936,19986,19998,20010,20028,20031,20032,20056,20083,20086,20087,20141,20156,20164,20170,20179,20187,20189,20212,20225,20234,20248,20256,20263,20270,20271,20275,20289,20300,20326,20335,20353,20449,20450,20513,20516,20535,20549,20562,20564,20630,20680,20704,20714,20729,20737,20795,20854,20866,20897,20898,20975,20982,20983,20991,21050,21140,21161,21173,21189,21198,21225,21259,21314,21386,21422,21432,21468,21513,21545,21548,21555,21611,21620,21636,21640,21678,21681,21694,21738,21764,21768,21854,21873,21891,21950,21961,21980,22061,22096,22100,22137,22146,22204,22222,22228,22229,22297,22312,22337,22348,22361,22429,22467,22496,22559,22647,22673,22686,22712,22731,22774,22822,22837,22903,22908,22916,22980,22988,23168,23186,23249,23275,23281,23295,23374,23402,23495,23555,23559,23585,23598,23610,23614,23636,23732,23764,23816,23840,23845,23858,23873,24028,24059,24131,24194,24241,24342,24413,24451,24489,24495,24528,24540,24586,24639,24651,24653,24707,24767,24791,24798,24804,24876,24884,24897,24931,25045,25122,25166,25184,25222,25226,25242,25264,25315,25342,25525,25556,25640,25694,25702,25775,25856,25872,25906,26116,26315,26573,26595,26640,26708,26760,26807,26958,26978,26985,27024,27076,27086,27141,27143,27246,27247,27424,27560,27931,28169,28323,28330,28336,28431,28454,28495,28882,28917,29141,29194,29374,29391,29412,29454,29802,29833,30740,30947,31129,31604,32905,32993,35603,35923,35926,36053,39483,39698,40503,40685,40938)
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 | 799 | 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.44 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.19 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 1.35 ms |
preparing | 0.60 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.38 ms |
end | 0.01 ms |
query end | 0.02 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 |