SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 661940 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 661940 [ RunTime:0.002159s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (89579,891554,48470,457670,350328,225735,565491,1004038,603505,648651,926278,747559,289262,348430,297041,531474,565306,840280,251063,551764,926319,961598,974630,469679,226182,47229,448637,750355,110937,801279,676669,63257,639353,330296,50604,1027739,195326,187804,743959,1707,28164,628794,234492,335371,173260,860741,465526,1026100,778271,131947,313200,226572,860310,474740,705272,344485,505143,247048,419931,671025) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 661940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001806s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 661940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]