SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001373s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50640 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50640 [ RunTime:0.001595s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (788410,256613,538286,628423,2354,362951,957370,984076,739205,763766,72648,435486,278390,967788,338375,392505,585529,38405,930464,1041356,596129,244041,426143,278600,258831,954953,929507,659477,821668,276942,999263,891651,1032596,83341,789865,42220,373724,209161,324686,315896,553896,127984,736746,25512,906115,716149,662686,672681,159622,164460,1002808,173212,1009152,902461,769849,587061,473347,512434,867586,891229) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]