Tiempo de la consulta: 18.42 ms Después de la última consulta: 1.85 ms Consulta a la memoria: 1.580 MB memoria antes de la consulta: 4.270 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-03 21:16:33')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-03 21:16:33')
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(14,19,20,21,22,23,24,25,26,27,28,29,30,31,32,49,72,78,85,127,139,154,155,183,184,199,203,204,214,240,253,263,272,279,285,303,349,353,368,373,397,422,450,484,495,505,506,507,511,512,518,526,531,540,542,550,551,556,559,561,566,572,583,585,608,621,666,667,682,686,705,709,717,735,754,801,805,808,816,840,856,863,869,882,885,895,917,921,947,954,961,968,1022,1059,1101,1102,1104,1124,1134,1155,1164,1188,1198,1204,1207,1216,1226,1238,1278,1279,1316,1347,1351,1397,1398,1408,1482,1498,1538,1565,1571,1587,1588,1594,1616,1626,1634,1645,1648,1656,1660,1670,1730,1731,1732,1734,1739,1740,1787,1795,1846,1867,1901,1953,1976,2024,2066,2130,2150,2290,2293,2308,2328,2353,2402,2427,2482,2546,2641,2647,2726,2758,2797,2954,3106,3107,3131,3174,3177,3193,3306,3328,3353,3369,3402,3409,3412,3442,3454,3490,3495,3519,3577,3616,3626,3663,3696,3769,3837,3855,3888,4004,4038,4052,4092,4142,4329,4330,4332,4344,4362,4395,4410,4503,4567,4572,4580,4589,4631,4640,4823,4845,4860,4884,4913,5051,5111,5139,5182,5249,5302,5365,5369,5396,5444,5451,5461,5478,5536,5543,5576,5580,5634,5658,5660,5694,5726,5727,5730,5731,5769,5792,5798,5800,5814,5846,5857,5878,5880,5913,5922,6043,6055,6066,6084,6120,6127,6178,6186,6245,6264,6350,6367,6466,6503,6523,6524,6604,6605,6616,6621,6639,6695,6708,6764,6793,6854,6876,6939,6953,7083,7122,7125,7181,7245,7246,7267,7268,7279,7353,7358,7365,7368,7413,7449,7478,7484,7492,7497,7513,7555,7573,7588,7618,7688,7689,7711,7716,7717,7720,7736,7764,7802,7818,7841,7897,7924,7950,7965,7980,7994,8021,8027,8042,8046,8073,8090,8116,8118,8338,8351,8483,8566,8568,8577,8587,8591,8610,8681,8864,8865,8934,8974,9029,9053,9068,9087,9116,9257,9341,9351,9364,9560,9584,9613,9734,9745,9781,9792,9820,9836,9877,9896,9939,9945,10051,10118,10134,10189,10216,10226,10237,10241,10243,10247,10248,10260,10264,10267,10282,10287,10369,10385,10418,10438,10442,10451,10475,10477,10478,10554,10630,10666,10686,10708,10731,10801,10835,10857,10888,10912,10971,10986,11001,11006,11029,11045,11059,11091,11123,11163,11290,11320,11354,11388,11425,11442,11446,11448,11472,11487,11548,11713,11756,11762,11822,11840,11900,11925,11983,12032,12069,12095,12126,12171,12186,12197,12223,12230,12237,12251,12274,12289,12358,12369,12397,12401,12410,12463,12474,12482,12487,12493,12592,12608,12619,12620,12624,12625,12637,12662,12677,12708,12718,12738,12745,12748,12786,12800,12824,12875,12884,12951,12962,13017,13020,13036,13040,13143,13176,13190,13191,13194,13246,13259,13294,13298,13309,13321,13328,13413,13434,13451,13456,13460,13534,13535,13573,13609,13621,13631,13657,13662,13671,13673,13674,13687,13702,13707,13773,13842,13860,13865,13867,13886,13894,13935,13975,13986,13994,14000,14005,14049,14062,14074,14087,14092,14099,14105,14119,14142,14184,14205,14218,14227,14234,14268,14271,14273,14282,14339,14348,14356,14360,14368,14396,14408,14416,14456,14521,14524,14557,14574,14578,14600,14624,14646,14651,14652,14680,14684,14692,14720,14726,14746,14753,14765,14770,14794,14815,14818,14823,14837,14931,14941,14982,14987,15002,15004,15024,15028,15029,15030,15032,15037,15043,15049,15060,15065,15086,15092,15108,15110,15114,15120,15123,15147,15166,15196,15201,15215,15222,15226,15230,15243,15247,15263,15266,15272,15304,15307,15314,15319,15324,15344,15356,15358,15360,15370,15371,15377,15382,15390,15402,15403,15406,15421,15424,15439,15443,15464,15477,15482,15485,15492,15500,15521,15525,15542,15548,15550,15551,15562,15563,15575,15604,15642,15660,15661,15664,15666,15673,15694,15703,15709,15714,15717,15725,15728,15730,15733,15744,15762,15763,15784,15786,15788,15808,15809,15819,15825,15837,15840,15841,15843,15861,15862,15866,15873,15874,15897,15901,15907,15936,15941,15945,15955,15965,15982,15997,16000,16020,16037,16050,16058,16093,16125,16136,16140,16153,16154,16161,16163,16166,16167,16176,16200,16206,16231,16257,16261,16278,16328,16353,16369,16370,16400,16414,16415,16422,16437,16438,16441,16451,16463,16467,16473,16497,16499,16508,16513,16514,16534,16539,16543,16560,16605,16613,16619,16644,16652,16657,16661,16663,16682,16689,16704,16716,16717,16720,16722,16772,16778,16809,16812,16820,16823,16825,16845,16866,16867,16882,16884,16893,16894,16904,16929,16936,17000,17018,17059,17063,17066,17084,17114,17115,17128,17132,17158,17160,17194,17205,17215,17229,17242,17244,17257,17283,17290,17291,17299,17334,17337,17347,17348,17349,17355,17358,17361,17369,17373,17393,17399,17407,17409,17420,17424,17432,17439,17445,17465,17493,17496,17511,17520,17533,17552,17560,17568,17569,17571,17585,17596,17597,17603,17623,17626,17656,17659,17666,17688,17702,17705,17707,17721,17733,17747,17763,17766,17772,17773,17774,17775,17782,17816,17818,17831,17852,17857,17875,17885,17886,17889,17895,17900,17918,17919,17939,17951,17952,17955,17961,17965,17973,17980,17987,17996,18001,18002,18031,18038,18053,18057,18063,18072,18079,18081,18082,18086,18102,18116,18133,18140,18143,18169,18174,18179,18200,18213,18216,18239,18258,18260,18309,18311,18313,18314,18316,18326,18331,18336,18343,18345,18361,18362,18384,18401,18402,18419,18424,18425,18426,18431,18435,18439,18440,18442,18454,18481,18493,18496,18498,18501,18508,18514,18524,18531,18537,18538,18543,18555,18566,18569,18573,18576,18577,18579,18598,18607,18612,18617,18621,18622,18640,18641,18642,18646,18649,18659,18668,18671,18674,18675,18679,18681,18682,18687,18689,18695,18705,18720,18731,18732,18738,18739,18765,18769,18775,18781,18792,18793,18820,18822,18837,18845,18847,18848,18852,18861,18866,18870,18874,18886,18891,18894,18898,18901,18910,18911,18914,18921,18930,18936,18948,18951,18953,18955,18978,18989,18991,18993,19002,19010,19013,19022,19024,19027,19034,19043,19052,19053,19059,19074,19076,19078,19083,19086,19101,19105,19120,19136,19150,19168,19171,19185,19198,19207,19218,19219,19237,19247,19250,19254,19268,19271,19274,19276,19281,19293,19294,19304,19305,19318,19321,19326,19327,19357,19358,19362,19366,19386,19396,19411,19427,19431,19438,19441,19442,19448,19453,19457,19495,19499,19503,19505,19519,19524,19526,19535,19553,19556,19566,19567,19582,19591,19595,19596,19604,19612,19613,19620,19640,19645,19646,19650,19654,19661,19662,19699,19700,19708,19720,19747,19748,19751,19761,19762,19767,19778,19781,19790,19841,19845,19858,19867,19881,19894,19906,19927,19932,19943,19953,19957,19962,19966,19979,19980,19991,19994,20001,20003,20008,20012,20016,20024,20032,20035,20036,20048,20050,20071,20076,20081,20097,20099,20100,20103,20133,20137,20153,20154,20156,20162,20166,20170,20181,20183,20187,20191,20204,20212,20216,20247,20253,20287,20295,20318,20343,20349,20354,20360,20370,20374,20379,20386,20391,20399,20403,20427,20432,20440,20450,20464,20518,20522,20524,20526,20558,20567,20578,20579,20603,20617,20649,20659,20683,20688,20700,20714,20716,20721,20726,20727,20738,20744,20752,20768,20770,20778,20780,20799,20804,20807,20810,20830,20847,20880,20884,20894,20896,20906,20924,20936,20945,20961,20980,20986,20990,21002,21016,21080,21103,21104,21105,21115,21123,21126,21130,21136,21150,21151,21161,21171,21178,21182,21198,21213,21243,21251,21252,21254,21258,21290,21301,21311,21313,21331,21341,21342,21365,21366,21368,21375,21376,21377,21379,21388,21404,21416,21418,21419,21422,21430,21448,21452,21454,21472,21481,21513,21516,21522,21526,21536,21539,21547,21557,21563,21574,21576,21583,21586,21604,21611,21623,21633,21659,21664,21668,21669,21693,21695,21709,21733,21734,21738,21748,21757,21761,21767,21781,21885,21886,21906,21912,21914,21916,21950,21951,21952,21988,22012,22021,22031,22038,22045,22059,22062,22066,22071,22080,22081,22082,22085,22087,22106,22140,22150,22153,22156,22192,22206,22216,22218,22220,22221,22232,22238,22239,22241,22243,22244,22245,22246,22267,22287,22289,22292,22295,22296,22334,22339,22346,22354,22365,22371,22388,22402,22409,22446,22458,22476,22478,22481,22496,22498,22500,22502,22503,22509,22510,22514,22527,22528,22543,22564,22580,22582,22587,22593,22602,22653,22655,22662,22669,22708,22713,22738,22742,22744,22757,22771,22772,22793,22797,22805,22829,22861,22865,22871,22874,22876,22888,22891,22895,22908,22929,22931,22943,22963,22972,23013,23023,23028,23034,23042,23064,23072,23081,23099,23107,23122,23124,23131,23191,23203,23210,23218,23219,23236,23240,23256,23258,23265,23268,23271,23275,23281,23299,23300,23302,23310,23312,23336,23345,23357,23382,23387,23390,23396,23398,23400,23408,23417,23426,23428,23468,23469,23483,23489,23498,23541,23561,23565,23567,23592,23613,23618,23628,23632,23648,23649,23656,23657,23685,23710,23722,23729,23759,23763,23791,23793,23811,23839,23845,23853,23854,23855,23857,23861,23881,23886,23887,23899,23900,23913,23920,23922,23930,23942,23955,23958,23962,23964,23967,23973,23975,23984,23989,23996,24008,24068,24070,24072,24076,24085,24088,24096,24105,24109,24111,24124,24130,24135,24141,24146,24158,24166,24171,24173,24174,24185,24188,24198,24209,24229,24249,24259,24260,24264,24282,24289,24303,24307,24331,24333,24343,24346,24375,24378,24386,24393,24414,24433,24437,24472,24485,24498,24536,24543,24569,24570,24579,24583,24587,24607,24618,24624,24651,24657,24658,24709,24713,24722,24731,24747,24765,24779,24784,24791,24814,24816,24819,24823,24838,24853,24861,24874,24881,24888,24924,24926,24930,24943,24944,24958,24968,24979,24989,24993,24994,24997,25048,25063,25072,25093,25095,25097,25100,25104,25126,25137,25151,25155,25171,25180,25183,25184,25194,25205,25216,25225,25227,25245,25255,25260,25268,25288,25307,25312,25342,25349,25351,25358,25360,25365,25397,25417,25418,25421,25442,25449,25453,25461,25474,25488,25490,25505,25506,25518,25541,25549,25553,25557,25563,25589,25595,25600,25602,25608,25624,25635,25642,25668,25673,25716,25748,25766,25780,25791,25797,25800,25809,25813,25818,25821,25826,25847,25864,25868,25870,25874,25876,25890,25922,25924,25933,25955,25958,25969,25991,25994,26013,26020,26025,26038,26048,26056,26073,26074,26099,26103,26118,26120,26122,26159,26166,26179,26185,26227,26244,26249,26260,26282,26283,26296,26305,26321,26335,26336,26342,26343,26344,26346,26355,26363,26366,26367,26369,26387,26392,26420,26426,26434,26446,26452,26454,26455,26486,26491,26496,26498,26505,26508,26544,26564,26569,26570,26590,26606,26620,26623,26634,26636,26656,26660,26665,26674,26677,26689,26691,26699,26702,26706,26726,26727,26739,26765,26772,26779,26780,26784,26790,26808,26811,26860,26881,26898,26900,26910,26918,26927,26928,26939,26945,26946,26956,26971,26973,26990,26996,27021,27024,27026,27045,27057,27075,27084,27131,27132,27151,27183,27186,27187,27199,27208,27222,27236,27258,27279,27303,27320,27340,27356,27363,27366,27372,27386,27396,27401,27403,27420,27441,27449,27454,27466,27473,27490,27496,27510,27520,27530,27541,27545,27551,27562,27563,27570,27574,27582,27583,27592,27623,27627,27628,27636,27650,27654,27655,27671,27677,27686,27692,27724,27738,27739,27750,27761,27813,27828,27890,27910,27916,27919,27922,27937,27946,28005,28021,28032,28033,28067,28107,28114,28115,28127,28128,28158,28166,28177,28187,28195,28214,28303,28318,28329,28351,28452,28531,28621,28673,28709,28718,28750,28764,28771,28786,28845,28872,28943,28950,28973,28984,28993,29019,29020,29053,29101,29121,29155,29171,29172,29197,29210,29218,29334,29349,29358,29365,29382,29394,29406,29411,29438,29460,29503,29509,29510,29512,29517,29563,29568,29625,29639,29642,29644,29653,29681,29720,29791,29814,29837,29839,29846,29863,29898,29915,29918,30433,30434,31551,31697,31767,31890,32182,32642,32643,32644,32756,33650,34797,35000,35144,35594,35660,35661,35727,35777,35814,35965,35997,36015,36293,36320,36345,36502,36623,36889,37468,37510,38575,38831,38853,39269,39333,39418,39462,39465,39483,39502,39674,39698,39710,39866,39876,39905,40046,40062,40161,40213,40224,40259,40277,40355,40408,40414,40454,40647,40651,40875,40946,40947,40948,40949,40950,40962,41057,41076,41186,41239,41336,41643,42144,43200,43302,43480,43481,43510,43951,43990,44020,44115,44144,44145,44188,44206,44207,44241,44345,44509,44661,44664,44827,45111)
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 | 2043 | 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.98 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.34 ms |
System lock | 0.03 ms |
optimizing | 0.13 ms |
statistics | 3.18 ms |
preparing | 1.63 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 11.42 ms |
end | 0.02 ms |
query end | 0.05 ms |
closing tables | 0.02 ms |
freeing items | 0.14 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 |