SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521643 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521643 [ RunTime:0.001474s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (293711,504630,884072,729061,229691,1018579,267583,436062,821438,1037304,633647,127321,521214,692890,1037291,424874,686582,995595,224075,623091,960169,497718,865300,225831,368734,154050,892718,14779,274695,767631,934353,483721,218245,851187,341801,600399,348599,192088,1042275,388736,1032043,417093,749559,517218,954992,923914,681093,433133,452526,1038915,627618,782112,205367,298879,771777,434568,544703,707988,579904,543528) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]