Tiempo de la consulta: 10.28 ms Después de la última consulta: 1.57 ms Consulta a la memoria: 1.065 MB memoria antes de la consulta: 4.435 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 21:23:00')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 21:23: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(2,3,4,5,6,7,8,10,11,14,16,19,20,21,22,23,24,25,26,27,28,29,30,31,32,49,60,66,72,78,81,94,117,120,126,127,165,167,180,201,204,216,225,253,255,263,265,272,275,287,304,305,306,316,317,340,344,353,354,368,377,390,435,443,463,484,493,495,505,506,507,515,519,533,547,549,550,551,581,583,584,592,593,607,608,621,635,667,686,693,705,709,719,728,731,740,741,742,757,760,777,791,801,816,825,831,841,855,882,891,895,900,908,916,917,931,954,955,961,968,1007,1015,1020,1029,1046,1052,1053,1056,1059,1080,1103,1105,1124,1134,1140,1161,1168,1186,1187,1188,1197,1198,1200,1204,1207,1226,1229,1235,1238,1257,1265,1287,1296,1298,1302,1304,1308,1313,1316,1336,1338,1342,1343,1344,1347,1354,1367,1380,1392,1402,1406,1413,1420,1421,1430,1433,1435,1441,1443,1463,1470,1478,1504,1506,1507,1524,1531,1532,1537,1558,1567,1568,1572,1587,1594,1598,1600,1681,1695,1716,1719,1739,1787,1823,1860,1898,1905,1920,1932,1990,2024,2031,2076,2096,2144,2145,2150,2178,2182,2188,2194,2204,2207,2209,2219,2229,2235,2236,2241,2242,2243,2245,2261,2278,2290,2293,2314,2315,2316,2319,2332,2333,2342,2353,2373,2376,2396,2410,2453,2459,2476,2481,2482,2503,2511,2516,2524,2564,2566,2573,2579,2594,2627,2631,2644,2666,2695,2717,2720,2726,2728,2758,2765,2770,2797,2817,2830,2834,2835,2926,2938,2942,2967,2991,3018,3063,3065,3073,3093,3112,3117,3126,3129,3137,3143,3152,3163,3166,3187,3193,3222,3226,3235,3245,3293,3306,3327,3347,3353,3382,3388,3390,3414,3417,3436,3442,3447,3457,3458,3486,3495,3531,3546,3556,3574,3579,3582,3587,3602,3626,3634,3657,3675,3696,3709,3769,3796,3827,3837,3840,3864,3976,3979,3986,4004,4015,4074,4092,4153,4250,4287,4309,4335,4343,4410,4488,4515,4525,4580,4631,4632,4640,4654,4684,4688,4689,4691,4718,4784,4808,4816,4841,4847,4871,4902,4949,4971,4973,4999,5016,5018,5020,5051,5099,5100,5150,5180,5247,5275,5291,5323,5365,5371,5378,5431,5451,5470,5471,5559,5566,5569,5572,5579,5588,5594,5597,5615,5632,5634,5640,5645,5650,5659,5660,5662,5686,5722,5726,5727,5729,5730,5747,5798,5822,5870,5894,5998,6006,6010,6020,6062,6101,6174,6186,6217,6245,6257,6272,6292,6311,6330,6348,6349,6354,6359,6363,6367,6392,6437,6445,6503,6542,6543,6565,6568,6604,6605,6616,6639,6657,6670,6675,6677,6694,6708,6742,6764,6793,6804,6836,6876,6939,6945,6975,6989,7056,7082,7086,7096,7099,7109,7110,7124,7138,7181,7205,7212,7243,7245,7249,7262,7265,7269,7275,7288,7291,7293,7299,7300,7309,7328,7334,7335,7368,7413,7458,7466,7484,7492,7495,7516,7555,7584,7618,7680,7711,7718,7719,7720,7802,7806,7837,7839,7841,7860,7868,7932,7935,7946,7950,7965,7970,7980,7994,7998,8027,8037,8061,8071,8073,8114,8199,8238,8275,8276,8339,8345,8351,8442,8451,8498,8499,8540,8566,8568,8569,8587,8593,8610,8704,8759,8773,8776,8781,8828,8846,8853,8983,9010,9029,9120,9148,9191,9201,9223,9257,9286,9291,9298,9322,9351,9398,9428,9475,9650,9682,9734,9745,9761,9792,9818,9820,9834,9839,9841,9864,9942,9945,10009,10010,10051,10078,10079,10110,10120,10202,10216,10237,10248,10255,10260,10261,10282,10304,10308,10340,10345,10348,10369,10385,10478,10502,10548,10553,10554,10595,10665,10666,10673,10686,10708,10713,10769,10775,10799,10857,10888,10912,10971,11006,11030,11031,11076,11091,11123,11146,11206,11235,11237,11241,11290,11320,11388,11424,11438,11439,11441,11487,11547,11551,11603,11626,11632,11692,11730,11762,11900,11925,11967,12012,12032,12060,12071,12116,12126,12128,12166,12181,12186,12212,12218,12219,12223,12225,12237,12251,12369,12385,12393,12428,12463,12474,12493,12548,12576,12595,12608,12620,12622,12623,12625,12630,12633,12634,12677,12684,12705,12717,12718,12752,12758,12760,12761,12768,12815,12846,12852,12894,12902,12925,12945,12957,12959,13002,13010,13012,13020,13032,13078,13115,13143,13176,13188,13190,13191,13246,13248,13259,13277,13294,13309,13433,13434,13456,13473,13517,13573,13609,13611,13621,13631,13662,13671,13673,13674,13702,13731,13734,13735,13759,13860,13867,13869,13959,13986,13994,14031,14047,14048,14062,14070,14101,14181,14184,14201,14204,14205,14227,14229,14249,14270,14273,14279,14293,14305,14331,14339,14341,14348,14350,14368,14391,14404,14408,14445,14447,14456,14457,14468,14482,14495,14510,14516,14522,14529,14534,14538,14542,14550,14564,14570,14592,14600,14624,14652,14683,14684,14692,14707,14746,14794,14807,14815,14846,14852,14931,14941,14981,14987,14993,15028,15069,15100,15108,15120,15147,15196,15215,15243,15263,15266,15293,15304,15321,15356,15370,15372,15389,15402,15408,15439,15464,15470,15477,15485,15495,15518,15521,15522,15530,15543,15548,15551,15562,15567,15599,15604,15651,15657,15663,15664,15680,15689,15703,15709,15715,15725,15728,15756,15763,15837,15839,15841,15850,15856,15866,15873,15948,15955,16020,16037,16050,16093,16153,16158,16163,16166,16209,16214,16249,16257,16317,16347,16358,16369,16370,16408,16421,16423,16425,16451,16477,16513,16523,16537,16539,16580,16604,16605,16619,16644,16645,16669,16685,16722,16763,16825,16845,16867,16872,16891,16996,17002,17059,17061,17090,17115,17128,17132,17138,17146,17148,17185,17194,17244,17257,17291,17337,17354,17373,17379,17407,17411,17420,17432,17458,17465,17477,17492,17493,17501,17518,17529,17533,17537,17542,17551,17552,17562,17565,17569,17615,17623,17626,17640,17646,17649,17688,17707,17725,17729,17747,17753,17757,17766,17772,17775,17799,17812,17823,17839,17851,17852,17869,17875,17880,17889,17895,17921,17925,17947,17952,17960,17980,17987,18000,18031,18032,18038,18057,18060,18072,18110,18116,18122,18127,18140,18158,18169,18200,18212,18216,18228,18240,18260,18276,18277,18284,18286,18301,18304,18309,18311,18314,18316,18321,18331,18364,18369,18375,18380,18390,18402,18425,18431,18433,18440,18479,18481,18490,18493,18511,18514,18516,18524,18543,18549,18566,18571,18580,18583,18621,18630,18646,18649,18659,18668,18679,18687,18690,18694,18738,18770,18780,18781,18782,18793,18837,18843,18847,18882,18891,18895,18914,18930,18951,18952,18969,18978,18984,18991,18994,18997,18999,19013,19028,19043,19052,19053,19059,19078,19083,19119,19130,19133,19147,19168,19178,19184,19219,19237,19247,19271,19288,19293,19318,19325,19335,19370,19383,19389,19411,19419,19427,19445,19448,19454,19457,19492,19501,19505,19519,19526,19535,19552,19553,19555,19556,19574,19595,19596,19612,19617,19634,19645,19646,19699,19700,19720,19731,19758,19764,19766,19811,19841,19880,19894,19898,19913,19953,19959,19971,19972,20003,20012,20016,20024,20036,20053,20058,20059,20065,20067,20076,20111,20116,20120,20133,20137,20153,20154,20181,20195,20197,20223,20248,20250,20252,20256,20268,20271,20273,20279,20281,20287,20295,20349,20355,20402,20403,20432,20441,20443,20500,20524,20586,20590,20609,20614,20649,20665,20667,20678,20681,20699,20705,20714,20721,20726,20738,20744,20769,20796,20800,20807,20814,20820,20878,20880,20888,20896,20906,20941,20945,20955,20967,20980,20983,20987,21046,21106,21115,21148,21163,21171,21198,21202,21213,21226,21229,21238,21240,21251,21255,21266,21290,21321,21331,21334,21340,21369,21393,21421,21430,21459,21467,21469,21472,21481,21490,21508,21521,21531,21539,21576,21586,21611,21668,21709,21711,21721,21734,21735,21748,21774,21781,21853,21861,21866,21870,21916,21952,21961,21971,22005,22021,22038,22045,22061,22066,22082,22087,22132,22145,22153,22175,22192,22198,22216,22238,22257,22262,22267,22289,22295,22313,22318,22334,22347,22371,22385,22388,22402,22404,22414,22419,22423,22457,22458,22476,22500,22503,22509,22525,22543,22574,22587,22602,22640,22647,22708,22732,22736,22738,22741,22745,22750,22805,22834,22841,22856,22876,22888,22891,22924,22931,22943,22979,23023,23028,23041,23064,23073,23078,23100,23107,23122,23130,23131,23132,23144,23168,23210,23219,23236,23258,23259,23299,23312,23332,23344,23426,23428,23469,23489,23512,23541,23567,23592,23598,23613,23614,23620,23649,23657,23675,23688,23711,23722,23729,23767,23793,23811,23817,23855,23861,23899,23907,23922,23926,23964,23967,23970,23973,23974,23984,24051,24077,24088,24105,24111,24135,24158,24166,24175,24193,24198,24200,24204,24213,24229,24275,24282,24289,24322,24337,24361,24375,24413,24414,24457,24478,24498,24536,24603,24607,24658,24666,24677,24692,24695,24703,24713,24722,24737,24765,24784,24799,24803,24814,24819,24823,24838,24853,24881,24924,24944,24958,24989,25004,25048,25093,25100,25106,25123,25135,25155,25178,25183,25205,25212,25268,25312,25331,25336,25342,25349,25353,25365,25397,25415,25417,25421,25449,25458,25460,25474,25475,25488,25541,25553,25557,25595,25635,25636,25668,25672,25685,25687,25690,25694,25709,25797,25847,25870,25891,25958,25969,25981,25985,26020,26030,26048,26062,26159,26166,26179,26193,26204,26219,26226,26249,26282,26288,26305,26363,26369,26386,26508,26509,26520,26530,26564,26570,26590,26620,26630,26636,26659,26673,26680,26726,26727,26731,26752,26760,26779,26802,26816,26818,26860,26892,26924,26939,27008,27018,27023,27084,27131,27138,27183,27184,27199,27354,27363,27410,27574,27592,27616,27790,27806,27808,27949,27968,28005,28033,28107,28114,28128,28218,28303,28313,28318,28366,28367,28412,28548,28557,28563,28575,28581,28601,28621,28630,28636,28764,28771,28808,28872,28943,28950,29002,29172,29210,29319,29358,29382,29438,29509,29510,29512,29569,29625,29653,29694,29695,29711,29846,29863,29935,30433,30434,30486,31640,31697,31890,32010,33878,34699,35000,35095,35153,35369,35548,35562,35585,35646,35660,35661,35727,35750,35777,35778,35814,35865,35878,35950,36051,36060,36130,36153,36196,36241,36267,36292,36299,36341,36383,36396,36534,36591,36594,36598,36604,36639,36769,36889,36937,37005,37083,37455,38353,38426,38465,38610,38613,38652,38777,38836,38890,38946,38971,39041,39071,39171,39225,39333,39406,39465,39483,39558,39571,39590,39682,39698,39710,39790,39821,39866,39936,39938,39995,40079,40224,40259,40317,40355,40385,40386,40387,40456,40651,40742,40813,40867,40875,40922,40983,41068,41239,41298,41442,41515,42310,42384,42456,42602,42971,43018,43155,43425,43426,43898,43907,43980,44197,44369,44370,44442,44906,45018,45038,45039,45040,45041,45042,45043,45227)
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 | 1758 | 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.81 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.05 ms |
init | 0.31 ms |
System lock | 0.02 ms |
optimizing | 0.11 ms |
statistics | 2.64 ms |
preparing | 1.37 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 4.16 ms |
end | 0.03 ms |
query end | 0.05 ms |
closing tables | 0.03 ms |
freeing items | 0.12 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 |