Tiempo de la consulta: 5.37 ms Después de la última consulta: 1.28 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.232 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-08 07:48:02')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-08 07:48:02')
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,21,25,49,58,78,113,114,117,136,170,172,197,202,207,208,260,263,271,280,287,290,291,293,344,349,350,353,374,376,377,378,379,380,394,437,456,563,607,608,611,686,693,770,797,824,831,843,868,891,941,964,976,986,997,1033,1043,1207,1215,1232,1247,1273,1287,1296,1329,1339,1348,1486,1503,1538,1601,1698,1709,1714,1718,1804,1931,2258,2305,2656,2714,2742,2757,2901,2991,2997,3020,3028,3045,3091,3117,3124,3209,3212,3215,3319,3329,3340,3452,3575,3604,3668,3671,3700,3732,3738,3783,3816,3842,3870,3895,3957,4087,4100,4120,4128,4131,4169,4188,4206,4319,4339,4378,4399,4473,4493,4612,4613,4614,4615,4617,4621,4638,4677,4920,4980,4982,5138,5189,5199,5435,5461,5471,5530,5559,5647,5730,5814,5825,5855,5857,5973,5996,6039,6131,6159,6234,6241,6292,6333,6372,6384,6407,6427,6464,6465,6468,6470,6484,6492,6493,6616,6631,6687,6688,6716,6744,6776,6908,6940,6942,6957,6961,6989,6998,7128,7154,7215,7218,7231,7232,7234,7243,7246,7249,7280,7282,7285,7289,7303,7311,7319,7328,7330,7333,7334,7344,7346,7361,7364,7367,7368,7370,7371,7374,7377,7379,7380,7387,7396,7402,7403,7406,7407,7408,7410,7413,7414,7415,7416,7417,7422,7425,7430,7431,7434,7435,7436,7447,7450,7454,7455,7456,7457,7458,7463,7464,7465,7483,7486,7489,7522,7545,7546,7552,7553,7555,7556,7565,7570,7572,7577,7583,7614,7615,7625,7626,7638,7659,7677,7678,7682,7683,7691,7713,7715,7720,7725,7735,7741,7744,7746,7749,7757,7768,7774,7799,7829,7830,7833,7834,7835,7836,7847,7851,7862,7863,7871,7890,7891,7894,7895,7900,7901,7916,7919,7923,7955,7957,7961,7962,7965,7967,7979,7982,7985,8020,8022,8023,8024,8027,8049,8064,8067,8072,8107,8108,8125,8177,8223,8229,8285,8383,8444,8549,8555,8589,8660,8689,8694,8698,8713,8851,8856,9057,9059,9181,9218,9233,9249,9253,9303,9318,9344,9399,9429,9432,9438,9439,9568,9658,9704,9723,9725,9805,9828,9861,9907,9966,9985,9996,10011,10046,10054,10092,10100,10110,10120,10149,10154,10180,10181,10186,10197,10199,10205,10227,10243,10259,10265,10295,10304,10313,10318,10349,10357,10369,10370,10382,10387,10399,10400,10415,10444,10522,10534,10564,10611,10623,10721,10777,10782,10798,10820,10821,10957,10971,11005,11026,11071,11150,11188,11235,11328,11333,11345,11362,11365,11386,11404,11458,11539,11592,11642,11663,11726,11779,11799,11816,11864,11893,11922,11950,11976,12009,12081,12178,12179,12226,12243,12248,12270,12388,12435,12446,12465,12488,12520,12527,12581,12582,12609,12617,12649,12670,12685,12736,12758,12838,12851,12873,12898,12907,12935,12944,12978,12985,13006,13035,13036,13041,13079,13137,13154,13229,13285,13307,13325,13327,13332,13334,13348,13375,13390,13420,13466,13497,13515,13647,13667,13670,13685,13805,13817,13835,13901,13906,13953,13972,14024,14052,14098,14113,14143,14152,14205,14223,14248,14250,14276,14283,14336,14352,14354,14366,14372,14396,14420,14421,14424,14426,14431,14453,14505,14530,14558,14571,14596,14625,14629,14630,14676,14680,14695,14713,14754,14770,14775,14789,14843,14845,14849,14852,14856,14865,14946,14973,14974,14983,14984,15007,15010,15015,15018,15021,15039,15046,15076,15126,15129,15156,15214,15231,15286,15293,15304,15315,15316,15318,15335,15351,15376,15406,15424,15444,15475,15520,15522,15533,15552,15581,15594,15600,15608,15616,15655,15673,15689,15700,15704,15714,15723,15730,15742,15755,15766,15778,15785,15790,15797,15805,15808,15812,15835,15874,15880,15894,15897,15902,15916,15925,15965,16053,16055,16058,16088,16095,16103,16127,16172,16240,16249,16250,16254,16316,16318,16324,16357,16362,16381,16384,16410,16417,16427,16440,16474,16490,16520,16521,16523,16542,16551,16584,16657,16670,16675,16695,16724,16739,16781,16783,16791,16816,16839,16841,16907,16942,16982,17049,17053,17080,17084,17116,17163,17188,17201,17240,17246,17256,17288,17291,17300,17331,17335,17344,17365,17386,17387,17394,17422,17444,17476,17497,17542,17553,17561,17566,17573,17575,17590,17607,17625,17630,17643,17660,17688,17711,17712,17717,17736,17753,17779,17783,17820,17824,17834,17850,17859,17862,17883,17887,17914,17919,17922,17930,17933,17936,17941,17950,17955,17967,17978,17981,17983,17996,17999,18044,18060,18061,18118,18121,18150,18216,18220,18222,18260,18278,18295,18300,18353,18382,18391,18397,18428,18429,18442,18482,18541,18552,18558,18571,18576,18605,18626,18664,18693,18706,18712,18728,18730,18735,18748,18793,18811,18830,18849,18871,18877,18888,18905,18922,18997,19001,19015,19055,19101,19105,19124,19128,19140,19145,19173,19220,19243,19254,19259,19277,19287,19315,19325,19379,19381,19426,19437,19472,19484,19486,19517,19531,19542,19574,19604,19607,19639,19651,19659,19679,19684,19710,19725,19733,19754,19772,19773,19794,19807,19830,19855,19871,19877,19881,19901,19923,19929,19965,19967,19972,19984,19996,20066,20097,20119,20127,20154,20175,20186,20189,20191,20289,20297,20333,20366,20385,20390,20405,20411,20433,20437,20445,20447,20488,20542,20545,20588,20592,20632,20638,20659,20660,20698,20708,20718,20772,20777,20781,20794,20805,20814,20885,20940,20947,20959,20960,20979,21009,21049,21055,21104,21116,21117,21118,21122,21128,21143,21170,21198,21228,21247,21259,21300,21305,21316,21325,21344,21350,21367,21370,21380,21390,21398,21418,21421,21448,21449,21457,21463,21470,21495,21520,21522,21540,21551,21554,21591,21602,21607,21611,21624,21640,21663,21680,21682,21684,21702,21741,21764,21776,21778,21843,21853,21867,21883,21895,21906,21917,21924,21947,21952,21968,21977,21990,21997,22003,22038,22039,22044,22067,22096,22106,22116,22119,22132,22154,22170,22178,22215,22255,22262,22276,22278,22289,22290,22298,22320,22349,22359,22363,22382,22395,22436,22450,22454,22460,22465,22476,22501,22555,22570,22579,22588,22596,22602,22616,22649,22653,22661,22693,22709,22718,22746,22751,22759,22781,22799,22804,22820,22840,22866,22877,22886,22914,22915,22930,22944,22959,22960,22986,23009,23029,23034,23071,23072,23087,23093,23103,23107,23112,23123,23137,23140,23156,23214,23229,23232,23236,23242,23252,23270,23279,23302,23308,23339,23340,23364,23367,23368,23401,23405,23430,23438,23444,23449,23480,23484,23527,23550,23553,23555,23575,23577,23621,23623,23642,23665,23680,23682,23691,23693,23698,23709,23712,23716,23719,23725,23727,23729,23743,23768,23784,23816,23846,23869,23885,23902,23920,23927,23944,23949,23955,23968,23989,24009,24015,24024,24060,24062,24065,24076,24100,24102,24110,24115,24159,24164,24196,24211,24223,24237,24239,24249,24270,24283,24296,24306,24335,24362,24372,24386,24397,24402,24422,24430,24431,24453,24457,24473,24475,24506,24507,24526,24530,24556,24575,24577,24584,24595,24617,24635,24656,24668,24677,24690,24707,24716,24724,24726,24736,24738,24751,24767,24779,24780,24785,24794,24800,24805,24809,24816,24834,24841,24859,24872,24915,24930,24931,24946,24963,25036,25037,25043,25063,25073,25081,25096,25112,25117,25136,25138,25155,25165,25178,25180,25200,25282,25287,25291,25294,25297,25310,25327,25329,25332,25343,25352,25358,25367,25384,25386,25408,25416,25418,25440,25452,25462,25477,25484,25515,25523,25526,25538,25548,25555,25560,25564,25582,25589,25640,25648,25664,25676,25687,25692,25697,25765,25806,25807,25854,25887,25889,25918,25919,25926,25941,25959,25971,26000,26023,26043,26055,26063,26229,26230,26250,26258,26261,26274,26340,26359,26362,26386,26390,26409,26413,26540,26541,26579,26595,26596,26609,26646,26711,26807,26820,26845,26853,26854,26873,26959,26968,27001,27039,27061,27062,27094,27126,27158,27221,27245,27290,27327,27347,27374,27379,27438,27492,27506,27512,27552,27557,27578,27584,27604,27605,27646,27707,27745,27749,27789,27795,27851,27871,27949,27950,27968,27975,28066,28094,28213,28264,28283,28441,28464,28468,28511,28537,28623,28749,28826,28846,28852,28892,28907,28908,28951,28964,28972,28973,29049,29061,29073,29140,29171,29194,29208,29325,29349,29443,29535,29539,29576,29642,29673,29719,29912,29936,29939,29962,30194,30274,30449,30988,31684,31798,31853,32820,32840,33416,35000,35632,35639,35640,35643,35711,35740,35741,35744,35752,35760,35774,35846,35858,36075,36208,36216,36492,36581,36584,37577,37759,38362,38900,38912,38958,38975,38986,39020,39064,39131,39159,39172,39224,39240,39600,39642,39687,39981,39998,40168,40184,40351,40611,40993,41148,41171,41211,41325,41915,43274)
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 | 1409 | 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.64 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.27 ms |
| System lock | 0.02 ms |
| optimizing | 0.09 ms |
| statistics | 2.20 ms |
| preparing | 1.09 ms |
| Sorting result | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.34 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 |
El PQDC realiza convenciones en las provincias y municipios:
De: fuente
