Tiempo de la consulta: 19.89 ms Después de la última consulta: 2.12 ms Consulta a la memoria: 1.596 MB memoria antes de la consulta: 4.693 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-05 14:52:14')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 14:52:14')
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,14,29,39,56,57,60,61,62,63,65,71,73,76,86,87,97,99,112,124,126,132,149,155,164,165,174,177,180,192,196,198,210,215,219,221,224,226,232,233,238,240,243,244,245,249,259,262,269,276,289,291,299,309,316,323,325,328,330,331,337,349,357,364,366,380,385,391,394,395,397,414,417,418,422,423,424,426,427,428,429,433,439,440,448,451,452,456,459,468,472,474,477,481,489,495,497,501,505,507,510,521,523,524,525,527,528,530,531,532,546,548,553,555,556,563,565,567,583,587,595,596,597,601,603,604,619,620,622,628,632,633,641,646,647,659,662,663,667,672,674,681,682,686,697,705,717,730,746,754,769,771,772,776,781,787,788,792,795,796,797,800,802,808,818,823,832,833,835,840,842,852,856,858,861,864,869,873,889,899,901,902,905,910,914,923,924,925,928,939,940,942,949,954,955,957,962,969,974,977,982,983,999,1004,1005,1007,1008,1011,1015,1021,1029,1033,1035,1039,1040,1055,1058,1062,1066,1071,1072,1087,1091,1095,1100,1101,1114,1119,1125,1145,1158,1165,1175,1182,1185,1195,1205,1216,1227,1231,1244,1247,1248,1252,1253,1255,1261,1264,1268,1271,1272,1274,1276,1278,1284,1285,1289,1303,1308,1309,1319,1325,1326,1328,1335,1347,1350,1351,1363,1368,1388,1389,1390,1394,1402,1407,1409,1410,1412,1417,1428,1432,1441,1444,1459,1482,1485,1486,1491,1492,1504,1509,1521,1557,1563,1565,1594,1606,1611,1612,1618,1619,1629,1648,1649,1660,1670,1675,1683,1693,1694,1697,1712,1717,1724,1742,1744,1749,1754,1764,1770,1771,1784,1794,1795,1796,1797,1800,1803,1808,1810,1839,1843,1849,1853,1854,1855,1862,1899,1915,1917,1918,1920,1930,1947,1949,1960,1961,1964,1975,1984,1994,1995,1999,2001,2007,2008,2012,2013,2015,2035,2048,2053,2054,2075,2086,2088,2089,2102,2132,2137,2155,2157,2161,2185,2265,2293,2294,2355,2429,2433,2455,2463,2520,2527,2532,2546,2551,2569,2580,2586,2589,2597,2601,2633,2638,2642,2643,2687,2739,2780,2788,2811,2814,2817,2818,2824,2851,2852,2855,2875,2883,2886,2887,2888,2958,2960,2961,2964,3005,3017,3026,3027,3055,3070,3082,3085,3098,3100,3107,3114,3147,3156,3167,3169,3181,3207,3227,3249,3251,3259,3269,3271,3281,3299,3318,3326,3328,3329,3337,3364,3368,3369,3387,3409,3412,3415,3416,3417,3424,3425,3444,3453,3456,3473,3498,3512,3517,3520,3531,3548,3552,3554,3589,3590,3593,3604,3616,3648,3651,3683,3689,3704,3709,3748,3749,3776,3796,3831,3832,3836,3852,3853,3858,3869,3872,3873,3898,3910,3913,3919,3922,3929,3932,3962,3963,3984,3988,3991,4000,4026,4034,4050,4059,4068,4082,4109,4110,4120,4129,4142,4244,4301,4327,4329,4355,4381,4434,4442,4468,4502,4529,4532,4538,4558,4560,4561,4572,4580,4600,4616,4620,4622,4626,4640,4666,4673,4674,4677,4718,4726,4750,4751,4752,4767,4780,4781,4785,4787,4801,4810,4813,4815,4816,4822,4825,4831,4832,4833,4844,4845,4846,4848,4854,4860,4865,4884,4901,4933,4955,4973,5043,5045,5053,5055,5063,5065,5066,5076,5096,5111,5134,5136,5153,5160,5170,5182,5183,5190,5201,5220,5221,5227,5243,5245,5249,5279,5282,5301,5302,5328,5332,5348,5357,5362,5363,5370,5415,5417,5469,5529,5559,5575,5576,5582,5583,5632,5633,5637,5644,5646,5648,5658,5678,5688,5694,5702,5703,5731,5732,5759,5777,5780,5792,5794,5795,5796,5802,5803,5804,5811,5825,5831,5846,5848,5876,5878,5880,5895,5899,5901,5904,5910,5919,5923,5978,5994,5999,6011,6021,6022,6038,6044,6049,6056,6068,6084,6087,6112,6148,6176,6198,6220,6258,6266,6292,6309,6312,6335,6343,6345,6353,6370,6390,6391,6420,6435,6442,6469,6476,6477,6492,6498,6501,6523,6524,6539,6548,6557,6558,6606,6610,6614,6635,6664,6670,6671,6688,6720,6729,6758,6765,6783,6794,6834,6845,6854,6855,6857,6884,6885,6908,6944,6958,6960,7000,7002,7012,7022,7030,7048,7053,7054,7057,7062,7090,7137,7139,7172,7174,7175,7195,7242,7247,7258,7273,7278,7292,7324,7325,7338,7348,7358,7365,7374,7380,7387,7401,7403,7404,7411,7418,7431,7443,7453,7455,7473,7488,7491,7497,7535,7549,7565,7567,7573,7591,7592,7595,7596,7644,7648,7716,7722,7751,7771,7797,7819,7847,7869,7913,7914,7958,7969,7980,7996,8009,8044,8050,8070,8076,8080,8081,8084,8086,8087,8089,8148,8161,8188,8192,8218,8227,8243,8258,8290,8291,8295,8296,8314,8325,8366,8373,8374,8387,8390,8398,8404,8417,8492,8505,8506,8538,8551,8577,8592,8602,8634,8707,8716,8779,8784,8790,8801,8848,8852,8859,8895,8907,8974,9004,9011,9018,9028,9055,9083,9139,9155,9175,9186,9193,9233,9237,9251,9252,9277,9279,9286,9362,9369,9399,9401,9431,9458,9488,9501,9525,9544,9559,9572,9573,9612,9648,9660,9670,9698,9708,9766,9831,9840,9849,9850,9857,9858,9889,9906,9909,9930,9932,9937,10046,10090,10091,10115,10129,10153,10176,10213,10278,10298,10305,10353,10364,10371,10418,10448,10449,10494,10572,10603,10609,10620,10629,10658,10689,10708,10720,10753,10787,10818,10840,10890,10893,10900,10942,10946,10947,10967,10970,11001,11131,11138,11184,11195,11198,11207,11210,11302,11408,11477,11486,11531,11532,11534,11542,11555,11559,11612,11618,11621,11672,11685,11693,11709,11720,11727,11822,11834,11877,11880,11930,12010,12024,12103,12119,12138,12141,12152,12168,12169,12205,12242,12270,12333,12387,12398,12408,12410,12415,12426,12439,12479,12482,12509,12531,12550,12567,12568,12590,12592,12594,12624,12639,12663,12667,12714,12748,12783,12801,12806,12851,12892,12895,12913,12926,12939,12942,12954,12974,12982,13013,13014,13025,13028,13034,13068,13079,13086,13126,13186,13209,13215,13220,13238,13246,13263,13269,13273,13285,13297,13309,13317,13325,13363,13365,13373,13383,13413,13415,13432,13436,13459,13477,13553,13556,13558,13566,13567,13579,13590,13625,13637,13672,13704,13722,13729,13744,13753,13770,13819,13833,13834,13847,13860,13881,13891,13896,13902,13903,13932,13935,13959,13974,13980,13986,13987,14010,14014,14015,14016,14029,14084,14103,14134,14154,14172,14177,14193,14197,14218,14232,14238,14290,14302,14334,14336,14338,14354,14363,14368,14374,14417,14427,14437,14478,14508,14521,14548,14571,14618,14620,14631,14651,14666,14675,14680,14688,14703,14705,14714,14725,14752,14769,14789,14795,14810,14846,14865,14876,14884,14885,14904,14914,14930,14940,14957,14969,14970,14976,14990,15006,15013,15038,15043,15054,15063,15065,15086,15087,15088,15096,15123,15133,15138,15144,15175,15203,15213,15223,15235,15244,15250,15261,15272,15300,15314,15323,15335,15376,15392,15430,15450,15460,15469,15484,15490,15518,15531,15533,15540,15544,15547,15550,15563,15566,15579,15583,15589,15601,15602,15604,15605,15612,15623,15625,15627,15630,15666,15667,15670,15694,15696,15706,15707,15781,15786,15804,15807,15809,15824,15835,15861,15875,15896,15899,15902,15909,15913,15915,15916,15917,15925,15941,15943,15969,15973,15992,15999,16005,16014,16015,16021,16023,16024,16051,16087,16089,16122,16199,16208,16213,16216,16219,16224,16245,16246,16278,16311,16313,16323,16336,16382,16398,16402,16417,16443,16454,16474,16479,16524,16529,16538,16547,16555,16579,16587,16588,16589,16596,16612,16620,16642,16698,16712,16715,16737,16745,16751,16791,16794,16813,16829,16830,16833,16857,16863,16891,16913,16915,16921,16940,16947,16964,16968,16976,16977,16995,17043,17045,17054,17055,17059,17064,17084,17140,17156,17160,17166,17169,17205,17209,17232,17248,17263,17287,17305,17311,17333,17336,17338,17349,17371,17372,17375,17378,17388,17442,17450,17458,17482,17483,17493,17513,17531,17541,17556,17584,17592,17622,17644,17646,17683,17695,17699,17705,17721,17722,17737,17752,17753,17782,17784,17788,17791,17798,17799,17806,17807,17808,17824,17842,17843,17883,17900,17907,17936,17966,17976,17978,17981,18002,18004,18006,18016,18019,18027,18036,18067,18068,18076,18083,18141,18150,18151,18203,18222,18227,18235,18249,18286,18297,18313,18333,18357,18378,18383,18415,18421,18437,18444,18447,18455,18456,18480,18507,18534,18542,18564,18579,18587,18619,18647,18653,18655,18657,18668,18676,18680,18695,18733,18742,18749,18752,18754,18766,18767,18778,18779,18792,18800,18801,18802,18804,18817,18832,18833,18835,18846,18853,18868,18874,18876,18877,18879,18893,18931,18935,18946,18951,18956,18980,19015,19027,19038,19046,19062,19082,19093,19164,19183,19184,19187,19196,19216,19218,19220,19228,19241,19257,19258,19267,19269,19275,19280,19282,19283,19289,19293,19299,19302,19307,19316,19339,19340,19357,19365,19383,19389,19400,19402,19421,19423,19426,19427,19428,19458,19470,19473,19481,19499,19503,19514,19532,19533,19545,19565,19573,19580,19586,19587,19592,19606,19640,19645,19646,19649,19664,19665,19702,19721,19741,19745,19755,19778,19779,19796,19800,19805,19823,19826,19830,19864,19870,19876,19937,19940,19942,19973,19976,20002,20029,20044,20056,20057,20062,20076,20077,20138,20145,20153,20154,20155,20177,20183,20184,20188,20191,20204,20208,20209,20215,20218,20230,20236,20272,20278,20291,20293,20303,20306,20310,20311,20337,20352,20366,20384,20391,20393,20452,20453,20470,20503,20508,20530,20570,20585,20600,20656,20662,20677,20698,20713,20733,20743,20764,20770,20804,20813,20820,20821,20843,20851,20853,20858,20860,20862,20871,20876,20879,20883,20905,20920,20921,20935,20944,20948,20949,20954,20963,20991,20999,21035,21042,21047,21050,21065,21080,21159,21168,21198,21200,21217,21230,21236,21282,21284,21291,21302,21313,21333,21335,21341,21361,21402,21412,21415,21465,21478,21483,21498,21528,21569,21573,21583,21603,21604,21632,21647,21652,21689,21698,21708,21729,21760,21770,21781,21787,21794,21803,21815,21820,21822,21900,21908,21930,21955,21962,21969,21986,21996,22036,22055,22058,22074,22105,22177,22202,22260,22321,22327,22351,22374,22428,22520,22540,22565,22567,22582,22594,22603,22615,22621,22623,22624,22660,22685,22738,22743,22774,22779,22818,22847,22854,22870,22873,22904,22922,22924,22926,22927,22932,22967,22985,23004,23006,23027,23032,23040,23082,23084,23090,23102,23131,23136,23138,23166,23170,23174,23200,23202,23215,23224,23246,23302,23350,23398,23400,23411,23412,23423,23453,23454,23481,23482,23503,23526,23531,23536,23548,23569,23570,23574,23599,23617,23633,23634,23645,23648,23652,23653,23682,23807,23850,23866,23875,23876,23894,23932,23958,24002,24067,24134,24137,24153,24154,24172,24173,24188,24189,24199,24208,24216,24219,24228,24279,24386,24391,24403,24415,24442,24443,24462,24484,24500,24510,24516,24526,24529,24545,24578,24585,24586,24598,24609,24614,24657,24662,24681,24682,24685,24719,24752,24763,24797,24853,24882,24917,24920,24945,24962,24973,24986,25006,25033,25061,25074,25110,25158,25214,25271,25323,25334,25379,25398,25456,25465,25513,25534,25549,25569,25598,25610,25632,25656,25689,25708,25721,25735,25742,25749,25753,25768,25782,25801,25860,25888,25901,26014,26043,26123,26140,26195,26197,26215,26245,26304,26318,26323,26324,26342,26361,26373,26386,26387,26398,26430,26452,26534,26548,26554,26577,26612,26637,26665,26728,26758,26780,26829,26909,26919,26920,26936,26941,26954,27029,27039,27075,27087,27103,27104,27127,27133,27135,27157,27184,27189,27211,27229,27279,27307,27337,27420,27439,27447,27488,27490,27492,27496,27548,27549,27563,27582,27675,27724,27739,27750,27800,27805,27863,27892,27904,27997,28072,28157,28169,28248,28277,28355,28391,28402,28416,28423,28466,28481,28547,28750,28910,28918,28925,28960,29033,29136,29197,29209,29221,29281,29366,29464,29640,29696,29837,30111,30242,30307,30478,30801,30930,30941,30978,31090,31109,31114,31356,31417,31533,31560,31561,31621,31663,31671,31767,31837,31899,31937,31962,32009,32048,32056,32097,32506,32583,32755,32756,32841,32910,33233,33259,33430,33435,33593,33645,33650,33651,33784,33874,33993,33997,34008,34176,34196,34300,34490,34494,34573,34701,34733,34783,34797,35192,35321,35443,35460,35568,35755,35790,35836,35859,35958,35965,35997,36014,36015,36018,36147,36160,36167,36178,36208,36219,36223,36230,36247,36256,36282,36293,36313,36320,36329,36344,36345,36349,36365,36370,36397,36433,36502,36564,36623,36627,36729,36819,36885,36903,36958,36964,37243,37289,37408,37468,37656,37797,37865,38000,38542,38575,38593,38658,38659,38660,38669,38691,38693,38779,38788,38815,38816,38817,38822,38831,38833,38845,38896,38897,38969,38987,39073,39132,39173,39180,39258,39418,39462,39494,39502,39614,39645,39674,39820,39845,39848,39876,39905,39972,39987,40031,40046,40053,40062,40085,40161,40245,40277,40301,40397,40408,40414,40454,40521,40572,40747,40831,40854,40858,40886,40918,40946,40947,40948,40949,40950,40952,40962,41057,41074,41076,41206,41256,41311,41363,41430,41460,41525,41526,41531,41539,41546,41561,41562,41580,41610,41630,41634,41643,41692,41700,41716,41720,42144,42217,42312,42444,42520,42530,42567,42752,42799,42880,42963,43052,43200,43238,43239,43302,43388,43436,43480,43481,43501,43510,43574,43717,43785,43828,43951,43990,44020,44115,44144,44145,44188,44206,44207,44241,44287,44345,44396,44402,44463,44602,44627,44661,44664,44743,44749,44827,44853,44855,44866,45076,45111,45251,45288)
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 | 2255 | 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.09 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.40 ms |
System lock | 0.02 ms |
optimizing | 0.15 ms |
statistics | 3.40 ms |
preparing | 1.76 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 12.19 ms |
end | 0.02 ms |
query end | 0.04 ms |
closing tables | 0.02 ms |
freeing items | 0.15 ms |
cleaning up | 0.06 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 |