Tiempo de la consulta: 11.79 ms Después de la última consulta: 2.05 ms Consulta a la memoria: 1.065 MB memoria antes de la consulta: 4.695 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 05:01:04')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 05:01:04')
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,14,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,66,67,78,81,87,88,89,94,109,110,111,117,120,125,126,127,136,137,154,167,180,188,189,190,195,200,201,205,216,234,239,241,246,248,249,263,265,271,278,304,305,306,313,315,316,317,325,332,340,353,354,358,362,365,368,372,373,374,377,382,390,412,415,416,420,421,422,423,424,426,427,429,431,446,450,458,463,478,484,493,495,496,500,501,503,510,515,519,521,531,549,558,574,575,584,592,618,621,635,668,671,682,686,695,723,728,729,731,737,740,741,742,757,771,785,790,791,804,812,816,825,841,842,845,853,855,862,868,878,879,891,908,911,915,928,931,954,955,986,997,1007,1010,1016,1018,1020,1027,1029,1033,1052,1057,1094,1103,1129,1158,1168,1186,1187,1188,1200,1207,1210,1214,1223,1226,1229,1234,1240,1257,1264,1265,1287,1296,1298,1302,1313,1319,1335,1336,1338,1339,1344,1345,1353,1354,1357,1361,1367,1380,1383,1392,1402,1406,1411,1413,1418,1420,1421,1430,1433,1434,1435,1441,1443,1461,1470,1478,1506,1507,1524,1531,1532,1537,1549,1558,1559,1568,1571,1572,1579,1596,1598,1620,1621,1671,1681,1690,1691,1695,1701,1718,1719,1738,1748,1752,1756,1760,1782,1811,1823,1873,1878,1905,1932,1954,1994,2082,2094,2096,2108,2145,2147,2165,2178,2194,2207,2208,2209,2229,2230,2236,2245,2251,2272,2314,2315,2316,2332,2333,2342,2343,2373,2376,2410,2423,2425,2433,2436,2453,2459,2476,2481,2503,2511,2516,2524,2530,2542,2564,2566,2579,2584,2594,2595,2644,2660,2667,2675,2678,2682,2695,2699,2720,2728,2740,2765,2780,2817,2822,2823,2825,2830,2835,2870,2875,2894,2922,2926,2942,2964,2975,2997,3020,3022,3028,3030,3036,3051,3063,3065,3073,3079,3097,3112,3117,3122,3126,3129,3137,3143,3163,3187,3212,3222,3235,3273,3290,3293,3294,3295,3316,3325,3327,3332,3347,3350,3353,3382,3388,3436,3457,3486,3506,3521,3546,3550,3556,3574,3579,3582,3587,3597,3602,3624,3650,3657,3675,3682,3696,3706,3709,3722,3796,3827,3840,3864,3871,3901,3927,3947,3951,3979,4011,4015,4047,4074,4096,4111,4153,4163,4227,4267,4276,4281,4309,4310,4323,4335,4343,4357,4368,4401,4411,4422,4467,4471,4472,4488,4490,4520,4525,4546,4562,4631,4632,4637,4654,4666,4674,4684,4688,4689,4691,4710,4718,4760,4765,4784,4790,4808,4841,4847,4871,4896,4902,4905,4949,4971,4999,5001,5016,5020,5049,5051,5060,5085,5088,5094,5099,5150,5151,5180,5186,5189,5300,5306,5323,5324,5378,5392,5399,5431,5470,5476,5515,5538,5555,5561,5566,5569,5572,5573,5579,5588,5594,5597,5632,5645,5648,5650,5659,5662,5685,5707,5722,5726,5727,5729,5732,5747,5798,5822,5870,5894,5895,5918,5929,5969,6006,6010,6032,6062,6121,6141,6147,6176,6217,6272,6292,6311,6317,6348,6349,6354,6359,6363,6392,6403,6445,6448,6475,6482,6484,6498,6520,6568,6616,6666,6671,6675,6677,6703,6742,6751,6763,6772,6776,6802,6818,6836,6837,6856,6864,6868,6872,6975,6990,6994,7017,7050,7056,7082,7086,7096,7099,7109,7110,7121,7124,7130,7138,7181,7210,7212,7273,7275,7276,7277,7285,7286,7287,7299,7309,7313,7327,7331,7334,7338,7346,7374,7449,7450,7464,7466,7482,7484,7495,7513,7551,7555,7577,7583,7584,7590,7594,7631,7666,7670,7680,7692,7716,7719,7726,7730,7745,7757,7764,7782,7811,7829,7837,7839,7840,7860,7868,7871,7884,7901,7932,7933,7942,7946,7961,7970,7993,7998,8027,8032,8037,8039,8061,8071,8138,8176,8177,8199,8215,8258,8275,8276,8339,8351,8399,8444,8451,8453,8454,8494,8498,8521,8540,8550,8553,8565,8569,8589,8593,8602,8610,8611,8638,8704,8773,8776,8781,8821,8835,8853,8856,8887,8973,8983,9017,9029,9122,9148,9191,9201,9206,9223,9254,9262,9282,9322,9384,9411,9428,9472,9475,9494,9569,9610,9650,9677,9678,9734,9743,9745,9754,9818,9832,9839,9841,9886,9891,9924,9942,9956,10009,10035,10078,10079,10121,10149,10199,10204,10207,10261,10274,10283,10307,10308,10315,10340,10345,10348,10388,10401,10403,10409,10420,10464,10499,10537,10538,10595,10642,10645,10656,10665,10673,10703,10708,10737,10775,10833,10838,10854,10860,10861,10892,10932,10986,11009,11027,11030,11039,11043,11112,11130,11142,11150,11174,11238,11241,11263,11292,11320,11324,11345,11366,11377,11439,11441,11473,11500,11538,11549,11588,11595,11603,11625,11626,11666,11670,11680,11687,11692,11700,11713,11716,11722,11723,11775,11786,11803,11870,11879,11926,11935,11967,11988,12011,12020,12036,12042,12060,12069,12085,12116,12128,12131,12136,12152,12161,12181,12218,12219,12223,12225,12311,12317,12319,12324,12362,12370,12385,12393,12448,12460,12514,12518,12588,12595,12601,12604,12620,12622,12623,12625,12630,12636,12650,12670,12676,12685,12686,12703,12705,12708,12717,12718,12738,12752,12758,12760,12815,12849,12887,12894,12910,12913,12925,12940,12945,12957,12960,12973,12996,13002,13010,13014,13016,13078,13079,13107,13132,13152,13167,13205,13222,13248,13250,13294,13296,13308,13345,13348,13359,13367,13379,13396,13416,13440,13446,13473,13474,13475,13481,13494,13594,13645,13664,13697,13708,13753,13759,13791,13830,13892,13899,13900,13959,13971,13973,14005,14027,14040,14047,14048,14078,14092,14133,14175,14181,14195,14198,14199,14204,14229,14232,14234,14268,14292,14293,14305,14310,14350,14355,14362,14364,14378,14380,14421,14445,14451,14453,14457,14468,14480,14493,14502,14505,14516,14531,14534,14536,14542,14554,14564,14570,14592,14608,14618,14637,14638,14640,14648,14654,14691,14699,14798,14816,14850,14852,14860,14955,14969,14975,14982,14987,15002,15003,15020,15038,15043,15052,15060,15079,15092,15105,15107,15115,15123,15138,15148,15180,15200,15206,15217,15226,15245,15248,15257,15261,15284,15293,15299,15321,15325,15328,15344,15358,15371,15372,15382,15403,15408,15410,15414,15417,15427,15443,15475,15476,15483,15492,15495,15500,15520,15530,15533,15574,15577,15580,15594,15609,15632,15637,15639,15642,15651,15656,15733,15745,15762,15788,15796,15811,15832,15835,15839,15840,15850,15861,15878,15879,15945,15954,15972,16024,16031,16052,16055,16062,16071,16072,16115,16156,16161,16167,16176,16177,16197,16214,16217,16249,16261,16279,16284,16295,16328,16336,16347,16353,16359,16368,16370,16389,16404,16416,16421,16423,16436,16447,16450,16458,16497,16510,16518,16526,16537,16543,16566,16580,16613,16627,16633,16648,16659,16662,16682,16751,16763,16778,16792,16794,16800,16816,16820,16833,16847,16865,16866,16893,16908,16909,16950,16976,16997,17002,17069,17072,17080,17114,17148,17149,17158,17185,17187,17194,17214,17234,17247,17269,17276,17291,17304,17309,17334,17335,17346,17347,17379,17390,17419,17424,17427,17441,17452,17456,17458,17460,17485,17496,17498,17501,17508,17512,17528,17529,17536,17573,17574,17596,17607,17620,17629,17633,17640,17646,17649,17650,17662,17679,17701,17702,17705,17721,17733,17753,17759,17761,17772,17774,17783,17799,17816,17824,17844,17851,17857,17869,17881,17885,17888,17901,17918,17921,17947,17951,17960,17973,17988,18009,18032,18035,18044,18055,18071,18073,18077,18084,18102,18110,18122,18127,18151,18158,18160,18179,18212,18220,18221,18231,18234,18238,18247,18260,18264,18277,18284,18286,18300,18301,18307,18309,18315,18321,18327,18345,18352,18353,18360,18366,18380,18401,18433,18434,18435,18447,18490,18516,18520,18537,18547,18549,18558,18571,18578,18580,18591,18596,18626,18630,18643,18690,18732,18739,18744,18750,18751,18757,18770,18780,18792,18801,18804,18819,18821,18826,18846,18909,18916,18920,18936,18960,18972,18973,18977,18993,18994,18999,19027,19028,19052,19063,19106,19130,19134,19136,19151,19158,19172,19178,19179,19184,19191,19205,19219,19224,19241,19247,19270,19272,19282,19285,19309,19313,19325,19335,19352,19363,19370,19381,19389,19394,19405,19420,19422,19437,19445,19454,19457,19460,19492,19501,19520,19551,19555,19562,19574,19586,19604,19617,19619,19626,19650,19659,19661,19666,19668,19681,19684,19695,19697,19724,19731,19733,19748,19752,19760,19772,19778,19790,19806,19825,19834,19867,19874,19875,19886,19898,19923,19925,19931,19932,19937,19944,19945,19949,19957,19972,19980,19996,20003,20008,20035,20042,20053,20059,20060,20063,20067,20095,20098,20111,20117,20120,20158,20166,20192,20193,20195,20204,20205,20213,20233,20248,20250,20252,20256,20271,20275,20279,20282,20299,20305,20306,20308,20327,20328,20332,20333,20337,20341,20342,20344,20352,20359,20370,20399,20419,20420,20439,20443,20457,20459,20487,20489,20500,20537,20554,20567,20570,20590,20595,20608,20609,20613,20616,20617,20648,20659,20667,20675,20681,20699,20700,20712,20723,20727,20743,20768,20777,20780,20782,20800,20806,20838,20839,20841,20847,20848,20877,20886,20888,20912,20922,20945,20956,20966,20974,21006,21013,21016,21017,21038,21055,21062,21067,21085,21086,21097,21108,21115,21121,21128,21133,21149,21159,21163,21181,21188,21214,21229,21231,21256,21258,21266,21279,21283,21285,21288,21300,21321,21324,21338,21340,21368,21387,21393,21396,21457,21459,21464,21467,21482,21485,21486,21490,21508,21523,21524,21526,21529,21542,21547,21566,21618,21623,21628,21650,21653,21661,21664,21665,21672,21676,21683,21684,21689,21690,21695,21702,21704,21713,21716,21719,21721,21727,21735,21740,21742,21750,21774,21776,21800,21824,21843,21850,21853,21859,21870,21878,21910,21954,21955,21961,21967,21994,22005,22015,22018,22031,22041,22053,22062,22077,22082,22088,22117,22122,22132,22137,22163,22164,22175,22195,22217,22219,22241,22257,22263,22266,22292,22302,22316,22324,22380,22385,22406,22421,22446,22453,22460,22483,22485,22493,22498,22512,22518,22525,22546,22553,22572,22580,22603,22620,22622,22626,22647,22655,22658,22668,22671,22681,22691,22710,22717,22727,22736,22739,22744,22765,22779,22780,22786,22787,22795,22804,22822,22829,22833,22834,22857,22867,22873,22897,22898,22902,22918,22923,22936,22947,22972,22979,22998,23007,23013,23024,23026,23041,23043,23047,23062,23082,23089,23124,23129,23132,23168,23179,23181,23197,23202,23214,23224,23260,23278,23288,23298,23310,23319,23332,23338,23365,23400,23424,23428,23430,23439,23440,23451,23465,23468,23480,23516,23528,23543,23584,23598,23618,23624,23665,23666,23667,23675,23686,23705,23716,23722,23726,23731,23733,23756,23780,23817,23855,23871,23873,23876,23907,23911,23922,23926,23927,23962,23968,23989,24002,24016,24077,24082,24095,24114,24175,24184,24190,24193,24201,24210,24226,24249,24340,24361,24393,24408,24413,24432,24475,24478,24485,24522,24567,24582,24617,24630,24657,24671,24672,24673,24681,24703,24714,24734,24746,24763,24765,24790,24799,24803,24807,24836,24845,24887,24909,24922,24937,24945,24956,24967,24989,24993,25030,25035,25038,25041,25062,25103,25131,25137,25138,25146,25155,25163,25171,25200,25218,25221,25235,25258,25315,25318,25331,25336,25351,25353,25373,25380,25406,25415,25436,25448,25458,25461,25469,25474,25475,25483,25500,25513,25540,25542,25548,25554,25557,25578,25583,25584,25600,25646,25660,25663,25685,25687,25690,25694,25746,25751,25753,25790,25813,25822,25864,25891,25904,25910,25911,25952,25959,25981,26000,26033,26062,26073,26116,26139,26147,26157,26174,26188,26191,26204,26207,26209,26221,26225,26226,26236,26247,26259,26271,26317,26322,26340,26343,26344,26355,26360,26362,26369,26386,26387,26392,26395,26415,26420,26424,26432,26434,26452,26454,26474,26481,26509,26520,26522,26530,26560,26562,26594,26598,26630,26651,26659,26677,26680,26701,26713,26731,26742,26780,26801,26802,26820,26845,26881,26897,26905,26907,26924,26934,26936,26944,26973,26997,27000,27024,27028,27038,27040,27075,27085,27096,27127,27157,27158,27178,27183,27184,27199,27279,27317,27321,27340,27344,27354,27355,27366,27368,27390,27403,27420,27422,27437,27442,27458,27530,27563,27593,27616,27688,27722,27724,27739,27806,27808,27829,27846,27851,27883,27893,27898,27950,28022,28066,28072,28080,28116,28135,28185,28198,28213,28218,28242,28256,28264,28294,28339,28366,28413,28440,28442,28539,28545,28601,28609,28614,28615,28616,28617,28636,28651,28712,28714,28715,28728,28736,28845,28944,29002,29034,29054,29089,29101,29127,29229,29348,29381,29413,29440,29445,29460,29467,29499,29550,29551,29635,29658,29683,29715,29743,29788,29801,29837,29839,29872,29896,29897,29915,29918,30414,30470,30486,30700,30849,30941,30956,31090,31510,31640,31837,31868,32352,33385,33417,34150,34699,35095,35153,35330,35585,35713,35744,35750,35754,35778,35799,35865,35895,35955,36021,36051,36130,36141,36167,36196,36267,36292,36299,36323,36341,36591,36594,36598,36604,36769,36984,37083,37722,37723,38542,38563,38610,38613,38628,38652,38730,38777,38838,38855,38883,38887,38906,38946,38964,38971,39001,39014,39041,39126,39171,39210,39225,39301,39342,39398,39444,39483,39530,39571,39590,39682,39703,39720,39764,39790,39821,39846,39877,39916,39994,40036,40064,40240,40242,40270,40275,40385,40386,40387,40456,40492,40514,40521,40548,40605,40672,40742,40861,40909,40983,41027,41068,41104,41298,41442,42310,42547,42602,42843,42876,43018,43425,43426,44635,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 | 2219 | 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.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.39 ms |
System lock | 0.04 ms |
optimizing | 0.15 ms |
statistics | 3.28 ms |
preparing | 1.74 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 4.14 ms |
end | 0.07 ms |
query end | 0.15 ms |
closing tables | 0.08 ms |
freeing items | 0.18 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 |