SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037190 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037190 [ RunTime:0.002630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (265795,580949,678266,663029,954228,441172,235349,567942,541992,733283,824589,39283,501093,588448,7213,1011572,816078,644543,840946,466923,835970,520916,201468,258613,692700,1048197,109213,197246,459482,499491,680302,864024,316290,256371,43552,430836,415832,568993,563760,167250,160458,348251,515555,595981,909714,589253,812379,335739,609709,40192,292254,214817,393941,235490,122088,198624,325862,872946,919083,636121) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]