SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410277 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410277 [ RunTime:0.001547s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (708363,742836,677549,1048463,166068,594068,872380,268464,896990,170720,1013343,321145,721498,12796,210108,526000,765559,922017,211370,428571,577081,333081,991201,801191,572988,790688,496635,193611,483385,352459,997119,613765,775994,847954,468148,125651,572629,809358,602685,921427,840918,713320,669192,552700,1014624,835902,109125,518288,244141,941998,398245,854269,982138,391840,458239,415088,676512,374527,486115,250740) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410277 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410277 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]