SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354133 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354133 [ RunTime:0.001843s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (671108,823094,593301,1028520,319335,519891,610935,989305,780520,416196,816648,20308,580881,845534,494382,649052,854384,425192,294305,780192,514094,539933,179176,120316,926639,628014,742271,986248,173989,847542,202289,457624,400193,695169,529164,703695,281929,757454,587479,885796,1044187,427855,41528,517185,794825,371034,291131,259225,755189,298707,1032650,936195,401424,114767,272001,823688,159338,966407,426636,928515) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354133 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354133 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003958s ]