Tiempo de la consulta: 4.76 ms Después de la última consulta: 1.13 ms Consulta a la memoria: 0.072 MB memoria antes de la consulta: 4.519 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 05:27:22')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 05:27:22')
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(11,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,71,75,81,87,88,89,90,92,96,97,98,99,102,104,107,110,111,125,185,188,189,190,198,199,200,205,209,210,217,226,228,232,234,238,240,242,243,246,248,249,263,265,267,271,276,325,353,362,412,415,416,419,420,421,422,423,424,426,427,428,429,431,466,484,487,496,501,503,523,531,574,575,593,605,607,637,686,701,785,853,862,868,903,904,946,948,966,986,1031,1067,1207,1209,1223,1277,1303,1304,1321,1331,1353,1357,1431,1434,1698,1718,1785,1825,1827,1845,1878,1945,1957,2072,2108,2156,2198,2208,2272,2314,2338,2376,2473,2729,2822,2825,3020,3051,3058,3209,3212,3292,3325,3329,3346,3347,3442,3453,3650,3672,3682,3961,3965,4310,4674,4784,4808,4902,4905,5021,5060,5125,5189,5300,5323,5324,5371,5392,5476,5488,5538,5565,5610,5622,5627,5628,5638,5647,5648,5649,5726,5727,5730,5732,5798,5833,5847,5894,5895,5896,6012,6141,6142,6209,6260,6264,6290,6307,6310,6311,6386,6392,6411,6482,6518,6550,6614,6616,6666,6671,6760,6776,6836,6839,6847,6868,6881,6915,6984,7017,7050,7056,7109,7124,7138,7199,7210,7266,7287,7289,7377,7450,7471,7624,7625,7647,7692,7716,7730,7772,7782,7811,7864,7928,7933,7936,7938,7958,7967,7970,7993,8027,8047,8056,8058,8062,8070,8154,8215,8320,8352,8354,8406,8444,8449,8543,8565,8589,8602,8610,8638,8663,8835,8844,8856,8887,9003,9051,9075,9107,9155,9195,9197,9206,9262,9282,9286,9351,9392,9411,9428,9472,9650,9677,9678,9724,9800,9825,9924,9965,10011,10031,10035,10068,10100,10134,10138,10167,10274,10323,10413,10436,10600,10719,10889,10956,11163,11231,11328,11345,11369,11371,11433,11697,11911,11946,12020,12095,12177,12221,12324,12341,12412,12440,12459,12460,12536,12620,12643,12650,12670,12679,12685,12686,12708,12807,12835,12887,12902,12913,12914,12967,12973,12996,13010,13014,13016,13062,13145,13152,13231,13276,13294,13298,13321,13348,13398,13405,13413,13471,13473,13474,13475,13530,13534,13544,13546,13557,13681,13691,13750,13800,13846,13853,13868,13900,13969,13971,13973,14029,14034,14122,14132,14135,14156,14203,14206,14218,14224,14229,14263,14293,14356,14362,14419,14435,14454,14464,14523,14534,14536,14554,14581,14595,14706,14773,14838,14860,14925,14987,15021,15038,15039,15043,15110,15179,15188,15198,15245,15261,15262,15293,15298,15331,15347,15366,15382,15414,15418,15421,15470,15473,15475,15476,15482,15495,15511,15517,15520,15533,15550,15573,15574,15630,15667,15757,15759,15784,15796,15835,15861,15945,15972,16002,16029,16055,16062,16071,16086,16115,16161,16162,16165,16176,16213,16263,16276,16352,16365,16416,16418,16468,16488,16497,16503,16526,16532,16543,16566,16720,16751,16812,16826,16833,16836,16859,16894,16905,16908,16950,16976,16983,17045,17058,17063,17105,17114,17142,17154,17236,17275,17309,17314,17317,17334,17335,17367,17376,17395,17409,17419,17453,17461,17496,17506,17520,17521,17528,17607,17611,17619,17629,17633,17650,17702,17710,17721,17854,17857,17862,17877,17935,17949,17965,18052,18071,18073,18075,18106,18124,18133,18181,18213,18220,18260,18300,18309,18311,18336,18360,18362,18371,18412,18426,18458,18465,18487,18488,18504,18509,18538,18558,18563,18570,18578,18588,18602,18675,18707,18726,18746,18753,18757,18790,18794,18801,18819,18845,18846,18852,18862,18878,18956,18958,18999,19006,19018,19024,19040,19057,19098,19150,19245,19252,19263,19282,19294,19312,19353,19358,19369,19381,19402,19454,19460,19483,19484,19527,19551,19582,19650,19661,19668,19676,19695,19722,19733,19772,19791,19816,19824,19825,19837,19858,19886,19923,19931,19937,19939,19943,19963,19980,20004,20039,20060,20092,20095,20122,20183,20192,20193,20213,20216,20269,20296,20301,20308,20343,20386,20408,20434,20439,20459,20488,20492,20496,20497,20526,20528,20539,20542,20567,20573,20592,20595,20616,20617,20648,20670,20688,20699,20700,20727,20792,20795,20802,20804,20847,20881,20891,20894,20907,20944,20964,20984,21002,21016,21038,21080,21109,21159,21182,21256,21259,21279,21283,21285,21288,21300,21317,21338,21368,21404,21454,21460,21464,21485,21486,21520,21524,21526,21529,21612,21618,21620,21623,21631,21650,21661,21664,21679,21690,21695,21704,21719,21727,21767,21780,21800,21824,21843,21846,21850,21891,21910,21954,21955,21958,21960,22015,22018,22032,22043,22062,22077,22085,22089,22117,22156,22162,22163,22164,22172,22189,22195,22197,22239,22241,22253,22267,22302,22319,22324,22325,22339,22344,22361,22363,22366,22406,22409,22421,22446,22453,22466,22481,22499,22512,22544,22547,22564,22580,22603,22611,22620,22622,22626,22632,22655,22658,22694,22695,22710,22726,22727,22753,22765,22780,22781,22787,22804,22807,22814,22829,22833,22865,22871,22897,22923,22947,22958,22972,22973,23003,23007,23010,23024,23036,23043,23062,23074,23082,23089,23096,23099,23104,23119,23124,23179,23184,23203,23214,23218,23230,23235,23254,23264,23268,23292,23304,23371,23381,23391,23420,23436,23455,23460,23475,23480,23483,23523,23528,23554,23555,23575,23585,23601,23604,23619,23629,23632,23665,23716,23719,23764,23781,23805,23813,23854,23893,23897,23901,23905,23909,23927,23947,23964,23986,24000,24007,24016,24038,24047,24051,24084,24092,24160,24197,24209,24211,24226,24228,24238,24249,24294,24303,24308,24339,24352,24361,24376,24393,24408,24429,24475,24496,24503,24504,24522,24526,24582,24585,24598,24615,24617,24663,24678,24679,24688,24711,24741,24759,24764,24767,24772,24782,24793,24798,24803,24861,24918,24934,24937,24956,24984,24992,24993,25005,25024,25030,25035,25062,25079,25089,25107,25131,25138,25151,25171,25232,25244,25263,25280,25287,25303,25318,25351,25368,25375,25386,25401,25406,25432,25436,25448,25480,25507,25542,25548,25584,25613,25637,25646,25649,25657,25660,25716,25741,25863,25904,25918,25949,25956,26000,26033,26040,26047,26093,26102,26105,26118,26131,26147,26184,26221,26283,26317,26343,26360,26410,26415,26424,26429,26443,26454,26474,26542,26625,26651,26673,26677,26699,26713,26732,26742,26801,26820,26845,26881,26884,26900,26905,26907,26925,26940,26944,26971,26973,26978,26990,26992,27000,27038,27072,27109,27118,27126,27143,27171,27232,27293,27366,27375,27402,27405,27430,27530,27550,27650,27688,27722,27846,27870,28013,28030,28072,28080,28121,28339,28440,28442,28537,28614,28615,28616,28712,28718,28728,28825,28845,28944,29054,29063,29155,29297,29446,29460,29635,29659,29926,29943,30083,30273,30483,30484,30808,30953,30991,31136,31213,31447,31873,32107,32552,33042,33044,33417,33884,33885,33886,34111,34284,34667,34668,34669,34788,34892,34902,35000,35126,35195,35235,35330,35472,35585,35650,35713,35744,35832,35846,35943,35955,36042,36047,36095,36619,36654,36763,36778,36786,36800,36880,37078,37080,37088,37917,38293,38411,38651,39142,39320,39381,39398,39530,39670,39887,39932,40036,40046,40056,40073,40085,40086,40113,40348,40451,40492,40568,40578,40605,40901,41049,41213,41477,41744,43644,43652,43927,44020,44044,44045,44049,44050,44057,44383,44971,45008)
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 | 1192 | 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.58 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.22 ms |
System lock | 0.02 ms |
optimizing | 0.08 ms |
statistics | 1.79 ms |
preparing | 0.93 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.44 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.06 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 |