Tiempo de la consulta: 6.23 ms Después de la última consulta: 1.11 ms Consulta a la memoria: 0.197 MB memoria antes de la consulta: 4.374 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 15:58:28')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 15:58: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(9,13,30,49,51,58,82,93,161,170,172,183,184,197,287,290,291,293,328,344,350,353,390,393,407,437,495,595,607,634,693,797,843,902,935,971,981,997,1198,1207,1232,1247,1280,1339,1354,1455,1486,1535,1603,1634,1646,1713,1786,1787,1800,1802,1804,1822,1900,1913,1931,2123,2210,2217,2228,2260,2305,2337,2378,2424,2468,2509,2598,2600,2601,2632,2636,2668,2669,2688,2689,2734,2757,2828,2952,2967,2997,3020,3028,3045,3067,3076,3087,3124,3127,3208,3209,3211,3212,3258,3319,3337,3373,3408,3410,3475,3663,3671,3718,3719,3725,3738,3757,3842,3871,4080,4120,4128,4131,4320,4383,4399,4473,4717,4832,4836,4910,4947,4957,4990,5092,5104,5150,5170,5173,5224,5298,5471,5539,5559,5647,5686,5798,5828,5871,5943,5944,5973,6039,6055,6131,6234,6264,6270,6484,6571,6609,6616,6645,6665,6688,6711,6770,6775,6809,6830,6910,6917,6919,6945,6977,6985,6998,7001,7271,7330,7361,7416,7442,7481,7482,7483,7524,7526,7585,7596,7624,7659,7677,7745,7810,7837,7847,7859,7866,7894,7913,7933,7965,7999,8000,8026,8027,8039,8057,8085,8088,8222,8250,8310,8330,8354,8416,8462,8532,8603,8706,8764,8964,9010,9012,9018,9196,9197,9239,9300,9308,9318,9370,9481,9552,9823,9865,9869,9920,10100,10149,10186,10260,10301,10352,10382,10400,10598,10603,10604,10623,10721,10764,10782,10811,10957,11098,11107,11113,11121,11137,11305,11356,11820,11859,11864,11994,12035,12113,12144,12216,12224,12254,12270,12437,12440,12541,12581,12582,12609,12669,12708,12851,12904,12978,13151,13188,13227,13268,13307,13321,13325,13332,13352,13387,13420,13474,13484,13515,13535,13575,13576,13671,13685,13693,13727,13748,13750,13782,13846,13858,13924,13941,13947,13972,14021,14052,14122,14327,14356,14372,14387,14430,14453,14495,14524,14630,14648,14663,14669,14679,14682,14688,14703,14709,14726,14733,14744,14746,14762,14790,14845,14849,14852,14856,14860,14905,14911,14949,14970,14973,14983,14992,15007,15020,15045,15046,15129,15156,15166,15179,15208,15209,15214,15234,15262,15293,15298,15304,15335,15351,15365,15366,15376,15406,15424,15475,15517,15520,15522,15528,15581,15594,15600,15651,15689,15700,15742,15751,15753,15785,15790,15812,15870,15880,15931,15937,15947,16057,16095,16115,16122,16127,16157,16249,16357,16375,16384,16422,16427,16440,16455,16465,16521,16551,16654,16675,16737,16781,16787,16802,16816,16841,16862,16894,17049,17101,17116,17166,17168,17188,17199,17240,17246,17286,17288,17296,17331,17334,17335,17344,17353,17369,17387,17409,17412,17433,17444,17497,17530,17531,17561,17573,17590,17603,17609,17630,17635,17700,17711,17736,17779,17826,17834,17857,17862,17883,17919,17927,17930,17936,17950,17956,17967,17983,17984,18022,18028,18029,18044,18061,18067,18165,18170,18222,18227,18260,18295,18317,18320,18362,18364,18377,18382,18473,18552,18595,18644,18664,18693,18704,18707,18728,18825,18830,18877,18888,18892,18905,18906,18907,18912,18926,18927,18929,18958,19015,19024,19105,19123,19124,19127,19128,19140,19153,19166,19173,19204,19211,19232,19235,19236,19245,19268,19287,19299,19315,19353,19362,19381,19387,19423,19432,19472,19484,19486,19507,19559,19607,19639,19684,19706,19710,19723,19725,19733,19750,19794,19807,19858,19876,19923,19967,19988,20066,20119,20175,20230,20296,20301,20309,20376,20385,20396,20437,20445,20469,20488,20542,20565,20574,20592,20618,20638,20642,20648,20656,20659,20750,20772,20777,20792,20940,20959,21053,21117,21118,21143,21198,21259,21329,21344,21367,21398,21403,21405,21421,21457,21470,21520,21522,21547,21598,21602,21614,21663,21684,21702,21718,21719,21722,21726,21741,21747,21764,21769,21773,21776,21778,21811,21824,21845,21850,21883,21891,21906,21917,21932,21968,21992,21997,22038,22067,22082,22106,22119,22129,22134,22178,22262,22267,22278,22298,22341,22419,22450,22453,22460,22466,22476,22481,22484,22494,22555,22570,22581,22729,22739,22759,22761,22781,22820,22840,22850,22851,22869,22886,22944,22960,22964,23034,23036,23037,23083,23093,23099,23100,23104,23119,23123,23162,23184,23213,23229,23242,23272,23273,23279,23287,23328,23364,23367,23368,23381,23405,23430,23438,23479,23493,23553,23555,23607,23720,23831,23849,23885,23887,23888,23891,23897,23905,23921,23955,23964,23968,24027,24043,24062,24076,24077,24153,24163,24164,24185,24199,24208,24228,24237,24247,24281,24286,24294,24316,24334,24337,24399,24406,24457,24459,24460,24463,24485,24497,24530,24539,24584,24589,24617,24650,24690,24743,24779,24781,24785,24788,24805,24834,24841,24871,24906,24915,24946,24951,24952,24956,24963,24983,25032,25037,25058,25068,25081,25117,25201,25297,25318,25329,25377,25450,25452,25523,25548,25597,25621,25622,25648,25673,25676,25723,25734,25747,25757,25771,25800,25807,25817,25818,25919,25927,25928,25971,26000,26028,26066,26082,26113,26153,26187,26229,26245,26261,26296,26372,26386,26388,26565,26576,26596,26620,26630,26639,26646,26691,26720,26815,26820,26835,26842,26843,26845,26854,26864,26873,26885,26916,26933,26935,26944,26947,26959,26964,27001,27061,27062,27065,27076,27100,27103,27108,27109,27137,27158,27192,27196,27209,27211,27212,27216,27242,27252,27268,27269,27270,27290,27298,27307,27323,27327,27347,27367,27408,27423,27487,27499,27526,27541,27552,27578,27583,27592,27595,27601,27646,27671,27707,27717,27745,27758,27786,27851,27923,27950,28016,28017,28031,28045,28059,28066,28075,28095,28097,28107,28109,28114,28120,28129,28162,28168,28192,28213,28230,28237,28243,28264,28279,28283,28354,28435,28673,28749,28765,28826,28985,28995,29011,29045,29061,29073,29152,29166,29226,29229,29266,29272,29333,29382,29495,29539,29611,29616,29639,29653,29655,29716,29719,29769,29805,29832,29866,29906,30111,30295,30447,30525,30529,30804,31084,31346,31608,31679,31735,32084,32767,32768,32817,32840,33871,33914,33925,33946,33954,33955,33956,33957,34014,34025,34275,34331,34588,34616,34632,34646,34693,34784,34794,34811,34815,35100,35191,35220,35227,35232,35238,35239,35250,35289,35295,35345,35365,35376,35397,35426,35444,35490,35540,35554,35556,35621,35637,35641,35688,35744,35805,35808,35882,35948,35956,36000,36015,36208,36220,36237,36368,36369,36373,36380,36385,36386,36420,36441,36584,36790,36791,36792,36793,36797,36849,36930,36941,36962,36984,36989,36998,37010,37015,37104,37136,37147,37245,37283,37307,37308,37370,37378,37473,37508,37534,37547,37626,37627,37643,37644,37757,37834,37902,38058,38086,38126,38133,38330,38418,38433,38489,38546,38617,38681,38723,38734,38821,38824,38829,38877,38904,38922,38949,38965,39039,39110,39133,39184,39205,39244,39290,39293,39296,39297,39345,39376,39448,39451,39460,39470,39476,39497,39519,39587,39610,39717,39718,39837,39856,39981,39998,40059,40168,40275,40319,40509,40560,40576,40611,40647,40855,40885,40888,40896,41004,41009,41033,41062,41109,41121,41123,41149,41152,41172,41176,41189,41201,41212,41225,41272,41289,41328,41332,41339,41343,41345,41415,41434,41479,41483,41504,41516,41550,41571,41577,41591,41612,41637,41737,41757,41781,41783,41862,41948,41964,41969,41980,42042,42329,42423,42479,42482,42637,42682,42736,42809,42811,42941,42987,43016,43032,43043,43093,43104,43109,43117,43165,43167,43221,43237,43240,43241,43271,43276,43326,43375,43401,43405,43446,43461,43475,43477,43483,43517,43518,43654,43712,43792,44062,44109,44122,44186,44187,44366,44378,44421,44573,44581,44632,44640,44656,44718,44735,44788,44807,44829,44871,44873,44881,44912,44935,44936,44988,45046,45057,45068,45101,45138,45174,45175,45201,45223,45235,45249,45263,45264,45274,45300,45313,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 | 1258 | 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.62 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.24 ms |
System lock | 0.02 ms |
optimizing | 0.09 ms |
statistics | 1.89 ms |
preparing | 0.98 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 1.12 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.04 ms |
cleaning up | 0.02 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 |