SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475018 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475018 [ RunTime:0.001897s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (943945,250730,848278,456636,29028,910585,59030,822506,391473,347095,180020,627404,680026,557374,375316,580981,1010328,717243,851117,593042,455463,905286,389873,1027036,270831,584133,425773,777983,805133,768412,360265,373036,448247,1013424,494946,512243,850676,1042191,367537,288536,1003588,1044822,622656,783888,864881,594904,65734,168564,952993,736346,348579,970776,50862,692086,141608,596066,476172,133878,460477,27828) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]