SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 349941 LIMIT 1 [ RunTime:0.000707s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 349941 [ RunTime:0.002914s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (411815,934008,665351,674252,786325,733304,693770,785511,194862,767203,907712,516748,190593,185439,545378,768910,434358,1012106,164066,287295,1012569,385145,89327,82013,112297,960457,143143,83279,162783,87768,784480,216298,142113,751678,219738,409398,76808,987487,329243,458546,675158,674964,62126,62003,383295,981396,241772,510667,455731,953406,672632,569294,537896,270873,517984,670287,301015,918081,58477,203780) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 349941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 349941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002110s ]