SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 392405 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 392405 [ RunTime:0.001880s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455891,836239,952155,448715,337509,402492,948755,448093,887507,35289,565072,957475,573493,194248,227792,314017,73226,642698,297309,872446,771470,149758,240965,21831,791471,991151,376999,31946,142657,724259,434936,236641,864916,348855,291413,1031513,237572,283271,569017,918525,243570,631034,971122,794712,70411,373485,521823,614322,973428,727956,934772,759084,777700,267772,17454,435715,525128,122148,598213,299073) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 392405 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 392405 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]