SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 748271 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 748271 [ RunTime:0.001790s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (261412,271047,165750,937910,895397,52618,366721,1010389,964463,885085,418401,1046188,423490,392586,506946,992324,200046,75390,74187,327978,905551,603416,588043,215212,516211,609404,130024,322512,530456,61736,564960,143832,1001794,571944,131744,933706,398310,794988,1033723,946216,841350,145083,578952,302491,787067,525619,449407,835212,855613,309950,220337,43500,887,940028,362071,563626,201329,884982,872035,50677) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 748271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 748271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]