Czas zapytania: 104.39 ms Po ostatnim zapytaniu: 3.24 ms Pamięć zapytania: 0.007 MB Pamięć przed zapytaniem: 3.547 MB Zwróconych wierszy: 5
SELECT i.*, c.alias AS categoryalias
FROM tvs_k2_items AS i
LEFT JOIN tvs_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-04-17 19:54:02')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-04-17 19:54:02')
AND i.access IN(1,1)
AND c.access IN(1,1)
AND c.published = 1
AND c.trash = 0
AND i.id IN(586,616,617,652,660,668,943,944,945,946,947,948,949,950,951,952,953,954,955,956,957,958,959,960,961,962,977,979,1012,1034,1064,1080,1085,1093,1094,1101,1114,1120,1125,1129,1134,1135,1140,1141,1144,1146,1194,1199,1232,1233,1234,1235,1236,1237,1238,1239,1257,1268,1269,1270,1282,1294,1353,1399,1401,1429,1436,1440,1459,1462,1466,1468,1469,1473,1479,1480,1481,1495,1529,1544,1613,1619,1638,1654,1672,1685,1706,1707,1751,1755,1757,1777,1778,1783,1788,1789,1791,1805,1806,1822,1826,1842,1880,1886,1891,1898,1903,1905,1908,1911,1918,1928,1936,1937,1948,1949,1959,1960,1961,1977,1978,1980,1981,1997,2005,2010,2011,2013,2021,2022,2029,2034,2040,2042,2046,2048,2059,2060,2062,2064,2093,2095,2104,2105,2111,2119,2120,2128,2145,2158,2166,2167,2182,2197,2201,2209,2216,2217,2218,2237,2238,2265,2266,2356,2370,2394,2395,2448,2456,2457,2468,2472,2473,2482,2494,2523,2538,2555,2558,2562,2566,2573,2580,2585,2594,2603,2608,2612,2614,2618,2621,2629,2647,2648,2649,2651,2652,2658,2661,2668,2671,2694,2697,2698,2711,2736,2762,2763,2764,2779,2780,2781,2783,2790,2801,2802,2810,2835,2859,2869,2873,2876,2878,2886,2887,2889,2890,2891,2893,2901,2903,2912,2917,2918,2919,2924,2925,2927,2934,2943,2951,2954,2955,2956,2957,2958,2963,2964,2967,2968,2972,2976,2978,2985,2994,2997,3014,3015,3039,3045,3054,3063,3071,3080,3097,3110,3111,3112,3119,3135,3145,3158,3178,3180,3181,3184,3202,3210,3211,3225,3226,3229,3230,3245,3262,3263,3272,3285,3286,3305,3309,3325,3328,3330,3341,3359,3379,3389,3400,3401,3407,3413,3415,3425,3426,3433,3437,3448,3450,3451,3457,3470,3471,3480,3486,3487,3489,3490,3498,3500,3504,3507,3508,3511,3512,3518,3522,3533,3535,3540,3552,3554,3555,3556,3558,3559,3574,3577,3578,3581,3587,3588,3590,3602,3609,3621,3630,3631,3638,3643,3644,3648,3649,3655,3667,3670,3675,3678,3679,3686,3693,3702,3705,3709,3710,3711,3712,3713,3732,3734,3751,3752,3755,3756,3761,3768,3769,3772,3773,3774,3780,3782,3785,3788,3804,3805,3806,3812,3834,3854,3855,3867,3881,3890,3891,3904,3905,3911,3913,3918,3931,3949,3950,3953,3957,3972,3980,3982,3986,3987,3988,3991,3999,4009,4013,4017,4019,4021,4024,4025,4027,4028,4032,4033,4035,4040,4055,4059,4063,4065,4067,4068,4074,4075,4076,4077,4079,4080,4085,4087,4088,4091,4093,4096,4097,4102,4107,4109,4110,4111,4112,4114,4116,4117,4118,4127,4133,4134,4149,4151,4152,4156,4159,4160,4162,4163,4167,4169,4173,4174,4185,4186,4187,4191,4192,4194,4195,4200,4201,4202,4203,4208,4210,4211,4213,4215,4217,4219,4220,4221,4222,4238,4241,4249,4250,4251,4252,4256,4264,4265,4279,4280,4281,4283,4287,4294,4296,4297,4300,4302,4305,4307,4308,4310,4316,4318,4319,4323,4326,4334,4338,4342,4343,4344,4345,4347,4351,4352,4357,4366,4367,4369,4371,4372,4377,4384,4385,4390,4394,4396,4417,4418,4420,4423,4424,4428,4433,4435,4436,4442,4443,4444,4446,4449,4455,4457,4459,4463,4466,4468,4474,4477,4483,4487,4489,4493,4496,4499,4501,4514,4516,4519,4525,4531,4532,4533,4538,4541,4542,4549,4550,4551,4554,4557,4558,4563,4570,4571,4572,4577,4579,4581,4583,4584,4589,4591,4593,4595,4598,4603,4606,4608,4610,4613,4614,4618,4619,4636,4637,4646,4647,4651,4664,4665,4667,4670,4681,4686,4699,4702,4704,4705,4725,4737,4744,4760,4762,4775,4777,4778,4786,4796,4798,4809,4819,4821,4833,4835,4837,4838,4857,4859,4867,4868,4873,4882,4890,4891,4896,4898,4900,4904,4906,4911,4916,4917,4919,4928,4930,4931,4945,4972,4974,4977,4979,4980,4991,4995,5010,5014,5016,5033,5045,5054,5055,5065,5068,5083,5086,5087,5094,5096,5100,5101,5113,5122,5123,5131,5155,5156,5183,5200,5208,5217,5222,5234,5236,5238,5242,5252,5256,5257,5265,5266,5272,5273,5282,5291,5292,5295,5310,5312,5318,5319,5320,5349,5351,5354,5359,5367,5374,5379,5387,5400,5401,5404,5406,5413,5416,5430,5440,5444,5454,5469,5498,5499,5520,5524,5525,5534,5567,5568,5598,5603,5605,5607,5608,5610,5611,5612,5613,5614,5615,5624,5625,5626,5627,5630,5635,5636,5640,5651,5653,5655,5656,5662,5663,5678,5687,5692,5696,5697,5711,5715,5718,5720,5723,5726,5728,5730,5734,5737,5747,5754,5755,5756,5771,5778,5791,5798,5800,5820,5833,5837,5843,5846,5847,5849,5852,5855,5857,5860,5866,5872,5874,5882,5889,5897,5909,5912,5924,5925,5927,5942,5943,5945,5949,5958,5961,5973,5986,6004,6006,6011,6016,6023,6024,6028,6029,6030,6031,6032,6040,6043,6048,6056,6070,6071,6072,6075,6077,6083,6100,6108,6115,6120,6123,6126,6144,6163,6202,6220,6245,6248,6263,6292,6314,6328,6338,6344,6346,6420,6421,6423,6438,6482,6483,6514,6516,6520,6525,6546,6552,6559,6561,6575,6579,6581,6582,6587,6602,6605,6607,6616,6626,6627,6633,6642,6653,6690,6709,6710,6712,6715,6719,6720,6734,6736,6738,6747,6794,6812,6819,6821,6833,6835,6838,6846,6848,6850,6869,6870,6878,6883,6910,6913,6934,6940,6951,6952,6960,6966,6968,6981,6983,6988,6993,7002,7003,7010,7018,7022,7031,7032,7045,7047,7061,7067,7073,7091,7109,7129,7225,7233,7234,7239,7318,7319,7320,7323,7332,7335,7343,7345,7351,7355,7381,7383,7384,7385,7391,7395,7396,7414,7439,7454,7459,7488,7498,7509,7510,7512,7525,7527,7541,7562,7564,7572,7580,7582,7584,7585,7596,7606,7615,7624,7631,7642,7647,7660,7661,7665,7712,7729,7770,7776,7777,7805,7806,7822,7825,7831,7842,7844,7847,7854,7859,7867,7890,7892,7894,7897,7904,7907,7908,7909,7924,7930,7964,7965,7982,7986,7988,7992,7997,7999,8004,8010,8012,8026,8029,8041,8047,8055,8060,8077,8084,8090,8091,8100,8103,8106,8118,8129,8142,8168,8191,8219,8229,8245,8252,8254,8256,8299,8304,8310,8311,8329,8339,8341,8343,8352,8369,8370,8374,8392,8402,8406,8410,8434,8449,8454,8458,8459,8461,8471,8477,8479,8491,8500,8517,8525,8533,8540,8541,8544,8548,8557,8570,8571,8579,8580,8602,8628,8649,8663,8669,8671,8698,8738,8739,8751,8753,8770,8815,8833,8866,8873,8874,8880,8881,8893,8899,8906,8916,8922,8923,8927,8942,8955,8970,8980,8982,8983,8986,9001,9004,9018,9050,9100,9103,9108,9121,9124,9125,9146,9147,9158,9168,9188,9224,9225,9229,9236,9237,9239,9242,9244,9250,9256,9271,9274,9283,9287,9288,9289,9296,9311,9319,9326,9357,9361,9364,9412,9420,9429,9432,9445,9447,9448,9460,9468,9471,9487,9500,9502,9503,9535,9537,9546,9547,9548,9553,9554,9556,9559,9576,9593,9596,9611,9618,9631,9633,9657,9663,9681,9682,9692,9695,9730,9731,9748,9754,9761,9763,9764,9782,9784,9786,9792,9803,9804,9817,9822,9827,9828,9831,9834,9835,9840,9843,9854,9856,9860,9863,9865,9869,9872,9874,9876,9882,9887,9899,9901,9907,9910,9915,9917,9922,9924,9927,9928,9940,9948,9951,9952,9959,9960,9965,9971,9976,9978,9983,9992,9998,10011,10012,10018,10029,10046,10050,10051,10070,10071,10088,10093,10095,10104,10112,10113,10122,10149,10166,10168,10174,10175,10176,10190,10191,10200,10201,10205,10211,10214,10220,10221,10227,10236,10243,10253,10261,10263,10277,10279,10285,10288,10289,10290,10301,10306,10308,10309,10310,10322,10323,10326,10329,10331,10333,10339,10346,10363,10366,10367,10373,10375,10388,10389,10393,10400,10402,10407,10409,10413,10419,10423,10427,10437,10441,10442,10469,10474,10475,10479,10480,10481,10502,10503,10506,10513,10519,10521,10527,10531,10546,10549,10553,10555,10577,10580,10585,10586,10587,10605,10607,10614,10622,10625,10636,10637,10644,10654,10661,10666,10669,10671,10682,10685,10691,10700,10708,10712,10717,10719,10723,10725,10726,10731,10739,10740,10747,10763,10767,10773,10776,10777,10782,10787,10788,10789,10792,10794,10795,10817,10818,10821,10823,10833,10835,10837,10839,10854,10862,10863,10869,10881,10888,10895,10897,10899,10906,10919,10924,10937,10944,10951,10956,10962,10963,10969,10970,10975,10978,10981,10985,10987,10989,10991,10993,10995,11003,11006,11010,11023,11026,11028,11032,11033,11036,11041,11045,11054,11107,11108,11126,11136,11138,11139,11141,11142,11147,11151,11168,11170,11198,11205,11211,11212,11218,11222,11224,11227,11229,11231,11239,11257,11267,11270,11302,11316,11328,11331,11333,11341,11342,11350,11360,11364,11389,11391,11392,11393,11412,11414,11421,11431,11434,11446,11447,11450,11453,11456,11457,11459,11461,11462,11463,11477,11485,11487,11488,11489,11534,11537,11545,11548,11558,11572,11576,11578,11579,11588,11590,11591,11606,11607,11608,11609,11610,11611,11612,11619,11620,11622,11623,11624,11625,11626,11628,11636,11639,11643,11644,11646,11655,11659,11660,11661,11672,11683,11725,11727,11741,11751,11764,11775,11777,11791,11793,11795,11801,11809,11812,11827,11829,11833,11837,11844,11846,11850,11856,11871,11873,11896,11899,11902,11905,11912,11916,11917,11945,11954,11965,11968,11993,12008,12016,12022,12031,12045,12059,12069,12070,12075,12076,12116,12158,12168,12169,12170,12172,12173,12193,12203,12204,12207,12221,12231,12238,12241,12242,12248,12258,12281,12294,12305,12319,12321,12328,12329,12333,12347,12351,12353,12357,12362,12366,12367,12374,12380,12382,12406,12413,12414,12420,12453,12465,12473,12478,12480,12518,12524,12541,12542,12545,12559,12568,12576,12579,12586,12595,12599,12604,12605,12615,12630,12632,12633,12638,12639,12643,12656,12662,12679,12684,12697,12720,12750,12762,12772,12773,12782,12803,12812,12830,12835,12841,12853,12872,12875,12876,12893,12944,12945,12971,12974,12982,13008,13011,13016,13029,13030,13036,13064,13077,13081,13099,13100,13118,13183,13238,13256,13267,13273,13277,13279,13281,13298,13306,13307,13308,13309,13311,13318,13319,13325,13343,13357,13363,13376,13379,13392,13400,13410,13417,13424,13426,13427,13428,13479,13492,13569,13583,13605,13732,13753,13773,13774,13836,13837,13877,13904,13918,13919,13925,13931,13963,13968,14008,14012,14013,14033,14036,14054,14055,14057,14072,14073,14111,14113,14124,14143,14145,14161,14171,14187,14189,14214,14287,14292,14294,14295,14298,14300,14309,14312,14314,14323,14328,14329,14336,14373,14374,14379,14385,14400,14429,14442,14451,14466,14493,14510,14529,14647,14648,14654,14687,14691,14699,14710,14714,14730,14738,14753,14756,14766,14770,14777,14789,14817,14825,14847,14907,14916,14926,14928,14945,14951,14970,14971,14972,14975,14991,15005,15010,15012,15026,15031,15060,15080,15150,15195,15215,15220,15221,15226,15228,15246,15248,15259,15261,15268,15293,15301,15317,15340,15352,15362,15371,15372,15373,15401,15416,15456,15511,15531,15533,15541,15549,15558,15559,15563,15578,15579,15580,15593,15616,15630,15646,15665,15666,15695,15719,15736,15739,15744,15755,15760,15763,15810,15842,15876,15896,15897,15901,15908,15909,15910,15911,15913,15915,15916,15922,15924,15928,15959,15972,15978,16006,16008,16012,16070,16077,16081,16104,16110,16121,16149,16150,16181,16200,16227,16228,16232,16244,16249,16295,16313,16330,16337,16340,16343,16380,16408,16447,16481,16489,16498,16506,16512,16520,16522,16534,16556,16561,16562,16572,16587,16592,16596,16598,16604,16611,16620,16626,16648,16650,16664,16710,16725,16732,16763,16786,16792,16809,16838,16856,16878,16883,16888,16924,16933,16940,16941,16942,16945,16980,17013,17026,17032,17066,17072,17073,17134,17138,17154,17183,17184,17193,17276,17282,17318,17361,17366,17370,17384,17464,17503,17512,17518,17538,17556,17567,17590,17633,17636,17643,17651,17658,17661,17688,17689,17696,17705,17720,17742,17747,17749,17750,17756,17776,17818,17861,17875,17883,17893,17985,17998,18004,18017,18031,18060,18061,18091,18095,18098,18154,18159,18188,18253,18273,18305,18324,18333,18371,18384,18405,18437,18450,18462,18486,18507,18549,18551,18565,18589,18649,18653,18656,18660,18663,18684,18685,18686,18697,18741,18770,18772,18781,18790,18815,18822,18824,18845,18860,18862,18868,18876,18877,18887,18902,18922,18923,18929,18931,18939,18951,18975,19025,19049,19081,19084,19110,19114,19117,19126,19134,19139,19165,19168,19170,19192,19196,19200,19201,19205,19220,19251,19252,19281,19286,19318,19339,19341,19355,19359,19383,19393,19398,19420,19434,19487,19493,19531,19546,19563,19565,19570,19575,19578,19589,19621,19623,19669,19670,19671,19672,19674,19686,19712,19723,19750,19755,19776,19778,19780,19794,19800,19805,19813,19819,19820,19821,19825,19833,19849,19851,19852,19858,19867,19868,19869,19874,19898,19912,19920,19969,19971,19981,19986,19992,20019,20058,20067,20095,20103,20106,20107,20137,20148,20152,20154,20156,20157,20159,20163,20172,20174,20179,20190,20193,20200,20209,20210,20214,20215,20228,20255,20267,20278,20284,20290,20298,20300,20311,20362,20372,20384,20386,20394,20405,20430,20437,20451,20469,20474,20480,20519,20539,20547,20561,20562,20569,20571,20572,20574,20581,20582,20606,20645,20658,20661,20665,20681,20685,20694,20698,20712,20714,20722,20726,20733,20742,20752,20753,20760,20768,20787,20788,20792,20795,20806,20829,20834,20864,20876,20884,20893,20911,20917,20944,20949,20953,20954,20956,20958,20990,21033,21044,21050,21070,21093,21094,21126,21133,21147,21157,21160,21185,21190,21195,21197,21211,21228,21234,21244,21263,21281,21283,21299,21300,21304,21305,21307,21340,21353,21355,21356,21358,21366,21371,21388,21403,21447,21454,21456,21473,21513,21563,21564,21581,21599,21620,21640,21653,21654,21659,21664,21678,21700,21705,21736,21742,21790,21871,21885,21887,21982,22017,22032,22069,22083,22096,22114,22137,22164,22210,22242,22249,22271,22274,22286,22302,22305,22306,22338,22364,22369,22410,22421,22454,22485,22486,22494,22505,22530,22555,22572,22697,22759,22774,22777,22845,22857,22965,22987,23033,23134,23161,23176,23222,23242,23268,23291,23328,23338,23343,23349,23359,23361,23373,23435,23470,23503,23524,23536,23537,23538,23592,23642,23681,23788,23949,23952,24139,24144,24193,24282,24484,24543,24544,24651,24667,24722,24725,24744,24750,24771,24968,25249,25636,26116,26260,26495,26762,27103,27647,29138,29146,29992,30146,30298,30553,30693,30857,30962,31184,31386,31476,31547,31641,31664,31765,31911,31996,32011,32074,32201,32259,32265,32304,32408,32467,32508,32537,32556,32557,32598,32600,32621,32669,32691,32734,32764,32783,32791,32802,32815,32816,32845,32860,32873,32875,32880,32889,32894,32914,32915,32918,32921,32930,33275,33300,33469,33519,33665,33844,34041,34164,34443,34545,34553,34616,34792,34869,35904,36618,36655,36921,37012,37176,37379,37616,37834,38125,38390,38543,38811,39171,39248,39365,39399,39651,39700,39910,40220,40289,40633,40907,40965,41193,41456,41544,41617,41739,42146,42216,42249,42430,42711,42719,42812,42814,42835,43411,43704,43946,43948,44699,45158,46138,47221,49422,49882,50055,50101,57387,57388,60767,60838,61225,61381,61775,61895,62457,64274,65000)
ORDER BY i.id DESC
LIMIT 0, 5
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | PRIMARY | <subquery2> | ALL | distinct_key | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 2527 | Using temporary; Uruchomiono metodę filesort |
1 | PRIMARY | i | eq_ref | PRIMARY,catid,idx_item | PRIMARY | 4 | tvc_0._col_1 | 1 | Using where |
1 | PRIMARY | c | eq_ref | PRIMARY,category,published,access,trash | PRIMARY | 4 | tvswieto_tvs03.i.catid | 1 | Using index condition; Using where |
2 | MATERIALIZED | <derived3> | ALL | NULL | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 2527 | |
3 | DERIVED | NULL | NULL | NULL | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | NULL | No tables used |
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
# | Wywołujący | Plik i numer linii |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/itemlist.php:668 |
12 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:278 |
11 | K2ViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
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:64 |
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 |