SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003328s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51614 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51614 [ RunTime:0.001930s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (285788,191758,729123,1043001,38095,237461,399405,951652,359150,162392,962302,297169,6046,681381,463913,877970,286292,556013,188911,927695,11754,242955,28826,627433,674432,783357,183320,205455,661148,497695,468947,266333,320243,853870,537037,663034,15321,173649,879000,725985,654932,544640,660314,285924,788696,74978,831604,707722,477810,989280,156046,1002990,119395,364452,191751,569099,562886,187243,682591,4847) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51614 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000713s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51614 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000652s ]