Tiempo de la consulta: 7.50 ms Después de la última consulta: 1.13 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.227 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-07 12:50:13')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 12:50:13')
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,14,15,16,17,25,29,33,43,48,49,57,67,72,83,109,127,131,136,137,165,178,179,195,239,241,255,275,278,281,294,316,335,344,358,362,368,372,373,374,380,398,411,436,446,488,522,549,569,572,581,593,607,619,621,723,724,728,735,737,744,752,755,756,757,766,771,784,804,812,816,825,853,871,872,878,894,899,900,916,928,931,952,955,963,972,978,980,987,1015,1018,1039,1046,1047,1053,1056,1080,1083,1090,1137,1140,1147,1154,1188,1200,1207,1210,1235,1238,1264,1287,1298,1302,1304,1306,1308,1313,1318,1336,1338,1344,1361,1364,1371,1380,1381,1383,1392,1406,1428,1430,1440,1443,1461,1470,1478,1504,1506,1525,1531,1532,1541,1556,1559,1572,1579,1596,1601,1621,1625,1649,1673,1690,1691,1695,1738,1751,1756,1760,1782,1823,1827,1873,1878,1938,1943,1954,1999,2000,2022,2082,2110,2115,2147,2184,2207,2311,2326,2332,2350,2356,2357,2425,2433,2447,2485,2489,2521,2530,2536,2540,2565,2566,2572,2579,2580,2583,2584,2595,2607,2610,2611,2621,2627,2650,2660,2667,2686,2720,2726,2728,2729,2733,2735,2740,2765,2766,2771,2787,2794,2798,2801,2822,2823,2836,2839,2845,2848,2870,2875,2894,2896,2899,2922,2939,2940,2943,2957,2970,2974,2975,2990,3022,3024,3033,3040,3065,3078,3097,3116,3117,3118,3129,3136,3162,3173,3175,3177,3215,3229,3257,3273,3290,3332,3350,3353,3393,3397,3443,3447,3448,3478,3506,3524,3549,3550,3551,3556,3567,3574,3589,3602,3603,3634,3759,3771,3773,3778,3785,3835,3838,3881,3885,3905,3915,3928,3930,3934,3951,3976,3977,3986,4001,4008,4013,4015,4019,4045,4062,4089,4091,4092,4111,4115,4128,4130,4154,4163,4164,4182,4203,4208,4235,4276,4305,4308,4357,4367,4368,4371,4377,4471,4515,4560,4627,4690,4693,4697,4710,4745,4758,4784,4792,4818,4819,4853,4856,4857,4896,4929,4949,4950,4973,4992,5018,5052,5053,5061,5063,5150,5175,5186,5233,5247,5265,5281,5284,5285,5305,5309,5349,5427,5476,5515,5555,5559,5561,5573,5633,5710,5729,5752,5827,5840,5894,5933,5965,5969,6024,6031,6047,6051,6062,6094,6121,6144,6145,6176,6203,6211,6215,6216,6267,6283,6284,6311,6317,6330,6403,6422,6438,6445,6453,6459,6482,6498,6501,6542,6543,6559,6567,6616,6619,6670,6742,6795,6802,6804,6825,6832,6837,6856,6899,6945,6976,6990,7002,7035,7121,7130,7175,7209,7217,7219,7225,7249,7253,7273,7330,7333,7352,7354,7374,7458,7464,7546,7554,7574,7575,7594,7598,7652,7656,7670,7678,7718,7726,7766,7806,7823,7849,7875,7950,7951,7961,7967,7970,8027,8037,8114,8120,8122,8138,8141,8169,8183,8189,8204,8205,8209,8210,8223,8228,8236,8238,8244,8245,8246,8247,8249,8275,8282,8301,8312,8315,8320,8321,8352,8355,8380,8394,8401,8412,8426,8427,8468,8471,8473,8487,8494,8499,8521,8537,8558,8560,8563,8565,8569,8571,8602,8614,8620,8626,8630,8725,8757,8759,8816,8838,8839,8840,8845,8877,8886,8888,8912,8921,8952,8983,8986,9010,9017,9047,9058,9103,9131,9136,9158,9164,9201,9203,9256,9342,9398,9401,9442,9480,9483,9487,9542,9564,9574,9575,9637,9686,9712,9723,9745,9749,9752,9818,9842,9864,9942,9949,9953,9986,9993,10017,10099,10103,10110,10120,10131,10141,10143,10144,10149,10165,10187,10204,10262,10275,10278,10280,10304,10307,10308,10315,10317,10340,10348,10375,10376,10388,10392,10403,10429,10471,10483,10491,10538,10561,10574,10596,10642,10645,10656,10673,10686,10695,10713,10769,10856,10860,10896,10912,10930,10938,10939,10948,10953,10962,10970,10975,10991,11037,11060,11074,11075,11076,11093,11112,11120,11142,11146,11152,11165,11174,11186,11234,11237,11241,11252,11255,11285,11292,11343,11361,11366,11371,11424,11434,11438,11491,11500,11574,11588,11595,11611,11626,11629,11648,11659,11661,11729,11730,11737,11738,11739,11741,11789,11800,11843,11844,11889,11920,11938,11967,11974,11988,11996,12002,12081,12082,12094,12118,12161,12179,12212,12218,12219,12223,12283,12326,12339,12356,12364,12384,12393,12434,12480,12511,12513,12526,12548,12556,12576,12630,12648,12684,12703,12752,12758,12761,12811,12852,12887,12902,12940,12959,12962,13002,13056,13079,13110,13115,13125,13150,13152,13153,13188,13207,13217,13308,13367,13377,13433,13476,13494,13554,13585,13613,13671,13685,13731,13734,13791,13869,13900,13994,14002,14005,14038,14070,14101,14104,14113,14175,14204,14227,14229,14249,14270,14287,14293,14305,14331,14341,14382,14386,14445,14457,14468,14470,14482,14495,14522,14537,14540,14608,14610,14612,14642,14643,14647,14730,14746,14791,14793,14807,14811,14846,14847,14850,14871,14873,14915,14931,14956,14960,14981,14993,15003,15069,15100,15117,15119,15162,15177,15200,15236,15248,15293,15305,15328,15400,15501,15512,15518,15522,15543,15596,15608,15678,15689,15728,15742,15755,15778,15791,15888,16001,16066,16163,16197,16209,16313,16356,16358,16365,16370,16423,16439,16446,16447,16450,16451,16494,16564,16565,16580,16604,16622,16644,16645,16685,16721,16754,16806,16814,16815,16816,16818,16831,16844,16854,16865,16866,16898,16935,16985,17011,17047,17069,17090,17108,17132,17143,17146,17169,17190,17194,17207,17234,17247,17291,17292,17376,17407,17410,17417,17430,17452,17456,17487,17514,17518,17536,17537,17551,17552,17588,17630,17662,17687,17725,17734,17753,17766,17838,17839,17845,17880,17887,17896,17925,17988,17989,17990,18000,18032,18060,18084,18088,18115,18136,18139,18159,18186,18247,18264,18277,18291,18304,18311,18351,18364,18375,18390,18433,18447,18490,18524,18571,18583,18596,18626,18690,18708,18716,18739,18751,18770,18780,18793,18801,18881,18882,18899,18909,18916,18952,18957,18971,18989,19017,19031,19043,19114,19119,19131,19133,19134,19145,19147,19192,19216,19221,19247,19260,19311,19330,19339,19367,19370,19413,19420,19429,19520,19586,19644,19659,19681,19700,19741,19758,19760,19764,19834,19875,19880,19881,19883,19913,19949,20016,20041,20042,20045,20056,20064,20067,20087,20095,20111,20156,20158,20170,20223,20239,20248,20270,20300,20326,20327,20345,20355,20362,20402,20420,20450,20457,20483,20570,20586,20613,20614,20627,20644,20654,20665,20681,20705,20807,20820,20848,20854,20878,20888,20897,20898,20941,20967,20983,21046,21115,21188,21218,21226,21240,21255,21307,21376,21390,21449,21628,21653,21676,21689,21707,21716,21720,21740,21756,21866,21870,21899,21956,21961,21964,22071,22075,22096,22100,22132,22138,22198,22217,22316,22344,22445,22496,22500,22509,22525,22572,22619,22623,22654,22669,22689,22731,22732,22741,22750,22795,22853,22856,22867,22916,22917,22930,22936,23057,23078,23100,23130,23168,23176,23197,23228,23249,23259,23298,23332,23377,23414,23424,23431,23440,23465,23598,23618,23627,23649,23657,23726,23728,23741,23767,23801,23815,23873,23882,23884,23964,23973,24032,24077,24095,24100,24143,24182,24184,24200,24241,24322,24337,24368,24413,24489,24495,24556,24619,24620,24695,24737,24746,24876,24884,24909,24912,24931,24982,24998,25004,25048,25109,25122,25123,25135,25178,25212,25235,25342,25397,25415,25441,25460,25500,25548,25694,25709,25854,25856,25959,26038,26048,26116,26188,26288,26298,26340,26395,26573,26595,26620,26659,26760,26771,26818,26915,26963,26978,27138,27178,27184,27317,27321,27412,27424,27563,27592,27593,27790,27898,27931,27949,27968,28005,28198,28313,28323,28330,28413,28438,28545,28548,28557,28563,28575,28581,28630,28917,29101,29141,29194,29319,29382,29504,29694,29695,29711,29715,29743,30700,32352,32993,35000,35135,35366,35588,35834,35857,35886,35891,35922,35923,35972,36364,36707,36836,37576,37851,38542,38563,38628,38855,38901,39112,39483,39558,39698,39773,40270,40483,40548,40789,40810,40813,40835,40922,41025,42284,42494,42833,43360,43543,44204,45141,45240,45252)
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 | 1329 | 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.96 ms |
checking permissions | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.25 ms |
System lock | 0.02 ms |
optimizing | 0.13 ms |
statistics | 3.06 ms |
preparing | 1.69 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.53 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.06 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 |