SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001401s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281272 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281272 [ RunTime:0.002821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (247380,284910,160839,747924,928269,334633,52749,827430,357969,920873,993908,674503,472200,208442,304775,667886,484503,862923,809720,910719,429418,824840,549167,941150,918758,429313,903402,402328,144995,984481,185093,2391,797163,1046287,758362,124796,330864,264049,352603,13782,568374,983091,500458,728546,675958,629101,649735,901664,492290,7940,631094,463240,226345,578539,995350,654916,451421,634465,306337,722232) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281272 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281272 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000736s ]