SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438875 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438875 [ RunTime:0.002349s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (350924,482015,235259,682670,55505,107621,626573,144822,661220,156667,94298,601702,920461,1004229,762486,242149,515537,114197,8430,61090,801970,890647,280928,126272,168147,157931,176827,569785,961963,618889,813887,347526,816094,954205,719825,426158,653399,141473,893618,475928,498302,756411,925160,507030,35314,1032890,177947,556874,108322,391392,643949,669557,768778,554163,477958,1023649,792574,811867,974484,643525) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438875 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438875 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001758s ]