SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 809645 LIMIT 1 [ RunTime:0.001016s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 809645 [ RunTime:0.003785s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028390,796419,379360,1022391,419151,492489,677601,396189,213061,216649,820839,740838,326498,995033,667737,218940,221474,240496,338252,897232,391066,525193,255473,447925,806098,56729,416077,98098,559334,1019541,851801,865393,149631,760351,560827,97982,1016133,68984,147237,487627,949198,133900,271488,900003,970555,764176,696811,1030192,162983,308321,456415,799103,1014425,458649,418438,436625,21944,530679,9597,307668) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 809645 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 809645 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]