SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 287631 LIMIT 1 [ RunTime:0.000796s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 287631 [ RunTime:0.001800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (316337,788972,287845,645694,29900,916161,462900,734432,197732,413201,1028695,784248,121756,310932,265228,980355,140423,925190,442862,206706,426308,482416,703028,222989,610219,424332,796907,922010,95487,996315,446625,378390,318737,559240,577991,516344,294015,542353,418242,487175,757771,955968,329500,385784,911576,831872,950344,492827,1047053,455153,546600,609114,514216,737463,201922,355560,1024632,263754,237875,252102) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 287631 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 287631 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]