Tiempo de la consulta: 5.75 ms Después de la última consulta: 1.44 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 4.541 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-05 03:37:28')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 03:37: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(11,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,81,87,88,89,110,111,125,188,189,190,192,200,205,234,246,248,249,263,271,325,353,362,412,415,416,420,421,422,423,424,426,427,429,431,484,496,501,503,531,540,574,575,579,593,599,686,785,840,841,853,862,868,971,981,986,1207,1223,1280,1342,1343,1352,1353,1357,1397,1408,1434,1455,1464,1473,1603,1718,1730,1731,1732,1803,1809,1878,1944,2014,2045,2046,2048,2053,2071,2086,2098,2108,2119,2121,2122,2208,2272,2284,2285,2300,2396,2427,2429,2463,2623,2665,2695,2719,2758,2825,2941,2958,2967,3020,3025,3051,3101,3212,3320,3321,3325,3373,3380,3410,3426,3454,3475,3487,3510,3521,3606,3650,3663,3682,3831,3984,4066,4310,4674,4699,4902,4905,5060,5189,5218,5324,5358,5391,5392,5476,5480,5538,5543,5544,5666,5685,5798,5846,5895,5934,5941,5973,6064,6136,6166,6311,6347,6392,6466,6467,6482,6539,6616,6666,6671,6776,6836,6868,6910,7017,7050,7056,7109,7124,7138,7167,7210,7287,7399,7440,7450,7692,7711,7716,7719,7730,7782,7811,7854,7933,7970,7993,8027,8149,8201,8215,8319,8353,8372,8444,8458,8483,8565,8589,8591,8602,8610,8638,8659,8681,8755,8808,8835,8856,8887,8966,9206,9262,9282,9313,9364,9411,9428,9437,9472,9605,9629,9650,9677,9678,9756,9875,9896,9924,9934,9977,10007,10035,10039,10052,10065,10134,10226,10274,10434,10483,10680,10689,10708,10764,11161,11345,11365,11476,11632,11677,11702,11917,12020,12254,12256,12324,12460,12494,12499,12520,12534,12620,12650,12669,12670,12685,12686,12708,12746,12790,12806,12913,12973,12996,13014,13016,13064,13150,13152,13294,13325,13348,13474,13475,13535,13576,13589,13644,13685,13873,13894,13898,13900,13971,13973,13975,14094,14199,14229,14293,14352,14360,14362,14431,14434,14496,14534,14536,14554,14604,14725,14860,14993,15038,15043,15045,15116,15128,15145,15148,15180,15220,15245,15261,15293,15296,15361,15382,15414,15475,15476,15520,15533,15574,15630,15714,15751,15753,15759,15785,15796,15813,15820,15844,15861,15904,15945,15972,16055,16056,16062,16071,16115,16155,16161,16176,16186,16200,16213,16263,16336,16407,16411,16412,16414,16417,16419,16434,16497,16526,16537,16543,16566,16652,16751,16820,16824,16833,16846,16876,16894,16917,16943,16950,16965,16976,17063,17109,17114,17136,17166,17198,17224,17236,17309,17317,17334,17335,17369,17385,17400,17419,17422,17496,17528,17607,17629,17630,17643,17644,17645,17652,17680,17695,17699,17702,17721,17785,17792,17798,17857,17862,17886,17946,17949,17965,17976,17977,18006,18021,18035,18036,18045,18071,18073,18081,18106,18124,18133,18151,18168,18171,18191,18213,18220,18241,18253,18259,18260,18300,18308,18309,18318,18347,18354,18360,18413,18426,18458,18473,18491,18497,18500,18537,18540,18558,18575,18578,18605,18635,18638,18643,18746,18751,18757,18789,18790,18795,18819,18821,18822,18828,18868,18911,18917,18918,18939,18952,18989,19005,19079,19082,19160,19190,19234,19235,19259,19263,19267,19282,19288,19301,19310,19320,19381,19390,19432,19460,19484,19495,19523,19531,19551,19561,19593,19594,19627,19650,19661,19668,19684,19695,19696,19710,19723,19733,19751,19772,19791,19824,19825,19832,19876,19877,19886,19888,19923,19931,19935,19937,19939,19957,19962,19980,19982,19988,19989,20008,20017,20060,20075,20085,20095,20120,20147,20150,20157,20169,20176,20187,20188,20192,20193,20211,20213,20220,20264,20277,20298,20307,20308,20310,20340,20343,20391,20401,20410,20421,20439,20442,20459,20481,20484,20503,20550,20567,20572,20595,20601,20616,20626,20630,20648,20699,20700,20705,20709,20713,20714,20727,20752,20782,20808,20813,20825,20830,20833,20837,20847,20862,20865,20871,20881,20883,20899,20907,20910,20920,20925,20954,20973,20990,21002,21012,21016,21021,21033,21038,21042,21047,21050,21059,21069,21080,21090,21094,21107,21122,21132,21134,21159,21169,21204,21230,21256,21262,21273,21279,21283,21285,21288,21300,21338,21368,21397,21410,21425,21441,21464,21466,21474,21485,21486,21491,21504,21524,21526,21529,21543,21547,21560,21563,21574,21581,21618,21623,21640,21641,21650,21660,21661,21664,21665,21670,21683,21688,21690,21695,21699,21704,21719,21727,21738,21756,21764,21796,21800,21810,21824,21825,21834,21837,21843,21850,21853,21902,21910,21926,21954,21955,21958,21960,21962,21967,21976,21977,22015,22017,22018,22034,22050,22062,22073,22077,22081,22085,22112,22117,22125,22149,22162,22163,22164,22191,22195,22197,22204,22208,22212,22218,22221,22241,22242,22278,22281,22292,22302,22305,22321,22324,22353,22384,22394,22405,22406,22421,22445,22446,22453,22484,22494,22502,22512,22514,22522,22544,22545,22554,22580,22590,22603,22606,22620,22622,22626,22646,22654,22655,22658,22659,22707,22710,22716,22727,22737,22745,22757,22759,22765,22768,22780,22787,22795,22804,22816,22829,22833,22838,22865,22867,22889,22894,22897,22909,22919,22923,22925,22938,22947,22958,22966,22968,22970,22971,22972,22991,22997,23001,23003,23007,23017,23024,23035,23043,23051,23053,23062,23063,23070,23082,23085,23089,23095,23097,23117,23124,23132,23135,23136,23179,23201,23214,23216,23217,23230,23239,23257,23280,23295,23302,23317,23320,23345,23348,23349,23351,23352,23359,23383,23396,23420,23453,23454,23480,23486,23512,23528,23532,23544,23556,23560,23571,23582,23600,23605,23609,23627,23631,23649,23659,23662,23665,23680,23681,23685,23712,23716,23772,23800,23806,23811,23813,23814,23826,23847,23851,23854,23927,23945,23947,23951,23953,23961,23963,23975,23999,24016,24045,24055,24071,24112,24120,24127,24139,24165,24169,24189,24203,24204,24206,24213,24223,24226,24244,24245,24246,24249,24307,24333,24385,24393,24401,24408,24410,24414,24425,24426,24475,24481,24483,24502,24513,24522,24549,24560,24582,24583,24617,24628,24644,24651,24681,24694,24730,24750,24796,24800,24803,24824,24848,24861,24865,24877,24878,24896,24911,24925,24937,24941,24956,24966,24967,24969,24973,24977,24993,25021,25025,25030,25031,25035,25053,25057,25061,25062,25089,25118,25127,25129,25131,25138,25171,25176,25210,25243,25287,25296,25318,25351,25368,25369,25372,25378,25396,25399,25406,25407,25424,25436,25440,25448,25458,25460,25506,25517,25518,25520,25523,25524,25525,25528,25536,25541,25542,25551,25552,25568,25582,25584,25591,25596,25646,25649,25660,25702,25775,25779,25781,25844,25863,25874,25904,25941,25962,25983,25992,25995,26000,26010,26033,26044,26056,26082,26087,26147,26164,26172,26201,26221,26241,26260,26271,26283,26295,26296,26317,26318,26320,26337,26343,26351,26354,26360,26362,26366,26371,26387,26391,26395,26415,26424,26454,26474,26491,26588,26613,26651,26677,26694,26713,26734,26742,26751,26756,26796,26801,26814,26820,26845,26881,26905,26907,26918,26929,26944,26947,26956,26963,26968,26973,26999,27000,27038,27048,27057,27086,27109,27116,27119,27124,27126,27137,27139,27156,27187,27242,27252,27281,27282,27302,27330,27360,27366,27408,27425,27530,27551,27622,27655,27688,27722,27803,27806,27818,27846,27860,27875,27958,27992,28030,28072,28080,28091,28117,28193,28241,28281,28328,28339,28429,28440,28442,28458,28504,28555,28614,28615,28616,28683,28691,28703,28712,28728,28845,28944,29054,29063,29108,29159,29298,29320,29460,29619,29630,29635,29714,29720,29746,29920,30231,30284,30761,31623,31624,32642,32643,32644,32679,33065,33417,33750,33954,33955,33956,34016,34047,34177,34180,34189,34205,34251,34377,34391,34417,34443,34483,34489,34502,34520,34548,34639,34690,34832,34888,34935,34959,35010,35094,35175,35185,35205,35300,35310,35314,35330,35392,35557,35581,35657,35658,35713,35744,35773,35847,35876,35902,35930,35936,35955,35959,35982,36031,36066,36227,36298,36437,36499,36531,36608,36688,36714,36759,36813,36828,36888,36893,36916,36957,36985,36990,37020,37024,37137,37344,37357,37365,37521,37534,37543,37544,37579,37642,37669,37693,37710,37731,37734,37740,37767,37787,37802,37844,37852,37853,37876,37932,37953,37999,38060,38185,38238,38329,38346,38361,38370,38409,38430,38506,38512,38520,38567,38588,38623,38734,38752,38764,38781,38809,38810,38837,38851,38861,38888,38956,38961,39019,39023,39070,39117,39160,39185,39212,39346,39398,39415,39416,39439,39491,39530,39582,39649,39670,39736,39757,39767,39838,39849,39932,39934,39993,40003,40036,40072,40073,40094,40104,40195,40302,40306,40345,40370,40379,40431,40492,40494,40505,40508,40605,40638,40699,40714,40866,40897,40904,40970,40996,41023,41046,41051,41075,41078,41089,41096,41142,41181,41185,41190,41227,41245,41251,41259,41273,41284,41297,41303,41313,41370,41373,41391,41440,41517,41660,41722,41726,41738,41739,41768,41811,41822,41851,41868,41875,41959,41972,41973,41981,41983,41997,42002,42010,42029,42035,42113,42124,42136,42199,42232,42251,42275,42282,42303,42353,42380,42427,42430,42446,42462,42478,42484,42574,42604,42625,42768,42788,42899,42900,42908,43058,43083,43116,43143,43181,43199,43268,43312,43342,43347,43348,43434,43443,43455,43468,43471,43507,43512,43527,43581,43612,43617,43628,43629,43647,43684,43703,43704,43730,43742,43758,43800,43836,43877,43883,43906,43927,44003,44045,44049,44050,44070,44073,44098,44239,44259,44338,44353,44356,44379,44389,44392,44437,44455,44521,44558,44570,44586,44603,44625,44658,44682,44683,44691,44708,44748,44830,44842,44874,44907,44964,44989,45008,45055,45060,45147,45195,45289,45301,45311)
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 | 1555 | 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.71 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.29 ms |
System lock | 0.02 ms |
optimizing | 0.10 ms |
statistics | 2.36 ms |
preparing | 1.17 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.31 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 |