SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512509 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512509 [ RunTime:0.002063s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (863326,46250,102509,237491,54139,961069,482727,384606,290808,115857,734365,412624,878010,933604,601990,807253,143079,123352,655586,497560,433289,41089,296386,746033,324946,970868,340902,175018,870370,490482,524865,989971,802264,665240,46119,383146,366874,298205,541807,961895,820248,959900,412366,418102,562259,700889,309445,56883,861687,541692,70499,136447,1003507,1037283,945386,31598,237957,82116,335232,1048035) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000558s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]