Tiempo de la consulta: 11.44 ms Después de la última consulta: 1.19 ms Consulta a la memoria: 1.072 MB memoria antes de la consulta: 4.531 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 07:59:47')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 07:59:47')
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,25,30,51,75,82,85,94,109,120,121,122,123,124,165,175,180,183,184,185,194,195,197,203,226,233,239,241,255,256,272,284,328,350,353,354,361,371,376,393,407,414,417,458,519,545,581,670,693,707,728,739,741,772,870,891,902,935,987,988,1013,1033,1054,1067,1080,1081,1085,1123,1129,1148,1207,1242,1254,1257,1277,1280,1284,1298,1304,1335,1354,1391,1455,1513,1535,1603,1634,1646,1693,1800,1802,1822,1900,1913,1915,1924,2023,2122,2156,2217,2305,2322,2337,2367,2378,2410,2424,2530,2598,2600,2601,2607,2610,2632,2636,2668,2689,2713,2807,2894,2963,3067,3087,3106,3107,3208,3212,3329,3337,3373,3408,3463,3718,3719,3725,3786,3787,3871,3911,4131,4133,4243,4320,4378,4473,4587,4710,4775,4799,4832,4836,4848,4910,4947,4957,4990,5040,5079,5086,5104,5139,5150,5170,5173,5224,5322,5451,5559,5622,5649,5679,5686,5796,5799,5814,5847,5855,5894,5934,6039,6062,6097,6147,6173,6264,6270,6277,6386,6393,6427,6446,6484,6571,6695,6775,6788,6830,6839,6847,6873,6910,6915,6917,6937,6945,6955,6985,6994,7082,7083,7105,7107,7117,7134,7158,7271,7275,7287,7290,7294,7304,7330,7356,7358,7374,7416,7459,7526,7547,7567,7586,7588,7624,7659,7663,7717,7726,7745,7746,7813,7830,7851,7860,7866,7950,7955,7958,7965,7998,8026,8027,8036,8039,8056,8057,8115,8191,8280,8330,8347,8354,8416,8462,8464,8502,8555,8764,8806,9010,9012,9018,9029,9052,9062,9111,9196,9197,9198,9300,9318,9351,9370,9452,9491,9574,9658,9681,9767,9860,9865,9869,9924,10078,10100,10112,10120,10186,10188,10209,10213,10258,10323,10352,10364,10369,10400,10412,10540,10603,10604,10613,10691,10693,10757,10764,10765,10811,10925,10956,11008,11035,11060,11098,11107,11121,11150,11163,11178,11192,11229,11235,11269,11305,11356,11366,11391,11404,11476,11612,11625,11745,11820,11859,11864,11969,11987,11994,12083,12095,12112,12113,12144,12216,12223,12224,12254,12388,12444,12445,12519,12541,12559,12563,12567,12609,12669,12670,12688,12753,12771,12807,12843,12889,12902,12940,12978,13010,13036,13038,13040,13045,13062,13074,13189,13268,13321,13325,13328,13352,13427,13506,13509,13534,13535,13575,13576,13644,13649,13681,13693,13727,13748,13782,13783,13792,13818,13819,13846,13868,13871,13924,13930,13938,13941,13969,13971,14009,14052,14079,14122,14151,14156,14203,14229,14246,14249,14267,14293,14327,14356,14426,14430,14495,14524,14602,14603,14608,14634,14648,14651,14660,14663,14669,14679,14680,14713,14727,14733,14746,14753,14766,14838,14849,14850,14860,14862,14869,14878,14895,14905,14911,14948,14961,14973,14977,14987,15003,15020,15021,15024,15038,15045,15046,15054,15110,15114,15151,15166,15179,15181,15188,15197,15198,15201,15208,15209,15234,15262,15293,15298,15304,15306,15311,15312,15315,15333,15352,15386,15421,15473,15475,15482,15496,15517,15522,15528,15550,15580,15594,15650,15667,15751,15753,15784,15808,15812,15870,15874,15904,15917,15937,15947,16001,16014,16057,16092,16122,16214,16365,16422,16440,16450,16455,16458,16465,16488,16499,16500,16508,16519,16526,16623,16654,16660,16689,16720,16737,16789,16802,16812,16894,16899,16907,16917,16927,16983,17035,17039,17046,17052,17060,17080,17090,17091,17132,17133,17135,17141,17142,17151,17186,17199,17317,17334,17335,17339,17344,17369,17409,17412,17456,17470,17479,17486,17520,17538,17584,17585,17590,17603,17609,17691,17700,17710,17753,17761,17810,17826,17857,17862,17870,17871,17902,17927,17931,17949,17956,17961,17965,17988,18022,18028,18029,18032,18067,18143,18165,18170,18213,18227,18260,18261,18274,18356,18362,18364,18385,18459,18465,18473,18494,18509,18520,18538,18595,18612,18629,18675,18705,18707,18726,18751,18753,18784,18804,18825,18845,18850,18856,18873,18901,18906,18907,18916,18926,18944,18958,18961,18974,19005,19007,19018,19024,19039,19040,19118,19123,19127,19134,19150,19152,19153,19154,19204,19211,19226,19232,19235,19252,19260,19287,19299,19353,19358,19390,19420,19423,19426,19432,19454,19483,19484,19487,19527,19589,19601,19624,19643,19645,19646,19648,19652,19658,19663,19676,19728,19733,19750,19767,19768,19791,19848,19849,19858,19862,19875,19876,19890,19903,19932,19938,19967,19988,20003,20020,20023,20030,20039,20066,20068,20071,20088,20090,20092,20095,20106,20122,20161,20183,20191,20220,20243,20244,20256,20262,20264,20303,20309,20350,20384,20386,20389,20391,20400,20408,20437,20455,20469,20472,20526,20528,20565,20566,20574,20592,20599,20618,20634,20639,20642,20648,20670,20688,20710,20750,20751,20792,20798,20803,20804,20847,20869,20894,20919,20944,20964,20984,20990,21040,21053,21087,21182,21196,21198,21243,21255,21259,21327,21329,21332,21404,21405,21433,21454,21487,21491,21498,21520,21526,21547,21556,21579,21598,21602,21614,21618,21667,21712,21722,21726,21740,21746,21747,21751,21761,21767,21769,21773,21782,21811,21824,21868,21870,21891,21932,21958,22013,22082,22099,22113,22129,22134,22156,22162,22172,22175,22194,22210,22212,22222,22228,22253,22254,22262,22267,22315,22329,22332,22344,22409,22430,22446,22453,22466,22476,22481,22484,22494,22499,22514,22554,22572,22581,22596,22612,22659,22674,22689,22694,22695,22713,22726,22739,22753,22781,22797,22804,22865,22869,22886,22900,22914,22925,22964,22966,22976,22999,23022,23036,23037,23077,23078,23099,23100,23104,23119,23123,23184,23185,23200,23212,23213,23218,23229,23243,23251,23254,23257,23261,23268,23287,23304,23309,23326,23328,23336,23340,23358,23364,23371,23381,23424,23451,23491,23492,23504,23554,23555,23571,23585,23604,23618,23625,23628,23632,23703,23704,23708,23721,23751,23779,23790,23805,23813,23834,23871,23885,23886,23887,23888,23890,23891,23893,23897,23899,23901,23904,23905,23907,23909,23927,23947,23962,23964,23969,23981,23983,23986,23988,24000,24012,24029,24039,24040,24077,24093,24144,24160,24161,24163,24168,24176,24187,24197,24208,24241,24264,24269,24281,24286,24292,24294,24316,24337,24343,24357,24361,24394,24429,24496,24499,24503,24579,24587,24589,24605,24617,24678,24679,24692,24781,24782,24785,24801,24802,24822,24832,24834,24841,24855,24871,24909,24915,24928,24941,24943,24977,24983,24985,25032,25035,25048,25068,25081,25091,25097,25147,25156,25182,25200,25201,25227,25230,25233,25293,25303,25333,25348,25377,25450,25505,25548,25560,25621,25622,25639,25648,25671,25680,25711,25723,25731,25747,25757,25766,25790,25818,25863,25885,25898,25909,25922,25927,25928,25949,25987,26000,26013,26053,26066,26099,26113,26188,26221,26245,26284,26296,26335,26359,26368,26372,26386,26494,26505,26565,26576,26620,26639,26646,26671,26691,26744,26755,26771,26784,26820,26827,26845,26868,26873,26968,27065,27153,27161,27178,27188,27211,27212,27213,27216,27220,27317,27321,27323,27347,27367,27401,27404,27407,27408,27423,27460,27529,27541,27583,27592,27595,27601,27671,27717,27758,27775,27786,27827,27916,27939,27949,27956,27968,27969,27992,28030,28031,28059,28066,28075,28094,28097,28114,28120,28129,28153,28162,28168,28169,28192,28230,28243,28336,28354,28435,28548,28552,28639,28673,28844,28846,28847,29011,29028,29045,29121,29143,29174,29266,29639,29743,29769,29866,29888,30000,30293,31026,31608,31850,31907,32058,32084,32484,33874,33914,33925,33946,33957,34025,34275,34331,34616,34646,34693,34811,34815,35220,35227,35238,35239,35289,35376,35397,35426,35444,35490,35554,35556,35621,35688,35743,35805,35882,35948,36000,36015,36128,36220,36237,36330,36368,36369,36373,36385,36420,36441,36584,36917,36930,36989,36998,37010,37011,37136,37147,37245,37283,37307,37308,37378,37534,37626,37644,38058,38126,38133,38330,38433,38489,38546,38824,38877,38904,38922,38949,39205,39241,39285,39290,39296,39476,39497,39587,39610,39629,39717,39987,40023,40319,40509,40560,40647,41062,41332,41345,41516,41781,41969,42637,42987,43016,43032,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 | 1335 | 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.63 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.25 ms |
System lock | 0.02 ms |
optimizing | 0.09 ms |
statistics | 2.03 ms |
preparing | 0.99 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 6.45 ms |
end | 0.03 ms |
query end | 0.04 ms |
closing tables | 0.03 ms |
freeing items | 0.34 ms |
cleaning up | 0.04 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 |