Време на заявката: 233.05 ms След последната заявка: 1.83 ms Памет за заявки: 0.072 MB Памет преди заявката: 4.168 MB Върнати редове: 3
SELECT i.*, c.alias AS categoryalias
FROM dui0l_k2_items AS i
LEFT JOIN dui0l_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 <= '2022-05-28 14:08:28')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2022-05-28 14:08:28')
AND i.access IN(1,1)
AND c.access IN(1,1)
AND c.published = 1
AND c.trash = 0
AND i.id IN(51,64,152,153,154,158,215,309,310,313,368,400,418,462,477,577,624,640,664,689,693,695,710,725,732,761,768,771,796,801,802,806,841,843,875,884,912,934,950,963,973,975,1003,1005,1025,1038,1105,1172,1181,1243,1263,1267,1322,1339,1348,1421,1470,1521,1605,1613,1632,1637,1645,1647,1665,1670,1677,1735,1760,1779,1795,2035,2052,2095,2115,2204,2274,2282,2284,2367,2368,2403,2575,2732,2743,2744,2855,2882,2971,3010,3042,3196,3205,3218,3223,3246,3258,3370,3422,3445,3471,3565,3762,3767,5522,6048,6121,6666,6741,6749,6753,6755,6758,6759,6764,6767,6776,6778,6780,6781,6782,6784,6788,6790,6795,6800,6807,6813,6814,6819,6821,6822,6823,6828,6840,6841,6844,6846,6849,6850,6853,6856,6858,6861,6862,6865,6867,6868,6869,6871,6890,6906,6909,6913,6915,6929,6933,6934,6936,6941,6944,6948,6966,6969,6970,6981,6998,7000,7033,7040,7046,7049,7055,7056,7060,7061,7079,7096,7099,7100,7108,7110,7113,7119,7127,7133,7136,7146,7153,7154,7159,7170,7172,7179,7182,7183,7190,7191,7225,7233,7236,7244,7245,7251,7252,7253,7266,7268,7286,7290,7302,7316,7323,7328,7339,7344,7367,7371,7374,7384,7385,7402,7409,7412,7414,7445,7446,7452,7455,7464,7469,7470,7479,7480,7482,7488,7505,7519,7527,7532,7552,7566,7567,7625,7640,7648,7651,7669,7701,7714,7722,7731,7751,7765,7772,7774,7779,7780,7806,7843,7846,7862,7891,7908,7914,7924,7925,7929,7935,7968,7978,7984,7992,8017,8018,8037,8056,8064,8065,8087,8094,8102,8131,8139,8140,8156,8162,8198,8201,8225,8243,8245,8246,8257,8262,8270,8277,8296,8297,8299,8300,8316,8322,8325,8338,8358,8369,8387,8397,8398,8404,8407,8409,8414,8420,8441,8472,8480,8483,8484,8489,8490,8504,8511,8520,8529,8530,8531,8533,8537,8546,8547,8550,8559,8565,8566,8567,8579,8596,8598,8613,8615,8649,8694,8696,8704,8707,8708,8720,8726,8735,8736,8763,8764,8766,8770,8772,8773,8777,8810,8816,8840,8841,8867,8879,8891,8898,8934,8959,8962,8967,9009,9032,9076,9087,9092,9093,9100,9123,9129,9135,9137,9166,9176,9178,9180,9181,9191,9206,9211,9228,9230,9241,9244,9257,9265,9266,9268,9285,9288,9297,9302,9314,9336,9340,9343,9347,9348,9359,9368,9371,9374,9378,9379,9387,9396,9406,9416,9418,9433,9437,9442,9457,9462,9466,9469,9477,9479,9493,9499,9503,9514,9515,9519,9525,9532,9553,9561,9570,9572,9577,9580,9585,9607,9608,9611,9612,9615,9622,9635,9636,9641,9649,9650,9655,9658,9665,9677,9681,9682,9685,9701,9706,9715,9723,9724,9731,9733,9741,9748,9749,9755,9757,9762,9766,9778,9782,9796,9805,9808,9817,9818,9819,9831,9832,9836,9840,9849,9850,9852,9862,9867,9876,9879,9893,9895,9901,9903,9909,9937,9939,9940,9950,9958,9967,9968,9979,9981,9991,10014,10019,10022,10026,10037,10039,10043,10046,10055,10071,10073,10085,10090,10101,10116,10124,10139,10141,10147,10148,10154,10159,10160,10170,10180,10189,10201,10213,10225,10230,10237,10315,10333,10339,10342,10345,10361,10362,10366,10377,10383,10398,10399,10405,10408,10415,10419,10422,10423,10438,10450,10465,10466,10467,10471,10472,10474,10475,10477,10495,10501,10502,10521,10540,10559,10564,10565,10572,10577,10582,10590,10596,10597,10599,10602,10603,10607,10625,10628,10635,10636,10654,10660,10670,10671,10674,10690,10701,10712,10714,10717,10727,10728,10729,10736,10747,10771,10782,10784,10794,10796,10814,10819,10842,10844,10854,10864,10867,10868,10873,10878,10881,10890,10893,10894,10896,10897,10900,10905,10907,10908,10916,10917,10920,10925,10928,10932,10935,10940,10941,10943,10945,10952,10956,10967,10973,10984,10988,11008,11010,11027,11033,11037,11044,11056,11066,11067,11073,11092,11095,11101,11110,11122,11124,11141,11147,11154,11157,11162,11173,11184,11186,11201,11205,11213,11215,11237,11245,11250,11259,11267,11270,11308,11313,11317,11330,11331,11336,11355,11362,11367,11372,11381,11385,11387,11395,11396,11400,11408,11429,11442,11450,11455,11472,11474,11478,11488,11509,11513,11524,11525,11549,11554,11559,11566,11574,11583,11586,11610,11613,11625,11626,11646,11648,11651,11655,11657,11660,11661,11665,11669,11670,11672,11674,11678,11686,11691,11697,11698,11701,11702,11707,11708,11715,11716,11721,11722,11733,11740,11742,11745,11757,11763,11791,11795,11800,11805,11809,11812,11816,11818,11820,11821,11834,11843,11847,11852,11854,11858,11864,11877,11880,11892,11902,11909,11924,11935,11940,11943,11945,11950,11964,11986,12015,12043,12049,12050,12067,12076,12079,12088,12091,12092,12101,12130,12140,12145,12146,12147,12152,12155,12162,12168,12169,12170,12184,12187,12191,12193,12198,12213,12221,12243,12245,12255,12258,12263,12264,12266,12270,12272,12278,12282,12288,12299,12307,12309,12311,12317,12320,12326,12328,12331,12335,12336,12349,12363,12366,12370,12371,12376,12377,12388,12392,12405,12410,12413,12419,12420,12428,12433,12437,12445,12450,12451,12456,12457,12459,12460,12462,12468,12476,12477,12480,12483,12486,12499,12515,12516,12518,12519,12520,12521,12534,12542,12543,12545,12548,12550,12552,12554,12555,12558,12559,12560,12561,12566,12567,12568,12580,12587,12588,12596,12609,12611,12621,12624,12626,12639,12674,12688,12691,12692,12705,12716,12717,12721,12722,12727,12731,12737,12741,12744,12753,12773,12789,12797,12800,12804,12809,12815,12819,12826,12828,12831,12832,12834,12835,12836,12837,12846,12849,12858,12859,12861,12871,12883,12886,12890,12915,12918,12942,12961,12966,12979,12994,13014,13018,13019,13023,13024,13030,13031,13055,13056,13057,13058,13060,13074,13080,13083,13084,13086,13090,13094,13100,13102,13103,13105,13107,13108,13113,13120,13121,13145,13152,13155,13157,13170,13174,13187,13191,13206,13223,13229,13237,13241,13246,13249,13253,13273,13276,13282,13303,13306,13310,13312,13357,13359,13370,13376,13377,13383,13391,13393,13397,13403,13408,13409,13417,13419,13434,13443,13451,13463,13466,13491,13493,13499,13538,13545,13570,13637,13655,13672,13755,13756,13758,13762,13777,13795,13816,13820,13824,13844,13848,13870,13887,13890,13905,13909,13911,13912,13921,13925,13941,13947,13959,13964,13966,13967,13968,13971,14008,14015,14017,14032,14034,14044,14048,14057,14064,14073,14079,14080,14092,14094,14099,14105,14111,14126,14136,14148,14158,14160,14162,14164,14167,14184,14188,14198,14209,14215,14271,14291,14308,14323,14324,14338,14343,14392,14396,14398,14401,14409,14422,14442,14451,14455,14458,14467,14478,14488,14499,14500,14503,14515,14527,14545,14565,14569,14578,14588,14589,14599,14617,14646,14659,14668,14682,14689,14693,14716,14743,14753,14756,14767,14771,14777,14786,14793,14803,14812,14820,14825,14844,14847,14852,14860,14861,14862,14865,14875,14904,14917,14918,14922,14938,14940,14949,14956,14972,14986,15002,15013,15014,15019,15024,15025,15027,15034,15040,15041,15043,15045,15046,15048,15057,15062,15063,15065,15067,15079,15081,15087,15094,15099,15101,15102,15134,15166,15179,15180,15202,15244,15262,15265,15270,15288,15295,15300,15311,15317,15328,15366,15369,15370,15398,15406,15411,15414,15421,15423,15433,15450,15458,15464,15481,15490,15498,15504,15509,15531,15594,15625,15698,15703,15716,15732,15742,15747,15757,15765,15767,15780,15788,15797,15800,15805,15816,15827,15831,15859,15869,15872,15876,15887,15892,15908,15914,15918,15926,15935,15939,15963,15984,15994,16004,16012,16026,16035,16055,16056,16074,16079,16097,16109,16130,16133,16145,16156,16164,16171,16178,16179,16193,16203,16204,16211,16212,16214,16259,16276,16294,16303,16315,16330,16352,16365,16376,16384,16386,16408,16417,16429,16433,16436,16439,16450,16485,16487,16488,16495,16496,16512,16555,16556,16558,16559,16571,16573,16575,16576,16582,16595,16613,16615,16619,16627,16629,16633,16634,16636,16642,16645,16648,16654,16670,16671,16688,16707,16711,16725,16732,16734,16736,16746,16761,16763,16765,16780,16796,16798,16813,16815,16823,16838,16839,16846,16870,16871,16878,16903,16917,16949,16952,16954,16960,16970,16986,16998,17000,17006,17014,17016,17053,17062,17064,17077,17081,17083,17085,17086,17090,17098,17101,17102,17103,17116,17121,17131,17136,17137,17141,17144,17157,17169,17171,17176,17179,17180,17185,17192,17193,17194,17199,17200,17204,17209,17210,17216,17224,17225,17226,17231,17232,17236,17238,17250,17251,17273,17274,17275,17279,17281,17282,17283,17285,17293,17299,17302,17314,17315,17318,17321,17322,17324,17325,17328,17335,17337,17342,17345,17348,17349,17350,17352,17362,17364,17369,17376,17384,17386,17392,17393,17394,17398,17402,17405,17406,17407,17408,17409,17412,17413,17414,17417,17422,17425,17426,17433,17441,17442,17456,17459,17461,17468,17469,17473,17477,17481,17488,17489,17491,17492,17496,17501,17503,17509,17517,17531,17537,17538,17541,17545,17547,17549,17550,17551,17552,17556,17561,17564,17565,17572,17573,17574,17576,17577,17584,17585,17586,17595,17598,17599,17602,17603,17604,17607,17608,17610,17625,17630,17633,17640,17643,17645,17646,17647,17652,17660,17661,17662,17665,17666,17668,17669,17670,17672,17673,17674,17675,17676,17682,17685,17689,17690,17693,17697,17698,17703,17706,17711,17713,17715,17717,17718,17719,17727,17729,17736,17737,17739,17741,17747,17748,17749,17752,17753,17758,17765,17769,17770,17771,17775,17776,17777,17779,17780,17785,17786,17787,17788,17789,17790,17798,17800,17803,17804,17807,17808,17809,17811,17812,17814,17816,17819,17820,17821,17823,17829,17833,17835,17836,17839,17840,17843,17845,17846,17849,17851,17859,17860,17861,17864,17865,17869,17874,17875,17879,17881,17882,17894,17895,17897,17899,17904,17908,17910,17912,17913,17915,17916,17918,17919,17921,17925,17927,17928,17931,17936,17943,17945,17946,17949,17952,17955,17957,17972,17976,17977,17979,17980,17981,17983,17990,17995,17997,18001,18003,18004,18009,18010,18014,18022,18023,18032,18036,18037,18040,18045,18048,18050,18052,18053,18065,18070,18072,18077,18084,18085,18088,18090,18101,18103,18108,18110,18112,18115,18117,18121,18122,18129,18130,18131,18135,18139,18150,18151,18159,18167,18172,18179,18182,18185,18187,18188,18190,18191,18192,18193,18194,18199,18213,18216,18223,18227,18229,18237,18238,18244,18248,18253,18255,18257,18261,18263,18271,18277,18278,18284,18286,18290,18295,18297,18303,18311,18316,18321,18322,18325,18330,18339,18341,18344,18348,18357,18358,18362,18366,18371,18381,18386,18395,18398,18400,18404,18405,18414,18425,18429,18431,18434,18440,18445,18447,18450,18460,18469,18476,18477,18481,18482,18483,18485,18490,18493,18495,18497,18498,18499,18507,18517,18518,18519,18523,18525,18527,18534,18535,18538,18540,18542,18545,18547,18548,18549,18550,18552,18553,18556,18562,18565,18573,18574,18582,18583,18585,18588,18589,18591,18592,18594,18595,18597,18598,18599,18603,18604,18606,18609,18611,18615,18616,18620,18630,18631,18638,18641,18645,18646,18647,18648,18655,18658,18662,18666,18670,18671,18676,18682,18685,18699,18701,18706,18708,18713,18717,18720,18728,18729,18732,18733,18743,18745,18747,18750,18752,18757,18763,18767,18768,18770,18772,18776,18782,18787,18789,18791,18793,18796,18797,18798,18802,18805,18807,18808,18809,18810,18811,18812,18818,18820,18821,18834,18839,18843,18848,18852,18853,18855,18864,18866,18872,18877,18881,18884,18885,18886,18887,18891,18897,18901,18902,18903,18905,18906,18919,18920,18921,18922,18924,18925,18929,18933,18935,18946,18947,18954,18960,18962,18965,18966,18970,18982,18983,18991,18993,19002,19005,19010,19013,19017,19020,19022,19027,19028,19029,19037,19038,19041,19047,19057,19061,19063,19066,19078,19082,19083,19086,19090,19093,19094,19101,19107,19109,19118,19130,19133,19134,19136,19140,19143,19144,19147,19148,19149,19151,19155,19156,19169,19171,19172,19179,19181,19182,19189,19196,19211,19212,19215,19217,19228,19229,19231,19235,19244,19245,19258,19259,19262,19275,19278,19279,19281,19284,19288,19294,19295,19301,19313,19315,19318,19319,19321,19323,19326,19337,19339,19342,19343,19347,19355,19357,19361,19362,19364,19367,19368,19375,19377,19383,19384,19387,19388,19389,19399,19404,19406,19407,19410,19412,19413,19416,19421,19422,19423,19425,19430,19440,19441,19442,19445,19448,19450,19452,19460,19461,19465,19466,19471,19476,19478,19479,19484,19488,19491,19495,19496,19501,19502,19507,19508,19512,19514,19522,19524,19533,19534,19537,19538,19542,19552,19555,19557,19559,19560,19571,19575,19580,19583,19586,19590,19595,19605,19613,19619,19622,19629,19634,19642,19649,19656,19660,19662,19671,19672,19674,19680,19685,19691,19692,19693,19695,19700,19706,19710,19714,19719,19723,19724,19737,19741,19749,19754,19759,19764,19766,19767,19771,19773,19775,19782,19783,19786,19791,19793,19800,19806,19808,19811,19812,19817,19823,19826,19827,19830,19831,19832,19839,19853,19854,19856,19859,19870,19876,19880,19896,19899,19901,19903,19908,19914,19915,19916,19918,19919,19921,19922,19929,19933,19934,19940,19943,19947,19954,19959,19971,19982,19995,20000,20001,20004,20006,20021,20025,20026,20029,20031,20042,20048,20053,20058,20068,20070,20072,20076,20077,20078,20079,20084,20090,20091,20097,20098,20099,20104,20111,20113,20120,20122,20132,20137,20140,20147,20149,20150,20151,20153,20156,20157,20165,20166,20168,20173,20179,20180,20189,20191,20193,20194,20195,20198,20207,20210,20214,20216,20222,20227,20245,20246,20250,20256,20257,20262,20273,20278,20282,20289,20290,20298,20299,20303,20322,20328,20332,20334,20340,20344,20346,20354,20355,20357,20358,20362,20366,20376,20378,20381,20386,20391,20392,20393,20396,20401,20405,20406,20411,20414,20417,20418,20420,20421,20424,20427,20434,20446,20448,20455,20461,20467,20472,20474,20478,20479,20481,20483,20484,20485,20488,20492,20493,20494,20500,20504,20505,20506,20511,20513,20521,20529,20535,20536,20539,20544,20555,20563,20565,20566,20567,20578,20579,20585,20588,20591,20595,20596,20602,20611,20613,20616,20617,20618,20624,20625,20629,20630,20648,20652,20656,20657,20666,20667,20674,20679,20682,20689,20701,20706,20710,20712,20717,20719,20722,20729,20731,20733,20734,20739,20744,20745,20751,20762,20769,20774,20777,20779,20781,20784,20786,20788,20789,20794,20796,20798,20802,20803,20806,20808,20812,20813,20822,20824,20829,20831,20834,20838,20840,20841,20844,20848,20849,20855,20860,20864,20865,20867,20868,20871,20878,20879,20880,20882,20884,20893,20896,20901,20904,20905,20911,20923,20924,20926,20929,20930,20935,20937,20939,20940,20942,20944,20946,20954,20956,20964,20967,20972,20974,20975,20976,20982,20988,20997,21001,21003,21007,21010,21014,21020,21026,21035,21036,21037,21039,21043,21045,21050,21056,21058,21060,21066,21071,21075,21077,21082,21085,21091,21097,21098,21100,21101,21102,21105,21106,21107,21110,21111,21112,21115,21116,21118,21151,21356,21393,21418)
ORDER BY i.id DESC
LIMIT 0, 3
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | PRIMARY | <subquery2> | ALL | distinct_key | НЕ МОЖЕ ДА БЪДЕ ИЗПОЛЗВАН ИНДЕКС КЛЮЧ | NULL | NULL | 2444 | Using temporary; Използване на файлове сортиране |
1 | PRIMARY | i | eq_ref | PRIMARY,item,catid | PRIMARY | 4 | tvc_0._col_1 | 1 | Using where |
1 | PRIMARY | c | eq_ref | PRIMARY,category,published,access,trash | PRIMARY | 4 | big5_archdb.i.catid | 1 | Using where |
2 | MATERIALIZED | <derived3> | ALL | NULL | НЕ МОЖЕ ДА БЪДЕ ИЗПОЛЗВАН ИНДЕКС КЛЮЧ | NULL | NULL | 2444 | |
3 | DERIVED | NULL | NULL | NULL | НЕ МОЖЕ ДА БЪДЕ ИЗПОЛЗВАН ИНДЕКС КЛЮЧ | NULL | NULL | NULL | No tables used |
Status | Duration |
---|
Starting | 1.39 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.58 ms |
Optimizing | 0.74 ms |
Statistics | 0.36 ms |
Preparing | 0.07 ms |
Creating tmp table | 0.06 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.50 ms |
Removing tmp table | 0.01 ms |
Sending data | 162.29 ms |
Creating sort index | 16.01 ms |
Removing tmp table | 50.59 ms |
Creating sort index | 0.03 ms |
End of update loop | 0.02 ms |
Removing tmp table | 0.01 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Removing tmp table | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.12 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/itemlist.php:686 |
12 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:290 |
11 | K2ViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:19 |
9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:78 |
8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |