Tiempo de la consulta: 4.91 ms Después de la última consulta: 1.11 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.384 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 17:32:28')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 17:32: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(4,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,71,72,75,116,120,121,122,123,124,126,127,128,174,197,253,255,269,282,283,294,295,296,301,302,307,353,373,377,393,437,446,481,550,611,613,667,669,670,671,686,705,724,726,735,746,757,800,801,816,831,860,892,900,954,973,986,1059,1078,1123,1124,1140,1183,1207,1226,1264,1304,1335,1384,1477,1519,1533,1697,1757,1773,1883,1897,2150,2152,2181,2195,2248,2278,2290,2293,2342,2371,2609,2713,2797,2853,2886,3103,3208,3219,3229,3442,3449,3452,3463,3491,3591,3620,3732,3784,3862,3898,3918,4258,4459,4625,4674,4676,4767,4813,4872,4920,4932,5154,5300,5351,5365,5386,5438,5451,5647,5686,5725,5726,5727,5730,5798,5894,5924,6050,6068,6141,6201,6278,6279,6294,6339,6415,6419,6463,6471,6475,6476,6477,6534,6542,6543,6545,6548,6583,6605,6616,6639,6643,6748,6841,6842,6888,6889,6895,6918,6936,7005,7105,7162,7163,7164,7185,7233,7337,7342,7412,7457,7463,7484,7488,7492,7516,7547,7551,7581,7616,7626,7642,7682,7683,7718,7741,7758,7779,7806,7829,7837,7847,7949,7950,7952,7955,7962,7964,7965,7984,7987,8024,8027,8113,8223,8408,8460,8489,8565,8568,8615,8689,8780,8860,8916,8917,8932,9073,9181,9351,9412,9495,9615,9745,9820,9927,10026,10092,10120,10180,10195,10228,10239,10274,10278,10298,10328,10364,10369,10379,10414,10415,10435,10460,10611,10659,10771,10894,10924,10960,10971,10978,11003,11031,11065,11073,11080,11083,11091,11095,11122,11127,11135,11143,11157,11206,11264,11309,11328,11370,11407,11427,11438,11497,11585,11587,11614,11721,11727,11730,11839,11848,11915,11987,12018,12038,12040,12091,12096,12098,12108,12109,12121,12133,12156,12193,12248,12299,12306,12307,12415,12449,12557,12672,12673,12717,12723,12735,12808,12848,12868,12871,12903,12916,12991,12997,13035,13075,13081,13141,13158,13190,13198,13231,13242,13331,13337,13346,13418,13419,13425,13456,13463,13511,13543,13551,13583,13595,13600,13611,13627,13646,13675,13677,13695,13697,13703,13705,13706,13707,13713,13715,13742,13788,13828,13838,13883,13920,13933,13951,13972,14057,14073,14080,14097,14104,14114,14150,14163,14196,14222,14227,14236,14249,14267,14278,14282,14314,14382,14413,14452,14469,14471,14486,14563,14571,14572,14574,14600,14616,14632,14657,14665,14684,14694,14701,14726,14732,14747,14767,14770,14775,14796,14799,14827,14842,14850,14945,14960,14980,14981,15006,15069,15120,15146,15161,15175,15206,15215,15243,15245,15303,15330,15343,15349,15354,15356,15389,15411,15439,15470,15475,15497,15513,15548,15561,15565,15576,15588,15631,15633,15641,15643,15655,15667,15668,15704,15730,15731,15750,15763,15789,15841,15873,15893,15953,15964,16020,16038,16053,16059,16087,16095,16169,16236,16258,16280,16320,16342,16356,16415,16442,16451,16458,16491,16507,16640,16645,16663,16688,16695,16715,16749,16771,16783,16808,16827,16829,16864,16889,16986,16996,17005,17048,17115,17130,17132,17193,17201,17221,17227,17228,17240,17243,17257,17277,17280,17294,17322,17382,17386,17392,17407,17436,17438,17464,17486,17487,17488,17500,17517,17557,17565,17598,17600,17603,17654,17679,17681,17701,17724,17730,17753,17754,17766,17781,17783,17822,17852,17874,17890,17892,17908,17912,17923,17938,17966,17991,17998,18001,18007,18034,18100,18121,18123,18134,18138,18143,18156,18185,18200,18216,18222,18239,18240,18254,18259,18261,18274,18303,18311,18316,18331,18334,18355,18356,18368,18370,18393,18396,18436,18445,18453,18492,18499,18503,18505,18510,18528,18559,18562,18564,18569,18580,18584,18599,18610,18645,18667,18668,18679,18686,18762,18764,18765,18793,18813,18829,18853,18859,18874,18895,18951,18961,18973,18985,19018,19037,19041,19065,19073,19092,19100,19117,19152,19175,19208,19217,19223,19242,19260,19272,19290,19291,19292,19293,19304,19312,19329,19371,19381,19403,19408,19409,19415,19416,19417,19428,19429,19436,19437,19453,19484,19497,19503,19531,19535,19567,19571,19578,19585,19589,19595,19596,19599,19601,19602,19604,19612,19623,19643,19645,19646,19671,19680,19682,19699,19700,19701,19720,19728,19733,19741,19764,19769,19780,19809,19827,19829,19853,19857,19882,19905,19952,19962,19970,20019,20029,20053,20062,20076,20109,20123,20127,20133,20137,20149,20243,20259,20273,20297,20298,20307,20323,20326,20327,20349,20367,20380,20381,20398,20403,20411,20441,20442,20444,20476,20488,20489,20517,20540,20543,20549,20551,20587,20611,20614,20621,20629,20630,20649,20662,20668,20684,20705,20748,20757,20764,20794,20797,20805,20809,20811,20820,20826,20875,20884,20923,20942,20962,20982,20993,21005,21009,21012,21063,21073,21101,21142,21165,21171,21186,21245,21248,21255,21308,21310,21312,21313,21322,21365,21388,21401,21402,21420,21458,21477,21498,21504,21512,21519,21541,21544,21545,21552,21554,21584,21611,21616,21621,21637,21645,21669,21682,21709,21740,21755,21758,21763,21865,21871,21882,21890,21897,21902,21903,21921,21922,21931,21947,21952,21973,21976,22000,22012,22023,22026,22029,22064,22065,22084,22092,22098,22100,22103,22110,22114,22122,22125,22159,22165,22171,22177,22185,22188,22193,22198,22217,22222,22223,22233,22237,22250,22252,22271,22274,22285,22290,22295,22298,22306,22312,22317,22322,22323,22334,22336,22337,22341,22348,22388,22404,22408,22422,22432,22439,22452,22469,22478,22479,22480,22500,22509,22543,22557,22563,22602,22610,22614,22644,22647,22688,22696,22702,22714,22723,22724,22725,22741,22745,22750,22794,22803,22804,22844,22876,22885,22890,22917,22935,22985,23000,23038,23046,23049,23061,23063,23073,23077,23125,23127,23135,23148,23153,23188,23201,23251,23253,23258,23305,23306,23313,23318,23342,23346,23356,23382,23419,23424,23433,23441,23442,23449,23463,23485,23518,23521,23524,23527,23551,23574,23575,23595,23600,23615,23631,23635,23672,23680,23682,23697,23708,23730,23746,23749,23757,23769,23777,23852,23861,23915,23917,23919,23956,23957,23959,23961,23967,23985,23987,23992,24082,24101,24121,24213,24225,24273,24288,24289,24295,24304,24305,24320,24332,24345,24346,24388,24390,24433,24440,24449,24456,24458,24470,24475,24505,24532,24555,24574,24576,24577,24593,24612,24614,24616,24632,24636,24642,24660,24664,24665,24667,24668,24675,24684,24691,24707,24748,24750,24756,24768,24783,24784,24789,24830,24831,24839,24888,24889,24907,24988,25039,25048,25080,25123,25147,25174,25206,25241,25273,25277,25312,25326,25344,25361,25365,25374,25394,25397,25488,25491,25500,25524,25528,25548,25691,25725,25755,25945,25970,25990,26042,26043,26048,26062,26066,26135,26161,26178,26186,26250,26255,26256,26274,26295,26305,26317,26379,26543,26563,26574,26595,26675,26687,26689,26711,26824,26826,26901,26986,27130,27153,27213,27261,27314,27315,27316,27362,27391,27438,27441,27472,27482,27678,27809,27833,27938,27945,28005,28033,28049,28192,28250,28254,28303,28311,28318,28320,28327,28336,28425,28436,28534,28559,28630,28763,28780,28795,28807,28837,28847,28850,28870,28950,28992,29012,29244,29250,29281,29332,29355,29358,29399,29476,29486,29623,29832,29863,29868,30723,31850,33270,34432,35495,35571,35690,36244,36798,36821,36995,38945,39128,39283,39286,39464,39642,39819,40110,40116,40145,40271,40490,40515,40640,40681,40720,40761,40773,40775,40777,40785,40809,40860,40922,40935,40937,40984,41023,41038,41048,41058,41069,41292,41364,42875,43564)
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 | 1237 | 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.62 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.23 ms |
System lock | 0.02 ms |
optimizing | 0.09 ms |
statistics | 1.92 ms |
preparing | 0.95 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.37 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 |