SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 551092 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 551092 [ RunTime:0.001535s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509881,935449,784468,222018,896002,340975,635801,285446,798980,1028970,453589,749073,170562,993425,803036,47470,529023,111023,82978,525932,66392,293976,19986,687713,42693,662927,601019,932436,785442,972668,706992,683411,349819,606131,937296,703503,434554,455816,254351,403859,44131,481667,77909,197864,177474,544485,349172,857678,556783,891740,971438,294274,791344,701449,806574,1027229,618161,624750,137554,267115) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 551092 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 551092 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]