SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331641 LIMIT 1 [ RunTime:0.000512s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331641 [ RunTime:0.003245s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (92604,381876,114042,277062,14512,152426,304946,74354,1031087,979067,784656,202399,771109,1026362,258679,35662,143802,663697,36004,478535,396354,644435,489251,506521,6953,619336,1008486,44118,256326,307965,601557,594575,269757,132734,383714,273777,1032113,749822,247153,758710,105045,840590,104095,592345,126351,500474,557590,909752,400882,553347,998887,663242,838041,403700,757603,909814,154843,455844,649970,913830) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331641 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000635s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331641 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]