Tiempo de la consulta: 3.17 ms Después de la última consulta: 0.56 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.304 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-04 12:32:23')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 12:32:23')
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(2,23,49,58,111,204,234,293,420,437,447,466,495,605,607,639,644,645,653,701,719,721,757,777,836,862,912,944,1173,1236,1463,1643,1720,1725,1893,2109,2144,2163,2164,2169,2195,2199,2202,2204,2210,2213,2217,2227,2234,2237,2242,2245,2256,2273,2286,2299,2346,2348,2386,2398,2767,2799,3049,3113,3286,3570,3617,3682,3715,3750,3852,3886,3974,4114,4188,4285,4306,4310,4754,4973,5026,5437,5484,5530,5533,5537,5560,5849,5874,5934,6294,6405,6608,6684,6833,6925,6933,6934,6948,7162,7163,7164,7251,7264,7329,7343,7436,7447,7679,7722,7806,7840,7854,7997,8045,8192,8250,8397,8430,8441,8499,8555,8567,8903,9249,9264,9299,9304,9318,9326,9414,9428,9438,9451,9784,10033,10160,10163,10169,10272,10366,10443,10453,10484,10512,10554,10562,10607,10661,10771,11242,11417,11427,11553,11711,11716,11828,12019,12228,12374,12692,12761,12808,12933,13019,13312,13323,13334,13551,13604,14141,14180,14246,14266,14375,14432,14491,14613,14624,14632,14701,14751,14760,15048,15094,15214,15273,15275,15281,15351,15426,15475,15582,15619,15677,15726,15750,15949,15953,16038,16236,16305,16322,16366,16430,16476,16486,16497,16547,16564,16571,16623,16673,16675,16728,16742,16901,16903,16963,17066,17088,17222,17266,17406,17411,17431,17688,17712,17715,17846,18008,18109,18128,18453,18625,18666,18698,18699,18718,18862,18864,18985,18997,19000,19191,19368,19419,19437,19504,19571,19580,19626,19635,19705,19733,19807,19818,19903,19919,19944,19946,19948,19951,19978,20018,20020,20083,20089,20105,20186,20226,20294,20312,20333,20359,20371,20388,20431,20498,20513,20523,20542,20563,20596,20608,20672,20721,20777,20784,20870,20906,21074,21110,21128,21135,21160,21231,21339,21350,21398,21505,21510,21512,21693,21733,21765,21798,21816,21878,21904,21947,22027,22030,22088,22114,22122,22126,22144,22185,22205,22216,22254,22273,22277,22305,22312,22336,22383,22395,22430,22605,22622,22706,22752,22834,22877,22913,22935,22974,23076,23112,23189,23209,23242,23263,23279,23306,23307,23367,23393,23438,23444,23458,23527,23689,23698,23709,23770,23786,23883,23895,23917,23941,23957,23994,24020,24064,24086,24114,24178,24297,24423,24471,24536,24559,24571,24573,24574,24635,24641,24672,24684,24756,24807,24812,24822,24868,24907,24964,25022,25111,25176,25215,25273,25274,25297,25310,25332,25343,25348,25361,25384,25389,25394,25420,25429,25434,25452,25477,25501,25560,25573,25580,25603,25614,25650,25657,25664,25671,25672,25676,25680,25681,25688,25696,25697,25699,25711,25718,25724,25755,25799,25807,25820,25847,25884,25907,25908,25931,25935,25947,25958,25967,25971,26030,26064,26133,26177,26193,26225,26230,26239,26250,26275,26292,26409,26431,26456,26507,26508,26529,26541,26543,26559,26571,26582,26596,26605,26618,26651,26664,26678,26685,26697,26715,26723,26725,26740,26742,26743,26749,26750,26756,26767,26768,26801,26809,26818,26859,26860,26896,26937,26960,26976,26991,27024,27025,27028,27045,27056,27058,27060,27082,27097,27155,27248,27261,27318,27417,27478,27512,27544,27567,27589,27591,27634,27737,27738,27763,27789,27811,27822,27930,27948,27957,27998,28006,28036,28135,28184,28309,28320,28342,28360,28361,28460,28472,28484,28499,28611,28620,28675,28690,28702,28755,28774,28787,28852,28887,28916,28939,29023,29123,29129,29213,29241,29249,29250,29413,29438,29533,29608,29618,29722,29799,29890,29904,32374,32392,34432,34451,34653,34750,35196,35566,35645,35841,35871,35942,37426,38380,38495,38597,38612,38666,38712,38736,38793,38846,38847,38857,38868,39025,39049,39144,39286,39385,39657,39761,40661,40681,40727,40860,40887,40972,41005,41158,41200,41217,41421,42210,42458,42486,42532,42562,42758,42948,43842,44303,45180)
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 | 620 | 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.34 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.14 ms |
System lock | 0.02 ms |
optimizing | 0.05 ms |
statistics | 1.00 ms |
preparing | 0.47 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.30 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 |