Tiempo de la consulta: 5.63 ms Después de la última consulta: 1.27 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.395 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 20:08:00')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 20:08:00')
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(60,75,126,127,128,197,198,215,219,221,254,274,276,309,325,328,330,353,394,417,418,452,474,489,583,622,672,681,692,705,710,735,796,801,816,893,998,1207,1273,1291,1304,1317,1323,1325,1328,1352,1388,1389,1390,1394,1395,1412,1464,1475,1712,1718,1730,1731,1732,1734,1754,1797,1800,1839,1873,1880,1892,1952,1984,2027,2043,2048,2053,2065,2085,2086,2185,2211,2290,2293,2355,2388,2429,2433,2492,2520,2532,2580,2687,2689,2719,2825,2900,2971,2997,3000,3005,3017,3026,3035,3049,3067,3071,3095,3110,3144,3161,3188,3202,3208,3214,3216,3269,3318,3322,3323,3337,3398,3442,3484,3512,3517,3584,3591,3620,3640,3674,3709,3776,3795,3800,3833,3918,3953,3988,3991,4000,4105,4109,4127,4301,4381,4434,4458,4459,4538,4544,4580,4620,4767,4793,4801,4891,4930,4932,4955,4978,5000,5043,5045,5096,5098,5154,5190,5195,5220,5232,5243,5263,5301,5336,5357,5417,5433,5451,5525,5544,5563,5575,5582,5583,5586,5625,5637,5644,5646,5666,5678,5700,5702,5732,5758,5768,5777,5779,5780,5794,5795,5799,5804,5809,5831,5872,5908,5910,5919,5923,5924,5947,5950,5986,5989,5990,5991,5997,6000,6007,6011,6012,6016,6020,6022,6038,6073,6079,6083,6087,6107,6108,6110,6112,6115,6132,6138,6141,6183,6195,6220,6222,6237,6258,6261,6266,6312,6319,6355,6390,6420,6432,6439,6464,6476,6477,6504,6521,6531,6545,6548,6564,6583,6592,6596,6610,6611,6616,6659,6716,6719,6722,6733,6749,6766,6784,6848,6855,6886,6887,6945,7005,7032,7048,7065,7067,7098,7146,7172,7200,7484,7516,7520,7527,7529,7549,7550,7567,7576,7595,7604,7621,7714,7716,7759,7760,7792,7810,7811,7829,7853,7866,7902,7958,7967,7969,7984,7996,8009,8027,8035,8054,8062,8064,8078,8081,8083,8084,8088,8089,8095,8114,8164,8178,8218,8223,8240,8257,8261,8263,8356,8363,8374,8377,8415,8420,8461,8477,8521,8546,8550,8573,8590,8637,8647,8653,8662,8685,8689,8696,8723,8740,8756,8799,8818,8826,8841,8847,8848,8861,8875,8879,8917,8962,9023,9040,9057,9093,9118,9126,9131,9139,9142,9175,9181,9182,9184,9186,9188,9205,9206,9237,9251,9254,9277,9282,9307,9345,9357,9362,9387,9394,9404,9408,9430,9431,9509,9515,9516,9521,9540,9572,9576,9589,9597,9598,9613,9629,9642,9644,9660,9665,9680,9697,9702,9711,9729,9738,9799,9833,9850,9864,9872,9899,9932,9934,9970,9992,10060,10113,10120,10147,10180,10195,10213,10217,10228,10254,10274,10285,10361,10369,10402,10486,10516,10603,10655,10678,10708,10720,10778,10790,10848,10879,10971,11006,11022,11065,11131,11137,11138,11159,11238,11302,11305,11317,11328,11370,11407,11437,11455,11541,11559,11670,11706,11776,11781,11783,11868,11925,11927,11980,11989,12037,12077,12123,12146,12202,12217,12242,12248,12250,12263,12264,12265,12334,12372,12381,12426,12520,12568,12590,12655,12675,12746,12757,12788,12799,12806,12893,12896,12903,12922,12926,12939,12976,12993,13010,13013,13015,13023,13037,13062,13067,13073,13080,13081,13126,13128,13129,13139,13145,13164,13169,13186,13190,13203,13215,13230,13231,13232,13238,13248,13249,13263,13296,13297,13314,13325,13336,13343,13365,13383,13411,13415,13426,13432,13453,13456,13459,13481,13490,13558,13566,13590,13617,13625,13681,13682,13701,13703,13705,13706,13711,13721,13742,13754,13833,13851,13855,13856,13861,13875,13881,13883,13943,13972,13986,14012,14017,14034,14041,14057,14073,14087,14091,14163,14176,14177,14193,14199,14214,14242,14261,14268,14278,14288,14304,14338,14388,14398,14406,14427,14443,14461,14469,14478,14531,14549,14562,14563,14571,14574,14651,14655,14656,14671,14680,14725,14732,14747,14766,14778,14805,14810,14813,14818,14885,14888,14904,14914,14953,14970,14978,14981,15002,15046,15047,15054,15061,15066,15096,15138,15175,15185,15197,15218,15235,15244,15250,15262,15287,15289,15292,15298,15314,15315,15320,15324,15332,15340,15349,15356,15469,15470,15490,15532,15540,15547,15550,15566,15602,15606,15612,15623,15630,15642,15662,15666,15707,15709,15731,15732,15741,15749,15785,15806,15835,15840,15876,15899,15902,15910,15922,15925,15929,15937,15980,16003,16005,16011,16013,16015,16053,16074,16094,16102,16117,16123,16145,16164,16181,16202,16213,16219,16228,16240,16242,16262,16265,16279,16280,16316,16342,16346,16377,16383,16386,16402,16408,16417,16418,16422,16441,16448,16449,16464,16479,16497,16547,16585,16588,16589,16624,16648,16676,16732,16735,16758,16793,16795,16811,16813,16833,16834,16857,16897,16917,16924,16947,16995,17045,17064,17089,17107,17115,17132,17146,17150,17156,17160,17169,17172,17209,17255,17263,17270,17293,17346,17363,17371,17378,17393,17404,17411,17417,17420,17424,17436,17450,17462,17488,17489,17507,17513,17585,17591,17618,17620,17630,17651,17655,17680,17681,17684,17697,17698,17721,17724,17739,17788,17808,17812,17815,17826,17842,17843,17862,17884,17923,17948,17964,17976,17977,17998,18006,18022,18036,18038,18068,18102,18106,18138,18151,18182,18184,18234,18243,18245,18253,18285,18297,18347,18378,18383,18444,18473,18494,18517,18547,18564,18565,18572,18599,18638,18642,18655,18678,18686,18723,18755,18766,18771,18777,18778,18792,18793,18795,18817,18826,18829,18835,18838,18851,18853,18868,18874,18876,18891,18892,18905,18906,18907,18917,18925,18929,18931,18934,18938,18940,18945,18956,18972,18977,18992,19019,19036,19038,19046,19062,19082,19130,19157,19159,19160,19163,19164,19167,19197,19216,19238,19267,19275,19286,19293,19298,19328,19381,19398,19408,19409,19422,19428,19432,19436,19441,19466,19483,19484,19492,19516,19525,19548,19553,19557,19558,19575,19579,19585,19589,19592,19643,19644,19693,19701,19706,19708,19728,19740,19747,19755,19764,19766,19769,19796,19808,19809,19829,19842,19845,19857,19865,19879,19895,19924,19927,19952,19963,19967,19976,19989,19994,20009,20027,20038,20052,20062,20081,20093,20109,20120,20139,20150,20178,20191,20211,20212,20215,20227,20244,20273,20298,20307,20323,20326,20337,20347,20353,20378,20382,20395,20398,20401,20404,20436,20442,20475,20498,20502,20535,20536,20544,20572,20601,20616,20697,20713,20728,20733,20750,20754,20791,20792,20821,20830,20858,20864,20884,20917,20932,20934,20946,20949,20963,20966,20997,20999,21002,21006,21016,21027,21040,21041,21047,21048,21050,21069,21102,21104,21109,21129,21139,21159,21172,21176,21182,21185,21186,21195,21200,21231,21233,21241,21250,21262,21308,21313,21359,21362,21368,21414,21445,21472,21504,21522,21528,21535,21543,21554,21616,21632,21638,21640,21648,21653,21671,21703,21705,21715,21758,21762,21794,21821,21826,21830,21833,21851,21874,21897,21907,21978,22033,22064,22070,22084,22092,22103,22141,22165,22209,22215,22235,22236,22249,22250,22271,22275,22290,22311,22328,22353,22362,22365,22408,22411,22448,22484,22497,22498,22511,22512,22514,22530,22531,22540,22546,22549,22550,22551,22564,22578,22590,22591,22595,22610,22615,22637,22638,22642,22651,22665,22670,22685,22704,22716,22738,22759,22765,22768,22772,22782,22810,22811,22823,22824,22832,22846,22849,22850,22889,22909,22926,22927,22945,22982,22989,22998,23035,23038,23039,23061,23082,23094,23112,23114,23139,23142,23181,23194,23236,23256,23258,23302,23336,23354,23358,23359,23398,23402,23418,23419,23424,23425,23428,23429,23435,23440,23449,23450,23465,23472,23476,23485,23494,23508,23509,23511,23515,23516,23531,23532,23551,23556,23571,23584,23589,23590,23595,23611,23627,23666,23680,23683,23702,23708,23709,23732,23765,23777,23800,23809,23826,23842,23892,23912,23945,23978,23985,24014,24015,24022,24027,24041,24101,24105,24121,24125,24168,24177,24190,24199,24244,24270,24280,24286,24298,24303,24317,24333,24339,24382,24386,24387,24396,24406,24415,24424,24426,24431,24451,24486,24527,24537,24540,24545,24553,24554,24572,24614,24639,24650,24662,24664,24675,24691,24753,24774,24777,24796,24831,24839,24856,24941,24962,24971,24975,24981,24984,24987,25035,25042,25048,25049,25077,25083,25097,25118,25129,25142,25151,25153,25154,25157,25174,25180,25191,25198,25214,25257,25281,25287,25355,25361,25433,25456,25482,25526,25537,25548,25552,25558,25562,25592,25593,25610,25628,25700,25723,25752,25802,25809,25819,25842,25871,25909,26010,26014,26044,26049,26079,26102,26190,26234,26250,26262,26295,26317,26367,26460,26466,26530,26531,26543,26558,26597,26875,26965,26999,27010,27096,27108,27109,27110,27126,27137,27173,27192,27208,27209,27217,27223,27234,27249,27252,27307,27362,27398,27422,27441,27466,27470,27499,27770,27786,28004,28177,28188,28192,28250,28321,28325,28479,28596,28630,28664,28837,28851,28911,28925,29144,29231,29232,29343,29607,29873,30111,30234,30478,31060,31623,31624,33303,33476,33998,34114,34258,35333,35574,35637,36027,36079,37105,37107,37212,37237,37241,38000,38005,38238,38691,39067,39833,39891,40072,40328,40810,41074,41136,44318,44427)
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 | 1477 | 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.69 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.28 ms |
System lock | 0.02 ms |
optimizing | 0.12 ms |
statistics | 2.15 ms |
preparing | 1.14 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.35 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 |