SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001344s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 986293 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 986293 [ RunTime:0.001783s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (591984,236694,832449,654343,585404,379563,716295,567390,256961,756086,836271,502956,874859,339239,451534,145780,327254,646176,21098,446389,464789,285805,959668,19335,807958,574487,446950,761190,98265,871462,903729,200497,218310,976088,861644,221112,960891,881696,559934,441360,417472,426939,345108,953233,840289,351696,172968,435133,91463,96713,393737,707406,493942,737528,633776,104537,711825,201299,786139,686685) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 986293 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 986293 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]