Tiempo de la consulta: 16.74 ms Después de la última consulta: 1.73 ms Consulta a la memoria: 1.487 MB memoria antes de la consulta: 4.436 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 13:39:50')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 13:39:50')
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(5,7,9,14,29,39,56,60,62,63,65,71,73,75,78,86,87,149,150,163,164,177,182,183,184,196,199,206,221,226,227,232,240,257,259,262,263,275,279,291,294,299,307,331,349,357,366,391,428,429,472,477,481,501,510,525,526,530,531,546,563,588,611,619,659,662,663,666,667,674,697,705,746,765,769,784,800,801,802,805,808,816,823,832,835,863,869,873,910,923,939,940,954,969,973,974,977,982,983,999,1004,1005,1011,1021,1029,1055,1078,1091,1095,1101,1102,1104,1114,1119,1158,1182,1183,1195,1205,1207,1212,1231,1247,1252,1253,1255,1268,1271,1276,1289,1308,1309,1316,1319,1337,1346,1347,1363,1409,1410,1428,1432,1439,1441,1444,1485,1503,1509,1538,1539,1557,1566,1606,1619,1629,1648,1675,1693,1694,1697,1715,1724,1751,1771,1785,1794,1795,1796,1808,1810,1815,1843,1854,1855,1862,1867,1879,1881,1899,1918,1919,1920,1930,1941,1960,1961,1968,1975,1984,1994,1995,2001,2008,2013,2015,2029,2035,2061,2075,2081,2088,2091,2121,2137,2150,2155,2157,2161,2181,2188,2195,2233,2261,2287,2290,2293,2309,2338,2371,2392,2395,2402,2403,2455,2471,2472,2527,2532,2537,2551,2562,2586,2587,2597,2638,2643,2688,2722,2743,2797,2814,2824,2843,2851,2883,2888,2953,2954,2956,2960,3027,3035,3055,3066,3100,3106,3107,3109,3146,3147,3169,3180,3207,3208,3280,3342,3361,3364,3368,3369,3387,3409,3412,3451,3454,3473,3474,3491,3499,3520,3548,3552,3553,3554,3571,3590,3633,3648,3682,3683,3689,3706,3748,3769,3782,3806,3819,3853,3858,3872,3913,3919,3922,3926,3931,3962,3991,4004,4034,4050,4068,4069,4110,4129,4166,4177,4231,4241,4301,4319,4327,4358,4361,4390,4468,4476,4499,4503,4513,4527,4529,4532,4558,4616,4620,4622,4623,4626,4666,4699,4713,4751,4752,4760,4767,4800,4803,4813,4815,4822,4831,4844,4846,4865,4933,4973,5055,5087,5134,5139,5153,5154,5160,5161,5220,5230,5244,5247,5257,5295,5318,5370,5415,5439,5442,5451,5461,5469,5474,5491,5559,5608,5647,5751,5780,5795,5797,5851,5881,5894,5999,6030,6056,6081,6089,6141,6148,6198,6204,6268,6278,6279,6319,6339,6391,6409,6412,6415,6420,6433,6435,6442,6447,6453,6456,6463,6472,6475,6476,6477,6485,6534,6548,6605,6616,6643,6684,6715,6719,6722,6744,6759,6833,6845,6855,6888,6889,6944,6953,6958,6978,7010,7013,7014,7022,7030,7048,7061,7077,7078,7120,7137,7149,7185,7195,7233,7242,7246,7258,7272,7324,7389,7418,7439,7455,7459,7463,7491,7492,7535,7554,7592,7595,7605,7648,7667,7703,7718,7741,7751,7819,7837,7886,7923,7950,7955,7964,7965,7978,7987,8027,8042,8061,8070,8086,8100,8116,8142,8158,8163,8181,8192,8203,8214,8220,8231,8241,8279,8285,8291,8295,8314,8334,8345,8351,8381,8397,8453,8522,8523,8538,8547,8556,8565,8588,8592,8602,8612,8634,8646,8649,8660,8664,8668,8688,8689,8704,8707,8711,8715,8724,8779,8796,8801,8829,8836,8851,8854,8858,8883,8895,8935,9039,9059,9064,9071,9073,9157,9166,9176,9189,9237,9277,9279,9343,9351,9359,9369,9401,9412,9434,9452,9457,9458,9463,9467,9488,9504,9554,9572,9593,9604,9633,9646,9675,9676,9688,9690,9710,9770,9773,9820,9901,9922,9924,9930,9976,10038,10069,10073,10087,10096,10120,10123,10132,10180,10187,10190,10209,10211,10218,10222,10236,10245,10278,10307,10322,10347,10361,10377,10414,10490,10519,10570,10572,10610,10614,10630,10650,10676,10694,10696,10717,10729,10783,10789,10791,10793,10827,10840,10846,10921,10945,10958,10971,11001,11059,11080,11095,11121,11184,11230,11239,11258,11267,11289,11304,11320,11323,11328,11338,11358,11402,11414,11428,11438,11446,11464,11510,11555,11563,11568,11571,11594,11742,11848,11859,11865,11951,11974,11991,12004,12035,12076,12108,12148,12218,12242,12248,12331,12398,12401,12408,12415,12463,12474,12505,12537,12550,12557,12576,12622,12625,12639,12667,12672,12686,12723,12773,12808,12844,12853,12868,12875,12974,12978,12984,12997,13012,13034,13058,13059,13126,13138,13149,13246,13252,13261,13268,13277,13352,13414,13497,13543,13600,13646,13663,13676,13677,13695,13697,13707,13713,13715,13723,13742,13764,13838,13853,13883,13896,13920,13933,13963,13990,13995,14074,14082,14117,14123,14150,14158,14167,14200,14244,14262,14267,14273,14282,14284,14303,14327,14345,14365,14381,14397,14407,14438,14439,14440,14456,14471,14485,14486,14507,14513,14595,14598,14600,14609,14657,14666,14674,14683,14684,14694,14703,14714,14752,14794,14796,14806,14828,14865,14923,14964,14965,14969,14976,14980,14983,15009,15012,15015,15032,15038,15048,15063,15087,15094,15101,15104,15108,15111,15115,15122,15127,15129,15139,15167,15192,15203,15206,15213,15215,15235,15243,15245,15258,15295,15301,15312,15326,15347,15362,15370,15378,15386,15393,15411,15429,15449,15453,15460,15475,15497,15499,15533,15537,15544,15548,15563,15575,15588,15604,15633,15643,15661,15673,15712,15725,15728,15757,15781,15782,15783,15789,15804,15807,15857,15864,15866,15875,15893,15907,15913,15915,15935,15964,15973,16000,16025,16034,16059,16070,16092,16093,16112,16122,16136,16153,16224,16257,16274,16314,16320,16326,16327,16341,16342,16359,16374,16392,16433,16451,16454,16458,16498,16507,16509,16534,16562,16587,16588,16602,16612,16625,16653,16659,16663,16664,16666,16686,16718,16726,16737,16750,16767,16791,16798,16805,16817,16829,16830,16832,16853,16886,16889,16913,16930,16936,16955,16959,16981,16995,16996,17004,17005,17007,17023,17048,17054,17055,17056,17066,17115,17125,17128,17132,17140,17159,17161,17166,17215,17216,17243,17257,17273,17277,17322,17323,17329,17333,17372,17382,17388,17392,17401,17429,17432,17434,17435,17438,17439,17442,17457,17464,17472,17475,17476,17491,17517,17541,17554,17557,17592,17596,17620,17634,17644,17646,17672,17683,17699,17702,17709,17730,17731,17733,17737,17753,17757,17767,17781,17791,17798,17799,17802,17806,17807,17818,17831,17840,17854,17890,17895,17908,17912,17920,17934,17936,17980,18007,18031,18034,18036,18071,18098,18100,18108,18134,18150,18155,18157,18217,18230,18239,18296,18311,18316,18352,18355,18357,18367,18368,18369,18383,18436,18444,18446,18480,18492,18542,18547,18561,18562,18569,18577,18592,18612,18631,18641,18657,18682,18689,18695,18733,18737,18739,18754,18764,18765,18769,18773,18779,18781,18802,18805,18827,18832,18869,18900,18910,18915,18920,18925,18934,18942,18951,18955,18977,18981,18982,18991,18995,18998,19000,19015,19022,19038,19055,19065,19069,19073,19080,19083,19091,19105,19108,19110,19132,19136,19139,19142,19149,19171,19183,19187,19208,19228,19240,19247,19258,19261,19269,19270,19280,19282,19283,19289,19290,19292,19294,19299,19302,19304,19307,19328,19329,19332,19333,19339,19389,19400,19401,19402,19415,19421,19423,19427,19429,19442,19453,19458,19461,19470,19493,19497,19503,19524,19532,19533,19535,19571,19573,19578,19590,19594,19595,19596,19608,19623,19650,19661,19681,19682,19683,19684,19700,19718,19720,19721,19739,19741,19771,19773,19778,19788,19796,19800,19809,19815,19825,19830,19836,19894,19896,19930,19932,19935,19937,19941,19970,19983,19987,19991,19992,19994,20007,20029,20034,20044,20056,20057,20062,20069,20076,20097,20102,20131,20145,20153,20164,20177,20183,20188,20199,20215,20236,20241,20278,20280,20293,20303,20306,20312,20316,20344,20354,20363,20374,20391,20403,20416,20440,20446,20460,20508,20527,20530,20536,20543,20545,20578,20600,20620,20621,20633,20636,20638,20659,20662,20684,20699,20701,20713,20717,20733,20743,20748,20753,20764,20790,20804,20809,20813,20826,20833,20843,20848,20851,20852,20853,20856,20858,20860,20871,20879,20883,20902,20906,20914,20920,20921,20939,20944,20949,20950,20954,20979,20999,21000,21003,21017,21064,21073,21118,21161,21168,21171,21178,21183,21184,21217,21219,21222,21228,21236,21242,21248,21252,21282,21305,21310,21313,21317,21323,21373,21388,21391,21401,21402,21431,21433,21458,21464,21483,21511,21522,21546,21552,21569,21586,21645,21655,21658,21666,21669,21676,21709,21711,21714,21737,21751,21760,21763,21787,21790,21795,21819,21820,21846,21851,21871,21890,21922,21952,21969,22029,22053,22059,22060,22065,22094,22100,22105,22110,22168,22177,22211,22223,22258,22294,22336,22379,22385,22389,22419,22422,22435,22454,22455,22459,22483,22492,22499,22500,22502,22515,22527,22550,22552,22563,22567,22572,22603,22612,22644,22663,22667,22673,22675,22688,22702,22708,22715,22723,22741,22742,22743,22749,22787,22803,22847,22854,22874,22880,22884,23000,23008,23022,23034,23063,23067,23073,23077,23090,23122,23124,23133,23138,23148,23150,23152,23153,23162,23163,23170,23202,23219,23224,23246,23247,23286,23322,23344,23375,23382,23403,23424,23441,23467,23478,23518,23524,23526,23536,23546,23552,23559,23564,23569,23575,23576,23599,23617,23635,23659,23672,23682,23691,23703,23708,23735,23749,23772,23778,23814,23845,23857,23874,23875,23889,23941,23949,23957,23959,23962,23967,23984,23987,23992,24010,24013,24014,24024,24035,24059,24067,24072,24075,24076,24111,24117,24153,24157,24189,24208,24219,24230,24260,24273,24289,24311,24313,24332,24344,24346,24353,24415,24452,24472,24475,24484,24487,24513,24523,24526,24585,24597,24598,24602,24607,24609,24612,24614,24616,24636,24642,24665,24673,24682,24686,24697,24698,24745,24779,24781,24788,24797,24823,24853,24857,24885,24907,24924,24943,24960,24973,25003,25039,25046,25048,25067,25070,25071,25115,25126,25195,25201,25252,25267,25273,25301,25309,25312,25321,25323,25341,25349,25360,25370,25373,25374,25394,25397,25421,25445,25456,25521,25528,25534,25548,25569,25592,25598,25610,25632,25678,25721,25725,25732,25754,25764,25789,25798,25810,25889,25901,25917,25925,25932,25966,25987,26014,26018,26035,26048,26064,26065,26105,26107,26122,26135,26142,26161,26162,26173,26176,26178,26208,26215,26222,26245,26247,26255,26306,26317,26386,26456,26522,26540,26554,26564,26574,26675,26689,26741,26765,26816,26824,26825,26829,26832,26920,26926,26939,26954,26982,27008,27026,27103,27130,27133,27135,27151,27157,27186,27210,27221,27251,27291,27319,27356,27362,27418,27427,27452,27482,27490,27506,27558,27572,27593,27609,27687,27704,27721,27759,27777,27805,27828,27833,27834,27863,27891,27904,27912,27938,27954,27997,28005,28033,28049,28123,28161,28248,28318,28383,28384,28397,28402,28403,28416,28420,28424,28436,28454,28540,28553,28559,28605,28608,28666,28692,28720,28763,28777,28780,28824,28910,28918,28960,28992,29006,29012,29021,29033,29089,29124,29136,29143,29244,29256,29281,29358,29369,29387,29473,29475,29486,29617,29799,29801,29810,29832,29890,29919,29930,29933,30307,31114,31227,31356,31499,31516,31671,32097,32841,33259,33270,33382,33430,33437,33593,33651,33784,33815,33993,34008,34176,34273,34300,34490,34573,34783,35568,35617,35734,35755,36188,36219,36399,36454,36798,36821,36822,36893,36916,36918,37315,37380,37408,37761,37874,37883,37996,38010,38021,38056,38066,38361,38455,38522,38534,38646,38732,38734,38775,38812,38903,38960,39033,39140,39283,39307,39358,39413,39452,39464,39504,39516,39534,39544,39557,39764,39785,39966,40054,40110,40137,40169,40288,40289,40296,40312,40313,40314,40360,40490,40515,40542,40801,40871,41036,41058,41063,41069,41144,41164,41256,41292,41311,41357,41402,41423,41430,41431,41513,41661,41789,41811,41885,41952,42285,42460,42489,42530,42715,42752,42799,42877,42878,43268,43410,43680,43705,43706,43707,43708,43899,43914,43915,43917,43960,44031,44041,44396,44402,44497,44602,44681,44743,45076,45115,45160,45206,45252)
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 | 1938 | 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.89 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.33 ms |
System lock | 0.02 ms |
optimizing | 0.12 ms |
statistics | 3.04 ms |
preparing | 1.80 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 9.55 ms |
end | 0.02 ms |
query end | 0.05 ms |
closing tables | 0.21 ms |
freeing items | 0.27 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 |