SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531993 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531993 [ RunTime:0.001684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (198329,48469,377837,327752,217652,843857,834099,158370,724706,1038738,513008,409525,843525,904155,122350,80755,490697,976042,658761,629460,241746,1030378,482015,694218,159591,75786,970821,443345,862215,343514,113786,521434,542379,50018,1043193,362390,745397,51517,394515,23060,610173,853740,829255,857671,1048493,855364,996894,193863,14366,1007181,345941,524065,236146,636433,271067,967656,408659,393339,210795,781569) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]