Време на заявката: 115.07 ms След последната заявка: 1.79 ms Памет за заявки: 0.072 MB Памет преди заявката: 4.067 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-07-06 09:31:46')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2022-07-06 09:31:46')
AND i.access IN(1,1)
AND c.access IN(1,1)
AND c.published = 1
AND c.trash = 0
AND i.id IN(85,86,89,93,97,101,114,146,162,163,172,215,229,242,270,289,292,361,446,494,519,526,529,664,682,684,801,868,912,1037,1067,1145,1153,1170,1172,1181,1183,1193,1214,1267,1270,1276,1298,1394,1471,1485,1518,1529,1541,1548,1570,1603,1642,1647,1655,1742,1804,1875,1901,1950,1966,1996,2014,2032,2260,2293,2358,2396,2403,2550,2553,2635,2839,2847,2882,2894,2944,2957,2959,2968,2972,2979,2992,3001,3007,3008,3009,3040,3121,3172,3192,3204,3258,3351,3358,3364,3365,3384,3389,3393,3408,3416,3418,3425,3450,3471,3476,3517,3645,3833,3940,5736,6332,6347,6418,6535,6612,6664,6666,6728,6739,6740,6741,6746,6752,6753,6758,6764,6767,6773,6776,6777,6780,6781,6788,6792,6795,6802,6803,6807,6819,6821,6824,6828,6831,6840,6841,6844,6846,6849,6850,6855,6856,6857,6858,6859,6861,6862,6867,6868,6869,6883,6892,6894,6905,6906,6914,6915,6923,6926,6927,6929,6934,6939,6944,6955,6966,6982,6986,6987,6988,6991,6995,7000,7002,7006,7016,7026,7029,7031,7033,7037,7038,7039,7040,7043,7046,7053,7054,7055,7059,7060,7061,7074,7079,7091,7096,7099,7100,7106,7109,7110,7119,7120,7121,7127,7131,7133,7141,7145,7154,7156,7165,7170,7174,7182,7188,7208,7210,7229,7233,7234,7242,7245,7250,7252,7257,7259,7280,7285,7290,7302,7317,7328,7336,7374,7389,7429,7445,7464,7465,7475,7476,7482,7489,7501,7505,7524,7530,7539,7586,7593,7594,7619,7625,7642,7646,7657,7661,7683,7686,7692,7698,7714,7716,7726,7731,7732,7765,7799,7828,7843,7861,7862,7868,7869,7877,7894,7902,7908,7909,7914,7918,7920,7922,7925,7937,7952,7963,7968,7969,7978,7981,8045,8052,8063,8065,8086,8099,8107,8137,8147,8155,8197,8198,8202,8220,8221,8245,8261,8270,8281,8297,8300,8303,8309,8314,8316,8326,8338,8343,8352,8357,8358,8369,8370,8373,8396,8398,8407,8429,8441,8458,8460,8477,8483,8489,8501,8504,8506,8513,8518,8519,8530,8532,8541,8546,8547,8550,8559,8567,8582,8600,8606,8609,8706,8707,8708,8735,8736,8739,8750,8757,8760,8764,8774,8790,8812,8824,8841,8891,8959,8964,8991,9016,9032,9033,9090,9093,9170,9174,9176,9188,9202,9244,9295,9326,9347,9348,9359,9369,9391,9405,9409,9411,9416,9418,9419,9425,9428,9434,9438,9439,9441,9456,9461,9474,9494,9498,9507,9508,9542,9581,9586,9590,9593,9597,9601,9613,9640,9642,9644,9647,9651,9680,9684,9689,9693,9697,9705,9706,9714,9719,9723,9725,9745,9747,9748,9755,9758,9762,9771,9773,9795,9827,9831,9832,9833,9836,9840,9848,9851,9860,9863,9865,9868,9871,9911,9917,9919,9920,9940,9943,9958,9971,9985,9997,10000,10018,10030,10035,10040,10045,10057,10063,10068,10071,10084,10090,10100,10111,10113,10116,10127,10135,10141,10155,10168,10180,10184,10185,10188,10201,10206,10212,10213,10215,10223,10230,10243,10252,10277,10289,10296,10304,10329,10333,10349,10353,10374,10383,10399,10405,10406,10408,10411,10413,10415,10420,10427,10430,10443,10449,10463,10476,10477,10499,10501,10519,10527,10533,10536,10539,10546,10549,10571,10572,10581,10585,10586,10597,10598,10599,10602,10606,10607,10608,10614,10628,10638,10644,10645,10647,10648,10649,10651,10653,10654,10655,10660,10662,10663,10667,10670,10673,10674,10676,10678,10680,10684,10686,10690,10694,10701,10704,10706,10709,10714,10715,10720,10723,10727,10728,10729,10740,10744,10747,10748,10750,10758,10762,10768,10771,10781,10782,10797,10803,10804,10805,10809,10812,10814,10816,10829,10836,10837,10838,10839,10840,10844,10848,10853,10854,10866,10867,10868,10873,10874,10877,10884,10889,10890,10893,10894,10897,10898,10900,10901,10907,10908,10909,10919,10920,10927,10932,10934,10935,10943,10944,10952,10974,10977,10985,10988,10994,10995,11004,11031,11038,11039,11040,11042,11044,11050,11054,11056,11059,11061,11062,11063,11067,11068,11073,11084,11095,11108,11109,11120,11121,11127,11129,11135,11141,11147,11149,11158,11206,11211,11217,11226,11228,11229,11230,11240,11242,11245,11246,11252,11254,11255,11258,11259,11262,11264,11267,11268,11270,11280,11283,11290,11297,11298,11303,11330,11332,11333,11345,11347,11351,11356,11357,11363,11375,11380,11382,11389,11392,11399,11402,11403,11407,11408,11413,11429,11441,11444,11450,11506,11514,11515,11522,11524,11525,11528,11532,11540,11544,11546,11550,11551,11552,11555,11556,11561,11581,11591,11592,11593,11597,11598,11599,11601,11603,11606,11612,11624,11634,11640,11641,11644,11648,11655,11699,11701,11704,11706,11707,11740,11765,11766,11827,11841,11848,11850,11852,11854,11940,11985,12040,12041,12042,12053,12056,12058,12067,12070,12076,12085,12088,12089,12091,12092,12094,12096,12097,12106,12113,12127,12155,12158,12160,12169,12170,12198,12208,12216,12221,12224,12228,12230,12233,12237,12244,12255,12266,12283,12288,12311,12316,12342,12343,12349,12351,12353,12354,12357,12358,12362,12366,12367,12370,12374,12416,12418,12420,12423,12431,12450,12487,12493,12499,12511,12515,12518,12537,12541,12544,12545,12547,12550,12552,12561,12574,12580,12593,12598,12602,12607,12608,12609,12615,12620,12621,12624,12626,12636,12640,12647,12681,12689,12691,12695,12705,12714,12729,12750,12760,12770,12771,12783,12827,12833,12844,12852,12853,12861,12864,12868,12877,12881,12891,12896,12898,12903,12924,12929,12939,12940,12955,12961,12963,12979,12984,13010,13011,13028,13050,13074,13103,13106,13108,13112,13117,13127,13143,13145,13149,13150,13167,13170,13174,13187,13196,13206,13229,13235,13244,13246,13264,13276,13339,13358,13443,13444,13445,13526,13545,13562,13570,13644,13650,13659,13670,13700,13712,13717,13747,13761,13810,13848,13859,13869,13905,13907,13922,13923,14008,14039,14092,14128,14144,14156,14167,14182,14188,14203,14209,14250,14270,14304,14451,14492,14500,14505,14530,14537,14539,14549,14565,14577,14598,14611,14635,14640,14643,14644,14714,14726,14752,14756,14767,14776,14806,14825,14833,14837,14853,14859,14870,14897,14909,14910,14921,14933,14943,14947,15004,15005,15012,15014,15084,15116,15118,15130,15137,15164,15207,15211,15263,15270,15271,15297,15317,15337,15338,15345,15354,15362,15369,15370,15375,15376,15395,15423,15427,15479,15485,15514,15528,15579,15584,15605,15606,15613,15669,15683,15698,15778,15781,15791,15813,15815,15816,15860,15861,15874,15901,15921,15926,15953,15963,16026,16047,16106,16131,16135,16140,16145,16146,16175,16179,16182,16194,16195,16201,16204,16205,16209,16210,16212,16217,16240,16268,16275,16292,16303,16329,16335,16345,16362,16365,16367,16369,16375,16398,16400,16425,16429,16431,16455,16488,16493,16496,16506,16509,16520,16527,16531,16540,16544,16559,16584,16590,16634,16651,16660,16666,16696,16797,16917,16954,16998,17009,17011,17052,17114,17140,17176,17205,17212,17218,17297,17299,17301,17324,17343,17350,17392,17396,17418,17458,17461,17466,17478,17496,17503,17538,17539,17561,17562,17576,17578,17581,17594,17595,17613,17621,17630,17633,17694,17748,17767,17841,17842,17884,17886,17894,17895,17903,17915,17918,17928,17950,17964,17969,18007,18022,18025,18027,18049,18055,18056,18064,18072,18073,18095,18114,18115,18118,18124,18137,18146,18151,18155,18179,18180,18201,18203,18206,18222,18230,18237,18241,18252,18271,18280,18288,18327,18334,18343,18346,18363,18367,18392,18403,18405,18418,18420,18421,18422,18423,18426,18427,18436,18437,18438,18443,18450,18474,18476,18480,18490,18495,18503,18507,18511,18538,18545,18552,18590,18606,18609,18629,18640,18644,18654,18672,18675,18683,18694,18696,18697,18713,18714,18723,18725,18750,18753,18756,18758,18760,18777,18778,18779,18780,18785,18786,18796,18811,18820,18832,18833,18834,18839,18852,18859,18868,18869,18887,18900,18902,18915,18928,18988,18989,19001,19005,19006,19009,19030,19031,19041,19077,19082,19086,19089,19090,19091,19104,19109,19118,19123,19130,19153,19156,19175,19177,19193,19217,19223,19230,19247,19254,19257,19259,19278,19280,19282,19283,19285,19295,19303,19309,19313,19323,19324,19339,19343,19345,19347,19375,19383,19385,19389,19390,19393,19394,19396,19411,19418,19420,19421,19422,19429,19430,19436,19449,19456,19462,19468,19474,19477,19492,19498,19518,19540,19552,19573,19599,19600,19612,19616,19617,19630,19631,19637,19638,19652,19653,19660,19667,19669,19671,19677,19679,19682,19683,19684,19689,19698,19703,19704,19720,19730,19734,19736,19738,19748,19766,19784,19795,19796,19803,19809,19810,19811,19819,19820,19821,19825,19835,19844,19850,19853,19854,19869,19870,19881,19884,19890,19891,19894,19895,19901,19903,19906,19909,19913,19914,19915,19924,19930,19934,19939,19973,19976,19989,19997,20003,20006,20014,20021,20024,20028,20031,20034,20045,20052,20053,20063,20073,20076,20082,20092,20093,20095,20100,20102,20107,20114,20118,20124,20125,20138,20142,20143,20144,20149,20151,20166,20168,20174,20176,20182,20188,20189,20201,20206,20208,20211,20212,20214,20218,20220,20221,20230,20239,20243,20264,20266,20285,20286,20288,20298,20311,20312,20313,20346,20348,20353,20364,20370,20377,20383,20386,20391,20395,20405,20407,20421,20422,20429,20431,20438,20441,20444,20448,20456,20470,20484,20485,20495,20496,20506,20508,20513,20522,20530,20543,20549,20551,20557,20560,20562,20565,20567,20570,20574,20582,20586,20611,20612,20613,20615,20622,20625,20646,20658,20662,20663,20664,20665,20678,20681,20683,20692,20693,20694,20697,20700,20712,20713,20715,20720,20729,20732,20733,20734,20741,20755,20761,20773,20781,20787,20809,20811,20814,20829,20832,20836,20839,20851,20855,20857,20858,20861,20862,20868,20874,20876,20879,20884,20886,20887,20892,20895,20898,20899,20904,20908,20914,20916,20949,20954,20958,20965,20971,20990,20997,20998,21009,21016,21023,21032,21046,21047,21048,21060,21061,21063,21064,21067,21078,21080,21085,21104,21117,21118,21121,21145,21152,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 | 1632 | 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 | 1632 | |
3 | DERIVED | NULL | NULL | NULL | НЕ МОЖЕ ДА БЪДЕ ИЗПОЛЗВАН ИНДЕКС КЛЮЧ | NULL | NULL | NULL | No tables used |
Status | Duration |
---|
Starting | 0.88 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.36 ms |
Optimizing | 0.43 ms |
Statistics | 0.34 ms |
Preparing | 0.07 ms |
Creating tmp table | 0.05 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.33 ms |
Removing tmp table | 0.01 ms |
Sending data | 85.62 ms |
Creating sort index | 5.28 ms |
Removing tmp table | 21.28 ms |
Creating sort index | 0.04 ms |
End of update loop | 0.02 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.09 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 |