Tiempo de la consulta: 4.80 ms Después de la última consulta: 0.94 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.335 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-07 03:30:13')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 03:30:13')
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(9,45,46,54,62,65,71,168,219,255,307,389,415,607,643,659,675,764,844,900,903,970,1207,1239,1277,1281,1335,1337,1372,1384,1497,1557,1563,1571,1755,1981,2064,2084,2103,2219,2325,2404,2426,2439,2489,2563,2625,2649,2732,2814,2827,2857,2909,2916,2924,3037,3038,3196,3248,3266,3276,3285,3364,3462,3603,3685,3732,3760,3767,3776,3833,3913,3960,3980,4034,4101,4110,4114,4129,4148,4150,4204,4209,4284,4315,4323,4327,4423,4456,4548,4573,4575,4859,4940,4944,5034,5150,5259,5387,5422,5491,5827,5857,5896,5909,5977,6100,6105,6128,6141,6277,6340,6360,6362,6440,6561,6629,6644,6649,6685,6696,6720,6736,6751,6762,6791,6833,6865,6881,6906,6969,6995,7045,7077,7111,7193,7201,7216,7218,7250,7258,7282,7331,7364,7379,7412,7444,7447,7490,7545,7586,7605,7614,7618,7651,7691,7724,7752,7771,7784,7787,7829,7903,7925,7935,7942,7960,7965,8004,8015,8055,8152,8160,8227,8234,8265,8281,8370,8378,8421,8507,8550,8611,8644,8660,8663,8700,8750,8753,8799,8813,8826,8864,8909,8925,8954,9027,9036,9063,9120,9328,9346,9350,9390,9415,9477,9578,9600,9610,9738,9829,9838,9854,9878,9904,9908,9922,9956,10004,10190,10247,10265,10269,10286,10289,10304,10313,10351,10414,10448,10479,10513,10532,10554,10617,10642,10661,10713,10754,10756,10769,10912,10971,10993,11023,11031,11041,11073,11121,11150,11230,11250,11262,11286,11320,11338,11387,11399,11438,11488,11545,11611,11687,11719,11796,11821,11826,11836,11872,11891,11903,11921,12019,12076,12139,12249,12410,12553,12567,12618,12632,12638,12689,12690,12697,12750,12758,13146,13166,13188,13209,13218,13262,13376,13384,13385,13421,13456,13499,13511,13613,13659,13702,13731,13733,13738,13760,13789,13808,13911,13926,13946,13961,13996,14053,14054,14141,14249,14270,14351,14396,14512,14513,14515,14525,14532,14601,14613,14616,14662,14692,14696,14730,14739,14820,14824,14825,14841,14939,14949,14999,15006,15041,15069,15081,15148,15149,15160,15178,15193,15213,15249,15268,15270,15326,15330,15346,15347,15388,15423,15457,15465,15474,15475,15482,15487,15497,15499,15551,15565,15570,15611,15617,15635,15636,15637,15640,15668,15738,15748,15767,15783,15866,15893,15913,15926,16023,16036,16039,16042,16059,16060,16062,16082,16084,16086,16097,16127,16128,16129,16156,16164,16168,16181,16194,16248,16256,16264,16292,16314,16315,16366,16403,16552,16560,16577,16664,16759,16827,16828,16844,16890,16949,16985,16991,17004,17053,17074,17102,17115,17145,17160,17184,17216,17222,17233,17318,17389,17459,17468,17470,17491,17596,17601,17633,17650,17704,17715,17723,17776,17844,17846,17855,17859,17889,17893,17926,17966,18046,18047,18054,18062,18122,18136,18157,18180,18233,18255,18274,18292,18311,18314,18344,18362,18395,18434,18460,18539,18544,18564,18607,18608,18617,18646,18697,18709,18718,18768,18800,18846,18862,18878,18886,18916,18922,18931,18954,18975,18980,19006,19011,19020,19028,19034,19042,19064,19105,19111,19124,19128,19135,19139,19155,19201,19218,19233,19240,19247,19306,19313,19366,19530,19550,19561,19604,19637,19645,19646,19652,19713,19732,19775,19852,19872,19876,19918,19930,19945,20018,20030,20070,20127,20247,20250,20260,20264,20327,20348,20376,20393,20398,20429,20444,20461,20556,20592,20602,20635,20649,20655,20678,20741,20747,20779,20783,20784,20794,20795,20797,20809,20813,20828,20850,20888,20906,20915,20959,21000,21057,21062,21079,21107,21108,21143,21161,21166,21179,21190,21249,21286,21294,21297,21307,21325,21369,21381,21397,21420,21434,21435,21451,21458,21464,21489,21499,21510,21548,21552,21554,21578,21590,21612,21635,21641,21710,21739,21740,21744,21764,21774,21776,21777,21831,21855,21858,21878,21883,21886,21894,21944,21976,21982,22001,22010,22040,22043,22063,22128,22160,22176,22214,22237,22238,22272,22298,22313,22317,22319,22325,22347,22348,22360,22364,22367,22407,22459,22461,22533,22553,22563,22571,22582,22607,22617,22645,22647,22648,22656,22686,22711,22733,22739,22763,22770,22775,22819,22837,22853,22883,22889,22890,22904,22957,22996,23019,23065,23067,23131,23185,23188,23195,23201,23220,23231,23237,23241,23260,23280,23286,23313,23320,23325,23326,23328,23335,23339,23415,23418,23436,23488,23553,23582,23612,23673,23678,23679,23706,23737,23764,23783,23819,23822,23856,23890,23896,23960,24063,24075,24102,24104,24142,24152,24184,24191,24273,24274,24327,24366,24371,24375,24392,24419,24482,24503,24550,24576,24592,24637,24644,24646,24682,24684,24689,24702,24723,24727,24733,24750,24760,24767,24816,24837,24844,24853,24860,24863,24899,24964,24970,25041,25056,25072,25098,25107,25117,25119,25121,25123,25124,25126,25133,25138,25139,25140,25141,25142,25143,25144,25145,25146,25147,25148,25151,25153,25174,25225,25250,25253,25279,25377,25380,25394,25567,25644,25645,25696,25699,25714,25717,25730,25785,25799,25850,25923,25938,25947,25993,26041,26173,26178,26183,26256,26273,26493,26501,26504,26521,26563,26648,26765,26818,26901,26926,26938,26972,27002,27011,27024,27056,27150,27170,27246,27273,27318,27321,27362,27365,27418,27431,27478,27496,27521,27545,27575,27593,27644,27686,27704,27721,27842,27917,27931,27936,28005,28033,28045,28082,28184,28225,28303,28312,28411,28561,28639,28646,28653,28658,28961,28989,29008,29009,29032,29066,29152,29153,29174,29180,29197,29319,29329,29355,29356,29417,29443,29444,29476,29536,29697,29781,29905,29922,29923,29935,30326,30481,31853,32768,32842,34998,35617,35689,35763,35871,35883,35884,35885,36367,36447,36602,37915,38807,38831,38850,38854,38866,39481,39558,39603,39681,39857,39892,39998,40025,40038,40083,40097,40147,40170,40200,40272,40545,40708,40759,40785,40809,40907,40937,40984,41035,41059,41082,41122,41184,41255,41301,41305,41325,41375,41458,42592,42599)
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 | 961 | 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.76 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.20 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.78 ms |
preparing | 0.76 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.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 |