Време на заявката: 228.19 ms След последната заявка: 1.14 ms Памет за заявки: 0.072 MB Памет преди заявката: 3.517 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-02-05 18:13:18')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-02-05 18:13:18')
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,153,172,215,309,313,400,494,636,664,682,768,796,801,802,841,868,878,889,912,934,950,963,973,1153,1170,1172,1181,1183,1214,1263,1267,1298,1394,1503,1595,1647,1677,1899,1901,1966,2115,2260,2326,2367,2396,2403,2407,2550,2553,2732,2882,2894,2944,2959,2968,2971,2992,3001,3007,3008,3009,3040,3042,3192,3196,3204,3223,3258,3351,3357,3418,3471,3476,3517,3645,5245,5522,5736,6048,6418,6561,6612,6624,6664,6666,6728,6739,6740,6741,6746,6753,6755,6758,6764,6767,6773,6776,6777,6778,6780,6781,6788,6792,6795,6796,6800,6802,6803,6807,6813,6819,6821,6824,6828,6831,6840,6841,6844,6849,6850,6853,6855,6856,6857,6858,6859,6861,6862,6867,6868,6869,6883,6892,6905,6906,6913,6914,6915,6923,6926,6927,6929,6933,6934,6936,6939,6941,6944,6955,6966,6981,6987,6988,6991,6995,7000,7002,7006,7016,7026,7029,7031,7033,7037,7038,7039,7040,7043,7046,7049,7054,7055,7059,7060,7061,7079,7087,7091,7096,7099,7100,7106,7109,7110,7113,7119,7120,7127,7131,7133,7141,7145,7153,7154,7156,7165,7170,7172,7174,7182,7183,7190,7191,7208,7210,7225,7233,7234,7238,7242,7245,7250,7252,7257,7259,7280,7290,7302,7317,7328,7336,7343,7367,7374,7389,7409,7422,7429,7464,7465,7469,7480,7482,7489,7501,7519,7524,7539,7541,7577,7593,7619,7625,7640,7642,7646,7657,7661,7683,7686,7692,7698,7714,7716,7726,7731,7732,7765,7772,7774,7799,7806,7828,7843,7861,7862,7869,7877,7891,7894,7902,7904,7908,7909,7914,7918,7920,7925,7935,7937,7943,7963,7968,7969,7978,7981,7992,7995,8017,8018,8045,8052,8063,8065,8099,8107,8140,8143,8155,8156,8198,8221,8222,8225,8245,8257,8261,8270,8277,8281,8288,8297,8300,8314,8316,8326,8338,8352,8357,8358,8369,8370,8373,8396,8397,8398,8404,8407,8420,8429,8441,8458,8460,8465,8467,8477,8480,8483,8489,8501,8504,8506,8511,8513,8518,8519,8520,8530,8531,8532,8541,8546,8547,8550,8559,8566,8567,8582,8587,8596,8606,8613,8674,8706,8707,8708,8720,8726,8735,8736,8739,8760,8764,8766,8774,8790,8812,8816,8824,8841,8852,8884,8891,8936,8967,8976,8997,9011,9032,9087,9090,9093,9096,9129,9135,9151,9166,9169,9176,9228,9241,9244,9257,9277,9288,9295,9314,9317,9326,9336,9347,9348,9359,9369,9371,9374,9387,9391,9405,9409,9416,9418,9425,9434,9437,9469,9474,9494,9498,9499,9507,9508,9514,9519,9531,9572,9585,9589,9593,9601,9607,9611,9612,9613,9622,9641,9642,9644,9650,9651,9655,9658,9677,9680,9682,9684,9689,9705,9706,9714,9723,9739,9748,9749,9755,9758,9760,9762,9764,9771,9773,9782,9808,9831,9832,9836,9840,9850,9852,9860,9862,9865,9867,9895,9901,9903,9920,9940,9950,9958,9967,9985,10014,10022,10071,10079,10090,10113,10116,10124,10135,10139,10141,10148,10155,10168,10180,10184,10188,10189,10201,10206,10212,10213,10223,10230,10243,10277,10296,10304,10310,10315,10333,10345,10362,10383,10399,10405,10406,10408,10415,10420,10427,10438,10443,10449,10463,10466,10476,10477,10501,10519,10527,10533,10546,10549,10550,10562,10572,10582,10586,10590,10597,10598,10599,10602,10607,10636,10638,10649,10651,10660,10663,10674,10684,10701,10712,10714,10723,10727,10728,10729,10736,10740,10744,10747,10750,10771,10782,10797,10803,10804,10805,10809,10814,10816,10836,10837,10838,10839,10840,10842,10844,10848,10853,10854,10866,10867,10868,10873,10874,10877,10884,10889,10890,10893,10894,10897,10898,10900,10905,10907,10908,10909,10916,10917,10919,10920,10923,10927,10928,10932,10934,10935,10943,10944,10952,10956,10973,10974,10977,10988,10995,11027,11030,11039,11042,11044,11054,11056,11061,11062,11063,11066,11067,11073,11095,11108,11109,11118,11121,11122,11127,11129,11135,11140,11141,11147,11149,11157,11158,11162,11184,11206,11211,11217,11226,11242,11245,11254,11255,11258,11259,11262,11264,11267,11268,11280,11283,11290,11297,11303,11313,11332,11333,11345,11347,11351,11356,11357,11363,11372,11375,11380,11381,11389,11392,11396,11399,11400,11402,11403,11407,11408,11429,11441,11444,11450,11491,11506,11509,11514,11522,11524,11525,11544,11546,11549,11550,11551,11552,11555,11556,11574,11583,11591,11592,11593,11599,11603,11606,11612,11624,11634,11640,11641,11644,11648,11655,11697,11701,11704,11707,11708,11722,11726,11740,11742,11757,11766,11786,11821,11847,11848,11850,11852,11854,11940,11974,11985,12041,12049,12050,12067,12076,12088,12091,12092,12094,12096,12097,12102,12127,12130,12158,12162,12169,12170,12187,12198,12203,12208,12216,12219,12221,12233,12244,12255,12264,12266,12282,12283,12311,12317,12328,12349,12353,12354,12366,12367,12370,12374,12377,12416,12420,12423,12450,12457,12462,12476,12487,12499,12510,12511,12515,12518,12534,12543,12544,12545,12548,12550,12552,12554,12555,12558,12560,12567,12574,12580,12593,12595,12596,12598,12607,12609,12620,12621,12624,12626,12636,12640,12647,12674,12691,12705,12714,12716,12717,12721,12722,12727,12729,12731,12746,12770,12771,12773,12797,12809,12826,12828,12831,12832,12834,12838,12839,12846,12849,12853,12857,12858,12861,12868,12871,12877,12886,12896,12898,12903,12905,12929,12939,12961,12963,12966,12979,13018,13024,13028,13055,13074,13080,13086,13094,13103,13105,13106,13108,13112,13113,13117,13127,13143,13145,13149,13157,13167,13170,13174,13187,13206,13229,13235,13244,13246,13249,13263,13264,13276,13293,13298,13310,13329,13339,13342,13347,13358,13376,13393,13409,13412,13434,13443,13463,13503,13517,13526,13538,13545,13570,13637,13644,13659,13700,13717,13758,13761,13762,13777,13795,13810,13816,13844,13859,13869,13870,13905,13907,13911,13912,13923,13925,13941,13959,13971,14008,14015,14032,14057,14092,14111,14126,14128,14137,14156,14158,14164,14167,14182,14188,14198,14203,14226,14250,14270,14271,14323,14338,14343,14382,14396,14401,14409,14422,14442,14451,14478,14492,14500,14503,14505,14527,14530,14536,14537,14545,14549,14565,14569,14577,14588,14590,14598,14611,14621,14635,14646,14668,14682,14714,14726,14752,14756,14767,14776,14777,14786,14793,14806,14825,14833,14837,14844,14853,14859,14865,14870,14875,14904,14909,14910,14917,14921,14928,14941,14943,15004,15012,15013,15014,15024,15034,15045,15048,15062,15079,15084,15087,15094,15099,15110,15130,15137,15164,15166,15202,15233,15263,15265,15270,15271,15274,15295,15317,15327,15337,15345,15362,15370,15375,15398,15406,15414,15421,15423,15450,15464,15485,15504,15531,15546,15579,15584,15589,15605,15606,15607,15613,15662,15684,15695,15698,15742,15797,15800,15813,15816,15860,15861,15874,15887,15892,15901,15926,15939,15963,16004,16026,16055,16118,16131,16133,16140,16156,16171,16178,16179,16195,16204,16205,16210,16212,16214,16259,16268,16276,16292,16294,16315,16329,16352,16365,16375,16384,16386,16398,16400,16408,16429,16433,16436,16450,16488,16495,16496,16509,16512,16514,16520,16555,16558,16559,16571,16573,16582,16613,16634,16642,16648,16660,16671,16688,16691,16711,16720,16734,16765,16798,16813,16838,16846,16870,16878,16903,16917,16936,16937,16949,16954,16960,16970,16986,16998,17006,17009,17011,17052,17064,17081,17090,17114,17121,17137,17141,17157,17180,17193,17205,17212,17217,17224,17226,17231,17236,17253,17275,17293,17299,17324,17345,17362,17376,17398,17414,17418,17422,17442,17473,17496,17501,17517,17538,17539,17541,17545,17562,17578,17584,17595,17604,17630,17633,17674,17697,17711,17729,17748,17752,17776,17785,17819,17823,17836,17860,17881,17884,17894,17918,17925,17928,17949,17952,17957,17979,17995,18007,18045,18064,18076,18101,18108,18117,18118,18137,18139,18151,18155,18167,18179,18180,18203,18223,18230,18244,18255,18281,18286,18288,18303,18321,18330,18339,18343,18362,18363,18392,18395,18403,18405,18414,18420,18423,18425,18427,18436,18438,18440,18443,18445,18460,18474,18476,18480,18481,18490,18495,18503,18517,18522,18525,18527,18534,18538,18549,18565,18574,18583,18589,18590,18592,18597,18606,18609,18615,18631,18640,18645,18646,18647,18654,18658,18666,18671,18672,18675,18676,18683,18694,18696,18697,18713,18714,18725,18728,18732,18745,18746,18747,18750,18758,18760,18763,18768,18797,18807,18811,18820,18832,18833,18839,18841,18852,18855,18859,18866,18868,18869,18881,18884,18886,18887,18897,18900,18902,18906,18915,18929,18933,18947,18954,18960,18962,18988,18989,19001,19005,19009,19010,19029,19038,19057,19077,19082,19090,19091,19093,19101,19104,19106,19109,19111,19118,19130,19133,19140,19143,19147,19151,19153,19154,19156,19171,19172,19175,19177,19182,19196,19212,19229,19230,19235,19244,19247,19254,19259,19278,19281,19285,19294,19295,19309,19313,19321,19323,19324,19326,19338,19339,19343,19347,19362,19375,19383,19385,19390,19393,19394,19405,19407,19411,19418,19420,19421,19422,19423,19429,19430,19441,19452,19460,19461,19462,19465,19472,19476,19478,19484,19501,19502,19518,19534,19538,19540,19555,19560,19569,19586,19590,19599,19600,19606,19619,19630,19631,19638,19652,19653,19662,19667,19669,19671,19677,19679,19680,19682,19683,19684,19685,19689,19693,19698,19700,19703,19704,19719,19724,19736,19737,19749,19766,19767,19773,19783,19800,19803,19809,19810,19811,19820,19821,19825,19827,19831,19832,19835,19839,19851,19854,19856,19857,19869,19870,19880,19881,19884,19890,19891,19894,19895,19899,19901,19903,19906,19909,19913,19914,19915,19916,19918,19921,19923,19924,19925,19929,19933,19939,19947,19971,19973,19976,19988,20000,20001,20003,20014,20021,20024,20028,20031,20034,20042,20045,20052,20053,20056,20068,20073,20077,20078,20091,20107,20110,20111,20113,20114,20120,20137,20142,20151,20156,20157,20166,20168,20174,20176,20179,20180,20182,20188,20191,20193,20198,20201,20206,20208,20211,20214,20218,20220,20221,20222,20230,20239,20243,20245,20262,20264,20282,20285,20286,20290,20298,20299,20311,20317,20332,20346,20353,20354,20358,20366,20370,20378,20383,20386,20388,20390,20391,20392,20401,20405,20407,20416,20417,20421,20422,20424,20427,20429,20431,20434,20441,20444,20472,20474,20481,20484,20485,20488,20493,20494,20495,20496,20500,20506,20509,20511,20513,20521,20522,20539,20542,20543,20544,20549,20557,20562,20565,20567,20579,20590,20611,20612,20613,20615,20618,20624,20646,20648,20656,20661,20662,20663,20664,20678,20689,20712,20713,20720,20729,20730,20733,20734,20741,20755,20762,20773,20777,20781,20784,20786,20787,20788,20789,20794,20811,20814,20822,20829,20832,20836,20839,20848,20849,20851,20855,20868,20871,20879,20884,20886,20887,20895,20898,20901,20902,20914,20930,20935,20939,20942,20954,20958,20964,20972,20974,20988,20990,21014,21020,21023,21024,21035,21055,21058,21060,21067,21078,21080,21085,21098,21102,21106,21107,21115,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 | 1779 | 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 | 1779 | |
3 | DERIVED | NULL | NULL | NULL | НЕ МОЖЕ ДА БЪДЕ ИЗПОЛЗВАН ИНДЕКС КЛЮЧ | NULL | NULL | NULL | No tables used |
Status | Duration |
---|
Starting | 0.55 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.26 ms |
Optimizing | 0.30 ms |
Statistics | 0.24 ms |
Preparing | 0.05 ms |
Creating tmp table | 0.04 ms |
Sorting result | 0.01 ms |
Executing | 0.01 ms |
Sending data | 0.22 ms |
Removing tmp table | 0.01 ms |
Sending data | 179.36 ms |
Creating sort index | 8.52 ms |
Removing tmp table | 38.25 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.10 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 |