Време на заявката: 170.32 ms След последната заявка: 1.77 ms Памет за заявки: 0.072 MB Памет преди заявката: 3.614 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-04-01 03:37:28')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-04-01 03:37: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(52,64,85,86,89,93,97,101,114,146,162,163,169,205,229,242,270,272,289,292,308,322,328,361,371,446,470,488,519,526,528,529,530,545,558,561,571,578,684,773,855,989,1037,1047,1067,1085,1110,1123,1145,1154,1181,1182,1183,1193,1229,1242,1264,1270,1276,1284,1302,1312,1315,1322,1349,1393,1394,1426,1449,1464,1471,1473,1485,1495,1504,1518,1529,1541,1548,1557,1570,1595,1600,1603,1617,1636,1642,1655,1742,1752,1803,1875,1950,1996,2014,2017,2018,2032,2037,2046,2188,2214,2293,2309,2356,2358,2390,2443,2550,2635,2666,2727,2746,2753,2760,2767,2803,2839,2847,2907,2957,2959,2968,2972,2979,3050,3066,3121,3172,3177,3221,3223,3225,3231,3237,3264,3356,3358,3364,3365,3384,3389,3393,3408,3416,3425,3450,3490,3510,3517,3537,3554,3558,3567,3569,3635,3639,3651,3713,3745,3833,3940,5244,5736,6332,6347,6352,6418,6498,6535,6542,6561,6612,6664,6671,6708,6716,6721,6724,6726,6741,6742,6746,6753,6754,6757,6764,6776,6777,6781,6795,6801,6802,6807,6812,6815,6823,6831,6839,6841,6844,6845,6850,6852,6854,6855,6857,6858,6861,6869,6871,6883,6894,6902,6905,6909,6911,6914,6926,6927,6932,6939,6943,6944,6949,6956,6957,6980,6984,6985,6986,6995,6999,7000,7002,7013,7016,7026,7029,7030,7032,7037,7038,7039,7041,7044,7045,7049,7053,7054,7055,7060,7061,7064,7066,7068,7073,7074,7087,7092,7099,7106,7109,7110,7115,7117,7120,7121,7123,7127,7131,7133,7144,7146,7148,7152,7154,7156,7158,7160,7165,7167,7168,7169,7171,7173,7174,7182,7188,7193,7195,7200,7206,7210,7214,7220,7225,7229,7230,7232,7233,7243,7250,7253,7267,7281,7285,7287,7295,7299,7301,7328,7343,7344,7356,7373,7375,7389,7394,7398,7404,7407,7413,7420,7422,7424,7426,7427,7445,7464,7470,7471,7475,7476,7480,7482,7484,7487,7489,7501,7505,7506,7509,7510,7512,7519,7526,7530,7534,7539,7556,7568,7576,7580,7586,7594,7597,7599,7619,7620,7625,7637,7646,7661,7667,7683,7692,7697,7711,7716,7719,7732,7733,7741,7744,7745,7747,7751,7761,7765,7770,7774,7777,7780,7787,7793,7797,7798,7799,7801,7803,7809,7822,7824,7826,7828,7829,7836,7838,7861,7868,7869,7877,7895,7899,7902,7904,7908,7914,7916,7918,7919,7922,7925,7930,7934,7941,7942,7952,7961,7971,7985,7988,7994,7996,8002,8010,8019,8022,8025,8030,8032,8036,8039,8041,8042,8050,8053,8059,8063,8065,8071,8072,8076,8085,8099,8100,8107,8110,8111,8113,8120,8122,8137,8138,8139,8143,8144,8146,8147,8150,8156,8164,8171,8181,8182,8184,8190,8192,8194,8197,8204,8207,8208,8220,8221,8222,8227,8229,8233,8235,8237,8240,8248,8250,8261,8264,8272,8274,8277,8278,8287,8292,8295,8297,8301,8303,8309,8310,8314,8322,8328,8338,8346,8352,8354,8357,8364,8365,8368,8373,8398,8407,8420,8441,8447,8457,8458,8460,8477,8482,8483,8489,8492,8502,8504,8506,8513,8518,8527,8529,8531,8532,8546,8547,8559,8562,8563,8567,8569,8574,8582,8591,8600,8606,8609,8613,8620,8622,8633,8634,8647,8654,8656,8670,8674,8684,8686,8703,8717,8733,8739,8749,8750,8757,8760,8764,8766,8774,8778,8787,8789,8792,8793,8797,8819,8834,8841,8848,8853,8861,8871,8877,8879,8883,8884,8888,8892,8896,8900,8904,8910,8914,8917,8924,8928,8929,8936,8942,8943,8945,8959,8964,8986,8990,8997,9000,9016,9025,9028,9033,9038,9045,9057,9096,9109,9117,9119,9122,9126,9129,9133,9140,9145,9156,9157,9161,9165,9168,9172,9183,9202,9210,9215,9241,9242,9270,9274,9277,9280,9288,9298,9305,9314,9316,9317,9320,9336,9356,9372,9374,9396,9404,9405,9408,9424,9437,9476,9477,9483,9488,9508,9510,9519,9530,9531,9537,9542,9566,9583,9585,9614,9626,9632,9656,9661,9665,9669,9670,9673,9682,9686,9689,9691,9692,9698,9700,9713,9719,9728,9735,9739,9750,9751,9754,9755,9756,9757,9772,9775,9776,9782,9790,9792,9798,9810,9818,9836,9837,9839,9848,9889,9891,9902,9908,9911,9914,9935,9979,9980,9992,9997,10014,10046,10053,10085,10086,10097,10104,10107,10125,10128,10134,10139,10148,10154,10158,10171,10185,10191,10222,10226,10277,10279,10280,10288,10290,10298,10307,10311,10312,10320,10372,10384,10385,10392,10400,10414,10445,10463,10468,10485,10508,10509,10517,10519,10524,10527,10533,10557,10558,10565,10570,10579,10586,10597,10603,10612,10633,10640,10655,10656,10660,10693,10700,10706,10707,10724,10735,10736,10739,10746,10760,10762,10783,10812,10818,10822,10832,10838,10842,10853,10854,10857,10859,10877,10893,10898,10942,10954,10962,10982,10987,10988,10991,11002,11004,11006,11012,11014,11015,11021,11027,11029,11031,11049,11053,11062,11067,11072,11074,11076,11080,11101,11103,11127,11139,11180,11202,11206,11236,11237,11238,11242,11247,11248,11254,11259,11270,11274,11283,11303,11309,11332,11333,11337,11347,11356,11360,11381,11388,11391,11394,11395,11399,11400,11408,11410,11415,11430,11431,11444,11453,11506,11516,11522,11548,11552,11563,11575,11579,11584,11590,11593,11599,11608,11641,11643,11671,11707,11764,11766,11827,11843,11852,11854,11925,11930,11985,11990,12029,12050,12061,12062,12067,12068,12070,12085,12091,12092,12096,12097,12101,12102,12104,12107,12126,12162,12169,12170,12213,12220,12221,12228,12233,12255,12287,12288,12296,12316,12332,12340,12342,12349,12353,12355,12362,12365,12366,12367,12374,12393,12394,12412,12417,12418,12422,12436,12477,12478,12511,12516,12543,12545,12563,12596,12598,12599,12607,12620,12622,12625,12629,12630,12653,12669,12672,12674,12684,12689,12691,12692,12696,12709,12714,12765,12777,12779,12817,12849,12852,12863,12883,12896,12903,12905,12907,12949,12958,12970,12981,12986,12987,13018,13031,13040,13049,13056,13066,13077,13089,13102,13108,13109,13112,13117,13119,13122,13132,13137,13138,13141,13144,13150,13160,13176,13196,13198,13220,13230,13235,13242,13244,13260,13263,13275,13290,13293,13308,13309,13310,13329,13347,13376,13399,13406,13412,13415,13443,13444,13445,13453,13461,13463,13475,13503,13505,13517,13518,13531,13544,13547,13607,13611,13617,13623,13624,13647,13650,13672,13714,13757,13769,13775,13778,13781,13802,13805,13806,13809,13823,13829,13848,13869,13874,13905,13907,13910,13921,13925,13927,13939,13954,13955,13993,13995,14008,14017,14018,14019,14025,14027,14039,14042,14050,14057,14064,14071,14080,14113,14124,14141,14171,14182,14203,14213,14248,14253,14267,14304,14309,14322,14382,14385,14393,14418,14426,14429,14436,14450,14478,14479,14492,14500,14501,14504,14505,14510,14519,14520,14534,14539,14545,14547,14549,14581,14582,14589,14617,14628,14631,14643,14644,14649,14651,14667,14672,14674,14680,14683,14704,14712,14734,14738,14748,14761,14775,14794,14815,14822,14825,14840,14848,14853,14877,14894,14897,14910,14928,14933,14934,14937,14943,14946,14947,14958,14963,14992,15001,15010,15017,15025,15036,15044,15055,15063,15064,15069,15083,15085,15087,15093,15104,15110,15113,15116,15118,15123,15125,15127,15131,15141,15145,15147,15148,15154,15157,15174,15206,15210,15211,15221,15230,15236,15248,15258,15261,15263,15283,15285,15292,15303,15316,15318,15321,15327,15338,15354,15360,15383,15387,15391,15394,15396,15397,15404,15411,15412,15427,15431,15436,15444,15450,15474,15476,15479,15490,15492,15497,15506,15514,15524,15528,15549,15557,15561,15571,15573,15585,15597,15606,15607,15621,15625,15638,15641,15658,15661,15662,15669,15670,15680,15681,15682,15683,15712,15714,15722,15730,15739,15741,15744,15746,15768,15771,15775,15778,15781,15791,15797,15808,15815,15875,15886,15888,15893,15896,15904,15905,15923,15929,15932,15938,15986,15994,16000,16005,16007,16028,16031,16047,16055,16061,16065,16086,16114,16115,16117,16119,16127,16146,16147,16162,16163,16192,16201,16232,16256,16261,16268,16275,16282,16295,16309,16311,16313,16317,16318,16324,16346,16348,16354,16362,16365,16368,16369,16374,16379,16383,16386,16387,16391,16392,16414,16415,16417,16419,16420,16425,16428,16431,16439,16440,16448,16450,16451,16455,16461,16464,16470,16472,16489,16493,16497,16506,16512,16514,16531,16533,16537,16540,16543,16546,16553,16554,16557,16558,16570,16581,16584,16595,16598,16605,16610,16621,16628,16631,16666,16673,16679,16687,16694,16696,16708,16710,16712,16730,16745,16755,16756,16764,16765,16797,16829,16841,16848,16871,16911,16917,16936,16946,16949,16951,16952,16989,16994,17000,17009,17014,17016,17036,17052,17074,17077,17083,17084,17085,17086,17107,17114,17131,17139,17140,17144,17152,17165,17169,17171,17176,17179,17185,17186,17199,17204,17209,17210,17212,17216,17218,17232,17238,17242,17249,17250,17251,17254,17273,17279,17281,17282,17283,17285,17288,17295,17300,17302,17304,17306,17313,17314,17315,17318,17321,17322,17325,17328,17331,17334,17335,17337,17340,17341,17342,17343,17348,17349,17350,17352,17353,17356,17365,17369,17373,17374,17380,17384,17385,17386,17389,17392,17393,17394,17395,17397,17402,17405,17406,17407,17408,17409,17412,17417,17422,17423,17425,17426,17431,17433,17440,17441,17451,17453,17457,17458,17459,17461,17466,17467,17468,17469,17478,17487,17488,17489,17491,17503,17509,17526,17531,17537,17539,17547,17549,17550,17551,17552,17556,17561,17565,17572,17573,17574,17576,17577,17585,17586,17587,17596,17597,17598,17599,17603,17607,17608,17610,17613,17617,17618,17625,17634,17640,17643,17645,17646,17647,17652,17661,17662,17665,17666,17667,17668,17669,17670,17672,17673,17674,17675,17676,17682,17685,17689,17690,17693,17698,17703,17704,17705,17707,17713,17715,17717,17718,17719,17727,17731,17736,17737,17741,17747,17749,17750,17758,17767,17769,17770,17771,17775,17776,17777,17779,17780,17786,17787,17788,17789,17790,17798,17800,17803,17804,17807,17808,17809,17811,17812,17814,17815,17816,17819,17820,17821,17829,17833,17835,17839,17840,17841,17842,17843,17846,17848,17849,17851,17852,17853,17861,17865,17869,17871,17874,17875,17877,17883,17886,17893,17894,17895,17897,17899,17901,17903,17904,17908,17912,17913,17915,17916,17918,17919,17921,17924,17927,17928,17931,17933,17936,17942,17945,17946,17947,17949,17952,17953,17955,17959,17969,17972,17976,17977,17979,17980,17981,17983,17998,18003,18004,18009,18010,18011,18017,18019,18022,18025,18026,18027,18031,18032,18033,18036,18037,18040,18041,18043,18046,18048,18049,18050,18052,18057,18064,18065,18070,18072,18073,18074,18077,18082,18083,18085,18088,18090,18110,18112,18114,18115,18117,18121,18129,18131,18133,18146,18159,18162,18172,18175,18185,18188,18190,18191,18192,18193,18194,18205,18211,18213,18224,18227,18230,18237,18238,18248,18252,18257,18261,18263,18265,18270,18277,18278,18280,18290,18296,18299,18304,18305,18307,18311,18325,18338,18341,18343,18344,18346,18348,18363,18367,18371,18376,18390,18392,18393,18395,18400,18404,18411,18415,18416,18418,18420,18421,18422,18426,18427,18429,18431,18433,18437,18441,18447,18448,18450,18452,18454,18456,18469,18475,18477,18485,18489,18490,18492,18493,18497,18498,18501,18502,18503,18507,18509,18518,18519,18523,18524,18538,18542,18545,18547,18548,18550,18554,18556,18557,18558,18560,18563,18564,18572,18573,18574,18582,18594,18595,18598,18599,18602,18604,18605,18610,18611,18615,18616,18617,18620,18621,18622,18624,18628,18629,18630,18633,18636,18638,18639,18641,18642,18644,18647,18648,18649,18653,18654,18656,18657,18661,18664,18665,18667,18670,18676,18680,18682,18685,18694,18696,18699,18701,18702,18706,18708,18710,18715,18716,18718,18723,18726,18728,18729,18733,18739,18743,18752,18754,18756,18757,18758,18759,18763,18767,18768,18770,18772,18776,18777,18778,18780,18781,18787,18789,18791,18796,18798,18799,18801,18803,18804,18807,18808,18809,18810,18812,18819,18821,18822,18826,18833,18834,18837,18839,18840,18841,18843,18848,18850,18852,18859,18863,18864,18871,18873,18876,18877,18880,18883,18885,18887,18891,18899,18901,18903,18905,18909,18913,18918,18919,18921,18922,18923,18924,18925,18927,18928,18935,18943,18944,18946,18964,18965,18966,18968,18969,18983,18989,18991,18993,18998,19001,19002,19005,19009,19011,19013,19014,19015,19017,19022,19027,19028,19029,19030,19032,19033,19037,19040,19043,19047,19052,19053,19061,19063,19072,19077,19078,19081,19083,19085,19096,19099,19104,19117,19119,19123,19131,19132,19134,19136,19138,19140,19149,19152,19155,19160,19174,19177,19179,19181,19183,19192,19193,19207,19210,19211,19212,19215,19219,19222,19223,19224,19226,19228,19230,19233,19235,19239,19240,19242,19243,19245,19248,19251,19253,19257,19258,19259,19260,19261,19266,19267,19270,19272,19275,19276,19277,19278,19280,19282,19284,19286,19295,19303,19308,19310,19312,19313,19315,19316,19317,19318,19319,19325,19327,19329,19331,19334,19337,19345,19348,19350,19357,19361,19367,19368,19371,19376,19379,19384,19385,19386,19387,19388,19389,19390,19395,19396,19401,19402,19406,19411,19412,19417,19420,19421,19422,19436,19438,19442,19444,19445,19448,19449,19450,19456,19458,19462,19463,19464,19465,19466,19468,19471,19472,19473,19474,19475,19485,19486,19488,19491,19492,19495,19496,19500,19505,19508,19512,19514,19516,19518,19520,19523,19530,19533,19535,19537,19538,19540,19542,19543,19545,19546,19547,19551,19553,19557,19559,19562,19568,19569,19571,19573,19578,19580,19581,19583,19593,19612,19614,19615,19616,19617,19622,19628,19631,19633,19634,19635,19641,19642,19647,19649,19655,19656,19658,19659,19660,19666,19667,19668,19669,19672,19674,19677,19678,19679,19682,19683,19684,19686,19690,19691,19692,19695,19697,19703,19705,19707,19710,19714,19720,19730,19734,19736,19738,19741,19743,19744,19748,19749,19750,19754,19756,19759,19764,19769,19771,19775,19781,19782,19784,19786,19787,19791,19793,19795,19796,19797,19803,19806,19808,19809,19811,19817,19819,19820,19821,19823,19825,19826,19832,19833,19835,19836,19837,19838,19839,19840,19841,19842,19844,19850,19853,19854,19859,19862,19863,19871,19872,19876,19881,19884,19892,19894,19896,19905,19906,19911,19915,19919,19920,19922,19923,19924,19925,19930,19931,19934,19938,19940,19943,19949,19952,19955,19956,19957,19959,19986,19995,19997,19998,20002,20003,20004,20006,20009,20015,20025,20026,20031,20032,20039,20043,20048,20052,20054,20057,20058,20061,20062,20063,20064,20066,20070,20076,20077,20092,20093,20095,20097,20098,20102,20104,20109,20110,20123,20125,20138,20142,20143,20144,20148,20149,20150,20152,20154,20163,20164,20165,20171,20176,20183,20184,20187,20188,20189,20192,20194,20195,20196,20200,20201,20203,20205,20206,20216,20219,20223,20228,20229,20236,20238,20240,20243,20244,20250,20253,20254,20265,20268,20269,20270,20272,20278,20280,20283,20288,20302,20303,20310,20311,20312,20313,20315,20317,20318,20322,20326,20328,20334,20335,20338,20340,20346,20352,20353,20355,20356,20363,20365,20367,20371,20375,20377,20381,20388,20390,20393,20395,20402,20407,20409,20411,20422,20426,20428,20429,20432,20438,20444,20445,20446,20448,20449,20456,20457,20458,20459,20466,20468,20470,20473,20475,20485,20490,20494,20495,20496,20501,20502,20503,20504,20505,20508,20513,20514,20516,20527,20530,20532,20533,20535,20536,20537,20541,20542,20547,20548,20549,20553,20555,20560,20563,20568,20574,20580,20583,20586,20588,20589,20591,20593,20594,20613,20614,20617,20619,20622,20623,20624,20625,20629,20639,20650,20652,20657,20658,20661,20662,20663,20664,20665,20666,20669,20674,20676,20679,20680,20681,20682,20683,20685,20686,20692,20693,20694,20697,20700,20701,20702,20706,20707,20712,20713,20714,20715,20716,20717,20719,20720,20722,20724,20726,20727,20731,20732,20733,20739,20740,20745,20746,20751,20754,20756,20757,20759,20761,20765,20771,20773,20778,20779,20783,20790,20791,20792,20794,20798,20800,20807,20811,20813,20814,20815,20824,20827,20829,20831,20832,20834,20835,20838,20842,20844,20849,20857,20858,20860,20861,20862,20863,20866,20867,20874,20876,20878,20883,20888,20892,20893,20896,20897,20905,20910,20911,20912,20916,20924,20926,20931,20934,20937,20938,20941,20946,20959,20960,20970,20971,20975,20978,20981,20987,20997,20998,21001,21003,21004,21005,21007,21010,21014,21017,21020,21026,21032,21043,21046,21047,21048,21049,21050,21052,21060,21061,21063,21064,21066,21074,21075,21079,21082,21084,21094,21097,21100,21101,21104,21105,21110,21112,21115,21116,21117,21121,21124,21143,21152,21168,21236,21244,21269,21274,21296,21297,21317,21368,21388,21393,21398,21401,21402,21423)
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 | 2721 | 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 | 2721 | |
| 3 | DERIVED | NULL | NULL | NULL | НЕ МОЖЕ ДА БЪДЕ ИЗПОЛЗВАН ИНДЕКС КЛЮЧ | NULL | NULL | NULL | No tables used |
| Status | Duration |
|---|
| Starting | 0.81 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.35 ms |
| Optimizing | 0.33 ms |
| Statistics | 0.12 ms |
| Preparing | 0.04 ms |
| Creating tmp table | 0.03 ms |
| Sorting result | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.27 ms |
| Removing tmp table | 0.01 ms |
| Sending data | 119.02 ms |
| Creating sort index | 9.06 ms |
| Removing tmp table | 39.94 ms |
| Creating sort index | 0.03 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.01 ms |
| Removing tmp table | 0.01 ms |
| Closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.07 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.02 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 |
