Tiempo de la consulta: 7.45 ms Después de la última consulta: 1.99 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.407 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 22:56:44')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 22:56:44')
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,177,186,188,189,198,202,212,214,215,220,221,254,260,263,279,310,330,353,354,356,357,358,359,360,361,363,364,394,417,418,452,460,477,500,530,655,660,686,723,736,756,757,765,793,830,965,1007,1020,1045,1051,1067,1080,1090,1104,1120,1143,1198,1207,1214,1237,1249,1294,1308,1316,1324,1336,1342,1343,1357,1363,1376,1386,1397,1439,1504,1505,1507,1512,1519,1543,1556,1557,1627,1644,1718,1740,1745,1762,1800,1818,1904,1909,1914,1979,2027,2047,2048,2053,2062,2063,2086,2088,2092,2105,2108,2122,2137,2142,2155,2156,2189,2190,2241,2282,2288,2322,2431,2465,2482,2532,2551,2571,2581,2630,2687,2689,2710,2721,2746,2757,2767,2795,2818,2858,2906,2939,2964,2983,3027,3038,3039,3059,3067,3081,3086,3130,3132,3145,3169,3207,3224,3240,3251,3294,3379,3396,3442,3463,3489,3512,3554,3570,3571,3606,3621,3632,3673,3682,3703,3721,3727,3761,3834,3850,3974,3984,4007,4068,4144,4166,4171,4200,4263,4285,4301,4310,4326,4370,4378,4422,4490,4510,4580,4626,4651,4691,4723,4767,4852,4863,4874,4907,4944,5018,5045,5055,5096,5132,5136,5164,5182,5183,5218,5229,5302,5367,5369,5371,5373,5446,5449,5451,5466,5537,5540,5544,5566,5579,5580,5581,5597,5616,5628,5631,5647,5659,5729,5731,5778,5798,5841,5854,5865,5894,5895,5931,6011,6017,6043,6045,6081,6112,6119,6135,6173,6253,6264,6274,6350,6405,6457,6476,6477,6479,6514,6516,6527,6541,6573,6601,6614,6645,6665,6690,6727,6733,6766,6827,6854,6939,6944,7010,7026,7048,7064,7127,7135,7138,7139,7143,7183,7191,7192,7193,7210,7284,7324,7365,7380,7387,7401,7402,7419,7437,7447,7453,7491,7521,7527,7592,7595,7601,7627,7629,7651,7664,7718,7730,7741,7751,7753,7760,7776,7795,7822,7850,7852,7854,7944,7950,7965,7986,7998,8001,8027,8067,8080,8084,8090,8093,8102,8120,8125,8164,8212,8338,8353,8356,8372,8501,8512,8525,8528,8546,8602,8618,8634,8635,8638,8659,8665,8666,8679,8682,8707,8776,8778,8808,8809,8823,8970,8974,9029,9050,9066,9067,9087,9200,9204,9219,9276,9282,9310,9311,9318,9350,9360,9367,9377,9387,9408,9460,9469,9488,9503,9515,9554,9571,9601,9616,9679,9699,9743,9745,9785,9827,9828,9830,9833,9854,9864,9871,9886,9893,9924,9930,9932,9947,9992,10004,10023,10043,10078,10108,10196,10226,10239,10263,10286,10314,10322,10329,10345,10364,10380,10416,10503,10572,10577,10582,10601,10665,10671,10686,10705,10708,10720,10738,10764,10768,10964,10980,10989,11001,11010,11029,11114,11119,11152,11191,11204,11209,11219,11265,11320,11408,11446,11523,11542,11594,11636,11678,11728,11754,11806,11835,11854,11891,11898,11906,11948,11954,12031,12078,12116,12125,12171,12200,12217,12224,12230,12256,12259,12271,12309,12367,12372,12389,12508,12546,12550,12563,12571,12578,12593,12595,12600,12605,12625,12654,12670,12678,12684,12708,12729,12737,12746,12748,12759,12789,12790,12791,12806,12840,12856,12872,12879,12882,12888,12895,12900,12902,12903,12906,12909,12910,12911,12912,12913,12914,12915,12949,12958,12989,13005,13014,13016,13017,13019,13027,13126,13140,13186,13246,13264,13266,13289,13321,13328,13344,13350,13444,13457,13488,13516,13542,13562,13571,13602,13615,13618,13645,13653,13702,13748,13760,13806,13860,13861,13874,13896,13916,13971,13990,14000,14037,14074,14077,14142,14152,14185,14205,14206,14219,14227,14240,14242,14243,14249,14269,14280,14292,14316,14331,14371,14401,14425,14440,14476,14488,14504,14508,14528,14591,14613,14638,14655,14660,14665,14666,14693,14703,14754,14807,14810,14830,14837,14846,14849,14850,14902,14964,14976,14993,15000,15038,15055,15062,15070,15079,15084,15154,15161,15171,15174,15203,15206,15235,15268,15278,15330,15331,15353,15366,15372,15380,15391,15438,15440,15470,15471,15473,15494,15500,15520,15522,15533,15542,15576,15579,15606,15678,15691,15707,15717,15739,15781,15785,15806,15819,15820,15827,15832,15835,15836,15844,15848,15866,15871,15875,15885,15896,15899,15905,15915,15939,15940,15953,15955,15967,15985,16017,16022,16056,16062,16091,16102,16156,16168,16208,16228,16230,16231,16245,16262,16286,16297,16337,16381,16382,16385,16386,16412,16414,16422,16435,16454,16462,16467,16472,16475,16479,16513,16541,16556,16568,16588,16619,16620,16621,16643,16646,16671,16689,16706,16722,16723,16790,16791,16800,16808,16809,16816,16818,16830,16838,16858,16876,16912,16922,16943,16998,17000,17037,17069,17090,17092,17123,17130,17132,17151,17166,17168,17173,17192,17222,17224,17230,17250,17276,17282,17283,17290,17301,17307,17310,17321,17333,17337,17357,17360,17361,17372,17377,17391,17401,17408,17422,17426,17442,17458,17465,17474,17500,17551,17571,17587,17600,17611,17626,17630,17643,17644,17678,17679,17680,17708,17710,17735,17757,17763,17777,17783,17806,17807,17817,17835,17839,17850,17856,17862,17863,17869,17875,17880,17882,17902,17905,17947,17965,17995,18005,18009,18022,18035,18036,18046,18047,18050,18071,18079,18097,18108,18122,18140,18142,18151,18169,18176,18194,18216,18220,18225,18226,18244,18253,18260,18264,18279,18295,18308,18332,18334,18347,18360,18376,18388,18406,18424,18435,18439,18462,18494,18520,18522,18537,18544,18554,18576,18583,18588,18598,18609,18629,18631,18649,18653,18659,18665,18668,18670,18682,18695,18700,18715,18718,18754,18769,18775,18784,18822,18832,18845,18855,18859,18861,18864,18868,18874,18885,18908,18912,18920,18930,18933,18949,18953,18978,18982,18989,18992,18995,19010,19018,19019,19022,19037,19042,19047,19056,19061,19062,19071,19073,19086,19104,19110,19135,19168,19181,19219,19237,19269,19282,19283,19289,19299,19300,19304,19320,19322,19326,19327,19346,19362,19367,19388,19390,19404,19412,19423,19426,19438,19449,19452,19462,19470,19496,19507,19516,19532,19538,19539,19551,19569,19581,19582,19591,19607,19624,19626,19652,19657,19668,19677,19694,19695,19697,19699,19719,19726,19760,19774,19795,19796,19800,19825,19826,19830,19833,19835,19837,19856,19888,19898,19904,19912,19913,19918,19921,19923,19937,19938,19943,19950,19959,19973,19984,20001,20026,20030,20039,20044,20064,20109,20111,20127,20152,20153,20167,20180,20184,20188,20189,20192,20194,20204,20210,20213,20215,20217,20220,20232,20236,20243,20264,20277,20278,20293,20295,20304,20306,20337,20340,20341,20354,20358,20360,20363,20370,20385,20439,20440,20442,20459,20467,20484,20488,20502,20525,20526,20529,20539,20543,20546,20564,20579,20600,20617,20621,20626,20632,20635,20647,20653,20658,20661,20663,20678,20683,20686,20693,20695,20709,20713,20726,20731,20736,20749,20750,20803,20804,20813,20821,20831,20833,20839,20840,20842,20843,20851,20858,20860,20865,20871,20873,20879,20880,20883,20910,20919,20920,20921,20925,20949,20954,20956,20967,20986,20988,20997,20999,21004,21006,21011,21027,21040,21041,21047,21049,21057,21063,21069,21070,21103,21104,21116,21123,21126,21135,21151,21158,21165,21166,21167,21172,21183,21185,21195,21202,21204,21213,21221,21225,21233,21236,21241,21250,21252,21260,21261,21263,21272,21282,21283,21296,21301,21313,21315,21347,21356,21365,21376,21377,21378,21394,21400,21402,21416,21419,21427,21430,21432,21436,21441,21452,21453,21467,21472,21483,21490,21493,21504,21508,21510,21524,21529,21534,21539,21556,21557,21566,21579,21589,21590,21593,21618,21623,21633,21641,21659,21661,21664,21667,21695,21721,21724,21727,21735,21748,21757,21760,21761,21767,21775,21799,21816,21834,21853,21856,21858,21871,21875,21880,21887,21888,21889,21901,21907,21912,21913,21926,21929,21954,21955,21969,21971,21988,21996,21999,22014,22032,22071,22085,22100,22106,22112,22117,22153,22162,22167,22171,22174,22178,22195,22204,22206,22208,22215,22235,22236,22251,22263,22283,22298,22300,22302,22324,22331,22339,22343,22350,22361,22362,22363,22372,22392,22397,22402,22406,22411,22412,22421,22427,22443,22455,22476,22496,22511,22514,22523,22527,22528,22530,22531,22533,22539,22544,22550,22551,22555,22564,22567,22568,22582,22588,22603,22620,22655,22669,22671,22674,22682,22693,22696,22703,22707,22709,22710,22713,22726,22727,22738,22743,22747,22750,22753,22758,22769,22779,22780,22800,22813,22820,22829,22831,22832,22835,22847,22852,22854,22856,22873,22883,22887,22900,22902,22918,22939,22941,22947,22971,22974,22976,22979,22989,22990,23007,23013,23023,23024,23033,23050,23064,23087,23089,23091,23118,23149,23173,23179,23182,23190,23200,23202,23218,23224,23230,23240,23249,23258,23261,23262,23264,23265,23281,23292,23299,23304,23310,23334,23340,23348,23354,23355,23360,23366,23378,23379,23380,23391,23396,23400,23416,23428,23429,23430,23446,23449,23455,23458,23464,23469,23476,23498,23502,23512,23516,23536,23542,23546,23549,23556,23569,23573,23586,23589,23591,23602,23612,23616,23625,23648,23655,23659,23665,23676,23693,23705,23707,23708,23719,23757,23759,23765,23793,23804,23806,23814,23825,23829,23836,23847,23850,23851,23853,23855,23856,23861,23863,23873,23874,23876,23880,23898,23905,23939,23940,23943,23951,23977,23992,23996,24003,24010,24011,24015,24021,24033,24040,24044,24067,24069,24070,24072,24082,24089,24099,24101,24103,24117,24120,24122,24125,24126,24135,24140,24148,24156,24160,24169,24181,24189,24197,24199,24203,24208,24211,24219,24240,24245,24247,24251,24261,24265,24268,24286,24306,24319,24329,24340,24346,24352,24360,24375,24376,24382,24393,24406,24408,24429,24451,24472,24473,24474,24483,24484,24487,24496,24503,24505,24506,24508,24512,24519,24526,24540,24560,24563,24564,24569,24570,24577,24578,24597,24598,24624,24629,24643,24649,24663,24676,24681,24682,24689,24706,24709,24711,24713,24721,24722,24729,24746,24754,24756,24759,24764,24772,24788,24790,24797,24802,24832,24855,24856,24865,24880,24881,24883,24908,24911,24918,24925,24926,24935,24937,24953,24956,24968,24971,24973,24980,24984,24992,24993,24996,25004,25005,25006,25044,25048,25052,25057,25062,25072,25073,25105,25120,25122,25127,25136,25163,25175,25180,25182,25188,25198,25209,25215,25255,25267,25270,25273,25288,25294,25322,25323,25330,25363,25364,25382,25383,25401,25407,25424,25426,25428,25439,25448,25456,25457,25458,25471,25486,25495,25497,25505,25509,25514,25523,25536,25537,25539,25546,25554,25558,25559,25565,25568,25587,25610,25628,25632,25648,25653,25665,25671,25679,25682,25729,25756,25764,25790,25799,25813,25821,25859,25864,25870,25891,25909,25925,25929,25935,25955,25966,25992,26014,26043,26044,26047,26073,26103,26105,26117,26118,26134,26162,26172,26204,26221,26229,26237,26239,26240,26259,26283,26296,26320,26321,26344,26362,26366,26381,26386,26389,26392,26405,26420,26426,26431,26432,26437,26469,26480,26524,26535,26541,26597,26603,26617,26634,26639,26651,26665,26680,26709,26712,26750,26769,26810,26818,26923,26926,26936,26948,26957,26975,26999,27038,27042,27057,27091,27109,27137,27143,27153,27170,27192,27198,27200,27209,27211,27213,27216,27252,27262,27301,27307,27353,27372,27406,27407,27496,27545,27571,27644,27677,27738,27776,27803,27985,28006,28120,28163,28256,28319,28458,28465,28470,28555,28627,28662,28680,28681,28682,28683,28702,28710,28781,28844,28847,28858,28867,28910,28912,28918,28936,28960,29033,29064,29071,29087,29129,29133,29142,29144,29249,29335,29379,29417,29571,29646,29727,29928,30050,30318,30790,31623,31624,32679,34008,34290,34316,34382,34384,34385,34470,34531,34645,34804,34813,35275,35590,35696,35826,35869,35885,35983,36067,36068,36104,36113,36232,36234,36302,36306,36323,36406,36476,36477,36543,36618,36684,37056,37210,37408,37475,37582,37602,38079,38131,38206,38506,38602,38639,38713,38910,39088,39104,39135,39180,39183,39204,39370,39411,39433,39463,39469,39495,39507,39508,39543,39750,39926,39966,40116,40167,40238,40311,40352,40369,40471,40540,40583,40659,40720,40798,40808,40865,40904,41013,41140,41241,41257,41298,41354,41444,41456,41486,41543,41662,41695,41696,41756,41779,41853,41911,41993,42009,42024,42025,42036,42044,42067,42080,42094,42187,42274,42282,42395,42408,42412,42484,42492,42531,42651,42676,42730,42732,42736,42745,42797,42932,42950,43052,43068,43152,43153,43213,43214,43215,43488,43576,43595,43685,43765,43858,43864,43865,43877,43988,44142,44916,44945,45001,45069)
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 | 2019 | 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.97 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.39 ms |
System lock | 0.02 ms |
optimizing | 0.14 ms |
statistics | 3.26 ms |
preparing | 1.74 ms |
Sorting result | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.38 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.08 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 |