Tiempo de la consulta: 5.64 ms Después de la última consulta: 1.50 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.422 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 05:27:07')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 05:27:07')
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,9,10,11,12,13,14,15,16,17,18,25,70,71,72,73,75,119,126,127,128,174,185,197,255,263,271,272,275,283,294,323,353,356,400,403,429,481,495,583,607,611,657,667,680,689,705,722,724,726,735,787,801,808,816,832,860,863,868,892,895,917,927,937,940,973,1074,1078,1101,1102,1124,1140,1183,1198,1207,1216,1226,1233,1241,1250,1319,1363,1458,1459,1469,1505,1519,1684,1697,1735,1745,1803,1823,1845,1853,1854,1883,1887,1975,2016,2069,2092,2101,2150,2181,2195,2254,2290,2293,2305,2371,2442,2517,2605,2674,2797,2804,2817,2884,2886,2887,2924,2944,2967,3001,3065,3111,3140,3154,3168,3183,3191,3207,3276,3291,3303,3306,3312,3343,3346,3376,3393,3406,3442,3445,3452,3491,3493,3522,3548,3569,3591,3597,3604,3620,3668,3700,3732,3750,3754,3862,3880,3898,3918,3983,3986,4114,4141,4209,4258,4459,4492,4625,4651,4739,4767,4813,4870,4920,4932,4973,5019,5079,5093,5095,5123,5136,5150,5154,5244,5247,5266,5365,5438,5450,5451,5513,5542,5647,5686,5689,5711,5894,5924,6068,6072,6102,6119,6141,6257,6278,6279,6294,6301,6315,6339,6354,6363,6372,6393,6400,6415,6463,6471,6475,6476,6477,6495,6534,6542,6543,6545,6548,6583,6593,6605,6616,6639,6643,6678,6727,6744,6807,6808,6840,6842,6888,6889,6918,6936,6945,6964,6997,7005,7018,7026,7156,7185,7248,7337,7412,7417,7457,7463,7484,7489,7492,7516,7517,7569,7583,7630,7683,7690,7718,7741,7749,7806,7829,7837,7847,7917,7934,7950,7955,7962,7964,7965,7987,7998,8024,8026,8027,8074,8088,8206,8223,8260,8281,8381,8460,8565,8615,8689,8740,8759,8780,8860,8861,8907,8916,8917,8929,8932,8937,8967,9010,9018,9048,9056,9057,9073,9082,9152,9181,9200,9237,9314,9351,9398,9412,9495,9627,9658,9704,9745,9764,9820,9825,9853,9858,9864,9927,10022,10026,10059,10120,10180,10195,10216,10228,10268,10273,10274,10278,10304,10328,10364,10369,10384,10412,10414,10435,10459,10462,10559,10628,10659,10696,10757,10894,10912,10924,10925,10971,10973,10978,10982,10990,11003,11022,11032,11065,11073,11080,11083,11091,11092,11108,11113,11122,11127,11138,11143,11150,11157,11195,11224,11264,11277,11308,11309,11318,11328,11370,11383,11407,11410,11438,11497,11534,11554,11585,11587,11614,11721,11727,11730,11839,11848,11854,11915,11944,11987,12018,12038,12040,12053,12091,12098,12108,12109,12115,12133,12193,12218,12248,12306,12307,12318,12393,12400,12410,12415,12449,12554,12557,12576,12672,12673,12684,12717,12723,12735,12761,12808,12834,12848,12868,12903,12916,12991,13029,13075,13081,13129,13140,13141,13159,13166,13172,13188,13190,13198,13231,13331,13346,13384,13418,13425,13456,13524,13530,13543,13548,13550,13573,13595,13600,13611,13627,13641,13646,13671,13675,13677,13695,13697,13703,13705,13706,13707,13712,13713,13715,13731,13741,13742,13763,13788,13821,13838,13855,13869,13883,13920,13933,13950,13951,13972,14057,14073,14080,14081,14097,14101,14104,14114,14140,14141,14148,14150,14159,14188,14196,14197,14222,14227,14236,14249,14267,14278,14281,14282,14286,14314,14331,14385,14428,14452,14469,14471,14486,14495,14563,14572,14574,14616,14632,14657,14675,14684,14694,14711,14732,14746,14747,14769,14770,14796,14799,14807,14827,14842,14846,14856,14865,14931,14932,14960,14980,14981,14993,15006,15018,15038,15049,15069,15100,15146,15175,15206,15215,15243,15245,15248,15251,15277,15303,15330,15343,15349,15356,15389,15411,15414,15470,15475,15496,15497,15513,15522,15524,15565,15576,15588,15606,15631,15633,15641,15668,15689,15719,15731,15750,15789,15841,15893,15897,15964,16020,16053,16059,16169,16178,16218,16237,16280,16320,16321,16324,16325,16342,16356,16415,16418,16432,16442,16451,16458,16507,16515,16521,16539,16550,16567,16603,16640,16645,16661,16663,16688,16713,16733,16734,16749,16808,16827,16829,16864,16904,16907,16950,16996,17005,17048,17065,17086,17090,17100,17115,17130,17132,17134,17138,17157,17193,17197,17205,17221,17227,17228,17234,17243,17257,17277,17280,17294,17309,17322,17382,17392,17401,17407,17420,17436,17438,17464,17487,17488,17517,17522,17557,17565,17600,17654,17679,17681,17701,17724,17730,17753,17762,17766,17775,17781,17813,17822,17835,17852,17874,17883,17890,17892,17900,17904,17908,17912,17923,17925,17935,17938,17956,17966,17987,17991,17993,17998,18007,18018,18024,18032,18038,18041,18043,18100,18105,18112,18113,18123,18129,18134,18138,18142,18156,18185,18200,18216,18239,18240,18248,18259,18260,18261,18282,18295,18303,18304,18311,18316,18326,18355,18356,18358,18364,18368,18370,18396,18409,18431,18436,18445,18453,18492,18499,18505,18521,18528,18562,18564,18569,18580,18584,18593,18599,18667,18668,18686,18717,18733,18763,18764,18765,18772,18773,18793,18813,18825,18826,18829,18853,18867,18874,18895,18929,18949,18951,18973,18985,19018,19024,19026,19040,19041,19043,19065,19073,19086,19092,19100,19117,19119,19126,19133,19134,19175,19208,19217,19223,19242,19260,19290,19292,19293,19304,19312,19329,19371,19381,19408,19409,19415,19417,19428,19429,19436,19484,19497,19503,19508,19545,19567,19571,19576,19578,19585,19589,19596,19602,19604,19606,19612,19623,19643,19653,19667,19671,19682,19693,19700,19701,19713,19715,19720,19728,19741,19744,19764,19769,19780,19793,19825,19828,19829,19853,19855,19871,19873,19882,19905,19952,19962,19970,20019,20029,20062,20076,20109,20123,20133,20137,20149,20163,20198,20259,20272,20273,20291,20298,20307,20323,20325,20326,20367,20374,20380,20398,20442,20444,20455,20471,20476,20488,20517,20542,20543,20564,20579,20586,20587,20611,20614,20621,20629,20641,20642,20649,20651,20655,20662,20665,20684,20698,20705,20707,20714,20748,20757,20764,20797,20801,20807,20809,20811,20820,20840,20852,20875,20884,20922,20923,20942,20945,20962,20977,20993,21012,21073,21101,21142,21165,21171,21186,21226,21240,21245,21248,21274,21292,21308,21310,21312,21322,21347,21369,21372,21388,21397,21402,21405,21420,21450,21458,21477,21498,21504,21512,21517,21519,21541,21544,21552,21554,21584,21586,21606,21611,21616,21637,21645,21669,21732,21739,21750,21755,21758,21763,21846,21851,21871,21882,21897,21903,21908,21921,21922,21926,22010,22023,22026,22029,22040,22064,22065,22082,22084,22086,22088,22092,22097,22100,22110,22125,22157,22165,22171,22177,22180,22188,22197,22198,22223,22229,22233,22234,22237,22250,22252,22270,22271,22276,22285,22290,22296,22307,22315,22318,22322,22336,22337,22341,22385,22404,22408,22414,22422,22439,22455,22469,22478,22479,22480,22489,22500,22557,22602,22610,22611,22614,22634,22672,22688,22692,22702,22711,22714,22720,22723,22725,22741,22745,22784,22790,22794,22803,22820,22831,22848,22852,22856,22885,22901,22935,22960,23016,23038,23040,23041,23046,23061,23063,23070,23073,23074,23077,23100,23130,23135,23147,23148,23153,23156,23173,23188,23198,23209,23243,23245,23247,23253,23258,23305,23313,23325,23340,23342,23346,23382,23388,23399,23419,23424,23433,23441,23442,23449,23484,23485,23492,23518,23521,23524,23551,23566,23575,23595,23615,23617,23631,23635,23647,23654,23672,23680,23697,23702,23708,23749,23767,23769,23777,23852,23915,23921,23926,23956,23959,23961,23964,23985,23987,23992,24077,24119,24121,24152,24163,24192,24193,24208,24213,24242,24273,24277,24288,24289,24295,24304,24312,24322,24332,24342,24383,24398,24424,24433,24440,24450,24451,24456,24458,24470,24475,24479,24498,24513,24532,24574,24593,24601,24612,24614,24616,24632,24636,24642,24643,24660,24664,24665,24675,24691,24705,24707,24737,24747,24748,24768,24783,24784,24785,24789,24826,24830,24831,24834,24839,24891,24907,24915,24964,24988,25004,25039,25048,25080,25123,25133,25135,25174,25178,25206,25222,25241,25277,25312,25344,25361,25365,25374,25394,25397,25413,25491,25528,25548,25631,25648,25657,25659,25725,25755,25787,25816,25818,25927,25928,25940,25946,25968,25990,26000,26017,26034,26048,26061,26062,26161,26178,26186,26202,26228,26245,26250,26255,26256,26261,26274,26295,26317,26378,26393,26410,26439,26471,26543,26563,26570,26574,26620,26630,26640,26679,26689,26763,26766,26770,26824,26866,26901,26976,26986,26992,27071,27125,27130,27138,27211,27216,27236,27261,27275,27298,27314,27315,27322,27362,27391,27423,27427,27441,27472,27475,27482,27513,27642,27671,27769,27786,27790,27833,27938,27949,27968,27974,28005,28033,28059,28066,28075,28094,28097,28120,28129,28155,28192,28250,28254,28311,28318,28320,28327,28354,28425,28436,28553,28559,28575,28630,28763,28779,28780,28795,28803,28807,28837,28850,28918,28992,29012,29022,29107,29187,29200,29244,29250,29281,29332,29355,29476,29486,29626,29694,29695,29832,29868,30285,30421,30609,30854,31301,31302,31422,31773,32241,32423,33270,33621,33877,33914,33950,34524,34584,34758,34927,34968,35259,35305,35690,35718,35878,36003,36167,36197,36198,36244,36423,36585,36798,36821,36952,37025,38662,38784,38818,38865,38905,38962,39078,39226,39283,39296,39384,39464,39542,39620,39642,39646,39666,39673,39808,39819,39823,40110,40116,40145,40271,40490,40515,40595,40812,40954,40984,41033,41038,41058,41069,41254,41292,41350,41364,41594,42074,42262,42424,42726,42951,43032,43487,43530,43598,43638,44297,45064,45191)
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 | 1538 | 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.27 ms |
System lock | 0.02 ms |
optimizing | 0.11 ms |
statistics | 2.29 ms |
preparing | 1.21 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.32 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 |