Tiempo de la consulta: 19.80 ms Después de la última consulta: 2.34 ms Consulta a la memoria: 1.463 MB memoria antes de la consulta: 4.629 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 06:56:28')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 06:56:28')
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(206,554,1330,1368,2250,2285,2451,2506,2779,2780,3456,3869,4069,4215,4226,4381,4494,5881,6066,6280,6309,6389,6493,6670,7421,7460,7480,7586,7620,7683,7828,8003,8114,8290,8310,8373,8411,8480,9051,9199,9631,9684,10033,10054,10154,10609,10716,10736,11379,11386,11461,11534,11795,11828,11884,11913,11930,11947,12106,12205,12253,12594,12722,12933,13107,13128,13173,13203,13343,13363,13402,13431,13439,13484,13567,13980,13991,14161,14206,14400,14534,14583,14637,14672,14822,14835,14937,14938,15047,15177,15300,15392,15438,15489,15591,15642,15760,15896,15954,16051,16159,16201,16469,16632,16716,16829,16882,16968,16977,17023,17146,17258,17393,17443,17493,17604,17718,17842,17883,17994,18097,18249,18442,18602,18739,18833,19046,19088,19102,19162,19241,19340,19354,19444,19598,20133,20159,20213,20230,20259,20414,20511,20677,20841,21064,21227,21383,22202,22627,22682,22828,22937,22975,23406,23570,23574,23730,23866,24023,24136,24216,24387,24447,24462,24477,24501,25207,25398,25409,25432,25443,25455,25550,25570,25581,25612,25621,25623,25624,25647,25659,25670,25703,25704,25707,25717,25727,25733,25735,25737,25740,25801,25805,25833,25842,25851,25860,25862,25897,25905,25906,25927,25935,25954,25985,25989,26017,26018,26021,26028,26031,26038,26041,26065,26089,26090,26097,26107,26122,26123,26126,26131,26136,26139,26155,26161,26183,26210,26219,26222,26238,26259,26264,26310,26333,26358,26360,26373,26377,26389,26403,26404,26408,26411,26418,26426,26454,26464,26479,26494,26499,26513,26517,26531,26532,26534,26549,26555,26558,26569,26583,26584,26625,26630,26665,26678,26692,26714,26731,26733,26737,26738,26751,26753,26758,26759,26761,26775,26834,26838,26846,26877,26885,26887,26891,26892,26911,26914,26941,26945,26947,26956,26968,26974,26992,27017,27026,27039,27046,27053,27054,27066,27069,27110,27116,27120,27121,27131,27143,27145,27155,27170,27171,27178,27189,27191,27218,27221,27228,27232,27248,27273,27277,27288,27310,27332,27337,27338,27343,27346,27355,27356,27359,27360,27362,27363,27364,27366,27372,27378,27386,27422,27430,27431,27452,27453,27459,27481,27485,27493,27499,27509,27520,27529,27548,27549,27574,27606,27607,27615,27632,27644,27645,27646,27669,27683,27684,27691,27700,27716,27722,27733,27734,27738,27773,27800,27816,27835,27846,27869,27881,27916,27917,27919,27928,27963,27972,27976,27977,27986,27991,27996,28006,28011,28037,28044,28055,28060,28061,28191,28288,28296,28311,28319,28348,28350,28378,28379,28380,28381,28386,28387,28395,28400,28404,28421,28426,28433,28434,28446,28460,28464,28474,28482,28494,28497,28500,28503,28506,28508,28512,28515,28516,28530,28558,28567,28604,28605,28606,28644,28645,28646,28665,28672,28700,28701,28720,28729,28732,28766,28768,28804,28805,28819,28881,28883,28888,28890,28898,28905,28926,28938,28940,28974,28975,28976,28986,28987,28995,29020,29043,29054,29068,29069,29076,29080,29109,29112,29115,29122,29129,29131,29156,29160,29182,29231,29232,29249,29252,29271,29310,29315,29324,29330,29333,29336,29366,29368,29370,29375,29380,29402,29403,29410,29414,29436,29446,29457,29477,29497,29506,29509,29525,29542,29544,29555,29556,29579,29580,29581,29593,29595,29597,29600,29606,29632,29633,29636,29649,29657,29670,29676,29677,29689,29693,29703,29704,29729,29730,29732,29733,29748,29762,29766,29782,29784,29819,29820,29828,29842,29851,29854,29859,29877,29880,29897,29927,29950,29975,29980,30021,30085,30094,30115,30144,30146,30226,30241,30243,30244,30245,30282,30299,30330,30331,30344,30347,30348,30351,30368,30384,30390,30397,30413,30474,30476,30482,30483,30497,30498,30502,30519,30544,30585,30595,30626,30685,30776,30778,30798,30826,30861,30863,30881,30887,30889,30902,30964,30968,31011,31016,31025,31041,31062,31072,31090,31115,31121,31138,31189,31206,31208,31209,31213,31214,31215,31230,31236,31237,31267,31305,31306,31308,31348,31349,31376,31423,31425,31427,31469,31474,31494,31500,31539,31580,31625,31681,31691,31692,31709,31771,31791,31830,31832,31849,31865,31877,31930,31937,31941,31943,31954,31995,31996,31999,32004,32012,32023,32045,32099,32108,32139,32144,32223,32270,32278,32279,32295,32325,32327,32329,32402,32406,32412,32433,32442,32520,32522,32528,32529,32578,32624,32646,32658,32671,32685,32717,32729,32730,32786,32793,32797,32800,32805,32806,32807,32815,32830,32914,32934,32974,33004,33010,33012,33013,33016,33017,33019,33020,33030,33043,33045,33063,33064,33067,33102,33104,33117,33122,33133,33142,33147,33267,33288,33333,33344,33376,33402,33458,33461,33476,33478,33511,33516,33522,33525,33527,33544,33572,33582,33583,33609,33642,33684,33694,33703,33760,33768,33774,33777,33790,33810,33811,33812,33813,33814,33894,33916,33918,33958,33959,34023,34059,34065,34090,34091,34125,34126,34127,34137,34160,34165,34189,34197,34199,34207,34225,34227,34238,34245,34246,34248,34252,34267,34290,34291,34300,34301,34306,34309,34314,34316,34318,34337,34342,34384,34385,34405,34413,34427,34428,34431,34435,34437,34444,34452,34469,34483,34485,34512,34521,34535,34549,34558,34578,34597,34598,34599,34602,34609,34614,34615,34619,34625,34627,34655,34657,34664,34665,34669,34671,34674,34689,34691,34701,34702,34710,34719,34723,34733,34738,34739,34740,34745,34747,34756,34759,34763,34770,34774,34818,34822,34823,34832,34839,34844,34846,34860,34865,34868,34869,34870,34871,34875,34890,34903,34905,34920,34925,34926,34929,34931,34934,34938,34950,34951,34956,34965,34966,34971,34980,34991,34998,35008,35010,35011,35012,35014,35026,35027,35033,35063,35068,35070,35086,35090,35094,35122,35130,35132,35133,35144,35150,35158,35160,35161,35183,35184,35192,35199,35203,35214,35223,35224,35246,35251,35255,35272,35274,35275,35279,35280,35281,35285,35293,35299,35306,35307,35314,35315,35319,35326,35327,35328,35332,35334,35338,35341,35346,35347,35348,35354,35356,35386,35392,35394,35408,35412,35415,35418,35422,35432,35438,35451,35455,35459,35464,35470,35486,35495,35499,35501,35502,35511,35516,35518,35524,35525,35536,35537,35538,35544,35552,35557,35560,35573,35582,35606,35610,35630,35641,35651,35652,35680,35688,35694,35695,35697,35701,35706,35708,35711,35714,35764,35772,35785,35790,35801,35807,35817,35819,35835,35836,35839,35845,35847,35859,35867,35876,35902,35908,35912,35913,35919,35925,35939,35951,35958,35962,35970,35973,35974,35981,35982,35984,35990,35994,35996,36005,36011,36030,36031,36033,36034,36037,36044,36047,36055,36062,36074,36076,36080,36088,36092,36099,36104,36105,36110,36120,36126,36132,36136,36141,36142,36144,36147,36155,36159,36167,36170,36173,36184,36194,36206,36209,36227,36233,36239,36242,36246,36247,36248,36260,36278,36288,36290,36305,36309,36311,36330,36337,36357,36370,36377,36381,36384,36388,36391,36393,36395,36413,36414,36418,36430,36433,36437,36438,36449,36467,36468,36469,36473,36478,36483,36488,36507,36508,36511,36513,36514,36520,36524,36525,36527,36530,36533,36535,36539,36558,36559,36574,36588,36595,36599,36607,36614,36644,36651,36653,36660,36662,36669,36670,36671,36673,36688,36693,36696,36697,36704,36708,36717,36719,36723,36743,36746,36747,36748,36749,36759,36766,36774,36780,36783,36786,36788,36790,36791,36792,36793,36808,36810,36811,36820,36822,36824,36826,36830,36848,36852,36873,36883,36886,36888,36889,36890,36893,36904,36905,36911,36913,36914,36915,36916,36918,36922,36923,36924,36929,36936,36963,36967,36975,36995,36997,37003,37007,37013,37014,37015,37024,37028,37034,37038,37043,37052,37072,37078,37080,37087,37096,37099,37105,37118,37119,37166,37172,37174,37196,37208,37234,37235,37254,37257,37259,37260,37270,37299,37303,37316,37324,37344,37355,37376,37377,37398,37400,37406,37425,37429,37443,37453,37460,37474,37477,37479,37491,37514,37516,37517,37521,37530,37543,37544,37554,37555,37589,37591,37605,37619,37624,37630,37631,37633,37636,37637,37662,37666,37667,37675,37683,37685,37710,37711,37713,37729,37731,37732,37739,37740,37742,37745,37752,37754,37767,37783,37786,37794,37803,37821,37826,37827,37859,37872,37874,37884,37885,37909,37910,37911,37914,37918,37922,37923,37936,37955,37958,37966,37974,37975,37991,37996,37999,38005,38012,38013,38014,38033,38043,38047,38060,38066,38070,38083,38085,38101,38108,38112,38117,38119,38134,38141,38143,38158,38159,38161,38165,38178,38183,38193,38194,38202,38203,38204,38206,38216,38218,38228,38235,38242,38243,38246,38248,38265,38266,38278,38283,38302,38314,38317,38334,38339,38345,38349,38361,38370,38391,38394,38396,38419,38421,38429,38430,38435,38453,38465,38471,38506,38510,38512,38516,38526,38543,38580,38588,38590,38594,38611,38623,38632,38658,38659,38671,38676,38688,38704,38710,38713,38716,38720,38734,38752,38753,38757,38764,38765,38775,38779,38781,38788,38789,38797,38799,38812,38815,38821,38823,38826,38829,38830,38837,38838,38851,38888,38918,38955,38956,38963,38981,38993,38998,39005,39013,39019,39020,39023,39024,39046,39054,39070,39079,39087,39101,39103,39104,39117,39131,39139,39140,39149,39151,39154,39155,39160,39168,39177,39183,39184,39189,39205,39228,39229,39244,39250,39252,39256,39257,39281,39307,39309,39310,39325,39329,39337,39342,39346,39357,39358,39360,39364,39365,39374,39377,39449,39471,39486,39498,39500,39503,39504,39521,39534,39540,39545,39546,39547,39548,39556,39557,39573,39575,39582,39591,39595,39599,39604,39621,39623,39625,39629,39633,39650,39661,39662,39676,39678,39679,39692,39710,39754,39757,39767,39780,39781,39791,39792,39793,39810,39818,39828,39835,39836,39838,39840,39853,39864,39866,39882,39883,39888,39898,39908,39909,39912,39915,39920,39921,39934,39947,39974,39976,39998,40001,40003,40024,40042,40055,40072,40081,40088,40090,40091,40103,40105,40129,40150,40155,40182,40194,40227,40250,40258,40274,40288,40289,40302,40306,40312,40313,40314,40320,40350,40360,40376,40378,40379,40399,40416,40430,40431,40432,40437,40442,40443,40447,40458,40467,40470,40501,40508,40510,40514,40519,40521,40522,40537,40539,40541,40542,40550,40564,40568,40570,40574,40587,40588,40589,40590,40609,40610,40611,40617,40621,40627,40634,40644,40654,40668,40670,40676,40686,40699,40705,40709,40713,40738,40743,40744,40750,40763,40767,40776,40791,40794,40801,40819,40820,40823,40827,40831,40848,40853,40866,40879,40882,40883,40886,40892,40897,40900,40903,40904,40915,40916,40923,40927,40936,40953,40965,40971,40986,40992,40996,41010,41011,41012,41014,41021,41028,41045,41051,41055,41062,41063,41066,41077,41087,41137,41139,41142,41143,41144,41178,41179,41190,41194,41216,41218,41233,41242,41249,41250,41251,41261,41275,41276,41284,41287,41291,41294,41303,41341,41345,41352,41358,41367,41369,41371,41382,41402,41403,41404,41407,41420,41423,41424,41427,41435,41446,41448,41451,41453,41454,41458,41461,41479,41496,41497,41498,41512,41521,41529,41530,41535,41544,41547,41562,41563,41568,41569,41571,41572,41582,41583,41626,41653,41663,41670,41683,41693,41709,41717,41729,41730,41731,41738,41751,41752,41753,41755,41756,41771,41777,41789,41794,41811,41833,41835,41838,41851,41852,41870,41877,41885,41890,41892,41897,41906,41918,41922,41928,41931,41939,41954,41967,41973,41978,41979,41980,41982,41984,41985,42004,42006,42008,42012,42013,42014,42030,42042,42047,42048,42056,42058,42061,42084,42085,42086,42090,42093,42113,42121,42129,42141,42147,42149,42155,42164,42172,42178,42191,42201,42204,42207,42214,42215,42216,42220,42232,42233,42234,42250,42256,42265,42267,42273,42278,42281,42285,42300,42301,42303,42312,42316,42317,42327,42329,42352,42355,42363,42413,42427,42436,42440,42441,42447,42451,42466,42470,42471,42474,42485,42488,42489,42492,42497,42501,42505,42515,42516,42517,42526,42528,42543,42544,42549,42554,42560,42573,42578,42579,42583,42589,42593,42601,42609,42610,42611,42617,42625,42659,42660,42682,42686,42687,42704,42714,42731,42732,42736,42746,42749,42753,42754,42764,42788,42793,42796,42798,42800,42810,42821,42823,42837,42856,42862,42866,42867,42874,42875,42880,42882,42884,42894,42911,42912,42913,42923,42947,42976,42979,43001,43015,43021,43023,43024,43034,43036,43040,43041,43057,43058,43059,43065,43075,43083,43085,43086,43088,43091,43092,43108,43115,43116,43121,43135,43142,43146,43147,43154,43160,43165,43168,43171,43172,43175,43181,43187,43190,43195,43196,43205,43210,43211,43212,43220,43252,43257,43267,43272,43273,43275,43282,43286,43287,43292,43295,43296,43297,43312,43323,43324,43325,43331,43337,43339,43340,43341,43343,43344,43361,43366,43368,43376,43377,43378,43381,43409,43416,43417,43427,43428,43429,43434,43439,43441,43442,43443,43449,43455,43457,43458,43460,43473,43474,43482,43484,43485,43493,43494,43500,43501,43502,43503,43512,43535,43540,43542,43551,43554,43558,43559,43564,43567,43572,43573,43574,43577,43579,43590,43591,43600,43605,43606,43611,43613,43617,43624,43626,43638,43643,43646,43648,43657,43661,43666,43673,43679,43680,43684,43686,43687,43694,43695,43696,43697,43699,43703,43705,43706,43707,43713,43721,43729,43730,43733,43734,43741,43742,43744,43745,43746,43747,43757,43758,43762,43767,43768,43776,43777,43782,43790,43791,43800,43806,43813,43822,43824,43825,43827,43829,43832,43833,43836,43838,43844,43845,43847,43858,43859,43860,43861,43863,43865,43866,43872,43875,43876,43877,43883,43889,43904,43906,43914,43915,43917,43918,43919,43925,43930,43934,43935,43938,43970,43971,43975,43976,43982,43987,43998,44000,44001,44003,44005,44008,44012,44016,44021,44022,44031,44035,44039,44040,44041,44044,44047,44048,44064,44080,44093,44098,44099,44117,44118,44132,44133,44156,44157,44158,44164,44168,44170,44179,44192,44225,44240,44243,44244,44257,44259,44261,44276,44293,44295,44300,44313,44320,44323,44326,44333,44340,44341,44358,44367,44371,44381,44390,44394,44397,44405,44409,44412,44413,44414,44417,44423,44424,44434,44438,44441,44448,44450,44455,44465,44470,44477,44482,44486,44490,44492,44496,44497,44502,44503,44505,44547,44548,44555,44559,44570,44576,44579,44581,44582,44586,44592,44597,44598,44603,44604,44616,44620,44621,44623,44625,44626,44630,44639,44644,44651,44658,44669,44675,44679,44681,44691,44693,44695,44699,44700,44709,44723,44724,44727,44728,44729,44731,44732,44733,44738,44740,44744,44748,44750,44754,44756,44765,44766,44770,44773,44789,44790,44791,44795,44808,44816,44819,44828,44853,44854,44859,44862,44875,44878,44882,44891,44897,44898,44902,44904,44909,44913,44917,44920,44924,44925,44929,44934,44937,44941,44942,44945,44952,44953,44966,44970,44975,44980,44986,44991,44997,45002,45003,45010,45012,45013,45019,45027,45034,45044,45052,45053,45054,45055,45070,45078,45085,45107,45113,45115,45120,45122,45147,45153,45155,45160,45161,45162,45163,45169,45171,45177,45182,45187,45190,45193,45200,45206,45212,45214,45229,45233,45246,45251,45266,45283,45301,45306,45310)
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 | 2399 | 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 | 1.15 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.41 ms |
System lock | 0.02 ms |
optimizing | 0.15 ms |
statistics | 3.63 ms |
preparing | 1.87 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 10.80 ms |
end | 0.02 ms |
query end | 0.05 ms |
closing tables | 0.02 ms |
freeing items | 0.15 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 |