SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534161 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534161 [ RunTime:0.001692s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (680100,812858,734493,417679,847298,558461,149181,252069,199294,714213,734054,857225,186258,293275,386191,968545,1028102,819187,821941,877475,865183,505705,469769,573818,312789,122303,849194,330510,262870,7041,177227,895802,639092,376831,304694,179455,719438,113464,87719,150963,325280,658835,500612,100428,891540,425004,435004,790419,529333,902435,364541,550475,120127,170723,464949,671072,692271,755422,391511,626880) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534161 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534161 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000678s ]