Tiempo de la consulta: 7.73 ms Después de la última consulta: 1.26 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.441 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 11:00:13')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 11:00:13')
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(9,11,49,58,71,74,75,76,77,78,113,114,117,136,147,148,149,150,151,152,153,154,155,161,162,163,164,165,167,170,172,204,207,208,234,287,290,291,293,339,343,344,349,353,377,385,389,437,447,458,495,607,609,669,679,686,693,744,782,797,799,813,831,843,844,851,862,868,942,956,970,976,986,997,999,1012,1017,1018,1053,1091,1139,1185,1186,1207,1215,1232,1233,1247,1273,1277,1287,1298,1339,1459,1463,1486,1502,1503,1643,1709,1725,1817,1835,1893,1931,2144,2169,2199,2210,2217,2237,2242,2256,2273,2286,2299,2313,2346,2348,2386,2476,2713,2757,2827,2857,2901,2964,2991,2997,3020,3028,3045,3049,3064,3106,3107,3113,3117,3124,3209,3210,3212,3322,3427,3442,3519,3668,3671,3692,3738,3794,3814,3842,3852,3870,3886,3986,4009,4013,4076,4105,4120,4128,4281,4378,4399,4405,4670,5300,5471,5525,5559,5647,5730,5894,6039,6131,6186,6234,6298,6362,6442,6484,6616,6633,6654,6688,6725,6726,6744,6749,6785,6905,6911,6948,6955,6971,6989,6998,7026,7101,7189,7280,7282,7285,7296,7311,7328,7361,7387,7402,7403,7410,7435,7456,7483,7486,7544,7551,7569,7614,7617,7626,7677,7688,7710,7797,7806,7836,7847,7858,7861,7863,7890,7894,7914,7929,7965,8018,8027,8107,8108,8133,8134,8177,8250,8295,8663,8679,9091,9242,9249,9282,9305,9318,9414,9438,9451,9457,9507,9626,9864,9916,9984,10092,10100,10110,10120,10149,10181,10193,10206,10239,10264,10309,10315,10318,10369,10370,10382,10389,10399,10415,10423,10425,10444,10453,10535,10611,10623,10644,10682,10721,10741,10761,10779,10782,10798,10809,10850,10907,10952,10957,11002,11037,11059,11091,11188,11207,11235,11242,11503,11726,11734,11779,11896,11922,11924,12070,12081,12133,12165,12243,12270,12301,12398,12403,12465,12482,12517,12520,12521,12562,12581,12582,12610,12625,12729,12758,12808,12846,12850,12851,12873,12907,12978,13006,13035,13036,13041,13061,13100,13105,13124,13137,13251,13307,13323,13332,13390,13420,13466,13481,13497,13515,13519,13548,13569,13624,13635,13692,13757,13771,13790,13805,13817,13835,13890,13894,13906,13953,13972,14024,14107,14113,14140,14143,14168,14189,14194,14201,14205,14208,14223,14237,14283,14285,14287,14334,14370,14372,14382,14401,14453,14457,14481,14487,14529,14530,14558,14571,14591,14625,14630,14631,14655,14695,14697,14698,14700,14725,14749,14754,14760,14771,14775,14829,14845,14847,14852,14856,14865,14911,14983,14984,14999,15007,15010,15035,15038,15063,15094,15111,15129,15150,15156,15158,15171,15177,15187,15214,15231,15233,15259,15270,15305,15335,15346,15351,15355,15361,15376,15406,15407,15418,15424,15429,15438,15469,15475,15486,15487,15516,15520,15522,15552,15581,15600,15655,15689,15700,15704,15722,15730,15740,15742,15778,15785,15790,15812,15850,15863,15875,15876,15880,15897,15937,15940,15965,15981,15987,15995,16024,16042,16043,16056,16058,16090,16095,16127,16129,16155,16211,16249,16250,16254,16281,16282,16303,16316,16323,16324,16338,16357,16359,16366,16384,16417,16427,16430,16438,16476,16516,16521,16524,16542,16547,16551,16561,16564,16571,16626,16657,16668,16675,16683,16687,16689,16695,16717,16724,16728,16777,16781,16783,16816,16819,16839,16840,16841,16848,16863,16942,16951,16984,17002,17007,17049,17050,17067,17084,17086,17116,17124,17148,17153,17155,17188,17201,17222,17240,17242,17246,17253,17273,17274,17278,17282,17287,17288,17289,17300,17331,17333,17360,17365,17386,17387,17414,17444,17467,17490,17497,17509,17523,17526,17539,17540,17553,17555,17561,17572,17573,17575,17598,17618,17630,17659,17664,17688,17701,17711,17712,17716,17727,17736,17753,17759,17779,17782,17783,17818,17826,17834,17850,17851,17853,17862,17879,17887,17893,17919,17920,17922,17930,17936,17950,17955,17967,17983,17995,17996,17999,18022,18044,18060,18061,18074,18081,18083,18121,18159,18173,18218,18219,18220,18222,18242,18260,18277,18278,18291,18292,18293,18295,18311,18348,18351,18352,18382,18391,18397,18409,18410,18428,18443,18450,18451,18541,18549,18552,18568,18571,18572,18577,18625,18626,18648,18651,18664,18693,18696,18706,18724,18728,18762,18811,18814,18827,18830,18849,18866,18877,18880,18883,18888,18901,18905,18911,18916,18947,18953,18997,19004,19014,19015,19060,19063,19105,19107,19124,19128,19138,19140,19145,19155,19165,19173,19217,19220,19229,19231,19255,19260,19283,19287,19297,19308,19314,19315,19378,19379,19381,19392,19407,19416,19418,19419,19437,19447,19452,19457,19460,19482,19486,19501,19511,19517,19531,19583,19591,19607,19617,19634,19639,19648,19659,19684,19707,19710,19718,19725,19731,19733,19747,19754,19794,19807,19812,19813,19832,19854,19869,19908,19923,19925,19929,19958,19960,19984,19996,20015,20040,20079,20083,20091,20097,20104,20119,20127,20140,20154,20168,20175,20179,20186,20200,20261,20289,20297,20318,20333,20336,20348,20357,20363,20366,20379,20405,20411,20443,20445,20461,20472,20522,20540,20542,20553,20555,20563,20607,20615,20632,20638,20659,20664,20666,20710,20737,20758,20772,20775,20777,20805,20885,20917,20940,20947,20957,20959,20960,20983,21009,21055,21058,21079,21104,21116,21117,21118,21119,21126,21128,21143,21187,21223,21228,21270,21297,21305,21316,21323,21344,21350,21367,21371,21372,21384,21390,21398,21418,21421,21447,21457,21463,21470,21492,21495,21496,21497,21520,21522,21540,21545,21546,21555,21611,21663,21682,21684,21702,21740,21741,21746,21751,21757,21764,21776,21778,21853,21855,21878,21879,21880,21883,21904,21906,21917,21924,21945,21947,21968,21977,21987,21992,21997,22000,22003,22011,22027,22030,22038,22040,22067,22089,22093,22106,22119,22126,22139,22154,22178,22180,22187,22218,22270,22278,22298,22306,22328,22336,22340,22349,22359,22364,22395,22407,22432,22450,22460,22476,22484,22497,22519,22529,22555,22559,22561,22570,22572,22592,22596,22605,22616,22622,22642,22653,22661,22693,22707,22709,22718,22746,22751,22752,22753,22759,22788,22799,22804,22819,22820,22836,22840,22858,22909,22911,22913,22935,22944,22960,22974,22976,22983,23011,23022,23033,23034,23052,23055,23069,23071,23078,23087,23091,23093,23112,23139,23140,23144,23162,23190,23204,23221,23236,23237,23239,23252,23262,23279,23295,23300,23302,23318,23326,23339,23348,23367,23368,23398,23405,23430,23438,23439,23449,23456,23463,23498,23522,23525,23527,23550,23553,23555,23562,23568,23577,23585,23599,23602,23617,23626,23653,23662,23665,23680,23682,23691,23693,23698,23716,23727,23743,23761,23784,23787,23816,23826,23829,23836,23849,23853,23910,23912,23925,23936,23953,23955,23958,23968,24019,24034,24060,24064,24065,24076,24102,24106,24145,24159,24164,24178,24215,24217,24220,24230,24236,24237,24268,24270,24278,24283,24326,24329,24364,24372,24386,24402,24417,24429,24457,24461,24473,24475,24526,24530,24573,24577,24581,24584,24634,24649,24656,24668,24672,24690,24730,24751,24754,24757,24773,24779,24800,24805,24809,24817,24825,24841,24849,24850,24859,24862,24868,24899,24930,24941,24946,24963,24975,25003,25037,25063,25069,25070,25071,25081,25096,25112,25117,25153,25155,25165,25180,25192,25225,25280,25293,25297,25310,25329,25332,25334,25343,25352,25358,25369,25382,25384,25386,25387,25412,25416,25418,25420,25429,25434,25452,25462,25477,25523,25535,25560,25564,25573,25589,25614,25653,25662,25664,25676,25688,25697,25701,25711,25747,25762,25785,25807,25820,25887,25919,25921,25926,25948,25965,25971,26008,26043,26050,26063,26133,26158,26175,26229,26250,26258,26261,26292,26358,26367,26431,26444,26540,26541,26559,26571,26583,26596,26618,26697,26698,26711,26742,26760,26807,26809,26854,26859,26873,26930,26959,26960,27001,27002,27009,27024,27039,27055,27056,27058,27060,27061,27062,27076,27082,27094,27101,27145,27158,27218,27221,27263,27271,27290,27327,27417,27435,27438,27506,27525,27544,27552,27578,27646,27707,27745,27851,27871,27949,27950,27957,27968,27975,27990,28066,28075,28094,28213,28264,28283,28464,28499,28511,28606,28611,28690,28749,28774,28826,28892,28907,28908,28933,28949,28951,28972,28973,29049,29061,29073,29140,29171,29194,29208,29340,29349,29372,29378,29535,29539,29576,29613,29617,29618,29622,29642,29673,29719,29911,29912,29923,29939,30449,31115,31286,32516,32676,32840,33749,35566,35744,35882,35942,36438,36875,38900,38986,39049,39131,39172,39385,39857,39981,39998,40168,40203,40351,40356,40483,40611,40759,40993,41211)
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 | 1393 | 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 | 1.03 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.07 ms |
init | 0.50 ms |
System lock | 0.02 ms |
optimizing | 0.14 ms |
statistics | 2.87 ms |
preparing | 1.72 ms |
Sorting result | 0.02 ms |
executing | 0.04 ms |
Sending data | 0.45 ms |
end | 0.01 ms |
query end | 0.08 ms |
closing tables | 0.01 ms |
freeing items | 0.10 ms |
cleaning up | 0.06 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 |