SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513447 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513447 [ RunTime:0.001937s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (357545,750027,147531,857116,123635,191118,469801,262270,198831,560958,57206,454387,604218,76985,991153,980765,495014,330053,337798,470175,728396,409962,36381,65901,268774,150537,556834,749005,2152,341732,495867,996254,894754,990593,353792,569108,752469,980226,596020,692386,1011419,62971,769781,384491,846748,724460,294366,405917,574095,163297,997243,660795,320938,459598,344694,29006,346702,861581,264665,530901) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513447 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513447 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]