SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003094s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431010 LIMIT 1 [ RunTime:0.000499s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431010 [ RunTime:0.002837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201137,579664,116371,802165,632821,491835,696213,624332,157007,11080,443041,185590,733101,613660,725768,360119,240422,779748,318890,478459,715457,801618,23324,608901,517455,553419,375822,784520,148246,85769,466315,59960,777230,876527,581588,208069,1013403,728905,318054,252758,321673,988186,45508,433174,261545,247558,324066,404645,351645,883808,17073,880491,684199,280599,58909,114102,865390,558325,607461,809095) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001806s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001146s ]