SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428036 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428036 [ RunTime:0.002101s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (507815,293407,159447,727647,566854,801015,232468,822672,1013926,180221,793760,866899,689256,52252,680433,914773,513356,557391,426306,730359,132743,21906,705721,538509,409550,989745,861284,539018,818030,303839,825620,859322,221749,850206,208521,488998,33594,150921,938134,220713,553054,585464,417712,525093,833149,792442,132967,471511,502959,677509,111042,214480,631284,532857,337326,1019904,934870,982056,372062,931620) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428036 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428036 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]