SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001554s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 194806 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 194806 [ RunTime:0.001661s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (17914,40654,796537,772563,678124,375895,726889,183927,767042,727351,67859,1031770,691571,649949,422608,370742,900146,724592,48356,1023559,885027,175127,1008842,431290,244659,400998,204832,101099,919325,800928,1007704,898985,997936,430361,705054,914250,960041,769312,79154,816161,24919,878542,631190,4095,589584,908231,761698,388737,754528,607289,616716,543176,871227,142877,544733,541222,806079,1046342,734460,537502) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 194806 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 194806 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]