Tiempo de la consulta: 5.94 ms Después de la última consulta: 1.57 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.557 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 21:21:41')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-08 21:21:41')
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(11,49,60,61,62,63,64,65,67,68,71,82,90,92,96,97,98,99,102,104,107,185,197,198,199,209,210,214,217,226,228,232,234,238,240,242,243,259,265,272,276,278,281,328,331,344,350,359,362,367,380,385,417,418,419,428,450,460,466,487,523,556,586,605,607,634,637,686,697,717,754,784,825,843,844,857,902,904,935,948,966,971,978,980,981,1006,1024,1031,1067,1168,1187,1198,1208,1209,1223,1280,1286,1305,1319,1351,1354,1371,1391,1455,1496,1506,1535,1540,1556,1565,1566,1603,1634,1646,1698,1713,1776,1800,1802,1804,1811,1822,1825,1845,1851,1877,1900,1913,1957,2004,2005,2013,2086,2109,2112,2123,2156,2210,2228,2260,2305,2337,2354,2378,2384,2394,2424,2467,2509,2598,2601,2613,2628,2632,2643,2668,2689,2729,2805,2822,2828,2870,2898,2939,2952,2962,2967,3020,3033,3058,3067,3074,3076,3087,3211,3212,3216,3283,3337,3340,3373,3377,3410,3478,3512,3564,3567,3590,3641,3663,3696,3718,3719,3725,3757,3779,3871,3934,3962,3982,4025,4033,4131,4172,4192,4257,4266,4320,4451,4468,4529,4563,4587,4622,4674,4690,4718,4741,4770,4784,4808,4832,4834,4876,4902,4947,4957,4990,5072,5086,5104,5125,5150,5170,5173,5224,5233,5237,5247,5268,5299,5303,5323,5371,5495,5559,5581,5589,5622,5644,5647,5649,5684,5685,5726,5727,5730,5798,5814,5827,5837,5847,5888,5973,6039,6131,6176,6264,6268,6270,6336,6381,6386,6470,6501,6518,6570,6609,6665,6690,6711,6748,6760,6770,6775,6809,6830,6839,6847,6872,6881,6910,6915,6917,6919,6945,6950,6984,6985,7001,7002,7017,7044,7104,7125,7137,7168,7183,7205,7271,7296,7330,7358,7396,7416,7428,7432,7482,7526,7585,7594,7624,7659,7681,7688,7708,7710,7745,7772,7801,7813,7838,7839,7860,7866,7913,7928,7931,7933,7946,7958,7965,7967,7981,7985,7993,7995,7998,7999,8000,8026,8027,8056,8062,8070,8088,8222,8250,8320,8354,8355,8391,8416,8438,8462,8481,8531,8532,8555,8603,8674,8706,8764,8773,8776,8844,8964,8972,9003,9012,9018,9109,9115,9196,9197,9239,9308,9330,9370,9425,9442,9481,9529,9532,9552,9556,9650,9724,9728,9865,9869,9895,9924,9944,9945,10001,10031,10100,10172,10243,10260,10280,10299,10301,10323,10340,10352,10383,10400,10436,10561,10603,10604,10673,10764,10811,10834,10889,10932,10956,10991,11098,11106,11107,11129,11163,11299,11305,11356,11377,11482,11565,11626,11627,11648,11688,11694,11711,11722,11822,11859,11911,11936,11946,12042,12095,12113,12150,12177,12216,12224,12238,12254,12337,12412,12424,12437,12500,12541,12550,12592,12609,12621,12668,12669,12679,12708,12727,12780,12878,12887,12897,12913,12944,12973,13002,13004,13010,13062,13152,13153,13231,13268,13276,13321,13328,13352,13398,13405,13436,13471,13473,13474,13476,13500,13501,13535,13575,13576,13585,13608,13629,13657,13671,13681,13685,13727,13748,13782,13783,13800,13811,13816,13846,13858,13859,13868,13922,13924,13934,13941,13969,14029,14034,14047,14103,14122,14153,14156,14185,14203,14218,14224,14263,14293,14327,14356,14424,14430,14524,14570,14581,14596,14648,14663,14669,14679,14688,14703,14709,14729,14733,14744,14762,14790,14808,14846,14849,14860,14862,14879,14895,14905,14906,14949,14958,14973,14987,14992,15020,15021,15038,15039,15046,15063,15110,15114,15145,15179,15183,15188,15198,15208,15209,15234,15238,15244,15262,15293,15298,15304,15306,15310,15347,15359,15365,15366,15368,15418,15421,15470,15473,15482,15485,15493,15495,15511,15517,15522,15540,15550,15573,15577,15594,15608,15630,15632,15645,15662,15667,15669,15751,15753,15755,15759,15776,15784,15791,15835,15843,15851,15870,15903,15931,15937,15957,15975,16046,16083,16088,16115,16122,16165,16201,16213,16263,16300,16322,16334,16340,16352,16365,16422,16426,16439,16440,16446,16455,16464,16465,16488,16503,16507,16520,16526,16532,16556,16629,16646,16654,16684,16689,16720,16728,16787,16791,16802,16812,16826,16830,16831,16840,16861,16862,16894,16905,16983,17045,17063,17090,17101,17133,17136,17142,17154,17166,17199,17210,17236,17242,17253,17275,17317,17334,17335,17344,17362,17369,17409,17412,17440,17443,17446,17453,17458,17471,17487,17506,17520,17521,17531,17584,17597,17609,17611,17619,17630,17635,17655,17662,17700,17710,17713,17737,17761,17823,17826,17839,17857,17862,17881,17902,17910,17927,17933,17947,17949,17956,17965,17976,17977,17994,18022,18028,18029,18052,18066,18067,18086,18088,18106,18124,18133,18162,18165,18170,18181,18191,18203,18213,18219,18227,18229,18260,18285,18300,18311,18336,18347,18362,18364,18376,18377,18426,18439,18458,18465,18467,18473,18490,18509,18520,18538,18567,18588,18595,18665,18671,18675,18707,18720,18726,18753,18762,18770,18783,18801,18807,18816,18825,18828,18845,18846,18852,18906,18907,18912,18926,18929,18956,18958,18974,18999,19002,19024,19040,19047,19057,19060,19067,19096,19098,19123,19127,19145,19148,19150,19153,19170,19180,19185,19204,19211,19235,19245,19252,19253,19263,19268,19276,19299,19312,19327,19352,19353,19358,19367,19369,19376,19397,19400,19402,19426,19432,19454,19457,19460,19463,19472,19483,19484,19487,19507,19527,19529,19532,19551,19577,19582,19620,19633,19668,19676,19687,19706,19722,19732,19744,19750,19772,19791,19796,19811,19816,19837,19845,19870,19876,19908,19909,19939,19943,19963,19988,19998,20004,20010,20028,20032,20039,20056,20057,20066,20068,20086,20092,20095,20122,20134,20135,20141,20156,20170,20177,20183,20187,20188,20216,20234,20256,20263,20269,20271,20289,20296,20301,20309,20338,20343,20353,20386,20396,20408,20424,20434,20437,20449,20450,20469,20483,20492,20497,20516,20521,20526,20528,20535,20539,20564,20565,20573,20574,20592,20617,20630,20642,20648,20670,20688,20704,20714,20729,20750,20751,20792,20804,20866,20873,20881,20886,20894,20907,20944,20953,20964,20982,20984,20990,21002,21050,21080,21087,21132,21173,21182,21189,21198,21225,21247,21259,21295,21300,21314,21329,21332,21402,21404,21405,21422,21432,21453,21454,21459,21487,21513,21545,21547,21598,21602,21610,21611,21614,21620,21631,21636,21640,21678,21679,21694,21718,21722,21726,21738,21764,21767,21768,21769,21773,21811,21824,21850,21854,21891,21909,21932,21940,21950,21958,21960,21980,22032,22085,22100,22132,22137,22146,22156,22162,22172,22189,22229,22239,22253,22262,22267,22297,22337,22339,22344,22361,22363,22409,22453,22466,22481,22494,22499,22525,22544,22547,22559,22564,22581,22611,22647,22673,22694,22695,22712,22726,22739,22749,22753,22758,22774,22781,22814,22851,22865,22868,22869,22871,22886,22903,22908,22914,22925,22958,22959,22964,22973,22980,22988,23003,23010,23036,23037,23072,23074,23083,23096,23099,23104,23119,23123,23127,23184,23186,23196,23203,23213,23218,23229,23230,23235,23250,23254,23261,23264,23268,23273,23275,23281,23287,23292,23295,23304,23309,23328,23371,23374,23381,23391,23397,23398,23401,23402,23455,23457,23460,23471,23475,23483,23493,23495,23511,23523,23554,23555,23585,23604,23610,23619,23632,23636,23686,23704,23719,23720,23732,23764,23805,23813,23831,23840,23845,23854,23858,23885,23887,23888,23891,23893,23897,23901,23905,23907,23909,23947,23964,23973,23986,24000,24007,24027,24028,24029,24043,24059,24067,24077,24092,24100,24160,24164,24180,24194,24197,24209,24226,24238,24281,24294,24303,24316,24334,24337,24339,24342,24352,24361,24376,24399,24429,24451,24463,24485,24489,24496,24503,24526,24539,24540,24556,24585,24586,24591,24594,24598,24615,24617,24639,24653,24663,24678,24679,24707,24711,24741,24743,24764,24772,24781,24782,24785,24788,24791,24804,24834,24861,24884,24897,24906,24912,24918,24934,24952,24956,24984,24992,24998,25005,25032,25038,25045,25062,25068,25079,25089,25151,25184,25201,25232,25244,25264,25287,25303,25304,25315,25318,25368,25375,25377,25401,25432,25450,25473,25480,25507,25548,25613,25621,25622,25637,25640,25648,25649,25673,25702,25716,25717,25723,25730,25734,25769,25771,25775,25818,25835,25863,25872,25906,25918,25927,25949,25956,25995,26000,26047,26113,26118,26131,26153,26184,26203,26221,26245,26283,26296,26315,26335,26374,26386,26388,26443,26516,26565,26576,26601,26620,26625,26629,26630,26638,26639,26640,26646,26663,26673,26683,26691,26699,26708,26732,26760,26784,26807,26815,26820,26845,26875,26879,26884,26900,26916,26925,26933,26935,26936,26940,26944,26948,26971,26978,26990,27009,27065,27086,27100,27101,27103,27109,27118,27126,27141,27143,27171,27184,27196,27209,27211,27212,27216,27232,27252,27259,27268,27269,27270,27298,27323,27384,27405,27408,27423,27430,27463,27487,27491,27492,27524,27526,27541,27550,27559,27560,27568,27570,27571,27595,27673,27676,27688,27717,27786,27805,27860,27898,28030,28031,28049,28059,28066,28075,28094,28097,28120,28121,28129,28162,28243,28329,28336,28384,28435,28454,28495,28587,28718,28825,28882,28941,29045,29063,29155,29229,29272,29297,29412,29454,29802,29926,29943,30083,30273,30483,30484,30525,30740,30808,31129,31136,31447,31604,31735,32107,32647,32767,32905,33649,35000,35365,35585,35603,35744,35792,35806,35808,35832,35846,35882,35947,36368,36369,37828,38133,38824,38877,38949,39205,39320,39381,39587,39887,40086,40113,40319,40451,40492,40509,40578,41049,41213,41477,44062)
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 | 1545 | 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.69 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.08 ms |
init | 0.36 ms |
System lock | 0.02 ms |
optimizing | 0.17 ms |
statistics | 2.38 ms |
preparing | 1.18 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.06 ms |
freeing items | 0.09 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 |