SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 193407 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 193407 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (821394,292618,1017533,856855,60103,676014,743377,85059,643330,433683,605337,719944,880442,510741,917273,683589,542289,945405,785842,661896,924500,734733,386030,114886,1004882,943104,936720,532514,396082,839131,426510,569788,515816,368503,942095,130236,548650,60192,915623,1023195,687567,8237,173601,808890,812545,158102,831954,151356,452406,389223,147772,288892,531427,284867,7784,247053,556510,591350,363891,47197) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000959s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 193407 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 193407 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]