SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547721 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547721 [ RunTime:0.001612s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (139311,755996,317739,1009772,505840,881456,164796,20792,399495,526465,892465,898735,972966,959852,468762,847828,455087,995729,459103,177272,934671,215985,253731,851248,335951,679759,2787,296202,287171,466895,249911,690754,95385,669943,424572,80566,462004,461601,404232,750971,810116,431673,609212,838418,657560,138866,693067,871897,417241,142836,539582,1020984,124157,805987,273302,177411,16325,1030244,347284,959539) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001785s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547721 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547721 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]