SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544993 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544993 [ RunTime:0.002922s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (138382,921112,198177,57890,422675,588969,873557,928649,962454,535764,737479,887295,297774,512169,802752,128914,333741,180230,709559,212834,186912,497090,351495,631171,717173,359853,291012,443621,237981,989577,461985,551560,23985,566589,785435,473809,281500,97395,89991,414827,467018,455887,941131,206577,544514,700779,745330,25369,684193,889911,336428,528004,952376,423207,43183,599822,753133,354347,581761,704176) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]