SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003502s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022592 LIMIT 1 [ RunTime:0.002848s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022592 [ RunTime:0.002657s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (888188,69456,103587,255069,504494,867120,885001,972306,101378,746264,926172,596487,1024533,785251,412259,1008744,1011523,596192,163831,432834,47048,403513,375007,1024812,462427,539146,358520,728529,8023,106433,954197,507206,438062,387858,456001,191758,436949,659356,1009640,883953,726328,523645,889415,333877,783998,244972,636891,878698,1023663,130294,429405,267292,914623,777523,944398,610413,792488,42553,651564,404264) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022592 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022592 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000817s ]