Tiempo de la consulta: 3.74 ms Después de la última consulta: 0.67 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.326 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 02:48:16')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 02:48:16')
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,263,341,466,482,869,1066,1101,1225,1359,1411,1503,1620,1701,1720,1735,1765,1775,1839,1848,2006,2008,2054,2109,2142,2632,2710,2767,2799,3009,3122,3188,3281,3292,3326,3329,3376,3442,3515,3570,3595,3617,3682,3715,3735,3974,4114,4148,4227,4285,4306,4310,4312,4323,4334,4354,4430,4507,4520,4550,4554,4621,4672,4673,4821,4832,4833,4848,5026,5049,5056,5094,5144,5266,5399,5484,5530,5537,5578,5646,5849,5897,5934,6141,6442,6606,6608,6612,6623,6637,6638,6679,6729,6833,6845,6905,6911,6925,6933,7022,7162,7163,7164,7169,7251,7264,7324,7343,7388,7395,7436,7447,7522,7527,7679,7840,7852,7854,8045,8273,8294,8367,8386,8393,8397,8430,8441,8498,8555,8567,8679,8707,8903,8940,9057,9061,9190,9199,9304,9326,9553,9992,10033,10101,10113,10160,10163,10169,10272,10407,10443,10453,10484,10512,10554,10562,10572,10607,10661,10771,11320,11417,11427,11443,11469,11549,11553,11700,11716,11828,12019,12324,12692,12817,12933,12973,13019,13186,13219,13312,13323,13334,13475,13551,13604,13851,13925,14132,14141,14146,14180,14189,14194,14246,14266,14331,14364,14375,14428,14491,14565,14601,14613,14624,14632,14701,14713,14737,14751,14760,14972,14975,14988,15048,15087,15094,15144,15171,15203,15214,15273,15281,15322,15351,15398,15426,15475,15582,15677,15680,15710,15726,15750,15796,15850,15949,15953,16038,16102,16236,16245,16305,16322,16366,16430,16468,16486,16497,16543,16547,16548,16564,16569,16571,16623,16636,16673,16698,16742,16793,16876,16903,16963,16997,17062,17066,17088,17167,17170,17266,17335,17406,17411,17412,17427,17431,17524,17606,17635,17715,17721,17846,17942,18008,18035,18080,18096,18109,18128,18151,18265,18306,18453,18473,18609,18625,18630,18666,18698,18699,18718,18779,18802,18836,18864,18969,18977,18978,18985,19000,19012,19039,19191,19368,19424,19504,19551,19571,19580,19626,19681,19690,19705,19807,19818,19903,19918,19919,19946,19948,19951,19978,20018,20020,20089,20105,20186,20188,20226,20294,20312,20359,20371,20388,20431,20448,20498,20513,20523,20565,20596,20608,20621,20672,20721,20777,20784,20870,20871,20906,20997,21025,21034,21074,21110,21135,21160,21185,21203,21231,21241,21339,21439,21505,21510,21512,21534,21560,21652,21720,21733,21746,21765,21787,21816,21831,21878,21947,22027,22114,22122,22144,22185,22205,22216,22249,22254,22273,22277,22305,22312,22383,22430,22603,22605,22706,22870,22877,22966,23076,23112,23189,23209,23263,23306,23307,23367,23393,23444,23452,23458,23648,23676,23689,23698,23701,23709,23770,23786,23883,23895,23917,23941,23945,23957,23994,24020,24064,24086,24114,24151,24297,24423,24471,24536,24559,24571,24574,24627,24635,24641,24684,24756,24807,24812,24822,25017,25022,25027,25111,25128,25176,25215,25273,25274,25297,25332,25348,25361,25394,25452,25477,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,26000,26030,26064,26082,26133,26177,26193,26225,26230,26239,26250,26292,26362,26408,26409,26431,26456,26471,26507,26508,26529,26541,26543,26559,26571,26582,26596,26605,26651,26664,26678,26685,26715,26723,26725,26740,26743,26749,26750,26756,26767,26768,26801,26809,26818,26859,26860,26896,26937,26949,26976,26991,26997,27025,27028,27045,27056,27060,27082,27097,27155,27248,27261,27318,27354,27417,27421,27460,27478,27502,27512,27544,27567,27589,27591,27613,27634,27635,27737,27738,27763,27789,27811,27822,27860,27875,27894,27898,27930,27948,27957,27968,27990,27998,28006,28022,28030,28036,28135,28184,28218,28272,28309,28320,28342,28360,28361,28416,28423,28440,28442,28458,28460,28470,28472,28524,28547,28582,28587,28620,28635,28636,28675,28690,28702,28755,28852,28858,28884,28916,29023,29123,29129,29221,29222,29241,29249,29250,29413,29438,29533,29608,29618,29799,29890,29904,32374,33897,34213,34290,34319,34432,34451,34561,34653,34750,35036,35103,35196,35219,35645,35676,35724,35746,35871,36033,36252,36398,36477,36618,36682,36935,37397,37426,37497,37654,37735,37880,37907,37947,38079,38448,38549,38574,38602,38666,38855,38988,39135,39253,39286,39301,39520,39683,39714,39761,39816,39971,40034,40326,40358,40365,40453,40481,40661,40727,40784,40829,40860,40863,40887,40941,41117,41158,41200,41217,41421,41528,42331,42411,42486,42758,42763,42876,43130,43461,43592,43690)
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 | 729 | 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.37 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.07 ms |
statistics | 1.12 ms |
preparing | 0.56 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.30 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.06 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 |