SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407093 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407093 [ RunTime:0.001636s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (921461,355357,259699,446014,592719,198960,958912,46090,758161,911574,558523,391396,813515,53657,957787,1021489,863720,525471,180293,808084,246607,399830,811458,1036060,256849,449418,24528,140195,447268,156677,901409,86457,7853,928413,485946,648572,899526,690006,248650,784851,142363,226818,710135,316627,443701,62447,140489,307033,38211,799168,156810,852239,759183,650945,113984,997287,429362,67844,345557,857308) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000434s ]