SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428991 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428991 [ RunTime:0.001597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (450629,474491,1038377,747360,517068,296476,326497,697196,163874,250182,312255,800304,445235,654832,124932,137504,845218,238333,377092,904981,305872,142598,314631,32311,134162,60419,424666,789207,63584,151527,292156,197973,638701,605947,414700,534749,622418,782441,865963,175988,649794,1035323,509984,813866,656561,747835,40680,665284,367037,280901,646438,545257,745982,260283,618744,994095,331921,568834,464612,560575) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]