Tiempo de la consulta: 11.97 ms Después de la última consulta: 2.23 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 4.490 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 03:28:16')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 03:28:16')
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(9,14,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,39,40,41,42,43,45,46,49,54,62,65,70,71,72,73,75,95,126,127,128,129,174,197,204,253,255,263,272,275,277,294,307,344,353,389,415,458,481,484,505,507,550,551,583,607,608,611,643,659,667,686,701,705,709,735,764,799,801,816,868,882,895,903,917,946,961,968,970,973,988,1059,1078,1080,1124,1134,1183,1198,1201,1204,1207,1226,1238,1277,1324,1329,1335,1337,1340,1347,1361,1364,1456,1501,1519,1563,1571,1587,1594,1607,1697,1756,1757,1787,1823,1825,1883,1922,1976,2018,2024,2041,2042,2084,2150,2181,2195,2285,2289,2290,2293,2305,2353,2371,2482,2489,2604,2608,2611,2695,2726,2732,2750,2758,2797,2827,2857,2886,2887,2893,2909,2946,3080,3123,3193,3196,3208,3255,3266,3302,3306,3329,3353,3364,3393,3442,3452,3491,3495,3591,3603,3604,3620,3626,3685,3696,3700,3732,3737,3760,3767,3769,3776,3782,3829,3833,3837,3880,3913,3931,3932,3960,3961,3980,3986,4004,4034,4092,4101,4110,4114,4118,4129,4148,4150,4204,4209,4255,4284,4323,4327,4410,4423,4456,4459,4488,4548,4575,4580,4631,4640,4739,4765,4767,4813,4859,4872,4940,5051,5085,5154,5207,5208,5259,5348,5365,5387,5422,5439,5451,5472,5491,5617,5634,5647,5658,5660,5698,5726,5727,5730,5749,5798,5827,5833,5877,5894,5896,5909,5924,5968,6015,6076,6100,6128,6141,6186,6245,6278,6279,6319,6339,6360,6362,6367,6415,6440,6454,6463,6475,6476,6477,6503,6515,6517,6534,6542,6543,6545,6548,6568,6583,6594,6604,6605,6614,6616,6628,6632,6643,6649,6658,6708,6720,6751,6762,6764,6791,6793,6865,6881,6888,6889,6935,6939,6969,7005,7045,7077,7105,7111,7136,7139,7150,7185,7193,7201,7216,7245,7250,7258,7270,7331,7364,7368,7379,7413,7417,7429,7444,7447,7463,7484,7489,7492,7516,7545,7553,7586,7594,7605,7614,7618,7648,7651,7675,7691,7711,7718,7720,7724,7741,7743,7752,7771,7777,7784,7787,7802,7829,7835,7837,7860,7895,7903,7925,7934,7935,7942,7950,7954,7955,7960,7964,7965,7980,7987,7992,7994,8004,8015,8026,8027,8052,8055,8061,8073,8074,8147,8152,8160,8173,8190,8223,8227,8234,8265,8351,8370,8378,8381,8421,8507,8550,8565,8566,8568,8587,8610,8611,8638,8644,8660,8663,8689,8700,8750,8753,8759,8776,8799,8813,8826,8849,8858,8860,8864,8894,8901,8909,8925,8954,8983,9015,9016,9063,9073,9077,9079,9086,9120,9181,9207,9257,9328,9350,9351,9390,9398,9412,9422,9477,9578,9600,9610,9653,9654,9704,9727,9734,9738,9745,9792,9820,9829,9838,9853,9878,9904,9908,9922,9942,9945,9956,9963,9969,10004,10019,10051,10068,10071,10078,10120,10138,10180,10190,10192,10195,10202,10216,10222,10237,10247,10248,10260,10265,10268,10269,10274,10278,10282,10289,10313,10340,10351,10369,10384,10385,10414,10416,10439,10448,10452,10471,10478,10479,10485,10513,10519,10554,10617,10628,10642,10666,10673,10686,10696,10754,10756,10810,10827,10857,10888,10912,10926,10971,10982,10987,10993,11006,11023,11031,11032,11034,11038,11041,11045,11065,11073,11080,11091,11101,11108,11121,11123,11150,11171,11179,11188,11189,11224,11230,11235,11247,11250,11286,11290,11293,11320,11328,11338,11370,11383,11387,11388,11399,11438,11487,11488,11534,11542,11545,11611,11626,11675,11687,11719,11762,11764,11796,11826,11836,11848,11900,11912,11921,11925,11944,11945,11951,11992,12032,12076,12092,12108,12115,12126,12176,12186,12237,12248,12249,12251,12307,12311,12321,12340,12341,12369,12415,12463,12474,12493,12516,12553,12554,12557,12584,12608,12632,12638,12657,12665,12672,12677,12689,12690,12697,12718,12723,12750,12752,12758,12760,12794,12804,12808,12818,12834,12868,12912,12945,13020,13043,13055,13081,13082,13143,13146,13162,13166,13172,13176,13190,13191,13209,13218,13231,13242,13243,13246,13259,13306,13309,13329,13358,13371,13376,13385,13410,13421,13425,13434,13456,13460,13495,13511,13529,13543,13573,13593,13600,13603,13609,13613,13621,13631,13646,13662,13673,13674,13675,13695,13702,13703,13705,13706,13707,13709,13713,13715,13731,13733,13738,13741,13742,13758,13759,13760,13772,13789,13808,13826,13831,13838,13860,13867,13883,13911,13920,13926,13933,13946,13961,13972,13986,13994,13996,14005,14048,14053,14054,14057,14062,14076,14096,14101,14115,14125,14141,14147,14148,14184,14200,14202,14205,14227,14249,14270,14273,14281,14282,14291,14339,14348,14351,14368,14385,14396,14408,14456,14470,14471,14486,14489,14512,14513,14515,14521,14523,14532,14555,14556,14572,14600,14601,14616,14624,14639,14652,14657,14662,14684,14692,14694,14730,14732,14739,14794,14796,14815,14820,14824,14825,14839,14841,14851,14903,14939,14941,14949,14959,14980,14981,14999,15006,15028,15041,15051,15069,15081,15108,15115,15120,15122,15147,15148,15154,15160,15178,15193,15196,15213,15215,15243,15245,15249,15263,15266,15268,15269,15277,15301,15304,15326,15330,15346,15347,15349,15354,15356,15370,15373,15378,15388,15402,15411,15418,15423,15439,15457,15464,15465,15470,15475,15477,15482,15485,15487,15497,15498,15499,15521,15524,15548,15551,15562,15570,15582,15588,15604,15611,15613,15617,15632,15633,15636,15637,15640,15664,15703,15709,15725,15728,15738,15750,15763,15767,15783,15787,15789,15837,15841,15842,15864,15866,15873,15893,15900,15913,15926,15955,15964,15979,16020,16023,16036,16037,16039,16042,16050,16059,16060,16082,16084,16086,16093,16097,16127,16128,16129,16145,16153,16156,16164,16166,16168,16181,16194,16199,16208,16220,16235,16248,16256,16257,16264,16280,16283,16292,16314,16315,16320,16327,16341,16342,16356,16366,16369,16370,16373,16394,16403,16405,16416,16451,16455,16460,16468,16507,16513,16515,16539,16552,16560,16577,16605,16619,16644,16659,16663,16664,16686,16722,16759,16795,16825,16828,16829,16844,16845,16867,16887,16890,16922,16965,16976,16991,16996,17004,17005,17042,17048,17053,17059,17074,17090,17102,17125,17128,17132,17145,17160,17169,17183,17194,17205,17216,17229,17233,17234,17243,17244,17250,17257,17276,17277,17291,17318,17322,17337,17373,17374,17392,17407,17411,17420,17432,17434,17438,17457,17459,17464,17465,17468,17470,17493,17494,17517,17519,17533,17541,17552,17554,17557,17568,17569,17596,17601,17613,17623,17626,17633,17650,17681,17688,17707,17715,17723,17730,17747,17753,17766,17772,17775,17776,17781,17813,17815,17822,17832,17843,17844,17846,17852,17855,17859,17875,17889,17890,17893,17895,17901,17908,17912,17923,17925,17926,17935,17952,17953,17956,17966,17972,17980,17987,17993,17998,18007,18018,18031,18032,18038,18046,18047,18048,18054,18056,18057,18062,18069,18072,18100,18102,18116,18122,18134,18140,18144,18156,18157,18169,18180,18200,18216,18233,18239,18244,18255,18260,18274,18281,18282,18292,18296,18311,18314,18316,18331,18344,18352,18355,18362,18368,18379,18380,18395,18402,18408,18425,18427,18431,18434,18436,18440,18447,18449,18460,18479,18481,18492,18493,18514,18518,18524,18539,18543,18544,18562,18563,18564,18566,18569,18592,18593,18594,18608,18617,18627,18640,18646,18648,18649,18659,18668,18674,18679,18680,18687,18691,18697,18709,18722,18733,18738,18746,18764,18765,18773,18781,18790,18793,18800,18812,18823,18825,18837,18846,18862,18878,18886,18889,18891,18896,18914,18916,18922,18930,18931,18938,18949,18951,18954,18960,18975,18978,18980,18991,19006,19011,19013,19018,19026,19028,19029,19034,19042,19053,19059,19065,19073,19078,19083,19092,19105,19109,19117,19124,19128,19134,19135,19139,19155,19168,19195,19201,19208,19218,19219,19237,19240,19247,19260,19266,19271,19290,19292,19293,19304,19306,19313,19318,19329,19346,19366,19370,19381,19408,19409,19411,19415,19427,19428,19429,19447,19448,19457,19469,19490,19497,19505,19508,19510,19519,19526,19530,19535,19537,19542,19545,19550,19553,19556,19561,19576,19578,19585,19589,19590,19595,19596,19604,19606,19612,19621,19623,19637,19645,19646,19652,19662,19667,19679,19682,19699,19700,19713,19718,19720,19732,19741,19744,19764,19775,19789,19810,19825,19841,19852,19853,19872,19882,19883,19894,19930,19931,19944,19945,19951,19953,19970,19971,19995,20012,20016,20018,20029,20030,20070,20075,20076,20109,20127,20133,20137,20153,20154,20164,20172,20181,20195,20207,20241,20247,20250,20260,20264,20268,20273,20274,20291,20295,20313,20327,20347,20348,20349,20365,20376,20378,20393,20398,20403,20407,20426,20429,20432,20444,20455,20461,20462,20496,20512,20524,20534,20542,20543,20602,20621,20649,20651,20662,20678,20684,20685,20701,20704,20707,20714,20721,20726,20738,20741,20744,20745,20747,20748,20764,20779,20783,20795,20797,20807,20809,20813,20818,20820,20828,20840,20850,20870,20880,20888,20896,20906,20914,20915,20939,20945,20958,20959,20977,20980,21000,21020,21054,21057,21062,21073,21101,21106,21107,21108,21115,21120,21141,21143,21161,21164,21171,21179,21190,21198,21202,21213,21219,21229,21238,21248,21249,21251,21274,21286,21292,21307,21310,21317,21319,21322,21325,21331,21336,21348,21369,21372,21373,21381,21388,21397,21407,21430,21434,21435,21446,21450,21458,21464,21472,21481,21489,21499,21504,21539,21548,21552,21554,21563,21568,21576,21578,21584,21586,21590,21592,21611,21612,21635,21638,21641,21645,21651,21668,21669,21675,21709,21710,21734,21737,21739,21740,21744,21748,21763,21764,21774,21776,21777,21781,21820,21821,21851,21855,21858,21871,21883,21886,21894,21916,21921,21922,21923,21931,21939,21944,21948,21952,21969,21976,21982,22001,22010,22021,22025,22029,22038,22040,22043,22045,22063,22065,22066,22073,22087,22101,22110,22128,22153,22160,22176,22177,22192,22211,22214,22216,22223,22237,22238,22250,22260,22286,22289,22294,22295,22298,22307,22313,22318,22319,22325,22334,22336,22338,22348,22352,22360,22371,22387,22388,22402,22407,22422,22455,22458,22459,22461,22476,22487,22500,22503,22504,22509,22533,22543,22546,22558,22587,22594,22602,22607,22617,22647,22648,22675,22686,22688,22700,22702,22708,22723,22733,22738,22739,22741,22755,22763,22770,22778,22803,22819,22820,22831,22837,22849,22852,22853,22861,22876,22888,22889,22890,22891,22901,22904,22924,22931,22935,22943,22956,22957,22996,23019,23023,23028,23030,23041,23044,23045,23063,23064,23065,23067,23070,23073,23077,23079,23090,23107,23122,23128,23131,23153,23163,23165,23185,23195,23201,23210,23219,23220,23236,23237,23241,23243,23244,23255,23258,23260,23280,23284,23299,23303,23312,23313,23320,23323,23325,23326,23328,23330,23335,23339,23341,23366,23375,23382,23386,23415,23418,23424,23428,23433,23436,23441,23443,23449,23469,23484,23485,23487,23489,23518,23524,23534,23541,23545,23567,23575,23578,23582,23592,23613,23617,23635,23649,23657,23660,23672,23673,23678,23679,23680,23684,23706,23708,23722,23729,23735,23737,23749,23764,23793,23811,23819,23822,23855,23856,23861,23890,23899,23913,23926,23930,23950,23954,23960,23966,23967,23973,23978,23984,23987,23992,23994,24006,24013,24063,24075,24084,24088,24102,24104,24105,24111,24121,24135,24142,24152,24158,24166,24176,24184,24191,24198,24223,24229,24236,24273,24274,24276,24282,24289,24293,24325,24327,24332,24347,24357,24366,24371,24375,24381,24392,24419,24433,24475,24495,24497,24498,24503,24513,24536,24550,24592,24607,24612,24614,24636,24638,24642,24644,24646,24658,24665,24675,24682,24687,24698,24702,24713,24717,24722,24727,24733,24765,24767,24769,24770,24771,24783,24784,24812,24814,24816,24817,24819,24823,24828,24831,24837,24838,24839,24844,24853,24858,24863,24877,24881,24899,24902,24904,24924,24944,24947,24958,24964,24987,25011,25012,25039,25041,25048,25056,25072,25093,25098,25107,25125,25133,25135,25155,25162,25174,25183,25205,25208,25225,25248,25250,25253,25263,25268,25277,25279,25280,25301,25312,25313,25342,25349,25361,25365,25377,25380,25394,25397,25417,25421,25442,25449,25474,25488,25528,25535,25541,25548,25553,25557,25567,25595,25608,25635,25644,25645,25657,25668,25696,25714,25725,25730,25732,25763,25785,25797,25799,25847,25850,25870,25882,25923,25932,25945,25946,25958,25969,25993,26020,26031,26048,26078,26159,26166,26167,26178,26179,26183,26228,26249,26250,26255,26256,26273,26282,26287,26295,26305,26317,26363,26369,26408,26423,26493,26501,26504,26508,26521,26530,26543,26563,26564,26570,26573,26574,26590,26629,26636,26648,26726,26741,26765,26778,26779,26824,26832,26860,26861,26901,26926,26928,26938,26972,27002,27011,27014,27024,27056,27084,27125,27130,27131,27150,27152,27170,27246,27273,27283,27319,27321,27362,27363,27365,27394,27418,27427,27431,27441,27482,27496,27517,27521,27545,27574,27575,27593,27644,27686,27704,27721,27833,27842,27917,27920,27931,27936,27938,28005,28020,28033,28045,28082,28104,28107,28114,28128,28192,28225,28250,28303,28312,28318,28327,28411,28436,28559,28561,28607,28608,28621,28630,28639,28640,28646,28653,28658,28677,28692,28763,28764,28765,28771,28803,28837,28872,28899,28943,28950,28961,28989,28992,29008,29009,29012,29022,29032,29066,29117,29118,29152,29153,29172,29174,29180,29197,29210,29244,29319,29329,29356,29358,29417,29438,29443,29444,29461,29475,29476,29478,29485,29486,29488,29491,29509,29510,29512,29559,29625,29653,29686,29781,29823,29832,29846,29863,29905,29922,29923,29935,30255,30285,30326,30433,30434,30481,31172,31697,31853,31890,31995,32768,32842,33018,33039,33081,33270,33300,33877,34093,34749,34884,34998,35000,35087,35165,35176,35178,35217,35394,35594,35595,35600,35617,35660,35661,35689,35726,35727,35731,35777,35814,35883,35884,35885,36057,36058,36059,36150,36185,36193,36195,36283,36322,36472,36549,36602,36798,36821,36834,36889,37029,37035,37036,37744,37913,37915,38082,38397,38518,38550,38551,38607,38807,38811,38831,38854,38866,38873,38903,38927,38934,38999,39033,39048,39102,39111,39195,39283,39302,39333,39384,39413,39431,39445,39464,39465,39481,39483,39493,39505,39542,39544,39603,39646,39650,39666,39681,39698,39710,39819,39857,39866,39917,39979,39998,40025,40038,40083,40097,40110,40147,40170,40200,40224,40259,40355,40490,40515,40545,40558,40580,40651,40708,40759,40785,40809,40875,40907,40937,40942,40984,41035,41041,41058,41059,41069,41082,41184,41239,41255,41292,41301,41305,41325,41350,41375,41808,42125,42264,42468,42629,42643,42665,42673,42692,42719,42723,42724,42835,42850,42870,42891,42898,42910,42961,42967,42968,42969,42970,42986,42989,43010,43047,43048,43049,43067,43110,43308,43645,43656,43761,44136,44722,44903)
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 | 2399 | 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 | 2.79 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.06 ms |
init | 0.63 ms |
System lock | 0.02 ms |
optimizing | 0.15 ms |
statistics | 5.15 ms |
preparing | 2.11 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.40 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.11 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 |