Време на заявката: 204.19 ms След последната заявка: 1.06 ms Памет за заявки: 0.072 MB Памет преди заявката: 4.080 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-20 07:55:50')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2022-05-20 07:55:50')
AND i.access IN(1,1)
AND c.access IN(1,1)
AND c.published = 1
AND c.trash = 0
AND i.id IN(93,97,172,215,494,664,682,801,868,912,1153,1170,1172,1181,1183,1214,1267,1298,1394,1647,1901,1966,2260,2396,2403,2550,2553,2882,2894,2944,2959,2968,2992,3001,3007,3008,3009,3040,3192,3204,3258,3351,3418,3471,3476,3517,3645,5736,6418,6612,6664,6666,6728,6739,6740,6741,6746,6753,6758,6764,6767,6773,6776,6777,6780,6781,6788,6792,6795,6802,6803,6807,6819,6821,6824,6828,6831,6840,6841,6844,6849,6850,6855,6856,6857,6858,6859,6861,6862,6867,6868,6869,6883,6892,6905,6906,6914,6915,6923,6926,6927,6929,6934,6939,6944,6949,6955,6966,6987,6988,6991,6995,7000,7002,7006,7016,7026,7029,7031,7032,7033,7037,7038,7039,7040,7043,7046,7054,7055,7059,7060,7061,7074,7079,7084,7091,7096,7099,7100,7106,7109,7110,7119,7120,7127,7131,7133,7136,7141,7145,7154,7156,7165,7170,7174,7182,7208,7210,7233,7234,7242,7245,7250,7252,7257,7259,7280,7290,7302,7317,7328,7336,7349,7350,7374,7389,7429,7464,7465,7482,7489,7501,7510,7524,7539,7593,7619,7625,7642,7646,7657,7661,7669,7683,7686,7692,7698,7714,7716,7726,7731,7732,7733,7765,7789,7799,7828,7843,7861,7862,7869,7877,7894,7902,7908,7909,7914,7918,7920,7925,7937,7963,7968,7969,7978,7981,8045,8052,8063,8065,8099,8107,8155,8198,8221,8245,8261,8270,8281,8297,8300,8314,8316,8326,8352,8357,8358,8369,8370,8373,8396,8398,8407,8413,8429,8441,8458,8460,8477,8483,8489,8501,8504,8506,8513,8518,8519,8527,8530,8532,8541,8546,8547,8550,8559,8567,8582,8606,8706,8707,8708,8735,8736,8739,8760,8764,8774,8790,8812,8824,8841,8887,8891,9018,9019,9032,9036,9090,9093,9176,9204,9213,9237,9238,9244,9263,9288,9295,9314,9318,9326,9327,9344,9347,9348,9356,9359,9360,9369,9374,9376,9391,9394,9396,9397,9404,9405,9406,9408,9409,9416,9418,9425,9434,9449,9453,9464,9474,9477,9494,9498,9507,9508,9526,9529,9530,9554,9567,9579,9593,9600,9601,9613,9614,9615,9616,9623,9628,9629,9632,9633,9634,9635,9642,9644,9646,9651,9653,9664,9665,9667,9668,9670,9673,9680,9682,9683,9684,9689,9696,9697,9698,9700,9705,9706,9710,9712,9713,9714,9715,9716,9718,9720,9721,9722,9723,9724,9728,9738,9740,9741,9742,9748,9751,9755,9758,9759,9762,9765,9767,9771,9772,9773,9774,9816,9819,9827,9831,9832,9836,9840,9847,9855,9860,9862,9865,9867,9890,9891,9904,9911,9912,9916,9920,9924,9935,9940,9956,9958,9974,9979,9985,9992,9997,10003,10014,10025,10034,10037,10071,10075,10085,10090,10100,10113,10116,10135,10137,10141,10155,10168,10171,10174,10180,10184,10185,10188,10189,10191,10201,10206,10212,10213,10223,10225,10229,10230,10243,10250,10257,10258,10268,10270,10277,10278,10281,10286,10290,10291,10296,10304,10320,10332,10333,10343,10365,10383,10388,10399,10400,10405,10406,10408,10409,10414,10415,10416,10420,10427,10443,10445,10449,10463,10467,10476,10477,10479,10501,10519,10527,10528,10533,10546,10549,10572,10586,10597,10598,10599,10602,10603,10607,10615,10622,10623,10625,10633,10634,10636,10638,10644,10649,10651,10656,10660,10663,10670,10674,10684,10690,10694,10701,10704,10710,10714,10723,10727,10728,10729,10736,10740,10744,10747,10748,10750,10762,10766,10770,10771,10782,10794,10797,10803,10804,10805,10809,10814,10816,10825,10836,10837,10838,10839,10840,10842,10844,10848,10853,10854,10866,10867,10868,10873,10874,10877,10884,10889,10890,10893,10894,10897,10898,10900,10907,10908,10909,10916,10919,10920,10927,10932,10934,10935,10943,10944,10946,10952,10974,10977,10988,10995,10996,11018,11039,11042,11044,11054,11056,11061,11062,11063,11066,11067,11073,11086,11095,11108,11109,11114,11121,11127,11129,11135,11141,11143,11147,11149,11158,11206,11211,11217,11226,11242,11245,11254,11255,11258,11259,11262,11264,11267,11268,11274,11280,11283,11290,11297,11298,11303,11332,11333,11345,11347,11351,11356,11357,11363,11375,11380,11385,11386,11389,11392,11399,11400,11402,11403,11407,11408,11429,11441,11444,11450,11506,11514,11522,11524,11525,11540,11544,11546,11550,11551,11552,11555,11556,11591,11592,11593,11599,11603,11606,11612,11624,11634,11640,11641,11644,11648,11649,11655,11697,11701,11702,11704,11707,11740,11766,11818,11841,11843,11848,11850,11852,11853,11854,11864,11877,11935,11940,11985,12016,12041,12042,12050,12075,12076,12077,12088,12091,12092,12094,12096,12097,12127,12145,12158,12162,12168,12169,12170,12184,12198,12208,12216,12221,12231,12233,12237,12244,12255,12266,12283,12287,12311,12336,12349,12353,12354,12366,12367,12370,12374,12416,12423,12432,12433,12450,12487,12496,12499,12511,12515,12518,12544,12545,12550,12552,12574,12580,12593,12596,12598,12602,12607,12609,12620,12621,12624,12626,12628,12630,12636,12639,12640,12647,12674,12684,12692,12696,12705,12714,12729,12737,12741,12770,12771,12800,12853,12861,12868,12877,12896,12898,12903,12923,12929,12939,12961,12963,12979,13018,13028,13074,13099,13103,13106,13108,13112,13117,13120,13127,13143,13145,13149,13166,13167,13170,13174,13187,13204,13206,13229,13235,13244,13246,13247,13264,13276,13306,13339,13358,13376,13383,13395,13406,13408,13414,13415,13419,13443,13463,13482,13526,13538,13545,13551,13556,13570,13644,13659,13700,13717,13729,13758,13761,13810,13859,13869,13905,13907,13918,13922,13923,13927,13939,13941,13990,13993,14008,14013,14021,14027,14041,14057,14080,14092,14128,14156,14163,14167,14182,14188,14203,14209,14250,14270,14275,14330,14337,14359,14385,14387,14413,14443,14451,14492,14499,14500,14503,14505,14520,14530,14537,14549,14565,14577,14581,14598,14607,14611,14617,14635,14659,14686,14714,14726,14752,14755,14756,14767,14776,14791,14806,14808,14825,14833,14837,14842,14853,14859,14870,14907,14909,14910,14921,14943,14969,15004,15012,15014,15027,15039,15040,15042,15044,15064,15065,15067,15068,15084,15113,15130,15137,15147,15164,15192,15234,15244,15263,15270,15271,15274,15283,15317,15318,15337,15345,15362,15363,15368,15375,15389,15423,15465,15485,15490,15502,15506,15517,15560,15571,15573,15579,15584,15605,15606,15613,15638,15682,15683,15684,15765,15767,15795,15797,15798,15799,15800,15809,15813,15816,15849,15851,15853,15859,15860,15861,15869,15874,15875,15876,15891,15892,15901,15903,15906,15915,15918,15926,15935,15963,15992,16026,16055,16073,16074,16079,16103,16131,16132,16140,16162,16179,16189,16193,16195,16204,16205,16210,16212,16268,16273,16292,16298,16315,16317,16329,16365,16368,16375,16384,16398,16400,16429,16450,16496,16509,16520,16547,16559,16597,16634,16656,16658,16660,16670,16756,16764,16768,16771,16788,16815,16871,16904,16917,16950,16954,16960,16998,17008,17009,17011,17035,17052,17082,17105,17114,17125,17144,17164,17203,17205,17212,17236,17249,17253,17254,17281,17299,17324,17385,17414,17418,17420,17436,17464,17496,17538,17539,17541,17545,17562,17563,17578,17595,17597,17630,17633,17640,17668,17682,17704,17710,17711,17748,17750,17801,17807,17823,17884,17909,17918,17928,17949,17994,17995,17998,18007,18017,18040,18064,18066,18073,18082,18084,18101,18106,18118,18137,18138,18139,18143,18151,18155,18174,18175,18179,18180,18203,18205,18208,18211,18216,18225,18230,18288,18297,18302,18332,18333,18343,18363,18366,18367,18392,18402,18403,18405,18415,18420,18423,18427,18436,18438,18443,18445,18454,18474,18475,18476,18478,18480,18481,18490,18491,18495,18499,18503,18535,18538,18552,18556,18572,18574,18582,18588,18590,18591,18606,18609,18626,18640,18644,18646,18654,18656,18661,18664,18665,18667,18672,18675,18683,18694,18696,18697,18705,18709,18713,18714,18717,18725,18750,18758,18760,18762,18793,18806,18811,18820,18822,18826,18832,18833,18850,18852,18859,18863,18868,18869,18871,18872,18880,18886,18887,18900,18915,18934,18943,18944,18948,18967,18972,18988,18989,18996,19001,19005,19009,19010,19043,19044,19052,19063,19068,19069,19070,19071,19077,19081,19082,19086,19088,19090,19091,19104,19109,19118,19130,19132,19143,19153,19156,19168,19169,19172,19175,19177,19203,19229,19230,19231,19233,19247,19254,19259,19266,19267,19278,19285,19295,19309,19313,19323,19324,19332,19339,19343,19347,19349,19350,19354,19362,19364,19374,19375,19383,19385,19390,19393,19394,19400,19402,19410,19411,19418,19420,19421,19422,19429,19430,19444,19456,19462,19472,19473,19475,19479,19485,19486,19500,19518,19523,19526,19528,19540,19545,19571,19572,19573,19575,19586,19588,19598,19599,19600,19630,19631,19638,19639,19651,19652,19653,19655,19667,19668,19669,19670,19671,19677,19679,19682,19683,19684,19689,19690,19691,19698,19703,19704,19706,19713,19743,19750,19766,19790,19803,19809,19810,19811,19820,19821,19825,19833,19835,19840,19844,19846,19854,19869,19870,19874,19875,19881,19884,19890,19891,19894,19895,19901,19903,19905,19906,19909,19911,19913,19914,19915,19918,19924,19939,19953,19956,19973,19976,19997,20003,20014,20021,20024,20028,20034,20045,20052,20053,20066,20073,20107,20114,20117,20118,20123,20142,20143,20151,20166,20168,20174,20176,20182,20187,20188,20192,20201,20206,20208,20209,20211,20214,20218,20219,20220,20221,20230,20236,20238,20239,20243,20256,20260,20264,20276,20285,20286,20296,20298,20302,20311,20327,20337,20346,20352,20353,20364,20366,20370,20383,20386,20391,20395,20405,20407,20421,20422,20425,20426,20429,20431,20432,20441,20444,20445,20459,20474,20485,20495,20496,20513,20522,20543,20549,20550,20557,20562,20565,20567,20574,20583,20598,20607,20611,20612,20613,20615,20628,20631,20636,20646,20661,20662,20663,20664,20700,20712,20713,20720,20729,20733,20734,20735,20740,20741,20755,20771,20773,20781,20784,20787,20811,20812,20813,20814,20821,20829,20832,20836,20839,20851,20855,20864,20868,20879,20884,20886,20887,20895,20898,20899,20909,20914,20934,20936,20942,20954,20958,20963,20973,20990,20993,21001,21009,21040,21060,21067,21068,21078,21080,21085,21086,21087,21091,21109,21118)
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 | 1644 | 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 | 1644 | |
3 | DERIVED | NULL | NULL | NULL | НЕ МОЖЕ ДА БЪДЕ ИЗПОЛЗВАН ИНДЕКС КЛЮЧ | NULL | NULL | NULL | No tables used |
Status | Duration |
---|
Starting | 0.52 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
Table lock | 0.01 ms |
Init | 0.23 ms |
Optimizing | 0.28 ms |
Statistics | 0.12 ms |
Preparing | 0.04 ms |
Creating tmp table | 0.03 ms |
Sorting result | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.16 ms |
Removing tmp table | 0.01 ms |
Sending data | 175.52 ms |
Creating sort index | 4.85 ms |
Removing tmp table | 22.07 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.00 ms |
Query end | 0.00 ms |
Commit | 0.01 ms |
Closing tables | 0.00 ms |
Removing tmp table | 0.00 ms |
Closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
Closing tables | 0.01 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 |