SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505887 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505887 [ RunTime:0.002619s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (957496,650100,689473,605053,1040279,227511,181868,599856,766126,86383,846558,1036274,1021941,53847,1037093,560533,913919,781359,784560,986689,749389,982550,836542,982549,717157,523749,1032731,375810,729438,1024647,76265,98090,212492,48009,17499,153422,140263,74828,551872,173090,654031,300128,410910,311663,902005,196072,900125,388266,132627,261736,257439,509475,903664,676268,198142,973225,837157,859938,211606,220126) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505887 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505887 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]