Tiempo de la consulta: 19.65 ms Después de la última consulta: 3.05 ms Consulta a la memoria: 1.487 MB memoria antes de la consulta: 4.504 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-06 18:06:00')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 18:06:00')
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(3,5,7,8,9,11,14,29,39,45,46,54,56,57,60,61,63,64,65,67,68,71,73,86,87,124,130,149,155,163,164,174,177,180,186,188,189,196,198,202,212,214,215,220,221,226,240,244,246,248,250,253,259,260,262,271,272,278,279,281,291,299,330,331,337,344,349,350,357,366,380,385,391,394,415,417,418,419,423,427,428,429,433,439,452,459,472,477,481,501,510,521,524,525,530,531,546,550,551,563,567,583,586,587,595,596,597,603,604,612,613,619,628,641,643,647,659,662,663,666,667,674,678,686,697,699,703,705,717,728,746,764,765,769,779,788,800,802,805,808,823,832,835,844,845,852,857,869,873,902,910,923,927,938,939,940,954,969,974,977,978,982,983,999,1004,1005,1011,1015,1021,1024,1055,1066,1091,1095,1099,1100,1114,1119,1133,1158,1168,1182,1187,1205,1208,1218,1222,1227,1231,1247,1252,1253,1255,1268,1269,1271,1272,1273,1274,1276,1289,1305,1308,1309,1319,1335,1346,1347,1349,1357,1363,1370,1397,1409,1410,1428,1432,1441,1444,1447,1485,1506,1509,1512,1519,1538,1543,1557,1563,1566,1571,1606,1619,1627,1629,1648,1675,1693,1694,1698,1724,1740,1771,1794,1795,1796,1800,1803,1808,1810,1843,1851,1853,1854,1855,1862,1867,1879,1899,1904,1918,1919,1920,1930,1960,1961,1975,1984,1994,1995,2001,2005,2008,2012,2013,2015,2035,2048,2053,2075,2084,2088,2092,2112,2122,2137,2142,2148,2155,2157,2161,2188,2189,2190,2241,2288,2293,2389,2392,2394,2402,2431,2455,2482,2527,2532,2551,2581,2586,2597,2598,2609,2638,2643,2687,2710,2746,2811,2814,2824,2851,2852,2883,2888,2906,2909,2937,2960,2962,3027,3030,3031,3055,3100,3106,3107,3109,3120,3130,3147,3156,3167,3169,3180,3193,3196,3207,3224,3240,3258,3266,3340,3364,3368,3369,3387,3409,3412,3415,3416,3417,3418,3451,3473,3474,3512,3520,3548,3552,3554,3557,3571,3590,3648,3683,3685,3689,3696,3721,3748,3760,3767,3776,3833,3836,3853,3858,3872,3913,3919,3922,3946,3960,3962,3982,3991,3994,4034,4050,4068,4101,4110,4129,4148,4150,4166,4204,4284,4301,4323,4327,4423,4437,4456,4468,4490,4523,4529,4532,4548,4558,4563,4575,4580,4587,4611,4616,4620,4622,4626,4640,4666,4699,4713,4751,4752,4767,4813,4815,4822,4831,4844,4846,4859,4865,4905,4933,4940,4973,5018,5045,5055,5096,5134,5153,5160,5161,5164,5220,5247,5259,5266,5370,5387,5415,5422,5469,5559,5562,5581,5730,5780,5795,5814,5881,5894,5899,5909,5999,6011,6093,6100,6112,6128,6148,6198,6253,6264,6323,6360,6362,6381,6391,6405,6420,6435,6440,6442,6470,6472,6476,6477,6548,6570,6649,6720,6748,6845,6855,6865,6881,6939,6944,6958,7013,7014,7022,7030,7048,7077,7111,7125,7137,7195,7216,7242,7246,7250,7258,7272,7296,7324,7331,7364,7418,7432,7439,7444,7491,7535,7586,7592,7595,7605,7614,7618,7648,7651,7724,7751,7752,7771,7784,7787,7795,7801,7819,7830,7838,7839,7860,7868,7903,7923,7925,7931,7935,7942,7946,7965,7981,7985,8004,8017,8055,8061,8070,8080,8084,8086,8087,8116,8152,8160,8192,8227,8234,8265,8291,8295,8314,8370,8378,8421,8507,8512,8517,8531,8538,8550,8555,8592,8602,8611,8634,8644,8660,8700,8707,8750,8753,8779,8799,8801,8813,8826,8864,8895,8925,8954,9063,9087,9120,9219,9237,9277,9279,9282,9328,9350,9360,9369,9387,9390,9401,9434,9460,9477,9488,9493,9515,9532,9554,9556,9572,9578,9600,9610,9679,9738,9763,9773,9829,9838,9878,9895,9904,9908,9922,9924,9930,9944,9945,9956,10004,10046,10098,10190,10243,10265,10269,10277,10280,10307,10313,10383,10414,10448,10483,10513,10561,10572,10617,10630,10642,10671,10694,10708,10720,10725,10734,10754,10756,10764,10783,10834,10840,10958,10993,11001,11023,11031,11041,11059,11073,11121,11129,11184,11250,11258,11286,11299,11314,11338,11377,11387,11402,11414,11446,11452,11464,11482,11488,11545,11555,11565,11593,11687,11688,11711,11748,11796,11822,11846,11854,11921,12042,12150,12202,12218,12238,12242,12249,12256,12271,12288,12331,12337,12380,12398,12401,12408,12424,12427,12463,12474,12550,12553,12622,12625,12632,12638,12639,12655,12667,12668,12686,12689,12690,12780,12806,12871,12875,12900,12905,12906,12907,12908,12909,12910,12911,12912,12913,12914,12915,12944,12958,12974,13004,13027,13034,13126,13142,13146,13152,13153,13166,13186,13209,13246,13264,13328,13376,13385,13391,13478,13657,13697,13702,13731,13738,13742,13748,13750,13760,13783,13789,13816,13896,13924,13934,13946,13961,13963,13990,13996,14018,14074,14082,14103,14108,14114,14117,14141,14153,14197,14224,14242,14244,14262,14273,14351,14396,14424,14440,14456,14504,14507,14512,14513,14515,14527,14532,14565,14570,14571,14596,14600,14601,14616,14662,14666,14683,14703,14714,14730,14739,14752,14794,14820,14824,14825,14849,14865,14895,14939,14958,14964,14969,14976,14977,14983,14999,15006,15032,15038,15041,15048,15063,15069,15081,15087,15094,15108,15111,15114,15129,15139,15145,15148,15154,15160,15175,15178,15183,15193,15203,15213,15224,15235,15244,15268,15271,15302,15324,15326,15347,15359,15368,15370,15388,15423,15457,15460,15465,15470,15473,15482,15487,15493,15500,15522,15533,15542,15544,15545,15548,15551,15562,15570,15575,15577,15580,15602,15604,15611,15617,15630,15632,15636,15637,15640,15645,15669,15707,15709,15725,15738,15757,15759,15767,15781,15782,15783,15804,15807,15832,15843,15866,15875,15913,15915,15935,15940,15952,15955,15957,15973,15975,15985,15988,16000,16017,16036,16039,16042,16056,16059,16082,16083,16084,16092,16093,16097,16122,16127,16129,16153,16156,16160,16181,16201,16224,16245,16248,16256,16279,16292,16297,16314,16315,16322,16326,16334,16337,16373,16374,16382,16403,16412,16417,16432,16435,16446,16454,16458,16464,16475,16479,16520,16534,16552,16556,16577,16579,16587,16588,16612,16619,16629,16643,16684,16722,16737,16759,16779,16790,16791,16828,16830,16832,16838,16861,16889,16890,16913,16922,16981,16991,16995,17028,17053,17054,17055,17074,17102,17115,17128,17140,17145,17160,17166,17210,17215,17216,17233,17253,17257,17268,17283,17289,17293,17333,17337,17360,17362,17372,17382,17388,17422,17432,17442,17443,17451,17458,17465,17468,17471,17507,17521,17541,17567,17575,17584,17592,17596,17630,17633,17634,17644,17646,17650,17655,17683,17699,17713,17733,17737,17761,17791,17796,17798,17799,17806,17807,17818,17840,17844,17850,17855,17856,17859,17863,17869,17893,17895,17905,17918,17926,17933,17936,17966,17980,17994,18005,18031,18036,18046,18047,18050,18054,18062,18122,18140,18147,18157,18162,18180,18194,18208,18225,18229,18233,18244,18255,18260,18274,18285,18292,18300,18311,18313,18314,18316,18334,18344,18357,18362,18364,18369,18383,18435,18439,18444,18460,18467,18480,18496,18520,18524,18537,18539,18542,18544,18561,18564,18567,18577,18588,18598,18603,18608,18609,18612,18629,18649,18657,18659,18665,18671,18682,18695,18706,18709,18720,18733,18754,18762,18769,18779,18800,18802,18804,18828,18832,18846,18859,18861,18862,18868,18872,18878,18885,18894,18908,18910,18916,18920,18922,18930,18931,18933,18942,18953,18954,18975,18977,18980,18982,18989,18991,18995,19000,19002,19005,19015,19022,19028,19034,19038,19042,19047,19060,19061,19067,19073,19083,19091,19105,19110,19124,19128,19132,19135,19136,19145,19148,19149,19155,19170,19180,19182,19183,19185,19187,19196,19218,19219,19228,19237,19240,19247,19253,19258,19269,19270,19276,19280,19282,19283,19289,19293,19294,19299,19302,19307,19313,19320,19322,19327,19339,19346,19352,19366,19376,19389,19400,19402,19421,19423,19427,19452,19453,19457,19458,19460,19470,19503,19524,19530,19532,19533,19550,19561,19573,19577,19581,19595,19604,19608,19620,19633,19637,19647,19650,19652,19661,19668,19684,19687,19695,19713,19718,19721,19732,19796,19800,19811,19815,19830,19837,19852,19870,19872,19894,19904,19908,19909,19930,19932,19937,19941,19945,19983,19991,19998,20001,20004,20010,20018,20028,20029,20030,20032,20034,20044,20056,20057,20062,20069,20086,20126,20127,20141,20142,20145,20147,20152,20153,20156,20170,20177,20183,20187,20188,20199,20215,20234,20236,20250,20256,20260,20263,20264,20271,20278,20289,20293,20306,20327,20344,20348,20353,20354,20363,20374,20376,20391,20393,20403,20429,20440,20444,20449,20450,20461,20471,20508,20516,20530,20535,20564,20578,20600,20602,20621,20630,20636,20638,20649,20661,20662,20678,20683,20713,20714,20729,20733,20741,20743,20764,20779,20797,20802,20804,20813,20826,20828,20843,20850,20851,20853,20856,20858,20860,20866,20871,20879,20883,20906,20910,20915,20920,20921,20944,20949,20954,20959,20963,20982,20999,21000,21047,21049,21050,21057,21062,21107,21108,21110,21118,21143,21161,21166,21168,21172,21173,21178,21189,21190,21198,21217,21225,21236,21242,21249,21252,21282,21305,21313,21314,21323,21325,21369,21381,21397,21402,21422,21432,21433,21434,21435,21458,21464,21472,21483,21489,21500,21508,21513,21522,21545,21546,21552,21554,21569,21578,21586,21587,21590,21611,21620,21636,21640,21641,21678,21694,21695,21710,21714,21737,21738,21740,21741,21744,21749,21757,21760,21764,21768,21776,21777,21778,21787,21820,21854,21855,21858,21883,21894,21906,21944,21950,21952,21968,21969,21976,21980,21982,22010,22040,22049,22059,22063,22100,22105,22137,22139,22142,22146,22160,22162,22173,22176,22214,22229,22237,22297,22298,22313,22337,22348,22361,22362,22402,22407,22419,22421,22427,22435,22455,22459,22461,22468,22492,22500,22502,22511,22527,22536,22559,22567,22579,22603,22617,22647,22651,22673,22708,22709,22712,22715,22733,22739,22742,22743,22758,22763,22774,22803,22819,22837,22847,22854,22874,22889,22890,22903,22904,22908,22941,22957,22980,22988,23000,23022,23023,23034,23065,23067,23122,23124,23131,23138,23148,23170,23185,23186,23195,23201,23202,23207,23219,23222,23224,23237,23241,23246,23247,23254,23260,23275,23280,23281,23286,23295,23313,23320,23325,23326,23328,23335,23339,23340,23344,23374,23375,23402,23450,23453,23467,23469,23495,23526,23536,23546,23555,23559,23564,23569,23582,23585,23599,23610,23617,23625,23636,23678,23679,23682,23691,23703,23732,23764,23772,23804,23819,23840,23845,23857,23858,23874,23875,23890,23898,23951,23959,23962,23967,23984,24010,24024,24028,24059,24067,24072,24075,24076,24102,24104,24111,24152,24153,24186,24189,24191,24194,24208,24219,24230,24273,24274,24327,24342,24346,24366,24371,24392,24415,24426,24451,24455,24484,24489,24496,24503,24523,24526,24540,24585,24586,24592,24598,24607,24609,24614,24616,24639,24644,24653,24673,24682,24707,24727,24733,24788,24791,24797,24802,24804,24816,24837,24844,24853,24857,24862,24884,24897,24899,24924,24964,24973,25003,25004,25045,25072,25098,25105,25107,25125,25126,25133,25139,25172,25184,25218,25225,25253,25257,25264,25273,25315,25323,25349,25360,25373,25374,25377,25380,25401,25421,25456,25465,25534,25569,25572,25598,25610,25632,25637,25640,25642,25644,25645,25702,25714,25721,25730,25764,25775,25785,25798,25850,25872,25901,25906,25987,25993,26014,26107,26122,26135,26172,26176,26178,26183,26215,26245,26256,26268,26273,26315,26370,26386,26493,26501,26504,26521,26522,26554,26563,26564,26640,26648,26708,26807,26816,26829,26901,26920,26926,26954,26972,26982,27002,27011,27026,27086,27103,27133,27135,27141,27143,27150,27151,27157,27170,27198,27246,27267,27271,27273,27292,27307,27321,27356,27371,27418,27431,27490,27496,27506,27521,27545,27558,27560,27572,27593,27644,27686,27704,27721,27805,27842,27863,27891,27904,27912,27917,27931,27936,27939,27997,28005,28033,28045,28082,28225,28248,28312,28336,28383,28384,28397,28402,28411,28416,28424,28436,28442,28454,28458,28495,28534,28547,28555,28575,28639,28653,28658,28683,28777,28780,28817,28824,28867,28882,28910,28918,28933,28960,28989,29008,29009,29021,29033,29089,29124,29136,29152,29153,29174,29197,29201,29221,29256,29281,29312,29319,29341,29356,29358,29412,29417,29440,29443,29444,29454,29476,29553,29617,29781,29802,29810,29824,29896,29905,29919,29922,29923,29930,29933,29935,30070,30307,30596,30740,31114,31129,31227,31243,31356,31499,31516,31604,31663,31671,31763,31885,31891,31896,32097,32316,32768,32841,32842,32905,33259,33416,33430,33593,33649,33651,33784,33815,33993,34008,34176,34300,34490,34573,34682,34783,35568,35603,35617,35689,35755,35854,35883,35885,36122,36219,36893,36916,36918,37056,37210,37315,37380,37408,37695,37696,37702,37807,37874,37996,38056,38066,38261,38361,38455,38475,38500,38502,38734,38775,38807,38812,38831,38854,38866,39163,39180,39186,39258,39267,39307,39358,39371,39452,39463,39469,39481,39491,39495,39504,39516,39543,39603,39653,39655,39681,39750,39819,39857,39870,39884,39933,39966,40025,40038,40083,40097,40169,40170,40200,40207,40208,40312,40313,40314,40355,40360,40402,40542,40572,40708,40759,40785,40801,40809,40817,40837,40852,40907,40937,40984,41036,41059,41063,41199,41241,41255,41256,41301,41311,41325,41365,41375,41402,41423,41430,41444,41525,41526,41541,41606,41811,41823,41885,41946,41960,42024,42025,42067,42132,42251,42408,42421,42425,42426,42444,42460,42489,42530,42748,42752,42799,42824,42839,43002,43052,43060,43069,43084,43087,43388,43680,43705,43706,43707,43717,43914,43915,43917,44031,44041,44161,44396,44402,44497,44509,44602,44681,44743,44749,44763,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 | 2253 | 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.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.40 ms |
System lock | 0.02 ms |
optimizing | 0.18 ms |
statistics | 4.04 ms |
preparing | 1.86 ms |
Sorting result | 0.03 ms |
executing | 0.01 ms |
Sending data | 11.34 ms |
end | 0.03 ms |
query end | 0.05 ms |
closing tables | 0.03 ms |
freeing items | 0.17 ms |
cleaning up | 0.05 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 |