Tiempo de la consulta: 31.37 ms Después de la última consulta: 2.18 ms Consulta a la memoria: 3.221 MB memoria antes de la consulta: 4.672 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-08 02:36:26')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-08 02:36:26')
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(8,16,17,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,39,40,41,42,43,44,45,46,47,48,49,50,51,54,55,64,75,84,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,125,128,157,162,165,175,180,193,194,195,205,206,209,210,211,218,222,225,226,227,228,229,230,231,232,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,252,253,257,263,269,270,271,272,275,287,308,311,327,329,361,367,370,385,387,388,390,391,392,393,395,397,398,400,401,402,403,404,405,408,410,411,412,414,415,416,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,435,436,437,438,442,443,445,448,451,454,455,466,471,473,475,479,482,499,529,543,560,581,589,594,610,635,639,643,644,645,653,661,662,672,680,685,686,692,700,701,703,709,713,736,754,760,761,772,783,786,802,826,847,848,856,859,868,874,893,896,907,924,960,967,968,984,998,1004,1021,1024,1032,1034,1042,1048,1079,1092,1098,1106,1127,1138,1142,1150,1151,1172,1192,1194,1205,1226,1255,1269,1271,1279,1280,1284,1290,1295,1305,1322,1326,1331,1335,1349,1358,1375,1382,1408,1420,1421,1425,1426,1433,1435,1437,1441,1444,1445,1447,1454,1455,1460,1466,1467,1476,1477,1481,1484,1491,1509,1534,1553,1586,1595,1605,1624,1664,1666,1788,1811,1812,1841,1852,1855,1870,1885,1903,1906,1984,2001,2018,2065,2077,2148,2162,2177,2193,2199,2301,2353,2359,2408,2432,2469,2480,2569,2582,2618,2629,2631,2637,2691,2724,2732,2773,2885,2989,3056,3095,3119,3202,3251,3265,3268,3278,3355,3364,3379,3452,3513,3537,3590,3592,3594,3616,3663,3684,3688,3825,3836,3872,3936,3938,3953,3958,3976,3992,4020,4063,4075,4118,4132,4138,4168,4173,4176,4197,4249,4252,4271,4277,4435,4442,4477,4523,4524,4525,4539,4558,4580,4585,4586,4587,4605,4637,4641,4648,4649,4665,4678,4688,4698,4758,4765,4785,4788,4790,4795,4808,4822,4844,4874,4892,4919,4932,4960,5014,5023,5035,5076,5079,5143,5157,5166,5226,5250,5259,5279,5332,5334,5360,5363,5394,5435,5496,5507,5508,5534,5560,5642,5658,5659,5692,5698,5700,5730,5807,5827,5832,5833,5834,5848,5853,5862,5876,5914,5927,5936,5949,5962,5968,5985,5990,6007,6009,6038,6063,6064,6067,6068,6072,6083,6133,6134,6138,6168,6200,6202,6217,6218,6226,6241,6247,6286,6305,6308,6315,6319,6323,6328,6334,6335,6366,6393,6396,6398,6421,6431,6452,6461,6464,6475,6500,6504,6506,6512,6520,6529,6532,6533,6540,6545,6551,6553,6574,6575,6583,6596,6599,6610,6611,6648,6661,6663,6664,6667,6669,6699,6707,6710,6718,6758,6765,6767,6768,6774,6777,6778,6783,6798,6810,6824,6842,6848,6853,6884,6885,6889,6905,6932,6941,6942,6944,6945,6955,6970,6997,6998,7002,7037,7043,7046,7057,7081,7086,7108,7136,7139,7140,7156,7172,7182,7190,7191,7193,7194,7200,7202,7233,7237,7245,7252,7258,7277,7278,7320,7323,7326,7344,7358,7405,7416,7419,7421,7435,7465,7525,7560,7567,7580,7582,7591,7596,7597,7611,7618,7621,7626,7633,7676,7686,7687,7688,7709,7718,7721,7748,7759,7761,7762,7764,7765,7769,7775,7779,7794,7800,7801,7802,7803,7811,7813,7820,7824,7828,7830,7834,7837,7839,7845,7860,7862,7867,7868,7869,7870,7873,7878,7883,7921,7931,7932,7936,7946,7951,7965,7966,7972,7995,7999,8029,8032,8034,8069,8077,8083,8088,8089,8091,8099,8108,8114,8155,8171,8186,8187,8206,8221,8230,8268,8278,8283,8286,8294,8297,8316,8340,8341,8353,8355,8359,8361,8387,8400,8406,8416,8417,8504,8518,8534,8540,8551,8582,8612,8613,8627,8646,8662,8666,8670,8695,8712,8728,8758,8760,8772,8778,8779,8814,8818,8819,8822,8827,8836,8848,8858,8864,8890,8892,8907,8910,8917,8925,8938,8944,8964,8997,9023,9067,9071,9083,9084,9086,9096,9097,9098,9100,9108,9110,9114,9122,9132,9149,9155,9172,9188,9199,9206,9222,9228,9233,9236,9238,9264,9270,9320,9404,9416,9433,9449,9462,9472,9501,9528,9548,9562,9626,9640,9641,9653,9654,9656,9675,9690,9699,9715,9716,9717,9750,9754,9755,9756,9757,9767,9788,9808,9853,9879,9889,9909,9919,9931,9934,9970,10035,10067,10068,10100,10156,10179,10220,10298,10301,10316,10356,10364,10371,10373,10413,10474,10501,10542,10616,10625,10627,10677,10706,10725,10736,10746,10765,10775,10779,10811,10814,10834,10851,10854,10884,10886,10909,10932,10995,10996,11044,11091,11112,11138,11179,11195,11212,11220,11223,11238,11244,11314,11332,11397,11408,11411,11413,11428,11437,11440,11443,11444,11458,11465,11527,11542,11565,11592,11651,11696,11700,11704,11705,11795,11814,11827,11842,11857,11859,11885,11947,12025,12089,12104,12170,12189,12198,12199,12238,12288,12304,12324,12334,12344,12368,12375,12388,12436,12437,12439,12440,12482,12507,12524,12567,12599,12624,12625,12672,12683,12684,12701,12705,12750,12816,12822,12839,12867,12892,12896,12898,12902,12913,12926,12946,12973,12994,13004,13010,13023,13067,13068,13076,13078,13126,13128,13145,13155,13160,13202,13209,13231,13232,13247,13248,13256,13258,13266,13272,13276,13277,13297,13316,13323,13341,13344,13348,13378,13413,13428,13436,13437,13438,13452,13458,13467,13477,13478,13479,13480,13481,13482,13485,13502,13503,13525,13543,13560,13589,13597,13606,13608,13617,13628,13645,13646,13660,13698,13724,13725,13729,13731,13778,13784,13794,13797,13798,13811,13824,13850,13851,13861,13880,13900,13926,13950,13962,13968,13970,13972,13976,14037,14052,14064,14091,14100,14125,14140,14149,14153,14154,14156,14159,14177,14179,14183,14187,14205,14222,14226,14246,14293,14309,14338,14353,14402,14411,14419,14427,14428,14429,14432,14451,14493,14498,14506,14519,14546,14563,14604,14641,14646,14677,14682,14687,14700,14710,14718,14774,14790,14796,14797,14807,14811,14832,14838,14860,14862,14864,14874,14875,14892,14895,14906,14942,14949,14958,14969,14970,14982,15002,15007,15038,15047,15063,15079,15138,15147,15148,15184,15185,15199,15216,15223,15224,15228,15229,15257,15272,15287,15293,15310,15315,15316,15359,15365,15411,15420,15450,15455,15460,15462,15464,15465,15476,15479,15500,15508,15515,15524,15533,15543,15551,15555,15566,15577,15583,15596,15598,15625,15632,15640,15643,15644,15645,15650,15654,15665,15674,15681,15685,15706,15722,15732,15759,15824,15832,15841,15856,15901,15913,15917,15935,15940,15941,15947,15954,15967,15969,15980,15982,15988,15999,16041,16051,16052,16066,16069,16071,16120,16137,16176,16184,16190,16202,16212,16216,16224,16258,16323,16348,16365,16370,16383,16385,16386,16387,16391,16428,16466,16469,16507,16523,16529,16543,16547,16550,16569,16586,16607,16629,16634,16641,16642,16658,16675,16677,16680,16706,16774,16780,16787,16791,16803,16831,16857,16862,16876,16880,16887,16897,16909,16910,16936,16978,16979,16987,17014,17022,17057,17087,17093,17100,17121,17126,17137,17139,17142,17148,17151,17169,17177,17224,17232,17233,17241,17248,17251,17253,17282,17295,17311,17328,17335,17336,17341,17355,17383,17384,17388,17393,17404,17424,17427,17448,17450,17454,17457,17478,17481,17500,17507,17543,17552,17555,17557,17587,17594,17608,17635,17641,17642,17645,17658,17660,17661,17667,17685,17690,17698,17699,17721,17722,17728,17737,17740,17742,17746,17776,17780,17785,17788,17799,17808,17809,17820,17822,17843,17856,17892,17894,17907,17908,17918,17921,17927,17928,17934,17956,17958,17960,18002,18006,18013,18021,18035,18037,18039,18040,18042,18055,18073,18078,18083,18105,18160,18174,18181,18202,18220,18223,18234,18235,18237,18245,18258,18284,18290,18292,18304,18306,18312,18354,18382,18440,18457,18466,18508,18525,18527,18540,18550,18563,18580,18648,18677,18707,18719,18736,18738,18739,18745,18747,18767,18771,18773,18774,18777,18779,18799,18801,18802,18813,18823,18824,18834,18843,18850,18851,18855,18879,18880,18885,18900,18901,18916,18917,18919,18935,18944,18954,18964,18968,18969,18979,18980,18996,18998,19012,19019,19024,19035,19041,19043,19053,19073,19075,19081,19089,19094,19099,19127,19132,19135,19145,19154,19157,19159,19186,19188,19189,19196,19197,19203,19216,19245,19256,19257,19265,19282,19294,19303,19307,19313,19335,19343,19358,19364,19376,19380,19383,19390,19407,19412,19424,19425,19452,19472,19489,19492,19505,19508,19514,19520,19526,19528,19532,19536,19544,19553,19558,19559,19562,19584,19585,19589,19596,19603,19605,19612,19618,19619,19630,19640,19649,19655,19664,19675,19685,19703,19704,19720,19723,19724,19745,19764,19773,19789,19793,19797,19801,19805,19806,19816,19831,19832,19843,19853,19933,19938,19950,19963,19968,19979,20002,20004,20037,20043,20046,20051,20056,20066,20072,20076,20082,20088,20094,20102,20115,20116,20117,20142,20159,20181,20190,20201,20202,20208,20209,20223,20226,20236,20242,20265,20266,20271,20275,20298,20323,20341,20362,20372,20404,20417,20428,20431,20438,20452,20456,20473,20477,20496,20501,20519,20533,20548,20568,20569,20577,20584,20590,20602,20608,20643,20664,20674,20682,20685,20715,20717,20720,20732,20738,20739,20754,20759,20766,20773,20795,20797,20803,20808,20832,20838,20852,20861,20864,20871,20873,20876,20877,20884,20890,20891,20908,20911,20933,20934,20935,20938,20939,20962,20969,20976,20985,21003,21008,21040,21044,21053,21059,21095,21149,21156,21176,21179,21186,21189,21197,21198,21205,21214,21221,21239,21240,21274,21275,21277,21280,21284,21293,21299,21308,21311,21326,21333,21341,21354,21358,21364,21379,21387,21393,21408,21411,21412,21428,21429,21434,21437,21438,21446,21451,21465,21469,21478,21491,21505,21509,21515,21527,21528,21538,21559,21562,21565,21573,21582,21601,21609,21611,21620,21629,21638,21652,21653,21654,21680,21688,21691,21708,21741,21744,21746,21775,21779,21784,21798,21817,21818,21819,21821,21824,21830,21835,21845,21848,21911,21942,21943,21946,21957,21962,21971,21981,21989,21995,22011,22019,22064,22094,22104,22109,22136,22158,22164,22173,22180,22186,22201,22211,22213,22222,22226,22259,22267,22286,22291,22294,22299,22309,22314,22315,22325,22330,22335,22338,22400,22410,22411,22414,22415,22416,22428,22435,22442,22448,22464,22475,22476,22482,22512,22524,22525,22534,22546,22561,22591,22600,22613,22624,22634,22638,22649,22653,22655,22662,22678,22679,22687,22710,22722,22728,22733,22749,22755,22756,22773,22816,22844,22848,22854,22860,22864,22872,22874,22876,22882,22885,22899,22903,22921,22945,23019,23031,23032,23039,23040,23101,23102,23110,23114,23123,23124,23143,23145,23161,23163,23186,23217,23221,23229,23260,23269,23277,23284,23296,23301,23313,23319,23320,23332,23337,23344,23362,23394,23406,23430,23444,23453,23463,23511,23513,23531,23541,23547,23592,23593,23634,23638,23645,23652,23685,23691,23695,23701,23705,23714,23715,23722,23738,23747,23760,23769,23833,23850,23860,23868,23948,23949,23954,23985,24017,24022,24052,24055,24056,24059,24164,24170,24179,24191,24198,24207,24217,24222,24309,24317,24338,24380,24441,24447,24455,24524,24599,24617,24634,24683,24700,24722,24726,24784,24808,24819,24838,24875,24884,24922,24954,24966,24977,25010,25039,25054,25096,25110,25141,25154,25172,25197,25278,25284,25292,25317,25326,25406,25456,25504,25511,25542,25585,25593,25598,25609,25612,25621,25648,25655,25656,25693,25705,25717,25719,25742,25750,25792,25833,25860,25881,25943,25964,25986,26002,26028,26043,26078,26109,26154,26166,26167,26171,26214,26215,26317,26338,26348,26353,26376,26394,26396,26398,26405,26406,26408,26410,26464,26468,26476,26530,26548,26661,26722,26753,26775,26797,26807,26849,26852,26858,26874,26875,26885,26891,26897,26905,26909,26916,26944,26945,26947,26950,26951,26956,27030,27035,27046,27054,27143,27166,27206,27237,27249,27268,27269,27270,27274,27280,27311,27326,27362,27383,27399,27414,27415,27420,27422,27437,27439,27482,27488,27491,27518,27547,27552,27582,27610,27717,27724,27726,27742,27779,27786,27805,27851,27859,27878,27997,28189,28233,28277,28306,28423,28598,28628,28671,28712,28714,28716,28745,28746,28889,28890,29000,29130,29373,29387,29454,29511,29548,29562,29864,29870,30506,30562,30703,30932,31384,31560,31937,32530,32769,32919,33345,33555,34174,34356,34428,34676,35102,35226,35299,35337,35360,35379,35434,35502,35596,35692,35695,35725,35736,35758,35780,35892,35926,35945,36065,36085,36160,36200,36217,36297,36515,36751,36817,36961,37034,37107,37116,37170,37397,37403,37439,37454,37942,38006,38103,38114,38122,38128,38315,38343,38398,38440,38446,38452,38530,38549,38674,38773,38800,38807,38850,38887,39004,39027,39033,39052,39065,39111,39113,39132,39142,39145,39150,39163,39170,39173,39193,39208,39237,39245,39271,39276,39286,39302,39315,39319,39335,39342,39347,39355,39375,39389,39412,39413,39475,39492,39528,39539,39572,39609,39616,39645,39669,39706,39722,39740,39747,39751,39768,39774,39775,39802,39820,39878,39968,40015,40018,40036,40037,40039,40049,40089,40097,40116,40186,40201,40225,40231,40257,40276,40328,40331,40392,40398,40436,40438,40460,40465,40492,40535,40554,40555,40558,40562,40588,40604,40614,40648,40661,40662,40667,40672,40681,40688,40707,40737,40751,40752,40774,40811,40817,40836,40887,40920,40922,40959,40993,41006,41040,41068,41083,41102,41147,41150,41163,41195,41220,41246,41270,41322,41418,41436,41499,41532,41570,41576,41649,41724,41794,41797,41800,41839,41865,41871,41879,41896,41927,41956,41957,42040,42054,42057,42065,42091,42134,42154,42163,42174,42188,42212,42304,42405,42448,42490,42538,42572,42703,42729,42765,42800,42806,42863,43009,43115,43136,43143,43222,43234,43244,43267,43294,43345,43459,43508,43509,43539,43550,43565,43596,43601,43605,43615,43682,43846,43979,44026,44177,44184,44277,44351,44400,44431,44491,44544,44588,44611,44613,44701,44894,44908,44941,45051,45136,45157,45302,45303)
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 | 2348 | 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.39 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.06 ms |
init | 0.45 ms |
System lock | 0.02 ms |
optimizing | 0.19 ms |
statistics | 4.23 ms |
preparing | 2.17 ms |
Sorting result | 0.06 ms |
executing | 0.01 ms |
Sending data | 21.57 ms |
end | 0.03 ms |
query end | 0.04 ms |
closing tables | 0.02 ms |
freeing items | 0.13 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 |