Tiempo de la consulta: 9.96 ms Después de la última consulta: 1.01 ms Consulta a la memoria: 1.072 MB memoria antes de la consulta: 4.346 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-03 23:12:04')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-03 23:12:04')
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(13,30,51,82,183,184,197,226,328,350,385,393,407,474,489,583,622,672,681,692,693,710,796,893,902,935,1085,1273,1280,1317,1323,1354,1391,1395,1455,1513,1535,1603,1634,1646,1693,1713,1718,1800,1802,1822,1873,1880,1900,1913,1915,2065,2122,2156,2211,2217,2305,2337,2367,2378,2388,2424,2433,2492,2598,2600,2601,2613,2632,2636,2668,2689,2805,2963,2997,3000,3049,3067,3071,3087,3095,3212,3214,3216,3337,3373,3408,3718,3719,3725,3800,3871,3918,3953,3988,4033,4131,4320,4381,4434,4473,4770,4832,4910,4932,4947,4957,4978,4990,5040,5079,5086,5104,5139,5150,5170,5173,5195,5237,5263,5268,5336,5559,5563,5575,5622,5686,5798,5799,5814,6038,6039,6097,6107,6115,6173,6195,6264,6268,6270,6446,6531,6548,6571,6695,6784,6830,6839,6847,6873,6910,6915,6917,6937,6985,7082,7083,7098,7117,7134,7172,7205,7294,7330,7358,7396,7416,7482,7520,7526,7567,7624,7659,7663,7714,7717,7745,7759,7813,7866,7958,7967,7996,8026,8036,8039,8054,8056,8057,8114,8330,8347,8354,8415,8416,8438,8462,8521,8848,8972,9012,9018,9131,9188,9196,9197,9206,9300,9330,9345,9370,9404,9481,9516,9529,9642,9658,9799,9865,9869,9970,10112,10186,10217,10254,10352,10400,10402,10486,10603,10604,10655,10678,10691,10764,10811,10879,10956,11098,11106,11107,11121,11138,11159,11163,11238,11356,11407,11455,11476,11541,11627,11722,11820,11859,11864,11927,11989,11994,12037,12083,12095,12113,12123,12144,12146,12202,12216,12223,12254,12263,12372,12381,12541,12592,12609,12655,12669,12708,12771,12807,12889,12893,12896,12903,12926,12976,12993,13023,13045,13073,13074,13080,13139,13164,13230,13232,13268,13296,13297,13314,13321,13328,13336,13343,13352,13411,13501,13509,13535,13575,13576,13681,13682,13685,13693,13711,13727,13748,13750,13754,13782,13783,13846,13856,13868,13875,13924,13938,13941,14012,14017,14041,14052,14073,14091,14122,14176,14199,14203,14214,14242,14268,14288,14304,14327,14338,14356,14427,14430,14469,14524,14549,14562,14563,14574,14648,14656,14663,14669,14679,14733,14747,14766,14778,14813,14846,14860,14862,14905,14906,14948,14970,14973,14987,15020,15021,15045,15046,15047,15061,15066,15110,15166,15175,15179,15185,15197,15201,15208,15209,15218,15234,15250,15262,15293,15298,15304,15310,15315,15332,15386,15421,15473,15482,15517,15528,15532,15540,15550,15566,15594,15650,15731,15732,15751,15753,15784,15851,15870,15929,15937,15947,15980,16053,16057,16094,16122,16123,16202,16214,16377,16422,16440,16441,16448,16455,16465,16497,16519,16526,16585,16589,16624,16654,16676,16689,16720,16728,16732,16737,16758,16802,16811,16812,16813,16857,16894,16897,16917,17064,17089,17133,17136,17146,17150,17169,17199,17209,17263,17317,17334,17335,17344,17363,17369,17378,17393,17409,17412,17417,17424,17436,17450,17462,17479,17488,17507,17513,17520,17584,17590,17591,17597,17603,17609,17630,17635,17684,17697,17700,17724,17739,17788,17808,17815,17826,17857,17862,17884,17902,17910,17927,17949,17956,17964,17965,17976,17977,18028,18029,18067,18138,18165,18170,18182,18213,18227,18243,18245,18362,18383,18473,18538,18564,18595,18599,18675,18678,18686,18707,18726,18753,18771,18777,18795,18817,18825,18829,18835,18838,18845,18853,18906,18907,18917,18926,18958,18972,18974,18992,19019,19024,19036,19039,19040,19123,19127,19150,19153,19157,19159,19161,19164,19167,19204,19211,19216,19232,19235,19252,19286,19299,19328,19353,19358,19398,19423,19426,19432,19436,19454,19466,19483,19484,19487,19525,19527,19557,19558,19575,19579,19643,19644,19676,19701,19706,19708,19740,19750,19755,19767,19769,19791,19796,19829,19842,19858,19876,19895,19924,19952,19963,19967,19988,20003,20027,20030,20039,20062,20066,20068,20092,20093,20122,20183,20211,20227,20262,20298,20307,20309,20323,20326,20338,20384,20386,20395,20396,20401,20434,20437,20442,20469,20475,20521,20526,20528,20544,20565,20566,20574,20592,20618,20642,20648,20670,20688,20728,20750,20751,20754,20791,20792,20804,20864,20884,20894,20934,20944,20946,20953,20964,20984,20990,21048,21053,21087,21109,21176,21182,21186,21196,21198,21243,21259,21308,21327,21329,21332,21359,21362,21404,21405,21414,21454,21487,21528,21535,21547,21598,21602,21614,21616,21653,21722,21726,21747,21758,21761,21767,21769,21773,21811,21824,21826,21830,21874,21891,21897,21932,21958,21978,22064,22070,22084,22092,22129,22134,22137,22156,22162,22165,22172,22253,22262,22267,22271,22275,22290,22409,22448,22453,22466,22481,22484,22494,22497,22499,22511,22549,22551,22578,22581,22610,22638,22665,22685,22704,22716,22726,22739,22753,22781,22782,22797,22823,22824,22832,22851,22865,22869,22871,22886,22914,22925,22927,22945,22959,22964,22982,23036,23037,23038,23061,23083,23099,23104,23114,23119,23123,23184,23213,23218,23229,23254,23257,23268,23287,23309,23328,23364,23381,23398,23419,23472,23491,23504,23508,23531,23551,23554,23590,23595,23604,23628,23632,23704,23751,23777,23805,23809,23813,23842,23885,23886,23887,23888,23890,23891,23893,23897,23899,23901,23904,23905,23907,23921,23927,23964,23981,23983,23985,23986,24000,24022,24029,24039,24040,24067,24077,24160,24163,24197,24244,24294,24316,24337,24429,24485,24496,24503,24527,24537,24587,24589,24617,24664,24678,24679,24691,24781,24782,24783,24785,24831,24834,24871,24971,24983,25032,25038,25068,25077,25153,25191,25198,25201,25233,25377,25433,25450,25482,25505,25548,25562,25593,25621,25622,25673,25717,25723,25757,25802,25818,25842,25863,25871,25909,25927,25928,26000,26066,26079,26113,26153,26296,26335,26372,26386,26388,26565,26576,26620,26630,26639,26646,26691,26699,26784,26820,26845,26879,26935,27010,27065,27212,27216,27323,27347,27367,27398,27408,27423,27492,27541,27568,27570,27583,27592,27595,27601,27671,27717,27758,27770,27786,28004,28031,28059,28066,28075,28094,28097,28114,28120,28129,28162,28168,28192,28230,28243,28329,28435,28479,28673,28925,29011,29045,29266,29639,29769,29866,30234,31608,32084,33925,33946,33957,34025,34114,34275,34331,34616,34646,34693,34811,34815,35220,35227,35238,35239,35289,35376,35397,35426,35444,35490,35554,35556,35621,35688,35805,35806,35808,35882,35948,36000,36015,36220,36237,36368,36369,36373,36385,36420,36441,36584,36917,36930,36989,36998,37010,37136,37147,37283,37307,37308,37378,37534,37626,37644,38005,38058,38126,38133,38330,38433,38489,38546,38824,38877,38904,38922,38949,39067,39205,39290,39296,39476,39497,39587,39610,39717,39833,40319,40509,40560,40647,40810,41062,41136,41332,41345,41516,41781,41969,42637,42987,43016,43109,43165,43237,43271,43405,43446,43461,43483,43712,44062,44366,44573,44718,44788,44807,44829,44873,44912,44935,44936,44988,45101,45138,45235,45263,45264,45316)
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 | 1117 | 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.50 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.22 ms |
System lock | 0.02 ms |
optimizing | 0.08 ms |
statistics | 1.72 ms |
preparing | 0.86 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 5.96 ms |
end | 0.02 ms |
query end | 0.07 ms |
closing tables | 0.02 ms |
freeing items | 0.17 ms |
cleaning up | 0.09 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 |