SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485273 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485273 [ RunTime:0.002249s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (519277,523811,747370,881868,294221,838558,152896,754168,1023721,119189,639717,174831,628332,540394,711059,573959,17944,3741,88686,1029914,593529,245556,367352,265151,55361,697653,658601,658259,686512,254999,760274,878556,500295,249081,822743,495581,786333,221451,402042,847022,175816,949944,675635,371636,726766,307438,222189,995000,766714,763797,488998,386155,183290,788528,456005,270729,104810,607608,207916,574814) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001714s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485273 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485273 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]