Tiempo de la consulta: 7.16 ms Después de la última consulta: 1.77 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.479 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-09 19:11:11')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 19:11:11')
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(2,11,49,58,82,93,147,148,149,150,151,152,153,154,155,161,162,163,164,205,345,346,349,350,352,385,389,407,437,458,466,471,485,495,530,531,570,595,605,607,634,686,708,709,710,711,712,713,721,723,783,799,813,844,868,881,911,956,970,971,977,981,986,999,1018,1053,1080,1091,1139,1185,1186,1198,1207,1233,1236,1277,1298,1503,1538,1555,1643,1687,1713,1736,1800,1802,1804,1817,1835,1940,2098,2109,2123,2210,2216,2228,2260,2337,2352,2353,2359,2378,2386,2466,2468,2509,2570,2631,2688,2713,2827,2828,2837,2857,2952,2964,2965,2967,3020,3067,3076,3108,3209,3210,3211,3258,3264,3319,3322,3373,3408,3410,3456,3464,3475,3507,3511,3519,3663,3664,3692,3715,3750,3757,3794,3814,3862,3871,3948,3986,4013,4076,4131,4281,4339,4383,4405,4485,4494,4670,4832,4836,4910,4973,5077,5092,5224,5298,5300,5437,5464,5484,5525,5533,5560,5785,5797,5798,5830,5849,5894,5943,5944,5964,5973,6039,6055,6062,6130,6131,6251,6294,6327,6331,6362,6405,6484,6516,6571,6600,6608,6609,6612,6633,6645,6653,6654,6665,6673,6684,6711,6725,6726,6735,6744,6749,6770,6775,6785,6809,6827,6833,6905,6911,6912,6919,6934,6945,6955,6971,6977,7001,7101,7196,7212,7271,7285,7296,7328,7329,7330,7407,7415,7435,7456,7482,7544,7585,7624,7674,7688,7710,7722,7797,7806,7810,7837,7858,7863,7866,7913,7933,7997,7999,8000,8027,8082,8085,8088,8192,8216,8222,8354,8405,8416,8441,8484,8499,8532,8552,8583,8584,8603,8663,8679,8692,8706,8743,8764,8820,8908,8942,8964,9012,9018,9239,9242,9264,9282,9299,9305,9308,9313,9438,9451,9481,9507,9552,9626,9784,9823,9864,9920,9999,10008,10100,10206,10239,10241,10260,10264,10266,10272,10291,10301,10315,10425,10530,10535,10562,10563,10598,10604,10611,10644,10741,10764,10779,10874,10907,10952,10978,11059,11091,11126,11203,11207,11244,11761,11896,11924,12035,12097,12113,12165,12216,12224,12228,12301,12374,12398,12437,12471,12482,12564,12581,12625,12644,12669,12708,12758,12761,12779,12803,12850,12980,13018,13061,13100,13138,13188,13219,13221,13260,13276,13362,13441,13474,13481,13512,13519,13605,13635,13646,13671,13678,13685,13687,13693,13725,13727,13748,13750,13782,13827,13852,13858,13894,13924,13941,13947,14057,14107,14140,14189,14194,14205,14208,14237,14401,14432,14446,14457,14548,14591,14604,14631,14648,14663,14669,14684,14688,14698,14703,14709,14725,14726,14744,14761,14762,14790,14829,14847,14849,14865,14895,14905,14911,14949,14970,14992,14999,15020,15031,15032,15038,15063,15094,15158,15171,15177,15187,15194,15204,15233,15259,15262,15270,15293,15298,15304,15346,15361,15365,15366,15407,15418,15429,15455,15469,15487,15516,15523,15594,15595,15619,15747,15751,15753,15785,15850,15858,15863,15875,15931,15933,15937,15981,15987,16005,16024,16043,16056,16090,16115,16122,16129,16140,16155,16157,16191,16211,16281,16323,16338,16359,16422,16438,16524,16547,16561,16564,16571,16573,16587,16626,16653,16668,16675,16689,16717,16749,16787,16816,16824,16840,16862,16863,16877,16894,16951,17002,17067,17086,17101,17137,17148,17166,17184,17242,17253,17273,17282,17287,17296,17339,17360,17490,17509,17530,17531,17539,17572,17618,17631,17635,17659,17701,17727,17759,17782,17818,17826,17853,17857,17862,17870,17879,17893,17920,18022,18074,18083,18173,18219,18220,18227,18311,18352,18377,18403,18432,18450,18464,18572,18595,18648,18696,18701,18808,18809,18817,18862,18866,18870,18880,18911,18912,18927,18929,18953,19004,19014,19054,19060,19063,19075,19155,19188,19189,19211,19217,19231,19235,19236,19245,19268,19283,19297,19308,19356,19407,19457,19472,19482,19484,19494,19507,19583,19591,19617,19625,19635,19648,19652,19706,19718,19720,19723,19730,19733,19747,19792,19802,19854,19944,19988,20015,20023,20054,20066,20076,20100,20127,20179,20208,20289,20333,20376,20396,20472,20488,20510,20522,20571,20596,20607,20615,20656,20664,20710,20737,20776,20824,20858,20947,20950,20969,21079,21126,21128,21181,21187,21198,21199,21223,21227,21242,21270,21297,21323,21372,21452,21496,21502,21555,21598,21693,21718,21719,21757,21791,21798,21850,21855,21879,21904,21932,21965,21987,22011,22040,22057,22088,22089,22099,22129,22130,22196,22218,22268,22306,22315,22336,22359,22419,22477,22484,22494,22562,22607,22634,22752,22753,22761,22786,22826,22827,22850,22851,22878,22909,22935,22974,22976,23011,23019,23042,23116,23139,23184,23213,23221,23242,23273,23287,23398,23430,23439,23456,23479,23493,23508,23525,23555,23562,23585,23594,23597,23602,23720,23730,23732,23761,23826,23828,23831,23853,23874,23887,23910,23936,23958,24001,24027,24034,24043,24062,24153,24176,24185,24199,24202,24208,24220,24222,24247,24253,24255,24281,24286,24316,24326,24334,24337,24364,24373,24399,24406,24429,24463,24477,24485,24497,24526,24539,24573,24577,24668,24718,24743,24788,24843,24849,24868,24899,24906,24907,24941,24951,24952,24956,24957,24964,24975,25022,25070,25071,25081,25082,25105,25153,25228,25280,25310,25318,25332,25352,25408,25415,25420,25429,25443,25445,25501,25535,25585,25603,25621,25630,25640,25643,25648,25653,25663,25664,25671,25673,25676,25703,25711,25717,25734,25747,25753,25755,25770,25771,25782,25785,25794,25800,25817,25833,25834,25841,25855,25864,25868,25877,25882,25884,25900,25921,25922,25933,25935,25948,25967,25975,26008,26020,26023,26026,26030,26050,26054,26056,26064,26092,26097,26113,26153,26160,26166,26173,26179,26185,26186,26187,26189,26191,26193,26205,26207,26221,26230,26231,26239,26240,26248,26262,26264,26275,26287,26292,26296,26297,26319,26327,26358,26367,26374,26380,26386,26388,26408,26431,26435,26440,26444,26451,26456,26459,26467,26469,26490,26516,26519,26536,26541,26550,26559,26560,26562,26571,26574,26575,26579,26583,26596,26601,26605,26629,26630,26635,26650,26664,26678,26684,26685,26698,26704,26709,26715,26716,26717,26723,26725,26732,26740,26741,26742,26745,26747,26748,26750,26752,26757,26760,26767,26768,26777,26788,26789,26801,26815,26818,26820,26824,26832,26848,26859,26896,26897,26912,26916,26933,26935,26936,26937,26944,26955,26959,26960,26964,26969,26976,26977,27001,27002,27003,27005,27009,27015,27018,27024,27025,27028,27050,27055,27056,27058,27063,27064,27082,27089,27100,27101,27103,27108,27109,27129,27136,27137,27150,27156,27161,27174,27192,27196,27204,27209,27212,27216,27218,27230,27238,27242,27252,27268,27269,27270,27272,27293,27294,27295,27298,27307,27308,27315,27317,27323,27327,27330,27350,27367,27376,27384,27427,27438,27466,27476,27478,27482,27487,27491,27497,27516,27570,27577,27589,27591,27595,27602,27644,27660,27673,27681,27701,27706,27709,27712,27714,27717,27718,27732,27737,27738,27748,27752,27753,27754,27763,27772,27786,27811,27827,27838,27839,27880,27905,27923,27932,27966,27982,28006,28031,28036,28038,28048,28050,28059,28066,28075,28094,28097,28102,28120,28127,28129,28137,28141,28154,28155,28176,28211,28215,28223,28232,28235,28237,28243,28255,28274,28276,28287,28293,28305,28308,28331,28345,28352,28356,28358,28361,28362,28363,28367,28368,28375,28376,28430,28435,28460,28466,28467,28471,28474,28475,28479,28482,28484,28488,28489,28494,28496,28497,28506,28519,28525,28530,28568,28611,28650,28654,28730,28731,28773,28863,28871,28887,28893,28894,28924,28995,29045,29078,29152,29166,29213,29226,29229,29272,29274,29284,29285,29307,29342,29372,29378,29379,29396,29399,29436,29474,29520,29532,29541,29545,29546,29555,29560,29578,29579,29598,29602,29603,29612,29617,29618,29663,29672,29716,29767,29779,29794,29818,29819,29934,29940,29966,29977,30093,30163,30168,30202,30333,30351,30373,30382,30395,30405,30406,30413,30440,30447,30450,30464,30465,30484,30504,30515,30525,30569,30580,30608,30613,30638,30687,30689,30721,30739,30741,30763,30967,30994,31016,31115,31167,31174,31188,31207,31218,31235,31311,31312,31314,31315,31317,31331,31337,31345,31355,31394,31399,31402,31431,31471,31527,31530,31568,31577,31586,31613,31679,31685,31735,31741,31760,31764,31820,31849,31863,31866,31931,31938,31939,31962,31982,32062,32069,32125,32172,32185,32225,32229,32239,32271,32374,32380,32397,32440,32441,32445,32494,32523,32548,32676,32689,32693,32699,32701,32767,32768,32776,32832,32855,32860,32870,32903,32915,32945,32973,32982,33033,33092,33099,33106,33116,33143,33146,33150,33221,33254,33271,33299,33301,33329,33346,33351,33499,33508,33569,33573,33580,33584,33744,33861,33872,33951,33952,33953,33956,33957,33964,33966,33974,33993,33999,34010,34014,34081,34082,34093,34105,34118,34122,34130,34161,34166,34171,34175,34191,34197,34204,34213,34226,34254,34257,34277,34308,34347,34377,34380,34405,34420,34432,34439,34451,34452,34458,34460,34467,34468,34470,34487,34488,34493,34500,34501,34518,34538,34543,34546,34555,34561,34578,34589,34605,34641,34646,34665,34718,34726,34731,34754,34759,34775,34776,34793,34802,34811,34825,34830,34836,34857,34861,34961,34963,34981,35021,35040,35055,35077,35084,35090,35100,35102,35104,35115,35116,35137,35138,35184,35191,35196,35209,35224,35232,35238,35239,35250,35289,35294,35295,35296,35311,35317,35345,35359,35365,35369,35376,35378,35387,35395,35397,35418,35419,35422,35435,35440,35448,35452,35453,35462,35465,35469,35484,35497,35507,35523,35526,35530,35540,35546,35548,35550,35554,35562,35565,35566,35575,35581,35614,35621,35623,35633,35641,35663,35710,35729,35744,35808,35827,35841,35866,35878,35882,35909,35915,35942,35948,35950,35956,35969,35971,35979,36015,36035,36066,36069,36070,36094,36154,36175,36176,36212,36216,36220,36228,36249,36250,36258,36262,36279,36281,36335,36338,36368,36373,36380,36385,36386,36418,36441,36452,36625,36790,36791,36792,36793,36803,36849,36859,36893,36910,36941,36984,37015,37040,37062,37104,37197,37245,37261,37358,37370,37429,37473,37508,37558,37560,37635,37643,37644,37652,37685,37757,37834,37902,38058,38113,38330,38418,38549,38559,38617,38666,38671,38681,38703,38723,38734,38806,38814,38821,38829,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,38921,38923,38925,38930,38932,38938,38939,38942,38963,38964,38965,38973,38974,38986,38988,39039,39064,39101,39110,39127,39133,39194,39244,39290,39293,39297,39415,39460,39470,39501,39519,39718,39837,39856,39857,39892,39942,39943,40059,40203,40271,40275,40319,40356,40391,40453,40483,40515,40545,40554,40560,40576,40629,40664,40674,40720,40728,40739,40746,40768,40773,40778,40780,40786,40839,40855,40860,40865,40880,40887,40893,40896,40967,40972,40993,41000,41004,41007,41009,41033,41039,41064,41076,41108,41123,41152,41153,41158,41163,41172,41174,41176,41189,41200,41201,41205,41212,41217,41225,41234,41272,41289,41290,41295,41322,41328,41334,41339,41343,41410,41415,41421,41431,41434,41479,41491,41500,41504,41505,41506,41507,41516,41528,41543,41548,41550,41571,41578,41581,41588,41591,41609,41611,41612,41613,41623,41628,41637,41645,41653,41654,41658,41659,41668,41669,41674,41685,41687,41690,41702,41733,41737,41741,41750,41757,41769,41774,41783,41786,41791,41792,41794,41815,41816,41821,41832,41840,41862,41876,41911,41912,41948,41964,41965,41968,41980,41995,42009,42023,42031,42034,42037,42049,42054,42079,42111,42133,42157,42176,42190,42206,42231,42282,42287,42290,42313,42325,42326,42329,42332,42350,42362,42367,42368,42389,42415,42453,42458,42480,42482,42493,42514,42515,42532,42536,42540,42565,42591,42623,42628,42650,42682,42688,42693,42736,42758,42811,42847,42860,42883,42888,42891,42933,42940,42941,42946,42965,42992,43028,43035,43043,43054,43063,43070,43071,43091,43093,43104,43117,43128,43130,43141,43146,43147,43154,43162,43167,43174,43207,43216,43217,43218,43221,43240,43241,43270,43271,43292,43305,43326,43358,43375,43385,43414,43432,43446,43450,43461,43465,43475,43477,43479,43517,43518,43537,43541,43554,43567,43572,43578,43584,43592,43619,43620,43623,43633,43653,43655,43660,43667,43675,43678,43681,43694,43695,43696,43720,43738,43770,43778,43792,43810,43815,43816,43842,43847,43855,43856,43909,43911,43927,43931,43937,44002,44018,44037,44042,44078,44103,44122,44143,44177,44186,44187,44237,44249,44250,44253,44254,44292,44303,44317,44378,44380,44399,44445,44451,44452,44459,44469,44475,44476,44483,44499,44565,44575,44577,44581,44587,44632,44633,44640,44656,44718,44735,44753,44754,44788,44794,44799,44800,44807,44814,44826,44829,44839,44844,44873,44881,44912,44916,44927,44932,44933,44935,44936,44941,44954,44966,44976,44994,44998,45006,45054,45060,45063,45069,45115,45140,45141,45174,45175,45180,45181,45210,45213,45223,45226,45231,45247,45249,45265,45274,45281,45282,45286,45300,45308,45313)
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 | 2118 | 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.97 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.38 ms |
System lock | 0.02 ms |
optimizing | 0.13 ms |
statistics | 3.15 ms |
preparing | 1.57 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.35 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.07 ms |
cleaning up | 0.03 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 |