Tiempo de la consulta: 3.71 ms Después de la última consulta: 0.61 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.176 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-06 11:29:28')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 11:29:28')
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(23,79,80,81,82,83,85,86,165,271,325,368,434,458,466,744,785,856,870,940,974,1010,1091,1277,1327,1365,1614,1691,1700,1720,2023,2109,2737,2767,2799,3024,3034,3059,3439,3570,3617,3682,3715,3963,3974,3982,4114,4285,4306,4310,4587,4893,5026,5484,5525,5530,5537,5662,5849,5874,5896,5934,6470,6473,6600,6608,6629,6654,6681,6833,6925,6933,6955,6971,7162,7163,7164,7191,7251,7264,7343,7436,7447,7568,7679,7744,7764,7840,7854,7966,8020,8045,8397,8430,8441,8502,8555,8567,8809,8903,8952,9304,9326,9960,10033,10048,10160,10163,10169,10272,10280,10299,10302,10395,10443,10453,10484,10512,10554,10560,10607,10661,10771,10887,10915,11022,11098,11278,11367,11415,11417,11427,11553,11555,11716,11747,11828,12019,12133,12190,12203,12293,12379,12416,12472,12572,12692,12716,12917,12933,13019,13029,13033,13084,13107,13177,13178,13278,13312,13323,13334,13388,13550,13551,13596,13604,13635,13658,13763,13836,13841,14108,14141,14180,14246,14266,14334,14350,14375,14453,14477,14491,14582,14613,14624,14632,14635,14701,14729,14751,14760,14891,14895,15048,15094,15171,15187,15214,15242,15273,15281,15304,15351,15426,15440,15475,15582,15626,15677,15726,15741,15750,15752,15766,15937,15949,15953,15978,16024,16038,16085,16123,16190,16217,16236,16281,16301,16305,16322,16325,16366,16392,16430,16433,16436,16486,16497,16561,16564,16571,16606,16623,16673,16695,16713,16742,16903,16909,16963,16966,17066,17088,17157,17222,17266,17327,17406,17411,17431,17515,17567,17596,17657,17669,17715,17759,17846,17968,18008,18049,18090,18109,18128,18214,18438,18453,18464,18625,18647,18648,18665,18666,18695,18698,18699,18718,18792,18864,18972,18973,18985,19000,19025,19060,19123,19191,19210,19275,19285,19292,19310,19368,19383,19495,19504,19571,19580,19626,19680,19705,19751,19807,19818,19887,19903,19919,19934,19936,19946,19948,19951,19969,19978,19986,20015,20018,20020,20031,20083,20086,20087,20089,20105,20179,20186,20225,20226,20263,20294,20312,20335,20359,20371,20388,20431,20460,20496,20498,20523,20549,20562,20596,20608,20664,20672,20680,20704,20721,20737,20746,20777,20784,20870,20877,20898,20906,20975,20991,20996,21074,21110,21135,21140,21160,21161,21194,21231,21259,21339,21386,21423,21505,21510,21512,21555,21640,21681,21689,21733,21765,21816,21878,21891,21912,21931,21947,22027,22061,22114,22122,22144,22185,22205,22216,22222,22228,22254,22273,22277,22283,22305,22311,22312,22326,22383,22393,22430,22605,22706,22752,22822,22877,22899,23076,23112,23189,23209,23224,23263,23306,23307,23367,23393,23444,23458,23559,23609,23614,23689,23698,23709,23770,23786,23883,23889,23895,23917,23929,23941,23957,23994,24020,24064,24086,24114,24131,24297,24364,24423,24455,24471,24513,24528,24536,24559,24571,24574,24635,24641,24651,24668,24684,24756,24807,24812,24822,25022,25111,25154,25176,25215,25222,25226,25242,25273,25274,25297,25332,25348,25361,25394,25452,25477,25525,25556,25560,25580,25603,25650,25657,25671,25672,25676,25680,25681,25696,25697,25699,25711,25724,25755,25799,25807,25820,25847,25884,25907,25908,25935,25947,25948,25958,25967,25971,26030,26064,26133,26177,26193,26225,26230,26239,26250,26292,26405,26409,26431,26456,26499,26507,26508,26529,26541,26543,26559,26571,26582,26596,26605,26651,26664,26678,26685,26698,26715,26723,26725,26740,26743,26749,26750,26756,26760,26767,26768,26801,26809,26810,26818,26859,26860,26896,26937,26958,26976,26985,26991,27009,27012,27024,27025,27028,27045,27056,27060,27076,27082,27097,27155,27247,27248,27261,27318,27417,27478,27512,27518,27533,27544,27567,27589,27591,27634,27737,27738,27763,27789,27811,27822,27930,27948,27957,27998,28006,28036,28075,28135,28169,28184,28309,28320,28342,28360,28361,28460,28472,28620,28675,28690,28702,28755,28852,28916,29023,29123,29129,29143,29241,29249,29250,29374,29391,29413,29438,29533,29608,29618,29799,29833,29890,29904,29908,30947,32374,34432,34451,34653,34750,35196,35645,35871,35926,36053,37426,38666,38886,39286,39411,39761,39877,40503,40661,40685,40727,40860,40887,41158,41183,41200,41217,41421,42486,42758)
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 | 683 | 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.40 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.16 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.10 ms |
preparing | 0.52 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.35 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.04 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 |