SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201817 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201817 [ RunTime:0.001884s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (247632,861291,979866,836890,279549,190792,290613,640055,810616,878352,401811,153077,1029221,776688,302842,174551,873763,138595,624385,268316,520963,628408,738897,1024416,1041737,118417,147400,352197,958473,223051,982388,840274,376545,425607,206766,744410,316924,605547,817129,728410,418850,835222,778025,979772,136717,203696,602477,319470,606194,847595,433727,166773,686547,487098,519511,724817,483801,50607,989643,705578) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201817 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201817 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000813s ]