SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414053 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414053 [ RunTime:0.002517s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (369383,951442,978679,296670,699054,864117,993379,786265,747061,852315,532842,285945,720914,801339,686132,308998,1009418,318486,225998,687757,244194,261628,794944,37333,929627,822959,668197,908586,297780,128431,879902,849156,901169,678016,582243,248213,899666,184924,354818,747830,595583,674557,984351,190755,724317,446316,930560,602359,936915,875958,177797,519491,734311,328883,91887,59247,223071,684281,269924,875475) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]