Tiempo de la consulta: 27.75 ms Después de la última consulta: 1.51 ms Consulta a la memoria: 3.127 MB memoria antes de la consulta: 4.594 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 05:31:14')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 05:31:14')
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,80,82,183,184,197,226,317,328,350,385,393,407,440,468,693,790,902,935,946,991,1001,1022,1085,1104,1167,1172,1205,1280,1352,1354,1357,1391,1455,1498,1513,1533,1535,1603,1634,1646,1693,1713,1781,1785,1800,1802,1804,1822,1828,1860,1900,1913,1915,1959,2018,2027,2121,2122,2156,2210,2217,2289,2305,2310,2337,2367,2378,2424,2451,2465,2598,2600,2601,2613,2632,2636,2668,2685,2689,2805,2825,2963,3067,3087,3212,3216,3337,3373,3381,3408,3439,3594,3718,3719,3725,3871,3872,3961,4033,4051,4061,4118,4131,4166,4191,4215,4227,4320,4392,4473,4493,4612,4613,4614,4615,4617,4770,4832,4910,4947,4957,4990,5040,5079,5086,5092,5104,5139,5150,5168,5170,5173,5222,5237,5268,5413,5543,5559,5622,5686,5755,5798,5799,5814,5943,6039,6097,6133,6141,6172,6173,6192,6264,6268,6270,6278,6279,6288,6324,6335,6446,6529,6571,6586,6614,6695,6718,6788,6830,6839,6847,6873,6910,6915,6917,6937,6977,6985,7041,7081,7082,7083,7117,7125,7134,7205,7294,7330,7358,7389,7396,7416,7482,7514,7526,7565,7624,7633,7648,7659,7663,7686,7690,7717,7735,7745,7758,7799,7813,7820,7866,7958,7964,8001,8020,8021,8026,8036,8039,8056,8057,8198,8239,8313,8330,8347,8354,8416,8436,8437,8438,8462,8504,8588,8657,8706,8808,8849,8858,8901,8972,9012,9015,9016,9018,9051,9073,9077,9086,9091,9139,9142,9196,9197,9207,9211,9238,9300,9308,9330,9346,9370,9437,9481,9529,9653,9654,9658,9754,9757,9785,9853,9865,9869,9905,9969,9990,10039,10068,10112,10138,10186,10260,10352,10400,10422,10458,10510,10603,10604,10634,10646,10691,10764,10802,10811,10827,10840,10849,10956,11098,11106,11107,11121,11142,11163,11179,11305,11323,11356,11461,11476,11542,11627,11702,11703,11715,11721,11722,11803,11820,11859,11864,11994,12013,12083,12095,12113,12144,12216,12223,12250,12254,12341,12393,12454,12488,12541,12567,12592,12609,12650,12669,12672,12686,12708,12735,12746,12750,12771,12807,12818,12830,12889,12917,13045,13074,13154,13188,13268,13276,13321,13328,13349,13352,13474,13501,13509,13535,13575,13576,13681,13685,13693,13727,13748,13750,13773,13782,13783,13816,13846,13868,13924,13938,13941,13947,14008,14020,14027,14052,14079,14118,14122,14125,14154,14169,14202,14203,14263,14291,14327,14340,14356,14357,14426,14430,14522,14524,14648,14663,14669,14679,14713,14733,14746,14749,14754,14769,14814,14832,14846,14860,14862,14905,14906,14911,14930,14948,14973,14987,14995,14996,15020,15021,15045,15046,15110,15166,15179,15201,15207,15208,15209,15217,15222,15234,15262,15293,15298,15304,15310,15313,15366,15386,15409,15415,15421,15473,15482,15517,15528,15539,15540,15550,15594,15613,15650,15689,15706,15751,15753,15784,15796,15851,15862,15870,15917,15937,15947,16027,16034,16057,16081,16120,16122,16150,16214,16220,16235,16346,16354,16422,16440,16465,16519,16526,16562,16578,16654,16671,16678,16689,16716,16720,16728,16737,16802,16812,16826,16887,16894,16917,16966,17014,17034,17115,17121,17133,17136,17167,17197,17199,17250,17304,17317,17334,17335,17344,17353,17369,17385,17409,17412,17439,17479,17520,17535,17584,17590,17597,17603,17609,17630,17635,17700,17826,17832,17857,17862,17883,17902,17906,17910,17927,17949,17956,17965,17976,17977,18028,18029,18061,18067,18071,18083,18165,18170,18213,18214,18227,18248,18263,18334,18362,18447,18473,18538,18590,18595,18658,18675,18707,18726,18739,18753,18782,18825,18845,18871,18906,18907,18926,18929,18952,18955,18958,18974,19024,19039,19040,19053,19123,19127,19150,19153,19182,19204,19211,19232,19235,19252,19299,19353,19358,19415,19423,19426,19432,19454,19483,19484,19487,19523,19527,19551,19676,19706,19750,19767,19788,19791,19796,19858,19875,19876,19886,19897,19904,19916,19927,19967,19988,20003,20030,20039,20066,20068,20092,20122,20180,20183,20239,20262,20288,20309,20338,20376,20384,20386,20396,20398,20434,20437,20449,20469,20521,20526,20528,20565,20566,20574,20592,20618,20642,20648,20670,20688,20690,20750,20751,20792,20804,20894,20935,20944,20953,20958,20964,20984,20990,21053,21073,21087,21119,21146,21182,21196,21198,21212,21243,21259,21327,21329,21332,21404,21405,21413,21454,21480,21487,21520,21523,21524,21547,21566,21592,21598,21602,21612,21614,21631,21696,21719,21722,21726,21747,21761,21767,21769,21773,21787,21811,21820,21821,21824,21885,21891,21924,21932,21941,21958,22055,22067,22129,22134,22137,22156,22162,22172,22197,22222,22253,22260,22262,22267,22389,22409,22453,22466,22481,22484,22494,22499,22539,22581,22620,22659,22722,22726,22739,22753,22781,22797,22851,22865,22869,22871,22886,22914,22925,22959,22964,23036,23037,23083,23099,23104,23119,23123,23184,23201,23213,23218,23229,23254,23257,23268,23273,23287,23309,23328,23364,23365,23381,23398,23491,23504,23523,23547,23552,23554,23604,23628,23632,23704,23720,23751,23805,23813,23885,23886,23887,23888,23890,23891,23893,23897,23899,23901,23904,23905,23907,23921,23927,23964,23981,23983,23986,24000,24029,24039,24040,24067,24077,24145,24160,24163,24172,24197,24294,24311,24316,24337,24381,24390,24422,24429,24485,24496,24497,24503,24522,24587,24589,24617,24676,24678,24679,24766,24781,24782,24785,24834,24854,24871,24983,25032,25038,25062,25068,25201,25233,25267,25377,25450,25505,25518,25535,25548,25554,25589,25621,25622,25639,25646,25648,25671,25673,25717,25723,25727,25747,25757,25758,25771,25784,25817,25818,25830,25831,25836,25849,25863,25909,25916,25924,25927,25928,25941,25942,25949,25961,25990,25992,25994,25995,26000,26010,26013,26025,26027,26031,26033,26035,26060,26066,26082,26087,26113,26120,26136,26146,26147,26153,26161,26167,26185,26187,26191,26194,26215,26221,26227,26234,26259,26296,26335,26337,26359,26372,26386,26388,26408,26486,26525,26565,26576,26620,26630,26639,26646,26691,26699,26741,26757,26759,26780,26784,26793,26820,26845,26873,26879,26890,26927,26929,26933,26935,26949,26968,27065,27148,27211,27212,27216,27240,27270,27323,27327,27343,27347,27367,27405,27408,27423,27487,27492,27526,27541,27568,27570,27578,27583,27592,27595,27601,27614,27671,27688,27707,27717,27758,27786,27922,27924,27927,28019,28031,28042,28059,28066,28075,28079,28094,28097,28104,28114,28120,28129,28162,28168,28192,28230,28243,28264,28329,28435,28441,28673,28846,28880,28899,28931,28943,28956,29011,29045,29117,29118,29266,29478,29485,29488,29491,29495,29611,29616,29639,29686,29724,29769,29823,29866,29976,29978,30111,30115,30255,30285,30385,30643,31608,31620,31735,31820,31837,31853,32084,32151,32720,32752,32767,32768,33018,33039,33300,33874,33908,33925,33932,33946,33957,33991,34025,34047,34093,34193,34200,34275,34331,34420,34616,34646,34693,34798,34811,34815,34816,34884,34892,35087,35165,35176,35178,35217,35220,35227,35233,35238,35239,35289,35353,35376,35386,35394,35397,35403,35426,35432,35444,35453,35490,35554,35556,35595,35600,35621,35688,35711,35728,35805,35806,35808,35814,35833,35835,35846,35882,35948,35950,35965,35973,36000,36015,36041,36057,36058,36059,36075,36141,36144,36150,36153,36185,36193,36195,36220,36237,36245,36283,36295,36322,36368,36369,36373,36385,36420,36441,36472,36486,36549,36555,36572,36584,36659,36662,36669,36670,36674,36678,36704,36790,36791,36792,36793,36811,36820,36826,36834,36862,36888,36917,36918,36929,36930,36932,36939,36965,36989,36991,36998,37010,37015,37020,37029,37035,37036,37038,37046,37052,37073,37109,37122,37131,37136,37147,37227,37245,37251,37257,37270,37272,37273,37282,37283,37307,37308,37368,37377,37378,37380,37381,37392,37443,37459,37460,37474,37484,37508,37530,37531,37534,37544,37554,37555,37568,37626,37633,37642,37644,37654,37662,37670,37671,37672,37673,37676,37677,37708,37710,37735,37744,37748,37767,37800,37802,37826,37844,37859,37875,37885,37891,37902,37921,37926,37929,37947,37978,38047,38058,38085,38086,38092,38122,38126,38133,38188,38266,38317,38318,38328,38330,38397,38421,38433,38489,38518,38526,38546,38550,38551,38558,38588,38590,38607,38611,38617,38676,38688,38713,38716,38720,38723,38742,38774,38799,38811,38821,38824,38829,38866,38873,38877,38903,38904,38912,38916,38922,38927,38934,38939,38949,38965,38975,38990,38999,39033,39048,39054,39090,39102,39111,39135,39155,39195,39205,39260,39290,39293,39296,39302,39309,39329,39346,39366,39377,39413,39431,39442,39445,39454,39471,39476,39485,39493,39497,39545,39546,39547,39548,39559,39573,39579,39587,39591,39598,39610,39624,39633,39650,39678,39686,39717,39724,39744,39766,39799,39828,39919,39979,40023,40067,40080,40088,40099,40102,40135,40149,40261,40288,40289,40319,40334,40356,40381,40406,40484,40509,40545,40558,40560,40580,40624,40645,40647,40660,40742,40772,40790,40853,40857,40900,40912,40927,40942,40953,40965,41033,41041,41062,41079,41137,41144,41171,41172,41178,41181,41191,41202,41212,41272,41276,41289,41290,41329,41331,41332,41345,41352,41358,41367,41446,41451,41453,41481,41505,41506,41512,41516,41519,41544,41554,41569,41587,41607,41632,41663,41725,41732,41734,41735,41737,41752,41773,41781,41821,41828,41835,41837,41848,41863,41892,41933,41939,41954,41969,41991,42076,42090,42121,42125,42145,42173,42186,42207,42234,42264,42267,42278,42280,42315,42358,42468,42497,42505,42507,42516,42541,42560,42588,42611,42629,42637,42643,42650,42665,42673,42677,42692,42701,42719,42723,42724,42735,42762,42768,42821,42835,42850,42857,42870,42891,42898,42910,42911,42912,42932,42961,42967,42968,42969,42970,42979,42986,42987,42989,43003,43010,43016,43021,43035,43039,43047,43048,43049,43067,43086,43094,43109,43110,43159,43165,43176,43177,43192,43237,43271,43281,43295,43308,43339,43340,43344,43405,43416,43442,43446,43461,43483,43494,43525,43526,43606,43613,43645,43656,43699,43712,43761,43768,43781,43795,43835,43862,43867,43874,43930,43936,44030,44062,44084,44087,44088,44089,44137,44168,44173,44320,44352,44366,44368,44394,44411,44426,44440,44532,44533,44538,44573,44598,44620,44674,44683,44718,44722,44738,44788,44807,44829,44873,44904,44912,44935,44936,44953,44988,45034,45100,45101,45138,45171,45186,45190,45213,45228,45233,45235,45263,45264,45307,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 | 1676 | 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.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.29 ms |
System lock | 0.02 ms |
optimizing | 0.11 ms |
statistics | 2.50 ms |
preparing | 1.24 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 21.49 ms |
end | 0.02 ms |
query end | 0.05 ms |
closing tables | 0.02 ms |
freeing items | 0.11 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 |