Време на заявката: 105.15 ms След последната заявка: 0.76 ms Памет за заявки: 0.072 MB Памет преди заявката: 4.037 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:26:44')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2022-05-20 07:26:44')
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,6752,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,6955,6966,6987,6988,6991,6995,7000,7002,7006,7016,7026,7029,7031,7033,7037,7038,7039,7040,7043,7046,7054,7055,7059,7060,7061,7079,7091,7096,7099,7100,7106,7109,7110,7119,7120,7127,7131,7133,7141,7145,7154,7156,7165,7170,7174,7180,7181,7182,7208,7210,7233,7234,7242,7245,7250,7252,7257,7259,7280,7290,7302,7317,7328,7336,7374,7389,7429,7464,7465,7482,7489,7501,7524,7539,7593,7619,7625,7642,7646,7657,7661,7683,7686,7692,7698,7714,7716,7726,7731,7732,7765,7799,7828,7843,7861,7862,7869,7877,7889,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,8429,8441,8458,8460,8477,8483,8489,8501,8504,8506,8513,8518,8519,8530,8532,8541,8546,8547,8550,8559,8567,8582,8606,8706,8707,8708,8735,8736,8739,8760,8764,8774,8790,8812,8824,8841,8891,8966,9029,9032,9090,9093,9176,9191,9200,9244,9295,9303,9326,9347,9348,9359,9369,9391,9405,9409,9416,9418,9425,9434,9474,9494,9498,9507,9508,9586,9593,9601,9613,9642,9644,9651,9676,9680,9684,9689,9705,9706,9714,9723,9748,9755,9758,9762,9771,9773,9808,9831,9832,9836,9840,9844,9860,9865,9920,9921,9937,9940,9958,9964,9985,10032,10039,10058,10071,10073,10077,10090,10113,10116,10129,10135,10141,10155,10168,10180,10184,10188,10201,10206,10212,10213,10223,10230,10243,10277,10288,10296,10304,10333,10383,10385,10391,10394,10395,10397,10398,10405,10406,10408,10415,10420,10427,10443,10449,10463,10476,10477,10481,10496,10501,10519,10527,10533,10538,10546,10549,10556,10571,10572,10586,10597,10598,10599,10602,10607,10608,10638,10649,10651,10663,10674,10684,10701,10714,10723,10727,10728,10729,10740,10744,10747,10750,10771,10782,10797,10803,10804,10805,10809,10814,10816,10836,10837,10838,10839,10840,10844,10848,10853,10854,10866,10867,10868,10873,10874,10877,10884,10889,10890,10893,10894,10897,10898,10900,10907,10908,10909,10919,10920,10927,10932,10934,10935,10943,10944,10952,10965,10972,10974,10977,10988,10995,11039,11042,11044,11050,11054,11056,11061,11062,11063,11067,11073,11095,11099,11108,11109,11110,11119,11121,11127,11129,11135,11138,11141,11147,11149,11158,11206,11211,11217,11226,11235,11240,11242,11245,11249,11250,11253,11254,11255,11258,11259,11262,11264,11267,11268,11280,11283,11290,11297,11303,11332,11333,11345,11347,11351,11356,11357,11363,11375,11380,11389,11392,11399,11402,11403,11407,11408,11429,11441,11444,11450,11506,11512,11514,11517,11518,11521,11522,11524,11525,11536,11544,11546,11550,11551,11552,11555,11556,11591,11592,11593,11603,11606,11612,11624,11634,11640,11641,11644,11648,11655,11701,11704,11707,11740,11766,11848,11850,11852,11854,11940,11985,12041,12076,12088,12091,12092,12094,12096,12097,12127,12158,12169,12170,12198,12208,12216,12221,12233,12244,12255,12266,12283,12311,12353,12354,12366,12367,12370,12374,12416,12423,12450,12487,12495,12499,12500,12511,12515,12517,12518,12544,12545,12550,12552,12574,12580,12593,12598,12600,12607,12609,12620,12621,12624,12626,12636,12640,12646,12647,12705,12714,12729,12770,12771,12853,12861,12868,12877,12896,12898,12903,12929,12939,12961,12963,12979,12988,13028,13057,13058,13069,13074,13083,13084,13103,13106,13108,13112,13117,13127,13143,13145,13149,13167,13170,13174,13187,13206,13229,13235,13244,13246,13264,13276,13339,13358,13443,13526,13545,13570,13644,13659,13700,13717,13761,13810,13859,13869,13905,13907,13923,14008,14092,14105,14128,14156,14167,14182,14188,14203,14250,14270,14451,14492,14500,14505,14530,14537,14549,14565,14577,14598,14611,14635,14714,14726,14752,14756,14767,14776,14806,14825,14833,14837,14853,14859,14870,14909,14910,14919,14921,14943,15004,15012,15014,15084,15130,15137,15159,15164,15263,15270,15271,15317,15337,15345,15362,15375,15423,15485,15579,15584,15605,15606,15613,15813,15816,15860,15861,15874,15901,15926,15963,16026,16131,16140,16171,16179,16195,16204,16205,16210,16212,16268,16292,16329,16365,16375,16398,16400,16429,16496,16509,16520,16559,16634,16660,16917,16954,16998,17009,17011,17052,17114,17205,17212,17324,17418,17496,17538,17539,17562,17578,17595,17630,17633,17748,17884,17918,17928,18007,18059,18064,18118,18137,18151,18155,18179,18180,18203,18230,18288,18343,18363,18392,18403,18405,18420,18423,18427,18436,18438,18443,18474,18476,18480,18490,18495,18503,18538,18590,18606,18609,18640,18654,18672,18675,18683,18694,18696,18697,18713,18714,18725,18750,18758,18760,18811,18820,18832,18833,18852,18859,18868,18869,18887,18900,18915,18988,18989,19001,19005,19009,19077,19082,19089,19091,19104,19109,19118,19130,19153,19156,19175,19177,19217,19230,19247,19254,19259,19278,19285,19295,19309,19313,19323,19324,19339,19343,19347,19375,19383,19385,19390,19393,19394,19411,19418,19420,19421,19422,19429,19430,19431,19462,19518,19540,19599,19600,19630,19631,19638,19652,19653,19667,19669,19671,19677,19679,19682,19683,19684,19689,19698,19703,19704,19766,19803,19809,19810,19811,19820,19821,19825,19834,19835,19854,19869,19870,19881,19884,19890,19891,19894,19895,19901,19903,19906,19909,19913,19914,19915,19924,19939,19973,19976,20003,20014,20021,20024,20028,20034,20045,20052,20053,20073,20095,20102,20107,20114,20118,20121,20124,20125,20142,20151,20166,20168,20174,20176,20182,20188,20201,20206,20208,20211,20212,20214,20218,20220,20221,20230,20239,20243,20264,20268,20285,20286,20298,20299,20304,20311,20346,20353,20364,20370,20383,20386,20391,20402,20405,20407,20421,20422,20429,20431,20437,20441,20444,20468,20495,20496,20502,20513,20522,20543,20549,20553,20557,20562,20565,20567,20578,20606,20608,20611,20612,20615,20618,20627,20634,20646,20661,20662,20663,20664,20712,20713,20720,20729,20733,20734,20741,20755,20769,20773,20781,20787,20811,20814,20829,20832,20836,20839,20851,20855,20868,20879,20883,20884,20886,20887,20892,20895,20898,20899,20908,20914,20949,20954,20958,20969,20971,20977,20981,20982,20983,20989,20990,20991,20992,20998,21008,21009,21015,21016,21023,21032,21040,21046,21047,21048,21049,21056,21060,21061,21064,21068,21077,21078,21080,21085,21105,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 | 1145 | 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 | 1145 | |
3 | DERIVED | NULL | NULL | NULL | НЕ МОЖЕ ДА БЪДЕ ИЗПОЛЗВАН ИНДЕКС КЛЮЧ | NULL | NULL | NULL | No tables used |
Status | Duration |
---|
Starting | 0.37 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
Table lock | 0.00 ms |
Init | 0.17 ms |
Optimizing | 0.23 ms |
Statistics | 0.17 ms |
Preparing | 0.04 ms |
Creating tmp table | 0.03 ms |
Sorting result | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.13 ms |
Removing tmp table | 0.01 ms |
Sending data | 86.38 ms |
Creating sort index | 3.43 ms |
Removing tmp table | 13.84 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.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.07 ms |
Updating status | 0.03 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 |