SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 831048 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 831048 [ RunTime:0.001943s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (301806,11216,953162,31825,436756,196632,951140,703482,602364,203124,151479,1023093,1008358,463308,173220,320078,512638,511956,481091,129699,1006032,572705,646357,399134,333722,291087,1014565,247803,759221,928314,586847,103503,767862,324670,130110,616194,775553,958895,209995,83299,86162,238737,238846,789450,433383,194626,39434,757153,273244,170420,217870,442240,592393,143140,962755,433944,290455,23415,366734,251471) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 831048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000802s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 831048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]