SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 494994 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 494994 [ RunTime:0.001597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (600430,887804,554406,669558,790846,473100,281307,619214,983330,950641,489910,505014,176492,325327,7487,913966,31099,600512,417899,899396,215335,737706,76751,362680,991342,597515,773737,325536,534803,733504,758406,802359,20884,388334,899179,525411,742051,12812,196178,295556,702045,81412,845577,986464,207295,944171,189130,911479,162301,104973,1048843,1015314,675861,531730,888278,764590,236176,413803,318185) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000941s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 494994 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 494994 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000400s ]