SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490491 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490491 [ RunTime:0.002267s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (106065,953221,834950,20157,355357,462091,665077,662309,39945,255363,162675,153001,540243,423969,350173,586058,861550,800235,1047532,545712,449442,970914,4188,156671,515040,519076,908542,1042590,549984,281033,649293,478181,113611,316408,914639,104621,1013293,710910,548910,916969,649975,811625,249372,93142,891430,742965,540479,481508,755790,949387,128146,77157,1036070,900731,492138,105200,762525,784992,969174,532846) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490491 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490491 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]