SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001406s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534035 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534035 [ RunTime:0.002434s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (190878,901955,281397,671752,271138,915080,944505,204683,701426,19959,171208,255241,531118,844591,346339,717618,50077,296213,109620,579380,1039957,582692,814468,612419,828163,663612,1039659,584658,692169,171485,461060,389404,687492,734747,7237,363151,525794,880357,731441,710275,815388,155182,174916,270082,791387,472185,290813,838199,262556,559109,874966,897470,336694,538085,618440,606895,416976,72489,954205,985122) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000954s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534035 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534035 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]