Tiempo de la consulta: 6.64 ms Después de la última consulta: 1.77 ms Consulta a la memoria: 0.072 MB memoria antes de la consulta: 4.279 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-09 03:42:50')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 03:42:50')
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,14,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,49,58,72,83,127,154,163,174,204,253,255,263,272,325,332,353,354,446,458,478,484,485,490,501,505,507,510,512,518,521,529,531,537,542,547,550,551,558,560,566,567,583,593,607,608,618,667,671,686,695,705,707,709,723,729,740,745,756,757,760,801,806,813,816,845,850,867,868,879,881,882,886,887,895,899,911,915,917,933,955,961,968,977,986,1010,1027,1033,1057,1059,1068,1094,1124,1134,1137,1148,1158,1186,1198,1204,1207,1210,1214,1226,1234,1238,1240,1265,1277,1335,1339,1342,1343,1344,1347,1587,1594,1600,1664,1698,1768,1787,1901,2024,2094,2150,2290,2293,2361,2410,2482,2485,2593,2726,2733,2758,2797,2964,3022,3118,3166,3193,3223,3295,3306,3353,3409,3442,3495,3520,3546,3598,3626,3695,3696,3706,3769,3790,3837,3844,3864,3884,3898,3940,3993,4004,4063,4092,4096,4116,4153,4163,4276,4281,4309,4409,4410,4436,4445,4453,4471,4580,4631,4640,4692,4765,4790,4949,4996,5001,5051,5085,5262,5278,5284,5300,5301,5306,5365,5451,5515,5634,5647,5648,5659,5660,5726,5727,5730,5798,5841,5870,5894,5918,6089,6186,6245,6367,6448,6503,6520,6579,6598,6604,6605,6616,6681,6703,6708,6752,6764,6775,6793,6806,6809,6828,6916,6939,6941,6994,7105,7120,7173,7212,7243,7245,7276,7277,7285,7327,7328,7338,7346,7368,7407,7413,7415,7418,7449,7462,7484,7492,7513,7516,7551,7554,7577,7583,7587,7618,7666,7711,7720,7730,7757,7764,7802,7829,7840,7871,7901,7950,7965,7980,7994,8027,8053,8073,8093,8106,8138,8177,8181,8191,8258,8318,8340,8445,8533,8566,8568,8587,8610,8619,8663,8731,8786,8864,8973,9062,9066,9117,9253,9254,9257,9292,9351,9364,9472,9473,9531,9532,9550,9580,9619,9682,9734,9745,9772,9792,9820,9832,9886,9891,9945,9956,9971,10024,10050,10051,10077,10079,10149,10197,10198,10199,10207,10216,10237,10248,10260,10266,10282,10290,10303,10350,10369,10385,10401,10464,10478,10486,10499,10518,10537,10554,10557,10572,10666,10686,10690,10731,10806,10831,10833,10857,10860,10888,10912,10932,10971,10986,11006,11009,11027,11043,11087,11091,11123,11150,11182,11238,11263,11273,11290,11320,11377,11388,11447,11473,11487,11494,11538,11542,11666,11680,11692,11713,11716,11762,11775,11840,11870,11879,11880,11900,11925,11926,12011,12032,12036,12042,12069,12085,12126,12131,12136,12152,12186,12216,12237,12251,12317,12319,12338,12362,12363,12366,12369,12370,12448,12463,12474,12490,12493,12514,12588,12604,12608,12636,12670,12676,12685,12738,12745,12757,12758,12761,12810,12849,12910,12920,12952,12960,12965,12969,12977,12983,13020,13049,13107,13132,13143,13152,13176,13190,13191,13222,13235,13246,13250,13259,13277,13287,13309,13329,13345,13359,13379,13396,13434,13440,13446,13456,13481,13521,13543,13573,13594,13609,13616,13621,13631,13651,13662,13664,13673,13674,13697,13702,13708,13753,13860,13867,13892,13985,13986,13994,14005,14011,14040,14062,14069,14078,14092,14109,14133,14139,14175,14184,14198,14199,14205,14227,14232,14234,14252,14268,14273,14305,14339,14348,14355,14368,14378,14408,14421,14451,14456,14480,14493,14502,14505,14531,14539,14552,14557,14559,14564,14591,14596,14600,14610,14624,14637,14652,14654,14684,14691,14692,14699,14701,14726,14774,14778,14794,14798,14815,14839,14895,14926,14941,14955,14979,14982,15002,15028,15032,15060,15065,15092,15094,15105,15107,15108,15114,15115,15120,15123,15125,15144,15147,15148,15180,15196,15206,15215,15217,15226,15243,15256,15257,15259,15263,15266,15284,15297,15299,15304,15325,15344,15356,15358,15370,15371,15402,15403,15410,15417,15439,15441,15443,15445,15455,15464,15477,15483,15485,15492,15493,15500,15521,15548,15551,15562,15577,15580,15604,15609,15632,15637,15638,15639,15640,15642,15656,15664,15703,15709,15725,15728,15733,15745,15760,15762,15763,15766,15788,15811,15825,15832,15835,15837,15840,15841,15866,15873,15877,15878,15879,15892,15954,15955,16014,16020,16024,16037,16050,16052,16053,16054,16093,16125,16151,16153,16156,16161,16166,16167,16187,16217,16257,16261,16277,16279,16295,16328,16336,16353,16359,16368,16369,16370,16389,16404,16410,16436,16447,16451,16458,16470,16513,16518,16539,16554,16558,16605,16607,16613,16619,16627,16635,16642,16644,16659,16662,16682,16691,16698,16722,16778,16792,16815,16820,16825,16831,16843,16845,16866,16867,16893,16909,16936,16964,17001,17010,17043,17059,17072,17115,17128,17132,17136,17149,17158,17185,17189,17194,17214,17244,17247,17253,17257,17269,17280,17291,17314,17337,17341,17346,17354,17364,17373,17381,17390,17403,17407,17417,17420,17424,17432,17439,17441,17452,17460,17463,17465,17485,17493,17498,17500,17512,17533,17536,17547,17552,17569,17574,17596,17597,17617,17620,17623,17626,17630,17633,17650,17688,17689,17701,17705,17729,17733,17747,17753,17759,17761,17766,17772,17774,17775,17783,17784,17816,17824,17844,17852,17858,17875,17885,17889,17895,17907,17918,17951,17952,17954,17961,17973,17980,17987,17990,18001,18031,18033,18038,18055,18057,18072,18102,18116,18140,18158,18160,18169,18176,18179,18200,18216,18217,18220,18221,18231,18233,18238,18260,18263,18277,18300,18311,18314,18315,18316,18331,18337,18345,18352,18353,18361,18366,18392,18401,18402,18425,18427,18431,18434,18435,18440,18442,18455,18475,18479,18481,18485,18486,18493,18498,18514,18520,18524,18527,18537,18543,18547,18565,18566,18576,18581,18586,18591,18643,18646,18648,18649,18659,18668,18679,18687,18716,18732,18738,18744,18750,18781,18792,18793,18808,18809,18821,18837,18846,18873,18891,18898,18909,18914,18920,18930,18936,18951,18957,18960,18972,18973,18978,18986,18991,18993,18997,19013,19027,19053,19059,19060,19063,19078,19083,19106,19120,19134,19136,19151,19168,19172,19179,19191,19205,19217,19219,19224,19237,19247,19251,19264,19270,19271,19285,19293,19303,19309,19313,19318,19331,19352,19377,19383,19405,19411,19413,19419,19422,19427,19433,19437,19440,19448,19451,19453,19457,19484,19492,19494,19504,19505,19519,19522,19526,19535,19552,19553,19556,19562,19566,19577,19593,19595,19596,19604,19609,19612,19619,19625,19626,19645,19646,19651,19666,19681,19697,19699,19700,19720,19730,19748,19752,19763,19766,19778,19779,19790,19806,19841,19864,19874,19894,19925,19935,19944,19953,19955,19957,19987,19999,20007,20008,20012,20016,20035,20042,20076,20083,20098,20117,20133,20137,20146,20153,20154,20158,20166,20167,20181,20199,20204,20205,20229,20233,20236,20237,20252,20279,20282,20295,20299,20305,20328,20332,20333,20344,20349,20352,20359,20362,20399,20403,20419,20420,20422,20427,20432,20457,20479,20487,20489,20524,20537,20554,20574,20605,20608,20649,20691,20712,20714,20721,20724,20726,20738,20744,20753,20765,20769,20774,20776,20780,20782,20795,20799,20807,20817,20826,20833,20835,20841,20877,20880,20886,20896,20906,20912,20915,20924,20950,20956,20974,20980,21013,21017,21055,21064,21067,21085,21086,21105,21108,21115,21121,21128,21133,21149,21152,21163,21171,21181,21184,21198,21213,21231,21242,21251,21258,21293,21324,21331,21334,21366,21387,21396,21415,21430,21452,21464,21465,21472,21481,21482,21518,21539,21542,21547,21566,21576,21586,21606,21611,21628,21662,21665,21668,21683,21689,21709,21713,21716,21734,21742,21748,21750,21766,21775,21781,21849,21859,21878,21916,21952,21967,21994,22021,22031,22038,22045,22053,22066,22087,22088,22089,22122,22126,22137,22153,22192,22216,22219,22220,22225,22238,22248,22266,22268,22289,22292,22295,22316,22334,22350,22366,22371,22378,22380,22382,22388,22395,22402,22419,22431,22458,22476,22485,22493,22498,22500,22503,22509,22530,22543,22546,22553,22559,22587,22602,22607,22666,22668,22671,22679,22681,22691,22708,22738,22740,22744,22753,22766,22779,22786,22793,22822,22834,22857,22859,22873,22875,22876,22888,22891,22898,22906,22918,22921,22924,22931,22933,22934,22935,22936,22943,22976,22998,23002,23006,23013,23017,23023,23026,23028,23047,23050,23064,23080,23103,23107,23122,23126,23131,23151,23181,23202,23210,23219,23224,23236,23258,23260,23271,23278,23288,23299,23310,23312,23319,23338,23343,23354,23380,23396,23400,23417,23428,23445,23466,23468,23469,23477,23489,23495,23512,23516,23541,23543,23567,23584,23592,23613,23614,23624,23639,23649,23651,23657,23659,23665,23666,23667,23677,23686,23693,23705,23719,23722,23726,23729,23731,23740,23756,23761,23768,23780,23782,23792,23793,23806,23811,23816,23827,23855,23861,23868,23869,23873,23874,23876,23899,23911,23914,23965,23967,23973,23984,23989,23998,24001,24002,24006,24059,24082,24088,24105,24111,24114,24135,24158,24166,24171,24190,24198,24201,24210,24212,24229,24260,24273,24282,24289,24299,24340,24373,24375,24432,24470,24485,24498,24536,24543,24567,24607,24608,24630,24657,24658,24659,24671,24672,24673,24681,24713,24718,24722,24734,24754,24765,24780,24784,24790,24807,24814,24819,24823,24836,24838,24845,24851,24853,24857,24881,24887,24905,24922,24924,24927,24942,24944,24945,24958,24960,24967,24995,25038,25041,25048,25090,25093,25103,25104,25119,25137,25141,25143,25146,25155,25163,25183,25199,25200,25205,25207,25218,25252,25258,25260,25268,25312,25315,25342,25345,25349,25353,25365,25366,25373,25380,25397,25417,25421,25435,25449,25461,25469,25474,25483,25486,25488,25502,25513,25540,25541,25553,25554,25557,25583,25595,25600,25615,25616,25635,25650,25663,25668,25746,25753,25778,25790,25797,25813,25822,25847,25870,25886,25911,25952,25958,25969,26016,26020,26048,26073,26103,26116,26157,26159,26166,26174,26179,26191,26207,26209,26225,26236,26238,26247,26249,26271,26282,26293,26305,26322,26324,26338,26344,26355,26363,26369,26387,26389,26392,26420,26431,26432,26434,26452,26479,26481,26508,26513,26522,26560,26562,26564,26570,26589,26590,26594,26598,26605,26636,26654,26701,26726,26776,26779,26780,26792,26857,26860,26897,26924,26934,26936,26939,27008,27015,27020,27024,27028,27040,27055,27075,27076,27084,27085,27093,27096,27127,27131,27149,27248,27279,27316,27355,27356,27363,27368,27390,27403,27420,27438,27442,27453,27473,27477,27516,27563,27566,27572,27574,27645,27669,27720,27724,27739,27822,27893,27898,27991,27994,28005,28033,28107,28114,28116,28128,28135,28185,28242,28294,28303,28316,28318,28539,28609,28617,28621,28651,28712,28714,28715,28764,28771,28872,28910,28922,28943,28950,29023,29034,29089,29123,29172,29210,29348,29358,29381,29413,29438,29445,29466,29467,29499,29509,29510,29512,29550,29551,29584,29625,29653,29658,29683,29788,29801,29834,29837,29839,29846,29863,29872,29896,29897,29909,29915,29918,30111,30414,30433,30434,30941,31090,31510,31697,31837,31890,32136,32904,33385,33932,34150,35000,35660,35661,35727,35730,35741,35777,35803,35814,35921,35989,36017,36041,36141,36235,36633,36639,36866,36889,36958,37595,37606,38353,38465,38800,38852,38887,38916,38985,39178,39242,39318,39333,39342,39369,39465,39483,39540,39653,39698,39710,39757,39846,39858,39866,39877,39931,39941,39955,39995,39998,40050,40054,40064,40214,40224,40259,40292,40355,40521,40651,40672,40706,40861,40875,40909,41063,41104,41239,41337,41420,41431,41468,42317,42459,42662,43485,43879)
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 | 1862 | 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.80 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.33 ms |
System lock | 0.02 ms |
optimizing | 0.13 ms |
statistics | 2.82 ms |
preparing | 1.39 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.46 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.07 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 |