SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568307 LIMIT 1 [ RunTime:0.000928s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568307 [ RunTime:0.001794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (821549,608638,294474,905950,525896,677719,898818,135059,438197,815124,232846,1031697,907868,117915,656020,913088,442107,529668,576558,232609,532904,111862,121794,268801,921264,289557,520555,307661,670973,914309,224738,981848,368480,189355,994542,209966,273690,582765,714892,309898,801359,339896,441618,633896,879227,949664,836173,362056,879512,394068,303305,521928,800031,147704,426573,821850,102386,42042,401817,331157) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568307 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568307 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]