SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488781 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488781 [ RunTime:0.002007s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (340086,997988,300080,356692,126722,886089,822618,683233,904847,358590,136689,385426,786456,351588,273834,732343,696060,859664,1006320,73051,398104,81,141970,127524,982337,249226,324768,500377,393462,34794,318956,34216,568863,933450,163060,1003704,379185,980319,509175,232253,708305,322923,810034,282545,730196,161339,499200,2824,862872,1019904,118955,237815,143863,984888,970564,478274,625550,354037,906932,967007) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000564s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]