Tiempo de la consulta: 11.65 ms Después de la última consulta: 1.25 ms Consulta a la memoria: 1.221 MB memoria antes de la consulta: 4.394 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-04 15:28:28')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 15:28:28')
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,9,13,30,36,38,51,60,66,78,81,82,94,117,120,126,167,180,183,184,197,201,216,265,304,305,306,316,317,328,340,350,354,368,377,385,390,393,407,463,470,487,493,495,515,519,549,584,592,593,621,635,693,728,731,740,741,742,791,806,825,841,855,881,891,902,908,931,935,954,955,963,964,965,972,978,1007,1017,1020,1029,1052,1067,1103,1137,1144,1152,1154,1168,1181,1187,1188,1206,1209,1229,1254,1257,1265,1280,1283,1287,1292,1293,1296,1298,1302,1306,1311,1313,1318,1336,1338,1344,1361,1364,1367,1380,1392,1402,1406,1413,1420,1421,1430,1433,1435,1441,1443,1455,1470,1478,1501,1506,1507,1524,1525,1531,1532,1535,1537,1546,1558,1568,1572,1598,1600,1603,1608,1610,1634,1640,1646,1681,1695,1706,1713,1719,1723,1726,1800,1802,1822,1823,1845,1869,1876,1879,1889,1898,1900,1905,1913,1932,1974,2009,2056,2096,2097,2104,2145,2175,2178,2194,2207,2209,2217,2229,2236,2245,2305,2314,2315,2316,2332,2333,2337,2342,2361,2373,2376,2378,2391,2400,2410,2424,2446,2453,2454,2459,2476,2481,2493,2503,2511,2516,2524,2539,2564,2579,2594,2598,2600,2601,2603,2613,2632,2636,2644,2668,2689,2695,2720,2728,2765,2805,2817,2830,2848,2895,2896,2920,2924,2926,2930,2931,2932,2936,2942,2977,2998,3047,3053,3063,3067,3073,3087,3112,3117,3126,3129,3137,3143,3153,3163,3171,3184,3187,3212,3216,3222,3235,3293,3307,3308,3309,3327,3337,3342,3347,3359,3366,3373,3382,3388,3408,3418,3419,3436,3457,3468,3486,3494,3529,3530,3532,3539,3546,3556,3558,3574,3575,3579,3582,3587,3602,3654,3657,3675,3709,3718,3719,3725,3796,3827,3840,3864,3871,3979,4015,4033,4074,4131,4153,4283,4309,4320,4335,4343,4473,4488,4525,4534,4631,4632,4654,4684,4688,4689,4691,4714,4718,4720,4721,4722,4770,4784,4808,4832,4841,4847,4871,4876,4902,4910,4917,4947,4949,4957,4971,4990,4999,5016,5020,5051,5086,5095,5099,5104,5140,5150,5162,5170,5173,5180,5237,5268,5323,5343,5354,5355,5378,5431,5456,5470,5554,5559,5566,5569,5572,5579,5588,5594,5596,5597,5614,5623,5632,5645,5650,5659,5662,5686,5722,5726,5727,5729,5747,5798,5814,5822,5845,5870,5959,6006,6010,6030,6039,6173,6217,6264,6268,6270,6272,6292,6348,6349,6354,6359,6363,6392,6445,6446,6568,6571,6675,6677,6745,6775,6830,6840,6910,6917,6975,6985,7056,7064,7082,7086,7096,7099,7110,7120,7148,7180,7181,7205,7212,7275,7299,7309,7318,7330,7334,7358,7396,7416,7454,7466,7482,7495,7526,7555,7622,7624,7659,7680,7719,7737,7745,7799,7813,7825,7837,7839,7860,7866,7868,7932,7946,7970,7998,8014,8026,8037,8039,8057,8061,8071,8090,8199,8229,8264,8272,8275,8276,8330,8339,8354,8416,8438,8451,8462,8498,8540,8569,8593,8598,8704,8773,8776,8781,8853,8972,8983,9012,9018,9027,9029,9148,9191,9196,9197,9201,9223,9300,9322,9330,9370,9440,9475,9481,9529,9650,9818,9839,9865,9869,9892,9920,9922,9942,10009,10022,10038,10047,10078,10079,10186,10229,10261,10299,10308,10340,10345,10348,10352,10376,10400,10595,10603,10604,10643,10665,10673,10708,10764,10775,10811,11030,11098,11104,11106,11107,11121,11241,11304,11305,11356,11439,11441,11603,11626,11627,11692,11722,11820,11859,11864,11967,11994,12060,12105,12113,12116,12128,12144,12181,12216,12219,12223,12225,12254,12385,12393,12541,12592,12595,12609,12620,12622,12623,12625,12630,12669,12705,12708,12717,12718,12752,12760,12812,12884,12894,12925,12945,12957,12997,13002,13010,13078,13187,13248,13268,13276,13284,13321,13328,13349,13352,13473,13501,13535,13575,13576,13685,13693,13727,13748,13750,13759,13782,13783,13846,13924,13941,13959,14005,14047,14048,14052,14122,14181,14204,14229,14293,14327,14350,14356,14430,14457,14468,14516,14524,14542,14570,14592,14648,14663,14679,14733,14819,14846,14852,14860,14862,14905,14906,14973,14987,15020,15045,15046,15166,15179,15208,15209,15234,15262,15293,15296,15298,15304,15310,15321,15372,15408,15495,15517,15528,15530,15540,15594,15651,15751,15753,15839,15850,15851,15870,15937,15938,15947,16057,16122,16214,16249,16347,16354,16370,16407,16421,16422,16423,16440,16455,16465,16509,16526,16537,16580,16610,16654,16728,16737,16763,16776,16790,16802,16834,16894,16954,17002,17067,17133,17136,17148,17185,17199,17291,17331,17334,17335,17343,17344,17369,17379,17391,17394,17409,17412,17458,17501,17529,17584,17590,17597,17603,17609,17635,17640,17646,17700,17799,17826,17851,17857,17862,17869,17902,17910,17921,17927,17947,17956,17960,17976,17977,18028,18029,18067,18079,18110,18122,18127,18158,18165,18170,18212,18227,18277,18284,18286,18301,18309,18321,18362,18380,18433,18473,18490,18516,18526,18549,18571,18580,18595,18630,18690,18698,18707,18770,18780,18825,18906,18907,18926,18958,18974,18994,18999,19024,19028,19052,19082,19115,19123,19127,19130,19153,19178,19184,19204,19211,19219,19232,19235,19299,19315,19325,19335,19353,19370,19373,19389,19423,19426,19432,19445,19454,19479,19484,19487,19492,19501,19555,19574,19617,19706,19731,19750,19796,19858,19876,19898,19959,19967,19972,19988,20003,20059,20065,20066,20067,20068,20111,20120,20173,20195,20248,20250,20252,20256,20271,20279,20309,20338,20396,20434,20437,20443,20461,20469,20500,20521,20565,20574,20590,20592,20609,20618,20642,20648,20667,20681,20688,20750,20751,20792,20800,20888,20945,20953,20990,21053,21087,21115,21163,21178,21198,21229,21259,21266,21321,21329,21332,21340,21393,21405,21459,21467,21487,21490,21508,21514,21537,21543,21547,21598,21602,21614,21624,21627,21681,21721,21722,21726,21735,21747,21769,21773,21774,21811,21824,21853,21870,21891,21901,21932,21961,22005,22054,22082,22129,22132,22134,22137,22175,22253,22257,22262,22267,22385,22453,22466,22481,22484,22494,22525,22581,22647,22736,22739,22781,22851,22869,22871,22886,22914,22925,22959,22964,22979,23036,23037,23041,23083,23099,23104,23119,23123,23132,23168,23184,23213,23229,23287,23309,23328,23332,23364,23381,23398,23452,23598,23675,23704,23722,23800,23817,23885,23888,23891,23897,23905,23907,23921,23922,23926,23964,24029,24067,24077,24163,24175,24193,24316,24337,24361,24413,24478,24485,24559,24617,24703,24781,24785,24799,24834,24871,24983,24989,25032,25038,25068,25201,25331,25336,25377,25450,25458,25475,25548,25557,25621,25622,25673,25685,25687,25690,25694,25717,25723,25729,25757,25818,25869,25891,25927,25928,25981,26000,26062,26066,26113,26153,26204,26226,26296,26335,26338,26369,26372,26386,26388,26509,26520,26530,26565,26576,26620,26630,26639,26646,26659,26680,26691,26699,26731,26784,26802,26820,26845,26879,26935,27059,27065,27183,27184,27199,27212,27216,27323,27347,27354,27367,27408,27423,27492,27541,27568,27570,27583,27592,27595,27601,27616,27671,27717,27758,27786,27806,27808,28031,28059,28066,28075,28094,28097,28114,28120,28129,28162,28168,28192,28218,28230,28243,28329,28366,28435,28593,28601,28636,28673,29002,29011,29045,29266,29639,29769,29856,29866,30486,31608,31640,32084,33417,33925,33946,33957,34025,34275,34331,34474,34475,34616,34646,34693,34699,34811,34815,35095,35153,35220,35227,35238,35239,35289,35376,35397,35426,35444,35490,35554,35556,35576,35585,35621,35688,35750,35778,35805,35806,35808,35865,35882,35948,36000,36015,36051,36130,36196,36220,36237,36267,36292,36299,36341,36368,36369,36373,36385,36420,36441,36584,36591,36594,36598,36604,36769,36930,36965,36989,36998,37010,37083,37136,37147,37283,37307,37308,37378,37534,37626,37644,37748,38058,38126,38133,38278,38330,38391,38402,38433,38453,38489,38546,38610,38613,38652,38777,38821,38824,38877,38904,38922,38946,38949,38971,39041,39171,39205,39225,39266,39290,39296,39476,39483,39497,39571,39579,39587,39590,39610,39682,39717,39719,39790,39815,39821,40319,40385,40386,40387,40456,40509,40560,40647,40742,40983,41062,41068,41151,41157,41189,41298,41328,41332,41345,41442,41516,41757,41781,41969,42123,42270,42310,42602,42637,42795,42843,42987,43016,43018,43109,43165,43237,43271,43405,43425,43426,43446,43461,43477,43483,43712,43808,43837,43964,44062,44366,44509,44573,44718,44788,44807,44829,44873,44906,44912,44935,44936,44988,45101,45138,45227,45235,45263,45264,45316)
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 | 1399 | 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.64 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.25 ms |
System lock | 0.02 ms |
optimizing | 0.09 ms |
statistics | 2.10 ms |
preparing | 1.05 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 5.92 ms |
end | 0.02 ms |
query end | 0.03 ms |
closing tables | 0.03 ms |
freeing items | 0.07 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 |