Tiempo de la consulta: 16.11 ms Después de la última consulta: 1.28 ms Consulta a la memoria: 1.072 MB memoria antes de la consulta: 4.251 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 06:23:47')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 06:23:47')
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(10,13,30,47,51,69,82,183,184,197,203,205,207,208,219,289,328,350,368,393,407,634,693,794,902,926,935,971,981,1024,1198,1280,1284,1291,1324,1338,1345,1354,1398,1413,1431,1455,1459,1486,1490,1504,1506,1535,1600,1601,1603,1634,1646,1800,1802,1804,1815,1822,1900,1913,1943,1956,2066,2123,2210,2217,2228,2260,2305,2337,2378,2379,2424,2509,2598,2600,2601,2632,2636,2668,2689,2818,2828,2952,2967,3055,3067,3070,3076,3087,3211,3212,3312,3327,3337,3373,3382,3385,3390,3408,3410,3439,3448,3490,3572,3663,3718,3719,3725,3757,3772,3826,3871,3916,4015,4039,4055,4060,4063,4087,4092,4144,4153,4163,4165,4177,4203,4276,4320,4389,4395,4457,4473,4496,4511,4549,4559,4602,4660,4760,4773,4832,4910,4912,4947,4949,4957,4983,4990,5008,5040,5050,5100,5104,5150,5161,5170,5173,5203,5218,5224,5239,5240,5301,5350,5428,5432,5462,5559,5633,5686,5725,5788,5931,5973,5979,6039,6043,6074,6081,6116,6131,6177,6192,6264,6270,6291,6307,6350,6374,6428,6435,6456,6462,6471,6473,6494,6495,6497,6499,6515,6520,6521,6534,6571,6576,6578,6598,6601,6603,6609,6636,6655,6656,6657,6659,6662,6665,6695,6711,6724,6725,6734,6764,6770,6775,6789,6790,6805,6809,6830,6838,6843,6869,6871,6873,6875,6876,6879,6903,6904,6910,6914,6917,6919,6925,6927,6928,6940,6945,6956,6957,6968,6985,6986,6990,6992,6994,7001,7009,7011,7016,7020,7045,7059,7100,7102,7248,7271,7309,7311,7313,7314,7330,7389,7397,7416,7431,7432,7443,7449,7453,7478,7484,7488,7494,7516,7523,7526,7542,7547,7548,7571,7578,7585,7586,7616,7618,7623,7624,7626,7659,7675,7677,7683,7711,7722,7726,7728,7737,7745,7773,7774,7787,7794,7797,7808,7832,7841,7866,7877,7913,7933,7999,8000,8026,8036,8039,8057,8062,8071,8088,8103,8106,8116,8135,8141,8157,8198,8199,8200,8222,8250,8272,8298,8323,8330,8334,8345,8348,8354,8399,8416,8452,8462,8489,8510,8532,8559,8598,8603,8608,8619,8639,8641,8649,8655,8658,8665,8700,8702,8706,8738,8755,8761,8764,8765,8770,8794,8823,8828,8829,8856,8871,8926,8953,8964,8973,8982,9012,9018,9020,9041,9058,9065,9068,9101,9127,9128,9147,9192,9196,9197,9239,9260,9300,9308,9355,9367,9370,9406,9476,9489,9514,9542,9552,9556,9558,9561,9565,9569,9592,9594,9602,9714,9724,9730,9762,9783,9794,9843,9865,9869,9893,9896,9910,9911,9919,9941,9951,9961,9983,10017,10083,10100,10118,10149,10184,10186,10192,10208,10209,10221,10260,10264,10291,10297,10301,10322,10332,10352,10395,10398,10400,10436,10450,10464,10473,10475,10480,10482,10485,10543,10603,10604,10613,10629,10631,10645,10646,10650,10660,10663,10681,10692,10710,10754,10764,10811,10941,10969,11041,11065,11098,11106,11107,11121,11151,11163,11209,11226,11229,11235,11258,11289,11295,11305,11356,11416,11505,11820,11859,11864,11867,11875,11904,11907,11934,11994,12002,12046,12113,12144,12216,12224,12254,12412,12437,12541,12609,12651,12652,12669,12743,12841,12857,13090,13187,13268,13290,13321,13352,13430,13455,13474,13505,13506,13528,13535,13552,13575,13576,13588,13671,13693,13727,13750,13777,13782,13800,13846,13858,13884,13917,13924,13941,14052,14092,14095,14108,14110,14118,14122,14142,14146,14189,14195,14196,14224,14234,14240,14244,14261,14276,14318,14327,14353,14356,14367,14373,14383,14430,14440,14445,14448,14524,14528,14533,14622,14648,14663,14669,14679,14681,14688,14701,14703,14709,14726,14733,14744,14745,14748,14750,14762,14765,14773,14790,14792,14794,14827,14842,14849,14860,14870,14871,14899,14905,14943,14949,14973,14992,15005,15020,15033,15045,15046,15048,15049,15107,15108,15116,15166,15178,15179,15208,15209,15232,15234,15247,15251,15262,15293,15298,15302,15304,15319,15327,15333,15335,15338,15365,15366,15390,15432,15438,15453,15482,15500,15503,15517,15521,15528,15533,15542,15560,15578,15594,15628,15631,15647,15655,15669,15678,15693,15705,15720,15723,15725,15746,15751,15753,15761,15770,15777,15780,15784,15808,15813,15840,15868,15870,15874,15878,15896,15912,15928,15931,15937,15938,15947,15954,15993,16008,16028,16036,16048,16057,16115,16141,16146,16169,16181,16231,16233,16264,16286,16288,16324,16354,16372,16378,16389,16415,16422,16440,16455,16461,16465,16471,16475,16515,16559,16653,16654,16666,16737,16768,16770,16787,16802,16822,16850,16862,16886,16894,16900,16958,16967,16982,17096,17101,17126,17160,17161,17190,17199,17214,17227,17228,17243,17275,17277,17299,17334,17335,17337,17344,17369,17396,17409,17412,17437,17482,17531,17573,17583,17590,17602,17603,17609,17619,17634,17652,17668,17700,17706,17707,17709,17716,17718,17726,17738,17756,17778,17809,17810,17817,17826,17857,17862,17869,17888,17923,17927,17947,17956,18028,18029,18067,18165,18170,18227,18248,18356,18362,18377,18404,18451,18473,18505,18518,18530,18537,18541,18550,18566,18603,18610,18619,18694,18707,18753,18775,18786,18801,18825,18832,18852,18861,18869,18872,18878,18888,18906,18907,18912,18926,18929,18940,18941,18948,18958,18966,18972,18985,18987,19003,19007,19024,19034,19061,19076,19100,19123,19127,19153,19173,19175,19204,19211,19219,19232,19235,19245,19268,19290,19299,19318,19322,19351,19353,19358,19382,19423,19432,19472,19479,19484,19503,19507,19519,19528,19566,19575,19591,19645,19646,19674,19750,19757,19787,19792,19858,19866,19876,19884,19906,19934,19935,19943,19967,19970,19974,19988,20000,20020,20131,20279,20281,20309,20399,20408,20437,20441,20469,20472,20504,20527,20538,20541,20565,20574,20580,20584,20592,20618,20641,20642,20648,20658,20684,20711,20716,20729,20730,20731,20739,20750,20753,20776,20780,20787,20788,20792,20797,20866,21012,21053,21063,21105,21198,21209,21259,21262,21296,21312,21323,21329,21343,21351,21405,21413,21425,21429,21436,21547,21566,21578,21585,21598,21602,21610,21614,21627,21636,21700,21703,21718,21722,21726,21734,21747,21769,21773,21811,21824,21850,21871,21886,21891,21900,21932,21946,22002,22051,22124,22129,22134,22214,22243,22247,22262,22267,22292,22296,22305,22326,22339,22365,22439,22446,22453,22466,22481,22484,22494,22509,22558,22564,22577,22581,22608,22682,22690,22725,22739,22781,22807,22854,22869,22871,22886,22946,22964,22988,23033,23036,23037,23079,23099,23104,23119,23123,23157,23184,23203,23207,23209,23213,23229,23265,23273,23287,23299,23328,23364,23381,23396,23425,23459,23493,23512,23602,23606,23626,23670,23685,23686,23720,23759,23831,23858,23885,23887,23888,23891,23897,23898,23905,23921,23964,23968,23989,24007,24008,24020,24043,24061,24077,24124,24163,24196,24202,24238,24281,24316,24334,24337,24348,24352,24399,24429,24463,24485,24525,24539,24566,24617,24639,24679,24743,24775,24781,24782,24785,24788,24794,24867,24871,24906,24924,24952,24956,24983,25032,25037,25046,25068,25095,25123,25139,25144,25194,25197,25198,25201,25208,25224,25263,25269,25318,25377,25412,25418,25450,25451,25478,25516,25531,25538,25548,25554,25556,25563,25590,25621,25622,25648,25723,25734,25757,25771,25817,25818,25888,25927,25928,26000,26055,26066,26113,26131,26159,26234,26249,26296,26344,26346,26366,26372,26386,26388,26414,26565,26576,26620,26639,26646,26685,26691,26756,26802,26815,26820,26827,26845,26861,26916,26933,26935,26936,26944,26964,26986,27059,27065,27086,27103,27128,27139,27171,27196,27209,27212,27216,27220,27252,27268,27269,27270,27298,27323,27347,27365,27367,27404,27405,27408,27423,27487,27541,27567,27583,27592,27595,27601,27655,27656,27663,27671,27683,27692,27695,27717,27758,27786,27887,27903,27999,28031,28059,28066,28067,28075,28094,28097,28114,28120,28129,28162,28168,28192,28230,28243,28435,28530,28673,28718,28826,28973,28984,28992,29004,29005,29008,29011,29021,29034,29037,29045,29229,29266,29272,29489,29639,29694,29716,29769,29810,29866,29873,29883,30266,30525,31510,31608,31735,32084,32182,32767,33099,33908,33925,33946,33957,34025,34239,34275,34331,34616,34646,34693,34811,34815,35220,35227,35238,35239,35289,35376,35397,35426,35444,35490,35554,35556,35621,35637,35688,35722,35740,35805,35882,35948,36000,36015,36220,36237,36337,36368,36369,36373,36385,36420,36441,36584,36930,36989,36998,37010,37136,37147,37283,37307,37308,37378,37534,37626,37644,38058,38126,38133,38167,38330,38433,38489,38546,38824,38877,38904,38922,38949,39205,39290,39296,39451,39476,39497,39587,39610,39717,40198,40319,40509,40560,40583,40647,40875,41062,41283,41332,41345,41516,41781,41969,42209,42637,42987,43016,43109,43165,43237,43271,43405,43446,43461,43483,43712,44062,44366,44573,44718,44788,44807,44829,44873,44912,44935,44936,44988,45101,45138,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 | 1447 | 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.93 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.22 ms |
statistics | 3.04 ms |
preparing | 1.60 ms |
Sorting result | 0.05 ms |
executing | 0.01 ms |
Sending data | 8.90 ms |
end | 0.06 ms |
query end | 0.04 ms |
closing tables | 0.13 ms |
freeing items | 0.09 ms |
cleaning up | 0.04 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 |