Tiempo de la consulta: 4.97 ms Después de la última consulta: 1.85 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.393 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 12:10:41')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 12:10:41')
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(12,169,206,259,326,327,370,388,390,448,454,455,596,625,626,743,793,843,915,980,994,1051,1066,1245,1327,1359,1398,1432,1491,1555,1620,1686,1701,1724,1741,1754,1775,1839,2038,2243,2369,2381,2574,2687,2710,2780,2808,2825,2884,2943,2972,3009,3026,3037,3059,3165,3173,3188,3193,3257,3281,3292,3329,3346,3356,3372,3373,3375,3376,3593,3721,3722,3752,3772,3826,3828,3977,4026,4049,4266,4337,4409,4411,4451,4461,4469,4486,4507,4510,4520,4583,4584,4620,4640,4672,4787,4832,5092,5094,5096,5170,5183,5244,5282,5283,5298,5301,5469,5505,5543,5638,5639,5651,5677,5683,5688,5703,5802,5831,5848,5895,6093,6142,6166,6176,6256,6335,6345,6424,6476,6477,6538,6573,6606,6612,6681,6783,6944,6998,7024,7092,7105,7113,7139,7211,7266,7294,7325,7346,7395,7428,7449,7513,7533,7569,7577,7615,7681,7869,7918,8002,8016,8042,8194,8201,8294,8325,8386,8393,8435,8454,8529,8532,8568,8707,8729,8940,9057,9061,9147,9190,9336,9367,9401,9470,9559,9641,9873,9916,9932,9934,10018,10199,10371,10407,10422,10464,10477,10501,10562,10572,10584,10681,10695,10710,10764,10779,10792,10980,10986,11009,11044,11089,11161,11207,11212,11231,11241,11263,11301,11317,11320,11327,11354,11361,11386,11398,11408,11431,11443,11462,11465,11480,11541,11549,11551,11590,11609,11633,11680,11684,11693,11694,11699,11701,11705,11713,11750,11751,11763,11788,11793,11794,11807,11814,11913,12006,12020,12036,12052,12069,12136,12201,12266,12305,12317,12324,12334,12370,12375,12470,12506,12514,12550,12648,12698,12819,12839,12870,12877,13056,13067,13168,13177,13202,13209,13222,13231,13250,13313,13348,13353,13358,13379,13386,13409,13429,13440,13454,13475,13581,13589,13594,13708,13850,13851,13892,13894,13925,13928,13941,13947,13970,14022,14040,14071,14078,14126,14129,14146,14155,14199,14211,14228,14234,14268,14403,14427,14432,14451,14480,14538,14654,14658,14689,14808,14814,14838,14860,14862,14865,14873,14944,14969,14974,14982,14988,15002,15017,15020,15060,15087,15107,15123,15133,15140,15144,15148,15171,15180,15226,15227,15314,15325,15358,15371,15414,15417,15443,15613,15619,15642,15646,15689,15690,15710,15723,15733,15758,15762,15788,15796,15825,15840,15855,15865,15871,15878,15901,15954,15967,15969,16080,16081,16088,16102,16103,16120,16121,16134,16167,16176,16220,16245,16261,16279,16324,16328,16353,16404,16416,16436,16463,16547,16559,16561,16563,16569,16578,16607,16613,16622,16626,16627,16682,16742,16743,16747,16756,16778,16820,16823,16866,16880,16905,16909,16929,17028,17055,17072,17136,17158,17167,17214,17251,17269,17315,17335,17337,17346,17395,17424,17439,17441,17449,17458,17471,17483,17500,17527,17569,17606,17608,17664,17705,17733,17756,17774,17816,17831,17885,17918,17951,17973,17986,18075,18077,18088,18092,18102,18145,18165,18179,18231,18241,18304,18306,18307,18315,18327,18345,18366,18378,18391,18401,18425,18473,18531,18551,18566,18595,18643,18652,18681,18696,18732,18779,18792,18821,18890,18920,18929,18936,18993,19019,19027,19106,19136,19137,19172,19179,19219,19281,19285,19405,19465,19487,19508,19647,19706,19710,19748,19778,19790,19796,19806,19860,19874,19957,19996,20008,20035,20094,20098,20141,20166,20191,20205,20399,20418,20448,20535,20567,20599,20662,20663,20780,20839,20921,20928,20966,20967,20988,20997,21006,21036,21057,21076,21095,21105,21149,21203,21214,21258,21270,21279,21308,21316,21357,21375,21384,21408,21473,21560,21564,21683,21720,21741,21790,21817,21835,21880,21914,21967,21995,22031,22038,22209,22249,22292,22365,22411,22450,22453,22498,22533,22560,22577,22696,22726,22779,22857,22870,22886,22938,23065,23161,23170,23310,23319,23353,23358,23397,23400,23417,23457,23459,23482,23498,23520,23788,23932,24034,24082,24109,24131,24174,24190,24210,24224,24261,24385,24485,24690,24695,24697,24708,24725,24787,24920,24933,25030,25097,25112,25124,25137,25145,25157,25208,25600,25689,25813,25822,25864,25875,25902,25966,26000,26037,26043,26044,26082,26083,26100,26148,26159,26219,26227,26241,26288,26306,26336,26377,26403,26405,26437,26447,26454,26486,26504,26505,26554,26569,26578,26630,26652,26707,26762,26804,26816,26825,26843,26874,26897,26914,26949,26968,26982,26991,27023,27027,27057,27233,27240,27291,27340,27344,27354,27376,27437,27502,27511,27522,27702,27803,27843,27875,28092,28152,28193,28218,28234,28239,28281,28327,28334,28340,28436,28437,28540,28548,28553,28555,28615,28616,28629,28656,28665,28666,28668,28671,28706,28707,28725,28727,28728,28745,28763,28776,28795,28799,28800,28803,28807,28828,28833,28834,28844,28847,28866,28872,28878,28925,28931,29006,29008,29013,29028,29127,29137,29201,29209,29329,29374,29389,29418,29459,29468,29622,29837,29847,29894,29918,29931,30138,30199,30262,30572,30573,30909,31050,31401,31533,31716,31791,31837,31908,32286,32288,32719,32739,32755,32842,32854,32965,33107,33164,33327,33503,33997,34265,34267,34291,34405,34543,34595,34785,34862,34902,34942,34969,34982,35047,35051,35071,35072,35073,35088,35097,35156,35165,35167,35206,35269,35294,35298,35308,35326,35427,35430,35540,35564,35588,35657,35674,35685,35694,35724,35931,36012,36160,36165,36167,36191,36247,36256,36285,36325,36346,36349,36355,36365,36370,36397,36421,36433,36442,36463,36489,36527,36574,36575,36576,36595,36651,36662,36669,36678,36698,36722,36747,36750,36795,36798,36806,36811,36829,36836,36885,36890,36922,36929,36955,36963,37006,37016,37033,37129,37135,37174,37225,37244,37251,37282,37338,37355,37375,37377,37415,37420,37459,37460,37528,37529,37532,37543,37544,37554,37557,37633,37647,37662,37738,37740,37767,37773,37785,37788,37794,37910,37911,37914,37972,37996,38007,38019,38047,38143,38165,38175,38178,38203,38204,38212,38240,38242,38243,38246,38266,38278,38302,38345,38365,38370,38372,38391,38392,38417,38421,38422,38429,38437,38438,38453,38470,38503,38506,38558,38580,38588,38590,38598,38599,38623,38633,38663,38676,38688,38704,38721,38734,38753,38764,38765,38781,38821,38823,38825,38826,38829,38837,38838,38888,38909,38922,38955,38964,38981,38988,39019,39023,39024,39054,39056,39061,39070,39079,39090,39104,39117,39139,39140,39148,39149,39151,39155,39160,39170,39175,39198,39228,39235,39244,39256,39257,39299,39301,39307,39309,39310,39325,39329,39337,39346,39357,39378,39425,39435,39449,39455,39471,39485,39486,39504,39521,39529,39534,39541,39545,39546,39547,39548,39573,39582,39591,39633,39636,39662,39676,39678,39692,39695,39696,39703,39732,39754,39757,39765,39767,39782,39792,39793,39810,39828,39836,39869,39881,39882,39896,39897,39898,39920,39934,39947,39971,39974,40003,40015,40052,40085,40107,40110,40118,40119,40136,40167,40194,40245,40251,40288,40289,40290,40303,40312,40313,40314,40320,40334,40344,40353,40358,40379,40419,40481,40482,40508,40539,40542,40568,40590,40625,40655,40659,40686,40698,40700,40743,40744,40757,40763,40776,40784,40791,40827,40879,40925,40965,40971,40986,41012,41063,41084,41105,41117,41179,41233,41240,41249,41282,41294,41348,41352,41353,41358,41369,41371,41380,41381,41382,41385,41386,41387,41403,41407,41424,41446,41451,41479,41520,41530,41532,41535,41551,41563,41569,41585,41642,41668,41705,41723,41738,41744,41755,41785,41789,41802,41866,41870,41874,41880,41892,41906,41925,41939,41955,42006,42034,42051,42067,42086,42090,42104,42106,42160,42233,42309,42394,42404,42427,42437,42505,42520,42537,42560,42603,42622,42664,42666,42776,42793,42798,42822,42851,42859,42866,42882,42884,42911,42912,42963,42978,43005,43015,43021,43027,43031,43064,43065,43075,43086,43090,43094,43099,43107,43111,43162,43163,43165,43235,43256,43259,43263,43273,43285,43303,43316,43317,43328,43331,43351,43353,43406,43413,43416,43430,43438,43494,43502,43520,43545,43577,43580,43585,43586,43603,43611,43613,43626,43631,43645,43648,43659,43697,43721,43753,43776,43819,43825,43827,43828,43851,43853,43871,43888,43890,43904,43938,43944,43945,44019,44039,44067,44078,44100,44101,44197,44236,44294,44352,44408,44502,44522,44542,44620,44623,44650,44654,44675,44752,44817,44833,44859,44893,45078,45134,45139,45217,45236,45288,45293,45295)
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 | 1341 | 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.64 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.28 ms |
System lock | 0.02 ms |
optimizing | 0.09 ms |
statistics | 2.00 ms |
preparing | 1.07 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.31 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.06 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 |