SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019679 LIMIT 1 [ RunTime:0.001798s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019679 [ RunTime:0.004443s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (22358,46438,696513,217477,669400,489339,1039997,140016,120476,952222,898618,660309,759292,852271,238353,187954,801147,755221,352489,353561,358876,769714,783815,991461,683256,15658,775978,98512,912592,76693,851150,222932,1000919,310955,299790,748858,834173,360207,895295,222317,736679,213844,876269,960817,642225,620991,631310,192522,108036,216955,21212,353395,843406,657161,39746,167476,108873,183586,473902,403497) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001657s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019679 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000717s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019679 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001920s ]