SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001612s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418285 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418285 [ RunTime:0.002868s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (383533,717034,109406,492844,801413,720133,511059,318567,423696,777909,654470,690913,312073,139874,878689,284029,759988,490432,716703,622131,900863,741104,383765,217553,816413,391945,340180,900740,986974,830010,682017,636136,10365,34278,859379,318578,683457,79163,349485,819825,832074,783881,850024,173556,75873,1041303,979954,222393,548174,313322,663584,1025092,358298,810442,425014,41375,792470,204684,184779,171195) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418285 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418285 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000700s ]