Време на заявката: 202.46 ms След последната заявка: 3.06 ms Памет за заявки: 0.072 MB Памет преди заявката: 3.612 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 <= '2023-06-08 15:12:19')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-06-08 15:12:19')
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,308,309,310,313,368,371,398,400,462,477,577,624,626,640,664,689,693,695,710,725,732,738,761,768,771,796,801,802,806,841,843,872,875,884,911,912,934,950,963,973,975,1003,1005,1025,1038,1168,1172,1181,1243,1244,1263,1267,1273,1322,1339,1348,1356,1367,1521,1535,1536,1557,1605,1629,1637,1640,1645,1647,1665,1670,1671,1677,1735,1755,1760,1795,1891,1966,2052,2095,2096,2115,2119,2274,2282,2284,2328,2367,2368,2403,2550,2553,2575,2600,2603,2627,2631,2677,2732,2743,2744,2853,2898,2971,3008,3009,3010,3042,3090,3162,3196,3218,3223,3246,3248,3258,3269,3300,3471,3495,3516,3533,3534,3537,3547,3548,3565,3762,3767,5522,5583,6048,6121,6507,6542,6666,6741,6749,6753,6755,6758,6764,6767,6776,6778,6780,6781,6782,6786,6788,6795,6800,6806,6807,6813,6814,6819,6821,6822,6823,6828,6829,6833,6840,6841,6844,6846,6849,6850,6853,6856,6857,6858,6861,6862,6867,6868,6869,6890,6897,6906,6909,6910,6913,6915,6916,6929,6933,6934,6936,6941,6944,6948,6951,6966,6981,6989,6998,7000,7033,7039,7040,7041,7044,7046,7049,7052,7055,7056,7060,7061,7064,7066,7068,7079,7092,7094,7096,7099,7100,7106,7108,7109,7110,7113,7119,7127,7133,7146,7150,7153,7154,7159,7170,7172,7173,7179,7182,7183,7190,7191,7223,7225,7233,7234,7236,7244,7245,7247,7251,7252,7262,7263,7268,7272,7275,7280,7282,7284,7286,7287,7290,7298,7299,7302,7316,7320,7323,7328,7347,7358,7367,7371,7374,7384,7402,7409,7455,7460,7466,7469,7472,7480,7482,7506,7519,7532,7556,7602,7625,7628,7630,7640,7648,7659,7669,7673,7716,7719,7722,7731,7765,7772,7773,7774,7776,7777,7779,7794,7806,7813,7820,7843,7846,7862,7869,7891,7908,7914,7925,7935,7952,7961,7968,7970,7971,7978,7979,7992,7993,7994,7996,8003,8015,8017,8018,8026,8035,8037,8056,8059,8064,8065,8072,8094,8139,8140,8156,8175,8184,8194,8198,8201,8209,8213,8225,8243,8245,8246,8257,8262,8277,8296,8297,8299,8300,8316,8325,8334,8338,8346,8358,8362,8369,8387,8397,8398,8399,8404,8407,8409,8420,8442,8444,8472,8480,8483,8484,8485,8486,8489,8490,8504,8505,8511,8519,8520,8529,8530,8531,8533,8546,8547,8550,8559,8565,8566,8567,8573,8579,8596,8598,8613,8619,8620,8624,8649,8694,8696,8704,8707,8708,8720,8723,8726,8735,8736,8740,8761,8763,8764,8766,8770,8777,8780,8808,8810,8816,8831,8835,8840,8841,8852,8857,8862,8867,8871,8879,8887,8891,8898,8926,8934,8963,8967,8970,9000,9009,9018,9032,9033,9079,9087,9093,9097,9100,9123,9135,9137,9166,9176,9178,9180,9183,9185,9198,9204,9206,9211,9219,9224,9228,9230,9234,9241,9243,9244,9254,9256,9257,9266,9268,9285,9288,9290,9314,9327,9332,9336,9340,9343,9347,9348,9359,9371,9374,9378,9379,9387,9396,9406,9409,9416,9418,9433,9437,9442,9449,9457,9459,9462,9464,9466,9468,9469,9479,9487,9493,9499,9500,9503,9513,9514,9515,9519,9525,9532,9553,9561,9572,9580,9582,9585,9588,9593,9599,9603,9605,9607,9608,9610,9611,9612,9615,9622,9626,9628,9635,9636,9637,9638,9640,9641,9642,9650,9655,9656,9658,9665,9667,9682,9685,9687,9689,9692,9705,9706,9713,9715,9718,9723,9724,9728,9733,9741,9748,9749,9755,9757,9762,9778,9782,9793,9796,9803,9805,9808,9819,9829,9831,9832,9836,9840,9845,9849,9850,9852,9862,9867,9893,9895,9897,9901,9903,9909,9925,9940,9950,9958,9967,9968,9969,9977,9978,9979,9981,9991,9992,9993,9997,10003,10014,10022,10034,10037,10043,10046,10055,10056,10060,10061,10067,10071,10075,10085,10090,10095,10103,10114,10116,10118,10124,10139,10141,10146,10147,10148,10154,10159,10160,10167,10170,10172,10180,10188,10189,10191,10201,10205,10213,10225,10230,10234,10260,10298,10315,10325,10326,10332,10333,10343,10345,10361,10362,10377,10382,10383,10394,10399,10405,10408,10410,10415,10419,10420,10422,10423,10438,10440,10443,10450,10458,10461,10465,10466,10467,10475,10477,10482,10495,10501,10502,10521,10524,10554,10559,10564,10565,10568,10572,10582,10590,10596,10597,10599,10602,10603,10607,10613,10615,10622,10635,10636,10654,10660,10670,10672,10674,10681,10690,10701,10711,10712,10713,10714,10717,10718,10725,10727,10728,10729,10736,10739,10747,10771,10782,10784,10794,10796,10802,10804,10805,10814,10819,10831,10842,10844,10854,10864,10867,10868,10873,10880,10881,10888,10889,10890,10893,10894,10896,10897,10900,10905,10907,10908,10911,10916,10917,10920,10928,10932,10934,10935,10941,10943,10944,10945,10952,10956,10967,10973,10978,10984,10987,10988,10992,10995,10999,11000,11003,11006,11012,11016,11027,11037,11044,11052,11056,11066,11067,11072,11073,11095,11122,11124,11141,11147,11153,11154,11157,11162,11173,11181,11184,11186,11193,11201,11205,11213,11215,11228,11233,11237,11243,11244,11245,11250,11259,11270,11288,11308,11313,11317,11330,11331,11336,11355,11362,11367,11372,11381,11387,11395,11396,11400,11408,11419,11429,11432,11442,11450,11455,11472,11474,11478,11485,11488,11498,11509,11513,11519,11524,11525,11526,11527,11531,11535,11549,11554,11561,11566,11574,11581,11583,11586,11610,11613,11618,11625,11626,11646,11648,11651,11655,11657,11660,11665,11669,11670,11672,11674,11678,11686,11691,11697,11698,11700,11701,11702,11707,11708,11715,11716,11721,11722,11733,11740,11742,11757,11763,11770,11791,11795,11800,11805,11809,11812,11816,11818,11820,11821,11834,11843,11844,11847,11852,11854,11858,11864,11866,11877,11880,11884,11892,11902,11909,11911,11924,11935,11940,11943,11945,11950,11964,11986,11990,11999,12015,12043,12046,12049,12050,12067,12076,12088,12091,12092,12101,12110,12120,12125,12130,12140,12145,12146,12147,12152,12155,12162,12168,12169,12170,12177,12184,12187,12191,12193,12198,12207,12213,12221,12222,12231,12237,12243,12245,12255,12258,12262,12263,12264,12266,12270,12272,12276,12278,12282,12283,12299,12307,12309,12311,12317,12320,12326,12328,12331,12335,12336,12348,12349,12362,12363,12365,12370,12371,12376,12377,12388,12392,12405,12410,12413,12419,12420,12428,12433,12437,12441,12445,12450,12451,12456,12457,12459,12460,12462,12468,12469,12476,12477,12480,12483,12486,12499,12507,12511,12515,12516,12518,12519,12520,12521,12525,12527,12534,12542,12543,12545,12548,12550,12552,12554,12555,12558,12559,12560,12566,12567,12568,12580,12587,12588,12596,12609,12619,12621,12624,12626,12639,12658,12671,12674,12688,12691,12698,12699,12705,12711,12716,12717,12721,12722,12727,12729,12731,12737,12741,12745,12753,12763,12773,12775,12778,12789,12793,12797,12799,12800,12804,12806,12809,12813,12815,12819,12826,12828,12831,12832,12834,12835,12836,12837,12846,12849,12858,12859,12861,12865,12871,12876,12879,12886,12890,12912,12915,12918,12926,12942,12945,12955,12961,12966,12979,12994,12997,13005,13012,13014,13018,13020,13021,13023,13024,13030,13041,13054,13055,13060,13067,13074,13080,13086,13090,13093,13094,13102,13103,13105,13108,13113,13120,13129,13133,13145,13147,13155,13157,13159,13164,13174,13187,13191,13205,13206,13223,13229,13246,13249,13250,13253,13273,13276,13282,13286,13298,13303,13310,13312,13337,13345,13354,13357,13359,13362,13363,13370,13376,13377,13380,13383,13391,13393,13397,13403,13408,13409,13417,13419,13434,13443,13448,13451,13455,13463,13465,13466,13491,13493,13524,13530,13538,13545,13570,13609,13637,13655,13672,13680,13692,13709,13740,13755,13756,13758,13760,13762,13771,13777,13778,13795,13816,13820,13823,13824,13844,13868,13870,13886,13887,13890,13905,13909,13911,13912,13921,13922,13923,13925,13927,13939,13941,13943,13947,13954,13959,13963,13966,13967,13968,13971,13993,14008,14011,14015,14017,14032,14034,14044,14048,14057,14064,14073,14080,14087,14092,14094,14099,14109,14111,14126,14148,14158,14162,14167,14174,14178,14184,14188,14195,14198,14202,14204,14209,14215,14223,14240,14249,14257,14271,14276,14291,14308,14309,14322,14323,14327,14338,14343,14390,14392,14396,14398,14401,14409,14422,14442,14451,14456,14467,14468,14478,14485,14488,14499,14500,14503,14509,14515,14527,14545,14546,14556,14565,14569,14575,14588,14599,14620,14633,14646,14652,14654,14655,14659,14668,14673,14682,14690,14693,14704,14716,14732,14734,14738,14743,14753,14756,14767,14771,14777,14779,14786,14793,14794,14803,14805,14812,14815,14816,14820,14825,14844,14846,14847,14848,14852,14860,14861,14862,14865,14874,14875,14904,14909,14913,14915,14917,14918,14922,14923,14938,14940,14941,14948,14949,14956,14960,14962,14963,14972,14976,14986,15000,15002,15013,15014,15019,15024,15027,15030,15034,15040,15041,15043,15045,15046,15048,15057,15062,15066,15067,15079,15081,15087,15093,15094,15099,15102,15134,15160,15162,15165,15166,15175,15179,15197,15202,15205,15208,15232,15244,15265,15270,15272,15281,15288,15295,15296,15300,15311,15317,15319,15328,15344,15359,15369,15370,15388,15398,15406,15414,15421,15423,15433,15434,15450,15457,15458,15464,15478,15481,15490,15502,15504,15509,15531,15545,15554,15567,15574,15625,15626,15698,15716,15726,15732,15740,15741,15742,15757,15767,15780,15788,15797,15800,15809,15816,15827,15831,15834,15844,15859,15869,15872,15876,15887,15892,15894,15908,15911,15914,15918,15926,15931,15935,15939,15963,15977,15983,15984,15988,15989,15992,15994,15995,16004,16008,16012,16026,16027,16037,16055,16074,16079,16084,16090,16097,16108,16113,16115,16117,16118,16119,16120,16127,16130,16131,16132,16133,16138,16140,16142,16145,16156,16162,16171,16178,16179,16189,16193,16195,16203,16204,16206,16211,16212,16214,16226,16231,16259,16261,16262,16276,16293,16294,16298,16303,16315,16330,16346,16348,16352,16353,16354,16361,16365,16372,16374,16376,16384,16386,16389,16398,16400,16408,16417,16424,16426,16429,16433,16436,16439,16450,16487,16488,16489,16494,16495,16496,16508,16512,16553,16555,16556,16558,16559,16571,16573,16575,16576,16582,16592,16595,16597,16601,16611,16612,16613,16615,16616,16620,16622,16627,16629,16633,16634,16636,16642,16645,16648,16654,16670,16671,16674,16688,16703,16707,16711,16732,16734,16736,16746,16761,16763,16765,16780,16789,16798,16813,16815,16828,16838,16839,16841,16846,16857,16870,16878,16903,16904,16908,16917,16929,16949,16954,16960,16970,16985,16986,16987,16994,16998,17006,17007,17008,17010,17015,17022,17053,17064,17076,17081,17090,17103,17121,17136,17137,17141,17144,17157,17161,17165,17180,17193,17194,17200,17216,17219,17224,17225,17226,17231,17236,17246,17251,17274,17275,17293,17295,17299,17324,17334,17341,17345,17362,17364,17370,17376,17398,17399,17410,17413,17414,17422,17442,17446,17473,17481,17490,17496,17501,17517,17518,17527,17538,17541,17545,17564,17584,17595,17604,17630,17633,17640,17659,17660,17674,17682,17697,17711,17729,17739,17742,17748,17752,17753,17776,17784,17785,17819,17823,17832,17836,17842,17845,17854,17855,17859,17860,17864,17879,17881,17882,17885,17887,17889,17894,17910,17918,17924,17925,17928,17933,17943,17945,17949,17952,17957,17968,17973,17978,17979,17990,17993,17995,18000,18001,18010,18014,18040,18043,18045,18053,18066,18073,18082,18084,18096,18101,18103,18108,18117,18121,18122,18126,18135,18139,18141,18151,18161,18167,18179,18182,18187,18199,18216,18223,18225,18229,18235,18244,18248,18253,18255,18260,18261,18276,18284,18286,18295,18297,18303,18310,18316,18321,18322,18326,18330,18336,18339,18357,18358,18362,18366,18381,18386,18395,18398,18405,18414,18425,18434,18440,18445,18460,18481,18482,18483,18490,18495,18499,18507,18509,18517,18525,18527,18534,18535,18538,18540,18549,18552,18553,18561,18562,18565,18574,18583,18588,18589,18591,18592,18597,18603,18606,18608,18609,18615,18617,18626,18631,18642,18645,18646,18647,18653,18655,18658,18662,18666,18671,18676,18680,18710,18713,18714,18717,18720,18728,18732,18741,18747,18750,18753,18756,18759,18763,18768,18777,18782,18792,18793,18797,18802,18805,18807,18811,18818,18820,18822,18835,18839,18840,18841,18852,18855,18858,18866,18872,18876,18878,18881,18884,18886,18897,18902,18906,18911,18916,18920,18929,18931,18933,18938,18939,18943,18944,18947,18948,18954,18955,18960,18961,18962,18969,18970,18980,18982,19005,19010,19018,19019,19020,19029,19038,19040,19041,19045,19051,19053,19055,19057,19063,19066,19068,19069,19070,19071,19072,19080,19081,19082,19086,19089,19090,19092,19093,19094,19096,19097,19098,19099,19101,19109,19110,19113,19118,19121,19123,19124,19129,19130,19133,19140,19143,19144,19146,19147,19148,19151,19160,19166,19169,19171,19172,19182,19188,19189,19194,19196,19212,19213,19216,19217,19225,19229,19231,19235,19236,19244,19258,19259,19262,19269,19278,19279,19281,19288,19289,19292,19293,19294,19295,19296,19307,19313,19314,19317,19318,19321,19323,19326,19339,19342,19343,19347,19362,19364,19375,19383,19384,19388,19399,19404,19407,19410,19416,19421,19423,19425,19430,19434,19440,19441,19451,19452,19460,19461,19465,19476,19478,19479,19484,19495,19501,19502,19503,19507,19517,19522,19524,19534,19538,19542,19548,19555,19560,19561,19570,19571,19575,19579,19580,19586,19590,19595,19605,19613,19619,19628,19629,19662,19671,19680,19685,19688,19693,19699,19700,19706,19719,19724,19725,19737,19749,19764,19766,19767,19769,19773,19783,19784,19788,19793,19800,19806,19811,19812,19826,19827,19831,19832,19839,19846,19853,19854,19856,19870,19880,19894,19899,19901,19903,19914,19915,19916,19918,19919,19921,19929,19932,19933,19947,19971,19989,19990,20000,20001,20008,20021,20029,20031,20042,20053,20068,20072,20077,20078,20079,20091,20111,20113,20120,20122,20127,20137,20140,20147,20151,20153,20156,20157,20168,20173,20179,20180,20190,20191,20193,20198,20199,20200,20207,20213,20214,20220,20222,20223,20227,20245,20246,20256,20257,20262,20273,20275,20282,20283,20289,20290,20291,20298,20299,20321,20329,20332,20337,20338,20344,20346,20354,20357,20358,20366,20376,20378,20383,20386,20391,20392,20396,20401,20404,20405,20406,20413,20414,20417,20418,20421,20424,20427,20434,20452,20455,20461,20464,20467,20472,20474,20478,20479,20481,20483,20484,20485,20487,20488,20492,20493,20494,20500,20506,20511,20513,20521,20529,20539,20542,20544,20546,20552,20565,20566,20567,20575,20579,20585,20591,20595,20597,20602,20611,20613,20618,20623,20624,20635,20636,20648,20656,20657,20667,20672,20675,20686,20687,20689,20693,20694,20708,20709,20712,20714,20722,20724,20725,20726,20729,20733,20734,20735,20744,20761,20762,20764,20769,20777,20781,20784,20786,20788,20789,20794,20795,20796,20802,20803,20806,20811,20812,20818,20821,20822,20829,20836,20840,20841,20847,20848,20849,20855,20861,20864,20865,20868,20871,20876,20879,20880,20882,20884,20901,20905,20911,20913,20918,20923,20929,20930,20931,20935,20939,20940,20942,20944,20954,20956,20964,20966,20967,20972,20974,20976,20982,20988,21001,21003,21010,21014,21020,21032,21035,21036,21037,21045,21054,21056,21058,21060,21068,21071,21077,21085,21091,21098,21102,21105,21106,21107,21115,21118,21151)
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 | 2491 | 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 | 2491 | |
| 3 | DERIVED | NULL | NULL | NULL | НЕ МОЖЕ ДА БЪДЕ ИЗПОЛЗВАН ИНДЕКС КЛЮЧ | NULL | NULL | NULL | No tables used |
| Status | Duration |
|---|
| Starting | 0.78 ms |
| Checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| Table lock | 0.01 ms |
| Init | 0.32 ms |
| Optimizing | 0.32 ms |
| Statistics | 0.33 ms |
| Preparing | 0.05 ms |
| Creating tmp table | 0.04 ms |
| Sorting result | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.25 ms |
| Removing tmp table | 0.01 ms |
| Sending data | 143.20 ms |
| Creating sort index | 9.92 ms |
| Removing tmp table | 46.81 ms |
| Creating sort index | 0.04 ms |
| End of update loop | 0.02 ms |
| Removing tmp table | 0.02 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.07 ms |
| Updating status | 0.02 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 |
