Tiempo de la consulta: 5.61 ms Después de la última consulta: 1.36 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.431 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 01:58:59')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 01:58:59')
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(1,11,17,49,58,83,111,151,154,158,159,204,234,255,263,282,293,325,332,353,357,420,437,446,447,458,478,485,495,510,512,521,529,531,537,542,547,558,560,566,567,593,605,607,618,639,644,645,653,663,669,671,686,695,701,719,721,723,729,756,757,760,777,806,816,836,845,850,862,868,879,886,911,912,915,933,944,955,977,986,1010,1027,1033,1057,1083,1094,1158,1173,1186,1207,1210,1214,1226,1234,1236,1240,1265,1277,1335,1339,1347,1463,1600,1643,1664,1698,1725,1768,1893,1898,2064,2094,2144,2150,2163,2164,2169,2178,2190,2192,2194,2195,2199,2201,2202,2204,2210,2213,2217,2222,2227,2232,2234,2237,2242,2245,2246,2249,2256,2273,2285,2286,2299,2319,2346,2348,2386,2398,2409,2733,2762,2827,2857,2859,2964,3022,3035,3049,3069,3113,3286,3295,3329,3353,3409,3520,3546,3696,3706,3852,3864,3884,3886,3898,3931,3932,3940,3993,4063,4096,4116,4153,4163,4188,4204,4229,4254,4276,4281,4286,4309,4409,4410,4436,4445,4453,4471,4661,4692,4765,4790,5001,5085,5300,5306,5515,5647,5648,5659,5730,5894,5918,6448,6520,6598,6681,6694,6703,6752,6775,6806,6809,6828,6908,6916,6941,6948,6989,6994,7105,7173,7212,7243,7275,7276,7277,7285,7288,7312,7326,7327,7335,7338,7346,7407,7418,7449,7462,7513,7516,7551,7577,7583,7666,7730,7757,7764,7829,7840,7871,7901,7965,8027,8053,8106,8138,8177,8258,8351,8445,8610,8663,8713,8864,8973,9249,9253,9254,9318,9414,9428,9432,9438,9451,9472,9473,9531,9532,9580,9734,9772,9832,9886,9891,9956,10024,10050,10077,10079,10149,10197,10198,10199,10207,10266,10290,10294,10303,10331,10350,10366,10401,10464,10484,10486,10499,10518,10537,10557,10690,10717,10731,10806,10831,10833,10912,10932,10986,11009,11027,11043,11087,11150,11182,11238,11242,11263,11273,11316,11345,11377,11447,11473,11494,11538,11542,11640,11666,11680,11692,11713,11716,11775,11823,11840,11870,11879,11880,11926,12011,12036,12042,12069,12085,12131,12136,12152,12216,12317,12319,12338,12362,12363,12366,12370,12448,12490,12514,12588,12604,12636,12670,12676,12677,12685,12738,12745,12757,12758,12769,12808,12810,12849,12909,12910,12920,12960,12965,12977,12983,13107,13132,13222,13235,13250,13257,13287,13345,13359,13379,13396,13440,13443,13446,13481,13594,13651,13664,13697,13708,13753,13766,13892,13985,14011,14013,14040,14069,14078,14092,14109,14133,14139,14175,14198,14199,14205,14227,14232,14234,14252,14268,14305,14307,14355,14378,14391,14421,14447,14450,14451,14480,14481,14493,14502,14505,14507,14517,14531,14557,14560,14570,14573,14591,14596,14610,14637,14654,14691,14699,14701,14774,14778,14798,14895,14926,14955,14979,14982,15002,15049,15060,15065,15076,15092,15105,15107,15109,15114,15115,15123,15144,15148,15158,15180,15206,15217,15226,15256,15257,15284,15297,15299,15304,15325,15344,15358,15371,15403,15410,15417,15441,15443,15445,15455,15472,15483,15492,15500,15577,15580,15609,15631,15632,15637,15639,15640,15642,15656,15733,15745,15760,15762,15766,15788,15811,15832,15835,15840,15877,15878,15879,15892,15954,16014,16024,16052,16053,16054,16125,16156,16167,16187,16192,16217,16261,16277,16279,16295,16328,16336,16353,16359,16364,16366,16368,16389,16404,16410,16436,16447,16458,16470,16476,16486,16490,16501,16518,16543,16554,16558,16607,16613,16627,16635,16642,16659,16662,16675,16682,16691,16698,16728,16778,16791,16792,16815,16820,16831,16843,16866,16893,16909,16948,16964,17001,17043,17059,17072,17149,17158,17185,17189,17214,17222,17247,17269,17280,17290,17300,17341,17346,17354,17364,17381,17390,17403,17417,17424,17441,17452,17460,17463,17485,17498,17500,17512,17536,17574,17596,17597,17615,17617,17620,17630,17633,17650,17688,17689,17701,17705,17712,17729,17733,17753,17759,17761,17772,17774,17783,17784,17810,17816,17824,17844,17885,17907,17918,17943,17951,17954,17973,17990,18001,18055,18098,18102,18158,18160,18176,18179,18217,18220,18221,18231,18238,18263,18277,18300,18315,18333,18337,18345,18352,18353,18361,18366,18380,18386,18401,18427,18434,18435,18455,18479,18485,18486,18520,18527,18537,18547,18562,18565,18576,18581,18586,18591,18619,18643,18648,18711,18716,18732,18744,18750,18762,18792,18805,18808,18809,18821,18839,18846,18847,18898,18909,18920,18936,18957,18960,18972,18973,18986,18993,18997,19027,19060,19063,19106,19120,19134,19136,19151,19172,19179,19183,19191,19205,19217,19224,19247,19251,19270,19280,19285,19303,19309,19313,19331,19352,19377,19383,19405,19413,19416,19419,19422,19433,19435,19437,19440,19453,19457,19484,19492,19494,19504,19522,19552,19556,19562,19566,19593,19604,19619,19625,19626,19651,19659,19666,19697,19720,19730,19733,19748,19752,19763,19766,19778,19779,19790,19806,19864,19874,19925,19944,19955,19957,19987,19993,19999,20007,20008,20035,20042,20076,20083,20098,20103,20116,20117,20146,20158,20166,20167,20199,20204,20205,20219,20229,20233,20236,20279,20282,20299,20305,20328,20332,20333,20344,20352,20359,20362,20399,20419,20420,20422,20423,20427,20457,20479,20487,20489,20537,20542,20554,20563,20574,20605,20608,20630,20681,20691,20712,20724,20753,20765,20769,20774,20776,20780,20782,20795,20799,20817,20826,20835,20841,20868,20877,20886,20912,20915,20947,20950,20956,20974,21013,21017,21055,21067,21085,21086,21105,21106,21108,21121,21128,21133,21149,21152,21163,21181,21184,21231,21242,21258,21293,21324,21350,21366,21387,21396,21398,21415,21452,21465,21482,21506,21518,21542,21545,21547,21566,21606,21628,21662,21665,21683,21689,21713,21716,21742,21750,21766,21775,21849,21859,21878,21894,21904,21919,21967,21994,22030,22031,22038,22052,22053,22088,22089,22122,22126,22137,22219,22225,22248,22266,22268,22292,22316,22336,22350,22359,22366,22378,22380,22382,22395,22414,22417,22419,22431,22485,22493,22498,22530,22546,22553,22559,22607,22622,22666,22668,22671,22681,22691,22740,22744,22752,22753,22766,22779,22786,22793,22804,22820,22822,22834,22857,22873,22875,22898,22899,22906,22913,22918,22921,22933,22934,22935,22936,22976,22998,23002,23006,23013,23015,23017,23026,23047,23050,23080,23103,23121,23126,23151,23181,23202,23222,23224,23242,23260,23271,23278,23279,23288,23295,23310,23318,23319,23338,23343,23354,23367,23380,23393,23396,23400,23417,23438,23444,23445,23466,23468,23477,23495,23512,23516,23527,23543,23578,23584,23596,23624,23634,23651,23659,23665,23666,23667,23677,23686,23693,23705,23709,23716,23719,23726,23731,23740,23756,23761,23768,23780,23782,23792,23806,23814,23816,23827,23855,23869,23873,23874,23876,23911,23914,23965,23989,23991,23998,24001,24002,24024,24059,24060,24082,24114,24171,24178,24190,24201,24210,24212,24260,24272,24299,24302,24340,24364,24373,24432,24470,24485,24543,24567,24573,24608,24630,24642,24657,24659,24671,24673,24681,24718,24734,24754,24780,24790,24804,24807,24836,24845,24851,24857,24872,24887,24900,24905,24906,24922,24927,24942,24945,24960,24967,24995,25038,25041,25064,25081,25090,25102,25103,25104,25119,25121,25137,25141,25143,25146,25163,25199,25200,25207,25218,25252,25258,25260,25310,25315,25332,25343,25345,25352,25353,25364,25366,25373,25380,25384,25386,25389,25402,25411,25420,25429,25434,25435,25452,25455,25461,25469,25474,25477,25483,25486,25501,25502,25513,25540,25554,25560,25573,25583,25595,25600,25614,25615,25616,25636,25650,25657,25663,25664,25676,25688,25697,25711,25718,25746,25753,25778,25790,25807,25813,25820,25822,25884,25886,25908,25911,25942,25948,25952,25971,26030,26043,26073,26103,26116,26133,26157,26174,26191,26193,26207,26209,26225,26236,26238,26239,26247,26250,26271,26275,26292,26293,26322,26324,26338,26344,26355,26387,26389,26392,26420,26431,26432,26434,26451,26452,26456,26479,26481,26513,26522,26541,26559,26560,26562,26571,26589,26594,26596,26598,26605,26618,26654,26697,26701,26709,26723,26741,26742,26776,26780,26792,26809,26814,26857,26859,26897,26898,26924,26934,26936,26939,26960,26969,27008,27015,27020,27022,27024,27025,27028,27040,27044,27055,27056,27058,27070,27075,27076,27079,27085,27093,27096,27127,27149,27248,27279,27355,27356,27368,27390,27403,27417,27420,27438,27442,27453,27477,27544,27563,27566,27572,27720,27724,27738,27739,27763,27822,27893,27898,27991,27998,28036,28116,28135,28185,28242,28294,28300,28309,28316,28342,28457,28461,28472,28484,28496,28499,28539,28609,28611,28617,28620,28651,28690,28712,28714,28715,28747,28755,28774,28787,28887,28910,28922,28939,29014,29023,29034,29089,29123,29241,29348,29381,29413,29445,29466,29467,29499,29534,29550,29551,29584,29588,29591,29658,29683,29722,29788,29801,29834,29837,29839,29872,29896,29897,29909,29915,29918,30111,30414,30939,30941,31090,31430,31510,31837,32136,32392,33385,33932,34150,35566,35730,35741,35803,35921,35942,35989,36017,36041,36042,36141,36235,36633,36866,36958,37587,38112,38380,38495,38597,38612,38712,38736,38793,38800,38846,38847,38852,38857,38867,38868,38878,38887,38916,38985,39025,39049,39144,39178,39318,39342,39369,39385,39387,39653,39657,39846,39858,39877,39902,39931,39941,39998,40014,40036,40050,40064,40214,40223,40521,40672,40681,40706,40797,40861,40909,41002,41005,41026,41034,41047,41104,41337,41399,41507,42210,42434,42455,42458,42532,42562,42948,43466,43842,43912,43981,43996,44289,44303,44770,45004,45005,45009,45023,45180)
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 | 1555 | 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.73 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.28 ms |
System lock | 0.02 ms |
optimizing | 0.11 ms |
statistics | 2.37 ms |
preparing | 1.19 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.31 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 |