Tiempo de la consulta: 11.25 ms Después de la última consulta: 1.33 ms Consulta a la memoria: 1.072 MB memoria antes de la consulta: 4.401 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-08 18:29:57')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-08 18:29:57')
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,21,30,51,82,84,91,100,183,184,197,226,328,350,385,393,407,480,513,693,739,902,921,931,935,971,979,981,988,991,1001,1014,1051,1085,1104,1111,1164,1211,1280,1342,1343,1352,1354,1357,1391,1397,1408,1455,1473,1513,1535,1551,1603,1626,1632,1634,1646,1649,1693,1708,1713,1730,1731,1732,1781,1785,1800,1802,1806,1815,1822,1900,1902,1909,1913,1914,1915,1944,2117,2122,2155,2156,2209,2210,2217,2305,2337,2345,2351,2367,2378,2427,2430,2543,2598,2600,2601,2613,2632,2636,2662,2665,2668,2689,2695,2704,2795,2805,2807,2825,2957,2963,3067,3087,3114,3212,3216,3219,3337,3373,3408,3426,3454,3481,3594,3718,3719,3725,3871,4033,4051,4131,4132,4166,4215,4227,4243,4320,4473,4493,4592,4612,4613,4614,4615,4617,4699,4770,4775,4799,4832,4836,4910,4947,4957,4990,5008,5040,5079,5086,5092,5104,5121,5139,5150,5170,5173,5218,5224,5237,5268,5559,5580,5622,5627,5679,5686,5694,5714,5796,5798,5799,5814,5855,5934,5943,6039,6097,6173,6192,6264,6268,6270,6277,6324,6347,6370,6427,6446,6502,6571,6586,6603,6630,6631,6695,6750,6775,6788,6830,6839,6847,6872,6873,6910,6915,6917,6937,6977,6985,7001,7081,7082,7083,7107,7117,7134,7158,7162,7163,7164,7169,7181,7192,7205,7275,7287,7290,7294,7330,7358,7396,7416,7430,7482,7526,7565,7586,7624,7659,7663,7689,7690,7716,7717,7735,7745,7746,7799,7813,7866,7955,7958,8026,8036,8039,8056,8057,8084,8149,8280,8330,8347,8354,8416,8436,8437,8438,8444,8462,8483,8577,8659,8706,8818,8972,9012,9018,9051,9052,9091,9111,9142,9195,9196,9197,9300,9308,9330,9370,9481,9529,9658,9681,9757,9806,9865,9869,10039,10112,10186,10209,10213,10258,10260,10323,10352,10400,10422,10451,10458,10510,10603,10604,10634,10691,10693,10764,10811,10840,10956,10992,11098,11106,11107,11121,11163,11192,11305,11323,11356,11476,11612,11627,11703,11721,11722,11745,11803,11820,11859,11864,11987,11994,12083,12095,12112,12113,12144,12153,12216,12223,12254,12488,12541,12592,12609,12650,12669,12686,12708,12753,12771,12807,12843,12859,12889,12978,13010,13045,13062,13074,13154,13188,13268,13276,13321,13325,13328,13349,13352,13474,13501,13509,13535,13566,13575,13576,13644,13681,13685,13693,13727,13748,13750,13782,13783,13818,13819,13846,13868,13871,13898,13924,13930,13938,13941,13947,13968,13971,13972,14008,14048,14052,14079,14122,14156,14169,14183,14203,14263,14267,14327,14356,14357,14360,14396,14426,14430,14524,14534,14648,14651,14660,14663,14669,14679,14680,14713,14733,14749,14753,14754,14832,14838,14846,14849,14860,14862,14869,14878,14905,14906,14911,14948,14973,14987,14996,15020,15021,15038,15045,15046,15054,15110,15128,15166,15179,15181,15188,15198,15201,15208,15209,15217,15222,15230,15234,15262,15293,15298,15304,15310,15312,15352,15366,15382,15386,15421,15473,15482,15517,15528,15533,15539,15540,15550,15580,15594,15650,15666,15689,15751,15753,15784,15796,15808,15812,15845,15851,15862,15866,15870,15874,15917,15937,15945,15947,16015,16040,16050,16057,16092,16120,16122,16214,16346,16354,16415,16422,16439,16440,16455,16458,16465,16499,16508,16519,16526,16562,16578,16652,16654,16660,16678,16689,16720,16728,16737,16789,16802,16812,16862,16894,16899,16917,16927,17014,17034,17035,17052,17080,17091,17121,17130,17133,17135,17136,17141,17167,17186,17199,17304,17313,17317,17334,17335,17344,17353,17369,17385,17404,17409,17412,17439,17447,17479,17496,17511,17520,17584,17590,17597,17603,17609,17630,17635,17663,17691,17700,17809,17826,17857,17862,17871,17902,17910,17927,17939,17949,17956,17965,17976,17977,18022,18028,18029,18053,18067,18071,18165,18170,18174,18213,18227,18297,18334,18352,18356,18362,18379,18385,18473,18483,18538,18590,18595,18658,18675,18705,18707,18726,18739,18753,18782,18784,18825,18845,18873,18906,18907,18926,18958,18974,19001,19024,19039,19040,19056,19118,19122,19123,19127,19150,19153,19182,19204,19211,19232,19235,19245,19250,19252,19292,19299,19353,19358,19392,19423,19426,19432,19445,19454,19483,19484,19487,19520,19527,19547,19589,19637,19643,19658,19661,19676,19694,19706,19728,19750,19765,19767,19789,19791,19796,19798,19809,19844,19848,19849,19853,19858,19862,19875,19876,19890,19904,19916,19967,19980,19988,20003,20030,20039,20053,20066,20068,20071,20090,20092,20106,20113,20122,20157,20180,20183,20191,20220,20244,20262,20287,20288,20309,20338,20351,20360,20376,20384,20386,20391,20396,20398,20434,20437,20447,20455,20469,20470,20521,20526,20528,20565,20566,20567,20574,20592,20599,20618,20634,20642,20648,20658,20670,20688,20690,20700,20750,20751,20792,20804,20805,20833,20837,20864,20869,20894,20934,20944,20953,20964,20984,20990,21016,21040,21053,21087,21094,21101,21146,21182,21196,21198,21243,21254,21259,21327,21329,21332,21368,21404,21405,21413,21454,21487,21509,21520,21523,21524,21547,21566,21579,21598,21602,21612,21614,21648,21650,21667,21712,21719,21722,21726,21727,21747,21761,21767,21769,21773,21784,21787,21811,21817,21824,21875,21891,21932,21958,22013,22062,22067,22098,22129,22134,22137,22147,22156,22162,22172,22210,22212,22232,22241,22253,22262,22267,22329,22332,22357,22406,22409,22446,22450,22453,22466,22476,22481,22482,22484,22494,22499,22510,22514,22581,22612,22620,22659,22674,22689,22726,22739,22753,22771,22780,22781,22797,22851,22865,22869,22871,22886,22897,22914,22925,22938,22959,22964,22966,23030,23035,23036,23037,23072,23083,23099,23104,23117,23119,23123,23157,23179,23183,23184,23200,23201,23212,23213,23218,23229,23254,23257,23261,23268,23273,23277,23287,23304,23305,23309,23326,23328,23336,23340,23345,23358,23364,23365,23381,23398,23491,23504,23509,23523,23554,23571,23585,23604,23625,23628,23632,23704,23708,23720,23751,23790,23805,23813,23834,23864,23871,23885,23886,23887,23888,23890,23891,23893,23894,23897,23899,23901,23904,23905,23907,23909,23915,23921,23927,23944,23947,23964,23969,23981,23983,23986,24000,24029,24039,24040,24067,24077,24124,24145,24160,24161,24163,24187,24197,24205,24208,24225,24269,24281,24286,24294,24316,24328,24337,24338,24343,24357,24361,24390,24393,24394,24395,24425,24429,24485,24496,24497,24503,24570,24582,24587,24589,24617,24623,24678,24679,24692,24700,24744,24761,24766,24781,24782,24785,24801,24802,24803,24824,24834,24852,24871,24983,24985,24992,25032,25035,25038,25046,25062,25068,25092,25097,25171,25182,25200,25201,25214,25227,25233,25377,25405,25410,25436,25450,25493,25505,25518,25537,25548,25554,25563,25589,25621,25622,25625,25639,25646,25648,25665,25671,25673,25717,25721,25723,25727,25734,25747,25748,25757,25758,25766,25771,25772,25774,25776,25780,25790,25817,25818,25830,25836,25863,25881,25885,25889,25898,25909,25916,25924,25927,25928,25934,25941,25942,25949,25961,25990,25992,25994,25995,26000,26010,26013,26025,26033,26035,26060,26066,26082,26087,26108,26113,26120,26136,26146,26147,26153,26161,26183,26185,26187,26191,26194,26198,26215,26221,26227,26234,26259,26260,26263,26296,26328,26335,26337,26359,26360,26361,26368,26372,26378,26386,26388,26410,26424,26471,26492,26565,26576,26620,26630,26639,26646,26679,26691,26699,26724,26744,26755,26780,26784,26808,26820,26827,26845,26866,26868,26873,26879,26894,26927,26933,26935,26968,26992,27065,27074,27091,27118,27120,27138,27211,27212,27216,27240,27270,27287,27322,27323,27327,27347,27367,27404,27405,27406,27407,27408,27423,27465,27473,27487,27492,27526,27541,27550,27568,27570,27578,27583,27592,27595,27601,27671,27688,27707,27717,27758,27786,27806,27833,27922,27924,28019,28031,28059,28066,28075,28094,28097,28114,28120,28129,28153,28162,28168,28192,28228,28230,28243,28264,28329,28354,28435,28673,28799,28800,28838,28846,28931,28943,29011,29028,29045,29100,29266,29611,29616,29639,29724,29769,29866,30111,30540,30556,30804,31551,31608,31735,31820,31827,31837,31853,32084,32369,32720,32767,32768,32862,33251,33415,33716,33874,33908,33925,33946,33957,34025,34275,34331,34616,34646,34693,34728,34811,34815,35220,35227,35232,35238,35239,35289,35295,35339,35345,35365,35376,35397,35426,35444,35476,35477,35490,35554,35556,35621,35688,35728,35743,35805,35806,35808,35814,35835,35846,35882,35947,35948,35956,36000,36015,36128,36141,36220,36237,36298,36368,36369,36373,36380,36385,36386,36420,36441,36584,36917,36930,36989,36998,37010,37011,37136,37147,37245,37283,37307,37308,37378,37534,37544,37626,37644,37677,37902,38058,38092,38126,38133,38330,38433,38489,38546,38617,38723,38799,38821,38824,38829,38877,38904,38912,38922,38949,38965,38990,39155,39205,39290,39293,39296,39366,39442,39476,39491,39497,39559,39587,39610,39686,39717,39724,39987,40319,40509,40560,40624,40647,41062,41171,41289,41332,41345,41516,41781,41969,42637,42987,43003,43016,43109,43165,43237,43271,43405,43446,43461,43483,43712,44062,44366,44564,44573,44718,44785,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 | 1489 | 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.65 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.32 ms |
System lock | 0.02 ms |
optimizing | 0.10 ms |
statistics | 2.35 ms |
preparing | 1.14 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 5.60 ms |
end | 0.02 ms |
query end | 0.03 ms |
closing tables | 0.02 ms |
freeing items | 0.07 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 |