Tiempo de la consulta: 5.56 ms Después de la última consulta: 1.25 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.253 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 09:48:08')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 09:48:08')
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(138,177,196,198,215,218,219,220,221,237,254,276,309,325,328,330,385,394,406,417,418,424,452,489,494,497,520,614,642,647,659,681,733,737,746,771,802,845,864,872,889,894,909,910,928,943,1062,1071,1132,1174,1190,1210,1252,1253,1297,1325,1328,1352,1355,1388,1389,1390,1394,1403,1412,1464,1465,1475,1712,1754,1797,1800,1839,1907,1952,1971,1973,2032,2048,2053,2085,2086,2124,2167,2185,2331,2355,2429,2520,2532,2580,2617,2687,2689,2706,2719,2790,2825,2900,3017,3026,3027,3060,3067,3082,3144,3188,3224,3240,3244,3269,3317,3318,3323,3330,3337,3398,3424,3444,3512,3517,3573,3674,3709,3776,3792,3832,3833,3905,3943,3991,4000,4008,4029,4035,4084,4109,4127,4224,4234,4235,4273,4301,4313,4331,4332,4361,4362,4364,4391,4444,4456,4538,4560,4580,4620,4732,4752,4835,4880,4955,5000,5037,5043,5045,5074,5096,5101,5154,5190,5195,5220,5243,5263,5269,5301,5357,5390,5417,5423,5544,5582,5583,5637,5644,5646,5648,5666,5678,5702,5732,5768,5777,5779,5794,5795,5803,5804,5831,5834,5859,5910,5919,5923,5997,6000,6007,6009,6011,6016,6022,6087,6110,6112,6160,6183,6220,6233,6237,6258,6261,6266,6312,6355,6390,6420,6429,6476,6477,6564,6596,6677,6716,6733,6749,6758,6766,6848,6855,6885,6941,7022,7032,7037,7048,7067,7202,7242,7278,7297,7303,7527,7549,7576,7580,7581,7595,7625,7673,7699,7710,7716,7760,7778,7811,7838,7853,7902,7958,7969,8009,8062,8064,8077,8078,8081,8084,8095,8105,8164,8178,8218,8240,8303,8356,8374,8417,8420,8443,8461,8512,8546,8573,8637,8788,8826,8861,8875,9004,9011,9051,9057,9093,9139,9175,9182,9184,9186,9237,9251,9254,9277,9307,9357,9362,9369,9394,9408,9410,9430,9431,9509,9516,9521,9540,9572,9576,9589,9629,9644,9660,9663,9666,9697,9711,9729,9850,9864,9899,9932,9934,9970,9992,9999,10046,10113,10140,10213,10361,10426,10467,10603,10677,10708,10720,11040,11080,11131,11137,11240,11302,11549,11552,11559,11669,11681,11706,11853,11880,12000,12020,12217,12242,12250,12334,12426,12439,12458,12520,12568,12590,12668,12746,12788,12799,12806,12949,12974,12998,13010,13013,13037,13062,13083,13126,13169,13186,13215,13238,13249,13263,13264,13325,13358,13365,13383,13415,13426,13432,13436,13453,13459,13481,13558,13566,13579,13590,13612,13625,13728,13822,13833,13875,13881,13986,13987,14047,14134,14159,14177,14193,14211,14261,14263,14337,14388,14461,14571,14651,14680,14700,14725,14805,14810,14818,14885,14904,14914,14927,14928,14941,14953,14978,14997,15054,15091,15096,15138,15181,15188,15235,15244,15261,15292,15340,15469,15490,15537,15540,15547,15550,15602,15612,15615,15623,15630,15662,15666,15685,15707,15762,15785,15806,15835,15840,15859,15902,15922,15925,15927,15937,16005,16013,16015,16074,16102,16117,16127,16142,16162,16213,16219,16228,16242,16260,16262,16265,16279,16316,16318,16346,16386,16402,16417,16422,16479,16547,16588,16641,16833,16834,16846,16908,16916,16917,16924,16936,16940,16944,16947,16968,16969,17045,17054,17063,17134,17136,17137,17160,17162,17172,17203,17206,17217,17268,17371,17372,17400,17416,17455,17480,17535,17629,17643,17644,17645,17680,17683,17699,17721,17750,17785,17798,17799,17826,17862,17886,17940,17946,17965,17976,17977,17991,18006,18021,18022,18035,18036,18040,18068,18076,18106,18151,18168,18171,18184,18191,18235,18241,18253,18259,18297,18308,18312,18347,18354,18378,18413,18422,18426,18444,18460,18473,18489,18491,18497,18500,18534,18535,18540,18542,18547,18572,18575,18599,18635,18638,18642,18655,18746,18747,18751,18766,18790,18792,18795,18803,18828,18835,18851,18853,18868,18874,18911,18917,18918,18923,18931,18934,18950,18954,18956,18973,18977,18980,19005,19038,19044,19062,19079,19082,19113,19130,19155,19156,19160,19164,19172,19197,19267,19275,19288,19301,19310,19320,19365,19390,19400,19432,19481,19484,19493,19495,19531,19561,19573,19592,19594,19618,19641,19678,19684,19696,19700,19706,19710,19723,19728,19742,19745,19751,19766,19778,19796,19824,19832,19835,19865,19876,19900,19924,19927,19938,19939,19950,19976,19982,19988,19989,20017,20038,20052,20062,20080,20120,20129,20150,20176,20177,20187,20188,20191,20193,20211,20212,20213,20235,20264,20267,20277,20298,20307,20310,20337,20340,20343,20387,20391,20401,20410,20421,20442,20481,20484,20502,20550,20567,20570,20572,20575,20616,20624,20630,20650,20689,20697,20705,20709,20713,20714,20727,20733,20740,20750,20752,20754,20792,20808,20813,20821,20830,20858,20865,20871,20881,20907,20910,20917,20920,20925,20932,20949,20954,20963,20966,20973,20990,20997,20999,21002,21006,21012,21021,21027,21033,21040,21041,21042,21047,21049,21050,21059,21069,21070,21080,21090,21102,21104,21107,21114,21132,21134,21159,21169,21172,21185,21195,21204,21221,21233,21241,21250,21261,21262,21273,21282,21288,21291,21311,21313,21342,21361,21368,21383,21397,21410,21445,21466,21472,21474,21485,21486,21491,21504,21539,21543,21547,21559,21560,21563,21574,21581,21618,21632,21640,21641,21647,21648,21650,21660,21670,21683,21688,21690,21691,21699,21703,21705,21738,21756,21764,21800,21810,21837,21844,21848,21853,21902,21907,21926,21929,21960,21976,21977,21985,21986,22015,22017,22034,22037,22050,22073,22081,22085,22103,22112,22131,22158,22161,22162,22164,22204,22235,22236,22242,22249,22265,22278,22279,22281,22285,22292,22300,22305,22321,22323,22353,22394,22405,22408,22411,22484,22498,22502,22511,22512,22514,22522,22530,22531,22540,22544,22545,22550,22564,22590,22591,22595,22606,22615,22646,22658,22665,22707,22716,22737,22738,22745,22757,22758,22759,22765,22767,22768,22772,22816,22838,22860,22889,22894,22909,22968,22970,22971,22989,22991,22997,23003,23017,23035,23051,23063,23070,23082,23084,23085,23094,23095,23097,23117,23132,23135,23136,23164,23181,23192,23194,23201,23216,23217,23230,23236,23239,23256,23257,23258,23268,23280,23285,23295,23302,23317,23320,23336,23345,23348,23349,23351,23352,23354,23358,23359,23379,23383,23396,23398,23418,23420,23424,23429,23434,23435,23440,23449,23460,23465,23476,23483,23512,23516,23528,23532,23556,23560,23561,23571,23582,23605,23609,23627,23631,23645,23649,23662,23680,23681,23685,23708,23712,23765,23772,23800,23803,23805,23806,23809,23811,23813,23814,23826,23847,23851,23854,23878,23894,23945,23951,23953,23961,23963,23975,23979,23999,24011,24027,24029,24045,24055,24087,24101,24112,24120,24125,24127,24139,24151,24155,24165,24168,24169,24177,24189,24199,24203,24204,24206,24209,24213,24223,24234,24244,24245,24246,24248,24251,24286,24303,24307,24333,24385,24386,24387,24401,24406,24410,24414,24425,24426,24483,24502,24508,24513,24540,24545,24549,24560,24572,24575,24580,24583,24628,24644,24651,24662,24681,24694,24719,24730,24743,24750,24783,24787,24796,24800,24805,24824,24848,24861,24865,24875,24877,24878,24896,24925,24941,24962,24966,24967,24969,24973,24975,24977,24981,24984,25021,25025,25031,25035,25042,25053,25057,25061,25083,25089,25097,25118,25127,25129,25142,25151,25157,25171,25180,25210,25214,25243,25253,25257,25287,25296,25351,25355,25369,25372,25378,25396,25399,25407,25424,25436,25440,25444,25456,25458,25460,25507,25517,25520,25523,25524,25525,25528,25536,25537,25541,25548,25551,25552,25558,25568,25582,25591,25596,25610,25626,25628,25649,25670,25695,25702,25775,25779,25781,25809,25819,25844,25845,25863,25865,25874,25890,25906,25941,25962,25983,26010,26014,26019,26033,26044,26049,26056,26080,26082,26147,26164,26172,26201,26234,26241,26271,26283,26296,26318,26320,26334,26337,26351,26354,26362,26366,26367,26379,26405,26466,26473,26489,26588,26597,26613,26694,26734,26796,26814,26999,27048,27108,27109,27119,27124,27126,27137,27139,27156,27192,27206,27209,27242,27252,27302,27307,27312,27313,27330,27362,27425,27466,27470,27551,27622,27694,27744,27786,27803,27806,27818,27860,27875,27958,28030,28117,28281,28325,28328,28429,28453,28458,28504,28555,28683,28691,28703,28733,28880,28882,28886,28898,28911,29108,29159,29164,29298,29320,29589,29619,29621,30111,30478,30605,30606,31055,31623,31624,31629,31703,32115,32679,32697,33416,33998,34177,34195,34205,34220,34258,34417,34489,34639,34690,34881,34888,35127,35300,35333,35368,35428,35657,35776,35862,35936,35959,36004,36079,36109,36117,36254,36298,36499,36813,36948,36990,37802,38000,38691,38763,38961,39726,39984,39997,40072,40370,40533,41025,41074,41089,41185,41351,41868,42702,42899,42900,42908,43581,43906,44384,44509,44682,44734,44830,45124)
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 | 1420 | 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.71 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.29 ms |
System lock | 0.02 ms |
optimizing | 0.10 ms |
statistics | 2.14 ms |
preparing | 1.08 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.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 |