Време на заявката: 207.86 ms След последната заявка: 1.79 ms Памет за заявки: 0.072 MB Памет преди заявката: 3.658 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-05-30 02:36:34')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-05-30 02:36:34')
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,65,99,152,153,154,158,200,215,273,309,310,313,368,371,400,462,477,498,567,568,569,570,577,624,640,664,689,693,695,710,725,732,761,768,771,794,796,800,801,802,806,830,841,843,860,875,878,884,912,934,950,963,973,975,1003,1005,1025,1038,1172,1181,1211,1243,1263,1267,1322,1339,1348,1493,1503,1519,1521,1563,1565,1575,1592,1595,1605,1637,1645,1647,1665,1670,1677,1717,1735,1760,1784,1795,1899,1914,1937,1987,2052,2095,2115,2177,2249,2274,2282,2284,2326,2367,2368,2403,2407,2575,2585,2725,2732,2743,2744,2760,2778,2819,2971,3003,3010,3042,3196,3218,3223,3246,3256,3258,3400,3471,3554,3558,3564,3565,3688,3762,3767,3773,3830,5245,5522,6048,6121,6561,6666,6704,6741,6746,6749,6753,6755,6758,6764,6767,6775,6776,6778,6780,6781,6782,6783,6784,6788,6792,6795,6796,6800,6803,6807,6813,6814,6819,6821,6822,6823,6825,6828,6840,6841,6844,6846,6847,6849,6850,6853,6856,6858,6861,6862,6867,6868,6869,6873,6890,6903,6906,6908,6909,6912,6913,6914,6915,6926,6927,6929,6932,6933,6934,6936,6941,6944,6966,6981,6993,6998,6999,7000,7002,7031,7033,7040,7046,7049,7054,7055,7056,7059,7060,7061,7068,7075,7079,7083,7087,7091,7093,7096,7099,7100,7106,7108,7110,7113,7115,7118,7119,7127,7131,7132,7133,7146,7148,7150,7153,7154,7156,7158,7159,7165,7169,7170,7171,7172,7173,7174,7176,7178,7179,7182,7183,7184,7185,7190,7191,7208,7214,7217,7218,7221,7223,7225,7230,7233,7236,7238,7243,7244,7245,7250,7251,7252,7256,7257,7268,7286,7290,7302,7304,7312,7313,7314,7316,7317,7323,7328,7343,7344,7346,7367,7371,7373,7374,7381,7384,7389,7399,7400,7402,7409,7416,7422,7442,7455,7456,7469,7470,7480,7482,7487,7489,7501,7502,7519,7532,7533,7534,7537,7539,7541,7543,7546,7561,7568,7569,7577,7578,7580,7599,7616,7619,7621,7625,7640,7648,7650,7669,7690,7718,7721,7722,7731,7732,7741,7755,7757,7759,7765,7766,7772,7774,7779,7787,7806,7826,7843,7846,7847,7862,7869,7877,7880,7883,7891,7894,7895,7904,7908,7914,7925,7935,7937,7943,7953,7968,7978,7992,8007,8008,8017,8018,8036,8037,8041,8042,8056,8065,8067,8094,8120,8130,8138,8139,8140,8143,8147,8156,8166,8169,8198,8201,8214,8222,8225,8229,8233,8237,8239,8241,8243,8245,8246,8257,8262,8265,8272,8277,8287,8294,8295,8296,8297,8299,8300,8316,8325,8326,8338,8354,8356,8358,8368,8369,8376,8387,8397,8398,8404,8407,8409,8413,8417,8420,8442,8454,8457,8460,8465,8466,8467,8472,8477,8480,8483,8484,8486,8489,8490,8501,8504,8506,8509,8511,8516,8520,8522,8529,8530,8531,8532,8533,8535,8536,8546,8547,8550,8559,8565,8566,8567,8570,8574,8587,8591,8596,8598,8599,8611,8613,8634,8647,8648,8649,8664,8674,8694,8696,8701,8704,8705,8707,8708,8717,8720,8721,8726,8735,8736,8750,8760,8763,8764,8766,8770,8772,8773,8777,8782,8788,8790,8792,8809,8810,8816,8819,8820,8824,8827,8840,8841,8848,8852,8860,8867,8873,8878,8879,8883,8884,8891,8892,8898,8904,8914,8928,8934,8935,8936,8967,8976,8997,9009,9011,9024,9032,9049,9087,9093,9096,9100,9123,9129,9135,9137,9151,9166,9169,9176,9180,9182,9206,9211,9228,9230,9233,9237,9241,9244,9257,9263,9266,9268,9277,9285,9288,9293,9296,9300,9307,9309,9311,9313,9314,9316,9317,9318,9319,9320,9321,9327,9334,9336,9340,9341,9343,9347,9348,9352,9353,9359,9366,9371,9374,9378,9379,9387,9394,9396,9399,9406,9416,9418,9433,9436,9437,9442,9450,9452,9457,9462,9466,9469,9475,9479,9493,9499,9502,9503,9505,9507,9512,9514,9515,9517,9519,9525,9530,9531,9532,9533,9553,9554,9561,9572,9574,9580,9583,9585,9589,9598,9602,9604,9607,9608,9611,9612,9615,9622,9628,9635,9636,9641,9648,9650,9653,9655,9658,9663,9664,9665,9682,9684,9685,9691,9698,9699,9700,9703,9704,9706,9709,9710,9712,9715,9719,9721,9723,9724,9733,9738,9739,9741,9748,9749,9755,9757,9758,9760,9762,9764,9765,9778,9782,9796,9805,9808,9816,9819,9831,9832,9836,9837,9840,9849,9850,9852,9853,9854,9862,9867,9873,9893,9895,9901,9903,9909,9938,9940,9950,9958,9967,9968,9979,9981,9991,10014,10022,10037,10043,10045,10046,10053,10055,10071,10083,10085,10090,10107,10116,10121,10124,10139,10141,10147,10148,10151,10154,10159,10160,10170,10171,10179,10180,10189,10201,10222,10225,10230,10232,10257,10268,10281,10288,10295,10301,10310,10315,10333,10338,10343,10345,10361,10362,10369,10372,10373,10377,10383,10384,10385,10390,10391,10392,10399,10405,10408,10415,10419,10422,10423,10436,10437,10438,10445,10450,10453,10465,10466,10467,10475,10477,10479,10495,10501,10502,10521,10528,10530,10550,10559,10562,10564,10565,10570,10572,10582,10588,10590,10596,10597,10599,10602,10603,10604,10607,10612,10633,10635,10636,10654,10660,10670,10674,10690,10701,10712,10714,10717,10727,10728,10729,10736,10739,10747,10750,10771,10782,10784,10794,10796,10814,10819,10836,10838,10842,10844,10854,10864,10867,10868,10873,10881,10882,10890,10893,10894,10896,10897,10900,10905,10907,10908,10916,10917,10920,10923,10927,10928,10932,10934,10935,10941,10943,10945,10952,10956,10967,10968,10973,10982,10984,10986,10988,10993,11013,11027,11030,11037,11044,11056,11057,11066,11067,11073,11088,11095,11106,11109,11122,11124,11140,11141,11147,11154,11157,11162,11164,11173,11184,11186,11201,11205,11213,11215,11237,11245,11250,11257,11258,11259,11262,11267,11270,11277,11280,11303,11306,11308,11313,11317,11324,11330,11331,11333,11336,11345,11355,11362,11367,11372,11380,11381,11387,11395,11396,11400,11408,11416,11429,11439,11442,11450,11455,11472,11474,11478,11488,11491,11509,11513,11517,11524,11525,11549,11554,11566,11574,11583,11586,11599,11602,11603,11606,11610,11612,11613,11625,11626,11635,11646,11648,11651,11655,11657,11660,11665,11669,11670,11671,11672,11673,11674,11678,11686,11691,11692,11697,11698,11701,11702,11707,11708,11715,11716,11721,11722,11726,11733,11740,11741,11742,11745,11755,11757,11763,11780,11783,11786,11791,11795,11800,11805,11809,11812,11816,11818,11820,11821,11831,11834,11843,11847,11852,11854,11857,11858,11864,11877,11880,11892,11893,11897,11902,11904,11909,11935,11940,11943,11945,11950,11964,11974,11986,12015,12043,12049,12050,12067,12074,12076,12085,12088,12091,12092,12099,12102,12130,12140,12145,12146,12147,12152,12155,12162,12168,12169,12170,12184,12187,12191,12193,12198,12201,12203,12213,12219,12221,12231,12233,12235,12241,12243,12245,12248,12255,12258,12263,12264,12266,12267,12270,12272,12278,12282,12294,12299,12307,12309,12311,12317,12320,12326,12328,12331,12335,12336,12349,12351,12358,12363,12370,12371,12376,12377,12388,12392,12405,12410,12413,12419,12420,12428,12433,12437,12445,12450,12451,12456,12457,12459,12460,12462,12468,12471,12476,12477,12480,12483,12486,12491,12498,12499,12515,12516,12518,12519,12520,12521,12534,12542,12543,12545,12548,12550,12552,12554,12555,12558,12559,12560,12566,12567,12568,12574,12580,12587,12588,12596,12609,12621,12624,12626,12639,12674,12688,12691,12705,12716,12717,12721,12722,12726,12727,12731,12734,12737,12741,12753,12773,12786,12789,12797,12800,12804,12809,12815,12819,12820,12826,12828,12831,12832,12834,12835,12836,12837,12838,12839,12846,12849,12858,12859,12861,12871,12876,12880,12886,12890,12903,12905,12915,12918,12942,12961,12966,12979,12982,12994,12999,13014,13018,13023,13024,13030,13043,13055,13060,13074,13080,13086,13090,13094,13098,13102,13103,13105,13108,13113,13120,13145,13157,13174,13187,13191,13195,13206,13223,13229,13230,13246,13249,13253,13263,13265,13273,13276,13278,13282,13293,13298,13303,13310,13312,13329,13342,13347,13357,13359,13368,13370,13376,13377,13383,13391,13393,13397,13403,13408,13409,13412,13417,13419,13434,13436,13443,13451,13462,13463,13466,13476,13491,13493,13503,13504,13510,13513,13517,13519,13533,13538,13545,13553,13556,13559,13565,13570,13575,13601,13604,13637,13640,13655,13668,13672,13679,13728,13740,13755,13756,13758,13762,13773,13777,13782,13791,13793,13795,13798,13803,13816,13820,13824,13844,13860,13870,13887,13890,13905,13909,13911,13912,13915,13921,13925,13941,13947,13951,13959,13966,13967,13968,13971,14008,14015,14017,14032,14034,14038,14044,14048,14057,14061,14062,14064,14073,14080,14092,14094,14099,14111,14126,14137,14139,14148,14149,14158,14162,14164,14167,14184,14188,14198,14209,14212,14215,14228,14271,14277,14282,14291,14295,14308,14316,14323,14338,14343,14382,14384,14388,14396,14398,14401,14405,14409,14422,14424,14425,14428,14442,14451,14467,14478,14488,14499,14500,14503,14515,14527,14536,14541,14545,14546,14547,14565,14569,14584,14588,14590,14599,14616,14621,14639,14646,14659,14668,14682,14693,14695,14716,14743,14753,14756,14767,14771,14777,14786,14788,14793,14803,14808,14809,14812,14820,14825,14844,14847,14852,14860,14861,14862,14865,14875,14876,14904,14917,14918,14922,14928,14938,14940,14949,14956,14972,14986,15002,15005,15013,15014,15019,15024,15027,15034,15040,15041,15043,15044,15045,15046,15048,15051,15057,15062,15067,15068,15079,15081,15084,15086,15087,15094,15099,15102,15106,15108,15110,15120,15134,15166,15200,15202,15210,15214,15217,15233,15242,15243,15244,15265,15268,15270,15273,15274,15288,15295,15300,15311,15317,15327,15328,15370,15378,15398,15406,15414,15421,15423,15431,15433,15446,15450,15458,15462,15464,15476,15481,15487,15490,15504,15509,15531,15546,15573,15579,15587,15589,15607,15625,15659,15662,15684,15694,15695,15698,15715,15716,15732,15742,15746,15752,15753,15757,15758,15765,15767,15780,15781,15788,15792,15797,15798,15800,15804,15809,15811,15816,15819,15822,15824,15827,15831,15851,15853,15859,15869,15872,15876,15879,15887,15892,15902,15906,15908,15914,15915,15918,15926,15935,15939,15945,15949,15954,15963,15976,15979,15984,15986,15994,15996,16004,16005,16011,16012,16026,16055,16066,16074,16079,16097,16109,16113,16118,16130,16133,16140,16156,16168,16169,16171,16178,16180,16193,16203,16204,16211,16212,16214,16222,16224,16259,16276,16279,16294,16303,16315,16330,16348,16352,16353,16365,16376,16384,16386,16408,16417,16429,16433,16436,16439,16450,16458,16480,16487,16488,16495,16496,16512,16514,16516,16534,16547,16555,16556,16558,16559,16571,16573,16575,16576,16577,16582,16595,16613,16615,16624,16627,16629,16633,16634,16636,16642,16645,16648,16654,16665,16670,16671,16674,16679,16682,16684,16685,16688,16691,16694,16707,16711,16720,16723,16732,16734,16736,16746,16761,16763,16765,16780,16798,16812,16813,16815,16838,16839,16846,16849,16858,16870,16878,16903,16917,16936,16937,16949,16951,16954,16960,16970,16986,16998,17004,17006,17009,17053,17064,17081,17089,17090,17103,17121,17136,17137,17141,17144,17157,17180,17193,17194,17200,17203,17213,17224,17225,17226,17231,17236,17242,17251,17253,17274,17275,17293,17299,17314,17324,17342,17345,17362,17364,17376,17398,17399,17413,17414,17422,17442,17473,17481,17496,17501,17517,17538,17539,17541,17545,17554,17564,17584,17595,17604,17630,17633,17640,17650,17660,17674,17682,17697,17707,17711,17729,17734,17739,17748,17752,17753,17776,17784,17785,17801,17819,17823,17836,17845,17859,17860,17864,17876,17879,17881,17882,17894,17901,17910,17918,17925,17928,17943,17945,17949,17952,17957,17976,17979,17986,17990,17994,17995,18001,18014,18017,18040,18045,18053,18084,18101,18103,18108,18114,18117,18120,18122,18128,18135,18139,18151,18167,18179,18182,18187,18190,18199,18216,18223,18229,18244,18248,18253,18255,18282,18284,18286,18295,18297,18303,18316,18321,18322,18330,18339,18357,18358,18362,18366,18381,18386,18395,18398,18402,18405,18414,18418,18425,18430,18434,18440,18441,18445,18451,18460,18481,18482,18483,18490,18491,18495,18499,18507,18517,18522,18525,18527,18530,18534,18535,18538,18540,18549,18552,18553,18562,18565,18572,18574,18583,18588,18589,18591,18592,18597,18603,18606,18607,18609,18615,18624,18631,18645,18646,18647,18655,18658,18662,18666,18671,18676,18686,18687,18713,18717,18720,18728,18732,18747,18750,18763,18768,18781,18782,18789,18793,18797,18802,18805,18807,18811,18818,18820,18824,18838,18839,18841,18852,18855,18866,18872,18881,18884,18886,18897,18902,18906,18915,18920,18929,18933,18942,18947,18954,18960,18962,18963,18967,18970,18982,18994,18996,19005,19010,19014,19020,19029,19038,19040,19041,19052,19057,19063,19066,19068,19071,19077,19079,19081,19082,19086,19087,19088,19090,19093,19094,19096,19098,19099,19100,19101,19108,19109,19110,19111,19112,19113,19114,19116,19117,19118,19119,19122,19123,19126,19129,19130,19132,19133,19137,19139,19140,19143,19144,19145,19147,19148,19150,19151,19152,19154,19156,19157,19160,19161,19163,19169,19171,19172,19173,19178,19182,19189,19190,19195,19196,19204,19206,19207,19209,19210,19212,19213,19217,19222,19225,19226,19227,19229,19230,19233,19235,19236,19238,19239,19242,19243,19244,19248,19251,19253,19254,19255,19258,19259,19261,19262,19264,19266,19268,19269,19271,19274,19278,19279,19281,19283,19288,19294,19295,19297,19298,19313,19314,19316,19317,19318,19321,19323,19325,19326,19334,19339,19342,19343,19346,19347,19348,19356,19362,19363,19364,19367,19370,19375,19383,19384,19385,19388,19399,19401,19402,19404,19405,19407,19408,19410,19413,19416,19417,19418,19421,19423,19425,19427,19429,19430,19432,19434,19438,19440,19441,19442,19444,19446,19450,19451,19452,19459,19461,19465,19470,19472,19475,19476,19477,19478,19479,19480,19484,19487,19489,19491,19495,19501,19502,19507,19510,19515,19522,19524,19526,19528,19530,19532,19534,19538,19542,19543,19552,19554,19555,19558,19560,19562,19563,19567,19569,19571,19575,19579,19580,19581,19584,19586,19590,19595,19598,19600,19603,19605,19613,19615,19619,19620,19623,19624,19628,19629,19633,19635,19640,19644,19648,19658,19659,19662,19671,19679,19680,19684,19685,19687,19691,19693,19694,19700,19703,19706,19711,19718,19719,19724,19734,19736,19737,19738,19739,19740,19744,19749,19764,19766,19767,19769,19773,19783,19784,19785,19787,19790,19793,19797,19799,19800,19806,19809,19811,19812,19822,19826,19827,19831,19832,19833,19839,19846,19853,19854,19856,19857,19858,19870,19877,19880,19894,19898,19899,19901,19903,19908,19914,19915,19916,19918,19919,19920,19921,19925,19929,19931,19933,19935,19941,19947,19955,19957,19958,19971,19977,19988,19992,20000,20001,20010,20021,20029,20031,20042,20044,20046,20050,20053,20057,20061,20062,20064,20066,20068,20071,20072,20073,20075,20076,20077,20078,20079,20084,20086,20091,20111,20113,20115,20120,20122,20128,20137,20140,20147,20148,20151,20153,20156,20157,20160,20163,20166,20168,20173,20177,20179,20180,20182,20184,20191,20193,20197,20198,20199,20200,20207,20209,20214,20215,20217,20219,20220,20222,20223,20224,20225,20226,20227,20228,20231,20245,20246,20247,20252,20253,20256,20257,20259,20260,20261,20262,20267,20273,20282,20287,20289,20290,20296,20298,20299,20307,20308,20309,20310,20315,20317,20332,20338,20344,20346,20350,20353,20354,20357,20358,20366,20376,20378,20379,20380,20383,20386,20387,20389,20391,20392,20393,20396,20401,20405,20406,20409,20410,20412,20413,20414,20416,20417,20418,20419,20421,20424,20427,20434,20455,20458,20461,20462,20463,20467,20472,20474,20478,20479,20481,20483,20484,20485,20487,20488,20492,20493,20494,20496,20500,20501,20505,20506,20509,20511,20513,20521,20529,20539,20542,20544,20551,20558,20565,20566,20567,20573,20579,20585,20587,20590,20591,20595,20598,20601,20602,20605,20609,20611,20613,20618,20622,20623,20624,20648,20656,20657,20660,20667,20680,20684,20689,20696,20703,20704,20705,20710,20712,20714,20722,20729,20733,20734,20744,20762,20769,20777,20781,20783,20784,20786,20788,20789,20794,20796,20797,20799,20800,20802,20803,20806,20812,20813,20822,20829,20830,20834,20836,20840,20841,20845,20848,20849,20855,20864,20865,20866,20868,20871,20879,20880,20882,20884,20888,20899,20901,20902,20905,20909,20911,20923,20929,20930,20935,20939,20940,20942,20944,20954,20956,20964,20967,20972,20974,20976,20982,20988,20998,21001,21010,21014,21020,21035,21036,21037,21045,21052,21055,21056,21058,21059,21060,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 | 2713 | 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 | 2713 | |
| 3 | DERIVED | NULL | NULL | NULL | НЕ МОЖЕ ДА БЪДЕ ИЗПОЛЗВАН ИНДЕКС КЛЮЧ | NULL | NULL | NULL | No tables used |
| Status | Duration |
|---|
| Starting | 0.85 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.36 ms |
| Optimizing | 0.34 ms |
| Statistics | 0.12 ms |
| Preparing | 0.05 ms |
| Creating tmp table | 0.04 ms |
| Sorting result | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.27 ms |
| Removing tmp table | 0.01 ms |
| Sending data | 141.98 ms |
| Creating sort index | 11.25 ms |
| Removing tmp table | 52.15 ms |
| Creating sort index | 0.05 ms |
| End of update loop | 0.01 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.02 ms |
| Removing tmp table | 0.02 ms |
| Closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.08 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 |
