SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513942 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513942 [ RunTime:0.003208s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (391286,1032196,631384,433136,678687,477941,950760,544333,276565,955042,893645,847048,121643,1004610,686767,316778,98392,672705,482406,264508,288878,68207,129588,1002274,656651,480941,954868,227480,697533,1032740,262743,81320,611500,1044773,681363,658126,860499,387049,35397,996252,1018937,334440,488196,724641,582430,326253,427042,209674,501065,245489,970138,168702,1002320,610196,889414,260092,877545,628054,951371,311724) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513942 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000645s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513942 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]