SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438189 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438189 [ RunTime:0.002438s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (517241,376359,957167,209734,673844,789278,470913,861928,81268,682307,1006101,792724,774216,961877,48437,842141,81384,735946,595963,628674,850929,846864,199312,656910,158693,221747,101056,901189,27315,782824,759289,152410,755557,718430,201002,952596,345726,15971,401967,177777,41493,359816,853787,217626,399382,1004119,1027802,122895,1007479,367982,608404,1002373,941826,183937,300419,844627,423892,520734,983027,700893) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001755s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438189 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438189 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]