SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 671005 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 671005 [ RunTime:0.002348s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (338431,570798,287588,645015,153824,906342,3172,25553,257674,910356,1628,372864,839801,588574,1030322,1038154,674828,83501,101724,1013494,39018,488573,1010089,331017,175001,530332,313689,393111,87058,609320,239343,777100,598471,69966,413713,33845,103380,869496,144040,763197,203659,753108,66126,503516,638344,349142,619796,190321,539056,918855,383073,504414,588983,44299,695844,338525,1005165,124694,237089,857919) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 671005 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 671005 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]