SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457221 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457221 [ RunTime:0.001796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (726110,174520,392053,610122,388024,867824,491355,266290,81742,259272,245187,328348,514137,55731,185900,65354,8065,81708,198001,215428,293435,827992,632607,566771,573098,441825,230900,881528,447506,359637,760709,763470,1016749,73061,245653,197023,29144,715123,154746,73005,745843,548601,437483,700347,584892,46004,959334,677214,394446,778437,971946,241584,679375,160245,372474,449310,527087,254404,593365,121397) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457221 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457221 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]