SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001392s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 397415 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 397415 [ RunTime:0.001889s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (508630,331271,1039524,992845,97608,538070,658981,550628,93618,341429,697311,860388,272342,492410,442318,188309,406042,611891,259870,312806,510226,826007,1048787,69775,90929,406440,317553,121832,500941,19356,1048623,620649,585669,839724,883868,533514,261409,280290,1027052,901612,788765,789433,834156,137686,363220,74126,852190,432754,268870,874546,803508,22202,539699,121757,44349,980665,183029,462379,233073,140258) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 397415 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 397415 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]