Tiempo de la consulta: 5.83 ms Después de la última consulta: 0.95 ms Consulta a la memoria: 0.182 MB memoria antes de la consulta: 4.349 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 04:42:23')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 04:42:23')
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(4,13,21,30,51,75,82,183,184,197,260,263,287,328,350,393,394,407,431,479,563,622,625,693,770,826,874,902,906,935,1235,1280,1296,1348,1354,1455,1503,1535,1538,1603,1634,1646,1714,1718,1800,1802,1804,1822,1900,1913,2217,2258,2305,2337,2378,2424,2569,2598,2600,2601,2632,2636,2668,2689,3067,3087,3212,3295,3319,3337,3373,3408,3456,3476,3488,3575,3718,3719,3725,3757,3871,4005,4100,4131,4320,4339,4473,4493,4612,4613,4614,4615,4617,4785,4831,4832,4910,4947,4957,4982,4990,5104,5150,5170,5173,5199,5461,5530,5559,5632,5686,5814,5855,5857,5973,5996,6039,6159,6264,6270,6372,6427,6465,6468,6470,6492,6571,6595,6600,6607,6616,6635,6744,6776,6830,6910,6917,6985,7002,7012,7215,7218,7231,7232,7234,7243,7246,7249,7285,7289,7319,7328,7330,7333,7334,7344,7346,7348,7364,7367,7368,7370,7371,7374,7377,7379,7380,7396,7406,7407,7408,7410,7413,7414,7415,7416,7417,7422,7430,7431,7435,7436,7447,7450,7455,7456,7457,7458,7463,7464,7465,7482,7486,7489,7526,7545,7546,7552,7553,7555,7565,7570,7577,7583,7615,7624,7625,7659,7678,7682,7683,7691,7715,7720,7735,7744,7745,7746,7749,7757,7768,7799,7830,7833,7834,7835,7851,7863,7871,7891,7894,7895,7900,7901,7919,7955,7957,7961,7962,7979,7982,8020,8022,8023,8024,8026,8039,8049,8057,8067,8072,8330,8354,8416,8462,8698,8964,9012,9018,9059,9101,9196,9197,9218,9253,9300,9303,9344,9370,9568,9658,9823,9865,9869,9907,9996,10186,10197,10199,10205,10243,10349,10352,10353,10387,10400,10522,10603,10604,10764,10811,11071,11098,11107,11113,11121,11138,11193,11305,11356,11404,11458,11820,11859,11864,11994,12113,12144,12216,12226,12254,12435,12442,12488,12527,12541,12609,12617,12649,12669,12944,12956,12978,13154,13227,13268,13321,13325,13327,13352,13375,13387,13452,13535,13575,13576,13667,13685,13693,13727,13782,13846,13924,13941,14021,14027,14052,14122,14231,14250,14327,14356,14366,14386,14421,14427,14430,14431,14498,14505,14524,14535,14596,14648,14663,14679,14680,14682,14713,14733,14770,14790,14849,14860,14865,14878,14905,14946,14970,14973,14974,14982,15015,15020,15039,15045,15046,15166,15179,15208,15209,15223,15234,15262,15293,15298,15318,15517,15528,15533,15594,15650,15673,15689,15753,15797,15808,15835,15870,15874,15902,15916,15919,15937,15947,16055,16057,16103,16122,16157,16172,16240,16292,16313,16410,16422,16440,16455,16465,16479,16488,16520,16584,16631,16654,16676,16737,16802,16857,16894,16907,17080,17117,17168,17199,17291,17295,17331,17334,17335,17344,17353,17369,17385,17393,17409,17412,17433,17476,17530,17531,17584,17603,17607,17609,17630,17635,17700,17722,17784,17788,17824,17826,17834,17857,17862,17883,17927,17928,17941,17956,17976,17977,17999,18022,18028,18029,18067,18087,18150,18165,18170,18220,18227,18317,18320,18353,18362,18442,18456,18473,18482,18558,18576,18582,18590,18595,18666,18707,18712,18730,18735,18767,18799,18815,18825,18892,18905,18906,18907,18926,18929,18958,19024,19032,19101,19123,19127,19153,19204,19211,19232,19235,19236,19243,19245,19299,19353,19387,19392,19423,19426,19432,19435,19472,19484,19487,19542,19639,19651,19695,19706,19740,19750,19772,19796,19858,19876,19916,19967,19988,20063,20066,20068,20100,20191,20289,20296,20301,20309,20376,20385,20437,20469,20473,20475,20565,20574,20584,20592,20618,20642,20648,20750,20792,20885,20981,21053,21198,21259,21300,21329,21336,21405,21547,21598,21602,21614,21624,21722,21726,21747,21769,21773,21811,21813,21824,21843,21891,21932,21952,21992,22019,22116,22129,22134,22249,22262,22267,22271,22289,22290,22329,22330,22341,22419,22453,22466,22481,22484,22494,22581,22602,22615,22621,22693,22739,22761,22781,22850,22869,22886,22914,22959,22964,23036,23037,23083,23099,23104,23107,23119,23123,23184,23213,23214,23229,23236,23272,23287,23309,23328,23364,23381,23555,23725,23729,23849,23885,23888,23891,23897,23905,23921,23949,23964,24062,24077,24095,24163,24211,24223,24316,24337,24460,24526,24595,24617,24650,24736,24738,24774,24781,24785,24834,24840,24871,24915,24951,24983,25032,25049,25066,25068,25178,25201,25294,25377,25450,25538,25548,25555,25621,25622,25648,25723,25734,25757,25771,25818,25829,25838,25848,25927,25928,25941,26000,26028,26066,26082,26113,26234,26296,26359,26372,26386,26409,26565,26576,26579,26609,26620,26639,26646,26691,26720,26744,26820,26835,26842,26843,26845,26864,26879,26916,26933,26944,26947,26968,27065,27076,27108,27126,27167,27192,27212,27216,27268,27269,27270,27323,27327,27347,27367,27408,27423,27487,27492,27499,27512,27541,27552,27583,27592,27595,27601,27604,27605,27671,27707,27717,27749,27758,27789,27851,27856,27926,28031,28059,28066,28075,28094,28097,28114,28120,28129,28162,28168,28192,28213,28230,28243,28264,28279,28435,28441,28468,28673,28846,29011,29045,29266,29311,29345,29495,29611,29639,29653,29655,29769,29866,29938,30111,30194,30471,30746,30988,31608,31798,31853,32009,32084,32106,33282,33416,33871,33874,33925,33946,33957,34025,34275,34331,34616,34646,34693,34784,34794,34811,34815,35220,35227,35238,35239,35289,35375,35376,35397,35426,35444,35490,35554,35556,35621,35637,35639,35640,35643,35688,35744,35752,35805,35882,35948,35956,36000,36015,36075,36208,36220,36237,36342,36368,36369,36373,36385,36420,36441,36541,36581,36584,36790,36791,36797,36878,36930,36931,36984,36989,36998,37010,37015,37136,37147,37283,37307,37308,37328,37378,37473,37534,37547,37626,37627,37643,37644,37759,38005,38046,38058,38086,38126,38133,38330,38362,38406,38433,38489,38546,38617,38723,38728,38821,38824,38829,38877,38901,38904,38912,38922,38949,38965,38990,39065,39155,39184,39205,39224,39240,39265,39290,39293,39296,39345,39376,39442,39448,39451,39476,39497,39587,39600,39610,39686,39717,39724,39815,39856,39921,40118,40319,40334,40509,40560,40624,40647,40673,40885,40888,41042,41062,41109,41121,41148,41149,41171,41172,41189,41192,41201,41212,41225,41227,41231,41245,41289,41332,41343,41345,41415,41483,41504,41516,41571,41577,41591,41612,41618,41757,41781,41969,41980,42042,42130,42131,42329,42423,42479,42637,42809,42987,43003,43012,43016,43109,43165,43237,43271,43276,43401,43405,43446,43454,43461,43483,43544,43654,43712,43934,44062,44109,44122,44366,44421,44573,44718,44735,44788,44807,44829,44848,44871,44873,44912,44935,44936,44988,45046,45057,45068,45101,45138,45150,45201,45235,45263,45264,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 | 1078 | 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.56 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.20 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.73 ms |
preparing | 0.87 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 1.24 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.23 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 |