Tiempo de la consulta: 15.04 ms Después de la última consulta: 1.93 ms Consulta a la memoria: 1.072 MB memoria antes de la consulta: 4.620 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-04 15:13:38')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 15:13:38')
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,49,51,71,79,80,81,82,83,85,86,90,92,96,97,98,99,102,104,107,144,165,183,184,197,198,199,209,210,217,226,228,232,234,238,240,242,243,260,263,265,271,276,287,325,328,350,368,385,393,394,407,419,428,434,458,466,487,523,563,605,607,637,693,744,770,806,870,902,904,935,940,948,964,966,974,1031,1067,1091,1209,1223,1280,1295,1296,1348,1354,1365,1455,1490,1503,1535,1538,1603,1614,1634,1646,1698,1713,1714,1718,1752,1755,1800,1802,1804,1815,1822,1825,1845,1900,1905,1913,1929,1957,2022,2156,2217,2258,2305,2337,2378,2424,2598,2600,2601,2613,2631,2632,2636,2641,2668,2688,2689,2729,2748,2805,2822,2902,3020,3024,3025,3034,3035,3058,3067,3087,3176,3177,3204,3212,3216,3319,3337,3373,3408,3439,3575,3614,3718,3719,3725,3790,3871,3925,3963,4033,4084,4090,4095,4100,4131,4152,4178,4227,4230,4282,4320,4337,4339,4392,4393,4415,4473,4493,4587,4612,4613,4614,4615,4617,4715,4748,4770,4784,4808,4832,4842,4891,4902,4910,4930,4947,4957,4982,4990,5033,5071,5083,5086,5104,5125,5150,5152,5170,5173,5199,5237,5238,5268,5269,5313,5323,5329,5350,5371,5461,5530,5559,5622,5639,5647,5649,5662,5685,5686,5691,5694,5713,5719,5726,5727,5798,5800,5814,5819,5847,5855,5857,5896,5933,5934,5973,5996,5998,6004,6024,6028,6039,6043,6050,6055,6066,6069,6081,6095,6097,6127,6159,6178,6185,6264,6268,6270,6272,6298,6329,6330,6332,6340,6347,6350,6372,6376,6386,6388,6414,6427,6442,6455,6456,6460,6462,6465,6468,6470,6471,6473,6492,6494,6497,6499,6500,6502,6515,6517,6518,6520,6534,6545,6546,6568,6571,6581,6600,6601,6603,6608,6616,6645,6654,6656,6658,6659,6711,6718,6744,6749,6760,6762,6776,6779,6788,6797,6805,6806,6809,6817,6827,6830,6839,6847,6868,6869,6872,6879,6881,6882,6889,6910,6914,6915,6916,6917,6942,6945,6955,6971,6982,6984,6985,6990,6995,7017,7043,7045,7079,7088,7102,7122,7125,7134,7135,7138,7150,7154,7155,7156,7160,7161,7170,7171,7173,7176,7178,7179,7191,7201,7205,7212,7213,7215,7218,7231,7232,7234,7241,7243,7246,7249,7267,7268,7270,7277,7279,7282,7283,7285,7289,7319,7327,7328,7330,7333,7334,7344,7346,7353,7358,7364,7367,7368,7370,7371,7372,7374,7376,7377,7378,7379,7380,7389,7395,7396,7397,7398,7406,7407,7408,7410,7411,7413,7414,7415,7416,7417,7418,7422,7427,7428,7430,7431,7435,7436,7447,7450,7455,7456,7457,7458,7459,7461,7462,7463,7464,7465,7469,7482,7486,7488,7489,7494,7495,7513,7514,7523,7526,7545,7546,7552,7553,7555,7565,7567,7568,7570,7577,7578,7583,7610,7615,7624,7625,7659,7674,7677,7678,7681,7682,7683,7686,7689,7690,7691,7708,7713,7715,7720,7722,7735,7737,7743,7744,7745,7746,7749,7757,7758,7768,7772,7780,7787,7799,7804,7806,7808,7810,7813,7830,7831,7833,7834,7835,7836,7841,7851,7855,7862,7863,7864,7866,7871,7891,7894,7895,7900,7901,7918,7919,7920,7923,7928,7930,7940,7955,7957,7958,7960,7961,7962,7963,7966,7967,7971,7979,7982,7987,7994,8017,8020,8021,8022,8023,8024,8026,8028,8039,8043,8048,8049,8056,8057,8062,8064,8067,8070,8071,8072,8073,8082,8090,8103,8109,8111,8134,8139,8140,8247,8270,8280,8289,8308,8311,8320,8330,8335,8346,8354,8375,8396,8408,8416,8429,8438,8452,8462,8492,8502,8506,8546,8571,8632,8653,8656,8690,8698,8740,8755,8761,8771,8785,8808,8809,8844,8866,8923,8945,8952,8972,8983,8987,9003,9012,9018,9039,9042,9059,9114,9127,9130,9157,9196,9197,9218,9232,9253,9297,9300,9303,9308,9330,9334,9344,9347,9370,9382,9407,9450,9463,9478,9481,9529,9562,9568,9585,9604,9639,9650,9658,9693,9694,9724,9759,9826,9840,9865,9869,9883,9907,9924,9973,9990,9996,10004,10031,10048,10087,10100,10108,10135,10186,10197,10199,10205,10243,10265,10278,10280,10299,10302,10323,10342,10349,10352,10359,10379,10387,10395,10399,10400,10436,10443,10522,10527,10534,10553,10560,10600,10603,10604,10636,10764,10811,10835,10840,10887,10889,10895,10915,10956,10963,11023,11031,11071,11098,11099,11106,11107,11115,11121,11126,11163,11192,11193,11226,11229,11231,11239,11253,11278,11305,11356,11367,11404,11415,11458,11548,11555,11581,11592,11627,11673,11722,11747,11820,11849,11859,11864,11875,11911,11946,11994,12013,12024,12027,12060,12095,12101,12104,12113,12133,12144,12155,12171,12177,12184,12186,12216,12226,12232,12254,12289,12293,12340,12358,12379,12412,12416,12434,12435,12472,12474,12488,12499,12507,12509,12520,12527,12541,12572,12592,12609,12617,12649,12669,12679,12708,12716,12887,12913,12917,12944,12973,12978,13010,13029,13062,13077,13084,13089,13154,13177,13178,13231,13268,13276,13278,13321,13325,13327,13328,13352,13356,13375,13388,13398,13405,13458,13471,13473,13485,13489,13501,13535,13537,13550,13561,13575,13576,13596,13635,13656,13658,13667,13681,13685,13693,13727,13748,13750,13763,13769,13782,13783,13800,13830,13836,13841,13846,13868,13913,13924,13941,13969,13996,14029,14034,14038,14052,14064,14084,14108,14110,14122,14156,14157,14203,14218,14224,14250,14263,14293,14327,14349,14350,14356,14357,14366,14421,14430,14431,14477,14505,14524,14569,14581,14596,14635,14648,14653,14663,14679,14680,14682,14685,14713,14729,14733,14749,14770,14818,14846,14849,14860,14862,14863,14865,14895,14899,14905,14906,14946,14947,14973,14974,14987,15015,15020,15021,15039,15040,15045,15046,15065,15071,15110,15152,15153,15160,15166,15179,15188,15198,15208,15209,15234,15242,15244,15253,15262,15269,15293,15298,15304,15310,15318,15323,15326,15347,15366,15395,15418,15421,15470,15473,15482,15495,15511,15517,15528,15533,15540,15550,15573,15594,15626,15628,15630,15667,15673,15689,15721,15741,15751,15753,15759,15766,15771,15772,15777,15784,15797,15808,15835,15851,15862,15870,15874,15902,15916,15925,15937,15938,15947,15954,15978,16031,16055,16057,16085,16101,16103,16122,16123,16156,16165,16172,16190,16213,16217,16240,16257,16258,16263,16281,16301,16325,16352,16365,16378,16392,16410,16422,16436,16440,16455,16465,16468,16488,16489,16520,16526,16532,16561,16566,16584,16606,16654,16713,16720,16728,16737,16747,16802,16812,16823,16826,16854,16873,16894,16907,16964,16966,16983,17024,17045,17063,17080,17133,17136,17142,17154,17157,17158,17199,17213,17236,17275,17291,17317,17334,17335,17344,17369,17386,17409,17412,17453,17476,17506,17520,17521,17541,17567,17568,17584,17590,17597,17599,17603,17607,17609,17611,17619,17633,17635,17657,17662,17669,17700,17710,17763,17824,17826,17857,17862,17877,17883,17902,17910,17927,17941,17949,17956,17965,17968,17976,17977,17991,17999,18028,18029,18049,18052,18067,18106,18124,18133,18150,18155,18165,18170,18181,18190,18213,18214,18220,18227,18301,18317,18336,18353,18362,18401,18409,18426,18438,18442,18458,18465,18473,18482,18509,18512,18538,18558,18568,18576,18588,18595,18647,18648,18663,18665,18675,18695,18701,18702,18707,18712,18726,18730,18735,18744,18753,18768,18801,18825,18841,18845,18846,18852,18905,18906,18907,18926,18927,18956,18958,18972,18974,18999,19003,19024,19040,19048,19049,19057,19060,19097,19098,19101,19123,19127,19150,19153,19170,19183,19204,19210,19211,19213,19222,19225,19232,19235,19243,19245,19252,19263,19299,19310,19312,19325,19344,19353,19358,19369,19402,19423,19426,19432,19454,19472,19478,19483,19484,19487,19495,19527,19542,19551,19582,19651,19676,19706,19722,19750,19751,19772,19788,19791,19796,19816,19837,19851,19858,19876,19939,19943,19947,19959,19963,19967,19986,19988,20004,20031,20039,20066,20068,20083,20086,20092,20122,20140,20179,20183,20191,20208,20216,20225,20269,20289,20296,20301,20309,20335,20338,20343,20385,20386,20396,20399,20408,20434,20437,20469,20486,20492,20497,20513,20521,20526,20528,20539,20562,20565,20573,20574,20592,20611,20617,20618,20632,20642,20648,20657,20670,20671,20680,20688,20704,20737,20750,20751,20792,20804,20854,20881,20885,20888,20894,20898,20907,20944,20953,20964,20975,20984,20990,20991,21002,21053,21080,21087,21140,21161,21182,21192,21198,21273,21294,21300,21327,21329,21332,21366,21386,21404,21405,21407,21413,21454,21455,21487,21547,21555,21566,21588,21598,21602,21614,21624,21631,21640,21679,21681,21696,21707,21722,21726,21747,21764,21767,21769,21773,21811,21824,21843,21884,21891,21913,21924,21932,21952,21958,21960,21969,21990,22009,22032,22038,22061,22073,22085,22116,22117,22129,22134,22137,22144,22156,22162,22172,22173,22189,22222,22228,22230,22233,22235,22239,22253,22262,22267,22286,22289,22290,22326,22339,22344,22360,22361,22362,22363,22393,22409,22453,22454,22466,22481,22484,22494,22499,22544,22547,22550,22564,22579,22581,22602,22611,22614,22684,22693,22694,22695,22712,22726,22739,22749,22753,22781,22785,22805,22812,22814,22822,22828,22851,22865,22869,22871,22886,22892,22914,22925,22958,22959,22964,22973,22989,23003,23010,23012,23023,23036,23037,23074,23083,23096,23099,23104,23107,23119,23121,23123,23139,23150,23184,23203,23213,23214,23218,23229,23230,23235,23254,23264,23268,23273,23287,23292,23304,23308,23309,23328,23364,23371,23381,23391,23398,23437,23455,23460,23475,23483,23523,23542,23554,23555,23559,23585,23604,23614,23619,23631,23632,23704,23719,23725,23729,23770,23805,23813,23849,23854,23885,23888,23891,23893,23897,23901,23905,23907,23909,23921,23947,23949,23964,23986,24000,24007,24015,24029,24062,24067,24077,24092,24131,24140,24160,24162,24163,24197,24209,24211,24223,24226,24229,24237,24238,24279,24294,24303,24316,24329,24337,24339,24352,24361,24362,24376,24390,24409,24429,24485,24496,24503,24520,24524,24526,24528,24538,24585,24595,24598,24615,24617,24650,24651,24663,24678,24679,24711,24736,24738,24741,24764,24766,24772,24774,24781,24782,24785,24834,24846,24861,24862,24871,24915,24918,24934,24956,24983,24984,24992,25005,25032,25038,25062,25068,25076,25079,25089,25137,25151,25178,25201,25222,25225,25226,25232,25242,25244,25255,25287,25294,25303,25335,25368,25369,25372,25375,25377,25401,25431,25432,25450,25480,25507,25510,25512,25525,25538,25548,25555,25556,25613,25621,25622,25637,25648,25649,25672,25673,25716,25717,25723,25729,25757,25771,25818,25863,25902,25918,25927,25928,25941,25949,25956,26000,26047,26062,26066,26074,26099,26103,26113,26118,26131,26153,26184,26203,26221,26283,26296,26335,26359,26372,26386,26388,26409,26443,26565,26575,26576,26579,26590,26609,26620,26625,26630,26639,26646,26673,26691,26699,26732,26760,26784,26820,26845,26879,26884,26900,26925,26935,26940,26958,26968,26971,26978,26985,26990,27024,27065,27076,27096,27109,27118,27126,27143,27171,27212,27216,27232,27247,27323,27347,27367,27405,27408,27423,27430,27492,27512,27541,27550,27563,27568,27570,27583,27592,27595,27601,27604,27605,27657,27671,27717,27749,27758,27786,27789,27791,28030,28031,28059,28066,28073,28075,28094,28097,28104,28114,28115,28120,28121,28129,28162,28168,28169,28192,28230,28243,28329,28420,28435,28441,28468,28673,28718,28825,28846,29011,29045,29063,29142,29155,29266,29297,29359,29374,29382,29391,29405,29419,29444,29505,29639,29655,29759,29769,29833,29866,29925,29926,29943,30083,30194,30273,30325,30483,30484,30585,30808,30947,30988,31136,31447,31608,31798,31853,32084,32107,32624,33416,33417,33925,33946,33957,34025,34275,34331,34616,34646,34693,34811,34815,35000,35171,35220,35227,35238,35239,35289,35376,35397,35426,35444,35490,35554,35556,35585,35621,35639,35640,35643,35653,35688,35741,35744,35752,35757,35771,35805,35806,35808,35832,35846,35882,35926,35948,36000,36015,36053,36075,36208,36220,36237,36368,36369,36373,36385,36420,36441,36581,36584,36918,36930,36989,36998,37010,37136,37147,37180,37183,37283,37307,37308,37378,37534,37626,37644,37744,37759,37894,38001,38058,38126,38133,38330,38362,38433,38489,38546,38824,38877,38904,38912,38922,38949,38993,39205,39224,39240,39290,39296,39320,39381,39476,39497,39587,39600,39610,39717,39887,40086,40113,40319,40451,40492,40503,40509,40560,40578,40601,40647,40685,41049,41062,41120,41148,41171,41213,41332,41345,41477,41516,41781,41840,41969,42036,42253,42258,42538,42637,42682,42987,43016,43109,43165,43237,43271,43405,43446,43461,43483,43551,43712,44033,44053,44062,44366,44509,44573,44718,44788,44807,44829,44873,44912,44935,44936,44988,45101,45138,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 | 2085 | 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 | 1.03 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.37 ms |
System lock | 0.02 ms |
optimizing | 0.15 ms |
statistics | 3.38 ms |
preparing | 1.78 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 7.14 ms |
end | 0.02 ms |
query end | 0.06 ms |
closing tables | 0.03 ms |
freeing items | 0.12 ms |
cleaning up | 0.05 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 |