Време на заявката: 196.60 ms След последната заявка: 1.28 ms Памет за заявки: 0.072 MB Памет преди заявката: 3.518 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-29 09:38:32')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-05-29 09:38:32')
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,152,153,154,158,215,273,309,310,313,368,400,462,477,577,624,640,664,689,693,695,710,725,732,761,768,771,794,796,801,802,806,841,843,860,875,884,912,934,950,963,973,975,1003,1005,1025,1038,1172,1181,1243,1263,1267,1322,1339,1348,1493,1519,1521,1592,1605,1637,1645,1647,1665,1670,1677,1735,1760,1784,1795,1914,1937,1987,2052,2095,2115,2177,2249,2274,2282,2284,2367,2368,2403,2575,2725,2732,2743,2744,2778,2819,2971,3003,3010,3042,3196,3218,3223,3256,3258,3400,3471,3565,3762,3767,3830,5522,6048,6121,6666,6741,6746,6749,6753,6755,6758,6764,6767,6775,6776,6778,6780,6781,6782,6783,6788,6795,6800,6807,6813,6814,6819,6821,6822,6823,6828,6840,6841,6844,6846,6849,6850,6853,6856,6858,6861,6862,6867,6868,6869,6873,6890,6906,6909,6913,6915,6929,6933,6934,6936,6941,6944,6966,6981,6993,6998,6999,7000,7033,7040,7046,7049,7054,7055,7056,7060,7061,7075,7079,7093,7096,7099,7100,7108,7110,7113,7118,7119,7127,7133,7146,7153,7154,7159,7170,7172,7179,7182,7183,7190,7191,7214,7218,7225,7233,7236,7244,7245,7251,7252,7268,7286,7290,7302,7316,7323,7328,7367,7371,7374,7381,7384,7402,7409,7455,7469,7480,7482,7519,7532,7543,7569,7578,7621,7625,7640,7648,7650,7669,7690,7718,7721,7722,7731,7741,7755,7765,7772,7774,7779,7806,7843,7846,7862,7880,7891,7908,7914,7925,7935,7953,7968,7978,7992,8017,8018,8037,8056,8065,8094,8139,8140,8156,8169,8198,8201,8225,8239,8241,8243,8245,8246,8257,8262,8277,8294,8295,8296,8297,8299,8300,8316,8325,8338,8356,8358,8369,8376,8387,8397,8398,8404,8407,8409,8420,8466,8472,8480,8483,8484,8489,8490,8504,8511,8520,8529,8530,8531,8533,8536,8546,8547,8550,8559,8565,8566,8567,8574,8596,8598,8613,8649,8664,8694,8696,8701,8704,8707,8708,8720,8721,8726,8735,8736,8763,8764,8766,8770,8777,8788,8810,8816,8840,8841,8867,8879,8891,8898,8904,8934,8967,9009,9024,9032,9049,9087,9093,9100,9123,9135,9137,9166,9176,9180,9206,9211,9228,9230,9241,9244,9257,9266,9268,9285,9288,9314,9336,9340,9343,9347,9348,9359,9371,9374,9378,9379,9387,9396,9399,9406,9416,9418,9433,9436,9437,9442,9457,9462,9466,9469,9479,9493,9499,9502,9503,9505,9512,9514,9515,9519,9525,9532,9553,9561,9572,9574,9580,9583,9585,9602,9604,9607,9608,9611,9612,9615,9622,9635,9636,9641,9650,9655,9658,9665,9682,9685,9706,9715,9723,9724,9733,9741,9748,9749,9755,9757,9762,9778,9782,9796,9805,9808,9819,9831,9832,9836,9840,9849,9850,9852,9853,9854,9862,9867,9873,9893,9895,9901,9903,9909,9940,9950,9958,9967,9968,9979,9981,9991,10014,10022,10037,10043,10045,10046,10055,10071,10085,10090,10107,10116,10121,10124,10139,10141,10147,10148,10154,10159,10160,10170,10179,10180,10189,10201,10225,10230,10232,10288,10295,10301,10315,10333,10338,10345,10361,10362,10369,10377,10383,10384,10385,10390,10391,10392,10399,10405,10408,10415,10419,10422,10423,10437,10438,10450,10453,10465,10466,10467,10475,10477,10479,10495,10501,10502,10521,10530,10559,10564,10565,10572,10582,10590,10596,10597,10599,10602,10603,10604,10607,10635,10636,10654,10660,10670,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,10881,10882,10890,10893,10894,10896,10897,10900,10905,10907,10908,10916,10917,10920,10928,10932,10935,10941,10943,10945,10952,10956,10967,10968,10973,10982,10984,10986,10988,11013,11027,11037,11044,11056,11066,11067,11073,11088,11095,11122,11141,11147,11154,11157,11162,11164,11173,11184,11186,11201,11205,11213,11215,11237,11245,11250,11259,11270,11277,11308,11313,11317,11330,11331,11336,11355,11362,11367,11372,11381,11387,11395,11396,11400,11408,11416,11429,11439,11442,11450,11455,11472,11474,11478,11488,11509,11513,11517,11524,11525,11549,11554,11566,11574,11583,11586,11610,11613,11625,11626,11635,11646,11648,11651,11655,11657,11660,11665,11669,11670,11672,11674,11678,11686,11691,11692,11697,11698,11701,11702,11707,11708,11715,11716,11721,11722,11733,11740,11741,11742,11755,11757,11763,11783,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,11909,11935,11940,11943,11945,11950,11964,11986,12015,12043,12049,12050,12067,12074,12076,12088,12091,12092,12099,12130,12140,12145,12146,12147,12152,12155,12162,12168,12169,12170,12184,12187,12191,12193,12198,12201,12213,12221,12241,12243,12245,12248,12255,12258,12263,12264,12266,12270,12272,12278,12282,12299,12307,12309,12311,12317,12320,12326,12328,12331,12335,12336,12349,12363,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,12498,12499,12515,12516,12518,12519,12520,12521,12534,12542,12543,12545,12548,12550,12552,12554,12555,12558,12559,12560,12566,12567,12568,12580,12587,12588,12596,12609,12621,12624,12626,12639,12674,12688,12691,12705,12716,12717,12721,12722,12726,12727,12731,12737,12741,12753,12773,12786,12789,12797,12800,12804,12809,12815,12819,12820,12826,12828,12831,12832,12834,12835,12836,12837,12846,12849,12858,12859,12861,12871,12886,12890,12915,12918,12942,12961,12966,12979,12982,12994,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,13206,13223,13229,13246,13249,13253,13273,13276,13282,13303,13310,13312,13357,13359,13368,13370,13376,13377,13383,13391,13393,13397,13403,13408,13409,13417,13419,13434,13436,13443,13451,13462,13463,13466,13476,13491,13493,13504,13510,13513,13519,13533,13538,13545,13559,13565,13570,13575,13601,13604,13637,13640,13655,13668,13672,13679,13728,13755,13756,13758,13762,13773,13777,13791,13795,13798,13816,13820,13824,13844,13870,13887,13890,13905,13909,13911,13912,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,14139,14148,14149,14158,14162,14167,14184,14188,14198,14209,14212,14215,14228,14271,14282,14291,14295,14308,14323,14338,14343,14384,14396,14398,14401,14405,14409,14422,14424,14425,14428,14442,14451,14467,14478,14488,14499,14500,14503,14515,14527,14545,14565,14569,14588,14599,14616,14646,14659,14668,14682,14693,14716,14743,14753,14756,14767,14771,14777,14786,14793,14803,14812,14820,14825,14844,14847,14852,14860,14861,14862,14865,14875,14876,14904,14917,14918,14922,14938,14940,14949,14956,14972,14986,15002,15013,15014,15019,15024,15027,15034,15040,15041,15043,15044,15045,15046,15048,15057,15062,15067,15068,15079,15081,15084,15086,15087,15094,15099,15102,15106,15120,15134,15166,15200,15202,15244,15265,15268,15270,15288,15295,15300,15311,15317,15328,15370,15398,15406,15414,15421,15423,15431,15433,15446,15450,15458,15462,15464,15481,15487,15490,15504,15509,15531,15587,15625,15698,15715,15716,15732,15742,15746,15757,15767,15780,15788,15797,15800,15804,15816,15827,15831,15859,15869,15872,15876,15887,15892,15908,15914,15918,15926,15935,15939,15949,15954,15963,15976,15979,15984,15994,16004,16012,16026,16055,16066,16074,16079,16097,16109,16130,16133,16156,16168,16169,16171,16178,16180,16193,16203,16204,16211,16212,16214,16224,16259,16276,16294,16303,16315,16330,16352,16365,16376,16384,16386,16408,16417,16429,16433,16436,16439,16450,16458,16487,16488,16495,16496,16512,16516,16555,16556,16558,16559,16571,16573,16575,16576,16577,16582,16595,16613,16615,16627,16629,16633,16634,16636,16642,16645,16648,16654,16665,16670,16671,16674,16679,16682,16684,16685,16688,16694,16707,16711,16723,16732,16734,16736,16746,16761,16763,16765,16780,16798,16813,16815,16838,16839,16846,16870,16878,16903,16917,16949,16954,16960,16970,16986,16998,17006,17053,17064,17081,17089,17090,17103,17121,17136,17137,17141,17144,17157,17180,17193,17194,17200,17224,17225,17226,17231,17236,17251,17274,17275,17293,17299,17324,17345,17362,17364,17376,17398,17413,17414,17422,17442,17473,17481,17496,17501,17517,17538,17541,17545,17564,17584,17595,17604,17630,17633,17640,17660,17674,17682,17697,17711,17729,17739,17748,17752,17753,17776,17784,17785,17819,17823,17836,17845,17859,17860,17864,17879,17881,17882,17894,17910,17918,17925,17928,17943,17945,17949,17952,17957,17979,17986,17990,17994,17995,18001,18014,18017,18040,18045,18053,18084,18101,18103,18108,18114,18117,18122,18135,18139,18151,18167,18179,18182,18187,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,18405,18414,18425,18434,18440,18445,18460,18481,18482,18483,18490,18495,18499,18507,18517,18525,18527,18530,18534,18535,18538,18540,18549,18552,18553,18562,18565,18574,18583,18588,18589,18591,18592,18597,18603,18606,18607,18609,18615,18631,18645,18646,18647,18655,18658,18662,18666,18671,18676,18713,18717,18720,18728,18732,18747,18750,18763,18768,18782,18793,18797,18802,18805,18807,18811,18818,18820,18838,18839,18852,18855,18866,18872,18881,18884,18886,18897,18902,18906,18920,18929,18933,18947,18954,18960,18962,18963,18970,18982,18994,19005,19010,19014,19020,19029,19038,19041,19052,19057,19063,19066,19071,19077,19079,19081,19082,19086,19087,19088,19090,19093,19094,19099,19100,19101,19108,19109,19112,19114,19116,19117,19118,19122,19126,19129,19130,19133,19137,19140,19143,19144,19145,19147,19148,19151,19152,19160,19161,19169,19171,19172,19178,19182,19189,19196,19204,19206,19209,19212,19217,19227,19229,19235,19244,19258,19259,19261,19262,19271,19278,19279,19281,19283,19288,19294,19295,19297,19298,19313,19317,19318,19321,19323,19325,19326,19339,19342,19343,19347,19362,19363,19364,19375,19383,19384,19385,19388,19399,19404,19407,19410,19416,19421,19423,19425,19430,19432,19438,19440,19441,19444,19452,19460,19461,19465,19470,19475,19476,19478,19479,19484,19487,19495,19501,19502,19507,19515,19522,19524,19530,19532,19534,19538,19542,19543,19554,19555,19560,19562,19563,19567,19571,19575,19586,19590,19595,19605,19613,19619,19620,19623,19624,19629,19633,19640,19644,19658,19662,19671,19679,19680,19685,19693,19700,19706,19711,19719,19724,19734,19737,19739,19740,19749,19764,19766,19767,19773,19783,19785,19793,19799,19800,19806,19811,19812,19826,19827,19831,19832,19839,19853,19854,19856,19870,19877,19880,19899,19901,19903,19914,19915,19916,19918,19919,19920,19921,19929,19933,19941,19947,19955,19958,19971,19977,20000,20001,20021,20029,20031,20042,20046,20053,20068,20071,20072,20077,20078,20079,20091,20111,20113,20120,20122,20128,20137,20140,20147,20151,20153,20156,20157,20160,20163,20168,20173,20177,20179,20180,20191,20193,20197,20198,20207,20209,20214,20215,20217,20222,20224,20225,20226,20227,20231,20245,20246,20247,20252,20256,20257,20259,20261,20262,20273,20282,20287,20289,20290,20298,20299,20308,20309,20315,20317,20332,20344,20346,20350,20354,20357,20358,20366,20376,20378,20379,20380,20386,20387,20391,20392,20396,20401,20405,20406,20409,20410,20412,20413,20414,20417,20418,20419,20421,20424,20427,20434,20455,20458,20461,20467,20472,20474,20478,20479,20481,20483,20484,20485,20488,20492,20493,20494,20500,20505,20506,20511,20513,20521,20529,20539,20544,20551,20558,20565,20566,20567,20573,20579,20585,20591,20595,20602,20611,20613,20618,20623,20624,20648,20656,20657,20667,20680,20684,20689,20696,20703,20705,20710,20712,20722,20729,20733,20734,20744,20762,20769,20777,20781,20783,20784,20786,20788,20789,20794,20796,20799,20802,20803,20806,20812,20822,20829,20840,20841,20848,20849,20855,20864,20865,20866,20868,20871,20879,20880,20882,20884,20901,20905,20909,20911,20923,20929,20930,20935,20939,20940,20942,20944,20954,20956,20964,20967,20972,20974,20976,20982,20988,21001,21010,21014,21020,21035,21036,21037,21045,21052,21056,21058,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 | 2028 | 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 | 2028 | |
| 3 | DERIVED | NULL | NULL | NULL | НЕ МОЖЕ ДА БЪДЕ ИЗПОЛЗВАН ИНДЕКС КЛЮЧ | NULL | NULL | NULL | No tables used |
| Status | Duration |
|---|
| Starting | 0.66 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.27 ms |
| Optimizing | 0.28 ms |
| Statistics | 0.23 ms |
| Preparing | 0.05 ms |
| Creating tmp table | 0.04 ms |
| Sorting result | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.21 ms |
| Removing tmp table | 0.01 ms |
| Sending data | 139.37 ms |
| Creating sort index | 10.01 ms |
| Removing tmp table | 45.03 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.02 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.06 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 |
