SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107513 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107513 [ RunTime:0.002093s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (831470,102147,1032916,344637,123948,234118,798261,958822,720201,609301,787986,539672,801377,927016,1008161,924748,408695,192107,470047,647204,388802,912031,612224,450093,762029,147452,366290,808856,750822,760858,444527,242883,297330,1006687,144864,943347,810474,651204,783931,83771,274277,111704,948862,213903,148144,344654,742131,615479,1038180,815427,628336,832870,415350,193199,319137,852739,972600,289903,829848,423832) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]