Tiempo de la consulta: 11.17 ms Después de la última consulta: 1.31 ms Consulta a la memoria: 0.635 MB memoria antes de la consulta: 4.556 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-07 17:34:17')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 17:34:17')
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(13,30,35,51,82,132,183,184,197,213,263,308,317,323,328,350,354,385,393,407,495,565,576,668,670,679,693,739,769,780,808,827,870,883,885,902,935,988,1050,1061,1065,1183,1196,1198,1231,1280,1354,1422,1455,1503,1533,1535,1603,1623,1634,1646,1679,1713,1796,1800,1802,1804,1822,1900,1902,1913,1944,1982,2010,2013,2027,2046,2047,2109,2146,2217,2224,2228,2260,2302,2305,2337,2367,2372,2378,2415,2424,2598,2600,2601,2613,2632,2636,2668,2689,2705,2756,2797,2805,2807,2859,2933,2967,2993,3000,3065,3067,3087,3108,3125,3212,3216,3236,3264,3288,3337,3373,3381,3408,3426,3480,3511,3663,3664,3718,3719,3725,3757,3825,3832,3871,3975,4033,4131,4132,4133,4243,4253,4320,4339,4392,4473,4503,4670,4770,4775,4799,4817,4832,4836,4868,4872,4910,4947,4957,4990,5086,5104,5150,5170,5173,5224,5237,5268,5300,5457,5559,5570,5615,5679,5686,5796,5798,5814,5855,5913,5934,6037,6039,6131,6150,6166,6256,6264,6268,6270,6275,6277,6288,6331,6427,6440,6470,6473,6516,6548,6571,6573,6577,6665,6711,6735,6775,6830,6845,6868,6897,6910,6917,6985,7081,7205,7214,7283,7290,7330,7357,7358,7389,7396,7416,7482,7526,7528,7586,7624,7633,7659,7674,7704,7712,7745,7746,7758,7782,7813,7848,7855,7866,7896,7933,7955,7997,8000,8021,8026,8039,8057,8088,8222,8280,8297,8330,8354,8372,8416,8438,8462,8480,8532,8603,8613,8706,8787,8819,8972,9012,9018,9052,9111,9196,9197,9284,9300,9320,9330,9339,9370,9437,9481,9529,9552,9626,9629,9677,9681,9766,9767,9785,9865,9869,9894,10186,10209,10213,10258,10263,10352,10400,10603,10604,10668,10708,10764,10803,10811,10847,10968,11098,11106,11107,11111,11121,11192,11305,11356,11397,11410,11430,11461,11612,11625,11627,11722,11745,11820,11859,11864,11987,11994,12112,12113,12144,12216,12254,12388,12437,12541,12592,12599,12609,12669,12686,12708,12746,12753,12816,12843,12978,13006,13018,13061,13068,13132,13154,13190,13268,13269,13276,13321,13325,13328,13352,13488,13501,13534,13535,13553,13575,13576,13589,13612,13645,13646,13672,13685,13693,13727,13748,13750,13782,13783,13818,13819,13846,13858,13859,13924,13926,13930,13941,13971,14052,14057,14079,14100,14122,14132,14139,14186,14267,14324,14327,14340,14356,14373,14395,14426,14430,14487,14522,14524,14601,14630,14648,14660,14663,14665,14679,14684,14709,14713,14733,14746,14753,14761,14816,14838,14846,14849,14860,14862,14869,14878,14880,14890,14905,14906,14911,14973,15020,15038,15045,15046,15054,15059,15060,15079,15112,15166,15179,15208,15209,15224,15234,15245,15262,15293,15298,15304,15310,15352,15464,15467,15517,15528,15530,15533,15540,15580,15594,15650,15751,15753,15763,15808,15812,15851,15870,15917,15937,15947,16057,16092,16108,16115,16122,16206,16208,16422,16440,16455,16458,16499,16508,16526,16571,16591,16652,16654,16728,16737,16740,16789,16802,16823,16835,16843,16862,16880,16894,16899,17035,17052,17080,17116,17117,17133,17135,17136,17138,17141,17186,17188,17199,17263,17288,17303,17334,17335,17343,17344,17369,17409,17412,17479,17531,17584,17590,17597,17603,17609,17611,17635,17691,17700,17716,17812,17826,17857,17862,17866,17871,17883,17902,17907,17908,17910,17927,17941,17956,17976,17977,18007,18022,18028,18029,18030,18045,18067,18091,18165,18170,18227,18356,18362,18450,18463,18473,18499,18585,18595,18705,18707,18825,18873,18880,18906,18907,18912,18926,18927,18929,18934,18944,18952,18958,18974,18982,19003,19024,19045,19110,19118,19123,19127,19153,19204,19211,19232,19235,19265,19291,19299,19303,19331,19348,19353,19364,19423,19426,19432,19448,19484,19487,19507,19541,19572,19589,19643,19660,19695,19706,19718,19728,19750,19790,19796,19848,19858,19862,19876,19890,19921,19967,19988,20041,20060,20066,20068,20073,20088,20090,20191,20215,20220,20244,20246,20258,20309,20329,20338,20384,20396,20413,20434,20437,20455,20458,20469,20510,20515,20521,20565,20571,20574,20592,20595,20599,20618,20634,20642,20648,20688,20750,20751,20778,20787,20792,20833,20837,20869,20883,20953,20976,20977,20990,21008,21015,21038,21040,21053,21078,21087,21180,21198,21210,21259,21266,21268,21275,21279,21329,21332,21353,21392,21405,21440,21441,21447,21469,21487,21520,21523,21524,21547,21571,21579,21598,21602,21614,21623,21664,21667,21681,21695,21712,21719,21722,21726,21727,21747,21769,21773,21791,21811,21824,21862,21875,21891,21932,21987,22117,22118,22129,22134,22137,22159,22195,22197,22207,22210,22212,22253,22262,22267,22302,22324,22329,22332,22357,22367,22384,22393,22406,22424,22442,22453,22466,22476,22481,22484,22494,22514,22580,22581,22596,22612,22620,22626,22645,22655,22659,22674,22689,22710,22727,22739,22753,22754,22780,22781,22788,22829,22830,22833,22851,22869,22871,22886,22897,22914,22923,22925,22947,22959,22964,22966,22977,23007,23024,23036,23037,23083,23089,23099,23104,23119,23123,23179,23184,23200,23212,23213,23229,23261,23273,23287,23304,23309,23318,23326,23328,23340,23364,23365,23381,23398,23479,23495,23571,23585,23622,23625,23695,23704,23708,23725,23739,23790,23834,23871,23880,23885,23888,23891,23897,23905,23907,23909,23921,23947,23964,23969,24004,24029,24067,24077,24115,24123,24161,24163,24187,24202,24208,24263,24269,24281,24286,24316,24337,24357,24361,24381,24394,24460,24463,24465,24485,24505,24555,24617,24623,24650,24678,24775,24780,24781,24785,24801,24802,24815,24834,24843,24862,24871,24915,24951,24957,24980,24983,25032,25038,25048,25062,25068,25097,25099,25148,25200,25201,25227,25377,25450,25548,25621,25622,25639,25648,25665,25673,25717,25723,25740,25746,25747,25757,25758,25766,25770,25788,25790,25818,25864,25898,25927,25928,25949,25967,26000,26013,26053,26056,26066,26092,26104,26113,26117,26153,26175,26221,26296,26335,26337,26359,26368,26372,26373,26374,26381,26386,26387,26388,26395,26408,26409,26505,26516,26544,26562,26565,26575,26576,26601,26620,26626,26629,26630,26639,26646,26664,26671,26678,26684,26691,26699,26715,26716,26739,26744,26755,26760,26784,26801,26820,26827,26845,26848,26864,26868,26873,26879,26905,26935,26945,26955,26968,27005,27036,27045,27065,27102,27105,27136,27161,27167,27196,27212,27213,27216,27323,27346,27347,27367,27404,27407,27408,27423,27454,27466,27492,27541,27568,27570,27583,27592,27595,27601,27614,27671,27688,27717,27758,27786,27986,28016,28017,28031,28059,28066,28075,28094,28095,28097,28109,28114,28120,28129,28152,28153,28162,28168,28192,28230,28243,28329,28354,28356,28435,28570,28670,28673,28765,28846,28857,28858,28985,29011,29028,29045,29213,29266,29333,29379,29436,29483,29553,29590,29602,29630,29639,29726,29769,29866,29977,30115,30334,30525,30529,30580,31608,31679,31706,31735,31764,31794,32078,32084,32257,32468,32649,32689,32752,32761,32768,32817,32865,32879,32945,32973,32977,32980,33026,33065,33090,33091,33099,33116,33157,33259,33289,33338,33545,33573,33596,33832,33874,33902,33917,33924,33925,33946,33951,33952,33957,33981,33982,33991,33993,33999,34014,34025,34105,34122,34135,34140,34171,34175,34251,34275,34331,34420,34481,34501,34616,34629,34646,34693,34714,34776,34798,34811,34815,34879,34914,34963,35092,35181,35197,35220,35227,35233,35238,35239,35282,35289,35376,35397,35426,35444,35490,35530,35554,35555,35556,35621,35668,35683,35687,35688,35710,35743,35805,35806,35808,35878,35882,35910,35937,35948,36000,36015,36062,36128,36220,36237,36279,36368,36369,36373,36385,36420,36428,36441,36555,36584,36774,36828,36860,36886,36925,36930,36932,36934,36971,36989,36998,37010,37011,37136,37147,37155,37198,37245,37271,37283,37307,37308,37370,37378,37508,37520,37534,37566,37626,37644,37671,37757,37820,37921,37959,38033,38058,38126,38133,38157,38178,38288,38330,38382,38402,38432,38433,38489,38538,38545,38546,38689,38690,38693,38740,38742,38786,38824,38843,38877,38904,38922,38939,38949,39205,39260,39285,39290,39296,39325,39434,39474,39476,39497,39587,39600,39610,39717,39828,39850,39987,40023,40054,40263,40267,40308,40319,40322,40334,40509,40560,40623,40647,40769,40789,40857,40869,41009,41062,41137,41172,41216,41274,41328,41329,41332,41339,41345,41407,41505,41506,41516,41654,41668,41690,41781,41845,41912,41920,41933,41968,41969,42010,42029,42129,42247,42363,42513,42540,42541,42637,42987,42992,43016,43109,43165,43237,43271,43295,43298,43350,43358,43405,43446,43461,43469,43483,43611,43612,43668,43704,43712,43768,43775,43781,43795,43867,43993,44062,44070,44091,44098,44245,44246,44317,44366,44368,44379,44504,44530,44546,44553,44572,44573,44674,44718,44780,44788,44807,44829,44873,44904,44912,44935,44936,44953,44988,45008,45101,45138,45190,45199,45231,45235,45263,45264,45304,45305,45316)
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 | 1445 | 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.03 ms |
init | 0.28 ms |
System lock | 0.02 ms |
optimizing | 0.10 ms |
statistics | 2.27 ms |
preparing | 1.13 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 5.66 ms |
end | 0.03 ms |
query end | 0.03 ms |
closing tables | 0.03 ms |
freeing items | 0.11 ms |
cleaning up | 0.04 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 |