SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201634 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201634 [ RunTime:0.001460s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (897237,349769,366120,675128,400267,380372,453419,135737,976321,168703,259155,666273,201854,216516,272869,243579,375489,725751,729816,668132,181686,1009510,287929,619407,650953,358671,777397,496361,719656,901682,209148,430160,812202,324491,989814,531599,739084,851717,526330,2564,1044492,111526,720680,423988,538214,223742,202082,828349,720300,620529,250285,402909,784089,329184,847508,516170,473470,392121,427761,943741) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002666s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201634 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201634 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]