SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481714 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481714 [ RunTime:0.002149s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (702640,975065,33647,901407,414702,741389,466625,614891,497820,878230,901001,22058,433102,350536,338913,38042,451076,522551,320503,672237,1033362,888906,85052,896289,781610,329572,351235,941422,112002,512278,59674,367093,259629,739848,14081,45079,577803,868975,1011541,1019930,293997,460161,621783,122061,978821,784325,1028922,953488,272479,135628,539984,582179,881117,351216,877205,876462,1013202,867215,935153,265024) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481714 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481714 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]