Tiempo de la consulta: 13.43 ms Después de la última consulta: 1.95 ms Consulta a la memoria: 1.065 MB memoria antes de la consulta: 4.629 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 08:49:37')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 08:49:37')
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(7,11,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,66,69,72,78,81,85,87,88,89,94,110,111,117,120,125,126,138,141,155,167,180,188,189,190,200,201,205,214,216,217,234,246,248,249,263,265,271,279,285,303,304,305,306,309,316,317,325,332,340,349,353,354,362,368,373,377,390,412,415,416,420,421,422,423,424,426,427,429,431,450,463,484,493,495,496,501,503,515,519,522,531,549,572,574,575,583,584,592,593,621,635,666,667,686,723,728,731,740,741,742,757,785,791,808,825,826,828,841,853,855,862,863,868,869,885,891,908,931,954,955,986,996,1007,1020,1029,1052,1101,1102,1103,1133,1168,1187,1188,1207,1216,1223,1229,1257,1265,1278,1279,1287,1296,1298,1302,1313,1323,1336,1338,1342,1343,1344,1353,1354,1357,1367,1380,1392,1402,1406,1413,1420,1421,1430,1433,1434,1435,1441,1443,1470,1478,1506,1507,1524,1531,1532,1537,1538,1558,1568,1572,1587,1598,1645,1648,1681,1695,1718,1719,1823,1846,1867,1878,1905,1932,2013,2096,2107,2108,2145,2178,2194,2207,2208,2209,2229,2236,2245,2272,2314,2315,2316,2328,2332,2333,2342,2373,2376,2381,2402,2410,2453,2459,2476,2481,2503,2511,2516,2524,2564,2579,2594,2610,2644,2647,2688,2695,2717,2720,2728,2765,2817,2825,2830,2925,2926,2942,2954,3020,3051,3054,3063,3073,3106,3107,3112,3117,3126,3129,3137,3143,3163,3174,3187,3212,3222,3235,3293,3325,3327,3353,3354,3369,3382,3388,3402,3409,3412,3436,3454,3457,3476,3486,3546,3556,3574,3577,3579,3582,3587,3602,3615,3650,3657,3663,3675,3682,3709,3796,3827,3840,3864,3934,3979,4015,4074,4153,4182,4309,4310,4335,4343,4409,4488,4503,4525,4589,4631,4632,4654,4674,4679,4680,4684,4688,4689,4691,4698,4718,4746,4784,4808,4816,4823,4841,4847,4863,4871,4902,4905,4916,4949,4971,4999,5001,5016,5020,5051,5060,5099,5160,5176,5180,5189,5192,5247,5254,5259,5291,5313,5323,5324,5371,5378,5392,5396,5431,5446,5449,5461,5470,5476,5478,5511,5536,5538,5566,5569,5572,5579,5588,5594,5597,5622,5631,5632,5645,5650,5659,5662,5666,5685,5686,5722,5726,5727,5729,5730,5747,5798,5799,5822,5846,5847,5857,5870,5881,5886,5894,5895,5896,5913,6006,6010,6056,6088,6120,6144,6178,6217,6257,6272,6292,6311,6348,6349,6354,6359,6363,6389,6392,6420,6437,6445,6465,6470,6478,6482,6488,6498,6531,6539,6545,6568,6575,6616,6639,6666,6671,6675,6677,6688,6730,6776,6799,6802,6836,6868,6876,6942,6948,6965,6975,6988,7014,7017,7050,7052,7056,7069,7082,7086,7096,7099,7109,7110,7122,7124,7138,7156,7181,7192,7200,7210,7212,7243,7244,7246,7272,7275,7276,7281,7287,7299,7309,7328,7334,7336,7339,7340,7410,7411,7420,7421,7437,7450,7460,7466,7478,7487,7495,7546,7555,7556,7588,7621,7624,7640,7680,7692,7716,7719,7720,7725,7730,7731,7736,7751,7776,7782,7799,7811,7818,7831,7837,7839,7841,7850,7860,7866,7868,7889,7897,7924,7932,7933,7946,7970,7993,7998,8027,8037,8046,8061,8071,8089,8090,8116,8118,8141,8199,8215,8235,8258,8259,8275,8276,8319,8339,8354,8360,8377,8382,8386,8417,8442,8444,8451,8457,8482,8494,8496,8498,8514,8533,8540,8565,8566,8569,8580,8589,8593,8602,8610,8617,8638,8704,8759,8760,8773,8776,8781,8835,8846,8853,8856,8860,8864,8887,8909,8929,8983,9029,9087,9120,9148,9191,9201,9204,9206,9219,9223,9259,9262,9282,9298,9322,9364,9411,9428,9429,9472,9475,9552,9650,9658,9668,9677,9678,9682,9750,9761,9801,9806,9818,9836,9839,9924,9942,9956,10009,10030,10035,10037,10078,10079,10114,10162,10261,10274,10308,10316,10327,10340,10345,10348,10403,10475,10478,10548,10553,10595,10615,10630,10665,10673,10694,10708,10775,10801,10868,10964,11030,11057,11059,11194,11241,11250,11253,11258,11288,11289,11299,11345,11408,11439,11440,11441,11472,11511,11547,11603,11626,11632,11668,11692,11714,11857,11899,11929,11935,11967,12011,12012,12020,12060,12116,12128,12181,12184,12219,12223,12225,12318,12324,12385,12401,12410,12428,12460,12499,12595,12617,12622,12623,12624,12625,12628,12630,12633,12637,12650,12670,12685,12686,12705,12708,12717,12718,12749,12752,12760,12768,12789,12810,12811,12853,12875,12876,12894,12901,12913,12925,12944,12945,12957,12962,12973,12996,13002,13010,13012,13014,13016,13017,13032,13078,13152,13224,13231,13239,13246,13248,13276,13277,13294,13298,13348,13349,13452,13473,13474,13475,13671,13687,13697,13707,13723,13735,13742,13759,13804,13840,13842,13851,13900,13913,13932,13959,13971,13973,13975,13992,14005,14044,14047,14048,14074,14089,14092,14105,14117,14142,14153,14181,14192,14203,14204,14224,14229,14263,14267,14271,14273,14293,14350,14362,14385,14399,14404,14442,14447,14456,14457,14468,14500,14516,14534,14536,14542,14554,14564,14570,14591,14592,14601,14646,14698,14708,14730,14754,14759,14795,14852,14860,14987,14992,15004,15022,15030,15032,15037,15038,15043,15055,15080,15094,15108,15147,15217,15245,15247,15261,15293,15321,15347,15372,15378,15382,15403,15408,15414,15424,15439,15440,15471,15475,15476,15486,15492,15493,15495,15520,15530,15533,15542,15562,15574,15575,15632,15639,15651,15657,15678,15711,15712,15714,15717,15728,15756,15757,15780,15796,15829,15839,15850,15856,15861,15899,15904,15905,15935,15945,15948,15952,15953,15972,16038,16055,16062,16071,16089,16115,16140,16153,16156,16158,16161,16176,16200,16206,16214,16216,16249,16257,16267,16297,16303,16305,16313,16347,16370,16373,16390,16394,16421,16423,16425,16430,16449,16457,16458,16459,16481,16488,16497,16508,16526,16534,16537,16543,16565,16566,16580,16609,16652,16657,16714,16751,16763,16780,16792,16813,16833,16863,16866,16872,16889,16891,16908,16928,16929,16936,16950,16976,16981,17000,17002,17033,17038,17039,17091,17102,17114,17116,17126,17142,17148,17185,17209,17215,17234,17249,17273,17275,17282,17291,17309,17314,17331,17334,17335,17344,17347,17358,17363,17379,17381,17405,17419,17422,17432,17458,17484,17496,17501,17509,17528,17529,17573,17575,17596,17607,17627,17629,17634,17640,17646,17659,17661,17662,17699,17702,17710,17721,17734,17757,17766,17799,17812,17818,17831,17840,17851,17854,17857,17862,17864,17869,17889,17895,17898,17921,17947,17960,17961,18021,18060,18071,18073,18110,18111,18122,18127,18158,18159,18181,18187,18212,18220,18229,18233,18249,18260,18267,18277,18284,18286,18298,18300,18301,18309,18316,18318,18321,18326,18342,18360,18362,18380,18384,18419,18421,18429,18433,18442,18452,18465,18490,18494,18498,18509,18511,18516,18543,18549,18552,18555,18556,18558,18561,18571,18577,18578,18580,18588,18605,18612,18618,18630,18652,18658,18675,18682,18689,18690,18739,18750,18757,18770,18780,18784,18801,18807,18816,18819,18826,18843,18845,18847,18848,18856,18864,18869,18901,18904,18910,18945,18953,18977,18988,18989,18991,18994,18995,18999,19007,19022,19024,19027,19028,19035,19039,19040,19052,19056,19059,19083,19086,19091,19105,19112,19130,19132,19135,19145,19149,19158,19171,19178,19184,19185,19189,19207,19217,19219,19226,19247,19260,19261,19274,19282,19292,19294,19303,19304,19313,19325,19335,19350,19364,19366,19370,19381,19386,19389,19396,19427,19437,19442,19445,19446,19453,19454,19460,19492,19501,19524,19527,19545,19551,19555,19567,19574,19581,19593,19595,19604,19608,19617,19650,19655,19659,19661,19668,19684,19695,19700,19731,19733,19772,19811,19825,19857,19867,19873,19883,19886,19898,19923,19931,19932,19937,19940,19950,19972,19980,19983,19991,20003,20006,20010,20020,20024,20026,20030,20033,20034,20036,20039,20043,20053,20056,20058,20059,20060,20067,20069,20095,20099,20103,20111,20115,20120,20145,20162,20183,20192,20193,20195,20199,20213,20216,20234,20237,20248,20250,20252,20254,20256,20271,20279,20287,20296,20308,20354,20356,20358,20374,20394,20402,20403,20426,20439,20440,20443,20459,20461,20464,20500,20539,20559,20567,20578,20579,20590,20595,20609,20616,20638,20648,20649,20659,20667,20677,20681,20699,20700,20727,20755,20768,20797,20800,20823,20826,20837,20847,20856,20866,20888,20945,20946,20947,20950,20969,20983,20987,21000,21007,21016,21038,21049,21087,21094,21095,21115,21118,21135,21148,21159,21161,21163,21178,21180,21194,21202,21229,21252,21256,21266,21279,21283,21285,21288,21294,21300,21305,21321,21334,21338,21340,21368,21380,21384,21388,21390,21393,21421,21422,21426,21433,21452,21458,21459,21464,21467,21485,21486,21490,21491,21508,21516,21520,21521,21522,21524,21526,21529,21536,21546,21583,21593,21618,21623,21650,21661,21664,21690,21692,21695,21701,21704,21709,21711,21719,21721,21727,21732,21735,21737,21752,21774,21782,21800,21824,21836,21843,21850,21853,21870,21906,21907,21910,21912,21917,21952,21954,21955,21956,21961,21971,21988,21998,22005,22015,22018,22020,22025,22030,22035,22059,22062,22077,22081,22082,22117,22132,22140,22149,22163,22164,22175,22177,22195,22222,22225,22228,22241,22244,22245,22246,22257,22302,22324,22325,22351,22359,22382,22385,22404,22406,22415,22416,22421,22435,22446,22453,22455,22500,22502,22512,22517,22525,22527,22543,22580,22603,22620,22622,22626,22633,22647,22651,22655,22658,22668,22693,22698,22710,22715,22727,22736,22742,22744,22765,22780,22787,22803,22804,22805,22829,22833,22841,22874,22895,22897,22898,22919,22923,22924,22947,22963,22972,22979,22985,23000,23007,23014,23022,23024,23028,23034,23041,23043,23053,23060,23062,23072,23081,23082,23089,23124,23132,23144,23168,23179,23181,23196,23200,23214,23234,23247,23250,23256,23294,23299,23300,23304,23328,23332,23344,23369,23401,23408,23467,23480,23516,23528,23546,23559,23564,23565,23598,23615,23620,23633,23665,23668,23675,23682,23691,23711,23716,23722,23732,23759,23763,23767,23817,23833,23839,23857,23859,23900,23907,23922,23926,23927,23930,23955,23962,23965,23967,23974,23982,24016,24019,24025,24051,24060,24072,24075,24076,24111,24127,24141,24155,24164,24174,24175,24193,24226,24230,24243,24248,24249,24264,24282,24356,24361,24392,24393,24408,24413,24457,24472,24475,24478,24522,24523,24573,24580,24582,24615,24616,24617,24618,24624,24703,24710,24727,24785,24788,24799,24803,24804,24823,24844,24888,24924,24937,24943,24956,24968,24979,24989,24993,24995,25003,25007,25030,25035,25041,25048,25062,25079,25099,25100,25126,25131,25135,25138,25170,25171,25184,25245,25278,25306,25315,25318,25331,25333,25336,25351,25360,25406,25411,25420,25428,25436,25448,25458,25463,25475,25498,25534,25542,25557,25584,25624,25639,25640,25646,25648,25660,25673,25685,25687,25690,25694,25764,25798,25818,25891,25904,25954,25955,25981,26000,26018,26033,26062,26107,26122,26147,26204,26219,26221,26226,26239,26317,26318,26343,26360,26361,26369,26386,26415,26424,26431,26454,26474,26509,26520,26522,26530,26630,26631,26651,26659,26665,26673,26677,26680,26713,26731,26737,26742,26767,26772,26779,26800,26801,26802,26808,26816,26820,26845,26881,26884,26898,26905,26907,26910,26939,26944,26947,26972,26973,26988,26996,27000,27023,27024,27026,27038,27102,27131,27151,27183,27184,27186,27188,27189,27199,27307,27332,27340,27354,27355,27356,27363,27364,27366,27390,27410,27431,27438,27449,27450,27452,27454,27490,27518,27520,27530,27533,27541,27545,27616,27624,27628,27688,27722,27738,27743,27775,27806,27808,27846,27891,28030,28046,28072,28080,28218,28240,28328,28330,28339,28366,28440,28442,28452,28601,28614,28615,28616,28636,28712,28728,28780,28823,28845,28892,28944,28961,29002,29054,29074,29215,29389,29460,29495,29502,29515,29557,29590,29635,29908,30482,30486,30656,31623,31624,31640,32250,32302,32381,32507,32590,32843,32896,32943,33040,33129,33199,33417,33649,34076,34078,34099,34109,34179,34184,34229,34241,34258,34260,34269,34292,34326,34343,34357,34699,35095,35144,35153,35218,35330,35585,35689,35713,35744,35750,35778,35865,35885,35955,36016,36051,36052,36130,36177,36196,36267,36289,36292,36299,36341,36384,36591,36594,36598,36604,36769,37083,37856,38610,38613,38652,38777,38946,38971,39041,39169,39171,39211,39225,39269,39398,39453,39483,39530,39571,39590,39625,39682,39763,39790,39821,39858,40036,40213,40385,40386,40387,40404,40456,40492,40605,40742,40822,40850,40983,40990,41068,41207,41298,41363,41442,42310,42602,43018,43425,43426,44906,45008,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 | 2078 | 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.27 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.52 ms |
System lock | 0.03 ms |
optimizing | 0.19 ms |
statistics | 4.08 ms |
preparing | 1.85 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 4.81 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.12 ms |
cleaning up | 0.03 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 |