Tiempo de la consulta: 3.36 ms Después de la última consulta: 0.56 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.197 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-05 01:43:08')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 01:43:08')
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,466,471,840,1148,1280,1397,1464,1502,1503,1720,1803,2014,2048,2109,2396,2627,2631,2719,2767,2799,3021,3570,3606,3617,3682,3715,3974,4114,4244,4285,4289,4306,4310,4355,5026,5484,5530,5537,5669,5675,5849,5874,5934,6136,6166,6608,6642,6653,6729,6833,6912,6925,6933,7007,7162,7163,7164,7251,7264,7343,7348,7382,7383,7436,7447,7679,7719,7840,7854,8045,8201,8353,8372,8397,8430,8441,8444,8555,8567,8583,8730,8751,8799,8903,9304,9326,9514,9629,9875,10033,10160,10163,10169,10272,10381,10434,10443,10453,10483,10484,10512,10554,10607,10661,10764,10771,11021,11077,11161,11365,11417,11427,11553,11716,11828,12019,12256,12520,12650,12669,12692,12790,12933,13019,13219,13251,13312,13323,13325,13334,13551,13569,13583,13600,13604,13605,13610,13644,13646,13975,14094,14141,14180,14246,14266,14352,14375,14491,14599,14613,14624,14632,14701,14710,14725,14751,14760,14993,15045,15048,15094,15171,15214,15273,15281,15351,15363,15426,15475,15487,15582,15677,15714,15724,15726,15750,15753,15759,15785,15796,15813,15820,15844,15949,15953,16038,16155,16186,16200,16213,16236,16305,16322,16366,16430,16486,16497,16537,16564,16571,16623,16673,16742,16821,16876,16903,16908,16963,17066,17088,17109,17166,17198,17266,17317,17406,17411,17422,17431,17605,17630,17652,17715,17846,17949,18008,18024,18106,18109,18128,18164,18318,18374,18453,18458,18537,18605,18608,18625,18666,18698,18699,18718,18864,18985,18989,19000,19107,19160,19190,19191,19234,19235,19259,19368,19504,19571,19580,19626,19627,19705,19807,19818,19877,19888,19903,19919,19946,19948,19951,19962,19978,19980,20018,20020,20089,20105,20120,20147,20169,20186,20226,20294,20312,20343,20359,20371,20388,20431,20498,20513,20523,20596,20608,20672,20721,20777,20784,20870,20906,21031,21074,21110,21122,21134,21135,21137,21160,21177,21231,21339,21425,21505,21510,21512,21605,21665,21670,21733,21765,21816,21819,21878,21947,21967,22027,22110,22114,22122,22144,22149,22185,22191,22205,22208,22216,22218,22221,22254,22273,22277,22305,22312,22383,22422,22430,22445,22484,22605,22654,22706,22768,22795,22877,22889,22909,22919,23001,23053,23076,23112,23189,23209,23263,23306,23307,23326,23359,23367,23393,23444,23458,23486,23532,23551,23600,23627,23689,23698,23709,23770,23786,23883,23895,23917,23941,23957,23994,24020,24064,24086,24114,24137,24278,24297,24423,24471,24481,24536,24559,24571,24574,24635,24641,24684,24756,24807,24812,24822,25017,25022,25027,25111,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,25781,25799,25807,25820,25847,25884,25907,25908,25935,25947,25948,25958,25967,25971,26010,26030,26064,26133,26177,26186,26193,26225,26230,26239,26250,26260,26292,26391,26409,26431,26456,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,26963,26976,26991,27025,27028,27045,27056,27060,27082,27097,27109,27155,27248,27261,27318,27417,27434,27478,27512,27544,27551,27567,27589,27591,27622,27634,27655,27737,27738,27763,27789,27811,27822,27930,27948,27957,27987,27992,27998,28006,28036,28091,28135,28184,28193,28241,28309,28320,28342,28360,28361,28460,28472,28620,28675,28690,28702,28755,28852,28916,29023,29063,29123,29129,29241,29249,29250,29413,29438,29533,29608,29618,29714,29720,29746,29799,29890,29904,29920,32374,32642,32643,34432,34451,34653,34750,34838,35196,35645,35871,36176,36490,36583,36596,36854,37362,37426,37976,38274,38375,38666,38810,38871,39161,39286,39580,39677,39758,39761,40181,40661,40727,40777,40860,40887,41158,41200,41217,41398,41421,41528,41814,42035,42066,42297,42486,42758,42888,43667,43678)
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 | 632 | 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.35 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.17 ms |
System lock | 0.02 ms |
optimizing | 0.05 ms |
statistics | 1.06 ms |
preparing | 0.64 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.37 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.05 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 |