SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002014s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 194094 LIMIT 1 [ RunTime:0.001236s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 194094 [ RunTime:0.008030s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (585089,157412,846835,911819,474107,332130,142419,724541,955541,166768,778406,855101,152790,959379,566433,858797,412036,741566,910523,203493,635557,563687,329099,363615,21059,609714,760265,421839,1010407,1038530,865826,1001764,488835,447761,413387,273858,91270,400023,434842,920877,626767,606074,433039,280287,730737,376290,842313,916929,295936,26255,582699,368509,35380,153002,419988,402816,66696,459553,714460,885452) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 194094 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 194094 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000905s ]