Tiempo de la consulta: 11.42 ms Después de la última consulta: 1.82 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.648 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-06 06:08:14')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 06:08:14')
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(82,93,181,192,197,198,215,216,221,224,225,226,254,262,269,275,280,311,325,328,385,394,407,474,495,540,579,595,596,599,634,641,642,650,681,686,715,764,841,854,875,935,971,976,981,1066,1071,1085,1167,1198,1266,1267,1280,1339,1342,1343,1352,1354,1358,1359,1391,1408,1455,1464,1467,1473,1513,1534,1535,1574,1603,1634,1637,1646,1659,1686,1693,1709,1713,1721,1778,1781,1800,1802,1804,1805,1809,1822,1896,1900,1913,1915,1932,1944,2046,2098,2122,2123,2156,2210,2221,2228,2239,2258,2260,2284,2285,2305,2337,2367,2378,2424,2427,2428,2455,2468,2509,2598,2600,2601,2613,2623,2632,2665,2668,2688,2689,2695,2805,2828,2855,2869,2941,2952,2958,2963,2967,3025,3067,3075,3076,3079,3087,3211,3212,3216,3258,3319,3320,3321,3337,3373,3380,3381,3398,3408,3410,3426,3454,3475,3487,3510,3521,3563,3595,3630,3663,3718,3719,3725,3757,3801,3831,3868,3870,3871,3984,4033,4061,4066,4131,4227,4320,4338,4383,4493,4547,4578,4699,4770,4799,4832,4836,4855,4905,4910,4911,4935,4947,4957,4965,4990,5040,5053,5062,5079,5086,5092,5098,5104,5139,5147,5150,5151,5166,5170,5173,5184,5195,5218,5224,5237,5263,5268,5273,5298,5374,5391,5406,5480,5519,5544,5559,5585,5622,5666,5756,5782,5798,5799,5814,5835,5846,5852,5906,5927,5943,5944,5973,6014,6032,6039,6055,6069,6097,6131,6161,6173,6222,6226,6264,6268,6270,6276,6308,6347,6373,6446,6466,6510,6539,6542,6543,6571,6609,6641,6645,6665,6666,6677,6695,6699,6711,6716,6770,6775,6779,6809,6830,6839,6847,6873,6910,6915,6917,6919,6924,6937,6939,6945,6977,6985,7001,7004,7048,7082,7083,7117,7134,7167,7201,7205,7222,7271,7287,7294,7330,7358,7396,7399,7416,7423,7446,7482,7526,7534,7556,7560,7569,7585,7624,7659,7663,7696,7716,7717,7739,7745,7758,7810,7812,7813,7837,7866,7904,7913,7926,7933,7958,7968,7999,8000,8026,8036,8039,8056,8060,8085,8088,8149,8178,8222,8250,8294,8296,8299,8306,8319,8330,8333,8347,8353,8354,8357,8416,8418,8438,8444,8458,8462,8483,8532,8550,8556,8572,8603,8659,8678,8685,8706,8710,8714,8755,8764,8808,8810,8835,8923,8940,8948,8964,8972,8995,9012,9018,9046,9091,9096,9098,9110,9140,9180,9186,9190,9196,9197,9199,9239,9252,9308,9313,9330,9362,9364,9370,9381,9437,9481,9529,9541,9552,9576,9605,9629,9641,9658,9685,9731,9756,9823,9865,9869,9873,9915,9920,9934,9958,9977,9998,10014,10039,10044,10046,10052,10100,10112,10113,10134,10147,10186,10260,10301,10342,10352,10400,10407,10504,10522,10581,10598,10603,10604,10689,10691,10708,10727,10764,10774,10811,10956,11098,11106,11107,11163,11178,11208,11305,11356,11436,11465,11476,11525,11549,11590,11627,11632,11677,11702,11706,11722,11742,11747,11750,11772,11791,11859,11864,11979,11994,12035,12083,12095,12113,12216,12223,12224,12254,12324,12330,12334,12437,12440,12494,12499,12534,12541,12550,12575,12592,12609,12669,12708,12746,12771,12790,12795,12806,12807,12889,12998,13045,13064,13065,13069,13070,13074,13094,13121,13128,13188,13209,13263,13268,13328,13352,13474,13501,13509,13535,13575,13576,13616,13671,13681,13685,13693,13727,13728,13748,13750,13782,13783,13803,13846,13858,13868,13873,13894,13898,13924,13938,13941,13947,14048,14122,14128,14146,14199,14203,14327,14352,14356,14360,14389,14430,14431,14434,14494,14496,14524,14534,14577,14604,14648,14663,14669,14679,14688,14703,14709,14713,14726,14733,14741,14744,14752,14762,14769,14790,14846,14849,14857,14860,14862,14889,14905,14906,14911,14948,14949,14969,14970,14973,14987,14992,14996,15020,15021,15045,15046,15077,15090,15110,15128,15133,15179,15184,15186,15201,15208,15209,15220,15234,15262,15279,15289,15293,15298,15304,15310,15365,15366,15386,15421,15473,15482,15517,15522,15533,15540,15550,15594,15598,15627,15630,15644,15650,15681,15689,15690,15753,15784,15785,15796,15808,15833,15849,15851,15870,15895,15902,15904,15931,15937,15945,15947,15960,15998,16010,16011,16040,16055,16078,16103,16115,16122,16157,16195,16214,16219,16242,16284,16401,16417,16419,16422,16440,16443,16455,16465,16519,16526,16548,16566,16570,16588,16652,16654,16678,16689,16720,16728,16787,16802,16812,16862,16894,16908,16913,16917,17014,17027,17072,17101,17133,17136,17166,17168,17198,17199,17217,17221,17224,17236,17296,17317,17334,17335,17344,17357,17369,17385,17409,17412,17479,17520,17530,17531,17580,17584,17597,17603,17609,17629,17635,17643,17695,17700,17826,17857,17862,17902,17910,17927,17949,17956,17959,17965,17976,17977,18012,18014,18022,18028,18029,18067,18068,18071,18165,18170,18213,18227,18276,18284,18306,18309,18362,18377,18382,18423,18458,18473,18491,18516,18538,18548,18582,18595,18599,18628,18675,18707,18726,18744,18753,18789,18821,18825,18845,18906,18907,18912,18926,18927,18929,18952,18974,19019,19024,19032,19039,19040,19112,19123,19127,19150,19153,19204,19211,19235,19236,19245,19252,19263,19268,19286,19299,19316,19353,19358,19359,19426,19432,19454,19472,19483,19484,19487,19507,19523,19527,19533,19593,19607,19676,19695,19706,19723,19742,19750,19758,19767,19783,19791,19796,19876,19935,19980,19988,20003,20026,20030,20039,20066,20068,20075,20086,20092,20122,20150,20157,20183,20262,20309,20338,20376,20384,20386,20396,20434,20437,20469,20488,20503,20521,20526,20528,20565,20566,20567,20574,20592,20604,20618,20637,20638,20642,20648,20656,20670,20688,20704,20713,20750,20751,20776,20792,20804,20806,20825,20832,20833,20837,20883,20894,20944,20953,20964,20984,20990,21013,21021,21087,21090,21094,21147,21174,21182,21196,21198,21230,21243,21259,21285,21327,21329,21332,21340,21404,21405,21435,21441,21454,21487,21547,21549,21598,21602,21614,21650,21660,21665,21670,21718,21719,21722,21726,21761,21767,21769,21773,21796,21811,21824,21825,21834,21850,21891,21932,21953,21958,21962,22015,22062,22117,22125,22129,22134,22137,22156,22162,22172,22196,22197,22212,22253,22262,22267,22290,22337,22352,22362,22384,22400,22409,22419,22421,22453,22466,22481,22494,22499,22551,22573,22581,22615,22659,22676,22726,22737,22739,22753,22761,22767,22781,22797,22829,22850,22851,22855,22865,22869,22871,22886,22914,22925,22938,22941,22958,22959,22963,22964,23035,23036,23037,23083,23099,23104,23115,23119,23123,23184,23213,23218,23229,23254,23257,23268,23273,23287,23309,23313,23328,23332,23345,23398,23453,23454,23479,23482,23491,23493,23504,23554,23604,23628,23632,23659,23704,23718,23720,23751,23788,23805,23813,23831,23860,23879,23885,23886,23887,23888,23890,23891,23893,23897,23899,23901,23904,23905,23907,23921,23927,23943,23964,23981,23983,23986,24000,24027,24029,24039,24040,24043,24062,24067,24071,24077,24107,24153,24160,24164,24172,24185,24197,24199,24208,24247,24248,24281,24286,24294,24316,24334,24337,24399,24406,24429,24434,24458,24463,24475,24485,24496,24497,24503,24539,24587,24589,24617,24678,24679,24743,24766,24781,24782,24785,24788,24793,24834,24854,24880,24894,24896,24906,24927,24951,24952,24956,24967,24993,25001,25013,25032,25038,25040,25068,25091,25094,25114,25131,25167,25201,25233,25296,25318,25321,25351,25367,25368,25371,25372,25377,25390,25391,25393,25414,25431,25433,25446,25450,25451,25457,25459,25464,25465,25467,25468,25472,25476,25482,25485,25486,25489,25492,25493,25494,25495,25499,25504,25505,25506,25508,25509,25510,25517,25518,25536,25537,25538,25540,25545,25546,25548,25552,25559,25569,25572,25576,25578,25582,25587,25588,25596,25621,25622,25648,25673,25674,25717,25723,25734,25747,25757,25771,25800,25817,25836,25863,25874,25909,25916,25927,25937,25941,25950,25953,25992,25995,26000,26010,26044,26047,26087,26113,26124,26153,26187,26211,26245,26262,26288,26296,26335,26362,26376,26386,26387,26388,26491,26506,26554,26565,26572,26576,26577,26578,26587,26620,26630,26639,26646,26653,26658,26664,26683,26691,26694,26699,26784,26785,26787,26796,26815,26820,26845,26879,26915,26916,26918,26933,26935,26944,26947,26956,26962,26964,26968,27041,27065,27067,27095,27103,27108,27109,27115,27116,27123,27137,27192,27196,27209,27212,27216,27242,27252,27268,27269,27270,27298,27307,27323,27342,27343,27355,27360,27367,27408,27423,27487,27492,27541,27568,27570,27581,27595,27717,27786,27923,28031,28059,28066,28075,28094,28097,28120,28129,28162,28237,28243,28290,28329,28435,28440,28534,28582,28635,28741,28751,28870,28930,28956,28995,29045,29152,29166,29222,29226,29229,29272,29630,29716,30231,30284,30525,30560,30761,31463,31533,31725,31735,32642,32643,32644,32767,32768,32819,33046,33065,33157,33268,33349,33405,33605,33750,33954,33955,33956,34016,34030,34047,34071,34159,34180,34189,34239,34243,34249,34251,34262,34270,34273,34375,34377,34391,34443,34483,34502,34520,34611,34646,34655,34811,34832,34888,34935,34956,34959,35010,35094,35100,35145,35175,35185,35191,35205,35232,35238,35239,35250,35266,35289,35295,35310,35314,35345,35351,35365,35376,35392,35397,35540,35554,35557,35581,35621,35641,35643,35658,35684,35744,35773,35805,35806,35808,35822,35847,35876,35881,35882,35902,35925,35930,35948,35982,36007,36015,36031,36066,36143,36220,36227,36251,36300,36331,36339,36368,36369,36373,36380,36382,36385,36386,36437,36441,36531,36554,36608,36617,36620,36688,36714,36790,36791,36792,36793,36828,36838,36849,36851,36888,36917,36930,36931,36933,36941,36957,36960,36984,36985,37002,37015,37024,37056,37104,37137,37245,37344,37357,37365,37370,37411,37422,37473,37508,37521,37524,37532,37534,37543,37544,37579,37642,37643,37644,37669,37670,37671,37672,37675,37676,37687,37688,37693,37710,37731,37740,37757,37758,37767,37785,37787,37796,37802,37834,37844,37852,37876,37887,37902,37932,37953,37999,38001,38019,38058,38060,38071,38133,38185,38199,38238,38329,38330,38346,38361,38363,38370,38409,38418,38430,38452,38506,38512,38520,38567,38585,38588,38617,38623,38664,38665,38681,38719,38723,38734,38762,38764,38781,38809,38821,38824,38829,38837,38851,38861,38877,38888,38933,38949,38956,38965,39019,39023,39039,39070,39110,39133,39160,39185,39205,39212,39227,39231,39244,39290,39293,39297,39346,39392,39397,39415,39416,39439,39460,39470,39491,39508,39517,39519,39582,39587,39635,39649,39670,39687,39718,39736,39757,39767,39769,39826,39837,39838,39849,39856,39891,39896,39897,39932,39934,39958,39964,39977,39993,40003,40025,40059,40072,40073,40082,40094,40104,40183,40195,40275,40292,40302,40306,40319,40345,40379,40431,40494,40505,40508,40509,40530,40560,40576,40638,40650,40699,40703,40714,40855,40859,40896,40897,40904,40970,40996,41004,41009,41023,41033,41046,41051,41070,41075,41078,41095,41096,41123,41134,41142,41152,41172,41176,41181,41188,41189,41190,41198,41201,41204,41212,41225,41227,41245,41251,41259,41272,41273,41284,41289,41297,41303,41313,41328,41339,41343,41370,41373,41391,41415,41434,41440,41464,41479,41503,41504,41517,41550,41571,41591,41601,41637,41660,41677,41681,41722,41726,41737,41738,41739,41757,41768,41778,41783,41811,41822,41851,41861,41862,41875,41948,41959,41964,41972,41973,41980,41981,41983,41997,42002,42010,42029,42107,42113,42124,42136,42185,42199,42205,42232,42251,42275,42282,42303,42312,42329,42353,42380,42387,42396,42427,42430,42446,42462,42478,42482,42484,42574,42590,42604,42625,42639,42682,42708,42716,42736,42768,42788,42811,42836,42890,42900,42941,42952,42991,42993,42998,43043,43050,43051,43058,43078,43083,43093,43104,43114,43116,43117,43120,43143,43167,43181,43191,43199,43221,43240,43241,43247,43248,43268,43274,43291,43300,43301,43312,43326,43335,43342,43347,43348,43360,43365,43375,43386,43398,43412,43424,43434,43443,43446,43455,43461,43468,43471,43475,43477,43507,43512,43517,43518,43527,43528,43546,43599,43612,43617,43628,43629,43647,43651,43684,43688,43700,43703,43704,43716,43725,43730,43742,43758,43792,43800,43836,43877,43883,43885,43927,43948,44003,44013,44045,44046,44049,44050,44051,44060,44062,44070,44073,44079,44094,44098,44120,44122,44128,44159,44165,44175,44186,44187,44200,44208,44229,44239,44259,44263,44282,44312,44324,44327,44338,44353,44356,44378,44379,44382,44387,44389,44392,44406,44422,44437,44447,44453,44455,44458,44479,44487,44500,44517,44521,44558,44562,44570,44581,44583,44586,44603,44609,44625,44632,44640,44656,44658,44662,44682,44683,44691,44708,44718,44735,44748,44761,44762,44785,44786,44788,44797,44807,44829,44842,44870,44873,44874,44881,44907,44912,44935,44936,44950,44964,44989,45008,45024,45050,45055,45060,45086,45106,45127,45131,45145,45147,45152,45174,45175,45183,45195,45196,45208,45209,45223,45249,45257,45274,45275,45288,45289,45291,45294,45300,45301,45304,45305,45307,45309,45311,45312,45313,45316,45317)
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 | 2107 | 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.50 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.47 ms |
System lock | 0.05 ms |
optimizing | 0.17 ms |
statistics | 5.11 ms |
preparing | 2.63 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.52 ms |
end | 0.01 ms |
query end | 0.06 ms |
closing tables | 0.02 ms |
freeing items | 0.12 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 |