SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 142378 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 142378 [ RunTime:0.001556s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (586700,547127,1011006,129783,380951,460907,191202,173838,251878,275226,796769,882016,357563,442666,729390,675634,1039444,211841,560640,502088,368571,433784,403925,852537,874237,544705,350537,263410,35113,909761,608695,391918,609115,502843,1005352,613794,709907,562025,98056,427782,74370,428038,1044341,144960,695683,309127,290766,164049,414172,993054,529301,274807,500051,377130,714523,828978,386882,103194,518470,715689) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 142378 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 142378 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]