Tiempo de la consulta: 14.43 ms Después de la última consulta: 2.19 ms Consulta a la memoria: 1.276 MB memoria antes de la consulta: 4.492 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 04:41:17')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 04:41:17')
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,5,9,21,45,46,54,62,65,71,185,212,274,308,311,415,477,500,594,624,643,659,764,1066,1081,1099,1248,1251,1252,1253,1255,1328,1335,1476,1479,1480,1514,1563,1571,1623,1628,1638,1641,1653,1785,1796,1806,2013,2033,2078,2084,2101,2125,2129,2324,2394,2397,2432,2452,2469,2494,2560,2605,2636,2647,2654,2671,2688,2716,2786,2812,2849,2909,2929,2954,2964,3001,3016,3054,3065,3110,3174,3193,3196,3202,3266,3454,3468,3563,3663,3685,3704,3750,3760,3767,3776,3797,3824,3833,3854,3872,3894,3913,3920,3960,3983,4034,4101,4110,4129,4144,4148,4150,4204,4227,4240,4246,4247,4284,4323,4325,4327,4339,4342,4409,4423,4456,4467,4492,4548,4575,4581,4772,4809,4823,4840,4845,4859,4863,4882,4940,4989,5008,5049,5247,5259,5381,5387,5396,5422,5437,5478,5483,5496,5512,5528,5545,5609,5628,5686,5697,5699,5801,5881,5886,5895,5909,6056,6065,6088,6100,6128,6155,6209,6227,6257,6262,6278,6279,6342,6354,6358,6360,6362,6369,6407,6440,6464,6465,6515,6517,6545,6589,6602,6608,6649,6660,6678,6709,6720,6726,6762,6789,6807,6808,6835,6840,6863,6865,6881,6988,7014,7077,7111,7136,7216,7245,7246,7250,7258,7272,7276,7331,7336,7364,7414,7437,7439,7444,7449,7485,7526,7570,7586,7605,7614,7618,7625,7651,7659,7720,7724,7732,7752,7771,7784,7787,7789,7872,7897,7903,7925,7935,7942,7953,7965,7985,7995,8004,8030,8055,8090,8109,8152,8153,8160,8179,8184,8227,8234,8265,8267,8302,8370,8378,8421,8449,8457,8507,8550,8566,8567,8611,8623,8625,8644,8660,8700,8721,8750,8753,8760,8762,8777,8794,8799,8813,8826,8832,8864,8897,8900,8925,8954,8978,8983,9029,9057,9063,9087,9120,9204,9236,9246,9255,9286,9328,9340,9350,9355,9364,9382,9390,9423,9429,9461,9477,9489,9495,9571,9578,9600,9610,9738,9769,9776,9815,9817,9818,9829,9838,9878,9904,9908,9922,9924,9932,9956,9999,10004,10060,10111,10132,10175,10190,10195,10265,10269,10313,10414,10430,10448,10475,10477,10513,10529,10553,10617,10630,10642,10694,10754,10756,10765,10839,10926,10933,10993,11023,11031,11041,11073,11121,11187,11195,11250,11258,11286,11338,11387,11418,11488,11545,11554,11687,11761,11792,11796,11899,11921,11929,11948,11955,12248,12249,12508,12553,12566,12602,12617,12620,12632,12638,12689,12690,12746,12810,12853,12901,12944,12976,13002,13006,13029,13097,13117,13144,13146,13166,13209,13231,13246,13294,13298,13356,13376,13385,13544,13546,13550,13557,13573,13669,13687,13697,13702,13703,13712,13718,13731,13738,13742,13760,13763,13789,13804,13861,13946,13961,13973,13996,14062,14063,14074,14108,14114,14117,14137,14141,14152,14188,14197,14279,14283,14311,14351,14355,14362,14389,14396,14420,14467,14490,14500,14512,14513,14515,14532,14554,14601,14616,14646,14662,14683,14698,14711,14730,14731,14739,14753,14754,14759,14765,14820,14824,14825,14856,14859,14896,14897,14939,14949,14992,14999,15006,15032,15037,15041,15064,15069,15081,15094,15109,15148,15160,15178,15179,15193,15202,15220,15221,15237,15268,15297,15326,15347,15357,15382,15388,15423,15448,15456,15457,15465,15471,15479,15482,15487,15492,15511,15551,15570,15611,15617,15636,15637,15640,15738,15757,15767,15783,15818,15829,15861,15866,15909,15913,15932,15935,15944,15959,15973,15981,15988,16036,16039,16042,16059,16082,16084,16094,16097,16127,16129,16140,16153,16156,16161,16181,16206,16218,16248,16256,16266,16289,16292,16314,16315,16373,16374,16403,16423,16449,16452,16458,16459,16478,16489,16521,16552,16577,16582,16638,16698,16734,16759,16788,16803,16828,16836,16848,16859,16889,16890,16913,16929,16957,16981,16991,17053,17074,17102,17115,17138,17145,17155,17160,17216,17232,17233,17249,17267,17273,17280,17285,17309,17381,17468,17484,17596,17633,17634,17650,17702,17727,17742,17757,17766,17797,17840,17844,17855,17859,17864,17875,17893,17895,17910,17926,17952,17961,17966,18052,18054,18060,18062,18112,18122,18127,18129,18142,18157,18180,18201,18208,18216,18233,18255,18267,18274,18292,18295,18314,18326,18344,18352,18354,18362,18384,18409,18431,18442,18446,18460,18498,18521,18539,18544,18550,18561,18564,18566,18577,18608,18660,18679,18707,18709,18714,18772,18800,18846,18847,18859,18862,18869,18878,18898,18904,18916,18922,18931,18937,18954,18975,18977,18980,18991,18993,18995,19004,19028,19034,19042,19091,19105,19112,19115,19124,19126,19128,19132,19135,19149,19155,19158,19207,19217,19218,19227,19240,19247,19294,19304,19313,19350,19366,19446,19453,19464,19502,19530,19550,19561,19581,19595,19604,19608,19637,19652,19655,19661,19684,19700,19713,19732,19768,19815,19852,19855,19867,19872,19909,19913,19945,19961,19983,20018,20030,20034,20036,20058,20127,20145,20199,20217,20241,20250,20260,20264,20268,20286,20327,20347,20348,20350,20354,20358,20374,20376,20378,20393,20400,20403,20423,20429,20444,20461,20480,20533,20534,20564,20578,20579,20602,20603,20638,20649,20659,20661,20678,20712,20730,20741,20755,20757,20768,20771,20779,20796,20797,20802,20812,20813,20826,20828,20849,20850,20856,20906,20915,20950,20959,20974,20978,20993,21000,21051,21057,21062,21069,21107,21108,21118,21143,21161,21165,21190,21224,21229,21249,21257,21305,21325,21369,21371,21381,21397,21433,21434,21435,21458,21464,21489,21518,21546,21552,21554,21578,21590,21593,21606,21611,21641,21710,21737,21740,21743,21744,21764,21765,21776,21777,21786,21855,21858,21883,21894,21926,21944,21952,21976,21982,22010,22019,22026,22040,22043,22052,22061,22063,22092,22097,22113,22130,22142,22160,22176,22189,22214,22229,22237,22244,22245,22246,22252,22261,22270,22276,22288,22298,22313,22343,22348,22407,22435,22455,22456,22459,22461,22477,22489,22517,22524,22529,22536,22579,22594,22611,22617,22625,22647,22648,22649,22668,22692,22715,22733,22739,22763,22784,22785,22803,22819,22837,22849,22889,22890,22900,22904,22920,22957,22973,23000,23016,23022,23026,23034,23043,23052,23055,23060,23065,23067,23081,23092,23131,23185,23195,23196,23199,23200,23201,23222,23234,23237,23241,23247,23250,23260,23280,23307,23313,23318,23320,23325,23326,23328,23335,23339,23360,23399,23457,23461,23467,23516,23546,23559,23564,23582,23647,23654,23668,23678,23679,23691,23737,23767,23857,23860,23890,23918,23922,23930,23954,23962,24030,24075,24076,24102,24104,24111,24141,24152,24174,24183,24186,24191,24192,24230,24242,24266,24269,24270,24273,24274,24277,24282,24288,24293,24312,24320,24327,24332,24357,24361,24366,24370,24371,24388,24391,24399,24407,24428,24450,24451,24479,24491,24497,24503,24523,24531,24539,24565,24568,24592,24616,24635,24644,24677,24683,24692,24705,24714,24717,24727,24733,24788,24806,24814,24816,24823,24837,24844,24883,24899,24910,24936,24950,24953,24964,24968,25003,25026,25069,25072,25098,25107,25125,25126,25133,25219,25222,25225,25244,25253,25256,25278,25282,25304,25318,25333,25340,25377,25380,25382,25403,25411,25413,25417,25534,25580,25609,25617,25624,25631,25639,25640,25644,25645,25648,25673,25709,25714,25730,25736,25747,25764,25771,25785,25787,25798,25816,25823,25832,25835,25845,25850,25852,25896,25898,25943,25963,25964,25968,25969,25979,25993,26061,26070,26107,26109,26122,26154,26167,26171,26178,26183,26195,26202,26256,26261,26273,26328,26348,26353,26361,26378,26410,26429,26433,26438,26439,26454,26468,26471,26492,26493,26501,26504,26521,26522,26529,26563,26570,26630,26648,26655,26670,26679,26681,26686,26712,26722,26724,26733,26763,26766,26767,26770,26779,26800,26807,26808,26816,26866,26873,26894,26901,26905,26908,26910,26926,26950,26951,26964,26972,26980,26983,26985,26991,26992,26996,27002,27011,27018,27026,27036,27047,27054,27071,27117,27118,27120,27131,27133,27138,27150,27170,27185,27186,27216,27219,27220,27235,27238,27246,27252,27266,27273,27280,27287,27292,27311,27314,27321,27322,27359,27363,27375,27383,27406,27415,27416,27418,27431,27438,27450,27452,27465,27475,27496,27521,27535,27536,27545,27550,27576,27580,27593,27610,27644,27686,27688,27704,27713,27715,27717,27721,27727,27731,27767,27772,27779,27833,27837,27842,27859,27891,27917,27931,27936,27944,27947,27974,28005,28012,28033,28034,28039,28045,28062,28074,28081,28082,28086,28096,28099,28100,28123,28126,28170,28180,28181,28189,28225,28228,28231,28233,28306,28310,28312,28313,28318,28320,28352,28364,28381,28401,28411,28418,28439,28451,28469,28471,28486,28492,28509,28528,28572,28588,28603,28630,28639,28644,28645,28650,28653,28658,28659,28708,28716,28719,28737,28743,28760,28779,28780,28802,28831,28838,28845,28875,28934,28956,28963,28965,28977,28989,28990,28991,28996,29008,29009,29045,29047,29070,29081,29100,29125,29150,29152,29153,29167,29170,29174,29179,29187,29190,29197,29200,29207,29225,29236,29239,29245,29246,29254,29267,29268,29273,29276,29292,29296,29304,29306,29313,29314,29319,29330,29334,29336,29338,29340,29344,29356,29364,29393,29417,29424,29442,29443,29444,29476,29479,29501,29521,29522,29548,29554,29583,29603,29605,29651,29652,29667,29673,29685,29687,29710,29735,29754,29755,29781,29784,29818,29820,29838,29843,29845,29864,29871,29878,29879,29882,29900,29905,29913,29916,29922,29923,29935,29949,29952,29958,30014,30019,30020,30059,30096,30105,30122,30165,30178,30198,30246,30370,30396,30411,30426,30460,30462,30505,30556,30577,30579,30609,30669,30689,30747,30753,30755,30773,30794,30804,30820,30821,30827,30854,30861,30908,30952,31005,31170,31191,31194,31269,31277,31309,31393,31427,31429,31438,31439,31471,31501,31538,31546,31547,31548,31549,31562,31588,31656,31660,31672,31677,31678,31689,31790,31816,31817,31823,31826,31841,31851,31874,31879,31944,31993,31997,32003,32032,32063,32117,32180,32213,32218,32238,32246,32250,32253,32261,32262,32263,32302,32303,32305,32323,32376,32381,32433,32435,32507,32511,32512,32524,32525,32530,32533,32550,32570,32590,32702,32768,32800,32803,32810,32842,32843,32855,32868,32896,32919,32923,32943,32981,33008,33040,33042,33048,33088,33129,33132,33136,33144,33177,33199,33226,33379,33431,33439,33459,33460,33510,33552,33568,33588,33604,33621,33649,33709,33725,33757,33805,33806,33807,33809,33834,33866,33950,34005,34026,34042,34078,34099,34103,34109,34116,34162,34179,34184,34211,34217,34229,34237,34241,34258,34260,34264,34269,34271,34282,34289,34292,34297,34322,34326,34343,34350,34357,34378,34402,34410,34414,34433,34440,34454,34456,34461,34462,34486,34509,34515,34524,34576,34584,34606,34613,34617,34627,34642,34650,34654,34673,34676,34678,34682,34707,34725,34753,34758,34778,34788,34801,34819,34834,34837,34856,34927,34932,34938,34961,34963,34994,34996,35020,35026,35049,35052,35056,35081,35082,35083,35085,35109,35121,35124,35125,35126,35129,35146,35151,35152,35154,35166,35170,35172,35194,35204,35212,35213,35215,35226,35230,35243,35248,35258,35259,35276,35299,35305,35320,35337,35379,35381,35398,35430,35442,35502,35512,35515,35518,35547,35563,35567,35583,35596,35599,35601,35617,35625,35650,35677,35678,35686,35689,35718,35742,35766,35773,35780,35794,35796,35806,35815,35816,35825,35855,35865,35883,35885,35888,35890,35893,35907,35911,35914,35920,35940,35977,35998,35999,36011,36022,36038,36040,36069,36085,36096,36098,36120,36131,36153,36158,36186,36197,36200,36207,36211,36215,36237,36241,36244,36249,36257,36271,36272,36273,36281,36287,36292,36297,36307,36312,36318,36327,36331,36351,36352,36358,36434,36440,36441,36443,36444,36451,36468,36485,36487,36490,36504,36509,36510,36517,36518,36545,36551,36563,36568,36597,36621,36641,36675,36712,36718,36745,36751,36770,36779,36782,36786,36809,36814,36817,36841,36895,36898,36927,36934,36939,36961,36976,37005,37017,37025,37040,37042,37062,37063,37070,37076,37087,37091,37112,37114,37116,37148,37150,37153,37167,37170,37204,37230,37309,37403,37439,37454,37496,37519,37540,37588,37596,37618,37663,37703,37706,37761,37789,37792,37793,37802,37807,37841,37852,37873,37893,37896,37897,37898,37900,37919,37973,38002,38005,38006,38024,38025,38026,38027,38088,38092,38093,38103,38110,38111,38114,38119,38122,38128,38140,38166,38173,38175,38179,38189,38190,38191,38198,38214,38219,38221,38248,38252,38253,38254,38284,38285,38292,38305,38310,38313,38315,38319,38340,38398,38440,38446,38447,38450,38476,38500,38502,38530,38548,38576,38584,38591,38600,38654,38662,38674,38690,38711,38784,38807,38831,38839,38854,38866,38879,38905,38917,38950,38982,38983,38986,38994,39027,39035,39059,39129,39150,39158,39167,39176,39192,39245,39261,39276,39279,39287,39294,39296,39347,39367,39375,39389,39391,39407,39444,39455,39481,39510,39603,39609,39622,39659,39681,39722,39747,39749,39768,39802,39823,39857,39864,39924,39948,40018,40025,40038,40043,40068,40083,40091,40097,40108,40170,40177,40200,40202,40231,40252,40276,40309,40319,40340,40398,40421,40423,40436,40438,40460,40473,40485,40497,40520,40535,40553,40556,40586,40614,40631,40667,40688,40689,40692,40708,40748,40759,40785,40805,40809,40822,40850,40881,40884,40892,40894,40907,40925,40931,40937,40954,40957,40958,40959,40981,40984,40988,40990,41040,41054,41059,41068,41077,41115,41141,41220,41228,41232,41255,41266,41286,41288,41301,41321,41325,41359,41375,41405,41418,41430,41436,41484,41555,41570,41573,41576,41592,41594,41595,41599,41624,41635,41649,41650,41660,41724,41728,41764,41782,41800,41806,41807,41834,41839,41865,41871,41879,41888,41927,41950,41956,41957,41992,42004,42040,42057,42065,42117,42144,42150,42154,42163,42174,42188,42212,42218,42262,42292,42314,42328,42366,42405,42431,42439,42448,42490,42496,42509,42511,42529,42542,42608,42652,42689,42691,42729,42741,42787,42806,42863,42934,42945,42960,42975,42997,43009,43042,43073,43143,43145,43148,43198,43202,43203,43222,43229,43234,43244,43251,43259,43290,43294,43327,43345,43367,43387,43389,43407,43433,43459,43487,43499,43508,43509,43530,43534,43539,43550,43601,43610,43615,43663,43682,43686,43687,43715,43727,43789,43794,43807,43838,43844,43846,43852,43868,43901,43920,43965,44026,44124,44125,44155,44262,44299,44340,44346,44351,44365,44400,44431,44484,44491,44498,44501,44565,44578,44588,44606,44607,44608,44611,44613,44637,44643,44655,44698,44701,44741,44779,44791,44818,44836,44864,44869,44894,44955,45051,45118,45122,45147,45157,45166,45191,45201,45230,45234,45240,45241,45287,45302,45303)
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 | 2355 | 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.18 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.48 ms |
System lock | 0.02 ms |
optimizing | 0.16 ms |
statistics | 3.57 ms |
preparing | 1.82 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 6.18 ms |
end | 0.02 ms |
query end | 0.04 ms |
closing tables | 0.03 ms |
freeing items | 0.13 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 |