Tiempo de la consulta: 6.62 ms Después de la última consulta: 0.96 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 4.237 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:06:40')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 01:06:40')
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,29,39,45,46,54,62,65,71,85,120,121,122,123,124,165,175,180,185,282,284,355,415,417,437,446,453,458,546,643,659,669,670,671,728,741,746,764,800,839,870,954,959,977,986,987,1011,1081,1123,1207,1277,1304,1308,1335,1363,1563,1571,2023,2084,2121,2131,2223,2242,2427,2456,2569,2610,2647,2713,2853,2856,2909,3059,3152,3169,3196,3219,3229,3266,3291,3412,3449,3498,3685,3700,3760,3767,3776,3784,3833,3911,3913,3960,3980,4034,4038,4101,4110,4129,4148,4150,4177,4204,4284,4323,4327,4333,4423,4456,4531,4548,4575,4674,4676,4710,4748,4859,4940,5187,5211,5259,5300,5387,5422,5479,5725,5909,5977,6100,6128,6351,6360,6362,6440,6649,6720,6748,6841,6865,6881,6895,6955,6994,7077,7111,7216,7250,7258,7321,7331,7343,7364,7389,7436,7444,7459,7494,7510,7516,7547,7551,7581,7586,7601,7605,7614,7618,7651,7676,7682,7724,7752,7771,7779,7784,7787,7805,7829,7830,7847,7851,7860,7903,7925,7935,7942,7954,7960,7965,7984,8004,8055,8111,8152,8159,8160,8227,8234,8265,8370,8378,8421,8507,8550,8555,8611,8644,8660,8661,8700,8750,8753,8799,8813,8826,8864,8925,8954,9063,9120,9328,9350,9390,9429,9477,9491,9578,9600,9610,9738,9829,9838,9854,9861,9878,9904,9908,9922,9956,10004,10190,10265,10269,10313,10412,10414,10448,10453,10513,10536,10540,10611,10617,10642,10668,10754,10756,10771,10993,11023,11031,11035,11041,11060,11073,11095,11121,11142,11207,11229,11250,11286,11295,11338,11387,11417,11427,11488,11545,11594,11687,11796,11921,12096,12121,12156,12249,12299,12444,12553,12559,12563,12632,12638,12689,12690,12692,13146,13166,13209,13376,13385,13404,13702,13731,13738,13760,13789,13921,13946,13961,13996,14077,14105,14141,14151,14163,14180,14246,14266,14351,14396,14414,14454,14512,14513,14514,14515,14532,14601,14616,14624,14632,14634,14662,14701,14726,14730,14739,14759,14820,14824,14825,14895,14939,14961,14999,15006,15041,15068,15069,15081,15111,15148,15151,15160,15178,15193,15214,15268,15273,15302,15326,15334,15347,15351,15388,15423,15425,15426,15457,15465,15482,15487,15551,15570,15574,15582,15611,15617,15636,15637,15640,15725,15726,15738,15750,15767,15783,15866,15900,15906,15913,15949,16001,16036,16038,16039,16042,16059,16082,16084,16097,16127,16129,16156,16163,16181,16248,16256,16270,16292,16301,16305,16314,16315,16324,16403,16498,16552,16577,16620,16623,16653,16715,16759,16828,16841,16876,16890,16942,16963,16967,16991,17000,17053,17062,17074,17088,17102,17115,17130,17138,17145,17160,17193,17216,17218,17222,17233,17277,17425,17427,17468,17486,17498,17500,17538,17585,17625,17633,17650,17706,17715,17732,17753,17754,17761,17813,17844,17846,17855,17859,17893,17926,17966,18001,18008,18054,18062,18109,18111,18122,18128,18143,18157,18180,18183,18222,18233,18247,18255,18260,18261,18292,18311,18314,18344,18362,18459,18460,18495,18520,18539,18544,18554,18564,18608,18625,18692,18699,18709,18762,18800,18846,18862,18878,18916,18922,18931,18954,18961,18975,18980,19000,19001,19018,19028,19034,19042,19077,19080,19105,19124,19128,19135,19152,19155,19185,19194,19218,19226,19240,19247,19260,19313,19323,19351,19355,19366,19368,19416,19437,19453,19486,19504,19530,19550,19561,19578,19601,19604,19626,19637,19648,19652,19663,19713,19732,19733,19807,19818,19827,19852,19857,19872,19874,19918,19934,19945,19946,19949,19956,19978,20000,20018,20030,20053,20127,20174,20243,20250,20253,20256,20260,20264,20304,20327,20348,20376,20389,20393,20429,20443,20444,20461,20489,20498,20524,20602,20630,20635,20649,20678,20702,20710,20718,20720,20741,20777,20779,20784,20797,20798,20813,20826,20828,20850,20870,20906,20915,20957,20959,20982,21000,21005,21057,21062,21074,21107,21108,21109,21135,21143,21160,21161,21170,21190,21226,21249,21253,21313,21325,21369,21381,21397,21401,21433,21434,21435,21458,21464,21468,21489,21505,21536,21545,21552,21554,21578,21581,21590,21593,21618,21641,21672,21682,21710,21733,21740,21744,21764,21776,21777,21837,21851,21855,21858,21878,21883,21894,21906,21944,21976,21982,22010,22040,22063,22098,22127,22141,22160,22176,22183,22214,22216,22222,22228,22237,22273,22277,22283,22298,22313,22320,22328,22348,22363,22407,22432,22446,22459,22461,22468,22508,22563,22617,22647,22688,22706,22733,22739,22763,22781,22804,22819,22837,22877,22889,22890,22904,22957,22976,22985,23012,23065,23067,23081,23127,23130,23131,23185,23189,23195,23201,23209,23237,23241,23251,23260,23280,23307,23313,23318,23320,23325,23326,23328,23335,23339,23463,23527,23555,23568,23574,23575,23582,23611,23678,23679,23698,23730,23746,23778,23779,23786,23837,23880,23883,23889,23890,23895,23917,23921,23988,23994,24064,24075,24082,24101,24102,24104,24116,24144,24150,24152,24191,24255,24273,24274,24282,24292,24327,24328,24366,24371,24390,24392,24503,24536,24574,24577,24592,24641,24644,24667,24668,24727,24733,24812,24816,24837,24844,24888,24899,24928,24958,24964,25035,25069,25072,25098,25107,25125,25133,25225,25253,25274,25285,25326,25377,25380,25443,25445,25548,25644,25645,25671,25680,25691,25714,25724,25730,25785,25847,25850,25993,26026,26042,26064,26066,26177,26178,26183,26254,26256,26273,26331,26379,26471,26493,26501,26504,26507,26521,26563,26582,26648,26666,26829,26860,26901,26926,26937,26972,26986,27002,27011,27045,27122,27150,27153,27156,27162,27170,27175,27184,27200,27206,27207,27210,27213,27215,27246,27273,27302,27316,27321,27330,27351,27353,27354,27367,27412,27418,27421,27431,27438,27445,27448,27455,27463,27480,27483,27489,27490,27496,27512,27521,27545,27567,27581,27593,27644,27685,27686,27697,27698,27704,27721,27783,27809,27827,27842,27854,27861,27864,27866,27867,27878,27884,27886,27891,27901,27904,27913,27917,27931,27936,27939,27965,28005,28033,28045,28051,28053,28082,28169,28225,28305,28312,28336,28341,28392,28411,28575,28594,28639,28653,28658,28702,28989,29008,29009,29152,29153,29174,29197,29249,29319,29356,29372,29417,29443,29444,29476,29781,29905,29922,29923,29933,29935,30723,31850,31907,32049,32374,32768,32842,34793,35495,35617,35689,35798,35883,35885,35962,36033,36135,36398,36461,37125,37735,37906,37907,38448,38451,38549,38574,38602,38666,38807,38831,38854,38866,38910,39135,39481,39511,39598,39603,39634,39681,39816,39857,40025,40038,40050,40083,40097,40170,40200,40251,40279,40326,40585,40603,40708,40759,40778,40785,40803,40808,40809,40829,40907,40937,40941,40984,41059,41255,41299,41301,41325,41375,41522,41566,41622,41747,41816,41840,42021,42159,42259,42331,42500,42701,42789,42852,43488,43564,43592,43609,43653,43815,43816,44114,44185,44224,44270,44809,44868,45276)
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 | 1113 | 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.82 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.37 ms |
System lock | 0.03 ms |
optimizing | 0.12 ms |
statistics | 2.76 ms |
preparing | 1.36 ms |
Sorting result | 0.06 ms |
executing | 0.01 ms |
Sending data | 0.48 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.09 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 |