SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 430721 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 430721 [ RunTime:0.001861s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1009846,754847,396785,424449,759705,1039502,866069,588522,467177,678910,280178,622480,554113,633842,119913,480218,102868,254504,801759,125129,110932,907420,500324,839320,585505,861727,890372,470899,914491,157123,108088,59111,985174,816353,431735,631844,494105,688529,760134,361910,714835,633023,613916,830884,699382,259782,750642,515389,866783,580837,431733,548703,285091,900171,200758,467147,766997,419684,521985,695338) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 430721 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 430721 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004901s ]