Tiempo de la consulta: 6.95 ms Después de la última consulta: 1.65 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.394 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 13:00:24')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 13:00:24')
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,29,45,46,54,62,65,71,129,177,186,188,189,198,202,212,214,215,220,221,254,260,310,330,394,415,417,418,452,530,643,659,660,764,830,1059,1104,1200,1249,1294,1316,1335,1347,1357,1376,1397,1413,1504,1505,1507,1512,1519,1543,1563,1571,1627,1644,1740,1748,1800,1904,1979,2027,2047,2048,2053,2063,2084,2086,2088,2092,2122,2137,2142,2155,2189,2190,2194,2241,2288,2431,2465,2482,2532,2551,2573,2581,2687,2689,2710,2746,2757,2795,2906,2909,3027,3038,3059,3067,3081,3086,3130,3196,3207,3224,3240,3251,3266,3379,3512,3554,3571,3606,3621,3632,3685,3703,3721,3727,3737,3760,3767,3776,3780,3833,3850,3913,3960,4007,4034,4068,4101,4110,4129,4144,4148,4150,4166,4171,4204,4263,4284,4299,4301,4323,4327,4370,4423,4456,4490,4510,4548,4575,4580,4626,4651,4767,4852,4859,4940,4944,5018,5045,5055,5096,5132,5164,5183,5218,5229,5259,5367,5369,5387,5422,5544,5581,5686,5854,5865,5894,5895,5909,5931,6011,6045,6081,6100,6112,6119,6128,6135,6173,6253,6264,6274,6360,6362,6405,6440,6457,6476,6477,6479,6527,6534,6604,6649,6657,6720,6733,6766,6827,6865,6881,6939,7010,7048,7064,7077,7111,7143,7216,7250,7258,7324,7331,7364,7389,7444,7491,7527,7586,7592,7595,7601,7605,7614,7618,7651,7724,7751,7752,7760,7771,7784,7787,7795,7822,7854,7903,7925,7935,7942,8001,8004,8055,8080,8084,8119,8152,8160,8164,8227,8234,8238,8265,8353,8356,8370,8372,8378,8421,8501,8507,8512,8546,8550,8602,8611,8634,8644,8659,8660,8679,8682,8700,8707,8750,8753,8778,8799,8808,8809,8813,8826,8864,8925,8954,8970,9050,9063,9066,9067,9087,9120,9150,9204,9215,9219,9276,9282,9310,9311,9328,9350,9360,9363,9367,9387,9390,9408,9460,9469,9477,9488,9503,9515,9554,9571,9578,9600,9601,9610,9679,9688,9699,9738,9743,9745,9785,9827,9828,9829,9830,9836,9838,9864,9871,9878,9886,9893,9904,9908,9922,9930,9932,9947,9956,9992,10004,10043,10073,10122,10190,10196,10263,10265,10269,10286,10313,10322,10329,10364,10414,10448,10513,10520,10577,10582,10617,10642,10671,10703,10705,10708,10720,10732,10754,10756,10764,10993,11010,11023,11031,11041,11073,11114,11119,11121,11209,11250,11279,11286,11338,11387,11408,11488,11545,11551,11594,11636,11687,11728,11796,11854,11891,11898,11906,11921,12187,12217,12230,12249,12256,12271,12372,12389,12508,12550,12553,12565,12578,12593,12595,12600,12632,12634,12638,12657,12684,12689,12690,12699,12708,12729,12746,12748,12759,12789,12790,12806,12840,12879,12882,12888,12900,12903,12906,12909,12910,12911,12912,12913,12914,12915,12944,12949,12958,13005,13014,13027,13126,13146,13166,13186,13209,13246,13264,13266,13321,13328,13376,13385,13457,13498,13562,13702,13731,13738,13748,13760,13789,13860,13896,13946,13961,13971,13996,14005,14074,14077,14141,14142,14185,14206,14242,14305,14316,14331,14351,14396,14425,14440,14488,14504,14510,14512,14513,14515,14528,14532,14601,14616,14624,14655,14660,14662,14666,14684,14703,14730,14739,14807,14810,14820,14824,14825,14902,14939,14964,14976,14993,14999,15000,15005,15006,15038,15041,15052,15055,15060,15062,15069,15070,15081,15084,15148,15154,15160,15161,15171,15178,15193,15196,15203,15206,15226,15235,15268,15326,15330,15347,15380,15388,15389,15391,15423,15457,15465,15470,15471,15473,15482,15487,15500,15522,15533,15542,15551,15564,15570,15576,15606,15611,15617,15636,15637,15640,15678,15691,15707,15738,15767,15781,15783,15785,15806,15819,15820,15827,15832,15841,15844,15848,15866,15871,15875,15876,15905,15913,15915,15940,15955,15956,15967,15985,16017,16036,16039,16042,16056,16059,16082,16084,16097,16102,16127,16129,16156,16181,16190,16208,16228,16230,16231,16245,16248,16256,16262,16289,16292,16297,16314,16315,16337,16381,16382,16385,16403,16412,16415,16422,16435,16454,16462,16467,16474,16475,16479,16513,16527,16552,16556,16568,16577,16588,16605,16619,16620,16643,16660,16689,16706,16715,16722,16759,16790,16791,16800,16828,16830,16838,16858,16876,16890,16896,16912,16922,16991,17037,17053,17074,17102,17115,17130,17145,17151,17160,17166,17168,17173,17192,17216,17233,17250,17276,17282,17283,17291,17301,17310,17333,17337,17349,17357,17360,17372,17377,17408,17422,17423,17442,17458,17465,17468,17474,17533,17541,17551,17587,17600,17619,17626,17633,17643,17644,17650,17678,17680,17757,17806,17807,17812,17835,17844,17850,17855,17856,17859,17862,17863,17875,17880,17888,17893,17902,17905,17926,17939,17965,17966,17995,17998,18005,18022,18035,18036,18046,18047,18050,18054,18062,18108,18122,18140,18151,18157,18169,18180,18194,18197,18225,18233,18244,18255,18274,18276,18292,18314,18334,18344,18347,18362,18376,18435,18439,18460,18462,18537,18539,18544,18564,18576,18583,18588,18608,18609,18629,18631,18649,18659,18665,18670,18695,18709,18715,18730,18735,18754,18769,18775,18782,18784,18796,18800,18832,18845,18846,18859,18862,18868,18874,18878,18885,18908,18916,18922,18930,18931,18933,18949,18953,18954,18975,18978,18980,18989,18992,19019,19028,19034,19037,19042,19056,19061,19062,19071,19073,19104,19105,19124,19128,19135,19155,19168,19218,19219,19237,19240,19247,19269,19282,19283,19289,19299,19300,19313,19320,19322,19327,19346,19362,19366,19390,19412,19423,19426,19438,19452,19462,19470,19516,19530,19532,19538,19539,19550,19551,19561,19569,19582,19591,19604,19607,19626,19637,19652,19668,19694,19695,19699,19713,19719,19732,19760,19794,19795,19796,19800,19825,19830,19833,19835,19837,19841,19852,19856,19872,19888,19898,19904,19911,19923,19937,19938,19943,19945,19950,19954,19959,19984,20001,20018,20026,20030,20039,20044,20064,20098,20111,20127,20152,20153,20167,20188,20189,20192,20197,20204,20210,20213,20215,20220,20232,20236,20243,20250,20260,20264,20268,20278,20293,20295,20306,20327,20337,20340,20341,20348,20358,20363,20376,20385,20393,20429,20439,20442,20444,20459,20461,20484,20502,20526,20527,20539,20543,20600,20602,20617,20621,20632,20649,20653,20658,20661,20663,20683,20686,20688,20693,20695,20699,20709,20713,20726,20741,20750,20779,20796,20797,20804,20813,20821,20828,20831,20833,20839,20840,20842,20843,20850,20851,20858,20860,20871,20873,20879,20880,20883,20906,20910,20915,20920,20921,20925,20949,20954,20956,20959,20967,20984,20997,20999,21000,21006,21027,21040,21041,21047,21049,21057,21062,21063,21069,21070,21103,21104,21107,21108,21126,21143,21161,21165,21166,21172,21182,21185,21190,21195,21204,21213,21221,21233,21236,21241,21243,21249,21250,21261,21282,21283,21296,21313,21315,21325,21356,21365,21369,21377,21378,21381,21397,21402,21430,21432,21434,21435,21436,21441,21452,21453,21458,21464,21472,21483,21489,21504,21508,21524,21539,21552,21554,21557,21566,21575,21578,21579,21586,21588,21590,21593,21618,21623,21641,21661,21664,21667,21695,21710,21724,21727,21740,21744,21748,21757,21760,21761,21764,21767,21775,21776,21777,21799,21834,21853,21855,21858,21871,21875,21880,21883,21887,21888,21889,21894,21901,21907,21913,21926,21929,21944,21955,21969,21971,21976,21982,21988,21996,22010,22014,22032,22040,22063,22080,22085,22106,22112,22117,22153,22160,22162,22167,22171,22176,22195,22204,22206,22208,22214,22215,22235,22236,22237,22283,22297,22298,22300,22302,22313,22324,22331,22339,22347,22348,22350,22361,22362,22363,22371,22372,22392,22397,22402,22406,22407,22411,22427,22443,22459,22461,22476,22511,22514,22523,22527,22528,22530,22531,22533,22539,22544,22550,22551,22564,22567,22568,22574,22582,22588,22603,22617,22620,22640,22647,22655,22671,22674,22693,22703,22707,22709,22710,22726,22727,22733,22738,22739,22743,22745,22750,22753,22758,22763,22769,22779,22780,22800,22813,22819,22829,22831,22832,22835,22837,22847,22852,22854,22856,22873,22887,22889,22890,22902,22904,22918,22939,22941,22947,22957,22971,22976,22989,22990,23007,23013,23023,23024,23033,23050,23064,23065,23067,23087,23089,23091,23131,23149,23157,23173,23179,23182,23185,23190,23195,23200,23201,23202,23205,23218,23224,23230,23237,23241,23258,23260,23261,23262,23264,23265,23280,23281,23283,23299,23310,23313,23314,23320,23325,23326,23328,23334,23335,23339,23340,23348,23354,23360,23366,23379,23380,23391,23396,23400,23416,23417,23429,23449,23455,23464,23469,23476,23498,23512,23516,23536,23542,23549,23556,23569,23573,23582,23591,23602,23625,23632,23659,23678,23679,23705,23708,23757,23765,23791,23793,23804,23814,23829,23836,23847,23850,23851,23853,23855,23856,23861,23873,23874,23876,23880,23890,23898,23905,23939,23940,23943,23977,23992,23996,24003,24010,24011,24015,24021,24033,24040,24044,24067,24069,24070,24075,24089,24101,24102,24103,24104,24110,24117,24120,24122,24125,24126,24140,24148,24152,24156,24160,24169,24181,24189,24191,24197,24199,24203,24208,24211,24219,24240,24245,24247,24251,24261,24265,24268,24273,24274,24286,24306,24319,24327,24329,24346,24352,24360,24366,24371,24375,24376,24377,24382,24392,24406,24408,24429,24430,24472,24473,24474,24483,24484,24487,24496,24503,24506,24508,24510,24512,24519,24526,24540,24560,24563,24564,24569,24570,24577,24578,24592,24597,24598,24629,24643,24644,24649,24663,24676,24681,24682,24689,24711,24713,24722,24727,24733,24746,24759,24764,24772,24788,24797,24802,24816,24832,24837,24844,24855,24856,24865,24880,24881,24899,24908,24911,24918,24925,24926,24935,24937,24956,24964,24971,24973,24980,24984,24992,24993,25004,25005,25006,25044,25052,25057,25062,25072,25073,25076,25098,25105,25107,25122,25125,25127,25133,25136,25163,25180,25182,25198,25209,25225,25253,25255,25267,25294,25322,25323,25363,25364,25377,25380,25382,25383,25401,25407,25424,25426,25439,25448,25456,25457,25458,25495,25505,25509,25523,25536,25537,25546,25554,25558,25559,25568,25587,25610,25628,25632,25644,25645,25653,25665,25682,25714,25730,25748,25756,25785,25788,25850,25868,25870,25891,25925,25929,25966,25992,25993,26014,26030,26044,26047,26073,26103,26105,26118,26131,26162,26172,26178,26183,26193,26229,26237,26256,26259,26273,26283,26296,26320,26321,26344,26362,26381,26386,26389,26392,26405,26426,26432,26437,26493,26501,26504,26521,26524,26563,26597,26617,26648,26665,26680,26712,26810,26816,26818,26901,26914,26925,26926,26948,26957,26972,26975,26999,27002,27011,27038,27042,27109,27137,27150,27153,27170,27192,27198,27200,27209,27211,27213,27216,27246,27252,27273,27301,27306,27307,27316,27321,27353,27402,27407,27418,27431,27496,27521,27545,27556,27593,27644,27679,27686,27704,27721,27776,27803,27827,27842,27890,27917,27931,27936,28005,28033,28045,28082,28225,28312,28319,28411,28458,28470,28555,28639,28653,28658,28683,28858,28867,28910,28912,28918,28936,28960,28989,29008,29009,29033,29071,29087,29142,29144,29152,29153,29174,29197,29249,29319,29335,29356,29417,29443,29444,29476,29625,29646,29760,29781,29791,29811,29905,29922,29923,29928,29935,31623,31624,32679,32768,32842,33878,34008,34382,35275,35617,35689,35696,35826,35883,35885,35983,36067,36068,36104,36113,36306,36406,36999,37056,37210,37408,37475,38122,38128,38490,38506,38807,38831,38854,38866,39180,39181,39463,39469,39481,39495,39543,39603,39681,39750,39857,39966,40025,40038,40083,40097,40167,40170,40184,40200,40348,40369,40471,40528,40601,40708,40759,40785,40798,40809,40907,40937,40955,40984,41059,41241,41255,41257,41301,41325,41375,41444,41777,41784,41879,42024,42025,42036,42067,42408,43052,43106,43265,44295,44988)
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 | 1893 | 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.95 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
init | 0.34 ms |
System lock | 0.02 ms |
optimizing | 0.12 ms |
statistics | 2.98 ms |
preparing | 1.44 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.38 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 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 |