SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001402s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 586891 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 586891 [ RunTime:0.001598s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (439109,744035,725459,259299,668700,217425,653142,234022,850680,9589,132459,1008225,624425,945957,52792,857980,964511,802835,435300,72124,246505,651782,823346,499324,24354,378945,1031719,604203,241345,149139,141016,485615,467811,639130,175022,114907,939629,1048637,394476,39033,394116,776987,598651,620145,814904,739990,135071,414918,15044,232847,75373,959913,155083,328889,407569,281248,882886,585145,125525,392526) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001671s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 586891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 586891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000748s ]