SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001480s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001400 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001400 [ RunTime:0.001463s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (788708,715144,986703,510020,630913,136585,996598,52248,119805,840936,246573,49850,351740,521356,341107,896930,281040,649589,921464,502430,125787,80226,297922,958173,1013849,794703,827129,964938,113688,930036,286037,558095,228064,23374,244274,606425,61270,606551,678493,880926,391302,461300,397411,860142,7608,648230,883687,80913,452146,85863,102461,1009197,569533,482898,423097,670010,899826,481316,937059,5595) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]