Tiempo de la consulta: 20.64 ms Después de la última consulta: 2.26 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-04 06:51:31')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 06:51:31')
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(205,466,471,554,1330,1368,1503,1687,1940,2098,2109,2352,2353,2359,2451,2466,2506,2631,2779,2780,2965,3264,3456,3511,3664,3715,3757,3814,3869,3948,4069,4339,4485,4494,5077,5797,5849,6066,6130,6251,6280,6309,6327,6331,6405,6516,6608,6612,6653,6735,6775,6827,6833,6912,7196,7329,7421,7480,7586,7620,7674,7683,7692,7810,7828,7866,7913,7984,8003,8114,8216,8250,8310,8373,8405,8411,8484,8552,8583,8584,8820,9051,9199,9313,9631,9684,9999,10008,10033,10054,10154,10272,10562,10609,10716,10736,11244,11379,11386,11461,11532,11534,11795,11828,11884,11913,11930,11947,12106,12205,12224,12253,12594,12722,12803,12933,12980,13018,13061,13107,13128,13173,13203,13219,13221,13260,13343,13363,13402,13431,13439,13484,13567,13687,13725,13980,13991,14161,14400,14432,14446,14548,14583,14604,14637,14648,14672,14684,14761,14822,14835,14937,14938,15047,15177,15300,15438,15455,15489,15591,15595,15642,15760,15896,16051,16159,16191,16201,16469,16573,16587,16632,16716,16749,16829,16882,16968,16977,17023,17137,17146,17258,17393,17443,17493,17604,17718,17842,17883,17994,18082,18249,18739,18833,19046,19088,19102,19162,19241,19340,19598,19802,20133,20159,20208,20230,20259,20414,20511,20571,20596,20677,21199,21227,21383,21502,21791,21965,22129,22130,22202,22634,22682,22826,22827,22828,22937,22975,23116,23406,23508,23570,23574,23730,23866,24023,24136,24216,24222,24253,24255,24387,24462,24477,24899,24957,25207,25228,25398,25408,25409,25415,25420,25443,25445,25455,25501,25550,25570,25581,25603,25612,25621,25623,25630,25640,25643,25647,25648,25659,25663,25664,25670,25671,25673,25703,25704,25717,25727,25733,25735,25737,25740,25753,25755,25770,25782,25801,25805,25833,25834,25841,25855,25860,25862,25864,25868,25877,25882,25884,25897,25900,25905,25906,25922,25933,25935,25967,25975,26017,26020,26023,26026,26028,26030,26054,26056,26064,26089,26090,26092,26097,26123,26126,26139,26155,26160,26166,26173,26179,26183,26185,26186,26189,26191,26193,26207,26221,26230,26231,26238,26239,26240,26248,26262,26264,26275,26287,26297,26310,26319,26327,26333,26373,26374,26380,26403,26404,26408,26411,26418,26431,26435,26440,26451,26456,26459,26464,26467,26469,26479,26490,26499,26516,26517,26519,26531,26532,26534,26536,26541,26549,26555,26558,26559,26560,26562,26571,26574,26575,26579,26584,26596,26601,26605,26625,26629,26635,26650,26664,26678,26684,26685,26692,26704,26709,26714,26715,26716,26717,26723,26725,26731,26732,26738,26740,26741,26742,26745,26747,26748,26750,26751,26752,26753,26757,26758,26759,26760,26761,26767,26768,26775,26777,26788,26789,26801,26818,26832,26838,26846,26848,26859,26877,26885,26887,26891,26896,26897,26911,26912,26936,26937,26945,26947,26955,26956,26959,26960,26969,26974,26976,26977,26992,27001,27003,27005,27015,27017,27018,27025,27028,27039,27046,27050,27053,27054,27055,27056,27058,27063,27064,27066,27089,27100,27110,27129,27136,27143,27145,27150,27156,27161,27171,27174,27178,27189,27191,27204,27228,27230,27272,27288,27293,27294,27295,27308,27310,27315,27317,27327,27330,27337,27338,27350,27359,27362,27364,27376,27378,27384,27386,27422,27427,27430,27438,27453,27459,27466,27476,27478,27485,27491,27493,27499,27509,27516,27548,27549,27570,27574,27577,27589,27591,27602,27606,27607,27615,27632,27644,27660,27673,27681,27684,27691,27696,27700,27701,27706,27709,27712,27714,27716,27718,27722,27732,27733,27734,27737,27738,27748,27752,27753,27754,27772,27773,27800,27811,27827,27835,27838,27839,27846,27880,27881,27905,27916,27928,27932,27963,27966,27972,27976,27982,28006,28036,28037,28038,28044,28048,28060,28061,28102,28127,28137,28141,28154,28176,28191,28211,28215,28223,28232,28235,28255,28274,28276,28287,28288,28293,28305,28308,28311,28331,28345,28348,28350,28352,28356,28358,28361,28362,28363,28367,28368,28375,28376,28379,28386,28404,28430,28460,28464,28466,28467,28471,28474,28475,28479,28482,28484,28488,28489,28494,28496,28497,28503,28506,28515,28519,28525,28530,28558,28567,28568,28604,28611,28644,28645,28650,28654,28665,28672,28700,28701,28730,28731,28766,28768,28773,28804,28805,28819,28863,28871,28881,28883,28887,28888,28890,28894,28898,28905,28924,28926,28938,28940,28974,28975,28986,28987,29020,29054,29068,29078,29080,29109,29112,29115,29131,29231,29232,29252,29274,29284,29285,29307,29324,29330,29336,29342,29366,29368,29370,29375,29378,29379,29380,29396,29399,29402,29403,29410,29414,29436,29446,29474,29477,29506,29509,29520,29532,29541,29542,29544,29545,29546,29555,29556,29560,29578,29579,29580,29581,29593,29595,29597,29598,29600,29602,29603,29606,29612,29649,29663,29670,29672,29676,29677,29689,29703,29704,29729,29730,29732,29733,29762,29767,29779,29794,29818,29819,29820,29842,29859,29880,29897,29934,29940,29950,29966,29977,29980,30021,30085,30093,30094,30163,30168,30202,30243,30244,30299,30331,30333,30344,30351,30368,30373,30382,30384,30395,30405,30406,30413,30447,30450,30465,30484,30504,30515,30525,30544,30569,30580,30595,30608,30613,30626,30638,30685,30687,30689,30721,30739,30741,30763,30776,30778,30798,30881,30902,30967,30968,30994,31011,31016,31025,31072,31115,31121,31138,31167,31174,31188,31207,31208,31209,31213,31214,31215,31218,31235,31308,31311,31312,31314,31315,31317,31331,31337,31345,31348,31349,31355,31376,31394,31399,31402,31423,31427,31431,31471,31527,31530,31568,31577,31586,31613,31625,31679,31681,31685,31691,31692,31709,31741,31760,31764,31771,31820,31832,31849,31863,31866,31877,31931,31937,31938,31939,31941,31943,31962,31982,31996,31999,32004,32012,32023,32045,32062,32069,32099,32108,32125,32139,32144,32172,32185,32225,32229,32239,32270,32271,32295,32325,32327,32329,32374,32380,32397,32402,32406,32412,32440,32441,32442,32445,32494,32520,32522,32523,32529,32548,32578,32624,32658,32671,32685,32689,32693,32699,32717,32729,32730,32776,32793,32805,32806,32807,32832,32855,32860,32870,32903,32914,32915,32945,32973,32974,32982,33004,33010,33012,33013,33016,33017,33019,33020,33030,33043,33045,33063,33064,33067,33092,33099,33102,33104,33106,33116,33122,33133,33142,33143,33146,33147,33150,33221,33254,33271,33288,33299,33301,33329,33333,33344,33346,33351,33376,33458,33476,33499,33508,33511,33516,33525,33527,33544,33569,33572,33573,33580,33582,33583,33584,33609,33642,33694,33703,33744,33768,33774,33777,33790,33810,33811,33812,33813,33814,33861,33872,33894,33916,33918,33951,33952,33953,33956,33957,33958,33959,33964,33966,33974,33993,33999,34010,34014,34023,34059,34065,34081,34082,34093,34105,34118,34122,34130,34137,34160,34161,34165,34166,34171,34175,34191,34197,34199,34204,34213,34225,34226,34238,34245,34246,34248,34254,34257,34277,34306,34308,34309,34314,34337,34377,34380,34405,34413,34420,34427,34428,34431,34432,34435,34437,34439,34444,34451,34452,34460,34467,34468,34469,34470,34483,34487,34488,34493,34500,34501,34512,34518,34521,34535,34538,34543,34546,34549,34555,34558,34561,34578,34589,34597,34598,34599,34602,34605,34614,34615,34619,34625,34627,34641,34657,34665,34671,34674,34701,34718,34719,34723,34731,34733,34739,34740,34745,34747,34754,34756,34759,34763,34770,34775,34776,34793,34802,34818,34825,34830,34836,34839,34846,34857,34861,34865,34868,34869,34870,34871,34875,34890,34903,34905,34920,34925,34926,34931,34934,34938,34956,34961,34963,34965,34966,34971,34980,34981,34991,34998,35008,35014,35021,35027,35040,35055,35063,35070,35077,35084,35086,35090,35100,35102,35104,35115,35116,35137,35138,35150,35160,35184,35192,35196,35199,35203,35214,35224,35255,35294,35296,35306,35307,35311,35317,35319,35326,35332,35345,35346,35347,35348,35359,35369,35376,35378,35387,35394,35395,35408,35412,35415,35418,35419,35422,35435,35438,35440,35448,35452,35453,35455,35459,35462,35464,35465,35469,35470,35484,35486,35495,35497,35501,35502,35507,35511,35518,35523,35526,35530,35544,35546,35548,35550,35552,35560,35562,35565,35566,35575,35581,35582,35614,35623,35630,35633,35641,35651,35652,35663,35680,35694,35695,35697,35706,35708,35710,35729,35764,35772,35790,35801,35819,35827,35836,35839,35841,35845,35859,35866,35867,35878,35908,35909,35912,35913,35915,35919,35925,35939,35942,35950,35951,35956,35958,35969,35971,35974,35979,35981,35984,35996,36005,36011,36030,36034,36035,36044,36047,36062,36066,36069,36070,36080,36094,36099,36110,36120,36126,36142,36147,36154,36155,36159,36170,36173,36175,36176,36184,36194,36209,36212,36216,36227,36228,36246,36248,36249,36250,36258,36260,36262,36278,36279,36281,36288,36290,36305,36309,36330,36335,36337,36338,36357,36377,36381,36388,36395,36413,36414,36418,36430,36438,36449,36452,36473,36478,36483,36507,36508,36511,36514,36525,36530,36533,36539,36559,36588,36599,36607,36614,36625,36644,36653,36660,36671,36693,36708,36717,36719,36743,36746,36748,36749,36780,36783,36786,36803,36808,36810,36824,36830,36848,36859,36873,36904,36905,36910,36911,36913,36914,36915,36923,36924,36936,36967,36975,36995,37007,37013,37014,37028,37034,37040,37062,37078,37080,37087,37099,37118,37119,37172,37197,37235,37259,37260,37299,37303,37316,37324,37376,37398,37400,37406,37429,37453,37477,37479,37514,37516,37517,37558,37560,37589,37591,37605,37619,37624,37630,37635,37636,37637,37652,37666,37667,37683,37685,37711,37713,37729,37731,37732,37742,37745,37752,37754,37794,37821,37827,37884,37885,37909,37923,37936,37955,37958,37966,37974,37975,37991,38005,38012,38013,38014,38043,38070,38108,38112,38113,38119,38134,38141,38159,38161,38183,38193,38194,38202,38216,38228,38235,38236,38283,38314,38334,38339,38349,38394,38396,38419,38435,38471,38549,38594,38632,38658,38659,38666,38671,38757,38779,38788,38806,38814,38815,38830,38846,38847,38850,38857,38862,38865,38867,38868,38870,38872,38874,38875,38876,38877,38878,38879,38880,38881,38882,38883,38884,38885,38886,38887,38888,38889,38890,38891,38892,38893,38894,38895,38898,38899,38902,38904,38910,38912,38913,38915,38918,38921,38923,38925,38930,38932,38938,38939,38942,38963,38964,38973,38974,38986,38988,38998,39005,39013,39020,39046,39064,39087,39101,39127,39131,39194,39250,39252,39281,39342,39360,39365,39374,39415,39498,39500,39556,39557,39575,39599,39604,39623,39629,39650,39661,39679,39780,39781,39791,39818,39835,39866,39883,39888,39892,39909,39942,39943,39998,40001,40024,40072,40090,40129,40150,40155,40182,40227,40250,40258,40271,40274,40376,40399,40416,40430,40431,40432,40437,40442,40443,40447,40453,40458,40467,40470,40501,40510,40514,40515,40519,40521,40522,40537,40545,40550,40554,40564,40570,40587,40588,40609,40610,40611,40617,40629,40634,40654,40664,40668,40670,40674,40699,40705,40720,40728,40738,40739,40746,40768,40773,40778,40780,40786,40794,40820,40823,40827,40831,40839,40848,40860,40865,40880,40883,40886,40887,40892,40903,40919,40923,40936,40967,40972,40993,41000,41007,41010,41011,41014,41021,41028,41039,41055,41064,41066,41076,41077,41087,41108,41139,41143,41153,41158,41163,41174,41200,41205,41217,41234,41242,41250,41251,41261,41287,41290,41295,41322,41334,41339,41341,41345,41404,41410,41421,41427,41431,41435,41448,41454,41461,41491,41496,41497,41498,41500,41505,41506,41507,41516,41521,41528,41529,41543,41547,41548,41568,41578,41581,41582,41583,41588,41611,41612,41613,41623,41628,41645,41653,41654,41658,41659,41668,41669,41670,41674,41683,41685,41687,41690,41693,41702,41709,41717,41729,41730,41731,41733,41741,41751,41753,41769,41771,41774,41777,41786,41791,41792,41794,41815,41816,41821,41832,41833,41840,41852,41876,41877,41906,41911,41912,41918,41931,41965,41967,41968,41978,41979,41984,41985,41995,42004,42012,42013,42014,42023,42030,42031,42034,42037,42042,42048,42049,42054,42061,42079,42084,42085,42093,42111,42133,42147,42149,42155,42164,42176,42178,42190,42201,42204,42206,42207,42214,42215,42231,42256,42265,42273,42281,42282,42287,42290,42300,42301,42313,42325,42326,42327,42350,42362,42367,42368,42389,42415,42440,42441,42447,42451,42453,42458,42471,42474,42480,42485,42488,42493,42514,42517,42526,42532,42536,42540,42543,42549,42565,42573,42578,42579,42583,42589,42591,42593,42601,42617,42623,42628,42650,42659,42686,42688,42693,42704,42714,42732,42749,42753,42758,42764,42810,42837,42847,42856,42860,42875,42880,42883,42888,42891,42894,42913,42923,42933,42940,42946,42947,42965,42976,42992,43001,43023,43024,43028,43034,43035,43040,43041,43054,43057,43059,43063,43070,43071,43085,43088,43091,43092,43108,43115,43128,43130,43141,43146,43147,43154,43160,43168,43171,43172,43174,43175,43187,43195,43196,43205,43207,43210,43211,43212,43216,43217,43218,43220,43252,43267,43270,43271,43272,43273,43275,43282,43292,43296,43297,43305,43323,43324,43325,43341,43358,43366,43368,43376,43377,43378,43409,43414,43417,43427,43428,43429,43432,43441,43449,43450,43457,43458,43460,43465,43473,43474,43479,43500,43501,43503,43537,43541,43542,43554,43564,43567,43572,43574,43578,43579,43584,43590,43592,43600,43605,43606,43619,43620,43623,43624,43633,43646,43653,43655,43657,43660,43666,43667,43673,43675,43678,43681,43686,43687,43694,43695,43696,43721,43733,43734,43738,43741,43744,43745,43746,43747,43757,43767,43770,43777,43778,43791,43806,43810,43813,43815,43816,43822,43829,43833,43842,43847,43855,43856,43859,43860,43861,43863,43866,43872,43875,43889,43909,43911,43918,43927,43931,43935,43937,43970,43971,43975,43976,43987,44000,44001,44002,44008,44018,44021,44022,44037,44039,44040,44042,44044,44047,44048,44064,44093,44099,44103,44132,44143,44156,44157,44164,44177,44179,44225,44240,44243,44244,44249,44250,44253,44254,44257,44292,44303,44313,44317,44323,44326,44333,44367,44371,44380,44381,44390,44397,44399,44405,44409,44412,44417,44424,44434,44438,44441,44445,44448,44450,44451,44452,44455,44459,44465,44469,44470,44475,44476,44477,44482,44483,44486,44490,44492,44496,44499,44502,44503,44505,44547,44548,44565,44570,44575,44577,44579,44582,44586,44587,44597,44616,44621,44623,44625,44633,44639,44644,44651,44669,44679,44691,44693,44695,44709,44723,44724,44729,44740,44744,44750,44753,44754,44756,44766,44770,44773,44789,44790,44791,44794,44795,44799,44800,44808,44810,44814,44816,44819,44826,44828,44839,44844,44853,44862,44875,44878,44902,44909,44913,44916,44920,44924,44925,44927,44929,44932,44933,44936,44937,44941,44942,44945,44954,44966,44970,44975,44976,44980,44986,44991,44994,44997,44998,45002,45006,45013,45019,45044,45052,45053,45054,45060,45063,45069,45070,45078,45085,45107,45113,45115,45120,45122,45140,45141,45147,45153,45161,45163,45180,45181,45182,45187,45200,45210,45212,45213,45214,45226,45229,45231,45246,45247,45251,45265,45266,45281,45282,45283,45286,45306,45308)
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 | 2396 | 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.06 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.42 ms |
System lock | 0.02 ms |
optimizing | 0.15 ms |
statistics | 3.59 ms |
preparing | 1.78 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 12.51 ms |
end | 0.12 ms |
query end | 0.09 ms |
closing tables | 0.04 ms |
freeing items | 0.22 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 |