SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405477 LIMIT 1 [ RunTime:0.000458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405477 [ RunTime:0.001868s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (993489,120886,422932,389958,37540,797880,310588,773253,133540,201606,531694,108628,879279,989428,174181,275246,540403,479628,960901,225596,178032,58919,793006,439933,1030437,842190,776772,696823,233608,537644,949882,1043840,714812,730748,8474,67920,841309,331053,903002,181978,399357,328696,205688,866726,454011,566363,713948,651823,420730,408968,300061,957005,588083,872802,921014,314177,198738,472005,964522,932910) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405477 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405477 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]